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_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_Order_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_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_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_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_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_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:

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_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:
21: l_org_id := OE_GLOBALS.G_ORG_ID;

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_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:
21: l_org_id := OE_GLOBALS.G_ORG_ID;
22:

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

397: p_version NUMBER,
398: x_header_rec IN OUT NOCOPY OE_Order_PUB.Header_Rec_Type)
399: IS
400: l_org_id NUMBER;
401: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
402: BEGIN
403: IF l_debug_level > 0 THEN
404: oe_debug_pub.add('Entering OE_VERSION_COMP.QUERY_HEADER_TRANS_ROW');
405: oe_debug_pub.add('header' ||p_header_id);

Line 404: oe_debug_pub.add('Entering OE_VERSION_COMP.QUERY_HEADER_TRANS_ROW');

400: l_org_id NUMBER;
401: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
402: BEGIN
403: IF l_debug_level > 0 THEN
404: oe_debug_pub.add('Entering OE_VERSION_COMP.QUERY_HEADER_TRANS_ROW');
405: oe_debug_pub.add('header' ||p_header_id);
406: oe_debug_pub.add('version' ||p_version);
407: END IF;
408:

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

401: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
402: BEGIN
403: IF l_debug_level > 0 THEN
404: oe_debug_pub.add('Entering OE_VERSION_COMP.QUERY_HEADER_TRANS_ROW');
405: oe_debug_pub.add('header' ||p_header_id);
406: oe_debug_pub.add('version' ||p_version);
407: END IF;
408:
409: l_org_id := OE_GLOBALS.G_ORG_ID;

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

402: BEGIN
403: IF l_debug_level > 0 THEN
404: oe_debug_pub.add('Entering OE_VERSION_COMP.QUERY_HEADER_TRANS_ROW');
405: oe_debug_pub.add('header' ||p_header_id);
406: oe_debug_pub.add('version' ||p_version);
407: END IF;
408:
409: l_org_id := OE_GLOBALS.G_ORG_ID;
410:

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

886: l_is_card_history1 VARCHAR2(1) := 'N';
887: l_is_card_history2 VARCHAR2(1) := 'N';
888:
889:
890: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
891: BEGIN
892:
893: oe_debug_pub.add('Entering OE_VERSION_COMP'||l_debug_level);
894: IF l_debug_level > 0 THEN

Line 893: oe_debug_pub.add('Entering OE_VERSION_COMP'||l_debug_level);

889:
890: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
891: BEGIN
892:
893: oe_debug_pub.add('Entering OE_VERSION_COMP'||l_debug_level);
894: IF l_debug_level > 0 THEN
895: oe_debug_pub.add('Entering OE_VERSION_COMP.COMPARE_HEADER_VERSIONS');
896: oe_debug_pub.add('header' ||p_header_id);
897: oe_debug_pub.add('prior_version' ||p_prior_version);

Line 895: oe_debug_pub.add('Entering OE_VERSION_COMP.COMPARE_HEADER_VERSIONS');

891: BEGIN
892:
893: oe_debug_pub.add('Entering OE_VERSION_COMP'||l_debug_level);
894: IF l_debug_level > 0 THEN
895: oe_debug_pub.add('Entering OE_VERSION_COMP.COMPARE_HEADER_VERSIONS');
896: oe_debug_pub.add('header' ||p_header_id);
897: oe_debug_pub.add('prior_version' ||p_prior_version);
898: oe_debug_pub.add('curr_version' ||p_current_version);
899: oe_debug_pub.add('next_version' ||p_next_version);

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

892:
893: oe_debug_pub.add('Entering OE_VERSION_COMP'||l_debug_level);
894: IF l_debug_level > 0 THEN
895: oe_debug_pub.add('Entering OE_VERSION_COMP.COMPARE_HEADER_VERSIONS');
896: oe_debug_pub.add('header' ||p_header_id);
897: oe_debug_pub.add('prior_version' ||p_prior_version);
898: oe_debug_pub.add('curr_version' ||p_current_version);
899: oe_debug_pub.add('next_version' ||p_next_version);
900: oe_debug_pub.add('max_version' ||g_max_version);

Line 897: oe_debug_pub.add('prior_version' ||p_prior_version);

893: oe_debug_pub.add('Entering OE_VERSION_COMP'||l_debug_level);
894: IF l_debug_level > 0 THEN
895: oe_debug_pub.add('Entering OE_VERSION_COMP.COMPARE_HEADER_VERSIONS');
896: oe_debug_pub.add('header' ||p_header_id);
897: oe_debug_pub.add('prior_version' ||p_prior_version);
898: oe_debug_pub.add('curr_version' ||p_current_version);
899: oe_debug_pub.add('next_version' ||p_next_version);
900: oe_debug_pub.add('max_version' ||g_max_version);
901: oe_debug_pub.add('trans_version' ||g_trans_version);

Line 898: oe_debug_pub.add('curr_version' ||p_current_version);

894: IF l_debug_level > 0 THEN
895: oe_debug_pub.add('Entering OE_VERSION_COMP.COMPARE_HEADER_VERSIONS');
896: oe_debug_pub.add('header' ||p_header_id);
897: oe_debug_pub.add('prior_version' ||p_prior_version);
898: oe_debug_pub.add('curr_version' ||p_current_version);
899: oe_debug_pub.add('next_version' ||p_next_version);
900: oe_debug_pub.add('max_version' ||g_max_version);
901: oe_debug_pub.add('trans_version' ||g_trans_version);
902: oe_debug_pub.add('prior phase chagne' ||g_prior_phase_change_flag);

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

895: oe_debug_pub.add('Entering OE_VERSION_COMP.COMPARE_HEADER_VERSIONS');
896: oe_debug_pub.add('header' ||p_header_id);
897: oe_debug_pub.add('prior_version' ||p_prior_version);
898: oe_debug_pub.add('curr_version' ||p_current_version);
899: oe_debug_pub.add('next_version' ||p_next_version);
900: oe_debug_pub.add('max_version' ||g_max_version);
901: oe_debug_pub.add('trans_version' ||g_trans_version);
902: oe_debug_pub.add('prior phase chagne' ||g_prior_phase_change_flag);
903: oe_debug_pub.add('curr phase chagne' ||g_curr_phase_change_flag);

Line 900: oe_debug_pub.add('max_version' ||g_max_version);

896: oe_debug_pub.add('header' ||p_header_id);
897: oe_debug_pub.add('prior_version' ||p_prior_version);
898: oe_debug_pub.add('curr_version' ||p_current_version);
899: oe_debug_pub.add('next_version' ||p_next_version);
900: oe_debug_pub.add('max_version' ||g_max_version);
901: oe_debug_pub.add('trans_version' ||g_trans_version);
902: oe_debug_pub.add('prior phase chagne' ||g_prior_phase_change_flag);
903: oe_debug_pub.add('curr phase chagne' ||g_curr_phase_change_flag);
904: oe_debug_pub.add('next phase chagne' ||g_next_phase_change_flag);

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

897: oe_debug_pub.add('prior_version' ||p_prior_version);
898: oe_debug_pub.add('curr_version' ||p_current_version);
899: oe_debug_pub.add('next_version' ||p_next_version);
900: oe_debug_pub.add('max_version' ||g_max_version);
901: oe_debug_pub.add('trans_version' ||g_trans_version);
902: oe_debug_pub.add('prior phase chagne' ||g_prior_phase_change_flag);
903: oe_debug_pub.add('curr phase chagne' ||g_curr_phase_change_flag);
904: oe_debug_pub.add('next phase chagne' ||g_next_phase_change_flag);
905: END IF;

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

898: oe_debug_pub.add('curr_version' ||p_current_version);
899: oe_debug_pub.add('next_version' ||p_next_version);
900: oe_debug_pub.add('max_version' ||g_max_version);
901: oe_debug_pub.add('trans_version' ||g_trans_version);
902: oe_debug_pub.add('prior phase chagne' ||g_prior_phase_change_flag);
903: oe_debug_pub.add('curr phase chagne' ||g_curr_phase_change_flag);
904: oe_debug_pub.add('next phase chagne' ||g_next_phase_change_flag);
905: END IF;
906:

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

899: oe_debug_pub.add('next_version' ||p_next_version);
900: oe_debug_pub.add('max_version' ||g_max_version);
901: oe_debug_pub.add('trans_version' ||g_trans_version);
902: oe_debug_pub.add('prior phase chagne' ||g_prior_phase_change_flag);
903: oe_debug_pub.add('curr phase chagne' ||g_curr_phase_change_flag);
904: oe_debug_pub.add('next phase chagne' ||g_next_phase_change_flag);
905: END IF;
906:
907: IF p_prior_version IS NOT NULL THEN

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

900: oe_debug_pub.add('max_version' ||g_max_version);
901: oe_debug_pub.add('trans_version' ||g_trans_version);
902: oe_debug_pub.add('prior phase chagne' ||g_prior_phase_change_flag);
903: oe_debug_pub.add('curr phase chagne' ||g_curr_phase_change_flag);
904: oe_debug_pub.add('next phase chagne' ||g_next_phase_change_flag);
905: END IF;
906:
907: IF p_prior_version IS NOT NULL THEN
908: OE_VERSION_COMP.QUERY_HEADER_ROW(p_header_id => p_header_id,

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

7059: p_phase_change_flag VARCHAR2,
7060: x_line_rec IN OUT NOCOPY OE_ORDER_PUB.line_rec_type)
7061: IS
7062: l_org_id NUMBER;
7063: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
7064: BEGIN
7065: IF l_debug_level > 0 THEN
7066: oe_debug_pub.add('Entering OE_VERSION_COMP.QUERY_LINE_ROW');
7067: oe_debug_pub.add('header' ||p_header_id);

Line 7066: oe_debug_pub.add('Entering OE_VERSION_COMP.QUERY_LINE_ROW');

7062: l_org_id NUMBER;
7063: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
7064: BEGIN
7065: IF l_debug_level > 0 THEN
7066: oe_debug_pub.add('Entering OE_VERSION_COMP.QUERY_LINE_ROW');
7067: oe_debug_pub.add('header' ||p_header_id);
7068: oe_debug_pub.add('version' ||p_version);
7069: END IF;
7070:

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

7063: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
7064: BEGIN
7065: IF l_debug_level > 0 THEN
7066: oe_debug_pub.add('Entering OE_VERSION_COMP.QUERY_LINE_ROW');
7067: oe_debug_pub.add('header' ||p_header_id);
7068: oe_debug_pub.add('version' ||p_version);
7069: END IF;
7070:
7071: l_org_id := OE_GLOBALS.G_ORG_ID;

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

7064: BEGIN
7065: IF l_debug_level > 0 THEN
7066: oe_debug_pub.add('Entering OE_VERSION_COMP.QUERY_LINE_ROW');
7067: oe_debug_pub.add('header' ||p_header_id);
7068: oe_debug_pub.add('version' ||p_version);
7069: END IF;
7070:
7071: l_org_id := OE_GLOBALS.G_ORG_ID;
7072:

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

7745: p_version NUMBER,
7746: x_line_rec IN OUT NOCOPY OE_ORDER_PUB.line_rec_type)
7747: IS
7748: l_org_id NUMBER;
7749: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
7750: BEGIN
7751: IF l_debug_level > 0 THEN
7752: oe_debug_pub.add('Entering OE_VERSION_COMP.QUERY_LINE_TRANS_ROW', 1);
7753: oe_debug_pub.add('header' ||p_header_id);

Line 7752: oe_debug_pub.add('Entering OE_VERSION_COMP.QUERY_LINE_TRANS_ROW', 1);

7748: l_org_id NUMBER;
7749: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
7750: BEGIN
7751: IF l_debug_level > 0 THEN
7752: oe_debug_pub.add('Entering OE_VERSION_COMP.QUERY_LINE_TRANS_ROW', 1);
7753: oe_debug_pub.add('header' ||p_header_id);
7754: oe_debug_pub.add('version' ||p_version);
7755: END IF;
7756:

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

7749: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
7750: BEGIN
7751: IF l_debug_level > 0 THEN
7752: oe_debug_pub.add('Entering OE_VERSION_COMP.QUERY_LINE_TRANS_ROW', 1);
7753: oe_debug_pub.add('header' ||p_header_id);
7754: oe_debug_pub.add('version' ||p_version);
7755: END IF;
7756:
7757: l_org_id := OE_GLOBALS.G_ORG_ID;

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

7750: BEGIN
7751: IF l_debug_level > 0 THEN
7752: oe_debug_pub.add('Entering OE_VERSION_COMP.QUERY_LINE_TRANS_ROW', 1);
7753: oe_debug_pub.add('header' ||p_header_id);
7754: oe_debug_pub.add('version' ||p_version);
7755: END IF;
7756:
7757: l_org_id := OE_GLOBALS.G_ORG_ID;
7758:

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

8512: x_prior_item_rel_type VARCHAR2(240);
8513: x_current_item_rel_type VARCHAR2(240);
8514: x_next_item_rel_type VARCHAR2(240);
8515:
8516: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
8517: p_prior_rec_exists VARCHAR2(1) := 'N';
8518: p_curr_rec_exists VARCHAR2(1) := 'N';
8519: p_next_rec_exists VARCHAR2(1) := 'N';
8520: p_trans_rec_exists VARCHAR2(1) := 'N';

Line 8525: oe_debug_pub.add('Entering Compare_line_attributes');

8521: ind NUMBER;
8522: BEGIN
8523:
8524: IF l_debug_level > 0 THEN
8525: oe_debug_pub.add('Entering Compare_line_attributes');
8526: oe_debug_pub.add('header' ||p_header_id);
8527: oe_debug_pub.add('line' ||p_line_id);
8528: oe_debug_pub.add('line number' ||x_line_number);
8529: oe_debug_pub.add('prior version' ||p_prior_version);

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

8522: BEGIN
8523:
8524: IF l_debug_level > 0 THEN
8525: oe_debug_pub.add('Entering Compare_line_attributes');
8526: oe_debug_pub.add('header' ||p_header_id);
8527: oe_debug_pub.add('line' ||p_line_id);
8528: oe_debug_pub.add('line number' ||x_line_number);
8529: oe_debug_pub.add('prior version' ||p_prior_version);
8530: oe_debug_pub.add('current version' ||p_current_version);

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

8523:
8524: IF l_debug_level > 0 THEN
8525: oe_debug_pub.add('Entering Compare_line_attributes');
8526: oe_debug_pub.add('header' ||p_header_id);
8527: oe_debug_pub.add('line' ||p_line_id);
8528: oe_debug_pub.add('line number' ||x_line_number);
8529: oe_debug_pub.add('prior version' ||p_prior_version);
8530: oe_debug_pub.add('current version' ||p_current_version);
8531: oe_debug_pub.add('next version' ||p_next_version);

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

8524: IF l_debug_level > 0 THEN
8525: oe_debug_pub.add('Entering Compare_line_attributes');
8526: oe_debug_pub.add('header' ||p_header_id);
8527: oe_debug_pub.add('line' ||p_line_id);
8528: oe_debug_pub.add('line number' ||x_line_number);
8529: oe_debug_pub.add('prior version' ||p_prior_version);
8530: oe_debug_pub.add('current version' ||p_current_version);
8531: oe_debug_pub.add('next version' ||p_next_version);
8532: oe_debug_pub.add('max version' ||g_max_version);

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

8525: oe_debug_pub.add('Entering Compare_line_attributes');
8526: oe_debug_pub.add('header' ||p_header_id);
8527: oe_debug_pub.add('line' ||p_line_id);
8528: oe_debug_pub.add('line number' ||x_line_number);
8529: oe_debug_pub.add('prior version' ||p_prior_version);
8530: oe_debug_pub.add('current version' ||p_current_version);
8531: oe_debug_pub.add('next version' ||p_next_version);
8532: oe_debug_pub.add('max version' ||g_max_version);
8533: oe_debug_pub.add('trans version' ||g_trans_version);

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

8526: oe_debug_pub.add('header' ||p_header_id);
8527: oe_debug_pub.add('line' ||p_line_id);
8528: oe_debug_pub.add('line number' ||x_line_number);
8529: oe_debug_pub.add('prior version' ||p_prior_version);
8530: oe_debug_pub.add('current version' ||p_current_version);
8531: oe_debug_pub.add('next version' ||p_next_version);
8532: oe_debug_pub.add('max version' ||g_max_version);
8533: oe_debug_pub.add('trans version' ||g_trans_version);
8534: END IF;

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

8527: oe_debug_pub.add('line' ||p_line_id);
8528: oe_debug_pub.add('line number' ||x_line_number);
8529: oe_debug_pub.add('prior version' ||p_prior_version);
8530: oe_debug_pub.add('current version' ||p_current_version);
8531: oe_debug_pub.add('next version' ||p_next_version);
8532: oe_debug_pub.add('max version' ||g_max_version);
8533: oe_debug_pub.add('trans version' ||g_trans_version);
8534: END IF;
8535:

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

8528: oe_debug_pub.add('line number' ||x_line_number);
8529: oe_debug_pub.add('prior version' ||p_prior_version);
8530: oe_debug_pub.add('current version' ||p_current_version);
8531: oe_debug_pub.add('next version' ||p_next_version);
8532: oe_debug_pub.add('max version' ||g_max_version);
8533: oe_debug_pub.add('trans version' ||g_trans_version);
8534: END IF;
8535:
8536: if p_total_lines > 0 THEN

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

8529: oe_debug_pub.add('prior version' ||p_prior_version);
8530: oe_debug_pub.add('current version' ||p_current_version);
8531: oe_debug_pub.add('next version' ||p_next_version);
8532: oe_debug_pub.add('max version' ||g_max_version);
8533: oe_debug_pub.add('trans version' ||g_trans_version);
8534: END IF;
8535:
8536: if p_total_lines > 0 THEN
8537: IF l_debug_level > 0 THEN

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

8534: END IF;
8535:
8536: if p_total_lines > 0 THEN
8537: IF l_debug_level > 0 THEN
8538: oe_debug_pub.add(' p_total_lines '||p_total_lines);
8539: end if;
8540: ind := p_total_lines;
8541: ELSE
8542: ind := 0;

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

8548: p_curr_rec := NULL;
8549: p_next_rec := NULL;
8550:
8551: IF l_debug_level > 0 THEN
8552: oe_debug_pub.add(' Quering prior line version details');
8553: oe_debug_pub.add('prior version' ||p_prior_version);
8554: END IF;
8555: /***************************************/
8556: IF p_prior_version IS NOT NULL THEN

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

8549: p_next_rec := NULL;
8550:
8551: IF l_debug_level > 0 THEN
8552: oe_debug_pub.add(' Quering prior line version details');
8553: oe_debug_pub.add('prior version' ||p_prior_version);
8554: END IF;
8555: /***************************************/
8556: IF p_prior_version IS NOT NULL THEN
8557: OE_VERSION_COMP.QUERY_LINE_ROW(p_header_id => p_header_id,

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

8565: p_prior_rec_exists := 'Y';
8566: END IF;
8567: END IF;
8568: IF l_debug_level > 0 THEN
8569: oe_debug_pub.add(' Quering current line version details');
8570: oe_debug_pub.add('current version' ||p_current_version);
8571: END IF;
8572:
8573: IF p_current_version IS NOT NULL THEN

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

8566: END IF;
8567: END IF;
8568: IF l_debug_level > 0 THEN
8569: oe_debug_pub.add(' Quering current line version details');
8570: oe_debug_pub.add('current version' ||p_current_version);
8571: END IF;
8572:
8573: IF p_current_version IS NOT NULL THEN
8574: OE_VERSION_COMP.QUERY_LINE_ROW(p_header_id => p_header_id,

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

8583: END IF;
8584:
8585: END IF;
8586: IF l_debug_level > 0 THEN
8587: oe_debug_pub.add(' Quering next/trans line version details');
8588: oe_debug_pub.add('next version' ||p_next_version);
8589: oe_debug_pub.add('trans version' ||g_trans_version);
8590: END IF;
8591: IF p_next_version = g_trans_version then

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

8584:
8585: END IF;
8586: IF l_debug_level > 0 THEN
8587: oe_debug_pub.add(' Quering next/trans line version details');
8588: oe_debug_pub.add('next version' ||p_next_version);
8589: oe_debug_pub.add('trans version' ||g_trans_version);
8590: END IF;
8591: IF p_next_version = g_trans_version then
8592: IF g_trans_version is not null then

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

8585: END IF;
8586: IF l_debug_level > 0 THEN
8587: oe_debug_pub.add(' Quering next/trans line version details');
8588: oe_debug_pub.add('next version' ||p_next_version);
8589: oe_debug_pub.add('trans version' ||g_trans_version);
8590: END IF;
8591: IF p_next_version = g_trans_version then
8592: IF g_trans_version is not null then
8593: --p_next_version := g_trans_version;

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

8620:
8621: --select oe_order_misc_pub.get_concat_line_number(l_line_id) into x_line_number from dual;
8622:
8623: IF l_debug_level > 0 THEN
8624: oe_debug_pub.add(' before finding new lines ');
8625: oe_debug_pub.add(' p_prior_rec_exists'||p_prior_rec_exists);
8626: oe_debug_pub.add(' p_curr_rec_exists'||p_curr_rec_exists);
8627: oe_debug_pub.add(' p_next_rec_exists'||p_next_rec_exists);
8628: oe_debug_pub.add(' p_trans_rec_exists'||p_trans_rec_exists);

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

8621: --select oe_order_misc_pub.get_concat_line_number(l_line_id) into x_line_number from dual;
8622:
8623: IF l_debug_level > 0 THEN
8624: oe_debug_pub.add(' before finding new lines ');
8625: oe_debug_pub.add(' p_prior_rec_exists'||p_prior_rec_exists);
8626: oe_debug_pub.add(' p_curr_rec_exists'||p_curr_rec_exists);
8627: oe_debug_pub.add(' p_next_rec_exists'||p_next_rec_exists);
8628: oe_debug_pub.add(' p_trans_rec_exists'||p_trans_rec_exists);
8629: END IF;

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

8622:
8623: IF l_debug_level > 0 THEN
8624: oe_debug_pub.add(' before finding new lines ');
8625: oe_debug_pub.add(' p_prior_rec_exists'||p_prior_rec_exists);
8626: oe_debug_pub.add(' p_curr_rec_exists'||p_curr_rec_exists);
8627: oe_debug_pub.add(' p_next_rec_exists'||p_next_rec_exists);
8628: oe_debug_pub.add(' p_trans_rec_exists'||p_trans_rec_exists);
8629: END IF;
8630: IF (p_prior_rec_exists = 'N' and p_curr_rec_exists = 'Y') OR

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

8623: IF l_debug_level > 0 THEN
8624: oe_debug_pub.add(' before finding new lines ');
8625: oe_debug_pub.add(' p_prior_rec_exists'||p_prior_rec_exists);
8626: oe_debug_pub.add(' p_curr_rec_exists'||p_curr_rec_exists);
8627: oe_debug_pub.add(' p_next_rec_exists'||p_next_rec_exists);
8628: oe_debug_pub.add(' p_trans_rec_exists'||p_trans_rec_exists);
8629: END IF;
8630: IF (p_prior_rec_exists = 'N' and p_curr_rec_exists = 'Y') OR
8631: (p_curr_rec_exists = 'N' and p_next_rec_exists ='Y') THEN

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

8624: oe_debug_pub.add(' before finding new lines ');
8625: oe_debug_pub.add(' p_prior_rec_exists'||p_prior_rec_exists);
8626: oe_debug_pub.add(' p_curr_rec_exists'||p_curr_rec_exists);
8627: oe_debug_pub.add(' p_next_rec_exists'||p_next_rec_exists);
8628: oe_debug_pub.add(' p_trans_rec_exists'||p_trans_rec_exists);
8629: END IF;
8630: IF (p_prior_rec_exists = 'N' and p_curr_rec_exists = 'Y') OR
8631: (p_curr_rec_exists = 'N' and p_next_rec_exists ='Y') THEN
8632: IF p_prior_version IS NOT NULL and p_curr_rec_exists = 'Y' THEN

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

8630: IF (p_prior_rec_exists = 'N' and p_curr_rec_exists = 'Y') OR
8631: (p_curr_rec_exists = 'N' and p_next_rec_exists ='Y') THEN
8632: IF p_prior_version IS NOT NULL and p_curr_rec_exists = 'Y' THEN
8633: IF l_debug_level > 0 THEN
8634: oe_debug_pub.add(' Prior is not there - current is there');
8635: END IF;
8636: ind := ind+1;
8637: x_line_changed_attr_tbl(ind).line_number := x_line_number;
8638: x_line_changed_attr_tbl(ind).prior_value := null;

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

8639: x_line_changed_attr_tbl(ind).current_value := 'ADD';
8640: x_line_changed_attr_tbl(ind).next_value := null;
8641: ELSIF (p_curr_rec_exists = 'N' and p_next_rec_exists = 'Y') THEN
8642: IF l_debug_level > 0 THEN
8643: oe_debug_pub.add(' Current is not there - next is there');
8644: END IF;
8645: ind := ind+1;
8646: x_line_changed_attr_tbl(ind).line_number := x_line_number;
8647: x_line_changed_attr_tbl(ind).prior_value := null;

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

8650: end if;
8651: END IF;
8652:
8653: IF l_debug_level > 0 THEN
8654: oe_debug_pub.add(' before finding deleted lines');
8655: oe_debug_pub.add(' p_prior_rec_exists'||p_prior_rec_exists);
8656: oe_debug_pub.add(' p_curr_rec_exists'||p_curr_rec_exists);
8657: oe_debug_pub.add(' p_next_rec_exists'||p_next_rec_exists);
8658: oe_debug_pub.add(' p_trans_rec_exists'||p_trans_rec_exists);

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

8651: END IF;
8652:
8653: IF l_debug_level > 0 THEN
8654: oe_debug_pub.add(' before finding deleted lines');
8655: oe_debug_pub.add(' p_prior_rec_exists'||p_prior_rec_exists);
8656: oe_debug_pub.add(' p_curr_rec_exists'||p_curr_rec_exists);
8657: oe_debug_pub.add(' p_next_rec_exists'||p_next_rec_exists);
8658: oe_debug_pub.add(' p_trans_rec_exists'||p_trans_rec_exists);
8659: oe_debug_pub.add(' x_line_numer '||x_line_number);

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

8652:
8653: IF l_debug_level > 0 THEN
8654: oe_debug_pub.add(' before finding deleted lines');
8655: oe_debug_pub.add(' p_prior_rec_exists'||p_prior_rec_exists);
8656: oe_debug_pub.add(' p_curr_rec_exists'||p_curr_rec_exists);
8657: oe_debug_pub.add(' p_next_rec_exists'||p_next_rec_exists);
8658: oe_debug_pub.add(' p_trans_rec_exists'||p_trans_rec_exists);
8659: oe_debug_pub.add(' x_line_numer '||x_line_number);
8660: END IF;

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

8653: IF l_debug_level > 0 THEN
8654: oe_debug_pub.add(' before finding deleted lines');
8655: oe_debug_pub.add(' p_prior_rec_exists'||p_prior_rec_exists);
8656: oe_debug_pub.add(' p_curr_rec_exists'||p_curr_rec_exists);
8657: oe_debug_pub.add(' p_next_rec_exists'||p_next_rec_exists);
8658: oe_debug_pub.add(' p_trans_rec_exists'||p_trans_rec_exists);
8659: oe_debug_pub.add(' x_line_numer '||x_line_number);
8660: END IF;
8661: IF (p_prior_rec_exists = 'Y' and p_curr_rec_exists = 'N') OR

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

8654: oe_debug_pub.add(' before finding deleted lines');
8655: oe_debug_pub.add(' p_prior_rec_exists'||p_prior_rec_exists);
8656: oe_debug_pub.add(' p_curr_rec_exists'||p_curr_rec_exists);
8657: oe_debug_pub.add(' p_next_rec_exists'||p_next_rec_exists);
8658: oe_debug_pub.add(' p_trans_rec_exists'||p_trans_rec_exists);
8659: oe_debug_pub.add(' x_line_numer '||x_line_number);
8660: END IF;
8661: IF (p_prior_rec_exists = 'Y' and p_curr_rec_exists = 'N') OR
8662: (p_curr_rec_exists = 'Y' and p_next_rec_exists ='N') THEN

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

8655: oe_debug_pub.add(' p_prior_rec_exists'||p_prior_rec_exists);
8656: oe_debug_pub.add(' p_curr_rec_exists'||p_curr_rec_exists);
8657: oe_debug_pub.add(' p_next_rec_exists'||p_next_rec_exists);
8658: oe_debug_pub.add(' p_trans_rec_exists'||p_trans_rec_exists);
8659: oe_debug_pub.add(' x_line_numer '||x_line_number);
8660: END IF;
8661: IF (p_prior_rec_exists = 'Y' and p_curr_rec_exists = 'N') OR
8662: (p_curr_rec_exists = 'Y' and p_next_rec_exists ='N') THEN
8663: IF p_prior_rec_exists = 'Y' and p_curr_rec_exists = 'N' THEN

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

8661: IF (p_prior_rec_exists = 'Y' and p_curr_rec_exists = 'N') OR
8662: (p_curr_rec_exists = 'Y' and p_next_rec_exists ='N') THEN
8663: IF p_prior_rec_exists = 'Y' and p_curr_rec_exists = 'N' THEN
8664: IF l_debug_level > 0 THEN
8665: oe_debug_pub.add(' Prior is there - current is not there');
8666: END IF;
8667: ind := ind+1;
8668: x_line_changed_attr_tbl(ind).line_number := x_line_number;
8669: x_line_changed_attr_tbl(ind).prior_value := null;

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

8670: x_line_changed_attr_tbl(ind).current_value := 'DELETE';
8671: x_line_changed_attr_tbl(ind).next_value := null;
8672: ELSIF p_curr_rec_exists = 'Y' and p_next_rec_exists = 'N' THEN
8673: IF l_debug_level > 0 THEN
8674: oe_debug_pub.add(' p_next_version'||p_next_version);
8675: oe_debug_pub.add(' g_trans_version'||g_trans_version);
8676: END IF;
8677: --if p_next_version != g_trans_version THEN
8678: IF l_debug_level > 0 THEN

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

8671: x_line_changed_attr_tbl(ind).next_value := null;
8672: ELSIF p_curr_rec_exists = 'Y' and p_next_rec_exists = 'N' THEN
8673: IF l_debug_level > 0 THEN
8674: oe_debug_pub.add(' p_next_version'||p_next_version);
8675: oe_debug_pub.add(' g_trans_version'||g_trans_version);
8676: END IF;
8677: --if p_next_version != g_trans_version THEN
8678: IF l_debug_level > 0 THEN
8679: oe_debug_pub.add(' Current is there - next is not there');

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

8675: oe_debug_pub.add(' g_trans_version'||g_trans_version);
8676: END IF;
8677: --if p_next_version != g_trans_version THEN
8678: IF l_debug_level > 0 THEN
8679: oe_debug_pub.add(' Current is there - next is not there');
8680: END IF;
8681: ind := ind+1;
8682: x_line_changed_attr_tbl(ind).line_number := x_line_number;
8683: x_line_changed_attr_tbl(ind).prior_value := null;

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

8687: end if;
8688: END IF;
8689: --dbms_output.put_line(' No line number'||x_line_number);
8690: IF l_debug_level > 0 THEN
8691: oe_debug_pub.add('******BEFORE COMPARING ATTRIBUTES*************');
8692: oe_debug_pub.add('current ind '|| ind);
8693: END IF;
8694:
8695: IF (p_prior_version IS NOT NULL and p_prior_rec_exists ='Y') OR

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

8688: END IF;
8689: --dbms_output.put_line(' No line number'||x_line_number);
8690: IF l_debug_level > 0 THEN
8691: oe_debug_pub.add('******BEFORE COMPARING ATTRIBUTES*************');
8692: oe_debug_pub.add('current ind '|| ind);
8693: END IF;
8694:
8695: IF (p_prior_version IS NOT NULL and p_prior_rec_exists ='Y') OR
8696: (p_current_version IS NOT NULL and p_curr_rec_exists ='Y') OR

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

18107: NULL;
18108: END IF;
18109: END IF; /* line_id not null */
18110: IF l_debug_level > 0 THEN
18111: oe_debug_pub.add('******AFTER COMPARING ATTRIBUTES*************');
18112: oe_debug_pub.add('current ind '|| ind);
18113: END IF;
18114: IF l_debug_level > 0 THEN
18115: oe_debug_pub.add(' Exiting OE_VERSION_COMP.Compare_Line_Attributes ');

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

18108: END IF;
18109: END IF; /* line_id not null */
18110: IF l_debug_level > 0 THEN
18111: oe_debug_pub.add('******AFTER COMPARING ATTRIBUTES*************');
18112: oe_debug_pub.add('current ind '|| ind);
18113: END IF;
18114: IF l_debug_level > 0 THEN
18115: oe_debug_pub.add(' Exiting OE_VERSION_COMP.Compare_Line_Attributes ');
18116: END IF;

Line 18115: oe_debug_pub.add(' Exiting OE_VERSION_COMP.Compare_Line_Attributes ');

18111: oe_debug_pub.add('******AFTER COMPARING ATTRIBUTES*************');
18112: oe_debug_pub.add('current ind '|| ind);
18113: END IF;
18114: IF l_debug_level > 0 THEN
18115: oe_debug_pub.add(' Exiting OE_VERSION_COMP.Compare_Line_Attributes ');
18116: END IF;
18117: /*
18118: j := 0;
18119: dbms_output.put_line('No of records'||x_line_changed_attr_tbl.count);

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

18159: and version_number in (p_prior_version,p_current_version,p_next_version);
18160: ind1 NUMBER;
18161: total_lines NUMBER;
18162: x_line_number VARCHAR2(30);
18163: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
18164: BEGIN
18165: IF l_debug_level > 0 THEN
18166: oe_debug_pub.add('Entering Compare_Line_versions');
18167: oe_debug_pub.add('header' ||p_header_id);

Line 18166: oe_debug_pub.add('Entering Compare_Line_versions');

18162: x_line_number VARCHAR2(30);
18163: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
18164: BEGIN
18165: IF l_debug_level > 0 THEN
18166: oe_debug_pub.add('Entering Compare_Line_versions');
18167: oe_debug_pub.add('header' ||p_header_id);
18168: oe_debug_pub.add('prior version' ||p_prior_version);
18169: oe_debug_pub.add('current version' ||p_current_version);
18170: oe_debug_pub.add('next version' ||p_next_version);

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

18163: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
18164: BEGIN
18165: IF l_debug_level > 0 THEN
18166: oe_debug_pub.add('Entering Compare_Line_versions');
18167: oe_debug_pub.add('header' ||p_header_id);
18168: oe_debug_pub.add('prior version' ||p_prior_version);
18169: oe_debug_pub.add('current version' ||p_current_version);
18170: oe_debug_pub.add('next version' ||p_next_version);
18171: oe_debug_pub.add('max version' ||g_max_version);

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

18164: BEGIN
18165: IF l_debug_level > 0 THEN
18166: oe_debug_pub.add('Entering Compare_Line_versions');
18167: oe_debug_pub.add('header' ||p_header_id);
18168: oe_debug_pub.add('prior version' ||p_prior_version);
18169: oe_debug_pub.add('current version' ||p_current_version);
18170: oe_debug_pub.add('next version' ||p_next_version);
18171: oe_debug_pub.add('max version' ||g_max_version);
18172: oe_debug_pub.add('trans version' ||g_trans_version);

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

18165: IF l_debug_level > 0 THEN
18166: oe_debug_pub.add('Entering Compare_Line_versions');
18167: oe_debug_pub.add('header' ||p_header_id);
18168: oe_debug_pub.add('prior version' ||p_prior_version);
18169: oe_debug_pub.add('current version' ||p_current_version);
18170: oe_debug_pub.add('next version' ||p_next_version);
18171: oe_debug_pub.add('max version' ||g_max_version);
18172: oe_debug_pub.add('trans version' ||g_trans_version);
18173: END IF;

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

18166: oe_debug_pub.add('Entering Compare_Line_versions');
18167: oe_debug_pub.add('header' ||p_header_id);
18168: oe_debug_pub.add('prior version' ||p_prior_version);
18169: oe_debug_pub.add('current version' ||p_current_version);
18170: oe_debug_pub.add('next version' ||p_next_version);
18171: oe_debug_pub.add('max version' ||g_max_version);
18172: oe_debug_pub.add('trans version' ||g_trans_version);
18173: END IF;
18174:

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

18167: oe_debug_pub.add('header' ||p_header_id);
18168: oe_debug_pub.add('prior version' ||p_prior_version);
18169: oe_debug_pub.add('current version' ||p_current_version);
18170: oe_debug_pub.add('next version' ||p_next_version);
18171: oe_debug_pub.add('max version' ||g_max_version);
18172: oe_debug_pub.add('trans version' ||g_trans_version);
18173: END IF;
18174:
18175: ind1:=0;

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

18168: oe_debug_pub.add('prior version' ||p_prior_version);
18169: oe_debug_pub.add('current version' ||p_current_version);
18170: oe_debug_pub.add('next version' ||p_next_version);
18171: oe_debug_pub.add('max version' ||g_max_version);
18172: oe_debug_pub.add('trans version' ||g_trans_version);
18173: END IF;
18174:
18175: ind1:=0;
18176: total_lines:=0;

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

18180: LOOP
18181: FETCH C_GET_LINES INTO l_line_id;
18182: EXIT WHEN C_GET_LINES%NOTFOUND;
18183: IF l_debug_level > 0 THEN
18184: oe_debug_pub.add('*************lines found(trans)******************'||l_line_id);
18185: END IF;
18186:
18187: IF l_line_id IS NOT NULL THEN
18188: IF l_debug_level > 0 THEN

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

18185: END IF;
18186:
18187: IF l_line_id IS NOT NULL THEN
18188: IF l_debug_level > 0 THEN
18189: oe_debug_pub.add('*************before call total lines(trans) ******************'||ind1);
18190: END IF;
18191: select oe_order_misc_pub.get_concat_line_number(l_line_id) into x_line_number from dual;
18192: IF x_line_number IS NULL THEN
18193: select oe_order_misc_pub.get_concat_hist_line_number(l_line_id) into x_line_number from dual;

Line 18196: oe_debug_pub.add('*line_number ******'||x_line_number);

18192: IF x_line_number IS NULL THEN
18193: select oe_order_misc_pub.get_concat_hist_line_number(l_line_id) into x_line_number from dual;
18194: END IF;
18195: IF l_debug_level > 0 THEN
18196: oe_debug_pub.add('*************line_number ******************'||x_line_number);
18197: END IF;
18198: COMPARE_LINE_ATTRIBUTES(p_header_id => p_header_id,
18199: p_line_id => l_line_id,
18200: p_prior_version => p_prior_version,

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

18212: ind1 := x_line_changed_attr_tbl.count;
18213: -- ind1 := ind1 + total_lines;
18214: END IF;
18215: IF l_debug_level > 0 THEN
18216: oe_debug_pub.add('*************after call total lines(trans) ******************'||ind1);
18217: END IF;
18218: END IF; /* line_id is not null */
18219: END LOOP;
18220: CLOSE C_GET_LINES;

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

18223: LOOP
18224: FETCH C_GET_HIST_LINES INTO l_line_id;
18225: EXIT WHEN C_GET_HIST_LINES%NOTFOUND;
18226: IF l_debug_level > 0 THEN
18227: oe_debug_pub.add('*************lines found******************'||l_line_id);
18228: END IF;
18229:
18230: IF l_line_id IS NOT NULL THEN
18231: IF l_debug_level > 0 THEN

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

18228: END IF;
18229:
18230: IF l_line_id IS NOT NULL THEN
18231: IF l_debug_level > 0 THEN
18232: oe_debug_pub.add('*************before call total lines ******************'||ind1);
18233: END IF;
18234: select oe_order_misc_pub.get_concat_hist_line_number(l_line_id) into x_line_number from dual;
18235: COMPARE_LINE_ATTRIBUTES(p_header_id => p_header_id,
18236: p_line_id => l_line_id,

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

18245: x_line_changed_attr_tbl => x_line_changed_attr_tbl,
18246: p_total_lines => ind1,
18247: x_line_number => x_line_number);
18248: IF l_debug_level > 0 THEN
18249: oe_debug_pub.add('*************after call total lines ******************'||ind1);
18250: END IF;
18251: IF x_line_changed_attr_tbl.count > 0 THEN
18252: ind1 := x_line_changed_attr_tbl.count;
18253: -- ind1 := ind1 + total_lines;

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

18268: x_header_scredit_rec IN OUT NOCOPY OE_Order_PUB.Header_Scredit_Rec_Type)
18269: IS
18270: l_org_id NUMBER;
18271: l_phase_change_flag VARCHAR2(1);
18272: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
18273: BEGIN
18274:
18275: IF l_debug_level > 0 THEN
18276: oe_debug_pub.add('Entering OE_VERSION_COMP.QUERY_HEADER_SC_ROW', 1);

Line 18276: oe_debug_pub.add('Entering OE_VERSION_COMP.QUERY_HEADER_SC_ROW', 1);

18272: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
18273: BEGIN
18274:
18275: IF l_debug_level > 0 THEN
18276: oe_debug_pub.add('Entering OE_VERSION_COMP.QUERY_HEADER_SC_ROW', 1);
18277: oe_debug_pub.add('header' ||p_header_id);
18278: oe_debug_pub.add('sales credit' ||p_sales_credit_id);
18279: oe_debug_pub.add('version' ||p_version);
18280: END IF;

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

18273: BEGIN
18274:
18275: IF l_debug_level > 0 THEN
18276: oe_debug_pub.add('Entering OE_VERSION_COMP.QUERY_HEADER_SC_ROW', 1);
18277: oe_debug_pub.add('header' ||p_header_id);
18278: oe_debug_pub.add('sales credit' ||p_sales_credit_id);
18279: oe_debug_pub.add('version' ||p_version);
18280: END IF;
18281:

Line 18278: oe_debug_pub.add('sales credit' ||p_sales_credit_id);

18274:
18275: IF l_debug_level > 0 THEN
18276: oe_debug_pub.add('Entering OE_VERSION_COMP.QUERY_HEADER_SC_ROW', 1);
18277: oe_debug_pub.add('header' ||p_header_id);
18278: oe_debug_pub.add('sales credit' ||p_sales_credit_id);
18279: oe_debug_pub.add('version' ||p_version);
18280: END IF;
18281:
18282: l_org_id := OE_GLOBALS.G_ORG_ID;

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

18275: IF l_debug_level > 0 THEN
18276: oe_debug_pub.add('Entering OE_VERSION_COMP.QUERY_HEADER_SC_ROW', 1);
18277: oe_debug_pub.add('header' ||p_header_id);
18278: oe_debug_pub.add('sales credit' ||p_sales_credit_id);
18279: oe_debug_pub.add('version' ||p_version);
18280: END IF;
18281:
18282: l_org_id := OE_GLOBALS.G_ORG_ID;
18283:

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

18386: x_header_scredit_rec IN OUT NOCOPY OE_Order_PUB.Header_Scredit_Rec_Type)
18387: IS
18388: l_org_id NUMBER;
18389: l_phase_change_flag VARCHAR2(1);
18390: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
18391: BEGIN
18392: IF l_debug_level > 0 THEN
18393: oe_debug_pub.add('Entering OE_VERSION_COMP.QUERY_HEADER_SC_TRANS_ROW');
18394: oe_debug_pub.add('header' ||p_header_id);

Line 18393: oe_debug_pub.add('Entering OE_VERSION_COMP.QUERY_HEADER_SC_TRANS_ROW');

18389: l_phase_change_flag VARCHAR2(1);
18390: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
18391: BEGIN
18392: IF l_debug_level > 0 THEN
18393: oe_debug_pub.add('Entering OE_VERSION_COMP.QUERY_HEADER_SC_TRANS_ROW');
18394: oe_debug_pub.add('header' ||p_header_id);
18395: oe_debug_pub.add('version' ||p_version);
18396: END IF;
18397:

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

18390: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
18391: BEGIN
18392: IF l_debug_level > 0 THEN
18393: oe_debug_pub.add('Entering OE_VERSION_COMP.QUERY_HEADER_SC_TRANS_ROW');
18394: oe_debug_pub.add('header' ||p_header_id);
18395: oe_debug_pub.add('version' ||p_version);
18396: END IF;
18397:
18398: l_org_id := OE_GLOBALS.G_ORG_ID;

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

18391: BEGIN
18392: IF l_debug_level > 0 THEN
18393: oe_debug_pub.add('Entering OE_VERSION_COMP.QUERY_HEADER_SC_TRANS_ROW');
18394: oe_debug_pub.add('header' ||p_header_id);
18395: oe_debug_pub.add('version' ||p_version);
18396: END IF;
18397:
18398: l_org_id := OE_GLOBALS.G_ORG_ID;
18399:

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

18513: v_header_col VARCHAR2(50);
18514: ind NUMBER;
18515: prior_exists VARCHAR2(1) := 'N';
18516: j NUMBER;
18517: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
18518: p_prior_rec_exists VARCHAR2(1) := 'N';
18519: p_curr_rec_exists VARCHAR2(1) := 'N';
18520: p_next_rec_exists VARCHAR2(1) := 'N';
18521: p_trans_rec_exists VARCHAR2(1) := 'N';

Line 18525: oe_debug_pub.add('Entering comparing_header_sc_attributes');

18521: p_trans_rec_exists VARCHAR2(1) := 'N';
18522: BEGIN
18523:
18524: IF l_debug_level > 0 THEN
18525: oe_debug_pub.add('Entering comparing_header_sc_attributes');
18526: oe_debug_pub.add('header' ||p_header_id);
18527: oe_debug_pub.add('Sales Credit' ||p_sales_credit_id);
18528: oe_debug_pub.add('prior version' ||p_prior_version);
18529: oe_debug_pub.add('current version' ||p_current_version);

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

18522: BEGIN
18523:
18524: IF l_debug_level > 0 THEN
18525: oe_debug_pub.add('Entering comparing_header_sc_attributes');
18526: oe_debug_pub.add('header' ||p_header_id);
18527: oe_debug_pub.add('Sales Credit' ||p_sales_credit_id);
18528: oe_debug_pub.add('prior version' ||p_prior_version);
18529: oe_debug_pub.add('current version' ||p_current_version);
18530: oe_debug_pub.add('next version' ||p_next_version);

Line 18527: oe_debug_pub.add('Sales Credit' ||p_sales_credit_id);

18523:
18524: IF l_debug_level > 0 THEN
18525: oe_debug_pub.add('Entering comparing_header_sc_attributes');
18526: oe_debug_pub.add('header' ||p_header_id);
18527: oe_debug_pub.add('Sales Credit' ||p_sales_credit_id);
18528: oe_debug_pub.add('prior version' ||p_prior_version);
18529: oe_debug_pub.add('current version' ||p_current_version);
18530: oe_debug_pub.add('next version' ||p_next_version);
18531: oe_debug_pub.add('max version' ||g_max_version);

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

18524: IF l_debug_level > 0 THEN
18525: oe_debug_pub.add('Entering comparing_header_sc_attributes');
18526: oe_debug_pub.add('header' ||p_header_id);
18527: oe_debug_pub.add('Sales Credit' ||p_sales_credit_id);
18528: oe_debug_pub.add('prior version' ||p_prior_version);
18529: oe_debug_pub.add('current version' ||p_current_version);
18530: oe_debug_pub.add('next version' ||p_next_version);
18531: oe_debug_pub.add('max version' ||g_max_version);
18532: oe_debug_pub.add('trans version' ||g_trans_version);

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

18525: oe_debug_pub.add('Entering comparing_header_sc_attributes');
18526: oe_debug_pub.add('header' ||p_header_id);
18527: oe_debug_pub.add('Sales Credit' ||p_sales_credit_id);
18528: oe_debug_pub.add('prior version' ||p_prior_version);
18529: oe_debug_pub.add('current version' ||p_current_version);
18530: oe_debug_pub.add('next version' ||p_next_version);
18531: oe_debug_pub.add('max version' ||g_max_version);
18532: oe_debug_pub.add('trans version' ||g_trans_version);
18533: END IF;

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

18526: oe_debug_pub.add('header' ||p_header_id);
18527: oe_debug_pub.add('Sales Credit' ||p_sales_credit_id);
18528: oe_debug_pub.add('prior version' ||p_prior_version);
18529: oe_debug_pub.add('current version' ||p_current_version);
18530: oe_debug_pub.add('next version' ||p_next_version);
18531: oe_debug_pub.add('max version' ||g_max_version);
18532: oe_debug_pub.add('trans version' ||g_trans_version);
18533: END IF;
18534:

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

18527: oe_debug_pub.add('Sales Credit' ||p_sales_credit_id);
18528: oe_debug_pub.add('prior version' ||p_prior_version);
18529: oe_debug_pub.add('current version' ||p_current_version);
18530: oe_debug_pub.add('next version' ||p_next_version);
18531: oe_debug_pub.add('max version' ||g_max_version);
18532: oe_debug_pub.add('trans version' ||g_trans_version);
18533: END IF;
18534:
18535: if p_total_lines > 0 THEN

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

18528: oe_debug_pub.add('prior version' ||p_prior_version);
18529: oe_debug_pub.add('current version' ||p_current_version);
18530: oe_debug_pub.add('next version' ||p_next_version);
18531: oe_debug_pub.add('max version' ||g_max_version);
18532: oe_debug_pub.add('trans version' ||g_trans_version);
18533: END IF;
18534:
18535: if p_total_lines > 0 THEN
18536: IF l_debug_level > 0 THEN

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

18533: END IF;
18534:
18535: if p_total_lines > 0 THEN
18536: IF l_debug_level > 0 THEN
18537: oe_debug_pub.add(' p_total_lines '||p_total_lines);
18538: end if;
18539: ind := p_total_lines;
18540: ELSE
18541: ind := 0;

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

18547: p_curr_rec := NULL;
18548: p_next_rec := NULL;
18549:
18550: IF l_debug_level > 0 THEN
18551: oe_debug_pub.add(' Quering prior line version details');
18552: oe_debug_pub.add('prior version' ||p_prior_version);
18553: END IF;
18554:
18555: IF p_prior_version IS NOT NULL THEN

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

18548: p_next_rec := NULL;
18549:
18550: IF l_debug_level > 0 THEN
18551: oe_debug_pub.add(' Quering prior line version details');
18552: oe_debug_pub.add('prior version' ||p_prior_version);
18553: END IF;
18554:
18555: IF p_prior_version IS NOT NULL THEN
18556: OE_VERSION_COMP.QUERY_HEADER_SC_ROW(p_header_id => p_header_id,

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

18564: p_prior_rec_exists := 'Y';
18565: END IF;
18566: END IF;
18567: IF l_debug_level > 0 THEN
18568: oe_debug_pub.add(' Quering current line version details');
18569: oe_debug_pub.add('current version' ||p_current_version);
18570: END IF;
18571:
18572: IF p_current_version IS NOT NULL THEN

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

18565: END IF;
18566: END IF;
18567: IF l_debug_level > 0 THEN
18568: oe_debug_pub.add(' Quering current line version details');
18569: oe_debug_pub.add('current version' ||p_current_version);
18570: END IF;
18571:
18572: IF p_current_version IS NOT NULL THEN
18573: OE_VERSION_COMP.QUERY_HEADER_SC_ROW(p_header_id => p_header_id,

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

18582: END IF;
18583:
18584: END IF;
18585: IF l_debug_level > 0 THEN
18586: oe_debug_pub.add(' Quering next/trans line version details');
18587: oe_debug_pub.add('next version' ||p_next_version);
18588: oe_debug_pub.add('trans version' ||g_trans_version);
18589: END IF;
18590:

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

18583:
18584: END IF;
18585: IF l_debug_level > 0 THEN
18586: oe_debug_pub.add(' Quering next/trans line version details');
18587: oe_debug_pub.add('next version' ||p_next_version);
18588: oe_debug_pub.add('trans version' ||g_trans_version);
18589: END IF;
18590:
18591: IF p_next_version = g_trans_version then

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

18584: END IF;
18585: IF l_debug_level > 0 THEN
18586: oe_debug_pub.add(' Quering next/trans line version details');
18587: oe_debug_pub.add('next version' ||p_next_version);
18588: oe_debug_pub.add('trans version' ||g_trans_version);
18589: END IF;
18590:
18591: IF p_next_version = g_trans_version then
18592: IF g_trans_version is not null then

Line 18620: oe_debug_pub.add(' p_prior_rec salesrep'||p_prior_rec.salesrep_id);

18616: END IF;
18617: END IF;
18618:
18619: IF l_debug_level > 0 THEN
18620: oe_debug_pub.add(' p_prior_rec salesrep'||p_prior_rec.salesrep_id);
18621: oe_debug_pub.add(' p_curr_rec '||p_curr_rec.salesrep_id);
18622: oe_debug_pub.add(' p_next_rec '||p_next_rec.salesrep_id);
18623: oe_debug_pub.add(' p_prior_rec sales group'||p_prior_rec.sales_group_id);
18624: oe_debug_pub.add(' p_curr_rec '||p_curr_rec.sales_group_id);

Line 18621: oe_debug_pub.add(' p_curr_rec '||p_curr_rec.salesrep_id);

18617: END IF;
18618:
18619: IF l_debug_level > 0 THEN
18620: oe_debug_pub.add(' p_prior_rec salesrep'||p_prior_rec.salesrep_id);
18621: oe_debug_pub.add(' p_curr_rec '||p_curr_rec.salesrep_id);
18622: oe_debug_pub.add(' p_next_rec '||p_next_rec.salesrep_id);
18623: oe_debug_pub.add(' p_prior_rec sales group'||p_prior_rec.sales_group_id);
18624: oe_debug_pub.add(' p_curr_rec '||p_curr_rec.sales_group_id);
18625: oe_debug_pub.add(' p_next_rec '||p_next_rec.sales_group_id);

Line 18622: oe_debug_pub.add(' p_next_rec '||p_next_rec.salesrep_id);

18618:
18619: IF l_debug_level > 0 THEN
18620: oe_debug_pub.add(' p_prior_rec salesrep'||p_prior_rec.salesrep_id);
18621: oe_debug_pub.add(' p_curr_rec '||p_curr_rec.salesrep_id);
18622: oe_debug_pub.add(' p_next_rec '||p_next_rec.salesrep_id);
18623: oe_debug_pub.add(' p_prior_rec sales group'||p_prior_rec.sales_group_id);
18624: oe_debug_pub.add(' p_curr_rec '||p_curr_rec.sales_group_id);
18625: oe_debug_pub.add(' p_next_rec '||p_next_rec.sales_group_id);
18626: oe_debug_pub.add(' checking whether salesreps are same or not');

Line 18623: oe_debug_pub.add(' p_prior_rec sales group'||p_prior_rec.sales_group_id);

18619: IF l_debug_level > 0 THEN
18620: oe_debug_pub.add(' p_prior_rec salesrep'||p_prior_rec.salesrep_id);
18621: oe_debug_pub.add(' p_curr_rec '||p_curr_rec.salesrep_id);
18622: oe_debug_pub.add(' p_next_rec '||p_next_rec.salesrep_id);
18623: oe_debug_pub.add(' p_prior_rec sales group'||p_prior_rec.sales_group_id);
18624: oe_debug_pub.add(' p_curr_rec '||p_curr_rec.sales_group_id);
18625: oe_debug_pub.add(' p_next_rec '||p_next_rec.sales_group_id);
18626: oe_debug_pub.add(' checking whether salesreps are same or not');
18627: oe_debug_pub.add(' p_prior_rec_exists'||p_prior_rec_exists);

Line 18624: oe_debug_pub.add(' p_curr_rec '||p_curr_rec.sales_group_id);

18620: oe_debug_pub.add(' p_prior_rec salesrep'||p_prior_rec.salesrep_id);
18621: oe_debug_pub.add(' p_curr_rec '||p_curr_rec.salesrep_id);
18622: oe_debug_pub.add(' p_next_rec '||p_next_rec.salesrep_id);
18623: oe_debug_pub.add(' p_prior_rec sales group'||p_prior_rec.sales_group_id);
18624: oe_debug_pub.add(' p_curr_rec '||p_curr_rec.sales_group_id);
18625: oe_debug_pub.add(' p_next_rec '||p_next_rec.sales_group_id);
18626: oe_debug_pub.add(' checking whether salesreps are same or not');
18627: oe_debug_pub.add(' p_prior_rec_exists'||p_prior_rec_exists);
18628: oe_debug_pub.add(' p_curr_rec_exists'||p_curr_rec_exists);

Line 18625: oe_debug_pub.add(' p_next_rec '||p_next_rec.sales_group_id);

18621: oe_debug_pub.add(' p_curr_rec '||p_curr_rec.salesrep_id);
18622: oe_debug_pub.add(' p_next_rec '||p_next_rec.salesrep_id);
18623: oe_debug_pub.add(' p_prior_rec sales group'||p_prior_rec.sales_group_id);
18624: oe_debug_pub.add(' p_curr_rec '||p_curr_rec.sales_group_id);
18625: oe_debug_pub.add(' p_next_rec '||p_next_rec.sales_group_id);
18626: oe_debug_pub.add(' checking whether salesreps are same or not');
18627: oe_debug_pub.add(' p_prior_rec_exists'||p_prior_rec_exists);
18628: oe_debug_pub.add(' p_curr_rec_exists'||p_curr_rec_exists);
18629: oe_debug_pub.add(' p_next_rec_exists'||p_next_rec_exists);

Line 18626: oe_debug_pub.add(' checking whether salesreps are same or not');

18622: oe_debug_pub.add(' p_next_rec '||p_next_rec.salesrep_id);
18623: oe_debug_pub.add(' p_prior_rec sales group'||p_prior_rec.sales_group_id);
18624: oe_debug_pub.add(' p_curr_rec '||p_curr_rec.sales_group_id);
18625: oe_debug_pub.add(' p_next_rec '||p_next_rec.sales_group_id);
18626: oe_debug_pub.add(' checking whether salesreps are same or not');
18627: oe_debug_pub.add(' p_prior_rec_exists'||p_prior_rec_exists);
18628: oe_debug_pub.add(' p_curr_rec_exists'||p_curr_rec_exists);
18629: oe_debug_pub.add(' p_next_rec_exists'||p_next_rec_exists);
18630: oe_debug_pub.add(' p_trans_rec_exists'||p_trans_rec_exists);

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

18623: oe_debug_pub.add(' p_prior_rec sales group'||p_prior_rec.sales_group_id);
18624: oe_debug_pub.add(' p_curr_rec '||p_curr_rec.sales_group_id);
18625: oe_debug_pub.add(' p_next_rec '||p_next_rec.sales_group_id);
18626: oe_debug_pub.add(' checking whether salesreps are same or not');
18627: oe_debug_pub.add(' p_prior_rec_exists'||p_prior_rec_exists);
18628: oe_debug_pub.add(' p_curr_rec_exists'||p_curr_rec_exists);
18629: oe_debug_pub.add(' p_next_rec_exists'||p_next_rec_exists);
18630: oe_debug_pub.add(' p_trans_rec_exists'||p_trans_rec_exists);
18631: END IF;

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

18624: oe_debug_pub.add(' p_curr_rec '||p_curr_rec.sales_group_id);
18625: oe_debug_pub.add(' p_next_rec '||p_next_rec.sales_group_id);
18626: oe_debug_pub.add(' checking whether salesreps are same or not');
18627: oe_debug_pub.add(' p_prior_rec_exists'||p_prior_rec_exists);
18628: oe_debug_pub.add(' p_curr_rec_exists'||p_curr_rec_exists);
18629: oe_debug_pub.add(' p_next_rec_exists'||p_next_rec_exists);
18630: oe_debug_pub.add(' p_trans_rec_exists'||p_trans_rec_exists);
18631: END IF;
18632: IF l_debug_level > 0 THEN

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

18625: oe_debug_pub.add(' p_next_rec '||p_next_rec.sales_group_id);
18626: oe_debug_pub.add(' checking whether salesreps are same or not');
18627: oe_debug_pub.add(' p_prior_rec_exists'||p_prior_rec_exists);
18628: oe_debug_pub.add(' p_curr_rec_exists'||p_curr_rec_exists);
18629: oe_debug_pub.add(' p_next_rec_exists'||p_next_rec_exists);
18630: oe_debug_pub.add(' p_trans_rec_exists'||p_trans_rec_exists);
18631: END IF;
18632: IF l_debug_level > 0 THEN
18633: oe_debug_pub.add('******AFTER COMPARING SC ATTRIBUTES*************');

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

18626: oe_debug_pub.add(' checking whether salesreps are same or not');
18627: oe_debug_pub.add(' p_prior_rec_exists'||p_prior_rec_exists);
18628: oe_debug_pub.add(' p_curr_rec_exists'||p_curr_rec_exists);
18629: oe_debug_pub.add(' p_next_rec_exists'||p_next_rec_exists);
18630: oe_debug_pub.add(' p_trans_rec_exists'||p_trans_rec_exists);
18631: END IF;
18632: IF l_debug_level > 0 THEN
18633: oe_debug_pub.add('******AFTER COMPARING SC ATTRIBUTES*************');
18634: oe_debug_pub.add('current ind '|| ind);

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

18629: oe_debug_pub.add(' p_next_rec_exists'||p_next_rec_exists);
18630: oe_debug_pub.add(' p_trans_rec_exists'||p_trans_rec_exists);
18631: END IF;
18632: IF l_debug_level > 0 THEN
18633: oe_debug_pub.add('******AFTER COMPARING SC ATTRIBUTES*************');
18634: oe_debug_pub.add('current ind '|| ind);
18635: END IF;
18636: IF (p_prior_rec_exists = 'Y' and p_curr_rec_exists ='Y') OR
18637: (p_curr_rec_exists = 'Y' and p_next_rec_exists ='Y') THEN

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

18630: oe_debug_pub.add(' p_trans_rec_exists'||p_trans_rec_exists);
18631: END IF;
18632: IF l_debug_level > 0 THEN
18633: oe_debug_pub.add('******AFTER COMPARING SC ATTRIBUTES*************');
18634: oe_debug_pub.add('current ind '|| ind);
18635: END IF;
18636: IF (p_prior_rec_exists = 'Y' and p_curr_rec_exists ='Y') OR
18637: (p_curr_rec_exists = 'Y' and p_next_rec_exists ='Y') THEN
18638: IF l_debug_level > 0 THEN

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

18635: END IF;
18636: IF (p_prior_rec_exists = 'Y' and p_curr_rec_exists ='Y') OR
18637: (p_curr_rec_exists = 'Y' and p_next_rec_exists ='Y') THEN
18638: IF l_debug_level > 0 THEN
18639: oe_debug_pub.add(' both exists - checking if both are same');
18640: END IF;
18641: IF OE_Globals.Equal(p_prior_rec.salesrep_id,p_curr_rec.salesrep_id) OR
18642: OE_Globals.Equal( p_curr_rec.salesrep_id, p_next_rec.salesrep_id) THEN
18643: /****************************/

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

19470: END IF;
19471: END IF; /* p and c = Y or c and n=y */
19472:
19473: IF l_debug_level > 0 THEN
19474: oe_debug_pub.add(' before finding new sales credits ');
19475: oe_debug_pub.add(' p_prior_rec_exists'||p_prior_rec_exists);
19476: oe_debug_pub.add(' p_curr_rec_exists'||p_curr_rec_exists);
19477: oe_debug_pub.add(' p_next_rec_exists'||p_next_rec_exists);
19478: oe_debug_pub.add(' p_trans_rec_exists'||p_trans_rec_exists);

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

19471: END IF; /* p and c = Y or c and n=y */
19472:
19473: IF l_debug_level > 0 THEN
19474: oe_debug_pub.add(' before finding new sales credits ');
19475: oe_debug_pub.add(' p_prior_rec_exists'||p_prior_rec_exists);
19476: oe_debug_pub.add(' p_curr_rec_exists'||p_curr_rec_exists);
19477: oe_debug_pub.add(' p_next_rec_exists'||p_next_rec_exists);
19478: oe_debug_pub.add(' p_trans_rec_exists'||p_trans_rec_exists);
19479: END IF;

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

19472:
19473: IF l_debug_level > 0 THEN
19474: oe_debug_pub.add(' before finding new sales credits ');
19475: oe_debug_pub.add(' p_prior_rec_exists'||p_prior_rec_exists);
19476: oe_debug_pub.add(' p_curr_rec_exists'||p_curr_rec_exists);
19477: oe_debug_pub.add(' p_next_rec_exists'||p_next_rec_exists);
19478: oe_debug_pub.add(' p_trans_rec_exists'||p_trans_rec_exists);
19479: END IF;
19480: IF (p_prior_rec_exists = 'N' and p_curr_rec_exists = 'Y') OR

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

19473: IF l_debug_level > 0 THEN
19474: oe_debug_pub.add(' before finding new sales credits ');
19475: oe_debug_pub.add(' p_prior_rec_exists'||p_prior_rec_exists);
19476: oe_debug_pub.add(' p_curr_rec_exists'||p_curr_rec_exists);
19477: oe_debug_pub.add(' p_next_rec_exists'||p_next_rec_exists);
19478: oe_debug_pub.add(' p_trans_rec_exists'||p_trans_rec_exists);
19479: END IF;
19480: IF (p_prior_rec_exists = 'N' and p_curr_rec_exists = 'Y') OR
19481: (p_curr_rec_exists = 'N' and p_next_rec_exists ='Y') THEN

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

19474: oe_debug_pub.add(' before finding new sales credits ');
19475: oe_debug_pub.add(' p_prior_rec_exists'||p_prior_rec_exists);
19476: oe_debug_pub.add(' p_curr_rec_exists'||p_curr_rec_exists);
19477: oe_debug_pub.add(' p_next_rec_exists'||p_next_rec_exists);
19478: oe_debug_pub.add(' p_trans_rec_exists'||p_trans_rec_exists);
19479: END IF;
19480: IF (p_prior_rec_exists = 'N' and p_curr_rec_exists = 'Y') OR
19481: (p_curr_rec_exists = 'N' and p_next_rec_exists ='Y') THEN
19482: IF p_prior_version IS NOT NULL and p_curr_rec_exists = 'Y' THEN

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

19480: IF (p_prior_rec_exists = 'N' and p_curr_rec_exists = 'Y') OR
19481: (p_curr_rec_exists = 'N' and p_next_rec_exists ='Y') THEN
19482: IF p_prior_version IS NOT NULL and p_curr_rec_exists = 'Y' THEN
19483: IF l_debug_level > 0 THEN
19484: oe_debug_pub.add(' Prior is not there - current is there');
19485: END IF;
19486: ind := ind+1;
19487: x_header_sc_changed_attr_tbl(ind).attribute_value := OE_ID_TO_VALUE.Salesrep(p_curr_rec.salesrep_id);
19488: x_header_sc_changed_attr_tbl(ind).prior_value := null;

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

19489: x_header_sc_changed_attr_tbl(ind).current_value := 'ADD';
19490: x_header_sc_changed_attr_tbl(ind).next_value := null;
19491: ELSIF (p_curr_rec_exists = 'N' and p_next_rec_exists = 'Y') THEN
19492: IF l_debug_level > 0 THEN
19493: oe_debug_pub.add(' Current is not there - next is there');
19494: END IF;
19495: ind := ind+1;
19496: x_header_sc_changed_attr_tbl(ind).attribute_value := OE_ID_TO_VALUE.Salesrep(p_next_rec.salesrep_id);
19497: x_header_sc_changed_attr_tbl(ind).prior_value := null;

Line 19504: oe_debug_pub.add(' before finding deleted salesreps');

19500: end if;
19501: END IF;
19502:
19503: IF l_debug_level > 0 THEN
19504: oe_debug_pub.add(' before finding deleted salesreps');
19505: oe_debug_pub.add(' p_prior_rec_exists'||p_prior_rec_exists);
19506: oe_debug_pub.add(' p_curr_rec_exists'||p_curr_rec_exists);
19507: oe_debug_pub.add(' p_next_rec_exists'||p_next_rec_exists);
19508: oe_debug_pub.add(' p_trans_rec_exists'||p_trans_rec_exists);

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

19501: END IF;
19502:
19503: IF l_debug_level > 0 THEN
19504: oe_debug_pub.add(' before finding deleted salesreps');
19505: oe_debug_pub.add(' p_prior_rec_exists'||p_prior_rec_exists);
19506: oe_debug_pub.add(' p_curr_rec_exists'||p_curr_rec_exists);
19507: oe_debug_pub.add(' p_next_rec_exists'||p_next_rec_exists);
19508: oe_debug_pub.add(' p_trans_rec_exists'||p_trans_rec_exists);
19509: END IF;

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

19502:
19503: IF l_debug_level > 0 THEN
19504: oe_debug_pub.add(' before finding deleted salesreps');
19505: oe_debug_pub.add(' p_prior_rec_exists'||p_prior_rec_exists);
19506: oe_debug_pub.add(' p_curr_rec_exists'||p_curr_rec_exists);
19507: oe_debug_pub.add(' p_next_rec_exists'||p_next_rec_exists);
19508: oe_debug_pub.add(' p_trans_rec_exists'||p_trans_rec_exists);
19509: END IF;
19510: IF (p_prior_rec_exists = 'Y' and p_curr_rec_exists = 'N') OR

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

19503: IF l_debug_level > 0 THEN
19504: oe_debug_pub.add(' before finding deleted salesreps');
19505: oe_debug_pub.add(' p_prior_rec_exists'||p_prior_rec_exists);
19506: oe_debug_pub.add(' p_curr_rec_exists'||p_curr_rec_exists);
19507: oe_debug_pub.add(' p_next_rec_exists'||p_next_rec_exists);
19508: oe_debug_pub.add(' p_trans_rec_exists'||p_trans_rec_exists);
19509: END IF;
19510: IF (p_prior_rec_exists = 'Y' and p_curr_rec_exists = 'N') OR
19511: (p_curr_rec_exists = 'Y' and p_next_rec_exists ='N') THEN

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

19504: oe_debug_pub.add(' before finding deleted salesreps');
19505: oe_debug_pub.add(' p_prior_rec_exists'||p_prior_rec_exists);
19506: oe_debug_pub.add(' p_curr_rec_exists'||p_curr_rec_exists);
19507: oe_debug_pub.add(' p_next_rec_exists'||p_next_rec_exists);
19508: oe_debug_pub.add(' p_trans_rec_exists'||p_trans_rec_exists);
19509: END IF;
19510: IF (p_prior_rec_exists = 'Y' and p_curr_rec_exists = 'N') OR
19511: (p_curr_rec_exists = 'Y' and p_next_rec_exists ='N') THEN
19512: IF p_prior_rec_exists = 'Y' and p_curr_rec_exists = 'N' THEN

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

19510: IF (p_prior_rec_exists = 'Y' and p_curr_rec_exists = 'N') OR
19511: (p_curr_rec_exists = 'Y' and p_next_rec_exists ='N') THEN
19512: IF p_prior_rec_exists = 'Y' and p_curr_rec_exists = 'N' THEN
19513: IF l_debug_level > 0 THEN
19514: oe_debug_pub.add(' Prior is there - current is not there');
19515: END IF;
19516: ind := ind+1;
19517: x_header_sc_changed_attr_tbl(ind).attribute_value := OE_ID_TO_VALUE.Salesrep(p_prior_rec.salesrep_id);
19518: x_header_sc_changed_attr_tbl(ind).prior_value := null;

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

19519: x_header_sc_changed_attr_tbl(ind).current_value := 'DELETE';
19520: x_header_sc_changed_attr_tbl(ind).next_value := null;
19521: ELSIF p_curr_rec_exists = 'Y' and p_next_rec_exists = 'N' THEN
19522: IF l_debug_level > 0 THEN
19523: oe_debug_pub.add(' p_next_version'||p_next_version);
19524: oe_debug_pub.add(' g_trans_version'||g_trans_version);
19525: END IF;
19526: --if p_next_version != g_trans_version THEN
19527: IF l_debug_level > 0 THEN

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

19520: x_header_sc_changed_attr_tbl(ind).next_value := null;
19521: ELSIF p_curr_rec_exists = 'Y' and p_next_rec_exists = 'N' THEN
19522: IF l_debug_level > 0 THEN
19523: oe_debug_pub.add(' p_next_version'||p_next_version);
19524: oe_debug_pub.add(' g_trans_version'||g_trans_version);
19525: END IF;
19526: --if p_next_version != g_trans_version THEN
19527: IF l_debug_level > 0 THEN
19528: oe_debug_pub.add(' Current is there - next is not there');

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

19524: oe_debug_pub.add(' g_trans_version'||g_trans_version);
19525: END IF;
19526: --if p_next_version != g_trans_version THEN
19527: IF l_debug_level > 0 THEN
19528: oe_debug_pub.add(' Current is there - next is not there');
19529: END IF;
19530: ind := ind+1;
19531: x_header_sc_changed_attr_tbl(ind).attribute_value := OE_ID_TO_VALUE.Salesrep(p_curr_rec.salesrep_id);
19532: x_header_sc_changed_attr_tbl(ind).prior_value := null;

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

19535: --end if;
19536: end if;
19537: END IF;
19538: IF l_debug_level > 0 THEN
19539: oe_debug_pub.add('******BEFORE COMPARING ATTRIBUTES*************');
19540: oe_debug_pub.add('current ind '|| ind);
19541: END IF;
19542:
19543: END IF; /* line_id not null */

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

19536: end if;
19537: END IF;
19538: IF l_debug_level > 0 THEN
19539: oe_debug_pub.add('******BEFORE COMPARING ATTRIBUTES*************');
19540: oe_debug_pub.add('current ind '|| ind);
19541: END IF;
19542:
19543: END IF; /* line_id not null */
19544: IF l_debug_level > 0 THEN

Line 19545: oe_debug_pub.add(' Exiting OE_VERSION_COMP.Compare_header_sc_Attributes ');

19541: END IF;
19542:
19543: END IF; /* line_id not null */
19544: IF l_debug_level > 0 THEN
19545: oe_debug_pub.add(' Exiting OE_VERSION_COMP.Compare_header_sc_Attributes ');
19546: END IF;
19547: /*
19548: j := 0;
19549: dbms_output.put_line('No of resales dreditcords'||x_header_sc_changed_attr_tbl.count);

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

19595: ind1 NUMBER;
19596: l_sales_credit_id NUMBER;
19597: total_lines NUMBER;
19598: x_sales_rep VARCHAR2(200);
19599: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
19600: BEGIN
19601: IF l_debug_level > 0 THEN
19602: oe_debug_pub.add('Entering Compare_header_sc_versions');
19603: oe_debug_pub.add('header' ||p_header_id);

Line 19602: oe_debug_pub.add('Entering Compare_header_sc_versions');

19598: x_sales_rep VARCHAR2(200);
19599: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
19600: BEGIN
19601: IF l_debug_level > 0 THEN
19602: oe_debug_pub.add('Entering Compare_header_sc_versions');
19603: oe_debug_pub.add('header' ||p_header_id);
19604: oe_debug_pub.add('prior version' ||p_prior_version);
19605: oe_debug_pub.add('current version' ||p_current_version);
19606: oe_debug_pub.add('next version' ||p_next_version);

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

19599: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
19600: BEGIN
19601: IF l_debug_level > 0 THEN
19602: oe_debug_pub.add('Entering Compare_header_sc_versions');
19603: oe_debug_pub.add('header' ||p_header_id);
19604: oe_debug_pub.add('prior version' ||p_prior_version);
19605: oe_debug_pub.add('current version' ||p_current_version);
19606: oe_debug_pub.add('next version' ||p_next_version);
19607: oe_debug_pub.add('max version' ||g_max_version);

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

19600: BEGIN
19601: IF l_debug_level > 0 THEN
19602: oe_debug_pub.add('Entering Compare_header_sc_versions');
19603: oe_debug_pub.add('header' ||p_header_id);
19604: oe_debug_pub.add('prior version' ||p_prior_version);
19605: oe_debug_pub.add('current version' ||p_current_version);
19606: oe_debug_pub.add('next version' ||p_next_version);
19607: oe_debug_pub.add('max version' ||g_max_version);
19608: oe_debug_pub.add('trans version' ||g_trans_version);

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

19601: IF l_debug_level > 0 THEN
19602: oe_debug_pub.add('Entering Compare_header_sc_versions');
19603: oe_debug_pub.add('header' ||p_header_id);
19604: oe_debug_pub.add('prior version' ||p_prior_version);
19605: oe_debug_pub.add('current version' ||p_current_version);
19606: oe_debug_pub.add('next version' ||p_next_version);
19607: oe_debug_pub.add('max version' ||g_max_version);
19608: oe_debug_pub.add('trans version' ||g_trans_version);
19609: END IF;

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

19602: oe_debug_pub.add('Entering Compare_header_sc_versions');
19603: oe_debug_pub.add('header' ||p_header_id);
19604: oe_debug_pub.add('prior version' ||p_prior_version);
19605: oe_debug_pub.add('current version' ||p_current_version);
19606: oe_debug_pub.add('next version' ||p_next_version);
19607: oe_debug_pub.add('max version' ||g_max_version);
19608: oe_debug_pub.add('trans version' ||g_trans_version);
19609: END IF;
19610:

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

19603: oe_debug_pub.add('header' ||p_header_id);
19604: oe_debug_pub.add('prior version' ||p_prior_version);
19605: oe_debug_pub.add('current version' ||p_current_version);
19606: oe_debug_pub.add('next version' ||p_next_version);
19607: oe_debug_pub.add('max version' ||g_max_version);
19608: oe_debug_pub.add('trans version' ||g_trans_version);
19609: END IF;
19610:
19611: ind1:=0;

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

19604: oe_debug_pub.add('prior version' ||p_prior_version);
19605: oe_debug_pub.add('current version' ||p_current_version);
19606: oe_debug_pub.add('next version' ||p_next_version);
19607: oe_debug_pub.add('max version' ||g_max_version);
19608: oe_debug_pub.add('trans version' ||g_trans_version);
19609: END IF;
19610:
19611: ind1:=0;
19612: total_lines:=0;

Line 19620: oe_debug_pub.add('*sales_credits found(trans)******'||l_sales_credit_id); END IF;

19616: LOOP
19617: FETCH C_GET_sales_credits INTO l_sales_credit_id;
19618: EXIT WHEN C_GET_sales_credits%NOTFOUND;
19619: IF l_debug_level > 0 THEN
19620: oe_debug_pub.add('*************sales_credits found(trans)******************'||l_sales_credit_id); END IF;
19621:
19622: IF l_sales_credit_id IS NOT NULL THEN
19623: IF l_debug_level > 0 THEN
19624: oe_debug_pub.add('*************before call total sales_credits(trans) ******************'||ind1);

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

19620: oe_debug_pub.add('*************sales_credits found(trans)******************'||l_sales_credit_id); END IF;
19621:
19622: IF l_sales_credit_id IS NOT NULL THEN
19623: IF l_debug_level > 0 THEN
19624: oe_debug_pub.add('*************before call total sales_credits(trans) ******************'||ind1);
19625: END IF;
19626: COMPARE_HEADER_SC_ATTRIBUTES(p_header_id => p_header_id,
19627: p_sales_credit_id => l_sales_credit_id,
19628: p_prior_version => p_prior_version,

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

19639: ind1 := x_header_sc_changed_attr_tbl.count;
19640: -- ind1 := ind1 + total_lines;
19641: END IF;
19642: IF l_debug_level > 0 THEN
19643: oe_debug_pub.add('*************after call total sales_credits(trans) ******************'||ind1);
19644: END IF;
19645: END IF; /* sales_Credit_id is not null */
19646: END LOOP;
19647: CLOSE C_GET_sales_credits;

Line 19654: oe_debug_pub.add('*sales_credits found******'||l_sales_credit_id);

19650: LOOP
19651: FETCH C_GET_HIST_sales_credits INTO l_sales_credit_id;
19652: EXIT WHEN C_GET_HIST_sales_credits%NOTFOUND;
19653: IF l_debug_level > 0 THEN
19654: oe_debug_pub.add('*************sales_credits found******************'||l_sales_credit_id);
19655: END IF;
19656:
19657: IF l_sales_credit_id IS NOT NULL THEN
19658: IF l_debug_level > 0 THEN

Line 19659: oe_debug_pub.add('*before call total sales_credits ******'||ind1);

19655: END IF;
19656:
19657: IF l_sales_credit_id IS NOT NULL THEN
19658: IF l_debug_level > 0 THEN
19659: oe_debug_pub.add('*************before call total sales_credits ******************'||ind1);
19660: END IF;
19661: COMPARE_HEADER_SC_ATTRIBUTES(p_header_id => p_header_id,
19662: p_sales_credit_id => l_sales_credit_id,
19663: p_prior_version => p_prior_version,

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

19670: g_next_phase_change_flag => g_next_phase_change_flag,
19671: x_header_sc_changed_attr_tbl => x_header_sc_changed_attr_tbl,
19672: p_total_lines => ind1);
19673: IF l_debug_level > 0 THEN
19674: oe_debug_pub.add('*************after call total sales credits ******************'||ind1);
19675: END IF;
19676: IF x_header_sc_changed_attr_tbl.count > 0 THEN
19677: ind1 := x_header_sc_changed_attr_tbl.count;
19678: -- ind1 := ind1 + total_lines;

Line 19698: oe_debug_pub.add('Entering OE_VERSION_COMP.QUERY_line_SC_ROW', 1);

19694: l_org_id NUMBER;
19695: l_phase_change_flag VARCHAR2(1);
19696: BEGIN
19697:
19698: oe_debug_pub.add('Entering OE_VERSION_COMP.QUERY_line_SC_ROW', 1);
19699:
19700: l_org_id := OE_GLOBALS.G_ORG_ID;
19701:
19702: IF l_org_id IS NULL THEN

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

19802: x_line_scredit_rec IN OUT NOCOPY OE_Order_PUB.line_Scredit_Rec_Type)
19803: IS
19804: l_org_id NUMBER;
19805: l_phase_change_flag VARCHAR2(1);
19806: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
19807: BEGIN
19808: IF l_debug_level > 0 THEN
19809: oe_debug_pub.add('Entering OE_VERSION_COMP.QUERY_line_SC_TRANS_ROW');
19810: oe_debug_pub.add('header' ||p_header_id);

Line 19809: oe_debug_pub.add('Entering OE_VERSION_COMP.QUERY_line_SC_TRANS_ROW');

19805: l_phase_change_flag VARCHAR2(1);
19806: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
19807: BEGIN
19808: IF l_debug_level > 0 THEN
19809: oe_debug_pub.add('Entering OE_VERSION_COMP.QUERY_line_SC_TRANS_ROW');
19810: oe_debug_pub.add('header' ||p_header_id);
19811: oe_debug_pub.add('version' ||p_version);
19812: END IF;
19813:

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

19806: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
19807: BEGIN
19808: IF l_debug_level > 0 THEN
19809: oe_debug_pub.add('Entering OE_VERSION_COMP.QUERY_line_SC_TRANS_ROW');
19810: oe_debug_pub.add('header' ||p_header_id);
19811: oe_debug_pub.add('version' ||p_version);
19812: END IF;
19813:
19814: l_org_id := OE_GLOBALS.G_ORG_ID;

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

19807: BEGIN
19808: IF l_debug_level > 0 THEN
19809: oe_debug_pub.add('Entering OE_VERSION_COMP.QUERY_line_SC_TRANS_ROW');
19810: oe_debug_pub.add('header' ||p_header_id);
19811: oe_debug_pub.add('version' ||p_version);
19812: END IF;
19813:
19814: l_org_id := OE_GLOBALS.G_ORG_ID;
19815:

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

19931: v_line_col VARCHAR2(50);
19932: ind NUMBER;
19933: prior_exists VARCHAR2(1) := 'N';
19934: j NUMBER;
19935: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
19936: p_prior_rec_exists VARCHAR2(1) := 'N';
19937: p_curr_rec_exists VARCHAR2(1) := 'N';
19938: p_next_rec_exists VARCHAR2(1) := 'N';
19939: p_trans_rec_exists VARCHAR2(1) := 'N';

Line 19943: oe_debug_pub.add('Entering comparing_line_sc_attributes');

19939: p_trans_rec_exists VARCHAR2(1) := 'N';
19940: BEGIN
19941:
19942: IF l_debug_level > 0 THEN
19943: oe_debug_pub.add('Entering comparing_line_sc_attributes');
19944: oe_debug_pub.add('header' ||p_header_id);
19945: oe_debug_pub.add('Sales Credit' ||p_sales_credit_id);
19946: oe_debug_pub.add('prior version' ||p_prior_version);
19947: oe_debug_pub.add('current version' ||p_current_version);

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

19940: BEGIN
19941:
19942: IF l_debug_level > 0 THEN
19943: oe_debug_pub.add('Entering comparing_line_sc_attributes');
19944: oe_debug_pub.add('header' ||p_header_id);
19945: oe_debug_pub.add('Sales Credit' ||p_sales_credit_id);
19946: oe_debug_pub.add('prior version' ||p_prior_version);
19947: oe_debug_pub.add('current version' ||p_current_version);
19948: oe_debug_pub.add('next version' ||p_next_version);

Line 19945: oe_debug_pub.add('Sales Credit' ||p_sales_credit_id);

19941:
19942: IF l_debug_level > 0 THEN
19943: oe_debug_pub.add('Entering comparing_line_sc_attributes');
19944: oe_debug_pub.add('header' ||p_header_id);
19945: oe_debug_pub.add('Sales Credit' ||p_sales_credit_id);
19946: oe_debug_pub.add('prior version' ||p_prior_version);
19947: oe_debug_pub.add('current version' ||p_current_version);
19948: oe_debug_pub.add('next version' ||p_next_version);
19949: oe_debug_pub.add('max version' ||g_max_version);

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

19942: IF l_debug_level > 0 THEN
19943: oe_debug_pub.add('Entering comparing_line_sc_attributes');
19944: oe_debug_pub.add('header' ||p_header_id);
19945: oe_debug_pub.add('Sales Credit' ||p_sales_credit_id);
19946: oe_debug_pub.add('prior version' ||p_prior_version);
19947: oe_debug_pub.add('current version' ||p_current_version);
19948: oe_debug_pub.add('next version' ||p_next_version);
19949: oe_debug_pub.add('max version' ||g_max_version);
19950: oe_debug_pub.add('trans version' ||g_trans_version);

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

19943: oe_debug_pub.add('Entering comparing_line_sc_attributes');
19944: oe_debug_pub.add('header' ||p_header_id);
19945: oe_debug_pub.add('Sales Credit' ||p_sales_credit_id);
19946: oe_debug_pub.add('prior version' ||p_prior_version);
19947: oe_debug_pub.add('current version' ||p_current_version);
19948: oe_debug_pub.add('next version' ||p_next_version);
19949: oe_debug_pub.add('max version' ||g_max_version);
19950: oe_debug_pub.add('trans version' ||g_trans_version);
19951: END IF;

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

19944: oe_debug_pub.add('header' ||p_header_id);
19945: oe_debug_pub.add('Sales Credit' ||p_sales_credit_id);
19946: oe_debug_pub.add('prior version' ||p_prior_version);
19947: oe_debug_pub.add('current version' ||p_current_version);
19948: oe_debug_pub.add('next version' ||p_next_version);
19949: oe_debug_pub.add('max version' ||g_max_version);
19950: oe_debug_pub.add('trans version' ||g_trans_version);
19951: END IF;
19952:

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

19945: oe_debug_pub.add('Sales Credit' ||p_sales_credit_id);
19946: oe_debug_pub.add('prior version' ||p_prior_version);
19947: oe_debug_pub.add('current version' ||p_current_version);
19948: oe_debug_pub.add('next version' ||p_next_version);
19949: oe_debug_pub.add('max version' ||g_max_version);
19950: oe_debug_pub.add('trans version' ||g_trans_version);
19951: END IF;
19952:
19953: if p_total_lines > 0 THEN

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

19946: oe_debug_pub.add('prior version' ||p_prior_version);
19947: oe_debug_pub.add('current version' ||p_current_version);
19948: oe_debug_pub.add('next version' ||p_next_version);
19949: oe_debug_pub.add('max version' ||g_max_version);
19950: oe_debug_pub.add('trans version' ||g_trans_version);
19951: END IF;
19952:
19953: if p_total_lines > 0 THEN
19954: IF l_debug_level > 0 THEN

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

19951: END IF;
19952:
19953: if p_total_lines > 0 THEN
19954: IF l_debug_level > 0 THEN
19955: oe_debug_pub.add(' p_total_lines '||p_total_lines);
19956: end if;
19957: ind := p_total_lines;
19958: ELSE
19959: ind := 0;

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

19965: p_curr_rec := NULL;
19966: p_next_rec := NULL;
19967:
19968: IF l_debug_level > 0 THEN
19969: oe_debug_pub.add(' Quering prior line version details');
19970: oe_debug_pub.add('prior version' ||p_prior_version);
19971: END IF;
19972:
19973: IF p_prior_version IS NOT NULL THEN

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

19966: p_next_rec := NULL;
19967:
19968: IF l_debug_level > 0 THEN
19969: oe_debug_pub.add(' Quering prior line version details');
19970: oe_debug_pub.add('prior version' ||p_prior_version);
19971: END IF;
19972:
19973: IF p_prior_version IS NOT NULL THEN
19974: OE_VERSION_COMP.QUERY_line_SC_ROW(p_header_id => p_header_id,

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

19982: p_prior_rec_exists := 'Y';
19983: END IF;
19984: END IF;
19985: IF l_debug_level > 0 THEN
19986: oe_debug_pub.add(' Quering current line version details');
19987: oe_debug_pub.add('current version' ||p_current_version);
19988: END IF;
19989:
19990: IF p_current_version IS NOT NULL THEN

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

19983: END IF;
19984: END IF;
19985: IF l_debug_level > 0 THEN
19986: oe_debug_pub.add(' Quering current line version details');
19987: oe_debug_pub.add('current version' ||p_current_version);
19988: END IF;
19989:
19990: IF p_current_version IS NOT NULL THEN
19991: OE_VERSION_COMP.QUERY_line_SC_ROW(p_header_id => p_header_id,

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

20000: END IF;
20001:
20002: END IF;
20003: IF l_debug_level > 0 THEN
20004: oe_debug_pub.add(' Quering next/trans line version details');
20005: oe_debug_pub.add('next version' ||p_next_version);
20006: oe_debug_pub.add('trans version' ||g_trans_version);
20007: END IF;
20008:

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

20001:
20002: END IF;
20003: IF l_debug_level > 0 THEN
20004: oe_debug_pub.add(' Quering next/trans line version details');
20005: oe_debug_pub.add('next version' ||p_next_version);
20006: oe_debug_pub.add('trans version' ||g_trans_version);
20007: END IF;
20008:
20009: IF p_next_version = g_trans_version then

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

20002: END IF;
20003: IF l_debug_level > 0 THEN
20004: oe_debug_pub.add(' Quering next/trans line version details');
20005: oe_debug_pub.add('next version' ||p_next_version);
20006: oe_debug_pub.add('trans version' ||g_trans_version);
20007: END IF;
20008:
20009: IF p_next_version = g_trans_version then
20010: IF g_trans_version is not null then

Line 20038: oe_debug_pub.add(' p_prior_rec salesrep'||p_prior_rec.salesrep_id);

20034: END IF;
20035: END IF;
20036:
20037: IF l_debug_level > 0 THEN
20038: oe_debug_pub.add(' p_prior_rec salesrep'||p_prior_rec.salesrep_id);
20039: oe_debug_pub.add(' p_curr_rec '||p_curr_rec.salesrep_id);
20040: oe_debug_pub.add(' p_next_rec '||p_next_rec.salesrep_id);
20041: oe_debug_pub.add(' p_prior_rec sales group'||p_prior_rec.sales_group_id);
20042: oe_debug_pub.add(' p_curr_rec '||p_curr_rec.sales_group_id);

Line 20039: oe_debug_pub.add(' p_curr_rec '||p_curr_rec.salesrep_id);

20035: END IF;
20036:
20037: IF l_debug_level > 0 THEN
20038: oe_debug_pub.add(' p_prior_rec salesrep'||p_prior_rec.salesrep_id);
20039: oe_debug_pub.add(' p_curr_rec '||p_curr_rec.salesrep_id);
20040: oe_debug_pub.add(' p_next_rec '||p_next_rec.salesrep_id);
20041: oe_debug_pub.add(' p_prior_rec sales group'||p_prior_rec.sales_group_id);
20042: oe_debug_pub.add(' p_curr_rec '||p_curr_rec.sales_group_id);
20043: oe_debug_pub.add(' p_next_rec '||p_next_rec.sales_group_id);

Line 20040: oe_debug_pub.add(' p_next_rec '||p_next_rec.salesrep_id);

20036:
20037: IF l_debug_level > 0 THEN
20038: oe_debug_pub.add(' p_prior_rec salesrep'||p_prior_rec.salesrep_id);
20039: oe_debug_pub.add(' p_curr_rec '||p_curr_rec.salesrep_id);
20040: oe_debug_pub.add(' p_next_rec '||p_next_rec.salesrep_id);
20041: oe_debug_pub.add(' p_prior_rec sales group'||p_prior_rec.sales_group_id);
20042: oe_debug_pub.add(' p_curr_rec '||p_curr_rec.sales_group_id);
20043: oe_debug_pub.add(' p_next_rec '||p_next_rec.sales_group_id);
20044: oe_debug_pub.add(' checking whether salesreps are same or not');

Line 20041: oe_debug_pub.add(' p_prior_rec sales group'||p_prior_rec.sales_group_id);

20037: IF l_debug_level > 0 THEN
20038: oe_debug_pub.add(' p_prior_rec salesrep'||p_prior_rec.salesrep_id);
20039: oe_debug_pub.add(' p_curr_rec '||p_curr_rec.salesrep_id);
20040: oe_debug_pub.add(' p_next_rec '||p_next_rec.salesrep_id);
20041: oe_debug_pub.add(' p_prior_rec sales group'||p_prior_rec.sales_group_id);
20042: oe_debug_pub.add(' p_curr_rec '||p_curr_rec.sales_group_id);
20043: oe_debug_pub.add(' p_next_rec '||p_next_rec.sales_group_id);
20044: oe_debug_pub.add(' checking whether salesreps are same or not');
20045: oe_debug_pub.add(' p_prior_rec_exists'||p_prior_rec_exists);

Line 20042: oe_debug_pub.add(' p_curr_rec '||p_curr_rec.sales_group_id);

20038: oe_debug_pub.add(' p_prior_rec salesrep'||p_prior_rec.salesrep_id);
20039: oe_debug_pub.add(' p_curr_rec '||p_curr_rec.salesrep_id);
20040: oe_debug_pub.add(' p_next_rec '||p_next_rec.salesrep_id);
20041: oe_debug_pub.add(' p_prior_rec sales group'||p_prior_rec.sales_group_id);
20042: oe_debug_pub.add(' p_curr_rec '||p_curr_rec.sales_group_id);
20043: oe_debug_pub.add(' p_next_rec '||p_next_rec.sales_group_id);
20044: oe_debug_pub.add(' checking whether salesreps are same or not');
20045: oe_debug_pub.add(' p_prior_rec_exists'||p_prior_rec_exists);
20046: oe_debug_pub.add(' p_curr_rec_exists'||p_curr_rec_exists);

Line 20043: oe_debug_pub.add(' p_next_rec '||p_next_rec.sales_group_id);

20039: oe_debug_pub.add(' p_curr_rec '||p_curr_rec.salesrep_id);
20040: oe_debug_pub.add(' p_next_rec '||p_next_rec.salesrep_id);
20041: oe_debug_pub.add(' p_prior_rec sales group'||p_prior_rec.sales_group_id);
20042: oe_debug_pub.add(' p_curr_rec '||p_curr_rec.sales_group_id);
20043: oe_debug_pub.add(' p_next_rec '||p_next_rec.sales_group_id);
20044: oe_debug_pub.add(' checking whether salesreps are same or not');
20045: oe_debug_pub.add(' p_prior_rec_exists'||p_prior_rec_exists);
20046: oe_debug_pub.add(' p_curr_rec_exists'||p_curr_rec_exists);
20047: oe_debug_pub.add(' p_next_rec_exists'||p_next_rec_exists);

Line 20044: oe_debug_pub.add(' checking whether salesreps are same or not');

20040: oe_debug_pub.add(' p_next_rec '||p_next_rec.salesrep_id);
20041: oe_debug_pub.add(' p_prior_rec sales group'||p_prior_rec.sales_group_id);
20042: oe_debug_pub.add(' p_curr_rec '||p_curr_rec.sales_group_id);
20043: oe_debug_pub.add(' p_next_rec '||p_next_rec.sales_group_id);
20044: oe_debug_pub.add(' checking whether salesreps are same or not');
20045: oe_debug_pub.add(' p_prior_rec_exists'||p_prior_rec_exists);
20046: oe_debug_pub.add(' p_curr_rec_exists'||p_curr_rec_exists);
20047: oe_debug_pub.add(' p_next_rec_exists'||p_next_rec_exists);
20048: oe_debug_pub.add(' p_trans_rec_exists'||p_trans_rec_exists);

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

20041: oe_debug_pub.add(' p_prior_rec sales group'||p_prior_rec.sales_group_id);
20042: oe_debug_pub.add(' p_curr_rec '||p_curr_rec.sales_group_id);
20043: oe_debug_pub.add(' p_next_rec '||p_next_rec.sales_group_id);
20044: oe_debug_pub.add(' checking whether salesreps are same or not');
20045: oe_debug_pub.add(' p_prior_rec_exists'||p_prior_rec_exists);
20046: oe_debug_pub.add(' p_curr_rec_exists'||p_curr_rec_exists);
20047: oe_debug_pub.add(' p_next_rec_exists'||p_next_rec_exists);
20048: oe_debug_pub.add(' p_trans_rec_exists'||p_trans_rec_exists);
20049: END IF;

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

20042: oe_debug_pub.add(' p_curr_rec '||p_curr_rec.sales_group_id);
20043: oe_debug_pub.add(' p_next_rec '||p_next_rec.sales_group_id);
20044: oe_debug_pub.add(' checking whether salesreps are same or not');
20045: oe_debug_pub.add(' p_prior_rec_exists'||p_prior_rec_exists);
20046: oe_debug_pub.add(' p_curr_rec_exists'||p_curr_rec_exists);
20047: oe_debug_pub.add(' p_next_rec_exists'||p_next_rec_exists);
20048: oe_debug_pub.add(' p_trans_rec_exists'||p_trans_rec_exists);
20049: END IF;
20050: IF (p_prior_rec_exists = 'Y' and p_curr_rec_exists ='Y') OR

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

20043: oe_debug_pub.add(' p_next_rec '||p_next_rec.sales_group_id);
20044: oe_debug_pub.add(' checking whether salesreps are same or not');
20045: oe_debug_pub.add(' p_prior_rec_exists'||p_prior_rec_exists);
20046: oe_debug_pub.add(' p_curr_rec_exists'||p_curr_rec_exists);
20047: oe_debug_pub.add(' p_next_rec_exists'||p_next_rec_exists);
20048: oe_debug_pub.add(' p_trans_rec_exists'||p_trans_rec_exists);
20049: END IF;
20050: IF (p_prior_rec_exists = 'Y' and p_curr_rec_exists ='Y') OR
20051: (p_curr_rec_exists = 'Y' and p_next_rec_exists ='Y') THEN

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

20044: oe_debug_pub.add(' checking whether salesreps are same or not');
20045: oe_debug_pub.add(' p_prior_rec_exists'||p_prior_rec_exists);
20046: oe_debug_pub.add(' p_curr_rec_exists'||p_curr_rec_exists);
20047: oe_debug_pub.add(' p_next_rec_exists'||p_next_rec_exists);
20048: oe_debug_pub.add(' p_trans_rec_exists'||p_trans_rec_exists);
20049: END IF;
20050: IF (p_prior_rec_exists = 'Y' and p_curr_rec_exists ='Y') OR
20051: (p_curr_rec_exists = 'Y' and p_next_rec_exists ='Y') THEN
20052: IF l_debug_level > 0 THEN

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

20049: END IF;
20050: IF (p_prior_rec_exists = 'Y' and p_curr_rec_exists ='Y') OR
20051: (p_curr_rec_exists = 'Y' and p_next_rec_exists ='Y') THEN
20052: IF l_debug_level > 0 THEN
20053: oe_debug_pub.add(' both exists - checking if both are same');
20054: END IF;
20055: IF OE_Globals.Equal(p_prior_rec.salesrep_id,p_curr_rec.salesrep_id) OR
20056: OE_Globals.Equal( p_curr_rec.salesrep_id, p_next_rec.salesrep_id) THEN
20057: /****************************/

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

20922: END IF;
20923: END IF; /* p and c = Y or c and n=y */
20924:
20925: IF l_debug_level > 0 THEN
20926: oe_debug_pub.add(' before finding new sales credits ');
20927: oe_debug_pub.add(' p_prior_rec_exists'||p_prior_rec_exists);
20928: oe_debug_pub.add(' p_curr_rec_exists'||p_curr_rec_exists);
20929: oe_debug_pub.add(' p_next_rec_exists'||p_next_rec_exists);
20930: oe_debug_pub.add(' p_trans_rec_exists'||p_trans_rec_exists);

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

20923: END IF; /* p and c = Y or c and n=y */
20924:
20925: IF l_debug_level > 0 THEN
20926: oe_debug_pub.add(' before finding new sales credits ');
20927: oe_debug_pub.add(' p_prior_rec_exists'||p_prior_rec_exists);
20928: oe_debug_pub.add(' p_curr_rec_exists'||p_curr_rec_exists);
20929: oe_debug_pub.add(' p_next_rec_exists'||p_next_rec_exists);
20930: oe_debug_pub.add(' p_trans_rec_exists'||p_trans_rec_exists);
20931: END IF;

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

20924:
20925: IF l_debug_level > 0 THEN
20926: oe_debug_pub.add(' before finding new sales credits ');
20927: oe_debug_pub.add(' p_prior_rec_exists'||p_prior_rec_exists);
20928: oe_debug_pub.add(' p_curr_rec_exists'||p_curr_rec_exists);
20929: oe_debug_pub.add(' p_next_rec_exists'||p_next_rec_exists);
20930: oe_debug_pub.add(' p_trans_rec_exists'||p_trans_rec_exists);
20931: END IF;
20932: IF (p_prior_rec_exists = 'N' and p_curr_rec_exists = 'Y') OR

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

20925: IF l_debug_level > 0 THEN
20926: oe_debug_pub.add(' before finding new sales credits ');
20927: oe_debug_pub.add(' p_prior_rec_exists'||p_prior_rec_exists);
20928: oe_debug_pub.add(' p_curr_rec_exists'||p_curr_rec_exists);
20929: oe_debug_pub.add(' p_next_rec_exists'||p_next_rec_exists);
20930: oe_debug_pub.add(' p_trans_rec_exists'||p_trans_rec_exists);
20931: END IF;
20932: IF (p_prior_rec_exists = 'N' and p_curr_rec_exists = 'Y') OR
20933: (p_curr_rec_exists = 'N' and p_next_rec_exists ='Y') THEN

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

20926: oe_debug_pub.add(' before finding new sales credits ');
20927: oe_debug_pub.add(' p_prior_rec_exists'||p_prior_rec_exists);
20928: oe_debug_pub.add(' p_curr_rec_exists'||p_curr_rec_exists);
20929: oe_debug_pub.add(' p_next_rec_exists'||p_next_rec_exists);
20930: oe_debug_pub.add(' p_trans_rec_exists'||p_trans_rec_exists);
20931: END IF;
20932: IF (p_prior_rec_exists = 'N' and p_curr_rec_exists = 'Y') OR
20933: (p_curr_rec_exists = 'N' and p_next_rec_exists ='Y') THEN
20934: IF p_prior_version IS NOT NULL and p_curr_rec_exists = 'Y' THEN

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

20932: IF (p_prior_rec_exists = 'N' and p_curr_rec_exists = 'Y') OR
20933: (p_curr_rec_exists = 'N' and p_next_rec_exists ='Y') THEN
20934: IF p_prior_version IS NOT NULL and p_curr_rec_exists = 'Y' THEN
20935: IF l_debug_level > 0 THEN
20936: oe_debug_pub.add(' Prior is not there - current is there');
20937: END IF;
20938: ind := ind+1;
20939: x_line_sc_changed_attr_tbl(ind).line_number := x_line_number;
20940: x_line_sc_changed_attr_tbl(ind).attribute_value := OE_ID_TO_VALUE.Salesrep(p_curr_rec.salesrep_id);

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

20942: x_line_sc_changed_attr_tbl(ind).current_value := 'ADD';
20943: x_line_sc_changed_attr_tbl(ind).next_value := null;
20944: ELSIF (p_curr_rec_exists = 'N' and p_next_rec_exists = 'Y') THEN
20945: IF l_debug_level > 0 THEN
20946: oe_debug_pub.add(' Current is not there - next is there');
20947: END IF;
20948: ind := ind+1;
20949: x_line_sc_changed_attr_tbl(ind).line_number := x_line_number;
20950: x_line_sc_changed_attr_tbl(ind).attribute_value := OE_ID_TO_VALUE.Salesrep(p_next_rec.salesrep_id);

Line 20958: oe_debug_pub.add(' before finding deleted salesreps');

20954: end if;
20955: END IF;
20956:
20957: IF l_debug_level > 0 THEN
20958: oe_debug_pub.add(' before finding deleted salesreps');
20959: oe_debug_pub.add(' p_prior_rec_exists'||p_prior_rec_exists);
20960: oe_debug_pub.add(' p_curr_rec_exists'||p_curr_rec_exists);
20961: oe_debug_pub.add(' p_next_rec_exists'||p_next_rec_exists);
20962: oe_debug_pub.add(' p_trans_rec_exists'||p_trans_rec_exists);

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

20955: END IF;
20956:
20957: IF l_debug_level > 0 THEN
20958: oe_debug_pub.add(' before finding deleted salesreps');
20959: oe_debug_pub.add(' p_prior_rec_exists'||p_prior_rec_exists);
20960: oe_debug_pub.add(' p_curr_rec_exists'||p_curr_rec_exists);
20961: oe_debug_pub.add(' p_next_rec_exists'||p_next_rec_exists);
20962: oe_debug_pub.add(' p_trans_rec_exists'||p_trans_rec_exists);
20963: END IF;

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

20956:
20957: IF l_debug_level > 0 THEN
20958: oe_debug_pub.add(' before finding deleted salesreps');
20959: oe_debug_pub.add(' p_prior_rec_exists'||p_prior_rec_exists);
20960: oe_debug_pub.add(' p_curr_rec_exists'||p_curr_rec_exists);
20961: oe_debug_pub.add(' p_next_rec_exists'||p_next_rec_exists);
20962: oe_debug_pub.add(' p_trans_rec_exists'||p_trans_rec_exists);
20963: END IF;
20964: IF (p_prior_rec_exists = 'Y' and p_curr_rec_exists = 'N') OR

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

20957: IF l_debug_level > 0 THEN
20958: oe_debug_pub.add(' before finding deleted salesreps');
20959: oe_debug_pub.add(' p_prior_rec_exists'||p_prior_rec_exists);
20960: oe_debug_pub.add(' p_curr_rec_exists'||p_curr_rec_exists);
20961: oe_debug_pub.add(' p_next_rec_exists'||p_next_rec_exists);
20962: oe_debug_pub.add(' p_trans_rec_exists'||p_trans_rec_exists);
20963: END IF;
20964: IF (p_prior_rec_exists = 'Y' and p_curr_rec_exists = 'N') OR
20965: (p_curr_rec_exists = 'Y' and p_next_rec_exists ='N') THEN

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

20958: oe_debug_pub.add(' before finding deleted salesreps');
20959: oe_debug_pub.add(' p_prior_rec_exists'||p_prior_rec_exists);
20960: oe_debug_pub.add(' p_curr_rec_exists'||p_curr_rec_exists);
20961: oe_debug_pub.add(' p_next_rec_exists'||p_next_rec_exists);
20962: oe_debug_pub.add(' p_trans_rec_exists'||p_trans_rec_exists);
20963: END IF;
20964: IF (p_prior_rec_exists = 'Y' and p_curr_rec_exists = 'N') OR
20965: (p_curr_rec_exists = 'Y' and p_next_rec_exists ='N') THEN
20966: IF p_prior_rec_exists = 'Y' and p_curr_rec_exists = 'N' THEN

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

20964: IF (p_prior_rec_exists = 'Y' and p_curr_rec_exists = 'N') OR
20965: (p_curr_rec_exists = 'Y' and p_next_rec_exists ='N') THEN
20966: IF p_prior_rec_exists = 'Y' and p_curr_rec_exists = 'N' THEN
20967: IF l_debug_level > 0 THEN
20968: oe_debug_pub.add(' Prior is there - current is not there');
20969: END IF;
20970: ind := ind+1;
20971: x_line_sc_changed_attr_tbl(ind).line_number := x_line_number;
20972: x_line_sc_changed_attr_tbl(ind).attribute_value := OE_ID_TO_VALUE.Salesrep(p_prior_rec.salesrep_id);

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

20974: x_line_sc_changed_attr_tbl(ind).current_value := 'DELETE';
20975: x_line_sc_changed_attr_tbl(ind).next_value := null;
20976: ELSIF p_curr_rec_exists = 'Y' and p_next_rec_exists = 'N' THEN
20977: IF l_debug_level > 0 THEN
20978: oe_debug_pub.add(' p_next_version'||p_next_version);
20979: oe_debug_pub.add(' g_trans_version'||g_trans_version);
20980: END IF;
20981: --if p_next_version != g_trans_version THEN
20982: IF l_debug_level > 0 THEN

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

20975: x_line_sc_changed_attr_tbl(ind).next_value := null;
20976: ELSIF p_curr_rec_exists = 'Y' and p_next_rec_exists = 'N' THEN
20977: IF l_debug_level > 0 THEN
20978: oe_debug_pub.add(' p_next_version'||p_next_version);
20979: oe_debug_pub.add(' g_trans_version'||g_trans_version);
20980: END IF;
20981: --if p_next_version != g_trans_version THEN
20982: IF l_debug_level > 0 THEN
20983: oe_debug_pub.add(' Current is there - next is not there');

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

20979: oe_debug_pub.add(' g_trans_version'||g_trans_version);
20980: END IF;
20981: --if p_next_version != g_trans_version THEN
20982: IF l_debug_level > 0 THEN
20983: oe_debug_pub.add(' Current is there - next is not there');
20984: END IF;
20985: ind := ind+1;
20986: x_line_sc_changed_attr_tbl(ind).line_number := x_line_number;
20987: x_line_sc_changed_attr_tbl(ind).attribute_value := OE_ID_TO_VALUE.Salesrep(p_curr_rec.salesrep_id);

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

20991: --end if;
20992: end if;
20993: END IF;
20994: IF l_debug_level > 0 THEN
20995: oe_debug_pub.add('******BEFORE COMPARING ATTRIBUTES*************');
20996: oe_debug_pub.add('current ind '|| ind);
20997: END IF;
20998:
20999: IF (p_prior_version IS NOT NULL and p_prior_rec_exists ='Y') OR

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

20992: end if;
20993: END IF;
20994: IF l_debug_level > 0 THEN
20995: oe_debug_pub.add('******BEFORE COMPARING ATTRIBUTES*************');
20996: oe_debug_pub.add('current ind '|| ind);
20997: END IF;
20998:
20999: IF (p_prior_version IS NOT NULL and p_prior_rec_exists ='Y') OR
21000: (p_current_version IS NOT NULL and p_curr_rec_exists ='Y') OR

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

21006: NULL;
21007: END IF;
21008: END IF; /* line_id not null */
21009: IF l_debug_level > 0 THEN
21010: oe_debug_pub.add('******AFTER COMPARING ATTRIBUTES*************');
21011: oe_debug_pub.add('current ind '|| ind);
21012: END IF;
21013: IF l_debug_level > 0 THEN
21014: oe_debug_pub.add(' Exiting OE_VERSION_COMP.Compare_line_sc_Attributes ');

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

21007: END IF;
21008: END IF; /* line_id not null */
21009: IF l_debug_level > 0 THEN
21010: oe_debug_pub.add('******AFTER COMPARING ATTRIBUTES*************');
21011: oe_debug_pub.add('current ind '|| ind);
21012: END IF;
21013: IF l_debug_level > 0 THEN
21014: oe_debug_pub.add(' Exiting OE_VERSION_COMP.Compare_line_sc_Attributes ');
21015: END IF;

Line 21014: oe_debug_pub.add(' Exiting OE_VERSION_COMP.Compare_line_sc_Attributes ');

21010: oe_debug_pub.add('******AFTER COMPARING ATTRIBUTES*************');
21011: oe_debug_pub.add('current ind '|| ind);
21012: END IF;
21013: IF l_debug_level > 0 THEN
21014: oe_debug_pub.add(' Exiting OE_VERSION_COMP.Compare_line_sc_Attributes ');
21015: END IF;
21016: /*
21017: j := 0;
21018: dbms_output.put_line('No of resales dreditcords'||x_line_sc_changed_attr_tbl.count);

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

21066: total_lines NUMBER;
21067: l_line_id NUMBER;
21068: x_sales_rep VARCHAR2(200);
21069: x_line_number VARCHAR2(30);
21070: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
21071: BEGIN
21072: IF l_debug_level > 0 THEN
21073: oe_debug_pub.add('Entering Compare_line_sc_versions');
21074: oe_debug_pub.add('header' ||p_header_id);

Line 21073: oe_debug_pub.add('Entering Compare_line_sc_versions');

21069: x_line_number VARCHAR2(30);
21070: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
21071: BEGIN
21072: IF l_debug_level > 0 THEN
21073: oe_debug_pub.add('Entering Compare_line_sc_versions');
21074: oe_debug_pub.add('header' ||p_header_id);
21075: oe_debug_pub.add('prior version' ||p_prior_version);
21076: oe_debug_pub.add('current version' ||p_current_version);
21077: oe_debug_pub.add('next version' ||p_next_version);

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

21070: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
21071: BEGIN
21072: IF l_debug_level > 0 THEN
21073: oe_debug_pub.add('Entering Compare_line_sc_versions');
21074: oe_debug_pub.add('header' ||p_header_id);
21075: oe_debug_pub.add('prior version' ||p_prior_version);
21076: oe_debug_pub.add('current version' ||p_current_version);
21077: oe_debug_pub.add('next version' ||p_next_version);
21078: oe_debug_pub.add('max version' ||g_max_version);

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

21071: BEGIN
21072: IF l_debug_level > 0 THEN
21073: oe_debug_pub.add('Entering Compare_line_sc_versions');
21074: oe_debug_pub.add('header' ||p_header_id);
21075: oe_debug_pub.add('prior version' ||p_prior_version);
21076: oe_debug_pub.add('current version' ||p_current_version);
21077: oe_debug_pub.add('next version' ||p_next_version);
21078: oe_debug_pub.add('max version' ||g_max_version);
21079: oe_debug_pub.add('trans version' ||g_trans_version);

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

21072: IF l_debug_level > 0 THEN
21073: oe_debug_pub.add('Entering Compare_line_sc_versions');
21074: oe_debug_pub.add('header' ||p_header_id);
21075: oe_debug_pub.add('prior version' ||p_prior_version);
21076: oe_debug_pub.add('current version' ||p_current_version);
21077: oe_debug_pub.add('next version' ||p_next_version);
21078: oe_debug_pub.add('max version' ||g_max_version);
21079: oe_debug_pub.add('trans version' ||g_trans_version);
21080: END IF;

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

21073: oe_debug_pub.add('Entering Compare_line_sc_versions');
21074: oe_debug_pub.add('header' ||p_header_id);
21075: oe_debug_pub.add('prior version' ||p_prior_version);
21076: oe_debug_pub.add('current version' ||p_current_version);
21077: oe_debug_pub.add('next version' ||p_next_version);
21078: oe_debug_pub.add('max version' ||g_max_version);
21079: oe_debug_pub.add('trans version' ||g_trans_version);
21080: END IF;
21081:

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

21074: oe_debug_pub.add('header' ||p_header_id);
21075: oe_debug_pub.add('prior version' ||p_prior_version);
21076: oe_debug_pub.add('current version' ||p_current_version);
21077: oe_debug_pub.add('next version' ||p_next_version);
21078: oe_debug_pub.add('max version' ||g_max_version);
21079: oe_debug_pub.add('trans version' ||g_trans_version);
21080: END IF;
21081:
21082: ind1:=0;

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

21075: oe_debug_pub.add('prior version' ||p_prior_version);
21076: oe_debug_pub.add('current version' ||p_current_version);
21077: oe_debug_pub.add('next version' ||p_next_version);
21078: oe_debug_pub.add('max version' ||g_max_version);
21079: oe_debug_pub.add('trans version' ||g_trans_version);
21080: END IF;
21081:
21082: ind1:=0;
21083: total_lines:=0;

Line 21091: oe_debug_pub.add('*sales_credits found(trans)******'||l_sales_credit_id);

21087: LOOP
21088: FETCH C_GET_sales_credits INTO l_sales_credit_id,l_line_id;
21089: EXIT WHEN C_GET_sales_credits%NOTFOUND;
21090: IF l_debug_level > 0 THEN
21091: oe_debug_pub.add('*************sales_credits found(trans)******************'||l_sales_credit_id);
21092: oe_debug_pub.add('*************sales_credits found(line_id)******************'||l_line_id);
21093: END IF;
21094:
21095: IF l_sales_credit_id IS NOT NULL THEN

Line 21092: oe_debug_pub.add('*sales_credits found(line_id)******'||l_line_id);

21088: FETCH C_GET_sales_credits INTO l_sales_credit_id,l_line_id;
21089: EXIT WHEN C_GET_sales_credits%NOTFOUND;
21090: IF l_debug_level > 0 THEN
21091: oe_debug_pub.add('*************sales_credits found(trans)******************'||l_sales_credit_id);
21092: oe_debug_pub.add('*************sales_credits found(line_id)******************'||l_line_id);
21093: END IF;
21094:
21095: IF l_sales_credit_id IS NOT NULL THEN
21096: IF l_debug_level > 0 THEN

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

21093: END IF;
21094:
21095: IF l_sales_credit_id IS NOT NULL THEN
21096: IF l_debug_level > 0 THEN
21097: oe_debug_pub.add('*************before call total sales_credits(trans) ******************'||ind1);
21098: END IF;
21099:
21100: IF l_line_id IS NOT NULL THEN
21101: select oe_order_misc_pub.get_concat_hist_line_number(l_line_id) into x_line_number from dual;

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

21121: ind1 := x_line_sc_changed_attr_tbl.count;
21122: -- ind1 := ind1 + total_lines;
21123: END IF;
21124: IF l_debug_level > 0 THEN
21125: oe_debug_pub.add('*************after call total sales_credits(trans) ******************'||ind1);
21126: END IF;
21127: END IF; /* sales_Credit_id is not null */
21128: END LOOP;
21129: CLOSE C_GET_sales_credits;

Line 21136: oe_debug_pub.add('*sales_credits found******'||l_sales_credit_id);

21132: LOOP
21133: FETCH C_GET_HIST_sales_credits INTO l_sales_credit_id,l_line_id;
21134: EXIT WHEN C_GET_HIST_sales_credits%NOTFOUND;
21135: IF l_debug_level > 0 THEN
21136: oe_debug_pub.add('*************sales_credits found******************'||l_sales_credit_id);
21137: END IF;
21138:
21139: IF l_sales_credit_id IS NOT NULL THEN
21140: IF l_debug_level > 0 THEN

Line 21141: oe_debug_pub.add('*before call total sales_credits ******'||ind1);

21137: END IF;
21138:
21139: IF l_sales_credit_id IS NOT NULL THEN
21140: IF l_debug_level > 0 THEN
21141: oe_debug_pub.add('*************before call total sales_credits ******************'||ind1);
21142: END IF;
21143: select oe_order_misc_pub.get_concat_hist_line_number(l_line_id) into x_line_number from dual;
21144: COMPARE_line_SC_ATTRIBUTES(p_header_id => p_header_id,
21145: p_sales_credit_id => l_sales_credit_id,

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

21154: x_line_sc_changed_attr_tbl => x_line_sc_changed_attr_tbl,
21155: p_total_lines => ind1,
21156: x_line_number => x_line_number);
21157: IF l_debug_level > 0 THEN
21158: oe_debug_pub.add('*************after call total sales credits ******************'||ind1);
21159: END IF;
21160: IF x_line_sc_changed_attr_tbl.count > 0 THEN
21161: ind1 := x_line_sc_changed_attr_tbl.count;
21162: -- ind1 := ind1 + total_lines;

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

21173: ) RETURN VARCHAR2
21174: IS
21175: l_line_status VARCHAR2(80) := NULL;
21176: --
21177: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
21178: --
21179: BEGIN
21180:
21181: IF p_line_status_code IS NOT NULL THEN

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

21193: EXCEPTION
21194:
21195: WHEN NO_DATA_FOUND THEN
21196: IF l_debug_level > 0 THEN
21197: oe_debug_pub.add('could not find line_status meaning');
21198: END IF;
21199: RETURN NULL;
21200: WHEN OTHERS THEN
21201: IF l_debug_level > 0 THEN

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

21198: END IF;
21199: RETURN NULL;
21200: WHEN OTHERS THEN
21201: IF l_debug_level > 0 THEN
21202: oe_debug_pub.add('others exception - line_status meaning');
21203: END IF;
21204: RETURN NULL;
21205: END line_status;
21206:

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

21218:
21219: l_attribute_value1 VARCHAR2(80);
21220: l_attribute_value2 VARCHAR2(80);
21221: --
21222: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
21223: --
21224:
21225: BEGIN
21226:

Line 21228: oe_debug_pub.add('Entering OE_VERSION_COMP.Card_Equal. ', 3);

21224:
21225: BEGIN
21226:
21227: IF l_debug_level > 0 THEN
21228: oe_debug_pub.add('Entering OE_VERSION_COMP.Card_Equal. ', 3);
21229: END IF;
21230:
21231: IF p_attribute_name = 'CREDIT_CARD_HOLDER_NAME' THEN
21232: -- instrument_id stores the card_history_change_id

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

21435: and application_column_name =p_application_column_name
21436: 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');
21437:
21438: BEGIN
21439: oe_debug_pub.add('Entering get_dff_seg_prompt');
21440: fnd_message.set_name('ONT','ONT_SLASH_SEPARATOR');
21441: slash:=FND_MESSAGE.GET;
21442:
21443: IF p_application_column_name = 'CONTEXT' THEN --Context Prompt

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

21444: select FORM_CONTEXT_PROMPT into l_prompt from FND_DESCRIPTIVE_FLEXS_VL
21445: where APPLICATION_ID = p_application_id
21446: and DESCRIPTIVE_FLEXFIELD_NAME = p_descriptive_flexfield_name;
21447:
21448: oe_debug_pub.add('Context Prompt='||l_prompt);
21449: ELSE --Attribute Prompt
21450:
21451: IF p_descriptive_flex_context_cod IS NULL
21452: AND p_desc_flex_context_cod_prior IS NULL

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

21454: select form_left_prompt into l_prompt from fnd_descr_flex_col_usage_vl where application_id=660
21455: and descriptive_flexfield_name= p_descriptive_flexfield_name
21456: and application_column_name =p_application_column_name;
21457:
21458: oe_debug_pub.add('Prompt='||l_prompt);
21459:
21460: ELSE --Context has been passed
21461: OPEN C1;
21462: LOOP

Line 21465: oe_debug_pub.add('lPrompt='||l_prompt);

21461: OPEN C1;
21462: LOOP
21463: FETCH C1 into l_prompt;
21464: exit When C1%NOTFOUND;
21465: oe_debug_pub.add('lPrompt='||l_prompt);
21466: if x_prompt IS NULL THEN
21467: x_prompt:=l_prompt;
21468: ELSIF x_prompt <> l_prompt THEN
21469: x_prompt:=x_prompt||slash||l_prompt;

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

21469: x_prompt:=x_prompt||slash||l_prompt;
21470: END IF;
21471: END LOOP;
21472: CLOSE C1;
21473: oe_debug_pub.add('Prompt='||x_prompt);
21474: RETURN(x_prompt);
21475: END IF; --Context been passed
21476: END IF; --Context/Attribute Prompt
21477: RETURN(l_prompt);

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

21478: EXCEPTION
21479: WHEN no_data_found THEN
21480: Return null;
21481: WHEN OTHERS THEN
21482: oe_debug_pub.add('error is'||SQLCODE||'message'||SQLERRM);
21483: Return Null;
21484: END get_dff_seg_prompt;
21485: --bug 4302049}
21486: