[Home] [Help]
271:
272: FOR c_no_class_code_rj_rec in c_no_class_code_rj(p_header_id) LOOP
273:
274: l_stmt_num := 1;
275: l_class_code := WSMPUTIL.GET_DEF_ACCT_CLASS_CODE(
276: c_no_class_code_rj_rec.org_id,
277: c_no_class_code_rj_rec.item_id,
278: c_no_class_code_rj_rec.subinv_name,
279: p_err_num,
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),
337: p_request_id => fnd_global.conc_request_id,
338: p_program_id => fnd_global.conc_program_id,
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,
389: p_program_id => fnd_global.conc_program_id,
390: p_program_application_id => fnd_global.prog_appl_id,
402:
403: FOR c_vldt_class_code_rj_rec in c_vldt_class_code_rj(p_header_id) LOOP
404: l_stmt_num := 5;
405:
406: if wsmputil.WSM_ESA_ENABLED(p_wip_entity_id => null,
407: err_code => p_err_num,
408: err_msg => p_err_msg,
409: p_org_id => c_vldt_class_code_rj_rec.org_id,
410: p_job_type => c_vldt_class_code_rj_rec.job_type
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,
439: p_program_application_id => fnd_global.prog_appl_id,
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,
525: p_program_id => fnd_global.conc_program_id,
526: p_program_application_id => fnd_global.prog_appl_id,
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,
562: p_message => substr(l_fnd_err_msg,1,2000),
563: p_request_id => fnd_global.conc_request_id,
564: p_program_id => fnd_global.conc_program_id,
565: p_program_application_id => fnd_global.prog_appl_id,
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 (
682: p_header_id => c_net_quantity_rec.header_id,
683: p_message => substr(l_fnd_err_msg,1,2000),
684: p_request_id => fnd_global.conc_request_id,
685: p_program_id => fnd_global.conc_program_id,
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 (
731: p_header_id => c_net_quantity_rec.header_id,
732: p_message => substr(l_fnd_err_msg,1,2000),
733: p_request_id => fnd_global.conc_request_id,
734: p_program_id => fnd_global.conc_program_id,
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 (
790: p_header_id => c_net_quantity_rec.header_id,
791: p_message => substr(l_fnd_err_msg,1,2000),
792: p_request_id => fnd_global.conc_request_id,
793: p_program_id => fnd_global.conc_program_id,
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 (
827: p_header_id => c_net_quantity_rec.header_id,
828: p_message => substr(l_fnd_err_msg,1,2000),
829: p_request_id => fnd_global.conc_request_id,
830: p_program_id => fnd_global.conc_program_id,
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,
876: p_message => substr(l_fnd_err_msg,1,2000),
877: p_request_id => fnd_global.conc_request_id,
878: p_program_id => fnd_global.conc_program_id,
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,
1589: p_message => substr(l_fnd_err_msg,1,2000),
1590: p_request_id => fnd_global.conc_request_id,
1591: p_program_id => fnd_global.conc_program_id,
1592: p_program_application_id => fnd_global.prog_appl_id,
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,
1638: p_program_id => fnd_global.conc_program_id,
1639: p_program_application_id => fnd_global.prog_appl_id,
1654: +-----------------------------------------------------------------*/
1655:
1656: l_stmt_num := 6;
1657:
1658: --Start NL Bugfix 3126650 : Moved acct_period check to WSMPUTIL API
1659:
1660: l_acct_period_id := WSMPUTIL.GET_INV_ACCT_PERIOD(p_err_num, p_err_msg, l_cur_wsmti_rec.organization_id, l_cur_wsmti_rec.transaction_date);
1661: l_fnd_err_msg := p_err_msg;
1662:
1656: l_stmt_num := 6;
1657:
1658: --Start NL Bugfix 3126650 : Moved acct_period check to WSMPUTIL API
1659:
1660: l_acct_period_id := WSMPUTIL.GET_INV_ACCT_PERIOD(p_err_num, p_err_msg, l_cur_wsmti_rec.organization_id, l_cur_wsmti_rec.transaction_date);
1661: l_fnd_err_msg := p_err_msg;
1662:
1663: IF (l_acct_period_id = 0) THEN
1664:
1663: IF (l_acct_period_id = 0) THEN
1664:
1665: set_wsmti_error;
1666:
1667: WSMPUTIL.AUTONOMOUS_WRITE_TO_WIE (p_header_id => l_cur_wsmti_rec.header_id,
1668: p_message => substr(l_fnd_err_msg,1,2000),
1669: p_request_id => fnd_global.conc_request_id,
1670: p_program_id => fnd_global.conc_program_id,
1671: p_program_application_id => fnd_global.prog_appl_id,
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,
1712: p_program_id => fnd_global.conc_program_id,
1713: p_program_application_id => fnd_global.prog_appl_id,
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,
1756: p_program_id => fnd_global.conc_program_id,
1757: p_program_application_id => fnd_global.prog_appl_id,
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,
1798: p_program_id => fnd_global.conc_program_id,
1799: p_program_application_id => fnd_global.prog_appl_id,
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,
1942: p_program_id => fnd_global.conc_program_id,
1943: p_program_application_id => fnd_global.prog_appl_id,
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 (
1991: p_header_id => l_header_id,
1992: p_message => substr(l_fnd_err_msg,1,2000),
1993: p_request_id => fnd_global.conc_request_id,
1994: p_program_id => fnd_global.conc_program_id,
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,
2036: p_program_id => fnd_global.conc_program_id,
2037: p_program_application_id => fnd_global.prog_appl_id,
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,
2087: p_program_id => fnd_global.conc_program_id,
2088: p_program_application_id => fnd_global.prog_appl_id,
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,
2107: p_program_id => fnd_global.conc_program_id,
2108: p_program_application_id => fnd_global.prog_appl_id,
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,
2153: p_message => substr(l_fnd_err_msg,1,2000),
2154: p_request_id => fnd_global.conc_request_id,
2155: p_program_id => fnd_global.conc_program_id,
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,
2218: p_message => substr(l_fnd_err_msg,1,2000),
2219: p_request_id => fnd_global.conc_request_id,
2220: p_program_id => fnd_global.conc_program_id,
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),
2244: p_request_id => fnd_global.conc_request_id,
2245: p_program_id => fnd_global.conc_program_id,
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,
2288: p_message => substr(l_fnd_err_msg,1,2000),
2289: p_request_id => fnd_global.conc_request_id,
2290: p_program_id => fnd_global.conc_program_id,
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,
2314: p_program_id => fnd_global.conc_program_id,
2315: p_program_application_id => fnd_global.prog_appl_id,
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,
2348: p_program_id => fnd_global.conc_program_id,
2349: p_program_application_id => fnd_global.prog_appl_id,
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,
2390: p_program_id => fnd_global.conc_program_id,
2391: p_program_application_id => fnd_global.prog_appl_id,
2409:
2410: -- Start : Additions to fix bug #3512105 --
2411: l_stmt_num := 33.5;
2412:
2413: l_profile_value := WSMPUTIL.CREATE_LBJ_COPY_RTG_PROFILE(l_cur_wsji_rec.organization_id); -- This returns the Profile value
2414:
2415: IF (l_profile_value = 2) THEN -- Option A (Old Behavior)
2416: null;
2417: ELSE -- Option C (New Behavior)
2414:
2415: IF (l_profile_value = 2) THEN -- Option A (Old Behavior)
2416: null;
2417: ELSE -- Option C (New Behavior)
2418: l_int_copy_type := WSMPUTIL.get_internal_copy_type(p_wip_entity_id => l_cur_wsji_rec.wip_entity_id);
2419:
2420: /* ST bug fix 3732580 : check for type 3 */
2421: IF (nvl(l_int_copy_type,0) = 3 /*<> 0*/) THEN -- Incorrect copies
2422: set_wsji_error();
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,
2431: p_program_id => fnd_global.conc_program_id,
2432: p_program_application_id => fnd_global.prog_appl_id,
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,
2470: p_program_id => fnd_global.conc_program_id,
2471: p_program_application_id => fnd_global.prog_appl_id,
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,
2515: p_program_id => fnd_global.conc_program_id,
2516: p_program_application_id => fnd_global.prog_appl_id,
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,
2559: p_program_id => fnd_global.conc_program_id,
2560: p_program_application_id => fnd_global.prog_appl_id,
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,
2623: p_program_id => fnd_global.conc_program_id,
2624: p_program_application_id => fnd_global.prog_appl_id,
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,
2681: p_program_id => fnd_global.conc_program_id,
2682: p_program_application_id => fnd_global.prog_appl_id,
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),
2734: p_request_id => fnd_global.conc_request_id,
2735: p_program_id => fnd_global.conc_program_id,
2736: p_program_application_id => fnd_global.prog_appl_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,
2851: p_program_id => fnd_global.conc_program_id,
2852: p_program_application_id => fnd_global.prog_appl_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,
2902: p_program_id => fnd_global.conc_program_id,
2903: p_program_application_id => fnd_global.prog_appl_id,
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,
2955: p_message => substr(l_fnd_err_msg,1,2000),
2956: p_request_id => fnd_global.conc_request_id,
2957: p_program_id => fnd_global.conc_program_id,
2991: WHERE wsji.header_id = l_header_id;
2992: --End Additions to fix bug #2265237--
2993:
2994:
2995: WSMPUTIL.AUTONOMOUS_WRITE_TO_WIE (
2996: p_header_id => l_header_id,
2997: p_message => substr(l_fnd_err_msg,1,2000),
2998: p_request_id => fnd_global.conc_request_id,
2999: p_program_id => fnd_global.conc_program_id,
3032:
3033: FND_MESSAGE.SET_NAME('WSM', 'WSM_OP_PURCHASE_REQ');
3034: l_fnd_err_msg := FND_MESSAGE.GET;
3035:
3036: WSMPUTIL.AUTONOMOUS_WRITE_TO_WIE (
3037: p_header_id => l_header_id,
3038: p_message => substr(l_fnd_err_msg,1,2000),
3039: p_request_id => fnd_global.conc_request_id,
3040: p_program_id => fnd_global.conc_program_id,
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,
3268: p_program_id => fnd_global.conc_program_id,
3269: p_program_application_id => fnd_global.prog_appl_id,
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,
3311: p_program_id => fnd_global.conc_program_id,
3312: p_program_application_id => fnd_global.prog_appl_id,
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,
3340: p_message => substr(l_fnd_err_msg,1,2000),
3341: p_request_id => fnd_global.conc_request_id,
3342: p_program_id => fnd_global.conc_program_id,
3343: p_program_application_id => fnd_global.prog_appl_id,
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,
3399: p_message => substr(l_fnd_err_msg,1,2000),
3400: p_request_id => fnd_global.conc_request_id,
3401: p_program_id => fnd_global.conc_program_id,
3402: p_program_application_id => fnd_global.prog_appl_id,
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,
3427: p_program_id => fnd_global.conc_program_id,
3428: p_program_application_id => fnd_global.prog_appl_id,
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,
3445: p_program_id => fnd_global.conc_program_id,
3446: p_program_application_id => fnd_global.prog_appl_id,
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 (
3484: p_header_id => l_header_id,
3485: p_message => substr(l_fnd_err_msg,1,2000),
3486: p_request_id => fnd_global.conc_request_id,
3487: p_program_id => fnd_global.conc_program_id,
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,
3519: p_program_id => fnd_global.conc_program_id,
3520: p_program_application_id => fnd_global.prog_appl_id,
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,
3552: p_program_id => fnd_global.conc_program_id,
3553: p_program_application_id => fnd_global.prog_appl_id,
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 (
3578: p_header_id => l_header_id,
3579: p_message => substr(l_fnd_err_msg,1,2000),
3580: p_request_id => fnd_global.conc_request_id,
3581: p_program_id => fnd_global.conc_program_id,
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,
3719: p_message => substr(l_fnd_err_msg,1,2000),
3720: p_request_id => fnd_global.conc_request_id,
3721: p_program_id => fnd_global.conc_program_id,
3722: p_program_application_id => fnd_global.prog_appl_id,
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),
3755: p_request_id => fnd_global.conc_request_id,
3756: p_program_id => fnd_global.conc_program_id,
3757: p_program_application_id => fnd_global.prog_appl_id,
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,
3788: p_message => substr(l_fnd_err_msg,1,2000),
3789: p_request_id => fnd_global.conc_request_id,
3790: p_program_id => fnd_global.conc_program_id,
3791: p_program_application_id => fnd_global.prog_appl_id,
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,
3823: p_message => substr(l_fnd_err_msg,1,2000),
3824: p_request_id => fnd_global.conc_request_id,
3825: p_program_id => fnd_global.conc_program_id,
3826: p_program_application_id => fnd_global.prog_appl_id,
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),
3928: p_request_id => fnd_global.conc_request_id,
3929: p_program_id => fnd_global.conc_program_id,
3930: p_program_application_id => fnd_global.prog_appl_id,
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),
3962: p_request_id => fnd_global.conc_request_id,
3963: p_program_id => fnd_global.conc_program_id,
3964: p_program_application_id => fnd_global.prog_appl_id,
4026: END IF;
4027:
4028: l_firm_flag := '';
4029:
4030: WSMPUTIL.validate_non_std_references(
4031: p_assembly_item_id => l_primary_item_id,
4032: p_routing_reference_id => l_routing_reference_id,
4033: p_bom_reference_id => l_bom_reference_id,
4034: --VJ: CodeRVW: Start Changes for NSLBJ--
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
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,
4073: p_program_application_id => fnd_global.prog_appl_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
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),
4102: p_request_id => fnd_global.conc_request_id,
4103: p_program_id => fnd_global.conc_program_id,
4104: p_program_application_id => fnd_global.prog_appl_id,
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),
4130: p_request_id => fnd_global.conc_request_id,
4131: p_program_id => fnd_global.conc_program_id,
4132: p_program_application_id => fnd_global.prog_appl_id,
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),
4157: p_request_id => fnd_global.conc_request_id,
4158: p_program_id => fnd_global.conc_program_id,
4159: p_program_application_id => fnd_global.prog_appl_id,
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,
4185: p_program_id => fnd_global.conc_program_id,
4186: p_program_application_id => fnd_global.prog_appl_id,
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,
4288: p_program_id => fnd_global.conc_program_id,
4289: p_program_application_id => fnd_global.prog_appl_id,
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,
4320: p_program_id => fnd_global.conc_program_id,
4321: p_program_application_id => fnd_global.prog_appl_id,
4330: --VJ: Start Additions for NSLBJ--
4331: --Moved this piece of code from WSMPPTAB.sm_table to here--
4332: /*--------------------------------------------------------------------+
4333: | If either scheduled start date or scheduled completion date is |
4334: | given, default the other one by calling WSMPUTIL.GET_SCHEDULED_DATE |
4335: +--------------------------------------------------------------------*/
4336:
4337: /* ST bug fix 3493984 : Add a check for the txn type */
4338: IF l_txn_type = WSMPCNST.BONUS THEN
4342: l_stmt_num := 98;
4343: IF (c_null_scheduled_date_rec.scheduled_start_date is not null)
4344: and (c_null_scheduled_date_rec.scheduled_completion_date is null) THEN
4345:
4346: l_sch_completion_date := WSMPUTIL.GET_SCHEDULED_DATE(
4347: p_organization_id => c_null_scheduled_date_rec.org_id,
4348: p_primary_item_id => c_null_scheduled_date_rec.item_id,
4349: p_schedule_method => 'F',
4350: p_input_date => c_null_scheduled_date_rec.scheduled_start_date,
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 (
4372: p_header_id => l_header_id,
4373: p_message => substr(l_fnd_err_msg,1,2000),
4374: p_request_id => fnd_global.conc_request_id,
4375: p_program_id => fnd_global.conc_program_id,
4387: l_stmt_num := 100;
4388: IF (c_null_scheduled_date_rec.scheduled_start_date is null)
4389: and (c_null_scheduled_date_rec.scheduled_completion_date is not null) THEN
4390:
4391: l_sch_start_date := WSMPUTIL.GET_SCHEDULED_DATE(
4392: p_organization_id => c_null_scheduled_date_rec.org_id,
4393: p_primary_item_id => c_null_scheduled_date_rec.item_id,
4394: p_schedule_method => 'B',
4395: p_input_date => c_null_scheduled_date_rec.scheduled_completion_date,
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 (
4417: p_header_id => l_header_id,
4418: p_message => substr(l_fnd_err_msg,1,2000),
4419: p_request_id => fnd_global.conc_request_id,
4420: p_program_id => fnd_global.conc_program_id,
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,
4459: p_program_id => fnd_global.conc_program_id,
4460: p_program_application_id => fnd_global.prog_appl_id,
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,
4494: p_program_id => fnd_global.conc_program_id,
4495: p_program_application_id => fnd_global.prog_appl_id,
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,
4531: p_program_id => fnd_global.conc_program_id,
4532: p_program_application_id => fnd_global.prog_appl_id,
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,
4589: p_program_id => fnd_global.conc_program_id,
4590: p_program_application_id => fnd_global.prog_appl_id,
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,
4644: p_program_id => fnd_global.conc_program_id,
4645: p_program_application_id => fnd_global.prog_appl_id,
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,
4675: p_program_id => fnd_global.conc_program_id,
4676: p_program_application_id => fnd_global.prog_appl_id,
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,
4713: p_program_id => fnd_global.conc_program_id,
4714: p_program_application_id => fnd_global.prog_appl_id,
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,
4768: p_program_id => fnd_global.conc_program_id,
4769: p_program_application_id => fnd_global.prog_appl_id,
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),
4821: p_request_id => fnd_global.conc_request_id,
4822: p_program_id => fnd_global.conc_program_id,
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),
4873: p_request_id => fnd_global.conc_request_id,
4874: p_program_id => fnd_global.conc_program_id,
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,
4917: p_program_id => fnd_global.conc_program_id,
4918: p_program_application_id => fnd_global.prog_appl_id,
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,
4970: p_program_id => fnd_global.conc_program_id,
4971: p_program_application_id => fnd_global.prog_appl_id,
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,
5012: p_program_id => fnd_global.conc_program_id,
5013: p_program_application_id => fnd_global.prog_appl_id,
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),
5053: p_request_id => fnd_global.conc_request_id,
5054: p_program_id => fnd_global.conc_program_id,
5055: p_program_application_id => fnd_global.prog_appl_id,
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),
5094: p_request_id => fnd_global.conc_request_id,
5095: p_program_id => fnd_global.conc_program_id,
5096: p_program_application_id => fnd_global.prog_appl_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,
5164: p_program_id => fnd_global.conc_program_id,
5165: p_program_application_id => fnd_global.prog_appl_id,
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,
5198: p_program_id => fnd_global.conc_program_id,
5199: p_program_application_id => fnd_global.prog_appl_id,
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,
5227: p_program_id => fnd_global.conc_program_id,
5228: p_program_application_id => fnd_global.prog_appl_id,
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,
5258: p_program_id => fnd_global.conc_program_id,
5259: p_program_application_id => fnd_global.prog_appl_id,
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,
5291: p_program_id => fnd_global.conc_program_id,
5292: p_program_application_id => fnd_global.prog_appl_id,
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,
5333: p_program_id => fnd_global.conc_program_id,
5334: p_program_application_id => fnd_global.prog_appl_id,
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,
5369: p_program_id => fnd_global.conc_program_id,
5370: p_program_application_id => fnd_global.prog_appl_id,
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,
5418: p_program_id => fnd_global.conc_program_id,
5419: p_program_application_id => fnd_global.prog_appl_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,
5439: p_program_id => fnd_global.conc_program_id,
5440: p_program_application_id => fnd_global.prog_appl_id,
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,
5488: p_program_id => fnd_global.conc_program_id,
5489: p_program_application_id => fnd_global.prog_appl_id,
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,
5509: p_program_id => fnd_global.conc_program_id,
5510: p_program_application_id => fnd_global.prog_appl_id,
5581:
5582: set_wrji_error(); -- WLTEnh
5583:
5584:
5585: WSMPUTIL.AUTONOMOUS_WRITE_TO_WIE (p_header_id => l_header_id,
5586: p_message => substr(l_fnd_err_msg,1,2000),
5587: p_request_id => fnd_global.conc_request_id,
5588: p_program_id => fnd_global.conc_program_id,
5589: p_program_application_id => fnd_global.prog_appl_id,
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 (
5749: p_header_id => l_header_id,
5750: p_message => substr(l_fnd_err_msg,1,2000),
5751: p_request_id => fnd_global.conc_request_id,
5752: p_program_id => fnd_global.conc_program_id,
5780: End If;
5781:
5782:
5783: --Start: Additions for APS-WLT--
5784: l_profile_value := WSMPUTIL.CREATE_LBJ_COPY_RTG_PROFILE(l_organization_id); -- This returns the Profile value
5785: --End: Additions for APS-WLT--
5786:
5787:
5788: -- begin bugfix 1776002
5820: WHERE header_id = l_header_id and rowid = l_wrji_rowid; -- WLTEnh.
5821:
5822: -- For Bonus, check routing start/end, if disabled error out
5823: IF (l_txn_type = WSMPCNST.BONUS and l_wrji_rtg_seq_id <> -1) THEN -- 4=Bns
5824: WSMPUTIL.find_routing_start (
5825: l_wrji_rtg_seq_id,
5826: l_rtg_rev_date,
5827: l_start_op_seq_id,
5828: x_error_code,
5833: ||l_stmt_num||'): '||l_fnd_err_msg);
5834:
5835: set_wrji_error(); -- WLTEnh
5836:
5837: WSMPUTIL.AUTONOMOUS_WRITE_TO_WIE (
5838: p_header_id => l_header_id,
5839: p_message => substr(l_fnd_err_msg,1,2000),
5840: p_request_id => fnd_global.conc_request_id,
5841: p_program_id => fnd_global.conc_program_id,
5849: END IF;
5850:
5851: -- CZH.I_OED-2, even though x_error_code = 0, here, l_start_op_seq_id is
5852: -- still the one defined in BON, not the replacement, because
5853: -- WSMPUTIL.primary_path_is_effective_till need this
5854:
5855: l_stmt_num := 142;
5856: -- IN WSMFJLTX.fmb, we check if the primary path is effective here,
5857: -- IF starting_operation_seq_num is specified.
5863: -- Check if the primary path is effective
5864: IF(l_wrji_starting_op_seq_num IS NOT NULL
5865: and l_wrji_rtg_seq_id <> -1)
5866: THEN
5867: IF (WSMPUTIL.primary_path_is_effective_till (
5868: l_wrji_rtg_seq_id,
5869: l_rtg_rev_date,
5870: l_start_op_seq_id,
5871: l_wrji_starting_op_seq_num,
5878: ||l_stmt_num||'): '||l_fnd_err_msg);
5879:
5880: set_wrji_error(); -- WLTEnh
5881:
5882: WSMPUTIL.AUTONOMOUS_WRITE_TO_WIE (
5883: p_header_id => l_header_id,
5884: p_message => substr(l_fnd_err_msg,1,2000),
5885: p_request_id => fnd_global.conc_request_id,
5886: p_program_id => fnd_global.conc_program_id,
5897:
5898: l_stmt_num := 143;
5899: -- For ALL transaction check routing end
5900: IF (l_wrji_rtg_seq_id <> -1) THEN
5901: WSMPUTIL.find_routing_end (
5902: l_wrji_rtg_seq_id,
5903: l_rtg_rev_date,
5904: l_end_op_seq_id,
5905: x_error_code,
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),
5917: p_request_id => fnd_global.conc_request_id,
5918: p_program_id => fnd_global.conc_program_id,
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,
6069: p_message => substr(l_fnd_err_msg,1,2000),
6070: p_request_id => fnd_global.conc_request_id,
6071: p_program_id => fnd_global.conc_program_id,
6072: p_program_application_id => fnd_global.prog_appl_id,
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,
6127: p_message => substr(l_fnd_err_msg,1,2000),
6128: p_request_id => fnd_global.conc_request_id,
6129: p_program_id => fnd_global.conc_program_id,
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,
6189: p_message => substr(l_fnd_err_msg,1,2000),
6190: p_request_id => fnd_global.conc_request_id,
6191: p_program_id => fnd_global.conc_program_id,
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,
6261: p_message => substr(l_fnd_err_msg,1,2000),
6262: p_request_id => fnd_global.conc_request_id,
6263: p_program_id => fnd_global.conc_program_id,
6264: p_program_application_id => fnd_global.prog_appl_id,
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,
6296: p_message => substr(l_fnd_err_msg,1,2000),
6297: p_request_id => fnd_global.conc_request_id,
6298: p_program_id => fnd_global.conc_program_id,
6299: p_program_application_id => fnd_global.prog_appl_id,
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,
6326: p_program_id => fnd_global.conc_program_id,
6327: p_program_application_id => fnd_global.prog_appl_id,
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,
6357: p_program_id => fnd_global.conc_program_id,
6358: p_program_application_id => fnd_global.prog_appl_id,
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,
6390: p_program_id => fnd_global.conc_program_id,
6391: p_program_application_id => fnd_global.prog_appl_id,
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,
6447: p_program_id => fnd_global.conc_program_id,
6448: p_program_application_id => fnd_global.prog_appl_id,
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,
6493: p_message => substr(l_fnd_err_msg,1,2000),
6494: p_request_id => fnd_global.conc_request_id,
6495: p_program_id => fnd_global.conc_program_id,
6496: p_program_application_id => fnd_global.prog_appl_id,
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,
6554: p_program_id => fnd_global.conc_program_id,
6555: p_program_application_id => fnd_global.prog_appl_id,
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,
6572: p_message => substr(l_fnd_err_msg,1,2000),
6573: p_request_id => fnd_global.conc_request_id,
6574: p_program_id => fnd_global.conc_program_id,
6575: p_program_application_id => fnd_global.prog_appl_id,
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,
6633: p_program_id => fnd_global.conc_program_id,
6634: p_program_application_id => fnd_global.prog_appl_id,
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,
6651: p_message => substr(l_fnd_err_msg,1,2000),
6652: p_request_id => fnd_global.conc_request_id,
6653: p_program_id => fnd_global.conc_program_id,
6654: p_program_application_id => fnd_global.prog_appl_id,
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,
6705: p_program_id => fnd_global.conc_program_id,
6706: p_program_application_id => fnd_global.prog_appl_id,
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,
6754: p_message => substr(l_fnd_err_msg,1,2000),
6755: p_request_id => fnd_global.conc_request_id,
6756: p_program_id => fnd_global.conc_program_id,
6757: p_program_application_id => fnd_global.prog_appl_id,
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,
6811: p_message => substr(l_fnd_err_msg,1,2000),
6812: p_request_id => fnd_global.conc_request_id,
6813: p_program_id => fnd_global.conc_program_id,
6814: p_program_application_id => fnd_global.prog_appl_id,
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,
6895: p_message => substr(l_fnd_err_msg,1,2000),
6896: p_request_id => fnd_global.conc_request_id,
6897: p_program_id => fnd_global.conc_program_id,
6898: p_program_application_id => fnd_global.prog_appl_id,
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,
6980: p_message => substr(l_fnd_err_msg,1,2000),
6981: p_request_id => fnd_global.conc_request_id,
6982: p_program_id => fnd_global.conc_program_id,
6983: p_program_application_id => fnd_global.prog_appl_id,
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,
7037: p_message => substr(l_fnd_err_msg,1,2000),
7038: p_request_id => fnd_global.conc_request_id,
7039: p_program_id => fnd_global.conc_program_id,
7040: p_program_application_id => fnd_global.prog_appl_id,
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,
7088: WSMPUTIL.AUTONOMOUS_WRITE_TO_WIE (p_header_id => l_header_id, --Changed to fix bug #2345536
7089: p_message => substr(l_fnd_err_msg,1,2000),
7090: p_request_id => fnd_global.conc_request_id,
7091: p_program_id => fnd_global.conc_program_id,
7084:
7085: set_wrji_error(); -- WLTEnh
7086:
7087: --WSMPUTIL.AUTONOMOUS_WRITE_TO_WIE (p_header_id => l_temp,
7088: WSMPUTIL.AUTONOMOUS_WRITE_TO_WIE (p_header_id => l_header_id, --Changed to fix bug #2345536
7089: p_message => substr(l_fnd_err_msg,1,2000),
7090: p_request_id => fnd_global.conc_request_id,
7091: p_program_id => fnd_global.conc_program_id,
7092: p_program_application_id => fnd_global.prog_appl_id,
7229:
7230: l_stmt_num := 185;
7231: -- This is called to get information about the starting operation --
7232: -- in the target routing --
7233: WSMPUTIL.operation_is_standard_repeats (
7234: p_routing_sequence_id => l_com_rtg_seq_id,
7235: p_routing_revision_date => l_rtg_rev_date, -- sysdate
7236: p_standard_operation_id => l_start_std_op_id,
7237: p_operation_code => l_start_op_code,
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);
7258:
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,
7327: p_message => substr(l_fnd_err_msg,1,2000),
7328: p_request_id => fnd_global.conc_request_id,
7329: p_program_id => fnd_global.conc_program_id,
7387: SET error_message = l_fnd_err_msg
7388: WHERE header_id = l_header_id
7389: AND rowid = l_wrji_rowid; --SpUA add
7390:
7391: --WSMPUTIL.AUTONOMOUS_WRITE_TO_WIE(p_header_id => l_temp,
7392:
7393: set_wrji_error(); -- WLTEnh
7394:
7395: WSMPUTIL.AUTONOMOUS_WRITE_TO_WIE(p_header_id => l_header_id, --Changed to fix bug #2345536
7391: --WSMPUTIL.AUTONOMOUS_WRITE_TO_WIE(p_header_id => l_temp,
7392:
7393: set_wrji_error(); -- WLTEnh
7394:
7395: WSMPUTIL.AUTONOMOUS_WRITE_TO_WIE(p_header_id => l_header_id, --Changed to fix bug #2345536
7396: p_message => substr(l_fnd_err_msg,1,2000),
7397: p_request_id => fnd_global.conc_request_id,
7398: p_program_id => fnd_global.conc_program_id,
7399: p_program_application_id => fnd_global.prog_appl_id,
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,
7459: p_message => substr(l_fnd_err_msg,1,2000),
7460: p_request_id => fnd_global.conc_request_id,
7461: p_program_id => fnd_global.conc_program_id,
7462: p_program_application_id => fnd_global.prog_appl_id,
7543: ) then
7544:
7545: l_stmt_num := 197;
7546:
7547: WSMPUTIL.find_routing_start (p_routing_sequence_id => l_wrji_rtg_seq_id,
7548: p_routing_rev_date => l_rtg_rev_date,
7549: -- CZH.I_OED-2: should be fixed in I_OED-1
7550: start_op_seq_id => l_start_op_seq_id,
7551: x_err_code => p_err_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;
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,
7567: p_message => substr(p_err_msg,1,2000),
7568: p_request_id => fnd_global.conc_request_id,
7569: p_program_id => fnd_global.conc_program_id,
7570: p_program_application_id => fnd_global.prog_appl_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,
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,
7625: p_message => substr(l_fnd_err_msg,1,2000),
7626: p_request_id => fnd_global.conc_request_id,
7627: p_program_id => fnd_global.conc_program_id,
7628: p_program_application_id => fnd_global.prog_appl_id,
7651: begin
7652:
7653: -- BA NSO-WLT
7654: -- Find the routing seq id for this bonus job, using this rtg_seq_id and op_code,
7655: -- use wsmputil.operation_is_standard_repeats to find out if it repeats in
7656: -- the n/w rtg.
7657:
7658: l_stmt_num := 202;
7659: --VJ: Start Changes for NSLBJ--
7665: --VJ: End Changes for NSLBJ--
7666:
7667:
7668: l_stmt_num := 203;
7669: wsmputil.operation_is_standard_repeats(
7670: p_routing_sequence_id => l_rl_rtg_seq_id,
7671: p_routing_revision_date => l_rtg_rev_date, --sysdate
7672: p_standard_operation_id => NULL,
7673: p_operation_code => l_start_op_code,
7690: SET wsji.error_message = l_fnd_generic_err_msg
7691: WHERE wsji.header_id = l_header_id
7692: and wip_entity_name = l_job_name;
7693:
7694: WSMPUTIL.AUTONOMOUS_WRITE_TO_WIE (p_header_id => l_header_id,
7695: p_message => substr(l_fnd_err_msg,1,2000),
7696: p_request_id => fnd_global.conc_request_id,
7697: p_program_id => fnd_global.conc_program_id,
7698: p_program_application_id => fnd_global.prog_appl_id,
7808: --End Additions to fix bug #2265237--
7809:
7810: set_wrji_error(); -- WLTEnh
7811:
7812: WSMPUTIL.AUTONOMOUS_WRITE_TO_WIE (p_header_id => l_header_id,
7813: p_message => substr(l_fnd_err_msg,1,2000),
7814: p_request_id => fnd_global.conc_request_id,
7815: p_program_id => fnd_global.conc_program_id,
7816: p_program_application_id => fnd_global.prog_appl_id,
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,
7855: p_message => substr(l_fnd_err_msg,1,2000),
7856: p_request_id => fnd_global.conc_request_id,
7857: p_program_id => fnd_global.conc_program_id,
7858: p_program_application_id => fnd_global.prog_appl_id,
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,
7932: p_message => substr(l_fnd_err_msg,1,2000),
7933: p_request_id => fnd_global.conc_request_id,
7934: p_program_id => fnd_global.conc_program_id,
7935: p_program_application_id => fnd_global.prog_appl_id,
7967: ||l_stmt_num||'): '||l_fnd_err_msg);
7968: END IF;
7969:
7970:
7971: WSMPUTIL.AUTONOMOUS_WRITE_TO_WIE (p_header_id => l_header_id,
7972: p_message => substr(l_fnd_err_msg,1,2000),
7973: p_request_id => fnd_global.conc_request_id,
7974: p_program_id => fnd_global.conc_program_id,
7975: p_program_application_id => fnd_global.prog_appl_id,
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,
8010: p_message => substr(l_fnd_err_msg,1,2000),
8011: p_request_id => fnd_global.conc_request_id,
8012: p_program_id => fnd_global.conc_program_id,
8013: p_program_application_id => fnd_global.prog_appl_id,
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,
8053: p_program_id => fnd_global.conc_program_id,
8054: p_program_application_id => fnd_global.prog_appl_id,
8085: where bon.transition_type = 1 -- Primary
8086: and nvl(bon.disable_date, sysdate+1) > sysdate
8087: --BC: CZH.I_OED-2
8088: --and bon.from_op_seq_id = bos.operation_sequence_id
8089: and WSMPUTIL.replacement_op_seq_id(
8090: bon.from_op_seq_id,
8091: l_rtg_rev_date) = bos.operation_sequence_id
8092: --EC: CZH.I_OED-2
8093: and bos.routing_sequence_id = wrji.common_routing_sequence_id -- BD NSO-WLT
8101: from bom_operation_networks bon,
8102: bom_operation_sequences bos
8103: --BC: CZH.I_OED-2
8104: --where bon.to_op_seq_id = bos.operation_sequence_id
8105: where WSMPUTIL.replacement_op_seq_id(
8106: bon.to_op_seq_id,
8107: l_rtg_rev_date) = bos.operation_sequence_id
8108: --EC: CZH.I_OED-2
8109: and bos.routing_sequence_id = wrji.common_routing_sequence_id -- BD NSO-WLT
8114: from bom_operation_networks bon1,
8115: bom_operation_sequences bos1
8116: --BC: CZH.I_OED-2
8117: --where bon1.from_op_seq_id = bos1.operation_sequence_id
8118: where WSMPUTIL.replacement_op_seq_id (
8119: bon1.from_op_seq_id,
8120: l_rtg_rev_date) = bos1.operation_sequence_id
8121: --EC: CZH.I_OED-2
8122: and bos1.routing_sequence_id = wrji.common_routing_sequence_id)
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,
8138: p_program_id => fnd_global.conc_program_id,
8139: p_program_application_id => fnd_global.prog_appl_id,
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,
8183: p_program_id => fnd_global.conc_program_id,
8184: p_program_application_id => fnd_global.prog_appl_id,
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,
8235: p_message => substr(l_fnd_err_msg,1,2000),
8236: p_request_id => fnd_global.conc_request_id,
8237: p_program_id => fnd_global.conc_program_id,
8238: p_program_application_id => fnd_global.prog_appl_id,
8291: and wip_entity_name = l_job_name;
8292:
8293: set_wrji_error(); -- WLTEnh
8294:
8295: WSMPUTIL.AUTONOMOUS_WRITE_TO_WIE (p_header_id => l_header_id,
8296: p_message => substr(l_fnd_err_msg,1,2000),
8297: p_request_id => fnd_global.conc_request_id,
8298: p_program_id => fnd_global.conc_program_id,
8299: p_program_application_id => fnd_global.prog_appl_id,
8327: SET error_message = l_fnd_generic_err_msg
8328: where header_id = l_header_id
8329: and wip_entity_name = l_job_name;
8330:
8331: WSMPUTIL.AUTONOMOUS_WRITE_TO_WIE (p_header_id => l_header_id,
8332: p_message => substr(l_fnd_err_msg,1,2000),
8333: p_request_id => fnd_global.conc_request_id,
8334: p_program_id => fnd_global.conc_program_id,
8335: p_program_application_id => fnd_global.prog_appl_id,
8393: SET error_message = l_fnd_generic_err_msg
8394: where header_id = l_header_id
8395: and wip_entity_name = l_job_name;
8396:
8397: WSMPUTIL.WRITE_TO_WIE (p_header_id => l_header_id,
8398: p_message => substr(l_fnd_err_msg,1,2000),
8399: p_request_id => fnd_global.conc_request_id,
8400: p_program_id => fnd_global.conc_program_id,
8401: p_program_application_id => fnd_global.prog_appl_id,
8438: and wip_entity_name = l_job_name;
8439:
8440: set_wrji_error(); -- WLTEnh
8441:
8442: WSMPUTIL.AUTONOMOUS_WRITE_TO_WIE (p_header_id => l_header_id,
8443: p_message => substr(l_fnd_err_msg,1,2000),
8444: p_request_id => fnd_global.conc_request_id,
8445: p_program_id => fnd_global.conc_program_id,
8446: p_program_application_id => fnd_global.prog_appl_id,
8475: and wip_entity_name = l_job_name;
8476:
8477: set_wrji_error(); -- WLTEnh
8478:
8479: WSMPUTIL.AUTONOMOUS_WRITE_TO_WIE (p_header_id => l_header_id,
8480: p_message => substr(l_fnd_err_msg,1,2000),
8481: p_request_id => fnd_global.conc_request_id,
8482: p_program_id => fnd_global.conc_program_id,
8483: p_program_application_id => fnd_global.prog_appl_id,
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,
8510: p_message => substr(l_fnd_err_msg,1,2000),
8511: p_request_id => fnd_global.conc_request_id,
8512: p_program_id => fnd_global.conc_program_id,
8513: p_program_application_id => fnd_global.prog_appl_id,
8581:
8582: Begin
8583: l_stmt_num := 233;
8584:
8585: select unique WSMPUTIL.replacement_op_seq_id ( operation_sequence_id,l_rtg_rev_date)
8586: into l_osp_start_op_seq_id
8587: from bom_operation_sequences bos,
8588: wsm_resulting_jobs_interface wrji
8589: where wrji.header_id = l_header_id
8591: and bos.routing_sequence_id = wrji.common_routing_sequence_id
8592: and bos.operation_seq_num = wrji.starting_operation_seq_num ;
8593:
8594:
8595: If WSMPUTIL.CHECK_PO_MOVE( l_osp_start_op_seq_id,
8596: 'O',
8597: l_rtg_rev_date,
8598: p_err_msg,
8599: p_err_num) then
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),
8611: p_request_id => fnd_global.conc_request_id,
8612: p_program_id => fnd_global.conc_program_id,
8613: p_program_application_id => fnd_global.prog_appl_id,
8631: ||l_stmt_num||'): '||l_fnd_err_msg);
8632:
8633: set_wrji_error(); -- WLTEnh
8634:
8635: WSMPUTIL.AUTONOMOUS_WRITE_TO_WIE (p_header_id => l_header_id,
8636: p_message => substr(l_fnd_err_msg,1,2000),
8637: p_request_id => fnd_global.conc_request_id,
8638: p_program_id => fnd_global.conc_program_id,
8639: p_program_application_id => fnd_global.prog_appl_id,
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;
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,
8782: p_program_id => fnd_global.conc_program_id,
8783: p_program_application_id => fnd_global.prog_appl_id,
8791:
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
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,
8844: p_program_id => fnd_global.conc_program_id,
8845: p_program_application_id => fnd_global.prog_appl_id,
8853:
8854: END IF;
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:
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,
8908: p_program_id => fnd_global.conc_program_id,
8909: p_program_application_id => fnd_global.prog_appl_id,
8929: FETCH C_RESULTING_JOB into l_job_name, l_txn_date, l_txn_id, l_header_id, l_organization_id;
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
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,
8981: p_program_id => fnd_global.conc_program_id,
8982: p_program_application_id => fnd_global.prog_appl_id,
8990:
8991: END IF;
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:
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,
9045: p_program_id => fnd_global.conc_program_id,
9046: p_program_application_id => fnd_global.prog_appl_id,
9054:
9055: END IF;
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:
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,
9109: p_program_id => fnd_global.conc_program_id,
9110: p_program_application_id => fnd_global.prog_appl_id,
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,
9154: p_program_id => fnd_global.conc_program_id,
9155: p_program_application_id => fnd_global.prog_appl_id,
9164:
9165:
9166:
9167: --Start: Additions for APS-WLT--
9168: l_profile_value := WSMPUTIL.CREATE_LBJ_COPY_RTG_PROFILE(l_organization_id); -- This returns the Profile value
9169:
9170: IF (l_profile_value = 2) THEN -- Option A (Old Behavior)
9171: null;
9172: ELSE -- Option C (New Behavior)
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,
9204: p_message => substr(l_fnd_err_msg,1,2000),
9205: p_request_id => fnd_global.conc_request_id,
9206: p_program_id => fnd_global.conc_program_id,
9207: p_program_application_id => fnd_global.prog_appl_id,