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 457: GL_MESSAGE.Write_Log(msg_name =>'SHRD0117',

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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