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 218: oe_debug_pub.add('entity validation for qualifier id');

214: -- Check required attributes.
215:
216:
217: --dbms_output.put_line('entity validation for qualifier id');
218: oe_debug_pub.add('entity validation for qualifier id');
219: oe_debug_pub.add('entity validation for qualifier id'||p_QUALIFIERS_rec.qualifier_id);
220:
221:
222:

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

215:
216:
217: --dbms_output.put_line('entity validation for qualifier id');
218: oe_debug_pub.add('entity validation for qualifier id');
219: oe_debug_pub.add('entity validation for qualifier id'||p_QUALIFIERS_rec.qualifier_id);
220:
221:
222:
223:

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

237:
238: END IF;
239:
240: --dbms_output.put_line('entity validation for qualifier id status '|| l_return_status);
241: oe_debug_pub.add('entity null validation for qualifier id status '|| l_return_status);
242: --dbms_output.put_line('entity validation for qualifier grouping no');
243: oe_debug_pub.add('entity validation for qualifier grouping no');
244:
245:

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

239:
240: --dbms_output.put_line('entity validation for qualifier id status '|| l_return_status);
241: oe_debug_pub.add('entity null validation for qualifier id status '|| l_return_status);
242: --dbms_output.put_line('entity validation for qualifier grouping no');
243: oe_debug_pub.add('entity validation for qualifier grouping no');
244:
245:
246:
247:

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

267:
268: END IF;
269:
270:
271: --oe_debug_pub.add('entity null validation for qualifier group id status '|| l_return_status);
272: --dbms_output.put_line('entity validation for qualifier group id status '|| l_return_status);
273:
274: --dbms_output.put_line('entity validation for qualifier attr_value');
275:

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

272: --dbms_output.put_line('entity validation for qualifier group id status '|| l_return_status);
273:
274: --dbms_output.put_line('entity validation for qualifier attr_value');
275:
276: --oe_debug_pub.add('entity validation for attr_value with value as '
277: -- || p_QUALIFIERS_rec.qualifier_attr_value);
278:
279:
280: -- qualifier_attr_value can be null when the operator is

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

302:
303:
304:
305: --dbms_output.put_line('entity validation for qualifier attr value '|| l_return_status);
306: oe_debug_pub.add('entity validation for qualifier attr value '|| l_return_status);
307:
308:
309: --dbms_output.put_line('entity validation for qualifier attribute');
310:

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

329:
330:
331:
332: --dbms_output.put_line('entity validation for qualifier attr '|| l_return_status);
333: oe_debug_pub.add('entity null validation for qualifier attr '|| l_return_status);
334:
335:
336:
337: --dbms_output.put_line('entity validation for qualifier context');

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

355: END IF;
356:
357:
358: --dbms_output.put_line('entity null validation for qualifier context '|| l_return_status);
359: oe_debug_pub.add('entity validation for qualifier context '|| l_return_status);
360: --dbms_output.put_line('entity validation for comparison operator ');
361:
362:
363:

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

382:
383:
384:
385: --dbms_output.put_line('entity validation for compari '|| l_return_status);
386: oe_debug_pub.add('entity validation for compari '|| l_return_status);
387: --dbms_output.put_line('entity validation for excluder flag operator ');
388:
389: /* Added for bug2368511 */
390:

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

404: END IF;
405:
406: END IF;
407:
408: oe_debug_pub.add('entity validation for List Line Id '|| l_return_status);
409:
410:
411: IF p_QUALIFIERS_rec.excluder_flag IS NULL
412: THEN

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

427:
428:
429:
430: --dbms_output.put_line('entity validation for excluder '|| l_return_status);
431: oe_debug_pub.add('entity validation for excluder '|| l_return_status);
432: -- Return Error if a required attribute is missing.
433:
434:
435:

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

540: END IF;
541:
542:
543: --dbms_output.put_line('entity validation for start_date '||l_return_status);
544: oe_debug_pub.add('entity validation for start_date '||l_return_status);
545: --dbms_output.put_line('entity validation for value to ');
546:
547:
548:

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

591:
592:
593:
594: --dbms_output.put_line('entity validation for value to '||l_return_status);
595: oe_debug_pub.add('entity validation for value to '||l_return_status);
596:
597:
598:
599: --Other Validations

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

676:
677: End If;*/
678:
679: --dbms_output.put_line('entity validation for duplicaet id '||l_return_status);
680: oe_debug_pub.add('entity validation for duplicaet id '||l_return_status);
681:
682:
683:
684:

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

711: End If;
712:
713:
714: --dbms_output.put_line('entity validation for compa2 '||l_return_status);
715: oe_debug_pub.add('entity validation for compa2 '||l_return_status);
716:
717:
718:
719: --Validate Qualifier_Context , Qualifier_attribute ,Qualifier_Attr Value

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

791: End If;
792:
793:
794: --dbms_output.put_line('for attributr '||l_return_status);
795: oe_debug_pub.add('for context '||l_return_status);
796:
797:
798: --- validate qualifier_attr_value only if comparison operator is
799: -- '='

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

821: AND p_QUALIFIERS_rec.qualifier_attribute = 'QUALIFIER_ATTRIBUTE2'
822: AND p_QUALIFIERS_rec.list_header_id IS NOT NULL
823: THEN
824:
825: oe_debug_pub.add('attcching');
826: BEGIN
827:
828: select gsa_indicator
829: into l_gsa_indicator

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

832:
833: IF nvl(l_gsa_indicator,'N') = 'Y'
834: THEN
835:
836: oe_debug_pub.add('GSA = Y');
837: select decode(party.party_type,'ORGANIZATION',party.gsa_indicator_flag,'N')
838: into l_customer_gsa_indicator
839: from hz_cust_accounts cust_acct,hz_parties party
840: where cust_acct.party_id = party.party_id and

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

842:
843: IF SQL%NOTFOUND
844: THEN
845:
846: oe_debug_pub.add('customer GSA not found');
847: l_return_status := FND_API.G_RET_STS_ERROR;
848:
849: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
850: THEN

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

856:
857: ELSIF nvl(l_customer_gsa_indicator,'N') <> 'Y'
858: THEN
859:
860: oe_debug_pub.add('customer GSA = '||l_customer_gsa_indicator);
861: l_return_status := FND_API.G_RET_STS_ERROR;
862:
863: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
864: THEN

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

873: END IF;
874:
875: EXCEPTION
876: when no_data_found then
877: oe_debug_pub.add('exception GSA indicator in header is null');
878: null;
879:
880: END;
881:

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

881:
882: END IF;
883:
884: --dbms_output.put_line('for value,'||l_return_status);
885: oe_debug_pub.add('for value,'||l_return_status);
886:
887: --dbms_output.put_line('org precede '||p_QUALIFIERS_rec.qualifier_precedence);
888: --dbms_output.put_line('n precede '||l_precedence);
889: oe_debug_pub.add('org precede '||p_QUALIFIERS_rec.qualifier_precedence);

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

885: oe_debug_pub.add('for value,'||l_return_status);
886:
887: --dbms_output.put_line('org precede '||p_QUALIFIERS_rec.qualifier_precedence);
888: --dbms_output.put_line('n precede '||l_precedence);
889: oe_debug_pub.add('org precede '||p_QUALIFIERS_rec.qualifier_precedence);
890: oe_debug_pub.add('n precede '||l_precedence);
891:
892: /*If p_QUALIFIERS_rec.qualifier_precedence <> l_precedence --- invalid precedence
893: Then

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

886:
887: --dbms_output.put_line('org precede '||p_QUALIFIERS_rec.qualifier_precedence);
888: --dbms_output.put_line('n precede '||l_precedence);
889: oe_debug_pub.add('org precede '||p_QUALIFIERS_rec.qualifier_precedence);
890: oe_debug_pub.add('n precede '||l_precedence);
891:
892: /*If p_QUALIFIERS_rec.qualifier_precedence <> l_precedence --- invalid precedence
893: Then
894: l_return_status := FND_API.G_RET_STS_ERROR;

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

927:
928:
929:
930: --dbms_output.put_line('for datatype,'||l_return_status);
931: oe_debug_pub.add('qualifier datatype,'||l_return_status);
932:
933:
934:
935: --validation for canonical form

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

1072: into l_start_date_active, l_end_date_active, l_list_header_id_1
1073: from qp_list_lines
1074: where list_line_id = p_qualifiers_rec.list_line_id;
1075:
1076: OE_Debug_Pub.add ( 'Value Set 1' || l_start_date_active || l_end_date_active );
1077:
1078: -- oe_debug_pub.add('about to delete a request to check duplicate modifier list lines without product attribute');
1079:
1080: QP_delayed_requests_pvt.Delete_Request

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

1074: where list_line_id = p_qualifiers_rec.list_line_id;
1075:
1076: OE_Debug_Pub.add ( 'Value Set 1' || l_start_date_active || l_end_date_active );
1077:
1078: -- oe_debug_pub.add('about to delete a request to check duplicate modifier list lines without product attribute');
1079:
1080: QP_delayed_requests_pvt.Delete_Request
1081: ( p_entity_code => QP_GLOBALS.G_ENTITY_ALL
1082: , p_entity_id => p_qualifiers_rec.list_line_id

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

1085: );
1086:
1087: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1088:
1089: oe_debug_pub.add('failed in logging a delayed request ');
1090:
1091: RAISE FND_API.G_EXC_ERROR;
1092:
1093: END IF;

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

1093: END IF;
1094:
1095: /* After deleting request if any log a new request to check duplicate modifier list lines with product attribute */
1096:
1097: oe_debug_pub.add('about to log a request to check duplicate modifier list lines with product attribute');
1098:
1099: select count(*) into p_attr_count
1100: from qp_pricing_attributes
1101: where list_line_id = p_qualifiers_rec.list_line_id;

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

1118: );
1119:
1120: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1121:
1122: oe_debug_pub.add('failed in logging a delayed request ');
1123:
1124: RAISE FND_API.G_EXC_ERROR;
1125:
1126: END IF;

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

1149: );
1150:
1151: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1152:
1153: oe_debug_pub.add('failed in logging a delayed request for duplicate modifiers');
1154:
1155: RAISE FND_API.G_EXC_ERROR;
1156:
1157: END IF;

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

1155: RAISE FND_API.G_EXC_ERROR;
1156:
1157: END IF;
1158: END IF;
1159: oe_debug_pub.add('after logging delayed request from qualfiers ');
1160: END IF;
1161:
1162:
1163: