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.WIP_BATCH_MOVE dependencies on WIP_CONSTANTS

Line 60: IF(p_step_type = wip_constants.queue)THEN

56: ---------------------
57: FUNCTION get_step_meaning(p_step_type NUMBER) RETURN VARCHAR2 IS
58:
59: BEGIN
60: IF(p_step_type = wip_constants.queue)THEN
61: RETURN queue_meaning;
62: ELSIF(p_step_type = wip_constants.run)THEN
63: RETURN run_meaning;
64: ELSIF(p_step_type = wip_constants.tomove)THEN

Line 62: ELSIF(p_step_type = wip_constants.run)THEN

58:
59: BEGIN
60: IF(p_step_type = wip_constants.queue)THEN
61: RETURN queue_meaning;
62: ELSIF(p_step_type = wip_constants.run)THEN
63: RETURN run_meaning;
64: ELSIF(p_step_type = wip_constants.tomove)THEN
65: RETURN tomove_meaning;
66: ELSIF(p_step_type = wip_constants.reject)THEN

Line 64: ELSIF(p_step_type = wip_constants.tomove)THEN

60: IF(p_step_type = wip_constants.queue)THEN
61: RETURN queue_meaning;
62: ELSIF(p_step_type = wip_constants.run)THEN
63: RETURN run_meaning;
64: ELSIF(p_step_type = wip_constants.tomove)THEN
65: RETURN tomove_meaning;
66: ELSIF(p_step_type = wip_constants.reject)THEN
67: RETURN reject_meaning;
68: ELSIF(p_step_type = wip_constants.scrap)THEN

Line 66: ELSIF(p_step_type = wip_constants.reject)THEN

62: ELSIF(p_step_type = wip_constants.run)THEN
63: RETURN run_meaning;
64: ELSIF(p_step_type = wip_constants.tomove)THEN
65: RETURN tomove_meaning;
66: ELSIF(p_step_type = wip_constants.reject)THEN
67: RETURN reject_meaning;
68: ELSIF(p_step_type = wip_constants.scrap)THEN
69: RETURN scrap_meaning;
70: END IF;

Line 68: ELSIF(p_step_type = wip_constants.scrap)THEN

64: ELSIF(p_step_type = wip_constants.tomove)THEN
65: RETURN tomove_meaning;
66: ELSIF(p_step_type = wip_constants.reject)THEN
67: RETURN reject_meaning;
68: ELSIF(p_step_type = wip_constants.scrap)THEN
69: RETURN scrap_meaning;
70: END IF;
71: END get_step_meaning;
72:

Line 118: WIP_CONSTANTS.MOVE_TXN txn_type,

114: wdj.primary_item_id item_id,
115: msik.concatenated_segments item_name,
116: p_move_qty txn_qty,
117: msik.primary_uom_code txn_uom,
118: WIP_CONSTANTS.MOVE_TXN txn_type,
119: wdj.project_id project_id,
120: pjm_project.all_proj_idtonum(wdj.project_id) project_number,
121: wdj.task_id task_id,
122: pjm_project.all_task_idtonum(wdj.task_id) task_number,

Line 148: AND wo3.count_point_type = WIP_CONSTANTS.YES_AUTO)

144: AND ((wo1.next_operation_seq_num IS NOT NULL AND
145: wo3.operation_seq_num > wo1.operation_seq_num) OR
146: (wo1.next_operation_seq_num IS NULL AND
147: wo3.operation_seq_num >= wo1.operation_seq_num))
148: AND wo3.count_point_type = WIP_CONSTANTS.YES_AUTO)
149: AND wo2.standard_operation_id = bso2.standard_operation_id(+)
150: AND wo2.department_id = bd2.department_id
151: AND wdj.primary_item_id = msik.inventory_item_id
152: AND wdj.organization_id = msik.organization_id

Line 166: IF (l_log_level <= wip_constants.trace_logging) THEN

162: l_params wip_logger.param_tbl_t;
163: BEGIN
164: l_process_phase := '1';
165: -- write parameter value to log file
166: IF (l_log_level <= wip_constants.trace_logging) THEN
167: l_params(1).paramName := 'p_org_id';
168: l_params(1).paramValue := p_org_id;
169: l_params(2).paramName := 'p_wip_entity_id';
170: l_params(2).paramValue := p_wip_entity_id;

Line 213: l_move_record.to_intraoperation_step_type := WIP_CONSTANTS.TOMOVE;

209: IF(l_move_info.fm_op_seq = l_move_info.to_op_seq AND
210: p_default_step_type <= p_fm_step_type) THEN
211: -- If it is the last operation and default step is less than or equal to
212: -- current step, set to_step to 'To Move'
213: l_move_record.to_intraoperation_step_type := WIP_CONSTANTS.TOMOVE;
214: ELSE
215: l_move_record.to_intraoperation_step_type := l_move_info.to_step_type;
216: END IF;
217: l_move_record.to_intraoperation_step := get_step_meaning(l_move_info.to_step_type);

Line 234: IF (l_log_level <= wip_constants.trace_logging) THEN

230:
231: x_return_status := fnd_api.g_ret_sts_success;
232:
233: -- write to the log file
234: IF (l_log_level <= wip_constants.trace_logging) THEN
235: wip_logger.exitPoint(p_procName => 'wip_batch_move.derive_move',
236: p_procReturnStatus => x_return_status,
237: p_msg => 'procedure complete',
238: x_returnStatus => l_return_status);

Line 249: IF (l_log_level <= wip_constants.trace_logging) THEN

245: END IF;
246: l_error_msg := 'process_phase = ' || l_process_phase || ';' ||
247: ' unexpected error: ' || SQLERRM || 'SQLCODE = ' || SQLCODE;
248:
249: IF (l_log_level <= wip_constants.trace_logging) THEN
250: wip_logger.exitPoint(p_procName => 'wip_batch_move.derive_move',
251: p_procReturnStatus => x_return_status,
252: p_msg => l_error_msg,
253: x_returnStatus => l_return_status);

Line 286: WIP_CONSTANTS.SCRAP to_step_type,

282: wo2.operation_seq_num to_op_seq,
283: bso2.operation_code to_op_code,
284: wo2.department_id to_dept_id,
285: bd2.department_code to_dept_code,
286: WIP_CONSTANTS.SCRAP to_step_type,
287: wdj.primary_item_id item_id,
288: msik.concatenated_segments item_name,
289: p_scrap_qty txn_qty,
290: msik.primary_uom_code txn_uom,

Line 291: WIP_CONSTANTS.MOVE_TXN txn_type,

287: wdj.primary_item_id item_id,
288: msik.concatenated_segments item_name,
289: p_scrap_qty txn_qty,
290: msik.primary_uom_code txn_uom,
291: WIP_CONSTANTS.MOVE_TXN txn_type,
292: wdj.project_id project_id,
293: pjm_project.all_proj_idtonum(wdj.project_id) project_number,
294: wdj.task_id task_id,
295: pjm_project.all_task_idtonum(wdj.task_id) task_number,

Line 322: AND wo3.count_point_type = WIP_CONSTANTS.YES_AUTO)

318: AND ((wo1.next_operation_seq_num IS NOT NULL AND
319: wo3.operation_seq_num > wo1.operation_seq_num) OR
320: (wo1.next_operation_seq_num IS NULL AND
321: wo3.operation_seq_num >= wo1.operation_seq_num))
322: AND wo3.count_point_type = WIP_CONSTANTS.YES_AUTO)
323: AND wo2.standard_operation_id = bso2.standard_operation_id(+)
324: AND wo2.department_id = bd2.department_id
325: AND wdj.primary_item_id = msik.inventory_item_id
326: AND wdj.organization_id = msik.organization_id

Line 342: IF (l_log_level <= wip_constants.trace_logging) THEN

338: l_params wip_logger.param_tbl_t;
339: BEGIN
340: l_process_phase := '1';
341: -- write parameter value to log file
342: IF (l_log_level <= wip_constants.trace_logging) THEN
343: l_params(1).paramName := 'p_org_id';
344: l_params(1).paramValue := p_org_id;
345: l_params(2).paramName := 'p_wip_entity_id';
346: l_params(2).paramValue := p_wip_entity_id;

Line 381: IF(p_fm_step_type = WIP_CONSTANTS.TOMOVE AND

377: l_scrap_record.fm_department_id := l_scrap_info.fm_dept_id;
378: l_scrap_record.fm_department_code := l_scrap_info.fm_dept_code;
379: l_scrap_record.fm_intraoperation_step_type := l_scrap_info.fm_step_type;
380: l_scrap_record.fm_intraoperation_step := get_step_meaning(l_scrap_info.fm_step_type);
381: IF(p_fm_step_type = WIP_CONSTANTS.TOMOVE AND
382: p_default_step_type = WIP_CONSTANTS.TOMOVE) THEN
383: -- If user move from 10TM to 20TM, we will scrap at operation 20.
384: l_scrap_record.to_operation_seq_num := l_scrap_info.to_op_seq;
385: l_scrap_record.to_operation_code := l_scrap_info.to_op_code;

Line 382: p_default_step_type = WIP_CONSTANTS.TOMOVE) THEN

378: l_scrap_record.fm_department_code := l_scrap_info.fm_dept_code;
379: l_scrap_record.fm_intraoperation_step_type := l_scrap_info.fm_step_type;
380: l_scrap_record.fm_intraoperation_step := get_step_meaning(l_scrap_info.fm_step_type);
381: IF(p_fm_step_type = WIP_CONSTANTS.TOMOVE AND
382: p_default_step_type = WIP_CONSTANTS.TOMOVE) THEN
383: -- If user move from 10TM to 20TM, we will scrap at operation 20.
384: l_scrap_record.to_operation_seq_num := l_scrap_info.to_op_seq;
385: l_scrap_record.to_operation_code := l_scrap_info.to_op_code;
386: l_scrap_record.to_department_id := l_scrap_info.to_dept_id;

Line 388: IF(p_require_scrap_acct = WIP_CONSTANTS.YES) THEN

384: l_scrap_record.to_operation_seq_num := l_scrap_info.to_op_seq;
385: l_scrap_record.to_operation_code := l_scrap_info.to_op_code;
386: l_scrap_record.to_department_id := l_scrap_info.to_dept_id;
387: l_scrap_record.to_department_code := l_scrap_info.to_dept_code;
388: IF(p_require_scrap_acct = WIP_CONSTANTS.YES) THEN
389: l_process_phase := '3';
390: l_level_id := wip_ws_util.get_preference_level_id(
391: p_pref_id => 10, -- Default Scrap Account
392: p_resp_key => p_resp_key,

Line 415: IF(p_require_scrap_acct = WIP_CONSTANTS.YES) THEN

411: l_scrap_record.to_operation_seq_num := l_scrap_info.fm_op_seq;
412: l_scrap_record.to_operation_code := l_scrap_info.fm_op_code;
413: l_scrap_record.to_department_id := l_scrap_info.fm_dept_id;
414: l_scrap_record.to_department_code := l_scrap_info.fm_dept_code;
415: IF(p_require_scrap_acct = WIP_CONSTANTS.YES) THEN
416: l_scrap_record.scrap_account_id := l_scrap_info.scrap_acct_id;
417: END IF;
418: END IF;
419: l_scrap_record.to_intraoperation_step_type := l_scrap_info.to_step_type;

Line 437: IF (l_log_level <= wip_constants.trace_logging) THEN

433:
434: x_return_status := fnd_api.g_ret_sts_success;
435:
436: -- write to the log file
437: IF (l_log_level <= wip_constants.trace_logging) THEN
438: wip_logger.exitPoint(p_procName => 'wip_batch_move.derive_scrap',
439: p_procReturnStatus => x_return_status,
440: p_msg => 'procedure complete',
441: x_returnStatus => l_return_status);

Line 449: IF (l_log_level <= wip_constants.trace_logging) THEN

445: x_return_status := fnd_api.g_ret_sts_error;
446: IF(c_scrap_info%ISOPEN) THEN
447: CLOSE c_scrap_info;
448: END IF;
449: IF (l_log_level <= wip_constants.trace_logging) THEN
450: wip_logger.exitPoint(p_procName => 'wip_batch_move.derive_scrap',
451: p_procReturnStatus => x_return_status,
452: p_msg => l_error_msg,
453: x_returnStatus => l_return_status);

Line 463: IF (l_log_level <= wip_constants.trace_logging) THEN

459: END IF;
460: l_error_msg := 'process_phase = ' || l_process_phase || ';' ||
461: ' unexpected error: ' || SQLERRM || 'SQLCODE = ' || SQLCODE;
462:
463: IF (l_log_level <= wip_constants.trace_logging) THEN
464: wip_logger.exitPoint(p_procName => 'wip_batch_move.derive_scrap',
465: p_procReturnStatus => x_return_status,
466: p_msg => l_error_msg,
467: x_returnStatus => l_return_status);

Line 497: IF (l_log_level <= wip_constants.trace_logging) THEN

493: l_params wip_logger.param_tbl_t;
494: BEGIN
495: l_process_phase := '1';
496: -- write parameter value to log file
497: IF (l_log_level <= wip_constants.trace_logging) THEN
498: l_params(1).paramName := 'p_org_id';
499: l_params(1).paramValue := p_org_id;
500: l_params(2).paramName := 'p_wip_entity_id';
501: l_params(2).paramValue := p_wip_entity_id;

Line 567: IF (l_log_level <= wip_constants.trace_logging) THEN

563: END IF;
564:
565: x_return_status := fnd_api.g_ret_sts_success;
566: -- write to the log file
567: IF (l_log_level <= wip_constants.trace_logging) THEN
568: wip_logger.exitPoint(p_procName => 'wip_batch_move.derive_row',
569: p_procReturnStatus => x_return_status,
570: p_msg => 'procedure complete',
571: x_returnStatus => l_return_status);

Line 577: IF (l_log_level <= wip_constants.trace_logging) THEN

573:
574: EXCEPTION
575: WHEN fnd_api.g_exc_unexpected_error THEN
576: x_return_status := fnd_api.g_ret_sts_error;
577: IF (l_log_level <= wip_constants.trace_logging) THEN
578: wip_logger.exitPoint(p_procName => 'wip_batch_move.derive_row',
579: p_procReturnStatus => x_return_status,
580: p_msg => l_error_msg,
581: x_returnStatus => l_return_status);

Line 589: IF (l_log_level <= wip_constants.trace_logging) THEN

585: x_return_status := fnd_api.g_ret_sts_error;
586: l_error_msg := 'process_phase = ' || l_process_phase || ';' ||
587: ' unexpected error: ' || SQLERRM || 'SQLCODE = ' || SQLCODE;
588:
589: IF (l_log_level <= wip_constants.trace_logging) THEN
590: wip_logger.exitPoint(p_procName => 'wip_batch_move.derive_row',
591: p_procReturnStatus => x_return_status,
592: p_msg => l_error_msg,
593: x_returnStatus => l_return_status);

Line 615: IF (l_log_level <= wip_constants.trace_logging) THEN

611: l_params wip_logger.param_tbl_t;
612: BEGIN
613: l_process_phase := '1';
614: -- write parameter value to log file
615: IF (l_log_level <= wip_constants.trace_logging) THEN
616: l_params(1).paramName := 'p_resp_key';
617: l_params(1).paramValue := p_resp_key;
618: l_params(2).paramName := 'p_org_id';
619: l_params(2).paramValue := p_org_id;

Line 655: IF (l_log_level <= wip_constants.trace_logging) THEN

651:
652: x_return_status := fnd_api.g_ret_sts_success;
653:
654: -- write to the log file
655: IF (l_log_level <= wip_constants.trace_logging) THEN
656: wip_logger.exitPoint(p_procName => 'wip_batch_move.get_preferences',
657: p_procReturnStatus => x_return_status,
658: p_msg => 'procedure complete',
659: x_returnStatus => l_return_status);

Line 667: IF (l_log_level <= wip_constants.trace_logging) THEN

663: x_return_status := fnd_api.g_ret_sts_error;
664: l_error_msg := 'process_phase = ' || l_process_phase || ';' ||
665: ' unexpected error: ' || SQLERRM || 'SQLCODE = ' || SQLCODE;
666:
667: IF (l_log_level <= wip_constants.trace_logging) THEN
668: wip_logger.exitPoint(p_procName => 'wip_batch_move.get_preferences',
669: p_procReturnStatus => x_return_status,
670: p_msg => l_error_msg,
671: x_returnStatus => l_return_status);

Line 692: IF(l_step_meaning.step = wip_constants.queue)THEN

688:
689: BEGIN
690: -- Put step lookup meaning in to global variables
691: FOR l_step_meaning IN c_step_meaning LOOP
692: IF(l_step_meaning.step = wip_constants.queue)THEN
693: queue_meaning := l_step_meaning.meaning;
694: ELSIF(l_step_meaning.step = wip_constants.run)THEN
695: run_meaning := l_step_meaning.meaning;
696: ELSIF(l_step_meaning.step = wip_constants.tomove)THEN

Line 694: ELSIF(l_step_meaning.step = wip_constants.run)THEN

690: -- Put step lookup meaning in to global variables
691: FOR l_step_meaning IN c_step_meaning LOOP
692: IF(l_step_meaning.step = wip_constants.queue)THEN
693: queue_meaning := l_step_meaning.meaning;
694: ELSIF(l_step_meaning.step = wip_constants.run)THEN
695: run_meaning := l_step_meaning.meaning;
696: ELSIF(l_step_meaning.step = wip_constants.tomove)THEN
697: tomove_meaning := l_step_meaning.meaning;
698: ELSIF(l_step_meaning.step = wip_constants.reject)THEN

Line 696: ELSIF(l_step_meaning.step = wip_constants.tomove)THEN

692: IF(l_step_meaning.step = wip_constants.queue)THEN
693: queue_meaning := l_step_meaning.meaning;
694: ELSIF(l_step_meaning.step = wip_constants.run)THEN
695: run_meaning := l_step_meaning.meaning;
696: ELSIF(l_step_meaning.step = wip_constants.tomove)THEN
697: tomove_meaning := l_step_meaning.meaning;
698: ELSIF(l_step_meaning.step = wip_constants.reject)THEN
699: reject_meaning := l_step_meaning.meaning;
700: ELSIF(l_step_meaning.step = wip_constants.scrap)THEN

Line 698: ELSIF(l_step_meaning.step = wip_constants.reject)THEN

694: ELSIF(l_step_meaning.step = wip_constants.run)THEN
695: run_meaning := l_step_meaning.meaning;
696: ELSIF(l_step_meaning.step = wip_constants.tomove)THEN
697: tomove_meaning := l_step_meaning.meaning;
698: ELSIF(l_step_meaning.step = wip_constants.reject)THEN
699: reject_meaning := l_step_meaning.meaning;
700: ELSIF(l_step_meaning.step = wip_constants.scrap)THEN
701: scrap_meaning := l_step_meaning.meaning;
702: END IF;

Line 700: ELSIF(l_step_meaning.step = wip_constants.scrap)THEN

696: ELSIF(l_step_meaning.step = wip_constants.tomove)THEN
697: tomove_meaning := l_step_meaning.meaning;
698: ELSIF(l_step_meaning.step = wip_constants.reject)THEN
699: reject_meaning := l_step_meaning.meaning;
700: ELSIF(l_step_meaning.step = wip_constants.scrap)THEN
701: scrap_meaning := l_step_meaning.meaning;
702: END IF;
703: END LOOP;
704: -- Get meaning of move transaction type

Line 709: AND lookup_code = wip_constants.move_txn;

705: SELECT meaning
706: INTO move_txn_meaning
707: FROM mfg_lookups
708: WHERE lookup_type = 'WIP_MOVE_TRANSACTION_TYPE'
709: AND lookup_code = wip_constants.move_txn;
710: EXCEPTION
711: WHEN others THEN
712: IF(c_step_meaning%ISOPEN) THEN
713: CLOSE c_step_meaning;

Line 734: IF (l_log_level <= wip_constants.trace_logging) THEN

730: l_txn_id NUMBER;
731: BEGIN
732: l_process_phase := '1';
733: -- write parameter value to log file
734: IF (l_log_level <= wip_constants.trace_logging) THEN
735: l_params(1).paramName := 'p_org_id';
736: l_params(1).paramValue := p_org_id;
737: l_params(2).paramName := 'p_employee_id';
738: l_params(2).paramValue := p_employee_id;

Line 825: WIP_CONSTANTS.MOVE_VAL, -- process_phase

821: NULL, -- program_update_date
822: NULL, -- kanban_card_id
823: NULL, -- source_code
824: NULL, -- source_line_id
825: WIP_CONSTANTS.MOVE_VAL, -- process_phase
826: WIP_CONSTANTS.RUNNING, -- process_status
827: WIP_CONSTANTS.MOVE_TXN, -- transaction_type
828: p_org_id, -- organization_id
829: NULL, -- organization_code

Line 826: WIP_CONSTANTS.RUNNING, -- process_status

822: NULL, -- kanban_card_id
823: NULL, -- source_code
824: NULL, -- source_line_id
825: WIP_CONSTANTS.MOVE_VAL, -- process_phase
826: WIP_CONSTANTS.RUNNING, -- process_status
827: WIP_CONSTANTS.MOVE_TXN, -- transaction_type
828: p_org_id, -- organization_id
829: NULL, -- organization_code
830: p_move_table_pvt(i).wip_entity_id,

Line 827: WIP_CONSTANTS.MOVE_TXN, -- transaction_type

823: NULL, -- source_code
824: NULL, -- source_line_id
825: WIP_CONSTANTS.MOVE_VAL, -- process_phase
826: WIP_CONSTANTS.RUNNING, -- process_status
827: WIP_CONSTANTS.MOVE_TXN, -- transaction_type
828: p_org_id, -- organization_id
829: NULL, -- organization_code
830: p_move_table_pvt(i).wip_entity_id,
831: p_move_table_pvt(i).wip_entity_name,

Line 832: WIP_CONSTANTS.DISCRETE, -- entity_type

828: p_org_id, -- organization_id
829: NULL, -- organization_code
830: p_move_table_pvt(i).wip_entity_id,
831: p_move_table_pvt(i).wip_entity_name,
832: WIP_CONSTANTS.DISCRETE, -- entity_type
833: p_move_table_pvt(i).primary_item_id,
834: NULL, -- line_id
835: NULL, -- line_code
836: NULL, -- repetitive_schedule_id

Line 930: IF (l_log_level <= wip_constants.trace_logging) THEN

926: END IF;
927:
928: x_return_status := fnd_api.g_ret_sts_success;
929: -- write to the log file
930: IF (l_log_level <= wip_constants.trace_logging) THEN
931: wip_logger.exitPoint(p_procName => 'wip_batch_move.insert_move_records',
932: p_procReturnStatus => x_return_status,
933: p_msg => 'procedure complete',
934: x_returnStatus => l_return_status);

Line 943: IF (l_log_level <= wip_constants.trace_logging) THEN

939: x_return_status := fnd_api.g_ret_sts_error;
940: l_error_msg := 'process_phase = ' || l_process_phase || ';' ||
941: ' unexpected error: ' || SQLERRM || 'SQLCODE = ' || SQLCODE;
942:
943: IF (l_log_level <= wip_constants.trace_logging) THEN
944: wip_logger.exitPoint(p_procName => 'wip_batch_move.insert_move_records',
945: p_procReturnStatus => x_return_status,
946: p_msg => l_error_msg,
947: x_returnStatus => l_return_status);

Line 1004: IF (l_log_level <= wip_constants.trace_logging) THEN

1000:
1001: BEGIN
1002: l_process_phase := '1';
1003: -- write parameter value to log file
1004: IF (l_log_level <= wip_constants.trace_logging) THEN
1005: l_params(1).paramName := 'p_group_id';
1006: l_params(1).paramValue := p_group_id;
1007:
1008: wip_logger.entryPoint(p_procName => 'wip_batch_move.process_move_records',

Line 1022: p_proc_phase => WIP_CONSTANTS.MOVE_VAL,

1018:
1019: wip_movProc_priv.processIntf(p_group_id => p_group_id,
1020: p_child_txn_id => -1,
1021: p_mtl_header_id => -1,
1022: p_proc_phase => WIP_CONSTANTS.MOVE_VAL,
1023: p_time_out => 0,
1024: p_move_mode => WIP_CONSTANTS.BACKGROUND,
1025: p_bf_mode => WIP_CONSTANTS.ONLINE,
1026: p_mtl_mode => WIP_CONSTANTS.ONLINE,

Line 1024: p_move_mode => WIP_CONSTANTS.BACKGROUND,

1020: p_child_txn_id => -1,
1021: p_mtl_header_id => -1,
1022: p_proc_phase => WIP_CONSTANTS.MOVE_VAL,
1023: p_time_out => 0,
1024: p_move_mode => WIP_CONSTANTS.BACKGROUND,
1025: p_bf_mode => WIP_CONSTANTS.ONLINE,
1026: p_mtl_mode => WIP_CONSTANTS.ONLINE,
1027: p_endDebug => fnd_api.g_false,
1028: p_initMsgList => fnd_api.g_true,

Line 1025: p_bf_mode => WIP_CONSTANTS.ONLINE,

1021: p_mtl_header_id => -1,
1022: p_proc_phase => WIP_CONSTANTS.MOVE_VAL,
1023: p_time_out => 0,
1024: p_move_mode => WIP_CONSTANTS.BACKGROUND,
1025: p_bf_mode => WIP_CONSTANTS.ONLINE,
1026: p_mtl_mode => WIP_CONSTANTS.ONLINE,
1027: p_endDebug => fnd_api.g_false,
1028: p_initMsgList => fnd_api.g_true,
1029: p_insertAssy => fnd_api.g_true,

Line 1026: p_mtl_mode => WIP_CONSTANTS.ONLINE,

1022: p_proc_phase => WIP_CONSTANTS.MOVE_VAL,
1023: p_time_out => 0,
1024: p_move_mode => WIP_CONSTANTS.BACKGROUND,
1025: p_bf_mode => WIP_CONSTANTS.ONLINE,
1026: p_mtl_mode => WIP_CONSTANTS.ONLINE,
1027: p_endDebug => fnd_api.g_false,
1028: p_initMsgList => fnd_api.g_true,
1029: p_insertAssy => fnd_api.g_true,
1030: p_do_backflush => fnd_api.g_true,

Line 1049: IF (l_log_level <= wip_constants.trace_logging) THEN

1045: l_process_phase := '6';
1046: END IF;
1047:
1048: -- write to the log file
1049: IF (l_log_level <= wip_constants.trace_logging) THEN
1050: wip_logger.exitPoint(p_procName => 'wip_batch_move.process_move_records',
1051: p_procReturnStatus => x_return_status,
1052: p_msg => 'procedure complete',
1053: x_returnStatus => l_return_status);

Line 1070: IF (l_log_level <= wip_constants.trace_logging) THEN

1066: l_error_text := l_error_text || l_errors.error_column ||':' ||
1067: l_errors.error_message || '; ';
1068: END LOOP;
1069:
1070: IF (l_log_level <= wip_constants.trace_logging) THEN
1071: wip_logger.exitPoint(p_procName => 'wip_batch_move.process_move_records',
1072: p_procReturnStatus => x_return_status,
1073: p_msg => 'wip_movProc_grp.processInterface failed',
1074: x_returnStatus => l_return_status);

Line 1090: IF (l_log_level <= wip_constants.trace_logging) THEN

1086: END IF;
1087: l_error_msg := 'process_phase = ' || l_process_phase || ';' ||
1088: ' unexpected error: ' || SQLERRM || 'SQLCODE = ' || SQLCODE;
1089:
1090: IF (l_log_level <= wip_constants.trace_logging) THEN
1091: wip_logger.exitPoint(p_procName => 'wip_batch_move.process_move_records',
1092: p_procReturnStatus => x_return_status,
1093: p_msg => l_error_msg,
1094: x_returnStatus => l_return_status);

Line 1119: IF (l_log_level <= wip_constants.trace_logging) THEN

1115: l_return_status VARCHAR2(1);
1116: l_params wip_logger.param_tbl_t;
1117: BEGIN
1118: -- write parameter value to log file
1119: IF (l_log_level <= wip_constants.trace_logging) THEN
1120: l_params(1).paramName := 'p_org_id';
1121: l_params(1).paramValue := p_org_id;
1122:
1123: wip_logger.entryPoint(p_procName => 'wip_batch_move.quality_require',

Line 1155: IF (l_log_level <= wip_constants.trace_logging) THEN

1151: qa_ss_const.project_number||'='||p_move_tbl(i).project_number||'@'||
1152: qa_ss_const.task_number||'='||p_move_tbl(i).task_number||'@'||
1153: qa_ss_const.bom_revision||'='||p_move_tbl(i).bom_revision;
1154:
1155: IF (l_log_level <= wip_constants.trace_logging) THEN
1156: wip_logger.log(p_msg => 'l_context_values='||l_context_values,
1157: x_returnStatus => l_return_status);
1158: END IF;
1159:

Line 1201: IF (l_log_level <= wip_constants.trace_logging) THEN

1197: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
1198: fnd_message.set_token('MESSAGE', l_error_msg);
1199: fnd_msg_pub.add;
1200:
1201: IF (l_log_level <= wip_constants.trace_logging) THEN
1202: wip_logger.log(p_msg => l_error_msg,
1203: x_returnStatus => l_return_status);
1204: END IF;
1205: END;

Line 1209: IF (l_log_level <= wip_constants.trace_logging) THEN

1205: END;
1206: END LOOP;
1207:
1208: -- write to the log file
1209: IF (l_log_level <= wip_constants.trace_logging) THEN
1210: wip_logger.exitPoint(p_procName => 'wip_batch_move.quality_require',
1211: p_procReturnStatus => fnd_api.g_ret_sts_success,
1212: p_msg => 'procedure complete',
1213: x_returnStatus => l_return_status);

Line 1219: IF (l_log_level <= wip_constants.trace_logging) THEN

1215: <>
1216: x_return_status := fnd_api.g_ret_sts_success;
1217:
1218: -- write to the log file
1219: IF (l_log_level <= wip_constants.trace_logging) THEN
1220: wip_logger.exitPoint(p_procName => 'wip_batch_move.derive_move',
1221: p_procReturnStatus => x_return_status,
1222: p_msg => 'procedure complete',
1223: x_returnStatus => l_return_status);

Line 1230: IF (l_log_level <= wip_constants.trace_logging) THEN

1226: WHEN others THEN
1227: x_return_status := fnd_api.g_ret_sts_error;
1228: l_error_msg := ' unexpected error: ' || SQLERRM || 'SQLCODE = ' || SQLCODE;
1229:
1230: IF (l_log_level <= wip_constants.trace_logging) THEN
1231: wip_logger.exitPoint(p_procName => 'wip_batch_move.derive_move',
1232: p_procReturnStatus => x_return_status,
1233: p_msg => l_error_msg,
1234: x_returnStatus => l_return_status);

Line 1250: IF (l_log_level <= wip_constants.trace_logging) THEN

1246: l_params wip_logger.param_tbl_t;
1247: BEGIN
1248: l_process_phase := '1';
1249: -- write parameter value to log file
1250: IF (l_log_level <= wip_constants.trace_logging) THEN
1251: l_params(1).paramName := 'p_default_step_type';
1252: l_params(1).paramValue := p_default_step_type;
1253:
1254: wip_logger.entryPoint(p_procName => 'wip_batch_move.validate_batch',

Line 1284: IF (l_log_level <= wip_constants.trace_logging) THEN

1280: END IF;
1281:
1282: x_return_status := fnd_api.g_ret_sts_success;
1283: -- write to the log file
1284: IF (l_log_level <= wip_constants.trace_logging) THEN
1285: wip_logger.exitPoint(p_procName => 'wip_batch_move.validate_batch',
1286: p_procReturnStatus => x_return_status,
1287: p_msg => 'procedure complete',
1288: x_returnStatus => l_return_status);

Line 1294: IF (l_log_level <= wip_constants.trace_logging) THEN

1290: EXCEPTION
1291: WHEN fnd_api.g_exc_unexpected_error THEN
1292: x_return_status := fnd_api.g_ret_sts_error;
1293:
1294: IF (l_log_level <= wip_constants.trace_logging) THEN
1295: wip_logger.exitPoint(p_procName => 'wip_batch_move.validate_batch',
1296: p_procReturnStatus => x_return_status,
1297: p_msg => l_error_msg,
1298: x_returnStatus => l_return_status);

Line 1306: IF (l_log_level <= wip_constants.trace_logging) THEN

1302: x_return_status := fnd_api.g_ret_sts_error;
1303: l_error_msg := 'process_phase = ' || l_process_phase || ';' ||
1304: ' unexpected error: ' || SQLERRM || 'SQLCODE = ' || SQLCODE;
1305:
1306: IF (l_log_level <= wip_constants.trace_logging) THEN
1307: wip_logger.exitPoint(p_procName => 'wip_batch_move.validate_batch',
1308: p_procReturnStatus => x_return_status,
1309: p_msg => l_error_msg,
1310: x_returnStatus => l_return_status);

Line 1347: IF (l_log_level <= wip_constants.trace_logging) THEN

1343: l_params wip_logger.param_tbl_t;
1344: BEGIN
1345: l_process_phase := '1';
1346: -- write parameter value to log file
1347: IF (l_log_level <= wip_constants.trace_logging) THEN
1348: l_params(1).paramName := 'p_org_id';
1349: l_params(1).paramValue := p_org_id;
1350: l_params(2).paramName := 'p_wip_entity_id';
1351: l_params(2).paramValue := p_wip_entity_id;

Line 1405: l_fm_step_type := WIP_CONSTANTS.QUEUE;

1401: END IF;
1402:
1403: -- If quantity not split, derive from step.
1404: IF(l_queue_qty = l_available_qty)THEN
1405: l_fm_step_type := WIP_CONSTANTS.QUEUE;
1406: ELSIF(l_run_qty = l_available_qty) THEN
1407: l_fm_step_type := WIP_CONSTANTS.RUN;
1408: ELSIF(l_to_move_qty = l_available_qty) THEN
1409: l_fm_step_type := WIP_CONSTANTS.TOMOVE;

Line 1407: l_fm_step_type := WIP_CONSTANTS.RUN;

1403: -- If quantity not split, derive from step.
1404: IF(l_queue_qty = l_available_qty)THEN
1405: l_fm_step_type := WIP_CONSTANTS.QUEUE;
1406: ELSIF(l_run_qty = l_available_qty) THEN
1407: l_fm_step_type := WIP_CONSTANTS.RUN;
1408: ELSIF(l_to_move_qty = l_available_qty) THEN
1409: l_fm_step_type := WIP_CONSTANTS.TOMOVE;
1410: END IF;
1411: ELSE -- Express move from search serial page, quantity can be splitted.

Line 1409: l_fm_step_type := WIP_CONSTANTS.TOMOVE;

1405: l_fm_step_type := WIP_CONSTANTS.QUEUE;
1406: ELSIF(l_run_qty = l_available_qty) THEN
1407: l_fm_step_type := WIP_CONSTANTS.RUN;
1408: ELSIF(l_to_move_qty = l_available_qty) THEN
1409: l_fm_step_type := WIP_CONSTANTS.TOMOVE;
1410: END IF;
1411: ELSE -- Express move from search serial page, quantity can be splitted.
1412: l_process_phase := '2.2';
1413: -- From_step is the current location of the serial.

Line 1414: SELECT nvl(msn.intraoperation_step_type, WIP_CONSTANTS.QUEUE)

1410: END IF;
1411: ELSE -- Express move from search serial page, quantity can be splitted.
1412: l_process_phase := '2.2';
1413: -- From_step is the current location of the serial.
1414: SELECT nvl(msn.intraoperation_step_type, WIP_CONSTANTS.QUEUE)
1415: INTO l_fm_step_type
1416: FROM mtl_serial_numbers msn,
1417: wip_discrete_jobs wdj
1418: WHERE wdj.organization_id = p_org_id

Line 1442: l_require_scrap_acct = WIP_CONSTANTS.YES AND

1438: WHERE organization_id = p_org_id;
1439: -- If user provide scrap quantity and organization require scrap account,
1440: -- preference "Default Scrap Account" must be set.
1441: IF(p_scrap_qty > 0 AND
1442: l_require_scrap_acct = WIP_CONSTANTS.YES AND
1443: p_default_scrap_acct_id IS NULL) THEN
1444: fnd_message.set_name('WIP','WIP_NO_SCRAP_ACCT_NO_BATCH');
1445: fnd_msg_pub.add;
1446: l_error_msg := 'No default scrap accout defined.';

Line 1496: IF (l_log_level <= wip_constants.trace_logging) THEN

1492:
1493: x_return_status := fnd_api.g_ret_sts_success;
1494:
1495: -- write to the log file
1496: IF (l_log_level <= wip_constants.trace_logging) THEN
1497: wip_logger.exitPoint(p_procName => 'wip_batch_move.validate_row',
1498: p_procReturnStatus => x_return_status,
1499: p_msg => 'procedure complete',
1500: x_returnStatus => l_return_status);

Line 1505: IF (l_log_level <= wip_constants.trace_logging) THEN

1501: END IF;
1502: EXCEPTION
1503: WHEN fnd_api.g_exc_unexpected_error THEN
1504: x_return_status := fnd_api.g_ret_sts_error;
1505: IF (l_log_level <= wip_constants.trace_logging) THEN
1506: wip_logger.exitPoint(p_procName => 'wip_batch_move.validate_row',
1507: p_procReturnStatus => x_return_status,
1508: p_msg => l_error_msg,
1509: x_returnStatus => l_return_status);

Line 1517: IF (l_log_level <= wip_constants.trace_logging) THEN

1513: x_return_status := fnd_api.g_ret_sts_error;
1514: l_error_msg := 'process_phase = ' || l_process_phase || ';' ||
1515: ' unexpected error: ' || SQLERRM || 'SQLCODE = ' || SQLCODE;
1516:
1517: IF (l_log_level <= wip_constants.trace_logging) THEN
1518: wip_logger.exitPoint(p_procName => 'wip_batch_move.validate_row',
1519: p_procReturnStatus => x_return_status,
1520: p_msg => l_error_msg,
1521: x_returnStatus => l_return_status);

Line 1548: IF (l_log_level <= wip_constants.trace_logging) THEN

1544: l_move_table_pvt wip_batch_move.move_table_pvt;
1545: l_params wip_logger.param_tbl_t;
1546: BEGIN
1547: -- write parameter value to log file
1548: IF (l_log_level <= wip_constants.trace_logging) THEN
1549: l_params(1).paramName := 'p_resp_key';
1550: l_params(1).paramValue := p_resp_key;
1551: l_params(2).paramName := 'p_org_id';
1552: l_params(2).paramValue := p_org_id;

Line 1649: IF (l_log_level <= wip_constants.trace_logging) THEN

1645: p_op_seq_num => p_move_table(i).op_seq,
1646: p_error_text => l_error_text);
1647: l_error_row := l_error_row + 1;
1648: l_error_msg := 'row = ' || i || ' : ' || l_error_msg;
1649: IF (l_log_level <= wip_constants.trace_logging) THEN
1650: wip_logger.log(p_msg => l_error_msg,
1651: x_returnStatus => l_return_status);
1652: END IF;
1653:

Line 1665: IF (l_log_level <= wip_constants.trace_logging) THEN

1661: l_error_row := l_error_row + 1;
1662: l_error_msg := 'row = ' || i || ' : ' ||
1663: ' unexpected error: ' || SQLERRM || 'SQLCODE = ' ||
1664: SQLCODE;
1665: IF (l_log_level <= wip_constants.trace_logging) THEN
1666: wip_logger.log(p_msg => l_error_msg,
1667: x_returnStatus => l_return_status);
1668: END IF;
1669: END;

Line 1680: IF (l_log_level <= wip_constants.trace_logging) THEN

1676: load_errors;
1677: x_return_status := fnd_api.g_ret_sts_error;
1678: END IF;
1679: -- Write to the log file.
1680: IF (l_log_level <= wip_constants.trace_logging) THEN
1681: wip_logger.exitPoint(p_procName => 'wip_batch_move.process',
1682: p_procReturnStatus => x_return_status,
1683: p_msg => 'procedure complete',
1684: x_returnStatus => l_return_status);

Line 1690: IF (l_log_level <= wip_constants.trace_logging) THEN

1686: END IF;
1687: EXCEPTION
1688: WHEN fnd_api.g_exc_unexpected_error THEN
1689: x_return_status := fnd_api.g_ret_sts_error;
1690: IF (l_log_level <= wip_constants.trace_logging) THEN
1691: wip_logger.exitPoint(p_procName => 'wip_batch_move.process',
1692: p_procReturnStatus => x_return_status,
1693: p_msg => l_error_msg,
1694: x_returnStatus => l_return_status);

Line 1702: IF (l_log_level <= wip_constants.trace_logging) THEN

1698: WHEN others THEN
1699: x_return_status := fnd_api.g_ret_sts_error;
1700: l_error_msg := ' unexpected error: ' || SQLERRM || 'SQLCODE = ' || SQLCODE;
1701:
1702: IF (l_log_level <= wip_constants.trace_logging) THEN
1703: wip_logger.exitPoint(p_procName => 'wip_batch_move.process',
1704: p_procReturnStatus => x_return_status,
1705: p_msg => l_error_msg,
1706: x_returnStatus => l_return_status);