APPS.PA_BILLING_SETUP_PVT dependencies on PA_BILLING_SETUP_PVT

Line 1: PACKAGE BODY PA_BILLING_SETUP_PVT AS

1: PACKAGE BODY PA_BILLING_SETUP_PVT AS
2: /* $Header: PABLSTVB.pls 120.3 2005/08/19 16:17:01 mwasowic noship $ */
3:
4:
5: -- API name : update_revenue_and_billing

Line 280: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_BILLING_SETUP_PVT',

276: THEN
277: ROLLBACK TO revenue_and_billing;
278: END IF;
279: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
280: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_BILLING_SETUP_PVT',
281: p_procedure_name => 'update_rev_and_billing',
282: p_error_text => SUBSTRB(SQLERRM,1,240));
283: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
284:

Line 298: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_BILLING_SETUP_PVT',

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

Line 503: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_BILLING_SETUP_PVT',

499: THEN
500: ROLLBACK TO credit_receivers;
501: END IF;
502: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
503: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_BILLING_SETUP_PVT',
504: p_procedure_name => 'CREATE_CREDIT_RECEIVERS',
505: p_error_text => SUBSTRB(SQLERRM,1,240));
506: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
507:

Line 525: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_BILLING_SETUP_PVT',

521: THEN
522: ROLLBACK TO credit_receivers;
523: END IF;
524: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
525: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_BILLING_SETUP_PVT',
526: p_procedure_name => 'CREATE_CREDIT_RECEIVERS',
527: p_error_text => SUBSTRB(SQLERRM,1,240));
528:
529: x_credit_receiver_id := null;

Line 783: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_BILLING_SETUP_PVT',

779: THEN
780: ROLLBACK TO credit_receivers;
781: END IF;
782: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
783: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_BILLING_SETUP_PVT',
784: p_procedure_name => 'UPDATE_CREDIT_RECEIVERS',
785: p_error_text => SUBSTRB(SQLERRM,1,240));
786: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
787:

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

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_PVT',
802: p_procedure_name => 'UPDATE_CREDIT_RECEIVERS',
803: p_error_text => SUBSTRB(SQLERRM,1,240));
804: RAISE;
805:

Line 972: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_BILLING_SETUP_PVT',

968: THEN
969: ROLLBACK TO credit_receivers;
970: END IF;
971: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
972: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_BILLING_SETUP_PVT',
973: p_procedure_name => 'delete_CREDIT_RECEIVERS',
974: p_error_text => SUBSTRB(SQLERRM,1,240));
975: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
976:

Line 990: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_BILLING_SETUP_PVT',

986: THEN
987: ROLLBACK TO credit_receivers;
988: END IF;
989: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
990: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_BILLING_SETUP_PVT',
991: p_procedure_name => 'delete_CREDIT_RECEIVERS',
992: p_error_text => SUBSTRB(SQLERRM,1,240));
993: RAISE;
994:

Line 1187: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_BILLING_SETUP_PVT',

1183: THEN
1184: ROLLBACK TO billing_assignments;
1185: END IF;
1186: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1187: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_BILLING_SETUP_PVT',
1188: p_procedure_name => 'CREATE_BILLING_ASSIGNMENTS',
1189: p_error_text => SUBSTRB(SQLERRM,1,240));
1190: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1191:

Line 1209: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_BILLING_SETUP_PVT',

1205: THEN
1206: ROLLBACK TO billing_assignments;
1207: END IF;
1208: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1209: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_BILLING_SETUP_PVT',
1210: p_procedure_name => 'CREATE_BILLING_ASSIGNMENTS',
1211: p_error_text => SUBSTRB(SQLERRM,1,240));
1212:
1213: x_billing_assignment_id := null;

Line 1440: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_BILLING_SETUP_PVT',

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

Line 1458: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_BILLING_SETUP_PVT',

1454: THEN
1455: ROLLBACK TO billing_assignments;
1456: END IF;
1457: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1458: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_BILLING_SETUP_PVT',
1459: p_procedure_name => 'UPDATE_BILLING_ASSIGNMENTS',
1460: p_error_text => SUBSTRB(SQLERRM,1,240));
1461: RAISE;
1462:

Line 1626: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_BILLING_SETUP_PVT',

1622: THEN
1623: ROLLBACK TO billing_assignments;
1624: END IF;
1625: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1626: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_BILLING_SETUP_PVT',
1627: p_procedure_name => 'DELETE_BILLING_ASSIGNMENTS',
1628: p_error_text => SUBSTRB(SQLERRM,1,240));
1629: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1630:

Line 1644: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_BILLING_SETUP_PVT',

1640: THEN
1641: ROLLBACK TO billing_assignments;
1642: END IF;
1643: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1644: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_BILLING_SETUP_PVT',
1645: p_procedure_name => 'DELETE_BILLING_ASSIGNMENTS',
1646: p_error_text => SUBSTRB(SQLERRM,1,240));
1647: RAISE;
1648:

Line 1651: END PA_BILLING_SETUP_PVT;

1647: RAISE;
1648:
1649: END delete_billing_assignments;
1650:
1651: END PA_BILLING_SETUP_PVT;