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.OE_BLANKET_PRICING_UTIL dependencies on OE_DEBUG_PUB

Line 12: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

8: ,p_blanket_header_id NUMBER DEFAULT NULL)
9: RETURN BOOLEAN IS
10: l_dummy VARCHAR2(30);
11: --
12: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
13: --
14: BEGIN
15:
16: if l_debug_level > 0 then

Line 17: oe_debug_pub.add('Enter OEXQPBLB IS_BLANKET_PRICE_LIST');

13: --
14: BEGIN
15:
16: if l_debug_level > 0 then
17: oe_debug_pub.add('Enter OEXQPBLB IS_BLANKET_PRICE_LIST');
18: end if;
19:
20:
21: SELECT 'VALID'

Line 33: oe_debug_pub.ADD('Not a blanket price list', 1);

29:
30: EXCEPTION
31: WHEN NO_DATA_FOUND THEN
32: if l_debug_level > 0 then
33: oe_debug_pub.ADD('Not a blanket price list', 1);
34: end if;
35: RETURN FALSE;
36:
37: END IS_BLANKET_PRICE_LIST;

Line 84: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

80: l_hdr_req_index NUMBER;
81: l_line_req_index_tbl OE_GLOBALS.Number_Tbl_Type;
82:
83: --
84: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
85: --
86: l_user_precedence NUMBER; --Bug#8468331
87:
88: BEGIN

Line 91: oe_debug_pub.add('Enter Create_Modifiers',1);

87:
88: BEGIN
89:
90: if l_debug_level > 0 then
91: oe_debug_pub.add('Enter Create_Modifiers',1);
92: end if;
93:
94: x_return_status := FND_API.G_RET_STS_SUCCESS;
95:

Line 156: oe_debug_pub.add('Modifier Name :'||l_modifier_list_rec.name);

152: l_qualifiers_tbl(1).active_flag := 'Y'; /* jhkuo */
153: l_qualifiers_tbl(1).list_type_code := 'DLT'; /* jhkuo */
154:
155: if l_debug_level > 0 then
156: oe_debug_pub.add('Modifier Name :'||l_modifier_list_rec.name);
157: oe_debug_pub.add('Modifier Currency :'||l_modifier_list_rec.currency_code);
158: end if;
159:
160: ELSIF l_request_rec.request_type = 'ADD_MODIFIER_LIST_LINE' THEN

Line 157: oe_debug_pub.add('Modifier Currency :'||l_modifier_list_rec.currency_code);

153: l_qualifiers_tbl(1).list_type_code := 'DLT'; /* jhkuo */
154:
155: if l_debug_level > 0 then
156: oe_debug_pub.add('Modifier Name :'||l_modifier_list_rec.name);
157: oe_debug_pub.add('Modifier Currency :'||l_modifier_list_rec.currency_code);
158: end if;
159:
160: ELSIF l_request_rec.request_type = 'ADD_MODIFIER_LIST_LINE' THEN
161:

Line 191: oe_debug_pub.add('Req Type :'||l_request_rec.request_type);

187:
188: WHILE I IS NOT NULL LOOP
189:
190: l_request_rec := oe_delayed_requests_pvt.g_delayed_requests(I);
191: oe_debug_pub.add('Req Type :'||l_request_rec.request_type);
192:
193: IF l_request_rec.request_type = 'ADD_MODIFIER_LIST_LINE' THEN
194:
195: -----------------------------------------------------------

Line 204: oe_debug_pub.add('Skip for null values');

200: AND (l_request_rec.param2 IS NULL OR l_request_rec.param2=FND_API.G_MISS_NUM)
201: THEN
202: IF l_debug_level > 0
203: THEN
204: oe_debug_pub.add('Skip for null values');
205: END IF;
206: oe_delayed_requests_pvt.g_delayed_requests.delete(I);
207: GOTO SKIP_LINE;
208: END IF;

Line 259: oe_debug_pub.add('Operator :'||l_modifiers_tbl(J).arithmetic_operator);

255: l_line_id_tbl(J) := l_request_rec.entity_id;
256: l_line_req_index_tbl(J) := I;
257:
258: if l_debug_level > 0 then
259: oe_debug_pub.add('Operator :'||l_modifiers_tbl(J).arithmetic_operator);
260: oe_debug_pub.add('Operand :'||l_modifiers_tbl(J).operand);
261: oe_debug_pub.add('Prod Attr :'||l_pricing_attr_tbl(J).product_attribute);
262: oe_debug_pub.add('Prod Attr Val :'||l_pricing_attr_tbl(J).product_attr_value);
263: end if;

Line 260: oe_debug_pub.add('Operand :'||l_modifiers_tbl(J).operand);

256: l_line_req_index_tbl(J) := I;
257:
258: if l_debug_level > 0 then
259: oe_debug_pub.add('Operator :'||l_modifiers_tbl(J).arithmetic_operator);
260: oe_debug_pub.add('Operand :'||l_modifiers_tbl(J).operand);
261: oe_debug_pub.add('Prod Attr :'||l_pricing_attr_tbl(J).product_attribute);
262: oe_debug_pub.add('Prod Attr Val :'||l_pricing_attr_tbl(J).product_attr_value);
263: end if;
264: J := J + 1;

Line 261: oe_debug_pub.add('Prod Attr :'||l_pricing_attr_tbl(J).product_attribute);

257:
258: if l_debug_level > 0 then
259: oe_debug_pub.add('Operator :'||l_modifiers_tbl(J).arithmetic_operator);
260: oe_debug_pub.add('Operand :'||l_modifiers_tbl(J).operand);
261: oe_debug_pub.add('Prod Attr :'||l_pricing_attr_tbl(J).product_attribute);
262: oe_debug_pub.add('Prod Attr Val :'||l_pricing_attr_tbl(J).product_attr_value);
263: end if;
264: J := J + 1;
265:

Line 262: oe_debug_pub.add('Prod Attr Val :'||l_pricing_attr_tbl(J).product_attr_value);

258: if l_debug_level > 0 then
259: oe_debug_pub.add('Operator :'||l_modifiers_tbl(J).arithmetic_operator);
260: oe_debug_pub.add('Operand :'||l_modifiers_tbl(J).operand);
261: oe_debug_pub.add('Prod Attr :'||l_pricing_attr_tbl(J).product_attribute);
262: oe_debug_pub.add('Prod Attr Val :'||l_pricing_attr_tbl(J).product_attr_value);
263: end if;
264: J := J + 1;
265:
266: END IF;

Line 329: oe_debug_pub.add('entity id :'||l_line_id_tbl(J));

325: l_qualifiers_tbl(J).qualifier_context := 'ORDER';
326: l_qualifiers_tbl(J).qualifier_precedence := 800;
327: l_qualifiers_tbl(J).qualifier_attribute := 'QUALIFIER_ATTRIBUTE6';
328: -- Blanket Line ID is the qualifier attribute value
329: oe_debug_pub.add('entity id :'||l_line_id_tbl(J));
330: l_qualifiers_tbl(J).qualifier_attr_value := l_line_id_tbl(J);
331: l_qualifiers_tbl(J).qualifier_grouping_no := 1;
332: l_qualifiers_tbl(J).operation := QP_GLOBALS.G_OPR_CREATE;
333: -- Copy list line ID from created modiifer lines table

Line 338: oe_debug_pub.add('sending list header id on qual :'||

334: l_qualifiers_tbl(J).list_header_id :=
335: l_x_modifiers_tbl(J).list_header_id;
336: l_qualifiers_tbl(J).list_line_id :=
337: l_x_modifiers_tbl(J).list_line_id;
338: oe_debug_pub.add('sending list header id on qual :'||
339: l_qualifiers_tbl(J).list_header_id);
340: oe_debug_pub.add('sending list line id on qual :'||
341: l_qualifiers_tbl(J).list_line_id);
342:

Line 340: oe_debug_pub.add('sending list line id on qual :'||

336: l_qualifiers_tbl(J).list_line_id :=
337: l_x_modifiers_tbl(J).list_line_id;
338: oe_debug_pub.add('sending list header id on qual :'||
339: l_qualifiers_tbl(J).list_header_id);
340: oe_debug_pub.add('sending list line id on qual :'||
341: l_qualifiers_tbl(J).list_line_id);
342:
343: J := l_x_modifiers_tbl.NEXT(J);
344:

Line 378: oe_debug_pub.add('blanket header id :'||l_blanket_header_id);

374: -- Update modifier list header id on blanket header table
375: IF l_modifier_list_rec.operation = QP_GLOBALS.G_OPR_CREATE THEN
376:
377: if l_debug_level > 0 then
378: oe_debug_pub.add('blanket header id :'||l_blanket_header_id);
379: oe_debug_pub.add('set modifier list id :'||
380: l_x_modifier_list_rec.list_header_id);
381: end if;
382:

Line 379: oe_debug_pub.add('set modifier list id :'||

375: IF l_modifier_list_rec.operation = QP_GLOBALS.G_OPR_CREATE THEN
376:
377: if l_debug_level > 0 then
378: oe_debug_pub.add('blanket header id :'||l_blanket_header_id);
379: oe_debug_pub.add('set modifier list id :'||
380: l_x_modifier_list_rec.list_header_id);
381: end if;
382:
383: update oe_blanket_headers

Line 406: oe_debug_pub.add('blanket line id :'||l_line_id_tbl(I));

402: I := l_line_id_tbl.FIRST;
403: WHILE I IS NOT NULL LOOP
404:
405: if l_debug_level > 0 then
406: oe_debug_pub.add('blanket line id :'||l_line_id_tbl(I));
407: oe_debug_pub.add('modifier list line id :'||l_x_modifiers_tbl(I).list_line_id);
408: end if;
409:
410: update oe_blanket_lines

Line 407: oe_debug_pub.add('modifier list line id :'||l_x_modifiers_tbl(I).list_line_id);

403: WHILE I IS NOT NULL LOOP
404:
405: if l_debug_level > 0 then
406: oe_debug_pub.add('blanket line id :'||l_line_id_tbl(I));
407: oe_debug_pub.add('modifier list line id :'||l_x_modifiers_tbl(I).list_line_id);
408: end if;
409:
410: update oe_blanket_lines
411: set lock_control = lock_control + 1

Line 431: oe_debug_pub.add('Exit Create_Modifiers',1);

427: OE_GLOBALS.G_CASCADING_REQUEST_LOGGED := TRUE;
428: oe_blanket_util.g_new_modifier_list := FALSE;
429:
430: if l_debug_level > 0 then
431: oe_debug_pub.add('Exit Create_Modifiers',1);
432: end if;
433: EXCEPTION
434: WHEN FND_API.G_EXC_ERROR THEN
435: x_return_status := fnd_api.g_ret_sts_error;

Line 468: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

464: ppr_qualifiers_val_tbl QP_Qualifier_Rules_Pub.Qualifiers_Val_Tbl_Type;
465: ppr_pricing_attr_tbl QP_PRICE_LIST_PUB.Pricing_Attr_Tbl_Type;
466: ppr_pricing_attr_val_tbl QP_PRICE_LIST_PUB.Pricing_Attr_Val_Tbl_Type;
467: --
468: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
469: --
470: BEGIN
471:
472: if l_debug_level > 0 then

Line 473: oe_debug_pub.add('Enter Deactivate_Price_List');

469: --
470: BEGIN
471:
472: if l_debug_level > 0 then
473: oe_debug_pub.add('Enter Deactivate_Price_List');
474: oe_debug_pub.add('p_list_header_id :'||p_list_header_id);
475: oe_debug_pub.add('p_list_line_id :'||p_list_line_id);
476: end if;
477:

Line 474: oe_debug_pub.add('p_list_header_id :'||p_list_header_id);

470: BEGIN
471:
472: if l_debug_level > 0 then
473: oe_debug_pub.add('Enter Deactivate_Price_List');
474: oe_debug_pub.add('p_list_header_id :'||p_list_header_id);
475: oe_debug_pub.add('p_list_line_id :'||p_list_line_id);
476: end if;
477:
478: IF p_list_header_id IS NOT NULL THEN

Line 475: oe_debug_pub.add('p_list_line_id :'||p_list_line_id);

471:
472: if l_debug_level > 0 then
473: oe_debug_pub.add('Enter Deactivate_Price_List');
474: oe_debug_pub.add('p_list_header_id :'||p_list_header_id);
475: oe_debug_pub.add('p_list_line_id :'||p_list_line_id);
476: end if;
477:
478: IF p_list_header_id IS NOT NULL THEN
479: gpr_price_list_rec.list_header_id := p_list_header_id;

Line 511: oe_debug_pub.add('Exit Deactivate_Price_List');

507: , x_PRICING_ATTR_val_tbl => ppr_pricing_attr_val_tbl
508: );
509:
510: if l_debug_level > 0 then
511: oe_debug_pub.add('Exit Deactivate_Price_List');
512: end if;
513:
514: EXCEPTION
515: WHEN FND_API.G_EXC_ERROR THEN

Line 540: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

536: l_return_status varchar2(30);
537: l_msg_count number := 0;
538: l_msg_data varchar2(2000);
539: --
540: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
541: --
542: l_modifier_list_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;
543: l_modifiers_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
544: l_x_modifier_list_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;

Line 556: oe_debug_pub.add('Enter Deactivate_Modifier');

552: l_control_rec QP_GLOBALS.Control_Rec_Type;
553: BEGIN
554:
555: if l_debug_level > 0 then
556: oe_debug_pub.add('Enter Deactivate_Modifier');
557: oe_debug_pub.add('p_list_header_id :'||p_list_header_id);
558: oe_debug_pub.add('p_list_line_id :'||p_list_line_id);
559: end if;
560:

Line 557: oe_debug_pub.add('p_list_header_id :'||p_list_header_id);

553: BEGIN
554:
555: if l_debug_level > 0 then
556: oe_debug_pub.add('Enter Deactivate_Modifier');
557: oe_debug_pub.add('p_list_header_id :'||p_list_header_id);
558: oe_debug_pub.add('p_list_line_id :'||p_list_line_id);
559: end if;
560:
561: IF p_list_header_id IS NOT NULL THEN

Line 558: oe_debug_pub.add('p_list_line_id :'||p_list_line_id);

554:
555: if l_debug_level > 0 then
556: oe_debug_pub.add('Enter Deactivate_Modifier');
557: oe_debug_pub.add('p_list_header_id :'||p_list_header_id);
558: oe_debug_pub.add('p_list_line_id :'||p_list_line_id);
559: end if;
560:
561: IF p_list_header_id IS NOT NULL THEN
562: l_modifier_list_rec.list_header_id := p_list_header_id;

Line 606: oe_debug_pub.add('Exit Deactivate_Modifier');

602: raise fnd_api.g_exc_unexpected_error;
603: end if;
604:
605: if l_debug_level > 0 then
606: oe_debug_pub.add('Exit Deactivate_Modifier');
607: end if;
608:
609: EXCEPTION
610: WHEN FND_API.G_EXC_ERROR THEN

Line 640: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

636: l_msg_count NUMBER;
637: l_msg_data VARCHAR2(2000);
638: l_exist_qp_list_line_id VARCHAR2(1) := 'Y';
639: --
640: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
641: --
642: BEGIN
643:
644: if l_debug_level > 0 then

Line 645: oe_debug_pub.add('Enter Deactivate_Pricing');

641: --
642: BEGIN
643:
644: if l_debug_level > 0 then
645: oe_debug_pub.add('Enter Deactivate_Pricing');
646: oe_debug_pub.add('p_blanket_header_id :'||p_blanket_header_id);
647: oe_debug_pub.add('p_blanket_line_id :'||p_blanket_line_id);
648: end if;
649:

Line 646: oe_debug_pub.add('p_blanket_header_id :'||p_blanket_header_id);

642: BEGIN
643:
644: if l_debug_level > 0 then
645: oe_debug_pub.add('Enter Deactivate_Pricing');
646: oe_debug_pub.add('p_blanket_header_id :'||p_blanket_header_id);
647: oe_debug_pub.add('p_blanket_line_id :'||p_blanket_line_id);
648: end if;
649:
650: x_return_status := fnd_api.g_ret_sts_success;

Line 647: oe_debug_pub.add('p_blanket_line_id :'||p_blanket_line_id);

643:
644: if l_debug_level > 0 then
645: oe_debug_pub.add('Enter Deactivate_Pricing');
646: oe_debug_pub.add('p_blanket_header_id :'||p_blanket_header_id);
647: oe_debug_pub.add('p_blanket_line_id :'||p_blanket_line_id);
648: end if;
649:
650: x_return_status := fnd_api.g_ret_sts_success;
651:

Line 723: oe_debug_pub.add('Exit Deactivate_Pricing');

719:
720: END IF;
721:
722: if l_debug_level > 0 then
723: oe_debug_pub.add('Exit Deactivate_Pricing');
724: end if;
725:
726: EXCEPTION
727: WHEN FND_API.G_EXC_ERROR THEN

Line 748: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

744: ( p_blanket_number IN NUMBER
745: )RETURN NUMBER IS
746: l_blanket_header_id NUMBER;
747: --
748: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
749: --
750: BEGIN
751:
752: if l_debug_level > 0 then

Line 753: oe_debug_pub.add('Enter Get_Blanket_Header_ID');

749: --
750: BEGIN
751:
752: if l_debug_level > 0 then
753: oe_debug_pub.add('Enter Get_Blanket_Header_ID');
754: oe_debug_pub.add('Blanket num :'||p_blanket_number);
755: end if;
756:
757: IF p_blanket_number IS NOT NULL

Line 754: oe_debug_pub.add('Blanket num :'||p_blanket_number);

750: BEGIN
751:
752: if l_debug_level > 0 then
753: oe_debug_pub.add('Enter Get_Blanket_Header_ID');
754: oe_debug_pub.add('Blanket num :'||p_blanket_number);
755: end if;
756:
757: IF p_blanket_number IS NOT NULL
758: AND p_blanket_number <> FND_API.G_MISS_NUM

Line 768: oe_debug_pub.add('Return Get_Blanket_Header_ID :'||l_blanket_header_id);

764: and org_id = mo_global.get_current_org_id;
765: END IF;
766:
767: if l_debug_level > 0 then
768: oe_debug_pub.add('Return Get_Blanket_Header_ID :'||l_blanket_header_id);
769: end if;
770:
771: RETURN l_blanket_header_id;
772:

Line 776: oe_debug_pub.add('No data found in Get_Blanket_Header_ID');

772:
773: EXCEPTION
774: WHEN NO_DATA_FOUND THEN
775: if l_debug_level > 0 then
776: oe_debug_pub.add('No data found in Get_Blanket_Header_ID');
777: end if;
778: RETURN NULL;
779: WHEN OTHERS THEN
780: IF l_debug_level > 0 THEN

Line 781: oe_debug_pub.add('other error :'||SQLERRM ) ;

777: end if;
778: RETURN NULL;
779: WHEN OTHERS THEN
780: IF l_debug_level > 0 THEN
781: oe_debug_pub.add('other error :'||SQLERRM ) ;
782: END IF;
783: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
784: THEN
785: OE_MSG_PUB.Add_Exc_Msg

Line 799: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

795: , p_blanket_line_number IN NUMBER
796: )RETURN NUMBER IS
797: l_blanket_line_id NUMBER;
798: --
799: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
800: --
801: BEGIN
802:
803: if l_debug_level > 0 then

Line 804: oe_debug_pub.add('Enter Get_Blanket_Line_ID');

800: --
801: BEGIN
802:
803: if l_debug_level > 0 then
804: oe_debug_pub.add('Enter Get_Blanket_Line_ID');
805: oe_debug_pub.add('Blanket num :'||p_blanket_number);
806: oe_debug_pub.add('Blanket line num :'||p_blanket_line_number);
807: end if;
808:

Line 805: oe_debug_pub.add('Blanket num :'||p_blanket_number);

801: BEGIN
802:
803: if l_debug_level > 0 then
804: oe_debug_pub.add('Enter Get_Blanket_Line_ID');
805: oe_debug_pub.add('Blanket num :'||p_blanket_number);
806: oe_debug_pub.add('Blanket line num :'||p_blanket_line_number);
807: end if;
808:
809: IF p_blanket_number IS NOT NULL

Line 806: oe_debug_pub.add('Blanket line num :'||p_blanket_line_number);

802:
803: if l_debug_level > 0 then
804: oe_debug_pub.add('Enter Get_Blanket_Line_ID');
805: oe_debug_pub.add('Blanket num :'||p_blanket_number);
806: oe_debug_pub.add('Blanket line num :'||p_blanket_line_number);
807: end if;
808:
809: IF p_blanket_number IS NOT NULL
810: AND p_blanket_line_number IS NOT NULL

Line 820: oe_debug_pub.add('Return Get_Blanket_Line_ID :'||l_blanket_line_id);

816: and line_number = p_blanket_line_number;
817: END IF;
818:
819: if l_debug_level > 0 then
820: oe_debug_pub.add('Return Get_Blanket_Line_ID :'||l_blanket_line_id);
821: end if;
822:
823: RETURN l_blanket_line_id;
824:

Line 828: oe_debug_pub.add('No data found in Get_Blanket_Line_ID');

824:
825: EXCEPTION
826: WHEN NO_DATA_FOUND THEN
827: if l_debug_level > 0 then
828: oe_debug_pub.add('No data found in Get_Blanket_Line_ID');
829: end if;
830: RETURN NULL;
831: WHEN OTHERS THEN
832: IF l_debug_level > 0 THEN

Line 833: oe_debug_pub.add('other error :'||SQLERRM ) ;

829: end if;
830: RETURN NULL;
831: WHEN OTHERS THEN
832: IF l_debug_level > 0 THEN
833: oe_debug_pub.add('other error :'||SQLERRM ) ;
834: END IF;
835: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
836: THEN
837: OE_MSG_PUB.Add_Exc_Msg

Line 851: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

847: , p_blanket_line_number IN NUMBER
848: )RETURN NUMBER IS
849: l_list_line_id NUMBER;
850: --
851: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
852: --
853: BEGIN
854:
855: if l_debug_level > 0 then

Line 856: oe_debug_pub.add('Enter Get_List_Line_ID');

852: --
853: BEGIN
854:
855: if l_debug_level > 0 then
856: oe_debug_pub.add('Enter Get_List_Line_ID');
857: oe_debug_pub.add('Blanket num :'||p_blanket_number);
858: oe_debug_pub.add('Blanket line num :'||p_blanket_line_number);
859: end if;
860:

Line 857: oe_debug_pub.add('Blanket num :'||p_blanket_number);

853: BEGIN
854:
855: if l_debug_level > 0 then
856: oe_debug_pub.add('Enter Get_List_Line_ID');
857: oe_debug_pub.add('Blanket num :'||p_blanket_number);
858: oe_debug_pub.add('Blanket line num :'||p_blanket_line_number);
859: end if;
860:
861: IF p_blanket_number IS NOT NULL

Line 858: oe_debug_pub.add('Blanket line num :'||p_blanket_line_number);

854:
855: if l_debug_level > 0 then
856: oe_debug_pub.add('Enter Get_List_Line_ID');
857: oe_debug_pub.add('Blanket num :'||p_blanket_number);
858: oe_debug_pub.add('Blanket line num :'||p_blanket_line_number);
859: end if;
860:
861: IF p_blanket_number IS NOT NULL
862: AND p_blanket_line_number IS NOT NULL

Line 872: oe_debug_pub.add('RETURN_Line_ID :'||l_list_line_id);

868: and line_number = p_blanket_line_number;
869: END IF;
870:
871: if l_debug_level > 0 then
872: oe_debug_pub.add('RETURN_Line_ID :'||l_list_line_id);
873: end if;
874:
875: RETURN l_list_line_id;
876:

Line 880: oe_debug_pub.add('No data found in Get_List_Line_ID');

876:
877: EXCEPTION
878: WHEN NO_DATA_FOUND THEN
879: if l_debug_level > 0 then
880: oe_debug_pub.add('No data found in Get_List_Line_ID');
881: end if;
882: RETURN NULL;
883: WHEN OTHERS THEN
884: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 907: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

903: l_returned_amount NUMBER;
904: l_order_rel_amt NUMBER := 0;
905: l_blanket_header_id NUMBER;
906: --
907: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
908: --
909: BEGIN
910:
911: if l_debug_level > 0 then

Line 912: oe_debug_pub.add('Enter Get_Blanket_Rel_Amt');

908: --
909: BEGIN
910:
911: if l_debug_level > 0 then
912: oe_debug_pub.add('Enter Get_Blanket_Rel_Amt');
913: oe_debug_pub.add('Blkt Num :'||p_blanket_number);
914: oe_debug_pub.add('Blkt Line Num :'||p_blanket_line_number);
915: oe_debug_pub.add('Line ID :'||p_line_id);
916: oe_debug_pub.add('Header ID :'||p_header_id);

Line 913: oe_debug_pub.add('Blkt Num :'||p_blanket_number);

909: BEGIN
910:
911: if l_debug_level > 0 then
912: oe_debug_pub.add('Enter Get_Blanket_Rel_Amt');
913: oe_debug_pub.add('Blkt Num :'||p_blanket_number);
914: oe_debug_pub.add('Blkt Line Num :'||p_blanket_line_number);
915: oe_debug_pub.add('Line ID :'||p_line_id);
916: oe_debug_pub.add('Header ID :'||p_header_id);
917: end if;

Line 914: oe_debug_pub.add('Blkt Line Num :'||p_blanket_line_number);

910:
911: if l_debug_level > 0 then
912: oe_debug_pub.add('Enter Get_Blanket_Rel_Amt');
913: oe_debug_pub.add('Blkt Num :'||p_blanket_number);
914: oe_debug_pub.add('Blkt Line Num :'||p_blanket_line_number);
915: oe_debug_pub.add('Line ID :'||p_line_id);
916: oe_debug_pub.add('Header ID :'||p_header_id);
917: end if;
918:

Line 915: oe_debug_pub.add('Line ID :'||p_line_id);

911: if l_debug_level > 0 then
912: oe_debug_pub.add('Enter Get_Blanket_Rel_Amt');
913: oe_debug_pub.add('Blkt Num :'||p_blanket_number);
914: oe_debug_pub.add('Blkt Line Num :'||p_blanket_line_number);
915: oe_debug_pub.add('Line ID :'||p_line_id);
916: oe_debug_pub.add('Header ID :'||p_header_id);
917: end if;
918:
919: IF p_blanket_number IS NULL

Line 916: oe_debug_pub.add('Header ID :'||p_header_id);

912: oe_debug_pub.add('Enter Get_Blanket_Rel_Amt');
913: oe_debug_pub.add('Blkt Num :'||p_blanket_number);
914: oe_debug_pub.add('Blkt Line Num :'||p_blanket_line_number);
915: oe_debug_pub.add('Line ID :'||p_line_id);
916: oe_debug_pub.add('Header ID :'||p_header_id);
917: end if;
918:
919: IF p_blanket_number IS NULL
920: -- Bug 3350448 =>

Line 940: oe_debug_pub.add('current blkt rel amt :'||l_released_amount);

936: from oe_blanket_headers_ext bhe, oe_blanket_headers_all bh
937: where bhe.order_number = p_blanket_number
938: and bhe.order_number = bh.order_number
939: and bh.org_id = mo_global.get_current_orG_id;
940: oe_debug_pub.add('current blkt rel amt :'||l_released_amount);
941: oe_debug_pub.add('current blkt ret amt :'||l_returned_amount);
942:
943: l_blanket_header_id := MOD(l_blanket_header_id,G_BINARY_LIMIT);--bug8465849
944:

Line 941: oe_debug_pub.add('current blkt ret amt :'||l_returned_amount);

937: where bhe.order_number = p_blanket_number
938: and bhe.order_number = bh.order_number
939: and bh.org_id = mo_global.get_current_orG_id;
940: oe_debug_pub.add('current blkt rel amt :'||l_released_amount);
941: oe_debug_pub.add('current blkt ret amt :'||l_returned_amount);
942:
943: l_blanket_header_id := MOD(l_blanket_header_id,G_BINARY_LIMIT);--bug8465849
944:
945: IF nvl(p_transaction_phase_code,'F') = 'F' THEN

Line 957: oe_debug_pub.add('order rel amt :'||l_order_rel_amt);

953:
954: IF OE_Blkt_Release_Util.g_blkt_hdr_tbl.EXISTS(l_blanket_header_id) THEN
955: l_order_rel_amt :=
956: OE_Blkt_Release_Util.g_bh_order_val_tbl(l_blanket_header_id).order_released_amount;
957: oe_debug_pub.add('order rel amt :'||l_order_rel_amt);
958: END IF;
959:
960: END IF;
961:

Line 965: oe_debug_pub.add('Blanket Rel Amt :'||l_rel_amt);

961:
962: l_rel_amt := l_released_amount - l_returned_amount - l_order_rel_amt;
963:
964: if l_debug_level > 0 then
965: oe_debug_pub.add('Blanket Rel Amt :'||l_rel_amt);
966: end if;
967:
968: RETURN l_rel_amt;
969:

Line 996: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

992: l_returned_amount NUMBER;
993: l_order_rel_amt NUMBER := 0;
994: l_blanket_line_id NUMBER;
995: --
996: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
997: --
998: BEGIN
999:
1000: if l_debug_level > 0 then

Line 1001: oe_debug_pub.add('Enter Get_Bl_Line_Rel_Amt');

997: --
998: BEGIN
999:
1000: if l_debug_level > 0 then
1001: oe_debug_pub.add('Enter Get_Bl_Line_Rel_Amt');
1002: oe_debug_pub.add('Blkt Num :'||p_blanket_number);
1003: oe_debug_pub.add('Blkt Line Num :'||p_blanket_line_number);
1004: oe_debug_pub.add('Line ID :'||p_line_id);
1005: oe_debug_pub.add('Header ID :'||p_header_id);

Line 1002: oe_debug_pub.add('Blkt Num :'||p_blanket_number);

998: BEGIN
999:
1000: if l_debug_level > 0 then
1001: oe_debug_pub.add('Enter Get_Bl_Line_Rel_Amt');
1002: oe_debug_pub.add('Blkt Num :'||p_blanket_number);
1003: oe_debug_pub.add('Blkt Line Num :'||p_blanket_line_number);
1004: oe_debug_pub.add('Line ID :'||p_line_id);
1005: oe_debug_pub.add('Header ID :'||p_header_id);
1006: end if;

Line 1003: oe_debug_pub.add('Blkt Line Num :'||p_blanket_line_number);

999:
1000: if l_debug_level > 0 then
1001: oe_debug_pub.add('Enter Get_Bl_Line_Rel_Amt');
1002: oe_debug_pub.add('Blkt Num :'||p_blanket_number);
1003: oe_debug_pub.add('Blkt Line Num :'||p_blanket_line_number);
1004: oe_debug_pub.add('Line ID :'||p_line_id);
1005: oe_debug_pub.add('Header ID :'||p_header_id);
1006: end if;
1007:

Line 1004: oe_debug_pub.add('Line ID :'||p_line_id);

1000: if l_debug_level > 0 then
1001: oe_debug_pub.add('Enter Get_Bl_Line_Rel_Amt');
1002: oe_debug_pub.add('Blkt Num :'||p_blanket_number);
1003: oe_debug_pub.add('Blkt Line Num :'||p_blanket_line_number);
1004: oe_debug_pub.add('Line ID :'||p_line_id);
1005: oe_debug_pub.add('Header ID :'||p_header_id);
1006: end if;
1007:
1008: IF p_blanket_number IS NULL

Line 1005: oe_debug_pub.add('Header ID :'||p_header_id);

1001: oe_debug_pub.add('Enter Get_Bl_Line_Rel_Amt');
1002: oe_debug_pub.add('Blkt Num :'||p_blanket_number);
1003: oe_debug_pub.add('Blkt Line Num :'||p_blanket_line_number);
1004: oe_debug_pub.add('Line ID :'||p_line_id);
1005: oe_debug_pub.add('Header ID :'||p_header_id);
1006: end if;
1007:
1008: IF p_blanket_number IS NULL
1009: OR p_blanket_line_number IS NULL

Line 1023: oe_debug_pub.add('current blkt rel amt :'||l_released_amount);

1019: ,l_blanket_line_id
1020: from oe_blanket_lines_ext
1021: where order_number = p_blanket_number
1022: and line_number = p_blanket_line_number;
1023: oe_debug_pub.add('current blkt rel amt :'||l_released_amount);
1024: oe_debug_pub.add('current blkt ret amt :'||l_returned_amount);
1025:
1026: l_blanket_line_id := MOD(l_blanket_line_id,G_BINARY_LIMIT);--bug8465849
1027:

Line 1024: oe_debug_pub.add('current blkt ret amt :'||l_returned_amount);

1020: from oe_blanket_lines_ext
1021: where order_number = p_blanket_number
1022: and line_number = p_blanket_line_number;
1023: oe_debug_pub.add('current blkt rel amt :'||l_released_amount);
1024: oe_debug_pub.add('current blkt ret amt :'||l_returned_amount);
1025:
1026: l_blanket_line_id := MOD(l_blanket_line_id,G_BINARY_LIMIT);--bug8465849
1027:
1028: IF nvl(p_transaction_phase_code,'F') = 'F' THEN

Line 1040: oe_debug_pub.add('order rel amt :'||l_order_rel_amt);

1036:
1037: IF OE_Blkt_Release_Util.g_blkt_line_tbl.EXISTS(l_blanket_line_id) THEN
1038: l_order_rel_amt :=
1039: OE_Blkt_Release_Util.g_bl_order_val_tbl(l_blanket_line_id).order_released_amount;
1040: oe_debug_pub.add('order rel amt :'||l_order_rel_amt);
1041: END IF;
1042:
1043: END IF;
1044:

Line 1048: oe_debug_pub.add('BL Line Rel Amt :'||l_rel_amt);

1044:
1045: l_rel_amt := l_released_amount - l_returned_amount - l_order_rel_amt;
1046:
1047: if l_debug_level > 0 then
1048: oe_debug_pub.add('BL Line Rel Amt :'||l_rel_amt);
1049: end if;
1050:
1051: RETURN l_rel_amt;
1052:

Line 1078: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

1074: l_returned_quantity NUMBER;
1075: l_order_rel_qty NUMBER := 0;
1076: l_blanket_line_id NUMBER;
1077: --
1078: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1079: --
1080: BEGIN
1081:
1082: if l_debug_level > 0 then

Line 1083: oe_debug_pub.add('Enter Get_Bl_Line_Rel_Qty');

1079: --
1080: BEGIN
1081:
1082: if l_debug_level > 0 then
1083: oe_debug_pub.add('Enter Get_Bl_Line_Rel_Qty');
1084: oe_debug_pub.add('Blkt Num :'||p_blanket_number);
1085: oe_debug_pub.add('Blkt Line Num :'||p_blanket_line_number);
1086: oe_debug_pub.add('Line ID :'||p_line_id);
1087: oe_debug_pub.add('Header ID :'||p_header_id);

Line 1084: oe_debug_pub.add('Blkt Num :'||p_blanket_number);

1080: BEGIN
1081:
1082: if l_debug_level > 0 then
1083: oe_debug_pub.add('Enter Get_Bl_Line_Rel_Qty');
1084: oe_debug_pub.add('Blkt Num :'||p_blanket_number);
1085: oe_debug_pub.add('Blkt Line Num :'||p_blanket_line_number);
1086: oe_debug_pub.add('Line ID :'||p_line_id);
1087: oe_debug_pub.add('Header ID :'||p_header_id);
1088: end if;

Line 1085: oe_debug_pub.add('Blkt Line Num :'||p_blanket_line_number);

1081:
1082: if l_debug_level > 0 then
1083: oe_debug_pub.add('Enter Get_Bl_Line_Rel_Qty');
1084: oe_debug_pub.add('Blkt Num :'||p_blanket_number);
1085: oe_debug_pub.add('Blkt Line Num :'||p_blanket_line_number);
1086: oe_debug_pub.add('Line ID :'||p_line_id);
1087: oe_debug_pub.add('Header ID :'||p_header_id);
1088: end if;
1089:

Line 1086: oe_debug_pub.add('Line ID :'||p_line_id);

1082: if l_debug_level > 0 then
1083: oe_debug_pub.add('Enter Get_Bl_Line_Rel_Qty');
1084: oe_debug_pub.add('Blkt Num :'||p_blanket_number);
1085: oe_debug_pub.add('Blkt Line Num :'||p_blanket_line_number);
1086: oe_debug_pub.add('Line ID :'||p_line_id);
1087: oe_debug_pub.add('Header ID :'||p_header_id);
1088: end if;
1089:
1090: IF p_blanket_number IS NULL

Line 1087: oe_debug_pub.add('Header ID :'||p_header_id);

1083: oe_debug_pub.add('Enter Get_Bl_Line_Rel_Qty');
1084: oe_debug_pub.add('Blkt Num :'||p_blanket_number);
1085: oe_debug_pub.add('Blkt Line Num :'||p_blanket_line_number);
1086: oe_debug_pub.add('Line ID :'||p_line_id);
1087: oe_debug_pub.add('Header ID :'||p_header_id);
1088: end if;
1089:
1090: IF p_blanket_number IS NULL
1091: OR p_blanket_line_number IS NULL

Line 1105: oe_debug_pub.add('current blkt rel qty :'||l_released_quantity);

1101: ,l_blanket_line_id
1102: from oe_blanket_lines_ext
1103: where order_number = p_blanket_number
1104: and line_number = p_blanket_line_number;
1105: oe_debug_pub.add('current blkt rel qty :'||l_released_quantity);
1106: oe_debug_pub.add('current blkt ret qty :'||l_returned_quantity);
1107:
1108: l_blanket_line_id := MOD(l_blanket_line_id,G_BINARY_LIMIT);--bug8465849
1109:

Line 1106: oe_debug_pub.add('current blkt ret qty :'||l_returned_quantity);

1102: from oe_blanket_lines_ext
1103: where order_number = p_blanket_number
1104: and line_number = p_blanket_line_number;
1105: oe_debug_pub.add('current blkt rel qty :'||l_released_quantity);
1106: oe_debug_pub.add('current blkt ret qty :'||l_returned_quantity);
1107:
1108: l_blanket_line_id := MOD(l_blanket_line_id,G_BINARY_LIMIT);--bug8465849
1109:
1110: IF nvl(p_transaction_phase_code,'F') = 'F' THEN

Line 1122: oe_debug_pub.add('order rel qty :'||l_order_rel_qty);

1118:
1119: IF OE_Blkt_Release_Util.g_blkt_line_tbl.EXISTS(l_blanket_line_id) THEN
1120: l_order_rel_qty :=
1121: OE_Blkt_Release_Util.g_bl_order_val_tbl(l_blanket_line_id).order_released_quantity;
1122: oe_debug_pub.add('order rel qty :'||l_order_rel_qty);
1123: END IF;
1124:
1125: END IF;
1126:

Line 1130: oe_debug_pub.add('BL Line Rel Qty :'||l_rel_qty);

1126:
1127: l_rel_qty := l_released_quantity - l_returned_quantity - l_order_rel_qty;
1128:
1129: if l_debug_level > 0 then
1130: oe_debug_pub.add('BL Line Rel Qty :'||l_rel_qty);
1131: end if;
1132:
1133: RETURN l_rel_qty;
1134:

Line 1138: oe_debug_pub.add('other error :'||SQLERRM ) ;

1134:
1135: EXCEPTION
1136: WHEN OTHERS THEN
1137: IF l_debug_level > 0 THEN
1138: oe_debug_pub.add('other error :'||SQLERRM ) ;
1139: END IF;
1140: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1141: THEN
1142: OE_MSG_PUB.Add_Exc_Msg