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 1039: IF fnd_api.to_boolean(p_commit) THEN

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

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

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

Line 1124: IF fnd_api.to_boolean(p_init_msg_list) THEN

1120: RAISE lg_exc_unexpected_error;
1121: END IF;
1122:
1123: -- Initialize message list if p_init_msg_list is set to TRUE.
1124: IF fnd_api.to_boolean(p_init_msg_list) THEN
1125: fnd_msg_pub.initialize;
1126: END IF;
1127:
1128: -- Initialize API return status to success

Line 1338: IF fnd_api.to_boolean(p_commit) THEN

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

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

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

Line 1450: IF fnd_api.to_boolean(p_init_msg_list) THEN

1446: RAISE lg_exc_unexpected_error;
1447: END IF;
1448:
1449: -- Initialize message list if p_init_msg_list is set to TRUE.
1450: IF fnd_api.to_boolean(p_init_msg_list) THEN
1451: fnd_msg_pub.initialize;
1452: END IF;
1453:
1454: x_msg_count := 0;

Line 1577: IF fnd_api.to_boolean(p_commit) THEN

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

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

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

Line 1644: IF fnd_api.to_boolean(p_init_msg_list) THEN

1640: RAISE lg_exc_unexpected_error;
1641: END IF;
1642:
1643: -- Initialize message list if p_init_msg_list is set to TRUE.
1644: IF fnd_api.to_boolean(p_init_msg_list) THEN
1645: fnd_msg_pub.initialize;
1646: END IF;
1647:
1648: -- Initialize API return status to success

Line 1661: IF fnd_api.to_boolean(p_commit) THEN

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

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

2727: x_return_status := lg_ret_sts_success;
2728: SAVEPOINT save_update_genealogy;
2729: g_mod_name := 'update_Genealogy';
2730:
2731: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
2732: RAISE lg_exc_unexpected_error;
2733: END IF;
2734:
2735: IF (l_debug = 1) THEN

Line 2768: IF fnd_api.to_boolean(p_init_msg_list) THEN

2764: mydebug('p_parent_lot_control_code: ' || p_parent_lot_control_code );
2765: mydebug('p_transaction_type: ' || p_transaction_type );
2766: END IF;
2767:
2768: IF fnd_api.to_boolean(p_init_msg_list) THEN
2769: fnd_msg_pub.initialize;
2770: END IF;
2771:
2772: IF p_parent_object_type IS NULL THEN