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.6.12010000.6 2008/11/25 08:45:04 skotakar 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 582: v1 =>'GL_JOURNALS_AUTOCOPY.do_autocopy',

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

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

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

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

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

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

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

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

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

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

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

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

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

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;

Line 700: END GL_JOURNALS_AUTOCOPY;

696: ROLLBACK;
697: app_exception.raise_exception;
698: END do_autocopy;
699:
700: END GL_JOURNALS_AUTOCOPY;