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_BLANKET_COMP dependencies on OE_DEBUG_PUB

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

7: p_phase_change_flag VARCHAR2,
8: x_header_rec IN OUT NOCOPY OE_Blanket_PUB.Header_Rec_Type)
9: IS
10: l_org_id NUMBER;
11: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
12: BEGIN
13: oe_debug_pub.add('l_debug_level'||l_debug_level );
14: IF l_debug_level > 0 THEN
15: oe_debug_pub.add('Entering OE_VERSION_BLANKET_COMP.QUERY_HEADER_ROW'||p_version );

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

9: IS
10: l_org_id NUMBER;
11: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
12: BEGIN
13: oe_debug_pub.add('l_debug_level'||l_debug_level );
14: IF l_debug_level > 0 THEN
15: oe_debug_pub.add('Entering OE_VERSION_BLANKET_COMP.QUERY_HEADER_ROW'||p_version );
16: oe_debug_pub.add('header' ||p_header_id);
17: oe_debug_pub.add('version' ||p_version);

Line 15: oe_debug_pub.add('Entering OE_VERSION_BLANKET_COMP.QUERY_HEADER_ROW'||p_version );

11: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
12: BEGIN
13: oe_debug_pub.add('l_debug_level'||l_debug_level );
14: IF l_debug_level > 0 THEN
15: oe_debug_pub.add('Entering OE_VERSION_BLANKET_COMP.QUERY_HEADER_ROW'||p_version );
16: oe_debug_pub.add('header' ||p_header_id);
17: oe_debug_pub.add('version' ||p_version);
18: oe_debug_pub.add('phase_change_flag' ||p_phase_change_flag);
19: END IF;

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

12: BEGIN
13: oe_debug_pub.add('l_debug_level'||l_debug_level );
14: IF l_debug_level > 0 THEN
15: oe_debug_pub.add('Entering OE_VERSION_BLANKET_COMP.QUERY_HEADER_ROW'||p_version );
16: oe_debug_pub.add('header' ||p_header_id);
17: oe_debug_pub.add('version' ||p_version);
18: oe_debug_pub.add('phase_change_flag' ||p_phase_change_flag);
19: END IF;
20: l_org_id := OE_GLOBALS.G_ORG_ID;

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

13: oe_debug_pub.add('l_debug_level'||l_debug_level );
14: IF l_debug_level > 0 THEN
15: oe_debug_pub.add('Entering OE_VERSION_BLANKET_COMP.QUERY_HEADER_ROW'||p_version );
16: oe_debug_pub.add('header' ||p_header_id);
17: oe_debug_pub.add('version' ||p_version);
18: oe_debug_pub.add('phase_change_flag' ||p_phase_change_flag);
19: END IF;
20: l_org_id := OE_GLOBALS.G_ORG_ID;
21:

Line 18: oe_debug_pub.add('phase_change_flag' ||p_phase_change_flag);

14: IF l_debug_level > 0 THEN
15: oe_debug_pub.add('Entering OE_VERSION_BLANKET_COMP.QUERY_HEADER_ROW'||p_version );
16: oe_debug_pub.add('header' ||p_header_id);
17: oe_debug_pub.add('version' ||p_version);
18: oe_debug_pub.add('phase_change_flag' ||p_phase_change_flag);
19: END IF;
20: l_org_id := OE_GLOBALS.G_ORG_ID;
21:
22: IF l_org_id IS NULL THEN

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

232: p_version NUMBER,
233: x_header_rec IN OUT NOCOPY OE_Blanket_PUB.Header_Rec_Type)
234: IS
235: l_org_id NUMBER;
236: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
237: BEGIN
238:
239: IF l_debug_level > 0 THEN
240: oe_debug_pub.add('Entering OE_BLKT_VERSION_COMPARISION.QUERY_HEADER_TRANS_ROW');

Line 240: oe_debug_pub.add('Entering OE_BLKT_VERSION_COMPARISION.QUERY_HEADER_TRANS_ROW');

236: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
237: BEGIN
238:
239: IF l_debug_level > 0 THEN
240: oe_debug_pub.add('Entering OE_BLKT_VERSION_COMPARISION.QUERY_HEADER_TRANS_ROW');
241: oe_debug_pub.add('header' ||p_header_id);
242: oe_debug_pub.add('version' ||p_version);
243: END IF;
244: l_org_id := OE_GLOBALS.G_ORG_ID;

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

237: BEGIN
238:
239: IF l_debug_level > 0 THEN
240: oe_debug_pub.add('Entering OE_BLKT_VERSION_COMPARISION.QUERY_HEADER_TRANS_ROW');
241: oe_debug_pub.add('header' ||p_header_id);
242: oe_debug_pub.add('version' ||p_version);
243: END IF;
244: l_org_id := OE_GLOBALS.G_ORG_ID;
245:

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

238:
239: IF l_debug_level > 0 THEN
240: oe_debug_pub.add('Entering OE_BLKT_VERSION_COMPARISION.QUERY_HEADER_TRANS_ROW');
241: oe_debug_pub.add('header' ||p_header_id);
242: oe_debug_pub.add('version' ||p_version);
243: END IF;
244: l_org_id := OE_GLOBALS.G_ORG_ID;
245:
246: IF l_org_id IS NULL THEN

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

539: x_sold_to_location_country VARCHAR2(240);
540: x_prior_sold_to_location VARCHAR2(2000);
541: x_current_sold_to_location VARCHAR2(2000);
542: x_next_sold_to_location VARCHAR2(2000);
543: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
544: BEGIN
545:
546: IF l_debug_level > 0 THEN
547: oe_debug_pub.add('Entering COMPARE_HEADER_VERSIONS');

Line 547: oe_debug_pub.add('Entering COMPARE_HEADER_VERSIONS');

543: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
544: BEGIN
545:
546: IF l_debug_level > 0 THEN
547: oe_debug_pub.add('Entering COMPARE_HEADER_VERSIONS');
548: oe_debug_pub.add('header' ||p_header_id);
549: oe_debug_pub.add('prior version' ||p_prior_version);
550: oe_debug_pub.add('current version' ||p_current_version);
551: oe_debug_pub.add('next version' ||p_next_version);

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

544: BEGIN
545:
546: IF l_debug_level > 0 THEN
547: oe_debug_pub.add('Entering COMPARE_HEADER_VERSIONS');
548: oe_debug_pub.add('header' ||p_header_id);
549: oe_debug_pub.add('prior version' ||p_prior_version);
550: oe_debug_pub.add('current version' ||p_current_version);
551: oe_debug_pub.add('next version' ||p_next_version);
552: oe_debug_pub.add('max version' ||g_max_version);

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

545:
546: IF l_debug_level > 0 THEN
547: oe_debug_pub.add('Entering COMPARE_HEADER_VERSIONS');
548: oe_debug_pub.add('header' ||p_header_id);
549: oe_debug_pub.add('prior version' ||p_prior_version);
550: oe_debug_pub.add('current version' ||p_current_version);
551: oe_debug_pub.add('next version' ||p_next_version);
552: oe_debug_pub.add('max version' ||g_max_version);
553: oe_debug_pub.add('trans version' ||g_trans_version);

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

546: IF l_debug_level > 0 THEN
547: oe_debug_pub.add('Entering COMPARE_HEADER_VERSIONS');
548: oe_debug_pub.add('header' ||p_header_id);
549: oe_debug_pub.add('prior version' ||p_prior_version);
550: oe_debug_pub.add('current version' ||p_current_version);
551: oe_debug_pub.add('next version' ||p_next_version);
552: oe_debug_pub.add('max version' ||g_max_version);
553: oe_debug_pub.add('trans version' ||g_trans_version);
554: oe_debug_pub.add('prior phase chagne' ||g_prior_phase_change_flag);

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

547: oe_debug_pub.add('Entering COMPARE_HEADER_VERSIONS');
548: oe_debug_pub.add('header' ||p_header_id);
549: oe_debug_pub.add('prior version' ||p_prior_version);
550: oe_debug_pub.add('current version' ||p_current_version);
551: oe_debug_pub.add('next version' ||p_next_version);
552: oe_debug_pub.add('max version' ||g_max_version);
553: oe_debug_pub.add('trans version' ||g_trans_version);
554: oe_debug_pub.add('prior phase chagne' ||g_prior_phase_change_flag);
555: oe_debug_pub.add('curr phase chagne' ||g_curr_phase_change_flag);

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

548: oe_debug_pub.add('header' ||p_header_id);
549: oe_debug_pub.add('prior version' ||p_prior_version);
550: oe_debug_pub.add('current version' ||p_current_version);
551: oe_debug_pub.add('next version' ||p_next_version);
552: oe_debug_pub.add('max version' ||g_max_version);
553: oe_debug_pub.add('trans version' ||g_trans_version);
554: oe_debug_pub.add('prior phase chagne' ||g_prior_phase_change_flag);
555: oe_debug_pub.add('curr phase chagne' ||g_curr_phase_change_flag);
556: oe_debug_pub.add('next phase chagne' ||g_next_phase_change_flag);

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

549: oe_debug_pub.add('prior version' ||p_prior_version);
550: oe_debug_pub.add('current version' ||p_current_version);
551: oe_debug_pub.add('next version' ||p_next_version);
552: oe_debug_pub.add('max version' ||g_max_version);
553: oe_debug_pub.add('trans version' ||g_trans_version);
554: oe_debug_pub.add('prior phase chagne' ||g_prior_phase_change_flag);
555: oe_debug_pub.add('curr phase chagne' ||g_curr_phase_change_flag);
556: oe_debug_pub.add('next phase chagne' ||g_next_phase_change_flag);
557: END IF;

Line 554: oe_debug_pub.add('prior phase chagne' ||g_prior_phase_change_flag);

550: oe_debug_pub.add('current version' ||p_current_version);
551: oe_debug_pub.add('next version' ||p_next_version);
552: oe_debug_pub.add('max version' ||g_max_version);
553: oe_debug_pub.add('trans version' ||g_trans_version);
554: oe_debug_pub.add('prior phase chagne' ||g_prior_phase_change_flag);
555: oe_debug_pub.add('curr phase chagne' ||g_curr_phase_change_flag);
556: oe_debug_pub.add('next phase chagne' ||g_next_phase_change_flag);
557: END IF;
558:

Line 555: oe_debug_pub.add('curr phase chagne' ||g_curr_phase_change_flag);

551: oe_debug_pub.add('next version' ||p_next_version);
552: oe_debug_pub.add('max version' ||g_max_version);
553: oe_debug_pub.add('trans version' ||g_trans_version);
554: oe_debug_pub.add('prior phase chagne' ||g_prior_phase_change_flag);
555: oe_debug_pub.add('curr phase chagne' ||g_curr_phase_change_flag);
556: oe_debug_pub.add('next phase chagne' ||g_next_phase_change_flag);
557: END IF;
558:
559: IF l_debug_level > 0 THEN

Line 556: oe_debug_pub.add('next phase chagne' ||g_next_phase_change_flag);

552: oe_debug_pub.add('max version' ||g_max_version);
553: oe_debug_pub.add('trans version' ||g_trans_version);
554: oe_debug_pub.add('prior phase chagne' ||g_prior_phase_change_flag);
555: oe_debug_pub.add('curr phase chagne' ||g_curr_phase_change_flag);
556: oe_debug_pub.add('next phase chagne' ||g_next_phase_change_flag);
557: END IF;
558:
559: IF l_debug_level > 0 THEN
560: oe_debug_pub.add(' Querying prior version details');

Line 560: oe_debug_pub.add(' Querying prior version details');

556: oe_debug_pub.add('next phase chagne' ||g_next_phase_change_flag);
557: END IF;
558:
559: IF l_debug_level > 0 THEN
560: oe_debug_pub.add(' Querying prior version details');
561: oe_debug_pub.add('prior_versio' ||p_prior_version);
562: END IF;
563: IF p_prior_version IS NOT NULL THEN
564: OE_VERSION_BLANKET_COMP.QUERY_HEADER_ROW(p_header_id => p_header_id,

Line 561: oe_debug_pub.add('prior_versio' ||p_prior_version);

557: END IF;
558:
559: IF l_debug_level > 0 THEN
560: oe_debug_pub.add(' Querying prior version details');
561: oe_debug_pub.add('prior_versio' ||p_prior_version);
562: END IF;
563: IF p_prior_version IS NOT NULL THEN
564: OE_VERSION_BLANKET_COMP.QUERY_HEADER_ROW(p_header_id => p_header_id,
565: p_version => p_prior_version,

Line 570: oe_debug_pub.add(' Querying current version details');

566: p_phase_change_flag => g_prior_phase_change_flag,
567: x_header_rec => p_prior_rec);
568: END IF;
569: IF l_debug_level > 0 THEN
570: oe_debug_pub.add(' Querying current version details');
571: oe_debug_pub.add('current_versio' ||p_current_version);
572: END IF;
573: IF p_current_version IS NOT NULL THEN
574: OE_VERSION_BLANKET_COMP.QUERY_HEADER_ROW(p_header_id => p_header_id,

Line 571: oe_debug_pub.add('current_versio' ||p_current_version);

567: x_header_rec => p_prior_rec);
568: END IF;
569: IF l_debug_level > 0 THEN
570: oe_debug_pub.add(' Querying current version details');
571: oe_debug_pub.add('current_versio' ||p_current_version);
572: END IF;
573: IF p_current_version IS NOT NULL THEN
574: OE_VERSION_BLANKET_COMP.QUERY_HEADER_ROW(p_header_id => p_header_id,
575: p_version => p_current_version,

Line 580: oe_debug_pub.add(' Querying next/trans version details');

576: p_phase_change_flag => g_curr_phase_change_flag,
577: x_header_rec => p_curr_rec);
578: END IF;
579: IF l_debug_level > 0 THEN
580: oe_debug_pub.add(' Querying next/trans version details');
581: oe_debug_pub.add('next_version' ||p_next_version);
582: oe_debug_pub.add('trans_version' ||g_trans_version);
583: END IF;
584: IF p_next_version = g_trans_version then

Line 581: oe_debug_pub.add('next_version' ||p_next_version);

577: x_header_rec => p_curr_rec);
578: END IF;
579: IF l_debug_level > 0 THEN
580: oe_debug_pub.add(' Querying next/trans version details');
581: oe_debug_pub.add('next_version' ||p_next_version);
582: oe_debug_pub.add('trans_version' ||g_trans_version);
583: END IF;
584: IF p_next_version = g_trans_version then
585: IF g_trans_version is not null then

Line 582: oe_debug_pub.add('trans_version' ||g_trans_version);

578: END IF;
579: IF l_debug_level > 0 THEN
580: oe_debug_pub.add(' Querying next/trans version details');
581: oe_debug_pub.add('next_version' ||p_next_version);
582: oe_debug_pub.add('trans_version' ||g_trans_version);
583: END IF;
584: IF p_next_version = g_trans_version then
585: IF g_trans_version is not null then
586: OE_VERSION_BLANKET_COMP.QUERY_HEADER_TRANS_ROW(p_header_id => p_header_id,

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

602: */
603: IF v_totcol > 0 THEN
604: ind:=0;
605: IF l_debug_level > 0 THEN
606: oe_debug_pub.add('******BEFORE COMPARING HEADER ATTRIBUTES*************');
607: oe_debug_pub.add('current ind '|| ind);
608: END IF;
609:
610: /****************************/

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

603: IF v_totcol > 0 THEN
604: ind:=0;
605: IF l_debug_level > 0 THEN
606: oe_debug_pub.add('******BEFORE COMPARING HEADER ATTRIBUTES*************');
607: oe_debug_pub.add('current ind '|| ind);
608: END IF;
609:
610: /****************************/
611: /* START ACCOUNTING_RULE_ID*/

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

4022: || ' Next '||x_header_changed_attr_tbl(j).next_value);
4023: END LOOP;
4024: */
4025: IF l_debug_level > 0 THEN
4026: oe_debug_pub.add('******AFTER COMPARING HEADER ATTRIBUTES*************');
4027: oe_debug_pub.add('current ind '|| ind);
4028: END IF;
4029: END COMPARE_HEADER_VERSIONS;
4030:

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

4023: END LOOP;
4024: */
4025: IF l_debug_level > 0 THEN
4026: oe_debug_pub.add('******AFTER COMPARING HEADER ATTRIBUTES*************');
4027: oe_debug_pub.add('current ind '|| ind);
4028: END IF;
4029: END COMPARE_HEADER_VERSIONS;
4030:
4031: PROCEDURE QUERY_LINE_ROW

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

4035: p_phase_change_flag VARCHAR2,
4036: x_line_rec IN OUT NOCOPY OE_Blanket_PUB.line_rec_type)
4037: IS
4038: l_org_id NUMBER;
4039: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
4040: BEGIN
4041: IF l_debug_level > 0 THEN
4042: oe_debug_pub.add('Entering OE_VERSION_BLANKET_COMP.QUERY_LINE_ROW');
4043: oe_debug_pub.add('header' ||p_header_id);

Line 4042: oe_debug_pub.add('Entering OE_VERSION_BLANKET_COMP.QUERY_LINE_ROW');

4038: l_org_id NUMBER;
4039: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
4040: BEGIN
4041: IF l_debug_level > 0 THEN
4042: oe_debug_pub.add('Entering OE_VERSION_BLANKET_COMP.QUERY_LINE_ROW');
4043: oe_debug_pub.add('header' ||p_header_id);
4044: oe_debug_pub.add('version' ||p_version);
4045: oe_debug_pub.add('phase_change_lfag' ||p_phase_change_flag);
4046: END IF;

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

4039: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
4040: BEGIN
4041: IF l_debug_level > 0 THEN
4042: oe_debug_pub.add('Entering OE_VERSION_BLANKET_COMP.QUERY_LINE_ROW');
4043: oe_debug_pub.add('header' ||p_header_id);
4044: oe_debug_pub.add('version' ||p_version);
4045: oe_debug_pub.add('phase_change_lfag' ||p_phase_change_flag);
4046: END IF;
4047:

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

4040: BEGIN
4041: IF l_debug_level > 0 THEN
4042: oe_debug_pub.add('Entering OE_VERSION_BLANKET_COMP.QUERY_LINE_ROW');
4043: oe_debug_pub.add('header' ||p_header_id);
4044: oe_debug_pub.add('version' ||p_version);
4045: oe_debug_pub.add('phase_change_lfag' ||p_phase_change_flag);
4046: END IF;
4047:
4048: l_org_id := OE_GLOBALS.G_ORG_ID;

Line 4045: oe_debug_pub.add('phase_change_lfag' ||p_phase_change_flag);

4041: IF l_debug_level > 0 THEN
4042: oe_debug_pub.add('Entering OE_VERSION_BLANKET_COMP.QUERY_LINE_ROW');
4043: oe_debug_pub.add('header' ||p_header_id);
4044: oe_debug_pub.add('version' ||p_version);
4045: oe_debug_pub.add('phase_change_lfag' ||p_phase_change_flag);
4046: END IF;
4047:
4048: l_org_id := OE_GLOBALS.G_ORG_ID;
4049:

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

4245: p_version NUMBER,
4246: x_line_rec IN OUT NOCOPY OE_Blanket_PUB.line_rec_type)
4247: IS
4248: l_org_id NUMBER;
4249: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
4250: BEGIN
4251: IF l_debug_level > 0 THEN
4252: oe_debug_pub.add('Entering OE_VERSION_BLANKET_COMP.QUERY_LINE_TRANS_ROW', 1);
4253: oe_debug_pub.add('header' ||p_header_id);

Line 4252: oe_debug_pub.add('Entering OE_VERSION_BLANKET_COMP.QUERY_LINE_TRANS_ROW', 1);

4248: l_org_id NUMBER;
4249: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
4250: BEGIN
4251: IF l_debug_level > 0 THEN
4252: oe_debug_pub.add('Entering OE_VERSION_BLANKET_COMP.QUERY_LINE_TRANS_ROW', 1);
4253: oe_debug_pub.add('header' ||p_header_id);
4254: oe_debug_pub.add('version' ||p_version);
4255: END IF;
4256:

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

4249: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
4250: BEGIN
4251: IF l_debug_level > 0 THEN
4252: oe_debug_pub.add('Entering OE_VERSION_BLANKET_COMP.QUERY_LINE_TRANS_ROW', 1);
4253: oe_debug_pub.add('header' ||p_header_id);
4254: oe_debug_pub.add('version' ||p_version);
4255: END IF;
4256:
4257: l_org_id := OE_GLOBALS.G_ORG_ID;

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

4250: BEGIN
4251: IF l_debug_level > 0 THEN
4252: oe_debug_pub.add('Entering OE_VERSION_BLANKET_COMP.QUERY_LINE_TRANS_ROW', 1);
4253: oe_debug_pub.add('header' ||p_header_id);
4254: oe_debug_pub.add('version' ||p_version);
4255: END IF;
4256:
4257: l_org_id := OE_GLOBALS.G_ORG_ID;
4258:

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

4528: x_intermed_ship_to_state VARCHAR2(240);
4529: x_intermed_ship_to_postal_code VARCHAR2(240);
4530: x_intermed_ship_to_country VARCHAR2(240);
4531: x_item_relationship_type VARCHAR2(240);
4532: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
4533: p_prior_rec_exists VARCHAR2(1) := 'N';
4534: p_curr_rec_exists VARCHAR2(1) := 'N';
4535: p_next_rec_exists VARCHAR2(1) := 'N';
4536: p_trans_rec_exists VARCHAR2(1) := 'N';

Line 4541: oe_debug_pub.add('Entering COMPARE_ATTRIBUTES');

4537: ind NUMBER;
4538: BEGIN
4539:
4540: IF l_debug_level > 0 THEN
4541: oe_debug_pub.add('Entering COMPARE_ATTRIBUTES');
4542: oe_debug_pub.add('header' ||p_header_id);
4543: oe_debug_pub.add('line' ||p_line_id);
4544: oe_debug_pub.add('line number' ||x_line_number);
4545: oe_debug_pub.add('prior version' ||p_prior_version);

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

4538: BEGIN
4539:
4540: IF l_debug_level > 0 THEN
4541: oe_debug_pub.add('Entering COMPARE_ATTRIBUTES');
4542: oe_debug_pub.add('header' ||p_header_id);
4543: oe_debug_pub.add('line' ||p_line_id);
4544: oe_debug_pub.add('line number' ||x_line_number);
4545: oe_debug_pub.add('prior version' ||p_prior_version);
4546: oe_debug_pub.add('current version' ||p_current_version);

Line 4543: oe_debug_pub.add('line' ||p_line_id);

4539:
4540: IF l_debug_level > 0 THEN
4541: oe_debug_pub.add('Entering COMPARE_ATTRIBUTES');
4542: oe_debug_pub.add('header' ||p_header_id);
4543: oe_debug_pub.add('line' ||p_line_id);
4544: oe_debug_pub.add('line number' ||x_line_number);
4545: oe_debug_pub.add('prior version' ||p_prior_version);
4546: oe_debug_pub.add('current version' ||p_current_version);
4547: oe_debug_pub.add('next version' ||p_next_version);

Line 4544: oe_debug_pub.add('line number' ||x_line_number);

4540: IF l_debug_level > 0 THEN
4541: oe_debug_pub.add('Entering COMPARE_ATTRIBUTES');
4542: oe_debug_pub.add('header' ||p_header_id);
4543: oe_debug_pub.add('line' ||p_line_id);
4544: oe_debug_pub.add('line number' ||x_line_number);
4545: oe_debug_pub.add('prior version' ||p_prior_version);
4546: oe_debug_pub.add('current version' ||p_current_version);
4547: oe_debug_pub.add('next version' ||p_next_version);
4548: oe_debug_pub.add('max version' ||g_max_version);

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

4541: oe_debug_pub.add('Entering COMPARE_ATTRIBUTES');
4542: oe_debug_pub.add('header' ||p_header_id);
4543: oe_debug_pub.add('line' ||p_line_id);
4544: oe_debug_pub.add('line number' ||x_line_number);
4545: oe_debug_pub.add('prior version' ||p_prior_version);
4546: oe_debug_pub.add('current version' ||p_current_version);
4547: oe_debug_pub.add('next version' ||p_next_version);
4548: oe_debug_pub.add('max version' ||g_max_version);
4549: oe_debug_pub.add('trans version' ||g_trans_version);

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

4542: oe_debug_pub.add('header' ||p_header_id);
4543: oe_debug_pub.add('line' ||p_line_id);
4544: oe_debug_pub.add('line number' ||x_line_number);
4545: oe_debug_pub.add('prior version' ||p_prior_version);
4546: oe_debug_pub.add('current version' ||p_current_version);
4547: oe_debug_pub.add('next version' ||p_next_version);
4548: oe_debug_pub.add('max version' ||g_max_version);
4549: oe_debug_pub.add('trans version' ||g_trans_version);
4550: END IF;

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

4543: oe_debug_pub.add('line' ||p_line_id);
4544: oe_debug_pub.add('line number' ||x_line_number);
4545: oe_debug_pub.add('prior version' ||p_prior_version);
4546: oe_debug_pub.add('current version' ||p_current_version);
4547: oe_debug_pub.add('next version' ||p_next_version);
4548: oe_debug_pub.add('max version' ||g_max_version);
4549: oe_debug_pub.add('trans version' ||g_trans_version);
4550: END IF;
4551:

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

4544: oe_debug_pub.add('line number' ||x_line_number);
4545: oe_debug_pub.add('prior version' ||p_prior_version);
4546: oe_debug_pub.add('current version' ||p_current_version);
4547: oe_debug_pub.add('next version' ||p_next_version);
4548: oe_debug_pub.add('max version' ||g_max_version);
4549: oe_debug_pub.add('trans version' ||g_trans_version);
4550: END IF;
4551:
4552: if p_total_lines > 0 THEN

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

4545: oe_debug_pub.add('prior version' ||p_prior_version);
4546: oe_debug_pub.add('current version' ||p_current_version);
4547: oe_debug_pub.add('next version' ||p_next_version);
4548: oe_debug_pub.add('max version' ||g_max_version);
4549: oe_debug_pub.add('trans version' ||g_trans_version);
4550: END IF;
4551:
4552: if p_total_lines > 0 THEN
4553: IF l_debug_level > 0 THEN

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

4550: END IF;
4551:
4552: if p_total_lines > 0 THEN
4553: IF l_debug_level > 0 THEN
4554: oe_debug_pub.add(' p_total_lines '||p_total_lines);
4555: end if;
4556: ind := p_total_lines;
4557: ELSE
4558: ind := 0;

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

4564: p_curr_rec := NULL;
4565: p_next_rec := NULL;
4566:
4567: IF l_debug_level > 0 THEN
4568: oe_debug_pub.add(' Quering prior line version details');
4569: oe_debug_pub.add('prior version' ||p_prior_version);
4570: END IF;
4571:
4572: IF p_prior_version IS NOT NULL THEN

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

4565: p_next_rec := NULL;
4566:
4567: IF l_debug_level > 0 THEN
4568: oe_debug_pub.add(' Quering prior line version details');
4569: oe_debug_pub.add('prior version' ||p_prior_version);
4570: END IF;
4571:
4572: IF p_prior_version IS NOT NULL THEN
4573: OE_VERSION_BLANKET_COMP.QUERY_LINE_ROW(p_header_id => p_header_id,

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

4581: p_prior_rec_exists := 'Y';
4582: END IF;
4583: END IF;
4584: IF l_debug_level > 0 THEN
4585: oe_debug_pub.add(' Quering current line version details');
4586: oe_debug_pub.add('current version' ||p_current_version);
4587: END IF;
4588:
4589: IF p_current_version IS NOT NULL THEN

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

4582: END IF;
4583: END IF;
4584: IF l_debug_level > 0 THEN
4585: oe_debug_pub.add(' Quering current line version details');
4586: oe_debug_pub.add('current version' ||p_current_version);
4587: END IF;
4588:
4589: IF p_current_version IS NOT NULL THEN
4590: OE_VERSION_BLANKET_COMP.QUERY_LINE_ROW(p_header_id => p_header_id,

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

4600:
4601: END IF;
4602:
4603: IF l_debug_level > 0 THEN
4604: oe_debug_pub.add(' Quering next/trans line version details');
4605: oe_debug_pub.add('next version' ||p_next_version);
4606: oe_debug_pub.add('trans version' ||g_trans_version);
4607: END IF;
4608:

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

4601: END IF;
4602:
4603: IF l_debug_level > 0 THEN
4604: oe_debug_pub.add(' Quering next/trans line version details');
4605: oe_debug_pub.add('next version' ||p_next_version);
4606: oe_debug_pub.add('trans version' ||g_trans_version);
4607: END IF;
4608:
4609: IF p_next_version = g_trans_version then

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

4602:
4603: IF l_debug_level > 0 THEN
4604: oe_debug_pub.add(' Quering next/trans line version details');
4605: oe_debug_pub.add('next version' ||p_next_version);
4606: oe_debug_pub.add('trans version' ||g_trans_version);
4607: END IF;
4608:
4609: IF p_next_version = g_trans_version then
4610: IF g_trans_version is not null then

Line 4638: oe_debug_pub.add(' before finding new lines ');

4634: END IF;
4635: END IF;
4636: END IF;
4637: IF l_debug_level > 0 THEN
4638: oe_debug_pub.add(' before finding new lines ');
4639: oe_debug_pub.add(' p_prior_rec_exists'||p_prior_rec_exists);
4640: oe_debug_pub.add(' p_curr_rec_exists'||p_curr_rec_exists);
4641: oe_debug_pub.add(' p_next_rec_exists'||p_next_rec_exists);
4642: oe_debug_pub.add(' p_trans_rec_exists'||p_trans_rec_exists);

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

4635: END IF;
4636: END IF;
4637: IF l_debug_level > 0 THEN
4638: oe_debug_pub.add(' before finding new lines ');
4639: oe_debug_pub.add(' p_prior_rec_exists'||p_prior_rec_exists);
4640: oe_debug_pub.add(' p_curr_rec_exists'||p_curr_rec_exists);
4641: oe_debug_pub.add(' p_next_rec_exists'||p_next_rec_exists);
4642: oe_debug_pub.add(' p_trans_rec_exists'||p_trans_rec_exists);
4643: END IF;

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

4636: END IF;
4637: IF l_debug_level > 0 THEN
4638: oe_debug_pub.add(' before finding new lines ');
4639: oe_debug_pub.add(' p_prior_rec_exists'||p_prior_rec_exists);
4640: oe_debug_pub.add(' p_curr_rec_exists'||p_curr_rec_exists);
4641: oe_debug_pub.add(' p_next_rec_exists'||p_next_rec_exists);
4642: oe_debug_pub.add(' p_trans_rec_exists'||p_trans_rec_exists);
4643: END IF;
4644: IF (p_prior_rec_exists = 'N' and p_curr_rec_exists = 'Y') OR

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

4637: IF l_debug_level > 0 THEN
4638: oe_debug_pub.add(' before finding new lines ');
4639: oe_debug_pub.add(' p_prior_rec_exists'||p_prior_rec_exists);
4640: oe_debug_pub.add(' p_curr_rec_exists'||p_curr_rec_exists);
4641: oe_debug_pub.add(' p_next_rec_exists'||p_next_rec_exists);
4642: oe_debug_pub.add(' p_trans_rec_exists'||p_trans_rec_exists);
4643: END IF;
4644: IF (p_prior_rec_exists = 'N' and p_curr_rec_exists = 'Y') OR
4645: (p_curr_rec_exists = 'N' and p_next_rec_exists ='Y') THEN

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

4638: oe_debug_pub.add(' before finding new lines ');
4639: oe_debug_pub.add(' p_prior_rec_exists'||p_prior_rec_exists);
4640: oe_debug_pub.add(' p_curr_rec_exists'||p_curr_rec_exists);
4641: oe_debug_pub.add(' p_next_rec_exists'||p_next_rec_exists);
4642: oe_debug_pub.add(' p_trans_rec_exists'||p_trans_rec_exists);
4643: END IF;
4644: IF (p_prior_rec_exists = 'N' and p_curr_rec_exists = 'Y') OR
4645: (p_curr_rec_exists = 'N' and p_next_rec_exists ='Y') THEN
4646: IF p_prior_version IS NOT NULL and p_curr_rec_exists = 'Y' THEN

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

4644: IF (p_prior_rec_exists = 'N' and p_curr_rec_exists = 'Y') OR
4645: (p_curr_rec_exists = 'N' and p_next_rec_exists ='Y') THEN
4646: IF p_prior_version IS NOT NULL and p_curr_rec_exists = 'Y' THEN
4647: IF l_debug_level > 0 THEN
4648: oe_debug_pub.add(' Prior is not there - current is there');
4649: END IF;
4650: ind := ind+1;
4651: x_line_changed_attr_tbl(ind).line_number := x_line_number;
4652: x_line_changed_attr_tbl(ind).prior_value := null;

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

4653: x_line_changed_attr_tbl(ind).current_value := 'ADD';
4654: x_line_changed_attr_tbl(ind).next_value := null;
4655: ELSIF (p_curr_rec_exists = 'N' and p_next_rec_exists = 'Y') THEN
4656: IF l_debug_level > 0 THEN
4657: oe_debug_pub.add(' Current is not there - next is there');
4658: END IF;
4659: ind := ind+1;
4660: x_line_changed_attr_tbl(ind).line_number := x_line_number;
4661: x_line_changed_attr_tbl(ind).prior_value := null;

Line 4668: oe_debug_pub.add(' before finding deleted lines');

4664: end if;
4665: END IF;
4666:
4667: IF l_debug_level > 0 THEN
4668: oe_debug_pub.add(' before finding deleted lines');
4669: oe_debug_pub.add(' p_prior_rec_exists'||p_prior_rec_exists);
4670: oe_debug_pub.add(' p_curr_rec_exists'||p_curr_rec_exists);
4671: oe_debug_pub.add(' p_next_rec_exists'||p_next_rec_exists);
4672: oe_debug_pub.add(' p_trans_rec_exists'||p_trans_rec_exists);

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

4665: END IF;
4666:
4667: IF l_debug_level > 0 THEN
4668: oe_debug_pub.add(' before finding deleted lines');
4669: oe_debug_pub.add(' p_prior_rec_exists'||p_prior_rec_exists);
4670: oe_debug_pub.add(' p_curr_rec_exists'||p_curr_rec_exists);
4671: oe_debug_pub.add(' p_next_rec_exists'||p_next_rec_exists);
4672: oe_debug_pub.add(' p_trans_rec_exists'||p_trans_rec_exists);
4673: oe_debug_pub.add(' x_line_numer '||x_line_number);

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

4666:
4667: IF l_debug_level > 0 THEN
4668: oe_debug_pub.add(' before finding deleted lines');
4669: oe_debug_pub.add(' p_prior_rec_exists'||p_prior_rec_exists);
4670: oe_debug_pub.add(' p_curr_rec_exists'||p_curr_rec_exists);
4671: oe_debug_pub.add(' p_next_rec_exists'||p_next_rec_exists);
4672: oe_debug_pub.add(' p_trans_rec_exists'||p_trans_rec_exists);
4673: oe_debug_pub.add(' x_line_numer '||x_line_number);
4674: END IF;

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

4667: IF l_debug_level > 0 THEN
4668: oe_debug_pub.add(' before finding deleted lines');
4669: oe_debug_pub.add(' p_prior_rec_exists'||p_prior_rec_exists);
4670: oe_debug_pub.add(' p_curr_rec_exists'||p_curr_rec_exists);
4671: oe_debug_pub.add(' p_next_rec_exists'||p_next_rec_exists);
4672: oe_debug_pub.add(' p_trans_rec_exists'||p_trans_rec_exists);
4673: oe_debug_pub.add(' x_line_numer '||x_line_number);
4674: END IF;
4675: IF (p_prior_rec_exists = 'Y' and p_curr_rec_exists = 'N') OR

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

4668: oe_debug_pub.add(' before finding deleted lines');
4669: oe_debug_pub.add(' p_prior_rec_exists'||p_prior_rec_exists);
4670: oe_debug_pub.add(' p_curr_rec_exists'||p_curr_rec_exists);
4671: oe_debug_pub.add(' p_next_rec_exists'||p_next_rec_exists);
4672: oe_debug_pub.add(' p_trans_rec_exists'||p_trans_rec_exists);
4673: oe_debug_pub.add(' x_line_numer '||x_line_number);
4674: END IF;
4675: IF (p_prior_rec_exists = 'Y' and p_curr_rec_exists = 'N') OR
4676: (p_curr_rec_exists = 'Y' and p_next_rec_exists ='N') THEN

Line 4673: oe_debug_pub.add(' x_line_numer '||x_line_number);

4669: oe_debug_pub.add(' p_prior_rec_exists'||p_prior_rec_exists);
4670: oe_debug_pub.add(' p_curr_rec_exists'||p_curr_rec_exists);
4671: oe_debug_pub.add(' p_next_rec_exists'||p_next_rec_exists);
4672: oe_debug_pub.add(' p_trans_rec_exists'||p_trans_rec_exists);
4673: oe_debug_pub.add(' x_line_numer '||x_line_number);
4674: END IF;
4675: IF (p_prior_rec_exists = 'Y' and p_curr_rec_exists = 'N') OR
4676: (p_curr_rec_exists = 'Y' and p_next_rec_exists ='N') THEN
4677: IF p_prior_rec_exists = 'Y' and p_curr_rec_exists = 'N' THEN

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

4675: IF (p_prior_rec_exists = 'Y' and p_curr_rec_exists = 'N') OR
4676: (p_curr_rec_exists = 'Y' and p_next_rec_exists ='N') THEN
4677: IF p_prior_rec_exists = 'Y' and p_curr_rec_exists = 'N' THEN
4678: IF l_debug_level > 0 THEN
4679: oe_debug_pub.add(' Prior is there - current is not there');
4680: END IF;
4681: ind := ind+1;
4682: x_line_changed_attr_tbl(ind).line_number := x_line_number;
4683: x_line_changed_attr_tbl(ind).prior_value := null;

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

4684: x_line_changed_attr_tbl(ind).current_value := 'DELETE';
4685: x_line_changed_attr_tbl(ind).next_value := null;
4686: ELSIF p_curr_rec_exists = 'Y' and p_next_rec_exists = 'N' THEN
4687: IF l_debug_level > 0 THEN
4688: oe_debug_pub.add(' p_next_version'||p_next_version);
4689: oe_debug_pub.add(' g_trans_version'||g_trans_version);
4690: END IF;
4691: --if p_next_version != g_trans_version THEN
4692: IF l_debug_level > 0 THEN

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

4685: x_line_changed_attr_tbl(ind).next_value := null;
4686: ELSIF p_curr_rec_exists = 'Y' and p_next_rec_exists = 'N' THEN
4687: IF l_debug_level > 0 THEN
4688: oe_debug_pub.add(' p_next_version'||p_next_version);
4689: oe_debug_pub.add(' g_trans_version'||g_trans_version);
4690: END IF;
4691: --if p_next_version != g_trans_version THEN
4692: IF l_debug_level > 0 THEN
4693: oe_debug_pub.add(' Current is there - next is not there');

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

4689: oe_debug_pub.add(' g_trans_version'||g_trans_version);
4690: END IF;
4691: --if p_next_version != g_trans_version THEN
4692: IF l_debug_level > 0 THEN
4693: oe_debug_pub.add(' Current is there - next is not there');
4694: END IF;
4695: ind := ind+1;
4696: x_line_changed_attr_tbl(ind).line_number := x_line_number;
4697: x_line_changed_attr_tbl(ind).prior_value := null;

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

4701: end if;
4702: END IF;
4703: --dbms_output.put_line(' No line number'||x_line_number);
4704: IF l_debug_level > 0 THEN
4705: oe_debug_pub.add('******BEFORE COMPARING ATTRIBUTES*************');
4706: oe_debug_pub.add('current ind '|| ind);
4707: END IF;
4708:
4709: IF (p_prior_version IS NOT NULL and p_prior_rec_exists ='Y') OR

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

4702: END IF;
4703: --dbms_output.put_line(' No line number'||x_line_number);
4704: IF l_debug_level > 0 THEN
4705: oe_debug_pub.add('******BEFORE COMPARING ATTRIBUTES*************');
4706: oe_debug_pub.add('current ind '|| ind);
4707: END IF;
4708:
4709: IF (p_prior_version IS NOT NULL and p_prior_rec_exists ='Y') OR
4710: (p_current_version IS NOT NULL and p_curr_rec_exists ='Y') OR

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

7672: CLOSE C_GET_LINES;
7673: */
7674: END IF; /* line_id not null */
7675: IF l_debug_level > 0 THEN
7676: oe_debug_pub.add('******AFTER COMPARING ATTRIBUTES*************');
7677: oe_debug_pub.add('current ind '|| ind);
7678: END IF;
7679: END COMPARE_ATTRIBUTES;
7680:

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

7673: */
7674: END IF; /* line_id not null */
7675: IF l_debug_level > 0 THEN
7676: oe_debug_pub.add('******AFTER COMPARING ATTRIBUTES*************');
7677: oe_debug_pub.add('current ind '|| ind);
7678: END IF;
7679: END COMPARE_ATTRIBUTES;
7680:
7681: /***************************************************/

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

7714: where header_id = p_header_id
7715: -- and transaction_phase_code = p_transaction_phase_code
7716: and version_number in (p_prior_version,p_current_version,p_next_version);
7717:
7718: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
7719: ind1 NUMBER;
7720: total_lines NUMBER;
7721: x_line_number NUMBER;
7722: BEGIN

Line 7725: oe_debug_pub.add('Entering COMPARE_LINE_VERSIONS');

7721: x_line_number NUMBER;
7722: BEGIN
7723:
7724: IF l_debug_level > 0 THEN
7725: oe_debug_pub.add('Entering COMPARE_LINE_VERSIONS');
7726: oe_debug_pub.add('header' ||p_header_id);
7727: oe_debug_pub.add('prior version' ||p_prior_version);
7728: oe_debug_pub.add('current version' ||p_current_version);
7729: oe_debug_pub.add('next version' ||p_next_version);

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

7722: BEGIN
7723:
7724: IF l_debug_level > 0 THEN
7725: oe_debug_pub.add('Entering COMPARE_LINE_VERSIONS');
7726: oe_debug_pub.add('header' ||p_header_id);
7727: oe_debug_pub.add('prior version' ||p_prior_version);
7728: oe_debug_pub.add('current version' ||p_current_version);
7729: oe_debug_pub.add('next version' ||p_next_version);
7730: oe_debug_pub.add('max version' ||g_max_version);

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

7723:
7724: IF l_debug_level > 0 THEN
7725: oe_debug_pub.add('Entering COMPARE_LINE_VERSIONS');
7726: oe_debug_pub.add('header' ||p_header_id);
7727: oe_debug_pub.add('prior version' ||p_prior_version);
7728: oe_debug_pub.add('current version' ||p_current_version);
7729: oe_debug_pub.add('next version' ||p_next_version);
7730: oe_debug_pub.add('max version' ||g_max_version);
7731: oe_debug_pub.add('trans version' ||g_trans_version);

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

7724: IF l_debug_level > 0 THEN
7725: oe_debug_pub.add('Entering COMPARE_LINE_VERSIONS');
7726: oe_debug_pub.add('header' ||p_header_id);
7727: oe_debug_pub.add('prior version' ||p_prior_version);
7728: oe_debug_pub.add('current version' ||p_current_version);
7729: oe_debug_pub.add('next version' ||p_next_version);
7730: oe_debug_pub.add('max version' ||g_max_version);
7731: oe_debug_pub.add('trans version' ||g_trans_version);
7732: END IF;

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

7725: oe_debug_pub.add('Entering COMPARE_LINE_VERSIONS');
7726: oe_debug_pub.add('header' ||p_header_id);
7727: oe_debug_pub.add('prior version' ||p_prior_version);
7728: oe_debug_pub.add('current version' ||p_current_version);
7729: oe_debug_pub.add('next version' ||p_next_version);
7730: oe_debug_pub.add('max version' ||g_max_version);
7731: oe_debug_pub.add('trans version' ||g_trans_version);
7732: END IF;
7733:

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

7726: oe_debug_pub.add('header' ||p_header_id);
7727: oe_debug_pub.add('prior version' ||p_prior_version);
7728: oe_debug_pub.add('current version' ||p_current_version);
7729: oe_debug_pub.add('next version' ||p_next_version);
7730: oe_debug_pub.add('max version' ||g_max_version);
7731: oe_debug_pub.add('trans version' ||g_trans_version);
7732: END IF;
7733:
7734: ind1:=0;

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

7727: oe_debug_pub.add('prior version' ||p_prior_version);
7728: oe_debug_pub.add('current version' ||p_current_version);
7729: oe_debug_pub.add('next version' ||p_next_version);
7730: oe_debug_pub.add('max version' ||g_max_version);
7731: oe_debug_pub.add('trans version' ||g_trans_version);
7732: END IF;
7733:
7734: ind1:=0;
7735: total_lines:=0;

Line 7743: oe_debug_pub.add('*lines found(trans)******'||l_line_id);

7739: LOOP
7740: FETCH C_GET_LINES INTO l_line_id,x_line_number;
7741: EXIT WHEN C_GET_LINES%NOTFOUND;
7742: IF l_debug_level > 0 THEN
7743: oe_debug_pub.add('*************lines found(trans)******************'||l_line_id);
7744: END IF;
7745:
7746: IF l_line_id IS NOT NULL THEN
7747: IF l_debug_level > 0 THEN

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

7744: END IF;
7745:
7746: IF l_line_id IS NOT NULL THEN
7747: IF l_debug_level > 0 THEN
7748: oe_debug_pub.add('*************before call total lines(trans) ******************'||ind1);
7749: END IF;
7750: COMPARE_ATTRIBUTES(p_header_id => p_header_id,
7751: p_line_id => l_line_id,
7752: p_prior_version => p_prior_version,

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

7764: ind1 := x_line_changed_attr_tbl.count;
7765: -- ind1 := ind1 + total_lines;
7766: END IF;
7767: IF l_debug_level > 0 THEN
7768: oe_debug_pub.add('*************after call total lines(trans) ******************'||ind1);
7769: END IF;
7770: END IF; /* line_id is not null */
7771: END LOOP;
7772: CLOSE C_GET_LINES;

Line 7779: oe_debug_pub.add('*lines found******'||l_line_id);

7775: LOOP
7776: FETCH C_GET_HIST_LINES INTO l_line_id,x_line_number;
7777: EXIT WHEN C_GET_HIST_LINES%NOTFOUND;
7778: IF l_debug_level > 0 THEN
7779: oe_debug_pub.add('*************lines found******************'||l_line_id);
7780: END IF;
7781:
7782: IF l_line_id IS NOT NULL THEN
7783: IF l_debug_level > 0 THEN

Line 7784: oe_debug_pub.add('*before call total lines ******'||ind1);

7780: END IF;
7781:
7782: IF l_line_id IS NOT NULL THEN
7783: IF l_debug_level > 0 THEN
7784: oe_debug_pub.add('*************before call total lines ******************'||ind1);
7785: END IF;
7786: COMPARE_ATTRIBUTES(p_header_id => p_header_id,
7787: p_line_id => l_line_id,
7788: p_prior_version => p_prior_version,

Line 7800: oe_debug_pub.add('*after call total lines ******'||ind1);

7796: x_line_changed_attr_tbl => x_line_changed_attr_tbl,
7797: p_total_lines => ind1,
7798: x_line_number => x_line_number);
7799: IF l_debug_level > 0 THEN
7800: oe_debug_pub.add('*************after call total lines ******************'||ind1);
7801: END IF;
7802: IF x_line_changed_attr_tbl.count > 0 THEN
7803: ind1 := x_line_changed_attr_tbl.count;
7804: -- ind1 := ind1 + total_lines;

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

7815: ) RETURN VARCHAR2
7816: IS
7817: l_line_status VARCHAR2(240) := NULL;
7818: --
7819: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
7820: --
7821: BEGIN
7822:
7823: IF p_line_status_code IS NOT NULL THEN

Line 7839: oe_debug_pub.add('could not find line_status meaning');

7835: EXCEPTION
7836:
7837: WHEN NO_DATA_FOUND THEN
7838: IF l_debug_level > 0 THEN
7839: oe_debug_pub.add('could not find line_status meaning');
7840: END IF;
7841: RETURN NULL;
7842: WHEN OTHERS THEN
7843: IF l_debug_level > 0 THEN

Line 7844: oe_debug_pub.add('others exception - line_status meaning');

7840: END IF;
7841: RETURN NULL;
7842: WHEN OTHERS THEN
7843: IF l_debug_level > 0 THEN
7844: oe_debug_pub.add('others exception - line_status meaning');
7845: END IF;
7846: RETURN NULL;
7847: END line_status;
7848: /***************************************************/

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

7865: and descriptive_flexfield_name= p_descriptive_flexfield_name
7866: and application_column_name =p_application_column_name
7867: 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');
7868: BEGIN
7869: oe_debug_pub.add('Entering get_dff_seg_prompt');
7870: fnd_message.set_name('ONT','ONT_SLASH_SEPARATOR');
7871: slash:=FND_MESSAGE.GET;
7872:
7873: IF p_application_column_name = 'CONTEXT' THEN --Context Prompt

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

7874: select FORM_CONTEXT_PROMPT into l_prompt from FND_DESCRIPTIVE_FLEXS_VL
7875: where APPLICATION_ID = p_application_id
7876: and DESCRIPTIVE_FLEXFIELD_NAME = p_descriptive_flexfield_name;
7877:
7878: oe_debug_pub.add('Context Prompt='||l_prompt);
7879: ELSE --Attribute Prompt
7880: IF p_descriptive_flex_context_cod IS NULL
7881: AND p_desc_flex_context_cod_prior IS NULL
7882: AND p_desc_flex_context_cod_next IS NULL THEN

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

7883: select form_left_prompt into l_prompt from fnd_descr_flex_col_usage_vl where application_id=660
7884: and descriptive_flexfield_name= p_descriptive_flexfield_name
7885: and application_column_name =p_application_column_name;
7886:
7887: oe_debug_pub.add('Prompt='||l_prompt);
7888:
7889: ELSE --Context has been passed
7890: OPEN c1;
7891: LOOP

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

7897: x_prompt:=x_prompt||slash||l_prompt;
7898: END IF;
7899: END LOOP;
7900: CLOSE C1;
7901: oe_debug_pub.add('Prompt='||x_prompt);
7902: RETURN(x_prompt);
7903: END IF; --Context been passed
7904: END IF; --Context/Attribute Prompt
7905:

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

7907: EXCEPTION
7908: WHEN no_data_found THEN
7909: Return null;
7910: WHEN OTHERS THEN
7911: oe_debug_pub.add('error is'||SQLCODE||'message'||SQLERRM);
7912: Return Null;
7913: END get_dff_seg_prompt;
7914: --bug 4302049
7915: