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 137: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

133: /* triangulation country would be the country where the RMA was created/booked */
134: l_movement_transaction.triangulation_country_code := l_movement_transaction.dispatch_territory_code;
135:
136: --Debug
137: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
138: THEN
139: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
140: ,G_MODULE_NAME || l_api_name || '::Before creating a dispatch side RMA record.'
141: ,'disp::' || l_movement_transaction.dispatch_territory_code ||

Line 139: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

135:
136: --Debug
137: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
138: THEN
139: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
140: ,G_MODULE_NAME || l_api_name || '::Before creating a dispatch side RMA record.'
141: ,'disp::' || l_movement_transaction.dispatch_territory_code ||
142: ':dest::' || l_movement_transaction.destination_territory_code ||
143: ':trian::' || l_movement_transaction.triangulation_country_code

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

159: IF NVL(l_insert_status,FND_API.G_RET_STS_SUCCESS) = FND_API.G_RET_STS_SUCCESS
160: THEN
161: COMMIT;
162: ---Debug
163: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
164: THEN
165: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
166: ,G_MODULE_NAME || l_api_name
167: ,'Created dispatch side RMA movement id:' || l_movement_transaction.movement_id

Line 165: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

161: COMMIT;
162: ---Debug
163: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
164: THEN
165: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
166: ,G_MODULE_NAME || l_api_name
167: ,'Created dispatch side RMA movement id:' || l_movement_transaction.movement_id
168: );
169: END IF;

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

171: g_records_processed := g_records_processed +1;
172: g_records_inserted := g_records_inserted +1;
173: l_movement_transaction := p_movement_transaction;
174:
175: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
176: THEN
177: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
178: , G_MODULE_NAME || l_api_name || '.end'
179: ,'exit procedure'

Line 177: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

173: l_movement_transaction := p_movement_transaction;
174:
175: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
176: THEN
177: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
178: , G_MODULE_NAME || l_api_name || '.end'
179: ,'exit procedure'
180: );
181: END IF;

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

184: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
185: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
186: l_error := SUBSTRB(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE),1,250);
187:
188: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
189: THEN
190: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
191: , G_MODULE_NAME || l_api_name||'. Unexpected exception'
192: , l_error

Line 190: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED

186: l_error := SUBSTRB(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE),1,250);
187:
188: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
189: THEN
190: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
191: , G_MODULE_NAME || l_api_name||'. Unexpected exception'
192: , l_error
193: );
194: END IF;

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

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

Line 199: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED

195:
196: WHEN NO_DATA_FOUND THEN
197: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
198: THEN
199: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
200: , G_MODULE_NAME || l_api_name||'. No data found exception'
201: , l_error
202: );
203: END IF;

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

210: , 'Others exception in '||l_api_name
211: );
212: END IF;
213:
214: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
215: THEN
216: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
217: , G_MODULE_NAME || l_api_name||'. Others exception'
218: , l_error

Line 216: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED

212: END IF;
213:
214: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
215: THEN
216: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
217: , G_MODULE_NAME || l_api_name||'. Others exception'
218: , l_error
219: );
220: END IF;

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

258: l_api_name CONSTANT VARCHAR2(30) := 'Process_Transaction';
259: l_debug CONSTANT VARCHAR2(1) := NVL(FND_PROFILE.Value('AFLOG_ENABLED'),'N');
260: l_error VARCHAR2(600);
261: BEGIN
262: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
263: THEN
264: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
265: , G_MODULE_NAME || l_api_name || '.begin'
266: ,'enter procedure'

Line 264: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

260: l_error VARCHAR2(600);
261: BEGIN
262: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
263: THEN
264: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
265: , G_MODULE_NAME || l_api_name || '.begin'
266: ,'enter procedure'
267: );
268: END IF;

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

286: );
287:
288: IF l_return_status <> FND_API.G_RET_STS_SUCCESS
289: THEN
290: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
291: THEN
292: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
293: , G_MODULE_NAME || l_api_name
294: || '.Failed in process_inv_transaction'

Line 292: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED

288: IF l_return_status <> FND_API.G_RET_STS_SUCCESS
289: THEN
290: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
291: THEN
292: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
293: , G_MODULE_NAME || l_api_name
294: || '.Failed in process_inv_transaction'
295: ,'Failed'
296: );

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

313: );
314:
315: IF l_return_status <> FND_API.G_RET_STS_SUCCESS
316: THEN
317: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
318: THEN
319: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
320: , G_MODULE_NAME || l_api_name
321: || '.Failed in Update_Invoice_Info'

Line 319: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED

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

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

338: );
339:
340: IF l_return_status <> FND_API.G_RET_STS_SUCCESS
341: THEN
342: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
343: THEN
344: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
345: , G_MODULE_NAME || l_api_name
346: || '.Failed in Process_Pending_Transactions'

Line 344: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED

340: IF l_return_status <> FND_API.G_RET_STS_SUCCESS
341: THEN
342: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
343: THEN
344: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
345: , G_MODULE_NAME || l_api_name
346: || '.Failed in Process_Pending_Transactions'
347: ,'Failed'
348: );

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_SO_Transaction'

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_SO_Transaction'
374: ,'Failed'
375: );

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

387: );
388:
389: IF l_return_status <> FND_API.G_RET_STS_SUCCESS
390: THEN
391: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
392: THEN
393: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
394: , G_MODULE_NAME || l_api_name
395: || '.Failed in Process_Triangulation_Txn'

Line 393: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED

389: IF l_return_status <> FND_API.G_RET_STS_SUCCESS
390: THEN
391: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
392: THEN
393: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
394: , G_MODULE_NAME || l_api_name
395: || '.Failed in Process_Triangulation_Txn'
396: ,'Failed'
397: );

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

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

Line 419: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED

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

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

434: );
435:
436: IF l_return_status <> FND_API.G_RET_STS_SUCCESS
437: THEN
438: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
439: THEN
440: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
441: , G_MODULE_NAME || l_api_name
442: || '.Failed in Process_IO_Arrival_Txn'

Line 440: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED

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

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

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

Line 466: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED

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

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

481: );
482:
483: IF l_return_status <> FND_API.G_RET_STS_SUCCESS
484: THEN
485: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
486: THEN
487: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
488: , G_MODULE_NAME || l_api_name
489: || '.Failed in Process_PO_Transaction'

Line 487: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED

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

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

507: );
508:
509: IF l_return_status <> FND_API.G_RET_STS_SUCCESS
510: THEN
511: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
512: THEN
513: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
514: , G_MODULE_NAME || l_api_name
515: || '.Failed in Process_RMA_Transaction'

Line 513: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED

509: IF l_return_status <> FND_API.G_RET_STS_SUCCESS
510: THEN
511: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
512: THEN
513: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
514: , G_MODULE_NAME || l_api_name
515: || '.Failed in Process_RMA_Transaction'
516: ,'Failed'
517: );

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

532: );
533:
534: IF l_return_status <> FND_API.G_RET_STS_SUCCESS
535: THEN
536: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
537: THEN
538: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
539: , G_MODULE_NAME || l_api_name
540: || '.Failed in Process_Pending_Transactions'

Line 538: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED

534: IF l_return_status <> FND_API.G_RET_STS_SUCCESS
535: THEN
536: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
537: THEN
538: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
539: , G_MODULE_NAME || l_api_name
540: || '.Failed in Process_Pending_Transactions'
541: ,'Failed'
542: );

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

560: , '< ***** Records Inserted: '||g_records_inserted
561: );
562: END IF;
563:
564: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
565: THEN
566: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
567: , G_MODULE_NAME || l_api_name || '.end'
568: ,'exit procedure'

Line 566: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

562: END IF;
563:
564: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
565: THEN
566: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
567: , G_MODULE_NAME || l_api_name || '.end'
568: ,'exit procedure'
569: );
570: END IF;

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

573: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
574: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
575: l_error := SUBSTRB(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE),1,250);
576:
577: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
578: THEN
579: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
580: , G_MODULE_NAME || l_api_name||'. Unexpected exception'
581: , l_error

Line 579: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED

575: l_error := SUBSTRB(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE),1,250);
576:
577: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
578: THEN
579: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
580: , G_MODULE_NAME || l_api_name||'. Unexpected exception'
581: , l_error
582: );
583: END IF;

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

582: );
583: END IF;
584:
585: WHEN NO_DATA_FOUND THEN
586: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
587: THEN
588: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
589: , G_MODULE_NAME || l_api_name||'. No data found exception'
590: , l_error

Line 588: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED

584:
585: WHEN NO_DATA_FOUND THEN
586: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
587: THEN
588: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
589: , G_MODULE_NAME || l_api_name||'. No data found exception'
590: , l_error
591: );
592: END IF;

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

599: , 'Others exception in '||l_api_name
600: );
601: END IF;
602:
603: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
604: THEN
605: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
606: , G_MODULE_NAME || l_api_name||'. Others exception'
607: , l_error

Line 605: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED

601: END IF;
602:
603: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
604: THEN
605: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
606: , G_MODULE_NAME || l_api_name||'. Others exception'
607: , l_error
608: );
609: END IF;

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

631: l_msg_count NUMBER;
632: l_msg_data VARCHAR2(100);
633: l_api_name CONSTANT VARCHAR2(300) := 'Process_Transaction (OVERLOADED)';
634: BEGIN
635: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
636: THEN
637: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
638: , G_MODULE_NAME || l_api_name || '.begin'
639: ,'enter procedure'

Line 637: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

633: l_api_name CONSTANT VARCHAR2(300) := 'Process_Transaction (OVERLOADED)';
634: BEGIN
635: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
636: THEN
637: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
638: , G_MODULE_NAME || l_api_name || '.begin'
639: ,'enter procedure'
640: );
641: END IF;

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

682: NULL;
683:
684: END IF;
685:
686: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
687: THEN
688: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
689: , G_MODULE_NAME || l_api_name || '.end'
690: ,'exit procedure'

Line 688: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

684: END IF;
685:
686: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
687: THEN
688: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
689: , G_MODULE_NAME || l_api_name || '.end'
690: ,'exit procedure'
691: );
692: END IF;

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

752: l_return_status VARCHAR2(1);
753: l_api_name CONSTANT VARCHAR2(30) := 'Process_INV_Transaction';
754: l_error VARCHAR2(600);
755: BEGIN
756: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
757: THEN
758: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
759: , G_MODULE_NAME || l_api_name || '.begin'
760: ,'enter procedure'

Line 758: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

754: l_error VARCHAR2(600);
755: BEGIN
756: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
757: THEN
758: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
759: , G_MODULE_NAME || l_api_name || '.begin'
760: ,'enter procedure'
761: );
762: END IF;

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

965: );
966:
967: IF l_return_status <> FND_API.G_RET_STS_SUCCESS
968: THEN
969: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
970: THEN
971: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
972: , G_MODULE_NAME || l_api_name
973: || '.Failed when call mvt_stats_util_info'

Line 971: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED

967: IF l_return_status <> FND_API.G_RET_STS_SUCCESS
968: THEN
969: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
970: THEN
971: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
972: , G_MODULE_NAME || l_api_name
973: || '.Failed when call mvt_stats_util_info'
974: ,'Failed'
975: );

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

998: l_movement_id := l_movement_transaction.movement_id;
999: g_records_inserted := g_records_inserted +1;
1000:
1001: --Debug changes for bug 9228762
1002: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1003: THEN
1004: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1005: , G_MODULE_NAME || l_api_name
1006: ||'.Created mvt id is '||l_movement_id

Line 1004: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

1000:
1001: --Debug changes for bug 9228762
1002: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1003: THEN
1004: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1005: , G_MODULE_NAME || l_api_name
1006: ||'.Created mvt id is '||l_movement_id
1007: ,'debug msg');
1008: END IF;

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

1035: END LOOP l_outer;
1036: CLOSE inv_crsr;
1037: END IF;
1038:
1039: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1040: THEN
1041: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1042: , G_MODULE_NAME || l_api_name || '.end'
1043: ,'exit procedure'

Line 1041: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

1037: END IF;
1038:
1039: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1040: THEN
1041: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1042: , G_MODULE_NAME || l_api_name || '.end'
1043: ,'exit procedure'
1044: );
1045: END IF;

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

1048: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1049: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1050: l_error := SUBSTRB(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE),1,250);
1051:
1052: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1053: THEN
1054: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
1055: , G_MODULE_NAME || l_api_name||'. Unexpected exception'
1056: , l_error

Line 1054: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED

1050: l_error := SUBSTRB(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE),1,250);
1051:
1052: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1053: THEN
1054: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
1055: , G_MODULE_NAME || l_api_name||'. Unexpected exception'
1056: , l_error
1057: );
1058: END IF;

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

1057: );
1058: END IF;
1059:
1060: WHEN NO_DATA_FOUND THEN
1061: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1062: THEN
1063: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
1064: , G_MODULE_NAME || l_api_name||'. No data found exception'
1065: , l_error

Line 1063: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED

1059:
1060: WHEN NO_DATA_FOUND THEN
1061: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1062: THEN
1063: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
1064: , G_MODULE_NAME || l_api_name||'. No data found exception'
1065: , l_error
1066: );
1067: END IF;

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

1074: , 'Others exception in '||l_api_name
1075: );
1076: END IF;
1077:
1078: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1079: THEN
1080: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
1081: , G_MODULE_NAME || l_api_name||'. Others exception'
1082: , l_error

Line 1080: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED

1076: END IF;
1077:
1078: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1079: THEN
1080: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
1081: , G_MODULE_NAME || l_api_name||'. Others exception'
1082: , l_error
1083: );
1084: END IF;

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

1150: FROM
1151: oe_order_lines_all
1152: WHERE line_id = l_link_to_line_id;
1153: BEGIN
1154: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1155: THEN
1156: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1157: , G_MODULE_NAME || l_api_name || '.begin'
1158: ,'enter procedure'

Line 1156: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

1152: WHERE line_id = l_link_to_line_id;
1153: BEGIN
1154: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1155: THEN
1156: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1157: , G_MODULE_NAME || l_api_name || '.begin'
1158: ,'enter procedure'
1159: );
1160: END IF;

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

1193: EXIT WHEN so_crsr%NOTFOUND;
1194:
1195: SAVEPOINT SO_Transaction;
1196:
1197: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1198: THEN
1199: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1200: , G_MODULE_NAME ||'.The SO num,ln id,pk line id,txn date are '
1201: ||l_movement_transaction.order_number

Line 1199: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

1195: SAVEPOINT SO_Transaction;
1196:
1197: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1198: THEN
1199: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1200: , G_MODULE_NAME ||'.The SO num,ln id,pk line id,txn date are '
1201: ||l_movement_transaction.order_number
1202: ||','||l_movement_transaction.order_line_id
1203: ||','||l_movement_transaction.picking_line_detail_id

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

1267:
1268: l_movement_transaction.transaction_date :=
1269: l_movement_transaction.reference_date;
1270:
1271: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1272: THEN
1273: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1274: , G_MODULE_NAME ||'.The reference txn date is '
1275: ||l_movement_transaction.transaction_date

Line 1273: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

1269: l_movement_transaction.reference_date;
1270:
1271: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1272: THEN
1273: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1274: , G_MODULE_NAME ||'.The reference txn date is '
1275: ||l_movement_transaction.transaction_date
1276: ,'debug msg');
1277: END IF;

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

1326: -- the transaction is not inside of start period and
1327: -- end period so not create transaction
1328: CLOSE ref_crsr;
1329: ELSE
1330: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1331: THEN
1332: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1333: , G_MODULE_NAME ||'.The usg,stat type,currency,tri mode,ref rule is '
1334: ||l_movement_transaction.usage_type

Line 1332: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

1328: CLOSE ref_crsr;
1329: ELSE
1330: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1331: THEN
1332: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1333: , G_MODULE_NAME ||'.The usg,stat type,currency,tri mode,ref rule is '
1334: ||l_movement_transaction.usage_type
1335: ||','||l_movement_transaction.stat_type
1336: ||','||l_stat_typ_transaction.gl_currency_code

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

1378: l_movement_transaction.dispatch_territory_code := l_shipping_org_terri_code;
1379: l_movement_transaction.destination_territory_code := l_customer_terri_code;
1380: END IF;
1381:
1382: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1383: THEN
1384: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1385: , G_MODULE_NAME
1386: ||'.The so le,shp le,shp org,cust,dest,disp terr code are '

Line 1384: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

1380: END IF;
1381:
1382: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1383: THEN
1384: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1385: , G_MODULE_NAME
1386: ||'.The so le,shp le,shp org,cust,dest,disp terr code are '
1387: ||l_so_le_terri_code||','||l_shipping_le_terri_code
1388: ||','||l_shipping_org_terri_code||','||l_customer_terri_code

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

1429: l_insert_flag := INV_MGD_MVT_SETUP_MDTR.Process_Setup_Context
1430: ( p_movement_transaction => l_movement_transaction);
1431: END IF;
1432:
1433: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1434: THEN
1435: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1436: , G_MODULE_NAME
1437: ||'.The need crt kit,kit rec status,insert flg are '

Line 1435: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

1431: END IF;
1432:
1433: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1434: THEN
1435: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1436: , G_MODULE_NAME
1437: ||'.The need crt kit,kit rec status,insert flg are '
1438: ||l_need_create_kit||','||l_kit_record_status
1439: ||','||l_insert_flag

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

1458:
1459:
1460: IF l_return_status <> 'Y'
1461: THEN
1462: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1463: THEN
1464: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
1465: , G_MODULE_NAME || l_api_name
1466: || '.Failed when call get_so_details'

Line 1464: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED

1460: IF l_return_status <> 'Y'
1461: THEN
1462: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1463: THEN
1464: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
1465: , G_MODULE_NAME || l_api_name
1466: || '.Failed when call get_so_details'
1467: ,'Failed'
1468: );

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

1476: );
1477:
1478: IF l_return_status <> FND_API.G_RET_STS_SUCCESS
1479: THEN
1480: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1481: THEN
1482: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
1483: , G_MODULE_NAME || l_api_name
1484: || '.Failed when call mvt_stats_util_info'

Line 1482: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED

1478: IF l_return_status <> FND_API.G_RET_STS_SUCCESS
1479: THEN
1480: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1481: THEN
1482: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
1483: , G_MODULE_NAME || l_api_name
1484: || '.Failed when call mvt_stats_util_info'
1485: ,'Failed'
1486: );

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

1504: END IF;
1505: END IF;
1506: */
1507:
1508: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1509: THEN
1510: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1511: , G_MODULE_NAME || l_api_name
1512: , 'Before updating fin_doc_flag::' ||

Line 1510: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

1506: */
1507:
1508: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1509: THEN
1510: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1511: , G_MODULE_NAME || l_api_name
1512: , 'Before updating fin_doc_flag::' ||
1513: 'Invoice_id:' || l_movement_transaction.invoice_id ||
1514: '::fin_doc_flag:' || l_movement_transaction.financial_document_flag

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

1556: THEN
1557: l_movement_id := l_movement_transaction.movement_id;
1558: g_records_inserted := g_records_inserted +1;
1559:
1560: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1561: THEN
1562: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1563: , G_MODULE_NAME || l_api_name
1564: ||'.Created mvt id is '||l_movement_id

Line 1562: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

1558: g_records_inserted := g_records_inserted +1;
1559:
1560: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1561: THEN
1562: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1563: , G_MODULE_NAME || l_api_name
1564: ||'.Created mvt id is '||l_movement_id
1565: ,'debug msg');
1566: END IF;

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

1617: END LOOP l_outer;
1618: CLOSE so_crsr;
1619: END IF;
1620:
1621: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1622: THEN
1623: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1624: , G_MODULE_NAME || l_api_name || '.end'
1625: ,'exit procedure'

Line 1623: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

1619: END IF;
1620:
1621: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1622: THEN
1623: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1624: , G_MODULE_NAME || l_api_name || '.end'
1625: ,'exit procedure'
1626: );
1627: END IF;

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

1630: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1631: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1632: l_error := SUBSTRB(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE),1,250);
1633:
1634: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1635: THEN
1636: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
1637: , G_MODULE_NAME || l_api_name||'. Unexpected exception'
1638: , l_error

Line 1636: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED

1632: l_error := SUBSTRB(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE),1,250);
1633:
1634: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1635: THEN
1636: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
1637: , G_MODULE_NAME || l_api_name||'. Unexpected exception'
1638: , l_error
1639: );
1640: END IF;

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

1639: );
1640: END IF;
1641:
1642: WHEN NO_DATA_FOUND THEN
1643: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1644: THEN
1645: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
1646: , G_MODULE_NAME || l_api_name||'. No data found exception'
1647: , l_error

Line 1645: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED

1641:
1642: WHEN NO_DATA_FOUND THEN
1643: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1644: THEN
1645: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
1646: , G_MODULE_NAME || l_api_name||'. No data found exception'
1647: , l_error
1648: );
1649: END IF;

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

1656: , 'Others exception in '||l_api_name
1657: );
1658: END IF;
1659:
1660: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1661: THEN
1662: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
1663: , G_MODULE_NAME || l_api_name||'. Others exception'
1664: , l_error

Line 1662: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED

1658: END IF;
1659:
1660: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1661: THEN
1662: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
1663: , G_MODULE_NAME || l_api_name||'. Others exception'
1664: , l_error
1665: );
1666: END IF;

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

1756: FROM
1757: hz_cust_site_uses_all
1758: WHERE site_use_id = l_movement_transaction.ship_to_site_use_id;
1759: BEGIN
1760: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1761: THEN
1762: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1763: , G_MODULE_NAME || l_api_name || '.begin'
1764: ,'enter procedure'

Line 1762: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

1758: WHERE site_use_id = l_movement_transaction.ship_to_site_use_id;
1759: BEGIN
1760: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1761: THEN
1762: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1763: , G_MODULE_NAME || l_api_name || '.begin'
1764: ,'enter procedure'
1765: );
1766: END IF;

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

1797:
1798: SAVEPOINT SOT_Transaction;
1799:
1800: --Debug
1801: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1802: THEN
1803: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1804: , G_MODULE_NAME ||'.The SO num,ln id,pk line id,txn date,site,org,item type,link to line id are '
1805: ||l_movement_transaction.order_number

Line 1803: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

1799:
1800: --Debug
1801: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1802: THEN
1803: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1804: , G_MODULE_NAME ||'.The SO num,ln id,pk line id,txn date,site,org,item type,link to line id are '
1805: ||l_movement_transaction.order_number
1806: ||','||l_movement_transaction.order_line_id
1807: ||','||l_movement_transaction.picking_line_detail_id

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

1827: l_shipping_le_id := INV_MGD_MVT_UTILS_PKG.Get_Shipping_Legal_Entity
1828: (p_warehouse_id => l_movement_transaction.organization_id);
1829:
1830: --Debug
1831: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1832: THEN
1833: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1834: , G_MODULE_NAME ||'.l_trans_date, l_shipping_le_id, org_id:'
1835: ||l_trans_date

Line 1833: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

1829:
1830: --Debug
1831: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1832: THEN
1833: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1834: , G_MODULE_NAME ||'.l_trans_date, l_shipping_le_id, org_id:'
1835: ||l_trans_date
1836: ||','||l_shipping_le_id
1837: ||','||l_movement_transaction.organization_id

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

1864:
1865: l_movement_transaction.destination_territory_code := l_le_territory_code;
1866:
1867: --Debug
1868: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1869: THEN
1870: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1871: , G_MODULE_NAME ||'.le_terr_code, cust_terri_code, dispatch, destination:'
1872: ||l_le_territory_code

Line 1870: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

1866:
1867: --Debug
1868: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1869: THEN
1870: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1871: , G_MODULE_NAME ||'.le_terr_code, cust_terri_code, dispatch, destination:'
1872: ||l_le_territory_code
1873: ||','||l_customer_terri_code
1874: ||','||l_movement_transaction.dispatch_territory_code

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

1902:
1903: EXIT l_inner WHEN setup_crsr%NOTFOUND;
1904:
1905: --Debug
1906: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1907: THEN
1908: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1909: , G_MODULE_NAME ||'.The usg,stat type,currency,tri mode,ref rule is '
1910: ||l_movement_transaction.usage_type

Line 1908: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

1904:
1905: --Debug
1906: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1907: THEN
1908: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1909: , G_MODULE_NAME ||'.The usg,stat type,currency,tri mode,ref rule is '
1910: ||l_movement_transaction.usage_type
1911: ||','||l_movement_transaction.stat_type
1912: ||','||l_stat_typ_transaction.triangulation_mode

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

2007: CLOSE ref_crsr;
2008: ELSE
2009:
2010: --Debug
2011: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2012: THEN
2013: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
2014: , G_MODULE_NAME ||'.The usg,stat type,currency,tri mode,ref rule is '
2015: ||l_movement_transaction.usage_type

Line 2013: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

2009:
2010: --Debug
2011: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2012: THEN
2013: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
2014: , G_MODULE_NAME ||'.The usg,stat type,currency,tri mode,ref rule is '
2015: ||l_movement_transaction.usage_type
2016: ||','||l_movement_transaction.stat_type
2017: ||','||l_stat_typ_transaction.gl_currency_code

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

2053: ( p_movement_transaction => l_movement_transaction);
2054: END IF;
2055:
2056: --Debug
2057: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2058: THEN
2059: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
2060: , G_MODULE_NAME
2061: ||'.The need crt kit,kit rec status,insert flg are '

Line 2059: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

2055:
2056: --Debug
2057: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2058: THEN
2059: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
2060: , G_MODULE_NAME
2061: ||'.The need crt kit,kit rec status,insert flg are '
2062: ||l_need_create_kit
2063: ||','||l_kit_record_status

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

2098: );
2099:
2100: IF l_return_status <> FND_API.G_RET_STS_SUCCESS
2101: THEN
2102: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2103: THEN
2104: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
2105: , G_MODULE_NAME || l_api_name
2106: || '.Failed when call mvt_stats_util_info'

Line 2104: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED

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

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

2144: l_movement_id := l_movement_transaction.movement_id;
2145: g_records_inserted := g_records_inserted +1;
2146:
2147: --Debug
2148: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2149: THEN
2150: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
2151: , G_MODULE_NAME || l_api_name
2152: ||'.Created mvt id is '||l_movement_id

Line 2150: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

2146:
2147: --Debug
2148: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2149: THEN
2150: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
2151: , G_MODULE_NAME || l_api_name
2152: ||'.Created mvt id is '||l_movement_id
2153: ,'debug msg');
2154: END IF;

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

2173: l_movement_transaction2.dispatch_territory_code := l_le_territory_code;
2174: l_movement_transaction2.destination_territory_code := l_customer_terri_code;
2175:
2176: --Debug
2177: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2178: THEN
2179: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
2180: , G_MODULE_NAME ||'.le_terr_code, cust_terri_code, dispatch, destination:'
2181: ||l_le_territory_code

Line 2179: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

2175:
2176: --Debug
2177: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2178: THEN
2179: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
2180: , G_MODULE_NAME ||'.le_terr_code, cust_terri_code, dispatch, destination:'
2181: ||l_le_territory_code
2182: ||','||l_customer_terri_code
2183: ||','||l_movement_transaction2.dispatch_territory_code

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

2194: ( p_movement_transaction => l_movement_transaction2);
2195: END IF;
2196:
2197: --Debug
2198: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2199: THEN
2200: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
2201: , G_MODULE_NAME
2202: ||'.The need crt kit,kit rec status,insert flg are '

Line 2200: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

2196:
2197: --Debug
2198: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2199: THEN
2200: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
2201: , G_MODULE_NAME
2202: ||'.The need crt kit,kit rec status,insert flg are '
2203: ||l_need_create_kit
2204: ||','||l_kit_record_status

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

2291: );
2292:
2293: IF l_return_status <> FND_API.G_RET_STS_SUCCESS
2294: THEN
2295: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2296: THEN
2297: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
2298: , G_MODULE_NAME || l_api_name
2299: || '.Failed when call mvt_stats_util_info -second SO'

Line 2297: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED

2293: IF l_return_status <> FND_API.G_RET_STS_SUCCESS
2294: THEN
2295: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2296: THEN
2297: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
2298: , G_MODULE_NAME || l_api_name
2299: || '.Failed when call mvt_stats_util_info -second SO'
2300: ,'Failed'
2301: );

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

2329: l_movement_id2 := l_movement_transaction2.movement_id;
2330: g_records_inserted := g_records_inserted +1;
2331:
2332: --Debug
2333: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2334: THEN
2335: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
2336: , G_MODULE_NAME || l_api_name
2337: ||'.Created mvt id 2 is '||l_movement_id2

Line 2335: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

2331:
2332: --Debug
2333: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2334: THEN
2335: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
2336: , G_MODULE_NAME || l_api_name
2337: ||'.Created mvt id 2 is '||l_movement_id2
2338: ,'debug msg');
2339: END IF;

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

2382: END LOOP l_outer;
2383: CLOSE sot_crsr;
2384: END IF;
2385:
2386: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2387: THEN
2388: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
2389: , G_MODULE_NAME || l_api_name || '.end'
2390: ,'exit procedure'

Line 2388: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

2384: END IF;
2385:
2386: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2387: THEN
2388: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
2389: , G_MODULE_NAME || l_api_name || '.end'
2390: ,'exit procedure'
2391: );
2392: END IF;

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

2395: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2396: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2397: l_error := SUBSTRB(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE),1,250);
2398:
2399: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2400: THEN
2401: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
2402: , G_MODULE_NAME || l_api_name||'. Unexpected exception'
2403: , l_error

Line 2401: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED

2397: l_error := SUBSTRB(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE),1,250);
2398:
2399: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2400: THEN
2401: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
2402: , G_MODULE_NAME || l_api_name||'. Unexpected exception'
2403: , l_error
2404: );
2405: END IF;

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

2404: );
2405: END IF;
2406:
2407: WHEN NO_DATA_FOUND THEN
2408: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2409: THEN
2410: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
2411: , G_MODULE_NAME || l_api_name||'. No data found exception'
2412: , l_error

Line 2410: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED

2406:
2407: WHEN NO_DATA_FOUND THEN
2408: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2409: THEN
2410: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
2411: , G_MODULE_NAME || l_api_name||'. No data found exception'
2412: , l_error
2413: );
2414: END IF;

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

2421: , 'Others exception in '||l_api_name
2422: );
2423: END IF;
2424:
2425: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2426: THEN
2427: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
2428: , G_MODULE_NAME || l_api_name||'. Others exception'
2429: , l_error

Line 2427: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED

2423: END IF;
2424:
2425: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2426: THEN
2427: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
2428: , G_MODULE_NAME || l_api_name||'. Others exception'
2429: , l_error
2430: );
2431: END IF;

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

2553: wsh_delivery_details_ob_grp_v wdd
2554: WHERE wdd.delivery_detail_id=l_movement_transaction.picking_line_detail_id;
2555:
2556: BEGIN
2557: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2558: THEN
2559: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
2560: , G_MODULE_NAME || l_api_name || '.begin'
2561: ,'enter procedure'

Line 2559: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

2555:
2556: BEGIN
2557: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2558: THEN
2559: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
2560: , G_MODULE_NAME || l_api_name || '.begin'
2561: ,'enter procedure'
2562: );
2563: END IF;

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

2593:
2594: SAVEPOINT IO_Transaction;
2595:
2596: --Bug 12548575: New debug messages.
2597: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2598: THEN
2599: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
2600: , G_MODULE_NAME
2601: ||'::RCV_TRX_ID::' || l_movement_transaction.rcv_transaction_id ||','

Line 2599: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

2595:
2596: --Bug 12548575: New debug messages.
2597: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2598: THEN
2599: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
2600: , G_MODULE_NAME
2601: ||'::RCV_TRX_ID::' || l_movement_transaction.rcv_transaction_id ||','
2602: ||'::TRX_DATE::' || l_movement_transaction.transaction_date ||','
2603: ||'::ORGANIZATION_ID::' || l_movement_transaction.organization_id ||','

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

2625: l_shipping_org_id;
2626: CLOSE shipping_org;
2627:
2628: --Bug 12548575: New debug messages.
2629: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2630: THEN
2631: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
2632: , G_MODULE_NAME
2633: ||'::PICKING_LINE_ID::' || l_movement_transaction.picking_line_detail_id ||','

Line 2631: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

2627:
2628: --Bug 12548575: New debug messages.
2629: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2630: THEN
2631: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
2632: , G_MODULE_NAME
2633: ||'::PICKING_LINE_ID::' || l_movement_transaction.picking_line_detail_id ||','
2634: ||'::SHIP_ORG_ID::' || l_shipping_org_id ||','
2635: ||'::ORD_LINE_ID::' || l_movement_transaction.order_line_id

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

2778: INV_MGD_MVT_UTILS_PKG.Get_Cust_VAT_Number
2779: (l_movement_transaction.bill_to_site_use_id);
2780:
2781: --Start Bugfix 13400081
2782: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2783: THEN
2784: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
2785: , G_MODULE_NAME || l_api_name
2786: , 'Before updating fin_doc_flag::' ||

Line 2784: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

2780:
2781: --Start Bugfix 13400081
2782: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2783: THEN
2784: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
2785: , G_MODULE_NAME || l_api_name
2786: , 'Before updating fin_doc_flag::' ||
2787: 'Invoice_id:' || l_movement_transaction.invoice_id ||
2788: '::fin_doc_flag:' || l_movement_transaction.financial_document_flag

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

2812: THEN
2813: l_movement_id := l_movement_transaction.movement_id;
2814: g_records_inserted := g_records_inserted +1;
2815:
2816: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2817: THEN
2818: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
2819: , G_MODULE_NAME || l_api_name
2820: ||'.Created mvt id is '||l_movement_id

Line 2818: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

2814: g_records_inserted := g_records_inserted +1;
2815:
2816: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2817: THEN
2818: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
2819: , G_MODULE_NAME || l_api_name
2820: ||'.Created mvt id is '||l_movement_id
2821: ,'debug msg');
2822: END IF;

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

2852: END LOOP l_outer;
2853: CLOSE io_arrival_crsr;
2854: END IF;
2855:
2856: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2857: THEN
2858: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
2859: , G_MODULE_NAME || l_api_name || '.end'
2860: ,'exit procedure'

Line 2858: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

2854: END IF;
2855:
2856: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2857: THEN
2858: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
2859: , G_MODULE_NAME || l_api_name || '.end'
2860: ,'exit procedure'
2861: );
2862: END IF;

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

2864: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2865: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2866: l_error := SUBSTRB(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE),1,250);
2867:
2868: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2869: THEN
2870: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
2871: , G_MODULE_NAME || l_api_name||'. Unexpected exception'
2872: , l_error

Line 2870: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED

2866: l_error := SUBSTRB(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE),1,250);
2867:
2868: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2869: THEN
2870: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
2871: , G_MODULE_NAME || l_api_name||'. Unexpected exception'
2872: , l_error
2873: );
2874: END IF;

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

2873: );
2874: END IF;
2875:
2876: WHEN NO_DATA_FOUND THEN
2877: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2878: THEN
2879: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
2880: , G_MODULE_NAME || l_api_name||'. No data found exception'
2881: , l_error

Line 2879: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED

2875:
2876: WHEN NO_DATA_FOUND THEN
2877: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2878: THEN
2879: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
2880: , G_MODULE_NAME || l_api_name||'. No data found exception'
2881: , l_error
2882: );
2883: END IF;

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

2890: , 'Others exception in '||l_api_name
2891: );
2892: END IF;
2893:
2894: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2895: THEN
2896: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
2897: , G_MODULE_NAME || l_api_name||'. Others exception'
2898: , l_error

Line 2896: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED

2892: END IF;
2893:
2894: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2895: THEN
2896: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
2897: , G_MODULE_NAME || l_api_name||'. Others exception'
2898: , l_error
2899: );
2900: END IF;

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

3093: mtl_movement_statistics
3094: WHERE movement_id = l_parent_mvt_id;
3095:
3096: BEGIN
3097: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
3098: THEN
3099: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
3100: , G_MODULE_NAME || l_api_name || '.begin'
3101: ,'enter procedure'

Line 3099: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

3095:
3096: BEGIN
3097: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
3098: THEN
3099: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
3100: , G_MODULE_NAME || l_api_name || '.begin'
3101: ,'enter procedure'
3102: );
3103: END IF;

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

3387: --insert new record and this will be used in calling procedure
3388: x_mvt_rtv_transaction.movement_id := null;
3389: END IF;
3390:
3391: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
3392: THEN
3393: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
3394: , G_MODULE_NAME || l_api_name || '.end'
3395: ,'exit procedure'

Line 3393: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

3389: END IF;
3390:
3391: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
3392: THEN
3393: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
3394: , G_MODULE_NAME || l_api_name || '.end'
3395: ,'exit procedure'
3396: );
3397: END IF;

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

3400: WHEN OTHERS THEN
3401: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3402: l_error := SUBSTRB(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE),1,250);
3403:
3404: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
3405: THEN
3406: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
3407: , G_MODULE_NAME || l_api_name||'. Others exception'
3408: , l_error

Line 3406: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED

3402: l_error := SUBSTRB(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE),1,250);
3403:
3404: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
3405: THEN
3406: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
3407: , G_MODULE_NAME || l_api_name||'. Others exception'
3408: , l_error
3409: );
3410: END IF;

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

3497: po_headers_all
3498: WHERE po_header_id = l_movement_transaction.po_header_id;
3499:
3500: BEGIN
3501: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
3502: THEN
3503: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
3504: , G_MODULE_NAME || l_api_name || '.begin'
3505: ,'enter procedure'

Line 3503: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

3499:
3500: BEGIN
3501: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
3502: THEN
3503: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
3504: , G_MODULE_NAME || l_api_name || '.begin'
3505: ,'enter procedure'
3506: );
3507: END IF;

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

3550: EXIT WHEN po_crsr%NOTFOUND;
3551:
3552: SAVEPOINT PO_Transaction;
3553:
3554: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
3555: THEN
3556: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
3557: , G_MODULE_NAME ||'.The PO hd,ln,loc,rcv id,txn date,sub,ship_hd,ship_ln:: '
3558: ||l_movement_transaction.po_header_id

Line 3556: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

3552: SAVEPOINT PO_Transaction;
3553:
3554: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
3555: THEN
3556: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
3557: , G_MODULE_NAME ||'.The PO hd,ln,loc,rcv id,txn date,sub,ship_hd,ship_ln:: '
3558: ||l_movement_transaction.po_header_id
3559: ||','||l_movement_transaction.po_line_id
3560: ||','||l_movement_transaction.po_line_location_id

Line 3590: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

3586: FETCH l_subinventory INTO l_subinv_code;
3587: CLOSE l_subinventory;
3588: END IF;
3589:
3590: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3591: FND_LOG.string( FND_LOG.LEVEL_PROCEDURE
3592: , G_MODULE_NAME ||'Subinv::'
3593: || l_subinv_code
3594: ,'debug msg');

Line 3591: FND_LOG.string( FND_LOG.LEVEL_PROCEDURE

3587: CLOSE l_subinventory;
3588: END IF;
3589:
3590: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3591: FND_LOG.string( FND_LOG.LEVEL_PROCEDURE
3592: , G_MODULE_NAME ||'Subinv::'
3593: || l_subinv_code
3594: ,'debug msg');
3595: END IF;

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

3638:
3639: l_movement_transaction.transaction_date :=
3640: l_movement_transaction.reference_date;
3641:
3642: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
3643: THEN
3644: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
3645: , G_MODULE_NAME ||'.The reference txn date is '
3646: ||l_movement_transaction.transaction_date

Line 3644: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

3640: l_movement_transaction.reference_date;
3641:
3642: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
3643: THEN
3644: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
3645: , G_MODULE_NAME ||'.The reference txn date is '
3646: ||l_movement_transaction.transaction_date
3647: ,'debug msg');
3648: END IF;

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

3694: --the transaction is not inside of start period and end period
3695: --so not create transaction
3696: CLOSE ref_crsr;
3697: ELSE
3698: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
3699: THEN
3700: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
3701: , G_MODULE_NAME ||'.The usg,stat type,currency,tri mode,ref rule are '
3702: ||l_movement_transaction.usage_type

Line 3700: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

3696: CLOSE ref_crsr;
3697: ELSE
3698: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
3699: THEN
3700: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
3701: , G_MODULE_NAME ||'.The usg,stat type,currency,tri mode,ref rule are '
3702: ||l_movement_transaction.usage_type
3703: ||','||l_movement_transaction.stat_type
3704: ||','||l_stat_typ_transaction.gl_currency_code

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

3776: FETCH l_drpshp INTO
3777: l_dropship_source_id;
3778: CLOSE l_drpshp;
3779:
3780: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
3781: THEN
3782: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
3783: , G_MODULE_NAME || l_api_name
3784: ||'.The drpshp source id is '||l_dropship_source_id

Line 3782: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

3778: CLOSE l_drpshp;
3779:
3780: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
3781: THEN
3782: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
3783: , G_MODULE_NAME || l_api_name
3784: ||'.The drpshp source id is '||l_dropship_source_id
3785: ,'debug msg');
3786: END IF;

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

3813: l_movement_transaction.destination_territory_code :=
3814: NVL(l_subinv_terr_code, l_org_terr_code);
3815: END IF;
3816:
3817: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
3818: THEN
3819: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
3820: , G_MODULE_NAME ||'.The subinv,org,dest,disp terr code are '
3821: ||l_subinv_terr_code

Line 3819: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

3815: END IF;
3816:
3817: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
3818: THEN
3819: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
3820: , G_MODULE_NAME ||'.The subinv,org,dest,disp terr code are '
3821: ||l_subinv_terr_code
3822: ||','||l_org_terr_code
3823: ||','||l_movement_transaction.destination_territory_code

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

3968: IF l_movement_id IS NOT NULL
3969: THEN
3970: g_records_inserted := g_records_inserted +1;
3971:
3972: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
3973: THEN
3974: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
3975: , G_MODULE_NAME || l_api_name
3976: ||'.Created mvt id is '||l_movement_id

Line 3974: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

3970: g_records_inserted := g_records_inserted +1;
3971:
3972: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
3973: THEN
3974: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
3975: , G_MODULE_NAME || l_api_name
3976: ||'.Created mvt id is '||l_movement_id
3977: ,'debug msg');
3978: END IF;

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

3983: -- that all the Movement amount calcns are done with the right quantity.
3984: -- Create a SO for drop shipment
3985: IF l_movement_transaction.transaction_nature='17'
3986: THEN
3987: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
3988: THEN
3989: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
3990: , G_MODULE_NAME ||'Process_PO_Dropship_Transaction1.begin'
3991: ,'enter dropship');

Line 3989: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

3985: IF l_movement_transaction.transaction_nature='17'
3986: THEN
3987: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
3988: THEN
3989: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
3990: , G_MODULE_NAME ||'Process_PO_Dropship_Transaction1.begin'
3991: ,'enter dropship');
3992: END IF;
3993:

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

4011: l_movement_transaction.destination_territory_code :=
4012: INV_MGD_MVT_UTILS_PKG.Get_Site_Location
4013: (l_movement_transaction.ship_to_site_use_id);
4014:
4015: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
4016: THEN
4017: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
4018: , G_MODULE_NAME ||'Process_PO_Dropship_Transaction1'
4019: ||'dest and disp terr code are '

Line 4017: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

4013: (l_movement_transaction.ship_to_site_use_id);
4014:
4015: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
4016: THEN
4017: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
4018: , G_MODULE_NAME ||'Process_PO_Dropship_Transaction1'
4019: ||'dest and disp terr code are '
4020: ||l_movement_transaction.destination_territory_code
4021: ||','||l_movement_transaction.dispatch_territory_code

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

4080: IF NVL(l_return_status,FND_API.G_RET_STS_SUCCESS) =
4081: FND_API.G_RET_STS_SUCCESS
4082: THEN
4083: g_records_inserted := g_records_inserted +1;
4084: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
4085: THEN
4086: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
4087: , G_MODULE_NAME ||'Process_PO_Dropship_Transaction1'
4088: ||'.Created mvt id is '

Line 4086: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

4082: THEN
4083: g_records_inserted := g_records_inserted +1;
4084: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
4085: THEN
4086: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
4087: , G_MODULE_NAME ||'Process_PO_Dropship_Transaction1'
4088: ||'.Created mvt id is '
4089: ||l_movement_transaction.movement_id
4090: ,'debug msg');

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

4092: END IF;
4093: END IF; -- end success from Mvt_Stats_Util_Info
4094: END IF; -- end l_insert_flag
4095:
4096: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
4097: THEN
4098: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
4099: , G_MODULE_NAME ||'Process_PO_Dropship_Transaction1.end'
4100: ,'exit dropship');

Line 4098: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

4094: END IF; -- end l_insert_flag
4095:
4096: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
4097: THEN
4098: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
4099: , G_MODULE_NAME ||'Process_PO_Dropship_Transaction1.end'
4100: ,'exit dropship');
4101: END IF;
4102: END IF; -- end dropship SO creation

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

4120: IF (NVL(l_stat_typ_transaction.triangulation_mode,'INVOICE_BASED')=
4121: 'INVOICE_BASED'
4122: AND l_receipt_transaction.transaction_type = 'RECEIVE')
4123: THEN
4124: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
4125: THEN
4126: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
4127: , G_MODULE_NAME ||'Process_PO_Dropship_Transaction2.begin'
4128: ,'enter dropship');

Line 4126: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

4122: AND l_receipt_transaction.transaction_type = 'RECEIVE')
4123: THEN
4124: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
4125: THEN
4126: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
4127: , G_MODULE_NAME ||'Process_PO_Dropship_Transaction2.begin'
4128: ,'enter dropship');
4129: END IF;
4130:

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

4153: l_movement_transaction.destination_territory_code :=
4154: INV_MGD_MVT_UTILS_PKG.Get_Site_Location
4155: (l_movement_transaction.ship_to_site_use_id);
4156:
4157: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
4158: THEN
4159: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
4160: , G_MODULE_NAME ||'Process_PO_Dropship_Transaction2'
4161: ||'dest and disp terr code are '

Line 4159: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

4155: (l_movement_transaction.ship_to_site_use_id);
4156:
4157: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
4158: THEN
4159: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
4160: , G_MODULE_NAME ||'Process_PO_Dropship_Transaction2'
4161: ||'dest and disp terr code are '
4162: ||l_movement_transaction.destination_territory_code
4163: ||','||l_movement_transaction.dispatch_territory_code

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

4225: THEN
4226: l_movement_id := l_movement_transaction.movement_id;
4227: g_records_inserted := g_records_inserted +1;
4228:
4229: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
4230: THEN
4231: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
4232: , G_MODULE_NAME ||'Process_PO_Dropship_Transaction2'
4233: ||'.Created mvt id is ' ||l_movement_transaction.movement_id

Line 4231: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

4227: g_records_inserted := g_records_inserted +1;
4228:
4229: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
4230: THEN
4231: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
4232: , G_MODULE_NAME ||'Process_PO_Dropship_Transaction2'
4233: ||'.Created mvt id is ' ||l_movement_transaction.movement_id
4234: ,'debug msg');
4235: END IF;

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

4238: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4239: END IF; --end sucess from Mvt_Stats_Util_Info
4240: END IF; --end insert flag Y
4241:
4242: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
4243: THEN
4244: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
4245: , G_MODULE_NAME ||'Process_PO_Dropship_Transaction2.end'
4246: ,'exit dropship');

Line 4244: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

4240: END IF; --end insert flag Y
4241:
4242: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
4243: THEN
4244: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
4245: , G_MODULE_NAME ||'Process_PO_Dropship_Transaction2.end'
4246: ,'exit dropship');
4247: END IF;
4248: END IF; --end invoice based

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

4282: END LOOP l_outer;
4283: CLOSE po_crsr;
4284: END IF;
4285:
4286: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
4287: THEN
4288: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
4289: , G_MODULE_NAME || l_api_name || '.end'
4290: ,'exit procedure'

Line 4288: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

4284: END IF;
4285:
4286: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
4287: THEN
4288: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
4289: , G_MODULE_NAME || l_api_name || '.end'
4290: ,'exit procedure'
4291: );
4292: END IF;

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

4295: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4296: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4297: l_error := SUBSTRB(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE),1,250);
4298:
4299: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
4300: THEN
4301: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
4302: , G_MODULE_NAME || l_api_name||'. Unexpected exception'
4303: , l_error

Line 4301: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED

4297: l_error := SUBSTRB(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE),1,250);
4298:
4299: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
4300: THEN
4301: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
4302: , G_MODULE_NAME || l_api_name||'. Unexpected exception'
4303: , l_error
4304: );
4305: END IF;

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

4304: );
4305: END IF;
4306:
4307: WHEN NO_DATA_FOUND THEN
4308: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
4309: THEN
4310: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
4311: , G_MODULE_NAME || l_api_name||'. No data found exception'
4312: , l_error

Line 4310: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED

4306:
4307: WHEN NO_DATA_FOUND THEN
4308: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
4309: THEN
4310: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
4311: , G_MODULE_NAME || l_api_name||'. No data found exception'
4312: , l_error
4313: );
4314: END IF;

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

4321: , 'Others exception in '||l_api_name
4322: );
4323: END IF;
4324:
4325: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
4326: THEN
4327: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
4328: , G_MODULE_NAME || l_api_name||'. Others exception'
4329: , l_error

Line 4327: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED

4323: END IF;
4324:
4325: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
4326: THEN
4327: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
4328: , G_MODULE_NAME || l_api_name||'. Others exception'
4329: , l_error
4330: );
4331: END IF;

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

4524: mtl_movement_statistics
4525: WHERE movement_id = l_parent_mvt_id;
4526:
4527: BEGIN
4528: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
4529: THEN
4530: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
4531: , G_MODULE_NAME || l_api_name || '.begin'
4532: ,'enter procedure'

Line 4530: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

4526:
4527: BEGIN
4528: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
4529: THEN
4530: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
4531: , G_MODULE_NAME || l_api_name || '.begin'
4532: ,'enter procedure'
4533: );
4534: END IF;

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

4818: --insert new record and this will be used in calling procedure
4819: x_mvt_rma_transaction.movement_id := null;
4820: END IF;
4821:
4822: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
4823: THEN
4824: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
4825: , G_MODULE_NAME || l_api_name || '.end'
4826: ,'exit procedure'

Line 4824: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

4820: END IF;
4821:
4822: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
4823: THEN
4824: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
4825: , G_MODULE_NAME || l_api_name || '.end'
4826: ,'exit procedure'
4827: );
4828: END IF;

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

4831: WHEN OTHERS THEN
4832: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4833: l_error := SUBSTRB(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE),1,250);
4834:
4835: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
4836: THEN
4837: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
4838: , G_MODULE_NAME || l_api_name||'.Others exception'
4839: , l_error

Line 4837: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED

4833: l_error := SUBSTRB(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE),1,250);
4834:
4835: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
4836: THEN
4837: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
4838: , G_MODULE_NAME || l_api_name||'.Others exception'
4839: , l_error
4840: );
4841: END IF;

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

4913: WHERE oola1.line_id = l_movement_transaction.order_line_id
4914: AND oola2.line_id = oola1.reference_line_id;
4915:
4916: BEGIN
4917: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
4918: THEN
4919: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
4920: , G_MODULE_NAME || l_api_name || '.begin'
4921: ,'enter procedure'

Line 4919: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

4915:
4916: BEGIN
4917: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
4918: THEN
4919: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
4920: , G_MODULE_NAME || l_api_name || '.begin'
4921: ,'enter procedure'
4922: );
4923: END IF;

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

4954: , l_subinv_code
4955: , l_mvt_stat_status;-- 7165989
4956:
4957: --Debug
4958: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
4959: THEN
4960: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
4961: ,G_MODULE_NAME || '::Printing RMA values::'
4962: ,'rcv_txn_id:' ||l_movement_transaction.rcv_transaction_id ||

Line 4960: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

4956:
4957: --Debug
4958: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
4959: THEN
4960: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
4961: ,G_MODULE_NAME || '::Printing RMA values::'
4962: ,'rcv_txn_id:' ||l_movement_transaction.rcv_transaction_id ||
4963: ',parent_txn_id:' || l_receipt_transaction.parent_transaction_id ||
4964: ',txn_type:' || l_receipt_transaction.transaction_type ||

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

4990: END IF;
4991: /*bug#7165989 : End */
4992:
4993: --Debug
4994: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
4995: THEN
4996: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
4997: ,G_MODULE_NAME || l_api_name
4998: ,'order_number:' ||l_movement_transaction.order_number

Line 4996: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

4992:
4993: --Debug
4994: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
4995: THEN
4996: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
4997: ,G_MODULE_NAME || l_api_name
4998: ,'order_number:' ||l_movement_transaction.order_number
4999: );
5000: END IF;

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

5013: END IF;
5014: CLOSE c_item_type;
5015:
5016: --Debug
5017: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
5018: THEN
5019: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
5020: ,G_MODULE_NAME || l_api_name
5021: ,'l_item_type_code:' || l_item_type_code

Line 5019: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

5015:
5016: --Debug
5017: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
5018: THEN
5019: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
5020: ,G_MODULE_NAME || l_api_name
5021: ,'l_item_type_code:' || l_item_type_code
5022: );
5023: END IF;

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

5053: , l_stat_typ_transaction.prior_invoice_days
5054: , l_stat_typ_transaction.triangulation_mode;
5055:
5056: --Debug
5057: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
5058: THEN
5059: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
5060: ,G_MODULE_NAME || '::Printing setup_crsr::'
5061: ,'zone:' || l_movement_transaction.zone_code ||

Line 5059: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

5055:
5056: --Debug
5057: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
5058: THEN
5059: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
5060: ,G_MODULE_NAME || '::Printing setup_crsr::'
5061: ,'zone:' || l_movement_transaction.zone_code ||
5062: ',usage:' || l_movement_transaction.usage_type ||
5063: ',stat:' || l_movement_transaction.stat_type ||

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

5092: l_movement_transaction.transaction_date :=
5093: l_movement_transaction.reference_date;
5094:
5095: --Debug
5096: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
5097: THEN
5098: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
5099: ,G_MODULE_NAME || l_api_name
5100: ,'txn_date:' || l_movement_transaction.transaction_date

Line 5098: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

5094:
5095: --Debug
5096: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
5097: THEN
5098: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
5099: ,G_MODULE_NAME || l_api_name
5100: ,'txn_date:' || l_movement_transaction.transaction_date
5101: );
5102: END IF;

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

5200: FND_FILE.put_line (FND_FILE.log , '< l_sold_from_org_code - '|| l_sold_from_org_code );
5201: /*7165989*/
5202:
5203: --Debug
5204: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
5205: THEN
5206: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
5207: ,G_MODULE_NAME || l_api_name
5208: ,'rma_le:' || l_rma_le_id ||

Line 5206: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

5202:
5203: --Debug
5204: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
5205: THEN
5206: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
5207: ,G_MODULE_NAME || l_api_name
5208: ,'rma_le:' || l_rma_le_id ||
5209: ',rcv_le:' || l_receiving_le_id ||
5210: ',subinv_terr:' || l_subinv_terr_code ||

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

5252: l_process_flag := 'Y';
5253: /* 7165989*/
5254:
5255: --Debug
5256: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
5257: THEN
5258: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
5259: ,G_MODULE_NAME || l_api_name
5260: ,'dest:' || l_movement_transaction.destination_territory_code ||

Line 5258: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

5254:
5255: --Debug
5256: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
5257: THEN
5258: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
5259: ,G_MODULE_NAME || l_api_name
5260: ,'dest:' || l_movement_transaction.destination_territory_code ||
5261: ',triang_country:' || l_movement_transaction.triangulation_country_code ||
5262: ',subinv_terr:' || l_subinv_terr_code ||

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

5286: FND_FILE.put_line (FND_FILE.log ,'mvt stat status after update'||l_mvt_stat_status );
5287: FND_FILE.put_line (FND_FILE.log ,'Case 1 : RMA Invoice Based Triangulation run at booking LE' );
5288:
5289: --Debug
5290: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
5291: THEN
5292: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
5293: ,G_MODULE_NAME || l_api_name || 'Case 1 : RMA Invoice Based Triangulation run at booking LE'
5294: ,'New mvt status:' || l_mvt_stat_status

Line 5292: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

5288:
5289: --Debug
5290: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
5291: THEN
5292: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
5293: ,G_MODULE_NAME || l_api_name || 'Case 1 : RMA Invoice Based Triangulation run at booking LE'
5294: ,'New mvt status:' || l_mvt_stat_status
5295: );
5296: END IF;

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

5301: l_destination :=
5302: INV_MGD_MVT_UTILS_PKG.Get_Org_Location(p_warehouse_id => l_movement_transaction.organization_id);
5303:
5304: --Debug
5305: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
5306: THEN
5307: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
5308: ,G_MODULE_NAME || l_api_name
5309: ,'l_dispatch:' || l_dispatch ||

Line 5307: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

5303:
5304: --Debug
5305: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
5306: THEN
5307: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
5308: ,G_MODULE_NAME || l_api_name
5309: ,'l_dispatch:' || l_dispatch ||
5310: ':l_destination:' || l_destination
5311: );

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

5326: , p_trans_date => l_movement_Transaction.transaction_date
5327: );
5328:
5329: --Debug
5330: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
5331: THEN
5332: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
5333: ,G_MODULE_NAME || l_api_name
5334: ,'ship_from:' || l_ship_from_loc ||

Line 5332: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

5328:
5329: --Debug
5330: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
5331: THEN
5332: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
5333: ,G_MODULE_NAME || l_api_name
5334: ,'ship_from:' || l_ship_from_loc ||
5335: ':ship_to:' || l_ship_to_loc
5336: );

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

5365: l_insert := 'N';
5366: END IF;
5367:
5368: --Debug
5369: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
5370: THEN
5371: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
5372: ,G_MODULE_NAME || l_api_name
5373: ,'l_insert:' || l_insert

Line 5371: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

5367:
5368: --Debug
5369: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
5370: THEN
5371: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
5372: ,G_MODULE_NAME || l_api_name
5373: ,'l_insert:' || l_insert
5374: );
5375: END IF;

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

5397: FND_FILE.put_line (FND_FILE.log ,'mvt stat status after update'||l_mvt_stat_status );
5398: FND_FILE.put_line (FND_FILE.log ,'Case 1.1 : RMA Invoice Based Triangulation run at booking LE where booking LE country is same as the customer country' );
5399:
5400: --Debug
5401: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
5402: THEN
5403: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
5404: ,G_MODULE_NAME || l_api_name || 'Case 1.1 : RMA Invoice Based Triangulation run at booking LE where booking LE country is same as the customer country'
5405: ,'New mvt status:' || l_mvt_stat_status

Line 5403: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

5399:
5400: --Debug
5401: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
5402: THEN
5403: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
5404: ,G_MODULE_NAME || l_api_name || 'Case 1.1 : RMA Invoice Based Triangulation run at booking LE where booking LE country is same as the customer country'
5405: ,'New mvt status:' || l_mvt_stat_status
5406: );
5407: END IF;

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

5424: NVL(l_subinv_terr_code, l_org_terr_code);
5425: l_process_flag := 'Y';
5426:
5427: --Debug
5428: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
5429: THEN
5430: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
5431: ,G_MODULE_NAME || l_api_name
5432: ,'dest:' || l_movement_transaction.destination_territory_code ||

Line 5430: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

5426:
5427: --Debug
5428: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
5429: THEN
5430: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
5431: ,G_MODULE_NAME || l_api_name
5432: ,'dest:' || l_movement_transaction.destination_territory_code ||
5433: ':l_process_flag:' || l_process_flag ||
5434: ':include_establishments:' || l_stat_typ_transaction.include_establishments

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

5448: END IF;
5449: FND_FILE.put_line (FND_FILE.log ,'Case 2 : RMA Shipment Based Triangulation run at receiving LE' );
5450:
5451: --Debug
5452: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
5453: THEN
5454: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
5455: ,G_MODULE_NAME || l_api_name || 'Case 2 : RMA Shipment Based Triangulation run at receiving LE'
5456: ,'l_insert_flag:' || l_insert_flag

Line 5454: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

5450:
5451: --Debug
5452: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
5453: THEN
5454: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
5455: ,G_MODULE_NAME || l_api_name || 'Case 2 : RMA Shipment Based Triangulation run at receiving LE'
5456: ,'l_insert_flag:' || l_insert_flag
5457: );
5458: END IF;

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

5480: /* triangulation country would be the country where the RMA was created / booked */
5481: l_movement_transaction.triangulation_country_code := l_sold_from_org_code;
5482:
5483: --Debug
5484: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
5485: THEN
5486: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
5487: ,G_MODULE_NAME || l_api_name
5488: ,'dest:' || l_movement_transaction.destination_territory_code ||

Line 5486: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

5482:
5483: --Debug
5484: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
5485: THEN
5486: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
5487: ,G_MODULE_NAME || l_api_name
5488: ,'dest:' || l_movement_transaction.destination_territory_code ||
5489: ':l_process_flag:' || l_process_flag ||
5490: ':include_establishments:' || l_stat_typ_transaction.include_establishments ||

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

5504: l_insert_flag := INV_MGD_MVT_SETUP_MDTR.Process_Setup_Context
5505: ( p_movement_transaction => l_movement_transaction);
5506:
5507: --Debug
5508: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
5509: THEN
5510: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
5511: ,G_MODULE_NAME || l_api_name
5512: ,'l_insert_flag:' || l_insert_flag ||

Line 5510: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

5506:
5507: --Debug
5508: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
5509: THEN
5510: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
5511: ,G_MODULE_NAME || l_api_name
5512: ,'l_insert_flag:' || l_insert_flag ||
5513: ':mvt_status:' || l_mvt_stat_status
5514: );

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

5527: END IF;
5528: FND_FILE.put_line (FND_FILE.log ,'Case 3 : RMA Invoice Based Triangulation run at receiving LE' );
5529:
5530: --Debug
5531: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
5532: THEN
5533: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
5534: ,G_MODULE_NAME || l_api_name || 'Case 3 : RMA Invoice Based Triangulation run at receiving LE'
5535: ,'New mvt_status:' || l_mvt_stat_status

Line 5533: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

5529:
5530: --Debug
5531: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
5532: THEN
5533: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
5534: ,G_MODULE_NAME || l_api_name || 'Case 3 : RMA Invoice Based Triangulation run at receiving LE'
5535: ,'New mvt_status:' || l_mvt_stat_status
5536: );
5537: END IF;

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

5547: NVL(l_subinv_terr_code, l_org_terr_code);
5548: l_process_flag := 'Y';
5549:
5550: --Debug
5551: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
5552: THEN
5553: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
5554: ,G_MODULE_NAME || l_api_name
5555: ,'dest:' || l_movement_transaction.destination_territory_code ||

Line 5553: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

5549:
5550: --Debug
5551: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
5552: THEN
5553: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
5554: ,G_MODULE_NAME || l_api_name
5555: ,'dest:' || l_movement_transaction.destination_territory_code ||
5556: ':l_process_flag:' || l_process_flag ||
5557: ':include_establishments:' || l_stat_typ_transaction.include_establishments

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

5568: THEN
5569: l_insert_flag := INV_MGD_MVT_SETUP_MDTR.Process_Setup_Context
5570: ( p_movement_transaction => l_movement_transaction);
5571: --Debug
5572: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
5573: THEN
5574: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
5575: ,G_MODULE_NAME || l_api_name || 'Case4: RMA LE is same as receiving LE'
5576: ,'l_insert_flag:' || l_insert_flag

Line 5574: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

5570: ( p_movement_transaction => l_movement_transaction);
5571: --Debug
5572: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
5573: THEN
5574: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
5575: ,G_MODULE_NAME || l_api_name || 'Case4: RMA LE is same as receiving LE'
5576: ,'l_insert_flag:' || l_insert_flag
5577: );
5578: END IF;

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

5580:
5581: END IF;
5582:
5583: --Debug
5584: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
5585: THEN
5586: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
5587: ,G_MODULE_NAME || l_api_name
5588: ,'l_insert_flag:' || l_insert_flag ||

Line 5586: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

5582:
5583: --Debug
5584: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
5585: THEN
5586: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
5587: ,G_MODULE_NAME || l_api_name
5588: ,'l_insert_flag:' || l_insert_flag ||
5589: ':l_return_status:' || l_return_status
5590: );

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

5601: );
5602:
5603: IF l_return_status <> FND_API.G_RET_STS_SUCCESS
5604: THEN
5605: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
5606: THEN
5607: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
5608: , G_MODULE_NAME || l_api_name
5609: || '.Failed when call mvt_stats_util_info'

Line 5607: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED

5603: IF l_return_status <> FND_API.G_RET_STS_SUCCESS
5604: THEN
5605: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
5606: THEN
5607: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
5608: , G_MODULE_NAME || l_api_name
5609: || '.Failed when call mvt_stats_util_info'
5610: ,'Failed'
5611: );

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

5652: l_movement_id := l_movement_transaction.movement_id;
5653: g_records_inserted := g_records_inserted +1;
5654:
5655: --Debug
5656: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
5657: THEN
5658: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
5659: ,G_MODULE_NAME || l_api_name
5660: ,'Created Movement Id::' || l_movement_id ||

Line 5658: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

5654:
5655: --Debug
5656: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
5657: THEN
5658: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
5659: ,G_MODULE_NAME || l_api_name
5660: ,'Created Movement Id::' || l_movement_id ||
5661: '::for transaction_id::' || l_movement_transaction.rcv_transaction_id
5662: );

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

5679:
5680: IF NVL(l_process_flag,'N') = 'Y'
5681: THEN
5682: --Debug
5683: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
5684: THEN
5685: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
5686: ,G_MODULE_NAME || l_api_name
5687: ,'Before upadting the RMA with status::' || l_mvt_stat_status

Line 5685: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

5681: THEN
5682: --Debug
5683: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
5684: THEN
5685: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
5686: ,G_MODULE_NAME || l_api_name
5687: ,'Before upadting the RMA with status::' || l_mvt_stat_status
5688: );
5689: END IF;

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

5705: END LOOP l_outer;
5706: CLOSE rma_crsr;
5707: END IF;
5708:
5709: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
5710: THEN
5711: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
5712: , G_MODULE_NAME || l_api_name || '.end'
5713: ,'exit procedure'

Line 5711: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

5707: END IF;
5708:
5709: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
5710: THEN
5711: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
5712: , G_MODULE_NAME || l_api_name || '.end'
5713: ,'exit procedure'
5714: );
5715: END IF;

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

5718: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5719: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5720: l_error := SUBSTRB(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE),1,250);
5721:
5722: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
5723: THEN
5724: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
5725: , G_MODULE_NAME || l_api_name||'. Unexpected exception'
5726: , l_error

Line 5724: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED

5720: l_error := SUBSTRB(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE),1,250);
5721:
5722: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
5723: THEN
5724: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
5725: , G_MODULE_NAME || l_api_name||'. Unexpected exception'
5726: , l_error
5727: );
5728: END IF;

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

5727: );
5728: END IF;
5729:
5730: WHEN NO_DATA_FOUND THEN
5731: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
5732: THEN
5733: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
5734: , G_MODULE_NAME || l_api_name||'. No data found exception'
5735: , l_error

Line 5733: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED

5729:
5730: WHEN NO_DATA_FOUND THEN
5731: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
5732: THEN
5733: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
5734: , G_MODULE_NAME || l_api_name||'. No data found exception'
5735: , l_error
5736: );
5737: END IF;

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

5744: , 'Others exception in '||l_api_name
5745: );
5746: END IF;
5747:
5748: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
5749: THEN
5750: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
5751: , G_MODULE_NAME || l_api_name||'. Others exception'
5752: , l_error

Line 5750: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED

5746: END IF;
5747:
5748: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
5749: THEN
5750: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
5751: , G_MODULE_NAME || l_api_name||'. Others exception'
5752: , l_error
5753: );
5754: END IF;

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

5792: l_api_name CONSTANT VARCHAR2(30) := 'Update_Invoice_Info';
5793: l_error VARCHAR2(600);
5794:
5795: BEGIN
5796: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
5797: THEN
5798: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
5799: , G_MODULE_NAME || l_api_name || '.begin'
5800: ,'enter procedure'

Line 5798: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

5794:
5795: BEGIN
5796: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
5797: THEN
5798: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
5799: , G_MODULE_NAME || l_api_name || '.begin'
5800: ,'enter procedure'
5801: );
5802: END IF;

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

6059: END LOOP ;
6060: CLOSE inv_crsr;
6061: END IF;
6062:
6063: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
6064: THEN
6065: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
6066: , G_MODULE_NAME || l_api_name || '.end'
6067: ,'exit procedure'

Line 6065: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

6061: END IF;
6062:
6063: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
6064: THEN
6065: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
6066: , G_MODULE_NAME || l_api_name || '.end'
6067: ,'exit procedure'
6068: );
6069: END IF;

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

6072: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6073: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6074: l_error := SUBSTRB(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE),1,250);
6075:
6076: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
6077: THEN
6078: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
6079: , G_MODULE_NAME || l_api_name||'. Unexpected exception'
6080: , l_error

Line 6078: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED

6074: l_error := SUBSTRB(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE),1,250);
6075:
6076: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
6077: THEN
6078: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
6079: , G_MODULE_NAME || l_api_name||'. Unexpected exception'
6080: , l_error
6081: );
6082: END IF;

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

6081: );
6082: END IF;
6083:
6084: WHEN NO_DATA_FOUND THEN
6085: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
6086: THEN
6087: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
6088: , G_MODULE_NAME || l_api_name||'. No data found exception'
6089: , l_error

Line 6087: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED

6083:
6084: WHEN NO_DATA_FOUND THEN
6085: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
6086: THEN
6087: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
6088: , G_MODULE_NAME || l_api_name||'. No data found exception'
6089: , l_error
6090: );
6091: END IF;

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

6098: , 'Others exception in '||l_api_name
6099: );
6100: END IF;
6101:
6102: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
6103: THEN
6104: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
6105: , G_MODULE_NAME || l_api_name||'. Others exception'
6106: , l_error

Line 6104: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED

6100: END IF;
6101:
6102: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
6103: THEN
6104: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
6105: , G_MODULE_NAME || l_api_name||'. Others exception'
6106: , l_error
6107: );
6108: END IF;

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

6157: WHERE parent_transaction_id = l_movement_transaction.rcv_transaction_id
6158: AND mvt_stat_status = 'NEW'
6159: AND transaction_type = 'CORRECT';
6160: BEGIN
6161: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
6162: THEN
6163: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
6164: , G_MODULE_NAME || l_api_name || '.begin'
6165: ,'enter procedure'

Line 6163: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

6159: AND transaction_type = 'CORRECT';
6160: BEGIN
6161: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
6162: THEN
6163: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
6164: , G_MODULE_NAME || l_api_name || '.begin'
6165: ,'enter procedure'
6166: );
6167: END IF;

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

6431: END LOOP ;
6432: CLOSE inv_crsr;
6433: END IF;
6434:
6435: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
6436: THEN
6437: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
6438: , G_MODULE_NAME || l_api_name || '.end'
6439: ,'exit procedure'

Line 6437: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

6433: END IF;
6434:
6435: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
6436: THEN
6437: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
6438: , G_MODULE_NAME || l_api_name || '.end'
6439: ,'exit procedure'
6440: );
6441: END IF;

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

6444: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6445: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6446: l_error := SUBSTRB(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE),1,250);
6447:
6448: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
6449: THEN
6450: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
6451: , G_MODULE_NAME || l_api_name||'. Unexpected exception'
6452: , l_error

Line 6450: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED

6446: l_error := SUBSTRB(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE),1,250);
6447:
6448: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
6449: THEN
6450: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
6451: , G_MODULE_NAME || l_api_name||'. Unexpected exception'
6452: , l_error
6453: );
6454: END IF;

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

6453: );
6454: END IF;
6455:
6456: WHEN NO_DATA_FOUND THEN
6457: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
6458: THEN
6459: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
6460: , G_MODULE_NAME || l_api_name||'. No data found exception'
6461: , l_error

Line 6459: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED

6455:
6456: WHEN NO_DATA_FOUND THEN
6457: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
6458: THEN
6459: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
6460: , G_MODULE_NAME || l_api_name||'. No data found exception'
6461: , l_error
6462: );
6463: END IF;

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

6470: , 'Others exception in '||l_api_name
6471: );
6472: END IF;
6473:
6474: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
6475: THEN
6476: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
6477: , G_MODULE_NAME || l_api_name||'. Others exception'
6478: , l_error

Line 6476: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED

6472: END IF;
6473:
6474: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
6475: THEN
6476: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
6477: , G_MODULE_NAME || l_api_name||'. Others exception'
6478: , l_error
6479: );
6480: END IF;

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

6520: l_api_name CONSTANT VARCHAR2(30) := 'Process_Pending_Transaction';
6521: l_error VARCHAR2(600);
6522:
6523: BEGIN
6524: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
6525: THEN
6526: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
6527: , G_MODULE_NAME || l_api_name || '.begin'
6528: ,'enter procedure'

Line 6526: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

6522:
6523: BEGIN
6524: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
6525: THEN
6526: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
6527: , G_MODULE_NAME || l_api_name || '.begin'
6528: ,'enter procedure'
6529: );
6530: END IF;

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

6830: END LOOP ;
6831: CLOSE mvt_crsr;
6832: END IF;
6833:
6834: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
6835: THEN
6836: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
6837: , G_MODULE_NAME || l_api_name || '.end'
6838: ,'exit procedure'

Line 6836: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

6832: END IF;
6833:
6834: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
6835: THEN
6836: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
6837: , G_MODULE_NAME || l_api_name || '.end'
6838: ,'exit procedure'
6839: );
6840: END IF;

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

6843: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6844: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6845: l_error := SUBSTRB(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE),1,250);
6846:
6847: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
6848: THEN
6849: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
6850: , G_MODULE_NAME || l_api_name||'. Unexpected exception'
6851: , l_error

Line 6849: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED

6845: l_error := SUBSTRB(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE),1,250);
6846:
6847: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
6848: THEN
6849: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
6850: , G_MODULE_NAME || l_api_name||'. Unexpected exception'
6851: , l_error
6852: );
6853: END IF;

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

6852: );
6853: END IF;
6854:
6855: WHEN NO_DATA_FOUND THEN
6856: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
6857: THEN
6858: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
6859: , G_MODULE_NAME || l_api_name||'. No data found exception'
6860: , l_error

Line 6858: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED

6854:
6855: WHEN NO_DATA_FOUND THEN
6856: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
6857: THEN
6858: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
6859: , G_MODULE_NAME || l_api_name||'. No data found exception'
6860: , l_error
6861: );
6862: END IF;

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

6869: , 'Others exception in '||l_api_name
6870: );
6871: END IF;
6872:
6873: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
6874: THEN
6875: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
6876: , G_MODULE_NAME || l_api_name||'. Others exception'
6877: , l_error

Line 6875: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED

6871: END IF;
6872:
6873: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
6874: THEN
6875: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
6876: , G_MODULE_NAME || l_api_name||'. Others exception'
6877: , l_error
6878: );
6879: END IF;