[Home] [Help]
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;
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;
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;
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:
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:
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;
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;
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);
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);
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);
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);
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);
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:
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
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
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);
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
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);
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);
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:
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));
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:
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 ');
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: