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.FII_AR_COLLECTORS_PKG dependencies on FII_UTIL

Line 34: l_dir := FII_UTIL.get_utl_file_dir;

30: -- Set default directory in case if the profile option
31: -- BIS_DEBUG_LOG_DIRECTORY is not set up
32: ------------------------------------------------------
33: IF l_dir IS NULL then
34: l_dir := FII_UTIL.get_utl_file_dir;
35: END IF;
36:
37: ----------------------------------------------------------------
38: -- FII_UTIL.initialize will set up the directory where

Line 38: -- FII_UTIL.initialize will set up the directory where

34: l_dir := FII_UTIL.get_utl_file_dir;
35: END IF;
36:
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');

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 47: g_schema_name := FII_UTIL.get_schema_name ('FII');

43:
44:
45: -- Obtain FII schema name
46: g_phase := 'Obtain Schema name, User ID, Login ID';
47: g_schema_name := FII_UTIL.get_schema_name ('FII');
48:
49: -- Obtain user ID, login ID and initialize package variables
50: FII_USER_ID := FND_GLOBAL.USER_ID;
51: FII_LOGIN_ID := FND_GLOBAL.LOGIN_ID;

Line 55: FII_UTIL.Write_Log ('>>> Failed Initialization');

51: FII_LOGIN_ID := FND_GLOBAL.LOGIN_ID;
52:
53: -- If any of the above values is not set, error out
54: IF (FII_USER_ID is NULL OR FII_LOGIN_ID is NULL) THEN
55: FII_UTIL.Write_Log ('>>> Failed Initialization');
56: RAISE CODIM_fatal_err;
57: END IF;
58:
59: -- Turn trace on if process is running in debug mode

Line 63: FII_UTIL.Write_Log ('Initialize: Set Trace On');

59: -- Turn trace on if process is running in debug mode
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

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 76: FII_UTIL.Write_Log ('Unexpected error when calling Initialize...');

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...');
77: FII_UTIL.Write_Log ( 'g_phase: ' || g_phase);
78: FII_UTIL.Write_Log ('Error Message: '|| substr(sqlerrm,1,180));
79: RAISE;
80:

Line 77: FII_UTIL.Write_Log ( 'g_phase: ' || g_phase);

73: RAISE;
74:
75: WHEN OTHERS THEN
76: FII_UTIL.Write_Log ('Unexpected error when calling Initialize...');
77: FII_UTIL.Write_Log ( 'g_phase: ' || g_phase);
78: FII_UTIL.Write_Log ('Error Message: '|| substr(sqlerrm,1,180));
79: RAISE;
80:
81: END Initialize;

Line 78: FII_UTIL.Write_Log ('Error Message: '|| substr(sqlerrm,1,180));

74:
75: WHEN OTHERS THEN
76: FII_UTIL.Write_Log ('Unexpected error when calling Initialize...');
77: FII_UTIL.Write_Log ( 'g_phase: ' || g_phase);
78: FII_UTIL.Write_Log ('Error Message: '|| substr(sqlerrm,1,180));
79: RAISE;
80:
81: END Initialize;
82:

Line 103: FII_UTIL.Write_Log (' Debug On');

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;
107:

Line 105: FII_UTIL.Write_Log (' Debug Off');

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;
107:
108: --First do the initialization
109:

Line 124: FII_UTIL.Write_Log(g_phase);

120:
121:
122: g_phase := 'Populating COLL_BATCH_PARTY_ID in fii_change_log';
123: IF (FIIDIM_Debug) THEN
124: FII_UTIL.Write_Log(g_phase);
125: End if;
126:
127: select nvl(max(batch_party_id), -1)
128: into l_max_batch_party_id

Line 160: FII_UTIL.Write_Log ('Now start processing '|| 'Collector dimension');

156: END IF;
157:
158:
159: IF (FIIDIM_Debug) THEN
160: FII_UTIL.Write_Log ('Now start processing '|| 'Collector dimension');
161: END IF;
162:
163: --Secondly populate the table FII_COLLECTORS
164:

Line 167: FII_UTIL.truncate_table ('FII_COLLECTORS', 'FII', g_retcode);

163: --Secondly populate the table FII_COLLECTORS
164:
165: g_phase := 'populating FII_COLLECTORS table';
166:
167: FII_UTIL.truncate_table ('FII_COLLECTORS', 'FII', g_retcode);
168:
169: /* For transactions, the AR UI requires the account and site use to be specified. However, for receipts,
170: it can be created with just the account information. Hence, in first sql, apart from picking up
171: non-null site_use_ids to get the collectors assigned at the site level, we do NVL(site_use_id, -2)

Line 240: FII_UTIL.Write_Log('Inserted ' || SQL%ROWCOUNT || ' rows IN FII_COLLECTORS');

236: and uses.site_use_id = profs.site_use_id
237: AND profs.last_update_date <= g_collection_to_date);
238:
239: IF (FIIDIM_Debug) THEN
240: FII_UTIL.Write_Log('Inserted ' || SQL%ROWCOUNT || ' rows IN FII_COLLECTORS');
241: END IF;
242:
243: -- Statistics for FII_COLLECTORS will be anyway gathered via RSG so NOT gathering stats in the program
244:

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 282: FII_UTIL.Write_Log ('Init_Load -> phase: '|| g_phase);

278: ret_val := FND_CONCURRENT.Set_Completion_Status
279: (status => 'ERROR', message => 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:

Line 283: FII_UTIL.Write_Log (

279: (status => 'ERROR', message => 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;

Line 326: FII_UTIL.Write_Log (' Debug On');

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;
330:

Line 328: FII_UTIL.Write_Log (' Debug Off');

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;
330:
331:
332: --First do the initialization

Line 338: FII_UTIL.Write_Log (g_phase);

334: Initialize;
335:
336: g_phase := 'Getting maximum batch_party_id from fii_change_log table';
337: IF (FIIDIM_Debug) THEN
338: FII_UTIL.Write_Log (g_phase);
339: END IF;
340:
341: select item_value
342: into l_max_batch_party_id

Line 346: FII_UTIL.Write_Log ('COLL_MAX_BATCH_PARTY_ID = '||l_max_batch_party_id);

342: into l_max_batch_party_id
343: from fii_change_log
344: where log_item = 'COLL_MAX_BATCH_PARTY_ID';
345:
346: FII_UTIL.Write_Log ('COLL_MAX_BATCH_PARTY_ID = '||l_max_batch_party_id);
347:
348: g_phase := 'Deleting merged parties.';
349: IF (FIIDIM_Debug) THEN
350: FII_UTIL.Write_Log (g_phase);

Line 350: FII_UTIL.Write_Log (g_phase);

346: FII_UTIL.Write_Log ('COLL_MAX_BATCH_PARTY_ID = '||l_max_batch_party_id);
347:
348: g_phase := 'Deleting merged parties.';
349: IF (FIIDIM_Debug) THEN
350: FII_UTIL.Write_Log (g_phase);
351: END IF;
352:
353: Delete from fii_collectors
354: where party_id in

Line 364: FII_UTIL.Write_Log (g_phase);

360: and batch_party_id > l_max_batch_party_id);
361:
362: g_phase := 'Logging maximum batch_party_id into fii_change_log table';
363: IF (FIIDIM_Debug) THEN
364: FII_UTIL.Write_Log (g_phase);
365: END IF;
366:
367: select nvl(max(batch_party_id), -1)
368: into l_max_batch_party_id

Line 403: FII_UTIL.Write_Log ('Now start processing Collector dimension');

399:
400: FND_CONCURRENT.Af_Commit;
401:
402: IF (FIIDIM_Debug) THEN
403: FII_UTIL.Write_Log ('Now start processing Collector dimension');
404: END IF;
405:
406: g_phase := 'Getting last refresh dates';
407:

Line 409: FII_UTIL.Write_Log ( 'g_phase: ' || g_phase);

405:
406: g_phase := 'Getting last refresh dates';
407:
408: IF (FIIDIM_Debug) THEN
409: FII_UTIL.Write_Log ( 'g_phase: ' || g_phase);
410: END IF;
411:
412: --Added by vkazhipu for customer bug 5763652
413:

Line 449: FII_UTIL.Write_Log ( 'last refresh date is ' || l_last_period_to);

445: l_last_period_to := bis_common_parameters.get_global_start_date;
446: END IF;
447:
448: IF (FIIDIM_Debug) THEN
449: FII_UTIL.Write_Log ( 'last refresh date is ' || l_last_period_to);
450:
451: END IF;
452:
453: l_last_update_join := 'AND TRUNC(prof.last_update_date) >=''' ||l_last_period_to||''' AND TRUNC(prof.last_update_date) <=''' ||g_collection_to_date||'''';

Line 556: FII_UTIL.Write_Log('Modified (Updation + Insertion) ' || SQL%ROWCOUNT || ' rows into FII_COLLECTORS');

552:
553: EXECUTE IMMEDIATE l_stmt;
554:
555: IF (FIIDIM_Debug) THEN
556: FII_UTIL.Write_Log('Modified (Updation + Insertion) ' || SQL%ROWCOUNT || ' rows into FII_COLLECTORS');
557: END IF;
558:
559: -- Statistics for FII_COLLECTORS will be anyway gathered via RSG so NOT gathering stats in the program
560:

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 590: FII_UTIL.Write_Log ('Incre_Update -> phase: '|| g_phase);

586: ret_val := FND_CONCURRENT.Set_Completion_Status
587: (status => 'ERROR', message => 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;

Line 591: FII_UTIL.Write_Log (

587: (status => 'ERROR', message => 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');