199: --
200: -- Calling Pre Customer User Hook
201: BEGIN
202:
203: IF JTF_USR_HKS.Ok_to_execute(G_PKG_NAME, l_api_name, 'B', 'C' ) THEN
204: csi_gen_utility_pvt.put_line('Calling CSI_ITEM_INSTANCE_CUHK.Create_Item_Instance_Pre ..');
205: CSI_ITEM_INSTANCE_CUHK.Create_Item_Instance_Pre
206: (
207: p_api_version => 1.0
238: --
239: END IF;
240: EXCEPTION
241: WHEN OTHERS THEN
242: csi_gen_utility_pvt.put_line('ERROR FROM JTF_USR_HKS.Ok_to_execute API Create Pre Customer');
243: RAISE FND_API.G_EXC_ERROR;
244: END;
245: --
246: -- Calling Pre Vertical User Hook
245: --
246: -- Calling Pre Vertical User Hook
247: BEGIN
248:
249: IF JTF_USR_HKS.Ok_to_execute( G_PKG_NAME, l_api_name, 'B', 'V' ) THEN
250: csi_gen_utility_pvt.put_line('Calling CSI_ITEM_INSTANCE_VUHK.Create_Item_Instance_Pre ..');
251: CSI_ITEM_INSTANCE_VUHK.Create_Item_Instance_Pre
252: (
253: p_api_version => 1.0
285: END IF;
286:
287: EXCEPTION
288: WHEN OTHERS THEN
289: csi_gen_utility_pvt.put_line('ERROR FROM JTF_USR_HKS.Ok_to_execute API Create Pre Vertical');
290: RAISE FND_API.G_EXC_ERROR;
291: END;
292:
293: -- End of PRE User Hooks
344: --
345: -- Calling Post Customer User Hook
346: BEGIN
347:
348: IF JTF_USR_HKS.Ok_to_execute(G_PKG_NAME, l_api_name, 'A', 'C' ) THEN
349: csi_gen_utility_pvt.put_line('Calling CSI_ITEM_INSTANCE_CUHK.Create_Item_Instance_Post ..');
350: CSI_ITEM_INSTANCE_CUHK.Create_Item_Instance_Post
351: (
352: p_api_version => 1.0
383: --
384: END IF;
385: EXCEPTION
386: WHEN OTHERS THEN
387: csi_gen_utility_pvt.put_line('ERROR FROM JTF_USR_HKS.Ok_to_execute API Create Post Customer');
388: RAISE FND_API.G_EXC_ERROR;
389: END;
390:
391:
1133:
1134: -- Calling Post Vertical User Hook
1135: BEGIN
1136:
1137: IF JTF_USR_HKS.Ok_to_execute( G_PKG_NAME, l_api_name, 'A', 'V' ) THEN
1138: csi_gen_utility_pvt.put_line('Calling CSI_ITEM_INSTANCE_VUHK.Create_Item_Instance_Post ..');
1139: CSI_ITEM_INSTANCE_VUHK.Create_Item_Instance_Post
1140: (
1141: p_api_version => 1.0
1172: --
1173: END IF;
1174: EXCEPTION
1175: WHEN OTHERS THEN
1176: csi_gen_utility_pvt.put_line('ERROR FROM JTF_USR_HKS.Ok_to_execute API Create Post Vertical');
1177: RAISE FND_API.G_EXC_ERROR;
1178: END;
1179: -- End of POST User Hooks
1180:
1581: END IF;
1582: -- End addition for MACD lock functionality
1583: -- Call Pre Customer User Hook
1584: BEGIN
1585: IF JTF_USR_HKS.Ok_to_execute(G_PKG_NAME, l_api_name, 'B', 'C' ) THEN
1586: csi_gen_utility_pvt.put_line('Calling CSI_ITEM_INSTANCE_CUHK.Update_Item_Instance_Pre ..');
1587: CSI_ITEM_INSTANCE_CUHK.Update_Item_Instance_Pre
1588: (
1589: p_api_version => 1.0
1622: END IF;
1623:
1624: EXCEPTION
1625: WHEN OTHERS THEN
1626: csi_gen_utility_pvt.put_line('ERROR FROM JTF_USR_HKS.Ok_to_execute API Update Pre Customer');
1627: RAISE FND_API.G_EXC_ERROR;
1628: END;
1629: --
1630: -- Call Pre Vertical user Hook
1628: END;
1629: --
1630: -- Call Pre Vertical user Hook
1631: BEGIN
1632: IF JTF_USR_HKS.Ok_to_execute(G_PKG_NAME, l_api_name, 'B', 'V' ) THEN
1633: csi_gen_utility_pvt.put_line('Calling CSI_ITEM_INSTANCE_VUHK.Update_Item_Instance_Pre ..');
1634: CSI_ITEM_INSTANCE_VUHK.Update_Item_Instance_Pre
1635: (
1636: p_api_version => 1.0
1667: END IF;
1668: END IF;
1669: EXCEPTION
1670: WHEN OTHERS THEN
1671: csi_gen_utility_pvt.put_line('ERROR FROM JTF_USR_HKS.Ok_to_execute API Update Pre Vertical');
1672: RAISE FND_API.G_EXC_ERROR;
1673: END;
1674: -- End of PRE User Hooks
1675: --
2107: x_return_status := l_tmp_return_status;
2108: -- Call Post Customer User Hook
2109: BEGIN
2110:
2111: IF JTF_USR_HKS.Ok_to_execute(G_PKG_NAME, l_api_name, 'A', 'C' ) THEN
2112: csi_gen_utility_pvt.put_line('Calling CSI_ITEM_INSTANCE_CUHK.Update_Item_Instance_Post ..');
2113: CSI_ITEM_INSTANCE_CUHK.Update_Item_Instance_Post
2114: (
2115: p_api_version => 1.0
2147: END IF;
2148:
2149: EXCEPTION
2150: WHEN OTHERS THEN
2151: csi_gen_utility_pvt.put_line('ERROR FROM JTF_USR_HKS.Ok_to_execute API Update Post Customer');
2152: RAISE FND_API.G_EXC_ERROR;
2153: END;
2154: --
2155: x_return_status := l_tmp_return_status;
3309: );
3310:
3311: -- Call Post Vertical user Hook
3312: BEGIN
3313: IF JTF_USR_HKS.Ok_to_execute(G_PKG_NAME, l_api_name, 'A', 'V' ) THEN
3314: csi_gen_utility_pvt.put_line('Calling CSI_ITEM_INSTANCE_VUHK.Update_Item_Instance_Post ..');
3315: CSI_ITEM_INSTANCE_VUHK.Update_Item_Instance_Post
3316: (
3317: p_api_version => 1.0
3349: END IF;
3350:
3351: EXCEPTION
3352: WHEN OTHERS THEN
3353: csi_gen_utility_pvt.put_line('ERROR FROM JTF_USR_HKS.Ok_to_execute API Update Post Vertical');
3354: RAISE FND_API.G_EXC_ERROR;
3355: END;
3356: x_return_status := l_tmp_return_status;
3357: -- End of POST User Hooks
3624: -- Start API body
3625: --
3626: -- Call Pre Customer User Hook
3627: BEGIN
3628: IF JTF_USR_HKS.Ok_to_execute(G_PKG_NAME, l_api_name, 'B', 'C' ) THEN
3629: csi_gen_utility_pvt.put_line('Calling CSI_ITEM_INSTANCE_CUHK.Expire_Item_Instance_Pre ..');
3630: CSI_ITEM_INSTANCE_CUHK.Expire_Item_Instance_Pre
3631: (
3632: p_api_version => 1.0
3657: END IF;
3658: END IF;
3659: EXCEPTION
3660: WHEN OTHERS THEN
3661: csi_gen_utility_pvt.put_line('ERROR FROM JTF_USR_HKS.Ok_to_execute API Expire Pre Customer');
3662: RAISE FND_API.G_EXC_ERROR;
3663: END;
3664: --
3665: -- Call Pre Vertical User Hook
3663: END;
3664: --
3665: -- Call Pre Vertical User Hook
3666: BEGIN
3667: IF JTF_USR_HKS.Ok_to_execute(G_PKG_NAME, l_api_name, 'B', 'V' ) THEN
3668: csi_gen_utility_pvt.put_line('Calling CSI_ITEM_INSTANCE_VUHK.Expire_Item_Instance_Pre ..');
3669: CSI_ITEM_INSTANCE_VUHK.Expire_Item_Instance_Pre
3670: (
3671: p_api_version => 1.0
3696: END IF;
3697: END IF;
3698: EXCEPTION
3699: WHEN OTHERS THEN
3700: csi_gen_utility_pvt.put_line('ERROR FROM JTF_USR_HKS.Ok_to_execute API Expire Pre Vertical');
3701: RAISE FND_API.G_EXC_ERROR;
3702: END;
3703: -- End PRE User Hooks
3704: --
3733: END IF;
3734: --
3735: -- Call Post Customer User Hook
3736: BEGIN
3737: IF JTF_USR_HKS.Ok_to_execute(G_PKG_NAME, l_api_name, 'A', 'C' ) THEN
3738: csi_gen_utility_pvt.put_line('Calling CSI_ITEM_INSTANCE_CUHK.Expire_Item_Instance_Post ..');
3739: CSI_ITEM_INSTANCE_CUHK.Expire_Item_Instance_Post
3740: (
3741: p_api_version => 1.0
3766: END IF;
3767: END IF;
3768: EXCEPTION
3769: WHEN OTHERS THEN
3770: csi_gen_utility_pvt.put_line('ERROR FROM JTF_USR_HKS.Ok_to_execute API Expire Post Customer');
3771: RAISE FND_API.G_EXC_ERROR;
3772: END;
3773: --
3774:
4040: p_count => x_msg_count ,
4041: p_data => x_msg_data );
4042: -- Call Post Vertical User Hook
4043: BEGIN
4044: IF JTF_USR_HKS.Ok_to_execute(G_PKG_NAME, l_api_name, 'A', 'V' ) THEN
4045: csi_gen_utility_pvt.put_line('Calling CSI_ITEM_INSTANCE_VUHK.Expire_Item_Instance_Post ..');
4046: CSI_ITEM_INSTANCE_VUHK.Expire_Item_Instance_Post
4047: (
4048: p_api_version => 1.0
4073: END IF;
4074: END IF;
4075: EXCEPTION
4076: WHEN OTHERS THEN
4077: csi_gen_utility_pvt.put_line('ERROR FROM JTF_USR_HKS.Ok_to_execute API Expire Post Vertical');
4078: RAISE FND_API.G_EXC_ERROR;
4079: END;
4080: -- End of POST User Hooks
4081: