236:
237: BEGIN
238:
239: fnd_message.set_name('JL', 'JL_CO_FA_PARAMETER');
240: fnd_file.put_line( FND_FILE.LOG, fnd_message.get);
241: fnd_file.put_line(FND_FILE.LOG, '----------------------------------------');
242: fnd_message.set_name('JL', 'JL_ZZ_GL_SOB');
243: fnd_message.set_token('SOB', p_to_ledger );
244: fnd_file.put_line( 1, fnd_message.get);
237: BEGIN
238:
239: fnd_message.set_name('JL', 'JL_CO_FA_PARAMETER');
240: fnd_file.put_line( FND_FILE.LOG, fnd_message.get);
241: fnd_file.put_line(FND_FILE.LOG, '----------------------------------------');
242: fnd_message.set_name('JL', 'JL_ZZ_GL_SOB');
243: fnd_message.set_token('SOB', p_to_ledger );
244: fnd_file.put_line( 1, fnd_message.get);
245: fnd_message.set_name('JL', 'JL_ZZ_FA_PERIOD_NAME');
240: fnd_file.put_line( FND_FILE.LOG, fnd_message.get);
241: fnd_file.put_line(FND_FILE.LOG, '----------------------------------------');
242: fnd_message.set_name('JL', 'JL_ZZ_GL_SOB');
243: fnd_message.set_token('SOB', p_to_ledger );
244: fnd_file.put_line( 1, fnd_message.get);
245: fnd_message.set_name('JL', 'JL_ZZ_FA_PERIOD_NAME');
246: fnd_message.set_token('PERIOD_NAME', p_period);
247: fnd_file.put_line( 1, fnd_message.get);
248: fnd_file.put_line(FND_FILE.LOG, '----------------------------------------');
243: fnd_message.set_token('SOB', p_to_ledger );
244: fnd_file.put_line( 1, fnd_message.get);
245: fnd_message.set_name('JL', 'JL_ZZ_FA_PERIOD_NAME');
246: fnd_message.set_token('PERIOD_NAME', p_period);
247: fnd_file.put_line( 1, fnd_message.get);
248: fnd_file.put_line(FND_FILE.LOG, '----------------------------------------');
249:
250: ---------------------------------------------------------
251: -- Find who columns --
244: fnd_file.put_line( 1, fnd_message.get);
245: fnd_message.set_name('JL', 'JL_ZZ_FA_PERIOD_NAME');
246: fnd_message.set_token('PERIOD_NAME', p_period);
247: fnd_file.put_line( 1, fnd_message.get);
248: fnd_file.put_line(FND_FILE.LOG, '----------------------------------------');
249:
250: ---------------------------------------------------------
251: -- Find who columns --
252: ---------------------------------------------------------
760:
761: END LOOP;
762: fnd_message.set_name('JL', 'JL_ZZ_GL_JE_PROCESSED');
763: fnd_message.set_token('NUMBER', x_number);
764: fnd_file.put_line( 1, fnd_message.get);
765:
766: fnd_message.set_name('JL', 'JL_ZZ_GL_JE_PROCESSED');
767: fnd_message.set_token('NUMBER', x_number);
768: fnd_file.put_line( FND_FILE.OUTPUT, fnd_message.get);
764: fnd_file.put_line( 1, fnd_message.get);
765:
766: fnd_message.set_name('JL', 'JL_ZZ_GL_JE_PROCESSED');
767: fnd_message.set_token('NUMBER', x_number);
768: fnd_file.put_line( FND_FILE.OUTPUT, fnd_message.get);
769:
770: COMMIT;
771:
772: IF (p_import = 'Y' AND x_counter_sum <> 0) THEN
829: WHEN UNABLE_TO_IMPORT THEN
830:
831: ROLLBACK;
832: fnd_message.set_name('JL', 'JL_ZZ_GL_CANNT_RUN_JOURNAL_IMP');
833: fnd_file.put_line(FND_FILE.LOG, fnd_message.get);
834: x_result := fnd_concurrent.set_completion_status( status => 'WARNING',
835: message => '');
836:
837: WHEN OTHERS THEN
867: exception_text => err_msg);
868:
869: ELSE
870: fnd_message.set_name('JL', 'JL_CO_FA_GENERAL_ERROR');
871: fnd_file.put_line( fnd_file.log, fnd_message.get);
872: err_num := SQLCODE;
873: err_msg := substr(SQLERRM, 1, 200);
874: ROLLBACK;
875: RAISE_APPLICATION_ERROR( err_num, err_msg);
902: x_program_id := fnd_global.conc_program_id;
903: x_sysdate := SYSDATE;
904:
905: IF x_debug THEN
906: fnd_file.put_line( 1, 'last_update_login:'||to_char(x_last_update_login));
907: fnd_file.put_line( 1, 'last_updated_by:'||to_char(x_last_updated_by));
908: fnd_file.put_line( 1, 'last_request_id:'||to_char(x_request_id));
909: fnd_file.put_line( 1, 'x_program_application_id :'||to_char(x_program_application_id ));
910: fnd_file.put_line( 1, 'x_program_id :'||to_char(x_program_id ));
903: x_sysdate := SYSDATE;
904:
905: IF x_debug THEN
906: fnd_file.put_line( 1, 'last_update_login:'||to_char(x_last_update_login));
907: fnd_file.put_line( 1, 'last_updated_by:'||to_char(x_last_updated_by));
908: fnd_file.put_line( 1, 'last_request_id:'||to_char(x_request_id));
909: fnd_file.put_line( 1, 'x_program_application_id :'||to_char(x_program_application_id ));
910: fnd_file.put_line( 1, 'x_program_id :'||to_char(x_program_id ));
911: fnd_file.put_line( 1, 'x_sysdate :'||to_char(x_sysdate ));
904:
905: IF x_debug THEN
906: fnd_file.put_line( 1, 'last_update_login:'||to_char(x_last_update_login));
907: fnd_file.put_line( 1, 'last_updated_by:'||to_char(x_last_updated_by));
908: fnd_file.put_line( 1, 'last_request_id:'||to_char(x_request_id));
909: fnd_file.put_line( 1, 'x_program_application_id :'||to_char(x_program_application_id ));
910: fnd_file.put_line( 1, 'x_program_id :'||to_char(x_program_id ));
911: fnd_file.put_line( 1, 'x_sysdate :'||to_char(x_sysdate ));
912:
905: IF x_debug THEN
906: fnd_file.put_line( 1, 'last_update_login:'||to_char(x_last_update_login));
907: fnd_file.put_line( 1, 'last_updated_by:'||to_char(x_last_updated_by));
908: fnd_file.put_line( 1, 'last_request_id:'||to_char(x_request_id));
909: fnd_file.put_line( 1, 'x_program_application_id :'||to_char(x_program_application_id ));
910: fnd_file.put_line( 1, 'x_program_id :'||to_char(x_program_id ));
911: fnd_file.put_line( 1, 'x_sysdate :'||to_char(x_sysdate ));
912:
913: END IF;
906: fnd_file.put_line( 1, 'last_update_login:'||to_char(x_last_update_login));
907: fnd_file.put_line( 1, 'last_updated_by:'||to_char(x_last_updated_by));
908: fnd_file.put_line( 1, 'last_request_id:'||to_char(x_request_id));
909: fnd_file.put_line( 1, 'x_program_application_id :'||to_char(x_program_application_id ));
910: fnd_file.put_line( 1, 'x_program_id :'||to_char(x_program_id ));
911: fnd_file.put_line( 1, 'x_sysdate :'||to_char(x_sysdate ));
912:
913: END IF;
914:
907: fnd_file.put_line( 1, 'last_updated_by:'||to_char(x_last_updated_by));
908: fnd_file.put_line( 1, 'last_request_id:'||to_char(x_request_id));
909: fnd_file.put_line( 1, 'x_program_application_id :'||to_char(x_program_application_id ));
910: fnd_file.put_line( 1, 'x_program_id :'||to_char(x_program_id ));
911: fnd_file.put_line( 1, 'x_sysdate :'||to_char(x_sysdate ));
912:
913: END IF;
914:
915: END find_who_columns;