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.OPIMPXWP dependencies on OPIMPXWP

Line 1: PACKAGE BODY OPIMPXWP AS

1: PACKAGE BODY OPIMPXWP AS
2: /*$Header: OPIMXWPB.pls 120.1 2005/06/08 18:31:48 appldev $ */
3:
4: procedure calc_wip_balance(
5: I_ORG_ID IN NUMBER,

Line 167: EDW_LOG.PUT_LINE('OPIMPXWP.calc_wip_balances. '

163: no_process exception;
164:
165: BEGIN
166:
167: EDW_LOG.PUT_LINE('OPIMPXWP.calc_wip_balances. '
168: || 'Processing org id: '
169: || to_char(i_org_id));
170:
171: /*

Line 172: DBMS_OUTPUT.PUT_LINE('OPIMPXWP.calc_wip_balances. '

168: || 'Processing org id: '
169: || to_char(i_org_id));
170:
171: /*
172: DBMS_OUTPUT.PUT_LINE('OPIMPXWP.calc_wip_balances. '
173: || 'Processing org id: '
174: || to_char(i_org_id));
175: */
176:

Line 335: EDW_LOG.PUT_LINE('OPIMPXWP.calc_wip_balance - No WIP data to extract');

331: o_err_num := 0;
332: o_err_code := '';
333: o_err_msg := '';
334: EDW_LOG.PUT_LINE('Org id: ' || to_char(i_org_id));
335: EDW_LOG.PUT_LINE('OPIMPXWP.calc_wip_balance - No WIP data to extract');
336: when process_error then
337: o_err_num := l_err_num;
338: o_err_code := l_err_code;
339: o_err_msg := 'OPIMPXWP.calc_wip_balance ('

Line 339: o_err_msg := 'OPIMPXWP.calc_wip_balance ('

335: EDW_LOG.PUT_LINE('OPIMPXWP.calc_wip_balance - No WIP data to extract');
336: when process_error then
337: o_err_num := l_err_num;
338: o_err_code := l_err_code;
339: o_err_msg := 'OPIMPXWP.calc_wip_balance ('
340: || to_char(l_stmt_num)
341: || ')';
342:
343: /*

Line 344: DBMS_OUTPUT.PUT_LINE('OPIMPXWP.calc_wip_balance ('

340: || to_char(l_stmt_num)
341: || ')';
342:
343: /*
344: DBMS_OUTPUT.PUT_LINE('OPIMPXWP.calc_wip_balance ('
345: || to_char(l_stmt_num)
346: || ')');
347: */
348:

Line 351: o_err_msg := 'OPIMPXWP.calc_wip_balance ('

347: */
348:
349: when others then
350: o_err_num := SQLCODE;
351: o_err_msg := 'OPIMPXWP.calc_wip_balance ('
352: || to_char(l_stmt_num)
353: || '): '
354: || substr(SQLERRM, 1,200);
355:

Line 357: DBMS_OUTPUT.PUT_LINE( 'OPIMPXWP.calc_wip_balance ('

353: || '): '
354: || substr(SQLERRM, 1,200);
355:
356: /*
357: DBMS_OUTPUT.PUT_LINE( 'OPIMPXWP.calc_wip_balance ('
358: || to_char(l_stmt_num)
359: || '): '
360: || substr(SQLERRM, 1,200));
361: */

Line 591: EDW_LOG.PUT_LINE('Processing (OPIMPXWP.calc_beginning_wip)...');

587: l_push_log_key := null;
588:
589: l_stmt_num := 10;
590:
591: EDW_LOG.PUT_LINE('Processing (OPIMPXWP.calc_beginning_wip)...');
592:
593: /*===============================================================================
594: -- FIRST, get current wip balance and load it to push log with start date in key.
595: ================================================================================*/

Line 726: o_err_msg := 'OPIMPXWP.calc_beginning_wip ('

722: */
723:
724: when others then
725: o_err_num := SQLCODE;
726: o_err_msg := 'OPIMPXWP.calc_beginning_wip ('
727: || to_char(l_stmt_num)
728: || '): '
729: || substr(SQLERRM, 1,200);
730:

Line 855: EDW_LOG.PUT_LINE('OPIMPXWP.upd_first_push_wip - ');

851: end if; -- end no existing row
852:
853: EXCEPTION
854: when process_error then
855: EDW_LOG.PUT_LINE('OPIMPXWP.upd_first_push_wip - ');
856: EDW_LOG.PUT_LINE('Error processing (OPIMPXWP.upd_first_push_wip)...');
857: EDW_LOG.PUT_LINE('Error Num= ' || to_char(l_err_num));
858: EDW_LOG.PUT_LINE('Statement Num= ' || to_char(l_stmt_num));
859:

Line 856: EDW_LOG.PUT_LINE('Error processing (OPIMPXWP.upd_first_push_wip)...');

852:
853: EXCEPTION
854: when process_error then
855: EDW_LOG.PUT_LINE('OPIMPXWP.upd_first_push_wip - ');
856: EDW_LOG.PUT_LINE('Error processing (OPIMPXWP.upd_first_push_wip)...');
857: EDW_LOG.PUT_LINE('Error Num= ' || to_char(l_err_num));
858: EDW_LOG.PUT_LINE('Statement Num= ' || to_char(l_stmt_num));
859:
860: when no_data_found then

Line 861: EDW_LOG.PUT_LINE('OPIMPXWP.upd_first_push_wip - stmt: '

857: EDW_LOG.PUT_LINE('Error Num= ' || to_char(l_err_num));
858: EDW_LOG.PUT_LINE('Statement Num= ' || to_char(l_stmt_num));
859:
860: when no_data_found then
861: EDW_LOG.PUT_LINE('OPIMPXWP.upd_first_push_wip - stmt: '
862: || to_char(l_stmt_num));
863: EDW_LOG.PUT_LINE('No item in MSI - Item id: ' || to_char(i_item_id)
864: || 'org id: ' || to_char(i_org_id));
865:

Line 868: o_err_msg := 'OPIMPXWP.upd_first_push_wip ('

864: || 'org id: ' || to_char(i_org_id));
865:
866: when others then
867: o_err_num := SQLCODE;
868: o_err_msg := 'OPIMPXWP.upd_first_push_wip ('
869: || to_char(l_stmt_num)
870: || '): '
871: || substr(SQLERRM, 1,200);
872:

Line 943: o_err_msg := 'OPIMPXWP.get_prev_end_bal ('

939: l_return_val := 0;
940: return l_return_val;
941: when others then
942: o_err_num := SQLCODE;
943: o_err_msg := 'OPIMPXWP.get_prev_end_bal ('
944: || to_char(l_stmt_num)
945: || '): '
946: || substr(SQLERRM, 1,200);
947:

Line 1122: EDW_LOG.PUT_LINE('OPIMPXWP.update_daily_wip:');

1118: end if; -- end checking for existence of push log row
1119:
1120: EXCEPTION
1121: when process_error then
1122: EDW_LOG.PUT_LINE('OPIMPXWP.update_daily_wip:');
1123: EDW_LOG.PUT_LINE('Error processing (OPIMPXWP.update_daily_wip)...');
1124: EDW_LOG.PUT_LINE('Error Num= ' || to_char(l_err_num));
1125: EDW_LOG.PUT_LINE('Statement Num= ' || to_char(l_stmt_num));
1126:

Line 1123: EDW_LOG.PUT_LINE('Error processing (OPIMPXWP.update_daily_wip)...');

1119:
1120: EXCEPTION
1121: when process_error then
1122: EDW_LOG.PUT_LINE('OPIMPXWP.update_daily_wip:');
1123: EDW_LOG.PUT_LINE('Error processing (OPIMPXWP.update_daily_wip)...');
1124: EDW_LOG.PUT_LINE('Error Num= ' || to_char(l_err_num));
1125: EDW_LOG.PUT_LINE('Statement Num= ' || to_char(l_stmt_num));
1126:
1127: when others then

Line 1129: o_err_msg := 'OPIMPXWP.update_daily_wip ('

1125: EDW_LOG.PUT_LINE('Statement Num= ' || to_char(l_stmt_num));
1126:
1127: when others then
1128: o_err_num := SQLCODE;
1129: o_err_msg := 'OPIMPXWP.update_daily_wip ('
1130: || to_char(l_stmt_num)
1131: || '): '
1132: || substr(SQLERRM, 1,200);
1133: EDW_LOG.PUT_LINE('Error Code: ' || to_char(o_err_num));

Line 1138: END OPIMPXWP;

1134: EDW_LOG.PUT_LINE(o_err_msg);
1135:
1136: END update_daily_wip;
1137:
1138: END OPIMPXWP;