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.GL_FLATTEN_LEDGER_SEG_VALS dependencies on GL_MESSAGE

Line 26: GL_MESSAGE.FUNC_ENT (FUNC_NAME =>

22: GLSTFL_FATAL_ERR EXCEPTION;
23: l_status_flag VARCHAR2(1);
24: BEGIN
25:
26: GL_MESSAGE.FUNC_ENT (FUNC_NAME =>
27: 'GL_FLATTEN_LEDGER_SEG_VALS.Fix_By_Coa');
28:
29:
30: -- The flow of this routine is as follows

Line 41: GL_MESSAGE.Write_Log(MSG_NAME =>'SHRD0180',

37:
38: -- Cleaning GL_LEDGER_SEGMENT_VALUES before processing
39:
40: IF (GL_FLATTEN_SETUP_DATA.GLSTFL_DEBUG) THEN
41: GL_MESSAGE.Write_Log(MSG_NAME =>'SHRD0180',
42: TOKEN_NUM => 2,
43: T1 =>'ROUTINE',
44: V1 =>
45: 'GL_FLATTEN_LEDGER_SEG_VALS.Fix_By_Coa()',

Line 64: GL_MESSAGE.Write_Log(MSG_NAME =>'SHRD0119',

60: FROM GL_LEDGERS
61: WHERE CHART_OF_ACCOUNTS_ID = GL_FLATTEN_SETUP_DATA.GLSTFL_COA_ID);
62:
63: L_Number_Of_Rows := SQL%ROWCOUNT;
64: GL_MESSAGE.Write_Log(MSG_NAME =>'SHRD0119',
65: TOKEN_NUM =>2,
66: T1 =>'NUM',
67: V1 => TO_CHAR(L_NUMBER_OF_ROWS),
68: T2 =>'TABLE',

Line 73: GL_MESSAGE.Write_Log(MSG_NAME =>'SHRD0180',

69: V2 =>'GL_LEDGER_SEGMENT_VALUES');
70:
71:
72: IF (GL_FLATTEN_SETUP_DATA.GLSTFL_DEBUG) THEN
73: GL_MESSAGE.Write_Log(MSG_NAME =>'SHRD0180',
74: TOKEN_NUM => 2,
75: T1 =>'ROUTINE',
76: V1 =>
77: 'GL_FLATTEN_LEDGER_SEG_VALS.Fix_By_Coa()',

Line 93: GL_MESSAGE.Write_Log(MSG_NAME =>'SHRD0118',

89: FROM GL_LEDGERS
90: WHERE chart_of_accounts_id = GL_FLATTEN_SETUP_DATA.GLSTFL_COA_ID);
91:
92: L_Number_Of_Rows := SQL%ROWCOUNT;
93: GL_MESSAGE.Write_Log(MSG_NAME =>'SHRD0118',
94: TOKEN_NUM =>2,
95: T1 =>'NUM',
96: V1 => TO_CHAR(L_NUMBER_OF_ROWS),
97: T2 =>'TABLE',

Line 105: GL_MESSAGE.Write_Log(MSG_NAME =>'SHRD0180',

101:
102: -- Update Start_Date/End_Date In GL_LEDGER_SEGMENT_VALUES
103:
104: IF (GL_FLATTEN_SETUP_DATA.GLSTFL_DEBUG) THEN
105: GL_MESSAGE.Write_Log(MSG_NAME =>'SHRD0180',
106: TOKEN_NUM => 2,
107: T1 =>'ROUTINE',
108: V1 =>
109: 'GL_FLATTEN_LEDGER_SEG_VALS.Fix_By_Coa()',

Line 133: GL_MESSAGE.Write_Log(MSG_NAME =>'SHRD0118',

129: GL_FLATTEN_SETUP_DATA.GLSTFL_REQ_ID
130: AND GLLNSV2.LEDGER_ID = GLL.LEDGER_ID);
131:
132: L_Number_Of_Rows := SQL%ROWCOUNT;
133: GL_MESSAGE.Write_Log(MSG_NAME =>'SHRD0118',
134: TOKEN_NUM =>2,
135: T1 =>'NUM',
136: V1 => TO_CHAR(L_NUMBER_OF_ROWS),
137: T2 =>'TABLE',

Line 143: GL_MESSAGE.Write_Log(MSG_NAME =>'SHRD0180',

139:
140: -- Marking outdated records in GL_LEDGER_SEGMENT_VALUES for delete.
141:
142: IF (GL_FLATTEN_SETUP_DATA.GLSTFL_DEBUG) THEN
143: GL_MESSAGE.Write_Log(MSG_NAME =>'SHRD0180',
144: TOKEN_NUM => 2,
145: T1 =>'ROUTINE',
146: V1 =>
147: 'GL_FLATTEN_LEDGER_SEG_VALS.Fix_By_Coa()',

Line 166: GL_MESSAGE.Write_Log(MSG_NAME =>'SHRD0118',

162: AND GLLNSV.STATUS_CODE = 'D'
163: AND GLLNSV.LEDGER_ID = GLL.LEDGER_ID);
164:
165: L_Number_Of_Rows := SQL%ROWCOUNT;
166: GL_MESSAGE.Write_Log(MSG_NAME =>'SHRD0118',
167: TOKEN_NUM =>2,
168: T1 =>'NUM',
169: V1 => TO_CHAR(l_number_of_rows),
170: T2 =>'TABLE',

Line 181: GL_MESSAGE.Write_Log(MSG_NAME =>'SHRD0180',

177: -- table for every new record in GL_LEDGER_NORM_SEG_VALS with
178: -- status_code 'I' and segment_value_type_code of 'S'.
179:
180: IF (GL_FLATTEN_SETUP_DATA.GLSTFL_DEBUG) THEN
181: GL_MESSAGE.Write_Log(MSG_NAME =>'SHRD0180',
182: TOKEN_NUM => 2,
183: T1 =>'ROUTINE',
184: V1 =>
185: 'GL_FLATTEN_LEDGER_SEG_VALS.Fix_By_Coa()',

Line 222: GL_MESSAGE.Write_Log(MSG_NAME =>'SHRD0117',

218: AND GLLNSV.SEGMENT_VALUE_TYPE_CODE = 'S');
219:
220:
221: L_Number_Of_Rows := SQL%ROWCOUNT;
222: GL_MESSAGE.Write_Log(MSG_NAME =>'SHRD0117',
223: TOKEN_NUM =>2,
224: T1 =>'NUM',
225: V1 =>TO_CHAR(L_NUMBER_OF_ROWS),
226: T2 =>'TABLE',

Line 235: GL_MESSAGE.Write_Log(MSG_NAME =>'SHRD0180',

231: -- table for every new record in GL_LEDGER_NORM_SEG_VALS with
232: -- status_code 'I' and segment_value_type_code of 'C'.
233:
234: If (GL_FLATTEN_SETUP_DATA.GLSTFL_DEBUG) THEN
235: GL_MESSAGE.Write_Log(MSG_NAME =>'SHRD0180',
236: TOKEN_NUM => 2,
237: T1 =>'ROUTINE',
238: V1 =>
239: 'GL_FLATTEN_LEDGER_SEG_VALS.Fix_By_Coa()',

Line 255: GL_MESSAGE.Write_Log(msg_name => 'SHRD0181',

251: IF (GL_FLATTEN_SETUP_DATA.GLSTFL_OP_MODE = 'VH') OR
252: (GL_FLATTEN_SETUP_DATA.GLSTFL_OP_MODE = 'LV')THEN
253:
254: IF (GL_FLATTEN_SETUP_DATA.GLSTFL_Debug) THEN
255: GL_MESSAGE.Write_Log(msg_name => 'SHRD0181',
256: token_num => 3,
257: t1 => 'ROUTINE',
258: v1 =>
259: 'GL_FLATTEN_LEDGER_SEG_VALS.Fix_By_Coa()',

Line 266: GL_MESSAGE.Write_Log(msg_name => 'SHRD0181',

262: t3 => 'VALUE',
263: v3 =>
264: TO_CHAR(GL_FLATTEN_SETUP_DATA.GLSTFL_Bal_Vs_Id));
265:
266: GL_MESSAGE.Write_Log(msg_name => 'SHRD0181',
267: token_num => 3,
268: t1 => 'ROUTINE',
269: v1 =>
270: 'GL_FLATTEN_LEDGER_SEG_VALS.Fix_By_Coa()',

Line 279: GL_MESSAGE.Write_Log

275: TO_CHAR(GL_FLATTEN_SETUP_DATA.GLSTFL_Mgt_Vs_Id));
276: END IF;
277:
278: IF (GL_FLATTEN_SETUP_DATA.GLSTFL_Debug) THEN
279: GL_MESSAGE.Write_Log
280: (msg_name => 'SHRD0180',
281: token_num => 2,
282: t1 => 'ROUTINE',
283: v1 => 'GL_FLATTEN_LEDGER_SEG_VALS.Fix_By_Coa()',

Line 301: GL_MESSAGE.Write_Log

297: RAISE GLSTFL_fatal_err;
298: END IF;
299:
300: IF (GL_FLATTEN_SETUP_DATA.GLSTFL_Debug) THEN
301: GL_MESSAGE.Write_Log
302: (msg_name => 'SHRD0180',
303: token_num => 2,
304: t1 => 'ROUTINE',
305: v1 => 'GL_FLATTEN_LEDGER_SEG_VALS.Fix_By_Coa()',

Line 366: GL_MESSAGE.Write_Log(MSG_NAME =>'SHRD0117',

362: AND GLSVH.PARENT_FLEX_VALUE = GLLNSV.SEGMENT_VALUE
363: AND GLSVH.STATUS_CODE IS NULL);
364:
365: L_Number_Of_Rows := SQL%ROWCOUNT;
366: GL_MESSAGE.Write_Log(MSG_NAME =>'SHRD0117',
367: TOKEN_NUM =>2,
368: T1 =>'NUM',
369: V1 =>TO_CHAR(L_NUMBER_OF_ROWS),
370: T2 =>'TABLE',

Line 387: GL_MESSAGE.Write_Log(MSG_NAME =>'SHRD0180',

383: -- logic in FIX_BY_COA() of this package.
384:
385:
386: IF (GL_FLATTEN_SETUP_DATA.GLSTFL_DEBUG) THEN
387: GL_MESSAGE.Write_Log(MSG_NAME =>'SHRD0180',
388: TOKEN_NUM => 2,
389: T1 =>'ROUTINE',
390: V1 =>
391: 'GL_FLATTEN_LEDGER_SEG_VALS.Fix_By_Coa()',

Line 447: GL_MESSAGE.Write_Log(MSG_NAME =>'SHRD0117',

443: TO_DATE('12/31/9999','MM/DD/YYYY'))));
444:
445:
446: l_number_of_rows := SQL%ROWCOUNT;
447: GL_MESSAGE.Write_Log(MSG_NAME =>'SHRD0117',
448: TOKEN_NUM =>2,
449: T1 =>'NUM',
450: V1 =>TO_CHAR(L_NUMBER_OF_ROWS),
451: T2 =>'TABLE',

Line 465: GL_MESSAGE.FUNC_SUCC(FUNC_NAME =>

461: END IF;
462:
463: FND_CONCURRENT.AF_COMMIT; -- COMMIT POINT
464:
465: GL_MESSAGE.FUNC_SUCC(FUNC_NAME =>
466: 'GL_FLATTEN_LEDGER_SEG_VALS.Fix_By_Coa');
467:
468: RETURN TRUE;
469:

Line 474: GL_MESSAGE.Write_Log(MSG_NAME =>'FLAT0002',

470: EXCEPTION
471:
472: WHEN GLSTFL_FATAL_ERR THEN
473:
474: GL_MESSAGE.Write_Log(MSG_NAME =>'FLAT0002',
475: TOKEN_NUM => 1,
476: T1 =>'ROUTINE_NAME',
477: V1 =>
478: 'GL_FLATTEN_LEDGER_SEG_VALS.Fix_By_Coa()');

Line 481: GL_MESSAGE.FUNC_FAIL(FUNC_NAME =>

477: V1 =>
478: 'GL_FLATTEN_LEDGER_SEG_VALS.Fix_By_Coa()');
479:
480:
481: GL_MESSAGE.FUNC_FAIL(FUNC_NAME =>
482: 'GL_FLATTEN_LEDGER_SEG_VALS.Fix_By_Coa');
483:
484: FND_CONCURRENT.AF_ROLLBACK; -- ROLLBACK POINT
485:

Line 490: GL_MESSAGE.Write_Log(MSG_NAME =>'SHRD0203',

486: RETURN FALSE;
487:
488: WHEN OTHERS THEN
489:
490: GL_MESSAGE.Write_Log(MSG_NAME =>'SHRD0203',
491: TOKEN_NUM =>2,
492: T1 =>'FUNCTION',
493: V1 =>'FIX_BY_COA()',
494: T2 =>'SQLERRMC',

Line 497: GL_MESSAGE.FUNC_FAIL(FUNC_NAME =>

493: V1 =>'FIX_BY_COA()',
494: T2 =>'SQLERRMC',
495: V2 => SQLERRM);
496:
497: GL_MESSAGE.FUNC_FAIL(FUNC_NAME =>
498: 'GL_FLATTEN_LEDGER_SEG_VALS.Fix_By_Coa');
499:
500: FND_CONCURRENT.AF_ROLLBACK; -- ROLLBACK POINT
501:

Line 528: GL_MESSAGE.FUNC_ENT(FUNC_NAME =>

524: GLSTFL_fatal_err EXCEPTION;
525:
526: BEGIN
527:
528: GL_MESSAGE.FUNC_ENT(FUNC_NAME =>
529: 'GL_FLATTEN_LEDGER_SEG_VALS.Fix_By_Value_Set');
530:
531: BEGIN
532:

Line 554: GL_MESSAGE.Write_Log(MSG_NAME =>'FLAT0001',

550:
551: END;
552:
553: IF (L_Check_Id <> 1) THEN
554: GL_MESSAGE.Write_Log(MSG_NAME =>'FLAT0001',
555: TOKEN_NUM => 1,
556: T1 =>'ROUTINE_NAME',
557: V1 =>
558: 'GL_FLATTEN_LEDGER_SEG_VALS.Fix_By_Value_Set()');

Line 560: GL_MESSAGE.FUNC_SUCC(FUNC_NAME =>

556: T1 =>'ROUTINE_NAME',
557: V1 =>
558: 'GL_FLATTEN_LEDGER_SEG_VALS.Fix_By_Value_Set()');
559:
560: GL_MESSAGE.FUNC_SUCC(FUNC_NAME =>
561: 'GL_FLATTEN_LEDGER_SEG_VALS.Fix_By_Value_Set');
562:
563: RETURN TRUE;
564:

Line 570: GL_MESSAGE.Write_Log(MSG_NAME =>'SHRD0180',

566:
567: -- Cleaning GL_LEDGER_SEGMENT_VALUES before processing
568:
569: IF (GL_FLATTEN_SETUP_DATA.GLSTFL_DEBUG) THEN
570: GL_MESSAGE.Write_Log(MSG_NAME =>'SHRD0180',
571: TOKEN_NUM => 2,
572: T1 =>'ROUTINE',
573: V1 =>
574: 'GL_FLATTEN_LEDGER_SEG_VALS.Fix_By_Value_Set()',

Line 594: GL_MESSAGE.Write_Log(MSG_NAME =>'SHRD0119',

590: OR MGT_SEG_VALUE_SET_ID =
591: GL_FLATTEN_SETUP_DATA.GLSTFL_VS_ID);
592:
593: L_Number_Of_Rows := SQL%ROWCOUNT;
594: GL_MESSAGE.Write_Log(MSG_NAME =>'SHRD0119',
595: TOKEN_NUM =>2,
596: T1 =>'NUM',
597: V1 =>TO_CHAR(L_NUMBER_OF_ROWS),
598: T2 =>'TABLE',

Line 604: GL_MESSAGE.Write_Log(MSG_NAME =>'SHRD0180',

600:
601: -- Cleaning GL_LEDGER_SEGMENT_VALUES before processing
602:
603: IF (GL_FLATTEN_SETUP_DATA.GLSTFL_DEBUG) THEN
604: GL_MESSAGE.Write_Log(MSG_NAME =>'SHRD0180',
605: TOKEN_NUM => 2,
606: T1 =>'ROUTINE',
607: V1 =>
608: 'GL_FLATTEN_LEDGER_SEG_VALS.Fix_By_Value_Set()',

Line 628: GL_MESSAGE.Write_Log(MSG_NAME =>'SHRD0118',

624: GL_FLATTEN_SETUP_DATA.GLSTFL_VS_ID);
625:
626:
627: L_Number_Of_Rows := SQL%ROWCOUNT;
628: GL_MESSAGE.Write_Log(MSG_NAME =>'SHRD0118',
629: TOKEN_NUM =>2,
630: T1 =>'NUM',
631: V1 =>TO_CHAR(L_NUMBER_OF_ROWS),
632: T2 =>'TABLE',

Line 641: GL_MESSAGE.Write_Log(MSG_NAME =>'SHRD0180',

637: -- Marking Parent-Child segment value mappings in
638: -- GL_LEDGER_SEGMENT_VALUES for delete
639:
640: IF (GL_FLATTEN_SETUP_DATA.GLSTFL_DEBUG) THEN
641: GL_MESSAGE.Write_Log(MSG_NAME =>'SHRD0180',
642: TOKEN_NUM => 2,
643: T1 =>'ROUTINE',
644: V1 =>
645: 'GL_FLATTEN_LEDGER_SEG_VALS.Fix_By_Value_Set()',

Line 680: GL_MESSAGE.Write_Log(MSG_NAME =>'SHRD0118',

676: GL_FLATTEN_SETUP_DATA.GLSTFL_VS_ID
677: AND GLLNSV.SEGMENT_TYPE_CODE = 'M')));
678:
679: L_Number_Of_Rows := SQL%ROWCOUNT;
680: GL_MESSAGE.Write_Log(MSG_NAME =>'SHRD0118',
681: TOKEN_NUM =>2,
682: T1 =>'NUM',
683: V1 =>TO_CHAR(L_NUMBER_OF_ROWS),
684: T2 =>'TABLE',

Line 694: GL_MESSAGE.Write_Log(MSG_NAME =>'SHRD0180',

690: -- GL_LEDGER_SEGMENT_VALUES.
691:
692: IF (GL_FLATTEN_SETUP_DATA.GLSTFL_DEBUG) THEN
693:
694: GL_MESSAGE.Write_Log(MSG_NAME =>'SHRD0180',
695: TOKEN_NUM => 2,
696: T1 =>'ROUTINE',
697: V1 =>
698: 'GL_FLATTEN_LEDGER_SEG_VALS.Fix_By_Value_Set()',

Line 741: GL_MESSAGE.Write_Log(MSG_NAME =>'SHRD0117',

737: AND GLLNSV.SEGMENT_TYPE_CODE = 'M')));
738:
739:
740: L_Number_Of_Rows := SQL%ROWCOUNT;
741: GL_MESSAGE.Write_Log(MSG_NAME =>'SHRD0117',
742: TOKEN_NUM =>2,
743: T1 =>'NUM',
744: V1 =>TO_CHAR(L_NUMBER_OF_ROWS),
745: T2 =>'TABLE',

Line 758: GL_MESSAGE.FUNC_SUCC(FUNC_NAME =>

754: END IF;
755:
756: FND_CONCURRENT.AF_COMMIT; -- COMMIT Point
757:
758: GL_MESSAGE.FUNC_SUCC(FUNC_NAME =>
759: 'GL_FLATTEN_LEDGER_SEG_VALS.Fix_By_Value_Set');
760:
761: RETURN TRUE;
762:

Line 767: GL_MESSAGE.Write_Log(MSG_NAME =>'FLAT0002',

763: EXCEPTION
764:
765: WHEN GLSTFL_FATAL_ERR THEN
766:
767: GL_MESSAGE.Write_Log(MSG_NAME =>'FLAT0002',
768: TOKEN_NUM => 1,
769: T1 =>'ROUTINE_NAME',
770: V1 => 'Fix_By_Value_Set()');
771:

Line 772: GL_MESSAGE.FUNC_FAIL(FUNC_NAME =>

768: TOKEN_NUM => 1,
769: T1 =>'ROUTINE_NAME',
770: V1 => 'Fix_By_Value_Set()');
771:
772: GL_MESSAGE.FUNC_FAIL(FUNC_NAME =>
773: 'GL_FLATTEN_LEDGER_SEG_VALS.Fix_By_Value_Set');
774:
775: FND_CONCURRENT.AF_ROLLBACK; -- ROLLBACK Point
776:

Line 781: GL_MESSAGE.Write_Log (MSG_NAME =>'SHRD0102',

777: RETURN FALSE;
778:
779: WHEN OTHERS THEN
780:
781: GL_MESSAGE.Write_Log (MSG_NAME =>'SHRD0102',
782: TOKEN_NUM => 1,
783: T1 =>'EMESSAGE',
784: V1 => SQLERRM);
785:

Line 786: GL_MESSAGE.FUNC_FAIL(FUNC_NAME =>

782: TOKEN_NUM => 1,
783: T1 =>'EMESSAGE',
784: V1 => SQLERRM);
785:
786: GL_MESSAGE.FUNC_FAIL(FUNC_NAME =>
787: 'GL_FLATTEN_LEDGER_SEG_VALS.Fix_By_Value_Set');
788:
789: FND_CONCURRENT.AF_ROLLBACK;
790:

Line 819: GL_MESSAGE.FUNC_ENT(FUNC_NAME =>

815: l_status VARCHAR2(1);
816:
817: BEGIN
818:
819: GL_MESSAGE.FUNC_ENT(FUNC_NAME =>
820: 'GL_FLATTEN_LEDGER_SEG_VALS.Clean_Up_By_Coa');
821:
822: -- Bug 8265487 -- Should update STATUS_CODE only for completed ledgers
823: UPDATE GL_LEDGER_NORM_SEG_VALS

Line 839: GL_MESSAGE.Write_Log(MSG_NAME =>'SHRD0118',

835: WHERE CHART_OF_ACCOUNTS_ID =
836: GL_FLATTEN_SETUP_DATA.GLSTFL_COA_ID); */
837:
838: L_Number_Of_Rows := SQL%ROWCOUNT;
839: GL_MESSAGE.Write_Log(MSG_NAME =>'SHRD0118',
840: TOKEN_NUM =>2,
841: T1 =>'NUM',
842: V1 =>TO_CHAR(L_NUMBER_OF_ROWS),
843: T2 => 'TABLE',

Line 858: GL_MESSAGE.Write_Log(MSG_NAME =>'SHRD0118',

854: WHERE CHART_OF_ACCOUNTS_ID =
855: GL_FLATTEN_SETUP_DATA.GLSTFL_COA_ID);
856:
857: L_Number_Of_Rows := SQL%ROWCOUNT;
858: GL_MESSAGE.Write_Log(MSG_NAME =>'SHRD0118',
859: TOKEN_NUM =>2,
860: T1 =>'NUM',
861: V1 =>TO_CHAR(L_NUMBER_OF_ROWS),
862: T2 => 'TABLE',

Line 879: GL_MESSAGE.Write_Log(MSG_NAME =>'SHRD0119',

875: WHERE CHART_OF_ACCOUNTS_ID =
876: GL_FLATTEN_SETUP_DATA.GLSTFL_COA_ID);
877:
878: L_Number_Of_Rows := SQL%ROWCOUNT;
879: GL_MESSAGE.Write_Log(MSG_NAME =>'SHRD0119',
880: TOKEN_NUM => 2,
881: T1 => 'NUM',
882: V1 => TO_CHAR(L_NUMBER_OF_ROWS),
883: T2 =>'TABLE',

Line 897: GL_MESSAGE.Write_Log(MSG_NAME =>'SHRD0119',

893: WHERE CHART_OF_ACCOUNTS_ID =
894: GL_FLATTEN_SETUP_DATA.GLSTFL_COA_ID);
895:
896: L_Number_Of_Rows := SQL%ROWCOUNT;
897: GL_MESSAGE.Write_Log(MSG_NAME =>'SHRD0119',
898: TOKEN_NUM => 2,
899: T1 => 'NUM',
900: V1 => TO_CHAR(L_NUMBER_OF_ROWS),
901: T2 =>'TABLE',

Line 905: GL_MESSAGE.FUNC_SUCC(FUNC_NAME =>

901: T2 =>'TABLE',
902: V2 => 'GL_LEDGER_SEGMENT_VALUES');
903: l_number_of_rows := 0;
904:
905: GL_MESSAGE.FUNC_SUCC(FUNC_NAME =>
906: 'GL_FLATTEN_LEDGER_SEG_VALS.Clean_Up_By_Coa');
907:
908: RETURN TRUE;
909:

Line 913: GL_MESSAGE.Write_Log (MSG_NAME =>'SHRD0102',

909:
910: EXCEPTION
911:
912: WHEN OTHERS THEN
913: GL_MESSAGE.Write_Log (MSG_NAME =>'SHRD0102',
914: TOKEN_NUM => 1,
915: T1 =>'EMESSAGE',
916: V1 => SQLERRM);
917:

Line 918: GL_MESSAGE.FUNC_FAIL(FUNC_NAME =>

914: TOKEN_NUM => 1,
915: T1 =>'EMESSAGE',
916: V1 => SQLERRM);
917:
918: GL_MESSAGE.FUNC_FAIL(FUNC_NAME =>
919: 'GL_FLATTEN_LEDGER_SEG_VALS.Clean_Up_By_Coa');
920:
921: FND_CONCURRENT.AF_ROLLBACK; -- ROLLBACK Point
922:

Line 948: GL_MESSAGE.FUNC_ENT(FUNC_NAME =>

944: L_Number_Of_Rows NUMBER :=0;
945:
946: BEGIN
947:
948: GL_MESSAGE.FUNC_ENT(FUNC_NAME =>
949: 'GL_FLATTEN_LEDGER_SEG_VALS.Clean_Up_By_Value_Set');
950:
951: UPDATE GL_LEDGER_SEGMENT_VALUES
952: SET STATUS_CODE = NULL

Line 963: GL_MESSAGE.Write_Log(MSG_NAME =>'SHRD0118',

959: OR MGT_SEG_VALUE_SET_ID =
960: GL_FLATTEN_SETUP_DATA.GLSTFL_VS_ID);
961:
962: L_Number_Of_Rows := SQL%ROWCOUNT;
963: GL_MESSAGE.Write_Log(MSG_NAME =>'SHRD0118',
964: TOKEN_NUM =>2,
965: T1 =>'NUM',
966: V1 =>TO_CHAR(L_NUMBER_OF_ROWS),
967: T2 => 'TABLE',

Line 982: GL_MESSAGE.Write_Log(MSG_NAME =>'SHRD0119',

978: OR MGT_SEG_VALUE_SET_ID =
979: GL_FLATTEN_SETUP_DATA.GLSTFL_VS_ID);
980:
981: L_Number_Of_Rows := SQL%ROWCOUNT;
982: GL_MESSAGE.Write_Log(MSG_NAME =>'SHRD0119',
983: TOKEN_NUM => 2,
984: T1 => 'NUM',
985: V1 => TO_CHAR(L_NUMBER_OF_ROWS),
986: T2 =>'TABLE',

Line 990: GL_MESSAGE.FUNC_SUCC(FUNC_NAME =>

986: T2 =>'TABLE',
987: V2 => 'GL_LEDGER_SEGMENT_VALUES');
988:
989:
990: GL_MESSAGE.FUNC_SUCC(FUNC_NAME =>
991: 'GL_FLATTEN_LEDGER_SEG_VALS.Clean_Up_By_Value_Set');
992:
993: RETURN TRUE;
994:

Line 999: GL_MESSAGE.Write_Log(MSG_NAME =>'SHRD0102',

995: EXCEPTION
996:
997: WHEN OTHERS THEN
998:
999: GL_MESSAGE.Write_Log(MSG_NAME =>'SHRD0102',
1000: TOKEN_NUM => 1,
1001: T1 =>'EMESSAGE',
1002: V1 => SQLERRM);
1003:

Line 1004: GL_MESSAGE.FUNC_FAIL(FUNC_NAME =>

1000: TOKEN_NUM => 1,
1001: T1 =>'EMESSAGE',
1002: V1 => SQLERRM);
1003:
1004: GL_MESSAGE.FUNC_FAIL(FUNC_NAME =>
1005: 'GL_FLATTEN_LEDGER_SEG_VALS.Clean_Up_By_Value_Set');
1006:
1007: FND_CONCURRENT.AF_ROLLBACK; -- ROLLBACK Point
1008:

Line 1039: GL_MESSAGE.FUNC_ENT(FUNC_NAME =>

1035: L_Ledger_Name VARCHAR2(30);
1036:
1037: BEGIN
1038:
1039: GL_MESSAGE.FUNC_ENT(FUNC_NAME =>
1040: 'GL_FLATTEN_LEDGER_SEG_VALS.Error_Check');
1041:
1042: IF (GL_FLATTEN_SETUP_DATA.GLSTFL_OP_MODE = 'VH') OR
1043: (GL_FLATTEN_SETUP_DATA.GLSTFL_OP_MODE = 'LV') THEN

Line 1095: GL_MESSAGE.Write_Log(MSG_NAME =>'FLAT0003',

1091: SELECT NAME INTO L_LEDGER_NAME
1092: FROM GL_LEDGERS
1093: WHERE LEDGER_ID = L_LEDGER_ID;
1094:
1095: GL_MESSAGE.Write_Log(MSG_NAME =>'FLAT0003',
1096: TOKEN_NUM => 2,
1097: T1 =>'SEGMENT_VALUE',
1098: V1 =>L_SEGMENT_VAL,
1099: T2 =>'LEDGER_NAME',

Line 1108: GL_MESSAGE.FUNC_FAIL(FUNC_NAME =>

1104: END LOOP;
1105:
1106: IF (Cursor_Lv_Ledger%ROWCOUNT >= 1) THEN
1107:
1108: GL_MESSAGE.FUNC_FAIL(FUNC_NAME =>
1109: 'GL_FLATTEN_LEDGER_SEG_VALS.Error_Check');
1110:
1111: RETURN FALSE;
1112:

Line 1180: GL_MESSAGE.Write_Log(MSG_NAME =>'FLAT0003',

1176: SELECT NAME INTO L_LEDGER_NAME
1177: FROM GL_LEDGERS
1178: WHERE LEDGER_ID = L_LEDGER_ID;
1179:
1180: GL_MESSAGE.Write_Log(MSG_NAME =>'FLAT0003',
1181: TOKEN_NUM => 2,
1182: T1 =>'SEGMENT_VALUE',
1183: V1 => L_Segment_Val,
1184: T2 =>'LEDGER_NAME',

Line 1193: GL_MESSAGE.FUNC_FAIL(FUNC_NAME =>

1189: END LOOP;
1190:
1191: IF (Cursor_SH_Ledger%ROWCOUNT >= 1) THEN
1192:
1193: GL_MESSAGE.FUNC_FAIL(FUNC_NAME =>
1194: 'GL_FLATTEN_LEDGER_SEG_VALS.Error_Check');
1195:
1196: RETURN FALSE;
1197:

Line 1206: GL_MESSAGE.FUNC_FAIL(FUNC_NAME =>

1202: EXCEPTION
1203:
1204: WHEN OTHERS THEN
1205:
1206: GL_MESSAGE.FUNC_FAIL(FUNC_NAME =>
1207: 'GL_FLATTEN_LEDGER_SEG_VALS.Error_Check');
1208:
1209: RETURN FALSE;
1210:

Line 1215: GL_MESSAGE.FUNC_SUCC(FUNC_NAME =>

1211: END; -- 'SH' and 'FF' mode PL/SQL block ends
1212:
1213: END IF; -- 'SH' and 'FF' Opearation mode If control block ends here.
1214:
1215: GL_MESSAGE.FUNC_SUCC(FUNC_NAME =>
1216: 'GL_FLATTEN_LEDGER_SEG_VALS.Error_Check');
1217:
1218: RETURN TRUE;
1219:

Line 1224: GL_MESSAGE.FUNC_SUCC(FUNC_NAME =>

1220: EXCEPTION
1221:
1222: WHEN NO_DATA_FOUND THEN
1223:
1224: GL_MESSAGE.FUNC_SUCC(FUNC_NAME =>
1225: 'GL_FLATTEN_LEDGER_SEG_VALS.Error_Check');
1226:
1227: RETURN TRUE;
1228:

Line 1231: GL_MESSAGE.Write_Log(MSG_NAME =>'SHRD0102',

1227: RETURN TRUE;
1228:
1229: WHEN OTHERS THEN
1230:
1231: GL_MESSAGE.Write_Log(MSG_NAME =>'SHRD0102',
1232: TOKEN_NUM => 1,
1233: T1 =>'EMESSAGE',
1234: V1 => SQLERRM);
1235:

Line 1236: GL_MESSAGE.FUNC_FAIL(FUNC_NAME =>

1232: TOKEN_NUM => 1,
1233: T1 =>'EMESSAGE',
1234: V1 => SQLERRM);
1235:
1236: GL_MESSAGE.FUNC_FAIL(FUNC_NAME =>
1237: 'GL_FLATTEN_LEDGER_SEG_VALS.Error_Check');
1238:
1239: RETURN FALSE;
1240: