DBA Data[Home] [Help]

APPS.WIP_OSP dependencies on FND_MSG_PUB

Line 1641: fnd_msg_pub.add;

1637:
1638: IF(x_return_status <> fnd_api.g_ret_sts_success) THEN
1639: FOR i IN 1..l_errors_rec.message_name.count LOOP
1640: fnd_message.set_name('PO', l_errors_rec.message_name(i));
1641: fnd_msg_pub.add;
1642: END LOOP;
1643: raise fnd_api.g_exc_unexpected_error;
1644: END IF;
1645: ELSE -- PO in status that do not allow update

Line 1647: fnd_msg_pub.add;

1643: raise fnd_api.g_exc_unexpected_error;
1644: END IF;
1645: ELSE -- PO in status that do not allow update
1646: fnd_message.set_name('WIP', 'WIP_INVALID_PO_STATUS');
1647: fnd_msg_pub.add;
1648: l_errMsg := 'PO is in status that does not allow update';
1649: raise fnd_api.g_exc_unexpected_error;
1650: END IF; -- Check PO status
1651: ELSIF (p_po_req_type = 'REQUISITION') THEN

Line 1681: fnd_msg_pub.add;

1677:
1678: IF(x_return_status <> fnd_api.g_ret_sts_success) THEN
1679: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
1680: fnd_message.set_token('MESSAGE', l_msgData);
1681: fnd_msg_pub.add;
1682: raise fnd_api.g_exc_unexpected_error;
1683: END IF;
1684: END IF; -- PO or Requisition
1685: -- write to the log file

Line 1715: fnd_msg_pub.add;

1711: x_returnStatus => l_returnStatus);
1712: END IF;
1713: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
1714: fnd_message.set_token('MESSAGE', l_errMsg);
1715: fnd_msg_pub.add;
1716: END updatePOReqNBD;
1717:
1718: /* Fix for bug 4734309: Added new parameter p_is_scrap_txn.
1719: * If passed as WIP_CONSTANTS.YES,

Line 2093: fnd_msg_pub.add;

2089: wip_repetitive_schedule_id = p_repetitive_id);
2090:
2091: IF(l_pending_recs <> 0) THEN
2092: fnd_message.set_name('WIP', 'WIP_REQUISITION_PENDING');
2093: fnd_msg_pub.add;
2094: l_errMsg := 'There are some pending records in ' ||
2095: 'PO_REQUISITIONS_INTERFACE_ALL';
2096: raise fnd_api.g_exc_unexpected_error;
2097: END IF;

Line 2105: fnd_msg_pub.add;

2101: FETCH c_multiple_po INTO l_multiple_po;
2102:
2103: IF (c_multiple_po%FOUND) THEN
2104: fnd_message.set_name('WIP', 'WIP_MULTIPLE_PO_FOUND');
2105: fnd_msg_pub.add;
2106: l_errMsg := 'Multiple PO/requisitions found for this job/schedule';
2107: raise fnd_api.g_exc_unexpected_error;
2108: ELSE
2109: -- Update PO quantity

Line 2155: fnd_msg_pub.add;

2151:
2152: IF(x_return_status <> fnd_api.g_ret_sts_success) THEN
2153: FOR i IN 1..l_errors_rec.message_name.count LOOP
2154: fnd_message.set_name('PO', l_errors_rec.message_name(i));
2155: fnd_msg_pub.add;
2156: END LOOP;
2157: raise fnd_api.g_exc_unexpected_error;
2158: END IF;
2159: ELSE -- PO is in the status that does not allow update

Line 2161: fnd_msg_pub.add;

2157: raise fnd_api.g_exc_unexpected_error;
2158: END IF;
2159: ELSE -- PO is in the status that does not allow update
2160: fnd_message.set_name('WIP', 'WIP_INVALID_PO_STATUS');
2161: fnd_msg_pub.add;
2162: l_errMsg := 'PO is in status that does not allow update';
2163: raise fnd_api.g_exc_unexpected_error;
2164: END IF; -- Check PO status
2165: ELSIF (l_update_po_qty.po_req_type = 'REQUISITION') THEN

Line 2204: fnd_msg_pub.add;

2200:
2201: IF(x_return_status <> fnd_api.g_ret_sts_success) THEN
2202: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
2203: fnd_message.set_token('MESSAGE', l_msgData);
2204: fnd_msg_pub.add;
2205: raise fnd_api.g_exc_unexpected_error;
2206: END IF;
2207: END IF; -- PO or Requisition
2208: END LOOP;

Line 2252: fnd_msg_pub.add;

2248: x_returnStatus => l_returnStatus);
2249: END IF;
2250: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
2251: fnd_message.set_token('MESSAGE', l_errMsg);
2252: fnd_msg_pub.add;
2253: END updatePOReqQuantity;
2254:
2255: PROCEDURE cancelPOReq (p_job_id IN NUMBER,
2256: p_repetitive_id IN NUMBER :=NULL,

Line 2404: fnd_msg_pub.initialize;

2400: END IF;
2401:
2402: -- Call PO API to cancel requisition
2403: IF p_clr_fnd_mes_flag = 'Y' Then -- added for bug fix 7415801
2404: fnd_msg_pub.initialize;
2405: END IF; --bug fix 7415801
2406:
2407: po_wip_integration_grp.cancel_document
2408: (p_api_version => 1.0,

Line 2432: fnd_msg_pub.add;

2428:
2429: IF(x_return_status <> fnd_api.g_ret_sts_success) THEN
2430: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
2431: fnd_message.set_token('MESSAGE', l_msgData);
2432: fnd_msg_pub.add;
2433: raise fnd_api.g_exc_unexpected_error;
2434: END IF;
2435: ELSE
2436: IF (l_logLevel <= wip_constants.full_logging) THEN

Line 2458: fnd_msg_pub.add;

2454:
2455: IF(x_return_status <> fnd_api.g_ret_sts_success) THEN
2456: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
2457: fnd_message.set_token('MESSAGE', l_msgData);
2458: fnd_msg_pub.add;
2459: raise fnd_api.g_exc_unexpected_error;
2460: END IF;
2461: END IF;
2462: EXCEPTION

Line 2471: fnd_msg_pub.add;

2467:
2468: IF (l_err_count > 0) THEN
2469: x_return_status := fnd_api.g_ret_sts_unexp_error;
2470: fnd_message.set_name('WIP','WIP_UNABLE_TO_CANCEL_PO');
2471: fnd_msg_pub.add;
2472: ELSE
2473: SELECT count(*)
2474: INTO l_pending_recs
2475: FROM po_requisitions_interface_all

Line 2479: fnd_msg_pub.add;

2475: FROM po_requisitions_interface_all
2476: WHERE wip_entity_id = p_job_id;
2477: IF(l_pending_recs <> 0) THEN
2478: fnd_message.set_name('WIP', 'WIP_REQUISITION_PENDING');
2479: fnd_msg_pub.add;
2480: x_return_status := fnd_api.g_ret_sts_unexp_error;
2481: ELSE
2482: x_return_status := fnd_api.g_ret_sts_success;
2483: END IF;

Line 2504: fnd_msg_pub.add;

2500: x_returnStatus => l_returnStatus);
2501: END IF;
2502: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
2503: fnd_message.set_token('MESSAGE', l_errMsg);
2504: fnd_msg_pub.add;
2505: END cancelPOReq;
2506:
2507: /* Fix for bug 4446607: This function returns TRUE if a PO/REQ is ever
2508: * created for this particular job/operation, irrespective of whether the