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.AMS_ASSOCIATIONS_PVT dependencies on AMS_UTILITY_PVT

Line 99: AMS_Utility_PVT.debug_message(l_full_name||': start');

95: IF (AMS_DEBUG_HIGH_ON) THEN
96:
97:
98:
99: AMS_Utility_PVT.debug_message(l_full_name||': start');
100:
101: END IF;
102:
103: IF FND_API.to_boolean(p_init_msg_list) THEN

Line 121: AMS_Utility_PVT.debug_message(l_full_name ||': validate');

117:
118: ----------------------- validate -----------------------
119: IF (AMS_DEBUG_HIGH_ON) THEN
120:
121: AMS_Utility_PVT.debug_message(l_full_name ||': validate');
122: END IF;
123:
124: validate_association(
125: p_api_version => l_api_version,

Line 217: AMS_Utility_PVT.debug_message(l_full_name ||': insert');

213: ------------------------------------------------------
214: -------------------------- insert --------------------------
215: IF (AMS_DEBUG_HIGH_ON) THEN
216:
217: AMS_Utility_PVT.debug_message(l_full_name ||': insert');
218: END IF;
219:
220: IF l_association_rec.object_association_id IS NULL THEN
221: LOOP

Line 373: AMS_Utility_PVT.debug_message(l_full_name ||': end');

369: IF (AMS_DEBUG_HIGH_ON) THEN
370:
371:
372:
373: AMS_Utility_PVT.debug_message(l_full_name ||': end');
374:
375: END IF;
376:
377: EXCEPTION

Line 487: AMS_Utility_PVT.debug_message(l_full_name||': start');

483: IF (AMS_DEBUG_HIGH_ON) THEN
484:
485:
486:
487: AMS_Utility_PVT.debug_message(l_full_name||': start');
488:
489: END IF;
490:
491: IF FND_API.to_boolean(p_init_msg_list) THEN

Line 531: AMS_Utility_PVT.debug_message(l_full_name ||': delete');

527:
528: ------------------------ delete ------------------------
529: IF (AMS_DEBUG_HIGH_ON) THEN
530:
531: AMS_Utility_PVT.debug_message(l_full_name ||': delete');
532: END IF;
533:
534: OPEN get_objattr_info(l_c_obj_id);
535: FETCH get_objattr_info into l_attr, l_object_type, l_object_id;

Line 617: AMS_Utility_PVT.debug_message(l_full_name ||': end');

613: IF (AMS_DEBUG_HIGH_ON) THEN
614:
615:
616:
617: AMS_Utility_PVT.debug_message(l_full_name ||': end');
618:
619: END IF;
620:
621: EXCEPTION

Line 698: AMS_Utility_PVT.debug_message(l_full_name||': start');

694:
695: -------------------- initialize ------------------------
696: IF (AMS_DEBUG_HIGH_ON) THEN
697:
698: AMS_Utility_PVT.debug_message(l_full_name||': start');
699: END IF;
700:
701: IF FND_API.to_boolean(p_init_msg_list) THEN
702: FND_MSG_PUB.initialize;

Line 719: AMS_Utility_PVT.debug_message(l_full_name||': lock');

715:
716: ------------------------ lock -------------------------
717: IF (AMS_DEBUG_HIGH_ON) THEN
718:
719: AMS_Utility_PVT.debug_message(l_full_name||': lock');
720: END IF;
721:
722: OPEN c_association_b;
723: FETCH c_association_b INTO l_object_association_id;

Line 744: AMS_Utility_PVT.debug_message(l_full_name ||': end');

740: IF (AMS_DEBUG_HIGH_ON) THEN
741:
742:
743:
744: AMS_Utility_PVT.debug_message(l_full_name ||': end');
745:
746: END IF;
747:
748: EXCEPTION

Line 750: WHEN AMS_Utility_PVT.resource_locked THEN

746: END IF;
747:
748: EXCEPTION
749:
750: WHEN AMS_Utility_PVT.resource_locked THEN
751: x_return_status := FND_API.g_ret_sts_error;
752: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
753: FND_MESSAGE.set_name('AMS', 'AMS_API_RESOURCE_LOCKED');
754: FND_MSG_PUB.add;

Line 839: AMS_Utility_PVT.debug_message(l_full_name||': start');

835: IF (AMS_DEBUG_HIGH_ON) THEN
836:
837:
838:
839: AMS_Utility_PVT.debug_message(l_full_name||': start');
840:
841: END IF;
842:
843: IF FND_API.to_boolean(p_init_msg_list) THEN

Line 864: AMS_Utility_PVT.debug_message(l_full_name ||': validate');

860:
861: ----------------------- validate ----------------------
862: IF (AMS_DEBUG_HIGH_ON) THEN
863:
864: AMS_Utility_PVT.debug_message(l_full_name ||': validate');
865: END IF;
866:
867: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
868: check_association_items(

Line 914: AMS_Utility_PVT.debug_message(l_full_name ||': update');

910: END IF ;
911: -------------------------- update --------------------
912: IF (AMS_DEBUG_HIGH_ON) THEN
913:
914: AMS_Utility_PVT.debug_message(l_full_name ||': update');
915: END IF;
916:
917: UPDATE ams_object_associations SET
918: last_update_date = SYSDATE,

Line 980: AMS_Utility_PVT.debug_message(l_full_name ||': end');

976: IF (AMS_DEBUG_HIGH_ON) THEN
977:
978:
979:
980: AMS_Utility_PVT.debug_message(l_full_name ||': end');
981:
982: END IF;
983:
984: EXCEPTION

Line 1050: AMS_Utility_PVT.debug_message(l_full_name||': start');

1046:
1047: ----------------------- initialize --------------------
1048: IF (AMS_DEBUG_HIGH_ON) THEN
1049:
1050: AMS_Utility_PVT.debug_message(l_full_name||': start');
1051: END IF;
1052:
1053: IF FND_API.to_boolean(p_init_msg_list) THEN
1054: FND_MSG_PUB.initialize;

Line 1071: AMS_Utility_PVT.debug_message(l_full_name||': check items');

1067:
1068: ---------------------- validate ------------------------
1069: IF (AMS_DEBUG_HIGH_ON) THEN
1070:
1071: AMS_Utility_PVT.debug_message(l_full_name||': check items');
1072: END IF;
1073:
1074: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
1075: check_association_items(

Line 1092: AMS_Utility_PVT.debug_message(l_full_name||': check record');

1088: IF (AMS_DEBUG_HIGH_ON) THEN
1089:
1090:
1091:
1092: AMS_Utility_PVT.debug_message(l_full_name||': check record');
1093:
1094: END IF;
1095:
1096: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_record THEN

Line 1120: AMS_Utility_PVT.debug_message(l_full_name ||': end');

1116: IF (AMS_DEBUG_HIGH_ON) THEN
1117:
1118:
1119:
1120: AMS_Utility_PVT.debug_message(l_full_name ||': end');
1121:
1122: END IF;
1123:
1124: EXCEPTION

Line 1198: IF AMS_Utility_PVT.check_fk_exists(

1194: return FND_API.g_false;
1195: END IF;
1196: -- call fk utility to check master....will call again later to check for using..
1197:
1198: IF AMS_Utility_PVT.check_fk_exists(
1199: l_foreign_table,
1200: l_foreign_table_id,
1201: p_master_id
1202: ) = FND_API.g_false

Line 1234: IF AMS_Utility_PVT.check_fk_exists(

1230: ELSE
1231: return FND_API.g_false;
1232: END IF;
1233:
1234: IF AMS_Utility_PVT.check_fk_exists(
1235: l_foreign_table,
1236: l_foreign_table_id,
1237: p_using_id
1238: ) = FND_API.g_false

Line 1368: IF AMS_Utility_PVT.check_uniqueness(

1364: --
1365: IF p_validation_mode = JTF_PLSQL_API.g_create
1366: AND p_association_rec.object_association_id IS NOT NULL
1367: THEN
1368: IF AMS_Utility_PVT.check_uniqueness(
1369: 'ams_object_associations',
1370: 'object_association_id = ' || p_association_rec.object_association_id
1371: ) = FND_API.g_false
1372: THEN

Line 1437: IF AMS_Utility_PVT.check_lookup_exists(

1433:
1434: ----------------------- association to object ------------------------
1435: IF p_association_rec.usage_type <> FND_API.g_miss_char THEN
1436: l_usage_type := p_association_rec.usage_type;
1437: IF AMS_Utility_PVT.check_lookup_exists(
1438: p_lookup_type => 'AMS_OBJECT_USAGE_TYPE',
1439: p_lookup_code => p_association_rec.usage_type
1440: ) = FND_API.g_false
1441: THEN

Line 1455: IF AMS_Utility_PVT.check_lookup_exists(

1451: usage type logic*/
1452: /* check for master object type lookup..*/
1453:
1454: IF p_association_rec.master_object_type <> FND_API.g_miss_char THEN
1455: IF AMS_Utility_PVT.check_lookup_exists(
1456: p_lookup_type => 'AMS_MASTER_OBJECT_TYPE',
1457: p_lookup_code => p_association_rec.master_object_type
1458: ) = FND_API.g_false
1459: THEN

Line 1472: IF AMS_Utility_PVT.check_lookup_exists(

1468: END IF;
1469:
1470: -- check for using object type lookup..
1471: IF p_association_rec.using_object_type <> FND_API.g_miss_char THEN
1472: IF AMS_Utility_PVT.check_lookup_exists(
1473: p_lookup_type => 'AMS_USING_OBJECT_TYPE',
1474: p_lookup_code => p_association_rec.using_object_type
1475: ) = FND_API.g_false
1476: THEN

Line 1519: IF AMS_Utility_PVT.Check_FK_Exists (

1515: -------------------------max_cost_currency_code--------------------
1516: l_additional_where_clause := ' enabled_flag '||''''||'Y'||'''';
1517: IF p_association_rec.max_cost_currency_code <> FND_API.g_miss_char
1518: AND p_association_rec.max_cost_currency_code IS NOT NULL THEN
1519: IF AMS_Utility_PVT.Check_FK_Exists (
1520: p_table_name => 'FND_CURRENCIES'
1521: ,p_pk_name => 'CURRENCY_CODE'
1522: ,p_pk_value => p_association_rec.max_cost_currency_code
1523: ,p_pk_data_type => AMS_Utility_PVT.G_VARCHAR2

Line 1523: ,p_pk_data_type => AMS_Utility_PVT.G_VARCHAR2

1519: IF AMS_Utility_PVT.Check_FK_Exists (
1520: p_table_name => 'FND_CURRENCIES'
1521: ,p_pk_name => 'CURRENCY_CODE'
1522: ,p_pk_value => p_association_rec.max_cost_currency_code
1523: ,p_pk_data_type => AMS_Utility_PVT.G_VARCHAR2
1524: ,p_additional_where_clause => l_additional_where_clause
1525: ) = FND_API.G_FALSE
1526: THEN
1527: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

Line 1541: IF AMS_Utility_PVT.check_lookup_exists(

1537: -------------------------fulfill_on_type_code--------------------
1538: /**
1539: IF p_association_rec.fulfill_on_type_code <> FND_API.g_miss_char
1540: AND p_association_rec.fulfill_on_type_code IS NOT NULL THEN
1541: IF AMS_Utility_PVT.check_lookup_exists(
1542: p_lookup_type => 'AMS_EVENT_FULFILL_ON',
1543: p_lookup_code => p_association_rec.fulfill_on_type_code
1544: ) = FND_API.g_false
1545: THEN

Line 1579: IF AMS_Utility_PVT.is_Y_or_N(p_association_rec.primary_flag) = FND_API.g_false

1575: ----------------------- primary_flag ------------------------
1576: IF p_association_rec.primary_flag <> FND_API.g_miss_char
1577: AND p_association_rec.primary_flag IS NOT NULL
1578: THEN
1579: IF AMS_Utility_PVT.is_Y_or_N(p_association_rec.primary_flag) = FND_API.g_false
1580: THEN
1581: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1582: THEN
1583: FND_MESSAGE.set_name('AMS', 'AMS_OBJ_BAD_PRIMARY_FLAG');

Line 1595: IF AMS_Utility_PVT.is_Y_or_N(p_association_rec.cost_frozen_flag) = FND_API.g_false

1591: ----------------------- cost_frozen_flag ------------------------
1592: IF p_association_rec.cost_frozen_flag <> FND_API.g_miss_char
1593: AND p_association_rec.cost_frozen_flag IS NOT NULL
1594: THEN
1595: IF AMS_Utility_PVT.is_Y_or_N(p_association_rec.cost_frozen_flag) = FND_API.g_false
1596: THEN
1597: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1598: THEN
1599: FND_MESSAGE.set_name('AMS', 'AMS_OBJ_BAD_COST_FROZEN_FLAG');