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

Line 90: oe_debug_pub.add('BEGIN modifier list in Private');

86: l_p_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type := p_MODIFIER_LIST_rec;
87: l_old_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type := p_old_MODIFIER_LIST_rec;
88: BEGIN
89:
90: oe_debug_pub.add('BEGIN modifier list in Private');
91: --dbms_output.put_line('BEGIN modifier list in Private');
92:
93: -- Load API control record
94:

Line 119: oe_debug_pub.add('Operation'||l_MODIFIER_LIST_rec.operation);

115: end if;
116:
117: -- Prepare record.
118:
119: oe_debug_pub.add('Operation'||l_MODIFIER_LIST_rec.operation);
120: --dbms_output.put_line('Operation'||l_MODIFIER_LIST_rec.operation);
121: IF l_MODIFIER_LIST_rec.operation = QP_GLOBALS.G_OPR_CREATE THEN
122:
123: oe_debug_pub.add('Private 01');

Line 123: oe_debug_pub.add('Private 01');

119: oe_debug_pub.add('Operation'||l_MODIFIER_LIST_rec.operation);
120: --dbms_output.put_line('Operation'||l_MODIFIER_LIST_rec.operation);
121: IF l_MODIFIER_LIST_rec.operation = QP_GLOBALS.G_OPR_CREATE THEN
122:
123: oe_debug_pub.add('Private 01');
124: --dbms_output.put_line('Private 01');
125: l_MODIFIER_LIST_rec.db_flag := FND_API.G_FALSE;
126:
127: -- Set missing old record elements to NULL.

Line 132: oe_debug_pub.add('Private 02');

128:
129: l_old_MODIFIER_LIST_rec :=
130: QP_Modifier_List_Util.Convert_Miss_To_Null (l_old_MODIFIER_LIST_rec);
131:
132: oe_debug_pub.add('Private 02');
133: --dbms_output.put_line('Private 02');
134: ELSIF l_MODIFIER_LIST_rec.operation = QP_GLOBALS.G_OPR_UPDATE
135: OR l_MODIFIER_LIST_rec.operation = QP_GLOBALS.G_OPR_DELETE
136: THEN

Line 137: OE_Debug_Pub.add('update on header');

133: --dbms_output.put_line('Private 02');
134: ELSIF l_MODIFIER_LIST_rec.operation = QP_GLOBALS.G_OPR_UPDATE
135: OR l_MODIFIER_LIST_rec.operation = QP_GLOBALS.G_OPR_DELETE
136: THEN
137: OE_Debug_Pub.add('update on header');
138: --dbms_output.put_line('update on header');
139: l_MODIFIER_LIST_rec.db_flag := FND_API.G_TRUE;
140:
141: -- Query Old if missing

Line 146: OE_Debug_Pub.add('query'||to_char(l_modifier_list_rec.list_header_id));

142:
143: IF l_old_MODIFIER_LIST_rec.list_header_id = FND_API.G_MISS_NUM
144: THEN
145:
146: OE_Debug_Pub.add('query'||to_char(l_modifier_list_rec.list_header_id));
147: --dbms_output.put_line('query'||to_char(l_modifier_list_rec.list_header_id));
148: l_old_MODIFIER_LIST_rec := QP_Modifier_List_Util.Query_Row
149: ( p_list_header_id => l_MODIFIER_LIST_rec.list_header_id
150: );

Line 152: OE_Debug_Pub.add('query'||l_modifier_list_rec.version_no);

148: l_old_MODIFIER_LIST_rec := QP_Modifier_List_Util.Query_Row
149: ( p_list_header_id => l_MODIFIER_LIST_rec.list_header_id
150: );
151:
152: OE_Debug_Pub.add('query'||l_modifier_list_rec.version_no);
153: ELSE
154:
155: -- Set missing old record elements to NULL.
156:

Line 168: OE_Debug_Pub.add('query'||l_modifier_list_rec.version_no);

164: l_MODIFIER_LIST_rec := QP_Modifier_List_Util.Complete_Record
165: ( p_MODIFIER_LIST_rec => l_MODIFIER_LIST_rec
166: , p_old_MODIFIER_LIST_rec => l_old_MODIFIER_LIST_rec
167: );
168: OE_Debug_Pub.add('query'||l_modifier_list_rec.version_no);
169:
170: END IF;
171:
172: -- Attribute level validation.

Line 174: oe_debug_pub.add('Private 03');

170: END IF;
171:
172: -- Attribute level validation.
173:
174: oe_debug_pub.add('Private 03');
175:
176: --dbms_output.put_line('just before if');
177:
178: IF l_MODIFIER_LIST_rec.operation = QP_GLOBALS.G_OPR_CREATE

Line 182: oe_debug_pub.add('in Private 03');

178: IF l_MODIFIER_LIST_rec.operation = QP_GLOBALS.G_OPR_CREATE
179: OR l_MODIFIER_LIST_rec.operation = QP_GLOBALS.G_OPR_UPDATE
180: OR l_MODIFIER_LIST_rec.operation = QP_GLOBALS.G_OPR_DELETE THEN
181:
182: oe_debug_pub.add('in Private 03');
183: IF l_control_rec.default_attributes
184: OR l_control_rec.change_attributes
185: THEN
186:

Line 187: oe_debug_pub.add('if Private 03');

183: IF l_control_rec.default_attributes
184: OR l_control_rec.change_attributes
185: THEN
186:
187: oe_debug_pub.add('if Private 03');
188: IF p_validation_level > FND_API.G_VALID_LEVEL_NONE THEN
189:
190: oe_debug_pub.add('2if Private 03');
191: OE_Debug_Pub.add('query'||l_modifier_list_rec.version_no);

Line 190: oe_debug_pub.add('2if Private 03');

186:
187: oe_debug_pub.add('if Private 03');
188: IF p_validation_level > FND_API.G_VALID_LEVEL_NONE THEN
189:
190: oe_debug_pub.add('2if Private 03');
191: OE_Debug_Pub.add('query'||l_modifier_list_rec.version_no);
192: QP_Validate_Modifier_List.Attributes
193: ( x_return_status => l_return_status
194: , p_MODIFIER_LIST_rec => l_MODIFIER_LIST_rec

Line 191: OE_Debug_Pub.add('query'||l_modifier_list_rec.version_no);

187: oe_debug_pub.add('if Private 03');
188: IF p_validation_level > FND_API.G_VALID_LEVEL_NONE THEN
189:
190: oe_debug_pub.add('2if Private 03');
191: OE_Debug_Pub.add('query'||l_modifier_list_rec.version_no);
192: QP_Validate_Modifier_List.Attributes
193: ( x_return_status => l_return_status
194: , p_MODIFIER_LIST_rec => l_MODIFIER_LIST_rec
195: , p_old_MODIFIER_LIST_rec => l_old_MODIFIER_LIST_rec

Line 198: OE_Debug_Pub.add('query'||l_modifier_list_rec.version_no);

194: , p_MODIFIER_LIST_rec => l_MODIFIER_LIST_rec
195: , p_old_MODIFIER_LIST_rec => l_old_MODIFIER_LIST_rec
196: );
197:
198: OE_Debug_Pub.add('query'||l_modifier_list_rec.version_no);
199: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
200: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
201: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
202: RAISE FND_API.G_EXC_ERROR;

Line 209: oe_debug_pub.add('Private 04');

205: END IF;
206:
207: END IF;
208:
209: oe_debug_pub.add('Private 04');
210: -- Clear dependent attributes.
211:
212: IF l_control_rec.change_attributes THEN
213:

Line 214: OE_Debug_Pub.add('query'||l_modifier_list_rec.version_no);

210: -- Clear dependent attributes.
211:
212: IF l_control_rec.change_attributes THEN
213:
214: OE_Debug_Pub.add('query'||l_modifier_list_rec.version_no);
215: l_p_MODIFIER_LIST_rec := l_MODIFIER_LIST_rec;
216: QP_Modifier_List_Util.Clear_Dependent_Attr
217: ( p_MODIFIER_LIST_rec => l_p_MODIFIER_LIST_rec
218: , p_old_MODIFIER_LIST_rec => l_old_MODIFIER_LIST_rec

Line 222: OE_Debug_Pub.add('query'||l_modifier_list_rec.version_no);

218: , p_old_MODIFIER_LIST_rec => l_old_MODIFIER_LIST_rec
219: , x_MODIFIER_LIST_rec => l_MODIFIER_LIST_rec
220: );
221:
222: OE_Debug_Pub.add('query'||l_modifier_list_rec.version_no);
223: END IF;
224:
225: oe_debug_pub.add('Private 05');
226: -- Default missing attributes

Line 225: oe_debug_pub.add('Private 05');

221:
222: OE_Debug_Pub.add('query'||l_modifier_list_rec.version_no);
223: END IF;
224:
225: oe_debug_pub.add('Private 05');
226: -- Default missing attributes
227:
228: IF l_control_rec.default_attributes
229: OR l_control_rec.change_attributes

Line 232: oe_debug_pub.add('Private 05');

228: IF l_control_rec.default_attributes
229: OR l_control_rec.change_attributes
230: THEN
231:
232: oe_debug_pub.add('Private 05');
233: l_p_MODIFIER_LIST_rec := l_MODIFIER_LIST_rec;
234: QP_Default_Modifier_List.Attributes
235: ( p_MODIFIER_LIST_rec => l_p_MODIFIER_LIST_rec
236: , x_MODIFIER_LIST_rec => l_MODIFIER_LIST_rec

Line 241: oe_debug_pub.add('Private 05.1');

237: );
238:
239: END IF;
240:
241: oe_debug_pub.add('Private 05.1');
242: -- Apply attribute changes
243:
244: IF l_control_rec.default_attributes
245: OR l_control_rec.change_attributes

Line 248: OE_Debug_Pub.add('query'||l_modifier_list_rec.version_no);

244: IF l_control_rec.default_attributes
245: OR l_control_rec.change_attributes
246: THEN
247:
248: OE_Debug_Pub.add('query'||l_modifier_list_rec.version_no);
249: l_p_MODIFIER_LIST_rec := l_MODIFIER_LIST_rec;
250: QP_Modifier_List_Util.Apply_Attribute_Changes
251: ( p_MODIFIER_LIST_rec => l_p_MODIFIER_LIST_rec
252: , p_old_MODIFIER_LIST_rec => l_old_MODIFIER_LIST_rec

Line 256: OE_Debug_Pub.add('query'||l_modifier_list_rec.version_no);

252: , p_old_MODIFIER_LIST_rec => l_old_MODIFIER_LIST_rec
253: , x_MODIFIER_LIST_rec => l_MODIFIER_LIST_rec
254: );
255:
256: OE_Debug_Pub.add('query'||l_modifier_list_rec.version_no);
257: END IF;
258:
259: -- Entity level validation.
260:

Line 272: oe_debug_pub.add('Private 06');

268: );
269:
270: ELSE
271:
272: oe_debug_pub.add('Private 06');
273: QP_Validate_Modifier_List.Entity
274: ( x_return_status => l_return_status
275: , p_MODIFIER_LIST_rec => l_MODIFIER_LIST_rec
276: , p_old_MODIFIER_LIST_rec => l_old_MODIFIER_LIST_rec

Line 278: OE_Debug_Pub.add('query'||l_modifier_list_rec.version_no);

274: ( x_return_status => l_return_status
275: , p_MODIFIER_LIST_rec => l_MODIFIER_LIST_rec
276: , p_old_MODIFIER_LIST_rec => l_old_MODIFIER_LIST_rec
277: );
278: OE_Debug_Pub.add('query'||l_modifier_list_rec.version_no);
279: null;
280:
281: END IF;
282:

Line 293: oe_debug_pub.add('Private 07');

289: END IF;
290:
291: -- Step 4. Write to DB
292:
293: oe_debug_pub.add('Private 07');
294: IF l_control_rec.write_to_db THEN
295:
296: IF l_MODIFIER_LIST_rec.operation = QP_GLOBALS.G_OPR_DELETE THEN
297:

Line 317: OE_Debug_Pub.add('query'||p_modifier_list_rec.version_no);

313: l_MODIFIER_LIST_rec.last_update_login := FND_GLOBAL.LOGIN_ID;
314:
315: IF l_MODIFIER_LIST_rec.operation = QP_GLOBALS.G_OPR_UPDATE THEN
316:
317: OE_Debug_Pub.add('query'||p_modifier_list_rec.version_no);
318: QP_Modifier_List_Util.Update_Row (l_MODIFIER_LIST_rec);
319:
320: ELSIF l_MODIFIER_LIST_rec.operation = QP_GLOBALS.G_OPR_CREATE THEN
321:

Line 341: oe_debug_pub.add('END modifier list in Private');

337:
338: x_MODIFIER_LIST_rec := l_MODIFIER_LIST_rec;
339: x_old_MODIFIER_LIST_rec := l_old_MODIFIER_LIST_rec;
340:
341: oe_debug_pub.add('END modifier list in Private');
342: --dbms_output.put_line('END modifier list in Private');
343: EXCEPTION
344:
345: WHEN FND_API.G_EXC_ERROR THEN

Line 351: oe_debug_pub.add('manoj - value of called_from_ui before delete_reqs_for_deleted_entity = ' || l_control_rec.called_from_ui);

347: l_MODIFIER_LIST_rec.return_status := FND_API.G_RET_STS_ERROR;
348: x_MODIFIER_LIST_rec := l_MODIFIER_LIST_rec;
349: x_old_MODIFIER_LIST_rec := l_old_MODIFIER_LIST_rec;
350:
351: oe_debug_pub.add('manoj - value of called_from_ui before delete_reqs_for_deleted_entity = ' || l_control_rec.called_from_ui);
352: -- mkarya If process_modifiers has been called from public package, then ONLY call
353: -- qp_delayed_requests_pvt.delete_reqs_for_deleted_entity
354: if l_control_rec.called_from_ui = 'N' then
355: qp_delayed_requests_pvt.delete_reqs_for_deleted_entity

Line 433: oe_debug_pub.add('BEGIN modifierss in Private');

429: l_pricing_phase_id number;
430:
431: BEGIN
432:
433: oe_debug_pub.add('BEGIN modifierss in Private');
434: --dbms_output.put_line('BEGIN modifierss in Private');
435: -- Init local table variables.
436:
437: l_MODIFIERS_tbl := p_MODIFIERS_tbl;

Line 573: oe_debug_pub.add('from id = '|| to_char(l_MODIFIERS_rec.from_rltd_modifier_id) );

569: END IF;
570:
571: -- Default missing attributes
572:
573: oe_debug_pub.add('from id = '|| to_char(l_MODIFIERS_rec.from_rltd_modifier_id) );
574: IF l_control_rec.default_attributes
575: OR l_control_rec.change_attributes
576: THEN
577:

Line 578: oe_debug_pub.add('before default atributeeee');

574: IF l_control_rec.default_attributes
575: OR l_control_rec.change_attributes
576: THEN
577:
578: oe_debug_pub.add('before default atributeeee');
579: l_p_MODIFIERS_rec := l_MODIFIERS_rec;
580: QP_Default_Modifiers.Attributes
581: ( p_MODIFIERS_rec => l_p_MODIFIERS_rec
582: , x_MODIFIERS_rec => l_MODIFIERS_rec

Line 587: oe_debug_pub.add('after from id = '|| to_char(l_MODIFIERS_rec.from_rltd_modifier_id) );

583: );
584:
585: END IF;
586:
587: oe_debug_pub.add('after from id = '|| to_char(l_MODIFIERS_rec.from_rltd_modifier_id) );
588: --dbms_output.put_line('here 2');
589: -- Apply attribute changes
590:
591: IF l_control_rec.default_attributes

Line 605: oe_debug_pub.add('after apply from id = '|| to_char(l_MODIFIERS_rec.from_rltd_modifier_id) );

601: END IF;
602:
603: -- Entity level validation.
604:
605: oe_debug_pub.add('after apply from id = '|| to_char(l_MODIFIERS_rec.from_rltd_modifier_id) );
606: --dbms_output.put_line('here 3');
607: IF l_control_rec.validate_entity THEN
608:
609: IF l_MODIFIERS_rec.operation = QP_GLOBALS.G_OPR_DELETE THEN

Line 628: oe_debug_pub.add('in if');

624: AND l_MODIFIERS_rec.list_line_type_code not in ('PBH', 'OID','PRG')
625: AND l_MODIFIERS_tbl(l_MODIFIERS_rec.modifier_parent_index).list_line_type_code IN ('PBH', 'OID', 'PRG')) THEN
626:
627: --dbms_output.put_line('inside if');
628: oe_debug_pub.add('in if');
629:
630: l_MODIFIERS_rec.from_rltd_modifier_id :=
631: l_MODIFIERS_tbl(l_MODIFIERS_rec.modifier_parent_index).list_line_id;
632:

Line 661: oe_debug_pub.add('after entity del from id = '|| to_char(l_MODIFIERS_rec.from_rltd_modifier_id) );

657: null;
658:
659: END IF;
660:
661: oe_debug_pub.add('after entity del from id = '|| to_char(l_MODIFIERS_rec.from_rltd_modifier_id) );
662: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
663: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
664: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
665: RAISE FND_API.G_EXC_ERROR;

Line 672: oe_debug_pub.add('Pre-write modifierss');

668: END IF;
669:
670:
671: IF l_control_rec.write_to_db THEN
672: oe_debug_pub.add('Pre-write modifierss');
673: null;
674: l_p_MODIFIERS_rec := l_MODIFIERS_rec;
675: QP_MODIFIERS_UTIL.PRE_WRITE_PROCESS
676: ( p_MODIFIERS_rec => l_p_MODIFIERS_rec

Line 686: oe_debug_pub.add('after step 4 from id = '|| to_char(l_MODIFIERS_rec.from_rltd_modifier_id) );

682:
683:
684: -- Step 4. Write to DB
685: --dbms_output.put_line('here 4');
686: oe_debug_pub.add('after step 4 from id = '|| to_char(l_MODIFIERS_rec.from_rltd_modifier_id) );
687: IF l_control_rec.write_to_db THEN
688:
689: IF l_MODIFIERS_rec.operation = QP_GLOBALS.G_OPR_DELETE THEN
690:

Line 691: oe_debug_pub.add('from id = '|| to_char(l_MODIFIERS_rec.from_rltd_modifier_id) );

687: IF l_control_rec.write_to_db THEN
688:
689: IF l_MODIFIERS_rec.operation = QP_GLOBALS.G_OPR_DELETE THEN
690:
691: oe_debug_pub.add('from id = '|| to_char(l_MODIFIERS_rec.from_rltd_modifier_id) );
692: IF l_MODIFIERS_rec.from_rltd_modifier_id = FND_API.G_MISS_NUM
693: AND l_MODIFIERS_rec.list_line_type_code <> 'PMR'
694:
695: THEN

Line 703: oe_debug_pub.add('just before deleteee');

699:
700: RAISE FND_API.G_EXC_ERROR;
701: ELSE
702:
703: oe_debug_pub.add('just before deleteee');
704: QP_Modifiers_Util.Delete_Row
705: ( p_list_line_id => l_MODIFIERS_rec.list_line_id
706: );
707:

Line 741: oe_debug_pub.add('just before update');

737: AND l_MODIFIERS_rec.rltd_modifier_grp_type IS NOT NULL
738: THEN
739:
740:
741: oe_debug_pub.add('just before update');
742:
743: QP_RLTD_MODIFIER_PVT.Update_Row(
744: l_MODIFIERS_rec.RLTD_MODIFIER_ID
745: , l_MODIFIERS_rec.creation_date

Line 788: oe_debug_pub.add('list before = ' || to_char(l_MODIFIERS_rec.list_line_id));

784: l_MODIFIERS_rec.creation_date := SYSDATE;
785: l_MODIFIERS_rec.created_by := FND_GLOBAL.USER_ID;
786:
787: --dbms_output.put_line('just before insert');
788: oe_debug_pub.add('list before = ' || to_char(l_MODIFIERS_rec.list_line_id));
789: oe_debug_pub.add('to before = ' || to_char(l_MODIFIERS_rec.to_rltd_modifier_id));
790: QP_Modifiers_Util.Insert_Row (l_MODIFIERS_rec);
791:
792: oe_debug_pub.add('from id= '||to_char(l_MODIFIERS_rec.from_rltd_modifier_id));

Line 789: oe_debug_pub.add('to before = ' || to_char(l_MODIFIERS_rec.to_rltd_modifier_id));

785: l_MODIFIERS_rec.created_by := FND_GLOBAL.USER_ID;
786:
787: --dbms_output.put_line('just before insert');
788: oe_debug_pub.add('list before = ' || to_char(l_MODIFIERS_rec.list_line_id));
789: oe_debug_pub.add('to before = ' || to_char(l_MODIFIERS_rec.to_rltd_modifier_id));
790: QP_Modifiers_Util.Insert_Row (l_MODIFIERS_rec);
791:
792: oe_debug_pub.add('from id= '||to_char(l_MODIFIERS_rec.from_rltd_modifier_id));
793: oe_debug_pub.add('grp no= '||to_char(l_MODIFIERS_rec.rltd_modifier_grp_no));

Line 792: oe_debug_pub.add('from id= '||to_char(l_MODIFIERS_rec.from_rltd_modifier_id));

788: oe_debug_pub.add('list before = ' || to_char(l_MODIFIERS_rec.list_line_id));
789: oe_debug_pub.add('to before = ' || to_char(l_MODIFIERS_rec.to_rltd_modifier_id));
790: QP_Modifiers_Util.Insert_Row (l_MODIFIERS_rec);
791:
792: oe_debug_pub.add('from id= '||to_char(l_MODIFIERS_rec.from_rltd_modifier_id));
793: oe_debug_pub.add('grp no= '||to_char(l_MODIFIERS_rec.rltd_modifier_grp_no));
794:
795:
796: -- For Coupon Issue, the to_rltd_modifier_id is the list_line_id of the benefit modifier.

Line 793: oe_debug_pub.add('grp no= '||to_char(l_MODIFIERS_rec.rltd_modifier_grp_no));

789: oe_debug_pub.add('to before = ' || to_char(l_MODIFIERS_rec.to_rltd_modifier_id));
790: QP_Modifiers_Util.Insert_Row (l_MODIFIERS_rec);
791:
792: oe_debug_pub.add('from id= '||to_char(l_MODIFIERS_rec.from_rltd_modifier_id));
793: oe_debug_pub.add('grp no= '||to_char(l_MODIFIERS_rec.rltd_modifier_grp_no));
794:
795:
796: -- For Coupon Issue, the to_rltd_modifier_id is the list_line_id of the benefit modifier.
797: -- So, to_rltd_modifier_id is passed from the form to the BOI. For all other types of

Line 813: oe_debug_pub.add('list type = ' || l_MODIFIERS_rec.list_line_type_code);

809: l_MODIFIERS_rec.to_rltd_modifier_id := l_MODIFIERS_rec.list_line_id;
810:
811: END IF;
812:
813: oe_debug_pub.add('list type = ' || l_MODIFIERS_rec.list_line_type_code);
814: oe_debug_pub.add('from = ' || to_char(l_MODIFIERS_rec.from_rltd_modifier_id));
815: oe_debug_pub.add('list after = ' || to_char(l_MODIFIERS_rec.list_line_id));
816: oe_debug_pub.add('to after = ' || to_char(l_MODIFIERS_rec.to_rltd_modifier_id));
817: oe_debug_pub.add('grp_no = ' || to_char(l_MODIFIERS_rec.rltd_modifier_grp_no));

Line 814: oe_debug_pub.add('from = ' || to_char(l_MODIFIERS_rec.from_rltd_modifier_id));

810:
811: END IF;
812:
813: oe_debug_pub.add('list type = ' || l_MODIFIERS_rec.list_line_type_code);
814: oe_debug_pub.add('from = ' || to_char(l_MODIFIERS_rec.from_rltd_modifier_id));
815: oe_debug_pub.add('list after = ' || to_char(l_MODIFIERS_rec.list_line_id));
816: oe_debug_pub.add('to after = ' || to_char(l_MODIFIERS_rec.to_rltd_modifier_id));
817: oe_debug_pub.add('grp_no = ' || to_char(l_MODIFIERS_rec.rltd_modifier_grp_no));
818: oe_debug_pub.add('grp_type = ' || l_MODIFIERS_rec.rltd_modifier_grp_type);

Line 815: oe_debug_pub.add('list after = ' || to_char(l_MODIFIERS_rec.list_line_id));

811: END IF;
812:
813: oe_debug_pub.add('list type = ' || l_MODIFIERS_rec.list_line_type_code);
814: oe_debug_pub.add('from = ' || to_char(l_MODIFIERS_rec.from_rltd_modifier_id));
815: oe_debug_pub.add('list after = ' || to_char(l_MODIFIERS_rec.list_line_id));
816: oe_debug_pub.add('to after = ' || to_char(l_MODIFIERS_rec.to_rltd_modifier_id));
817: oe_debug_pub.add('grp_no = ' || to_char(l_MODIFIERS_rec.rltd_modifier_grp_no));
818: oe_debug_pub.add('grp_type = ' || l_MODIFIERS_rec.rltd_modifier_grp_type);
819: oe_debug_pub.add('parent index = ' || l_MODIFIERS_rec.modifier_parent_index);

Line 816: oe_debug_pub.add('to after = ' || to_char(l_MODIFIERS_rec.to_rltd_modifier_id));

812:
813: oe_debug_pub.add('list type = ' || l_MODIFIERS_rec.list_line_type_code);
814: oe_debug_pub.add('from = ' || to_char(l_MODIFIERS_rec.from_rltd_modifier_id));
815: oe_debug_pub.add('list after = ' || to_char(l_MODIFIERS_rec.list_line_id));
816: oe_debug_pub.add('to after = ' || to_char(l_MODIFIERS_rec.to_rltd_modifier_id));
817: oe_debug_pub.add('grp_no = ' || to_char(l_MODIFIERS_rec.rltd_modifier_grp_no));
818: oe_debug_pub.add('grp_type = ' || l_MODIFIERS_rec.rltd_modifier_grp_type);
819: oe_debug_pub.add('parent index = ' || l_MODIFIERS_rec.modifier_parent_index);
820:

Line 817: oe_debug_pub.add('grp_no = ' || to_char(l_MODIFIERS_rec.rltd_modifier_grp_no));

813: oe_debug_pub.add('list type = ' || l_MODIFIERS_rec.list_line_type_code);
814: oe_debug_pub.add('from = ' || to_char(l_MODIFIERS_rec.from_rltd_modifier_id));
815: oe_debug_pub.add('list after = ' || to_char(l_MODIFIERS_rec.list_line_id));
816: oe_debug_pub.add('to after = ' || to_char(l_MODIFIERS_rec.to_rltd_modifier_id));
817: oe_debug_pub.add('grp_no = ' || to_char(l_MODIFIERS_rec.rltd_modifier_grp_no));
818: oe_debug_pub.add('grp_type = ' || l_MODIFIERS_rec.rltd_modifier_grp_type);
819: oe_debug_pub.add('parent index = ' || l_MODIFIERS_rec.modifier_parent_index);
820:
821:

Line 818: oe_debug_pub.add('grp_type = ' || l_MODIFIERS_rec.rltd_modifier_grp_type);

814: oe_debug_pub.add('from = ' || to_char(l_MODIFIERS_rec.from_rltd_modifier_id));
815: oe_debug_pub.add('list after = ' || to_char(l_MODIFIERS_rec.list_line_id));
816: oe_debug_pub.add('to after = ' || to_char(l_MODIFIERS_rec.to_rltd_modifier_id));
817: oe_debug_pub.add('grp_no = ' || to_char(l_MODIFIERS_rec.rltd_modifier_grp_no));
818: oe_debug_pub.add('grp_type = ' || l_MODIFIERS_rec.rltd_modifier_grp_type);
819: oe_debug_pub.add('parent index = ' || l_MODIFIERS_rec.modifier_parent_index);
820:
821:
822:

Line 819: oe_debug_pub.add('parent index = ' || l_MODIFIERS_rec.modifier_parent_index);

815: oe_debug_pub.add('list after = ' || to_char(l_MODIFIERS_rec.list_line_id));
816: oe_debug_pub.add('to after = ' || to_char(l_MODIFIERS_rec.to_rltd_modifier_id));
817: oe_debug_pub.add('grp_no = ' || to_char(l_MODIFIERS_rec.rltd_modifier_grp_no));
818: oe_debug_pub.add('grp_type = ' || l_MODIFIERS_rec.rltd_modifier_grp_type);
819: oe_debug_pub.add('parent index = ' || l_MODIFIERS_rec.modifier_parent_index);
820:
821:
822:
823: IF ((l_MODIFIERS_rec.modifier_parent_index IS NOT NULL)

Line 829: oe_debug_pub.add('in if');

825: AND l_MODIFIERS_rec.list_line_type_code not in ('PBH', 'OID','PRG')
826: AND l_MODIFIERS_tbl(l_MODIFIERS_rec.modifier_parent_index).list_line_type_code IN ('PBH', 'OID', 'PRG')) THEN
827:
828: --dbms_output.put_line('inside if');
829: oe_debug_pub.add('in if');
830:
831: l_MODIFIERS_rec.from_rltd_modifier_id :=
832: l_MODIFIERS_tbl(l_MODIFIERS_rec.modifier_parent_index).list_line_id;
833:

Line 840: oe_debug_pub.add('before insert');

836: --dbms_output.put_line('type = '||l_MODIFIERS_rec.list_line_type_code);
837: --dbms_output.put_line('from pri = '||to_char(l_MODIFIERS_rec.from_rltd_modifier_id));
838:
839:
840: oe_debug_pub.add('before insert');
841:
842: IF l_MODIFIERS_rec.from_rltd_modifier_id IS NOT NULL
843: AND l_MODIFIERS_rec.list_line_id IS NOT NULL
844: AND l_MODIFIERS_rec.rltd_modifier_grp_no IS NOT NULL

Line 852: oe_debug_pub.add('just before insert');

848: select QP_RLTD_MODIFIERS_S.nextval
849: into l_rltd_modifiers_s from dual;
850:
851:
852: oe_debug_pub.add('just before insert');
853: --dbms_output.put_line('just before insert in rltd'||nvl(to_char(l_MODIFIERS_rec.to_rltd_modifier_id), 'aaa'));
854:
855: QP_RLTD_MODIFIER_PVT.Insert_Row(
856: l_rltd_modifiers_s

Line 1035: oe_debug_pub.add('END modifierss in Private');

1031:
1032: x_MODIFIERS_tbl := l_MODIFIERS_tbl;
1033: x_old_MODIFIERS_tbl := l_old_MODIFIERS_tbl;
1034:
1035: oe_debug_pub.add('END modifierss in Private');
1036: EXCEPTION
1037:
1038: WHEN FND_API.G_EXC_ERROR THEN
1039:

Line 1082: oe_debug_pub.add('BEGIN qualifierss in Private');

1078: l_old_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
1079: l_old_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
1080: BEGIN
1081:
1082: oe_debug_pub.add('BEGIN qualifierss in Private');
1083: -- Init local table variables.
1084:
1085: l_QUALIFIERS_tbl := p_QUALIFIERS_tbl;
1086: l_old_QUALIFIERS_tbl := p_old_QUALIFIERS_tbl;

Line 1116: oe_debug_pub.add('test01');

1112: -- Prepare record.
1113:
1114: IF l_QUALIFIERS_rec.operation = QP_GLOBALS.G_OPR_CREATE THEN
1115:
1116: oe_debug_pub.add('test01');
1117: l_QUALIFIERS_rec.db_flag := FND_API.G_FALSE;
1118:
1119: -- Set missing old record elements to NULL.
1120:

Line 1150: oe_debug_pub.add('before complete rec ');

1146: END IF;
1147:
1148: -- Complete new record from old
1149:
1150: oe_debug_pub.add('before complete rec ');
1151: l_QUALIFIERS_rec := QP_Qualifiers_Util.Complete_Record
1152: ( p_QUALIFIERS_rec => l_QUALIFIERS_rec
1153: , p_old_QUALIFIERS_rec => l_old_QUALIFIERS_rec
1154: );

Line 1166: oe_debug_pub.add('before validate qual');

1162: THEN
1163:
1164: IF p_validation_level > FND_API.G_VALID_LEVEL_NONE THEN
1165:
1166: oe_debug_pub.add('before validate qual');
1167: QP_Validate_Qualifiers.Attributes
1168: ( x_return_status => l_return_status
1169: , p_QUALIFIERS_rec => l_QUALIFIERS_rec
1170: , p_old_QUALIFIERS_rec => l_old_QUALIFIERS_rec

Line 1173: oe_debug_pub.add('after validate qual');

1169: , p_QUALIFIERS_rec => l_QUALIFIERS_rec
1170: , p_old_QUALIFIERS_rec => l_old_QUALIFIERS_rec
1171: );
1172:
1173: oe_debug_pub.add('after validate qual');
1174: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1175: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1176: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1177: RAISE FND_API.G_EXC_ERROR;

Line 1184: oe_debug_pub.add('before util clear');

1180: END IF;
1181:
1182: END IF;
1183:
1184: oe_debug_pub.add('before util clear');
1185: -- Clear dependent attributes.
1186:
1187: IF l_control_rec.change_attributes THEN
1188:

Line 1189: oe_debug_pub.add('before clear depen');

1185: -- Clear dependent attributes.
1186:
1187: IF l_control_rec.change_attributes THEN
1188:
1189: oe_debug_pub.add('before clear depen');
1190: l_p_QUALIFIERS_rec := l_QUALIFIERS_rec;
1191: QP_Qualifiers_Util.Clear_Dependent_Attr
1192: ( p_QUALIFIERS_rec => l_p_QUALIFIERS_rec
1193: , p_old_QUALIFIERS_rec => l_old_QUALIFIERS_rec

Line 1199: oe_debug_pub.add('before default attrib');

1195: );
1196:
1197: END IF;
1198:
1199: oe_debug_pub.add('before default attrib');
1200: -- Default missing attributes
1201:
1202: IF l_control_rec.default_attributes
1203: OR l_control_rec.change_attributes

Line 1215: oe_debug_pub.add('before util');

1211: END IF;
1212:
1213: -- Apply attribute changes
1214:
1215: oe_debug_pub.add('before util');
1216: IF l_control_rec.default_attributes
1217: OR l_control_rec.change_attributes
1218: THEN
1219: l_p_QUALIFIERS_rec := l_QUALIFIERS_rec;

Line 1241: oe_debug_pub.add('before entity validate');

1237: );
1238:
1239: ELSE
1240:
1241: oe_debug_pub.add('before entity validate');
1242: QP_Validate_Qualifiers.Entity
1243: ( x_return_status => l_return_status
1244: , p_QUALIFIERS_rec => l_QUALIFIERS_rec
1245: , p_old_QUALIFIERS_rec => l_old_QUALIFIERS_rec

Line 1249: oe_debug_pub.add('after entity validate');

1245: , p_old_QUALIFIERS_rec => l_old_QUALIFIERS_rec
1246: );
1247:
1248: END IF;
1249: oe_debug_pub.add('after entity validate');
1250:
1251: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1252: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1253: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

Line 1256: oe_debug_pub.add('after entity validate end if');

1252: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1253: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1254: RAISE FND_API.G_EXC_ERROR;
1255: END IF;
1256: oe_debug_pub.add('after entity validate end if');
1257:
1258: END IF;
1259:
1260: -- Step 3.5. Perform action which need to be performed before

Line 1299: oe_debug_pub.add('util . Insert');

1295:
1296: l_QUALIFIERS_rec.creation_date := SYSDATE;
1297: l_QUALIFIERS_rec.created_by := FND_GLOBAL.USER_ID;
1298:
1299: oe_debug_pub.add('util . Insert');
1300: QP_Qualifiers_Util.Insert_Row (l_QUALIFIERS_rec);
1301:
1302: END IF;
1303:

Line 1408: oe_debug_pub.add('exp loop ');

1404: end if;
1405:
1406: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1407:
1408: oe_debug_pub.add('exp loop ');
1409: END;
1410: END LOOP;
1411:
1412: -- Load OUT parameters

Line 1417: oe_debug_pub.add('END qualifierss in Private');

1413:
1414: x_QUALIFIERS_tbl := l_QUALIFIERS_tbl;
1415: x_old_QUALIFIERS_tbl := l_old_QUALIFIERS_tbl;
1416:
1417: oe_debug_pub.add('END qualifierss in Private');
1418: EXCEPTION
1419:
1420: WHEN FND_API.G_EXC_ERROR THEN
1421:

Line 1442: oe_debug_pub.add('EXP qualifierss in Private');

1438:
1439:
1440: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1441:
1442: oe_debug_pub.add('EXP qualifierss in Private');
1443: END Qualifierss;
1444:
1445: -- Pricing_Attrs
1446:

Line 1477: oe_debug_pub.add('BEGIN pricing_attrs in Private');

1473: l_old_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;
1474: l_continuous_price_break_flag VARCHAR2(1); --Continuous Price Breaks
1475: BEGIN
1476:
1477: oe_debug_pub.add('BEGIN pricing_attrs in Private');
1478: -- Init local table variables.
1479:
1480: l_PRICING_ATTR_tbl := p_PRICING_ATTR_tbl;
1481: l_old_PRICING_ATTR_tbl := p_old_PRICING_ATTR_tbl;

Line 1509: oe_debug_pub.add('oper = '|| l_PRICING_ATTR_rec.operation );

1505: l_PRICING_ATTR_rec.return_status := FND_API.G_RET_STS_SUCCESS;
1506:
1507: -- Prepare record.
1508:
1509: oe_debug_pub.add('oper = '|| l_PRICING_ATTR_rec.operation );
1510:
1511: IF l_PRICING_ATTR_rec.operation = QP_GLOBALS.G_OPR_CREATE THEN
1512:
1513: l_PRICING_ATTR_rec.db_flag := FND_API.G_FALSE;

Line 1531: oe_debug_pub.add('before query');

1527:
1528: IF l_old_PRICING_ATTR_rec.pricing_attribute_id = FND_API.G_MISS_NUM
1529: THEN
1530:
1531: oe_debug_pub.add('before query');
1532: l_old_PRICING_ATTR_rec := QP_Pricing_Attr_Util.Query_Row
1533: ( p_pricing_attribute_id => l_PRICING_ATTR_rec.pricing_attribute_id
1534: );
1535:

Line 1547: oe_debug_pub.add('1111');

1543: END IF;
1544:
1545: -- Complete new record from old
1546:
1547: oe_debug_pub.add('1111');
1548: l_PRICING_ATTR_rec := QP_Pricing_Attr_Util.Complete_Record
1549: ( p_PRICING_ATTR_rec => l_PRICING_ATTR_rec
1550: , p_old_PRICING_ATTR_rec => l_old_PRICING_ATTR_rec
1551: );

Line 1557: oe_debug_pub.add('2222');

1553: END IF;
1554:
1555: -- Attribute level validation.
1556:
1557: oe_debug_pub.add('2222');
1558: IF l_PRICING_ATTR_rec.operation = QP_GLOBALS.G_OPR_CREATE
1559: OR l_PRICING_ATTR_rec.operation = QP_GLOBALS.G_OPR_UPDATE
1560: OR l_PRICING_ATTR_rec.operation = QP_GLOBALS.G_OPR_DELETE THEN
1561:

Line 1565: oe_debug_pub.add('calling get_parent from apply attribute');

1561:
1562:
1563: --- added by svdeshmu
1564:
1565: oe_debug_pub.add('calling get_parent from apply attribute');
1566: oe_debug_pub.add('with child as'||l_pricing_attr_rec.list_line_id);
1567: Get_Parent_List_Line_Id
1568: ( p_child_list_line_id =>l_PRICING_ATTR_REC.list_line_id
1569: , x_parent_list_line_id =>l_parent_list_line_id

Line 1566: oe_debug_pub.add('with child as'||l_pricing_attr_rec.list_line_id);

1562:
1563: --- added by svdeshmu
1564:
1565: oe_debug_pub.add('calling get_parent from apply attribute');
1566: oe_debug_pub.add('with child as'||l_pricing_attr_rec.list_line_id);
1567: Get_Parent_List_Line_Id
1568: ( p_child_list_line_id =>l_PRICING_ATTR_REC.list_line_id
1569: , x_parent_list_line_id =>l_parent_list_line_id
1570: , x_list_line_type_code =>l_list_line_type_code

Line 1573: oe_debug_pub.add('status of get_parent is'||l_status);

1569: , x_parent_list_line_id =>l_parent_list_line_id
1570: , x_list_line_type_code =>l_list_line_type_code
1571: , x_status =>l_status
1572: );
1573: oe_debug_pub.add('status of get_parent is'||l_status);
1574:
1575: IF l_status = 'T' AND l_list_line_type_code = 'PBH' THEN
1576:
1577: oe_debug_pub.add('calling log request for ob from private ');

Line 1577: oe_debug_pub.add('calling log request for ob from private ');

1573: oe_debug_pub.add('status of get_parent is'||l_status);
1574:
1575: IF l_status = 'T' AND l_list_line_type_code = 'PBH' THEN
1576:
1577: oe_debug_pub.add('calling log request for ob from private ');
1578: oe_debug_pub.add('list_line_id is '||l_parent_list_line_id);
1579: oe_debug_pub.add(' pr is '||l_PRICING_ATTR_REC.list_line_id);
1580:
1581: --Added to check whether the PBH is for continuous or

Line 1578: oe_debug_pub.add('list_line_id is '||l_parent_list_line_id);

1574:
1575: IF l_status = 'T' AND l_list_line_type_code = 'PBH' THEN
1576:
1577: oe_debug_pub.add('calling log request for ob from private ');
1578: oe_debug_pub.add('list_line_id is '||l_parent_list_line_id);
1579: oe_debug_pub.add(' pr is '||l_PRICING_ATTR_REC.list_line_id);
1580:
1581: --Added to check whether the PBH is for continuous or
1582: --non-continuous price breaks

Line 1579: oe_debug_pub.add(' pr is '||l_PRICING_ATTR_REC.list_line_id);

1575: IF l_status = 'T' AND l_list_line_type_code = 'PBH' THEN
1576:
1577: oe_debug_pub.add('calling log request for ob from private ');
1578: oe_debug_pub.add('list_line_id is '||l_parent_list_line_id);
1579: oe_debug_pub.add(' pr is '||l_PRICING_ATTR_REC.list_line_id);
1580:
1581: --Added to check whether the PBH is for continuous or
1582: --non-continuous price breaks
1583: BEGIN

Line 1631: oe_debug_pub.add('3333');

1627: END IF;
1628:
1629: END IF;
1630:
1631: oe_debug_pub.add('3333');
1632: -- Clear dependent attributes.
1633:
1634: IF l_control_rec.change_attributes THEN
1635: l_p_PRICING_ATTR_rec := l_PRICING_ATTR_rec;

Line 1659: oe_debug_pub.add('4444');

1655: END IF;
1656:
1657: -- Apply attribute changes
1658:
1659: oe_debug_pub.add('4444');
1660: IF l_control_rec.default_attributes
1661: OR l_control_rec.change_attributes
1662: THEN
1663:

Line 1664: oe_debug_pub.add('7777');

1660: IF l_control_rec.default_attributes
1661: OR l_control_rec.change_attributes
1662: THEN
1663:
1664: oe_debug_pub.add('7777');
1665: l_p_PRICING_ATTR_rec := l_PRICING_ATTR_rec;
1666: QP_Pricing_Attr_Util.Apply_Attribute_Changes
1667: ( p_PRICING_ATTR_rec => l_p_PRICING_ATTR_rec
1668: , p_old_PRICING_ATTR_rec => l_old_PRICING_ATTR_rec

Line 1676: oe_debug_pub.add('5555');

1672: END IF;
1673:
1674: -- Entity level validation.
1675:
1676: oe_debug_pub.add('5555');
1677: IF l_control_rec.validate_entity THEN
1678:
1679: IF l_PRICING_ATTR_rec.operation = QP_GLOBALS.G_OPR_DELETE THEN
1680:

Line 1717: oe_debug_pub.add('6666');

1713: END IF;
1714:
1715: -- Step 4. Write to DB
1716:
1717: oe_debug_pub.add('6666');
1718: IF l_control_rec.write_to_db THEN
1719:
1720: IF l_PRICING_ATTR_rec.operation = QP_GLOBALS.G_OPR_DELETE THEN
1721:

Line 1756: oe_debug_pub.add('calling get_parent from QPXVMLSB while delete');

1752: End;
1753: -- bug 3563355 end
1754: END IF;
1755:
1756: oe_debug_pub.add('calling get_parent from QPXVMLSB while delete');
1757: oe_debug_pub.add('with child as'||l_pricing_attr_rec.list_line_id);
1758: Get_Parent_List_Line_Id
1759: ( p_child_list_line_id =>l_PRICING_ATTR_REC.list_line_id
1760: , x_parent_list_line_id =>l_parent_list_line_id

Line 1757: oe_debug_pub.add('with child as'||l_pricing_attr_rec.list_line_id);

1753: -- bug 3563355 end
1754: END IF;
1755:
1756: oe_debug_pub.add('calling get_parent from QPXVMLSB while delete');
1757: oe_debug_pub.add('with child as'||l_pricing_attr_rec.list_line_id);
1758: Get_Parent_List_Line_Id
1759: ( p_child_list_line_id =>l_PRICING_ATTR_REC.list_line_id
1760: , x_parent_list_line_id =>l_parent_list_line_id
1761: , x_list_line_type_code =>l_list_line_type_code

Line 1765: oe_debug_pub.add('status of get_parent is'||l_status);

1761: , x_list_line_type_code =>l_list_line_type_code
1762: , x_status =>l_status
1763: );
1764:
1765: oe_debug_pub.add('status of get_parent is'||l_status);
1766:
1767: IF l_status = 'T' THEN
1768:
1769: oe_debug_pub.add('calling log request for ob from private ');

Line 1769: oe_debug_pub.add('calling log request for ob from private ');

1765: oe_debug_pub.add('status of get_parent is'||l_status);
1766:
1767: IF l_status = 'T' THEN
1768:
1769: oe_debug_pub.add('calling log request for ob from private ');
1770: oe_debug_pub.add('list_line_id is '||l_parent_list_line_id);
1771: qp_delayed_requests_PVT.log_request
1772: ( p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS
1773: , p_entity_id => l_parent_list_line_id

Line 1770: oe_debug_pub.add('list_line_id is '||l_parent_list_line_id);

1766:
1767: IF l_status = 'T' THEN
1768:
1769: oe_debug_pub.add('calling log request for ob from private ');
1770: oe_debug_pub.add('list_line_id is '||l_parent_list_line_id);
1771: qp_delayed_requests_PVT.log_request
1772: ( p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS
1773: , p_entity_id => l_parent_list_line_id
1774: , p_param1 =>l_list_line_type_code

Line 1787: oe_debug_pub.add('7777');

1783: -- end of additions by svdeshmu
1784:
1785:
1786:
1787: oe_debug_pub.add('7777');
1788: QP_Pricing_Attr_Util.Delete_Row
1789: ( p_pricing_attribute_id => l_PRICING_ATTR_rec.pricing_attribute_id
1790: );
1791:

Line 1808: oe_debug_pub.add(to_char(l_PRICING_ATTR_rec.attribute_grouping_no)||'attr_grp');

1804: ELSIF l_PRICING_ATTR_rec.operation = QP_GLOBALS.G_OPR_CREATE THEN
1805:
1806: l_PRICING_ATTR_rec.creation_date := SYSDATE;
1807: l_PRICING_ATTR_rec.created_by := FND_GLOBAL.USER_ID;
1808: oe_debug_pub.add(to_char(l_PRICING_ATTR_rec.attribute_grouping_no)||'attr_grp');
1809: QP_Pricing_Attr_Util.Insert_Row (l_PRICING_ATTR_rec);
1810:
1811: END IF;
1812:

Line 1837: oe_debug_pub.add('manoj - value of called_from_ui before delete_reqs_for_deleted_entity = ' || l_control_rec.called_from_ui);

1833: l_PRICING_ATTR_rec.return_status := FND_API.G_RET_STS_ERROR;
1834: l_PRICING_ATTR_tbl(I) := l_PRICING_ATTR_rec;
1835: l_old_PRICING_ATTR_tbl(I) := l_old_PRICING_ATTR_rec;
1836:
1837: oe_debug_pub.add('manoj - value of called_from_ui before delete_reqs_for_deleted_entity = ' || l_control_rec.called_from_ui);
1838: --dbms_output.put_line('manoj - pricing_attr- value of called_from_ui before delete_reqs_for_deleted_entity = ' || l_control_rec.called_from_ui);
1839: -- mkarya If process_modifiers has been called from public package, then ONLY call
1840: -- qp_delayed_requests_pvt.delete_reqs_for_deleted_entity
1841: if l_control_rec.called_from_ui = 'N' then

Line 1946: oe_debug_pub.add('END pricing_attrs in Private');

1942:
1943: x_PRICING_ATTR_tbl := l_PRICING_ATTR_tbl;
1944: x_old_PRICING_ATTR_tbl := l_old_PRICING_ATTR_tbl;
1945:
1946: oe_debug_pub.add('END pricing_attrs in Private');
1947: EXCEPTION
1948:
1949: WHEN FND_API.G_EXC_ERROR THEN
1950:

Line 2055: oe_debug_pub.add('BEGIN process_modifiers in Private');

2051: -- Blanket Agreement
2052: l_qual_exists VARCHAR2(1) := 'N';
2053: BEGIN
2054:
2055: oe_debug_pub.add('BEGIN process_modifiers in Private');
2056: --dbms_output.put_line('BEGIN process_modifiers in Private');
2057: -- Standard call to check for call compatibility
2058:
2059: IF NOT FND_API.Compatible_API_Call

Line 2107: oe_debug_pub.add('Operation in pvt'||l_MODIFIER_LIST_rec.operation);

2103:
2104:
2105: -- Init local table variables.
2106:
2107: oe_debug_pub.add('Operation in pvt'||l_MODIFIER_LIST_rec.operation);
2108: l_MODIFIERS_tbl := p_MODIFIERS_tbl;
2109: l_old_MODIFIERS_tbl := p_old_MODIFIERS_tbl;
2110:
2111: -- Init local table variables.

Line 2123: oe_debug_pub.add('list type1= '|| l_MODIFIER_LIST_rec.list_type_code);

2119: l_old_PRICING_ATTR_tbl := p_old_PRICING_ATTR_tbl;
2120:
2121: -- Modifier_List
2122:
2123: oe_debug_pub.add('list type1= '|| l_MODIFIER_LIST_rec.list_type_code);
2124: l_p_MODIFIER_LIST_rec := l_MODIFIER_LIST_rec;
2125: l_p_old_MODIFIER_LIST_rec := l_old_MODIFIER_LIST_rec;
2126: Modifier_List
2127: ( p_validation_level => p_validation_level

Line 2157: oe_debug_pub.add('list type2= '|| l_MODIFIER_LIST_rec.list_type_code);

2153: -- NULL;
2154:
2155: END IF;
2156:
2157: oe_debug_pub.add('list type2= '|| l_MODIFIER_LIST_rec.list_type_code);
2158: --dbms_output.put_line('load parent key');
2159: -- Load parent key if missing and operation is create.
2160:
2161: FOR I IN 1..l_MODIFIERS_tbl.COUNT LOOP

Line 2182: oe_debug_pub.add('list type3= '|| l_MODIFIER_LIST_rec.list_type_code);

2178: END LOOP;
2179:
2180: -- Modifierss
2181:
2182: oe_debug_pub.add('list type3= '|| l_MODIFIER_LIST_rec.list_type_code);
2183: l_p_MODIFIERS_tbl := l_MODIFIERS_tbl;
2184: l_p_old_MODIFIERS_tbl := l_old_MODIFIERS_tbl;
2185: Modifierss
2186: ( p_validation_level => p_validation_level

Line 2200: oe_debug_pub.add('here1');

2196: IF p_control_rec.process AND
2197: (p_control_rec.process_entity = QP_GLOBALS.G_ENTITY_ALL OR
2198: p_control_rec.process_entity = QP_GLOBALS.G_ENTITY_MODIFIERS)
2199: THEN
2200: oe_debug_pub.add('here1');
2201: --NULL;
2202:
2203: -- FOR QUALIFICATION_IND
2204: QP_DELAYED_REQUESTS_PVT.Process_Request_for_Entity

Line 2217: oe_debug_pub.add('list type4= '|| l_MODIFIER_LIST_rec.list_type_code);

2213: END IF;
2214:
2215: END IF;
2216:
2217: oe_debug_pub.add('list type4= '|| l_MODIFIER_LIST_rec.list_type_code);
2218: -- Load parent key if missing and operation is create.
2219:
2220: FOR I IN 1..l_QUALIFIERS_tbl.COUNT LOOP
2221:

Line 2222: oe_debug_pub.add('here2');

2218: -- Load parent key if missing and operation is create.
2219:
2220: FOR I IN 1..l_QUALIFIERS_tbl.COUNT LOOP
2221:
2222: oe_debug_pub.add('here2');
2223: l_QUALIFIERS_rec := l_QUALIFIERS_tbl(I);
2224:
2225: IF l_QUALIFIERS_rec.operation = QP_GLOBALS.G_OPR_CREATE
2226: AND (l_QUALIFIERS_rec.list_header_id IS NULL OR

Line 2230: oe_debug_pub.add('here3');

2226: AND (l_QUALIFIERS_rec.list_header_id IS NULL OR
2227: l_QUALIFIERS_rec.list_header_id = FND_API.G_MISS_NUM)
2228: THEN
2229:
2230: oe_debug_pub.add('here3');
2231: -- Copy parent_id.
2232:
2233: l_QUALIFIERS_tbl(I).list_header_id := l_MODIFIER_LIST_rec.list_header_id;
2234: END IF;

Line 2251: oe_debug_pub.add('here4');

2247: );
2248:
2249: -- Perform QUALIFIERS group requests.
2250:
2251: oe_debug_pub.add('here4');
2252: IF p_control_rec.process AND
2253: (p_control_rec.process_entity = QP_GLOBALS.G_ENTITY_ALL OR
2254: p_control_rec.process_entity = QP_GLOBALS.G_ENTITY_QUALIFIERS)
2255: THEN

Line 2257: oe_debug_pub.add('here5');

2253: (p_control_rec.process_entity = QP_GLOBALS.G_ENTITY_ALL OR
2254: p_control_rec.process_entity = QP_GLOBALS.G_ENTITY_QUALIFIERS)
2255: THEN
2256:
2257: oe_debug_pub.add('here5');
2258: -- FOR CHECK_SEGMENT_LEVEL_IN_GROUP
2259: QP_DELAYED_REQUESTS_PVT.Process_Request_for_Entity
2260: (p_entity_code => QP_GLOBALS.G_ENTITY_QUALIFIERS
2261: ,p_delete => FND_API.G_TRUE

Line 2280: oe_debug_pub.add(to_char(l_PRICING_ATTR_rec.attribute_grouping_no)||'attr_grp_no');

2276: FOR I IN 1..l_PRICING_ATTR_tbl.COUNT LOOP
2277:
2278: l_PRICING_ATTR_rec := l_PRICING_ATTR_tbl(I);
2279:
2280: oe_debug_pub.add(to_char(l_PRICING_ATTR_rec.attribute_grouping_no)||'attr_grp_no');
2281: IF l_PRICING_ATTR_rec.operation = QP_GLOBALS.G_OPR_CREATE
2282: AND (l_PRICING_ATTR_rec.list_line_id IS NULL OR
2283: l_PRICING_ATTR_rec.list_line_id = FND_API.G_MISS_NUM)
2284: THEN

Line 2286: oe_debug_pub.add('here6');

2282: AND (l_PRICING_ATTR_rec.list_line_id IS NULL OR
2283: l_PRICING_ATTR_rec.list_line_id = FND_API.G_MISS_NUM)
2284: THEN
2285:
2286: oe_debug_pub.add('here6');
2287: oe_debug_pub.add(to_char(l_PRICING_ATTR_rec.attribute_grouping_no)||'attr_grp_no');
2288: oe_debug_pub.add(to_char(l_PRICING_ATTR_rec.MODIFIERS_index));
2289: -- Check If parent exists.
2290:

Line 2287: oe_debug_pub.add(to_char(l_PRICING_ATTR_rec.attribute_grouping_no)||'attr_grp_no');

2283: l_PRICING_ATTR_rec.list_line_id = FND_API.G_MISS_NUM)
2284: THEN
2285:
2286: oe_debug_pub.add('here6');
2287: oe_debug_pub.add(to_char(l_PRICING_ATTR_rec.attribute_grouping_no)||'attr_grp_no');
2288: oe_debug_pub.add(to_char(l_PRICING_ATTR_rec.MODIFIERS_index));
2289: -- Check If parent exists.
2290:
2291: IF l_MODIFIERS_tbl.EXISTS(l_PRICING_ATTR_rec.MODIFIERS_index) THEN

Line 2288: oe_debug_pub.add(to_char(l_PRICING_ATTR_rec.MODIFIERS_index));

2284: THEN
2285:
2286: oe_debug_pub.add('here6');
2287: oe_debug_pub.add(to_char(l_PRICING_ATTR_rec.attribute_grouping_no)||'attr_grp_no');
2288: oe_debug_pub.add(to_char(l_PRICING_ATTR_rec.MODIFIERS_index));
2289: -- Check If parent exists.
2290:
2291: IF l_MODIFIERS_tbl.EXISTS(l_PRICING_ATTR_rec.MODIFIERS_index) THEN
2292:

Line 2295: oe_debug_pub.add('if here6');

2291: IF l_MODIFIERS_tbl.EXISTS(l_PRICING_ATTR_rec.MODIFIERS_index) THEN
2292:
2293: -- Copy parent_id.
2294:
2295: oe_debug_pub.add('if here6');
2296: l_PRICING_ATTR_tbl(I).list_line_id := l_MODIFIERS_tbl(l_PRICING_ATTR_rec.MODIFIERS_index).list_line_id;
2297:
2298: ELSE
2299:

Line 2300: oe_debug_pub.add('else if here6');

2296: l_PRICING_ATTR_tbl(I).list_line_id := l_MODIFIERS_tbl(l_PRICING_ATTR_rec.MODIFIERS_index).list_line_id;
2297:
2298: ELSE
2299:
2300: oe_debug_pub.add('else if here6');
2301: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
2302: THEN
2303:
2304: FND_MESSAGE.SET_NAME('QP','QP_API_INV_PARENT_INDEX');

Line 2316: oe_debug_pub.add('pricing attrhere6');

2312: END IF;
2313: END LOOP;
2314: -- Pricing_Attrs
2315:
2316: oe_debug_pub.add('pricing attrhere6');
2317: l_p_PRICING_ATTR_tbl := l_PRICING_ATTR_tbl;
2318: l_p_old_PRICING_ATTR_tbl := l_old_PRICING_ATTR_tbl;
2319: Pricing_Attrs
2320: ( p_validation_level => p_validation_level

Line 2328: oe_debug_pub.add('after pricing attrhere6');

2324: , x_PRICING_ATTR_tbl => l_PRICING_ATTR_tbl
2325: , x_old_PRICING_ATTR_tbl => l_old_PRICING_ATTR_tbl
2326: );
2327:
2328: oe_debug_pub.add('after pricing attrhere6');
2329: -- Perform PRICING_ATTR group requests.
2330:
2331: IF p_control_rec.process AND
2332: (p_control_rec.process_entity = QP_GLOBALS.G_ENTITY_ALL OR

Line 2351: oe_debug_pub.add('list type5= '|| l_MODIFIER_LIST_rec.list_type_code);

2347: -- NULL;
2348:
2349: END IF;
2350:
2351: oe_debug_pub.add('list type5= '|| l_MODIFIER_LIST_rec.list_type_code);
2352: oe_debug_pub.add('before last if');
2353: -- Step 6. Perform Object group logic
2354:
2355: IF p_control_rec.process AND

Line 2352: oe_debug_pub.add('before last if');

2348:
2349: END IF;
2350:
2351: oe_debug_pub.add('list type5= '|| l_MODIFIER_LIST_rec.list_type_code);
2352: oe_debug_pub.add('before last if');
2353: -- Step 6. Perform Object group logic
2354:
2355: IF p_control_rec.process AND
2356: p_control_rec.process_entity = QP_GLOBALS.G_ENTITY_ALL

Line 2369: oe_debug_pub.add('calling process_request');

2365: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2366: RAISE FND_API.G_EXC_ERROR;
2367: END IF;
2368: /*
2369: oe_debug_pub.add('calling process_request');
2370: QP_delayed_requests_pvt.process_request_for_entity(p_entity_code =>QP_GLOBALS.G_ENTITY_MODIFIER_LIST,
2371: x_return_status=>l_return_status);
2372:
2373: oe_debug_pub.add('return status after calling process_request' || l_return_status);

Line 2373: oe_debug_pub.add('return status after calling process_request' || l_return_status);

2369: oe_debug_pub.add('calling process_request');
2370: QP_delayed_requests_pvt.process_request_for_entity(p_entity_code =>QP_GLOBALS.G_ENTITY_MODIFIER_LIST,
2371: x_return_status=>l_return_status);
2372:
2373: oe_debug_pub.add('return status after calling process_request' || l_return_status);
2374:
2375: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2376: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2377: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

Line 2400: oe_debug_pub.add('Before processing delayed request for duplicate modifiers');

2396:
2397: IF p_control_rec.process AND
2398: p_control_rec.process_entity = QP_GLOBALS.G_ENTITY_ALL
2399: THEN
2400: oe_debug_pub.add('Before processing delayed request for duplicate modifiers');
2401: -- FOR Duplicate Modifier Lines
2402: QP_DELAYED_REQUESTS_PVT.Process_Delayed_Requests
2403: (
2404: x_return_status => l_return_status

Line 2412: oe_debug_pub.add('After processing delayed request for duplicate modifiers');

2408: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2409: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2410: RAISE FND_API.G_EXC_ERROR;
2411: END IF;
2412: oe_debug_pub.add('After processing delayed request for duplicate modifiers');
2413:
2414: END IF;
2415: ELSE
2416:

Line 2426: oe_debug_pub.add('list type6= '|| l_MODIFIER_LIST_rec.list_type_code);

2422:
2423: -- end bug2091362
2424:
2425:
2426: oe_debug_pub.add('list type6= '|| l_MODIFIER_LIST_rec.list_type_code);
2427:
2428:
2429: oe_debug_pub.add('before validation');
2430: oe_debug_pub.add('oper = '|| l_MODIFIERS_rec.operation);

Line 2429: oe_debug_pub.add('before validation');

2425:
2426: oe_debug_pub.add('list type6= '|| l_MODIFIER_LIST_rec.list_type_code);
2427:
2428:
2429: oe_debug_pub.add('before validation');
2430: oe_debug_pub.add('oper = '|| l_MODIFIERS_rec.operation);
2431: oe_debug_pub.add('list type = '|| l_MODIFIER_LIST_rec.list_type_code);
2432: oe_debug_pub.add('Modifier type = '|| l_MODIFIERS_rec.list_line_type_code);
2433:

Line 2430: oe_debug_pub.add('oper = '|| l_MODIFIERS_rec.operation);

2426: oe_debug_pub.add('list type6= '|| l_MODIFIER_LIST_rec.list_type_code);
2427:
2428:
2429: oe_debug_pub.add('before validation');
2430: oe_debug_pub.add('oper = '|| l_MODIFIERS_rec.operation);
2431: oe_debug_pub.add('list type = '|| l_MODIFIER_LIST_rec.list_type_code);
2432: oe_debug_pub.add('Modifier type = '|| l_MODIFIERS_rec.list_line_type_code);
2433:
2434: -- Done processing, load OUT parameters.

Line 2431: oe_debug_pub.add('list type = '|| l_MODIFIER_LIST_rec.list_type_code);

2427:
2428:
2429: oe_debug_pub.add('before validation');
2430: oe_debug_pub.add('oper = '|| l_MODIFIERS_rec.operation);
2431: oe_debug_pub.add('list type = '|| l_MODIFIER_LIST_rec.list_type_code);
2432: oe_debug_pub.add('Modifier type = '|| l_MODIFIERS_rec.list_line_type_code);
2433:
2434: -- Done processing, load OUT parameters.
2435:

Line 2432: oe_debug_pub.add('Modifier type = '|| l_MODIFIERS_rec.list_line_type_code);

2428:
2429: oe_debug_pub.add('before validation');
2430: oe_debug_pub.add('oper = '|| l_MODIFIERS_rec.operation);
2431: oe_debug_pub.add('list type = '|| l_MODIFIER_LIST_rec.list_type_code);
2432: oe_debug_pub.add('Modifier type = '|| l_MODIFIERS_rec.list_line_type_code);
2433:
2434: -- Done processing, load OUT parameters.
2435:
2436: x_MODIFIER_LIST_rec := l_MODIFIER_LIST_rec;

Line 2505: oe_debug_pub.add('inside create qualifier for blanket modifier');

2501: AND ( x_MODIFIER_LIST_rec.orig_system_header_ref <> NULL
2502: OR x_MODIFIER_LIST_rec.orig_system_header_ref <> FND_API.G_MISS_CHAR)
2503: )
2504: THEN
2505: oe_debug_pub.add('inside create qualifier for blanket modifier');
2506:
2507: BEGIN
2508: select 'Y' into l_qual_exists
2509: from qp_qualifiers

Line 2531: oe_debug_pub.add('Unexp Error while creating blanket qualifier');

2527: , x_return_status => l_return_status
2528: );
2529:
2530: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2531: oe_debug_pub.add('Unexp Error while creating blanket qualifier');
2532: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2533: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2534: oe_debug_pub.add('Exp Error while creating blanket qualifier');
2535: RAISE FND_API.G_EXC_ERROR;

Line 2534: oe_debug_pub.add('Exp Error while creating blanket qualifier');

2530: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2531: oe_debug_pub.add('Unexp Error while creating blanket qualifier');
2532: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2533: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2534: oe_debug_pub.add('Exp Error while creating blanket qualifier');
2535: RAISE FND_API.G_EXC_ERROR;
2536: END IF;
2537: END IF;
2538:

Line 2541: oe_debug_pub.add('END process_modifiers in Private');

2537: END IF;
2538:
2539: END IF;
2540:
2541: oe_debug_pub.add('END process_modifiers in Private');
2542:
2543: EXCEPTION
2544:
2545: WHEN FND_API.G_EXC_ERROR THEN

Line 2548: oe_debug_pub.add('manoj - value of called_from_ui before clear_request = ' || p_control_rec.called_from_ui);

2544:
2545: WHEN FND_API.G_EXC_ERROR THEN
2546:
2547: x_return_status := FND_API.G_RET_STS_ERROR;
2548: oe_debug_pub.add('manoj - value of called_from_ui before clear_request = ' || p_control_rec.called_from_ui);
2549: --dbms_output.put_line('manoj - value of called_from_ui before clear_request = ' || p_control_rec.called_from_ui);
2550: -- mkarya If process_modifiers has been called from public package, then ONLY call clear_request
2551: if p_control_rec.called_from_ui = 'N' then
2552: qp_delayed_requests_pvt.Clear_Request

Line 2615: oe_debug_pub.add('EXP process_modifiers in Private');

2611: ( p_count => x_msg_count
2612: , p_data => x_msg_data
2613: );
2614:
2615: oe_debug_pub.add('EXP process_modifiers in Private');
2616: END Process_Modifiers;
2617:
2618: -- Start of Comments
2619: -- API name Lock_Modifiers

Line 2662: oe_debug_pub.add('BEGIN lock_modifiers in Private');

2658: l_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
2659: l_PRICING_ATTR_rec QP_Modifiers_PUB.Pricing_Attr_Rec_Type;
2660: BEGIN
2661:
2662: oe_debug_pub.add('BEGIN lock_modifiers in Private');
2663: -- Standard call to check for call compatibility
2664:
2665: IF NOT FND_API.Compatible_API_Call
2666: ( l_api_version_number

Line 2787: oe_debug_pub.add('END lock_modifiers in Private');

2783: ( p_count => x_msg_count
2784: , p_data => x_msg_data
2785: );
2786:
2787: oe_debug_pub.add('END lock_modifiers in Private');
2788:
2789: EXCEPTION
2790:
2791: WHEN FND_API.G_EXC_ERROR THEN

Line 2884: oe_debug_pub.add('BEGIN get_modifiers in Private');

2880: l_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;
2881: l_x_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;
2882: BEGIN
2883:
2884: oe_debug_pub.add('BEGIN get_modifiers in Private');
2885: -- Standard call to check for call compatibility
2886:
2887: IF NOT FND_API.Compatible_API_Call
2888: ( l_api_version_number

Line 3005: oe_debug_pub.add('END get_modifiers in Private');

3001: ( p_count => x_msg_count
3002: , p_data => x_msg_data
3003: );
3004:
3005: oe_debug_pub.add('END get_modifiers in Private');
3006: END Get_Modifiers;
3007:
3008: END QP_Modifiers_PVT;