[Home] [Help]
1: PACKAGE BODY JTF_TERRITORY_TYPE_PVT AS
2: /* $Header: jtfvttyb.pls 120.0 2005/06/02 18:23:08 appldev ship $ */
3: -- ---------------------------------------------------
4: -- Start of Comments
5: -- ---------------------------------------------------
2: /* $Header: jtfvttyb.pls 120.0 2005/06/02 18:23:08 appldev ship $ */
3: -- ---------------------------------------------------
4: -- Start of Comments
5: -- ---------------------------------------------------
6: -- PACKAGE NAME: JTF_TERRITORY_TYPE_PVT
7: -- ---------------------------------------------------
8: -- PURPOSE
9: -- Joint task force core territory manager public api's.
10: -- This package is a public API for inserting territory type
42: -- End of Comments
43: -- ***************************************************
44: -- GLOBAL VARIABLES
45: -- ***************************************************
46: g_pkg_name CONSTANT VARCHAR2(30) := 'JTF_TERRITORY_TYPE_PVT';
47: g_file_name CONSTANT VARCHAR2(12) := 'jtfvttyb.pls';
48: g_appl_id NUMBER := fnd_global.prog_appl_id;
49: g_login_id NUMBER := fnd_global.conc_login_id;
50: g_program_id NUMBER := fnd_global.conc_program_id;
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:
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:
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:
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:
531: --Declare cursor to get Terr Qualifier
532: CURSOR c_getterrtypequal
533: IS
534: SELECT jtq.terr_type_qual_id
535: FROM jtf_terr_type_qual jtq
536: WHERE jtq.terr_type_id = l_terrtype_id
537: FOR UPDATE;
538:
539: --Declare cursor to get qualifiers Type usages
547: --Declare cursor to get Terr Usages
548: CURSOR c_getterrtypeusgs
549: IS
550: SELECT jtu.terr_type_usg_id
551: FROM jtf_terr_type_usgs jtu
552: WHERE jtu.terr_type_id = l_terrtype_id
553: FOR UPDATE;
554:
555: l_api_name CONSTANT VARCHAR2(30) := 'Delete_Territory';
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:
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:
807: attribute12,
808: attribute13,
809: attribute14,
810: attribute15
811: FROM jtf_terr_types
812: WHERE terr_type_id = l_terrtype_id
813: FOR UPDATE NOWAIT;
814:
815: --Local variable declaration
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:
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;
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:
906: RAISE fnd_api.g_exc_error;
907: END IF;
908:
909: CLOSE c_getterrtype;
910: --dbms_ourtput.put_line('De-Activate_Terrtype PVT: Before Calling JTF_TERR_TYPES_PKG.Update_Row');
911: jtf_terr_types_pkg.update_row (
912: x_rowid => l_rowid,
913: x_terr_type_id => l_ref_terrtype_rec.terr_type_id,
914: x_last_updated_by => l_ref_terrtype_rec.last_updated_by,
907: END IF;
908:
909: CLOSE c_getterrtype;
910: --dbms_ourtput.put_line('De-Activate_Terrtype PVT: Before Calling JTF_TERR_TYPES_PKG.Update_Row');
911: jtf_terr_types_pkg.update_row (
912: x_rowid => l_rowid,
913: x_terr_type_id => l_ref_terrtype_rec.terr_type_id,
914: x_last_updated_by => l_ref_terrtype_rec.last_updated_by,
915: x_last_update_date => l_ref_terrtype_rec.last_update_date,
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:
1056: jtq.overlap_allowed_flag,
1057: jtq.in_use_flag,
1058: jtq.qualifier_mode,
1059: jtq.org_id
1060: FROM jtf_terr_type_qual jtq
1061: WHERE jtq.terr_type_id = p_terrtype_id
1062: FOR UPDATE;
1063:
1064: --Declare cursor to get qualifiers Type usages
1088: jtu.creation_date,
1089: jtu.created_by,
1090: jtu.last_update_login,
1091: jtu.org_id
1092: FROM jtf_terr_type_usgs jtu
1093: WHERE jtu.terr_type_id = p_terrtype_id
1094: FOR UPDATE;
1095:
1096: l_api_name CONSTANT VARCHAR2(30) := 'Copy_Territory_Type';
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:
1202: l_terrtype_rec.attribute12,
1203: l_terrtype_rec.attribute13,
1204: l_terrtype_rec.attribute14,
1205: l_terrtype_rec.attribute15
1206: FROM jtf_terr_types
1207: WHERE terr_type_id = p_terrtype_id;
1208: l_terrtype_rec.terr_type_id := NULL;
1209: l_terrtype_rec.name := p_terrtype_name;
1210: l_terrtype_rec.description := p_terrtype_description;
1293: END LOOP;
1294:
1295: CLOSE c_gettypequaltypeusgs;
1296: --
1297: -- Call api to insert records into jtf_terr_qualtype_usgs
1298: --
1299: --dbms_output.put_line('Create_terrtype PVT: Before Calling Create_TerrTypeQualType_Usage PVT');
1300: create_terrtypequaltype_usage (
1301: p_api_version_number => p_api_version_number,
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:
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:
1543: RAISE fnd_api.g_exc_error;
1544: END IF;
1545:
1546: --
1547: -- Call api to insert records into jtf_terr_qualtype_usgs
1548: --
1549: --dbms_ourtput.put_line('Create_terrtype PVT: Before Calling Create_TerrTypeQualType_Usage PVT');
1550: create_terrtypequaltype_usage (
1551: p_api_version_number => p_api_version_number,
1616: -- start of comments
1617: -- ***************************************************
1618: -- API name : Create_TerrType_record
1619: -- Type : PUBLIC
1620: -- Function : To create a records in jtf_Terr_Type_all table
1621: --
1622: -- Pre-reqs :
1623: -- Parameters:
1624: -- IN :
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:
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:
1728:
1729: --dbms_output.put_line('Value of l_terrtype_id='||TO_CHAR(l_terrtype_id));
1730:
1731: -- Call insert terr_all table handler
1732: --dbms_ourtput.put_line('Create_TerrType_Record PVT: Before calling JTF_TERR_TYPES_PKG.Insert_Row');
1733: jtf_terr_types_pkg.insert_row (
1734: x_rowid => l_rowid,
1735: x_terr_type_id => l_terrtype_id,
1736: x_last_updated_by => p_terrtype_rec.last_updated_by,
1729: --dbms_output.put_line('Value of l_terrtype_id='||TO_CHAR(l_terrtype_id));
1730:
1731: -- Call insert terr_all table handler
1732: --dbms_ourtput.put_line('Create_TerrType_Record PVT: Before calling JTF_TERR_TYPES_PKG.Insert_Row');
1733: jtf_terr_types_pkg.insert_row (
1734: x_rowid => l_rowid,
1735: x_terr_type_id => l_terrtype_id,
1736: x_last_updated_by => p_terrtype_rec.last_updated_by,
1737: x_last_update_date => p_terrtype_rec.last_update_date,
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:
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:
1902: FOR l_counter IN 1 .. l_terrtypeusgs_tbl_count
1903: LOOP
1904: --
1905: BEGIN
1906: -- dbms_ourtput.put_line('Create_TerrType_Usages PVT: Inside Loop JTF_TERR_TYPE_USGS_PKG.Insert_Row');
1907: -- Initialize API return status to success
1908: x_return_status := fnd_api.g_ret_sts_success;
1909:
1910: IF (p_validation_level >= fnd_api.g_valid_level_full)
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:
1948: l_terrtypeusg_id := NULL;
1949: END IF;
1950:
1951: --
1952: jtf_terr_type_usgs_pkg.insert_row (
1953: x_rowid => l_rowid,
1954: x_terr_type_usg_id => l_terrtypeusg_id,
1955: x_last_update_date => p_terrtypeusgs_tbl (l_counter).last_update_date,
1956: x_last_updated_by => p_terrtypeusgs_tbl (l_counter).last_updated_by,
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:
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:
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:
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:
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:
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:
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:
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:
2517: l_terrtypequal_id := NULL;
2518: END IF;
2519:
2520: -- Call insert terrtype_Qualifier table handler
2521: --dbms_ourtput.put_line('Create_TerrType_Qualifier REC: JTF_TERR_TYPE_QUAL_PKG.Insert_Row');
2522: jtf_terr_type_qual_pkg.insert_row (
2523: x_rowid => l_rowid,
2524: x_terr_type_qual_id => l_terrtypequal_id,
2525: x_last_update_date => p_terrtypequal_rec.last_update_date,
2518: END IF;
2519:
2520: -- Call insert terrtype_Qualifier table handler
2521: --dbms_ourtput.put_line('Create_TerrType_Qualifier REC: JTF_TERR_TYPE_QUAL_PKG.Insert_Row');
2522: jtf_terr_type_qual_pkg.insert_row (
2523: x_rowid => l_rowid,
2524: x_terr_type_qual_id => l_terrtypequal_id,
2525: x_last_update_date => p_terrtypequal_rec.last_update_date,
2526: x_last_updated_by => p_terrtypequal_rec.last_updated_by,
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:
2838: attribute12,
2839: attribute13,
2840: attribute14,
2841: attribute15
2842: FROM jtf_terr_types
2843: WHERE terr_type_id = l_terrtype_id
2844: FOR UPDATE NOWAIT;
2845:
2846: --
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:
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:
2963: END IF;
2964: END IF;
2965:
2966: --
2967: --dbms_ourtput.put_line('Update_TerrType_Record PVT: Before Calling JTF_TERR_TYPES_PKG.Update_Row');
2968: jtf_terr_types_pkg.update_row (
2969: x_rowid => l_rowid,
2970: x_terr_type_id => p_terrtype_rec.terr_type_id,
2971: x_last_updated_by => p_terrtype_rec.last_updated_by,
2964: END IF;
2965:
2966: --
2967: --dbms_ourtput.put_line('Update_TerrType_Record PVT: Before Calling JTF_TERR_TYPES_PKG.Update_Row');
2968: jtf_terr_types_pkg.update_row (
2969: x_rowid => l_rowid,
2970: x_terr_type_id => p_terrtype_rec.terr_type_id,
2971: x_last_updated_by => p_terrtype_rec.last_updated_by,
2972: x_last_update_date => p_terrtype_rec.last_update_date,
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:
3106: creation_date,
3107: last_update_login,
3108: terr_type_id,
3109: source_id
3110: FROM jtf_terr_type_usgs
3111: WHERE terr_type_usg_id = l_terr_type_usg_id
3112: FOR UPDATE NOWAIT;
3113:
3114: --Local variable declaration
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:
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:
3206: RAISE fnd_api.g_exc_error;
3207: END IF;
3208: End If;
3209:
3210: --dbms_ourtput.put_line('Update_TerrType_Usages REC: Before Calling JTF_TERR_TYPE_USGS_PKG.Update_Row');
3211: -- Call insert terr_Qual_Type_Usgs table handler
3212: jtf_terr_type_usgs_pkg.update_row (
3213: x_rowid => l_rowid,
3214: x_terr_type_usg_id => p_terrtypeusgs_rec.terr_type_usg_id,
3208: End If;
3209:
3210: --dbms_ourtput.put_line('Update_TerrType_Usages REC: Before Calling JTF_TERR_TYPE_USGS_PKG.Update_Row');
3211: -- Call insert terr_Qual_Type_Usgs table handler
3212: jtf_terr_type_usgs_pkg.update_row (
3213: x_rowid => l_rowid,
3214: x_terr_type_usg_id => p_terrtypeusgs_rec.terr_type_usg_id,
3215: x_last_update_date => p_terrtypeusgs_rec.last_update_date,
3216: x_last_updated_by => p_terrtypeusgs_rec.last_updated_by,
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:
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:
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:
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:
3786: terr_type_id,
3787: exclusive_use_flag,
3788: overlap_allowed_flag,
3789: in_use_flag
3790: FROM jtf_terr_type_qual
3791: WHERE terr_type_qual_id = l_terrtypequal_id
3792: FOR UPDATE NOWAIT;
3793:
3794: --
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:
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:
3894: END IF;
3895: --
3896: END IF;
3897:
3898: --dbms_ourtput.put_line('Update_TerrType_Qualifier REC: Before Calling JTF_TERR_TYPE_QUAL_PKG.Update_Row');
3899: jtf_terr_type_qual_pkg.update_row (
3900: x_rowid => l_rowid,
3901: x_terr_type_qual_id => p_terrtypequal_rec.terr_type_qual_id,
3902: x_last_update_date => p_terrtypequal_rec.last_update_date,
3895: --
3896: END IF;
3897:
3898: --dbms_ourtput.put_line('Update_TerrType_Qualifier REC: Before Calling JTF_TERR_TYPE_QUAL_PKG.Update_Row');
3899: jtf_terr_type_qual_pkg.update_row (
3900: x_rowid => l_rowid,
3901: x_terr_type_qual_id => p_terrtypequal_rec.terr_type_qual_id,
3902: x_last_update_date => p_terrtypequal_rec.last_update_date,
3903: x_last_updated_by => p_terrtypequal_rec.last_updated_by,
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:
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:
4165:
4166: --Initialize the return status to success
4167: x_return_status := fnd_api.g_ret_sts_success;
4168: --
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');
4166: --Initialize the return status to success
4167: x_return_status := fnd_api.g_ret_sts_success;
4168: --
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:
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:
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:
4300:
4301: --Initialize the return status to success
4302: x_return_status := fnd_api.g_ret_sts_success;
4303: --
4304: --dbms_ourtput.put_line('Delete_TerrType_Usages PVT: Before Calling JTF_TERR_TYPE_USGS_PKG.Delete_Row');
4305: jtf_terr_type_usgs_pkg.delete_row (
4306: x_terr_type_usg_id => p_terrtypeusg_id
4307: );
4308: --
4301: --Initialize the return status to success
4302: x_return_status := fnd_api.g_ret_sts_success;
4303: --
4304: --dbms_ourtput.put_line('Delete_TerrType_Usages PVT: Before Calling JTF_TERR_TYPE_USGS_PKG.Delete_Row');
4305: jtf_terr_type_usgs_pkg.delete_row (
4306: x_terr_type_usg_id => p_terrtypeusg_id
4307: );
4308: --
4309: --Prepare message name
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:
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:
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:
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:
4579:
4580: --Initialize the return status to success
4581: x_return_status := fnd_api.g_ret_sts_success;
4582: --
4583: --dbms_ourtput.put_line('Delete_TerrType_Qualifier PVT: Before Calling JTF_TERR_TYPE_QUAL_PKG.Delete_Row');
4584: jtf_terr_type_qual_pkg.delete_row (
4585: x_terr_type_qual_id => p_terrtypequal_id
4586: );
4587: --
4580: --Initialize the return status to success
4581: x_return_status := fnd_api.g_ret_sts_success;
4582: --
4583: --dbms_ourtput.put_line('Delete_TerrType_Qualifier PVT: Before Calling JTF_TERR_TYPE_QUAL_PKG.Delete_Row');
4584: jtf_terr_type_qual_pkg.delete_row (
4585: x_terr_type_qual_id => p_terrtypequal_id
4586: );
4587: --
4588: --Prepare message name
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:
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:
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:
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:
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:
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:
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:
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:
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:
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:
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
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:
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:
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:
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:
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:
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:
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
5026:
5027: IF jtf_ctm_utility_pvt.fk_id_is_valid (
5028: l_validate_id,
5029: 'TERR_TYPE_ID',
5030: 'JTF_TERR_TYPES'
5031: ) <>
5032: fnd_api.g_true
5033: THEN
5034: --dbms_output.put_line (
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;
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;
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;
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:
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:
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:
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:
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:
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:
5226: l_qual_type_usg_id := p_type_qualtypeusgs_rec.qual_type_usg_id;
5227: --Check the qual_type_usg_id specified is valid
5228: SELECT 1
5229: INTO l_dummy
5230: FROM jtf_terr_type_usgs jtu, jtf_qual_type_usgs jqtu
5231: WHERE jtu.terr_type_id = p_terr_type_id
5232: AND jtu.source_id = jqtu.source_id
5233: AND jqtu.qual_type_usg_id = l_qual_type_usg_id;
5234: EXCEPTION
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:
5252:
5253: IF jtf_ctm_utility_pvt.fk_id_is_valid (
5254: l_validate_id,
5255: 'TERR_TYPE_ID',
5256: 'JTF_TERR_TYPES'
5257: ) <>
5258: fnd_api.g_true
5259: THEN
5260: --dbms_output.put_line (
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;
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:
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:
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:
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:
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:
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:
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:
5416: x_return_status := fnd_api.g_ret_sts_success;
5417: --
5418: SELECT COUNT (*)
5419: INTO l_count
5420: FROM jtf_terr
5421: WHERE territory_type_id = p_terrtype_id;
5422:
5423: --
5424: -- If there are therritories that use this territory Type
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,
5455: END is_terrtype_deletable;
5456:
5457: --
5458: -- Package body
5459: END JTF_TERRITORY_TYPE_PVT;
5460:
5461: