[Home] [Help]
1730:
1731: IF(x_return_status <> fnd_api.g_ret_sts_success) THEN
1732: FOR i IN 1..l_errors_rec.message_name.count LOOP
1733: fnd_message.set_name('PO', l_errors_rec.message_name(i));
1734: fnd_msg_pub.add;
1735: END LOOP;
1736: raise fnd_api.g_exc_unexpected_error;
1737: END IF;
1738: ELSE -- PO in status that do not allow update
1736: raise fnd_api.g_exc_unexpected_error;
1737: END IF;
1738: ELSE -- PO in status that do not allow update
1739: fnd_message.set_name('WIP', 'WIP_INVALID_PO_STATUS');
1740: fnd_msg_pub.add;
1741: l_errMsg := 'PO is in status that does not allow update';
1742: raise fnd_api.g_exc_unexpected_error;
1743: END IF; -- Check PO status
1744: ELSIF (p_po_req_type = 'REQUISITION') THEN
1770:
1771: IF(x_return_status <> fnd_api.g_ret_sts_success) THEN
1772: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
1773: fnd_message.set_token('MESSAGE', l_msgData);
1774: fnd_msg_pub.add;
1775: raise fnd_api.g_exc_unexpected_error;
1776: END IF;
1777: END IF; -- PO or Requisition
1778: -- write to the log file
1804: x_returnStatus => l_returnStatus);
1805: END IF;
1806: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
1807: fnd_message.set_token('MESSAGE', l_errMsg);
1808: fnd_msg_pub.add;
1809: END updatePOReqNBD;
1810:
1811: /* Fix for bug 4734309: Added new parameter p_is_scrap_txn.
1812: * If passed as WIP_CONSTANTS.YES,
2215: wip_repetitive_schedule_id = p_repetitive_id);
2216:
2217: IF(l_pending_recs <> 0) THEN
2218: fnd_message.set_name('WIP', 'WIP_REQUISITION_PENDING');
2219: fnd_msg_pub.add;
2220: l_errMsg := 'There are some pending records in ' ||
2221: 'PO_REQUISITIONS_INTERFACE_ALL';
2222: raise fnd_api.g_exc_unexpected_error;
2223: END IF;
2227: FETCH c_multiple_po INTO l_multiple_po;
2228:
2229: IF (c_multiple_po%FOUND) THEN
2230: fnd_message.set_name('WIP', 'WIP_MULTIPLE_PO_FOUND');
2231: fnd_msg_pub.add;
2232: l_errMsg := 'Multiple PO/requisitions found for this job/schedule';
2233: raise fnd_api.g_exc_unexpected_error;
2234: ELSE
2235: -- Update PO quantity
2282: x_api_errors => l_errors_rec);
2283: IF(x_return_status <> fnd_api.g_ret_sts_success) THEN
2284: FOR i IN 1..l_errors_rec.message_name.count LOOP
2285: fnd_message.set_name('PO', l_errors_rec.message_name(i));
2286: fnd_msg_pub.add;
2287: END LOOP;
2288: raise fnd_api.g_exc_unexpected_error;
2289: END IF;
2290: */
2290: */
2291:
2292: ELSE -- PO is in the status that does not allow update
2293: fnd_message.set_name('WIP', 'WIP_INVALID_PO_STATUS');
2294: fnd_msg_pub.add;
2295: l_errMsg := 'PO is in status that does not allow update';
2296: raise fnd_api.g_exc_unexpected_error;
2297: END IF; -- Check PO status
2298: ELSIF (l_update_po_qty.po_req_type = 'REQUISITION') THEN
2333:
2334: IF(x_return_status <> fnd_api.g_ret_sts_success) THEN
2335: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
2336: fnd_message.set_token('MESSAGE', l_msgData);
2337: fnd_msg_pub.add;
2338: raise fnd_api.g_exc_unexpected_error;
2339: END IF;
2340: END IF; -- PO or Requisition
2341: END LOOP;
2356:
2357: IF(x_return_status <> fnd_api.g_ret_sts_success) THEN
2358: FOR i IN 1..l_errors_rec.message_name.count LOOP
2359: fnd_message.set_name('PO', l_errors_rec.message_name(i));
2360: fnd_msg_pub.add;
2361: END LOOP;
2362: raise fnd_api.g_exc_unexpected_error;
2363: END IF;
2364: END LOOP;
2408: x_returnStatus => l_returnStatus);
2409: END IF;
2410: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
2411: fnd_message.set_token('MESSAGE', l_errMsg);
2412: fnd_msg_pub.add;
2413: END updatePOReqQuantity;
2414:
2415:
2416: PROCEDURE cancelPOReq (p_job_id IN NUMBER,
2562:
2563: -- Call PO API to cancel requisition
2564: -- Bug fix 8681037: Added NVL in the if condition.
2565: IF NVL(p_clr_fnd_mes_flag, 'N') = 'Y' Then -- added for bug fix 7415801
2566: fnd_msg_pub.initialize;
2567: END IF; --bug fix 7415801
2568:
2569: po_wip_integration_grp.cancel_document
2570: (p_api_version => 1.0,
2590:
2591: IF(x_return_status <> fnd_api.g_ret_sts_success) THEN
2592: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
2593: fnd_message.set_token('MESSAGE', l_msgData);
2594: fnd_msg_pub.add;
2595: raise fnd_api.g_exc_unexpected_error;
2596: END IF;
2597: ELSE
2598: IF (l_logLevel <= wip_constants.full_logging) THEN
2616:
2617: IF(x_return_status <> fnd_api.g_ret_sts_success) THEN
2618: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
2619: fnd_message.set_token('MESSAGE', l_msgData);
2620: fnd_msg_pub.add;
2621: raise fnd_api.g_exc_unexpected_error;
2622: END IF;
2623: END IF;
2624: EXCEPTION
2629:
2630: IF (l_err_count > 0) THEN
2631: x_return_status := fnd_api.g_ret_sts_unexp_error;
2632: fnd_message.set_name('WIP','WIP_UNABLE_TO_CANCEL_PO');
2633: fnd_msg_pub.add;
2634: ELSE
2635: SELECT count(*)
2636: INTO l_pending_recs
2637: FROM po_requisitions_interface_all
2637: FROM po_requisitions_interface_all
2638: WHERE wip_entity_id = p_job_id;
2639: IF(l_pending_recs <> 0) THEN
2640: fnd_message.set_name('WIP', 'WIP_REQUISITION_PENDING');
2641: fnd_msg_pub.add;
2642: x_return_status := fnd_api.g_ret_sts_unexp_error;
2643: ELSE
2644: x_return_status := fnd_api.g_ret_sts_success;
2645: END IF;
2662: x_returnStatus => l_returnStatus);
2663: END IF;
2664: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
2665: fnd_message.set_token('MESSAGE', l_errMsg);
2666: fnd_msg_pub.add;
2667: END cancelPOReq;
2668:
2669: /* Fix for bug 4446607: This function returns TRUE if a PO/REQ is ever
2670: * created for this particular job/operation, irrespective of whether the