[Home] [Help]
283: raise failed_get_class_code;
284: END IF;
285:
286: IF (l_debug = 'Y') THEN
287: FND_FILE.PUT_LINE(FND_FILE.LOG,'WSMPVLDT.POPULATE_COLUMNS('||l_stmt_num||
288: '): l_class_code from GET_DEF_ACCT_CLASS_CODE='||l_class_code);
289: END IF;
290:
291: IF (l_class_code IS NOT NULL ) THEN
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,
336: p_message => substr(l_fnd_err_msg,1,2000),
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),
388: p_request_id => fnd_global.conc_request_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,
438: p_program_id => fnd_global.conc_program_id,
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: /*-------------------------------------------------------------------+
490: | For Non-Standard Lot Based Jobs : |
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),
524: p_request_id => fnd_global.conc_request_id,
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);
558:
559: End If;
560:
561: WSMPUTIL.AUTONOMOUS_WRITE_TO_WIE (p_header_id => C_NONSTD_NO_CLASS_CODE_RJ_rec.header_id,
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);
679: End If;
680:
681: WSMPUTIL.AUTONOMOUS_WRITE_TO_WIE (
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||
727: '): '||l_fnd_err_msg);
728: End If;
729:
730: WSMPUTIL.AUTONOMOUS_WRITE_TO_WIE (
757: END IF;
758: END LOOP;
759:
760: if l_debug = 'Y' then
761: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.POPULATE_COLUMNS('||l_stmt_num||
762: ', l_quantity_scrapped: '||l_quantity_scrapped||
763: ', total_potential_supply: '||total_potential_supply);
764: end if;
765:
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;
788:
789: WSMPUTIL.AUTONOMOUS_WRITE_TO_WIE (
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||
823: '): '||l_fnd_err_msg);
824: End If;
825:
826: WSMPUTIL.AUTONOMOUS_WRITE_TO_WIE (
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;
873:
874: WSMPUTIL.AUTONOMOUS_WRITE_TO_WIE (
875: p_header_id => c_coproducts_supply_rec.header_id,
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:
916: --VJ: Start Additions for NSLBJ--
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:
942: --VJ: End Additions for NSLBJ--
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:
976: /*---------------------------------------------------------------+
978: +---------------------------------------------------------------*/
979:
980: l_stmt_num := 23;
981: IF (l_debug = 'Y') THEN
982: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.POPULATE_COLUMNS('||l_stmt_num||
983: '): B4 updating completion_subinventory and completion_locator_id');
984: END IF;
985:
986: l_stmt_num := 24;
1032: l_temp_loc_id;
1033: --VJ: End Changes for NSLBJ--
1034:
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');
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;
1046: /* ST bugfix 3336844 comment out check for locator control with MSI. populate locator_id from BOR regardless
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:
1092: -- CZH.BUG2398718, added code to check locator_type,
1130: INTO l_temp_csi,
1131: l_temp_loc_id;
1132:
1133: IF (SQL%ROWCOUNT > 0) and l_debug = 'Y' THEN
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');
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;
1145: IF (l_err_occurred = 1) THEN
1150:
1151: p_err_num := 0;
1152: p_err_msg := 'WSMPVLDT.POPULATE_COLUMNS: Returned Success';
1153: IF (l_debug = 'Y') THEN
1154: FND_FILE.PUT_LINE(FND_FILE.LOG, p_err_msg);
1155: END IF;
1156:
1157: EXCEPTION
1158: WHEN e_proc_error THEN
1157: EXCEPTION
1158: WHEN e_proc_error THEN
1159: p_err_num := 1;
1160: p_err_msg := 'WSMPVLDT.POPULATE_COLUMNS('||l_stmt_num||'): Error';
1161: FND_FILE.PUT_LINE(FND_FILE.LOG, p_err_msg);
1162:
1163: WHEN failed_get_class_code THEN
1164: p_err_msg := 'WSMPVLDT.POPULATE_COLUMNS('||l_stmt_num||');'|| p_err_msg;
1165: FND_FILE.PUT_LINE(FND_FILE.LOG, 'failed_get_class_code error-'||p_err_msg);
1161: FND_FILE.PUT_LINE(FND_FILE.LOG, p_err_msg);
1162:
1163: WHEN failed_get_class_code THEN
1164: p_err_msg := 'WSMPVLDT.POPULATE_COLUMNS('||l_stmt_num||');'|| p_err_msg;
1165: FND_FILE.PUT_LINE(FND_FILE.LOG, 'failed_get_class_code error-'||p_err_msg);
1166:
1167: WHEN others THEN
1168:
1169: p_err_num := SQLCODE;
1167: WHEN others THEN
1168:
1169: p_err_num := SQLCODE;
1170: p_err_msg := 'WSMPVLDT.POPULATE_COLUMNS('||l_stmt_num||');'|| SUBSTR(SQLERRM,1,1000);
1171: FND_FILE.PUT_LINE(FND_FILE.LOG, p_err_msg);
1172:
1173: END POPULATE_COLUMNS;
1174:
1175: /*EA WLTEnh */
1521:
1522: p_err_num := 0;
1523:
1524: IF (l_debug = 'Y') THEN
1525: FND_FILE.PUT_LINE(FND_FILE.LOG,
1526: 'WSMPVLDT.VALIDATE_RECORDS(START): WSMPLOAD.G_HEADER_ID='||WSMPLOAD.G_HEADER_ID);
1527: fnd_file.put_line(fnd_file.log, 'WSMPVLDT.VALIDATE_RECORDS:Start Time:'
1528: ||to_char(SYSDATE, 'DD-MON-YYYY HH24:MI:SS'));
1529:
1523:
1524: IF (l_debug = 'Y') THEN
1525: FND_FILE.PUT_LINE(FND_FILE.LOG,
1526: 'WSMPVLDT.VALIDATE_RECORDS(START): WSMPLOAD.G_HEADER_ID='||WSMPLOAD.G_HEADER_ID);
1527: fnd_file.put_line(fnd_file.log, 'WSMPVLDT.VALIDATE_RECORDS:Start Time:'
1528: ||to_char(SYSDATE, 'DD-MON-YYYY HH24:MI:SS'));
1529:
1530: END IF;
1531:
1548:
1549: EXIT WHEN C_WSMTI%NOTFOUND;
1550:
1551: IF (l_debug = 'Y') THEN
1552: FND_FILE.PUT_LINE(FND_FILE.LOG,
1553: 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): Processing WSMTI header_id='||l_header_id);
1554: END IF;
1555:
1556: ----------- Start of WSMTI Validations - Inside cursor C_WSMTI ------------
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:
1587:
1588: WSMPUTIL.AUTONOMOUS_WRITE_TO_WIE (p_header_id => l_cur_wsmti_rec.header_id,
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),
1637: p_request_id => fnd_global.conc_request_id,
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),
1711: p_request_id => fnd_global.conc_request_id,
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),
1755: p_request_id => fnd_global.conc_request_id,
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),
1797: p_request_id => fnd_global.conc_request_id,
1817: SET wsmti.error_message = l_fnd_generic_err_msg
1818: , wsmti.process_status = WIP_CONSTANTS.ERROR
1819: WHERE wsmti.rowid = l_cur_wsmti_rec.rowid;
1820:
1821: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('
1822: ||l_stmt_num||'): '
1823: ||'Record for Header Id '
1824: ||l_cur_wsmti_rec.header_id
1825: ||' set to ERROR in WSMTI.');
1832: SET wsji.error_message = l_fnd_generic_err_msg
1833: , wsji.process_status = WIP_CONSTANTS.ERROR
1834: Where wsji.header_id = l_cur_wsmti_rec.header_id;
1835:
1836: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('
1837: ||l_stmt_num||'): '
1838: ||'Record for Header Id '
1839: ||l_cur_wsmti_rec.header_id
1840: ||' set to ERROR in WSJI for NON-BONUS Transaction.');
1847: Set wrji.error_message = l_fnd_generic_err_msg
1848: , wrji.process_status = WIP_CONSTANTS.ERROR
1849: Where wrji.header_id = l_cur_wsmti_rec.header_id;
1850:
1851: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('
1852: ||l_stmt_num||'): '
1853: ||'Record for Header Id '
1854: ||l_cur_wsmti_rec.header_id
1855: ||' set to ERROR in WRJI.');
1887:
1888: EXIT WHEN C_WSJI%NOTFOUND;
1889:
1890: IF (l_debug = 'Y') THEN
1891: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('
1892: ||l_stmt_num||'): Processing WSJI header_id='||l_header_id);
1893: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('
1894: ||l_stmt_num||'): l_cur_wsji_rec Record'
1895: ||'; wsji_header_id='||l_cur_wsji_rec.wsji_header_id
1889:
1890: IF (l_debug = 'Y') THEN
1891: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('
1892: ||l_stmt_num||'): Processing WSJI header_id='||l_header_id);
1893: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('
1894: ||l_stmt_num||'): l_cur_wsji_rec Record'
1895: ||'; wsji_header_id='||l_cur_wsji_rec.wsji_header_id
1896: ||'; wip_entity_id='||l_cur_wsji_rec.wip_entity_id
1897: ||'; routing_seq_id='||l_cur_wsji_rec.routing_seq_id
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),
1941: p_request_id => fnd_global.conc_request_id,
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);
1988: End If;
1989:
1990: WSMPUTIL.AUTONOMOUS_WRITE_TO_WIE (
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),
2035: p_request_id => fnd_global.conc_request_id,
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),
2086: p_request_id => fnd_global.conc_request_id,
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),
2106: p_request_id => fnd_global.conc_request_id,
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;
2150:
2151: WSMPUTIL.AUTONOMOUS_WRITE_TO_WIE (
2152: p_header_id => l_header_id,
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;
2215:
2216: WSMPUTIL.AUTONOMOUS_WRITE_TO_WIE (
2217: p_header_id => l_header_id,
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,
2243: p_message => substr(l_fnd_err_msg,1,2000),
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:
2286: WSMPUTIL.AUTONOMOUS_WRITE_TO_WIE (
2287: p_header_id => l_header_id,
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),
2313: p_request_id => fnd_global.conc_request_id,
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),
2347: p_request_id => fnd_global.conc_request_id,
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),
2389: p_request_id => fnd_global.conc_request_id,
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),
2430: p_request_id => fnd_global.conc_request_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),
2469: p_request_id => fnd_global.conc_request_id,
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),
2514: p_request_id => fnd_global.conc_request_id,
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),
2558: p_request_id => fnd_global.conc_request_id,
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),
2622: p_request_id => fnd_global.conc_request_id,
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),
2680: p_request_id => fnd_global.conc_request_id,
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;
2732: WSMPUTIL.AUTONOMOUS_WRITE_TO_WIE (p_header_id => l_header_id,
2733: p_message => substr(l_fnd_err_msg,1,2000),
2813: end if;
2814:
2815: If l_debug = 'Y' Then
2816:
2817: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('
2818: ||l_stmt_num
2819: ||'): l_cur_wsji_rec.wip_entity_id:'||l_cur_wsji_rec.wip_entity_id
2820: ||', l_cur_wsji_rec.routing_seq_id:'||l_cur_wsji_rec.routing_seq_id
2821: ||', l_cur_wsji_rec.primary_item_id:'||l_cur_wsji_rec.primary_item_id
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),
2850: p_request_id => fnd_global.conc_request_id,
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),
2901: p_request_id => fnd_global.conc_request_id,
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:
2953: WSMPUTIL.AUTONOMOUS_WRITE_TO_WIE (
2954: p_header_id => l_header_id,
2967: -- Bug#2099775 added to handle too_many_rows when at a Repeated stdoperation.
2968: when too_many_rows Then
2969:
2970: IF (l_debug = 'Y') THEN
2971: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('
2972: ||l_stmt_num||') Standard Operation Id ' ||
2973: l_merge_std_op_id || ' Repeats. Valid for Merge;' );
2974: END IF;
2975: null;
2980: set_wsji_error();
2981:
2982: l_fnd_err_msg := SQLERRM;
2983: l_error_num := l_stmt_num;
2984: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): '||l_fnd_err_msg);
2985:
2986: --Start Additions to fix bug #2265237--
2987: --Whenever there's error, error_message column in interface table should be updated.
2988: l_stmt_num := 51;
3072: Where wsji.rowid = l_cur_wsji_rec.wsji_rowid
3073: and l_wsji_error_flag <> 1;
3074:
3075: If SQL%ROWCOUNT > 0 and l_debug = 'Y' THEN
3076: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('
3077: ||l_stmt_num||'): '|| ' Populated WSJI for modified columns.');
3078: End If;
3079:
3080: If l_wsji_error_flag = 1 Then -- Only a Single UPDATE on WSMTI
3085: SET wsji.error_message = l_fnd_generic_err_msg
3086: , wsji.process_status = WIP_CONSTANTS.ERROR
3087: WHERE wsji.rowid = l_cur_wsji_rec.wsji_rowid;
3088:
3089: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('
3090: ||l_stmt_num||'): '
3091: ||'Record for Header Id '
3092: ||l_cur_wsji_rec.wsji_header_id
3093: ||' set to ERROR in WSJI.');
3097: Set wrji.error_message = l_fnd_generic_err_msg
3098: , wrji.process_status = WIP_CONSTANTS.ERROR
3099: Where wrji.header_id = l_cur_wsji_rec.wsji_header_id;
3100:
3101: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('
3102: ||l_stmt_num||'): '
3103: ||'Record for Header Id '
3104: ||l_cur_wsji_rec.wsji_header_id
3105: ||' set to ERROR in WRJI.');
3109: SET wsmti.error_message = l_fnd_generic_err_msg
3110: , wsmti.process_status = WIP_CONSTANTS.ERROR
3111: Where wsmti.header_id = l_cur_wsji_rec.wsji_header_id;
3112:
3113: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('
3114: ||l_stmt_num||'): '
3115: ||'Record for Header Id '
3116: ||l_cur_wsji_rec.wsji_header_id
3117: ||' set to ERROR in WSMTI.');
3182:
3183: l_stmt_num := 59;
3184:
3185: IF (l_debug = 'Y') THEN
3186: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): Processing WRJI header_id='||l_header_id);
3187: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_wrji_rtg_seq_id='||l_wrji_rtg_seq_id||
3188: ', l_wrji_alt_rtg_desig='||l_wrji_alt_rtg_desig||
3189: ', l_wrji_bom_seq_id='||l_wrji_bom_seq_id||
3190: ', l_wrji_alt_bom_desig='||l_wrji_alt_bom_desig||
3183: l_stmt_num := 59;
3184:
3185: IF (l_debug = 'Y') THEN
3186: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): Processing WRJI header_id='||l_header_id);
3187: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_wrji_rtg_seq_id='||l_wrji_rtg_seq_id||
3188: ', l_wrji_alt_rtg_desig='||l_wrji_alt_rtg_desig||
3189: ', l_wrji_bom_seq_id='||l_wrji_bom_seq_id||
3190: ', l_wrji_alt_bom_desig='||l_wrji_alt_bom_desig||
3191: ', l_txn_type='||l_txn_type||
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),
3267: p_request_id => fnd_global.conc_request_id,
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),
3310: p_request_id => fnd_global.conc_request_id,
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);
3337: End If;
3338:
3339: WSMPUTIL.AUTONOMOUS_WRITE_TO_WIE (p_header_id => l_header_id,
3372: and wsji.wip_entity_id is NULL)
3373: );
3374:
3375: If l_debug = 'Y' Then
3376: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('
3377: ||l_stmt_num||'): Min Job Type: '||
3378: l_min_job_type || ', Max Job Type: '||l_max_job_type);
3379: End If;
3380:
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;
3397:
3398: WSMPUTIL.AUTONOMOUS_WRITE_TO_WIE (p_header_id => l_header_id,
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),
3426: p_request_id => fnd_global.conc_request_id,
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),
3444: p_request_id => fnd_global.conc_request_id,
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);
3481: End If;
3482:
3483: WSMPUTIL.AUTONOMOUS_WRITE_TO_WIE (
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),
3518: p_request_id => fnd_global.conc_request_id,
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),
3551: p_request_id => fnd_global.conc_request_id,
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;
3576:
3577: WSMPUTIL.AUTONOMOUS_WRITE_TO_WIE (
3606: p_err_msg,
3607: p_err_num);
3608:
3609: IF (p_err_num <> 0) THEN
3610: FND_FILE.PUT_LINE(FND_FILE.LOG,'Errored rows in WSJI/WRJI in populate_columns='||SQL%ROWCOUNT);
3611: raise proc_error;
3612: END IF;
3613:
3614: --VJ: End Additions for NSLBJ--
3636: AND wrji.header_id = l_header_id
3637: AND wrji.wip_entity_name = l_we_name;
3638:
3639: IF (l_debug = 'Y') THEN
3640: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): '||
3641: 'l_job_type='||l_job_type||
3642: ', l_organization_id='||l_organization_id||
3643: ', l_net_quantity='||l_net_quantity||
3644: ', l_class_code='||l_class_code||
3669: IF (l_txn_type = WSMPCNST.UPDATE_ROUTING) THEN
3670:
3671: l_stmt_num := 75;
3672: IF (l_debug = 'Y') THEN
3673: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): Processing Upd Routing');
3674: END IF;
3675: l_stmt_num := 76;
3676:
3677: SELECT wdj.bom_reference_id,
3710: WHERE header_id = l_header_id;
3711:
3712: set_wrji_error(); -- WLTEnh
3713: IF (l_debug = 'Y') THEN
3714: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('
3715: ||l_stmt_num||'): '||l_fnd_err_msg);
3716: END IF;
3717:
3718: WSMPUTIL.AUTONOMOUS_WRITE_TO_WIE (p_header_id => l_header_id,
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;
3753: WSMPUTIL.AUTONOMOUS_WRITE_TO_WIE (p_header_id => l_header_id,
3754: p_message => substr(l_fnd_err_msg,1,2000),
3779: WHERE header_id = l_header_id;
3780:
3781: set_wrji_error(); -- WLTEnh
3782: IF (l_debug = 'Y') THEN
3783: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('
3784: ||l_stmt_num||'): '||l_fnd_err_msg);
3785: END IF;
3786:
3787: WSMPUTIL.AUTONOMOUS_WRITE_TO_WIE (p_header_id => l_header_id,
3814:
3815: set_wrji_error(); -- WLTEnh
3816:
3817: IF (l_debug = 'Y') THEN
3818: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('
3819: ||l_stmt_num||'): '||l_fnd_err_msg);
3820: END IF;
3821:
3822: WSMPUTIL.AUTONOMOUS_WRITE_TO_WIE (p_header_id => l_header_id,
3845: -- all bom and routing info should be same as starting (repre) lot
3846: IF (l_txn_type = WSMPCNST.MERGE) THEN
3847: l_stmt_num := 82;
3848: IF (l_debug = 'Y') THEN
3849: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): Processing Merge');
3850: END IF;
3851:
3852: l_stmt_num := 83;
3853:
3870: AND wsji.representative_flag='Y';
3871: ELSE
3872: l_stmt_num := 84;
3873: IF (l_debug = 'Y') THEN
3874: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||
3875: '): Processing Split/Upd Lot Name/Upd Qty');
3876: END IF;
3877:
3878: l_stmt_num := 85;
3895: AND wsji.wip_entity_id = wdj.wip_entity_id;
3896: END IF;
3897:
3898: IF (l_debug = 'Y') THEN
3899: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_st_bom_ref_id='||l_st_bom_ref_id||
3900: ', l_st_alt_bom_desig='||l_st_alt_bom_desig||
3901: ', l_st_bom_seq_id='||l_st_bom_seq_id||
3902: ', l_st_rtg_ref_id='||l_st_rtg_ref_id||
3903: ', l_st_alt_rtg_desig='||l_st_alt_rtg_desig||
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;
3926: WSMPUTIL.AUTONOMOUS_WRITE_TO_WIE (p_header_id => l_header_id,
3927: p_message => substr(l_fnd_err_msg,1,2000),
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;
3960: WSMPUTIL.AUTONOMOUS_WRITE_TO_WIE (p_header_id => l_header_id,
3961: p_message => substr(l_fnd_err_msg,1,2000),
3996: -- 14: Invalid Firm Planned Flag
3997:
3998: l_stmt_num := 88;
3999: IF (l_debug = 'Y') THEN
4000: FND_FILE.PUT_LINE(FND_FILE.LOG,'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): '||
4001: 'l_job_type='||l_job_type||
4002: ' l_primary_item_id='||l_primary_item_id||
4003:
4004: ' l_routing_reference_id='||l_routing_reference_id||
4055: x_err_msg => p_err_msg --OUT param--
4056: );
4057: IF (p_err_num <> 0) THEN
4058:
4059: FND_FILE.PUT_LINE(FND_FILE.LOG,'WSMPUTIL.validate_non_std_references returned error');
4060: l_stmt_num := 89;
4061: UPDATE wsm_resulting_jobs_interface
4062: SET error_message = p_err_msg
4063: where header_id = l_header_id
4064: and rowid = l_wrji_rowid; --SpUA add
4065:
4066: set_wrji_error(); -- WLTEnh
4067:
4068: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): '||p_err_msg);
4069: WSMPUTIL.AUTONOMOUS_WRITE_TO_WIE (p_header_id => l_header_id,
4070: p_message => substr(p_err_msg,1,2000),
4071: p_request_id => fnd_global.conc_request_id,
4072: p_program_id => fnd_global.conc_program_id,
4078: raise proc_error;
4079: END IF;
4080:
4081: ELSE
4082: FND_FILE.PUT_LINE(FND_FILE.LOG,'WSMPUTIL.validate_non_std_references returned success');
4083:
4084: IF (l_wrji_rtg_seq_id = -1 AND l_nsj_routing_seq_id IS NOT NULL) THEN
4085: l_stmt_num := 90;
4086: UPDATE wsm_resulting_jobs_interface
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;
4100: WSMPUTIL.AUTONOMOUS_WRITE_TO_WIE (p_header_id => l_header_id,
4101: p_message => substr(l_fnd_err_msg,1,2000),
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;
4128: WSMPUTIL.AUTONOMOUS_WRITE_TO_WIE (p_header_id => l_header_id,
4129: p_message => substr(l_fnd_err_msg,1,2000),
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;
4155: WSMPUTIL.AUTONOMOUS_WRITE_TO_WIE (p_header_id => l_header_id,
4156: p_message => substr(l_fnd_err_msg,1,2000),
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),
4184: p_request_id => fnd_global.conc_request_id,
4222: p_err_msg,
4223: p_err_num);
4224:
4225: IF (p_err_num <> 0) THEN
4226: FND_FILE.PUT_LINE(FND_FILE.LOG,'Errored rows in WSJI/WRJI in populate_columns='||SQL%ROWCOUNT);
4227: raise proc_error;
4228: END IF;
4229:
4230: l_stmt_num := 95;
4246: AND wrji.header_id = l_header_id
4247: AND wrji.wip_entity_name = l_we_name;
4248:
4249: IF (l_debug = 'Y') THEN
4250: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): '||
4251: 'l_job_type='||l_job_type||
4252: ', l_organization_id='||l_organization_id||
4253: ', l_net_quantity='||l_net_quantity||
4254: ', l_class_code='||l_class_code||
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),
4287: p_request_id => fnd_global.conc_request_id,
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),
4319: p_request_id => fnd_global.conc_request_id,
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;
4370:
4371: WSMPUTIL.AUTONOMOUS_WRITE_TO_WIE (
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;
4415:
4416: WSMPUTIL.AUTONOMOUS_WRITE_TO_WIE (
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),
4458: p_request_id => fnd_global.conc_request_id,
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),
4493: p_request_id => fnd_global.conc_request_id,
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),
4530: p_request_id => fnd_global.conc_request_id,
4550: l_stmt_num := 105;
4551: --VJ: Start Changes for NSLBJ--
4552: --Changed the sql since org_id has been added to WRJI now--
4553: If l_debug = 'Y' Then
4554: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('
4555: ||l_stmt_num
4556: ||'): l_header_id='||l_header_id
4557: ||'; WSMPLOAD.G_HEADER_ID='||WSMPLOAD.G_HEADER_ID);
4558: End If;
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),
4588: p_request_id => fnd_global.conc_request_id,
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),
4643: p_request_id => fnd_global.conc_request_id,
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),
4674: p_request_id => fnd_global.conc_request_id,
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),
4712: p_request_id => fnd_global.conc_request_id,
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),
4767: p_request_id => fnd_global.conc_request_id,
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),
4820: p_message => substr(l_fnd_err_msg,1,2000),
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),
4872: p_message => substr(l_fnd_err_msg,1,2000),
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),
4916: p_request_id => fnd_global.conc_request_id,
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),
4969: p_request_id => fnd_global.conc_request_id,
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),
5011: p_request_id => fnd_global.conc_request_id,
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;
5051: WSMPUTIL.AUTONOMOUS_WRITE_TO_WIE (p_header_id => l_header_id,
5052: p_message => substr(l_fnd_err_msg,1,2000),
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;
5092: WSMPUTIL.AUTONOMOUS_WRITE_TO_WIE (p_header_id => l_header_id,
5093: p_message => substr(l_fnd_err_msg,1,2000),
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),
5163: p_request_id => fnd_global.conc_request_id,
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),
5197: p_request_id => fnd_global.conc_request_id,
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,
5225: p_message => substr(l_fnd_err_msg,1,2000),
5226: p_request_id => fnd_global.conc_request_id,
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,
5256: p_message => substr(l_fnd_err_msg,1,2000),
5257: p_request_id => fnd_global.conc_request_id,
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,
5289: p_message => substr(l_fnd_err_msg,1,2000),
5290: p_request_id => fnd_global.conc_request_id,
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,
5331: p_message => substr(l_fnd_err_msg,1,2000),
5332: p_request_id => fnd_global.conc_request_id,
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),
5368: p_request_id => fnd_global.conc_request_id,
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,
5416: p_message => substr(l_fnd_err_msg,1,2000),
5417: p_request_id => fnd_global.conc_request_id,
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),
5438: p_request_id => fnd_global.conc_request_id,
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,
5486: p_message => substr(l_fnd_err_msg,1,2000),
5487: p_request_id => fnd_global.conc_request_id,
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),
5508: p_request_id => fnd_global.conc_request_id,
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:
5584:
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:
5657: -- BA: CZH.I_OED-1
5701: l_item_id := l_routing_reference_id;
5702: END IF;
5703:
5704: If (l_debug = 'Y') Then
5705: FND_FILE.PUT_LINE(FND_FILE.LOG, 'At line# '||l_stmt_num||
5706: ' l_organization_id='||l_organization_id||
5707: ', l_item_id='||l_item_id||
5708: ', l_rtg_rev_date='||l_rtg_rev_date||
5709: ', l_routing_rev='||l_rtg_rev||
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;
5747:
5748: WSMPUTIL.AUTONOMOUS_WRITE_TO_WIE (
5769: -- EA: CZH.I_OED-1
5770:
5771: l_stmt_num := 140;
5772: If (l_debug = 'Y') Then
5773: FND_FILE.PUT_LINE(FND_FILE.LOG, 'At line# '||l_stmt_num||
5774: ' l_organization_id='||l_organization_id||
5775: ', l_item_id='||l_item_id||
5776: ', l_rtg_rev_date='||l_rtg_rev_date||
5777: ', l_routing_rev='||l_rtg_rev||
5828: x_error_code,
5829: x_error_msg);
5830: IF (x_error_code <> 0) THEN
5831: l_fnd_err_msg := x_error_msg;
5832: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('
5833: ||l_stmt_num||'): '||l_fnd_err_msg);
5834:
5835: set_wrji_error(); -- WLTEnh
5836:
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
5881:
5908: IF (x_error_code <> 0) THEN
5909: set_wrji_error(); -- WLTEnh
5910:
5911: l_fnd_err_msg := x_error_msg;
5912: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('
5913: ||l_stmt_num||'): '||l_fnd_err_msg);
5914: WSMPUTIL.AUTONOMOUS_WRITE_TO_WIE (
5915: p_header_id => l_header_id,
5916: p_message => substr(l_fnd_err_msg,1,2000),
5972: l_op_seq_id := -99;
5973: end;
5974:
5975: IF (l_debug = 'Y') THEN
5976: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('
5977: ||l_stmt_num||':) l_op_seq_id = '||l_op_seq_id);
5978: END IF;
5979:
5980: IF ( l_op_seq_id <> -99 ) THEN -- only when the std op id exists in the new routing,
5980: IF ( l_op_seq_id <> -99 ) THEN -- only when the std op id exists in the new routing,
5981: -- we need to check the following
5982: l_stmt_num := 145;
5983: IF (l_debug = 'Y') THEN
5984: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('
5985: ||l_stmt_num||':) l_rtg_seq_id (from DJ)= '||l_rtg_seq_id);
5986: END IF;
5987:
5988: -- Update error message col if user is performing update assembly/routing from "ToMove" of an oprn,
6040: -- End : Fix for bug #3196985 --
6041:
6042: l_stmt_num := 149;
6043: IF (l_debug = 'Y') THEN
6044: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): '
6045: ||'l_bos_stdop_id='||l_bos_stdop_id
6046: ||'l_bos_opseq_num='||l_bos_opseq_num
6047: ||', l_bso_stdop_code='||l_bso_stdop_code);
6048: END IF;
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:
6068: WSMPUTIL.AUTONOMOUS_WRITE_TO_WIE (p_header_id => l_header_id,
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);
6124: END IF;
6125: WSMPUTIL.AUTONOMOUS_WRITE_TO_WIE (
6126: p_header_id => l_header_id,
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;
6187: WSMPUTIL.AUTONOMOUS_WRITE_TO_WIE (
6188: p_header_id => l_header_id,
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:
6260: WSMPUTIL.AUTONOMOUS_WRITE_TO_WIE (p_header_id => l_header_id,
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:
6295: WSMPUTIL.AUTONOMOUS_WRITE_TO_WIE (p_header_id => l_header_id,
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,
6324: p_message => substr(l_fnd_err_msg,1,2000),
6325: p_request_id => fnd_global.conc_request_id,
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,
6355: p_message => substr(l_fnd_err_msg,1,2000),
6356: p_request_id => fnd_global.conc_request_id,
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,
6388: p_message => substr(l_fnd_err_msg,1,2000),
6389: p_request_id => fnd_global.conc_request_id,
6403: /* SpUA: Split and Update Assy is now part of this list */
6404:
6405: l_stmt_num := 160;
6406: If (l_debug = 'Y') Then
6407: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): '||
6408: 'l_bom_seq_id='||l_bom_seq_id||
6409: ', l_wrji_bom_seq_id='||l_wrji_bom_seq_id||
6410: ', l_alt_bom_desig='||l_alt_bom_desig||
6411: ', l_wrji_alt_bom_desig='||l_wrji_alt_bom_desig);
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,
6445: p_message => substr(l_fnd_err_msg,1,2000),
6446: p_request_id => fnd_global.conc_request_id,
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:
6492: WSMPUTIL.AUTONOMOUS_WRITE_TO_WIE (p_header_id => l_header_id,
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,
6552: p_message => substr(l_fnd_err_msg,1,2000),
6553: p_request_id => fnd_global.conc_request_id,
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:
6571: WSMPUTIL.AUTONOMOUS_WRITE_TO_WIE (p_header_id => l_header_id,
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,
6631: p_message => substr(l_fnd_err_msg,1,2000),
6632: p_request_id => fnd_global.conc_request_id,
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:
6650: WSMPUTIL.AUTONOMOUS_WRITE_TO_WIE (p_header_id => l_header_id,
6678: FROM wsm_resulting_jobs_interface
6679: WHERE header_id = l_header_id;
6680:
6681: If (l_debug = 'Y') Then
6682: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): '||
6683: 'l_bom_seq_id='||l_bom_seq_id||
6684: ', l_wrji_bom_seq_id='||l_wrji_bom_seq_id||
6685: ', l_alt_bom_desig='||l_alt_bom_desig||
6686: ', l_wrji_alt_bom_desig='||l_wrji_alt_bom_desig);
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),
6704: p_request_id => fnd_global.conc_request_id,
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:
6753: WSMPUTIL.AUTONOMOUS_WRITE_TO_WIE (p_header_id => l_header_id,
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:
6810: WSMPUTIL.AUTONOMOUS_WRITE_TO_WIE (p_header_id => l_header_id,
6840: l_rev_date := l_rtg_rev_date;
6841: -- EA: CZH.I_OED-1
6842:
6843: If (l_debug = 'Y') Then
6844: FND_FILE.PUT_LINE(FND_FILE.LOG, 'At line# '||l_stmt_num||
6845: ' l_organization_id='||l_organization_id||
6846: ', l_temp='||l_temp||
6847: ', l_rev_date='||l_rev_date||
6848: ', l_routing_rev='||l_routing_rev);
6864:
6865: /* EA 2662639 */
6866:
6867: If (l_debug = 'Y') Then
6868: FND_FILE.PUT_LINE(FND_FILE.LOG, 'At line# '||l_stmt_num||
6869: ' l_organization_id='||l_organization_id||
6870: ', l_temp='||l_temp||
6871: ', l_rev_date='||l_rev_date||
6872: ', l_routing_rev='||l_routing_rev);
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);
6892: End If;
6893:
6894: WSMPUTIL.AUTONOMOUS_WRITE_TO_WIE (p_header_id => l_header_id,
6919: l_bom_revision_date := c_bom_rtg_revision_rec.bom_revision_date;
6920: /*EA WLTEnh*/
6921:
6922: If (l_debug = 'Y') Then
6923: FND_FILE.PUT_LINE(FND_FILE.LOG, 'At line# '||l_stmt_num||
6924: ' l_organization_id='||l_organization_id||
6925: ', l_temp(itemId) ='||l_temp||
6926: ', l_bom_revision_date ='||l_bom_revision_date||
6927: ', l_bom_revision ='||l_bom_revision);
6949: END IF;
6950:
6951:
6952: If (l_debug = 'Y') Then
6953: FND_FILE.PUT_LINE(FND_FILE.LOG, 'At line# '||l_stmt_num||
6954: ' l_organization_id='||l_organization_id||
6955: ', l_temp(itemId) ='||l_temp||
6956: ', l_bom_revision_date ='||l_bom_revision_date||
6957: ', l_bom_revision ='||l_bom_revision);
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;
6978:
6979: WSMPUTIL.AUTONOMOUS_WRITE_TO_WIE (p_header_id => l_header_id,
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:
7036: WSMPUTIL.AUTONOMOUS_WRITE_TO_WIE (p_header_id => l_header_id,
7079: SET error_message = l_fnd_err_msg
7080: WHERE ROWID = chartorowid(REV_REC.X_ROWID);
7081:
7082: IF (SQL%ROWCOUNT > 0) THEN
7083: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): '||l_fnd_err_msg);
7084:
7085: set_wrji_error(); -- WLTEnh
7086:
7087: --WSMPUTIL.AUTONOMOUS_WRITE_TO_WIE (p_header_id => l_temp,
7209: END IF;
7210: --VJ: End Additions for NSLBJ--
7211:
7212: If (l_debug = 'Y') Then
7213: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): '||
7214: 'l_com_rtg_seq_id='||l_com_rtg_seq_id||
7215: ', l_pri_it_id='||l_pri_it_id||
7216: ', l_start_op_seq_num='||l_start_op_seq_num||
7217: ', l_start_op_code='||l_start_op_code||
7249: End If;
7250:
7251: If (l_debug = 'Y') Then
7252:
7253: FND_FILE.PUT_LINE(FND_FILE.LOG,
7254: 'Returned success from WSMPUTIL.operation_is_standard_repeats;'
7255: || ' Job currently at intraoperation Step: '|| l_sj_intraoperation_step
7256: ||'; l_op_is_std: ' || l_op_is_std
7257: || '; l_op_rptd_times '|| l_op_rptd_times);
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;
7325: WSMPUTIL.AUTONOMOUS_WRITE_TO_WIE (
7326: p_header_id => l_header_id,
7380:
7381: BEGIN
7382:
7383: l_stmt_num := 193;
7384: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): '||l_fnd_err_msg);
7385:
7386: UPDATE wsm_resulting_jobs_interface
7387: SET error_message = l_fnd_err_msg
7388: WHERE header_id = l_header_id
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:
7458: WSMPUTIL.AUTONOMOUS_WRITE_TO_WIE (p_header_id => l_header_id,
7505: WHERE txn.header_id = wrji.header_id
7506: AND txn.transaction_type_id = WSMPCNST.BONUS);
7507:
7508: IF (l_debug = 'Y') THEN
7509: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): l_count='||l_count);
7510: END IF;
7511:
7512:
7513: IF (l_count > 0) THEN -- EndIf just before stmt_num = 535 --
7526: WHERE txn.header_id = wrji.header_id
7527: AND txn.transaction_type_id = WSMPCNST.BONUS);
7528:
7529: IF (l_debug = 'Y') THEN
7530: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('
7531: ||l_stmt_num||'): l_start_std_op_id='
7532: ||l_start_std_op_id||', l_start_op_code='
7533: ||l_start_op_code||', l_start_op_seq_num='
7534: ||l_start_op_seq_num);
7552: x_err_msg => p_err_msg);
7553:
7554: IF (p_err_num <> 0) THEN
7555:
7556: FND_FILE.PUT_LINE(FND_FILE.LOG,'WSMPUTIL.find_routing_start returned error');
7557: l_stmt_num := 198;
7558: UPDATE wsm_resulting_jobs_interface
7559: SET error_message = p_err_msg
7560: where header_id = l_header_id;
7558: UPDATE wsm_resulting_jobs_interface
7559: SET error_message = p_err_msg
7560: where header_id = l_header_id;
7561:
7562: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): '||p_err_msg);
7563:
7564: set_wrji_error(); -- WLTEnh
7565:
7566: WSMPUTIL.AUTONOMOUS_WRITE_TO_WIE (p_header_id => l_header_id,
7575: raise proc_error;
7576: END IF;
7577:
7578: ELSE
7579: FND_FILE.PUT_LINE(FND_FILE.LOG,'WSMPUTIL.find_routing_start returned success');
7580: END IF;
7581:
7582: l_stmt_num := 199;
7583: select bos.operation_seq_num,
7598: END IF;
7599:
7600: l_stmt_num := 201;
7601: IF (l_debug = 'Y') THEN
7602: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): '||
7603: 'l_bos_op_seq_num='||l_bos_op_seq_num||
7604: ', l_bos_std_op_id='||l_bos_std_op_id||
7605: ', l_bso_op_code='||l_bso_op_code);
7606: END IF;
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);
7622: End If;
7623:
7624: WSMPUTIL.AUTONOMOUS_WRITE_TO_WIE (p_header_id => l_header_id,
7639:
7640: IF (l_start_op_code IS NOT NULL) THEN
7641:
7642: IF (l_debug = 'Y') THEN
7643: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): starting op_code = '||l_start_op_code);
7644: END IF;
7645:
7646: ---------------
7647: -- 1685779: added begin/end block so that if invalid opcode is passed, it is validated and a proper
7682:
7683: -- If the std oprn is repeated but operation seq num is not populated, error out..
7684: -- Also, if the std oprn code passed is incorrect, error out..
7685: l_fnd_err_msg := ' FAILURE: This operation code does not belong to a std op or this std op is repeated';
7686: fnd_file.put_line(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): '||l_fnd_err_msg);
7687:
7688: l_stmt_num := 204;
7689: UPDATE wsm_resulting_jobs_interface wsji
7690: SET wsji.error_message = l_fnd_generic_err_msg
7782: and wrji.internal_group_id = WSMPLOAD.G_GROUP_ID;
7783: -- EA: BUG 2686319
7784:
7785: IF (l_debug = 'Y') THEN
7786: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num
7787: ||'): l_bos_op_seq_num='||l_bos_op_seq_num||', l_bos_op_seq_id='||l_bos_op_seq_id);
7788: END IF;
7789:
7790: end if;
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.
7803: l_stmt_num := 208;
7826: IF (l_start_op_seq_num IS NULL) OR (l_start_op_seq_num <> l_bos_op_seq_num) THEN
7827:
7828: l_stmt_num := 209;
7829: IF (l_debug = 'Y') THEN
7830: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||
7831: '): l_start_op_seq_num IS NULL or l_start_op_seq_num <> l_bos_op_seq_num');
7832: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||
7833: '): l_start_op_seq_num = '||l_start_op_seq_num||
7834: ' l_bos_op_seq_num = '||l_bos_op_seq_num);
7828: l_stmt_num := 209;
7829: IF (l_debug = 'Y') THEN
7830: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||
7831: '): l_start_op_seq_num IS NULL or l_start_op_seq_num <> l_bos_op_seq_num');
7832: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||
7833: '): l_start_op_seq_num = '||l_start_op_seq_num||
7834: ' l_bos_op_seq_num = '||l_bos_op_seq_num);
7835: END IF;
7836:
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;
7853:
7854: WSMPUTIL.AUTONOMOUS_WRITE_TO_WIE (p_header_id => l_header_id,
7867:
7868: ELSIF (l_start_op_seq_num IS NOT NULL) THEN
7869:
7870: IF (l_debug = 'Y') THEN
7871: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||
7872: '): starting op_seq_num = '||l_start_op_seq_num);
7873: END IF;
7874:
7875:
7913: End If;
7914:
7915: -- EA NSO-WLT
7916: IF (l_debug = 'Y') THEN
7917: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||'): l_bso_op_code='||
7918: l_bso_op_code||', l_bos_op_seq_id='||l_bos_op_seq_id);
7919: END IF;
7920:
7921: exception
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:
7931: WSMPUTIL.AUTONOMOUS_WRITE_TO_WIE (p_header_id => l_header_id,
7944:
7945:
7946: IF (nvl(l_start_op_code, '*') <> nvl(l_bso_op_code, '*')) THEN
7947: IF (l_debug = 'Y') THEN
7948: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||
7949: '): l_start_op_code <> l_bso_op_code');
7950: END IF;
7951:
7952: l_stmt_num := 212;
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;
7969:
7970:
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;
8008:
8009: WSMPUTIL.AUTONOMOUS_WRITE_TO_WIE (p_header_id => l_header_id,
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),
8052: p_request_id => fnd_global.conc_request_id,
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),
8137: p_request_id => fnd_global.conc_request_id,
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),
8182: p_request_id => fnd_global.conc_request_id,
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;
8233:
8234: WSMPUTIL.AUTONOMOUS_WRITE_TO_WIE (p_header_id => l_header_id,
8268: where header_id = l_header_id
8269: and wip_entity_name = l_job_name;
8270:
8271: IF (l_debug = 'Y') THEN
8272: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('||l_stmt_num||
8273: '): l_comp_sub_inv_r='||l_comp_sub_inv_r||', l_comp_loc_id_r='||l_comp_loc_id_r);
8274: END IF;
8275:
8276: -- BA: Bugfix 2169141
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
8289: SET error_message = l_fnd_generic_err_msg
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
8328: where header_id = l_header_id
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
8394: where header_id = l_header_id
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
8437: where header_id = l_header_id
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
8474: where header_id = l_header_id
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);
8507: End If;
8508:
8509: WSMPUTIL.AUTONOMOUS_WRITE_TO_WIE (p_header_id => l_header_id,
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,
8610: p_message => substr(l_fnd_err_msg,1,2000),
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
8634:
8665: , wrji.process_status = WIP_CONSTANTS.ERROR
8666: where wrji.header_id = l_header_id
8667: and wrji.wip_entity_name = NVL(l_job_name, wrji.wip_entity_name);
8668:
8669: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('
8670: ||l_stmt_num||'): '
8671: ||'Record for Header Id '
8672: ||l_header_id
8673: ||' set to ERROR in WRJI.');
8680: SET wsji.error_message = l_fnd_generic_err_msg
8681: , wsji.process_status = WIP_CONSTANTS.ERROR
8682: Where wsji.header_id = l_header_id;
8683:
8684: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('
8685: ||l_stmt_num||'): '
8686: ||'Record for Header Id '
8687: ||l_header_id
8688: ||' set to ERROR in WSJI for Non-BONUS Transaction.');
8695: SET wsmti.error_message = l_fnd_generic_err_msg
8696: , wsmti.process_status = WIP_CONSTANTS.ERROR
8697: Where wsmti.header_id = l_header_id;
8698:
8699: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('
8700: ||l_stmt_num||'): '
8701: ||'Record for Header Id '
8702: ||l_header_id
8703: ||' set to ERROR in WSMTI.');
8721: -- Start : Comments to fix bug #3453139 --
8722: /********************************************
8723:
8724: IF (l_debug = 'Y') THEN
8725: FND_FILE.PUT_LINE(FND_FILE.LOG,'Before check_wmti, check_wlmti of starting lots');
8726: END IF;
8727:
8728: OPEN C_STARTING_JOB;
8729: LOOP fetch C_STARTING_JOB into l_wip_id, l_txn_date, l_txn_id, l_header_id, l_organization_id;
8730: exit when c_starting_job%notfound;
8731: l_stmt_num := 237;
8732: IF (wsmputil.check_wmti(l_wip_id, null, l_txn_date, p_err_num, p_err_msg, l_organization_id) <> 0) THEN
8733:
8734: FND_FILE.PUT_LINE(FND_FILE.LOG,'check_wmti returned error:Pending move txn in this lot');
8735:
8736: l_stmt_num := 238;
8737: UPDATE WSM_STARTING_JOBS_INTERFACE wsji
8738: SET wsji.error_message = l_fnd_generic_err_msg
8739: , wsji.process_status = WIP_CONSTANTS.ERROR
8740: WHERE wsji.header_id = l_header_id
8741: AND wsji.WIP_ENTITY_ID = l_wip_id;
8742:
8743: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('
8744: ||l_stmt_num||'): '
8745: ||'Record for Header Id '
8746: ||l_header_id
8747: ||' set to ERROR in WSJI for wip_entity_id='||l_wip_id);
8751: SET wrji.error_message = l_fnd_generic_err_msg
8752: , wrji.process_status = WIP_CONSTANTS.ERROR
8753: WHERE wrji.header_id = l_header_id;
8754:
8755: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('
8756: ||l_stmt_num||'): '
8757: ||'Record for Header Id '
8758: ||l_header_id
8759: ||' set to ERROR in WRJI ');
8763: SET wsmti.error_message = l_fnd_generic_err_msg
8764: , wsmti.process_status = WIP_CONSTANTS.ERROR
8765: WHERE wsmti.header_id = l_header_id;
8766:
8767: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('
8768: ||l_stmt_num||'): '
8769: ||'Record for Header Id '
8770: ||l_header_id
8771: ||' set to ERROR in WSMTI ');
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),
8781: p_request_id => fnd_global.conc_request_id,
8792: END IF;
8793:
8794: l_stmt_num := 241;
8795: IF (wsmputil.check_wsmt(l_wip_id, null, l_txn_id, l_txn_date, p_err_num, p_err_msg, l_organization_id) <> 0) THEN
8796: FND_FILE.PUT_LINE(FND_FILE.LOG,'check_wsmt returned error:Pending wip lot txns in this lot');
8797:
8798: l_stmt_num := 242;
8799: UPDATE WSM_STARTING_JOBS_INTERFACE wsji
8800: SET wsji.error_message = l_fnd_generic_err_msg
8801: , wsji.process_status = WIP_CONSTANTS.ERROR
8802: WHERE wsji.header_id = l_header_id
8803: AND wsji.WIP_ENTITY_ID = l_wip_id;
8804:
8805: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('
8806: ||l_stmt_num||'): '
8807: ||'Record for Header Id '
8808: ||l_header_id
8809: ||' set to ERROR in WSJI for wip_entity_id='||l_wip_id);
8813: SET wrji.error_message = l_fnd_generic_err_msg
8814: , wrji.process_status = WIP_CONSTANTS.ERROR
8815: WHERE wrji.header_id = l_header_id;
8816:
8817: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('
8818: ||l_stmt_num||'): '
8819: ||'Record for Header Id '
8820: ||l_header_id
8821: ||' set to ERROR in WRJI ');
8825: SET wsmti.error_message = l_fnd_generic_err_msg
8826: , wsmti.process_status = WIP_CONSTANTS.ERROR
8827: WHERE wsmti.header_id = l_header_id;
8828:
8829: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('
8830: ||l_stmt_num||'): '
8831: ||'Record for Header Id '
8832: ||l_header_id
8833: ||' set to ERROR in WSMTI ');
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),
8843: p_request_id => fnd_global.conc_request_id,
8855:
8856: l_stmt_num := 245;
8857: IF (wsmputil.check_wlmti(l_wip_id, null, l_header_id, l_txn_date, p_err_num, p_err_msg, l_organization_id) <> 0) THEN
8858: IF (l_debug = 'Y') THEN
8859: FND_FILE.PUT_LINE(FND_FILE.LOG,'check_wlmti returned error:Pending wip move interface txns in this lot');
8860: END IF;
8861:
8862: l_stmt_num := 246;
8863: UPDATE WSM_STARTING_JOBS_INTERFACE wsji
8865: , wsji.process_status = WIP_CONSTANTS.ERROR
8866: WHERE wsji.header_id = l_header_id
8867: AND wsji.WIP_ENTITY_ID = l_wip_id;
8868:
8869: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('
8870: ||l_stmt_num||'): '
8871: ||'Record for Header Id '
8872: ||l_header_id
8873: ||' set to ERROR in WSJI for wip_entity_id='||l_wip_id);
8877: SET wrji.error_message = l_fnd_generic_err_msg
8878: , wrji.process_status = WIP_CONSTANTS.ERROR
8879: WHERE wrji.header_id = l_header_id;
8880:
8881: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('
8882: ||l_stmt_num||'): '
8883: ||'Record for Header Id '
8884: ||l_header_id
8885: ||' set to ERROR in WRJI ');
8889: SET wsmti.error_message = l_fnd_generic_err_msg
8890: , wsmti.process_status = WIP_CONSTANTS.ERROR
8891: WHERE wsmti.header_id = l_header_id;
8892:
8893: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('
8894: ||l_stmt_num||'): '
8895: ||'Record for Header Id '
8896: ||l_header_id
8897: ||' set to ERROR in WSMTI ');
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),
8907: p_request_id => fnd_global.conc_request_id,
8920: END LOOP;
8921: CLOSE C_STARTING_JOB;
8922:
8923: IF (l_debug = 'Y') THEN
8924: FND_FILE.PUT_LINE(FND_FILE.LOG,'Before check_wmti, check_wlmti of resulting lots');
8925: END IF;
8926:
8927: OPEN C_RESULTING_JOB;
8928: LOOP
8930: EXIT when c_resulting_job%notfound;
8931:
8932: l_stmt_num := 249;
8933: IF (wsmputil.check_wmti(null,l_job_name, l_txn_date, p_err_num, p_err_msg, l_organization_id) <> 0) THEN
8934: FND_FILE.PUT_LINE(FND_FILE.LOG,'check_wmti returned error:Pending move txn in this lot');
8935:
8936: l_stmt_num := 250;
8937: UPDATE WSM_RESULTING_JOBS_INTERFACE wrji
8938: SET wrji.error_message = l_fnd_generic_err_msg
8939: , wrji.process_status = WIP_CONSTANTS.ERROR
8940: WHERE wrji.header_id = l_header_id
8941: AND wrji.WIP_ENTITY_NAME = l_job_name;
8942:
8943: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('
8944: ||l_stmt_num||'): '
8945: ||'Record for Header Id '
8946: ||l_header_id
8947: ||' set to ERROR in WRJI for wip_entity_name='||l_job_name);
8950: SET wsji.error_message = l_fnd_generic_err_msg
8951: , wsji.process_status = WIP_CONSTANTS.ERROR
8952: WHERE wsji.header_id = l_header_id;
8953:
8954: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('
8955: ||l_stmt_num||'): '
8956: ||'Record for Header Id '
8957: ||l_header_id
8958: ||' set to ERROR in WSJI ');
8962: SET wsmti.error_message = l_fnd_generic_err_msg
8963: , wsmti.process_status = WIP_CONSTANTS.ERROR
8964: WHERE wsmti.header_id = l_header_id;
8965:
8966: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('
8967: ||l_stmt_num||'): '
8968: ||'Record for Header Id '
8969: ||l_header_id
8970: ||' set to ERROR in WSMTI ');
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),
8980: p_request_id => fnd_global.conc_request_id,
8992:
8993: l_stmt_num := 253;
8994: IF (wsmputil.check_wsmt(null,l_job_name, l_txn_id, l_txn_date, p_err_num, p_err_msg, l_organization_id) <> 0) THEN
8995: IF (l_debug = 'Y') THEN
8996: FND_FILE.PUT_LINE(FND_FILE.LOG,'check_wsmt returned error:Pending wip lot txns in this lot');
8997: END IF;
8998:
8999: l_stmt_num := 254;
9000: UPDATE WSM_RESULTING_JOBS_INTERFACE wrji
9002: , wrji.process_status = WIP_CONSTANTS.ERROR
9003: WHERE wrji.header_id = l_header_id
9004: AND wrji.WIP_ENTITY_NAME = l_job_name;
9005:
9006: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('
9007: ||l_stmt_num||'): '
9008: ||'Record for Header Id '
9009: ||l_header_id
9010: ||' set to ERROR in WRJI for wip_entity_name='||l_job_name);
9014: SET wsji.error_message = l_fnd_generic_err_msg
9015: , wsji.process_status = WIP_CONSTANTS.ERROR
9016: WHERE wsji.header_id = l_header_id;
9017:
9018: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('
9019: ||l_stmt_num||'): '
9020: ||'Record for Header Id '
9021: ||l_header_id
9022: ||' set to ERROR in WSJI ');
9026: SET wsmti.error_message = l_fnd_generic_err_msg
9027: , wsmti.process_status = WIP_CONSTANTS.ERROR
9028: WHERE wsmti.header_id = l_header_id;
9029:
9030: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('
9031: ||l_stmt_num||'): '
9032: ||'Record for Header Id '
9033: ||l_header_id
9034: ||' set to ERROR in WSMTI ');
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),
9044: p_request_id => fnd_global.conc_request_id,
9056:
9057: l_stmt_num := 257;
9058: IF (wsmputil.check_wlmti(l_wip_id, null, l_header_id, l_txn_date, p_err_num, p_err_msg, l_organization_id) <> 0) THEN
9059: IF (l_debug = 'Y') THEN
9060: FND_FILE.PUT_LINE(FND_FILE.LOG,'check_wlmti returned error:Pending wip move interface txns in this lot');
9061: END IF;
9062:
9063: l_stmt_num := 258;
9064: UPDATE WSM_RESULTING_JOBS_INTERFACE wrji
9066: , wrji.process_status = WIP_CONSTANTS.ERROR
9067: WHERE wrji.header_id = l_header_id
9068: AND wrji.WIP_ENTITY_NAME = l_job_name;
9069:
9070: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('
9071: ||l_stmt_num||'): '
9072: ||'Record for Header Id '
9073: ||l_header_id
9074: ||' set to ERROR in WRJI for wip_entity_name='||l_job_name);
9078: SET wsji.error_message = l_fnd_generic_err_msg
9079: , wsji.process_status = WIP_CONSTANTS.ERROR
9080: WHERE wsji.header_id = l_header_id;
9081:
9082: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('
9083: ||l_stmt_num||'): '
9084: ||'Record for Header Id '
9085: ||l_header_id
9086: ||' set to ERROR in WSJI ');
9090: SET wsmti.error_message = l_fnd_generic_err_msg
9091: , wsmti.process_status = WIP_CONSTANTS.ERROR
9092: WHERE wsmti.header_id = l_header_id;
9093:
9094: FND_FILE.PUT_LINE(FND_FILE.LOG, 'WSMPVLDT.VALIDATE_RECORDS('
9095: ||l_stmt_num||'): '
9096: ||'Record for Header Id '
9097: ||l_header_id
9098: ||' set to ERROR in WSMTI ');
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),
9108: p_request_id => fnd_global.conc_request_id,
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),
9153: p_request_id => fnd_global.conc_request_id,
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:
9203: WSMPUTIL.AUTONOMOUS_WRITE_TO_WIE ( p_header_id => l_header_id,
9277:
9278: If (l_errored_rows = 0) Then
9279: p_err_msg := 'WSMPVLDT.VALIDATE_RECORDS: Passed validation for Header Id: '||WSMPLOAD.G_HEADER_ID;
9280: IF (l_debug = 'Y') THEN
9281: FND_FILE.PUT_LINE(FND_FILE.LOG, p_err_msg);
9282: END IF;
9283: Else
9284: p_err_msg := ('Failed validation for Header Id '||WSMPLOAD.G_HEADER_ID);
9285: p_err_num := l_errored_rows;
9282: END IF;
9283: Else
9284: p_err_msg := ('Failed validation for Header Id '||WSMPLOAD.G_HEADER_ID);
9285: p_err_num := l_errored_rows;
9286: FND_FILE.PUT_LINE(FND_FILE.LOG, p_err_msg);
9287:
9288: End If;
9289:
9290: IF (l_debug = 'Y') THEN
9287:
9288: End If;
9289:
9290: IF (l_debug = 'Y') THEN
9291: fnd_file.put_line(fnd_file.log, 'WSMPVLDT.VALIDATE_RECORDS:End Time:'
9292: ||to_char(SYSDATE, 'DD-MON-YYYY HH24:MI:SS'));
9293: END IF;
9294:
9295: EXCEPTION
9293: END IF;
9294:
9295: EXCEPTION
9296: WHEN proc_error THEN
9297: FND_FILE.PUT_LINE(fnd_file.log, substr('WSMPVLDT.VALIDATE_RECORDS('
9298: || to_char(l_stmt_num)
9299: || '): '
9300: || p_err_msg
9301: , 1, 2000) );
9302:
9303: when others then
9304: p_err_num := SQLCODE;
9305: p_err_msg := 'WSMPVLDT.VALIDATE_RECORDS: ('||to_char(l_stmt_num)||'): '||SUBSTR(SQLERRM,1,1000);
9306: FND_FILE.PUT_LINE(fnd_file.log, p_err_msg);
9307:
9308: END VALIDATE_RECORDS;
9309:
9310:
9330:
9331: WHEN others THEN
9332: p_err_num := SQLCODE;
9333: p_err_msg := SUBSTR(SQLERRM,1,1000);
9334: FND_FILE.PUT_LINE(FND_FILE.LOG, p_err_msg);
9335: END CHECK_MERGE_OP;
9336:
9337:
9338: /*-------------------------------------------------------------+
9352: EXCEPTION
9353: WHEN others THEN
9354: p_err_num := SQLCODE;
9355: p_err_msg := SUBSTR(SQLERRM,1,1000);
9356: FND_FILE.PUT_LINE(FND_FILE.LOG, p_err_msg);
9357:
9358: END CHECK_NUMBER_OF_LOTS;
9359:
9360:
9375: EXCEPTION
9376: WHEN others THEN
9377: p_err_num := SQLCODE;
9378: p_err_msg := SUBSTR(SQLERRM,1,1000);
9379: FND_FILE.PUT_LINE(FND_FILE.LOG, p_err_msg);
9380:
9381: END CHECK_TOTAL_QTY;
9382:
9383:
9401: EXCEPTION
9402: WHEN others THEN
9403: p_err_num := SQLCODE;
9404: p_err_msg := SUBSTR(SQLERRM,1,1000);
9405: FND_FILE.PUT_LINE(FND_FILE.LOG, p_err_msg);
9406:
9407: END MATCH_START_RESULT_LOT;
9408:
9409: