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.BIL_DO_L1_OPPTY_SUMRY_PKG dependencies on BIL_DO_UTIL_PKG

Line 78: BIL_DO_UTIL_PKG.Write_Log(p_msg=>'Parameters for Refresh_Data - Debug: ' || p_debug_mode

74: if l_collection_date_start is null
75: or l_collection_date_start > l_collection_date_end then
76: l_collection_date_start := l_collection_date_end;
77: end if;
78: BIL_DO_UTIL_PKG.Write_Log(p_msg=>'Parameters for Refresh_Data - Debug: ' || p_debug_mode
79: || ' Trace: ' || p_trace_mode
80: || ' Parallel Degree: ' || TO_CHAR(p_Degree),p_debug => p_Debug_mode);
81:
82: Refresh_Date_Range( ERRBUF => ERRBUF

Line 94: BIL_DO_UTIL_PKG.Write_Log(

90: EXCEPTION
91: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
92: ERRBUF := ERRBUF||'Error in Refresh_Data:'||to_char(sqlcode)||sqlerrm;
93: RETCODE := '2' ;
94: BIL_DO_UTIL_PKG.Write_Log(
95: p_msg => 'Error in Refresh_Data:'||to_char(sqlcode)||sqlerrm
96: , p_force => 'Y',p_debug =>G_Debug);
97: ROLLBACK;
98: Reset_Table_Usages;

Line 103: BIL_DO_UTIL_PKG.Write_Log(

99:
100: WHEN OTHERS THEN
101: ERRBUF := ERRBUF||'Error in Refresh_Data:'||to_char(sqlcode)||sqlerrm;
102: RETCODE := '2';
103: BIL_DO_UTIL_PKG.Write_Log(
104: p_msg => 'Error in Refresh_Data:'||to_char(sqlcode)||sqlerrm
105: , p_force => 'Y',p_debug =>G_Debug);
106: ROLLBACK;
107: Reset_table_Usages;

Line 198: BIL_DO_UTIL_PKG.Write_Log('Analyze table BIL_DO_L1_OPPTY_SUMRY',p_debug => p_debug_mode);

194: end loop;
195: end if;
196:
197: /*Analyze the table after insertion*/
198: BIL_DO_UTIL_PKG.Write_Log('Analyze table BIL_DO_L1_OPPTY_SUMRY',p_debug => p_debug_mode);
199: DBMS_STATS.gather_table_stats(ownname=>'BIL', tabName=>'BIL_DO_L1_OPPTY_SUMRY', cascade=>TRUE,
200: degree=>G_Degree, estimate_percent=>99, granularity=>'GLOBAL');
201:
202:

Line 207: BIL_DO_UTIL_PKG.Write_Log(p_msg=>'Alter bil_do_l1_OPPTY_SUMRY table to noparallel', p_debug=>p_debug_mode);

203: IF G_Trace THEN
204: EXECUTE IMMEDIATE 'ALTER SESSION SET SQL_TRACE=FALSE';
205: END IF;
206: Reset_Table_Usages;
207: BIL_DO_UTIL_PKG.Write_Log(p_msg=>'Alter bil_do_l1_OPPTY_SUMRY table to noparallel', p_debug=>p_debug_mode);
208:
209: BIL_DO_UTIL_PKG.Write_Log(p_msg=>'End of Refresh_Date_Range for Opportunity to Quote Bin', p_debug=>p_debug_mode);
210:
211:

Line 209: BIL_DO_UTIL_PKG.Write_Log(p_msg=>'End of Refresh_Date_Range for Opportunity to Quote Bin', p_debug=>p_debug_mode);

205: END IF;
206: Reset_Table_Usages;
207: BIL_DO_UTIL_PKG.Write_Log(p_msg=>'Alter bil_do_l1_OPPTY_SUMRY table to noparallel', p_debug=>p_debug_mode);
208:
209: BIL_DO_UTIL_PKG.Write_Log(p_msg=>'End of Refresh_Date_Range for Opportunity to Quote Bin', p_debug=>p_debug_mode);
210:
211:
212: EXCEPTION
213: WHEN OTHERS THEN

Line 216: BIL_DO_UTIL_PKG.Write_Log(

212: EXCEPTION
213: WHEN OTHERS THEN
214: ERRBUF := ERRBUF||'Error in Refresh_Date_Range:'||to_char(sqlcode)||sqlerrm;
215: RETCODE := '2';
216: BIL_DO_UTIL_PKG.Write_Log(
217: p_msg => 'Error in Refresh_Date_Range:'||to_char(sqlcode)||sqlerrm
218: , p_force => 'Y',p_debug =>G_Debug);
219: ROLLBACK;
220: END Refresh_date_Range;

Line 241: BIL_DO_UTIL_PKG.Write_Log(p_msg=>'Delete Data for collection date: ' || TO_CHAR(l_collection_date, 'DD-MON-YYYY'), p_debug=>p_debug_mode);

237: l_collection_date := to_date(p_collection_date);
238:
239: /*Delete the existing records for the same collect_date from the table*/
240: IF (G_Truncate = 'N') THEN
241: BIL_DO_UTIL_PKG.Write_Log(p_msg=>'Delete Data for collection date: ' || TO_CHAR(l_collection_date, 'DD-MON-YYYY'), p_debug=>p_debug_mode);
242: Delete_table( ERRBUF => ERRBUF
243: ,RETCODE => RETCODE
244: ,p_date => l_collection_date);
245: END IF;

Line 247: BIL_DO_UTIL_PKG.Write_Log(p_msg=>'Insert Data for collection date: ' || TO_CHAR(l_collection_date, 'DD-MON-YYYY'), p_debug=>p_debug_mode);

243: ,RETCODE => RETCODE
244: ,p_date => l_collection_date);
245: END IF;
246:
247: BIL_DO_UTIL_PKG.Write_Log(p_msg=>'Insert Data for collection date: ' || TO_CHAR(l_collection_date, 'DD-MON-YYYY'), p_debug=>p_debug_mode);
248: /*Calling the insert procedure for inserting data to the table.*/
249: Insert_Data( ERRBUF => ERRBUF
250: ,RETCODE => RETCODE
251: ,p_degree => p_degree

Line 258: BIL_DO_UTIL_PKG.Write_Log(

254: EXCEPTION
255: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
256: ERRBUF := ERRBUF||'Error in Refresh_Data_Day:'||to_char(sqlcode)||sqlerrm;
257: RETCODE := '2' ;
258: BIL_DO_UTIL_PKG.Write_Log(
259: p_msg => 'Error in Refresh_Data:'||to_char(sqlcode)||sqlerrm
260: , p_force => 'Y',p_debug =>G_Debug);
261: ROLLBACK;
262: Reset_Table_Usages;

Line 267: BIL_DO_UTIL_PKG.Write_Log(

263:
264: WHEN OTHERS THEN
265: ERRBUF := ERRBUF||'Error in Refresh_Data_Day:'||to_char(sqlcode)||sqlerrm;
266: RETCODE := '2';
267: BIL_DO_UTIL_PKG.Write_Log(
268: p_msg => 'Error in Refresh_Data_Day:'||to_char(sqlcode)||sqlerrm
269: , p_force => 'Y',p_debug =>G_Debug);
270: ROLLBACK;
271: Reset_table_Usages;

Line 375: BIL_DO_UTIL_PKG.Write_Log(p_msg=>'No Rows are inserted from Insert_data',p_stime=>l_stime,p_etime=>SYSDATE, p_force=>'Y',p_debug=>G_Debug);

371: ,l_enabled_flag;
372:
373: COMMIT;
374: IF (SQL%ROWCOUNT = 0) THEN
375: BIL_DO_UTIL_PKG.Write_Log(p_msg=>'No Rows are inserted from Insert_data',p_stime=>l_stime,p_etime=>SYSDATE, p_force=>'Y',p_debug=>G_Debug);
376: RETCODE := 1;
377: END IF;
378:
379: BIL_DO_UTIL_PKG.Write_Log(p_msg=>' Rows Inserted:'||SQL%ROWCOUNT,p_stime=>l_stime,p_etime=>SYSDATE, p_debug=>G_Debug);

Line 379: BIL_DO_UTIL_PKG.Write_Log(p_msg=>' Rows Inserted:'||SQL%ROWCOUNT,p_stime=>l_stime,p_etime=>SYSDATE, p_debug=>G_Debug);

375: BIL_DO_UTIL_PKG.Write_Log(p_msg=>'No Rows are inserted from Insert_data',p_stime=>l_stime,p_etime=>SYSDATE, p_force=>'Y',p_debug=>G_Debug);
376: RETCODE := 1;
377: END IF;
378:
379: BIL_DO_UTIL_PKG.Write_Log(p_msg=>' Rows Inserted:'||SQL%ROWCOUNT,p_stime=>l_stime,p_etime=>SYSDATE, p_debug=>G_Debug);
380:
381: EXCEPTION
382: WHEN OTHERS THEN
383: ERRBUF := ERRBUF ||' Insert_Data:'||sqlcode||' '|| sqlerrm;

Line 385: BIL_DO_UTIL_PKG.Write_Log(p_msg=>' Insert_Data:'||sqlcode||' '|| sqlerrm

381: EXCEPTION
382: WHEN OTHERS THEN
383: ERRBUF := ERRBUF ||' Insert_Data:'||sqlcode||' '|| sqlerrm;
384: RETCODE := '2';
385: BIL_DO_UTIL_PKG.Write_Log(p_msg=>' Insert_Data:'||sqlcode||' '|| sqlerrm
386: , p_force=> 'Y',p_debug=>G_Debug);
387: Reset_Table_Usages;
388: end Insert_Data;
389:

Line 401: BIL_DO_UTIL_PKG.Write_Log(p_msg=>'Deleted records from BIL Table BIL_DO_L1_OPPTY_SUMRY',p_debug=>G_Debug);

397: l_date DATE := p_date;
398: BEGIN
399: DELETE FROM BIL_DO_L1_OPPTY_SUMRY
400: WHERE collection_date = l_date;
401: BIL_DO_UTIL_PKG.Write_Log(p_msg=>'Deleted records from BIL Table BIL_DO_L1_OPPTY_SUMRY',p_debug=>G_Debug);
402: EXCEPTION
403: WHEN NO_DATA_FOUND THEN
404: null;
405: WHEN OTHERS THEN

Line 416: BIL_DO_UTIL_PKG.Write_Log('BIL Table BIL_DO_L1_OPPTY_SUMRY altered to logging',p_debug=>G_Debug);

412: *********/
413: PROCEDURE Reset_Table_Usages IS
414: BEGIN
415: EXECUTE IMMEDIATE 'ALTER TABLE BIL.BIL_DO_L1_OPPTY_SUMRY LOGGING';
416: BIL_DO_UTIL_PKG.Write_Log('BIL Table BIL_DO_L1_OPPTY_SUMRY altered to logging',p_debug=>G_Debug);
417: END Reset_Table_Usages;
418:
419:
420: /*******************

Line 426: BIL_DO_UTIL_PKG.Write_Log(p_msg=>'BIL Table bil_do_l1_oppty_sumry is truncated',p_debug=>G_Debug);

422: *******************/
423: PROCEDURE Truncate_table is
424: BEGIN
425: EXECUTE IMMEDIATE 'truncate table bil.bil_do_l1_oppty_sumry';
426: BIL_DO_UTIL_PKG.Write_Log(p_msg=>'BIL Table bil_do_l1_oppty_sumry is truncated',p_debug=>G_Debug);
427: END;
428:
429:
430: /*******

Line 436: BIL_DO_UTIL_PKG.Write_Log('BIL Table BIL_DO_L1_OPPTY_SUMRY altered to nologging',p_debug=>G_Debug);

432: *******/
433: PROCEDURE Set_Table_Usages IS
434: BEGIN
435: EXECUTE IMMEDIATE 'ALTER TABLE BIL.BIL_DO_L1_OPPTY_SUMRY NOLOGGING';
436: BIL_DO_UTIL_PKG.Write_Log('BIL Table BIL_DO_L1_OPPTY_SUMRY altered to nologging',p_debug=>G_Debug);
437: END Set_Table_Usages;
438:
439: END BIL_DO_L1_OPPTY_SUMRY_PKG;