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 WSM_RESULTING_JOBS_INTERFACE

Line 95: -- FROM wsm_resulting_jobs_interface rj,

91: -- txn.organization_id org_id,
92: -- rj.primary_item_id item_id,
93: -- rj.completion_subinventory subinv_name,
94: -- rj.rowid rj_rowid --SpUA Add
95: -- FROM wsm_resulting_jobs_interface rj,
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

Line 121: FROM wsm_resulting_jobs_interface rj,

117: rj.class_code class_code, /* ST bug fix 3150692 review comments : Added */
118: rj.primary_item_id item_id,
119: rj.completion_subinventory subinv_name,
120: rj.rowid rj_rowid --SpUA Add
121: FROM wsm_resulting_jobs_interface rj,
122: wsm_split_merge_txn_interface txn
123: WHERE rj.header_id = p_header_id
124: AND txn.header_id = rj.header_id
125: AND rj.job_type = WIP_CONSTANTS.STANDARD

Line 135: FROM wsm_resulting_jobs_interface rj,

131: SELECT rj.class_code class_code,
132: rj.job_type job_type,
133: txn.organization_id org_id,
134: rj.header_id header_id
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

Line 150: FROM wsm_resulting_jobs_interface rj,

146: txn.organization_id org_id,
147: rj.primary_item_id item_id,
148: rj.completion_subinventory subinv_name,
149: txn.transaction_type_id txn_type_id
150: FROM wsm_resulting_jobs_interface rj,
151: wsm_split_merge_txn_interface txn
152: -- WHERE rj.class_code is null -- Commented to fix bug #3150692--
153: -- AND rj.header_id = p_header_id -- Commented to fix bug #3150692--
154: WHERE rj.header_id = p_header_id

Line 169: FROM wsm_resulting_jobs_interface rj,

165: rj.net_quantity net_quantity,
166: rj.wip_entity_name,
167: /* ST : fix bug 3766859 : added job type */
168: rj.job_type
169: FROM wsm_resulting_jobs_interface rj,
170: wsm_split_merge_txn_interface txn
171: WHERE rj.net_quantity is NULL
172: AND rj.header_id = p_header_id
173: AND txn.header_id = rj.header_id

Line 186: FROM wsm_resulting_jobs_interface rj,

182:
183: CURSOR C_COPRODUCTS_SUPPLY(p_header_id NUMBER) is
184: SELECT distinct (rj.header_id) header_id,
185: txn.organization_id org_id
186: FROM wsm_resulting_jobs_interface rj,
187: wsm_split_merge_txn_interface txn
188: WHERE ( rj.coproducts_supply is NULL OR
189: rj.coproducts_supply NOT IN (1,2))
190: AND txn.header_id = rj.header_id

Line 259: | Default class_code in wsm_resulting_jobs_interface table. If |

255:
256: BEGIN
257: /*-----------------------------------------------------------------+
258: | For Standard Lot Based Jobs : |
259: | Default class_code in wsm_resulting_jobs_interface table. If |
260: | transaction type is bonus, then default the class_code as defined|
261: | in wip_parameters, otherwise, copying over the class_code from |
262: | parent lots. |
263: +-----------------------------------------------------------------*/

Line 293: -- UPDATE wsm_resulting_jobs_interface rj

289: END IF;
290:
291: IF (l_class_code IS NOT NULL ) THEN
292: l_stmt_num := 2;
293: -- UPDATE wsm_resulting_jobs_interface rj
294: -- SET class_code = l_class_code
295: -- WHERE rj.class_code is null
296: -- AND rj.header_id = c_no_class_code_rj_rec.header_id
297: -- AND EXISTS ( SELECT null

Line 318: UPDATE wsm_resulting_jobs_interface rj

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
321: -- AND rj.class_code IS NULL /* ST bug fix 3150692 Added check for class_code to prevent overwrite of user entered value for Std Bonus txn*/
322: /* ST bug fix 3150692 review comments : Commented the class code check */

Line 355: UPDATE wsm_resulting_jobs_interface wrji

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
359:

Line 427: UPDATE wsm_resulting_jobs_interface wrji

423: if p_est_scrap_account is null or p_est_scrap_var_account is null then
424: l_err_occurred := 1; --VJ: Added for NSLBJ--
425: l_stmt_num := 8;
426:
427: UPDATE wsm_resulting_jobs_interface wrji
428: SET wrji.error_message = l_fnd_generic_err_msg
429: WHERE wrji.header_id = c_vldt_class_code_rj_rec.header_id;
430:
431: FND_MESSAGE.SET_NAME('WSM', 'WSM_NO_WAC_SCRAP_ACC');

Line 454: update wsm_resulting_jobs_interface rj

450: --abb H Optional Scrap addition end
451:
452: -- for txn not in bonus
453: l_stmt_num := 9;
454: update wsm_resulting_jobs_interface rj
455: set class_code = (select dis.class_code
456: from wip_discrete_jobs dis,
457: wsm_starting_jobs_interface sj
458: where sj.header_id = rj.header_id

Line 491: | If class_code in wsm_resulting_jobs_interface table is NULL, error.|

487: END IF;
488:
489: /*-------------------------------------------------------------------+
490: | For Non-Standard Lot Based Jobs : |
491: | If class_code in wsm_resulting_jobs_interface table is NULL, error.|
492: +-------------------------------------------------------------------*/
493:
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

Line 504: UPDATE wsm_resulting_jobs_interface wrji

500: l_stmt_num := 11;
501:
502: /* ST : commeting this for bug 3722383 */
503: /* l_err_occurred := 1; --VJ: 0313: Changed position for NSLBJ-- */
504: UPDATE wsm_resulting_jobs_interface wrji
505: SET wrji.error_message = l_fnd_generic_err_msg
506: WHERE wrji.class_code is null
507: AND wrji.header_id = C_NONSTD_NO_CLASS_CODE_RJ_rec.header_id
508: AND wrji.internal_group_id = WSMPLOAD.G_GROUP_ID

Line 539: UPDATE wsm_resulting_jobs_interface wrji

535: ELSE -- if transaction <> BONUS
536: --Representative Flag would be set for one starting job in Merge,
537: --as well as for the starting job in other transactions (except Bonus)
538: l_stmt_num := 12;
539: UPDATE wsm_resulting_jobs_interface wrji
540: SET wrji.class_code = (SELECT wdj.class_code
541: FROM wip_discrete_jobs wdj,
542: wsm_starting_jobs_interface wsji
543: WHERE wsji.wip_entity_id = wdj.wip_entity_id

Line 608: UPDATE wsm_resulting_jobs_interface wrji

604: IF (sj_net_quantity < sj_scrap_quantity) THEN
605:
606: IF (c_net_quantity_rec.wip_entity_name <> sj_wip_entity_name) THEN
607: l_stmt_num := 14;
608: UPDATE wsm_resulting_jobs_interface wrji
609: SET wrji.net_quantity = 0
610: WHERE wrji.net_quantity is NULL
611: AND wrji.wip_entity_name = c_net_quantity_rec.wip_entity_name
612: AND wrji.header_id = c_net_quantity_rec.header_id;

Line 615: update wsm_resulting_jobs_interface wrji

611: AND wrji.wip_entity_name = c_net_quantity_rec.wip_entity_name
612: AND wrji.header_id = c_net_quantity_rec.header_id;
613: ELSE
614: --Start FP bugfix 3403087
615: update wsm_resulting_jobs_interface wrji
616: set wrji.net_quantity = (select wdj.net_quantity
617: from wip_discrete_jobs wdj,
618: wip_entities we
619: where wdj.wip_entity_id = we.wip_entity_id

Line 631: UPDATE wsm_resulting_jobs_interface wrji

627: ELSE
628: -- bugfix 2168797: While updating the net_quantity, round it to the 6 decimal place.
629: IF (c_net_quantity_rec.wip_entity_name <> sj_wip_entity_name) THEN
630: l_stmt_num := 15;
631: UPDATE wsm_resulting_jobs_interface wrji
632: SET wrji.net_quantity =
633: round(c_net_quantity_rec.start_quantity *
634: (sj_net_quantity-sj_scrap_quantity) *
635: (1/(sj_start_quantity-sj_scrap_quantity)), 6 )

Line 641: update wsm_resulting_jobs_interface wrji

637: AND wrji.wip_entity_name = c_net_quantity_rec.wip_entity_name
638: AND wrji.header_id = c_net_quantity_rec.header_id;
639: ELSE
640: --Start FP bugfix 3403087
641: update wsm_resulting_jobs_interface wrji
642: set wrji.net_quantity = (select wdj.net_quantity
643: from wip_discrete_jobs wdj,
644: wip_entities we
645: where wdj.wip_entity_id = we.wip_entity_id

Line 663: UPDATE wsm_resulting_jobs_interface wrji

659: if rj_net_quantity > c_net_quantity_rec.start_quantity then
660: rj_net_quantity := c_net_quantity_rec.start_quantity;
661: end if;
662:
663: UPDATE wsm_resulting_jobs_interface wrji
664: SET wrji.net_quantity = rj_net_quantity
665: WHERE wrji.net_quantity is NULL
666: AND wrji.wip_entity_name = c_net_quantity_rec.wip_entity_name
667: AND wrji.header_id = c_net_quantity_rec.header_id;

Line 700: UPDATE wsm_resulting_jobs_interface wrji

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 =
702: -- Start : Changes for bug#3181486 - Net Planned Qty --
703: -- (select (wrji.start_quantity-wdj.start_quantity+wdj.net_quantity)
704: (select (wrji.start_quantity*(wdj.net_quantity-wdj.quantity_scrapped)

Line 715: from wsm_resulting_jobs_interface wrji

711: AND wrji.header_id = c_net_quantity_rec.header_id;
712:
713: select net_quantity
714: into l_stmt_num
715: from wsm_resulting_jobs_interface wrji
716: where wrji.wip_entity_name = c_net_quantity_rec.wip_entity_name
717: and wrji.header_id = c_net_quantity_rec.header_id;
718:
719: IF (SQL%ROWCOUNT > 0) THEN

Line 768: UPDATE wsm_resulting_jobs_interface wrji

764: end if;
765:
766: IF (match_wip_entity = FALSE) THEN
767: l_stmt_num := 17;
768: UPDATE wsm_resulting_jobs_interface wrji
769: SET wrji.net_quantity = total_potential_supply
770: WHERE wrji.net_quantity is NULL
771: AND wrji.header_id = c_net_quantity_rec.header_id;
772: ELSE --Start FP bugfix 3403087

Line 773: UPDATE wsm_resulting_jobs_interface wrji

769: SET wrji.net_quantity = total_potential_supply
770: WHERE wrji.net_quantity is NULL
771: AND wrji.header_id = c_net_quantity_rec.header_id;
772: ELSE --Start FP bugfix 3403087
773: UPDATE wsm_resulting_jobs_interface wrji
774: SET wrji.net_quantity = total_potential_supply + l_quantity_scrapped
775: WHERE wrji.net_quantity is NULL
776: AND wrji.header_id = c_net_quantity_rec.header_id;
777: --End FP bugfix 3403087

Line 808: UPDATE wsm_resulting_jobs_interface wrji

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
811: ,0)
812: WHERE wrji.header_id = c_net_quantity_rec.header_id

Line 847: | it is null in wsm_resulting_jobs_interface |

843:
844:
845: /*-----------------------------------------------------------------+
846: | Default coproducts_supply from wsm_parameters if |
847: | it is null in wsm_resulting_jobs_interface |
848: +-----------------------------------------------------------------*/
849:
850:
851: FOR c_coproducts_supply_rec IN c_coproducts_supply(p_header_id) LOOP

Line 855: UPDATE wsm_resulting_jobs_interface wrji

851: FOR c_coproducts_supply_rec IN c_coproducts_supply(p_header_id) LOOP
852:
853:
854: l_stmt_num := 19;
855: UPDATE wsm_resulting_jobs_interface wrji
856: SET wrji.coproducts_supply =
857: (SELECT decode(coproducts_supply_default, NULL, 2
858: , coproducts_supply_default)
859: FROM wsm_parameters

Line 892: | Default starting_intraoperation_step in wsm_resulting_jobs_interface table. |

888: END LOOP;
889:
890:
891: /*----------------------------------------------------------------------------+
892: | Default starting_intraoperation_step in wsm_resulting_jobs_interface table. |
893: | from intraoperation_stepin wsm_starting_jobs_interface table |
894: +----------------------------------------------------------------------------*/
895:
896: l_stmt_num := 20;

Line 897: UPDATE wsm_resulting_jobs_interface rj

893: | from intraoperation_stepin wsm_starting_jobs_interface table |
894: +----------------------------------------------------------------------------*/
895:
896: l_stmt_num := 20;
897: UPDATE wsm_resulting_jobs_interface rj
898: SET rj.starting_intraoperation_step =
899: (select sj.intraoperation_step
900: from wsm_starting_jobs_interface sj
901: where sj.header_id = rj.header_id

Line 922: UPDATE wsm_resulting_jobs_interface wrji

918: /*----------------------------------------------------------+
919: | Default starting_intraoperation_step for Bonus to 'Queue' |
920: +----------------------------------------------------------*/
921: l_stmt_num := 21;
922: UPDATE wsm_resulting_jobs_interface wrji
923: SET wrji.starting_intraoperation_step = WIP_CONSTANTS.QUEUE
924: WHERE wrji.starting_intraoperation_step IS NULL
925: AND wrji.process_status = WIP_CONSTANTS.RUNNING
926: AND wrji.internal_group_id = WSMPLOAD.G_GROUP_ID

Line 946: | wsm_resulting_jobs_interface table for Bonus/Split txns. |

942: --VJ: End Additions for NSLBJ--
943:
944: /*-----------------------------------------------------------------+
945: | Default forward_op_option to 4 in |
946: | wsm_resulting_jobs_interface table for Bonus/Split txns. |
947: +-----------------------------------------------------------------*/
948:
949: l_stmt_num := 22;
950: UPDATE wsm_resulting_jobs_interface rj

Line 950: UPDATE wsm_resulting_jobs_interface rj

946: | wsm_resulting_jobs_interface table for Bonus/Split txns. |
947: +-----------------------------------------------------------------*/
948:
949: l_stmt_num := 22;
950: UPDATE wsm_resulting_jobs_interface rj
951: SET rj.forward_op_option = 4
952: WHERE rj.process_status = WIP_CONSTANTS.RUNNING
953: AND rj.internal_group_id = WSMPLOAD.G_GROUP_ID
954: AND rj.forward_op_option <> 4

Line 990: UPDATE wsm_resulting_jobs_interface rj

986: l_stmt_num := 24;
987:
988: /* ST bugfix 3336844 comment out check for locator control with MSI. populate locator_id from BOR regardless
989: the locator control, will validate it later. */
990: UPDATE wsm_resulting_jobs_interface rj
991: SET (rj.completion_subinventory,
992: rj.completion_locator_id) =
993: (SELECT bor.completion_subinventory,
994: /* decode(msi.locator_type, 1, NULL, */ /* ST bugfix 3336844 */

Line 1048: UPDATE wsm_resulting_jobs_interface rj

1044:
1045: l_stmt_num := 25;
1046: /* ST bugfix 3336844 comment out check for locator control with MSI. populate locator_id from BOR regardless
1047: the locator control, will validate it later. */
1048: UPDATE wsm_resulting_jobs_interface rj
1049: SET (rj.completion_subinventory,
1050: rj.completion_locator_id) =
1051: (SELECT wdj.completion_subinventory,
1052: /*decode(msi.locator_type, 1, NULL,*/ /* ST bug 3336844 */

Line 1100: UPDATE wsm_resulting_jobs_interface rj

1096:
1097: /* ST bugfix 3336844 comment out check for locator control with MSI. populate locator_id from BOR regardless
1098: the locator control, will validate it later. */
1099:
1100: UPDATE wsm_resulting_jobs_interface rj
1101: SET (rj.completion_subinventory,
1102: rj.completion_locator_id) =
1103: (SELECT wdj.completion_subinventory,
1104: /* decode(msi.locator_type, 1, NULL,*/ /* St bug 3336844 */

Line 1302: FROM wsm_resulting_jobs_interface rj

1298: SELECT rj.scheduled_start_date scheduled_start_date,
1299: rj.scheduled_completion_date scheduled_completion_date,rj.start_quantity,
1300: rj.organization_id org_id,
1301: rj.primary_item_id item_id
1302: FROM wsm_resulting_jobs_interface rj
1303: WHERE rj.process_status = WIP_CONSTANTS.RUNNING
1304: AND rj.internal_group_id = WSMPLOAD.G_GROUP_ID
1305: AND rj.header_id = l_header_id
1306: AND (rj.scheduled_start_date is null

Line 1322: FROM wsm_resulting_jobs_interface wrji

1318: , wrji.bom_revision
1319: , wrji.routing_revision_date
1320: , wrji.routing_revision
1321: /*EA WLTEnh */
1322: FROM wsm_resulting_jobs_interface wrji
1323: WHERE wrji.process_status = WIP_CONSTANTS.RUNNING
1324: AND wrji.internal_group_id = WSMPLOAD.G_GROUP_ID
1325: AND wrji.header_id = l_header_id
1326: AND wrji.wip_entity_name = l_we_name; --VJ: Added condition to fix bug #2315397--

Line 1359: FROM WSM_RESULTING_JOBS_INTERFACE RJ

1355: --VJ: Start Changes for NSLBJ--
1356: --Changed the sql since org_id has been added to WRJI now--
1357: CURSOR REV_CUR(p_header_id NUMBER) IS -- WLTEnh to fix incorrect update
1358: SELECT ROWIDTOCHAR(RJ.ROWID) "X_ROWID", RJ.ORGANIZATION_ID, RJ.HEADER_ID
1359: FROM WSM_RESULTING_JOBS_INTERFACE RJ
1360: WHERE RJ.HEADER_ID = p_header_id
1361: AND RJ.GROUP_ID = WSMPLOAD.G_GROUP_ID
1362: AND RJ.PROCESS_STATUS = WIP_CONSTANTS.RUNNING
1363: AND (RJ.BOM_REVISION IS NOT NULL OR RJ.BOM_REVISION_DATE IS NOT NULL)

Line 1392: WSM_RESULTING_JOBS_INTERFACE RJ

1388: TXN.TRANSACTION_ID,
1389: TXN.HEADER_ID
1390: , TXN.ORGANIZATION_ID -- 2804945
1391: FROM WSM_SPLIT_MERGE_TXN_INTERFACE TXN,
1392: WSM_RESULTING_JOBS_INTERFACE RJ
1393: WHERE TXN.INTERNAL_GROUP_ID = WSMPLOAD.G_GROUP_ID
1394: AND RJ.HEADER_ID = TXN.HEADER_ID
1395: AND TXN.header_id = WSMPLOAD.G_HEADER_ID -- XleSplits
1396: AND TXN.PROCESS_STATUS = WIP_CONSTANTS.RUNNING

Line 1467: FROM wsm_resulting_jobs_interface wrji,

1463: wrji.completion_locator_id
1464: --VJ: CodeRVW: End Additions for NSLBJ--
1465: , wrji.rowid wrji_rowid
1466: , nvl(wrji.split_has_update_assy, 0) --SpUA add
1467: FROM wsm_resulting_jobs_interface wrji,
1468: wsm_split_merge_txn_interface wsmti
1469: WHERE wrji.process_status = WIP_CONSTANTS.RUNNING
1470: AND wrji.internal_group_id = WSMPLOAD.G_GROUP_ID
1471: AND wsmti.internal_group_id = WSMPLOAD.G_GROUP_ID

Line 1782: from wsm_resulting_jobs_interface rj

1778: Begin
1779: l_stmt_num := 12;
1780:
1781: select null into l_dummy
1782: from wsm_resulting_jobs_interface rj
1783: where rj.header_id = l_cur_wsmti_rec.header_id;
1784:
1785: Exception
1786:

Line 1846: Update wsm_resulting_jobs_interface wrji

1842: End If;
1843:
1844: l_stmt_num := 16;
1845:
1846: Update wsm_resulting_jobs_interface wrji
1847: Set wrji.error_message = l_fnd_generic_err_msg
1848: , wrji.process_status = WIP_CONSTANTS.ERROR
1849: Where wrji.header_id = l_cur_wsmti_rec.header_id;
1850:

Line 3096: Update wsm_resulting_jobs_interface wrji

3092: ||l_cur_wsji_rec.wsji_header_id
3093: ||' set to ERROR in WSJI.');
3094:
3095: l_stmt_num := 56; -- Bug#2682603
3096: Update wsm_resulting_jobs_interface wrji
3097: Set wrji.error_message = l_fnd_generic_err_msg
3098: , wrji.process_status = WIP_CONSTANTS.ERROR
3099: Where wrji.header_id = l_cur_wsji_rec.wsji_header_id;
3100:

Line 3226: UPDATE wsm_resulting_jobs_interface wrji

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
3228: WHERE wrji.header_id = l_header_id
3229: AND wrji.split_has_update_assy IS NULL;
3230:

Line 3252: update wsm_resulting_jobs_interface wrji

3248: (l_split_has_update_assy NOT IN (0, 1))
3249: then
3250: l_stmt_num := 63;
3251:
3252: update wsm_resulting_jobs_interface wrji
3253: SET wrji.error_message = l_fnd_generic_err_msg
3254: , wrji.process_status = WIP_CONSTANTS.ERROR -- WLTEnh
3255: WHERE wrji.header_id = l_header_id;
3256:

Line 3286: | validate job_type in wsm_resulting_jobs_interface table: |

3282: --SpUA end
3283:
3284: --VJ: Start move following code to start of validations to fix bug #2315397--
3285: /*------------------------------------------------------------+
3286: | validate job_type in wsm_resulting_jobs_interface table: |
3287: | It should be the same as the job_types of the starting jobs |
3288: +------------------------------------------------------------*/
3289:
3290: l_stmt_num := 64;

Line 3291: update wsm_resulting_jobs_interface wrji

3287: | It should be the same as the job_types of the starting jobs |
3288: +------------------------------------------------------------*/
3289:
3290: l_stmt_num := 64;
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--

Line 3323: update wsm_resulting_jobs_interface wrji

3319: END IF;
3320:
3321: l_stmt_num := 65;
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;

Line 3384: update wsm_resulting_jobs_interface wrji

3380:
3381: IF (l_min_job_type = l_max_job_type) THEN
3382: l_stmt_num := 68;
3383:
3384: update wsm_resulting_jobs_interface wrji
3385: SET wrji.job_type = l_min_job_type
3386: WHERE wrji.header_id = l_header_id
3387: and wrji.job_type IS NULL;
3388:

Line 3410: update wsm_resulting_jobs_interface wrji

3406: END IF;
3407:
3408: l_stmt_num := 69;
3409:
3410: update wsm_resulting_jobs_interface wrji
3411: SET wrji.error_message = l_fnd_generic_err_msg
3412: , wrji.process_status = WIP_CONSTANTS.ERROR -- WLTEnh
3413: WHERE wrji.header_id = l_header_id
3414: and wrji.job_type IS NOT NULL

Line 3460: | validate organization_id in wsm_resulting_jobs_interface table |

3456:
3457: END IF;
3458:
3459: /*----------------------------------------------------------------+
3460: | validate organization_id in wsm_resulting_jobs_interface table |
3461: +-----------------------------------------------------------------*/
3462:
3463: l_stmt_num := 70;
3464: update wsm_resulting_jobs_interface wrji

Line 3464: update wsm_resulting_jobs_interface wrji

3460: | validate organization_id in wsm_resulting_jobs_interface table |
3461: +-----------------------------------------------------------------*/
3462:
3463: l_stmt_num := 70;
3464: update wsm_resulting_jobs_interface wrji
3465: SET organization_id = (SELECT organization_id
3466: FROM wsm_split_merge_txn_interface
3467: WHERE header_id = wrji.header_id
3468: AND process_status = WIP_CONSTANTS.RUNNING

Line 3498: update wsm_resulting_jobs_interface wrji

3494: END IF;
3495: END IF;
3496:
3497: l_stmt_num := 71;
3498: update wsm_resulting_jobs_interface wrji
3499: SET wrji.error_message = l_fnd_generic_err_msg
3500: WHERE wrji.header_id = l_header_id
3501: and not exists (select null
3502: from wsm_split_merge_txn_interface txn

Line 3561: update wsm_resulting_jobs_interface rj

3557:
3558: raise proc_error;
3559: END;
3560:
3561: update wsm_resulting_jobs_interface rj
3562: set scheduled_start_date = l_scheduled_start_date,
3563: scheduled_completion_date = l_scheduled_completion_date
3564: where rj.process_status = WIP_CONSTANTS.RUNNING
3565: and rj.internal_group_id = WSMPLOAD.G_GROUP_ID

Line 3633: FROM wsm_resulting_jobs_interface wrji

3629: l_net_quantity,
3630: l_class_code,
3631: l_completion_subinventory,
3632: l_completion_locator_id
3633: FROM wsm_resulting_jobs_interface wrji
3634: WHERE wrji.process_status = WIP_CONSTANTS.RUNNING
3635: AND wrji.internal_group_id = WSMPLOAD.G_GROUP_ID
3636: AND wrji.header_id = l_header_id
3637: AND wrji.wip_entity_name = l_we_name;

Line 3708: UPDATE wsm_resulting_jobs_interface

3704: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'bom_reference_id in Resulting Jobs');
3705: l_fnd_err_msg := FND_MESSAGE.GET;
3706:
3707: l_stmt_num := 78;
3708: UPDATE wsm_resulting_jobs_interface
3709: SET error_message = l_fnd_err_msg
3710: WHERE header_id = l_header_id;
3711:
3712: set_wrji_error(); -- WLTEnh

Line 3732: UPDATE wsm_resulting_jobs_interface

3728: -- Start : Added code to fix bug #3196002--
3729: ELSIF l_bom_reference_id IS NULL THEN
3730: l_stmt_num := 79;
3731:
3732: UPDATE wsm_resulting_jobs_interface
3733: SET bom_reference_id = l_wdj_bom_ref_id,
3734: alternate_bom_designator = l_wdj_alt_bom_desig,
3735: common_bom_sequence_id = l_wdj_bom_seq_id,
3736: bom_revision_date = l_wdj_bom_rev_dt,

Line 3777: UPDATE wsm_resulting_jobs_interface

3773: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'alternate_bom_designator in Resulting Jobs');
3774: l_fnd_err_msg := FND_MESSAGE.GET;
3775:
3776: l_stmt_num := 80;
3777: UPDATE wsm_resulting_jobs_interface
3778: SET error_message = l_fnd_err_msg
3779: WHERE header_id = l_header_id;
3780:
3781: set_wrji_error(); -- WLTEnh

Line 3811: UPDATE wsm_resulting_jobs_interface

3807: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'common_bom_sequence_id in Resulting Jobs');
3808: l_fnd_err_msg := FND_MESSAGE.GET;
3809:
3810: l_stmt_num := 81;
3811: UPDATE wsm_resulting_jobs_interface
3812: SET error_message = l_fnd_err_msg
3813: WHERE header_id = l_header_id;
3814:
3815: set_wrji_error(); -- WLTEnh

Line 3912: UPDATE wsm_resulting_jobs_interface

3908: (l_bom_reference_id <> l_st_bom_ref_id) OR
3909: (l_nslbj_alt_bom_desig <> l_st_alt_bom_desig) OR
3910: (l_wrji_bom_seq_id <> l_st_bom_seq_id) THEN
3911: l_stmt_num := 86;
3912: UPDATE wsm_resulting_jobs_interface
3913: SET bom_reference_id = l_st_bom_ref_id,
3914: alternate_bom_designator = l_st_alt_bom_desig,
3915: common_bom_sequence_id = l_st_bom_seq_id
3916: WHERE header_id = l_header_id

Line 3944: UPDATE wsm_resulting_jobs_interface

3940: (l_routing_reference_id <> l_st_rtg_ref_id) OR
3941: (l_nslbj_alt_rtg_desig <> l_st_alt_rtg_desig) OR
3942: (l_wrji_rtg_seq_id <> l_st_rtg_seq_id) THEN
3943: l_stmt_num := 87;
3944: UPDATE wsm_resulting_jobs_interface
3945: SET routing_reference_id = l_st_rtg_ref_id,
3946: alternate_routing_designator = l_st_alt_rtg_desig,
3947: common_routing_sequence_id = l_st_rtg_seq_id
3948: WHERE header_id = l_header_id

Line 4061: UPDATE wsm_resulting_jobs_interface

4057: IF (p_err_num <> 0) THEN
4058:
4059: FND_FILE.PUT_LINE(FND_FILE.LOG,'WSMPUTIL.validate_non_std_references returned error');
4060: l_stmt_num := 89;
4061: UPDATE wsm_resulting_jobs_interface
4062: SET error_message = p_err_msg
4063: where header_id = l_header_id
4064: and rowid = l_wrji_rowid; --SpUA add
4065:

Line 4086: UPDATE wsm_resulting_jobs_interface

4082: FND_FILE.PUT_LINE(FND_FILE.LOG,'WSMPUTIL.validate_non_std_references returned success');
4083:
4084: IF (l_wrji_rtg_seq_id = -1 AND l_nsj_routing_seq_id IS NOT NULL) THEN
4085: l_stmt_num := 90;
4086: UPDATE wsm_resulting_jobs_interface
4087: SET common_routing_sequence_id = l_nsj_routing_seq_id
4088: WHERE header_id = l_header_id
4089: AND rowid = l_wrji_rowid; --SpUA add
4090:

Line 4114: UPDATE wsm_resulting_jobs_interface wrji

4110: END IF;
4111:
4112: ELSIF (l_wrji_rtg_seq_id <> l_nsj_routing_seq_id) THEN
4113: l_stmt_num := 91;
4114: UPDATE wsm_resulting_jobs_interface wrji
4115: SET wrji.error_message = l_fnd_generic_err_msg
4116: WHERE header_id = l_header_id
4117: AND rowid = l_wrji_rowid; --SpUA add
4118:

Line 4143: UPDATE wsm_resulting_jobs_interface

4139: END IF;
4140:
4141: IF (l_wrji_bom_seq_id = -1 AND l_nsj_bom_seq_id <> -1) THEN
4142: l_stmt_num := 92;
4143: UPDATE wsm_resulting_jobs_interface
4144: SET common_bom_sequence_id = l_nsj_bom_seq_id
4145: WHERE header_id = l_header_id
4146: AND rowid = l_wrji_rowid; --SpUA add
4147:

Line 4170: UPDATE wsm_resulting_jobs_interface wrji

4166:
4167: ELSIF ( (l_wrji_bom_seq_id <> l_nsj_bom_seq_id) AND
4168: (l_nsj_bom_seq_id <> -1) ) THEN
4169: l_stmt_num := 93;
4170: UPDATE wsm_resulting_jobs_interface wrji
4171: SET wrji.error_message = l_fnd_generic_err_msg
4172: WHERE header_id = l_header_id
4173: AND rowid = l_wrji_rowid; --SpUA add
4174:

Line 4243: FROM wsm_resulting_jobs_interface wrji

4239: l_net_quantity,
4240: l_class_code,
4241: l_completion_subinventory,
4242: l_completion_locator_id
4243: FROM wsm_resulting_jobs_interface wrji
4244: WHERE wrji.process_status = WIP_CONSTANTS.RUNNING
4245: AND wrji.internal_group_id = WSMPLOAD.G_GROUP_ID
4246: AND wrji.header_id = l_header_id
4247: AND wrji.wip_entity_name = l_we_name;

Line 4266: UPDATE wsm_resulting_jobs_interface wrji

4262: | it is the same as the representative lot. |
4263: +-----------------------------------------------------------------*/
4264:
4265: l_stmt_num := 96;
4266: UPDATE wsm_resulting_jobs_interface wrji
4267: SET wrji.error_message = l_fnd_generic_err_msg
4268: WHERE wrji.header_id = l_header_id
4269: AND EXISTS (select 1
4270: FROM wip_entities we,

Line 4304: UPDATE wsm_resulting_jobs_interface wrji

4300: | no scheduled start date and no scheduled completion date |
4301: +-----------------------------------------------------------------*/
4302:
4303: l_stmt_num := 97;
4304: UPDATE wsm_resulting_jobs_interface wrji
4305: SET wrji.error_message = l_fnd_generic_err_msg
4306: WHERE wrji.header_id = l_header_id
4307: AND wrji.SCHEDULED_START_DATE IS NULL
4308: AND wrji.SCHEDULED_COMPLETION_DATE IS NULL;

Line 4357: UPDATE wsm_resulting_jobs_interface wrji

4353: x_err_msg => p_err_msg);
4354:
4355: l_stmt_num := 99;
4356:
4357: UPDATE wsm_resulting_jobs_interface wrji
4358: SET wrji.scheduled_completion_date = l_sch_completion_date
4359: WHERE wrji.internal_group_id = WSMPLOAD.G_GROUP_ID
4360: AND wrji.header_id = l_header_id;
4361:

Line 4402: UPDATE wsm_resulting_jobs_interface wrji

4398: x_err_msg => p_err_msg);
4399:
4400: l_stmt_num := 101;
4401:
4402: UPDATE wsm_resulting_jobs_interface wrji
4403: SET wrji.scheduled_start_date = l_sch_start_date
4404: WHERE wrji.internal_group_id = WSMPLOAD.G_GROUP_ID
4405: AND wrji.header_id = l_header_id;
4406:

Line 4442: UPDATE wsm_resulting_jobs_interface wrji

4438: | Verify that scheduled_completion_date comes after scheduled_start_date|
4439: +----------------------------------------------------------------------*/
4440:
4441: l_stmt_num := 102;
4442: UPDATE wsm_resulting_jobs_interface wrji
4443: SET wrji.error_message = l_fnd_generic_err_msg
4444: WHERE wrji.header_id = l_header_id
4445: AND wrji.SCHEDULED_START_DATE is not null
4446: AND wrji.SCHEDULED_COMPLETION_DATE is not null

Line 4471: | validate header_id in wsm_resulting_jobs_interface table |

4467: END IF;
4468:
4469:
4470: /*-----------------------------------------------------------------+
4471: | validate header_id in wsm_resulting_jobs_interface table |
4472: +-----------------------------------------------------------------*/
4473:
4474: l_stmt_num := 103;
4475: UPDATE wsm_resulting_jobs_interface wrji

Line 4475: UPDATE wsm_resulting_jobs_interface wrji

4471: | validate header_id in wsm_resulting_jobs_interface table |
4472: +-----------------------------------------------------------------*/
4473:
4474: l_stmt_num := 103;
4475: UPDATE wsm_resulting_jobs_interface wrji
4476: SET wrji.error_message = l_fnd_generic_err_msg
4477: WHERE wrji.header_id = l_header_id
4478: and not exists (select null
4479: from wsm_split_merge_txn_interface txn

Line 4508: | validate that wip_entity_name in wsm_resulting_jobs_interface |

4504: --VJ: Start Additions for NSLBJ--
4505:
4506:
4507: /*-----------------------------------------------------------------+
4508: | validate that wip_entity_name in wsm_resulting_jobs_interface |
4509: | table has a maximum length of 30 characters. |
4510: +-----------------------------------------------------------------*/
4511:
4512: l_stmt_num := 104;

Line 4513: UPDATE wsm_resulting_jobs_interface wrji

4509: | table has a maximum length of 30 characters. |
4510: +-----------------------------------------------------------------*/
4511:
4512: l_stmt_num := 104;
4513: UPDATE wsm_resulting_jobs_interface wrji
4514: SET wrji.error_message = l_fnd_generic_err_msg
4515: WHERE header_id = l_header_id
4516: AND wip_entity_name IS NOT NULL
4517: AND length(wip_entity_name) > 30;

Line 4545: | validate wip_entity_name in wsm_resulting_jobs_interface table: |

4541: --VJ: End Additions for NSLBJ--
4542:
4543:
4544: /*-----------------------------------------------------------------+
4545: | validate wip_entity_name in wsm_resulting_jobs_interface table: |
4546: | wip_entity_name cannot duplicate existing job name except when |
4547: | the job name is also a starting lot. |
4548: +-----------------------------------------------------------------*/
4549:

Line 4561: UPDATE wsm_resulting_jobs_interface wrji

4557: ||'; WSMPLOAD.G_HEADER_ID='||WSMPLOAD.G_HEADER_ID);
4558: End If;
4559: l_stmt_num := 106;
4560:
4561: UPDATE wsm_resulting_jobs_interface wrji
4562: SET wrji.error_message = l_fnd_generic_err_msg
4563: WHERE wrji.header_id = l_header_id
4564: and exists (select null
4565: from wip_discrete_jobs_all_v we

Line 4601: | validate wip_entity_name in wsm_resulting_jobs_interface table: |

4597: END IF;
4598:
4599:
4600: /*-----------------------------------------------------------------+
4601: | validate wip_entity_name in wsm_resulting_jobs_interface table: |
4602: | wip_entity_name must be the same as the starting job name when |
4603: | doing updates. |
4604: +-----------------------------------------------------------------*/
4605:

Line 4607: UPDATE wsm_resulting_jobs_interface wrji

4603: | doing updates. |
4604: +-----------------------------------------------------------------*/
4605:
4606: l_stmt_num := 107;
4607: UPDATE wsm_resulting_jobs_interface wrji
4608: SET wrji.error_message = l_fnd_generic_err_msg
4609: WHERE wrji.header_id = l_header_id
4610: and not exists ((select null
4611: from wsm_starting_jobs_interface sj,

Line 4690: | validate wip_entity_name in wsm_resulting_jobs_interface table: |

4686: --VJ: End Additions to fix bug #2352364--
4687:
4688: --VJ: Start Additions for NSLBJ--
4689: /*-----------------------------------------------------------------+
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

Line 4698: from wsm_resulting_jobs_interface

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
4699: where header_id = l_header_id
4700: and wip_entity_name = l_job_name;
4701:
4702: IF (l_count > 1) THEN

Line 4727: | validate primary_item_id in wsm_resulting_jobs_interface table |

4723: END IF;
4724: --VJ: End Additions for NSLBJ--
4725:
4726: /*-----------------------------------------------------------------+
4727: | validate primary_item_id in wsm_resulting_jobs_interface table |
4728: +-----------------------------------------------------------------*/
4729:
4730: l_stmt_num := 110;
4731: UPDATE wsm_resulting_jobs_interface wrji

Line 4731: UPDATE wsm_resulting_jobs_interface wrji

4727: | validate primary_item_id in wsm_resulting_jobs_interface table |
4728: +-----------------------------------------------------------------*/
4729:
4730: l_stmt_num := 110;
4731: UPDATE wsm_resulting_jobs_interface wrji
4732: SET wrji.error_message = l_fnd_generic_err_msg
4733: WHERE wrji.header_id = l_header_id
4734: and not exists (select null
4735: from mtl_system_items mtl,

Line 4782: | validate primary_item_id in wsm_resulting_jobs_interface table

4778:
4779: -- bug 1882366 start changes
4780:
4781: /*-----------------------------------------------------------------+
4782: | validate primary_item_id in wsm_resulting_jobs_interface table
4783: | is lot controlled
4784: +-----------------------------------------------------------------*/
4785:
4786: l_stmt_num := 111;

Line 4787: UPDATE wsm_resulting_jobs_interface wrji

4783: | is lot controlled
4784: +-----------------------------------------------------------------*/
4785:
4786: l_stmt_num := 111;
4787: UPDATE wsm_resulting_jobs_interface wrji
4788: SET wrji.error_message = l_fnd_generic_err_msg
4789: WHERE wrji.header_id = l_header_id
4790: and not exists (select null
4791: from mtl_system_items mtl,

Line 4834: | validate primary_item_id in wsm_resulting_jobs_interface table

4830: END IF;
4831:
4832:
4833: /*-----------------------------------------------------------------+
4834: | validate primary_item_id in wsm_resulting_jobs_interface table
4835: | is not serial controlled
4836: +-----------------------------------------------------------------*/
4837:
4838: l_stmt_num := 112;

Line 4839: UPDATE wsm_resulting_jobs_interface wrji

4835: | is not serial controlled
4836: +-----------------------------------------------------------------*/
4837:
4838: l_stmt_num := 112;
4839: UPDATE wsm_resulting_jobs_interface wrji
4840: SET wrji.error_message = l_fnd_generic_err_msg
4841: WHERE wrji.header_id = l_header_id
4842: and not exists (select null
4843: from mtl_system_items mtl,

Line 4894: UPDATE wsm_resulting_jobs_interface wrji

4890: | if transaction is update assembly. |
4891: +-----------------------------------------------------------------*/
4892:
4893: l_stmt_num := 113;
4894: UPDATE wsm_resulting_jobs_interface wrji
4895: SET wrji.error_message = l_fnd_generic_err_msg
4896: WHERE wrji.header_id = l_header_id
4897: and exists (select null
4898: from wsm_starting_jobs_interface sj,

Line 4929: | Validate bonus account in wsm_resulting_jobs_interface table |

4925: END IF;
4926:
4927:
4928: /*-----------------------------------------------------------------+
4929: | Validate bonus account in wsm_resulting_jobs_interface table |
4930: +-----------------------------------------------------------------*/
4931:
4932: l_stmt_num := 114;
4933: UPDATE wsm_resulting_jobs_interface wrji

Line 4933: UPDATE wsm_resulting_jobs_interface wrji

4929: | Validate bonus account in wsm_resulting_jobs_interface table |
4930: +-----------------------------------------------------------------*/
4931:
4932: l_stmt_num := 114;
4933: UPDATE wsm_resulting_jobs_interface wrji
4934: SET wrji.error_message = l_fnd_generic_err_msg
4935: WHERE wrji.header_id = l_header_id
4936: and not exists (select 1
4937: from gl_code_combinations gcc,

Line 4982: | validate start_quantity in wsm_resulting_jobs_interface table |

4978: END IF;
4979:
4980:
4981: /*-----------------------------------------------------------------+
4982: | validate start_quantity in wsm_resulting_jobs_interface table |
4983: +-----------------------------------------------------------------*/
4984:
4985: l_stmt_num := 115;
4986: UPDATE wsm_resulting_jobs_interface wrji

Line 4986: UPDATE wsm_resulting_jobs_interface wrji

4982: | validate start_quantity in wsm_resulting_jobs_interface table |
4983: +-----------------------------------------------------------------*/
4984:
4985: l_stmt_num := 115;
4986: UPDATE wsm_resulting_jobs_interface wrji
4987: SET wrji.error_message = l_fnd_generic_err_msg
4988: WHERE wrji.header_id = l_header_id
4989: and ( (wrji.start_quantity < 0 OR nvl(wrji.start_quantity,0) = 0)
4990: or (exists (select null

Line 5037: UPDATE wsm_resulting_jobs_interface wrji

5033: AND wsji.wip_entity_id = wdj.wip_entity_id;
5034:
5035: l_stmt_num := 118;
5036:
5037: UPDATE wsm_resulting_jobs_interface wrji
5038: SET wrji.start_quantity = l_wdj_st_qty
5039: WHERE wrji.header_id = l_header_id
5040: AND wrji.start_quantity <> l_wdj_st_qty;
5041:

Line 5075: UPDATE wsm_resulting_jobs_interface wrji

5071:
5072: l_stmt_num := 119;
5073: IF (l_job_type = WIP_CONSTANTS.STANDARD) THEN
5074: l_stmt_num := 120;
5075: UPDATE wsm_resulting_jobs_interface wrji
5076: SET routing_reference_id = NULL,
5077: bom_reference_id = NULL
5078: WHERE wrji.header_id = l_header_id
5079: AND wrji.job_type = WIP_CONSTANTS.STANDARD --VJ: Added for NSLBJ--

Line 5148: UPDATE wsm_resulting_jobs_interface wrji

5144:
5145: --VJ: Start Additions for NSLBJ--
5146: --Also a fix for bug #2265237--
5147: l_stmt_num := 123;
5148: UPDATE wsm_resulting_jobs_interface wrji
5149: SET wrji.error_message = l_fnd_generic_err_msg
5150: WHERE wrji.header_id = l_header_id
5151: AND wrji.rowid = l_wrji_rowid;
5152: --VJ: End Additions for NSLBJ--

Line 5157: FND_MESSAGE.SET_TOKEN('TABLE_NAME', 'WSM_RESULTING_JOBS_INTERFACE');

5153:
5154: set_wrji_error(); -- WLTEnh
5155:
5156: FND_MESSAGE.SET_NAME('WSM', 'WSM_INVALID_ROUTING_ID');
5157: FND_MESSAGE.SET_TOKEN('TABLE_NAME', 'WSM_RESULTING_JOBS_INTERFACE');
5158: l_fnd_err_msg := FND_MESSAGE.GET;
5159: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): '||l_fnd_err_msg);
5160:
5161: WSMPUTIL.AUTONOMOUS_WRITE_TO_WIE (p_header_id => l_header_id,

Line 5182: UPDATE wsm_resulting_jobs_interface wrji

5178:
5179: --VJ: Start Additions for NSLBJ--
5180: --Also a fix for bug #2265237--
5181: l_stmt_num := 124;
5182: UPDATE wsm_resulting_jobs_interface wrji
5183: SET wrji.error_message = l_fnd_generic_err_msg
5184: WHERE wrji.header_id = l_header_id
5185: AND wrji.rowid = l_wrji_rowid;
5186: --VJ: End Additions for NSLBJ--

Line 5191: FND_MESSAGE.SET_TOKEN('TABLE_NAME', 'WSM_RESULTING_JOBS_INTERFACE');

5187:
5188: set_wrji_error(); -- WLTEnh
5189:
5190: FND_MESSAGE.SET_NAME('WSM', 'WSM_INVALID_ALT_RTG_DESIG');
5191: FND_MESSAGE.SET_TOKEN('TABLE_NAME', 'WSM_RESULTING_JOBS_INTERFACE');
5192: l_fnd_err_msg := FND_MESSAGE.GET;
5193: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): '||l_fnd_err_msg);
5194:
5195: WSMPUTIL.AUTONOMOUS_WRITE_TO_WIE (p_header_id => l_header_id,

Line 5210: UPDATE wsm_resulting_jobs_interface wrji

5206: end if;
5207:
5208: if (l_wrji_rtg_seq_id = -1) then
5209: l_stmt_num := 125;
5210: UPDATE wsm_resulting_jobs_interface wrji
5211: SET common_routing_sequence_id=l_rtg_seq_id
5212: WHERE wrji.process_status = WIP_CONSTANTS.RUNNING
5213: AND wrji.header_id=l_header_id
5214: AND wrji.rowid = l_wrji_rowid;

Line 5242: UPDATE wsm_resulting_jobs_interface wrji

5238: if ((l_wrji_alt_rtg_desig = '-1') and
5239: (l_alt_rtg_desig <> '-1'))
5240: then
5241: l_stmt_num := 126;
5242: UPDATE wsm_resulting_jobs_interface wrji
5243: SET alternate_routing_designator=l_alt_rtg_desig
5244: WHERE wrji.process_status = WIP_CONSTANTS.RUNNING
5245: AND wrji.job_type = WIP_CONSTANTS.STANDARD --VJ: Added for NSLBJ--
5246: AND wrji.header_id=l_header_id

Line 5275: UPDATE wsm_resulting_jobs_interface wrji

5271: if ((l_wrji_alt_rtg_desig <> '-1') and
5272: (l_alt_rtg_desig = '-1'))
5273: then
5274: l_stmt_num := 127;
5275: UPDATE wsm_resulting_jobs_interface wrji
5276: SET alternate_routing_designator=NULL
5277: WHERE wrji.process_status = WIP_CONSTANTS.RUNNING
5278: AND wrji.job_type = WIP_CONSTANTS.STANDARD --VJ: Added for NSLBJ--
5279: AND wrji.header_id=l_header_id

Line 5310: UPDATE wsm_resulting_jobs_interface wrji

5306: if ((l_wrji_rtg_seq_id=-1) and
5307: (l_wrji_alt_rtg_desig='-1'))
5308: then
5309: l_stmt_num := 128;
5310: UPDATE wsm_resulting_jobs_interface wrji
5311: SET common_routing_sequence_id=
5312: (select bor.common_routing_sequence_id
5313: from bom_operational_routings bor
5314: where bor.assembly_item_id = decode(wrji.job_type,

Line 5345: UPDATE wsm_resulting_jobs_interface wrji

5341:
5342: elsif ((l_wrji_rtg_seq_id<>-1) and
5343: (l_wrji_alt_rtg_desig<>'-1')) then
5344: l_stmt_num := 129;
5345: UPDATE wsm_resulting_jobs_interface wrji
5346: SET wrji.error_message = l_fnd_generic_err_msg
5347: WHERE wrji.header_id = l_header_id
5348: AND wrji.rowid = l_wrji_rowid --SpUA add
5349: AND wrji.job_type = WIP_CONSTANTS.STANDARD --VJ: Added for NSLBJ--

Line 5383: UPDATE wsm_resulting_jobs_interface wrji

5379: elsif ( (l_wrji_rtg_seq_id<>-1) and
5380: (l_wrji_alt_rtg_desig='-1')) then
5381:
5382: l_stmt_num := 130;
5383: UPDATE wsm_resulting_jobs_interface wrji
5384: SET wrji.error_message = l_fnd_generic_err_msg
5385: WHERE wrji.header_id = l_header_id
5386: AND wrji.rowid = l_wrji_rowid --SpUA add
5387: AND wrji.job_type = WIP_CONSTANTS.STANDARD --VJ: Added for NSLBJ--

Line 5397: UPDATE wsm_resulting_jobs_interface wrji

5393: and bor.cfm_routing_flag=3);
5394:
5395: if (SQL%ROWCOUNT=0) then
5396: l_stmt_num := 131;
5397: UPDATE wsm_resulting_jobs_interface wrji
5398: SET wrji.alternate_routing_designator =
5399: (select bor.alternate_routing_designator
5400: from bom_operational_routings bor
5401: where bor.routing_sequence_id = wrji.common_routing_sequence_id

Line 5432: FND_MESSAGE.SET_TOKEN('TABLE_NAME', 'WSM_RESULTING_JOBS_INTERFACE');

5428:
5429: set_wrji_error(); -- WLTEnh
5430:
5431: FND_MESSAGE.SET_NAME('WSM', 'WSM_INVALID_ROUTING_ID');
5432: FND_MESSAGE.SET_TOKEN('TABLE_NAME', 'WSM_RESULTING_JOBS_INTERFACE');
5433: l_fnd_err_msg := FND_MESSAGE.GET;
5434: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): '||l_fnd_err_msg);
5435:
5436: WSMPUTIL.AUTONOMOUS_WRITE_TO_WIE (p_header_id => l_header_id,

Line 5453: UPDATE wsm_resulting_jobs_interface wrji

5449: elsif ( (l_wrji_rtg_seq_id=-1) and
5450: (l_wrji_alt_rtg_desig<>'-1')) then
5451:
5452: l_stmt_num := 132;
5453: UPDATE wsm_resulting_jobs_interface wrji
5454: SET wrji.error_message = l_fnd_generic_err_msg
5455: WHERE wrji.header_id = l_header_id
5456: AND wrji.rowid = l_wrji_rowid --SpUA add
5457: AND wrji.job_type = WIP_CONSTANTS.STANDARD --VJ: Added for NSLBJ--

Line 5467: UPDATE wsm_resulting_jobs_interface wrji

5463: and bor.cfm_routing_flag=3);
5464:
5465: if (SQL%ROWCOUNT=0) then
5466: l_stmt_num := 133;
5467: UPDATE wsm_resulting_jobs_interface wrji
5468: SET wrji.common_routing_sequence_id =
5469: (select bor.common_routing_sequence_id
5470: from bom_operational_routings bor
5471: where bor.alternate_routing_designator = wrji.alternate_routing_designator

Line 5534: FROM wsm_resulting_jobs_interface

5530: and wsji.header_id=l_header_id;
5531:
5532: SELECT nvl(common_routing_sequence_id, -1), nvl(alternate_routing_designator, '-1')
5533: INTO l_wrji_rtg_seq_id, l_wrji_alt_rtg_desig
5534: FROM wsm_resulting_jobs_interface
5535: WHERE header_id = l_header_id;
5536:
5537: --Start: Additions for APS-WLT--
5538: BOM_REVISIONS.Get_Revision(

Line 5566: UPDATE wsm_resulting_jobs_interface

5562:
5563: END IF;
5564:
5565: l_stmt_num := 135;
5566: UPDATE wsm_resulting_jobs_interface
5567: SET routing_revision = l_rtg_rev,
5568: routing_revision_date = l_rtg_rev_date
5569: WHERE header_id = l_header_id;
5570: --End: Additions for APS-WLT--

Line 5612: UPDATE wsm_resulting_jobs_interface rj

5608: -- !!!!!!!! this might be a temp fix
5609: l_stmt_num := 136;
5610: /* ST bugfix 3336844 (2793501) commenting out check for locator control in MSI. Instead, populate locator_id from BOR
5611: --regardless of the locator control type. We will validate the locator info later.*/
5612: UPDATE wsm_resulting_jobs_interface rj
5613: SET (rj.completion_subinventory,
5614: rj.completion_locator_id) =
5615: (SELECT bor.completion_subinventory,
5616: /*decode(msi.locator_type, 1, NULL,*/ /*ST bug fix 3336844 */

Line 5733: update wsm_resulting_jobs_interface wrji

5729: );
5730:
5731: /* ST bug fix 3493984 Update the resulting job interface */
5732: l_stmt_num := 139.1;
5733: update wsm_resulting_jobs_interface wrji
5734: set routing_revision_date = l_rtg_rev_date,
5735: routing_revision = l_rtg_rev
5736: where wrji.header_id = l_header_id
5737: and wrji.rowid = l_wrji_rowid;

Line 5819: FROM wsm_resulting_jobs_interface

5815: l_stmt_num := 141;
5816: --BA: CZH.I_OED-1, validate routing information here
5817: SELECT nvl(common_routing_sequence_id, -1)
5818: INTO l_wrji_rtg_seq_id
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

Line 5860: from wsm_resulting_jobs_interface wrji

5856: -- IN WSMFJLTX.fmb, we check if the primary path is effective here,
5857: -- IF starting_operation_seq_num is specified.
5858: select wrji.starting_operation_seq_num
5859: into l_wrji_starting_op_seq_num
5860: from wsm_resulting_jobs_interface wrji
5861: where wrji.header_id = l_header_id;
5862:
5863: -- Check if the primary path is effective
5864: IF(l_wrji_starting_op_seq_num IS NOT NULL

Line 5948: wsm_resulting_jobs_interface rj,

5944: l_bos_stdop_id,
5945: l_sj_intraoperation_step, -- BBK:NSO:WLT
5946: l_rj_rout_seq_id --VJ: Added for NSLBJ--
5947: FROM bom_operation_sequences bos,
5948: wsm_resulting_jobs_interface rj,
5949: wsm_starting_jobs_interface sj,
5950: wip_operations wo
5951: WHERE sj.header_id = l_header_id
5952: AND rj.rowid = l_wrji_rowid --SpUA add

Line 6053: UPDATE wsm_resulting_jobs_interface wrji

6049:
6050: -- Start: Additions to fix bug #3154541--
6051: IF( l_execute_this = 2) THEN
6052: l_stmt_num := 150;
6053: UPDATE wsm_resulting_jobs_interface wrji
6054: SET wrji.error_message = l_fnd_generic_err_msg
6055: WHERE wrji.header_id = l_header_id
6056: AND wrji.rowid = l_wrji_rowid
6057: AND wrji.starting_operation_seq_num IS NULL

Line 6084: UPDATE wsm_resulting_jobs_interface wrji

6080:
6081: -- End: Additions to fix bug #3154541--
6082: ELSIF( l_execute_this = 1) THEN -- Added to fix bug #3196985--
6083: l_stmt_num := 151;
6084: UPDATE wsm_resulting_jobs_interface wrji
6085: SET starting_operation_seq_num = l_bos_opseq_num,
6086: starting_operation_code = l_bso_stdop_code
6087: WHERE wrji.header_id = l_header_id
6088: and wrji.rowid = l_wrji_rowid --SpUA add

Line 6154: UPDATE wsm_resulting_jobs_interface wrji

6150: and l_profile_value = 2) Then
6151: --End SpUA bugfix 3161493
6152:
6153: l_stmt_num := 152;
6154: UPDATE wsm_resulting_jobs_interface wrji
6155: SET starting_operation_seq_num = NULL,
6156: starting_operation_code = NULL
6157: WHERE wrji.header_id = l_header_id
6158: AND wrji.rowid = l_wrji_rowid --SpUA add

Line 6246: UPDATE wsm_resulting_jobs_interface wrji

6242:
6243: --VJ: Start Additions for NSLBJ--
6244: --Also a fix for bug #2265237--
6245: l_stmt_num := 155;
6246: UPDATE wsm_resulting_jobs_interface wrji
6247: SET wrji.error_message = l_fnd_generic_err_msg
6248: WHERE wrji.header_id = l_header_id
6249: AND wrji.job_type = WIP_CONSTANTS.STANDARD
6250: AND wrji.rowid = l_wrji_rowid;

Line 6281: UPDATE wsm_resulting_jobs_interface wrji

6277:
6278: --VJ: Start Additions for NSLBJ--
6279: --Also a fix for bug #2265237--
6280: l_stmt_num := 156;
6281: UPDATE wsm_resulting_jobs_interface wrji
6282: SET wrji.error_message = l_fnd_generic_err_msg
6283: WHERE wrji.header_id = l_header_id
6284: AND wrji.job_type = WIP_CONSTANTS.STANDARD
6285: AND wrji.rowid = l_wrji_rowid;

Line 6310: UPDATE wsm_resulting_jobs_interface wrji

6306: end if;
6307:
6308: if (l_wrji_bom_seq_id = -1) then
6309: l_stmt_num := 157;
6310: UPDATE wsm_resulting_jobs_interface wrji
6311: SET common_bom_sequence_id=l_bom_seq_id
6312: WHERE wrji.process_status = WIP_CONSTANTS.RUNNING
6313: AND wrji.header_id=l_header_id
6314: AND wrji.job_type = WIP_CONSTANTS.STANDARD --VJ: Added for NSLBJ--

Line 6341: UPDATE wsm_resulting_jobs_interface wrji

6337: if ((l_wrji_alt_bom_desig = '-1') and (l_alt_bom_desig <> '-1'))
6338: then
6339:
6340: l_stmt_num := 158;
6341: UPDATE wsm_resulting_jobs_interface wrji
6342: SET alternate_bom_designator=l_alt_bom_desig
6343: WHERE wrji.process_status = WIP_CONSTANTS.RUNNING
6344: AND wrji.header_id=l_header_id
6345: AND wrji.job_type = WIP_CONSTANTS.STANDARD --VJ: Added for NSLBJ--

Line 6374: UPDATE wsm_resulting_jobs_interface wrji

6370: (l_alt_bom_desig = '-1'))
6371: then
6372:
6373: l_stmt_num := 159;
6374: UPDATE wsm_resulting_jobs_interface wrji
6375: SET alternate_bom_designator=NULL
6376: WHERE wrji.process_status = WIP_CONSTANTS.RUNNING
6377: AND wrji.header_id=l_header_id
6378: AND wrji.job_type = WIP_CONSTANTS.STANDARD --VJ: Added for NSLBJ--

Line 6421: UPDATE wsm_resulting_jobs_interface wrji

6417: -- user populated NULL for WRJI common_bom_sequence_id, alternate_bom_designator --
6418: -----------------------------------------------------------------------------------
6419: then
6420: l_stmt_num := 161;
6421: UPDATE wsm_resulting_jobs_interface wrji
6422: SET common_bom_sequence_id=
6423: (select bom.common_bill_sequence_id
6424: from bom_bill_of_materials bom,
6425: mtl_system_items msi --bugfix 1828859

Line 6467: UPDATE wsm_resulting_jobs_interface wrji

6463: elsif ( (l_wrji_bom_seq_id<>-1) and
6464: (l_wrji_alt_bom_desig<>'-1')) then
6465:
6466: l_stmt_num := 162;
6467: UPDATE wsm_resulting_jobs_interface wrji
6468: SET wrji.error_message = l_fnd_generic_err_msg
6469: WHERE wrji.header_id = l_header_id
6470: AND wrji.rowid = l_wrji_rowid --SpUA add
6471: AND wrji.job_type = WIP_CONSTANTS.STANDARD --VJ: Added for NSLBJ--

Line 6509: UPDATE wsm_resulting_jobs_interface wrji

6505: elsif ( (l_wrji_bom_seq_id<>-1) and
6506: (l_wrji_alt_bom_desig='-1')) then
6507:
6508: l_stmt_num := 163;
6509: UPDATE wsm_resulting_jobs_interface wrji
6510: SET wrji.error_message = l_fnd_generic_err_msg
6511: WHERE wrji.header_id = l_header_id
6512: AND wrji.rowid = l_wrji_rowid --SpUA add
6513: AND wrji.job_type = WIP_CONSTANTS.STANDARD --VJ: Added for NSLBJ--

Line 6528: UPDATE wsm_resulting_jobs_interface wrji

6524: -- and bom.assembly_type=1); --endfix
6525:
6526: if (SQL%ROWCOUNT=0) then
6527: l_stmt_num := 164;
6528: UPDATE wsm_resulting_jobs_interface wrji
6529: SET wrji.alternate_bom_designator = (select bom.alternate_bom_designator
6530: from bom_bill_of_materials bom,
6531: mtl_system_items msi --bugfix 1828859
6532: where bom.bill_sequence_id = wrji.common_bom_sequence_id

Line 6588: UPDATE wsm_resulting_jobs_interface wrji

6584: elsif ((l_wrji_bom_seq_id=-1) and
6585: (l_wrji_alt_bom_desig<>'-1')) then
6586:
6587: l_stmt_num := 165;
6588: UPDATE wsm_resulting_jobs_interface wrji
6589: SET wrji.error_message = l_fnd_generic_err_msg
6590: WHERE wrji.header_id = l_header_id
6591: AND wrji.rowid = l_wrji_rowid --SpUA add
6592: AND wrji.job_type = WIP_CONSTANTS.STANDARD --VJ: Added for NSLBJ--

Line 6607: UPDATE wsm_resulting_jobs_interface wrji

6603: -- and bom.assembly_type=1); --endfix
6604:
6605: if (SQL%ROWCOUNT=0) then
6606: l_stmt_num := 166;
6607: UPDATE wsm_resulting_jobs_interface wrji
6608: SET wrji.common_bom_sequence_id = (select bom.common_bill_sequence_id
6609: from bom_bill_of_materials bom,
6610: mtl_system_items msi --bugfix 1828859
6611: where bom.alternate_bom_designator = wrji.alternate_bom_designator

Line 6678: FROM wsm_resulting_jobs_interface

6674: l_stmt_num := 168;
6675:
6676: SELECT nvl(common_bom_sequence_id, -1), nvl(alternate_bom_designator, '-1')
6677: INTO l_wrji_bom_seq_id, l_wrji_alt_bom_desig
6678: FROM wsm_resulting_jobs_interface
6679: WHERE header_id = l_header_id;
6680:
6681: If (l_debug = 'Y') Then
6682: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): '||

Line 6692: UPDATE wsm_resulting_jobs_interface wrji

6688:
6689: IF((l_bom_seq_id <> l_wrji_bom_seq_id) OR
6690: (l_alt_bom_desig <> l_wrji_alt_bom_desig)) THEN
6691: l_stmt_num := 169;
6692: UPDATE wsm_resulting_jobs_interface wrji
6693: SET common_bom_sequence_id = l_bom_seq_id,
6694: alternate_bom_designator = l_alt_bom_desig
6695: WHERE wrji.header_id = l_header_id;
6696:

Line 6723: | validate alternate routing in wsm_resulting_jobs_interface table |

6719: /*EA#1623701*/
6720:
6721:
6722: /*-----------------------------------------------------------------+
6723: | validate alternate routing in wsm_resulting_jobs_interface table |
6724: +-----------------------------------------------------------------*/
6725:
6726: l_stmt_num := 170;
6727: --VJ: Start Changes for NSLBJ--

Line 6730: UPDATE wsm_resulting_jobs_interface wrji

6726: l_stmt_num := 170;
6727: --VJ: Start Changes for NSLBJ--
6728: --Changed the sql since org_id has been added to WRJI now--
6729:
6730: UPDATE wsm_resulting_jobs_interface wrji
6731: SET wrji.error_message = l_fnd_generic_err_msg
6732: WHERE wrji.header_id = l_header_id
6733: AND wrji.job_type = WIP_CONSTANTS.STANDARD --VJ: Added for NSLBJ--
6734: and not exists (select null

Line 6768: | validate alternate bill in wsm_resulting_jobs_interface table |

6764: END IF;
6765:
6766:
6767: /*--------------------------------------------------------------+
6768: | validate alternate bill in wsm_resulting_jobs_interface table |
6769: +--------------------------------------------------------------*/
6770:
6771: l_stmt_num := 171;
6772:

Line 6775: UPDATE wsm_resulting_jobs_interface wrji

6771: l_stmt_num := 171;
6772:
6773: --VJ: Start Changes for NSLBJ--
6774: --Changed the sql since org_id has been added to WRJI now--
6775: UPDATE wsm_resulting_jobs_interface wrji
6776: SET wrji.error_message = l_fnd_generic_err_msg
6777: WHERE wrji.header_id = l_header_id
6778: AND wrji.job_type = WIP_CONSTANTS.STANDARD --VJ: Added for NSLBJ--
6779: and not exists

Line 6876: UPDATE WSM_RESULTING_JOBS_INTERFACE WRJI

6872: ', l_routing_rev='||l_routing_rev);
6873: End If;
6874:
6875: l_stmt_num := 174;
6876: UPDATE WSM_RESULTING_JOBS_INTERFACE WRJI
6877: SET WRJI.routing_revision = l_routing_rev,
6878: WRJI.routing_revision_date = l_rev_date
6879: WHERE WRJI.header_id = l_header_id
6880: AND WRJI.wip_entity_name = c_bom_rtg_revision_rec.we_name

Line 6961: UPDATE WSM_RESULTING_JOBS_INTERFACE WRJI

6957: ', l_bom_revision ='||l_bom_revision);
6958: End If;
6959:
6960: l_stmt_num := 178;
6961: UPDATE WSM_RESULTING_JOBS_INTERFACE WRJI
6962: SET WRJI.bom_revision = l_bom_revision,
6963: WRJI.bom_revision_date = l_bom_revision_date
6964: WHERE WRJI.header_id = l_header_id
6965: AND WRJI.wip_entity_name = c_bom_rtg_revision_rec.we_name;

Line 6999: | in wsm_resulting_jobs_interface table |

6995:
6996:
6997: /*-------------------------------------------------+
6998: | validate routing_revision/routing_revision_date |
6999: | in wsm_resulting_jobs_interface table |
7000: +-------------------------------------------------*/
7001:
7002: l_stmt_num := 179;
7003: --VJ: Start Changes for NSLBJ--

Line 7005: UPDATE wsm_resulting_jobs_interface wrji

7001:
7002: l_stmt_num := 179;
7003: --VJ: Start Changes for NSLBJ--
7004: --Changed the sql since org_id has been added to WRJI now--
7005: UPDATE wsm_resulting_jobs_interface wrji
7006: SET wrji.error_message = l_fnd_generic_err_msg
7007: WHERE wrji.header_id = l_header_id
7008: AND wrji.job_type = WIP_CONSTANTS.STANDARD --VJ: Added for NSLBJ--
7009: and not exists (select null

Line 7052: | in wsm_resulting_jobs_interface table |

7048:
7049:
7050: /*-----------------------------------------+
7051: | validate bom_revision/bom_revision_date |
7052: | in wsm_resulting_jobs_interface table |
7053: +-----------------------------------------*/
7054:
7055: /* ST : 3712972 validation not required as the check will be done in wip_revisions.bom_revision
7056: BEGIN

Line 7063: wsm_resulting_jobs_interface RJ

7059: BEGIN
7060: l_stmt_num := 180;
7061: SELECT REV_REC.HEADER_ID INTO l_temp
7062: FROM mtl_item_rev_highdate_v MIR ,
7063: wsm_resulting_jobs_interface RJ
7064: WHERE MIR.ORGANIZATION_ID = REV_REC.ORGANIZATION_ID
7065: AND RJ.ROWID = chartorowid(REV_REC.X_ROWID)
7066: AND MIR.INVENTORY_ITEM_ID = RJ.PRIMARY_ITEM_ID
7067: AND ( (MIR.REVISION = nvl(RJ.BOM_REVISION, MIR.REVISION))

Line 7078: UPDATE wsm_resulting_jobs_interface

7074: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'bill revision in Resulting Jobs');
7075: l_fnd_err_msg := FND_MESSAGE.GET;
7076:
7077: l_stmt_num := 181;
7078: UPDATE wsm_resulting_jobs_interface
7079: SET error_message = l_fnd_err_msg
7080: WHERE ROWID = chartorowid(REV_REC.X_ROWID);
7081:
7082: IF (SQL%ROWCOUNT > 0) THEN

Line 7169: wsm_resulting_jobs_interface wrji,

7165: , l_organization_id
7166: , l_sj_intraoperation_step
7167: from
7168: bom_operational_routings bor,
7169: wsm_resulting_jobs_interface wrji,
7170: wsm_starting_jobs_interface wsji
7171: where
7172: bor.assembly_item_id = wrji.primary_item_id
7173: and nvl(bor.alternate_routing_designator, '*') = nvl(wrji.alternate_routing_designator, '*')

Line 7201: wsm_resulting_jobs_interface wrji,

7197: l_start_std_op_id
7198: , l_organization_id
7199: , l_sj_intraoperation_step
7200: from
7201: wsm_resulting_jobs_interface wrji,
7202: wsm_starting_jobs_interface wsji
7203: where
7204: wrji.header_id = l_header_id
7205: and wrji.rowid = l_wrji_rowid --SpUA add

Line 7305: UPDATE wsm_resulting_jobs_interface wrji

7301: and bos.operation_type = 1
7302: and bos.STANDARD_OPERATION_ID = l_start_std_op_id;
7303: --BA: BUGFIX 2686319 get the start_op_seq_num
7304: l_stmt_num := 191;
7305: UPDATE wsm_resulting_jobs_interface wrji
7306: SET starting_std_op_id = l_start_std_op_id,
7307: starting_operation_seq_num = l_start_op_seq_num, -- ADD: BUGFIX 2686319
7308: starting_operation_code = l_start_op_code
7309: WHERE wrji.header_id = l_header_id

Line 7386: UPDATE wsm_resulting_jobs_interface

7382:
7383: l_stmt_num := 193;
7384: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): '||l_fnd_err_msg);
7385:
7386: UPDATE wsm_resulting_jobs_interface
7387: SET error_message = l_fnd_err_msg
7388: WHERE header_id = l_header_id
7389: AND rowid = l_wrji_rowid; --SpUA add
7390:

Line 7433: UPDATE wsm_resulting_jobs_interface wrji

7429:
7430: l_stmt_num := 194;
7431: --VJ: Start Changes for NSLBJ--
7432: --Changed the sql since org_id has been added to WRJI now--
7433: UPDATE wsm_resulting_jobs_interface wrji
7434: SET wrji.error_message = l_fnd_generic_err_msg
7435: WHERE wrji.header_id = l_header_id
7436: AND exists (SELECT null
7437: FROM wsm_split_merge_txn_interface txn

Line 7501: FROM wsm_resulting_jobs_interface wrji

7497:
7498: l_stmt_num := 195;
7499: SELECT count(*)
7500: INTO l_count
7501: FROM wsm_resulting_jobs_interface wrji
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

Line 7522: FROM wsm_resulting_jobs_interface wrji

7518: wrji.starting_operation_seq_num
7519: INTO l_start_std_op_id,
7520: l_start_op_code,
7521: l_start_op_seq_num
7522: FROM wsm_resulting_jobs_interface wrji
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

Line 7558: UPDATE wsm_resulting_jobs_interface

7554: IF (p_err_num <> 0) THEN
7555:
7556: FND_FILE.PUT_LINE(FND_FILE.LOG,'WSMPUTIL.find_routing_start returned error');
7557: l_stmt_num := 198;
7558: UPDATE wsm_resulting_jobs_interface
7559: SET error_message = p_err_msg
7560: where header_id = l_header_id;
7561:
7562: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): '||p_err_msg);

Line 7608: UPDATE wsm_resulting_jobs_interface wrji

7604: ', l_bos_std_op_id='||l_bos_std_op_id||
7605: ', l_bso_op_code='||l_bso_op_code);
7606: END IF;
7607:
7608: UPDATE wsm_resulting_jobs_interface wrji
7609: SET wrji.starting_operation_seq_num = l_bos_op_seq_num,
7610: wrji.starting_operation_code = l_bso_op_code,
7611: wrji.starting_std_op_id = l_bos_std_op_id
7612: WHERE wrji.header_id = l_header_id;

Line 7663: from wsm_resulting_jobs_interface wrji

7659: --VJ: Start Changes for NSLBJ--
7660: --Changed the sql since org_id has been added to WRJI now--
7661: select wrji.common_routing_sequence_id, wrji.organization_id
7662: into l_rl_rtg_seq_id, l_organization_id
7663: from wsm_resulting_jobs_interface wrji
7664: where wrji.header_id = l_header_id;
7665: --VJ: End Changes for NSLBJ--
7666:
7667:

Line 7689: UPDATE wsm_resulting_jobs_interface wsji

7685: l_fnd_err_msg := ' FAILURE: This operation code does not belong to a std op or this std op is repeated';
7686: fnd_file.put_line(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): '||l_fnd_err_msg);
7687:
7688: l_stmt_num := 204;
7689: UPDATE wsm_resulting_jobs_interface wsji
7690: SET wsji.error_message = l_fnd_generic_err_msg
7691: WHERE wsji.header_id = l_header_id
7692: and wip_entity_name = l_job_name;
7693:

Line 7723: wsm_resulting_jobs_interface wrji

7719: INTO l_bos_op_seq_id,
7720: l_bos_std_op_id
7721: FROM bom_standard_operations bso,
7722: bom_operation_sequences bos,
7723: wsm_resulting_jobs_interface wrji
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

Line 7758: wsm_resulting_jobs_interface wrji

7754: l_bos_op_seq_id,
7755: l_bos_std_op_id
7756: FROM bom_standard_operations bso,
7757: bom_operation_sequences bos,
7758: wsm_resulting_jobs_interface wrji
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

Line 7778: UPDATE wsm_resulting_jobs_interface wrji

7774: -- EC: CZH.I_OED-1
7775:
7776: -- BA: BUG 2686319 update WRJI with starting_operation_seq_num
7777: l_stmt_num := 207;
7778: UPDATE wsm_resulting_jobs_interface wrji
7779: SET starting_operation_seq_num = l_bos_op_seq_num
7780: WHERE wrji.header_id = l_header_id
7781: and wrji.process_status = WIP_CONSTANTS.RUNNING
7782: and wrji.internal_group_id = WSMPLOAD.G_GROUP_ID;

Line 7804: UPDATE wsm_resulting_jobs_interface wsji

7800:
7801: --Start Additions to fix bug #2265237--
7802: --Whenever there's error, error_message column in interface table should be updated.
7803: l_stmt_num := 208;
7804: UPDATE wsm_resulting_jobs_interface wsji
7805: SET wsji.error_message = l_fnd_generic_err_msg
7806: WHERE wsji.header_id = l_header_id
7807: and wip_entity_name = l_job_name;
7808: --End Additions to fix bug #2265237--

Line 7837: UPDATE wsm_resulting_jobs_interface wrji

7833: '): l_start_op_seq_num = '||l_start_op_seq_num||
7834: ' l_bos_op_seq_num = '||l_bos_op_seq_num);
7835: END IF;
7836:
7837: UPDATE wsm_resulting_jobs_interface wrji
7838: SET wrji.starting_operation_seq_num = l_bos_op_seq_num
7839: WHERE wrji.header_id = l_header_id
7840: AND exists (SELECT null
7841: FROM wsm_split_merge_txn_interface txn

Line 7890: wsm_resulting_jobs_interface wrji

7886: bos.standard_operation_id
7887: INTO l_bos_op_seq_id,
7888: l_bos_std_op_id
7889: FROM bom_operation_sequences bos,
7890: wsm_resulting_jobs_interface wrji
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

Line 7953: UPDATE wsm_resulting_jobs_interface wrji

7949: '): l_start_op_code <> l_bso_op_code');
7950: END IF;
7951:
7952: l_stmt_num := 212;
7953: UPDATE wsm_resulting_jobs_interface wrji
7954: SET wrji.starting_operation_code = l_bso_op_code
7955: WHERE wrji.header_id = l_header_id
7956: AND exists (SELECT null
7957: FROM wsm_split_merge_txn_interface txn

Line 7992: UPDATE wsm_resulting_jobs_interface wrji

7988: -- EA NSO-WLT
7989:
7990:
7991: l_stmt_num := 213;
7992: UPDATE wsm_resulting_jobs_interface wrji
7993: SET wrji.starting_std_op_id = l_bos_std_op_id
7994: WHERE wrji.header_id = l_header_id
7995: AND exists (SELECT null
7996: FROM wsm_split_merge_txn_interface txn

Line 8033: UPDATE wsm_resulting_jobs_interface wrji

8029: +-----------------------------------------------------------------*/
8030:
8031:
8032: l_stmt_num := 214;
8033: UPDATE wsm_resulting_jobs_interface wrji
8034: SET wrji.error_message = l_fnd_generic_err_msg
8035: WHERE wrji.header_id = l_header_id
8036: AND EXISTS (SELECT null
8037: FROM wsm_split_merge_txn_interface txn

Line 8073: UPDATE wsm_resulting_jobs_interface wrji

8069: +-----------------------------------------------------------------*/
8070:
8071: -- BA NSO-WLT
8072: l_stmt_num := 215;
8073: UPDATE wsm_resulting_jobs_interface wrji
8074: SET wrji.error_message = l_fnd_generic_err_msg
8075: WHERE wrji.header_id = l_header_id
8076: AND exists (SELECT null
8077: FROM wsm_split_merge_txn_interface txn

Line 8151: | wsm_resulting_jobs_interface table: For bonus lot, intraoperation|

8147:
8148:
8149: /*-----------------------------------------------------------------+
8150: | validate starting_intraoperation_step in |
8151: | wsm_resulting_jobs_interface table: For bonus lot, intraoperation|
8152: | step must be queue. For the other transaction type, intra- |
8153: | operation step must be queue or to move. |
8154: +-----------------------------------------------------------------*/
8155:

Line 8157: UPDATE wsm_resulting_jobs_interface wrji

8153: | operation step must be queue or to move. |
8154: +-----------------------------------------------------------------*/
8155:
8156: l_stmt_num := 216;
8157: UPDATE wsm_resulting_jobs_interface wrji
8158: SET wrji.error_message = l_fnd_generic_err_msg
8159: WHERE wrji.header_id = l_header_id
8160: and wrji.starting_intraoperation_step is not null
8161: and NOT EXISTS (select null

Line 8221: UPDATE wsm_resulting_jobs_interface wrji

8217: WHERE wdj.wip_entity_id = wsji.wip_entity_id
8218: AND wsji.header_id = l_header_id;
8219:
8220: l_stmt_num := 219;
8221: UPDATE wsm_resulting_jobs_interface wrji
8222: SET scheduled_completion_date = l_sch_comp_date
8223: WHERE wrji.header_id = l_header_id
8224: AND scheduled_completion_date <> l_sch_comp_date;
8225:

Line 8267: from wsm_resulting_jobs_interface

8263: select completion_subinventory,
8264: completion_locator_id /*ST bug fix 3336844 nvl(completion_locator_id, -1)*/
8265: into l_comp_sub_inv_r,
8266: l_comp_loc_id_r
8267: from wsm_resulting_jobs_interface
8268: where header_id = l_header_id
8269: and wip_entity_name = l_job_name;
8270:
8271: IF (l_debug = 'Y') THEN

Line 8288: UPDATE wsm_resulting_jobs_interface

8284: l_fnd_err_msg := FND_MESSAGE.GET;
8285: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): '||l_fnd_err_msg);
8286: l_stmt_num := 221;
8287:
8288: UPDATE wsm_resulting_jobs_interface
8289: SET error_message = l_fnd_generic_err_msg
8290: where header_id = l_header_id
8291: and wip_entity_name = l_job_name;
8292:

Line 8326: UPDATE wsm_resulting_jobs_interface

8322: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'Completion Subinventory in Resulting jobs');
8323: l_fnd_err_msg := FND_MESSAGE.GET;
8324: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): '||l_fnd_err_msg);
8325:
8326: UPDATE wsm_resulting_jobs_interface
8327: SET error_message = l_fnd_generic_err_msg
8328: where header_id = l_header_id
8329: and wip_entity_name = l_job_name;
8330:

Line 8392: UPDATE wsm_resulting_jobs_interface

8388: 'Completion Subinventory and Locator combination in Resulting jobs');
8389: l_fnd_err_msg := FND_MESSAGE.GET;
8390: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): '||l_fnd_err_msg);
8391:
8392: UPDATE wsm_resulting_jobs_interface
8393: SET error_message = l_fnd_generic_err_msg
8394: where header_id = l_header_id
8395: and wip_entity_name = l_job_name;
8396:

Line 8435: UPDATE wsm_resulting_jobs_interface

8431: 'Completion Locator ID in Resulting jobs');
8432: l_fnd_err_msg := FND_MESSAGE.GET;
8433: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): '||l_fnd_err_msg);
8434:
8435: UPDATE wsm_resulting_jobs_interface
8436: SET error_message = l_fnd_generic_err_msg
8437: where header_id = l_header_id
8438: and wip_entity_name = l_job_name;
8439:

Line 8472: UPDATE wsm_resulting_jobs_interface

8468: 'Completion Subinventory and Locator combination in Resulting jobs');
8469: l_fnd_err_msg := FND_MESSAGE.GET;
8470: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): '||l_fnd_err_msg);
8471:
8472: UPDATE wsm_resulting_jobs_interface
8473: SET error_message = l_fnd_generic_err_msg
8474: where header_id = l_header_id
8475: and wip_entity_name = l_job_name;
8476:

Line 8495: UPDATE wsm_resulting_jobs_interface wrji

8491:
8492: elsif(l_comp_loc_id_r <> -1) then
8493: -- locator_type <>2, will ignore the completion_locator_id
8494: l_stmt_num := 228;
8495: UPDATE wsm_resulting_jobs_interface wrji
8496: SET wrji.completion_locator_id = NULL
8497: where header_id = l_header_id
8498: and wip_entity_name = l_job_name;
8499:

Line 8576: from wsm_resulting_jobs_interface wrji

8572:
8573: l_stmt_num := 231;
8574: select wrji.starting_operation_seq_num
8575: into l_osp_start_op_seq_id
8576: from wsm_resulting_jobs_interface wrji
8577: where wrji.header_id = l_header_id
8578: and wrji.rowid = l_wrji_rowid; --SpUA add
8579:
8580: l_stmt_num := 232;

Line 8588: wsm_resulting_jobs_interface wrji

8584:
8585: select unique WSMPUTIL.replacement_op_seq_id ( operation_sequence_id,l_rtg_rev_date)
8586: into l_osp_start_op_seq_id
8587: from bom_operation_sequences bos,
8588: wsm_resulting_jobs_interface wrji
8589: where wrji.header_id = l_header_id
8590: and wrji.rowid = l_wrji_rowid --SpUA add
8591: and bos.routing_sequence_id = wrji.common_routing_sequence_id
8592: and bos.operation_seq_num = wrji.starting_operation_seq_num ;

Line 8663: UPDATE wsm_resulting_jobs_interface wrji

8659:
8660: If l_wrji_error_flag = 1 Then -- UPDATE WSMTI
8661:
8662: l_stmt_num := 234;
8663: UPDATE wsm_resulting_jobs_interface wrji
8664: SET wrji.error_message = l_fnd_generic_err_msg
8665: , wrji.process_status = WIP_CONSTANTS.ERROR
8666: where wrji.header_id = l_header_id
8667: and wrji.wip_entity_name = NVL(l_job_name, wrji.wip_entity_name);

Line 8750: UPDATE WSM_RESULTING_JOBS_INTERFACE wrji

8746: ||l_header_id
8747: ||' set to ERROR in WSJI for wip_entity_id='||l_wip_id);
8748:
8749: l_stmt_num := 239;
8750: UPDATE WSM_RESULTING_JOBS_INTERFACE wrji
8751: SET wrji.error_message = l_fnd_generic_err_msg
8752: , wrji.process_status = WIP_CONSTANTS.ERROR
8753: WHERE wrji.header_id = l_header_id;
8754:

Line 8812: UPDATE WSM_RESULTING_JOBS_INTERFACE wrji

8808: ||l_header_id
8809: ||' set to ERROR in WSJI for wip_entity_id='||l_wip_id);
8810:
8811: l_stmt_num := 243;
8812: UPDATE WSM_RESULTING_JOBS_INTERFACE wrji
8813: SET wrji.error_message = l_fnd_generic_err_msg
8814: , wrji.process_status = WIP_CONSTANTS.ERROR
8815: WHERE wrji.header_id = l_header_id;
8816:

Line 8876: UPDATE WSM_RESULTING_JOBS_INTERFACE wrji

8872: ||l_header_id
8873: ||' set to ERROR in WSJI for wip_entity_id='||l_wip_id);
8874:
8875: l_stmt_num := 247;
8876: UPDATE WSM_RESULTING_JOBS_INTERFACE wrji
8877: SET wrji.error_message = l_fnd_generic_err_msg
8878: , wrji.process_status = WIP_CONSTANTS.ERROR
8879: WHERE wrji.header_id = l_header_id;
8880:

Line 8937: UPDATE WSM_RESULTING_JOBS_INTERFACE wrji

8933: IF (wsmputil.check_wmti(null,l_job_name, l_txn_date, p_err_num, p_err_msg, l_organization_id) <> 0) THEN
8934: FND_FILE.PUT_LINE(FND_FILE.LOG,'check_wmti returned error:Pending move txn in this lot');
8935:
8936: l_stmt_num := 250;
8937: UPDATE WSM_RESULTING_JOBS_INTERFACE wrji
8938: SET wrji.error_message = l_fnd_generic_err_msg
8939: , wrji.process_status = WIP_CONSTANTS.ERROR
8940: WHERE wrji.header_id = l_header_id
8941: AND wrji.WIP_ENTITY_NAME = l_job_name;

Line 9000: UPDATE WSM_RESULTING_JOBS_INTERFACE wrji

8996: FND_FILE.PUT_LINE(FND_FILE.LOG,'check_wsmt returned error:Pending wip lot txns in this lot');
8997: END IF;
8998:
8999: l_stmt_num := 254;
9000: UPDATE WSM_RESULTING_JOBS_INTERFACE wrji
9001: SET wrji.error_message = l_fnd_generic_err_msg
9002: , wrji.process_status = WIP_CONSTANTS.ERROR
9003: WHERE wrji.header_id = l_header_id
9004: AND wrji.WIP_ENTITY_NAME = l_job_name;

Line 9064: UPDATE WSM_RESULTING_JOBS_INTERFACE wrji

9060: FND_FILE.PUT_LINE(FND_FILE.LOG,'check_wlmti returned error:Pending wip move interface txns in this lot');
9061: END IF;
9062:
9063: l_stmt_num := 258;
9064: UPDATE WSM_RESULTING_JOBS_INTERFACE wrji
9065: SET wrji.error_message = l_fnd_generic_err_msg
9066: , wrji.process_status = WIP_CONSTANTS.ERROR
9067: WHERE wrji.header_id = l_header_id
9068: AND wrji.WIP_ENTITY_NAME = l_job_name;

Line 9136: UPDATE wsm_resulting_jobs_interface wrji

9132: +-----------------------------------------------------------------*/
9133:
9134: l_stmt_num := 261;
9135:
9136: UPDATE wsm_resulting_jobs_interface wrji
9137: SET wrji.error_message = l_fnd_generic_err_msg
9138: WHERE wrji.header_id = l_header_id
9139: and (wrji.net_quantity < 0 --fixed as a part of bug #2352369
9140: -- and (wrji.net_quantity <= 0

Line 9179: -- FROM wsm_resulting_jobs_interface

9175: -- Start : Changes for bug #3421662--
9176: BEGIN
9177: -- SELECT nvl(starting_operation_seq_num, -1), starting_operation_code
9178: -- INTO l_wrji_starting_op_seq_num, l_wrji_starting_op_code
9179: -- FROM wsm_resulting_jobs_interface
9180: -- WHERE header_id = l_header_id
9181: -- AND rowid = l_wrji_rowid;
9182:
9183: SELECT nvl(wrji.starting_operation_seq_num, -1), wrji.starting_operation_code

Line 9185: FROM wsm_resulting_jobs_interface wrji,

9181: -- AND rowid = l_wrji_rowid;
9182:
9183: SELECT nvl(wrji.starting_operation_seq_num, -1), wrji.starting_operation_code
9184: INTO l_wrji_starting_op_seq_num, l_wrji_starting_op_code
9185: FROM wsm_resulting_jobs_interface wrji,
9186: wsm_split_merge_txn_interface wsmti
9187: WHERE wrji.header_id = l_header_id
9188: AND wsmti.header_id = wrji.header_id
9189: AND (wsmti.transaction_type_id in (3,5) -- Upd rtg/assy

Line 9247: FROM wsm_resulting_jobs_interface

9243: UPDATE wsm_split_merge_txn_interface
9244: SET error_message = l_fnd_err_msg -- error_message = error_message || l_fnd_err_msg
9245: , process_status = WIP_CONSTANTS.ERROR -- WLTEnh
9246: WHERE header_id IN ( SELECT distinct header_id
9247: FROM wsm_resulting_jobs_interface
9248: WHERE error_message IS NOT NULL)
9249: AND process_status = WIP_CONSTANTS.RUNNING;
9250:
9251: