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

Line 26: oe_debug_pub.add('entering qualifier rules' );

22: l_p_QUALIFIER_RULES_rec QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type := p_QUALIFIER_RULES_rec;
23: l_old_QUALIFIER_RULES_rec QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type := p_old_QUALIFIER_RULES_rec;
24: BEGIN
25:
26: oe_debug_pub.add('entering qualifier rules' );
27: oe_debug_pub.add('operation is '||nvl(l_QUALIFIER_RULES_rec.operation,'null') );
28:
29: -- Load API control record
30:

Line 27: oe_debug_pub.add('operation is '||nvl(l_QUALIFIER_RULES_rec.operation,'null') );

23: l_old_QUALIFIER_RULES_rec QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type := p_old_QUALIFIER_RULES_rec;
24: BEGIN
25:
26: oe_debug_pub.add('entering qualifier rules' );
27: oe_debug_pub.add('operation is '||nvl(l_QUALIFIER_RULES_rec.operation,'null') );
28:
29: -- Load API control record
30:
31: l_control_rec := QP_GLOBALS.Init_Control_Rec

Line 50: --oe_debug_pub.add('setting missing old record to null');

46: l_QUALIFIER_RULES_rec.db_flag := FND_API.G_FALSE;
47:
48: -- Set missing old record elements to NULL.
49:
50: --oe_debug_pub.add('setting missing old record to null');
51:
52: l_old_QUALIFIER_RULES_rec :=
53: QP_Qualifier_Rules_Util.Convert_Miss_To_Null (l_old_QUALIFIER_RULES_rec);
54:

Line 104: --oe_debug_pub.add('executing QP_validate.attributes');

100: THEN
101:
102: IF p_validation_level > FND_API.G_VALID_LEVEL_NONE THEN
103:
104: --oe_debug_pub.add('executing QP_validate.attributes');
105: --oe_debug_pub.add('name '||l_QUALIFIER_RULES_rec.name);
106: --oe_debug_pub.add('desc '||l_QUALIFIER_RULES_rec.description);
107:
108:

Line 105: --oe_debug_pub.add('name '||l_QUALIFIER_RULES_rec.name);

101:
102: IF p_validation_level > FND_API.G_VALID_LEVEL_NONE THEN
103:
104: --oe_debug_pub.add('executing QP_validate.attributes');
105: --oe_debug_pub.add('name '||l_QUALIFIER_RULES_rec.name);
106: --oe_debug_pub.add('desc '||l_QUALIFIER_RULES_rec.description);
107:
108:
109:

Line 106: --oe_debug_pub.add('desc '||l_QUALIFIER_RULES_rec.description);

102: IF p_validation_level > FND_API.G_VALID_LEVEL_NONE THEN
103:
104: --oe_debug_pub.add('executing QP_validate.attributes');
105: --oe_debug_pub.add('name '||l_QUALIFIER_RULES_rec.name);
106: --oe_debug_pub.add('desc '||l_QUALIFIER_RULES_rec.description);
107:
108:
109:
110: --oe_debug_pub.add('from old record');

Line 110: --oe_debug_pub.add('from old record');

106: --oe_debug_pub.add('desc '||l_QUALIFIER_RULES_rec.description);
107:
108:
109:
110: --oe_debug_pub.add('from old record');
111: --oe_debug_pub.add('name '||l_old_QUALIFIER_RULES_rec.name);
112: --oe_debug_pub.add('desc '||l_old_QUALIFIER_RULES_rec.description);
113:
114: --dbms_output.put_line('calling validate attributes');

Line 111: --oe_debug_pub.add('name '||l_old_QUALIFIER_RULES_rec.name);

107:
108:
109:
110: --oe_debug_pub.add('from old record');
111: --oe_debug_pub.add('name '||l_old_QUALIFIER_RULES_rec.name);
112: --oe_debug_pub.add('desc '||l_old_QUALIFIER_RULES_rec.description);
113:
114: --dbms_output.put_line('calling validate attributes');
115:

Line 112: --oe_debug_pub.add('desc '||l_old_QUALIFIER_RULES_rec.description);

108:
109:
110: --oe_debug_pub.add('from old record');
111: --oe_debug_pub.add('name '||l_old_QUALIFIER_RULES_rec.name);
112: --oe_debug_pub.add('desc '||l_old_QUALIFIER_RULES_rec.description);
113:
114: --dbms_output.put_line('calling validate attributes');
115:
116: QP_Validate_Qualifier_Rules.Attributes

Line 124: --oe_debug_pub.add('after executing QP_validate.attributes ,status is '|| l_return_status);

120: );
121:
122:
123:
124: --oe_debug_pub.add('after executing QP_validate.attributes ,status is '|| l_return_status);
125: --dbms_output.put_line('after executing QP_validate.attributes ,status is '|| l_return_status);
126:
127:
128: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 159: oe_debug_pub.add(' executing QP_default_qualifier_rules.attributes ');

155: OR l_control_rec.change_attributes
156: THEN
157:
158:
159: oe_debug_pub.add(' executing QP_default_qualifier_rules.attributes ');
160: --dbms_output.put_line('calling default qualifier_rule attribute');
161: l_p_QUALIFIER_RULES_rec := l_QUALIFIER_RULES_rec; --added for nocopy hint
162: QP_Default_Qualifier_Rules.Attributes
163: ( p_QUALIFIER_RULES_rec => l_p_QUALIFIER_RULES_rec

Line 247: oe_debug_pub.add('calling insert row');

243: l_QUALIFIER_RULES_rec.creation_date := SYSDATE;
244: l_QUALIFIER_RULES_rec.created_by := FND_GLOBAL.USER_ID;
245:
246: --dbms_output.put_line('calling _rule insert row');
247: oe_debug_pub.add('calling insert row');
248: QP_Qualifier_Rules_Util.Insert_Row (l_QUALIFIER_RULES_rec);
249:
250: END IF;
251:

Line 263: oe_debug_pub.add('leavingqualfiier rule pricate');

259:
260: x_QUALIFIER_RULES_rec := l_QUALIFIER_RULES_rec;
261: x_old_QUALIFIER_RULES_rec := l_old_QUALIFIER_RULES_rec;
262:
263: oe_debug_pub.add('leavingqualfiier rule pricate');
264:
265:
266: EXCEPTION
267:

Line 357: oe_debug_pub.add('entering in qualifierss');

353: l_old_QUALIFIERS_tbl := p_old_QUALIFIERS_tbl;
354:
355:
356: --dbms_output.put_line('entering in loop');
357: oe_debug_pub.add('entering in qualifierss');
358: oe_debug_pub.add('entering in loop with '||l_QUALIFIERS_tbl.COUNT);
359:
360:
361: FOR I IN 1..l_QUALIFIERS_tbl.COUNT LOOP

Line 358: oe_debug_pub.add('entering in loop with '||l_QUALIFIERS_tbl.COUNT);

354:
355:
356: --dbms_output.put_line('entering in loop');
357: oe_debug_pub.add('entering in qualifierss');
358: oe_debug_pub.add('entering in loop with '||l_QUALIFIERS_tbl.COUNT);
359:
360:
361: FOR I IN 1..l_QUALIFIERS_tbl.COUNT LOOP
362: BEGIN

Line 380: oe_debug_pub.add('qualifier rule is = '||l_QUALIFIERS_rec.qualifier_rule_id);

376: END IF;
377:
378: -- Load API control record
379:
380: oe_debug_pub.add('qualifier rule is = '||l_QUALIFIERS_rec.qualifier_rule_id);
381: oe_debug_pub.add('qualifier value is = '||l_QUALIFIERS_rec.qualifier_attr_value);
382: oe_debug_pub.add('qualifier value is = '||l_QUALIFIERS_rec.qualifier_attr_value_to);
383:
384: --dbms_output.put_line('operation is '|| l_QUALIFIERS_rec.operation);

Line 381: oe_debug_pub.add('qualifier value is = '||l_QUALIFIERS_rec.qualifier_attr_value);

377:
378: -- Load API control record
379:
380: oe_debug_pub.add('qualifier rule is = '||l_QUALIFIERS_rec.qualifier_rule_id);
381: oe_debug_pub.add('qualifier value is = '||l_QUALIFIERS_rec.qualifier_attr_value);
382: oe_debug_pub.add('qualifier value is = '||l_QUALIFIERS_rec.qualifier_attr_value_to);
383:
384: --dbms_output.put_line('operation is '|| l_QUALIFIERS_rec.operation);
385:

Line 382: oe_debug_pub.add('qualifier value is = '||l_QUALIFIERS_rec.qualifier_attr_value_to);

378: -- Load API control record
379:
380: oe_debug_pub.add('qualifier rule is = '||l_QUALIFIERS_rec.qualifier_rule_id);
381: oe_debug_pub.add('qualifier value is = '||l_QUALIFIERS_rec.qualifier_attr_value);
382: oe_debug_pub.add('qualifier value is = '||l_QUALIFIERS_rec.qualifier_attr_value_to);
383:
384: --dbms_output.put_line('operation is '|| l_QUALIFIERS_rec.operation);
385:
386:

Line 406: oe_debug_pub.add('caliing miss to null');

402:
403: -- Set missing old record elements to NULL.
404:
405: --dbms_output.put_line('caliing miss to null');
406: oe_debug_pub.add('caliing miss to null');
407:
408:
409:
410:

Line 441: oe_debug_pub.add('completing new reocrd');

437: END IF;
438:
439: -- Complete new record from old
440: --dbms_output.put_line('completing record');
441: oe_debug_pub.add('completing new reocrd');
442:
443: l_QUALIFIERS_rec := QP_Qualifiers_Util.Complete_Record
444: ( p_QUALIFIERS_rec => l_QUALIFIERS_rec
445: , p_old_QUALIFIERS_rec => l_old_QUALIFIERS_rec

Line 459: oe_debug_pub.add('validating record by attributes');

455:
456: IF p_validation_level > FND_API.G_VALID_LEVEL_NONE THEN
457:
458: --dbms_output.put_line('validating record');
459: oe_debug_pub.add('validating record by attributes');
460:
461: QP_Validate_Qualifiers.Attributes
462: ( x_return_status => l_return_status
463: , p_QUALIFIERS_rec => l_QUALIFIERS_rec

Line 483: oe_debug_pub.add('clearing dependent records');

479: IF l_control_rec.change_attributes THEN
480:
481: --dbms_output.put_line('clearing dependent record');
482:
483: oe_debug_pub.add('clearing dependent records');
484:
485: l_p_QUALIFIERS_rec := l_QUALIFIERS_rec; -- added for nocopy hint
486: QP_Qualifiers_Util.Clear_Dependent_Attr
487: ( p_QUALIFIERS_rec => l_p_QUALIFIERS_rec

Line 501: oe_debug_pub.add('defaulting record');

497: OR l_control_rec.change_attributes
498: THEN
499:
500: --dbms_output.put_line('defaulting record');
501: oe_debug_pub.add('defaulting record');
502:
503:
504: l_p_QUALIFIERS_rec := l_QUALIFIERS_rec; -- added for nocopy hint
505: QP_Default_Qualifiers.Attributes

Line 519: oe_debug_pub.add('applying change attribute ');

515: OR l_control_rec.change_attributes
516: THEN
517:
518: --dbms_output.put_line('applying change attribute ');
519: oe_debug_pub.add('applying change attribute ');
520:
521:
522: l_p_QUALIFIERS_rec := l_QUALIFIERS_rec; -- added for nocopy hint
523: QP_Qualifiers_Util.Apply_Attribute_Changes

Line 535: oe_debug_pub.add('checking entity validation condition ');

531: -- Entity level validation.
532:
533: IF l_control_rec.validate_entity THEN
534:
535: oe_debug_pub.add('checking entity validation condition ');
536: oe_debug_pub.add('operation is '|| l_QUALIFIERS_rec.operation);
537: IF l_QUALIFIERS_rec.operation = QP_GLOBALS.G_OPR_DELETE THEN
538:
539: QP_Validate_Qualifiers.Entity_Delete

Line 536: oe_debug_pub.add('operation is '|| l_QUALIFIERS_rec.operation);

532:
533: IF l_control_rec.validate_entity THEN
534:
535: oe_debug_pub.add('checking entity validation condition ');
536: oe_debug_pub.add('operation is '|| l_QUALIFIERS_rec.operation);
537: IF l_QUALIFIERS_rec.operation = QP_GLOBALS.G_OPR_DELETE THEN
538:
539: QP_Validate_Qualifiers.Entity_Delete
540: ( x_return_status => l_return_status

Line 547: oe_debug_pub.add('qualifiers entity validation ');

543:
544: ELSE
545:
546: --dbms_output.put_line('qualifiers entity validation ');
547: oe_debug_pub.add('qualifiers entity validation ');
548: QP_Validate_Qualifiers.Entity
549: ( x_return_status => l_return_status
550: , p_QUALIFIERS_rec => l_QUALIFIERS_rec
551: , p_old_QUALIFIERS_rec => l_old_QUALIFIERS_rec

Line 607: oe_debug_pub.add('calling insert for qualifiers');

603: l_QUALIFIERS_rec.created_by := FND_GLOBAL.USER_ID;
604:
605:
606: --dbms_output.put_line('claiing insert');
607: oe_debug_pub.add('calling insert for qualifiers');
608:
609: QP_Qualifiers_Util.Insert_Row (l_QUALIFIERS_rec);
610:
611: END IF;

Line 807: oe_debug_pub.add('entering process qualifier rules');

803: qual_count NUMBER;
804: l_list_name VARCHAR2(240);
805: BEGIN
806:
807: oe_debug_pub.add('entering process qualifier rules');
808:
809:
810: -- Standard call to check for call compatibility
811:

Line 835: oe_debug_pub.add('calling qualifier rules');

831: l_old_QUALIFIERS_tbl := p_old_QUALIFIERS_tbl;
832:
833: -- Qualifier_Rules
834:
835: oe_debug_pub.add('calling qualifier rules');
836:
837: l_p_QUALIFIER_RULES_rec := l_QUALIFIER_RULES_rec; -- added for nocopy hint
838: l_p_old_QUALIFIER_RULES_rec := l_old_QUALIFIER_RULES_rec;
839: Qualifier_Rules

Line 849: oe_debug_pub.add('leaving qualifier rules ' ||x_QUALIFIER_RULES_rec.qualifier_rule_id);

845: , x_old_QUALIFIER_RULES_rec => l_old_QUALIFIER_RULES_rec
846: );
847:
848:
849: oe_debug_pub.add('leaving qualifier rules ' ||x_QUALIFIER_RULES_rec.qualifier_rule_id);
850:
851:
852:
853: -- Perform QUALIFIER_RULES group requests.

Line 870: oe_debug_pub.add('qualifier rec is ');

866: FOR I IN 1..l_QUALIFIERS_tbl.COUNT LOOP
867:
868: l_QUALIFIERS_rec := l_QUALIFIERS_tbl(I);
869:
870: oe_debug_pub.add('qualifier rec is ');
871: oe_debug_pub.add('id is ' || l_QUALIFIERS_rec.qualifier_id);
872: oe_debug_pub.add('context is ' || l_QUALIFIERS_rec.qualifier_context);
873: oe_debug_pub.add(' attr is ' || l_QUALIFIERS_rec.qualifier_attribute);
874: oe_debug_pub.add(' val is ' || l_QUALIFIERS_rec.qualifier_attr_value);

Line 871: oe_debug_pub.add('id is ' || l_QUALIFIERS_rec.qualifier_id);

867:
868: l_QUALIFIERS_rec := l_QUALIFIERS_tbl(I);
869:
870: oe_debug_pub.add('qualifier rec is ');
871: oe_debug_pub.add('id is ' || l_QUALIFIERS_rec.qualifier_id);
872: oe_debug_pub.add('context is ' || l_QUALIFIERS_rec.qualifier_context);
873: oe_debug_pub.add(' attr is ' || l_QUALIFIERS_rec.qualifier_attribute);
874: oe_debug_pub.add(' val is ' || l_QUALIFIERS_rec.qualifier_attr_value);
875:

Line 872: oe_debug_pub.add('context is ' || l_QUALIFIERS_rec.qualifier_context);

868: l_QUALIFIERS_rec := l_QUALIFIERS_tbl(I);
869:
870: oe_debug_pub.add('qualifier rec is ');
871: oe_debug_pub.add('id is ' || l_QUALIFIERS_rec.qualifier_id);
872: oe_debug_pub.add('context is ' || l_QUALIFIERS_rec.qualifier_context);
873: oe_debug_pub.add(' attr is ' || l_QUALIFIERS_rec.qualifier_attribute);
874: oe_debug_pub.add(' val is ' || l_QUALIFIERS_rec.qualifier_attr_value);
875:
876:

Line 873: oe_debug_pub.add(' attr is ' || l_QUALIFIERS_rec.qualifier_attribute);

869:
870: oe_debug_pub.add('qualifier rec is ');
871: oe_debug_pub.add('id is ' || l_QUALIFIERS_rec.qualifier_id);
872: oe_debug_pub.add('context is ' || l_QUALIFIERS_rec.qualifier_context);
873: oe_debug_pub.add(' attr is ' || l_QUALIFIERS_rec.qualifier_attribute);
874: oe_debug_pub.add(' val is ' || l_QUALIFIERS_rec.qualifier_attr_value);
875:
876:
877:

Line 874: oe_debug_pub.add(' val is ' || l_QUALIFIERS_rec.qualifier_attr_value);

870: oe_debug_pub.add('qualifier rec is ');
871: oe_debug_pub.add('id is ' || l_QUALIFIERS_rec.qualifier_id);
872: oe_debug_pub.add('context is ' || l_QUALIFIERS_rec.qualifier_context);
873: oe_debug_pub.add(' attr is ' || l_QUALIFIERS_rec.qualifier_attribute);
874: oe_debug_pub.add(' val is ' || l_QUALIFIERS_rec.qualifier_attr_value);
875:
876:
877:
878: IF l_QUALIFIERS_rec.operation = QP_GLOBALS.G_OPR_CREATE

Line 940: oe_debug_pub.add('calling qualifierss from process rules pvtt');

936:
937: -- Qualifierss
938:
939: --dbms_output.put_line('calling qualifierssi');
940: oe_debug_pub.add('calling qualifierss from process rules pvtt');
941: l_p_QUALIFIERS_tbl := l_QUALIFIERS_tbl; -- added for nocopy hint
942: l_p_old_QUALIFIERS_tbl := l_old_QUALIFIERS_tbl;
943: Qualifierss
944: ( p_validation_level => p_validation_level

Line 953: oe_debug_pub.add('before if delayed req for warn_same_qual_group');

949: , x_old_QUALIFIERS_tbl => l_old_QUALIFIERS_tbl
950: );
951:
952: -- Perform QUALIFIERS group requests.
953: oe_debug_pub.add('before if delayed req for warn_same_qual_group');
954:
955: IF p_control_rec.process AND
956: (p_control_rec.process_entity = QP_GLOBALS.G_ENTITY_ALL OR
957: p_control_rec.process_entity = QP_GLOBALS.G_ENTITY_QUALIFIERS)

Line 960: oe_debug_pub.add('before delayed req for warn_same_qual_group');

956: (p_control_rec.process_entity = QP_GLOBALS.G_ENTITY_ALL OR
957: p_control_rec.process_entity = QP_GLOBALS.G_ENTITY_QUALIFIERS)
958: THEN
959:
960: oe_debug_pub.add('before delayed req for warn_same_qual_group');
961:
962: --code modified by spgopal for bug 1501138
963: --warning message to be shown
964: --when a < 1 qualifier is created in same group with same

Line 980: oe_debug_pub.add('after if delayed req for warn_same_qual_group');

976: NULL;
977:
978: END IF;
979:
980: oe_debug_pub.add('after if delayed req for warn_same_qual_group');
981: oe_debug_pub.add('before if delayed req for list_qual_ind');
982: oe_debug_pub.add('before if delayed req for list_qual_ind'||p_control_rec.process_entity);
983: -- Step 6. Perform Object group logic
984:

Line 981: oe_debug_pub.add('before if delayed req for list_qual_ind');

977:
978: END IF;
979:
980: oe_debug_pub.add('after if delayed req for warn_same_qual_group');
981: oe_debug_pub.add('before if delayed req for list_qual_ind');
982: oe_debug_pub.add('before if delayed req for list_qual_ind'||p_control_rec.process_entity);
983: -- Step 6. Perform Object group logic
984:
985: IF p_control_rec.process AND

Line 982: oe_debug_pub.add('before if delayed req for list_qual_ind'||p_control_rec.process_entity);

978: END IF;
979:
980: oe_debug_pub.add('after if delayed req for warn_same_qual_group');
981: oe_debug_pub.add('before if delayed req for list_qual_ind');
982: oe_debug_pub.add('before if delayed req for list_qual_ind'||p_control_rec.process_entity);
983: -- Step 6. Perform Object group logic
984:
985: IF p_control_rec.process AND
986: p_control_rec.process_entity = QP_GLOBALS.G_ENTITY_ALL

Line 989: oe_debug_pub.add('before delayed req for list_qual_ind');

985: IF p_control_rec.process AND
986: p_control_rec.process_entity = QP_GLOBALS.G_ENTITY_ALL
987: THEN
988:
989: oe_debug_pub.add('before delayed req for list_qual_ind');
990: --code modified by spgopal for bug 1543456
991: --qualification_indicator to be updated for qualifiers
992: --created when a qualifierrule is copied in pricelist or modifier
993: -- FOR QUALIFICATION_IND

Line 1005: oe_debug_pub.add('after if delayed req for list_qual_ind');

1001: RAISE FND_API.G_EXC_ERROR;
1002: END IF;
1003:
1004: END IF;
1005: oe_debug_pub.add('after if delayed req for list_qual_ind');
1006:
1007: -- Done processing, load OUT parameters.
1008:
1009: x_QUALIFIER_RULES_rec := l_QUALIFIER_RULES_rec;

Line 1051: oe_debug_pub.add('leaving process qualifier rules');

1047: ( p_count => x_msg_count
1048: , p_data => x_msg_data
1049: );
1050:
1051: oe_debug_pub.add('leaving process qualifier rules');
1052:
1053:
1054: EXCEPTION
1055:

Line 1119: oe_debug_pub.add('in exception qualifier_rules_pvt');

1115: ( p_count => x_msg_count
1116: , p_data => x_msg_data
1117: );
1118:
1119: oe_debug_pub.add('in exception qualifier_rules_pvt');
1120: END Process_Qualifier_Rules;
1121:
1122: -- Start of Comments
1123: -- API name Lock_Qualifier_Rules

Line 1644: oe_debug_pub.add('begin create_blanket_qual'||to_char(p_old_list_header_id)||'old'||to_char(p_list_header_id)||'new');

1640: l_old_qual_count NUMBER;
1641:
1642: BEGIN
1643:
1644: oe_debug_pub.add('begin create_blanket_qual'||to_char(p_old_list_header_id)||'old'||to_char(p_list_header_id)||'new');
1645:
1646: IF p_list_header_id IS NOT NULL OR
1647: p_list_header_id <> FND_API.G_MISS_NUM THEN
1648:

Line 1651: oe_debug_pub.add('in if create : '||p_operation);

1647: p_list_header_id <> FND_API.G_MISS_NUM THEN
1648:
1649: if p_operation = QP_GLOBALS.G_OPR_CREATE then
1650:
1651: oe_debug_pub.add('in if create : '||p_operation);
1652:
1653: l_qualifiers_rec.list_header_id := p_list_header_id;
1654: l_qualifiers_rec.qualifier_attr_value := p_blanket_id;
1655: l_qualifiers_rec.qualifier_context := 'ORDER';

Line 1680: oe_debug_pub.add('in if update : '||p_operation);

1676: , x_QUALIFIERS_tbl => l_x_QUALIFIERS_tbl
1677: );
1678:
1679: elsif p_operation = OE_GLOBALS.G_OPR_UPDATE then
1680: oe_debug_pub.add('in if update : '||p_operation);
1681:
1682: if p_old_list_header_id <> p_list_header_id then
1683: oe_debug_pub.add('in else id!=id'||p_operation);
1684: delete from qp_qualifiers where

Line 1683: oe_debug_pub.add('in else id!=id'||p_operation);

1679: elsif p_operation = OE_GLOBALS.G_OPR_UPDATE then
1680: oe_debug_pub.add('in if update : '||p_operation);
1681:
1682: if p_old_list_header_id <> p_list_header_id then
1683: oe_debug_pub.add('in else id!=id'||p_operation);
1684: delete from qp_qualifiers where
1685: list_header_id = p_old_list_header_id
1686: and qualifier_context = 'ORDER'
1687: and qualifier_attribute = 'QUALIFIER_ATTRIBUTE5'

Line 1694: oe_debug_pub.add('in if id=id'||p_operation);

1690: else
1691: null;
1692: end if;
1693:
1694: oe_debug_pub.add('in if id=id'||p_operation);
1695:
1696: BEGIN
1697: select count(list_header_id) into l_qual_count
1698: from qp_qualifiers where

Line 1711: oe_debug_pub.add('in if count'||to_char(l_qual_count));

1707:
1708: END;
1709:
1710: if l_qual_count < 1 then
1711: oe_debug_pub.add('in if count'||to_char(l_qual_count));
1712: l_qualifiers_rec.list_header_id := p_list_header_id;
1713: l_qualifiers_rec.qualifier_attr_value := p_blanket_id;
1714: l_qualifiers_rec.qualifier_context := 'ORDER';
1715: l_qualifiers_rec.qualifier_attribute := 'QUALIFIER_ATTRIBUTE5';

Line 1722: oe_debug_pub.add('in else count'||to_char(l_qual_count));

1718: l_qualifiers_rec.operation := QP_GLOBALS.G_OPR_CREATE;
1719: l_qualifiers_tbl(1) := l_qualifiers_rec;
1720:
1721: else
1722: oe_debug_pub.add('in else count'||to_char(l_qual_count));
1723: null;
1724:
1725: end if; --l_qual_count<1
1726:

Line 1745: oe_debug_pub.add('in if delete : '||p_operation);

1741: , x_QUALIFIERS_tbl => l_x_QUALIFIERS_tbl
1742: );
1743:
1744: elsif p_operation = OE_GLOBALS.G_OPR_DELETE then
1745: oe_debug_pub.add('in if delete : '||p_operation);
1746:
1747: if p_old_list_header_id <> p_list_header_id then
1748: oe_debug_pub.add('in else id != id '||p_operation);
1749: delete from qp_qualifiers where

Line 1748: oe_debug_pub.add('in else id != id '||p_operation);

1744: elsif p_operation = OE_GLOBALS.G_OPR_DELETE then
1745: oe_debug_pub.add('in if delete : '||p_operation);
1746:
1747: if p_old_list_header_id <> p_list_header_id then
1748: oe_debug_pub.add('in else id != id '||p_operation);
1749: delete from qp_qualifiers where
1750: list_header_id = p_old_list_header_id
1751: and qualifier_context = 'ORDER'
1752: and qualifier_attribute = 'QUALIFIER_ATTRIBUTE5'

Line 1760: oe_debug_pub.add('in if id=id'||p_operation);

1756: null;
1757: end if;
1758:
1759: BEGIN
1760: oe_debug_pub.add('in if id=id'||p_operation);
1761: delete from qp_qualifiers where
1762: list_header_id = p_old_list_header_id
1763: and qualifier_context = 'ORDER'
1764: and qualifier_attribute = 'QUALIFIER_ATTRIBUTE5'

Line 1774: oe_debug_pub.add('end create_blanket_qual'||to_char(p_old_list_header_id)||'old'||to_char(p_list_header_id)||'new');

1770: END;
1771: end if; --operation
1772: END IF;
1773:
1774: oe_debug_pub.add('end create_blanket_qual'||to_char(p_old_list_header_id)||'old'||to_char(p_list_header_id)||'new');
1775:
1776: EXCEPTION
1777:
1778: WHEN OTHERS THEN

Line 1794: oe_debug_pub.add('exp create_blanket_qual'||to_char(p_old_list_header_id)||'old'||to_char(p_list_header_id)||'new');

1790: ( p_count => l_msg_count
1791: , p_data => l_msg_data
1792: );
1793:
1794: oe_debug_pub.add('exp create_blanket_qual'||to_char(p_old_list_header_id)||'old'||to_char(p_list_header_id)||'new');
1795:
1796: END Create_Blanket_Qualifier;
1797:
1798: END QP_Qualifier_Rules_PVT;