70: BEGIN
71:
72: INV_MGD_MVT_UTILS_PKG.Log_Initialize;
73:
74: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
75: THEN
76: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
77: , G_MODULE_NAME || l_procedure_name || '.begin'
78: ,'enter procedure'
72: INV_MGD_MVT_UTILS_PKG.Log_Initialize;
73:
74: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
75: THEN
76: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
77: , G_MODULE_NAME || l_procedure_name || '.begin'
78: ,'enter procedure'
79: );
80: END IF;
138:
139:
140: -- RETURN setup_crsr;
141:
142: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
143: THEN
144: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
145: , G_MODULE_NAME || l_procedure_name || '.end'
146: ,'exit procedure'
140: -- RETURN setup_crsr;
141:
142: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
143: THEN
144: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
145: , G_MODULE_NAME || l_procedure_name || '.end'
146: ,'exit procedure'
147: );
148: END IF;
205: l_msg_data VARCHAR2(100);
206: l_procedure_name CONSTANT VARCHAR2(30) := 'Get_Setup_Context';
207:
208: BEGIN
209: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
210: THEN
211: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
212: , G_MODULE_NAME || l_procedure_name || '.begin'
213: ,'enter procedure'
207:
208: BEGIN
209: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
210: THEN
211: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
212: , G_MODULE_NAME || l_procedure_name || '.begin'
213: ,'enter procedure'
214: );
215: END IF;
232: FROM
233: MTL_STAT_TYPE_USAGES mstat
234: WHERE mstat.legal_entity_id = p_legal_entity_id;
235:
236: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
237: THEN
238: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
239: , G_MODULE_NAME || l_procedure_name || '.end'
240: ,'exit procedure'
234: WHERE mstat.legal_entity_id = p_legal_entity_id;
235:
236: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
237: THEN
238: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
239: , G_MODULE_NAME || l_procedure_name || '.end'
240: ,'exit procedure'
241: );
242: END IF;
303: l_transaction_date DATE;
304: l_procedure_name CONSTANT VARCHAR2(30) := 'Get_Invoice_Context';
305:
306: BEGIN
307: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
308: THEN
309: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
310: , G_MODULE_NAME || l_procedure_name || '.begin'
311: ,'enter procedure'
305:
306: BEGIN
307: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
308: THEN
309: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
310: , G_MODULE_NAME || l_procedure_name || '.begin'
311: ,'enter procedure'
312: );
313: END IF;
362: AND mstat.stat_type = p_movement_transaction.stat_type;
363:
364: -- RETURN setup_crsr;
365:
366: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
367: THEN
368: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
369: , G_MODULE_NAME || l_procedure_name || '.end'
370: ,'exit procedure'
364: -- RETURN setup_crsr;
365:
366: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
367: THEN
368: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
369: , G_MODULE_NAME || l_procedure_name || '.end'
370: ,'exit procedure'
371: );
372: END IF;
429: l_ship_to_loc VARCHAR2(10);
430: l_procedure_name CONSTANT VARCHAR2(30) := 'Process_Setup_Context';
431:
432: BEGIN
433: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
434: THEN
435: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
436: , G_MODULE_NAME || l_procedure_name || '.begin'
437: ,'enter procedure'
431:
432: BEGIN
433: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
434: THEN
435: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
436: , G_MODULE_NAME || l_procedure_name || '.begin'
437: ,'enter procedure'
438: );
439: END IF;
514: ELSE
515: l_insert_flag := 'N';
516: END IF;
517:
518: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
519: THEN
520: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
521: , G_MODULE_NAME || l_procedure_name || '.end'
522: ,'exit procedure'
516: END IF;
517:
518: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
519: THEN
520: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
521: , G_MODULE_NAME || l_procedure_name || '.end'
522: ,'exit procedure'
523: );
524: END IF;
556: IS
557: l_api_version_number CONSTANT NUMBER := 1.0;
558: l_procedure_name CONSTANT VARCHAR2(30):= 'Get_Movement_Stat_Usages';
559: BEGIN
560: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
561: THEN
562: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
563: , G_MODULE_NAME || l_procedure_name || '.begin'
564: ,'enter procedure'
558: l_procedure_name CONSTANT VARCHAR2(30):= 'Get_Movement_Stat_Usages';
559: BEGIN
560: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
561: THEN
562: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
563: , G_MODULE_NAME || l_procedure_name || '.begin'
564: ,'enter procedure'
565: );
566: END IF;
616: ( p_count => x_msg_count
617: , p_data => x_msg_data
618: );
619:
620: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
621: THEN
622: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
623: , G_MODULE_NAME || l_procedure_name || '.end'
624: ,'exit procedure'
618: );
619:
620: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
621: THEN
622: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
623: , G_MODULE_NAME || l_procedure_name || '.end'
624: ,'exit procedure'
625: );
626: END IF;