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.INV_GENEALOGY_PUB dependencies on STANDARD

Line 390: -- Standard Start of API savepoint

386: l_return_status VARCHAR2(10);
387: l_msg_count NUMBER;
388: l_msg_data VARCHAR2(4000);
389: BEGIN
390: -- Standard Start of API savepoint
391: x_return_status := lg_ret_sts_success;
392: SAVEPOINT save_insert_genealogy;
393: g_mod_name := 'Insert_Genealogy';
394:

Line 1021: -- Standard check of p_commit.

1017:
1018: IF (l_debug = 1) THEN mydebug( 'Inserted a New Record ' ); END IF;
1019:
1020: --End of API body.
1021: -- Standard check of p_commit.
1022: IF fnd_api.to_boolean(p_commit) THEN
1023: COMMIT WORK;
1024: IF (l_debug = 1) THEN mydebug( 'Commit work' ); END IF;
1025: END IF;

Line 1027: -- Standard call to get message count and if count is 1, get message info.

1023: COMMIT WORK;
1024: IF (l_debug = 1) THEN mydebug( 'Commit work' ); END IF;
1025: END IF;
1026:
1027: -- Standard call to get message count and if count is 1, get message info.
1028: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1029: ELSE
1030: IF (l_debug = 1) THEN mydebug( 'Record Already present ' ); END IF;
1031: END IF;

Line 1093: -- Standard Start of API savepoint

1089: l_parent_object_id NUMBER;
1090: l_parent_object_type NUMBER;
1091: l_debug NUMBER :=1 ; -- := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
1092: BEGIN
1093: -- Standard Start of API savepoint
1094: SAVEPOINT update_genealogy_pub;
1095:
1096: g_mod_name := 'Update Genealogy';
1097:

Line 1098: -- Standard call to check for call compatibility.

1094: SAVEPOINT update_genealogy_pub;
1095:
1096: g_mod_name := 'Update Genealogy';
1097:
1098: -- Standard call to check for call compatibility.
1099: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
1100: RAISE lg_exc_unexpected_error;
1101: END IF;
1102:

Line 1317: -- Standard check of p_commit.

1313: WHERE object_id = l_object_id
1314: AND end_date_active IS NULL;
1315:
1316: -- End of API body.
1317: -- Standard check of p_commit.
1318: IF fnd_api.to_boolean(p_commit) THEN
1319: COMMIT WORK;
1320: END IF;
1321:

Line 1322: -- Standard call to get message count and if count is 1, get message info.

1318: IF fnd_api.to_boolean(p_commit) THEN
1319: COMMIT WORK;
1320: END IF;
1321:
1322: -- Standard call to get message count and if count is 1, get message info.
1323: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1324: EXCEPTION
1325: WHEN lg_exc_error THEN
1326: ROLLBACK TO update_genealogy_pub;

Line 1421: -- Standard Start of API savepoint

1417: || ' p_start_date_active = ' || TO_CHAR(p_start_date_active, 'DD-MON-RRRR')
1418: || ' p_end_date_active = ' || TO_CHAR(p_end_date_active, 'DD-MON-RRRR') );
1419: END IF;
1420:
1421: -- Standard Start of API savepoint
1422: SAVEPOINT apiinsert_genealogy_apipub;
1423:
1424: -- Standard call to check for call compatibility.
1425: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN

Line 1424: -- Standard call to check for call compatibility.

1420:
1421: -- Standard Start of API savepoint
1422: SAVEPOINT apiinsert_genealogy_apipub;
1423:
1424: -- Standard call to check for call compatibility.
1425: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
1426: RAISE lg_exc_unexpected_error;
1427: END IF;
1428:

Line 1556: -- Standard check of p_commit.

1552:
1553: CLOSE childlotmmt;
1554: END IF;
1555:
1556: -- Standard check of p_commit.
1557: IF fnd_api.to_boolean(p_commit) THEN
1558: COMMIT WORK;
1559: END IF;
1560:

Line 1561: -- Standard call to get message count and if count is 1, get message info.

1557: IF fnd_api.to_boolean(p_commit) THEN
1558: COMMIT WORK;
1559: END IF;
1560:
1561: -- Standard call to get message count and if count is 1, get message info.
1562: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1563: EXCEPTION
1564: WHEN lg_exc_error THEN
1565: IF (l_debug = 1) THEN

Line 1615: -- Standard call to check for call compatibility.

1611: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name || '.' || l_api_name;
1612: BEGIN
1613: SAVEPOINT inv_eam_genealogy;
1614:
1615: -- Standard call to check for call compatibility.
1616: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
1617: RAISE lg_exc_unexpected_error;
1618: END IF;
1619:

Line 1637: -- Standard check of p_commit.

1633: and end_date_active = p_end_date_active
1634: and genealogy_type = 5;
1635:
1636: -- End of API body.
1637: -- Standard check of p_commit.
1638: IF fnd_api.to_boolean(p_commit) THEN
1639: COMMIT WORK;
1640: END IF;
1641:

Line 1642: -- Standard call to get message count and if count is 1, get message info.

1638: IF fnd_api.to_boolean(p_commit) THEN
1639: COMMIT WORK;
1640: END IF;
1641:
1642: -- Standard call to get message count and if count is 1, get message info.
1643: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1644: EXCEPTION
1645: WHEN lg_exc_error THEN
1646: ROLLBACK TO inv_eam_genealogy;

Line 1724: -- Standard Start of API savepoint

1720: l_parent_lot_control_code NUMBER;
1721: l_action VARCHAR2(10);
1722: BEGIN
1723: x_return_status := lg_ret_sts_success;
1724: -- Standard Start of API savepoint
1725: SAVEPOINT save_parameter_validations;
1726:
1727: g_mod_name := 'parameter_validations';
1728:

Line 2703: -- Standard Start of API savepoint

2699: l_return_status VARCHAR2(10);
2700: l_msg_count NUMBER;
2701: l_msg_data VARCHAR2(240);
2702: BEGIN
2703: -- Standard Start of API savepoint
2704: x_return_status := lg_ret_sts_success;
2705: SAVEPOINT save_update_genealogy;
2706: g_mod_name := 'update_Genealogy';
2707: