APPS.JTF_TERRITORY_TYPE_PVT dependencies on FND_MESSAGE

Line 155: fnd_message.set_name ('JTF', 'JTF_TERR_START_MSG');

151:
152: -- Debug Message
153: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_debug_low)
154: THEN
155: fnd_message.set_name ('JTF', 'JTF_TERR_START_MSG');
156: fnd_message.set_name ('PROC_NAME', l_api_name);
157: fnd_msg_pub.add;
158: END IF;
159:

Line 156: fnd_message.set_name ('PROC_NAME', l_api_name);

152: -- Debug Message
153: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_debug_low)
154: THEN
155: fnd_message.set_name ('JTF', 'JTF_TERR_START_MSG');
156: fnd_message.set_name ('PROC_NAME', l_api_name);
157: fnd_msg_pub.add;
158: END IF;
159:
160: -- Initialize API return status to success

Line 223: fnd_message.set_name ('JTF', 'JTF_TERR_END_MSG');

219:
220: -- Debug Message
221: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_debug_low)
222: THEN
223: fnd_message.set_name ('JTF', 'JTF_TERR_END_MSG');
224: fnd_message.set_name ('PROC_NAME', l_api_name);
225: fnd_msg_pub.add;
226: END IF;
227:

Line 224: fnd_message.set_name ('PROC_NAME', l_api_name);

220: -- Debug Message
221: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_debug_low)
222: THEN
223: fnd_message.set_name ('JTF', 'JTF_TERR_END_MSG');
224: fnd_message.set_name ('PROC_NAME', l_api_name);
225: fnd_msg_pub.add;
226: END IF;
227:
228: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

Line 350: fnd_message.set_name ('JTF', 'JTF_TERR_START_MSG');

346:
347: -- Debug Message
348: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_debug_low)
349: THEN
350: fnd_message.set_name ('JTF', 'JTF_TERR_START_MSG');
351: fnd_message.set_name ('PROC_NAME', l_api_name);
352: fnd_msg_pub.add;
353: END IF;
354:

Line 351: fnd_message.set_name ('PROC_NAME', l_api_name);

347: -- Debug Message
348: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_debug_low)
349: THEN
350: fnd_message.set_name ('JTF', 'JTF_TERR_START_MSG');
351: fnd_message.set_name ('PROC_NAME', l_api_name);
352: fnd_msg_pub.add;
353: END IF;
354:
355: -- Initialize API return status to success

Line 442: fnd_message.set_name ('JTF', 'JTF_TERR_END_MSG');

438:
439: -- Debug Message
440: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_debug_low)
441: THEN
442: fnd_message.set_name ('JTF', 'JTF_TERR_END_MSG');
443: fnd_message.set_name ('PROC_NAME', l_api_name);
444: fnd_msg_pub.add;
445: END IF;
446:

Line 443: fnd_message.set_name ('PROC_NAME', l_api_name);

439: -- Debug Message
440: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_debug_low)
441: THEN
442: fnd_message.set_name ('JTF', 'JTF_TERR_END_MSG');
443: fnd_message.set_name ('PROC_NAME', l_api_name);
444: fnd_msg_pub.add;
445: END IF;
446:
447: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

Line 589: fnd_message.set_name ('JTF', 'JTF_TERR_START_MSG');

585:
586: -- Debug Message
587: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_debug_low)
588: THEN
589: fnd_message.set_name ('JTF', 'JTF_TERR_START_MSG');
590: fnd_message.set_name ('PROC_NAME', l_api_name);
591: fnd_msg_pub.add;
592: END IF;
593:

Line 590: fnd_message.set_name ('PROC_NAME', l_api_name);

586: -- Debug Message
587: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_debug_low)
588: THEN
589: fnd_message.set_name ('JTF', 'JTF_TERR_START_MSG');
590: fnd_message.set_name ('PROC_NAME', l_api_name);
591: fnd_msg_pub.add;
592: END IF;
593:
594: -- Initialize API return status to success

Line 695: fnd_message.set_name ('JTF', 'JTF_TERR_END_MSG');

691:
692: -- Debug Message
693: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_debug_low)
694: THEN
695: fnd_message.set_name ('JTF', 'JTF_TERR_END_MSG');
696: fnd_message.set_name ('PROC_NAME', l_api_name);
697: fnd_msg_pub.add;
698: END IF;
699:

Line 696: fnd_message.set_name ('PROC_NAME', l_api_name);

692: -- Debug Message
693: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_debug_low)
694: THEN
695: fnd_message.set_name ('JTF', 'JTF_TERR_END_MSG');
696: fnd_message.set_name ('PROC_NAME', l_api_name);
697: fnd_msg_pub.add;
698: END IF;
699:
700: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

Line 847: fnd_message.set_name ('JTF', 'JTF_TERR_START_MSG');

843:
844: -- Debug Message
845: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_debug_low)
846: THEN
847: fnd_message.set_name ('JTF', 'JTF_TERR_START_MSG');
848: fnd_message.set_name ('PROC_NAME', l_api_name);
849: fnd_msg_pub.add;
850: END IF;
851:

Line 848: fnd_message.set_name ('PROC_NAME', l_api_name);

844: -- Debug Message
845: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_debug_low)
846: THEN
847: fnd_message.set_name ('JTF', 'JTF_TERR_START_MSG');
848: fnd_message.set_name ('PROC_NAME', l_api_name);
849: fnd_msg_pub.add;
850: END IF;
851:
852: -- Initialize API return status to success

Line 900: fnd_message.set_name ('JTF', 'JTF_TERR_MISSING_UPDT_TARGET');

896: THEN
897: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
898: THEN
899: --dbms_ourtput.put_line('De-Activate Terrtype PVT: C_GetTerrType%NOTFOUND');
900: fnd_message.set_name ('JTF', 'JTF_TERR_MISSING_UPDT_TARGET');
901: fnd_message.set_token ('TABLE_NAME', 'JTF_TERR_TYPES');
902: fnd_message.set_token ('PK_ID', TO_CHAR (p_terrtype_id));
903: fnd_msg_pub.add;
904: END IF;

Line 901: fnd_message.set_token ('TABLE_NAME', 'JTF_TERR_TYPES');

897: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
898: THEN
899: --dbms_ourtput.put_line('De-Activate Terrtype PVT: C_GetTerrType%NOTFOUND');
900: fnd_message.set_name ('JTF', 'JTF_TERR_MISSING_UPDT_TARGET');
901: fnd_message.set_token ('TABLE_NAME', 'JTF_TERR_TYPES');
902: fnd_message.set_token ('PK_ID', TO_CHAR (p_terrtype_id));
903: fnd_msg_pub.add;
904: END IF;
905:

Line 902: fnd_message.set_token ('PK_ID', TO_CHAR (p_terrtype_id));

898: THEN
899: --dbms_ourtput.put_line('De-Activate Terrtype PVT: C_GetTerrType%NOTFOUND');
900: fnd_message.set_name ('JTF', 'JTF_TERR_MISSING_UPDT_TARGET');
901: fnd_message.set_token ('TABLE_NAME', 'JTF_TERR_TYPES');
902: fnd_message.set_token ('PK_ID', TO_CHAR (p_terrtype_id));
903: fnd_msg_pub.add;
904: END IF;
905:
906: RAISE fnd_api.g_exc_error;

Line 948: fnd_message.set_name ('JTF', 'JTF_TERR_END_MSG');

944:
945: -- Debug Message
946: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_debug_low)
947: THEN
948: fnd_message.set_name ('JTF', 'JTF_TERR_END_MSG');
949: fnd_message.set_name ('PROC_NAME', l_api_name);
950: fnd_msg_pub.add;
951: END IF;
952:

Line 949: fnd_message.set_name ('PROC_NAME', l_api_name);

945: -- Debug Message
946: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_debug_low)
947: THEN
948: fnd_message.set_name ('JTF', 'JTF_TERR_END_MSG');
949: fnd_message.set_name ('PROC_NAME', l_api_name);
950: fnd_msg_pub.add;
951: END IF;
952:
953: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

Line 1140: fnd_message.set_name ('JTF', 'JTF_TERR_START_MSG');

1136:
1137: -- Debug Message
1138: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_debug_low)
1139: THEN
1140: fnd_message.set_name ('JTF', 'JTF_TERR_START_MSG');
1141: fnd_message.set_name ('PROC_NAME', l_api_name);
1142: fnd_msg_pub.add;
1143: END IF;
1144:

Line 1141: fnd_message.set_name ('PROC_NAME', l_api_name);

1137: -- Debug Message
1138: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_debug_low)
1139: THEN
1140: fnd_message.set_name ('JTF', 'JTF_TERR_START_MSG');
1141: fnd_message.set_name ('PROC_NAME', l_api_name);
1142: fnd_msg_pub.add;
1143: END IF;
1144:
1145: -- Initialize API return status to success

Line 1361: fnd_message.set_name ('JTF', 'JTF_TERR_END_MSG');

1357:
1358: -- Debug Message
1359: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_debug_low)
1360: THEN
1361: fnd_message.set_name ('JTF', 'JTF_TERR_END_MSG');
1362: fnd_message.set_name ('PROC_NAME', l_api_name);
1363: fnd_msg_pub.add;
1364: END IF;
1365:

Line 1362: fnd_message.set_name ('PROC_NAME', l_api_name);

1358: -- Debug Message
1359: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_debug_low)
1360: THEN
1361: fnd_message.set_name ('JTF', 'JTF_TERR_END_MSG');
1362: fnd_message.set_name ('PROC_NAME', l_api_name);
1363: fnd_msg_pub.add;
1364: END IF;
1365:
1366: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

Line 1482: fnd_message.set_name ('JTF', 'JTF_TERR_START_MSG');

1478:
1479: -- Debug Message
1480: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_debug_low)
1481: THEN
1482: fnd_message.set_name ('JTF', 'JTF_TERR_START_MSG');
1483: fnd_message.set_name ('PROC_NAME', l_api_name);
1484: fnd_msg_pub.add;
1485: END IF;
1486:

Line 1483: fnd_message.set_name ('PROC_NAME', l_api_name);

1479: -- Debug Message
1480: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_debug_low)
1481: THEN
1482: fnd_message.set_name ('JTF', 'JTF_TERR_START_MSG');
1483: fnd_message.set_name ('PROC_NAME', l_api_name);
1484: fnd_msg_pub.add;
1485: END IF;
1486:
1487: -- Initialize API return status to success

Line 1580: fnd_message.set_name ('JTF', 'Create TerrType Header: End');

1576: --
1577: -- Debug Message
1578: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_debug_low)
1579: THEN
1580: fnd_message.set_name ('JTF', 'Create TerrType Header: End');
1581: fnd_msg_pub.add;
1582: END IF;
1583: --dbms_ourtput.put_line('Create_TerrType_Header PVT: Exiting API');
1584: EXCEPTION

Line 1684: fnd_message.set_name ('JTF', 'JTF_TERR_START_MSG');

1680:
1681: -- Debug Message
1682: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_debug_low)
1683: THEN
1684: fnd_message.set_name ('JTF', 'JTF_TERR_START_MSG');
1685: fnd_message.set_name ('PROC_NAME', l_api_name);
1686: fnd_msg_pub.add;
1687: END IF;
1688:

Line 1685: fnd_message.set_name ('PROC_NAME', l_api_name);

1681: -- Debug Message
1682: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_debug_low)
1683: THEN
1684: fnd_message.set_name ('JTF', 'JTF_TERR_START_MSG');
1685: fnd_message.set_name ('PROC_NAME', l_api_name);
1686: fnd_msg_pub.add;
1687: END IF;
1688:
1689: -- Initialize API return status to success

Line 1698: fnd_message.set_name ('JTF', 'JTF_TERR_VALIDATE_MSG');

1694: THEN
1695: -- Debug message
1696: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_debug_low)
1697: THEN
1698: fnd_message.set_name ('JTF', 'JTF_TERR_VALIDATE_MSG');
1699: fnd_message.set_token ('PROC_NAME', 'Validate_TerrType_Record');
1700: fnd_msg_pub.add;
1701: END IF;
1702:

Line 1699: fnd_message.set_token ('PROC_NAME', 'Validate_TerrType_Record');

1695: -- Debug message
1696: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_debug_low)
1697: THEN
1698: fnd_message.set_name ('JTF', 'JTF_TERR_VALIDATE_MSG');
1699: fnd_message.set_token ('PROC_NAME', 'Validate_TerrType_Record');
1700: fnd_msg_pub.add;
1701: END IF;
1702:
1703: --

Line 1772: fnd_message.set_name ('JTF', 'JTF_TERR_END_MSG');

1768:
1769: -- Debug Message
1770: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_debug_low)
1771: THEN
1772: fnd_message.set_name ('JTF', 'JTF_TERR_END_MSG');
1773: fnd_message.set_name ('PROC_NAME', l_api_name);
1774: fnd_msg_pub.add;
1775: END IF;
1776:

Line 1773: fnd_message.set_name ('PROC_NAME', l_api_name);

1769: -- Debug Message
1770: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_debug_low)
1771: THEN
1772: fnd_message.set_name ('JTF', 'JTF_TERR_END_MSG');
1773: fnd_message.set_name ('PROC_NAME', l_api_name);
1774: fnd_msg_pub.add;
1775: END IF;
1776:
1777: -- Standard check for p_commit

Line 1897: fnd_message.set_name ('JTF', 'JTF_TERR_START_MSG');

1893:
1894: -- Debug Message
1895: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_debug_low)
1896: THEN
1897: fnd_message.set_name ('JTF', 'JTF_TERR_START_MSG');
1898: fnd_message.set_name ('PROC_NAME', l_api_name);
1899: fnd_msg_pub.add;
1900: END IF;
1901:

Line 1898: fnd_message.set_name ('PROC_NAME', l_api_name);

1894: -- Debug Message
1895: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_debug_low)
1896: THEN
1897: fnd_message.set_name ('JTF', 'JTF_TERR_START_MSG');
1898: fnd_message.set_name ('PROC_NAME', l_api_name);
1899: fnd_msg_pub.add;
1900: END IF;
1901:
1902: FOR l_counter IN 1 .. l_terrtypeusgs_tbl_count

Line 1917: fnd_message.set_name ('JTF', 'JTF_TERR_VALIDATE_MSG');

1913: IF fnd_msg_pub.check_msg_level (
1914: fnd_msg_pub.g_msg_lvl_debug_low
1915: )
1916: THEN
1917: fnd_message.set_name ('JTF', 'JTF_TERR_VALIDATE_MSG');
1918: fnd_message.set_token ('PROC_NAME', 'Validate_TerrType_Usage');
1919: fnd_msg_pub.add;
1920: END IF;
1921:

Line 1918: fnd_message.set_token ('PROC_NAME', 'Validate_TerrType_Usage');

1914: fnd_msg_pub.g_msg_lvl_debug_low
1915: )
1916: THEN
1917: fnd_message.set_name ('JTF', 'JTF_TERR_VALIDATE_MSG');
1918: fnd_message.set_token ('PROC_NAME', 'Validate_TerrType_Usage');
1919: fnd_msg_pub.add;
1920: END IF;
1921:
1922: --

Line 2013: fnd_message.set_name ('JTF', 'JTF_TERR_END_MSG');

2009: END LOOP;
2010:
2011: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_debug_low)
2012: THEN
2013: fnd_message.set_name ('JTF', 'JTF_TERR_END_MSG');
2014: fnd_message.set_name ('PROC_NAME', l_api_name);
2015: fnd_msg_pub.add;
2016: END IF;
2017:

Line 2014: fnd_message.set_name ('PROC_NAME', l_api_name);

2010:
2011: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_debug_low)
2012: THEN
2013: fnd_message.set_name ('JTF', 'JTF_TERR_END_MSG');
2014: fnd_message.set_name ('PROC_NAME', l_api_name);
2015: fnd_msg_pub.add;
2016: END IF;
2017:
2018: --

Line 2108: fnd_message.set_name ('JTF', 'JTF_TERR_START_MSG');

2104:
2105: -- Debug Message
2106: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_debug_low)
2107: THEN
2108: fnd_message.set_name ('JTF', 'JTF_TERR_START_MSG');
2109: fnd_message.set_name ('PROC_NAME', l_api_name);
2110: fnd_msg_pub.add;
2111: END IF;
2112:

Line 2109: fnd_message.set_name ('PROC_NAME', l_api_name);

2105: -- Debug Message
2106: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_debug_low)
2107: THEN
2108: fnd_message.set_name ('JTF', 'JTF_TERR_START_MSG');
2109: fnd_message.set_name ('PROC_NAME', l_api_name);
2110: fnd_msg_pub.add;
2111: END IF;
2112:
2113: -- Initialize API return status to success

Line 2121: fnd_message.set_name ('JTF', 'JTF_TERR_VALIDATE_MSG');

2117: THEN
2118: -- Debug message
2119: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_debug_low)
2120: THEN
2121: fnd_message.set_name ('JTF', 'JTF_TERR_VALIDATE_MSG');
2122: fnd_message.set_token ('PROC_NAME', 'Validate_Territory_Usage');
2123: fnd_msg_pub.add;
2124: END IF;
2125:

Line 2122: fnd_message.set_token ('PROC_NAME', 'Validate_Territory_Usage');

2118: -- Debug message
2119: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_debug_low)
2120: THEN
2121: fnd_message.set_name ('JTF', 'JTF_TERR_VALIDATE_MSG');
2122: fnd_message.set_token ('PROC_NAME', 'Validate_Territory_Usage');
2123: fnd_msg_pub.add;
2124: END IF;
2125:
2126: -- Invoke validation procedures

Line 2175: fnd_message.set_name ('JTF', 'JTF_TERR_END_MSG');

2171: x_typequaltypeusgs_out_rec.return_status := fnd_api.g_ret_sts_success;
2172:
2173: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_debug_low)
2174: THEN
2175: fnd_message.set_name ('JTF', 'JTF_TERR_END_MSG');
2176: fnd_message.set_name ('PROC_NAME', l_api_name);
2177: fnd_msg_pub.add;
2178: END IF;
2179:

Line 2176: fnd_message.set_name ('PROC_NAME', l_api_name);

2172:
2173: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_debug_low)
2174: THEN
2175: fnd_message.set_name ('JTF', 'JTF_TERR_END_MSG');
2176: fnd_message.set_name ('PROC_NAME', l_api_name);
2177: fnd_msg_pub.add;
2178: END IF;
2179:
2180: -- Standard check for p_commit

Line 2310: fnd_message.set_name ('JTF', 'JTF_TERR_START_MSG');

2306:
2307: -- Debug Message
2308: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_debug_low)
2309: THEN
2310: fnd_message.set_name ('JTF', 'JTF_TERR_START_MSG');
2311: fnd_message.set_name ('PROC_NAME', l_api_name);
2312: fnd_msg_pub.add;
2313: END IF;
2314:

Line 2311: fnd_message.set_name ('PROC_NAME', l_api_name);

2307: -- Debug Message
2308: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_debug_low)
2309: THEN
2310: fnd_message.set_name ('JTF', 'JTF_TERR_START_MSG');
2311: fnd_message.set_name ('PROC_NAME', l_api_name);
2312: fnd_msg_pub.add;
2313: END IF;
2314:
2315: -- Initialize API return status to success

Line 2383: fnd_message.set_name ('JTF', 'JTF_TERR_END_MSG');

2379: END LOOP;
2380:
2381: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_debug_low)
2382: THEN
2383: fnd_message.set_name ('JTF', 'JTF_TERR_END_MSG');
2384: fnd_message.set_name ('PROC_NAME', l_api_name);
2385: fnd_msg_pub.add;
2386: END IF;
2387:

Line 2384: fnd_message.set_name ('PROC_NAME', l_api_name);

2380:
2381: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_debug_low)
2382: THEN
2383: fnd_message.set_name ('JTF', 'JTF_TERR_END_MSG');
2384: fnd_message.set_name ('PROC_NAME', l_api_name);
2385: fnd_msg_pub.add;
2386: END IF;
2387:
2388: -- Standard check for p_commit

Line 2474: fnd_message.set_name ('JTF', 'JTF_TERR_START_MSG');

2470:
2471: -- Debug Message
2472: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_debug_low)
2473: THEN
2474: fnd_message.set_name ('JTF', 'JTF_TERR_START_MSG');
2475: fnd_message.set_name ('PROC_NAME', l_api_name);
2476: fnd_msg_pub.add;
2477: END IF;
2478:

Line 2475: fnd_message.set_name ('PROC_NAME', l_api_name);

2471: -- Debug Message
2472: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_debug_low)
2473: THEN
2474: fnd_message.set_name ('JTF', 'JTF_TERR_START_MSG');
2475: fnd_message.set_name ('PROC_NAME', l_api_name);
2476: fnd_msg_pub.add;
2477: END IF;
2478:
2479: -- Initialize API return status to success

Line 2488: fnd_message.set_name ('JTF', 'JTF_TERR_VALIDATE_MSG');

2484: THEN
2485: -- Debug message
2486: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_debug_low)
2487: THEN
2488: fnd_message.set_name ('JTF', 'JTF_TERR_VALIDATE_MSG');
2489: fnd_message.set_token ('PROC_NAME', 'validate_qualifier');
2490: fnd_msg_pub.add;
2491: END IF;
2492:

Line 2489: fnd_message.set_token ('PROC_NAME', 'validate_qualifier');

2485: -- Debug message
2486: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_debug_low)
2487: THEN
2488: fnd_message.set_name ('JTF', 'JTF_TERR_VALIDATE_MSG');
2489: fnd_message.set_token ('PROC_NAME', 'validate_qualifier');
2490: fnd_msg_pub.add;
2491: END IF;
2492:
2493: --

Line 2551: fnd_message.set_name ('JTF', 'JTF_TERR_END_MSG');

2547:
2548: --
2549: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_debug_low)
2550: THEN
2551: fnd_message.set_name ('JTF', 'JTF_TERR_END_MSG');
2552: fnd_message.set_name ('PROC_NAME', l_api_name);
2553: fnd_msg_pub.add;
2554: END IF;
2555:

Line 2552: fnd_message.set_name ('PROC_NAME', l_api_name);

2548: --
2549: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_debug_low)
2550: THEN
2551: fnd_message.set_name ('JTF', 'JTF_TERR_END_MSG');
2552: fnd_message.set_name ('PROC_NAME', l_api_name);
2553: fnd_msg_pub.add;
2554: END IF;
2555:
2556: -- Standard check for p_commit

Line 2685: fnd_message.set_name ('JTF', 'Create_Type_Qual PVT: Start');

2681:
2682: -- Debug Message
2683: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_debug_low)
2684: THEN
2685: fnd_message.set_name ('JTF', 'Create_Type_Qual PVT: Start');
2686: fnd_msg_pub.add;
2687: END IF;
2688:
2689: -- Initialize API return status to success

Line 2757: fnd_message.set_name ('JTF', 'Create_Type_Qual PVT: End');

2753: END LOOP;
2754:
2755: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_debug_low)
2756: THEN
2757: fnd_message.set_name ('JTF', 'Create_Type_Qual PVT: End');
2758: fnd_msg_pub.add;
2759: END IF;
2760:
2761: -- Standard check for p_commit

Line 2879: fnd_message.set_name ('JTF', 'JTF_TERR_START_MSG');

2875:
2876: -- Debug Message
2877: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_debug_low)
2878: THEN
2879: fnd_message.set_name ('JTF', 'JTF_TERR_START_MSG');
2880: fnd_message.set_name ('PROC_NAME', l_api_name);
2881: fnd_msg_pub.add;
2882: END IF;
2883:

Line 2880: fnd_message.set_name ('PROC_NAME', l_api_name);

2876: -- Debug Message
2877: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_debug_low)
2878: THEN
2879: fnd_message.set_name ('JTF', 'JTF_TERR_START_MSG');
2880: fnd_message.set_name ('PROC_NAME', l_api_name);
2881: fnd_msg_pub.add;
2882: END IF;
2883:
2884: -- Initialize API return status to SUCCESS

Line 2928: fnd_message.set_name ('JTF', 'API_MISSING_UPDATE_TARGET');

2924: IF (c_getterrtype%NOTFOUND)
2925: THEN
2926: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
2927: THEN
2928: fnd_message.set_name ('JTF', 'API_MISSING_UPDATE_TARGET');
2929: fnd_message.set_token ('INFO', 'TERRITORY_TYPE', FALSE);
2930: fnd_msg_pub.add;
2931: END IF;
2932:

Line 2929: fnd_message.set_token ('INFO', 'TERRITORY_TYPE', FALSE);

2925: THEN
2926: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
2927: THEN
2928: fnd_message.set_name ('JTF', 'API_MISSING_UPDATE_TARGET');
2929: fnd_message.set_token ('INFO', 'TERRITORY_TYPE', FALSE);
2930: fnd_msg_pub.add;
2931: END IF;
2932:
2933: RAISE fnd_api.g_exc_error;

Line 2945: fnd_message.set_name ('JTF', 'JTF_TERR_VALIDATE_MSG');

2941: THEN
2942: -- Debug message
2943: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_debug_low)
2944: THEN
2945: fnd_message.set_name ('JTF', 'JTF_TERR_VALIDATE_MSG');
2946: fnd_message.set_token ('PROC_NAME', 'Validate_TerrType_Record');
2947: fnd_msg_pub.add;
2948: END IF;
2949:

Line 2946: fnd_message.set_token ('PROC_NAME', 'Validate_TerrType_Record');

2942: -- Debug message
2943: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_debug_low)
2944: THEN
2945: fnd_message.set_name ('JTF', 'JTF_TERR_VALIDATE_MSG');
2946: fnd_message.set_token ('PROC_NAME', 'Validate_TerrType_Record');
2947: fnd_msg_pub.add;
2948: END IF;
2949:
2950: --

Line 3007: fnd_message.set_name ('JTF', 'JTF_TERR_END_MSG');

3003:
3004: -- Debug Message
3005: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_debug_low)
3006: THEN
3007: fnd_message.set_name ('JTF', 'JTF_TERR_END_MSG');
3008: fnd_message.set_name ('PROC_NAME', l_api_name);
3009: fnd_msg_pub.add;
3010: END IF;
3011:

Line 3008: fnd_message.set_name ('PROC_NAME', l_api_name);

3004: -- Debug Message
3005: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_debug_low)
3006: THEN
3007: fnd_message.set_name ('JTF', 'JTF_TERR_END_MSG');
3008: fnd_message.set_name ('PROC_NAME', l_api_name);
3009: fnd_msg_pub.add;
3010: END IF;
3011:
3012: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

Line 3144: fnd_message.set_name ('JTF', 'JTF_TERR_START_MSG');

3140:
3141: -- Debug Message
3142: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_debug_low)
3143: THEN
3144: fnd_message.set_name ('JTF', 'JTF_TERR_START_MSG');
3145: fnd_message.set_name ('PROC_NAME', l_api_name);
3146: fnd_msg_pub.add;
3147: END IF;
3148:

Line 3145: fnd_message.set_name ('PROC_NAME', l_api_name);

3141: -- Debug Message
3142: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_debug_low)
3143: THEN
3144: fnd_message.set_name ('JTF', 'JTF_TERR_START_MSG');
3145: fnd_message.set_name ('PROC_NAME', l_api_name);
3146: fnd_msg_pub.add;
3147: END IF;
3148:
3149: -- Initialize API return status to SUCCESS

Line 3170: fnd_message.set_name ('JTF', 'API_MISSING_UPDATE_TARGET');

3166: THEN
3167: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
3168: THEN
3169: --dbms_ourtput.put_line('Update_TerrType_Usages REC: C_GetTerrTypeUsage%NOTFOUND');
3170: fnd_message.set_name ('JTF', 'API_MISSING_UPDATE_TARGET');
3171: fnd_message.set_token ('INFO', 'TERRITORY_TYPE_USAGE', FALSE);
3172: fnd_msg_pub.add;
3173: END IF;
3174:

Line 3171: fnd_message.set_token ('INFO', 'TERRITORY_TYPE_USAGE', FALSE);

3167: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
3168: THEN
3169: --dbms_ourtput.put_line('Update_TerrType_Usages REC: C_GetTerrTypeUsage%NOTFOUND');
3170: fnd_message.set_name ('JTF', 'API_MISSING_UPDATE_TARGET');
3171: fnd_message.set_token ('INFO', 'TERRITORY_TYPE_USAGE', FALSE);
3172: fnd_msg_pub.add;
3173: END IF;
3174:
3175: RAISE fnd_api.g_exc_error;

Line 3187: fnd_message.set_name ('JTF', 'JTF_TERR_VALIDATE_MSG');

3183: IF fnd_msg_pub.check_msg_level (
3184: fnd_msg_pub.g_msg_lvl_debug_low
3185: )
3186: THEN
3187: fnd_message.set_name ('JTF', 'JTF_TERR_VALIDATE_MSG');
3188: fnd_message.set_token ('PROC_NAME', 'Validate_TerrType_Usage');
3189: fnd_msg_pub.add;
3190: END IF;
3191:

Line 3188: fnd_message.set_token ('PROC_NAME', 'Validate_TerrType_Usage');

3184: fnd_msg_pub.g_msg_lvl_debug_low
3185: )
3186: THEN
3187: fnd_message.set_name ('JTF', 'JTF_TERR_VALIDATE_MSG');
3188: fnd_message.set_token ('PROC_NAME', 'Validate_TerrType_Usage');
3189: fnd_msg_pub.add;
3190: END IF;
3191:
3192: --

Line 3232: fnd_message.set_name ('JTF', 'JTF_TERR_END_MSG');

3228:
3229: -- Debug Message
3230: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_debug_low)
3231: THEN
3232: fnd_message.set_name ('JTF', 'JTF_TERR_END_MSG');
3233: fnd_message.set_name ('PROC_NAME', l_api_name);
3234: fnd_msg_pub.add;
3235: END IF;
3236:

Line 3233: fnd_message.set_name ('PROC_NAME', l_api_name);

3229: -- Debug Message
3230: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_debug_low)
3231: THEN
3232: fnd_message.set_name ('JTF', 'JTF_TERR_END_MSG');
3233: fnd_message.set_name ('PROC_NAME', l_api_name);
3234: fnd_msg_pub.add;
3235: END IF;
3236:
3237: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

Line 3489: fnd_message.set_name ('JTF', 'JTF_TERR_START_MSG');

3485:
3486: -- Debug Message
3487: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_debug_low)
3488: THEN
3489: fnd_message.set_name ('JTF', 'JTF_TERR_START_MSG');
3490: fnd_message.set_name ('PROC_NAME', l_api_name);
3491: fnd_msg_pub.add;
3492: END IF;
3493:

Line 3490: fnd_message.set_name ('PROC_NAME', l_api_name);

3486: -- Debug Message
3487: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_debug_low)
3488: THEN
3489: fnd_message.set_name ('JTF', 'JTF_TERR_START_MSG');
3490: fnd_message.set_name ('PROC_NAME', l_api_name);
3491: fnd_msg_pub.add;
3492: END IF;
3493:
3494: -- Initialize API return status to SUCCESS

Line 3514: fnd_message.set_name ('JTF', 'API_MISSING_UPDATE_TARGET');

3510: THEN
3511: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
3512: THEN
3513: --dbms_ourtput.put_line('Update_TerrTypeQualType_Usage REC: C_GetTypeQualTypeUsgs%NOTFOUND');
3514: fnd_message.set_name ('JTF', 'API_MISSING_UPDATE_TARGET');
3515: fnd_message.set_token ('INFO', 'TERRITORY', FALSE);
3516: fnd_msg_pub.add;
3517: END IF;
3518:

Line 3515: fnd_message.set_token ('INFO', 'TERRITORY', FALSE);

3511: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
3512: THEN
3513: --dbms_ourtput.put_line('Update_TerrTypeQualType_Usage REC: C_GetTypeQualTypeUsgs%NOTFOUND');
3514: fnd_message.set_name ('JTF', 'API_MISSING_UPDATE_TARGET');
3515: fnd_message.set_token ('INFO', 'TERRITORY', FALSE);
3516: fnd_msg_pub.add;
3517: END IF;
3518:
3519: RAISE fnd_api.g_exc_error;

Line 3529: fnd_message.set_name ('JTF', 'JTF_TERR_VALIDATE_MSG');

3525: THEN
3526: -- Debug message
3527: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_debug_low)
3528: THEN
3529: fnd_message.set_name ('JTF', 'JTF_TERR_VALIDATE_MSG');
3530: fnd_message.set_token ('PROC_NAME', 'Validate_Territory_Usage');
3531: fnd_msg_pub.add;
3532: END IF;
3533:

Line 3530: fnd_message.set_token ('PROC_NAME', 'Validate_Territory_Usage');

3526: -- Debug message
3527: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_debug_low)
3528: THEN
3529: fnd_message.set_name ('JTF', 'JTF_TERR_VALIDATE_MSG');
3530: fnd_message.set_token ('PROC_NAME', 'Validate_Territory_Usage');
3531: fnd_msg_pub.add;
3532: END IF;
3533:
3534: -- Invoke validation procedures

Line 3572: fnd_message.set_name ('JTF', 'JTF_TERR_END_MSG');

3568:
3569: -- Debug Message
3570: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_debug_low)
3571: THEN
3572: fnd_message.set_name ('JTF', 'JTF_TERR_END_MSG');
3573: fnd_message.set_name ('PROC_NAME', l_api_name);
3574: fnd_msg_pub.add;
3575: END IF;
3576:

Line 3573: fnd_message.set_name ('PROC_NAME', l_api_name);

3569: -- Debug Message
3570: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_debug_low)
3571: THEN
3572: fnd_message.set_name ('JTF', 'JTF_TERR_END_MSG');
3573: fnd_message.set_name ('PROC_NAME', l_api_name);
3574: fnd_msg_pub.add;
3575: END IF;
3576:
3577: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

Line 3828: fnd_message.set_name ('JTF', 'JTF_TERR_START_MSG');

3824:
3825: -- Debug Message
3826: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_debug_low)
3827: THEN
3828: fnd_message.set_name ('JTF', 'JTF_TERR_START_MSG');
3829: fnd_message.set_name ('PROC_NAME', l_api_name);
3830: fnd_msg_pub.add;
3831: END IF;
3832:

Line 3829: fnd_message.set_name ('PROC_NAME', l_api_name);

3825: -- Debug Message
3826: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_debug_low)
3827: THEN
3828: fnd_message.set_name ('JTF', 'JTF_TERR_START_MSG');
3829: fnd_message.set_name ('PROC_NAME', l_api_name);
3830: fnd_msg_pub.add;
3831: END IF;
3832:
3833: -- Initialize API return status to SUCCESS

Line 3857: fnd_message.set_name ('JTF', 'API_MISSING_UPDATE_TARGET');

3853: IF (c_getterrqualifier%NOTFOUND)
3854: THEN
3855: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
3856: THEN
3857: fnd_message.set_name ('JTF', 'API_MISSING_UPDATE_TARGET');
3858: fnd_message.set_token ('INFO', 'TERRITORY_TYPE_QUALIFIER', FALSE);
3859: fnd_msg_pub.add;
3860: END IF;
3861:

Line 3858: fnd_message.set_token ('INFO', 'TERRITORY_TYPE_QUALIFIER', FALSE);

3854: THEN
3855: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
3856: THEN
3857: fnd_message.set_name ('JTF', 'API_MISSING_UPDATE_TARGET');
3858: fnd_message.set_token ('INFO', 'TERRITORY_TYPE_QUALIFIER', FALSE);
3859: fnd_msg_pub.add;
3860: END IF;
3861:
3862: RAISE fnd_api.g_exc_error;

Line 3874: fnd_message.set_name ('JTF', 'JTF_TERR_VALIDATE_MSG');

3870: THEN
3871: -- Debug message
3872: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_debug_low)
3873: THEN
3874: fnd_message.set_name ('JTF', 'JTF_TERR_VALIDATE_MSG');
3875: fnd_message.set_token ('PROC_NAME', 'validate_qualifier');
3876: fnd_msg_pub.add;
3877: END IF;
3878:

Line 3875: fnd_message.set_token ('PROC_NAME', 'validate_qualifier');

3871: -- Debug message
3872: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_debug_low)
3873: THEN
3874: fnd_message.set_name ('JTF', 'JTF_TERR_VALIDATE_MSG');
3875: fnd_message.set_token ('PROC_NAME', 'validate_qualifier');
3876: fnd_msg_pub.add;
3877: END IF;
3878:
3879: --

Line 3924: fnd_message.set_name ('JTF', 'JTF_TERR_END_MSG');

3920:
3921: -- Debug Message
3922: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_debug_low)
3923: THEN
3924: fnd_message.set_name ('JTF', 'JTF_TERR_END_MSG');
3925: fnd_message.set_name ('PROC_NAME', l_api_name);
3926: fnd_msg_pub.add;
3927: END IF;
3928:

Line 3925: fnd_message.set_name ('PROC_NAME', l_api_name);

3921: -- Debug Message
3922: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_debug_low)
3923: THEN
3924: fnd_message.set_name ('JTF', 'JTF_TERR_END_MSG');
3925: fnd_message.set_name ('PROC_NAME', l_api_name);
3926: fnd_msg_pub.add;
3927: END IF;
3928:
3929: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

Line 4161: fnd_message.set_name ('JTF', 'JTF_TERR_START_MSG');

4157:
4158: -- Debug Message
4159: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_debug_low)
4160: THEN
4161: fnd_message.set_name ('JTF', 'JTF_TERR_START_MSG');
4162: fnd_message.set_name ('PROC_NAME', l_api_name);
4163: fnd_msg_pub.add;
4164: END IF;
4165:

Line 4162: fnd_message.set_name ('PROC_NAME', l_api_name);

4158: -- Debug Message
4159: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_debug_low)
4160: THEN
4161: fnd_message.set_name ('JTF', 'JTF_TERR_START_MSG');
4162: fnd_message.set_name ('PROC_NAME', l_api_name);
4163: fnd_msg_pub.add;
4164: END IF;
4165:
4166: --Initialize the return status to success

Line 4173: fnd_message.set_name ('JTF', 'TERRTYPE_RECORDS_DELETED');

4169: --dbms_ourtput.put_line('Delete_TerrType_Record PVT: Before Calling JTF_TERR_TYPES_PKG.Delete_Row');
4170: jtf_terr_types_pkg.delete_row (x_terr_type_id => p_terrtype_id);
4171: --
4172: --Prepare message name
4173: fnd_message.set_name ('JTF', 'TERRTYPE_RECORDS_DELETED');
4174:
4175: IF SQL%FOUND
4176: THEN
4177: --dbms_ourtput.put_line('Delete_TerrType_Record PVT: NO-RCORDS-FOUND');

Line 4183: fnd_message.set_name ('ITEMS_DELETED', l_row_count);

4179: l_row_count := SQL%ROWCOUNT;
4180: END IF;
4181:
4182: --Prepare message token
4183: fnd_message.set_name ('ITEMS_DELETED', l_row_count);
4184:
4185: --Add message to API message list
4186: fnd_msg_pub.add;
4187:

Line 4191: fnd_message.set_name ('JTF', 'JTF_TERR_END_MSG');

4187:
4188: -- Debug Message
4189: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_debug_low)
4190: THEN
4191: fnd_message.set_name ('JTF', 'JTF_TERR_END_MSG');
4192: fnd_message.set_name ('PROC_NAME', l_api_name);
4193: fnd_msg_pub.add;
4194: END IF;
4195:

Line 4192: fnd_message.set_name ('PROC_NAME', l_api_name);

4188: -- Debug Message
4189: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_debug_low)
4190: THEN
4191: fnd_message.set_name ('JTF', 'JTF_TERR_END_MSG');
4192: fnd_message.set_name ('PROC_NAME', l_api_name);
4193: fnd_msg_pub.add;
4194: END IF;
4195:
4196: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

Line 4296: fnd_message.set_name ('JTF', 'JTF_TERR_START_MSG');

4292:
4293: -- Debug Message
4294: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_debug_low)
4295: THEN
4296: fnd_message.set_name ('JTF', 'JTF_TERR_START_MSG');
4297: fnd_message.set_name ('PROC_NAME', l_api_name);
4298: fnd_msg_pub.add;
4299: END IF;
4300:

Line 4297: fnd_message.set_name ('PROC_NAME', l_api_name);

4293: -- Debug Message
4294: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_debug_low)
4295: THEN
4296: fnd_message.set_name ('JTF', 'JTF_TERR_START_MSG');
4297: fnd_message.set_name ('PROC_NAME', l_api_name);
4298: fnd_msg_pub.add;
4299: END IF;
4300:
4301: --Initialize the return status to success

Line 4310: fnd_message.set_name ('JTF', 'TERRTYPE_USGS_DELETED');

4306: x_terr_type_usg_id => p_terrtypeusg_id
4307: );
4308: --
4309: --Prepare message name
4310: fnd_message.set_name ('JTF', 'TERRTYPE_USGS_DELETED');
4311:
4312: IF SQL%FOUND
4313: THEN
4314: --dbms_ourtput.put_line('Delete_TerrType_Usages PVT: NO-RCORDS-FOUND');

Line 4320: fnd_message.set_name ('ITEMS_DELETED', l_row_count);

4316: l_row_count := SQL%ROWCOUNT;
4317: END IF;
4318:
4319: --Prepare message token
4320: fnd_message.set_name ('ITEMS_DELETED', l_row_count);
4321: --Add message to API message list
4322: fnd_msg_pub.add;
4323:
4324: -- Debug Message

Line 4327: fnd_message.set_name ('JTF', 'JTF_TERR_END_MSG');

4323:
4324: -- Debug Message
4325: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_debug_low)
4326: THEN
4327: fnd_message.set_name ('JTF', 'JTF_TERR_END_MSG');
4328: fnd_message.set_name ('PROC_NAME', l_api_name);
4329: fnd_msg_pub.add;
4330: END IF;
4331:

Line 4328: fnd_message.set_name ('PROC_NAME', l_api_name);

4324: -- Debug Message
4325: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_debug_low)
4326: THEN
4327: fnd_message.set_name ('JTF', 'JTF_TERR_END_MSG');
4328: fnd_message.set_name ('PROC_NAME', l_api_name);
4329: fnd_msg_pub.add;
4330: END IF;
4331:
4332: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

Line 4435: fnd_message.set_name ('JTF', 'JTF_TERR_START_MSG');

4431:
4432: -- Debug Message
4433: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_debug_low)
4434: THEN
4435: fnd_message.set_name ('JTF', 'JTF_TERR_START_MSG');
4436: fnd_message.set_name ('PROC_NAME', l_api_name);
4437: fnd_msg_pub.add;
4438: END IF;
4439:

Line 4436: fnd_message.set_name ('PROC_NAME', l_api_name);

4432: -- Debug Message
4433: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_debug_low)
4434: THEN
4435: fnd_message.set_name ('JTF', 'JTF_TERR_START_MSG');
4436: fnd_message.set_name ('PROC_NAME', l_api_name);
4437: fnd_msg_pub.add;
4438: END IF;
4439:
4440: --Initialize the return status to success

Line 4450: fnd_message.set_name ('JTF', 'TERRTYPE_QUALUSGS_DELETED');

4446: );
4447: --
4448: --
4449: --Prepare message name
4450: fnd_message.set_name ('JTF', 'TERRTYPE_QUALUSGS_DELETED');
4451:
4452: --
4453: IF SQL%FOUND
4454: THEN

Line 4461: fnd_message.set_name ('ITEMS_DELETED', l_row_count);

4457: l_row_count := SQL%ROWCOUNT;
4458: END IF;
4459:
4460: --Prepare message token
4461: fnd_message.set_name ('ITEMS_DELETED', l_row_count);
4462: --Add message to API message list
4463: fnd_msg_pub.add;
4464:
4465: -- Debug Message

Line 4468: fnd_message.set_name ('JTF', 'JTF_TERR_END_MSG');

4464:
4465: -- Debug Message
4466: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_debug_low)
4467: THEN
4468: fnd_message.set_name ('JTF', 'JTF_TERR_END_MSG');
4469: fnd_message.set_name ('PROC_NAME', l_api_name);
4470: fnd_msg_pub.add;
4471: END IF;
4472:

Line 4469: fnd_message.set_name ('PROC_NAME', l_api_name);

4465: -- Debug Message
4466: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_debug_low)
4467: THEN
4468: fnd_message.set_name ('JTF', 'JTF_TERR_END_MSG');
4469: fnd_message.set_name ('PROC_NAME', l_api_name);
4470: fnd_msg_pub.add;
4471: END IF;
4472:
4473: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

Line 4575: fnd_message.set_name ('JTF', 'JTF_TERR_START_MSG');

4571:
4572: -- Debug Message
4573: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_debug_low)
4574: THEN
4575: fnd_message.set_name ('JTF', 'JTF_TERR_START_MSG');
4576: fnd_message.set_name ('PROC_NAME', l_api_name);
4577: fnd_msg_pub.add;
4578: END IF;
4579:

Line 4576: fnd_message.set_name ('PROC_NAME', l_api_name);

4572: -- Debug Message
4573: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_debug_low)
4574: THEN
4575: fnd_message.set_name ('JTF', 'JTF_TERR_START_MSG');
4576: fnd_message.set_name ('PROC_NAME', l_api_name);
4577: fnd_msg_pub.add;
4578: END IF;
4579:
4580: --Initialize the return status to success

Line 4589: fnd_message.set_name ('JTF', 'TERRTYPE_QUALIFIERS_DELETED');

4585: x_terr_type_qual_id => p_terrtypequal_id
4586: );
4587: --
4588: --Prepare message name
4589: fnd_message.set_name ('JTF', 'TERRTYPE_QUALIFIERS_DELETED');
4590:
4591: IF SQL%FOUND
4592: THEN
4593: --dbms_ourtput.put_line('Delete_TerrType_Qualifier PVT: NO-RCORDS-FOUND');

Line 4599: fnd_message.set_name ('ITEMS_DELETED', l_row_count);

4595: l_row_count := SQL%ROWCOUNT;
4596: END IF;
4597:
4598: --Prepare message token
4599: fnd_message.set_name ('ITEMS_DELETED', l_row_count);
4600: --Add message to API message list
4601: fnd_msg_pub.add ();
4602:
4603: -- Debug Message

Line 4606: fnd_message.set_name ('JTF', 'JTF_TERR_END_MSG');

4602:
4603: -- Debug Message
4604: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_debug_low)
4605: THEN
4606: fnd_message.set_name ('JTF', 'JTF_TERR_END_MSG');
4607: fnd_message.set_name ('PROC_NAME', l_api_name);
4608: fnd_msg_pub.add;
4609: END IF;
4610:

Line 4607: fnd_message.set_name ('PROC_NAME', l_api_name);

4603: -- Debug Message
4604: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_debug_low)
4605: THEN
4606: fnd_message.set_name ('JTF', 'JTF_TERR_END_MSG');
4607: fnd_message.set_name ('PROC_NAME', l_api_name);
4608: fnd_msg_pub.add;
4609: END IF;
4610:
4611: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

Line 4669: fnd_message.set_name ('JTF', 'JTF_TERR_MISSING_COL_VALUE');

4665: (p_terr_type_rec.name = fnd_api.g_miss_char)
4666: THEN
4667: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
4668: THEN
4669: fnd_message.set_name ('JTF', 'JTF_TERR_MISSING_COL_VALUE');
4670: fnd_message.set_token ('COL_NAME', 'NAME');
4671: fnd_msg_pub.add;
4672: END IF;
4673:

Line 4670: fnd_message.set_token ('COL_NAME', 'NAME');

4666: THEN
4667: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
4668: THEN
4669: fnd_message.set_name ('JTF', 'JTF_TERR_MISSING_COL_VALUE');
4670: fnd_message.set_token ('COL_NAME', 'NAME');
4671: fnd_msg_pub.add;
4672: END IF;
4673:
4674: x_return_status := fnd_api.g_ret_sts_error;

Line 4684: fnd_message.set_name ('JTF', 'JTF_TERR_MISSING_COL_VALUE');

4680: OR (p_terr_type_rec.application_short_name = fnd_api.g_miss_char)
4681: THEN
4682: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
4683: THEN
4684: fnd_message.set_name ('JTF', 'JTF_TERR_MISSING_COL_VALUE');
4685: fnd_message.set_token ('COL_NAME', 'APPLICATION_SHORT_NAME');
4686: fnd_msg_pub.add;
4687: END IF;
4688:

Line 4685: fnd_message.set_token ('COL_NAME', 'APPLICATION_SHORT_NAME');

4681: THEN
4682: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
4683: THEN
4684: fnd_message.set_name ('JTF', 'JTF_TERR_MISSING_COL_VALUE');
4685: fnd_message.set_token ('COL_NAME', 'APPLICATION_SHORT_NAME');
4686: fnd_msg_pub.add;
4687: END IF;
4688:
4689: x_return_status := fnd_api.g_ret_sts_error;

Line 4699: fnd_message.set_name ('JTF', 'JTF_TERR_MISSING_COL_VALUE');

4695: OR (p_terr_type_rec.enabled_flag = fnd_api.g_miss_char)
4696: THEN
4697: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
4698: THEN
4699: fnd_message.set_name ('JTF', 'JTF_TERR_MISSING_COL_VALUE');
4700: fnd_message.set_token ('COL_NAME', 'ENABLED_FLAG');
4701: fnd_msg_pub.add;
4702: END IF;
4703:

Line 4700: fnd_message.set_token ('COL_NAME', 'ENABLED_FLAG');

4696: THEN
4697: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
4698: THEN
4699: fnd_message.set_name ('JTF', 'JTF_TERR_MISSING_COL_VALUE');
4700: fnd_message.set_token ('COL_NAME', 'ENABLED_FLAG');
4701: fnd_msg_pub.add;
4702: END IF;
4703:
4704: x_return_status := fnd_api.g_ret_sts_error;

Line 4713: fnd_message.set_name ('JTF', 'JTF_TERR_MISSING_COL_VALUE');

4709: OR (p_terr_type_rec.org_id = fnd_api.g_miss_num)
4710: THEN
4711: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
4712: THEN
4713: fnd_message.set_name ('JTF', 'JTF_TERR_MISSING_COL_VALUE');
4714: fnd_message.set_token ('COL_NAME', 'ORG_ID');
4715: fnd_msg_pub.add;
4716: END IF;
4717:

Line 4714: fnd_message.set_token ('COL_NAME', 'ORG_ID');

4710: THEN
4711: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
4712: THEN
4713: fnd_message.set_name ('JTF', 'JTF_TERR_MISSING_COL_VALUE');
4714: fnd_message.set_token ('COL_NAME', 'ORG_ID');
4715: fnd_msg_pub.add;
4716: END IF;
4717:
4718: x_return_status := fnd_api.g_ret_sts_error;

Line 4728: fnd_message.set_name ('JTF', 'JTF_TERR_MISSING_COL_VALUE');

4724: OR p_terr_type_rec.created_by = fnd_api.g_miss_num)
4725: THEN
4726: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
4727: THEN
4728: fnd_message.set_name ('JTF', 'JTF_TERR_MISSING_COL_VALUE');
4729: fnd_message.set_token ('COL_NAME', 'CREATED_BY');
4730: fnd_msg_pub.add;
4731: END IF;
4732:

Line 4729: fnd_message.set_token ('COL_NAME', 'CREATED_BY');

4725: THEN
4726: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
4727: THEN
4728: fnd_message.set_name ('JTF', 'JTF_TERR_MISSING_COL_VALUE');
4729: fnd_message.set_token ('COL_NAME', 'CREATED_BY');
4730: fnd_msg_pub.add;
4731: END IF;
4732:
4733: x_return_status := fnd_api.g_ret_sts_error;

Line 4742: fnd_message.set_name ('JTF', 'JTF_TERR_MISSING_COL_VALUE');

4738: OR p_terr_type_rec.creation_date = fnd_api.g_miss_date)
4739: THEN
4740: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
4741: THEN
4742: fnd_message.set_name ('JTF', 'JTF_TERR_MISSING_COL_VALUE');
4743: fnd_message.set_token ('COL_NAME', 'CREATION_DATE');
4744: fnd_msg_pub.add;
4745: END IF;
4746:

Line 4743: fnd_message.set_token ('COL_NAME', 'CREATION_DATE');

4739: THEN
4740: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
4741: THEN
4742: fnd_message.set_name ('JTF', 'JTF_TERR_MISSING_COL_VALUE');
4743: fnd_message.set_token ('COL_NAME', 'CREATION_DATE');
4744: fnd_msg_pub.add;
4745: END IF;
4746:
4747: x_return_status := fnd_api.g_ret_sts_error;

Line 4756: fnd_message.set_name ('JTF', 'JTF_TERR_MISSING_COL_VALUE');

4752: OR p_terr_type_rec.last_updated_by = fnd_api.g_miss_num)
4753: THEN
4754: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
4755: THEN
4756: fnd_message.set_name ('JTF', 'JTF_TERR_MISSING_COL_VALUE');
4757: fnd_message.set_token ('COL_NAME', 'LAST_UPDATED_BY');
4758: fnd_msg_pub.add;
4759: END IF;
4760:

Line 4757: fnd_message.set_token ('COL_NAME', 'LAST_UPDATED_BY');

4753: THEN
4754: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
4755: THEN
4756: fnd_message.set_name ('JTF', 'JTF_TERR_MISSING_COL_VALUE');
4757: fnd_message.set_token ('COL_NAME', 'LAST_UPDATED_BY');
4758: fnd_msg_pub.add;
4759: END IF;
4760:
4761: x_return_status := fnd_api.g_ret_sts_error;

Line 4770: fnd_message.set_name ('JTF', 'JTF_TERR_MISSING_COL_VALUE');

4766: OR p_terr_type_rec.last_update_date = fnd_api.g_miss_date)
4767: THEN
4768: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
4769: THEN
4770: fnd_message.set_name ('JTF', 'JTF_TERR_MISSING_COL_VALUE');
4771: fnd_message.set_token ('COL_NAME', 'LAST_UPDATE_DATE');
4772: fnd_msg_pub.add;
4773: END IF;
4774:

Line 4771: fnd_message.set_token ('COL_NAME', 'LAST_UPDATE_DATE');

4767: THEN
4768: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
4769: THEN
4770: fnd_message.set_name ('JTF', 'JTF_TERR_MISSING_COL_VALUE');
4771: fnd_message.set_token ('COL_NAME', 'LAST_UPDATE_DATE');
4772: fnd_msg_pub.add;
4773: END IF;
4774:
4775: x_return_status := fnd_api.g_ret_sts_error;

Line 4784: fnd_message.set_name ('JTF', 'JTF_TERR_MISSING_COL_VALUE');

4780: OR p_terr_type_rec.last_update_login = fnd_api.g_miss_num)
4781: THEN
4782: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
4783: THEN
4784: fnd_message.set_name ('JTF', 'JTF_TERR_MISSING_COL_VALUE');
4785: fnd_message.set_token ('COL_NAME', 'LAST_UPDATE_LOGIN');
4786: fnd_msg_pub.add;
4787: END IF;
4788:

Line 4785: fnd_message.set_token ('COL_NAME', 'LAST_UPDATE_LOGIN');

4781: THEN
4782: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
4783: THEN
4784: fnd_message.set_name ('JTF', 'JTF_TERR_MISSING_COL_VALUE');
4785: fnd_message.set_token ('COL_NAME', 'LAST_UPDATE_LOGIN');
4786: fnd_msg_pub.add;
4787: END IF;
4788:
4789: x_return_status := fnd_api.g_ret_sts_error;

Line 4884: fnd_message.set_name ('JTF', 'JTF_TERR_DISABLED_TERR_QUAL');

4880: --dbms_output.put_line (
4881: -- 'Validate_Qualifier: NO_DATA_FOUND Exception'
4882: --);
4883: x_return_status := fnd_api.g_ret_sts_error;
4884: fnd_message.set_name ('JTF', 'JTF_TERR_DISABLED_TERR_QUAL');
4885: fnd_msg_pub.add;
4886: fnd_msg_pub.count_and_get (
4887: p_count => x_msg_count,
4888: p_data => x_msg_data

Line 4898: fnd_message.set_name ('JTF', 'JTF_TERR_MISSING_COL_VALUE');

4894: OR p_terrtypequal_rec.org_id = fnd_api.g_miss_num)
4895: THEN
4896: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
4897: THEN
4898: fnd_message.set_name ('JTF', 'JTF_TERR_MISSING_COL_VALUE');
4899: fnd_message.set_token ('COL_NAME', 'ORG_ID');
4900: fnd_msg_pub.add;
4901: END IF;
4902:

Line 4899: fnd_message.set_token ('COL_NAME', 'ORG_ID');

4895: THEN
4896: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
4897: THEN
4898: fnd_message.set_name ('JTF', 'JTF_TERR_MISSING_COL_VALUE');
4899: fnd_message.set_token ('COL_NAME', 'ORG_ID');
4900: fnd_msg_pub.add;
4901: END IF;
4902:
4903: x_return_status := fnd_api.g_ret_sts_error;

Line 4913: fnd_message.set_name ('JTF', 'JTF_TERR_MISSING_COL_VALUE');

4909: OR p_terrtypequal_rec.created_by = fnd_api.g_miss_num)
4910: THEN
4911: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
4912: THEN
4913: fnd_message.set_name ('JTF', 'JTF_TERR_MISSING_COL_VALUE');
4914: fnd_message.set_token ('COL_NAME', 'CREATED_BY');
4915: fnd_msg_pub.add;
4916: END IF;
4917:

Line 4914: fnd_message.set_token ('COL_NAME', 'CREATED_BY');

4910: THEN
4911: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
4912: THEN
4913: fnd_message.set_name ('JTF', 'JTF_TERR_MISSING_COL_VALUE');
4914: fnd_message.set_token ('COL_NAME', 'CREATED_BY');
4915: fnd_msg_pub.add;
4916: END IF;
4917:
4918: x_return_status := fnd_api.g_ret_sts_error;

Line 4927: fnd_message.set_name ('JTF', 'JTF_TERR_MISSING_COL_VALUE');

4923: OR p_terrtypequal_rec.creation_date = fnd_api.g_miss_date)
4924: THEN
4925: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
4926: THEN
4927: fnd_message.set_name ('JTF', 'JTF_TERR_MISSING_COL_VALUE');
4928: fnd_message.set_token ('COL_NAME', 'CREATION_DATE');
4929: fnd_msg_pub.add;
4930: END IF;
4931:

Line 4928: fnd_message.set_token ('COL_NAME', 'CREATION_DATE');

4924: THEN
4925: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
4926: THEN
4927: fnd_message.set_name ('JTF', 'JTF_TERR_MISSING_COL_VALUE');
4928: fnd_message.set_token ('COL_NAME', 'CREATION_DATE');
4929: fnd_msg_pub.add;
4930: END IF;
4931:
4932: x_return_status := fnd_api.g_ret_sts_error;

Line 4941: fnd_message.set_name ('JTF', 'JTF_TERR_MISSING_COL_VALUE');

4937: OR p_terrtypequal_rec.last_updated_by = fnd_api.g_miss_num)
4938: THEN
4939: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
4940: THEN
4941: fnd_message.set_name ('JTF', 'JTF_TERR_MISSING_COL_VALUE');
4942: fnd_message.set_token ('COL_NAME', 'LAST_UPDATED_BY');
4943: fnd_msg_pub.add;
4944: END IF;
4945:

Line 4942: fnd_message.set_token ('COL_NAME', 'LAST_UPDATED_BY');

4938: THEN
4939: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
4940: THEN
4941: fnd_message.set_name ('JTF', 'JTF_TERR_MISSING_COL_VALUE');
4942: fnd_message.set_token ('COL_NAME', 'LAST_UPDATED_BY');
4943: fnd_msg_pub.add;
4944: END IF;
4945:
4946: x_return_status := fnd_api.g_ret_sts_error;

Line 4955: fnd_message.set_name ('JTF', 'JTF_TERR_MISSING_COL_VALUE');

4951: OR p_terrtypequal_rec.last_update_date = fnd_api.g_miss_date)
4952: THEN
4953: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
4954: THEN
4955: fnd_message.set_name ('JTF', 'JTF_TERR_MISSING_COL_VALUE');
4956: fnd_message.set_token ('COL_NAME', 'LAST_UPDATE_DATE');
4957: fnd_msg_pub.add;
4958: END IF;
4959:

Line 4956: fnd_message.set_token ('COL_NAME', 'LAST_UPDATE_DATE');

4952: THEN
4953: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
4954: THEN
4955: fnd_message.set_name ('JTF', 'JTF_TERR_MISSING_COL_VALUE');
4956: fnd_message.set_token ('COL_NAME', 'LAST_UPDATE_DATE');
4957: fnd_msg_pub.add;
4958: END IF;
4959:
4960: x_return_status := fnd_api.g_ret_sts_error;

Line 4969: fnd_message.set_name ('JTF', 'JTF_TERR_MISSING_COL_VALUE');

4965: OR p_terrtypequal_rec.last_update_login = fnd_api.g_miss_num)
4966: THEN
4967: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
4968: THEN
4969: fnd_message.set_name ('JTF', 'JTF_TERR_MISSING_COL_VALUE');
4970: fnd_message.set_token ('COL_NAME', 'LAST_UPDATE_LOGIN');
4971: fnd_msg_pub.add;
4972: END IF;
4973:

Line 4970: fnd_message.set_token ('COL_NAME', 'LAST_UPDATE_LOGIN');

4966: THEN
4967: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
4968: THEN
4969: fnd_message.set_name ('JTF', 'JTF_TERR_MISSING_COL_VALUE');
4970: fnd_message.set_token ('COL_NAME', 'LAST_UPDATE_LOGIN');
4971: fnd_msg_pub.add;
4972: END IF;
4973:
4974: x_return_status := fnd_api.g_ret_sts_error;

Line 4986: fnd_message.set_name ('JTF', 'JTF_TERR_UNEXPECTED_ERROR');

4982: WHEN OTHERS
4983: THEN
4984: --dbms_output.put_line ('Validate_Qualifier: Others Exception');
4985: x_return_status := fnd_api.g_ret_sts_unexp_error;
4986: fnd_message.set_name ('JTF', 'JTF_TERR_UNEXPECTED_ERROR');
4987: fnd_msg_pub.add;
4988: fnd_msg_pub.count_and_get (
4989: p_count => x_msg_count,
4990: p_data => x_msg_data

Line 5037: fnd_message.set_name ('JTF', 'JTF_TERR_INVALID_FOREIGN_KEY');

5033: THEN
5034: --dbms_output.put_line (
5035: -- 'Validate_Territory_Usage: l_status <> FND_API.G_TRUE'
5036: --);
5037: fnd_message.set_name ('JTF', 'JTF_TERR_INVALID_FOREIGN_KEY');
5038: fnd_message.set_token ('TABLE_NAME', 'JTF_TERR_TYPES');
5039: fnd_message.set_token ('COLUMN_NAME', 'TERR_TYPE_ID');
5040: fnd_msg_pub.add;
5041: x_return_status := fnd_api.g_ret_sts_error;

Line 5038: fnd_message.set_token ('TABLE_NAME', 'JTF_TERR_TYPES');

5034: --dbms_output.put_line (
5035: -- 'Validate_Territory_Usage: l_status <> FND_API.G_TRUE'
5036: --);
5037: fnd_message.set_name ('JTF', 'JTF_TERR_INVALID_FOREIGN_KEY');
5038: fnd_message.set_token ('TABLE_NAME', 'JTF_TERR_TYPES');
5039: fnd_message.set_token ('COLUMN_NAME', 'TERR_TYPE_ID');
5040: fnd_msg_pub.add;
5041: x_return_status := fnd_api.g_ret_sts_error;
5042: END IF;

Line 5039: fnd_message.set_token ('COLUMN_NAME', 'TERR_TYPE_ID');

5035: -- 'Validate_Territory_Usage: l_status <> FND_API.G_TRUE'
5036: --);
5037: fnd_message.set_name ('JTF', 'JTF_TERR_INVALID_FOREIGN_KEY');
5038: fnd_message.set_token ('TABLE_NAME', 'JTF_TERR_TYPES');
5039: fnd_message.set_token ('COLUMN_NAME', 'TERR_TYPE_ID');
5040: fnd_msg_pub.add;
5041: x_return_status := fnd_api.g_ret_sts_error;
5042: END IF;
5043:

Line 5065: fnd_message.set_name ('JTF', 'JTF_TERR_INVALID_FOREIGN_KEY');

5061: THEN
5062: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
5063: THEN
5064: --dbms_output.put_line ('Validate_Territory_Usage: FND_MSG_PUB.ADD');
5065: fnd_message.set_name ('JTF', 'JTF_TERR_INVALID_FOREIGN_KEY');
5066: fnd_message.set_token ('TABLE_NAME', 'JTF_SOURCES');
5067: fnd_message.set_token ('COLUMN_NAME', 'SOURCE_ID');
5068: fnd_msg_pub.add;
5069: END IF;

Line 5066: fnd_message.set_token ('TABLE_NAME', 'JTF_SOURCES');

5062: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
5063: THEN
5064: --dbms_output.put_line ('Validate_Territory_Usage: FND_MSG_PUB.ADD');
5065: fnd_message.set_name ('JTF', 'JTF_TERR_INVALID_FOREIGN_KEY');
5066: fnd_message.set_token ('TABLE_NAME', 'JTF_SOURCES');
5067: fnd_message.set_token ('COLUMN_NAME', 'SOURCE_ID');
5068: fnd_msg_pub.add;
5069: END IF;
5070:

Line 5067: fnd_message.set_token ('COLUMN_NAME', 'SOURCE_ID');

5063: THEN
5064: --dbms_output.put_line ('Validate_Territory_Usage: FND_MSG_PUB.ADD');
5065: fnd_message.set_name ('JTF', 'JTF_TERR_INVALID_FOREIGN_KEY');
5066: fnd_message.set_token ('TABLE_NAME', 'JTF_SOURCES');
5067: fnd_message.set_token ('COLUMN_NAME', 'SOURCE_ID');
5068: fnd_msg_pub.add;
5069: END IF;
5070:
5071: x_return_status := fnd_api.g_ret_sts_error;

Line 5080: fnd_message.set_name ('JTF', 'JTF_TERR_MISSING_COL_VALUE');

5076: OR (p_terrtypeusgs_rec.org_id = fnd_api.g_miss_num)
5077: THEN
5078: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
5079: THEN
5080: fnd_message.set_name ('JTF', 'JTF_TERR_MISSING_COL_VALUE');
5081: fnd_message.set_token ('COL_NAME', 'ORG_ID');
5082: fnd_msg_pub.add;
5083: END IF;
5084:

Line 5081: fnd_message.set_token ('COL_NAME', 'ORG_ID');

5077: THEN
5078: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
5079: THEN
5080: fnd_message.set_name ('JTF', 'JTF_TERR_MISSING_COL_VALUE');
5081: fnd_message.set_token ('COL_NAME', 'ORG_ID');
5082: fnd_msg_pub.add;
5083: END IF;
5084:
5085: x_return_status := fnd_api.g_ret_sts_error;

Line 5095: fnd_message.set_name ('JTF', 'JTF_TERR_MISSING_COL_VALUE');

5091: OR p_terrtypeusgs_rec.created_by = fnd_api.g_miss_num)
5092: THEN
5093: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
5094: THEN
5095: fnd_message.set_name ('JTF', 'JTF_TERR_MISSING_COL_VALUE');
5096: fnd_message.set_token ('COL_NAME', 'CREATED_BY');
5097: fnd_msg_pub.add;
5098: END IF;
5099:

Line 5096: fnd_message.set_token ('COL_NAME', 'CREATED_BY');

5092: THEN
5093: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
5094: THEN
5095: fnd_message.set_name ('JTF', 'JTF_TERR_MISSING_COL_VALUE');
5096: fnd_message.set_token ('COL_NAME', 'CREATED_BY');
5097: fnd_msg_pub.add;
5098: END IF;
5099:
5100: x_return_status := fnd_api.g_ret_sts_error;

Line 5109: fnd_message.set_name ('JTF', 'JTF_TERR_MISSING_COL_VALUE');

5105: OR p_terrtypeusgs_rec.creation_date = fnd_api.g_miss_date)
5106: THEN
5107: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
5108: THEN
5109: fnd_message.set_name ('JTF', 'JTF_TERR_MISSING_COL_VALUE');
5110: fnd_message.set_token ('COL_NAME', 'CREATION_DATE');
5111: fnd_msg_pub.add;
5112: END IF;
5113:

Line 5110: fnd_message.set_token ('COL_NAME', 'CREATION_DATE');

5106: THEN
5107: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
5108: THEN
5109: fnd_message.set_name ('JTF', 'JTF_TERR_MISSING_COL_VALUE');
5110: fnd_message.set_token ('COL_NAME', 'CREATION_DATE');
5111: fnd_msg_pub.add;
5112: END IF;
5113:
5114: x_return_status := fnd_api.g_ret_sts_error;

Line 5123: fnd_message.set_name ('JTF', 'JTF_TERR_MISSING_COL_VALUE');

5119: OR p_terrtypeusgs_rec.last_updated_by = fnd_api.g_miss_num)
5120: THEN
5121: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
5122: THEN
5123: fnd_message.set_name ('JTF', 'JTF_TERR_MISSING_COL_VALUE');
5124: fnd_message.set_token ('COL_NAME', 'LAST_UPDATED_BY');
5125: fnd_msg_pub.add;
5126: END IF;
5127:

Line 5124: fnd_message.set_token ('COL_NAME', 'LAST_UPDATED_BY');

5120: THEN
5121: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
5122: THEN
5123: fnd_message.set_name ('JTF', 'JTF_TERR_MISSING_COL_VALUE');
5124: fnd_message.set_token ('COL_NAME', 'LAST_UPDATED_BY');
5125: fnd_msg_pub.add;
5126: END IF;
5127:
5128: x_return_status := fnd_api.g_ret_sts_error;

Line 5137: fnd_message.set_name ('JTF', 'JTF_TERR_MISSING_COL_VALUE');

5133: OR p_terrtypeusgs_rec.last_update_date = fnd_api.g_miss_date)
5134: THEN
5135: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
5136: THEN
5137: fnd_message.set_name ('JTF', 'JTF_TERR_MISSING_COL_VALUE');
5138: fnd_message.set_token ('COL_NAME', 'LAST_UPDATE_DATE');
5139: fnd_msg_pub.add;
5140: END IF;
5141:

Line 5138: fnd_message.set_token ('COL_NAME', 'LAST_UPDATE_DATE');

5134: THEN
5135: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
5136: THEN
5137: fnd_message.set_name ('JTF', 'JTF_TERR_MISSING_COL_VALUE');
5138: fnd_message.set_token ('COL_NAME', 'LAST_UPDATE_DATE');
5139: fnd_msg_pub.add;
5140: END IF;
5141:
5142: x_return_status := fnd_api.g_ret_sts_error;

Line 5151: fnd_message.set_name ('JTF', 'JTF_TERR_MISSING_COL_VALUE');

5147: OR p_terrtypeusgs_rec.last_update_login = fnd_api.g_miss_num)
5148: THEN
5149: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
5150: THEN
5151: fnd_message.set_name ('JTF', 'JTF_TERR_MISSING_COL_VALUE');
5152: fnd_message.set_token ('COL_NAME', 'LAST_UPDATE_LOGIN');
5153: fnd_msg_pub.add;
5154: END IF;
5155:

Line 5152: fnd_message.set_token ('COL_NAME', 'LAST_UPDATE_LOGIN');

5148: THEN
5149: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
5150: THEN
5151: fnd_message.set_name ('JTF', 'JTF_TERR_MISSING_COL_VALUE');
5152: fnd_message.set_token ('COL_NAME', 'LAST_UPDATE_LOGIN');
5153: fnd_msg_pub.add;
5154: END IF;
5155:
5156: x_return_status := fnd_api.g_ret_sts_error;

Line 5237: fnd_message.set_name ('JTF', 'JTF_TERR_INVALID_TERR_QTYPE');

5233: AND jqtu.qual_type_usg_id = l_qual_type_usg_id;
5234: EXCEPTION
5235: WHEN NO_DATA_FOUND
5236: THEN
5237: fnd_message.set_name ('JTF', 'JTF_TERR_INVALID_TERR_QTYPE');
5238: fnd_msg_pub.add;
5239: RAISE fnd_api.g_exc_unexpected_error;
5240: END;
5241:

Line 5266: fnd_message.set_name ('JTF', 'JTF_TERR_INVALID_FOREIGN_KEY');

5262: --);
5263:
5264: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
5265: THEN
5266: fnd_message.set_name ('JTF', 'JTF_TERR_INVALID_FOREIGN_KEY');
5267: fnd_message.set_token ('TABLE_NAME', 'JTF_TERR_TYPES');
5268: fnd_message.set_token ('COLUMN_NAME', 'TERR_TYPE_ID');
5269: fnd_msg_pub.add;
5270: END IF;

Line 5267: fnd_message.set_token ('TABLE_NAME', 'JTF_TERR_TYPES');

5263:
5264: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
5265: THEN
5266: fnd_message.set_name ('JTF', 'JTF_TERR_INVALID_FOREIGN_KEY');
5267: fnd_message.set_token ('TABLE_NAME', 'JTF_TERR_TYPES');
5268: fnd_message.set_token ('COLUMN_NAME', 'TERR_TYPE_ID');
5269: fnd_msg_pub.add;
5270: END IF;
5271:

Line 5268: fnd_message.set_token ('COLUMN_NAME', 'TERR_TYPE_ID');

5264: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
5265: THEN
5266: fnd_message.set_name ('JTF', 'JTF_TERR_INVALID_FOREIGN_KEY');
5267: fnd_message.set_token ('TABLE_NAME', 'JTF_TERR_TYPES');
5268: fnd_message.set_token ('COLUMN_NAME', 'TERR_TYPE_ID');
5269: fnd_msg_pub.add;
5270: END IF;
5271:
5272: x_return_status := fnd_api.g_ret_sts_error;

Line 5284: fnd_message.set_name ('JTF', 'JTF_TERR_MISSING_COL_VALUE');

5280: OR (p_type_qualtypeusgs_rec.org_id = fnd_api.g_miss_num)
5281: THEN
5282: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
5283: THEN
5284: fnd_message.set_name ('JTF', 'JTF_TERR_MISSING_COL_VALUE');
5285: fnd_message.set_token ('COL_NAME', 'ORG_ID');
5286: fnd_msg_pub.add;
5287: END IF;
5288:

Line 5285: fnd_message.set_token ('COL_NAME', 'ORG_ID');

5281: THEN
5282: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
5283: THEN
5284: fnd_message.set_name ('JTF', 'JTF_TERR_MISSING_COL_VALUE');
5285: fnd_message.set_token ('COL_NAME', 'ORG_ID');
5286: fnd_msg_pub.add;
5287: END IF;
5288:
5289: x_return_status := fnd_api.g_ret_sts_error;

Line 5299: fnd_message.set_name ('JTF', 'JTF_TERR_MISSING_COL_VALUE');

5295: OR p_type_qualtypeusgs_rec.created_by = fnd_api.g_miss_num)
5296: THEN
5297: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
5298: THEN
5299: fnd_message.set_name ('JTF', 'JTF_TERR_MISSING_COL_VALUE');
5300: fnd_message.set_token ('COL_NAME', 'CREATED_BY');
5301: fnd_msg_pub.add;
5302: END IF;
5303:

Line 5300: fnd_message.set_token ('COL_NAME', 'CREATED_BY');

5296: THEN
5297: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
5298: THEN
5299: fnd_message.set_name ('JTF', 'JTF_TERR_MISSING_COL_VALUE');
5300: fnd_message.set_token ('COL_NAME', 'CREATED_BY');
5301: fnd_msg_pub.add;
5302: END IF;
5303:
5304: x_return_status := fnd_api.g_ret_sts_error;

Line 5313: fnd_message.set_name ('JTF', 'JTF_TERR_MISSING_COL_VALUE');

5309: OR p_type_qualtypeusgs_rec.creation_date = fnd_api.g_miss_date)
5310: THEN
5311: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
5312: THEN
5313: fnd_message.set_name ('JTF', 'JTF_TERR_MISSING_COL_VALUE');
5314: fnd_message.set_token ('COL_NAME', 'CREATION_DATE');
5315: fnd_msg_pub.add;
5316: END IF;
5317:

Line 5314: fnd_message.set_token ('COL_NAME', 'CREATION_DATE');

5310: THEN
5311: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
5312: THEN
5313: fnd_message.set_name ('JTF', 'JTF_TERR_MISSING_COL_VALUE');
5314: fnd_message.set_token ('COL_NAME', 'CREATION_DATE');
5315: fnd_msg_pub.add;
5316: END IF;
5317:
5318: x_return_status := fnd_api.g_ret_sts_error;

Line 5327: fnd_message.set_name ('JTF', 'JTF_TERR_MISSING_COL_VALUE');

5323: OR p_type_qualtypeusgs_rec.last_updated_by = fnd_api.g_miss_num)
5324: THEN
5325: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
5326: THEN
5327: fnd_message.set_name ('JTF', 'JTF_TERR_MISSING_COL_VALUE');
5328: fnd_message.set_token ('COL_NAME', 'LAST_UPDATED_BY');
5329: fnd_msg_pub.add;
5330: END IF;
5331:

Line 5328: fnd_message.set_token ('COL_NAME', 'LAST_UPDATED_BY');

5324: THEN
5325: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
5326: THEN
5327: fnd_message.set_name ('JTF', 'JTF_TERR_MISSING_COL_VALUE');
5328: fnd_message.set_token ('COL_NAME', 'LAST_UPDATED_BY');
5329: fnd_msg_pub.add;
5330: END IF;
5331:
5332: x_return_status := fnd_api.g_ret_sts_error;

Line 5341: fnd_message.set_name ('JTF', 'JTF_TERR_MISSING_COL_VALUE');

5337: OR p_type_qualtypeusgs_rec.last_update_date = fnd_api.g_miss_date)
5338: THEN
5339: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
5340: THEN
5341: fnd_message.set_name ('JTF', 'JTF_TERR_MISSING_COL_VALUE');
5342: fnd_message.set_token ('COL_NAME', 'LAST_UPDATE_DATE');
5343: fnd_msg_pub.add;
5344: END IF;
5345:

Line 5342: fnd_message.set_token ('COL_NAME', 'LAST_UPDATE_DATE');

5338: THEN
5339: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
5340: THEN
5341: fnd_message.set_name ('JTF', 'JTF_TERR_MISSING_COL_VALUE');
5342: fnd_message.set_token ('COL_NAME', 'LAST_UPDATE_DATE');
5343: fnd_msg_pub.add;
5344: END IF;
5345:
5346: x_return_status := fnd_api.g_ret_sts_error;

Line 5355: fnd_message.set_name ('JTF', 'JTF_TERR_MISSING_COL_VALUE');

5351: OR p_type_qualtypeusgs_rec.last_update_login = fnd_api.g_miss_num)
5352: THEN
5353: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
5354: THEN
5355: fnd_message.set_name ('JTF', 'JTF_TERR_MISSING_COL_VALUE');
5356: fnd_message.set_token ('COL_NAME', 'LAST_UPDATE_LOGIN');
5357: fnd_msg_pub.add;
5358: END IF;
5359:

Line 5356: fnd_message.set_token ('COL_NAME', 'LAST_UPDATE_LOGIN');

5352: THEN
5353: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
5354: THEN
5355: fnd_message.set_name ('JTF', 'JTF_TERR_MISSING_COL_VALUE');
5356: fnd_message.set_token ('COL_NAME', 'LAST_UPDATE_LOGIN');
5357: fnd_msg_pub.add;
5358: END IF;
5359:
5360: x_return_status := fnd_api.g_ret_sts_error;

Line 5446: fnd_message.set_name ('JTF', 'JTF_TERR_UNKNOWN_ERROR');

5442: );
5443: WHEN OTHERS
5444: THEN
5445: x_return_status := fnd_api.g_ret_sts_unexp_error;
5446: fnd_message.set_name ('JTF', 'JTF_TERR_UNKNOWN_ERROR');
5447: fnd_message.set_name ('P_TEXT', SQLERRM);
5448: fnd_msg_pub.add;
5449: fnd_msg_pub.count_and_get (
5450: p_count => x_msg_count,

Line 5447: fnd_message.set_name ('P_TEXT', SQLERRM);

5443: WHEN OTHERS
5444: THEN
5445: x_return_status := fnd_api.g_ret_sts_unexp_error;
5446: fnd_message.set_name ('JTF', 'JTF_TERR_UNKNOWN_ERROR');
5447: fnd_message.set_name ('P_TEXT', SQLERRM);
5448: fnd_msg_pub.add;
5449: fnd_msg_pub.count_and_get (
5450: p_count => x_msg_count,
5451: p_data => x_msg_data