DBA Data[Home] [Help]

APPS.WIP_OSP dependencies on FND_MESSAGE

Line 439: FND_MESSAGE.SET_NAME('WIP', 'WIP_RELEASE_VALID_EMPLOYEE');

435: x_emp_found := Cemp%FOUND;
436: CLOSE Cemp;
437:
438: IF x_emp_found = FALSE THEN
439: FND_MESSAGE.SET_NAME('WIP', 'WIP_RELEASE_VALID_EMPLOYEE');
440: APP_EXCEPTION.RAISE_EXCEPTION;
441: END IF;
442:
443: OPEN Cops;

Line 449: FND_MESSAGE.SET_NAME('WIP', 'WIP_RELEASE_PO_MOVE');

445: x_no_loc_found := Cops%FOUND;
446: CLOSE Cops;
447:
448: IF x_no_loc_found = TRUE THEN
449: FND_MESSAGE.SET_NAME('WIP', 'WIP_RELEASE_PO_MOVE');
450: APP_EXCEPTION.RAISE_EXCEPTION;
451: END IF;
452:
453: IF P_Repetitive_Schedule_Id IS NULL THEN

Line 1304: fnd_message.set_name('WIP', l_msg);

1300: close check_osp;
1301:
1302: if (l_found) then
1303: -- cannot perform move
1304: fnd_message.set_name('WIP', l_msg);
1305: x_error := substrb(fnd_message.get, 1, 240);
1306: x_msg := l_msg;
1307: return false;
1308: end if;

Line 1305: x_error := substrb(fnd_message.get, 1, 240);

1301:
1302: if (l_found) then
1303: -- cannot perform move
1304: fnd_message.set_name('WIP', l_msg);
1305: x_error := substrb(fnd_message.get, 1, 240);
1306: x_msg := l_msg;
1307: return false;
1308: end if;
1309: return (TRUE);

Line 1547: fnd_message.set_name('WIP','WIP_MISSING_PO_FPJ_ONWARD');

1543: END LOOP; -- for each job
1544: ELSE
1545: -- Customers do not have PO FPJ
1546: retcode := 1; -- warning
1547: fnd_message.set_name('WIP','WIP_MISSING_PO_FPJ_ONWARD');
1548: errbuf := fnd_message.get;
1549: END IF;
1550: EXCEPTION
1551: WHEN others THEN

Line 1548: errbuf := fnd_message.get;

1544: ELSE
1545: -- Customers do not have PO FPJ
1546: retcode := 1; -- warning
1547: fnd_message.set_name('WIP','WIP_MISSING_PO_FPJ_ONWARD');
1548: errbuf := fnd_message.get;
1549: END IF;
1550: EXCEPTION
1551: WHEN others THEN
1552: retcode := 2; -- error

Line 1640: fnd_message.set_name('PO', l_errors_rec.message_name(i));

1636: x_api_errors => l_errors_rec);
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;

Line 1646: fnd_message.set_name('WIP', 'WIP_INVALID_PO_STATUS');

1642: END LOOP;
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

Line 1679: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');

1675: x_msg_count => l_msgCount,
1676: x_msg_data => l_msgData);
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;

Line 1680: fnd_message.set_token('MESSAGE', l_msgData);

1676: x_msg_data => l_msgData);
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

Line 1713: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');

1709: p_procReturnStatus => x_return_status,
1710: p_msg => l_errMsg,
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:

Line 1714: fnd_message.set_token('MESSAGE', l_errMsg);

1710: p_msg => l_errMsg,
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.

Line 2092: fnd_message.set_name('WIP', 'WIP_REQUISITION_PENDING');

2088: AND (p_repetitive_id IS NULL OR
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;

Line 2104: fnd_message.set_name('WIP', 'WIP_MULTIPLE_PO_FOUND');

2100: OPEN c_multiple_po;
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

Line 2154: fnd_message.set_name('PO', l_errors_rec.message_name(i));

2150: x_api_errors => l_errors_rec);
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;

Line 2160: fnd_message.set_name('WIP', 'WIP_INVALID_PO_STATUS');

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
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

Line 2202: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');

2198: x_msg_count => l_msgCount,
2199: x_msg_data => l_msgData);
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;

Line 2203: fnd_message.set_token('MESSAGE', l_msgData);

2199: x_msg_data => l_msgData);
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

Line 2250: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');

2246: p_procReturnStatus => x_return_status,
2247: p_msg => l_errMsg,
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:

Line 2251: fnd_message.set_token('MESSAGE', l_errMsg);

2247: p_msg => l_errMsg,
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,

Line 2430: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');

2426: x_msg_count => l_msgCount,
2427: x_msg_data => l_msgData);
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;

Line 2431: fnd_message.set_token('MESSAGE', l_msgData);

2427: x_msg_data => l_msgData);
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

Line 2456: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');

2452: x_msg_count => l_msgCount,
2453: x_msg_data => l_msgData);
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;

Line 2457: fnd_message.set_token('MESSAGE', l_msgData);

2453: x_msg_data => l_msgData);
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;

Line 2470: fnd_message.set_name('WIP','WIP_UNABLE_TO_CANCEL_PO');

2466: END LOOP;
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

Line 2478: fnd_message.set_name('WIP', 'WIP_REQUISITION_PENDING');

2474: INTO l_pending_recs
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;

Line 2502: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');

2498: p_procReturnStatus => x_return_status,
2499: p_msg => l_errMsg,
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:

Line 2503: fnd_message.set_token('MESSAGE', l_errMsg);

2499: p_msg => l_errMsg,
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