APPS.ISC_MAINT_WO_ETL_PKG dependencies on ISC_MAINT_WO_ETL_PKG

Line 1: Package Body ISC_MAINT_WO_ETL_PKG AS

1: Package Body ISC_MAINT_WO_ETL_PKG AS
2: /*$Header: iscmaintwoetlb.pls 120.3 2006/01/03 03:04:30 nbhamidi noship $ */
3:
4: g_sysdate DATE := SYSDATE;
5: g_user_id NUMBER := nvl(fnd_global.user_id, -1);

Line 63: l_err_msg := 'ISC_MAINT_WO_ETL_PKG.Save_Last_Collection_Date ('

59:
60: WHEN OTHERS THEN
61: rollback;
62: l_err_num := SQLCODE;
63: l_err_msg := 'ISC_MAINT_WO_ETL_PKG.Save_Last_Collection_Date ('
64: || to_char(l_stmt_num)
65: || '): '
66: || substr(SQLERRM, 1,200);
67:

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 253: l_err_msg := 'ISC_MAINT_WO_ETL_PKG.GET_WORK_ORDERS_INITIAL_LOAD ('

249: WHEN OTHERS THEN
250: rollback;
251:
252: l_err_num := SQLCODE;
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 ('

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 501: l_err_msg := 'ISC_MAINT_WO_ETL_PKG.GET_WORK_ORDERS_INCR_LOAD ('

497: rollback;
498:
499:
500: l_err_num := SQLCODE;
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 ('

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 520: End ISC_MAINT_WO_ETL_PKG;

516:
517: END GET_WORK_ORDERS_INCR_LOAD;
518:
519:
520: End ISC_MAINT_WO_ETL_PKG;