DBA Data[Home] [Help]

APPS.AHL_DI_DOC_INDEX_PUB dependencies on AHL_DI_DOC_INDEX_PUB

Line 1: PACKAGE BODY AHL_DI_DOC_INDEX_PUB AS

1: PACKAGE BODY AHL_DI_DOC_INDEX_PUB AS
2: /* $Header: AHLPDIXB.pls 120.1 2006/02/07 03:51:04 sagarwal noship $ */
3: --
4: G_PKG_NAME VARCHAR2(30) := 'AHL_DI_DOC_INDEX_PUB';
5: --

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

1: PACKAGE BODY AHL_DI_DOC_INDEX_PUB AS
2: /* $Header: AHLPDIXB.pls 120.1 2006/02/07 03:51:04 sagarwal noship $ */
3: --
4: G_PKG_NAME VARCHAR2(30) := 'AHL_DI_DOC_INDEX_PUB';
5: --
6: /*-----------------------------------------------------------*/
7: /* procedure name: Check_lookup_name_Or_Id(private procedure)*/
8: /* description : used to retrieve lookup code */

Line 162: AHL_DEBUG_PUB.debug( 'enter ahl_di_doc_index_pub.Create Document','+DI+');

158: -- Check if API is called in debug mode. If yes, enable debug.
159: AHL_DEBUG_PUB.enable_debug;
160: -- Debug info.
161: IF AHL_DEBUG_PUB.G_FILE_DEBUG THEN
162: AHL_DEBUG_PUB.debug( 'enter ahl_di_doc_index_pub.Create Document','+DI+');
163: END IF;
164:
165: -- Standard call to check for call compatibility.
166: IF FND_API.to_boolean(l_init_msg_list)

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

391: END IF;
392: END IF;
393: -- Debug info.
394: IF AHL_DEBUG_PUB.G_FILE_DEBUG THEN
395: AHL_DEBUG_PUB.debug( 'Before processing Supplier Record ahl_di_doc_index_pub.create_document','+DI+');
396: END IF;
397: --For Supplier Record, If the process flag is 'S' i.e Create Supplier
398: ELSIF p_x_document_tbl(i).process_flag = 'S'
399: THEN

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

517: END LOOP;
518: END IF;
519: -- Debug info.
520: IF AHL_DEBUG_PUB.G_FILE_DEBUG THEN
521: AHL_DEBUG_PUB.debug( 'Before processing Recipient Record ahl_di_doc_index_pub.create_document','+DI+');
522: END IF;
523: --for Creating Recipient Record, 'R'
524: ELSIF p_x_document_tbl(i).process_flag = 'R'
525: THEN

Line 1027: IF JTF_USR_HKS.Ok_to_Execute( 'AHL_DI_DOC_INDEX_PUB','CREATE_DOCUMENT',

1023: /* Date : Dec 28 2001 */
1024: /*-----------------------------------------------------------*/
1025:
1026:
1027: IF JTF_USR_HKS.Ok_to_Execute( 'AHL_DI_DOC_INDEX_PUB','CREATE_DOCUMENT',
1028: 'B', 'C' ) then
1029: AHL_DEBUG_PUB.debug( 'Start AHL_DI_DOC_INDEX_CUHK.CREATE_DOCUMENT_PRE');
1030:
1031: AHL_DI_DOC_INDEX_CUHK.CREATE_DOCUMENT_PRE

Line 1052: IF JTF_USR_HKS.Ok_to_Execute( 'AHL_DI_DOC_INDEX_PUB','CREATE_DOCUMENT','B', 'V' )

1048: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1049: END IF;
1050: END IF;
1051:
1052: IF JTF_USR_HKS.Ok_to_Execute( 'AHL_DI_DOC_INDEX_PUB','CREATE_DOCUMENT','B', 'V' )
1053: then
1054:
1055: AHL_DEBUG_PUB.debug( 'Start AHL_DI_DOC_INDEX_VUHK.CREATE_DOCUMENT_PRE');
1056:

Line 1142: IF JTF_USR_HKS.Ok_to_Execute( 'AHL_DI_DOC_INDEX_PUB','CREATE_DOCUMENT',

1138: /* description : Added by ssaklani to call User Hooks */
1139: /* Date : Dec 28 2001 */
1140: /*------------------------------------------------------------------------------*/
1141:
1142: IF JTF_USR_HKS.Ok_to_Execute( 'AHL_DI_DOC_INDEX_PUB','CREATE_DOCUMENT',
1143: 'A', 'V' ) then
1144:
1145: AHL_DEBUG_PUB.debug( 'Start AHL_DI_DOC_INDEX_VUHK.CREATE_DOCUMENT_POST ');
1146:

Line 1167: IF JTF_USR_HKS.Ok_to_Execute( 'AHL_DI_DOC_INDEX_PUB','CREATE_DOCUMENT',

1163: AHL_DEBUG_PUB.debug( 'End AHL_DI_DOC_INDEX_VUHK.CREATE_DOCUMENT_POST ');
1164:
1165: END IF;
1166:
1167: IF JTF_USR_HKS.Ok_to_Execute( 'AHL_DI_DOC_INDEX_PUB','CREATE_DOCUMENT',
1168: 'A', 'C' ) then
1169:
1170: AHL_DEBUG_PUB.debug( 'Start AHL_DI_DOC_INDEX_CUHK.CREATE_DOCUMENT_POST');
1171:

Line 1242: AHL_DEBUG_PUB.debug( 'ahl_di_doc_index_pub.Create Document','+DI+');

1238: p_data => x_msg_data);
1239: IF AHL_DEBUG_PUB.G_FILE_DEBUG THEN
1240: AHL_DEBUG_PUB.log_app_messages (
1241: x_msg_count, x_msg_data, 'ERROR' );
1242: AHL_DEBUG_PUB.debug( 'ahl_di_doc_index_pub.Create Document','+DI+');
1243: END IF;
1244: -- Check if API is called in debug mode. If yes, disable debug.
1245: AHL_DEBUG_PUB.disable_debug;
1246:

Line 1257: AHL_DEBUG_PUB.debug( 'ahl_di_doc_index_pub.Create Document','+DI+');

1253: -- Debug info.
1254: IF AHL_DEBUG_PUB.G_FILE_DEBUG THEN
1255: AHL_DEBUG_PUB.log_app_messages (
1256: x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
1257: AHL_DEBUG_PUB.debug( 'ahl_di_doc_index_pub.Create Document','+DI+');
1258: END IF;
1259: -- Check if API is called in debug mode. If yes, disable debug.
1260: AHL_DEBUG_PUB.disable_debug;
1261:

Line 1267: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_DI_DOC_INDEX_PUB',

1263: ROLLBACK TO create_document;
1264: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1265: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1266: THEN
1267: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_DI_DOC_INDEX_PUB',
1268: p_procedure_name => 'CREATE_DOCUMENT',
1269: p_error_text => SUBSTR(SQLERRM,1,240));
1270: END IF;
1271: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

Line 1279: AHL_DEBUG_PUB.debug( 'ahl_di_doc_index_pub.Create Document','+DI+');

1275: -- Debug info.
1276: IF AHL_DEBUG_PUB.G_FILE_DEBUG THEN
1277: AHL_DEBUG_PUB.log_app_messages (
1278: x_msg_count, x_msg_data, 'SQL ERROR' );
1279: AHL_DEBUG_PUB.debug( 'ahl_di_doc_index_pub.Create Document','+DI+');
1280: END IF;
1281: -- Check if API is called in debug mode. If yes, disable debug.
1282: AHL_DEBUG_PUB.disable_debug;
1283:

Line 1442: AHL_DEBUG_PUB.debug( 'enter ahl_di_doc_index_pub.Modify Document','+DI+');

1438: -- Check if API is called in debug mode. If yes, enable debug.
1439: AHL_DEBUG_PUB.enable_debug;
1440: -- Debug info.
1441: IF AHL_DEBUG_PUB.G_FILE_DEBUG THEN
1442: AHL_DEBUG_PUB.debug( 'enter ahl_di_doc_index_pub.Modify Document','+DI+');
1443: END IF;
1444: -- Standard call to check for call compatibility.
1445: IF FND_API.to_boolean(l_init_msg_list)
1446: THEN

Line 1710: AHL_DEBUG_PUB.debug( 'Before processing Supplier Record ahl_di_doc_index_pub.modify document','+DI+');

1706: END IF;
1707: END IF;
1708: -- Debug info.
1709: IF AHL_DEBUG_PUB.G_FILE_DEBUG THEN
1710: AHL_DEBUG_PUB.debug( 'Before processing Supplier Record ahl_di_doc_index_pub.modify document','+DI+');
1711: END IF;
1712:
1713: --For update supplier record
1714: ELSIF p_x_document_tbl(i).process_flag = 'S'

Line 1874: AHL_DEBUG_PUB.debug( 'Before processing Recipient Record ahl_di_doc_index_pub.modify document','+DI+');

1870: END LOOP;
1871: END IF;
1872: -- Debug info.
1873: IF AHL_DEBUG_PUB.G_FILE_DEBUG THEN
1874: AHL_DEBUG_PUB.debug( 'Before processing Recipient Record ahl_di_doc_index_pub.modify document','+DI+');
1875: END IF;
1876: --For Update Recipient Record
1877: ELSIF p_x_document_tbl(i).process_flag = 'R'
1878: THEN

Line 1970: IF JTF_USR_HKS.Ok_to_Execute( 'AHL_DI_DOC_INDEX_PUB','MODIFY_DOCUMENT',

1966: /* Date : Dec 28 2001 */
1967: /*-----------------------------------------------------------*/
1968:
1969:
1970: IF JTF_USR_HKS.Ok_to_Execute( 'AHL_DI_DOC_INDEX_PUB','MODIFY_DOCUMENT',
1971: 'B', 'C' ) then
1972: AHL_DEBUG_PUB.debug( 'Start AHL_DI_DOC_INDEX_CUHK.MODIFY_DOCUMENT_PRE');
1973:
1974: AHL_DI_DOC_INDEX_CUHK.MODIFY_DOCUMENT_PRE

Line 1996: IF JTF_USR_HKS.Ok_to_Execute( 'AHL_DI_DOC_INDEX_PUB','MODIFY_DOCUMENT',

1992: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1993: END IF;
1994: END IF;
1995:
1996: IF JTF_USR_HKS.Ok_to_Execute( 'AHL_DI_DOC_INDEX_PUB','MODIFY_DOCUMENT',
1997: 'B', 'V' ) then
1998:
1999: AHL_DEBUG_PUB.debug( 'Start AHL_DI_DOC_INDEX_VUHK.MODIFY_DOCUMENT_PRE');
2000:

Line 2086: IF JTF_USR_HKS.Ok_to_Execute( 'AHL_DI_DOC_INDEX_PUB','MODIFY_DOCUMENT','A', 'V' )

2082: /*------------------------------------------------------------------------------*/
2083:
2084:
2085:
2086: IF JTF_USR_HKS.Ok_to_Execute( 'AHL_DI_DOC_INDEX_PUB','MODIFY_DOCUMENT','A', 'V' )
2087: then
2088: AHL_DEBUG_PUB.debug( 'Start AHL_DI_DOC_INDEX_VUHK.MODIFY_DOCUMENT_POST');
2089:
2090: AHL_DI_DOC_INDEX_VUHK.MODIFY_DOCUMENT_POST

Line 2109: IF JTF_USR_HKS.Ok_to_Execute( 'AHL_DI_DOC_INDEX_PUB','MODIFY_DOCUMENT','A', 'C' )

2105: AHL_DEBUG_PUB.debug( 'End AHL_DI_DOC_INDEX_VUHK.MODIFY_DOCUMENT_POST');
2106:
2107: END IF;
2108:
2109: IF JTF_USR_HKS.Ok_to_Execute( 'AHL_DI_DOC_INDEX_PUB','MODIFY_DOCUMENT','A', 'C' )
2110: then
2111:
2112: AHL_DEBUG_PUB.debug( 'Start AHL_DI_DOC_INDEX_CUHK.MODIFY_DOCUMENT_POST');
2113:

Line 2161: AHL_DEBUG_PUB.debug( 'ahl_di_doc_index_pub.Modify Document','+DI+');

2157: p_data => x_msg_data);
2158: IF AHL_DEBUG_PUB.G_FILE_DEBUG THEN
2159: AHL_DEBUG_PUB.log_app_messages (
2160: x_msg_count, x_msg_data, 'ERROR' );
2161: AHL_DEBUG_PUB.debug( 'ahl_di_doc_index_pub.Modify Document','+DI+');
2162: END IF;
2163:
2164: -- Check if API is called in debug mode. If yes, disable debug.
2165: AHL_DEBUG_PUB.disable_debug;

Line 2178: AHL_DEBUG_PUB.debug( 'ahl_di_doc_index_pub.Modify Document','+DI+');

2174: -- Debug info.
2175: IF AHL_DEBUG_PUB.G_FILE_DEBUG THEN
2176: AHL_DEBUG_PUB.log_app_messages (
2177: x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
2178: AHL_DEBUG_PUB.debug( 'ahl_di_doc_index_pub.Modify Document','+DI+');
2179: END IF;
2180: -- Check if API is called in debug mode. If yes, disable debug.
2181: AHL_DEBUG_PUB.disable_debug;
2182:

Line 2199: AHL_DEBUG_PUB.debug( 'ahl_di_doc_index_pub.Modify Document','+DI+');

2195: -- Debug info.
2196: IF AHL_DEBUG_PUB.G_FILE_DEBUG THEN
2197: AHL_DEBUG_PUB.log_app_messages (
2198: x_msg_count, x_msg_data, 'SQL ERROR' );
2199: AHL_DEBUG_PUB.debug( 'ahl_di_doc_index_pub.Modify Document','+DI+');
2200: END IF;
2201:
2202: -- Check if API is called in debug mode. If yes, disable debug.
2203: AHL_DEBUG_PUB.disable_debug;

Line 2207: END AHL_DI_DOC_INDEX_PUB;

2203: AHL_DEBUG_PUB.disable_debug;
2204:
2205: END MODIFY_DOCUMENT;
2206:
2207: END AHL_DI_DOC_INDEX_PUB;