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_DI_DOC_INDEX_PVT

Line 1: PACKAGE BODY AHL_DI_DOC_INDEX_PVT AS

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;

Line 4: G_PKG_NAME VARCHAR2(30) := 'AHL_DI_DOC_INDEX_PVT';

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;

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 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 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 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 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 724: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_DI_DOC_INDEX_PVT',

720: ROLLBACK TO create_document;
721: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
722: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
723: THEN
724: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_DI_DOC_INDEX_PVT',
725: p_procedure_name => 'CREATE_DOCUMENT',
726: p_error_text => SUBSTR(SQLERRM,1,240));
727: END IF;
728: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

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 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 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 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 1128: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_DI_DOC_INDEX_PVT',

1124: ROLLBACK TO modify_document;
1125: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1126: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1127: THEN
1128: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_DI_DOC_INDEX_PVT',
1129: p_procedure_name => 'MODIFY_DOCUMENT',
1130: p_error_text => SUBSTR(SQLERRM,1,240));
1131: END IF;
1132: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

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 1234: SELECT AHL_DI_DOC_INDEX_PVT.GET_PRODUCT_INSTALL_STATUS('PO')

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;
1237: END;
1238:

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 1432: SELECT AHL_DI_DOC_INDEX_PVT.GET_PRODUCT_INSTALL_STATUS('PO')

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;
1435: END;
1436:

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 1656: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_DI_DOC_INDEX_PVT',

1652: ROLLBACK TO create_supplier;
1653: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1654: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1655: THEN
1656: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_DI_DOC_INDEX_PVT',
1657: p_procedure_name => 'CREATE_SUPPLIER',
1658: p_error_text => SUBSTR(SQLERRM,1,240));
1659: END IF;
1660: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

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 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 1790: SELECT AHL_DI_DOC_INDEX_PVT.GET_PRODUCT_INSTALL_STATUS('PO')

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;
1793: END;
1794:

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 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 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 2030: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_DI_DOC_INDEX_PVT',

2026: ROLLBACK TO modify_supplier;
2027: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2028: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2029: THEN
2030: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_DI_DOC_INDEX_PVT',
2031: p_procedure_name => 'MODIFY_SUPPLIER',
2032: p_error_text => SUBSTR(SQLERRM,1,240));
2033: END IF;
2034: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

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 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 2157: SELECT AHL_DI_DOC_INDEX_PVT.GET_PRODUCT_INSTALL_STATUS('PO')

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;
2160: END;
2161:

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 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 2281: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_DI_DOC_INDEX_PVT',

2277: ROLLBACK TO delete_supplier;
2278: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2279: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2280: THEN
2281: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_DI_DOC_INDEX_PVT',
2282: p_procedure_name => 'DELETE_SUPPLIER',
2283: p_error_text => SUBSTR(SQLERRM,1,240));
2284: END IF;
2285: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

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 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 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 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 2699: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_DI_DOC_INDEX_PVT',

2695: ROLLBACK TO create_recipient;
2696: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2697: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2698: THEN
2699: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_DI_DOC_INDEX_PVT',
2700: p_procedure_name => 'CREATE_RECIPIENT',
2701: p_error_text => SUBSTR(SQLERRM,1,240));
2702: END IF;
2703: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

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 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 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 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 2976: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_DI_DOC_INDEX_PVT',

2972: ROLLBACK TO modify_recipient;
2973: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2974: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2975: THEN
2976: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_DI_DOC_INDEX_PVT',
2977: p_procedure_name => 'MODIFY_RECIPIENT',
2978: p_error_text => SUBSTR(SQLERRM,1,240));
2979: END IF;
2980: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

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 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 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 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 3148: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_DI_DOC_INDEX_PVT',

3144: ROLLBACK TO delete_recipient;
3145: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3146: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3147: THEN
3148: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_DI_DOC_INDEX_PVT',
3149: p_procedure_name => 'DELETE_RECIPIENT',
3150: p_error_text => SUBSTR(SQLERRM,1,240));
3151: END IF;
3152: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

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 3169: END AHL_DI_DOC_INDEX_PVT;

3165: END IF;
3166:
3167: END DELETE_RECIPIENT;
3168:
3169: END AHL_DI_DOC_INDEX_PVT;