DBA Data[Home] [Help]

APPS.GL_ENT_FUNC_BAL_UPGRADE_PKG dependencies on FND_LOG

Line 43: GL_MESSAGE.FUNC_ENT(fn_name, FND_LOG.LEVEL_PROCEDURE,

39: StdInterimInsertStr VARCHAR2(2200);
40: ccid_range VARCHAR2(100);
41: hint_txt VARCHAR2(500);
42: BEGIN
43: GL_MESSAGE.FUNC_ENT(fn_name, FND_LOG.LEVEL_PROCEDURE,
44: g_api || '.' || fn_name);
45: -- parameters
46: GL_MESSAGE.WRITE_FNDLOG_STRING(FND_LOG.LEVEL_PROCEDURE,
47: g_api || '.' || fn_name,

Line 46: GL_MESSAGE.WRITE_FNDLOG_STRING(FND_LOG.LEVEL_PROCEDURE,

42: BEGIN
43: GL_MESSAGE.FUNC_ENT(fn_name, FND_LOG.LEVEL_PROCEDURE,
44: g_api || '.' || fn_name);
45: -- parameters
46: GL_MESSAGE.WRITE_FNDLOG_STRING(FND_LOG.LEVEL_PROCEDURE,
47: g_api || '.' || fn_name,
48: 'x_src_table = ' || x_src_table);
49: GL_MESSAGE.WRITE_FNDLOG_STRING(FND_LOG.LEVEL_PROCEDURE,
50: g_api || '.' || fn_name,

Line 49: GL_MESSAGE.WRITE_FNDLOG_STRING(FND_LOG.LEVEL_PROCEDURE,

45: -- parameters
46: GL_MESSAGE.WRITE_FNDLOG_STRING(FND_LOG.LEVEL_PROCEDURE,
47: g_api || '.' || fn_name,
48: 'x_src_table = ' || x_src_table);
49: GL_MESSAGE.WRITE_FNDLOG_STRING(FND_LOG.LEVEL_PROCEDURE,
50: g_api || '.' || fn_name,
51: 'x_start_id = ' || x_start_id);
52: GL_MESSAGE.WRITE_FNDLOG_STRING(FND_LOG.LEVEL_PROCEDURE,
53: g_api || '.' || fn_name,

Line 52: GL_MESSAGE.WRITE_FNDLOG_STRING(FND_LOG.LEVEL_PROCEDURE,

48: 'x_src_table = ' || x_src_table);
49: GL_MESSAGE.WRITE_FNDLOG_STRING(FND_LOG.LEVEL_PROCEDURE,
50: g_api || '.' || fn_name,
51: 'x_start_id = ' || x_start_id);
52: GL_MESSAGE.WRITE_FNDLOG_STRING(FND_LOG.LEVEL_PROCEDURE,
53: g_api || '.' || fn_name,
54: 'x_end_id = ' || x_end_id);
55:
56: IF (x_src_table = g_std_bal_table) THEN

Line 120: GL_MESSAGE.FUNC_SUCC(fn_name, FND_LOG.LEVEL_PROCEDURE,

116: ELSE
117: EXECUTE IMMEDIATE StdInterimInsertStr;
118: END IF;
119:
120: GL_MESSAGE.FUNC_SUCC(fn_name, FND_LOG.LEVEL_PROCEDURE,
121: g_api || '.' || fn_name);
122: EXCEPTION
123: WHEN OTHERS THEN
124: GL_MESSAGE.WRITE_FNDLOG_STRING(FND_LOG.LEVEL_UNEXPECTED,

Line 124: GL_MESSAGE.WRITE_FNDLOG_STRING(FND_LOG.LEVEL_UNEXPECTED,

120: GL_MESSAGE.FUNC_SUCC(fn_name, FND_LOG.LEVEL_PROCEDURE,
121: g_api || '.' || fn_name);
122: EXCEPTION
123: WHEN OTHERS THEN
124: GL_MESSAGE.WRITE_FNDLOG_STRING(FND_LOG.LEVEL_UNEXPECTED,
125: g_api || '.' || fn_name,
126: SUBSTR(SQLERRM, 1, 4000));
127: GL_MESSAGE.FUNC_FAIL(fn_name, FND_LOG.LEVEL_UNEXPECTED,
128: g_api || '.' || fn_name);

Line 127: GL_MESSAGE.FUNC_FAIL(fn_name, FND_LOG.LEVEL_UNEXPECTED,

123: WHEN OTHERS THEN
124: GL_MESSAGE.WRITE_FNDLOG_STRING(FND_LOG.LEVEL_UNEXPECTED,
125: g_api || '.' || fn_name,
126: SUBSTR(SQLERRM, 1, 4000));
127: GL_MESSAGE.FUNC_FAIL(fn_name, FND_LOG.LEVEL_UNEXPECTED,
128: g_api || '.' || fn_name);
129: RAISE;
130: END prepare_std_bal_gt;
131:

Line 154: GL_MESSAGE.FUNC_ENT(fn_name, FND_LOG.LEVEL_PROCEDURE,

150: StdUpdateFrgnEntBalStr VARCHAR2(1000);
151: bal_where_clause VARCHAR2(200);
152: hint_txt VARCHAR2(500);
153: BEGIN
154: GL_MESSAGE.FUNC_ENT(fn_name, FND_LOG.LEVEL_PROCEDURE,
155: g_api || '.' || fn_name);
156: -- parameters
157: GL_MESSAGE.WRITE_FNDLOG_STRING(FND_LOG.LEVEL_PROCEDURE,
158: g_api || '.' || fn_name,

Line 157: GL_MESSAGE.WRITE_FNDLOG_STRING(FND_LOG.LEVEL_PROCEDURE,

153: BEGIN
154: GL_MESSAGE.FUNC_ENT(fn_name, FND_LOG.LEVEL_PROCEDURE,
155: g_api || '.' || fn_name);
156: -- parameters
157: GL_MESSAGE.WRITE_FNDLOG_STRING(FND_LOG.LEVEL_PROCEDURE,
158: g_api || '.' || fn_name,
159: 'x_src_table = ' || x_src_table);
160: GL_MESSAGE.WRITE_FNDLOG_STRING(FND_LOG.LEVEL_PROCEDURE,
161: g_api || '.' || fn_name,

Line 160: GL_MESSAGE.WRITE_FNDLOG_STRING(FND_LOG.LEVEL_PROCEDURE,

156: -- parameters
157: GL_MESSAGE.WRITE_FNDLOG_STRING(FND_LOG.LEVEL_PROCEDURE,
158: g_api || '.' || fn_name,
159: 'x_src_table = ' || x_src_table);
160: GL_MESSAGE.WRITE_FNDLOG_STRING(FND_LOG.LEVEL_PROCEDURE,
161: g_api || '.' || fn_name,
162: 'x_start_id = ' || x_start_id);
163: GL_MESSAGE.WRITE_FNDLOG_STRING(FND_LOG.LEVEL_PROCEDURE,
164: g_api || '.' || fn_name,

Line 163: GL_MESSAGE.WRITE_FNDLOG_STRING(FND_LOG.LEVEL_PROCEDURE,

159: 'x_src_table = ' || x_src_table);
160: GL_MESSAGE.WRITE_FNDLOG_STRING(FND_LOG.LEVEL_PROCEDURE,
161: g_api || '.' || fn_name,
162: 'x_start_id = ' || x_start_id);
163: GL_MESSAGE.WRITE_FNDLOG_STRING(FND_LOG.LEVEL_PROCEDURE,
164: g_api || '.' || fn_name,
165: 'x_end_id = ' || x_end_id);
166:
167: IF (x_src_table = g_std_bal_table) THEN

Line 202: GL_MESSAGE.FUNC_SUCC(fn_name, FND_LOG.LEVEL_PROCEDURE,

198: ELSE
199: EXECUTE IMMEDIATE StdUpdateFrgnEntBalStr;
200: END IF;
201:
202: GL_MESSAGE.FUNC_SUCC(fn_name, FND_LOG.LEVEL_PROCEDURE,
203: g_api || '.' || fn_name);
204: EXCEPTION
205: WHEN OTHERS THEN
206: GL_MESSAGE.WRITE_FNDLOG_STRING(FND_LOG.LEVEL_UNEXPECTED,

Line 206: GL_MESSAGE.WRITE_FNDLOG_STRING(FND_LOG.LEVEL_UNEXPECTED,

202: GL_MESSAGE.FUNC_SUCC(fn_name, FND_LOG.LEVEL_PROCEDURE,
203: g_api || '.' || fn_name);
204: EXCEPTION
205: WHEN OTHERS THEN
206: GL_MESSAGE.WRITE_FNDLOG_STRING(FND_LOG.LEVEL_UNEXPECTED,
207: g_api || '.' || fn_name,
208: SUBSTR(SQLERRM, 1, 4000));
209: GL_MESSAGE.FUNC_FAIL(fn_name, FND_LOG.LEVEL_UNEXPECTED,
210: g_api || '.' || fn_name);

Line 209: GL_MESSAGE.FUNC_FAIL(fn_name, FND_LOG.LEVEL_UNEXPECTED,

205: WHEN OTHERS THEN
206: GL_MESSAGE.WRITE_FNDLOG_STRING(FND_LOG.LEVEL_UNEXPECTED,
207: g_api || '.' || fn_name,
208: SUBSTR(SQLERRM, 1, 4000));
209: GL_MESSAGE.FUNC_FAIL(fn_name, FND_LOG.LEVEL_UNEXPECTED,
210: g_api || '.' || fn_name);
211: RAISE;
212: END update_std_foreign_ent_bal;
213:

Line 236: GL_MESSAGE.FUNC_ENT(fn_name, FND_LOG.LEVEL_PROCEDURE,

232: StdUpdateFuncEntBalStr VARCHAR2(1400);
233: ccid_range VARCHAR2(100);
234: hint_txt VARCHAR2(500);
235: BEGIN
236: GL_MESSAGE.FUNC_ENT(fn_name, FND_LOG.LEVEL_PROCEDURE,
237: g_api || '.' || fn_name);
238: -- parameters
239: GL_MESSAGE.WRITE_FNDLOG_STRING(FND_LOG.LEVEL_PROCEDURE,
240: g_api || '.' || fn_name,

Line 239: GL_MESSAGE.WRITE_FNDLOG_STRING(FND_LOG.LEVEL_PROCEDURE,

235: BEGIN
236: GL_MESSAGE.FUNC_ENT(fn_name, FND_LOG.LEVEL_PROCEDURE,
237: g_api || '.' || fn_name);
238: -- parameters
239: GL_MESSAGE.WRITE_FNDLOG_STRING(FND_LOG.LEVEL_PROCEDURE,
240: g_api || '.' || fn_name,
241: 'x_src_table = ' || x_src_table);
242: GL_MESSAGE.WRITE_FNDLOG_STRING(FND_LOG.LEVEL_PROCEDURE,
243: g_api || '.' || fn_name,

Line 242: GL_MESSAGE.WRITE_FNDLOG_STRING(FND_LOG.LEVEL_PROCEDURE,

238: -- parameters
239: GL_MESSAGE.WRITE_FNDLOG_STRING(FND_LOG.LEVEL_PROCEDURE,
240: g_api || '.' || fn_name,
241: 'x_src_table = ' || x_src_table);
242: GL_MESSAGE.WRITE_FNDLOG_STRING(FND_LOG.LEVEL_PROCEDURE,
243: g_api || '.' || fn_name,
244: 'x_start_id = ' || x_start_id);
245: GL_MESSAGE.WRITE_FNDLOG_STRING(FND_LOG.LEVEL_PROCEDURE,
246: g_api || '.' || fn_name,

Line 245: GL_MESSAGE.WRITE_FNDLOG_STRING(FND_LOG.LEVEL_PROCEDURE,

241: 'x_src_table = ' || x_src_table);
242: GL_MESSAGE.WRITE_FNDLOG_STRING(FND_LOG.LEVEL_PROCEDURE,
243: g_api || '.' || fn_name,
244: 'x_start_id = ' || x_start_id);
245: GL_MESSAGE.WRITE_FNDLOG_STRING(FND_LOG.LEVEL_PROCEDURE,
246: g_api || '.' || fn_name,
247: 'x_end_id = ' || x_end_id);
248:
249: IF (x_src_table = g_std_bal_table) THEN

Line 294: GL_MESSAGE.FUNC_SUCC(fn_name, FND_LOG.LEVEL_PROCEDURE,

290: ELSE
291: EXECUTE IMMEDIATE StdUpdateFuncEntBalStr;
292: END IF;
293:
294: GL_MESSAGE.FUNC_SUCC(fn_name, FND_LOG.LEVEL_PROCEDURE,
295: g_api || '.' || fn_name);
296: EXCEPTION
297: WHEN OTHERS THEN
298: GL_MESSAGE.WRITE_FNDLOG_STRING(FND_LOG.LEVEL_UNEXPECTED,

Line 298: GL_MESSAGE.WRITE_FNDLOG_STRING(FND_LOG.LEVEL_UNEXPECTED,

294: GL_MESSAGE.FUNC_SUCC(fn_name, FND_LOG.LEVEL_PROCEDURE,
295: g_api || '.' || fn_name);
296: EXCEPTION
297: WHEN OTHERS THEN
298: GL_MESSAGE.WRITE_FNDLOG_STRING(FND_LOG.LEVEL_UNEXPECTED,
299: g_api || '.' || fn_name,
300: SUBSTR(SQLERRM, 1, 4000));
301: GL_MESSAGE.FUNC_FAIL(fn_name, FND_LOG.LEVEL_UNEXPECTED,
302: g_api || '.' || fn_name);

Line 301: GL_MESSAGE.FUNC_FAIL(fn_name, FND_LOG.LEVEL_UNEXPECTED,

297: WHEN OTHERS THEN
298: GL_MESSAGE.WRITE_FNDLOG_STRING(FND_LOG.LEVEL_UNEXPECTED,
299: g_api || '.' || fn_name,
300: SUBSTR(SQLERRM, 1, 4000));
301: GL_MESSAGE.FUNC_FAIL(fn_name, FND_LOG.LEVEL_UNEXPECTED,
302: g_api || '.' || fn_name);
303: RAISE;
304: END update_std_func_ent_bal;
305:

Line 327: GL_MESSAGE.FUNC_ENT(fn_name, FND_LOG.LEVEL_PROCEDURE,

323: fn_name CONSTANT VARCHAR2(30) := 'PREPARE_ADB_BAL_GT';
324: AdbInterimInsertStr VARCHAR2(8000);
325: ccid_range VARCHAR2(100);
326: BEGIN
327: GL_MESSAGE.FUNC_ENT(fn_name, FND_LOG.LEVEL_PROCEDURE,
328: g_api || '.' || fn_name);
329: -- parameters
330: GL_MESSAGE.WRITE_FNDLOG_STRING(FND_LOG.LEVEL_PROCEDURE,
331: g_api || '.' || fn_name,

Line 330: GL_MESSAGE.WRITE_FNDLOG_STRING(FND_LOG.LEVEL_PROCEDURE,

326: BEGIN
327: GL_MESSAGE.FUNC_ENT(fn_name, FND_LOG.LEVEL_PROCEDURE,
328: g_api || '.' || fn_name);
329: -- parameters
330: GL_MESSAGE.WRITE_FNDLOG_STRING(FND_LOG.LEVEL_PROCEDURE,
331: g_api || '.' || fn_name,
332: 'x_src_table = ' || x_src_table);
333: GL_MESSAGE.WRITE_FNDLOG_STRING(FND_LOG.LEVEL_PROCEDURE,
334: g_api || '.' || fn_name,

Line 333: GL_MESSAGE.WRITE_FNDLOG_STRING(FND_LOG.LEVEL_PROCEDURE,

329: -- parameters
330: GL_MESSAGE.WRITE_FNDLOG_STRING(FND_LOG.LEVEL_PROCEDURE,
331: g_api || '.' || fn_name,
332: 'x_src_table = ' || x_src_table);
333: GL_MESSAGE.WRITE_FNDLOG_STRING(FND_LOG.LEVEL_PROCEDURE,
334: g_api || '.' || fn_name,
335: 'x_start_id = ' || x_start_id);
336: GL_MESSAGE.WRITE_FNDLOG_STRING(FND_LOG.LEVEL_PROCEDURE,
337: g_api || '.' || fn_name,

Line 336: GL_MESSAGE.WRITE_FNDLOG_STRING(FND_LOG.LEVEL_PROCEDURE,

332: 'x_src_table = ' || x_src_table);
333: GL_MESSAGE.WRITE_FNDLOG_STRING(FND_LOG.LEVEL_PROCEDURE,
334: g_api || '.' || fn_name,
335: 'x_start_id = ' || x_start_id);
336: GL_MESSAGE.WRITE_FNDLOG_STRING(FND_LOG.LEVEL_PROCEDURE,
337: g_api || '.' || fn_name,
338: 'x_end_id = ' || x_end_id);
339:
340: IF (x_src_table = g_adb_bal_table) THEN

Line 503: GL_MESSAGE.FUNC_SUCC(fn_name, FND_LOG.LEVEL_PROCEDURE,

499: ELSE
500: EXECUTE IMMEDIATE AdbInterimInsertStr;
501: END IF;
502:
503: GL_MESSAGE.FUNC_SUCC(fn_name, FND_LOG.LEVEL_PROCEDURE,
504: g_api || '.' || fn_name);
505: EXCEPTION
506: WHEN OTHERS THEN
507: GL_MESSAGE.WRITE_FNDLOG_STRING(FND_LOG.LEVEL_UNEXPECTED,

Line 507: GL_MESSAGE.WRITE_FNDLOG_STRING(FND_LOG.LEVEL_UNEXPECTED,

503: GL_MESSAGE.FUNC_SUCC(fn_name, FND_LOG.LEVEL_PROCEDURE,
504: g_api || '.' || fn_name);
505: EXCEPTION
506: WHEN OTHERS THEN
507: GL_MESSAGE.WRITE_FNDLOG_STRING(FND_LOG.LEVEL_UNEXPECTED,
508: g_api || '.' || fn_name,
509: SUBSTR(SQLERRM, 1, 4000));
510: GL_MESSAGE.FUNC_FAIL(fn_name, FND_LOG.LEVEL_UNEXPECTED,
511: g_api || '.' || fn_name);

Line 510: GL_MESSAGE.FUNC_FAIL(fn_name, FND_LOG.LEVEL_UNEXPECTED,

506: WHEN OTHERS THEN
507: GL_MESSAGE.WRITE_FNDLOG_STRING(FND_LOG.LEVEL_UNEXPECTED,
508: g_api || '.' || fn_name,
509: SUBSTR(SQLERRM, 1, 4000));
510: GL_MESSAGE.FUNC_FAIL(fn_name, FND_LOG.LEVEL_UNEXPECTED,
511: g_api || '.' || fn_name);
512: RAISE;
513: END prepare_adb_bal_gt;
514:

Line 536: GL_MESSAGE.FUNC_ENT(fn_name, FND_LOG.LEVEL_PROCEDURE,

532: fn_name CONSTANT VARCHAR2(30) := 'UPDATE_ADB_FUNC_ENT_BAL';
533: AdbUpdateFuncEntBalStr VARCHAR2(2600);
534: ccid_range VARCHAR2(200);
535: BEGIN
536: GL_MESSAGE.FUNC_ENT(fn_name, FND_LOG.LEVEL_PROCEDURE,
537: g_api || '.' || fn_name);
538: -- parameters
539: GL_MESSAGE.WRITE_FNDLOG_STRING(FND_LOG.LEVEL_PROCEDURE,
540: g_api || '.' || fn_name,

Line 539: GL_MESSAGE.WRITE_FNDLOG_STRING(FND_LOG.LEVEL_PROCEDURE,

535: BEGIN
536: GL_MESSAGE.FUNC_ENT(fn_name, FND_LOG.LEVEL_PROCEDURE,
537: g_api || '.' || fn_name);
538: -- parameters
539: GL_MESSAGE.WRITE_FNDLOG_STRING(FND_LOG.LEVEL_PROCEDURE,
540: g_api || '.' || fn_name,
541: 'x_src_table = ' || x_src_table);
542: GL_MESSAGE.WRITE_FNDLOG_STRING(FND_LOG.LEVEL_PROCEDURE,
543: g_api || '.' || fn_name,

Line 542: GL_MESSAGE.WRITE_FNDLOG_STRING(FND_LOG.LEVEL_PROCEDURE,

538: -- parameters
539: GL_MESSAGE.WRITE_FNDLOG_STRING(FND_LOG.LEVEL_PROCEDURE,
540: g_api || '.' || fn_name,
541: 'x_src_table = ' || x_src_table);
542: GL_MESSAGE.WRITE_FNDLOG_STRING(FND_LOG.LEVEL_PROCEDURE,
543: g_api || '.' || fn_name,
544: 'x_start_id = ' || x_start_id);
545: GL_MESSAGE.WRITE_FNDLOG_STRING(FND_LOG.LEVEL_PROCEDURE,
546: g_api || '.' || fn_name,

Line 545: GL_MESSAGE.WRITE_FNDLOG_STRING(FND_LOG.LEVEL_PROCEDURE,

541: 'x_src_table = ' || x_src_table);
542: GL_MESSAGE.WRITE_FNDLOG_STRING(FND_LOG.LEVEL_PROCEDURE,
543: g_api || '.' || fn_name,
544: 'x_start_id = ' || x_start_id);
545: GL_MESSAGE.WRITE_FNDLOG_STRING(FND_LOG.LEVEL_PROCEDURE,
546: g_api || '.' || fn_name,
547: 'x_end_id = ' || x_end_id);
548:
549: IF (x_src_table = g_adb_bal_table) THEN

Line 621: GL_MESSAGE.FUNC_SUCC(fn_name, FND_LOG.LEVEL_PROCEDURE,

617: ELSE
618: EXECUTE IMMEDIATE AdbUpdateFuncEntBalStr;
619: END IF;
620:
621: GL_MESSAGE.FUNC_SUCC(fn_name, FND_LOG.LEVEL_PROCEDURE,
622: g_api || '.' || fn_name);
623: EXCEPTION
624: WHEN OTHERS THEN
625: GL_MESSAGE.WRITE_FNDLOG_STRING(FND_LOG.LEVEL_UNEXPECTED,

Line 625: GL_MESSAGE.WRITE_FNDLOG_STRING(FND_LOG.LEVEL_UNEXPECTED,

621: GL_MESSAGE.FUNC_SUCC(fn_name, FND_LOG.LEVEL_PROCEDURE,
622: g_api || '.' || fn_name);
623: EXCEPTION
624: WHEN OTHERS THEN
625: GL_MESSAGE.WRITE_FNDLOG_STRING(FND_LOG.LEVEL_UNEXPECTED,
626: g_api || '.' || fn_name,
627: SUBSTR(SQLERRM, 1, 4000));
628: GL_MESSAGE.FUNC_FAIL(fn_name, FND_LOG.LEVEL_UNEXPECTED,
629: g_api || '.' || fn_name);

Line 628: GL_MESSAGE.FUNC_FAIL(fn_name, FND_LOG.LEVEL_UNEXPECTED,

624: WHEN OTHERS THEN
625: GL_MESSAGE.WRITE_FNDLOG_STRING(FND_LOG.LEVEL_UNEXPECTED,
626: g_api || '.' || fn_name,
627: SUBSTR(SQLERRM, 1, 4000));
628: GL_MESSAGE.FUNC_FAIL(fn_name, FND_LOG.LEVEL_UNEXPECTED,
629: g_api || '.' || fn_name);
630: RAISE;
631: END update_adb_func_ent_bal;
632:

Line 652: GL_MESSAGE.FUNC_ENT(fn_name, FND_LOG.LEVEL_PROCEDURE,

648:
649: l_who_cols VARCHAR2(150);
650: l_who_vals VARCHAR2(30);
651: BEGIN
652: GL_MESSAGE.FUNC_ENT(fn_name, FND_LOG.LEVEL_PROCEDURE,
653: g_api || '.' || fn_name);
654: -- parameters
655: GL_MESSAGE.WRITE_FNDLOG_STRING(FND_LOG.LEVEL_PROCEDURE,
656: g_api || '.' || fn_name,

Line 655: GL_MESSAGE.WRITE_FNDLOG_STRING(FND_LOG.LEVEL_PROCEDURE,

651: BEGIN
652: GL_MESSAGE.FUNC_ENT(fn_name, FND_LOG.LEVEL_PROCEDURE,
653: g_api || '.' || fn_name);
654: -- parameters
655: GL_MESSAGE.WRITE_FNDLOG_STRING(FND_LOG.LEVEL_PROCEDURE,
656: g_api || '.' || fn_name,
657: 'x_src_table = ' || x_src_table);
658:
659: IF (x_src_table = g_adb_bal_table) THEN

Line 729: GL_MESSAGE.FUNC_SUCC(fn_name, FND_LOG.LEVEL_PROCEDURE,

725: ' and b2.converted_from_currency is null)';
726:
727: EXECUTE IMMEDIATE AdbInsertFuncEntBalStr;
728:
729: GL_MESSAGE.FUNC_SUCC(fn_name, FND_LOG.LEVEL_PROCEDURE,
730: g_api || '.' || fn_name);
731: EXCEPTION
732: WHEN OTHERS THEN
733: GL_MESSAGE.WRITE_FNDLOG_STRING(FND_LOG.LEVEL_UNEXPECTED,

Line 733: GL_MESSAGE.WRITE_FNDLOG_STRING(FND_LOG.LEVEL_UNEXPECTED,

729: GL_MESSAGE.FUNC_SUCC(fn_name, FND_LOG.LEVEL_PROCEDURE,
730: g_api || '.' || fn_name);
731: EXCEPTION
732: WHEN OTHERS THEN
733: GL_MESSAGE.WRITE_FNDLOG_STRING(FND_LOG.LEVEL_UNEXPECTED,
734: g_api || '.' || fn_name,
735: SUBSTR(SQLERRM, 1, 4000));
736: GL_MESSAGE.FUNC_FAIL(fn_name, FND_LOG.LEVEL_UNEXPECTED,
737: g_api || '.' || fn_name);

Line 736: GL_MESSAGE.FUNC_FAIL(fn_name, FND_LOG.LEVEL_UNEXPECTED,

732: WHEN OTHERS THEN
733: GL_MESSAGE.WRITE_FNDLOG_STRING(FND_LOG.LEVEL_UNEXPECTED,
734: g_api || '.' || fn_name,
735: SUBSTR(SQLERRM, 1, 4000));
736: GL_MESSAGE.FUNC_FAIL(fn_name, FND_LOG.LEVEL_UNEXPECTED,
737: g_api || '.' || fn_name);
738: RAISE;
739: END insert_adb_func_ent_bal;
740:

Line 765: GL_MESSAGE.FUNC_ENT(fn_name, FND_LOG.LEVEL_PROCEDURE,

761: fn_name CONSTANT VARCHAR2(30) := 'CHECK_MM_TABLE_COLUMN';
762: l_table_exists NUMBER := 0;
763: l_column_exists NUMBER := 0;
764: BEGIN
765: GL_MESSAGE.FUNC_ENT(fn_name, FND_LOG.LEVEL_PROCEDURE,
766: g_api || '.' || fn_name);
767: -- parameters
768: GL_MESSAGE.WRITE_FNDLOG_STRING(FND_LOG.LEVEL_PROCEDURE,
769: g_api || '.' || fn_name,

Line 768: GL_MESSAGE.WRITE_FNDLOG_STRING(FND_LOG.LEVEL_PROCEDURE,

764: BEGIN
765: GL_MESSAGE.FUNC_ENT(fn_name, FND_LOG.LEVEL_PROCEDURE,
766: g_api || '.' || fn_name);
767: -- parameters
768: GL_MESSAGE.WRITE_FNDLOG_STRING(FND_LOG.LEVEL_PROCEDURE,
769: g_api || '.' || fn_name,
770: 'x_gl_schema = ' || x_gl_schema);
771: GL_MESSAGE.WRITE_FNDLOG_STRING(FND_LOG.LEVEL_PROCEDURE,
772: g_api || '.' || fn_name,

Line 771: GL_MESSAGE.WRITE_FNDLOG_STRING(FND_LOG.LEVEL_PROCEDURE,

767: -- parameters
768: GL_MESSAGE.WRITE_FNDLOG_STRING(FND_LOG.LEVEL_PROCEDURE,
769: g_api || '.' || fn_name,
770: 'x_gl_schema = ' || x_gl_schema);
771: GL_MESSAGE.WRITE_FNDLOG_STRING(FND_LOG.LEVEL_PROCEDURE,
772: g_api || '.' || fn_name,
773: 'x_table_name = ' || x_table_name);
774:
775: x_table_exists := FALSE;

Line 802: GL_MESSAGE.WRITE_FNDLOG_STRING(FND_LOG.LEVEL_PROCEDURE,

798: END IF;
799: END IF;
800:
801: -- out parameters (print the local variables)
802: GL_MESSAGE.WRITE_FNDLOG_STRING(FND_LOG.LEVEL_PROCEDURE,
803: g_api || '.' || fn_name,
804: 'l_table_exists = ' || l_table_exists);
805: GL_MESSAGE.WRITE_FNDLOG_STRING(FND_LOG.LEVEL_PROCEDURE,
806: g_api || '.' || fn_name,

Line 805: GL_MESSAGE.WRITE_FNDLOG_STRING(FND_LOG.LEVEL_PROCEDURE,

801: -- out parameters (print the local variables)
802: GL_MESSAGE.WRITE_FNDLOG_STRING(FND_LOG.LEVEL_PROCEDURE,
803: g_api || '.' || fn_name,
804: 'l_table_exists = ' || l_table_exists);
805: GL_MESSAGE.WRITE_FNDLOG_STRING(FND_LOG.LEVEL_PROCEDURE,
806: g_api || '.' || fn_name,
807: 'l_column_exists = ' || l_column_exists);
808: GL_MESSAGE.FUNC_SUCC(fn_name, FND_LOG.LEVEL_PROCEDURE,
809: g_api || '.' || fn_name);

Line 808: GL_MESSAGE.FUNC_SUCC(fn_name, FND_LOG.LEVEL_PROCEDURE,

804: 'l_table_exists = ' || l_table_exists);
805: GL_MESSAGE.WRITE_FNDLOG_STRING(FND_LOG.LEVEL_PROCEDURE,
806: g_api || '.' || fn_name,
807: 'l_column_exists = ' || l_column_exists);
808: GL_MESSAGE.FUNC_SUCC(fn_name, FND_LOG.LEVEL_PROCEDURE,
809: g_api || '.' || fn_name);
810: EXCEPTION
811: WHEN OTHERS THEN
812: GL_MESSAGE.WRITE_FNDLOG_STRING(FND_LOG.LEVEL_UNEXPECTED,

Line 812: GL_MESSAGE.WRITE_FNDLOG_STRING(FND_LOG.LEVEL_UNEXPECTED,

808: GL_MESSAGE.FUNC_SUCC(fn_name, FND_LOG.LEVEL_PROCEDURE,
809: g_api || '.' || fn_name);
810: EXCEPTION
811: WHEN OTHERS THEN
812: GL_MESSAGE.WRITE_FNDLOG_STRING(FND_LOG.LEVEL_UNEXPECTED,
813: g_api || '.' || fn_name,
814: SUBSTR(SQLERRM, 1, 4000));
815: GL_MESSAGE.FUNC_FAIL(fn_name, FND_LOG.LEVEL_UNEXPECTED,
816: g_api || '.' || fn_name);

Line 815: GL_MESSAGE.FUNC_FAIL(fn_name, FND_LOG.LEVEL_UNEXPECTED,

811: WHEN OTHERS THEN
812: GL_MESSAGE.WRITE_FNDLOG_STRING(FND_LOG.LEVEL_UNEXPECTED,
813: g_api || '.' || fn_name,
814: SUBSTR(SQLERRM, 1, 4000));
815: GL_MESSAGE.FUNC_FAIL(fn_name, FND_LOG.LEVEL_UNEXPECTED,
816: g_api || '.' || fn_name);
817: RAISE;
818: END check_mm_table_column;
819:

Line 843: GL_MESSAGE.FUNC_ENT(fn_name, FND_LOG.LEVEL_PROCEDURE,

839: l_column_exists BOOLEAN;
840:
841: sql_stmt VARCHAR2(200);
842: BEGIN
843: GL_MESSAGE.FUNC_ENT(fn_name, FND_LOG.LEVEL_PROCEDURE,
844: g_api || '.' || fn_name);
845: -- parameters
846: GL_MESSAGE.WRITE_FNDLOG_STRING(FND_LOG.LEVEL_PROCEDURE,
847: g_api || '.' || fn_name,

Line 846: GL_MESSAGE.WRITE_FNDLOG_STRING(FND_LOG.LEVEL_PROCEDURE,

842: BEGIN
843: GL_MESSAGE.FUNC_ENT(fn_name, FND_LOG.LEVEL_PROCEDURE,
844: g_api || '.' || fn_name);
845: -- parameters
846: GL_MESSAGE.WRITE_FNDLOG_STRING(FND_LOG.LEVEL_PROCEDURE,
847: g_api || '.' || fn_name,
848: 'x_mm_request_id = ' || x_mm_request_id);
849: GL_MESSAGE.WRITE_FNDLOG_STRING(FND_LOG.LEVEL_PROCEDURE,
850: g_api || '.' || fn_name,

Line 849: GL_MESSAGE.WRITE_FNDLOG_STRING(FND_LOG.LEVEL_PROCEDURE,

845: -- parameters
846: GL_MESSAGE.WRITE_FNDLOG_STRING(FND_LOG.LEVEL_PROCEDURE,
847: g_api || '.' || fn_name,
848: 'x_mm_request_id = ' || x_mm_request_id);
849: GL_MESSAGE.WRITE_FNDLOG_STRING(FND_LOG.LEVEL_PROCEDURE,
850: g_api || '.' || fn_name,
851: 'x_gl_schema = ' || x_gl_schema);
852: GL_MESSAGE.WRITE_FNDLOG_STRING(FND_LOG.LEVEL_PROCEDURE,
853: g_api || '.' || fn_name,

Line 852: GL_MESSAGE.WRITE_FNDLOG_STRING(FND_LOG.LEVEL_PROCEDURE,

848: 'x_mm_request_id = ' || x_mm_request_id);
849: GL_MESSAGE.WRITE_FNDLOG_STRING(FND_LOG.LEVEL_PROCEDURE,
850: g_api || '.' || fn_name,
851: 'x_gl_schema = ' || x_gl_schema);
852: GL_MESSAGE.WRITE_FNDLOG_STRING(FND_LOG.LEVEL_PROCEDURE,
853: g_api || '.' || fn_name,
854: 'x_applsys_schema = ' || x_applsys_schema);
855:
856: -- upgrade standard balances table

Line 897: GL_MESSAGE.FUNC_SUCC(fn_name, FND_LOG.LEVEL_PROCEDURE,

893:
894: -- dummy commit, to make sure the rollback segment will be set
895: FND_CONCURRENT.AF_COMMIT;
896:
897: GL_MESSAGE.FUNC_SUCC(fn_name, FND_LOG.LEVEL_PROCEDURE,
898: g_api || '.' || fn_name);
899: EXCEPTION
900: WHEN OTHERS THEN
901: GL_MESSAGE.WRITE_FNDLOG_STRING(FND_LOG.LEVEL_UNEXPECTED,

Line 901: GL_MESSAGE.WRITE_FNDLOG_STRING(FND_LOG.LEVEL_UNEXPECTED,

897: GL_MESSAGE.FUNC_SUCC(fn_name, FND_LOG.LEVEL_PROCEDURE,
898: g_api || '.' || fn_name);
899: EXCEPTION
900: WHEN OTHERS THEN
901: GL_MESSAGE.WRITE_FNDLOG_STRING(FND_LOG.LEVEL_UNEXPECTED,
902: g_api || '.' || fn_name,
903: SUBSTR(SQLERRM, 1, 4000));
904: GL_MESSAGE.FUNC_FAIL(fn_name, FND_LOG.LEVEL_UNEXPECTED,
905: g_api || '.' || fn_name);

Line 904: GL_MESSAGE.FUNC_FAIL(fn_name, FND_LOG.LEVEL_UNEXPECTED,

900: WHEN OTHERS THEN
901: GL_MESSAGE.WRITE_FNDLOG_STRING(FND_LOG.LEVEL_UNEXPECTED,
902: g_api || '.' || fn_name,
903: SUBSTR(SQLERRM, 1, 4000));
904: GL_MESSAGE.FUNC_FAIL(fn_name, FND_LOG.LEVEL_UNEXPECTED,
905: g_api || '.' || fn_name);
906: RAISE;
907: END alter_movemerge_tables;
908:

Line 934: GL_MESSAGE.FUNC_ENT(fn_name, FND_LOG.LEVEL_PROCEDURE,

930: l_table_owner VARCHAR2(30);
931: l_gl_schema VARCHAR2(30);
932: l_applsys_schema VARCHAR2(30);
933: BEGIN
934: GL_MESSAGE.FUNC_ENT(fn_name, FND_LOG.LEVEL_PROCEDURE,
935: g_api || '.' || fn_name);
936: -- parameters
937: GL_MESSAGE.WRITE_FNDLOG_STRING(FND_LOG.LEVEL_PROCEDURE,
938: g_api || '.' || fn_name,

Line 937: GL_MESSAGE.WRITE_FNDLOG_STRING(FND_LOG.LEVEL_PROCEDURE,

933: BEGIN
934: GL_MESSAGE.FUNC_ENT(fn_name, FND_LOG.LEVEL_PROCEDURE,
935: g_api || '.' || fn_name);
936: -- parameters
937: GL_MESSAGE.WRITE_FNDLOG_STRING(FND_LOG.LEVEL_PROCEDURE,
938: g_api || '.' || fn_name,
939: 'x_batch_size = ' || x_batch_size);
940: GL_MESSAGE.WRITE_FNDLOG_STRING(FND_LOG.LEVEL_PROCEDURE,
941: g_api || '.' || fn_name,

Line 940: GL_MESSAGE.WRITE_FNDLOG_STRING(FND_LOG.LEVEL_PROCEDURE,

936: -- parameters
937: GL_MESSAGE.WRITE_FNDLOG_STRING(FND_LOG.LEVEL_PROCEDURE,
938: g_api || '.' || fn_name,
939: 'x_batch_size = ' || x_batch_size);
940: GL_MESSAGE.WRITE_FNDLOG_STRING(FND_LOG.LEVEL_PROCEDURE,
941: g_api || '.' || fn_name,
942: 'x_num_workers = ' || x_num_workers);
943:
944: -- AD_CONC_UTILS_PKG.submit_subrequests sets request data

Line 1012: log_level => FND_LOG.LEVEL_PROCEDURE,

1008: END IF;
1009:
1010: ELSE
1011: GL_MESSAGE.WRITE_LOG(msg_name => 'EFCB0001',
1012: log_level => FND_LOG.LEVEL_PROCEDURE,
1013: module => g_api || '.' || fn_name);
1014: x_retcode := AD_CONC_UTILS_PKG.CONC_WARNING;
1015: END IF;
1016:

Line 1043: GL_MESSAGE.FUNC_SUCC(fn_name, FND_LOG.LEVEL_PROCEDURE,

1039: last_update_login = 0;
1040: END IF;
1041: END IF;
1042:
1043: GL_MESSAGE.FUNC_SUCC(fn_name, FND_LOG.LEVEL_PROCEDURE,
1044: g_api || '.' || fn_name);
1045: EXCEPTION
1046: WHEN SUBMIT_REQ_ERROR THEN
1047: x_retcode := AD_CONC_UTILS_PKG.CONC_FAIL;

Line 1052: log_level => FND_LOG.LEVEL_PROCEDURE,

1048: GL_MESSAGE.WRITE_LOG(msg_name => 'SHRD0055',
1049: token_num => 1,
1050: t1 => 'ROUTINE',
1051: v1 => fn_name,
1052: log_level => FND_LOG.LEVEL_PROCEDURE,
1053: module => g_api || '.' || fn_name);
1054: GL_MESSAGE.FUNC_FAIL(fn_name, FND_LOG.LEVEL_UNEXPECTED,
1055: g_api || '.' || fn_name);
1056: RAISE;

Line 1054: GL_MESSAGE.FUNC_FAIL(fn_name, FND_LOG.LEVEL_UNEXPECTED,

1050: t1 => 'ROUTINE',
1051: v1 => fn_name,
1052: log_level => FND_LOG.LEVEL_PROCEDURE,
1053: module => g_api || '.' || fn_name);
1054: GL_MESSAGE.FUNC_FAIL(fn_name, FND_LOG.LEVEL_UNEXPECTED,
1055: g_api || '.' || fn_name);
1056: RAISE;
1057: WHEN OTHERS THEN
1058: x_retcode := AD_CONC_UTILS_PKG.CONC_FAIL;

Line 1059: GL_MESSAGE.WRITE_FNDLOG_STRING(FND_LOG.LEVEL_UNEXPECTED,

1055: g_api || '.' || fn_name);
1056: RAISE;
1057: WHEN OTHERS THEN
1058: x_retcode := AD_CONC_UTILS_PKG.CONC_FAIL;
1059: GL_MESSAGE.WRITE_FNDLOG_STRING(FND_LOG.LEVEL_UNEXPECTED,
1060: g_api || '.' || fn_name,
1061: SUBSTR(SQLERRM, 1, 4000));
1062: GL_MESSAGE.FUNC_FAIL(fn_name, FND_LOG.LEVEL_UNEXPECTED,
1063: g_api || '.' || fn_name);

Line 1062: GL_MESSAGE.FUNC_FAIL(fn_name, FND_LOG.LEVEL_UNEXPECTED,

1058: x_retcode := AD_CONC_UTILS_PKG.CONC_FAIL;
1059: GL_MESSAGE.WRITE_FNDLOG_STRING(FND_LOG.LEVEL_UNEXPECTED,
1060: g_api || '.' || fn_name,
1061: SUBSTR(SQLERRM, 1, 4000));
1062: GL_MESSAGE.FUNC_FAIL(fn_name, FND_LOG.LEVEL_UNEXPECTED,
1063: g_api || '.' || fn_name);
1064: RAISE;
1065: END upgrade_ent_func_bal;
1066:

Line 1088: GL_MESSAGE.FUNC_ENT(fn_name, FND_LOG.LEVEL_PROCEDURE,

1084: FND_FILE.PUT_LINE(FND_FILE.LOG, 'X_Num_Workers : ' || X_Num_Workers);
1085: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Session Id : ' ||
1086: FND_GLOBAL.session_id);
1087:
1088: GL_MESSAGE.FUNC_ENT(fn_name, FND_LOG.LEVEL_PROCEDURE,
1089: g_api || '.' || fn_name);
1090: -- parameters
1091: GL_MESSAGE.WRITE_FNDLOG_STRING(FND_LOG.LEVEL_PROCEDURE,
1092: g_api || '.' || fn_name,

Line 1091: GL_MESSAGE.WRITE_FNDLOG_STRING(FND_LOG.LEVEL_PROCEDURE,

1087:
1088: GL_MESSAGE.FUNC_ENT(fn_name, FND_LOG.LEVEL_PROCEDURE,
1089: g_api || '.' || fn_name);
1090: -- parameters
1091: GL_MESSAGE.WRITE_FNDLOG_STRING(FND_LOG.LEVEL_PROCEDURE,
1092: g_api || '.' || fn_name,
1093: 'x_batch_size = ' || x_batch_size);
1094: GL_MESSAGE.WRITE_FNDLOG_STRING(FND_LOG.LEVEL_PROCEDURE,
1095: g_api || '.' || fn_name,

Line 1094: GL_MESSAGE.WRITE_FNDLOG_STRING(FND_LOG.LEVEL_PROCEDURE,

1090: -- parameters
1091: GL_MESSAGE.WRITE_FNDLOG_STRING(FND_LOG.LEVEL_PROCEDURE,
1092: g_api || '.' || fn_name,
1093: 'x_batch_size = ' || x_batch_size);
1094: GL_MESSAGE.WRITE_FNDLOG_STRING(FND_LOG.LEVEL_PROCEDURE,
1095: g_api || '.' || fn_name,
1096: 'x_argument4 = ' || x_argument4);
1097:
1098: ad_parallel_updates_pkg.initialize_id_range(

Line 1150: GL_MESSAGE.FUNC_SUCC(fn_name, FND_LOG.LEVEL_PROCEDURE,

1146: end loop;
1147:
1148: x_retcode := AD_CONC_UTILS_PKG.CONC_SUCCESS;
1149:
1150: GL_MESSAGE.FUNC_SUCC(fn_name, FND_LOG.LEVEL_PROCEDURE,
1151: g_api || '.' || fn_name);
1152: EXCEPTION
1153: WHEN OTHERS THEN
1154: x_errbuf := SUBSTR(SQLERRM, 1, 240);

Line 1156: GL_MESSAGE.WRITE_FNDLOG_STRING(FND_LOG.LEVEL_UNEXPECTED,

1152: EXCEPTION
1153: WHEN OTHERS THEN
1154: x_errbuf := SUBSTR(SQLERRM, 1, 240);
1155: x_retcode := AD_CONC_UTILS_PKG.CONC_FAIL;
1156: GL_MESSAGE.WRITE_FNDLOG_STRING(FND_LOG.LEVEL_UNEXPECTED,
1157: g_api || '.' || fn_name,
1158: SUBSTR(SQLERRM, 1, 4000));
1159: GL_MESSAGE.FUNC_FAIL(fn_name, FND_LOG.LEVEL_UNEXPECTED,
1160: g_api || '.' || fn_name);

Line 1159: GL_MESSAGE.FUNC_FAIL(fn_name, FND_LOG.LEVEL_UNEXPECTED,

1155: x_retcode := AD_CONC_UTILS_PKG.CONC_FAIL;
1156: GL_MESSAGE.WRITE_FNDLOG_STRING(FND_LOG.LEVEL_UNEXPECTED,
1157: g_api || '.' || fn_name,
1158: SUBSTR(SQLERRM, 1, 4000));
1159: GL_MESSAGE.FUNC_FAIL(fn_name, FND_LOG.LEVEL_UNEXPECTED,
1160: g_api || '.' || fn_name);
1161: RAISE;
1162: END upgrade_balance_tables;
1163:

Line 1191: GL_MESSAGE.FUNC_ENT(fn_name, FND_LOG.LEVEL_PROCEDURE,

1187: FROM gl_movemerge_requests
1188: WHERE ledger_id = v_ledger_id
1189: AND status_code = 'MC';
1190: BEGIN
1191: GL_MESSAGE.FUNC_ENT(fn_name, FND_LOG.LEVEL_PROCEDURE,
1192: g_api || '.' || fn_name);
1193: -- parameters
1194: GL_MESSAGE.WRITE_FNDLOG_STRING(FND_LOG.LEVEL_PROCEDURE,
1195: g_api || '.' || fn_name,

Line 1194: GL_MESSAGE.WRITE_FNDLOG_STRING(FND_LOG.LEVEL_PROCEDURE,

1190: BEGIN
1191: GL_MESSAGE.FUNC_ENT(fn_name, FND_LOG.LEVEL_PROCEDURE,
1192: g_api || '.' || fn_name);
1193: -- parameters
1194: GL_MESSAGE.WRITE_FNDLOG_STRING(FND_LOG.LEVEL_PROCEDURE,
1195: g_api || '.' || fn_name,
1196: 'x_gl_schema = ' || x_gl_schema);
1197: GL_MESSAGE.WRITE_FNDLOG_STRING(FND_LOG.LEVEL_PROCEDURE,
1198: g_api || '.' || fn_name,

Line 1197: GL_MESSAGE.WRITE_FNDLOG_STRING(FND_LOG.LEVEL_PROCEDURE,

1193: -- parameters
1194: GL_MESSAGE.WRITE_FNDLOG_STRING(FND_LOG.LEVEL_PROCEDURE,
1195: g_api || '.' || fn_name,
1196: 'x_gl_schema = ' || x_gl_schema);
1197: GL_MESSAGE.WRITE_FNDLOG_STRING(FND_LOG.LEVEL_PROCEDURE,
1198: g_api || '.' || fn_name,
1199: 'x_applsys_schema = ' || x_applsys_schema);
1200:
1201: FOR rec IN c_ledgers LOOP

Line 1250: GL_MESSAGE.FUNC_SUCC(fn_name, FND_LOG.LEVEL_PROCEDURE,

1246: END LOOP;
1247:
1248: x_retcode := AD_CONC_UTILS_PKG.CONC_SUCCESS;
1249:
1250: GL_MESSAGE.FUNC_SUCC(fn_name, FND_LOG.LEVEL_PROCEDURE,
1251: g_api || '.' || fn_name);
1252: EXCEPTION
1253: WHEN OTHERS THEN
1254: x_errbuf := SUBSTR(SQLERRM, 1, 240);

Line 1256: GL_MESSAGE.WRITE_FNDLOG_STRING(FND_LOG.LEVEL_UNEXPECTED,

1252: EXCEPTION
1253: WHEN OTHERS THEN
1254: x_errbuf := SUBSTR(SQLERRM, 1, 240);
1255: x_retcode := AD_CONC_UTILS_PKG.CONC_FAIL;
1256: GL_MESSAGE.WRITE_FNDLOG_STRING(FND_LOG.LEVEL_UNEXPECTED,
1257: g_api || '.' || fn_name,
1258: SUBSTR(SQLERRM, 1, 4000));
1259: GL_MESSAGE.FUNC_FAIL(fn_name, FND_LOG.LEVEL_UNEXPECTED,
1260: g_api || '.' || fn_name);

Line 1259: GL_MESSAGE.FUNC_FAIL(fn_name, FND_LOG.LEVEL_UNEXPECTED,

1255: x_retcode := AD_CONC_UTILS_PKG.CONC_FAIL;
1256: GL_MESSAGE.WRITE_FNDLOG_STRING(FND_LOG.LEVEL_UNEXPECTED,
1257: g_api || '.' || fn_name,
1258: SUBSTR(SQLERRM, 1, 4000));
1259: GL_MESSAGE.FUNC_FAIL(fn_name, FND_LOG.LEVEL_UNEXPECTED,
1260: g_api || '.' || fn_name);
1261: RAISE;
1262: END upgrade_movemerge_int_tables;
1263: