DBA Data[Home] [Help]

APPS.JMF_SHIKYU_INV_PVT dependencies on FND_API

Line 48: --| FND_API.G_RET_STS_ERROR if the return |

44: --| Receiving Transactions' since INV has |
45: --| fixed bug 5086940 |
46: --| 03/22/2006 vchu Added a check in Process_Transaction to |
47: --| set x_return_status to |
48: --| FND_API.G_RET_STS_ERROR if the return |
49: --| status from |
50: --| INV_TXN_MANAGER_PUB.Process_Transactions|
51: --| is NULL |
52: --| 06/16/2006 vchu Fixed Bug 5337725: Modified the |

Line 104: x_return_status := FND_API.G_RET_STS_SUCCESS;

100: , G_MODULE_PREFIX || l_api_name || '.begin'
101: , NULL);
102: END IF;
103:
104: x_return_status := FND_API.G_RET_STS_SUCCESS;
105:
106: SELECT OSA_ITEM_ID
107: INTO l_osa_item_id
108: FROM JMF_SUBCONTRACT_ORDERS

Line 130: x_return_status := FND_API.G_RET_STS_ERROR;

126: END IF;
127:
128: EXCEPTION
129: WHEN NO_DATA_FOUND THEN
130: x_return_status := FND_API.G_RET_STS_ERROR;
131: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
132: FND_LOG.string( FND_LOG.LEVEL_EXCEPTION
133: , G_MODULE_PREFIX || l_api_name || '.No Date Found'
134: , 'Exception - Subcontracting Purchase Order Shipment : '

Line 138: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

134: , 'Exception - Subcontracting Purchase Order Shipment : '
135: || p_subcontract_po_shipment_id);
136: END IF;
137: WHEN OTHERS THEN
138: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
139: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
140: FND_LOG.string( FND_LOG.LEVEL_UNEXPECTED
141: , G_MODULE_PREFIX || l_api_name || '.others_exception'
142: , 'Exception');

Line 175: x_return_status := FND_API.G_RET_STS_SUCCESS;

171: , G_MODULE_PREFIX || l_api_name || '.begin'
172: , NULL);
173: END IF;
174:
175: x_return_status := FND_API.G_RET_STS_SUCCESS;
176:
177: SELECT OSA_ITEM_ID
178: INTO l_osa_item_id
179: FROM JMF_SUBCONTRACT_ORDERS

Line 201: x_return_status := FND_API.G_RET_STS_ERROR;

197: END IF;
198:
199: EXCEPTION
200: WHEN NO_DATA_FOUND THEN
201: x_return_status := FND_API.G_RET_STS_ERROR;
202: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
203: FND_LOG.string( FND_LOG.LEVEL_EXCEPTION
204: , G_MODULE_PREFIX || l_api_name || '.No Date Found'
205: , 'Exception - Subcontracting Purchase Order Shipment : '

Line 209: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

205: , 'Exception - Subcontracting Purchase Order Shipment : '
206: || p_subcontract_po_shipment_id);
207: END IF;
208: WHEN OTHERS THEN
209: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
210: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
211: FND_LOG.string( FND_LOG.LEVEL_UNEXPECTED
212: , G_MODULE_PREFIX || l_api_name || '.others_exception'
213: , 'Exception');

Line 245: x_return_status := FND_API.G_RET_STS_SUCCESS;

241: , G_MODULE_PREFIX || l_api_name || '.begin'
242: , NULL);
243: END IF;
244:
245: x_return_status := FND_API.G_RET_STS_SUCCESS;
246:
247: SELECT OSA_ITEM_ID
248: INTO l_osa_item_id
249: FROM JMF_SUBCONTRACT_ORDERS

Line 271: x_return_status := FND_API.G_RET_STS_ERROR;

267: END IF;
268:
269: EXCEPTION
270: WHEN NO_DATA_FOUND THEN
271: x_return_status := FND_API.G_RET_STS_ERROR;
272: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
273: FND_LOG.string( FND_LOG.LEVEL_EXCEPTION
274: , G_MODULE_PREFIX || l_api_name || '.No Date Found'
275: , 'Exception - Subcontracting Purchase Order Shipment : '

Line 279: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

275: , 'Exception - Subcontracting Purchase Order Shipment : '
276: || p_subcontract_po_shipment_id);
277: END IF;
278: WHEN OTHERS THEN
279: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
280: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
281: FND_LOG.string( FND_LOG.LEVEL_UNEXPECTED
282: , G_MODULE_PREFIX || l_api_name || '.others_exception'
283: , 'Exception');

Line 315: x_return_status := FND_API.G_RET_STS_SUCCESS;

311: , G_MODULE_PREFIX || l_api_name || '.begin'
312: , NULL);
313: END IF;
314:
315: x_return_status := FND_API.G_RET_STS_SUCCESS;
316:
317: SELECT OSA_ITEM_ID
318: INTO l_osa_item_id
319: FROM JMF_SUBCONTRACT_ORDERS

Line 341: x_return_status := FND_API.G_RET_STS_ERROR;

337: END IF;
338:
339: EXCEPTION
340: WHEN NO_DATA_FOUND THEN
341: x_return_status := FND_API.G_RET_STS_ERROR;
342: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
343: FND_LOG.string( FND_LOG.LEVEL_EXCEPTION
344: , G_MODULE_PREFIX || l_api_name || '.No Date Found'
345: , 'Exception - Subcontracting Purchase Order Shipment : '

Line 349: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

345: , 'Exception - Subcontracting Purchase Order Shipment : '
346: || p_subcontract_po_shipment_id);
347: END IF;
348: WHEN OTHERS THEN
349: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
350: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
351: FND_LOG.string( FND_LOG.LEVEL_UNEXPECTED
352: , G_MODULE_PREFIX || l_api_name || '.others_exception'
353: , 'Exception');

Line 385: x_return_status := FND_API.G_RET_STS_SUCCESS;

381: , G_MODULE_PREFIX || l_api_name || '.begin'
382: , NULL);
383: END IF;
384:
385: x_return_status := FND_API.G_RET_STS_SUCCESS;
386:
387: Process_Transaction
388: ( p_subcontract_po_shipment_id => p_subcontract_po_shipment_id
389: , p_quantity => p_quantity

Line 405: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

401: END IF;
402:
403: EXCEPTION
404: WHEN OTHERS THEN
405: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
406: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
407: FND_LOG.string( FND_LOG.LEVEL_UNEXPECTED
408: , G_MODULE_PREFIX || l_api_name || '.others_exception'
409: , 'Exception');

Line 441: x_return_status := FND_API.G_RET_STS_SUCCESS;

437: , G_MODULE_PREFIX || l_api_name || '.begin'
438: , NULL);
439: END IF;
440:
441: x_return_status := FND_API.G_RET_STS_SUCCESS;
442:
443: Process_Transaction
444: ( p_subcontract_po_shipment_id => p_subcontract_po_shipment_id
445: , p_quantity => p_quantity * -1

Line 461: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

457: END IF;
458:
459: EXCEPTION
460: WHEN OTHERS THEN
461: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
462: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
463: FND_LOG.string( FND_LOG.LEVEL_UNEXPECTED
464: , G_MODULE_PREFIX || l_api_name || '.others_exception'
465: , 'Exception');

Line 735: x_return_status := FND_API.G_RET_STS_ERROR;

731: );
732:
733: IF l_return_status IS NULL
734: THEN
735: x_return_status := FND_API.G_RET_STS_ERROR;
736: ELSE
737: x_return_status := l_return_status;
738: END IF;
739:

Line 740: IF l_return_status <> FND_API.G_RET_STS_SUCCESS

736: ELSE
737: x_return_status := l_return_status;
738: END IF;
739:
740: IF l_return_status <> FND_API.G_RET_STS_SUCCESS
741: THEN
742: FND_MESSAGE.Set_Name('JMF', 'JMF_SHK_INV_PROCESS_FAIL');
743: FND_MSG_PUB.Add;
744: END IF;