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

Line 45: -- Replaced all fnd_log.level_procedure with STATEMENT

41: -- in Rollup_MR_Cost_Hierarchy API
42: --
43: -- 07-NOV-2007 RBHAVSAR Added PROCEDURE level logs when entering and exiting a procedure.
44: -- Returned the status before returning from the procedure.
45: -- Replaced all fnd_log.level_procedure with STATEMENT
46: -- level logs and added more STATEMENT level logs at
47: -- key decision points. Removed some tabs in the code.
48: -----------------------------------------------------------------
49:

Line 61: l_log_current_level NUMBER := fnd_log.g_current_runtime_level;

57: G_DEBUG VARCHAR2(1) := AHL_DEBUG_PUB.is_log_enabled;
58: ------------------------------------
59: -- Common constants and variables --
60: ------------------------------------
61: l_log_current_level NUMBER := fnd_log.g_current_runtime_level;
62: l_log_statement NUMBER := fnd_log.level_statement;
63: l_log_procedure NUMBER := fnd_log.level_procedure;
64: l_log_error NUMBER := fnd_log.level_error;
65: l_log_unexpected NUMBER := fnd_log.level_unexpected;

Line 62: l_log_statement NUMBER := fnd_log.level_statement;

58: ------------------------------------
59: -- Common constants and variables --
60: ------------------------------------
61: l_log_current_level NUMBER := fnd_log.g_current_runtime_level;
62: l_log_statement NUMBER := fnd_log.level_statement;
63: l_log_procedure NUMBER := fnd_log.level_procedure;
64: l_log_error NUMBER := fnd_log.level_error;
65: l_log_unexpected NUMBER := fnd_log.level_unexpected;
66: ----------------------------------------------------------------------

Line 63: l_log_procedure NUMBER := fnd_log.level_procedure;

59: -- Common constants and variables --
60: ------------------------------------
61: l_log_current_level NUMBER := fnd_log.g_current_runtime_level;
62: l_log_statement NUMBER := fnd_log.level_statement;
63: l_log_procedure NUMBER := fnd_log.level_procedure;
64: l_log_error NUMBER := fnd_log.level_error;
65: l_log_unexpected NUMBER := fnd_log.level_unexpected;
66: ----------------------------------------------------------------------
67: -- START: Defining procedures BODY --

Line 64: l_log_error NUMBER := fnd_log.level_error;

60: ------------------------------------
61: l_log_current_level NUMBER := fnd_log.g_current_runtime_level;
62: l_log_statement NUMBER := fnd_log.level_statement;
63: l_log_procedure NUMBER := fnd_log.level_procedure;
64: l_log_error NUMBER := fnd_log.level_error;
65: l_log_unexpected NUMBER := fnd_log.level_unexpected;
66: ----------------------------------------------------------------------
67: -- START: Defining procedures BODY --
68: ----------------------------------------------------------------------

Line 65: l_log_unexpected NUMBER := fnd_log.level_unexpected;

61: l_log_current_level NUMBER := fnd_log.g_current_runtime_level;
62: l_log_statement NUMBER := fnd_log.level_statement;
63: l_log_procedure NUMBER := fnd_log.level_procedure;
64: l_log_error NUMBER := fnd_log.level_error;
65: l_log_unexpected NUMBER := fnd_log.level_unexpected;
66: ----------------------------------------------------------------------
67: -- START: Defining procedures BODY --
68: ----------------------------------------------------------------------
69:

Line 147: fnd_log.string(l_log_procedure,

143:
144: BEGIN
145:
146: IF (l_log_procedure >= l_log_current_level) THEN
147: fnd_log.string(l_log_procedure,
148: L_DEBUG_KEY ||'.begin',
149: 'At the start of PL SQL procedure. Visit id = ' || p_visit_id );
150: END IF;
151:

Line 183: fnd_log.string(l_log_statement,

179: i := i + 1;
180: CLOSE c_master_wo_cur;
181:
182: IF (l_log_statement >= l_log_current_level) THEN
183: fnd_log.string(l_log_statement,
184: L_DEBUG_KEY,
185: 'Master Wo Object Id : ' || l_master_wo_rec.wip_entity_id ||
186: 'Master Wo Parent Object Id : ' || l_master_wo_rec.wip_entity_id ||
187: 'Application Id : ' || l_application_id);

Line 239: fnd_log.string(l_log_statement,

235: l_cst_job_tbl(i).level_num := l_child_tasks_rec.level;
236: l_cst_job_tbl(i).program_application_id := l_application_id;
237:
238: IF (l_log_statement >= l_log_current_level) THEN
239: fnd_log.string(l_log_statement,
240: L_DEBUG_KEY,
241: 'Visit Task Id : ' || l_child_tasks_rec.visit_task_id ||
242: 'Associated Child Object Id : ' || l_child_id ||
243: 'Associated Child Object Type : ' || l_child_entity ||

Line 256: fnd_log.string(l_log_statement,

252: END LOOP;
253: CLOSE c_child_tasks_cur;
254:
255: IF (l_log_statement >= l_log_current_level) THEN
256: fnd_log.string(l_log_statement,
257: L_DEBUG_KEY,
258: 'Before Calling Insert Cst Wo Hierarchy ' ||l_cst_job_tbl.count);
259: END IF;
260:

Line 269: fnd_log.string(l_log_statement,

265: x_session_id => x_cost_session_id,
266: x_return_status => l_return_status);
267:
268: IF (l_log_statement >= l_log_current_level) THEN
269: fnd_log.string(l_log_statement,
270: L_DEBUG_KEY,
271: 'After Calling Insert cost workorder hierarchy, Return Status = ' || l_return_status ||
272: 'Session id :' ||x_cost_session_id);
273: END IF;

Line 278: fnd_log.string(l_log_statement,

274:
275: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
276:
277: IF (l_log_statement >= l_log_current_level) THEN
278: fnd_log.string(l_log_statement,
279: L_DEBUG_KEY,
280: 'Errors from Insert cost workorder hierarchy' || x_msg_count);
281: END IF;
282:

Line 287: fnd_log.string(l_log_procedure,

283: RAISE Fnd_Api.g_exc_error;
284: END IF;
285:
286: IF (l_log_procedure >= l_log_current_level) THEN
287: fnd_log.string(l_log_procedure,
288: L_DEBUG_KEY ||'.end',
289: 'At the end of PL SQL procedure. Return Status = ' || l_return_status);
290: END IF;
291:

Line 403: fnd_log.string(l_log_procedure,

399: -- yazhou 27-Jun-2006 ends
400:
401: BEGIN
402: IF (l_log_procedure >= l_log_current_level) THEN
403: fnd_log.string(l_log_procedure,
404: L_DEBUG_KEY ||'.begin',
405: 'At the start of PL SQL procedure. Visit Id = ' || p_visit_id);
406: END IF;
407:

Line 430: fnd_log.string(l_log_statement,

426: l_cst_job_tbl(i).level_num := 0;
427: l_cst_job_tbl(i).program_application_id := l_application_id;
428:
429: IF (l_log_statement >= l_log_current_level) THEN
430: fnd_log.string(l_log_statement,
431: L_DEBUG_KEY,
432: 'Level-Parent Object Id - Child Object Id' || l_cst_job_tbl(i).level_num ||
433: '----' || l_cst_job_tbl(i).parent_object_id || '-----' || l_cst_job_tbl(i).object_id);
434: END IF;

Line 447: fnd_log.string(l_log_statement,

443: l_cst_job_tbl(i).level_num := child_cur.level;
444: l_cst_job_tbl(i).program_application_id := l_application_id;
445:
446: IF (l_log_statement >= l_log_current_level) THEN
447: fnd_log.string(l_log_statement,
448: L_DEBUG_KEY,
449: 'Level-Parent Object Id - Child Object Id' || l_cst_job_tbl(i).level_num || '----' || l_cst_job_tbl(i).parent_object_id || '-----' || l_cst_job_tbl(i).object_id);
450: END IF;
451:

Line 455: fnd_log.string(l_log_statement,

451:
452: END LOOP;
453:
454: IF (l_log_statement >= l_log_current_level) THEN
455: fnd_log.string(l_log_statement,
456: L_DEBUG_KEY,
457: 'Before Calling Insert_Cst_Wo_Hierarchy');
458: END IF;
459:

Line 469: fnd_log.string(l_log_statement,

465: x_return_status => l_return_status
466: );
467:
468: IF (l_log_statement >= l_log_current_level) THEN
469: fnd_log.string(l_log_statement,
470: L_DEBUG_KEY,
471: 'After Calling Insert_Cst_Wo_Hierarchy, Return Status = ' || l_return_status);
472: END IF;
473:

Line 476: fnd_log.string(l_log_statement,

472: END IF;
473:
474: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
475: IF (l_log_statement >= l_log_current_level) THEN
476: fnd_log.string(l_log_statement,
477: L_DEBUG_KEY,
478: 'Errors from Insert cost workorder hierarchy' || x_msg_count);
479: END IF;
480:

Line 486: fnd_log.string(l_log_procedure,

482: RAISE Fnd_Api.g_exc_error;
483: END IF;
484:
485: IF (l_log_procedure >= l_log_current_level) THEN
486: fnd_log.string(l_log_procedure,
487: L_DEBUG_KEY ||'.end',
488: 'At the end of PL SQL procedure. Return Status = ' || x_return_status ||
489: ' x_session_id = ' || x_MR_session_id );
490: END IF;

Line 559: fnd_log.string(l_log_procedure,

555:
556: BEGIN
557:
558: IF (l_log_procedure >= l_log_current_level) THEN
559: fnd_log.string(l_log_procedure,
560: L_DEBUG_KEY ||'.begin',
561: 'At the start of PL SQL procedure.');
562: END IF;
563:

Line 576: fnd_log.string(l_log_statement,

572: IF l_group_id IS NULL THEN
573: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_CST_EAM_SEQ_NOT_EXIST');
574: FND_MSG_PUB.ADD;
575: IF (l_log_statement >= l_log_current_level) THEN
576: fnd_log.string(l_log_statement,
577: L_DEBUG_KEY,
578: 'MTL_EAM_ASSET_ACTIVITIES_S Sequence not exists ');
579: END IF;
580: RAISE Fnd_Api.g_exc_error;

Line 589: fnd_log.string(l_log_statement,

585: FOR i IN l_cst_job_tbl.FIRST..l_cst_job_tbl.LAST
586: LOOP
587:
588: IF (l_log_statement >= l_log_current_level) THEN
589: fnd_log.string(l_log_statement,
590: L_DEBUG_KEY,
591: 'Call INSERT CST_EAM_HIERARCHY_SNAPSHOT ');
592: END IF;
593: INSERT INTO CST_EAM_HIERARCHY_SNAPSHOT(

Line 633: fnd_log.string(l_log_procedure,

629:
630: -- x_return_status := FND_API.G_RET_STS_SUCCESS;
631:
632: IF (l_log_procedure >= l_log_current_level) THEN
633: fnd_log.string(l_log_procedure,
634: L_DEBUG_KEY ||'.end',
635: 'At the end of PL SQL procedure. ' ||
636: 'Value of Session ID : ' || x_session_id);
637: END IF;

Line 706: fnd_log.string(l_log_procedure,

702: BEGIN
703: ------------------------Initialize Body------------------------------------
704:
705: IF (l_log_procedure >= l_log_current_level) THEN
706: fnd_log.string(l_log_procedure,
707: L_DEBUG_KEY ||'.begin',
708: 'At the start of PL SQL procedure.' ||
709: 'Visit ID : ' || p_visit_id || 'Session ID : ' || p_Session_id);
710: END IF;

Line 738: fnd_log.string(l_log_statement,

734: CLOSE c_job;
735:
736: -- Debug statements
737: IF (l_log_statement >= l_log_current_level) THEN
738: fnd_log.string(l_log_statement,
739: L_DEBUG_KEY,
740: 'Before calling Get_WO_Cost API to find Cost' ||
741: 'WIP ENTITY ID = ' || l_wip_Id );
742: END IF;

Line 756: fnd_log.string(l_log_statement,

752:
753:
754: -- Debug statements
755: IF (l_log_statement >= l_log_current_level) THEN
756: fnd_log.string(l_log_statement,
757: L_DEBUG_KEY,
758: 'After calling Get_WO_Cost API to find Cost, Return Status = ' || l_return_status ||
759: 'Actual Cost : ' || l_actual_cost ||
760: 'Estimated Cost : ' || l_estimated_cost );

Line 776: fnd_log.string(l_log_statement,

772:
773: IF c_OSP_Job%FOUND THEN
774: -- Debug statements
775: IF (l_log_statement >= l_log_current_level) THEN
776: fnd_log.string(l_log_statement,
777: L_DEBUG_KEY,
778: 'Before calling Get_OSP_Cost API to find Cost for OSP Job' );
779: END IF;
780:

Line 794: fnd_log.string(l_log_statement,

790: l_estimated_cost := l_estimated_cost + l_OSP_cost;
791:
792: -- Debug statements
793: IF (l_log_statement >= l_log_current_level) THEN
794: fnd_log.string(l_log_statement,
795: L_DEBUG_KEY,
796: 'After calling Get_OSP_Cost API, Return Status = ' || l_return_status ||
797: 'Actual Cost : ' || l_actual_cost ||
798: 'Estimated Cost : ' || l_estimated_cost );

Line 816: fnd_log.string(l_log_procedure,

812:
813: --x_return_status := FND_API.G_RET_STS_SUCCESS;
814:
815: IF (l_log_procedure >= l_log_current_level) THEN
816: fnd_log.string(l_log_procedure,
817: L_DEBUG_KEY ||'.end',
818: 'At the end of PL SQL procedure. Return Status = ' || l_return_status ||
819: 'Actual Cost : ' || l_actual_cost ||
820: 'Estimated Cost : ' || l_estimated_cost );

Line 911: fnd_log.string(l_log_procedure,

907: BEGIN
908: ------------------------Initialize Body------------------------------------
909:
910: IF (l_log_procedure >= l_log_current_level) THEN
911: fnd_log.string(l_log_procedure,
912: L_DEBUG_KEY ||'.begin',
913: 'At the start of PL SQL procedure.' ||
914: 'Visit Task ID : ' || p_visit_task_id || 'Session ID : ' || p_Session_id);
915:

Line 940: fnd_log.string(l_log_statement,

936:
937: IF c_task_rec.MR_Id IS NOT NULL THEN
938:
939: IF (l_log_statement >= l_log_current_level) THEN
940: fnd_log.string(l_log_statement,
941: L_DEBUG_KEY,
942: 'MR ID is not null : ' || c_task_rec.MR_Id );
943: END IF;
944: -- Cursor to find out WIP entity Id for the Current task

Line 952: fnd_log.string(l_log_statement,

948:
949: -- Debug statements
950:
951: IF (l_log_statement >= l_log_current_level) THEN
952: fnd_log.string(l_log_statement,
953: L_DEBUG_KEY,
954: 'WIP ENTITY ID : ' || l_wip_Id ||
955: 'Before calling Get_WO_Cost API to find Cost' );
956: END IF;

Line 968: fnd_log.string(l_log_statement,

964: x_return_status => l_return_status);
965:
966: -- Debug statements
967: IF (l_log_statement >= l_log_current_level) THEN
968: fnd_log.string(l_log_statement,
969: L_DEBUG_KEY,
970: 'After calling Get_WO_Cost API to find Cost' ||
971: 'Actual Cost : ' || l_actual_cost ||
972: 'Estimated Cost : ' || l_estimated_cost );

Line 994: fnd_log.string(l_log_statement,

990: IF c_OSP_Job%FOUND THEN
991:
992: -- Debug statements
993: IF (l_log_statement >= l_log_current_level) THEN
994: fnd_log.string(l_log_statement,
995: L_DEBUG_KEY,
996: 'Before calling Get_OSP_Cost API to find Cost for OSP Job' );
997: END IF;
998:

Line 1012: fnd_log.string(l_log_statement,

1008:
1009: -- Debug statements
1010:
1011: IF (l_log_statement >= l_log_current_level) THEN
1012: fnd_log.string(l_log_statement,
1013: L_DEBUG_KEY,
1014: 'After calling Get_OSP_Cost API to find Cost for OSP Job, , Return Status = ' || l_return_status ||
1015: 'Actual Cost : ' || l_actual_cost ||
1016: 'Estimated Cost : ' || l_estimated_cost);

Line 1034: fnd_log.string(l_log_procedure,

1030: ------------------------End of API Body------------------------------------
1031: --x_return_status := FND_API.G_RET_STS_SUCCESS;
1032:
1033: IF (l_log_procedure >= l_log_current_level) THEN
1034: fnd_log.string(l_log_procedure,
1035: L_DEBUG_KEY ||'.end',
1036: 'At the end of PL SQL procedure. Return Status = ' || l_return_status ||
1037: 'Actual Cost : ' || l_actual_cost ||
1038: 'Estimated Cost : ' || l_estimated_cost);

Line 1104: fnd_log.string(l_log_procedure,

1100:
1101: BEGIN
1102: ------------------------Initialize Body------------------------------------
1103: IF (l_log_procedure >= l_log_current_level) THEN
1104: fnd_log.string(l_log_procedure,
1105: L_DEBUG_KEY ||'.begin',
1106: 'At the start of PL SQL procedure.' ||
1107: 'Value of Visit Task ID : ' || p_visit_task_id ||
1108: 'Cost Session ID : ' || p_Session_id );

Line 1132: fnd_log.string(l_log_statement,

1128:
1129: -- for manually created summary task representing MRs
1130:
1131: IF (l_log_statement >= l_log_current_level) THEN
1132: fnd_log.string(l_log_statement,
1133: L_DEBUG_KEY,
1134: 'TASK TYPE CODE is = ' || c_task_rec.TASK_TYPE_CODE ||
1135: 'MR ID is = ' || c_task_rec.mr_id );
1136: END IF;

Line 1143: fnd_log.string(l_log_statement,

1139: THEN
1140:
1141: -- Debug statements
1142: IF (l_log_statement >= l_log_current_level) THEN
1143: fnd_log.string(l_log_statement,
1144: L_DEBUG_KEY,
1145: 'Before calling Get_WO_Cost API to find Cost' );
1146: END IF;
1147:

Line 1158: fnd_log.string(l_log_statement,

1154: x_return_status => l_return_status);
1155:
1156: -- Debug statements
1157: IF (l_log_statement >= l_log_current_level) THEN
1158: fnd_log.string(l_log_statement,
1159: L_DEBUG_KEY,
1160: 'After calling Get_WO_Cost API to find Cost, , Return Status = ' || l_return_status);
1161: END IF;
1162:

Line 1171: fnd_log.string(l_log_statement,

1167: CLOSE c_WO_tasks;
1168:
1169: -- Debug statements
1170: IF (l_log_statement >= l_log_current_level) THEN
1171: fnd_log.string(l_log_statement,
1172: L_DEBUG_KEY,
1173: 'Before calling Get_WO_Cost API to find Cost' ||
1174: 'WIP ENTITY ID = ' || c_WO_tasks_rec.wip_entity_id ||
1175: 'Value of Work Order ID = ' || c_WO_tasks_rec.workorder_id );

Line 1189: fnd_log.string(l_log_statement,

1185: x_return_status => l_return_status);
1186:
1187: -- Debug statements
1188: IF (l_log_statement >= l_log_current_level) THEN
1189: fnd_log.string(l_log_statement,
1190: L_DEBUG_KEY,
1191: 'After calling Get_OSP_Cost API to find Cost for OSP Job, Return Status = ' || l_return_status ||
1192: 'Value of p_Session_Id : ' || p_Session_Id ||
1193: 'Actual Cost : ' || l_actual_cost ||

Line 1219: fnd_log.string(l_log_statement,

1215: IF c_OSP_Job%FOUND THEN
1216:
1217: -- Debug statements
1218: IF (l_log_statement >= l_log_current_level) THEN
1219: fnd_log.string(l_log_statement,
1220: L_DEBUG_KEY,
1221: 'Before calling Get_OSP_Cost API to find Cost for OSP Job' );
1222: END IF;
1223:

Line 1236: fnd_log.string(l_log_statement,

1232: l_estimated_cost := l_estimated_cost + nvl(l_OSP_cost,0);
1233:
1234: -- Debug statements
1235: IF (l_log_statement >= l_log_current_level) THEN
1236: fnd_log.string(l_log_statement,
1237: L_DEBUG_KEY,
1238: 'After calling Get_OSP_Cost API to find Cost for OSP Job, Return Status = ' || l_return_status ||
1239: 'Actual Cost : ' || l_actual_cost ||
1240: 'Estimated Cost : ' || l_estimated_cost );

Line 1257: fnd_log.string(l_log_procedure,

1253:
1254: ------------------------End of API Body------------------------------------
1255:
1256: IF (l_log_procedure >= l_log_current_level) THEN
1257: fnd_log.string(l_log_procedure,
1258: L_DEBUG_KEY ||'.end',
1259: 'At the end of PL SQL procedure. Return Status = ' || l_return_status ||
1260: 'Task Actual Cost : ' || x_actual_cost ||
1261: 'Task Estimated Cost : ' || x_estimated_cost );

Line 1324: fnd_log.string(l_log_procedure,

1320: BEGIN
1321: ------------------------Initialize Body------------------------------------
1322:
1323: IF (l_log_procedure >= l_log_current_level) THEN
1324: fnd_log.string(l_log_procedure,
1325: L_DEBUG_KEY ||'.begin',
1326: 'At the start of PL SQL procedure.' ||
1327: 'Value of Visit Task ID : ' || p_visit_task_id ||
1328: 'Session ID : ' || p_Session_id );

Line 1351: fnd_log.string(l_log_statement,

1347: FETCH c_task INTO c_task_rec;
1348: CLOSE c_task;
1349:
1350: IF (l_log_statement >= l_log_current_level) THEN
1351: fnd_log.string(l_log_statement,
1352: L_DEBUG_KEY,
1353: 'TASK TYPE CODE = ' || c_task_rec.TASK_TYPE_CODE ||
1354: 'MR ID = ' || c_task_rec.mr_id );
1355: END IF;

Line 1362: fnd_log.string(l_log_statement,

1358:
1359: IF c_task_rec.TASK_TYPE_CODE = 'SUMMARY' and c_task_rec.mr_id is not null THEN
1360:
1361: IF (l_log_statement >= l_log_current_level) THEN
1362: fnd_log.string(l_log_statement,
1363: L_DEBUG_KEY,
1364: 'Before Calling Calculate_MR_Cost : MR-summary tasks' );
1365: END IF;
1366:

Line 1376: fnd_log.string(l_log_statement,

1372: x_return_status => l_return_status
1373: );
1374:
1375: IF (l_log_statement >= l_log_current_level) THEN
1376: fnd_log.string(l_log_statement,
1377: L_DEBUG_KEY,
1378: 'After calling Calculate_MR_Cost, Return Status = ' || l_return_status ||
1379: 'Actual Cost : ' || l_actual_cost ||
1380: 'Estimated Cost : ' || l_estimated_cost );

Line 1392: fnd_log.string(l_log_statement,

1388: CLOSE c_job;
1389:
1390: -- Debug statements
1391: IF (l_log_statement >= l_log_current_level) THEN
1392: fnd_log.string(l_log_statement,
1393: L_DEBUG_KEY,
1394: 'Before calling Get_WO_Cost API to find Cost : Non-summary tasks ' ||
1395: 'WIP ENTITY ID : ' || l_wip_Id ||
1396: 'Value of Work Order ID : ' || l_WO_Id );

Line 1409: fnd_log.string(l_log_statement,

1405: x_return_status => l_return_status);
1406:
1407: -- Debug statements
1408: IF (l_log_statement >= l_log_current_level) THEN
1409: fnd_log.string(l_log_statement,
1410: L_DEBUG_KEY,
1411: 'After calling Get_OSP_Cost API to find Cost for OSP Job, Return Status = ' || l_return_status ||
1412: 'Actual Cost : ' || l_actual_cost ||
1413: 'Estimated Cost : ' || l_estimated_cost );

Line 1422: fnd_log.string(l_log_statement,

1418:
1419: IF c_OSP_Job%FOUND THEN
1420:
1421: IF (l_log_statement >= l_log_current_level) THEN
1422: fnd_log.string(l_log_statement,
1423: L_DEBUG_KEY,
1424: 'Before calling AHL_OSP_COST_PVT.Get_OSP_Cost' );
1425: END IF;
1426: AHL_OSP_COST_PVT.Get_OSP_Cost

Line 1437: fnd_log.string(l_log_statement,

1433: l_actual_cost := l_actual_cost + nvl(l_OSP_cost,0);
1434: l_estimated_cost := l_estimated_cost + nvl(l_OSP_cost,0);
1435:
1436: IF (l_log_statement >= l_log_current_level) THEN
1437: fnd_log.string(l_log_statement,
1438: L_DEBUG_KEY,
1439: 'After calling AHL_OSP_COST_PVT.Get_OSP_Cost, Return Status = ' || l_return_status ||
1440: 'l_actual_cost = ' || l_actual_cost ||
1441: 'l_estimated_cost = ' || l_estimated_cost);

Line 1455: fnd_log.string(l_log_procedure,

1451:
1452: ------------------------End of API Body------------------------------------
1453:
1454: IF (l_log_procedure >= l_log_current_level) THEN
1455: fnd_log.string(l_log_procedure,
1456: L_DEBUG_KEY ||'.end',
1457: 'At the end of PL SQL procedure. Return Status = ' || l_return_status ||
1458: 'Task Actual Cost : ' || x_actual_cost ||
1459: 'Task Estimated Cost : ' || x_estimated_cost );

Line 1520: fnd_log.string(l_log_procedure,

1516: BEGIN
1517: ------------------------Initialize Body------------------------------------
1518:
1519: IF (l_log_procedure >= l_log_current_level) THEN
1520: fnd_log.string(l_log_procedure,
1521: L_DEBUG_KEY ||'.begin',
1522: 'At the start of PL SQL procedure.' ||
1523: 'Value of Visit ID : ' || l_cost_price_rec.visit_id ||
1524: 'Value of Cost Session ID : ' || l_cost_price_rec.cost_session_Id ||

Line 1559: fnd_log.string(l_log_statement,

1555:
1556: FND_MSG_PUB.ADD;
1557:
1558: IF (l_log_statement >= l_log_current_level) THEN
1559: fnd_log.string(l_log_statement,
1560: L_DEBUG_KEY,
1561: 'Visit id is mandatory but found null in input ' );
1562: END IF;
1563:

Line 1577: fnd_log.string(l_log_statement,

1573: FETCH c_job_visit INTO l_cost_price_rec.workorder_id;
1574: CLOSE c_job_visit;
1575:
1576: IF (l_log_statement >= l_log_current_level) THEN
1577: fnd_log.string(l_log_statement,
1578: L_DEBUG_KEY,
1579: 'work order ID is : '||l_cost_price_rec.workorder_id );
1580: END IF;
1581:

Line 1619: fnd_log.string(l_log_statement,

1615:
1616: END IF; -- Check for visit status
1617:
1618: IF (l_log_statement >= l_log_current_level) THEN
1619: fnd_log.string(l_log_statement,
1620: L_DEBUG_KEY,
1621: 'l_cost_rollup_flag = ' || l_cost_rollup_flag );
1622: END IF;
1623:

Line 1631: fnd_log.string(l_log_statement,

1627: -- are present in Released status for Visit
1628: IF l_MR_Session_Id IS NOT NULL AND l_cost_session_Id IS NOT NULL THEN
1629:
1630: IF (l_log_statement >= l_log_current_level) THEN
1631: fnd_log.string(l_log_statement,
1632: L_DEBUG_KEY,
1633: 'Before calling Rollup_MR_Cost_Hierarchy API: ' );
1634: END IF;
1635:

Line 1653: fnd_log.string(l_log_statement,

1649: RAISE Fnd_Api.G_EXC_ERROR;
1650: END IF;
1651:
1652: IF (l_log_statement >= l_log_current_level) THEN
1653: fnd_log.string(l_log_statement,
1654: L_DEBUG_KEY,
1655: 'After calling Rollup_MR_Cost_Hierarchy API, Return Status = ' || l_return_status ||
1656: 'Visit Id : ' || l_visit_id );
1657: END IF;

Line 1664: fnd_log.string(l_log_statement,

1660: -- Else for MR Session and Cost Session ID
1661: -- are not present in Released Status for Visit
1662:
1663: IF (l_log_statement >= l_log_current_level) THEN
1664: fnd_log.string(l_log_statement,
1665: L_DEBUG_KEY,
1666: 'Before calling Push_MR_Cost_Hierarchy API: ' );
1667: END IF;
1668:

Line 1683: fnd_log.string(l_log_statement,

1679: x_return_status => l_return_status
1680: );
1681:
1682: IF (l_log_statement >= l_log_current_level) THEN
1683: fnd_log.string(l_log_statement,
1684: L_DEBUG_KEY,
1685: 'After calling Push_MR_Cost_Hierarchy API, Return Status = ' || l_return_status ||
1686: 'Visit Id : ' || l_visit_id );
1687: END IF;

Line 1694: fnd_log.string(l_log_statement,

1690: RAISE Fnd_Api.G_EXC_ERROR;
1691: END IF;
1692:
1693: IF (l_log_statement >= l_log_current_level) THEN
1694: fnd_log.string(l_log_statement,
1695: L_DEBUG_KEY,
1696: 'Before calling Rollup_MR_Cost_Hierarchy API: ' );
1697: END IF;
1698:

Line 1716: fnd_log.string(l_log_statement,

1712: RAISE Fnd_Api.G_EXC_ERROR;
1713: END IF;
1714:
1715: IF (l_log_statement >= l_log_current_level) THEN
1716: fnd_log.string(l_log_statement,
1717: L_DEBUG_KEY,
1718: 'After calling Rollup_MR_Cost_Hierarchy API, Return Status = ' || l_return_status ||
1719: 'Visit Id : ' || l_visit_id);
1720: END IF;

Line 1738: fnd_log.string(l_log_procedure,

1734:
1735: ------------------------End of API Body------------------------------------
1736:
1737: IF (l_log_procedure >= l_log_current_level) THEN
1738: fnd_log.string(l_log_procedure,
1739: L_DEBUG_KEY ||'.end',
1740: 'At the end of PL SQL procedure. Return Status = ' || l_return_status ||
1741: 'MR Session ID: ' || p_x_cost_price_rec.MR_Session_Id ||
1742: 'Cost Session ID: ' || p_x_cost_price_rec.Cost_Session_Id ||

Line 1789: fnd_log.string(l_log_procedure,

1785: BEGIN
1786: ------------------------Initialize Body------------------------------------
1787:
1788: IF (l_log_procedure >= l_log_current_level) THEN
1789: fnd_log.string(l_log_procedure,
1790: L_DEBUG_KEY ||'.begin',
1791: 'At the start of PL SQL procedure.' ||
1792: 'Value of Visit ID : ' || l_cost_price_rec.visit_id ||
1793: 'Value of Cost Session ID : ' || l_cost_price_rec.cost_session_Id ||

Line 1828: fnd_log.string(l_log_statement,

1824:
1825: -- yazhou 25-Jul-2005 ends
1826:
1827: IF (l_log_statement >= l_log_current_level) THEN
1828: fnd_log.string(l_log_statement,
1829: L_DEBUG_KEY,
1830: 'Before calling Push_MR_Cost_Hierarchy API: ' );
1831: END IF;
1832:

Line 1847: fnd_log.string(l_log_statement,

1843: x_return_status => l_return_status
1844: );
1845:
1846: IF (l_log_statement >= l_log_current_level) THEN
1847: fnd_log.string(l_log_statement,
1848: L_DEBUG_KEY,
1849: 'After calling Push_MR_Cost_Hierarchy API, Return Status = ' || l_return_status );
1850: END IF;
1851:

Line 1857: fnd_log.string(l_log_statement,

1853: RAISE Fnd_Api.G_EXC_ERROR;
1854: END IF;
1855:
1856: IF (l_log_statement >= l_log_current_level) THEN
1857: fnd_log.string(l_log_statement,
1858: L_DEBUG_KEY,
1859: 'Before calling Rollup_MR_Cost_Hierarchy API: ' );
1860: END IF;
1861:

Line 1883: fnd_log.string(l_log_statement,

1879: x_return_status => l_return_status
1880: );
1881:
1882: IF (l_log_statement >= l_log_current_level) THEN
1883: fnd_log.string(l_log_statement,
1884: L_DEBUG_KEY,
1885: 'After calling Rollup_MR_Cost_Hierarchy API, Return Status = ' || l_return_status);
1886: END IF;
1887:

Line 1902: fnd_log.string(l_log_procedure,

1898: ------------------------End of API Body------------------------------------
1899:
1900:
1901: IF (l_log_procedure >= l_log_current_level) THEN
1902: fnd_log.string(l_log_procedure,
1903: L_DEBUG_KEY ||'.end',
1904: 'At the end of PL SQL procedure. Return Status = ' || l_return_status ||
1905: 'Value of Cost Session ID : ' || p_x_cost_price_rec.cost_session_Id ||
1906: 'Value of MR Session ID : ' || p_x_cost_price_rec.MR_Session_Id );

Line 1951: fnd_log.string(l_log_procedure,

1947: BEGIN
1948: ------------------------Initialize Body------------------------------------
1949:
1950: IF (l_log_procedure >= l_log_current_level) THEN
1951: fnd_log.string(l_log_procedure,
1952: L_DEBUG_KEY ||'.begin',
1953: 'At the start of PL SQL procedure.' ||
1954: 'Value for Session ID : ' || p_Session_Id ||
1955: 'Value for Object ID : ' || p_id ||

Line 1983: fnd_log.string(l_log_procedure,

1979:
1980: ------------------------End of API Body------------------------------------
1981:
1982: IF (l_log_procedure >= l_log_current_level) THEN
1983: fnd_log.string(l_log_procedure,
1984: L_DEBUG_KEY ||'.end',
1985: 'At the end of PL SQL procedure. Return Status = ' || x_return_status ||
1986: 'Value for Actual Cost : ' || x_Actual_Cost ||
1987: 'Value for Estimated Cost : ' || x_Estimated_Cost );

Line 2062: fnd_log.string(l_log_procedure,

2058:
2059: BEGIN
2060:
2061: IF (l_log_procedure >= l_log_current_level) THEN
2062: fnd_log.string(l_log_procedure,
2063: L_DEBUG_KEY ||'.begin',
2064: 'At the start of PL SQL procedure.' ||
2065: 'Value of Cost Session ID : ' || p_cost_session_id ||
2066: 'Value of MR Session ID : ' || p_MR_session_id );

Line 2102: fnd_log.string(l_log_statement,

2098: END LOOP;
2099: CLOSE c_wip_jobs;
2100:
2101: IF (l_log_statement >= l_log_current_level) THEN
2102: fnd_log.string(l_log_statement,
2103: L_DEBUG_KEY,
2104: 'Before Calling CST_EAMCOST_PUB.Delete_eamPerBal' );
2105: END IF;
2106:

Line 2122: fnd_log.string(l_log_statement,

2118: p_org_id => visit_rec.organization_id,
2119: p_type => 1);
2120:
2121: IF (l_log_statement >= l_log_current_level) THEN
2122: fnd_log.string(l_log_statement,
2123: L_DEBUG_KEY,
2124: 'After Calling CST_EAMCOST_PUB.Delete_eamPerBal, Return Status = ' || l_return_status );
2125: END IF;
2126:

Line 2130: fnd_log.string(l_log_statement,

2126:
2127: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2128:
2129: IF (l_log_statement >= l_log_current_level) THEN
2130: fnd_log.string(l_log_statement,
2131: L_DEBUG_KEY,
2132: 'Errors from CST_EAMCOST_PUB.Delete_eamPerBal API -COST SESSION' || l_msg_count );
2133: END IF;
2134:

Line 2151: fnd_log.string(l_log_statement,

2147: EXIT WHEN c_wip_jobs%NOTFOUND;
2148: IF c_wip_jobs%FOUND THEN
2149:
2150: IF (l_log_statement >= l_log_current_level) THEN
2151: fnd_log.string(l_log_statement,
2152: L_DEBUG_KEY,
2153: 'Before calling CST_EAMCOST_PUB.Compute_Job_Estimate' );
2154: END IF;
2155:

Line 2173: fnd_log.string(l_log_statement,

2169: x_msg_count => l_msg_count,
2170: x_msg_data => l_msg_data);
2171:
2172: IF (l_log_statement >= l_log_current_level) THEN
2173: fnd_log.string(l_log_statement,
2174: L_DEBUG_KEY,
2175: 'After calling CST_EAMCOST_PUB.Compute_Job_Estimate, Return Status = ' || l_return_status);
2176: END IF;
2177:

Line 2181: fnd_log.string(l_log_statement,

2177:
2178: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2179:
2180: IF (l_log_statement >= l_log_current_level) THEN
2181: fnd_log.string(l_log_statement,
2182: L_DEBUG_KEY,
2183: 'Errors from CST_EAMCOST_PUB.Delete_eamPerBal API -COST SESSION' || l_msg_count );
2184: END IF;
2185:

Line 2196: fnd_log.string(l_log_statement,

2192: END LOOP;
2193: CLOSE c_wip_jobs;
2194:
2195: IF (l_log_statement >= l_log_current_level) THEN
2196: fnd_log.string(l_log_statement,
2197: L_DEBUG_KEY,
2198: 'Before Calling CST_EAMCOST_PUB.Rollup_WorkOrderCost-COST SESSION' );
2199: END IF;
2200:

Line 2221: fnd_log.string(l_log_statement,

2217:
2218: );
2219:
2220: IF (l_log_statement >= l_log_current_level) THEN
2221: fnd_log.string(l_log_statement,
2222: L_DEBUG_KEY,
2223: 'After Calling CST_EAMCOST_PUB.Rollup_WorkOrderCost-COST SESSION, Return Status = ' || l_return_status );
2224: END IF;
2225:

Line 2230: fnd_log.string(l_log_statement,

2226:
2227: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2228:
2229: IF (l_log_statement >= l_log_current_level) THEN
2230: fnd_log.string(l_log_statement,
2231: L_DEBUG_KEY,
2232: 'Errors from CST_EAMCOST_PUB.Rollup_WorkOrderCosts API -COST SESSION' || l_msg_count );
2233: END IF;
2234:

Line 2241: fnd_log.string(l_log_statement,

2237: FND_MSG_PUB.Initialize;
2238: END IF;
2239:
2240: IF (l_log_statement >= l_log_current_level) THEN
2241: fnd_log.string(l_log_statement,
2242: L_DEBUG_KEY,
2243: 'Before Calling CST_EAMCOST_PUB.Rollup_WorkOrderCost-MR SESSION' );
2244: END IF;
2245:

Line 2266: fnd_log.string(l_log_statement,

2262:
2263: );
2264:
2265: IF (l_log_statement >= l_log_current_level) THEN
2266: fnd_log.string(l_log_statement,
2267: L_DEBUG_KEY,
2268: 'After Calling CST_EAMCOST_PUB.Rollup_WorkOrderCost-MR SESSION, Return Status = ' || l_return_status);
2269: END IF;
2270:

Line 2274: fnd_log.string(l_log_statement,

2270:
2271: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2272:
2273: IF (l_log_statement >= l_log_current_level) THEN
2274: fnd_log.string(l_log_statement,
2275: L_DEBUG_KEY,
2276: 'Errors from CST_EAMCOST_PUB.Rollup_WorkOrderCosts API -MR SESSION' || l_msg_count);
2277: END IF;
2278:

Line 2287: fnd_log.string(l_log_procedure,

2283:
2284: ------------------------End of API Body------------------------------------
2285:
2286: IF (l_log_procedure >= l_log_current_level) THEN
2287: fnd_log.string(l_log_procedure,
2288: L_DEBUG_KEY ||'.end',
2289: 'At the end of PL SQL procedure. Return Status = ' || l_return_status);
2290: END IF;
2291:

Line 2327: fnd_log.string(l_log_procedure,

2323: BEGIN
2324: ------------------------Initialize Body------------------------------------
2325:
2326: IF (l_log_procedure >= l_log_current_level) THEN
2327: fnd_log.string(l_log_procedure,
2328: L_DEBUG_KEY ||'.begin',
2329: 'At the start of PL SQL procedure. Visit Id = ' || p_visit_id);
2330: END IF;
2331:

Line 2339: fnd_log.string(l_log_statement,

2335: -- Initialize API return status to success
2336: x_return_status := FND_API.G_RET_STS_SUCCESS;
2337:
2338: IF (l_log_statement >= l_log_current_level) THEN
2339: fnd_log.string(l_log_statement,
2340: L_DEBUG_KEY,
2341: 'Before Calling Create_WO_Cost_Structure: Value of Visit ID : ' || p_visit_id );
2342: END IF;
2343:

Line 2359: fnd_log.string(l_log_statement,

2355: x_msg_data => l_msg_data
2356: );
2357:
2358: IF (l_log_statement >= l_log_current_level) THEN
2359: fnd_log.string(l_log_statement,
2360: L_DEBUG_KEY,
2361: 'After Calling AHL_VWP_CST_WO_PVT.Create_WO_Cost_Structure, Return Status = ' || l_return_status);
2362: END IF;
2363:

Line 2367: fnd_log.string(l_log_statement,

2363:
2364: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2365:
2366: IF (l_log_statement >= l_log_current_level) THEN
2367: fnd_log.string(l_log_statement,
2368: L_DEBUG_KEY,
2369: 'Errors from Create_WO_Cost_Structure API' || l_msg_count) ;
2370: END IF;
2371:

Line 2376: fnd_log.string(l_log_statement,

2372: RAISE Fnd_Api.g_exc_error;
2373: END IF;
2374:
2375: IF (l_log_statement >= l_log_current_level) THEN
2376: fnd_log.string(l_log_statement,
2377: L_DEBUG_KEY,
2378: 'Before Calling AHL_VWP_CST_WO_PVT.Create_WO_Dependencies' );
2379: END IF;
2380:

Line 2395: fnd_log.string(l_log_statement,

2391: x_msg_data => l_msg_data
2392: );
2393:
2394: IF (l_log_statement >= l_log_current_level) THEN
2395: fnd_log.string(l_log_statement,
2396: L_DEBUG_KEY,
2397: 'After Calling AHL_VWP_CST_WO_PVT.Create_WO_Dependencies, Return Status = ' || l_return_status);
2398: END IF;
2399:

Line 2403: fnd_log.string(l_log_statement,

2399:
2400: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2401:
2402: IF (l_log_statement >= l_log_current_level) THEN
2403: fnd_log.string(l_log_statement,
2404: L_DEBUG_KEY,
2405: 'Errors from Create_WO_Dependencies API' || l_msg_count );
2406: END IF;
2407:

Line 2418: fnd_log.string(l_log_procedure,

2414: x_return_status := FND_API.G_RET_STS_SUCCESS;
2415:
2416: ------------------------End of API Body------------------------------------
2417: IF (l_log_procedure >= l_log_current_level) THEN
2418: fnd_log.string(l_log_procedure,
2419: L_DEBUG_KEY ||'.end',
2420: 'At the end of PL SQL procedure. Return Status = ' || l_return_status ||
2421: 'x_MR_session_id = ' || x_MR_session_id ||
2422: 'x_cost_session_id = ' || x_cost_session_id );

Line 2448: fnd_log.string(l_log_procedure,

2444: BEGIN
2445: ------------------------Initialize Body------------------------------------
2446:
2447: IF (l_log_procedure >= l_log_current_level) THEN
2448: fnd_log.string(l_log_procedure,
2449: L_DEBUG_KEY ||'.begin',
2450: 'At the start of PL SQL procedure.' ||
2451: 'Actual Price : ' || p_actual_price || '***' || 'Actual Cost : ' || p_actual_cost ||
2452: 'Estimated Price : ' || p_estimated_price || '***' || 'Actual Price : ' || p_actual_price );

Line 2475: fnd_log.string(l_log_procedure,

2471: END IF;
2472:
2473: ------------------------End of API Body------------------------------------
2474: IF (l_log_procedure >= l_log_current_level) THEN
2475: fnd_log.string(l_log_procedure,
2476: L_DEBUG_KEY ||'.end',
2477: 'At the end of PL SQL procedure. Return Status = ' || x_return_status ||
2478: 'Actual Profit : ' || x_actual_profit ||
2479: 'Estimated Profit : ' || x_estimated_profit );