eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_BILLING_SETUP_PUB dependencies on PA_BILLING_SETUP_PUB

Line 1: PACKAGE BODY PA_BILLING_SETUP_PUB AS

1: PACKAGE BODY PA_BILLING_SETUP_PUB AS
2: /* $Header: PABLSTPB.pls 120.3 2005/08/19 16:16:42 mwasowic noship $ */
3:
4: G_PKG_NAME VARCHAR2(30) := 'PA_BILLING_SETUP_PUB';
5:

Line 4: G_PKG_NAME VARCHAR2(30) := 'PA_BILLING_SETUP_PUB';

1: PACKAGE BODY PA_BILLING_SETUP_PUB AS
2: /* $Header: PABLSTPB.pls 120.3 2005/08/19 16:16:42 mwasowic noship $ */
3:
4: G_PKG_NAME VARCHAR2(30) := 'PA_BILLING_SETUP_PUB';
5:
6: -- API name : update_revenue_and_billing
7: -- Type : Public procedure
8: -- Pre-reqs : None

Line 126: pa_debug.init_err_stack('PA_BILLING_SETUP_PUB.update_revenue_and_billing');

122: if (p_debug_mode = 'Y') then
123: pa_debug.debug('Update Revenue and Bill Info PUB : Initializing message stack.');
124: end if;
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;

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 426: pa_debug.init_err_stack('PA_BILLING_SETUP_PUB.update_revenue_and_billing');

422: if (p_debug_mode = 'Y') then
423: pa_debug.debug('Update Revenue and Bill Info PUB : Initializing message stack.');
424: end if;
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;

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 679: pa_debug.init_err_stack('PA_BILLING_SETUP_PUB.update_credit receivers');

675: if (p_debug_mode = 'Y') then
676: pa_debug.debug('Update credit receivers PUB : Initializing message stack.');
677: end if;
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;

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 921: pa_debug.init_err_stack('PA_BILLING_SETUP_PUB.Delete_credit receivers');

917: if (p_debug_mode = 'Y') then
918: pa_debug.debug('Delete credit receivers PUB : Initializing message stack.');
919: end if;
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;

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 1130: pa_debug.init_err_stack('PA_BILLING_SETUP_PUB.create_billing_assignments');

1126: if (p_debug_mode = 'Y') then
1127: pa_debug.debug('create_billing_assignments PUB : Initializing message stack.');
1128: end if;
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;

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 1338: pa_debug.init_err_stack('PA_BILLING_SETUP_PUB.update_billing_assignments');

1334: if (p_debug_mode = 'Y') then
1335: pa_debug.debug('update_billing_assignments PUB : Initializing message stack.');
1336: end if;
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;

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 1533: pa_debug.init_err_stack('PA_BILLING_SETUP_PUB.delete_billing_assignments');

1529: if (p_debug_mode = 'Y') then
1530: pa_debug.debug('delete_billing_assignments PUB : Initializing message stack.');
1531: end if;
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;

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;

Line 1623: END PA_BILLING_SETUP_PUB;

1619: p_error_text => SUBSTRB(SQLERRM,1,240));
1620: RAISE;
1621: END delete_billing_assignments;
1622:
1623: END PA_BILLING_SETUP_PUB;