[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;
438: AND wdj.wip_entity_id = p_wip_entity_id
439: AND wdj.organization_id = p_org_id;
440:
441: l_level_id NUMBER;
442: l_log_level NUMBER := fnd_log.g_current_runtime_level;
443: l_default_scrap_acct_id VARCHAR2(30);
444: l_error_msg VARCHAR2(240);
445: l_process_phase VARCHAR2(3);
446: l_return_status VARCHAR2(1);
596: p_resp_key IN VARCHAR2,
597: x_move_table_pvt OUT NOCOPY wip_batch_move.move_table_pvt,
598: x_return_status OUT NOCOPY VARCHAR2) IS
599:
600: l_log_level NUMBER := fnd_log.g_current_runtime_level;
601: l_error_msg VARCHAR2(240);
602: l_process_phase VARCHAR2(3);
603: l_return_status VARCHAR2(1);
604: l_params wip_logger.param_tbl_t;
712: x_default_scrap_acct_id OUT NOCOPY NUMBER,
713: x_return_status OUT NOCOPY VARCHAR2) IS
714:
715: l_level_id NUMBER;
716: l_log_level NUMBER := fnd_log.g_current_runtime_level;
717: l_default_scrap_acct_id VARCHAR2(30);
718: l_default_step_type VARCHAR2(1);
719: l_error_msg VARCHAR2(240);
720: l_process_phase VARCHAR2(3);
831: p_assy_serial IN VARCHAR2,
832: x_group_id OUT NOCOPY NUMBER,
833: x_return_status OUT NOCOPY VARCHAR2) IS
834:
835: l_log_level NUMBER := fnd_log.g_current_runtime_level;
836: l_total_row NUMBER;
837: l_error_msg VARCHAR2(240);
838: l_process_phase VARCHAR2(3);
839: l_return_status VARCHAR2(1);
1099: FROM wip_move_txn_interface wmti
1100: WHERE wmti.group_id = p_group_id
1101: ORDER BY wmti.transaction_id;
1102:
1103: l_log_level NUMBER := fnd_log.g_current_runtime_level;
1104: l_error_msg VARCHAR2(1000);
1105: l_error_text VARCHAR2(2000);
1106: l_process_phase VARCHAR2(3);
1107: l_return_status VARCHAR2(1);
1215: x_quality_require OUT NOCOPY VARCHAR2,
1216: x_plan_names OUT NOCOPY VARCHAR2,
1217: x_return_status OUT NOCOPY VARCHAR2)IS
1218:
1219: l_log_level NUMBER := fnd_log.g_current_runtime_level;
1220: l_total_row NUMBER;
1221: l_commit_allow VARCHAR2(1);
1222: l_context_values VARCHAR2(10000);
1223: l_context_ids VARCHAR2(10000); -- fix bug 13336388
1408: PROCEDURE validate_batch(p_default_step_type IN NUMBER,
1409: x_return_status OUT NOCOPY VARCHAR2) IS
1410:
1411: l_dff_required BOOLEAN;
1412: l_log_level NUMBER := fnd_log.g_current_runtime_level;
1413: l_error_msg VARCHAR2(240);
1414: l_process_phase VARCHAR2(3);
1415: l_return_status VARCHAR2(1);
1416: l_params wip_logger.param_tbl_t;
1499: x_return_status OUT NOCOPY VARCHAR2) IS
1500:
1501: l_available_qty NUMBER;
1502: l_fm_step_type NUMBER;
1503: l_log_level NUMBER := fnd_log.g_current_runtime_level;
1504: l_queue_qty NUMBER;
1505: l_run_qty NUMBER;
1506: l_to_move_qty NUMBER;
1507: l_require_scrap_acct NUMBER;
1744: l_default_scrap_acct_id NUMBER;
1745: l_default_step_type NUMBER;
1746: l_error_row NUMBER := 0;
1747: l_group_id NUMBER;
1748: l_log_level NUMBER := fnd_log.g_current_runtime_level;
1749: l_total_row NUMBER;
1750: l_error_msg VARCHAR2(240);
1751: l_error_text VARCHAR2(2000);
1752: l_return_status VARCHAR2(1);