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.5.12020000.2 2012/12/14 07:56:19 shnatu ship $ */
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 818: AHL_DEBUG_PUB.enable_debug;

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

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

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

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

1017: END IF;
1018: -- Debug info.
1019: IF G_DEBUG='Y' THEN
1020: IF G_DEBUG='Y' THEN
1021: AHL_DEBUG_PUB.debug( 'Before start processing Supplier Record ahl_di_doc_index_pvt.modify document','+DI+');
1022:
1023: END IF;
1024: END IF;
1025:

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

1039: END IF;
1040: -- Debug info.
1041: IF G_DEBUG='Y' THEN
1042: IF G_DEBUG='Y' THEN
1043: AHL_DEBUG_PUB.debug( 'Before start processing Recipient Record ahl_di_doc_index_pvt.modify document','+DI+');
1044:
1045: END IF;
1046: END IF;
1047:

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

1072: COMMIT;
1073: END IF;
1074: -- Debug info
1075: IF G_DEBUG='Y' THEN
1076: AHL_DEBUG_PUB.debug( 'End of private api modify document','+DI+');
1077:
1078: END IF;
1079: -- Check if API is called in debug mode. If yes, disable debug.
1080: IF G_DEBUG='Y' THEN

Line 1081: AHL_DEBUG_PUB.disable_debug;

1077:
1078: END IF;
1079: -- Check if API is called in debug mode. If yes, disable debug.
1080: IF G_DEBUG='Y' THEN
1081: AHL_DEBUG_PUB.disable_debug;
1082:
1083: END IF;
1084:
1085: EXCEPTION

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

1090: p_count => x_msg_count,
1091: p_data => x_msg_data);
1092:
1093: IF G_DEBUG='Y' THEN
1094: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'ERROR' );
1095: AHL_DEBUG_PUB.debug( 'ahl_di_doc_index_pvt.modify document','+DI+');
1096:
1097:
1098:

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

1091: p_data => x_msg_data);
1092:
1093: IF G_DEBUG='Y' THEN
1094: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'ERROR' );
1095: AHL_DEBUG_PUB.debug( 'ahl_di_doc_index_pvt.modify document','+DI+');
1096:
1097:
1098:
1099: -- Check if API is called in debug mode. If yes, disable debug.

Line 1101: AHL_DEBUG_PUB.disable_debug;

1097:
1098:
1099: -- Check if API is called in debug mode. If yes, disable debug.
1100:
1101: AHL_DEBUG_PUB.disable_debug;
1102:
1103: END IF;
1104:
1105: WHEN FND_API.G_EXC_ERROR THEN

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

1109: p_count => x_msg_count,
1110: p_data => X_msg_data);
1111: -- Debug info.
1112: IF G_DEBUG='Y' THEN
1113: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
1114: AHL_DEBUG_PUB.debug( 'ahl_di_doc_index_pvt.modify document','+DI+');
1115:
1116:
1117: -- Check if API is called in debug mode. If yes, disable debug.

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

1110: p_data => X_msg_data);
1111: -- Debug info.
1112: IF G_DEBUG='Y' THEN
1113: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
1114: AHL_DEBUG_PUB.debug( 'ahl_di_doc_index_pvt.modify document','+DI+');
1115:
1116:
1117: -- Check if API is called in debug mode. If yes, disable debug.
1118:

Line 1119: AHL_DEBUG_PUB.disable_debug;

1115:
1116:
1117: -- Check if API is called in debug mode. If yes, disable debug.
1118:
1119: AHL_DEBUG_PUB.disable_debug;
1120:
1121: END IF;
1122:
1123: WHEN OTHERS THEN

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

1134: p_data => X_msg_data);
1135:
1136: -- Debug info.
1137: IF G_DEBUG='Y' THEN
1138: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'SQL ERROR' );
1139: AHL_DEBUG_PUB.debug( 'ahl_di_doc_index_pvt.modify document','+DI+');
1140:
1141:
1142:

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

1135:
1136: -- Debug info.
1137: IF G_DEBUG='Y' THEN
1138: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'SQL ERROR' );
1139: AHL_DEBUG_PUB.debug( 'ahl_di_doc_index_pvt.modify document','+DI+');
1140:
1141:
1142:
1143: -- Check if API is called in debug mode. If yes, disable debug.

Line 1144: AHL_DEBUG_PUB.disable_debug;

1140:
1141:
1142:
1143: -- Check if API is called in debug mode. If yes, disable debug.
1144: AHL_DEBUG_PUB.disable_debug;
1145:
1146: END IF;
1147:
1148: END MODIFY_DOCUMENT;

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

1228:
1229: -- Perf Bug Fix 4919011.
1230: BEGIN
1231: IF G_DEBUG='Y' THEN
1232: AHL_DEBUG_PUB.debug( 'Fetching Installation Status of PO','+SUP+');
1233: END IF;
1234: SELECT AHL_DI_DOC_INDEX_PVT.GET_PRODUCT_INSTALL_STATUS('PO')
1235: INTO l_prod_install_status
1236: FROM DUAL;

Line 1405: AHL_DEBUG_PUB.enable_debug;

1401: -- Standard Start of API savepoint
1402: SAVEPOINT create_supplier;
1403: -- Check if API is called in debug mode. If yes, enable debug.
1404: IF G_DEBUG='Y' THEN
1405: AHL_DEBUG_PUB.enable_debug;
1406: END IF;
1407: -- Debug info.
1408: IF G_DEBUG='Y' THEN
1409: AHL_DEBUG_PUB.debug( 'enter ahl_di_doc_index_pvt.Create Supplier','+SUP+');

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

1405: AHL_DEBUG_PUB.enable_debug;
1406: END IF;
1407: -- Debug info.
1408: IF G_DEBUG='Y' THEN
1409: AHL_DEBUG_PUB.debug( 'enter ahl_di_doc_index_pvt.Create Supplier','+SUP+');
1410: END IF;
1411:
1412: -- Standard call to check for call compatibility.
1413: IF FND_API.to_boolean(p_init_msg_list)

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

1426:
1427: -- Perf Bug Fix 4919011.
1428: BEGIN
1429: IF G_DEBUG='Y' THEN
1430: AHL_DEBUG_PUB.debug( 'Fetching Installation Status of P0','+SUP+');
1431: END IF;
1432: SELECT AHL_DI_DOC_INDEX_PVT.GET_PRODUCT_INSTALL_STATUS('PO')
1433: INTO l_prod_install_status
1434: FROM DUAL;

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

1602: COMMIT;
1603: END IF;
1604: -- Debug info
1605: IF G_DEBUG='Y' THEN
1606: AHL_DEBUG_PUB.debug( 'End of private api Create Supplier','+SUP+');
1607:
1608: END IF;
1609: -- Check if API is called in debug mode. If yes, disable debug.
1610: IF G_DEBUG='Y' THEN

Line 1611: AHL_DEBUG_PUB.disable_debug;

1607:
1608: END IF;
1609: -- Check if API is called in debug mode. If yes, disable debug.
1610: IF G_DEBUG='Y' THEN
1611: AHL_DEBUG_PUB.disable_debug;
1612:
1613: END IF;
1614:
1615: EXCEPTION

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

1620: p_count => x_msg_count,
1621: p_data => x_msg_data);
1622:
1623: IF G_DEBUG='Y' THEN
1624: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'ERROR' );
1625: AHL_DEBUG_PUB.debug( 'ahl_di_doc_index_pvt.Create Supplier','+SUP+');
1626:
1627:
1628: -- Check if API is called in debug mode. If yes, disable debug.

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

1621: p_data => x_msg_data);
1622:
1623: IF G_DEBUG='Y' THEN
1624: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'ERROR' );
1625: AHL_DEBUG_PUB.debug( 'ahl_di_doc_index_pvt.Create Supplier','+SUP+');
1626:
1627:
1628: -- Check if API is called in debug mode. If yes, disable debug.
1629:

Line 1630: AHL_DEBUG_PUB.disable_debug;

1626:
1627:
1628: -- Check if API is called in debug mode. If yes, disable debug.
1629:
1630: AHL_DEBUG_PUB.disable_debug;
1631:
1632: END IF;
1633:
1634: WHEN FND_API.G_EXC_ERROR THEN

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

1638: p_count => x_msg_count,
1639: p_data => X_msg_data);
1640: -- Debug info.
1641: IF G_DEBUG='Y' THEN
1642: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
1643: AHL_DEBUG_PUB.debug( 'ahl_di_doc_index_pub.Create Supplier','+SUP+');
1644:
1645:
1646: -- Check if API is called in debug mode. If yes, disable debug.

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

1639: p_data => X_msg_data);
1640: -- Debug info.
1641: IF G_DEBUG='Y' THEN
1642: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
1643: AHL_DEBUG_PUB.debug( 'ahl_di_doc_index_pub.Create Supplier','+SUP+');
1644:
1645:
1646: -- Check if API is called in debug mode. If yes, disable debug.
1647: AHL_DEBUG_PUB.disable_debug;

Line 1647: AHL_DEBUG_PUB.disable_debug;

1643: AHL_DEBUG_PUB.debug( 'ahl_di_doc_index_pub.Create Supplier','+SUP+');
1644:
1645:
1646: -- Check if API is called in debug mode. If yes, disable debug.
1647: AHL_DEBUG_PUB.disable_debug;
1648:
1649: END IF;
1650:
1651: WHEN OTHERS THEN

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

1662: p_data => X_msg_data);
1663:
1664: -- Debug info.
1665: IF G_DEBUG='Y' THEN
1666: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'SQL ERROR' );
1667: AHL_DEBUG_PUB.debug( 'ahl_di_doc_index_pvt.Create Supplier','+SUP+');
1668:
1669:
1670: -- Check if API is called in debug mode. If yes, disable debug.

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

1663:
1664: -- Debug info.
1665: IF G_DEBUG='Y' THEN
1666: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'SQL ERROR' );
1667: AHL_DEBUG_PUB.debug( 'ahl_di_doc_index_pvt.Create Supplier','+SUP+');
1668:
1669:
1670: -- Check if API is called in debug mode. If yes, disable debug.
1671: AHL_DEBUG_PUB.disable_debug;

Line 1671: AHL_DEBUG_PUB.disable_debug;

1667: AHL_DEBUG_PUB.debug( 'ahl_di_doc_index_pvt.Create Supplier','+SUP+');
1668:
1669:
1670: -- Check if API is called in debug mode. If yes, disable debug.
1671: AHL_DEBUG_PUB.disable_debug;
1672:
1673: END IF;
1674:
1675: END CREATE_SUPPLIER;

Line 1761: AHL_DEBUG_PUB.enable_debug;

1757: -- Standard Start of API savepoint
1758: SAVEPOINT modify_supplier;
1759: -- Check if API is called in debug mode. If yes, enable debug.
1760: IF G_DEBUG='Y' THEN
1761: AHL_DEBUG_PUB.enable_debug;
1762:
1763: END IF;
1764: -- Debug info.
1765: IF G_DEBUG='Y' THEN

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

1762:
1763: END IF;
1764: -- Debug info.
1765: IF G_DEBUG='Y' THEN
1766: AHL_DEBUG_PUB.debug( 'anand enter ahl_di_doc_index_pvt.Modify Supplier','+SUP+');
1767: END IF;
1768:
1769: -- Standard call to check for call compatibility.
1770: IF FND_API.to_boolean(p_init_msg_list)

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

1784:
1785: -- Perf Bug Fix 4919011.
1786: BEGIN
1787: IF G_DEBUG='Y' THEN
1788: AHL_DEBUG_PUB.debug( 'Fetching Installation Status of PO','+SUP+');
1789: END IF;
1790: SELECT AHL_DI_DOC_INDEX_PVT.GET_PRODUCT_INSTALL_STATUS('PO')
1791: INTO l_prod_install_status
1792: FROM DUAL;

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

1799: -- Calling validate suppliers
1800: --ad
1801: IF G_DEBUG='Y' THEN
1802: IF G_DEBUG='Y' THEN
1803: AHL_DEBUG_PUB.debug( ' anand enter ahl_di_doc_index_pvt.Modify Supplier before validate supplier ','+SUP+');
1804:
1805: END IF;
1806: END IF;
1807: --ad

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

1819: l_msg_count := FND_MSG_PUB.count_msg;
1820: --ad
1821: IF G_DEBUG='Y' THEN
1822: IF G_DEBUG='Y' THEN
1823: AHL_DEBUG_PUB.debug( ' anand enter ahl_di_doc_index_pvt.Modify Supplier after validate sup '||l_msg_count,'+SUP+');
1824:
1825: END IF;
1826: END IF;
1827: --ad

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

1944: l_msg_count := FND_MSG_PUB.count_msg;
1945: --ad
1946: IF G_DEBUG='Y' THEN
1947: IF G_DEBUG='Y' THEN
1948: AHL_DEBUG_PUB.debug( ' anand enter ahl_di_doc_index_pvt.Modify Supplier after modify sup '||l_msg_count,'+SUP+');
1949:
1950: END IF;
1951: END IF;
1952: --ad

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

1963: END IF;
1964:
1965: -- Debug info
1966: IF G_DEBUG='Y' THEN
1967: AHL_DEBUG_PUB.debug( 'End of private api Modify Supplier','+SUP+');
1968:
1969: END IF;
1970: -- Check if API is called in debug mode. If yes, disable debug.
1971: IF G_DEBUG='Y' THEN

Line 1972: AHL_DEBUG_PUB.disable_debug;

1968:
1969: END IF;
1970: -- Check if API is called in debug mode. If yes, disable debug.
1971: IF G_DEBUG='Y' THEN
1972: AHL_DEBUG_PUB.disable_debug;
1973:
1974: END IF;
1975:
1976: EXCEPTION

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

1981: p_count => x_msg_count,
1982: p_data => x_msg_data);
1983:
1984: IF G_DEBUG='Y' THEN
1985: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'ERROR' );
1986: AHL_DEBUG_PUB.debug( 'ahl_di_doc_index_pvt.Modify supplier','+SUP+');
1987:
1988:
1989:

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

1982: p_data => x_msg_data);
1983:
1984: IF G_DEBUG='Y' THEN
1985: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'ERROR' );
1986: AHL_DEBUG_PUB.debug( 'ahl_di_doc_index_pvt.Modify supplier','+SUP+');
1987:
1988:
1989:
1990: -- Check if API is called in debug mode. If yes, disable debug.

Line 1991: AHL_DEBUG_PUB.disable_debug;

1987:
1988:
1989:
1990: -- Check if API is called in debug mode. If yes, disable debug.
1991: AHL_DEBUG_PUB.disable_debug;
1992:
1993: END IF;
1994:
1995: WHEN FND_API.G_EXC_ERROR THEN

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

1999: p_count => x_msg_count,
2000: p_data => X_msg_data);
2001: -- Debug info.
2002: IF G_DEBUG='Y' THEN
2003: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
2004: AHL_DEBUG_PUB.debug( 'ahl_di_doc_index_pvt.Modify Supplier','+SUP+');
2005:
2006:
2007:

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

2000: p_data => X_msg_data);
2001: -- Debug info.
2002: IF G_DEBUG='Y' THEN
2003: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
2004: AHL_DEBUG_PUB.debug( 'ahl_di_doc_index_pvt.Modify Supplier','+SUP+');
2005:
2006:
2007:
2008: -- Check if API is called in debug mode. If yes, disable debug.

Line 2009: AHL_DEBUG_PUB.disable_debug;

2005:
2006:
2007:
2008: -- Check if API is called in debug mode. If yes, disable debug.
2009: AHL_DEBUG_PUB.disable_debug;
2010:
2011: END IF;
2012:
2013: WHEN DUP_VAL_ON_INDEX THEN

Line 2021: AHL_DEBUG_PUB.disable_debug;

2017: FND_MESSAGE.SET_TOKEN('SUPNAME',l_supplier_name);
2018: FND_MSG_PUB.ADD;
2019: -- Check if API is called in debug mode. If yes, disable debug.
2020: IF G_DEBUG='Y' THEN
2021: AHL_DEBUG_PUB.disable_debug;
2022:
2023: END IF;
2024:
2025: WHEN OTHERS THEN

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

2036: p_data => X_msg_data);
2037:
2038: -- Debug info.
2039: IF G_DEBUG='Y' THEN
2040: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'SQL ERROR' );
2041: AHL_DEBUG_PUB.debug( 'ahl_di_doc_index_pvt.Modify Supplier','+SUP+');
2042:
2043:
2044:

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

2037:
2038: -- Debug info.
2039: IF G_DEBUG='Y' THEN
2040: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'SQL ERROR' );
2041: AHL_DEBUG_PUB.debug( 'ahl_di_doc_index_pvt.Modify Supplier','+SUP+');
2042:
2043:
2044:
2045: -- Check if API is called in debug mode. If yes, disable debug.

Line 2046: AHL_DEBUG_PUB.disable_debug;

2042:
2043:
2044:
2045: -- Check if API is called in debug mode. If yes, disable debug.
2046: AHL_DEBUG_PUB.disable_debug;
2047:
2048: END IF;
2049:
2050: END MODIFY_SUPPLIER;

Line 2130: AHL_DEBUG_PUB.enable_debug;

2126: -- Standard Start of API savepoint
2127: SAVEPOINT delete_supplier;
2128: -- Check if API is called in debug mode. If yes, enable debug.
2129: IF G_DEBUG='Y' THEN
2130: AHL_DEBUG_PUB.enable_debug;
2131:
2132: END IF;
2133: -- Debug info.
2134: IF G_DEBUG='Y' THEN

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

2131:
2132: END IF;
2133: -- Debug info.
2134: IF G_DEBUG='Y' THEN
2135: AHL_DEBUG_PUB.debug( 'enter ahl_di_doc_index_pvt.Delete Supplier','+SUP+');
2136: END IF;
2137: -- Standard call to check for call compatibility.
2138: IF FND_API.to_boolean(p_init_msg_list)
2139: THEN

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

2151:
2152: -- Perf Bug Fix 4919011.
2153: BEGIN
2154: IF G_DEBUG='Y' THEN
2155: AHL_DEBUG_PUB.debug( 'Fetching Product Install Status for PO');
2156: END IF;
2157: SELECT AHL_DI_DOC_INDEX_PVT.GET_PRODUCT_INSTALL_STATUS('PO')
2158: INTO l_prod_install_status
2159: FROM DUAL;

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

2228: COMMIT;
2229: END IF;
2230: -- Debug info
2231: IF G_DEBUG='Y' THEN
2232: AHL_DEBUG_PUB.debug( 'End of private api Delete Supplier','+SUP+');
2233:
2234: END IF;
2235: -- Check if API is called in debug mode. If yes, disable debug.
2236: IF G_DEBUG='Y' THEN

Line 2237: AHL_DEBUG_PUB.disable_debug;

2233:
2234: END IF;
2235: -- Check if API is called in debug mode. If yes, disable debug.
2236: IF G_DEBUG='Y' THEN
2237: AHL_DEBUG_PUB.disable_debug;
2238:
2239: END IF;
2240:
2241: EXCEPTION

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

2246: p_count => x_msg_count,
2247: p_data => x_msg_data);
2248:
2249: IF G_DEBUG='Y' THEN
2250: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'ERROR' );
2251: AHL_DEBUG_PUB.debug( 'ahl_di_doc_index_pvt.delete Supplier','+SUP+');
2252:
2253:
2254: -- Check if API is called in debug mode. If yes, disable debug.

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

2247: p_data => x_msg_data);
2248:
2249: IF G_DEBUG='Y' THEN
2250: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'ERROR' );
2251: AHL_DEBUG_PUB.debug( 'ahl_di_doc_index_pvt.delete Supplier','+SUP+');
2252:
2253:
2254: -- Check if API is called in debug mode. If yes, disable debug.
2255: AHL_DEBUG_PUB.disable_debug;

Line 2255: AHL_DEBUG_PUB.disable_debug;

2251: AHL_DEBUG_PUB.debug( 'ahl_di_doc_index_pvt.delete Supplier','+SUP+');
2252:
2253:
2254: -- Check if API is called in debug mode. If yes, disable debug.
2255: AHL_DEBUG_PUB.disable_debug;
2256:
2257: END IF;
2258:
2259: WHEN FND_API.G_EXC_ERROR THEN

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

2263: p_count => x_msg_count,
2264: p_data => X_msg_data);
2265: -- Debug info.
2266: IF G_DEBUG='Y' THEN
2267: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
2268: AHL_DEBUG_PUB.debug( 'ahl_di_doc_index_pvt.Delete Supplier','+SUP+');
2269:
2270:
2271: -- Check if API is called in debug mode. If yes, disable debug.

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

2264: p_data => X_msg_data);
2265: -- Debug info.
2266: IF G_DEBUG='Y' THEN
2267: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
2268: AHL_DEBUG_PUB.debug( 'ahl_di_doc_index_pvt.Delete Supplier','+SUP+');
2269:
2270:
2271: -- Check if API is called in debug mode. If yes, disable debug.
2272: AHL_DEBUG_PUB.disable_debug;

Line 2272: AHL_DEBUG_PUB.disable_debug;

2268: AHL_DEBUG_PUB.debug( 'ahl_di_doc_index_pvt.Delete Supplier','+SUP+');
2269:
2270:
2271: -- Check if API is called in debug mode. If yes, disable debug.
2272: AHL_DEBUG_PUB.disable_debug;
2273:
2274: END IF;
2275:
2276: WHEN OTHERS THEN

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

2287: p_data => X_msg_data);
2288:
2289: -- Debug info.
2290: IF G_DEBUG='Y' THEN
2291: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'SQL ERROR' );
2292: AHL_DEBUG_PUB.debug( 'ahl_di_doc_index_pvt.Delete Supplier','+SUP+');
2293:
2294:
2295: -- Check if API is called in debug mode. If yes, disable debug.

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

2288:
2289: -- Debug info.
2290: IF G_DEBUG='Y' THEN
2291: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'SQL ERROR' );
2292: AHL_DEBUG_PUB.debug( 'ahl_di_doc_index_pvt.Delete Supplier','+SUP+');
2293:
2294:
2295: -- Check if API is called in debug mode. If yes, disable debug.
2296: AHL_DEBUG_PUB.disable_debug;

Line 2296: AHL_DEBUG_PUB.disable_debug;

2292: AHL_DEBUG_PUB.debug( 'ahl_di_doc_index_pvt.Delete Supplier','+SUP+');
2293:
2294:
2295: -- Check if API is called in debug mode. If yes, disable debug.
2296: AHL_DEBUG_PUB.disable_debug;
2297:
2298: END IF;
2299:
2300: END DELETE_SUPPLIER;

Line 2475: AHL_DEBUG_PUB.enable_debug;

2471: -- Standard Start of API savepoint
2472: SAVEPOINT create_recipient;
2473: -- Check if API is called in debug mode. If yes, enable debug.
2474: IF G_DEBUG='Y' THEN
2475: AHL_DEBUG_PUB.enable_debug;
2476:
2477: END IF;
2478: -- Debug info.
2479: IF G_DEBUG='Y' THEN

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

2477: END IF;
2478: -- Debug info.
2479: IF G_DEBUG='Y' THEN
2480: IF G_DEBUG='Y' THEN
2481: AHL_DEBUG_PUB.debug( 'enter ahl_di_doc_index_pvt.Create Recipient','+REP+');
2482:
2483: END IF;
2484: END IF;
2485: -- Standard call to check for call compatibility.

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

2646: COMMIT;
2647: END IF;
2648: -- Debug info
2649: IF G_DEBUG='Y' THEN
2650: AHL_DEBUG_PUB.debug( 'End of private api Create Recipient','+REP+');
2651:
2652: END IF;
2653: -- Check if API is called in debug mode. If yes, disable debug.
2654: IF G_DEBUG='Y' THEN

Line 2655: AHL_DEBUG_PUB.disable_debug;

2651:
2652: END IF;
2653: -- Check if API is called in debug mode. If yes, disable debug.
2654: IF G_DEBUG='Y' THEN
2655: AHL_DEBUG_PUB.disable_debug;
2656:
2657: END IF;
2658:
2659: EXCEPTION

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

2664: p_count => x_msg_count,
2665: p_data => x_msg_data);
2666:
2667: IF G_DEBUG='Y' THEN
2668: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'ERROR' );
2669: AHL_DEBUG_PUB.debug( 'ahl_di_doc_index_pvt.Create Recipient','+REP+');
2670:
2671:
2672: -- Check if API is called in debug mode. If yes, disable debug.

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

2665: p_data => x_msg_data);
2666:
2667: IF G_DEBUG='Y' THEN
2668: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'ERROR' );
2669: AHL_DEBUG_PUB.debug( 'ahl_di_doc_index_pvt.Create Recipient','+REP+');
2670:
2671:
2672: -- Check if API is called in debug mode. If yes, disable debug.
2673: AHL_DEBUG_PUB.disable_debug;

Line 2673: AHL_DEBUG_PUB.disable_debug;

2669: AHL_DEBUG_PUB.debug( 'ahl_di_doc_index_pvt.Create Recipient','+REP+');
2670:
2671:
2672: -- Check if API is called in debug mode. If yes, disable debug.
2673: AHL_DEBUG_PUB.disable_debug;
2674:
2675: END IF;
2676:
2677: WHEN FND_API.G_EXC_ERROR THEN

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

2681: p_count => x_msg_count,
2682: p_data => X_msg_data);
2683: -- Debug info.
2684: IF G_DEBUG='Y' THEN
2685: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
2686: AHL_DEBUG_PUB.debug( 'ahl_di_doc_index_pvt.Create Recipient','+REP+');
2687:
2688:
2689: -- Check if API is called in debug mode. If yes, disable debug.

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

2682: p_data => X_msg_data);
2683: -- Debug info.
2684: IF G_DEBUG='Y' THEN
2685: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
2686: AHL_DEBUG_PUB.debug( 'ahl_di_doc_index_pvt.Create Recipient','+REP+');
2687:
2688:
2689: -- Check if API is called in debug mode. If yes, disable debug.
2690: AHL_DEBUG_PUB.disable_debug;

Line 2690: AHL_DEBUG_PUB.disable_debug;

2686: AHL_DEBUG_PUB.debug( 'ahl_di_doc_index_pvt.Create Recipient','+REP+');
2687:
2688:
2689: -- Check if API is called in debug mode. If yes, disable debug.
2690: AHL_DEBUG_PUB.disable_debug;
2691:
2692: END IF;
2693:
2694: WHEN OTHERS THEN

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

2705: p_data => X_msg_data);
2706:
2707: -- Debug info.
2708: IF G_DEBUG='Y' THEN
2709: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'SQL ERROR' );
2710: AHL_DEBUG_PUB.debug( 'ahl_di_doc_index_pvt.Create Recipient','+REP+');
2711:
2712:
2713: -- Check if API is called in debug mode. If yes, disable debug.

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

2706:
2707: -- Debug info.
2708: IF G_DEBUG='Y' THEN
2709: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'SQL ERROR' );
2710: AHL_DEBUG_PUB.debug( 'ahl_di_doc_index_pvt.Create Recipient','+REP+');
2711:
2712:
2713: -- Check if API is called in debug mode. If yes, disable debug.
2714: AHL_DEBUG_PUB.disable_debug;

Line 2714: AHL_DEBUG_PUB.disable_debug;

2710: AHL_DEBUG_PUB.debug( 'ahl_di_doc_index_pvt.Create Recipient','+REP+');
2711:
2712:
2713: -- Check if API is called in debug mode. If yes, disable debug.
2714: AHL_DEBUG_PUB.disable_debug;
2715:
2716: END IF;
2717:
2718: END CREATE_RECIPIENT;

Line 2779: AHL_DEBUG_PUB.enable_debug;

2775: SAVEPOINT modify_recipient;
2776: -- Check if API is called in debug mode. If yes, enable debug.
2777:
2778: IF G_DEBUG='Y' THEN
2779: AHL_DEBUG_PUB.enable_debug;
2780:
2781: END IF;
2782: -- Debug info.
2783: IF G_DEBUG='Y' THEN

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

2781: END IF;
2782: -- Debug info.
2783: IF G_DEBUG='Y' THEN
2784: IF G_DEBUG='Y' THEN
2785: AHL_DEBUG_PUB.debug( 'enter ahl_di_doc_index_pvt.Modify Recipient','+REP+');
2786:
2787: END IF;
2788: END IF;
2789: -- Standard call to check for call compatibility.

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

2915: COMMIT;
2916: END IF;
2917: -- Debug info
2918: IF G_DEBUG='Y' THEN
2919: AHL_DEBUG_PUB.debug( 'End of private api Modify Recipient','+REP+');
2920:
2921: END IF;
2922: -- Check if API is called in debug mode. If yes, disable debug.
2923: IF G_DEBUG='Y' THEN

Line 2924: AHL_DEBUG_PUB.disable_debug;

2920:
2921: END IF;
2922: -- Check if API is called in debug mode. If yes, disable debug.
2923: IF G_DEBUG='Y' THEN
2924: AHL_DEBUG_PUB.disable_debug;
2925:
2926: END IF;
2927:
2928: EXCEPTION

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

2932: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
2933: p_count => x_msg_count,
2934: p_data => x_msg_data);
2935: IF G_DEBUG='Y' THEN
2936: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'ERROR' );
2937: AHL_DEBUG_PUB.debug( 'ahl_di_doc_index_pvt.Modify Recipient','+REP+');
2938:
2939: -- Check if API is called in debug mode. If yes, disable debug.
2940: AHL_DEBUG_PUB.disable_debug;

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

2933: p_count => x_msg_count,
2934: p_data => x_msg_data);
2935: IF G_DEBUG='Y' THEN
2936: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'ERROR' );
2937: AHL_DEBUG_PUB.debug( 'ahl_di_doc_index_pvt.Modify Recipient','+REP+');
2938:
2939: -- Check if API is called in debug mode. If yes, disable debug.
2940: AHL_DEBUG_PUB.disable_debug;
2941:

Line 2940: AHL_DEBUG_PUB.disable_debug;

2936: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'ERROR' );
2937: AHL_DEBUG_PUB.debug( 'ahl_di_doc_index_pvt.Modify Recipient','+REP+');
2938:
2939: -- Check if API is called in debug mode. If yes, disable debug.
2940: AHL_DEBUG_PUB.disable_debug;
2941:
2942: END IF;
2943:
2944: WHEN FND_API.G_EXC_ERROR THEN

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

2948: p_count => x_msg_count,
2949: p_data => X_msg_data);
2950: -- Debug info.
2951: IF G_DEBUG='Y' THEN
2952: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
2953: AHL_DEBUG_PUB.debug( 'ahl_di_doc_index_pvt.Modify Recipient','+REP+');
2954:
2955:
2956: -- Check if API is called in debug mode. If yes, disable debug.

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

2949: p_data => X_msg_data);
2950: -- Debug info.
2951: IF G_DEBUG='Y' THEN
2952: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
2953: AHL_DEBUG_PUB.debug( 'ahl_di_doc_index_pvt.Modify Recipient','+REP+');
2954:
2955:
2956: -- Check if API is called in debug mode. If yes, disable debug.
2957: AHL_DEBUG_PUB.disable_debug;

Line 2957: AHL_DEBUG_PUB.disable_debug;

2953: AHL_DEBUG_PUB.debug( 'ahl_di_doc_index_pvt.Modify Recipient','+REP+');
2954:
2955:
2956: -- Check if API is called in debug mode. If yes, disable debug.
2957: AHL_DEBUG_PUB.disable_debug;
2958:
2959: END IF;
2960:
2961: WHEN DUP_VAL_ON_INDEX THEN

Line 2968: AHL_DEBUG_PUB.disable_debug;

2964: FND_MESSAGE.SET_NAME('AHL','AHL_DI_RECIPIENT_DUP_RECORD');
2965: FND_MSG_PUB.ADD;
2966: -- Check if API is called in debug mode. If yes, disable debug.
2967: IF G_DEBUG='Y' THEN
2968: AHL_DEBUG_PUB.disable_debug;
2969:
2970: END IF;
2971: WHEN OTHERS THEN
2972: ROLLBACK TO modify_recipient;

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

2982: p_data => X_msg_data);
2983:
2984: -- Debug info.
2985: IF G_DEBUG='Y' THEN
2986: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'SQL ERROR' );
2987: AHL_DEBUG_PUB.debug( 'ahl_di_doc_index_pvt.Modify Recipient','+REP+');
2988:
2989:
2990: -- Check if API is called in debug mode. If yes, disable debug.

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

2983:
2984: -- Debug info.
2985: IF G_DEBUG='Y' THEN
2986: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'SQL ERROR' );
2987: AHL_DEBUG_PUB.debug( 'ahl_di_doc_index_pvt.Modify Recipient','+REP+');
2988:
2989:
2990: -- Check if API is called in debug mode. If yes, disable debug.
2991: AHL_DEBUG_PUB.disable_debug;

Line 2991: AHL_DEBUG_PUB.disable_debug;

2987: AHL_DEBUG_PUB.debug( 'ahl_di_doc_index_pvt.Modify Recipient','+REP+');
2988:
2989:
2990: -- Check if API is called in debug mode. If yes, disable debug.
2991: AHL_DEBUG_PUB.disable_debug;
2992:
2993: END IF;
2994:
2995: END MODIFY_RECIPIENT;

Line 3037: AHL_DEBUG_PUB.enable_debug;

3033: SAVEPOINT delete_recipient;
3034: -- Check if API is called in debug mode. If yes, enable debug.
3035:
3036: IF G_DEBUG='Y' THEN
3037: AHL_DEBUG_PUB.enable_debug;
3038:
3039: END IF;
3040: -- Debug info.
3041: IF G_DEBUG='Y' THEN

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

3039: END IF;
3040: -- Debug info.
3041: IF G_DEBUG='Y' THEN
3042: IF G_DEBUG='Y' THEN
3043: AHL_DEBUG_PUB.debug( 'enter ahl_di_doc_index_pvt.Delete Recipient','+REP+');
3044:
3045: END IF;
3046: END IF;
3047: -- Standard call to check for call compatibility.

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

3096: COMMIT;
3097: END IF;
3098: -- Debug info
3099: IF G_DEBUG='Y' THEN
3100: AHL_DEBUG_PUB.debug( 'End of private api Delete Recipient','+REP+');
3101:
3102: END IF;
3103: -- Check if API is called in debug mode. If yes, disable debug.
3104: IF G_DEBUG='Y' THEN

Line 3105: AHL_DEBUG_PUB.disable_debug;

3101:
3102: END IF;
3103: -- Check if API is called in debug mode. If yes, disable debug.
3104: IF G_DEBUG='Y' THEN
3105: AHL_DEBUG_PUB.disable_debug;
3106:
3107: END IF;
3108:
3109: EXCEPTION

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

3113: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
3114: p_count => x_msg_count,
3115: p_data => x_msg_data);
3116: IF G_DEBUG='Y' THEN
3117: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'ERROR' );
3118: AHL_DEBUG_PUB.debug( 'ahl_di_doc_index_pvt.Delete Recipient','+REP+');
3119:
3120:
3121: -- Check if API is called in debug mode. If yes, disable debug.

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

3114: p_count => x_msg_count,
3115: p_data => x_msg_data);
3116: IF G_DEBUG='Y' THEN
3117: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'ERROR' );
3118: AHL_DEBUG_PUB.debug( 'ahl_di_doc_index_pvt.Delete Recipient','+REP+');
3119:
3120:
3121: -- Check if API is called in debug mode. If yes, disable debug.
3122: AHL_DEBUG_PUB.disable_debug;

Line 3122: AHL_DEBUG_PUB.disable_debug;

3118: AHL_DEBUG_PUB.debug( 'ahl_di_doc_index_pvt.Delete Recipient','+REP+');
3119:
3120:
3121: -- Check if API is called in debug mode. If yes, disable debug.
3122: AHL_DEBUG_PUB.disable_debug;
3123:
3124: END IF;
3125:
3126: WHEN FND_API.G_EXC_ERROR THEN

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

3130: p_count => x_msg_count,
3131: p_data => X_msg_data);
3132: -- Debug info.
3133: IF G_DEBUG='Y' THEN
3134: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
3135: AHL_DEBUG_PUB.debug( 'ahl_di_doc_index_pvt.Delete Recipient','+REP+');
3136:
3137:
3138: -- Check if API is called in debug mode. If yes, disable debug.

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

3131: p_data => X_msg_data);
3132: -- Debug info.
3133: IF G_DEBUG='Y' THEN
3134: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
3135: AHL_DEBUG_PUB.debug( 'ahl_di_doc_index_pvt.Delete Recipient','+REP+');
3136:
3137:
3138: -- Check if API is called in debug mode. If yes, disable debug.
3139: AHL_DEBUG_PUB.disable_debug;

Line 3139: AHL_DEBUG_PUB.disable_debug;

3135: AHL_DEBUG_PUB.debug( 'ahl_di_doc_index_pvt.Delete Recipient','+REP+');
3136:
3137:
3138: -- Check if API is called in debug mode. If yes, disable debug.
3139: AHL_DEBUG_PUB.disable_debug;
3140:
3141: END IF;
3142:
3143: WHEN OTHERS THEN

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

3154: p_data => X_msg_data);
3155:
3156: -- Debug info.
3157: IF G_DEBUG='Y' THEN
3158: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'SQL ERROR' );
3159: AHL_DEBUG_PUB.debug( 'ahl_di_doc_index_pvt.Delete Recipient','+REP+');
3160:
3161:
3162: -- Check if API is called in debug mode. If yes, disable debug.

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

3155:
3156: -- Debug info.
3157: IF G_DEBUG='Y' THEN
3158: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'SQL ERROR' );
3159: AHL_DEBUG_PUB.debug( 'ahl_di_doc_index_pvt.Delete Recipient','+REP+');
3160:
3161:
3162: -- Check if API is called in debug mode. If yes, disable debug.
3163: AHL_DEBUG_PUB.disable_debug;

Line 3163: AHL_DEBUG_PUB.disable_debug;

3159: AHL_DEBUG_PUB.debug( 'ahl_di_doc_index_pvt.Delete Recipient','+REP+');
3160:
3161:
3162: -- Check if API is called in debug mode. If yes, disable debug.
3163: AHL_DEBUG_PUB.disable_debug;
3164:
3165: END IF;
3166:
3167: END DELETE_RECIPIENT;