DBA Data[Home] [Help]

APPS.GL_JOURNALS_AUTOCOPY dependencies on GL_MESSAGE

Line 28: GL_MESSAGE.Func_Ent(func_name => 'GL_JOURNALS_AUTOCOPY.do_autocopy');

24: org_id NUMBER;
25: temp NUMBER;
26: BEGIN
27:
28: GL_MESSAGE.Func_Ent(func_name => 'GL_JOURNALS_AUTOCOPY.do_autocopy');
29:
30: -- Obtain user ID and login ID
31: usr_id := FND_GLOBAL.User_Id;
32: log_id := FND_GLOBAL.Login_Id;

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

35: FND_PROFILE.GET('GL_DEBUG_MODE', dmode_profile);
36: FND_PROFILE.GET('ORG_ID', x_org_id);
37: FND_PROFILE.GET('UNIQUE:SEQ_NUMBERS', seq_num);
38:
39: GL_MESSAGE.Write_Log(msg_name =>'SHRD0181',
40: token_num => 3 ,
41: t1 =>'ROUTINE',
42: v1 =>'GL_JOURNALS_AUTOCOPY.do_autocopy',
43: t2 =>'VARIABLE',

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

49: IF (NVL(X_Debug, 'N') <> 'N') OR (dmode_profile = 'Y') THEN
50: dmode := TRUE;
51:
52: -- If debug mode, print out what we have so far
53: GL_MESSAGE.Write_Log(msg_name =>'SHRD0181',
54: token_num => 3 ,
55: t1 =>'ROUTINE',
56: v1 =>'GL_JOURNALS_AUTOCOPY.do_autocopy',
57: t2 =>'VARIABLE',

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

57: t2 =>'VARIABLE',
58: v2 =>'JEB_ID',
59: t3 =>'VALUE',
60: v3 => to_char(Jeb_id));
61: GL_MESSAGE.Write_Log(msg_name =>'SHRD0181',
62: token_num => 3 ,
63: t1 =>'ROUTINE',
64: v1 =>'GL_JOURNALS_AUTOCOPY.do_autocopy',
65: t2 =>'VARIABLE',

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

65: t2 =>'VARIABLE',
66: v2 =>'NEW_NAME',
67: t3 =>'VALUE',
68: v3 => New_Name);
69: GL_MESSAGE.Write_Log(msg_name =>'SHRD0181',
70: token_num => 3 ,
71: t1 =>'ROUTINE',
72: v1 =>'GL_JOURNALS_AUTOCOPY.do_autocopy',
73: t2 =>'VARIABLE',

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

73: t2 =>'VARIABLE',
74: v2 =>'NEW_PERIOD_NAME',
75: t3 =>'VALUE',
76: v3 => New_Period_Name);
77: GL_MESSAGE.Write_Log(msg_name =>'SHRD0181',
78: token_num => 3 ,
79: t1 =>'ROUTINE',
80: v1 =>'GL_JOURNALS_AUTOCOPY.do_autocopy',
81: t2 =>'VARIABLE',

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

81: t2 =>'VARIABLE',
82: v2 =>'NEW_EFF_DATE',
83: t3 =>'VALUE',
84: v3 => to_char(New_Eff_Date,'DD-MON-RR'));
85: GL_MESSAGE.Write_Log(msg_name =>'SHRD0181',
86: token_num => 3 ,
87: t1 =>'ROUTINE',
88: v1 =>'GL_JOURNALS_AUTOCOPY.do_autocopy',
89: t2 =>'VARIABLE',

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

89: t2 =>'VARIABLE',
90: v2 =>'ORG_ID',
91: t3 =>'VALUE',
92: v3 => Org_id);
93: GL_MESSAGE.Write_Log(msg_name =>'SHRD0181',
94: token_num => 3 ,
95: t1 =>'ROUTINE',
96: v1 =>'GL_JOURNALS_AUTOCOPY.do_autocopy',
97: t2 =>'VARIABLE',

Line 113: GL_MESSAGE.Write_Log(msg_name =>'JECP0000',

109: FROM gl_je_batches
110: WHERE je_batch_id = jeb_id;
111: EXCEPTION
112: WHEN NO_DATA_FOUND THEN
113: GL_MESSAGE.Write_Log(msg_name =>'JECP0000',
114: token_num => 1,
115: t1 =>'JEB_ID',
116: v1 =>to_char(jeb_id));
117: Raise GLUJECPB_FATAL_ERR;

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

126: Raise GLUJECPB_FATAL_ERR;
127: END IF;
128:
129: IF (dmode) THEN
130: GL_MESSAGE.Write_Log(msg_name =>'SHRD0181',
131: token_num => 3 ,
132: t1 =>'ROUTINE',
133: v1 =>'GL_JOURNALS_AUTOCOPY.do_autocopy',
134: t2 =>'VARIABLE',

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

157: WHERE je_source_name = 'AutoCopy';--Modified the source from Manual to Autocopy as part of bug7373688
158: END IF;
159:
160: IF (dmode) THEN
161: GL_MESSAGE.Write_Log(msg_name =>'SHRD0181',
162: token_num => 3 ,
163: t1 =>'ROUTINE',
164: v1 =>'GL_JOURNALS_AUTOCOPY.do_autocopy',
165: t2 =>'VARIABLE',

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

165: t2 =>'VARIABLE',
166: v2 =>'BC_FLAG',
167: t3 =>'VALUE',
168: v3 => bc_flag);
169: GL_MESSAGE.Write_Log(msg_name =>'SHRD0181',
170: token_num => 3 ,
171: t1 =>'ROUTINE',
172: v1 =>'GL_JOURNALS_AUTOCOPY.do_autocopy',
173: t2 =>'VARIABLE',

Line 212: GL_MESSAGE.Write_Log(msg_name =>'SHRD0117',

208: Raise GLUJECPB_FATAL_ERR;
209: END IF;
210:
211: temp := SQL%ROWCOUNT;
212: GL_MESSAGE.Write_Log(msg_name =>'SHRD0117',
213: token_num => 2 ,
214: t1 =>'NUM',
215: v1 =>to_char(temp),
216: t2 =>'TABLE',

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

298: conversion_date := New_eff_date;
299: END IF;
300:
301: IF (dmode) THEN
302: GL_MESSAGE.Write_Log(msg_name =>'SHRD0181',
303: token_num => 3 ,
304: t1 =>'ROUTINE',
305: v1 =>'GL_JOURNALS_AUTOCOPY.do_autocopy',
306: t2 =>'VARIABLE',

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

306: t2 =>'VARIABLE',
307: v2 =>'REV_METHOD',
308: t3 =>'VALUE',
309: v3 => rev_method);
310: GL_MESSAGE.Write_Log(msg_name =>'SHRD0181',
311: token_num => 3 ,
312: t1 =>'ROUTINE',
313: v1 =>'GL_JOURNALS_AUTOCOPY.do_autocopy',
314: t2 =>'VARIABLE',

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

314: t2 =>'VARIABLE',
315: v2 =>'REV_PERIOD',
316: t3 =>'VALUE',
317: v3 => rev_period);
318: GL_MESSAGE.Write_Log(msg_name =>'SHRD0181',
319: token_num => 3 ,
320: t1 =>'ROUTINE',
321: v1 =>'GL_JOURNALS_AUTOCOPY.do_autocopy',
322: t2 =>'VARIABLE',

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

322: t2 =>'VARIABLE',
323: v2 =>'REV_DATE',
324: t3 =>'VALUE',
325: v3 => to_char(rev_date,'DD-MON-RR'));
326: GL_MESSAGE.Write_Log(msg_name =>'SHRD0181',
327: token_num => 3 ,
328: t1 =>'ROUTINE',
329: v1 =>'GL_JOURNALS_AUTOCOPY.do_autocopy',
330: t2 =>'VARIABLE',

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

331: v2 =>'CONVERSION_RATE',
332: t3 =>'VALUE',
333: v3 => to_char(conversion_rate,
334: '999999999999.99999999999999'));
335: GL_MESSAGE.Write_Log(msg_name =>'SHRD0181',
336: token_num => 3 ,
337: t1 =>'ROUTINE',
338: v1 =>'GL_JOURNALS_AUTOCOPY.do_autocopy',
339: t2 =>'VARIABLE',

Line 394: GL_MESSAGE.Write_Log(msg_name =>'SHRD0117',

390: END LOOP;
391: END;
392:
393: temp := SQL%ROWCOUNT;
394: GL_MESSAGE.Write_Log(msg_name =>'SHRD0117',
395: token_num => 2 ,
396: t1 =>'NUM',
397: v1 =>to_char(temp),
398: t2 =>'TABLE',

Line 459: GL_MESSAGE.Write_Log(msg_name =>'SHRD0117',

455: AND jel.je_header_id = jeh1.je_header_id
456: AND nvl(jel.tax_line_flag,'N') = 'N';
457:
458: temp := SQL%ROWCOUNT;
459: GL_MESSAGE.Write_Log(msg_name =>'SHRD0117',
460: token_num => 2 ,
461: t1 =>'NUM',
462: v1 =>to_char(temp),
463: t2 =>'TABLE',

Line 484: GL_MESSAGE.Write_Log(msg_name =>'SHRD0117',

480: || ' ' || to_char(jeh1.je_header_id))
481: AND sv.je_header_id = jeh1.je_header_id;
482:
483: temp := SQL%ROWCOUNT;
484: GL_MESSAGE.Write_Log(msg_name =>'SHRD0117',
485: token_num => 2 ,
486: t1 =>'NUM',
487: v1 =>to_char(temp),
488: t2 =>'TABLE',

Line 524: GL_MESSAGE.Write_Log(msg_name =>'SHRD0117',

520: AND rec.je_header_id(+) = jel.je_header_id
521: AND rec.je_line_num(+) = jel.je_line_num;
522:
523: temp := SQL%ROWCOUNT;
524: GL_MESSAGE.Write_Log(msg_name =>'SHRD0117',
525: token_num => 2 ,
526: t1 =>'NUM',
527: v1 =>to_char(temp),
528: t2 =>'TABLE',

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

577: FETCH new_journals INTO row_id, lgr_id, je_category, je_name;
578: EXIT WHEN new_journals%NOTFOUND;
579:
580: IF (dmode) THEN
581: GL_MESSAGE.Write_Log(msg_name =>'SHRD0181',
582: token_num => 3 ,
583: t1 =>'ROUTINE',
584: v1 =>'GL_JOURNALS_AUTOCOPY.do_autocopy',
585: t2 =>'VARIABLE',

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

585: t2 =>'VARIABLE',
586: v2 =>'JE_CATEGORY',
587: t3 =>'VALUE',
588: v3 => je_category);
589: GL_MESSAGE.Write_Log(msg_name =>'SHRD0181',
590: token_num => 3 ,
591: t1 =>'ROUTINE',
592: v1 =>'GL_JOURNALS_AUTOCOPY.do_autocopy',
593: t2 =>'VARIABLE',

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

593: t2 =>'VARIABLE',
594: v2 =>'LGR_ID',
595: t3 =>'VALUE',
596: v3 => to_char(lgr_id));
597: GL_MESSAGE.Write_Log(msg_name =>'SHRD0181',
598: token_num => 3 ,
599: t1 =>'ROUTINE',
600: v1 =>'GL_JOURNALS_AUTOCOPY.do_autocopy',
601: t2 =>'VARIABLE',

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

615: docseq_id => seq_id,
616: suppress_warn => 'Y');
617:
618: IF (dmode) THEN
619: GL_MESSAGE.Write_Log(msg_name =>'SHRD0181',
620: token_num => 3 ,
621: t1 =>'ROUTINE',
622: v1 =>'GL_JOURNALS_AUTOCOPY.do_autocopy',
623: t2 =>'VARIABLE',

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

623: t2 =>'VARIABLE',
624: v2 =>'SEQ_RESULT',
625: t3 =>'VALUE',
626: v3 => to_char(seq_result));
627: GL_MESSAGE.Write_Log(msg_name =>'SHRD0181',
628: token_num => 3 ,
629: t1 =>'ROUTINE',
630: v1 =>'GL_JOURNALS_AUTOCOPY.do_autocopy',
631: t2 =>'VARIABLE',

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

631: t2 =>'VARIABLE',
632: v2 =>'SEQ_VAL',
633: t3 =>'VALUE',
634: v3 => to_char(seq_val));
635: GL_MESSAGE.Write_Log(msg_name =>'SHRD0181',
636: token_num => 3 ,
637: t1 =>'ROUTINE',
638: v1 =>'GL_JOURNALS_AUTOCOPY.do_autocopy',
639: t2 =>'VARIABLE',

Line 651: GL_MESSAGE.Write_Log(msg_name =>'JECP0001',

647: SET doc_sequence_id = seq_id,
648: doc_sequence_value = seq_val
649: WHERE rowid = row_id;
650: ELSIF (seq_num = 'A') THEN
651: GL_MESSAGE.Write_Log(msg_name =>'JECP0001',
652: token_num => 2 ,
653: t1 =>'NAME',
654: v1 => je_name);
655: Raise GLUJECPB_FATAL_ERR;

Line 665: GL_MESSAGE.Func_Succ(func_name => 'GL_JOURNALS_AUTOCOPY.do_autocopy');

661:
662: -- Commit all work
663: FND_CONCURRENT.Af_Commit;
664:
665: GL_MESSAGE.Func_Succ(func_name => 'GL_JOURNALS_AUTOCOPY.do_autocopy');
666:
667: EXCEPTION
668: WHEN OTHERS THEN
669: Rollback;

Line 670: GL_MESSAGE.Func_Fail(func_name => 'GL_JOURNALS_AUTOCOPY.do_autocopy');

666:
667: EXCEPTION
668: WHEN OTHERS THEN
669: Rollback;
670: GL_MESSAGE.Func_Fail(func_name => 'GL_JOURNALS_AUTOCOPY.do_autocopy');
671: RAISE;
672: END do_autocopy;
673:
674: -- ********************************************************************

Line 684: GL_MESSAGE.Func_Ent(func_name => 'GL_JOURNALS_AUTOCOPY.do_autocopy');

680: New_Period_Name VARCHAR2,
681: New_Eff_Date VARCHAR2,
682: X_Debug VARCHAR2 DEFAULT NULL) IS
683: BEGIN
684: GL_MESSAGE.Func_Ent(func_name => 'GL_JOURNALS_AUTOCOPY.do_autocopy');
685: GL_JOURNALS_AUTOCOPY.do_autocopy(
686: Jeb_id => Jeb_id,
687: New_Name => New_Name,
688: New_Period_Name => New_Period_Name,

Line 691: GL_MESSAGE.Func_Succ(func_name => 'GL_JOURNALS_AUTOCOPY.do_autocopy');

687: New_Name => New_Name,
688: New_Period_Name => New_Period_Name,
689: New_Eff_Date => to_date(New_Eff_Date, 'YYYY/MM/DD'),
690: X_Debug => X_Debug);
691: GL_MESSAGE.Func_Succ(func_name => 'GL_JOURNALS_AUTOCOPY.do_autocopy');
692:
693: EXCEPTION
694: WHEN OTHERS THEN
695: GL_MESSAGE.Func_Fail(func_name => 'GL_JOURNALS_AUTOCOPY.do_autocopy');

Line 695: GL_MESSAGE.Func_Fail(func_name => 'GL_JOURNALS_AUTOCOPY.do_autocopy');

691: GL_MESSAGE.Func_Succ(func_name => 'GL_JOURNALS_AUTOCOPY.do_autocopy');
692:
693: EXCEPTION
694: WHEN OTHERS THEN
695: GL_MESSAGE.Func_Fail(func_name => 'GL_JOURNALS_AUTOCOPY.do_autocopy');
696: errbuf := SQLERRM ;
697: retcode := '2';
698: ROLLBACK;
699: app_exception.raise_exception;