DBA Data[Home] [Help]

APPS.OZF_TP_ACCRUAL_PVT dependencies on FND_FILE

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

1374: CLOSE batch_info_csr;
1375:
1376: IF l_fund_id is null THEN
1377: ozf_utility_pvt.error_message('OZF_THRDPTY_BUDGET_ERR');
1378: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Please setup Profile OZF : Price Difference Budget before running Third Party Accrual.');
1379: RAISE FND_API.g_exc_error;
1380: END IF;
1381:
1382: -- First check whether the order result collection EXISTS or not

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

3058: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3059: END IF;
3060:
3061: -- [BUG 4233341 FIXING]: add output file
3062: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Disputed Interface Lines After Pre-Processing:');
3063: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' ');
3064: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Interface');
3065: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Line Id Dispute Code Error Column Name Column Value');
3066: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' --------- -------------------------------- -------------------------------- -------------------- ------------');

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

3059: END IF;
3060:
3061: -- [BUG 4233341 FIXING]: add output file
3062: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Disputed Interface Lines After Pre-Processing:');
3063: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' ');
3064: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Interface');
3065: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Line Id Dispute Code Error Column Name Column Value');
3066: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' --------- -------------------------------- -------------------------------- -------------------- ------------');
3067:

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

3060:
3061: -- [BUG 4233341 FIXING]: add output file
3062: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Disputed Interface Lines After Pre-Processing:');
3063: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' ');
3064: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Interface');
3065: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Line Id Dispute Code Error Column Name Column Value');
3066: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' --------- -------------------------------- -------------------------------- -------------------- ------------');
3067:
3068: --i_output_idx := 1;

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

3061: -- [BUG 4233341 FIXING]: add output file
3062: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Disputed Interface Lines After Pre-Processing:');
3063: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' ');
3064: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Interface');
3065: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Line Id Dispute Code Error Column Name Column Value');
3066: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' --------- -------------------------------- -------------------------------- -------------------- ------------');
3067:
3068: --i_output_idx := 1;
3069: IF l_output_dispute_line_tbl.EXISTS(1) THEN

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

3062: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Disputed Interface Lines After Pre-Processing:');
3063: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' ');
3064: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Interface');
3065: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Line Id Dispute Code Error Column Name Column Value');
3066: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' --------- -------------------------------- -------------------------------- -------------------- ------------');
3067:
3068: --i_output_idx := 1;
3069: IF l_output_dispute_line_tbl.EXISTS(1) THEN
3070: l_output_dispute_line_tbl.DELETE;

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

3085: */
3086: CLOSE csr_out_dispute_pre_proc;
3087:
3088: FOR i_output_idx IN 1..l_output_dispute_line_tbl.COUNT LOOP
3089: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' '
3090: ||RPAD(l_output_dispute_line_tbl(i_output_idx).id, 10, ' ')
3091: ||RPAD(l_output_dispute_line_tbl(i_output_idx).dispute_code, 33, ' ')
3092: ||RPAD(l_output_dispute_line_tbl(i_output_idx).error_message, 34, ' ')
3093: ||RPAD(l_output_dispute_line_tbl(i_output_idx).column_name, 21, ' ')

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

3092: ||RPAD(l_output_dispute_line_tbl(i_output_idx).error_message, 34, ' ')
3093: ||RPAD(l_output_dispute_line_tbl(i_output_idx).column_name, 21, ' ')
3094: ||RPAD(l_output_dispute_line_tbl(i_output_idx).column_value, 15, ' ')
3095: );
3096: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' ');
3097: END LOOP;
3098: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' ');
3099:
3100: -- remove all the disputed lines

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

3094: ||RPAD(l_output_dispute_line_tbl(i_output_idx).column_value, 15, ' ')
3095: );
3096: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' ');
3097: END LOOP;
3098: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' ');
3099:
3100: -- remove all the disputed lines
3101: UPDATE ozf_resale_lines_int
3102: SET resale_batch_id = null

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

3649:
3650: IF OZF_DEBUG_LOW_ON THEN
3651: ozf_utility_PVT.debug_message(l_api_name||'>> No Order to process <<');
3652: END IF;
3653: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' There is no valid order to process.');
3654:
3655: END IF; -- IF l_order_num_tbl.EXISTS(1) THEN
3656:
3657:

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

3655: END IF; -- IF l_order_num_tbl.EXISTS(1) THEN
3656:
3657:
3658: -- [BUG 4233341 FIXING]: add output file
3659: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Disputed Lines After Processing Order:');
3660: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' ');
3661: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Interface');
3662: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Line Id Dispute Code Error Column Name Column Value');
3663: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' --------- -------------------------------- -------------------------------- -------------------- ------------');

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

3656:
3657:
3658: -- [BUG 4233341 FIXING]: add output file
3659: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Disputed Lines After Processing Order:');
3660: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' ');
3661: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Interface');
3662: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Line Id Dispute Code Error Column Name Column Value');
3663: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' --------- -------------------------------- -------------------------------- -------------------- ------------');
3664:

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

3657:
3658: -- [BUG 4233341 FIXING]: add output file
3659: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Disputed Lines After Processing Order:');
3660: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' ');
3661: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Interface');
3662: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Line Id Dispute Code Error Column Name Column Value');
3663: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' --------- -------------------------------- -------------------------------- -------------------- ------------');
3664:
3665: --i_output_idx := 1;

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

3658: -- [BUG 4233341 FIXING]: add output file
3659: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Disputed Lines After Processing Order:');
3660: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' ');
3661: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Interface');
3662: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Line Id Dispute Code Error Column Name Column Value');
3663: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' --------- -------------------------------- -------------------------------- -------------------- ------------');
3664:
3665: --i_output_idx := 1;
3666: IF l_output_dispute_line_tbl.EXISTS(1) THEN

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

3659: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Disputed Lines After Processing Order:');
3660: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' ');
3661: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Interface');
3662: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Line Id Dispute Code Error Column Name Column Value');
3663: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' --------- -------------------------------- -------------------------------- -------------------- ------------');
3664:
3665: --i_output_idx := 1;
3666: IF l_output_dispute_line_tbl.EXISTS(1) THEN
3667: l_output_dispute_line_tbl.DELETE;

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

3682: */
3683: CLOSE csr_out_dispute_pre_proc;
3684:
3685: FOR i_output_idx IN 1..l_output_dispute_line_tbl.COUNT LOOP
3686: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' '
3687: ||RPAD(l_output_dispute_line_tbl(i_output_idx).id, 10, ' ')
3688: ||RPAD(l_output_dispute_line_tbl(i_output_idx).dispute_code, 33, ' ')
3689: ||RPAD(l_output_dispute_line_tbl(i_output_idx).error_message, 34, ' ')
3690: ||RPAD(l_output_dispute_line_tbl(i_output_idx).column_name, 21, ' ')

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

3689: ||RPAD(l_output_dispute_line_tbl(i_output_idx).error_message, 34, ' ')
3690: ||RPAD(l_output_dispute_line_tbl(i_output_idx).column_name, 21, ' ')
3691: ||RPAD(l_output_dispute_line_tbl(i_output_idx).column_value, 15, ' ')
3692: );
3693: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' ');
3694: END LOOP;
3695: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' ');
3696:
3697: -- [BEGIN OF BUG 4233341 FIXING]

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

3691: ||RPAD(l_output_dispute_line_tbl(i_output_idx).column_value, 15, ' ')
3692: );
3693: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' ');
3694: END LOOP;
3695: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' ');
3696:
3697: -- [BEGIN OF BUG 4233341 FIXING]
3698: -- delink all the new/processed/disputed lines
3699: UPDATE ozf_resale_lines_int_all

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

3716: OPEN csr_get_batch_number(p_resale_batch_id);
3717: FETCH csr_get_batch_number INTO l_batch_number;
3718: CLOSE csr_get_batch_number;
3719:
3720: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Batch Successfully Created and Closed:');
3721: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' ');
3722: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Batch Number: '||l_batch_number);
3723: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Successfully Processed: '||l_valid_line_count);
3724: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' ');

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

3717: FETCH csr_get_batch_number INTO l_batch_number;
3718: CLOSE csr_get_batch_number;
3719:
3720: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Batch Successfully Created and Closed:');
3721: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' ');
3722: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Batch Number: '||l_batch_number);
3723: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Successfully Processed: '||l_valid_line_count);
3724: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' ');
3725:

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

3718: CLOSE csr_get_batch_number;
3719:
3720: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Batch Successfully Created and Closed:');
3721: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' ');
3722: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Batch Number: '||l_batch_number);
3723: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Successfully Processed: '||l_valid_line_count);
3724: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' ');
3725:
3726: ELSE

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

3719:
3720: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Batch Successfully Created and Closed:');
3721: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' ');
3722: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Batch Number: '||l_batch_number);
3723: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Successfully Processed: '||l_valid_line_count);
3724: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' ');
3725:
3726: ELSE
3727: DELETE FROM ozf_resale_batches_all

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

3720: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Batch Successfully Created and Closed:');
3721: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' ');
3722: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Batch Number: '||l_batch_number);
3723: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Successfully Processed: '||l_valid_line_count);
3724: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' ');
3725:
3726: ELSE
3727: DELETE FROM ozf_resale_batches_all
3728: WHERE resale_batch_id = p_resale_batch_id;

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

3989: WHERE request_id = G_CONC_REQUEST_ID)
3990: AND resale_id_type = 'IFACE';
3991:
3992: -- [BUG 4233341 FIXING: Add program output file]
3993: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Request Id : '||G_CONC_REQUEST_ID);
3994: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Data Source Code : '||p_data_source_code);
3995: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*------------------------------------------------------------------------------------------------------*');
3996:
3997: -- list of partner_party_id based on the sold_from_cust_account_id

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

3990: AND resale_id_type = 'IFACE';
3991:
3992: -- [BUG 4233341 FIXING: Add program output file]
3993: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Request Id : '||G_CONC_REQUEST_ID);
3994: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Data Source Code : '||p_data_source_code);
3995: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*------------------------------------------------------------------------------------------------------*');
3996:
3997: -- list of partner_party_id based on the sold_from_cust_account_id
3998: --Add org_id, currency_code

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

3991:
3992: -- [BUG 4233341 FIXING: Add program output file]
3993: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Request Id : '||G_CONC_REQUEST_ID);
3994: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Data Source Code : '||p_data_source_code);
3995: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*------------------------------------------------------------------------------------------------------*');
3996:
3997: -- list of partner_party_id based on the sold_from_cust_account_id
3998: --Add org_id, currency_code
3999: OPEN account_id_csr(G_CONC_REQUEST_ID);

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

4129: END IF;
4130:
4131: IF l_batch_tbl.EXISTS(1) THEN
4132: FOR i in 1..l_batch_tbl.LAST LOOP
4133: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '* Sold From Customer: '||l_sold_from_cust_name_tbl(i));
4134: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '* Currency Code: '||l_currency_code_tbl(i));
4135: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' ');
4136:
4137: Process_order(

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

4130:
4131: IF l_batch_tbl.EXISTS(1) THEN
4132: FOR i in 1..l_batch_tbl.LAST LOOP
4133: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '* Sold From Customer: '||l_sold_from_cust_name_tbl(i));
4134: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '* Currency Code: '||l_currency_code_tbl(i));
4135: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' ');
4136:
4137: Process_order(
4138: p_api_version => 1

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

4131: IF l_batch_tbl.EXISTS(1) THEN
4132: FOR i in 1..l_batch_tbl.LAST LOOP
4133: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '* Sold From Customer: '||l_sold_from_cust_name_tbl(i));
4134: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '* Currency Code: '||l_currency_code_tbl(i));
4135: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' ');
4136:
4137: Process_order(
4138: p_api_version => 1
4139: ,p_init_msg_list => FND_API.G_FALSE

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

4221:
4222: SAVEPOINT START_TP_ACCRUAL;
4223: RETCODE := 0;
4224:
4225: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*======================================================================================================*');
4226: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Execution Starts On: ' || to_char(sysdate,'MM-DD-YYYY HH24:MI:SS'));
4227: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*------------------------------------------------------------------------------------------------------*');
4228: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'MO_GLOBAL.GET_CURRENT_ORG_ID: ' || MO_GLOBAL.GET_CURRENT_ORG_ID());
4229: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*------------------------------------------------------------------------------------------------------*');

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

4222: SAVEPOINT START_TP_ACCRUAL;
4223: RETCODE := 0;
4224:
4225: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*======================================================================================================*');
4226: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Execution Starts On: ' || to_char(sysdate,'MM-DD-YYYY HH24:MI:SS'));
4227: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*------------------------------------------------------------------------------------------------------*');
4228: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'MO_GLOBAL.GET_CURRENT_ORG_ID: ' || MO_GLOBAL.GET_CURRENT_ORG_ID());
4229: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*------------------------------------------------------------------------------------------------------*');
4230:

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

4223: RETCODE := 0;
4224:
4225: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*======================================================================================================*');
4226: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Execution Starts On: ' || to_char(sysdate,'MM-DD-YYYY HH24:MI:SS'));
4227: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*------------------------------------------------------------------------------------------------------*');
4228: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'MO_GLOBAL.GET_CURRENT_ORG_ID: ' || MO_GLOBAL.GET_CURRENT_ORG_ID());
4229: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*------------------------------------------------------------------------------------------------------*');
4230:
4231:

Line 4228: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'MO_GLOBAL.GET_CURRENT_ORG_ID: ' || MO_GLOBAL.GET_CURRENT_ORG_ID());

4224:
4225: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*======================================================================================================*');
4226: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Execution Starts On: ' || to_char(sysdate,'MM-DD-YYYY HH24:MI:SS'));
4227: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*------------------------------------------------------------------------------------------------------*');
4228: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'MO_GLOBAL.GET_CURRENT_ORG_ID: ' || MO_GLOBAL.GET_CURRENT_ORG_ID());
4229: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*------------------------------------------------------------------------------------------------------*');
4230:
4231:
4232: -- Debug Message

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

4225: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*======================================================================================================*');
4226: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Execution Starts On: ' || to_char(sysdate,'MM-DD-YYYY HH24:MI:SS'));
4227: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*------------------------------------------------------------------------------------------------------*');
4228: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'MO_GLOBAL.GET_CURRENT_ORG_ID: ' || MO_GLOBAL.GET_CURRENT_ORG_ID());
4229: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*------------------------------------------------------------------------------------------------------*');
4230:
4231:
4232: -- Debug Message
4233: IF OZF_DEBUG_HIGH_ON THEN

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

4256: IF OZF_DEBUG_HIGH_ON THEN
4257: OZF_UTILITY_PVT.debug_message(p_message_text => l_full_name||': End');
4258: END IF;
4259:
4260: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*------------------------------------------------------------------------------------------------------*');
4261: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Execution Ends On: ' || to_char(sysdate,'MM-DD-YYYY HH24:MI:SS'));
4262: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*======================================================================================================*');
4263:
4264: -- Write all messages to a log

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

4257: OZF_UTILITY_PVT.debug_message(p_message_text => l_full_name||': End');
4258: END IF;
4259:
4260: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*------------------------------------------------------------------------------------------------------*');
4261: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Execution Ends On: ' || to_char(sysdate,'MM-DD-YYYY HH24:MI:SS'));
4262: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*======================================================================================================*');
4263:
4264: -- Write all messages to a log
4265: OZF_UTILITY_PVT.Write_Conc_Log;

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

4258: END IF;
4259:
4260: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*------------------------------------------------------------------------------------------------------*');
4261: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Execution Ends On: ' || to_char(sysdate,'MM-DD-YYYY HH24:MI:SS'));
4262: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*======================================================================================================*');
4263:
4264: -- Write all messages to a log
4265: OZF_UTILITY_PVT.Write_Conc_Log;
4266: EXCEPTION