[Home] [Help]
964: l_module || '.' || l_stmt_num,
965: SQLERRM);
966: END IF;
967: ROLLBACK;
968: fnd_file.put_line(fnd_file.log,' Exception in Insert_wip_costs');
969: x_err_num := SQLCODE;
970: x_err_code := NULL;
971: x_err_msg := SUBSTR('CSTPPWAS.insert_wip_costs('
972: || to_char(l_stmt_num)
2179: END IF;
2180:
2181: EXCEPTION
2182: WHEN OTHERS THEN
2183: fnd_file.put_line(fnd_file.log,' Exception '||to_char(l_stmt_num));
2184: IF (l_uLog) THEN
2185: FND_LOG.STRING (FND_LOG.LEVEL_UNEXPECTED,
2186: l_module || '.' || l_stmt_num,
2187: SQLERRM);
4604: END LOOP;
4605:
4606: FOR c_ent_rec IN c_non_rework_entity_scrap LOOP
4607:
4608: fnd_file.put_line(fnd_file.log,' Scrap_Qty Update << ');
4609: l_stmt_num := 45;
4610:
4611: UPDATE WIP_PAC_PERIOD_BALANCES
4612: SET relieved_scrap_qty = nvl(relieved_scrap_qty,0) + c_ent_rec.net_scrap