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 1038: -- Standard check of p_commit.

1034:
1035: IF (l_debug = 1) THEN mydebug( 'Inserted a New Record ' ); END IF;
1036:
1037: --End of API body.
1038: -- Standard check of p_commit.
1039: IF fnd_api.to_boolean(p_commit) THEN
1040: COMMIT WORK;
1041: IF (l_debug = 1) THEN mydebug( 'Commit work' ); END IF;
1042: END IF;

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

1040: COMMIT WORK;
1041: IF (l_debug = 1) THEN mydebug( 'Commit work' ); END IF;
1042: END IF;
1043:
1044: -- Standard call to get message count and if count is 1, get message info.
1045: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1046: ELSE
1047: IF (l_debug = 1) THEN mydebug( 'Record Already present ' ); END IF;
1048: END IF;

Line 1113: -- Standard Start of API savepoint

1109: l_parent_object_id NUMBER;
1110: l_parent_object_type NUMBER;
1111: l_debug NUMBER :=1 ; -- := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
1112: BEGIN
1113: -- Standard Start of API savepoint
1114: SAVEPOINT update_genealogy_pub;
1115:
1116: g_mod_name := 'Update Genealogy';
1117:

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

1114: SAVEPOINT update_genealogy_pub;
1115:
1116: g_mod_name := 'Update Genealogy';
1117:
1118: -- Standard call to check for call compatibility.
1119: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
1120: RAISE lg_exc_unexpected_error;
1121: END IF;
1122:

Line 1337: -- Standard check of p_commit.

1333: WHERE object_id = l_object_id
1334: AND end_date_active IS NULL;
1335:
1336: -- End of API body.
1337: -- Standard check of p_commit.
1338: IF fnd_api.to_boolean(p_commit) THEN
1339: COMMIT WORK;
1340: END IF;
1341:

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

1338: IF fnd_api.to_boolean(p_commit) THEN
1339: COMMIT WORK;
1340: END IF;
1341:
1342: -- Standard call to get message count and if count is 1, get message info.
1343: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1344: EXCEPTION
1345: WHEN lg_exc_error THEN
1346: ROLLBACK TO update_genealogy_pub;

Line 1441: -- Standard Start of API savepoint

1437: || ' p_start_date_active = ' || TO_CHAR(p_start_date_active, 'DD-MON-RRRR')
1438: || ' p_end_date_active = ' || TO_CHAR(p_end_date_active, 'DD-MON-RRRR') );
1439: END IF;
1440:
1441: -- Standard Start of API savepoint
1442: SAVEPOINT apiinsert_genealogy_apipub;
1443:
1444: -- Standard call to check for call compatibility.
1445: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN

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

1440:
1441: -- Standard Start of API savepoint
1442: SAVEPOINT apiinsert_genealogy_apipub;
1443:
1444: -- Standard call to check for call compatibility.
1445: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
1446: RAISE lg_exc_unexpected_error;
1447: END IF;
1448:

Line 1576: -- Standard check of p_commit.

1572:
1573: CLOSE childlotmmt;
1574: END IF;
1575:
1576: -- Standard check of p_commit.
1577: IF fnd_api.to_boolean(p_commit) THEN
1578: COMMIT WORK;
1579: END IF;
1580:

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

1577: IF fnd_api.to_boolean(p_commit) THEN
1578: COMMIT WORK;
1579: END IF;
1580:
1581: -- Standard call to get message count and if count is 1, get message info.
1582: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1583: EXCEPTION
1584: WHEN lg_exc_error THEN
1585: IF (l_debug = 1) THEN

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

1634: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name || '.' || l_api_name;
1635: BEGIN
1636: SAVEPOINT inv_eam_genealogy;
1637:
1638: -- Standard call to check for call compatibility.
1639: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
1640: RAISE lg_exc_unexpected_error;
1641: END IF;
1642:

Line 1660: -- Standard check of p_commit.

1656: and end_date_active = p_end_date_active
1657: and genealogy_type = 5;
1658:
1659: -- End of API body.
1660: -- Standard check of p_commit.
1661: IF fnd_api.to_boolean(p_commit) THEN
1662: COMMIT WORK;
1663: END IF;
1664:

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

1661: IF fnd_api.to_boolean(p_commit) THEN
1662: COMMIT WORK;
1663: END IF;
1664:
1665: -- Standard call to get message count and if count is 1, get message info.
1666: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1667: EXCEPTION
1668: WHEN lg_exc_error THEN
1669: ROLLBACK TO inv_eam_genealogy;

Line 1747: -- Standard Start of API savepoint

1743: l_parent_lot_control_code NUMBER;
1744: l_action VARCHAR2(10);
1745: BEGIN
1746: x_return_status := lg_ret_sts_success;
1747: -- Standard Start of API savepoint
1748: SAVEPOINT save_parameter_validations;
1749:
1750: g_mod_name := 'parameter_validations';
1751:

Line 2726: -- Standard Start of API savepoint

2722: l_return_status VARCHAR2(10);
2723: l_msg_count NUMBER;
2724: l_msg_data VARCHAR2(240);
2725: BEGIN
2726: -- Standard Start of API savepoint
2727: x_return_status := lg_ret_sts_success;
2728: SAVEPOINT save_update_genealogy;
2729: g_mod_name := 'update_Genealogy';
2730: