APPS.GME_MOBILE_LOVS dependencies on FND_API

Line 375: WHEN FND_API.G_EXC_UNEXPECTED_ERROR

371:
372: END IF;
373:
374: EXCEPTION
375: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
376: THEN
377: NULL;
378:
379: END Batch_Lov;

Line 631: WHEN FND_API.G_EXC_UNEXPECTED_ERROR

627: ORDER BY line_no;
628: END IF;
629:
630: EXCEPTION
631: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
632: THEN
633: NULL;
634: END Line_Step_LoV;
635:

Line 912: WHEN FND_API.G_EXC_UNEXPECTED_ERROR

908: AND s.oprn_id = o.oprn_id
909: ORDER BY 1;
910:
911: EXCEPTION
912: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
913: THEN
914: NULL;
915: END Step_Ingredient_Lov;
916:

Line 963: WHEN FND_API.G_EXC_UNEXPECTED_ERROR

959: AND s.oprn_id = o.oprn_id
960: ORDER BY 1;
961:
962: EXCEPTION
963: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
964: THEN
965: NULL;
966: END Step_Prod_ByProd_LoV;
967:

Line 1014: WHEN FND_API.G_EXC_UNEXPECTED_ERROR

1010: AND s.oprn_id = o.oprn_id
1011: ORDER BY 1;
1012:
1013: EXCEPTION
1014: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
1015: THEN
1016: NULL;
1017: END Step_Pend_Lot_LoV;
1018:

Line 1064: WHEN FND_API.G_EXC_UNEXPECTED_ERROR

1060: AND s.oprn_id = o.oprn_id
1061: ORDER BY 1;
1062:
1063: EXCEPTION
1064: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
1065: THEN
1066: NULL;
1067: END Step_All_Items_LoV;
1068:

Line 1296: WHEN FND_API.G_EXC_UNEXPECTED_ERROR

1292: OR
1293: mcr.org_independent_flag = 'Y');
1294:
1295: EXCEPTION
1296: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
1297: THEN
1298: NULL;
1299: END Ingredient_LoV;
1300:

Line 1396: WHEN FND_API.G_EXC_UNEXPECTED_ERROR

1392: OR
1393: mcr.org_independent_flag = 'Y');
1394:
1395: EXCEPTION
1396: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
1397: THEN
1398: NULL;
1399: END Ingredient_Rsrv_LoV;
1400:

Line 1580: WHEN FND_API.G_EXC_UNEXPECTED_ERROR

1576: mcr.org_independent_flag = 'Y');
1577: END IF;
1578:
1579: EXCEPTION
1580: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
1581: THEN
1582: NULL;
1583: END Ingredient_Step_LoV;
1584:

Line 1769: WHEN FND_API.G_EXC_UNEXPECTED_ERROR

1765: ORDER BY line_no;
1766: END IF;
1767:
1768: EXCEPTION
1769: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
1770: THEN
1771: NULL;
1772: END Material_Step_LoV;
1773:

Line 1961: WHEN FND_API.G_EXC_UNEXPECTED_ERROR

1957: mcr.org_independent_flag = 'Y');
1958: END IF;
1959:
1960: EXCEPTION
1961: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
1962: THEN
1963: NULL;
1964: END Material_Lot_LoV;
1965:

Line 2151: WHEN FND_API.G_EXC_UNEXPECTED_ERROR

2147: mcr.org_independent_flag = 'Y');
2148: END IF;
2149:
2150: EXCEPTION
2151: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
2152: THEN
2153: NULL;
2154: END Material_Step_For_IB_LoV;
2155:

Line 3882: WHEN FND_API.G_EXC_UNEXPECTED_ERROR

3878: AND r.resources = p_resource
3879: AND r.organization_id = p_organization_id
3880: AND i.instance_number LIKE (p_instance);
3881: EXCEPTION
3882: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
3883: THEN
3884: NULL;
3885: END Resource_Instance_Mst_LoV;
3886:

Line 3938: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3934: AND TO_CHAR(gbs.batchstep_no) LIKE LTRIM(RTRIM(p_step_no||'%'))
3935: AND gbs.oprn_id = gmo.oprn_id
3936: ORDER BY 1;
3937: EXCEPTION
3938: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3939: NULL;
3940: END step_pending_lov;
3941:
3942: /*###############################################################

Line 3969: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3965: AND TO_CHAR(gbs.batchstep_no) LIKE LTRIM(RTRIM(p_step_no||'%'))
3966: AND gbs.oprn_id = gmo.oprn_id
3967: ORDER BY 1;
3968: EXCEPTION
3969: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3970: NULL;
3971: END step_pending_wip_lov;
3972:
3973: /*###############################################################

Line 4020: WHEN FND_API.G_EXC_UNEXPECTED_ERROR

4016: AND u.user_id = r.last_updated_by
4017: ORDER BY r.resources;
4018:
4019: EXCEPTION
4020: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
4021: THEN
4022: NULL;
4023: END Resource_MsT_LoV;
4024:

Line 4081: WHEN FND_API.G_EXC_UNEXPECTED_ERROR

4077: AND u.user_id = rt.last_updated_by
4078: ORDER BY r.resources;
4079:
4080: EXCEPTION
4081: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
4082: THEN
4083: NULL;
4084: END Resource_Txn_LoV;
4085: