eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.WIP_OSP dependencies on FND_API

Line 365: raise fnd_api.g_exc_unexpected_error;

361: from po_system_parameters_all
362: where org_id = l_ou_id;
363: EXCEPTION
364: WHEN NO_DATA_FOUND THEN
365: raise fnd_api.g_exc_unexpected_error;
366: END;
367:
368: /*ER 4276433*/
369: if(fnd_profile.value('WIP_OSP_INITIATE_REQAPPR') = WIP_CONSTANTS.NO) then

Line 910: raise fnd_api.g_exc_unexpected_error;

906: from po_system_parameters_all
907: where org_id = l_ou_id;
908: EXCEPTION
909: WHEN NO_DATA_FOUND THEN
910: raise fnd_api.g_exc_unexpected_error;
911: END;
912:
913: /*ER 4276433*/
914: if(fnd_profile.value('WIP_OSP_INITIATE_REQAPPR') = WIP_CONSTANTS.NO) then

Line 1697: x_return_status := fnd_api.g_ret_sts_success;

1693: x_returnStatus => l_returnStatus);
1694: END IF;
1695:
1696: SAVEPOINT s_update_po_nbd;
1697: x_return_status := fnd_api.g_ret_sts_success;
1698: -- Set OU context before calling PO API. This change is mandatory for
1699: -- MOAC change in R12.
1700: mo_global.set_policy_context('S',p_ou_id);
1701: -- Update PO need by date and promise date

Line 1721: p_init_msg_list => fnd_api.g_true,

1717: p_need_by_date => p_new_NBD);
1718:
1719: po_wip_integration_grp.update_document(
1720: p_api_version => 1.0,
1721: p_init_msg_list => fnd_api.g_true,
1722: p_changes => l_po_changes,
1723: p_run_submission_checks => fnd_api.g_true,
1724: p_launch_approvals_flag => fnd_api.g_true,
1725: p_buyer_id => NULL,

Line 1723: p_run_submission_checks => fnd_api.g_true,

1719: po_wip_integration_grp.update_document(
1720: p_api_version => 1.0,
1721: p_init_msg_list => fnd_api.g_true,
1722: p_changes => l_po_changes,
1723: p_run_submission_checks => fnd_api.g_true,
1724: p_launch_approvals_flag => fnd_api.g_true,
1725: p_buyer_id => NULL,
1726: p_update_source => NULL,
1727: p_override_date => NULL,

Line 1724: p_launch_approvals_flag => fnd_api.g_true,

1720: p_api_version => 1.0,
1721: p_init_msg_list => fnd_api.g_true,
1722: p_changes => l_po_changes,
1723: p_run_submission_checks => fnd_api.g_true,
1724: p_launch_approvals_flag => fnd_api.g_true,
1725: p_buyer_id => NULL,
1726: p_update_source => NULL,
1727: p_override_date => NULL,
1728: x_return_status => x_return_status,

Line 1731: IF(x_return_status <> fnd_api.g_ret_sts_success) THEN

1727: p_override_date => NULL,
1728: x_return_status => x_return_status,
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;

Line 1736: raise fnd_api.g_exc_unexpected_error;

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
1739: fnd_message.set_name('WIP', 'WIP_INVALID_PO_STATUS');
1740: fnd_msg_pub.add;

Line 1742: raise fnd_api.g_exc_unexpected_error;

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
1745: -- Call PO API to update requisition
1746: l_req_changes := PO_REQ_CHANGES_REC_TYPE(

Line 1771: IF(x_return_status <> fnd_api.g_ret_sts_success) THEN

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

Line 1775: raise fnd_api.g_exc_unexpected_error;

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
1779: IF (l_logLevel <= wip_constants.trace_logging) THEN

Line 1786: WHEN fnd_api.g_exc_unexpected_error THEN

1782: p_msg => 'procedure complete',
1783: x_returnStatus => l_returnStatus);
1784: END IF;
1785: EXCEPTION
1786: WHEN fnd_api.g_exc_unexpected_error THEN
1787: ROLLBACK TO SAVEPOINT s_update_po_nbd;
1788: x_return_status := fnd_api.g_ret_sts_unexp_error;
1789: IF (l_logLevel <= wip_constants.trace_logging) THEN
1790: wip_logger.exitPoint(p_procName => 'wip_osp.updatePOReqNBD',

Line 1788: x_return_status := fnd_api.g_ret_sts_unexp_error;

1784: END IF;
1785: EXCEPTION
1786: WHEN fnd_api.g_exc_unexpected_error THEN
1787: ROLLBACK TO SAVEPOINT s_update_po_nbd;
1788: x_return_status := fnd_api.g_ret_sts_unexp_error;
1789: IF (l_logLevel <= wip_constants.trace_logging) THEN
1790: wip_logger.exitPoint(p_procName => 'wip_osp.updatePOReqNBD',
1791: p_procReturnStatus => x_return_status,
1792: p_msg => l_errMsg,

Line 1798: x_return_status := fnd_api.g_ret_sts_unexp_error;

1794: END IF;
1795:
1796: WHEN others THEN
1797: ROLLBACK TO SAVEPOINT s_update_po_nbd;
1798: x_return_status := fnd_api.g_ret_sts_unexp_error;
1799: l_errMsg := 'unexpected error: ' || SQLERRM || 'SQLCODE = ' || SQLCODE;
1800: IF (l_logLevel <= wip_constants.trace_logging) THEN
1801: wip_logger.exitPoint(p_procName => 'wip_osp.updatePOReqNBD',
1802: p_procReturnStatus => x_return_status,

Line 2183: x_return_status := fnd_api.g_ret_sts_success;

2179: x_returnStatus => l_returnStatus);
2180: END IF;
2181:
2182: SAVEPOINT s_update_po_qty;
2183: x_return_status := fnd_api.g_ret_sts_success;
2184:
2185: IF(p_repetitive_id IS NULL) THEN
2186: -- Discrete jobs
2187: SELECT po_creation_time

Line 2222: raise fnd_api.g_exc_unexpected_error;

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;
2224: end if; /* if((p_is_scrap_txn = WIP_CONSTANTS.YES AND */
2225:
2226: OPEN c_multiple_po;

Line 2233: raise fnd_api.g_exc_unexpected_error;

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
2236: FOR l_update_po_qty IN c_update_po_qty LOOP
2237: -- Set OU context before calling PO API. This change is

Line 2274: p_init_msg_list => fnd_api.g_true,

2270: l_pochanges_tab(indx):=l_po_changes;
2271: /* Commented by tekang for FP bug 10383628
2272: po_wip_integration_grp.update_document(
2273: p_api_version => 1.0,
2274: p_init_msg_list => fnd_api.g_true,
2275: p_changes => l_po_changes,
2276: p_run_submission_checks => fnd_api.g_true,
2277: p_launch_approvals_flag => fnd_api.g_true,
2278: p_buyer_id => NULL,

Line 2276: p_run_submission_checks => fnd_api.g_true,

2272: po_wip_integration_grp.update_document(
2273: p_api_version => 1.0,
2274: p_init_msg_list => fnd_api.g_true,
2275: p_changes => l_po_changes,
2276: p_run_submission_checks => fnd_api.g_true,
2277: p_launch_approvals_flag => fnd_api.g_true,
2278: p_buyer_id => NULL,
2279: p_update_source => NULL,
2280: p_override_date => NULL,

Line 2277: p_launch_approvals_flag => fnd_api.g_true,

2273: p_api_version => 1.0,
2274: p_init_msg_list => fnd_api.g_true,
2275: p_changes => l_po_changes,
2276: p_run_submission_checks => fnd_api.g_true,
2277: p_launch_approvals_flag => fnd_api.g_true,
2278: p_buyer_id => NULL,
2279: p_update_source => NULL,
2280: p_override_date => NULL,
2281: x_return_status => x_return_status,

Line 2283: IF(x_return_status <> fnd_api.g_ret_sts_success) THEN

2279: p_update_source => NULL,
2280: p_override_date => NULL,
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;

Line 2288: raise fnd_api.g_exc_unexpected_error;

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: */
2291:
2292: ELSE -- PO is in the status that does not allow update

Line 2296: raise fnd_api.g_exc_unexpected_error;

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
2299: -- Call PO API to update QUANTITY in PO_REQUISITION_LINES_ALL.
2300: l_req_changes := PO_REQ_CHANGES_REC_TYPE(

Line 2334: IF(x_return_status <> fnd_api.g_ret_sts_success) THEN

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

Line 2338: raise fnd_api.g_exc_unexpected_error;

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;
2342: /* Added by tekang for FP bug 10383623 */

Line 2347: p_init_msg_list => fnd_api.g_true,

2343: If l_pochanges_tab.count>0 then
2344: FOR i in 1..l_pochanges_tab.count LOOP --Added for bug#14782614- To call the update_document for all records
2345: po_wip_integration_grp.update_document(
2346: p_api_version => 1.0,
2347: p_init_msg_list => fnd_api.g_true,
2348: p_changes => l_pochanges_tab(i),
2349: p_run_submission_checks => fnd_api.g_true,
2350: p_launch_approvals_flag => fnd_api.g_true,
2351: p_buyer_id => NULL,

Line 2349: p_run_submission_checks => fnd_api.g_true,

2345: po_wip_integration_grp.update_document(
2346: p_api_version => 1.0,
2347: p_init_msg_list => fnd_api.g_true,
2348: p_changes => l_pochanges_tab(i),
2349: p_run_submission_checks => fnd_api.g_true,
2350: p_launch_approvals_flag => fnd_api.g_true,
2351: p_buyer_id => NULL,
2352: p_update_source => NULL,
2353: p_override_date => NULL,

Line 2350: p_launch_approvals_flag => fnd_api.g_true,

2346: p_api_version => 1.0,
2347: p_init_msg_list => fnd_api.g_true,
2348: p_changes => l_pochanges_tab(i),
2349: p_run_submission_checks => fnd_api.g_true,
2350: p_launch_approvals_flag => fnd_api.g_true,
2351: p_buyer_id => NULL,
2352: p_update_source => NULL,
2353: p_override_date => NULL,
2354: x_return_status => x_return_status,

Line 2357: IF(x_return_status <> fnd_api.g_ret_sts_success) THEN

2353: p_override_date => NULL,
2354: x_return_status => x_return_status,
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;

Line 2362: raise fnd_api.g_exc_unexpected_error;

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;
2365: end if; --If l_pochanges_tab.count>0
2366:

Line 2384: WHEN fnd_api.g_exc_unexpected_error THEN

2380: p_msg => 'procedure complete',
2381: x_returnStatus => l_returnStatus);
2382: END IF;
2383: EXCEPTION
2384: WHEN fnd_api.g_exc_unexpected_error THEN
2385: ROLLBACK TO SAVEPOINT s_update_po_qty;
2386: IF(c_multiple_po%ISOPEN) THEN
2387: CLOSE c_multiple_po;
2388: END IF;

Line 2389: x_return_status := fnd_api.g_ret_sts_unexp_error;

2385: ROLLBACK TO SAVEPOINT s_update_po_qty;
2386: IF(c_multiple_po%ISOPEN) THEN
2387: CLOSE c_multiple_po;
2388: END IF;
2389: x_return_status := fnd_api.g_ret_sts_unexp_error;
2390: IF (l_logLevel <= wip_constants.trace_logging) THEN
2391: wip_logger.exitPoint(p_procName => 'wip_osp.updatePOReqQuantity',
2392: p_procReturnStatus => x_return_status,
2393: p_msg => l_errMsg,

Line 2402: x_return_status := fnd_api.g_ret_sts_unexp_error;

2398: ROLLBACK TO SAVEPOINT s_update_po_qty;
2399: IF(c_multiple_po%ISOPEN) THEN
2400: CLOSE c_multiple_po;
2401: END IF;
2402: x_return_status := fnd_api.g_ret_sts_unexp_error;
2403: l_errMsg := 'unexpected error: ' || SQLERRM || 'SQLCODE = ' || SQLCODE;
2404: IF (l_logLevel <= wip_constants.trace_logging) THEN
2405: wip_logger.exitPoint(p_procName => 'wip_osp.updatePOReqQuantity',
2406: p_procReturnStatus => x_return_status,

Line 2591: IF(x_return_status <> fnd_api.g_ret_sts_success) THEN

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

Line 2595: raise fnd_api.g_exc_unexpected_error;

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
2599: l_debugMsg := 'req_header_id = ' || l_po_req.req_header_id|| ' ; '

Line 2617: IF(x_return_status <> fnd_api.g_ret_sts_success) THEN

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

Line 2621: raise fnd_api.g_exc_unexpected_error;

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
2625: WHEN others THEN

Line 2631: x_return_status := fnd_api.g_ret_sts_unexp_error;

2627: END;
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(*)

Line 2642: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

Line 2644: x_return_status := fnd_api.g_ret_sts_success;

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;
2646: END IF;
2647: -- write to the log file
2648: IF (l_logLevel <= wip_constants.trace_logging) THEN

Line 2656: x_return_status := fnd_api.g_ret_sts_unexp_error;

2652: x_returnStatus => l_returnStatus);
2653: END IF;
2654: EXCEPTION
2655: WHEN others THEN
2656: x_return_status := fnd_api.g_ret_sts_unexp_error;
2657: l_errMsg := 'unexpected error: ' || SQLERRM || 'SQLCODE = ' || SQLCODE;
2658: IF (l_logLevel <= wip_constants.trace_logging) THEN
2659: wip_logger.exitPoint(p_procName => 'wip_osp.cancelPOReq',
2660: p_procReturnStatus => x_return_status,