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_DOC_INDEX_PVT dependencies on AHL_DEBUG_PUB

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

1: PACKAGE BODY AHL_DI_DOC_INDEX_PVT AS
2: /* $Header: AHLVDIXB.pls 120.2 2006/02/07 03:49:04 sagarwal noship $ */
3: --
4: G_PKG_NAME VARCHAR2(30) := 'AHL_DI_DOC_INDEX_PVT';
5: G_DEBUG VARCHAR2(1):=AHL_DEBUG_PUB.is_log_enabled;
6: --
7: /* ===========================================================================
8: G_DEBUG VARCHAR2(1):=AHL_DEBUG_PUB.is_log_enabled;
9: FUNCTION NAME : get_product_install_status (x_product_name IN VARCHAR2)

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

4: G_PKG_NAME VARCHAR2(30) := 'AHL_DI_DOC_INDEX_PVT';
5: G_DEBUG VARCHAR2(1):=AHL_DEBUG_PUB.is_log_enabled;
6: --
7: /* ===========================================================================
8: G_DEBUG VARCHAR2(1):=AHL_DEBUG_PUB.is_log_enabled;
9: FUNCTION NAME : get_product_install_status (x_product_name IN VARCHAR2)
10: RETURN VARCHAR2
11:
12: DESCRIPTION : Returns the product's installation status

Line 210: AHL_DEBUG_PUB.enable_debug;

206: FND_MSG_PUB.ADD;
207: */
208: l_delete_flag := nvl(p_delete_flag, 'N');
209:
210: AHL_DEBUG_PUB.enable_debug;
211: -- Debug info.
212: IF AHL_DEBUG_PUB.G_FILE_DEBUG THEN
213: AHL_DEBUG_PUB.debug( 'enter ahl_di_doc_index_pvt.VALIDATE_DOCUMENT','+DI+');
214: END IF;

Line 212: IF AHL_DEBUG_PUB.G_FILE_DEBUG THEN

208: l_delete_flag := nvl(p_delete_flag, 'N');
209:
210: AHL_DEBUG_PUB.enable_debug;
211: -- Debug info.
212: IF AHL_DEBUG_PUB.G_FILE_DEBUG THEN
213: AHL_DEBUG_PUB.debug( 'enter ahl_di_doc_index_pvt.VALIDATE_DOCUMENT','+DI+');
214: END IF;
215: IF l_delete_flag <> 'Y'
216: THEN

Line 213: AHL_DEBUG_PUB.debug( 'enter ahl_di_doc_index_pvt.VALIDATE_DOCUMENT','+DI+');

209:
210: AHL_DEBUG_PUB.enable_debug;
211: -- Debug info.
212: IF AHL_DEBUG_PUB.G_FILE_DEBUG THEN
213: AHL_DEBUG_PUB.debug( 'enter ahl_di_doc_index_pvt.VALIDATE_DOCUMENT','+DI+');
214: END IF;
215: IF l_delete_flag <> 'Y'
216: THEN
217: IF p_document_id IS NOT NULL

Line 432: IF AHL_DEBUG_PUB.G_FILE_DEBUG THEN

428: END IF;
429:
430:
431: END IF;
432: IF AHL_DEBUG_PUB.G_FILE_DEBUG THEN
433: AHL_DEBUG_PUB.debug( 'exit ahl_di_doc_index_pvt.VALIDATE_DOCUMENT','+DI+');
434: END IF;
435: --
436: END VALIDATE_DOCUMENT;

Line 433: AHL_DEBUG_PUB.debug( 'exit ahl_di_doc_index_pvt.VALIDATE_DOCUMENT','+DI+');

429:
430:
431: END IF;
432: IF AHL_DEBUG_PUB.G_FILE_DEBUG THEN
433: AHL_DEBUG_PUB.debug( 'exit ahl_di_doc_index_pvt.VALIDATE_DOCUMENT','+DI+');
434: END IF;
435: --
436: END VALIDATE_DOCUMENT;
437: /*------------------------------------------------------*/

Line 478: AHL_DEBUG_PUB.enable_debug;

474: -- Standard Start of API savepoint
475: SAVEPOINT create_document;
476: -- Check if API is called in debug mode. If yes, enable debug.
477: IF G_DEBUG='Y' THEN
478: AHL_DEBUG_PUB.enable_debug;
479:
480: END IF;
481: -- Debug info.
482: IF G_DEBUG='Y' THEN

Line 484: AHL_DEBUG_PUB.debug( 'enter ahl_di_doc_index_pvt.create_document','+DI+');

480: END IF;
481: -- Debug info.
482: IF G_DEBUG='Y' THEN
483: IF G_DEBUG='Y' THEN
484: AHL_DEBUG_PUB.debug( 'enter ahl_di_doc_index_pvt.create_document','+DI+');
485:
486: END IF;
487: END IF;
488: -- Standard call to check for call compatibility.

Line 629: AHL_DEBUG_PUB.debug( 'Before processing Supplier Record ahl_di_doc_index_pvt.create_document','+DI+');

625: END IF;
626: -- Debug info.
627: IF G_DEBUG='Y' THEN
628: IF G_DEBUG='Y' THEN
629: AHL_DEBUG_PUB.debug( 'Before processing Supplier Record ahl_di_doc_index_pvt.create_document','+DI+');
630:
631: END IF;
632: END IF;
633: -- Checks for any suppliers exists for the document index

Line 650: AHL_DEBUG_PUB.debug( 'Before processing Recipient Record ahl_di_doc_index_pub.create_document','+DI+');

646: END IF;
647: -- Debug info.
648: IF G_DEBUG='Y' THEN
649: IF G_DEBUG='Y' THEN
650: AHL_DEBUG_PUB.debug( 'Before processing Recipient Record ahl_di_doc_index_pub.create_document','+DI+');
651:
652: END IF;
653: END IF;
654: -- Checks for any Recipients exists for the document index

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

688: p_count => x_msg_count,
689: p_data => x_msg_data);
690:
691: IF G_DEBUG='Y' THEN
692: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'ERROR' );
693: AHL_DEBUG_PUB.debug( 'ahl_di_doc_index_pvt.create document','+DI+');
694:
695:
696: -- Check if API is called in debug mode. If yes, disable debug.

Line 693: AHL_DEBUG_PUB.debug( 'ahl_di_doc_index_pvt.create document','+DI+');

689: p_data => x_msg_data);
690:
691: IF G_DEBUG='Y' THEN
692: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'ERROR' );
693: AHL_DEBUG_PUB.debug( 'ahl_di_doc_index_pvt.create document','+DI+');
694:
695:
696: -- Check if API is called in debug mode. If yes, disable debug.
697:

Line 698: AHL_DEBUG_PUB.disable_debug;

694:
695:
696: -- Check if API is called in debug mode. If yes, disable debug.
697:
698: AHL_DEBUG_PUB.disable_debug;
699:
700: END IF;
701: WHEN FND_API.G_EXC_ERROR THEN
702: ROLLBACK TO create_document;

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

705: p_count => x_msg_count,
706: p_data => X_msg_data);
707: -- Debug info.
708: IF G_DEBUG='Y' THEN
709: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
710: AHL_DEBUG_PUB.debug( 'ahl_di_doc_index_pvt.create document','+DI+');
711:
712:
713:

Line 710: AHL_DEBUG_PUB.debug( 'ahl_di_doc_index_pvt.create document','+DI+');

706: p_data => X_msg_data);
707: -- Debug info.
708: IF G_DEBUG='Y' THEN
709: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
710: AHL_DEBUG_PUB.debug( 'ahl_di_doc_index_pvt.create document','+DI+');
711:
712:
713:
714: -- Check if API is called in debug mode. If yes, disable debug.

Line 716: AHL_DEBUG_PUB.disable_debug;

712:
713:
714: -- Check if API is called in debug mode. If yes, disable debug.
715:
716: AHL_DEBUG_PUB.disable_debug;
717:
718: END IF;
719: WHEN OTHERS THEN
720: ROLLBACK TO create_document;

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

730: p_data => X_msg_data);
731:
732: -- Debug info.
733: IF G_DEBUG='Y' THEN
734: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'SQL ERROR' );
735: AHL_DEBUG_PUB.debug( 'ahl_di_doc_index_pvt.create document','+DI+');
736:
737:
738:

Line 735: AHL_DEBUG_PUB.debug( 'ahl_di_doc_index_pvt.create document','+DI+');

731:
732: -- Debug info.
733: IF G_DEBUG='Y' THEN
734: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'SQL ERROR' );
735: AHL_DEBUG_PUB.debug( 'ahl_di_doc_index_pvt.create document','+DI+');
736:
737:
738:
739: -- Check if API is called in debug mode. If yes, disable debug.

Line 741: AHL_DEBUG_PUB.disable_debug;

737:
738:
739: -- Check if API is called in debug mode. If yes, disable debug.
740:
741: AHL_DEBUG_PUB.disable_debug;
742:
743: END IF;
744: END CREATE_DOCUMENT;
745: /*------------------------------------------------------*/

Line 817: AHL_DEBUG_PUB.enable_debug;

813: SAVEPOINT modify_document;
814:
815: -- Check if API is called in debug mode. If yes, enable debug.
816: IF G_DEBUG='Y' THEN
817: AHL_DEBUG_PUB.enable_debug;
818:
819: END IF;
820: -- Debug info.
821: IF G_DEBUG='Y' THEN

Line 823: AHL_DEBUG_PUB.debug( 'enter ahl_di_doc_index_pvt.modify_document','+DI+');

819: END IF;
820: -- Debug info.
821: IF G_DEBUG='Y' THEN
822: IF G_DEBUG='Y' THEN
823: AHL_DEBUG_PUB.debug( 'enter ahl_di_doc_index_pvt.modify_document','+DI+');
824:
825: END IF;
826: END IF;
827: -- Standard call to check for call compatibility.

Line 935: AHL_DEBUG_PUB.debug( 'Before start processing Supplier Record ahl_di_doc_index_pvt.modify document','+DI+');

931: END IF;
932: -- Debug info.
933: IF G_DEBUG='Y' THEN
934: IF G_DEBUG='Y' THEN
935: AHL_DEBUG_PUB.debug( 'Before start processing Supplier Record ahl_di_doc_index_pvt.modify document','+DI+');
936:
937: END IF;
938: END IF;
939:

Line 957: AHL_DEBUG_PUB.debug( 'Before start processing Recipient Record ahl_di_doc_index_pvt.modify document','+DI+');

953: END IF;
954: -- Debug info.
955: IF G_DEBUG='Y' THEN
956: IF G_DEBUG='Y' THEN
957: AHL_DEBUG_PUB.debug( 'Before start processing Recipient Record ahl_di_doc_index_pvt.modify document','+DI+');
958:
959: END IF;
960: END IF;
961:

Line 990: AHL_DEBUG_PUB.debug( 'End of private api modify document','+DI+');

986: COMMIT;
987: END IF;
988: -- Debug info
989: IF G_DEBUG='Y' THEN
990: AHL_DEBUG_PUB.debug( 'End of private api modify document','+DI+');
991:
992: END IF;
993: -- Check if API is called in debug mode. If yes, disable debug.
994: IF G_DEBUG='Y' THEN

Line 995: AHL_DEBUG_PUB.disable_debug;

991:
992: END IF;
993: -- Check if API is called in debug mode. If yes, disable debug.
994: IF G_DEBUG='Y' THEN
995: AHL_DEBUG_PUB.disable_debug;
996:
997: END IF;
998:
999: EXCEPTION

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

1004: p_count => x_msg_count,
1005: p_data => x_msg_data);
1006:
1007: IF G_DEBUG='Y' THEN
1008: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'ERROR' );
1009: AHL_DEBUG_PUB.debug( 'ahl_di_doc_index_pvt.modify document','+DI+');
1010:
1011:
1012:

Line 1009: AHL_DEBUG_PUB.debug( 'ahl_di_doc_index_pvt.modify document','+DI+');

1005: p_data => x_msg_data);
1006:
1007: IF G_DEBUG='Y' THEN
1008: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'ERROR' );
1009: AHL_DEBUG_PUB.debug( 'ahl_di_doc_index_pvt.modify document','+DI+');
1010:
1011:
1012:
1013: -- Check if API is called in debug mode. If yes, disable debug.

Line 1015: AHL_DEBUG_PUB.disable_debug;

1011:
1012:
1013: -- Check if API is called in debug mode. If yes, disable debug.
1014:
1015: AHL_DEBUG_PUB.disable_debug;
1016:
1017: END IF;
1018:
1019: WHEN FND_API.G_EXC_ERROR THEN

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

1023: p_count => x_msg_count,
1024: p_data => X_msg_data);
1025: -- Debug info.
1026: IF G_DEBUG='Y' THEN
1027: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
1028: AHL_DEBUG_PUB.debug( 'ahl_di_doc_index_pvt.modify document','+DI+');
1029:
1030:
1031: -- Check if API is called in debug mode. If yes, disable debug.

Line 1028: AHL_DEBUG_PUB.debug( 'ahl_di_doc_index_pvt.modify document','+DI+');

1024: p_data => X_msg_data);
1025: -- Debug info.
1026: IF G_DEBUG='Y' THEN
1027: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
1028: AHL_DEBUG_PUB.debug( 'ahl_di_doc_index_pvt.modify document','+DI+');
1029:
1030:
1031: -- Check if API is called in debug mode. If yes, disable debug.
1032:

Line 1033: AHL_DEBUG_PUB.disable_debug;

1029:
1030:
1031: -- Check if API is called in debug mode. If yes, disable debug.
1032:
1033: AHL_DEBUG_PUB.disable_debug;
1034:
1035: END IF;
1036:
1037: WHEN OTHERS THEN

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

1048: p_data => X_msg_data);
1049:
1050: -- Debug info.
1051: IF G_DEBUG='Y' THEN
1052: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'SQL ERROR' );
1053: AHL_DEBUG_PUB.debug( 'ahl_di_doc_index_pvt.modify document','+DI+');
1054:
1055:
1056:

Line 1053: AHL_DEBUG_PUB.debug( 'ahl_di_doc_index_pvt.modify document','+DI+');

1049:
1050: -- Debug info.
1051: IF G_DEBUG='Y' THEN
1052: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'SQL ERROR' );
1053: AHL_DEBUG_PUB.debug( 'ahl_di_doc_index_pvt.modify document','+DI+');
1054:
1055:
1056:
1057: -- Check if API is called in debug mode. If yes, disable debug.

Line 1058: AHL_DEBUG_PUB.disable_debug;

1054:
1055:
1056:
1057: -- Check if API is called in debug mode. If yes, disable debug.
1058: AHL_DEBUG_PUB.disable_debug;
1059:
1060: END IF;
1061:
1062: END MODIFY_DOCUMENT;

Line 1146: AHL_DEBUG_PUB.debug( 'Fetching Installation Status of PO','+SUP+');

1142:
1143: -- Perf Bug Fix 4919011.
1144: BEGIN
1145: IF G_DEBUG='Y' THEN
1146: AHL_DEBUG_PUB.debug( 'Fetching Installation Status of PO','+SUP+');
1147: END IF;
1148: SELECT AHL_DI_DOC_INDEX_PVT.GET_PRODUCT_INSTALL_STATUS('PO')
1149: INTO l_prod_install_status
1150: FROM DUAL;

Line 1319: AHL_DEBUG_PUB.enable_debug;

1315: -- Standard Start of API savepoint
1316: SAVEPOINT create_supplier;
1317: -- Check if API is called in debug mode. If yes, enable debug.
1318: IF G_DEBUG='Y' THEN
1319: AHL_DEBUG_PUB.enable_debug;
1320: END IF;
1321: -- Debug info.
1322: IF G_DEBUG='Y' THEN
1323: AHL_DEBUG_PUB.debug( 'enter ahl_di_doc_index_pvt.Create Supplier','+SUP+');

Line 1323: AHL_DEBUG_PUB.debug( 'enter ahl_di_doc_index_pvt.Create Supplier','+SUP+');

1319: AHL_DEBUG_PUB.enable_debug;
1320: END IF;
1321: -- Debug info.
1322: IF G_DEBUG='Y' THEN
1323: AHL_DEBUG_PUB.debug( 'enter ahl_di_doc_index_pvt.Create Supplier','+SUP+');
1324: END IF;
1325:
1326: -- Standard call to check for call compatibility.
1327: IF FND_API.to_boolean(p_init_msg_list)

Line 1344: AHL_DEBUG_PUB.debug( 'Fetching Installation Status of P0','+SUP+');

1340:
1341: -- Perf Bug Fix 4919011.
1342: BEGIN
1343: IF G_DEBUG='Y' THEN
1344: AHL_DEBUG_PUB.debug( 'Fetching Installation Status of P0','+SUP+');
1345: END IF;
1346: SELECT AHL_DI_DOC_INDEX_PVT.GET_PRODUCT_INSTALL_STATUS('PO')
1347: INTO l_prod_install_status
1348: FROM DUAL;

Line 1520: AHL_DEBUG_PUB.debug( 'End of private api Create Supplier','+SUP+');

1516: COMMIT;
1517: END IF;
1518: -- Debug info
1519: IF G_DEBUG='Y' THEN
1520: AHL_DEBUG_PUB.debug( 'End of private api Create Supplier','+SUP+');
1521:
1522: END IF;
1523: -- Check if API is called in debug mode. If yes, disable debug.
1524: IF G_DEBUG='Y' THEN

Line 1525: AHL_DEBUG_PUB.disable_debug;

1521:
1522: END IF;
1523: -- Check if API is called in debug mode. If yes, disable debug.
1524: IF G_DEBUG='Y' THEN
1525: AHL_DEBUG_PUB.disable_debug;
1526:
1527: END IF;
1528:
1529: EXCEPTION

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

1534: p_count => x_msg_count,
1535: p_data => x_msg_data);
1536:
1537: IF G_DEBUG='Y' THEN
1538: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'ERROR' );
1539: AHL_DEBUG_PUB.debug( 'ahl_di_doc_index_pvt.Create Supplier','+SUP+');
1540:
1541:
1542: -- Check if API is called in debug mode. If yes, disable debug.

Line 1539: AHL_DEBUG_PUB.debug( 'ahl_di_doc_index_pvt.Create Supplier','+SUP+');

1535: p_data => x_msg_data);
1536:
1537: IF G_DEBUG='Y' THEN
1538: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'ERROR' );
1539: AHL_DEBUG_PUB.debug( 'ahl_di_doc_index_pvt.Create Supplier','+SUP+');
1540:
1541:
1542: -- Check if API is called in debug mode. If yes, disable debug.
1543:

Line 1544: AHL_DEBUG_PUB.disable_debug;

1540:
1541:
1542: -- Check if API is called in debug mode. If yes, disable debug.
1543:
1544: AHL_DEBUG_PUB.disable_debug;
1545:
1546: END IF;
1547:
1548: WHEN FND_API.G_EXC_ERROR THEN

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

1552: p_count => x_msg_count,
1553: p_data => X_msg_data);
1554: -- Debug info.
1555: IF G_DEBUG='Y' THEN
1556: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
1557: AHL_DEBUG_PUB.debug( 'ahl_di_doc_index_pub.Create Supplier','+SUP+');
1558:
1559:
1560: -- Check if API is called in debug mode. If yes, disable debug.

Line 1557: AHL_DEBUG_PUB.debug( 'ahl_di_doc_index_pub.Create Supplier','+SUP+');

1553: p_data => X_msg_data);
1554: -- Debug info.
1555: IF G_DEBUG='Y' THEN
1556: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
1557: AHL_DEBUG_PUB.debug( 'ahl_di_doc_index_pub.Create Supplier','+SUP+');
1558:
1559:
1560: -- Check if API is called in debug mode. If yes, disable debug.
1561: AHL_DEBUG_PUB.disable_debug;

Line 1561: AHL_DEBUG_PUB.disable_debug;

1557: AHL_DEBUG_PUB.debug( 'ahl_di_doc_index_pub.Create Supplier','+SUP+');
1558:
1559:
1560: -- Check if API is called in debug mode. If yes, disable debug.
1561: AHL_DEBUG_PUB.disable_debug;
1562:
1563: END IF;
1564:
1565: WHEN OTHERS THEN

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

1576: p_data => X_msg_data);
1577:
1578: -- Debug info.
1579: IF G_DEBUG='Y' THEN
1580: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'SQL ERROR' );
1581: AHL_DEBUG_PUB.debug( 'ahl_di_doc_index_pvt.Create Supplier','+SUP+');
1582:
1583:
1584: -- Check if API is called in debug mode. If yes, disable debug.

Line 1581: AHL_DEBUG_PUB.debug( 'ahl_di_doc_index_pvt.Create Supplier','+SUP+');

1577:
1578: -- Debug info.
1579: IF G_DEBUG='Y' THEN
1580: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'SQL ERROR' );
1581: AHL_DEBUG_PUB.debug( 'ahl_di_doc_index_pvt.Create Supplier','+SUP+');
1582:
1583:
1584: -- Check if API is called in debug mode. If yes, disable debug.
1585: AHL_DEBUG_PUB.disable_debug;

Line 1585: AHL_DEBUG_PUB.disable_debug;

1581: AHL_DEBUG_PUB.debug( 'ahl_di_doc_index_pvt.Create Supplier','+SUP+');
1582:
1583:
1584: -- Check if API is called in debug mode. If yes, disable debug.
1585: AHL_DEBUG_PUB.disable_debug;
1586:
1587: END IF;
1588:
1589: END CREATE_SUPPLIER;

Line 1675: AHL_DEBUG_PUB.enable_debug;

1671: -- Standard Start of API savepoint
1672: SAVEPOINT modify_supplier;
1673: -- Check if API is called in debug mode. If yes, enable debug.
1674: IF G_DEBUG='Y' THEN
1675: AHL_DEBUG_PUB.enable_debug;
1676:
1677: END IF;
1678: -- Debug info.
1679: IF G_DEBUG='Y' THEN

Line 1680: AHL_DEBUG_PUB.debug( 'anand enter ahl_di_doc_index_pvt.Modify Supplier','+SUP+');

1676:
1677: END IF;
1678: -- Debug info.
1679: IF G_DEBUG='Y' THEN
1680: AHL_DEBUG_PUB.debug( 'anand enter ahl_di_doc_index_pvt.Modify Supplier','+SUP+');
1681: END IF;
1682:
1683: -- Standard call to check for call compatibility.
1684: IF FND_API.to_boolean(p_init_msg_list)

Line 1702: AHL_DEBUG_PUB.debug( 'Fetching Installation Status of PO','+SUP+');

1698:
1699: -- Perf Bug Fix 4919011.
1700: BEGIN
1701: IF G_DEBUG='Y' THEN
1702: AHL_DEBUG_PUB.debug( 'Fetching Installation Status of PO','+SUP+');
1703: END IF;
1704: SELECT AHL_DI_DOC_INDEX_PVT.GET_PRODUCT_INSTALL_STATUS('PO')
1705: INTO l_prod_install_status
1706: FROM DUAL;

Line 1717: AHL_DEBUG_PUB.debug( ' anand enter ahl_di_doc_index_pvt.Modify Supplier before validate supplier ','+SUP+');

1713: -- Calling validate suppliers
1714: --ad
1715: IF G_DEBUG='Y' THEN
1716: IF G_DEBUG='Y' THEN
1717: AHL_DEBUG_PUB.debug( ' anand enter ahl_di_doc_index_pvt.Modify Supplier before validate supplier ','+SUP+');
1718:
1719: END IF;
1720: END IF;
1721: --ad

Line 1737: AHL_DEBUG_PUB.debug( ' anand enter ahl_di_doc_index_pvt.Modify Supplier after validate sup '||l_msg_count,'+SUP+');

1733: l_msg_count := FND_MSG_PUB.count_msg;
1734: --ad
1735: IF G_DEBUG='Y' THEN
1736: IF G_DEBUG='Y' THEN
1737: AHL_DEBUG_PUB.debug( ' anand enter ahl_di_doc_index_pvt.Modify Supplier after validate sup '||l_msg_count,'+SUP+');
1738:
1739: END IF;
1740: END IF;
1741: --ad

Line 1862: AHL_DEBUG_PUB.debug( ' anand enter ahl_di_doc_index_pvt.Modify Supplier after modify sup '||l_msg_count,'+SUP+');

1858: l_msg_count := FND_MSG_PUB.count_msg;
1859: --ad
1860: IF G_DEBUG='Y' THEN
1861: IF G_DEBUG='Y' THEN
1862: AHL_DEBUG_PUB.debug( ' anand enter ahl_di_doc_index_pvt.Modify Supplier after modify sup '||l_msg_count,'+SUP+');
1863:
1864: END IF;
1865: END IF;
1866: --ad

Line 1881: AHL_DEBUG_PUB.debug( 'End of private api Modify Supplier','+SUP+');

1877: END IF;
1878:
1879: -- Debug info
1880: IF G_DEBUG='Y' THEN
1881: AHL_DEBUG_PUB.debug( 'End of private api Modify Supplier','+SUP+');
1882:
1883: END IF;
1884: -- Check if API is called in debug mode. If yes, disable debug.
1885: IF G_DEBUG='Y' THEN

Line 1886: AHL_DEBUG_PUB.disable_debug;

1882:
1883: END IF;
1884: -- Check if API is called in debug mode. If yes, disable debug.
1885: IF G_DEBUG='Y' THEN
1886: AHL_DEBUG_PUB.disable_debug;
1887:
1888: END IF;
1889:
1890: EXCEPTION

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

1895: p_count => x_msg_count,
1896: p_data => x_msg_data);
1897:
1898: IF G_DEBUG='Y' THEN
1899: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'ERROR' );
1900: AHL_DEBUG_PUB.debug( 'ahl_di_doc_index_pvt.Modify supplier','+SUP+');
1901:
1902:
1903:

Line 1900: AHL_DEBUG_PUB.debug( 'ahl_di_doc_index_pvt.Modify supplier','+SUP+');

1896: p_data => x_msg_data);
1897:
1898: IF G_DEBUG='Y' THEN
1899: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'ERROR' );
1900: AHL_DEBUG_PUB.debug( 'ahl_di_doc_index_pvt.Modify supplier','+SUP+');
1901:
1902:
1903:
1904: -- Check if API is called in debug mode. If yes, disable debug.

Line 1905: AHL_DEBUG_PUB.disable_debug;

1901:
1902:
1903:
1904: -- Check if API is called in debug mode. If yes, disable debug.
1905: AHL_DEBUG_PUB.disable_debug;
1906:
1907: END IF;
1908:
1909: WHEN FND_API.G_EXC_ERROR THEN

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

1913: p_count => x_msg_count,
1914: p_data => X_msg_data);
1915: -- Debug info.
1916: IF G_DEBUG='Y' THEN
1917: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
1918: AHL_DEBUG_PUB.debug( 'ahl_di_doc_index_pvt.Modify Supplier','+SUP+');
1919:
1920:
1921:

Line 1918: AHL_DEBUG_PUB.debug( 'ahl_di_doc_index_pvt.Modify Supplier','+SUP+');

1914: p_data => X_msg_data);
1915: -- Debug info.
1916: IF G_DEBUG='Y' THEN
1917: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
1918: AHL_DEBUG_PUB.debug( 'ahl_di_doc_index_pvt.Modify Supplier','+SUP+');
1919:
1920:
1921:
1922: -- Check if API is called in debug mode. If yes, disable debug.

Line 1923: AHL_DEBUG_PUB.disable_debug;

1919:
1920:
1921:
1922: -- Check if API is called in debug mode. If yes, disable debug.
1923: AHL_DEBUG_PUB.disable_debug;
1924:
1925: END IF;
1926:
1927: WHEN DUP_VAL_ON_INDEX THEN

Line 1935: AHL_DEBUG_PUB.disable_debug;

1931: FND_MESSAGE.SET_TOKEN('SUPNAME',l_supplier_name);
1932: FND_MSG_PUB.ADD;
1933: -- Check if API is called in debug mode. If yes, disable debug.
1934: IF G_DEBUG='Y' THEN
1935: AHL_DEBUG_PUB.disable_debug;
1936:
1937: END IF;
1938:
1939: WHEN OTHERS THEN

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

1950: p_data => X_msg_data);
1951:
1952: -- Debug info.
1953: IF G_DEBUG='Y' THEN
1954: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'SQL ERROR' );
1955: AHL_DEBUG_PUB.debug( 'ahl_di_doc_index_pvt.Modify Supplier','+SUP+');
1956:
1957:
1958:

Line 1955: AHL_DEBUG_PUB.debug( 'ahl_di_doc_index_pvt.Modify Supplier','+SUP+');

1951:
1952: -- Debug info.
1953: IF G_DEBUG='Y' THEN
1954: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'SQL ERROR' );
1955: AHL_DEBUG_PUB.debug( 'ahl_di_doc_index_pvt.Modify Supplier','+SUP+');
1956:
1957:
1958:
1959: -- Check if API is called in debug mode. If yes, disable debug.

Line 1960: AHL_DEBUG_PUB.disable_debug;

1956:
1957:
1958:
1959: -- Check if API is called in debug mode. If yes, disable debug.
1960: AHL_DEBUG_PUB.disable_debug;
1961:
1962: END IF;
1963:
1964: END MODIFY_SUPPLIER;

Line 2044: AHL_DEBUG_PUB.enable_debug;

2040: -- Standard Start of API savepoint
2041: SAVEPOINT delete_supplier;
2042: -- Check if API is called in debug mode. If yes, enable debug.
2043: IF G_DEBUG='Y' THEN
2044: AHL_DEBUG_PUB.enable_debug;
2045:
2046: END IF;
2047: -- Debug info.
2048: IF G_DEBUG='Y' THEN

Line 2049: AHL_DEBUG_PUB.debug( 'enter ahl_di_doc_index_pvt.Delete Supplier','+SUP+');

2045:
2046: END IF;
2047: -- Debug info.
2048: IF G_DEBUG='Y' THEN
2049: AHL_DEBUG_PUB.debug( 'enter ahl_di_doc_index_pvt.Delete Supplier','+SUP+');
2050: END IF;
2051: -- Standard call to check for call compatibility.
2052: IF FND_API.to_boolean(p_init_msg_list)
2053: THEN

Line 2069: AHL_DEBUG_PUB.debug( 'Fetching Product Install Status for PO');

2065:
2066: -- Perf Bug Fix 4919011.
2067: BEGIN
2068: IF G_DEBUG='Y' THEN
2069: AHL_DEBUG_PUB.debug( 'Fetching Product Install Status for PO');
2070: END IF;
2071: SELECT AHL_DI_DOC_INDEX_PVT.GET_PRODUCT_INSTALL_STATUS('PO')
2072: INTO l_prod_install_status
2073: FROM DUAL;

Line 2146: AHL_DEBUG_PUB.debug( 'End of private api Delete Supplier','+SUP+');

2142: COMMIT;
2143: END IF;
2144: -- Debug info
2145: IF G_DEBUG='Y' THEN
2146: AHL_DEBUG_PUB.debug( 'End of private api Delete Supplier','+SUP+');
2147:
2148: END IF;
2149: -- Check if API is called in debug mode. If yes, disable debug.
2150: IF G_DEBUG='Y' THEN

Line 2151: AHL_DEBUG_PUB.disable_debug;

2147:
2148: END IF;
2149: -- Check if API is called in debug mode. If yes, disable debug.
2150: IF G_DEBUG='Y' THEN
2151: AHL_DEBUG_PUB.disable_debug;
2152:
2153: END IF;
2154:
2155: EXCEPTION

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

2160: p_count => x_msg_count,
2161: p_data => x_msg_data);
2162:
2163: IF G_DEBUG='Y' THEN
2164: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'ERROR' );
2165: AHL_DEBUG_PUB.debug( 'ahl_di_doc_index_pvt.delete Supplier','+SUP+');
2166:
2167:
2168: -- Check if API is called in debug mode. If yes, disable debug.

Line 2165: AHL_DEBUG_PUB.debug( 'ahl_di_doc_index_pvt.delete Supplier','+SUP+');

2161: p_data => x_msg_data);
2162:
2163: IF G_DEBUG='Y' THEN
2164: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'ERROR' );
2165: AHL_DEBUG_PUB.debug( 'ahl_di_doc_index_pvt.delete Supplier','+SUP+');
2166:
2167:
2168: -- Check if API is called in debug mode. If yes, disable debug.
2169: AHL_DEBUG_PUB.disable_debug;

Line 2169: AHL_DEBUG_PUB.disable_debug;

2165: AHL_DEBUG_PUB.debug( 'ahl_di_doc_index_pvt.delete Supplier','+SUP+');
2166:
2167:
2168: -- Check if API is called in debug mode. If yes, disable debug.
2169: AHL_DEBUG_PUB.disable_debug;
2170:
2171: END IF;
2172:
2173: WHEN FND_API.G_EXC_ERROR THEN

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

2177: p_count => x_msg_count,
2178: p_data => X_msg_data);
2179: -- Debug info.
2180: IF G_DEBUG='Y' THEN
2181: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
2182: AHL_DEBUG_PUB.debug( 'ahl_di_doc_index_pvt.Delete Supplier','+SUP+');
2183:
2184:
2185: -- Check if API is called in debug mode. If yes, disable debug.

Line 2182: AHL_DEBUG_PUB.debug( 'ahl_di_doc_index_pvt.Delete Supplier','+SUP+');

2178: p_data => X_msg_data);
2179: -- Debug info.
2180: IF G_DEBUG='Y' THEN
2181: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
2182: AHL_DEBUG_PUB.debug( 'ahl_di_doc_index_pvt.Delete Supplier','+SUP+');
2183:
2184:
2185: -- Check if API is called in debug mode. If yes, disable debug.
2186: AHL_DEBUG_PUB.disable_debug;

Line 2186: AHL_DEBUG_PUB.disable_debug;

2182: AHL_DEBUG_PUB.debug( 'ahl_di_doc_index_pvt.Delete Supplier','+SUP+');
2183:
2184:
2185: -- Check if API is called in debug mode. If yes, disable debug.
2186: AHL_DEBUG_PUB.disable_debug;
2187:
2188: END IF;
2189:
2190: WHEN OTHERS THEN

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

2201: p_data => X_msg_data);
2202:
2203: -- Debug info.
2204: IF G_DEBUG='Y' THEN
2205: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'SQL ERROR' );
2206: AHL_DEBUG_PUB.debug( 'ahl_di_doc_index_pvt.Delete Supplier','+SUP+');
2207:
2208:
2209: -- Check if API is called in debug mode. If yes, disable debug.

Line 2206: AHL_DEBUG_PUB.debug( 'ahl_di_doc_index_pvt.Delete Supplier','+SUP+');

2202:
2203: -- Debug info.
2204: IF G_DEBUG='Y' THEN
2205: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'SQL ERROR' );
2206: AHL_DEBUG_PUB.debug( 'ahl_di_doc_index_pvt.Delete Supplier','+SUP+');
2207:
2208:
2209: -- Check if API is called in debug mode. If yes, disable debug.
2210: AHL_DEBUG_PUB.disable_debug;

Line 2210: AHL_DEBUG_PUB.disable_debug;

2206: AHL_DEBUG_PUB.debug( 'ahl_di_doc_index_pvt.Delete Supplier','+SUP+');
2207:
2208:
2209: -- Check if API is called in debug mode. If yes, disable debug.
2210: AHL_DEBUG_PUB.disable_debug;
2211:
2212: END IF;
2213:
2214: END DELETE_SUPPLIER;

Line 2389: AHL_DEBUG_PUB.enable_debug;

2385: -- Standard Start of API savepoint
2386: SAVEPOINT create_recipient;
2387: -- Check if API is called in debug mode. If yes, enable debug.
2388: IF G_DEBUG='Y' THEN
2389: AHL_DEBUG_PUB.enable_debug;
2390:
2391: END IF;
2392: -- Debug info.
2393: IF G_DEBUG='Y' THEN

Line 2395: AHL_DEBUG_PUB.debug( 'enter ahl_di_doc_index_pvt.Create Recipient','+REP+');

2391: END IF;
2392: -- Debug info.
2393: IF G_DEBUG='Y' THEN
2394: IF G_DEBUG='Y' THEN
2395: AHL_DEBUG_PUB.debug( 'enter ahl_di_doc_index_pvt.Create Recipient','+REP+');
2396:
2397: END IF;
2398: END IF;
2399: -- Standard call to check for call compatibility.

Line 2564: AHL_DEBUG_PUB.debug( 'End of private api Create Recipient','+REP+');

2560: COMMIT;
2561: END IF;
2562: -- Debug info
2563: IF G_DEBUG='Y' THEN
2564: AHL_DEBUG_PUB.debug( 'End of private api Create Recipient','+REP+');
2565:
2566: END IF;
2567: -- Check if API is called in debug mode. If yes, disable debug.
2568: IF G_DEBUG='Y' THEN

Line 2569: AHL_DEBUG_PUB.disable_debug;

2565:
2566: END IF;
2567: -- Check if API is called in debug mode. If yes, disable debug.
2568: IF G_DEBUG='Y' THEN
2569: AHL_DEBUG_PUB.disable_debug;
2570:
2571: END IF;
2572:
2573: EXCEPTION

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

2578: p_count => x_msg_count,
2579: p_data => x_msg_data);
2580:
2581: IF G_DEBUG='Y' THEN
2582: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'ERROR' );
2583: AHL_DEBUG_PUB.debug( 'ahl_di_doc_index_pvt.Create Recipient','+REP+');
2584:
2585:
2586: -- Check if API is called in debug mode. If yes, disable debug.

Line 2583: AHL_DEBUG_PUB.debug( 'ahl_di_doc_index_pvt.Create Recipient','+REP+');

2579: p_data => x_msg_data);
2580:
2581: IF G_DEBUG='Y' THEN
2582: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'ERROR' );
2583: AHL_DEBUG_PUB.debug( 'ahl_di_doc_index_pvt.Create Recipient','+REP+');
2584:
2585:
2586: -- Check if API is called in debug mode. If yes, disable debug.
2587: AHL_DEBUG_PUB.disable_debug;

Line 2587: AHL_DEBUG_PUB.disable_debug;

2583: AHL_DEBUG_PUB.debug( 'ahl_di_doc_index_pvt.Create Recipient','+REP+');
2584:
2585:
2586: -- Check if API is called in debug mode. If yes, disable debug.
2587: AHL_DEBUG_PUB.disable_debug;
2588:
2589: END IF;
2590:
2591: WHEN FND_API.G_EXC_ERROR THEN

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

2595: p_count => x_msg_count,
2596: p_data => X_msg_data);
2597: -- Debug info.
2598: IF G_DEBUG='Y' THEN
2599: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
2600: AHL_DEBUG_PUB.debug( 'ahl_di_doc_index_pvt.Create Recipient','+REP+');
2601:
2602:
2603: -- Check if API is called in debug mode. If yes, disable debug.

Line 2600: AHL_DEBUG_PUB.debug( 'ahl_di_doc_index_pvt.Create Recipient','+REP+');

2596: p_data => X_msg_data);
2597: -- Debug info.
2598: IF G_DEBUG='Y' THEN
2599: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
2600: AHL_DEBUG_PUB.debug( 'ahl_di_doc_index_pvt.Create Recipient','+REP+');
2601:
2602:
2603: -- Check if API is called in debug mode. If yes, disable debug.
2604: AHL_DEBUG_PUB.disable_debug;

Line 2604: AHL_DEBUG_PUB.disable_debug;

2600: AHL_DEBUG_PUB.debug( 'ahl_di_doc_index_pvt.Create Recipient','+REP+');
2601:
2602:
2603: -- Check if API is called in debug mode. If yes, disable debug.
2604: AHL_DEBUG_PUB.disable_debug;
2605:
2606: END IF;
2607:
2608: WHEN OTHERS THEN

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

2619: p_data => X_msg_data);
2620:
2621: -- Debug info.
2622: IF G_DEBUG='Y' THEN
2623: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'SQL ERROR' );
2624: AHL_DEBUG_PUB.debug( 'ahl_di_doc_index_pvt.Create Recipient','+REP+');
2625:
2626:
2627: -- Check if API is called in debug mode. If yes, disable debug.

Line 2624: AHL_DEBUG_PUB.debug( 'ahl_di_doc_index_pvt.Create Recipient','+REP+');

2620:
2621: -- Debug info.
2622: IF G_DEBUG='Y' THEN
2623: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'SQL ERROR' );
2624: AHL_DEBUG_PUB.debug( 'ahl_di_doc_index_pvt.Create Recipient','+REP+');
2625:
2626:
2627: -- Check if API is called in debug mode. If yes, disable debug.
2628: AHL_DEBUG_PUB.disable_debug;

Line 2628: AHL_DEBUG_PUB.disable_debug;

2624: AHL_DEBUG_PUB.debug( 'ahl_di_doc_index_pvt.Create Recipient','+REP+');
2625:
2626:
2627: -- Check if API is called in debug mode. If yes, disable debug.
2628: AHL_DEBUG_PUB.disable_debug;
2629:
2630: END IF;
2631:
2632: END CREATE_RECIPIENT;

Line 2693: AHL_DEBUG_PUB.enable_debug;

2689: SAVEPOINT modify_recipient;
2690: -- Check if API is called in debug mode. If yes, enable debug.
2691:
2692: IF G_DEBUG='Y' THEN
2693: AHL_DEBUG_PUB.enable_debug;
2694:
2695: END IF;
2696: -- Debug info.
2697: IF G_DEBUG='Y' THEN

Line 2699: AHL_DEBUG_PUB.debug( 'enter ahl_di_doc_index_pvt.Modify Recipient','+REP+');

2695: END IF;
2696: -- Debug info.
2697: IF G_DEBUG='Y' THEN
2698: IF G_DEBUG='Y' THEN
2699: AHL_DEBUG_PUB.debug( 'enter ahl_di_doc_index_pvt.Modify Recipient','+REP+');
2700:
2701: END IF;
2702: END IF;
2703: -- Standard call to check for call compatibility.

Line 2833: AHL_DEBUG_PUB.debug( 'End of private api Modify Recipient','+REP+');

2829: COMMIT;
2830: END IF;
2831: -- Debug info
2832: IF G_DEBUG='Y' THEN
2833: AHL_DEBUG_PUB.debug( 'End of private api Modify Recipient','+REP+');
2834:
2835: END IF;
2836: -- Check if API is called in debug mode. If yes, disable debug.
2837: IF G_DEBUG='Y' THEN

Line 2838: AHL_DEBUG_PUB.disable_debug;

2834:
2835: END IF;
2836: -- Check if API is called in debug mode. If yes, disable debug.
2837: IF G_DEBUG='Y' THEN
2838: AHL_DEBUG_PUB.disable_debug;
2839:
2840: END IF;
2841:
2842: EXCEPTION

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

2846: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
2847: p_count => x_msg_count,
2848: p_data => x_msg_data);
2849: IF G_DEBUG='Y' THEN
2850: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'ERROR' );
2851: AHL_DEBUG_PUB.debug( 'ahl_di_doc_index_pvt.Modify Recipient','+REP+');
2852:
2853: -- Check if API is called in debug mode. If yes, disable debug.
2854: AHL_DEBUG_PUB.disable_debug;

Line 2851: AHL_DEBUG_PUB.debug( 'ahl_di_doc_index_pvt.Modify Recipient','+REP+');

2847: p_count => x_msg_count,
2848: p_data => x_msg_data);
2849: IF G_DEBUG='Y' THEN
2850: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'ERROR' );
2851: AHL_DEBUG_PUB.debug( 'ahl_di_doc_index_pvt.Modify Recipient','+REP+');
2852:
2853: -- Check if API is called in debug mode. If yes, disable debug.
2854: AHL_DEBUG_PUB.disable_debug;
2855:

Line 2854: AHL_DEBUG_PUB.disable_debug;

2850: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'ERROR' );
2851: AHL_DEBUG_PUB.debug( 'ahl_di_doc_index_pvt.Modify Recipient','+REP+');
2852:
2853: -- Check if API is called in debug mode. If yes, disable debug.
2854: AHL_DEBUG_PUB.disable_debug;
2855:
2856: END IF;
2857:
2858: WHEN FND_API.G_EXC_ERROR THEN

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

2862: p_count => x_msg_count,
2863: p_data => X_msg_data);
2864: -- Debug info.
2865: IF G_DEBUG='Y' THEN
2866: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
2867: AHL_DEBUG_PUB.debug( 'ahl_di_doc_index_pvt.Modify Recipient','+REP+');
2868:
2869:
2870: -- Check if API is called in debug mode. If yes, disable debug.

Line 2867: AHL_DEBUG_PUB.debug( 'ahl_di_doc_index_pvt.Modify Recipient','+REP+');

2863: p_data => X_msg_data);
2864: -- Debug info.
2865: IF G_DEBUG='Y' THEN
2866: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
2867: AHL_DEBUG_PUB.debug( 'ahl_di_doc_index_pvt.Modify Recipient','+REP+');
2868:
2869:
2870: -- Check if API is called in debug mode. If yes, disable debug.
2871: AHL_DEBUG_PUB.disable_debug;

Line 2871: AHL_DEBUG_PUB.disable_debug;

2867: AHL_DEBUG_PUB.debug( 'ahl_di_doc_index_pvt.Modify Recipient','+REP+');
2868:
2869:
2870: -- Check if API is called in debug mode. If yes, disable debug.
2871: AHL_DEBUG_PUB.disable_debug;
2872:
2873: END IF;
2874:
2875: WHEN DUP_VAL_ON_INDEX THEN

Line 2882: AHL_DEBUG_PUB.disable_debug;

2878: FND_MESSAGE.SET_NAME('AHL','AHL_DI_RECIPIENT_DUP_RECORD');
2879: FND_MSG_PUB.ADD;
2880: -- Check if API is called in debug mode. If yes, disable debug.
2881: IF G_DEBUG='Y' THEN
2882: AHL_DEBUG_PUB.disable_debug;
2883:
2884: END IF;
2885: WHEN OTHERS THEN
2886: ROLLBACK TO modify_recipient;

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

2896: p_data => X_msg_data);
2897:
2898: -- Debug info.
2899: IF G_DEBUG='Y' THEN
2900: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'SQL ERROR' );
2901: AHL_DEBUG_PUB.debug( 'ahl_di_doc_index_pvt.Modify Recipient','+REP+');
2902:
2903:
2904: -- Check if API is called in debug mode. If yes, disable debug.

Line 2901: AHL_DEBUG_PUB.debug( 'ahl_di_doc_index_pvt.Modify Recipient','+REP+');

2897:
2898: -- Debug info.
2899: IF G_DEBUG='Y' THEN
2900: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'SQL ERROR' );
2901: AHL_DEBUG_PUB.debug( 'ahl_di_doc_index_pvt.Modify Recipient','+REP+');
2902:
2903:
2904: -- Check if API is called in debug mode. If yes, disable debug.
2905: AHL_DEBUG_PUB.disable_debug;

Line 2905: AHL_DEBUG_PUB.disable_debug;

2901: AHL_DEBUG_PUB.debug( 'ahl_di_doc_index_pvt.Modify Recipient','+REP+');
2902:
2903:
2904: -- Check if API is called in debug mode. If yes, disable debug.
2905: AHL_DEBUG_PUB.disable_debug;
2906:
2907: END IF;
2908:
2909: END MODIFY_RECIPIENT;

Line 2951: AHL_DEBUG_PUB.enable_debug;

2947: SAVEPOINT delete_recipient;
2948: -- Check if API is called in debug mode. If yes, enable debug.
2949:
2950: IF G_DEBUG='Y' THEN
2951: AHL_DEBUG_PUB.enable_debug;
2952:
2953: END IF;
2954: -- Debug info.
2955: IF G_DEBUG='Y' THEN

Line 2957: AHL_DEBUG_PUB.debug( 'enter ahl_di_doc_index_pvt.Delete Recipient','+REP+');

2953: END IF;
2954: -- Debug info.
2955: IF G_DEBUG='Y' THEN
2956: IF G_DEBUG='Y' THEN
2957: AHL_DEBUG_PUB.debug( 'enter ahl_di_doc_index_pvt.Delete Recipient','+REP+');
2958:
2959: END IF;
2960: END IF;
2961: -- Standard call to check for call compatibility.

Line 3014: AHL_DEBUG_PUB.debug( 'End of private api Delete Recipient','+REP+');

3010: COMMIT;
3011: END IF;
3012: -- Debug info
3013: IF G_DEBUG='Y' THEN
3014: AHL_DEBUG_PUB.debug( 'End of private api Delete Recipient','+REP+');
3015:
3016: END IF;
3017: -- Check if API is called in debug mode. If yes, disable debug.
3018: IF G_DEBUG='Y' THEN

Line 3019: AHL_DEBUG_PUB.disable_debug;

3015:
3016: END IF;
3017: -- Check if API is called in debug mode. If yes, disable debug.
3018: IF G_DEBUG='Y' THEN
3019: AHL_DEBUG_PUB.disable_debug;
3020:
3021: END IF;
3022:
3023: EXCEPTION

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

3027: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
3028: p_count => x_msg_count,
3029: p_data => x_msg_data);
3030: IF G_DEBUG='Y' THEN
3031: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'ERROR' );
3032: AHL_DEBUG_PUB.debug( 'ahl_di_doc_index_pvt.Delete Recipient','+REP+');
3033:
3034:
3035: -- Check if API is called in debug mode. If yes, disable debug.

Line 3032: AHL_DEBUG_PUB.debug( 'ahl_di_doc_index_pvt.Delete Recipient','+REP+');

3028: p_count => x_msg_count,
3029: p_data => x_msg_data);
3030: IF G_DEBUG='Y' THEN
3031: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'ERROR' );
3032: AHL_DEBUG_PUB.debug( 'ahl_di_doc_index_pvt.Delete Recipient','+REP+');
3033:
3034:
3035: -- Check if API is called in debug mode. If yes, disable debug.
3036: AHL_DEBUG_PUB.disable_debug;

Line 3036: AHL_DEBUG_PUB.disable_debug;

3032: AHL_DEBUG_PUB.debug( 'ahl_di_doc_index_pvt.Delete Recipient','+REP+');
3033:
3034:
3035: -- Check if API is called in debug mode. If yes, disable debug.
3036: AHL_DEBUG_PUB.disable_debug;
3037:
3038: END IF;
3039:
3040: WHEN FND_API.G_EXC_ERROR THEN

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

3044: p_count => x_msg_count,
3045: p_data => X_msg_data);
3046: -- Debug info.
3047: IF G_DEBUG='Y' THEN
3048: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
3049: AHL_DEBUG_PUB.debug( 'ahl_di_doc_index_pvt.Delete Recipient','+REP+');
3050:
3051:
3052: -- Check if API is called in debug mode. If yes, disable debug.

Line 3049: AHL_DEBUG_PUB.debug( 'ahl_di_doc_index_pvt.Delete Recipient','+REP+');

3045: p_data => X_msg_data);
3046: -- Debug info.
3047: IF G_DEBUG='Y' THEN
3048: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
3049: AHL_DEBUG_PUB.debug( 'ahl_di_doc_index_pvt.Delete Recipient','+REP+');
3050:
3051:
3052: -- Check if API is called in debug mode. If yes, disable debug.
3053: AHL_DEBUG_PUB.disable_debug;

Line 3053: AHL_DEBUG_PUB.disable_debug;

3049: AHL_DEBUG_PUB.debug( 'ahl_di_doc_index_pvt.Delete Recipient','+REP+');
3050:
3051:
3052: -- Check if API is called in debug mode. If yes, disable debug.
3053: AHL_DEBUG_PUB.disable_debug;
3054:
3055: END IF;
3056:
3057: WHEN OTHERS THEN

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

3068: p_data => X_msg_data);
3069:
3070: -- Debug info.
3071: IF G_DEBUG='Y' THEN
3072: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'SQL ERROR' );
3073: AHL_DEBUG_PUB.debug( 'ahl_di_doc_index_pvt.Delete Recipient','+REP+');
3074:
3075:
3076: -- Check if API is called in debug mode. If yes, disable debug.

Line 3073: AHL_DEBUG_PUB.debug( 'ahl_di_doc_index_pvt.Delete Recipient','+REP+');

3069:
3070: -- Debug info.
3071: IF G_DEBUG='Y' THEN
3072: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'SQL ERROR' );
3073: AHL_DEBUG_PUB.debug( 'ahl_di_doc_index_pvt.Delete Recipient','+REP+');
3074:
3075:
3076: -- Check if API is called in debug mode. If yes, disable debug.
3077: AHL_DEBUG_PUB.disable_debug;

Line 3077: AHL_DEBUG_PUB.disable_debug;

3073: AHL_DEBUG_PUB.debug( 'ahl_di_doc_index_pvt.Delete Recipient','+REP+');
3074:
3075:
3076: -- Check if API is called in debug mode. If yes, disable debug.
3077: AHL_DEBUG_PUB.disable_debug;
3078:
3079: END IF;
3080:
3081: END DELETE_RECIPIENT;