DBA Data[Home] [Help]

APPS.PA_BILLING_SETUP_PVT dependencies on FND_MSG_PUB

Line 239: l_msg_count := FND_MSG_PUB.count_msg;

235: x_return_status := 'E' ;
236: END IF;
237: END;
238: END IF;
239: l_msg_count := FND_MSG_PUB.count_msg;
240:
241: IF l_msg_count > 0 THEN
242: x_msg_count := l_msg_count;
243: x_return_status := 'E';

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 734: l_msg_count := FND_MSG_PUB.count_msg;

730: x_return_status := 'E' ;
731: END IF;
732: END;
733: end if;
734: l_msg_count := FND_MSG_PUB.count_msg;
735:
736: IF l_msg_count > 0 THEN
737: x_msg_count := l_msg_count;
738: x_return_status := 'E';

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 953: l_msg_count := FND_MSG_PUB.count_msg;

949: x_return_status := 'E' ;
950: END IF;
951: END;
952: end if;
953: l_msg_count := FND_MSG_PUB.count_msg;
954:
955: IF l_msg_count > 0 THEN
956: x_msg_count := l_msg_count;
957: x_return_status := 'E';

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 1395: l_msg_count := FND_MSG_PUB.count_msg;

1391: x_return_status := 'E' ;
1392: END IF;
1393: END;
1394: end if;
1395: l_msg_count := FND_MSG_PUB.count_msg;
1396:
1397: IF l_msg_count > 0 THEN
1398: x_msg_count := l_msg_count;
1399: x_return_status := 'E';

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 1605: l_msg_count := FND_MSG_PUB.count_msg;

1601: x_return_status := 'E' ;
1602: END IF;
1603: END;
1604: end if;
1605: l_msg_count := FND_MSG_PUB.count_msg;
1606:
1607: IF l_msg_count > 0 THEN
1608: x_msg_count := l_msg_count;
1609: x_return_status := 'E';

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: