75: -- Calling Private package: Create_DelivKitItem
76: -- Hint: Primary key needs to be returned
77:
78: -- customer pre-processing
79: IF JTF_USR_HKS.ok_to_execute(g_pkg_name, l_api_name, 'B', 'C')
80: THEN
81: AMS_DelivKitItem_CUHK.create_DelivKitItem_pre(
82: l_pvt_DelivKitItem_rec,
83: l_return_status
90: END IF;
91: END IF;
92:
93: -- vertical industry pre-processing
94: IF JTF_USR_HKS.ok_to_execute(g_pkg_name, l_api_name, 'B', 'V')
95: THEN
96: AMS_DelivKitItem_VUHK.create_DelivKitItem_pre(
97: l_pvt_DelivKitItem_rec,
98: l_return_status
127: -- End of API body.
128: --
129:
130: -- customer pre-processing
131: IF JTF_USR_HKS.ok_to_execute(g_pkg_name, l_api_name, 'A', 'C')
132: THEN
133: AMS_DelivKitItem_CUHK.create_DelivKitItem_post(
134: l_pvt_DelivKitItem_rec,
135: x_Deliv_kit_item_id,
145:
146:
147:
148: -- vertical industry pre-processing
149: IF JTF_USR_HKS.ok_to_execute(g_pkg_name, l_api_name, 'A', 'V')
150: THEN
151: AMS_DelivKitItem_VUHK.create_DelivKitItem_post(
152: l_pvt_DelivKitItem_rec,
153: x_Deliv_kit_item_id,
269: -- Initialize API return status to SUCCESS
270: x_return_status := FND_API.G_RET_STS_SUCCESS;
271:
272: -- customer pre-processing
273: IF JTF_USR_HKS.ok_to_execute(g_pkg_name, l_api_name, 'B', 'C')
274: THEN
275: AMS_DelivKitItem_CUHK.update_DelivKitItem_pre(
276: l_pvt_DelivKitItem_rec,
277: l_return_status
284: END IF;
285: END IF;
286:
287: -- vertical industry pre-processing
288: IF JTF_USR_HKS.ok_to_execute(g_pkg_name, l_api_name, 'B', 'V')
289: THEN
290: AMS_DelivKitItem_VUHK.update_DelivKitItem_pre(
291: l_pvt_DelivKitItem_rec,
292: l_return_status
327: THEN
328: COMMIT WORK;
329: END IF;
330:
331: IF JTF_USR_HKS.ok_to_execute(g_pkg_name, l_api_name, 'A', 'C')
332: THEN
333: AMS_DelivKitItem_CUHK.update_DelivKitItem_post(
334: l_pvt_DelivKitItem_rec,
335: l_return_status
342: END IF;
343: END IF;
344:
345: -- vertical industry pre-processing
346: IF JTF_USR_HKS.ok_to_execute(g_pkg_name, l_api_name, 'A', 'V')
347: THEN
348: AMS_DelivKitItem_VUHK.update_DelivKitItem_post(
349: l_pvt_DelivKitItem_rec,
350: l_return_status
457: -- Initialize API return status to SUCCESS
458: x_return_status := FND_API.G_RET_STS_SUCCESS;
459:
460: -- customer pre-processing
461: IF JTF_USR_HKS.ok_to_execute(g_pkg_name, l_api_name, 'B', 'C')
462: THEN
463: AMS_DelivKitItem_CUHK.delete_DelivKitItem_pre(
464: l_deliv_kit_item_id,
465: l_object_version_number,
473: END IF;
474: END IF;
475:
476: -- vertical industry pre-processing
477: IF JTF_USR_HKS.ok_to_execute(g_pkg_name, l_api_name, 'B', 'V')
478: THEN
479: AMS_DelivKitItem_VUHK.delete_DelivKitItem_pre(
480: l_deliv_kit_item_id,
481: l_object_version_number,
515: -- End of API body
516: --
517:
518: -- customer pre-processing
519: IF JTF_USR_HKS.ok_to_execute(g_pkg_name, l_api_name, 'A', 'C')
520: THEN
521: AMS_DelivKitItem_CUHK.delete_DelivKitItem_post(
522: l_deliv_kit_item_id,
523: l_object_version_number,
531: END IF;
532: END IF;
533:
534: -- vertical industry pre-processing
535: IF JTF_USR_HKS.ok_to_execute(g_pkg_name, l_api_name, 'A', 'V')
536: THEN
537: AMS_DelivKitItem_VUHK.delete_DelivKitItem_post(
538: l_deliv_kit_item_id,
539: l_object_version_number,
636: FND_MSG_PUB.initialize;
637: END IF;
638:
639: -- customer pre-processing
640: IF JTF_USR_HKS.ok_to_execute(g_pkg_name, l_api_name, 'B', 'C')
641: THEN
642: AMS_DelivKitItem_CUHK.validate_DelivKitItem_pre(
643: l_pvt_DelivKitItem_rec,
644: l_return_status
651: END IF;
652: END IF;
653:
654: -- vertical industry pre-processing
655: IF JTF_USR_HKS.ok_to_execute(g_pkg_name, l_api_name, 'B', 'V')
656: THEN
657: AMS_DelivKitItem_VUHK.validate_DelivKitItem_pre(
658: l_pvt_DelivKitItem_rec,
659: l_return_status
689:
690:
691:
692: -- vertical industry post-processing
693: IF JTF_USR_HKS.ok_to_execute(g_pkg_name, l_api_name, 'A', 'V')
694: THEN
695: AMS_DelivKitItem_VUHK.validate_DelivKitItem_post(
696: l_pvt_DelivKitItem_rec,
697: l_return_status
704: END IF;
705: END IF;
706:
707: -- customer post-processing
708: IF JTF_USR_HKS.ok_to_execute(g_pkg_name, l_api_name, 'A', 'C')
709: THEN
710: AMS_DelivKitItem_CUHK.validate_DelivKitItem_post(
711: l_pvt_DelivKitItem_rec,
712: l_return_status
812: -- Initialize API return status to SUCCESS
813: x_return_status := FND_API.G_RET_STS_SUCCESS;
814: --
815: -- customer pre-processing
816: IF JTF_USR_HKS.ok_to_execute(g_pkg_name, l_api_name, 'B', 'C')
817: THEN
818: AMS_DelivKitItem_CUHK.lock_DelivKitItem_pre(
819: l_deliv_kit_item_id,
820: l_object_version_number,
828: END IF;
829: END IF;
830:
831: -- vertical industry pre-processing
832: IF JTF_USR_HKS.ok_to_execute(g_pkg_name, l_api_name, 'B', 'V')
833: THEN
834: AMS_DelivKitItem_VUHK.lock_DelivKitItem_pre(
835: l_deliv_kit_item_id,
836: l_object_version_number,
868: --
869: -- End of API body.
870: --
871: -- customer pre-processing
872: IF JTF_USR_HKS.ok_to_execute(g_pkg_name, l_api_name, 'A', 'C')
873: THEN
874: AMS_DelivKitItem_CUHK.lock_DelivKitItem_post(
875: l_deliv_kit_item_id,
876: l_object_version_number,
884: END IF;
885: END IF;
886:
887: -- vertical industry pre-processing
888: IF JTF_USR_HKS.ok_to_execute(g_pkg_name, l_api_name, 'A', 'V')
889: THEN
890: AMS_DelivKitItem_VUHK.lock_DelivKitItem_post(
891: l_deliv_kit_item_id,
892: l_object_version_number,