DBA Data[Home] [Help]

APPS.AHL_DI_SUBSCRIPTION_PUB dependencies on AHL_DI_SUBSCRIPTION_CUHK

Line 439: /* procedure name: AHL_DI_SUBSCRIPTION_CUHK.CREATE_SUBSCRIPTION_PRE */

435: END IF;
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: /*------------------------------------------------------------------------*/

Line 449: AHL_DEBUG_PUB.debug( 'Start AHL_DI_SUBSCRIPTION_CUHK.CREATE_SUBSCRIPTION_Pre');

445: IF JTF_USR_HKS.Ok_to_Execute( 'AHL_DI_SUBSCRIPTION_PUB','CREATE_SUBSCRIPTION',
446: 'B', 'C' ) then
447:
448: IF G_DEBUG='Y' THEN
449: AHL_DEBUG_PUB.debug( 'Start AHL_DI_SUBSCRIPTION_CUHK.CREATE_SUBSCRIPTION_Pre');
450:
451: END IF;
452: AHL_DI_SUBSCRIPTION_CUHK.CREATE_SUBSCRIPTION_Pre(
453: P_X_SUBSCRIPTION_TBL => l_subscription_tbl,

Line 452: AHL_DI_SUBSCRIPTION_CUHK.CREATE_SUBSCRIPTION_Pre(

448: IF G_DEBUG='Y' THEN
449: AHL_DEBUG_PUB.debug( 'Start AHL_DI_SUBSCRIPTION_CUHK.CREATE_SUBSCRIPTION_Pre');
450:
451: END IF;
452: AHL_DI_SUBSCRIPTION_CUHK.CREATE_SUBSCRIPTION_Pre(
453: P_X_SUBSCRIPTION_TBL => l_subscription_tbl,
454: X_RETURN_STATUS => l_return_status ,
455: X_MSG_COUNT => l_msg_count ,
456: X_MSG_DATA => l_msg_data );

Line 459: AHL_DEBUG_PUB.debug( 'End AHL_DI_SUBSCRIPTION_CUHK.CREATE_SUBSCRIPTION_Pre');

455: X_MSG_COUNT => l_msg_count ,
456: X_MSG_DATA => l_msg_data );
457:
458: IF G_DEBUG='Y' THEN
459: AHL_DEBUG_PUB.debug( 'End AHL_DI_SUBSCRIPTION_CUHK.CREATE_SUBSCRIPTION_Pre');
460:
461: END IF;
462:
463: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

Line 552: /* AHL_DI_SUBSCRIPTION_CUHK.CREATE_SUBSCRIPTION_Post */

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: /*------------------------------------------------------------------------*/
556:

Line 588: AHL_DEBUG_PUB.debug( 'Start AHL_DI_SUBSCRIPTION_CUHK.CREATE_SUBSCRIPTION_Post');

584:
585: IF JTF_USR_HKS.Ok_to_Execute( 'AHL_DI_SUBSCRIPTION_PUB','CREATE_SUBSCRIPTION',
586: 'A', 'C' ) then
587: IF G_DEBUG='Y' THEN
588: AHL_DEBUG_PUB.debug( 'Start AHL_DI_SUBSCRIPTION_CUHK.CREATE_SUBSCRIPTION_Post');
589:
590: END IF;
591: AHL_DI_SUBSCRIPTION_CUHK.CREATE_SUBSCRIPTION_Post(
592: P_SUBSCRIPTION_TBL => l_subscription_tbl,

Line 591: AHL_DI_SUBSCRIPTION_CUHK.CREATE_SUBSCRIPTION_Post(

587: IF G_DEBUG='Y' THEN
588: AHL_DEBUG_PUB.debug( 'Start AHL_DI_SUBSCRIPTION_CUHK.CREATE_SUBSCRIPTION_Post');
589:
590: END IF;
591: AHL_DI_SUBSCRIPTION_CUHK.CREATE_SUBSCRIPTION_Post(
592: P_SUBSCRIPTION_TBL => l_subscription_tbl,
593: X_RETURN_STATUS => l_return_status ,
594: X_MSG_COUNT => l_msg_count ,
595: X_MSG_DATA => l_msg_data );

Line 598: AHL_DEBUG_PUB.debug( 'End AHL_DI_SUBSCRIPTION_CUHK.CREATE_SUBSCRIPTION_Post');

594: X_MSG_COUNT => l_msg_count ,
595: X_MSG_DATA => l_msg_data );
596:
597: IF G_DEBUG='Y' THEN
598: AHL_DEBUG_PUB.debug( 'End AHL_DI_SUBSCRIPTION_CUHK.CREATE_SUBSCRIPTION_Post');
599:
600: END IF;
601:
602: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

Line 1106: /* procedure name: AHL_DI_SUBSCRIPTION_CUHK.MODIFY_SUBSCRIPTION_PRE */

1102: END IF;
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: /*------------------------------------------------------------------------*/

Line 1115: AHL_DEBUG_PUB.debug( 'Start AHL_DI_SUBSCRIPTION_CUHK.MODIFY_SUBSCRIPTION_Pre');

1111:
1112: IF JTF_USR_HKS.Ok_to_Execute( 'AHL_DI_SUBSCRIPTION_PUB','MODIFY_SUBSCRIPTION',
1113: 'B', 'C' ) then
1114: IF G_DEBUG='Y' THEN
1115: AHL_DEBUG_PUB.debug( 'Start AHL_DI_SUBSCRIPTION_CUHK.MODIFY_SUBSCRIPTION_Pre');
1116:
1117: END IF;
1118: AHL_DI_SUBSCRIPTION_CUHK.MODIFY_SUBSCRIPTION_Pre(
1119: P_X_SUBSCRIPTION_TBL => l_subscription_tbl,

Line 1118: AHL_DI_SUBSCRIPTION_CUHK.MODIFY_SUBSCRIPTION_Pre(

1114: IF G_DEBUG='Y' THEN
1115: AHL_DEBUG_PUB.debug( 'Start AHL_DI_SUBSCRIPTION_CUHK.MODIFY_SUBSCRIPTION_Pre');
1116:
1117: END IF;
1118: AHL_DI_SUBSCRIPTION_CUHK.MODIFY_SUBSCRIPTION_Pre(
1119: P_X_SUBSCRIPTION_TBL => l_subscription_tbl,
1120: X_RETURN_STATUS => l_return_status ,
1121: X_MSG_COUNT => l_msg_count ,
1122: X_MSG_DATA => l_msg_data );

Line 1126: AHL_DEBUG_PUB.debug( 'End AHL_DI_SUBSCRIPTION_CUHK.MODIFY_SUBSCRIPTION_Pre');

1122: X_MSG_DATA => l_msg_data );
1123:
1124:
1125: IF G_DEBUG='Y' THEN
1126: AHL_DEBUG_PUB.debug( 'End AHL_DI_SUBSCRIPTION_CUHK.MODIFY_SUBSCRIPTION_Pre');
1127:
1128: END IF;
1129:
1130: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

Line 1215: /* AHL_DI_SUBSCRIPTION_CUHK.MODIFY_SUBSCRIPTION_Post */

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: /*------------------------------------------------------------------------*/
1219:

Line 1249: AHL_DEBUG_PUB.debug( 'Start AHL_DI_SUBSCRIPTION_CUHK.MODIFY_SUBSCRIPTION_Post');

1245:
1246: IF JTF_USR_HKS.Ok_to_Execute( 'AHL_DI_SUBSCRIPTION_PUB','MODIFY_SUBSCRIPTION',
1247: 'A', 'C' ) then
1248: IF G_DEBUG='Y' THEN
1249: AHL_DEBUG_PUB.debug( 'Start AHL_DI_SUBSCRIPTION_CUHK.MODIFY_SUBSCRIPTION_Post');
1250:
1251: END IF;
1252: AHL_DI_SUBSCRIPTION_CUHK.MODIFY_SUBSCRIPTION_Post(
1253: P_SUBSCRIPTION_TBL => l_subscription_tbl,

Line 1252: AHL_DI_SUBSCRIPTION_CUHK.MODIFY_SUBSCRIPTION_Post(

1248: IF G_DEBUG='Y' THEN
1249: AHL_DEBUG_PUB.debug( 'Start AHL_DI_SUBSCRIPTION_CUHK.MODIFY_SUBSCRIPTION_Post');
1250:
1251: END IF;
1252: AHL_DI_SUBSCRIPTION_CUHK.MODIFY_SUBSCRIPTION_Post(
1253: P_SUBSCRIPTION_TBL => l_subscription_tbl,
1254: X_RETURN_STATUS => l_return_status ,
1255: X_MSG_COUNT => l_msg_count ,
1256: X_MSG_DATA => l_msg_data );

Line 1259: AHL_DEBUG_PUB.debug( 'End AHL_DI_SUBSCRIPTION_CUHK.MODIFY_SUBSCRIPTION_Post');

1255: X_MSG_COUNT => l_msg_count ,
1256: X_MSG_DATA => l_msg_data );
1257:
1258: IF G_DEBUG='Y' THEN
1259: AHL_DEBUG_PUB.debug( 'End AHL_DI_SUBSCRIPTION_CUHK.MODIFY_SUBSCRIPTION_Post');
1260:
1261: END IF;
1262:
1263: IF l_return_status = FND_API.G_RET_STS_ERROR THEN