DBA Data[Home] [Help]

APPS.AHL_UMP_UNITMAINT_PVT dependencies on FND_FILE

Line 530: fnd_file.put_line(fnd_file.log, 'Building Unit Effectivity failed. Refer to the error message below.');

526: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
527: p_data => x_msg_data,
528: p_encoded => fnd_api.g_false);
529: IF (p_concurrent_flag = 'Y') THEN
530: fnd_file.put_line(fnd_file.log, 'Building Unit Effectivity failed. Refer to the error message below.');
531: log_error_messages;
532: END IF;
533: -- Disable debug
534: AHL_DEBUG_PUB.disable_debug;

Line 545: fnd_file.put_line(fnd_file.log, 'Building Unit Effectivity failed. Refer to the error message below.');

541: p_data => x_msg_data,
542: p_encoded => fnd_api.g_false);
543:
544: IF (p_concurrent_flag = 'Y') THEN
545: fnd_file.put_line(fnd_file.log, 'Building Unit Effectivity failed. Refer to the error message below.');
546: log_error_messages;
547: END IF;
548: -- Disable debug
549: AHL_DEBUG_PUB.disable_debug;

Line 563: fnd_file.put_line(fnd_file.log, 'Building Unit Effectivity failed. Refer to the error message below.');

559: p_data => x_msg_data,
560: p_encoded => fnd_api.g_false);
561:
562: IF (p_concurrent_flag = 'Y') THEN
563: fnd_file.put_line(fnd_file.log, 'Building Unit Effectivity failed. Refer to the error message below.');
564: log_error_messages;
565: END IF;
566:
567: -- Disable debug

Line 605: fnd_file.put_line(fnd_file.log, 'Start building Simlation Unit Effectivity for Simlation Plan ID = ' ||p_simulation_plan_id);

601: AHL_DEBUG_PUB.enable_debug;
602: END IF;
603:
604:
605: fnd_file.put_line(fnd_file.log, 'Start building Simlation Unit Effectivity for Simlation Plan ID = ' ||p_simulation_plan_id);
606:
607: -- Add debug mesg.
608: IF G_DEBUG='Y' THEN
609: AHL_DEBUG_PUB.debug('Begin private API:' || G_PKG_NAME || '.' || l_api_name);

Line 645: fnd_file.put_line(fnd_file.log, 'Completed building Simlation Unit Effectivity Sccessfully');

641: p_encoded => fnd_api.g_false
642: );
643:
644:
645: fnd_file.put_line(fnd_file.log, 'Completed building Simlation Unit Effectivity Sccessfully');
646:
647: --
648: EXCEPTION
649: WHEN FND_API.G_EXC_ERROR THEN

Line 654: fnd_file.put_line(fnd_file.log, 'Building Simlation Unit Effectivity failed. Refer to the error message below.');

650: FND_MSG_PUB.count_and_get( p_count => l_msg_count,
651: p_data => l_msg_data,
652: p_encoded => fnd_api.g_false);
653:
654: fnd_file.put_line(fnd_file.log, 'Building Simlation Unit Effectivity failed. Refer to the error message below.');
655: log_error_messages;
656:
657: -- Disable debug
658: AHL_DEBUG_PUB.disable_debug;

Line 668: fnd_file.put_line(fnd_file.log, 'Building Simlation Unit Effectivity failed. Refer to the error message below.');

664: p_data => l_msg_data,
665: p_encoded => fnd_api.g_false);
666:
667:
668: fnd_file.put_line(fnd_file.log, 'Building Simlation Unit Effectivity failed. Refer to the error message below.');
669: log_error_messages;
670:
671: -- Disable debug
672: AHL_DEBUG_PUB.disable_debug;

Line 685: fnd_file.put_line(fnd_file.log, 'Building Simlation Unit Effectivity failed. Refer to the error message below.');

681: p_data => l_msg_data,
682: p_encoded => fnd_api.g_false);
683:
684:
685: fnd_file.put_line(fnd_file.log, 'Building Simlation Unit Effectivity failed. Refer to the error message below.');
686: log_error_messages;
687:
688:
689: -- Disable debug

Line 6045: fnd_file.put_line(FND_FILE.LOG, 'Err message-'||l_msg_index_out||':' || l_msg_data);

6041: p_encoded => FND_API.G_FALSE,
6042: p_data => l_msg_data,
6043: p_msg_index_out => l_msg_index_out );
6044:
6045: fnd_file.put_line(FND_FILE.LOG, 'Err message-'||l_msg_index_out||':' || l_msg_data);
6046: IF G_DEBUG = 'Y' THEN
6047: AHL_DEBUG_PUB.Debug('Err message-'||l_msg_index_out||':' || substr(l_msg_data,1,240));
6048: END IF;
6049:

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

6122: END IF;
6123:
6124: -- perform validations -- start
6125:
6126: fnd_file.put_line(fnd_file.log, 'At the begining of the process...');
6127:
6128: FOR get_terminated_mr IN get_terminated_mrs_csr LOOP
6129:
6130: SAVEPOINT process_terminated_MRs_pvt;

Line 6132: fnd_file.put_line(fnd_file.log, 'Currently processing Terminated MR Title -> '|| get_terminated_mr.title);

6128: FOR get_terminated_mr IN get_terminated_mrs_csr LOOP
6129:
6130: SAVEPOINT process_terminated_MRs_pvt;
6131:
6132: fnd_file.put_line(fnd_file.log, 'Currently processing Terminated MR Title -> '|| get_terminated_mr.title);
6133: fnd_file.put_line(fnd_file.log, 'MR Header ID -> '|| get_terminated_mr.mr_header_id);
6134: fnd_file.put_line(fnd_file.log, 'MR Header ID -> '|| get_terminated_mr.version_number);
6135:
6136: OPEN GetNewMR_csr(get_terminated_mr.title,get_terminated_mr.version_number,

Line 6133: fnd_file.put_line(fnd_file.log, 'MR Header ID -> '|| get_terminated_mr.mr_header_id);

6129:
6130: SAVEPOINT process_terminated_MRs_pvt;
6131:
6132: fnd_file.put_line(fnd_file.log, 'Currently processing Terminated MR Title -> '|| get_terminated_mr.title);
6133: fnd_file.put_line(fnd_file.log, 'MR Header ID -> '|| get_terminated_mr.mr_header_id);
6134: fnd_file.put_line(fnd_file.log, 'MR Header ID -> '|| get_terminated_mr.version_number);
6135:
6136: OPEN GetNewMR_csr(get_terminated_mr.title,get_terminated_mr.version_number,
6137: get_terminated_mr.application_usg_code,get_terminated_mr.effective_to);

Line 6134: fnd_file.put_line(fnd_file.log, 'MR Header ID -> '|| get_terminated_mr.version_number);

6130: SAVEPOINT process_terminated_MRs_pvt;
6131:
6132: fnd_file.put_line(fnd_file.log, 'Currently processing Terminated MR Title -> '|| get_terminated_mr.title);
6133: fnd_file.put_line(fnd_file.log, 'MR Header ID -> '|| get_terminated_mr.mr_header_id);
6134: fnd_file.put_line(fnd_file.log, 'MR Header ID -> '|| get_terminated_mr.version_number);
6135:
6136: OPEN GetNewMR_csr(get_terminated_mr.title,get_terminated_mr.version_number,
6137: get_terminated_mr.application_usg_code,get_terminated_mr.effective_to);
6138: FETCH GetNewMR_csr INTO l_new_mr_rec.mr_header_id, l_new_mr_rec.version_number;

Line 6141: fnd_file.put_line(fnd_file.log, 'Next revision could not be found for -> '|| get_terminated_mr.title);

6137: get_terminated_mr.application_usg_code,get_terminated_mr.effective_to);
6138: FETCH GetNewMR_csr INTO l_new_mr_rec.mr_header_id, l_new_mr_rec.version_number;
6139: IF(GetNewMR_csr%NOTFOUND) THEN
6140: CLOSE GetNewMR_csr;
6141: fnd_file.put_line(fnd_file.log, 'Next revision could not be found for -> '|| get_terminated_mr.title);
6142: fnd_file.put_line(fnd_file.log, 'Error rolling back');
6143: retcode := 2; -- Error
6144: ROLLBACK TO process_terminated_MRs_pvt;
6145: RETURN;

Line 6142: fnd_file.put_line(fnd_file.log, 'Error rolling back');

6138: FETCH GetNewMR_csr INTO l_new_mr_rec.mr_header_id, l_new_mr_rec.version_number;
6139: IF(GetNewMR_csr%NOTFOUND) THEN
6140: CLOSE GetNewMR_csr;
6141: fnd_file.put_line(fnd_file.log, 'Next revision could not be found for -> '|| get_terminated_mr.title);
6142: fnd_file.put_line(fnd_file.log, 'Error rolling back');
6143: retcode := 2; -- Error
6144: ROLLBACK TO process_terminated_MRs_pvt;
6145: RETURN;
6146: ELSE

Line 6165: fnd_file.put_line(fnd_file.log, 'Maintenance Requirement -> '||get_terminated_mr.title||' is not processed for termination because of following error(s)');

6161: x_msg_count =>l_msg_count,
6162: x_msg_data =>l_msg_data);
6163: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
6164: -- log a warning
6165: fnd_file.put_line(fnd_file.log, 'Maintenance Requirement -> '||get_terminated_mr.title||' is not processed for termination because of following error(s)');
6166: fnd_file.put_line(fnd_file.log, '---------------------------------------------------------------------------------');
6167:
6168: LOOP
6169: l_err_msg := FND_MSG_PUB.GET;

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

6162: x_msg_data =>l_msg_data);
6163: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
6164: -- log a warning
6165: fnd_file.put_line(fnd_file.log, 'Maintenance Requirement -> '||get_terminated_mr.title||' is not processed for termination because of following error(s)');
6166: fnd_file.put_line(fnd_file.log, '---------------------------------------------------------------------------------');
6167:
6168: LOOP
6169: l_err_msg := FND_MSG_PUB.GET;
6170: IF l_err_msg IS NULL THEN

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

6169: l_err_msg := FND_MSG_PUB.GET;
6170: IF l_err_msg IS NULL THEN
6171: EXIT;
6172: END IF;
6173: fnd_file.put_line(fnd_file.log, l_err_msg);
6174: END LOOP;
6175: ROLLBACK TO process_terminated_MRs_pvt;
6176: retcode := 2; -- Error
6177: RETURN;

Line 6186: fnd_file.put_line(fnd_file.log, 'End of processing Terminated Maintenance Requirements..');

6182: END LOOP; -- end of outer for loop
6183:
6184: retcode := 0; -- success, since nothing is wrong
6185:
6186: fnd_file.put_line(fnd_file.log, 'End of processing Terminated Maintenance Requirements..');
6187:
6188: END process_terminated_MRs;
6189:
6190: END AHL_UMP_UNITMAINT_PVT;