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.WSMPVLDT dependencies on WSMPCNST

Line 100: -- (WSMPCNST.BONUS))

96: -- wsm_split_merge_txn_interface txn
97: -- WHERE rj.header_id = p_header_id -- WLTEnh Add
98: -- AND txn.header_id = rj.header_id
99: -- AND (txn.transaction_type_id in
100: -- (WSMPCNST.BONUS))
101: -- (WSMPCNST.UPDATE_ASSEMBLY,
102: -- WSMPCNST.BONUS,
103: -- WSMPCNST.UPDATE_ROUTING)
104: -- --SpUA begin

Line 101: -- (WSMPCNST.UPDATE_ASSEMBLY,

97: -- WHERE rj.header_id = p_header_id -- WLTEnh Add
98: -- AND txn.header_id = rj.header_id
99: -- AND (txn.transaction_type_id in
100: -- (WSMPCNST.BONUS))
101: -- (WSMPCNST.UPDATE_ASSEMBLY,
102: -- WSMPCNST.BONUS,
103: -- WSMPCNST.UPDATE_ROUTING)
104: -- --SpUA begin
105: -- OR (txn.transaction_type_id in (WSMPCNST.SPLIT) AND rj.split_has_update_assy = 1))

Line 102: -- WSMPCNST.BONUS,

98: -- AND txn.header_id = rj.header_id
99: -- AND (txn.transaction_type_id in
100: -- (WSMPCNST.BONUS))
101: -- (WSMPCNST.UPDATE_ASSEMBLY,
102: -- WSMPCNST.BONUS,
103: -- WSMPCNST.UPDATE_ROUTING)
104: -- --SpUA begin
105: -- OR (txn.transaction_type_id in (WSMPCNST.SPLIT) AND rj.split_has_update_assy = 1))
106: -- --SpUA end

Line 103: -- WSMPCNST.UPDATE_ROUTING)

99: -- AND (txn.transaction_type_id in
100: -- (WSMPCNST.BONUS))
101: -- (WSMPCNST.UPDATE_ASSEMBLY,
102: -- WSMPCNST.BONUS,
103: -- WSMPCNST.UPDATE_ROUTING)
104: -- --SpUA begin
105: -- OR (txn.transaction_type_id in (WSMPCNST.SPLIT) AND rj.split_has_update_assy = 1))
106: -- --SpUA end
107: -- AND rj.job_type = WIP_CONSTANTS.STANDARD --VJ: Added for NSLBJ--

Line 105: -- OR (txn.transaction_type_id in (WSMPCNST.SPLIT) AND rj.split_has_update_assy = 1))

101: -- (WSMPCNST.UPDATE_ASSEMBLY,
102: -- WSMPCNST.BONUS,
103: -- WSMPCNST.UPDATE_ROUTING)
104: -- --SpUA begin
105: -- OR (txn.transaction_type_id in (WSMPCNST.SPLIT) AND rj.split_has_update_assy = 1))
106: -- --SpUA end
107: -- AND rj.job_type = WIP_CONSTANTS.STANDARD --VJ: Added for NSLBJ--
108: -- AND rj.internal_group_id = WSMPLOAD.G_GROUP_ID
109: -- AND rj.process_status = WIP_CONSTANTS.RUNNING

Line 139: AND txn.transaction_type_id = WSMPCNST.BONUS

135: FROM wsm_resulting_jobs_interface rj,
136: wsm_split_merge_txn_interface txn
137: WHERE txn.header_id = rj.header_id
138: AND rj.header_id = p_header_id -- WLTEnh Add
139: AND txn.transaction_type_id = WSMPCNST.BONUS
140: AND rj.internal_group_id = WSMPLOAD.G_GROUP_ID
141: AND rj.process_status = WIP_CONSTANTS.RUNNING
142: ORDER BY TXN.TRANSACTION_DATE;
143:

Line 175: (WSMPCNST.SPLIT,

171: WHERE rj.net_quantity is NULL
172: AND rj.header_id = p_header_id
173: AND txn.header_id = rj.header_id
174: AND txn.transaction_type_id in
175: (WSMPCNST.SPLIT,
176: WSMPCNST.MERGE,
177: WSMPCNST.BONUS,
178: WSMPCNST.UPDATE_QUANTITY)
179: AND rj.internal_group_id = WSMPLOAD.G_GROUP_ID

Line 176: WSMPCNST.MERGE,

172: AND rj.header_id = p_header_id
173: AND txn.header_id = rj.header_id
174: AND txn.transaction_type_id in
175: (WSMPCNST.SPLIT,
176: WSMPCNST.MERGE,
177: WSMPCNST.BONUS,
178: WSMPCNST.UPDATE_QUANTITY)
179: AND rj.internal_group_id = WSMPLOAD.G_GROUP_ID
180: AND rj.process_status = WIP_CONSTANTS.RUNNING;

Line 177: WSMPCNST.BONUS,

173: AND txn.header_id = rj.header_id
174: AND txn.transaction_type_id in
175: (WSMPCNST.SPLIT,
176: WSMPCNST.MERGE,
177: WSMPCNST.BONUS,
178: WSMPCNST.UPDATE_QUANTITY)
179: AND rj.internal_group_id = WSMPLOAD.G_GROUP_ID
180: AND rj.process_status = WIP_CONSTANTS.RUNNING;
181:

Line 178: WSMPCNST.UPDATE_QUANTITY)

174: AND txn.transaction_type_id in
175: (WSMPCNST.SPLIT,
176: WSMPCNST.MERGE,
177: WSMPCNST.BONUS,
178: WSMPCNST.UPDATE_QUANTITY)
179: AND rj.internal_group_id = WSMPLOAD.G_GROUP_ID
180: AND rj.process_status = WIP_CONSTANTS.RUNNING;
181:
182:

Line 193: (WSMPCNST.SPLIT,

189: rj.coproducts_supply NOT IN (1,2))
190: AND txn.header_id = rj.header_id
191: AND rj.header_id = p_header_id
192: AND txn.transaction_type_id in
193: (WSMPCNST.SPLIT,
194: WSMPCNST.MERGE,
195: WSMPCNST.BONUS)
196: AND rj.internal_group_id = WSMPLOAD.G_GROUP_ID
197: AND rj.process_status = WIP_CONSTANTS.RUNNING;

Line 194: WSMPCNST.MERGE,

190: AND txn.header_id = rj.header_id
191: AND rj.header_id = p_header_id
192: AND txn.transaction_type_id in
193: (WSMPCNST.SPLIT,
194: WSMPCNST.MERGE,
195: WSMPCNST.BONUS)
196: AND rj.internal_group_id = WSMPLOAD.G_GROUP_ID
197: AND rj.process_status = WIP_CONSTANTS.RUNNING;
198:

Line 195: WSMPCNST.BONUS)

191: AND rj.header_id = p_header_id
192: AND txn.transaction_type_id in
193: (WSMPCNST.SPLIT,
194: WSMPCNST.MERGE,
195: WSMPCNST.BONUS)
196: AND rj.internal_group_id = WSMPLOAD.G_GROUP_ID
197: AND rj.process_status = WIP_CONSTANTS.RUNNING;
198:
199: /*BA#1732786*/

Line 301: -- (WSMPCNST.BONUS)))

297: -- AND EXISTS ( SELECT null
298: -- FROM wsm_split_merge_txn_interface txn
299: -- WHERE txn.header_id = rj.header_id
300: -- AND (txn.transaction_type_id in
301: -- (WSMPCNST.BONUS)))
302: -- (WSMPCNST.UPDATE_ASSEMBLY,
303: -- WSMPCNST.BONUS,
304: -- WSMPCNST.UPDATE_ROUTING)
305: -- --SpUA begin

Line 302: -- (WSMPCNST.UPDATE_ASSEMBLY,

298: -- FROM wsm_split_merge_txn_interface txn
299: -- WHERE txn.header_id = rj.header_id
300: -- AND (txn.transaction_type_id in
301: -- (WSMPCNST.BONUS)))
302: -- (WSMPCNST.UPDATE_ASSEMBLY,
303: -- WSMPCNST.BONUS,
304: -- WSMPCNST.UPDATE_ROUTING)
305: -- --SpUA begin
306: -- OR (txn.transaction_type_id in (WSMPCNST.SPLIT) AND

Line 303: -- WSMPCNST.BONUS,

299: -- WHERE txn.header_id = rj.header_id
300: -- AND (txn.transaction_type_id in
301: -- (WSMPCNST.BONUS)))
302: -- (WSMPCNST.UPDATE_ASSEMBLY,
303: -- WSMPCNST.BONUS,
304: -- WSMPCNST.UPDATE_ROUTING)
305: -- --SpUA begin
306: -- OR (txn.transaction_type_id in (WSMPCNST.SPLIT) AND
307: -- rj.split_has_update_assy = 1)))

Line 304: -- WSMPCNST.UPDATE_ROUTING)

300: -- AND (txn.transaction_type_id in
301: -- (WSMPCNST.BONUS)))
302: -- (WSMPCNST.UPDATE_ASSEMBLY,
303: -- WSMPCNST.BONUS,
304: -- WSMPCNST.UPDATE_ROUTING)
305: -- --SpUA begin
306: -- OR (txn.transaction_type_id in (WSMPCNST.SPLIT) AND
307: -- rj.split_has_update_assy = 1)))
308: -- --SpUA end

Line 306: -- OR (txn.transaction_type_id in (WSMPCNST.SPLIT) AND

302: -- (WSMPCNST.UPDATE_ASSEMBLY,
303: -- WSMPCNST.BONUS,
304: -- WSMPCNST.UPDATE_ROUTING)
305: -- --SpUA begin
306: -- OR (txn.transaction_type_id in (WSMPCNST.SPLIT) AND
307: -- rj.split_has_update_assy = 1)))
308: -- --SpUA end
309: -- AND rj.rowid = c_no_class_code_rj_rec.rj_rowid --SpUA Add
310: -- AND rj.internal_group_id = WSMPLOAD.G_GROUP_ID

Line 316: IF c_no_class_code_rj_rec.txn_type_id = WSMPCNST.BONUS and c_no_class_code_rj_rec.class_code IS NULL THEN /* ST bug fix 3150692 Added check for the txn type */

312:
313: -- Changed to fix bug #3150692 --
314: l_stmt_num := 3;
315: /* ST bug fix 3150692 review comments : Move the class code check to the IF condition */
316: IF c_no_class_code_rj_rec.txn_type_id = WSMPCNST.BONUS and c_no_class_code_rj_rec.class_code IS NULL THEN /* ST bug fix 3150692 Added check for the txn type */
317:
318: UPDATE wsm_resulting_jobs_interface rj
319: SET class_code = l_class_code
320: WHERE rj.header_id = c_no_class_code_rj_rec.header_id

Line 354: IF c_no_class_code_rj_rec.txn_type_id = WSMPCNST.BONUS THEN

350: l_stmt_num := 4; --this l_stmt_num was 15 before
351: l_err_occurred := 1; --VJ: Added for NSLBJ--
352:
353: /* ST bug fix 3150692 review comments : Added this check */
354: IF c_no_class_code_rj_rec.txn_type_id = WSMPCNST.BONUS THEN
355: UPDATE wsm_resulting_jobs_interface wrji
356: SET wrji.error_message = l_fnd_generic_err_msg
357: WHERE wrji.class_code is null
358: AND wrji.header_id = c_no_class_code_rj_rec.header_id

Line 366: (WSMPCNST.BONUS)))

362: FROM wsm_split_merge_txn_interface txn
363: WHERE txn.header_id = wrji.header_id
364: AND (txn.transaction_type_id in
365: -- Start : Fix for bug #3150692 --
366: (WSMPCNST.BONUS)))
367: -- (WSMPCNST.UPDATE_ASSEMBLY,
368: -- WSMPCNST.BONUS,
369: -- WSMPCNST.UPDATE_ROUTING)
370: -- --SpUA begin

Line 367: -- (WSMPCNST.UPDATE_ASSEMBLY,

363: WHERE txn.header_id = wrji.header_id
364: AND (txn.transaction_type_id in
365: -- Start : Fix for bug #3150692 --
366: (WSMPCNST.BONUS)))
367: -- (WSMPCNST.UPDATE_ASSEMBLY,
368: -- WSMPCNST.BONUS,
369: -- WSMPCNST.UPDATE_ROUTING)
370: -- --SpUA begin
371: -- OR (txn.transaction_type_id in (WSMPCNST.SPLIT) AND

Line 368: -- WSMPCNST.BONUS,

364: AND (txn.transaction_type_id in
365: -- Start : Fix for bug #3150692 --
366: (WSMPCNST.BONUS)))
367: -- (WSMPCNST.UPDATE_ASSEMBLY,
368: -- WSMPCNST.BONUS,
369: -- WSMPCNST.UPDATE_ROUTING)
370: -- --SpUA begin
371: -- OR (txn.transaction_type_id in (WSMPCNST.SPLIT) AND
372: -- wrji.split_has_update_assy = 1)))

Line 369: -- WSMPCNST.UPDATE_ROUTING)

365: -- Start : Fix for bug #3150692 --
366: (WSMPCNST.BONUS)))
367: -- (WSMPCNST.UPDATE_ASSEMBLY,
368: -- WSMPCNST.BONUS,
369: -- WSMPCNST.UPDATE_ROUTING)
370: -- --SpUA begin
371: -- OR (txn.transaction_type_id in (WSMPCNST.SPLIT) AND
372: -- wrji.split_has_update_assy = 1)))
373: -- --SpUA end

Line 371: -- OR (txn.transaction_type_id in (WSMPCNST.SPLIT) AND

367: -- (WSMPCNST.UPDATE_ASSEMBLY,
368: -- WSMPCNST.BONUS,
369: -- WSMPCNST.UPDATE_ROUTING)
370: -- --SpUA begin
371: -- OR (txn.transaction_type_id in (WSMPCNST.SPLIT) AND
372: -- wrji.split_has_update_assy = 1)))
373: -- --SpUA end
374: -- End : Fix for bug #3150692 --
375:

Line 397: END IF; /* ST bug fix 3150692 review comments : c_no_class_code_rj_rec.txn_type = WSMPCNST.BONUS end */

393: x_err_msg => p_err_msg);
394: IF(p_err_num <> 0) THEN
395: raise e_proc_error;
396: END IF;
397: END IF; /* ST bug fix 3150692 review comments : c_no_class_code_rj_rec.txn_type = WSMPCNST.BONUS end */
398: END IF;
399: END LOOP;
400: --abb H Optional Scrap addition begin
401: --validation of existance of WAC scrap accounts

Line 472: (WSMPCNST.BONUS)));

468: FROM wsm_split_merge_txn_interface txn2
469: WHERE txn2.header_id = rj.header_id
470: AND (txn2.transaction_type_id not in
471: -- Start : Fix for bug #3150692 --
472: (WSMPCNST.BONUS)));
473: -- (WSMPCNST.UPDATE_ASSEMBLY,
474: -- WSMPCNST.BONUS,
475: -- WSMPCNST.UPDATE_ROUTING)
476: -- --SpUA begin

Line 473: -- (WSMPCNST.UPDATE_ASSEMBLY,

469: WHERE txn2.header_id = rj.header_id
470: AND (txn2.transaction_type_id not in
471: -- Start : Fix for bug #3150692 --
472: (WSMPCNST.BONUS)));
473: -- (WSMPCNST.UPDATE_ASSEMBLY,
474: -- WSMPCNST.BONUS,
475: -- WSMPCNST.UPDATE_ROUTING)
476: -- --SpUA begin
477: -- OR (txn2.transaction_type_id in (WSMPCNST.SPLIT)

Line 474: -- WSMPCNST.BONUS,

470: AND (txn2.transaction_type_id not in
471: -- Start : Fix for bug #3150692 --
472: (WSMPCNST.BONUS)));
473: -- (WSMPCNST.UPDATE_ASSEMBLY,
474: -- WSMPCNST.BONUS,
475: -- WSMPCNST.UPDATE_ROUTING)
476: -- --SpUA begin
477: -- OR (txn2.transaction_type_id in (WSMPCNST.SPLIT)
478: -- AND rj.split_has_update_assy = 0)));

Line 475: -- WSMPCNST.UPDATE_ROUTING)

471: -- Start : Fix for bug #3150692 --
472: (WSMPCNST.BONUS)));
473: -- (WSMPCNST.UPDATE_ASSEMBLY,
474: -- WSMPCNST.BONUS,
475: -- WSMPCNST.UPDATE_ROUTING)
476: -- --SpUA begin
477: -- OR (txn2.transaction_type_id in (WSMPCNST.SPLIT)
478: -- AND rj.split_has_update_assy = 0)));
479: -- --SpUA end

Line 477: -- OR (txn2.transaction_type_id in (WSMPCNST.SPLIT)

473: -- (WSMPCNST.UPDATE_ASSEMBLY,
474: -- WSMPCNST.BONUS,
475: -- WSMPCNST.UPDATE_ROUTING)
476: -- --SpUA begin
477: -- OR (txn2.transaction_type_id in (WSMPCNST.SPLIT)
478: -- AND rj.split_has_update_assy = 0)));
479: -- --SpUA end
480: -- End : Fix for bug #3150692 --
481:

Line 498: IF (C_NONSTD_NO_CLASS_CODE_RJ_rec.txn_type_id = WSMPCNST.BONUS) THEN --VJ: CodeRVW: Added for NSLBJ--

494: --VJ: Start Additions for NSLBJ--
495: FOR C_NONSTD_NO_CLASS_CODE_RJ_rec in C_NONSTD_NO_CLASS_CODE_RJ(p_header_id) LOOP
496: l_stmt_num := 10;
497:
498: IF (C_NONSTD_NO_CLASS_CODE_RJ_rec.txn_type_id = WSMPCNST.BONUS) THEN --VJ: CodeRVW: Added for NSLBJ--
499:
500: l_stmt_num := 11;
501:
502: /* ST : commeting this for bug 3722383 */

Line 586: IF (c_net_quantity_rec.transaction_type_id = WSMPCNST.SPLIT) THEN

582: +-----------------------------------------------------------------*/
583:
584: FOR c_net_quantity_rec IN c_net_quantity(p_header_id) LOOP
585:
586: IF (c_net_quantity_rec.transaction_type_id = WSMPCNST.SPLIT) THEN
587: l_stmt_num := 13;
588: select we.wip_entity_name,
589: wdj.start_quantity,
590: wdj.net_quantity,

Line 697: IF (c_net_quantity_rec.transaction_type_id = WSMPCNST.UPDATE_QUANTITY) THEN

693: END IF;
694:
695: END IF;
696:
697: IF (c_net_quantity_rec.transaction_type_id = WSMPCNST.UPDATE_QUANTITY) THEN
698: l_stmt_num := 16;
699:
700: UPDATE wsm_resulting_jobs_interface wrji
701: SET wrji.net_quantity =

Line 747: IF ( c_net_quantity_rec.transaction_type_id = WSMPCNST.MERGE) THEN

743: END IF;
744:
745: l_stmt_num := 16;
746:
747: IF ( c_net_quantity_rec.transaction_type_id = WSMPCNST.MERGE) THEN
748: FOR rec in c_net_quantity_merge(c_net_quantity_rec.header_id) LOOP
749: IF (rec.potential_supply < 0) THEN
750: rec.potential_supply := 0;
751: END IF;

Line 806: IF ( c_net_quantity_rec.transaction_type_id = WSMPCNST.BONUS) THEN

802:
803: --FP bugfix 3403087 END IF;
804: END IF;
805:
806: IF ( c_net_quantity_rec.transaction_type_id = WSMPCNST.BONUS) THEN
807: l_stmt_num := 18;
808: UPDATE wsm_resulting_jobs_interface wrji
809: /* ST : fix for bug 3766859 : added decode : in case of non-std bonus default to 0 */
810: SET wrji.net_quantity = decode ( c_net_quantity_rec.job_type, WIP_CONSTANTS.STANDARD,wrji.start_quantity

Line 931: AND sji.transaction_type_id = WSMPCNST.BONUS

927: AND wrji.header_id = p_header_id -- WLTEnh
928: AND EXISTS(SELECT 1
929: FROM wsm_split_merge_txn_interface sji
930: WHERE sji.header_id = wrji.header_id
931: AND sji.transaction_type_id = WSMPCNST.BONUS
932: AND sji.process_status = WIP_CONSTANTS.RUNNING);
933:
934: IF (SQL%ROWCOUNT > 0) and l_debug = 'Y' THEN
935: FND_MESSAGE.SET_NAME('WSM', 'WSM_MODIFIED_FIELD');

Line 962: ( --WSMPCNST.SPLIT,

958: WHERE internal_group_id = WSMPLOAD.G_GROUP_ID
959: AND process_status = WIP_CONSTANTS.RUNNING
960: AND (transaction_type_id IN
961: --SpUA begin
962: ( --WSMPCNST.SPLIT,
963: WSMPCNST.BONUS)
964: OR (transaction_type_id IN (WSMPCNST.SPLIT)
965: AND rj.split_has_update_assy = 0)));
966: --SpUA end

Line 963: WSMPCNST.BONUS)

959: AND process_status = WIP_CONSTANTS.RUNNING
960: AND (transaction_type_id IN
961: --SpUA begin
962: ( --WSMPCNST.SPLIT,
963: WSMPCNST.BONUS)
964: OR (transaction_type_id IN (WSMPCNST.SPLIT)
965: AND rj.split_has_update_assy = 0)));
966: --SpUA end
967:

Line 964: OR (transaction_type_id IN (WSMPCNST.SPLIT)

960: AND (transaction_type_id IN
961: --SpUA begin
962: ( --WSMPCNST.SPLIT,
963: WSMPCNST.BONUS)
964: OR (transaction_type_id IN (WSMPCNST.SPLIT)
965: AND rj.split_has_update_assy = 0)));
966: --SpUA end
967:
968: IF (SQL%ROWCOUNT > 0) and l_debug = 'Y' THEN

Line 1022: AND (transaction_type_id IN (WSMPCNST.UPDATE_ASSEMBLY,

1018: FROM wsm_split_merge_txn_interface
1019: WHERE internal_group_id = WSMPLOAD.G_GROUP_ID
1020: and header_id = p_header_id -- WLTEnh
1021: AND process_status = WIP_CONSTANTS.RUNNING
1022: AND (transaction_type_id IN (WSMPCNST.UPDATE_ASSEMBLY,
1023: WSMPCNST.BONUS,
1024: WSMPCNST.UPDATE_ROUTING)
1025: --SpUA begin
1026: OR (transaction_type_id IN (WSMPCNST.SPLIT)

Line 1023: WSMPCNST.BONUS,

1019: WHERE internal_group_id = WSMPLOAD.G_GROUP_ID
1020: and header_id = p_header_id -- WLTEnh
1021: AND process_status = WIP_CONSTANTS.RUNNING
1022: AND (transaction_type_id IN (WSMPCNST.UPDATE_ASSEMBLY,
1023: WSMPCNST.BONUS,
1024: WSMPCNST.UPDATE_ROUTING)
1025: --SpUA begin
1026: OR (transaction_type_id IN (WSMPCNST.SPLIT)
1027: AND rj.split_has_update_assy = 1)))

Line 1024: WSMPCNST.UPDATE_ROUTING)

1020: and header_id = p_header_id -- WLTEnh
1021: AND process_status = WIP_CONSTANTS.RUNNING
1022: AND (transaction_type_id IN (WSMPCNST.UPDATE_ASSEMBLY,
1023: WSMPCNST.BONUS,
1024: WSMPCNST.UPDATE_ROUTING)
1025: --SpUA begin
1026: OR (transaction_type_id IN (WSMPCNST.SPLIT)
1027: AND rj.split_has_update_assy = 1)))
1028: --SpUA end

Line 1026: OR (transaction_type_id IN (WSMPCNST.SPLIT)

1022: AND (transaction_type_id IN (WSMPCNST.UPDATE_ASSEMBLY,
1023: WSMPCNST.BONUS,
1024: WSMPCNST.UPDATE_ROUTING)
1025: --SpUA begin
1026: OR (transaction_type_id IN (WSMPCNST.SPLIT)
1027: AND rj.split_has_update_assy = 1)))
1028: --SpUA end
1029: RETURNING rj.completion_subinventory,
1030: rj.completion_locator_id

Line 1077: AND (transaction_type_id IN ( --WSMPCNST.SPLIT,

1073: WHERE internal_group_id = WSMPLOAD.G_GROUP_ID
1074: and header_id = p_header_id -- WLTEnh
1075: AND process_status = WIP_CONSTANTS.RUNNING
1076: --SpUA begin
1077: AND (transaction_type_id IN ( --WSMPCNST.SPLIT,
1078: WSMPCNST.UPDATE_LOT_NAME,
1079: WSMPCNST.UPDATE_QUANTITY)
1080: OR (transaction_type_id IN (WSMPCNST.SPLIT)
1081: AND rj.split_has_update_assy = 0)));

Line 1078: WSMPCNST.UPDATE_LOT_NAME,

1074: and header_id = p_header_id -- WLTEnh
1075: AND process_status = WIP_CONSTANTS.RUNNING
1076: --SpUA begin
1077: AND (transaction_type_id IN ( --WSMPCNST.SPLIT,
1078: WSMPCNST.UPDATE_LOT_NAME,
1079: WSMPCNST.UPDATE_QUANTITY)
1080: OR (transaction_type_id IN (WSMPCNST.SPLIT)
1081: AND rj.split_has_update_assy = 0)));
1082: --SpUA end

Line 1079: WSMPCNST.UPDATE_QUANTITY)

1075: AND process_status = WIP_CONSTANTS.RUNNING
1076: --SpUA begin
1077: AND (transaction_type_id IN ( --WSMPCNST.SPLIT,
1078: WSMPCNST.UPDATE_LOT_NAME,
1079: WSMPCNST.UPDATE_QUANTITY)
1080: OR (transaction_type_id IN (WSMPCNST.SPLIT)
1081: AND rj.split_has_update_assy = 0)));
1082: --SpUA end
1083:

Line 1080: OR (transaction_type_id IN (WSMPCNST.SPLIT)

1076: --SpUA begin
1077: AND (transaction_type_id IN ( --WSMPCNST.SPLIT,
1078: WSMPCNST.UPDATE_LOT_NAME,
1079: WSMPCNST.UPDATE_QUANTITY)
1080: OR (transaction_type_id IN (WSMPCNST.SPLIT)
1081: AND rj.split_has_update_assy = 0)));
1082: --SpUA end
1083:
1084: IF (SQL%ROWCOUNT > 0) and l_debug = 'Y' THEN

Line 1127: AND transaction_type_id IN ( WSMPCNST.MERGE ))

1123: FROM wsm_split_merge_txn_interface
1124: WHERE internal_group_id = WSMPLOAD.G_GROUP_ID
1125: and header_id = p_header_id -- WLTEnh
1126: AND process_status = WIP_CONSTANTS.RUNNING
1127: AND transaction_type_id IN ( WSMPCNST.MERGE ))
1128: RETURNING rj.completion_subinventory, -- WLTEnh
1129: rj.completion_locator_id
1130: INTO l_temp_csi,
1131: l_temp_loc_id;

Line 1734: If l_cur_wsmti_rec.transaction_type_id <> WSMPCNST.BONUS Then

1730: +-----------------------------------------------------------------*/
1731:
1732: l_stmt_num := 9;
1733:
1734: If l_cur_wsmti_rec.transaction_type_id <> WSMPCNST.BONUS Then
1735:
1736: Begin
1737: l_stmt_num := 10;
1738:

Line 1828: If l_cur_wsmti_rec.transaction_type_id <> WSMPCNST.BONUS Then

1824: ||l_cur_wsmti_rec.header_id
1825: ||' set to ERROR in WSMTI.');
1826:
1827: l_stmt_num := 14; -- Bug 2682603
1828: If l_cur_wsmti_rec.transaction_type_id <> WSMPCNST.BONUS Then
1829: l_stmt_num := 15;
1830:
1831: Update wsm_starting_jobs_interface wsji
1832: SET wsji.error_message = l_fnd_generic_err_msg

Line 2068: and wsmti.transaction_type_id = WSMPCNST.MERGE);

2064: and wsji.representative_flag = 'Y'
2065: and exists (select 1
2066: from wsm_split_merge_txn_interface wsmti
2067: where wsmti.header_id = l_cur_wsji_rec.wsji_header_id
2068: and wsmti.transaction_type_id = WSMPCNST.MERGE);
2069:
2070: If l_dummy > 1 Then
2071: raise e_too_many_rep_lot_exception;
2072: End If;

Line 2133: (WSMPCNST.SPLIT,

2129: l_cur_wsji_rec.representative_flag
2130: FROM wsm_split_merge_txn_interface wsmti
2131: WHERE wsmti.header_id = l_cur_wsji_rec.wsji_header_id
2132: AND wsmti.transaction_type_id IN
2133: (WSMPCNST.SPLIT,
2134: WSMPCNST.UPDATE_ASSEMBLY,
2135: WSMPCNST.UPDATE_ROUTING,
2136: WSMPCNST.UPDATE_QUANTITY,
2137: WSMPCNST.UPDATE_LOT_NAME);

Line 2134: WSMPCNST.UPDATE_ASSEMBLY,

2130: FROM wsm_split_merge_txn_interface wsmti
2131: WHERE wsmti.header_id = l_cur_wsji_rec.wsji_header_id
2132: AND wsmti.transaction_type_id IN
2133: (WSMPCNST.SPLIT,
2134: WSMPCNST.UPDATE_ASSEMBLY,
2135: WSMPCNST.UPDATE_ROUTING,
2136: WSMPCNST.UPDATE_QUANTITY,
2137: WSMPCNST.UPDATE_LOT_NAME);
2138:

Line 2135: WSMPCNST.UPDATE_ROUTING,

2131: WHERE wsmti.header_id = l_cur_wsji_rec.wsji_header_id
2132: AND wsmti.transaction_type_id IN
2133: (WSMPCNST.SPLIT,
2134: WSMPCNST.UPDATE_ASSEMBLY,
2135: WSMPCNST.UPDATE_ROUTING,
2136: WSMPCNST.UPDATE_QUANTITY,
2137: WSMPCNST.UPDATE_LOT_NAME);
2138:
2139: IF (SQL%ROWCOUNT > 0) THEN

Line 2136: WSMPCNST.UPDATE_QUANTITY,

2132: AND wsmti.transaction_type_id IN
2133: (WSMPCNST.SPLIT,
2134: WSMPCNST.UPDATE_ASSEMBLY,
2135: WSMPCNST.UPDATE_ROUTING,
2136: WSMPCNST.UPDATE_QUANTITY,
2137: WSMPCNST.UPDATE_LOT_NAME);
2138:
2139: IF (SQL%ROWCOUNT > 0) THEN
2140:

Line 2137: WSMPCNST.UPDATE_LOT_NAME);

2133: (WSMPCNST.SPLIT,
2134: WSMPCNST.UPDATE_ASSEMBLY,
2135: WSMPCNST.UPDATE_ROUTING,
2136: WSMPCNST.UPDATE_QUANTITY,
2137: WSMPCNST.UPDATE_LOT_NAME);
2138:
2139: IF (SQL%ROWCOUNT > 0) THEN
2140:
2141: set_wsji_warning();

Line 2499: and l_cur_wsji_rec.transaction_type_id <> WSMPCNST.BONUS;

2495: and wo.wip_entity_id = l_cur_wsji_rec.wip_entity_id
2496: and wo.operation_seq_num = l_cur_wsji_rec.operation_seq_num
2497: and decode(wo.quantity_in_queue,0, wo.quantity_waiting_to_move,
2498: wo.quantity_in_queue) > 0
2499: and l_cur_wsji_rec.transaction_type_id <> WSMPCNST.BONUS;
2500:
2501: Exception
2502:
2503: When NO_DATA_FOUND Then

Line 2542: and txn.transaction_type_id <> WSMPCNST.BONUS

2538:
2539: select null into l_dummy
2540: from wsm_split_merge_txn_interface txn
2541: where txn.header_id = l_cur_wsji_rec.wsji_header_id
2542: and txn.transaction_type_id <> WSMPCNST.BONUS
2543: AND l_cur_wsji_rec.intraoperation_step in (WIP_CONSTANTS.QUEUE, WIP_CONSTANTS.TOMOVE);
2544:
2545: Exception
2546:

Line 2604: AND txn.transaction_type_id = WSMPCNST.BONUS;

2600:
2601: SELECT null into l_dummy
2602: FROM wsm_split_merge_txn_interface txn
2603: WHERE txn.header_id = l_cur_wsji_rec.wsji_header_id
2604: AND txn.transaction_type_id = WSMPCNST.BONUS;
2605:
2606: If SQL%ROWCOUNT > 0 Then
2607: raise TOO_MANY_ROWS;
2608: End If;

Line 2643: IF (l_cur_wsji_rec.transaction_type_id = WSMPCNST.MERGE) THEN

2639: /*----------------------------------------------+
2640: | Starting jobs in Merge should all be different|
2641: +----------------------------------------------*/
2642:
2643: IF (l_cur_wsji_rec.transaction_type_id = WSMPCNST.MERGE) THEN
2644: l_stmt_num := 42;
2645: /* ST : Bug fix 3880193 : Commenting the below SQL as it fails when merging more than 2 jobs */
2646: /*
2647: SELECT count(*)

Line 2765: if (l_cur_wsji_rec.transaction_type_id = WSMPCNST.MERGE) then

2761:
2762: /*BA#1623701*/
2763:
2764:
2765: if (l_cur_wsji_rec.transaction_type_id = WSMPCNST.MERGE) then
2766: l_stmt_num := 45;
2767:
2768: Begin
2769: l_stmt_num := 46;

Line 2833: ((l_cur_wsji_rec.representative_flag='Y') or (l_cur_wsji_rec.transaction_type_id <> WSMPCNST.MERGE))

2829:
2830: if (
2831: (l_cur_wsji_rec.routing_seq_id <> -1) and
2832: (l_cur_wsji_rec.routing_seq_id <> l_rtg_seq_id) and
2833: ((l_cur_wsji_rec.representative_flag='Y') or (l_cur_wsji_rec.transaction_type_id <> WSMPCNST.MERGE))
2834: )
2835: then
2836:
2837: -- WSJI routing_seq_id is PROVIDED -- Bug#2679705

Line 2863: (l_cur_wsji_rec.transaction_type_id=WSMPCNST.MERGE)

2859:
2860: elsif (
2861: (l_cur_wsji_rec.routing_seq_id <> -1) and
2862: (l_cur_wsji_rec.representative_flag<>'Y') and
2863: (l_cur_wsji_rec.transaction_type_id=WSMPCNST.MERGE)
2864: ) then
2865:
2866: -- WSJI routing_seq_id is PROVIDED -- Bug#2679705
2867: -- And this is the representative lot

Line 2923: if (l_cur_wsji_rec.transaction_type_id = WSMPCNST.MERGE) then

2919: | is merge txn in wsm_starting_jobs_interface |
2920: +---------------------------------------------------------------------*/
2921:
2922:
2923: if (l_cur_wsji_rec.transaction_type_id = WSMPCNST.MERGE) then
2924:
2925:
2926: BEGIN
2927:

Line 3020: if ( l_cur_wsji_rec.transaction_type_id in ( WSMPCNST.SPLIT,

3016:
3017: l_stmt_num := 52;
3018:
3019:
3020: if ( l_cur_wsji_rec.transaction_type_id in ( WSMPCNST.SPLIT,
3021: WSMPCNST.MERGE,
3022: WSMPCNST.UPDATE_ASSEMBLY,
3023: WSMPCNST.UPDATE_ROUTING )) then
3024:

Line 3021: WSMPCNST.MERGE,

3017: l_stmt_num := 52;
3018:
3019:
3020: if ( l_cur_wsji_rec.transaction_type_id in ( WSMPCNST.SPLIT,
3021: WSMPCNST.MERGE,
3022: WSMPCNST.UPDATE_ASSEMBLY,
3023: WSMPCNST.UPDATE_ROUTING )) then
3024:
3025: l_stmt_num := 53;

Line 3022: WSMPCNST.UPDATE_ASSEMBLY,

3018:
3019:
3020: if ( l_cur_wsji_rec.transaction_type_id in ( WSMPCNST.SPLIT,
3021: WSMPCNST.MERGE,
3022: WSMPCNST.UPDATE_ASSEMBLY,
3023: WSMPCNST.UPDATE_ROUTING )) then
3024:
3025: l_stmt_num := 53;
3026:

Line 3023: WSMPCNST.UPDATE_ROUTING )) then

3019:
3020: if ( l_cur_wsji_rec.transaction_type_id in ( WSMPCNST.SPLIT,
3021: WSMPCNST.MERGE,
3022: WSMPCNST.UPDATE_ASSEMBLY,
3023: WSMPCNST.UPDATE_ROUTING )) then
3024:
3025: l_stmt_num := 53;
3026:
3027: if wip_osp.po_req_exists( l_cur_wsji_rec.wip_entity_id,

Line 3223: IF (l_txn_type = WSMPCNST.SPLIT) THEN

3219:
3220: /*For Split txns only. If flag is 1, must update assembly.
3221: If flag is 0, assembly must be same. If flag is some other value, error out*/
3222:
3223: IF (l_txn_type = WSMPCNST.SPLIT) THEN
3224: l_stmt_num := 61;
3225:
3226: UPDATE wsm_resulting_jobs_interface wrji
3227: SET split_has_update_assy = 0

Line 3295: AND l_txn_type = WSMPCNST.BONUS --VJ: CodeRVW: Added for NSLBJ--

3291: update wsm_resulting_jobs_interface wrji
3292: SET wrji.error_message = l_fnd_generic_err_msg
3293: , wrji.process_status = WIP_CONSTANTS.ERROR -- WLTEnh
3294: WHERE wrji.header_id = l_header_id
3295: AND l_txn_type = WSMPCNST.BONUS --VJ: CodeRVW: Added for NSLBJ--
3296: AND wrji.job_type IS NOT NULL
3297: AND wrji.job_type NOT IN (WIP_CONSTANTS.STANDARD, WIP_CONSTANTS.NONSTANDARD); --Fixed bug #2341915
3298:
3299: IF (SQL%ROWCOUNT > 0) THEN

Line 3326: AND l_txn_type = WSMPCNST.BONUS

3322: --VJ: Start additions to fix bug #2341915--
3323: update wsm_resulting_jobs_interface wrji
3324: SET wrji.job_type = WIP_CONSTANTS.STANDARD
3325: WHERE wrji.header_id = l_header_id
3326: AND l_txn_type = WSMPCNST.BONUS
3327: AND wrji.job_type IS NULL;
3328:
3329: IF (SQL%ROWCOUNT > 0) THEN
3330: FND_MESSAGE.SET_NAME('WSM', 'WSM_MODIFIED_FIELD');

Line 3353: IF (l_txn_type <> WSMPCNST.BONUS) THEN

3349: --VJ: End additions to fix bug #2341915--
3350:
3351: l_stmt_num := 66;
3352: --VJ: CodeRVW: Start Changes for NSLBJ--
3353: IF (l_txn_type <> WSMPCNST.BONUS) THEN
3354: --VJ: CodeRVW: End Changes for NSLBJ--
3355:
3356: l_stmt_num := 67;
3357:

Line 3530: IF l_txn_type NOT IN (WSMPCNST.BONUS) THEN

3526: END IF;
3527: END IF;
3528:
3529: /* ST bug fix 3493984 : Update the resulting lot's start and completion dates */
3530: IF l_txn_type NOT IN (WSMPCNST.BONUS) THEN
3531:
3532: BEGIN
3533: select dis.scheduled_start_date,
3534: dis.scheduled_completion_date

Line 3669: IF (l_txn_type = WSMPCNST.UPDATE_ROUTING) THEN

3665: l_nslbj_alt_bom_desig := l_wrji_alt_bom_desig;
3666: END IF;
3667: --VJ: 0313: End Additions for NSLBJ--
3668:
3669: IF (l_txn_type = WSMPCNST.UPDATE_ROUTING) THEN
3670:
3671: l_stmt_num := 75;
3672: IF (l_debug = 'Y') THEN
3673: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): Processing Upd Routing');

Line 3834: END IF; --IF (l_txn_type = WSMPCNST.UPDATE_ROUTING) THEN--

3830: raise proc_error;
3831:
3832: END IF;
3833:
3834: END IF; --IF (l_txn_type = WSMPCNST.UPDATE_ROUTING) THEN--
3835:
3836:
3837: --VJ: 0313: Start Additions for NSLBJ--
3838: --SpUA begin

Line 3839: IF (l_txn_type IN ( --WSMPCNST.SPLIT,

3835:
3836:
3837: --VJ: 0313: Start Additions for NSLBJ--
3838: --SpUA begin
3839: IF (l_txn_type IN ( --WSMPCNST.SPLIT,
3840: WSMPCNST.MERGE,
3841: WSMPCNST.UPDATE_LOT_NAME, WSMPCNST.UPDATE_QUANTITY)
3842: OR (l_txn_type IN (WSMPCNST.SPLIT) AND l_split_has_update_assy = 0))
3843: --SpUA end

Line 3840: WSMPCNST.MERGE,

3836:
3837: --VJ: 0313: Start Additions for NSLBJ--
3838: --SpUA begin
3839: IF (l_txn_type IN ( --WSMPCNST.SPLIT,
3840: WSMPCNST.MERGE,
3841: WSMPCNST.UPDATE_LOT_NAME, WSMPCNST.UPDATE_QUANTITY)
3842: OR (l_txn_type IN (WSMPCNST.SPLIT) AND l_split_has_update_assy = 0))
3843: --SpUA end
3844: THEN

Line 3841: WSMPCNST.UPDATE_LOT_NAME, WSMPCNST.UPDATE_QUANTITY)

3837: --VJ: 0313: Start Additions for NSLBJ--
3838: --SpUA begin
3839: IF (l_txn_type IN ( --WSMPCNST.SPLIT,
3840: WSMPCNST.MERGE,
3841: WSMPCNST.UPDATE_LOT_NAME, WSMPCNST.UPDATE_QUANTITY)
3842: OR (l_txn_type IN (WSMPCNST.SPLIT) AND l_split_has_update_assy = 0))
3843: --SpUA end
3844: THEN
3845: -- all bom and routing info should be same as starting (repre) lot

Line 3842: OR (l_txn_type IN (WSMPCNST.SPLIT) AND l_split_has_update_assy = 0))

3838: --SpUA begin
3839: IF (l_txn_type IN ( --WSMPCNST.SPLIT,
3840: WSMPCNST.MERGE,
3841: WSMPCNST.UPDATE_LOT_NAME, WSMPCNST.UPDATE_QUANTITY)
3842: OR (l_txn_type IN (WSMPCNST.SPLIT) AND l_split_has_update_assy = 0))
3843: --SpUA end
3844: THEN
3845: -- all bom and routing info should be same as starting (repre) lot
3846: IF (l_txn_type = WSMPCNST.MERGE) THEN

Line 3846: IF (l_txn_type = WSMPCNST.MERGE) THEN

3842: OR (l_txn_type IN (WSMPCNST.SPLIT) AND l_split_has_update_assy = 0))
3843: --SpUA end
3844: THEN
3845: -- all bom and routing info should be same as starting (repre) lot
3846: IF (l_txn_type = WSMPCNST.MERGE) THEN
3847: l_stmt_num := 82;
3848: IF (l_debug = 'Y') THEN
3849: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): Processing Merge');
3850: END IF;

Line 3977: IF (l_txn_type IN (WSMPCNST.BONUS, WSMPCNST.UPDATE_ASSEMBLY, WSMPCNST.UPDATE_ROUTING)

3973:
3974: END IF; --IF (l_txn_type IN (SPLIT, MERGE, UPDATE_LOT_NAME, UPDATE_QUANTITY)) THEN--
3975: --VJ: 0313: End Additions for NSLBJ--
3976:
3977: IF (l_txn_type IN (WSMPCNST.BONUS, WSMPCNST.UPDATE_ASSEMBLY, WSMPCNST.UPDATE_ROUTING)
3978: --SpUA begin
3979: OR (l_txn_type IN (WSMPCNST.SPLIT) AND l_split_has_update_assy = 1)) THEN
3980: --SpUA end
3981: --VJ: 0313: Changed position for NSLBJ--

Line 3979: OR (l_txn_type IN (WSMPCNST.SPLIT) AND l_split_has_update_assy = 1)) THEN

3975: --VJ: 0313: End Additions for NSLBJ--
3976:
3977: IF (l_txn_type IN (WSMPCNST.BONUS, WSMPCNST.UPDATE_ASSEMBLY, WSMPCNST.UPDATE_ROUTING)
3978: --SpUA begin
3979: OR (l_txn_type IN (WSMPCNST.SPLIT) AND l_split_has_update_assy = 1)) THEN
3980: --SpUA end
3981: --VJ: 0313: Changed position for NSLBJ--
3982: -- *** Error Code and Message Guide ***
3983: -- 1: Routing Reference Cannot be Null

Line 4196: END IF; --IF (l_txn_type IN (WSMPCNST.BONUS, WSMPCNST.UPDATE_ASSEMBLY, WSMPCNST.UPDATE_ROUTING))

4192: END IF;
4193: END IF;
4194: END IF;
4195:
4196: END IF; --IF (l_txn_type IN (WSMPCNST.BONUS, WSMPCNST.UPDATE_ASSEMBLY, WSMPCNST.UPDATE_ROUTING))
4197:
4198: END IF; --(l_job_type = WIP_CONSTANTS.NONSTANDARD) Begin @ _stmt_num := 166
4199:
4200: -- BA: CZH.BUG2398718

Line 4338: IF l_txn_type = WSMPCNST.BONUS THEN

4334: | given, default the other one by calling WSMPUTIL.GET_SCHEDULED_DATE |
4335: +--------------------------------------------------------------------*/
4336:
4337: /* ST bug fix 3493984 : Add a check for the txn type */
4338: IF l_txn_type = WSMPCNST.BONUS THEN
4339:
4340: FOR c_null_scheduled_date_rec IN c_scheduled_date(l_header_id) LOOP
4341:
4342: l_stmt_num := 98;

Line 4619: (WSMPCNST.UPDATE_ASSEMBLY,

4615: and sj.header_id = txn.header_id
4616: and wrji.wip_entity_name = we.wip_entity_name
4617: and we.organization_id = txn.organization_id
4618: and txn.transaction_type_id in
4619: (WSMPCNST.UPDATE_ASSEMBLY,
4620: WSMPCNST.UPDATE_ROUTING,
4621: WSMPCNST.UPDATE_QUANTITY)
4622: and we.wip_entity_id = sj.wip_entity_id)
4623: union

Line 4620: WSMPCNST.UPDATE_ROUTING,

4616: and wrji.wip_entity_name = we.wip_entity_name
4617: and we.organization_id = txn.organization_id
4618: and txn.transaction_type_id in
4619: (WSMPCNST.UPDATE_ASSEMBLY,
4620: WSMPCNST.UPDATE_ROUTING,
4621: WSMPCNST.UPDATE_QUANTITY)
4622: and we.wip_entity_id = sj.wip_entity_id)
4623: union
4624: select null

Line 4621: WSMPCNST.UPDATE_QUANTITY)

4617: and we.organization_id = txn.organization_id
4618: and txn.transaction_type_id in
4619: (WSMPCNST.UPDATE_ASSEMBLY,
4620: WSMPCNST.UPDATE_ROUTING,
4621: WSMPCNST.UPDATE_QUANTITY)
4622: and we.wip_entity_id = sj.wip_entity_id)
4623: union
4624: select null
4625: from wsm_split_merge_txn_interface txn

Line 4628: (WSMPCNST.SPLIT,

4624: select null
4625: from wsm_split_merge_txn_interface txn
4626: where txn.header_id = wrji.header_id
4627: and txn.transaction_type_id IN
4628: (WSMPCNST.SPLIT,
4629: WSMPCNST.MERGE,
4630: WSMPCNST.BONUS,
4631: WSMPCNST.UPDATE_LOT_NAME));
4632:

Line 4629: WSMPCNST.MERGE,

4625: from wsm_split_merge_txn_interface txn
4626: where txn.header_id = wrji.header_id
4627: and txn.transaction_type_id IN
4628: (WSMPCNST.SPLIT,
4629: WSMPCNST.MERGE,
4630: WSMPCNST.BONUS,
4631: WSMPCNST.UPDATE_LOT_NAME));
4632:
4633: IF (SQL%ROWCOUNT > 0) THEN

Line 4630: WSMPCNST.BONUS,

4626: where txn.header_id = wrji.header_id
4627: and txn.transaction_type_id IN
4628: (WSMPCNST.SPLIT,
4629: WSMPCNST.MERGE,
4630: WSMPCNST.BONUS,
4631: WSMPCNST.UPDATE_LOT_NAME));
4632:
4633: IF (SQL%ROWCOUNT > 0) THEN
4634: set_wrji_error(); -- WLTEnh

Line 4631: WSMPCNST.UPDATE_LOT_NAME));

4627: and txn.transaction_type_id IN
4628: (WSMPCNST.SPLIT,
4629: WSMPCNST.MERGE,
4630: WSMPCNST.BONUS,
4631: WSMPCNST.UPDATE_LOT_NAME));
4632:
4633: IF (SQL%ROWCOUNT > 0) THEN
4634: set_wrji_error(); -- WLTEnh
4635:

Line 4655: IF (l_txn_type = (WSMPCNST.UPDATE_LOT_NAME)) THEN

4651: END IF;
4652: END IF;
4653:
4654: --VJ: Start Additions to fix bug #2352364--
4655: IF (l_txn_type = (WSMPCNST.UPDATE_LOT_NAME)) THEN
4656: l_stmt_num := 108;
4657: SELECT we.wip_entity_name
4658: INTO l_start_we_name
4659: FROM wip_entities we,

Line 4694: IF (l_txn_type = WSMPCNST.SPLIT) THEN

4690: | validate wip_entity_name in wsm_resulting_jobs_interface table: |
4691: | For split, there cannot be multiple occurences of a job_name |
4692: +-----------------------------------------------------------------*/
4693:
4694: IF (l_txn_type = WSMPCNST.SPLIT) THEN
4695: l_stmt_num := 109;
4696: select count(*)
4697: into l_count
4698: from wsm_resulting_jobs_interface

Line 4739: (WSMPCNST.SPLIT,

4735: from mtl_system_items mtl,
4736: wsm_split_merge_txn_interface txn
4737: where txn.header_id = wrji.header_id
4738: and txn.transaction_type_id in
4739: (WSMPCNST.SPLIT,
4740: WSMPCNST.MERGE,
4741: WSMPCNST.UPDATE_ASSEMBLY,
4742: WSMPCNST.BONUS)
4743: and mtl.organization_id = txn.organization_id

Line 4740: WSMPCNST.MERGE,

4736: wsm_split_merge_txn_interface txn
4737: where txn.header_id = wrji.header_id
4738: and txn.transaction_type_id in
4739: (WSMPCNST.SPLIT,
4740: WSMPCNST.MERGE,
4741: WSMPCNST.UPDATE_ASSEMBLY,
4742: WSMPCNST.BONUS)
4743: and mtl.organization_id = txn.organization_id
4744: and mtl.inventory_item_id = wrji.primary_item_id

Line 4741: WSMPCNST.UPDATE_ASSEMBLY,

4737: where txn.header_id = wrji.header_id
4738: and txn.transaction_type_id in
4739: (WSMPCNST.SPLIT,
4740: WSMPCNST.MERGE,
4741: WSMPCNST.UPDATE_ASSEMBLY,
4742: WSMPCNST.BONUS)
4743: and mtl.organization_id = txn.organization_id
4744: and mtl.inventory_item_id = wrji.primary_item_id
4745: and mtl.build_in_wip_flag = 'Y'

Line 4742: WSMPCNST.BONUS)

4738: and txn.transaction_type_id in
4739: (WSMPCNST.SPLIT,
4740: WSMPCNST.MERGE,
4741: WSMPCNST.UPDATE_ASSEMBLY,
4742: WSMPCNST.BONUS)
4743: and mtl.organization_id = txn.organization_id
4744: and mtl.inventory_item_id = wrji.primary_item_id
4745: and mtl.build_in_wip_flag = 'Y'
4746: and mtl.pick_components_flag = 'N'

Line 4753: (WSMPCNST.UPDATE_ROUTING,

4749: select null
4750: from wsm_split_merge_txn_interface txn1
4751: where txn1.header_id = wrji.header_id
4752: and txn1.transaction_type_id in
4753: (WSMPCNST.UPDATE_ROUTING,
4754: WSMPCNST.UPDATE_QUANTITY,
4755: WSMPCNST.UPDATE_LOT_NAME ));
4756:
4757: IF (SQL%ROWCOUNT > 0) THEN

Line 4754: WSMPCNST.UPDATE_QUANTITY,

4750: from wsm_split_merge_txn_interface txn1
4751: where txn1.header_id = wrji.header_id
4752: and txn1.transaction_type_id in
4753: (WSMPCNST.UPDATE_ROUTING,
4754: WSMPCNST.UPDATE_QUANTITY,
4755: WSMPCNST.UPDATE_LOT_NAME ));
4756:
4757: IF (SQL%ROWCOUNT > 0) THEN
4758: set_wrji_error(); -- WLTEnh

Line 4755: WSMPCNST.UPDATE_LOT_NAME ));

4751: where txn1.header_id = wrji.header_id
4752: and txn1.transaction_type_id in
4753: (WSMPCNST.UPDATE_ROUTING,
4754: WSMPCNST.UPDATE_QUANTITY,
4755: WSMPCNST.UPDATE_LOT_NAME ));
4756:
4757: IF (SQL%ROWCOUNT > 0) THEN
4758: set_wrji_error(); -- WLTEnh
4759:

Line 4795: (WSMPCNST.SPLIT,

4791: from mtl_system_items mtl,
4792: wsm_split_merge_txn_interface txn
4793: where txn.header_id = wrji.header_id
4794: and txn.transaction_type_id in
4795: (WSMPCNST.SPLIT,
4796: WSMPCNST.MERGE,
4797: WSMPCNST.UPDATE_ASSEMBLY,
4798: WSMPCNST.BONUS)
4799: and mtl.organization_id = txn.organization_id

Line 4796: WSMPCNST.MERGE,

4792: wsm_split_merge_txn_interface txn
4793: where txn.header_id = wrji.header_id
4794: and txn.transaction_type_id in
4795: (WSMPCNST.SPLIT,
4796: WSMPCNST.MERGE,
4797: WSMPCNST.UPDATE_ASSEMBLY,
4798: WSMPCNST.BONUS)
4799: and mtl.organization_id = txn.organization_id
4800: and mtl.inventory_item_id = wrji.primary_item_id

Line 4797: WSMPCNST.UPDATE_ASSEMBLY,

4793: where txn.header_id = wrji.header_id
4794: and txn.transaction_type_id in
4795: (WSMPCNST.SPLIT,
4796: WSMPCNST.MERGE,
4797: WSMPCNST.UPDATE_ASSEMBLY,
4798: WSMPCNST.BONUS)
4799: and mtl.organization_id = txn.organization_id
4800: and mtl.inventory_item_id = wrji.primary_item_id
4801: and mtl.lot_control_code = 2

Line 4798: WSMPCNST.BONUS)

4794: and txn.transaction_type_id in
4795: (WSMPCNST.SPLIT,
4796: WSMPCNST.MERGE,
4797: WSMPCNST.UPDATE_ASSEMBLY,
4798: WSMPCNST.BONUS)
4799: and mtl.organization_id = txn.organization_id
4800: and mtl.inventory_item_id = wrji.primary_item_id
4801: and mtl.lot_control_code = 2
4802: union

Line 4807: (WSMPCNST.UPDATE_ROUTING,

4803: select null
4804: from wsm_split_merge_txn_interface txn1
4805: where txn1.header_id = wrji.header_id
4806: and txn1.transaction_type_id in
4807: (WSMPCNST.UPDATE_ROUTING,
4808: WSMPCNST.UPDATE_QUANTITY,
4809: WSMPCNST.UPDATE_LOT_NAME ));
4810:
4811: IF (SQL%ROWCOUNT > 0) THEN

Line 4808: WSMPCNST.UPDATE_QUANTITY,

4804: from wsm_split_merge_txn_interface txn1
4805: where txn1.header_id = wrji.header_id
4806: and txn1.transaction_type_id in
4807: (WSMPCNST.UPDATE_ROUTING,
4808: WSMPCNST.UPDATE_QUANTITY,
4809: WSMPCNST.UPDATE_LOT_NAME ));
4810:
4811: IF (SQL%ROWCOUNT > 0) THEN
4812: set_wrji_error(); -- WLTEnh

Line 4809: WSMPCNST.UPDATE_LOT_NAME ));

4805: where txn1.header_id = wrji.header_id
4806: and txn1.transaction_type_id in
4807: (WSMPCNST.UPDATE_ROUTING,
4808: WSMPCNST.UPDATE_QUANTITY,
4809: WSMPCNST.UPDATE_LOT_NAME ));
4810:
4811: IF (SQL%ROWCOUNT > 0) THEN
4812: set_wrji_error(); -- WLTEnh
4813:

Line 4847: (WSMPCNST.SPLIT,

4843: from mtl_system_items mtl,
4844: wsm_split_merge_txn_interface txn
4845: where txn.header_id = wrji.header_id
4846: and txn.transaction_type_id in
4847: (WSMPCNST.SPLIT,
4848: WSMPCNST.MERGE,
4849: WSMPCNST.UPDATE_ASSEMBLY,
4850: WSMPCNST.BONUS)
4851: and mtl.organization_id = txn.organization_id

Line 4848: WSMPCNST.MERGE,

4844: wsm_split_merge_txn_interface txn
4845: where txn.header_id = wrji.header_id
4846: and txn.transaction_type_id in
4847: (WSMPCNST.SPLIT,
4848: WSMPCNST.MERGE,
4849: WSMPCNST.UPDATE_ASSEMBLY,
4850: WSMPCNST.BONUS)
4851: and mtl.organization_id = txn.organization_id
4852: and mtl.inventory_item_id = wrji.primary_item_id

Line 4849: WSMPCNST.UPDATE_ASSEMBLY,

4845: where txn.header_id = wrji.header_id
4846: and txn.transaction_type_id in
4847: (WSMPCNST.SPLIT,
4848: WSMPCNST.MERGE,
4849: WSMPCNST.UPDATE_ASSEMBLY,
4850: WSMPCNST.BONUS)
4851: and mtl.organization_id = txn.organization_id
4852: and mtl.inventory_item_id = wrji.primary_item_id
4853: and mtl.serial_number_control_code = 1

Line 4850: WSMPCNST.BONUS)

4846: and txn.transaction_type_id in
4847: (WSMPCNST.SPLIT,
4848: WSMPCNST.MERGE,
4849: WSMPCNST.UPDATE_ASSEMBLY,
4850: WSMPCNST.BONUS)
4851: and mtl.organization_id = txn.organization_id
4852: and mtl.inventory_item_id = wrji.primary_item_id
4853: and mtl.serial_number_control_code = 1
4854: union

Line 4859: (WSMPCNST.UPDATE_ROUTING,

4855: select null
4856: from wsm_split_merge_txn_interface txn1
4857: where txn1.header_id = wrji.header_id
4858: and txn1.transaction_type_id in
4859: (WSMPCNST.UPDATE_ROUTING,
4860: WSMPCNST.UPDATE_QUANTITY,
4861: WSMPCNST.UPDATE_LOT_NAME ));
4862:
4863: IF (SQL%ROWCOUNT > 0) THEN

Line 4860: WSMPCNST.UPDATE_QUANTITY,

4856: from wsm_split_merge_txn_interface txn1
4857: where txn1.header_id = wrji.header_id
4858: and txn1.transaction_type_id in
4859: (WSMPCNST.UPDATE_ROUTING,
4860: WSMPCNST.UPDATE_QUANTITY,
4861: WSMPCNST.UPDATE_LOT_NAME ));
4862:
4863: IF (SQL%ROWCOUNT > 0) THEN
4864: set_wrji_error(); -- WLTEnh

Line 4861: WSMPCNST.UPDATE_LOT_NAME ));

4857: where txn1.header_id = wrji.header_id
4858: and txn1.transaction_type_id in
4859: (WSMPCNST.UPDATE_ROUTING,
4860: WSMPCNST.UPDATE_QUANTITY,
4861: WSMPCNST.UPDATE_LOT_NAME ));
4862:
4863: IF (SQL%ROWCOUNT > 0) THEN
4864: set_wrji_error(); -- WLTEnh
4865:

Line 4905: and txn.transaction_type_id = WSMPCNST.UPDATE_ASSEMBLY);

4901: where sj.wip_entity_id = dj.wip_entity_id
4902: and dj.primary_item_id = nvl(wrji.primary_item_id,dj.primary_item_id)
4903: and txn.header_id = wrji.header_id
4904: and sj.header_id = txn.header_id
4905: and txn.transaction_type_id = WSMPCNST.UPDATE_ASSEMBLY);
4906:
4907: IF (SQL%ROWCOUNT > 0) THEN
4908: set_wrji_error(); -- WLTEnh
4909:

Line 4943: (WSMPCNST.BONUS,

4939: wsm_split_merge_txn_interface txn
4940: where txn.organization_id = ood.organization_id
4941: and txn.header_id = wrji.header_id
4942: and txn.transaction_type_id IN
4943: (WSMPCNST.BONUS,
4944: WSMPCNST.UPDATE_QUANTITY)
4945: and ood.chart_of_accounts_id = gcc.chart_of_accounts_id
4946: and nvl (wrji.bonus_acct_id, -1) = gcc.code_combination_id
4947: and gcc.enabled_flag = 'Y'

Line 4944: WSMPCNST.UPDATE_QUANTITY)

4940: where txn.organization_id = ood.organization_id
4941: and txn.header_id = wrji.header_id
4942: and txn.transaction_type_id IN
4943: (WSMPCNST.BONUS,
4944: WSMPCNST.UPDATE_QUANTITY)
4945: and ood.chart_of_accounts_id = gcc.chart_of_accounts_id
4946: and nvl (wrji.bonus_acct_id, -1) = gcc.code_combination_id
4947: and gcc.enabled_flag = 'Y'
4948: and txn.transaction_date between

Line 4955: (WSMPCNST.BONUS,

4951: union
4952: select 1
4953: from wsm_split_merge_txn_interface txn1
4954: where txn1.transaction_type_id NOT IN
4955: (WSMPCNST.BONUS,
4956: WSMPCNST.UPDATE_QUANTITY)
4957: and txn1.header_id = wrji.header_id);
4958:
4959: IF (SQL%ROWCOUNT > 0) THEN

Line 4956: WSMPCNST.UPDATE_QUANTITY)

4952: select 1
4953: from wsm_split_merge_txn_interface txn1
4954: where txn1.transaction_type_id NOT IN
4955: (WSMPCNST.BONUS,
4956: WSMPCNST.UPDATE_QUANTITY)
4957: and txn1.header_id = wrji.header_id);
4958:
4959: IF (SQL%ROWCOUNT > 0) THEN
4960: set_wrji_error(); -- WLTEnh

Line 4996: and txn.transaction_type_id = WSMPCNST.UPDATE_QUANTITY

4992: wsm_starting_jobs_interface sj,
4993: wip_discrete_jobs dj
4994: where txn.header_id = wrji.header_id
4995: and txn.header_id = sj.header_id
4996: and txn.transaction_type_id = WSMPCNST.UPDATE_QUANTITY
4997: and sj.wip_entity_id = dj.wip_entity_id
4998: and wrji.start_quantity <= (dj.start_quantity -
4999: dj.quantity_scrapped - dj.quantity_completed))));
5000:

Line 5024: IF (l_txn_type IN (WSMPCNST.UPDATE_ASSEMBLY,

5020: END IF;
5021:
5022: --Start fix for bug #2448428--
5023: l_stmt_num := 116;
5024: IF (l_txn_type IN (WSMPCNST.UPDATE_ASSEMBLY,
5025: WSMPCNST.UPDATE_ROUTING,
5026: WSMPCNST.UPDATE_LOT_NAME)) THEN
5027: l_stmt_num := 117;
5028: SELECT wdj.start_quantity

Line 5025: WSMPCNST.UPDATE_ROUTING,

5021:
5022: --Start fix for bug #2448428--
5023: l_stmt_num := 116;
5024: IF (l_txn_type IN (WSMPCNST.UPDATE_ASSEMBLY,
5025: WSMPCNST.UPDATE_ROUTING,
5026: WSMPCNST.UPDATE_LOT_NAME)) THEN
5027: l_stmt_num := 117;
5028: SELECT wdj.start_quantity
5029: INTO l_wdj_st_qty

Line 5026: WSMPCNST.UPDATE_LOT_NAME)) THEN

5022: --Start fix for bug #2448428--
5023: l_stmt_num := 116;
5024: IF (l_txn_type IN (WSMPCNST.UPDATE_ASSEMBLY,
5025: WSMPCNST.UPDATE_ROUTING,
5026: WSMPCNST.UPDATE_LOT_NAME)) THEN
5027: l_stmt_num := 117;
5028: SELECT wdj.start_quantity
5029: INTO l_wdj_st_qty
5030: FROM wip_discrete_jobs wdj,

Line 5116: if (l_txn_type in ( --WSMPCNST.SPLIT,

5112:
5113: /*BA#1623701*/
5114:
5115: --SpUA begin
5116: if (l_txn_type in ( --WSMPCNST.SPLIT,
5117: WSMPCNST.MERGE,
5118: WSMPCNST.UPDATE_QUANTITY,
5119: WSMPCNST.UPDATE_LOT_NAME
5120: )

Line 5117: WSMPCNST.MERGE,

5113: /*BA#1623701*/
5114:
5115: --SpUA begin
5116: if (l_txn_type in ( --WSMPCNST.SPLIT,
5117: WSMPCNST.MERGE,
5118: WSMPCNST.UPDATE_QUANTITY,
5119: WSMPCNST.UPDATE_LOT_NAME
5120: )
5121: OR (l_txn_type in (WSMPCNST.SPLIT) and l_split_has_update_assy = 0)) then

Line 5118: WSMPCNST.UPDATE_QUANTITY,

5114:
5115: --SpUA begin
5116: if (l_txn_type in ( --WSMPCNST.SPLIT,
5117: WSMPCNST.MERGE,
5118: WSMPCNST.UPDATE_QUANTITY,
5119: WSMPCNST.UPDATE_LOT_NAME
5120: )
5121: OR (l_txn_type in (WSMPCNST.SPLIT) and l_split_has_update_assy = 0)) then
5122: --SpUA end

Line 5119: WSMPCNST.UPDATE_LOT_NAME

5115: --SpUA begin
5116: if (l_txn_type in ( --WSMPCNST.SPLIT,
5117: WSMPCNST.MERGE,
5118: WSMPCNST.UPDATE_QUANTITY,
5119: WSMPCNST.UPDATE_LOT_NAME
5120: )
5121: OR (l_txn_type in (WSMPCNST.SPLIT) and l_split_has_update_assy = 0)) then
5122: --SpUA end
5123:

Line 5121: OR (l_txn_type in (WSMPCNST.SPLIT) and l_split_has_update_assy = 0)) then

5117: WSMPCNST.MERGE,
5118: WSMPCNST.UPDATE_QUANTITY,
5119: WSMPCNST.UPDATE_LOT_NAME
5120: )
5121: OR (l_txn_type in (WSMPCNST.SPLIT) and l_split_has_update_assy = 0)) then
5122: --SpUA end
5123:
5124: if (l_txn_type = WSMPCNST.MERGE) then
5125: l_stmt_num := 121;

Line 5124: if (l_txn_type = WSMPCNST.MERGE) then

5120: )
5121: OR (l_txn_type in (WSMPCNST.SPLIT) and l_split_has_update_assy = 0)) then
5122: --SpUA end
5123:
5124: if (l_txn_type = WSMPCNST.MERGE) then
5125: l_stmt_num := 121;
5126: select common_routing_sequence_id, nvl(alternate_routing_designator, '-1')
5127: into l_rtg_seq_id, l_alt_rtg_desig
5128: from wip_discrete_jobs wdj, wsm_starting_jobs_interface wsji

Line 5303: else /* ie. l_txn_type in (WSMPCNST.BONUS, WSMPCNST.UPDATE_ASSEMBLY, WSMPCNST.UPDATE_ROUTING)) */

5299:
5300: end if;
5301: --End NL Bugfix 3112243
5302:
5303: else /* ie. l_txn_type in (WSMPCNST.BONUS, WSMPCNST.UPDATE_ASSEMBLY, WSMPCNST.UPDATE_ROUTING)) */
5304: /*SpUA: Split and Update Assy is now part of this list*/
5305:
5306: if ((l_wrji_rtg_seq_id=-1) and
5307: (l_wrji_alt_rtg_desig='-1'))

Line 5522: IF (l_txn_type in (WSMPCNST.UPDATE_ROUTING)) THEN

5518:
5519: END IF; /* l_wrji_rtg_seq_id and l_wrji_alt_rtg_desig condition ends */
5520:
5521: --VJ: Start additions to fix bug #2352354--
5522: IF (l_txn_type in (WSMPCNST.UPDATE_ROUTING)) THEN
5523: l_stmt_num := 134;
5524: select nvl(common_routing_sequence_id, -1), nvl(alternate_routing_designator, '-1')
5525: , routing_revision, routing_revision_date -- Added for APS-WLT
5526: into l_rtg_seq_id, l_alt_rtg_desig

Line 5641: AND (transaction_type_id IN (WSMPCNST.UPDATE_ASSEMBLY,

5637: AND rj.header_id IN (SELECT header_id
5638: FROM wsm_split_merge_txn_interface
5639: WHERE internal_group_id = WSMPLOAD.G_GROUP_ID
5640: AND process_status = WIP_CONSTANTS.RUNNING
5641: AND (transaction_type_id IN (WSMPCNST.UPDATE_ASSEMBLY,
5642: WSMPCNST.BONUS,
5643: WSMPCNST.UPDATE_ROUTING)
5644: --SpUA begin
5645: OR (transaction_type_id = WSMPCNST.SPLIT

Line 5642: WSMPCNST.BONUS,

5638: FROM wsm_split_merge_txn_interface
5639: WHERE internal_group_id = WSMPLOAD.G_GROUP_ID
5640: AND process_status = WIP_CONSTANTS.RUNNING
5641: AND (transaction_type_id IN (WSMPCNST.UPDATE_ASSEMBLY,
5642: WSMPCNST.BONUS,
5643: WSMPCNST.UPDATE_ROUTING)
5644: --SpUA begin
5645: OR (transaction_type_id = WSMPCNST.SPLIT
5646: AND l_split_has_update_assy = 1)));

Line 5643: WSMPCNST.UPDATE_ROUTING)

5639: WHERE internal_group_id = WSMPLOAD.G_GROUP_ID
5640: AND process_status = WIP_CONSTANTS.RUNNING
5641: AND (transaction_type_id IN (WSMPCNST.UPDATE_ASSEMBLY,
5642: WSMPCNST.BONUS,
5643: WSMPCNST.UPDATE_ROUTING)
5644: --SpUA begin
5645: OR (transaction_type_id = WSMPCNST.SPLIT
5646: AND l_split_has_update_assy = 1)));
5647: --SpUA end

Line 5645: OR (transaction_type_id = WSMPCNST.SPLIT

5641: AND (transaction_type_id IN (WSMPCNST.UPDATE_ASSEMBLY,
5642: WSMPCNST.BONUS,
5643: WSMPCNST.UPDATE_ROUTING)
5644: --SpUA begin
5645: OR (transaction_type_id = WSMPCNST.SPLIT
5646: AND l_split_has_update_assy = 1)));
5647: --SpUA end
5648:
5649: IF (SQL%ROWCOUNT > 0) and l_debug = 'Y' THEN

Line 5669: IF (l_txn_type IN (--WSMPCNST.SPLIT, /* ST fix for bug 3327459 */

5665: l_stmt_num := 137;
5666: /* ST bug fix 3327459 : In case of split with no change of assembly the routing rev date should default from the parent job,
5667: in case of a job with change of assembly the routing rev date should honour user entered date */
5668:
5669: IF (l_txn_type IN (--WSMPCNST.SPLIT, /* ST fix for bug 3327459 */
5670: WSMPCNST.UPDATE_QUANTITY,
5671: WSMPCNST.UPDATE_LOT_NAME))
5672: OR (l_txn_type = WSMPCNST.SPLIT and l_split_has_update_assy = 0 ) /* ST fix for bug 3327459 */
5673: THEN

Line 5670: WSMPCNST.UPDATE_QUANTITY,

5666: /* ST bug fix 3327459 : In case of split with no change of assembly the routing rev date should default from the parent job,
5667: in case of a job with change of assembly the routing rev date should honour user entered date */
5668:
5669: IF (l_txn_type IN (--WSMPCNST.SPLIT, /* ST fix for bug 3327459 */
5670: WSMPCNST.UPDATE_QUANTITY,
5671: WSMPCNST.UPDATE_LOT_NAME))
5672: OR (l_txn_type = WSMPCNST.SPLIT and l_split_has_update_assy = 0 ) /* ST fix for bug 3327459 */
5673: THEN
5674: l_stmt_num := 138;

Line 5671: WSMPCNST.UPDATE_LOT_NAME))

5667: in case of a job with change of assembly the routing rev date should honour user entered date */
5668:
5669: IF (l_txn_type IN (--WSMPCNST.SPLIT, /* ST fix for bug 3327459 */
5670: WSMPCNST.UPDATE_QUANTITY,
5671: WSMPCNST.UPDATE_LOT_NAME))
5672: OR (l_txn_type = WSMPCNST.SPLIT and l_split_has_update_assy = 0 ) /* ST fix for bug 3327459 */
5673: THEN
5674: l_stmt_num := 138;
5675: select wdj.routing_revision,

Line 5672: OR (l_txn_type = WSMPCNST.SPLIT and l_split_has_update_assy = 0 ) /* ST fix for bug 3327459 */

5668:
5669: IF (l_txn_type IN (--WSMPCNST.SPLIT, /* ST fix for bug 3327459 */
5670: WSMPCNST.UPDATE_QUANTITY,
5671: WSMPCNST.UPDATE_LOT_NAME))
5672: OR (l_txn_type = WSMPCNST.SPLIT and l_split_has_update_assy = 0 ) /* ST fix for bug 3327459 */
5673: THEN
5674: l_stmt_num := 138;
5675: select wdj.routing_revision,
5676: wdj.routing_revision_date

Line 5684: ELSIF (l_txn_type = WSMPCNST.MERGE) THEN

5680: wsm_starting_jobs_interface wsji
5681: where wdj.wip_entity_id=wsji.wip_entity_id
5682: and wsji.header_id=l_header_id;
5683:
5684: ELSIF (l_txn_type = WSMPCNST.MERGE) THEN
5685: l_stmt_num := 139;
5686: select wdj.routing_revision,
5687: wdj.routing_revision_date
5688: into l_rtg_rev,

Line 5823: IF (l_txn_type = WSMPCNST.BONUS and l_wrji_rtg_seq_id <> -1) THEN -- 4=Bns

5819: FROM wsm_resulting_jobs_interface
5820: WHERE header_id = l_header_id and rowid = l_wrji_rowid; -- WLTEnh.
5821:
5822: -- For Bonus, check routing start/end, if disabled error out
5823: IF (l_txn_type = WSMPCNST.BONUS and l_wrji_rtg_seq_id <> -1) THEN -- 4=Bns
5824: WSMPUTIL.find_routing_start (
5825: l_wrji_rtg_seq_id,
5826: l_rtg_rev_date,
5827: l_start_op_seq_id,

Line 6013: (WSMPCNST.UPDATE_ASSEMBLY, WSMPCNST.UPDATE_ROUTING )

6009: wsm_split_merge_txn_interface wsmti
6010: WHERE wsji.header_id = l_header_id
6011: AND wsmti.header_id = l_header_id
6012: AND (wsmti.transaction_type_id in
6013: (WSMPCNST.UPDATE_ASSEMBLY, WSMPCNST.UPDATE_ROUTING )
6014: OR (wsmti.transaction_type_id in (WSMPCNST.SPLIT)
6015: AND l_split_has_update_assy = 1));
6016:
6017: IF (l_profile_value = 2) THEN -- Option A (Old Behavior)

Line 6014: OR (wsmti.transaction_type_id in (WSMPCNST.SPLIT)

6010: WHERE wsji.header_id = l_header_id
6011: AND wsmti.header_id = l_header_id
6012: AND (wsmti.transaction_type_id in
6013: (WSMPCNST.UPDATE_ASSEMBLY, WSMPCNST.UPDATE_ROUTING )
6014: OR (wsmti.transaction_type_id in (WSMPCNST.SPLIT)
6015: AND l_split_has_update_assy = 1));
6016:
6017: IF (l_profile_value = 2) THEN -- Option A (Old Behavior)
6018: IF (l_st_iop = WIP_CONSTANTS.QUEUE) THEN -- Res St Op is mandatory.

Line 6098: (WSMPCNST.UPDATE_ASSEMBLY, WSMPCNST.UPDATE_ROUTING )

6094: wsm_split_merge_txn_interface txn
6095: where txn.header_id = wrji.header_id
6096: and txn.header_id = sj.header_id
6097: and (txn.transaction_type_id in
6098: (WSMPCNST.UPDATE_ASSEMBLY, WSMPCNST.UPDATE_ROUTING )
6099: --SpUA begin
6100: OR (txn.transaction_type_id in (WSMPCNST.SPLIT)
6101: AND l_split_has_update_assy = 1))
6102: --SpUA end

Line 6100: OR (txn.transaction_type_id in (WSMPCNST.SPLIT)

6096: and txn.header_id = sj.header_id
6097: and (txn.transaction_type_id in
6098: (WSMPCNST.UPDATE_ASSEMBLY, WSMPCNST.UPDATE_ROUTING )
6099: --SpUA begin
6100: OR (txn.transaction_type_id in (WSMPCNST.SPLIT)
6101: AND l_split_has_update_assy = 1))
6102: --SpUA end
6103: --Start Changes to fix bug #2352369--
6104: --and sj.intraoperation_step = WIP_CONSTANTS.TOMOVE

Line 6169: (WSMPCNST.UPDATE_ASSEMBLY, WSMPCNST.UPDATE_ROUTING )

6165: wsm_split_merge_txn_interface txn
6166: where txn.header_id = wrji.header_id
6167: and txn.header_id = sj.header_id
6168: and (txn.transaction_type_id in
6169: (WSMPCNST.UPDATE_ASSEMBLY, WSMPCNST.UPDATE_ROUTING )
6170: --SpUA begin
6171: OR (txn.transaction_type_id in (WSMPCNST.SPLIT)
6172: AND l_split_has_update_assy = 1))
6173: --SpUA end

Line 6171: OR (txn.transaction_type_id in (WSMPCNST.SPLIT)

6167: and txn.header_id = sj.header_id
6168: and (txn.transaction_type_id in
6169: (WSMPCNST.UPDATE_ASSEMBLY, WSMPCNST.UPDATE_ROUTING )
6170: --SpUA begin
6171: OR (txn.transaction_type_id in (WSMPCNST.SPLIT)
6172: AND l_split_has_update_assy = 1))
6173: --SpUA end
6174: and sj.intraoperation_step = WIP_CONSTANTS.TOMOVE
6175: );

Line 6214: if (l_txn_type in ( --WSMPCNST.SPLIT,

6210: | mark the record with warning message if no bom or routing is |
6211: | found. |
6212: +-----------------------------------------------------------------*/
6213: --SpUA begin
6214: if (l_txn_type in ( --WSMPCNST.SPLIT,
6215: WSMPCNST.MERGE,
6216: WSMPCNST.UPDATE_QUANTITY,
6217: WSMPCNST.UPDATE_LOT_NAME)
6218: OR (l_txn_type in (WSMPCNST.SPLIT) and l_split_has_update_assy = 0))

Line 6215: WSMPCNST.MERGE,

6211: | found. |
6212: +-----------------------------------------------------------------*/
6213: --SpUA begin
6214: if (l_txn_type in ( --WSMPCNST.SPLIT,
6215: WSMPCNST.MERGE,
6216: WSMPCNST.UPDATE_QUANTITY,
6217: WSMPCNST.UPDATE_LOT_NAME)
6218: OR (l_txn_type in (WSMPCNST.SPLIT) and l_split_has_update_assy = 0))
6219: then

Line 6216: WSMPCNST.UPDATE_QUANTITY,

6212: +-----------------------------------------------------------------*/
6213: --SpUA begin
6214: if (l_txn_type in ( --WSMPCNST.SPLIT,
6215: WSMPCNST.MERGE,
6216: WSMPCNST.UPDATE_QUANTITY,
6217: WSMPCNST.UPDATE_LOT_NAME)
6218: OR (l_txn_type in (WSMPCNST.SPLIT) and l_split_has_update_assy = 0))
6219: then
6220: --SpUA end

Line 6217: WSMPCNST.UPDATE_LOT_NAME)

6213: --SpUA begin
6214: if (l_txn_type in ( --WSMPCNST.SPLIT,
6215: WSMPCNST.MERGE,
6216: WSMPCNST.UPDATE_QUANTITY,
6217: WSMPCNST.UPDATE_LOT_NAME)
6218: OR (l_txn_type in (WSMPCNST.SPLIT) and l_split_has_update_assy = 0))
6219: then
6220: --SpUA end
6221:

Line 6218: OR (l_txn_type in (WSMPCNST.SPLIT) and l_split_has_update_assy = 0))

6214: if (l_txn_type in ( --WSMPCNST.SPLIT,
6215: WSMPCNST.MERGE,
6216: WSMPCNST.UPDATE_QUANTITY,
6217: WSMPCNST.UPDATE_LOT_NAME)
6218: OR (l_txn_type in (WSMPCNST.SPLIT) and l_split_has_update_assy = 0))
6219: then
6220: --SpUA end
6221:
6222: if (l_txn_type = WSMPCNST.MERGE) then

Line 6222: if (l_txn_type = WSMPCNST.MERGE) then

6218: OR (l_txn_type in (WSMPCNST.SPLIT) and l_split_has_update_assy = 0))
6219: then
6220: --SpUA end
6221:
6222: if (l_txn_type = WSMPCNST.MERGE) then
6223: l_stmt_num := 153;
6224: select common_bom_sequence_id, nvl(alternate_bom_designator, '-1')
6225: into l_bom_seq_id, l_alt_bom_desig
6226: from wip_discrete_jobs wdj, wsm_starting_jobs_interface wsji

Line 6402: else /* ie. if (l_txn_type in (WSMPCNST.BONUS, WSMPCNST.UPDATE_ASSEMBLY, WSMPCNST.UPDATE_ROUTING)) */

6398:
6399: end if;
6400: --End NL Bugfix 3112243
6401:
6402: else /* ie. if (l_txn_type in (WSMPCNST.BONUS, WSMPCNST.UPDATE_ASSEMBLY, WSMPCNST.UPDATE_ROUTING)) */
6403: /* SpUA: Split and Update Assy is now part of this list */
6404:
6405: l_stmt_num := 160;
6406: If (l_debug = 'Y') Then

Line 6666: if (l_txn_type in (WSMPCNST.UPDATE_ROUTING)) THEN

6662: end if; /* l_wrji_bom_seq_id and l_wrji_alt_bom_desig condition check ends */
6663:
6664: --VJ: Start additions to fix bug #2352344--
6665: --Extra validations for Upd Rtg--
6666: if (l_txn_type in (WSMPCNST.UPDATE_ROUTING)) THEN
6667: l_stmt_num := 167;
6668: select nvl(common_bom_sequence_id, -1), nvl(alternate_bom_designator, '-1')
6669: into l_bom_seq_id, l_alt_bom_desig
6670: from wip_discrete_jobs wdj, wsm_starting_jobs_interface wsji

Line 7124: if (l_txn_type in (WSMPCNST.UPDATE_ASSEMBLY, WSMPCNST.UPDATE_ROUTING)

7120: -- EA: NSO-WLT
7121:
7122: -- ***********************************************************************
7123:
7124: if (l_txn_type in (WSMPCNST.UPDATE_ASSEMBLY, WSMPCNST.UPDATE_ROUTING)
7125: --SpUA begin
7126: OR (l_txn_type in (WSMPCNST.SPLIT) AND l_split_has_update_assy = 1)) then
7127: --SpUA end
7128:

Line 7126: OR (l_txn_type in (WSMPCNST.SPLIT) AND l_split_has_update_assy = 1)) then

7122: -- ***********************************************************************
7123:
7124: if (l_txn_type in (WSMPCNST.UPDATE_ASSEMBLY, WSMPCNST.UPDATE_ROUTING)
7125: --SpUA begin
7126: OR (l_txn_type in (WSMPCNST.SPLIT) AND l_split_has_update_assy = 1)) then
7127: --SpUA end
7128:
7129: DECLARE
7130:

Line 7439: AND txn.transaction_type_id = WSMPCNST.BONUS)

7435: WHERE wrji.header_id = l_header_id
7436: AND exists (SELECT null
7437: FROM wsm_split_merge_txn_interface txn
7438: WHERE txn.header_id = wrji.header_id
7439: AND txn.transaction_type_id = WSMPCNST.BONUS)
7440: AND wrji.starting_std_op_id is not null
7441: AND wrji.starting_operation_code is not null
7442: AND wrji.starting_std_op_id <>
7443: ( SELECT bso.standard_operation_id

Line 7506: AND txn.transaction_type_id = WSMPCNST.BONUS);

7502: WHERE wrji.header_id = l_header_id
7503: AND exists (SELECT null
7504: FROM wsm_split_merge_txn_interface txn
7505: WHERE txn.header_id = wrji.header_id
7506: AND txn.transaction_type_id = WSMPCNST.BONUS);
7507:
7508: IF (l_debug = 'Y') THEN
7509: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): l_count='||l_count);
7510: END IF;

Line 7527: AND txn.transaction_type_id = WSMPCNST.BONUS);

7523: WHERE wrji.header_id = l_header_id
7524: AND exists (SELECT null
7525: FROM wsm_split_merge_txn_interface txn
7526: WHERE txn.header_id = wrji.header_id
7527: AND txn.transaction_type_id = WSMPCNST.BONUS);
7528:
7529: IF (l_debug = 'Y') THEN
7530: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('
7531: ||l_stmt_num||'): l_start_std_op_id='

Line 7728: AND txn.transaction_type_id = WSMPCNST.BONUS)

7724: WHERE wrji.header_id = l_header_id
7725: AND exists (SELECT null
7726: FROM wsm_split_merge_txn_interface txn
7727: WHERE txn.header_id = wrji.header_id
7728: AND txn.transaction_type_id = WSMPCNST.BONUS)
7729: AND bos.routing_sequence_id = wrji.common_routing_sequence_id
7730: AND nvl(bos.standard_operation_id, -9999) = nvl(bso.standard_operation_id, -9999)
7731: AND nvl(bso.operation_code, '*') = nvl(l_start_op_code, '*')
7732: AND bos.operation_seq_num = l_start_op_seq_num --2265237

Line 7763: AND txn.transaction_type_id = WSMPCNST.BONUS)

7759: WHERE wrji.header_id = l_header_id
7760: AND exists (SELECT null
7761: FROM wsm_split_merge_txn_interface txn
7762: WHERE txn.header_id = wrji.header_id
7763: AND txn.transaction_type_id = WSMPCNST.BONUS)
7764: AND bos.routing_sequence_id = wrji.common_routing_sequence_id
7765: AND nvl(bos.standard_operation_id, -9999) = nvl(bso.standard_operation_id, -9999)
7766: AND nvl(bso.operation_code, '*') = nvl(l_start_op_code, '*')
7767: -- BC: CZH.I_OED-1, check against routing revsion date

Line 7843: AND txn.transaction_type_id = WSMPCNST.BONUS);

7839: WHERE wrji.header_id = l_header_id
7840: AND exists (SELECT null
7841: FROM wsm_split_merge_txn_interface txn
7842: WHERE txn.header_id = wrji.header_id
7843: AND txn.transaction_type_id = WSMPCNST.BONUS);
7844:
7845: IF (SQL%ROWCOUNT > 0) THEN
7846: FND_MESSAGE.SET_NAME('WSM', 'WSM_MODIFIED_FIELD');
7847: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'starting_operation_seq_num in Resulting Jobs');

Line 7895: AND txn.transaction_type_id = WSMPCNST.BONUS)

7891: where wrji.header_id = l_header_id
7892: AND exists (SELECT null
7893: FROM wsm_split_merge_txn_interface txn
7894: WHERE txn.header_id = wrji.header_id
7895: AND txn.transaction_type_id = WSMPCNST.BONUS)
7896: AND bos.routing_sequence_id = wrji.common_routing_sequence_id
7897: and bos.operation_seq_num = l_start_op_seq_num
7898: -- bugfix 1746686 Validate operation effectivity
7899: -- BC: CZH.I_OED-1, check against routing revsion date

Line 7959: AND txn.transaction_type_id = WSMPCNST.BONUS);

7955: WHERE wrji.header_id = l_header_id
7956: AND exists (SELECT null
7957: FROM wsm_split_merge_txn_interface txn
7958: WHERE txn.header_id = wrji.header_id
7959: AND txn.transaction_type_id = WSMPCNST.BONUS);
7960:
7961: IF (SQL%ROWCOUNT > 0) THEN
7962: FND_MESSAGE.SET_NAME('WSM', 'WSM_MODIFIED_FIELD');
7963: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'starting_operation_code in Resulting Jobs');

Line 7998: AND txn.transaction_type_id = WSMPCNST.BONUS);

7994: WHERE wrji.header_id = l_header_id
7995: AND exists (SELECT null
7996: FROM wsm_split_merge_txn_interface txn
7997: WHERE txn.header_id = wrji.header_id
7998: AND txn.transaction_type_id = WSMPCNST.BONUS);
7999:
8000: IF (SQL%ROWCOUNT > 0) THEN
8001: FND_MESSAGE.SET_NAME('WSM', 'WSM_MODIFIED_FIELD');
8002: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'starting_std_op_id in Resulting Jobs');

Line 8039: AND txn.transaction_type_id = WSMPCNST.BONUS -- BA NSO-WLT

8035: WHERE wrji.header_id = l_header_id
8036: AND EXISTS (SELECT null
8037: FROM wsm_split_merge_txn_interface txn
8038: WHERE txn.header_id = wrji.header_id
8039: AND txn.transaction_type_id = WSMPCNST.BONUS -- BA NSO-WLT
8040: AND wrji.starting_operation_seq_num is null); -- EA NSO-WLT
8041:
8042: IF (SQL%ROWCOUNT > 0) THEN
8043: set_wrji_error(); -- WLTEnh

Line 8079: AND txn.transaction_type_id = WSMPCNST.BONUS)

8075: WHERE wrji.header_id = l_header_id
8076: AND exists (SELECT null
8077: FROM wsm_split_merge_txn_interface txn
8078: WHERE txn.header_id = wrji.header_id
8079: AND txn.transaction_type_id = WSMPCNST.BONUS)
8080: AND nvl(wrji.starting_std_op_id, -9999) = nvl(l_bos_std_op_id, -9999)
8081: AND not exists
8082: ( select 'Is Primary Path'
8083: from bom_operation_networks bon,

Line 8165: decode(txn.transaction_type_id,WSMPCNST.BONUS,1,wrji.starting_intraoperation_step)

8161: and NOT EXISTS (select null
8162: from wsm_split_merge_txn_interface txn
8163: where txn.header_id = wrji.header_id
8164: and wrji.starting_intraoperation_step =
8165: decode(txn.transaction_type_id,WSMPCNST.BONUS,1,wrji.starting_intraoperation_step)
8166: and wrji.starting_intraoperation_step in
8167: (WIP_CONSTANTS.QUEUE,
8168: WIP_CONSTANTS.TOMOVE));
8169:

Line 8208: IF (l_txn_type = WSMPCNST.UPDATE_ROUTING) THEN

8204: INTO l_txn_type
8205: FROM wsm_split_merge_txn_interface wsmti
8206: WHERE wsmti.header_id = l_header_id;
8207:
8208: IF (l_txn_type = WSMPCNST.UPDATE_ROUTING) THEN
8209: -- need to make sure that completion date
8210: -- has not been changed.
8211:
8212: l_stmt_num := 218;

Line 8542: IF (l_txn_type in ( WSMPCNST.BONUS, WSMPCNST.UPDATE_ROUTING, WSMPCNST.UPDATE_ASSEMBLY)

8538: -- INTO l_txn_type
8539: -- FROM wsm_split_merge_txn_interface wsmti
8540: -- WHERE wsmti.header_id = l_header_id;
8541:
8542: IF (l_txn_type in ( WSMPCNST.BONUS, WSMPCNST.UPDATE_ROUTING, WSMPCNST.UPDATE_ASSEMBLY)
8543: --SpUA begin
8544: OR (l_txn_type in (WSMPCNST.SPLIT) AND l_split_has_update_assy = 1)) THEN
8545: --SpUA end
8546:

Line 8544: OR (l_txn_type in (WSMPCNST.SPLIT) AND l_split_has_update_assy = 1)) THEN

8540: -- WHERE wsmti.header_id = l_header_id;
8541:
8542: IF (l_txn_type in ( WSMPCNST.BONUS, WSMPCNST.UPDATE_ROUTING, WSMPCNST.UPDATE_ASSEMBLY)
8543: --SpUA begin
8544: OR (l_txn_type in (WSMPCNST.SPLIT) AND l_split_has_update_assy = 1)) THEN
8545: --SpUA end
8546:
8547: --SpUA bugfix 3161200
8548: --This is not really a SpUA bug!! But fixed anyway. For the valid case where

Line 8558: IF (l_txn_type = WSMPCNST.BONUS) THEN

8554: l_sj_intraoperation_step number;
8555:
8556: begin
8557:
8558: IF (l_txn_type = WSMPCNST.BONUS) THEN
8559: l_sj_intraoperation_step := WIP_CONSTANTS.QUEUE;
8560: ELSE
8561: l_stmt_num := 230;
8562: select intraoperation_step

Line 8675: If l_txn_type <> WSMPCNST.BONUS Then

8671: ||'Record for Header Id '
8672: ||l_header_id
8673: ||' set to ERROR in WRJI.');
8674: -- Bug 2682603
8675: If l_txn_type <> WSMPCNST.BONUS Then
8676:
8677: l_stmt_num := 235;
8678:
8679: Update wsm_starting_jobs_interface wsji