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

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

60:
61:
62:
63:
64: AMS_Utility_PVT.debug_message(l_full_name || ': start');
65:
66:
67: END IF;
68:

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

81:
82: -- validate
83: IF (AMS_DEBUG_HIGH_ON) THEN
84:
85: AMS_Utility_PVT.debug_message(l_full_name || ': validate');
86: END IF;
87: validate_list_word_replace
88: (
89: p_api_version => l_api_version,

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

103:
104: -- insert
105: IF (AMS_DEBUG_HIGH_ON) THEN
106:
107: AMS_Utility_PVT.debug_message(l_full_name || ': insert');
108: END IF;
109:
110: IF l_wrd_rpl_rec.list_word_replaces_id IS NULL THEN
111: LOOP

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

167: IF (AMS_DEBUG_HIGH_ON) THEN
168:
169:
170:
171: AMS_Utility_PVT.debug_message(l_full_name||': end');
172:
173: END IF;
174:
175: EXCEPTION

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

249: IF (AMS_DEBUG_HIGH_ON) THEN
250:
251:
252:
253: AMS_Utility_PVT.debug_message(l_full_name || ': start');
254:
255: END IF;
256:
257: IF NOT FND_API.compatible_api_call

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

270: -- validate
271: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
272: IF (AMS_DEBUG_HIGH_ON) THEN
273:
274: AMS_Utility_PVT.debug_message(l_full_name || ': validate');
275: END IF;
276:
277: check_items
278: (

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

299:
300: -- update
301: IF (AMS_DEBUG_HIGH_ON) THEN
302:
303: AMS_Utility_PVT.debug_message(l_full_name||': update');
304: END IF;
305:
306: UPDATE AMS_LIST_WORD_REPLACES SET
307: last_update_date = SYSDATE,

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

338: IF (AMS_DEBUG_HIGH_ON) THEN
339:
340:
341:
342: AMS_Utility_PVT.debug_message(l_full_name || ': end');
343:
344: END IF;
345:
346: EXCEPTION

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

421: IF (AMS_DEBUG_HIGH_ON) THEN
422:
423:
424:
425: AMS_Utility_PVT.debug_message(l_full_name || ': start');
426:
427: END IF;
428:
429: IF FND_API.to_boolean(p_init_msg_list) THEN

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

445:
446: -- delete
447: IF (AMS_DEBUG_HIGH_ON) THEN
448:
449: AMS_Utility_PVT.debug_message(l_full_name || ': delete');
450: END IF;
451:
452: DELETE FROM AMS_LIST_WORD_REPLACES
453: WHERE list_word_replaces_id = p_wrd_rpl_id

Line 465: AMS_Utility_PVT.debug_message(l_full_name || ': list word fields delete');

461: RAISE FND_API.g_exc_error;
462: END IF;
463: IF (AMS_DEBUG_HIGH_ON) THEN
464:
465: AMS_Utility_PVT.debug_message(l_full_name || ': list word fields delete');
466: END IF;
467:
468: FOR l_word_fields_rec IN c_list_word_fields
469: LOOP

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

501: IF (AMS_DEBUG_HIGH_ON) THEN
502:
503:
504:
505: AMS_Utility_PVT.debug_message(l_full_name || ': end');
506:
507: END IF;
508:
509: EXCEPTION

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

579: BEGIN
580: -- initialize
581: IF (AMS_DEBUG_HIGH_ON) THEN
582:
583: AMS_Utility_PVT.debug_message(l_full_name || ': start');
584: END IF;
585:
586: IF FND_API.to_boolean(p_init_msg_list) THEN
587: FND_MSG_PUB.initialize;

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

602:
603: -- lock
604: IF (AMS_DEBUG_HIGH_ON) THEN
605:
606: AMS_Utility_PVT.debug_message(l_full_name || ': lock');
607: END IF;
608:
609: OPEN c_list_word_replace;
610: FETCH c_list_word_replace INTO l_wrd_rpl_id;

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

629: IF (AMS_DEBUG_HIGH_ON) THEN
630:
631:
632:
633: AMS_Utility_PVT.debug_message(l_full_name || ': end');
634:
635: END IF;
636:
637: EXCEPTION

Line 639: WHEN AMS_Utility_PVT.resource_locked THEN

635: END IF;
636:
637: EXCEPTION
638:
639: WHEN AMS_Utility_PVT.resource_locked THEN
640: x_return_status := FND_API.g_ret_sts_error;
641: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
642: FND_MESSAGE.set_name('AMS', 'AMS_API_RESOURCE_LOCKED');
643: FND_MSG_PUB.add;

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

713:
714: ----------------------- initialize --------------------
715: IF (AMS_DEBUG_HIGH_ON) THEN
716:
717: AMS_Utility_PVT.debug_message(l_full_name||': start');
718: END IF;
719:
720: IF NOT FND_API.compatible_api_call
721: (

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

733: ---------------------- validate ------------------------
734: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
735: IF (AMS_DEBUG_HIGH_ON) THEN
736:
737: AMS_Utility_PVT.debug_message(l_full_name||': check items');
738: END IF;
739: check_items
740: (
741: p_validation_mode => JTF_PLSQL_API.g_create,

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

763: IF (AMS_DEBUG_HIGH_ON) THEN
764:
765:
766:
767: AMS_Utility_PVT.debug_message(l_full_name ||': end');
768:
769: END IF;
770:
771: EXCEPTION

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

823: BEGIN
824: -- initialize
825: IF (AMS_DEBUG_HIGH_ON) THEN
826:
827: AMS_Utility_PVT.debug_message(l_full_name || ': start');
828: END IF;
829:
830: x_return_status := FND_API.g_ret_sts_success;
831:

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

831:
832: -- check required items
833: IF (AMS_DEBUG_HIGH_ON) THEN
834:
835: AMS_Utility_PVT.debug_message(l_full_name || ': check required items');
836: END IF;
837: check_req_items
838: (
839: p_validation_mode => p_validation_mode,

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

847:
848: -- check unique key items
849: IF (AMS_DEBUG_HIGH_ON) THEN
850:
851: AMS_Utility_PVT.debug_message(l_full_name || ': check uk items');
852: END IF;
853: check_uk_items
854: (
855: p_validation_mode => p_validation_mode,

Line 982: l_uk_flag := AMS_Utility_PVT.check_uniqueness

978: -- check PK, if list_word_replaces_id is passed in, must check if it is duplicate
979: IF p_validation_mode = JTF_PLSQL_API.g_create
980: AND p_wrd_rpl_rec.list_word_replaces_id IS NOT NULL
981: THEN
982: l_uk_flag := AMS_Utility_PVT.check_uniqueness
983: (
984: 'AMS_LIST_WORD_REPLACES',
985: 'list_word_replaces_id = ' || p_wrd_rpl_rec.list_word_replaces_id
986: );

Line 1001: l_uk_flag := AMS_Utility_PVT.check_uniqueness

997: END IF;
998:
999: -- check original_word, replacement_word
1000: IF p_wrd_rpl_rec.list_word_replaces_id IS NOT NULL THEN
1001: l_uk_flag := AMS_Utility_PVT.check_uniqueness
1002: (
1003: 'AMS_LIST_WORD_REPLACES',
1004: 'list_word_replaces_id <> ' || p_wrd_rpl_rec.list_word_replaces_id
1005: || ' AND original_word = ''' || p_wrd_rpl_rec.original_word

Line 1009: l_uk_flag := AMS_Utility_PVT.check_uniqueness

1005: || ' AND original_word = ''' || p_wrd_rpl_rec.original_word
1006: || ''' AND replacement_word = ''' || p_wrd_rpl_rec.replacement_word || ''''
1007: );
1008: ELSE
1009: l_uk_flag := AMS_Utility_PVT.check_uniqueness
1010: (
1011: 'AMS_LIST_WORD_REPLACES',
1012: 'original_word = ''' || p_wrd_rpl_rec.original_word
1013: ||''' AND replacement_word = ''' || p_wrd_rpl_rec.replacement_word || ''''