[Home] [Help]
152: AND wdj.organization_id = msik.organization_id
153: AND wdj.wip_entity_id = p_wip_entity_id
154: AND wdj.organization_id = p_org_id;
155:
156: l_log_level NUMBER := fnd_log.g_current_runtime_level;
157: l_error_msg VARCHAR2(240);
158: l_process_phase VARCHAR2(3);
159: l_return_status VARCHAR(1);
160: l_move_info c_move_info%ROWTYPE;
327: AND wdj.wip_entity_id = p_wip_entity_id
328: AND wdj.organization_id = p_org_id;
329:
330: l_level_id NUMBER;
331: l_log_level NUMBER := fnd_log.g_current_runtime_level;
332: l_default_scrap_acct_id VARCHAR2(30);
333: l_error_msg VARCHAR2(240);
334: l_process_phase VARCHAR2(3);
335: l_return_status VARCHAR2(1);
485: p_resp_key IN VARCHAR2,
486: x_move_table_pvt OUT NOCOPY wip_batch_move.move_table_pvt,
487: x_return_status OUT NOCOPY VARCHAR2) IS
488:
489: l_log_level NUMBER := fnd_log.g_current_runtime_level;
490: l_error_msg VARCHAR2(240);
491: l_process_phase VARCHAR2(3);
492: l_return_status VARCHAR2(1);
493: l_params wip_logger.param_tbl_t;
601: x_default_scrap_acct_id OUT NOCOPY NUMBER,
602: x_return_status OUT NOCOPY VARCHAR2) IS
603:
604: l_level_id NUMBER;
605: l_log_level NUMBER := fnd_log.g_current_runtime_level;
606: l_default_scrap_acct_id VARCHAR2(30);
607: l_default_step_type VARCHAR2(1);
608: l_error_msg VARCHAR2(240);
609: l_process_phase VARCHAR2(3);
720: p_assy_serial IN VARCHAR2,
721: x_group_id OUT NOCOPY NUMBER,
722: x_return_status OUT NOCOPY VARCHAR2) IS
723:
724: l_log_level NUMBER := fnd_log.g_current_runtime_level;
725: l_total_row NUMBER;
726: l_error_msg VARCHAR2(240);
727: l_process_phase VARCHAR2(3);
728: l_return_status VARCHAR2(1);
988: FROM wip_move_txn_interface wmti
989: WHERE wmti.group_id = p_group_id
990: ORDER BY wmti.transaction_id;
991:
992: l_log_level NUMBER := fnd_log.g_current_runtime_level;
993: l_error_msg VARCHAR2(1000);
994: l_error_text VARCHAR2(2000);
995: l_process_phase VARCHAR2(3);
996: l_return_status VARCHAR2(1);
1103: x_quality_require OUT NOCOPY VARCHAR2,
1104: x_plan_names OUT NOCOPY VARCHAR2,
1105: x_return_status OUT NOCOPY VARCHAR2)IS
1106:
1107: l_log_level NUMBER := fnd_log.g_current_runtime_level;
1108: l_total_row NUMBER;
1109: l_commit_allow VARCHAR2(1);
1110: l_context_values VARCHAR2(10000);
1111: l_error_msg VARCHAR2(240);
1238: PROCEDURE validate_batch(p_default_step_type IN NUMBER,
1239: x_return_status OUT NOCOPY VARCHAR2) IS
1240:
1241: l_dff_required BOOLEAN;
1242: l_log_level NUMBER := fnd_log.g_current_runtime_level;
1243: l_error_msg VARCHAR2(240);
1244: l_process_phase VARCHAR2(3);
1245: l_return_status VARCHAR2(1);
1246: l_params wip_logger.param_tbl_t;
1329: x_return_status OUT NOCOPY VARCHAR2) IS
1330:
1331: l_available_qty NUMBER;
1332: l_fm_step_type NUMBER;
1333: l_log_level NUMBER := fnd_log.g_current_runtime_level;
1334: l_queue_qty NUMBER;
1335: l_run_qty NUMBER;
1336: l_to_move_qty NUMBER;
1337: l_require_scrap_acct NUMBER;
1535: l_default_scrap_acct_id NUMBER;
1536: l_default_step_type NUMBER;
1537: l_error_row NUMBER := 0;
1538: l_group_id NUMBER;
1539: l_log_level NUMBER := fnd_log.g_current_runtime_level;
1540: l_total_row NUMBER;
1541: l_error_msg VARCHAR2(240);
1542: l_error_text VARCHAR2(2000);
1543: l_return_status VARCHAR2(1);