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_BASE_GRP_PKG dependencies on BIL_DO_UTIL_PKG

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

84: IF NVL(p_degree,0) > 0 THEN
85: G_Degree := p_degree;
86: END IF;
87:
88: BIL_DO_UTIL_PKG.Write_Log(p_msg=>'Parameters for collect_temp_data - Debug: ' || p_debug_mode
89: || ' Trace: ' || p_trace_mode
90: || ' Parallel Degree: ' || TO_CHAR(G_Degree)
91: || ' Profile Option: ' || TO_CHAR(l_profile_option), p_debug=>G_Debug);
92:

Line 96: BIL_DO_UTIL_PKG.Write_Log(p_msg=>'Truncating table', p_debug=>G_Debug);

92:
93: /*Set table to nologging*/
94: Set_Table_Usages;
95: /*Truncate the table*/
96: BIL_DO_UTIL_PKG.Write_Log(p_msg=>'Truncating table', p_debug=>G_Debug);
97:
98: Truncate_table;
99:
100: /*insert all the parents*/

Line 129: BIL_DO_UTIL_PKG.Write_Log('Analyze table BIL_DO_L1_BASE_GRP_TEMP',p_debug=>G_Debug);

125: ,p_level => l_profile_option
126: ,p_degree => p_degree);
127:
128: /*Analyze the table after insertion*/
129: BIL_DO_UTIL_PKG.Write_Log('Analyze table BIL_DO_L1_BASE_GRP_TEMP',p_debug=>G_Debug);
130: DBMS_STATS.gather_table_stats(ownname=>'BIL', tabName=>'BIL_DO_L1_BASE_GRP_TEMP', cascade=>TRUE,
131: degree=>G_Degree, estimate_percent=>99, granularity=>'GLOBAL');
132:
133:

Line 142: BIL_DO_UTIL_PKG.Write_Log(

138: EXCEPTION
139: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
140: ERRBUF := ERRBUF||'Error in collect_temp_data:'||to_char(sqlcode)||sqlerrm;
141: RETCODE := '2' ;
142: BIL_DO_UTIL_PKG.Write_Log(
143: p_msg => 'Error in Collect_Temp_Data:'||to_char(sqlcode)||sqlerrm
144: , p_force => 'Y', p_debug => G_Debug);
145: ROLLBACK;
146: Reset_Table_Usages;

Line 152: BIL_DO_UTIL_PKG.Write_Log(

148:
149: WHEN OTHERS THEN
150: ERRBUF := ERRBUF||'Error in Collect_Temp_Data:'||to_char(sqlcode)||sqlerrm;
151: RETCODE := '2';
152: BIL_DO_UTIL_PKG.Write_Log(
153: p_msg => 'Error in Collect_Temp_Data:'||to_char(sqlcode)||sqlerrm
154: , p_force => 'Y', p_debug => G_Debug);
155: ROLLBACK;
156: Reset_table_Usages;

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

224: ,l_sales;
225:
226: COMMIT;
227: IF (SQL%ROWCOUNT = 0) THEN
228: BIL_DO_UTIL_PKG.Write_Log(p_msg=>'No Rows are inserted from Insert_parent_data',p_stime=>l_stime,p_etime=>SYSDATE, p_force=>'Y',p_debug=>G_Debug);
229: END IF;
230: BIL_DO_UTIL_PKG.Write_Log(p_msg=>'Rows Inserted from Insert_parent_data:'||SQL%ROWCOUNT,p_stime=>l_stime,p_etime=>SYSDATE, p_debug=>G_Debug);
231: EXCEPTION
232: WHEN OTHERS THEN

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

226: COMMIT;
227: IF (SQL%ROWCOUNT = 0) THEN
228: BIL_DO_UTIL_PKG.Write_Log(p_msg=>'No Rows are inserted from Insert_parent_data',p_stime=>l_stime,p_etime=>SYSDATE, p_force=>'Y',p_debug=>G_Debug);
229: END IF;
230: BIL_DO_UTIL_PKG.Write_Log(p_msg=>'Rows Inserted from Insert_parent_data:'||SQL%ROWCOUNT,p_stime=>l_stime,p_etime=>SYSDATE, p_debug=>G_Debug);
231: EXCEPTION
232: WHEN OTHERS THEN
233: ERRBUF := ERRBUF ||' Insert_Parent_Data:'||sqlcode||' '|| sqlerrm;
234: RETCODE := '2';

Line 236: BIL_DO_UTIL_PKG.Write_Log(p_msg=>' Insert_Parent_Data:'||sqlcode||' '|| sqlerrm

232: WHEN OTHERS THEN
233: ERRBUF := ERRBUF ||' Insert_Parent_Data:'||sqlcode||' '|| sqlerrm;
234: RETCODE := '2';
235: ROLLBACK;
236: BIL_DO_UTIL_PKG.Write_Log(p_msg=>' Insert_Parent_Data:'||sqlcode||' '|| sqlerrm
237: , p_force=> 'Y', p_debug => G_Debug);
238:
239: END Insert_Parent_Data;
240:

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

303: ,l_sales;
304:
305: COMMIT;
306: IF (SQL%ROWCOUNT = 0) THEN
307: BIL_DO_UTIL_PKG.Write_Log(p_msg=>'No Rows are inserted from Insert_Hirarchial_Data',p_stime=>l_stime,p_etime=>SYSDATE, p_force=>'Y',p_debug=>G_Debug);
308: END IF;
309:
310: BIL_DO_UTIL_PKG.Write_Log(p_msg=>'Rows Inserted from Insert_Hirarchial_Data:'||SQL%ROWCOUNT,p_stime=>l_stime,p_etime=>SYSDATE, p_debug=>G_Debug);
311:

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

306: IF (SQL%ROWCOUNT = 0) THEN
307: BIL_DO_UTIL_PKG.Write_Log(p_msg=>'No Rows are inserted from Insert_Hirarchial_Data',p_stime=>l_stime,p_etime=>SYSDATE, p_force=>'Y',p_debug=>G_Debug);
308: END IF;
309:
310: BIL_DO_UTIL_PKG.Write_Log(p_msg=>'Rows Inserted from Insert_Hirarchial_Data:'||SQL%ROWCOUNT,p_stime=>l_stime,p_etime=>SYSDATE, p_debug=>G_Debug);
311:
312: EXCEPTION
313: WHEN OTHERS THEN
314: ERRBUF := ERRBUF ||' Insert_Hirarchial_Data:'||sqlcode||' '|| sqlerrm;

Line 317: BIL_DO_UTIL_PKG.Write_Log(p_msg=>' Insert_Hirarchial_Data:'||sqlcode||' '|| sqlerrm

313: WHEN OTHERS THEN
314: ERRBUF := ERRBUF ||' Insert_Hirarchial_Data:'||sqlcode||' '|| sqlerrm;
315: RETCODE := '2';
316: ROLLBACK;
317: BIL_DO_UTIL_PKG.Write_Log(p_msg=>' Insert_Hirarchial_Data:'||sqlcode||' '|| sqlerrm
318: , p_force=> 'Y', p_debug => G_Debug);
319:
320: end insert_hirarchial_data;
321:

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

375: ,l_sales;
376:
377: COMMIT;
378: IF (SQL%ROWCOUNT = 0) THEN
379: BIL_DO_UTIL_PKG.Write_Log(p_msg=>'No Rows are inserted from Insert_From_Denorm',p_stime=>l_stime,p_etime=>SYSDATE, p_force=>'Y',p_debug=>G_Debug);
380: END IF;
381:
382: BIL_DO_UTIL_PKG.Write_Log(p_msg=>'Rows Inserted from Insert_From_Denorm:'||SQL%ROWCOUNT,p_stime=>l_stime,p_etime=>SYSDATE, p_debug=>G_Debug);
383: EXCEPTION

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

378: IF (SQL%ROWCOUNT = 0) THEN
379: BIL_DO_UTIL_PKG.Write_Log(p_msg=>'No Rows are inserted from Insert_From_Denorm',p_stime=>l_stime,p_etime=>SYSDATE, p_force=>'Y',p_debug=>G_Debug);
380: END IF;
381:
382: BIL_DO_UTIL_PKG.Write_Log(p_msg=>'Rows Inserted from Insert_From_Denorm:'||SQL%ROWCOUNT,p_stime=>l_stime,p_etime=>SYSDATE, p_debug=>G_Debug);
383: EXCEPTION
384: WHEN OTHERS THEN
385: ERRBUF := ERRBUF ||' Insert_From_Denorm:'||sqlcode||' '|| sqlerrm;
386: RETCODE := '2';

Line 388: BIL_DO_UTIL_PKG.Write_Log(p_msg=>' Insert_From_Denorm:'||sqlcode||' '|| sqlerrm

384: WHEN OTHERS THEN
385: ERRBUF := ERRBUF ||' Insert_From_Denorm:'||sqlcode||' '|| sqlerrm;
386: RETCODE := '2';
387: ROLLBACK;
388: BIL_DO_UTIL_PKG.Write_Log(p_msg=>' Insert_From_Denorm:'||sqlcode||' '|| sqlerrm
389: , p_force=> 'Y',p_debug => G_Debug);
390:
391: END Insert_From_Denorm;
392:

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

395: *******************/
396: PROCEDURE Truncate_table is
397: BEGIN
398: EXECUTE IMMEDIATE 'truncate table bil.bil_do_l1_base_grp_temp';
399: BIL_DO_UTIL_PKG.Write_Log(p_msg=>'BIL Table bil_do_l1_base_grp_temp is truncated',p_debug=>G_Debug);
400: END;
401:
402: /*************************
403: *Alter tables to logging

Line 408: BIL_DO_UTIL_PKG.Write_Log(p_msg=>'BIL Table bil_do_l1_base_grp_temp altered to logging', p_debug=>G_Debug);

404: *************************/
405: PROCEDURE Reset_Table_Usages IS
406: BEGIN
407: EXECUTE IMMEDIATE 'ALTER TABLE bil.bil_do_l1_base_grp_temp LOGGING';
408: BIL_DO_UTIL_PKG.Write_Log(p_msg=>'BIL Table bil_do_l1_base_grp_temp altered to logging', p_debug=>G_Debug);
409: END Reset_Table_Usages;
410:
411: /***********************************************************
412: * Alter all the tables used to nologging, drop the indexes

Line 419: BIL_DO_UTIL_PKG.Write_Log(p_msg=>'BIL Table bil_do_l1_base_grp_temp altered to nologging',p_debug=>G_Debug);

415: BEGIN
416:
417: EXECUTE IMMEDIATE 'ALTER TABLE bil.bil_do_l1_base_grp_temp NOLOGGING';
418:
419: BIL_DO_UTIL_PKG.Write_Log(p_msg=>'BIL Table bil_do_l1_base_grp_temp altered to nologging',p_debug=>G_Debug);
420:
421: END Set_Table_Usages;
422:
423: END BIL_DO_L1_BASE_GRP_PKG;