APPS.GMI_MSCA_PUB dependencies on FND_API

Line 101: WHEN FND_API.G_EXC_UNEXPECTED_ERROR

97: WHERE 1=2;
98: END IF;
99:
100: EXCEPTION
101: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
102: THEN
103: NULL;
104:
105: END item_no_lov;

Line 145: WHEN FND_API.G_EXC_UNEXPECTED_ERROR

141: AND NOT EXISTS(select location from ic_loct_mst where location = l.location)
142: ORDER BY 1;
143:
144: EXCEPTION
145: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
146: THEN
147: NULL;
148:
149: END loct_lov;

Line 227: WHEN FND_API.G_EXC_UNEXPECTED_ERROR

223: AND m.delete_mark = 0
224: ORDER BY m.orgn_code;
225:
226: EXCEPTION
227: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
228: THEN
229: NULL;
230:
231: END orgn_lov;

Line 261: WHEN FND_API.G_EXC_UNEXPECTED_ERROR

257: AND reason_code LIKE UPPER(p_reason)
258: ORDER BY 1 ;
259:
260: EXCEPTION
261: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
262: THEN
263: NULL;
264:
265: END reason_lov;

Line 292: WHEN FND_API.G_EXC_UNEXPECTED_ERROR

288: AND A.delete_mark = 0
289: ORDER BY 1, 2;
290:
291: EXCEPTION
292: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
293: THEN
294: NULL;
295:
296: END sublot_lov;

Line 324: WHEN FND_API.G_EXC_UNEXPECTED_ERROR

320: AND item_um like p_uom
321: ORDER BY 1;
322:
323: EXCEPTION
324: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
325: THEN
326: NULL;
327:
328: END uom_lov;

Line 380: WHEN FND_API.G_EXC_UNEXPECTED_ERROR

376: WHERE 1=2;
377: END IF;
378: END IF;
379: EXCEPTION
380: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
381: THEN
382: NULL;
383:
384: END whse_lov;

Line 420: WHEN FND_API.G_EXC_UNEXPECTED_ERROR

416: WHERE 1=2;
417: END IF;
418:
419: EXCEPTION
420: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
421: THEN
422: NULL;
423:
424: END to_whse_lov;

Line 469: WHEN FND_API.G_EXC_UNEXPECTED_ERROR

465: AND NOT EXISTS(select location from ic_loct_mst where location = l.location)
466: ORDER BY 1;
467:
468: EXCEPTION
469: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
470: THEN
471: NULL;
472:
473: END to_loct_lov;

Line 614: , p_init_msg_list => FND_API.G_TRUE

610: print_debug('in Create_Transaction calling GMIPAPI.Inventory_Posting');
611:
612: GMIPAPI.Inventory_Posting
613: ( p_api_version => 3.0
614: , p_init_msg_list => FND_API.G_TRUE
615: , p_commit => FND_API.G_FALSE
616: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
617: , p_qty_rec => l_qty_rec
618: , x_ic_jrnl_mst_row => l_ic_jrnl_mst_row

Line 615: , p_commit => FND_API.G_FALSE

611:
612: GMIPAPI.Inventory_Posting
613: ( p_api_version => 3.0
614: , p_init_msg_list => FND_API.G_TRUE
615: , p_commit => FND_API.G_FALSE
616: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
617: , p_qty_rec => l_qty_rec
618: , x_ic_jrnl_mst_row => l_ic_jrnl_mst_row
619: , x_ic_adjs_jnl_row1 => l_ic_adjs_jnl_row1

Line 616: , p_validation_level => FND_API.G_VALID_LEVEL_FULL

612: GMIPAPI.Inventory_Posting
613: ( p_api_version => 3.0
614: , p_init_msg_list => FND_API.G_TRUE
615: , p_commit => FND_API.G_FALSE
616: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
617: , p_qty_rec => l_qty_rec
618: , x_ic_jrnl_mst_row => l_ic_jrnl_mst_row
619: , x_ic_adjs_jnl_row1 => l_ic_adjs_jnl_row1
620: , x_ic_adjs_jnl_row2 => l_ic_adjs_jnl_row2

Line 627: IF l_return_status = fnd_api.g_ret_sts_success

623: , x_msg_data => l_msg_data);
624:
625: print_debug('in Create_Transaction after GMIPAPI.Inventory_Posting');
626:
627: IF l_return_status = fnd_api.g_ret_sts_success
628: THEN
629: print_debug('SUCCESS....');
630: x_return_value := 0;
631: COMMIT;

Line 641: , p_encoded => fnd_api.g_false

637: LOOP
638: FND_MSG_PUB.get
639: ( p_msg_index => i
640: , p_data => l_message
641: , p_encoded => fnd_api.g_false
642: , p_msg_index_out => l_count
643: );
644:
645: IF i = 1

Line 705: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

701:
702: IF (get_lot_stat%NOTFOUND)
703: THEN
704: CLOSE get_lot_stat;
705: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
706: END IF;
707:
708: CLOSE get_lot_stat;
709:

Line 711: WHEN FND_API.G_EXC_UNEXPECTED_ERROR

707:
708: CLOSE get_lot_stat;
709:
710: EXCEPTION
711: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
712: THEN
713: x_lot_status := NULL;
714:
715: END get_lot_status;