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.

APPS.JMF_SHIKYU_ALLOCATION_PVT dependencies on FND_API

Line 160: --| the 'S' status by FND_API.G_RET_STS_SUCCESS. |

156: --| the Subcontracting Order Shipment. |
157: --| 10-MAY-2006 vchu Added a WHEN OTHERS THEN statement to the |
158: --| EXCEPTION block of all the procedures to print |
159: --| out the sqlerrm. Also replaced hardcoding of |
160: --| the 'S' status by FND_API.G_RET_STS_SUCCESS. |
161: --| 11-MAY-2006 vchu Modified Delete_Allocations to only update |
162: --| the allocated_quantity of the corresponding |
163: --| jmf_shikyu_replenishments record if there were |
164: --| indeed allocations being deleted. The wrong |

Line 603: x_return_status := FND_API.G_RET_STS_ERROR;

599:
600: EXCEPTION
601: WHEN g_replen_so_line_not_exist THEN
602:
603: x_return_status := FND_API.G_RET_STS_ERROR;
604:
605: IF g_fnd_debug = 'Y' AND
606: FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
607: THEN

Line 616: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

612: END IF;
613:
614: WHEN OTHERS THEN
615:
616: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
617:
618: IF g_fnd_debug = 'Y' AND
619: FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
620: THEN

Line 745: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

741: EXCEPTION
742:
743: WHEN OTHERS THEN
744:
745: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
746:
747: IF g_fnd_debug = 'Y' AND
748: FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
749: THEN

Line 1150: x_return_status := FND_API.G_RET_STS_ERROR;

1146: EXCEPTION
1147:
1148: WHEN g_no_wip_job_found_exc THEN
1149:
1150: x_return_status := FND_API.G_RET_STS_ERROR;
1151: IF g_fnd_debug = 'Y' AND
1152: FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
1153: THEN
1154: FND_LOG.string( FND_LOG.LEVEL_EXCEPTION

Line 1162: x_return_status := FND_API.G_RET_STS_ERROR;

1158: END IF;
1159:
1160: WHEN g_no_ship_method_found_exc THEN
1161:
1162: x_return_status := FND_API.G_RET_STS_ERROR;
1163: IF g_fnd_debug = 'Y' AND
1164: FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
1165: THEN
1166: FND_LOG.string( FND_LOG.LEVEL_EXCEPTION

Line 1174: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1170: END IF;
1171:
1172: WHEN OTHERS THEN
1173:
1174: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1175:
1176: IF g_fnd_debug = 'Y' AND
1177: FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
1178: THEN

Line 1439: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1435: EXCEPTION
1436:
1437: WHEN OTHERS THEN
1438:
1439: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1440:
1441: IF g_fnd_debug = 'Y' AND
1442: FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
1443: THEN

Line 1533: IF x_return_status <> FND_API.G_RET_STS_SUCCESS

1529: || ', x_po_line_location_id = ' || l_new_replen_po_shipment_id);
1530: END IF;
1531:
1532: -- *** vchu: new code 8/18
1533: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
1534: THEN
1535:
1536: RAISE g_process_replen_po_exc;
1537:

Line 1620: IF x_return_status <> FND_API.G_RET_STS_SUCCESS

1616: || x_return_status);
1617: END IF;
1618:
1619: -- *** vchu: new code 8/18
1620: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
1621: THEN
1622:
1623: RAISE g_process_replen_so_exc;
1624:

Line 1682: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1678: END IF;
1679:
1680: WHEN OTHERS THEN
1681:
1682: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1683:
1684: IF g_fnd_debug = 'Y' AND
1685: FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
1686: THEN

Line 1895: IF x_return_status <> FND_API.G_RET_STS_SUCCESS

1891: , x_return_status => x_return_status
1892: );
1893:
1894: -- *** vchu: new code 8/18
1895: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
1896: THEN
1897:
1898: RAISE g_process_replen_so_exc;
1899:

Line 1993: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1989: END IF;
1990:
1991: WHEN OTHERS THEN
1992:
1993: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1994:
1995: IF g_fnd_debug = 'Y' AND
1996: FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
1997: THEN

Line 2163: x_return_status := FND_API.G_RET_STS_ERROR;

2159: EXCEPTION
2160:
2161: WHEN NO_DATA_FOUND THEN
2162:
2163: x_return_status := FND_API.G_RET_STS_ERROR;
2164: IF g_fnd_debug = 'Y' AND
2165: FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
2166: THEN
2167: FND_LOG.string( FND_LOG.LEVEL_EXCEPTION

Line 2175: x_return_status := FND_API.G_RET_STS_ERROR;

2171: END IF;
2172:
2173: WHEN g_non_shikyu_component_exc THEN
2174:
2175: x_return_status := FND_API.G_RET_STS_ERROR;
2176: IF g_fnd_debug = 'Y' AND
2177: FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
2178: THEN
2179: FND_LOG.string( FND_LOG.LEVEL_EXCEPTION

Line 2186: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2182: END IF;
2183:
2184: WHEN OTHERS THEN
2185:
2186: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2187:
2188: IF g_fnd_debug = 'Y' AND
2189: FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
2190: THEN

Line 2333: IF x_return_status = FND_API.G_RET_STS_SUCCESS

2329: || x_return_status);
2330: END IF;
2331:
2332: -- *** vchu: new code 8/18
2333: IF x_return_status = FND_API.G_RET_STS_SUCCESS
2334: THEN
2335: -- Allocate the remaining qty required to the Replenishment SO Lines newly
2336: -- created according to the existing Replenishment PO Shipments with remaining
2337: -- quantity

Line 2406: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2402: EXCEPTION
2403:
2404: WHEN OTHERS THEN
2405:
2406: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2407:
2408: IF g_fnd_debug = 'Y' AND
2409: FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
2410: THEN

Line 2570: IF x_return_status = FND_API.G_RET_STS_SUCCESS

2566: , l_api_name || ': x_return_status = ' || x_return_status);
2567: END IF;
2568:
2569: -- *** vchu: new code 8/18
2570: IF x_return_status = FND_API.G_RET_STS_SUCCESS
2571: AND
2572: Validate_Price
2573: ( p_subcontract_po_shipment_id => p_subcontract_po_shipment_id
2574: , p_component_id => p_component_id

Line 2615: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2611: EXCEPTION
2612:
2613: WHEN OTHERS THEN
2614:
2615: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2616:
2617: IF g_fnd_debug = 'Y' AND
2618: FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
2619: THEN

Line 2902: x_return_status := FND_API.G_RET_STS_ERROR;

2898: EXCEPTION
2899:
2900: WHEN g_no_alloc_found_exc THEN
2901:
2902: x_return_status := FND_API.G_RET_STS_ERROR;
2903: IF g_fnd_debug = 'Y' AND
2904: FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
2905: THEN
2906: FND_LOG.string( FND_LOG.LEVEL_EXCEPTION

Line 2913: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2909: END IF;
2910:
2911: WHEN OTHERS THEN
2912:
2913: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2914:
2915: IF g_fnd_debug = 'Y' AND
2916: FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
2917: THEN

Line 3122: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3118: EXCEPTION
3119:
3120: WHEN OTHERS THEN
3121:
3122: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3123:
3124: IF g_fnd_debug = 'Y' AND
3125: FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
3126: THEN

Line 3291: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3287: EXCEPTION
3288:
3289: WHEN OTHERS THEN
3290:
3291: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3292:
3293: IF g_fnd_debug = 'Y' AND
3294: FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
3295: THEN

Line 3404: IF FND_API.to_boolean(NVL(p_init_msg_list, FND_API.G_FALSE))

3400: , NULL);
3401: END IF;
3402:
3403: -- Start API initialization
3404: IF FND_API.to_boolean(NVL(p_init_msg_list, FND_API.G_FALSE))
3405: THEN
3406: FND_MSG_PUB.initialize;
3407: END IF;
3408:

Line 3409: IF NOT FND_API.Compatible_API_Call( l_api_version

3405: THEN
3406: FND_MSG_PUB.initialize;
3407: END IF;
3408:
3409: IF NOT FND_API.Compatible_API_Call( l_api_version
3410: , p_api_version
3411: , l_api_name
3412: , G_PKG_NAME
3413: )

Line 3415: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3411: , l_api_name
3412: , G_PKG_NAME
3413: )
3414: THEN
3415: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3416: END IF;
3417:
3418: x_return_status := FND_API.G_RET_STS_SUCCESS;
3419:

Line 3418: x_return_status := FND_API.G_RET_STS_SUCCESS;

3414: THEN
3415: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3416: END IF;
3417:
3418: x_return_status := FND_API.G_RET_STS_SUCCESS;
3419:
3420: -- End API initialization
3421:
3422: Select jsr.shikyu_component_id,

Line 3615: x_return_status := FND_API.G_RET_STS_SUCCESS;

3611: IF l_remaining_qty_to_reduce > 0
3612: THEN
3613: RAISE g_qty_not_fully_dealloc_exc;
3614: ELSE
3615: x_return_status := FND_API.G_RET_STS_SUCCESS;
3616: END IF;
3617:
3618: END IF;
3619: END IF;

Line 3637: x_return_status := FND_API.G_RET_STS_ERROR;

3633: ( p_count => x_msg_count
3634: , p_data => x_msg_data
3635: );
3636: */
3637: x_return_status := FND_API.G_RET_STS_ERROR;
3638: IF g_fnd_debug = 'Y' AND
3639: FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
3640: THEN
3641: FND_LOG.string( FND_LOG.LEVEL_EXCEPTION

Line 3647: x_return_status := FND_API.G_RET_STS_ERROR;

3643: , 'No Data Found - Replenishment Sales Order Line: ' || p_replen_order_line_id);
3644: END IF;
3645:
3646: WHEN g_qty_not_fully_dealloc_exc THEN
3647: x_return_status := FND_API.G_RET_STS_ERROR;
3648: IF g_fnd_debug = 'Y' AND
3649: FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
3650: THEN
3651: FND_LOG.string( FND_LOG.LEVEL_EXCEPTION

Line 3659: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3655: END IF;
3656:
3657: WHEN OTHERS THEN
3658:
3659: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3660:
3661: IF g_fnd_debug = 'Y' AND
3662: FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
3663: THEN

Line 3814: x_return_status := FND_API.G_RET_STS_SUCCESS;

3810: , G_MODULE_PREFIX || l_api_name || '.begin'
3811: , NULL);
3812: END IF;
3813:
3814: x_return_status := FND_API.G_RET_STS_SUCCESS;
3815:
3816: -- API Initialization
3817: /*Initialize
3818: ( p_api_version => l_api_version

Line 4369: WHEN FND_API.G_EXC_ERROR THEN

4365: , l_api_name || ' Exit');
4366: END IF;
4367:
4368: EXCEPTION
4369: WHEN FND_API.G_EXC_ERROR THEN
4370:
4371: ROLLBACK;
4372: x_return_status := FND_API.G_RET_STS_ERROR;
4373:

Line 4372: x_return_status := FND_API.G_RET_STS_ERROR;

4368: EXCEPTION
4369: WHEN FND_API.G_EXC_ERROR THEN
4370:
4371: ROLLBACK;
4372: x_return_status := FND_API.G_RET_STS_ERROR;
4373:
4374: IF g_fnd_debug = 'Y' AND
4375: FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
4376: THEN

Line 4379: , l_api_name || ': FND_API.G_EXC_ERROR'

4375: FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
4376: THEN
4377: FND_LOG.string( FND_LOG.LEVEL_EXCEPTION
4378: , G_MODULE_PREFIX || l_api_name || '.g_exc_error'
4379: , l_api_name || ': FND_API.G_EXC_ERROR'
4380: );
4381:
4382: FND_LOG.string( FND_LOG.LEVEL_EXCEPTION
4383: , G_MODULE_PREFIX || l_api_name || '.g_exc_error'

Line 4388: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4384: , l_api_name || ': SQLERRM : '|| SQLERRM
4385: );
4386: END IF;
4387:
4388: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4389:
4390: ROLLBACK ;
4391: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4392:

Line 4391: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4387:
4388: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4389:
4390: ROLLBACK ;
4391: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4392:
4393: IF g_fnd_debug = 'Y' AND
4394: FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
4395: THEN

Line 4398: , l_api_name || ': FND_API.G_EXC_UNEXPECTED_ERROR'

4394: FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
4395: THEN
4396: FND_LOG.string( FND_LOG.LEVEL_EXCEPTION
4397: , G_MODULE_PREFIX || l_api_name || '.g_exc_unexpected_error'
4398: , l_api_name || ': FND_API.G_EXC_UNEXPECTED_ERROR'
4399: );
4400:
4401: FND_LOG.string( FND_LOG.LEVEL_EXCEPTION
4402: , G_MODULE_PREFIX || l_api_name || '.g_exc_unexpected_error'

Line 4410: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4406:
4407: WHEN OTHERS THEN
4408:
4409: ROLLBACK ;
4410: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4411:
4412: IF g_fnd_debug = 'Y' AND
4413: FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
4414: THEN

Line 5219: IF FND_API.to_boolean(NVL(p_init_msg_list, FND_API.G_FALSE)) THEN

5215: END IF;
5216:
5217: -- Start API initialization
5218:
5219: IF FND_API.to_boolean(NVL(p_init_msg_list, FND_API.G_FALSE)) THEN
5220: FND_MSG_PUB.initialize;
5221: END IF;
5222:
5223: IF NOT FND_API.Compatible_API_Call( p_api_version

Line 5223: IF NOT FND_API.Compatible_API_Call( p_api_version

5219: IF FND_API.to_boolean(NVL(p_init_msg_list, FND_API.G_FALSE)) THEN
5220: FND_MSG_PUB.initialize;
5221: END IF;
5222:
5223: IF NOT FND_API.Compatible_API_Call( p_api_version
5224: , p_input_api_version
5225: , p_api_name
5226: , G_PKG_NAME
5227: )

Line 5229: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5225: , p_api_name
5226: , G_PKG_NAME
5227: )
5228: THEN
5229: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5230: END IF;
5231:
5232: x_return_status := FND_API.G_RET_STS_SUCCESS;
5233:

Line 5232: x_return_status := FND_API.G_RET_STS_SUCCESS;

5228: THEN
5229: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5230: END IF;
5231:
5232: x_return_status := FND_API.G_RET_STS_SUCCESS;
5233:
5234: -- End API initialization
5235:
5236: END Initialize;