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 116: oe_debug_pub.add('Operation'||l_MODIFIER_LIST_rec.operation);

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

2171: END LOOP;
2172:
2173: -- Modifierss
2174:
2175: oe_debug_pub.add('list type3= '|| l_MODIFIER_LIST_rec.list_type_code);
2176: l_p_MODIFIERS_tbl := l_MODIFIERS_tbl;
2177: l_p_old_MODIFIERS_tbl := l_old_MODIFIERS_tbl;
2178: Modifierss
2179: ( p_validation_level => p_validation_level

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

2189: IF p_control_rec.process AND
2190: (p_control_rec.process_entity = QP_GLOBALS.G_ENTITY_ALL OR
2191: p_control_rec.process_entity = QP_GLOBALS.G_ENTITY_MODIFIERS)
2192: THEN
2193: oe_debug_pub.add('here1');
2194: --NULL;
2195:
2196: -- FOR QUALIFICATION_IND
2197: QP_DELAYED_REQUESTS_PVT.Process_Request_for_Entity

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

2206: END IF;
2207:
2208: END IF;
2209:
2210: oe_debug_pub.add('list type4= '|| l_MODIFIER_LIST_rec.list_type_code);
2211: -- Load parent key if missing and operation is create.
2212:
2213: FOR I IN 1..l_QUALIFIERS_tbl.COUNT LOOP
2214:

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

2211: -- Load parent key if missing and operation is create.
2212:
2213: FOR I IN 1..l_QUALIFIERS_tbl.COUNT LOOP
2214:
2215: oe_debug_pub.add('here2');
2216: l_QUALIFIERS_rec := l_QUALIFIERS_tbl(I);
2217:
2218: IF l_QUALIFIERS_rec.operation = QP_GLOBALS.G_OPR_CREATE
2219: AND (l_QUALIFIERS_rec.list_header_id IS NULL OR

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

2219: AND (l_QUALIFIERS_rec.list_header_id IS NULL OR
2220: l_QUALIFIERS_rec.list_header_id = FND_API.G_MISS_NUM)
2221: THEN
2222:
2223: oe_debug_pub.add('here3');
2224: -- Copy parent_id.
2225:
2226: l_QUALIFIERS_tbl(I).list_header_id := l_MODIFIER_LIST_rec.list_header_id;
2227: END IF;

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

2240: );
2241:
2242: -- Perform QUALIFIERS group requests.
2243:
2244: oe_debug_pub.add('here4');
2245: IF p_control_rec.process AND
2246: (p_control_rec.process_entity = QP_GLOBALS.G_ENTITY_ALL OR
2247: p_control_rec.process_entity = QP_GLOBALS.G_ENTITY_QUALIFIERS)
2248: THEN

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

2246: (p_control_rec.process_entity = QP_GLOBALS.G_ENTITY_ALL OR
2247: p_control_rec.process_entity = QP_GLOBALS.G_ENTITY_QUALIFIERS)
2248: THEN
2249:
2250: oe_debug_pub.add('here5');
2251: -- FOR CHECK_SEGMENT_LEVEL_IN_GROUP
2252: QP_DELAYED_REQUESTS_PVT.Process_Request_for_Entity
2253: (p_entity_code => QP_GLOBALS.G_ENTITY_QUALIFIERS
2254: ,p_delete => FND_API.G_TRUE

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

2269: FOR I IN 1..l_PRICING_ATTR_tbl.COUNT LOOP
2270:
2271: l_PRICING_ATTR_rec := l_PRICING_ATTR_tbl(I);
2272:
2273: oe_debug_pub.add(to_char(l_PRICING_ATTR_rec.attribute_grouping_no)||'attr_grp_no');
2274: IF l_PRICING_ATTR_rec.operation = QP_GLOBALS.G_OPR_CREATE
2275: AND (l_PRICING_ATTR_rec.list_line_id IS NULL OR
2276: l_PRICING_ATTR_rec.list_line_id = FND_API.G_MISS_NUM)
2277: THEN

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

2275: AND (l_PRICING_ATTR_rec.list_line_id IS NULL OR
2276: l_PRICING_ATTR_rec.list_line_id = FND_API.G_MISS_NUM)
2277: THEN
2278:
2279: oe_debug_pub.add('here6');
2280: oe_debug_pub.add(to_char(l_PRICING_ATTR_rec.attribute_grouping_no)||'attr_grp_no');
2281: oe_debug_pub.add(to_char(l_PRICING_ATTR_rec.MODIFIERS_index));
2282: -- Check If parent exists.
2283:

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

2276: l_PRICING_ATTR_rec.list_line_id = FND_API.G_MISS_NUM)
2277: THEN
2278:
2279: oe_debug_pub.add('here6');
2280: oe_debug_pub.add(to_char(l_PRICING_ATTR_rec.attribute_grouping_no)||'attr_grp_no');
2281: oe_debug_pub.add(to_char(l_PRICING_ATTR_rec.MODIFIERS_index));
2282: -- Check If parent exists.
2283:
2284: IF l_MODIFIERS_tbl.EXISTS(l_PRICING_ATTR_rec.MODIFIERS_index) THEN

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

2277: THEN
2278:
2279: oe_debug_pub.add('here6');
2280: oe_debug_pub.add(to_char(l_PRICING_ATTR_rec.attribute_grouping_no)||'attr_grp_no');
2281: oe_debug_pub.add(to_char(l_PRICING_ATTR_rec.MODIFIERS_index));
2282: -- Check If parent exists.
2283:
2284: IF l_MODIFIERS_tbl.EXISTS(l_PRICING_ATTR_rec.MODIFIERS_index) THEN
2285:

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

2284: IF l_MODIFIERS_tbl.EXISTS(l_PRICING_ATTR_rec.MODIFIERS_index) THEN
2285:
2286: -- Copy parent_id.
2287:
2288: oe_debug_pub.add('if here6');
2289: l_PRICING_ATTR_tbl(I).list_line_id := l_MODIFIERS_tbl(l_PRICING_ATTR_rec.MODIFIERS_index).list_line_id;
2290:
2291: ELSE
2292:

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

2289: l_PRICING_ATTR_tbl(I).list_line_id := l_MODIFIERS_tbl(l_PRICING_ATTR_rec.MODIFIERS_index).list_line_id;
2290:
2291: ELSE
2292:
2293: oe_debug_pub.add('else if here6');
2294: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
2295: THEN
2296:
2297: FND_MESSAGE.SET_NAME('QP','QP_API_INV_PARENT_INDEX');

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

2305: END IF;
2306: END LOOP;
2307: -- Pricing_Attrs
2308:
2309: oe_debug_pub.add('pricing attrhere6');
2310: l_p_PRICING_ATTR_tbl := l_PRICING_ATTR_tbl;
2311: l_p_old_PRICING_ATTR_tbl := l_old_PRICING_ATTR_tbl;
2312: Pricing_Attrs
2313: ( p_validation_level => p_validation_level

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

2317: , x_PRICING_ATTR_tbl => l_PRICING_ATTR_tbl
2318: , x_old_PRICING_ATTR_tbl => l_old_PRICING_ATTR_tbl
2319: );
2320:
2321: oe_debug_pub.add('after pricing attrhere6');
2322: -- Perform PRICING_ATTR group requests.
2323:
2324: IF p_control_rec.process AND
2325: (p_control_rec.process_entity = QP_GLOBALS.G_ENTITY_ALL OR

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

2340: -- NULL;
2341:
2342: END IF;
2343:
2344: oe_debug_pub.add('list type5= '|| l_MODIFIER_LIST_rec.list_type_code);
2345: oe_debug_pub.add('before last if');
2346: -- Step 6. Perform Object group logic
2347:
2348: IF p_control_rec.process AND

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

2341:
2342: END IF;
2343:
2344: oe_debug_pub.add('list type5= '|| l_MODIFIER_LIST_rec.list_type_code);
2345: oe_debug_pub.add('before last if');
2346: -- Step 6. Perform Object group logic
2347:
2348: IF p_control_rec.process AND
2349: p_control_rec.process_entity = QP_GLOBALS.G_ENTITY_ALL

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

2358: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2359: RAISE FND_API.G_EXC_ERROR;
2360: END IF;
2361: /*
2362: oe_debug_pub.add('calling process_request');
2363: QP_delayed_requests_pvt.process_request_for_entity(p_entity_code =>QP_GLOBALS.G_ENTITY_MODIFIER_LIST,
2364: x_return_status=>l_return_status);
2365:
2366: oe_debug_pub.add('return status after calling process_request' || l_return_status);

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

2362: oe_debug_pub.add('calling process_request');
2363: QP_delayed_requests_pvt.process_request_for_entity(p_entity_code =>QP_GLOBALS.G_ENTITY_MODIFIER_LIST,
2364: x_return_status=>l_return_status);
2365:
2366: oe_debug_pub.add('return status after calling process_request' || l_return_status);
2367:
2368: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2369: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2370: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

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

2389:
2390: IF p_control_rec.process AND
2391: p_control_rec.process_entity = QP_GLOBALS.G_ENTITY_ALL
2392: THEN
2393: oe_debug_pub.add('Before processing delayed request for duplicate modifiers');
2394: -- FOR Duplicate Modifier Lines
2395: QP_DELAYED_REQUESTS_PVT.Process_Delayed_Requests
2396: (
2397: x_return_status => l_return_status

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

2401: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2402: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2403: RAISE FND_API.G_EXC_ERROR;
2404: END IF;
2405: oe_debug_pub.add('After processing delayed request for duplicate modifiers');
2406:
2407: END IF;
2408: ELSE
2409:

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

2415:
2416: -- end bug2091362
2417:
2418:
2419: oe_debug_pub.add('list type6= '|| l_MODIFIER_LIST_rec.list_type_code);
2420:
2421:
2422: oe_debug_pub.add('before validation');
2423: oe_debug_pub.add('oper = '|| l_MODIFIERS_rec.operation);

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

2418:
2419: oe_debug_pub.add('list type6= '|| l_MODIFIER_LIST_rec.list_type_code);
2420:
2421:
2422: oe_debug_pub.add('before validation');
2423: oe_debug_pub.add('oper = '|| l_MODIFIERS_rec.operation);
2424: oe_debug_pub.add('list type = '|| l_MODIFIER_LIST_rec.list_type_code);
2425: oe_debug_pub.add('Modifier type = '|| l_MODIFIERS_rec.list_line_type_code);
2426:

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

2419: oe_debug_pub.add('list type6= '|| l_MODIFIER_LIST_rec.list_type_code);
2420:
2421:
2422: oe_debug_pub.add('before validation');
2423: oe_debug_pub.add('oper = '|| l_MODIFIERS_rec.operation);
2424: oe_debug_pub.add('list type = '|| l_MODIFIER_LIST_rec.list_type_code);
2425: oe_debug_pub.add('Modifier type = '|| l_MODIFIERS_rec.list_line_type_code);
2426:
2427: -- Done processing, load OUT parameters.

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

2420:
2421:
2422: oe_debug_pub.add('before validation');
2423: oe_debug_pub.add('oper = '|| l_MODIFIERS_rec.operation);
2424: oe_debug_pub.add('list type = '|| l_MODIFIER_LIST_rec.list_type_code);
2425: oe_debug_pub.add('Modifier type = '|| l_MODIFIERS_rec.list_line_type_code);
2426:
2427: -- Done processing, load OUT parameters.
2428:

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

2421:
2422: oe_debug_pub.add('before validation');
2423: oe_debug_pub.add('oper = '|| l_MODIFIERS_rec.operation);
2424: oe_debug_pub.add('list type = '|| l_MODIFIER_LIST_rec.list_type_code);
2425: oe_debug_pub.add('Modifier type = '|| l_MODIFIERS_rec.list_line_type_code);
2426:
2427: -- Done processing, load OUT parameters.
2428:
2429: x_MODIFIER_LIST_rec := l_MODIFIER_LIST_rec;

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

2494: AND ( x_MODIFIER_LIST_rec.orig_system_header_ref <> NULL
2495: OR x_MODIFIER_LIST_rec.orig_system_header_ref <> FND_API.G_MISS_CHAR)
2496: )
2497: THEN
2498: oe_debug_pub.add('inside create qualifier for blanket modifier');
2499:
2500: BEGIN
2501: select 'Y' into l_qual_exists
2502: from qp_qualifiers

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

2520: , x_return_status => l_return_status
2521: );
2522:
2523: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2524: oe_debug_pub.add('Unexp Error while creating blanket qualifier');
2525: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2526: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2527: oe_debug_pub.add('Exp Error while creating blanket qualifier');
2528: RAISE FND_API.G_EXC_ERROR;

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

2523: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2524: oe_debug_pub.add('Unexp Error while creating blanket qualifier');
2525: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2526: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2527: oe_debug_pub.add('Exp Error while creating blanket qualifier');
2528: RAISE FND_API.G_EXC_ERROR;
2529: END IF;
2530: END IF;
2531:

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

2530: END IF;
2531:
2532: END IF;
2533:
2534: oe_debug_pub.add('END process_modifiers in Private');
2535:
2536: EXCEPTION
2537:
2538: WHEN FND_API.G_EXC_ERROR THEN

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

2537:
2538: WHEN FND_API.G_EXC_ERROR THEN
2539:
2540: x_return_status := FND_API.G_RET_STS_ERROR;
2541: oe_debug_pub.add('manoj - value of called_from_ui before clear_request = ' || p_control_rec.called_from_ui);
2542: --dbms_output.put_line('manoj - value of called_from_ui before clear_request = ' || p_control_rec.called_from_ui);
2543: -- mkarya If process_modifiers has been called from public package, then ONLY call clear_request
2544: if p_control_rec.called_from_ui = 'N' then
2545: qp_delayed_requests_pvt.Clear_Request

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

2604: ( p_count => x_msg_count
2605: , p_data => x_msg_data
2606: );
2607:
2608: oe_debug_pub.add('EXP process_modifiers in Private');
2609: END Process_Modifiers;
2610:
2611: -- Start of Comments
2612: -- API name Lock_Modifiers

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

2651: l_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
2652: l_PRICING_ATTR_rec QP_Modifiers_PUB.Pricing_Attr_Rec_Type;
2653: BEGIN
2654:
2655: oe_debug_pub.add('BEGIN lock_modifiers in Private');
2656: -- Standard call to check for call compatibility
2657:
2658: IF NOT FND_API.Compatible_API_Call
2659: ( l_api_version_number

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

2776: ( p_count => x_msg_count
2777: , p_data => x_msg_data
2778: );
2779:
2780: oe_debug_pub.add('END lock_modifiers in Private');
2781:
2782: EXCEPTION
2783:
2784: WHEN FND_API.G_EXC_ERROR THEN

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

2873: l_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;
2874: l_x_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;
2875: BEGIN
2876:
2877: oe_debug_pub.add('BEGIN get_modifiers in Private');
2878: -- Standard call to check for call compatibility
2879:
2880: IF NOT FND_API.Compatible_API_Call
2881: ( l_api_version_number

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

2994: ( p_count => x_msg_count
2995: , p_data => x_msg_data
2996: );
2997:
2998: oe_debug_pub.add('END get_modifiers in Private');
2999: END Get_Modifiers;
3000:
3001: END QP_Modifiers_PVT;