eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AHL_COMPLETIONS_PVT dependencies on FND_FILE

Line 10561: fnd_file.put_line(fnd_file.log, 'At the begining of the process...');

10557: END IF;
10558:
10559: -- perform validations -- start
10560:
10561: fnd_file.put_line(fnd_file.log, 'At the begining of the process...');
10562:
10563: OPEN c_get_eligible_wos;
10564:
10565: --FOR l_eligible_wos IN c_get_eligible_wos

Line 10609: fnd_file.put_line(fnd_file.log, 'Total Work Orders selected for processing -> '||l_workorder_id_tbl.COUNT);

10605: EXIT;
10606:
10607: END IF;
10608:
10609: fnd_file.put_line(fnd_file.log, 'Total Work Orders selected for processing -> '||l_workorder_id_tbl.COUNT);
10610:
10611: FOR l_index IN l_workorder_id_tbl.FIRST .. l_workorder_id_tbl.LAST
10612: LOOP
10613: -- 1. validate if the Work Order Unit is locked.

Line 10632: fnd_file.put_line(fnd_file.log, 'Work Order -> '||l_workorder_name_tbl(l_index)||' is not closed due to following error(s)');

10628:
10629: l_valid_for_close_tbl(l_index) := 'N';
10630:
10631: -- log a warning
10632: fnd_file.put_line(fnd_file.log, 'Work Order -> '||l_workorder_name_tbl(l_index)||' is not closed due to following error(s)');
10633: fnd_file.put_line(fnd_file.log, FND_MSG_PUB.GET(p_encoded => FND_API.G_FALSE));
10634: FND_MSG_PUB.Delete_Msg;
10635:
10636: END IF;

Line 10633: fnd_file.put_line(fnd_file.log, FND_MSG_PUB.GET(p_encoded => FND_API.G_FALSE));

10629: l_valid_for_close_tbl(l_index) := 'N';
10630:
10631: -- log a warning
10632: fnd_file.put_line(fnd_file.log, 'Work Order -> '||l_workorder_name_tbl(l_index)||' is not closed due to following error(s)');
10633: fnd_file.put_line(fnd_file.log, FND_MSG_PUB.GET(p_encoded => FND_API.G_FALSE));
10634: FND_MSG_PUB.Delete_Msg;
10635:
10636: END IF;
10637:

Line 10653: fnd_file.put_line(fnd_file.log, 'Work Order -> '||l_workorder_name_tbl(l_index)||' is processed but with following warning(s)...');

10649:
10650: IF l_junk IS NOT NULL
10651: THEN
10652: -- No need to skip the Work Order but just log a message.
10653: fnd_file.put_line(fnd_file.log, 'Work Order -> '||l_workorder_name_tbl(l_index)||' is processed but with following warning(s)...');
10654: fnd_file.put_line(fnd_file.log, 'Work Order '||l_workorder_name_tbl(l_index)||' has material');
10655:
10656: END IF;
10657:

Line 10654: fnd_file.put_line(fnd_file.log, 'Work Order '||l_workorder_name_tbl(l_index)||' has material');

10650: IF l_junk IS NOT NULL
10651: THEN
10652: -- No need to skip the Work Order but just log a message.
10653: fnd_file.put_line(fnd_file.log, 'Work Order -> '||l_workorder_name_tbl(l_index)||' is processed but with following warning(s)...');
10654: fnd_file.put_line(fnd_file.log, 'Work Order '||l_workorder_name_tbl(l_index)||' has material');
10655:
10656: END IF;
10657:
10658: -- 3. Update the status of all materials of the Work Order to History before closing them.

Line 10679: fnd_file.put_line(fnd_file.log, 'Work Order -> '||l_workorder_name_tbl(l_index)||' is not closed due to following error(s)');

10675: IF l_return_status <> FND_API.G_RET_STS_SUCCESS
10676: THEN
10677: l_valid_for_close_tbl(l_index) := 'N';
10678: -- log a warning
10679: fnd_file.put_line(fnd_file.log, 'Work Order -> '||l_workorder_name_tbl(l_index)||' is not closed due to following error(s)');
10680: fnd_file.put_line(fnd_file.log, '---------------------------------------------------------------------------------');
10681:
10682: LOOP
10683: l_err_msg := FND_MSG_PUB.GET;

Line 10680: fnd_file.put_line(fnd_file.log, '---------------------------------------------------------------------------------');

10676: THEN
10677: l_valid_for_close_tbl(l_index) := 'N';
10678: -- log a warning
10679: fnd_file.put_line(fnd_file.log, 'Work Order -> '||l_workorder_name_tbl(l_index)||' is not closed due to following error(s)');
10680: fnd_file.put_line(fnd_file.log, '---------------------------------------------------------------------------------');
10681:
10682: LOOP
10683: l_err_msg := FND_MSG_PUB.GET;
10684: IF l_err_msg IS NULL

Line 10688: fnd_file.put_line(fnd_file.log, l_err_msg);

10684: IF l_err_msg IS NULL
10685: THEN
10686: EXIT;
10687: END IF;
10688: fnd_file.put_line(fnd_file.log, l_err_msg);
10689: END LOOP;
10690:
10691: END IF;
10692:

Line 10721: fnd_file.put_line(fnd_file.log, 'Following error(s) occured while closing Work Orders..');

10717: EXCEPTION
10718:
10719: WHEN OTHERS THEN
10720:
10721: fnd_file.put_line(fnd_file.log, 'Following error(s) occured while closing Work Orders..');
10722:
10723: FOR j IN 1..sql%bulk_exceptions.count
10724: LOOP
10725: fnd_file.put_line(fnd_file.log,

Line 10725: fnd_file.put_line(fnd_file.log,

10721: fnd_file.put_line(fnd_file.log, 'Following error(s) occured while closing Work Orders..');
10722:
10723: FOR j IN 1..sql%bulk_exceptions.count
10724: LOOP
10725: fnd_file.put_line(fnd_file.log,
10726: sql%bulk_exceptions(j).error_index || ', ' ||
10727: Sqlerrm(-sql%bulk_exceptions(j).error_code) );
10728: END LOOP;
10729:

Line 10847: fnd_file.put_line(fnd_file.log, 'Following error(s) occured while closing Work Orders..');

10843: EXCEPTION
10844:
10845: WHEN OTHERS THEN
10846:
10847: fnd_file.put_line(fnd_file.log, 'Following error(s) occured while closing Work Orders..');
10848:
10849: FOR j IN 1..sql%bulk_exceptions.count
10850: LOOP
10851: fnd_file.put_line(fnd_file.log,

Line 10851: fnd_file.put_line(fnd_file.log,

10847: fnd_file.put_line(fnd_file.log, 'Following error(s) occured while closing Work Orders..');
10848:
10849: FOR j IN 1..sql%bulk_exceptions.count
10850: LOOP
10851: fnd_file.put_line(fnd_file.log,
10852: sql%bulk_exceptions(j).error_index || ', ' ||
10853: Sqlerrm(-sql%bulk_exceptions(j).error_code) );
10854: END LOOP;
10855:

Line 10874: fnd_file.put_line(fnd_file.log, 'End of processing the close Work Orders..');

10870: -- perform validations -- end
10871:
10872: retcode := 0; -- success, since nothing is wrong
10873:
10874: fnd_file.put_line(fnd_file.log, 'End of processing the close Work Orders..');
10875:
10876: END Close_WorkOrders;
10877:
10878: --for fix of bug number 6467963