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 677: oe_debug_pub.ADD('JAGAN JAVA ENGINE INSTALLED : ' || QP_JAVA_ENGINE_UTIL_PUB.Java_Engine_Installed);

673: --pattern
674:
675: -- g_qp_pattern_search := FND_PROFILE.VALUE('QP_PATTERN_SEARCH');
676:
677: oe_debug_pub.ADD('JAGAN JAVA ENGINE INSTALLED : ' || QP_JAVA_ENGINE_UTIL_PUB.Java_Engine_Installed);
678: oe_debug_pub.ADD('JAGAN QP PATTERN SEARCH : ' || FND_PROFILE.VALUE('QP_PATTERN_SEARCH'));
679: oe_debug_pub.ADD('JAGAN REQUEST TYPE : ' || l_request_type);
680: oe_debug_pub.ADD('JAGAN ENTITY CODE : ' || l_entity_code);
681: oe_debug_pub.ADD('JAGAN REQUIRED ENTITY CODE IS : ' || QP_GLOBALS.G_ENTITY_MODIFIER_LIST ||','|| QP_GLOBALS.G_ENTITY_MODIFIERS);

Line 678: oe_debug_pub.ADD('JAGAN QP PATTERN SEARCH : ' || FND_PROFILE.VALUE('QP_PATTERN_SEARCH'));

674:
675: -- g_qp_pattern_search := FND_PROFILE.VALUE('QP_PATTERN_SEARCH');
676:
677: oe_debug_pub.ADD('JAGAN JAVA ENGINE INSTALLED : ' || QP_JAVA_ENGINE_UTIL_PUB.Java_Engine_Installed);
678: oe_debug_pub.ADD('JAGAN QP PATTERN SEARCH : ' || FND_PROFILE.VALUE('QP_PATTERN_SEARCH'));
679: oe_debug_pub.ADD('JAGAN REQUEST TYPE : ' || l_request_type);
680: oe_debug_pub.ADD('JAGAN ENTITY CODE : ' || l_entity_code);
681: oe_debug_pub.ADD('JAGAN REQUIRED ENTITY CODE IS : ' || QP_GLOBALS.G_ENTITY_MODIFIER_LIST ||','|| QP_GLOBALS.G_ENTITY_MODIFIERS);
682:

Line 679: oe_debug_pub.ADD('JAGAN REQUEST TYPE : ' || l_request_type);

675: -- g_qp_pattern_search := FND_PROFILE.VALUE('QP_PATTERN_SEARCH');
676:
677: oe_debug_pub.ADD('JAGAN JAVA ENGINE INSTALLED : ' || QP_JAVA_ENGINE_UTIL_PUB.Java_Engine_Installed);
678: oe_debug_pub.ADD('JAGAN QP PATTERN SEARCH : ' || FND_PROFILE.VALUE('QP_PATTERN_SEARCH'));
679: oe_debug_pub.ADD('JAGAN REQUEST TYPE : ' || l_request_type);
680: oe_debug_pub.ADD('JAGAN ENTITY CODE : ' || l_entity_code);
681: oe_debug_pub.ADD('JAGAN REQUIRED ENTITY CODE IS : ' || QP_GLOBALS.G_ENTITY_MODIFIER_LIST ||','|| QP_GLOBALS.G_ENTITY_MODIFIERS);
682:
683: IF QP_JAVA_ENGINE_UTIL_PUB.Java_Engine_Installed = 'N' THEN

Line 680: oe_debug_pub.ADD('JAGAN ENTITY CODE : ' || l_entity_code);

676:
677: oe_debug_pub.ADD('JAGAN JAVA ENGINE INSTALLED : ' || QP_JAVA_ENGINE_UTIL_PUB.Java_Engine_Installed);
678: oe_debug_pub.ADD('JAGAN QP PATTERN SEARCH : ' || FND_PROFILE.VALUE('QP_PATTERN_SEARCH'));
679: oe_debug_pub.ADD('JAGAN REQUEST TYPE : ' || l_request_type);
680: oe_debug_pub.ADD('JAGAN ENTITY CODE : ' || l_entity_code);
681: oe_debug_pub.ADD('JAGAN REQUIRED ENTITY CODE IS : ' || QP_GLOBALS.G_ENTITY_MODIFIER_LIST ||','|| QP_GLOBALS.G_ENTITY_MODIFIERS);
682:
683: IF QP_JAVA_ENGINE_UTIL_PUB.Java_Engine_Installed = 'N' THEN
684: IF FND_PROFILE.VALUE('QP_PATTERN_SEARCH') = 'M' OR FND_PROFILE.VALUE('QP_PATTERN_SEARCH') = 'P' OR FND_PROFILE.VALUE('QP_PATTERN_SEARCH') = 'B' THEN

Line 681: oe_debug_pub.ADD('JAGAN REQUIRED ENTITY CODE IS : ' || QP_GLOBALS.G_ENTITY_MODIFIER_LIST ||','|| QP_GLOBALS.G_ENTITY_MODIFIERS);

677: oe_debug_pub.ADD('JAGAN JAVA ENGINE INSTALLED : ' || QP_JAVA_ENGINE_UTIL_PUB.Java_Engine_Installed);
678: oe_debug_pub.ADD('JAGAN QP PATTERN SEARCH : ' || FND_PROFILE.VALUE('QP_PATTERN_SEARCH'));
679: oe_debug_pub.ADD('JAGAN REQUEST TYPE : ' || l_request_type);
680: oe_debug_pub.ADD('JAGAN ENTITY CODE : ' || l_entity_code);
681: oe_debug_pub.ADD('JAGAN REQUIRED ENTITY CODE IS : ' || QP_GLOBALS.G_ENTITY_MODIFIER_LIST ||','|| QP_GLOBALS.G_ENTITY_MODIFIERS);
682:
683: IF QP_JAVA_ENGINE_UTIL_PUB.Java_Engine_Installed = 'N' THEN
684: IF FND_PROFILE.VALUE('QP_PATTERN_SEARCH') = 'M' OR FND_PROFILE.VALUE('QP_PATTERN_SEARCH') = 'P' OR FND_PROFILE.VALUE('QP_PATTERN_SEARCH') = 'B' THEN
685: --AND ( l_entity_code = QP_GLOBALS.G_ENTITY_MODIFIER_LIST OR l_entity_code = QP_GLOBALS.G_ENTITY_MODIFIERS OR l_entity_code = QP_GLOBALS.G_ENTITY_ALL) THEN

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

684: IF FND_PROFILE.VALUE('QP_PATTERN_SEARCH') = 'M' OR FND_PROFILE.VALUE('QP_PATTERN_SEARCH') = 'P' OR FND_PROFILE.VALUE('QP_PATTERN_SEARCH') = 'B' THEN
685: --AND ( l_entity_code = QP_GLOBALS.G_ENTITY_MODIFIER_LIST OR l_entity_code = QP_GLOBALS.G_ENTITY_MODIFIERS OR l_entity_code = QP_GLOBALS.G_ENTITY_ALL) THEN
686:
687: IF l_request_type = QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN THEN
688: oe_debug_pub.add('Processing req Attribute Groups');
689: QP_DELAYED_REQUESTS_UTIL.maintain_header_pattern(
690: p_list_header_id => l_request_rec.entity_Id
691: , p_qualifier_group => l_request_rec.request_unique_key1
692: , p_setup_action => l_request_rec.request_unique_key2

Line 694: oe_debug_pub.ADD(' JAGAN 1 ENTITY CODE : ' || l_entity_code);

690: p_list_header_id => l_request_rec.entity_Id
691: , p_qualifier_group => l_request_rec.request_unique_key1
692: , p_setup_action => l_request_rec.request_unique_key2
693: , x_return_status => l_return_status);
694: oe_debug_pub.ADD(' JAGAN 1 ENTITY CODE : ' || l_entity_code);
695: END IF;
696: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
697: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
698: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

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

698: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
699: RAISE FND_API.G_EXC_ERROR;
700: END IF;
701: IF l_request_type = QP_GLOBALS.G_MAINTAIN_LINE_PATTERN THEN
702: oe_debug_pub.add('Processing req Attribute Groups');
703: QP_DELAYED_REQUESTS_UTIL.maintain_line_pattern(
704: p_list_header_id => l_request_rec.entity_Id
705: , p_list_line_id => l_request_rec.request_unique_key1
706: , p_qualifier_group => l_request_rec.request_unique_key2

Line 709: oe_debug_pub.ADD(' JAGAN 2 ENTITY CODE : ' || l_entity_code);

705: , p_list_line_id => l_request_rec.request_unique_key1
706: , p_qualifier_group => l_request_rec.request_unique_key2
707: , p_setup_action => l_request_rec.request_unique_key3
708: , x_return_status => l_return_status);
709: oe_debug_pub.ADD(' JAGAN 2 ENTITY CODE : ' || l_entity_code);
710: END IF;
711: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
712: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
713: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

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

714: RAISE FND_API.G_EXC_ERROR;
715: END IF;
716:
717: IF l_request_type = QP_GLOBALS.G_MAINTAIN_PRODUCT_PATTERN THEN
718: oe_debug_pub.add('Processing req Attribute Groups');
719: QP_DELAYED_REQUESTS_UTIL.maintain_product_pattern(
720: p_list_header_id => l_request_rec.entity_Id
721: , p_list_line_id => l_request_rec.request_unique_key1
722: , p_setup_action => l_request_rec.request_unique_key2

Line 724: oe_debug_pub.ADD('JAGAN 3 ENTITY CODE : ' || l_entity_code);

720: p_list_header_id => l_request_rec.entity_Id
721: , p_list_line_id => l_request_rec.request_unique_key1
722: , p_setup_action => l_request_rec.request_unique_key2
723: , x_return_status => l_return_status);
724: oe_debug_pub.ADD('JAGAN 3 ENTITY CODE : ' || l_entity_code);
725: END IF;
726: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
727: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
728: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

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

734:
735: --pattern
736: IF l_request_type = QP_GLOBALS.G_VALIDATE_SELLING_ROUNDING
737: THEN
738: oe_debug_pub.add('processing req VALIDATE_SELLING_ROUNDING');
739: QP_DELAYED_REQUESTS_UTIL.validate_selling_rounding(
740: p_currency_header_id => l_entity_id,
741: p_to_currency_code => l_request_rec.param1,
742: x_return_status => l_return_status);

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

750:
751:
752: IF l_request_type = QP_GLOBALS.G_CHECK_SEGMENT_LEVEL_IN_GROUP
753: THEN
754: oe_debug_pub.add('processing req CHECK_SEGMENT_LEVEL_IN_GROUP');
755: QP_DELAYED_REQUESTS_UTIL.check_segment_level_in_group(
756: p_list_line_id => l_entity_id,
757: p_list_header_id => l_request_rec.request_unique_key1,
758: p_qualifier_grouping_no => l_request_rec.request_unique_key2,

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

766: END IF;
767:
768: IF l_request_type = QP_GLOBALS.G_CHECK_LINE_FOR_HEADER_QUAL
769: THEN
770: oe_debug_pub.add('processing req CHECK_LINE_FOR_HEADER_QUAL');
771: QP_DELAYED_REQUESTS_UTIL.CHECK_LINE_FOR_HEADER_QUAL(
772: p_list_header_id => l_entity_id,
773: p_list_line_id => l_request_rec.request_unique_key1,
774: x_return_status => l_return_status);

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

781: END IF;
782:
783: -- Hierarchical Categories (sfiresto)
784: IF l_request_type = QP_GLOBALS.G_CHECK_ENABLED_FUNC_AREAS THEN
785: oe_debug_pub.add('processing req CHECK_ENABLED_FUNC_AREAS');
786: QP_DELAYED_REQUESTS_UTIL.Check_Enabled_Func_Areas(
787: p_pte_source_system_id => l_entity_id,
788: x_return_status => l_return_status);
789: END IF;

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

799: -- delayed request for changed lines
800: if QP_PERF_PVT.enabled = 'Y' then
801:
802: if l_request_type = QP_GLOBALS.G_UPDATE_CHANGED_LINES_ADD then
803: oe_debug_pub.add('processing req G_UPDATE_CHANGED_LINES_ADD');
804: QP_DELAYED_REQUESTS_UTIL.update_changed_lines_add(
805: p_list_line_id => l_entity_id,
806: p_list_header_id => l_request_rec.param2,
807: p_pricing_phase_id => l_request_rec.param1,

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

806: p_list_header_id => l_request_rec.param2,
807: p_pricing_phase_id => l_request_rec.param1,
808: x_return_status => l_return_status);
809: elsif l_request_type = QP_GLOBALS.G_UPDATE_CHANGED_LINES_DEL then
810: oe_debug_pub.add('processing req G_UPDATE_CHANGED_LINES_DEL');
811: QP_DELAYED_REQUESTS_UTIL.update_changed_lines_del(
812: p_list_line_id => l_entity_id,
813: p_list_header_id => l_request_rec.param2,
814: p_pricing_phase_id => l_request_rec.param1,

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

815: p_product_attribute => l_request_rec.param3,
816: p_product_attr_value => l_request_rec.param4,
817: x_return_status => l_return_status);
818: elsif l_request_type = QP_GLOBALS.G_UPDATE_CHANGED_LINES_PH then
819: oe_debug_pub.add('processing req G_UPDATE_CHANGED_LINES_PHASE');
820: QP_DELAYED_REQUESTS_UTIL.update_changed_lines_ph(
821: p_list_line_id => l_entity_id,
822: p_list_header_id => l_request_rec.param2,
823: p_pricing_phase_id => l_request_rec.param1,

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

823: p_pricing_phase_id => l_request_rec.param1,
824: p_old_pricing_phase_id => l_request_rec.param3,
825: x_return_status => l_return_status);
826: elsif l_request_type = QP_GLOBALS.G_UPDATE_CHANGED_LINES_ACT then
827: oe_debug_pub.add('processing req G_UPDATE_CHANGED_LINES_ACTIVE');
828: QP_DELAYED_REQUESTS_UTIL.update_changed_lines_act(
829: p_list_header_id => l_entity_id,
830: p_active_flag => l_request_rec.param1,
831: x_return_status => l_return_status);

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

829: p_list_header_id => l_entity_id,
830: p_active_flag => l_request_rec.param1,
831: x_return_status => l_return_status);
832: --hvop elsif l_request_type = QP_GLOBALS.G_UPDATE_HVOP then
833: oe_debug_pub.add('processing req G_UPDATE_HVOP')
834: ;
835: QP_DELAYED_REQUESTS_UTIL.HVOP_Pricing_Setup(x_return_status => l_return_status);
836: --hvop
837: end if;

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

885: G_Delayed_Requests(p_request_ind).processed := 'N';
886: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
887:
888: WHEN NO_DATA_FOUND THEN
889: oe_debug_pub.add('Exiting Process_Request_Pvt no_data_found exception ');
890: G_Delayed_Requests(p_request_ind).processed := 'N';
891: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
892:
893:

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

910: , 'Process_Request_Pvt'
911: );
912: END IF;
913:
914: oe_debug_pub.add('Exiting Process_Request_Pvt with others exception ');
915:
916:
917: End Process_Request_Pvt;
918: /** End Local Procedures **/

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

965: l_request QP_QUALIFIER_RULES_PUB.REQUEST_REC_TYPE;
966: l_req_entity QP_QUALIFIER_RULES_PUB.Requesting_Entity_Rec_Type;
967: BEGIN
968:
969: oe_debug_pub.add('Entering Procedure Log_Request in Package QP_Delayed_Requests_Pvt');
970: oe_debug_pub.add('log_request_type'||p_request_type);
971:
972: -- Initialize the request_record
973: l_request.request_type := p_request_type;

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

966: l_req_entity QP_QUALIFIER_RULES_PUB.Requesting_Entity_Rec_Type;
967: BEGIN
968:
969: oe_debug_pub.add('Entering Procedure Log_Request in Package QP_Delayed_Requests_Pvt');
970: oe_debug_pub.add('log_request_type'||p_request_type);
971:
972: -- Initialize the request_record
973: l_request.request_type := p_request_type;
974: l_request.entity_id := p_entity_id;

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

1028:
1029: l_request.processed := 'N';
1030: IF l_request_search_rslt = FND_API.g_true -- replace the request
1031: THEN
1032: OE_Debug_PUB.ADD('Request replaced');
1033: g_delayed_requests(l_request_ind) := l_request;
1034:
1035: ELSE -- insert the new request
1036: OE_Debug_PUB.ADD('New request inserted');

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

1032: OE_Debug_PUB.ADD('Request replaced');
1033: g_delayed_requests(l_request_ind) := l_request;
1034:
1035: ELSE -- insert the new request
1036: OE_Debug_PUB.ADD('New request inserted');
1037: -- l_request_ind := nvl(g_delayed_requests.LAST, 0) + 1; --2502849
1038: g_delayed_requests(l_request_ind) := l_request; --Added for 2502849
1039: END IF;
1040:

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

1046: l_req_entity_ind := nvl(g_requesting_entities.LAST, 0) + 1;
1047: -- Insert into the requesting entities table
1048: g_requesting_entities(l_req_entity_ind) := l_req_entity;
1049: END IF;--2650093
1050: oe_debug_pub.add('end of log request');
1051:
1052: EXCEPTION
1053:
1054: WHEN FND_API.G_EXC_ERROR THEN

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

1126: l_request_ind number;
1127: l_req_entity_ind number;
1128: BEGIN
1129:
1130: oe_debug_pub.add('Entering Procedure Delete_Request in Package QP_Delayed_Requests_Pvt');
1131:
1132: x_return_status := FND_API.G_RET_STS_SUCCESS;
1133: IF p_entity_id IS NOT NULL THEN --2650093
1134: Check_for_Request( p_entity_code => p_entity_code

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

1197: Procedure Clear_Request( x_return_status OUT NOCOPY VARCHAR2)
1198: IS
1199: BEGIN
1200:
1201: oe_debug_pub.add('Entering Procedure Clear_Request in Package QP_Delayed_Requests_Pvt');
1202:
1203: x_return_status := FND_API.G_RET_STS_SUCCESS;
1204:
1205: G_Delayed_Requests.DELETE;

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

1236: l_return_status Varchar2(30);
1237: Begin
1238: x_return_status := FND_API.G_RET_STS_SUCCESS;
1239:
1240: oe_debug_pub.add('Entering Procedure Process_Request in Package QP_Delayed_Requests_Pvt');
1241: IF p_entity_id IS NOT NULL THEN --2650093
1242: Check_for_Request( p_entity_code => p_entity_code
1243: ,p_entity_id => p_entity_id
1244: ,p_request_type => p_request_type

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

1304: l_ind Number;
1305: Begin
1306: x_return_status := FND_API.G_RET_STS_SUCCESS;
1307:
1308: oe_debug_pub.add('Entering Procedure Process_Request_for_Entity in Package QP_Delayed_Requests_Pvt');
1309: --dbms_output.put_line('Entering Procedure Process_Request_for_Entity in Package QP_Delayed_Requests_Pvt');
1310: --dbms_output.put_line('entity id is ' ||p_entity_code);
1311:
1312: l_ind := G_Delayed_Requests.first;

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

1311:
1312: l_ind := G_Delayed_Requests.first;
1313:
1314: /*WHILE l_ind IS NOT NULL loop
1315: oe_debug_pub.add('entity is ' ||G_Delayed_Requests(l_ind).Entity_code);
1316: --dbms_output.put_line('entity is ' ||G_Delayed_Requests(l_ind).Entity_code);
1317: oe_debug_pub.add('entity id is ' ||G_Delayed_Requests(l_ind).Entity_id);
1318: --dbms_output.put_line('entity id is ' ||G_Delayed_Requests(l_ind).Entity_id);
1319: END LOOP;*/

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

1313:
1314: /*WHILE l_ind IS NOT NULL loop
1315: oe_debug_pub.add('entity is ' ||G_Delayed_Requests(l_ind).Entity_code);
1316: --dbms_output.put_line('entity is ' ||G_Delayed_Requests(l_ind).Entity_code);
1317: oe_debug_pub.add('entity id is ' ||G_Delayed_Requests(l_ind).Entity_id);
1318: --dbms_output.put_line('entity id is ' ||G_Delayed_Requests(l_ind).Entity_id);
1319: END LOOP;*/
1320:
1321: l_ind := G_Delayed_Requests.first;

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

1339: --EXIT;
1340: END IF;
1341: l_ind := G_Delayed_Requests.Next(l_ind);
1342: END LOOP;
1343: oe_debug_pub.add('Exiting Process_Request_for_Entity ');
1344: --dbms_output.put_line('Exiting Process_Request_for_Entity ');
1345:
1346: EXCEPTION
1347:

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

1364: , 'Process_Request_for_Entity'
1365: );
1366: END IF;
1367:
1368: oe_debug_pub.add('Exiting Process_Request_for_Entity ');
1369:
1370: End Process_Request_for_Entity;
1371:
1372: Procedure Process_Request_for_ReqType

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

1378: l_ind Number;
1379: Begin
1380: x_return_status := FND_API.G_RET_STS_SUCCESS;
1381:
1382: oe_debug_pub.add('Entering Procedure Process_Request_for_ReqType in Package QP_Delayed_Requests_Pvt');
1383:
1384: l_ind := G_Delayed_Requests.first;
1385:
1386: WHILE l_ind IS NOT NULL LOOP

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

1430: ) IS
1431: l_return_status Varchar2(30);
1432: Begin
1433:
1434: oe_debug_pub.add('Entering Procedure Process_Delayed_Requests in Package QP_Delayed_Requests_Pvt');
1435:
1436: -- Process requests as per the dependency
1437: -- This procedure processes all requests.
1438: -- For each request type defined in QP_GLOBALS

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

1725: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1726: RAISE FND_API.G_EXC_ERROR;
1727: END IF;
1728: end if;
1729: oe_debug_pub.add('Ren: in process delayed request');
1730:
1731: -- mkarya for pattern delayed requests
1732: IF QP_JAVA_ENGINE_UTIL_PUB.Java_Engine_Installed = 'Y' THEN
1733: Process_Request_for_ReqType