eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AHL_DI_SUBSCRIPTION_PUB dependencies on AHL_DEBUG_PUB

Line 13: G_DEBUG VARCHAR2(1) := AHL_DEBUG_PUB.is_log_enabled;

9: /* */
10: /*-----------------------------------------------------------*/
11:
12: --G_DEBUG VARCHAR2(1):=FND_PROFILE.VALUE('AHL_API_FILE_DEBUG_ON');
13: G_DEBUG VARCHAR2(1) := AHL_DEBUG_PUB.is_log_enabled;
14:
15: PROCEDURE Check_lookup_name_Or_Id
16: ( p_lookup_type IN FND_LOOKUPS.lookup_type%TYPE,
17: p_lookup_code IN FND_LOOKUPS.lookup_code%TYPE ,

Line 154: AHL_DEBUG_PUB.enable_debug;

150: -- Standard Start of API savepoint
151: SAVEPOINT create_subscription;
152: -- Check if API is called in debug mode. If yes, enable debug.
153: IF G_DEBUG='Y' THEN
154: AHL_DEBUG_PUB.enable_debug;
155:
156: END IF;
157: -- Debug info.
158: IF G_DEBUG='Y' THEN

Line 160: AHL_DEBUG_PUB.debug( 'enter ahl_di_subscription_pub.Create Subscription','+SUB+');

156: END IF;
157: -- Debug info.
158: IF G_DEBUG='Y' THEN
159: IF G_DEBUG='Y' THEN
160: AHL_DEBUG_PUB.debug( 'enter ahl_di_subscription_pub.Create Subscription','+SUB+');
161:
162: END IF;
163: END IF;
164: -- Standard call to check for call compatibility.

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 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 474: AHL_DEBUG_PUB.debug( 'Start AHL_DI_SUBSCRIPTION_VUHK.CREATE_SUBSCRIPTION_Pre');

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,

Line 484: AHL_DEBUG_PUB.debug( 'END AHL_DI_SUBSCRIPTION_VUHK.CREATE_SUBSCRIPTION_Pre');

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

Line 562: AHL_DEBUG_PUB.debug( 'Start AHL_DI_SUBSCRIPTION_VUHK.CREATE_SUBSCRIPTION_Post');

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(

Line 573: AHL_DEBUG_PUB.debug( 'End AHL_DI_SUBSCRIPTION_VUHK.CREATE_SUBSCRIPTION_Post');

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:

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 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 622: AHL_DEBUG_PUB.debug( 'End of public api Create Subscription','+SUB+');

618: COMMIT;
619: END IF;
620: -- Debug info
621: IF G_DEBUG='Y' THEN
622: AHL_DEBUG_PUB.debug( 'End of public api Create Subscription','+SUB+');
623:
624: END IF;
625: -- Check if API is called in debug mode. If yes, disable debug.
626: IF G_DEBUG='Y' THEN

Line 627: AHL_DEBUG_PUB.disable_debug;

623:
624: END IF;
625: -- Check if API is called in debug mode. If yes, disable debug.
626: IF G_DEBUG='Y' THEN
627: AHL_DEBUG_PUB.disable_debug;
628:
629: END IF;
630:
631: EXCEPTION

Line 639: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'ERROR' );

635: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
636: p_count => x_msg_count,
637: p_data => x_msg_data);
638: IF G_DEBUG='Y' THEN
639: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'ERROR' );
640: AHL_DEBUG_PUB.debug( 'ahl_di_subscription_pub.Create Subscription','+SUB+');
641:
642:
643: -- Check if API is called in debug mode. If yes, disable debug.

Line 640: AHL_DEBUG_PUB.debug( 'ahl_di_subscription_pub.Create Subscription','+SUB+');

636: p_count => x_msg_count,
637: p_data => x_msg_data);
638: IF G_DEBUG='Y' THEN
639: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'ERROR' );
640: AHL_DEBUG_PUB.debug( 'ahl_di_subscription_pub.Create Subscription','+SUB+');
641:
642:
643: -- Check if API is called in debug mode. If yes, disable debug.
644: AHL_DEBUG_PUB.disable_debug;

Line 644: AHL_DEBUG_PUB.disable_debug;

640: AHL_DEBUG_PUB.debug( 'ahl_di_subscription_pub.Create Subscription','+SUB+');
641:
642:
643: -- Check if API is called in debug mode. If yes, disable debug.
644: AHL_DEBUG_PUB.disable_debug;
645:
646: END IF;
647:
648: WHEN FND_API.G_EXC_ERROR THEN

Line 656: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );

652: p_count => x_msg_count,
653: p_data => X_msg_data);
654: -- Debug info.
655: IF G_DEBUG='Y' THEN
656: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
657: AHL_DEBUG_PUB.debug( 'ahl_di_subscription_pub.Create Subscription','+SUB+');
658:
659:
660: -- Check if API is called in debug mode. If yes, disable debug.

Line 657: AHL_DEBUG_PUB.debug( 'ahl_di_subscription_pub.Create Subscription','+SUB+');

653: p_data => X_msg_data);
654: -- Debug info.
655: IF G_DEBUG='Y' THEN
656: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
657: AHL_DEBUG_PUB.debug( 'ahl_di_subscription_pub.Create Subscription','+SUB+');
658:
659:
660: -- Check if API is called in debug mode. If yes, disable debug.
661: AHL_DEBUG_PUB.disable_debug;

Line 661: AHL_DEBUG_PUB.disable_debug;

657: AHL_DEBUG_PUB.debug( 'ahl_di_subscription_pub.Create Subscription','+SUB+');
658:
659:
660: -- Check if API is called in debug mode. If yes, disable debug.
661: AHL_DEBUG_PUB.disable_debug;
662:
663: END IF;
664:
665: WHEN OTHERS THEN

Line 680: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'SQL ERROR' );

676: p_data => X_msg_data);
677:
678: -- Debug info.
679: IF G_DEBUG='Y' THEN
680: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'SQL ERROR' );
681: AHL_DEBUG_PUB.debug( 'ahl_di_subscription_pub.Create Subscription','+SUB+');
682:
683:
684: -- Check if API is called in debug mode. If yes, disable debug.

Line 681: AHL_DEBUG_PUB.debug( 'ahl_di_subscription_pub.Create Subscription','+SUB+');

677:
678: -- Debug info.
679: IF G_DEBUG='Y' THEN
680: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'SQL ERROR' );
681: AHL_DEBUG_PUB.debug( 'ahl_di_subscription_pub.Create Subscription','+SUB+');
682:
683:
684: -- Check if API is called in debug mode. If yes, disable debug.
685: AHL_DEBUG_PUB.disable_debug;

Line 685: AHL_DEBUG_PUB.disable_debug;

681: AHL_DEBUG_PUB.debug( 'ahl_di_subscription_pub.Create Subscription','+SUB+');
682:
683:
684: -- Check if API is called in debug mode. If yes, disable debug.
685: AHL_DEBUG_PUB.disable_debug;
686:
687: END IF;
688:
689: END CREATE_SUBSCRIPTION;

Line 804: AHL_DEBUG_PUB.enable_debug;

800: -- Standard Start of API savepoint
801: SAVEPOINT modify_subscription;
802: -- Check if API is called in debug mode. If yes, enable debug.
803: IF G_DEBUG='Y' THEN
804: AHL_DEBUG_PUB.enable_debug;
805:
806: END IF;
807: -- Debug info.
808: IF G_DEBUG='Y' THEN

Line 810: AHL_DEBUG_PUB.debug( 'enter ahl_di_subscription_pub.Modify Subscription','+SUB+');

806: END IF;
807: -- Debug info.
808: IF G_DEBUG='Y' THEN
809: IF G_DEBUG='Y' THEN
810: AHL_DEBUG_PUB.debug( 'enter ahl_di_subscription_pub.Modify Subscription','+SUB+');
811:
812: END IF;
813: END IF;
814: -- Standard call to check for call compatibility.

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 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 1140: AHL_DEBUG_PUB.debug( 'Start AHL_DI_SUBSCRIPTION_VUHK.MODIFY_SUBSCRIPTION_Pre');

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(

Line 1151: AHL_DEBUG_PUB.debug( 'End AHL_DI_SUBSCRIPTION_VUHK.MODIFY_SUBSCRIPTION_Pre');

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

Line 1224: AHL_DEBUG_PUB.debug( 'Start AHL_DI_SUBSCRIPTION_VUHK.MODIFY_SUBSCRIPTION_Post');

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(

Line 1235: AHL_DEBUG_PUB.debug( 'End AHL_DI_SUBSCRIPTION_VUHK.MODIFY_SUBSCRIPTION_Post');

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

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 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

Line 1284: AHL_DEBUG_PUB.debug( 'End of public api Modify Subscription','+SUB+');

1280:
1281:
1282: -- Debug info
1283: IF G_DEBUG='Y' THEN
1284: AHL_DEBUG_PUB.debug( 'End of public api Modify Subscription','+SUB+');
1285:
1286: END IF;
1287: -- Check if API is called in debug mode. If yes, disable debug.
1288: IF G_DEBUG='Y' THEN

Line 1289: AHL_DEBUG_PUB.disable_debug;

1285:
1286: END IF;
1287: -- Check if API is called in debug mode. If yes, disable debug.
1288: IF G_DEBUG='Y' THEN
1289: AHL_DEBUG_PUB.disable_debug;
1290:
1291: END IF;
1292:
1293: EXCEPTION

Line 1301: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'ERROR' );

1297: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
1298: p_count => x_msg_count,
1299: p_data => x_msg_data);
1300: IF G_DEBUG='Y' THEN
1301: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'ERROR' );
1302: AHL_DEBUG_PUB.debug( 'ahl_di_subscription_pub.Modify Subscription','+SUB+');
1303:
1304:
1305: -- Check if API is called in debug mode. If yes, disable debug.

Line 1302: AHL_DEBUG_PUB.debug( 'ahl_di_subscription_pub.Modify Subscription','+SUB+');

1298: p_count => x_msg_count,
1299: p_data => x_msg_data);
1300: IF G_DEBUG='Y' THEN
1301: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'ERROR' );
1302: AHL_DEBUG_PUB.debug( 'ahl_di_subscription_pub.Modify Subscription','+SUB+');
1303:
1304:
1305: -- Check if API is called in debug mode. If yes, disable debug.
1306: AHL_DEBUG_PUB.disable_debug;

Line 1306: AHL_DEBUG_PUB.disable_debug;

1302: AHL_DEBUG_PUB.debug( 'ahl_di_subscription_pub.Modify Subscription','+SUB+');
1303:
1304:
1305: -- Check if API is called in debug mode. If yes, disable debug.
1306: AHL_DEBUG_PUB.disable_debug;
1307:
1308: END IF;
1309:
1310: WHEN FND_API.G_EXC_ERROR THEN

Line 1318: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );

1314: p_count => x_msg_count,
1315: p_data => X_msg_data);
1316: -- Debug info.
1317: IF G_DEBUG='Y' THEN
1318: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
1319: AHL_DEBUG_PUB.debug( 'ahl_di_subscription_pub.Modify Subscription','+SUB+');
1320:
1321:
1322: -- Check if API is called in debug mode. If yes, disable debug.

Line 1319: AHL_DEBUG_PUB.debug( 'ahl_di_subscription_pub.Modify Subscription','+SUB+');

1315: p_data => X_msg_data);
1316: -- Debug info.
1317: IF G_DEBUG='Y' THEN
1318: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
1319: AHL_DEBUG_PUB.debug( 'ahl_di_subscription_pub.Modify Subscription','+SUB+');
1320:
1321:
1322: -- Check if API is called in debug mode. If yes, disable debug.
1323: AHL_DEBUG_PUB.disable_debug;

Line 1323: AHL_DEBUG_PUB.disable_debug;

1319: AHL_DEBUG_PUB.debug( 'ahl_di_subscription_pub.Modify Subscription','+SUB+');
1320:
1321:
1322: -- Check if API is called in debug mode. If yes, disable debug.
1323: AHL_DEBUG_PUB.disable_debug;
1324:
1325: END IF;
1326:
1327: WHEN OTHERS THEN

Line 1342: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'SQL ERROR' );

1338: p_data => X_msg_data);
1339:
1340: -- Debug info.
1341: IF G_DEBUG='Y' THEN
1342: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'SQL ERROR' );
1343: AHL_DEBUG_PUB.debug( 'ahl_di_subscription_pub.Modify Subscription','+SUB+');
1344:
1345:
1346: -- Check if API is called in debug mode. If yes, disable debug.

Line 1343: AHL_DEBUG_PUB.debug( 'ahl_di_subscription_pub.Modify Subscription','+SUB+');

1339:
1340: -- Debug info.
1341: IF G_DEBUG='Y' THEN
1342: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'SQL ERROR' );
1343: AHL_DEBUG_PUB.debug( 'ahl_di_subscription_pub.Modify Subscription','+SUB+');
1344:
1345:
1346: -- Check if API is called in debug mode. If yes, disable debug.
1347: AHL_DEBUG_PUB.disable_debug;

Line 1347: AHL_DEBUG_PUB.disable_debug;

1343: AHL_DEBUG_PUB.debug( 'ahl_di_subscription_pub.Modify Subscription','+SUB+');
1344:
1345:
1346: -- Check if API is called in debug mode. If yes, disable debug.
1347: AHL_DEBUG_PUB.disable_debug;
1348:
1349: END IF;
1350:
1351: END MODIFY_SUBSCRIPTION;