[Home] [Help]
128: l_msg_data VARCHAR2(2000);
129: BEGIN
130: --dbms_ourtput.put_line('create_terrtype PVT: Entering API');
131:
132: -- Standard Start of API savepoint
133: SAVEPOINT create_terrtype_pvt;
134:
135: -- Standard call to check for call compatibility.
136: IF NOT fnd_api.compatible_api_call (
131:
132: -- Standard Start of API savepoint
133: SAVEPOINT create_terrtype_pvt;
134:
135: -- Standard call to check for call compatibility.
136: IF NOT fnd_api.compatible_api_call (
137: l_api_version_number,
138: p_api_version_number,
139: l_api_name,
226: END IF;
227:
228: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
229:
230: -- Standard check for p_commit
231: IF fnd_api.to_boolean (p_commit)
232: THEN
233: COMMIT WORK;
234: END IF;
323: l_return_status VARCHAR2(1);
324: BEGIN
325: --dbms_ourtput.put_line('Update_Terrtype PVT: Entering API');
326:
327: -- Standard Start of API savepoint
328: SAVEPOINT update_terrtype_pvt;
329:
330: -- Standard call to check for call compatibility.
331: IF NOT fnd_api.compatible_api_call (
326:
327: -- Standard Start of API savepoint
328: SAVEPOINT update_terrtype_pvt;
329:
330: -- Standard call to check for call compatibility.
331: IF NOT fnd_api.compatible_api_call (
332: l_api_version_number,
333: p_api_version_number,
334: l_api_name,
445: END IF;
446:
447: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
448:
449: -- Standard check for p_commit
450: IF fnd_api.to_boolean (p_commit)
451: THEN
452: COMMIT WORK;
453: END IF;
562: BEGIN
563: --
564: --dbms_ourtput.put_line('Delete_Terrtype PVT: Entering API');
565:
566: -- Standard Start of API savepoint
567: SAVEPOINT delete_territory_pvt;
568:
569: -- Standard call to check for call compatibility.
570: IF NOT fnd_api.compatible_api_call (
565:
566: -- Standard Start of API savepoint
567: SAVEPOINT delete_territory_pvt;
568:
569: -- Standard call to check for call compatibility.
570: IF NOT fnd_api.compatible_api_call (
571: l_api_version_number,
572: p_api_version_number,
573: l_api_name,
698: END IF;
699:
700: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
701:
702: -- Standard check for p_commit
703: IF fnd_api.to_boolean (p_commit)
704: THEN
705: COMMIT WORK;
706: END IF;
820: l_ref_terrtype_rec terrtype_rec_type;
821: BEGIN
822: --dbms_ourtput.put_line('De-Activate_Terrtype PVT: Entering API');
823:
824: -- Standard Start of API savepoint
825: SAVEPOINT deactivate_territory_pvt;
826:
827: -- Standard call to check for call compatibility.
828: IF NOT fnd_api.compatible_api_call (
823:
824: -- Standard Start of API savepoint
825: SAVEPOINT deactivate_territory_pvt;
826:
827: -- Standard call to check for call compatibility.
828: IF NOT fnd_api.compatible_api_call (
829: l_api_version_number,
830: p_api_version_number,
831: l_api_name,
951: END IF;
952:
953: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
954:
955: -- Standard check for p_commit
956: IF fnd_api.to_boolean (p_commit)
957: THEN
958: COMMIT WORK;
959: END IF;
1113: BEGIN
1114: --
1115: --dbms_output.put_line('Copy_Terrtype PVT: Entering API - ' || p_enabled_flag);
1116:
1117: -- Standard Start of API savepoint
1118: SAVEPOINT copy_terrtype_pvt;
1119:
1120: -- Standard call to check for call compatibility.
1121: IF NOT fnd_api.compatible_api_call (
1116:
1117: -- Standard Start of API savepoint
1118: SAVEPOINT copy_terrtype_pvt;
1119:
1120: -- Standard call to check for call compatibility.
1121: IF NOT fnd_api.compatible_api_call (
1122: l_api_version_number,
1123: p_api_version_number,
1124: l_api_name,
1364: END IF;
1365:
1366: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1367:
1368: -- Standard check for p_commit
1369: IF fnd_api.to_boolean (p_commit)
1370: THEN
1371: COMMIT WORK;
1372: END IF;
1657: l_api_version_number CONSTANT NUMBER := 1.0;
1658: BEGIN
1659: --dbms_ourtput.put_line('Create_TerrType_Record PVT: Entering API');
1660:
1661: -- Standard Start of API savepoint
1662: SAVEPOINT create_terr_rec_pvt;
1663:
1664: -- Standard call to check for call compatibility.
1665: IF NOT fnd_api.compatible_api_call (
1660:
1661: -- Standard Start of API savepoint
1662: SAVEPOINT create_terr_rec_pvt;
1663:
1664: -- Standard call to check for call compatibility.
1665: IF NOT fnd_api.compatible_api_call (
1666: l_api_version_number,
1667: p_api_version_number,
1668: l_api_name,
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
1778: IF fnd_api.to_boolean (p_commit)
1779: THEN
1780: COMMIT WORK;
1781: END IF;
1779: THEN
1780: COMMIT WORK;
1781: END IF;
1782:
1783: -- Standard call to get message count and if count is 1, get message info.
1784: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1785: --dbms_ourtput.put_line('Create_TerrType_Record PVT: Exiting API');
1786: EXCEPTION
1787: WHEN fnd_api.g_exc_error
1870: l_api_version_number CONSTANT NUMBER := 1.0;
1871: BEGIN
1872: --dbms_ourtput.put_line('Create_TerrType_Usages PVT: Entering API');
1873:
1874: -- Standard Start of API savepoint
1875: SAVEPOINT create_terr_type_usg_pvt;
1876:
1877: -- Standard call to check for call compatibility.
1878: IF NOT fnd_api.compatible_api_call (
1873:
1874: -- Standard Start of API savepoint
1875: SAVEPOINT create_terr_type_usg_pvt;
1876:
1877: -- Standard call to check for call compatibility.
1878: IF NOT fnd_api.compatible_api_call (
1879: l_api_version_number,
1880: p_api_version_number,
1881: l_api_name,
2015: fnd_msg_pub.add;
2016: END IF;
2017:
2018: --
2019: -- Standard check for p_commit
2020: IF fnd_api.to_boolean (p_commit)
2021: THEN
2022: COMMIT WORK;
2023: END IF;
2021: THEN
2022: COMMIT WORK;
2023: END IF;
2024:
2025: -- Standard call to get message count and if count is 1, get message info.
2026: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
2027: --
2028: --dbms_ourtput.put_line('Create_TerrType_Usages PVT: Exiting API');
2029: --
2081: l_api_version_number CONSTANT NUMBER := 1.0;
2082: BEGIN
2083: --dbms_ourtput.put_line('Create_TerrTypeQualType_Usage REC: Entering API');
2084:
2085: -- Standard Start of API savepoint
2086: SAVEPOINT create_type_qtype_usg_pvt;
2087:
2088: -- Standard call to check for call compatibility.
2089: IF NOT fnd_api.compatible_api_call (
2084:
2085: -- Standard Start of API savepoint
2086: SAVEPOINT create_type_qtype_usg_pvt;
2087:
2088: -- Standard call to check for call compatibility.
2089: IF NOT fnd_api.compatible_api_call (
2090: l_api_version_number,
2091: p_api_version_number,
2092: l_api_name,
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
2181: IF fnd_api.to_boolean (p_commit)
2182: THEN
2183: COMMIT WORK;
2184: END IF;
2182: THEN
2183: COMMIT WORK;
2184: END IF;
2185:
2186: -- Standard call to get message count and if count is 1, get message info.
2187: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
2188: --dbms_ourtput.put_line('Create_TerrTypeQualType_Usage REC: Exiting API');
2189: EXCEPTION
2190: WHEN fnd_api.g_exc_error
2283: l_api_version_number CONSTANT NUMBER := 1.0;
2284: BEGIN
2285: --dbms_ourtput.put_line('Create_TerrTypeQualType_Usage TBL: Entering API');
2286:
2287: -- Standard Start of API savepoint
2288: SAVEPOINT create_terr_qtype_usg_pvt;
2289:
2290: -- Standard call to check for call compatibility.
2291: IF NOT fnd_api.compatible_api_call (
2286:
2287: -- Standard Start of API savepoint
2288: SAVEPOINT create_terr_qtype_usg_pvt;
2289:
2290: -- Standard call to check for call compatibility.
2291: IF NOT fnd_api.compatible_api_call (
2292: l_api_version_number,
2293: p_api_version_number,
2294: l_api_name,
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
2389: IF fnd_api.to_boolean (p_commit)
2390: THEN
2391: COMMIT WORK;
2392: END IF;
2390: THEN
2391: COMMIT WORK;
2392: END IF;
2393:
2394: -- Standard call to get message count and if count is 1, get message info.
2395: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
2396: --dbms_ourtput.put_line('Create_TerrTypeQualType_Usage TBL: Exiting API');
2397: --
2398:
2447: l_api_version_number CONSTANT NUMBER := 1.0;
2448: BEGIN
2449: --dbms_ourtput.put_line('Create_TerrType_Qualifier REC: Entering API');
2450:
2451: -- Standard Start of API savepoint
2452: SAVEPOINT create_terr_type_qual_pvt;
2453:
2454: -- Standard call to check for call compatibility.
2455: IF NOT fnd_api.compatible_api_call (
2450:
2451: -- Standard Start of API savepoint
2452: SAVEPOINT create_terr_type_qual_pvt;
2453:
2454: -- Standard call to check for call compatibility.
2455: IF NOT fnd_api.compatible_api_call (
2456: l_api_version_number,
2457: p_api_version_number,
2458: l_api_name,
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
2557: IF fnd_api.to_boolean (p_commit)
2558: THEN
2559: COMMIT WORK;
2560: END IF;
2558: THEN
2559: COMMIT WORK;
2560: END IF;
2561:
2562: -- Standard call to get message count and if count is 1, get message info.
2563: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
2564:
2565: --dbms_ourtput.put_line('Create_TerrType_Qualifier PVT: Exiting API');
2566: EXCEPTION
2658: l_api_version_number CONSTANT NUMBER := 1.0;
2659: BEGIN
2660: --dbms_ourtput.put_line('Create_TerrType_Qualifier TBL: Entering API');
2661:
2662: -- Standard Start of API savepoint
2663: SAVEPOINT create_terr_qual_pvt;
2664:
2665: -- Standard call to check for call compatibility.
2666: IF NOT fnd_api.compatible_api_call (
2661:
2662: -- Standard Start of API savepoint
2663: SAVEPOINT create_terr_qual_pvt;
2664:
2665: -- Standard call to check for call compatibility.
2666: IF NOT fnd_api.compatible_api_call (
2667: l_api_version_number,
2668: p_api_version_number,
2669: l_api_name,
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
2762: IF fnd_api.to_boolean (p_commit)
2763: THEN
2764: COMMIT WORK;
2765: END IF;
2763: THEN
2764: COMMIT WORK;
2765: END IF;
2766:
2767: -- Standard call to get message count and if count is 1, get message info.
2768: fnd_msg_pub.count_and_get ( p_count => x_msg_count, p_data => x_msg_data);
2769:
2770: --dbms_ourtput.put_line('Create_TerrType_Qualifier TBL: Exiting API');
2771: --
2852: l_ref_terrtype_rec terrtype_rec_type;
2853: BEGIN
2854: --dbms_ourtput.put_line('Update_TerrType_Record PVT: Entering API');
2855:
2856: -- Standard start of PAI savepoint
2857: SAVEPOINT update_terrtype_pvt;
2858:
2859: -- Standard call to check for call compatibility.
2860: IF NOT fnd_api.compatible_api_call (
2855:
2856: -- Standard start of PAI savepoint
2857: SAVEPOINT update_terrtype_pvt;
2858:
2859: -- Standard call to check for call compatibility.
2860: IF NOT fnd_api.compatible_api_call (
2861: l_api_version_number,
2862: p_api_version_number,
2863: l_api_name,
3010: END IF;
3011:
3012: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
3013:
3014: -- Standard check for p_commit
3015: IF fnd_api.to_boolean (p_commit)
3016: THEN
3017: COMMIT WORK;
3018: END IF;
3117: l_api_version_number CONSTANT NUMBER := 1.0;
3118: l_return_status VARCHAR2(1);
3119: l_ref_terrtypeusgs_rec terrtypeusgs_rec_type;
3120: BEGIN
3121: -- Standard start of PAI savepoint
3122: SAVEPOINT update_terrtype_usgs_pvt;
3123:
3124: -- Standard call to check for call compatibility.
3125: IF NOT fnd_api.compatible_api_call (
3120: BEGIN
3121: -- Standard start of PAI savepoint
3122: SAVEPOINT update_terrtype_usgs_pvt;
3123:
3124: -- Standard call to check for call compatibility.
3125: IF NOT fnd_api.compatible_api_call (
3126: l_api_version_number,
3127: p_api_version_number,
3128: l_api_name,
3235: END IF;
3236:
3237: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
3238:
3239: -- Standard check for p_commit
3240: IF fnd_api.to_boolean (p_commit)
3241: THEN
3242: COMMIT WORK;
3243: END IF;
3462: l_ref_typequaltypeusgs_rec typequaltypeusgs_rec_type;
3463: BEGIN
3464: --dbms_ourtput.put_line('Update_TerrTypeQualType_Usage REC: Entering API');
3465:
3466: -- Standard start of PAI savepoint
3467: SAVEPOINT update_typeqtype_usgs_pvt;
3468:
3469: -- Standard call to check for call compatibility.
3470: IF NOT fnd_api.compatible_api_call (
3465:
3466: -- Standard start of PAI savepoint
3467: SAVEPOINT update_typeqtype_usgs_pvt;
3468:
3469: -- Standard call to check for call compatibility.
3470: IF NOT fnd_api.compatible_api_call (
3471: l_api_version_number,
3472: p_api_version_number,
3473: l_api_name,
3575: END IF;
3576:
3577: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
3578:
3579: -- Standard check for p_commit
3580: IF fnd_api.to_boolean (p_commit)
3581: THEN
3582: COMMIT WORK;
3583: END IF;
3801: l_ref_terrtypequal_rec terrtypequal_rec_type;
3802: BEGIN
3803: --dbms_ourtput.put_line('Update_TerrType_Qualifier REC: Entering API');
3804:
3805: -- Standard start of PAI savepoint
3806: SAVEPOINT update_terrtype_qualifier;
3807:
3808: -- Standard call to check for call compatibility.
3809: IF NOT fnd_api.compatible_api_call (
3804:
3805: -- Standard start of PAI savepoint
3806: SAVEPOINT update_terrtype_qualifier;
3807:
3808: -- Standard call to check for call compatibility.
3809: IF NOT fnd_api.compatible_api_call (
3810: l_api_version_number,
3811: p_api_version_number,
3812: l_api_name,
3927: END IF;
3928:
3929: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
3930:
3931: -- Standard check for p_commit
3932: IF fnd_api.to_boolean (p_commit)
3933: THEN
3934: COMMIT WORK;
3935: END IF;
4134: l_return_status VARCHAR2(1);
4135: BEGIN
4136: --dbms_ourtput.put_line('Delete_TerrType_Record PVT: Entering API');
4137:
4138: -- Standard start of PAI savepoint
4139: SAVEPOINT delete_terr_record_pvt;
4140:
4141: -- Standard call to check for call compatibility.
4142: IF NOT fnd_api.compatible_api_call (
4137:
4138: -- Standard start of PAI savepoint
4139: SAVEPOINT delete_terr_record_pvt;
4140:
4141: -- Standard call to check for call compatibility.
4142: IF NOT fnd_api.compatible_api_call (
4143: l_api_version_number,
4144: p_api_version_number,
4145: l_api_name,
4194: END IF;
4195:
4196: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
4197:
4198: -- Standard check for p_commit
4199: IF fnd_api.to_boolean (p_commit)
4200: THEN
4201: COMMIT WORK;
4202: END IF;
4269: l_return_status VARCHAR2(1);
4270: BEGIN
4271: --dbms_ourtput.put_line('Delete_TerrType_Usages PVT: Entering API');
4272:
4273: -- Standard start of PAI savepoint
4274: SAVEPOINT delete_terrtype_usgs_pvt;
4275:
4276: -- Standard call to check for call compatibility.
4277: IF NOT fnd_api.compatible_api_call (
4272:
4273: -- Standard start of PAI savepoint
4274: SAVEPOINT delete_terrtype_usgs_pvt;
4275:
4276: -- Standard call to check for call compatibility.
4277: IF NOT fnd_api.compatible_api_call (
4278: l_api_version_number,
4279: p_api_version_number,
4280: l_api_name,
4330: END IF;
4331:
4332: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
4333:
4334: -- Standard check for p_commit
4335: IF fnd_api.to_boolean (p_commit)
4336: THEN
4337: COMMIT WORK;
4338: END IF;
4408: l_return_status VARCHAR2(1);
4409: BEGIN
4410: --dbms_ourtput.put_line('Delete_TerrTypeQualType_Usage PVT: Entering API');
4411:
4412: -- Standard start of PAI savepoint
4413: SAVEPOINT delete_typequaltypeusg_pvt;
4414:
4415: -- Standard call to check for call compatibility.
4416: IF NOT fnd_api.compatible_api_call (
4411:
4412: -- Standard start of PAI savepoint
4413: SAVEPOINT delete_typequaltypeusg_pvt;
4414:
4415: -- Standard call to check for call compatibility.
4416: IF NOT fnd_api.compatible_api_call (
4417: l_api_version_number,
4418: p_api_version_number,
4419: l_api_name,
4471: END IF;
4472:
4473: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
4474:
4475: -- Standard check for p_commit
4476: IF fnd_api.to_boolean (p_commit)
4477: THEN
4478: COMMIT WORK;
4479: END IF;
4548: l_return_status VARCHAR2(1);
4549: BEGIN
4550: --dbms_ourtput.put_line('Delete_TerrType_Qualifier PVT: Entering API');
4551:
4552: -- Standard start of PAI savepoint
4553: SAVEPOINT delete_terrtypequal_pvt;
4554:
4555: -- Standard call to check for call compatibility.
4556: IF NOT fnd_api.compatible_api_call (
4551:
4552: -- Standard start of PAI savepoint
4553: SAVEPOINT delete_terrtypequal_pvt;
4554:
4555: -- Standard call to check for call compatibility.
4556: IF NOT fnd_api.compatible_api_call (
4557: l_api_version_number,
4558: p_api_version_number,
4559: l_api_name,
4609: END IF;
4610:
4611: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
4612:
4613: -- Standard check for p_commit
4614: IF fnd_api.to_boolean (p_commit)
4615: THEN
4616: COMMIT WORK;
4617: END IF;