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 175: IF (l_log_level <= wip_constants.trace_logging) THEN

171: l_return_message VARCHAR2(240);
172: BEGIN
173: l_process_phase := '1';
174: -- write parameter value to log file
175: IF (l_log_level <= wip_constants.trace_logging) THEN
176: l_params(1).paramName := 'p_org_id';
177: l_params(1).paramValue := p_org_id;
178: l_params(2).paramName := 'p_wip_entity_id';
179: l_params(2).paramValue := p_wip_entity_id;

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

266: IF(c_move_info%ISOPEN) THEN
267: CLOSE c_move_info;
268: END IF;
269: l_error_msg := 'MOVE_TO_STEP_HOOK errored out: ' || l_return_message;
270: IF (l_log_level <= wip_constants.trace_logging) THEN
271: wip_logger.exitPoint(p_procName => 'wip_batch_move.derive_move',
272: p_procReturnStatus => x_return_status,
273: p_msg => l_error_msg,
274: x_returnStatus => l_return_status);

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

291: IF(l_move_info.fm_op_seq = l_move_info.to_op_seq AND
292: p_default_step_type <= p_fm_step_type) THEN
293: -- If it is the last operation and default step is less than or equal to
294: -- current step, set to_step to 'To Move'
295: l_move_record.to_intraoperation_step_type := WIP_CONSTANTS.TOMOVE;
296: ELSE
297: l_move_record.to_intraoperation_step_type := l_move_info.to_step_type;
298: END IF;
299: END IF;

Line 319: IF(l_express_cmp = 1 AND l_next_op_seq_num is null AND l_move_record.to_intraoperation_step_type = WIP_CONSTANTS.TOMOVE) THEN

315: and organization_id = p_org_id
316: and operation_seq_num = l_move_record.to_operation_seq_num;
317:
318: --only do express complete when preference Express Move and Complete at Last Operation is set to yes
319: IF(l_express_cmp = 1 AND l_next_op_seq_num is null AND l_move_record.to_intraoperation_step_type = WIP_CONSTANTS.TOMOVE) THEN
320: wip_logger.log('EZ completion',l_return_status);
321: l_move_record.transaction_type := WIP_CONSTANTS.COMP_TXN;
322: ELSE
323: wip_logger.log('Normal Move',l_return_status);

Line 321: l_move_record.transaction_type := WIP_CONSTANTS.COMP_TXN;

317:
318: --only do express complete when preference Express Move and Complete at Last Operation is set to yes
319: IF(l_express_cmp = 1 AND l_next_op_seq_num is null AND l_move_record.to_intraoperation_step_type = WIP_CONSTANTS.TOMOVE) THEN
320: wip_logger.log('EZ completion',l_return_status);
321: l_move_record.transaction_type := WIP_CONSTANTS.COMP_TXN;
322: ELSE
323: wip_logger.log('Normal Move',l_return_status);
324: l_move_record.transaction_type := WIP_CONSTANTS.MOVE_TXN;
325: END IF;

Line 324: l_move_record.transaction_type := WIP_CONSTANTS.MOVE_TXN;

320: wip_logger.log('EZ completion',l_return_status);
321: l_move_record.transaction_type := WIP_CONSTANTS.COMP_TXN;
322: ELSE
323: wip_logger.log('Normal Move',l_return_status);
324: l_move_record.transaction_type := WIP_CONSTANTS.MOVE_TXN;
325: END IF;
326:
327: l_move_record.to_intraoperation_step := get_step_meaning(l_move_info.to_step_type);
328: l_move_record.primary_item_id := l_move_info.item_id;

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

341:
342: x_return_status := fnd_api.g_ret_sts_success;
343:
344: -- write to the log file
345: IF (l_log_level <= wip_constants.trace_logging) THEN
346: wip_logger.exitPoint(p_procName => 'wip_batch_move.derive_move',
347: p_procReturnStatus => x_return_status,
348: p_msg => 'procedure complete',
349: x_returnStatus => l_return_status);

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

356: END IF;
357: l_error_msg := 'process_phase = ' || l_process_phase || ';' ||
358: ' unexpected error: ' || SQLERRM || 'SQLCODE = ' || SQLCODE;
359:
360: IF (l_log_level <= wip_constants.trace_logging) THEN
361: wip_logger.exitPoint(p_procName => 'wip_batch_move.derive_move',
362: p_procReturnStatus => x_return_status,
363: p_msg => l_error_msg,
364: x_returnStatus => l_return_status);

Line 397: WIP_CONSTANTS.SCRAP to_step_type,

393: wo2.operation_seq_num to_op_seq,
394: bso2.operation_code to_op_code,
395: wo2.department_id to_dept_id,
396: bd2.department_code to_dept_code,
397: WIP_CONSTANTS.SCRAP to_step_type,
398: wdj.primary_item_id item_id,
399: msik.concatenated_segments item_name,
400: p_scrap_qty txn_qty,
401: msik.primary_uom_code txn_uom,

Line 402: WIP_CONSTANTS.MOVE_TXN txn_type,

398: wdj.primary_item_id item_id,
399: msik.concatenated_segments item_name,
400: p_scrap_qty txn_qty,
401: msik.primary_uom_code txn_uom,
402: WIP_CONSTANTS.MOVE_TXN txn_type,
403: wdj.project_id project_id,
404: pjm_project.all_proj_idtonum(wdj.project_id) project_number,
405: wdj.task_id task_id,
406: pjm_project.all_task_idtonum(wdj.task_id) task_number,

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

429: AND ((wo1.next_operation_seq_num IS NOT NULL AND
430: wo3.operation_seq_num > wo1.operation_seq_num) OR
431: (wo1.next_operation_seq_num IS NULL AND
432: wo3.operation_seq_num >= wo1.operation_seq_num))
433: AND wo3.count_point_type = WIP_CONSTANTS.YES_AUTO)
434: AND wo2.standard_operation_id = bso2.standard_operation_id(+)
435: AND wo2.department_id = bd2.department_id
436: AND wdj.primary_item_id = msik.inventory_item_id
437: AND wdj.organization_id = msik.organization_id

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

449: l_params wip_logger.param_tbl_t;
450: BEGIN
451: l_process_phase := '1';
452: -- write parameter value to log file
453: IF (l_log_level <= wip_constants.trace_logging) THEN
454: l_params(1).paramName := 'p_org_id';
455: l_params(1).paramValue := p_org_id;
456: l_params(2).paramName := 'p_wip_entity_id';
457: l_params(2).paramValue := p_wip_entity_id;

Line 492: IF(p_fm_step_type = WIP_CONSTANTS.TOMOVE AND

488: l_scrap_record.fm_department_id := l_scrap_info.fm_dept_id;
489: l_scrap_record.fm_department_code := l_scrap_info.fm_dept_code;
490: l_scrap_record.fm_intraoperation_step_type := l_scrap_info.fm_step_type;
491: l_scrap_record.fm_intraoperation_step := get_step_meaning(l_scrap_info.fm_step_type);
492: IF(p_fm_step_type = WIP_CONSTANTS.TOMOVE AND
493: p_default_step_type = WIP_CONSTANTS.TOMOVE) THEN
494: -- If user move from 10TM to 20TM, we will scrap at operation 20.
495: l_scrap_record.to_operation_seq_num := l_scrap_info.to_op_seq;
496: l_scrap_record.to_operation_code := l_scrap_info.to_op_code;

Line 493: p_default_step_type = WIP_CONSTANTS.TOMOVE) THEN

489: l_scrap_record.fm_department_code := l_scrap_info.fm_dept_code;
490: l_scrap_record.fm_intraoperation_step_type := l_scrap_info.fm_step_type;
491: l_scrap_record.fm_intraoperation_step := get_step_meaning(l_scrap_info.fm_step_type);
492: IF(p_fm_step_type = WIP_CONSTANTS.TOMOVE AND
493: p_default_step_type = WIP_CONSTANTS.TOMOVE) THEN
494: -- If user move from 10TM to 20TM, we will scrap at operation 20.
495: l_scrap_record.to_operation_seq_num := l_scrap_info.to_op_seq;
496: l_scrap_record.to_operation_code := l_scrap_info.to_op_code;
497: l_scrap_record.to_department_id := l_scrap_info.to_dept_id;

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

495: l_scrap_record.to_operation_seq_num := l_scrap_info.to_op_seq;
496: l_scrap_record.to_operation_code := l_scrap_info.to_op_code;
497: l_scrap_record.to_department_id := l_scrap_info.to_dept_id;
498: l_scrap_record.to_department_code := l_scrap_info.to_dept_code;
499: IF(p_require_scrap_acct = WIP_CONSTANTS.YES) THEN
500: l_process_phase := '3';
501: l_level_id := wip_ws_util.get_preference_level_id(
502: p_pref_id => 10, -- Default Scrap Account
503: p_resp_key => p_resp_key,

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

522: l_scrap_record.to_operation_seq_num := l_scrap_info.fm_op_seq;
523: l_scrap_record.to_operation_code := l_scrap_info.fm_op_code;
524: l_scrap_record.to_department_id := l_scrap_info.fm_dept_id;
525: l_scrap_record.to_department_code := l_scrap_info.fm_dept_code;
526: IF(p_require_scrap_acct = WIP_CONSTANTS.YES) THEN
527: l_scrap_record.scrap_account_id := l_scrap_info.scrap_acct_id;
528: END IF;
529: END IF;
530: l_scrap_record.to_intraoperation_step_type := l_scrap_info.to_step_type;

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

544:
545: x_return_status := fnd_api.g_ret_sts_success;
546:
547: -- write to the log file
548: IF (l_log_level <= wip_constants.trace_logging) THEN
549: wip_logger.exitPoint(p_procName => 'wip_batch_move.derive_scrap',
550: p_procReturnStatus => x_return_status,
551: p_msg => 'procedure complete',
552: x_returnStatus => l_return_status);

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

556: x_return_status := fnd_api.g_ret_sts_error;
557: IF(c_scrap_info%ISOPEN) THEN
558: CLOSE c_scrap_info;
559: END IF;
560: IF (l_log_level <= wip_constants.trace_logging) THEN
561: wip_logger.exitPoint(p_procName => 'wip_batch_move.derive_scrap',
562: p_procReturnStatus => x_return_status,
563: p_msg => l_error_msg,
564: x_returnStatus => l_return_status);

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

570: END IF;
571: l_error_msg := 'process_phase = ' || l_process_phase || ';' ||
572: ' unexpected error: ' || SQLERRM || 'SQLCODE = ' || SQLCODE;
573:
574: IF (l_log_level <= wip_constants.trace_logging) THEN
575: wip_logger.exitPoint(p_procName => 'wip_batch_move.derive_scrap',
576: p_procReturnStatus => x_return_status,
577: p_msg => l_error_msg,
578: x_returnStatus => l_return_status);

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

604: l_params wip_logger.param_tbl_t;
605: BEGIN
606: l_process_phase := '1';
607: -- write parameter value to log file
608: IF (l_log_level <= wip_constants.trace_logging) THEN
609: l_params(1).paramName := 'p_org_id';
610: l_params(1).paramValue := p_org_id;
611: l_params(2).paramName := 'p_wip_entity_id';
612: l_params(2).paramValue := p_wip_entity_id;

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

674: END IF;
675:
676: x_return_status := fnd_api.g_ret_sts_success;
677: -- write to the log file
678: IF (l_log_level <= wip_constants.trace_logging) THEN
679: wip_logger.exitPoint(p_procName => 'wip_batch_move.derive_row',
680: p_procReturnStatus => x_return_status,
681: p_msg => 'procedure complete',
682: x_returnStatus => l_return_status);

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

684:
685: EXCEPTION
686: WHEN fnd_api.g_exc_unexpected_error THEN
687: x_return_status := fnd_api.g_ret_sts_error;
688: IF (l_log_level <= wip_constants.trace_logging) THEN
689: wip_logger.exitPoint(p_procName => 'wip_batch_move.derive_row',
690: p_procReturnStatus => x_return_status,
691: p_msg => l_error_msg,
692: x_returnStatus => l_return_status);

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

696: x_return_status := fnd_api.g_ret_sts_error;
697: l_error_msg := 'process_phase = ' || l_process_phase || ';' ||
698: ' unexpected error: ' || SQLERRM || 'SQLCODE = ' || SQLCODE;
699:
700: IF (l_log_level <= wip_constants.trace_logging) THEN
701: wip_logger.exitPoint(p_procName => 'wip_batch_move.derive_row',
702: p_procReturnStatus => x_return_status,
703: p_msg => l_error_msg,
704: x_returnStatus => l_return_status);

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

722: l_params wip_logger.param_tbl_t;
723: BEGIN
724: l_process_phase := '1';
725: -- write parameter value to log file
726: IF (l_log_level <= wip_constants.trace_logging) THEN
727: l_params(1).paramName := 'p_resp_key';
728: l_params(1).paramValue := p_resp_key;
729: l_params(2).paramName := 'p_org_id';
730: l_params(2).paramValue := p_org_id;

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

762:
763: x_return_status := fnd_api.g_ret_sts_success;
764:
765: -- write to the log file
766: IF (l_log_level <= wip_constants.trace_logging) THEN
767: wip_logger.exitPoint(p_procName => 'wip_batch_move.get_preferences',
768: p_procReturnStatus => x_return_status,
769: p_msg => 'procedure complete',
770: x_returnStatus => l_return_status);

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

774: x_return_status := fnd_api.g_ret_sts_error;
775: l_error_msg := 'process_phase = ' || l_process_phase || ';' ||
776: ' unexpected error: ' || SQLERRM || 'SQLCODE = ' || SQLCODE;
777:
778: IF (l_log_level <= wip_constants.trace_logging) THEN
779: wip_logger.exitPoint(p_procName => 'wip_batch_move.get_preferences',
780: p_procReturnStatus => x_return_status,
781: p_msg => l_error_msg,
782: x_returnStatus => l_return_status);

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

799:
800: BEGIN
801: -- Put step lookup meaning in to global variables
802: FOR l_step_meaning IN c_step_meaning LOOP
803: IF(l_step_meaning.step = wip_constants.queue)THEN
804: queue_meaning := l_step_meaning.meaning;
805: ELSIF(l_step_meaning.step = wip_constants.run)THEN
806: run_meaning := l_step_meaning.meaning;
807: ELSIF(l_step_meaning.step = wip_constants.tomove)THEN

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

801: -- Put step lookup meaning in to global variables
802: FOR l_step_meaning IN c_step_meaning LOOP
803: IF(l_step_meaning.step = wip_constants.queue)THEN
804: queue_meaning := l_step_meaning.meaning;
805: ELSIF(l_step_meaning.step = wip_constants.run)THEN
806: run_meaning := l_step_meaning.meaning;
807: ELSIF(l_step_meaning.step = wip_constants.tomove)THEN
808: tomove_meaning := l_step_meaning.meaning;
809: ELSIF(l_step_meaning.step = wip_constants.reject)THEN

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

803: IF(l_step_meaning.step = wip_constants.queue)THEN
804: queue_meaning := l_step_meaning.meaning;
805: ELSIF(l_step_meaning.step = wip_constants.run)THEN
806: run_meaning := l_step_meaning.meaning;
807: ELSIF(l_step_meaning.step = wip_constants.tomove)THEN
808: tomove_meaning := l_step_meaning.meaning;
809: ELSIF(l_step_meaning.step = wip_constants.reject)THEN
810: reject_meaning := l_step_meaning.meaning;
811: ELSIF(l_step_meaning.step = wip_constants.scrap)THEN

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

805: ELSIF(l_step_meaning.step = wip_constants.run)THEN
806: run_meaning := l_step_meaning.meaning;
807: ELSIF(l_step_meaning.step = wip_constants.tomove)THEN
808: tomove_meaning := l_step_meaning.meaning;
809: ELSIF(l_step_meaning.step = wip_constants.reject)THEN
810: reject_meaning := l_step_meaning.meaning;
811: ELSIF(l_step_meaning.step = wip_constants.scrap)THEN
812: scrap_meaning := l_step_meaning.meaning;
813: END IF;

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

807: ELSIF(l_step_meaning.step = wip_constants.tomove)THEN
808: tomove_meaning := l_step_meaning.meaning;
809: ELSIF(l_step_meaning.step = wip_constants.reject)THEN
810: reject_meaning := l_step_meaning.meaning;
811: ELSIF(l_step_meaning.step = wip_constants.scrap)THEN
812: scrap_meaning := l_step_meaning.meaning;
813: END IF;
814: END LOOP;
815: -- Get meaning of move transaction type

Line 820: AND lookup_code = wip_constants.move_txn;

816: SELECT meaning
817: INTO move_txn_meaning
818: FROM mfg_lookups
819: WHERE lookup_type = 'WIP_MOVE_TRANSACTION_TYPE'
820: AND lookup_code = wip_constants.move_txn;
821: EXCEPTION
822: WHEN others THEN
823: IF(c_step_meaning%ISOPEN) THEN
824: CLOSE c_step_meaning;

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

841: l_txn_id NUMBER;
842: BEGIN
843: l_process_phase := '1';
844: -- write parameter value to log file
845: IF (l_log_level <= wip_constants.trace_logging) THEN
846: l_params(1).paramName := 'p_org_id';
847: l_params(1).paramValue := p_org_id;
848: l_params(2).paramName := 'p_employee_id';
849: l_params(2).paramValue := p_employee_id;

Line 936: WIP_CONSTANTS.MOVE_VAL, -- process_phase

932: NULL, -- program_update_date
933: NULL, -- kanban_card_id
934: NULL, -- source_code
935: NULL, -- source_line_id
936: WIP_CONSTANTS.MOVE_VAL, -- process_phase
937: WIP_CONSTANTS.RUNNING, -- process_status
938: p_move_table_pvt(i).transaction_type, -- transaction_type
939: p_org_id, -- organization_id
940: NULL, -- organization_code

Line 937: WIP_CONSTANTS.RUNNING, -- process_status

933: NULL, -- kanban_card_id
934: NULL, -- source_code
935: NULL, -- source_line_id
936: WIP_CONSTANTS.MOVE_VAL, -- process_phase
937: WIP_CONSTANTS.RUNNING, -- process_status
938: p_move_table_pvt(i).transaction_type, -- transaction_type
939: p_org_id, -- organization_id
940: NULL, -- organization_code
941: p_move_table_pvt(i).wip_entity_id,

Line 943: WIP_CONSTANTS.DISCRETE, -- entity_type

939: p_org_id, -- organization_id
940: NULL, -- organization_code
941: p_move_table_pvt(i).wip_entity_id,
942: p_move_table_pvt(i).wip_entity_name,
943: WIP_CONSTANTS.DISCRETE, -- entity_type
944: p_move_table_pvt(i).primary_item_id,
945: NULL, -- line_id
946: NULL, -- line_code
947: NULL, -- repetitive_schedule_id

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

1037: END IF;
1038:
1039: x_return_status := fnd_api.g_ret_sts_success;
1040: -- write to the log file
1041: IF (l_log_level <= wip_constants.trace_logging) THEN
1042: wip_logger.exitPoint(p_procName => 'wip_batch_move.insert_move_records',
1043: p_procReturnStatus => x_return_status,
1044: p_msg => 'procedure complete',
1045: x_returnStatus => l_return_status);

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

1050: x_return_status := fnd_api.g_ret_sts_error;
1051: l_error_msg := 'process_phase = ' || l_process_phase || ';' ||
1052: ' unexpected error: ' || SQLERRM || 'SQLCODE = ' || SQLCODE;
1053:
1054: IF (l_log_level <= wip_constants.trace_logging) THEN
1055: wip_logger.exitPoint(p_procName => 'wip_batch_move.insert_move_records',
1056: p_procReturnStatus => x_return_status,
1057: p_msg => l_error_msg,
1058: x_returnStatus => l_return_status);

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

1111:
1112: BEGIN
1113: l_process_phase := '1';
1114: -- write parameter value to log file
1115: IF (l_log_level <= wip_constants.trace_logging) THEN
1116: l_params(1).paramName := 'p_group_id';
1117: l_params(1).paramValue := p_group_id;
1118:
1119: wip_logger.entryPoint(p_procName => 'wip_batch_move.process_move_records',

Line 1133: p_proc_phase => WIP_CONSTANTS.MOVE_VAL,

1129:
1130: wip_movProc_priv.processIntf(p_group_id => p_group_id,
1131: p_child_txn_id => -1,
1132: p_mtl_header_id => -1,
1133: p_proc_phase => WIP_CONSTANTS.MOVE_VAL,
1134: p_time_out => 0,
1135: p_move_mode => WIP_CONSTANTS.BACKGROUND,
1136: p_bf_mode => WIP_CONSTANTS.ONLINE,
1137: p_mtl_mode => WIP_CONSTANTS.ONLINE,

Line 1135: p_move_mode => WIP_CONSTANTS.BACKGROUND,

1131: p_child_txn_id => -1,
1132: p_mtl_header_id => -1,
1133: p_proc_phase => WIP_CONSTANTS.MOVE_VAL,
1134: p_time_out => 0,
1135: p_move_mode => WIP_CONSTANTS.BACKGROUND,
1136: p_bf_mode => WIP_CONSTANTS.ONLINE,
1137: p_mtl_mode => WIP_CONSTANTS.ONLINE,
1138: p_endDebug => fnd_api.g_false,
1139: p_initMsgList => fnd_api.g_true,

Line 1136: p_bf_mode => WIP_CONSTANTS.ONLINE,

1132: p_mtl_header_id => -1,
1133: p_proc_phase => WIP_CONSTANTS.MOVE_VAL,
1134: p_time_out => 0,
1135: p_move_mode => WIP_CONSTANTS.BACKGROUND,
1136: p_bf_mode => WIP_CONSTANTS.ONLINE,
1137: p_mtl_mode => WIP_CONSTANTS.ONLINE,
1138: p_endDebug => fnd_api.g_false,
1139: p_initMsgList => fnd_api.g_true,
1140: p_insertAssy => fnd_api.g_true,

Line 1137: p_mtl_mode => WIP_CONSTANTS.ONLINE,

1133: p_proc_phase => WIP_CONSTANTS.MOVE_VAL,
1134: p_time_out => 0,
1135: p_move_mode => WIP_CONSTANTS.BACKGROUND,
1136: p_bf_mode => WIP_CONSTANTS.ONLINE,
1137: p_mtl_mode => WIP_CONSTANTS.ONLINE,
1138: p_endDebug => fnd_api.g_false,
1139: p_initMsgList => fnd_api.g_true,
1140: p_insertAssy => fnd_api.g_true,
1141: p_do_backflush => fnd_api.g_true,

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

1156: l_process_phase := '6';
1157: END IF;
1158:
1159: -- write to the log file
1160: IF (l_log_level <= wip_constants.trace_logging) THEN
1161: wip_logger.exitPoint(p_procName => 'wip_batch_move.process_move_records',
1162: p_procReturnStatus => x_return_status,
1163: p_msg => 'procedure complete',
1164: x_returnStatus => l_return_status);

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

1177: l_error_text := l_error_text || l_errors.error_column ||':' ||
1178: l_errors.error_message || '; ';
1179: END LOOP;
1180:
1181: IF (l_log_level <= wip_constants.trace_logging) THEN
1182: wip_logger.exitPoint(p_procName => 'wip_batch_move.process_move_records',
1183: p_procReturnStatus => x_return_status,
1184: p_msg => 'wip_movProc_grp.processInterface failed',
1185: x_returnStatus => l_return_status);

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

1197: END IF;
1198: l_error_msg := 'process_phase = ' || l_process_phase || ';' ||
1199: ' unexpected error: ' || SQLERRM || 'SQLCODE = ' || SQLCODE;
1200:
1201: IF (l_log_level <= wip_constants.trace_logging) THEN
1202: wip_logger.exitPoint(p_procName => 'wip_batch_move.process_move_records',
1203: p_procReturnStatus => x_return_status,
1204: p_msg => l_error_msg,
1205: x_returnStatus => l_return_status);

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

1232: l_return_status VARCHAR2(1);
1233: l_params wip_logger.param_tbl_t;
1234: BEGIN
1235: -- write parameter value to log file
1236: IF (l_log_level <= wip_constants.trace_logging) THEN
1237: l_params(1).paramName := 'p_org_id';
1238: l_params(1).paramValue := p_org_id;
1239:
1240: wip_logger.entryPoint(p_procName => 'wip_batch_move.quality_require',

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

1295: qa_ss_const.transaction_date||'='||sysdate||'@'||
1296: qa_ss_const.project_number||'='||p_move_tbl(i).project_id||'@'||
1297: qa_ss_const.task_number||'='||p_move_tbl(i).task_id;
1298:
1299: IF (l_log_level <= wip_constants.trace_logging) THEN
1300: wip_logger.log(p_msg => 'l_context_values='||l_context_values,
1301: x_returnStatus => l_return_status);
1302: END IF;
1303:

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

1367: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
1368: fnd_message.set_token('MESSAGE', l_error_msg);
1369: fnd_msg_pub.add;
1370:
1371: IF (l_log_level <= wip_constants.trace_logging) THEN
1372: wip_logger.log(p_msg => l_error_msg,
1373: x_returnStatus => l_return_status);
1374: END IF;
1375: END;

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

1375: END;
1376: END LOOP;
1377:
1378: -- write to the log file
1379: IF (l_log_level <= wip_constants.trace_logging) THEN
1380: wip_logger.exitPoint(p_procName => 'wip_batch_move.quality_require',
1381: p_procReturnStatus => fnd_api.g_ret_sts_success,
1382: p_msg => 'procedure complete',
1383: x_returnStatus => l_return_status);

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

1385: <>
1386: x_return_status := fnd_api.g_ret_sts_success;
1387:
1388: -- write to the log file
1389: IF (l_log_level <= wip_constants.trace_logging) THEN
1390: wip_logger.exitPoint(p_procName => 'wip_batch_move.derive_move',
1391: p_procReturnStatus => x_return_status,
1392: p_msg => 'procedure complete',
1393: x_returnStatus => l_return_status);

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

1396: WHEN others THEN
1397: x_return_status := fnd_api.g_ret_sts_error;
1398: l_error_msg := ' unexpected error: ' || SQLERRM || 'SQLCODE = ' || SQLCODE;
1399:
1400: IF (l_log_level <= wip_constants.trace_logging) THEN
1401: wip_logger.exitPoint(p_procName => 'wip_batch_move.derive_move',
1402: p_procReturnStatus => x_return_status,
1403: p_msg => l_error_msg,
1404: x_returnStatus => l_return_status);

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

1416: l_params wip_logger.param_tbl_t;
1417: BEGIN
1418: l_process_phase := '1';
1419: -- write parameter value to log file
1420: IF (l_log_level <= wip_constants.trace_logging) THEN
1421: l_params(1).paramName := 'p_default_step_type';
1422: l_params(1).paramValue := p_default_step_type;
1423:
1424: wip_logger.entryPoint(p_procName => 'wip_batch_move.validate_batch',

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

1450: END IF;
1451:
1452: x_return_status := fnd_api.g_ret_sts_success;
1453: -- write to the log file
1454: IF (l_log_level <= wip_constants.trace_logging) THEN
1455: wip_logger.exitPoint(p_procName => 'wip_batch_move.validate_batch',
1456: p_procReturnStatus => x_return_status,
1457: p_msg => 'procedure complete',
1458: x_returnStatus => l_return_status);

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

1460: EXCEPTION
1461: WHEN fnd_api.g_exc_unexpected_error THEN
1462: x_return_status := fnd_api.g_ret_sts_error;
1463:
1464: IF (l_log_level <= wip_constants.trace_logging) THEN
1465: wip_logger.exitPoint(p_procName => 'wip_batch_move.validate_batch',
1466: p_procReturnStatus => x_return_status,
1467: p_msg => l_error_msg,
1468: x_returnStatus => l_return_status);

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

1472: x_return_status := fnd_api.g_ret_sts_error;
1473: l_error_msg := 'process_phase = ' || l_process_phase || ';' ||
1474: ' unexpected error: ' || SQLERRM || 'SQLCODE = ' || SQLCODE;
1475:
1476: IF (l_log_level <= wip_constants.trace_logging) THEN
1477: wip_logger.exitPoint(p_procName => 'wip_batch_move.validate_batch',
1478: p_procReturnStatus => x_return_status,
1479: p_msg => l_error_msg,
1480: x_returnStatus => l_return_status);

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

1529:
1530: BEGIN
1531: l_process_phase := '1';
1532: -- write parameter value to log file
1533: IF (l_log_level <= wip_constants.trace_logging) THEN
1534: l_params(1).paramName := 'p_org_id';
1535: l_params(1).paramValue := p_org_id;
1536: l_params(2).paramName := 'p_wip_entity_id';
1537: l_params(2).paramValue := p_wip_entity_id;

Line 1591: l_fm_step_type := WIP_CONSTANTS.QUEUE;

1587: END IF;
1588:
1589: -- If quantity not split, derive from step.
1590: IF(l_queue_qty = l_available_qty)THEN
1591: l_fm_step_type := WIP_CONSTANTS.QUEUE;
1592: ELSIF(l_run_qty = l_available_qty) THEN
1593: l_fm_step_type := WIP_CONSTANTS.RUN;
1594: ELSIF(l_to_move_qty = l_available_qty) THEN
1595: l_fm_step_type := WIP_CONSTANTS.TOMOVE;

Line 1593: l_fm_step_type := WIP_CONSTANTS.RUN;

1589: -- If quantity not split, derive from step.
1590: IF(l_queue_qty = l_available_qty)THEN
1591: l_fm_step_type := WIP_CONSTANTS.QUEUE;
1592: ELSIF(l_run_qty = l_available_qty) THEN
1593: l_fm_step_type := WIP_CONSTANTS.RUN;
1594: ELSIF(l_to_move_qty = l_available_qty) THEN
1595: l_fm_step_type := WIP_CONSTANTS.TOMOVE;
1596: END IF;
1597:

Line 1595: l_fm_step_type := WIP_CONSTANTS.TOMOVE;

1591: l_fm_step_type := WIP_CONSTANTS.QUEUE;
1592: ELSIF(l_run_qty = l_available_qty) THEN
1593: l_fm_step_type := WIP_CONSTANTS.RUN;
1594: ELSIF(l_to_move_qty = l_available_qty) THEN
1595: l_fm_step_type := WIP_CONSTANTS.TOMOVE;
1596: END IF;
1597:
1598: --Fix bug 13336388, determine whether is serialized job
1599: select nvl(wdj.serialization_start_op, -1)

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

1604:
1605: ELSE -- Express move from search serial page, quantity can be splitted.
1606: l_process_phase := '2.2';
1607: -- From_step is the current location of the serial.
1608: SELECT nvl(msn.intraoperation_step_type, WIP_CONSTANTS.QUEUE)
1609: INTO l_fm_step_type
1610: FROM mtl_serial_numbers msn,
1611: wip_discrete_jobs wdj
1612: WHERE wdj.organization_id = p_org_id

Line 1636: l_require_scrap_acct = WIP_CONSTANTS.YES AND

1632: WHERE organization_id = p_org_id;
1633: -- If user provide scrap quantity and organization require scrap account,
1634: -- preference "Default Scrap Account" must be set.
1635: IF(p_scrap_qty > 0 AND
1636: l_require_scrap_acct = WIP_CONSTANTS.YES AND
1637: p_default_scrap_acct_id IS NULL) THEN
1638: fnd_message.set_name('WIP','WIP_NO_SCRAP_ACCT_NO_BATCH');
1639: fnd_msg_pub.add;
1640: l_error_msg := 'No default scrap accout defined.';

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

1701:
1702: x_return_status := fnd_api.g_ret_sts_success;
1703:
1704: -- write to the log file
1705: IF (l_log_level <= wip_constants.trace_logging) THEN
1706: wip_logger.exitPoint(p_procName => 'wip_batch_move.validate_row',
1707: p_procReturnStatus => x_return_status,
1708: p_msg => 'procedure complete',
1709: x_returnStatus => l_return_status);

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

1710: END IF;
1711: EXCEPTION
1712: WHEN fnd_api.g_exc_unexpected_error THEN
1713: x_return_status := fnd_api.g_ret_sts_error;
1714: IF (l_log_level <= wip_constants.trace_logging) THEN
1715: wip_logger.exitPoint(p_procName => 'wip_batch_move.validate_row',
1716: p_procReturnStatus => x_return_status,
1717: p_msg => l_error_msg,
1718: x_returnStatus => l_return_status);

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

1722: x_return_status := fnd_api.g_ret_sts_error;
1723: l_error_msg := 'process_phase = ' || l_process_phase || ';' ||
1724: ' unexpected error: ' || SQLERRM || 'SQLCODE = ' || SQLCODE;
1725:
1726: IF (l_log_level <= wip_constants.trace_logging) THEN
1727: wip_logger.exitPoint(p_procName => 'wip_batch_move.validate_row',
1728: p_procReturnStatus => x_return_status,
1729: p_msg => l_error_msg,
1730: x_returnStatus => l_return_status);

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

1753: l_move_table_pvt wip_batch_move.move_table_pvt;
1754: l_params wip_logger.param_tbl_t;
1755: BEGIN
1756: -- write parameter value to log file
1757: IF (l_log_level <= wip_constants.trace_logging) THEN
1758: l_params(1).paramName := 'p_resp_key';
1759: l_params(1).paramValue := p_resp_key;
1760: l_params(2).paramName := 'p_org_id';
1761: l_params(2).paramValue := p_org_id;

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

1854: p_op_seq_num => p_move_table(i).op_seq,
1855: p_error_text => l_error_text);
1856: l_error_row := l_error_row + 1;
1857: l_error_msg := 'row = ' || i || ' : ' || l_error_msg;
1858: IF (l_log_level <= wip_constants.trace_logging) THEN
1859: wip_logger.log(p_msg => l_error_msg,
1860: x_returnStatus => l_return_status);
1861: END IF;
1862:

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

1870: l_error_row := l_error_row + 1;
1871: l_error_msg := 'row = ' || i || ' : ' ||
1872: ' unexpected error: ' || SQLERRM || 'SQLCODE = ' ||
1873: SQLCODE;
1874: IF (l_log_level <= wip_constants.trace_logging) THEN
1875: wip_logger.log(p_msg => l_error_msg,
1876: x_returnStatus => l_return_status);
1877: END IF;
1878: END;

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

1885: load_errors;
1886: x_return_status := fnd_api.g_ret_sts_error;
1887: END IF;
1888: -- Write to the log file.
1889: IF (l_log_level <= wip_constants.trace_logging) THEN
1890: wip_logger.exitPoint(p_procName => 'wip_batch_move.process',
1891: p_procReturnStatus => x_return_status,
1892: p_msg => 'procedure complete',
1893: x_returnStatus => l_return_status);

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

1895: END IF;
1896: EXCEPTION
1897: WHEN fnd_api.g_exc_unexpected_error THEN
1898: x_return_status := fnd_api.g_ret_sts_error;
1899: IF (l_log_level <= wip_constants.trace_logging) THEN
1900: wip_logger.exitPoint(p_procName => 'wip_batch_move.process',
1901: p_procReturnStatus => x_return_status,
1902: p_msg => l_error_msg,
1903: x_returnStatus => l_return_status);

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

1907: WHEN others THEN
1908: x_return_status := fnd_api.g_ret_sts_error;
1909: l_error_msg := ' unexpected error: ' || SQLERRM || 'SQLCODE = ' || SQLCODE;
1910:
1911: IF (l_log_level <= wip_constants.trace_logging) THEN
1912: wip_logger.exitPoint(p_procName => 'wip_batch_move.process',
1913: p_procReturnStatus => x_return_status,
1914: p_msg => l_error_msg,
1915: x_returnStatus => l_return_status);