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 FND_MESSAGE

Line 266: FND_MESSAGE.SET_NAME('WSM', 'WSM_ERRORS_IN_WIE');

262: | parent lots. |
263: +-----------------------------------------------------------------*/
264:
265: p_err_num := 0;
266: FND_MESSAGE.SET_NAME('WSM', 'WSM_ERRORS_IN_WIE');
267: l_fnd_generic_err_msg := FND_MESSAGE.GET;
268:
269: l_wrji_rowid := p_wrji_rowid; --SpUA
270:

Line 267: l_fnd_generic_err_msg := FND_MESSAGE.GET;

263: +-----------------------------------------------------------------*/
264:
265: p_err_num := 0;
266: FND_MESSAGE.SET_NAME('WSM', 'WSM_ERRORS_IN_WIE');
267: l_fnd_generic_err_msg := FND_MESSAGE.GET;
268:
269: l_wrji_rowid := p_wrji_rowid; --SpUA
270:
271:

Line 329: FND_MESSAGE.SET_NAME('WSM', 'WSM_MODIFIED_FIELD');

325: AND rj.process_status = WIP_CONSTANTS.RUNNING;
326:
327:
328: IF (SQL%ROWCOUNT > 0) and l_debug = 'Y' THEN
329: FND_MESSAGE.SET_NAME('WSM', 'WSM_MODIFIED_FIELD');
330: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'class_code in Resulting Jobs');
331: l_fnd_err_msg := FND_MESSAGE.GET;
332: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.POPULATE_COLUMNS('||l_stmt_num||'): '||l_fnd_err_msg);
333:

Line 330: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'class_code in Resulting Jobs');

326:
327:
328: IF (SQL%ROWCOUNT > 0) and l_debug = 'Y' THEN
329: FND_MESSAGE.SET_NAME('WSM', 'WSM_MODIFIED_FIELD');
330: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'class_code in Resulting Jobs');
331: l_fnd_err_msg := FND_MESSAGE.GET;
332: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.POPULATE_COLUMNS('||l_stmt_num||'): '||l_fnd_err_msg);
333:
334: WSMPUTIL.AUTONOMOUS_WRITE_TO_WIE (

Line 331: l_fnd_err_msg := FND_MESSAGE.GET;

327:
328: IF (SQL%ROWCOUNT > 0) and l_debug = 'Y' THEN
329: FND_MESSAGE.SET_NAME('WSM', 'WSM_MODIFIED_FIELD');
330: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'class_code in Resulting Jobs');
331: l_fnd_err_msg := FND_MESSAGE.GET;
332: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.POPULATE_COLUMNS('||l_stmt_num||'): '||l_fnd_err_msg);
333:
334: WSMPUTIL.AUTONOMOUS_WRITE_TO_WIE (
335: p_header_id => c_no_class_code_rj_rec.header_id,

Line 381: FND_MESSAGE.SET_NAME('WSM', 'WSM_NULL_FIELD');

377: AND wrji.rowid = c_no_class_code_rj_rec.rj_rowid --SpUA add
378: AND wrji.internal_group_id = WSMPLOAD.G_GROUP_ID
379: AND wrji.process_status = WIP_CONSTANTS.RUNNING;
380:
381: FND_MESSAGE.SET_NAME('WSM', 'WSM_NULL_FIELD');
382: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'class_code');
383: l_fnd_err_msg := FND_MESSAGE.GET;
384: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.POPULATE_COLUMNS('||l_stmt_num||'): '||l_fnd_err_msg);
385:

Line 382: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'class_code');

378: AND wrji.internal_group_id = WSMPLOAD.G_GROUP_ID
379: AND wrji.process_status = WIP_CONSTANTS.RUNNING;
380:
381: FND_MESSAGE.SET_NAME('WSM', 'WSM_NULL_FIELD');
382: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'class_code');
383: l_fnd_err_msg := FND_MESSAGE.GET;
384: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.POPULATE_COLUMNS('||l_stmt_num||'): '||l_fnd_err_msg);
385:
386: WSMPUTIL.AUTONOMOUS_WRITE_TO_WIE (p_header_id => c_no_class_code_rj_rec.header_id,

Line 383: l_fnd_err_msg := FND_MESSAGE.GET;

379: AND wrji.process_status = WIP_CONSTANTS.RUNNING;
380:
381: FND_MESSAGE.SET_NAME('WSM', 'WSM_NULL_FIELD');
382: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'class_code');
383: l_fnd_err_msg := FND_MESSAGE.GET;
384: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.POPULATE_COLUMNS('||l_stmt_num||'): '||l_fnd_err_msg);
385:
386: WSMPUTIL.AUTONOMOUS_WRITE_TO_WIE (p_header_id => c_no_class_code_rj_rec.header_id,
387: p_message => substr(l_fnd_err_msg,1,2000),

Line 431: FND_MESSAGE.SET_NAME('WSM', 'WSM_NO_WAC_SCRAP_ACC');

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');
432: FND_MESSAGE.SET_TOKEN('CC', c_vldt_class_code_rj_rec.class_code);
433: l_fnd_err_msg := FND_MESSAGE.GET;
434: FND_FILE.PUT_LINE(FND_FILE.LOG,'WSMPVLDT.POPULATE_COLUMNS('||l_stmt_num||'): '||l_fnd_err_msg);
435: WSMPUTIL.AUTONOMOUS_WRITE_TO_WIE (p_header_id => c_vldt_class_code_rj_rec.header_id,

Line 432: FND_MESSAGE.SET_TOKEN('CC', c_vldt_class_code_rj_rec.class_code);

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');
432: FND_MESSAGE.SET_TOKEN('CC', c_vldt_class_code_rj_rec.class_code);
433: l_fnd_err_msg := FND_MESSAGE.GET;
434: FND_FILE.PUT_LINE(FND_FILE.LOG,'WSMPVLDT.POPULATE_COLUMNS('||l_stmt_num||'): '||l_fnd_err_msg);
435: WSMPUTIL.AUTONOMOUS_WRITE_TO_WIE (p_header_id => c_vldt_class_code_rj_rec.header_id,
436: p_message => substr(l_fnd_err_msg,1,2000),

Line 433: l_fnd_err_msg := FND_MESSAGE.GET;

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');
432: FND_MESSAGE.SET_TOKEN('CC', c_vldt_class_code_rj_rec.class_code);
433: l_fnd_err_msg := FND_MESSAGE.GET;
434: FND_FILE.PUT_LINE(FND_FILE.LOG,'WSMPVLDT.POPULATE_COLUMNS('||l_stmt_num||'): '||l_fnd_err_msg);
435: WSMPUTIL.AUTONOMOUS_WRITE_TO_WIE (p_header_id => c_vldt_class_code_rj_rec.header_id,
436: p_message => substr(l_fnd_err_msg,1,2000),
437: p_request_id => fnd_global.conc_request_id,

Line 483: FND_MESSAGE.SET_NAME('WSM', 'WSM_MODIFIED_FIELD');

479: -- --SpUA end
480: -- End : Fix for bug #3150692 --
481:
482: IF (SQL%ROWCOUNT > 0) and l_debug = 'Y' THEN
483: FND_MESSAGE.SET_NAME('WSM', 'WSM_MODIFIED_FIELD');
484: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'class_code in Resulting Jobs');
485: l_fnd_err_msg := FND_MESSAGE.GET;
486: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.POPULATE_COLUMNS('||l_stmt_num||'): '||l_fnd_err_msg);
487: END IF;

Line 484: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'class_code in Resulting Jobs');

480: -- End : Fix for bug #3150692 --
481:
482: IF (SQL%ROWCOUNT > 0) and l_debug = 'Y' THEN
483: FND_MESSAGE.SET_NAME('WSM', 'WSM_MODIFIED_FIELD');
484: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'class_code in Resulting Jobs');
485: l_fnd_err_msg := FND_MESSAGE.GET;
486: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.POPULATE_COLUMNS('||l_stmt_num||'): '||l_fnd_err_msg);
487: END IF;
488:

Line 485: l_fnd_err_msg := FND_MESSAGE.GET;

481:
482: IF (SQL%ROWCOUNT > 0) and l_debug = 'Y' THEN
483: FND_MESSAGE.SET_NAME('WSM', 'WSM_MODIFIED_FIELD');
484: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'class_code in Resulting Jobs');
485: l_fnd_err_msg := FND_MESSAGE.GET;
486: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.POPULATE_COLUMNS('||l_stmt_num||'): '||l_fnd_err_msg);
487: END IF;
488:
489: /*-------------------------------------------------------------------+

Line 517: FND_MESSAGE.SET_NAME('WSM', 'WSM_NULL_FIELD');

513:
514: /* ST : moved this inside the IF condition */
515: l_err_occurred := 1; --VJ: 0313: Changed position for NSLBJ--
516:
517: FND_MESSAGE.SET_NAME('WSM', 'WSM_NULL_FIELD');
518: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'class_code');
519: l_fnd_err_msg := FND_MESSAGE.GET;
520: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.POPULATE_COLUMNS('||l_stmt_num||'): '||l_fnd_err_msg);
521:

Line 518: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'class_code');

514: /* ST : moved this inside the IF condition */
515: l_err_occurred := 1; --VJ: 0313: Changed position for NSLBJ--
516:
517: FND_MESSAGE.SET_NAME('WSM', 'WSM_NULL_FIELD');
518: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'class_code');
519: l_fnd_err_msg := FND_MESSAGE.GET;
520: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.POPULATE_COLUMNS('||l_stmt_num||'): '||l_fnd_err_msg);
521:
522: WSMPUTIL.AUTONOMOUS_WRITE_TO_WIE (p_header_id => C_NONSTD_NO_CLASS_CODE_RJ_rec.header_id,

Line 519: l_fnd_err_msg := FND_MESSAGE.GET;

515: l_err_occurred := 1; --VJ: 0313: Changed position for NSLBJ--
516:
517: FND_MESSAGE.SET_NAME('WSM', 'WSM_NULL_FIELD');
518: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'class_code');
519: l_fnd_err_msg := FND_MESSAGE.GET;
520: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.POPULATE_COLUMNS('||l_stmt_num||'): '||l_fnd_err_msg);
521:
522: WSMPUTIL.AUTONOMOUS_WRITE_TO_WIE (p_header_id => C_NONSTD_NO_CLASS_CODE_RJ_rec.header_id,
523: p_message => substr(l_fnd_err_msg,1,2000),

Line 551: FND_MESSAGE.SET_NAME('WSM', 'WSM_MODIFIED_FIELD');

547: WHERE wrji.header_id = C_NONSTD_NO_CLASS_CODE_RJ_rec.header_id
548: AND wrji.internal_group_id = WSMPLOAD.G_GROUP_ID
549: AND wrji.process_status = WIP_CONSTANTS.RUNNING;
550:
551: FND_MESSAGE.SET_NAME('WSM', 'WSM_MODIFIED_FIELD');
552: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'class_code in Resulting Jobs');
553: l_fnd_err_msg := FND_MESSAGE.GET;
554:
555: If l_debug = 'Y' Then

Line 552: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'class_code in Resulting Jobs');

548: AND wrji.internal_group_id = WSMPLOAD.G_GROUP_ID
549: AND wrji.process_status = WIP_CONSTANTS.RUNNING;
550:
551: FND_MESSAGE.SET_NAME('WSM', 'WSM_MODIFIED_FIELD');
552: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'class_code in Resulting Jobs');
553: l_fnd_err_msg := FND_MESSAGE.GET;
554:
555: If l_debug = 'Y' Then
556:

Line 553: l_fnd_err_msg := FND_MESSAGE.GET;

549: AND wrji.process_status = WIP_CONSTANTS.RUNNING;
550:
551: FND_MESSAGE.SET_NAME('WSM', 'WSM_MODIFIED_FIELD');
552: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'class_code in Resulting Jobs');
553: l_fnd_err_msg := FND_MESSAGE.GET;
554:
555: If l_debug = 'Y' Then
556:
557: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.POPULATE_COLUMNS('||l_stmt_num||'): '||l_fnd_err_msg);

Line 672: FND_MESSAGE.SET_NAME('WSM', 'WSM_MODIFIED_FIELD');

668:
669: /* ST : end fix 3766859*/
670:
671: IF (SQL%ROWCOUNT > 0) THEN
672: FND_MESSAGE.SET_NAME('WSM', 'WSM_MODIFIED_FIELD');
673: FND_MESSAGE.SET_TOKEN('FLD_NAME','net_quantity in Resulting Jobs');
674: l_fnd_err_msg := FND_MESSAGE.GET;
675:
676: If l_debug = 'Y' Then

Line 673: FND_MESSAGE.SET_TOKEN('FLD_NAME','net_quantity in Resulting Jobs');

669: /* ST : end fix 3766859*/
670:
671: IF (SQL%ROWCOUNT > 0) THEN
672: FND_MESSAGE.SET_NAME('WSM', 'WSM_MODIFIED_FIELD');
673: FND_MESSAGE.SET_TOKEN('FLD_NAME','net_quantity in Resulting Jobs');
674: l_fnd_err_msg := FND_MESSAGE.GET;
675:
676: If l_debug = 'Y' Then
677: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.POPULATE_COLUMNS('||l_stmt_num||

Line 674: l_fnd_err_msg := FND_MESSAGE.GET;

670:
671: IF (SQL%ROWCOUNT > 0) THEN
672: FND_MESSAGE.SET_NAME('WSM', 'WSM_MODIFIED_FIELD');
673: FND_MESSAGE.SET_TOKEN('FLD_NAME','net_quantity in Resulting Jobs');
674: l_fnd_err_msg := FND_MESSAGE.GET;
675:
676: If l_debug = 'Y' Then
677: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.POPULATE_COLUMNS('||l_stmt_num||
678: '): '||l_fnd_err_msg);

Line 720: FND_MESSAGE.SET_NAME('WSM', 'WSM_MODIFIED_FIELD');

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
720: FND_MESSAGE.SET_NAME('WSM', 'WSM_MODIFIED_FIELD');
721: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'net_quantity '|| l_stmt_num || ' in Resulting Jobs');
722: l_fnd_err_msg := FND_MESSAGE.GET;
723:
724:

Line 721: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'net_quantity '|| l_stmt_num || ' in Resulting Jobs');

717: and wrji.header_id = c_net_quantity_rec.header_id;
718:
719: IF (SQL%ROWCOUNT > 0) THEN
720: FND_MESSAGE.SET_NAME('WSM', 'WSM_MODIFIED_FIELD');
721: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'net_quantity '|| l_stmt_num || ' in Resulting Jobs');
722: l_fnd_err_msg := FND_MESSAGE.GET;
723:
724:
725: If l_debug = 'Y' Then

Line 722: l_fnd_err_msg := FND_MESSAGE.GET;

718:
719: IF (SQL%ROWCOUNT > 0) THEN
720: FND_MESSAGE.SET_NAME('WSM', 'WSM_MODIFIED_FIELD');
721: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'net_quantity '|| l_stmt_num || ' in Resulting Jobs');
722: l_fnd_err_msg := FND_MESSAGE.GET;
723:
724:
725: If l_debug = 'Y' Then
726: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.POPULATE_COLUMNS('||l_stmt_num||

Line 781: FND_MESSAGE.SET_NAME('WSM', 'WSM_MODIFIED_FIELD');

777: --End FP bugfix 3403087
778: END IF;
779:
780: IF (SQL%ROWCOUNT > 0) THEN
781: FND_MESSAGE.SET_NAME('WSM', 'WSM_MODIFIED_FIELD');
782: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'net_quantity in Resulting Jobs');
783: l_fnd_err_msg := FND_MESSAGE.GET;
784: If l_debug = 'Y' Then
785: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.POPULATE_COLUMNS('||l_stmt_num||

Line 782: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'net_quantity in Resulting Jobs');

778: END IF;
779:
780: IF (SQL%ROWCOUNT > 0) THEN
781: FND_MESSAGE.SET_NAME('WSM', 'WSM_MODIFIED_FIELD');
782: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'net_quantity in Resulting Jobs');
783: l_fnd_err_msg := FND_MESSAGE.GET;
784: If l_debug = 'Y' Then
785: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.POPULATE_COLUMNS('||l_stmt_num||
786: '): '||l_fnd_err_msg);

Line 783: l_fnd_err_msg := FND_MESSAGE.GET;

779:
780: IF (SQL%ROWCOUNT > 0) THEN
781: FND_MESSAGE.SET_NAME('WSM', 'WSM_MODIFIED_FIELD');
782: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'net_quantity in Resulting Jobs');
783: l_fnd_err_msg := FND_MESSAGE.GET;
784: If l_debug = 'Y' Then
785: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.POPULATE_COLUMNS('||l_stmt_num||
786: '): '||l_fnd_err_msg);
787: End If;

Line 816: FND_MESSAGE.SET_NAME('WSM', 'WSM_MODIFIED_FIELD');

812: WHERE wrji.header_id = c_net_quantity_rec.header_id
813: AND wrji.net_quantity is NULL ;
814:
815: IF (SQL%ROWCOUNT > 0) THEN
816: FND_MESSAGE.SET_NAME('WSM', 'WSM_MODIFIED_FIELD');
817: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'net_quantity in Resulting Jobs');
818: l_fnd_err_msg := FND_MESSAGE.GET;
819:
820: If l_debug = 'Y' Then

Line 817: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'net_quantity in Resulting Jobs');

813: AND wrji.net_quantity is NULL ;
814:
815: IF (SQL%ROWCOUNT > 0) THEN
816: FND_MESSAGE.SET_NAME('WSM', 'WSM_MODIFIED_FIELD');
817: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'net_quantity in Resulting Jobs');
818: l_fnd_err_msg := FND_MESSAGE.GET;
819:
820: If l_debug = 'Y' Then
821:

Line 818: l_fnd_err_msg := FND_MESSAGE.GET;

814:
815: IF (SQL%ROWCOUNT > 0) THEN
816: FND_MESSAGE.SET_NAME('WSM', 'WSM_MODIFIED_FIELD');
817: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'net_quantity in Resulting Jobs');
818: l_fnd_err_msg := FND_MESSAGE.GET;
819:
820: If l_debug = 'Y' Then
821:
822: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.POPULATE_COLUMNS('||l_stmt_num||

Line 866: FND_MESSAGE.SET_NAME('WSM', 'WSM_MODIFIED_FIELD');

862: AND ( wrji.coproducts_supply is NULL OR
863: wrji.coproducts_supply NOT IN (1,2));
864:
865: IF (SQL%ROWCOUNT > 0) THEN
866: FND_MESSAGE.SET_NAME('WSM', 'WSM_MODIFIED_FIELD');
867: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'coproducts_supply in Resulting Jobs');
868: l_fnd_err_msg := FND_MESSAGE.GET;
869:
870: If l_debug = 'Y' Then

Line 867: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'coproducts_supply in Resulting Jobs');

863: wrji.coproducts_supply NOT IN (1,2));
864:
865: IF (SQL%ROWCOUNT > 0) THEN
866: FND_MESSAGE.SET_NAME('WSM', 'WSM_MODIFIED_FIELD');
867: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'coproducts_supply in Resulting Jobs');
868: l_fnd_err_msg := FND_MESSAGE.GET;
869:
870: If l_debug = 'Y' Then
871: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.POPULATE_COLUMNS('||l_stmt_num||'): '||l_fnd_err_msg);

Line 868: l_fnd_err_msg := FND_MESSAGE.GET;

864:
865: IF (SQL%ROWCOUNT > 0) THEN
866: FND_MESSAGE.SET_NAME('WSM', 'WSM_MODIFIED_FIELD');
867: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'coproducts_supply in Resulting Jobs');
868: l_fnd_err_msg := FND_MESSAGE.GET;
869:
870: If l_debug = 'Y' Then
871: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.POPULATE_COLUMNS('||l_stmt_num||'): '||l_fnd_err_msg);
872: End If;

Line 909: FND_MESSAGE.SET_NAME('WSM', 'WSM_MODIFIED_FIELD');

905: AND rj.header_id = p_header_id -- WLTEnh
906: AND rj.starting_intraoperation_step is null;
907:
908: IF (SQL%ROWCOUNT > 0) and l_debug = 'Y' THEN
909: FND_MESSAGE.SET_NAME('WSM', 'WSM_MODIFIED_FIELD');
910: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'starting_intraoperation_step in Resulting Jobs');
911: l_fnd_err_msg := FND_MESSAGE.GET;
912: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.POPULATE_COLUMNS('||l_stmt_num||'): '||l_fnd_err_msg);
913:

Line 910: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'starting_intraoperation_step in Resulting Jobs');

906: AND rj.starting_intraoperation_step is null;
907:
908: IF (SQL%ROWCOUNT > 0) and l_debug = 'Y' THEN
909: FND_MESSAGE.SET_NAME('WSM', 'WSM_MODIFIED_FIELD');
910: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'starting_intraoperation_step in Resulting Jobs');
911: l_fnd_err_msg := FND_MESSAGE.GET;
912: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.POPULATE_COLUMNS('||l_stmt_num||'): '||l_fnd_err_msg);
913:
914: END IF;

Line 911: l_fnd_err_msg := FND_MESSAGE.GET;

907:
908: IF (SQL%ROWCOUNT > 0) and l_debug = 'Y' THEN
909: FND_MESSAGE.SET_NAME('WSM', 'WSM_MODIFIED_FIELD');
910: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'starting_intraoperation_step in Resulting Jobs');
911: l_fnd_err_msg := FND_MESSAGE.GET;
912: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.POPULATE_COLUMNS('||l_stmt_num||'): '||l_fnd_err_msg);
913:
914: END IF;
915:

Line 935: FND_MESSAGE.SET_NAME('WSM', 'WSM_MODIFIED_FIELD');

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');
936: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'starting_intraoperation_step in Resulting Jobs');
937: l_fnd_err_msg := FND_MESSAGE.GET;
938: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.POPULATE_COLUMNS('||l_stmt_num||'): '||l_fnd_err_msg);
939:

Line 936: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'starting_intraoperation_step in Resulting Jobs');

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');
936: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'starting_intraoperation_step in Resulting Jobs');
937: l_fnd_err_msg := FND_MESSAGE.GET;
938: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.POPULATE_COLUMNS('||l_stmt_num||'): '||l_fnd_err_msg);
939:
940: END IF;

Line 937: l_fnd_err_msg := FND_MESSAGE.GET;

933:
934: IF (SQL%ROWCOUNT > 0) and l_debug = 'Y' THEN
935: FND_MESSAGE.SET_NAME('WSM', 'WSM_MODIFIED_FIELD');
936: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'starting_intraoperation_step in Resulting Jobs');
937: l_fnd_err_msg := FND_MESSAGE.GET;
938: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.POPULATE_COLUMNS('||l_stmt_num||'): '||l_fnd_err_msg);
939:
940: END IF;
941:

Line 969: FND_MESSAGE.SET_NAME('WSM', 'WSM_MODIFIED_FIELD');

965: AND rj.split_has_update_assy = 0)));
966: --SpUA end
967:
968: IF (SQL%ROWCOUNT > 0) and l_debug = 'Y' THEN
969: FND_MESSAGE.SET_NAME('WSM', 'WSM_MODIFIED_FIELD');
970: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'forward_op_option in Resulting Jobs');
971: l_fnd_err_msg := FND_MESSAGE.GET;
972: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.POPULATE_COLUMNS('||l_stmt_num||'): '||l_fnd_err_msg);
973:

Line 970: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'forward_op_option in Resulting Jobs');

966: --SpUA end
967:
968: IF (SQL%ROWCOUNT > 0) and l_debug = 'Y' THEN
969: FND_MESSAGE.SET_NAME('WSM', 'WSM_MODIFIED_FIELD');
970: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'forward_op_option in Resulting Jobs');
971: l_fnd_err_msg := FND_MESSAGE.GET;
972: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.POPULATE_COLUMNS('||l_stmt_num||'): '||l_fnd_err_msg);
973:
974: END IF;

Line 971: l_fnd_err_msg := FND_MESSAGE.GET;

967:
968: IF (SQL%ROWCOUNT > 0) and l_debug = 'Y' THEN
969: FND_MESSAGE.SET_NAME('WSM', 'WSM_MODIFIED_FIELD');
970: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'forward_op_option in Resulting Jobs');
971: l_fnd_err_msg := FND_MESSAGE.GET;
972: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.POPULATE_COLUMNS('||l_stmt_num||'): '||l_fnd_err_msg);
973:
974: END IF;
975:

Line 1039: fnd_message.set_name('WSM', 'WSM_MODIFIED_FIELD');

1035: IF (SQL%ROWCOUNT > 0) and l_debug = 'Y' THEN
1036: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.POPULATE_COLUMNS('||l_stmt_num||'): '||
1037: 'l_temp_csi='||l_temp_csi||
1038: ', l_temp_loc_id='||l_temp_loc_id);
1039: fnd_message.set_name('WSM', 'WSM_MODIFIED_FIELD');
1040: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'Completion Subinventory and Locator from Routing');
1041: l_fnd_err_msg := FND_MESSAGE.GET;
1042: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.POPULATE_COLUMN('||l_stmt_num||'): '||l_fnd_err_msg);
1043: END IF;

Line 1040: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'Completion Subinventory and Locator from Routing');

1036: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.POPULATE_COLUMNS('||l_stmt_num||'): '||
1037: 'l_temp_csi='||l_temp_csi||
1038: ', l_temp_loc_id='||l_temp_loc_id);
1039: fnd_message.set_name('WSM', 'WSM_MODIFIED_FIELD');
1040: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'Completion Subinventory and Locator from Routing');
1041: l_fnd_err_msg := FND_MESSAGE.GET;
1042: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.POPULATE_COLUMN('||l_stmt_num||'): '||l_fnd_err_msg);
1043: END IF;
1044:

Line 1041: l_fnd_err_msg := FND_MESSAGE.GET;

1037: 'l_temp_csi='||l_temp_csi||
1038: ', l_temp_loc_id='||l_temp_loc_id);
1039: fnd_message.set_name('WSM', 'WSM_MODIFIED_FIELD');
1040: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'Completion Subinventory and Locator from Routing');
1041: l_fnd_err_msg := FND_MESSAGE.GET;
1042: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.POPULATE_COLUMN('||l_stmt_num||'): '||l_fnd_err_msg);
1043: END IF;
1044:
1045: l_stmt_num := 25;

Line 1085: fnd_message.set_name('WSM', 'WSM_MODIFIED_FIELD');

1081: AND rj.split_has_update_assy = 0)));
1082: --SpUA end
1083:
1084: IF (SQL%ROWCOUNT > 0) and l_debug = 'Y' THEN
1085: fnd_message.set_name('WSM', 'WSM_MODIFIED_FIELD');
1086: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'Completion Subinventory and Locator from Starting Jobs');
1087: l_fnd_err_msg := FND_MESSAGE.GET;
1088: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.POPULATE_COLUMN('||l_stmt_num||'): '||l_fnd_err_msg);
1089: END IF;

Line 1086: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'Completion Subinventory and Locator from Starting Jobs');

1082: --SpUA end
1083:
1084: IF (SQL%ROWCOUNT > 0) and l_debug = 'Y' THEN
1085: fnd_message.set_name('WSM', 'WSM_MODIFIED_FIELD');
1086: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'Completion Subinventory and Locator from Starting Jobs');
1087: l_fnd_err_msg := FND_MESSAGE.GET;
1088: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.POPULATE_COLUMN('||l_stmt_num||'): '||l_fnd_err_msg);
1089: END IF;
1090: -- end 2099827

Line 1087: l_fnd_err_msg := FND_MESSAGE.GET;

1083:
1084: IF (SQL%ROWCOUNT > 0) and l_debug = 'Y' THEN
1085: fnd_message.set_name('WSM', 'WSM_MODIFIED_FIELD');
1086: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'Completion Subinventory and Locator from Starting Jobs');
1087: l_fnd_err_msg := FND_MESSAGE.GET;
1088: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.POPULATE_COLUMN('||l_stmt_num||'): '||l_fnd_err_msg);
1089: END IF;
1090: -- end 2099827
1091:

Line 1138: fnd_message.set_name('WSM', 'WSM_MODIFIED_FIELD');

1134: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.POPULATE_COLUMNS('||l_stmt_num||'): '||
1135: ' p_header_id='||p_header_id||
1136: ' l_temp_csi='||l_temp_csi||
1137: ', l_temp_loc_id='||l_temp_loc_id);
1138: fnd_message.set_name('WSM', 'WSM_MODIFIED_FIELD');
1139: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'Completion Subinventory and Locator from Starting Jobs for Merge');
1140: l_fnd_err_msg := FND_MESSAGE.GET;
1141: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.POPULATE_COLUMN('||l_stmt_num||'): '||l_fnd_err_msg);
1142: END IF;

Line 1139: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'Completion Subinventory and Locator from Starting Jobs for Merge');

1135: ' p_header_id='||p_header_id||
1136: ' l_temp_csi='||l_temp_csi||
1137: ', l_temp_loc_id='||l_temp_loc_id);
1138: fnd_message.set_name('WSM', 'WSM_MODIFIED_FIELD');
1139: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'Completion Subinventory and Locator from Starting Jobs for Merge');
1140: l_fnd_err_msg := FND_MESSAGE.GET;
1141: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.POPULATE_COLUMN('||l_stmt_num||'): '||l_fnd_err_msg);
1142: END IF;
1143:

Line 1140: l_fnd_err_msg := FND_MESSAGE.GET;

1136: ' l_temp_csi='||l_temp_csi||
1137: ', l_temp_loc_id='||l_temp_loc_id);
1138: fnd_message.set_name('WSM', 'WSM_MODIFIED_FIELD');
1139: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'Completion Subinventory and Locator from Starting Jobs for Merge');
1140: l_fnd_err_msg := FND_MESSAGE.GET;
1141: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.POPULATE_COLUMN('||l_stmt_num||'): '||l_fnd_err_msg);
1142: END IF;
1143:
1144: l_stmt_num := 27;

Line 1350: l_fnd_err_msg VARCHAR2(2000); -- for fnd_messages

1346: l_rtg_rev VARCHAR2(10); -- ADD: CZH.I_OED-1
1347: l_rtg_rev_date DATE := SYSDATE;-- ADD: CZH.I_OED-1, default to SYSDATE
1348: l_item_id NUMBER; -- ADD: CZH.I_OED-1
1349:
1350: l_fnd_err_msg VARCHAR2(2000); -- for fnd_messages
1351: l_fnd_generic_err_msg VARCHAR2(2000); -- for fnd_message WSM_ERRORS_IN_WIE
1352:
1353: proc_error EXCEPTION;
1354:

Line 1351: l_fnd_generic_err_msg VARCHAR2(2000); -- for fnd_message WSM_ERRORS_IN_WIE

1347: l_rtg_rev_date DATE := SYSDATE;-- ADD: CZH.I_OED-1, default to SYSDATE
1348: l_item_id NUMBER; -- ADD: CZH.I_OED-1
1349:
1350: l_fnd_err_msg VARCHAR2(2000); -- for fnd_messages
1351: l_fnd_generic_err_msg VARCHAR2(2000); -- for fnd_message WSM_ERRORS_IN_WIE
1352:
1353: proc_error EXCEPTION;
1354:
1355: --VJ: Start Changes for NSLBJ--

Line 1532: FND_MESSAGE.SET_NAME('WSM', 'WSM_ERRORS_IN_WIE');

1528: ||to_char(SYSDATE, 'DD-MON-YYYY HH24:MI:SS'));
1529:
1530: END IF;
1531:
1532: FND_MESSAGE.SET_NAME('WSM', 'WSM_ERRORS_IN_WIE');
1533: l_fnd_generic_err_msg := FND_MESSAGE.GET;
1534:
1535: OPEN C_WSMTI;
1536: -- 1685779 : indented the code

Line 1533: l_fnd_generic_err_msg := FND_MESSAGE.GET;

1529:
1530: END IF;
1531:
1532: FND_MESSAGE.SET_NAME('WSM', 'WSM_ERRORS_IN_WIE');
1533: l_fnd_generic_err_msg := FND_MESSAGE.GET;
1534:
1535: OPEN C_WSMTI;
1536: -- 1685779 : indented the code
1537: LOOP

Line 1580: FND_MESSAGE.SET_NAME('WSM', 'WSM_INVALID_FIELD');

1576: When NO_DATA_FOUND Then
1577:
1578: set_wsmti_error;
1579:
1580: FND_MESSAGE.SET_NAME('WSM', 'WSM_INVALID_FIELD');
1581: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'transaction_type_id in Split Merge Transactions');
1582: l_fnd_err_msg := FND_MESSAGE.GET;
1583:
1584: FND_FILE.PUT_LINE(FND_FILE.LOG,

Line 1581: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'transaction_type_id in Split Merge Transactions');

1577:
1578: set_wsmti_error;
1579:
1580: FND_MESSAGE.SET_NAME('WSM', 'WSM_INVALID_FIELD');
1581: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'transaction_type_id in Split Merge Transactions');
1582: l_fnd_err_msg := FND_MESSAGE.GET;
1583:
1584: FND_FILE.PUT_LINE(FND_FILE.LOG,
1585: 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): '||l_fnd_err_msg);

Line 1582: l_fnd_err_msg := FND_MESSAGE.GET;

1578: set_wsmti_error;
1579:
1580: FND_MESSAGE.SET_NAME('WSM', 'WSM_INVALID_FIELD');
1581: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'transaction_type_id in Split Merge Transactions');
1582: l_fnd_err_msg := FND_MESSAGE.GET;
1583:
1584: FND_FILE.PUT_LINE(FND_FILE.LOG,
1585: 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): '||l_fnd_err_msg);
1586:

Line 1630: FND_MESSAGE.SET_NAME('WSM', 'WSM_INVALID_FIELD');

1626: When NO_DATA_FOUND Then
1627:
1628: set_wsmti_error;
1629:
1630: FND_MESSAGE.SET_NAME('WSM', 'WSM_INVALID_FIELD');
1631: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'organization_id in Split Merge Transactions');
1632: l_fnd_err_msg := FND_MESSAGE.GET;
1633: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): '||l_fnd_err_msg);
1634:

Line 1631: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'organization_id in Split Merge Transactions');

1627:
1628: set_wsmti_error;
1629:
1630: FND_MESSAGE.SET_NAME('WSM', 'WSM_INVALID_FIELD');
1631: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'organization_id in Split Merge Transactions');
1632: l_fnd_err_msg := FND_MESSAGE.GET;
1633: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): '||l_fnd_err_msg);
1634:
1635: WSMPUTIL.AUTONOMOUS_WRITE_TO_WIE (p_header_id => l_cur_wsmti_rec.header_id,

Line 1632: l_fnd_err_msg := FND_MESSAGE.GET;

1628: set_wsmti_error;
1629:
1630: FND_MESSAGE.SET_NAME('WSM', 'WSM_INVALID_FIELD');
1631: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'organization_id in Split Merge Transactions');
1632: l_fnd_err_msg := FND_MESSAGE.GET;
1633: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): '||l_fnd_err_msg);
1634:
1635: WSMPUTIL.AUTONOMOUS_WRITE_TO_WIE (p_header_id => l_cur_wsmti_rec.header_id,
1636: p_message => substr(l_fnd_err_msg,1,2000),

Line 1704: FND_MESSAGE.SET_NAME('WSM', 'WSM_INVALID_FIELD');

1700: WHEN NO_DATA_FOUND Then
1701:
1702: set_wsmti_error;
1703:
1704: FND_MESSAGE.SET_NAME('WSM', 'WSM_INVALID_FIELD');
1705: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'reason_id in Split Merge Transactions');
1706: l_fnd_err_msg := FND_MESSAGE.GET;
1707: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): '||l_fnd_err_msg);
1708:

Line 1705: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'reason_id in Split Merge Transactions');

1701:
1702: set_wsmti_error;
1703:
1704: FND_MESSAGE.SET_NAME('WSM', 'WSM_INVALID_FIELD');
1705: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'reason_id in Split Merge Transactions');
1706: l_fnd_err_msg := FND_MESSAGE.GET;
1707: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): '||l_fnd_err_msg);
1708:
1709: WSMPUTIL.AUTONOMOUS_WRITE_TO_WIE (p_header_id => l_cur_wsmti_rec.header_id,

Line 1706: l_fnd_err_msg := FND_MESSAGE.GET;

1702: set_wsmti_error;
1703:
1704: FND_MESSAGE.SET_NAME('WSM', 'WSM_INVALID_FIELD');
1705: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'reason_id in Split Merge Transactions');
1706: l_fnd_err_msg := FND_MESSAGE.GET;
1707: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): '||l_fnd_err_msg);
1708:
1709: WSMPUTIL.AUTONOMOUS_WRITE_TO_WIE (p_header_id => l_cur_wsmti_rec.header_id,
1710: p_message => substr(l_fnd_err_msg,1,2000),

Line 1749: FND_MESSAGE.SET_NAME('WSM', 'WSM_START_LOT_REQUIRED');

1745: When NO_DATA_FOUND Then
1746:
1747: set_wsmti_error;
1748:
1749: FND_MESSAGE.SET_NAME('WSM', 'WSM_START_LOT_REQUIRED');
1750: l_fnd_err_msg := FND_MESSAGE.GET;
1751: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): '||l_fnd_err_msg);
1752:
1753: WSMPUTIL.AUTONOMOUS_WRITE_TO_WIE (p_header_id => l_cur_wsmti_rec.header_id,

Line 1750: l_fnd_err_msg := FND_MESSAGE.GET;

1746:
1747: set_wsmti_error;
1748:
1749: FND_MESSAGE.SET_NAME('WSM', 'WSM_START_LOT_REQUIRED');
1750: l_fnd_err_msg := FND_MESSAGE.GET;
1751: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): '||l_fnd_err_msg);
1752:
1753: WSMPUTIL.AUTONOMOUS_WRITE_TO_WIE (p_header_id => l_cur_wsmti_rec.header_id,
1754: p_message => substr(l_fnd_err_msg,1,2000),

Line 1791: FND_MESSAGE.SET_NAME('WSM', 'WSM_RESULT_LOT_REQUIRED');

1787: When NO_DATA_FOUND Then
1788:
1789: set_wsmti_error;
1790:
1791: FND_MESSAGE.SET_NAME('WSM', 'WSM_RESULT_LOT_REQUIRED');
1792: l_fnd_err_msg := FND_MESSAGE.GET;
1793: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): '||l_fnd_err_msg);
1794:
1795: WSMPUTIL.AUTONOMOUS_WRITE_TO_WIE (p_header_id => l_cur_wsmti_rec.header_id,

Line 1792: l_fnd_err_msg := FND_MESSAGE.GET;

1788:
1789: set_wsmti_error;
1790:
1791: FND_MESSAGE.SET_NAME('WSM', 'WSM_RESULT_LOT_REQUIRED');
1792: l_fnd_err_msg := FND_MESSAGE.GET;
1793: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): '||l_fnd_err_msg);
1794:
1795: WSMPUTIL.AUTONOMOUS_WRITE_TO_WIE (p_header_id => l_cur_wsmti_rec.header_id,
1796: p_message => substr(l_fnd_err_msg,1,2000),

Line 1934: FND_MESSAGE.SET_NAME('WSM', 'WSM_INVALID_FIELD');

1930: When NO_DATA_FOUND Then
1931:
1932: set_wsji_error();
1933:
1934: FND_MESSAGE.SET_NAME('WSM', 'WSM_INVALID_FIELD');
1935: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'header_id in Starting Jobs');
1936: l_fnd_err_msg := FND_MESSAGE.GET;
1937: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): '||l_fnd_err_msg);
1938:

Line 1935: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'header_id in Starting Jobs');

1931:
1932: set_wsji_error();
1933:
1934: FND_MESSAGE.SET_NAME('WSM', 'WSM_INVALID_FIELD');
1935: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'header_id in Starting Jobs');
1936: l_fnd_err_msg := FND_MESSAGE.GET;
1937: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): '||l_fnd_err_msg);
1938:
1939: WSMPUTIL.AUTONOMOUS_WRITE_TO_WIE (p_header_id => l_header_id,

Line 1936: l_fnd_err_msg := FND_MESSAGE.GET;

1932: set_wsji_error();
1933:
1934: FND_MESSAGE.SET_NAME('WSM', 'WSM_INVALID_FIELD');
1935: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'header_id in Starting Jobs');
1936: l_fnd_err_msg := FND_MESSAGE.GET;
1937: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): '||l_fnd_err_msg);
1938:
1939: WSMPUTIL.AUTONOMOUS_WRITE_TO_WIE (p_header_id => l_header_id,
1940: p_message => substr(l_fnd_err_msg,1,2000),

Line 1981: FND_MESSAGE.SET_NAME('WSM', 'WSM_MODIFIED_FIELD');

1977: When NO_DATA_FOUND Then
1978:
1979: set_wsji_warning();
1980:
1981: FND_MESSAGE.SET_NAME('WSM', 'WSM_MODIFIED_FIELD');
1982: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'organization_id in Starting Jobs');
1983: l_fnd_err_msg := FND_MESSAGE.GET;
1984:
1985: If l_debug = 'Y' THEN

Line 1982: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'organization_id in Starting Jobs');

1978:
1979: set_wsji_warning();
1980:
1981: FND_MESSAGE.SET_NAME('WSM', 'WSM_MODIFIED_FIELD');
1982: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'organization_id in Starting Jobs');
1983: l_fnd_err_msg := FND_MESSAGE.GET;
1984:
1985: If l_debug = 'Y' THEN
1986: FND_FILE.PUT_LINE(FND_FILE.LOG,

Line 1983: l_fnd_err_msg := FND_MESSAGE.GET;

1979: set_wsji_warning();
1980:
1981: FND_MESSAGE.SET_NAME('WSM', 'WSM_MODIFIED_FIELD');
1982: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'organization_id in Starting Jobs');
1983: l_fnd_err_msg := FND_MESSAGE.GET;
1984:
1985: If l_debug = 'Y' THEN
1986: FND_FILE.PUT_LINE(FND_FILE.LOG,
1987: 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): '||l_fnd_err_msg);

Line 2028: FND_MESSAGE.SET_NAME('WSM', 'WSM_INVALID_FIELD');

2024: When NO_DATA_FOUND Then
2025:
2026: set_wsji_error();
2027:
2028: FND_MESSAGE.SET_NAME('WSM', 'WSM_INVALID_FIELD');
2029: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'organization_id in Starting Jobs');
2030: l_fnd_err_msg := FND_MESSAGE.GET;
2031: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): '||l_fnd_err_msg);
2032:

Line 2029: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'organization_id in Starting Jobs');

2025:
2026: set_wsji_error();
2027:
2028: FND_MESSAGE.SET_NAME('WSM', 'WSM_INVALID_FIELD');
2029: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'organization_id in Starting Jobs');
2030: l_fnd_err_msg := FND_MESSAGE.GET;
2031: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): '||l_fnd_err_msg);
2032:
2033: WSMPUTIL.AUTONOMOUS_WRITE_TO_WIE (p_header_id => l_header_id,

Line 2030: l_fnd_err_msg := FND_MESSAGE.GET;

2026: set_wsji_error();
2027:
2028: FND_MESSAGE.SET_NAME('WSM', 'WSM_INVALID_FIELD');
2029: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'organization_id in Starting Jobs');
2030: l_fnd_err_msg := FND_MESSAGE.GET;
2031: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): '||l_fnd_err_msg);
2032:
2033: WSMPUTIL.AUTONOMOUS_WRITE_TO_WIE (p_header_id => l_header_id,
2034: p_message => substr(l_fnd_err_msg,1,2000),

Line 2080: FND_MESSAGE.SET_NAME('WSM', 'WSM_REPRESENTATIVE_LOT');

2076: When NO_DATA_FOUND Then
2077:
2078: set_wsji_error();
2079:
2080: FND_MESSAGE.SET_NAME('WSM', 'WSM_REPRESENTATIVE_LOT');
2081: l_fnd_err_msg := FND_MESSAGE.GET;
2082: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): '||l_fnd_err_msg);
2083:
2084: WSMPUTIL.AUTONOMOUS_WRITE_TO_WIE (p_header_id => l_header_id,

Line 2081: l_fnd_err_msg := FND_MESSAGE.GET;

2077:
2078: set_wsji_error();
2079:
2080: FND_MESSAGE.SET_NAME('WSM', 'WSM_REPRESENTATIVE_LOT');
2081: l_fnd_err_msg := FND_MESSAGE.GET;
2082: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): '||l_fnd_err_msg);
2083:
2084: WSMPUTIL.AUTONOMOUS_WRITE_TO_WIE (p_header_id => l_header_id,
2085: p_message => substr(l_fnd_err_msg,1,2000),

Line 2100: FND_MESSAGE.SET_NAME('WSM', 'WSM_REPRESENTATIVE_LOT');

2096: When e_too_many_rep_lot_exception Then
2097:
2098: set_wsji_error();
2099:
2100: FND_MESSAGE.SET_NAME('WSM', 'WSM_REPRESENTATIVE_LOT');
2101: l_fnd_err_msg := FND_MESSAGE.GET;
2102: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): '||l_fnd_err_msg);
2103:
2104: WSMPUTIL.AUTONOMOUS_WRITE_TO_WIE (p_header_id => l_header_id,

Line 2101: l_fnd_err_msg := FND_MESSAGE.GET;

2097:
2098: set_wsji_error();
2099:
2100: FND_MESSAGE.SET_NAME('WSM', 'WSM_REPRESENTATIVE_LOT');
2101: l_fnd_err_msg := FND_MESSAGE.GET;
2102: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): '||l_fnd_err_msg);
2103:
2104: WSMPUTIL.AUTONOMOUS_WRITE_TO_WIE (p_header_id => l_header_id,
2105: p_message => substr(l_fnd_err_msg,1,2000),

Line 2143: FND_MESSAGE.SET_NAME('WSM', 'WSM_MODIFIED_FIELD');

2139: IF (SQL%ROWCOUNT > 0) THEN
2140:
2141: set_wsji_warning();
2142:
2143: FND_MESSAGE.SET_NAME('WSM', 'WSM_MODIFIED_FIELD');
2144: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'representative_flag in Starting Jobs');
2145: l_fnd_err_msg := FND_MESSAGE.GET;
2146:
2147: If l_debug = 'Y' THEN

Line 2144: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'representative_flag in Starting Jobs');

2140:
2141: set_wsji_warning();
2142:
2143: FND_MESSAGE.SET_NAME('WSM', 'WSM_MODIFIED_FIELD');
2144: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'representative_flag in Starting Jobs');
2145: l_fnd_err_msg := FND_MESSAGE.GET;
2146:
2147: If l_debug = 'Y' THEN
2148: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): '||l_fnd_err_msg);

Line 2145: l_fnd_err_msg := FND_MESSAGE.GET;

2141: set_wsji_warning();
2142:
2143: FND_MESSAGE.SET_NAME('WSM', 'WSM_MODIFIED_FIELD');
2144: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'representative_flag in Starting Jobs');
2145: l_fnd_err_msg := FND_MESSAGE.GET;
2146:
2147: If l_debug = 'Y' THEN
2148: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): '||l_fnd_err_msg);
2149: End If;

Line 2208: FND_MESSAGE.SET_NAME('WSM', 'WSM_MODIFIED_FIELD');

2204: WIP_CONSTANTS.NONSTANDARD) --VJ: Added for NSLBJ--
2205: and we.entity_type = 5;
2206:
2207: IF (SQL%ROWCOUNT > 0) THEN
2208: FND_MESSAGE.SET_NAME('WSM', 'WSM_MODIFIED_FIELD');
2209: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'wip_entity_name in Starting Jobs');
2210: l_fnd_err_msg := FND_MESSAGE.GET;
2211:
2212: If l_debug = 'Y' THEN

Line 2209: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'wip_entity_name in Starting Jobs');

2205: and we.entity_type = 5;
2206:
2207: IF (SQL%ROWCOUNT > 0) THEN
2208: FND_MESSAGE.SET_NAME('WSM', 'WSM_MODIFIED_FIELD');
2209: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'wip_entity_name in Starting Jobs');
2210: l_fnd_err_msg := FND_MESSAGE.GET;
2211:
2212: If l_debug = 'Y' THEN
2213: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): '||l_fnd_err_msg);

Line 2210: l_fnd_err_msg := FND_MESSAGE.GET;

2206:
2207: IF (SQL%ROWCOUNT > 0) THEN
2208: FND_MESSAGE.SET_NAME('WSM', 'WSM_MODIFIED_FIELD');
2209: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'wip_entity_name in Starting Jobs');
2210: l_fnd_err_msg := FND_MESSAGE.GET;
2211:
2212: If l_debug = 'Y' THEN
2213: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): '||l_fnd_err_msg);
2214: End If;

Line 2236: FND_MESSAGE.SET_NAME('WSM', 'WSM_INVALID_FIELD');

2232: When NO_DATA_FOUND Then
2233:
2234: set_wsji_error();
2235:
2236: FND_MESSAGE.SET_NAME('WSM', 'WSM_INVALID_FIELD');
2237: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'wip_entity_id in Starting Jobs');
2238: l_fnd_err_msg := FND_MESSAGE.GET;
2239: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): '||l_fnd_err_msg);
2240:

Line 2237: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'wip_entity_id in Starting Jobs');

2233:
2234: set_wsji_error();
2235:
2236: FND_MESSAGE.SET_NAME('WSM', 'WSM_INVALID_FIELD');
2237: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'wip_entity_id in Starting Jobs');
2238: l_fnd_err_msg := FND_MESSAGE.GET;
2239: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): '||l_fnd_err_msg);
2240:
2241: WSMPUTIL.AUTONOMOUS_WRITE_TO_WIE (

Line 2238: l_fnd_err_msg := FND_MESSAGE.GET;

2234: set_wsji_error();
2235:
2236: FND_MESSAGE.SET_NAME('WSM', 'WSM_INVALID_FIELD');
2237: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'wip_entity_id in Starting Jobs');
2238: l_fnd_err_msg := FND_MESSAGE.GET;
2239: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): '||l_fnd_err_msg);
2240:
2241: WSMPUTIL.AUTONOMOUS_WRITE_TO_WIE (
2242: p_header_id => l_header_id,

Line 2279: FND_MESSAGE.SET_NAME('WSM', 'WSM_MODIFIED_FIELD');

2275: and dis.job_type in (WIP_CONSTANTS.STANDARD, WIP_CONSTANTS.NONSTANDARD)
2276: and we.entity_type = 5;
2277:
2278: IF (SQL%ROWCOUNT > 0) THEN
2279: FND_MESSAGE.SET_NAME('WSM', 'WSM_MODIFIED_FIELD');
2280: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'wip_entity_id in Starting Jobs');
2281: l_fnd_err_msg := FND_MESSAGE.GET;
2282: If l_debug = 'Y' THEN
2283: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): '||l_fnd_err_msg);

Line 2280: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'wip_entity_id in Starting Jobs');

2276: and we.entity_type = 5;
2277:
2278: IF (SQL%ROWCOUNT > 0) THEN
2279: FND_MESSAGE.SET_NAME('WSM', 'WSM_MODIFIED_FIELD');
2280: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'wip_entity_id in Starting Jobs');
2281: l_fnd_err_msg := FND_MESSAGE.GET;
2282: If l_debug = 'Y' THEN
2283: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): '||l_fnd_err_msg);
2284: End If;

Line 2281: l_fnd_err_msg := FND_MESSAGE.GET;

2277:
2278: IF (SQL%ROWCOUNT > 0) THEN
2279: FND_MESSAGE.SET_NAME('WSM', 'WSM_MODIFIED_FIELD');
2280: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'wip_entity_id in Starting Jobs');
2281: l_fnd_err_msg := FND_MESSAGE.GET;
2282: If l_debug = 'Y' THEN
2283: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): '||l_fnd_err_msg);
2284: End If;
2285:

Line 2306: FND_MESSAGE.SET_NAME('WSM', 'WSM_INVALID_FIELD');

2302: When NO_DATA_FOUND Then
2303:
2304: set_wsji_error();
2305:
2306: FND_MESSAGE.SET_NAME('WSM', 'WSM_INVALID_FIELD');
2307: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'wip_entity_name in Starting Jobs');
2308: l_fnd_err_msg := FND_MESSAGE.GET;
2309: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): '||l_fnd_err_msg);
2310:

Line 2307: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'wip_entity_name in Starting Jobs');

2303:
2304: set_wsji_error();
2305:
2306: FND_MESSAGE.SET_NAME('WSM', 'WSM_INVALID_FIELD');
2307: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'wip_entity_name in Starting Jobs');
2308: l_fnd_err_msg := FND_MESSAGE.GET;
2309: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): '||l_fnd_err_msg);
2310:
2311: WSMPUTIL.AUTONOMOUS_WRITE_TO_WIE (p_header_id => l_header_id,

Line 2308: l_fnd_err_msg := FND_MESSAGE.GET;

2304: set_wsji_error();
2305:
2306: FND_MESSAGE.SET_NAME('WSM', 'WSM_INVALID_FIELD');
2307: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'wip_entity_name in Starting Jobs');
2308: l_fnd_err_msg := FND_MESSAGE.GET;
2309: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): '||l_fnd_err_msg);
2310:
2311: WSMPUTIL.AUTONOMOUS_WRITE_TO_WIE (p_header_id => l_header_id,
2312: p_message => substr(l_fnd_err_msg,1,2000),

Line 2340: FND_MESSAGE.SET_NAME('WSM', 'WSM_INVALID_FIELD');

2336: l_cur_wsji_rec.wip_entity_name is NULL ) Then
2337:
2338: set_wsji_error();
2339:
2340: FND_MESSAGE.SET_NAME('WSM', 'WSM_INVALID_FIELD');
2341: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'wip_entity_name/wip_entity_id in Starting Jobs');
2342: l_fnd_err_msg := FND_MESSAGE.GET;
2343: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): '||l_fnd_err_msg);
2344:

Line 2341: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'wip_entity_name/wip_entity_id in Starting Jobs');

2337:
2338: set_wsji_error();
2339:
2340: FND_MESSAGE.SET_NAME('WSM', 'WSM_INVALID_FIELD');
2341: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'wip_entity_name/wip_entity_id in Starting Jobs');
2342: l_fnd_err_msg := FND_MESSAGE.GET;
2343: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): '||l_fnd_err_msg);
2344:
2345: WSMPUTIL.AUTONOMOUS_WRITE_TO_WIE (p_header_id => l_header_id,

Line 2342: l_fnd_err_msg := FND_MESSAGE.GET;

2338: set_wsji_error();
2339:
2340: FND_MESSAGE.SET_NAME('WSM', 'WSM_INVALID_FIELD');
2341: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'wip_entity_name/wip_entity_id in Starting Jobs');
2342: l_fnd_err_msg := FND_MESSAGE.GET;
2343: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): '||l_fnd_err_msg);
2344:
2345: WSMPUTIL.AUTONOMOUS_WRITE_TO_WIE (p_header_id => l_header_id,
2346: p_message => substr(l_fnd_err_msg,1,2000),

Line 2382: FND_MESSAGE.SET_NAME('WSM', 'WSM_NOT_RELEASED_JOB');

2378: When NO_DATA_FOUND Then
2379:
2380: set_wsji_error();
2381:
2382: FND_MESSAGE.SET_NAME('WSM', 'WSM_NOT_RELEASED_JOB');
2383: FND_MESSAGE.SET_TOKEN('FLD_NAME', '');
2384: l_fnd_err_msg := FND_MESSAGE.GET;
2385: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): '||l_fnd_err_msg);
2386:

Line 2383: FND_MESSAGE.SET_TOKEN('FLD_NAME', '');

2379:
2380: set_wsji_error();
2381:
2382: FND_MESSAGE.SET_NAME('WSM', 'WSM_NOT_RELEASED_JOB');
2383: FND_MESSAGE.SET_TOKEN('FLD_NAME', '');
2384: l_fnd_err_msg := FND_MESSAGE.GET;
2385: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): '||l_fnd_err_msg);
2386:
2387: WSMPUTIL.AUTONOMOUS_WRITE_TO_WIE (p_header_id => l_header_id,

Line 2384: l_fnd_err_msg := FND_MESSAGE.GET;

2380: set_wsji_error();
2381:
2382: FND_MESSAGE.SET_NAME('WSM', 'WSM_NOT_RELEASED_JOB');
2383: FND_MESSAGE.SET_TOKEN('FLD_NAME', '');
2384: l_fnd_err_msg := FND_MESSAGE.GET;
2385: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): '||l_fnd_err_msg);
2386:
2387: WSMPUTIL.AUTONOMOUS_WRITE_TO_WIE (p_header_id => l_header_id,
2388: p_message => substr(l_fnd_err_msg,1,2000),

Line 2424: FND_MESSAGE.SET_NAME('WSM', 'WSM_NO_VALID_COPY');

2420: /* ST bug fix 3732580 : check for type 3 */
2421: IF (nvl(l_int_copy_type,0) = 3 /*<> 0*/) THEN -- Incorrect copies
2422: set_wsji_error();
2423:
2424: FND_MESSAGE.SET_NAME('WSM', 'WSM_NO_VALID_COPY');
2425: l_fnd_err_msg := FND_MESSAGE.GET;
2426: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): '||l_fnd_err_msg);
2427:
2428: WSMPUTIL.AUTONOMOUS_WRITE_TO_WIE (p_header_id => l_header_id,

Line 2425: l_fnd_err_msg := FND_MESSAGE.GET;

2421: IF (nvl(l_int_copy_type,0) = 3 /*<> 0*/) THEN -- Incorrect copies
2422: set_wsji_error();
2423:
2424: FND_MESSAGE.SET_NAME('WSM', 'WSM_NO_VALID_COPY');
2425: l_fnd_err_msg := FND_MESSAGE.GET;
2426: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): '||l_fnd_err_msg);
2427:
2428: WSMPUTIL.AUTONOMOUS_WRITE_TO_WIE (p_header_id => l_header_id,
2429: p_message => substr(l_fnd_err_msg,1,2000),

Line 2463: FND_MESSAGE.SET_NAME('WSM', 'WSM_DIFF_JOB_TYP_ST');

2459: AND NVL(wsji.organization_id, l_cur_wsji_rec.organization_id) = we.organization_id
2460: AND we.wip_entity_id = wdj.wip_entity_id;
2461:
2462: IF (l_min_job_type <> l_max_job_type) THEN
2463: FND_MESSAGE.SET_NAME('WSM', 'WSM_DIFF_JOB_TYP_ST');
2464: l_fnd_err_msg := FND_MESSAGE.GET;
2465: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): '||l_fnd_err_msg);
2466:
2467: WSMPUTIL.AUTONOMOUS_WRITE_TO_WIE (p_header_id => l_header_id,

Line 2464: l_fnd_err_msg := FND_MESSAGE.GET;

2460: AND we.wip_entity_id = wdj.wip_entity_id;
2461:
2462: IF (l_min_job_type <> l_max_job_type) THEN
2463: FND_MESSAGE.SET_NAME('WSM', 'WSM_DIFF_JOB_TYP_ST');
2464: l_fnd_err_msg := FND_MESSAGE.GET;
2465: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): '||l_fnd_err_msg);
2466:
2467: WSMPUTIL.AUTONOMOUS_WRITE_TO_WIE (p_header_id => l_header_id,
2468: p_message => substr(l_fnd_err_msg,1,2000),

Line 2507: FND_MESSAGE.SET_NAME('WSM', 'WSM_INVALID_FIELD');

2503: When NO_DATA_FOUND Then
2504:
2505: set_wsji_error();
2506:
2507: FND_MESSAGE.SET_NAME('WSM', 'WSM_INVALID_FIELD');
2508: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'operation_seq_num in Starting Jobs');
2509: l_fnd_err_msg := FND_MESSAGE.GET;
2510: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): '||l_fnd_err_msg);
2511:

Line 2508: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'operation_seq_num in Starting Jobs');

2504:
2505: set_wsji_error();
2506:
2507: FND_MESSAGE.SET_NAME('WSM', 'WSM_INVALID_FIELD');
2508: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'operation_seq_num in Starting Jobs');
2509: l_fnd_err_msg := FND_MESSAGE.GET;
2510: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): '||l_fnd_err_msg);
2511:
2512: WSMPUTIL.AUTONOMOUS_WRITE_TO_WIE (p_header_id => l_header_id,

Line 2509: l_fnd_err_msg := FND_MESSAGE.GET;

2505: set_wsji_error();
2506:
2507: FND_MESSAGE.SET_NAME('WSM', 'WSM_INVALID_FIELD');
2508: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'operation_seq_num in Starting Jobs');
2509: l_fnd_err_msg := FND_MESSAGE.GET;
2510: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): '||l_fnd_err_msg);
2511:
2512: WSMPUTIL.AUTONOMOUS_WRITE_TO_WIE (p_header_id => l_header_id,
2513: p_message => substr(l_fnd_err_msg,1,2000),

Line 2551: FND_MESSAGE.SET_NAME('WSM', 'WSM_INVALID_FIELD');

2547: When NO_DATA_FOUND Then
2548:
2549: set_wsji_error();
2550:
2551: FND_MESSAGE.SET_NAME('WSM', 'WSM_INVALID_FIELD');
2552: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'intraoperation_step in Starting Jobs');
2553: l_fnd_err_msg := FND_MESSAGE.GET;
2554: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): '||l_fnd_err_msg);
2555:

Line 2552: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'intraoperation_step in Starting Jobs');

2548:
2549: set_wsji_error();
2550:
2551: FND_MESSAGE.SET_NAME('WSM', 'WSM_INVALID_FIELD');
2552: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'intraoperation_step in Starting Jobs');
2553: l_fnd_err_msg := FND_MESSAGE.GET;
2554: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): '||l_fnd_err_msg);
2555:
2556: WSMPUTIL.AUTONOMOUS_WRITE_TO_WIE (p_header_id => l_header_id,

Line 2553: l_fnd_err_msg := FND_MESSAGE.GET;

2549: set_wsji_error();
2550:
2551: FND_MESSAGE.SET_NAME('WSM', 'WSM_INVALID_FIELD');
2552: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'intraoperation_step in Starting Jobs');
2553: l_fnd_err_msg := FND_MESSAGE.GET;
2554: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): '||l_fnd_err_msg);
2555:
2556: WSMPUTIL.AUTONOMOUS_WRITE_TO_WIE (p_header_id => l_header_id,
2557: p_message => substr(l_fnd_err_msg,1,2000),

Line 2616: FND_MESSAGE.SET_NAME('WSM', 'WSM_NO_START_FOR_BONUS');

2612: When TOO_MANY_ROWS Then
2613:
2614: set_wsji_error();
2615:
2616: FND_MESSAGE.SET_NAME('WSM', 'WSM_NO_START_FOR_BONUS');
2617: l_fnd_err_msg := FND_MESSAGE.GET;
2618: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): '||l_fnd_err_msg);
2619:
2620: WSMPUTIL.AUTONOMOUS_WRITE_TO_WIE (p_header_id => l_header_id,

Line 2617: l_fnd_err_msg := FND_MESSAGE.GET;

2613:
2614: set_wsji_error();
2615:
2616: FND_MESSAGE.SET_NAME('WSM', 'WSM_NO_START_FOR_BONUS');
2617: l_fnd_err_msg := FND_MESSAGE.GET;
2618: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): '||l_fnd_err_msg);
2619:
2620: WSMPUTIL.AUTONOMOUS_WRITE_TO_WIE (p_header_id => l_header_id,
2621: p_message => substr(l_fnd_err_msg,1,2000),

Line 2674: FND_MESSAGE.SET_NAME('WSM', 'WSM_LOT_IN_USE');

2670: IF (l_count > 1) THEN
2671:
2672: set_wsji_error();
2673:
2674: FND_MESSAGE.SET_NAME('WSM', 'WSM_LOT_IN_USE');
2675: l_fnd_err_msg := FND_MESSAGE.GET;
2676: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): '||l_fnd_err_msg);
2677:
2678: WSMPUTIL.AUTONOMOUS_WRITE_TO_WIE (p_header_id => l_header_id,

Line 2675: l_fnd_err_msg := FND_MESSAGE.GET;

2671:
2672: set_wsji_error();
2673:
2674: FND_MESSAGE.SET_NAME('WSM', 'WSM_LOT_IN_USE');
2675: l_fnd_err_msg := FND_MESSAGE.GET;
2676: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): '||l_fnd_err_msg);
2677:
2678: WSMPUTIL.AUTONOMOUS_WRITE_TO_WIE (p_header_id => l_header_id,
2679: p_message => substr(l_fnd_err_msg,1,2000),

Line 2725: FND_MESSAGE.SET_NAME('WSM', 'WSM_MODIFIED_FIELD');

2721: IF (SQL%ROWCOUNT > 0) THEN
2722:
2723: set_wsji_warning();
2724:
2725: FND_MESSAGE.SET_NAME('WSM', 'WSM_MODIFIED_FIELD');
2726: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'primary_item_id/routing_seq_id in Starting Jobs');
2727: l_fnd_err_msg := FND_MESSAGE.GET;
2728: IF (l_debug = 'Y') THEN
2729: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('

Line 2726: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'primary_item_id/routing_seq_id in Starting Jobs');

2722:
2723: set_wsji_warning();
2724:
2725: FND_MESSAGE.SET_NAME('WSM', 'WSM_MODIFIED_FIELD');
2726: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'primary_item_id/routing_seq_id in Starting Jobs');
2727: l_fnd_err_msg := FND_MESSAGE.GET;
2728: IF (l_debug = 'Y') THEN
2729: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('
2730: ||l_stmt_num||'): '||l_fnd_err_msg);

Line 2727: l_fnd_err_msg := FND_MESSAGE.GET;

2723: set_wsji_warning();
2724:
2725: FND_MESSAGE.SET_NAME('WSM', 'WSM_MODIFIED_FIELD');
2726: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'primary_item_id/routing_seq_id in Starting Jobs');
2727: l_fnd_err_msg := FND_MESSAGE.GET;
2728: IF (l_debug = 'Y') THEN
2729: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('
2730: ||l_stmt_num||'): '||l_fnd_err_msg);
2731: END IF;

Line 2843: FND_MESSAGE.SET_NAME('WSM', 'WSM_INVALID_ROUTING_ID');

2839: -- And this is the representative lot or txn is not a merge txn
2840: -- Then ERROR condition.
2841:
2842:
2843: FND_MESSAGE.SET_NAME('WSM', 'WSM_INVALID_ROUTING_ID');
2844: FND_MESSAGE.SET_TOKEN('TABLE_NAME','WSM_STARTING_JOBS_INTERFACE');
2845: l_fnd_err_msg := FND_MESSAGE.GET;
2846: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): '||l_fnd_err_msg);
2847:

Line 2844: FND_MESSAGE.SET_TOKEN('TABLE_NAME','WSM_STARTING_JOBS_INTERFACE');

2840: -- Then ERROR condition.
2841:
2842:
2843: FND_MESSAGE.SET_NAME('WSM', 'WSM_INVALID_ROUTING_ID');
2844: FND_MESSAGE.SET_TOKEN('TABLE_NAME','WSM_STARTING_JOBS_INTERFACE');
2845: l_fnd_err_msg := FND_MESSAGE.GET;
2846: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): '||l_fnd_err_msg);
2847:
2848: WSMPUTIL.AUTONOMOUS_WRITE_TO_WIE (p_header_id => l_header_id,

Line 2845: l_fnd_err_msg := FND_MESSAGE.GET;

2841:
2842:
2843: FND_MESSAGE.SET_NAME('WSM', 'WSM_INVALID_ROUTING_ID');
2844: FND_MESSAGE.SET_TOKEN('TABLE_NAME','WSM_STARTING_JOBS_INTERFACE');
2845: l_fnd_err_msg := FND_MESSAGE.GET;
2846: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): '||l_fnd_err_msg);
2847:
2848: WSMPUTIL.AUTONOMOUS_WRITE_TO_WIE (p_header_id => l_header_id,
2849: p_message => substr(l_fnd_err_msg,1,2000),

Line 2893: FND_MESSAGE.SET_NAME('WSM', 'WSM_INVALID_FIELD');

2889:
2890: --VJ: End Changes for NSLBJ--
2891:
2892: IF (SQL%ROWCOUNT > 0) THEN
2893: FND_MESSAGE.SET_NAME('WSM', 'WSM_INVALID_FIELD');
2894: --bugfix 1922146: routing_sequence_id instead of common_routing_sequence_id
2895: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'routing_sequence_id in Starting Jobs');
2896: l_fnd_err_msg := FND_MESSAGE.GET;
2897: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): '||l_fnd_err_msg);

Line 2895: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'routing_sequence_id in Starting Jobs');

2891:
2892: IF (SQL%ROWCOUNT > 0) THEN
2893: FND_MESSAGE.SET_NAME('WSM', 'WSM_INVALID_FIELD');
2894: --bugfix 1922146: routing_sequence_id instead of common_routing_sequence_id
2895: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'routing_sequence_id in Starting Jobs');
2896: l_fnd_err_msg := FND_MESSAGE.GET;
2897: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): '||l_fnd_err_msg);
2898:
2899: WSMPUTIL.AUTONOMOUS_WRITE_TO_WIE (p_header_id => l_header_id,

Line 2896: l_fnd_err_msg := FND_MESSAGE.GET;

2892: IF (SQL%ROWCOUNT > 0) THEN
2893: FND_MESSAGE.SET_NAME('WSM', 'WSM_INVALID_FIELD');
2894: --bugfix 1922146: routing_sequence_id instead of common_routing_sequence_id
2895: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'routing_sequence_id in Starting Jobs');
2896: l_fnd_err_msg := FND_MESSAGE.GET;
2897: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): '||l_fnd_err_msg);
2898:
2899: WSMPUTIL.AUTONOMOUS_WRITE_TO_WIE (p_header_id => l_header_id,
2900: p_message => substr(l_fnd_err_msg,1,2000),

Line 2947: FND_MESSAGE.SET_NAME('WSM', 'WSM_NO_MERGE_AT_NSO'); --BBK

2943: when NO_DATA_FOUND then
2944:
2945: set_wsji_error();
2946:
2947: FND_MESSAGE.SET_NAME('WSM', 'WSM_NO_MERGE_AT_NSO'); --BBK
2948: l_fnd_err_msg := FND_MESSAGE.GET;
2949:
2950: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): '||l_fnd_err_msg);
2951: l_error_num := l_stmt_num; -- Bug#2099775

Line 2948: l_fnd_err_msg := FND_MESSAGE.GET;

2944:
2945: set_wsji_error();
2946:
2947: FND_MESSAGE.SET_NAME('WSM', 'WSM_NO_MERGE_AT_NSO'); --BBK
2948: l_fnd_err_msg := FND_MESSAGE.GET;
2949:
2950: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): '||l_fnd_err_msg);
2951: l_error_num := l_stmt_num; -- Bug#2099775
2952:

Line 3033: FND_MESSAGE.SET_NAME('WSM', 'WSM_OP_PURCHASE_REQ');

3029: l_cur_wsji_rec.organization_id,
3030: l_cur_wsji_rec.operation_seq_num,
3031: 5 ) then
3032:
3033: FND_MESSAGE.SET_NAME('WSM', 'WSM_OP_PURCHASE_REQ');
3034: l_fnd_err_msg := FND_MESSAGE.GET;
3035:
3036: WSMPUTIL.AUTONOMOUS_WRITE_TO_WIE (
3037: p_header_id => l_header_id,

Line 3034: l_fnd_err_msg := FND_MESSAGE.GET;

3030: l_cur_wsji_rec.operation_seq_num,
3031: 5 ) then
3032:
3033: FND_MESSAGE.SET_NAME('WSM', 'WSM_OP_PURCHASE_REQ');
3034: l_fnd_err_msg := FND_MESSAGE.GET;
3035:
3036: WSMPUTIL.AUTONOMOUS_WRITE_TO_WIE (
3037: p_header_id => l_header_id,
3038: p_message => substr(l_fnd_err_msg,1,2000),

Line 3260: FND_MESSAGE.SET_NAME('WSM', 'WSM_INVALID_FIELD');

3256:
3257:
3258: set_wrji_error(); -- WLTEnh
3259:
3260: FND_MESSAGE.SET_NAME('WSM', 'WSM_INVALID_FIELD');
3261: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'Split Has Update Assy Flag in Resulting Jobs');
3262: l_fnd_err_msg := FND_MESSAGE.GET;
3263: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): '||l_fnd_err_msg);
3264:

Line 3261: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'Split Has Update Assy Flag in Resulting Jobs');

3257:
3258: set_wrji_error(); -- WLTEnh
3259:
3260: FND_MESSAGE.SET_NAME('WSM', 'WSM_INVALID_FIELD');
3261: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'Split Has Update Assy Flag in Resulting Jobs');
3262: l_fnd_err_msg := FND_MESSAGE.GET;
3263: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): '||l_fnd_err_msg);
3264:
3265: WSMPUTIL.AUTONOMOUS_WRITE_TO_WIE (p_header_id => l_header_id,

Line 3262: l_fnd_err_msg := FND_MESSAGE.GET;

3258: set_wrji_error(); -- WLTEnh
3259:
3260: FND_MESSAGE.SET_NAME('WSM', 'WSM_INVALID_FIELD');
3261: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'Split Has Update Assy Flag in Resulting Jobs');
3262: l_fnd_err_msg := FND_MESSAGE.GET;
3263: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): '||l_fnd_err_msg);
3264:
3265: WSMPUTIL.AUTONOMOUS_WRITE_TO_WIE (p_header_id => l_header_id,
3266: p_message => substr(l_fnd_err_msg,1,2000),

Line 3303: FND_MESSAGE.SET_NAME('WSM', 'WSM_INVALID_FIELD');

3299: IF (SQL%ROWCOUNT > 0) THEN
3300:
3301: set_wrji_error(); -- WLTEnh
3302:
3303: FND_MESSAGE.SET_NAME('WSM', 'WSM_INVALID_FIELD');
3304: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'job_type in Resulting Jobs');
3305: l_fnd_err_msg := FND_MESSAGE.GET;
3306: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): '||l_fnd_err_msg);
3307:

Line 3304: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'job_type in Resulting Jobs');

3300:
3301: set_wrji_error(); -- WLTEnh
3302:
3303: FND_MESSAGE.SET_NAME('WSM', 'WSM_INVALID_FIELD');
3304: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'job_type in Resulting Jobs');
3305: l_fnd_err_msg := FND_MESSAGE.GET;
3306: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): '||l_fnd_err_msg);
3307:
3308: WSMPUTIL.AUTONOMOUS_WRITE_TO_WIE (p_header_id => l_header_id,

Line 3305: l_fnd_err_msg := FND_MESSAGE.GET;

3301: set_wrji_error(); -- WLTEnh
3302:
3303: FND_MESSAGE.SET_NAME('WSM', 'WSM_INVALID_FIELD');
3304: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'job_type in Resulting Jobs');
3305: l_fnd_err_msg := FND_MESSAGE.GET;
3306: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): '||l_fnd_err_msg);
3307:
3308: WSMPUTIL.AUTONOMOUS_WRITE_TO_WIE (p_header_id => l_header_id,
3309: p_message => substr(l_fnd_err_msg,1,2000),

Line 3330: FND_MESSAGE.SET_NAME('WSM', 'WSM_MODIFIED_FIELD');

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');
3331: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'job_type in Resulting Jobs');
3332: l_fnd_err_msg := FND_MESSAGE.GET;
3333:
3334: If l_debug = 'Y' Then

Line 3331: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'job_type in Resulting Jobs');

3327: AND wrji.job_type IS NULL;
3328:
3329: IF (SQL%ROWCOUNT > 0) THEN
3330: FND_MESSAGE.SET_NAME('WSM', 'WSM_MODIFIED_FIELD');
3331: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'job_type in Resulting Jobs');
3332: l_fnd_err_msg := FND_MESSAGE.GET;
3333:
3334: If l_debug = 'Y' Then
3335: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('

Line 3332: l_fnd_err_msg := FND_MESSAGE.GET;

3328:
3329: IF (SQL%ROWCOUNT > 0) THEN
3330: FND_MESSAGE.SET_NAME('WSM', 'WSM_MODIFIED_FIELD');
3331: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'job_type in Resulting Jobs');
3332: l_fnd_err_msg := FND_MESSAGE.GET;
3333:
3334: If l_debug = 'Y' Then
3335: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('
3336: ||l_stmt_num||'): '||l_fnd_err_msg);

Line 3390: FND_MESSAGE.SET_NAME('WSM', 'WSM_MODIFIED_FIELD');

3386: WHERE wrji.header_id = l_header_id
3387: and wrji.job_type IS NULL;
3388:
3389: IF (SQL%ROWCOUNT > 0) THEN
3390: FND_MESSAGE.SET_NAME('WSM', 'WSM_MODIFIED_FIELD');
3391: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'job_type in Resulting Jobs');
3392: l_fnd_err_msg := FND_MESSAGE.GET;
3393: If l_debug = 'Y' Then
3394: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('

Line 3391: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'job_type in Resulting Jobs');

3387: and wrji.job_type IS NULL;
3388:
3389: IF (SQL%ROWCOUNT > 0) THEN
3390: FND_MESSAGE.SET_NAME('WSM', 'WSM_MODIFIED_FIELD');
3391: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'job_type in Resulting Jobs');
3392: l_fnd_err_msg := FND_MESSAGE.GET;
3393: If l_debug = 'Y' Then
3394: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('
3395: ||l_stmt_num||'): '||l_fnd_err_msg);

Line 3392: l_fnd_err_msg := FND_MESSAGE.GET;

3388:
3389: IF (SQL%ROWCOUNT > 0) THEN
3390: FND_MESSAGE.SET_NAME('WSM', 'WSM_MODIFIED_FIELD');
3391: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'job_type in Resulting Jobs');
3392: l_fnd_err_msg := FND_MESSAGE.GET;
3393: If l_debug = 'Y' Then
3394: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('
3395: ||l_stmt_num||'): '||l_fnd_err_msg);
3396: End If;

Line 3419: FND_MESSAGE.SET_NAME('WSM', 'WSM_INVALID_FIELD');

3415: AND wrji.job_type <> l_min_job_type;
3416:
3417: IF (SQL%ROWCOUNT > 0) THEN
3418: set_wrji_error(); -- WLTEnh
3419: FND_MESSAGE.SET_NAME('WSM', 'WSM_INVALID_FIELD');
3420: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'job_type in Resulting Jobs');
3421: l_fnd_err_msg := FND_MESSAGE.GET;
3422: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): '||l_fnd_err_msg);
3423:

Line 3420: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'job_type in Resulting Jobs');

3416:
3417: IF (SQL%ROWCOUNT > 0) THEN
3418: set_wrji_error(); -- WLTEnh
3419: FND_MESSAGE.SET_NAME('WSM', 'WSM_INVALID_FIELD');
3420: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'job_type in Resulting Jobs');
3421: l_fnd_err_msg := FND_MESSAGE.GET;
3422: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): '||l_fnd_err_msg);
3423:
3424: WSMPUTIL.AUTONOMOUS_WRITE_TO_WIE (p_header_id => l_header_id,

Line 3421: l_fnd_err_msg := FND_MESSAGE.GET;

3417: IF (SQL%ROWCOUNT > 0) THEN
3418: set_wrji_error(); -- WLTEnh
3419: FND_MESSAGE.SET_NAME('WSM', 'WSM_INVALID_FIELD');
3420: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'job_type in Resulting Jobs');
3421: l_fnd_err_msg := FND_MESSAGE.GET;
3422: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): '||l_fnd_err_msg);
3423:
3424: WSMPUTIL.AUTONOMOUS_WRITE_TO_WIE (p_header_id => l_header_id,
3425: p_message => substr(l_fnd_err_msg,1,2000),

Line 3438: FND_MESSAGE.SET_NAME('WSM', 'WSM_DIFF_JOB_TYP');

3434: END IF;
3435: END IF;
3436: ELSE --IF (l_min_job_type <> l_max_job_type)
3437: set_wrji_error(); -- WLTEnh
3438: FND_MESSAGE.SET_NAME('WSM', 'WSM_DIFF_JOB_TYP');
3439: l_fnd_err_msg := FND_MESSAGE.GET;
3440: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): '||l_fnd_err_msg);
3441:
3442: WSMPUTIL.AUTONOMOUS_WRITE_TO_WIE (p_header_id => l_header_id,

Line 3439: l_fnd_err_msg := FND_MESSAGE.GET;

3435: END IF;
3436: ELSE --IF (l_min_job_type <> l_max_job_type)
3437: set_wrji_error(); -- WLTEnh
3438: FND_MESSAGE.SET_NAME('WSM', 'WSM_DIFF_JOB_TYP');
3439: l_fnd_err_msg := FND_MESSAGE.GET;
3440: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): '||l_fnd_err_msg);
3441:
3442: WSMPUTIL.AUTONOMOUS_WRITE_TO_WIE (p_header_id => l_header_id,
3443: p_message => substr(l_fnd_err_msg,1,2000),

Line 3474: FND_MESSAGE.SET_NAME('WSM', 'WSM_MODIFIED_FIELD');

3470: WHERE wrji.header_id = l_header_id
3471: AND wrji.organization_id IS NULL;
3472:
3473: IF (SQL%ROWCOUNT > 0) THEN
3474: FND_MESSAGE.SET_NAME('WSM', 'WSM_MODIFIED_FIELD');
3475: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'organization_id in Resulting Jobs');
3476: l_fnd_err_msg := FND_MESSAGE.GET;
3477:
3478: If l_debug = 'Y' Then

Line 3475: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'organization_id in Resulting Jobs');

3471: AND wrji.organization_id IS NULL;
3472:
3473: IF (SQL%ROWCOUNT > 0) THEN
3474: FND_MESSAGE.SET_NAME('WSM', 'WSM_MODIFIED_FIELD');
3475: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'organization_id in Resulting Jobs');
3476: l_fnd_err_msg := FND_MESSAGE.GET;
3477:
3478: If l_debug = 'Y' Then
3479: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('

Line 3476: l_fnd_err_msg := FND_MESSAGE.GET;

3472:
3473: IF (SQL%ROWCOUNT > 0) THEN
3474: FND_MESSAGE.SET_NAME('WSM', 'WSM_MODIFIED_FIELD');
3475: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'organization_id in Resulting Jobs');
3476: l_fnd_err_msg := FND_MESSAGE.GET;
3477:
3478: If l_debug = 'Y' Then
3479: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('
3480: ||l_stmt_num||'): '||l_fnd_err_msg);

Line 3511: FND_MESSAGE.SET_NAME('WSM', 'WSM_INVALID_FIELD');

3507:
3508:
3509: IF (SQL%ROWCOUNT > 0) THEN
3510: set_wrji_error(); -- WLTEnh
3511: FND_MESSAGE.SET_NAME('WSM', 'WSM_INVALID_FIELD');
3512: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'organization_id in Resulting Jobs');
3513: l_fnd_err_msg := FND_MESSAGE.GET;
3514: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): '||l_fnd_err_msg);
3515:

Line 3512: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'organization_id in Resulting Jobs');

3508:
3509: IF (SQL%ROWCOUNT > 0) THEN
3510: set_wrji_error(); -- WLTEnh
3511: FND_MESSAGE.SET_NAME('WSM', 'WSM_INVALID_FIELD');
3512: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'organization_id in Resulting Jobs');
3513: l_fnd_err_msg := FND_MESSAGE.GET;
3514: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): '||l_fnd_err_msg);
3515:
3516: WSMPUTIL.AUTONOMOUS_WRITE_TO_WIE (p_header_id => l_header_id,

Line 3513: l_fnd_err_msg := FND_MESSAGE.GET;

3509: IF (SQL%ROWCOUNT > 0) THEN
3510: set_wrji_error(); -- WLTEnh
3511: FND_MESSAGE.SET_NAME('WSM', 'WSM_INVALID_FIELD');
3512: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'organization_id in Resulting Jobs');
3513: l_fnd_err_msg := FND_MESSAGE.GET;
3514: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): '||l_fnd_err_msg);
3515:
3516: WSMPUTIL.AUTONOMOUS_WRITE_TO_WIE (p_header_id => l_header_id,
3517: p_message => substr(l_fnd_err_msg,1,2000),

Line 3545: FND_MESSAGE.SET_NAME('WSM', 'WSM_NO_START_END_DATES');

3541: and sj.representative_flag = 'Y';
3542: EXCEPTION
3543: WHEN OTHERS THEN
3544:
3545: FND_MESSAGE.SET_NAME('WSM', 'WSM_NO_START_END_DATES');
3546: l_fnd_err_msg := FND_MESSAGE.GET;
3547: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): '||l_fnd_err_msg);
3548:
3549: WSMPUTIL.AUTONOMOUS_WRITE_TO_WIE (p_header_id => l_header_id,

Line 3546: l_fnd_err_msg := FND_MESSAGE.GET;

3542: EXCEPTION
3543: WHEN OTHERS THEN
3544:
3545: FND_MESSAGE.SET_NAME('WSM', 'WSM_NO_START_END_DATES');
3546: l_fnd_err_msg := FND_MESSAGE.GET;
3547: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): '||l_fnd_err_msg);
3548:
3549: WSMPUTIL.AUTONOMOUS_WRITE_TO_WIE (p_header_id => l_header_id,
3550: p_message => substr(l_fnd_err_msg,1,2000),

Line 3569: FND_MESSAGE.SET_NAME('WSM', 'WSM_MODIFIED_FIELD');

3565: and rj.internal_group_id = WSMPLOAD.G_GROUP_ID
3566: and rj.header_id = l_header_id;
3567:
3568: IF (SQL%ROWCOUNT > 0) THEN
3569: FND_MESSAGE.SET_NAME('WSM', 'WSM_MODIFIED_FIELD');
3570: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'scheduled_start_date/scheduled_completion_date in Resulting Jobs');
3571: l_fnd_err_msg := FND_MESSAGE.GET;
3572: If l_debug = 'Y' Then
3573: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('

Line 3570: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'scheduled_start_date/scheduled_completion_date in Resulting Jobs');

3566: and rj.header_id = l_header_id;
3567:
3568: IF (SQL%ROWCOUNT > 0) THEN
3569: FND_MESSAGE.SET_NAME('WSM', 'WSM_MODIFIED_FIELD');
3570: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'scheduled_start_date/scheduled_completion_date in Resulting Jobs');
3571: l_fnd_err_msg := FND_MESSAGE.GET;
3572: If l_debug = 'Y' Then
3573: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('
3574: ||l_stmt_num||'): '||l_fnd_err_msg);

Line 3571: l_fnd_err_msg := FND_MESSAGE.GET;

3567:
3568: IF (SQL%ROWCOUNT > 0) THEN
3569: FND_MESSAGE.SET_NAME('WSM', 'WSM_MODIFIED_FIELD');
3570: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'scheduled_start_date/scheduled_completion_date in Resulting Jobs');
3571: l_fnd_err_msg := FND_MESSAGE.GET;
3572: If l_debug = 'Y' Then
3573: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('
3574: ||l_stmt_num||'): '||l_fnd_err_msg);
3575: End If;

Line 3703: FND_MESSAGE.SET_NAME('WSM', 'WSM_INVALID_FIELD');

3699:
3700: IF (l_bom_reference_id IS NOT NULL AND --Takes care of bug #2352344 for NSLBJ--
3701: (l_wdj_bom_ref_id <> l_bom_reference_id)) THEN
3702:
3703: FND_MESSAGE.SET_NAME('WSM', 'WSM_INVALID_FIELD');
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;

Line 3704: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'bom_reference_id in Resulting Jobs');

3700: IF (l_bom_reference_id IS NOT NULL AND --Takes care of bug #2352344 for NSLBJ--
3701: (l_wdj_bom_ref_id <> l_bom_reference_id)) THEN
3702:
3703: FND_MESSAGE.SET_NAME('WSM', 'WSM_INVALID_FIELD');
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

Line 3705: l_fnd_err_msg := FND_MESSAGE.GET;

3701: (l_wdj_bom_ref_id <> l_bom_reference_id)) THEN
3702:
3703: FND_MESSAGE.SET_NAME('WSM', 'WSM_INVALID_FIELD');
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

Line 3746: FND_MESSAGE.SET_NAME('WSM', 'WSM_MODIFIED_FIELD');

3742: l_wrji_bom_seq_id := l_wdj_bom_seq_id;
3743: l_bom_revision_date := l_wdj_bom_rev_dt;
3744: l_bom_revision := l_wdj_bom_rev;
3745:
3746: FND_MESSAGE.SET_NAME('WSM', 'WSM_MODIFIED_FIELD');
3747: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'Bom information in Resulting Jobs');
3748: l_fnd_err_msg := FND_MESSAGE.GET;
3749: IF (l_debug = 'Y') THEN
3750: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('

Line 3747: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'Bom information in Resulting Jobs');

3743: l_bom_revision_date := l_wdj_bom_rev_dt;
3744: l_bom_revision := l_wdj_bom_rev;
3745:
3746: FND_MESSAGE.SET_NAME('WSM', 'WSM_MODIFIED_FIELD');
3747: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'Bom information in Resulting Jobs');
3748: l_fnd_err_msg := FND_MESSAGE.GET;
3749: IF (l_debug = 'Y') THEN
3750: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('
3751: ||l_stmt_num||'): '||l_fnd_err_msg);

Line 3748: l_fnd_err_msg := FND_MESSAGE.GET;

3744: l_bom_revision := l_wdj_bom_rev;
3745:
3746: FND_MESSAGE.SET_NAME('WSM', 'WSM_MODIFIED_FIELD');
3747: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'Bom information in Resulting Jobs');
3748: l_fnd_err_msg := FND_MESSAGE.GET;
3749: IF (l_debug = 'Y') THEN
3750: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('
3751: ||l_stmt_num||'): '||l_fnd_err_msg);
3752: END IF;

Line 3772: FND_MESSAGE.SET_NAME('WSM', 'WSM_INVALID_FIELD');

3768: IF (l_nslbj_alt_bom_desig IS NOT NULL AND --Takes care of bug #2352344 for NSLBJ--
3769: (nvl(l_wdj_alt_bom_desig,'#*#*#') <> l_nslbj_alt_bom_desig)) THEN
3770: --VJ: CodeRVW: Start Changes for NSLBJ--
3771:
3772: FND_MESSAGE.SET_NAME('WSM', 'WSM_INVALID_FIELD');
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;

Line 3773: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'alternate_bom_designator in Resulting Jobs');

3769: (nvl(l_wdj_alt_bom_desig,'#*#*#') <> l_nslbj_alt_bom_desig)) THEN
3770: --VJ: CodeRVW: Start Changes for NSLBJ--
3771:
3772: FND_MESSAGE.SET_NAME('WSM', 'WSM_INVALID_FIELD');
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

Line 3774: l_fnd_err_msg := FND_MESSAGE.GET;

3770: --VJ: CodeRVW: Start Changes for NSLBJ--
3771:
3772: FND_MESSAGE.SET_NAME('WSM', 'WSM_INVALID_FIELD');
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

Line 3806: FND_MESSAGE.SET_NAME('WSM', 'WSM_INVALID_FIELD');

3802: IF (l_wrji_bom_seq_id <> -1 AND --Fixed bug #2345536
3803: (nvl(l_wdj_bom_seq_id, -1) <> l_wrji_bom_seq_id)) THEN
3804: --VJ: CodeRVW: Start Changes for NSLBJ--
3805:
3806: FND_MESSAGE.SET_NAME('WSM', 'WSM_INVALID_FIELD');
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;

Line 3807: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'common_bom_sequence_id in Resulting Jobs');

3803: (nvl(l_wdj_bom_seq_id, -1) <> l_wrji_bom_seq_id)) THEN
3804: --VJ: CodeRVW: Start Changes for NSLBJ--
3805:
3806: FND_MESSAGE.SET_NAME('WSM', 'WSM_INVALID_FIELD');
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

Line 3808: l_fnd_err_msg := FND_MESSAGE.GET;

3804: --VJ: CodeRVW: Start Changes for NSLBJ--
3805:
3806: FND_MESSAGE.SET_NAME('WSM', 'WSM_INVALID_FIELD');
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

Line 3919: FND_MESSAGE.SET_NAME('WSM', 'WSM_MODIFIED_FIELD');

3915: common_bom_sequence_id = l_st_bom_seq_id
3916: WHERE header_id = l_header_id
3917: AND wip_entity_name = l_we_name;
3918:
3919: FND_MESSAGE.SET_NAME('WSM', 'WSM_MODIFIED_FIELD');
3920: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'Bom information in Resulting Jobs');
3921: l_fnd_err_msg := FND_MESSAGE.GET;
3922: IF (l_debug = 'Y') THEN
3923: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('

Line 3920: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'Bom information in Resulting Jobs');

3916: WHERE header_id = l_header_id
3917: AND wip_entity_name = l_we_name;
3918:
3919: FND_MESSAGE.SET_NAME('WSM', 'WSM_MODIFIED_FIELD');
3920: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'Bom information in Resulting Jobs');
3921: l_fnd_err_msg := FND_MESSAGE.GET;
3922: IF (l_debug = 'Y') THEN
3923: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('
3924: ||l_stmt_num||'): '||l_fnd_err_msg);

Line 3921: l_fnd_err_msg := FND_MESSAGE.GET;

3917: AND wip_entity_name = l_we_name;
3918:
3919: FND_MESSAGE.SET_NAME('WSM', 'WSM_MODIFIED_FIELD');
3920: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'Bom information in Resulting Jobs');
3921: l_fnd_err_msg := FND_MESSAGE.GET;
3922: IF (l_debug = 'Y') THEN
3923: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('
3924: ||l_stmt_num||'): '||l_fnd_err_msg);
3925: END IF;

Line 3953: FND_MESSAGE.SET_NAME('WSM', 'WSM_MODIFIED_FIELD');

3949: AND wip_entity_name = l_we_name;
3950:
3951: l_wrji_rtg_seq_id := l_st_rtg_seq_id;
3952:
3953: FND_MESSAGE.SET_NAME('WSM', 'WSM_MODIFIED_FIELD');
3954: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'Routing information in Resulting Jobs');
3955: l_fnd_err_msg := FND_MESSAGE.GET;
3956: IF (l_debug = 'Y') THEN
3957: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('

Line 3954: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'Routing information in Resulting Jobs');

3950:
3951: l_wrji_rtg_seq_id := l_st_rtg_seq_id;
3952:
3953: FND_MESSAGE.SET_NAME('WSM', 'WSM_MODIFIED_FIELD');
3954: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'Routing information in Resulting Jobs');
3955: l_fnd_err_msg := FND_MESSAGE.GET;
3956: IF (l_debug = 'Y') THEN
3957: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('
3958: ||l_stmt_num||'): '||l_fnd_err_msg);

Line 3955: l_fnd_err_msg := FND_MESSAGE.GET;

3951: l_wrji_rtg_seq_id := l_st_rtg_seq_id;
3952:
3953: FND_MESSAGE.SET_NAME('WSM', 'WSM_MODIFIED_FIELD');
3954: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'Routing information in Resulting Jobs');
3955: l_fnd_err_msg := FND_MESSAGE.GET;
3956: IF (l_debug = 'Y') THEN
3957: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('
3958: ||l_stmt_num||'): '||l_fnd_err_msg);
3959: END IF;

Line 4093: FND_MESSAGE.SET_NAME('WSM', 'WSM_MODIFIED_FIELD');

4089: AND rowid = l_wrji_rowid; --SpUA add
4090:
4091: l_wrji_rtg_seq_id := l_nsj_routing_seq_id; --Added to fix bug #2352354
4092:
4093: FND_MESSAGE.SET_NAME('WSM', 'WSM_MODIFIED_FIELD');
4094: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'common_routing_sequence_id in Resulting Jobs');
4095: l_fnd_err_msg := FND_MESSAGE.GET;
4096: IF (l_debug = 'Y') THEN
4097: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('

Line 4094: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'common_routing_sequence_id in Resulting Jobs');

4090:
4091: l_wrji_rtg_seq_id := l_nsj_routing_seq_id; --Added to fix bug #2352354
4092:
4093: FND_MESSAGE.SET_NAME('WSM', 'WSM_MODIFIED_FIELD');
4094: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'common_routing_sequence_id in Resulting Jobs');
4095: l_fnd_err_msg := FND_MESSAGE.GET;
4096: IF (l_debug = 'Y') THEN
4097: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('
4098: ||l_stmt_num||'): '||l_fnd_err_msg);

Line 4095: l_fnd_err_msg := FND_MESSAGE.GET;

4091: l_wrji_rtg_seq_id := l_nsj_routing_seq_id; --Added to fix bug #2352354
4092:
4093: FND_MESSAGE.SET_NAME('WSM', 'WSM_MODIFIED_FIELD');
4094: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'common_routing_sequence_id in Resulting Jobs');
4095: l_fnd_err_msg := FND_MESSAGE.GET;
4096: IF (l_debug = 'Y') THEN
4097: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('
4098: ||l_stmt_num||'): '||l_fnd_err_msg);
4099: END IF;

Line 4121: FND_MESSAGE.SET_NAME('WSM', 'WSM_INVALID_FIELD');

4117: AND rowid = l_wrji_rowid; --SpUA add
4118:
4119: set_wrji_error(); -- WLTEnh
4120:
4121: FND_MESSAGE.SET_NAME('WSM', 'WSM_INVALID_FIELD');
4122: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'common_routing_sequence_id in Resulting Jobs');
4123: l_fnd_err_msg := FND_MESSAGE.GET;
4124: IF (l_debug = 'Y') THEN
4125: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('

Line 4122: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'common_routing_sequence_id in Resulting Jobs');

4118:
4119: set_wrji_error(); -- WLTEnh
4120:
4121: FND_MESSAGE.SET_NAME('WSM', 'WSM_INVALID_FIELD');
4122: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'common_routing_sequence_id in Resulting Jobs');
4123: l_fnd_err_msg := FND_MESSAGE.GET;
4124: IF (l_debug = 'Y') THEN
4125: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('
4126: ||l_stmt_num||'): '||l_fnd_err_msg);

Line 4123: l_fnd_err_msg := FND_MESSAGE.GET;

4119: set_wrji_error(); -- WLTEnh
4120:
4121: FND_MESSAGE.SET_NAME('WSM', 'WSM_INVALID_FIELD');
4122: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'common_routing_sequence_id in Resulting Jobs');
4123: l_fnd_err_msg := FND_MESSAGE.GET;
4124: IF (l_debug = 'Y') THEN
4125: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('
4126: ||l_stmt_num||'): '||l_fnd_err_msg);
4127: END IF;

Line 4148: FND_MESSAGE.SET_NAME('WSM', 'WSM_MODIFIED_FIELD');

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:
4148: FND_MESSAGE.SET_NAME('WSM', 'WSM_MODIFIED_FIELD');
4149: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'common_bom_sequence_id in Resulting Jobs');
4150: l_fnd_err_msg := FND_MESSAGE.GET;
4151: IF (l_debug = 'Y') THEN
4152: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('

Line 4149: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'common_bom_sequence_id in Resulting Jobs');

4145: WHERE header_id = l_header_id
4146: AND rowid = l_wrji_rowid; --SpUA add
4147:
4148: FND_MESSAGE.SET_NAME('WSM', 'WSM_MODIFIED_FIELD');
4149: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'common_bom_sequence_id in Resulting Jobs');
4150: l_fnd_err_msg := FND_MESSAGE.GET;
4151: IF (l_debug = 'Y') THEN
4152: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('
4153: ||l_stmt_num||'): '||l_fnd_err_msg);

Line 4150: l_fnd_err_msg := FND_MESSAGE.GET;

4146: AND rowid = l_wrji_rowid; --SpUA add
4147:
4148: FND_MESSAGE.SET_NAME('WSM', 'WSM_MODIFIED_FIELD');
4149: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'common_bom_sequence_id in Resulting Jobs');
4150: l_fnd_err_msg := FND_MESSAGE.GET;
4151: IF (l_debug = 'Y') THEN
4152: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('
4153: ||l_stmt_num||'): '||l_fnd_err_msg);
4154: END IF;

Line 4177: FND_MESSAGE.SET_NAME('WSM', 'WSM_INVALID_FIELD');

4173: AND rowid = l_wrji_rowid; --SpUA add
4174:
4175: set_wrji_error(); -- WLTEnh
4176:
4177: FND_MESSAGE.SET_NAME('WSM', 'WSM_INVALID_FIELD');
4178: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'common_bom_sequence_id in Resulting Jobs');
4179: l_fnd_err_msg := FND_MESSAGE.GET;
4180: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('
4181: ||l_stmt_num||'): '||l_fnd_err_msg);

Line 4178: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'common_bom_sequence_id in Resulting Jobs');

4174:
4175: set_wrji_error(); -- WLTEnh
4176:
4177: FND_MESSAGE.SET_NAME('WSM', 'WSM_INVALID_FIELD');
4178: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'common_bom_sequence_id in Resulting Jobs');
4179: l_fnd_err_msg := FND_MESSAGE.GET;
4180: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('
4181: ||l_stmt_num||'): '||l_fnd_err_msg);
4182: WSMPUTIL.AUTONOMOUS_WRITE_TO_WIE (p_header_id => l_header_id,

Line 4179: l_fnd_err_msg := FND_MESSAGE.GET;

4175: set_wrji_error(); -- WLTEnh
4176:
4177: FND_MESSAGE.SET_NAME('WSM', 'WSM_INVALID_FIELD');
4178: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'common_bom_sequence_id in Resulting Jobs');
4179: l_fnd_err_msg := FND_MESSAGE.GET;
4180: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('
4181: ||l_stmt_num||'): '||l_fnd_err_msg);
4182: WSMPUTIL.AUTONOMOUS_WRITE_TO_WIE (p_header_id => l_header_id,
4183: p_message => substr(l_fnd_err_msg,1,2000),

Line 4281: FND_MESSAGE.SET_NAME('WSM', 'WSM_CURRENT_REPRESENTATIVE_LOT');

4277: IF (SQL%ROWCOUNT > 0) THEN
4278:
4279: set_wrji_error(); -- WLTEnh
4280:
4281: FND_MESSAGE.SET_NAME('WSM', 'WSM_CURRENT_REPRESENTATIVE_LOT');
4282: l_fnd_err_msg := FND_MESSAGE.GET;
4283: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): '||l_fnd_err_msg);
4284:
4285: WSMPUTIL.AUTONOMOUS_WRITE_TO_WIE (p_header_id => l_header_id,

Line 4282: l_fnd_err_msg := FND_MESSAGE.GET;

4278:
4279: set_wrji_error(); -- WLTEnh
4280:
4281: FND_MESSAGE.SET_NAME('WSM', 'WSM_CURRENT_REPRESENTATIVE_LOT');
4282: l_fnd_err_msg := FND_MESSAGE.GET;
4283: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): '||l_fnd_err_msg);
4284:
4285: WSMPUTIL.AUTONOMOUS_WRITE_TO_WIE (p_header_id => l_header_id,
4286: p_message => substr(l_fnd_err_msg,1,2000),

Line 4313: FND_MESSAGE.SET_NAME('WSM', 'WSM_NO_START_END_DATES');

4309:
4310: IF (SQL%ROWCOUNT > 0) THEN
4311: set_wrji_error(); -- WLTEnh
4312:
4313: FND_MESSAGE.SET_NAME('WSM', 'WSM_NO_START_END_DATES');
4314: l_fnd_err_msg := FND_MESSAGE.GET;
4315: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): '||l_fnd_err_msg);
4316:
4317: WSMPUTIL.AUTONOMOUS_WRITE_TO_WIE (p_header_id => l_header_id,

Line 4314: l_fnd_err_msg := FND_MESSAGE.GET;

4310: IF (SQL%ROWCOUNT > 0) THEN
4311: set_wrji_error(); -- WLTEnh
4312:
4313: FND_MESSAGE.SET_NAME('WSM', 'WSM_NO_START_END_DATES');
4314: l_fnd_err_msg := FND_MESSAGE.GET;
4315: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): '||l_fnd_err_msg);
4316:
4317: WSMPUTIL.AUTONOMOUS_WRITE_TO_WIE (p_header_id => l_header_id,
4318: p_message => substr(l_fnd_err_msg,1,2000),

Line 4363: FND_MESSAGE.SET_NAME('WSM', 'WSM_MODIFIED_FIELD');

4359: WHERE wrji.internal_group_id = WSMPLOAD.G_GROUP_ID
4360: AND wrji.header_id = l_header_id;
4361:
4362: IF (SQL%ROWCOUNT > 0) THEN
4363: FND_MESSAGE.SET_NAME('WSM', 'WSM_MODIFIED_FIELD');
4364: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'scheduled_completion_date in Resulting Jobs');
4365: l_fnd_err_msg := FND_MESSAGE.GET;
4366: If l_debug = 'Y' Then
4367: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('

Line 4364: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'scheduled_completion_date in Resulting Jobs');

4360: AND wrji.header_id = l_header_id;
4361:
4362: IF (SQL%ROWCOUNT > 0) THEN
4363: FND_MESSAGE.SET_NAME('WSM', 'WSM_MODIFIED_FIELD');
4364: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'scheduled_completion_date in Resulting Jobs');
4365: l_fnd_err_msg := FND_MESSAGE.GET;
4366: If l_debug = 'Y' Then
4367: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('
4368: ||l_stmt_num||'): '||l_fnd_err_msg);

Line 4365: l_fnd_err_msg := FND_MESSAGE.GET;

4361:
4362: IF (SQL%ROWCOUNT > 0) THEN
4363: FND_MESSAGE.SET_NAME('WSM', 'WSM_MODIFIED_FIELD');
4364: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'scheduled_completion_date in Resulting Jobs');
4365: l_fnd_err_msg := FND_MESSAGE.GET;
4366: If l_debug = 'Y' Then
4367: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('
4368: ||l_stmt_num||'): '||l_fnd_err_msg);
4369: End If;

Line 4408: FND_MESSAGE.SET_NAME('WSM', 'WSM_MODIFIED_FIELD');

4404: WHERE wrji.internal_group_id = WSMPLOAD.G_GROUP_ID
4405: AND wrji.header_id = l_header_id;
4406:
4407: IF (SQL%ROWCOUNT > 0) THEN
4408: FND_MESSAGE.SET_NAME('WSM', 'WSM_MODIFIED_FIELD');
4409: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'scheduled_start_date in Resulting Jobs');
4410: l_fnd_err_msg := FND_MESSAGE.GET;
4411: If l_debug = 'Y' Then
4412: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('

Line 4409: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'scheduled_start_date in Resulting Jobs');

4405: AND wrji.header_id = l_header_id;
4406:
4407: IF (SQL%ROWCOUNT > 0) THEN
4408: FND_MESSAGE.SET_NAME('WSM', 'WSM_MODIFIED_FIELD');
4409: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'scheduled_start_date in Resulting Jobs');
4410: l_fnd_err_msg := FND_MESSAGE.GET;
4411: If l_debug = 'Y' Then
4412: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('
4413: ||l_stmt_num||'): '||l_fnd_err_msg);

Line 4410: l_fnd_err_msg := FND_MESSAGE.GET;

4406:
4407: IF (SQL%ROWCOUNT > 0) THEN
4408: FND_MESSAGE.SET_NAME('WSM', 'WSM_MODIFIED_FIELD');
4409: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'scheduled_start_date in Resulting Jobs');
4410: l_fnd_err_msg := FND_MESSAGE.GET;
4411: If l_debug = 'Y' Then
4412: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('
4413: ||l_stmt_num||'): '||l_fnd_err_msg);
4414: End If;

Line 4452: FND_MESSAGE.SET_NAME('WSM', 'WSM_INVALID_DATES');

4448:
4449: IF (SQL%ROWCOUNT > 0) THEN
4450: set_wrji_error(); -- WLTEnh
4451:
4452: FND_MESSAGE.SET_NAME('WSM', 'WSM_INVALID_DATES');
4453: l_fnd_err_msg := FND_MESSAGE.GET;
4454: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): '||l_fnd_err_msg);
4455:
4456: WSMPUTIL.AUTONOMOUS_WRITE_TO_WIE (p_header_id => l_header_id,

Line 4453: l_fnd_err_msg := FND_MESSAGE.GET;

4449: IF (SQL%ROWCOUNT > 0) THEN
4450: set_wrji_error(); -- WLTEnh
4451:
4452: FND_MESSAGE.SET_NAME('WSM', 'WSM_INVALID_DATES');
4453: l_fnd_err_msg := FND_MESSAGE.GET;
4454: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): '||l_fnd_err_msg);
4455:
4456: WSMPUTIL.AUTONOMOUS_WRITE_TO_WIE (p_header_id => l_header_id,
4457: p_message => substr(l_fnd_err_msg,1,2000),

Line 4486: FND_MESSAGE.SET_NAME('WSM', 'WSM_INVALID_FIELD');

4482:
4483: IF (SQL%ROWCOUNT > 0) THEN
4484: set_wrji_error(); -- WLTEnh
4485:
4486: FND_MESSAGE.SET_NAME('WSM', 'WSM_INVALID_FIELD');
4487: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'header_id in Resulting Jobs');
4488: l_fnd_err_msg := FND_MESSAGE.GET;
4489: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): '||l_fnd_err_msg);
4490:

Line 4487: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'header_id in Resulting Jobs');

4483: IF (SQL%ROWCOUNT > 0) THEN
4484: set_wrji_error(); -- WLTEnh
4485:
4486: FND_MESSAGE.SET_NAME('WSM', 'WSM_INVALID_FIELD');
4487: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'header_id in Resulting Jobs');
4488: l_fnd_err_msg := FND_MESSAGE.GET;
4489: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): '||l_fnd_err_msg);
4490:
4491: WSMPUTIL.AUTONOMOUS_WRITE_TO_WIE (p_header_id => l_header_id,

Line 4488: l_fnd_err_msg := FND_MESSAGE.GET;

4484: set_wrji_error(); -- WLTEnh
4485:
4486: FND_MESSAGE.SET_NAME('WSM', 'WSM_INVALID_FIELD');
4487: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'header_id in Resulting Jobs');
4488: l_fnd_err_msg := FND_MESSAGE.GET;
4489: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): '||l_fnd_err_msg);
4490:
4491: WSMPUTIL.AUTONOMOUS_WRITE_TO_WIE (p_header_id => l_header_id,
4492: p_message => substr(l_fnd_err_msg,1,2000),

Line 4522: FND_MESSAGE.SET_NAME('WSM', 'WSM_EXCEED_MAX_LEN');

4518:
4519: IF (SQL%ROWCOUNT > 0) THEN
4520: set_wrji_error(); -- WLTEnh
4521:
4522: FND_MESSAGE.SET_NAME('WSM', 'WSM_EXCEED_MAX_LEN');
4523: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'wip_entity_name in Resulting Jobs');
4524: FND_MESSAGE.SET_TOKEN('VALUE', '30');
4525: l_fnd_err_msg := FND_MESSAGE.GET;
4526: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): '||l_fnd_err_msg);

Line 4523: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'wip_entity_name in Resulting Jobs');

4519: IF (SQL%ROWCOUNT > 0) THEN
4520: set_wrji_error(); -- WLTEnh
4521:
4522: FND_MESSAGE.SET_NAME('WSM', 'WSM_EXCEED_MAX_LEN');
4523: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'wip_entity_name in Resulting Jobs');
4524: FND_MESSAGE.SET_TOKEN('VALUE', '30');
4525: l_fnd_err_msg := FND_MESSAGE.GET;
4526: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): '||l_fnd_err_msg);
4527:

Line 4524: FND_MESSAGE.SET_TOKEN('VALUE', '30');

4520: set_wrji_error(); -- WLTEnh
4521:
4522: FND_MESSAGE.SET_NAME('WSM', 'WSM_EXCEED_MAX_LEN');
4523: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'wip_entity_name in Resulting Jobs');
4524: FND_MESSAGE.SET_TOKEN('VALUE', '30');
4525: l_fnd_err_msg := FND_MESSAGE.GET;
4526: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): '||l_fnd_err_msg);
4527:
4528: WSMPUTIL.AUTONOMOUS_WRITE_TO_WIE (p_header_id => l_header_id,

Line 4525: l_fnd_err_msg := FND_MESSAGE.GET;

4521:
4522: FND_MESSAGE.SET_NAME('WSM', 'WSM_EXCEED_MAX_LEN');
4523: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'wip_entity_name in Resulting Jobs');
4524: FND_MESSAGE.SET_TOKEN('VALUE', '30');
4525: l_fnd_err_msg := FND_MESSAGE.GET;
4526: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): '||l_fnd_err_msg);
4527:
4528: WSMPUTIL.AUTONOMOUS_WRITE_TO_WIE (p_header_id => l_header_id,
4529: p_message => substr(l_fnd_err_msg,1,2000),

Line 4582: FND_MESSAGE.SET_NAME('WSM', 'WSM_DUPLICATE_ENT_NAME');

4578:
4579: IF (SQL%ROWCOUNT > 0) THEN
4580: set_wrji_error(); -- WLTEnh
4581:
4582: FND_MESSAGE.SET_NAME('WSM', 'WSM_DUPLICATE_ENT_NAME');
4583: l_fnd_err_msg := FND_MESSAGE.GET;
4584: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): '||l_fnd_err_msg);
4585:
4586: WSMPUTIL.AUTONOMOUS_WRITE_TO_WIE (p_header_id => l_header_id,

Line 4583: l_fnd_err_msg := FND_MESSAGE.GET;

4579: IF (SQL%ROWCOUNT > 0) THEN
4580: set_wrji_error(); -- WLTEnh
4581:
4582: FND_MESSAGE.SET_NAME('WSM', 'WSM_DUPLICATE_ENT_NAME');
4583: l_fnd_err_msg := FND_MESSAGE.GET;
4584: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): '||l_fnd_err_msg);
4585:
4586: WSMPUTIL.AUTONOMOUS_WRITE_TO_WIE (p_header_id => l_header_id,
4587: p_message => substr(l_fnd_err_msg,1,2000),

Line 4636: FND_MESSAGE.SET_NAME('WSM', 'WSM_RESULTING_DIFFERENT');

4632:
4633: IF (SQL%ROWCOUNT > 0) THEN
4634: set_wrji_error(); -- WLTEnh
4635:
4636: FND_MESSAGE.SET_NAME('WSM', 'WSM_RESULTING_DIFFERENT');
4637: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'wip_entity_name');
4638: l_fnd_err_msg := FND_MESSAGE.GET;
4639: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): '||l_fnd_err_msg);
4640:

Line 4637: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'wip_entity_name');

4633: IF (SQL%ROWCOUNT > 0) THEN
4634: set_wrji_error(); -- WLTEnh
4635:
4636: FND_MESSAGE.SET_NAME('WSM', 'WSM_RESULTING_DIFFERENT');
4637: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'wip_entity_name');
4638: l_fnd_err_msg := FND_MESSAGE.GET;
4639: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): '||l_fnd_err_msg);
4640:
4641: WSMPUTIL.AUTONOMOUS_WRITE_TO_WIE (p_header_id => l_header_id,

Line 4638: l_fnd_err_msg := FND_MESSAGE.GET;

4634: set_wrji_error(); -- WLTEnh
4635:
4636: FND_MESSAGE.SET_NAME('WSM', 'WSM_RESULTING_DIFFERENT');
4637: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'wip_entity_name');
4638: l_fnd_err_msg := FND_MESSAGE.GET;
4639: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): '||l_fnd_err_msg);
4640:
4641: WSMPUTIL.AUTONOMOUS_WRITE_TO_WIE (p_header_id => l_header_id,
4642: p_message => substr(l_fnd_err_msg,1,2000),

Line 4667: FND_MESSAGE.SET_NAME('WSM', 'WSM_RESULTING_SAME');

4663:
4664: IF (l_start_we_name = l_job_name) THEN -- Start and resulting job name are same--
4665: set_wrji_error(); -- WLTEnh
4666:
4667: FND_MESSAGE.SET_NAME('WSM', 'WSM_RESULTING_SAME');
4668: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'wip_entity_name');
4669: l_fnd_err_msg := FND_MESSAGE.GET;
4670: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): '||l_fnd_err_msg);
4671:

Line 4668: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'wip_entity_name');

4664: IF (l_start_we_name = l_job_name) THEN -- Start and resulting job name are same--
4665: set_wrji_error(); -- WLTEnh
4666:
4667: FND_MESSAGE.SET_NAME('WSM', 'WSM_RESULTING_SAME');
4668: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'wip_entity_name');
4669: l_fnd_err_msg := FND_MESSAGE.GET;
4670: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): '||l_fnd_err_msg);
4671:
4672: WSMPUTIL.AUTONOMOUS_WRITE_TO_WIE (p_header_id => l_header_id,

Line 4669: l_fnd_err_msg := FND_MESSAGE.GET;

4665: set_wrji_error(); -- WLTEnh
4666:
4667: FND_MESSAGE.SET_NAME('WSM', 'WSM_RESULTING_SAME');
4668: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'wip_entity_name');
4669: l_fnd_err_msg := FND_MESSAGE.GET;
4670: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): '||l_fnd_err_msg);
4671:
4672: WSMPUTIL.AUTONOMOUS_WRITE_TO_WIE (p_header_id => l_header_id,
4673: p_message => substr(l_fnd_err_msg,1,2000),

Line 4705: FND_MESSAGE.SET_NAME('WSM', 'WSM_INVALID_FIELD');

4701:
4702: IF (l_count > 1) THEN
4703: set_wrji_error(); -- WLTEnh
4704:
4705: FND_MESSAGE.SET_NAME('WSM', 'WSM_INVALID_FIELD');
4706: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'wip_entity_name in Resulting Jobs');
4707: l_fnd_err_msg := FND_MESSAGE.GET;
4708: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): '||l_fnd_err_msg);
4709:

Line 4706: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'wip_entity_name in Resulting Jobs');

4702: IF (l_count > 1) THEN
4703: set_wrji_error(); -- WLTEnh
4704:
4705: FND_MESSAGE.SET_NAME('WSM', 'WSM_INVALID_FIELD');
4706: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'wip_entity_name in Resulting Jobs');
4707: l_fnd_err_msg := FND_MESSAGE.GET;
4708: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): '||l_fnd_err_msg);
4709:
4710: WSMPUTIL.AUTONOMOUS_WRITE_TO_WIE (p_header_id => l_header_id,

Line 4707: l_fnd_err_msg := FND_MESSAGE.GET;

4703: set_wrji_error(); -- WLTEnh
4704:
4705: FND_MESSAGE.SET_NAME('WSM', 'WSM_INVALID_FIELD');
4706: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'wip_entity_name in Resulting Jobs');
4707: l_fnd_err_msg := FND_MESSAGE.GET;
4708: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): '||l_fnd_err_msg);
4709:
4710: WSMPUTIL.AUTONOMOUS_WRITE_TO_WIE (p_header_id => l_header_id,
4711: p_message => substr(l_fnd_err_msg,1,2000),

Line 4760: FND_MESSAGE.SET_NAME('WSM', 'WSM_INVALID_FIELD');

4756:
4757: IF (SQL%ROWCOUNT > 0) THEN
4758: set_wrji_error(); -- WLTEnh
4759:
4760: FND_MESSAGE.SET_NAME('WSM', 'WSM_INVALID_FIELD');
4761: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'primary_item_id in Resulting Jobs');
4762: l_fnd_err_msg := FND_MESSAGE.GET;
4763: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): '||l_fnd_err_msg);
4764:

Line 4761: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'primary_item_id in Resulting Jobs');

4757: IF (SQL%ROWCOUNT > 0) THEN
4758: set_wrji_error(); -- WLTEnh
4759:
4760: FND_MESSAGE.SET_NAME('WSM', 'WSM_INVALID_FIELD');
4761: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'primary_item_id in Resulting Jobs');
4762: l_fnd_err_msg := FND_MESSAGE.GET;
4763: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): '||l_fnd_err_msg);
4764:
4765: WSMPUTIL.AUTONOMOUS_WRITE_TO_WIE (p_header_id => l_header_id,

Line 4762: l_fnd_err_msg := FND_MESSAGE.GET;

4758: set_wrji_error(); -- WLTEnh
4759:
4760: FND_MESSAGE.SET_NAME('WSM', 'WSM_INVALID_FIELD');
4761: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'primary_item_id in Resulting Jobs');
4762: l_fnd_err_msg := FND_MESSAGE.GET;
4763: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): '||l_fnd_err_msg);
4764:
4765: WSMPUTIL.AUTONOMOUS_WRITE_TO_WIE (p_header_id => l_header_id,
4766: p_message => substr(l_fnd_err_msg,1,2000),

Line 4814: FND_MESSAGE.SET_NAME('WSM', 'WSM_ASSEMBLY_NO_LOT');

4810:
4811: IF (SQL%ROWCOUNT > 0) THEN
4812: set_wrji_error(); -- WLTEnh
4813:
4814: FND_MESSAGE.SET_NAME('WSM', 'WSM_ASSEMBLY_NO_LOT');
4815: l_fnd_err_msg := FND_MESSAGE.GET;
4816: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): '||l_fnd_err_msg);
4817:
4818: WSMPUTIL.AUTONOMOUS_WRITE_TO_WIE (p_header_id => l_header_id,

Line 4815: l_fnd_err_msg := FND_MESSAGE.GET;

4811: IF (SQL%ROWCOUNT > 0) THEN
4812: set_wrji_error(); -- WLTEnh
4813:
4814: FND_MESSAGE.SET_NAME('WSM', 'WSM_ASSEMBLY_NO_LOT');
4815: l_fnd_err_msg := FND_MESSAGE.GET;
4816: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): '||l_fnd_err_msg);
4817:
4818: WSMPUTIL.AUTONOMOUS_WRITE_TO_WIE (p_header_id => l_header_id,
4819: -- p_message => substr(l_fnd_err_msg,1,240),

Line 4866: FND_MESSAGE.SET_NAME('WSM', 'WSM_ASSEMBLY_NOT_SERIAL');

4862:
4863: IF (SQL%ROWCOUNT > 0) THEN
4864: set_wrji_error(); -- WLTEnh
4865:
4866: FND_MESSAGE.SET_NAME('WSM', 'WSM_ASSEMBLY_NOT_SERIAL');
4867: l_fnd_err_msg := FND_MESSAGE.GET;
4868: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): '||l_fnd_err_msg);
4869:
4870: WSMPUTIL.AUTONOMOUS_WRITE_TO_WIE (p_header_id => l_header_id,

Line 4867: l_fnd_err_msg := FND_MESSAGE.GET;

4863: IF (SQL%ROWCOUNT > 0) THEN
4864: set_wrji_error(); -- WLTEnh
4865:
4866: FND_MESSAGE.SET_NAME('WSM', 'WSM_ASSEMBLY_NOT_SERIAL');
4867: l_fnd_err_msg := FND_MESSAGE.GET;
4868: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): '||l_fnd_err_msg);
4869:
4870: WSMPUTIL.AUTONOMOUS_WRITE_TO_WIE (p_header_id => l_header_id,
4871: -- p_message => substr(l_fnd_err_msg,1,240),

Line 4910: FND_MESSAGE.SET_NAME('WSM', 'WSM_INVALID_ITEM_FOR_UPDASSY');

4906:
4907: IF (SQL%ROWCOUNT > 0) THEN
4908: set_wrji_error(); -- WLTEnh
4909:
4910: FND_MESSAGE.SET_NAME('WSM', 'WSM_INVALID_ITEM_FOR_UPDASSY');
4911: l_fnd_err_msg := FND_MESSAGE.GET;
4912: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): '||l_fnd_err_msg);
4913:
4914: WSMPUTIL.AUTONOMOUS_WRITE_TO_WIE (p_header_id => l_header_id,

Line 4911: l_fnd_err_msg := FND_MESSAGE.GET;

4907: IF (SQL%ROWCOUNT > 0) THEN
4908: set_wrji_error(); -- WLTEnh
4909:
4910: FND_MESSAGE.SET_NAME('WSM', 'WSM_INVALID_ITEM_FOR_UPDASSY');
4911: l_fnd_err_msg := FND_MESSAGE.GET;
4912: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): '||l_fnd_err_msg);
4913:
4914: WSMPUTIL.AUTONOMOUS_WRITE_TO_WIE (p_header_id => l_header_id,
4915: p_message => substr(l_fnd_err_msg,1,2000),

Line 4962: FND_MESSAGE.SET_NAME('WSM', 'WSM_INVALID_FIELD');

4958:
4959: IF (SQL%ROWCOUNT > 0) THEN
4960: set_wrji_error(); -- WLTEnh
4961:
4962: FND_MESSAGE.SET_NAME('WSM', 'WSM_INVALID_FIELD');
4963: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'bonus_acct_id in Resulting Jobs');
4964: l_fnd_err_msg := FND_MESSAGE.GET;
4965: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): '||l_fnd_err_msg);
4966:

Line 4963: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'bonus_acct_id in Resulting Jobs');

4959: IF (SQL%ROWCOUNT > 0) THEN
4960: set_wrji_error(); -- WLTEnh
4961:
4962: FND_MESSAGE.SET_NAME('WSM', 'WSM_INVALID_FIELD');
4963: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'bonus_acct_id in Resulting Jobs');
4964: l_fnd_err_msg := FND_MESSAGE.GET;
4965: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): '||l_fnd_err_msg);
4966:
4967: WSMPUTIL.AUTONOMOUS_WRITE_TO_WIE (p_header_id => l_header_id,

Line 4964: l_fnd_err_msg := FND_MESSAGE.GET;

4960: set_wrji_error(); -- WLTEnh
4961:
4962: FND_MESSAGE.SET_NAME('WSM', 'WSM_INVALID_FIELD');
4963: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'bonus_acct_id in Resulting Jobs');
4964: l_fnd_err_msg := FND_MESSAGE.GET;
4965: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): '||l_fnd_err_msg);
4966:
4967: WSMPUTIL.AUTONOMOUS_WRITE_TO_WIE (p_header_id => l_header_id,
4968: p_message => substr(l_fnd_err_msg,1,2000),

Line 5004: FND_MESSAGE.SET_NAME('WSM', 'WSM_INVALID_FIELD');

5000:
5001: IF (SQL%ROWCOUNT > 0) THEN
5002: set_wrji_error(); -- WLTEnh
5003:
5004: FND_MESSAGE.SET_NAME('WSM', 'WSM_INVALID_FIELD');
5005: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'start_quantity in Resulting Jobs');
5006: l_fnd_err_msg := FND_MESSAGE.GET;
5007: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): '||l_fnd_err_msg);
5008:

Line 5005: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'start_quantity in Resulting Jobs');

5001: IF (SQL%ROWCOUNT > 0) THEN
5002: set_wrji_error(); -- WLTEnh
5003:
5004: FND_MESSAGE.SET_NAME('WSM', 'WSM_INVALID_FIELD');
5005: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'start_quantity in Resulting Jobs');
5006: l_fnd_err_msg := FND_MESSAGE.GET;
5007: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): '||l_fnd_err_msg);
5008:
5009: WSMPUTIL.AUTONOMOUS_WRITE_TO_WIE (p_header_id => l_header_id,

Line 5006: l_fnd_err_msg := FND_MESSAGE.GET;

5002: set_wrji_error(); -- WLTEnh
5003:
5004: FND_MESSAGE.SET_NAME('WSM', 'WSM_INVALID_FIELD');
5005: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'start_quantity in Resulting Jobs');
5006: l_fnd_err_msg := FND_MESSAGE.GET;
5007: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): '||l_fnd_err_msg);
5008:
5009: WSMPUTIL.AUTONOMOUS_WRITE_TO_WIE (p_header_id => l_header_id,
5010: p_message => substr(l_fnd_err_msg,1,2000),

Line 5044: FND_MESSAGE.SET_NAME('WSM', 'WSM_MODIFIED_FIELD');

5040: AND wrji.start_quantity <> l_wdj_st_qty;
5041:
5042: IF (SQL%ROWCOUNT > 0) THEN
5043:
5044: FND_MESSAGE.SET_NAME('WSM', 'WSM_MODIFIED_FIELD');
5045: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'start_quantity in Resulting Jobs');
5046: l_fnd_err_msg := FND_MESSAGE.GET;
5047: IF (l_debug = 'Y') THEN
5048: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('

Line 5045: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'start_quantity in Resulting Jobs');

5041:
5042: IF (SQL%ROWCOUNT > 0) THEN
5043:
5044: FND_MESSAGE.SET_NAME('WSM', 'WSM_MODIFIED_FIELD');
5045: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'start_quantity in Resulting Jobs');
5046: l_fnd_err_msg := FND_MESSAGE.GET;
5047: IF (l_debug = 'Y') THEN
5048: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('
5049: ||l_stmt_num||'): '||l_fnd_err_msg);

Line 5046: l_fnd_err_msg := FND_MESSAGE.GET;

5042: IF (SQL%ROWCOUNT > 0) THEN
5043:
5044: FND_MESSAGE.SET_NAME('WSM', 'WSM_MODIFIED_FIELD');
5045: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'start_quantity in Resulting Jobs');
5046: l_fnd_err_msg := FND_MESSAGE.GET;
5047: IF (l_debug = 'Y') THEN
5048: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('
5049: ||l_stmt_num||'): '||l_fnd_err_msg);
5050: END IF;

Line 5085: FND_MESSAGE.SET_NAME('WSM', 'WSM_MODIFIED_FIELD');

5081: and wrji.internal_group_id = WSMPLOAD.G_GROUP_ID
5082: and (wrji.routing_reference_id IS NOT NULL
5083: OR wrji.bom_reference_id IS NOT NULL);
5084:
5085: FND_MESSAGE.SET_NAME('WSM', 'WSM_MODIFIED_FIELD');
5086: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'routing_reference_id/bom_reference_id in Resulting Jobs');
5087: l_fnd_err_msg := FND_MESSAGE.GET;
5088: IF (l_debug = 'Y') THEN
5089: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('

Line 5086: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'routing_reference_id/bom_reference_id in Resulting Jobs');

5082: and (wrji.routing_reference_id IS NOT NULL
5083: OR wrji.bom_reference_id IS NOT NULL);
5084:
5085: FND_MESSAGE.SET_NAME('WSM', 'WSM_MODIFIED_FIELD');
5086: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'routing_reference_id/bom_reference_id in Resulting Jobs');
5087: l_fnd_err_msg := FND_MESSAGE.GET;
5088: IF (l_debug = 'Y') THEN
5089: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('
5090: ||l_stmt_num||'): '||l_fnd_err_msg);

Line 5087: l_fnd_err_msg := FND_MESSAGE.GET;

5083: OR wrji.bom_reference_id IS NOT NULL);
5084:
5085: FND_MESSAGE.SET_NAME('WSM', 'WSM_MODIFIED_FIELD');
5086: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'routing_reference_id/bom_reference_id in Resulting Jobs');
5087: l_fnd_err_msg := FND_MESSAGE.GET;
5088: IF (l_debug = 'Y') THEN
5089: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('
5090: ||l_stmt_num||'): '||l_fnd_err_msg);
5091: END IF;

Line 5156: FND_MESSAGE.SET_NAME('WSM', 'WSM_INVALID_ROUTING_ID');

5152: --VJ: End Additions for NSLBJ--
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:

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 5158: l_fnd_err_msg := FND_MESSAGE.GET;

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,
5162: p_message => substr(l_fnd_err_msg,1,2000),

Line 5190: FND_MESSAGE.SET_NAME('WSM', 'WSM_INVALID_ALT_RTG_DESIG');

5186: --VJ: End Additions for NSLBJ--
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:

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 5192: l_fnd_err_msg := FND_MESSAGE.GET;

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,
5196: p_message => substr(l_fnd_err_msg,1,2000),

Line 5218: FND_MESSAGE.SET_NAME('WSM', 'WSM_MODIFIED_FIELD');

5214: AND wrji.rowid = l_wrji_rowid;
5215:
5216: l_wrji_rtg_seq_id := l_rtg_seq_id;
5217:
5218: FND_MESSAGE.SET_NAME('WSM', 'WSM_MODIFIED_FIELD');
5219: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'common_routing_sequence_id in Resulting Jobs');
5220: l_fnd_err_msg := FND_MESSAGE.GET;
5221: IF (l_debug = 'Y') THEN
5222: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): '||l_fnd_err_msg);

Line 5219: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'common_routing_sequence_id in Resulting Jobs');

5215:
5216: l_wrji_rtg_seq_id := l_rtg_seq_id;
5217:
5218: FND_MESSAGE.SET_NAME('WSM', 'WSM_MODIFIED_FIELD');
5219: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'common_routing_sequence_id in Resulting Jobs');
5220: l_fnd_err_msg := FND_MESSAGE.GET;
5221: IF (l_debug = 'Y') THEN
5222: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): '||l_fnd_err_msg);
5223: END IF;

Line 5220: l_fnd_err_msg := FND_MESSAGE.GET;

5216: l_wrji_rtg_seq_id := l_rtg_seq_id;
5217:
5218: FND_MESSAGE.SET_NAME('WSM', 'WSM_MODIFIED_FIELD');
5219: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'common_routing_sequence_id in Resulting Jobs');
5220: l_fnd_err_msg := FND_MESSAGE.GET;
5221: IF (l_debug = 'Y') THEN
5222: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): '||l_fnd_err_msg);
5223: END IF;
5224: WSMPUTIL.AUTONOMOUS_WRITE_TO_WIE (p_header_id => l_header_id,

Line 5249: FND_MESSAGE.SET_NAME('WSM', 'WSM_MODIFIED_FIELD');

5245: AND wrji.job_type = WIP_CONSTANTS.STANDARD --VJ: Added for NSLBJ--
5246: AND wrji.header_id=l_header_id
5247: AND wrji.rowid = l_wrji_rowid;
5248:
5249: FND_MESSAGE.SET_NAME('WSM', 'WSM_MODIFIED_FIELD');
5250: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'alternate_routing_designator in Resulting Jobs');
5251: l_fnd_err_msg := FND_MESSAGE.GET;
5252: IF (l_debug = 'Y') THEN
5253: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): '||l_fnd_err_msg);

Line 5250: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'alternate_routing_designator in Resulting Jobs');

5246: AND wrji.header_id=l_header_id
5247: AND wrji.rowid = l_wrji_rowid;
5248:
5249: FND_MESSAGE.SET_NAME('WSM', 'WSM_MODIFIED_FIELD');
5250: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'alternate_routing_designator in Resulting Jobs');
5251: l_fnd_err_msg := FND_MESSAGE.GET;
5252: IF (l_debug = 'Y') THEN
5253: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): '||l_fnd_err_msg);
5254: END IF;

Line 5251: l_fnd_err_msg := FND_MESSAGE.GET;

5247: AND wrji.rowid = l_wrji_rowid;
5248:
5249: FND_MESSAGE.SET_NAME('WSM', 'WSM_MODIFIED_FIELD');
5250: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'alternate_routing_designator in Resulting Jobs');
5251: l_fnd_err_msg := FND_MESSAGE.GET;
5252: IF (l_debug = 'Y') THEN
5253: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): '||l_fnd_err_msg);
5254: END IF;
5255: WSMPUTIL.AUTONOMOUS_WRITE_TO_WIE (p_header_id => l_header_id,

Line 5282: FND_MESSAGE.SET_NAME('WSM', 'WSM_MODIFIED_FIELD');

5278: AND wrji.job_type = WIP_CONSTANTS.STANDARD --VJ: Added for NSLBJ--
5279: AND wrji.header_id=l_header_id
5280: AND wrji.rowid = l_wrji_rowid;
5281:
5282: FND_MESSAGE.SET_NAME('WSM', 'WSM_MODIFIED_FIELD');
5283: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'alternate_routing_designator in Resulting Jobs');
5284: l_fnd_err_msg := FND_MESSAGE.GET;
5285: IF (l_debug = 'Y') THEN
5286: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): '||l_fnd_err_msg);

Line 5283: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'alternate_routing_designator in Resulting Jobs');

5279: AND wrji.header_id=l_header_id
5280: AND wrji.rowid = l_wrji_rowid;
5281:
5282: FND_MESSAGE.SET_NAME('WSM', 'WSM_MODIFIED_FIELD');
5283: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'alternate_routing_designator in Resulting Jobs');
5284: l_fnd_err_msg := FND_MESSAGE.GET;
5285: IF (l_debug = 'Y') THEN
5286: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): '||l_fnd_err_msg);
5287: END IF;

Line 5284: l_fnd_err_msg := FND_MESSAGE.GET;

5280: AND wrji.rowid = l_wrji_rowid;
5281:
5282: FND_MESSAGE.SET_NAME('WSM', 'WSM_MODIFIED_FIELD');
5283: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'alternate_routing_designator in Resulting Jobs');
5284: l_fnd_err_msg := FND_MESSAGE.GET;
5285: IF (l_debug = 'Y') THEN
5286: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): '||l_fnd_err_msg);
5287: END IF;
5288: WSMPUTIL.AUTONOMOUS_WRITE_TO_WIE (p_header_id => l_header_id,

Line 5324: FND_MESSAGE.SET_NAME('WSM', 'WSM_MODIFIED_FIELD');

5320: WHERE wrji.header_id = l_header_id
5321: AND wrji.rowid = l_wrji_rowid --SpUA add
5322: RETURNING wrji.common_routing_sequence_id INTO l_wrji_rtg_seq_id; --Added to fix bug #2358370
5323:
5324: FND_MESSAGE.SET_NAME('WSM', 'WSM_MODIFIED_FIELD');
5325: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'common_routing_sequence_id in Resulting Jobs');
5326: l_fnd_err_msg := FND_MESSAGE.GET;
5327: IF (l_debug = 'Y') THEN
5328: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): '||l_fnd_err_msg);

Line 5325: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'common_routing_sequence_id in Resulting Jobs');

5321: AND wrji.rowid = l_wrji_rowid --SpUA add
5322: RETURNING wrji.common_routing_sequence_id INTO l_wrji_rtg_seq_id; --Added to fix bug #2358370
5323:
5324: FND_MESSAGE.SET_NAME('WSM', 'WSM_MODIFIED_FIELD');
5325: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'common_routing_sequence_id in Resulting Jobs');
5326: l_fnd_err_msg := FND_MESSAGE.GET;
5327: IF (l_debug = 'Y') THEN
5328: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): '||l_fnd_err_msg);
5329: END IF;

Line 5326: l_fnd_err_msg := FND_MESSAGE.GET;

5322: RETURNING wrji.common_routing_sequence_id INTO l_wrji_rtg_seq_id; --Added to fix bug #2358370
5323:
5324: FND_MESSAGE.SET_NAME('WSM', 'WSM_MODIFIED_FIELD');
5325: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'common_routing_sequence_id in Resulting Jobs');
5326: l_fnd_err_msg := FND_MESSAGE.GET;
5327: IF (l_debug = 'Y') THEN
5328: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): '||l_fnd_err_msg);
5329: END IF;
5330: WSMPUTIL.AUTONOMOUS_WRITE_TO_WIE (p_header_id => l_header_id,

Line 5361: FND_MESSAGE.SET_NAME('WSM', 'WSM_INVALID_FIELD');

5357:
5358: IF (SQL%ROWCOUNT > 0) THEN
5359: set_wrji_error(); -- WLTEnh
5360:
5361: FND_MESSAGE.SET_NAME('WSM', 'WSM_INVALID_FIELD');
5362: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'common_routing_sequence_id in Resulting Jobs');
5363: l_fnd_err_msg := FND_MESSAGE.GET;
5364: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): '||l_fnd_err_msg);
5365:

Line 5362: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'common_routing_sequence_id in Resulting Jobs');

5358: IF (SQL%ROWCOUNT > 0) THEN
5359: set_wrji_error(); -- WLTEnh
5360:
5361: FND_MESSAGE.SET_NAME('WSM', 'WSM_INVALID_FIELD');
5362: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'common_routing_sequence_id in Resulting Jobs');
5363: l_fnd_err_msg := FND_MESSAGE.GET;
5364: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): '||l_fnd_err_msg);
5365:
5366: WSMPUTIL.AUTONOMOUS_WRITE_TO_WIE (p_header_id => l_header_id,

Line 5363: l_fnd_err_msg := FND_MESSAGE.GET;

5359: set_wrji_error(); -- WLTEnh
5360:
5361: FND_MESSAGE.SET_NAME('WSM', 'WSM_INVALID_FIELD');
5362: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'common_routing_sequence_id in Resulting Jobs');
5363: l_fnd_err_msg := FND_MESSAGE.GET;
5364: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): '||l_fnd_err_msg);
5365:
5366: WSMPUTIL.AUTONOMOUS_WRITE_TO_WIE (p_header_id => l_header_id,
5367: p_message => substr(l_fnd_err_msg,1,2000),

Line 5409: FND_MESSAGE.SET_NAME('WSM', 'WSM_MODIFIED_FIELD');

5405: WHERE wrji.header_id = l_header_id
5406: AND wrji.rowid = l_wrji_rowid --SpUA add
5407: AND wrji.job_type = WIP_CONSTANTS.STANDARD; --VJ: Added for NSLBJ--
5408:
5409: FND_MESSAGE.SET_NAME('WSM', 'WSM_MODIFIED_FIELD');
5410: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'alternate_routing_designator in Resulting Jobs');
5411: l_fnd_err_msg := FND_MESSAGE.GET;
5412: IF (l_debug = 'Y') THEN
5413: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): '||l_fnd_err_msg);

Line 5410: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'alternate_routing_designator in Resulting Jobs');

5406: AND wrji.rowid = l_wrji_rowid --SpUA add
5407: AND wrji.job_type = WIP_CONSTANTS.STANDARD; --VJ: Added for NSLBJ--
5408:
5409: FND_MESSAGE.SET_NAME('WSM', 'WSM_MODIFIED_FIELD');
5410: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'alternate_routing_designator in Resulting Jobs');
5411: l_fnd_err_msg := FND_MESSAGE.GET;
5412: IF (l_debug = 'Y') THEN
5413: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): '||l_fnd_err_msg);
5414: END IF;

Line 5411: l_fnd_err_msg := FND_MESSAGE.GET;

5407: AND wrji.job_type = WIP_CONSTANTS.STANDARD; --VJ: Added for NSLBJ--
5408:
5409: FND_MESSAGE.SET_NAME('WSM', 'WSM_MODIFIED_FIELD');
5410: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'alternate_routing_designator in Resulting Jobs');
5411: l_fnd_err_msg := FND_MESSAGE.GET;
5412: IF (l_debug = 'Y') THEN
5413: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): '||l_fnd_err_msg);
5414: END IF;
5415: WSMPUTIL.AUTONOMOUS_WRITE_TO_WIE (p_header_id => l_header_id,

Line 5431: FND_MESSAGE.SET_NAME('WSM', 'WSM_INVALID_ROUTING_ID');

5427: else
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:

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 5433: l_fnd_err_msg := FND_MESSAGE.GET;

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,
5437: p_message => substr(l_fnd_err_msg,1,2000),

Line 5479: FND_MESSAGE.SET_NAME('WSM', 'WSM_MODIFIED_FIELD');

5475: WHERE wrji.header_id = l_header_id
5476: AND wrji.rowid = l_wrji_rowid --SpUA add
5477: AND wrji.job_type = WIP_CONSTANTS.STANDARD; --VJ: Added for NSLBJ--
5478:
5479: FND_MESSAGE.SET_NAME('WSM', 'WSM_MODIFIED_FIELD');
5480: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'common_routing_sequence_id in Resulting Jobs');
5481: l_fnd_err_msg := FND_MESSAGE.GET;
5482: IF (l_debug = 'Y') THEN
5483: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): '||l_fnd_err_msg);

Line 5480: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'common_routing_sequence_id in Resulting Jobs');

5476: AND wrji.rowid = l_wrji_rowid --SpUA add
5477: AND wrji.job_type = WIP_CONSTANTS.STANDARD; --VJ: Added for NSLBJ--
5478:
5479: FND_MESSAGE.SET_NAME('WSM', 'WSM_MODIFIED_FIELD');
5480: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'common_routing_sequence_id in Resulting Jobs');
5481: l_fnd_err_msg := FND_MESSAGE.GET;
5482: IF (l_debug = 'Y') THEN
5483: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): '||l_fnd_err_msg);
5484: END IF;

Line 5481: l_fnd_err_msg := FND_MESSAGE.GET;

5477: AND wrji.job_type = WIP_CONSTANTS.STANDARD; --VJ: Added for NSLBJ--
5478:
5479: FND_MESSAGE.SET_NAME('WSM', 'WSM_MODIFIED_FIELD');
5480: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'common_routing_sequence_id in Resulting Jobs');
5481: l_fnd_err_msg := FND_MESSAGE.GET;
5482: IF (l_debug = 'Y') THEN
5483: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): '||l_fnd_err_msg);
5484: END IF;
5485: WSMPUTIL.AUTONOMOUS_WRITE_TO_WIE (p_header_id => l_header_id,

Line 5501: FND_MESSAGE.SET_NAME('WSM', 'WSM_INVALID_FIELD');

5497: else
5498:
5499: set_wrji_error(); -- WLTEnh
5500:
5501: FND_MESSAGE.SET_NAME('WSM', 'WSM_INVALID_FIELD');
5502: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'common_routing_sequence_id in Resulting Jobs');
5503: l_fnd_err_msg := FND_MESSAGE.GET;
5504: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): '||l_fnd_err_msg);
5505:

Line 5502: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'common_routing_sequence_id in Resulting Jobs');

5498:
5499: set_wrji_error(); -- WLTEnh
5500:
5501: FND_MESSAGE.SET_NAME('WSM', 'WSM_INVALID_FIELD');
5502: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'common_routing_sequence_id in Resulting Jobs');
5503: l_fnd_err_msg := FND_MESSAGE.GET;
5504: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): '||l_fnd_err_msg);
5505:
5506: WSMPUTIL.AUTONOMOUS_WRITE_TO_WIE (p_header_id => l_header_id,

Line 5503: l_fnd_err_msg := FND_MESSAGE.GET;

5499: set_wrji_error(); -- WLTEnh
5500:
5501: FND_MESSAGE.SET_NAME('WSM', 'WSM_INVALID_FIELD');
5502: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'common_routing_sequence_id in Resulting Jobs');
5503: l_fnd_err_msg := FND_MESSAGE.GET;
5504: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): '||l_fnd_err_msg);
5505:
5506: WSMPUTIL.AUTONOMOUS_WRITE_TO_WIE (p_header_id => l_header_id,
5507: p_message => substr(l_fnd_err_msg,1,2000),

Line 5577: FND_MESSAGE.SET_NAME('WSM', 'WSM_RESULTING_SAME');

5573: (l_alt_rtg_desig = l_wrji_alt_rtg_desig)
5574: AND (l_wdj_rtg_rev = l_rtg_rev) --Added for APS-WLT
5575: AND (l_wdj_rtg_rev_dt = l_rtg_rev_date) --Added for APS-WLT
5576: THEN
5577: FND_MESSAGE.SET_NAME('WSM', 'WSM_RESULTING_SAME');
5578: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'Routing');
5579: l_fnd_err_msg := FND_MESSAGE.GET;
5580: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): '||l_fnd_err_msg);
5581:

Line 5578: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'Routing');

5574: AND (l_wdj_rtg_rev = l_rtg_rev) --Added for APS-WLT
5575: AND (l_wdj_rtg_rev_dt = l_rtg_rev_date) --Added for APS-WLT
5576: THEN
5577: FND_MESSAGE.SET_NAME('WSM', 'WSM_RESULTING_SAME');
5578: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'Routing');
5579: l_fnd_err_msg := FND_MESSAGE.GET;
5580: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): '||l_fnd_err_msg);
5581:
5582: set_wrji_error(); -- WLTEnh

Line 5579: l_fnd_err_msg := FND_MESSAGE.GET;

5575: AND (l_wdj_rtg_rev_dt = l_rtg_rev_date) --Added for APS-WLT
5576: THEN
5577: FND_MESSAGE.SET_NAME('WSM', 'WSM_RESULTING_SAME');
5578: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'Routing');
5579: l_fnd_err_msg := FND_MESSAGE.GET;
5580: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): '||l_fnd_err_msg);
5581:
5582: set_wrji_error(); -- WLTEnh
5583:

Line 5650: fnd_message.set_name('WSM', 'WSM_MODIFIED_FIELD');

5646: AND l_split_has_update_assy = 1)));
5647: --SpUA end
5648:
5649: IF (SQL%ROWCOUNT > 0) and l_debug = 'Y' THEN
5650: fnd_message.set_name('WSM', 'WSM_MODIFIED_FIELD');
5651: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'Completion Subinventory and Locator from Routing');
5652: l_fnd_err_msg := FND_MESSAGE.GET;
5653: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.POPULATE_COLUMN('||l_stmt_num||'): '||l_fnd_err_msg);
5654: END IF;

Line 5651: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'Completion Subinventory and Locator from Routing');

5647: --SpUA end
5648:
5649: IF (SQL%ROWCOUNT > 0) and l_debug = 'Y' THEN
5650: fnd_message.set_name('WSM', 'WSM_MODIFIED_FIELD');
5651: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'Completion Subinventory and Locator from Routing');
5652: l_fnd_err_msg := FND_MESSAGE.GET;
5653: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.POPULATE_COLUMN('||l_stmt_num||'): '||l_fnd_err_msg);
5654: END IF;
5655: --EA: CZH.BUG2398718

Line 5652: l_fnd_err_msg := FND_MESSAGE.GET;

5648:
5649: IF (SQL%ROWCOUNT > 0) and l_debug = 'Y' THEN
5650: fnd_message.set_name('WSM', 'WSM_MODIFIED_FIELD');
5651: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'Completion Subinventory and Locator from Routing');
5652: l_fnd_err_msg := FND_MESSAGE.GET;
5653: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.POPULATE_COLUMN('||l_stmt_num||'): '||l_fnd_err_msg);
5654: END IF;
5655: --EA: CZH.BUG2398718
5656:

Line 5740: FND_MESSAGE.SET_NAME('WSM', 'WSM_MODIFIED_FIELD');

5736: where wrji.header_id = l_header_id
5737: and wrji.rowid = l_wrji_rowid;
5738:
5739: IF (SQL%ROWCOUNT > 0) THEN
5740: FND_MESSAGE.SET_NAME('WSM', 'WSM_MODIFIED_FIELD');
5741: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'routing revision date/routing revision in Resulting Jobs');
5742: l_fnd_err_msg := FND_MESSAGE.GET;
5743: If l_debug = 'Y' Then
5744: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('

Line 5741: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'routing revision date/routing revision in Resulting Jobs');

5737: and wrji.rowid = l_wrji_rowid;
5738:
5739: IF (SQL%ROWCOUNT > 0) THEN
5740: FND_MESSAGE.SET_NAME('WSM', 'WSM_MODIFIED_FIELD');
5741: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'routing revision date/routing revision in Resulting Jobs');
5742: l_fnd_err_msg := FND_MESSAGE.GET;
5743: If l_debug = 'Y' Then
5744: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('
5745: ||l_stmt_num||'): '||l_fnd_err_msg);

Line 5742: l_fnd_err_msg := FND_MESSAGE.GET;

5738:
5739: IF (SQL%ROWCOUNT > 0) THEN
5740: FND_MESSAGE.SET_NAME('WSM', 'WSM_MODIFIED_FIELD');
5741: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'routing revision date/routing revision in Resulting Jobs');
5742: l_fnd_err_msg := FND_MESSAGE.GET;
5743: If l_debug = 'Y' Then
5744: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('
5745: ||l_stmt_num||'): '||l_fnd_err_msg);
5746: End If;

Line 5875: FND_MESSAGE.SET_NAME('WSM', 'WSM_PRIMARY_PATH_DISABLED');

5871: l_wrji_starting_op_seq_num,
5872: x_error_code,
5873: x_error_msg) = 0)
5874: THEN
5875: FND_MESSAGE.SET_NAME('WSM', 'WSM_PRIMARY_PATH_DISABLED');
5876: l_fnd_err_msg := FND_MESSAGE.GET;
5877: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('
5878: ||l_stmt_num||'): '||l_fnd_err_msg);
5879:

Line 5876: l_fnd_err_msg := FND_MESSAGE.GET;

5872: x_error_code,
5873: x_error_msg) = 0)
5874: THEN
5875: FND_MESSAGE.SET_NAME('WSM', 'WSM_PRIMARY_PATH_DISABLED');
5876: l_fnd_err_msg := FND_MESSAGE.GET;
5877: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('
5878: ||l_stmt_num||'): '||l_fnd_err_msg);
5879:
5880: set_wrji_error(); -- WLTEnh

Line 6061: FND_MESSAGE.SET_NAME('WSM', 'WSM_NULL_FIELD');

6057: AND wrji.starting_operation_seq_num IS NULL
6058: AND wrji.starting_operation_code IS NULL;
6059:
6060: IF (SQL%ROWCOUNT = 1) THEN
6061: FND_MESSAGE.SET_NAME('WSM', 'WSM_NULL_FIELD');
6062: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'starting_operation_seq_num/starting_operation_code in Resulting Jobs');
6063: l_fnd_err_msg := FND_MESSAGE.GET;
6064: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): '||l_fnd_err_msg);
6065:

Line 6062: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'starting_operation_seq_num/starting_operation_code in Resulting Jobs');

6058: AND wrji.starting_operation_code IS NULL;
6059:
6060: IF (SQL%ROWCOUNT = 1) THEN
6061: FND_MESSAGE.SET_NAME('WSM', 'WSM_NULL_FIELD');
6062: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'starting_operation_seq_num/starting_operation_code in Resulting Jobs');
6063: l_fnd_err_msg := FND_MESSAGE.GET;
6064: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): '||l_fnd_err_msg);
6065:
6066: set_wrji_error();

Line 6063: l_fnd_err_msg := FND_MESSAGE.GET;

6059:
6060: IF (SQL%ROWCOUNT = 1) THEN
6061: FND_MESSAGE.SET_NAME('WSM', 'WSM_NULL_FIELD');
6062: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'starting_operation_seq_num/starting_operation_code in Resulting Jobs');
6063: l_fnd_err_msg := FND_MESSAGE.GET;
6064: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): '||l_fnd_err_msg);
6065:
6066: set_wrji_error();
6067:

Line 6114: FND_MESSAGE.SET_NAME('WSM', 'WSM_MODIFIED_FIELD');

6110: );
6111:
6112: If (SQL%ROWCOUNT) > 0 then -- Bugfix 2563075 Added IF Clause
6113:
6114: FND_MESSAGE.SET_NAME('WSM', 'WSM_MODIFIED_FIELD');
6115: FND_MESSAGE.SET_TOKEN('FLD_NAME',
6116: ( ' starting operation seqnum/code in Resulting Jobs,'||
6117: ' as current operation is uniquely identified in target routing')
6118: );

Line 6115: FND_MESSAGE.SET_TOKEN('FLD_NAME',

6111:
6112: If (SQL%ROWCOUNT) > 0 then -- Bugfix 2563075 Added IF Clause
6113:
6114: FND_MESSAGE.SET_NAME('WSM', 'WSM_MODIFIED_FIELD');
6115: FND_MESSAGE.SET_TOKEN('FLD_NAME',
6116: ( ' starting operation seqnum/code in Resulting Jobs,'||
6117: ' as current operation is uniquely identified in target routing')
6118: );
6119: l_fnd_err_msg := FND_MESSAGE.GET;

Line 6119: l_fnd_err_msg := FND_MESSAGE.GET;

6115: FND_MESSAGE.SET_TOKEN('FLD_NAME',
6116: ( ' starting operation seqnum/code in Resulting Jobs,'||
6117: ' as current operation is uniquely identified in target routing')
6118: );
6119: l_fnd_err_msg := FND_MESSAGE.GET;
6120:
6121: IF (l_debug = 'Y') THEN
6122: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('
6123: ||l_stmt_num||'): '||l_fnd_err_msg);

Line 6177: FND_MESSAGE.SET_NAME('WSM', 'WSM_MODIFIED_FIELD');

6173: --SpUA end
6174: and sj.intraoperation_step = WIP_CONSTANTS.TOMOVE
6175: );
6176:
6177: FND_MESSAGE.SET_NAME('WSM', 'WSM_MODIFIED_FIELD');
6178: FND_MESSAGE.SET_TOKEN('FLD_NAME',
6179: ( ' starting operation seqnum/code in Resulting Jobs to NULL,'||
6180: ' ; Job is at TO_MOVE intraoperation step.')
6181: );

Line 6178: FND_MESSAGE.SET_TOKEN('FLD_NAME',

6174: and sj.intraoperation_step = WIP_CONSTANTS.TOMOVE
6175: );
6176:
6177: FND_MESSAGE.SET_NAME('WSM', 'WSM_MODIFIED_FIELD');
6178: FND_MESSAGE.SET_TOKEN('FLD_NAME',
6179: ( ' starting operation seqnum/code in Resulting Jobs to NULL,'||
6180: ' ; Job is at TO_MOVE intraoperation step.')
6181: );
6182: l_fnd_err_msg := FND_MESSAGE.GET;

Line 6182: l_fnd_err_msg := FND_MESSAGE.GET;

6178: FND_MESSAGE.SET_TOKEN('FLD_NAME',
6179: ( ' starting operation seqnum/code in Resulting Jobs to NULL,'||
6180: ' ; Job is at TO_MOVE intraoperation step.')
6181: );
6182: l_fnd_err_msg := FND_MESSAGE.GET;
6183: IF (l_debug = 'Y') THEN
6184: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('
6185: ||l_stmt_num||'): '||l_fnd_err_msg);
6186: END IF;

Line 6253: FND_MESSAGE.SET_NAME('WSM', 'WSM_INVALID_FIELD');

6249: AND wrji.job_type = WIP_CONSTANTS.STANDARD
6250: AND wrji.rowid = l_wrji_rowid;
6251: --VJ: End Additions for NSLBJ--
6252:
6253: FND_MESSAGE.SET_NAME('WSM', 'WSM_INVALID_FIELD');
6254: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'common_bom_sequence_id in Resulting Jobs');
6255: l_fnd_err_msg := FND_MESSAGE.GET;
6256: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): '||l_fnd_err_msg);
6257:

Line 6254: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'common_bom_sequence_id in Resulting Jobs');

6250: AND wrji.rowid = l_wrji_rowid;
6251: --VJ: End Additions for NSLBJ--
6252:
6253: FND_MESSAGE.SET_NAME('WSM', 'WSM_INVALID_FIELD');
6254: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'common_bom_sequence_id in Resulting Jobs');
6255: l_fnd_err_msg := FND_MESSAGE.GET;
6256: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): '||l_fnd_err_msg);
6257:
6258: set_wrji_error(); -- WLTEnh

Line 6255: l_fnd_err_msg := FND_MESSAGE.GET;

6251: --VJ: End Additions for NSLBJ--
6252:
6253: FND_MESSAGE.SET_NAME('WSM', 'WSM_INVALID_FIELD');
6254: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'common_bom_sequence_id in Resulting Jobs');
6255: l_fnd_err_msg := FND_MESSAGE.GET;
6256: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): '||l_fnd_err_msg);
6257:
6258: set_wrji_error(); -- WLTEnh
6259:

Line 6288: FND_MESSAGE.SET_NAME('WSM', 'WSM_INVALID_FIELD');

6284: AND wrji.job_type = WIP_CONSTANTS.STANDARD
6285: AND wrji.rowid = l_wrji_rowid;
6286: --VJ: End Additions for NSLBJ--
6287:
6288: FND_MESSAGE.SET_NAME('WSM', 'WSM_INVALID_FIELD');
6289: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'alternate_bom_designator in Resulting Jobs');
6290: l_fnd_err_msg := FND_MESSAGE.GET;
6291: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): '||l_fnd_err_msg);
6292:

Line 6289: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'alternate_bom_designator in Resulting Jobs');

6285: AND wrji.rowid = l_wrji_rowid;
6286: --VJ: End Additions for NSLBJ--
6287:
6288: FND_MESSAGE.SET_NAME('WSM', 'WSM_INVALID_FIELD');
6289: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'alternate_bom_designator in Resulting Jobs');
6290: l_fnd_err_msg := FND_MESSAGE.GET;
6291: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): '||l_fnd_err_msg);
6292:
6293: set_wrji_error(); -- WLTEnh

Line 6290: l_fnd_err_msg := FND_MESSAGE.GET;

6286: --VJ: End Additions for NSLBJ--
6287:
6288: FND_MESSAGE.SET_NAME('WSM', 'WSM_INVALID_FIELD');
6289: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'alternate_bom_designator in Resulting Jobs');
6290: l_fnd_err_msg := FND_MESSAGE.GET;
6291: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): '||l_fnd_err_msg);
6292:
6293: set_wrji_error(); -- WLTEnh
6294:

Line 6317: FND_MESSAGE.SET_NAME('WSM', 'WSM_MODIFIED_FIELD');

6313: AND wrji.header_id=l_header_id
6314: AND wrji.job_type = WIP_CONSTANTS.STANDARD --VJ: Added for NSLBJ--
6315: AND wrji.rowid = l_wrji_rowid;
6316:
6317: FND_MESSAGE.SET_NAME('WSM', 'WSM_MODIFIED_FIELD');
6318: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'common_bom_sequence_id in Resulting Jobs');
6319: l_fnd_err_msg := FND_MESSAGE.GET;
6320: IF (l_debug = 'Y') THEN
6321: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): '||l_fnd_err_msg);

Line 6318: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'common_bom_sequence_id in Resulting Jobs');

6314: AND wrji.job_type = WIP_CONSTANTS.STANDARD --VJ: Added for NSLBJ--
6315: AND wrji.rowid = l_wrji_rowid;
6316:
6317: FND_MESSAGE.SET_NAME('WSM', 'WSM_MODIFIED_FIELD');
6318: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'common_bom_sequence_id in Resulting Jobs');
6319: l_fnd_err_msg := FND_MESSAGE.GET;
6320: IF (l_debug = 'Y') THEN
6321: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): '||l_fnd_err_msg);
6322: END IF;

Line 6319: l_fnd_err_msg := FND_MESSAGE.GET;

6315: AND wrji.rowid = l_wrji_rowid;
6316:
6317: FND_MESSAGE.SET_NAME('WSM', 'WSM_MODIFIED_FIELD');
6318: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'common_bom_sequence_id in Resulting Jobs');
6319: l_fnd_err_msg := FND_MESSAGE.GET;
6320: IF (l_debug = 'Y') THEN
6321: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): '||l_fnd_err_msg);
6322: END IF;
6323: WSMPUTIL.AUTONOMOUS_WRITE_TO_WIE (p_header_id => l_header_id,

Line 6348: FND_MESSAGE.SET_NAME('WSM', 'WSM_MODIFIED_FIELD');

6344: AND wrji.header_id=l_header_id
6345: AND wrji.job_type = WIP_CONSTANTS.STANDARD --VJ: Added for NSLBJ--
6346: AND wrji.rowid = l_wrji_rowid;
6347:
6348: FND_MESSAGE.SET_NAME('WSM', 'WSM_MODIFIED_FIELD');
6349: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'alternate_bom_designator in Resulting Jobs');
6350: l_fnd_err_msg := FND_MESSAGE.GET;
6351: IF (l_debug = 'Y') THEN
6352: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): '||l_fnd_err_msg);

Line 6349: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'alternate_bom_designator in Resulting Jobs');

6345: AND wrji.job_type = WIP_CONSTANTS.STANDARD --VJ: Added for NSLBJ--
6346: AND wrji.rowid = l_wrji_rowid;
6347:
6348: FND_MESSAGE.SET_NAME('WSM', 'WSM_MODIFIED_FIELD');
6349: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'alternate_bom_designator in Resulting Jobs');
6350: l_fnd_err_msg := FND_MESSAGE.GET;
6351: IF (l_debug = 'Y') THEN
6352: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): '||l_fnd_err_msg);
6353: END IF;

Line 6350: l_fnd_err_msg := FND_MESSAGE.GET;

6346: AND wrji.rowid = l_wrji_rowid;
6347:
6348: FND_MESSAGE.SET_NAME('WSM', 'WSM_MODIFIED_FIELD');
6349: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'alternate_bom_designator in Resulting Jobs');
6350: l_fnd_err_msg := FND_MESSAGE.GET;
6351: IF (l_debug = 'Y') THEN
6352: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): '||l_fnd_err_msg);
6353: END IF;
6354: WSMPUTIL.AUTONOMOUS_WRITE_TO_WIE (p_header_id => l_header_id,

Line 6381: FND_MESSAGE.SET_NAME('WSM', 'WSM_MODIFIED_FIELD');

6377: AND wrji.header_id=l_header_id
6378: AND wrji.job_type = WIP_CONSTANTS.STANDARD --VJ: Added for NSLBJ--
6379: AND wrji.rowid = l_wrji_rowid;
6380:
6381: FND_MESSAGE.SET_NAME('WSM', 'WSM_MODIFIED_FIELD');
6382: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'alternate_bom_designator in Resulting Jobs');
6383: l_fnd_err_msg := FND_MESSAGE.GET;
6384: IF (l_debug = 'Y') THEN
6385: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): '||l_fnd_err_msg);

Line 6382: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'alternate_bom_designator in Resulting Jobs');

6378: AND wrji.job_type = WIP_CONSTANTS.STANDARD --VJ: Added for NSLBJ--
6379: AND wrji.rowid = l_wrji_rowid;
6380:
6381: FND_MESSAGE.SET_NAME('WSM', 'WSM_MODIFIED_FIELD');
6382: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'alternate_bom_designator in Resulting Jobs');
6383: l_fnd_err_msg := FND_MESSAGE.GET;
6384: IF (l_debug = 'Y') THEN
6385: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): '||l_fnd_err_msg);
6386: END IF;

Line 6383: l_fnd_err_msg := FND_MESSAGE.GET;

6379: AND wrji.rowid = l_wrji_rowid;
6380:
6381: FND_MESSAGE.SET_NAME('WSM', 'WSM_MODIFIED_FIELD');
6382: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'alternate_bom_designator in Resulting Jobs');
6383: l_fnd_err_msg := FND_MESSAGE.GET;
6384: IF (l_debug = 'Y') THEN
6385: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): '||l_fnd_err_msg);
6386: END IF;
6387: WSMPUTIL.AUTONOMOUS_WRITE_TO_WIE (p_header_id => l_header_id,

Line 6438: FND_MESSAGE.SET_NAME('WSM', 'WSM_MODIFIED_FIELD');

6434: WHERE wrji.header_id = l_header_id
6435: AND wrji.rowid = l_wrji_rowid --SpUA add
6436: AND wrji.job_type = WIP_CONSTANTS.STANDARD; --VJ: Added for NSLBJ--
6437:
6438: FND_MESSAGE.SET_NAME('WSM', 'WSM_MODIFIED_FIELD');
6439: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'common_bom_sequence_id in Resulting Jobs');
6440: l_fnd_err_msg := FND_MESSAGE.GET;
6441: IF (l_debug = 'Y') THEN
6442: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): '||l_fnd_err_msg);

Line 6439: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'common_bom_sequence_id in Resulting Jobs');

6435: AND wrji.rowid = l_wrji_rowid --SpUA add
6436: AND wrji.job_type = WIP_CONSTANTS.STANDARD; --VJ: Added for NSLBJ--
6437:
6438: FND_MESSAGE.SET_NAME('WSM', 'WSM_MODIFIED_FIELD');
6439: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'common_bom_sequence_id in Resulting Jobs');
6440: l_fnd_err_msg := FND_MESSAGE.GET;
6441: IF (l_debug = 'Y') THEN
6442: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): '||l_fnd_err_msg);
6443: END IF;

Line 6440: l_fnd_err_msg := FND_MESSAGE.GET;

6436: AND wrji.job_type = WIP_CONSTANTS.STANDARD; --VJ: Added for NSLBJ--
6437:
6438: FND_MESSAGE.SET_NAME('WSM', 'WSM_MODIFIED_FIELD');
6439: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'common_bom_sequence_id in Resulting Jobs');
6440: l_fnd_err_msg := FND_MESSAGE.GET;
6441: IF (l_debug = 'Y') THEN
6442: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): '||l_fnd_err_msg);
6443: END IF;
6444: WSMPUTIL.AUTONOMOUS_WRITE_TO_WIE (p_header_id => l_header_id,

Line 6485: FND_MESSAGE.SET_NAME('WSM', 'WSM_INVALID_FIELD');

6481: or (bom.assembly_type = 2)));
6482:
6483:
6484: IF (SQL%ROWCOUNT > 0) THEN
6485: FND_MESSAGE.SET_NAME('WSM', 'WSM_INVALID_FIELD');
6486: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'common_bom_sequence_id in Resulting Jobs');
6487: l_fnd_err_msg := FND_MESSAGE.GET;
6488: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): '||l_fnd_err_msg);
6489:

Line 6486: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'common_bom_sequence_id in Resulting Jobs');

6482:
6483:
6484: IF (SQL%ROWCOUNT > 0) THEN
6485: FND_MESSAGE.SET_NAME('WSM', 'WSM_INVALID_FIELD');
6486: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'common_bom_sequence_id in Resulting Jobs');
6487: l_fnd_err_msg := FND_MESSAGE.GET;
6488: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): '||l_fnd_err_msg);
6489:
6490: set_wrji_error(); -- WLTEnh

Line 6487: l_fnd_err_msg := FND_MESSAGE.GET;

6483:
6484: IF (SQL%ROWCOUNT > 0) THEN
6485: FND_MESSAGE.SET_NAME('WSM', 'WSM_INVALID_FIELD');
6486: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'common_bom_sequence_id in Resulting Jobs');
6487: l_fnd_err_msg := FND_MESSAGE.GET;
6488: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): '||l_fnd_err_msg);
6489:
6490: set_wrji_error(); -- WLTEnh
6491:

Line 6545: FND_MESSAGE.SET_NAME('WSM', 'WSM_MODIFIED_FIELD');

6541: WHERE wrji.header_id = l_header_id
6542: AND wrji.rowid = l_wrji_rowid --SpUA add
6543: AND wrji.job_type = WIP_CONSTANTS.STANDARD; --VJ: Added for NSLBJ--
6544:
6545: FND_MESSAGE.SET_NAME('WSM', 'WSM_MODIFIED_FIELD');
6546: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'alternate_bom_designator in Resulting Jobs');
6547: l_fnd_err_msg := FND_MESSAGE.GET;
6548: IF (l_debug = 'Y') THEN
6549: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): '||l_fnd_err_msg);

Line 6546: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'alternate_bom_designator in Resulting Jobs');

6542: AND wrji.rowid = l_wrji_rowid --SpUA add
6543: AND wrji.job_type = WIP_CONSTANTS.STANDARD; --VJ: Added for NSLBJ--
6544:
6545: FND_MESSAGE.SET_NAME('WSM', 'WSM_MODIFIED_FIELD');
6546: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'alternate_bom_designator in Resulting Jobs');
6547: l_fnd_err_msg := FND_MESSAGE.GET;
6548: IF (l_debug = 'Y') THEN
6549: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): '||l_fnd_err_msg);
6550: END IF;

Line 6547: l_fnd_err_msg := FND_MESSAGE.GET;

6543: AND wrji.job_type = WIP_CONSTANTS.STANDARD; --VJ: Added for NSLBJ--
6544:
6545: FND_MESSAGE.SET_NAME('WSM', 'WSM_MODIFIED_FIELD');
6546: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'alternate_bom_designator in Resulting Jobs');
6547: l_fnd_err_msg := FND_MESSAGE.GET;
6548: IF (l_debug = 'Y') THEN
6549: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): '||l_fnd_err_msg);
6550: END IF;
6551: WSMPUTIL.AUTONOMOUS_WRITE_TO_WIE (p_header_id => l_header_id,

Line 6564: FND_MESSAGE.SET_NAME('WSM', 'WSM_INVALID_FIELD');

6560: raise proc_error;
6561: END IF;
6562:
6563: else
6564: FND_MESSAGE.SET_NAME('WSM', 'WSM_INVALID_FIELD');
6565: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'common_bom_sequence_id in Resulting Jobs');
6566: l_fnd_err_msg := FND_MESSAGE.GET;
6567: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): '||l_fnd_err_msg);
6568:

Line 6565: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'common_bom_sequence_id in Resulting Jobs');

6561: END IF;
6562:
6563: else
6564: FND_MESSAGE.SET_NAME('WSM', 'WSM_INVALID_FIELD');
6565: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'common_bom_sequence_id in Resulting Jobs');
6566: l_fnd_err_msg := FND_MESSAGE.GET;
6567: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): '||l_fnd_err_msg);
6568:
6569: set_wrji_error(); -- WLTEnh

Line 6566: l_fnd_err_msg := FND_MESSAGE.GET;

6562:
6563: else
6564: FND_MESSAGE.SET_NAME('WSM', 'WSM_INVALID_FIELD');
6565: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'common_bom_sequence_id in Resulting Jobs');
6566: l_fnd_err_msg := FND_MESSAGE.GET;
6567: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): '||l_fnd_err_msg);
6568:
6569: set_wrji_error(); -- WLTEnh
6570:

Line 6624: FND_MESSAGE.SET_NAME('WSM', 'WSM_MODIFIED_FIELD');

6620: WHERE wrji.header_id = l_header_id
6621: AND wrji.rowid = l_wrji_rowid
6622: AND wrji.job_type = WIP_CONSTANTS.STANDARD; --VJ: Added for NSLBJ--
6623:
6624: FND_MESSAGE.SET_NAME('WSM', 'WSM_MODIFIED_FIELD');
6625: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'common_bom_sequence_id in Resulting Jobs');
6626: l_fnd_err_msg := FND_MESSAGE.GET;
6627: IF (l_debug = 'Y') THEN
6628: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): '||l_fnd_err_msg);

Line 6625: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'common_bom_sequence_id in Resulting Jobs');

6621: AND wrji.rowid = l_wrji_rowid
6622: AND wrji.job_type = WIP_CONSTANTS.STANDARD; --VJ: Added for NSLBJ--
6623:
6624: FND_MESSAGE.SET_NAME('WSM', 'WSM_MODIFIED_FIELD');
6625: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'common_bom_sequence_id in Resulting Jobs');
6626: l_fnd_err_msg := FND_MESSAGE.GET;
6627: IF (l_debug = 'Y') THEN
6628: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): '||l_fnd_err_msg);
6629: END IF;

Line 6626: l_fnd_err_msg := FND_MESSAGE.GET;

6622: AND wrji.job_type = WIP_CONSTANTS.STANDARD; --VJ: Added for NSLBJ--
6623:
6624: FND_MESSAGE.SET_NAME('WSM', 'WSM_MODIFIED_FIELD');
6625: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'common_bom_sequence_id in Resulting Jobs');
6626: l_fnd_err_msg := FND_MESSAGE.GET;
6627: IF (l_debug = 'Y') THEN
6628: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): '||l_fnd_err_msg);
6629: END IF;
6630: WSMPUTIL.AUTONOMOUS_WRITE_TO_WIE (p_header_id => l_header_id,

Line 6643: FND_MESSAGE.SET_NAME('WSM', 'WSM_INVALID_FIELD');

6639: raise proc_error;
6640: END IF;
6641:
6642: else
6643: FND_MESSAGE.SET_NAME('WSM', 'WSM_INVALID_FIELD');
6644: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'alternate_bom_designator in Resulting Jobs');
6645: l_fnd_err_msg := FND_MESSAGE.GET;
6646: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): '||l_fnd_err_msg);
6647:

Line 6644: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'alternate_bom_designator in Resulting Jobs');

6640: END IF;
6641:
6642: else
6643: FND_MESSAGE.SET_NAME('WSM', 'WSM_INVALID_FIELD');
6644: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'alternate_bom_designator in Resulting Jobs');
6645: l_fnd_err_msg := FND_MESSAGE.GET;
6646: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): '||l_fnd_err_msg);
6647:
6648: set_wrji_error(); -- WLTEnh

Line 6645: l_fnd_err_msg := FND_MESSAGE.GET;

6641:
6642: else
6643: FND_MESSAGE.SET_NAME('WSM', 'WSM_INVALID_FIELD');
6644: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'alternate_bom_designator in Resulting Jobs');
6645: l_fnd_err_msg := FND_MESSAGE.GET;
6646: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): '||l_fnd_err_msg);
6647:
6648: set_wrji_error(); -- WLTEnh
6649:

Line 6697: FND_MESSAGE.SET_NAME('WSM', 'WSM_MODIFIED_FIELD');

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:
6697: FND_MESSAGE.SET_NAME('WSM', 'WSM_MODIFIED_FIELD');
6698: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'common_bom_sequence_id/alternate_bom_designator in Resulting Jobs');
6699: l_fnd_err_msg := FND_MESSAGE.GET;
6700: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): '||l_fnd_err_msg);
6701:

Line 6698: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'common_bom_sequence_id/alternate_bom_designator in Resulting Jobs');

6694: alternate_bom_designator = l_alt_bom_desig
6695: WHERE wrji.header_id = l_header_id;
6696:
6697: FND_MESSAGE.SET_NAME('WSM', 'WSM_MODIFIED_FIELD');
6698: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'common_bom_sequence_id/alternate_bom_designator in Resulting Jobs');
6699: l_fnd_err_msg := FND_MESSAGE.GET;
6700: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): '||l_fnd_err_msg);
6701:
6702: WSMPUTIL.AUTONOMOUS_WRITE_TO_WIE (p_header_id => l_header_id,

Line 6699: l_fnd_err_msg := FND_MESSAGE.GET;

6695: WHERE wrji.header_id = l_header_id;
6696:
6697: FND_MESSAGE.SET_NAME('WSM', 'WSM_MODIFIED_FIELD');
6698: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'common_bom_sequence_id/alternate_bom_designator in Resulting Jobs');
6699: l_fnd_err_msg := FND_MESSAGE.GET;
6700: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): '||l_fnd_err_msg);
6701:
6702: WSMPUTIL.AUTONOMOUS_WRITE_TO_WIE (p_header_id => l_header_id,
6703: p_message => substr(l_fnd_err_msg,1,2000),

Line 6746: FND_MESSAGE.SET_NAME('WSM', 'WSM_INVALID_FIELD');

6742:
6743: --VJ: End Changes for NSLBJ--
6744:
6745: IF (SQL%ROWCOUNT > 0) THEN
6746: FND_MESSAGE.SET_NAME('WSM', 'WSM_INVALID_FIELD');
6747: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'alternate_routing_designator in Resulting Jobs');
6748: l_fnd_err_msg := FND_MESSAGE.GET;
6749: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): '||l_fnd_err_msg);
6750:

Line 6747: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'alternate_routing_designator in Resulting Jobs');

6743: --VJ: End Changes for NSLBJ--
6744:
6745: IF (SQL%ROWCOUNT > 0) THEN
6746: FND_MESSAGE.SET_NAME('WSM', 'WSM_INVALID_FIELD');
6747: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'alternate_routing_designator in Resulting Jobs');
6748: l_fnd_err_msg := FND_MESSAGE.GET;
6749: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): '||l_fnd_err_msg);
6750:
6751: set_wrji_error(); -- WLTEnh

Line 6748: l_fnd_err_msg := FND_MESSAGE.GET;

6744:
6745: IF (SQL%ROWCOUNT > 0) THEN
6746: FND_MESSAGE.SET_NAME('WSM', 'WSM_INVALID_FIELD');
6747: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'alternate_routing_designator in Resulting Jobs');
6748: l_fnd_err_msg := FND_MESSAGE.GET;
6749: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): '||l_fnd_err_msg);
6750:
6751: set_wrji_error(); -- WLTEnh
6752:

Line 6803: FND_MESSAGE.SET_NAME('WSM', 'WSM_INVALID_FIELD');

6799:
6800: --VJ: End Changes for NSLBJ--
6801:
6802: IF (SQL%ROWCOUNT > 0) THEN
6803: FND_MESSAGE.SET_NAME('WSM', 'WSM_INVALID_FIELD');
6804: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'alternate_bom_designator in Resulting Jobs');
6805: l_fnd_err_msg := FND_MESSAGE.GET;
6806: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): '||l_fnd_err_msg);
6807:

Line 6804: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'alternate_bom_designator in Resulting Jobs');

6800: --VJ: End Changes for NSLBJ--
6801:
6802: IF (SQL%ROWCOUNT > 0) THEN
6803: FND_MESSAGE.SET_NAME('WSM', 'WSM_INVALID_FIELD');
6804: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'alternate_bom_designator in Resulting Jobs');
6805: l_fnd_err_msg := FND_MESSAGE.GET;
6806: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): '||l_fnd_err_msg);
6807:
6808: set_wrji_error(); -- WLTEnh

Line 6805: l_fnd_err_msg := FND_MESSAGE.GET;

6801:
6802: IF (SQL%ROWCOUNT > 0) THEN
6803: FND_MESSAGE.SET_NAME('WSM', 'WSM_INVALID_FIELD');
6804: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'alternate_bom_designator in Resulting Jobs');
6805: l_fnd_err_msg := FND_MESSAGE.GET;
6806: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): '||l_fnd_err_msg);
6807:
6808: set_wrji_error(); -- WLTEnh
6809:

Line 6885: FND_MESSAGE.SET_NAME('WSM', 'WSM_MODIFIED_FIELD');

6881: AND (WRJI.routing_revision IS NULL
6882: OR WRJI.routing_revision_date IS NULL);
6883:
6884: IF (SQL%ROWCOUNT > 0) THEN
6885: FND_MESSAGE.SET_NAME('WSM', 'WSM_MODIFIED_FIELD');
6886: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'routing_revision/routing_revision_date in Resulting Jobs');
6887: l_fnd_err_msg := FND_MESSAGE.GET;
6888: If l_debug = 'Y' Then
6889:

Line 6886: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'routing_revision/routing_revision_date in Resulting Jobs');

6882: OR WRJI.routing_revision_date IS NULL);
6883:
6884: IF (SQL%ROWCOUNT > 0) THEN
6885: FND_MESSAGE.SET_NAME('WSM', 'WSM_MODIFIED_FIELD');
6886: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'routing_revision/routing_revision_date in Resulting Jobs');
6887: l_fnd_err_msg := FND_MESSAGE.GET;
6888: If l_debug = 'Y' Then
6889:
6890: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('

Line 6887: l_fnd_err_msg := FND_MESSAGE.GET;

6883:
6884: IF (SQL%ROWCOUNT > 0) THEN
6885: FND_MESSAGE.SET_NAME('WSM', 'WSM_MODIFIED_FIELD');
6886: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'routing_revision/routing_revision_date in Resulting Jobs');
6887: l_fnd_err_msg := FND_MESSAGE.GET;
6888: If l_debug = 'Y' Then
6889:
6890: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('
6891: ||l_stmt_num||'): '||l_fnd_err_msg);

Line 6971: FND_MESSAGE.SET_NAME('WSM', 'WSM_MODIFIED_FIELD');

6967: AND (WRJI.bom_revision IS NULL
6968: OR WRJI.bom_revision_date IS NULL);
6969: */
6970: IF (SQL%ROWCOUNT > 0) THEN
6971: FND_MESSAGE.SET_NAME('WSM', 'WSM_MODIFIED_FIELD');
6972: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'bom_revision/bom_revision_date in Resulting Jobs');
6973: l_fnd_err_msg := FND_MESSAGE.GET;
6974: If l_debug = 'Y' Then
6975: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('

Line 6972: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'bom_revision/bom_revision_date in Resulting Jobs');

6968: OR WRJI.bom_revision_date IS NULL);
6969: */
6970: IF (SQL%ROWCOUNT > 0) THEN
6971: FND_MESSAGE.SET_NAME('WSM', 'WSM_MODIFIED_FIELD');
6972: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'bom_revision/bom_revision_date in Resulting Jobs');
6973: l_fnd_err_msg := FND_MESSAGE.GET;
6974: If l_debug = 'Y' Then
6975: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('
6976: ||l_stmt_num||'): '||l_fnd_err_msg);

Line 6973: l_fnd_err_msg := FND_MESSAGE.GET;

6969: */
6970: IF (SQL%ROWCOUNT > 0) THEN
6971: FND_MESSAGE.SET_NAME('WSM', 'WSM_MODIFIED_FIELD');
6972: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'bom_revision/bom_revision_date in Resulting Jobs');
6973: l_fnd_err_msg := FND_MESSAGE.GET;
6974: If l_debug = 'Y' Then
6975: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('
6976: ||l_stmt_num||'): '||l_fnd_err_msg);
6977: End If;

Line 7029: FND_MESSAGE.SET_NAME('WSM', 'WSM_INVALID_FIELD');

7025: );
7026: --VJ: End Changes for NSLBJ--
7027:
7028: IF (SQL%ROWCOUNT > 0) THEN
7029: FND_MESSAGE.SET_NAME('WSM', 'WSM_INVALID_FIELD');
7030: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'routing_revision/routing_revision_date in Resulting Jobs');
7031: l_fnd_err_msg := FND_MESSAGE.GET;
7032: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): '||l_fnd_err_msg);
7033:

Line 7030: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'routing_revision/routing_revision_date in Resulting Jobs');

7026: --VJ: End Changes for NSLBJ--
7027:
7028: IF (SQL%ROWCOUNT > 0) THEN
7029: FND_MESSAGE.SET_NAME('WSM', 'WSM_INVALID_FIELD');
7030: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'routing_revision/routing_revision_date in Resulting Jobs');
7031: l_fnd_err_msg := FND_MESSAGE.GET;
7032: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): '||l_fnd_err_msg);
7033:
7034: set_wrji_error(); -- WLTEnh

Line 7031: l_fnd_err_msg := FND_MESSAGE.GET;

7027:
7028: IF (SQL%ROWCOUNT > 0) THEN
7029: FND_MESSAGE.SET_NAME('WSM', 'WSM_INVALID_FIELD');
7030: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'routing_revision/routing_revision_date in Resulting Jobs');
7031: l_fnd_err_msg := FND_MESSAGE.GET;
7032: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): '||l_fnd_err_msg);
7033:
7034: set_wrji_error(); -- WLTEnh
7035:

Line 7073: FND_MESSAGE.SET_NAME('WSM', 'WSM_INFO_NOT_FOUND');

7069: MIR.EFFECTIVITY_DATE AND MIR.HIGH_DATE ) );
7070:
7071: EXCEPTION
7072: WHEN NO_DATA_FOUND THEN
7073: FND_MESSAGE.SET_NAME('WSM', 'WSM_INFO_NOT_FOUND');
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;

Line 7074: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'bill revision in Resulting Jobs');

7070:
7071: EXCEPTION
7072: WHEN NO_DATA_FOUND THEN
7073: FND_MESSAGE.SET_NAME('WSM', 'WSM_INFO_NOT_FOUND');
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

Line 7075: l_fnd_err_msg := FND_MESSAGE.GET;

7071: EXCEPTION
7072: WHEN NO_DATA_FOUND THEN
7073: FND_MESSAGE.SET_NAME('WSM', 'WSM_INFO_NOT_FOUND');
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

Line 7265: FND_MESSAGE.SET_NAME('WSM', 'WSM_JOB_AT_NSO'); --BBK

7261:
7262: if (l_op_is_std = 0 and l_sj_intraoperation_step <> WIP_CONSTANTS.TOMOVE ) then
7263: l_stmt_num := 187;
7264: -- op is non-std
7265: FND_MESSAGE.SET_NAME('WSM', 'WSM_JOB_AT_NSO'); --BBK
7266: l_fnd_err_msg := FND_MESSAGE.GET;
7267: -- l_fnd_err_msg := 'Please specify the starting operation, since current operation does not exist in the target routing.';
7268: raise l_processing_err_excp;
7269:

Line 7266: l_fnd_err_msg := FND_MESSAGE.GET;

7262: if (l_op_is_std = 0 and l_sj_intraoperation_step <> WIP_CONSTANTS.TOMOVE ) then
7263: l_stmt_num := 187;
7264: -- op is non-std
7265: FND_MESSAGE.SET_NAME('WSM', 'WSM_JOB_AT_NSO'); --BBK
7266: l_fnd_err_msg := FND_MESSAGE.GET;
7267: -- l_fnd_err_msg := 'Please specify the starting operation, since current operation does not exist in the target routing.';
7268: raise l_processing_err_excp;
7269:
7270: elsif (l_op_rptd_times = 0 and l_sj_intraoperation_step <> WIP_CONSTANTS.TOMOVE) then

Line 7273: fnd_message.set_name('WSM', 'WSM_NO_CURRENT_STDOP_TGTRTG'); --BBK

7269:
7270: elsif (l_op_rptd_times = 0 and l_sj_intraoperation_step <> WIP_CONSTANTS.TOMOVE) then
7271: l_stmt_num := 188;
7272: -- this std op does not exist in the target asly/routing
7273: fnd_message.set_name('WSM', 'WSM_NO_CURRENT_STDOP_TGTRTG'); --BBK
7274: l_fnd_err_msg := FND_MESSAGE.GET;
7275: raise l_processing_err_excp;
7276:
7277: -- BA#Bug#2095535 BBK:NSO:WLT

Line 7274: l_fnd_err_msg := FND_MESSAGE.GET;

7270: elsif (l_op_rptd_times = 0 and l_sj_intraoperation_step <> WIP_CONSTANTS.TOMOVE) then
7271: l_stmt_num := 188;
7272: -- this std op does not exist in the target asly/routing
7273: fnd_message.set_name('WSM', 'WSM_NO_CURRENT_STDOP_TGTRTG'); --BBK
7274: l_fnd_err_msg := FND_MESSAGE.GET;
7275: raise l_processing_err_excp;
7276:
7277: -- BA#Bug#2095535 BBK:NSO:WLT
7278:

Line 7315: FND_MESSAGE.SET_NAME('WSM', 'WSM_MODIFIED_FIELD');

7311: and wrji.process_status = WIP_CONSTANTS.RUNNING
7312: and wrji.internal_group_id = WSMPLOAD.G_GROUP_ID;
7313:
7314:
7315: FND_MESSAGE.SET_NAME('WSM', 'WSM_MODIFIED_FIELD');
7316: FND_MESSAGE.SET_TOKEN('FLD_NAME',
7317: ( ' starting operation code/std.op id in Resulting Jobs,'||
7318: ' as current operation is uniquely identified in target routing')
7319: );

Line 7316: FND_MESSAGE.SET_TOKEN('FLD_NAME',

7312: and wrji.internal_group_id = WSMPLOAD.G_GROUP_ID;
7313:
7314:
7315: FND_MESSAGE.SET_NAME('WSM', 'WSM_MODIFIED_FIELD');
7316: FND_MESSAGE.SET_TOKEN('FLD_NAME',
7317: ( ' starting operation code/std.op id in Resulting Jobs,'||
7318: ' as current operation is uniquely identified in target routing')
7319: );
7320: l_fnd_err_msg := FND_MESSAGE.GET;

Line 7320: l_fnd_err_msg := FND_MESSAGE.GET;

7316: FND_MESSAGE.SET_TOKEN('FLD_NAME',
7317: ( ' starting operation code/std.op id in Resulting Jobs,'||
7318: ' as current operation is uniquely identified in target routing')
7319: );
7320: l_fnd_err_msg := FND_MESSAGE.GET;
7321: IF (l_debug = 'Y') THEN
7322: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('
7323: ||l_stmt_num||'): '||l_fnd_err_msg);
7324: END IF;

Line 7342: FND_MESSAGE.SET_NAME('WSM', 'WSM_JOB_AT_REPEATED_OP'); --BBK

7338:
7339: elsif (l_op_rptd_times > 1 and l_sj_intraoperation_step <> WIP_CONSTANTS.TOMOVE ) then
7340: -- this std op is repeated more than once in the routing.
7341: l_stmt_num := 192;
7342: FND_MESSAGE.SET_NAME('WSM', 'WSM_JOB_AT_REPEATED_OP'); --BBK
7343: l_fnd_err_msg := FND_MESSAGE.GET;
7344: raise l_processing_err_excp;
7345:
7346: elsif (

Line 7343: l_fnd_err_msg := FND_MESSAGE.GET;

7339: elsif (l_op_rptd_times > 1 and l_sj_intraoperation_step <> WIP_CONSTANTS.TOMOVE ) then
7340: -- this std op is repeated more than once in the routing.
7341: l_stmt_num := 192;
7342: FND_MESSAGE.SET_NAME('WSM', 'WSM_JOB_AT_REPEATED_OP'); --BBK
7343: l_fnd_err_msg := FND_MESSAGE.GET;
7344: raise l_processing_err_excp;
7345:
7346: elsif (
7347: (l_op_is_std = 0 and l_sj_intraoperation_step = WIP_CONSTANTS.TOMOVE)

Line 7367: fnd_message.set_name('WSM', 'WSM_NO_WSM_ROUTING'); --BBK

7363: EXCEPTION
7364:
7365: when no_data_found then
7366: l_upd_rtg_asly_err := 1;
7367: fnd_message.set_name('WSM', 'WSM_NO_WSM_ROUTING'); --BBK
7368: l_fnd_err_msg := FND_MESSAGE.GET;
7369:
7370: when l_processing_err_excp then
7371: l_upd_rtg_asly_err := 1;

Line 7368: l_fnd_err_msg := FND_MESSAGE.GET;

7364:
7365: when no_data_found then
7366: l_upd_rtg_asly_err := 1;
7367: fnd_message.set_name('WSM', 'WSM_NO_WSM_ROUTING'); --BBK
7368: l_fnd_err_msg := FND_MESSAGE.GET;
7369:
7370: when l_processing_err_excp then
7371: l_upd_rtg_asly_err := 1;
7372:

Line 7451: FND_MESSAGE.SET_NAME('WSM', 'WSM_INVALID_FIELD');

7447:
7448: --VJ: End Changes for NSLBJ--
7449:
7450: IF (SQL%ROWCOUNT > 0) THEN
7451: FND_MESSAGE.SET_NAME('WSM', 'WSM_INVALID_FIELD');
7452: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'starting_std_op_id/starting_operation_code in Resulting Jobs');
7453: l_fnd_err_msg := FND_MESSAGE.GET;
7454: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): '||l_fnd_err_msg);
7455:

Line 7452: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'starting_std_op_id/starting_operation_code in Resulting Jobs');

7448: --VJ: End Changes for NSLBJ--
7449:
7450: IF (SQL%ROWCOUNT > 0) THEN
7451: FND_MESSAGE.SET_NAME('WSM', 'WSM_INVALID_FIELD');
7452: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'starting_std_op_id/starting_operation_code in Resulting Jobs');
7453: l_fnd_err_msg := FND_MESSAGE.GET;
7454: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): '||l_fnd_err_msg);
7455:
7456: set_wrji_error(); -- WLTEnh

Line 7453: l_fnd_err_msg := FND_MESSAGE.GET;

7449:
7450: IF (SQL%ROWCOUNT > 0) THEN
7451: FND_MESSAGE.SET_NAME('WSM', 'WSM_INVALID_FIELD');
7452: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'starting_std_op_id/starting_operation_code in Resulting Jobs');
7453: l_fnd_err_msg := FND_MESSAGE.GET;
7454: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): '||l_fnd_err_msg);
7455:
7456: set_wrji_error(); -- WLTEnh
7457:

Line 7615: FND_MESSAGE.SET_NAME('WSM', 'WSM_MODIFIED_FIELD');

7611: wrji.starting_std_op_id = l_bos_std_op_id
7612: WHERE wrji.header_id = l_header_id;
7613:
7614: IF (SQL%ROWCOUNT > 0) THEN
7615: FND_MESSAGE.SET_NAME('WSM', 'WSM_MODIFIED_FIELD');
7616: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'starting_operation_seq_num/starting_operation_code/starting_std_op_id in Resulting Jobs');
7617: l_fnd_err_msg := FND_MESSAGE.GET;
7618:
7619: If l_debug = 'Y' Then

Line 7616: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'starting_operation_seq_num/starting_operation_code/starting_std_op_id in Resulting Jobs');

7612: WHERE wrji.header_id = l_header_id;
7613:
7614: IF (SQL%ROWCOUNT > 0) THEN
7615: FND_MESSAGE.SET_NAME('WSM', 'WSM_MODIFIED_FIELD');
7616: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'starting_operation_seq_num/starting_operation_code/starting_std_op_id in Resulting Jobs');
7617: l_fnd_err_msg := FND_MESSAGE.GET;
7618:
7619: If l_debug = 'Y' Then
7620: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('

Line 7617: l_fnd_err_msg := FND_MESSAGE.GET;

7613:
7614: IF (SQL%ROWCOUNT > 0) THEN
7615: FND_MESSAGE.SET_NAME('WSM', 'WSM_MODIFIED_FIELD');
7616: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'starting_operation_seq_num/starting_operation_code/starting_std_op_id in Resulting Jobs');
7617: l_fnd_err_msg := FND_MESSAGE.GET;
7618:
7619: If l_debug = 'Y' Then
7620: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('
7621: ||l_stmt_num||'): '||l_fnd_err_msg);

Line 7796: FND_MESSAGE.SET_NAME('WSM', 'WSM_INVALID_FIELD');

7792: --End Changes to fix bug #2265237--
7793:
7794: exception
7795: when NO_DATA_FOUND then
7796: FND_MESSAGE.SET_NAME('WSM', 'WSM_INVALID_FIELD');
7797: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'starting_operation_code');
7798: l_fnd_err_msg := FND_MESSAGE.GET;
7799: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): '||l_fnd_err_msg);
7800:

Line 7797: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'starting_operation_code');

7793:
7794: exception
7795: when NO_DATA_FOUND then
7796: FND_MESSAGE.SET_NAME('WSM', 'WSM_INVALID_FIELD');
7797: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'starting_operation_code');
7798: l_fnd_err_msg := FND_MESSAGE.GET;
7799: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): '||l_fnd_err_msg);
7800:
7801: --Start Additions to fix bug #2265237--

Line 7798: l_fnd_err_msg := FND_MESSAGE.GET;

7794: exception
7795: when NO_DATA_FOUND then
7796: FND_MESSAGE.SET_NAME('WSM', 'WSM_INVALID_FIELD');
7797: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'starting_operation_code');
7798: l_fnd_err_msg := FND_MESSAGE.GET;
7799: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): '||l_fnd_err_msg);
7800:
7801: --Start Additions to fix bug #2265237--
7802: --Whenever there's error, error_message column in interface table should be updated.

Line 7846: FND_MESSAGE.SET_NAME('WSM', 'WSM_MODIFIED_FIELD');

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');
7848: l_fnd_err_msg := FND_MESSAGE.GET;
7849: If l_debug = 'Y' Then
7850: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('

Line 7847: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'starting_operation_seq_num in Resulting Jobs');

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');
7848: l_fnd_err_msg := FND_MESSAGE.GET;
7849: If l_debug = 'Y' Then
7850: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('
7851: ||l_stmt_num||'): '||l_fnd_err_msg);

Line 7848: l_fnd_err_msg := FND_MESSAGE.GET;

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');
7848: l_fnd_err_msg := FND_MESSAGE.GET;
7849: If l_debug = 'Y' Then
7850: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('
7851: ||l_stmt_num||'): '||l_fnd_err_msg);
7852: End If;

Line 7924: FND_MESSAGE.SET_NAME('WSM', 'WSM_INVALID_FIELD');

7920:
7921: exception
7922:
7923: when NO_DATA_FOUND then
7924: FND_MESSAGE.SET_NAME('WSM', 'WSM_INVALID_FIELD');
7925: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'starting_operation_seq_num');
7926: l_fnd_err_msg := FND_MESSAGE.GET;
7927: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): '||l_fnd_err_msg);
7928:

Line 7925: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'starting_operation_seq_num');

7921: exception
7922:
7923: when NO_DATA_FOUND then
7924: FND_MESSAGE.SET_NAME('WSM', 'WSM_INVALID_FIELD');
7925: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'starting_operation_seq_num');
7926: l_fnd_err_msg := FND_MESSAGE.GET;
7927: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): '||l_fnd_err_msg);
7928:
7929: set_wrji_error(); -- WLTEnh

Line 7926: l_fnd_err_msg := FND_MESSAGE.GET;

7922:
7923: when NO_DATA_FOUND then
7924: FND_MESSAGE.SET_NAME('WSM', 'WSM_INVALID_FIELD');
7925: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'starting_operation_seq_num');
7926: l_fnd_err_msg := FND_MESSAGE.GET;
7927: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): '||l_fnd_err_msg);
7928:
7929: set_wrji_error(); -- WLTEnh
7930:

Line 7962: FND_MESSAGE.SET_NAME('WSM', 'WSM_MODIFIED_FIELD');

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');
7964: l_fnd_err_msg := FND_MESSAGE.GET;
7965: IF (l_debug = 'Y') THEN
7966: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('

Line 7963: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'starting_operation_code in Resulting Jobs');

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');
7964: l_fnd_err_msg := FND_MESSAGE.GET;
7965: IF (l_debug = 'Y') THEN
7966: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('
7967: ||l_stmt_num||'): '||l_fnd_err_msg);

Line 7964: l_fnd_err_msg := FND_MESSAGE.GET;

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');
7964: l_fnd_err_msg := FND_MESSAGE.GET;
7965: IF (l_debug = 'Y') THEN
7966: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('
7967: ||l_stmt_num||'): '||l_fnd_err_msg);
7968: END IF;

Line 8001: FND_MESSAGE.SET_NAME('WSM', 'WSM_MODIFIED_FIELD');

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');
8003: l_fnd_err_msg := FND_MESSAGE.GET;
8004: IF (l_debug = 'Y') THEN
8005: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('

Line 8002: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'starting_std_op_id in Resulting Jobs');

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');
8003: l_fnd_err_msg := FND_MESSAGE.GET;
8004: IF (l_debug = 'Y') THEN
8005: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('
8006: ||l_stmt_num||'): '||l_fnd_err_msg);

Line 8003: l_fnd_err_msg := FND_MESSAGE.GET;

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');
8003: l_fnd_err_msg := FND_MESSAGE.GET;
8004: IF (l_debug = 'Y') THEN
8005: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('
8006: ||l_stmt_num||'): '||l_fnd_err_msg);
8007: END IF;

Line 8045: FND_MESSAGE.SET_NAME('WSM', 'WSM_INVALID_FIELD');

8041:
8042: IF (SQL%ROWCOUNT > 0) THEN
8043: set_wrji_error(); -- WLTEnh
8044:
8045: FND_MESSAGE.SET_NAME('WSM', 'WSM_INVALID_FIELD');
8046: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'starting_std_op_id/starting_operation_code in Resulting Jobs');
8047: l_fnd_err_msg := FND_MESSAGE.GET;
8048: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): '||l_fnd_err_msg);
8049:

Line 8046: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'starting_std_op_id/starting_operation_code in Resulting Jobs');

8042: IF (SQL%ROWCOUNT > 0) THEN
8043: set_wrji_error(); -- WLTEnh
8044:
8045: FND_MESSAGE.SET_NAME('WSM', 'WSM_INVALID_FIELD');
8046: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'starting_std_op_id/starting_operation_code in Resulting Jobs');
8047: l_fnd_err_msg := FND_MESSAGE.GET;
8048: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): '||l_fnd_err_msg);
8049:
8050: WSMPUTIL.AUTONOMOUS_WRITE_TO_WIE (p_header_id => l_header_id,

Line 8047: l_fnd_err_msg := FND_MESSAGE.GET;

8043: set_wrji_error(); -- WLTEnh
8044:
8045: FND_MESSAGE.SET_NAME('WSM', 'WSM_INVALID_FIELD');
8046: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'starting_std_op_id/starting_operation_code in Resulting Jobs');
8047: l_fnd_err_msg := FND_MESSAGE.GET;
8048: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): '||l_fnd_err_msg);
8049:
8050: WSMPUTIL.AUTONOMOUS_WRITE_TO_WIE (p_header_id => l_header_id,
8051: p_message => substr(l_fnd_err_msg,1,2000),

Line 8131: FND_MESSAGE.SET_NAME('WSM', 'WSM_OPRN_NOT_PRIMARY');

8127: IF (SQL%ROWCOUNT > 0) THEN
8128:
8129: set_wrji_error(); -- WLTEnh
8130:
8131: FND_MESSAGE.SET_NAME('WSM', 'WSM_OPRN_NOT_PRIMARY');
8132: l_fnd_err_msg := FND_MESSAGE.GET;
8133: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): '||l_fnd_err_msg);
8134:
8135: WSMPUTIL.AUTONOMOUS_WRITE_TO_WIE (p_header_id => l_header_id,

Line 8132: l_fnd_err_msg := FND_MESSAGE.GET;

8128:
8129: set_wrji_error(); -- WLTEnh
8130:
8131: FND_MESSAGE.SET_NAME('WSM', 'WSM_OPRN_NOT_PRIMARY');
8132: l_fnd_err_msg := FND_MESSAGE.GET;
8133: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): '||l_fnd_err_msg);
8134:
8135: WSMPUTIL.AUTONOMOUS_WRITE_TO_WIE (p_header_id => l_header_id,
8136: p_message => substr(l_fnd_err_msg,1,2000),

Line 8175: FND_MESSAGE.SET_NAME('WSM', 'WSM_INVALID_FIELD');

8171: IF (SQL%ROWCOUNT > 0) THEN
8172:
8173: set_wrji_error(); -- WLTEnh
8174:
8175: FND_MESSAGE.SET_NAME('WSM', 'WSM_INVALID_FIELD');
8176: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'starting_intraoperation_step in Resulting Jobs');
8177: l_fnd_err_msg := FND_MESSAGE.GET;
8178: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): '||l_fnd_err_msg);
8179:

Line 8176: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'starting_intraoperation_step in Resulting Jobs');

8172:
8173: set_wrji_error(); -- WLTEnh
8174:
8175: FND_MESSAGE.SET_NAME('WSM', 'WSM_INVALID_FIELD');
8176: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'starting_intraoperation_step in Resulting Jobs');
8177: l_fnd_err_msg := FND_MESSAGE.GET;
8178: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): '||l_fnd_err_msg);
8179:
8180: WSMPUTIL.AUTONOMOUS_WRITE_TO_WIE (p_header_id => l_header_id,

Line 8177: l_fnd_err_msg := FND_MESSAGE.GET;

8173: set_wrji_error(); -- WLTEnh
8174:
8175: FND_MESSAGE.SET_NAME('WSM', 'WSM_INVALID_FIELD');
8176: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'starting_intraoperation_step in Resulting Jobs');
8177: l_fnd_err_msg := FND_MESSAGE.GET;
8178: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): '||l_fnd_err_msg);
8179:
8180: WSMPUTIL.AUTONOMOUS_WRITE_TO_WIE (p_header_id => l_header_id,
8181: p_message => substr(l_fnd_err_msg,1,2000),

Line 8227: FND_MESSAGE.SET_NAME('WSM', 'WSM_DISALLOW_SCH_DATE_CHANGE');

8223: WHERE wrji.header_id = l_header_id
8224: AND scheduled_completion_date <> l_sch_comp_date;
8225:
8226: IF (SQL%ROWCOUNT > 0) THEN
8227: FND_MESSAGE.SET_NAME('WSM', 'WSM_DISALLOW_SCH_DATE_CHANGE');
8228: l_fnd_err_msg := FND_MESSAGE.GET;
8229: If l_debug = 'Y' Then
8230: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('
8231: ||l_stmt_num||'): '||l_fnd_err_msg);

Line 8228: l_fnd_err_msg := FND_MESSAGE.GET;

8224: AND scheduled_completion_date <> l_sch_comp_date;
8225:
8226: IF (SQL%ROWCOUNT > 0) THEN
8227: FND_MESSAGE.SET_NAME('WSM', 'WSM_DISALLOW_SCH_DATE_CHANGE');
8228: l_fnd_err_msg := FND_MESSAGE.GET;
8229: If l_debug = 'Y' Then
8230: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('
8231: ||l_stmt_num||'): '||l_fnd_err_msg);
8232: End If;

Line 8281: FND_MESSAGE.SET_NAME('WSM', 'WSM_NULL_FIELD');

8277: -- BC: czh.bug2398718, added code to error out if completion_sub_inv is null
8278: -- if (l_comp_sub_inv_r is not null) then
8279: if (l_comp_sub_inv_r is null and l_job_type = 1 ) then --For Std Job only. Bug#2679562
8280: -- error out saying Completion Subinventory is needed
8281: FND_MESSAGE.SET_NAME('WSM', 'WSM_NULL_FIELD');
8282: FND_MESSAGE.SET_TOKEN('FLD_NAME',
8283: 'Completion Subinventory in Resulting jobs');
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);

Line 8282: FND_MESSAGE.SET_TOKEN('FLD_NAME',

8278: -- if (l_comp_sub_inv_r is not null) then
8279: if (l_comp_sub_inv_r is null and l_job_type = 1 ) then --For Std Job only. Bug#2679562
8280: -- error out saying Completion Subinventory is needed
8281: FND_MESSAGE.SET_NAME('WSM', 'WSM_NULL_FIELD');
8282: FND_MESSAGE.SET_TOKEN('FLD_NAME',
8283: 'Completion Subinventory in Resulting jobs');
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;

Line 8284: l_fnd_err_msg := FND_MESSAGE.GET;

8280: -- error out saying Completion Subinventory is needed
8281: FND_MESSAGE.SET_NAME('WSM', 'WSM_NULL_FIELD');
8282: FND_MESSAGE.SET_TOKEN('FLD_NAME',
8283: 'Completion Subinventory in Resulting jobs');
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

Line 8321: FND_MESSAGE.SET_NAME('WSM', 'WSM_INVALID_FIELD');

8317: l_stmt_num := 223;
8318:
8319: if l_count = 0 then
8320: l_stmt_num := 224;
8321: FND_MESSAGE.SET_NAME('WSM', 'WSM_INVALID_FIELD');
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:

Line 8322: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'Completion Subinventory in Resulting jobs');

8318:
8319: if l_count = 0 then
8320: l_stmt_num := 224;
8321: FND_MESSAGE.SET_NAME('WSM', 'WSM_INVALID_FIELD');
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

Line 8323: l_fnd_err_msg := FND_MESSAGE.GET;

8319: if l_count = 0 then
8320: l_stmt_num := 224;
8321: FND_MESSAGE.SET_NAME('WSM', 'WSM_INVALID_FIELD');
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

Line 8386: FND_MESSAGE.SET_NAME('WSM', 'WSM_INVALID_FIELD');

8382: end;
8383:
8384: if not l_loc_success then
8385:
8386: FND_MESSAGE.SET_NAME('WSM', 'WSM_INVALID_FIELD');
8387: FND_MESSAGE.SET_TOKEN('FLD_NAME',
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);

Line 8387: FND_MESSAGE.SET_TOKEN('FLD_NAME',

8383:
8384: if not l_loc_success then
8385:
8386: FND_MESSAGE.SET_NAME('WSM', 'WSM_INVALID_FIELD');
8387: FND_MESSAGE.SET_TOKEN('FLD_NAME',
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:

Line 8389: l_fnd_err_msg := FND_MESSAGE.GET;

8385:
8386: FND_MESSAGE.SET_NAME('WSM', 'WSM_INVALID_FIELD');
8387: FND_MESSAGE.SET_TOKEN('FLD_NAME',
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

Line 8429: FND_MESSAGE.SET_NAME('WSM', 'WSM_NULL_FIELD');

8425: -- if(l_locator_control_type = 2 and l_comp_loc_id_r = -1) then -- BBK- Bug#2795951
8426: if(l_locator_control_type <> 1 and l_comp_loc_id_r = -1) then -- BBK- Bug#2795951
8427: l_stmt_num := 226;
8428: -- error out saying Completion Locator is needed
8429: FND_MESSAGE.SET_NAME('WSM', 'WSM_NULL_FIELD');
8430: FND_MESSAGE.SET_TOKEN('FLD_NAME',
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);

Line 8430: FND_MESSAGE.SET_TOKEN('FLD_NAME',

8426: if(l_locator_control_type <> 1 and l_comp_loc_id_r = -1) then -- BBK- Bug#2795951
8427: l_stmt_num := 226;
8428: -- error out saying Completion Locator is needed
8429: FND_MESSAGE.SET_NAME('WSM', 'WSM_NULL_FIELD');
8430: FND_MESSAGE.SET_TOKEN('FLD_NAME',
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:

Line 8432: l_fnd_err_msg := FND_MESSAGE.GET;

8428: -- error out saying Completion Locator is needed
8429: FND_MESSAGE.SET_NAME('WSM', 'WSM_NULL_FIELD');
8430: FND_MESSAGE.SET_TOKEN('FLD_NAME',
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

Line 8466: FND_MESSAGE.SET_NAME('WSM', 'WSM_INVALID_FIELD');

8462: and SUBINVENTORY_CODE = l_comp_sub_inv_r
8463: and organization_id = l_organization_id;
8464:
8465: if l_count = 0 then
8466: FND_MESSAGE.SET_NAME('WSM', 'WSM_INVALID_FIELD');
8467: FND_MESSAGE.SET_TOKEN('FLD_NAME',
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);

Line 8467: FND_MESSAGE.SET_TOKEN('FLD_NAME',

8463: and organization_id = l_organization_id;
8464:
8465: if l_count = 0 then
8466: FND_MESSAGE.SET_NAME('WSM', 'WSM_INVALID_FIELD');
8467: FND_MESSAGE.SET_TOKEN('FLD_NAME',
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:

Line 8469: l_fnd_err_msg := FND_MESSAGE.GET;

8465: if l_count = 0 then
8466: FND_MESSAGE.SET_NAME('WSM', 'WSM_INVALID_FIELD');
8467: FND_MESSAGE.SET_TOKEN('FLD_NAME',
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

Line 8500: FND_MESSAGE.SET_NAME('WSM', 'WSM_MODIFIED_FIELD');

8496: SET wrji.completion_locator_id = NULL
8497: where header_id = l_header_id
8498: and wip_entity_name = l_job_name;
8499:
8500: FND_MESSAGE.SET_NAME('WSM', 'WSM_MODIFIED_FIELD');
8501: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'Completion Locator ID to NULL in Resulting jobs');
8502: l_fnd_err_msg := FND_MESSAGE.GET;
8503:
8504: If l_debug = 'Y' Then

Line 8501: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'Completion Locator ID to NULL in Resulting jobs');

8497: where header_id = l_header_id
8498: and wip_entity_name = l_job_name;
8499:
8500: FND_MESSAGE.SET_NAME('WSM', 'WSM_MODIFIED_FIELD');
8501: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'Completion Locator ID to NULL in Resulting jobs');
8502: l_fnd_err_msg := FND_MESSAGE.GET;
8503:
8504: If l_debug = 'Y' Then
8505: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('

Line 8502: l_fnd_err_msg := FND_MESSAGE.GET;

8498: and wip_entity_name = l_job_name;
8499:
8500: FND_MESSAGE.SET_NAME('WSM', 'WSM_MODIFIED_FIELD');
8501: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'Completion Locator ID to NULL in Resulting jobs');
8502: l_fnd_err_msg := FND_MESSAGE.GET;
8503:
8504: If l_debug = 'Y' Then
8505: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('
8506: ||l_stmt_num||'): '||l_fnd_err_msg);

Line 8604: FND_MESSAGE.SET_NAME('WSM', 'WSM_OP_PO_MOVE');

8600:
8601:
8602: set_wrji_error();
8603:
8604: FND_MESSAGE.SET_NAME('WSM', 'WSM_OP_PO_MOVE');
8605: l_fnd_err_msg := FND_MESSAGE.GET;
8606: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): '||
8607: l_fnd_err_msg);
8608:

Line 8605: l_fnd_err_msg := FND_MESSAGE.GET;

8601:
8602: set_wrji_error();
8603:
8604: FND_MESSAGE.SET_NAME('WSM', 'WSM_OP_PO_MOVE');
8605: l_fnd_err_msg := FND_MESSAGE.GET;
8606: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): '||
8607: l_fnd_err_msg);
8608:
8609: WSMPUTIL.AUTONOMOUS_WRITE_TO_WIE (p_header_id => l_header_id,

Line 8627: FND_MESSAGE.SET_NAME('WSM', 'WSM_INVALID_FIELD');

8623: Exception
8624:
8625: When NO_DATA_FOUND Then
8626:
8627: FND_MESSAGE.SET_NAME('WSM', 'WSM_INVALID_FIELD');
8628: FND_MESSAGE.SET_TOKEN('FLD_NAME', ' starting_operation_seq_num');
8629: l_fnd_err_msg := FND_MESSAGE.GET;
8630: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('
8631: ||l_stmt_num||'): '||l_fnd_err_msg);

Line 8628: FND_MESSAGE.SET_TOKEN('FLD_NAME', ' starting_operation_seq_num');

8624:
8625: When NO_DATA_FOUND Then
8626:
8627: FND_MESSAGE.SET_NAME('WSM', 'WSM_INVALID_FIELD');
8628: FND_MESSAGE.SET_TOKEN('FLD_NAME', ' starting_operation_seq_num');
8629: l_fnd_err_msg := FND_MESSAGE.GET;
8630: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('
8631: ||l_stmt_num||'): '||l_fnd_err_msg);
8632:

Line 8629: l_fnd_err_msg := FND_MESSAGE.GET;

8625: When NO_DATA_FOUND Then
8626:
8627: FND_MESSAGE.SET_NAME('WSM', 'WSM_INVALID_FIELD');
8628: FND_MESSAGE.SET_TOKEN('FLD_NAME', ' starting_operation_seq_num');
8629: l_fnd_err_msg := FND_MESSAGE.GET;
8630: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('
8631: ||l_stmt_num||'): '||l_fnd_err_msg);
8632:
8633: set_wrji_error(); -- WLTEnh

Line 8774: FND_MESSAGE.SET_NAME('WSM', 'WSM_PENDING_TXN');

8770: ||l_header_id
8771: ||' set to ERROR in WSMTI ');
8772:
8773: IF (SQL%ROWCOUNT > 0) THEN
8774: FND_MESSAGE.SET_NAME('WSM', 'WSM_PENDING_TXN');
8775: FND_MESSAGE.SET_TOKEN('TABLE', 'wip_move_transaction_interface');
8776: l_fnd_err_msg := FND_MESSAGE.GET;
8777: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): '||l_fnd_err_msg);
8778:

Line 8775: FND_MESSAGE.SET_TOKEN('TABLE', 'wip_move_transaction_interface');

8771: ||' set to ERROR in WSMTI ');
8772:
8773: IF (SQL%ROWCOUNT > 0) THEN
8774: FND_MESSAGE.SET_NAME('WSM', 'WSM_PENDING_TXN');
8775: FND_MESSAGE.SET_TOKEN('TABLE', 'wip_move_transaction_interface');
8776: l_fnd_err_msg := FND_MESSAGE.GET;
8777: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): '||l_fnd_err_msg);
8778:
8779: WSMPUTIL.AUTONOMOUS_WRITE_TO_WIE (p_header_id => l_header_id,

Line 8776: l_fnd_err_msg := FND_MESSAGE.GET;

8772:
8773: IF (SQL%ROWCOUNT > 0) THEN
8774: FND_MESSAGE.SET_NAME('WSM', 'WSM_PENDING_TXN');
8775: FND_MESSAGE.SET_TOKEN('TABLE', 'wip_move_transaction_interface');
8776: l_fnd_err_msg := FND_MESSAGE.GET;
8777: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): '||l_fnd_err_msg);
8778:
8779: WSMPUTIL.AUTONOMOUS_WRITE_TO_WIE (p_header_id => l_header_id,
8780: p_message => substr(l_fnd_err_msg,1,2000),

Line 8836: FND_MESSAGE.SET_NAME('WSM', 'WSM_PENDING_TXN');

8832: ||l_header_id
8833: ||' set to ERROR in WSMTI ');
8834:
8835: IF (SQL%ROWCOUNT > 0) THEN
8836: FND_MESSAGE.SET_NAME('WSM', 'WSM_PENDING_TXN');
8837: FND_MESSAGE.SET_TOKEN('TABLE', 'wsm_split_merge_transactions');
8838: l_fnd_err_msg := FND_MESSAGE.GET;
8839: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): '||l_fnd_err_msg);
8840:

Line 8837: FND_MESSAGE.SET_TOKEN('TABLE', 'wsm_split_merge_transactions');

8833: ||' set to ERROR in WSMTI ');
8834:
8835: IF (SQL%ROWCOUNT > 0) THEN
8836: FND_MESSAGE.SET_NAME('WSM', 'WSM_PENDING_TXN');
8837: FND_MESSAGE.SET_TOKEN('TABLE', 'wsm_split_merge_transactions');
8838: l_fnd_err_msg := FND_MESSAGE.GET;
8839: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): '||l_fnd_err_msg);
8840:
8841: WSMPUTIL.AUTONOMOUS_WRITE_TO_WIE (p_header_id => l_header_id,

Line 8838: l_fnd_err_msg := FND_MESSAGE.GET;

8834:
8835: IF (SQL%ROWCOUNT > 0) THEN
8836: FND_MESSAGE.SET_NAME('WSM', 'WSM_PENDING_TXN');
8837: FND_MESSAGE.SET_TOKEN('TABLE', 'wsm_split_merge_transactions');
8838: l_fnd_err_msg := FND_MESSAGE.GET;
8839: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): '||l_fnd_err_msg);
8840:
8841: WSMPUTIL.AUTONOMOUS_WRITE_TO_WIE (p_header_id => l_header_id,
8842: p_message => substr(l_fnd_err_msg,1,2000),

Line 8900: FND_MESSAGE.SET_NAME('WSM', 'WSM_PENDING_TXN');

8896: ||l_header_id
8897: ||' set to ERROR in WSMTI ');
8898:
8899: IF (SQL%ROWCOUNT > 0) THEN
8900: FND_MESSAGE.SET_NAME('WSM', 'WSM_PENDING_TXN');
8901: FND_MESSAGE.SET_TOKEN('TABLE', 'wsm_lot_move_txn_interface');
8902: l_fnd_err_msg := FND_MESSAGE.GET;
8903: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): '||l_fnd_err_msg);
8904:

Line 8901: FND_MESSAGE.SET_TOKEN('TABLE', 'wsm_lot_move_txn_interface');

8897: ||' set to ERROR in WSMTI ');
8898:
8899: IF (SQL%ROWCOUNT > 0) THEN
8900: FND_MESSAGE.SET_NAME('WSM', 'WSM_PENDING_TXN');
8901: FND_MESSAGE.SET_TOKEN('TABLE', 'wsm_lot_move_txn_interface');
8902: l_fnd_err_msg := FND_MESSAGE.GET;
8903: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): '||l_fnd_err_msg);
8904:
8905: WSMPUTIL.AUTONOMOUS_WRITE_TO_WIE (p_header_id => l_header_id,

Line 8902: l_fnd_err_msg := FND_MESSAGE.GET;

8898:
8899: IF (SQL%ROWCOUNT > 0) THEN
8900: FND_MESSAGE.SET_NAME('WSM', 'WSM_PENDING_TXN');
8901: FND_MESSAGE.SET_TOKEN('TABLE', 'wsm_lot_move_txn_interface');
8902: l_fnd_err_msg := FND_MESSAGE.GET;
8903: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): '||l_fnd_err_msg);
8904:
8905: WSMPUTIL.AUTONOMOUS_WRITE_TO_WIE (p_header_id => l_header_id,
8906: p_message => substr(l_fnd_err_msg,1,2000),

Line 8973: FND_MESSAGE.SET_NAME('WSM', 'WSM_PENDING_TXN');

8969: ||l_header_id
8970: ||' set to ERROR in WSMTI ');
8971:
8972: IF (SQL%ROWCOUNT > 0) THEN
8973: FND_MESSAGE.SET_NAME('WSM', 'WSM_PENDING_TXN');
8974: FND_MESSAGE.SET_TOKEN('TABLE', 'wip_move_transaction_interface');
8975: l_fnd_err_msg := FND_MESSAGE.GET;
8976: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): '||l_fnd_err_msg);
8977:

Line 8974: FND_MESSAGE.SET_TOKEN('TABLE', 'wip_move_transaction_interface');

8970: ||' set to ERROR in WSMTI ');
8971:
8972: IF (SQL%ROWCOUNT > 0) THEN
8973: FND_MESSAGE.SET_NAME('WSM', 'WSM_PENDING_TXN');
8974: FND_MESSAGE.SET_TOKEN('TABLE', 'wip_move_transaction_interface');
8975: l_fnd_err_msg := FND_MESSAGE.GET;
8976: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): '||l_fnd_err_msg);
8977:
8978: WSMPUTIL.AUTONOMOUS_WRITE_TO_WIE (p_header_id => l_header_id,

Line 8975: l_fnd_err_msg := FND_MESSAGE.GET;

8971:
8972: IF (SQL%ROWCOUNT > 0) THEN
8973: FND_MESSAGE.SET_NAME('WSM', 'WSM_PENDING_TXN');
8974: FND_MESSAGE.SET_TOKEN('TABLE', 'wip_move_transaction_interface');
8975: l_fnd_err_msg := FND_MESSAGE.GET;
8976: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): '||l_fnd_err_msg);
8977:
8978: WSMPUTIL.AUTONOMOUS_WRITE_TO_WIE (p_header_id => l_header_id,
8979: p_message => substr(l_fnd_err_msg,1,2000),

Line 9037: FND_MESSAGE.SET_NAME('WSM', 'WSM_PENDING_TXN');

9033: ||l_header_id
9034: ||' set to ERROR in WSMTI ');
9035:
9036: IF (SQL%ROWCOUNT > 0) THEN
9037: FND_MESSAGE.SET_NAME('WSM', 'WSM_PENDING_TXN');
9038: FND_MESSAGE.SET_TOKEN('TABLE', 'wsm_split_merge_transactions');
9039: l_fnd_err_msg := FND_MESSAGE.GET;
9040: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): '||l_fnd_err_msg);
9041:

Line 9038: FND_MESSAGE.SET_TOKEN('TABLE', 'wsm_split_merge_transactions');

9034: ||' set to ERROR in WSMTI ');
9035:
9036: IF (SQL%ROWCOUNT > 0) THEN
9037: FND_MESSAGE.SET_NAME('WSM', 'WSM_PENDING_TXN');
9038: FND_MESSAGE.SET_TOKEN('TABLE', 'wsm_split_merge_transactions');
9039: l_fnd_err_msg := FND_MESSAGE.GET;
9040: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): '||l_fnd_err_msg);
9041:
9042: WSMPUTIL.AUTONOMOUS_WRITE_TO_WIE (p_header_id => l_header_id,

Line 9039: l_fnd_err_msg := FND_MESSAGE.GET;

9035:
9036: IF (SQL%ROWCOUNT > 0) THEN
9037: FND_MESSAGE.SET_NAME('WSM', 'WSM_PENDING_TXN');
9038: FND_MESSAGE.SET_TOKEN('TABLE', 'wsm_split_merge_transactions');
9039: l_fnd_err_msg := FND_MESSAGE.GET;
9040: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): '||l_fnd_err_msg);
9041:
9042: WSMPUTIL.AUTONOMOUS_WRITE_TO_WIE (p_header_id => l_header_id,
9043: p_message => substr(l_fnd_err_msg,1,2000),

Line 9101: FND_MESSAGE.SET_NAME('WSM', 'WSM_PENDING_TXN');

9097: ||l_header_id
9098: ||' set to ERROR in WSMTI ');
9099:
9100: IF (SQL%ROWCOUNT > 0) THEN
9101: FND_MESSAGE.SET_NAME('WSM', 'WSM_PENDING_TXN');
9102: FND_MESSAGE.SET_TOKEN('TABLE', 'wsm_lot_move_txn_interface');
9103: l_fnd_err_msg := FND_MESSAGE.GET;
9104: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): '||l_fnd_err_msg);
9105:

Line 9102: FND_MESSAGE.SET_TOKEN('TABLE', 'wsm_lot_move_txn_interface');

9098: ||' set to ERROR in WSMTI ');
9099:
9100: IF (SQL%ROWCOUNT > 0) THEN
9101: FND_MESSAGE.SET_NAME('WSM', 'WSM_PENDING_TXN');
9102: FND_MESSAGE.SET_TOKEN('TABLE', 'wsm_lot_move_txn_interface');
9103: l_fnd_err_msg := FND_MESSAGE.GET;
9104: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): '||l_fnd_err_msg);
9105:
9106: WSMPUTIL.AUTONOMOUS_WRITE_TO_WIE (p_header_id => l_header_id,

Line 9103: l_fnd_err_msg := FND_MESSAGE.GET;

9099:
9100: IF (SQL%ROWCOUNT > 0) THEN
9101: FND_MESSAGE.SET_NAME('WSM', 'WSM_PENDING_TXN');
9102: FND_MESSAGE.SET_TOKEN('TABLE', 'wsm_lot_move_txn_interface');
9103: l_fnd_err_msg := FND_MESSAGE.GET;
9104: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): '||l_fnd_err_msg);
9105:
9106: WSMPUTIL.AUTONOMOUS_WRITE_TO_WIE (p_header_id => l_header_id,
9107: p_message => substr(l_fnd_err_msg,1,2000),

Line 9146: FND_MESSAGE.SET_NAME('WSM', 'WSM_INVALID_FIELD');

9142: wrji.net_quantity > wrji.start_quantity ); --bugfix 2168797: replaced AND with OR
9143:
9144:
9145: IF (SQL%ROWCOUNT > 0) THEN
9146: FND_MESSAGE.SET_NAME('WSM', 'WSM_INVALID_FIELD');
9147: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'net_quantity in Resulting Jobs');
9148: l_fnd_err_msg := FND_MESSAGE.GET;
9149: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): '||l_fnd_err_msg);
9150:

Line 9147: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'net_quantity in Resulting Jobs');

9143:
9144:
9145: IF (SQL%ROWCOUNT > 0) THEN
9146: FND_MESSAGE.SET_NAME('WSM', 'WSM_INVALID_FIELD');
9147: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'net_quantity in Resulting Jobs');
9148: l_fnd_err_msg := FND_MESSAGE.GET;
9149: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): '||l_fnd_err_msg);
9150:
9151: WSMPUTIL.AUTONOMOUS_WRITE_TO_WIE (p_header_id => l_header_id,

Line 9148: l_fnd_err_msg := FND_MESSAGE.GET;

9144:
9145: IF (SQL%ROWCOUNT > 0) THEN
9146: FND_MESSAGE.SET_NAME('WSM', 'WSM_INVALID_FIELD');
9147: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'net_quantity in Resulting Jobs');
9148: l_fnd_err_msg := FND_MESSAGE.GET;
9149: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): '||l_fnd_err_msg);
9150:
9151: WSMPUTIL.AUTONOMOUS_WRITE_TO_WIE (p_header_id => l_header_id,
9152: p_message => substr(l_fnd_err_msg,1,2000),

Line 9196: FND_MESSAGE.SET_NAME('WSM', 'WSM_NULL_FIELD');

9192: AND wrji.rowid = l_wrji_rowid;
9193: -- End : Changes for bug #3421662--
9194:
9195: IF (l_wrji_starting_op_seq_num = -1) AND (l_wrji_starting_op_code IS NULL) THEN
9196: FND_MESSAGE.SET_NAME('WSM', 'WSM_NULL_FIELD');
9197: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'Starting Operation Seq Num / Code in Resulting jobs');
9198: l_fnd_err_msg := FND_MESSAGE.GET;
9199: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): '||l_fnd_err_msg);
9200:

Line 9197: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'Starting Operation Seq Num / Code in Resulting jobs');

9193: -- End : Changes for bug #3421662--
9194:
9195: IF (l_wrji_starting_op_seq_num = -1) AND (l_wrji_starting_op_code IS NULL) THEN
9196: FND_MESSAGE.SET_NAME('WSM', 'WSM_NULL_FIELD');
9197: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'Starting Operation Seq Num / Code in Resulting jobs');
9198: l_fnd_err_msg := FND_MESSAGE.GET;
9199: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): '||l_fnd_err_msg);
9200:
9201: set_wrji_error(); -- WLTEnh

Line 9198: l_fnd_err_msg := FND_MESSAGE.GET;

9194:
9195: IF (l_wrji_starting_op_seq_num = -1) AND (l_wrji_starting_op_code IS NULL) THEN
9196: FND_MESSAGE.SET_NAME('WSM', 'WSM_NULL_FIELD');
9197: FND_MESSAGE.SET_TOKEN('FLD_NAME', 'Starting Operation Seq Num / Code in Resulting jobs');
9198: l_fnd_err_msg := FND_MESSAGE.GET;
9199: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): '||l_fnd_err_msg);
9200:
9201: set_wrji_error(); -- WLTEnh
9202:

Line 9226: FND_MESSAGE.SET_NAME('WSM', 'WSM_ERR_IN_START_LOT');

9222:
9223: --End: Additions for APS-WLT--
9224:
9225:
9226: FND_MESSAGE.SET_NAME('WSM', 'WSM_ERR_IN_START_LOT');
9227: l_fnd_err_msg := FND_MESSAGE.GET;
9228:
9229: l_stmt_num := 263;
9230: UPDATE wsm_split_merge_txn_interface

Line 9227: l_fnd_err_msg := FND_MESSAGE.GET;

9223: --End: Additions for APS-WLT--
9224:
9225:
9226: FND_MESSAGE.SET_NAME('WSM', 'WSM_ERR_IN_START_LOT');
9227: l_fnd_err_msg := FND_MESSAGE.GET;
9228:
9229: l_stmt_num := 263;
9230: UPDATE wsm_split_merge_txn_interface
9231: SET error_message = l_fnd_err_msg -- error_message = error_message || l_fnd_err_msg

Line 9239: FND_MESSAGE.SET_NAME('WSM', 'WSM_ERR_IN_RESULT_LOT');

9235: WHERE error_message IS NOT NULL)
9236: AND process_status = WIP_CONSTANTS.RUNNING;
9237:
9238:
9239: FND_MESSAGE.SET_NAME('WSM', 'WSM_ERR_IN_RESULT_LOT');
9240: l_fnd_err_msg := FND_MESSAGE.GET;
9241:
9242: l_stmt_num := 264;
9243: UPDATE wsm_split_merge_txn_interface

Line 9240: l_fnd_err_msg := FND_MESSAGE.GET;

9236: AND process_status = WIP_CONSTANTS.RUNNING;
9237:
9238:
9239: FND_MESSAGE.SET_NAME('WSM', 'WSM_ERR_IN_RESULT_LOT');
9240: l_fnd_err_msg := FND_MESSAGE.GET;
9241:
9242: l_stmt_num := 264;
9243: UPDATE wsm_split_merge_txn_interface
9244: SET error_message = l_fnd_err_msg -- error_message = error_message || l_fnd_err_msg