DBA Data[Home] [Help]

APPS.WIP_OSP dependencies on FND_MESSAGE

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

470: x_emp_found := Cemp%FOUND;
471: CLOSE Cemp;
472:
473: IF x_emp_found = FALSE THEN
474: FND_MESSAGE.SET_NAME('WIP', 'WIP_RELEASE_VALID_EMPLOYEE');
475: APP_EXCEPTION.RAISE_EXCEPTION;
476: END IF;
477:
478: OPEN Cops;

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

480: x_no_loc_found := Cops%FOUND;
481: CLOSE Cops;
482:
483: IF x_no_loc_found = TRUE THEN
484: FND_MESSAGE.SET_NAME('WIP', 'WIP_RELEASE_PO_MOVE');
485: APP_EXCEPTION.RAISE_EXCEPTION;
486: END IF;
487:
488: IF P_Repetitive_Schedule_Id IS NULL THEN

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

1386: close check_osp;
1387:
1388: if (l_found) then
1389: -- cannot perform move
1390: fnd_message.set_name('WIP', l_msg);
1391: x_error := substrb(fnd_message.get, 1, 240);
1392: x_msg := l_msg;
1393: return false;
1394: end if;

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

1387:
1388: if (l_found) then
1389: -- cannot perform move
1390: fnd_message.set_name('WIP', l_msg);
1391: x_error := substrb(fnd_message.get, 1, 240);
1392: x_msg := l_msg;
1393: return false;
1394: end if;
1395: return (TRUE);

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

1636: END LOOP; -- for each job
1637: ELSE
1638: -- Customers do not have PO FPJ
1639: retcode := 1; -- warning
1640: fnd_message.set_name('WIP','WIP_MISSING_PO_FPJ_ONWARD');
1641: errbuf := fnd_message.get;
1642: END IF;
1643: EXCEPTION
1644: WHEN others THEN

Line 1641: errbuf := fnd_message.get;

1637: ELSE
1638: -- Customers do not have PO FPJ
1639: retcode := 1; -- warning
1640: fnd_message.set_name('WIP','WIP_MISSING_PO_FPJ_ONWARD');
1641: errbuf := fnd_message.get;
1642: END IF;
1643: EXCEPTION
1644: WHEN others THEN
1645: retcode := 2; -- error

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

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

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

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

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

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

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

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

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

1802: p_procReturnStatus => x_return_status,
1803: p_msg => l_errMsg,
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:

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

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

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

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

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

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

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

2281: x_return_status => x_return_status,
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;

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

2289: END IF;
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

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

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

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

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

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

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

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

2406: p_procReturnStatus => x_return_status,
2407: p_msg => l_errMsg,
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:

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

2660: p_procReturnStatus => x_return_status,
2661: p_msg => l_errMsg,
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:

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

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