DBA Data[Home] [Help]

APPS.FII_AR_COLLECTORS_PKG dependencies on FII_AR_COLLECTORS_PKG

Line 1: PACKAGE BODY FII_AR_COLLECTORS_PKG AS

1: PACKAGE BODY FII_AR_COLLECTORS_PKG AS
2: /* $Header: FIIARCOLLB.pls 120.7.12000000.2 2007/03/16 20:51:22 vkazhipu ship $ */
3:
4: g_phase VARCHAR2(120);
5: g_schema_name VARCHAR2(120) := 'FII';

Line 20: FII_MESSAGE.Func_Ent ('FII_AR_COLLECTORS_PKG.Initialize');

16:
17: BEGIN
18:
19: IF (FIIDIM_Debug) THEN
20: FII_MESSAGE.Func_Ent ('FII_AR_COLLECTORS_PKG.Initialize');
21: END IF;
22:
23: g_phase := 'Do set up for log file';
24: ----------------------------------------------

Line 41: FII_UTIL.initialize('FII_AR_COLLECTORS_PKG.log',

37: ----------------------------------------------------------------
38: -- FII_UTIL.initialize will set up the directory where
39: -- the log files and output files are written to
40: ----------------------------------------------------------------
41: FII_UTIL.initialize('FII_AR_COLLECTORS_PKG.log',
42: 'FII_AR_COLLECTORS_PKG.out',l_dir,'FII_AR_COLLECTORS_PKG');
43:
44:
45: -- Obtain FII schema name

Line 42: 'FII_AR_COLLECTORS_PKG.out',l_dir,'FII_AR_COLLECTORS_PKG');

38: -- FII_UTIL.initialize will set up the directory where
39: -- the log files and output files are written to
40: ----------------------------------------------------------------
41: FII_UTIL.initialize('FII_AR_COLLECTORS_PKG.log',
42: 'FII_AR_COLLECTORS_PKG.out',l_dir,'FII_AR_COLLECTORS_PKG');
43:
44:
45: -- Obtain FII schema name
46: g_phase := 'Obtain Schema name, User ID, Login ID';

Line 64: FII_MESSAGE.Func_Succ ('FII_AR_COLLECTORS_PKG.Initialize');

60: IF (FIIDIM_Debug) THEN
61: -- Program running in debug mode, turning trace on
62: EXECUTE IMMEDIATE 'ALTER SESSION SET SQL_TRACE TRUE';
63: FII_UTIL.Write_Log ('Initialize: Set Trace On');
64: FII_MESSAGE.Func_Succ ('FII_AR_COLLECTORS_PKG.Initialize');
65: END IF;
66:
67: EXCEPTION
68:

Line 70: FII_UTIL.Write_Log ('FII_AR_COLLECTORS_PKG.Initialize : '|| 'User defined error');

66:
67: EXCEPTION
68:
69: WHEN CODIM_fatal_err THEN
70: FII_UTIL.Write_Log ('FII_AR_COLLECTORS_PKG.Initialize : '|| 'User defined error');
71: FND_CONCURRENT.Af_Rollback;
72: FII_MESSAGE.Func_Fail(func_name => 'FII_AR_COLLECTORS_PKG.Initialize');
73: RAISE;
74:

Line 72: FII_MESSAGE.Func_Fail(func_name => 'FII_AR_COLLECTORS_PKG.Initialize');

68:
69: WHEN CODIM_fatal_err THEN
70: FII_UTIL.Write_Log ('FII_AR_COLLECTORS_PKG.Initialize : '|| 'User defined error');
71: FND_CONCURRENT.Af_Rollback;
72: FII_MESSAGE.Func_Fail(func_name => 'FII_AR_COLLECTORS_PKG.Initialize');
73: RAISE;
74:
75: WHEN OTHERS THEN
76: FII_UTIL.Write_Log ('Unexpected error when calling Initialize...');

Line 102: FII_MESSAGE.Func_Ent(func_name => 'FII_AR_COLLECTORS_PKG.Init_Load');

98: FIIDIM_Debug := FALSE;
99: END IF;
100:
101: IF (FIIDIM_Debug) THEN
102: FII_MESSAGE.Func_Ent(func_name => 'FII_AR_COLLECTORS_PKG.Init_Load');
103: FII_UTIL.Write_Log (' Debug On');
104: ELSE
105: FII_UTIL.Write_Log (' Debug Off');
106: END IF;

Line 255: FII_MESSAGE.Func_Succ(func_name => 'FII_AR_COLLECTORS_PKG.Init_Load');

251:
252: FND_CONCURRENT.Af_Commit;
253:
254: IF (FIIDIM_Debug) THEN
255: FII_MESSAGE.Func_Succ(func_name => 'FII_AR_COLLECTORS_PKG.Init_Load');
256: END IF;
257:
258: --Added by vkazhipu for customer bug 5763652
259:

Line 272: FII_UTIL.Write_Log ('FII_AR_COLLECTORS_PKG.Init_Load: '||

268: EXCEPTION
269:
270: WHEN CODIM_fatal_err THEN
271:
272: FII_UTIL.Write_Log ('FII_AR_COLLECTORS_PKG.Init_Load: '||
273: 'User defined error');
274:
275: FND_CONCURRENT.Af_Rollback;
276: FII_MESSAGE.Func_Fail(func_name => 'FII_AR_COLLECTORS_PKG.Init_Load');

Line 276: FII_MESSAGE.Func_Fail(func_name => 'FII_AR_COLLECTORS_PKG.Init_Load');

272: FII_UTIL.Write_Log ('FII_AR_COLLECTORS_PKG.Init_Load: '||
273: 'User defined error');
274:
275: FND_CONCURRENT.Af_Rollback;
276: FII_MESSAGE.Func_Fail(func_name => 'FII_AR_COLLECTORS_PKG.Init_Load');
277: retcode := sqlcode;
278: ret_val := FND_CONCURRENT.Set_Completion_Status
279: (status => 'ERROR', message => substr(sqlerrm,1,180));
280:

Line 284: 'Other error IN FII_AR_COLLECTORS_PKG.Init_Load: ' || substr(sqlerrm,1,180));

280:
281: WHEN OTHERS THEN
282: FII_UTIL.Write_Log ('Init_Load -> phase: '|| g_phase);
283: FII_UTIL.Write_Log (
284: 'Other error IN FII_AR_COLLECTORS_PKG.Init_Load: ' || substr(sqlerrm,1,180));
285:
286:
287: FND_CONCURRENT.Af_Rollback;
288: FII_MESSAGE.Func_Fail(func_name => 'FII_AR_COLLECTORS_PKG.Init_Load');

Line 288: FII_MESSAGE.Func_Fail(func_name => 'FII_AR_COLLECTORS_PKG.Init_Load');

284: 'Other error IN FII_AR_COLLECTORS_PKG.Init_Load: ' || substr(sqlerrm,1,180));
285:
286:
287: FND_CONCURRENT.Af_Rollback;
288: FII_MESSAGE.Func_Fail(func_name => 'FII_AR_COLLECTORS_PKG.Init_Load');
289: retcode := sqlcode;
290: ret_val := FND_CONCURRENT.Set_Completion_Status
291: (status => 'ERROR', message => substr(sqlerrm,1,180));
292:

Line 325: FII_MESSAGE.Func_Ent(func_name => 'FII_AR_COLLECTORS_PKG.Incre_Update');

321: FIIDIM_Debug := FALSE;
322: END IF;
323:
324: IF (FIIDIM_Debug) THEN
325: FII_MESSAGE.Func_Ent(func_name => 'FII_AR_COLLECTORS_PKG.Incre_Update');
326: FII_UTIL.Write_Log (' Debug On');
327: ELSE
328: FII_UTIL.Write_Log (' Debug Off');
329: END IF;

Line 567: FII_MESSAGE.Func_Succ(func_name => 'FII_AR_COLLECTORS_PKG.Incre_Update');

563:
564: FND_CONCURRENT.Af_Commit;
565:
566: IF (FIIDIM_Debug) THEN
567: FII_MESSAGE.Func_Succ(func_name => 'FII_AR_COLLECTORS_PKG.Incre_Update');
568: END IF;
569:
570: --Added by vkazhipu for customer bug 5763652
571: BIS_COLLECTION_UTILITIES.wrapup(

Line 580: FII_UTIL.Write_Log ('FII_AR_COLLECTORS_PKG.Incre_Update'||

576: -- Exception handling
577:
578: EXCEPTION
579: WHEN CODIM_fatal_err THEN
580: FII_UTIL.Write_Log ('FII_AR_COLLECTORS_PKG.Incre_Update'||
581: 'User defined error');
582:
583: FND_CONCURRENT.Af_Rollback;
584: FII_MESSAGE.Func_Fail(func_name => 'FII_AR_COLLECTORS_PKG.Incre_Update');

Line 584: FII_MESSAGE.Func_Fail(func_name => 'FII_AR_COLLECTORS_PKG.Incre_Update');

580: FII_UTIL.Write_Log ('FII_AR_COLLECTORS_PKG.Incre_Update'||
581: 'User defined error');
582:
583: FND_CONCURRENT.Af_Rollback;
584: FII_MESSAGE.Func_Fail(func_name => 'FII_AR_COLLECTORS_PKG.Incre_Update');
585: retcode := sqlcode;
586: ret_val := FND_CONCURRENT.Set_Completion_Status
587: (status => 'ERROR', message => substr(sqlerrm,1,180));
588:

Line 592: 'Other error IN FII_AR_COLLECTORS_PKG.Incre_Update: ' || substr(sqlerrm,1,180));

588:
589: WHEN OTHERS THEN
590: FII_UTIL.Write_Log ('Incre_Update -> phase: '|| g_phase);
591: FII_UTIL.Write_Log (
592: 'Other error IN FII_AR_COLLECTORS_PKG.Incre_Update: ' || substr(sqlerrm,1,180));
593:
594: FND_CONCURRENT.Af_Rollback;
595: FII_MESSAGE.Func_Fail(func_name => 'FII_AR_COLLECTORS_PKG.Incre_Update');
596: retcode := sqlcode;

Line 595: FII_MESSAGE.Func_Fail(func_name => 'FII_AR_COLLECTORS_PKG.Incre_Update');

591: FII_UTIL.Write_Log (
592: 'Other error IN FII_AR_COLLECTORS_PKG.Incre_Update: ' || substr(sqlerrm,1,180));
593:
594: FND_CONCURRENT.Af_Rollback;
595: FII_MESSAGE.Func_Fail(func_name => 'FII_AR_COLLECTORS_PKG.Incre_Update');
596: retcode := sqlcode;
597: ret_val := FND_CONCURRENT.Set_Completion_Status
598: (status => 'ERROR', message => substr(sqlerrm,1,180));
599:

Line 604: END FII_AR_COLLECTORS_PKG;

600: END Incre_Update;
601:
602:
603:
604: END FII_AR_COLLECTORS_PKG;