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

Line 149: oe_debug_pub.add('entity validation for qualifier id');

145: -- Check required attributes.
146:
147:
148: --dbms_output.put_line('entity validation for qualifier id');
149: oe_debug_pub.add('entity validation for qualifier id');
150: oe_debug_pub.add('entity validation for qualifier id'||p_QUALIFIERS_rec.qualifier_id);
151:
152:
153:

Line 150: oe_debug_pub.add('entity validation for qualifier id'||p_QUALIFIERS_rec.qualifier_id);

146:
147:
148: --dbms_output.put_line('entity validation for qualifier id');
149: oe_debug_pub.add('entity validation for qualifier id');
150: oe_debug_pub.add('entity validation for qualifier id'||p_QUALIFIERS_rec.qualifier_id);
151:
152:
153:
154:

Line 172: oe_debug_pub.add('entity null validation for qualifier id status '|| l_return_status);

168:
169: END IF;
170:
171: --dbms_output.put_line('entity validation for qualifier id status '|| l_return_status);
172: oe_debug_pub.add('entity null validation for qualifier id status '|| l_return_status);
173: --dbms_output.put_line('entity validation for qualifier grouping no');
174: oe_debug_pub.add('entity validation for qualifier grouping no');
175:
176:

Line 174: oe_debug_pub.add('entity validation for qualifier grouping no');

170:
171: --dbms_output.put_line('entity validation for qualifier id status '|| l_return_status);
172: oe_debug_pub.add('entity null validation for qualifier id status '|| l_return_status);
173: --dbms_output.put_line('entity validation for qualifier grouping no');
174: oe_debug_pub.add('entity validation for qualifier grouping no');
175:
176:
177:
178:

Line 202: --oe_debug_pub.add('entity null validation for qualifier group id status '|| l_return_status);

198:
199: END IF;
200:
201:
202: --oe_debug_pub.add('entity null validation for qualifier group id status '|| l_return_status);
203: --dbms_output.put_line('entity validation for qualifier group id status '|| l_return_status);
204:
205: --dbms_output.put_line('entity validation for qualifier attr_value');
206:

Line 207: --oe_debug_pub.add('entity validation for attr_value with value as '

203: --dbms_output.put_line('entity validation for qualifier group id status '|| l_return_status);
204:
205: --dbms_output.put_line('entity validation for qualifier attr_value');
206:
207: --oe_debug_pub.add('entity validation for attr_value with value as '
208: -- || p_QUALIFIERS_rec.qualifier_attr_value);
209:
210:
211: -- qualifier_attr_value can be null when the operator is

Line 237: oe_debug_pub.add('entity validation for qualifier attr value '|| l_return_status);

233:
234:
235:
236: --dbms_output.put_line('entity validation for qualifier attr value '|| l_return_status);
237: oe_debug_pub.add('entity validation for qualifier attr value '|| l_return_status);
238:
239:
240: --dbms_output.put_line('entity validation for qualifier attribute');
241:

Line 264: oe_debug_pub.add('entity null validation for qualifier attr '|| l_return_status);

260:
261:
262:
263: --dbms_output.put_line('entity validation for qualifier attr '|| l_return_status);
264: oe_debug_pub.add('entity null validation for qualifier attr '|| l_return_status);
265:
266:
267:
268: --dbms_output.put_line('entity validation for qualifier context');

Line 290: oe_debug_pub.add('entity validation for qualifier context '|| l_return_status);

286: END IF;
287:
288:
289: --dbms_output.put_line('entity null validation for qualifier context '|| l_return_status);
290: oe_debug_pub.add('entity validation for qualifier context '|| l_return_status);
291: --dbms_output.put_line('entity validation for comparison operator ');
292:
293:
294:

Line 317: oe_debug_pub.add('entity validation for compari '|| l_return_status);

313:
314:
315:
316: --dbms_output.put_line('entity validation for compari '|| l_return_status);
317: oe_debug_pub.add('entity validation for compari '|| l_return_status);
318: --dbms_output.put_line('entity validation for excluder flag operator ');
319:
320: /* Added for bug2368511 */
321:

Line 339: oe_debug_pub.add('entity validation for List Line Id '|| l_return_status);

335: END IF;
336:
337: END IF;
338:
339: oe_debug_pub.add('entity validation for List Line Id '|| l_return_status);
340:
341:
342: IF p_QUALIFIERS_rec.excluder_flag IS NULL
343: THEN

Line 362: oe_debug_pub.add('entity validation for excluder '|| l_return_status);

358:
359:
360:
361: --dbms_output.put_line('entity validation for excluder '|| l_return_status);
362: oe_debug_pub.add('entity validation for excluder '|| l_return_status);
363: -- Return Error if a required attribute is missing.
364:
365:
366:

Line 444: oe_debug_pub.add('entity validation for start_date '||l_return_status);

440: END IF;
441:
442:
443: --dbms_output.put_line('entity validation for start_date '||l_return_status);
444: oe_debug_pub.add('entity validation for start_date '||l_return_status);
445: --dbms_output.put_line('entity validation for value to ');
446:
447:
448:

Line 495: oe_debug_pub.add('entity validation for value to '||l_return_status);

491:
492:
493:
494: --dbms_output.put_line('entity validation for value to '||l_return_status);
495: oe_debug_pub.add('entity validation for value to '||l_return_status);
496:
497:
498:
499: --Other Validations

Line 580: oe_debug_pub.add('entity validation for duplicaet id '||l_return_status);

576:
577: End If;*/
578:
579: --dbms_output.put_line('entity validation for duplicaet id '||l_return_status);
580: oe_debug_pub.add('entity validation for duplicaet id '||l_return_status);
581:
582:
583:
584:

Line 615: oe_debug_pub.add('entity validation for compa2 '||l_return_status);

611: End If;
612:
613:
614: --dbms_output.put_line('entity validation for compa2 '||l_return_status);
615: oe_debug_pub.add('entity validation for compa2 '||l_return_status);
616:
617:
618:
619: --Validate Qualifier_Context , Qualifier_attribute ,Qualifier_Attr Value

Line 695: oe_debug_pub.add('for context '||l_return_status);

691: End If;
692:
693:
694: --dbms_output.put_line('for attributr '||l_return_status);
695: oe_debug_pub.add('for context '||l_return_status);
696:
697:
698: --- validate qualifier_attr_value only if comparison operator is
699: -- '='

Line 725: oe_debug_pub.add('attcching');

721: AND p_QUALIFIERS_rec.qualifier_attribute = 'QUALIFIER_ATTRIBUTE2'
722: AND p_QUALIFIERS_rec.list_header_id IS NOT NULL
723: THEN
724:
725: oe_debug_pub.add('attcching');
726: BEGIN
727:
728: select gsa_indicator
729: into l_gsa_indicator

Line 736: oe_debug_pub.add('GSA = Y');

732:
733: IF nvl(l_gsa_indicator,'N') = 'Y'
734: THEN
735:
736: oe_debug_pub.add('GSA = Y');
737: select decode(party.party_type,'ORGANIZATION',party.gsa_indicator_flag,'N')
738: into l_customer_gsa_indicator
739: from hz_cust_accounts cust_acct,hz_parties party
740: where cust_acct.party_id = party.party_id and

Line 746: oe_debug_pub.add('customer GSA not found');

742:
743: IF SQL%NOTFOUND
744: THEN
745:
746: oe_debug_pub.add('customer GSA not found');
747: l_return_status := FND_API.G_RET_STS_ERROR;
748:
749: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
750: THEN

Line 760: oe_debug_pub.add('customer GSA = '||l_customer_gsa_indicator);

756:
757: ELSIF nvl(l_customer_gsa_indicator,'N') <> 'Y'
758: THEN
759:
760: oe_debug_pub.add('customer GSA = '||l_customer_gsa_indicator);
761: l_return_status := FND_API.G_RET_STS_ERROR;
762:
763: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
764: THEN

Line 777: oe_debug_pub.add('exception GSA indicator in header is null');

773: END IF;
774:
775: EXCEPTION
776: when no_data_found then
777: oe_debug_pub.add('exception GSA indicator in header is null');
778: null;
779:
780: END;
781:

Line 785: oe_debug_pub.add('for value,'||l_return_status);

781:
782: END IF;
783:
784: --dbms_output.put_line('for value,'||l_return_status);
785: oe_debug_pub.add('for value,'||l_return_status);
786:
787: --dbms_output.put_line('org precede '||p_QUALIFIERS_rec.qualifier_precedence);
788: --dbms_output.put_line('n precede '||l_precedence);
789: oe_debug_pub.add('org precede '||p_QUALIFIERS_rec.qualifier_precedence);

Line 789: oe_debug_pub.add('org precede '||p_QUALIFIERS_rec.qualifier_precedence);

785: oe_debug_pub.add('for value,'||l_return_status);
786:
787: --dbms_output.put_line('org precede '||p_QUALIFIERS_rec.qualifier_precedence);
788: --dbms_output.put_line('n precede '||l_precedence);
789: oe_debug_pub.add('org precede '||p_QUALIFIERS_rec.qualifier_precedence);
790: oe_debug_pub.add('n precede '||l_precedence);
791:
792: /*If p_QUALIFIERS_rec.qualifier_precedence <> l_precedence --- invalid precedence
793: Then

Line 790: oe_debug_pub.add('n precede '||l_precedence);

786:
787: --dbms_output.put_line('org precede '||p_QUALIFIERS_rec.qualifier_precedence);
788: --dbms_output.put_line('n precede '||l_precedence);
789: oe_debug_pub.add('org precede '||p_QUALIFIERS_rec.qualifier_precedence);
790: oe_debug_pub.add('n precede '||l_precedence);
791:
792: /*If p_QUALIFIERS_rec.qualifier_precedence <> l_precedence --- invalid precedence
793: Then
794: l_return_status := FND_API.G_RET_STS_ERROR;

Line 831: oe_debug_pub.add('qualifier datatype,'||l_return_status);

827:
828:
829:
830: --dbms_output.put_line('for datatype,'||l_return_status);
831: oe_debug_pub.add('qualifier datatype,'||l_return_status);
832:
833:
834:
835: --validation for canonical form

Line 976: OE_Debug_Pub.add ( 'Value Set 1' || l_start_date_active || l_end_date_active );

972: into l_start_date_active, l_end_date_active, l_list_header_id_1
973: from qp_list_lines
974: where list_line_id = p_qualifiers_rec.list_line_id;
975:
976: OE_Debug_Pub.add ( 'Value Set 1' || l_start_date_active || l_end_date_active );
977:
978: -- oe_debug_pub.add('about to delete a request to check duplicate modifier list lines without product attribute');
979:
980: QP_delayed_requests_pvt.Delete_Request

Line 978: -- oe_debug_pub.add('about to delete a request to check duplicate modifier list lines without product attribute');

974: where list_line_id = p_qualifiers_rec.list_line_id;
975:
976: OE_Debug_Pub.add ( 'Value Set 1' || l_start_date_active || l_end_date_active );
977:
978: -- oe_debug_pub.add('about to delete a request to check duplicate modifier list lines without product attribute');
979:
980: QP_delayed_requests_pvt.Delete_Request
981: ( p_entity_code => QP_GLOBALS.G_ENTITY_ALL
982: , p_entity_id => p_qualifiers_rec.list_line_id

Line 989: oe_debug_pub.add('failed in logging a delayed request ');

985: );
986:
987: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
988:
989: oe_debug_pub.add('failed in logging a delayed request ');
990:
991: RAISE FND_API.G_EXC_ERROR;
992:
993: END IF;

Line 997: oe_debug_pub.add('about to log a request to check duplicate modifier list lines with product attribute');

993: END IF;
994:
995: /* After deleting request if any log a new request to check duplicate modifier list lines with product attribute */
996:
997: oe_debug_pub.add('about to log a request to check duplicate modifier list lines with product attribute');
998:
999: select count(*) into p_attr_count
1000: from qp_pricing_attributes
1001: where list_line_id = p_qualifiers_rec.list_line_id;

Line 1022: oe_debug_pub.add('failed in logging a delayed request ');

1018: );
1019:
1020: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1021:
1022: oe_debug_pub.add('failed in logging a delayed request ');
1023:
1024: RAISE FND_API.G_EXC_ERROR;
1025:
1026: END IF;

Line 1053: oe_debug_pub.add('failed in logging a delayed request for duplicate modifiers');

1049: );
1050:
1051: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1052:
1053: oe_debug_pub.add('failed in logging a delayed request for duplicate modifiers');
1054:
1055: RAISE FND_API.G_EXC_ERROR;
1056:
1057: END IF;

Line 1059: oe_debug_pub.add('after logging delayed request from qualfiers ');

1055: RAISE FND_API.G_EXC_ERROR;
1056:
1057: END IF;
1058: END IF;
1059: oe_debug_pub.add('after logging delayed request from qualfiers ');
1060: END IF;
1061:
1062:
1063: