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_PRD_DISP_UTIL_PVT dependencies on FND_LOG

Line 227: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

223: IF FND_API.to_boolean( p_init_msg_list ) THEN
224: FND_MSG_PUB.initialize;
225: END IF;
226:
227: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
228: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
229: G_LOG_PREFIX||l_api_name||': Begin API',
230: 'At the start of the procedure and p_workorder_id = '||p_workorder_id||
231: ' p_start_row = '||p_start_row||' p_rows_per_page='||p_rows_per_page);

Line 228: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

224: FND_MSG_PUB.initialize;
225: END IF;
226:
227: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
228: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
229: G_LOG_PREFIX||l_api_name||': Begin API',
230: 'At the start of the procedure and p_workorder_id = '||p_workorder_id||
231: ' p_start_row = '||p_start_row||' p_rows_per_page='||p_rows_per_page);
232: END IF;

Line 329: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

325: CLOSE get_con_status_id;
326: END IF;
327: END IF;
328:
329: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
330: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
331: G_LOG_PREFIX||l_api_name||': Finish the value to id conversion and validation',
332: 'At the end of the procedure');
333: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

Line 330: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

326: END IF;
327: END IF;
328:
329: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
330: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
331: G_LOG_PREFIX||l_api_name||': Finish the value to id conversion and validation',
332: 'At the end of the procedure');
333: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
334: G_LOG_PREFIX||l_api_name||': l_path_position_id='||l_path_position_id||

Line 333: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

329: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
330: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
331: G_LOG_PREFIX||l_api_name||': Finish the value to id conversion and validation',
332: 'At the end of the procedure');
333: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
334: G_LOG_PREFIX||l_api_name||': l_path_position_id='||l_path_position_id||
335: 'l_path_pos_comm_id='||l_path_pos_comm_id||'l_item_group_id='||l_item_group_id||
336: 'l_inv_item_id='||l_inv_item_id||'l_con_status_id='||l_con_status_id);
337: END IF;

Line 422: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

418: IF l_where_str IS NOT NULL THEN
419: l_sql_str := l_sql_str || ' WHERE ' || l_where_str ;
420: END IF;
421:
422: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
423: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
424: G_LOG_PREFIX||l_api_name||': Within the API',
425: 'p_disp_filter_rec.condition_code='||p_disp_filter_rec.condition_code);
426: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

Line 423: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

419: l_sql_str := l_sql_str || ' WHERE ' || l_where_str ;
420: END IF;
421:
422: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
423: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
424: G_LOG_PREFIX||l_api_name||': Within the API',
425: 'p_disp_filter_rec.condition_code='||p_disp_filter_rec.condition_code);
426: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
427: G_LOG_PREFIX||l_api_name||': Within the API',

Line 426: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

422: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
423: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
424: G_LOG_PREFIX||l_api_name||': Within the API',
425: 'p_disp_filter_rec.condition_code='||p_disp_filter_rec.condition_code);
426: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
427: G_LOG_PREFIX||l_api_name||': Within the API',
428: 'l_sql_str='||substr(l_sql_str, 1, 254));
429: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
430: G_LOG_PREFIX||l_api_name||': Within the API',

Line 429: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

425: 'p_disp_filter_rec.condition_code='||p_disp_filter_rec.condition_code);
426: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
427: G_LOG_PREFIX||l_api_name||': Within the API',
428: 'l_sql_str='||substr(l_sql_str, 1, 254));
429: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
430: G_LOG_PREFIX||l_api_name||': Within the API',
431: 'l_sql_str='||substr(l_sql_str, 255, 500));
432: END IF;
433: --dbms_output.put_line(substr(l_sql_str,1, 254));

Line 571: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

567: x_disp_list_tbl(i).off_serial_number := l_part_change_instance.off_serial_number;
568: x_disp_list_tbl(i).off_lot_number := l_part_change_instance.off_lot_number;
569: x_disp_list_tbl(i).off_quantity := l_part_change_instance.off_quantity;
570: x_disp_list_tbl(i).off_uom := l_part_change_instance.off_uom;
571: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
572: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
573: G_LOG_PREFIX||l_api_name,
574: 'x_disp_list_tbl(i).off_inv_item_id '|| x_disp_list_tbl(i).off_inv_item_id||
575: 'x_disp_list_tbl(i).off_item_number ' || x_disp_list_tbl(i).off_item_number );

Line 572: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

568: x_disp_list_tbl(i).off_lot_number := l_part_change_instance.off_lot_number;
569: x_disp_list_tbl(i).off_quantity := l_part_change_instance.off_quantity;
570: x_disp_list_tbl(i).off_uom := l_part_change_instance.off_uom;
571: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
572: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
573: G_LOG_PREFIX||l_api_name,
574: 'x_disp_list_tbl(i).off_inv_item_id '|| x_disp_list_tbl(i).off_inv_item_id||
575: 'x_disp_list_tbl(i).off_item_number ' || x_disp_list_tbl(i).off_item_number );
576: END IF;

Line 702: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

698: END IF;
699: END LOOP;
700: END IF;
701:
702: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
703: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
704: G_LOG_PREFIX||l_api_name||': After normal execution',
705: 'At the end of the procedure');
706: END IF;

Line 703: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

699: END LOOP;
700: END IF;
701:
702: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
703: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
704: G_LOG_PREFIX||l_api_name||': After normal execution',
705: 'At the end of the procedure');
706: END IF;
707:

Line 1323: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1319: SAVEPOINT Get_Part_Change_Disp_Pvt;
1320:
1321: -- Initialize Procedure return status to success
1322: x_return_status := FND_API.G_RET_STS_SUCCESS;
1323: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1324: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1325: G_LOG_PREFIX||l_api_name||': Begin API',
1326: 'Entering the Procedure.');
1327: END IF;

Line 1324: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

1320:
1321: -- Initialize Procedure return status to success
1322: x_return_status := FND_API.G_RET_STS_SUCCESS;
1323: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1324: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1325: G_LOG_PREFIX||l_api_name||': Begin API',
1326: 'Entering the Procedure.');
1327: END IF;
1328:

Line 1333: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1329: IF (FND_API.to_boolean(p_init_msg_list)) THEN
1330: FND_MSG_PUB.initialize;
1331: END IF;
1332:
1333: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1334: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1335: G_LOG_PREFIX||l_api_name,
1336: 'About to call AHL_MC_PATH_POSITION_PVT.Map_Instance_To_Pos_ID with ' ||
1337: 'p_csi_item_instance_id = ' || p_parent_instance_id ||

Line 1334: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

1330: FND_MSG_PUB.initialize;
1331: END IF;
1332:
1333: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1334: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1335: G_LOG_PREFIX||l_api_name,
1336: 'About to call AHL_MC_PATH_POSITION_PVT.Map_Instance_To_Pos_ID with ' ||
1337: 'p_csi_item_instance_id = ' || p_parent_instance_id ||
1338: ', p_relationship_id = ' || p_relationship_id);

Line 1370: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1366: p_csi_item_instance_id => p_parent_instance_id,
1367: p_relationship_id => p_relationship_id,
1368: x_path_position_id => l_path_position_id);
1369:
1370: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1371: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1372: G_LOG_PREFIX||l_api_name,
1373: 'Returned from call to AHL_MC_PATH_POSITION_PVT.Map_Instance_To_Pos_ID.' ||
1374: ' x_path_position_id = ' || l_path_position_id);

Line 1371: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

1367: p_relationship_id => p_relationship_id,
1368: x_path_position_id => l_path_position_id);
1369:
1370: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1371: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1372: G_LOG_PREFIX||l_api_name,
1373: 'Returned from call to AHL_MC_PATH_POSITION_PVT.Map_Instance_To_Pos_ID.' ||
1374: ' x_path_position_id = ' || l_path_position_id);
1375: END IF;

Line 1383: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1379: OPEN check_installed_csr (p_parent_instance_id, p_relationship_id);
1380: FETCH check_installed_csr into l_csi_instance_id;
1381: --If installed
1382: IF (check_installed_csr%FOUND) THEN
1383: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1384: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1385: G_LOG_PREFIX||l_api_name,
1386: 'Instance is installed. Getting disposition for ' ||
1387: ' l_path_position_id = ' || l_path_position_id ||

Line 1384: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

1380: FETCH check_installed_csr into l_csi_instance_id;
1381: --If installed
1382: IF (check_installed_csr%FOUND) THEN
1383: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1384: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1385: G_LOG_PREFIX||l_api_name,
1386: 'Instance is installed. Getting disposition for ' ||
1387: ' l_path_position_id = ' || l_path_position_id ||
1388: ' and l_csi_instance_id = ' || l_csi_instance_id);

Line 1406: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1402: END IF;
1403: END IF;
1404: CLOSE get_rem_disposition_csr;
1405: ELSE
1406: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1407: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1408: G_LOG_PREFIX||l_api_name,
1409: 'Instance is NOT installed. Getting disposition for ' ||
1410: 'l_path_position_id = ' || l_path_position_id);

Line 1407: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

1403: END IF;
1404: CLOSE get_rem_disposition_csr;
1405: ELSE
1406: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1407: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1408: G_LOG_PREFIX||l_api_name,
1409: 'Instance is NOT installed. Getting disposition for ' ||
1410: 'l_path_position_id = ' || l_path_position_id);
1411: END IF;

Line 1433: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1429:
1430: -- SATHAPLI::FP OGMA Issue# 105 - Non-Serialized Item Maintenance, 17-Dec-2007
1431: -- Check for the disposition id not being set as -1 in the above checks.
1432: IF (l_found_flag = true AND (NVL(x_disposition_rec.disposition_id,0) <> -1)) THEN
1433: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1434: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1435: G_LOG_PREFIX||l_api_name,
1436: 'Found matching Disposition. l_disp_rec.disposition_id = ' || l_disp_rec.disposition_id);
1437: END IF;

Line 1434: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

1430: -- SATHAPLI::FP OGMA Issue# 105 - Non-Serialized Item Maintenance, 17-Dec-2007
1431: -- Check for the disposition id not being set as -1 in the above checks.
1432: IF (l_found_flag = true AND (NVL(x_disposition_rec.disposition_id,0) <> -1)) THEN
1433: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1434: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1435: G_LOG_PREFIX||l_api_name,
1436: 'Found matching Disposition. l_disp_rec.disposition_id = ' || l_disp_rec.disposition_id);
1437: END IF;
1438: x_disposition_rec.disposition_id := l_disp_rec.disposition_id;

Line 1491: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1487: x_sec_disp_type_tbl => x_sec_disp_type_tbl);
1488: ELSE
1489: --No matching disposition, must create new.
1490: --x_disposition_rec is null
1491: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1492: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1493: G_LOG_PREFIX||l_api_name,
1494: 'Could not find any matching Disposition.');
1495: END IF;

Line 1492: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

1488: ELSE
1489: --No matching disposition, must create new.
1490: --x_disposition_rec is null
1491: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1492: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1493: G_LOG_PREFIX||l_api_name,
1494: 'Could not find any matching Disposition.');
1495: END IF;
1496: Ahl_prd_disp_util_pvt.Get_Available_Disp_Types (

Line 2118: IF (FND_LOG.LEVEL_EVENT>= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2114: l_req_material_u_rec.requested_quantity := l_mtl_requirement.requested_quantity + l_delta_quantity;
2115: l_req_material_u_rec.OPERATION_FLAG := 'U';
2116: l_req_material_u_tbl(1) := l_req_material_u_rec;
2117:
2118: IF (FND_LOG.LEVEL_EVENT>= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2119: FND_LOG.STRING(FND_LOG.LEVEL_EVENT,
2120: G_LOG_PREFIX||l_api_name||': Within the API',
2121: 'Just before calling API: Ahl_PP_Materials_PVT.Process_Material_Request');
2122: END IF;

Line 2119: FND_LOG.STRING(FND_LOG.LEVEL_EVENT,

2115: l_req_material_u_rec.OPERATION_FLAG := 'U';
2116: l_req_material_u_tbl(1) := l_req_material_u_rec;
2117:
2118: IF (FND_LOG.LEVEL_EVENT>= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2119: FND_LOG.STRING(FND_LOG.LEVEL_EVENT,
2120: G_LOG_PREFIX||l_api_name||': Within the API',
2121: 'Just before calling API: Ahl_PP_Materials_PVT.Process_Material_Request');
2122: END IF;
2123: Ahl_PP_Materials_PVT.Process_Material_Request (

Line 2139: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2135: l_update_flag := true;
2136:
2137: ELSE
2138: close check_mtl_requirement;
2139: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2140: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
2141: G_LOG_PREFIX||l_api_name||': Within the API',
2142: 'Just before calling API: Ahl_PP_Materials_PVT.Create_Material_Reqst');
2143: END IF;

Line 2140: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

2136:
2137: ELSE
2138: close check_mtl_requirement;
2139: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2140: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
2141: G_LOG_PREFIX||l_api_name||': Within the API',
2142: 'Just before calling API: Ahl_PP_Materials_PVT.Create_Material_Reqst');
2143: END IF;
2144: Ahl_PP_Materials_PVT.Create_Material_Reqst (

Line 2159: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2155: END IF;
2156: --Standard check to count messages
2157: x_msg_count := Fnd_Msg_Pub.count_msg;
2158: IF x_msg_count > 0 THEN
2159: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2160: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
2161: G_LOG_PREFIX||l_api_name||': Within the API',
2162: 'Error occurred after calling the API in Ahl_PP_Materials_PVT and x_return_status='||
2163: x_return_status||', x_msg_count='||x_msg_count);

Line 2160: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

2156: --Standard check to count messages
2157: x_msg_count := Fnd_Msg_Pub.count_msg;
2158: IF x_msg_count > 0 THEN
2159: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2160: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
2161: G_LOG_PREFIX||l_api_name||': Within the API',
2162: 'Error occurred after calling the API in Ahl_PP_Materials_PVT and x_return_status='||
2163: x_return_status||', x_msg_count='||x_msg_count);
2164: END IF;

Line 2286: IF (FND_LOG.LEVEL_PROCEDURE>= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2282: IF (FND_API.to_boolean(p_init_msg_list)) THEN
2283: FND_MSG_PUB.initialize;
2284: END IF;
2285:
2286: IF (FND_LOG.LEVEL_PROCEDURE>= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2287: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
2288: G_LOG_PREFIX||l_api_name||': Begining of the API',
2289: 'At the start of the API and p_service_request_id ='||
2290: p_service_request_id||', p_disposition_id='||p_disposition_id);

Line 2287: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

2283: FND_MSG_PUB.initialize;
2284: END IF;
2285:
2286: IF (FND_LOG.LEVEL_PROCEDURE>= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2287: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
2288: G_LOG_PREFIX||l_api_name||': Begining of the API',
2289: 'At the start of the API and p_service_request_id ='||
2290: p_service_request_id||', p_disposition_id='||p_disposition_id);
2291: END IF;

Line 2334: IF (FND_LOG.LEVEL_EVENT>= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2330: l_link_rec.program_application_id := fnd_global.prog_appl_id;
2331: l_link_rec.program_id := fnd_global.conc_program_id;
2332: l_link_rec.program_update_date := sysdate;
2333:
2334: IF (FND_LOG.LEVEL_EVENT>= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2335: FND_LOG.STRING(FND_LOG.LEVEL_EVENT,
2336: G_LOG_PREFIX||l_api_name||': Within the API',
2337: 'Just before calling cs_incidentlinks_pub.create_incidentlink and subject_id='||
2338: p_service_request_id||', object_id='||p_disposition_id);

Line 2335: FND_LOG.STRING(FND_LOG.LEVEL_EVENT,

2331: l_link_rec.program_id := fnd_global.conc_program_id;
2332: l_link_rec.program_update_date := sysdate;
2333:
2334: IF (FND_LOG.LEVEL_EVENT>= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2335: FND_LOG.STRING(FND_LOG.LEVEL_EVENT,
2336: G_LOG_PREFIX||l_api_name||': Within the API',
2337: 'Just before calling cs_incidentlinks_pub.create_incidentlink and subject_id='||
2338: p_service_request_id||', object_id='||p_disposition_id);
2339: END IF;

Line 2357: IF (FND_LOG.LEVEL_EVENT>= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2353: x_object_version_number => l_object_version_number,
2354: x_reciprocal_link_id => l_reciprocal_link_id,
2355: x_link_id => x_link_id);
2356:
2357: IF (FND_LOG.LEVEL_EVENT>= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2358: FND_LOG.STRING(FND_LOG.LEVEL_EVENT,
2359: G_LOG_PREFIX||l_api_name||': Within the API',
2360: 'After calling cs_incidentlinks_pub.create_incidentlink and x_return_status='||
2361: x_return_status||', x_reciprocal_link_id='||l_reciprocal_link_id||', x_link_id='||

Line 2358: FND_LOG.STRING(FND_LOG.LEVEL_EVENT,

2354: x_reciprocal_link_id => l_reciprocal_link_id,
2355: x_link_id => x_link_id);
2356:
2357: IF (FND_LOG.LEVEL_EVENT>= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2358: FND_LOG.STRING(FND_LOG.LEVEL_EVENT,
2359: G_LOG_PREFIX||l_api_name||': Within the API',
2360: 'After calling cs_incidentlinks_pub.create_incidentlink and x_return_status='||
2361: x_return_status||', x_reciprocal_link_id='||l_reciprocal_link_id||', x_link_id='||
2362: x_link_id);

Line 2371: IF (FND_LOG.LEVEL_PROCEDURE>= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2367: fnd_msg_pub.add;
2368: RAISE FND_API.G_EXC_ERROR;
2369: End If;
2370:
2371: IF (FND_LOG.LEVEL_PROCEDURE>= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2372: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
2373: G_LOG_PREFIX||l_api_name||': End of the API',
2374: 'At the end of the API after normal execution.');
2375: END IF;

Line 2372: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

2368: RAISE FND_API.G_EXC_ERROR;
2369: End If;
2370:
2371: IF (FND_LOG.LEVEL_PROCEDURE>= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2372: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
2373: G_LOG_PREFIX||l_api_name||': End of the API',
2374: 'At the end of the API after normal execution.');
2375: END IF;
2376:

Line 2438: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2434: l_visit_task_instance_id NUMBER;
2435: l_curr_instance_id NUMBER;
2436:
2437: BEGIN
2438: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2439: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
2440: L_DEBUG_KEY || '.begin',
2441: 'Getting UC Header Id for workorder with Id: ' || p_workorder_id);
2442: END IF;

Line 2439: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

2435: l_curr_instance_id NUMBER;
2436:
2437: BEGIN
2438: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2439: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
2440: L_DEBUG_KEY || '.begin',
2441: 'Getting UC Header Id for workorder with Id: ' || p_workorder_id);
2442: END IF;
2443: OPEN get_instance_id_csr;

Line 2457: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2453: -- Task instance does not belong to an UC. Try to get from Visit Header Level
2454: l_return_value := AHL_UTIL_UC_PKG.get_uc_header_id(l_visit_instance_id);
2455: END IF;
2456: END IF;
2457: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2458: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
2459: L_DEBUG_KEY || '.end',
2460: 'Got UC Header Id ' || l_return_value || ' for workorder with Id: ' || p_workorder_id);
2461: END IF;

Line 2458: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

2454: l_return_value := AHL_UTIL_UC_PKG.get_uc_header_id(l_visit_instance_id);
2455: END IF;
2456: END IF;
2457: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2458: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
2459: L_DEBUG_KEY || '.end',
2460: 'Got UC Header Id ' || l_return_value || ' for workorder with Id: ' || p_workorder_id);
2461: END IF;
2462: RETURN l_return_value;