DBA Data[Home] [Help]

APPS.INV_3PL_BILLING_UNITS_PVT dependencies on FND_FILE

Line 364: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Error => '||x_msg_data);

360: , p_transaction_date => sel_eligible_rec.creation_date
361: );
362: IF x_return_status <> fnd_api.g_ret_sts_success THEN
363: x_msg_data := fnd_message.get;
364: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Error => '||x_msg_data);
365: IF g_debug = 1 THEN
366: debug('Error from update_locator_capacity - '||x_msg_data);
367: END IF;
368: l_success := FALSE;

Line 416: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Error => '||x_msg_data);

412: , p_transaction_date => sel_new_rec.creation_date
413: );
414: IF x_return_status <> fnd_api.g_ret_sts_success THEN
415: x_msg_data := fnd_message.get;
416: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Error => '||x_msg_data);
417:
418: IF g_debug = 1 THEN
419: debug('Error from update_locator_capacity - '||x_msg_data);
420: END IF;

Line 457: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Error => '||x_msg_data);

453: , p_transaction_date => sel_new_rec.creation_date
454: );
455: IF x_return_status <> fnd_api.g_ret_sts_success THEN
456: x_msg_data := fnd_message.get;
457: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Error => '||x_msg_data);
458:
459: IF g_debug = 1 THEN
460: debug('Error from update_locator_capacity - '||x_msg_data);
461: END IF;

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

487: END IF;
488: OKC_CONTEXT.set_okc_org_context( p_OU_id, NULL);
489: END IF;
490:
491: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' ');
492: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '--------------------------------------------------------------------------------------------------------------------');
493: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Output Summary ');
494: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '--------------------------------------------------------------------------------------------------------------------');
495:

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

488: OKC_CONTEXT.set_okc_org_context( p_OU_id, NULL);
489: END IF;
490:
491: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' ');
492: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '--------------------------------------------------------------------------------------------------------------------');
493: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Output Summary ');
494: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '--------------------------------------------------------------------------------------------------------------------');
495:
496:

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

489: END IF;
490:
491: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' ');
492: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '--------------------------------------------------------------------------------------------------------------------');
493: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Output Summary ');
494: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '--------------------------------------------------------------------------------------------------------------------');
495:
496:
497: l_success := TRUE;

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

490:
491: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' ');
492: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '--------------------------------------------------------------------------------------------------------------------');
493: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Output Summary ');
494: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '--------------------------------------------------------------------------------------------------------------------');
495:
496:
497: l_success := TRUE;
498: d_sql_stmt := NULL;

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

830: l_progress := 80;
831:
832: if l_printed_in_outfile = 'N' THEN
833: IF NOT (l_success) THEN
834: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '--------------------------------------------------------------------------------------------------------------------');
835: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Could not update counter reading for the following combination ');
836: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '--------------------------------------------------------------------------------------------------------------------');
837: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Client id : '|| v_client_id);
838: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Client number : '|| v_client_number);

Line 835: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Could not update counter reading for the following combination ');

831:
832: if l_printed_in_outfile = 'N' THEN
833: IF NOT (l_success) THEN
834: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '--------------------------------------------------------------------------------------------------------------------');
835: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Could not update counter reading for the following combination ');
836: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '--------------------------------------------------------------------------------------------------------------------');
837: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Client id : '|| v_client_id);
838: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Client number : '|| v_client_number);
839: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Client name : '|| v_client_name);

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

832: if l_printed_in_outfile = 'N' THEN
833: IF NOT (l_success) THEN
834: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '--------------------------------------------------------------------------------------------------------------------');
835: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Could not update counter reading for the following combination ');
836: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '--------------------------------------------------------------------------------------------------------------------');
837: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Client id : '|| v_client_id);
838: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Client number : '|| v_client_number);
839: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Client name : '|| v_client_name);
840: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Contract id : '|| v_contract_id);

Line 837: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Client id : '|| v_client_id);

833: IF NOT (l_success) THEN
834: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '--------------------------------------------------------------------------------------------------------------------');
835: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Could not update counter reading for the following combination ');
836: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '--------------------------------------------------------------------------------------------------------------------');
837: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Client id : '|| v_client_id);
838: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Client number : '|| v_client_number);
839: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Client name : '|| v_client_name);
840: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Contract id : '|| v_contract_id);
841: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Contract number : '|| v_contract_number);

Line 838: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Client number : '|| v_client_number);

834: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '--------------------------------------------------------------------------------------------------------------------');
835: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Could not update counter reading for the following combination ');
836: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '--------------------------------------------------------------------------------------------------------------------');
837: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Client id : '|| v_client_id);
838: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Client number : '|| v_client_number);
839: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Client name : '|| v_client_name);
840: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Contract id : '|| v_contract_id);
841: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Contract number : '|| v_contract_number);
842: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Billing source name : '|| v_billing_source_name);

Line 839: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Client name : '|| v_client_name);

835: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Could not update counter reading for the following combination ');
836: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '--------------------------------------------------------------------------------------------------------------------');
837: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Client id : '|| v_client_id);
838: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Client number : '|| v_client_number);
839: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Client name : '|| v_client_name);
840: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Contract id : '|| v_contract_id);
841: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Contract number : '|| v_contract_number);
842: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Billing source name : '|| v_billing_source_name);
843:

Line 840: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Contract id : '|| v_contract_id);

836: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '--------------------------------------------------------------------------------------------------------------------');
837: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Client id : '|| v_client_id);
838: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Client number : '|| v_client_number);
839: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Client name : '|| v_client_name);
840: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Contract id : '|| v_contract_id);
841: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Contract number : '|| v_contract_number);
842: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Billing source name : '|| v_billing_source_name);
843:
844: IF (l_plsql_blk_failed = 'Y') AND

Line 841: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Contract number : '|| v_contract_number);

837: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Client id : '|| v_client_id);
838: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Client number : '|| v_client_number);
839: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Client name : '|| v_client_name);
840: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Contract id : '|| v_contract_id);
841: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Contract number : '|| v_contract_number);
842: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Billing source name : '|| v_billing_source_name);
843:
844: IF (l_plsql_blk_failed = 'Y') AND
845: (x_return_status <> fnd_api.g_ret_sts_success) THEN

Line 842: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Billing source name : '|| v_billing_source_name);

838: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Client number : '|| v_client_number);
839: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Client name : '|| v_client_name);
840: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Contract id : '|| v_contract_id);
841: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Contract number : '|| v_contract_number);
842: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Billing source name : '|| v_billing_source_name);
843:
844: IF (l_plsql_blk_failed = 'Y') AND
845: (x_return_status <> fnd_api.g_ret_sts_success) THEN
846: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Error from custom/seeded source => '||l_plsql_msg_data);

Line 846: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Error from custom/seeded source => '||l_plsql_msg_data);

842: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Billing source name : '|| v_billing_source_name);
843:
844: IF (l_plsql_blk_failed = 'Y') AND
845: (x_return_status <> fnd_api.g_ret_sts_success) THEN
846: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Error from custom/seeded source => '||l_plsql_msg_data);
847: END IF;
848: l_printed_in_outfile := 'Y';
849:
850: IF g_debug = 1 THEN

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

887:
888: l_ret := FND_CONCURRENT.SET_COMPLETION_STATUS('NORMAL',ERRBUF);
889: END IF;
890:
891: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' ');
892: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '--------------------------------------------------------------------------------------------------------------------');
893: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' SUMMARY OF PROCESSING ');
894: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '--------------------------------------------------------------------------------------------------------------------');
895: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Total Records processed -> '|| l_rec_processed);

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

888: l_ret := FND_CONCURRENT.SET_COMPLETION_STATUS('NORMAL',ERRBUF);
889: END IF;
890:
891: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' ');
892: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '--------------------------------------------------------------------------------------------------------------------');
893: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' SUMMARY OF PROCESSING ');
894: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '--------------------------------------------------------------------------------------------------------------------');
895: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Total Records processed -> '|| l_rec_processed);
896: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Number of records failed -> '|| l_rec_failed);

Line 893: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' SUMMARY OF PROCESSING ');

889: END IF;
890:
891: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' ');
892: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '--------------------------------------------------------------------------------------------------------------------');
893: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' SUMMARY OF PROCESSING ');
894: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '--------------------------------------------------------------------------------------------------------------------');
895: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Total Records processed -> '|| l_rec_processed);
896: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Number of records failed -> '|| l_rec_failed);
897:

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

890:
891: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' ');
892: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '--------------------------------------------------------------------------------------------------------------------');
893: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' SUMMARY OF PROCESSING ');
894: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '--------------------------------------------------------------------------------------------------------------------');
895: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Total Records processed -> '|| l_rec_processed);
896: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Number of records failed -> '|| l_rec_failed);
897:
898: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Number of records processed successfully -> '|| to_char(l_rec_processed - l_rec_failed));

Line 895: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Total Records processed -> '|| l_rec_processed);

891: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' ');
892: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '--------------------------------------------------------------------------------------------------------------------');
893: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' SUMMARY OF PROCESSING ');
894: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '--------------------------------------------------------------------------------------------------------------------');
895: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Total Records processed -> '|| l_rec_processed);
896: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Number of records failed -> '|| l_rec_failed);
897:
898: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Number of records processed successfully -> '|| to_char(l_rec_processed - l_rec_failed));
899:

Line 896: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Number of records failed -> '|| l_rec_failed);

892: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '--------------------------------------------------------------------------------------------------------------------');
893: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' SUMMARY OF PROCESSING ');
894: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '--------------------------------------------------------------------------------------------------------------------');
895: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Total Records processed -> '|| l_rec_processed);
896: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Number of records failed -> '|| l_rec_failed);
897:
898: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Number of records processed successfully -> '|| to_char(l_rec_processed - l_rec_failed));
899:
900: debug(l_progress ||' : Completed Execution ');

Line 898: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Number of records processed successfully -> '|| to_char(l_rec_processed - l_rec_failed));

894: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '--------------------------------------------------------------------------------------------------------------------');
895: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Total Records processed -> '|| l_rec_processed);
896: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Number of records failed -> '|| l_rec_failed);
897:
898: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Number of records processed successfully -> '|| to_char(l_rec_processed - l_rec_failed));
899:
900: debug(l_progress ||' : Completed Execution ');
901: RETURN;
902: