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;
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;
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;
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;
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;
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;
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;
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;
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;
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
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
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
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;
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
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:
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;