436:
437:
438: /*------------------------------------------------------------------------*/
439: /* procedure name: AHL_DI_SUBSCRIPTION_CUHK.CREATE_SUBSCRIPTION_PRE */
440: /* AHL_DI_SUBSCRIPTION_VUHK.CREATE_SUBSCRIPTION_PRE */
441: /* description : Added by siddhartha to call User Hooks */
442: /* Date : Dec 20 2001 */
443: /*------------------------------------------------------------------------*/
444:
470:
471: IF JTF_USR_HKS.Ok_to_Execute( 'AHL_DI_SUBSCRIPTION_PUB','CREATE_SUBSCRIPTION',
472: 'B', 'V' ) then
473: IF G_DEBUG='Y' THEN
474: AHL_DEBUG_PUB.debug( 'Start AHL_DI_SUBSCRIPTION_VUHK.CREATE_SUBSCRIPTION_Pre');
475:
476: END IF;
477: AHL_DI_SUBSCRIPTION_VUHK.CREATE_SUBSCRIPTION_Pre(
478: P_X_SUBSCRIPTION_TBL => l_subscription_tbl,
473: IF G_DEBUG='Y' THEN
474: AHL_DEBUG_PUB.debug( 'Start AHL_DI_SUBSCRIPTION_VUHK.CREATE_SUBSCRIPTION_Pre');
475:
476: END IF;
477: AHL_DI_SUBSCRIPTION_VUHK.CREATE_SUBSCRIPTION_Pre(
478: P_X_SUBSCRIPTION_TBL => l_subscription_tbl,
479: X_RETURN_STATUS => l_return_status ,
480: X_MSG_COUNT => l_msg_count ,
481: X_MSG_DATA => l_msg_data );
480: X_MSG_COUNT => l_msg_count ,
481: X_MSG_DATA => l_msg_data );
482:
483: IF G_DEBUG='Y' THEN
484: AHL_DEBUG_PUB.debug( 'END AHL_DI_SUBSCRIPTION_VUHK.CREATE_SUBSCRIPTION_Pre');
485:
486: END IF;
487:
488: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
547: END IF;
548:
549:
550: /*------------------------------------------------------------------------*/
551: /* procedure name: AHL_DI_SUBSCRIPTION_VUHK.CREATE_SUBSCRIPTION_Post */
552: /* AHL_DI_SUBSCRIPTION_CUHK.CREATE_SUBSCRIPTION_Post */
553: /* description : Added by siddhartha to call User Hooks */
554: /* Date : Dec 20 2001 */
555: /*------------------------------------------------------------------------*/
558: IF JTF_USR_HKS.Ok_to_Execute( 'AHL_DI_SUBSCRIPTION_PUB','CREATE_SUBSCRIPTION',
559: 'A', 'V' ) then
560:
561: IF G_DEBUG='Y' THEN
562: AHL_DEBUG_PUB.debug( 'Start AHL_DI_SUBSCRIPTION_VUHK.CREATE_SUBSCRIPTION_Post');
563:
564: END IF;
565:
566: AHL_DI_SUBSCRIPTION_VUHK.CREATE_SUBSCRIPTION_Post(
562: AHL_DEBUG_PUB.debug( 'Start AHL_DI_SUBSCRIPTION_VUHK.CREATE_SUBSCRIPTION_Post');
563:
564: END IF;
565:
566: AHL_DI_SUBSCRIPTION_VUHK.CREATE_SUBSCRIPTION_Post(
567: P_SUBSCRIPTION_TBL => l_subscription_tbl,
568: X_RETURN_STATUS => l_return_status ,
569: X_MSG_COUNT => l_msg_count ,
570: X_MSG_DATA => l_msg_data );
569: X_MSG_COUNT => l_msg_count ,
570: X_MSG_DATA => l_msg_data );
571:
572: IF G_DEBUG='Y' THEN
573: AHL_DEBUG_PUB.debug( 'End AHL_DI_SUBSCRIPTION_VUHK.CREATE_SUBSCRIPTION_Post');
574:
575: END IF;
576:
577:
1103:
1104:
1105: /*------------------------------------------------------------------------*/
1106: /* procedure name: AHL_DI_SUBSCRIPTION_CUHK.MODIFY_SUBSCRIPTION_PRE */
1107: /* AHL_DI_SUBSCRIPTION_VUHK.MODIFY_SUBSCRIPTION_PRE */
1108: /* description : Added by siddhartha to call User Hooks */
1109: /* Date : Dec 20 2001 */
1110: /*------------------------------------------------------------------------*/
1111:
1136:
1137: IF JTF_USR_HKS.Ok_to_Execute( 'AHL_DI_SUBSCRIPTION_PUB','MODIFY_SUBSCRIPTION',
1138: 'B', 'V' ) then
1139: IF G_DEBUG='Y' THEN
1140: AHL_DEBUG_PUB.debug( 'Start AHL_DI_SUBSCRIPTION_VUHK.MODIFY_SUBSCRIPTION_Pre');
1141:
1142: END IF;
1143:
1144: AHL_DI_SUBSCRIPTION_VUHK.MODIFY_SUBSCRIPTION_Pre(
1140: AHL_DEBUG_PUB.debug( 'Start AHL_DI_SUBSCRIPTION_VUHK.MODIFY_SUBSCRIPTION_Pre');
1141:
1142: END IF;
1143:
1144: AHL_DI_SUBSCRIPTION_VUHK.MODIFY_SUBSCRIPTION_Pre(
1145: P_X_SUBSCRIPTION_TBL => l_subscription_tbl,
1146: X_RETURN_STATUS => l_return_status ,
1147: X_MSG_COUNT => l_msg_count ,
1148: X_MSG_DATA => l_msg_data );
1147: X_MSG_COUNT => l_msg_count ,
1148: X_MSG_DATA => l_msg_data );
1149:
1150: IF G_DEBUG='Y' THEN
1151: AHL_DEBUG_PUB.debug( 'End AHL_DI_SUBSCRIPTION_VUHK.MODIFY_SUBSCRIPTION_Pre');
1152:
1153: END IF;
1154:
1155: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1210: END IF;
1211: END IF;
1212:
1213: /*------------------------------------------------------------------------*/
1214: /* procedure name: AHL_DI_SUBSCRIPTION_VUHK.MODIFY_SUBSCRIPTION_Post */
1215: /* AHL_DI_SUBSCRIPTION_CUHK.MODIFY_SUBSCRIPTION_Post */
1216: /* description : Added by siddhartha to call User Hooks */
1217: /* Date : Dec 20 2001 */
1218: /*------------------------------------------------------------------------*/
1220:
1221: IF JTF_USR_HKS.Ok_to_Execute( 'AHL_DI_SUBSCRIPTION_PUB','MODIFY_SUBSCRIPTION',
1222: 'A', 'V' ) then
1223: IF G_DEBUG='Y' THEN
1224: AHL_DEBUG_PUB.debug( 'Start AHL_DI_SUBSCRIPTION_VUHK.MODIFY_SUBSCRIPTION_Post');
1225:
1226: END IF;
1227:
1228: AHL_DI_SUBSCRIPTION_VUHK.MODIFY_SUBSCRIPTION_Post(
1224: AHL_DEBUG_PUB.debug( 'Start AHL_DI_SUBSCRIPTION_VUHK.MODIFY_SUBSCRIPTION_Post');
1225:
1226: END IF;
1227:
1228: AHL_DI_SUBSCRIPTION_VUHK.MODIFY_SUBSCRIPTION_Post(
1229: P_SUBSCRIPTION_TBL => l_subscription_tbl,
1230: X_RETURN_STATUS => l_return_status ,
1231: X_MSG_COUNT => l_msg_count ,
1232: X_MSG_DATA => l_msg_data );
1231: X_MSG_COUNT => l_msg_count ,
1232: X_MSG_DATA => l_msg_data );
1233:
1234: IF G_DEBUG='Y' THEN
1235: AHL_DEBUG_PUB.debug( 'End AHL_DI_SUBSCRIPTION_VUHK.MODIFY_SUBSCRIPTION_Post');
1236:
1237: END IF;
1238:
1239: IF l_return_status = FND_API.G_RET_STS_ERROR THEN