DBA Data[Home] [Help]

APPS.PA_BILLING_SETUP_PUB dependencies on FND_MSG_PUB

Line 129: fnd_msg_pub.initialize;

125:
126: pa_debug.init_err_stack('PA_BILLING_SETUP_PUB.update_revenue_and_billing');
127:
128: if FND_API.to_boolean(nvl(p_init_msg_list, FND_API.G_FALSE)) then
129: fnd_msg_pub.initialize;
130: end if;
131:
132: x_return_status := 'S';
133:

Line 271: l_msg_count := FND_MSG_PUB.count_msg;

267:
268: if (p_debug_mode = 'Y') then
269: pa_debug.debug('Update reve and Bill Info PUB : checking message count');
270: end if;
271: l_msg_count := FND_MSG_PUB.count_msg;
272: If l_msg_count > 0 THEN
273: x_msg_count := l_msg_count;
274: If l_msg_count = 1 THEN
275: pa_interface_utils_pub.get_messages

Line 299: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_BILLING_SETUP_PUB',

295: THEN
296: ROLLBACK TO revenue_and_billing;
297: END IF;
298: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
299: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_BILLING_SETUP_PUB',
300: p_procedure_name => 'update_revenue_and_Billing',
301: p_error_text => SUBSTRB(SQLERRM,1,240));
302: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
303:

Line 317: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_BILLING_SETUP_PUB',

313: THEN
314: ROLLBACK TO revenue_and_billing;
315: END IF;
316: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
317: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_BILLING_SETUP_PUB',
318: p_procedure_name => 'update_revenue_and_Billing',
319: p_error_text => SUBSTRB(SQLERRM,1,240));
320: RAISE;
321:

Line 429: fnd_msg_pub.initialize;

425:
426: pa_debug.init_err_stack('PA_BILLING_SETUP_PUB.update_revenue_and_billing');
427:
428: if FND_API.to_boolean(nvl(p_init_msg_list, FND_API.G_FALSE)) then
429: fnd_msg_pub.initialize;
430: end if;
431:
432: x_return_status := 'S';
433:

Line 518: l_msg_count := FND_MSG_PUB.count_msg;

514:
515: if (p_debug_mode = 'Y') then
516: pa_debug.debug('CREATE CREDIT RECEIVERS PUB : checking message count');
517: end if;
518: l_msg_count := FND_MSG_PUB.count_msg;
519: If l_msg_count > 0 THEN
520: x_msg_count := l_msg_count;
521: If l_msg_count = 1 THEN
522: pa_interface_utils_pub.get_messages

Line 546: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_BILLING_SETUP_PUB',

542: THEN
543: ROLLBACK TO credit_receivers;
544: END IF;
545: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
546: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_BILLING_SETUP_PUB',
547: p_procedure_name => 'CREATE_CREDIT_RECEIVERS',
548: p_error_text => SUBSTRB(SQLERRM,1,240));
549: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
550:

Line 568: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_BILLING_SETUP_PUB',

564: THEN
565: ROLLBACK TO credit_receivers;
566: END IF;
567: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
568: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_BILLING_SETUP_PUB',
569: p_procedure_name => 'CREATE_CREDIT_RECEIVERS',
570: p_error_text => SUBSTRB(SQLERRM,1,240));
571:
572: x_credit_receiver_id := null;

Line 682: fnd_msg_pub.initialize;

678:
679: pa_debug.init_err_stack('PA_BILLING_SETUP_PUB.update_credit receivers');
680:
681: if FND_API.to_boolean(nvl(p_init_msg_list, FND_API.G_FALSE)) then
682: fnd_msg_pub.initialize;
683: end if;
684:
685: x_return_status := 'S';
686:

Line 773: l_msg_count := FND_MSG_PUB.count_msg;

769: if (p_debug_mode = 'Y') then
770: pa_debug.debug('UPDATE CREDIT RECEIVERS PUB : checking message count');
771: end if;
772:
773: l_msg_count := FND_MSG_PUB.count_msg;
774: If l_msg_count > 0 THEN
775: x_msg_count := l_msg_count;
776: If l_msg_count = 1 THEN
777: pa_interface_utils_pub.get_messages

Line 801: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_BILLING_SETUP_PUB',

797: THEN
798: ROLLBACK TO credit_receivers;
799: END IF;
800: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
801: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_BILLING_SETUP_PUB',
802: p_procedure_name => 'UPDATE_CREDIT_RECEIVERS',
803: p_error_text => SUBSTRB(SQLERRM,1,240));
804: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
805:

Line 819: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_BILLING_SETUP_PUB',

815: THEN
816: ROLLBACK TO credit_receivers;
817: END IF;
818: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
819: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_BILLING_SETUP_PUB',
820: p_procedure_name => 'UPDATE_CREDIT_RECEIVERS',
821: p_error_text => SUBSTRB(SQLERRM,1,240));
822: RAISE;
823:

Line 924: fnd_msg_pub.initialize;

920:
921: pa_debug.init_err_stack('PA_BILLING_SETUP_PUB.Delete_credit receivers');
922:
923: if FND_API.to_boolean(nvl(p_init_msg_list, FND_API.G_FALSE)) then
924: fnd_msg_pub.initialize;
925: end if;
926:
927: x_return_status := 'S';
928:

Line 986: l_msg_count := FND_MSG_PUB.count_msg;

982:
983: if (p_debug_mode = 'Y') then
984: pa_debug.debug('DELETE CREDIT RECEIVERS PUB : checking message count');
985: end if;
986: l_msg_count := FND_MSG_PUB.count_msg;
987: If l_msg_count > 0 THEN
988: x_msg_count := l_msg_count;
989: If l_msg_count = 1 THEN
990: pa_interface_utils_pub.get_messages

Line 1014: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_BILLING_SETUP_PUB',

1010: THEN
1011: ROLLBACK TO credit_receivers;
1012: END IF;
1013: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1014: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_BILLING_SETUP_PUB',
1015: p_procedure_name => 'DELETE_CREDIT_RECEIVERS',
1016: p_error_text => SUBSTRB(SQLERRM,1,240));
1017: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1018:

Line 1032: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_BILLING_SETUP_PUB',

1028: THEN
1029: ROLLBACK TO credit_receivers;
1030: END IF;
1031: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1032: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_BILLING_SETUP_PUB',
1033: p_procedure_name => 'DELETE_CREDIT_RECEIVERS',
1034: p_error_text => SUBSTRB(SQLERRM,1,240));
1035: RAISE;
1036: END delete_credit_receivers;

Line 1133: fnd_msg_pub.initialize;

1129:
1130: pa_debug.init_err_stack('PA_BILLING_SETUP_PUB.create_billing_assignments');
1131:
1132: if FND_API.to_boolean(nvl(p_init_msg_list, FND_API.G_FALSE)) then
1133: fnd_msg_pub.initialize;
1134: end if;
1135:
1136: x_return_status := 'S';
1137:

Line 1184: l_msg_count := FND_MSG_PUB.count_msg;

1180:
1181: if (p_debug_mode = 'Y') then
1182: pa_debug.debug('CREATEE BILLING ASSIGNMENTS PUB : checking message count');
1183: end if;
1184: l_msg_count := FND_MSG_PUB.count_msg;
1185: If l_msg_count > 0 THEN
1186: x_msg_count := l_msg_count;
1187: If l_msg_count = 1 THEN
1188: pa_interface_utils_pub.get_messages

Line 1212: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_BILLING_SETUP_PUB',

1208: THEN
1209: ROLLBACK TO billing_assignments;
1210: END IF;
1211: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1212: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_BILLING_SETUP_PUB',
1213: p_procedure_name => 'create_billing_assignments',
1214: p_error_text => SUBSTRB(SQLERRM,1,240));
1215: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1216:

Line 1234: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_BILLING_SETUP_PUB',

1230: THEN
1231: ROLLBACK TO billing_assignments;
1232: END IF;
1233: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1234: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_BILLING_SETUP_PUB',
1235: p_procedure_name => 'create_billing_assignments',
1236: p_error_text => SUBSTRB(SQLERRM,1,240));
1237:
1238: x_billing_assignment_id := null;

Line 1341: fnd_msg_pub.initialize;

1337:
1338: pa_debug.init_err_stack('PA_BILLING_SETUP_PUB.update_billing_assignments');
1339:
1340: if FND_API.to_boolean(nvl(p_init_msg_list, FND_API.G_FALSE)) then
1341: fnd_msg_pub.initialize;
1342: end if;
1343:
1344: x_return_status := 'S';
1345:

Line 1393: l_msg_count := FND_MSG_PUB.count_msg;

1389:
1390: if (p_debug_mode = 'Y') then
1391: pa_debug.debug('UPDATE BILLING ASSIGNMENTS PUB : checking message count');
1392: end if;
1393: l_msg_count := FND_MSG_PUB.count_msg;
1394: If l_msg_count > 0 THEN
1395: x_msg_count := l_msg_count;
1396: If l_msg_count = 1 THEN
1397: pa_interface_utils_pub.get_messages

Line 1421: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_BILLING_SETUP_PUB',

1417: THEN
1418: ROLLBACK TO billing_assignments;
1419: END IF;
1420: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1421: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_BILLING_SETUP_PUB',
1422: p_procedure_name => 'update_billing_assignments',
1423: p_error_text => SUBSTRB(SQLERRM,1,240));
1424: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1425:

Line 1439: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_BILLING_SETUP_PUB',

1435: THEN
1436: ROLLBACK TO billing_assignments;
1437: END IF;
1438: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1439: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_BILLING_SETUP_PUB',
1440: p_procedure_name => 'update_billing_assignments',
1441: p_error_text => SUBSTRB(SQLERRM,1,240));
1442: RAISE;
1443: END update_billing_assignments;

Line 1536: fnd_msg_pub.initialize;

1532:
1533: pa_debug.init_err_stack('PA_BILLING_SETUP_PUB.delete_billing_assignments');
1534:
1535: if FND_API.to_boolean(nvl(p_init_msg_list, FND_API.G_FALSE)) then
1536: fnd_msg_pub.initialize;
1537: end if;
1538:
1539: x_return_status := 'S';
1540:

Line 1571: l_msg_count := FND_MSG_PUB.count_msg;

1567:
1568: if (p_debug_mode = 'Y') then
1569: pa_debug.debug('DELETE BILLING ASSIGNMENTS PUB : checking message count');
1570: end if;
1571: l_msg_count := FND_MSG_PUB.count_msg;
1572: If l_msg_count > 0 THEN
1573: x_msg_count := l_msg_count;
1574: If l_msg_count = 1 THEN
1575: pa_interface_utils_pub.get_messages

Line 1599: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_BILLING_SETUP_PUB',

1595: THEN
1596: ROLLBACK TO billing_assignments;
1597: END IF;
1598: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1599: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_BILLING_SETUP_PUB',
1600: p_procedure_name => 'delete_billing_assignments',
1601: p_error_text => SUBSTRB(SQLERRM,1,240));
1602: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1603:

Line 1617: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_BILLING_SETUP_PUB',

1613: THEN
1614: ROLLBACK TO billing_assignments;
1615: END IF;
1616: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1617: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_BILLING_SETUP_PUB',
1618: p_procedure_name => 'delete_billing_assignments',
1619: p_error_text => SUBSTRB(SQLERRM,1,240));
1620: RAISE;
1621: END delete_billing_assignments;