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 11388: fnd_file.put_line(fnd_file.log, 'At the begining of the process...');

11384: END IF;
11385:
11386: -- perform validations -- start
11387:
11388: fnd_file.put_line(fnd_file.log, 'At the begining of the process...');
11389:
11390: OPEN c_get_eligible_wos;
11391:
11392: --FOR l_eligible_wos IN c_get_eligible_wos

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

11432: EXIT;
11433:
11434: END IF;
11435:
11436: fnd_file.put_line(fnd_file.log, 'Total Work Orders selected for processing -> '||l_workorder_id_tbl.COUNT);
11437:
11438: FOR l_index IN l_workorder_id_tbl.FIRST .. l_workorder_id_tbl.LAST
11439: LOOP
11440: -- 1. validate if the Work Order Unit is locked.

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

11455:
11456: l_valid_for_close_tbl(l_index) := 'N';
11457:
11458: -- log a warning
11459: fnd_file.put_line(fnd_file.log, 'Work Order -> '||l_workorder_name_tbl(l_index)||' is not closed due to following error(s)');
11460: fnd_file.put_line(fnd_file.log, FND_MSG_PUB.GET(p_encoded => FND_API.G_FALSE));
11461: FND_MSG_PUB.Delete_Msg;
11462:
11463: END IF;

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

11456: l_valid_for_close_tbl(l_index) := 'N';
11457:
11458: -- log a warning
11459: fnd_file.put_line(fnd_file.log, 'Work Order -> '||l_workorder_name_tbl(l_index)||' is not closed due to following error(s)');
11460: fnd_file.put_line(fnd_file.log, FND_MSG_PUB.GET(p_encoded => FND_API.G_FALSE));
11461: FND_MSG_PUB.Delete_Msg;
11462:
11463: END IF;
11464:

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

11476:
11477: IF l_junk IS NOT NULL
11478: THEN
11479: -- No need to skip the Work Order but just log a message.
11480: fnd_file.put_line(fnd_file.log, 'Work Order -> '||l_workorder_name_tbl(l_index)||' is processed but with following warning(s)...');
11481: fnd_file.put_line(fnd_file.log, 'Work Order '||l_workorder_name_tbl(l_index)||' has material');
11482:
11483: END IF;
11484:

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

11477: IF l_junk IS NOT NULL
11478: THEN
11479: -- No need to skip the Work Order but just log a message.
11480: fnd_file.put_line(fnd_file.log, 'Work Order -> '||l_workorder_name_tbl(l_index)||' is processed but with following warning(s)...');
11481: fnd_file.put_line(fnd_file.log, 'Work Order '||l_workorder_name_tbl(l_index)||' has material');
11482:
11483: END IF;
11484:
11485: -- 3. Update the status of all materials of the Work Order to History before closing them.

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

11502: IF l_return_status <> FND_API.G_RET_STS_SUCCESS
11503: THEN
11504: l_valid_for_close_tbl(l_index) := 'N';
11505: -- log a warning
11506: fnd_file.put_line(fnd_file.log, 'Work Order -> '||l_workorder_name_tbl(l_index)||' is not closed due to following error(s)');
11507: fnd_file.put_line(fnd_file.log, '---------------------------------------------------------------------------------');
11508:
11509: LOOP
11510: l_err_msg := FND_MSG_PUB.GET;

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

11503: THEN
11504: l_valid_for_close_tbl(l_index) := 'N';
11505: -- log a warning
11506: fnd_file.put_line(fnd_file.log, 'Work Order -> '||l_workorder_name_tbl(l_index)||' is not closed due to following error(s)');
11507: fnd_file.put_line(fnd_file.log, '---------------------------------------------------------------------------------');
11508:
11509: LOOP
11510: l_err_msg := FND_MSG_PUB.GET;
11511: IF l_err_msg IS NULL

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

11511: IF l_err_msg IS NULL
11512: THEN
11513: EXIT;
11514: END IF;
11515: fnd_file.put_line(fnd_file.log, l_err_msg);
11516: END LOOP;
11517:
11518: END IF;
11519:

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

11532: IF l_return_status <> FND_API.G_RET_STS_SUCCESS
11533: THEN
11534: l_valid_for_close_tbl(l_index) := 'N';
11535: -- log a warning
11536: fnd_file.put_line(fnd_file.log, 'Work Order -> '||l_workorder_name_tbl(l_index)||' is not closed due to following error(s)');
11537: fnd_file.put_line(fnd_file.log, '---------------------------------------------------------------------------------');
11538: LOOP
11539: l_err_msg := FND_MSG_PUB.GET;
11540: IF l_err_msg IS NULL

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

11533: THEN
11534: l_valid_for_close_tbl(l_index) := 'N';
11535: -- log a warning
11536: fnd_file.put_line(fnd_file.log, 'Work Order -> '||l_workorder_name_tbl(l_index)||' is not closed due to following error(s)');
11537: fnd_file.put_line(fnd_file.log, '---------------------------------------------------------------------------------');
11538: LOOP
11539: l_err_msg := FND_MSG_PUB.GET;
11540: IF l_err_msg IS NULL
11541: THEN

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

11540: IF l_err_msg IS NULL
11541: THEN
11542: EXIT;
11543: END IF;
11544: fnd_file.put_line(fnd_file.log, l_err_msg);
11545: END LOOP;
11546: END IF;
11547: END IF;
11548: --sukhwsin::VEE Code Changes - end

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

11572: EXCEPTION
11573:
11574: WHEN OTHERS THEN
11575:
11576: fnd_file.put_line(fnd_file.log, 'Following error(s) occured while closing Work Orders..');
11577:
11578: FOR j IN 1..sql%bulk_exceptions.count
11579: LOOP
11580: fnd_file.put_line(fnd_file.log,

Line 11580: fnd_file.put_line(fnd_file.log,

11576: fnd_file.put_line(fnd_file.log, 'Following error(s) occured while closing Work Orders..');
11577:
11578: FOR j IN 1..sql%bulk_exceptions.count
11579: LOOP
11580: fnd_file.put_line(fnd_file.log,
11581: sql%bulk_exceptions(j).error_index || ', ' ||
11582: Sqlerrm(-sql%bulk_exceptions(j).error_code) );
11583: END LOOP;
11584:

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

11698: EXCEPTION
11699:
11700: WHEN OTHERS THEN
11701:
11702: fnd_file.put_line(fnd_file.log, 'Following error(s) occured while closing Work Orders..');
11703:
11704: FOR j IN 1..sql%bulk_exceptions.count
11705: LOOP
11706: fnd_file.put_line(fnd_file.log,

Line 11706: fnd_file.put_line(fnd_file.log,

11702: fnd_file.put_line(fnd_file.log, 'Following error(s) occured while closing Work Orders..');
11703:
11704: FOR j IN 1..sql%bulk_exceptions.count
11705: LOOP
11706: fnd_file.put_line(fnd_file.log,
11707: sql%bulk_exceptions(j).error_index || ', ' ||
11708: Sqlerrm(-sql%bulk_exceptions(j).error_code) );
11709: END LOOP;
11710:

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

11725: -- perform validations -- end
11726:
11727: retcode := 0; -- success, since nothing is wrong
11728:
11729: fnd_file.put_line(fnd_file.log, 'End of processing the close Work Orders..');
11730:
11731: END Close_WorkOrders;
11732:
11733: --for fix of bug number 6467963