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

Line 49: oe_debug_pub.add('Entering Procedure Check_for_Request in Package QP_Delayed_Requests_Pvt');

45: BEGIN
46: x_return_status := FND_API.G_RET_STS_SUCCESS;
47: x_result := FND_API.G_FALSE;
48:
49: oe_debug_pub.add('Entering Procedure Check_for_Request in Package QP_Delayed_Requests_Pvt');
50:
51: -- 2502849 l_ind to l_max_ind is the range of index positions that can
52: -- hold requests for this entity id - for e.g. if entity_id is
53: -- 2341 and G_MAX_REQUESTS is 1000 then the range would be:

Line 151: oe_debug_pub.add('Entering Procedure Process_Request_Pvt ');

147:
148:
149: BEGIN
150:
151: oe_debug_pub.add('Entering Procedure Process_Request_Pvt ');
152: --dbms_output.put_line('Entering Procedure Process_Request_Pvt ');
153:
154: x_return_status := FND_API.G_RET_STS_SUCCESS;
155:

Line 156: oe_debug_pub.add('Request processed '||G_Delayed_Requests(p_request_ind).processed);

152: --dbms_output.put_line('Entering Procedure Process_Request_Pvt ');
153:
154: x_return_status := FND_API.G_RET_STS_SUCCESS;
155:
156: oe_debug_pub.add('Request processed '||G_Delayed_Requests(p_request_ind).processed);
157:
158: -- if request has already been processed ('Y') or if the request is
159: -- being processed ('I'): this would occur if request resulted in
160: -- to a recursive call to process order.

Line 171: oe_debug_pub.add('Request type '||l_request_type);

167: l_entity_code := l_request_rec.entity_code;
168: l_entity_Id := l_request_rec.entity_Id;
169: l_request_type := l_request_rec.request_type;
170:
171: oe_debug_pub.add('Request type '||l_request_type);
172: oe_debug_pub.add('entity code '||l_entity_code);
173: oe_debug_pub.add('entity id '||l_entity_Id);
174:
175: G_Delayed_Requests(p_request_ind).processed := 'I';

Line 172: oe_debug_pub.add('entity code '||l_entity_code);

168: l_entity_Id := l_request_rec.entity_Id;
169: l_request_type := l_request_rec.request_type;
170:
171: oe_debug_pub.add('Request type '||l_request_type);
172: oe_debug_pub.add('entity code '||l_entity_code);
173: oe_debug_pub.add('entity id '||l_entity_Id);
174:
175: G_Delayed_Requests(p_request_ind).processed := 'I';
176:

Line 173: oe_debug_pub.add('entity id '||l_entity_Id);

169: l_request_type := l_request_rec.request_type;
170:
171: oe_debug_pub.add('Request type '||l_request_type);
172: oe_debug_pub.add('entity code '||l_entity_code);
173: oe_debug_pub.add('entity id '||l_entity_Id);
174:
175: G_Delayed_Requests(p_request_ind).processed := 'I';
176:
177:

Line 286: oe_debug_pub.add('Processing check_mult_price_break_attrs');

282:
283:
284: IF l_request_type = QP_GLOBALS.G_MULTIPLE_PRICE_BREAK_ATTRS
285: THEN
286: oe_debug_pub.add('Processing check_mult_price_break_attrs');
287: QP_DELAYED_REQUESTS_UTIL.Check_Mult_Price_Break_Attrs(
288: p_parent_list_line_id => l_request_rec.param1,
289: x_return_status => l_return_status);
290: END IF;

Line 301: oe_debug_pub.add('Processing check_mult_price_break_attrs');

297:
298:
299: IF l_request_type = QP_GLOBALS.G_MIXED_QUAL_SEG_LEVELS
300: THEN
301: oe_debug_pub.add('Processing check_mult_price_break_attrs');
302: QP_DELAYED_REQUESTS_UTIL.Check_Mixed_Qual_Seg_Levels(
303: x_return_status => l_return_status,
304: p_qualifier_rule_id => l_request_rec.param1);
305: END IF;

Line 535: oe_debug_pub.add('qual context'||l_request_rec.param3||' attr '||l_request_rec.param4||' grp no '||l_request_rec.param2);

531:
532: /*fix for bug 1501138*/
533: IF l_request_type = QP_GLOBALS.G_WARN_SAME_QUALIFIER_GROUP
534: THEN
535: oe_debug_pub.add('qual context'||l_request_rec.param3||' attr '||l_request_rec.param4||' grp no '||l_request_rec.param2);
536:
537: /*
538: QP_DELAYED_REQUESTS_UTIL.Warn_same_qualifier_group(
539: p_list_header_id => l_entity_id,

Line 547: oe_debug_pub.add('after qual context'||l_request_rec.param3||' attr '||l_request_rec.param4||' grp no '||l_request_rec.param3);

543: p_qualifier_attribute => l_request_rec.param4,
544: x_return_status => l_return_status);
545: */
546:
547: oe_debug_pub.add('after qual context'||l_request_rec.param3||' attr '||l_request_rec.param4||' grp no '||l_request_rec.param3);
548: null;
549: END IF;
550:
551: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 577: oe_debug_pub.add('processing req UPDATE_PRICING_PHASE');

573: /*included by spgopal for pricing phase seeded data over-write problem to update the denormalised columns in QP_PRICING_PHASES*/
574:
575: IF l_request_type = QP_GLOBALS.G_UPDATE_PRICING_PHASE
576: THEN
577: oe_debug_pub.add('processing req UPDATE_PRICING_PHASE');
578: QP_DELAYED_REQUESTS_UTIL.update_pricing_phase(
579: p_pricing_phase_id => l_request_rec.param1,
580: p_automatic_flag => l_request_rec.param2, --fix for bug 3756625
581: p_count => l_request_rec.param3,

Line 595: oe_debug_pub.add('processing req UPDATE_MANUAL_MODIFIER_FLAG');

591:
592: -- Essilor Fix bug 2789138
593: IF l_request_type = QP_GLOBALS.G_UPDATE_MANUAL_MODIFIER_FLAG
594: THEN
595: oe_debug_pub.add('processing req UPDATE_MANUAL_MODIFIER_FLAG');
596: QP_DELAYED_REQUESTS_UTIL.Update_manual_modifier_flag(
597: p_pricing_phase_id => l_request_rec.param1,
598: p_automatic_flag => l_request_rec.param2,
599: x_return_status => l_return_status);

Line 611: oe_debug_pub.add('processing req UPDATE_HVOP');

607:
608: --hvop
609: IF l_request_type = QP_GLOBALS.G_UPDATE_HVOP
610: THEN
611: oe_debug_pub.add('processing req UPDATE_HVOP');
612: QP_DELAYED_REQUESTS_UTIL.HVOP_Pricing_Setup (x_return_status => l_return_status);
613: END IF;
614:
615: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 626: oe_debug_pub.add('Processing req Attribute Groups');

622: --pattern
623: IF QP_JAVA_ENGINE_UTIL_PUB.Java_Engine_Installed = 'Y' THEN
624:
625: IF l_request_type = QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN THEN
626: oe_debug_pub.add('Processing req Attribute Groups');
627: QP_DELAYED_REQUESTS_UTIL.maintain_header_pattern(
628: p_list_header_id => l_request_rec.entity_Id
629: , p_qualifier_group => l_request_rec.request_unique_key1
630: , p_setup_action => l_request_rec.request_unique_key2

Line 639: oe_debug_pub.add('Processing req Attribute Groups');

635: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
636: RAISE FND_API.G_EXC_ERROR;
637: END IF;
638: IF l_request_type = QP_GLOBALS.G_MAINTAIN_LINE_PATTERN THEN
639: oe_debug_pub.add('Processing req Attribute Groups');
640: QP_DELAYED_REQUESTS_UTIL.maintain_line_pattern(
641: p_list_header_id => l_request_rec.entity_Id
642: , p_list_line_id => l_request_rec.request_unique_key1
643: , p_qualifier_group => l_request_rec.request_unique_key2

Line 654: oe_debug_pub.add('Processing req Attribute Groups');

650: RAISE FND_API.G_EXC_ERROR;
651: END IF;
652:
653: IF l_request_type = QP_GLOBALS.G_MAINTAIN_PRODUCT_PATTERN THEN
654: oe_debug_pub.add('Processing req Attribute Groups');
655: QP_DELAYED_REQUESTS_UTIL.maintain_product_pattern(
656: p_list_header_id => l_request_rec.entity_Id
657: , p_list_line_id => l_request_rec.request_unique_key1
658: , p_setup_action => l_request_rec.request_unique_key2

Line 673: oe_debug_pub.add('processing req VALIDATE_SELLING_ROUNDING');

669: --pattern
670:
671: IF l_request_type = QP_GLOBALS.G_VALIDATE_SELLING_ROUNDING
672: THEN
673: oe_debug_pub.add('processing req VALIDATE_SELLING_ROUNDING');
674: QP_DELAYED_REQUESTS_UTIL.validate_selling_rounding(
675: p_currency_header_id => l_entity_id,
676: p_to_currency_code => l_request_rec.param1,
677: x_return_status => l_return_status);

Line 689: oe_debug_pub.add('processing req CHECK_SEGMENT_LEVEL_IN_GROUP');

685:
686:
687: IF l_request_type = QP_GLOBALS.G_CHECK_SEGMENT_LEVEL_IN_GROUP
688: THEN
689: oe_debug_pub.add('processing req CHECK_SEGMENT_LEVEL_IN_GROUP');
690: QP_DELAYED_REQUESTS_UTIL.check_segment_level_in_group(
691: p_list_line_id => l_entity_id,
692: p_list_header_id => l_request_rec.request_unique_key1,
693: p_qualifier_grouping_no => l_request_rec.request_unique_key2,

Line 705: oe_debug_pub.add('processing req CHECK_LINE_FOR_HEADER_QUAL');

701: END IF;
702:
703: IF l_request_type = QP_GLOBALS.G_CHECK_LINE_FOR_HEADER_QUAL
704: THEN
705: oe_debug_pub.add('processing req CHECK_LINE_FOR_HEADER_QUAL');
706: QP_DELAYED_REQUESTS_UTIL.CHECK_LINE_FOR_HEADER_QUAL(
707: p_list_header_id => l_entity_id,
708: p_list_line_id => l_request_rec.request_unique_key1,
709: x_return_status => l_return_status);

Line 720: oe_debug_pub.add('processing req CHECK_ENABLED_FUNC_AREAS');

716: END IF;
717:
718: -- Hierarchical Categories (sfiresto)
719: IF l_request_type = QP_GLOBALS.G_CHECK_ENABLED_FUNC_AREAS THEN
720: oe_debug_pub.add('processing req CHECK_ENABLED_FUNC_AREAS');
721: QP_DELAYED_REQUESTS_UTIL.Check_Enabled_Func_Areas(
722: p_pte_source_system_id => l_entity_id,
723: x_return_status => l_return_status);
724: END IF;

Line 738: oe_debug_pub.add('processing req G_UPDATE_CHANGED_LINES_ADD');

734: -- delayed request for changed lines
735: if QP_PERF_PVT.enabled = 'Y' then
736:
737: if l_request_type = QP_GLOBALS.G_UPDATE_CHANGED_LINES_ADD then
738: oe_debug_pub.add('processing req G_UPDATE_CHANGED_LINES_ADD');
739: QP_DELAYED_REQUESTS_UTIL.update_changed_lines_add(
740: p_list_line_id => l_entity_id,
741: p_list_header_id => l_request_rec.param2,
742: p_pricing_phase_id => l_request_rec.param1,

Line 745: oe_debug_pub.add('processing req G_UPDATE_CHANGED_LINES_DEL');

741: p_list_header_id => l_request_rec.param2,
742: p_pricing_phase_id => l_request_rec.param1,
743: x_return_status => l_return_status);
744: elsif l_request_type = QP_GLOBALS.G_UPDATE_CHANGED_LINES_DEL then
745: oe_debug_pub.add('processing req G_UPDATE_CHANGED_LINES_DEL');
746: QP_DELAYED_REQUESTS_UTIL.update_changed_lines_del(
747: p_list_line_id => l_entity_id,
748: p_list_header_id => l_request_rec.param2,
749: p_pricing_phase_id => l_request_rec.param1,

Line 754: oe_debug_pub.add('processing req G_UPDATE_CHANGED_LINES_PHASE');

750: p_product_attribute => l_request_rec.param3,
751: p_product_attr_value => l_request_rec.param4,
752: x_return_status => l_return_status);
753: elsif l_request_type = QP_GLOBALS.G_UPDATE_CHANGED_LINES_PH then
754: oe_debug_pub.add('processing req G_UPDATE_CHANGED_LINES_PHASE');
755: QP_DELAYED_REQUESTS_UTIL.update_changed_lines_ph(
756: p_list_line_id => l_entity_id,
757: p_list_header_id => l_request_rec.param2,
758: p_pricing_phase_id => l_request_rec.param1,

Line 762: oe_debug_pub.add('processing req G_UPDATE_CHANGED_LINES_ACTIVE');

758: p_pricing_phase_id => l_request_rec.param1,
759: p_old_pricing_phase_id => l_request_rec.param3,
760: x_return_status => l_return_status);
761: elsif l_request_type = QP_GLOBALS.G_UPDATE_CHANGED_LINES_ACT then
762: oe_debug_pub.add('processing req G_UPDATE_CHANGED_LINES_ACTIVE');
763: QP_DELAYED_REQUESTS_UTIL.update_changed_lines_act(
764: p_list_header_id => l_entity_id,
765: p_active_flag => l_request_rec.param1,
766: x_return_status => l_return_status);

Line 768: oe_debug_pub.add('processing req G_UPDATE_HVOP')

764: p_list_header_id => l_entity_id,
765: p_active_flag => l_request_rec.param1,
766: x_return_status => l_return_status);
767: --hvop elsif l_request_type = QP_GLOBALS.G_UPDATE_HVOP then
768: oe_debug_pub.add('processing req G_UPDATE_HVOP')
769: ;
770: QP_DELAYED_REQUESTS_UTIL.HVOP_Pricing_Setup(x_return_status => l_return_status);
771: --hvop
772: end if;

Line 824: oe_debug_pub.add('Exiting Process_Request_Pvt no_data_found exception ');

820: G_Delayed_Requests(p_request_ind).processed := 'N';
821: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
822:
823: WHEN NO_DATA_FOUND THEN
824: oe_debug_pub.add('Exiting Process_Request_Pvt no_data_found exception ');
825: G_Delayed_Requests(p_request_ind).processed := 'N';
826: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
827:
828:

Line 849: oe_debug_pub.add('Exiting Process_Request_Pvt with others exception ');

845: , 'Process_Request_Pvt'
846: );
847: END IF;
848:
849: oe_debug_pub.add('Exiting Process_Request_Pvt with others exception ');
850:
851:
852: End Process_Request_Pvt;
853: /** End Local Procedures **/

Line 904: oe_debug_pub.add('Entering Procedure Log_Request in Package QP_Delayed_Requests_Pvt');

900: l_request QP_QUALIFIER_RULES_PUB.REQUEST_REC_TYPE;
901: l_req_entity QP_QUALIFIER_RULES_PUB.Requesting_Entity_Rec_Type;
902: BEGIN
903:
904: oe_debug_pub.add('Entering Procedure Log_Request in Package QP_Delayed_Requests_Pvt');
905: oe_debug_pub.add('log_request_type'||p_request_type);
906:
907: -- Initialize the request_record
908: l_request.request_type := p_request_type;

Line 905: oe_debug_pub.add('log_request_type'||p_request_type);

901: l_req_entity QP_QUALIFIER_RULES_PUB.Requesting_Entity_Rec_Type;
902: BEGIN
903:
904: oe_debug_pub.add('Entering Procedure Log_Request in Package QP_Delayed_Requests_Pvt');
905: oe_debug_pub.add('log_request_type'||p_request_type);
906:
907: -- Initialize the request_record
908: l_request.request_type := p_request_type;
909: l_request.entity_id := p_entity_id;

Line 967: OE_Debug_PUB.ADD('Request replaced');

963:
964: l_request.processed := 'N';
965: IF l_request_search_rslt = FND_API.g_true -- replace the request
966: THEN
967: OE_Debug_PUB.ADD('Request replaced');
968: g_delayed_requests(l_request_ind) := l_request;
969:
970: ELSE -- insert the new request
971: OE_Debug_PUB.ADD('New request inserted');

Line 971: OE_Debug_PUB.ADD('New request inserted');

967: OE_Debug_PUB.ADD('Request replaced');
968: g_delayed_requests(l_request_ind) := l_request;
969:
970: ELSE -- insert the new request
971: OE_Debug_PUB.ADD('New request inserted');
972: -- l_request_ind := nvl(g_delayed_requests.LAST, 0) + 1; --2502849
973: g_delayed_requests(l_request_ind) := l_request; --Added for 2502849
974: END IF;
975:

Line 985: oe_debug_pub.add('end of log request');

981: l_req_entity_ind := nvl(g_requesting_entities.LAST, 0) + 1;
982: -- Insert into the requesting entities table
983: g_requesting_entities(l_req_entity_ind) := l_req_entity;
984: END IF;--2650093
985: oe_debug_pub.add('end of log request');
986:
987: EXCEPTION
988:
989: WHEN FND_API.G_EXC_ERROR THEN

Line 1065: oe_debug_pub.add('Entering Procedure Delete_Request in Package QP_Delayed_Requests_Pvt');

1061: l_request_ind number;
1062: l_req_entity_ind number;
1063: BEGIN
1064:
1065: oe_debug_pub.add('Entering Procedure Delete_Request in Package QP_Delayed_Requests_Pvt');
1066:
1067: x_return_status := FND_API.G_RET_STS_SUCCESS;
1068: IF p_entity_id IS NOT NULL THEN --2650093
1069: Check_for_Request( p_entity_code => p_entity_code

Line 1136: oe_debug_pub.add('Entering Procedure Clear_Request in Package QP_Delayed_Requests_Pvt');

1132: Procedure Clear_Request( x_return_status OUT NOCOPY VARCHAR2)
1133: IS
1134: BEGIN
1135:
1136: oe_debug_pub.add('Entering Procedure Clear_Request in Package QP_Delayed_Requests_Pvt');
1137:
1138: x_return_status := FND_API.G_RET_STS_SUCCESS;
1139:
1140: G_Delayed_Requests.DELETE;

Line 1175: oe_debug_pub.add('Entering Procedure Process_Request in Package QP_Delayed_Requests_Pvt');

1171: l_return_status Varchar2(30);
1172: Begin
1173: x_return_status := FND_API.G_RET_STS_SUCCESS;
1174:
1175: oe_debug_pub.add('Entering Procedure Process_Request in Package QP_Delayed_Requests_Pvt');
1176: IF p_entity_id IS NOT NULL THEN --2650093
1177: Check_for_Request( p_entity_code => p_entity_code
1178: ,p_entity_id => p_entity_id
1179: ,p_request_type => p_request_type

Line 1243: oe_debug_pub.add('Entering Procedure Process_Request_for_Entity in Package QP_Delayed_Requests_Pvt');

1239: l_ind Number;
1240: Begin
1241: x_return_status := FND_API.G_RET_STS_SUCCESS;
1242:
1243: oe_debug_pub.add('Entering Procedure Process_Request_for_Entity in Package QP_Delayed_Requests_Pvt');
1244: --dbms_output.put_line('Entering Procedure Process_Request_for_Entity in Package QP_Delayed_Requests_Pvt');
1245: --dbms_output.put_line('entity id is ' ||p_entity_code);
1246:
1247: l_ind := G_Delayed_Requests.first;

Line 1250: oe_debug_pub.add('entity is ' ||G_Delayed_Requests(l_ind).Entity_code);

1246:
1247: l_ind := G_Delayed_Requests.first;
1248:
1249: /*WHILE l_ind IS NOT NULL loop
1250: oe_debug_pub.add('entity is ' ||G_Delayed_Requests(l_ind).Entity_code);
1251: --dbms_output.put_line('entity is ' ||G_Delayed_Requests(l_ind).Entity_code);
1252: oe_debug_pub.add('entity id is ' ||G_Delayed_Requests(l_ind).Entity_id);
1253: --dbms_output.put_line('entity id is ' ||G_Delayed_Requests(l_ind).Entity_id);
1254: END LOOP;*/

Line 1252: oe_debug_pub.add('entity id is ' ||G_Delayed_Requests(l_ind).Entity_id);

1248:
1249: /*WHILE l_ind IS NOT NULL loop
1250: oe_debug_pub.add('entity is ' ||G_Delayed_Requests(l_ind).Entity_code);
1251: --dbms_output.put_line('entity is ' ||G_Delayed_Requests(l_ind).Entity_code);
1252: oe_debug_pub.add('entity id is ' ||G_Delayed_Requests(l_ind).Entity_id);
1253: --dbms_output.put_line('entity id is ' ||G_Delayed_Requests(l_ind).Entity_id);
1254: END LOOP;*/
1255:
1256: l_ind := G_Delayed_Requests.first;

Line 1278: oe_debug_pub.add('Exiting Process_Request_for_Entity ');

1274: --EXIT;
1275: END IF;
1276: l_ind := G_Delayed_Requests.Next(l_ind);
1277: END LOOP;
1278: oe_debug_pub.add('Exiting Process_Request_for_Entity ');
1279: --dbms_output.put_line('Exiting Process_Request_for_Entity ');
1280:
1281: EXCEPTION
1282:

Line 1303: oe_debug_pub.add('Exiting Process_Request_for_Entity ');

1299: , 'Process_Request_for_Entity'
1300: );
1301: END IF;
1302:
1303: oe_debug_pub.add('Exiting Process_Request_for_Entity ');
1304:
1305: End Process_Request_for_Entity;
1306:
1307: Procedure Process_Request_for_ReqType

Line 1317: oe_debug_pub.add('Entering Procedure Process_Request_for_ReqType in Package QP_Delayed_Requests_Pvt');

1313: l_ind Number;
1314: Begin
1315: x_return_status := FND_API.G_RET_STS_SUCCESS;
1316:
1317: oe_debug_pub.add('Entering Procedure Process_Request_for_ReqType in Package QP_Delayed_Requests_Pvt');
1318:
1319: l_ind := G_Delayed_Requests.first;
1320:
1321: WHILE l_ind IS NOT NULL LOOP

Line 1369: oe_debug_pub.add('Entering Procedure Process_Delayed_Requests in Package QP_Delayed_Requests_Pvt');

1365: ) IS
1366: l_return_status Varchar2(30);
1367: Begin
1368:
1369: oe_debug_pub.add('Entering Procedure Process_Delayed_Requests in Package QP_Delayed_Requests_Pvt');
1370:
1371: -- Process requests as per the dependency
1372: -- This procedure processes all requests.
1373: -- For each request type defined in QP_GLOBALS

Line 1664: oe_debug_pub.add('Ren: in process delayed request');

1660: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1661: RAISE FND_API.G_EXC_ERROR;
1662: END IF;
1663: end if;
1664: oe_debug_pub.add('Ren: in process delayed request');
1665:
1666: -- mkarya for pattern delayed requests
1667: IF QP_JAVA_ENGINE_UTIL_PUB.Java_Engine_Installed = 'Y' THEN
1668: Process_Request_for_ReqType