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.OE_VERSION_PRICE_ADJUST_COMP dependencies on OE_DEBUG_PUB

Line 13: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

9: x_header_adj_rec IN OUT NOCOPY OE_Order_PUB.Header_Adj_Rec_Type)
10: IS
11: l_org_id NUMBER;
12: l_phase_change_flag VARCHAR2(1);
13: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
14: BEGIN
15: oe_debug_pub.add('l_debug_level'||l_debug_level );
16: IF l_debug_level > 0 THEN
17: oe_debug_pub.add('Entering OE_VERSION_PRICE_ADJUST_COMP.QUERY_HEADER_ADJ_ROW');

Line 15: oe_debug_pub.add('l_debug_level'||l_debug_level );

11: l_org_id NUMBER;
12: l_phase_change_flag VARCHAR2(1);
13: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
14: BEGIN
15: oe_debug_pub.add('l_debug_level'||l_debug_level );
16: IF l_debug_level > 0 THEN
17: oe_debug_pub.add('Entering OE_VERSION_PRICE_ADJUST_COMP.QUERY_HEADER_ADJ_ROW');
18: oe_debug_pub.add('header' ||p_header_id);
19: oe_debug_pub.add('price adjust' ||p_price_adjustment_id);

Line 17: oe_debug_pub.add('Entering OE_VERSION_PRICE_ADJUST_COMP.QUERY_HEADER_ADJ_ROW');

13: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
14: BEGIN
15: oe_debug_pub.add('l_debug_level'||l_debug_level );
16: IF l_debug_level > 0 THEN
17: oe_debug_pub.add('Entering OE_VERSION_PRICE_ADJUST_COMP.QUERY_HEADER_ADJ_ROW');
18: oe_debug_pub.add('header' ||p_header_id);
19: oe_debug_pub.add('price adjust' ||p_price_adjustment_id);
20: oe_debug_pub.add('version' ||p_version);
21: END IF;

Line 18: oe_debug_pub.add('header' ||p_header_id);

14: BEGIN
15: oe_debug_pub.add('l_debug_level'||l_debug_level );
16: IF l_debug_level > 0 THEN
17: oe_debug_pub.add('Entering OE_VERSION_PRICE_ADJUST_COMP.QUERY_HEADER_ADJ_ROW');
18: oe_debug_pub.add('header' ||p_header_id);
19: oe_debug_pub.add('price adjust' ||p_price_adjustment_id);
20: oe_debug_pub.add('version' ||p_version);
21: END IF;
22:

Line 19: oe_debug_pub.add('price adjust' ||p_price_adjustment_id);

15: oe_debug_pub.add('l_debug_level'||l_debug_level );
16: IF l_debug_level > 0 THEN
17: oe_debug_pub.add('Entering OE_VERSION_PRICE_ADJUST_COMP.QUERY_HEADER_ADJ_ROW');
18: oe_debug_pub.add('header' ||p_header_id);
19: oe_debug_pub.add('price adjust' ||p_price_adjustment_id);
20: oe_debug_pub.add('version' ||p_version);
21: END IF;
22:
23: l_org_id := OE_GLOBALS.G_ORG_ID;

Line 20: oe_debug_pub.add('version' ||p_version);

16: IF l_debug_level > 0 THEN
17: oe_debug_pub.add('Entering OE_VERSION_PRICE_ADJUST_COMP.QUERY_HEADER_ADJ_ROW');
18: oe_debug_pub.add('header' ||p_header_id);
19: oe_debug_pub.add('price adjust' ||p_price_adjustment_id);
20: oe_debug_pub.add('version' ||p_version);
21: END IF;
22:
23: l_org_id := OE_GLOBALS.G_ORG_ID;
24:

Line 267: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

263: x_header_adj_rec IN OUT NOCOPY OE_Order_PUB.Header_Adj_Rec_Type)
264: IS
265: l_org_id NUMBER;
266: l_phase_change_flag VARCHAR2(1);
267: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
268: BEGIN
269: IF l_debug_level > 0 THEN
270: oe_debug_pub.add('Entering OE_VERSION_PRICE_ADJUST_COMP.QUERY_HEADER_ADJ_TRANS_ROW', 1);
271: oe_debug_pub.add('header' ||p_header_id);

Line 270: oe_debug_pub.add('Entering OE_VERSION_PRICE_ADJUST_COMP.QUERY_HEADER_ADJ_TRANS_ROW', 1);

266: l_phase_change_flag VARCHAR2(1);
267: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
268: BEGIN
269: IF l_debug_level > 0 THEN
270: oe_debug_pub.add('Entering OE_VERSION_PRICE_ADJUST_COMP.QUERY_HEADER_ADJ_TRANS_ROW', 1);
271: oe_debug_pub.add('header' ||p_header_id);
272: oe_debug_pub.add('hprice' ||p_price_adjustment_id);
273: oe_debug_pub.add('version' ||p_version);
274: END IF;

Line 271: oe_debug_pub.add('header' ||p_header_id);

267: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
268: BEGIN
269: IF l_debug_level > 0 THEN
270: oe_debug_pub.add('Entering OE_VERSION_PRICE_ADJUST_COMP.QUERY_HEADER_ADJ_TRANS_ROW', 1);
271: oe_debug_pub.add('header' ||p_header_id);
272: oe_debug_pub.add('hprice' ||p_price_adjustment_id);
273: oe_debug_pub.add('version' ||p_version);
274: END IF;
275:

Line 272: oe_debug_pub.add('hprice' ||p_price_adjustment_id);

268: BEGIN
269: IF l_debug_level > 0 THEN
270: oe_debug_pub.add('Entering OE_VERSION_PRICE_ADJUST_COMP.QUERY_HEADER_ADJ_TRANS_ROW', 1);
271: oe_debug_pub.add('header' ||p_header_id);
272: oe_debug_pub.add('hprice' ||p_price_adjustment_id);
273: oe_debug_pub.add('version' ||p_version);
274: END IF;
275:
276: l_org_id := OE_GLOBALS.G_ORG_ID;

Line 273: oe_debug_pub.add('version' ||p_version);

269: IF l_debug_level > 0 THEN
270: oe_debug_pub.add('Entering OE_VERSION_PRICE_ADJUST_COMP.QUERY_HEADER_ADJ_TRANS_ROW', 1);
271: oe_debug_pub.add('header' ||p_header_id);
272: oe_debug_pub.add('hprice' ||p_price_adjustment_id);
273: oe_debug_pub.add('version' ||p_version);
274: END IF;
275:
276: l_org_id := OE_GLOBALS.G_ORG_ID;
277:

Line 532: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

528: v_header_col VARCHAR2(50);
529: ind NUMBER;
530: prior_exists VARCHAR2(1) := 'N';
531: j NUMBER;
532: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
533: p_prior_rec_exists VARCHAR2(1) := 'N';
534: p_curr_rec_exists VARCHAR2(1) := 'N';
535: p_next_rec_exists VARCHAR2(1) := 'N';
536: p_trans_rec_exists VARCHAR2(1) := 'N';

Line 540: oe_debug_pub.add('Entering comparing_header_adj_attributes');

536: p_trans_rec_exists VARCHAR2(1) := 'N';
537: BEGIN
538:
539: IF l_debug_level > 0 THEN
540: oe_debug_pub.add('Entering comparing_header_adj_attributes');
541: oe_debug_pub.add('header' ||p_header_id);
542: oe_debug_pub.add('price_adjustment_id' ||p_price_adjustment_id);
543: oe_debug_pub.add('prior version' ||p_prior_version);
544: oe_debug_pub.add('current version' ||p_current_version);

Line 541: oe_debug_pub.add('header' ||p_header_id);

537: BEGIN
538:
539: IF l_debug_level > 0 THEN
540: oe_debug_pub.add('Entering comparing_header_adj_attributes');
541: oe_debug_pub.add('header' ||p_header_id);
542: oe_debug_pub.add('price_adjustment_id' ||p_price_adjustment_id);
543: oe_debug_pub.add('prior version' ||p_prior_version);
544: oe_debug_pub.add('current version' ||p_current_version);
545: oe_debug_pub.add('next version' ||p_next_version);

Line 542: oe_debug_pub.add('price_adjustment_id' ||p_price_adjustment_id);

538:
539: IF l_debug_level > 0 THEN
540: oe_debug_pub.add('Entering comparing_header_adj_attributes');
541: oe_debug_pub.add('header' ||p_header_id);
542: oe_debug_pub.add('price_adjustment_id' ||p_price_adjustment_id);
543: oe_debug_pub.add('prior version' ||p_prior_version);
544: oe_debug_pub.add('current version' ||p_current_version);
545: oe_debug_pub.add('next version' ||p_next_version);
546: oe_debug_pub.add('max version' ||g_max_version);

Line 543: oe_debug_pub.add('prior version' ||p_prior_version);

539: IF l_debug_level > 0 THEN
540: oe_debug_pub.add('Entering comparing_header_adj_attributes');
541: oe_debug_pub.add('header' ||p_header_id);
542: oe_debug_pub.add('price_adjustment_id' ||p_price_adjustment_id);
543: oe_debug_pub.add('prior version' ||p_prior_version);
544: oe_debug_pub.add('current version' ||p_current_version);
545: oe_debug_pub.add('next version' ||p_next_version);
546: oe_debug_pub.add('max version' ||g_max_version);
547: oe_debug_pub.add('trans version' ||g_trans_version);

Line 544: oe_debug_pub.add('current version' ||p_current_version);

540: oe_debug_pub.add('Entering comparing_header_adj_attributes');
541: oe_debug_pub.add('header' ||p_header_id);
542: oe_debug_pub.add('price_adjustment_id' ||p_price_adjustment_id);
543: oe_debug_pub.add('prior version' ||p_prior_version);
544: oe_debug_pub.add('current version' ||p_current_version);
545: oe_debug_pub.add('next version' ||p_next_version);
546: oe_debug_pub.add('max version' ||g_max_version);
547: oe_debug_pub.add('trans version' ||g_trans_version);
548: END IF;

Line 545: oe_debug_pub.add('next version' ||p_next_version);

541: oe_debug_pub.add('header' ||p_header_id);
542: oe_debug_pub.add('price_adjustment_id' ||p_price_adjustment_id);
543: oe_debug_pub.add('prior version' ||p_prior_version);
544: oe_debug_pub.add('current version' ||p_current_version);
545: oe_debug_pub.add('next version' ||p_next_version);
546: oe_debug_pub.add('max version' ||g_max_version);
547: oe_debug_pub.add('trans version' ||g_trans_version);
548: END IF;
549:

Line 546: oe_debug_pub.add('max version' ||g_max_version);

542: oe_debug_pub.add('price_adjustment_id' ||p_price_adjustment_id);
543: oe_debug_pub.add('prior version' ||p_prior_version);
544: oe_debug_pub.add('current version' ||p_current_version);
545: oe_debug_pub.add('next version' ||p_next_version);
546: oe_debug_pub.add('max version' ||g_max_version);
547: oe_debug_pub.add('trans version' ||g_trans_version);
548: END IF;
549:
550: if p_total_lines > 0 THEN

Line 547: oe_debug_pub.add('trans version' ||g_trans_version);

543: oe_debug_pub.add('prior version' ||p_prior_version);
544: oe_debug_pub.add('current version' ||p_current_version);
545: oe_debug_pub.add('next version' ||p_next_version);
546: oe_debug_pub.add('max version' ||g_max_version);
547: oe_debug_pub.add('trans version' ||g_trans_version);
548: END IF;
549:
550: if p_total_lines > 0 THEN
551: IF l_debug_level > 0 THEN

Line 552: oe_debug_pub.add(' p_total_lines '||p_total_lines);

548: END IF;
549:
550: if p_total_lines > 0 THEN
551: IF l_debug_level > 0 THEN
552: oe_debug_pub.add(' p_total_lines '||p_total_lines);
553: end if;
554: ind := p_total_lines;
555: ELSE
556: ind := 0;

Line 566: oe_debug_pub.add(' Quering prior line version details');

562: p_curr_rec := NULL;
563: p_next_rec := NULL;
564:
565: IF l_debug_level > 0 THEN
566: oe_debug_pub.add(' Quering prior line version details');
567: oe_debug_pub.add('prior version' ||p_prior_version);
568: END IF;
569:
570: IF p_prior_version IS NOT NULL THEN

Line 567: oe_debug_pub.add('prior version' ||p_prior_version);

563: p_next_rec := NULL;
564:
565: IF l_debug_level > 0 THEN
566: oe_debug_pub.add(' Quering prior line version details');
567: oe_debug_pub.add('prior version' ||p_prior_version);
568: END IF;
569:
570: IF p_prior_version IS NOT NULL THEN
571: OE_VERSION_PRICE_ADJUST_COMP.QUERY_HEADER_adj_ROW(p_header_id => p_header_id,

Line 583: oe_debug_pub.add(' Quering current line version details');

579: p_prior_rec_exists := 'Y';
580: END IF;
581: END IF;
582: IF l_debug_level > 0 THEN
583: oe_debug_pub.add(' Quering current line version details');
584: oe_debug_pub.add('current version' ||p_current_version);
585: END IF;
586:
587: IF p_current_version IS NOT NULL THEN

Line 584: oe_debug_pub.add('current version' ||p_current_version);

580: END IF;
581: END IF;
582: IF l_debug_level > 0 THEN
583: oe_debug_pub.add(' Quering current line version details');
584: oe_debug_pub.add('current version' ||p_current_version);
585: END IF;
586:
587: IF p_current_version IS NOT NULL THEN
588: OE_VERSION_PRICE_ADJUST_COMP.QUERY_HEADER_adj_ROW(p_header_id => p_header_id,

Line 601: oe_debug_pub.add(' Quering next/trans line version details');

597: END IF;
598:
599: END IF;
600: IF l_debug_level > 0 THEN
601: oe_debug_pub.add(' Quering next/trans line version details');
602: oe_debug_pub.add('next version' ||p_next_version);
603: oe_debug_pub.add('trans version' ||g_trans_version);
604: END IF;
605:

Line 602: oe_debug_pub.add('next version' ||p_next_version);

598:
599: END IF;
600: IF l_debug_level > 0 THEN
601: oe_debug_pub.add(' Quering next/trans line version details');
602: oe_debug_pub.add('next version' ||p_next_version);
603: oe_debug_pub.add('trans version' ||g_trans_version);
604: END IF;
605:
606: IF p_next_version = g_trans_version then

Line 603: oe_debug_pub.add('trans version' ||g_trans_version);

599: END IF;
600: IF l_debug_level > 0 THEN
601: oe_debug_pub.add(' Quering next/trans line version details');
602: oe_debug_pub.add('next version' ||p_next_version);
603: oe_debug_pub.add('trans version' ||g_trans_version);
604: END IF;
605:
606: IF p_next_version = g_trans_version then
607: IF g_trans_version is not null then

Line 635: oe_debug_pub.add(' p_prior_rec adjustments'||p_prior_rec.price_adjustment_id);

631: END IF;
632: END IF;
633:
634: IF l_debug_level > 0 THEN
635: oe_debug_pub.add(' p_prior_rec adjustments'||p_prior_rec.price_adjustment_id);
636: oe_debug_pub.add(' p_curr_rec '||p_curr_rec.price_adjustment_id);
637: oe_debug_pub.add(' p_next_rec '||p_next_rec.price_adjustment_id);
638: oe_debug_pub.add(' p_prior_reclist header id'||p_prior_rec.list_header_id);
639: oe_debug_pub.add(' p_curr_rec '||p_curr_rec.list_header_id);

Line 636: oe_debug_pub.add(' p_curr_rec '||p_curr_rec.price_adjustment_id);

632: END IF;
633:
634: IF l_debug_level > 0 THEN
635: oe_debug_pub.add(' p_prior_rec adjustments'||p_prior_rec.price_adjustment_id);
636: oe_debug_pub.add(' p_curr_rec '||p_curr_rec.price_adjustment_id);
637: oe_debug_pub.add(' p_next_rec '||p_next_rec.price_adjustment_id);
638: oe_debug_pub.add(' p_prior_reclist header id'||p_prior_rec.list_header_id);
639: oe_debug_pub.add(' p_curr_rec '||p_curr_rec.list_header_id);
640: oe_debug_pub.add(' p_next_rec '||p_next_rec.list_header_id);

Line 637: oe_debug_pub.add(' p_next_rec '||p_next_rec.price_adjustment_id);

633:
634: IF l_debug_level > 0 THEN
635: oe_debug_pub.add(' p_prior_rec adjustments'||p_prior_rec.price_adjustment_id);
636: oe_debug_pub.add(' p_curr_rec '||p_curr_rec.price_adjustment_id);
637: oe_debug_pub.add(' p_next_rec '||p_next_rec.price_adjustment_id);
638: oe_debug_pub.add(' p_prior_reclist header id'||p_prior_rec.list_header_id);
639: oe_debug_pub.add(' p_curr_rec '||p_curr_rec.list_header_id);
640: oe_debug_pub.add(' p_next_rec '||p_next_rec.list_header_id);
641: oe_debug_pub.add(' checking whether price_adjustment_id are same or not');

Line 638: oe_debug_pub.add(' p_prior_reclist header id'||p_prior_rec.list_header_id);

634: IF l_debug_level > 0 THEN
635: oe_debug_pub.add(' p_prior_rec adjustments'||p_prior_rec.price_adjustment_id);
636: oe_debug_pub.add(' p_curr_rec '||p_curr_rec.price_adjustment_id);
637: oe_debug_pub.add(' p_next_rec '||p_next_rec.price_adjustment_id);
638: oe_debug_pub.add(' p_prior_reclist header id'||p_prior_rec.list_header_id);
639: oe_debug_pub.add(' p_curr_rec '||p_curr_rec.list_header_id);
640: oe_debug_pub.add(' p_next_rec '||p_next_rec.list_header_id);
641: oe_debug_pub.add(' checking whether price_adjustment_id are same or not');
642: oe_debug_pub.add(' p_prior_rec_exists'||p_prior_rec_exists);

Line 639: oe_debug_pub.add(' p_curr_rec '||p_curr_rec.list_header_id);

635: oe_debug_pub.add(' p_prior_rec adjustments'||p_prior_rec.price_adjustment_id);
636: oe_debug_pub.add(' p_curr_rec '||p_curr_rec.price_adjustment_id);
637: oe_debug_pub.add(' p_next_rec '||p_next_rec.price_adjustment_id);
638: oe_debug_pub.add(' p_prior_reclist header id'||p_prior_rec.list_header_id);
639: oe_debug_pub.add(' p_curr_rec '||p_curr_rec.list_header_id);
640: oe_debug_pub.add(' p_next_rec '||p_next_rec.list_header_id);
641: oe_debug_pub.add(' checking whether price_adjustment_id are same or not');
642: oe_debug_pub.add(' p_prior_rec_exists'||p_prior_rec_exists);
643: oe_debug_pub.add(' p_curr_rec_exists'||p_curr_rec_exists);

Line 640: oe_debug_pub.add(' p_next_rec '||p_next_rec.list_header_id);

636: oe_debug_pub.add(' p_curr_rec '||p_curr_rec.price_adjustment_id);
637: oe_debug_pub.add(' p_next_rec '||p_next_rec.price_adjustment_id);
638: oe_debug_pub.add(' p_prior_reclist header id'||p_prior_rec.list_header_id);
639: oe_debug_pub.add(' p_curr_rec '||p_curr_rec.list_header_id);
640: oe_debug_pub.add(' p_next_rec '||p_next_rec.list_header_id);
641: oe_debug_pub.add(' checking whether price_adjustment_id are same or not');
642: oe_debug_pub.add(' p_prior_rec_exists'||p_prior_rec_exists);
643: oe_debug_pub.add(' p_curr_rec_exists'||p_curr_rec_exists);
644: oe_debug_pub.add(' p_next_rec_exists'||p_next_rec_exists);

Line 641: oe_debug_pub.add(' checking whether price_adjustment_id are same or not');

637: oe_debug_pub.add(' p_next_rec '||p_next_rec.price_adjustment_id);
638: oe_debug_pub.add(' p_prior_reclist header id'||p_prior_rec.list_header_id);
639: oe_debug_pub.add(' p_curr_rec '||p_curr_rec.list_header_id);
640: oe_debug_pub.add(' p_next_rec '||p_next_rec.list_header_id);
641: oe_debug_pub.add(' checking whether price_adjustment_id are same or not');
642: oe_debug_pub.add(' p_prior_rec_exists'||p_prior_rec_exists);
643: oe_debug_pub.add(' p_curr_rec_exists'||p_curr_rec_exists);
644: oe_debug_pub.add(' p_next_rec_exists'||p_next_rec_exists);
645: oe_debug_pub.add(' p_trans_rec_exists'||p_trans_rec_exists);

Line 642: oe_debug_pub.add(' p_prior_rec_exists'||p_prior_rec_exists);

638: oe_debug_pub.add(' p_prior_reclist header id'||p_prior_rec.list_header_id);
639: oe_debug_pub.add(' p_curr_rec '||p_curr_rec.list_header_id);
640: oe_debug_pub.add(' p_next_rec '||p_next_rec.list_header_id);
641: oe_debug_pub.add(' checking whether price_adjustment_id are same or not');
642: oe_debug_pub.add(' p_prior_rec_exists'||p_prior_rec_exists);
643: oe_debug_pub.add(' p_curr_rec_exists'||p_curr_rec_exists);
644: oe_debug_pub.add(' p_next_rec_exists'||p_next_rec_exists);
645: oe_debug_pub.add(' p_trans_rec_exists'||p_trans_rec_exists);
646: END IF;

Line 643: oe_debug_pub.add(' p_curr_rec_exists'||p_curr_rec_exists);

639: oe_debug_pub.add(' p_curr_rec '||p_curr_rec.list_header_id);
640: oe_debug_pub.add(' p_next_rec '||p_next_rec.list_header_id);
641: oe_debug_pub.add(' checking whether price_adjustment_id are same or not');
642: oe_debug_pub.add(' p_prior_rec_exists'||p_prior_rec_exists);
643: oe_debug_pub.add(' p_curr_rec_exists'||p_curr_rec_exists);
644: oe_debug_pub.add(' p_next_rec_exists'||p_next_rec_exists);
645: oe_debug_pub.add(' p_trans_rec_exists'||p_trans_rec_exists);
646: END IF;
647: IF (p_prior_rec_exists = 'Y' and p_curr_rec_exists ='Y') OR

Line 644: oe_debug_pub.add(' p_next_rec_exists'||p_next_rec_exists);

640: oe_debug_pub.add(' p_next_rec '||p_next_rec.list_header_id);
641: oe_debug_pub.add(' checking whether price_adjustment_id are same or not');
642: oe_debug_pub.add(' p_prior_rec_exists'||p_prior_rec_exists);
643: oe_debug_pub.add(' p_curr_rec_exists'||p_curr_rec_exists);
644: oe_debug_pub.add(' p_next_rec_exists'||p_next_rec_exists);
645: oe_debug_pub.add(' p_trans_rec_exists'||p_trans_rec_exists);
646: END IF;
647: IF (p_prior_rec_exists = 'Y' and p_curr_rec_exists ='Y') OR
648: (p_curr_rec_exists = 'Y' and p_next_rec_exists ='Y') THEN

Line 645: oe_debug_pub.add(' p_trans_rec_exists'||p_trans_rec_exists);

641: oe_debug_pub.add(' checking whether price_adjustment_id are same or not');
642: oe_debug_pub.add(' p_prior_rec_exists'||p_prior_rec_exists);
643: oe_debug_pub.add(' p_curr_rec_exists'||p_curr_rec_exists);
644: oe_debug_pub.add(' p_next_rec_exists'||p_next_rec_exists);
645: oe_debug_pub.add(' p_trans_rec_exists'||p_trans_rec_exists);
646: END IF;
647: IF (p_prior_rec_exists = 'Y' and p_curr_rec_exists ='Y') OR
648: (p_curr_rec_exists = 'Y' and p_next_rec_exists ='Y') THEN
649: IF l_debug_level > 0 THEN

Line 650: oe_debug_pub.add(' both exists - checking if both are same');

646: END IF;
647: IF (p_prior_rec_exists = 'Y' and p_curr_rec_exists ='Y') OR
648: (p_curr_rec_exists = 'Y' and p_next_rec_exists ='Y') THEN
649: IF l_debug_level > 0 THEN
650: oe_debug_pub.add(' both exists - checking if both are same');
651: END IF;
652: IF OE_Globals.Equal(p_prior_rec.list_header_id,p_curr_rec.list_header_id) OR
653: OE_Globals.Equal( p_curr_rec.list_header_id, p_next_rec.list_header_id) THEN
654: /****************************/

Line 2830: oe_debug_pub.add(' before finding new price_adjustment_id ');

2826: END IF; /* if price adjustment is same */
2827: END IF; /* p and c = Y or c and n=y */
2828:
2829: IF l_debug_level > 0 THEN
2830: oe_debug_pub.add(' before finding new price_adjustment_id ');
2831: oe_debug_pub.add(' p_prior_rec_exists'||p_prior_rec_exists);
2832: oe_debug_pub.add(' p_curr_rec_exists'||p_curr_rec_exists);
2833: oe_debug_pub.add(' p_next_rec_exists'||p_next_rec_exists);
2834: oe_debug_pub.add(' p_trans_rec_exists'||p_trans_rec_exists);

Line 2831: oe_debug_pub.add(' p_prior_rec_exists'||p_prior_rec_exists);

2827: END IF; /* p and c = Y or c and n=y */
2828:
2829: IF l_debug_level > 0 THEN
2830: oe_debug_pub.add(' before finding new price_adjustment_id ');
2831: oe_debug_pub.add(' p_prior_rec_exists'||p_prior_rec_exists);
2832: oe_debug_pub.add(' p_curr_rec_exists'||p_curr_rec_exists);
2833: oe_debug_pub.add(' p_next_rec_exists'||p_next_rec_exists);
2834: oe_debug_pub.add(' p_trans_rec_exists'||p_trans_rec_exists);
2835: END IF;

Line 2832: oe_debug_pub.add(' p_curr_rec_exists'||p_curr_rec_exists);

2828:
2829: IF l_debug_level > 0 THEN
2830: oe_debug_pub.add(' before finding new price_adjustment_id ');
2831: oe_debug_pub.add(' p_prior_rec_exists'||p_prior_rec_exists);
2832: oe_debug_pub.add(' p_curr_rec_exists'||p_curr_rec_exists);
2833: oe_debug_pub.add(' p_next_rec_exists'||p_next_rec_exists);
2834: oe_debug_pub.add(' p_trans_rec_exists'||p_trans_rec_exists);
2835: END IF;
2836: IF (p_prior_rec_exists = 'N' and p_curr_rec_exists = 'Y') OR

Line 2833: oe_debug_pub.add(' p_next_rec_exists'||p_next_rec_exists);

2829: IF l_debug_level > 0 THEN
2830: oe_debug_pub.add(' before finding new price_adjustment_id ');
2831: oe_debug_pub.add(' p_prior_rec_exists'||p_prior_rec_exists);
2832: oe_debug_pub.add(' p_curr_rec_exists'||p_curr_rec_exists);
2833: oe_debug_pub.add(' p_next_rec_exists'||p_next_rec_exists);
2834: oe_debug_pub.add(' p_trans_rec_exists'||p_trans_rec_exists);
2835: END IF;
2836: IF (p_prior_rec_exists = 'N' and p_curr_rec_exists = 'Y') OR
2837: (p_curr_rec_exists = 'N' and p_next_rec_exists ='Y') THEN

Line 2834: oe_debug_pub.add(' p_trans_rec_exists'||p_trans_rec_exists);

2830: oe_debug_pub.add(' before finding new price_adjustment_id ');
2831: oe_debug_pub.add(' p_prior_rec_exists'||p_prior_rec_exists);
2832: oe_debug_pub.add(' p_curr_rec_exists'||p_curr_rec_exists);
2833: oe_debug_pub.add(' p_next_rec_exists'||p_next_rec_exists);
2834: oe_debug_pub.add(' p_trans_rec_exists'||p_trans_rec_exists);
2835: END IF;
2836: IF (p_prior_rec_exists = 'N' and p_curr_rec_exists = 'Y') OR
2837: (p_curr_rec_exists = 'N' and p_next_rec_exists ='Y') THEN
2838: IF p_prior_version IS NOT NULL and p_curr_rec_exists = 'Y' THEN

Line 2840: oe_debug_pub.add(' Prior is not there - current is there');

2836: IF (p_prior_rec_exists = 'N' and p_curr_rec_exists = 'Y') OR
2837: (p_curr_rec_exists = 'N' and p_next_rec_exists ='Y') THEN
2838: IF p_prior_version IS NOT NULL and p_curr_rec_exists = 'Y' THEN
2839: IF l_debug_level > 0 THEN
2840: oe_debug_pub.add(' Prior is not there - current is there');
2841: END IF;
2842: ind := ind+1;
2843: x_header_adj_changed_attr_tbl(ind).attribute_value := OE_ID_TO_VALUE.new_modifier_list(p_curr_rec.list_header_id);
2844: x_header_adj_changed_attr_tbl(ind).prior_value := null;

Line 2849: oe_debug_pub.add(' Current is not there - next is there');

2845: x_header_adj_changed_attr_tbl(ind).current_value := 'ADD';
2846: x_header_adj_changed_attr_tbl(ind).next_value := null;
2847: ELSIF (p_curr_rec_exists = 'N' and p_next_rec_exists = 'Y') THEN
2848: IF l_debug_level > 0 THEN
2849: oe_debug_pub.add(' Current is not there - next is there');
2850: END IF;
2851: ind := ind+1;
2852: x_header_adj_changed_attr_tbl(ind).attribute_value := OE_ID_TO_VALUE.new_modifier_list(p_next_rec.list_header_id);
2853: x_header_adj_changed_attr_tbl(ind).prior_value := null;

Line 2860: oe_debug_pub.add(' before finding deleted new_modifier_list');

2856: end if;
2857: END IF;
2858:
2859: IF l_debug_level > 0 THEN
2860: oe_debug_pub.add(' before finding deleted new_modifier_list');
2861: oe_debug_pub.add(' p_prior_rec_exists'||p_prior_rec_exists);
2862: oe_debug_pub.add(' p_curr_rec_exists'||p_curr_rec_exists);
2863: oe_debug_pub.add(' p_next_rec_exists'||p_next_rec_exists);
2864: oe_debug_pub.add(' p_trans_rec_exists'||p_trans_rec_exists);

Line 2861: oe_debug_pub.add(' p_prior_rec_exists'||p_prior_rec_exists);

2857: END IF;
2858:
2859: IF l_debug_level > 0 THEN
2860: oe_debug_pub.add(' before finding deleted new_modifier_list');
2861: oe_debug_pub.add(' p_prior_rec_exists'||p_prior_rec_exists);
2862: oe_debug_pub.add(' p_curr_rec_exists'||p_curr_rec_exists);
2863: oe_debug_pub.add(' p_next_rec_exists'||p_next_rec_exists);
2864: oe_debug_pub.add(' p_trans_rec_exists'||p_trans_rec_exists);
2865: END IF;

Line 2862: oe_debug_pub.add(' p_curr_rec_exists'||p_curr_rec_exists);

2858:
2859: IF l_debug_level > 0 THEN
2860: oe_debug_pub.add(' before finding deleted new_modifier_list');
2861: oe_debug_pub.add(' p_prior_rec_exists'||p_prior_rec_exists);
2862: oe_debug_pub.add(' p_curr_rec_exists'||p_curr_rec_exists);
2863: oe_debug_pub.add(' p_next_rec_exists'||p_next_rec_exists);
2864: oe_debug_pub.add(' p_trans_rec_exists'||p_trans_rec_exists);
2865: END IF;
2866: IF (p_prior_rec_exists = 'Y' and p_curr_rec_exists = 'N') OR

Line 2863: oe_debug_pub.add(' p_next_rec_exists'||p_next_rec_exists);

2859: IF l_debug_level > 0 THEN
2860: oe_debug_pub.add(' before finding deleted new_modifier_list');
2861: oe_debug_pub.add(' p_prior_rec_exists'||p_prior_rec_exists);
2862: oe_debug_pub.add(' p_curr_rec_exists'||p_curr_rec_exists);
2863: oe_debug_pub.add(' p_next_rec_exists'||p_next_rec_exists);
2864: oe_debug_pub.add(' p_trans_rec_exists'||p_trans_rec_exists);
2865: END IF;
2866: IF (p_prior_rec_exists = 'Y' and p_curr_rec_exists = 'N') OR
2867: (p_curr_rec_exists = 'Y' and p_next_rec_exists ='N') THEN

Line 2864: oe_debug_pub.add(' p_trans_rec_exists'||p_trans_rec_exists);

2860: oe_debug_pub.add(' before finding deleted new_modifier_list');
2861: oe_debug_pub.add(' p_prior_rec_exists'||p_prior_rec_exists);
2862: oe_debug_pub.add(' p_curr_rec_exists'||p_curr_rec_exists);
2863: oe_debug_pub.add(' p_next_rec_exists'||p_next_rec_exists);
2864: oe_debug_pub.add(' p_trans_rec_exists'||p_trans_rec_exists);
2865: END IF;
2866: IF (p_prior_rec_exists = 'Y' and p_curr_rec_exists = 'N') OR
2867: (p_curr_rec_exists = 'Y' and p_next_rec_exists ='N') THEN
2868: IF p_prior_rec_exists = 'Y' and p_curr_rec_exists = 'N' THEN

Line 2870: oe_debug_pub.add(' Prior is there - current is not there');

2866: IF (p_prior_rec_exists = 'Y' and p_curr_rec_exists = 'N') OR
2867: (p_curr_rec_exists = 'Y' and p_next_rec_exists ='N') THEN
2868: IF p_prior_rec_exists = 'Y' and p_curr_rec_exists = 'N' THEN
2869: IF l_debug_level > 0 THEN
2870: oe_debug_pub.add(' Prior is there - current is not there');
2871: END IF;
2872: ind := ind+1;
2873: x_header_adj_changed_attr_tbl(ind).attribute_value := OE_ID_TO_VALUE.new_modifier_list(p_prior_rec.list_header_id);
2874: x_header_adj_changed_attr_tbl(ind).prior_value := null;

Line 2879: oe_debug_pub.add(' p_next_version'||p_next_version);

2875: x_header_adj_changed_attr_tbl(ind).current_value := 'DELETE';
2876: x_header_adj_changed_attr_tbl(ind).next_value := null;
2877: ELSIF p_curr_rec_exists = 'Y' and p_next_rec_exists = 'N' THEN
2878: IF l_debug_level > 0 THEN
2879: oe_debug_pub.add(' p_next_version'||p_next_version);
2880: oe_debug_pub.add(' g_trans_version'||g_trans_version);
2881: END IF;
2882: --if p_next_version != g_trans_version THEN
2883: IF l_debug_level > 0 THEN

Line 2880: oe_debug_pub.add(' g_trans_version'||g_trans_version);

2876: x_header_adj_changed_attr_tbl(ind).next_value := null;
2877: ELSIF p_curr_rec_exists = 'Y' and p_next_rec_exists = 'N' THEN
2878: IF l_debug_level > 0 THEN
2879: oe_debug_pub.add(' p_next_version'||p_next_version);
2880: oe_debug_pub.add(' g_trans_version'||g_trans_version);
2881: END IF;
2882: --if p_next_version != g_trans_version THEN
2883: IF l_debug_level > 0 THEN
2884: oe_debug_pub.add(' Current is there - next is not there');

Line 2884: oe_debug_pub.add(' Current is there - next is not there');

2880: oe_debug_pub.add(' g_trans_version'||g_trans_version);
2881: END IF;
2882: --if p_next_version != g_trans_version THEN
2883: IF l_debug_level > 0 THEN
2884: oe_debug_pub.add(' Current is there - next is not there');
2885: END IF;
2886: ind := ind+1;
2887: x_header_adj_changed_attr_tbl(ind).attribute_value := OE_ID_TO_VALUE.new_modifier_list(p_curr_rec.list_header_id);
2888: x_header_adj_changed_attr_tbl(ind).prior_value := null;

Line 2895: oe_debug_pub.add('BEFORE COMPARING ATTRIBUTES*******');

2891: --end if;
2892: end if;
2893: END IF;
2894: IF l_debug_level > 0 THEN
2895: oe_debug_pub.add('******BEFORE COMPARING ATTRIBUTES*************');
2896: oe_debug_pub.add('current ind '|| ind);
2897: END IF;
2898:
2899: END IF; /* line_id not null */

Line 2896: oe_debug_pub.add('current ind '|| ind);

2892: end if;
2893: END IF;
2894: IF l_debug_level > 0 THEN
2895: oe_debug_pub.add('******BEFORE COMPARING ATTRIBUTES*************');
2896: oe_debug_pub.add('current ind '|| ind);
2897: END IF;
2898:
2899: END IF; /* line_id not null */
2900: IF l_debug_level > 0 THEN

Line 2901: oe_debug_pub.add('AFTER COMPARING ATTRIBUTES*******');

2897: END IF;
2898:
2899: END IF; /* line_id not null */
2900: IF l_debug_level > 0 THEN
2901: oe_debug_pub.add('******AFTER COMPARING ATTRIBUTES*************');
2902: oe_debug_pub.add('current ind '|| ind);
2903: END IF;
2904: IF l_debug_level > 0 THEN
2905: oe_debug_pub.add(' Exiting OE_VERSION_PRICE_ADJUST_COMP.Compare_header_adj_Attributes ');

Line 2902: oe_debug_pub.add('current ind '|| ind);

2898:
2899: END IF; /* line_id not null */
2900: IF l_debug_level > 0 THEN
2901: oe_debug_pub.add('******AFTER COMPARING ATTRIBUTES*************');
2902: oe_debug_pub.add('current ind '|| ind);
2903: END IF;
2904: IF l_debug_level > 0 THEN
2905: oe_debug_pub.add(' Exiting OE_VERSION_PRICE_ADJUST_COMP.Compare_header_adj_Attributes ');
2906: END IF;

Line 2905: oe_debug_pub.add(' Exiting OE_VERSION_PRICE_ADJUST_COMP.Compare_header_adj_Attributes ');

2901: oe_debug_pub.add('******AFTER COMPARING ATTRIBUTES*************');
2902: oe_debug_pub.add('current ind '|| ind);
2903: END IF;
2904: IF l_debug_level > 0 THEN
2905: oe_debug_pub.add(' Exiting OE_VERSION_PRICE_ADJUST_COMP.Compare_header_adj_Attributes ');
2906: END IF;
2907: /*
2908: j := 0;
2909: dbms_output.put_line('No of records'||x_header_adj_changed_attr_tbl.count);

Line 2964: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

2960: and version_number in (p_prior_version,p_current_version,p_next_version);
2961: ind1 NUMBER;
2962: l_price_adjustment_id NUMBER;
2963: total_lines NUMBER;
2964: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2965: BEGIN
2966: IF l_debug_level > 0 THEN
2967: oe_debug_pub.add('Entering Compare_header_adj_versions');
2968: oe_debug_pub.add('header' ||p_header_id);

Line 2967: oe_debug_pub.add('Entering Compare_header_adj_versions');

2963: total_lines NUMBER;
2964: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2965: BEGIN
2966: IF l_debug_level > 0 THEN
2967: oe_debug_pub.add('Entering Compare_header_adj_versions');
2968: oe_debug_pub.add('header' ||p_header_id);
2969: oe_debug_pub.add('prior version' ||p_prior_version);
2970: oe_debug_pub.add('current version' ||p_current_version);
2971: oe_debug_pub.add('next version' ||p_next_version);

Line 2968: oe_debug_pub.add('header' ||p_header_id);

2964: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2965: BEGIN
2966: IF l_debug_level > 0 THEN
2967: oe_debug_pub.add('Entering Compare_header_adj_versions');
2968: oe_debug_pub.add('header' ||p_header_id);
2969: oe_debug_pub.add('prior version' ||p_prior_version);
2970: oe_debug_pub.add('current version' ||p_current_version);
2971: oe_debug_pub.add('next version' ||p_next_version);
2972: oe_debug_pub.add('max version' ||g_max_version);

Line 2969: oe_debug_pub.add('prior version' ||p_prior_version);

2965: BEGIN
2966: IF l_debug_level > 0 THEN
2967: oe_debug_pub.add('Entering Compare_header_adj_versions');
2968: oe_debug_pub.add('header' ||p_header_id);
2969: oe_debug_pub.add('prior version' ||p_prior_version);
2970: oe_debug_pub.add('current version' ||p_current_version);
2971: oe_debug_pub.add('next version' ||p_next_version);
2972: oe_debug_pub.add('max version' ||g_max_version);
2973: oe_debug_pub.add('trans version' ||g_trans_version);

Line 2970: oe_debug_pub.add('current version' ||p_current_version);

2966: IF l_debug_level > 0 THEN
2967: oe_debug_pub.add('Entering Compare_header_adj_versions');
2968: oe_debug_pub.add('header' ||p_header_id);
2969: oe_debug_pub.add('prior version' ||p_prior_version);
2970: oe_debug_pub.add('current version' ||p_current_version);
2971: oe_debug_pub.add('next version' ||p_next_version);
2972: oe_debug_pub.add('max version' ||g_max_version);
2973: oe_debug_pub.add('trans version' ||g_trans_version);
2974: END IF;

Line 2971: oe_debug_pub.add('next version' ||p_next_version);

2967: oe_debug_pub.add('Entering Compare_header_adj_versions');
2968: oe_debug_pub.add('header' ||p_header_id);
2969: oe_debug_pub.add('prior version' ||p_prior_version);
2970: oe_debug_pub.add('current version' ||p_current_version);
2971: oe_debug_pub.add('next version' ||p_next_version);
2972: oe_debug_pub.add('max version' ||g_max_version);
2973: oe_debug_pub.add('trans version' ||g_trans_version);
2974: END IF;
2975:

Line 2972: oe_debug_pub.add('max version' ||g_max_version);

2968: oe_debug_pub.add('header' ||p_header_id);
2969: oe_debug_pub.add('prior version' ||p_prior_version);
2970: oe_debug_pub.add('current version' ||p_current_version);
2971: oe_debug_pub.add('next version' ||p_next_version);
2972: oe_debug_pub.add('max version' ||g_max_version);
2973: oe_debug_pub.add('trans version' ||g_trans_version);
2974: END IF;
2975:
2976: ind1:=0;

Line 2973: oe_debug_pub.add('trans version' ||g_trans_version);

2969: oe_debug_pub.add('prior version' ||p_prior_version);
2970: oe_debug_pub.add('current version' ||p_current_version);
2971: oe_debug_pub.add('next version' ||p_next_version);
2972: oe_debug_pub.add('max version' ||g_max_version);
2973: oe_debug_pub.add('trans version' ||g_trans_version);
2974: END IF;
2975:
2976: ind1:=0;
2977: total_lines:=0;

Line 2985: oe_debug_pub.add('*adjustments found(trans)******'||l_price_adjustment_id); END IF;

2981: LOOP
2982: FETCH C_GET_adjustments INTO l_price_adjustment_id;
2983: EXIT WHEN C_GET_adjustments%NOTFOUND;
2984: IF l_debug_level > 0 THEN
2985: oe_debug_pub.add('*************adjustments found(trans)******************'||l_price_adjustment_id); END IF;
2986:
2987: IF l_price_adjustment_id IS NOT NULL THEN
2988: IF l_debug_level > 0 THEN
2989: oe_debug_pub.add('*************before call total price_adjustment_id(trans) ******************'||ind1);

Line 2989: oe_debug_pub.add('*before call total price_adjustment_id(trans) ******'||ind1);

2985: oe_debug_pub.add('*************adjustments found(trans)******************'||l_price_adjustment_id); END IF;
2986:
2987: IF l_price_adjustment_id IS NOT NULL THEN
2988: IF l_debug_level > 0 THEN
2989: oe_debug_pub.add('*************before call total price_adjustment_id(trans) ******************'||ind1);
2990: END IF;
2991: COMPARE_HEADER_adj_ATTRIBUTES(p_header_id => p_header_id,
2992: p_price_adjustment_id => l_price_adjustment_id,
2993: p_prior_version => p_prior_version,

Line 3009: oe_debug_pub.add('*after call total price_adjustment_id(trans) ******'||ind1);

3005: ind1 := x_header_adj_changed_attr_tbl.count;
3006: -- ind1 := ind1 + total_lines;
3007: END IF;
3008: IF l_debug_level > 0 THEN
3009: oe_debug_pub.add('*************after call total price_adjustment_id(trans) ******************'||ind1);
3010: END IF;
3011: END IF; /* price_adjustment_id is not null */
3012: END LOOP;
3013: CLOSE C_GET_adjustments;

Line 3020: oe_debug_pub.add('*adjustments found******'||l_price_adjustment_id);

3016: LOOP
3017: FETCH C_GET_HIST_adjustments INTO l_price_adjustment_id;
3018: EXIT WHEN C_GET_HIST_adjustments%NOTFOUND;
3019: IF l_debug_level > 0 THEN
3020: oe_debug_pub.add('*************adjustments found******************'||l_price_adjustment_id);
3021: END IF;
3022:
3023: IF l_price_adjustment_id IS NOT NULL THEN
3024: IF l_debug_level > 0 THEN

Line 3025: oe_debug_pub.add('*before call total price_adjustment ******'||ind1);

3021: END IF;
3022:
3023: IF l_price_adjustment_id IS NOT NULL THEN
3024: IF l_debug_level > 0 THEN
3025: oe_debug_pub.add('*************before call total price_adjustment ******************'||ind1);
3026: END IF;
3027: COMPARE_HEADER_adj_ATTRIBUTES(p_header_id => p_header_id,
3028: p_price_adjustment_id => l_price_adjustment_id,
3029: p_prior_version => p_prior_version,

Line 3040: oe_debug_pub.add('*after call total price_adjustment_id credits ******'||ind1);

3036: g_trans_version => g_trans_version,
3037: x_header_adj_changed_attr_tbl => x_header_adj_changed_attr_tbl,
3038: p_total_lines => ind1);
3039: IF l_debug_level > 0 THEN
3040: oe_debug_pub.add('*************after call total price_adjustment_id credits ******************'||ind1);
3041: END IF;
3042: IF x_header_adj_changed_attr_tbl.count > 0 THEN
3043: ind1 := x_header_adj_changed_attr_tbl.count;
3044: -- ind1 := ind1 + total_lines;

Line 3063: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

3059: x_line_adj_rec IN OUT NOCOPY OE_Order_PUB.line_Adj_Rec_Type)
3060: IS
3061: l_org_id NUMBER;
3062: l_phase_change_flag VARCHAR2(1);
3063: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3064: BEGIN
3065: IF l_debug_level > 0 THEN
3066: oe_debug_pub.add('Entering OE_VERSION_PRICE_ADJUST_COMP.QUERY_line_ADJ_ROW');
3067: oe_debug_pub.add('header' ||p_header_id);

Line 3066: oe_debug_pub.add('Entering OE_VERSION_PRICE_ADJUST_COMP.QUERY_line_ADJ_ROW');

3062: l_phase_change_flag VARCHAR2(1);
3063: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3064: BEGIN
3065: IF l_debug_level > 0 THEN
3066: oe_debug_pub.add('Entering OE_VERSION_PRICE_ADJUST_COMP.QUERY_line_ADJ_ROW');
3067: oe_debug_pub.add('header' ||p_header_id);
3068: oe_debug_pub.add('header' ||p_price_adjustment_id);
3069: oe_debug_pub.add('version' ||p_version);
3070: END IF;

Line 3067: oe_debug_pub.add('header' ||p_header_id);

3063: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3064: BEGIN
3065: IF l_debug_level > 0 THEN
3066: oe_debug_pub.add('Entering OE_VERSION_PRICE_ADJUST_COMP.QUERY_line_ADJ_ROW');
3067: oe_debug_pub.add('header' ||p_header_id);
3068: oe_debug_pub.add('header' ||p_price_adjustment_id);
3069: oe_debug_pub.add('version' ||p_version);
3070: END IF;
3071:

Line 3068: oe_debug_pub.add('header' ||p_price_adjustment_id);

3064: BEGIN
3065: IF l_debug_level > 0 THEN
3066: oe_debug_pub.add('Entering OE_VERSION_PRICE_ADJUST_COMP.QUERY_line_ADJ_ROW');
3067: oe_debug_pub.add('header' ||p_header_id);
3068: oe_debug_pub.add('header' ||p_price_adjustment_id);
3069: oe_debug_pub.add('version' ||p_version);
3070: END IF;
3071:
3072: l_org_id := OE_GLOBALS.G_ORG_ID;

Line 3069: oe_debug_pub.add('version' ||p_version);

3065: IF l_debug_level > 0 THEN
3066: oe_debug_pub.add('Entering OE_VERSION_PRICE_ADJUST_COMP.QUERY_line_ADJ_ROW');
3067: oe_debug_pub.add('header' ||p_header_id);
3068: oe_debug_pub.add('header' ||p_price_adjustment_id);
3069: oe_debug_pub.add('version' ||p_version);
3070: END IF;
3071:
3072: l_org_id := OE_GLOBALS.G_ORG_ID;
3073:

Line 3317: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

3313: x_line_adj_rec IN OUT NOCOPY OE_Order_PUB.line_Adj_Rec_Type)
3314: IS
3315: l_org_id NUMBER;
3316: l_phase_change_flag VARCHAR2(1);
3317: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3318: BEGIN
3319: IF l_debug_level > 0 THEN
3320: oe_debug_pub.add('Entering OE_VERSION_PRICE_ADJUST_COMP.QUERY_line_ADJ_TRANS_ROW' );
3321: oe_debug_pub.add('header' ||p_header_id);

Line 3320: oe_debug_pub.add('Entering OE_VERSION_PRICE_ADJUST_COMP.QUERY_line_ADJ_TRANS_ROW' );

3316: l_phase_change_flag VARCHAR2(1);
3317: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3318: BEGIN
3319: IF l_debug_level > 0 THEN
3320: oe_debug_pub.add('Entering OE_VERSION_PRICE_ADJUST_COMP.QUERY_line_ADJ_TRANS_ROW' );
3321: oe_debug_pub.add('header' ||p_header_id);
3322: oe_debug_pub.add('price' ||p_price_adjustment_id);
3323: oe_debug_pub.add('version' ||p_version);
3324: END IF;

Line 3321: oe_debug_pub.add('header' ||p_header_id);

3317: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3318: BEGIN
3319: IF l_debug_level > 0 THEN
3320: oe_debug_pub.add('Entering OE_VERSION_PRICE_ADJUST_COMP.QUERY_line_ADJ_TRANS_ROW' );
3321: oe_debug_pub.add('header' ||p_header_id);
3322: oe_debug_pub.add('price' ||p_price_adjustment_id);
3323: oe_debug_pub.add('version' ||p_version);
3324: END IF;
3325:

Line 3322: oe_debug_pub.add('price' ||p_price_adjustment_id);

3318: BEGIN
3319: IF l_debug_level > 0 THEN
3320: oe_debug_pub.add('Entering OE_VERSION_PRICE_ADJUST_COMP.QUERY_line_ADJ_TRANS_ROW' );
3321: oe_debug_pub.add('header' ||p_header_id);
3322: oe_debug_pub.add('price' ||p_price_adjustment_id);
3323: oe_debug_pub.add('version' ||p_version);
3324: END IF;
3325:
3326: l_org_id := OE_GLOBALS.G_ORG_ID;

Line 3323: oe_debug_pub.add('version' ||p_version);

3319: IF l_debug_level > 0 THEN
3320: oe_debug_pub.add('Entering OE_VERSION_PRICE_ADJUST_COMP.QUERY_line_ADJ_TRANS_ROW' );
3321: oe_debug_pub.add('header' ||p_header_id);
3322: oe_debug_pub.add('price' ||p_price_adjustment_id);
3323: oe_debug_pub.add('version' ||p_version);
3324: END IF;
3325:
3326: l_org_id := OE_GLOBALS.G_ORG_ID;
3327:

Line 3584: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

3580: v_line_col VARCHAR2(50);
3581: ind NUMBER;
3582: prior_exists VARCHAR2(1) := 'N';
3583: j NUMBER;
3584: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3585: p_prior_rec_exists VARCHAR2(1) := 'N';
3586: p_curr_rec_exists VARCHAR2(1) := 'N';
3587: p_next_rec_exists VARCHAR2(1) := 'N';
3588: p_trans_rec_exists VARCHAR2(1) := 'N';

Line 3592: oe_debug_pub.add('Entering comparing_line_adj_attributes');

3588: p_trans_rec_exists VARCHAR2(1) := 'N';
3589: BEGIN
3590:
3591: IF l_debug_level > 0 THEN
3592: oe_debug_pub.add('Entering comparing_line_adj_attributes');
3593: oe_debug_pub.add('header' ||p_header_id);
3594: oe_debug_pub.add('adjustment id' ||p_price_adjustment_id);
3595: oe_debug_pub.add('prior version' ||p_prior_version);
3596: oe_debug_pub.add('current version' ||p_current_version);

Line 3593: oe_debug_pub.add('header' ||p_header_id);

3589: BEGIN
3590:
3591: IF l_debug_level > 0 THEN
3592: oe_debug_pub.add('Entering comparing_line_adj_attributes');
3593: oe_debug_pub.add('header' ||p_header_id);
3594: oe_debug_pub.add('adjustment id' ||p_price_adjustment_id);
3595: oe_debug_pub.add('prior version' ||p_prior_version);
3596: oe_debug_pub.add('current version' ||p_current_version);
3597: oe_debug_pub.add('next version' ||p_next_version);

Line 3594: oe_debug_pub.add('adjustment id' ||p_price_adjustment_id);

3590:
3591: IF l_debug_level > 0 THEN
3592: oe_debug_pub.add('Entering comparing_line_adj_attributes');
3593: oe_debug_pub.add('header' ||p_header_id);
3594: oe_debug_pub.add('adjustment id' ||p_price_adjustment_id);
3595: oe_debug_pub.add('prior version' ||p_prior_version);
3596: oe_debug_pub.add('current version' ||p_current_version);
3597: oe_debug_pub.add('next version' ||p_next_version);
3598: oe_debug_pub.add('max version' ||g_max_version);

Line 3595: oe_debug_pub.add('prior version' ||p_prior_version);

3591: IF l_debug_level > 0 THEN
3592: oe_debug_pub.add('Entering comparing_line_adj_attributes');
3593: oe_debug_pub.add('header' ||p_header_id);
3594: oe_debug_pub.add('adjustment id' ||p_price_adjustment_id);
3595: oe_debug_pub.add('prior version' ||p_prior_version);
3596: oe_debug_pub.add('current version' ||p_current_version);
3597: oe_debug_pub.add('next version' ||p_next_version);
3598: oe_debug_pub.add('max version' ||g_max_version);
3599: oe_debug_pub.add('trans version' ||g_trans_version);

Line 3596: oe_debug_pub.add('current version' ||p_current_version);

3592: oe_debug_pub.add('Entering comparing_line_adj_attributes');
3593: oe_debug_pub.add('header' ||p_header_id);
3594: oe_debug_pub.add('adjustment id' ||p_price_adjustment_id);
3595: oe_debug_pub.add('prior version' ||p_prior_version);
3596: oe_debug_pub.add('current version' ||p_current_version);
3597: oe_debug_pub.add('next version' ||p_next_version);
3598: oe_debug_pub.add('max version' ||g_max_version);
3599: oe_debug_pub.add('trans version' ||g_trans_version);
3600: END IF;

Line 3597: oe_debug_pub.add('next version' ||p_next_version);

3593: oe_debug_pub.add('header' ||p_header_id);
3594: oe_debug_pub.add('adjustment id' ||p_price_adjustment_id);
3595: oe_debug_pub.add('prior version' ||p_prior_version);
3596: oe_debug_pub.add('current version' ||p_current_version);
3597: oe_debug_pub.add('next version' ||p_next_version);
3598: oe_debug_pub.add('max version' ||g_max_version);
3599: oe_debug_pub.add('trans version' ||g_trans_version);
3600: END IF;
3601:

Line 3598: oe_debug_pub.add('max version' ||g_max_version);

3594: oe_debug_pub.add('adjustment id' ||p_price_adjustment_id);
3595: oe_debug_pub.add('prior version' ||p_prior_version);
3596: oe_debug_pub.add('current version' ||p_current_version);
3597: oe_debug_pub.add('next version' ||p_next_version);
3598: oe_debug_pub.add('max version' ||g_max_version);
3599: oe_debug_pub.add('trans version' ||g_trans_version);
3600: END IF;
3601:
3602: if p_total_lines > 0 THEN

Line 3599: oe_debug_pub.add('trans version' ||g_trans_version);

3595: oe_debug_pub.add('prior version' ||p_prior_version);
3596: oe_debug_pub.add('current version' ||p_current_version);
3597: oe_debug_pub.add('next version' ||p_next_version);
3598: oe_debug_pub.add('max version' ||g_max_version);
3599: oe_debug_pub.add('trans version' ||g_trans_version);
3600: END IF;
3601:
3602: if p_total_lines > 0 THEN
3603: IF l_debug_level > 0 THEN

Line 3604: oe_debug_pub.add(' p_total_lines '||p_total_lines);

3600: END IF;
3601:
3602: if p_total_lines > 0 THEN
3603: IF l_debug_level > 0 THEN
3604: oe_debug_pub.add(' p_total_lines '||p_total_lines);
3605: end if;
3606: ind := p_total_lines;
3607: ELSE
3608: ind := 0;

Line 3618: oe_debug_pub.add(' Quering prior line version details');

3614: p_curr_rec := NULL;
3615: p_next_rec := NULL;
3616:
3617: IF l_debug_level > 0 THEN
3618: oe_debug_pub.add(' Quering prior line version details');
3619: oe_debug_pub.add('prior version' ||p_prior_version);
3620: END IF;
3621:
3622: IF p_prior_version IS NOT NULL THEN

Line 3619: oe_debug_pub.add('prior version' ||p_prior_version);

3615: p_next_rec := NULL;
3616:
3617: IF l_debug_level > 0 THEN
3618: oe_debug_pub.add(' Quering prior line version details');
3619: oe_debug_pub.add('prior version' ||p_prior_version);
3620: END IF;
3621:
3622: IF p_prior_version IS NOT NULL THEN
3623: OE_VERSION_PRICE_ADJUST_COMP.QUERY_line_adj_ROW(p_header_id => p_header_id,

Line 3635: oe_debug_pub.add(' Quering current line version details');

3631: p_prior_rec_exists := 'Y';
3632: END IF;
3633: END IF;
3634: IF l_debug_level > 0 THEN
3635: oe_debug_pub.add(' Quering current line version details');
3636: oe_debug_pub.add('current version' ||p_current_version);
3637: END IF;
3638:
3639: IF p_current_version IS NOT NULL THEN

Line 3636: oe_debug_pub.add('current version' ||p_current_version);

3632: END IF;
3633: END IF;
3634: IF l_debug_level > 0 THEN
3635: oe_debug_pub.add(' Quering current line version details');
3636: oe_debug_pub.add('current version' ||p_current_version);
3637: END IF;
3638:
3639: IF p_current_version IS NOT NULL THEN
3640: OE_VERSION_PRICE_ADJUST_COMP.QUERY_line_adj_ROW(p_header_id => p_header_id,

Line 3653: oe_debug_pub.add(' Quering next/trans line version details');

3649: END IF;
3650:
3651: END IF;
3652: IF l_debug_level > 0 THEN
3653: oe_debug_pub.add(' Quering next/trans line version details');
3654: oe_debug_pub.add('next version' ||p_next_version);
3655: oe_debug_pub.add('trans version' ||g_trans_version);
3656: END IF;
3657:

Line 3654: oe_debug_pub.add('next version' ||p_next_version);

3650:
3651: END IF;
3652: IF l_debug_level > 0 THEN
3653: oe_debug_pub.add(' Quering next/trans line version details');
3654: oe_debug_pub.add('next version' ||p_next_version);
3655: oe_debug_pub.add('trans version' ||g_trans_version);
3656: END IF;
3657:
3658: IF p_next_version = g_trans_version then

Line 3655: oe_debug_pub.add('trans version' ||g_trans_version);

3651: END IF;
3652: IF l_debug_level > 0 THEN
3653: oe_debug_pub.add(' Quering next/trans line version details');
3654: oe_debug_pub.add('next version' ||p_next_version);
3655: oe_debug_pub.add('trans version' ||g_trans_version);
3656: END IF;
3657:
3658: IF p_next_version = g_trans_version then
3659: IF g_trans_version is not null then

Line 3687: oe_debug_pub.add(' p_prior_rec list header id'||p_prior_rec.list_header_id);

3683: END IF;
3684: END IF;
3685:
3686: IF l_debug_level > 0 THEN
3687: oe_debug_pub.add(' p_prior_rec list header id'||p_prior_rec.list_header_id);
3688: oe_debug_pub.add(' p_curr_rec '||p_curr_rec.list_header_id);
3689: oe_debug_pub.add(' p_next_rec '||p_next_rec.list_header_id);
3690: oe_debug_pub.add(' checking whether adjustments are same or not');
3691: oe_debug_pub.add(' p_prior_rec_exists'||p_prior_rec_exists);

Line 3688: oe_debug_pub.add(' p_curr_rec '||p_curr_rec.list_header_id);

3684: END IF;
3685:
3686: IF l_debug_level > 0 THEN
3687: oe_debug_pub.add(' p_prior_rec list header id'||p_prior_rec.list_header_id);
3688: oe_debug_pub.add(' p_curr_rec '||p_curr_rec.list_header_id);
3689: oe_debug_pub.add(' p_next_rec '||p_next_rec.list_header_id);
3690: oe_debug_pub.add(' checking whether adjustments are same or not');
3691: oe_debug_pub.add(' p_prior_rec_exists'||p_prior_rec_exists);
3692: oe_debug_pub.add(' p_curr_rec_exists'||p_curr_rec_exists);

Line 3689: oe_debug_pub.add(' p_next_rec '||p_next_rec.list_header_id);

3685:
3686: IF l_debug_level > 0 THEN
3687: oe_debug_pub.add(' p_prior_rec list header id'||p_prior_rec.list_header_id);
3688: oe_debug_pub.add(' p_curr_rec '||p_curr_rec.list_header_id);
3689: oe_debug_pub.add(' p_next_rec '||p_next_rec.list_header_id);
3690: oe_debug_pub.add(' checking whether adjustments are same or not');
3691: oe_debug_pub.add(' p_prior_rec_exists'||p_prior_rec_exists);
3692: oe_debug_pub.add(' p_curr_rec_exists'||p_curr_rec_exists);
3693: oe_debug_pub.add(' p_next_rec_exists'||p_next_rec_exists);

Line 3690: oe_debug_pub.add(' checking whether adjustments are same or not');

3686: IF l_debug_level > 0 THEN
3687: oe_debug_pub.add(' p_prior_rec list header id'||p_prior_rec.list_header_id);
3688: oe_debug_pub.add(' p_curr_rec '||p_curr_rec.list_header_id);
3689: oe_debug_pub.add(' p_next_rec '||p_next_rec.list_header_id);
3690: oe_debug_pub.add(' checking whether adjustments are same or not');
3691: oe_debug_pub.add(' p_prior_rec_exists'||p_prior_rec_exists);
3692: oe_debug_pub.add(' p_curr_rec_exists'||p_curr_rec_exists);
3693: oe_debug_pub.add(' p_next_rec_exists'||p_next_rec_exists);
3694: oe_debug_pub.add(' p_trans_rec_exists'||p_trans_rec_exists);

Line 3691: oe_debug_pub.add(' p_prior_rec_exists'||p_prior_rec_exists);

3687: oe_debug_pub.add(' p_prior_rec list header id'||p_prior_rec.list_header_id);
3688: oe_debug_pub.add(' p_curr_rec '||p_curr_rec.list_header_id);
3689: oe_debug_pub.add(' p_next_rec '||p_next_rec.list_header_id);
3690: oe_debug_pub.add(' checking whether adjustments are same or not');
3691: oe_debug_pub.add(' p_prior_rec_exists'||p_prior_rec_exists);
3692: oe_debug_pub.add(' p_curr_rec_exists'||p_curr_rec_exists);
3693: oe_debug_pub.add(' p_next_rec_exists'||p_next_rec_exists);
3694: oe_debug_pub.add(' p_trans_rec_exists'||p_trans_rec_exists);
3695: END IF;

Line 3692: oe_debug_pub.add(' p_curr_rec_exists'||p_curr_rec_exists);

3688: oe_debug_pub.add(' p_curr_rec '||p_curr_rec.list_header_id);
3689: oe_debug_pub.add(' p_next_rec '||p_next_rec.list_header_id);
3690: oe_debug_pub.add(' checking whether adjustments are same or not');
3691: oe_debug_pub.add(' p_prior_rec_exists'||p_prior_rec_exists);
3692: oe_debug_pub.add(' p_curr_rec_exists'||p_curr_rec_exists);
3693: oe_debug_pub.add(' p_next_rec_exists'||p_next_rec_exists);
3694: oe_debug_pub.add(' p_trans_rec_exists'||p_trans_rec_exists);
3695: END IF;
3696: IF (p_prior_rec_exists = 'Y' and p_curr_rec_exists ='Y') OR

Line 3693: oe_debug_pub.add(' p_next_rec_exists'||p_next_rec_exists);

3689: oe_debug_pub.add(' p_next_rec '||p_next_rec.list_header_id);
3690: oe_debug_pub.add(' checking whether adjustments are same or not');
3691: oe_debug_pub.add(' p_prior_rec_exists'||p_prior_rec_exists);
3692: oe_debug_pub.add(' p_curr_rec_exists'||p_curr_rec_exists);
3693: oe_debug_pub.add(' p_next_rec_exists'||p_next_rec_exists);
3694: oe_debug_pub.add(' p_trans_rec_exists'||p_trans_rec_exists);
3695: END IF;
3696: IF (p_prior_rec_exists = 'Y' and p_curr_rec_exists ='Y') OR
3697: (p_curr_rec_exists = 'Y' and p_next_rec_exists ='Y') THEN

Line 3694: oe_debug_pub.add(' p_trans_rec_exists'||p_trans_rec_exists);

3690: oe_debug_pub.add(' checking whether adjustments are same or not');
3691: oe_debug_pub.add(' p_prior_rec_exists'||p_prior_rec_exists);
3692: oe_debug_pub.add(' p_curr_rec_exists'||p_curr_rec_exists);
3693: oe_debug_pub.add(' p_next_rec_exists'||p_next_rec_exists);
3694: oe_debug_pub.add(' p_trans_rec_exists'||p_trans_rec_exists);
3695: END IF;
3696: IF (p_prior_rec_exists = 'Y' and p_curr_rec_exists ='Y') OR
3697: (p_curr_rec_exists = 'Y' and p_next_rec_exists ='Y') THEN
3698: IF l_debug_level > 0 THEN

Line 3699: oe_debug_pub.add(' both exists - checking if both are same');

3695: END IF;
3696: IF (p_prior_rec_exists = 'Y' and p_curr_rec_exists ='Y') OR
3697: (p_curr_rec_exists = 'Y' and p_next_rec_exists ='Y') THEN
3698: IF l_debug_level > 0 THEN
3699: oe_debug_pub.add(' both exists - checking if both are same');
3700: END IF;
3701: IF OE_Globals.Equal(p_prior_rec.list_header_id,p_curr_rec.list_header_id) OR
3702: OE_Globals.Equal( p_curr_rec.list_header_id, p_next_rec.list_header_id) THEN
3703: /****************************/

Line 6029: oe_debug_pub.add(' before finding new sales credits ');

6025: END IF; /* same list header id */
6026: END IF; /* p and c = Y or c and n=y */
6027:
6028: IF l_debug_level > 0 THEN
6029: oe_debug_pub.add(' before finding new sales credits ');
6030: oe_debug_pub.add(' p_prior_rec_exists'||p_prior_rec_exists);
6031: oe_debug_pub.add(' p_curr_rec_exists'||p_curr_rec_exists);
6032: oe_debug_pub.add(' p_next_rec_exists'||p_next_rec_exists);
6033: oe_debug_pub.add(' p_trans_rec_exists'||p_trans_rec_exists);

Line 6030: oe_debug_pub.add(' p_prior_rec_exists'||p_prior_rec_exists);

6026: END IF; /* p and c = Y or c and n=y */
6027:
6028: IF l_debug_level > 0 THEN
6029: oe_debug_pub.add(' before finding new sales credits ');
6030: oe_debug_pub.add(' p_prior_rec_exists'||p_prior_rec_exists);
6031: oe_debug_pub.add(' p_curr_rec_exists'||p_curr_rec_exists);
6032: oe_debug_pub.add(' p_next_rec_exists'||p_next_rec_exists);
6033: oe_debug_pub.add(' p_trans_rec_exists'||p_trans_rec_exists);
6034: END IF;

Line 6031: oe_debug_pub.add(' p_curr_rec_exists'||p_curr_rec_exists);

6027:
6028: IF l_debug_level > 0 THEN
6029: oe_debug_pub.add(' before finding new sales credits ');
6030: oe_debug_pub.add(' p_prior_rec_exists'||p_prior_rec_exists);
6031: oe_debug_pub.add(' p_curr_rec_exists'||p_curr_rec_exists);
6032: oe_debug_pub.add(' p_next_rec_exists'||p_next_rec_exists);
6033: oe_debug_pub.add(' p_trans_rec_exists'||p_trans_rec_exists);
6034: END IF;
6035: IF (p_prior_rec_exists = 'N' and p_curr_rec_exists = 'Y') OR

Line 6032: oe_debug_pub.add(' p_next_rec_exists'||p_next_rec_exists);

6028: IF l_debug_level > 0 THEN
6029: oe_debug_pub.add(' before finding new sales credits ');
6030: oe_debug_pub.add(' p_prior_rec_exists'||p_prior_rec_exists);
6031: oe_debug_pub.add(' p_curr_rec_exists'||p_curr_rec_exists);
6032: oe_debug_pub.add(' p_next_rec_exists'||p_next_rec_exists);
6033: oe_debug_pub.add(' p_trans_rec_exists'||p_trans_rec_exists);
6034: END IF;
6035: IF (p_prior_rec_exists = 'N' and p_curr_rec_exists = 'Y') OR
6036: (p_curr_rec_exists = 'N' and p_next_rec_exists ='Y') THEN

Line 6033: oe_debug_pub.add(' p_trans_rec_exists'||p_trans_rec_exists);

6029: oe_debug_pub.add(' before finding new sales credits ');
6030: oe_debug_pub.add(' p_prior_rec_exists'||p_prior_rec_exists);
6031: oe_debug_pub.add(' p_curr_rec_exists'||p_curr_rec_exists);
6032: oe_debug_pub.add(' p_next_rec_exists'||p_next_rec_exists);
6033: oe_debug_pub.add(' p_trans_rec_exists'||p_trans_rec_exists);
6034: END IF;
6035: IF (p_prior_rec_exists = 'N' and p_curr_rec_exists = 'Y') OR
6036: (p_curr_rec_exists = 'N' and p_next_rec_exists ='Y') THEN
6037: IF p_prior_version IS NOT NULL and p_curr_rec_exists = 'Y' THEN

Line 6039: oe_debug_pub.add(' Prior is not there - current is there');

6035: IF (p_prior_rec_exists = 'N' and p_curr_rec_exists = 'Y') OR
6036: (p_curr_rec_exists = 'N' and p_next_rec_exists ='Y') THEN
6037: IF p_prior_version IS NOT NULL and p_curr_rec_exists = 'Y' THEN
6038: IF l_debug_level > 0 THEN
6039: oe_debug_pub.add(' Prior is not there - current is there');
6040: END IF;
6041: ind := ind+1;
6042: x_line_adj_changed_attr_tbl(ind).line_number := x_line_number;
6043: x_line_adj_changed_attr_tbl(ind).attribute_value := OE_ID_TO_VALUE.new_modifier_list(p_curr_rec.list_header_id);

Line 6049: oe_debug_pub.add(' Current is not there - next is there');

6045: x_line_adj_changed_attr_tbl(ind).current_value := 'ADD';
6046: x_line_adj_changed_attr_tbl(ind).next_value := null;
6047: ELSIF (p_curr_rec_exists = 'N' and p_next_rec_exists = 'Y') THEN
6048: IF l_debug_level > 0 THEN
6049: oe_debug_pub.add(' Current is not there - next is there');
6050: oe_debug_pub.add(' new mod' ||p_next_rec.list_header_id);
6051: END IF;
6052: ind := ind+1;
6053: x_line_adj_changed_attr_tbl(ind).line_number := x_line_number;

Line 6050: oe_debug_pub.add(' new mod' ||p_next_rec.list_header_id);

6046: x_line_adj_changed_attr_tbl(ind).next_value := null;
6047: ELSIF (p_curr_rec_exists = 'N' and p_next_rec_exists = 'Y') THEN
6048: IF l_debug_level > 0 THEN
6049: oe_debug_pub.add(' Current is not there - next is there');
6050: oe_debug_pub.add(' new mod' ||p_next_rec.list_header_id);
6051: END IF;
6052: ind := ind+1;
6053: x_line_adj_changed_attr_tbl(ind).line_number := x_line_number;
6054: x_line_adj_changed_attr_tbl(ind).attribute_value := OE_ID_TO_VALUE.new_modifier_list(p_next_rec.list_header_id);

Line 6062: oe_debug_pub.add(' before finding deleted new_modifier_list');

6058: end if;
6059: END IF;
6060:
6061: IF l_debug_level > 0 THEN
6062: oe_debug_pub.add(' before finding deleted new_modifier_list');
6063: oe_debug_pub.add(' p_prior_rec_exists'||p_prior_rec_exists);
6064: oe_debug_pub.add(' p_curr_rec_exists'||p_curr_rec_exists);
6065: oe_debug_pub.add(' p_next_rec_exists'||p_next_rec_exists);
6066: oe_debug_pub.add(' p_trans_rec_exists'||p_trans_rec_exists);

Line 6063: oe_debug_pub.add(' p_prior_rec_exists'||p_prior_rec_exists);

6059: END IF;
6060:
6061: IF l_debug_level > 0 THEN
6062: oe_debug_pub.add(' before finding deleted new_modifier_list');
6063: oe_debug_pub.add(' p_prior_rec_exists'||p_prior_rec_exists);
6064: oe_debug_pub.add(' p_curr_rec_exists'||p_curr_rec_exists);
6065: oe_debug_pub.add(' p_next_rec_exists'||p_next_rec_exists);
6066: oe_debug_pub.add(' p_trans_rec_exists'||p_trans_rec_exists);
6067: END IF;

Line 6064: oe_debug_pub.add(' p_curr_rec_exists'||p_curr_rec_exists);

6060:
6061: IF l_debug_level > 0 THEN
6062: oe_debug_pub.add(' before finding deleted new_modifier_list');
6063: oe_debug_pub.add(' p_prior_rec_exists'||p_prior_rec_exists);
6064: oe_debug_pub.add(' p_curr_rec_exists'||p_curr_rec_exists);
6065: oe_debug_pub.add(' p_next_rec_exists'||p_next_rec_exists);
6066: oe_debug_pub.add(' p_trans_rec_exists'||p_trans_rec_exists);
6067: END IF;
6068: IF (p_prior_rec_exists = 'Y' and p_curr_rec_exists = 'N') OR

Line 6065: oe_debug_pub.add(' p_next_rec_exists'||p_next_rec_exists);

6061: IF l_debug_level > 0 THEN
6062: oe_debug_pub.add(' before finding deleted new_modifier_list');
6063: oe_debug_pub.add(' p_prior_rec_exists'||p_prior_rec_exists);
6064: oe_debug_pub.add(' p_curr_rec_exists'||p_curr_rec_exists);
6065: oe_debug_pub.add(' p_next_rec_exists'||p_next_rec_exists);
6066: oe_debug_pub.add(' p_trans_rec_exists'||p_trans_rec_exists);
6067: END IF;
6068: IF (p_prior_rec_exists = 'Y' and p_curr_rec_exists = 'N') OR
6069: (p_curr_rec_exists = 'Y' and p_next_rec_exists ='N') THEN

Line 6066: oe_debug_pub.add(' p_trans_rec_exists'||p_trans_rec_exists);

6062: oe_debug_pub.add(' before finding deleted new_modifier_list');
6063: oe_debug_pub.add(' p_prior_rec_exists'||p_prior_rec_exists);
6064: oe_debug_pub.add(' p_curr_rec_exists'||p_curr_rec_exists);
6065: oe_debug_pub.add(' p_next_rec_exists'||p_next_rec_exists);
6066: oe_debug_pub.add(' p_trans_rec_exists'||p_trans_rec_exists);
6067: END IF;
6068: IF (p_prior_rec_exists = 'Y' and p_curr_rec_exists = 'N') OR
6069: (p_curr_rec_exists = 'Y' and p_next_rec_exists ='N') THEN
6070: IF p_prior_rec_exists = 'Y' and p_curr_rec_exists = 'N' THEN

Line 6072: oe_debug_pub.add(' Prior is there - current is not there');

6068: IF (p_prior_rec_exists = 'Y' and p_curr_rec_exists = 'N') OR
6069: (p_curr_rec_exists = 'Y' and p_next_rec_exists ='N') THEN
6070: IF p_prior_rec_exists = 'Y' and p_curr_rec_exists = 'N' THEN
6071: IF l_debug_level > 0 THEN
6072: oe_debug_pub.add(' Prior is there - current is not there');
6073: END IF;
6074: ind := ind+1;
6075: x_line_adj_changed_attr_tbl(ind).line_number := x_line_number;
6076: x_line_adj_changed_attr_tbl(ind).attribute_value := OE_ID_TO_VALUE.new_modifier_list(p_prior_rec.list_header_id);

Line 6082: oe_debug_pub.add(' p_next_version'||p_next_version);

6078: x_line_adj_changed_attr_tbl(ind).current_value := 'DELETE';
6079: x_line_adj_changed_attr_tbl(ind).next_value := null;
6080: ELSIF p_curr_rec_exists = 'Y' and p_next_rec_exists = 'N' THEN
6081: IF l_debug_level > 0 THEN
6082: oe_debug_pub.add(' p_next_version'||p_next_version);
6083: oe_debug_pub.add(' g_trans_version'||g_trans_version);
6084: END IF;
6085: --if p_next_version != g_trans_version THEN
6086: IF l_debug_level > 0 THEN

Line 6083: oe_debug_pub.add(' g_trans_version'||g_trans_version);

6079: x_line_adj_changed_attr_tbl(ind).next_value := null;
6080: ELSIF p_curr_rec_exists = 'Y' and p_next_rec_exists = 'N' THEN
6081: IF l_debug_level > 0 THEN
6082: oe_debug_pub.add(' p_next_version'||p_next_version);
6083: oe_debug_pub.add(' g_trans_version'||g_trans_version);
6084: END IF;
6085: --if p_next_version != g_trans_version THEN
6086: IF l_debug_level > 0 THEN
6087: oe_debug_pub.add(' Current is there - next is not there');

Line 6087: oe_debug_pub.add(' Current is there - next is not there');

6083: oe_debug_pub.add(' g_trans_version'||g_trans_version);
6084: END IF;
6085: --if p_next_version != g_trans_version THEN
6086: IF l_debug_level > 0 THEN
6087: oe_debug_pub.add(' Current is there - next is not there');
6088: END IF;
6089: ind := ind+1;
6090: x_line_adj_changed_attr_tbl(ind).line_number := x_line_number;
6091: x_line_adj_changed_attr_tbl(ind).attribute_value := OE_ID_TO_VALUE.new_modifier_list(p_curr_rec.list_header_id);

Line 6099: oe_debug_pub.add('BEFORE COMPARING ATTRIBUTES*******');

6095: --end if;
6096: end if;
6097: END IF;
6098: IF l_debug_level > 0 THEN
6099: oe_debug_pub.add('******BEFORE COMPARING ATTRIBUTES*************');
6100: oe_debug_pub.add('current ind '|| ind);
6101: END IF;
6102:
6103: END IF; /* price_adjustment_id not null */

Line 6100: oe_debug_pub.add('current ind '|| ind);

6096: end if;
6097: END IF;
6098: IF l_debug_level > 0 THEN
6099: oe_debug_pub.add('******BEFORE COMPARING ATTRIBUTES*************');
6100: oe_debug_pub.add('current ind '|| ind);
6101: END IF;
6102:
6103: END IF; /* price_adjustment_id not null */
6104: IF l_debug_level > 0 THEN

Line 6105: oe_debug_pub.add('AFTER COMPARING ATTRIBUTES*******');

6101: END IF;
6102:
6103: END IF; /* price_adjustment_id not null */
6104: IF l_debug_level > 0 THEN
6105: oe_debug_pub.add('******AFTER COMPARING ATTRIBUTES*************');
6106: oe_debug_pub.add('current ind '|| ind);
6107: END IF;
6108: IF l_debug_level > 0 THEN
6109: oe_debug_pub.add(' Exiting OE_VERSION_PRICE_ADJUST_COMP.Compare_line_adj_Attributes ');

Line 6106: oe_debug_pub.add('current ind '|| ind);

6102:
6103: END IF; /* price_adjustment_id not null */
6104: IF l_debug_level > 0 THEN
6105: oe_debug_pub.add('******AFTER COMPARING ATTRIBUTES*************');
6106: oe_debug_pub.add('current ind '|| ind);
6107: END IF;
6108: IF l_debug_level > 0 THEN
6109: oe_debug_pub.add(' Exiting OE_VERSION_PRICE_ADJUST_COMP.Compare_line_adj_Attributes ');
6110: END IF;

Line 6109: oe_debug_pub.add(' Exiting OE_VERSION_PRICE_ADJUST_COMP.Compare_line_adj_Attributes ');

6105: oe_debug_pub.add('******AFTER COMPARING ATTRIBUTES*************');
6106: oe_debug_pub.add('current ind '|| ind);
6107: END IF;
6108: IF l_debug_level > 0 THEN
6109: oe_debug_pub.add(' Exiting OE_VERSION_PRICE_ADJUST_COMP.Compare_line_adj_Attributes ');
6110: END IF;
6111: /*
6112: j := 0;
6113: dbms_output.put_line('No of resales dreditcords'||x_line_adj_changed_attr_tbl.count);

Line 6170: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

6166: l_price_adjustment_id NUMBER;
6167: total_lines NUMBER;
6168: l_line_id NUMBER;
6169: x_line_number VARCHAR2(30);
6170: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
6171: BEGIN
6172: IF l_debug_level > 0 THEN
6173: oe_debug_pub.add('Entering Compare_line_adj_versions');
6174: oe_debug_pub.add('header' ||p_header_id);

Line 6173: oe_debug_pub.add('Entering Compare_line_adj_versions');

6169: x_line_number VARCHAR2(30);
6170: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
6171: BEGIN
6172: IF l_debug_level > 0 THEN
6173: oe_debug_pub.add('Entering Compare_line_adj_versions');
6174: oe_debug_pub.add('header' ||p_header_id);
6175: oe_debug_pub.add('prior version' ||p_prior_version);
6176: oe_debug_pub.add('current version' ||p_current_version);
6177: oe_debug_pub.add('next version' ||p_next_version);

Line 6174: oe_debug_pub.add('header' ||p_header_id);

6170: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
6171: BEGIN
6172: IF l_debug_level > 0 THEN
6173: oe_debug_pub.add('Entering Compare_line_adj_versions');
6174: oe_debug_pub.add('header' ||p_header_id);
6175: oe_debug_pub.add('prior version' ||p_prior_version);
6176: oe_debug_pub.add('current version' ||p_current_version);
6177: oe_debug_pub.add('next version' ||p_next_version);
6178: oe_debug_pub.add('max version' ||g_max_version);

Line 6175: oe_debug_pub.add('prior version' ||p_prior_version);

6171: BEGIN
6172: IF l_debug_level > 0 THEN
6173: oe_debug_pub.add('Entering Compare_line_adj_versions');
6174: oe_debug_pub.add('header' ||p_header_id);
6175: oe_debug_pub.add('prior version' ||p_prior_version);
6176: oe_debug_pub.add('current version' ||p_current_version);
6177: oe_debug_pub.add('next version' ||p_next_version);
6178: oe_debug_pub.add('max version' ||g_max_version);
6179: oe_debug_pub.add('trans version' ||g_trans_version);

Line 6176: oe_debug_pub.add('current version' ||p_current_version);

6172: IF l_debug_level > 0 THEN
6173: oe_debug_pub.add('Entering Compare_line_adj_versions');
6174: oe_debug_pub.add('header' ||p_header_id);
6175: oe_debug_pub.add('prior version' ||p_prior_version);
6176: oe_debug_pub.add('current version' ||p_current_version);
6177: oe_debug_pub.add('next version' ||p_next_version);
6178: oe_debug_pub.add('max version' ||g_max_version);
6179: oe_debug_pub.add('trans version' ||g_trans_version);
6180: END IF;

Line 6177: oe_debug_pub.add('next version' ||p_next_version);

6173: oe_debug_pub.add('Entering Compare_line_adj_versions');
6174: oe_debug_pub.add('header' ||p_header_id);
6175: oe_debug_pub.add('prior version' ||p_prior_version);
6176: oe_debug_pub.add('current version' ||p_current_version);
6177: oe_debug_pub.add('next version' ||p_next_version);
6178: oe_debug_pub.add('max version' ||g_max_version);
6179: oe_debug_pub.add('trans version' ||g_trans_version);
6180: END IF;
6181:

Line 6178: oe_debug_pub.add('max version' ||g_max_version);

6174: oe_debug_pub.add('header' ||p_header_id);
6175: oe_debug_pub.add('prior version' ||p_prior_version);
6176: oe_debug_pub.add('current version' ||p_current_version);
6177: oe_debug_pub.add('next version' ||p_next_version);
6178: oe_debug_pub.add('max version' ||g_max_version);
6179: oe_debug_pub.add('trans version' ||g_trans_version);
6180: END IF;
6181:
6182: ind1:=0;

Line 6179: oe_debug_pub.add('trans version' ||g_trans_version);

6175: oe_debug_pub.add('prior version' ||p_prior_version);
6176: oe_debug_pub.add('current version' ||p_current_version);
6177: oe_debug_pub.add('next version' ||p_next_version);
6178: oe_debug_pub.add('max version' ||g_max_version);
6179: oe_debug_pub.add('trans version' ||g_trans_version);
6180: END IF;
6181:
6182: ind1:=0;
6183: total_lines:=0;

Line 6191: oe_debug_pub.add('*adjustments found(trans)******'||l_price_adjustment_id);

6187: LOOP
6188: FETCH C_GET_adjustments INTO l_price_adjustment_id,l_line_id;
6189: EXIT WHEN C_GET_adjustments%NOTFOUND;
6190: IF l_debug_level > 0 THEN
6191: oe_debug_pub.add('*************adjustments found(trans)******************'||l_price_adjustment_id);
6192: oe_debug_pub.add('*************adjustments found(line_id)******************'||l_line_id);
6193: END IF;
6194:
6195: IF l_price_adjustment_id IS NOT NULL THEN

Line 6192: oe_debug_pub.add('*adjustments found(line_id)******'||l_line_id);

6188: FETCH C_GET_adjustments INTO l_price_adjustment_id,l_line_id;
6189: EXIT WHEN C_GET_adjustments%NOTFOUND;
6190: IF l_debug_level > 0 THEN
6191: oe_debug_pub.add('*************adjustments found(trans)******************'||l_price_adjustment_id);
6192: oe_debug_pub.add('*************adjustments found(line_id)******************'||l_line_id);
6193: END IF;
6194:
6195: IF l_price_adjustment_id IS NOT NULL THEN
6196: IF l_debug_level > 0 THEN

Line 6197: oe_debug_pub.add('*before call total adjustments(trans) ******'||ind1);

6193: END IF;
6194:
6195: IF l_price_adjustment_id IS NOT NULL THEN
6196: IF l_debug_level > 0 THEN
6197: oe_debug_pub.add('*************before call total adjustments(trans) ******************'||ind1);
6198: END IF;
6199:
6200: IF l_line_id IS NOT NULL THEN
6201: -- bug 9299752

Line 6232: oe_debug_pub.add('*after call total price adjustments(trans) ******'||ind1);

6228: ind1 := x_line_adj_changed_attr_tbl.count;
6229: -- ind1 := ind1 + total_lines;
6230: END IF;
6231: IF l_debug_level > 0 THEN
6232: oe_debug_pub.add('*************after call total price adjustments(trans) ******************'||ind1);
6233: END IF;
6234: END IF; /* price_adjustment_id is not null */
6235: END LOOP;
6236: CLOSE C_GET_adjustments;

Line 6243: oe_debug_pub.add('*adjustments found******'||l_price_adjustment_id);

6239: LOOP
6240: FETCH C_GET_HIST_adjustments INTO l_price_adjustment_id,l_line_id;
6241: EXIT WHEN C_GET_HIST_adjustments%NOTFOUND;
6242: IF l_debug_level > 0 THEN
6243: oe_debug_pub.add('*************adjustments found******************'||l_price_adjustment_id);
6244: END IF;
6245:
6246: IF l_price_adjustment_id IS NOT NULL THEN
6247: IF l_debug_level > 0 THEN

Line 6248: oe_debug_pub.add('*before call total price adjustments ******'||ind1);

6244: END IF;
6245:
6246: IF l_price_adjustment_id IS NOT NULL THEN
6247: IF l_debug_level > 0 THEN
6248: oe_debug_pub.add('*************before call total price adjustments ******************'||ind1);
6249: END IF;
6250: -- bug 9299752
6251: begin
6252: select oe_order_misc_pub.get_concat_hist_line_number(l_line_id) into x_line_number from dual;

Line 6272: oe_debug_pub.add('*after call total adjustments ******'||ind1);

6268: x_line_adj_changed_attr_tbl => x_line_adj_changed_attr_tbl,
6269: p_total_lines => ind1,
6270: x_line_number => x_line_number);
6271: IF l_debug_level > 0 THEN
6272: oe_debug_pub.add('*************after call total adjustments ******************'||ind1);
6273: END IF;
6274: IF x_line_adj_changed_attr_tbl.count > 0 THEN
6275: ind1 := x_line_adj_changed_attr_tbl.count;
6276: -- ind1 := ind1 + total_lines;

Line 6305: oe_debug_pub.add('Entering get_dff_seg_prompt');

6301: and descriptive_flexfield_name= p_descriptive_flexfield_name
6302: and application_column_name =p_application_column_name
6303: and DESCRIPTIVE_FLEX_CONTEXT_CODE in (p_descriptive_flex_context_cod, p_desc_flex_context_cod_prior, p_desc_flex_context_cod_next, 'Global Data Elements');
6304: BEGIN
6305: oe_debug_pub.add('Entering get_dff_seg_prompt');
6306: fnd_message.set_name('ONT','ONT_SLASH_SEPARATOR');
6307: slash:=FND_MESSAGE.GET;
6308:
6309: IF p_application_column_name = 'CONTEXT' THEN --Context Prompt

Line 6314: oe_debug_pub.add('Context Prompt='||l_prompt);

6310: select FORM_CONTEXT_PROMPT into l_prompt from FND_DESCRIPTIVE_FLEXS_VL
6311: where APPLICATION_ID = p_application_id
6312: and DESCRIPTIVE_FLEXFIELD_NAME = p_descriptive_flexfield_name;
6313:
6314: oe_debug_pub.add('Context Prompt='||l_prompt);
6315: ELSE --Attribute Prompt
6316: IF p_descriptive_flex_context_cod IS NULL
6317: AND p_desc_flex_context_cod_prior IS NULL
6318: AND p_desc_flex_context_cod_next IS NULL THEN

Line 6323: oe_debug_pub.add('Prompt='||l_prompt);

6319: select form_left_prompt into l_prompt from fnd_descr_flex_col_usage_vl where application_id=660
6320: and descriptive_flexfield_name= p_descriptive_flexfield_name
6321: and application_column_name =p_application_column_name;
6322:
6323: oe_debug_pub.add('Prompt='||l_prompt);
6324: ELSE --Context has been passed
6325: OPEN c1;
6326: LOOP
6327: FETCH c1 into l_prompt;

Line 6336: oe_debug_pub.add('Prompt='||x_prompt);

6332: x_prompt:=x_prompt||slash||l_prompt;
6333: END IF;
6334: END LOOP;
6335: CLOSE C1;
6336: oe_debug_pub.add('Prompt='||x_prompt);
6337: RETURN(x_prompt);
6338: END IF; --Context been passed
6339: END IF; --Context/Attribute Prompt
6340: RETURN(l_prompt);

Line 6345: oe_debug_pub.add('error is'||SQLCODE||'message'||SQLERRM);

6341: EXCEPTION
6342: WHEN no_data_found THEN
6343: Return null;
6344: WHEN OTHERS THEN
6345: oe_debug_pub.add('error is'||SQLCODE||'message'||SQLERRM);
6346: Return NULL;
6347: END get_dff_seg_prompt;
6348: --bug 4302049
6349: