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 36: fnd_file.put_line(FND_FILE.LOG,'Populate Close Temp');

32: l_number_temp NUMBER ;
33:
34: BEGIN
35: x_returnStatus := fnd_api.g_ret_sts_success;
36: fnd_file.put_line(FND_FILE.LOG,'Populate Close Temp');
37:
38: IF (l_logLevel <= wip_constants.trace_logging) THEN
39: l_params(1).paramName := 'p_organization_id';
40: l_params(1).paramValue := p_organization_id ;

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

163: INTO l_number_temp
164: FROM WIP_DJ_CLOSE_TEMP
165: WHERE group_id = x_group_id ;
166:
167: fnd_file.put_line(FND_FILE.LOG,'Records inserted in close temp '||to_char(l_number_temp));
168:
169: --
170: -- Bug 5345660 exitPoint for normal exit.
171: --

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

238: p_params => l_params,
239: x_returnStatus => l_return_Status);
240: END IF;
241: x_ReturnStatus := fnd_api.g_ret_sts_success ;
242: fnd_file.put_line(FND_FILE.LOG,'Time Zone Conversions');
243:
244: IF(fnd_profile.value('ENABLE_TIMEZONE_CONVERSIONS') = 'Y') THEN
245:
246: HZ_TIMEZONE_PUB.Get_Time(

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

332:
333:
334: END IF;
335:
336: fnd_file.put_line(FND_FILE.LOG,'x_from_release_date : '||to_char(x_from_release_date));
337: fnd_file.put_line(FND_FILE.LOG,'x_to_release_date : '||to_char(x_to_release_date));
338: fnd_file.put_line(FND_FILE.LOG,'x_from_start_date : '||to_char(x_from_start_date));
339: fnd_file.put_line(FND_FILE.LOG,'x_to_start_date : '||to_char(x_to_start_date));
340: fnd_file.put_line(FND_FILE.LOG,'x_from_completion_date : '||to_char(x_from_completion_date));

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

333:
334: END IF;
335:
336: fnd_file.put_line(FND_FILE.LOG,'x_from_release_date : '||to_char(x_from_release_date));
337: fnd_file.put_line(FND_FILE.LOG,'x_to_release_date : '||to_char(x_to_release_date));
338: fnd_file.put_line(FND_FILE.LOG,'x_from_start_date : '||to_char(x_from_start_date));
339: fnd_file.put_line(FND_FILE.LOG,'x_to_start_date : '||to_char(x_to_start_date));
340: fnd_file.put_line(FND_FILE.LOG,'x_from_completion_date : '||to_char(x_from_completion_date));
341: fnd_file.put_line(FND_FILE.LOG,'x_to_completion_date : '||to_char(x_to_completion_date));

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

334: END IF;
335:
336: fnd_file.put_line(FND_FILE.LOG,'x_from_release_date : '||to_char(x_from_release_date));
337: fnd_file.put_line(FND_FILE.LOG,'x_to_release_date : '||to_char(x_to_release_date));
338: fnd_file.put_line(FND_FILE.LOG,'x_from_start_date : '||to_char(x_from_start_date));
339: fnd_file.put_line(FND_FILE.LOG,'x_to_start_date : '||to_char(x_to_start_date));
340: fnd_file.put_line(FND_FILE.LOG,'x_from_completion_date : '||to_char(x_from_completion_date));
341: fnd_file.put_line(FND_FILE.LOG,'x_to_completion_date : '||to_char(x_to_completion_date));
342: fnd_file.put_line(FND_FILE.LOG,'x_act_close_date : '||to_char(x_act_close_date));

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

335:
336: fnd_file.put_line(FND_FILE.LOG,'x_from_release_date : '||to_char(x_from_release_date));
337: fnd_file.put_line(FND_FILE.LOG,'x_to_release_date : '||to_char(x_to_release_date));
338: fnd_file.put_line(FND_FILE.LOG,'x_from_start_date : '||to_char(x_from_start_date));
339: fnd_file.put_line(FND_FILE.LOG,'x_to_start_date : '||to_char(x_to_start_date));
340: fnd_file.put_line(FND_FILE.LOG,'x_from_completion_date : '||to_char(x_from_completion_date));
341: fnd_file.put_line(FND_FILE.LOG,'x_to_completion_date : '||to_char(x_to_completion_date));
342: fnd_file.put_line(FND_FILE.LOG,'x_act_close_date : '||to_char(x_act_close_date));
343:

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

336: fnd_file.put_line(FND_FILE.LOG,'x_from_release_date : '||to_char(x_from_release_date));
337: fnd_file.put_line(FND_FILE.LOG,'x_to_release_date : '||to_char(x_to_release_date));
338: fnd_file.put_line(FND_FILE.LOG,'x_from_start_date : '||to_char(x_from_start_date));
339: fnd_file.put_line(FND_FILE.LOG,'x_to_start_date : '||to_char(x_to_start_date));
340: fnd_file.put_line(FND_FILE.LOG,'x_from_completion_date : '||to_char(x_from_completion_date));
341: fnd_file.put_line(FND_FILE.LOG,'x_to_completion_date : '||to_char(x_to_completion_date));
342: fnd_file.put_line(FND_FILE.LOG,'x_act_close_date : '||to_char(x_act_close_date));
343:
344: IF fnd_log.g_current_runtime_level <= wip_constants.trace_logging THEN

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

337: fnd_file.put_line(FND_FILE.LOG,'x_to_release_date : '||to_char(x_to_release_date));
338: fnd_file.put_line(FND_FILE.LOG,'x_from_start_date : '||to_char(x_from_start_date));
339: fnd_file.put_line(FND_FILE.LOG,'x_to_start_date : '||to_char(x_to_start_date));
340: fnd_file.put_line(FND_FILE.LOG,'x_from_completion_date : '||to_char(x_from_completion_date));
341: fnd_file.put_line(FND_FILE.LOG,'x_to_completion_date : '||to_char(x_to_completion_date));
342: fnd_file.put_line(FND_FILE.LOG,'x_act_close_date : '||to_char(x_act_close_date));
343:
344: IF fnd_log.g_current_runtime_level <= wip_constants.trace_logging THEN
345: wip_logger.exitPoint(

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

338: fnd_file.put_line(FND_FILE.LOG,'x_from_start_date : '||to_char(x_from_start_date));
339: fnd_file.put_line(FND_FILE.LOG,'x_to_start_date : '||to_char(x_to_start_date));
340: fnd_file.put_line(FND_FILE.LOG,'x_from_completion_date : '||to_char(x_from_completion_date));
341: fnd_file.put_line(FND_FILE.LOG,'x_to_completion_date : '||to_char(x_to_completion_date));
342: fnd_file.put_line(FND_FILE.LOG,'x_act_close_date : '||to_char(x_act_close_date));
343:
344: IF fnd_log.g_current_runtime_level <= wip_constants.trace_logging THEN
345: wip_logger.exitPoint(
346: p_procName => 'wip_close_priv.time_zone_conversions',

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

416: BULK COLLECT INTO l_failed_ids;
417:
418: l_failed_counter := l_failed_ids.COUNT;
419:
420: fnd_file.put_line(FND_FILE.LOG,'Number of jobs failed because release date before close date : '|| to_char(l_failed_counter));
421:
422: IF l_failed_counter = 0 THEN
423: x_returnstatus := FND_API.G_RET_STS_SUCCESS;
424: ELSE

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

540: x_returnStatus => l_return_Status);
541: END IF;
542: x_returnStatus := fnd_api.g_ret_sts_success;
543: l_failed_counter := 0 ;
544: fnd_file.put_line(FND_FILE.LOG,'Pending Txns Check');
545:
546: OPEN c_pending_txns ;
547: LOOP
548: FETCH c_pending_txns INTO l_failed_jobs ;

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

548: FETCH c_pending_txns INTO l_failed_jobs ;
549: if (c_pending_txns%FOUND) then
550: l_failed_counter := l_failed_counter + 1 ;
551: x_returnStatus := FND_API.G_RET_STS_ERROR ;
552: fnd_file.put_line(FND_FILE.OUTPUT,to_char(l_failed_jobs));
553: end if ;
554:
555: UPDATE WIP_DJ_CLOSE_TEMP
556: SET STATUS_TYPE = 99

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

572: WHERE GROUP_ID = p_group_id
573: AND ORGANIZATION_ID = p_organization_id
574: AND STATUS_TYPE = 99;
575:
576: fnd_file.put_line(FND_FILE.LOG,'Number of jobs failed due to Pending txns : '|| to_char(l_failed_counter));
577:
578: IF (c_pending_txns%ISOPEN) THEN
579: CLOSE c_pending_txns ;
580: END IF;

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

699: UPDATE WIP_DJ_CLOSE_TEMP
700: SET STATUS_TYPE = 99
701: WHERE WIP_ENTITY_ID = l_jobRec.wip_entity_id;
702: l_failed_counter := l_failed_counter + 1 ;
703: fnd_file.put_line(FND_FILE.OUTPUT,to_char(l_jobRec.wip_entity_name));
704: x_returnstatus := FND_API.G_RET_STS_ERROR;
705: END IF;
706: end loop;
707:

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

718: WHERE GROUP_ID = p_group_id
719: AND ORGANIZATION_ID = p_organization_id
720: AND STATUS_TYPE = 99;
721:
722: fnd_file.put_line(FND_FILE.LOG,'Number of jobs failed due to Pending Clocks : '|| to_char(l_failed_counter));
723:
724: --
725: -- Bug 5345660 exitPoint for normal exit.
726: --

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

774: l_msg_data VARCHAR2(2000);
775: l_failed_counter NUMBER ;
776: BEGIN
777: l_failed_counter := 0 ;
778: fnd_file.put_line(FND_FILE.LOG,'Cancelling Move Orders if any exists ');
779: for l_jobRec in c_jobs loop
780: wip_picking_pvt.cancel_allocations
781: (p_wip_entity_id => l_jobRec.wip_entity_id,
782: p_wip_entity_type => l_jobRec.entity_type,

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

781: (p_wip_entity_id => l_jobRec.wip_entity_id,
782: p_wip_entity_type => l_jobRec.entity_type,
783: x_return_status => l_ret_status,
784: x_msg_data => l_msg_data);
785: fnd_file.put_line(FND_FILE.LOG,'return status '||l_ret_status);
786: IF (l_ret_status <> FND_API.G_RET_STS_SUCCESS ) then
787: UPDATE WIP_DJ_CLOSE_TEMP
788: SET STATUS_TYPE = 99
789: WHERE WIP_ENTITY_ID = l_jobRec.wip_entity_id;

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

787: UPDATE WIP_DJ_CLOSE_TEMP
788: SET STATUS_TYPE = 99
789: WHERE WIP_ENTITY_ID = l_jobRec.wip_entity_id;
790: l_failed_counter := l_failed_counter + 1 ;
791: fnd_file.put_line(FND_FILE.OUTPUT,to_char(l_jobRec.wip_entity_name));
792: x_returnstatus := FND_API.G_RET_STS_ERROR;
793: END IF;
794: end loop;
795:

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

829: l_ret_status VARCHAR2(30);
830: l_msg_data VARCHAR2(2000);
831: l_propagate_job_change_to_po NUMBER;
832: BEGIN
833: fnd_file.put_line(FND_FILE.LOG,'Cancel PO');
834:
835: select propagate_job_change_to_po
836: into l_propagate_job_change_to_po
837: from wip_parameters

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

894: AND mmt.TRANSACTION_DATE > wdct.ACTUAL_CLOSE_DATE) ;
895: l_failed_jobs WIP_DJ_CLOSE_TEMP.WIP_ENTITY_NAME%TYPE ;
896: l_failed_counter NUMBER ;
897: BEGIN
898: fnd_file.put_line(FND_FILE.LOG,'Inside Procedure Close Date ');
899: x_returnStatus := fnd_api.g_ret_sts_success;
900: l_failed_counter := 0 ;
901:
902: IF (l_logLevel <= wip_constants.trace_logging) THEN

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

912: OPEN c_pending_txns ;
913: LOOP
914: FETCH c_pending_txns INTO l_failed_jobs ;
915: if (c_pending_txns%FOUND) then
916: fnd_file.put_line(FND_FILE.LOG,'Close date precedes the txn date for job '||l_failed_jobs);
917: l_failed_counter := l_failed_counter + 1 ;
918: x_returnstatus := FND_API.G_RET_STS_ERROR ;
919: fnd_file.put_line(FND_FILE.OUTPUT,to_char(l_failed_jobs));
920: end if ;

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

915: if (c_pending_txns%FOUND) then
916: fnd_file.put_line(FND_FILE.LOG,'Close date precedes the txn date for job '||l_failed_jobs);
917: l_failed_counter := l_failed_counter + 1 ;
918: x_returnstatus := FND_API.G_RET_STS_ERROR ;
919: fnd_file.put_line(FND_FILE.OUTPUT,to_char(l_failed_jobs));
920: end if ;
921:
922: UPDATE WIP_DJ_CLOSE_TEMP
923: SET STATUS_TYPE = 99

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

924: WHERE WIP_ENTITY_NAME = l_failed_jobs ;
925:
926: EXIT WHEN c_pending_txns%NOTFOUND ;
927: END LOOP ;
928: fnd_file.put_line(FND_FILE.LOG,'Number of failed jobs because of past close date : '||l_failed_counter);
929:
930: UPDATE WIP_DISCRETE_JOBS
931: SET STATUS_TYPE = WIP_CONSTANTS.FAIL_CLOSE
932: WHERE WIP_ENTITY_ID IN

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

1031: l_failed_jobs WIP_DJ_CLOSE_TEMP.WIP_ENTITY_NAME%TYPE ;
1032: l_failed_counter NUMBER ;
1033:
1034: BEGIN
1035: fnd_file.put_line(FND_FILE.LOG,'Open PO Check');
1036:
1037: IF (l_logLevel <= wip_constants.trace_logging) THEN
1038: l_params(1).paramName := 'p_organization_id';
1039: l_params(1).paramValue := p_organization_id ;

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

1049: OPEN c_open_po ;
1050: LOOP
1051: FETCH c_open_po INTO l_failed_jobs ;
1052: if (c_open_po%FOUND) then
1053: fnd_file.put_line(FND_FILE.LOG,'Open PO Exists');
1054: l_failed_counter := l_failed_counter + 1 ;
1055: x_returnStatus := fnd_api.g_ret_sts_error;
1056: fnd_file.put_line(FND_FILE.OUTPUT,to_char(l_failed_jobs));
1057: fnd_message.set_name('WIP', 'WIP_CANCEL_JOB/SCHED_OPEN_PO');

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

1052: if (c_open_po%FOUND) then
1053: fnd_file.put_line(FND_FILE.LOG,'Open PO Exists');
1054: l_failed_counter := l_failed_counter + 1 ;
1055: x_returnStatus := fnd_api.g_ret_sts_error;
1056: fnd_file.put_line(FND_FILE.OUTPUT,to_char(l_failed_jobs));
1057: fnd_message.set_name('WIP', 'WIP_CANCEL_JOB/SCHED_OPEN_PO');
1058: l_msg := fnd_message.get;
1059: fnd_file.put_line(FND_FILE.OUTPUT,l_msg);
1060: fnd_file.put_line(FND_FILE.OUTPUT,'*******************');

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

1055: x_returnStatus := fnd_api.g_ret_sts_error;
1056: fnd_file.put_line(FND_FILE.OUTPUT,to_char(l_failed_jobs));
1057: fnd_message.set_name('WIP', 'WIP_CANCEL_JOB/SCHED_OPEN_PO');
1058: l_msg := fnd_message.get;
1059: fnd_file.put_line(FND_FILE.OUTPUT,l_msg);
1060: fnd_file.put_line(FND_FILE.OUTPUT,'*******************');
1061: end if ;
1062:
1063: EXIT WHEN c_open_po%NOTFOUND ;

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

1056: fnd_file.put_line(FND_FILE.OUTPUT,to_char(l_failed_jobs));
1057: fnd_message.set_name('WIP', 'WIP_CANCEL_JOB/SCHED_OPEN_PO');
1058: l_msg := fnd_message.get;
1059: fnd_file.put_line(FND_FILE.OUTPUT,l_msg);
1060: fnd_file.put_line(FND_FILE.OUTPUT,'*******************');
1061: end if ;
1062:
1063: EXIT WHEN c_open_po%NOTFOUND ;
1064: END LOOP ;

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

1062:
1063: EXIT WHEN c_open_po%NOTFOUND ;
1064: END LOOP ;
1065:
1066: fnd_file.put_line(FND_FILE.LOG,'Number of jobs failed in Open PO : '||to_char( l_failed_counter));
1067:
1068: IF (c_open_po%ISOPEN) THEN
1069: CLOSE c_open_po ;
1070: END IF;

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

1117: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
1118:
1119: BEGIN
1120: x_returnStatus := fnd_api.g_ret_sts_success;
1121: fnd_file.put_line(FND_FILE.LOG,'lot validate');
1122: IF (l_logLevel <= wip_constants.trace_logging) THEN
1123: l_params(1).paramName := 'p_organization_id';
1124: l_params(1).paramValue := p_organization_id ;
1125: l_params(1).paramName := 'p_group_id';

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

1194: AND wdct.wip_entity_id = wrv.wip_entity_id;
1195:
1196: BEGIN
1197: x_returnStatus := fnd_api.g_ret_sts_success;
1198: fnd_file.put_line(FND_FILE.LOG,'delete Existing reservations');
1199:
1200: IF (l_logLevel <= wip_constants.trace_logging) THEN
1201: l_params(1).paramName := 'p_organization_id';
1202: l_params(1).paramValue := p_organization_id ;

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

1344: errbuf VARCHAR2(200);
1345: retcode NUMBER ;
1346:
1347: BEGIN
1348: fnd_file.put_line(FND_FILE.LOG,'Running Reports.........');
1349:
1350: x_ReturnStatus := fnd_api.g_ret_sts_success;
1351: SORT_BY_JOB := 1 ;
1352: l_report_type := p_report_type ;

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

1355: IF ( l_precision_profile = NULL ) then
1356: l_precision_profile := 2;
1357: END IF ;
1358:
1359: fnd_file.put_line(FND_FILE.LOG,'Report Quantity Precision');
1360:
1361: SELECT COUNT(*)
1362: INTO l_std_asst_jobs
1363: FROM WIP_DJ_CLOSE_TEMP TEMP,

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

1428: IF (l_std_asst_jobs >= 1) and ( l_report_type <> 4 ) THEN
1429: /* STANDARD AND ASSET JOBS */
1430:
1431: IF (l_std_org_count = 1 ) THEN
1432: fnd_file.put_line(FND_FILE.LOG,'--------WIPRDJVR---------');
1433:
1434: l_req_id := FND_REQUEST.SUBMIT_REQUEST('WIP','WIPRDJVR',NULL,NULL,
1435: NULL,
1436: to_char(p_organization_id), -- Organziation id Parameter 1

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

1466: NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
1467: NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
1468:
1469: ELSE
1470: fnd_file.put_line(FND_FILE.LOG,'CSTRDJVA');
1471:
1472: l_req_id := FND_REQUEST.SUBMIT_REQUEST('BOM','CSTRDJVA',NULL,NULL,
1473: FALSE,
1474: NULL , -- Parameter 1

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

1511: END IF;
1512:
1513: WAIT_CONC_PROGRAM(l_req_id,ERRBUF,RETCODE);
1514:
1515: FND_FILE.PUT_LINE(FND_FILE.LOG,'Costing Report Concurrent Program return code : '||retcode);
1516:
1517: if (retcode <> -1 ) then
1518: FND_FILE.PUT_LINE(FND_FILE.LOG,'Report has errored or has a warning');
1519: errbuf := fnd_message.get;

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

1514:
1515: FND_FILE.PUT_LINE(FND_FILE.LOG,'Costing Report Concurrent Program return code : '||retcode);
1516:
1517: if (retcode <> -1 ) then
1518: FND_FILE.PUT_LINE(FND_FILE.LOG,'Report has errored or has a warning');
1519: errbuf := fnd_message.get;
1520: raise FND_API.G_EXC_ERROR ;
1521: end if;
1522:

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

1526:
1527: IF (l_expense_jobs >= 1) and ( l_report_type <> 4 ) THEN
1528:
1529: l_report_type := 1 ; -- Always detailed reports only
1530: fnd_file.put_line(FND_FILE.LOG,'WIPREJVR');
1531:
1532: l_req_id := FND_REQUEST.SUBMIT_REQUEST('WIP','WIPREJVR',NULL,NULL,
1533: FALSE,
1534: to_char(p_organization_id), -- Parameter 1

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

1563: END IF;
1564:
1565: WAIT_CONC_PROGRAM(l_req_id,ERRBUF,RETCODE);
1566:
1567: FND_FILE.PUT_LINE(FND_FILE.LOG,'Expense report reurn code : '||retcode);
1568:
1569: if (retcode <> -1 ) then
1570: FND_FILE.PUT_LINE(FND_FILE.LOG,'Report has errored or has a warning');
1571: errbuf := fnd_message.get;

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

1566:
1567: FND_FILE.PUT_LINE(FND_FILE.LOG,'Expense report reurn code : '||retcode);
1568:
1569: if (retcode <> -1 ) then
1570: FND_FILE.PUT_LINE(FND_FILE.LOG,'Report has errored or has a warning');
1571: errbuf := fnd_message.get;
1572: raise FND_API.G_EXC_ERROR ;
1573: end if;
1574:

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

1644: l_at_submission_time := 1 ; ---SRS
1645: l_immediate := 2 ; -- From Close Form
1646: x_returnStatus := FND_API.G_RET_STS_SUCCESS ;
1647:
1648: fnd_file.put_line(FND_FILE.LOG,'WIP DISCRETE JOB CLOSE');
1649:
1650: fnd_file.put_line(FND_FILE.OUTPUT,'*****************************');
1651: fnd_file.put_line(FND_FILE.OUTPUT,'WIP DISCRETE JOB CLOSE OUTPUT');
1652: fnd_file.put_line(FND_FILE.OUTPUT,'*****************************');

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

1646: x_returnStatus := FND_API.G_RET_STS_SUCCESS ;
1647:
1648: fnd_file.put_line(FND_FILE.LOG,'WIP DISCRETE JOB CLOSE');
1649:
1650: fnd_file.put_line(FND_FILE.OUTPUT,'*****************************');
1651: fnd_file.put_line(FND_FILE.OUTPUT,'WIP DISCRETE JOB CLOSE OUTPUT');
1652: fnd_file.put_line(FND_FILE.OUTPUT,'*****************************');
1653: -- write parameter value to log file
1654:

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

1647:
1648: fnd_file.put_line(FND_FILE.LOG,'WIP DISCRETE JOB CLOSE');
1649:
1650: fnd_file.put_line(FND_FILE.OUTPUT,'*****************************');
1651: fnd_file.put_line(FND_FILE.OUTPUT,'WIP DISCRETE JOB CLOSE OUTPUT');
1652: fnd_file.put_line(FND_FILE.OUTPUT,'*****************************');
1653: -- write parameter value to log file
1654:
1655: IF (l_logLevel <= wip_constants.trace_logging) THEN

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

1648: fnd_file.put_line(FND_FILE.LOG,'WIP DISCRETE JOB CLOSE');
1649:
1650: fnd_file.put_line(FND_FILE.OUTPUT,'*****************************');
1651: fnd_file.put_line(FND_FILE.OUTPUT,'WIP DISCRETE JOB CLOSE OUTPUT');
1652: fnd_file.put_line(FND_FILE.OUTPUT,'*****************************');
1653: -- write parameter value to log file
1654:
1655: IF (l_logLevel <= wip_constants.trace_logging) THEN
1656: l_params(1).paramName := 'p_organization_id';

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

1706: RAISE FND_API.G_EXC_ERROR ;
1707: END IF;
1708:
1709: if ( sysdate > l_act_close_date ) then
1710: fnd_file.put_line(FND_FILE.LOG,'WIP DISCRETE CLOSE');
1711: else
1712: fnd_message.set_name('WIP','CLOSE DATE');
1713: l_msg := fnd_message.get;
1714: l_msg := l_msg || ' ' || l_act_close_date ;

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

1715: fnd_message.set_name('WIP','WIP_LESS_OR_EQUAL');
1716: fnd_message.set_token('ENTITY1',l_msg);
1717: fnd_message.set_token('ENTITY2', sysdate);
1718: l_msg := fnd_message.get;
1719: fnd_file.put_line(FND_FILE.OUTPUT,l_msg);
1720: fnd_file.put_line(FND_FILE.OUTPUT,'*******************');
1721: fnd_file.put_line(FND_FILE.LOG,l_msg);
1722: RAISE FND_API.G_EXC_ERROR ;
1723: end if ;

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

1716: fnd_message.set_token('ENTITY1',l_msg);
1717: fnd_message.set_token('ENTITY2', sysdate);
1718: l_msg := fnd_message.get;
1719: fnd_file.put_line(FND_FILE.OUTPUT,l_msg);
1720: fnd_file.put_line(FND_FILE.OUTPUT,'*******************');
1721: fnd_file.put_line(FND_FILE.LOG,l_msg);
1722: RAISE FND_API.G_EXC_ERROR ;
1723: end if ;
1724:

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

1717: fnd_message.set_token('ENTITY2', sysdate);
1718: l_msg := fnd_message.get;
1719: fnd_file.put_line(FND_FILE.OUTPUT,l_msg);
1720: fnd_file.put_line(FND_FILE.OUTPUT,'*******************');
1721: fnd_file.put_line(FND_FILE.LOG,l_msg);
1722: RAISE FND_API.G_EXC_ERROR ;
1723: end if ;
1724:
1725: /****************************************************************

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

1740: EXCEPTION
1741: WHEN NO_DATA_FOUND THEN
1742: fnd_message.set_name('WIP','WIP_CLOSE_CLOSED_PERIOD');
1743: l_msg := fnd_message.get;
1744: fnd_file.put_line(FND_FILE.OUTPUT,l_msg);
1745: fnd_file.put_line(FND_FILE.OUTPUT,'*******************');
1746: fnd_file.put_line(FND_FILE.LOG,l_msg) ;
1747: RAISE FND_API.G_EXC_ERROR ;
1748: END ;

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

1741: WHEN NO_DATA_FOUND THEN
1742: fnd_message.set_name('WIP','WIP_CLOSE_CLOSED_PERIOD');
1743: l_msg := fnd_message.get;
1744: fnd_file.put_line(FND_FILE.OUTPUT,l_msg);
1745: fnd_file.put_line(FND_FILE.OUTPUT,'*******************');
1746: fnd_file.put_line(FND_FILE.LOG,l_msg) ;
1747: RAISE FND_API.G_EXC_ERROR ;
1748: END ;
1749:

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

1742: fnd_message.set_name('WIP','WIP_CLOSE_CLOSED_PERIOD');
1743: l_msg := fnd_message.get;
1744: fnd_file.put_line(FND_FILE.OUTPUT,l_msg);
1745: fnd_file.put_line(FND_FILE.OUTPUT,'*******************');
1746: fnd_file.put_line(FND_FILE.LOG,l_msg) ;
1747: RAISE FND_API.G_EXC_ERROR ;
1748: END ;
1749:
1750: /**********************************************************

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

1844: l_group_id := p_group_id ;
1845:
1846: END IF ;
1847:
1848: fnd_file.put_line(FND_FILE.LOG,'GROUP ID '||to_char(l_group_id));
1849:
1850: /**********************************************************
1851: * *
1852: * Checks if Job Release date <= actual close date *

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

1860:
1861: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
1862: fnd_message.set_name('WIP', 'WIP_PRIOR_DATE_RELEASE');
1863: l_msg := fnd_message.get;
1864: fnd_file.put_line(FND_FILE.OUTPUT,l_msg);
1865: fnd_file.put_line(FND_FILE.OUTPUT,'*******************');
1866: x_warning := 1 ;
1867: --
1868: -- Bug 5345660 Added profile check before invoking wip_logger

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

1861: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
1862: fnd_message.set_name('WIP', 'WIP_PRIOR_DATE_RELEASE');
1863: l_msg := fnd_message.get;
1864: fnd_file.put_line(FND_FILE.OUTPUT,l_msg);
1865: fnd_file.put_line(FND_FILE.OUTPUT,'*******************');
1866: x_warning := 1 ;
1867: --
1868: -- Bug 5345660 Added profile check before invoking wip_logger
1869: --

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

1902:
1903: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
1904: fnd_message.set_name('WIP', 'WIP_PENDING_CLOCKS');
1905: l_msg := fnd_message.get;
1906: fnd_file.put_line(FND_FILE.OUTPUT,l_msg);
1907: fnd_file.put_line(FND_FILE.OUTPUT,'*******************');
1908: x_warning := 1 ;
1909: --
1910: -- Bug 5345660 Added profile check before invoking wip_logger

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

1903: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
1904: fnd_message.set_name('WIP', 'WIP_PENDING_CLOCKS');
1905: l_msg := fnd_message.get;
1906: fnd_file.put_line(FND_FILE.OUTPUT,l_msg);
1907: fnd_file.put_line(FND_FILE.OUTPUT,'*******************');
1908: x_warning := 1 ;
1909: --
1910: -- Bug 5345660 Added profile check before invoking wip_logger
1911: --

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

1928: p_group_id => l_group_id);
1929: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
1930: fnd_message.set_name('WIP', 'TRANSACTIONS PENDING');
1931: l_msg := fnd_message.get;
1932: fnd_file.put_line(FND_FILE.OUTPUT,l_msg);
1933: fnd_file.put_line(FND_FILE.OUTPUT,'*******************');
1934: x_warning := 1 ;
1935: --
1936: -- Bug 5345660 Added profile check before invoking wip_logger

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

1929: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
1930: fnd_message.set_name('WIP', 'TRANSACTIONS PENDING');
1931: l_msg := fnd_message.get;
1932: fnd_file.put_line(FND_FILE.OUTPUT,l_msg);
1933: fnd_file.put_line(FND_FILE.OUTPUT,'*******************');
1934: x_warning := 1 ;
1935: --
1936: -- Bug 5345660 Added profile check before invoking wip_logger
1937: --

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

1955:
1956: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
1957: fnd_message.set_name('WIP', 'TRANSACTIONS PENDING');
1958: l_msg := fnd_message.get;
1959: fnd_file.put_line(FND_FILE.OUTPUT,l_msg);
1960: fnd_file.put_line(FND_FILE.OUTPUT,'*******************');
1961: x_warning := 1 ;
1962: --
1963: -- Bug 5345660 Added profile check before invoking wip_logger

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

1956: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
1957: fnd_message.set_name('WIP', 'TRANSACTIONS PENDING');
1958: l_msg := fnd_message.get;
1959: fnd_file.put_line(FND_FILE.OUTPUT,l_msg);
1960: fnd_file.put_line(FND_FILE.OUTPUT,'*******************');
1961: x_warning := 1 ;
1962: --
1963: -- Bug 5345660 Added profile check before invoking wip_logger
1964: --

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

1981:
1982: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
1983: fnd_message.set_name('WIP', 'CLOSE DATE IN PAST');
1984: l_msg := fnd_message.get;
1985: fnd_file.put_line(FND_FILE.OUTPUT,l_msg);
1986: fnd_file.put_line(FND_FILE.OUTPUT,'*******************');
1987: x_warning := 1 ;
1988: --
1989: -- Bug 5345660 Added profile check before invoking wip_logger

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

1982: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
1983: fnd_message.set_name('WIP', 'CLOSE DATE IN PAST');
1984: l_msg := fnd_message.get;
1985: fnd_file.put_line(FND_FILE.OUTPUT,l_msg);
1986: fnd_file.put_line(FND_FILE.OUTPUT,'*******************');
1987: x_warning := 1 ;
1988: --
1989: -- Bug 5345660 Added profile check before invoking wip_logger
1990: --

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

2255: /*****************************************************/
2256: /* CALLING REPORTS */
2257: /*****************************************************/
2258:
2259: fnd_file.get_names(l_msg,l_msg_data);
2260: fnd_file.put_line( FND_FILE.LOG,l_msg);
2261: fnd_file.put_line( FND_FILE.LOG,l_msg_data);
2262:
2263: Run_Reports(

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

2256: /* CALLING REPORTS */
2257: /*****************************************************/
2258:
2259: fnd_file.get_names(l_msg,l_msg_data);
2260: fnd_file.put_line( FND_FILE.LOG,l_msg);
2261: fnd_file.put_line( FND_FILE.LOG,l_msg_data);
2262:
2263: Run_Reports(
2264: x_returnstatus => l_return_status,

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

2257: /*****************************************************/
2258:
2259: fnd_file.get_names(l_msg,l_msg_data);
2260: fnd_file.put_line( FND_FILE.LOG,l_msg);
2261: fnd_file.put_line( FND_FILE.LOG,l_msg_data);
2262:
2263: Run_Reports(
2264: x_returnstatus => l_return_status,
2265: p_group_id => l_group_id ,

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

2287: FROM WIP_DJ_CLOSE_TEMP
2288: WHERE ORGANIZATION_ID = p_organization_id
2289: AND GROUP_ID = l_group_id;
2290:
2291: fnd_file.put_line( FND_FILE.LOG,'Number of jobs Closed '||to_char(l_num_close));
2292: fnd_file.put(FND_FILE.OUTPUT,to_char(l_num_close)||' ');
2293: fnd_message.set_name('WIP','WIP_NUM_CLOSED');
2294: l_msg := fnd_message.get;
2295: fnd_file.put_line(FND_FILE.OUTPUT,l_msg);

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

2288: WHERE ORGANIZATION_ID = p_organization_id
2289: AND GROUP_ID = l_group_id;
2290:
2291: fnd_file.put_line( FND_FILE.LOG,'Number of jobs Closed '||to_char(l_num_close));
2292: fnd_file.put(FND_FILE.OUTPUT,to_char(l_num_close)||' ');
2293: fnd_message.set_name('WIP','WIP_NUM_CLOSED');
2294: l_msg := fnd_message.get;
2295: fnd_file.put_line(FND_FILE.OUTPUT,l_msg);
2296: fnd_file.put_line(FND_FILE.OUTPUT,'*******************');

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

2291: fnd_file.put_line( FND_FILE.LOG,'Number of jobs Closed '||to_char(l_num_close));
2292: fnd_file.put(FND_FILE.OUTPUT,to_char(l_num_close)||' ');
2293: fnd_message.set_name('WIP','WIP_NUM_CLOSED');
2294: l_msg := fnd_message.get;
2295: fnd_file.put_line(FND_FILE.OUTPUT,l_msg);
2296: fnd_file.put_line(FND_FILE.OUTPUT,'*******************');
2297:
2298:
2299: IF ( l_num_close > 0 ) THEN

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

2292: fnd_file.put(FND_FILE.OUTPUT,to_char(l_num_close)||' ');
2293: fnd_message.set_name('WIP','WIP_NUM_CLOSED');
2294: l_msg := fnd_message.get;
2295: fnd_file.put_line(FND_FILE.OUTPUT,l_msg);
2296: fnd_file.put_line(FND_FILE.OUTPUT,'*******************');
2297:
2298:
2299: IF ( l_num_close > 0 ) THEN
2300: DELETE FROM WIP_DJ_CLOSE_TEMP

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

2317:
2318: EXCEPTION
2319: WHEN others THEN
2320: rollback ;
2321: fnd_file.put_line( FND_FILE.LOG,'Exception has occured');
2322: x_returnStatus := FND_API.G_RET_STS_ERROR ;
2323: /* Update jobs to Failed Close status */
2324:
2325: /*Bug 6908428: Update the status of eam_work_order_details to failed close and proceed workflow notification*/