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.INV_MGD_MVT_STATS_PROC dependencies on FND_LOG

Line 84: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

80: l_insert_status VARCHAR2(10);
81: l_stat_typ_transaction INV_MGD_MVT_DATA_STR.Movement_Stat_Usages_Rec_Type;
82: l_return_status VARCHAR2(1);
83: BEGIN
84: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
85: THEN
86: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
87: , G_MODULE_NAME || l_api_name || '.begin'
88: ,'enter procedure'

Line 86: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

82: l_return_status VARCHAR2(1);
83: BEGIN
84: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
85: THEN
86: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
87: , G_MODULE_NAME || l_api_name || '.begin'
88: ,'enter procedure'
89: );
90: END IF;

Line 104: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

100: );
101:
102: IF l_return_status <> FND_API.G_RET_STS_SUCCESS
103: THEN
104: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
105: THEN
106: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
107: , G_MODULE_NAME || l_api_name
108: || '.Failed when call mvt_stats_util_info'

Line 106: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED

102: IF l_return_status <> FND_API.G_RET_STS_SUCCESS
103: THEN
104: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
105: THEN
106: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
107: , G_MODULE_NAME || l_api_name
108: || '.Failed when call mvt_stats_util_info'
109: ,'Failed'
110: );

Line 156: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

152: g_records_processed := g_records_processed +1;
153: g_records_inserted := g_records_inserted +1;
154: l_movement_transaction := p_movement_transaction;
155:
156: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
157: THEN
158: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
159: , G_MODULE_NAME || l_api_name || '.end'
160: ,'exit procedure'

Line 158: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

154: l_movement_transaction := p_movement_transaction;
155:
156: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
157: THEN
158: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
159: , G_MODULE_NAME || l_api_name || '.end'
160: ,'exit procedure'
161: );
162: END IF;

Line 169: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

165: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
166: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
167: l_error := SUBSTRB(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE),1,250);
168:
169: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
170: THEN
171: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
172: , G_MODULE_NAME || l_api_name||'. Unexpected exception'
173: , l_error

Line 171: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED

167: l_error := SUBSTRB(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE),1,250);
168:
169: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
170: THEN
171: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
172: , G_MODULE_NAME || l_api_name||'. Unexpected exception'
173: , l_error
174: );
175: END IF;

Line 178: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

174: );
175: END IF;
176:
177: WHEN NO_DATA_FOUND THEN
178: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
179: THEN
180: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
181: , G_MODULE_NAME || l_api_name||'. No data found exception'
182: , l_error

Line 180: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED

176:
177: WHEN NO_DATA_FOUND THEN
178: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
179: THEN
180: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
181: , G_MODULE_NAME || l_api_name||'. No data found exception'
182: , l_error
183: );
184: END IF;

Line 195: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

191: , 'Others exception in '||l_api_name
192: );
193: END IF;
194:
195: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
196: THEN
197: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
198: , G_MODULE_NAME || l_api_name||'. Others exception'
199: , l_error

Line 197: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED

193: END IF;
194:
195: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
196: THEN
197: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
198: , G_MODULE_NAME || l_api_name||'. Others exception'
199: , l_error
200: );
201: END IF;

Line 243: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

239: l_api_name CONSTANT VARCHAR2(30) := 'Process_Transaction';
240: l_debug CONSTANT VARCHAR2(1) := NVL(FND_PROFILE.Value('AFLOG_ENABLED'),'N');
241: l_error VARCHAR2(600);
242: BEGIN
243: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
244: THEN
245: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
246: , G_MODULE_NAME || l_api_name || '.begin'
247: ,'enter procedure'

Line 245: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

241: l_error VARCHAR2(600);
242: BEGIN
243: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
244: THEN
245: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
246: , G_MODULE_NAME || l_api_name || '.begin'
247: ,'enter procedure'
248: );
249: END IF;

Line 271: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

267: );
268:
269: IF l_return_status <> FND_API.G_RET_STS_SUCCESS
270: THEN
271: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
272: THEN
273: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
274: , G_MODULE_NAME || l_api_name
275: || '.Failed in process_inv_transaction'

Line 273: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED

269: IF l_return_status <> FND_API.G_RET_STS_SUCCESS
270: THEN
271: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
272: THEN
273: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
274: , G_MODULE_NAME || l_api_name
275: || '.Failed in process_inv_transaction'
276: ,'Failed'
277: );

Line 298: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

294: );
295:
296: IF l_return_status <> FND_API.G_RET_STS_SUCCESS
297: THEN
298: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
299: THEN
300: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
301: , G_MODULE_NAME || l_api_name
302: || '.Failed in Update_Invoice_Info'

Line 300: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED

296: IF l_return_status <> FND_API.G_RET_STS_SUCCESS
297: THEN
298: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
299: THEN
300: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
301: , G_MODULE_NAME || l_api_name
302: || '.Failed in Update_Invoice_Info'
303: ,'Failed'
304: );

Line 321: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

317: );
318:
319: IF l_return_status <> FND_API.G_RET_STS_SUCCESS
320: THEN
321: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
322: THEN
323: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
324: , G_MODULE_NAME || l_api_name
325: || '.Failed in Process_Pending_Transactions'

Line 323: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED

319: IF l_return_status <> FND_API.G_RET_STS_SUCCESS
320: THEN
321: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
322: THEN
323: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
324: , G_MODULE_NAME || l_api_name
325: || '.Failed in Process_Pending_Transactions'
326: ,'Failed'
327: );

Line 347: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

343: );
344:
345: IF l_return_status <> FND_API.G_RET_STS_SUCCESS
346: THEN
347: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
348: THEN
349: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
350: , G_MODULE_NAME || l_api_name
351: || '.Failed in Process_SO_Transaction'

Line 349: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED

345: IF l_return_status <> FND_API.G_RET_STS_SUCCESS
346: THEN
347: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
348: THEN
349: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
350: , G_MODULE_NAME || l_api_name
351: || '.Failed in Process_SO_Transaction'
352: ,'Failed'
353: );

Line 369: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

365: );
366:
367: IF l_return_status <> FND_API.G_RET_STS_SUCCESS
368: THEN
369: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
370: THEN
371: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
372: , G_MODULE_NAME || l_api_name
373: || '.Failed in Process_Triangulation_Txn'

Line 371: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED

367: IF l_return_status <> FND_API.G_RET_STS_SUCCESS
368: THEN
369: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
370: THEN
371: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
372: , G_MODULE_NAME || l_api_name
373: || '.Failed in Process_Triangulation_Txn'
374: ,'Failed'
375: );

Line 395: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

391: );
392:
393: IF l_return_status <> FND_API.G_RET_STS_SUCCESS
394: THEN
395: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
396: THEN
397: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
398: , G_MODULE_NAME || l_api_name
399: || '.Failed in Process_SO_Trangsaction - IO'

Line 397: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED

393: IF l_return_status <> FND_API.G_RET_STS_SUCCESS
394: THEN
395: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
396: THEN
397: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
398: , G_MODULE_NAME || l_api_name
399: || '.Failed in Process_SO_Trangsaction - IO'
400: ,'Failed'
401: );

Line 416: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

412: );
413:
414: IF l_return_status <> FND_API.G_RET_STS_SUCCESS
415: THEN
416: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
417: THEN
418: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
419: , G_MODULE_NAME || l_api_name
420: || '.Failed in Process_IO_Arrival_Txn'

Line 418: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED

414: IF l_return_status <> FND_API.G_RET_STS_SUCCESS
415: THEN
416: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
417: THEN
418: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
419: , G_MODULE_NAME || l_api_name
420: || '.Failed in Process_IO_Arrival_Txn'
421: ,'Failed'
422: );

Line 442: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

438: );
439:
440: IF l_return_status <> FND_API.G_RET_STS_SUCCESS
441: THEN
442: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
443: THEN
444: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
445: , G_MODULE_NAME || l_api_name
446: || '.Failed in Update_PO_With_Correction'

Line 444: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED

440: IF l_return_status <> FND_API.G_RET_STS_SUCCESS
441: THEN
442: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
443: THEN
444: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
445: , G_MODULE_NAME || l_api_name
446: || '.Failed in Update_PO_With_Correction'
447: ,'Failed'
448: );

Line 463: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

459: );
460:
461: IF l_return_status <> FND_API.G_RET_STS_SUCCESS
462: THEN
463: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
464: THEN
465: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
466: , G_MODULE_NAME || l_api_name
467: || '.Failed in Process_PO_Transaction'

Line 465: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED

461: IF l_return_status <> FND_API.G_RET_STS_SUCCESS
462: THEN
463: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
464: THEN
465: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
466: , G_MODULE_NAME || l_api_name
467: || '.Failed in Process_PO_Transaction'
468: ,'Failed'
469: );

Line 489: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

485: );
486:
487: IF l_return_status <> FND_API.G_RET_STS_SUCCESS
488: THEN
489: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
490: THEN
491: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
492: , G_MODULE_NAME || l_api_name
493: || '.Failed in Process_RMA_Transaction'

Line 491: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED

487: IF l_return_status <> FND_API.G_RET_STS_SUCCESS
488: THEN
489: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
490: THEN
491: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
492: , G_MODULE_NAME || l_api_name
493: || '.Failed in Process_RMA_Transaction'
494: ,'Failed'
495: );

Line 516: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

512: , '< ***** Records Inserted: '||g_records_inserted
513: );
514: END IF;
515:
516: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
517: THEN
518: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
519: , G_MODULE_NAME || l_api_name || '.end'
520: ,'exit procedure'

Line 518: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

514: END IF;
515:
516: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
517: THEN
518: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
519: , G_MODULE_NAME || l_api_name || '.end'
520: ,'exit procedure'
521: );
522: END IF;

Line 529: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

525: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
526: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
527: l_error := SUBSTRB(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE),1,250);
528:
529: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
530: THEN
531: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
532: , G_MODULE_NAME || l_api_name||'. Unexpected exception'
533: , l_error

Line 531: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED

527: l_error := SUBSTRB(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE),1,250);
528:
529: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
530: THEN
531: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
532: , G_MODULE_NAME || l_api_name||'. Unexpected exception'
533: , l_error
534: );
535: END IF;

Line 538: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

534: );
535: END IF;
536:
537: WHEN NO_DATA_FOUND THEN
538: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
539: THEN
540: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
541: , G_MODULE_NAME || l_api_name||'. No data found exception'
542: , l_error

Line 540: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED

536:
537: WHEN NO_DATA_FOUND THEN
538: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
539: THEN
540: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
541: , G_MODULE_NAME || l_api_name||'. No data found exception'
542: , l_error
543: );
544: END IF;

Line 555: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

551: , 'Others exception in '||l_api_name
552: );
553: END IF;
554:
555: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
556: THEN
557: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
558: , G_MODULE_NAME || l_api_name||'. Others exception'
559: , l_error

Line 557: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED

553: END IF;
554:
555: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
556: THEN
557: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
558: , G_MODULE_NAME || l_api_name||'. Others exception'
559: , l_error
560: );
561: END IF;

Line 587: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

583: l_msg_count NUMBER;
584: l_msg_data VARCHAR2(100);
585: l_api_name CONSTANT VARCHAR2(300) := 'Process_Transaction (OVERLOADED)';
586: BEGIN
587: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
588: THEN
589: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
590: , G_MODULE_NAME || l_api_name || '.begin'
591: ,'enter procedure'

Line 589: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

585: l_api_name CONSTANT VARCHAR2(300) := 'Process_Transaction (OVERLOADED)';
586: BEGIN
587: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
588: THEN
589: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
590: , G_MODULE_NAME || l_api_name || '.begin'
591: ,'enter procedure'
592: );
593: END IF;

Line 638: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

634: NULL;
635:
636: END IF;
637:
638: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
639: THEN
640: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
641: , G_MODULE_NAME || l_api_name || '.end'
642: ,'exit procedure'

Line 640: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

636: END IF;
637:
638: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
639: THEN
640: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
641: , G_MODULE_NAME || l_api_name || '.end'
642: ,'exit procedure'
643: );
644: END IF;

Line 708: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

704: l_return_status VARCHAR2(1);
705: l_api_name CONSTANT VARCHAR2(30) := 'Process_INV_Transaction';
706: l_error VARCHAR2(600);
707: BEGIN
708: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
709: THEN
710: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
711: , G_MODULE_NAME || l_api_name || '.begin'
712: ,'enter procedure'

Line 710: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

706: l_error VARCHAR2(600);
707: BEGIN
708: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
709: THEN
710: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
711: , G_MODULE_NAME || l_api_name || '.begin'
712: ,'enter procedure'
713: );
714: END IF;

Line 921: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

917: );
918:
919: IF l_return_status <> FND_API.G_RET_STS_SUCCESS
920: THEN
921: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
922: THEN
923: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
924: , G_MODULE_NAME || l_api_name
925: || '.Failed when call mvt_stats_util_info'

Line 923: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED

919: IF l_return_status <> FND_API.G_RET_STS_SUCCESS
920: THEN
921: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
922: THEN
923: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
924: , G_MODULE_NAME || l_api_name
925: || '.Failed when call mvt_stats_util_info'
926: ,'Failed'
927: );

Line 982: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

978: END LOOP l_outer;
979: CLOSE inv_crsr;
980: END IF;
981:
982: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
983: THEN
984: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
985: , G_MODULE_NAME || l_api_name || '.end'
986: ,'exit procedure'

Line 984: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

980: END IF;
981:
982: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
983: THEN
984: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
985: , G_MODULE_NAME || l_api_name || '.end'
986: ,'exit procedure'
987: );
988: END IF;

Line 995: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

991: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
992: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
993: l_error := SUBSTRB(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE),1,250);
994:
995: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
996: THEN
997: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
998: , G_MODULE_NAME || l_api_name||'. Unexpected exception'
999: , l_error

Line 997: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED

993: l_error := SUBSTRB(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE),1,250);
994:
995: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
996: THEN
997: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
998: , G_MODULE_NAME || l_api_name||'. Unexpected exception'
999: , l_error
1000: );
1001: END IF;

Line 1004: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

1000: );
1001: END IF;
1002:
1003: WHEN NO_DATA_FOUND THEN
1004: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1005: THEN
1006: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
1007: , G_MODULE_NAME || l_api_name||'. No data found exception'
1008: , l_error

Line 1006: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED

1002:
1003: WHEN NO_DATA_FOUND THEN
1004: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1005: THEN
1006: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
1007: , G_MODULE_NAME || l_api_name||'. No data found exception'
1008: , l_error
1009: );
1010: END IF;

Line 1021: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

1017: , 'Others exception in '||l_api_name
1018: );
1019: END IF;
1020:
1021: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1022: THEN
1023: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
1024: , G_MODULE_NAME || l_api_name||'. Others exception'
1025: , l_error

Line 1023: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED

1019: END IF;
1020:
1021: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1022: THEN
1023: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
1024: , G_MODULE_NAME || l_api_name||'. Others exception'
1025: , l_error
1026: );
1027: END IF;

Line 1097: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

1093: FROM
1094: oe_order_lines_all
1095: WHERE line_id = l_link_to_line_id;
1096: BEGIN
1097: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1098: THEN
1099: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1100: , G_MODULE_NAME || l_api_name || '.begin'
1101: ,'enter procedure'

Line 1099: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

1095: WHERE line_id = l_link_to_line_id;
1096: BEGIN
1097: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1098: THEN
1099: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1100: , G_MODULE_NAME || l_api_name || '.begin'
1101: ,'enter procedure'
1102: );
1103: END IF;

Line 1140: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

1136: EXIT WHEN so_crsr%NOTFOUND;
1137:
1138: SAVEPOINT SO_Transaction;
1139:
1140: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1141: THEN
1142: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1143: , G_MODULE_NAME ||'.The SO num,ln id,pk line id,txn date are '
1144: ||l_movement_transaction.order_number

Line 1142: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

1138: SAVEPOINT SO_Transaction;
1139:
1140: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1141: THEN
1142: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1143: , G_MODULE_NAME ||'.The SO num,ln id,pk line id,txn date are '
1144: ||l_movement_transaction.order_number
1145: ||','||l_movement_transaction.order_line_id
1146: ||','||l_movement_transaction.picking_line_detail_id

Line 1214: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

1210:
1211: l_movement_transaction.transaction_date :=
1212: l_movement_transaction.reference_date;
1213:
1214: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1215: THEN
1216: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1217: , G_MODULE_NAME ||'.The reference txn date is '
1218: ||l_movement_transaction.transaction_date

Line 1216: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

1212: l_movement_transaction.reference_date;
1213:
1214: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1215: THEN
1216: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1217: , G_MODULE_NAME ||'.The reference txn date is '
1218: ||l_movement_transaction.transaction_date
1219: ,'debug msg');
1220: END IF;

Line 1273: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

1269: -- the transaction is not inside of start period and
1270: -- end period so not create transaction
1271: CLOSE ref_crsr;
1272: ELSE
1273: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1274: THEN
1275: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1276: , G_MODULE_NAME ||'.The usg,stat type,currency,tri mode,ref rule is '
1277: ||l_movement_transaction.usage_type

Line 1275: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

1271: CLOSE ref_crsr;
1272: ELSE
1273: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1274: THEN
1275: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1276: , G_MODULE_NAME ||'.The usg,stat type,currency,tri mode,ref rule is '
1277: ||l_movement_transaction.usage_type
1278: ||','||l_movement_transaction.stat_type
1279: ||','||l_stat_typ_transaction.gl_currency_code

Line 1325: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

1321: l_movement_transaction.dispatch_territory_code := l_shipping_org_terri_code;
1322: l_movement_transaction.destination_territory_code := l_customer_terri_code;
1323: END IF;
1324:
1325: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1326: THEN
1327: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1328: , G_MODULE_NAME
1329: ||'.The so le,shp le,shp org,cust,dest,disp terr code are '

Line 1327: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

1323: END IF;
1324:
1325: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1326: THEN
1327: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1328: , G_MODULE_NAME
1329: ||'.The so le,shp le,shp org,cust,dest,disp terr code are '
1330: ||l_so_le_terri_code||','||l_shipping_le_terri_code
1331: ||','||l_shipping_org_terri_code||','||l_customer_terri_code

Line 1376: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

1372: l_insert_flag := INV_MGD_MVT_SETUP_MDTR.Process_Setup_Context
1373: ( p_movement_transaction => l_movement_transaction);
1374: END IF;
1375:
1376: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1377: THEN
1378: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1379: , G_MODULE_NAME
1380: ||'.The need crt kit,kit rec status,insert flg are '

Line 1378: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

1374: END IF;
1375:
1376: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1377: THEN
1378: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1379: , G_MODULE_NAME
1380: ||'.The need crt kit,kit rec status,insert flg are '
1381: ||l_need_create_kit||','||l_kit_record_status
1382: ||','||l_insert_flag

Line 1405: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

1401:
1402:
1403: IF l_return_status <> 'Y'
1404: THEN
1405: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1406: THEN
1407: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
1408: , G_MODULE_NAME || l_api_name
1409: || '.Failed when call get_so_details'

Line 1407: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED

1403: IF l_return_status <> 'Y'
1404: THEN
1405: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1406: THEN
1407: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
1408: , G_MODULE_NAME || l_api_name
1409: || '.Failed when call get_so_details'
1410: ,'Failed'
1411: );

Line 1423: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

1419: );
1420:
1421: IF l_return_status <> FND_API.G_RET_STS_SUCCESS
1422: THEN
1423: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1424: THEN
1425: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
1426: , G_MODULE_NAME || l_api_name
1427: || '.Failed when call mvt_stats_util_info'

Line 1425: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED

1421: IF l_return_status <> FND_API.G_RET_STS_SUCCESS
1422: THEN
1423: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1424: THEN
1425: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
1426: , G_MODULE_NAME || l_api_name
1427: || '.Failed when call mvt_stats_util_info'
1428: ,'Failed'
1429: );

Line 1481: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

1477: THEN
1478: l_movement_id := l_movement_transaction.movement_id;
1479: g_records_inserted := g_records_inserted +1;
1480:
1481: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1482: THEN
1483: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1484: , G_MODULE_NAME || l_api_name
1485: ||'.Created mvt id is '||l_movement_id

Line 1483: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

1479: g_records_inserted := g_records_inserted +1;
1480:
1481: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1482: THEN
1483: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1484: , G_MODULE_NAME || l_api_name
1485: ||'.Created mvt id is '||l_movement_id
1486: ,'debug msg');
1487: END IF;

Line 1542: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

1538: END LOOP l_outer;
1539: CLOSE so_crsr;
1540: END IF;
1541:
1542: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1543: THEN
1544: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1545: , G_MODULE_NAME || l_api_name || '.end'
1546: ,'exit procedure'

Line 1544: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

1540: END IF;
1541:
1542: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1543: THEN
1544: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1545: , G_MODULE_NAME || l_api_name || '.end'
1546: ,'exit procedure'
1547: );
1548: END IF;

Line 1555: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

1551: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1552: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1553: l_error := SUBSTRB(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE),1,250);
1554:
1555: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1556: THEN
1557: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
1558: , G_MODULE_NAME || l_api_name||'. Unexpected exception'
1559: , l_error

Line 1557: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED

1553: l_error := SUBSTRB(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE),1,250);
1554:
1555: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1556: THEN
1557: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
1558: , G_MODULE_NAME || l_api_name||'. Unexpected exception'
1559: , l_error
1560: );
1561: END IF;

Line 1564: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

1560: );
1561: END IF;
1562:
1563: WHEN NO_DATA_FOUND THEN
1564: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1565: THEN
1566: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
1567: , G_MODULE_NAME || l_api_name||'. No data found exception'
1568: , l_error

Line 1566: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED

1562:
1563: WHEN NO_DATA_FOUND THEN
1564: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1565: THEN
1566: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
1567: , G_MODULE_NAME || l_api_name||'. No data found exception'
1568: , l_error
1569: );
1570: END IF;

Line 1581: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

1577: , 'Others exception in '||l_api_name
1578: );
1579: END IF;
1580:
1581: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1582: THEN
1583: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
1584: , G_MODULE_NAME || l_api_name||'. Others exception'
1585: , l_error

Line 1583: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED

1579: END IF;
1580:
1581: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1582: THEN
1583: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
1584: , G_MODULE_NAME || l_api_name||'. Others exception'
1585: , l_error
1586: );
1587: END IF;

Line 1681: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

1677: FROM
1678: hz_cust_site_uses_all
1679: WHERE site_use_id = l_movement_transaction.ship_to_site_use_id;
1680: BEGIN
1681: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1682: THEN
1683: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1684: , G_MODULE_NAME || l_api_name || '.begin'
1685: ,'enter procedure'

Line 1683: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

1679: WHERE site_use_id = l_movement_transaction.ship_to_site_use_id;
1680: BEGIN
1681: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1682: THEN
1683: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1684: , G_MODULE_NAME || l_api_name || '.begin'
1685: ,'enter procedure'
1686: );
1687: END IF;

Line 1946: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

1942: );
1943:
1944: IF l_return_status <> FND_API.G_RET_STS_SUCCESS
1945: THEN
1946: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1947: THEN
1948: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
1949: , G_MODULE_NAME || l_api_name
1950: || '.Failed when call mvt_stats_util_info'

Line 1948: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED

1944: IF l_return_status <> FND_API.G_RET_STS_SUCCESS
1945: THEN
1946: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1947: THEN
1948: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
1949: , G_MODULE_NAME || l_api_name
1950: || '.Failed when call mvt_stats_util_info'
1951: ,'Failed'
1952: );

Line 2106: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

2102: );
2103:
2104: IF l_return_status <> FND_API.G_RET_STS_SUCCESS
2105: THEN
2106: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2107: THEN
2108: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
2109: , G_MODULE_NAME || l_api_name
2110: || '.Failed when call mvt_stats_util_info -second SO'

Line 2108: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED

2104: IF l_return_status <> FND_API.G_RET_STS_SUCCESS
2105: THEN
2106: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2107: THEN
2108: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
2109: , G_MODULE_NAME || l_api_name
2110: || '.Failed when call mvt_stats_util_info -second SO'
2111: ,'Failed'
2112: );

Line 2188: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

2184: END LOOP l_outer;
2185: CLOSE sot_crsr;
2186: END IF;
2187:
2188: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2189: THEN
2190: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
2191: , G_MODULE_NAME || l_api_name || '.end'
2192: ,'exit procedure'

Line 2190: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

2186: END IF;
2187:
2188: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2189: THEN
2190: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
2191: , G_MODULE_NAME || l_api_name || '.end'
2192: ,'exit procedure'
2193: );
2194: END IF;

Line 2201: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

2197: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2198: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2199: l_error := SUBSTRB(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE),1,250);
2200:
2201: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2202: THEN
2203: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
2204: , G_MODULE_NAME || l_api_name||'. Unexpected exception'
2205: , l_error

Line 2203: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED

2199: l_error := SUBSTRB(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE),1,250);
2200:
2201: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2202: THEN
2203: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
2204: , G_MODULE_NAME || l_api_name||'. Unexpected exception'
2205: , l_error
2206: );
2207: END IF;

Line 2210: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

2206: );
2207: END IF;
2208:
2209: WHEN NO_DATA_FOUND THEN
2210: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2211: THEN
2212: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
2213: , G_MODULE_NAME || l_api_name||'. No data found exception'
2214: , l_error

Line 2212: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED

2208:
2209: WHEN NO_DATA_FOUND THEN
2210: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2211: THEN
2212: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
2213: , G_MODULE_NAME || l_api_name||'. No data found exception'
2214: , l_error
2215: );
2216: END IF;

Line 2227: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

2223: , 'Others exception in '||l_api_name
2224: );
2225: END IF;
2226:
2227: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2228: THEN
2229: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
2230: , G_MODULE_NAME || l_api_name||'. Others exception'
2231: , l_error

Line 2229: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED

2225: END IF;
2226:
2227: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2228: THEN
2229: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
2230: , G_MODULE_NAME || l_api_name||'. Others exception'
2231: , l_error
2232: );
2233: END IF;

Line 2306: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

2302: AND oola.orig_sys_document_ref = l_req_number
2303: AND oola.source_document_line_id = l_movement_transaction.requisition_line_id
2304: AND oola.line_id = wdd.source_line_id;
2305: BEGIN
2306: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2307: THEN
2308: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
2309: , G_MODULE_NAME || l_api_name || '.begin'
2310: ,'enter procedure'

Line 2308: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

2304: AND oola.line_id = wdd.source_line_id;
2305: BEGIN
2306: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2307: THEN
2308: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
2309: , G_MODULE_NAME || l_api_name || '.begin'
2310: ,'enter procedure'
2311: );
2312: END IF;

Line 2548: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

2544: END LOOP l_outer;
2545: CLOSE io_arrival_crsr;
2546: END IF;
2547:
2548: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2549: THEN
2550: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
2551: , G_MODULE_NAME || l_api_name || '.end'
2552: ,'exit procedure'

Line 2550: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

2546: END IF;
2547:
2548: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2549: THEN
2550: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
2551: , G_MODULE_NAME || l_api_name || '.end'
2552: ,'exit procedure'
2553: );
2554: END IF;

Line 2560: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

2556: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2557: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2558: l_error := SUBSTRB(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE),1,250);
2559:
2560: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2561: THEN
2562: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
2563: , G_MODULE_NAME || l_api_name||'. Unexpected exception'
2564: , l_error

Line 2562: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED

2558: l_error := SUBSTRB(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE),1,250);
2559:
2560: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2561: THEN
2562: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
2563: , G_MODULE_NAME || l_api_name||'. Unexpected exception'
2564: , l_error
2565: );
2566: END IF;

Line 2569: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

2565: );
2566: END IF;
2567:
2568: WHEN NO_DATA_FOUND THEN
2569: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2570: THEN
2571: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
2572: , G_MODULE_NAME || l_api_name||'. No data found exception'
2573: , l_error

Line 2571: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED

2567:
2568: WHEN NO_DATA_FOUND THEN
2569: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2570: THEN
2571: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
2572: , G_MODULE_NAME || l_api_name||'. No data found exception'
2573: , l_error
2574: );
2575: END IF;

Line 2586: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

2582: , 'Others exception in '||l_api_name
2583: );
2584: END IF;
2585:
2586: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2587: THEN
2588: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
2589: , G_MODULE_NAME || l_api_name||'. Others exception'
2590: , l_error

Line 2588: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED

2584: END IF;
2585:
2586: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2587: THEN
2588: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
2589: , G_MODULE_NAME || l_api_name||'. Others exception'
2590: , l_error
2591: );
2592: END IF;

Line 2789: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

2785: mtl_movement_statistics
2786: WHERE movement_id = l_parent_mvt_id;
2787:
2788: BEGIN
2789: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2790: THEN
2791: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
2792: , G_MODULE_NAME || l_api_name || '.begin'
2793: ,'enter procedure'

Line 2791: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

2787:
2788: BEGIN
2789: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2790: THEN
2791: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
2792: , G_MODULE_NAME || l_api_name || '.begin'
2793: ,'enter procedure'
2794: );
2795: END IF;

Line 3083: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

3079: --insert new record and this will be used in calling procedure
3080: x_mvt_rtv_transaction.movement_id := null;
3081: END IF;
3082:
3083: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
3084: THEN
3085: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
3086: , G_MODULE_NAME || l_api_name || '.end'
3087: ,'exit procedure'

Line 3085: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

3081: END IF;
3082:
3083: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
3084: THEN
3085: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
3086: , G_MODULE_NAME || l_api_name || '.end'
3087: ,'exit procedure'
3088: );
3089: END IF;

Line 3096: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

3092: WHEN OTHERS THEN
3093: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3094: l_error := SUBSTRB(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE),1,250);
3095:
3096: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
3097: THEN
3098: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
3099: , G_MODULE_NAME || l_api_name||'. Others exception'
3100: , l_error

Line 3098: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED

3094: l_error := SUBSTRB(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE),1,250);
3095:
3096: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
3097: THEN
3098: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
3099: , G_MODULE_NAME || l_api_name||'. Others exception'
3100: , l_error
3101: );
3102: END IF;

Line 3178: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

3174: po_headers_all
3175: WHERE po_header_id = l_movement_transaction.po_header_id;
3176:
3177: BEGIN
3178: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
3179: THEN
3180: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
3181: , G_MODULE_NAME || l_api_name || '.begin'
3182: ,'enter procedure'

Line 3180: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

3176:
3177: BEGIN
3178: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
3179: THEN
3180: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
3181: , G_MODULE_NAME || l_api_name || '.begin'
3182: ,'enter procedure'
3183: );
3184: END IF;

Line 3228: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

3224: EXIT WHEN po_crsr%NOTFOUND;
3225:
3226: SAVEPOINT PO_Transaction;
3227:
3228: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
3229: THEN
3230: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
3231: , G_MODULE_NAME ||'.The PO hd,ln,loc,rcv id,txn date are '
3232: ||l_movement_transaction.po_header_id

Line 3230: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

3226: SAVEPOINT PO_Transaction;
3227:
3228: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
3229: THEN
3230: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
3231: , G_MODULE_NAME ||'.The PO hd,ln,loc,rcv id,txn date are '
3232: ||l_movement_transaction.po_header_id
3233: ||','||l_movement_transaction.po_line_id
3234: ||','||l_movement_transaction.po_line_location_id

Line 3299: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

3295:
3296: l_movement_transaction.transaction_date :=
3297: l_movement_transaction.reference_date;
3298:
3299: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
3300: THEN
3301: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
3302: , G_MODULE_NAME ||'.The reference txn date is '
3303: ||l_movement_transaction.transaction_date

Line 3301: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

3297: l_movement_transaction.reference_date;
3298:
3299: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
3300: THEN
3301: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
3302: , G_MODULE_NAME ||'.The reference txn date is '
3303: ||l_movement_transaction.transaction_date
3304: ,'debug msg');
3305: END IF;

Line 3355: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

3351: --the transaction is not inside of start period and end period
3352: --so not create transaction
3353: CLOSE ref_crsr;
3354: ELSE
3355: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
3356: THEN
3357: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
3358: , G_MODULE_NAME ||'.The usg,stat type,currency,tri mode,ref rule are '
3359: ||l_movement_transaction.usage_type

Line 3357: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

3353: CLOSE ref_crsr;
3354: ELSE
3355: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
3356: THEN
3357: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
3358: , G_MODULE_NAME ||'.The usg,stat type,currency,tri mode,ref rule are '
3359: ||l_movement_transaction.usage_type
3360: ||','||l_movement_transaction.stat_type
3361: ||','||l_stat_typ_transaction.gl_currency_code

Line 3437: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

3433: FETCH l_drpshp INTO
3434: l_dropship_source_id;
3435: CLOSE l_drpshp;
3436:
3437: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
3438: THEN
3439: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
3440: , G_MODULE_NAME || l_api_name
3441: ||'.The drpshp source id is '||l_dropship_source_id

Line 3439: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

3435: CLOSE l_drpshp;
3436:
3437: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
3438: THEN
3439: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
3440: , G_MODULE_NAME || l_api_name
3441: ||'.The drpshp source id is '||l_dropship_source_id
3442: ,'debug msg');
3443: END IF;

Line 3474: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

3470: l_movement_transaction.destination_territory_code :=
3471: NVL(l_subinv_terr_code, l_org_terr_code);
3472: END IF;
3473:
3474: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
3475: THEN
3476: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
3477: , G_MODULE_NAME ||'.The subinv,org,dest,disp terr code are '
3478: ||l_subinv_terr_code

Line 3476: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

3472: END IF;
3473:
3474: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
3475: THEN
3476: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
3477: , G_MODULE_NAME ||'.The subinv,org,dest,disp terr code are '
3478: ||l_subinv_terr_code
3479: ||','||l_org_terr_code
3480: ||','||l_movement_transaction.destination_territory_code

Line 3629: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

3625: IF l_movement_id IS NOT NULL
3626: THEN
3627: g_records_inserted := g_records_inserted +1;
3628:
3629: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
3630: THEN
3631: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
3632: , G_MODULE_NAME || l_api_name
3633: ||'.Created mvt id is '||l_movement_id

Line 3631: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

3627: g_records_inserted := g_records_inserted +1;
3628:
3629: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
3630: THEN
3631: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
3632: , G_MODULE_NAME || l_api_name
3633: ||'.Created mvt id is '||l_movement_id
3634: ,'debug msg');
3635: END IF;

Line 3644: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

3640: -- that all the Movement amount calcns are done with the right quantity.
3641: -- Create a SO for drop shipment
3642: IF l_movement_transaction.transaction_nature='17'
3643: THEN
3644: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
3645: THEN
3646: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
3647: , G_MODULE_NAME ||'Process_PO_Dropship_Transaction1.begin'
3648: ,'enter dropship');

Line 3646: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

3642: IF l_movement_transaction.transaction_nature='17'
3643: THEN
3644: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
3645: THEN
3646: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
3647: , G_MODULE_NAME ||'Process_PO_Dropship_Transaction1.begin'
3648: ,'enter dropship');
3649: END IF;
3650:

Line 3672: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

3668: l_movement_transaction.destination_territory_code :=
3669: INV_MGD_MVT_UTILS_PKG.Get_Site_Location
3670: (l_movement_transaction.ship_to_site_use_id);
3671:
3672: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
3673: THEN
3674: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
3675: , G_MODULE_NAME ||'Process_PO_Dropship_Transaction1'
3676: ||'dest and disp terr code are '

Line 3674: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

3670: (l_movement_transaction.ship_to_site_use_id);
3671:
3672: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
3673: THEN
3674: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
3675: , G_MODULE_NAME ||'Process_PO_Dropship_Transaction1'
3676: ||'dest and disp terr code are '
3677: ||l_movement_transaction.destination_territory_code
3678: ||','||l_movement_transaction.dispatch_territory_code

Line 3741: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

3737: IF NVL(l_return_status,FND_API.G_RET_STS_SUCCESS) =
3738: FND_API.G_RET_STS_SUCCESS
3739: THEN
3740: g_records_inserted := g_records_inserted +1;
3741: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
3742: THEN
3743: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
3744: , G_MODULE_NAME ||'Process_PO_Dropship_Transaction1'
3745: ||'.Created mvt id is '

Line 3743: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

3739: THEN
3740: g_records_inserted := g_records_inserted +1;
3741: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
3742: THEN
3743: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
3744: , G_MODULE_NAME ||'Process_PO_Dropship_Transaction1'
3745: ||'.Created mvt id is '
3746: ||l_movement_transaction.movement_id
3747: ,'debug msg');

Line 3753: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

3749: END IF;
3750: END IF; -- end success from Mvt_Stats_Util_Info
3751: END IF; -- end l_insert_flag
3752:
3753: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
3754: THEN
3755: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
3756: , G_MODULE_NAME ||'Process_PO_Dropship_Transaction1.end'
3757: ,'exit dropship');

Line 3755: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

3751: END IF; -- end l_insert_flag
3752:
3753: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
3754: THEN
3755: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
3756: , G_MODULE_NAME ||'Process_PO_Dropship_Transaction1.end'
3757: ,'exit dropship');
3758: END IF;
3759: END IF; -- end dropship SO creation

Line 3781: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

3777: IF (NVL(l_stat_typ_transaction.triangulation_mode,'INVOICE_BASED')=
3778: 'INVOICE_BASED'
3779: AND l_receipt_transaction.transaction_type = 'RECEIVE')
3780: THEN
3781: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
3782: THEN
3783: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
3784: , G_MODULE_NAME ||'Process_PO_Dropship_Transaction2.begin'
3785: ,'enter dropship');

Line 3783: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

3779: AND l_receipt_transaction.transaction_type = 'RECEIVE')
3780: THEN
3781: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
3782: THEN
3783: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
3784: , G_MODULE_NAME ||'Process_PO_Dropship_Transaction2.begin'
3785: ,'enter dropship');
3786: END IF;
3787:

Line 3814: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

3810: l_movement_transaction.destination_territory_code :=
3811: INV_MGD_MVT_UTILS_PKG.Get_Site_Location
3812: (l_movement_transaction.ship_to_site_use_id);
3813:
3814: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
3815: THEN
3816: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
3817: , G_MODULE_NAME ||'Process_PO_Dropship_Transaction2'
3818: ||'dest and disp terr code are '

Line 3816: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

3812: (l_movement_transaction.ship_to_site_use_id);
3813:
3814: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
3815: THEN
3816: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
3817: , G_MODULE_NAME ||'Process_PO_Dropship_Transaction2'
3818: ||'dest and disp terr code are '
3819: ||l_movement_transaction.destination_territory_code
3820: ||','||l_movement_transaction.dispatch_territory_code

Line 3886: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

3882: THEN
3883: l_movement_id := l_movement_transaction.movement_id;
3884: g_records_inserted := g_records_inserted +1;
3885:
3886: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
3887: THEN
3888: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
3889: , G_MODULE_NAME ||'Process_PO_Dropship_Transaction2'
3890: ||'.Created mvt id is ' ||l_movement_transaction.movement_id

Line 3888: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

3884: g_records_inserted := g_records_inserted +1;
3885:
3886: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
3887: THEN
3888: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
3889: , G_MODULE_NAME ||'Process_PO_Dropship_Transaction2'
3890: ||'.Created mvt id is ' ||l_movement_transaction.movement_id
3891: ,'debug msg');
3892: END IF;

Line 3899: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

3895: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3896: END IF; --end sucess from Mvt_Stats_Util_Info
3897: END IF; --end insert flag Y
3898:
3899: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
3900: THEN
3901: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
3902: , G_MODULE_NAME ||'Process_PO_Dropship_Transaction2.end'
3903: ,'exit dropship');

Line 3901: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

3897: END IF; --end insert flag Y
3898:
3899: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
3900: THEN
3901: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
3902: , G_MODULE_NAME ||'Process_PO_Dropship_Transaction2.end'
3903: ,'exit dropship');
3904: END IF;
3905: END IF; --end invoice based

Line 3943: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

3939: END LOOP l_outer;
3940: CLOSE po_crsr;
3941: END IF;
3942:
3943: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
3944: THEN
3945: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
3946: , G_MODULE_NAME || l_api_name || '.end'
3947: ,'exit procedure'

Line 3945: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

3941: END IF;
3942:
3943: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
3944: THEN
3945: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
3946: , G_MODULE_NAME || l_api_name || '.end'
3947: ,'exit procedure'
3948: );
3949: END IF;

Line 3956: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

3952: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3953: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3954: l_error := SUBSTRB(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE),1,250);
3955:
3956: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
3957: THEN
3958: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
3959: , G_MODULE_NAME || l_api_name||'. Unexpected exception'
3960: , l_error

Line 3958: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED

3954: l_error := SUBSTRB(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE),1,250);
3955:
3956: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
3957: THEN
3958: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
3959: , G_MODULE_NAME || l_api_name||'. Unexpected exception'
3960: , l_error
3961: );
3962: END IF;

Line 3965: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

3961: );
3962: END IF;
3963:
3964: WHEN NO_DATA_FOUND THEN
3965: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
3966: THEN
3967: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
3968: , G_MODULE_NAME || l_api_name||'. No data found exception'
3969: , l_error

Line 3967: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED

3963:
3964: WHEN NO_DATA_FOUND THEN
3965: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
3966: THEN
3967: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
3968: , G_MODULE_NAME || l_api_name||'. No data found exception'
3969: , l_error
3970: );
3971: END IF;

Line 3982: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

3978: , 'Others exception in '||l_api_name
3979: );
3980: END IF;
3981:
3982: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
3983: THEN
3984: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
3985: , G_MODULE_NAME || l_api_name||'. Others exception'
3986: , l_error

Line 3984: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED

3980: END IF;
3981:
3982: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
3983: THEN
3984: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
3985: , G_MODULE_NAME || l_api_name||'. Others exception'
3986: , l_error
3987: );
3988: END IF;

Line 4185: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

4181: mtl_movement_statistics
4182: WHERE movement_id = l_parent_mvt_id;
4183:
4184: BEGIN
4185: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
4186: THEN
4187: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
4188: , G_MODULE_NAME || l_api_name || '.begin'
4189: ,'enter procedure'

Line 4187: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

4183:
4184: BEGIN
4185: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
4186: THEN
4187: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
4188: , G_MODULE_NAME || l_api_name || '.begin'
4189: ,'enter procedure'
4190: );
4191: END IF;

Line 4479: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

4475: --insert new record and this will be used in calling procedure
4476: x_mvt_rma_transaction.movement_id := null;
4477: END IF;
4478:
4479: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
4480: THEN
4481: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
4482: , G_MODULE_NAME || l_api_name || '.end'
4483: ,'exit procedure'

Line 4481: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

4477: END IF;
4478:
4479: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
4480: THEN
4481: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
4482: , G_MODULE_NAME || l_api_name || '.end'
4483: ,'exit procedure'
4484: );
4485: END IF;

Line 4492: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

4488: WHEN OTHERS THEN
4489: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4490: l_error := SUBSTRB(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE),1,250);
4491:
4492: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
4493: THEN
4494: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
4495: , G_MODULE_NAME || l_api_name||'.Others exception'
4496: , l_error

Line 4494: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED

4490: l_error := SUBSTRB(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE),1,250);
4491:
4492: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
4493: THEN
4494: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
4495: , G_MODULE_NAME || l_api_name||'.Others exception'
4496: , l_error
4497: );
4498: END IF;

Line 4574: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

4570: WHERE oola1.line_id = l_movement_transaction.order_line_id
4571: AND oola2.line_id = oola1.reference_line_id;
4572:
4573: BEGIN
4574: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
4575: THEN
4576: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
4577: , G_MODULE_NAME || l_api_name || '.begin'
4578: ,'enter procedure'

Line 4576: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

4572:
4573: BEGIN
4574: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
4575: THEN
4576: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
4577: , G_MODULE_NAME || l_api_name || '.begin'
4578: ,'enter procedure'
4579: );
4580: END IF;

Line 5034: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

5030: );
5031:
5032: IF l_return_status <> FND_API.G_RET_STS_SUCCESS
5033: THEN
5034: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
5035: THEN
5036: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
5037: , G_MODULE_NAME || l_api_name
5038: || '.Failed when call mvt_stats_util_info'

Line 5036: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED

5032: IF l_return_status <> FND_API.G_RET_STS_SUCCESS
5033: THEN
5034: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
5035: THEN
5036: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
5037: , G_MODULE_NAME || l_api_name
5038: || '.Failed when call mvt_stats_util_info'
5039: ,'Failed'
5040: );

Line 5116: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

5112: END LOOP l_outer;
5113: CLOSE rma_crsr;
5114: END IF;
5115:
5116: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
5117: THEN
5118: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
5119: , G_MODULE_NAME || l_api_name || '.end'
5120: ,'exit procedure'

Line 5118: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

5114: END IF;
5115:
5116: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
5117: THEN
5118: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
5119: , G_MODULE_NAME || l_api_name || '.end'
5120: ,'exit procedure'
5121: );
5122: END IF;

Line 5129: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

5125: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5126: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5127: l_error := SUBSTRB(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE),1,250);
5128:
5129: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
5130: THEN
5131: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
5132: , G_MODULE_NAME || l_api_name||'. Unexpected exception'
5133: , l_error

Line 5131: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED

5127: l_error := SUBSTRB(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE),1,250);
5128:
5129: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
5130: THEN
5131: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
5132: , G_MODULE_NAME || l_api_name||'. Unexpected exception'
5133: , l_error
5134: );
5135: END IF;

Line 5138: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

5134: );
5135: END IF;
5136:
5137: WHEN NO_DATA_FOUND THEN
5138: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
5139: THEN
5140: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
5141: , G_MODULE_NAME || l_api_name||'. No data found exception'
5142: , l_error

Line 5140: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED

5136:
5137: WHEN NO_DATA_FOUND THEN
5138: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
5139: THEN
5140: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
5141: , G_MODULE_NAME || l_api_name||'. No data found exception'
5142: , l_error
5143: );
5144: END IF;

Line 5155: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

5151: , 'Others exception in '||l_api_name
5152: );
5153: END IF;
5154:
5155: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
5156: THEN
5157: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
5158: , G_MODULE_NAME || l_api_name||'. Others exception'
5159: , l_error

Line 5157: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED

5153: END IF;
5154:
5155: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
5156: THEN
5157: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
5158: , G_MODULE_NAME || l_api_name||'. Others exception'
5159: , l_error
5160: );
5161: END IF;

Line 5203: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

5199: l_api_name CONSTANT VARCHAR2(30) := 'Update_Invoice_Info';
5200: l_error VARCHAR2(600);
5201:
5202: BEGIN
5203: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
5204: THEN
5205: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
5206: , G_MODULE_NAME || l_api_name || '.begin'
5207: ,'enter procedure'

Line 5205: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

5201:
5202: BEGIN
5203: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
5204: THEN
5205: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
5206: , G_MODULE_NAME || l_api_name || '.begin'
5207: ,'enter procedure'
5208: );
5209: END IF;

Line 5470: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

5466: END LOOP ;
5467: CLOSE inv_crsr;
5468: END IF;
5469:
5470: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
5471: THEN
5472: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
5473: , G_MODULE_NAME || l_api_name || '.end'
5474: ,'exit procedure'

Line 5472: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

5468: END IF;
5469:
5470: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
5471: THEN
5472: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
5473: , G_MODULE_NAME || l_api_name || '.end'
5474: ,'exit procedure'
5475: );
5476: END IF;

Line 5483: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

5479: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5480: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5481: l_error := SUBSTRB(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE),1,250);
5482:
5483: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
5484: THEN
5485: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
5486: , G_MODULE_NAME || l_api_name||'. Unexpected exception'
5487: , l_error

Line 5485: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED

5481: l_error := SUBSTRB(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE),1,250);
5482:
5483: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
5484: THEN
5485: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
5486: , G_MODULE_NAME || l_api_name||'. Unexpected exception'
5487: , l_error
5488: );
5489: END IF;

Line 5492: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

5488: );
5489: END IF;
5490:
5491: WHEN NO_DATA_FOUND THEN
5492: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
5493: THEN
5494: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
5495: , G_MODULE_NAME || l_api_name||'. No data found exception'
5496: , l_error

Line 5494: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED

5490:
5491: WHEN NO_DATA_FOUND THEN
5492: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
5493: THEN
5494: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
5495: , G_MODULE_NAME || l_api_name||'. No data found exception'
5496: , l_error
5497: );
5498: END IF;

Line 5509: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

5505: , 'Others exception in '||l_api_name
5506: );
5507: END IF;
5508:
5509: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
5510: THEN
5511: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
5512: , G_MODULE_NAME || l_api_name||'. Others exception'
5513: , l_error

Line 5511: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED

5507: END IF;
5508:
5509: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
5510: THEN
5511: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
5512: , G_MODULE_NAME || l_api_name||'. Others exception'
5513: , l_error
5514: );
5515: END IF;

Line 5568: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

5564: WHERE parent_transaction_id = l_movement_transaction.rcv_transaction_id
5565: AND mvt_stat_status = 'NEW'
5566: AND transaction_type = 'CORRECT';
5567: BEGIN
5568: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
5569: THEN
5570: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
5571: , G_MODULE_NAME || l_api_name || '.begin'
5572: ,'enter procedure'

Line 5570: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

5566: AND transaction_type = 'CORRECT';
5567: BEGIN
5568: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
5569: THEN
5570: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
5571: , G_MODULE_NAME || l_api_name || '.begin'
5572: ,'enter procedure'
5573: );
5574: END IF;

Line 5842: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

5838: END LOOP ;
5839: CLOSE inv_crsr;
5840: END IF;
5841:
5842: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
5843: THEN
5844: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
5845: , G_MODULE_NAME || l_api_name || '.end'
5846: ,'exit procedure'

Line 5844: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

5840: END IF;
5841:
5842: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
5843: THEN
5844: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
5845: , G_MODULE_NAME || l_api_name || '.end'
5846: ,'exit procedure'
5847: );
5848: END IF;

Line 5855: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

5851: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5852: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5853: l_error := SUBSTRB(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE),1,250);
5854:
5855: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
5856: THEN
5857: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
5858: , G_MODULE_NAME || l_api_name||'. Unexpected exception'
5859: , l_error

Line 5857: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED

5853: l_error := SUBSTRB(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE),1,250);
5854:
5855: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
5856: THEN
5857: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
5858: , G_MODULE_NAME || l_api_name||'. Unexpected exception'
5859: , l_error
5860: );
5861: END IF;

Line 5864: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

5860: );
5861: END IF;
5862:
5863: WHEN NO_DATA_FOUND THEN
5864: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
5865: THEN
5866: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
5867: , G_MODULE_NAME || l_api_name||'. No data found exception'
5868: , l_error

Line 5866: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED

5862:
5863: WHEN NO_DATA_FOUND THEN
5864: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
5865: THEN
5866: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
5867: , G_MODULE_NAME || l_api_name||'. No data found exception'
5868: , l_error
5869: );
5870: END IF;

Line 5881: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

5877: , 'Others exception in '||l_api_name
5878: );
5879: END IF;
5880:
5881: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
5882: THEN
5883: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
5884: , G_MODULE_NAME || l_api_name||'. Others exception'
5885: , l_error

Line 5883: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED

5879: END IF;
5880:
5881: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
5882: THEN
5883: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
5884: , G_MODULE_NAME || l_api_name||'. Others exception'
5885: , l_error
5886: );
5887: END IF;

Line 5931: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

5927: l_api_name CONSTANT VARCHAR2(30) := 'Process_Pending_Transaction';
5928: l_error VARCHAR2(600);
5929:
5930: BEGIN
5931: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
5932: THEN
5933: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
5934: , G_MODULE_NAME || l_api_name || '.begin'
5935: ,'enter procedure'

Line 5933: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

5929:
5930: BEGIN
5931: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
5932: THEN
5933: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
5934: , G_MODULE_NAME || l_api_name || '.begin'
5935: ,'enter procedure'
5936: );
5937: END IF;

Line 6241: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

6237: END LOOP ;
6238: CLOSE mvt_crsr;
6239: END IF;
6240:
6241: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
6242: THEN
6243: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
6244: , G_MODULE_NAME || l_api_name || '.end'
6245: ,'exit procedure'

Line 6243: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

6239: END IF;
6240:
6241: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
6242: THEN
6243: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
6244: , G_MODULE_NAME || l_api_name || '.end'
6245: ,'exit procedure'
6246: );
6247: END IF;

Line 6254: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

6250: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6251: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6252: l_error := SUBSTRB(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE),1,250);
6253:
6254: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
6255: THEN
6256: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
6257: , G_MODULE_NAME || l_api_name||'. Unexpected exception'
6258: , l_error

Line 6256: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED

6252: l_error := SUBSTRB(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE),1,250);
6253:
6254: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
6255: THEN
6256: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
6257: , G_MODULE_NAME || l_api_name||'. Unexpected exception'
6258: , l_error
6259: );
6260: END IF;

Line 6263: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

6259: );
6260: END IF;
6261:
6262: WHEN NO_DATA_FOUND THEN
6263: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
6264: THEN
6265: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
6266: , G_MODULE_NAME || l_api_name||'. No data found exception'
6267: , l_error

Line 6265: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED

6261:
6262: WHEN NO_DATA_FOUND THEN
6263: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
6264: THEN
6265: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
6266: , G_MODULE_NAME || l_api_name||'. No data found exception'
6267: , l_error
6268: );
6269: END IF;

Line 6280: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

6276: , 'Others exception in '||l_api_name
6277: );
6278: END IF;
6279:
6280: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
6281: THEN
6282: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
6283: , G_MODULE_NAME || l_api_name||'. Others exception'
6284: , l_error

Line 6282: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED

6278: END IF;
6279:
6280: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
6281: THEN
6282: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
6283: , G_MODULE_NAME || l_api_name||'. Others exception'
6284: , l_error
6285: );
6286: END IF;