eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JL_CO_GL_MG_MEDIA_PKG dependencies on FND_MESSAGE

Line 100: fnd_message.set_name('JL', 'JL_CO_GL_MG_INVALID_PATH');

96: EXCEPTION
97:
98: WHEN UTL_FILE.INVALID_PATH THEN
99:
100: fnd_message.set_name('JL', 'JL_CO_GL_MG_INVALID_PATH');
101: x_error_text := SUBSTR(fnd_message.get, 1, 100);
102: app_exception.raise_exception (exception_type => 'APP',
103: exception_code =>
104: jl_zz_fa_utilities_pkg.get_app_errnum('JL', 'JL_CO_GL_MG_INVALID_PATH'),

Line 101: x_error_text := SUBSTR(fnd_message.get, 1, 100);

97:
98: WHEN UTL_FILE.INVALID_PATH THEN
99:
100: fnd_message.set_name('JL', 'JL_CO_GL_MG_INVALID_PATH');
101: x_error_text := SUBSTR(fnd_message.get, 1, 100);
102: app_exception.raise_exception (exception_type => 'APP',
103: exception_code =>
104: jl_zz_fa_utilities_pkg.get_app_errnum('JL', 'JL_CO_GL_MG_INVALID_PATH'),
105: exception_text => x_error_text);

Line 109: fnd_message.set_name('JL', 'JL_CO_GL_MG_INVALID_MODE');

105: exception_text => x_error_text);
106:
107: WHEN UTL_FILE.INVALID_MODE THEN
108:
109: fnd_message.set_name('JL', 'JL_CO_GL_MG_INVALID_MODE');
110: x_error_text := SUBSTR(fnd_message.get, 1, 100);
111: app_exception.raise_exception (exception_type => 'APP',
112: exception_code =>
113: jl_zz_fa_utilities_pkg.get_app_errnum('JL', 'JL_CO_GL_MG_INVALID_MODE'),

Line 110: x_error_text := SUBSTR(fnd_message.get, 1, 100);

106:
107: WHEN UTL_FILE.INVALID_MODE THEN
108:
109: fnd_message.set_name('JL', 'JL_CO_GL_MG_INVALID_MODE');
110: x_error_text := SUBSTR(fnd_message.get, 1, 100);
111: app_exception.raise_exception (exception_type => 'APP',
112: exception_code =>
113: jl_zz_fa_utilities_pkg.get_app_errnum('JL', 'JL_CO_GL_MG_INVALID_MODE'),
114: exception_text => x_error_text);

Line 118: fnd_message.set_name('JL', 'JL_CO_GL_MG_WRITE_ERROR');

114: exception_text => x_error_text);
115:
116: WHEN UTL_FILE.WRITE_ERROR THEN
117:
118: fnd_message.set_name('JL', 'JL_CO_GL_MG_WRITE_ERROR');
119: x_error_text := SUBSTR(fnd_message.get, 1, 100);
120: app_exception.raise_exception (exception_type => 'APP',
121: exception_code =>
122: jl_zz_fa_utilities_pkg.get_app_errnum('JL', 'JL_CO_GL_MG_WRITE_ERROR'),

Line 119: x_error_text := SUBSTR(fnd_message.get, 1, 100);

115:
116: WHEN UTL_FILE.WRITE_ERROR THEN
117:
118: fnd_message.set_name('JL', 'JL_CO_GL_MG_WRITE_ERROR');
119: x_error_text := SUBSTR(fnd_message.get, 1, 100);
120: app_exception.raise_exception (exception_type => 'APP',
121: exception_code =>
122: jl_zz_fa_utilities_pkg.get_app_errnum('JL', 'JL_CO_GL_MG_WRITE_ERROR'),
123: exception_text => x_error_text);

Line 127: fnd_message.set_name('JL', 'JL_CO_GL_MG_INVALID_FILEHANDLE');

123: exception_text => x_error_text);
124:
125: WHEN UTL_FILE.INVALID_FILEHANDLE THEN
126:
127: fnd_message.set_name('JL', 'JL_CO_GL_MG_INVALID_FILEHANDLE');
128: x_error_text := SUBSTR(fnd_message.get, 1, 100);
129: app_exception.raise_exception (exception_type => 'APP',
130: exception_code =>
131: jl_zz_fa_utilities_pkg.get_app_errnum('JL', 'JL_CO_GL_MG_INVALID_FILEHANDLE'),

Line 128: x_error_text := SUBSTR(fnd_message.get, 1, 100);

124:
125: WHEN UTL_FILE.INVALID_FILEHANDLE THEN
126:
127: fnd_message.set_name('JL', 'JL_CO_GL_MG_INVALID_FILEHANDLE');
128: x_error_text := SUBSTR(fnd_message.get, 1, 100);
129: app_exception.raise_exception (exception_type => 'APP',
130: exception_code =>
131: jl_zz_fa_utilities_pkg.get_app_errnum('JL', 'JL_CO_GL_MG_INVALID_FILEHANDLE'),
132: exception_text => x_error_text);

Line 136: fnd_message.set_name('JL', 'JL_CO_GL_MG_INVALID_OPERATION');

132: exception_text => x_error_text);
133:
134: WHEN UTL_FILE.INVALID_OPERATION THEN
135:
136: fnd_message.set_name('JL', 'JL_CO_GL_MG_INVALID_OPERATION');
137: x_error_text := SUBSTR(fnd_message.get, 1, 100);
138: app_exception.raise_exception (exception_type => 'APP',
139: exception_code =>
140: jl_zz_fa_utilities_pkg.get_app_errnum('JL', 'JL_CO_GL_MG_INVALID_OPERATION'),

Line 137: x_error_text := SUBSTR(fnd_message.get, 1, 100);

133:
134: WHEN UTL_FILE.INVALID_OPERATION THEN
135:
136: fnd_message.set_name('JL', 'JL_CO_GL_MG_INVALID_OPERATION');
137: x_error_text := SUBSTR(fnd_message.get, 1, 100);
138: app_exception.raise_exception (exception_type => 'APP',
139: exception_code =>
140: jl_zz_fa_utilities_pkg.get_app_errnum('JL', 'JL_CO_GL_MG_INVALID_OPERATION'),
141: exception_text => x_error_text);

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

141: exception_text => x_error_text);
142:
143: WHEN OTHERS THEN
144:
145: fnd_message.set_name('JL', 'JL_CO_FA_GENERAL_ERROR');
146: x_error_text := SUBSTR(fnd_message.get, 1, 100);
147: ROLLBACK;
148: app_exception.raise_exception (exception_type => 'APP',
149: exception_code =>

Line 146: x_error_text := SUBSTR(fnd_message.get, 1, 100);

142:
143: WHEN OTHERS THEN
144:
145: fnd_message.set_name('JL', 'JL_CO_FA_GENERAL_ERROR');
146: x_error_text := SUBSTR(fnd_message.get, 1, 100);
147: ROLLBACK;
148: app_exception.raise_exception (exception_type => 'APP',
149: exception_code =>
150: jl_zz_fa_utilities_pkg.get_app_errnum('JL', 'JL_CO_FA_GENERAL_ERROR'),

Line 185: fnd_message.set_name('AR', 'GENERIC_MESSAGE');

181: EXCEPTION
182:
183: WHEN NO_DATA_FOUND THEN
184:
185: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
186: fnd_message.set_token('GENERIC_TEXT',
187: 'Exception "NO_DATA_FOUND" for selection of nit information from JL_CO_GL_NITS table');
188: x_error_text := SUBSTR(fnd_message.get, 1, 100);
189: app_exception.raise_exception (exception_type => 'APP',

Line 186: fnd_message.set_token('GENERIC_TEXT',

182:
183: WHEN NO_DATA_FOUND THEN
184:
185: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
186: fnd_message.set_token('GENERIC_TEXT',
187: 'Exception "NO_DATA_FOUND" for selection of nit information from JL_CO_GL_NITS table');
188: x_error_text := SUBSTR(fnd_message.get, 1, 100);
189: app_exception.raise_exception (exception_type => 'APP',
190: exception_code =>

Line 188: x_error_text := SUBSTR(fnd_message.get, 1, 100);

184:
185: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
186: fnd_message.set_token('GENERIC_TEXT',
187: 'Exception "NO_DATA_FOUND" for selection of nit information from JL_CO_GL_NITS table');
188: x_error_text := SUBSTR(fnd_message.get, 1, 100);
189: app_exception.raise_exception (exception_type => 'APP',
190: exception_code =>
191: jl_zz_fa_utilities_pkg.get_app_errnum('AR', 'GENERIC_MESSAGE'),
192: exception_text => x_error_text);

Line 196: fnd_message.set_name('AR', 'GENERIC_MESSAGE');

192: exception_text => x_error_text);
193:
194: WHEN OTHERS THEN
195:
196: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
197: fnd_message.set_token('GENERIC_TEXT',
198: 'Exception "OTHERS" for selection of nit information from JL_CO_GL_NITS table');
199: x_error_text := SUBSTR(fnd_message.get, 1, 100);
200: app_exception.raise_exception (exception_type => 'APP',

Line 197: fnd_message.set_token('GENERIC_TEXT',

193:
194: WHEN OTHERS THEN
195:
196: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
197: fnd_message.set_token('GENERIC_TEXT',
198: 'Exception "OTHERS" for selection of nit information from JL_CO_GL_NITS table');
199: x_error_text := SUBSTR(fnd_message.get, 1, 100);
200: app_exception.raise_exception (exception_type => 'APP',
201: exception_code =>

Line 199: x_error_text := SUBSTR(fnd_message.get, 1, 100);

195:
196: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
197: fnd_message.set_token('GENERIC_TEXT',
198: 'Exception "OTHERS" for selection of nit information from JL_CO_GL_NITS table');
199: x_error_text := SUBSTR(fnd_message.get, 1, 100);
200: app_exception.raise_exception (exception_type => 'APP',
201: exception_code =>
202: jl_zz_fa_utilities_pkg.get_app_errnum('AR', 'GENERIC_MESSAGE'),
203: exception_text => x_error_text);

Line 334: fnd_message.set_name('AR', 'GENERIC_MESSAGE');

330: EXCEPTION
331:
332: WHEN OTHERS THEN
333:
334: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
335: fnd_message.set_token('GENERIC_TEXT',
336: 'Exception "OTHERS" while inserting into jl_co_gl_mg_lines table');
337: x_error_text := SUBSTR(fnd_message.get, 1, 100);
338: ROLLBACK;

Line 335: fnd_message.set_token('GENERIC_TEXT',

331:
332: WHEN OTHERS THEN
333:
334: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
335: fnd_message.set_token('GENERIC_TEXT',
336: 'Exception "OTHERS" while inserting into jl_co_gl_mg_lines table');
337: x_error_text := SUBSTR(fnd_message.get, 1, 100);
338: ROLLBACK;
339: app_exception.raise_exception (exception_type => 'APP',

Line 337: x_error_text := SUBSTR(fnd_message.get, 1, 100);

333:
334: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
335: fnd_message.set_token('GENERIC_TEXT',
336: 'Exception "OTHERS" while inserting into jl_co_gl_mg_lines table');
337: x_error_text := SUBSTR(fnd_message.get, 1, 100);
338: ROLLBACK;
339: app_exception.raise_exception (exception_type => 'APP',
340: exception_code =>
341: jl_zz_fa_utilities_pkg.get_app_errnum('AR', 'GENERIC_MESSAGE'),

Line 609: fnd_message.set_name('FND', 'CONC-ARGUMENTS');

605:
606: x_trx_count := 0;
607: x_bal_count := 0;
608:
609: fnd_message.set_name('FND', 'CONC-ARGUMENTS');
610: fnd_file.put_line( fnd_file.log, fnd_message.get);
611: fnd_file.put_line(fnd_file.log, '----------------------------------------');
612: fnd_message.set_name('JL', 'JL_CO_GL_MG_SET_OF_BOOKS_ID');
613: fnd_message.set_token('SET_OF_BOOKS_ID', p_set_of_books_id);

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

606: x_trx_count := 0;
607: x_bal_count := 0;
608:
609: fnd_message.set_name('FND', 'CONC-ARGUMENTS');
610: fnd_file.put_line( fnd_file.log, fnd_message.get);
611: fnd_file.put_line(fnd_file.log, '----------------------------------------');
612: fnd_message.set_name('JL', 'JL_CO_GL_MG_SET_OF_BOOKS_ID');
613: fnd_message.set_token('SET_OF_BOOKS_ID', p_set_of_books_id);
614: put_line( fnd_file.log, fnd_message.get);

Line 612: fnd_message.set_name('JL', 'JL_CO_GL_MG_SET_OF_BOOKS_ID');

608:
609: fnd_message.set_name('FND', 'CONC-ARGUMENTS');
610: fnd_file.put_line( fnd_file.log, fnd_message.get);
611: fnd_file.put_line(fnd_file.log, '----------------------------------------');
612: fnd_message.set_name('JL', 'JL_CO_GL_MG_SET_OF_BOOKS_ID');
613: fnd_message.set_token('SET_OF_BOOKS_ID', p_set_of_books_id);
614: put_line( fnd_file.log, fnd_message.get);
615: fnd_message.set_name('JL', 'JL_CO_GL_MG_REPORTED_YEAR');
616: fnd_message.set_token('REPORTED_YEAR', p_reported_year);

Line 613: fnd_message.set_token('SET_OF_BOOKS_ID', p_set_of_books_id);

609: fnd_message.set_name('FND', 'CONC-ARGUMENTS');
610: fnd_file.put_line( fnd_file.log, fnd_message.get);
611: fnd_file.put_line(fnd_file.log, '----------------------------------------');
612: fnd_message.set_name('JL', 'JL_CO_GL_MG_SET_OF_BOOKS_ID');
613: fnd_message.set_token('SET_OF_BOOKS_ID', p_set_of_books_id);
614: put_line( fnd_file.log, fnd_message.get);
615: fnd_message.set_name('JL', 'JL_CO_GL_MG_REPORTED_YEAR');
616: fnd_message.set_token('REPORTED_YEAR', p_reported_year);
617: put_line( fnd_file.log, fnd_message.get);

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

610: fnd_file.put_line( fnd_file.log, fnd_message.get);
611: fnd_file.put_line(fnd_file.log, '----------------------------------------');
612: fnd_message.set_name('JL', 'JL_CO_GL_MG_SET_OF_BOOKS_ID');
613: fnd_message.set_token('SET_OF_BOOKS_ID', p_set_of_books_id);
614: put_line( fnd_file.log, fnd_message.get);
615: fnd_message.set_name('JL', 'JL_CO_GL_MG_REPORTED_YEAR');
616: fnd_message.set_token('REPORTED_YEAR', p_reported_year);
617: put_line( fnd_file.log, fnd_message.get);
618: fnd_message.set_name('JL', 'JL_CO_GL_MG_PERIOD_START');

Line 615: fnd_message.set_name('JL', 'JL_CO_GL_MG_REPORTED_YEAR');

611: fnd_file.put_line(fnd_file.log, '----------------------------------------');
612: fnd_message.set_name('JL', 'JL_CO_GL_MG_SET_OF_BOOKS_ID');
613: fnd_message.set_token('SET_OF_BOOKS_ID', p_set_of_books_id);
614: put_line( fnd_file.log, fnd_message.get);
615: fnd_message.set_name('JL', 'JL_CO_GL_MG_REPORTED_YEAR');
616: fnd_message.set_token('REPORTED_YEAR', p_reported_year);
617: put_line( fnd_file.log, fnd_message.get);
618: fnd_message.set_name('JL', 'JL_CO_GL_MG_PERIOD_START');
619: fnd_message.set_token('PERIOD_START', p_period_start);

Line 616: fnd_message.set_token('REPORTED_YEAR', p_reported_year);

612: fnd_message.set_name('JL', 'JL_CO_GL_MG_SET_OF_BOOKS_ID');
613: fnd_message.set_token('SET_OF_BOOKS_ID', p_set_of_books_id);
614: put_line( fnd_file.log, fnd_message.get);
615: fnd_message.set_name('JL', 'JL_CO_GL_MG_REPORTED_YEAR');
616: fnd_message.set_token('REPORTED_YEAR', p_reported_year);
617: put_line( fnd_file.log, fnd_message.get);
618: fnd_message.set_name('JL', 'JL_CO_GL_MG_PERIOD_START');
619: fnd_message.set_token('PERIOD_START', p_period_start);
620: put_line( fnd_file.log, fnd_message.get);

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

613: fnd_message.set_token('SET_OF_BOOKS_ID', p_set_of_books_id);
614: put_line( fnd_file.log, fnd_message.get);
615: fnd_message.set_name('JL', 'JL_CO_GL_MG_REPORTED_YEAR');
616: fnd_message.set_token('REPORTED_YEAR', p_reported_year);
617: put_line( fnd_file.log, fnd_message.get);
618: fnd_message.set_name('JL', 'JL_CO_GL_MG_PERIOD_START');
619: fnd_message.set_token('PERIOD_START', p_period_start);
620: put_line( fnd_file.log, fnd_message.get);
621: fnd_message.set_name('JL', 'JL_CO_GL_MG_PERIOD_END');

Line 618: fnd_message.set_name('JL', 'JL_CO_GL_MG_PERIOD_START');

614: put_line( fnd_file.log, fnd_message.get);
615: fnd_message.set_name('JL', 'JL_CO_GL_MG_REPORTED_YEAR');
616: fnd_message.set_token('REPORTED_YEAR', p_reported_year);
617: put_line( fnd_file.log, fnd_message.get);
618: fnd_message.set_name('JL', 'JL_CO_GL_MG_PERIOD_START');
619: fnd_message.set_token('PERIOD_START', p_period_start);
620: put_line( fnd_file.log, fnd_message.get);
621: fnd_message.set_name('JL', 'JL_CO_GL_MG_PERIOD_END');
622: fnd_message.set_token('PERIOD_END', p_period_end);

Line 619: fnd_message.set_token('PERIOD_START', p_period_start);

615: fnd_message.set_name('JL', 'JL_CO_GL_MG_REPORTED_YEAR');
616: fnd_message.set_token('REPORTED_YEAR', p_reported_year);
617: put_line( fnd_file.log, fnd_message.get);
618: fnd_message.set_name('JL', 'JL_CO_GL_MG_PERIOD_START');
619: fnd_message.set_token('PERIOD_START', p_period_start);
620: put_line( fnd_file.log, fnd_message.get);
621: fnd_message.set_name('JL', 'JL_CO_GL_MG_PERIOD_END');
622: fnd_message.set_token('PERIOD_END', p_period_end);
623: put_line( fnd_file.log, fnd_message.get);

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

616: fnd_message.set_token('REPORTED_YEAR', p_reported_year);
617: put_line( fnd_file.log, fnd_message.get);
618: fnd_message.set_name('JL', 'JL_CO_GL_MG_PERIOD_START');
619: fnd_message.set_token('PERIOD_START', p_period_start);
620: put_line( fnd_file.log, fnd_message.get);
621: fnd_message.set_name('JL', 'JL_CO_GL_MG_PERIOD_END');
622: fnd_message.set_token('PERIOD_END', p_period_end);
623: put_line( fnd_file.log, fnd_message.get);
624: fnd_message.set_name('JL', 'JL_CO_GL_MG_LITERAL_START');

Line 621: fnd_message.set_name('JL', 'JL_CO_GL_MG_PERIOD_END');

617: put_line( fnd_file.log, fnd_message.get);
618: fnd_message.set_name('JL', 'JL_CO_GL_MG_PERIOD_START');
619: fnd_message.set_token('PERIOD_START', p_period_start);
620: put_line( fnd_file.log, fnd_message.get);
621: fnd_message.set_name('JL', 'JL_CO_GL_MG_PERIOD_END');
622: fnd_message.set_token('PERIOD_END', p_period_end);
623: put_line( fnd_file.log, fnd_message.get);
624: fnd_message.set_name('JL', 'JL_CO_GL_MG_LITERAL_START');
625: fnd_message.set_token('LITERAL_START', p_literal_start);

Line 622: fnd_message.set_token('PERIOD_END', p_period_end);

618: fnd_message.set_name('JL', 'JL_CO_GL_MG_PERIOD_START');
619: fnd_message.set_token('PERIOD_START', p_period_start);
620: put_line( fnd_file.log, fnd_message.get);
621: fnd_message.set_name('JL', 'JL_CO_GL_MG_PERIOD_END');
622: fnd_message.set_token('PERIOD_END', p_period_end);
623: put_line( fnd_file.log, fnd_message.get);
624: fnd_message.set_name('JL', 'JL_CO_GL_MG_LITERAL_START');
625: fnd_message.set_token('LITERAL_START', p_literal_start);
626: put_line( fnd_file.log, fnd_message.get);

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

619: fnd_message.set_token('PERIOD_START', p_period_start);
620: put_line( fnd_file.log, fnd_message.get);
621: fnd_message.set_name('JL', 'JL_CO_GL_MG_PERIOD_END');
622: fnd_message.set_token('PERIOD_END', p_period_end);
623: put_line( fnd_file.log, fnd_message.get);
624: fnd_message.set_name('JL', 'JL_CO_GL_MG_LITERAL_START');
625: fnd_message.set_token('LITERAL_START', p_literal_start);
626: put_line( fnd_file.log, fnd_message.get);
627: fnd_message.set_name('JL', 'JL_CO_GL_MG_LITERAL_END');

Line 624: fnd_message.set_name('JL', 'JL_CO_GL_MG_LITERAL_START');

620: put_line( fnd_file.log, fnd_message.get);
621: fnd_message.set_name('JL', 'JL_CO_GL_MG_PERIOD_END');
622: fnd_message.set_token('PERIOD_END', p_period_end);
623: put_line( fnd_file.log, fnd_message.get);
624: fnd_message.set_name('JL', 'JL_CO_GL_MG_LITERAL_START');
625: fnd_message.set_token('LITERAL_START', p_literal_start);
626: put_line( fnd_file.log, fnd_message.get);
627: fnd_message.set_name('JL', 'JL_CO_GL_MG_LITERAL_END');
628: fnd_message.set_token('LITERAL_END', p_literal_end);

Line 625: fnd_message.set_token('LITERAL_START', p_literal_start);

621: fnd_message.set_name('JL', 'JL_CO_GL_MG_PERIOD_END');
622: fnd_message.set_token('PERIOD_END', p_period_end);
623: put_line( fnd_file.log, fnd_message.get);
624: fnd_message.set_name('JL', 'JL_CO_GL_MG_LITERAL_START');
625: fnd_message.set_token('LITERAL_START', p_literal_start);
626: put_line( fnd_file.log, fnd_message.get);
627: fnd_message.set_name('JL', 'JL_CO_GL_MG_LITERAL_END');
628: fnd_message.set_token('LITERAL_END', p_literal_end);
629: put_line( fnd_file.log, fnd_message.get);

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

622: fnd_message.set_token('PERIOD_END', p_period_end);
623: put_line( fnd_file.log, fnd_message.get);
624: fnd_message.set_name('JL', 'JL_CO_GL_MG_LITERAL_START');
625: fnd_message.set_token('LITERAL_START', p_literal_start);
626: put_line( fnd_file.log, fnd_message.get);
627: fnd_message.set_name('JL', 'JL_CO_GL_MG_LITERAL_END');
628: fnd_message.set_token('LITERAL_END', p_literal_end);
629: put_line( fnd_file.log, fnd_message.get);
630: fnd_file.put_line(fnd_file.log, '----------------------------------------');

Line 627: fnd_message.set_name('JL', 'JL_CO_GL_MG_LITERAL_END');

623: put_line( fnd_file.log, fnd_message.get);
624: fnd_message.set_name('JL', 'JL_CO_GL_MG_LITERAL_START');
625: fnd_message.set_token('LITERAL_START', p_literal_start);
626: put_line( fnd_file.log, fnd_message.get);
627: fnd_message.set_name('JL', 'JL_CO_GL_MG_LITERAL_END');
628: fnd_message.set_token('LITERAL_END', p_literal_end);
629: put_line( fnd_file.log, fnd_message.get);
630: fnd_file.put_line(fnd_file.log, '----------------------------------------');
631:

Line 628: fnd_message.set_token('LITERAL_END', p_literal_end);

624: fnd_message.set_name('JL', 'JL_CO_GL_MG_LITERAL_START');
625: fnd_message.set_token('LITERAL_START', p_literal_start);
626: put_line( fnd_file.log, fnd_message.get);
627: fnd_message.set_name('JL', 'JL_CO_GL_MG_LITERAL_END');
628: fnd_message.set_token('LITERAL_END', p_literal_end);
629: put_line( fnd_file.log, fnd_message.get);
630: fnd_file.put_line(fnd_file.log, '----------------------------------------');
631:
632:

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

625: fnd_message.set_token('LITERAL_START', p_literal_start);
626: put_line( fnd_file.log, fnd_message.get);
627: fnd_message.set_name('JL', 'JL_CO_GL_MG_LITERAL_END');
628: fnd_message.set_token('LITERAL_END', p_literal_end);
629: put_line( fnd_file.log, fnd_message.get);
630: fnd_file.put_line(fnd_file.log, '----------------------------------------');
631:
632:
633: /******************************************************

Line 686: fnd_message.set_name('JL', 'JL_CO_GL_MG_DELETE');

682: AND origin = 'A';
683:
684: IF SQL%FOUND THEN
685: COMMIT;
686: fnd_message.set_name('JL', 'JL_CO_GL_MG_DELETE');
687: fnd_message.set_token('NUMBER', TO_CHAR(SQL%ROWCOUNT));
688: fnd_message.set_token('TABLE', 'JL_CO_GL_MG_LINES');
689: put_line( fnd_file.log, fnd_message.get);
690: ELSE

Line 687: fnd_message.set_token('NUMBER', TO_CHAR(SQL%ROWCOUNT));

683:
684: IF SQL%FOUND THEN
685: COMMIT;
686: fnd_message.set_name('JL', 'JL_CO_GL_MG_DELETE');
687: fnd_message.set_token('NUMBER', TO_CHAR(SQL%ROWCOUNT));
688: fnd_message.set_token('TABLE', 'JL_CO_GL_MG_LINES');
689: put_line( fnd_file.log, fnd_message.get);
690: ELSE
691: NULL;

Line 688: fnd_message.set_token('TABLE', 'JL_CO_GL_MG_LINES');

684: IF SQL%FOUND THEN
685: COMMIT;
686: fnd_message.set_name('JL', 'JL_CO_GL_MG_DELETE');
687: fnd_message.set_token('NUMBER', TO_CHAR(SQL%ROWCOUNT));
688: fnd_message.set_token('TABLE', 'JL_CO_GL_MG_LINES');
689: put_line( fnd_file.log, fnd_message.get);
690: ELSE
691: NULL;
692: fnd_message.set_name('JL', 'JL_CO_GL_MG_NOT_DELETE');

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

685: COMMIT;
686: fnd_message.set_name('JL', 'JL_CO_GL_MG_DELETE');
687: fnd_message.set_token('NUMBER', TO_CHAR(SQL%ROWCOUNT));
688: fnd_message.set_token('TABLE', 'JL_CO_GL_MG_LINES');
689: put_line( fnd_file.log, fnd_message.get);
690: ELSE
691: NULL;
692: fnd_message.set_name('JL', 'JL_CO_GL_MG_NOT_DELETE');
693: fnd_message.set_token('TABLE', 'JL_CO_GL_MG_LINES');

Line 692: fnd_message.set_name('JL', 'JL_CO_GL_MG_NOT_DELETE');

688: fnd_message.set_token('TABLE', 'JL_CO_GL_MG_LINES');
689: put_line( fnd_file.log, fnd_message.get);
690: ELSE
691: NULL;
692: fnd_message.set_name('JL', 'JL_CO_GL_MG_NOT_DELETE');
693: fnd_message.set_token('TABLE', 'JL_CO_GL_MG_LINES');
694: put_line( fnd_file.log, fnd_message.get);
695: END IF;
696:

Line 693: fnd_message.set_token('TABLE', 'JL_CO_GL_MG_LINES');

689: put_line( fnd_file.log, fnd_message.get);
690: ELSE
691: NULL;
692: fnd_message.set_name('JL', 'JL_CO_GL_MG_NOT_DELETE');
693: fnd_message.set_token('TABLE', 'JL_CO_GL_MG_LINES');
694: put_line( fnd_file.log, fnd_message.get);
695: END IF;
696:
697: EXCEPTION

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

690: ELSE
691: NULL;
692: fnd_message.set_name('JL', 'JL_CO_GL_MG_NOT_DELETE');
693: fnd_message.set_token('TABLE', 'JL_CO_GL_MG_LINES');
694: put_line( fnd_file.log, fnd_message.get);
695: END IF;
696:
697: EXCEPTION
698:

Line 718: fnd_message.set_name('JL', 'JL_CO_GL_MG_DELETE');

714: );
715:
716: IF SQL%FOUND THEN
717: COMMIT;
718: fnd_message.set_name('JL', 'JL_CO_GL_MG_DELETE');
719: fnd_message.set_token('NUMBER', TO_CHAR(SQL%ROWCOUNT));
720: fnd_message.set_token('TABLE', 'JL_CO_GL_MG_HEADERS');
721: put_line( fnd_file.log, fnd_message.get);
722: ELSE

Line 719: fnd_message.set_token('NUMBER', TO_CHAR(SQL%ROWCOUNT));

715:
716: IF SQL%FOUND THEN
717: COMMIT;
718: fnd_message.set_name('JL', 'JL_CO_GL_MG_DELETE');
719: fnd_message.set_token('NUMBER', TO_CHAR(SQL%ROWCOUNT));
720: fnd_message.set_token('TABLE', 'JL_CO_GL_MG_HEADERS');
721: put_line( fnd_file.log, fnd_message.get);
722: ELSE
723: NULL;

Line 720: fnd_message.set_token('TABLE', 'JL_CO_GL_MG_HEADERS');

716: IF SQL%FOUND THEN
717: COMMIT;
718: fnd_message.set_name('JL', 'JL_CO_GL_MG_DELETE');
719: fnd_message.set_token('NUMBER', TO_CHAR(SQL%ROWCOUNT));
720: fnd_message.set_token('TABLE', 'JL_CO_GL_MG_HEADERS');
721: put_line( fnd_file.log, fnd_message.get);
722: ELSE
723: NULL;
724: fnd_message.set_name('JL', 'JL_CO_GL_MG_NOT_DELETE');

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

717: COMMIT;
718: fnd_message.set_name('JL', 'JL_CO_GL_MG_DELETE');
719: fnd_message.set_token('NUMBER', TO_CHAR(SQL%ROWCOUNT));
720: fnd_message.set_token('TABLE', 'JL_CO_GL_MG_HEADERS');
721: put_line( fnd_file.log, fnd_message.get);
722: ELSE
723: NULL;
724: fnd_message.set_name('JL', 'JL_CO_GL_MG_NOT_DELETE');
725: fnd_message.set_token('TABLE', 'JL_CO_GL_MG_HEADERS');

Line 724: fnd_message.set_name('JL', 'JL_CO_GL_MG_NOT_DELETE');

720: fnd_message.set_token('TABLE', 'JL_CO_GL_MG_HEADERS');
721: put_line( fnd_file.log, fnd_message.get);
722: ELSE
723: NULL;
724: fnd_message.set_name('JL', 'JL_CO_GL_MG_NOT_DELETE');
725: fnd_message.set_token('TABLE', 'JL_CO_GL_MG_HEADERS');
726: put_line( fnd_file.log, fnd_message.get);
727: END IF;
728:

Line 725: fnd_message.set_token('TABLE', 'JL_CO_GL_MG_HEADERS');

721: put_line( fnd_file.log, fnd_message.get);
722: ELSE
723: NULL;
724: fnd_message.set_name('JL', 'JL_CO_GL_MG_NOT_DELETE');
725: fnd_message.set_token('TABLE', 'JL_CO_GL_MG_HEADERS');
726: put_line( fnd_file.log, fnd_message.get);
727: END IF;
728:
729: EXCEPTION

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

722: ELSE
723: NULL;
724: fnd_message.set_name('JL', 'JL_CO_GL_MG_NOT_DELETE');
725: fnd_message.set_token('TABLE', 'JL_CO_GL_MG_HEADERS');
726: put_line( fnd_file.log, fnd_message.get);
727: END IF;
728:
729: EXCEPTION
730:

Line 784: fnd_message.set_name('JL', 'JL_CO_GL_MG_INSERT');

780: );
781:
782: COMMIT;
783:
784: fnd_message.set_name('JL', 'JL_CO_GL_MG_INSERT');
785: fnd_message.set_token('NUMBER', '1');
786: fnd_message.set_token('TYPE', ' ');
787: fnd_message.set_token('TABLE', 'JL_CO_GL_MG_HEADERS');
788: put_line( fnd_file.log, fnd_message.get);

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

781:
782: COMMIT;
783:
784: fnd_message.set_name('JL', 'JL_CO_GL_MG_INSERT');
785: fnd_message.set_token('NUMBER', '1');
786: fnd_message.set_token('TYPE', ' ');
787: fnd_message.set_token('TABLE', 'JL_CO_GL_MG_HEADERS');
788: put_line( fnd_file.log, fnd_message.get);
789:

Line 786: fnd_message.set_token('TYPE', ' ');

782: COMMIT;
783:
784: fnd_message.set_name('JL', 'JL_CO_GL_MG_INSERT');
785: fnd_message.set_token('NUMBER', '1');
786: fnd_message.set_token('TYPE', ' ');
787: fnd_message.set_token('TABLE', 'JL_CO_GL_MG_HEADERS');
788: put_line( fnd_file.log, fnd_message.get);
789:
790: EXCEPTION

Line 787: fnd_message.set_token('TABLE', 'JL_CO_GL_MG_HEADERS');

783:
784: fnd_message.set_name('JL', 'JL_CO_GL_MG_INSERT');
785: fnd_message.set_token('NUMBER', '1');
786: fnd_message.set_token('TYPE', ' ');
787: fnd_message.set_token('TABLE', 'JL_CO_GL_MG_HEADERS');
788: put_line( fnd_file.log, fnd_message.get);
789:
790: EXCEPTION
791:

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

784: fnd_message.set_name('JL', 'JL_CO_GL_MG_INSERT');
785: fnd_message.set_token('NUMBER', '1');
786: fnd_message.set_token('TYPE', ' ');
787: fnd_message.set_token('TABLE', 'JL_CO_GL_MG_HEADERS');
788: put_line( fnd_file.log, fnd_message.get);
789:
790: EXCEPTION
791:
792: WHEN OTHERS THEN

Line 794: fnd_message.set_name('AR', 'GENERIC_MESSAGE');

790: EXCEPTION
791:
792: WHEN OTHERS THEN
793:
794: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
795: fnd_message.set_token('GENERIC_TEXT',
796: 'Exception "OTHERS" while inserting into jl_co_gl_mg_headers table');
797: x_error_text := SUBSTR(fnd_message.get, 1, 100);
798: ROLLBACK;

Line 795: fnd_message.set_token('GENERIC_TEXT',

791:
792: WHEN OTHERS THEN
793:
794: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
795: fnd_message.set_token('GENERIC_TEXT',
796: 'Exception "OTHERS" while inserting into jl_co_gl_mg_headers table');
797: x_error_text := SUBSTR(fnd_message.get, 1, 100);
798: ROLLBACK;
799: app_exception.raise_exception (exception_type => 'APP',

Line 797: x_error_text := SUBSTR(fnd_message.get, 1, 100);

793:
794: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
795: fnd_message.set_token('GENERIC_TEXT',
796: 'Exception "OTHERS" while inserting into jl_co_gl_mg_headers table');
797: x_error_text := SUBSTR(fnd_message.get, 1, 100);
798: ROLLBACK;
799: app_exception.raise_exception (exception_type => 'APP',
800: exception_code =>
801: jl_zz_fa_utilities_pkg.get_app_errnum('AR', 'GENERIC_MESSAGE'),

Line 879: fnd_message.set_name('JL', 'JL_CO_GL_MG_INSERT');

875: END LOOP;
876:
877: IF x_trx_count > 0 THEN
878:
879: fnd_message.set_name('JL', 'JL_CO_GL_MG_INSERT');
880: fnd_message.set_token('NUMBER', TO_CHAR(x_trx_count));
881: fnd_message.set_token('TYPE', 'NIT_TRANSACTIONS');
882: fnd_message.set_token('TABLE', 'JL_CO_GL_MG_LINES');
883: put_line( fnd_file.log, fnd_message.get);

Line 880: fnd_message.set_token('NUMBER', TO_CHAR(x_trx_count));

876:
877: IF x_trx_count > 0 THEN
878:
879: fnd_message.set_name('JL', 'JL_CO_GL_MG_INSERT');
880: fnd_message.set_token('NUMBER', TO_CHAR(x_trx_count));
881: fnd_message.set_token('TYPE', 'NIT_TRANSACTIONS');
882: fnd_message.set_token('TABLE', 'JL_CO_GL_MG_LINES');
883: put_line( fnd_file.log, fnd_message.get);
884:

Line 881: fnd_message.set_token('TYPE', 'NIT_TRANSACTIONS');

877: IF x_trx_count > 0 THEN
878:
879: fnd_message.set_name('JL', 'JL_CO_GL_MG_INSERT');
880: fnd_message.set_token('NUMBER', TO_CHAR(x_trx_count));
881: fnd_message.set_token('TYPE', 'NIT_TRANSACTIONS');
882: fnd_message.set_token('TABLE', 'JL_CO_GL_MG_LINES');
883: put_line( fnd_file.log, fnd_message.get);
884:
885: END IF;

Line 882: fnd_message.set_token('TABLE', 'JL_CO_GL_MG_LINES');

878:
879: fnd_message.set_name('JL', 'JL_CO_GL_MG_INSERT');
880: fnd_message.set_token('NUMBER', TO_CHAR(x_trx_count));
881: fnd_message.set_token('TYPE', 'NIT_TRANSACTIONS');
882: fnd_message.set_token('TABLE', 'JL_CO_GL_MG_LINES');
883: put_line( fnd_file.log, fnd_message.get);
884:
885: END IF;
886:

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

879: fnd_message.set_name('JL', 'JL_CO_GL_MG_INSERT');
880: fnd_message.set_token('NUMBER', TO_CHAR(x_trx_count));
881: fnd_message.set_token('TYPE', 'NIT_TRANSACTIONS');
882: fnd_message.set_token('TABLE', 'JL_CO_GL_MG_LINES');
883: put_line( fnd_file.log, fnd_message.get);
884:
885: END IF;
886:
887: IF x_bal_count > 0 THEN

Line 889: fnd_message.set_name('JL', 'JL_CO_GL_MG_INSERT');

885: END IF;
886:
887: IF x_bal_count > 0 THEN
888:
889: fnd_message.set_name('JL', 'JL_CO_GL_MG_INSERT');
890: fnd_message.set_token('NUMBER', TO_CHAR(x_bal_count));
891: fnd_message.set_token('TYPE', 'NIT_BALANCES');
892: fnd_message.set_token('TABLE', 'JL_CO_GL_MG_LINES');
893: put_line( fnd_file.log, fnd_message.get);

Line 890: fnd_message.set_token('NUMBER', TO_CHAR(x_bal_count));

886:
887: IF x_bal_count > 0 THEN
888:
889: fnd_message.set_name('JL', 'JL_CO_GL_MG_INSERT');
890: fnd_message.set_token('NUMBER', TO_CHAR(x_bal_count));
891: fnd_message.set_token('TYPE', 'NIT_BALANCES');
892: fnd_message.set_token('TABLE', 'JL_CO_GL_MG_LINES');
893: put_line( fnd_file.log, fnd_message.get);
894:

Line 891: fnd_message.set_token('TYPE', 'NIT_BALANCES');

887: IF x_bal_count > 0 THEN
888:
889: fnd_message.set_name('JL', 'JL_CO_GL_MG_INSERT');
890: fnd_message.set_token('NUMBER', TO_CHAR(x_bal_count));
891: fnd_message.set_token('TYPE', 'NIT_BALANCES');
892: fnd_message.set_token('TABLE', 'JL_CO_GL_MG_LINES');
893: put_line( fnd_file.log, fnd_message.get);
894:
895: END IF;

Line 892: fnd_message.set_token('TABLE', 'JL_CO_GL_MG_LINES');

888:
889: fnd_message.set_name('JL', 'JL_CO_GL_MG_INSERT');
890: fnd_message.set_token('NUMBER', TO_CHAR(x_bal_count));
891: fnd_message.set_token('TYPE', 'NIT_BALANCES');
892: fnd_message.set_token('TABLE', 'JL_CO_GL_MG_LINES');
893: put_line( fnd_file.log, fnd_message.get);
894:
895: END IF;
896:

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

889: fnd_message.set_name('JL', 'JL_CO_GL_MG_INSERT');
890: fnd_message.set_token('NUMBER', TO_CHAR(x_bal_count));
891: fnd_message.set_token('TYPE', 'NIT_BALANCES');
892: fnd_message.set_token('TABLE', 'JL_CO_GL_MG_LINES');
893: put_line( fnd_file.log, fnd_message.get);
894:
895: END IF;
896:
897: IF x_trx_count = 0 AND x_bal_count = 0 THEN

Line 928: fnd_message.set_name('JL', 'JL_CO_GL_MG_FILE_SENT');

924: WHEN HEADERS_STATUS_Y THEN
925:
926: x_message := '----***************** W A R N I N G **********************----';
927: put_line( fnd_file.log, x_message);
928: fnd_message.set_name('JL', 'JL_CO_GL_MG_FILE_SENT');
929: fnd_message.set_token('YEAR', p_reported_year);
930: x_error_text := fnd_message.get;
931: put_line( fnd_file.log, x_error_text);
932: x_error_text := SUBSTR(x_error_text, 1, 100);

Line 929: fnd_message.set_token('YEAR', p_reported_year);

925:
926: x_message := '----***************** W A R N I N G **********************----';
927: put_line( fnd_file.log, x_message);
928: fnd_message.set_name('JL', 'JL_CO_GL_MG_FILE_SENT');
929: fnd_message.set_token('YEAR', p_reported_year);
930: x_error_text := fnd_message.get;
931: put_line( fnd_file.log, x_error_text);
932: x_error_text := SUBSTR(x_error_text, 1, 100);
933: x_message := '----******************************************************----';

Line 930: x_error_text := fnd_message.get;

926: x_message := '----***************** W A R N I N G **********************----';
927: put_line( fnd_file.log, x_message);
928: fnd_message.set_name('JL', 'JL_CO_GL_MG_FILE_SENT');
929: fnd_message.set_token('YEAR', p_reported_year);
930: x_error_text := fnd_message.get;
931: put_line( fnd_file.log, x_error_text);
932: x_error_text := SUBSTR(x_error_text, 1, 100);
933: x_message := '----******************************************************----';
934: put_line( fnd_file.log, x_message);

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

938: exception_text => x_error_text);
939:
940: WHEN OTHERS THEN
941:
942: fnd_message.set_name('JL', 'JL_CO_FA_GENERAL_ERROR');
943: fnd_file.put_line( fnd_file.log, fnd_message.get);
944: x_error_code := SQLCODE;
945: x_error_text := SUBSTR(SQLERRM,1,200);
946: ROLLBACK;

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

939:
940: WHEN OTHERS THEN
941:
942: fnd_message.set_name('JL', 'JL_CO_FA_GENERAL_ERROR');
943: fnd_file.put_line( fnd_file.log, fnd_message.get);
944: x_error_code := SQLCODE;
945: x_error_text := SUBSTR(SQLERRM,1,200);
946: ROLLBACK;
947: RAISE_APPLICATION_ERROR( x_error_code, x_error_text);

Line 1104: fnd_message.set_name('FND', 'CONC-ARGUMENTS');

1100:
1101:
1102: BEGIN <>
1103:
1104: fnd_message.set_name('FND', 'CONC-ARGUMENTS');
1105: fnd_file.put_line( fnd_file.log, fnd_message.get);
1106: fnd_file.put_line(fnd_file.log, '----------------------------------------');
1107: fnd_message.set_name('JL', 'JL_CO_GL_MG_SET_OF_BOOKS_ID');
1108: fnd_message.set_token('SET_OF_BOOKS_ID', p_set_of_books_id);

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

1101:
1102: BEGIN <>
1103:
1104: fnd_message.set_name('FND', 'CONC-ARGUMENTS');
1105: fnd_file.put_line( fnd_file.log, fnd_message.get);
1106: fnd_file.put_line(fnd_file.log, '----------------------------------------');
1107: fnd_message.set_name('JL', 'JL_CO_GL_MG_SET_OF_BOOKS_ID');
1108: fnd_message.set_token('SET_OF_BOOKS_ID', p_set_of_books_id);
1109: put_line( fnd_file.log, fnd_message.get);

Line 1107: fnd_message.set_name('JL', 'JL_CO_GL_MG_SET_OF_BOOKS_ID');

1103:
1104: fnd_message.set_name('FND', 'CONC-ARGUMENTS');
1105: fnd_file.put_line( fnd_file.log, fnd_message.get);
1106: fnd_file.put_line(fnd_file.log, '----------------------------------------');
1107: fnd_message.set_name('JL', 'JL_CO_GL_MG_SET_OF_BOOKS_ID');
1108: fnd_message.set_token('SET_OF_BOOKS_ID', p_set_of_books_id);
1109: put_line( fnd_file.log, fnd_message.get);
1110: fnd_message.set_name('JL', 'JL_CO_GL_MG_REPORTED_YEAR');
1111: fnd_message.set_token('REPORTED_YEAR', p_reported_year);

Line 1108: fnd_message.set_token('SET_OF_BOOKS_ID', p_set_of_books_id);

1104: fnd_message.set_name('FND', 'CONC-ARGUMENTS');
1105: fnd_file.put_line( fnd_file.log, fnd_message.get);
1106: fnd_file.put_line(fnd_file.log, '----------------------------------------');
1107: fnd_message.set_name('JL', 'JL_CO_GL_MG_SET_OF_BOOKS_ID');
1108: fnd_message.set_token('SET_OF_BOOKS_ID', p_set_of_books_id);
1109: put_line( fnd_file.log, fnd_message.get);
1110: fnd_message.set_name('JL', 'JL_CO_GL_MG_REPORTED_YEAR');
1111: fnd_message.set_token('REPORTED_YEAR', p_reported_year);
1112: put_line( fnd_file.log, fnd_message.get);

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

1105: fnd_file.put_line( fnd_file.log, fnd_message.get);
1106: fnd_file.put_line(fnd_file.log, '----------------------------------------');
1107: fnd_message.set_name('JL', 'JL_CO_GL_MG_SET_OF_BOOKS_ID');
1108: fnd_message.set_token('SET_OF_BOOKS_ID', p_set_of_books_id);
1109: put_line( fnd_file.log, fnd_message.get);
1110: fnd_message.set_name('JL', 'JL_CO_GL_MG_REPORTED_YEAR');
1111: fnd_message.set_token('REPORTED_YEAR', p_reported_year);
1112: put_line( fnd_file.log, fnd_message.get);
1113: fnd_message.set_name('JL', 'JL_CO_GL_MG_LITERAL_START');

Line 1110: fnd_message.set_name('JL', 'JL_CO_GL_MG_REPORTED_YEAR');

1106: fnd_file.put_line(fnd_file.log, '----------------------------------------');
1107: fnd_message.set_name('JL', 'JL_CO_GL_MG_SET_OF_BOOKS_ID');
1108: fnd_message.set_token('SET_OF_BOOKS_ID', p_set_of_books_id);
1109: put_line( fnd_file.log, fnd_message.get);
1110: fnd_message.set_name('JL', 'JL_CO_GL_MG_REPORTED_YEAR');
1111: fnd_message.set_token('REPORTED_YEAR', p_reported_year);
1112: put_line( fnd_file.log, fnd_message.get);
1113: fnd_message.set_name('JL', 'JL_CO_GL_MG_LITERAL_START');
1114: fnd_message.set_token('LITERAL_START', p_literal_start);

Line 1111: fnd_message.set_token('REPORTED_YEAR', p_reported_year);

1107: fnd_message.set_name('JL', 'JL_CO_GL_MG_SET_OF_BOOKS_ID');
1108: fnd_message.set_token('SET_OF_BOOKS_ID', p_set_of_books_id);
1109: put_line( fnd_file.log, fnd_message.get);
1110: fnd_message.set_name('JL', 'JL_CO_GL_MG_REPORTED_YEAR');
1111: fnd_message.set_token('REPORTED_YEAR', p_reported_year);
1112: put_line( fnd_file.log, fnd_message.get);
1113: fnd_message.set_name('JL', 'JL_CO_GL_MG_LITERAL_START');
1114: fnd_message.set_token('LITERAL_START', p_literal_start);
1115: put_line( fnd_file.log, fnd_message.get);

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

1108: fnd_message.set_token('SET_OF_BOOKS_ID', p_set_of_books_id);
1109: put_line( fnd_file.log, fnd_message.get);
1110: fnd_message.set_name('JL', 'JL_CO_GL_MG_REPORTED_YEAR');
1111: fnd_message.set_token('REPORTED_YEAR', p_reported_year);
1112: put_line( fnd_file.log, fnd_message.get);
1113: fnd_message.set_name('JL', 'JL_CO_GL_MG_LITERAL_START');
1114: fnd_message.set_token('LITERAL_START', p_literal_start);
1115: put_line( fnd_file.log, fnd_message.get);
1116: fnd_message.set_name('JL', 'JL_CO_GL_MG_LITERAL_END');

Line 1113: fnd_message.set_name('JL', 'JL_CO_GL_MG_LITERAL_START');

1109: put_line( fnd_file.log, fnd_message.get);
1110: fnd_message.set_name('JL', 'JL_CO_GL_MG_REPORTED_YEAR');
1111: fnd_message.set_token('REPORTED_YEAR', p_reported_year);
1112: put_line( fnd_file.log, fnd_message.get);
1113: fnd_message.set_name('JL', 'JL_CO_GL_MG_LITERAL_START');
1114: fnd_message.set_token('LITERAL_START', p_literal_start);
1115: put_line( fnd_file.log, fnd_message.get);
1116: fnd_message.set_name('JL', 'JL_CO_GL_MG_LITERAL_END');
1117: fnd_message.set_token('LITERAL_END', p_literal_end);

Line 1114: fnd_message.set_token('LITERAL_START', p_literal_start);

1110: fnd_message.set_name('JL', 'JL_CO_GL_MG_REPORTED_YEAR');
1111: fnd_message.set_token('REPORTED_YEAR', p_reported_year);
1112: put_line( fnd_file.log, fnd_message.get);
1113: fnd_message.set_name('JL', 'JL_CO_GL_MG_LITERAL_START');
1114: fnd_message.set_token('LITERAL_START', p_literal_start);
1115: put_line( fnd_file.log, fnd_message.get);
1116: fnd_message.set_name('JL', 'JL_CO_GL_MG_LITERAL_END');
1117: fnd_message.set_token('LITERAL_END', p_literal_end);
1118: put_line( fnd_file.log, fnd_message.get);

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

1111: fnd_message.set_token('REPORTED_YEAR', p_reported_year);
1112: put_line( fnd_file.log, fnd_message.get);
1113: fnd_message.set_name('JL', 'JL_CO_GL_MG_LITERAL_START');
1114: fnd_message.set_token('LITERAL_START', p_literal_start);
1115: put_line( fnd_file.log, fnd_message.get);
1116: fnd_message.set_name('JL', 'JL_CO_GL_MG_LITERAL_END');
1117: fnd_message.set_token('LITERAL_END', p_literal_end);
1118: put_line( fnd_file.log, fnd_message.get);
1119: fnd_file.put_line(fnd_file.log, '----------------------------------------');

Line 1116: fnd_message.set_name('JL', 'JL_CO_GL_MG_LITERAL_END');

1112: put_line( fnd_file.log, fnd_message.get);
1113: fnd_message.set_name('JL', 'JL_CO_GL_MG_LITERAL_START');
1114: fnd_message.set_token('LITERAL_START', p_literal_start);
1115: put_line( fnd_file.log, fnd_message.get);
1116: fnd_message.set_name('JL', 'JL_CO_GL_MG_LITERAL_END');
1117: fnd_message.set_token('LITERAL_END', p_literal_end);
1118: put_line( fnd_file.log, fnd_message.get);
1119: fnd_file.put_line(fnd_file.log, '----------------------------------------');
1120:

Line 1117: fnd_message.set_token('LITERAL_END', p_literal_end);

1113: fnd_message.set_name('JL', 'JL_CO_GL_MG_LITERAL_START');
1114: fnd_message.set_token('LITERAL_START', p_literal_start);
1115: put_line( fnd_file.log, fnd_message.get);
1116: fnd_message.set_name('JL', 'JL_CO_GL_MG_LITERAL_END');
1117: fnd_message.set_token('LITERAL_END', p_literal_end);
1118: put_line( fnd_file.log, fnd_message.get);
1119: fnd_file.put_line(fnd_file.log, '----------------------------------------');
1120:
1121: /******************************************************

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

1114: fnd_message.set_token('LITERAL_START', p_literal_start);
1115: put_line( fnd_file.log, fnd_message.get);
1116: fnd_message.set_name('JL', 'JL_CO_GL_MG_LITERAL_END');
1117: fnd_message.set_token('LITERAL_END', p_literal_end);
1118: put_line( fnd_file.log, fnd_message.get);
1119: fnd_file.put_line(fnd_file.log, '----------------------------------------');
1120:
1121: /******************************************************
1122: Check for JL_CO_GL_MG_HEADERS.STATUS = 'Y'. If any row

Line 1180: fnd_message.set_name('AR', 'GENERIC_MESSAGE');

1176: EXCEPTION
1177:
1178: WHEN NO_DATA_FOUND THEN
1179:
1180: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
1181: fnd_message.set_token('GENERIC_TEXT',
1182: 'Exception "NO_DATA_FOUND" for selection of flags from JL_CO_GL_MG_LITERALS table');
1183: put_line(fnd_file.log, fnd_message.get);
1184: x_error_code := SQLCODE;

Line 1181: fnd_message.set_token('GENERIC_TEXT',

1177:
1178: WHEN NO_DATA_FOUND THEN
1179:
1180: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
1181: fnd_message.set_token('GENERIC_TEXT',
1182: 'Exception "NO_DATA_FOUND" for selection of flags from JL_CO_GL_MG_LITERALS table');
1183: put_line(fnd_file.log, fnd_message.get);
1184: x_error_code := SQLCODE;
1185: x_error_text := SUBSTR(SQLERRM,1,200);

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

1179:
1180: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
1181: fnd_message.set_token('GENERIC_TEXT',
1182: 'Exception "NO_DATA_FOUND" for selection of flags from JL_CO_GL_MG_LITERALS table');
1183: put_line(fnd_file.log, fnd_message.get);
1184: x_error_code := SQLCODE;
1185: x_error_text := SUBSTR(SQLERRM,1,200);
1186: RAISE_APPLICATION_ERROR( x_error_code, x_error_text);
1187:

Line 1190: fnd_message.set_name('AR', 'GENERIC_MESSAGE');

1186: RAISE_APPLICATION_ERROR( x_error_code, x_error_text);
1187:
1188: WHEN TOO_MANY_ROWS THEN
1189:
1190: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
1191: fnd_message.set_token('GENERIC_TEXT',
1192: 'Exception "TOO_MANY_ROWS" for selection of flags from JL_CO_GL_MG_LITERALS table');
1193: put_line(fnd_file.log, fnd_message.get);
1194: x_error_code := SQLCODE;

Line 1191: fnd_message.set_token('GENERIC_TEXT',

1187:
1188: WHEN TOO_MANY_ROWS THEN
1189:
1190: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
1191: fnd_message.set_token('GENERIC_TEXT',
1192: 'Exception "TOO_MANY_ROWS" for selection of flags from JL_CO_GL_MG_LITERALS table');
1193: put_line(fnd_file.log, fnd_message.get);
1194: x_error_code := SQLCODE;
1195: x_error_text := SUBSTR(SQLERRM,1,200);

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

1189:
1190: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
1191: fnd_message.set_token('GENERIC_TEXT',
1192: 'Exception "TOO_MANY_ROWS" for selection of flags from JL_CO_GL_MG_LITERALS table');
1193: put_line(fnd_file.log, fnd_message.get);
1194: x_error_code := SQLCODE;
1195: x_error_text := SUBSTR(SQLERRM,1,200);
1196: RAISE_APPLICATION_ERROR( x_error_code, x_error_text);
1197:

Line 1200: fnd_message.set_name('AR', 'GENERIC_MESSAGE');

1196: RAISE_APPLICATION_ERROR( x_error_code, x_error_text);
1197:
1198: WHEN OTHERS THEN
1199:
1200: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
1201: fnd_message.set_token('GENERIC_TEXT',
1202: 'Exception "OTHERS" for selection of flags from JL_CO_GL_MG_LITERALS table');
1203: put_line(fnd_file.log, fnd_message.get);
1204: x_error_code := SQLCODE;

Line 1201: fnd_message.set_token('GENERIC_TEXT',

1197:
1198: WHEN OTHERS THEN
1199:
1200: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
1201: fnd_message.set_token('GENERIC_TEXT',
1202: 'Exception "OTHERS" for selection of flags from JL_CO_GL_MG_LITERALS table');
1203: put_line(fnd_file.log, fnd_message.get);
1204: x_error_code := SQLCODE;
1205: x_error_text := SUBSTR(SQLERRM,1,200);

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

1199:
1200: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
1201: fnd_message.set_token('GENERIC_TEXT',
1202: 'Exception "OTHERS" for selection of flags from JL_CO_GL_MG_LITERALS table');
1203: put_line(fnd_file.log, fnd_message.get);
1204: x_error_code := SQLCODE;
1205: x_error_text := SUBSTR(SQLERRM,1,200);
1206: RAISE_APPLICATION_ERROR( x_error_code, x_error_text);
1207:

Line 1356: fnd_message.set_name('JL', 'JL_CO_GL_MG_TH_ALERT');

1352: IF count_process_flag > 0 THEN
1353:
1354: x_message := '----***************** W A R N I N G **********************----';
1355: put_line( fnd_file.log, x_message);
1356: fnd_message.set_name('JL', 'JL_CO_GL_MG_TH_ALERT');
1357: fnd_message.set_token('NUMBER', TO_CHAR(count_process_flag));
1358: fnd_message.set_token('TABLE', 'JL_CO_GL_MG_LITERALS');
1359: x_error_text := fnd_message.get;
1360: put_line( fnd_file.log, x_error_text);

Line 1357: fnd_message.set_token('NUMBER', TO_CHAR(count_process_flag));

1353:
1354: x_message := '----***************** W A R N I N G **********************----';
1355: put_line( fnd_file.log, x_message);
1356: fnd_message.set_name('JL', 'JL_CO_GL_MG_TH_ALERT');
1357: fnd_message.set_token('NUMBER', TO_CHAR(count_process_flag));
1358: fnd_message.set_token('TABLE', 'JL_CO_GL_MG_LITERALS');
1359: x_error_text := fnd_message.get;
1360: put_line( fnd_file.log, x_error_text);
1361: x_error_text := SUBSTR(x_error_text, 1, 100);

Line 1358: fnd_message.set_token('TABLE', 'JL_CO_GL_MG_LITERALS');

1354: x_message := '----***************** W A R N I N G **********************----';
1355: put_line( fnd_file.log, x_message);
1356: fnd_message.set_name('JL', 'JL_CO_GL_MG_TH_ALERT');
1357: fnd_message.set_token('NUMBER', TO_CHAR(count_process_flag));
1358: fnd_message.set_token('TABLE', 'JL_CO_GL_MG_LITERALS');
1359: x_error_text := fnd_message.get;
1360: put_line( fnd_file.log, x_error_text);
1361: x_error_text := SUBSTR(x_error_text, 1, 100);
1362: x_message := '----******************************************************----';

Line 1359: x_error_text := fnd_message.get;

1355: put_line( fnd_file.log, x_message);
1356: fnd_message.set_name('JL', 'JL_CO_GL_MG_TH_ALERT');
1357: fnd_message.set_token('NUMBER', TO_CHAR(count_process_flag));
1358: fnd_message.set_token('TABLE', 'JL_CO_GL_MG_LITERALS');
1359: x_error_text := fnd_message.get;
1360: put_line( fnd_file.log, x_error_text);
1361: x_error_text := SUBSTR(x_error_text, 1, 100);
1362: x_message := '----******************************************************----';
1363: put_line( fnd_file.log, x_message);

Line 1377: fnd_message.set_name('JL', 'JL_CO_GL_MG_FILE_SENT');

1373: WHEN HEADERS_STATUS_Y THEN
1374:
1375: x_message := '----***************** W A R N I N G **********************----';
1376: put_line( fnd_file.log, x_message);
1377: fnd_message.set_name('JL', 'JL_CO_GL_MG_FILE_SENT');
1378: fnd_message.set_token('YEAR', p_reported_year);
1379: x_error_text := fnd_message.get;
1380: put_line( fnd_file.log, x_error_text);
1381: x_error_text := SUBSTR(x_error_text, 1, 100);

Line 1378: fnd_message.set_token('YEAR', p_reported_year);

1374:
1375: x_message := '----***************** W A R N I N G **********************----';
1376: put_line( fnd_file.log, x_message);
1377: fnd_message.set_name('JL', 'JL_CO_GL_MG_FILE_SENT');
1378: fnd_message.set_token('YEAR', p_reported_year);
1379: x_error_text := fnd_message.get;
1380: put_line( fnd_file.log, x_error_text);
1381: x_error_text := SUBSTR(x_error_text, 1, 100);
1382: x_message := '----******************************************************----';

Line 1379: x_error_text := fnd_message.get;

1375: x_message := '----***************** W A R N I N G **********************----';
1376: put_line( fnd_file.log, x_message);
1377: fnd_message.set_name('JL', 'JL_CO_GL_MG_FILE_SENT');
1378: fnd_message.set_token('YEAR', p_reported_year);
1379: x_error_text := fnd_message.get;
1380: put_line( fnd_file.log, x_error_text);
1381: x_error_text := SUBSTR(x_error_text, 1, 100);
1382: x_message := '----******************************************************----';
1383: put_line( fnd_file.log, x_message);

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

1387: exception_text => x_error_text);
1388:
1389: WHEN OTHERS THEN
1390:
1391: fnd_message.set_name('JL', 'JL_CO_FA_GENERAL_ERROR');
1392: fnd_file.put_line( fnd_file.log, fnd_message.get);
1393: x_error_code := SQLCODE;
1394: x_error_text := SUBSTR(SQLERRM,1,200);
1395: ROLLBACK;

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

1388:
1389: WHEN OTHERS THEN
1390:
1391: fnd_message.set_name('JL', 'JL_CO_FA_GENERAL_ERROR');
1392: fnd_file.put_line( fnd_file.log, fnd_message.get);
1393: x_error_code := SQLCODE;
1394: x_error_text := SUBSTR(SQLERRM,1,200);
1395: ROLLBACK;
1396: RAISE_APPLICATION_ERROR( x_error_code, x_error_text);

Line 1482: fnd_message.set_name('FND', 'CONC-ARGUMENTS');

1478:
1479:
1480: BEGIN <>
1481:
1482: fnd_message.set_name('FND', 'CONC-ARGUMENTS');
1483: fnd_file.put_line( fnd_file.log, fnd_message.get);
1484: fnd_file.put_line(fnd_file.log, '----------------------------------------');
1485: fnd_message.set_name('JL', 'JL_CO_GL_MG_LEGAL_ENTITY_ID');
1486: fnd_message.set_token('LEGAL_ENTITY_ID', p_legal_entity_id);

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

1479:
1480: BEGIN <>
1481:
1482: fnd_message.set_name('FND', 'CONC-ARGUMENTS');
1483: fnd_file.put_line( fnd_file.log, fnd_message.get);
1484: fnd_file.put_line(fnd_file.log, '----------------------------------------');
1485: fnd_message.set_name('JL', 'JL_CO_GL_MG_LEGAL_ENTITY_ID');
1486: fnd_message.set_token('LEGAL_ENTITY_ID', p_legal_entity_id);
1487: put_line( fnd_file.log, fnd_message.get);

Line 1485: fnd_message.set_name('JL', 'JL_CO_GL_MG_LEGAL_ENTITY_ID');

1481:
1482: fnd_message.set_name('FND', 'CONC-ARGUMENTS');
1483: fnd_file.put_line( fnd_file.log, fnd_message.get);
1484: fnd_file.put_line(fnd_file.log, '----------------------------------------');
1485: fnd_message.set_name('JL', 'JL_CO_GL_MG_LEGAL_ENTITY_ID');
1486: fnd_message.set_token('LEGAL_ENTITY_ID', p_legal_entity_id);
1487: put_line( fnd_file.log, fnd_message.get);
1488: fnd_message.set_name('JL', 'JL_CO_GL_MG_SET_OF_BOOKS_ID');
1489: fnd_message.set_token('SET_OF_BOOKS_ID', p_set_of_books_id);

Line 1486: fnd_message.set_token('LEGAL_ENTITY_ID', p_legal_entity_id);

1482: fnd_message.set_name('FND', 'CONC-ARGUMENTS');
1483: fnd_file.put_line( fnd_file.log, fnd_message.get);
1484: fnd_file.put_line(fnd_file.log, '----------------------------------------');
1485: fnd_message.set_name('JL', 'JL_CO_GL_MG_LEGAL_ENTITY_ID');
1486: fnd_message.set_token('LEGAL_ENTITY_ID', p_legal_entity_id);
1487: put_line( fnd_file.log, fnd_message.get);
1488: fnd_message.set_name('JL', 'JL_CO_GL_MG_SET_OF_BOOKS_ID');
1489: fnd_message.set_token('SET_OF_BOOKS_ID', p_set_of_books_id);
1490: put_line( fnd_file.log, fnd_message.get);

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

1483: fnd_file.put_line( fnd_file.log, fnd_message.get);
1484: fnd_file.put_line(fnd_file.log, '----------------------------------------');
1485: fnd_message.set_name('JL', 'JL_CO_GL_MG_LEGAL_ENTITY_ID');
1486: fnd_message.set_token('LEGAL_ENTITY_ID', p_legal_entity_id);
1487: put_line( fnd_file.log, fnd_message.get);
1488: fnd_message.set_name('JL', 'JL_CO_GL_MG_SET_OF_BOOKS_ID');
1489: fnd_message.set_token('SET_OF_BOOKS_ID', p_set_of_books_id);
1490: put_line( fnd_file.log, fnd_message.get);
1491: fnd_message.set_name('JL', 'JL_CO_GL_MG_REPORTED_YEAR');

Line 1488: fnd_message.set_name('JL', 'JL_CO_GL_MG_SET_OF_BOOKS_ID');

1484: fnd_file.put_line(fnd_file.log, '----------------------------------------');
1485: fnd_message.set_name('JL', 'JL_CO_GL_MG_LEGAL_ENTITY_ID');
1486: fnd_message.set_token('LEGAL_ENTITY_ID', p_legal_entity_id);
1487: put_line( fnd_file.log, fnd_message.get);
1488: fnd_message.set_name('JL', 'JL_CO_GL_MG_SET_OF_BOOKS_ID');
1489: fnd_message.set_token('SET_OF_BOOKS_ID', p_set_of_books_id);
1490: put_line( fnd_file.log, fnd_message.get);
1491: fnd_message.set_name('JL', 'JL_CO_GL_MG_REPORTED_YEAR');
1492: fnd_message.set_token('REPORTED_YEAR', p_reported_year);

Line 1489: fnd_message.set_token('SET_OF_BOOKS_ID', p_set_of_books_id);

1485: fnd_message.set_name('JL', 'JL_CO_GL_MG_LEGAL_ENTITY_ID');
1486: fnd_message.set_token('LEGAL_ENTITY_ID', p_legal_entity_id);
1487: put_line( fnd_file.log, fnd_message.get);
1488: fnd_message.set_name('JL', 'JL_CO_GL_MG_SET_OF_BOOKS_ID');
1489: fnd_message.set_token('SET_OF_BOOKS_ID', p_set_of_books_id);
1490: put_line( fnd_file.log, fnd_message.get);
1491: fnd_message.set_name('JL', 'JL_CO_GL_MG_REPORTED_YEAR');
1492: fnd_message.set_token('REPORTED_YEAR', p_reported_year);
1493: put_line( fnd_file.log, fnd_message.get);

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

1486: fnd_message.set_token('LEGAL_ENTITY_ID', p_legal_entity_id);
1487: put_line( fnd_file.log, fnd_message.get);
1488: fnd_message.set_name('JL', 'JL_CO_GL_MG_SET_OF_BOOKS_ID');
1489: fnd_message.set_token('SET_OF_BOOKS_ID', p_set_of_books_id);
1490: put_line( fnd_file.log, fnd_message.get);
1491: fnd_message.set_name('JL', 'JL_CO_GL_MG_REPORTED_YEAR');
1492: fnd_message.set_token('REPORTED_YEAR', p_reported_year);
1493: put_line( fnd_file.log, fnd_message.get);
1494: fnd_message.set_name('JL', 'JL_CO_GL_MG_LABEL');

Line 1491: fnd_message.set_name('JL', 'JL_CO_GL_MG_REPORTED_YEAR');

1487: put_line( fnd_file.log, fnd_message.get);
1488: fnd_message.set_name('JL', 'JL_CO_GL_MG_SET_OF_BOOKS_ID');
1489: fnd_message.set_token('SET_OF_BOOKS_ID', p_set_of_books_id);
1490: put_line( fnd_file.log, fnd_message.get);
1491: fnd_message.set_name('JL', 'JL_CO_GL_MG_REPORTED_YEAR');
1492: fnd_message.set_token('REPORTED_YEAR', p_reported_year);
1493: put_line( fnd_file.log, fnd_message.get);
1494: fnd_message.set_name('JL', 'JL_CO_GL_MG_LABEL');
1495: fnd_message.set_token('LABEL', p_label);

Line 1492: fnd_message.set_token('REPORTED_YEAR', p_reported_year);

1488: fnd_message.set_name('JL', 'JL_CO_GL_MG_SET_OF_BOOKS_ID');
1489: fnd_message.set_token('SET_OF_BOOKS_ID', p_set_of_books_id);
1490: put_line( fnd_file.log, fnd_message.get);
1491: fnd_message.set_name('JL', 'JL_CO_GL_MG_REPORTED_YEAR');
1492: fnd_message.set_token('REPORTED_YEAR', p_reported_year);
1493: put_line( fnd_file.log, fnd_message.get);
1494: fnd_message.set_name('JL', 'JL_CO_GL_MG_LABEL');
1495: fnd_message.set_token('LABEL', p_label);
1496: put_line( fnd_file.log, fnd_message.get);

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

1489: fnd_message.set_token('SET_OF_BOOKS_ID', p_set_of_books_id);
1490: put_line( fnd_file.log, fnd_message.get);
1491: fnd_message.set_name('JL', 'JL_CO_GL_MG_REPORTED_YEAR');
1492: fnd_message.set_token('REPORTED_YEAR', p_reported_year);
1493: put_line( fnd_file.log, fnd_message.get);
1494: fnd_message.set_name('JL', 'JL_CO_GL_MG_LABEL');
1495: fnd_message.set_token('LABEL', p_label);
1496: put_line( fnd_file.log, fnd_message.get);
1497: fnd_file.put_line(fnd_file.log, '----------------------------------------');

Line 1494: fnd_message.set_name('JL', 'JL_CO_GL_MG_LABEL');

1490: put_line( fnd_file.log, fnd_message.get);
1491: fnd_message.set_name('JL', 'JL_CO_GL_MG_REPORTED_YEAR');
1492: fnd_message.set_token('REPORTED_YEAR', p_reported_year);
1493: put_line( fnd_file.log, fnd_message.get);
1494: fnd_message.set_name('JL', 'JL_CO_GL_MG_LABEL');
1495: fnd_message.set_token('LABEL', p_label);
1496: put_line( fnd_file.log, fnd_message.get);
1497: fnd_file.put_line(fnd_file.log, '----------------------------------------');
1498:

Line 1495: fnd_message.set_token('LABEL', p_label);

1491: fnd_message.set_name('JL', 'JL_CO_GL_MG_REPORTED_YEAR');
1492: fnd_message.set_token('REPORTED_YEAR', p_reported_year);
1493: put_line( fnd_file.log, fnd_message.get);
1494: fnd_message.set_name('JL', 'JL_CO_GL_MG_LABEL');
1495: fnd_message.set_token('LABEL', p_label);
1496: put_line( fnd_file.log, fnd_message.get);
1497: fnd_file.put_line(fnd_file.log, '----------------------------------------');
1498:
1499:

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

1492: fnd_message.set_token('REPORTED_YEAR', p_reported_year);
1493: put_line( fnd_file.log, fnd_message.get);
1494: fnd_message.set_name('JL', 'JL_CO_GL_MG_LABEL');
1495: fnd_message.set_token('LABEL', p_label);
1496: put_line( fnd_file.log, fnd_message.get);
1497: fnd_file.put_line(fnd_file.log, '----------------------------------------');
1498:
1499:
1500: /******************************************************

Line 1591: fnd_message.set_name('AR', 'GENERIC_MESSAGE');

1587: EXCEPTION
1588:
1589: WHEN NO_DATA_FOUND THEN
1590:
1591: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
1592: fnd_message.set_token('GENERIC_TEXT',
1593: 'Exception "NO_DATA_FOUND" while selecting company information');
1594: put_line(fnd_file.log, fnd_message.get);
1595: x_error_code := SQLCODE;

Line 1592: fnd_message.set_token('GENERIC_TEXT',

1588:
1589: WHEN NO_DATA_FOUND THEN
1590:
1591: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
1592: fnd_message.set_token('GENERIC_TEXT',
1593: 'Exception "NO_DATA_FOUND" while selecting company information');
1594: put_line(fnd_file.log, fnd_message.get);
1595: x_error_code := SQLCODE;
1596: x_error_text := SUBSTR(SQLERRM,1,200);

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

1590:
1591: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
1592: fnd_message.set_token('GENERIC_TEXT',
1593: 'Exception "NO_DATA_FOUND" while selecting company information');
1594: put_line(fnd_file.log, fnd_message.get);
1595: x_error_code := SQLCODE;
1596: x_error_text := SUBSTR(SQLERRM,1,200);
1597: RAISE_APPLICATION_ERROR( x_error_code, x_error_text);
1598:

Line 1601: fnd_message.set_name('AR', 'GENERIC_MESSAGE');

1597: RAISE_APPLICATION_ERROR( x_error_code, x_error_text);
1598:
1599: WHEN TOO_MANY_ROWS THEN
1600:
1601: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
1602: fnd_message.set_token('GENERIC_TEXT',
1603: 'Exception "TOO_MANY_ROWS" while selecting company information');
1604: put_line(fnd_file.log, fnd_message.get);
1605: x_error_code := SQLCODE;

Line 1602: fnd_message.set_token('GENERIC_TEXT',

1598:
1599: WHEN TOO_MANY_ROWS THEN
1600:
1601: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
1602: fnd_message.set_token('GENERIC_TEXT',
1603: 'Exception "TOO_MANY_ROWS" while selecting company information');
1604: put_line(fnd_file.log, fnd_message.get);
1605: x_error_code := SQLCODE;
1606: x_error_text := SUBSTR(SQLERRM,1,200);

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

1600:
1601: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
1602: fnd_message.set_token('GENERIC_TEXT',
1603: 'Exception "TOO_MANY_ROWS" while selecting company information');
1604: put_line(fnd_file.log, fnd_message.get);
1605: x_error_code := SQLCODE;
1606: x_error_text := SUBSTR(SQLERRM,1,200);
1607: RAISE_APPLICATION_ERROR( x_error_code, x_error_text);
1608:

Line 1611: fnd_message.set_name('AR', 'GENERIC_MESSAGE');

1607: RAISE_APPLICATION_ERROR( x_error_code, x_error_text);
1608:
1609: WHEN OTHERS THEN
1610:
1611: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
1612: fnd_message.set_token('GENERIC_TEXT',
1613: 'Exception "OTHERS" while selecting company information');
1614: put_line(fnd_file.log, fnd_message.get);
1615: x_error_code := SQLCODE;

Line 1612: fnd_message.set_token('GENERIC_TEXT',

1608:
1609: WHEN OTHERS THEN
1610:
1611: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
1612: fnd_message.set_token('GENERIC_TEXT',
1613: 'Exception "OTHERS" while selecting company information');
1614: put_line(fnd_file.log, fnd_message.get);
1615: x_error_code := SQLCODE;
1616: x_error_text := SUBSTR(SQLERRM,1,200);

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

1610:
1611: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
1612: fnd_message.set_token('GENERIC_TEXT',
1613: 'Exception "OTHERS" while selecting company information');
1614: put_line(fnd_file.log, fnd_message.get);
1615: x_error_code := SQLCODE;
1616: x_error_text := SUBSTR(SQLERRM,1,200);
1617: RAISE_APPLICATION_ERROR( x_error_code, x_error_text);
1618:

Line 1723: fnd_message.set_name('JL', 'JL_CO_GL_MG_INDENTI_REGISTER');

1719: **********************************************/
1720:
1721: put_line(fnd_file.output, identifi_register);
1722:
1723: fnd_message.set_name('JL', 'JL_CO_GL_MG_INDENTI_REGISTER');
1724: put_line( fnd_file.log, fnd_message.get);
1725:
1726: /****************************************
1727: Write movement_register to the flat file

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

1720:
1721: put_line(fnd_file.output, identifi_register);
1722:
1723: fnd_message.set_name('JL', 'JL_CO_GL_MG_INDENTI_REGISTER');
1724: put_line( fnd_file.log, fnd_message.get);
1725:
1726: /****************************************
1727: Write movement_register to the flat file
1728: ****************************************/

Line 1740: fnd_message.set_name('JL', 'JL_CO_GL_MG_MOVE_REGISTER');

1736: put_line(fnd_file.output, movement_register);
1737:
1738: END LOOP;
1739:
1740: fnd_message.set_name('JL', 'JL_CO_GL_MG_MOVE_REGISTER');
1741: fnd_message.set_token('NUMBER', tab_record_counter);
1742: put_line( fnd_file.log, fnd_message.get);
1743:
1744: ELSE

Line 1741: fnd_message.set_token('NUMBER', tab_record_counter);

1737:
1738: END LOOP;
1739:
1740: fnd_message.set_name('JL', 'JL_CO_GL_MG_MOVE_REGISTER');
1741: fnd_message.set_token('NUMBER', tab_record_counter);
1742: put_line( fnd_file.log, fnd_message.get);
1743:
1744: ELSE
1745:

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

1738: END LOOP;
1739:
1740: fnd_message.set_name('JL', 'JL_CO_GL_MG_MOVE_REGISTER');
1741: fnd_message.set_token('NUMBER', tab_record_counter);
1742: put_line( fnd_file.log, fnd_message.get);
1743:
1744: ELSE
1745:
1746: NULL;

Line 1748: fnd_message.set_name('JL', 'JL_CO_GL_MG_NO_MOVE_REGISTER');

1744: ELSE
1745:
1746: NULL;
1747:
1748: fnd_message.set_name('JL', 'JL_CO_GL_MG_NO_MOVE_REGISTER');
1749: x_message := fnd_message.get;
1750: put_line( fnd_file.log, x_message);
1751: put_line( fnd_file.output, x_message);
1752:

Line 1749: x_message := fnd_message.get;

1745:
1746: NULL;
1747:
1748: fnd_message.set_name('JL', 'JL_CO_GL_MG_NO_MOVE_REGISTER');
1749: x_message := fnd_message.get;
1750: put_line( fnd_file.log, x_message);
1751: put_line( fnd_file.output, x_message);
1752:
1753: END IF;

Line 1771: fnd_message.set_name('JL', 'JL_CO_GL_MG_CLOSE_REGISTER');

1767: **************************************/
1768:
1769: put_line(fnd_file.output, closed_register);
1770:
1771: fnd_message.set_name('JL', 'JL_CO_GL_MG_CLOSE_REGISTER');
1772: put_line( fnd_file.log, fnd_message.get);
1773:
1774: /********************************************
1775: Update the jl_co_gl_mg_headers.status to 'Y'

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

1768:
1769: put_line(fnd_file.output, closed_register);
1770:
1771: fnd_message.set_name('JL', 'JL_CO_GL_MG_CLOSE_REGISTER');
1772: put_line( fnd_file.log, fnd_message.get);
1773:
1774: /********************************************
1775: Update the jl_co_gl_mg_headers.status to 'Y'
1776: for final generation is done for DIAN

Line 1814: fnd_message.set_name('JL', 'JL_CO_GL_MG_FILE_SENT');

1810: WHEN HEADERS_STATUS_Y THEN
1811:
1812: x_message := '----***************** W A R N I N G **********************----';
1813: put_line( fnd_file.log, x_message);
1814: fnd_message.set_name('JL', 'JL_CO_GL_MG_FILE_SENT');
1815: fnd_message.set_token('YEAR', p_reported_year);
1816: x_error_text := fnd_message.get;
1817: put_line( fnd_file.log, x_error_text);
1818: x_error_text := SUBSTR(x_error_text, 1, 100);

Line 1815: fnd_message.set_token('YEAR', p_reported_year);

1811:
1812: x_message := '----***************** W A R N I N G **********************----';
1813: put_line( fnd_file.log, x_message);
1814: fnd_message.set_name('JL', 'JL_CO_GL_MG_FILE_SENT');
1815: fnd_message.set_token('YEAR', p_reported_year);
1816: x_error_text := fnd_message.get;
1817: put_line( fnd_file.log, x_error_text);
1818: x_error_text := SUBSTR(x_error_text, 1, 100);
1819: x_message := '----******************************************************----';

Line 1816: x_error_text := fnd_message.get;

1812: x_message := '----***************** W A R N I N G **********************----';
1813: put_line( fnd_file.log, x_message);
1814: fnd_message.set_name('JL', 'JL_CO_GL_MG_FILE_SENT');
1815: fnd_message.set_token('YEAR', p_reported_year);
1816: x_error_text := fnd_message.get;
1817: put_line( fnd_file.log, x_error_text);
1818: x_error_text := SUBSTR(x_error_text, 1, 100);
1819: x_message := '----******************************************************----';
1820: put_line( fnd_file.log, x_message);

Line 1831: fnd_message.set_name('JL', 'JL_CO_GL_MG_GEN_ALERT');

1827: WHEN MG_GENERAL_ALERT THEN
1828:
1829: x_message := '----***************** W A R N I N G **********************----';
1830: put_line( fnd_file.log, x_message);
1831: fnd_message.set_name('JL', 'JL_CO_GL_MG_GEN_ALERT');
1832: fnd_message.set_token('NUMBER', TO_CHAR(count_process_flag));
1833: fnd_message.set_token('TABLE', 'JL_CO_GL_MG_LITERALS');
1834: x_error_text := SUBSTR(fnd_message.get, 1, 200);
1835: put_line( fnd_file.log, x_error_text);

Line 1832: fnd_message.set_token('NUMBER', TO_CHAR(count_process_flag));

1828:
1829: x_message := '----***************** W A R N I N G **********************----';
1830: put_line( fnd_file.log, x_message);
1831: fnd_message.set_name('JL', 'JL_CO_GL_MG_GEN_ALERT');
1832: fnd_message.set_token('NUMBER', TO_CHAR(count_process_flag));
1833: fnd_message.set_token('TABLE', 'JL_CO_GL_MG_LITERALS');
1834: x_error_text := SUBSTR(fnd_message.get, 1, 200);
1835: put_line( fnd_file.log, x_error_text);
1836: x_error_text := SUBSTR(x_error_text, 1, 100);

Line 1833: fnd_message.set_token('TABLE', 'JL_CO_GL_MG_LITERALS');

1829: x_message := '----***************** W A R N I N G **********************----';
1830: put_line( fnd_file.log, x_message);
1831: fnd_message.set_name('JL', 'JL_CO_GL_MG_GEN_ALERT');
1832: fnd_message.set_token('NUMBER', TO_CHAR(count_process_flag));
1833: fnd_message.set_token('TABLE', 'JL_CO_GL_MG_LITERALS');
1834: x_error_text := SUBSTR(fnd_message.get, 1, 200);
1835: put_line( fnd_file.log, x_error_text);
1836: x_error_text := SUBSTR(x_error_text, 1, 100);
1837: x_message := '----******************************************************----';

Line 1834: x_error_text := SUBSTR(fnd_message.get, 1, 200);

1830: put_line( fnd_file.log, x_message);
1831: fnd_message.set_name('JL', 'JL_CO_GL_MG_GEN_ALERT');
1832: fnd_message.set_token('NUMBER', TO_CHAR(count_process_flag));
1833: fnd_message.set_token('TABLE', 'JL_CO_GL_MG_LITERALS');
1834: x_error_text := SUBSTR(fnd_message.get, 1, 200);
1835: put_line( fnd_file.log, x_error_text);
1836: x_error_text := SUBSTR(x_error_text, 1, 100);
1837: x_message := '----******************************************************----';
1838: put_line( fnd_file.log, x_message);

Line 1846: fnd_message.set_name('JL', 'JL_CO_GL_MG_NO_LOCATION_ID');

1842: exception_text => x_error_text);
1843:
1844: WHEN LOCATION_ID_DOES_NOT_EXIST THEN
1845:
1846: fnd_message.set_name('JL', 'JL_CO_GL_MG_NO_LOCATION_ID');
1847: x_error_text := SUBSTR(fnd_message.get, 1, 100);
1848: app_exception.raise_exception (exception_type => 'APP',
1849: exception_code =>
1850: jl_zz_fa_utilities_pkg.get_app_errnum('JL', 'JL_CO_GL_MG_NO_LOCATION_ID'),

Line 1847: x_error_text := SUBSTR(fnd_message.get, 1, 100);

1843:
1844: WHEN LOCATION_ID_DOES_NOT_EXIST THEN
1845:
1846: fnd_message.set_name('JL', 'JL_CO_GL_MG_NO_LOCATION_ID');
1847: x_error_text := SUBSTR(fnd_message.get, 1, 100);
1848: app_exception.raise_exception (exception_type => 'APP',
1849: exception_code =>
1850: jl_zz_fa_utilities_pkg.get_app_errnum('JL', 'JL_CO_GL_MG_NO_LOCATION_ID'),
1851: exception_text => x_error_text);

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

1851: exception_text => x_error_text);
1852:
1853: WHEN OTHERS THEN
1854:
1855: fnd_message.set_name('JL', 'JL_CO_FA_GENERAL_ERROR');
1856: fnd_file.put_line( fnd_file.log, fnd_message.get);
1857: x_error_code := SQLCODE;
1858: x_error_text := SUBSTR(SQLERRM,1,200);
1859: RAISE_APPLICATION_ERROR( x_error_code, x_error_text);

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

1852:
1853: WHEN OTHERS THEN
1854:
1855: fnd_message.set_name('JL', 'JL_CO_FA_GENERAL_ERROR');
1856: fnd_file.put_line( fnd_file.log, fnd_message.get);
1857: x_error_code := SQLCODE;
1858: x_error_text := SUBSTR(SQLERRM,1,200);
1859: RAISE_APPLICATION_ERROR( x_error_code, x_error_text);
1860: