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

Line 159: AHL_DEBUG_PUB.enable_debug;

155: BEGIN
156: -- Standard Start of API savepoint
157: SAVEPOINT create_document;
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;

Line 161: IF AHL_DEBUG_PUB.G_FILE_DEBUG THEN

157: SAVEPOINT create_document;
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.

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 394: IF AHL_DEBUG_PUB.G_FILE_DEBUG THEN

390: RAISE FND_API.G_EXC_ERROR;
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'

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 520: IF AHL_DEBUG_PUB.G_FILE_DEBUG THEN

516: --}}adharia
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'

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 1029: AHL_DEBUG_PUB.debug( 'Start AHL_DI_DOC_INDEX_CUHK.CREATE_DOCUMENT_PRE');

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
1032: (
1033:

Line 1043: AHL_DEBUG_PUB.debug( 'End AHL_DI_DOC_INDEX_CUHK.CREATE_DOCUMENT_PRE');

1039: x_msg_data => l_msg_data
1040: );
1041:
1042:
1043: AHL_DEBUG_PUB.debug( 'End AHL_DI_DOC_INDEX_CUHK.CREATE_DOCUMENT_PRE');
1044:
1045: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1046: RAISE FND_API.G_EXC_ERROR;
1047: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 1055: AHL_DEBUG_PUB.debug( 'Start AHL_DI_DOC_INDEX_VUHK.CREATE_DOCUMENT_PRE');

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:
1057: AHL_DI_DOC_INDEX_VUHK.CREATE_DOCUMENT_PRE
1058: (
1059: p_x_document_tbl => l_document_tbl ,

Line 1070: AHL_DEBUG_PUB.debug( 'End AHL_DI_DOC_INDEX_VUHK.CREATE_DOCUMENT_PRE');

1066: /*
1067: --Standard check to count messages
1068: l_msg_count := FND_MSG_PUB.count_msg;
1069: */
1070: AHL_DEBUG_PUB.debug( 'End AHL_DI_DOC_INDEX_VUHK.CREATE_DOCUMENT_PRE');
1071:
1072: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1073: RAISE FND_API.G_EXC_ERROR;
1074: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 1145: AHL_DEBUG_PUB.debug( 'Start AHL_DI_DOC_INDEX_VUHK.CREATE_DOCUMENT_POST ');

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:
1147:
1148: AHL_DI_DOC_INDEX_VUHK.CREATE_DOCUMENT_POST
1149: (

Line 1163: AHL_DEBUG_PUB.debug( 'End AHL_DI_DOC_INDEX_VUHK.CREATE_DOCUMENT_POST ');

1159: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1160: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1161: END IF;
1162:
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',

Line 1170: AHL_DEBUG_PUB.debug( 'Start AHL_DI_DOC_INDEX_CUHK.CREATE_DOCUMENT_POST');

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:
1172:
1173: AHL_DI_DOC_INDEX_CUHK.CREATE_DOCUMENT_POST(
1174:

Line 1189: AHL_DEBUG_PUB.debug( 'End AHL_DI_DOC_INDEX_CUHK.CREATE_DOCUMENT_POST');

1185: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1186: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1187: END IF;
1188:
1189: AHL_DEBUG_PUB.debug( 'End AHL_DI_DOC_INDEX_CUHK.CREATE_DOCUMENT_POST');
1190:
1191:
1192: END IF;
1193:

Line 1228: AHL_DEBUG_PUB.debug( 'End of public api Create Document','+DI+');

1224: IF FND_API.TO_BOOLEAN(p_commit) THEN
1225: COMMIT;
1226: END IF;
1227: -- Debug info
1228: AHL_DEBUG_PUB.debug( 'End of public api Create Document','+DI+');
1229: -- Check if API is called in debug mode. If yes, disable debug.
1230: AHL_DEBUG_PUB.disable_debug;
1231:
1232: EXCEPTION

Line 1230: AHL_DEBUG_PUB.disable_debug;

1226: END IF;
1227: -- Debug info
1228: AHL_DEBUG_PUB.debug( 'End of public api Create Document','+DI+');
1229: -- Check if API is called in debug mode. If yes, disable debug.
1230: AHL_DEBUG_PUB.disable_debug;
1231:
1232: EXCEPTION
1233: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1234: ROLLBACK TO create_document;

Line 1239: IF AHL_DEBUG_PUB.G_FILE_DEBUG THEN

1235: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1236: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
1237: p_count => x_msg_count,
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;

Line 1240: AHL_DEBUG_PUB.log_app_messages (

1236: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
1237: p_count => x_msg_count,
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.

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 1245: AHL_DEBUG_PUB.disable_debug;

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:
1247: WHEN FND_API.G_EXC_ERROR THEN
1248: ROLLBACK TO create_document;
1249: X_return_status := FND_API.G_RET_STS_ERROR;

Line 1254: IF AHL_DEBUG_PUB.G_FILE_DEBUG THEN

1250: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
1251: p_count => x_msg_count,
1252: p_data => X_msg_data);
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;

Line 1255: AHL_DEBUG_PUB.log_app_messages (

1251: p_count => x_msg_count,
1252: p_data => X_msg_data);
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.

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 1260: AHL_DEBUG_PUB.disable_debug;

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:
1262: WHEN OTHERS THEN
1263: ROLLBACK TO create_document;
1264: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1276: IF AHL_DEBUG_PUB.G_FILE_DEBUG THEN

1272: p_count => x_msg_count,
1273: p_data => X_msg_data);
1274:
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;

Line 1277: AHL_DEBUG_PUB.log_app_messages (

1273: p_data => X_msg_data);
1274:
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.

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 1282: AHL_DEBUG_PUB.disable_debug;

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:
1284: END CREATE_DOCUMENT;
1285: /*------------------------------------------------------*/
1286: /* procedure name: modify_document */

Line 1439: AHL_DEBUG_PUB.enable_debug;

1435: -- Standard Start of API savepoint
1436: SAVEPOINT modify_document;
1437:
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;

Line 1441: IF AHL_DEBUG_PUB.G_FILE_DEBUG THEN

1437:
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)

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 1461: IF AHL_DEBUG_PUB.G_FILE_DEBUG THEN

1457: END IF;
1458: --Start of API Body
1459:
1460: BEGIN
1461: IF AHL_DEBUG_PUB.G_FILE_DEBUG THEN
1462: AHL_DEBUG_PUB.debug( 'Fetching Product Installation Status','+DI+');
1463: END IF;
1464: Select AHL_DI_DOC_INDEX_PVT.GET_PRODUCT_INSTALL_STATUS('PO')
1465: into l_prod_install_status

Line 1462: AHL_DEBUG_PUB.debug( 'Fetching Product Installation Status','+DI+');

1458: --Start of API Body
1459:
1460: BEGIN
1461: IF AHL_DEBUG_PUB.G_FILE_DEBUG THEN
1462: AHL_DEBUG_PUB.debug( 'Fetching Product Installation Status','+DI+');
1463: END IF;
1464: Select AHL_DI_DOC_INDEX_PVT.GET_PRODUCT_INSTALL_STATUS('PO')
1465: into l_prod_install_status
1466: from dual;

Line 1709: IF AHL_DEBUG_PUB.G_FILE_DEBUG THEN

1705: RAISE FND_API.G_EXC_ERROR;
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

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 1873: IF AHL_DEBUG_PUB.G_FILE_DEBUG THEN

1869: */
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'

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 1972: AHL_DEBUG_PUB.debug( 'Start AHL_DI_DOC_INDEX_CUHK.MODIFY_DOCUMENT_PRE');

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
1975: (
1976:

Line 1986: AHL_DEBUG_PUB.debug( 'End AHL_DI_DOC_INDEX_CUHK.MODIFY_DOCUMENT_PRE');

1982: x_msg_data => l_msg_data
1983: );
1984:
1985:
1986: AHL_DEBUG_PUB.debug( 'End AHL_DI_DOC_INDEX_CUHK.MODIFY_DOCUMENT_PRE');
1987:
1988:
1989: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1990: RAISE FND_API.G_EXC_ERROR;

Line 1999: AHL_DEBUG_PUB.debug( 'Start AHL_DI_DOC_INDEX_VUHK.MODIFY_DOCUMENT_PRE');

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:
2001: AHL_DI_DOC_INDEX_VUHK.MODIFY_DOCUMENT_PRE
2002: (
2003: p_x_document_tbl => l_document_tbl ,

Line 2016: AHL_DEBUG_PUB.debug( 'End AHL_DI_DOC_INDEX_VUHK.MODIFY_DOCUMENT_PRE');

2012: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2013: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2014: END IF;
2015:
2016: AHL_DEBUG_PUB.debug( 'End AHL_DI_DOC_INDEX_VUHK.MODIFY_DOCUMENT_PRE');
2017:
2018: END IF;
2019:
2020:

Line 2088: AHL_DEBUG_PUB.debug( 'Start AHL_DI_DOC_INDEX_VUHK.MODIFY_DOCUMENT_POST');

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
2091: (
2092: p_document_tbl => l_document_tbl ,

Line 2105: AHL_DEBUG_PUB.debug( 'End AHL_DI_DOC_INDEX_VUHK.MODIFY_DOCUMENT_POST');

2101: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2102: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2103: END IF;
2104:
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' )

Line 2112: AHL_DEBUG_PUB.debug( 'Start AHL_DI_DOC_INDEX_CUHK.MODIFY_DOCUMENT_POST');

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:
2114: AHL_DI_DOC_INDEX_CUHK.MODIFY_DOCUMENT_POST(
2115:
2116: p_document_tbl => l_document_tbl ,

Line 2131: AHL_DEBUG_PUB.debug( 'End AHL_DI_DOC_INDEX_CUHK.MODIFY_DOCUMENT_POST');

2127: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2128: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2129: END IF;
2130:
2131: AHL_DEBUG_PUB.debug( 'End AHL_DI_DOC_INDEX_CUHK.MODIFY_DOCUMENT_POST');
2132:
2133: END IF;
2134:
2135: /*---------------------------------------------------------*/

Line 2147: AHL_DEBUG_PUB.debug( 'End of public api Modify Document','+DI+');

2143: IF FND_API.TO_BOOLEAN(p_commit) THEN
2144: COMMIT;
2145: END IF;
2146: -- Debug info
2147: AHL_DEBUG_PUB.debug( 'End of public api Modify Document','+DI+');
2148: -- Check if API is called in debug mode. If yes, disable debug.
2149: AHL_DEBUG_PUB.disable_debug;
2150:
2151: EXCEPTION

Line 2149: AHL_DEBUG_PUB.disable_debug;

2145: END IF;
2146: -- Debug info
2147: AHL_DEBUG_PUB.debug( 'End of public api Modify Document','+DI+');
2148: -- Check if API is called in debug mode. If yes, disable debug.
2149: AHL_DEBUG_PUB.disable_debug;
2150:
2151: EXCEPTION
2152: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2153: ROLLBACK TO modify_document;

Line 2158: IF AHL_DEBUG_PUB.G_FILE_DEBUG THEN

2154: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2155: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
2156: p_count => x_msg_count,
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;

Line 2159: AHL_DEBUG_PUB.log_app_messages (

2155: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
2156: p_count => x_msg_count,
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:

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 2165: AHL_DEBUG_PUB.disable_debug;

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;
2166:
2167: WHEN FND_API.G_EXC_ERROR THEN
2168: ROLLBACK TO modify_document;
2169: X_return_status := FND_API.G_RET_STS_ERROR;

Line 2175: IF AHL_DEBUG_PUB.G_FILE_DEBUG THEN

2171: p_count => x_msg_count,
2172: p_data => X_msg_data);
2173:
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;

Line 2176: AHL_DEBUG_PUB.log_app_messages (

2172: p_data => X_msg_data);
2173:
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.

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 2181: AHL_DEBUG_PUB.disable_debug;

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:
2183: WHEN OTHERS THEN
2184: ROLLBACK TO modify_document;
2185: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2196: IF AHL_DEBUG_PUB.G_FILE_DEBUG THEN

2192: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
2193: p_count => x_msg_count,
2194: p_data => X_msg_data);
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;

Line 2197: AHL_DEBUG_PUB.log_app_messages (

2193: p_count => x_msg_count,
2194: p_data => X_msg_data);
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:

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 2203: AHL_DEBUG_PUB.disable_debug;

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;
2204:
2205: END MODIFY_DOCUMENT;
2206:
2207: END AHL_DI_DOC_INDEX_PUB;