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

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

8:
9: G_VENDOR_DEPT_CLASS_CODE CONSTANT VARCHAR2(30) := 'Vendor';
10:
11: --G_DEBUG VARCHAR2(1):=FND_PROFILE.VALUE('AHL_API_FILE_DEBUG_ON');
12: G_DEBUG VARCHAR2(1) := AHL_DEBUG_PUB.is_log_enabled;
13: G_LOG_PREFIX CONSTANT VARCHAR2(100) := 'ahl.plsql.AHL_OSP_QUERIES_PVT';
14:
15:
16: FUNCTION Get_Suggested_Vendor(p_work_order_id IN NUMBER ,

Line 131: AHL_DEBUG_PUB.enable_debug;

127: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY || '.begin', 'Entering Procedure');
128: END IF;
129:
130: IF G_DEBUG='Y' THEN
131: AHL_DEBUG_PUB.enable_debug;
132:
133: END IF;
134:
135: -- Standard call to check for call compatibility

Line 294: AHL_DEBUG_PUB.debug(SUBSTR( l_sql_string, 1, 1000), 'SEARCH_OSP: ');

290:
291: l_sql_string := l_sql_string || ' ORDER BY OSP.OSP_ORDER_ID DESC ';
292:
293: IF G_DEBUG='Y' THEN
294: AHL_DEBUG_PUB.debug(SUBSTR( l_sql_string, 1, 1000), 'SEARCH_OSP: ');
295: END IF;
296:
297: --remove this line when not test
298: --l_sql_string := l_sql_string || ' WHERE ROWNUM < 3 ';

Line 354: AHL_DEBUG_PUB.debug(' x_results_count:-' || x_results_count);

350: WHEN NO_DATA_FOUND THEN
351: x_results_count := 0;
352: END;
353: IF G_DEBUG='Y' THEN
354: AHL_DEBUG_PUB.debug(' x_results_count:-' || x_results_count);
355: END IF;
356:
357: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
358: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY || '.end', 'End Procedure');

Line 504: AHL_DEBUG_PUB.enable_debug;

500: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY || '.begin', 'Entering Procedure');
501: END IF;
502:
503: IF G_DEBUG='Y' THEN
504: AHL_DEBUG_PUB.enable_debug;
505:
506: END IF;
507:
508: -- Standard call to check for call compatibility

Line 616: AHL_DEBUG_PUB.debug(SUBSTR(l_sql_string,1, 1000), 'SEARCH_WO: ');

612:
613: l_sql_string := l_sql_string || ' ORDER BY JOB_NUMBER ';
614:
615: IF G_DEBUG='Y' THEN
616: AHL_DEBUG_PUB.debug(SUBSTR(l_sql_string,1, 1000), 'SEARCH_WO: ');
617: END IF;
618:
619: AHL_OSP_UTIL_PKG.OPEN_SEARCH_CURSOR(l_wo_cur, l_conditions, l_sql_string);
620: i := 0;

Line 662: AHL_DEBUG_PUB.debug(' x_results_count:-' || x_results_count);

658: WHEN NO_DATA_FOUND THEN
659: x_results_count := 0;
660: END;
661: IF G_DEBUG='Y' THEN
662: AHL_DEBUG_PUB.debug(' x_results_count:-' || x_results_count);
663: END IF;
664:
665:
666:

Line 854: AHL_DEBUG_PUB.debug('Before Calling Associate_OSP_With_PO', 'GET_HEADER_AND_LINES: ');

850: IF (P_OSP_ID IS NOT NULL) THEN
851:
852:
853: IF G_DEBUG='Y' THEN
854: AHL_DEBUG_PUB.debug('Before Calling Associate_OSP_With_PO', 'GET_HEADER_AND_LINES: ');
855: END IF;
856: -- CALL PO API to synch OSP with PO
857: AHL_OSP_PO_PVT.Associate_OSP_With_PO
858: (

Line 874: AHL_DEBUG_PUB.debug('After Calling Associate_OSP_With_PO', 'GET_HEADER_AND_LINES: ');

870: );
871:
872: IF G_DEBUG='Y' THEN
873: IF G_DEBUG='Y' THEN
874: AHL_DEBUG_PUB.debug('After Calling Associate_OSP_With_PO', 'GET_HEADER_AND_LINES: ');
875:
876: END IF;
877: IF G_DEBUG='Y' THEN
878: AHL_DEBUG_PUB.debug('x_return_status' || x_return_status, 'GET_HEADER_AND_LINES: ');

Line 878: AHL_DEBUG_PUB.debug('x_return_status' || x_return_status, 'GET_HEADER_AND_LINES: ');

874: AHL_DEBUG_PUB.debug('After Calling Associate_OSP_With_PO', 'GET_HEADER_AND_LINES: ');
875:
876: END IF;
877: IF G_DEBUG='Y' THEN
878: AHL_DEBUG_PUB.debug('x_return_status' || x_return_status, 'GET_HEADER_AND_LINES: ');
879:
880: END IF;
881: IF G_DEBUG='Y' THEN
882: AHL_DEBUG_PUB.debug('x_msg_data' || x_msg_data, 'GET_HEADER_AND_LINES: ');

Line 882: AHL_DEBUG_PUB.debug('x_msg_data' || x_msg_data, 'GET_HEADER_AND_LINES: ');

878: AHL_DEBUG_PUB.debug('x_return_status' || x_return_status, 'GET_HEADER_AND_LINES: ');
879:
880: END IF;
881: IF G_DEBUG='Y' THEN
882: AHL_DEBUG_PUB.debug('x_msg_data' || x_msg_data, 'GET_HEADER_AND_LINES: ');
883:
884: END IF;
885:
886: END IF;

Line 922: AHL_DEBUG_PUB.debug('l_header_queries: ' || SUBSTR(l_header_queries,1, 900), 'GET_HEADER_AND_LINES: ');

918: l_header_queries := l_header_queries || p_osp_id;
919:
920:
921: IF G_DEBUG='Y' THEN
922: AHL_DEBUG_PUB.debug('l_header_queries: ' || SUBSTR(l_header_queries,1, 900), 'GET_HEADER_AND_LINES: ');
923: END IF;
924:
925: --dbms_output.put_line( 'SQL:' || l_header_queries );
926: OPEN l_header_csr FOR l_header_queries;

Line 957: AHL_DEBUG_PUB.debug('After Fetch l_header_queries: ' , 'GET_HEADER_AND_LINES: ');

953: contract_number;
954:
955:
956: IF G_DEBUG='Y' THEN
957: AHL_DEBUG_PUB.debug('After Fetch l_header_queries: ' , 'GET_HEADER_AND_LINES: ');
958: END IF;
959:
960: x_order_header_rec.OSP_ID := OSP_ID;
961: x_order_header_rec.object_version_number := object_version_number;

Line 990: AHL_DEBUG_PUB.debug('After Assign to x_order_header_rec: ' , 'GET_HEADER_AND_LINES: ');

986:
987: CLOSE l_header_csr;
988:
989: IF G_DEBUG='Y' THEN
990: AHL_DEBUG_PUB.debug('After Assign to x_order_header_rec: ' , 'GET_HEADER_AND_LINES: ');
991: END IF;
992:
993: ELSE
994: --In Create Mode get Default Values for Order Header

Line 1206: AHL_DEBUG_PUB.enable_debug;

1202: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1203: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY || '.begin', 'Entering Procedure');
1204: END IF;
1205: IF G_DEBUG='Y' THEN
1206: AHL_DEBUG_PUB.enable_debug;
1207: END IF;
1208:
1209: IF G_DEBUG='Y' THEN
1210: IF G_DEBUG='Y' THEN

Line 1211: AHL_DEBUG_PUB.debug('Begin Get_order_lines', 'GET_ORDER_LINES: ');

1207: END IF;
1208:
1209: IF G_DEBUG='Y' THEN
1210: IF G_DEBUG='Y' THEN
1211: AHL_DEBUG_PUB.debug('Begin Get_order_lines', 'GET_ORDER_LINES: ');
1212:
1213: END IF;
1214: --i := 0;
1215: IF P_work_order_ids IS NULL THEN

Line 1217: AHL_DEBUG_PUB.debug('P_work_order_ids is null', 'GET_ORDER_LINES: ');

1213: END IF;
1214: --i := 0;
1215: IF P_work_order_ids IS NULL THEN
1216: IF G_DEBUG='Y' THEN
1217: AHL_DEBUG_PUB.debug('P_work_order_ids is null', 'GET_ORDER_LINES: ');
1218: END IF;
1219: END IF;
1220:
1221: IF G_DEBUG='Y' THEN

Line 1222: AHL_DEBUG_PUB.debug('P_osp_id = ' || P_osp_id, 'GET_ORDER_LINES: ');

1218: END IF;
1219: END IF;
1220:
1221: IF G_DEBUG='Y' THEN
1222: AHL_DEBUG_PUB.debug('P_osp_id = ' || P_osp_id, 'GET_ORDER_LINES: ');
1223: END IF;
1224:
1225: END IF;
1226:

Line 1280: AHL_DEBUG_PUB.debug('l_line_queries: ' || SUBSTR(l_line_queries, 1, 900), 'GET_ORDER_LINES: ');

1276: l_line_queries := l_line_queries || ' ORDER BY OSP_LINE_NUMBER ';
1277:
1278:
1279: IF G_DEBUG='Y' THEN
1280: AHL_DEBUG_PUB.debug('l_line_queries: ' || SUBSTR(l_line_queries, 1, 900), 'GET_ORDER_LINES: ');
1281: END IF;
1282:
1283: OPEN l_line_csr FOR l_line_queries;
1284: i := 0;

Line 1320: AHL_DEBUG_PUB.debug('After FETCH Order Lines', 'GET_ORDER_LINES: ');

1316:
1317: EXIT WHEN l_line_csr%NOTFOUND;
1318:
1319: IF G_DEBUG='Y' THEN
1320: AHL_DEBUG_PUB.debug('After FETCH Order Lines', 'GET_ORDER_LINES: ');
1321: END IF;
1322:
1323: x_order_lines_tbl(i).OSP_ORDER_LINE_ID := l_osp_order_line_id;
1324: x_order_lines_tbl(i).OBJECT_VERSION_NUMBER := l_object_version_number;

Line 1356: AHL_DEBUG_PUB.debug('After Assign Order Lines', 'GET_ORDER_LINES: ');

1352: x_order_lines_tbl(i).PRJ_TASK_ID := l_PROJECT_TASK_ID ;
1353: x_order_lines_tbl(i).PRJ_TASK_NAME := l_PROJECT_TASK_NAME ;
1354:
1355: IF G_DEBUG='Y' THEN
1356: AHL_DEBUG_PUB.debug('After Assign Order Lines', 'GET_ORDER_LINES: ');
1357: END IF;
1358:
1359: i:= i + 1;
1360:

Line 1399: AHL_DEBUG_PUB.debug('Search_WO: l_line_queries = ' || SUBSTR(l_line_queries, 1, 900));

1395: END LOOP;
1396: l_line_queries := l_line_queries || ' )';
1397:
1398: IF G_DEBUG='Y' THEN
1399: AHL_DEBUG_PUB.debug('Search_WO: l_line_queries = ' || SUBSTR(l_line_queries, 1, 900));
1400: END IF;
1401:
1402: IF G_DEBUG='Y' THEN
1403: AHL_DEBUG_PUB.debug('l_line_queries: ' || SUBSTR(l_line_queries, 1, 900), 'GET_ORDER_LINES: ');

Line 1403: AHL_DEBUG_PUB.debug('l_line_queries: ' || SUBSTR(l_line_queries, 1, 900), 'GET_ORDER_LINES: ');

1399: AHL_DEBUG_PUB.debug('Search_WO: l_line_queries = ' || SUBSTR(l_line_queries, 1, 900));
1400: END IF;
1401:
1402: IF G_DEBUG='Y' THEN
1403: AHL_DEBUG_PUB.debug('l_line_queries: ' || SUBSTR(l_line_queries, 1, 900), 'GET_ORDER_LINES: ');
1404: END IF;
1405:
1406: OPEN l_line_csr FOR l_line_queries;
1407: i := 0;