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 EDW_LOG

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 177: EDW_LOG.PUT_LINE('Start inv txn date: '

173: || 'Processing org id: '
174: || to_char(i_org_id));
175: */
176:
177: EDW_LOG.PUT_LINE('Start inv txn date: '
178: || to_char(i_push_start_inv_txn_date,'DD-MON-YYYY
179: hh24:mi:ss'));
180: EDW_LOG.PUT_LINE('Start wip txn date: '
181: || to_char(i_push_start_wip_txn_date,'DD-MON-YYYY

Line 180: EDW_LOG.PUT_LINE('Start wip txn date: '

176:
177: EDW_LOG.PUT_LINE('Start inv txn date: '
178: || to_char(i_push_start_inv_txn_date,'DD-MON-YYYY
179: hh24:mi:ss'));
180: EDW_LOG.PUT_LINE('Start wip txn date: '
181: || to_char(i_push_start_wip_txn_date,'DD-MON-YYYY
182: hh24:mi:ss'));
183: EDW_LOG.PUT_LINE('Txn end date: '
184: || to_char(i_push_end_txn_date,'DD-MON-YYYY

Line 183: EDW_LOG.PUT_LINE('Txn end date: '

179: hh24:mi:ss'));
180: EDW_LOG.PUT_LINE('Start wip txn date: '
181: || to_char(i_push_start_wip_txn_date,'DD-MON-YYYY
182: hh24:mi:ss'));
183: EDW_LOG.PUT_LINE('Txn end date: '
184: || to_char(i_push_end_txn_date,'DD-MON-YYYY
185: hh24:mi:ss'));
186: EDW_LOG.PUT_LINE('End inv txn id: '
187: || to_char(i_push_last_inv_txn_id));

Line 186: EDW_LOG.PUT_LINE('End inv txn id: '

182: hh24:mi:ss'));
183: EDW_LOG.PUT_LINE('Txn end date: '
184: || to_char(i_push_end_txn_date,'DD-MON-YYYY
185: hh24:mi:ss'));
186: EDW_LOG.PUT_LINE('End inv txn id: '
187: || to_char(i_push_last_inv_txn_id));
188: EDW_LOG.PUT_LINE('End wip txn id: '
189: || to_char(i_push_last_wip_txn_id));
190:

Line 188: EDW_LOG.PUT_LINE('End wip txn id: '

184: || to_char(i_push_end_txn_date,'DD-MON-YYYY
185: hh24:mi:ss'));
186: EDW_LOG.PUT_LINE('End inv txn id: '
187: || to_char(i_push_last_inv_txn_id));
188: EDW_LOG.PUT_LINE('End wip txn id: '
189: || to_char(i_push_last_wip_txn_id));
190:
191: -- initialize local variables
192: l_stmt_num := 0;

Line 334: EDW_LOG.PUT_LINE('Org id: ' || to_char(i_org_id));

330: when no_process then
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;

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 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 848: EDW_LOG.PUT_LINE('Error calling OPIMPXIN.Insert_update_push_log');

844: l_wip_amount, -- p_total6
845: 2, -- selector
846: l_err_num); -- l_status
847: if l_err_num <> 0 then
848: EDW_LOG.PUT_LINE('Error calling OPIMPXIN.Insert_update_push_log');
849: raise process_error;
850: end if;
851: end if; -- end no existing row
852:

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 857: EDW_LOG.PUT_LINE('Error Num= ' || to_char(l_err_num));

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
861: EDW_LOG.PUT_LINE('OPIMPXWP.upd_first_push_wip - stmt: '

Line 858: EDW_LOG.PUT_LINE('Statement Num= ' || to_char(l_stmt_num));

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
861: EDW_LOG.PUT_LINE('OPIMPXWP.upd_first_push_wip - stmt: '
862: || to_char(l_stmt_num));

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 863: EDW_LOG.PUT_LINE('No item in MSI - Item id: ' || to_char(i_item_id)

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:
866: when others then
867: o_err_num := SQLCODE;

Line 1115: EDW_LOG.PUT_LINE('Error calling OPIMPXIN.Insert_update_push_log');

1111: l_avg_value, -- p_total6
1112: 2, -- selector
1113: l_err_num); -- l_status
1114: if l_err_num <> 0 then
1115: EDW_LOG.PUT_LINE('Error calling OPIMPXIN.Insert_update_push_log');
1116: raise process_error;
1117: end if;
1118: end if; -- end checking for existence of push log row
1119:

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 1124: EDW_LOG.PUT_LINE('Error Num= ' || to_char(l_err_num));

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
1128: o_err_num := SQLCODE;

Line 1125: EDW_LOG.PUT_LINE('Statement Num= ' || to_char(l_stmt_num));

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
1128: o_err_num := SQLCODE;
1129: o_err_msg := 'OPIMPXWP.update_daily_wip ('

Line 1133: EDW_LOG.PUT_LINE('Error Code: ' || to_char(o_err_num));

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));
1134: EDW_LOG.PUT_LINE(o_err_msg);
1135:
1136: END update_daily_wip;
1137:

Line 1134: EDW_LOG.PUT_LINE(o_err_msg);

1130: || to_char(l_stmt_num)
1131: || '): '
1132: || substr(SQLERRM, 1,200);
1133: EDW_LOG.PUT_LINE('Error Code: ' || to_char(o_err_num));
1134: EDW_LOG.PUT_LINE(o_err_msg);
1135:
1136: END update_daily_wip;
1137:
1138: END OPIMPXWP;