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 70: AMS_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);

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

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

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

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

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

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

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

Line 424: FND_MSG_PUB.add;

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

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

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

Line 451: FND_MSG_PUB.add;

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

Line 744: FND_MSG_PUB.initialize;

740: END IF;
741:
742: IF FND_API.to_boolean (p_init_msg_list) THEN
743: -- Clear out the message buffer.
744: FND_MSG_PUB.initialize;
745: END IF;
746:
747: IF NOT FND_API.compatible_api_call (
748: l_api_version,

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

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

Line 771: FND_MSG_PUB.add;

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

Line 865: FND_MSG_PUB.count_and_get (

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

Line 882: FND_MSG_PUB.count_and_get (

878:
879: EXCEPTION
880: WHEN FND_API.g_exc_error THEN
881: x_return_status := FND_API.g_ret_sts_error;
882: FND_MSG_PUB.count_and_get (
883: p_encoded => FND_API.g_false,
884: p_count => x_msg_count,
885: p_data => x_msg_data
886: );

Line 889: FND_MSG_PUB.count_and_get (

885: p_data => x_msg_data
886: );
887: WHEN FND_API.g_exc_unexpected_error THEN
888: x_return_status := FND_API.g_ret_sts_unexp_error ;
889: FND_MSG_PUB.count_and_get (
890: p_encoded => FND_API.g_false,
891: p_count => x_msg_count,
892: p_data => x_msg_data
893: );

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

892: p_data => x_msg_data
893: );
894: WHEN OTHERS THEN
895: x_return_status := FND_API.g_ret_sts_unexp_error;
896: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
897: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
898: END IF;
899:
900: FND_MSG_PUB.count_and_get (

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

893: );
894: WHEN OTHERS THEN
895: x_return_status := FND_API.g_ret_sts_unexp_error;
896: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
897: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
898: END IF;
899:
900: FND_MSG_PUB.count_and_get (
901: p_encoded => FND_API.g_false,

Line 900: FND_MSG_PUB.count_and_get (

896: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
897: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
898: END IF;
899:
900: FND_MSG_PUB.count_and_get (
901: p_encoded => FND_API.g_false,
902: p_count => x_msg_count,
903: p_data => x_msg_data
904: );