21: -- 11-20-99 VNEDUNGA Changed the QUALIFER_MODE from
22: -- NUMBER to VARCHAR2
23: -- 02-22-00 VNEDUNGA Changing the copy record routines
24: -- to consider org_id
25: -- 03-28-00 VNEDUNGA Adding the fnd_message calls
26: --
27: --
28: -- End of Comments
29: -- ***************************************************
476:
477: -- Debug Message
478: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_debug_low)
479: THEN
480: fnd_message.set_name ('JTF', 'JTF_TERR_START_MSG');
481: fnd_message.set_name ('PROC_NAME', l_api_name);
482: fnd_msg_pub.add;
483: END IF;
484:
477: -- Debug Message
478: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_debug_low)
479: THEN
480: fnd_message.set_name ('JTF', 'JTF_TERR_START_MSG');
481: fnd_message.set_name ('PROC_NAME', l_api_name);
482: fnd_msg_pub.add;
483: END IF;
484:
485: -- Initialize API return status to success
545:
546: -- Debug Message
547: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_debug_low)
548: THEN
549: fnd_message.set_name ('JTF', 'JTF_TERR_END_MSG');
550: fnd_message.set_name ('PROC_NAME', l_api_name);
551: fnd_msg_pub.add;
552: END IF;
553:
546: -- Debug Message
547: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_debug_low)
548: THEN
549: fnd_message.set_name ('JTF', 'JTF_TERR_END_MSG');
550: fnd_message.set_name ('PROC_NAME', l_api_name);
551: fnd_msg_pub.add;
552: END IF;
553:
554: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
695:
696: -- Debug Message
697: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_debug_low)
698: THEN
699: fnd_message.set_name ('JTF', 'JTF_TERR_START_MSG');
700: fnd_message.set_name ('PROC_NAME', l_api_name);
701: fnd_msg_pub.add;
702: END IF;
703:
696: -- Debug Message
697: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_debug_low)
698: THEN
699: fnd_message.set_name ('JTF', 'JTF_TERR_START_MSG');
700: fnd_message.set_name ('PROC_NAME', l_api_name);
701: fnd_msg_pub.add;
702: END IF;
703:
704: -- Initialize API return status to success
769:
770: -- Debug Message
771: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_debug_low)
772: THEN
773: fnd_message.set_name ('JTF', 'JTF_TERR_END_MSG');
774: fnd_message.set_name ('PROC_NAME', l_api_name);
775: fnd_msg_pub.add;
776: END IF;
777:
770: -- Debug Message
771: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_debug_low)
772: THEN
773: fnd_message.set_name ('JTF', 'JTF_TERR_END_MSG');
774: fnd_message.set_name ('PROC_NAME', l_api_name);
775: fnd_msg_pub.add;
776: END IF;
777:
778: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
894:
895: -- Debug Message
896: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_debug_low)
897: THEN
898: fnd_message.set_name ('JTF', 'JTF_TERR_START_MSG');
899: fnd_message.set_name ('PROC_NAME', l_api_name);
900: fnd_msg_pub.add;
901: END IF;
902:
895: -- Debug Message
896: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_debug_low)
897: THEN
898: fnd_message.set_name ('JTF', 'JTF_TERR_START_MSG');
899: fnd_message.set_name ('PROC_NAME', l_api_name);
900: fnd_msg_pub.add;
901: END IF;
902:
903: -- Initialize API return status to success
934:
935: -- Debug Message
936: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_debug_low)
937: THEN
938: fnd_message.set_name ('JTF', 'JTF_TERR_END_MSG');
939: fnd_message.set_name ('PROC_NAME', l_api_name);
940: fnd_msg_pub.add;
941: END IF;
942:
935: -- Debug Message
936: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_debug_low)
937: THEN
938: fnd_message.set_name ('JTF', 'JTF_TERR_END_MSG');
939: fnd_message.set_name ('PROC_NAME', l_api_name);
940: fnd_msg_pub.add;
941: END IF;
942:
943: -- Standard call to get message count and if count is 1, get message info.
1048:
1049: -- Debug Message
1050: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_debug_low)
1051: THEN
1052: fnd_message.set_name ('JTF', 'JTF_TERR_START_MSG');
1053: fnd_message.set_name ('PROC_NAME', l_api_name);
1054: fnd_msg_pub.add;
1055: END IF;
1056:
1049: -- Debug Message
1050: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_debug_low)
1051: THEN
1052: fnd_message.set_name ('JTF', 'JTF_TERR_START_MSG');
1053: fnd_message.set_name ('PROC_NAME', l_api_name);
1054: fnd_msg_pub.add;
1055: END IF;
1056:
1057: -- Initialize API return status to success
1088:
1089: -- Debug Message
1090: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_debug_low)
1091: THEN
1092: fnd_message.set_name ('JTF', 'JTF_TERR_END_MSG');
1093: fnd_message.set_name ('PROC_NAME', l_api_name);
1094: fnd_msg_pub.add;
1095: END IF;
1096:
1089: -- Debug Message
1090: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_debug_low)
1091: THEN
1092: fnd_message.set_name ('JTF', 'JTF_TERR_END_MSG');
1093: fnd_message.set_name ('PROC_NAME', l_api_name);
1094: fnd_msg_pub.add;
1095: END IF;
1096:
1097: -- Standard call to get message count and if count is 1, get message info.