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 1154: x_return_status := FND_API.G_RET_STS_ERROR;

1150: EXCEPTION
1151:
1152: WHEN g_no_wip_job_found_exc THEN
1153:
1154: x_return_status := FND_API.G_RET_STS_ERROR;
1155: IF g_fnd_debug = 'Y' AND
1156: FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
1157: THEN
1158: FND_LOG.string( FND_LOG.LEVEL_EXCEPTION

Line 1166: x_return_status := FND_API.G_RET_STS_ERROR;

1162: END IF;
1163:
1164: WHEN g_no_ship_method_found_exc THEN
1165:
1166: x_return_status := FND_API.G_RET_STS_ERROR;
1167: IF g_fnd_debug = 'Y' AND
1168: FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
1169: THEN
1170: FND_LOG.string( FND_LOG.LEVEL_EXCEPTION

Line 1178: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1174: END IF;
1175:
1176: WHEN OTHERS THEN
1177:
1178: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1179:
1180: IF g_fnd_debug = 'Y' AND
1181: FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
1182: THEN

Line 1445: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1441: EXCEPTION
1442:
1443: WHEN OTHERS THEN
1444:
1445: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1446:
1447: IF g_fnd_debug = 'Y' AND
1448: FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
1449: THEN

Line 1539: IF x_return_status <> FND_API.G_RET_STS_SUCCESS

1535: || ', x_po_line_location_id = ' || l_new_replen_po_shipment_id);
1536: END IF;
1537:
1538: -- *** vchu: new code 8/18
1539: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
1540: THEN
1541:
1542: RAISE g_process_replen_po_exc;
1543:

Line 1626: IF x_return_status <> FND_API.G_RET_STS_SUCCESS

1622: || x_return_status);
1623: END IF;
1624:
1625: -- *** vchu: new code 8/18
1626: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
1627: THEN
1628:
1629: RAISE g_process_replen_so_exc;
1630:

Line 1688: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1684: END IF;
1685:
1686: WHEN OTHERS THEN
1687:
1688: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1689:
1690: IF g_fnd_debug = 'Y' AND
1691: FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
1692: THEN

Line 1901: IF x_return_status <> FND_API.G_RET_STS_SUCCESS

1897: , x_return_status => x_return_status
1898: );
1899:
1900: -- *** vchu: new code 8/18
1901: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
1902: THEN
1903:
1904: RAISE g_process_replen_so_exc;
1905:

Line 1999: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1995: END IF;
1996:
1997: WHEN OTHERS THEN
1998:
1999: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2000:
2001: IF g_fnd_debug = 'Y' AND
2002: FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
2003: THEN

Line 2169: x_return_status := FND_API.G_RET_STS_ERROR;

2165: EXCEPTION
2166:
2167: WHEN NO_DATA_FOUND THEN
2168:
2169: x_return_status := FND_API.G_RET_STS_ERROR;
2170: IF g_fnd_debug = 'Y' AND
2171: FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
2172: THEN
2173: FND_LOG.string( FND_LOG.LEVEL_EXCEPTION

Line 2181: x_return_status := FND_API.G_RET_STS_ERROR;

2177: END IF;
2178:
2179: WHEN g_non_shikyu_component_exc THEN
2180:
2181: x_return_status := FND_API.G_RET_STS_ERROR;
2182: IF g_fnd_debug = 'Y' AND
2183: FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
2184: THEN
2185: FND_LOG.string( FND_LOG.LEVEL_EXCEPTION

Line 2192: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2188: END IF;
2189:
2190: WHEN OTHERS THEN
2191:
2192: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2193:
2194: IF g_fnd_debug = 'Y' AND
2195: FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
2196: THEN

Line 2339: IF x_return_status = FND_API.G_RET_STS_SUCCESS

2335: || x_return_status);
2336: END IF;
2337:
2338: -- *** vchu: new code 8/18
2339: IF x_return_status = FND_API.G_RET_STS_SUCCESS
2340: THEN
2341: -- Allocate the remaining qty required to the Replenishment SO Lines newly
2342: -- created according to the existing Replenishment PO Shipments with remaining
2343: -- quantity

Line 2412: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2408: EXCEPTION
2409:
2410: WHEN OTHERS THEN
2411:
2412: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2413:
2414: IF g_fnd_debug = 'Y' AND
2415: FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
2416: THEN

Line 2576: IF x_return_status = FND_API.G_RET_STS_SUCCESS

2572: , l_api_name || ': x_return_status = ' || x_return_status);
2573: END IF;
2574:
2575: -- *** vchu: new code 8/18
2576: IF x_return_status = FND_API.G_RET_STS_SUCCESS
2577: AND
2578: Validate_Price
2579: ( p_subcontract_po_shipment_id => p_subcontract_po_shipment_id
2580: , p_component_id => p_component_id

Line 2621: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2617: EXCEPTION
2618:
2619: WHEN OTHERS THEN
2620:
2621: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2622:
2623: IF g_fnd_debug = 'Y' AND
2624: FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
2625: THEN

Line 2913: x_return_status := FND_API.G_RET_STS_ERROR;

2909: EXCEPTION
2910:
2911: WHEN g_no_alloc_found_exc THEN
2912:
2913: x_return_status := FND_API.G_RET_STS_ERROR;
2914: IF g_fnd_debug = 'Y' AND
2915: FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
2916: THEN
2917: FND_LOG.string( FND_LOG.LEVEL_EXCEPTION

Line 2924: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2920: END IF;
2921:
2922: WHEN OTHERS THEN
2923:
2924: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2925:
2926: IF g_fnd_debug = 'Y' AND
2927: FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
2928: THEN

Line 3141: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3137: EXCEPTION
3138:
3139: WHEN OTHERS THEN
3140:
3141: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3142:
3143: IF g_fnd_debug = 'Y' AND
3144: FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
3145: THEN

Line 3379: IF x_return_status <> FND_API.G_RET_STS_SUCCESS

3375: , p_excess_qty => l_closed_so_line_rec.primary_uom_qty - l_ordered_primary_qty
3376: */
3377: );
3378:
3379: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
3380: THEN
3381: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
3382: THEN
3383: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

Line 3445: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3441: EXCEPTION
3442:
3443: WHEN OTHERS THEN
3444: rollback;
3445: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3446:
3447: IF g_fnd_debug = 'Y' AND
3448: FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
3449: THEN

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

3558: ':p_excess_qty:' || p_excess_qty);
3559: END IF;
3560:
3561: -- Start API initialization
3562: IF FND_API.to_boolean(NVL(p_init_msg_list, FND_API.G_FALSE))
3563: THEN
3564: FND_MSG_PUB.initialize;
3565: END IF;
3566:

Line 3567: IF NOT FND_API.Compatible_API_Call( l_api_version

3563: THEN
3564: FND_MSG_PUB.initialize;
3565: END IF;
3566:
3567: IF NOT FND_API.Compatible_API_Call( l_api_version
3568: , p_api_version
3569: , l_api_name
3570: , G_PKG_NAME
3571: )

Line 3573: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3569: , l_api_name
3570: , G_PKG_NAME
3571: )
3572: THEN
3573: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3574: END IF;
3575:
3576: x_return_status := FND_API.G_RET_STS_SUCCESS;
3577:

Line 3576: x_return_status := FND_API.G_RET_STS_SUCCESS;

3572: THEN
3573: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3574: END IF;
3575:
3576: x_return_status := FND_API.G_RET_STS_SUCCESS;
3577:
3578: -- End API initialization
3579:
3580: Select jsr.shikyu_component_id,

Line 3936: x_return_status := FND_API.G_RET_STS_SUCCESS;

3932: IF l_remaining_qty_to_reduce > 0
3933: THEN
3934: RAISE g_qty_not_fully_dealloc_exc;
3935: ELSE
3936: x_return_status := FND_API.G_RET_STS_SUCCESS;
3937: END IF;
3938:
3939: END IF;
3940: END IF;

Line 3958: x_return_status := FND_API.G_RET_STS_ERROR;

3954: ( p_count => x_msg_count
3955: , p_data => x_msg_data
3956: );
3957: */
3958: x_return_status := FND_API.G_RET_STS_ERROR;
3959: IF g_fnd_debug = 'Y' AND
3960: FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
3961: THEN
3962: FND_LOG.string( FND_LOG.LEVEL_EXCEPTION

Line 3968: x_return_status := FND_API.G_RET_STS_ERROR;

3964: , 'No Data Found - Replenishment Sales Order Line: ' || p_replen_order_line_id);
3965: END IF;
3966:
3967: WHEN g_qty_not_fully_dealloc_exc THEN
3968: x_return_status := FND_API.G_RET_STS_ERROR;
3969: IF g_fnd_debug = 'Y' AND
3970: FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
3971: THEN
3972: FND_LOG.string( FND_LOG.LEVEL_EXCEPTION

Line 3980: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3976: END IF;
3977:
3978: WHEN OTHERS THEN
3979:
3980: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3981:
3982: IF g_fnd_debug = 'Y' AND
3983: FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
3984: THEN

Line 4144: x_return_status := FND_API.G_RET_STS_SUCCESS;

4140: ,G_MODULE_PREFIX || l_api_name
4141: ,'Begin');
4142: END IF;
4143:
4144: x_return_status := FND_API.G_RET_STS_SUCCESS;
4145:
4146: -- API Initialization
4147: /*Initialize
4148: ( p_api_version => l_api_version

Line 4364: IF l_return_status <> FND_API.G_RET_STS_SUCCESS

4360: C_SHIKYU_REPLENISHMENT_rec.REPLENISHMENT_SO_LINE_ID
4361: , x_deleted_allocations_tbl => l_deleted_allocations_tbl
4362: );
4363:
4364: IF l_return_status <> FND_API.G_RET_STS_SUCCESS
4365: THEN
4366: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
4367: THEN
4368: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

Line 4558: IF l_return_status <> FND_API.G_RET_STS_SUCCESS

4554: , x_reduced_allocations_tbl => l_reduced_allocations_tbl
4555: , x_actual_reduced_qty => l_decreased_qty
4556: );
4557:
4558: IF l_return_status <> FND_API.G_RET_STS_SUCCESS
4559: THEN
4560: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
4561: THEN
4562: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

Line 4829: WHEN FND_API.G_EXC_ERROR THEN

4825: , 'Exit');
4826: END IF;
4827:
4828: EXCEPTION
4829: WHEN FND_API.G_EXC_ERROR THEN
4830: ROLLBACK;
4831: x_return_status := FND_API.G_RET_STS_ERROR;
4832:
4833: IF g_fnd_debug = 'Y' AND FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL

Line 4831: x_return_status := FND_API.G_RET_STS_ERROR;

4827:
4828: EXCEPTION
4829: WHEN FND_API.G_EXC_ERROR THEN
4830: ROLLBACK;
4831: x_return_status := FND_API.G_RET_STS_ERROR;
4832:
4833: IF g_fnd_debug = 'Y' AND FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
4834: THEN
4835: FND_LOG.string( FND_LOG.LEVEL_EXCEPTION

Line 4841: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4837: , 'ERROR::' || sqlerrm
4838: );
4839: END IF;
4840:
4841: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4842: ROLLBACK ;
4843: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4844:
4845: IF g_fnd_debug = 'Y' AND FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL

Line 4843: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4839: END IF;
4840:
4841: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4842: ROLLBACK ;
4843: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4844:
4845: IF g_fnd_debug = 'Y' AND FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
4846: THEN
4847: FND_LOG.string( FND_LOG.LEVEL_EXCEPTION

Line 4855: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4851: END IF;
4852:
4853: WHEN OTHERS THEN
4854: ROLLBACK ;
4855: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4856:
4857: IF g_fnd_debug = 'Y' AND FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
4858: THEN
4859: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED

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

5659: END IF;
5660:
5661: -- Start API initialization
5662:
5663: IF FND_API.to_boolean(NVL(p_init_msg_list, FND_API.G_FALSE)) THEN
5664: FND_MSG_PUB.initialize;
5665: END IF;
5666:
5667: IF NOT FND_API.Compatible_API_Call( p_api_version

Line 5667: IF NOT FND_API.Compatible_API_Call( p_api_version

5663: IF FND_API.to_boolean(NVL(p_init_msg_list, FND_API.G_FALSE)) THEN
5664: FND_MSG_PUB.initialize;
5665: END IF;
5666:
5667: IF NOT FND_API.Compatible_API_Call( p_api_version
5668: , p_input_api_version
5669: , p_api_name
5670: , G_PKG_NAME
5671: )

Line 5673: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5669: , p_api_name
5670: , G_PKG_NAME
5671: )
5672: THEN
5673: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5674: END IF;
5675:
5676: x_return_status := FND_API.G_RET_STS_SUCCESS;
5677:

Line 5676: x_return_status := FND_API.G_RET_STS_SUCCESS;

5672: THEN
5673: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5674: END IF;
5675:
5676: x_return_status := FND_API.G_RET_STS_SUCCESS;
5677:
5678: -- End API initialization
5679:
5680: END Initialize;

Line 5734: x_return_status := FND_API.G_RET_STS_SUCCESS;

5730: ,G_MODULE_PREFIX || l_api_name
5731: ,'Begin');
5732: end if;
5733:
5734: x_return_status := FND_API.G_RET_STS_SUCCESS;
5735:
5736: for so_date_change_rec in c_so_date_changes_cur loop
5737: if g_fnd_debug = 'Y' AND FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
5738: then

Line 5822: if l_return_status <> FND_API.G_RET_STS_SUCCESS

5818: , p_replen_so_line_id => l_line_id
5819: , x_deleted_allocations_tbl => l_deleted_allocations_tbl
5820: );
5821:
5822: if l_return_status <> FND_API.G_RET_STS_SUCCESS
5823: then
5824: if FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
5825: then
5826: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

Line 5889: if l_return_status <> FND_API.G_RET_STS_SUCCESS

5885: , p_qty => l_deleted_qty --check if this needs to be in puom
5886: , p_skip_po_replen_creation => 'N'
5887: );
5888:
5889: if l_return_status <> FND_API.G_RET_STS_SUCCESS
5890: then
5891: if FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
5892: then
5893: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

Line 5941: WHEN FND_API.G_EXC_ERROR THEN

5937: end if; --om_schedule_ship_date > jmf_schedule_ship_date
5938: end loop;
5939:
5940: exception
5941: WHEN FND_API.G_EXC_ERROR THEN
5942: -- dbms_output.put_line(' EXCEPTION: FND_API.G_EXC_ERROR ');
5943: -- dbms_output.put_line(' SQLERRM : '|| SQLERRM );
5944:
5945: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 5942: -- dbms_output.put_line(' EXCEPTION: FND_API.G_EXC_ERROR ');

5938: end loop;
5939:
5940: exception
5941: WHEN FND_API.G_EXC_ERROR THEN
5942: -- dbms_output.put_line(' EXCEPTION: FND_API.G_EXC_ERROR ');
5943: -- dbms_output.put_line(' SQLERRM : '|| SQLERRM );
5944:
5945: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5946: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

Line 5956: x_return_status := FND_API.g_ret_sts_error;

5952: FND_MSG_PUB.Count_And_Get
5953: ( p_count => l_msg_count
5954: , p_data => l_msg_data
5955: );
5956: x_return_status := FND_API.g_ret_sts_error;
5957:
5958: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5959: -- dbms_output.put_line(' EXCEPTION: FND_API.G_EXC_UNEXPECTED_ERROR ');
5960: -- dbms_output.put_line(' SQLERRM : '|| SQLERRM );

Line 5958: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5954: , p_data => l_msg_data
5955: );
5956: x_return_status := FND_API.g_ret_sts_error;
5957:
5958: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5959: -- dbms_output.put_line(' EXCEPTION: FND_API.G_EXC_UNEXPECTED_ERROR ');
5960: -- dbms_output.put_line(' SQLERRM : '|| SQLERRM );
5961:
5962: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 5959: -- dbms_output.put_line(' EXCEPTION: FND_API.G_EXC_UNEXPECTED_ERROR ');

5955: );
5956: x_return_status := FND_API.g_ret_sts_error;
5957:
5958: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5959: -- dbms_output.put_line(' EXCEPTION: FND_API.G_EXC_UNEXPECTED_ERROR ');
5960: -- dbms_output.put_line(' SQLERRM : '|| SQLERRM );
5961:
5962: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5963: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

Line 5974: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

5970: ( p_count => l_msg_count
5971: , p_data => l_msg_data
5972: );
5973:
5974: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5975:
5976: WHEN OTHERS THEN
5977:
5978: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 5990: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

5986: ( p_count => l_msg_count
5987: , p_data => l_msg_data
5988: );
5989:
5990: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5991:
5992: end reconcile_rso_date_changes;
5993:
5994: END JMF_SHIKYU_ALLOCATION_PVT;