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.WIP_JOBCLOSE_PRIV dependencies on FND_FILE

Line 43: fnd_file.put_line(FND_FILE.LOG,'Populate Close Temp');

39: PRAGMA EXCEPTION_INIT(ex_dml_errors, -24381);
40:
41: BEGIN
42: x_returnStatus := fnd_api.g_ret_sts_success;
43: fnd_file.put_line(FND_FILE.LOG,'Populate Close Temp');
44:
45: IF (l_logLevel <= wip_constants.trace_logging) THEN
46: l_params(1).paramName := 'p_organization_id';
47: l_params(1).paramValue := p_organization_id ;

Line 430: fnd_file.put_line(FND_FILE.LOG,'Records inserted in close temp '||to_char(l_number_temp));

426: INTO l_number_temp
427: FROM WIP_DJ_CLOSE_TEMP
428: WHERE group_id = x_group_id ;
429:
430: fnd_file.put_line(FND_FILE.LOG,'Records inserted in close temp '||to_char(l_number_temp));
431:
432: --
433: -- Bug 5345660 exitPoint for normal exit.
434: --

Line 507: fnd_file.put_line(FND_FILE.LOG,'Time Zone Conversions');

503: p_params => l_params,
504: x_returnStatus => l_return_Status);
505: END IF;
506: x_ReturnStatus := fnd_api.g_ret_sts_success ;
507: fnd_file.put_line(FND_FILE.LOG,'Time Zone Conversions');
508:
509: IF(fnd_profile.value('ENABLE_TIMEZONE_CONVERSIONS') = 'Y') THEN
510:
511: HZ_TIMEZONE_PUB.Get_Time(

Line 603: fnd_file.put_line(FND_FILE.LOG,'x_from_release_date : '||to_char(x_from_release_date));

599:
600:
601: END IF;
602:
603: fnd_file.put_line(FND_FILE.LOG,'x_from_release_date : '||to_char(x_from_release_date));
604: fnd_file.put_line(FND_FILE.LOG,'x_to_release_date : '||to_char(x_to_release_date));
605: fnd_file.put_line(FND_FILE.LOG,'x_from_start_date : '||to_char(x_from_start_date));
606: fnd_file.put_line(FND_FILE.LOG,'x_to_start_date : '||to_char(x_to_start_date));
607: fnd_file.put_line(FND_FILE.LOG,'x_from_completion_date : '||to_char(x_from_completion_date));

Line 604: fnd_file.put_line(FND_FILE.LOG,'x_to_release_date : '||to_char(x_to_release_date));

600:
601: END IF;
602:
603: fnd_file.put_line(FND_FILE.LOG,'x_from_release_date : '||to_char(x_from_release_date));
604: fnd_file.put_line(FND_FILE.LOG,'x_to_release_date : '||to_char(x_to_release_date));
605: fnd_file.put_line(FND_FILE.LOG,'x_from_start_date : '||to_char(x_from_start_date));
606: fnd_file.put_line(FND_FILE.LOG,'x_to_start_date : '||to_char(x_to_start_date));
607: fnd_file.put_line(FND_FILE.LOG,'x_from_completion_date : '||to_char(x_from_completion_date));
608: fnd_file.put_line(FND_FILE.LOG,'x_to_completion_date : '||to_char(x_to_completion_date));

Line 605: fnd_file.put_line(FND_FILE.LOG,'x_from_start_date : '||to_char(x_from_start_date));

601: END IF;
602:
603: fnd_file.put_line(FND_FILE.LOG,'x_from_release_date : '||to_char(x_from_release_date));
604: fnd_file.put_line(FND_FILE.LOG,'x_to_release_date : '||to_char(x_to_release_date));
605: fnd_file.put_line(FND_FILE.LOG,'x_from_start_date : '||to_char(x_from_start_date));
606: fnd_file.put_line(FND_FILE.LOG,'x_to_start_date : '||to_char(x_to_start_date));
607: fnd_file.put_line(FND_FILE.LOG,'x_from_completion_date : '||to_char(x_from_completion_date));
608: fnd_file.put_line(FND_FILE.LOG,'x_to_completion_date : '||to_char(x_to_completion_date));
609: fnd_file.put_line(FND_FILE.LOG,'x_act_close_date : '||to_char(x_act_close_date));

Line 606: fnd_file.put_line(FND_FILE.LOG,'x_to_start_date : '||to_char(x_to_start_date));

602:
603: fnd_file.put_line(FND_FILE.LOG,'x_from_release_date : '||to_char(x_from_release_date));
604: fnd_file.put_line(FND_FILE.LOG,'x_to_release_date : '||to_char(x_to_release_date));
605: fnd_file.put_line(FND_FILE.LOG,'x_from_start_date : '||to_char(x_from_start_date));
606: fnd_file.put_line(FND_FILE.LOG,'x_to_start_date : '||to_char(x_to_start_date));
607: fnd_file.put_line(FND_FILE.LOG,'x_from_completion_date : '||to_char(x_from_completion_date));
608: fnd_file.put_line(FND_FILE.LOG,'x_to_completion_date : '||to_char(x_to_completion_date));
609: fnd_file.put_line(FND_FILE.LOG,'x_act_close_date : '||to_char(x_act_close_date));
610:

Line 607: fnd_file.put_line(FND_FILE.LOG,'x_from_completion_date : '||to_char(x_from_completion_date));

603: fnd_file.put_line(FND_FILE.LOG,'x_from_release_date : '||to_char(x_from_release_date));
604: fnd_file.put_line(FND_FILE.LOG,'x_to_release_date : '||to_char(x_to_release_date));
605: fnd_file.put_line(FND_FILE.LOG,'x_from_start_date : '||to_char(x_from_start_date));
606: fnd_file.put_line(FND_FILE.LOG,'x_to_start_date : '||to_char(x_to_start_date));
607: fnd_file.put_line(FND_FILE.LOG,'x_from_completion_date : '||to_char(x_from_completion_date));
608: fnd_file.put_line(FND_FILE.LOG,'x_to_completion_date : '||to_char(x_to_completion_date));
609: fnd_file.put_line(FND_FILE.LOG,'x_act_close_date : '||to_char(x_act_close_date));
610:
611: IF fnd_log.g_current_runtime_level <= wip_constants.trace_logging THEN

Line 608: fnd_file.put_line(FND_FILE.LOG,'x_to_completion_date : '||to_char(x_to_completion_date));

604: fnd_file.put_line(FND_FILE.LOG,'x_to_release_date : '||to_char(x_to_release_date));
605: fnd_file.put_line(FND_FILE.LOG,'x_from_start_date : '||to_char(x_from_start_date));
606: fnd_file.put_line(FND_FILE.LOG,'x_to_start_date : '||to_char(x_to_start_date));
607: fnd_file.put_line(FND_FILE.LOG,'x_from_completion_date : '||to_char(x_from_completion_date));
608: fnd_file.put_line(FND_FILE.LOG,'x_to_completion_date : '||to_char(x_to_completion_date));
609: fnd_file.put_line(FND_FILE.LOG,'x_act_close_date : '||to_char(x_act_close_date));
610:
611: IF fnd_log.g_current_runtime_level <= wip_constants.trace_logging THEN
612: wip_logger.exitPoint(

Line 609: fnd_file.put_line(FND_FILE.LOG,'x_act_close_date : '||to_char(x_act_close_date));

605: fnd_file.put_line(FND_FILE.LOG,'x_from_start_date : '||to_char(x_from_start_date));
606: fnd_file.put_line(FND_FILE.LOG,'x_to_start_date : '||to_char(x_to_start_date));
607: fnd_file.put_line(FND_FILE.LOG,'x_from_completion_date : '||to_char(x_from_completion_date));
608: fnd_file.put_line(FND_FILE.LOG,'x_to_completion_date : '||to_char(x_to_completion_date));
609: fnd_file.put_line(FND_FILE.LOG,'x_act_close_date : '||to_char(x_act_close_date));
610:
611: IF fnd_log.g_current_runtime_level <= wip_constants.trace_logging THEN
612: wip_logger.exitPoint(
613: p_procName => 'wip_close_priv.time_zone_conversions',

Line 687: fnd_file.put_line(FND_FILE.LOG,'Number of jobs failed because release date before close date : '|| to_char(l_failed_counter));

683: BULK COLLECT INTO l_failed_ids;
684:
685: l_failed_counter := l_failed_ids.COUNT;
686:
687: fnd_file.put_line(FND_FILE.LOG,'Number of jobs failed because release date before close date : '|| to_char(l_failed_counter));
688:
689: IF l_failed_counter = 0 THEN
690: x_returnstatus := FND_API.G_RET_STS_SUCCESS;
691: ELSE

Line 811: fnd_file.put_line(FND_FILE.LOG,'Pending Txns Check');

807: x_returnStatus => l_return_Status);
808: END IF;
809: x_returnStatus := fnd_api.g_ret_sts_success;
810: l_failed_counter := 0 ;
811: fnd_file.put_line(FND_FILE.LOG,'Pending Txns Check');
812:
813: OPEN c_pending_txns ;
814: LOOP
815: FETCH c_pending_txns INTO l_failed_jobs ;

Line 819: fnd_file.put_line(FND_FILE.OUTPUT,to_char(l_failed_jobs));

815: FETCH c_pending_txns INTO l_failed_jobs ;
816: if (c_pending_txns%FOUND) then
817: l_failed_counter := l_failed_counter + 1 ;
818: x_returnStatus := FND_API.G_RET_STS_ERROR ;
819: fnd_file.put_line(FND_FILE.OUTPUT,to_char(l_failed_jobs));
820: end if ;
821:
822: UPDATE WIP_DJ_CLOSE_TEMP
823: SET STATUS_TYPE = 99

Line 843: fnd_file.put_line(FND_FILE.LOG,'Number of jobs failed due to Pending txns : '|| to_char(l_failed_counter));

839: WHERE GROUP_ID = p_group_id
840: AND ORGANIZATION_ID = p_organization_id
841: AND STATUS_TYPE = 99;
842:
843: fnd_file.put_line(FND_FILE.LOG,'Number of jobs failed due to Pending txns : '|| to_char(l_failed_counter));
844:
845: IF (c_pending_txns%ISOPEN) THEN
846: CLOSE c_pending_txns ;
847: END IF;

Line 970: fnd_file.put_line(FND_FILE.OUTPUT,to_char(l_jobRec.wip_entity_name));

966: UPDATE WIP_DJ_CLOSE_TEMP
967: SET STATUS_TYPE = 99
968: WHERE WIP_ENTITY_ID = l_jobRec.wip_entity_id;
969: l_failed_counter := l_failed_counter + 1 ;
970: fnd_file.put_line(FND_FILE.OUTPUT,to_char(l_jobRec.wip_entity_name));
971: x_returnstatus := FND_API.G_RET_STS_ERROR;
972: END IF;
973: end loop;
974:

Line 989: fnd_file.put_line(FND_FILE.LOG,'Number of jobs failed due to Pending Clocks : '|| to_char(l_failed_counter));

985: WHERE GROUP_ID = p_group_id
986: AND ORGANIZATION_ID = p_organization_id
987: AND STATUS_TYPE = 99;
988:
989: fnd_file.put_line(FND_FILE.LOG,'Number of jobs failed due to Pending Clocks : '|| to_char(l_failed_counter));
990:
991: --
992: -- Bug 5345660 exitPoint for normal exit.
993: --

Line 1045: fnd_file.put_line(FND_FILE.LOG,'Cancelling Move Orders if any exists ');

1041: l_msg_data VARCHAR2(2000);
1042: l_failed_counter NUMBER ;
1043: BEGIN
1044: l_failed_counter := 0 ;
1045: fnd_file.put_line(FND_FILE.LOG,'Cancelling Move Orders if any exists ');
1046: for l_jobRec in c_jobs loop
1047: wip_picking_pvt.cancel_allocations
1048: (p_wip_entity_id => l_jobRec.wip_entity_id,
1049: p_wip_entity_type => l_jobRec.entity_type,

Line 1052: fnd_file.put_line(FND_FILE.LOG,'return status '||l_ret_status);

1048: (p_wip_entity_id => l_jobRec.wip_entity_id,
1049: p_wip_entity_type => l_jobRec.entity_type,
1050: x_return_status => l_ret_status,
1051: x_msg_data => l_msg_data);
1052: fnd_file.put_line(FND_FILE.LOG,'return status '||l_ret_status);
1053: IF (l_ret_status <> FND_API.G_RET_STS_SUCCESS ) then
1054: UPDATE WIP_DJ_CLOSE_TEMP
1055: SET STATUS_TYPE = 99
1056: WHERE WIP_ENTITY_ID = l_jobRec.wip_entity_id;

Line 1058: fnd_file.put_line(FND_FILE.OUTPUT,to_char(l_jobRec.wip_entity_name));

1054: UPDATE WIP_DJ_CLOSE_TEMP
1055: SET STATUS_TYPE = 99
1056: WHERE WIP_ENTITY_ID = l_jobRec.wip_entity_id;
1057: l_failed_counter := l_failed_counter + 1 ;
1058: fnd_file.put_line(FND_FILE.OUTPUT,to_char(l_jobRec.wip_entity_name));
1059: x_returnstatus := FND_API.G_RET_STS_ERROR;
1060: END IF;
1061: end loop;
1062:

Line 1100: fnd_file.put_line(FND_FILE.LOG,'Cancel PO');

1096: l_ret_status VARCHAR2(30);
1097: l_msg_data VARCHAR2(2000);
1098: l_propagate_job_change_to_po NUMBER;
1099: BEGIN
1100: fnd_file.put_line(FND_FILE.LOG,'Cancel PO');
1101:
1102: select propagate_job_change_to_po
1103: into l_propagate_job_change_to_po
1104: from wip_parameters

Line 1165: fnd_file.put_line(FND_FILE.LOG,'Inside Procedure Close Date ');

1161: AND mmt.TRANSACTION_DATE > wdct.ACTUAL_CLOSE_DATE) ;
1162: l_failed_jobs WIP_DJ_CLOSE_TEMP.WIP_ENTITY_NAME%TYPE ;
1163: l_failed_counter NUMBER ;
1164: BEGIN
1165: fnd_file.put_line(FND_FILE.LOG,'Inside Procedure Close Date ');
1166: x_returnStatus := fnd_api.g_ret_sts_success;
1167: l_failed_counter := 0 ;
1168:
1169: IF (l_logLevel <= wip_constants.trace_logging) THEN

Line 1183: fnd_file.put_line(FND_FILE.LOG,'Close date precedes the txn date for job '||l_failed_jobs);

1179: OPEN c_pending_txns ;
1180: LOOP
1181: FETCH c_pending_txns INTO l_failed_jobs ;
1182: if (c_pending_txns%FOUND) then
1183: fnd_file.put_line(FND_FILE.LOG,'Close date precedes the txn date for job '||l_failed_jobs);
1184: l_failed_counter := l_failed_counter + 1 ;
1185: x_returnstatus := FND_API.G_RET_STS_ERROR ;
1186: fnd_file.put_line(FND_FILE.OUTPUT,to_char(l_failed_jobs));
1187: end if ;

Line 1186: fnd_file.put_line(FND_FILE.OUTPUT,to_char(l_failed_jobs));

1182: if (c_pending_txns%FOUND) then
1183: fnd_file.put_line(FND_FILE.LOG,'Close date precedes the txn date for job '||l_failed_jobs);
1184: l_failed_counter := l_failed_counter + 1 ;
1185: x_returnstatus := FND_API.G_RET_STS_ERROR ;
1186: fnd_file.put_line(FND_FILE.OUTPUT,to_char(l_failed_jobs));
1187: end if ;
1188:
1189: UPDATE WIP_DJ_CLOSE_TEMP
1190: SET STATUS_TYPE = 99

Line 1195: fnd_file.put_line(FND_FILE.LOG,'Number of failed jobs because of past close date : '||l_failed_counter);

1191: WHERE WIP_ENTITY_NAME = l_failed_jobs ;
1192:
1193: EXIT WHEN c_pending_txns%NOTFOUND ;
1194: END LOOP ;
1195: fnd_file.put_line(FND_FILE.LOG,'Number of failed jobs because of past close date : '||l_failed_counter);
1196:
1197: UPDATE WIP_DISCRETE_JOBS
1198: SET STATUS_TYPE = WIP_CONSTANTS.FAIL_CLOSE
1199: WHERE WIP_ENTITY_ID IN

Line 1303: fnd_file.put_line(FND_FILE.LOG,'Open PO Check');

1299: l_failed_jobs WIP_DJ_CLOSE_TEMP.WIP_ENTITY_NAME%TYPE ;
1300: l_failed_counter NUMBER ;
1301:
1302: BEGIN
1303: fnd_file.put_line(FND_FILE.LOG,'Open PO Check');
1304:
1305: IF (l_logLevel <= wip_constants.trace_logging) THEN
1306: l_params(1).paramName := 'p_organization_id';
1307: l_params(1).paramValue := p_organization_id ;

Line 1321: fnd_file.put_line(FND_FILE.LOG,'Open PO Exists');

1317: OPEN c_open_po ;
1318: LOOP
1319: FETCH c_open_po INTO l_failed_jobs ;
1320: if (c_open_po%FOUND) then
1321: fnd_file.put_line(FND_FILE.LOG,'Open PO Exists');
1322: l_failed_counter := l_failed_counter + 1 ;
1323: x_returnStatus := fnd_api.g_ret_sts_error;
1324: fnd_file.put_line(FND_FILE.OUTPUT,to_char(l_failed_jobs));
1325: fnd_message.set_name('WIP', 'WIP_CANCEL_JOB/SCHED_OPEN_PO');

Line 1324: fnd_file.put_line(FND_FILE.OUTPUT,to_char(l_failed_jobs));

1320: if (c_open_po%FOUND) then
1321: fnd_file.put_line(FND_FILE.LOG,'Open PO Exists');
1322: l_failed_counter := l_failed_counter + 1 ;
1323: x_returnStatus := fnd_api.g_ret_sts_error;
1324: fnd_file.put_line(FND_FILE.OUTPUT,to_char(l_failed_jobs));
1325: fnd_message.set_name('WIP', 'WIP_CANCEL_JOB/SCHED_OPEN_PO');
1326: l_msg := fnd_message.get;
1327: fnd_file.put_line(FND_FILE.OUTPUT,l_msg);
1328: fnd_file.put_line(FND_FILE.OUTPUT,'*******************');

Line 1327: fnd_file.put_line(FND_FILE.OUTPUT,l_msg);

1323: x_returnStatus := fnd_api.g_ret_sts_error;
1324: fnd_file.put_line(FND_FILE.OUTPUT,to_char(l_failed_jobs));
1325: fnd_message.set_name('WIP', 'WIP_CANCEL_JOB/SCHED_OPEN_PO');
1326: l_msg := fnd_message.get;
1327: fnd_file.put_line(FND_FILE.OUTPUT,l_msg);
1328: fnd_file.put_line(FND_FILE.OUTPUT,'*******************');
1329: end if ;
1330:
1331: EXIT WHEN c_open_po%NOTFOUND ;

Line 1328: fnd_file.put_line(FND_FILE.OUTPUT,'*******************');

1324: fnd_file.put_line(FND_FILE.OUTPUT,to_char(l_failed_jobs));
1325: fnd_message.set_name('WIP', 'WIP_CANCEL_JOB/SCHED_OPEN_PO');
1326: l_msg := fnd_message.get;
1327: fnd_file.put_line(FND_FILE.OUTPUT,l_msg);
1328: fnd_file.put_line(FND_FILE.OUTPUT,'*******************');
1329: end if ;
1330:
1331: EXIT WHEN c_open_po%NOTFOUND ;
1332: END LOOP ;

Line 1334: fnd_file.put_line(FND_FILE.LOG,'Number of jobs failed in Open PO : '||to_char( l_failed_counter));

1330:
1331: EXIT WHEN c_open_po%NOTFOUND ;
1332: END LOOP ;
1333:
1334: fnd_file.put_line(FND_FILE.LOG,'Number of jobs failed in Open PO : '||to_char( l_failed_counter));
1335:
1336: IF (c_open_po%ISOPEN) THEN
1337: CLOSE c_open_po ;
1338: END IF;

Line 1410: fnd_file.put_line(FND_FILE.LOG,'Delivery Quantity Check');

1406: l_failed_jobs WIP_DJ_CLOSE_TEMP.WIP_ENTITY_NAME%TYPE ;
1407: l_failed_counter NUMBER ;
1408:
1409: BEGIN
1410: fnd_file.put_line(FND_FILE.LOG,'Delivery Quantity Check');
1411:
1412: IF (l_logLevel <= wip_constants.trace_logging) THEN
1413: l_params(1).paramName := 'p_organization_id';
1414: l_params(1).paramValue := p_organization_id ;

Line 1428: fnd_file.put_line(FND_FILE.LOG,'Quantity delivered less than Quantity received');

1424: OPEN c_delivered_qty ;
1425: LOOP
1426: FETCH c_delivered_qty INTO l_failed_jobs ;
1427: if (c_delivered_qty%FOUND) then
1428: fnd_file.put_line(FND_FILE.LOG,'Quantity delivered less than Quantity received');
1429: l_failed_counter := l_failed_counter + 1 ;
1430: x_returnStatus := fnd_api.g_ret_sts_error;
1431: fnd_file.put_line(FND_FILE.OUTPUT,to_char(l_failed_jobs));
1432: fnd_message.set_name('WIP', 'WIP_PO_NOT_DELIVERED'); /*Bug 9877786(FP of 9791544)*/

Line 1431: fnd_file.put_line(FND_FILE.OUTPUT,to_char(l_failed_jobs));

1427: if (c_delivered_qty%FOUND) then
1428: fnd_file.put_line(FND_FILE.LOG,'Quantity delivered less than Quantity received');
1429: l_failed_counter := l_failed_counter + 1 ;
1430: x_returnStatus := fnd_api.g_ret_sts_error;
1431: fnd_file.put_line(FND_FILE.OUTPUT,to_char(l_failed_jobs));
1432: fnd_message.set_name('WIP', 'WIP_PO_NOT_DELIVERED'); /*Bug 9877786(FP of 9791544)*/
1433: l_msg := fnd_message.get;
1434: fnd_file.put_line(FND_FILE.OUTPUT,l_msg);
1435: fnd_file.put_line(FND_FILE.OUTPUT,'*******************');

Line 1434: fnd_file.put_line(FND_FILE.OUTPUT,l_msg);

1430: x_returnStatus := fnd_api.g_ret_sts_error;
1431: fnd_file.put_line(FND_FILE.OUTPUT,to_char(l_failed_jobs));
1432: fnd_message.set_name('WIP', 'WIP_PO_NOT_DELIVERED'); /*Bug 9877786(FP of 9791544)*/
1433: l_msg := fnd_message.get;
1434: fnd_file.put_line(FND_FILE.OUTPUT,l_msg);
1435: fnd_file.put_line(FND_FILE.OUTPUT,'*******************');
1436: end if ;
1437: /*Bug 13625290*/
1438: UPDATE WIP_DJ_CLOSE_TEMP

Line 1435: fnd_file.put_line(FND_FILE.OUTPUT,'*******************');

1431: fnd_file.put_line(FND_FILE.OUTPUT,to_char(l_failed_jobs));
1432: fnd_message.set_name('WIP', 'WIP_PO_NOT_DELIVERED'); /*Bug 9877786(FP of 9791544)*/
1433: l_msg := fnd_message.get;
1434: fnd_file.put_line(FND_FILE.OUTPUT,l_msg);
1435: fnd_file.put_line(FND_FILE.OUTPUT,'*******************');
1436: end if ;
1437: /*Bug 13625290*/
1438: UPDATE WIP_DJ_CLOSE_TEMP
1439: SET STATUS_TYPE = 99

Line 1445: fnd_file.put_line(FND_FILE.LOG,'Number of jobs failed in Delivered Quantity : '||to_char( l_failed_counter));

1441:
1442: EXIT WHEN c_delivered_qty%NOTFOUND ;
1443: END LOOP ;
1444:
1445: fnd_file.put_line(FND_FILE.LOG,'Number of jobs failed in Delivered Quantity : '||to_char( l_failed_counter));
1446: /*Bug 13625290*/
1447: UPDATE WIP_DISCRETE_JOBS
1448: SET STATUS_TYPE = WIP_CONSTANTS.FAIL_CLOSE
1449: WHERE WIP_ENTITY_ID IN

Line 1511: fnd_file.put_line(FND_FILE.LOG,'lot validate');

1507: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
1508:
1509: BEGIN
1510: x_returnStatus := fnd_api.g_ret_sts_success;
1511: fnd_file.put_line(FND_FILE.LOG,'lot validate');
1512: IF (l_logLevel <= wip_constants.trace_logging) THEN
1513: l_params(1).paramName := 'p_organization_id';
1514: l_params(1).paramValue := p_organization_id ;
1515: l_params(1).paramName := 'p_group_id';

Line 1605: fnd_file.put_line(FND_FILE.LOG,'delete Existing reservations');

1601:
1602: /* end of fix 8681037 (FP 8461467) */
1603: BEGIN
1604: x_returnStatus := fnd_api.g_ret_sts_success;
1605: fnd_file.put_line(FND_FILE.LOG,'delete Existing reservations');
1606:
1607: IF (l_logLevel <= wip_constants.trace_logging) THEN
1608: l_params(1).paramName := 'p_organization_id';
1609: l_params(1).paramValue := p_organization_id ;

Line 1755: fnd_file.put_line(FND_FILE.LOG,'Running Reports.........');

1751: errbuf VARCHAR2(200);
1752: retcode NUMBER ;
1753:
1754: BEGIN
1755: fnd_file.put_line(FND_FILE.LOG,'Running Reports.........');
1756:
1757: x_ReturnStatus := fnd_api.g_ret_sts_success;
1758: SORT_BY_JOB := 1 ;
1759: l_report_type := p_report_type ;

Line 1766: fnd_file.put_line(FND_FILE.LOG,'Report Quantity Precision');

1762: IF ( l_precision_profile = NULL ) then
1763: l_precision_profile := 2;
1764: END IF ;
1765:
1766: fnd_file.put_line(FND_FILE.LOG,'Report Quantity Precision');
1767:
1768: SELECT COUNT(*)
1769: INTO l_std_asst_jobs
1770: FROM WIP_DJ_CLOSE_TEMP TEMP,

Line 1839: fnd_file.put_line(FND_FILE.LOG,'--------WIPRDJVR---------');

1835: IF (l_std_asst_jobs >= 1) and ( l_report_type <> 4 ) THEN
1836: /* STANDARD AND ASSET JOBS */
1837:
1838: IF (l_std_org_count = 1 ) THEN
1839: fnd_file.put_line(FND_FILE.LOG,'--------WIPRDJVR---------');
1840:
1841: l_req_id := FND_REQUEST.SUBMIT_REQUEST('WIP','WIPRDJVR',NULL,NULL,
1842: NULL,
1843: to_char(p_organization_id), -- Organziation id Parameter 1

Line 1877: fnd_file.put_line(FND_FILE.LOG,'CSTRDJVA');

1873: NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
1874: NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
1875:
1876: ELSE
1877: fnd_file.put_line(FND_FILE.LOG,'CSTRDJVA');
1878:
1879: l_req_id := FND_REQUEST.SUBMIT_REQUEST('BOM','CSTRDJVA',NULL,NULL,
1880: FALSE,
1881: NULL , -- Parameter 1

Line 1922: FND_FILE.PUT_LINE(FND_FILE.LOG,'Costing Report Concurrent Program return code : '||retcode);

1918: END IF;
1919:
1920: WAIT_CONC_PROGRAM(l_req_id,ERRBUF,RETCODE);
1921:
1922: FND_FILE.PUT_LINE(FND_FILE.LOG,'Costing Report Concurrent Program return code : '||retcode);
1923:
1924: if (retcode <> -1 ) then
1925: FND_FILE.PUT_LINE(FND_FILE.LOG,'Report has errored or has a warning');
1926: errbuf := fnd_message.get;

Line 1925: FND_FILE.PUT_LINE(FND_FILE.LOG,'Report has errored or has a warning');

1921:
1922: FND_FILE.PUT_LINE(FND_FILE.LOG,'Costing Report Concurrent Program return code : '||retcode);
1923:
1924: if (retcode <> -1 ) then
1925: FND_FILE.PUT_LINE(FND_FILE.LOG,'Report has errored or has a warning');
1926: errbuf := fnd_message.get;
1927: raise FND_API.G_EXC_ERROR ;
1928: end if;
1929:

Line 1937: fnd_file.put_line(FND_FILE.LOG,'WIPREJVR');

1933:
1934: IF (l_expense_jobs >= 1) and ( l_report_type <> 4 ) THEN
1935:
1936: l_report_type := 1 ; -- Always detailed reports only
1937: fnd_file.put_line(FND_FILE.LOG,'WIPREJVR');
1938:
1939: l_req_id := FND_REQUEST.SUBMIT_REQUEST('WIP','WIPREJVR',NULL,NULL,
1940: FALSE,
1941: to_char(p_organization_id), -- Parameter 1

Line 1974: FND_FILE.PUT_LINE(FND_FILE.LOG,'Expense report reurn code : '||retcode);

1970: END IF;
1971:
1972: WAIT_CONC_PROGRAM(l_req_id,ERRBUF,RETCODE);
1973:
1974: FND_FILE.PUT_LINE(FND_FILE.LOG,'Expense report reurn code : '||retcode);
1975:
1976: if (retcode <> -1 ) then
1977: FND_FILE.PUT_LINE(FND_FILE.LOG,'Report has errored or has a warning');
1978: errbuf := fnd_message.get;

Line 1977: FND_FILE.PUT_LINE(FND_FILE.LOG,'Report has errored or has a warning');

1973:
1974: FND_FILE.PUT_LINE(FND_FILE.LOG,'Expense report reurn code : '||retcode);
1975:
1976: if (retcode <> -1 ) then
1977: FND_FILE.PUT_LINE(FND_FILE.LOG,'Report has errored or has a warning');
1978: errbuf := fnd_message.get;
1979: raise FND_API.G_EXC_ERROR ;
1980: end if;
1981:

Line 2059: fnd_file.put_line(FND_FILE.LOG,'WIP DISCRETE JOB CLOSE');

2055: l_at_submission_time := 1 ; ---SRS
2056: l_immediate := 2 ; -- From Close Form
2057: x_returnStatus := FND_API.G_RET_STS_SUCCESS ;
2058:
2059: fnd_file.put_line(FND_FILE.LOG,'WIP DISCRETE JOB CLOSE');
2060:
2061: fnd_file.put_line(FND_FILE.OUTPUT,'*****************************');
2062: fnd_file.put_line(FND_FILE.OUTPUT,'WIP DISCRETE JOB CLOSE OUTPUT');
2063: fnd_file.put_line(FND_FILE.OUTPUT,'*****************************');

Line 2061: fnd_file.put_line(FND_FILE.OUTPUT,'*****************************');

2057: x_returnStatus := FND_API.G_RET_STS_SUCCESS ;
2058:
2059: fnd_file.put_line(FND_FILE.LOG,'WIP DISCRETE JOB CLOSE');
2060:
2061: fnd_file.put_line(FND_FILE.OUTPUT,'*****************************');
2062: fnd_file.put_line(FND_FILE.OUTPUT,'WIP DISCRETE JOB CLOSE OUTPUT');
2063: fnd_file.put_line(FND_FILE.OUTPUT,'*****************************');
2064: -- write parameter value to log file
2065:

Line 2062: fnd_file.put_line(FND_FILE.OUTPUT,'WIP DISCRETE JOB CLOSE OUTPUT');

2058:
2059: fnd_file.put_line(FND_FILE.LOG,'WIP DISCRETE JOB CLOSE');
2060:
2061: fnd_file.put_line(FND_FILE.OUTPUT,'*****************************');
2062: fnd_file.put_line(FND_FILE.OUTPUT,'WIP DISCRETE JOB CLOSE OUTPUT');
2063: fnd_file.put_line(FND_FILE.OUTPUT,'*****************************');
2064: -- write parameter value to log file
2065:
2066: IF (l_logLevel <= wip_constants.trace_logging) THEN

Line 2063: fnd_file.put_line(FND_FILE.OUTPUT,'*****************************');

2059: fnd_file.put_line(FND_FILE.LOG,'WIP DISCRETE JOB CLOSE');
2060:
2061: fnd_file.put_line(FND_FILE.OUTPUT,'*****************************');
2062: fnd_file.put_line(FND_FILE.OUTPUT,'WIP DISCRETE JOB CLOSE OUTPUT');
2063: fnd_file.put_line(FND_FILE.OUTPUT,'*****************************');
2064: -- write parameter value to log file
2065:
2066: IF (l_logLevel <= wip_constants.trace_logging) THEN
2067: l_params(1).paramName := 'p_organization_id';

Line 2144: fnd_file.put_line(FND_FILE.LOG,'WIP DISCRETE CLOSE');

2140: RAISE FND_API.G_EXC_ERROR ;
2141: END IF;
2142:
2143: if ( sysdate > l_act_close_date ) then
2144: fnd_file.put_line(FND_FILE.LOG,'WIP DISCRETE CLOSE');
2145: else
2146: fnd_message.set_name('WIP','CLOSE DATE');
2147: l_msg := fnd_message.get;
2148: l_msg := l_msg || ' ' || l_act_close_date ;

Line 2153: fnd_file.put_line(FND_FILE.OUTPUT,l_msg);

2149: fnd_message.set_name('WIP','WIP_LESS_OR_EQUAL');
2150: fnd_message.set_token('ENTITY1',l_msg);
2151: fnd_message.set_token('ENTITY2', sysdate);
2152: l_msg := fnd_message.get;
2153: fnd_file.put_line(FND_FILE.OUTPUT,l_msg);
2154: fnd_file.put_line(FND_FILE.OUTPUT,'*******************');
2155: fnd_file.put_line(FND_FILE.LOG,l_msg);
2156: RAISE FND_API.G_EXC_ERROR ;
2157: end if ;

Line 2154: fnd_file.put_line(FND_FILE.OUTPUT,'*******************');

2150: fnd_message.set_token('ENTITY1',l_msg);
2151: fnd_message.set_token('ENTITY2', sysdate);
2152: l_msg := fnd_message.get;
2153: fnd_file.put_line(FND_FILE.OUTPUT,l_msg);
2154: fnd_file.put_line(FND_FILE.OUTPUT,'*******************');
2155: fnd_file.put_line(FND_FILE.LOG,l_msg);
2156: RAISE FND_API.G_EXC_ERROR ;
2157: end if ;
2158:

Line 2155: fnd_file.put_line(FND_FILE.LOG,l_msg);

2151: fnd_message.set_token('ENTITY2', sysdate);
2152: l_msg := fnd_message.get;
2153: fnd_file.put_line(FND_FILE.OUTPUT,l_msg);
2154: fnd_file.put_line(FND_FILE.OUTPUT,'*******************');
2155: fnd_file.put_line(FND_FILE.LOG,l_msg);
2156: RAISE FND_API.G_EXC_ERROR ;
2157: end if ;
2158:
2159: /****************************************************************

Line 2178: fnd_file.put_line(FND_FILE.OUTPUT,l_msg);

2174: EXCEPTION
2175: WHEN NO_DATA_FOUND THEN
2176: fnd_message.set_name('WIP','WIP_CLOSE_CLOSED_PERIOD');
2177: l_msg := fnd_message.get;
2178: fnd_file.put_line(FND_FILE.OUTPUT,l_msg);
2179: fnd_file.put_line(FND_FILE.OUTPUT,'*******************');
2180: fnd_file.put_line(FND_FILE.LOG,l_msg) ;
2181: RAISE FND_API.G_EXC_ERROR ;
2182: END ;

Line 2179: fnd_file.put_line(FND_FILE.OUTPUT,'*******************');

2175: WHEN NO_DATA_FOUND THEN
2176: fnd_message.set_name('WIP','WIP_CLOSE_CLOSED_PERIOD');
2177: l_msg := fnd_message.get;
2178: fnd_file.put_line(FND_FILE.OUTPUT,l_msg);
2179: fnd_file.put_line(FND_FILE.OUTPUT,'*******************');
2180: fnd_file.put_line(FND_FILE.LOG,l_msg) ;
2181: RAISE FND_API.G_EXC_ERROR ;
2182: END ;
2183:

Line 2180: fnd_file.put_line(FND_FILE.LOG,l_msg) ;

2176: fnd_message.set_name('WIP','WIP_CLOSE_CLOSED_PERIOD');
2177: l_msg := fnd_message.get;
2178: fnd_file.put_line(FND_FILE.OUTPUT,l_msg);
2179: fnd_file.put_line(FND_FILE.OUTPUT,'*******************');
2180: fnd_file.put_line(FND_FILE.LOG,l_msg) ;
2181: RAISE FND_API.G_EXC_ERROR ;
2182: END ;
2183:
2184: /**********************************************************

Line 2284: fnd_file.put_line(FND_FILE.LOG,'GROUP ID '||to_char(l_group_id));

2280:
2281: END IF ;
2282:
2283: SAVEPOINT wip_close; --Bug#13639508- Added a savepoint so that insertion into wip_dj_close_temp is not rolled back
2284: fnd_file.put_line(FND_FILE.LOG,'GROUP ID '||to_char(l_group_id));
2285:
2286: /*Fix bug 9250439*/
2287: SELECT COUNT(*)
2288: INTO l_jobs_to_close

Line 2311: fnd_file.put_line(FND_FILE.OUTPUT,l_msg);

2307:
2308: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
2309: fnd_message.set_name('WIP', 'WIP_PRIOR_DATE_RELEASE');
2310: l_msg := fnd_message.get;
2311: fnd_file.put_line(FND_FILE.OUTPUT,l_msg);
2312: fnd_file.put_line(FND_FILE.OUTPUT,'*******************');
2313: x_warning := 1 ;
2314: --
2315: -- Bug 5345660 Added profile check before invoking wip_logger

Line 2312: fnd_file.put_line(FND_FILE.OUTPUT,'*******************');

2308: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
2309: fnd_message.set_name('WIP', 'WIP_PRIOR_DATE_RELEASE');
2310: l_msg := fnd_message.get;
2311: fnd_file.put_line(FND_FILE.OUTPUT,l_msg);
2312: fnd_file.put_line(FND_FILE.OUTPUT,'*******************');
2313: x_warning := 1 ;
2314: --
2315: -- Bug 5345660 Added profile check before invoking wip_logger
2316: --

Line 2353: fnd_file.put_line(FND_FILE.OUTPUT,l_msg);

2349:
2350: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
2351: fnd_message.set_name('WIP', 'WIP_PENDING_CLOCKS');
2352: l_msg := fnd_message.get;
2353: fnd_file.put_line(FND_FILE.OUTPUT,l_msg);
2354: fnd_file.put_line(FND_FILE.OUTPUT,'*******************');
2355: x_warning := 1 ;
2356: --
2357: -- Bug 5345660 Added profile check before invoking wip_logger

Line 2354: fnd_file.put_line(FND_FILE.OUTPUT,'*******************');

2350: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
2351: fnd_message.set_name('WIP', 'WIP_PENDING_CLOCKS');
2352: l_msg := fnd_message.get;
2353: fnd_file.put_line(FND_FILE.OUTPUT,l_msg);
2354: fnd_file.put_line(FND_FILE.OUTPUT,'*******************');
2355: x_warning := 1 ;
2356: --
2357: -- Bug 5345660 Added profile check before invoking wip_logger
2358: --

Line 2379: fnd_file.put_line(FND_FILE.OUTPUT,l_msg);

2375: p_group_id => l_group_id);
2376: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
2377: fnd_message.set_name('WIP', 'TRANSACTIONS PENDING');
2378: l_msg := fnd_message.get;
2379: fnd_file.put_line(FND_FILE.OUTPUT,l_msg);
2380: fnd_file.put_line(FND_FILE.OUTPUT,'*******************');
2381: x_warning := 1 ;
2382: --
2383: -- Bug 5345660 Added profile check before invoking wip_logger

Line 2380: fnd_file.put_line(FND_FILE.OUTPUT,'*******************');

2376: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
2377: fnd_message.set_name('WIP', 'TRANSACTIONS PENDING');
2378: l_msg := fnd_message.get;
2379: fnd_file.put_line(FND_FILE.OUTPUT,l_msg);
2380: fnd_file.put_line(FND_FILE.OUTPUT,'*******************');
2381: x_warning := 1 ;
2382: --
2383: -- Bug 5345660 Added profile check before invoking wip_logger
2384: --

Line 2406: fnd_file.put_line(FND_FILE.OUTPUT,l_msg);

2402:
2403: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
2404: fnd_message.set_name('WIP', 'TRANSACTIONS PENDING');
2405: l_msg := fnd_message.get;
2406: fnd_file.put_line(FND_FILE.OUTPUT,l_msg);
2407: fnd_file.put_line(FND_FILE.OUTPUT,'*******************');
2408: x_warning := 1 ;
2409: --
2410: -- Bug 5345660 Added profile check before invoking wip_logger

Line 2407: fnd_file.put_line(FND_FILE.OUTPUT,'*******************');

2403: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
2404: fnd_message.set_name('WIP', 'TRANSACTIONS PENDING');
2405: l_msg := fnd_message.get;
2406: fnd_file.put_line(FND_FILE.OUTPUT,l_msg);
2407: fnd_file.put_line(FND_FILE.OUTPUT,'*******************');
2408: x_warning := 1 ;
2409: --
2410: -- Bug 5345660 Added profile check before invoking wip_logger
2411: --

Line 2432: fnd_file.put_line(FND_FILE.OUTPUT,l_msg);

2428:
2429: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
2430: fnd_message.set_name('WIP', 'CLOSE DATE IN PAST');
2431: l_msg := fnd_message.get;
2432: fnd_file.put_line(FND_FILE.OUTPUT,l_msg);
2433: fnd_file.put_line(FND_FILE.OUTPUT,'*******************');
2434: x_warning := 1 ;
2435: --
2436: -- Bug 5345660 Added profile check before invoking wip_logger

Line 2433: fnd_file.put_line(FND_FILE.OUTPUT,'*******************');

2429: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
2430: fnd_message.set_name('WIP', 'CLOSE DATE IN PAST');
2431: l_msg := fnd_message.get;
2432: fnd_file.put_line(FND_FILE.OUTPUT,l_msg);
2433: fnd_file.put_line(FND_FILE.OUTPUT,'*******************');
2434: x_warning := 1 ;
2435: --
2436: -- Bug 5345660 Added profile check before invoking wip_logger
2437: --

Line 2545: fnd_file.put_line(FND_FILE.LOG,'Current accounting Period ID : '||to_char(l_acct_period_id));

2541: WHERE TRUNC(SYSDATE) >= TRUNC(PERIOD_START_DATE)
2542: AND TRUNC(SYSDATE) <= TRUNC(SCHEDULE_CLOSE_DATE)
2543: AND ORGANIZATION_ID = p_organization_id;
2544:
2545: fnd_file.put_line(FND_FILE.LOG,'Current accounting Period ID : '||to_char(l_acct_period_id));
2546: EXCEPTION
2547: WHEN OTHERS THEN
2548:
2549: IF p_act_close_date IS NULL THEN

Line 2565: fnd_file.put_line(FND_FILE.LOG,'Last accounting Period ID : '||to_char(l_acct_period_id));

2561: AND oap.PERIOD_CLOSE_DATE IS NULL
2562: AND INV_LE_TIMEZONE_PUB.GET_LE_DAY_FOR_INV_ORG(nvl(l_acct_period_close_date,to_date(p_act_close_date,'YYYY/MM/DD HH24:MI:SS')),p_organization_id)
2563: BETWEEN oap.PERIOD_START_DATE and oap.SCHEDULE_CLOSE_DATE;
2564:
2565: fnd_file.put_line(FND_FILE.LOG,'Last accounting Period ID : '||to_char(l_acct_period_id));
2566: END;
2567:
2568:
2569: /*********************************************************

Line 2770: fnd_file.get_names(l_msg,l_msg_data);

2766: /*****************************************************/
2767: /* CALLING REPORTS */
2768: /*****************************************************/
2769:
2770: fnd_file.get_names(l_msg,l_msg_data);
2771: fnd_file.put_line( FND_FILE.LOG,l_msg);
2772: fnd_file.put_line( FND_FILE.LOG,l_msg_data);
2773:
2774: Run_Reports(

Line 2771: fnd_file.put_line( FND_FILE.LOG,l_msg);

2767: /* CALLING REPORTS */
2768: /*****************************************************/
2769:
2770: fnd_file.get_names(l_msg,l_msg_data);
2771: fnd_file.put_line( FND_FILE.LOG,l_msg);
2772: fnd_file.put_line( FND_FILE.LOG,l_msg_data);
2773:
2774: Run_Reports(
2775: x_returnstatus => l_return_status,

Line 2772: fnd_file.put_line( FND_FILE.LOG,l_msg_data);

2768: /*****************************************************/
2769:
2770: fnd_file.get_names(l_msg,l_msg_data);
2771: fnd_file.put_line( FND_FILE.LOG,l_msg);
2772: fnd_file.put_line( FND_FILE.LOG,l_msg_data);
2773:
2774: Run_Reports(
2775: x_returnstatus => l_return_status,
2776: p_group_id => l_group_id ,

Line 2802: fnd_file.put_line( FND_FILE.LOG,'Number of jobs Closed '||to_char(l_num_close));

2798: FROM WIP_DJ_CLOSE_TEMP
2799: WHERE ORGANIZATION_ID = p_organization_id
2800: AND GROUP_ID = l_group_id;
2801:
2802: fnd_file.put_line( FND_FILE.LOG,'Number of jobs Closed '||to_char(l_num_close));
2803: fnd_file.put(FND_FILE.OUTPUT,to_char(l_num_close)||' ');
2804: fnd_message.set_name('WIP','WIP_NUM_CLOSED');
2805: l_msg := fnd_message.get;
2806: fnd_file.put_line(FND_FILE.OUTPUT,l_msg);

Line 2803: fnd_file.put(FND_FILE.OUTPUT,to_char(l_num_close)||' ');

2799: WHERE ORGANIZATION_ID = p_organization_id
2800: AND GROUP_ID = l_group_id;
2801:
2802: fnd_file.put_line( FND_FILE.LOG,'Number of jobs Closed '||to_char(l_num_close));
2803: fnd_file.put(FND_FILE.OUTPUT,to_char(l_num_close)||' ');
2804: fnd_message.set_name('WIP','WIP_NUM_CLOSED');
2805: l_msg := fnd_message.get;
2806: fnd_file.put_line(FND_FILE.OUTPUT,l_msg);
2807: fnd_file.put_line(FND_FILE.OUTPUT,'*******************');

Line 2806: fnd_file.put_line(FND_FILE.OUTPUT,l_msg);

2802: fnd_file.put_line( FND_FILE.LOG,'Number of jobs Closed '||to_char(l_num_close));
2803: fnd_file.put(FND_FILE.OUTPUT,to_char(l_num_close)||' ');
2804: fnd_message.set_name('WIP','WIP_NUM_CLOSED');
2805: l_msg := fnd_message.get;
2806: fnd_file.put_line(FND_FILE.OUTPUT,l_msg);
2807: fnd_file.put_line(FND_FILE.OUTPUT,'*******************');
2808:
2809:
2810: IF ( l_num_close > 0 ) THEN

Line 2807: fnd_file.put_line(FND_FILE.OUTPUT,'*******************');

2803: fnd_file.put(FND_FILE.OUTPUT,to_char(l_num_close)||' ');
2804: fnd_message.set_name('WIP','WIP_NUM_CLOSED');
2805: l_msg := fnd_message.get;
2806: fnd_file.put_line(FND_FILE.OUTPUT,l_msg);
2807: fnd_file.put_line(FND_FILE.OUTPUT,'*******************');
2808:
2809:
2810: IF ( l_num_close > 0 ) THEN
2811: DELETE FROM WIP_DJ_CLOSE_TEMP

Line 2835: fnd_file.put_line( FND_FILE.LOG,'Exception has occured');

2831: EXCEPTION
2832: WHEN others THEN
2833: rollback TO wip_close;--Bug#13639508- Rollback to the savepoint so that insertion into wip_dj_close_temp is not rolled back
2834:
2835: fnd_file.put_line( FND_FILE.LOG,'Exception has occured');
2836: x_returnStatus := FND_API.G_RET_STS_ERROR ;
2837: /* Update jobs to Failed Close status */
2838:
2839: /*Bug 6908428: Update the status of eam_work_order_details to failed close and proceed workflow notification*/