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.ISC_MAINT_WO_ETL_PKG dependencies on BIS_COLLECTION_UTILITIES

Line 68: BIS_COLLECTION_UTILITIES.put_line('ISC_MAINT_WO_ETL_PKG.Save_Last_Collection_Date - Error at statement ('

64: || to_char(l_stmt_num)
65: || '): '
66: || substr(SQLERRM, 1,200);
67:
68: BIS_COLLECTION_UTILITIES.put_line('ISC_MAINT_WO_ETL_PKG.Save_Last_Collection_Date - Error at statement ('
69: || to_char(l_stmt_num)
70: || ')');
71:
72: BIS_COLLECTION_UTILITIES.put_line('Error Number: ' || to_char(l_err_num));

Line 72: BIS_COLLECTION_UTILITIES.put_line('Error Number: ' || to_char(l_err_num));

68: BIS_COLLECTION_UTILITIES.put_line('ISC_MAINT_WO_ETL_PKG.Save_Last_Collection_Date - Error at statement ('
69: || to_char(l_stmt_num)
70: || ')');
71:
72: BIS_COLLECTION_UTILITIES.put_line('Error Number: ' || to_char(l_err_num));
73: BIS_COLLECTION_UTILITIES.put_line('Error Message: ' || l_err_msg);
74:
75: return FALSE;
76:

Line 73: BIS_COLLECTION_UTILITIES.put_line('Error Message: ' || l_err_msg);

69: || to_char(l_stmt_num)
70: || ')');
71:
72: BIS_COLLECTION_UTILITIES.put_line('Error Number: ' || to_char(l_err_num));
73: BIS_COLLECTION_UTILITIES.put_line('Error Message: ' || l_err_msg);
74:
75: return FALSE;
76:
77: END Save_Last_Collection_Date;

Line 97: IF BIS_COLLECTION_UTILITIES.SETUP( 'ISC_MAINT_WORK_ORDERS_F' ) = FALSE THEN

93: l_list(1) := 'BIS_GLOBAL_START_DATE';
94:
95: IF (bis_common_parameters.check_global_parameters(l_list)) THEN
96:
97: IF BIS_COLLECTION_UTILITIES.SETUP( 'ISC_MAINT_WORK_ORDERS_F' ) = FALSE THEN
98: RAISE_APPLICATION_ERROR(-20000, errbuf);
99: End if;
100:
101: l_stmt_num := 1;

Line 112: BIS_COLLECTION_UTILITIES.put_line('Global start date is not available. Cannot proceed.');

108: BEGIN
109: select BIS_COMMON_PARAMETERS.GET_GLOBAL_START_DATE into g_global_start_date from DUAL;
110: EXCEPTION
111: WHEN NO_DATA_FOUND THEN
112: BIS_COLLECTION_UTILITIES.put_line('Global start date is not available. Cannot proceed.');
113: BIS_COLLECTION_UTILITIES.put_line(SQLERRM);
114: retcode := SQLCODE;
115: errbuf := SQLERRM;
116: return;

Line 113: BIS_COLLECTION_UTILITIES.put_line(SQLERRM);

109: select BIS_COMMON_PARAMETERS.GET_GLOBAL_START_DATE into g_global_start_date from DUAL;
110: EXCEPTION
111: WHEN NO_DATA_FOUND THEN
112: BIS_COLLECTION_UTILITIES.put_line('Global start date is not available. Cannot proceed.');
113: BIS_COLLECTION_UTILITIES.put_line(SQLERRM);
114: retcode := SQLCODE;
115: errbuf := SQLERRM;
116: return;
117: END;

Line 122: BIS_COLLECTION_UTILITIES.put_line('Failed to store current sysdate as the Last Collection Date.');

118:
119: -- Store current sysdate as the Last Collection Date.
120: l_stmt_num := 20;
121: if Save_Last_Collection_Date = FALSE THEN
122: BIS_COLLECTION_UTILITIES.put_line('Failed to store current sysdate as the Last Collection Date.');
123: RAISE_APPLICATION_ERROR(-20000, errbuf);
124: end if;
125:
126:

Line 232: BIS_COLLECTION_UTILITIES.PUT_LINE('Finished EAM Work Orders Extraction into Base Table: '|| l_row_count || ' row(s) inserted');

228:
229: l_row_count := sql%rowcount;
230: commit;
231:
232: BIS_COLLECTION_UTILITIES.PUT_LINE('Finished EAM Work Orders Extraction into Base Table: '|| l_row_count || ' row(s) inserted');
233:
234:
235: BIS_COLLECTION_UTILITIES.WRAPUP(
236: p_status => TRUE,

Line 235: BIS_COLLECTION_UTILITIES.WRAPUP(

231:
232: BIS_COLLECTION_UTILITIES.PUT_LINE('Finished EAM Work Orders Extraction into Base Table: '|| l_row_count || ' row(s) inserted');
233:
234:
235: BIS_COLLECTION_UTILITIES.WRAPUP(
236: p_status => TRUE,
237: p_count => l_row_count,
238: p_message => 'Successfully loaded EAM Work Orders Base table at ' || TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS')
239: );

Line 243: BIS_COLLECTION_UTILITIES.PUT_LINE('Global Parameters are not setup.');

239: );
240:
241: ELSE
242: retcode := g_error;
243: BIS_COLLECTION_UTILITIES.PUT_LINE('Global Parameters are not setup.');
244: BIS_COLLECTION_UTILITIES.PUT_LINE('Please check that the profile option BIS_GLOBAL_START_DATE is setup.');
245:
246: END IF;
247:

Line 244: BIS_COLLECTION_UTILITIES.PUT_LINE('Please check that the profile option BIS_GLOBAL_START_DATE is setup.');

240:
241: ELSE
242: retcode := g_error;
243: BIS_COLLECTION_UTILITIES.PUT_LINE('Global Parameters are not setup.');
244: BIS_COLLECTION_UTILITIES.PUT_LINE('Please check that the profile option BIS_GLOBAL_START_DATE is setup.');
245:
246: END IF;
247:
248: EXCEPTION

Line 257: BIS_COLLECTION_UTILITIES.PUT_LINE('ISC_MAINT_WO_ETL_PKG.GET_WORK_ORDERS_INITIAL_LOAD - Error at statement ('

253: l_err_msg := 'ISC_MAINT_WO_ETL_PKG.GET_WORK_ORDERS_INITIAL_LOAD ('
254: || to_char(l_stmt_num)
255: || '): '
256: || substr(SQLERRM, 1,200);
257: BIS_COLLECTION_UTILITIES.PUT_LINE('ISC_MAINT_WO_ETL_PKG.GET_WORK_ORDERS_INITIAL_LOAD - Error at statement ('
258: || to_char(l_stmt_num)
259: || ')');
260: BIS_COLLECTION_UTILITIES.PUT_LINE('Error Number: ' || to_char(l_err_num));
261: BIS_COLLECTION_UTILITIES.PUT_LINE('Error Message: ' || l_err_msg);

Line 260: BIS_COLLECTION_UTILITIES.PUT_LINE('Error Number: ' || to_char(l_err_num));

256: || substr(SQLERRM, 1,200);
257: BIS_COLLECTION_UTILITIES.PUT_LINE('ISC_MAINT_WO_ETL_PKG.GET_WORK_ORDERS_INITIAL_LOAD - Error at statement ('
258: || to_char(l_stmt_num)
259: || ')');
260: BIS_COLLECTION_UTILITIES.PUT_LINE('Error Number: ' || to_char(l_err_num));
261: BIS_COLLECTION_UTILITIES.PUT_LINE('Error Message: ' || l_err_msg);
262: BIS_COLLECTION_UTILITIES.WRAPUP( FALSE,
263: l_row_count,
264: 'EXCEPTION '|| l_err_num||' : '||l_err_msg

Line 261: BIS_COLLECTION_UTILITIES.PUT_LINE('Error Message: ' || l_err_msg);

257: BIS_COLLECTION_UTILITIES.PUT_LINE('ISC_MAINT_WO_ETL_PKG.GET_WORK_ORDERS_INITIAL_LOAD - Error at statement ('
258: || to_char(l_stmt_num)
259: || ')');
260: BIS_COLLECTION_UTILITIES.PUT_LINE('Error Number: ' || to_char(l_err_num));
261: BIS_COLLECTION_UTILITIES.PUT_LINE('Error Message: ' || l_err_msg);
262: BIS_COLLECTION_UTILITIES.WRAPUP( FALSE,
263: l_row_count,
264: 'EXCEPTION '|| l_err_num||' : '||l_err_msg
265: );

Line 262: BIS_COLLECTION_UTILITIES.WRAPUP( FALSE,

258: || to_char(l_stmt_num)
259: || ')');
260: BIS_COLLECTION_UTILITIES.PUT_LINE('Error Number: ' || to_char(l_err_num));
261: BIS_COLLECTION_UTILITIES.PUT_LINE('Error Message: ' || l_err_msg);
262: BIS_COLLECTION_UTILITIES.WRAPUP( FALSE,
263: l_row_count,
264: 'EXCEPTION '|| l_err_num||' : '||l_err_msg
265: );
266:

Line 290: IF BIS_COLLECTION_UTILITIES.SETUP( 'ISC_MAINT_WORK_ORDERS_F' ) = FALSE THEN

286: l_list(1) := 'BIS_GLOBAL_START_DATE';
287:
288: IF (bis_common_parameters.check_global_parameters(l_list)) THEN
289:
290: IF BIS_COLLECTION_UTILITIES.SETUP( 'ISC_MAINT_WORK_ORDERS_F' ) = FALSE THEN
291: RAISE_APPLICATION_ERROR(-20000, errbuf);
292: End if;
293:
294: l_stmt_num := 10;

Line 299: BIS_COLLECTION_UTILITIES.put_line('Global start date is not available. Cannot proceed.');

295: BEGIN
296: select BIS_COMMON_PARAMETERS.GET_GLOBAL_START_DATE into g_global_start_date from DUAL;
297: EXCEPTION
298: WHEN NO_DATA_FOUND THEN
299: BIS_COLLECTION_UTILITIES.put_line('Global start date is not available. Cannot proceed.');
300: BIS_COLLECTION_UTILITIES.put_line(SQLERRM);
301: retcode := SQLCODE;
302: errbuf := SQLERRM;
303: return;

Line 300: BIS_COLLECTION_UTILITIES.put_line(SQLERRM);

296: select BIS_COMMON_PARAMETERS.GET_GLOBAL_START_DATE into g_global_start_date from DUAL;
297: EXCEPTION
298: WHEN NO_DATA_FOUND THEN
299: BIS_COLLECTION_UTILITIES.put_line('Global start date is not available. Cannot proceed.');
300: BIS_COLLECTION_UTILITIES.put_line(SQLERRM);
301: retcode := SQLCODE;
302: errbuf := SQLERRM;
303: return;
304: WHEN OTHERS then /* added as a part of standard */

Line 314: BIS_COLLECTION_UTILITIES.put_line('Last collection date is not available. Cannot proceed.');

310: SELECT Last_Update_Date INTO g_last_collection_date FROM ISC_MAINT_WORK_ORDERS_F
311: WHERE Organization_id = -99 and Work_Order_id = -99 and Entity_Type = -1;
312: EXCEPTION
313: WHEN NO_DATA_FOUND THEN
314: BIS_COLLECTION_UTILITIES.put_line('Last collection date is not available. Cannot proceed.');
315: BIS_COLLECTION_UTILITIES.put_line(SQLERRM);
316: retcode := SQLCODE;
317: errbuf := SQLERRM;
318: return;

Line 315: BIS_COLLECTION_UTILITIES.put_line(SQLERRM);

311: WHERE Organization_id = -99 and Work_Order_id = -99 and Entity_Type = -1;
312: EXCEPTION
313: WHEN NO_DATA_FOUND THEN
314: BIS_COLLECTION_UTILITIES.put_line('Last collection date is not available. Cannot proceed.');
315: BIS_COLLECTION_UTILITIES.put_line(SQLERRM);
316: retcode := SQLCODE;
317: errbuf := SQLERRM;
318: return;
319: when OTHERS then /* added as a part of standard */

Line 327: BIS_COLLECTION_UTILITIES.put_line('Failed to store current sysdate as the Last Collection Date.');

323:
324: l_stmt_num := 30;
325: -- Store current sysdate as the Last Collection Date.
326: if Save_Last_Collection_Date = FALSE THEN
327: BIS_COLLECTION_UTILITIES.put_line('Failed to store current sysdate as the Last Collection Date.');
328: RAISE_APPLICATION_ERROR(-20000, errbuf);
329: end if;
330:
331:

Line 480: BIS_COLLECTION_UTILITIES.PUT_LINE('Finished EAM Work Orders Extraction into Base Table: '|| l_row_count || ' row(s) inserted/updated');

476:
477: l_row_count := sql%rowcount;
478: commit;
479:
480: BIS_COLLECTION_UTILITIES.PUT_LINE('Finished EAM Work Orders Extraction into Base Table: '|| l_row_count || ' row(s) inserted/updated');
481:
482: BIS_COLLECTION_UTILITIES.WRAPUP(
483: p_status => TRUE,
484: p_count => l_row_count,

Line 482: BIS_COLLECTION_UTILITIES.WRAPUP(

478: commit;
479:
480: BIS_COLLECTION_UTILITIES.PUT_LINE('Finished EAM Work Orders Extraction into Base Table: '|| l_row_count || ' row(s) inserted/updated');
481:
482: BIS_COLLECTION_UTILITIES.WRAPUP(
483: p_status => TRUE,
484: p_count => l_row_count,
485: p_message => 'Successfully loaded EAM Work Orders Base table at ' || TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS')
486: );

Line 490: BIS_COLLECTION_UTILITIES.PUT_LINE('Global Parameters are not setup.');

486: );
487:
488: ELSE
489: retcode := g_error;
490: BIS_COLLECTION_UTILITIES.PUT_LINE('Global Parameters are not setup.');
491: BIS_COLLECTION_UTILITIES.PUT_LINE('Please check that the profile option BIS_GLOBAL_START_DATE is setup.');
492:
493: END IF;
494:

Line 491: BIS_COLLECTION_UTILITIES.PUT_LINE('Please check that the profile option BIS_GLOBAL_START_DATE is setup.');

487:
488: ELSE
489: retcode := g_error;
490: BIS_COLLECTION_UTILITIES.PUT_LINE('Global Parameters are not setup.');
491: BIS_COLLECTION_UTILITIES.PUT_LINE('Please check that the profile option BIS_GLOBAL_START_DATE is setup.');
492:
493: END IF;
494:
495: EXCEPTION

Line 505: BIS_COLLECTION_UTILITIES.PUT_LINE('ISC_MAINT_WO_ETL_PKG.GET_WORK_ORDERS_INCR_LOAD - Error at statement ('

501: l_err_msg := 'ISC_MAINT_WO_ETL_PKG.GET_WORK_ORDERS_INCR_LOAD ('
502: || to_char(l_stmt_num)
503: || '): '
504: || substr(SQLERRM, 1,200);
505: BIS_COLLECTION_UTILITIES.PUT_LINE('ISC_MAINT_WO_ETL_PKG.GET_WORK_ORDERS_INCR_LOAD - Error at statement ('
506: || to_char(l_stmt_num)
507: || ')');
508: BIS_COLLECTION_UTILITIES.PUT_LINE('Error Number: ' || to_char(l_err_num));
509: BIS_COLLECTION_UTILITIES.PUT_LINE('Error Message: ' || l_err_msg);

Line 508: BIS_COLLECTION_UTILITIES.PUT_LINE('Error Number: ' || to_char(l_err_num));

504: || substr(SQLERRM, 1,200);
505: BIS_COLLECTION_UTILITIES.PUT_LINE('ISC_MAINT_WO_ETL_PKG.GET_WORK_ORDERS_INCR_LOAD - Error at statement ('
506: || to_char(l_stmt_num)
507: || ')');
508: BIS_COLLECTION_UTILITIES.PUT_LINE('Error Number: ' || to_char(l_err_num));
509: BIS_COLLECTION_UTILITIES.PUT_LINE('Error Message: ' || l_err_msg);
510: BIS_COLLECTION_UTILITIES.WRAPUP( FALSE, l_row_count, 'EXCEPTION '|| l_err_num||' : '||l_err_msg );
511:
512: retcode := SQLCODE;

Line 509: BIS_COLLECTION_UTILITIES.PUT_LINE('Error Message: ' || l_err_msg);

505: BIS_COLLECTION_UTILITIES.PUT_LINE('ISC_MAINT_WO_ETL_PKG.GET_WORK_ORDERS_INCR_LOAD - Error at statement ('
506: || to_char(l_stmt_num)
507: || ')');
508: BIS_COLLECTION_UTILITIES.PUT_LINE('Error Number: ' || to_char(l_err_num));
509: BIS_COLLECTION_UTILITIES.PUT_LINE('Error Message: ' || l_err_msg);
510: BIS_COLLECTION_UTILITIES.WRAPUP( FALSE, l_row_count, 'EXCEPTION '|| l_err_num||' : '||l_err_msg );
511:
512: retcode := SQLCODE;
513: errbuf := SQLERRM;

Line 510: BIS_COLLECTION_UTILITIES.WRAPUP( FALSE, l_row_count, 'EXCEPTION '|| l_err_num||' : '||l_err_msg );

506: || to_char(l_stmt_num)
507: || ')');
508: BIS_COLLECTION_UTILITIES.PUT_LINE('Error Number: ' || to_char(l_err_num));
509: BIS_COLLECTION_UTILITIES.PUT_LINE('Error Message: ' || l_err_msg);
510: BIS_COLLECTION_UTILITIES.WRAPUP( FALSE, l_row_count, 'EXCEPTION '|| l_err_num||' : '||l_err_msg );
511:
512: retcode := SQLCODE;
513: errbuf := SQLERRM;
514: RAISE_APPLICATION_ERROR(-20000, errbuf);