DBA Data[Home] [Help]

APPS.AHL_DI_SUBSCRIPTION_PVT dependencies on STANDARD

Line 518: -- Standard Start of API savepoint

514: -- Added pjha 15-May-2002 for modifying 'subscribed to' Begin
515: l_subscribe_to_flag VARCHAR2(1);
516: -- Added pjha 15-May-2002 for modifying 'subscribed to' End
517: BEGIN
518: -- Standard Start of API savepoint
519: SAVEPOINT create_subscription;
520:
521: -- Check if API is called in debug mode. If yes, enable debug.
522: IF G_DEBUG='Y' THEN

Line 533: -- Standard call to check for call compatibility.

529: AHL_DEBUG_PUB.debug( 'enter ahl_di_subscription_pvt.Create Subscription','+SUB+');
530:
531: END IF;
532: END IF;
533: -- Standard call to check for call compatibility.
534: IF FND_API.to_boolean(p_init_msg_list)
535: THEN
536: FND_MSG_PUB.initialize;
537: END IF;

Line 569: -- Standard call to get message count and if count is get message info.

565: p_purchase_order_no =>p_x_subscription_tbl(i).purchase_order_no,
566: p_delete_flag =>p_x_subscription_tbl(i).delete_flag
567: );
568: END LOOP;
569: -- Standard call to get message count and if count is get message info.
570: l_msg_count := FND_MSG_PUB.count_msg;
571:
572: IF l_msg_count > 0 THEN
573: X_msg_count := l_msg_count;

Line 803: -- Standard check of p_commit.

799: END IF;
800: END IF;
801: END LOOP;
802: END IF;
803: -- Standard check of p_commit.
804: IF FND_API.TO_BOOLEAN(p_commit) THEN
805: COMMIT;
806: END IF;
807: -- Debug info

Line 1028: -- Standard Start of API savepoint

1024: -- Added pjha 28-Jun-2002 for modifying 'subscribed to' End
1025:
1026: --
1027: BEGIN
1028: -- Standard Start of API savepoint
1029: SAVEPOINT modify_subscription;
1030: -- Check if API is called in debug mode. If yes, enable debug.
1031: IF G_DEBUG='Y' THEN
1032: AHL_DEBUG_PUB.enable_debug;

Line 1039: -- Standard call to check for call compatibility.

1035: -- Debug info.
1036: IF G_DEBUG='Y' THEN
1037: AHL_DEBUG_PUB.debug( 'enter ahl_di_subscription_pvt.Modify Subscription','+SUB+');
1038: END IF;
1039: -- Standard call to check for call compatibility.
1040: IF FND_API.to_boolean(p_init_msg_list)
1041: THEN
1042: FND_MSG_PUB.initialize;
1043: END IF;

Line 1157: -- Standard call to get message count

1153: CLOSE get_old_sub;
1154: END IF;
1155: END LOOP;
1156: --End of Validations
1157: -- Standard call to get message count
1158: l_msg_count := FND_MSG_PUB.count_msg;
1159:
1160: IF l_msg_count > 0 THEN
1161: X_msg_count := l_msg_count;

Line 1388: -- Standard check of p_commit.

1384:
1385: END IF;
1386: END LOOP;
1387: END IF;
1388: -- Standard check of p_commit.
1389: IF FND_API.TO_BOOLEAN(p_commit) THEN
1390: COMMIT;
1391: END IF;
1392: -- Debug info

Line 1502: -- Standard Start of API savepoint

1498: l_object_version_number NUMBER;
1499: l_end_date DATE;
1500: l_start_date DATE;
1501: BEGIN
1502: -- Standard Start of API savepoint
1503: SAVEPOINT delete_subscriptions;
1504: -- Standard call to check for call compatibility.
1505: IF FND_API.to_boolean(p_init_msg_list)
1506: THEN

Line 1504: -- Standard call to check for call compatibility.

1500: l_start_date DATE;
1501: BEGIN
1502: -- Standard Start of API savepoint
1503: SAVEPOINT delete_subscriptions;
1504: -- Standard call to check for call compatibility.
1505: IF FND_API.to_boolean(p_init_msg_list)
1506: THEN
1507: FND_MSG_PUB.initialize;
1508: END IF;

Line 1587: -- Standard check of p_commit.

1583: -- Modified pjha 14-Jun-2002 for deleting the row: End
1584: END LOOP;
1585: -- Modified pjha 15-May-2002 for modifying 'subscribed to' End
1586: END IF;
1587: -- Standard check of p_commit.
1588: IF FND_API.TO_BOOLEAN(p_commit) THEN
1589: COMMIT;
1590: END IF;
1591: