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

Line 1337: (p_to_intraop_step_type = WIP_CONSTANTS.SCRAP) ) THEN

1333: l_stmt_num := 165;
1334:
1335: -- Allow forward moves in the open interface, Returns are not allowed
1336: IF ( (l_txn_type = 2) AND -- Move and Completion
1337: (p_to_intraop_step_type = WIP_CONSTANTS.SCRAP) ) THEN
1338: x_return_code := 1;
1339:
1340: FND_MESSAGE.SET_NAME('WSM', 'WSM_TXN_FOR_SCR');
1341: x_err_buf := FND_MESSAGE.GET;

Line 1516: IF ( (p_fm_intraop_step_type = WIP_CONSTANTS.SCRAP) AND

1512: return(x_return_code);
1513: END IF;
1514:
1515: -- p_fm_intraop_step_type should not be Scrap
1516: IF ( (p_fm_intraop_step_type = WIP_CONSTANTS.SCRAP) AND
1517: (l_txn_type <> 4) ) THEN -- Added condition as a part of fix for bug #2083671
1518: x_return_code := 1;
1519:
1520: FND_MESSAGE.SET_NAME('WSM', 'WSM_NO_MOVE_FM_SCRAP');

Line 2833: (p_to_intraop_step_type = WIP_CONSTANTS.REJECT)) THEN

2829: END IF;
2830:
2831: -- p_to_intraop_step_type should not be > 5 -- NSO Modification by abedajna
2832: IF ((p_to_intraop_step_type > 5) OR (p_to_intraop_step_type is NULL) OR
2833: (p_to_intraop_step_type = WIP_CONSTANTS.REJECT)) THEN
2834: x_return_code := 1;
2835:
2836: FND_MESSAGE.SET_NAME('WSM', 'WSM_INVALID_FIELD');
2837: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'to_intraop_step_type');

Line 2845: IF ( (p_to_intraop_step_type = WIP_CONSTANTS.SCRAP) AND

2841: return(x_return_code);
2842: END IF;
2843:
2844: -- Cannot Scrap in a Future Op
2845: IF ( (p_to_intraop_step_type = WIP_CONSTANTS.SCRAP) AND
2846: -- BC: CZH.bug2362225 need to consider NULL value
2847: --(l_wo_op_seq_id <> l_op_seq_id)
2848: ( nvl(l_wo_op_seq_id, -99) <> nvl(l_op_seq_id, -99)
2849: or -- ADD: CZH, jump will always add a new op, hence, cannot scrap

Line 2908: IF ( ( (p_to_intraop_step_type = WIP_CONSTANTS.SCRAP)

2904: -- CZH.DBG: WHAT IF l_wo_op_seq_id or l_op_seq_id IS NULL???
2905: IF (l_wo_op_seq_id <> l_op_seq_id) THEN -- Check if p_fm_op_seq_num = p_to_op_seq_num
2906: l_err_condition := 1;
2907: ELSE -- p_fm_op_seq_num = p_to_op_seq_num
2908: IF ( ( (p_to_intraop_step_type = WIP_CONSTANTS.SCRAP)
2909: OR
2910: ( (l_scrap_qty>0)
2911: AND
2912: --bug 3385113 add nvl

Line 2915: ( (p_fm_intraop_step_type = WIP_CONSTANTS.QUEUE)

2911: AND
2912: --bug 3385113 add nvl
2913: (nvl(l_scrap_at_operation_flag, -1)=1)))
2914: AND
2915: ( (p_fm_intraop_step_type = WIP_CONSTANTS.QUEUE)
2916: AND
2917: (l_next_mand_step = WIP_CONSTANTS.RUN)
2918: )) THEN
2919:

Line 2917: (l_next_mand_step = WIP_CONSTANTS.RUN)

2913: (nvl(l_scrap_at_operation_flag, -1)=1)))
2914: AND
2915: ( (p_fm_intraop_step_type = WIP_CONSTANTS.QUEUE)
2916: AND
2917: (l_next_mand_step = WIP_CONSTANTS.RUN)
2918: )) THEN
2919:
2920: l_err_condition := 1;
2921:

Line 2924: --move enh case 2100 added p_to_intraop_step_type <> WIP_CONSTANTS.SCRAP

2920: l_err_condition := 1;
2921:
2922: END IF;
2923: -- ELSE
2924: --move enh case 2100 added p_to_intraop_step_type <> WIP_CONSTANTS.SCRAP
2925: IF ((p_txn_qty > 0) AND (p_to_intraop_step_type <> WIP_CONSTANTS.SCRAP)
2926: AND (p_to_intraop_step_type > l_next_mand_step)) THEN
2927:
2928: l_err_condition := 1;

Line 2925: IF ((p_txn_qty > 0) AND (p_to_intraop_step_type <> WIP_CONSTANTS.SCRAP)

2921:
2922: END IF;
2923: -- ELSE
2924: --move enh case 2100 added p_to_intraop_step_type <> WIP_CONSTANTS.SCRAP
2925: IF ((p_txn_qty > 0) AND (p_to_intraop_step_type <> WIP_CONSTANTS.SCRAP)
2926: AND (p_to_intraop_step_type > l_next_mand_step)) THEN
2927:
2928: l_err_condition := 1;
2929:

Line 2975: IF ((l_scrap_qty>0) AND (l_scrap_at_operation_flag=2) AND (l_next_mand_step IN (WIP_CONSTANTS.QUEUE,

2971: l_next_mand_step := WSMPOPRN.get_next_mandatory_step(0, l_intra_op_flag_value);
2972: -- l_next_mand_step is now the mandatory intra-op in p_to_op_seq_num
2973:
2974: IF (l_next_mand_step > 0) THEN -- there is a mandatory intraop
2975: IF ((l_scrap_qty>0) AND (l_scrap_at_operation_flag=2) AND (l_next_mand_step IN (WIP_CONSTANTS.QUEUE,
2976: WIP_CONSTANTS.RUN))) THEN
2977: l_err_condition := 1;
2978: END IF;
2979: IF ((p_txn_qty > 0) AND (p_to_intraop_step_type > l_next_mand_step)) THEN

Line 2976: WIP_CONSTANTS.RUN))) THEN

2972: -- l_next_mand_step is now the mandatory intra-op in p_to_op_seq_num
2973:
2974: IF (l_next_mand_step > 0) THEN -- there is a mandatory intraop
2975: IF ((l_scrap_qty>0) AND (l_scrap_at_operation_flag=2) AND (l_next_mand_step IN (WIP_CONSTANTS.QUEUE,
2976: WIP_CONSTANTS.RUN))) THEN
2977: l_err_condition := 1;
2978: END IF;
2979: IF ((p_txn_qty > 0) AND (p_to_intraop_step_type > l_next_mand_step)) THEN
2980: l_err_condition := 1;

Line 3135: IF ((p_to_intraop_step_type = WIP_CONSTANTS.SCRAP) OR (l_scrap_qty>0)) THEN

3131: l_stmt_num := 315;
3132: -- Must use entire operation qty as txn qty except for Scrap
3133: -- For Scrap txn qty must be <= operation qty
3134: --move enh added the condition OR (l_scrap_qty>0) to the if statement
3135: IF ((p_to_intraop_step_type = WIP_CONSTANTS.SCRAP) OR (l_scrap_qty>0)) THEN
3136:
3137: if (l_debug = 'Y') then
3138: fnd_file.put_line(fnd_file.log, 'IOP = SCRAP');
3139: end if;

Line 3168: -- IF (((p_to_intraop_step_type = WIP_CONSTANTS.SCRAP) OR (nvl(l_scrap_at_operation_flag, 1)=1))

3164: bug 3571019 additionally we should try to get the scrap account from WCO for both the from op/to op
3165: and then try BD
3166: --bug 3571019 get the scrap account depending on the l_scrap_at_operation_flag
3167: --if intraop scrap or scrap at from or if l_scrap_acc_id is null
3168: -- IF (((p_to_intraop_step_type = WIP_CONSTANTS.SCRAP) OR (nvl(l_scrap_at_operation_flag, 1)=1))
3169: -- OR (l_scrap_acc_id IS NULL)) THEN
3170: --move enh added the IF (l_scrap_acc_id IS NULL) condition
3171: -- IF (l_scrap_acc_id IS NULL) THEN
3172: -- SELECT nvl(scrap_account, -1)

Line 3187: ((p_to_intraop_step_type = WIP_CONSTANTS.SCRAP) OR (nvl(l_scrap_at_operation_flag, 1)=1)))

3183:
3184: --bug 3571019
3185: -- get scrap_account from WCO
3186: IF ((g_aps_wps_profile='Y') AND
3187: ((p_to_intraop_step_type = WIP_CONSTANTS.SCRAP) OR (nvl(l_scrap_at_operation_flag, 1)=1)))
3188: THEN
3189: SELECT WCO.scrap_account
3190: INTO l_scrap_acc_id
3191: FROM WSM_COPY_OPERATIONS WCO

Line 3309: IF ((p_to_intraop_step_type = WIP_CONSTANTS.SCRAP) OR

3305: if l_est_scrap_acc = 1 and l_job_type = 1 then
3306: IF (g_aps_wps_profile='Y') THEN
3307: IF (l_wlmti_scrap_acct_id = -1) THEN
3308:
3309: IF ((p_to_intraop_step_type = WIP_CONSTANTS.SCRAP) OR
3310: (nvl(l_scrap_at_operation_flag, 1)=1))
3311: THEN
3312: BEGIN
3313: SELECT WCO.scrap_account

Line 3548: END IF; --(p_to_intraop_step_type = WIP_CONSTANTS.SCRAP) OR (l_scrap_qty>0)

3544: end if; -- org is scrap acc enabled.
3545:
3546: -- abb H optional scap accounting end
3547:
3548: END IF; --(p_to_intraop_step_type = WIP_CONSTANTS.SCRAP) OR (l_scrap_qty>0)
3549: l_stmt_num := 330;
3550: --move enh commenting out the following IF and adding the new checks for move and scrap qty
3551: /* IF ( (l_converted_txn_qty > l_operation_qty) OR
3552: (l_converted_txn_qty < 0) )

Line 3565: IF ((p_to_intraop_step_type <> WIP_CONSTANTS.SCRAP)

3561: return(x_return_code);
3562: END IF;*/
3563:
3564: --bug 3385113 added nvls
3565: IF ((p_to_intraop_step_type <> WIP_CONSTANTS.SCRAP)
3566: AND (nvl(l_converted_txn_qty, 0)+nvl(l_converted_scrap_qty, 0) <> l_operation_qty)) THEN
3567: x_return_code := 1;
3568:
3569: FND_MESSAGE.SET_NAME('WSM', 'WSM_SCRAP_MOVE_QTY_INCORRECT');

Line 3679: (p_to_intraop_step_type = WIP_CONSTANTS.TOMOVE) )

3675: --NSO Modification by abedajna begin
3676: -- Check if the to op_code is the last op_code in the routing
3677: IF ( (l_op_code = l_end_op_code) AND
3678: (p_to_op_seq_num = l_end_op_seq_num) AND
3679: (p_to_intraop_step_type = WIP_CONSTANTS.TOMOVE) )
3680: THEN
3681:
3682: --bugfix 3632605
3683: if (l_cmp_subinv is NULL) then

Line 3735: (p_to_intraop_step_type = WIP_CONSTANTS.TOMOVE) )

3731:
3732: -- Check if the to dept_id is the dept_id of the last operation in the routing
3733: IF ( (l_to_dept_id = l_end_dept_id) AND
3734: (p_to_op_seq_num = l_end_op_seq_num) AND
3735: (p_to_intraop_step_type = WIP_CONSTANTS.TOMOVE) )
3736: THEN
3737:
3738: --bugfix 3632605
3739: if (l_cmp_subinv is NULL) then

Line 4161: FM_INTRAOPERATION_STEP_TYPE = WIP_CONSTANTS.TOMOVE,

4157:
4158: update wsm_lot_move_txn_interface
4159: set FM_OPERATION_SEQ_NUM = l_cmp_to_op_seq_num,
4160: FM_OPERATION_CODE = l_cmp_to_op_code,
4161: FM_INTRAOPERATION_STEP_TYPE = WIP_CONSTANTS.TOMOVE,
4162: SCRAP_QUANTITY = l_wmt_scrap_qty
4163: where header_id = p_header_id;
4164:
4165: l_converted_scrap_qty := l_wmt_pri_scrap_qty;

Line 4900: --if (l_fm_intraop_step = WIP_CONSTANTS.SCRAP) then

4896:
4897:
4898: l_stmt_num := 450;
4899: -- If we are undoing a scrap operation, then get the scrap account from WLMTI
4900: --if (l_fm_intraop_step = WIP_CONSTANTS.SCRAP) then
4901: --move enh added the condition nvl(l_scrap_qty, 0) <> 0
4902: if ((l_to_intraop_step = WIP_CONSTANTS.SCRAP) OR (nvl(l_converted_scrap_qty, 0) <> 0)) then -- Changed to fix bug #2083671
4903:
4904: select nvl(scrap_account_id,-1)

Line 4902: if ((l_to_intraop_step = WIP_CONSTANTS.SCRAP) OR (nvl(l_converted_scrap_qty, 0) <> 0)) then -- Changed to fix bug #2083671

4898: l_stmt_num := 450;
4899: -- If we are undoing a scrap operation, then get the scrap account from WLMTI
4900: --if (l_fm_intraop_step = WIP_CONSTANTS.SCRAP) then
4901: --move enh added the condition nvl(l_scrap_qty, 0) <> 0
4902: if ((l_to_intraop_step = WIP_CONSTANTS.SCRAP) OR (nvl(l_converted_scrap_qty, 0) <> 0)) then -- Changed to fix bug #2083671
4903:
4904: select nvl(scrap_account_id,-1)
4905: into l_wlmti_scrap_acct_id
4906: from wsm_lot_move_txn_interface

Line 5023: IF (l_to_intraop_step = WIP_CONSTANTS.SCRAP) THEN

5019: l_stmt_num := 480;
5020: /* Call to make sure that the bwd move is ok if there are lot transactions */
5021: --move enh 115.136 changed the l_fm_intraop_step to l_to_intraop_step
5022:
5023: IF (l_to_intraop_step = WIP_CONSTANTS.SCRAP) THEN
5024: IF (l_converted_txn_qty > 0) THEN
5025: l_bk_move_chk_qty := l_converted_txn_qty;
5026: ELSE
5027: l_bk_move_chk_qty := l_converted_scrap_qty;

Line 6140: AND status = g_running -- WIP_CONSTANTS.RUNNING --Added condition to fix bug #1815584

6136: scrap_quantity,
6137: serial_start_flag -- ST : Serial Support Project --
6138: FROM wsm_lot_move_txn_interface
6139: WHERE group_id = p_group_id
6140: AND status = g_running -- WIP_CONSTANTS.RUNNING --Added condition to fix bug #1815584
6141: ORDER BY transaction_date, organization_id, wip_entity_id, processing_order;
6142:
6143: --move enh To be used when we switch to the new logging scheme
6144: /* l_current_runtime_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

Line 6309: wlmti.status = WIP_CONSTANTS.RUNNING,

6305: /* LOTATTR: Changed the following so that transaction_id is
6306: updated ONLY if it wasn't populated by the user */
6307: SET transaction_id=nvl(transaction_id,wip_transactions_s.nextval),
6308: wlmti.error = NULL,
6309: wlmti.status = WIP_CONSTANTS.RUNNING,
6310: wlmti.last_update_date = SYSDATE,
6311: wlmti.last_updated_by = decode(nvl(g_user_id, -1),
6312: -1, wlmti.last_updated_by,
6313: g_user_id),

Line 6321: AND wlmti.status = WIP_CONSTANTS.PENDING

6317: wlmti.request_id = g_request_id,
6318: wlmti.program_id = g_program_id,
6319: wlmti.program_application_id = g_program_application_id
6320: WHERE group_id = p_group_id
6321: AND wlmti.status = WIP_CONSTANTS.PENDING
6322: AND wlmti.transaction_date <= SYSDATE+1;
6323:
6324: IF (SQL%ROWCOUNT = 0) THEN
6325: FND_MESSAGE.SET_NAME('WSM', 'WSM_UPDATE_INVALID');

Line 6782: IF ((l_transaction_type = WIP_CONSTANTS.MOVE_TXN) AND ((l_primary_quantity/(l_converted_scrap_qty+l_primary_quantity)) < nvl(p_low_yield_trigger_limit, -1))) THEN

6778: l_stmt_num := 110.104;
6779: --bug 5490644 perform this check only if the txn is move txn
6780: --bug 5185512 Changed '<=' to '<' below
6781: --IF ((l_primary_quantity/(l_converted_scrap_qty+l_primary_quantity)) <= nvl(p_low_yield_trigger_limit, -1)) THEN
6782: IF ((l_transaction_type = WIP_CONSTANTS.MOVE_TXN) AND ((l_primary_quantity/(l_converted_scrap_qty+l_primary_quantity)) < nvl(p_low_yield_trigger_limit, -1))) THEN
6783: l_stmt_num := 253.14;
6784: l_put_job_on_hold := 1;
6785: /*************************No need to throw error************************************
6786: l_msg_tokens.delete;

Line 6882: IF ((l_transaction_type = WIP_CONSTANTS.MOVE_TXN) AND ((l_max_acceptable_scrap_qty IS NOT NULL) AND (nvl(p_scrap_code_qty_tbls(l_header_id)(i), 0) > l_max_acceptable_scrap_qty)))

6878: AND BSOSC.scrap_code = p_scrap_codes_tbls(l_header_id)(i);
6879:
6880: l_stmt_num := 110.7;
6881: --bug 5490644 perform this check only if the txn is move txn
6882: IF ((l_transaction_type = WIP_CONSTANTS.MOVE_TXN) AND ((l_max_acceptable_scrap_qty IS NOT NULL) AND (nvl(p_scrap_code_qty_tbls(l_header_id)(i), 0) > l_max_acceptable_scrap_qty)))
6883: THEN
6884: l_stmt_num := 253.14;
6885: l_put_job_on_hold := 1;
6886: /*************************No need to throw error************************************

Line 8015: (l_to_intraoperation_step_type = WIP_CONSTANTS.SCRAP)

8011: ( (l_converted_scrap_qty = l_available_qty)
8012: OR
8013: ( (l_primary_quantity = l_available_qty)
8014: AND
8015: (l_to_intraoperation_step_type = WIP_CONSTANTS.SCRAP)
8016: )
8017: )
8018: )
8019: OR

Line 8354: 'move out oa page', WIP_CONSTANTS.MOVE_PROC,

8350: l_wmti_group_id), -- GROUP_ID
8351: SOURCE_CODE,
8352: SOURCE_LINE_ID,
8353: decode(SOURCE_CODE,
8354: 'move out oa page', WIP_CONSTANTS.MOVE_PROC,
8355: 'undo oa page', WIP_CONSTANTS.MOVE_PROC,
8356: g_move_val), --1 Process_Phase, --2721366: Replaced 1 with constant
8357: g_running, --1 Process_Status , --2721366: Replaced 1 with constant
8358: g_move_txn,

Line 8355: 'undo oa page', WIP_CONSTANTS.MOVE_PROC,

8351: SOURCE_CODE,
8352: SOURCE_LINE_ID,
8353: decode(SOURCE_CODE,
8354: 'move out oa page', WIP_CONSTANTS.MOVE_PROC,
8355: 'undo oa page', WIP_CONSTANTS.MOVE_PROC,
8356: g_move_val), --1 Process_Phase, --2721366: Replaced 1 with constant
8357: g_running, --1 Process_Status , --2721366: Replaced 1 with constant
8358: g_move_txn,
8359: ORGANIZATION_ID,

Line 8590: 'move in oa page', WIP_CONSTANTS.MOVE_PROC,

8586: l_wmti_group_id), -- GROUP_ID
8587: SOURCE_CODE,
8588: SOURCE_LINE_ID,
8589: decode(SOURCE_CODE,
8590: 'move in oa page', WIP_CONSTANTS.MOVE_PROC,
8591: 'move out oa page', WIP_CONSTANTS.MOVE_PROC,
8592: 'move to next op oa page', WIP_CONSTANTS.MOVE_PROC,
8593: 'jump oa page', WIP_CONSTANTS.MOVE_PROC,
8594: 'undo oa page', WIP_CONSTANTS.MOVE_PROC,

Line 8591: 'move out oa page', WIP_CONSTANTS.MOVE_PROC,

8587: SOURCE_CODE,
8588: SOURCE_LINE_ID,
8589: decode(SOURCE_CODE,
8590: 'move in oa page', WIP_CONSTANTS.MOVE_PROC,
8591: 'move out oa page', WIP_CONSTANTS.MOVE_PROC,
8592: 'move to next op oa page', WIP_CONSTANTS.MOVE_PROC,
8593: 'jump oa page', WIP_CONSTANTS.MOVE_PROC,
8594: 'undo oa page', WIP_CONSTANTS.MOVE_PROC,
8595: g_move_val), --1 Process_Phase, --2721366: Replaced 1 with constant

Line 8592: 'move to next op oa page', WIP_CONSTANTS.MOVE_PROC,

8588: SOURCE_LINE_ID,
8589: decode(SOURCE_CODE,
8590: 'move in oa page', WIP_CONSTANTS.MOVE_PROC,
8591: 'move out oa page', WIP_CONSTANTS.MOVE_PROC,
8592: 'move to next op oa page', WIP_CONSTANTS.MOVE_PROC,
8593: 'jump oa page', WIP_CONSTANTS.MOVE_PROC,
8594: 'undo oa page', WIP_CONSTANTS.MOVE_PROC,
8595: g_move_val), --1 Process_Phase, --2721366: Replaced 1 with constant
8596: g_running, --1 Process_Status , --2721366: Replaced 1 with constant

Line 8593: 'jump oa page', WIP_CONSTANTS.MOVE_PROC,

8589: decode(SOURCE_CODE,
8590: 'move in oa page', WIP_CONSTANTS.MOVE_PROC,
8591: 'move out oa page', WIP_CONSTANTS.MOVE_PROC,
8592: 'move to next op oa page', WIP_CONSTANTS.MOVE_PROC,
8593: 'jump oa page', WIP_CONSTANTS.MOVE_PROC,
8594: 'undo oa page', WIP_CONSTANTS.MOVE_PROC,
8595: g_move_val), --1 Process_Phase, --2721366: Replaced 1 with constant
8596: g_running, --1 Process_Status , --2721366: Replaced 1 with constant
8597: decode(TRANSACTION_TYPE,4, 1, TRANSACTION_TYPE),

Line 8594: 'undo oa page', WIP_CONSTANTS.MOVE_PROC,

8590: 'move in oa page', WIP_CONSTANTS.MOVE_PROC,
8591: 'move out oa page', WIP_CONSTANTS.MOVE_PROC,
8592: 'move to next op oa page', WIP_CONSTANTS.MOVE_PROC,
8593: 'jump oa page', WIP_CONSTANTS.MOVE_PROC,
8594: 'undo oa page', WIP_CONSTANTS.MOVE_PROC,
8595: g_move_val), --1 Process_Phase, --2721366: Replaced 1 with constant
8596: g_running, --1 Process_Status , --2721366: Replaced 1 with constant
8597: decode(TRANSACTION_TYPE,4, 1, TRANSACTION_TYPE),
8598: ORGANIZATION_ID,

Line 8625: WIP_CONSTANTS.SCRAP, SCRAP_ACCOUNT_ID,

8621: PRIMARY_QUANTITY,
8622: PRIMARY_UOM ,
8623: --bug 5092117 added decode statements
8624: decode(TO_INTRAOPERATION_STEP_TYPE,
8625: WIP_CONSTANTS.SCRAP, SCRAP_ACCOUNT_ID,
8626: decode(FM_INTRAOPERATION_STEP_TYPE,
8627: WIP_CONSTANTS.SCRAP, SCRAP_ACCOUNT_ID,
8628: NULL)
8629: ),

Line 8627: WIP_CONSTANTS.SCRAP, SCRAP_ACCOUNT_ID,

8623: --bug 5092117 added decode statements
8624: decode(TO_INTRAOPERATION_STEP_TYPE,
8625: WIP_CONSTANTS.SCRAP, SCRAP_ACCOUNT_ID,
8626: decode(FM_INTRAOPERATION_STEP_TYPE,
8627: WIP_CONSTANTS.SCRAP, SCRAP_ACCOUNT_ID,
8628: NULL)
8629: ),
8630: REASON_ID,
8631: REASON_NAME,

Line 8850: --move enh 115.135 changed WIP_CONSTANTS.MOVE_TXN to global variable after perf check

8846: END IF;
8847: END IF;
8848:
8849: l_stmt_num := 250;
8850: --move enh 115.135 changed WIP_CONSTANTS.MOVE_TXN to global variable after perf check
8851: IF ((l_transaction_type = g_move_txn) AND (l_fm_op_seq_num <> l_max_op_seq)
8852: and (g_aps_wps_profile='Y')) THEN
8853: IF (l_scrap_at_operation_flag = 2) THEN
8854: --bug 3385113 add nvl

Line 8919: IF (l_mtl_txn_profile = WIP_CONSTANTS.FORM_LEVEL) THEN

8915: --MTL_TRANS_PROC 1 online, 2 immediate concurrent, 3 background, 4 form level
8916:
8917: l_mtl_txn_profile := FND_PROFILE.value('TRANSACTION_PROCESS_MODE');
8918:
8919: IF (l_mtl_txn_profile = WIP_CONSTANTS.FORM_LEVEL) THEN
8920: --l_mtl_txn_profile := FND_PROFILE.value('WIP_MOVE_TRANSACTION');
8921: l_mtl_txn_profile := FND_PROFILE.value('WIP_SHOP_FLOOR_MTL_TRANSACTION');
8922: END IF;
8923:

Line 9028: p_procPhase => WIP_CONSTANTS.MOVE_PROC,

9024:
9025: --bug 5446252 replace l_scrap_txn_id with l_mes_scrap_txn_id
9026: wip_movProc_grp.processInterface(
9027: p_movTxnID => l_mes_scrap_txn_id,
9028: p_procPhase => WIP_CONSTANTS.MOVE_PROC,
9029: p_txnHdrID => p_mtl_txn_hdr_id,
9030: p_mtlMode => l_mtl_txn_profile,
9031: p_cplTxnID => null,
9032: p_commit => null,

Line 9079: IF ((l_primary_quantity > 0) and (l_to_intraoperation_step_type <> WIP_CONSTANTS.SCRAP)

9075: INTO l_cpl_txn_id
9076: FROM dual;
9077: END IF;
9078:
9079: IF ((l_primary_quantity > 0) and (l_to_intraoperation_step_type <> WIP_CONSTANTS.SCRAP)
9080: and (l_fm_intraoperation_step_type <> WIP_CONSTANTS.SCRAP)) THEN
9081: l_stmt_num := 252;
9082: IF (G_LOG_LEVEL_STATEMENT >= l_log_level) THEN
9083: l_msg_tokens.delete;

Line 9080: and (l_fm_intraoperation_step_type <> WIP_CONSTANTS.SCRAP)) THEN

9076: FROM dual;
9077: END IF;
9078:
9079: IF ((l_primary_quantity > 0) and (l_to_intraoperation_step_type <> WIP_CONSTANTS.SCRAP)
9080: and (l_fm_intraoperation_step_type <> WIP_CONSTANTS.SCRAP)) THEN
9081: l_stmt_num := 252;
9082: IF (G_LOG_LEVEL_STATEMENT >= l_log_level) THEN
9083: l_msg_tokens.delete;
9084: WSM_log_PVT.logMessage (

Line 9096: p_procPhase => WIP_CONSTANTS.MOVE_PROC,

9092: END IF;
9093:
9094: wip_movProc_grp.processInterface(
9095: p_movTxnID => l_transaction_id,
9096: p_procPhase => WIP_CONSTANTS.MOVE_PROC,
9097: p_txnHdrID => p_mtl_txn_hdr_id,
9098: p_mtlMode => l_mtl_txn_profile,
9099: p_cplTxnID => l_cpl_txn_id,
9100: p_commit => null,

Line 9126: --l_mtl_txn_profile IN (WIP_CONSTANTS.BACKGROUND,

9122: );
9123: END IF;
9124: raise e_proc_exception;
9125: END IF;
9126: --l_mtl_txn_profile IN (WIP_CONSTANTS.BACKGROUND,
9127: -- WIP_CONSTANTS.IMMED_CONC)
9128:
9129: x_wip_move_api_sucess_msg := fnd_msg_pub.get;
9130: IF (G_LOG_LEVEL_STATEMENT >= l_log_level) THEN

Line 9127: -- WIP_CONSTANTS.IMMED_CONC)

9123: END IF;
9124: raise e_proc_exception;
9125: END IF;
9126: --l_mtl_txn_profile IN (WIP_CONSTANTS.BACKGROUND,
9127: -- WIP_CONSTANTS.IMMED_CONC)
9128:
9129: x_wip_move_api_sucess_msg := fnd_msg_pub.get;
9130: IF (G_LOG_LEVEL_STATEMENT >= l_log_level) THEN
9131: IF (l_return_status = 'S') THEN

Line 9571: IF (l_to_intraoperation_step_type = WIP_CONSTANTS.QUEUE) THEN

9567: -- END;
9568: --End of changes for bug 5480482
9569:
9570: --bug 5057593
9571: IF (l_to_intraoperation_step_type = WIP_CONSTANTS.QUEUE) THEN
9572: IF ((p_sec_uom_code_tbls IS NOT NULL) AND (p_sec_uom_code_tbls.exists(l_header_id))
9573: AND (p_sec_uom_code_tbls(l_header_id).count > 0))
9574: THEN
9575: FORALL i in p_sec_uom_code_tbls(l_header_id).FIRST..p_sec_uom_code_tbls(l_header_id).LAST

Line 9582: END IF; --(l_to_intraoperation_step_type = WIP_CONSTANTS.QUEUE)

9578: WHERE wip_entity_id = l_wip_entity_id
9579: AND operation_seq_num = l_job_to_op_seq_num
9580: AND uom_code = p_sec_uom_code_tbls(l_header_id)(i);
9581: END IF; --IF ((p_sec_uom_code_tbls IS NOT NULL)
9582: END IF; --(l_to_intraoperation_step_type = WIP_CONSTANTS.QUEUE)
9583: --bug 5057593 end
9584: END IF; --ELSIF (nvl(p_source_code, 'interface') = 'move out oa page') THEN
9585: --Bug 5480482:WDJ.actual_start_date should be update only if this is
9586: --the first move txn.

Line 9981: SET STATUS_TYPE = WIP_CONSTANTS.HOLD,

9977: END IF; --IF nvl(p_bonus_quantity, 0) > 0
9978:
9979: IF (l_put_job_on_hold = 1) THEN
9980: UPDATE WIP_DISCRETE_JOBS
9981: SET STATUS_TYPE = WIP_CONSTANTS.HOLD,
9982: LAST_UPDATE_DATE = sysdate,
9983: LAST_UPDATED_BY = g_user_id
9984: WHERE wip_entity_id = l_wip_entity_id;
9985: END IF;

Line 11009: -- and status = WIP_CONSTANTS.COMPLETED

11005: -- DELETE wsm_serial_txn_interface
11006: -- WHERE header_id in (SELECT header_id
11007: -- from wsm_lot_move_txn_interface wlmti
11008: -- WHERE group_id = l_wmti_group_id
11009: -- and status = WIP_CONSTANTS.COMPLETED
11010: -- AND transaction_date <= decode(l_del_profile_value, NULL,
11011: -- transaction_date-1, SYSDATE-l_del_profile_value)
11012: -- )
11013: -- AND action_flag in (1,2,3,4,5,6)

Line 11023: -- and wlmti.status = WIP_CONSTANTS.COMPLETED)

11019: -- from wip_move_transactions wmt,
11020: -- wsm_lot_move_txn_interface wlmti
11021: -- where wlmti.group_id = l_wmti_group_id
11022: -- and wlmti.wip_entity_id = wmt.wip_entity_id
11023: -- and wlmti.status = WIP_CONSTANTS.COMPLETED)
11024: -- AND transaction_type_id = 5;
11025: -- ST : Serial Support Project --
11026:
11027: DELETE wsm_lot_move_txn_interface wlmti

Line 11028: WHERE status = WIP_CONSTANTS.COMPLETED

11024: -- AND transaction_type_id = 5;
11025: -- ST : Serial Support Project --
11026:
11027: DELETE wsm_lot_move_txn_interface wlmti
11028: WHERE status = WIP_CONSTANTS.COMPLETED
11029: AND transaction_date <= decode(l_del_profile_value, NULL,
11030: transaction_date-1, SYSDATE-l_del_profile_value)
11031: RETURNING header_id BULK COLLECT INTO l_header_id_tbl;
11032:

Line 11551: SET MTL.wip_entity_type = WIP_CONSTANTS.LOTBASED,

11547: IF (l_mti_rows > 0) THEN
11548:
11549:
11550: UPDATE MTL_TRANSACTIONS_INTERFACE MTL
11551: SET MTL.wip_entity_type = WIP_CONSTANTS.LOTBASED,
11552: --bug 5584140 operation_seq_num is already stamped in the UI and there could be multiple
11553: --operation seq nums so don't overwrite. Get department_id for each operation
11554: --operation_seq_num = p_fm_operation_seq_num,
11555: --department_id = p_fm_department_id

Line 11813: , WIP_CONSTANTS.PENDING --STATUS

11809: , fnd_global.user_name--CREATED_BY_NAME
11810: , g_login_id --LAST_UPDATE_LOGIN
11811: , WIP_TRANSACTIONS_S.NEXTVAL --p_group_id --GROUP_ID
11812: , p_source_code --source_code
11813: , WIP_CONSTANTS.PENDING --STATUS
11814: , p_TRANSACTION_TYPE
11815: , p_ORGANIZATION_ID
11816: , null --!! ORGANIZATION_CODE
11817: , p_WIP_ENTITY_ID

Line 11819: , WIP_CONSTANTS.LOTBASED --!!ENTITY_TYPE

11815: , p_ORGANIZATION_ID
11816: , null --!! ORGANIZATION_CODE
11817: , p_WIP_ENTITY_ID
11818: , p_WIP_ENTITY_NAME
11819: , WIP_CONSTANTS.LOTBASED --!!ENTITY_TYPE
11820: , null --PRIMARY_ITEM_ID
11821: , nvl(p_TRANSACTION_DATE, sysdate)
11822: , p_FM_OPERATION_SEQ_NUM
11823: , p_FM_OPERATION_CODE

Line 12521: x_transaction_type := WIP_CONSTANTS.COMP_TXN;

12517: --!!hardcode
12518: -- x_quality_region := 'F';
12519:
12520: IF (l_end_routing_operation = p_routing_operation) THEN
12521: x_transaction_type := WIP_CONSTANTS.COMP_TXN;
12522: x_show_next_op_choice := 0;
12523: x_show_next_op := 0;
12524: x_show_next_op_by_default := 2;
12525: ELSIF (p_routing_operation IS NULL) THEN

Line 12526: x_transaction_type := WIP_CONSTANTS.MOVE_TXN;

12522: x_show_next_op_choice := 0;
12523: x_show_next_op := 0;
12524: x_show_next_op_by_default := 2;
12525: ELSIF (p_routing_operation IS NULL) THEN
12526: x_transaction_type := WIP_CONSTANTS.MOVE_TXN;
12527: x_show_next_op_choice := 0;
12528: x_show_next_op := 0;
12529: x_show_next_op_by_default := 2;
12530: ELSE

Line 12531: x_transaction_type := WIP_CONSTANTS.MOVE_TXN;

12527: x_show_next_op_choice := 0;
12528: x_show_next_op := 0;
12529: x_show_next_op_by_default := 2;
12530: ELSE
12531: x_transaction_type := WIP_CONSTANTS.MOVE_TXN;
12532: END IF;
12533:
12534: l_stmt_num := 140;
12535: IF x_employee_id IS NULL THEN