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_JOURNALS_AUTOCOPY dependencies on GL_JOURNALS_AUTOCOPY

Line 1: PACKAGE BODY GL_JOURNALS_AUTOCOPY AS

1: PACKAGE BODY GL_JOURNALS_AUTOCOPY AS
2: /* $Header: glujecpb.pls 120.15 2012/01/25 09:33:55 degoel ship $ */
3:
4: -- ********************************************************************
5:

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 42: v1 =>'GL_JOURNALS_AUTOCOPY.do_autocopy',

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',
44: v2 =>'Debug Mode',
45: t3 =>'VALUE',
46: v3 => dmode_profile);

Line 56: v1 =>'GL_JOURNALS_AUTOCOPY.do_autocopy',

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',
58: v2 =>'JEB_ID',
59: t3 =>'VALUE',
60: v3 => to_char(Jeb_id));

Line 64: v1 =>'GL_JOURNALS_AUTOCOPY.do_autocopy',

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',
66: v2 =>'NEW_NAME',
67: t3 =>'VALUE',
68: v3 => New_Name);

Line 72: v1 =>'GL_JOURNALS_AUTOCOPY.do_autocopy',

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',
74: v2 =>'NEW_PERIOD_NAME',
75: t3 =>'VALUE',
76: v3 => New_Period_Name);

Line 80: v1 =>'GL_JOURNALS_AUTOCOPY.do_autocopy',

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',
82: v2 =>'NEW_EFF_DATE',
83: t3 =>'VALUE',
84: v3 => to_char(New_Eff_Date,'DD-MON-RR'));

Line 88: v1 =>'GL_JOURNALS_AUTOCOPY.do_autocopy',

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',
90: v2 =>'ORG_ID',
91: t3 =>'VALUE',
92: v3 => Org_id);

Line 96: v1 =>'GL_JOURNALS_AUTOCOPY.do_autocopy',

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',
98: v2 =>'SEQ_NUM',
99: t3 =>'VALUE',
100: v3 => Seq_Num);

Line 133: v1 =>'GL_JOURNALS_AUTOCOPY.do_autocopy',

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',
135: v2 =>'NEW_JEB_ID',
136: t3 =>'VALUE',
137: v3 => to_char(new_jeb_id));

Line 164: v1 =>'GL_JOURNALS_AUTOCOPY.do_autocopy',

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',
166: v2 =>'BC_FLAG',
167: t3 =>'VALUE',
168: v3 => bc_flag);

Line 172: v1 =>'GL_JOURNALS_AUTOCOPY.do_autocopy',

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',
174: v2 =>'APPROVAL_FLAG',
175: t3 =>'VALUE',
176: v3 => approval_flag);

Line 305: v1 =>'GL_JOURNALS_AUTOCOPY.do_autocopy',

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',
307: v2 =>'REV_METHOD',
308: t3 =>'VALUE',
309: v3 => rev_method);

Line 313: v1 =>'GL_JOURNALS_AUTOCOPY.do_autocopy',

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',
315: v2 =>'REV_PERIOD',
316: t3 =>'VALUE',
317: v3 => rev_period);

Line 321: v1 =>'GL_JOURNALS_AUTOCOPY.do_autocopy',

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',
323: v2 =>'REV_DATE',
324: t3 =>'VALUE',
325: v3 => to_char(rev_date,'DD-MON-RR'));

Line 329: v1 =>'GL_JOURNALS_AUTOCOPY.do_autocopy',

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',
331: v2 =>'CONVERSION_RATE',
332: t3 =>'VALUE',
333: v3 => to_char(conversion_rate,

Line 338: v1 =>'GL_JOURNALS_AUTOCOPY.do_autocopy',

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',
340: v2 =>'CONV_DATE',
341: t3 =>'VALUE',
342: v3 => to_char(conversion_date,

Line 584: v1 =>'GL_JOURNALS_AUTOCOPY.do_autocopy',

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',
586: v2 =>'JE_CATEGORY',
587: t3 =>'VALUE',
588: v3 => je_category);

Line 592: v1 =>'GL_JOURNALS_AUTOCOPY.do_autocopy',

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',
594: v2 =>'LGR_ID',
595: t3 =>'VALUE',
596: v3 => to_char(lgr_id));

Line 600: v1 =>'GL_JOURNALS_AUTOCOPY.do_autocopy',

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',
602: v2 =>'EFFDATE',
603: t3 =>'VALUE',
604: v3 => to_char(New_eff_date,

Line 622: v1 =>'GL_JOURNALS_AUTOCOPY.do_autocopy',

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',
624: v2 =>'SEQ_RESULT',
625: t3 =>'VALUE',
626: v3 => to_char(seq_result));

Line 630: v1 =>'GL_JOURNALS_AUTOCOPY.do_autocopy',

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',
632: v2 =>'SEQ_VAL',
633: t3 =>'VALUE',
634: v3 => to_char(seq_val));

Line 638: v1 =>'GL_JOURNALS_AUTOCOPY.do_autocopy',

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',
640: v2 =>'SEQ_ID',
641: t3 =>'VALUE',
642: v3 => to_char(seq_id));

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 685: GL_JOURNALS_AUTOCOPY.do_autocopy(

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,
689: New_Eff_Date => to_date(New_Eff_Date, 'YYYY/MM/DD'),

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;

Line 702: END GL_JOURNALS_AUTOCOPY;

698: ROLLBACK;
699: app_exception.raise_exception;
700: END do_autocopy;
701:
702: END GL_JOURNALS_AUTOCOPY;