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_LISTDEDUPE_PVT dependencies on FND_MSG_PUB

Line 69: AMS_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);

65: -- p_stmt VARCHAR2
66: --
67: -- End Of Comments
68:
69: AMS_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
70: AMS_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
71: AMS_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
72:
73: FUNCTION Exec_Sql_Stmt (p_stmt VARCHAR2)

Line 70: AMS_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);

66: --
67: -- End Of Comments
68:
69: AMS_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
70: AMS_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
71: AMS_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
72:
73: FUNCTION Exec_Sql_Stmt (p_stmt VARCHAR2)
74: RETURN NUMBER

Line 71: AMS_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);

67: -- End Of Comments
68:
69: AMS_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
70: AMS_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
71: AMS_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
72:
73: FUNCTION Exec_Sql_Stmt (p_stmt VARCHAR2)
74: RETURN NUMBER
75: IS

Line 420: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

416: THEN
417: Write_To_Act_Log (p_list_header_id,'No more list rule associated with the list' ,'LOW' );
418: END IF;
419:
420: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
421: THEN
422: FND_MESSAGE.set_name('AMS', 'AMS_LIST_NO_LIST_RULE');
423: FND_MSG_PUB.add;
424: END IF;

Line 423: FND_MSG_PUB.add;

419:
420: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
421: THEN
422: FND_MESSAGE.set_name('AMS', 'AMS_LIST_NO_LIST_RULE');
423: FND_MSG_PUB.add;
424: END IF;
425:
426: CLOSE c_list_rules;
427: RETURN 0;

Line 448: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

444: IF (p_send_to_log = 'Y') THEN
445: Write_To_Act_Log (p_list_header_id,'Only one rule can be associated with the list','LOW' );
446: END IF;
447:
448: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
449: FND_MESSAGE.set_name('AMS', 'AMS_LIST_ONLY_ONE_LIST_RULE');
450: FND_MSG_PUB.add;
451: END IF;
452:

Line 450: FND_MSG_PUB.add;

446: END IF;
447:
448: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
449: FND_MESSAGE.set_name('AMS', 'AMS_LIST_ONLY_ONE_LIST_RULE');
450: FND_MSG_PUB.add;
451: END IF;
452:
453: CLOSE c_list_rules;
454: RETURN 0;

Line 740: FND_MSG_PUB.initialize;

736: END IF;
737:
738: IF FND_API.to_boolean (p_init_msg_list) THEN
739: -- Clear out the message buffer.
740: FND_MSG_PUB.initialize;
741: END IF;
742:
743: IF NOT FND_API.compatible_api_call (
744: l_api_version,

Line 765: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_error) THEN

761: LOOP
762: FETCH c_fields INTO l_field_table_name, l_field_column_name, l_substring_length;
763: IF (c_fields%ROWCOUNT = 0) THEN
764: CLOSE c_fields;
765: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_error) THEN
766: FND_MESSAGE.set_name ('AMS', 'AMS_LIST_BAD_DEDUPE_RULE');
767: FND_MSG_PUB.add;
768: END IF;
769: RAISE FND_API.g_exc_error;

Line 767: FND_MSG_PUB.add;

763: IF (c_fields%ROWCOUNT = 0) THEN
764: CLOSE c_fields;
765: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_error) THEN
766: FND_MESSAGE.set_name ('AMS', 'AMS_LIST_BAD_DEDUPE_RULE');
767: FND_MSG_PUB.add;
768: END IF;
769: RAISE FND_API.g_exc_error;
770: END IF;
771: EXIT WHEN c_fields%NOTFOUND;

Line 861: FND_MSG_PUB.count_and_get (

857: -- The returned key may be of greater length than
858: -- the allowable key length.
859: x_dedupe_key := SUBSTR (l_dedupe_key, 1, L_KEY_LENGTH);
860:
861: FND_MSG_PUB.count_and_get (
862: p_encoded => FND_API.g_false,
863: p_count => x_msg_count,
864: p_data => x_msg_data
865: );

Line 878: FND_MSG_PUB.count_and_get (

874:
875: EXCEPTION
876: WHEN FND_API.g_exc_error THEN
877: x_return_status := FND_API.g_ret_sts_error;
878: FND_MSG_PUB.count_and_get (
879: p_encoded => FND_API.g_false,
880: p_count => x_msg_count,
881: p_data => x_msg_data
882: );

Line 885: FND_MSG_PUB.count_and_get (

881: p_data => x_msg_data
882: );
883: WHEN FND_API.g_exc_unexpected_error THEN
884: x_return_status := FND_API.g_ret_sts_unexp_error ;
885: FND_MSG_PUB.count_and_get (
886: p_encoded => FND_API.g_false,
887: p_count => x_msg_count,
888: p_data => x_msg_data
889: );

Line 892: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

888: p_data => x_msg_data
889: );
890: WHEN OTHERS THEN
891: x_return_status := FND_API.g_ret_sts_unexp_error;
892: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
893: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
894: END IF;
895:
896: FND_MSG_PUB.count_and_get (

Line 893: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);

889: );
890: WHEN OTHERS THEN
891: x_return_status := FND_API.g_ret_sts_unexp_error;
892: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
893: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
894: END IF;
895:
896: FND_MSG_PUB.count_and_get (
897: p_encoded => FND_API.g_false,

Line 896: FND_MSG_PUB.count_and_get (

892: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
893: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
894: END IF;
895:
896: FND_MSG_PUB.count_and_get (
897: p_encoded => FND_API.g_false,
898: p_count => x_msg_count,
899: p_data => x_msg_data
900: );