DBA Data[Home] [Help]

APPS.ONT_IMPLICITCUSTACCEPT_PVT dependencies on OE_DEBUG_PUB

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

56: -- Section for declaring local variables
57: --
58: l_procedure_name CONSTANT VARCHAR2(30) := ' implicit_acceptance ';
59: l_cust_sys_param VARCHAR(1);
60: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
61:
62: CURSOR l_secured_ou_cur IS
63: SELECT ou.organization_id
64: FROM hr_operating_units ou

Line 70: oe_debug_pub.add('Implicit_acceptance'||g_org_id);

66:
67: BEGIN
68:
69: IF l_debug_level > 0 THEN
70: oe_debug_pub.add('Implicit_acceptance'||g_org_id);
71: END IF;
72:
73:
74: g_org_id := p_org_id;

Line 94: oe_debug_pub.add('Implicit Acceptance: g_org_id:'||g_org_id);

90: -- Get the value of system parameter,To verify whether customer acceptance is enabled.
91: -- MOAC Start
92: IF g_org_id IS NOT NULL THEN
93: IF l_debug_level > 0 THEN
94: oe_debug_pub.add('Implicit Acceptance: g_org_id:'||g_org_id);
95: END IF;
96:
97: MO_GLOBAL.set_policy_context('S', g_org_id);
98: l_cust_sys_param := OE_SYS_PARAMETERS.VALUE('ENABLE_FULFILLMENT_ACCEPTANCE',g_org_id);

Line 103: oe_debug_pub.add('Implicit Acceptance: Customer Acceptance System Parameter is True');

99:
100: /* myerrams, Bug: 5161878. Null value should be treated as No.*/
101: IF l_cust_sys_param = 'Y' THEN
102: IF l_debug_level > 0 THEN
103: oe_debug_pub.add('Implicit Acceptance: Customer Acceptance System Parameter is True');
104: END IF;
105: g_customer_acceptance_enabled := true;
106: ELSE
107: IF l_debug_level > 0 THEN

Line 108: oe_debug_pub.add('Implicit Acceptance: Customer Acceptance System Parameter is False');

104: END IF;
105: g_customer_acceptance_enabled := true;
106: ELSE
107: IF l_debug_level > 0 THEN
108: oe_debug_pub.add('Implicit Acceptance: Customer Acceptance System Parameter is False');
109: END IF;
110: g_customer_acceptance_enabled := false;
111: END IF;
112: /*myerrams, Bug: 5161878. End.*/

Line 116: oe_debug_pub.add('g_customer_acceptance_enabled is TRUE calling process_expired_lines');

112: /*myerrams, Bug: 5161878. End.*/
113:
114: IF g_customer_acceptance_enabled THEN
115: IF l_debug_level > 0 THEN
116: oe_debug_pub.add('g_customer_acceptance_enabled is TRUE calling process_expired_lines');
117: END IF;
118: process_expired_lines;
119: ELSE
120: IF l_debug_level > 0 THEN

Line 121: oe_debug_pub.add('AAMBASTH: g_customer_acceptance_enabled is FALSE calling process_all_lines');

117: END IF;
118: process_expired_lines;
119: ELSE
120: IF l_debug_level > 0 THEN
121: oe_debug_pub.add('AAMBASTH: g_customer_acceptance_enabled is FALSE calling process_all_lines');
122: END IF;
123: process_all_lines;
124: END IF;
125:

Line 141: oe_debug_pub.add('Implicit Acceptance: Customer Acceptance System Parameter is True for Org:'||g_org_id );

137:
138: /* myerrams, Bug: 5161878. Null value should be treated as No.*/
139: IF l_cust_sys_param = 'Y' THEN
140: IF l_debug_level > 0 THEN
141: oe_debug_pub.add('Implicit Acceptance: Customer Acceptance System Parameter is True for Org:'||g_org_id );
142: END IF;
143: g_customer_acceptance_enabled := true;
144: ELSE
145: IF l_debug_level > 0 THEN

Line 146: oe_debug_pub.add('Implicit Acceptance: Customer Acceptance System Parameter is False for Org:'||g_org_id);

142: END IF;
143: g_customer_acceptance_enabled := true;
144: ELSE
145: IF l_debug_level > 0 THEN
146: oe_debug_pub.add('Implicit Acceptance: Customer Acceptance System Parameter is False for Org:'||g_org_id);
147: END IF;
148: g_customer_acceptance_enabled := false;
149: END IF;
150: /* myerrams, Bug: 5161878. End.*/

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

222: -- Dynamic Cursor Variable
223: -- =======================
224: TYPE g_cust_lines_type IS REF CURSOR;
225: g_cust_lines g_cust_lines_type;
226: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
227:
228: BEGIN
229:
230: /*myerrams, Bug:5161878. This method is executed more than once.

Line 241: oe_debug_pub.add('Implicit Acceptance: l_query_where_clause:'||l_query_where_clause);

237: l_query_where_clause := ' WHERE flow_status_code in (:1 , :2) AND org_id = :3 and open_flag = :4 ';
238: l_cust_query := g_cust_query || g_query_from_clause || l_query_where_clause;
239:
240: IF l_debug_level > 0 THEN
241: oe_debug_pub.add('Implicit Acceptance: l_query_where_clause:'||l_query_where_clause);
242: oe_debug_pub.add('Implicit Acceptance: l_cust_query:'||l_cust_query);
243: END IF;
244:
245: OPEN g_cust_lines FOR l_cust_query

Line 242: oe_debug_pub.add('Implicit Acceptance: l_cust_query:'||l_cust_query);

238: l_cust_query := g_cust_query || g_query_from_clause || l_query_where_clause;
239:
240: IF l_debug_level > 0 THEN
241: oe_debug_pub.add('Implicit Acceptance: l_query_where_clause:'||l_query_where_clause);
242: oe_debug_pub.add('Implicit Acceptance: l_cust_query:'||l_cust_query);
243: END IF;
244:
245: OPEN g_cust_lines FOR l_cust_query
246: USING 'PRE-BILLING_ACCEPTANCE','POST-BILLING_ACCEPTANCE',g_org_id,'Y'; --myerrams, Bug: 5297684

Line 281: oe_debug_pub.add('Exception in getting the fulfillment date');

277: WHERE line_id = l_line_id;
278: EXCEPTION
279:
280: WHEN OTHERS THEN
281: oe_debug_pub.add('Exception in getting the fulfillment date');
282:
283: END;
284:
285: l_expiry_date := l_fulfillment_date + NVL(l_revrec_expiration_days,0);

Line 309: oe_debug_pub.add('Implicit Acceptance: inside l_status condition');

305: l_action_request_tbl(l_table_loop_index).date_param1 := l_expiry_date; -- bug 8293484
306: l_table_loop_index := l_table_loop_index + 1;
307:
308: IF l_debug_level > 0 THEN
309: oe_debug_pub.add('Implicit Acceptance: inside l_status condition');
310: oe_debug_pub.add('Implicit Acceptance: entity_code:'||OE_GLOBALS.G_ENTITY_LINE);
311: oe_debug_pub.add('Implicit Acceptance: request_type:'||OE_GLOBALS.G_ACCEPT_FULFILLMENT);
312: oe_debug_pub.add('Implicit Acceptance: entity_id:'||l_line_id);
313: oe_debug_pub.add('Implicit Acceptance: param5:'||l_header_id);

Line 310: oe_debug_pub.add('Implicit Acceptance: entity_code:'||OE_GLOBALS.G_ENTITY_LINE);

306: l_table_loop_index := l_table_loop_index + 1;
307:
308: IF l_debug_level > 0 THEN
309: oe_debug_pub.add('Implicit Acceptance: inside l_status condition');
310: oe_debug_pub.add('Implicit Acceptance: entity_code:'||OE_GLOBALS.G_ENTITY_LINE);
311: oe_debug_pub.add('Implicit Acceptance: request_type:'||OE_GLOBALS.G_ACCEPT_FULFILLMENT);
312: oe_debug_pub.add('Implicit Acceptance: entity_id:'||l_line_id);
313: oe_debug_pub.add('Implicit Acceptance: param5:'||l_header_id);
314: oe_debug_pub.add('Implicit Acceptance: date_param1:'||l_expiry_date); --bug 8293484

Line 311: oe_debug_pub.add('Implicit Acceptance: request_type:'||OE_GLOBALS.G_ACCEPT_FULFILLMENT);

307:
308: IF l_debug_level > 0 THEN
309: oe_debug_pub.add('Implicit Acceptance: inside l_status condition');
310: oe_debug_pub.add('Implicit Acceptance: entity_code:'||OE_GLOBALS.G_ENTITY_LINE);
311: oe_debug_pub.add('Implicit Acceptance: request_type:'||OE_GLOBALS.G_ACCEPT_FULFILLMENT);
312: oe_debug_pub.add('Implicit Acceptance: entity_id:'||l_line_id);
313: oe_debug_pub.add('Implicit Acceptance: param5:'||l_header_id);
314: oe_debug_pub.add('Implicit Acceptance: date_param1:'||l_expiry_date); --bug 8293484
315: END IF;

Line 312: oe_debug_pub.add('Implicit Acceptance: entity_id:'||l_line_id);

308: IF l_debug_level > 0 THEN
309: oe_debug_pub.add('Implicit Acceptance: inside l_status condition');
310: oe_debug_pub.add('Implicit Acceptance: entity_code:'||OE_GLOBALS.G_ENTITY_LINE);
311: oe_debug_pub.add('Implicit Acceptance: request_type:'||OE_GLOBALS.G_ACCEPT_FULFILLMENT);
312: oe_debug_pub.add('Implicit Acceptance: entity_id:'||l_line_id);
313: oe_debug_pub.add('Implicit Acceptance: param5:'||l_header_id);
314: oe_debug_pub.add('Implicit Acceptance: date_param1:'||l_expiry_date); --bug 8293484
315: END IF;
316: END LOOP;

Line 313: oe_debug_pub.add('Implicit Acceptance: param5:'||l_header_id);

309: oe_debug_pub.add('Implicit Acceptance: inside l_status condition');
310: oe_debug_pub.add('Implicit Acceptance: entity_code:'||OE_GLOBALS.G_ENTITY_LINE);
311: oe_debug_pub.add('Implicit Acceptance: request_type:'||OE_GLOBALS.G_ACCEPT_FULFILLMENT);
312: oe_debug_pub.add('Implicit Acceptance: entity_id:'||l_line_id);
313: oe_debug_pub.add('Implicit Acceptance: param5:'||l_header_id);
314: oe_debug_pub.add('Implicit Acceptance: date_param1:'||l_expiry_date); --bug 8293484
315: END IF;
316: END LOOP;
317: g_action_request_tbl := l_action_request_tbl; --myerrams, Bug:5161878

Line 314: oe_debug_pub.add('Implicit Acceptance: date_param1:'||l_expiry_date); --bug 8293484

310: oe_debug_pub.add('Implicit Acceptance: entity_code:'||OE_GLOBALS.G_ENTITY_LINE);
311: oe_debug_pub.add('Implicit Acceptance: request_type:'||OE_GLOBALS.G_ACCEPT_FULFILLMENT);
312: oe_debug_pub.add('Implicit Acceptance: entity_id:'||l_line_id);
313: oe_debug_pub.add('Implicit Acceptance: param5:'||l_header_id);
314: oe_debug_pub.add('Implicit Acceptance: date_param1:'||l_expiry_date); --bug 8293484
315: END IF;
316: END LOOP;
317: g_action_request_tbl := l_action_request_tbl; --myerrams, Bug:5161878
318: CLOSE g_cust_lines;

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

358: l_action_request_tbl OE_ORDER_PUB.Request_Tbl_Type; --myerrams, Bug:5161878
359: l_query_where_clause VARCHAR2(3000); --myerrams, Bug: 5235959
360: l_max_actual_shipment_date DATE; --myerrams, Bug: 5212583
361: l_count NUMBER; --myerrams, Bug: 5212583
362: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
363: l_query_from_clause VARCHAR2(100);
364:
365: l_expiry_date DATE := SYSDATE; -- bug 8293484
366: l_fulfillment_date DATE; -- bug 8293484

Line 377: oe_debug_pub.add('Implicit Acceptance: Inside Process_expired_lines');

373:
374: BEGIN
375:
376: IF l_debug_level > 0 THEN
377: oe_debug_pub.add('Implicit Acceptance: Inside Process_expired_lines');
378: END IF;
379:
380: /* myerrams, Bug: 5531056. Modified the l_cust_query to restrict records with Acceptance Expire Event as Ship Confirm Date and REVREC_EVENT_CODE as Invoicing (Pre-Billing Acceptance) */
381: l_query_where_clause := ' WHERE oel.contingency_id = arc.contingency_id AND oel.flow_status_code = :1 AND oel.org_id = :2 and oel.open_flag = :3 AND arc.expiration_event_code = :4 AND oel.REVREC_EVENT_CODE = :5 ';

Line 385: oe_debug_pub.add('Implicit Acceptance: the query that is being executed is:'||l_cust_query);

381: l_query_where_clause := ' WHERE oel.contingency_id = arc.contingency_id AND oel.flow_status_code = :1 AND oel.org_id = :2 and oel.open_flag = :3 AND arc.expiration_event_code = :4 AND oel.REVREC_EVENT_CODE = :5 ';
382: l_query_from_clause := ' FROM oe_order_lines_all oel, ar_deferral_reasons arc ';
383: l_cust_query := l_cust_query || l_query_from_clause || l_query_where_clause;
384: IF l_debug_level > 0 THEN
385: oe_debug_pub.add('Implicit Acceptance: the query that is being executed is:'||l_cust_query);
386: END IF;
387:
388: OPEN g_cust_lines FOR l_cust_query
389: USING 'PRE-BILLING_ACCEPTANCE',g_org_id,'Y', 'SHIP_CONFIRM_DATE', 'INVOICING' ; --myerrams, Bug: 5297684

Line 419: oe_debug_pub.add('Inside Non Shippable line Logic');

415: ELSE
416: g_fulfillment_action := OE_GLOBALS.G_ACCEPT_FULFILLMENT;
417: IF l_actual_shipment_date IS NULL THEN
418: IF l_debug_level > 0 THEN
419: oe_debug_pub.add('Inside Non Shippable line Logic');
420: END IF;
421: IF (l_item_type_code = 'KIT' or l_item_type_code = 'MODEL') and l_top_model_line_id = l_line_id THEN
422: IF l_debug_level > 0 THEN
423: oe_debug_pub.add('Inside KIT or MODEL Item Logic, Line_id:'||l_line_id);

Line 423: oe_debug_pub.add('Inside KIT or MODEL Item Logic, Line_id:'||l_line_id);

419: oe_debug_pub.add('Inside Non Shippable line Logic');
420: END IF;
421: IF (l_item_type_code = 'KIT' or l_item_type_code = 'MODEL') and l_top_model_line_id = l_line_id THEN
422: IF l_debug_level > 0 THEN
423: oe_debug_pub.add('Inside KIT or MODEL Item Logic, Line_id:'||l_line_id);
424: END IF;
425: SELECT count(*)
426: INTO l_count
427: FROM oe_order_lines_all

Line 480: oe_debug_pub.add('Exception in getting the fulfillment date'); -- exception should be raised

476: WHERE line_id = l_line_id;
477: EXCEPTION
478:
479: WHEN OTHERS THEN
480: oe_debug_pub.add('Exception in getting the fulfillment date'); -- exception should be raised
481:
482: END;
483:
484: l_expiry_date := l_fulfillment_date + NVL(l_revrec_expiration_days,0);

Line 513: oe_debug_pub.add('Implicit Acceptance: inside l_status condition');

509: l_action_request_tbl(l_table_loop_index).date_param1 := l_expiry_date; --bug 8293484
510: l_table_loop_index := l_table_loop_index + 1;
511:
512: IF l_debug_level > 0 THEN
513: oe_debug_pub.add('Implicit Acceptance: inside l_status condition');
514: oe_debug_pub.add('Implicit Acceptance: entity_code:'||OE_GLOBALS.G_ENTITY_LINE);
515: oe_debug_pub.add('Implicit Acceptance: request_type:'||g_fulfillment_action); --myerrams, Bug: 5212583
516: oe_debug_pub.add('Implicit Acceptance: entity_id:'||l_line_id);
517: oe_debug_pub.add('Implicit Acceptance: param5:'||l_header_id);

Line 514: oe_debug_pub.add('Implicit Acceptance: entity_code:'||OE_GLOBALS.G_ENTITY_LINE);

510: l_table_loop_index := l_table_loop_index + 1;
511:
512: IF l_debug_level > 0 THEN
513: oe_debug_pub.add('Implicit Acceptance: inside l_status condition');
514: oe_debug_pub.add('Implicit Acceptance: entity_code:'||OE_GLOBALS.G_ENTITY_LINE);
515: oe_debug_pub.add('Implicit Acceptance: request_type:'||g_fulfillment_action); --myerrams, Bug: 5212583
516: oe_debug_pub.add('Implicit Acceptance: entity_id:'||l_line_id);
517: oe_debug_pub.add('Implicit Acceptance: param5:'||l_header_id);
518: oe_debug_pub.add('Implicit Acceptance: date_param1:'||l_expiry_date); -- bug 8293484

Line 515: oe_debug_pub.add('Implicit Acceptance: request_type:'||g_fulfillment_action); --myerrams, Bug: 5212583

511:
512: IF l_debug_level > 0 THEN
513: oe_debug_pub.add('Implicit Acceptance: inside l_status condition');
514: oe_debug_pub.add('Implicit Acceptance: entity_code:'||OE_GLOBALS.G_ENTITY_LINE);
515: oe_debug_pub.add('Implicit Acceptance: request_type:'||g_fulfillment_action); --myerrams, Bug: 5212583
516: oe_debug_pub.add('Implicit Acceptance: entity_id:'||l_line_id);
517: oe_debug_pub.add('Implicit Acceptance: param5:'||l_header_id);
518: oe_debug_pub.add('Implicit Acceptance: date_param1:'||l_expiry_date); -- bug 8293484
519: END IF;

Line 516: oe_debug_pub.add('Implicit Acceptance: entity_id:'||l_line_id);

512: IF l_debug_level > 0 THEN
513: oe_debug_pub.add('Implicit Acceptance: inside l_status condition');
514: oe_debug_pub.add('Implicit Acceptance: entity_code:'||OE_GLOBALS.G_ENTITY_LINE);
515: oe_debug_pub.add('Implicit Acceptance: request_type:'||g_fulfillment_action); --myerrams, Bug: 5212583
516: oe_debug_pub.add('Implicit Acceptance: entity_id:'||l_line_id);
517: oe_debug_pub.add('Implicit Acceptance: param5:'||l_header_id);
518: oe_debug_pub.add('Implicit Acceptance: date_param1:'||l_expiry_date); -- bug 8293484
519: END IF;
520: END IF;

Line 517: oe_debug_pub.add('Implicit Acceptance: param5:'||l_header_id);

513: oe_debug_pub.add('Implicit Acceptance: inside l_status condition');
514: oe_debug_pub.add('Implicit Acceptance: entity_code:'||OE_GLOBALS.G_ENTITY_LINE);
515: oe_debug_pub.add('Implicit Acceptance: request_type:'||g_fulfillment_action); --myerrams, Bug: 5212583
516: oe_debug_pub.add('Implicit Acceptance: entity_id:'||l_line_id);
517: oe_debug_pub.add('Implicit Acceptance: param5:'||l_header_id);
518: oe_debug_pub.add('Implicit Acceptance: date_param1:'||l_expiry_date); -- bug 8293484
519: END IF;
520: END IF;
521: END LOOP;

Line 518: oe_debug_pub.add('Implicit Acceptance: date_param1:'||l_expiry_date); -- bug 8293484

514: oe_debug_pub.add('Implicit Acceptance: entity_code:'||OE_GLOBALS.G_ENTITY_LINE);
515: oe_debug_pub.add('Implicit Acceptance: request_type:'||g_fulfillment_action); --myerrams, Bug: 5212583
516: oe_debug_pub.add('Implicit Acceptance: entity_id:'||l_line_id);
517: oe_debug_pub.add('Implicit Acceptance: param5:'||l_header_id);
518: oe_debug_pub.add('Implicit Acceptance: date_param1:'||l_expiry_date); -- bug 8293484
519: END IF;
520: END IF;
521: END LOOP;
522: g_action_request_tbl := l_action_request_tbl; --myerrams, Bug:5161878

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

544: l_line_adj_assoc_out_tbl OE_ORDER_PUB.Line_Adj_Assoc_Tbl_Type;
545: l_line_scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
546: l_lot_serial_out_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
547: l_action_request_out_tbl OE_Order_PUB.Request_Tbl_Type;
548: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
549: BEGIN
550: IF l_debug_level > 0 THEN
551: oe_debug_pub.add('Implicit Acceptance: Before call to Process Order API');
552: END IF;

Line 551: oe_debug_pub.add('Implicit Acceptance: Before call to Process Order API');

547: l_action_request_out_tbl OE_Order_PUB.Request_Tbl_Type;
548: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
549: BEGIN
550: IF l_debug_level > 0 THEN
551: oe_debug_pub.add('Implicit Acceptance: Before call to Process Order API');
552: END IF;
553: OE_Order_PVT.Process_Order( p_api_version_number => 1.0
554: , x_return_status => g_return_status
555: , x_msg_count => g_msg_count

Line 573: oe_debug_pub.add('Implicit Acceptance: After call to Process Order API');

569: , p_x_lot_serial_tbl => l_lot_serial_out_tbl
570: , p_x_action_request_tbl => g_action_request_tbl
571: );
572: IF l_debug_level > 0 THEN
573: oe_debug_pub.add('Implicit Acceptance: After call to Process Order API');
574: END IF;
575: --myerrams, decode the message
576: if g_msg_count > 0 then
577: for k in 1 .. g_msg_count loop

Line 585: oe_debug_pub.add('Implicit Acceptance: Process Order Error Msgs -> g_msg_data:'||g_msg_data);

581: g_msg_data := g_msg_data || k || '.' || g_msg_data || ' ' ;
582: end loop;
583: end if;
584: IF l_debug_level > 0 THEN
585: oe_debug_pub.add('Implicit Acceptance: Process Order Error Msgs -> g_msg_data:'||g_msg_data);
586: END IF;
587: EXCEPTION
588: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
589: THEN

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

626: l_line_id NUMBER;
627: l_contingency_id NUMBER;
628: l_revrec_event_code VARCHAR2(30);
629: l_accepted_quantity NUMBER;
630: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
631: BEGIN
632: OE_SERVICE_UTIL.Get_Cust_Product_Line_Id( x_return_status => l_return_status
633: , p_reference_line_id => p_service_ref_line_id
634: , p_customer_id => p_sold_to_org_id

Line 659: oe_debug_pub.add('Implicit Acceptance: validate_service_lines returns true');

655: ELSE
656: g_fulfillment_action := OE_GLOBALS.G_ACCEPT_FULFILLMENT;
657: END IF;
658: IF l_debug_level > 0 THEN
659: oe_debug_pub.add('Implicit Acceptance: validate_service_lines returns true');
660: END IF;
661: RETURN TRUE;
662: ELSE
663: IF l_debug_level > 0 THEN

Line 664: oe_debug_pub.add('Implicit Acceptance: validate_service_lines returns false');

660: END IF;
661: RETURN TRUE;
662: ELSE
663: IF l_debug_level > 0 THEN
664: oe_debug_pub.add('Implicit Acceptance: validate_service_lines returns false');
665: END IF;
666: RETURN FALSE;
667: END IF;
668:

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

680: RETURN BOOLEAN
681: IS
682: l_reference_date DATE;
683: l_revrec_expiration_days NUMBER;
684: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
685: BEGIN
686: l_reference_date := p_actual_shipment_date;
687:
688: /* myerrams, Bug: 5531056; If Exipration Days is null, then its explicit acceptance.