[Home] [Help]
1525: p_org_id => p_organization_id,
1526: p_operation_seq_num => cur_row.operation_seq_num,
1527: p_inventory_item_id => cur_row.inventory_item_id_old)) then
1528:
1529: FND_MESSAGE.set_name('WIP', 'WIP_QTY_REQ_CHANGE_WARNING');
1530: wip_jsi_utils.record_current_error(TRUE) ;
1531:
1532: wip_picking_pub.Update_Component_BackOrdQty(p_wip_entity_id => p_wip_entity_id,
1533: p_operation_seq_num => cur_row.operation_seq_num,
1555: p_wip_entity_type => WIP_CONSTANTS.DISCRETE,
1556: x_return_status => x_return_status,
1557: x_msg_data => x_msg_data);
1558:
1559: FND_MESSAGE.set_name('WIP', 'WIP_SUPPLY_CHANGE_WARNING2');
1560: wip_jsi_utils.record_current_error(TRUE);
1561: end if;
1562:
1563: --Bug#4675116
1827: NULL;
1828: END;
1829:
1830: IF l_op_exists = 1 THEN
1831: fnd_message.set_name('WIP','WIP_ADD_OP_INVALID');
1832: wip_jsi_utils.record_current_error(FALSE);
1833:
1834: update wip_job_dtls_interface wjdi
1835: set process_status = wip_constants.error
1841: and organization_id = p_organization_id
1842: and substitution_type = wip_job_details.wip_add;
1843:
1844: x_err_code := SQLCODE;
1845: x_err_msg := fnd_message.get;
1846: x_return_status := FND_API.G_RET_STS_ERROR;
1847: return;
1848: END IF;
1849: END IF;
1870: NULL;
1871: END;
1872:
1873: IF l_txn_exists = 1 THEN
1874: fnd_message.set_name('WIP','WIP_ADD_OP_INVALID');
1875: wip_jsi_utils.record_current_error(FALSE);
1876: update wip_job_dtls_interface wjdi
1877: set process_status = wip_constants.error
1878: where group_id = p_group_id
1883: and organization_id = p_organization_id
1884: and substitution_type = wip_job_details.wip_add;
1885:
1886: x_err_code := SQLCODE;
1887: x_err_msg := fnd_message.get;
1888: x_return_status := FND_API.G_RET_STS_ERROR;
1889: return;
1890: END IF;
1891: END IF;
2459:
2460: begin
2461: for l_inv_row in c_invalid_rows loop
2462: l_error_exists := true;
2463: fnd_message.set_name('WIP', 'WIP_INVALID_SCHEDULE_DATE');
2464: fnd_message.set_token('INTERFACE', to_char(l_inv_row.interface_id));
2465: --Bug#14487360: Replacing substr with substrb to ensure that non-English error message is not errored out
2466: if(wip_job_details.std_alone = 1) then
2467: wip_interface_err_Utils.add_error(p_interface_id => l_inv_row.interface_id,
2460: begin
2461: for l_inv_row in c_invalid_rows loop
2462: l_error_exists := true;
2463: fnd_message.set_name('WIP', 'WIP_INVALID_SCHEDULE_DATE');
2464: fnd_message.set_token('INTERFACE', to_char(l_inv_row.interface_id));
2465: --Bug#14487360: Replacing substr with substrb to ensure that non-English error message is not errored out
2466: if(wip_job_details.std_alone = 1) then
2467: wip_interface_err_Utils.add_error(p_interface_id => l_inv_row.interface_id,
2468: p_text => substrb(fnd_message.get,1,500),
2464: fnd_message.set_token('INTERFACE', to_char(l_inv_row.interface_id));
2465: --Bug#14487360: Replacing substr with substrb to ensure that non-English error message is not errored out
2466: if(wip_job_details.std_alone = 1) then
2467: wip_interface_err_Utils.add_error(p_interface_id => l_inv_row.interface_id,
2468: p_text => substrb(fnd_message.get,1,500),
2469: p_error_type => wip_jdi_utils.msg_error);
2470: else
2471: wip_interface_err_Utils.add_error(p_interface_id => wip_jsi_utils.current_interface_id,
2472: p_text => substrb(fnd_message.get,1,500),
2468: p_text => substrb(fnd_message.get,1,500),
2469: p_error_type => wip_jdi_utils.msg_error);
2470: else
2471: wip_interface_err_Utils.add_error(p_interface_id => wip_jsi_utils.current_interface_id,
2472: p_text => substrb(fnd_message.get,1,500),
2473: p_error_type => wip_jdi_utils.msg_error);
2474: end if;
2475: end loop;
2476: