eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.INV_MGD_PRD_CONTROL_MEDIATOR dependencies on INV_ORGHIERARCHY_PVT

Line 136: --- INV_ORGHIERARCHY_PVT.Log

132: l_return_flag VARCHAR2(1);
133:
134: BEGIN
135:
136: --- INV_ORGHIERARCHY_PVT.Log
137: --- (INV_ORGHIERARCHY_PVT.G_LOG_PROCEDURE
138: --- ,'> GET_CLOSED_STATUS for acct_period ' || p_acct_period_id
139: --- || ' Org Name:' || p_org
140: --- );

Line 137: --- (INV_ORGHIERARCHY_PVT.G_LOG_PROCEDURE

133:
134: BEGIN
135:
136: --- INV_ORGHIERARCHY_PVT.Log
137: --- (INV_ORGHIERARCHY_PVT.G_LOG_PROCEDURE
138: --- ,'> GET_CLOSED_STATUS for acct_period ' || p_acct_period_id
139: --- || ' Org Name:' || p_org
140: --- );
141:

Line 182: --- INV_ORGHIERARCHY_PVT.Log

178: l_return_flag := 'N' ;
179: END IF;
180:
181:
182: --- INV_ORGHIERARCHY_PVT.Log
183: --- (INV_ORGHIERARCHY_PVT.G_LOG_PROCEDURE
184: --- ,'< GET_CLOSED_STATUS with flag ' || l_return_flag
185: --- );
186:

Line 183: --- (INV_ORGHIERARCHY_PVT.G_LOG_PROCEDURE

179: END IF;
180:
181:
182: --- INV_ORGHIERARCHY_PVT.Log
183: --- (INV_ORGHIERARCHY_PVT.G_LOG_PROCEDURE
184: --- ,'< GET_CLOSED_STATUS with flag ' || l_return_flag
185: --- );
186:
187: RETURN l_return_flag;

Line 196: INV_ORGHIERARCHY_PVT.Log( INV_ORGHIERARCHY_PVT.G_LOG_EXCEPTION

192: Error/Exception logging should not depend on
193: FND Debug Enabled profile otpion. Bug: 3555234
194: IF G_DEBUG = 'Y' THEN
195: */
196: INV_ORGHIERARCHY_PVT.Log( INV_ORGHIERARCHY_PVT.G_LOG_EXCEPTION
197: , 'SQLERRM '|| SQLERRM);
198: --END IF;
199:
200: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 238: ---INV_ORGHIERARCHY_PVT.Log

234: -- Loop through the PL/SQL table and verify the
235: -- status of the programs that are still not
236: -- COMPLETE status
237:
238: ---INV_ORGHIERARCHY_PVT.Log
239: ---(INV_ORGHIERARCHY_PVT.G_LOG_PROCEDURE
240: --- ,'> GET_OPEN_REQUESTS_COUNT '
241: ---);
242:

Line 239: ---(INV_ORGHIERARCHY_PVT.G_LOG_PROCEDURE

235: -- status of the programs that are still not
236: -- COMPLETE status
237:
238: ---INV_ORGHIERARCHY_PVT.Log
239: ---(INV_ORGHIERARCHY_PVT.G_LOG_PROCEDURE
240: --- ,'> GET_OPEN_REQUESTS_COUNT '
241: ---);
242:
243: FOR I IN 1 .. G_LOG_REPORT_TABLE.COUNT

Line 250: --- INV_ORGHIERARCHY_PVT.Log

246: THEN
247: IF NVL(G_LOG_REPORT_TABLE(I).request_status , 'X')
248: <> 'COMPLETE'
249: THEN
250: --- INV_ORGHIERARCHY_PVT.Log
251: --- (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
252: --- ,' Checking request status: '||
253: --- G_LOG_REPORT_TABLE(I).request_id
254: --- );

Line 251: --- (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT

247: IF NVL(G_LOG_REPORT_TABLE(I).request_status , 'X')
248: <> 'COMPLETE'
249: THEN
250: --- INV_ORGHIERARCHY_PVT.Log
251: --- (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
252: --- ,' Checking request status: '||
253: --- G_LOG_REPORT_TABLE(I).request_id
254: --- );
255:

Line 275: -- INV_ORGHIERARCHY_PVT.Log

271: l_request_status := 'COMPLETE';
272: END IF;
273:
274:
275: -- INV_ORGHIERARCHY_PVT.Log
276: -- (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
277: -- ,' Out with status: '|| l_request_status
278: -- );
279:

Line 276: -- (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT

272: END IF;
273:
274:
275: -- INV_ORGHIERARCHY_PVT.Log
276: -- (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
277: -- ,' Out with status: '|| l_request_status
278: -- );
279:
280: IF l_request_status = 'COMPLETE'

Line 311: ---INV_ORGHIERARCHY_PVT.Log

307: G_LOG_REPORT_TABLE(I).status := 'Closed' ;
308: END IF;
309: END LOOP ;
310:
311: ---INV_ORGHIERARCHY_PVT.Log
312: ---(INV_ORGHIERARCHY_PVT.G_LOG_PROCEDURE
313: ---,'< GET_OPEN_REQUESTS_COUNT with count '|| l_count
314: ---);
315:

Line 312: ---(INV_ORGHIERARCHY_PVT.G_LOG_PROCEDURE

308: END IF;
309: END LOOP ;
310:
311: ---INV_ORGHIERARCHY_PVT.Log
312: ---(INV_ORGHIERARCHY_PVT.G_LOG_PROCEDURE
313: ---,'< GET_OPEN_REQUESTS_COUNT with count '|| l_count
314: ---);
315:
316: RETURN l_count ;

Line 325: INV_ORGHIERARCHY_PVT.Log( INV_ORGHIERARCHY_PVT.G_LOG_EXCEPTION

321: Error/Exception logging should not depend on
322: FND Debug Enabled profile otpion. Bug: 3555234
323: IF G_DEBUG = 'Y' THEN
324: */
325: INV_ORGHIERARCHY_PVT.Log( INV_ORGHIERARCHY_PVT.G_LOG_EXCEPTION
326: , 'SQLERRM '|| SQLERRM) ;
327: --END IF;
328:
329: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 366: ---INV_ORGHIERARCHY_PVT.Log

362: I NUMBER ;
363:
364: BEGIN
365:
366: ---INV_ORGHIERARCHY_PVT.Log
367: ---(INV_ORGHIERARCHY_PVT.G_LOG_PROCEDURE
368: --- ,'> ADD_ITEM for period ' || p_period
369: ---);
370:

Line 367: ---(INV_ORGHIERARCHY_PVT.G_LOG_PROCEDURE

363:
364: BEGIN
365:
366: ---INV_ORGHIERARCHY_PVT.Log
367: ---(INV_ORGHIERARCHY_PVT.G_LOG_PROCEDURE
368: --- ,'> ADD_ITEM for period ' || p_period
369: ---);
370:
371: I := NVL(G_LOG_REPORT_TABLE.COUNT, 0 ) + 1 ;

Line 373: ---INV_ORGHIERARCHY_PVT.Log

369: ---);
370:
371: I := NVL(G_LOG_REPORT_TABLE.COUNT, 0 ) + 1 ;
372:
373: ---INV_ORGHIERARCHY_PVT.Log
374: ---(INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
375: --- ,' No of records in the report table = '|| i
376: ---);
377:

Line 374: ---(INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT

370:
371: I := NVL(G_LOG_REPORT_TABLE.COUNT, 0 ) + 1 ;
372:
373: ---INV_ORGHIERARCHY_PVT.Log
374: ---(INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
375: --- ,' No of records in the report table = '|| i
376: ---);
377:
378:

Line 390: ---INV_ORGHIERARCHY_PVT.Log

386:
387: I := NULL ;
388:
389:
390: ---INV_ORGHIERARCHY_PVT.Log
391: ---(INV_ORGHIERARCHY_PVT.G_LOG_PROCEDURE
392: --- ,'< ADD_ITEM '
393: ---);
394:

Line 391: ---(INV_ORGHIERARCHY_PVT.G_LOG_PROCEDURE

387: I := NULL ;
388:
389:
390: ---INV_ORGHIERARCHY_PVT.Log
391: ---(INV_ORGHIERARCHY_PVT.G_LOG_PROCEDURE
392: --- ,'< ADD_ITEM '
393: ---);
394:
395: END ADD_ITEM ;

Line 414: INV_ORGHIERARCHY_PVT.Log

410: /* Variable initialization is shifted from declaration section. It was done during bug:3638081 fix to resolve GSCC warning */
411: l_space := ' ' ;
412: IF G_DEBUG = 'Y' THEN
413:
414: INV_ORGHIERARCHY_PVT.Log
415: (INV_ORGHIERARCHY_PVT.G_LOG_PROCEDURE
416: ,'> PRINT_REPORT '
417: );
418:

Line 415: (INV_ORGHIERARCHY_PVT.G_LOG_PROCEDURE

411: l_space := ' ' ;
412: IF G_DEBUG = 'Y' THEN
413:
414: INV_ORGHIERARCHY_PVT.Log
415: (INV_ORGHIERARCHY_PVT.G_LOG_PROCEDURE
416: ,'> PRINT_REPORT '
417: );
418:
419: INV_ORGHIERARCHY_PVT.Log

Line 419: INV_ORGHIERARCHY_PVT.Log

415: (INV_ORGHIERARCHY_PVT.G_LOG_PROCEDURE
416: ,'> PRINT_REPORT '
417: );
418:
419: INV_ORGHIERARCHY_PVT.Log
420: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
421: ,' '
422: );
423: END IF;

Line 420: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT

416: ,'> PRINT_REPORT '
417: );
418:
419: INV_ORGHIERARCHY_PVT.Log
420: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
421: ,' '
422: );
423: END IF;
424:

Line 430: INV_ORGHIERARCHY_PVT.Log

426: Following code block is modified to change log level. Replaced
427: G_LOG_STATEMENT wtih G_LOG_PRINT becasue basic report will be printed
428: irrespective of FND Debug Enabled profile option.
429: */
430: INV_ORGHIERARCHY_PVT.Log
431: (INV_ORGHIERARCHY_PVT.G_LOG_PRINT
432: ,' '
433: );
434:

Line 431: (INV_ORGHIERARCHY_PVT.G_LOG_PRINT

427: G_LOG_STATEMENT wtih G_LOG_PRINT becasue basic report will be printed
428: irrespective of FND Debug Enabled profile option.
429: */
430: INV_ORGHIERARCHY_PVT.Log
431: (INV_ORGHIERARCHY_PVT.G_LOG_PRINT
432: ,' '
433: );
434:
435: INV_ORGHIERARCHY_PVT.Log

Line 435: INV_ORGHIERARCHY_PVT.Log

431: (INV_ORGHIERARCHY_PVT.G_LOG_PRINT
432: ,' '
433: );
434:
435: INV_ORGHIERARCHY_PVT.Log
436: (INV_ORGHIERARCHY_PVT.G_LOG_PRINT
437: ,'************** Begin Report **************************** '
438: );
439:

Line 436: (INV_ORGHIERARCHY_PVT.G_LOG_PRINT

432: ,' '
433: );
434:
435: INV_ORGHIERARCHY_PVT.Log
436: (INV_ORGHIERARCHY_PVT.G_LOG_PRINT
437: ,'************** Begin Report **************************** '
438: );
439:
440: FOR I IN G_LOG_REPORT_TABLE.FIRST .. G_LOG_REPORT_TABLE.LAST

Line 444: INV_ORGHIERARCHY_PVT.Log

440: FOR I IN G_LOG_REPORT_TABLE.FIRST .. G_LOG_REPORT_TABLE.LAST
441: LOOP
442: IF G_LOG_REPORT_TABLE(I).org IS NOT NULL
443: THEN
444: INV_ORGHIERARCHY_PVT.Log
445: (INV_ORGHIERARCHY_PVT.G_LOG_PRINT
446: ,' '
447: );
448:

Line 445: (INV_ORGHIERARCHY_PVT.G_LOG_PRINT

441: LOOP
442: IF G_LOG_REPORT_TABLE(I).org IS NOT NULL
443: THEN
444: INV_ORGHIERARCHY_PVT.Log
445: (INV_ORGHIERARCHY_PVT.G_LOG_PRINT
446: ,' '
447: );
448:
449: INV_ORGHIERARCHY_PVT.Log

Line 449: INV_ORGHIERARCHY_PVT.Log

445: (INV_ORGHIERARCHY_PVT.G_LOG_PRINT
446: ,' '
447: );
448:
449: INV_ORGHIERARCHY_PVT.Log
450: (INV_ORGHIERARCHY_PVT.G_LOG_PRINT
451: ,'.................................................. '
452: );
453:

Line 450: (INV_ORGHIERARCHY_PVT.G_LOG_PRINT

446: ,' '
447: );
448:
449: INV_ORGHIERARCHY_PVT.Log
450: (INV_ORGHIERARCHY_PVT.G_LOG_PRINT
451: ,'.................................................. '
452: );
453:
454: INV_ORGHIERARCHY_PVT.Log

Line 454: INV_ORGHIERARCHY_PVT.Log

450: (INV_ORGHIERARCHY_PVT.G_LOG_PRINT
451: ,'.................................................. '
452: );
453:
454: INV_ORGHIERARCHY_PVT.Log
455: (INV_ORGHIERARCHY_PVT.G_LOG_PRINT
456: ,'ORGANIZATION : ' || G_LOG_REPORT_TABLE(I).org
457: );
458:

Line 455: (INV_ORGHIERARCHY_PVT.G_LOG_PRINT

451: ,'.................................................. '
452: );
453:
454: INV_ORGHIERARCHY_PVT.Log
455: (INV_ORGHIERARCHY_PVT.G_LOG_PRINT
456: ,'ORGANIZATION : ' || G_LOG_REPORT_TABLE(I).org
457: );
458:
459: INV_ORGHIERARCHY_PVT.Log

Line 459: INV_ORGHIERARCHY_PVT.Log

455: (INV_ORGHIERARCHY_PVT.G_LOG_PRINT
456: ,'ORGANIZATION : ' || G_LOG_REPORT_TABLE(I).org
457: );
458:
459: INV_ORGHIERARCHY_PVT.Log
460: (INV_ORGHIERARCHY_PVT.G_LOG_PRINT
461: ,' '
462: );
463:

Line 460: (INV_ORGHIERARCHY_PVT.G_LOG_PRINT

456: ,'ORGANIZATION : ' || G_LOG_REPORT_TABLE(I).org
457: );
458:
459: INV_ORGHIERARCHY_PVT.Log
460: (INV_ORGHIERARCHY_PVT.G_LOG_PRINT
461: ,' '
462: );
463:
464: ELSE

Line 465: INV_ORGHIERARCHY_PVT.Log

461: ,' '
462: );
463:
464: ELSE
465: INV_ORGHIERARCHY_PVT.Log
466: (INV_ORGHIERARCHY_PVT.G_LOG_PRINT
467: , G_LOG_REPORT_TABLE(I).period || l_space ||
468: G_LOG_REPORT_TABLE(I).status
469: || l_space || G_LOG_REPORT_TABLE(I).reason

Line 466: (INV_ORGHIERARCHY_PVT.G_LOG_PRINT

462: );
463:
464: ELSE
465: INV_ORGHIERARCHY_PVT.Log
466: (INV_ORGHIERARCHY_PVT.G_LOG_PRINT
467: , G_LOG_REPORT_TABLE(I).period || l_space ||
468: G_LOG_REPORT_TABLE(I).status
469: || l_space || G_LOG_REPORT_TABLE(I).reason
470: );

Line 475: INV_ORGHIERARCHY_PVT.Log

471:
472: END IF;
473: END LOOP;
474:
475: INV_ORGHIERARCHY_PVT.Log
476: (INV_ORGHIERARCHY_PVT.G_LOG_PRINT
477: ,' '
478: );
479:

Line 476: (INV_ORGHIERARCHY_PVT.G_LOG_PRINT

472: END IF;
473: END LOOP;
474:
475: INV_ORGHIERARCHY_PVT.Log
476: (INV_ORGHIERARCHY_PVT.G_LOG_PRINT
477: ,' '
478: );
479:
480: INV_ORGHIERARCHY_PVT.Log

Line 480: INV_ORGHIERARCHY_PVT.Log

476: (INV_ORGHIERARCHY_PVT.G_LOG_PRINT
477: ,' '
478: );
479:
480: INV_ORGHIERARCHY_PVT.Log
481: (INV_ORGHIERARCHY_PVT.G_LOG_PRINT
482: ,'************** End Report **************************** '
483: );
484:

Line 481: (INV_ORGHIERARCHY_PVT.G_LOG_PRINT

477: ,' '
478: );
479:
480: INV_ORGHIERARCHY_PVT.Log
481: (INV_ORGHIERARCHY_PVT.G_LOG_PRINT
482: ,'************** End Report **************************** '
483: );
484:
485: INV_ORGHIERARCHY_PVT.Log

Line 485: INV_ORGHIERARCHY_PVT.Log

481: (INV_ORGHIERARCHY_PVT.G_LOG_PRINT
482: ,'************** End Report **************************** '
483: );
484:
485: INV_ORGHIERARCHY_PVT.Log
486: (INV_ORGHIERARCHY_PVT.G_LOG_PROCEDURE
487: ,' '
488: );
489:

Line 486: (INV_ORGHIERARCHY_PVT.G_LOG_PROCEDURE

482: ,'************** End Report **************************** '
483: );
484:
485: INV_ORGHIERARCHY_PVT.Log
486: (INV_ORGHIERARCHY_PVT.G_LOG_PROCEDURE
487: ,' '
488: );
489:
490: IF G_DEBUG = 'Y' THEN

Line 492: INV_ORGHIERARCHY_PVT.Log

488: );
489:
490: IF G_DEBUG = 'Y' THEN
491:
492: INV_ORGHIERARCHY_PVT.Log
493: (INV_ORGHIERARCHY_PVT.G_LOG_PROCEDURE
494: ,'< PRINT_REPORT '
495: );
496:

Line 493: (INV_ORGHIERARCHY_PVT.G_LOG_PROCEDURE

489:
490: IF G_DEBUG = 'Y' THEN
491:
492: INV_ORGHIERARCHY_PVT.Log
493: (INV_ORGHIERARCHY_PVT.G_LOG_PROCEDURE
494: ,'< PRINT_REPORT '
495: );
496:
497: END IF;

Line 523: INV_ORGHIERARCHY_PVT.Log

519:
520: BEGIN
521:
522: IF G_DEBUG = 'Y' THEN
523: INV_ORGHIERARCHY_PVT.Log
524: (INV_ORGHIERARCHY_PVT.G_LOG_PROCEDURE
525: ,'> GET_MAX_OPEN_PERIOD '
526: );
527: END IF;

Line 524: (INV_ORGHIERARCHY_PVT.G_LOG_PROCEDURE

520: BEGIN
521:
522: IF G_DEBUG = 'Y' THEN
523: INV_ORGHIERARCHY_PVT.Log
524: (INV_ORGHIERARCHY_PVT.G_LOG_PROCEDURE
525: ,'> GET_MAX_OPEN_PERIOD '
526: );
527: END IF;
528:

Line 544: INV_ORGHIERARCHY_PVT.Log

540: AND orgp.period_set_name = p_period_set_name
541: AND orgp.open_flag = 'Y' ;
542:
543: IF G_DEBUG = 'Y' THEN
544: INV_ORGHIERARCHY_PVT.Log
545: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
546: ,' Max Open period num ' || l_max_period_id
547: );
548: END IF;

Line 545: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT

541: AND orgp.open_flag = 'Y' ;
542:
543: IF G_DEBUG = 'Y' THEN
544: INV_ORGHIERARCHY_PVT.Log
545: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
546: ,' Max Open period num ' || l_max_period_id
547: );
548: END IF;
549:

Line 556: INV_ORGHIERARCHY_PVT.Log

552: THEN
553: l_max_period_id := NULL;
554:
555: IF G_DEBUG = 'Y' THEN
556: INV_ORGHIERARCHY_PVT.Log
557: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
558: ,' Open period not found '
559: );
560: END IF;

Line 557: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT

553: l_max_period_id := NULL;
554:
555: IF G_DEBUG = 'Y' THEN
556: INV_ORGHIERARCHY_PVT.Log
557: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
558: ,' Open period not found '
559: );
560: END IF;
561: END ;

Line 584: INV_ORGHIERARCHY_PVT.Log

580: AND orgp.acct_period_id = l_max_period_id
581: AND orgp.organization_id = p_org_id;
582:
583: IF G_DEBUG = 'Y' THEN
584: INV_ORGHIERARCHY_PVT.Log
585: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
586: ,' gl period found '
587: );
588: END IF;

Line 585: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT

581: AND orgp.organization_id = p_org_id;
582:
583: IF G_DEBUG = 'Y' THEN
584: INV_ORGHIERARCHY_PVT.Log
585: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
586: ,' gl period found '
587: );
588: END IF;
589:

Line 594: INV_ORGHIERARCHY_PVT.Log

590: EXCEPTION
591: WHEN NO_DATA_FOUND THEN
592:
593: IF G_DEBUG = 'Y' THEN
594: INV_ORGHIERARCHY_PVT.Log
595: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
596: ,' gl period not found '
597: );
598: END IF;

Line 595: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT

591: WHEN NO_DATA_FOUND THEN
592:
593: IF G_DEBUG = 'Y' THEN
594: INV_ORGHIERARCHY_PVT.Log
595: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
596: ,' gl period not found '
597: );
598: END IF;
599:

Line 608: INV_ORGHIERARCHY_PVT.Log

604:
605: ELSE
606:
607: IF G_DEBUG = 'Y' THEN
608: INV_ORGHIERARCHY_PVT.Log
609: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
610: ,' gl period not selcted '
611: );
612: END IF;

Line 609: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT

605: ELSE
606:
607: IF G_DEBUG = 'Y' THEN
608: INV_ORGHIERARCHY_PVT.Log
609: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
610: ,' gl period not selcted '
611: );
612: END IF;
613: x_period_name := NULL;

Line 620: INV_ORGHIERARCHY_PVT.Log

616:
617: END IF;
618:
619: IF G_DEBUG = 'Y' THEN
620: INV_ORGHIERARCHY_PVT.Log
621: (INV_ORGHIERARCHY_PVT.G_LOG_PROCEDURE
622: ,'< GET_MAX_OPEN_PERIOD '
623: );
624: END IF;

Line 621: (INV_ORGHIERARCHY_PVT.G_LOG_PROCEDURE

617: END IF;
618:
619: IF G_DEBUG = 'Y' THEN
620: INV_ORGHIERARCHY_PVT.Log
621: (INV_ORGHIERARCHY_PVT.G_LOG_PROCEDURE
622: ,'< GET_MAX_OPEN_PERIOD '
623: );
624: END IF;
625:

Line 634: INV_ORGHIERARCHY_PVT.Log( INV_ORGHIERARCHY_PVT.G_LOG_EXCEPTION

630: Error/Exception logging should not depend on
631: FND Debug Enabled profile otpion. Bug: 3555234
632: IF G_DEBUG = 'Y' THEN
633: */
634: INV_ORGHIERARCHY_PVT.Log( INV_ORGHIERARCHY_PVT.G_LOG_EXCEPTION
635: , 'SQLERRM '|| SQLERRM) ;
636: --END IF;
637:
638: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 673: INV_ORGHIERARCHY_PVT.Log

669:
670: BEGIN
671:
672: IF G_DEBUG = 'Y' THEN
673: INV_ORGHIERARCHY_PVT.Log
674: (INV_ORGHIERARCHY_PVT.G_LOG_PROCEDURE
675: ,'> GET_MIN_OPEN_PERIOD'
676: );
677: END IF;

Line 674: (INV_ORGHIERARCHY_PVT.G_LOG_PROCEDURE

670: BEGIN
671:
672: IF G_DEBUG = 'Y' THEN
673: INV_ORGHIERARCHY_PVT.Log
674: (INV_ORGHIERARCHY_PVT.G_LOG_PROCEDURE
675: ,'> GET_MIN_OPEN_PERIOD'
676: );
677: END IF;
678:

Line 690: INV_ORGHIERARCHY_PVT.Log

686: WHERE orgp.organization_id = p_org_id
687: AND orgp.period_set_name = p_period_set_name ;
688:
689: IF G_DEBUG = 'Y' THEN
690: INV_ORGHIERARCHY_PVT.Log
691: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
692: ,' Min Open period num ' || l_min_period_id
693: );
694: END IF;

Line 691: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT

687: AND orgp.period_set_name = p_period_set_name ;
688:
689: IF G_DEBUG = 'Y' THEN
690: INV_ORGHIERARCHY_PVT.Log
691: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
692: ,' Min Open period num ' || l_min_period_id
693: );
694: END IF;
695:

Line 701: INV_ORGHIERARCHY_PVT.Log

697: WHEN NO_DATA_FOUND THEN
698: l_min_period_id := NULL;
699:
700: IF G_DEBUG = 'Y' THEN
701: INV_ORGHIERARCHY_PVT.Log
702: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
703: ,' Open period not found '
704: );
705: END IF;

Line 702: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT

698: l_min_period_id := NULL;
699:
700: IF G_DEBUG = 'Y' THEN
701: INV_ORGHIERARCHY_PVT.Log
702: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
703: ,' Open period not found '
704: );
705: END IF;
706: END ;

Line 729: INV_ORGHIERARCHY_PVT.Log

725: AND orgp.acct_period_id = l_min_period_id
726: AND orgp.organization_id = p_org_id;
727:
728: IF G_DEBUG = 'Y' THEN
729: INV_ORGHIERARCHY_PVT.Log
730: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
731: ,' gl period found '
732: );
733: END IF;

Line 730: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT

726: AND orgp.organization_id = p_org_id;
727:
728: IF G_DEBUG = 'Y' THEN
729: INV_ORGHIERARCHY_PVT.Log
730: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
731: ,' gl period found '
732: );
733: END IF;
734:

Line 739: INV_ORGHIERARCHY_PVT.Log

735: EXCEPTION
736: WHEN NO_DATA_FOUND THEN
737:
738: IF G_DEBUG = 'Y' THEN
739: INV_ORGHIERARCHY_PVT.Log
740: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
741: ,' gl period not found '
742: );
743: END IF;

Line 740: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT

736: WHEN NO_DATA_FOUND THEN
737:
738: IF G_DEBUG = 'Y' THEN
739: INV_ORGHIERARCHY_PVT.Log
740: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
741: ,' gl period not found '
742: );
743: END IF;
744: x_period_name := NULL;

Line 751: INV_ORGHIERARCHY_PVT.Log

747: END ;
748:
749: ELSE
750: IF G_DEBUG = 'Y' THEN
751: INV_ORGHIERARCHY_PVT.Log
752: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
753: ,' gl period not selcted '
754: );
755: END IF;

Line 752: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT

748:
749: ELSE
750: IF G_DEBUG = 'Y' THEN
751: INV_ORGHIERARCHY_PVT.Log
752: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
753: ,' gl period not selcted '
754: );
755: END IF;
756: x_period_name := NULL;

Line 764: INV_ORGHIERARCHY_PVT.Log

760: END IF;
761:
762:
763: IF G_DEBUG = 'Y' THEN
764: INV_ORGHIERARCHY_PVT.Log
765: (INV_ORGHIERARCHY_PVT.G_LOG_PROCEDURE
766: ,'< GET_MIN_OPEN_PERIOD '
767: );
768: END IF;

Line 765: (INV_ORGHIERARCHY_PVT.G_LOG_PROCEDURE

761:
762:
763: IF G_DEBUG = 'Y' THEN
764: INV_ORGHIERARCHY_PVT.Log
765: (INV_ORGHIERARCHY_PVT.G_LOG_PROCEDURE
766: ,'< GET_MIN_OPEN_PERIOD '
767: );
768: END IF;
769:

Line 777: INV_ORGHIERARCHY_PVT.Log( INV_ORGHIERARCHY_PVT.G_LOG_EXCEPTION

773: Error/Exception logging should not depend on
774: FND Debug Enabled profile otpion. Bug: 3555234
775: IF G_DEBUG = 'Y' THEN
776: */
777: INV_ORGHIERARCHY_PVT.Log( INV_ORGHIERARCHY_PVT.G_LOG_EXCEPTION
778: , 'SQLERRM '|| SQLERRM) ;
779: --END IF;
780:
781: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 816: l_org_code_list INV_ORGHIERARCHY_PVT.OrgID_tbl_type;

812: , p_requests_count IN NUMBER
813: )
814: IS
815:
816: l_org_code_list INV_ORGHIERARCHY_PVT.OrgID_tbl_type;
817:
818: l_orgid hr_organization_units.organization_id%TYPE;
819: l_org_name VARCHAR2(240) := NULL;
820:

Line 994: INV_ORGHIERARCHY_PVT.Log

990:
991: BEGIN
992:
993: IF G_DEBUG = 'Y' THEN
994: INV_ORGHIERARCHY_PVT.Log
995: (INV_ORGHIERARCHY_PVT.G_LOG_PROCEDURE
996: ,'> INV_MGD_PRD_CONTROL_MEDIATOR.Period_Control '
997: );
998: END IF;

Line 995: (INV_ORGHIERARCHY_PVT.G_LOG_PROCEDURE

991: BEGIN
992:
993: IF G_DEBUG = 'Y' THEN
994: INV_ORGHIERARCHY_PVT.Log
995: (INV_ORGHIERARCHY_PVT.G_LOG_PROCEDURE
996: ,'> INV_MGD_PRD_CONTROL_MEDIATOR.Period_Control '
997: );
998: END IF;
999: -- Following validation block which was introduced during bug 3904824

Line 1046: INV_ORGHIERARCHY_PVT.get_organization_List (

1042: l_requests_count := p_requests_count ;
1043:
1044: x_retcode := RETCODE_SUCCESS;
1045:
1046: INV_ORGHIERARCHY_PVT.get_organization_List (
1047: p_hierarchy_id => p_org_hierarchy_id
1048: , p_origin_org_id => p_org_hierarchy_origin
1049: , x_org_id_tbl => l_org_code_list
1050: , p_include_origin => 'Y'

Line 1054: INV_ORGHIERARCHY_PVT.Log

1050: , p_include_origin => 'Y'
1051: );
1052:
1053: IF G_DEBUG = 'Y' THEN
1054: INV_ORGHIERARCHY_PVT.Log
1055: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
1056: ,' Out of Org List capture with count '|| l_org_code_list.COUNT
1057: );
1058: END IF;

Line 1055: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT

1051: );
1052:
1053: IF G_DEBUG = 'Y' THEN
1054: INV_ORGHIERARCHY_PVT.Log
1055: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
1056: ,' Out of Org List capture with count '|| l_org_code_list.COUNT
1057: );
1058: END IF;
1059:

Line 1062: l_property_flag := INV_ORGHIERARCHY_PVT.

1058: END IF;
1059:
1060: -- Bug : 3296392 - Validate for the same Calendar of all orgs in hierarchy
1061:
1062: l_property_flag := INV_ORGHIERARCHY_PVT.
1063: validate_property(l_org_code_list, 'CALENDAR');
1064:
1065: IF G_DEBUG = 'Y' THEN
1066: INV_ORGHIERARCHY_PVT.Log

Line 1066: INV_ORGHIERARCHY_PVT.Log

1062: l_property_flag := INV_ORGHIERARCHY_PVT.
1063: validate_property(l_org_code_list, 'CALENDAR');
1064:
1065: IF G_DEBUG = 'Y' THEN
1066: INV_ORGHIERARCHY_PVT.Log
1067: ( INV_ORGHIERARCHY_PVT.G_LOG_EVENT
1068: ,'Property Flag:' || l_property_flag );
1069: END IF;
1070:

Line 1067: ( INV_ORGHIERARCHY_PVT.G_LOG_EVENT

1063: validate_property(l_org_code_list, 'CALENDAR');
1064:
1065: IF G_DEBUG = 'Y' THEN
1066: INV_ORGHIERARCHY_PVT.Log
1067: ( INV_ORGHIERARCHY_PVT.G_LOG_EVENT
1068: ,'Property Flag:' || l_property_flag );
1069: END IF;
1070:
1071: IF l_property_flag = 'N' THEN

Line 1097: l_property_flag := INV_ORGHIERARCHY_PVT.

1093:
1094: END IF;
1095: -- Bug : 3296392 - Validate for the same ChartOfAccounts of all orgs in hierarchy
1096:
1097: l_property_flag := INV_ORGHIERARCHY_PVT.
1098: validate_property(l_org_code_list, 'CHART_OF_ACCOUNTS');
1099:
1100: IF G_DEBUG = 'Y' THEN
1101: INV_ORGHIERARCHY_PVT.Log

Line 1101: INV_ORGHIERARCHY_PVT.Log

1097: l_property_flag := INV_ORGHIERARCHY_PVT.
1098: validate_property(l_org_code_list, 'CHART_OF_ACCOUNTS');
1099:
1100: IF G_DEBUG = 'Y' THEN
1101: INV_ORGHIERARCHY_PVT.Log
1102: ( INV_ORGHIERARCHY_PVT.G_LOG_EVENT
1103: ,'Property Flag:' || l_property_flag );
1104: END IF;
1105:

Line 1102: ( INV_ORGHIERARCHY_PVT.G_LOG_EVENT

1098: validate_property(l_org_code_list, 'CHART_OF_ACCOUNTS');
1099:
1100: IF G_DEBUG = 'Y' THEN
1101: INV_ORGHIERARCHY_PVT.Log
1102: ( INV_ORGHIERARCHY_PVT.G_LOG_EVENT
1103: ,'Property Flag:' || l_property_flag );
1104: END IF;
1105:
1106: IF l_property_flag = 'N' THEN

Line 1135: INV_ORGHIERARCHY_PVT.Log

1131:
1132:
1133:
1134: IF G_DEBUG = 'Y' THEN
1135: INV_ORGHIERARCHY_PVT.Log
1136: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
1137: ,' '
1138: );
1139:

Line 1136: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT

1132:
1133:
1134: IF G_DEBUG = 'Y' THEN
1135: INV_ORGHIERARCHY_PVT.Log
1136: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
1137: ,' '
1138: );
1139:
1140: INV_ORGHIERARCHY_PVT.Log

Line 1140: INV_ORGHIERARCHY_PVT.Log

1136: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
1137: ,' '
1138: );
1139:
1140: INV_ORGHIERARCHY_PVT.Log
1141: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
1142: ,'*********************** Start of Report *********************** '
1143: );
1144:

Line 1141: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT

1137: ,' '
1138: );
1139:
1140: INV_ORGHIERARCHY_PVT.Log
1141: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
1142: ,'*********************** Start of Report *********************** '
1143: );
1144:
1145: INV_ORGHIERARCHY_PVT.Log

Line 1145: INV_ORGHIERARCHY_PVT.Log

1141: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
1142: ,'*********************** Start of Report *********************** '
1143: );
1144:
1145: INV_ORGHIERARCHY_PVT.Log
1146: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
1147: ,' '
1148: );
1149:

Line 1146: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT

1142: ,'*********************** Start of Report *********************** '
1143: );
1144:
1145: INV_ORGHIERARCHY_PVT.Log
1146: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
1147: ,' '
1148: );
1149:
1150: INV_ORGHIERARCHY_PVT.Log

Line 1150: INV_ORGHIERARCHY_PVT.Log

1146: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
1147: ,' '
1148: );
1149:
1150: INV_ORGHIERARCHY_PVT.Log
1151: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
1152: ,' ------------------- Running for Parameters --------------- '
1153: );
1154:

Line 1151: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT

1147: ,' '
1148: );
1149:
1150: INV_ORGHIERARCHY_PVT.Log
1151: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
1152: ,' ------------------- Running for Parameters --------------- '
1153: );
1154:
1155: INV_ORGHIERARCHY_PVT.Log

Line 1155: INV_ORGHIERARCHY_PVT.Log

1151: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
1152: ,' ------------------- Running for Parameters --------------- '
1153: );
1154:
1155: INV_ORGHIERARCHY_PVT.Log
1156: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
1157: ,' p_org_hierarchy_origin '
1158: || p_org_hierarchy_origin
1159: );

Line 1156: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT

1152: ,' ------------------- Running for Parameters --------------- '
1153: );
1154:
1155: INV_ORGHIERARCHY_PVT.Log
1156: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
1157: ,' p_org_hierarchy_origin '
1158: || p_org_hierarchy_origin
1159: );
1160:

Line 1161: INV_ORGHIERARCHY_PVT.Log

1157: ,' p_org_hierarchy_origin '
1158: || p_org_hierarchy_origin
1159: );
1160:
1161: INV_ORGHIERARCHY_PVT.Log
1162: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
1163: ,' p_org_hierarchy_id '
1164: || p_org_hierarchy_id
1165: );

Line 1162: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT

1158: || p_org_hierarchy_origin
1159: );
1160:
1161: INV_ORGHIERARCHY_PVT.Log
1162: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
1163: ,' p_org_hierarchy_id '
1164: || p_org_hierarchy_id
1165: );
1166:

Line 1167: INV_ORGHIERARCHY_PVT.Log

1163: ,' p_org_hierarchy_id '
1164: || p_org_hierarchy_id
1165: );
1166:
1167: INV_ORGHIERARCHY_PVT.Log
1168: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
1169: ,' p_close_period_name '
1170: || p_close_period_name
1171: );

Line 1168: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT

1164: || p_org_hierarchy_id
1165: );
1166:
1167: INV_ORGHIERARCHY_PVT.Log
1168: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
1169: ,' p_close_period_name '
1170: || p_close_period_name
1171: );
1172:

Line 1173: INV_ORGHIERARCHY_PVT.Log

1169: ,' p_close_period_name '
1170: || p_close_period_name
1171: );
1172:
1173: INV_ORGHIERARCHY_PVT.Log
1174: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
1175: ,' p_open_period_count '
1176: || p_open_period_count
1177: );

Line 1174: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT

1170: || p_close_period_name
1171: );
1172:
1173: INV_ORGHIERARCHY_PVT.Log
1174: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
1175: ,' p_open_period_count '
1176: || p_open_period_count
1177: );
1178:

Line 1179: INV_ORGHIERARCHY_PVT.Log

1175: ,' p_open_period_count '
1176: || p_open_period_count
1177: );
1178:
1179: INV_ORGHIERARCHY_PVT.Log
1180: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
1181: ,' p_open_or_close_flag '
1182: || p_open_or_close_flag
1183: );

Line 1180: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT

1176: || p_open_period_count
1177: );
1178:
1179: INV_ORGHIERARCHY_PVT.Log
1180: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
1181: ,' p_open_or_close_flag '
1182: || p_open_or_close_flag
1183: );
1184:

Line 1185: INV_ORGHIERARCHY_PVT.Log

1181: ,' p_open_or_close_flag '
1182: || p_open_or_close_flag
1183: );
1184:
1185: INV_ORGHIERARCHY_PVT.Log
1186: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
1187: ,' p_requests_count '
1188: || p_requests_count
1189: );

Line 1186: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT

1182: || p_open_or_close_flag
1183: );
1184:
1185: INV_ORGHIERARCHY_PVT.Log
1186: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
1187: ,' p_requests_count '
1188: || p_requests_count
1189: );
1190:

Line 1191: INV_ORGHIERARCHY_PVT.Log

1187: ,' p_requests_count '
1188: || p_requests_count
1189: );
1190:
1191: INV_ORGHIERARCHY_PVT.Log
1192: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
1193: ,' '
1194: );
1195:

Line 1192: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT

1188: || p_requests_count
1189: );
1190:
1191: INV_ORGHIERARCHY_PVT.Log
1192: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
1193: ,' '
1194: );
1195:
1196: INV_ORGHIERARCHY_PVT.Log

Line 1196: INV_ORGHIERARCHY_PVT.Log

1192: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
1193: ,' '
1194: );
1195:
1196: INV_ORGHIERARCHY_PVT.Log
1197: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
1198: ,' --------------- End Parameters ----------------------------------------- '
1199: );
1200:

Line 1197: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT

1193: ,' '
1194: );
1195:
1196: INV_ORGHIERARCHY_PVT.Log
1197: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
1198: ,' --------------- End Parameters ----------------------------------------- '
1199: );
1200:
1201: INV_ORGHIERARCHY_PVT.Log

Line 1201: INV_ORGHIERARCHY_PVT.Log

1197: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
1198: ,' --------------- End Parameters ----------------------------------------- '
1199: );
1200:
1201: INV_ORGHIERARCHY_PVT.Log
1202: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
1203: ,' '
1204: );
1205:

Line 1202: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT

1198: ,' --------------- End Parameters ----------------------------------------- '
1199: );
1200:
1201: INV_ORGHIERARCHY_PVT.Log
1202: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
1203: ,' '
1204: );
1205:
1206: INV_ORGHIERARCHY_PVT.Log

Line 1206: INV_ORGHIERARCHY_PVT.Log

1202: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
1203: ,' '
1204: );
1205:
1206: INV_ORGHIERARCHY_PVT.Log
1207: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
1208: ,' ............................................................ '
1209: );
1210: END IF;

Line 1207: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT

1203: ,' '
1204: );
1205:
1206: INV_ORGHIERARCHY_PVT.Log
1207: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
1208: ,' ............................................................ '
1209: );
1210: END IF;
1211:

Line 1255: INV_ORGHIERARCHY_PVT.Log

1251: AND UPPER( HOI.ORG_INFORMATION_CONTEXT || '') = 'ACCOUNTING INFORMATION'
1252: AND TO_NUMBER(HOI.ORG_INFORMATION1) = glstb.SET_OF_BOOKS_ID ;
1253:
1254: IF G_DEBUG = 'Y' THEN
1255: INV_ORGHIERARCHY_PVT.Log
1256: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
1257: ,' FOUND: Period Set name '
1258: || l_period_set_name );
1259:

Line 1256: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT

1252: AND TO_NUMBER(HOI.ORG_INFORMATION1) = glstb.SET_OF_BOOKS_ID ;
1253:
1254: IF G_DEBUG = 'Y' THEN
1255: INV_ORGHIERARCHY_PVT.Log
1256: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
1257: ,' FOUND: Period Set name '
1258: || l_period_set_name );
1259:
1260: INV_ORGHIERARCHY_PVT.Log

Line 1260: INV_ORGHIERARCHY_PVT.Log

1256: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
1257: ,' FOUND: Period Set name '
1258: || l_period_set_name );
1259:
1260: INV_ORGHIERARCHY_PVT.Log
1261: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
1262: ,' FOUND: Period Type '
1263: || l_sob_period_type );
1264:

Line 1261: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT

1257: ,' FOUND: Period Set name '
1258: || l_period_set_name );
1259:
1260: INV_ORGHIERARCHY_PVT.Log
1261: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
1262: ,' FOUND: Period Type '
1263: || l_sob_period_type );
1264:
1265: INV_ORGHIERARCHY_PVT.Log

Line 1265: INV_ORGHIERARCHY_PVT.Log

1261: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
1262: ,' FOUND: Period Type '
1263: || l_sob_period_type );
1264:
1265: INV_ORGHIERARCHY_PVT.Log
1266: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
1267: ,' Calling GET_MAX_OPEN_PERIOD ' );
1268: END IF;
1269:

Line 1266: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT

1262: ,' FOUND: Period Type '
1263: || l_sob_period_type );
1264:
1265: INV_ORGHIERARCHY_PVT.Log
1266: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
1267: ,' Calling GET_MAX_OPEN_PERIOD ' );
1268: END IF;
1269:
1270: GET_MAX_OPEN_PERIOD

Line 1280: INV_ORGHIERARCHY_PVT.Log

1276: , x_period_name => l_final_period_name
1277: );
1278:
1279: IF G_DEBUG = 'Y' THEN
1280: INV_ORGHIERARCHY_PVT.Log
1281: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
1282: ,' Out of GET_MAX_OPEN_PERIOD with period name '|| l_final_period_name );
1283: END IF;
1284:

Line 1281: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT

1277: );
1278:
1279: IF G_DEBUG = 'Y' THEN
1280: INV_ORGHIERARCHY_PVT.Log
1281: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
1282: ,' Out of GET_MAX_OPEN_PERIOD with period name '|| l_final_period_name );
1283: END IF;
1284:
1285: EXCEPTION

Line 1290: INV_ORGHIERARCHY_PVT.Log

1286: WHEN NO_DATA_FOUND
1287: THEN
1288:
1289: IF G_DEBUG = 'Y' THEN
1290: INV_ORGHIERARCHY_PVT.Log
1291: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
1292: ,' NO_DATA_FOUND: Period Set name not found for Hierarchy Origin '
1293: || p_org_hierarchy_origin
1294: );

Line 1291: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT

1287: THEN
1288:
1289: IF G_DEBUG = 'Y' THEN
1290: INV_ORGHIERARCHY_PVT.Log
1291: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
1292: ,' NO_DATA_FOUND: Period Set name not found for Hierarchy Origin '
1293: || p_org_hierarchy_origin
1294: );
1295: END IF;

Line 1312: INV_ORGHIERARCHY_PVT.Log

1308:
1309: CLOSE c_org_name;
1310:
1311: IF G_DEBUG = 'Y' THEN
1312: INV_ORGHIERARCHY_PVT.Log
1313: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
1314: ,' Hierarchy Origin name = '||
1315: l_org_name
1316: );

Line 1313: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT

1309: CLOSE c_org_name;
1310:
1311: IF G_DEBUG = 'Y' THEN
1312: INV_ORGHIERARCHY_PVT.Log
1313: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
1314: ,' Hierarchy Origin name = '||
1315: l_org_name
1316: );
1317:

Line 1318: INV_ORGHIERARCHY_PVT.Log

1314: ,' Hierarchy Origin name = '||
1315: l_org_name
1316: );
1317:
1318: INV_ORGHIERARCHY_PVT.Log
1319: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
1320: ,' Calling GET_MIN_OPEN_PERIOD ' );
1321: END IF;
1322:

Line 1319: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT

1315: l_org_name
1316: );
1317:
1318: INV_ORGHIERARCHY_PVT.Log
1319: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
1320: ,' Calling GET_MIN_OPEN_PERIOD ' );
1321: END IF;
1322:
1323: GET_MIN_OPEN_PERIOD

Line 1333: INV_ORGHIERARCHY_PVT.Log

1329: , x_period_name => l_min_period
1330: );
1331:
1332: IF G_DEBUG = 'Y' THEN
1333: INV_ORGHIERARCHY_PVT.Log
1334: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
1335: ,' Out of GET_MIN_OPEN_PERIOD with period name '|| l_min_period );
1336: END IF;
1337:

Line 1334: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT

1330: );
1331:
1332: IF G_DEBUG = 'Y' THEN
1333: INV_ORGHIERARCHY_PVT.Log
1334: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
1335: ,' Out of GET_MIN_OPEN_PERIOD with period name '|| l_min_period );
1336: END IF;
1337:
1338: -- If there are no minimum periods opened for this Org

Line 1353: INV_ORGHIERARCHY_PVT.Log

1349: l_org_from_date := l_date_from ;
1350: END IF;
1351:
1352: IF G_DEBUG = 'Y' THEN
1353: INV_ORGHIERARCHY_PVT.Log
1354: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
1355: ,' l_org_from_date '|| l_org_from_date
1356: );
1357: END IF;

Line 1354: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT

1350: END IF;
1351:
1352: IF G_DEBUG = 'Y' THEN
1353: INV_ORGHIERARCHY_PVT.Log
1354: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
1355: ,' l_org_from_date '|| l_org_from_date
1356: );
1357: END IF;
1358:

Line 1362: INV_ORGHIERARCHY_PVT.Log

1358:
1359: IF l_count > NVL(p_open_period_count,0) THEN
1360:
1361: IF G_DEBUG = 'Y' THEN
1362: INV_ORGHIERARCHY_PVT.Log
1363: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
1364: ,' No Processing for Hierarchy Origin as Input count 0 '
1365: );
1366: END IF;

Line 1363: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT

1359: IF l_count > NVL(p_open_period_count,0) THEN
1360:
1361: IF G_DEBUG = 'Y' THEN
1362: INV_ORGHIERARCHY_PVT.Log
1363: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
1364: ,' No Processing for Hierarchy Origin as Input count 0 '
1365: );
1366: END IF;
1367: ELSE

Line 1379: INV_ORGHIERARCHY_PVT.Log

1375: l_period_final_start_date := l_gl_period_future.period_start_date ;
1376: l_period_final_end_date := l_gl_period_future.period_end_date ;
1377:
1378: IF G_DEBUG = 'Y' THEN
1379: INV_ORGHIERARCHY_PVT.Log
1380: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
1381: ,'Period Final End Date: ' || to_char(l_period_final_end_date)
1382: );
1383:

Line 1380: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT

1376: l_period_final_end_date := l_gl_period_future.period_end_date ;
1377:
1378: IF G_DEBUG = 'Y' THEN
1379: INV_ORGHIERARCHY_PVT.Log
1380: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
1381: ,'Period Final End Date: ' || to_char(l_period_final_end_date)
1382: );
1383:
1384: INV_ORGHIERARCHY_PVT.Log

Line 1384: INV_ORGHIERARCHY_PVT.Log

1380: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
1381: ,'Period Final End Date: ' || to_char(l_period_final_end_date)
1382: );
1383:
1384: INV_ORGHIERARCHY_PVT.Log
1385: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
1386: ,'********* Start Processing for Hierarchy Origin ********* '
1387: );
1388:

Line 1385: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT

1381: ,'Period Final End Date: ' || to_char(l_period_final_end_date)
1382: );
1383:
1384: INV_ORGHIERARCHY_PVT.Log
1385: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
1386: ,'********* Start Processing for Hierarchy Origin ********* '
1387: );
1388:
1389: INV_ORGHIERARCHY_PVT.Log

Line 1389: INV_ORGHIERARCHY_PVT.Log

1385: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
1386: ,'********* Start Processing for Hierarchy Origin ********* '
1387: );
1388:
1389: INV_ORGHIERARCHY_PVT.Log
1390: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
1391: ,'Period Count: ' || l_count
1392: );
1393: /* Following code line has been commented. It is shifted

Line 1390: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT

1386: ,'********* Start Processing for Hierarchy Origin ********* '
1387: );
1388:
1389: INV_ORGHIERARCHY_PVT.Log
1390: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
1391: ,'Period Count: ' || l_count
1392: );
1393: /* Following code line has been commented. It is shifted
1394: out of debug condition block.Bug 3555234.

Line 1406: INV_ORGHIERARCHY_PVT.Log

1402: , p_acct_period_id => NULL
1403: );
1404: */
1405:
1406: INV_ORGHIERARCHY_PVT.Log
1407: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
1408: ,' ======== Attempt to Open Period : ' || l_gl_period_future.open_period_name
1409: || ' ============================ ' );
1410: END IF;

Line 1407: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT

1403: );
1404: */
1405:
1406: INV_ORGHIERARCHY_PVT.Log
1407: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
1408: ,' ======== Attempt to Open Period : ' || l_gl_period_future.open_period_name
1409: || ' ============================ ' );
1410: END IF;
1411:

Line 1444: INV_ORGHIERARCHY_PVT.Log

1440: , x_return_status => l_return_status
1441: ) ;
1442:
1443: IF G_DEBUG = 'Y' THEN
1444: INV_ORGHIERARCHY_PVT.Log
1445: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
1446: ,' l_last_scheduled_close_date ' || l_last_scheduled_close_date
1447: );
1448:

Line 1445: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT

1441: ) ;
1442:
1443: IF G_DEBUG = 'Y' THEN
1444: INV_ORGHIERARCHY_PVT.Log
1445: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
1446: ,' l_last_scheduled_close_date ' || l_last_scheduled_close_date
1447: );
1448:
1449: INV_ORGHIERARCHY_PVT.Log

Line 1449: INV_ORGHIERARCHY_PVT.Log

1445: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
1446: ,' l_last_scheduled_close_date ' || l_last_scheduled_close_date
1447: );
1448:
1449: INV_ORGHIERARCHY_PVT.Log
1450: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
1451: ,' l_new_acct_period_id ' || l_new_acct_period_id
1452: );
1453: END IF;

Line 1450: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT

1446: ,' l_last_scheduled_close_date ' || l_last_scheduled_close_date
1447: );
1448:
1449: INV_ORGHIERARCHY_PVT.Log
1450: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
1451: ,' l_new_acct_period_id ' || l_new_acct_period_id
1452: );
1453: END IF;
1454:

Line 1458: INV_ORGHIERARCHY_PVT.Log

1454:
1455: IF (l_duplicate_open_period) = true
1456: THEN
1457: IF G_DEBUG = 'Y' THEN
1458: INV_ORGHIERARCHY_PVT.Log
1459: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
1460: , ' duplicate_open_period Error for '
1461: || l_orgid
1462: );

Line 1459: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT

1455: IF (l_duplicate_open_period) = true
1456: THEN
1457: IF G_DEBUG = 'Y' THEN
1458: INV_ORGHIERARCHY_PVT.Log
1459: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
1460: , ' duplicate_open_period Error for '
1461: || l_orgid
1462: );
1463: END IF;

Line 1480: INV_ORGHIERARCHY_PVT.Log

1476:
1477: IF l_prior_period_open = true
1478: THEN
1479: IF G_DEBUG = 'Y' THEN
1480: INV_ORGHIERARCHY_PVT.Log
1481: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
1482: , ' '
1483: );
1484: END IF;

Line 1481: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT

1477: IF l_prior_period_open = true
1478: THEN
1479: IF G_DEBUG = 'Y' THEN
1480: INV_ORGHIERARCHY_PVT.Log
1481: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
1482: , ' '
1483: );
1484: END IF;
1485: ELSE

Line 1487: INV_ORGHIERARCHY_PVT.Log

1483: );
1484: END IF;
1485: ELSE
1486: IF G_DEBUG = 'Y' THEN
1487: INV_ORGHIERARCHY_PVT.Log
1488: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
1489: , ' EXCEPTION: l_prior_period_open FALSE '
1490: );
1491: END IF;

Line 1488: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT

1484: END IF;
1485: ELSE
1486: IF G_DEBUG = 'Y' THEN
1487: INV_ORGHIERARCHY_PVT.Log
1488: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
1489: , ' EXCEPTION: l_prior_period_open FALSE '
1490: );
1491: END IF;
1492: ADD_ITEM

Line 1506: INV_ORGHIERARCHY_PVT.Log

1502:
1503: IF (l_commit_complete) = true
1504: THEN
1505: IF G_DEBUG = 'Y' THEN
1506: INV_ORGHIERARCHY_PVT.Log
1507: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
1508: ,' Open SUCCESS for '
1509: || l_orgid || ' - '|| l_org_name
1510: );

Line 1507: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT

1503: IF (l_commit_complete) = true
1504: THEN
1505: IF G_DEBUG = 'Y' THEN
1506: INV_ORGHIERARCHY_PVT.Log
1507: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
1508: ,' Open SUCCESS for '
1509: || l_orgid || ' - '|| l_org_name
1510: );
1511: END IF;

Line 1525: INV_ORGHIERARCHY_PVT.Log

1521:
1522: COMMIT;
1523: ELSE
1524: IF G_DEBUG = 'Y' THEN
1525: INV_ORGHIERARCHY_PVT.Log
1526: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
1527: ,' Open FAILED for '
1528: || l_orgid || ' - '|| l_org_name
1529: );

Line 1526: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT

1522: COMMIT;
1523: ELSE
1524: IF G_DEBUG = 'Y' THEN
1525: INV_ORGHIERARCHY_PVT.Log
1526: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
1527: ,' Open FAILED for '
1528: || l_orgid || ' - '|| l_org_name
1529: );
1530: END IF;

Line 1545: INV_ORGHIERARCHY_PVT.Log

1541: ROLLBACK ;
1542: END IF;
1543:
1544: IF G_DEBUG = 'Y' THEN
1545: INV_ORGHIERARCHY_PVT.Log
1546: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
1547: ,' Hierarchy Origin End of Period Name ' || l_gl_period_future.open_period_name
1548: || ' ============================ ' );
1549: END IF;

Line 1546: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT

1542: END IF;
1543:
1544: IF G_DEBUG = 'Y' THEN
1545: INV_ORGHIERARCHY_PVT.Log
1546: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
1547: ,' Hierarchy Origin End of Period Name ' || l_gl_period_future.open_period_name
1548: || ' ============================ ' );
1549: END IF;
1550:

Line 1602: INV_ORGHIERARCHY_PVT.Log

1598: -- The Organization list belonging to this Hierarchy Origin
1599: -- is retreived. organization list includes the hierarchy origin
1600:
1601: IF G_DEBUG = 'Y' THEN
1602: INV_ORGHIERARCHY_PVT.Log
1603: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
1604: ,' Calling INV_ORGHIERARCHY_PVT.get_organization_List '
1605: );
1606: END IF;

Line 1603: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT

1599: -- is retreived. organization list includes the hierarchy origin
1600:
1601: IF G_DEBUG = 'Y' THEN
1602: INV_ORGHIERARCHY_PVT.Log
1603: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
1604: ,' Calling INV_ORGHIERARCHY_PVT.get_organization_List '
1605: );
1606: END IF;
1607:

Line 1604: ,' Calling INV_ORGHIERARCHY_PVT.get_organization_List '

1600:
1601: IF G_DEBUG = 'Y' THEN
1602: INV_ORGHIERARCHY_PVT.Log
1603: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
1604: ,' Calling INV_ORGHIERARCHY_PVT.get_organization_List '
1605: );
1606: END IF;
1607:
1608:

Line 1612: INV_ORGHIERARCHY_PVT.Log

1608:
1609: IF NVL(l_org_code_list.COUNT,0) > 0
1610: THEN
1611: IF G_DEBUG = 'Y' THEN
1612: INV_ORGHIERARCHY_PVT.Log
1613: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
1614: ,' count > 0 '
1615: );
1616: END IF;

Line 1613: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT

1609: IF NVL(l_org_code_list.COUNT,0) > 0
1610: THEN
1611: IF G_DEBUG = 'Y' THEN
1612: INV_ORGHIERARCHY_PVT.Log
1613: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
1614: ,' count > 0 '
1615: );
1616: END IF;
1617:

Line 1624: INV_ORGHIERARCHY_PVT.Log

1620: l_index := l_org_code_list.FIRST;
1621: l_orgid := l_org_code_list(l_index);
1622:
1623: IF G_DEBUG = 'Y' THEN
1624: INV_ORGHIERARCHY_PVT.Log
1625: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
1626: ,' Initial l_index ' || l_index
1627: );
1628:

Line 1625: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT

1621: l_orgid := l_org_code_list(l_index);
1622:
1623: IF G_DEBUG = 'Y' THEN
1624: INV_ORGHIERARCHY_PVT.Log
1625: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
1626: ,' Initial l_index ' || l_index
1627: );
1628:
1629: INV_ORGHIERARCHY_PVT.Log

Line 1629: INV_ORGHIERARCHY_PVT.Log

1625: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
1626: ,' Initial l_index ' || l_index
1627: );
1628:
1629: INV_ORGHIERARCHY_PVT.Log
1630: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
1631: ,' Initial l_orgid ' || l_orgid
1632: );
1633:

Line 1630: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT

1626: ,' Initial l_index ' || l_index
1627: );
1628:
1629: INV_ORGHIERARCHY_PVT.Log
1630: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
1631: ,' Initial l_orgid ' || l_orgid
1632: );
1633:
1634: INV_ORGHIERARCHY_PVT.Log

Line 1634: INV_ORGHIERARCHY_PVT.Log

1630: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
1631: ,' Initial l_orgid ' || l_orgid
1632: );
1633:
1634: INV_ORGHIERARCHY_PVT.Log
1635: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
1636: ,' About to Enter WHILE Loop for the Org List '
1637: );
1638:

Line 1635: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT

1631: ,' Initial l_orgid ' || l_orgid
1632: );
1633:
1634: INV_ORGHIERARCHY_PVT.Log
1635: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
1636: ,' About to Enter WHILE Loop for the Org List '
1637: );
1638:
1639: INV_ORGHIERARCHY_PVT.Log

Line 1639: INV_ORGHIERARCHY_PVT.Log

1635: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
1636: ,' About to Enter WHILE Loop for the Org List '
1637: );
1638:
1639: INV_ORGHIERARCHY_PVT.Log
1640: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
1641: ,' '
1642: );
1643:

Line 1640: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT

1636: ,' About to Enter WHILE Loop for the Org List '
1637: );
1638:
1639: INV_ORGHIERARCHY_PVT.Log
1640: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
1641: ,' '
1642: );
1643:
1644: INV_ORGHIERARCHY_PVT.Log

Line 1644: INV_ORGHIERARCHY_PVT.Log

1640: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
1641: ,' '
1642: );
1643:
1644: INV_ORGHIERARCHY_PVT.Log
1645: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
1646: ,' ............................................................ '
1647: );
1648: END IF;

Line 1645: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT

1641: ,' '
1642: );
1643:
1644: INV_ORGHIERARCHY_PVT.Log
1645: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
1646: ,' ............................................................ '
1647: );
1648: END IF;
1649:

Line 1653: INV_ORGHIERARCHY_PVT.Log

1649:
1650: WHILE ( l_list_count > 0 )
1651: LOOP
1652: IF G_DEBUG = 'Y' THEN
1653: INV_ORGHIERARCHY_PVT.Log
1654: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
1655: ,' Into while loop with l_index ' || l_index
1656: );
1657: END IF;

Line 1654: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT

1650: WHILE ( l_list_count > 0 )
1651: LOOP
1652: IF G_DEBUG = 'Y' THEN
1653: INV_ORGHIERARCHY_PVT.Log
1654: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
1655: ,' Into while loop with l_index ' || l_index
1656: );
1657: END IF;
1658:

Line 1662: INV_ORGHIERARCHY_PVT.Log

1658:
1659: l_orgid := l_org_code_list(l_index);
1660:
1661: IF G_DEBUG = 'Y' THEN
1662: INV_ORGHIERARCHY_PVT.Log
1663: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
1664: ,' Organization Id: ' || l_orgid
1665: );
1666: END IF;

Line 1663: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT

1659: l_orgid := l_org_code_list(l_index);
1660:
1661: IF G_DEBUG = 'Y' THEN
1662: INV_ORGHIERARCHY_PVT.Log
1663: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
1664: ,' Organization Id: ' || l_orgid
1665: );
1666: END IF;
1667:

Line 1683: INV_ORGHIERARCHY_PVT.Log

1679: IF p_open_or_close_flag = 'O' AND l_orgid <> p_org_hierarchy_origin
1680: THEN
1681:
1682: IF G_DEBUG = 'Y' THEN
1683: INV_ORGHIERARCHY_PVT.Log
1684: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
1685: ,' while loop l_orgid ' || l_orgid
1686: );
1687: END IF;

Line 1684: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT

1680: THEN
1681:
1682: IF G_DEBUG = 'Y' THEN
1683: INV_ORGHIERARCHY_PVT.Log
1684: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
1685: ,' while loop l_orgid ' || l_orgid
1686: );
1687: END IF;
1688:

Line 1691: INV_ORGHIERARCHY_PVT.Log

1687: END IF;
1688:
1689:
1690: IF G_DEBUG = 'Y' THEN
1691: INV_ORGHIERARCHY_PVT.Log
1692: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
1693: ,' ************** START Processing Organization = '||
1694: l_org_name || ' ************************** '
1695: );

Line 1692: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT

1688:
1689:
1690: IF G_DEBUG = 'Y' THEN
1691: INV_ORGHIERARCHY_PVT.Log
1692: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
1693: ,' ************** START Processing Organization = '||
1694: l_org_name || ' ************************** '
1695: );
1696: END IF;

Line 1710: INV_ORGHIERARCHY_PVT.Log

1706: );
1707:
1708:
1709: IF G_DEBUG = 'Y' THEN
1710: INV_ORGHIERARCHY_PVT.Log
1711: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
1712: ,'## Organization Date From '|| l_date_from
1713: );
1714: END IF;

Line 1711: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT

1707:
1708:
1709: IF G_DEBUG = 'Y' THEN
1710: INV_ORGHIERARCHY_PVT.Log
1711: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
1712: ,'## Organization Date From '|| l_date_from
1713: );
1714: END IF;
1715:

Line 1722: INV_ORGHIERARCHY_PVT.Log

1718:
1719: l_cursor_final_end_date := l_period_final_end_date ;
1720:
1721: IF G_DEBUG = 'Y' THEN
1722: INV_ORGHIERARCHY_PVT.Log
1723: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
1724: ,' l_cursor_final_end_date '|| l_cursor_final_end_date
1725: );
1726:

Line 1723: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT

1719: l_cursor_final_end_date := l_period_final_end_date ;
1720:
1721: IF G_DEBUG = 'Y' THEN
1722: INV_ORGHIERARCHY_PVT.Log
1723: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
1724: ,' l_cursor_final_end_date '|| l_cursor_final_end_date
1725: );
1726:
1727: -- The Minimum and Maximum periods for this Org

Line 1731: INV_ORGHIERARCHY_PVT.Log

1727: -- The Minimum and Maximum periods for this Org
1728: -- is selected. This required to determine the
1729: -- range of periods that are eligible to be Opened
1730:
1731: INV_ORGHIERARCHY_PVT.Log
1732: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
1733: ,' Calling GET_MIN_OPEN_PERIOD ' );
1734: END IF;
1735:

Line 1732: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT

1728: -- is selected. This required to determine the
1729: -- range of periods that are eligible to be Opened
1730:
1731: INV_ORGHIERARCHY_PVT.Log
1732: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
1733: ,' Calling GET_MIN_OPEN_PERIOD ' );
1734: END IF;
1735:
1736: GET_MIN_OPEN_PERIOD

Line 1746: INV_ORGHIERARCHY_PVT.Log

1742: , x_period_name => l_min_period
1743: );
1744:
1745: IF G_DEBUG = 'Y' THEN
1746: INV_ORGHIERARCHY_PVT.Log
1747: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
1748: ,' Out of GET_MIN_OPEN_PERIOD with period name '|| l_min_period );
1749: END IF;
1750:

Line 1747: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT

1743: );
1744:
1745: IF G_DEBUG = 'Y' THEN
1746: INV_ORGHIERARCHY_PVT.Log
1747: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
1748: ,' Out of GET_MIN_OPEN_PERIOD with period name '|| l_min_period );
1749: END IF;
1750:
1751: -- If there are no minimum periods opened for this Org

Line 1767: INV_ORGHIERARCHY_PVT.Log

1763: l_org_from_date := l_date_from;
1764: END IF;
1765:
1766: IF G_DEBUG = 'Y' THEN
1767: INV_ORGHIERARCHY_PVT.Log
1768: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
1769: ,' l_org_from_date '|| l_org_from_date
1770: );
1771: END IF;

Line 1768: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT

1764: END IF;
1765:
1766: IF G_DEBUG = 'Y' THEN
1767: INV_ORGHIERARCHY_PVT.Log
1768: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
1769: ,' l_org_from_date '|| l_org_from_date
1770: );
1771: END IF;
1772:

Line 1780: INV_ORGHIERARCHY_PVT.Log

1776: -- for each of the period
1777:
1778:
1779: IF G_DEBUG = 'Y' THEN
1780: INV_ORGHIERARCHY_PVT.Log
1781: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
1782: ,' ======== Attempt to Open Period : ' || l_gl_period_future.open_period_name
1783: || ' ============================ ' );
1784: END IF;

Line 1781: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT

1777:
1778:
1779: IF G_DEBUG = 'Y' THEN
1780: INV_ORGHIERARCHY_PVT.Log
1781: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
1782: ,' ======== Attempt to Open Period : ' || l_gl_period_future.open_period_name
1783: || ' ============================ ' );
1784: END IF;
1785:

Line 1806: INV_ORGHIERARCHY_PVT.Log

1802: , x_return_status => l_return_status
1803: ) ;
1804:
1805: IF G_DEBUG = 'Y' THEN
1806: INV_ORGHIERARCHY_PVT.Log
1807: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
1808: ,' l_last_scheduled_close_date ' || l_last_scheduled_close_date
1809: );
1810:

Line 1807: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT

1803: ) ;
1804:
1805: IF G_DEBUG = 'Y' THEN
1806: INV_ORGHIERARCHY_PVT.Log
1807: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
1808: ,' l_last_scheduled_close_date ' || l_last_scheduled_close_date
1809: );
1810:
1811: INV_ORGHIERARCHY_PVT.Log

Line 1811: INV_ORGHIERARCHY_PVT.Log

1807: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
1808: ,' l_last_scheduled_close_date ' || l_last_scheduled_close_date
1809: );
1810:
1811: INV_ORGHIERARCHY_PVT.Log
1812: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
1813: ,' l_new_acct_period_id ' || l_new_acct_period_id
1814: );
1815: END IF;

Line 1812: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT

1808: ,' l_last_scheduled_close_date ' || l_last_scheduled_close_date
1809: );
1810:
1811: INV_ORGHIERARCHY_PVT.Log
1812: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
1813: ,' l_new_acct_period_id ' || l_new_acct_period_id
1814: );
1815: END IF;
1816:

Line 1820: INV_ORGHIERARCHY_PVT.Log

1816:
1817: IF (l_duplicate_open_period) = true
1818: THEN
1819: IF G_DEBUG = 'Y' THEN
1820: INV_ORGHIERARCHY_PVT.Log
1821: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
1822: , ' duplicate_open_period Error for '
1823: || l_orgid
1824: );

Line 1821: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT

1817: IF (l_duplicate_open_period) = true
1818: THEN
1819: IF G_DEBUG = 'Y' THEN
1820: INV_ORGHIERARCHY_PVT.Log
1821: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
1822: , ' duplicate_open_period Error for '
1823: || l_orgid
1824: );
1825: END IF;

Line 1842: INV_ORGHIERARCHY_PVT.Log

1838:
1839: IF (l_prior_period_open) = true
1840: THEN
1841: IF G_DEBUG = 'Y' THEN
1842: INV_ORGHIERARCHY_PVT.Log
1843: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
1844: , ' '
1845: );
1846: END IF;

Line 1843: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT

1839: IF (l_prior_period_open) = true
1840: THEN
1841: IF G_DEBUG = 'Y' THEN
1842: INV_ORGHIERARCHY_PVT.Log
1843: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
1844: , ' '
1845: );
1846: END IF;
1847: ELSE

Line 1849: INV_ORGHIERARCHY_PVT.Log

1845: );
1846: END IF;
1847: ELSE
1848: IF G_DEBUG = 'Y' THEN
1849: INV_ORGHIERARCHY_PVT.Log
1850: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
1851: , ' EXCEPTION: l_prior_period_open FALSE '
1852: );
1853: END IF;

Line 1850: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT

1846: END IF;
1847: ELSE
1848: IF G_DEBUG = 'Y' THEN
1849: INV_ORGHIERARCHY_PVT.Log
1850: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
1851: , ' EXCEPTION: l_prior_period_open FALSE '
1852: );
1853: END IF;
1854:

Line 1870: INV_ORGHIERARCHY_PVT.Log

1866:
1867: IF (l_commit_complete) = true
1868: THEN
1869: IF G_DEBUG = 'Y' THEN
1870: INV_ORGHIERARCHY_PVT.Log
1871: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
1872: ,' Open SUCCESS for '
1873: || l_orgid || ' - '|| l_org_name
1874: );

Line 1871: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT

1867: IF (l_commit_complete) = true
1868: THEN
1869: IF G_DEBUG = 'Y' THEN
1870: INV_ORGHIERARCHY_PVT.Log
1871: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
1872: ,' Open SUCCESS for '
1873: || l_orgid || ' - '|| l_org_name
1874: );
1875: END IF;

Line 1890: INV_ORGHIERARCHY_PVT.Log

1886:
1887: COMMIT;
1888: ELSE
1889: IF G_DEBUG = 'Y' THEN
1890: INV_ORGHIERARCHY_PVT.Log
1891: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
1892: ,' Open FAILED for '
1893: || l_orgid || ' - '|| l_org_name
1894: );

Line 1891: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT

1887: COMMIT;
1888: ELSE
1889: IF G_DEBUG = 'Y' THEN
1890: INV_ORGHIERARCHY_PVT.Log
1891: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
1892: ,' Open FAILED for '
1893: || l_orgid || ' - '|| l_org_name
1894: );
1895: END IF;

Line 1910: INV_ORGHIERARCHY_PVT.Log

1906: ROLLBACK ;
1907: END IF;
1908:
1909: IF G_DEBUG = 'Y' THEN
1910: INV_ORGHIERARCHY_PVT.Log
1911: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
1912: ,' ======== End of Period Name ' || l_gl_period_future.open_period_name
1913: || ' ============================ ' );
1914: END IF;

Line 1911: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT

1907: END IF;
1908:
1909: IF G_DEBUG = 'Y' THEN
1910: INV_ORGHIERARCHY_PVT.Log
1911: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
1912: ,' ======== End of Period Name ' || l_gl_period_future.open_period_name
1913: || ' ============================ ' );
1914: END IF;
1915:

Line 1942: INV_ORGHIERARCHY_PVT.Log

1938:
1939:
1940:
1941: IF G_DEBUG = 'Y' THEN
1942: INV_ORGHIERARCHY_PVT.Log
1943: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
1944: ,' Calling CST_AccountingPeriod_PUB.verify_periodclose for Org ID '
1945: || l_orgid
1946: );

Line 1943: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT

1939:
1940:
1941: IF G_DEBUG = 'Y' THEN
1942: INV_ORGHIERARCHY_PVT.Log
1943: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
1944: ,' Calling CST_AccountingPeriod_PUB.verify_periodclose for Org ID '
1945: || l_orgid
1946: );
1947:

Line 1948: INV_ORGHIERARCHY_PVT.Log

1944: ,' Calling CST_AccountingPeriod_PUB.verify_periodclose for Org ID '
1945: || l_orgid
1946: );
1947:
1948: INV_ORGHIERARCHY_PVT.Log
1949: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
1950: ,' Org ID ' || l_orgid || ' for period ' ||
1951: l_org_acct_periods_val_open.open_period_name ||
1952: ' Schedule Close Date:' || l_org_acct_periods_val_open.schedule_close_date

Line 1949: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT

1945: || l_orgid
1946: );
1947:
1948: INV_ORGHIERARCHY_PVT.Log
1949: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
1950: ,' Org ID ' || l_orgid || ' for period ' ||
1951: l_org_acct_periods_val_open.open_period_name ||
1952: ' Schedule Close Date:' || l_org_acct_periods_val_open.schedule_close_date
1953: );

Line 1987: INV_ORGHIERARCHY_PVT.Log

1983: FND_MESSAGE.SET_NAME('INV', 'INV_NO_NEXT_PERIOD');
1984: l_error_msg := SUBSTR(FND_MESSAGE.Get, 1,255);
1985:
1986: IF G_DEBUG = 'Y' THEN
1987: INV_ORGHIERARCHY_PVT.Log
1988: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
1989: ,l_error_msg
1990: );
1991: END IF;

Line 1988: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT

1984: l_error_msg := SUBSTR(FND_MESSAGE.Get, 1,255);
1985:
1986: IF G_DEBUG = 'Y' THEN
1987: INV_ORGHIERARCHY_PVT.Log
1988: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
1989: ,l_error_msg
1990: );
1991: END IF;
1992:

Line 2001: INV_ORGHIERARCHY_PVT.Log

1997: FND_MESSAGE.SET_NAME('INV', 'INV_CLOSE_IN_ORDER');
1998: l_error_msg := SUBSTR(FND_MESSAGE.Get, 1,255);
1999:
2000: IF G_DEBUG = 'Y' THEN
2001: INV_ORGHIERARCHY_PVT.Log
2002: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
2003: ,l_error_msg
2004: );
2005: END IF;

Line 2002: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT

1998: l_error_msg := SUBSTR(FND_MESSAGE.Get, 1,255);
1999:
2000: IF G_DEBUG = 'Y' THEN
2001: INV_ORGHIERARCHY_PVT.Log
2002: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
2003: ,l_error_msg
2004: );
2005: END IF;
2006:

Line 2032: INV_ORGHIERARCHY_PVT.Log

2028: IF (l_org_acct_periods_val_open.period_start_date > l_le_sysdate) THEN
2029: FND_MESSAGE.SET_NAME('BOM','CST_CLOSE_FUTURE_PERIOD');
2030: l_error_msg := SUBSTR(FND_MESSAGE.Get, 1,255);
2031: IF G_DEBUG = 'Y' THEN
2032: INV_ORGHIERARCHY_PVT.Log
2033: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
2034: ,l_error_msg
2035: );
2036: END IF;

Line 2033: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT

2029: FND_MESSAGE.SET_NAME('BOM','CST_CLOSE_FUTURE_PERIOD');
2030: l_error_msg := SUBSTR(FND_MESSAGE.Get, 1,255);
2031: IF G_DEBUG = 'Y' THEN
2032: INV_ORGHIERARCHY_PVT.Log
2033: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
2034: ,l_error_msg
2035: );
2036: END IF;
2037: l_verify_flag := 'N';

Line 2048: INV_ORGHIERARCHY_PVT.Log

2044: -- Get remaining hours from sysdate
2045: l_hours_remaining := round((l_period_end_date - sysdate) * 24);
2046:
2047: IF G_DEBUG = 'Y' THEN
2048: INV_ORGHIERARCHY_PVT.Log
2049: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
2050: ,'Remaining hours to close period : ' || l_hours_remaining
2051: );
2052: END IF;

Line 2049: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT

2045: l_hours_remaining := round((l_period_end_date - sysdate) * 24);
2046:
2047: IF G_DEBUG = 'Y' THEN
2048: INV_ORGHIERARCHY_PVT.Log
2049: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
2050: ,'Remaining hours to close period : ' || l_hours_remaining
2051: );
2052: END IF;
2053: ADD_ITEM

Line 2069: INV_ORGHIERARCHY_PVT.Log

2065: ELSE
2066: FND_MESSAGE.SET_NAME('BOM','CST_EARLY_CLOSE_NOT_ALLOWED');
2067: l_error_msg := SUBSTR(FND_MESSAGE.Get, 1,255);
2068: IF G_DEBUG = 'Y' THEN
2069: INV_ORGHIERARCHY_PVT.Log
2070: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
2071: ,l_error_msg
2072: );
2073: END IF;

Line 2070: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT

2066: FND_MESSAGE.SET_NAME('BOM','CST_EARLY_CLOSE_NOT_ALLOWED');
2067: l_error_msg := SUBSTR(FND_MESSAGE.Get, 1,255);
2068: IF G_DEBUG = 'Y' THEN
2069: INV_ORGHIERARCHY_PVT.Log
2070: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
2071: ,l_error_msg
2072: );
2073: END IF;
2074: l_verify_flag := 'N';

Line 2083: INV_ORGHIERARCHY_PVT.Log

2079: FND_MESSAGE.SET_NAME('INV', 'INV_GL_DOWNLOAD_IN_PROGRESS');
2080: l_error_msg := SUBSTR(FND_MESSAGE.Get, 1,255);
2081:
2082: IF G_DEBUG = 'Y' THEN
2083: INV_ORGHIERARCHY_PVT.Log
2084: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
2085: ,l_error_msg
2086: );
2087: END IF;

Line 2084: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT

2080: l_error_msg := SUBSTR(FND_MESSAGE.Get, 1,255);
2081:
2082: IF G_DEBUG = 'Y' THEN
2083: INV_ORGHIERARCHY_PVT.Log
2084: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
2085: ,l_error_msg
2086: );
2087: END IF;
2088:

Line 2097: INV_ORGHIERARCHY_PVT.Log

2093: FND_MESSAGE.SET_NAME('INV', 'INV_RECLOSE_PERIOD');
2094: l_error_msg := SUBSTR(FND_MESSAGE.Get, 1,255);
2095:
2096: IF G_DEBUG = 'Y' THEN
2097: INV_ORGHIERARCHY_PVT.Log
2098: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
2099: ,l_error_msg
2100: );
2101: END IF;

Line 2098: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT

2094: l_error_msg := SUBSTR(FND_MESSAGE.Get, 1,255);
2095:
2096: IF G_DEBUG = 'Y' THEN
2097: INV_ORGHIERARCHY_PVT.Log
2098: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
2099: ,l_error_msg
2100: );
2101: END IF;
2102:

Line 2169: INV_ORGHIERARCHY_PVT.Log

2165: LOOP
2166: IF GET_OPEN_REQUESTS_COUNT < l_requests_count
2167: THEN
2168: IF G_DEBUG = 'Y' THEN
2169: INV_ORGHIERARCHY_PVT.Log
2170: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
2171: ,' Exiting Request Loop '
2172: );
2173: END IF;

Line 2170: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT

2166: IF GET_OPEN_REQUESTS_COUNT < l_requests_count
2167: THEN
2168: IF G_DEBUG = 'Y' THEN
2169: INV_ORGHIERARCHY_PVT.Log
2170: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
2171: ,' Exiting Request Loop '
2172: );
2173: END IF;
2174: EXIT;

Line 2185: INV_ORGHIERARCHY_PVT.Log

2181:
2182: END LOOP;
2183:
2184: IF G_DEBUG = 'Y' THEN
2185: INV_ORGHIERARCHY_PVT.Log
2186: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
2187: ,' Calling CLOSE_PERIOD for Org ID '
2188: || l_orgid || ' for period ' ||
2189: l_org_acct_periods_val_open.open_period_name

Line 2186: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT

2182: END LOOP;
2183:
2184: IF G_DEBUG = 'Y' THEN
2185: INV_ORGHIERARCHY_PVT.Log
2186: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
2187: ,' Calling CLOSE_PERIOD for Org ID '
2188: || l_orgid || ' for period ' ||
2189: l_org_acct_periods_val_open.open_period_name
2190: );

Line 2220: INV_ORGHIERARCHY_PVT.Log

2216: , x_return_status => l_return_status
2217: );
2218:
2219: IF G_DEBUG = 'Y' THEN
2220: INV_ORGHIERARCHY_PVT.Log
2221: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
2222: ,' Out of CST_AccountingPeriod_PUB.close_period for Org ID ' || l_orgid
2223: );
2224: END IF;

Line 2221: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT

2217: );
2218:
2219: IF G_DEBUG = 'Y' THEN
2220: INV_ORGHIERARCHY_PVT.Log
2221: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
2222: ,' Out of CST_AccountingPeriod_PUB.close_period for Org ID ' || l_orgid
2223: );
2224: END IF;
2225:

Line 2229: INV_ORGHIERARCHY_PVT.Log

2225:
2226: IF (l_wip_failed) = true
2227: THEN
2228: IF G_DEBUG = 'Y' THEN
2229: INV_ORGHIERARCHY_PVT.Log
2230: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
2231: ,' WIP Failed for '
2232: || l_orgid || ' Request ID ' || l_req_id
2233: ) ;

Line 2230: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT

2226: IF (l_wip_failed) = true
2227: THEN
2228: IF G_DEBUG = 'Y' THEN
2229: INV_ORGHIERARCHY_PVT.Log
2230: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
2231: ,' WIP Failed for '
2232: || l_orgid || ' Request ID ' || l_req_id
2233: ) ;
2234: END IF;

Line 2250: INV_ORGHIERARCHY_PVT.Log

2246:
2247: IF (l_download_failed) = true
2248: THEN
2249: IF G_DEBUG = 'Y' THEN
2250: INV_ORGHIERARCHY_PVT.Log
2251: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
2252: ,' download_failed for '
2253: || l_orgid || ' Request ID ' || l_req_id
2254: );

Line 2251: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT

2247: IF (l_download_failed) = true
2248: THEN
2249: IF G_DEBUG = 'Y' THEN
2250: INV_ORGHIERARCHY_PVT.Log
2251: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
2252: ,' download_failed for '
2253: || l_orgid || ' Request ID ' || l_req_id
2254: );
2255: END IF;

Line 2275: INV_ORGHIERARCHY_PVT.Log

2271:
2272: FND_MESSAGE.SET_NAME('BOM','CST_UNPROCESSED_TXNS');
2273: l_error_msg := SUBSTR(FND_MESSAGE.Get, 1,255);
2274: IF G_DEBUG = 'Y' THEN
2275: INV_ORGHIERARCHY_PVT.Log
2276: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
2277: ,l_error_msg
2278: );
2279: END IF;

Line 2276: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT

2272: FND_MESSAGE.SET_NAME('BOM','CST_UNPROCESSED_TXNS');
2273: l_error_msg := SUBSTR(FND_MESSAGE.Get, 1,255);
2274: IF G_DEBUG = 'Y' THEN
2275: INV_ORGHIERARCHY_PVT.Log
2276: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
2277: ,l_error_msg
2278: );
2279: END IF;
2280:

Line 2284: INV_ORGHIERARCHY_PVT.Log

2280:
2281: FND_MESSAGE.SET_NAME('INV','INV_PERIOD_CLOSE_ABORTED');
2282: l_error_msg := SUBSTR(FND_MESSAGE.Get, 1,255);
2283: IF G_DEBUG = 'Y' THEN
2284: INV_ORGHIERARCHY_PVT.Log
2285: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
2286: ,l_error_msg
2287: );
2288: END IF;

Line 2285: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT

2281: FND_MESSAGE.SET_NAME('INV','INV_PERIOD_CLOSE_ABORTED');
2282: l_error_msg := SUBSTR(FND_MESSAGE.Get, 1,255);
2283: IF G_DEBUG = 'Y' THEN
2284: INV_ORGHIERARCHY_PVT.Log
2285: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
2286: ,l_error_msg
2287: );
2288: END IF;
2289:

Line 2296: INV_ORGHIERARCHY_PVT.Log

2292:
2293: IF ( l_close_failed ) = true
2294: THEN
2295: IF G_DEBUG = 'Y' THEN
2296: INV_ORGHIERARCHY_PVT.Log
2297: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
2298: ,' close Falied - for Org ID '
2299: || l_orgid || ' Request ID ' || l_req_id
2300: );

Line 2297: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT

2293: IF ( l_close_failed ) = true
2294: THEN
2295: IF G_DEBUG = 'Y' THEN
2296: INV_ORGHIERARCHY_PVT.Log
2297: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
2298: ,' close Falied - for Org ID '
2299: || l_orgid || ' Request ID ' || l_req_id
2300: );
2301: END IF;

Line 2316: INV_ORGHIERARCHY_PVT.Log

2312:
2313: ROLLBACK ;
2314: ELSE --IF ( l_close_failed ) = true
2315: IF G_DEBUG = 'Y' THEN
2316: INV_ORGHIERARCHY_PVT.Log
2317: ( INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
2318: , ' Close in process REquest '|| l_req_id
2319: );
2320: END IF;

Line 2317: ( INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT

2313: ROLLBACK ;
2314: ELSE --IF ( l_close_failed ) = true
2315: IF G_DEBUG = 'Y' THEN
2316: INV_ORGHIERARCHY_PVT.Log
2317: ( INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
2318: , ' Close in process REquest '|| l_req_id
2319: );
2320: END IF;
2321: IF p_close_if_res_recmd = 'Y' AND

Line 2326: INV_ORGHIERARCHY_PVT.Log

2322: (l_pend_receiving > 0 OR l_pend_matl > 0 OR l_pend_move > 0
2323: OR l_released_work_orders > 0 OR l_pending_ship > 0) THEN
2324: l_closed_if_res_recmd := 1;
2325: IF G_DEBUG = 'Y' THEN
2326: INV_ORGHIERARCHY_PVT.Log
2327: ( INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
2328: , ' WARNING : There are pending transactions with resolutions recommended for '||l_org_acct_periods_val_open.open_period_name||
2329: ' in '||l_orgid
2330: );

Line 2327: ( INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT

2323: OR l_released_work_orders > 0 OR l_pending_ship > 0) THEN
2324: l_closed_if_res_recmd := 1;
2325: IF G_DEBUG = 'Y' THEN
2326: INV_ORGHIERARCHY_PVT.Log
2327: ( INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
2328: , ' WARNING : There are pending transactions with resolutions recommended for '||l_org_acct_periods_val_open.open_period_name||
2329: ' in '||l_orgid
2330: );
2331: END IF;

Line 2356: INV_ORGHIERARCHY_PVT.Log

2352: END IF; --IF ( l_close_failed ) = true
2353:
2354: ELSE --IF l_unproc_matl = 0
2355: IF G_DEBUG = 'Y' THEN
2356: INV_ORGHIERARCHY_PVT.Log
2357: ( INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
2358: , 'Pending Transactions exists'
2359: );
2360: END IF;

Line 2357: ( INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT

2353:
2354: ELSE --IF l_unproc_matl = 0
2355: IF G_DEBUG = 'Y' THEN
2356: INV_ORGHIERARCHY_PVT.Log
2357: ( INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
2358: , 'Pending Transactions exists'
2359: );
2360: END IF;
2361: ADD_ITEM

Line 2375: INV_ORGHIERARCHY_PVT.Log

2371:
2372: -- verify_periodclose failed
2373: ELSE
2374: IF G_DEBUG = 'Y' THEN
2375: INV_ORGHIERARCHY_PVT.Log
2376: ( INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
2377: , ' Period not eligible to be closed '
2378: );
2379: END IF;

Line 2376: ( INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT

2372: -- verify_periodclose failed
2373: ELSE
2374: IF G_DEBUG = 'Y' THEN
2375: INV_ORGHIERARCHY_PVT.Log
2376: ( INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
2377: , ' Period not eligible to be closed '
2378: );
2379: END IF;
2380:

Line 2385: INV_ORGHIERARCHY_PVT.Log

2381: END IF; -- verify_periodclose
2382:
2383: ELSE
2384: IF G_DEBUG = 'Y' THEN
2385: INV_ORGHIERARCHY_PVT.Log
2386: ( INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
2387: , ' Period not Open '
2388: );
2389: END IF;

Line 2386: ( INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT

2382:
2383: ELSE
2384: IF G_DEBUG = 'Y' THEN
2385: INV_ORGHIERARCHY_PVT.Log
2386: ( INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
2387: , ' Period not Open '
2388: );
2389: END IF;
2390: /* Commented following code for showing details of only eligible

Line 2405: INV_ORGHIERARCHY_PVT.Log

2401:
2402: END IF; -- open flag check
2403: END LOOP;
2404: IF G_DEBUG = 'Y' THEN
2405: INV_ORGHIERARCHY_PVT.Log
2406: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
2407: ,' Out of Close FOR loop ' );
2408: END IF;
2409: END IF; -- Open or close flag check

Line 2406: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT

2402: END IF; -- open flag check
2403: END LOOP;
2404: IF G_DEBUG = 'Y' THEN
2405: INV_ORGHIERARCHY_PVT.Log
2406: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
2407: ,' Out of Close FOR loop ' );
2408: END IF;
2409: END IF; -- Open or close flag check
2410:

Line 2415: INV_ORGHIERARCHY_PVT.Log

2411: l_list_count := l_list_count - 1;
2412: l_index := l_index + 1;
2413:
2414: IF G_DEBUG = 'Y' THEN
2415: INV_ORGHIERARCHY_PVT.Log
2416: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
2417: ,' '
2418: );
2419:

Line 2416: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT

2412: l_index := l_index + 1;
2413:
2414: IF G_DEBUG = 'Y' THEN
2415: INV_ORGHIERARCHY_PVT.Log
2416: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
2417: ,' '
2418: );
2419:
2420: INV_ORGHIERARCHY_PVT.Log

Line 2420: INV_ORGHIERARCHY_PVT.Log

2416: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
2417: ,' '
2418: );
2419:
2420: INV_ORGHIERARCHY_PVT.Log
2421: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
2422: ,' ************** END Processing Organization = '||
2423: l_org_name || ' ************************** '
2424: );

Line 2421: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT

2417: ,' '
2418: );
2419:
2420: INV_ORGHIERARCHY_PVT.Log
2421: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
2422: ,' ************** END Processing Organization = '||
2423: l_org_name || ' ************************** '
2424: );
2425: END IF;

Line 2431: INV_ORGHIERARCHY_PVT.Log

2427: l_date_from := NULL;
2428: l_org_from_date := NULL;
2429:
2430: IF G_DEBUG = 'Y' THEN
2431: INV_ORGHIERARCHY_PVT.Log
2432: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
2433: ,' Out of Close FOR loop ' );
2434: END IF;
2435:

Line 2432: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT

2428: l_org_from_date := NULL;
2429:
2430: IF G_DEBUG = 'Y' THEN
2431: INV_ORGHIERARCHY_PVT.Log
2432: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
2433: ,' Out of Close FOR loop ' );
2434: END IF;
2435:
2436: END LOOP; -- organization list loop

Line 2439: INV_ORGHIERARCHY_PVT.Log

2435:
2436: END LOOP; -- organization list loop
2437:
2438: IF G_DEBUG = 'Y' THEN
2439: INV_ORGHIERARCHY_PVT.Log
2440: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
2441: ,' Out of Org List WHILE Loop, start final request check '
2442: );
2443: END IF;

Line 2440: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT

2436: END LOOP; -- organization list loop
2437:
2438: IF G_DEBUG = 'Y' THEN
2439: INV_ORGHIERARCHY_PVT.Log
2440: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
2441: ,' Out of Org List WHILE Loop, start final request check '
2442: );
2443: END IF;
2444:

Line 2452: INV_ORGHIERARCHY_PVT.Log

2448: LOOP
2449: IF GET_OPEN_REQUESTS_COUNT <= 0
2450: THEN
2451: IF G_DEBUG = 'Y' THEN
2452: INV_ORGHIERARCHY_PVT.Log
2453: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
2454: ,' Exiting Request Loop '
2455: );
2456: END IF;

Line 2453: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT

2449: IF GET_OPEN_REQUESTS_COUNT <= 0
2450: THEN
2451: IF G_DEBUG = 'Y' THEN
2452: INV_ORGHIERARCHY_PVT.Log
2453: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
2454: ,' Exiting Request Loop '
2455: );
2456: END IF;
2457: EXIT;

Line 2468: INV_ORGHIERARCHY_PVT.Log

2464:
2465: END LOOP;
2466:
2467: IF G_DEBUG = 'Y' THEN
2468: INV_ORGHIERARCHY_PVT.Log
2469: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
2470: , ' Out of final Request Loop ' );
2471: END IF;
2472: ELSE

Line 2469: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT

2465: END LOOP;
2466:
2467: IF G_DEBUG = 'Y' THEN
2468: INV_ORGHIERARCHY_PVT.Log
2469: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
2470: , ' Out of final Request Loop ' );
2471: END IF;
2472: ELSE
2473: IF G_DEBUG = 'Y' THEN

Line 2474: INV_ORGHIERARCHY_PVT.Log

2470: , ' Out of final Request Loop ' );
2471: END IF;
2472: ELSE
2473: IF G_DEBUG = 'Y' THEN
2474: INV_ORGHIERARCHY_PVT.Log
2475: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
2476: , ' Org List Empty ' );
2477: END IF;
2478: END IF;

Line 2475: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT

2471: END IF;
2472: ELSE
2473: IF G_DEBUG = 'Y' THEN
2474: INV_ORGHIERARCHY_PVT.Log
2475: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
2476: , ' Org List Empty ' );
2477: END IF;
2478: END IF;
2479:

Line 2481: INV_ORGHIERARCHY_PVT.Log

2477: END IF;
2478: END IF;
2479:
2480: IF G_DEBUG = 'Y' THEN
2481: INV_ORGHIERARCHY_PVT.Log
2482: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
2483: ,' '
2484: );
2485:

Line 2482: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT

2478: END IF;
2479:
2480: IF G_DEBUG = 'Y' THEN
2481: INV_ORGHIERARCHY_PVT.Log
2482: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
2483: ,' '
2484: );
2485:
2486: INV_ORGHIERARCHY_PVT.Log

Line 2486: INV_ORGHIERARCHY_PVT.Log

2482: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
2483: ,' '
2484: );
2485:
2486: INV_ORGHIERARCHY_PVT.Log
2487: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
2488: ,'*********************** End of Report *********************** '
2489: );
2490: END IF;

Line 2487: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT

2483: ,' '
2484: );
2485:
2486: INV_ORGHIERARCHY_PVT.Log
2487: (INV_ORGHIERARCHY_PVT.G_LOG_STATEMENT
2488: ,'*********************** End of Report *********************** '
2489: );
2490: END IF;
2491:

Line 2495: INV_ORGHIERARCHY_PVT.Log

2491:
2492: PRINT_REPORT ;
2493:
2494: IF G_DEBUG = 'Y' THEN
2495: INV_ORGHIERARCHY_PVT.Log
2496: (INV_ORGHIERARCHY_PVT.G_LOG_PROCEDURE
2497: ,'< INV_MGD_PRD_CONTROL_MEDIATOR.Period_Control '
2498: );
2499: END IF;

Line 2496: (INV_ORGHIERARCHY_PVT.G_LOG_PROCEDURE

2492: PRINT_REPORT ;
2493:
2494: IF G_DEBUG = 'Y' THEN
2495: INV_ORGHIERARCHY_PVT.Log
2496: (INV_ORGHIERARCHY_PVT.G_LOG_PROCEDURE
2497: ,'< INV_MGD_PRD_CONTROL_MEDIATOR.Period_Control '
2498: );
2499: END IF;
2500:

Line 2513: -- INV_ORGHIERARCHY_PVT.Log

2509: -- to handle scheduling related exception.
2510:
2511: -- Bug #3904824.New exception introduced.
2512: -- WHEN l_close_period_before_sch_dt THEN
2513: -- INV_ORGHIERARCHY_PVT.Log
2514: -- (INV_ORGHIERARCHY_PVT.G_LOG_EXCEPTION,x_errbuff);
2515: -- x_retcode := RETCODE_ERROR;
2516:
2517:

Line 2514: -- (INV_ORGHIERARCHY_PVT.G_LOG_EXCEPTION,x_errbuff);

2510:
2511: -- Bug #3904824.New exception introduced.
2512: -- WHEN l_close_period_before_sch_dt THEN
2513: -- INV_ORGHIERARCHY_PVT.Log
2514: -- (INV_ORGHIERARCHY_PVT.G_LOG_EXCEPTION,x_errbuff);
2515: -- x_retcode := RETCODE_ERROR;
2516:
2517:
2518: -- Bug:3296392 - Addeed the exception hanlding for the validaiton

Line 2521: INV_ORGHIERARCHY_PVT.Log

2517:
2518: -- Bug:3296392 - Addeed the exception hanlding for the validaiton
2519: -- failure.
2520: WHEN l_hierarchy_validation THEN
2521: INV_ORGHIERARCHY_PVT.Log
2522: (INV_ORGHIERARCHY_PVT.G_LOG_EXCEPTION,x_errbuff);
2523: x_retcode := RETCODE_ERROR;
2524:
2525: WHEN OTHERS THEN

Line 2522: (INV_ORGHIERARCHY_PVT.G_LOG_EXCEPTION,x_errbuff);

2518: -- Bug:3296392 - Addeed the exception hanlding for the validaiton
2519: -- failure.
2520: WHEN l_hierarchy_validation THEN
2521: INV_ORGHIERARCHY_PVT.Log
2522: (INV_ORGHIERARCHY_PVT.G_LOG_EXCEPTION,x_errbuff);
2523: x_retcode := RETCODE_ERROR;
2524:
2525: WHEN OTHERS THEN
2526: /* This executable is used by concurrent program so

Line 2531: INV_ORGHIERARCHY_PVT.Log( INV_ORGHIERARCHY_PVT.G_LOG_EXCEPTION

2527: Error/Exception logging should not depend on
2528: FND Debug Enabled profile otpion. Bug: 3555234
2529: IF G_DEBUG = 'Y' THEN
2530: */
2531: INV_ORGHIERARCHY_PVT.Log( INV_ORGHIERARCHY_PVT.G_LOG_EXCEPTION
2532: , 'SQLERRM '|| SQLERRM) ;
2533: --END IF;
2534: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2535: THEN