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.

[Home] [Help]

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 150: fnd_log.string(l_log_procedure,

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

Line 186: fnd_log.string(l_log_statement,

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

Line 242: fnd_log.string(l_log_statement,

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

Line 259: fnd_log.string(l_log_statement,

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

Line 272: fnd_log.string(l_log_statement,

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

Line 281: fnd_log.string(l_log_statement,

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

Line 290: fnd_log.string(l_log_procedure,

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

Line 406: fnd_log.string(l_log_procedure,

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

Line 433: fnd_log.string(l_log_statement,

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

Line 450: fnd_log.string(l_log_statement,

446: l_cst_job_tbl(i).level_num := child_cur.level;
447: l_cst_job_tbl(i).program_application_id := l_application_id;
448:
449: IF (l_log_statement >= l_log_current_level) THEN
450: fnd_log.string(l_log_statement,
451: L_DEBUG_KEY,
452: '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);
453: END IF;
454:

Line 458: fnd_log.string(l_log_statement,

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

Line 472: fnd_log.string(l_log_statement,

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

Line 479: fnd_log.string(l_log_statement,

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

Line 489: fnd_log.string(l_log_procedure,

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

Line 562: fnd_log.string(l_log_procedure,

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

Line 579: fnd_log.string(l_log_statement,

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

Line 592: fnd_log.string(l_log_statement,

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

Line 636: fnd_log.string(l_log_procedure,

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

Line 709: fnd_log.string(l_log_procedure,

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

Line 741: fnd_log.string(l_log_statement,

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

Line 759: fnd_log.string(l_log_statement,

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

Line 779: fnd_log.string(l_log_statement,

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

Line 797: fnd_log.string(l_log_statement,

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

Line 819: fnd_log.string(l_log_procedure,

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

Line 914: fnd_log.string(l_log_procedure,

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

Line 943: fnd_log.string(l_log_statement,

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

Line 955: fnd_log.string(l_log_statement,

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

Line 971: fnd_log.string(l_log_statement,

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

Line 997: fnd_log.string(l_log_statement,

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

Line 1015: fnd_log.string(l_log_statement,

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

Line 1037: fnd_log.string(l_log_procedure,

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

Line 1107: fnd_log.string(l_log_procedure,

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

Line 1135: fnd_log.string(l_log_statement,

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

Line 1146: fnd_log.string(l_log_statement,

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

Line 1161: fnd_log.string(l_log_statement,

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

Line 1174: fnd_log.string(l_log_statement,

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

Line 1192: fnd_log.string(l_log_statement,

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

Line 1222: fnd_log.string(l_log_statement,

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

Line 1239: fnd_log.string(l_log_statement,

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

Line 1260: fnd_log.string(l_log_procedure,

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

Line 1327: fnd_log.string(l_log_procedure,

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

Line 1354: fnd_log.string(l_log_statement,

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

Line 1365: fnd_log.string(l_log_statement,

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

Line 1379: fnd_log.string(l_log_statement,

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

Line 1395: fnd_log.string(l_log_statement,

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

Line 1412: fnd_log.string(l_log_statement,

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

Line 1425: fnd_log.string(l_log_statement,

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

Line 1440: fnd_log.string(l_log_statement,

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

Line 1458: fnd_log.string(l_log_procedure,

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

Line 1523: fnd_log.string(l_log_procedure,

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

Line 1562: fnd_log.string(l_log_statement,

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

Line 1580: fnd_log.string(l_log_statement,

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

Line 1622: fnd_log.string(l_log_statement,

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

Line 1634: fnd_log.string(l_log_statement,

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

Line 1656: fnd_log.string(l_log_statement,

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

Line 1667: fnd_log.string(l_log_statement,

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

Line 1686: fnd_log.string(l_log_statement,

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

Line 1697: fnd_log.string(l_log_statement,

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

Line 1719: fnd_log.string(l_log_statement,

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

Line 1741: fnd_log.string(l_log_procedure,

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

Line 1792: fnd_log.string(l_log_procedure,

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

Line 1831: fnd_log.string(l_log_statement,

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

Line 1850: fnd_log.string(l_log_statement,

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

Line 1860: fnd_log.string(l_log_statement,

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

Line 1886: fnd_log.string(l_log_statement,

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

Line 1905: fnd_log.string(l_log_procedure,

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

Line 1954: fnd_log.string(l_log_procedure,

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

Line 1986: fnd_log.string(l_log_procedure,

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

Line 2065: fnd_log.string(l_log_procedure,

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

Line 2105: fnd_log.string(l_log_statement,

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

Line 2125: fnd_log.string(l_log_statement,

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

Line 2133: fnd_log.string(l_log_statement,

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

Line 2154: fnd_log.string(l_log_statement,

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

Line 2176: fnd_log.string(l_log_statement,

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

Line 2184: fnd_log.string(l_log_statement,

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

Line 2199: fnd_log.string(l_log_statement,

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

Line 2224: fnd_log.string(l_log_statement,

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

Line 2233: fnd_log.string(l_log_statement,

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

Line 2244: fnd_log.string(l_log_statement,

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

Line 2269: fnd_log.string(l_log_statement,

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

Line 2277: fnd_log.string(l_log_statement,

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

Line 2290: fnd_log.string(l_log_procedure,

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

Line 2330: fnd_log.string(l_log_procedure,

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

Line 2342: fnd_log.string(l_log_statement,

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

Line 2362: fnd_log.string(l_log_statement,

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

Line 2370: fnd_log.string(l_log_statement,

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

Line 2379: fnd_log.string(l_log_statement,

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

Line 2398: fnd_log.string(l_log_statement,

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

Line 2406: fnd_log.string(l_log_statement,

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

Line 2421: fnd_log.string(l_log_procedure,

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

Line 2451: fnd_log.string(l_log_procedure,

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

Line 2478: fnd_log.string(l_log_procedure,

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