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

Line 78: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Aging Bucket: Date Range = '|| l_bucket_date_range);

74: * bucket type = 'FUTURE' due_date >= sysdate + ABS(dyas_start)
75: * due_date <= sysdate + ABS(dyas_to)
76: *-----------------------------------------------------------*/
77: l_bucket_date_range := ABS(p_days_start - p_days_to);
78: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Aging Bucket: Date Range = '|| l_bucket_date_range);
79:
80: -- start of Bugfix 5143538
81: -- Absolute value of days must be added for past and future to support negatives
82: IF p_seq_type = 'M' OR

Line 488: FND_FILE.PUT_LINE(FND_FILE.LOG, '== START populating aging : time stamp :: '||TO_CHAR(SYSDATE, 'MM-DD-YYYY HH24:MI:SS'));

484: IF g_debug THEN
485: OZF_Utility_PVT.debug_message('== START populating aging : time stamp :: '||TO_CHAR(SYSDATE, 'MM-DD-YYYY HH24:MI:SS'));
486: END IF;
487:
488: FND_FILE.PUT_LINE(FND_FILE.LOG, '== START populating aging : time stamp :: '||TO_CHAR(SYSDATE, 'MM-DD-YYYY HH24:MI:SS'));
489: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*----------------------------------- Claim Aging Execution Report -------------------------------------*');
490: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Execution Starts On: ' || to_char(sysdate,'MM-DD-YYYY HH24:MI:SS'));
491: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*------------------------------------------------------------------------------------------------------*');
492:

Line 489: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '----------------------------------- Claim Aging Execution Report -------------------------------------');

485: OZF_Utility_PVT.debug_message('== START populating aging : time stamp :: '||TO_CHAR(SYSDATE, 'MM-DD-YYYY HH24:MI:SS'));
486: END IF;
487:
488: FND_FILE.PUT_LINE(FND_FILE.LOG, '== START populating aging : time stamp :: '||TO_CHAR(SYSDATE, 'MM-DD-YYYY HH24:MI:SS'));
489: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*----------------------------------- Claim Aging Execution Report -------------------------------------*');
490: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Execution Starts On: ' || to_char(sysdate,'MM-DD-YYYY HH24:MI:SS'));
491: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*------------------------------------------------------------------------------------------------------*');
492:
493: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Aging Bucket id = '||p_bucket_id);

Line 490: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Execution Starts On: ' || to_char(sysdate,'MM-DD-YYYY HH24:MI:SS'));

486: END IF;
487:
488: FND_FILE.PUT_LINE(FND_FILE.LOG, '== START populating aging : time stamp :: '||TO_CHAR(SYSDATE, 'MM-DD-YYYY HH24:MI:SS'));
489: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*----------------------------------- Claim Aging Execution Report -------------------------------------*');
490: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Execution Starts On: ' || to_char(sysdate,'MM-DD-YYYY HH24:MI:SS'));
491: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*------------------------------------------------------------------------------------------------------*');
492:
493: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Aging Bucket id = '||p_bucket_id);
494:

Line 491: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '------------------------------------------------------------------------------------------------------');

487:
488: FND_FILE.PUT_LINE(FND_FILE.LOG, '== START populating aging : time stamp :: '||TO_CHAR(SYSDATE, 'MM-DD-YYYY HH24:MI:SS'));
489: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*----------------------------------- Claim Aging Execution Report -------------------------------------*');
490: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Execution Starts On: ' || to_char(sysdate,'MM-DD-YYYY HH24:MI:SS'));
491: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*------------------------------------------------------------------------------------------------------*');
492:
493: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Aging Bucket id = '||p_bucket_id);
494:
495: IF p_bucket_id IS NOT NULL THEN

Line 493: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Aging Bucket id = '||p_bucket_id);

489: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*----------------------------------- Claim Aging Execution Report -------------------------------------*');
490: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Execution Starts On: ' || to_char(sysdate,'MM-DD-YYYY HH24:MI:SS'));
491: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*------------------------------------------------------------------------------------------------------*');
492:
493: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Aging Bucket id = '||p_bucket_id);
494:
495: IF p_bucket_id IS NOT NULL THEN
496: OPEN bucket_name_csr(p_bucket_id);
497: FETCH bucket_name_csr INTO l_bucket_name;

Line 501: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Aging Buket Name: ' || l_bucket_name);

497: FETCH bucket_name_csr INTO l_bucket_name;
498: CLOSE bucket_name_csr;
499: END IF;
500:
501: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Aging Buket Name: ' || l_bucket_name);
502: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*------------------------------------------------------------------------------------------------------*');
503: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Bucket Line Name Start Date End Date Bucket Line Type' );
504: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' );
505: OPEN bucket_lines_csr(p_bucket_id);

Line 502: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '------------------------------------------------------------------------------------------------------');

498: CLOSE bucket_name_csr;
499: END IF;
500:
501: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Aging Buket Name: ' || l_bucket_name);
502: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*------------------------------------------------------------------------------------------------------*');
503: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Bucket Line Name Start Date End Date Bucket Line Type' );
504: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' );
505: OPEN bucket_lines_csr(p_bucket_id);
506: LOOP

Line 503: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Bucket Line Name Start Date End Date Bucket Line Type' );

499: END IF;
500:
501: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Aging Buket Name: ' || l_bucket_name);
502: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*------------------------------------------------------------------------------------------------------*');
503: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Bucket Line Name Start Date End Date Bucket Line Type' );
504: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' );
505: OPEN bucket_lines_csr(p_bucket_id);
506: LOOP
507: FETCH bucket_lines_csr INTO l_bucket_lines_tbl(l_counter);

Line 504: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' );

500:
501: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Aging Buket Name: ' || l_bucket_name);
502: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*------------------------------------------------------------------------------------------------------*');
503: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Bucket Line Name Start Date End Date Bucket Line Type' );
504: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' );
505: OPEN bucket_lines_csr(p_bucket_id);
506: LOOP
507: FETCH bucket_lines_csr INTO l_bucket_lines_tbl(l_counter);
508: EXIT WHEN bucket_lines_csr%NOTFOUND

Line 565: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, rpad(l_bucket_lines_tbl(i).report_heading1|| ' ' ||l_bucket_lines_tbl(i).report_heading2, 46, ' ')||' '||l_start_date||' '||l_end_date||' '||l_bucket_lines_tbl(i).type);

561: l_start_date := sysdate + l_days_start;
562: l_end_date := sysdate + l_days_to;
563: END IF;
564:
565: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, rpad(l_bucket_lines_tbl(i).report_heading1|| ' ' ||l_bucket_lines_tbl(i).report_heading2, 46, ' ')||' '||l_start_date||' '||l_end_date||' '||l_bucket_lines_tbl(i).type);
566:
567: populate_aging_dates(
568: p_bucket_id => l_bucket_lines_tbl(i).aging_bucket_id,
569: p_bucket_line_id => l_bucket_lines_tbl(i).aging_bucket_line_id,

Line 577: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Line#'||i||' -- days_start ::' || l_bucket_lines_tbl(i).days_start);

573: p_days_to => l_days_to,
574: p_seq_type => l_seq_type,
575: x_return_status => l_return_status
576: );
577: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Line#'||i||' -- days_start ::' || l_bucket_lines_tbl(i).days_start);
578: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Line#'||i||' -- days_to ::' || l_bucket_lines_tbl(i).days_to);
579: FND_FILE.PUT_LINE(FND_FILE.LOG, 'return status#'||i||' ::' || l_return_status);
580:
581: IF l_return_status = FND_API.g_ret_sts_error THEN

Line 578: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Line#'||i||' -- days_to ::' || l_bucket_lines_tbl(i).days_to);

574: p_seq_type => l_seq_type,
575: x_return_status => l_return_status
576: );
577: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Line#'||i||' -- days_start ::' || l_bucket_lines_tbl(i).days_start);
578: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Line#'||i||' -- days_to ::' || l_bucket_lines_tbl(i).days_to);
579: FND_FILE.PUT_LINE(FND_FILE.LOG, 'return status#'||i||' ::' || l_return_status);
580:
581: IF l_return_status = FND_API.g_ret_sts_error THEN
582: -- raise error and log message

Line 579: FND_FILE.PUT_LINE(FND_FILE.LOG, 'return status#'||i||' ::' || l_return_status);

575: x_return_status => l_return_status
576: );
577: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Line#'||i||' -- days_start ::' || l_bucket_lines_tbl(i).days_start);
578: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Line#'||i||' -- days_to ::' || l_bucket_lines_tbl(i).days_to);
579: FND_FILE.PUT_LINE(FND_FILE.LOG, 'return status#'||i||' ::' || l_return_status);
580:
581: IF l_return_status = FND_API.g_ret_sts_error THEN
582: -- raise error and log message
583: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

Line 597: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '------------------------------------------------------------------------------------------------------');

593: -- populate table ozf_aging_summary
594: populate_aging_summary(
595: x_return_status => l_return_status
596: );
597: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*------------------------------------------------------------------------------------------------------*');
598: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Total number of Bucket lines selected: ' || to_char(l_bucket_lines_tbl.count));
599:
600: IF l_return_status <> FND_API.g_ret_sts_success THEN
601: -- raise error and log message

Line 598: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Total number of Bucket lines selected: ' || to_char(l_bucket_lines_tbl.count));

594: populate_aging_summary(
595: x_return_status => l_return_status
596: );
597: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*------------------------------------------------------------------------------------------------------*');
598: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Total number of Bucket lines selected: ' || to_char(l_bucket_lines_tbl.count));
599:
600: IF l_return_status <> FND_API.g_ret_sts_success THEN
601: -- raise error and log message
602: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

Line 609: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Execution Status: Successful' );

605: END IF;
606: RAISE FND_API.g_exc_error;
607: END IF;
608:
609: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Execution Status: Successful' );
610: FND_FILE.PUT_LINE(FND_FILE.LOG, '== END populating aging : time stamp :: '||TO_CHAR(SYSDATE, 'MM-DD-YYYY HH24:MI:SS'));
611: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Execution Ends On: ' || to_char(sysdate,'MM-DD-YYYY HH24:MI:SS'));
612: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*------------------------------------------------------------------------------------------------------*');
613:

Line 610: FND_FILE.PUT_LINE(FND_FILE.LOG, '== END populating aging : time stamp :: '||TO_CHAR(SYSDATE, 'MM-DD-YYYY HH24:MI:SS'));

606: RAISE FND_API.g_exc_error;
607: END IF;
608:
609: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Execution Status: Successful' );
610: FND_FILE.PUT_LINE(FND_FILE.LOG, '== END populating aging : time stamp :: '||TO_CHAR(SYSDATE, 'MM-DD-YYYY HH24:MI:SS'));
611: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Execution Ends On: ' || to_char(sysdate,'MM-DD-YYYY HH24:MI:SS'));
612: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*------------------------------------------------------------------------------------------------------*');
613:
614: IF g_debug THEN

Line 611: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Execution Ends On: ' || to_char(sysdate,'MM-DD-YYYY HH24:MI:SS'));

607: END IF;
608:
609: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Execution Status: Successful' );
610: FND_FILE.PUT_LINE(FND_FILE.LOG, '== END populating aging : time stamp :: '||TO_CHAR(SYSDATE, 'MM-DD-YYYY HH24:MI:SS'));
611: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Execution Ends On: ' || to_char(sysdate,'MM-DD-YYYY HH24:MI:SS'));
612: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*------------------------------------------------------------------------------------------------------*');
613:
614: IF g_debug THEN
615: OZF_Utility_PVT.debug_message('== END populating aging : time stamp :: '||TO_CHAR(SYSDATE, 'MM-DD-YYYY HH24:MI:SS'));

Line 612: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '------------------------------------------------------------------------------------------------------');

608:
609: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Execution Status: Successful' );
610: FND_FILE.PUT_LINE(FND_FILE.LOG, '== END populating aging : time stamp :: '||TO_CHAR(SYSDATE, 'MM-DD-YYYY HH24:MI:SS'));
611: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Execution Ends On: ' || to_char(sysdate,'MM-DD-YYYY HH24:MI:SS'));
612: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*------------------------------------------------------------------------------------------------------*');
613:
614: IF g_debug THEN
615: OZF_Utility_PVT.debug_message('== END populating aging : time stamp :: '||TO_CHAR(SYSDATE, 'MM-DD-YYYY HH24:MI:SS'));
616: END IF;

Line 628: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'FND_API.g_exc_error');

624: ,p_data => l_msg_data
625: );
626: */
627: OZF_UTILITY_PVT.write_conc_log;
628: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'FND_API.g_exc_error');
629: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Execution Status: Failure (Error:' || FND_MSG_PUB.get(2, FND_API.g_false)||')');
630: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Execution Ends On: ' || to_char(sysdate,'MM-DD-YYYY HH24:MI:SS'));
631: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*------------------------------------------------------------------------------------------------------*');
632:

Line 629: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Execution Status: Failure (Error:' || FND_MSG_PUB.get(2, FND_API.g_false)||')');

625: );
626: */
627: OZF_UTILITY_PVT.write_conc_log;
628: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'FND_API.g_exc_error');
629: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Execution Status: Failure (Error:' || FND_MSG_PUB.get(2, FND_API.g_false)||')');
630: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Execution Ends On: ' || to_char(sysdate,'MM-DD-YYYY HH24:MI:SS'));
631: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*------------------------------------------------------------------------------------------------------*');
632:
633: ERRBUF := l_msg_data;

Line 630: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Execution Ends On: ' || to_char(sysdate,'MM-DD-YYYY HH24:MI:SS'));

626: */
627: OZF_UTILITY_PVT.write_conc_log;
628: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'FND_API.g_exc_error');
629: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Execution Status: Failure (Error:' || FND_MSG_PUB.get(2, FND_API.g_false)||')');
630: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Execution Ends On: ' || to_char(sysdate,'MM-DD-YYYY HH24:MI:SS'));
631: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*------------------------------------------------------------------------------------------------------*');
632:
633: ERRBUF := l_msg_data;
634: RETCODE := 2;

Line 631: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '------------------------------------------------------------------------------------------------------');

627: OZF_UTILITY_PVT.write_conc_log;
628: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'FND_API.g_exc_error');
629: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Execution Status: Failure (Error:' || FND_MSG_PUB.get(2, FND_API.g_false)||')');
630: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Execution Ends On: ' || to_char(sysdate,'MM-DD-YYYY HH24:MI:SS'));
631: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*------------------------------------------------------------------------------------------------------*');
632:
633: ERRBUF := l_msg_data;
634: RETCODE := 2;
635: WHEN FND_API.g_exc_unexpected_error THEN

Line 645: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'FND_API.g_exc_unexpected_error');

641: ,p_data => l_msg_data
642: );
643: */
644: OZF_UTILITY_PVT.write_conc_log;
645: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'FND_API.g_exc_unexpected_error');
646: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Execution Status: Failure (Error:' || FND_MSG_PUB.get(2, FND_API.g_false)||')');
647: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Execution Ends On: ' || to_char(sysdate,'MM-DD-YYYY HH24:MI:SS'));
648: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*------------------------------------------------------------------------------------------------------*');
649: ERRBUF := l_msg_data;

Line 646: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Execution Status: Failure (Error:' || FND_MSG_PUB.get(2, FND_API.g_false)||')');

642: );
643: */
644: OZF_UTILITY_PVT.write_conc_log;
645: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'FND_API.g_exc_unexpected_error');
646: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Execution Status: Failure (Error:' || FND_MSG_PUB.get(2, FND_API.g_false)||')');
647: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Execution Ends On: ' || to_char(sysdate,'MM-DD-YYYY HH24:MI:SS'));
648: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*------------------------------------------------------------------------------------------------------*');
649: ERRBUF := l_msg_data;
650: RETCODE := 2;

Line 647: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Execution Ends On: ' || to_char(sysdate,'MM-DD-YYYY HH24:MI:SS'));

643: */
644: OZF_UTILITY_PVT.write_conc_log;
645: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'FND_API.g_exc_unexpected_error');
646: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Execution Status: Failure (Error:' || FND_MSG_PUB.get(2, FND_API.g_false)||')');
647: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Execution Ends On: ' || to_char(sysdate,'MM-DD-YYYY HH24:MI:SS'));
648: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*------------------------------------------------------------------------------------------------------*');
649: ERRBUF := l_msg_data;
650: RETCODE := 2;
651: WHEN OTHERS THEN

Line 648: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '------------------------------------------------------------------------------------------------------');

644: OZF_UTILITY_PVT.write_conc_log;
645: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'FND_API.g_exc_unexpected_error');
646: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Execution Status: Failure (Error:' || FND_MSG_PUB.get(2, FND_API.g_false)||')');
647: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Execution Ends On: ' || to_char(sysdate,'MM-DD-YYYY HH24:MI:SS'));
648: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*------------------------------------------------------------------------------------------------------*');
649: ERRBUF := l_msg_data;
650: RETCODE := 2;
651: WHEN OTHERS THEN
652: ROLLBACK TO Aging_Summary;

Line 654: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'OTHERS exception');

650: RETCODE := 2;
651: WHEN OTHERS THEN
652: ROLLBACK TO Aging_Summary;
653: OZF_UTILITY_PVT.write_conc_log;
654: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'OTHERS exception');
655: ERRBUF := substr(sqlerrm, 1, 80);
656: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Execution Status: Failure (Error:' || ERRBUF||')');
657: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Execution Ends On: ' || to_char(sysdate,'MM-DD-YYYY HH24:MI:SS'));
658: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*------------------------------------------------------------------------------------------------------*');

Line 656: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Execution Status: Failure (Error:' || ERRBUF||')');

652: ROLLBACK TO Aging_Summary;
653: OZF_UTILITY_PVT.write_conc_log;
654: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'OTHERS exception');
655: ERRBUF := substr(sqlerrm, 1, 80);
656: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Execution Status: Failure (Error:' || ERRBUF||')');
657: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Execution Ends On: ' || to_char(sysdate,'MM-DD-YYYY HH24:MI:SS'));
658: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*------------------------------------------------------------------------------------------------------*');
659: RETCODE := 2;
660: END Populate_Aging;

Line 657: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Execution Ends On: ' || to_char(sysdate,'MM-DD-YYYY HH24:MI:SS'));

653: OZF_UTILITY_PVT.write_conc_log;
654: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'OTHERS exception');
655: ERRBUF := substr(sqlerrm, 1, 80);
656: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Execution Status: Failure (Error:' || ERRBUF||')');
657: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Execution Ends On: ' || to_char(sysdate,'MM-DD-YYYY HH24:MI:SS'));
658: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*------------------------------------------------------------------------------------------------------*');
659: RETCODE := 2;
660: END Populate_Aging;
661:

Line 658: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '------------------------------------------------------------------------------------------------------');

654: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'OTHERS exception');
655: ERRBUF := substr(sqlerrm, 1, 80);
656: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Execution Status: Failure (Error:' || ERRBUF||')');
657: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Execution Ends On: ' || to_char(sysdate,'MM-DD-YYYY HH24:MI:SS'));
658: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*------------------------------------------------------------------------------------------------------*');
659: RETCODE := 2;
660: END Populate_Aging;
661:
662: END OZF_Claim_Aging_PVT;