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 490: FND_FILE.PUT_LINE(FND_FILE.LOG, '== START populating aging : time stamp :: '||TO_CHAR(SYSDATE, 'MM-DD-YYYY HH24:MI:SS'));

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 574: 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);

570: l_start_date := sysdate + l_days_start;
571: l_end_date := sysdate + l_days_to;
572: END IF;
573:
574: 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);
575:
576: populate_aging_dates(
577: p_bucket_id => l_bucket_lines_tbl(i).aging_bucket_id,
578: p_bucket_line_id => l_bucket_lines_tbl(i).aging_bucket_line_id,

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

582: p_days_to => l_days_to,
583: p_seq_type => l_seq_type,
584: x_return_status => l_return_status
585: );
586: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Line#'||i||' -- days_start ::' || l_bucket_lines_tbl(i).days_start);
587: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Line#'||i||' -- days_to ::' || l_bucket_lines_tbl(i).days_to);
588: FND_FILE.PUT_LINE(FND_FILE.LOG, 'return status#'||i||' ::' || l_return_status);
589:
590: IF l_return_status = FND_API.g_ret_sts_error THEN

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

583: p_seq_type => l_seq_type,
584: x_return_status => l_return_status
585: );
586: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Line#'||i||' -- days_start ::' || l_bucket_lines_tbl(i).days_start);
587: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Line#'||i||' -- days_to ::' || l_bucket_lines_tbl(i).days_to);
588: FND_FILE.PUT_LINE(FND_FILE.LOG, 'return status#'||i||' ::' || l_return_status);
589:
590: IF l_return_status = FND_API.g_ret_sts_error THEN
591: -- raise error and log message

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

584: x_return_status => l_return_status
585: );
586: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Line#'||i||' -- days_start ::' || l_bucket_lines_tbl(i).days_start);
587: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Line#'||i||' -- days_to ::' || l_bucket_lines_tbl(i).days_to);
588: FND_FILE.PUT_LINE(FND_FILE.LOG, 'return status#'||i||' ::' || l_return_status);
589:
590: IF l_return_status = FND_API.g_ret_sts_error THEN
591: -- raise error and log message
592: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

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

602: -- populate table ozf_aging_summary
603: populate_aging_summary(
604: x_return_status => l_return_status
605: );
606: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*------------------------------------------------------------------------------------------------------*');
607: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Total number of Bucket lines selected: ' || to_char(l_bucket_lines_tbl.count));
608:
609: IF l_return_status <> FND_API.g_ret_sts_success THEN
610: -- raise error and log message

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

603: populate_aging_summary(
604: x_return_status => l_return_status
605: );
606: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*------------------------------------------------------------------------------------------------------*');
607: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Total number of Bucket lines selected: ' || to_char(l_bucket_lines_tbl.count));
608:
609: IF l_return_status <> FND_API.g_ret_sts_success THEN
610: -- raise error and log message
611: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

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

614: END IF;
615: RAISE FND_API.g_exc_error;
616: END IF;
617:
618: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Execution Status: Successful' );
619: FND_FILE.PUT_LINE(FND_FILE.LOG, '== END populating aging : time stamp :: '||TO_CHAR(SYSDATE, 'MM-DD-YYYY HH24:MI:SS'));
620: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Execution Ends On: ' || to_char(sysdate,'MM-DD-YYYY HH24:MI:SS'));
621: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*------------------------------------------------------------------------------------------------------*');
622:

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

615: RAISE FND_API.g_exc_error;
616: END IF;
617:
618: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Execution Status: Successful' );
619: FND_FILE.PUT_LINE(FND_FILE.LOG, '== END populating aging : time stamp :: '||TO_CHAR(SYSDATE, 'MM-DD-YYYY HH24:MI:SS'));
620: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Execution Ends On: ' || to_char(sysdate,'MM-DD-YYYY HH24:MI:SS'));
621: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*------------------------------------------------------------------------------------------------------*');
622:
623: IF g_debug THEN

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

616: END IF;
617:
618: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Execution Status: Successful' );
619: FND_FILE.PUT_LINE(FND_FILE.LOG, '== END populating aging : time stamp :: '||TO_CHAR(SYSDATE, 'MM-DD-YYYY HH24:MI:SS'));
620: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Execution Ends On: ' || to_char(sysdate,'MM-DD-YYYY HH24:MI:SS'));
621: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*------------------------------------------------------------------------------------------------------*');
622:
623: IF g_debug THEN
624: OZF_Utility_PVT.debug_message('== END populating aging : time stamp :: '||TO_CHAR(SYSDATE, 'MM-DD-YYYY HH24:MI:SS'));

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

617:
618: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Execution Status: Successful' );
619: FND_FILE.PUT_LINE(FND_FILE.LOG, '== END populating aging : time stamp :: '||TO_CHAR(SYSDATE, 'MM-DD-YYYY HH24:MI:SS'));
620: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Execution Ends On: ' || to_char(sysdate,'MM-DD-YYYY HH24:MI:SS'));
621: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*------------------------------------------------------------------------------------------------------*');
622:
623: IF g_debug THEN
624: OZF_Utility_PVT.debug_message('== END populating aging : time stamp :: '||TO_CHAR(SYSDATE, 'MM-DD-YYYY HH24:MI:SS'));
625: END IF;

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

633: ,p_data => l_msg_data
634: );
635: */
636: OZF_UTILITY_PVT.write_conc_log;
637: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'FND_API.g_exc_error');
638: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Execution Status: Failure (Error:' || FND_MSG_PUB.get(2, FND_API.g_false)||')');
639: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Execution Ends On: ' || to_char(sysdate,'MM-DD-YYYY HH24:MI:SS'));
640: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*------------------------------------------------------------------------------------------------------*');
641:

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

634: );
635: */
636: OZF_UTILITY_PVT.write_conc_log;
637: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'FND_API.g_exc_error');
638: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Execution Status: Failure (Error:' || FND_MSG_PUB.get(2, FND_API.g_false)||')');
639: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Execution Ends On: ' || to_char(sysdate,'MM-DD-YYYY HH24:MI:SS'));
640: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*------------------------------------------------------------------------------------------------------*');
641:
642: ERRBUF := l_msg_data;

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

635: */
636: OZF_UTILITY_PVT.write_conc_log;
637: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'FND_API.g_exc_error');
638: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Execution Status: Failure (Error:' || FND_MSG_PUB.get(2, FND_API.g_false)||')');
639: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Execution Ends On: ' || to_char(sysdate,'MM-DD-YYYY HH24:MI:SS'));
640: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*------------------------------------------------------------------------------------------------------*');
641:
642: ERRBUF := l_msg_data;
643: RETCODE := 2;

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

636: OZF_UTILITY_PVT.write_conc_log;
637: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'FND_API.g_exc_error');
638: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Execution Status: Failure (Error:' || FND_MSG_PUB.get(2, FND_API.g_false)||')');
639: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Execution Ends On: ' || to_char(sysdate,'MM-DD-YYYY HH24:MI:SS'));
640: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*------------------------------------------------------------------------------------------------------*');
641:
642: ERRBUF := l_msg_data;
643: RETCODE := 2;
644: WHEN FND_API.g_exc_unexpected_error THEN

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

650: ,p_data => l_msg_data
651: );
652: */
653: OZF_UTILITY_PVT.write_conc_log;
654: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'FND_API.g_exc_unexpected_error');
655: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Execution Status: Failure (Error:' || FND_MSG_PUB.get(2, FND_API.g_false)||')');
656: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Execution Ends On: ' || to_char(sysdate,'MM-DD-YYYY HH24:MI:SS'));
657: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*------------------------------------------------------------------------------------------------------*');
658: ERRBUF := l_msg_data;

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

651: );
652: */
653: OZF_UTILITY_PVT.write_conc_log;
654: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'FND_API.g_exc_unexpected_error');
655: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Execution Status: Failure (Error:' || FND_MSG_PUB.get(2, FND_API.g_false)||')');
656: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Execution Ends On: ' || to_char(sysdate,'MM-DD-YYYY HH24:MI:SS'));
657: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*------------------------------------------------------------------------------------------------------*');
658: ERRBUF := l_msg_data;
659: RETCODE := 2;

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

652: */
653: OZF_UTILITY_PVT.write_conc_log;
654: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'FND_API.g_exc_unexpected_error');
655: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Execution Status: Failure (Error:' || FND_MSG_PUB.get(2, FND_API.g_false)||')');
656: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Execution Ends On: ' || to_char(sysdate,'MM-DD-YYYY HH24:MI:SS'));
657: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*------------------------------------------------------------------------------------------------------*');
658: ERRBUF := l_msg_data;
659: RETCODE := 2;
660: WHEN OTHERS THEN

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

653: OZF_UTILITY_PVT.write_conc_log;
654: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'FND_API.g_exc_unexpected_error');
655: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Execution Status: Failure (Error:' || FND_MSG_PUB.get(2, FND_API.g_false)||')');
656: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Execution Ends On: ' || to_char(sysdate,'MM-DD-YYYY HH24:MI:SS'));
657: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*------------------------------------------------------------------------------------------------------*');
658: ERRBUF := l_msg_data;
659: RETCODE := 2;
660: WHEN OTHERS THEN
661: ROLLBACK TO Aging_Summary;

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

659: RETCODE := 2;
660: WHEN OTHERS THEN
661: ROLLBACK TO Aging_Summary;
662: OZF_UTILITY_PVT.write_conc_log;
663: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'OTHERS exception');
664: ERRBUF := substr(sqlerrm, 1, 80);
665: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Execution Status: Failure (Error:' || ERRBUF||')');
666: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Execution Ends On: ' || to_char(sysdate,'MM-DD-YYYY HH24:MI:SS'));
667: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*------------------------------------------------------------------------------------------------------*');

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

661: ROLLBACK TO Aging_Summary;
662: OZF_UTILITY_PVT.write_conc_log;
663: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'OTHERS exception');
664: ERRBUF := substr(sqlerrm, 1, 80);
665: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Execution Status: Failure (Error:' || ERRBUF||')');
666: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Execution Ends On: ' || to_char(sysdate,'MM-DD-YYYY HH24:MI:SS'));
667: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*------------------------------------------------------------------------------------------------------*');
668: RETCODE := 2;
669: END Populate_Aging;

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

662: OZF_UTILITY_PVT.write_conc_log;
663: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'OTHERS exception');
664: ERRBUF := substr(sqlerrm, 1, 80);
665: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Execution Status: Failure (Error:' || ERRBUF||')');
666: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Execution Ends On: ' || to_char(sysdate,'MM-DD-YYYY HH24:MI:SS'));
667: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*------------------------------------------------------------------------------------------------------*');
668: RETCODE := 2;
669: END Populate_Aging;
670:

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

663: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'OTHERS exception');
664: ERRBUF := substr(sqlerrm, 1, 80);
665: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Execution Status: Failure (Error:' || ERRBUF||')');
666: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Execution Ends On: ' || to_char(sysdate,'MM-DD-YYYY HH24:MI:SS'));
667: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*------------------------------------------------------------------------------------------------------*');
668: RETCODE := 2;
669: END Populate_Aging;
670:
671: END OZF_Claim_Aging_PVT;