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_LIST_RULE_FIELDS_PVT dependencies on AMS_UTILITY_PVT

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

65:
66:
67:
68:
69: AMS_Utility_PVT.debug_message(l_full_name || ': start');
70:
71:
72: END IF;
73:

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

98:
99: -- validate
100: IF (AMS_DEBUG_HIGH_ON) THEN
101:
102: AMS_Utility_PVT.debug_message(l_full_name || ': validate');
103: END IF;
104: validate_list_rule_field
105: (
106: p_api_version => l_api_version,

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

120:
121: -- insert
122: IF (AMS_DEBUG_HIGH_ON) THEN
123:
124: AMS_Utility_PVT.debug_message(l_full_name || ': insert');
125: END IF;
126:
127: IF l_rule_fld_rec.list_rule_field_id IS NULL THEN
128: LOOP

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

190: IF (AMS_DEBUG_HIGH_ON) THEN
191:
192:
193:
194: AMS_Utility_PVT.debug_message(l_full_name||': end');
195:
196: END IF;
197:
198: EXCEPTION

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

272: IF (AMS_DEBUG_HIGH_ON) THEN
273:
274:
275:
276: AMS_Utility_PVT.debug_message(l_full_name || ': start');
277:
278: END IF;
279:
280: IF NOT FND_API.compatible_api_call

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

293: -- validate
294: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
295: IF (AMS_DEBUG_HIGH_ON) THEN
296:
297: AMS_Utility_PVT.debug_message(l_full_name || ': validate');
298: END IF;
299:
300: check_items
301: (

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

322:
323: -- update
324: IF (AMS_DEBUG_HIGH_ON) THEN
325:
326: AMS_Utility_PVT.debug_message(l_full_name||': update');
327: END IF;
328:
329: UPDATE AMS_LIST_RULE_FIELDS SET
330: last_update_date = SYSDATE,

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

364: IF (AMS_DEBUG_HIGH_ON) THEN
365:
366:
367:
368: AMS_Utility_PVT.debug_message(l_full_name || ': end');
369:
370: END IF;
371:
372: EXCEPTION

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

453: IF (AMS_DEBUG_HIGH_ON) THEN
454:
455:
456:
457: AMS_Utility_PVT.debug_message(l_full_name || ': start');
458:
459: END IF;
460:
461: IF FND_API.to_boolean(p_init_msg_list) THEN

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

493:
494: -- delete
495: IF (AMS_DEBUG_HIGH_ON) THEN
496:
497: AMS_Utility_PVT.debug_message(l_full_name || ': delete');
498: END IF;
499:
500: DELETE FROM AMS_LIST_RULE_FIELDS
501: WHERE list_rule_field_id = p_rule_fld_id

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

524: IF (AMS_DEBUG_HIGH_ON) THEN
525:
526:
527:
528: AMS_Utility_PVT.debug_message(l_full_name || ': end');
529:
530: END IF;
531:
532: EXCEPTION

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

602: BEGIN
603: -- initialize
604: IF (AMS_DEBUG_HIGH_ON) THEN
605:
606: AMS_Utility_PVT.debug_message(l_full_name || ': start');
607: END IF;
608:
609: IF FND_API.to_boolean(p_init_msg_list) THEN
610: FND_MSG_PUB.initialize;

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

625:
626: -- lock
627: IF (AMS_DEBUG_HIGH_ON) THEN
628:
629: AMS_Utility_PVT.debug_message(l_full_name || ': lock');
630: END IF;
631:
632: OPEN c_list_rule_field;
633: FETCH c_list_rule_field INTO l_rule_fld_id;

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

652: IF (AMS_DEBUG_HIGH_ON) THEN
653:
654:
655:
656: AMS_Utility_PVT.debug_message(l_full_name || ': end');
657:
658: END IF;
659:
660: EXCEPTION

Line 662: WHEN AMS_Utility_PVT.resource_locked THEN

658: END IF;
659:
660: EXCEPTION
661:
662: WHEN AMS_Utility_PVT.resource_locked THEN
663: x_return_status := FND_API.g_ret_sts_error;
664: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
665: FND_MESSAGE.set_name('AMS', 'AMS_API_RESOURCE_LOCKED');
666: FND_MSG_PUB.add;

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

736:
737: ----------------------- initialize --------------------
738: IF (AMS_DEBUG_HIGH_ON) THEN
739:
740: AMS_Utility_PVT.debug_message(l_full_name||': start');
741: END IF;
742:
743: IF NOT FND_API.compatible_api_call
744: (

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

756: ---------------------- validate ------------------------
757: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
758: IF (AMS_DEBUG_HIGH_ON) THEN
759:
760: AMS_Utility_PVT.debug_message(l_full_name||': check items');
761: END IF;
762: check_items
763: (
764: p_validation_mode => JTF_PLSQL_API.g_create,

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

786: IF (AMS_DEBUG_HIGH_ON) THEN
787:
788:
789:
790: AMS_Utility_PVT.debug_message(l_full_name ||': end');
791:
792: END IF;
793:
794: EXCEPTION

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

846: BEGIN
847: -- initialize
848: IF (AMS_DEBUG_HIGH_ON) THEN
849:
850: AMS_Utility_PVT.debug_message(l_full_name || ': start');
851: END IF;
852:
853: x_return_status := FND_API.g_ret_sts_success;
854:

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

854:
855: -- check required items
856: IF (AMS_DEBUG_HIGH_ON) THEN
857:
858: AMS_Utility_PVT.debug_message(l_full_name || ': check required items');
859: END IF;
860: check_req_items
861: (
862: p_validation_mode => p_validation_mode,

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

870:
871: -- check foreign key items
872: IF (AMS_DEBUG_HIGH_ON) THEN
873:
874: AMS_Utility_PVT.debug_message(l_full_name || ': check fk items');
875: END IF;
876: check_fk_items
877: (
878: p_rule_fld_rec => p_rule_fld_rec,

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

885:
886: -- check unique key items
887: IF (AMS_DEBUG_HIGH_ON) THEN
888:
889: AMS_Utility_PVT.debug_message(l_full_name || ': check uk items');
890: END IF;
891: check_uk_items
892: (
893: p_validation_mode => p_validation_mode,

Line 1004: l_fk_flag := AMS_Utility_PVT.check_fk_exists

1000:
1001: x_return_status := FND_API.g_ret_sts_success;
1002:
1003: -- check field_table_name, field_column_name
1004: l_fk_flag := AMS_Utility_PVT.check_fk_exists
1005: (
1006: 'AMS_LIST_FIELDS_B',
1007: 'field_table_name',
1008: p_rule_fld_rec.field_table_name,

Line 1025: l_fk_flag := AMS_Utility_PVT.check_fk_exists

1021: END IF;
1022:
1023: -- check list_rule_id
1024: IF p_rule_fld_rec.list_rule_id IS NOT NULL THEN
1025: l_fk_flag := AMS_Utility_PVT.check_fk_exists
1026: (
1027: 'AMS_LIST_RULES_ALL',
1028: 'list_rule_id',
1029: p_rule_fld_rec.list_rule_id

Line 1070: l_uk_flag := AMS_Utility_PVT.check_uniqueness

1066: -- check PK, if list_rule_field_id is passed in, must check if it is duplicate
1067: IF p_validation_mode = JTF_PLSQL_API.g_create
1068: AND p_rule_fld_rec.list_rule_field_id IS NOT NULL
1069: THEN
1070: l_uk_flag := AMS_Utility_PVT.check_uniqueness
1071: (
1072: 'AMS_LIST_RULE_FIELDS',
1073: 'list_rule_field_id = ' || p_rule_fld_rec.list_rule_field_id
1074: );

Line 1089: l_uk_flag := AMS_Utility_PVT.check_uniqueness

1085: END IF;
1086:
1087: -- check original_word, replacement_word
1088: IF p_rule_fld_rec.list_rule_field_id IS NOT NULL THEN
1089: l_uk_flag := AMS_Utility_PVT.check_uniqueness
1090: (
1091: 'AMS_LIST_RULE_FIELDS',
1092: 'list_rule_field_id <> ' || p_rule_fld_rec.list_rule_field_id
1093: || ' AND list_rule_id = ' || p_rule_fld_rec.list_rule_id

Line 1098: l_uk_flag := AMS_Utility_PVT.check_uniqueness

1094: || ' AND field_table_name = ''' || p_rule_fld_rec.field_table_name
1095: || ''' AND field_column_name = ''' || p_rule_fld_rec.field_column_name || ''''
1096: );
1097: ELSE
1098: l_uk_flag := AMS_Utility_PVT.check_uniqueness
1099: (
1100: 'AMS_LIST_RULE_FIELDS',
1101: 'list_rule_id = ' || p_rule_fld_rec.list_rule_id
1102: || ' AND field_table_name = ''' || p_rule_fld_rec.field_table_name