APPS.JL_ZZ_GL_COPY_JE_PKG dependencies on FND_MESSAGE

Line 239: fnd_message.set_name('JL', 'JL_CO_FA_PARAMETER');

235: x_source_row VARCHAR2(2) :='Y';
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 );

Line 240: fnd_file.put_line( FND_FILE.LOG, fnd_message.get);

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);

Line 242: fnd_message.set_name('JL', 'JL_ZZ_GL_SOB');

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');
246: fnd_message.set_token('PERIOD_NAME', p_period);

Line 243: fnd_message.set_token('SOB', p_to_ledger );

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');
246: fnd_message.set_token('PERIOD_NAME', p_period);
247: fnd_file.put_line( 1, fnd_message.get);

Line 244: fnd_file.put_line( 1, fnd_message.get);

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, '----------------------------------------');

Line 245: fnd_message.set_name('JL', 'JL_ZZ_FA_PERIOD_NAME');

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, '----------------------------------------');
249:

Line 246: fnd_message.set_token('PERIOD_NAME', p_period);

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, '----------------------------------------');
249:
250: ---------------------------------------------------------

Line 247: fnd_file.put_line( 1, fnd_message.get);

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 --

Line 762: fnd_message.set_name('JL', 'JL_ZZ_GL_JE_PROCESSED');

758:
759: END LOOP;
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');

Line 763: fnd_message.set_token('NUMBER', x_number);

759: END LOOP;
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);

Line 764: fnd_file.put_line( 1, fnd_message.get);

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);

Line 766: fnd_message.set_name('JL', 'JL_ZZ_GL_JE_PROCESSED');

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);
769:
770: COMMIT;

Line 767: fnd_message.set_token('NUMBER', x_number);

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);
769:
770: COMMIT;
771:

Line 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

Line 798: fnd_message.set_name('JL', 'JL_ZZ_GL_DIFF_CHAT_OF_ACCT_ID');

794: END IF;
795: EXCEPTION
796: WHEN DIFF_CHART_OF_ACCT_ID THEN
797:
798: fnd_message.set_name('JL', 'JL_ZZ_GL_DIFF_CHAT_OF_ACCT_ID');
799: fnd_message.set_token('TO_BOOK', x_to_ledger.name);
800: fnd_message.set_token('FROM_BOOK', x_from_ledger.name);
801: err_msg := fnd_message.get;
802: app_exception.raise_exception (exception_type => 'APP',

Line 799: fnd_message.set_token('TO_BOOK', x_to_ledger.name);

795: EXCEPTION
796: WHEN DIFF_CHART_OF_ACCT_ID THEN
797:
798: fnd_message.set_name('JL', 'JL_ZZ_GL_DIFF_CHAT_OF_ACCT_ID');
799: fnd_message.set_token('TO_BOOK', x_to_ledger.name);
800: fnd_message.set_token('FROM_BOOK', x_from_ledger.name);
801: err_msg := fnd_message.get;
802: app_exception.raise_exception (exception_type => 'APP',
803: exception_code =>

Line 800: fnd_message.set_token('FROM_BOOK', x_from_ledger.name);

796: WHEN DIFF_CHART_OF_ACCT_ID THEN
797:
798: fnd_message.set_name('JL', 'JL_ZZ_GL_DIFF_CHAT_OF_ACCT_ID');
799: fnd_message.set_token('TO_BOOK', x_to_ledger.name);
800: fnd_message.set_token('FROM_BOOK', x_from_ledger.name);
801: err_msg := fnd_message.get;
802: app_exception.raise_exception (exception_type => 'APP',
803: exception_code =>
804: jl_zz_fa_utilities_pkg.get_app_errnum('JL', 'JL_ZZ_GL_DIFF_CHAT_OF_ACCT_ID'),

Line 801: err_msg := fnd_message.get;

797:
798: fnd_message.set_name('JL', 'JL_ZZ_GL_DIFF_CHAT_OF_ACCT_ID');
799: fnd_message.set_token('TO_BOOK', x_to_ledger.name);
800: fnd_message.set_token('FROM_BOOK', x_from_ledger.name);
801: err_msg := fnd_message.get;
802: app_exception.raise_exception (exception_type => 'APP',
803: exception_code =>
804: jl_zz_fa_utilities_pkg.get_app_errnum('JL', 'JL_ZZ_GL_DIFF_CHAT_OF_ACCT_ID'),
805: exception_text => err_msg);

Line 809: fnd_message.set_name('JL', 'JL_ZZ_GL_DIFF_CURRENCY_CODE');

805: exception_text => err_msg);
806:
807: WHEN DIFF_CURRENCY_CODE THEN
808:
809: fnd_message.set_name('JL', 'JL_ZZ_GL_DIFF_CURRENCY_CODE');
810: fnd_message.set_token('TO_BOOK', x_to_ledger.name);
811: fnd_message.set_token('FROM_BOOK', x_from_ledger.name);
812: err_msg := fnd_message.get;
813: app_exception.raise_exception (exception_type => 'APP',

Line 810: fnd_message.set_token('TO_BOOK', x_to_ledger.name);

806:
807: WHEN DIFF_CURRENCY_CODE THEN
808:
809: fnd_message.set_name('JL', 'JL_ZZ_GL_DIFF_CURRENCY_CODE');
810: fnd_message.set_token('TO_BOOK', x_to_ledger.name);
811: fnd_message.set_token('FROM_BOOK', x_from_ledger.name);
812: err_msg := fnd_message.get;
813: app_exception.raise_exception (exception_type => 'APP',
814: exception_code =>

Line 811: fnd_message.set_token('FROM_BOOK', x_from_ledger.name);

807: WHEN DIFF_CURRENCY_CODE THEN
808:
809: fnd_message.set_name('JL', 'JL_ZZ_GL_DIFF_CURRENCY_CODE');
810: fnd_message.set_token('TO_BOOK', x_to_ledger.name);
811: fnd_message.set_token('FROM_BOOK', x_from_ledger.name);
812: err_msg := fnd_message.get;
813: app_exception.raise_exception (exception_type => 'APP',
814: exception_code =>
815: jl_zz_fa_utilities_pkg.get_app_errnum('JL', 'JL_ZZ_GL_DIFF_CURRENCY_CODE'),

Line 812: err_msg := fnd_message.get;

808:
809: fnd_message.set_name('JL', 'JL_ZZ_GL_DIFF_CURRENCY_CODE');
810: fnd_message.set_token('TO_BOOK', x_to_ledger.name);
811: fnd_message.set_token('FROM_BOOK', x_from_ledger.name);
812: err_msg := fnd_message.get;
813: app_exception.raise_exception (exception_type => 'APP',
814: exception_code =>
815: jl_zz_fa_utilities_pkg.get_app_errnum('JL', 'JL_ZZ_GL_DIFF_CURRENCY_CODE'),
816: exception_text => err_msg);

Line 820: fnd_message.set_name('JL', 'JL_ZZ_GL_DIFF_CALENDAR');

816: exception_text => err_msg);
817:
818: WHEN DIFF_CALENDAR THEN
819:
820: fnd_message.set_name('JL', 'JL_ZZ_GL_DIFF_CALENDAR');
821: fnd_message.set_token('TO_BOOK', x_to_ledger.name);
822: fnd_message.set_token('FROM_BOOK', x_from_ledger.name);
823: err_msg := fnd_message.get;
824: app_exception.raise_exception (exception_type => 'APP',

Line 821: fnd_message.set_token('TO_BOOK', x_to_ledger.name);

817:
818: WHEN DIFF_CALENDAR THEN
819:
820: fnd_message.set_name('JL', 'JL_ZZ_GL_DIFF_CALENDAR');
821: fnd_message.set_token('TO_BOOK', x_to_ledger.name);
822: fnd_message.set_token('FROM_BOOK', x_from_ledger.name);
823: err_msg := fnd_message.get;
824: app_exception.raise_exception (exception_type => 'APP',
825: exception_code =>

Line 822: fnd_message.set_token('FROM_BOOK', x_from_ledger.name);

818: WHEN DIFF_CALENDAR THEN
819:
820: fnd_message.set_name('JL', 'JL_ZZ_GL_DIFF_CALENDAR');
821: fnd_message.set_token('TO_BOOK', x_to_ledger.name);
822: fnd_message.set_token('FROM_BOOK', x_from_ledger.name);
823: err_msg := fnd_message.get;
824: app_exception.raise_exception (exception_type => 'APP',
825: exception_code =>
826: jl_zz_fa_utilities_pkg.get_app_errnum('JL', 'JL_ZZ_GL_DIFF_CALENDAR'),

Line 823: err_msg := fnd_message.get;

819:
820: fnd_message.set_name('JL', 'JL_ZZ_GL_DIFF_CALENDAR');
821: fnd_message.set_token('TO_BOOK', x_to_ledger.name);
822: fnd_message.set_token('FROM_BOOK', x_from_ledger.name);
823: err_msg := fnd_message.get;
824: app_exception.raise_exception (exception_type => 'APP',
825: exception_code =>
826: jl_zz_fa_utilities_pkg.get_app_errnum('JL', 'JL_ZZ_GL_DIFF_CALENDAR'),
827: exception_text => err_msg);

Line 832: fnd_message.set_name('JL', 'JL_ZZ_GL_CANNT_RUN_JOURNAL_IMP');

828:
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:

Line 833: fnd_file.put_line(FND_FILE.LOG, fnd_message.get);

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

Line 840: fnd_message.set_name('JL', 'JL_ZZ_FA_EXEC_FAILURE');

836:
837: WHEN OTHERS THEN
838:
839: IF x_statement = 'SOB_INFO' THEN
840: fnd_message.set_name('JL', 'JL_ZZ_FA_EXEC_FAILURE');
841: fnd_message.set_token('NUMBER', '1');
842: err_msg := fnd_message.get;
843: ROLLBACK;
844: app_exception.raise_exception (exception_type => 'APP',

Line 841: fnd_message.set_token('NUMBER', '1');

837: WHEN OTHERS THEN
838:
839: IF x_statement = 'SOB_INFO' THEN
840: fnd_message.set_name('JL', 'JL_ZZ_FA_EXEC_FAILURE');
841: fnd_message.set_token('NUMBER', '1');
842: err_msg := fnd_message.get;
843: ROLLBACK;
844: app_exception.raise_exception (exception_type => 'APP',
845: exception_code =>

Line 842: err_msg := fnd_message.get;

838:
839: IF x_statement = 'SOB_INFO' THEN
840: fnd_message.set_name('JL', 'JL_ZZ_FA_EXEC_FAILURE');
841: fnd_message.set_token('NUMBER', '1');
842: err_msg := fnd_message.get;
843: ROLLBACK;
844: app_exception.raise_exception (exception_type => 'APP',
845: exception_code =>
846: jl_zz_fa_utilities_pkg.get_app_errnum('JL', 'JL_ZZ_FA_EXEC_FAILURE'),

Line 850: fnd_message.set_name('JL', 'JL_ZZ_FA_EXEC_FAILURE');

846: jl_zz_fa_utilities_pkg.get_app_errnum('JL', 'JL_ZZ_FA_EXEC_FAILURE'),
847: exception_text => err_msg);
848:
849: ELSIF x_statement = 'SEQ_INFO' THEN
850: fnd_message.set_name('JL', 'JL_ZZ_FA_EXEC_FAILURE');
851: fnd_message.set_token('NUMBER', '2');
852: err_msg := fnd_message.get;
853: ROLLBACK;
854: app_exception.raise_exception (exception_type => 'APP',

Line 851: fnd_message.set_token('NUMBER', '2');

847: exception_text => err_msg);
848:
849: ELSIF x_statement = 'SEQ_INFO' THEN
850: fnd_message.set_name('JL', 'JL_ZZ_FA_EXEC_FAILURE');
851: fnd_message.set_token('NUMBER', '2');
852: err_msg := fnd_message.get;
853: ROLLBACK;
854: app_exception.raise_exception (exception_type => 'APP',
855: exception_code =>

Line 852: err_msg := fnd_message.get;

848:
849: ELSIF x_statement = 'SEQ_INFO' THEN
850: fnd_message.set_name('JL', 'JL_ZZ_FA_EXEC_FAILURE');
851: fnd_message.set_token('NUMBER', '2');
852: err_msg := fnd_message.get;
853: ROLLBACK;
854: app_exception.raise_exception (exception_type => 'APP',
855: exception_code =>
856: jl_zz_fa_utilities_pkg.get_app_errnum('JL', 'JL_ZZ_FA_EXEC_FAILURE'),

Line 860: fnd_message.set_name('JL', 'JL_ZZ_FA_EXEC_FAILURE');

856: jl_zz_fa_utilities_pkg.get_app_errnum('JL', 'JL_ZZ_FA_EXEC_FAILURE'),
857: exception_text => err_msg);
858:
859: ELSIF x_statement = 'INS_GLIF' THEN
860: fnd_message.set_name('JL', 'JL_ZZ_FA_EXEC_FAILURE');
861: fnd_message.set_token('NUMBER', '3');
862: err_msg := fnd_message.get;
863: ROLLBACK;
864: app_exception.raise_exception (exception_type => 'APP',

Line 861: fnd_message.set_token('NUMBER', '3');

857: exception_text => err_msg);
858:
859: ELSIF x_statement = 'INS_GLIF' THEN
860: fnd_message.set_name('JL', 'JL_ZZ_FA_EXEC_FAILURE');
861: fnd_message.set_token('NUMBER', '3');
862: err_msg := fnd_message.get;
863: ROLLBACK;
864: app_exception.raise_exception (exception_type => 'APP',
865: exception_code =>

Line 862: err_msg := fnd_message.get;

858:
859: ELSIF x_statement = 'INS_GLIF' THEN
860: fnd_message.set_name('JL', 'JL_ZZ_FA_EXEC_FAILURE');
861: fnd_message.set_token('NUMBER', '3');
862: err_msg := fnd_message.get;
863: ROLLBACK;
864: app_exception.raise_exception (exception_type => 'APP',
865: exception_code =>
866: jl_zz_fa_utilities_pkg.get_app_errnum('JL', 'JL_ZZ_FA_EXEC_FAILURE'),

Line 870: fnd_message.set_name('JL', 'JL_CO_FA_GENERAL_ERROR');

866: jl_zz_fa_utilities_pkg.get_app_errnum('JL', 'JL_ZZ_FA_EXEC_FAILURE'),
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;

Line 871: fnd_file.put_line( fnd_file.log, fnd_message.get);

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);