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 FND_API

Line 61: lg_fnd_g_false VARCHAR2(1) := FND_API.G_FALSE;

57: -- Global constant holding the package name
58: g_pkg_name CONSTANT VARCHAR2(30) := 'INV_genealogy_PUB';
59: g_mod_name VARCHAR2(30) := NULL;
60: --lg_fnd_validate_none CONSTANT NUMBER := 0;
61: lg_fnd_g_false VARCHAR2(1) := FND_API.G_FALSE;
62: lg_fnd_valid_level_full NUMBER := FND_API.G_VALID_LEVEL_FULL;
63:
64: lg_ret_sts_error CONSTANT VARCHAR2(30) := fnd_api.g_ret_sts_error;
65: lg_ret_sts_unexp_error CONSTANT VARCHAR2(30) := fnd_api.g_ret_sts_unexp_error;

Line 62: lg_fnd_valid_level_full NUMBER := FND_API.G_VALID_LEVEL_FULL;

58: g_pkg_name CONSTANT VARCHAR2(30) := 'INV_genealogy_PUB';
59: g_mod_name VARCHAR2(30) := NULL;
60: --lg_fnd_validate_none CONSTANT NUMBER := 0;
61: lg_fnd_g_false VARCHAR2(1) := FND_API.G_FALSE;
62: lg_fnd_valid_level_full NUMBER := FND_API.G_VALID_LEVEL_FULL;
63:
64: lg_ret_sts_error CONSTANT VARCHAR2(30) := fnd_api.g_ret_sts_error;
65: lg_ret_sts_unexp_error CONSTANT VARCHAR2(30) := fnd_api.g_ret_sts_unexp_error;
66: lg_ret_sts_success CONSTANT VARCHAR2(30) := fnd_api.g_ret_sts_success;

Line 64: lg_ret_sts_error CONSTANT VARCHAR2(30) := fnd_api.g_ret_sts_error;

60: --lg_fnd_validate_none CONSTANT NUMBER := 0;
61: lg_fnd_g_false VARCHAR2(1) := FND_API.G_FALSE;
62: lg_fnd_valid_level_full NUMBER := FND_API.G_VALID_LEVEL_FULL;
63:
64: lg_ret_sts_error CONSTANT VARCHAR2(30) := fnd_api.g_ret_sts_error;
65: lg_ret_sts_unexp_error CONSTANT VARCHAR2(30) := fnd_api.g_ret_sts_unexp_error;
66: lg_ret_sts_success CONSTANT VARCHAR2(30) := fnd_api.g_ret_sts_success;
67:
68: lg_exc_error EXCEPTION ; --fnd_api.g_exc_error;

Line 65: lg_ret_sts_unexp_error CONSTANT VARCHAR2(30) := fnd_api.g_ret_sts_unexp_error;

61: lg_fnd_g_false VARCHAR2(1) := FND_API.G_FALSE;
62: lg_fnd_valid_level_full NUMBER := FND_API.G_VALID_LEVEL_FULL;
63:
64: lg_ret_sts_error CONSTANT VARCHAR2(30) := fnd_api.g_ret_sts_error;
65: lg_ret_sts_unexp_error CONSTANT VARCHAR2(30) := fnd_api.g_ret_sts_unexp_error;
66: lg_ret_sts_success CONSTANT VARCHAR2(30) := fnd_api.g_ret_sts_success;
67:
68: lg_exc_error EXCEPTION ; --fnd_api.g_exc_error;
69: lg_exc_unexpected_error EXCEPTION ; --fnd_api.g_exc_unexpected_error;

Line 66: lg_ret_sts_success CONSTANT VARCHAR2(30) := fnd_api.g_ret_sts_success;

62: lg_fnd_valid_level_full NUMBER := FND_API.G_VALID_LEVEL_FULL;
63:
64: lg_ret_sts_error CONSTANT VARCHAR2(30) := fnd_api.g_ret_sts_error;
65: lg_ret_sts_unexp_error CONSTANT VARCHAR2(30) := fnd_api.g_ret_sts_unexp_error;
66: lg_ret_sts_success CONSTANT VARCHAR2(30) := fnd_api.g_ret_sts_success;
67:
68: lg_exc_error EXCEPTION ; --fnd_api.g_exc_error;
69: lg_exc_unexpected_error EXCEPTION ; --fnd_api.g_exc_unexpected_error;
70:

Line 68: lg_exc_error EXCEPTION ; --fnd_api.g_exc_error;

64: lg_ret_sts_error CONSTANT VARCHAR2(30) := fnd_api.g_ret_sts_error;
65: lg_ret_sts_unexp_error CONSTANT VARCHAR2(30) := fnd_api.g_ret_sts_unexp_error;
66: lg_ret_sts_success CONSTANT VARCHAR2(30) := fnd_api.g_ret_sts_success;
67:
68: lg_exc_error EXCEPTION ; --fnd_api.g_exc_error;
69: lg_exc_unexpected_error EXCEPTION ; --fnd_api.g_exc_unexpected_error;
70:
71:
72: -- R12 GEnealogy Enhancements :

Line 69: lg_exc_unexpected_error EXCEPTION ; --fnd_api.g_exc_unexpected_error;

65: lg_ret_sts_unexp_error CONSTANT VARCHAR2(30) := fnd_api.g_ret_sts_unexp_error;
66: lg_ret_sts_success CONSTANT VARCHAR2(30) := fnd_api.g_ret_sts_success;
67:
68: lg_exc_error EXCEPTION ; --fnd_api.g_exc_error;
69: lg_exc_unexpected_error EXCEPTION ; --fnd_api.g_exc_unexpected_error;
70:
71:
72: -- R12 GEnealogy Enhancements :
73: -- Local prtocedure to validate input parameters passed to Insert-genealogy or

Line 395: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN

391: x_return_status := lg_ret_sts_success;
392: SAVEPOINT save_insert_genealogy;
393: g_mod_name := 'Insert_Genealogy';
394:
395: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
396: RAISE lg_exc_unexpected_error;
397: END IF;
398:
399: IF (l_debug = 1) THEN

Line 431: IF fnd_api.to_boolean(p_init_msg_list) THEN

427: mydebug('p_child_lot_control_code: ' || p_child_lot_control_code );
428: mydebug('p_parent_lot_control_code: ' || p_parent_lot_control_code );
429: END IF;
430:
431: IF fnd_api.to_boolean(p_init_msg_list) THEN
432: fnd_msg_pub.initialize;
433: END IF;
434:
435: -- Initialize API return status to success

Line 1022: IF fnd_api.to_boolean(p_commit) THEN

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;
1026:

Line 1099: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN

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:
1103: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 1104: IF fnd_api.to_boolean(p_init_msg_list) THEN

1100: RAISE lg_exc_unexpected_error;
1101: END IF;
1102:
1103: -- Initialize message list if p_init_msg_list is set to TRUE.
1104: IF fnd_api.to_boolean(p_init_msg_list) THEN
1105: fnd_msg_pub.initialize;
1106: END IF;
1107:
1108: -- Initialize API return status to success

Line 1318: IF fnd_api.to_boolean(p_commit) THEN

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:
1322: -- Standard call to get message count and if count is 1, get message info.

Line 1425: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN

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:
1429: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 1430: IF fnd_api.to_boolean(p_init_msg_list) THEN

1426: RAISE lg_exc_unexpected_error;
1427: END IF;
1428:
1429: -- Initialize message list if p_init_msg_list is set to TRUE.
1430: IF fnd_api.to_boolean(p_init_msg_list) THEN
1431: fnd_msg_pub.initialize;
1432: END IF;
1433:
1434: x_msg_count := 0;

Line 1557: IF fnd_api.to_boolean(p_commit) THEN

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:
1561: -- Standard call to get message count and if count is 1, get message info.

Line 1616: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN

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:
1620: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 1621: IF fnd_api.to_boolean(p_init_msg_list) THEN

1617: RAISE lg_exc_unexpected_error;
1618: END IF;
1619:
1620: -- Initialize message list if p_init_msg_list is set to TRUE.
1621: IF fnd_api.to_boolean(p_init_msg_list) THEN
1622: fnd_msg_pub.initialize;
1623: END IF;
1624:
1625: -- Initialize API return status to success

Line 1638: IF fnd_api.to_boolean(p_commit) THEN

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:
1642: -- Standard call to get message count and if count is 1, get message info.

Line 2708: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN

2704: x_return_status := lg_ret_sts_success;
2705: SAVEPOINT save_update_genealogy;
2706: g_mod_name := 'update_Genealogy';
2707:
2708: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
2709: RAISE lg_exc_unexpected_error;
2710: END IF;
2711:
2712: IF (l_debug = 1) THEN

Line 2745: IF fnd_api.to_boolean(p_init_msg_list) THEN

2741: mydebug('p_parent_lot_control_code: ' || p_parent_lot_control_code );
2742: mydebug('p_transaction_type: ' || p_transaction_type );
2743: END IF;
2744:
2745: IF fnd_api.to_boolean(p_init_msg_list) THEN
2746: fnd_msg_pub.initialize;
2747: END IF;
2748:
2749: IF p_parent_object_type IS NULL THEN