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_TP_ACCRUAL_PVT dependencies on FND_FILE

Line 1767: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Please setup Profile OZF : Price Difference Budget before running Third Party Accrual.');

1763: CLOSE batch_info_csr;
1764:
1765: IF l_fund_id is null THEN
1766: ozf_utility_pvt.error_message('OZF_THRDPTY_BUDGET_ERR');
1767: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Please setup Profile OZF : Price Difference Budget before running Third Party Accrual.');
1768: RAISE FND_API.g_exc_error;
1769: END IF;
1770:
1771: -- First check whether the order result collection EXISTS or not

Line 3696: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Disputed Interface Lines After Pre-Processing:');

3692: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3693: END IF;
3694:
3695: -- [BUG 4233341 FIXING]: add output file
3696: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Disputed Interface Lines After Pre-Processing:');
3697: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' ');
3698: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Interface');
3699: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Line Id Dispute Code Error Column Name Column Value');
3700: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' --------- -------------------------------- -------------------------------- -------------------- ------------');

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

3693: END IF;
3694:
3695: -- [BUG 4233341 FIXING]: add output file
3696: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Disputed Interface Lines After Pre-Processing:');
3697: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' ');
3698: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Interface');
3699: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Line Id Dispute Code Error Column Name Column Value');
3700: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' --------- -------------------------------- -------------------------------- -------------------- ------------');
3701:

Line 3698: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Interface');

3694:
3695: -- [BUG 4233341 FIXING]: add output file
3696: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Disputed Interface Lines After Pre-Processing:');
3697: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' ');
3698: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Interface');
3699: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Line Id Dispute Code Error Column Name Column Value');
3700: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' --------- -------------------------------- -------------------------------- -------------------- ------------');
3701:
3702: --i_output_idx := 1;

Line 3699: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Line Id Dispute Code Error Column Name Column Value');

3695: -- [BUG 4233341 FIXING]: add output file
3696: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Disputed Interface Lines After Pre-Processing:');
3697: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' ');
3698: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Interface');
3699: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Line Id Dispute Code Error Column Name Column Value');
3700: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' --------- -------------------------------- -------------------------------- -------------------- ------------');
3701:
3702: --i_output_idx := 1;
3703: IF l_output_dispute_line_tbl.EXISTS(1) THEN

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

3696: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Disputed Interface Lines After Pre-Processing:');
3697: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' ');
3698: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Interface');
3699: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Line Id Dispute Code Error Column Name Column Value');
3700: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' --------- -------------------------------- -------------------------------- -------------------- ------------');
3701:
3702: --i_output_idx := 1;
3703: IF l_output_dispute_line_tbl.EXISTS(1) THEN
3704: l_output_dispute_line_tbl.DELETE;

Line 3711: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' '

3707: FETCH csr_out_dispute_pre_proc BULK COLLECT INTO l_output_dispute_line_tbl;
3708: CLOSE csr_out_dispute_pre_proc;
3709:
3710: FOR i_output_idx IN 1..l_output_dispute_line_tbl.COUNT LOOP
3711: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' '
3712: ||RPAD(l_output_dispute_line_tbl(i_output_idx).id, 10, ' ')
3713: ||RPAD(l_output_dispute_line_tbl(i_output_idx).dispute_code, 33, ' ')
3714: ||RPAD(l_output_dispute_line_tbl(i_output_idx).error_message, 34, ' ')
3715: ||RPAD(l_output_dispute_line_tbl(i_output_idx).column_name, 21, ' ')

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

3714: ||RPAD(l_output_dispute_line_tbl(i_output_idx).error_message, 34, ' ')
3715: ||RPAD(l_output_dispute_line_tbl(i_output_idx).column_name, 21, ' ')
3716: ||RPAD(l_output_dispute_line_tbl(i_output_idx).column_value, 15, ' ')
3717: );
3718: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' ');
3719: END LOOP;
3720: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' ');
3721:
3722: --AMITAMKU Bug 14685303 - Added call of this procedure to check if the duplicates of the existing lines

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

3716: ||RPAD(l_output_dispute_line_tbl(i_output_idx).column_value, 15, ' ')
3717: );
3718: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' ');
3719: END LOOP;
3720: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' ');
3721:
3722: --AMITAMKU Bug 14685303 - Added call of this procedure to check if the duplicates of the existing lines
3723: --If duplicate lines are found, then the status is updated as DUPLICATED
3724: OZF_RESALE_COMMON_PVT.Update_Duplicates (

Line 3739: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Duplicated Interface Lines After Pre-Processing:');

3735: ,x_msg_count => l_msg_count
3736: );
3737:
3738: --AMITAMKU Bug 14685303 - details of duplicate lines are printed in output file
3739: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Duplicated Interface Lines After Pre-Processing:');
3740: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' ');
3741: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Interface');
3742: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Line Id Column Name Column Value');
3743: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' --------- -------------------- ------------');

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

3736: );
3737:
3738: --AMITAMKU Bug 14685303 - details of duplicate lines are printed in output file
3739: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Duplicated Interface Lines After Pre-Processing:');
3740: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' ');
3741: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Interface');
3742: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Line Id Column Name Column Value');
3743: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' --------- -------------------- ------------');
3744:

Line 3741: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Interface');

3737:
3738: --AMITAMKU Bug 14685303 - details of duplicate lines are printed in output file
3739: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Duplicated Interface Lines After Pre-Processing:');
3740: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' ');
3741: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Interface');
3742: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Line Id Column Name Column Value');
3743: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' --------- -------------------- ------------');
3744:
3745: IF l_output_duplicate_line_tbl.EXISTS(1) THEN

Line 3742: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Line Id Column Name Column Value');

3738: --AMITAMKU Bug 14685303 - details of duplicate lines are printed in output file
3739: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Duplicated Interface Lines After Pre-Processing:');
3740: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' ');
3741: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Interface');
3742: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Line Id Column Name Column Value');
3743: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' --------- -------------------- ------------');
3744:
3745: IF l_output_duplicate_line_tbl.EXISTS(1) THEN
3746: l_output_duplicate_line_tbl.DELETE;

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

3739: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Duplicated Interface Lines After Pre-Processing:');
3740: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' ');
3741: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Interface');
3742: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Line Id Column Name Column Value');
3743: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' --------- -------------------- ------------');
3744:
3745: IF l_output_duplicate_line_tbl.EXISTS(1) THEN
3746: l_output_duplicate_line_tbl.DELETE;
3747: END IF;

Line 3754: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' '

3750: FETCH csr_out_duplicate_pre_proc BULK COLLECT INTO l_output_duplicate_line_tbl;
3751: CLOSE csr_out_duplicate_pre_proc;
3752:
3753: FOR i_output_idx IN 1..l_output_duplicate_line_tbl.COUNT LOOP
3754: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' '
3755: ||RPAD(l_output_duplicate_line_tbl(i_output_idx).id, 10, ' ')
3756: ||RPAD(l_output_duplicate_line_tbl(i_output_idx).column_name, 21, ' ')
3757: ||RPAD(l_output_duplicate_line_tbl(i_output_idx).column_value, 15, ' ')
3758: );

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

3755: ||RPAD(l_output_duplicate_line_tbl(i_output_idx).id, 10, ' ')
3756: ||RPAD(l_output_duplicate_line_tbl(i_output_idx).column_name, 21, ' ')
3757: ||RPAD(l_output_duplicate_line_tbl(i_output_idx).column_value, 15, ' ')
3758: );
3759: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' ');
3760: END LOOP;
3761: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' ');
3762:
3763: --AMITAMKU Bug 14685303 - Added check so that if the batch is rejected then no need to calculate third party accruals

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

3757: ||RPAD(l_output_duplicate_line_tbl(i_output_idx).column_value, 15, ' ')
3758: );
3759: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' ');
3760: END LOOP;
3761: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' ');
3762:
3763: --AMITAMKU Bug 14685303 - Added check so that if the batch is rejected then no need to calculate third party accruals
3764: IF l_new_batch_status = 'REJECTED' THEN
3765: RETURN;

Line 4493: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' There is no valid order to process.');

4489:
4490: IF OZF_DEBUG_LOW_ON THEN
4491: ozf_utility_PVT.debug_message(l_api_name||'>> No Order to process <<');
4492: END IF;
4493: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' There is no valid order to process.');
4494:
4495: END IF; -- IF l_order_num_tbl.EXISTS(1) THEN
4496:
4497:

Line 4499: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Disputed Lines After Processing Order:');

4495: END IF; -- IF l_order_num_tbl.EXISTS(1) THEN
4496:
4497:
4498: -- [BUG 4233341 FIXING]: add output file
4499: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Disputed Lines After Processing Order:');
4500: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' ');
4501: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Interface');
4502: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Line Id Dispute Code Error Column Name Column Value');
4503: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' --------- -------------------------------- -------------------------------- -------------------- ------------');

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

4496:
4497:
4498: -- [BUG 4233341 FIXING]: add output file
4499: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Disputed Lines After Processing Order:');
4500: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' ');
4501: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Interface');
4502: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Line Id Dispute Code Error Column Name Column Value');
4503: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' --------- -------------------------------- -------------------------------- -------------------- ------------');
4504:

Line 4501: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Interface');

4497:
4498: -- [BUG 4233341 FIXING]: add output file
4499: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Disputed Lines After Processing Order:');
4500: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' ');
4501: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Interface');
4502: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Line Id Dispute Code Error Column Name Column Value');
4503: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' --------- -------------------------------- -------------------------------- -------------------- ------------');
4504:
4505: --i_output_idx := 1;

Line 4502: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Line Id Dispute Code Error Column Name Column Value');

4498: -- [BUG 4233341 FIXING]: add output file
4499: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Disputed Lines After Processing Order:');
4500: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' ');
4501: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Interface');
4502: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Line Id Dispute Code Error Column Name Column Value');
4503: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' --------- -------------------------------- -------------------------------- -------------------- ------------');
4504:
4505: --i_output_idx := 1;
4506: IF l_output_dispute_line_tbl.EXISTS(1) THEN

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

4499: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Disputed Lines After Processing Order:');
4500: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' ');
4501: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Interface');
4502: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Line Id Dispute Code Error Column Name Column Value');
4503: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' --------- -------------------------------- -------------------------------- -------------------- ------------');
4504:
4505: --i_output_idx := 1;
4506: IF l_output_dispute_line_tbl.EXISTS(1) THEN
4507: l_output_dispute_line_tbl.DELETE;

Line 4526: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' '

4522: */
4523: CLOSE csr_out_dispute_pre_proc;
4524:
4525: FOR i_output_idx IN 1..l_output_dispute_line_tbl.COUNT LOOP
4526: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' '
4527: ||RPAD(l_output_dispute_line_tbl(i_output_idx).id, 10, ' ')
4528: ||RPAD(l_output_dispute_line_tbl(i_output_idx).dispute_code, 33, ' ')
4529: ||RPAD(l_output_dispute_line_tbl(i_output_idx).error_message, 34, ' ')
4530: ||RPAD(l_output_dispute_line_tbl(i_output_idx).column_name, 21, ' ')

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

4529: ||RPAD(l_output_dispute_line_tbl(i_output_idx).error_message, 34, ' ')
4530: ||RPAD(l_output_dispute_line_tbl(i_output_idx).column_name, 21, ' ')
4531: ||RPAD(l_output_dispute_line_tbl(i_output_idx).column_value, 15, ' ')
4532: );
4533: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' ');
4534: END LOOP;
4535: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' ');
4536:
4537:

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

4531: ||RPAD(l_output_dispute_line_tbl(i_output_idx).column_value, 15, ' ')
4532: );
4533: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' ');
4534: END LOOP;
4535: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' ');
4536:
4537:
4538: -- Bug 14194884 - TPA In Draft Mode ER : nepanda -- this if condition needs to be moved here
4539: IF l_run_mode <> 'DRAFT' THEN

Line 4564: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Batch Successfully Created and Closed:');

4560: OPEN csr_get_batch_number(p_resale_batch_id);
4561: FETCH csr_get_batch_number INTO l_batch_number;
4562: CLOSE csr_get_batch_number;
4563:
4564: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Batch Successfully Created and Closed:');
4565: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' ');
4566: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Batch Number: '||l_batch_number);
4567: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Successfully Processed: '||l_valid_line_count);
4568: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' ');

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

4561: FETCH csr_get_batch_number INTO l_batch_number;
4562: CLOSE csr_get_batch_number;
4563:
4564: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Batch Successfully Created and Closed:');
4565: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' ');
4566: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Batch Number: '||l_batch_number);
4567: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Successfully Processed: '||l_valid_line_count);
4568: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' ');
4569:

Line 4566: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Batch Number: '||l_batch_number);

4562: CLOSE csr_get_batch_number;
4563:
4564: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Batch Successfully Created and Closed:');
4565: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' ');
4566: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Batch Number: '||l_batch_number);
4567: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Successfully Processed: '||l_valid_line_count);
4568: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' ');
4569:
4570: ELSE

Line 4567: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Successfully Processed: '||l_valid_line_count);

4563:
4564: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Batch Successfully Created and Closed:');
4565: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' ');
4566: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Batch Number: '||l_batch_number);
4567: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Successfully Processed: '||l_valid_line_count);
4568: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' ');
4569:
4570: ELSE
4571: DELETE FROM ozf_resale_batches_all

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

4564: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Batch Successfully Created and Closed:');
4565: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' ');
4566: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Batch Number: '||l_batch_number);
4567: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Successfully Processed: '||l_valid_line_count);
4568: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' ');
4569:
4570: ELSE
4571: DELETE FROM ozf_resale_batches_all
4572: WHERE resale_batch_id = p_resale_batch_id;

Line 4906: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Request Id : '||G_CONC_REQUEST_ID);

4902: AND resale_id_type = 'IFACE';
4903:
4904:
4905: -- [BUG 4233341 FIXING: Add program output file]
4906: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Request Id : '||G_CONC_REQUEST_ID);
4907: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Operating Unit : '||l_org_id);
4908: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Data Source Code : '||p_data_source_code);
4909: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Run Mode : '||l_run_mode);
4910:

Line 4907: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Operating Unit : '||l_org_id);

4903:
4904:
4905: -- [BUG 4233341 FIXING: Add program output file]
4906: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Request Id : '||G_CONC_REQUEST_ID);
4907: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Operating Unit : '||l_org_id);
4908: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Data Source Code : '||p_data_source_code);
4909: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Run Mode : '||l_run_mode);
4910:
4911: -- Bug 14194884 - TPA In Draft Mode ER : Getting the Draft Run Id from the sequence. Draft Run Id will be incremented everytime TPA is run in DRAFT mode.

Line 4908: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Data Source Code : '||p_data_source_code);

4904:
4905: -- [BUG 4233341 FIXING: Add program output file]
4906: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Request Id : '||G_CONC_REQUEST_ID);
4907: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Operating Unit : '||l_org_id);
4908: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Data Source Code : '||p_data_source_code);
4909: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Run Mode : '||l_run_mode);
4910:
4911: -- Bug 14194884 - TPA In Draft Mode ER : Getting the Draft Run Id from the sequence. Draft Run Id will be incremented everytime TPA is run in DRAFT mode.
4912: IF l_run_mode = 'DRAFT' THEN

Line 4909: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Run Mode : '||l_run_mode);

4905: -- [BUG 4233341 FIXING: Add program output file]
4906: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Request Id : '||G_CONC_REQUEST_ID);
4907: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Operating Unit : '||l_org_id);
4908: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Data Source Code : '||p_data_source_code);
4909: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Run Mode : '||l_run_mode);
4910:
4911: -- Bug 14194884 - TPA In Draft Mode ER : Getting the Draft Run Id from the sequence. Draft Run Id will be incremented everytime TPA is run in DRAFT mode.
4912: IF l_run_mode = 'DRAFT' THEN
4913: SELECT OZF_DRAFT_RUN_S.nextval INTO l_draft_run_id FROM DUAL;

Line 4914: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Draft Run Id : '|| l_draft_run_id);

4910:
4911: -- Bug 14194884 - TPA In Draft Mode ER : Getting the Draft Run Id from the sequence. Draft Run Id will be incremented everytime TPA is run in DRAFT mode.
4912: IF l_run_mode = 'DRAFT' THEN
4913: SELECT OZF_DRAFT_RUN_S.nextval INTO l_draft_run_id FROM DUAL;
4914: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Draft Run Id : '|| l_draft_run_id);
4915: END IF;
4916:
4917: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*------------------------------------------------------------------------------------------------------*');
4918:

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

4913: SELECT OZF_DRAFT_RUN_S.nextval INTO l_draft_run_id FROM DUAL;
4914: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Draft Run Id : '|| l_draft_run_id);
4915: END IF;
4916:
4917: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*------------------------------------------------------------------------------------------------------*');
4918:
4919: -- list of partner_party_id based on the sold_from_cust_account_id
4920: --Add org_id, currency_code
4921: OPEN account_id_csr(G_CONC_REQUEST_ID);

Line 5068: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '* Sold From Customer: '||l_sold_from_cust_name_tbl(i));

5064: END IF;
5065:
5066: IF l_batch_tbl.EXISTS(1) THEN
5067: FOR i in 1..l_batch_tbl.LAST LOOP
5068: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '* Sold From Customer: '||l_sold_from_cust_name_tbl(i));
5069: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '* Currency Code: '||l_currency_code_tbl(i));
5070: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' ');
5071:
5072: Process_order(

Line 5069: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '* Currency Code: '||l_currency_code_tbl(i));

5065:
5066: IF l_batch_tbl.EXISTS(1) THEN
5067: FOR i in 1..l_batch_tbl.LAST LOOP
5068: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '* Sold From Customer: '||l_sold_from_cust_name_tbl(i));
5069: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '* Currency Code: '||l_currency_code_tbl(i));
5070: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' ');
5071:
5072: Process_order(
5073: p_api_version => 1

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

5066: IF l_batch_tbl.EXISTS(1) THEN
5067: FOR i in 1..l_batch_tbl.LAST LOOP
5068: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '* Sold From Customer: '||l_sold_from_cust_name_tbl(i));
5069: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '* Currency Code: '||l_currency_code_tbl(i));
5070: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' ');
5071:
5072: Process_order(
5073: p_api_version => 1
5074: ,p_init_msg_list => FND_API.G_FALSE

Line 5575: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Draft Run completed for Run Id : ' || l_draft_run_id || ' And Org Id : ' || l_org_id); -- nepanda : Fix for bug # 15900683

5571: OPEN csr_processed_lines_count;
5572: FETCH csr_processed_lines_count INTO l_processed_lines_count;
5573: CLOSE csr_processed_lines_count;
5574:
5575: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Draft Run completed for Run Id : ' || l_draft_run_id || ' And Org Id : ' || l_org_id); -- nepanda : Fix for bug # 15900683
5576: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Number Of Lines Processed : '|| l_processed_lines_count);
5577: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Please check OZF_FUNDS_UTILIZED_DRAFT_ALL, OZF_RESALE_DRAFT_LOGS_ALL and OZF_RESALE_LINES_INT_DRAFT_ALL tables for accrual details ');
5578: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' ');
5579:

Line 5576: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Number Of Lines Processed : '|| l_processed_lines_count);

5572: FETCH csr_processed_lines_count INTO l_processed_lines_count;
5573: CLOSE csr_processed_lines_count;
5574:
5575: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Draft Run completed for Run Id : ' || l_draft_run_id || ' And Org Id : ' || l_org_id); -- nepanda : Fix for bug # 15900683
5576: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Number Of Lines Processed : '|| l_processed_lines_count);
5577: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Please check OZF_FUNDS_UTILIZED_DRAFT_ALL, OZF_RESALE_DRAFT_LOGS_ALL and OZF_RESALE_LINES_INT_DRAFT_ALL tables for accrual details ');
5578: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' ');
5579:
5580: -- Fix for Bug 14584673

Line 5577: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Please check OZF_FUNDS_UTILIZED_DRAFT_ALL, OZF_RESALE_DRAFT_LOGS_ALL and OZF_RESALE_LINES_INT_DRAFT_ALL tables for accrual details ');

5573: CLOSE csr_processed_lines_count;
5574:
5575: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Draft Run completed for Run Id : ' || l_draft_run_id || ' And Org Id : ' || l_org_id); -- nepanda : Fix for bug # 15900683
5576: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Number Of Lines Processed : '|| l_processed_lines_count);
5577: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Please check OZF_FUNDS_UTILIZED_DRAFT_ALL, OZF_RESALE_DRAFT_LOGS_ALL and OZF_RESALE_LINES_INT_DRAFT_ALL tables for accrual details ');
5578: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' ');
5579:
5580: -- Fix for Bug 14584673
5581: UPDATE ozf_resale_lines_int_all

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

5574:
5575: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Draft Run completed for Run Id : ' || l_draft_run_id || ' And Org Id : ' || l_org_id); -- nepanda : Fix for bug # 15900683
5576: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Number Of Lines Processed : '|| l_processed_lines_count);
5577: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Please check OZF_FUNDS_UTILIZED_DRAFT_ALL, OZF_RESALE_DRAFT_LOGS_ALL and OZF_RESALE_LINES_INT_DRAFT_ALL tables for accrual details ');
5578: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' ');
5579:
5580: -- Fix for Bug 14584673
5581: UPDATE ozf_resale_lines_int_all
5582: SET request_id = null, resale_batch_id = null

Line 5763: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '======================================================================================================');

5759: END IF;
5760:
5761: l_run_mode := NVL(p_run_mode, 'FINAL'); -- Bug 14194884 - TPA In Draft Mode ER : Defaulting Draft Run Mode to FINAL
5762:
5763: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*======================================================================================================*');
5764: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Execution Starts On: ' || to_char(sysdate,'MM-DD-YYYY HH24:MI:SS'));
5765: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*------------------------------------------------------------------------------------------------------*');
5766: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Third Party Accrual Run Mode: ' || p_run_mode);
5767: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*------------------------------------------------------------------------------------------------------*');

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

5760:
5761: l_run_mode := NVL(p_run_mode, 'FINAL'); -- Bug 14194884 - TPA In Draft Mode ER : Defaulting Draft Run Mode to FINAL
5762:
5763: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*======================================================================================================*');
5764: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Execution Starts On: ' || to_char(sysdate,'MM-DD-YYYY HH24:MI:SS'));
5765: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*------------------------------------------------------------------------------------------------------*');
5766: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Third Party Accrual Run Mode: ' || p_run_mode);
5767: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*------------------------------------------------------------------------------------------------------*');
5768:

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

5761: l_run_mode := NVL(p_run_mode, 'FINAL'); -- Bug 14194884 - TPA In Draft Mode ER : Defaulting Draft Run Mode to FINAL
5762:
5763: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*======================================================================================================*');
5764: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Execution Starts On: ' || to_char(sysdate,'MM-DD-YYYY HH24:MI:SS'));
5765: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*------------------------------------------------------------------------------------------------------*');
5766: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Third Party Accrual Run Mode: ' || p_run_mode);
5767: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*------------------------------------------------------------------------------------------------------*');
5768:
5769:

Line 5766: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Third Party Accrual Run Mode: ' || p_run_mode);

5762:
5763: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*======================================================================================================*');
5764: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Execution Starts On: ' || to_char(sysdate,'MM-DD-YYYY HH24:MI:SS'));
5765: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*------------------------------------------------------------------------------------------------------*');
5766: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Third Party Accrual Run Mode: ' || p_run_mode);
5767: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*------------------------------------------------------------------------------------------------------*');
5768:
5769:
5770: -- Debug Message

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

5763: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*======================================================================================================*');
5764: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Execution Starts On: ' || to_char(sysdate,'MM-DD-YYYY HH24:MI:SS'));
5765: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*------------------------------------------------------------------------------------------------------*');
5766: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Third Party Accrual Run Mode: ' || p_run_mode);
5767: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*------------------------------------------------------------------------------------------------------*');
5768:
5769:
5770: -- Debug Message
5771: IF OZF_DEBUG_HIGH_ON THEN

Line 5793: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '--- Start Fetch Records for Organization id ---' || to_char(l_org_id(m)));

5789: IF (l_org_id.COUNT > 0) THEN
5790: FOR m IN l_org_id.FIRST .. l_org_id.LAST LOOP
5791: BEGIN
5792: IF OZF_DEBUG_LOW_ON THEN
5793: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '--- Start Fetch Records for Organization id ---' || to_char(l_org_id(m)));
5794: END IF;
5795: MO_GLOBAL.set_policy_context('S', l_org_id(m));
5796:
5797: -- nepanda : Fix for bug # 15900683 : end

Line 5811: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Error occurred for Organization id ---' || to_char(l_org_id(m)));

5807: ,x_msg_count => l_msg_count
5808: );
5809: IF l_return_status = FND_API.g_ret_sts_error THEN
5810: ozf_utility_pvt.error_message('OZF_PROC_RESALE_ERR');
5811: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Error occurred for Organization id ---' || to_char(l_org_id(m)));
5812: --RAISE FND_API.G_EXC_ERROR;
5813: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
5814: ozf_utility_pvt.error_message('OZF_PROC_RESALE_ERR');
5815: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Unexpected Error occurred for Organization id ---' || to_char(l_org_id(m)));

Line 5815: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Unexpected Error occurred for Organization id ---' || to_char(l_org_id(m)));

5811: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Error occurred for Organization id ---' || to_char(l_org_id(m)));
5812: --RAISE FND_API.G_EXC_ERROR;
5813: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
5814: ozf_utility_pvt.error_message('OZF_PROC_RESALE_ERR');
5815: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Unexpected Error occurred for Organization id ---' || to_char(l_org_id(m)));
5816: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5817: END IF;
5818: END;
5819: END LOOP; -- FOR m IN l_org_id.FIRST .. l_org_id.LAST LOOP

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

5891: IF OZF_DEBUG_HIGH_ON THEN
5892: OZF_UTILITY_PVT.debug_message(p_message_text => l_full_name||': End');
5893: END IF;
5894:
5895: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*------------------------------------------------------------------------------------------------------*');
5896: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Execution Ends On: ' || to_char(sysdate,'MM-DD-YYYY HH24:MI:SS'));
5897: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*======================================================================================================*');
5898:
5899: -- Write all messages to a log

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

5892: OZF_UTILITY_PVT.debug_message(p_message_text => l_full_name||': End');
5893: END IF;
5894:
5895: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*------------------------------------------------------------------------------------------------------*');
5896: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Execution Ends On: ' || to_char(sysdate,'MM-DD-YYYY HH24:MI:SS'));
5897: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*======================================================================================================*');
5898:
5899: -- Write all messages to a log
5900: OZF_UTILITY_PVT.Write_Conc_Log;

Line 5897: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '======================================================================================================');

5893: END IF;
5894:
5895: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*------------------------------------------------------------------------------------------------------*');
5896: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Execution Ends On: ' || to_char(sysdate,'MM-DD-YYYY HH24:MI:SS'));
5897: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*======================================================================================================*');
5898:
5899: -- Write all messages to a log
5900: OZF_UTILITY_PVT.Write_Conc_Log;
5901: EXCEPTION