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

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

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

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

79: -- Get the value of system parameter,To verify whether customer acceptance is enabled.
80: -- MOAC Start
81: IF g_org_id IS NOT NULL THEN
82: IF l_debug_level > 0 THEN
83: oe_debug_pub.add('Implicit Acceptance: g_org_id:'||g_org_id);
84: END IF;
85:
86: MO_GLOBAL.set_policy_context('S', g_org_id);
87: l_cust_sys_param := OE_SYS_PARAMETERS.VALUE('ENABLE_FULFILLMENT_ACCEPTANCE',g_org_id);

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

88:
89: /* myerrams, Bug: 5161878. Null value should be treated as No.*/
90: IF l_cust_sys_param = 'Y' THEN
91: IF l_debug_level > 0 THEN
92: oe_debug_pub.add('Implicit Acceptance: Customer Acceptance System Parameter is True');
93: END IF;
94: g_customer_acceptance_enabled := true;
95: ELSE
96: IF l_debug_level > 0 THEN

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

93: END IF;
94: g_customer_acceptance_enabled := true;
95: ELSE
96: IF l_debug_level > 0 THEN
97: oe_debug_pub.add('Implicit Acceptance: Customer Acceptance System Parameter is False');
98: END IF;
99: g_customer_acceptance_enabled := false;
100: END IF;
101: /*myerrams, Bug: 5161878. End.*/

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

120:
121: /* myerrams, Bug: 5161878. Null value should be treated as No.*/
122: IF l_cust_sys_param = 'Y' THEN
123: IF l_debug_level > 0 THEN
124: oe_debug_pub.add('Implicit Acceptance: Customer Acceptance System Parameter is True for Org:'||g_org_id );
125: END IF;
126: g_customer_acceptance_enabled := true;
127: ELSE
128: IF l_debug_level > 0 THEN

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

125: END IF;
126: g_customer_acceptance_enabled := true;
127: ELSE
128: IF l_debug_level > 0 THEN
129: oe_debug_pub.add('Implicit Acceptance: Customer Acceptance System Parameter is False for Org:'||g_org_id);
130: END IF;
131: g_customer_acceptance_enabled := false;
132: END IF;
133: /* myerrams, Bug: 5161878. End.*/

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

203: -- Dynamic Cursor Variable
204: -- =======================
205: TYPE g_cust_lines_type IS REF CURSOR;
206: g_cust_lines g_cust_lines_type;
207: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
208:
209: BEGIN
210:
211: /*myerrams, Bug:5161878. This method is executed more than once.

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

218: l_query_where_clause := ' WHERE flow_status_code in (:1 , :2) AND org_id = :3 and open_flag = :4 ';
219: l_cust_query := g_cust_query || g_query_from_clause || l_query_where_clause;
220:
221: IF l_debug_level > 0 THEN
222: oe_debug_pub.add('Implicit Acceptance: l_query_where_clause:'||l_query_where_clause);
223: oe_debug_pub.add('Implicit Acceptance: l_cust_query:'||l_cust_query);
224: END IF;
225:
226: OPEN g_cust_lines FOR l_cust_query

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

219: l_cust_query := g_cust_query || g_query_from_clause || l_query_where_clause;
220:
221: IF l_debug_level > 0 THEN
222: oe_debug_pub.add('Implicit Acceptance: l_query_where_clause:'||l_query_where_clause);
223: oe_debug_pub.add('Implicit Acceptance: l_cust_query:'||l_cust_query);
224: END IF;
225:
226: OPEN g_cust_lines FOR l_cust_query
227: USING 'PRE-BILLING_ACCEPTANCE','POST-BILLING_ACCEPTANCE',g_org_id,'Y'; --myerrams, Bug: 5297684

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

257: l_action_request_tbl(l_table_loop_index).date_param1 := SYSDATE;
258: l_table_loop_index := l_table_loop_index + 1;
259:
260: IF l_debug_level > 0 THEN
261: oe_debug_pub.add('Implicit Acceptance: inside l_status condition');
262: oe_debug_pub.add('Implicit Acceptance: entity_code:'||OE_GLOBALS.G_ENTITY_LINE);
263: oe_debug_pub.add('Implicit Acceptance: request_type:'||OE_GLOBALS.G_ACCEPT_FULFILLMENT);
264: oe_debug_pub.add('Implicit Acceptance: entity_id:'||l_line_id);
265: oe_debug_pub.add('Implicit Acceptance: param5:'||l_header_id);

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

258: l_table_loop_index := l_table_loop_index + 1;
259:
260: IF l_debug_level > 0 THEN
261: oe_debug_pub.add('Implicit Acceptance: inside l_status condition');
262: oe_debug_pub.add('Implicit Acceptance: entity_code:'||OE_GLOBALS.G_ENTITY_LINE);
263: oe_debug_pub.add('Implicit Acceptance: request_type:'||OE_GLOBALS.G_ACCEPT_FULFILLMENT);
264: oe_debug_pub.add('Implicit Acceptance: entity_id:'||l_line_id);
265: oe_debug_pub.add('Implicit Acceptance: param5:'||l_header_id);
266: oe_debug_pub.add('Implicit Acceptance: date_param1:'||SYSDATE);

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

259:
260: IF l_debug_level > 0 THEN
261: oe_debug_pub.add('Implicit Acceptance: inside l_status condition');
262: oe_debug_pub.add('Implicit Acceptance: entity_code:'||OE_GLOBALS.G_ENTITY_LINE);
263: oe_debug_pub.add('Implicit Acceptance: request_type:'||OE_GLOBALS.G_ACCEPT_FULFILLMENT);
264: oe_debug_pub.add('Implicit Acceptance: entity_id:'||l_line_id);
265: oe_debug_pub.add('Implicit Acceptance: param5:'||l_header_id);
266: oe_debug_pub.add('Implicit Acceptance: date_param1:'||SYSDATE);
267: END IF;

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

260: IF l_debug_level > 0 THEN
261: oe_debug_pub.add('Implicit Acceptance: inside l_status condition');
262: oe_debug_pub.add('Implicit Acceptance: entity_code:'||OE_GLOBALS.G_ENTITY_LINE);
263: oe_debug_pub.add('Implicit Acceptance: request_type:'||OE_GLOBALS.G_ACCEPT_FULFILLMENT);
264: oe_debug_pub.add('Implicit Acceptance: entity_id:'||l_line_id);
265: oe_debug_pub.add('Implicit Acceptance: param5:'||l_header_id);
266: oe_debug_pub.add('Implicit Acceptance: date_param1:'||SYSDATE);
267: END IF;
268: END LOOP;

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

261: oe_debug_pub.add('Implicit Acceptance: inside l_status condition');
262: oe_debug_pub.add('Implicit Acceptance: entity_code:'||OE_GLOBALS.G_ENTITY_LINE);
263: oe_debug_pub.add('Implicit Acceptance: request_type:'||OE_GLOBALS.G_ACCEPT_FULFILLMENT);
264: oe_debug_pub.add('Implicit Acceptance: entity_id:'||l_line_id);
265: oe_debug_pub.add('Implicit Acceptance: param5:'||l_header_id);
266: oe_debug_pub.add('Implicit Acceptance: date_param1:'||SYSDATE);
267: END IF;
268: END LOOP;
269: g_action_request_tbl := l_action_request_tbl; --myerrams, Bug:5161878

Line 266: oe_debug_pub.add('Implicit Acceptance: date_param1:'||SYSDATE);

262: oe_debug_pub.add('Implicit Acceptance: entity_code:'||OE_GLOBALS.G_ENTITY_LINE);
263: oe_debug_pub.add('Implicit Acceptance: request_type:'||OE_GLOBALS.G_ACCEPT_FULFILLMENT);
264: oe_debug_pub.add('Implicit Acceptance: entity_id:'||l_line_id);
265: oe_debug_pub.add('Implicit Acceptance: param5:'||l_header_id);
266: oe_debug_pub.add('Implicit Acceptance: date_param1:'||SYSDATE);
267: END IF;
268: END LOOP;
269: g_action_request_tbl := l_action_request_tbl; --myerrams, Bug:5161878
270: CLOSE g_cust_lines;

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

310: l_action_request_tbl OE_ORDER_PUB.Request_Tbl_Type; --myerrams, Bug:5161878
311: l_query_where_clause VARCHAR2(3000); --myerrams, Bug: 5235959
312: l_max_actual_shipment_date DATE; --myerrams, Bug: 5212583
313: l_count NUMBER; --myerrams, Bug: 5212583
314: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
315: l_query_from_clause VARCHAR2(100);
316: -- ======================
317: -- Dynamic Cursor Variable
318: -- =======================

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

321:
322: BEGIN
323:
324: IF l_debug_level > 0 THEN
325: oe_debug_pub.add('Implicit Acceptance: Inside Process_expired_lines');
326: END IF;
327:
328: /* 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) */
329: 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 333: oe_debug_pub.add('Implicit Acceptance: the query that is being executed is:'||l_cust_query);

329: 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 ';
330: l_query_from_clause := ' FROM oe_order_lines_all oel, ar_deferral_reasons arc ';
331: l_cust_query := l_cust_query || l_query_from_clause || l_query_where_clause;
332: IF l_debug_level > 0 THEN
333: oe_debug_pub.add('Implicit Acceptance: the query that is being executed is:'||l_cust_query);
334: END IF;
335:
336: OPEN g_cust_lines FOR l_cust_query
337: USING 'PRE-BILLING_ACCEPTANCE',g_org_id,'Y', 'SHIP_CONFIRM_DATE', 'INVOICING' ; --myerrams, Bug: 5297684

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

363: ELSE
364: g_fulfillment_action := OE_GLOBALS.G_ACCEPT_FULFILLMENT;
365: IF l_actual_shipment_date IS NULL THEN
366: IF l_debug_level > 0 THEN
367: oe_debug_pub.add('Inside Non Shippable line Logic');
368: END IF;
369: IF (l_item_type_code = 'KIT' or l_item_type_code = 'MODEL') and l_top_model_line_id = l_line_id THEN
370: IF l_debug_level > 0 THEN
371: oe_debug_pub.add('Inside KIT or MODEL Item Logic, Line_id:'||l_line_id);

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

367: oe_debug_pub.add('Inside Non Shippable line Logic');
368: END IF;
369: IF (l_item_type_code = 'KIT' or l_item_type_code = 'MODEL') and l_top_model_line_id = l_line_id THEN
370: IF l_debug_level > 0 THEN
371: oe_debug_pub.add('Inside KIT or MODEL Item Logic, Line_id:'||l_line_id);
372: END IF;
373: SELECT count(*)
374: INTO l_count
375: FROM oe_order_lines_all

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

428: l_action_request_tbl(l_table_loop_index).date_param1 := SYSDATE;
429: l_table_loop_index := l_table_loop_index + 1;
430:
431: IF l_debug_level > 0 THEN
432: oe_debug_pub.add('Implicit Acceptance: inside l_status condition');
433: oe_debug_pub.add('Implicit Acceptance: entity_code:'||OE_GLOBALS.G_ENTITY_LINE);
434: oe_debug_pub.add('Implicit Acceptance: request_type:'||g_fulfillment_action); --myerrams, Bug: 5212583
435: oe_debug_pub.add('Implicit Acceptance: entity_id:'||l_line_id);
436: oe_debug_pub.add('Implicit Acceptance: param5:'||l_header_id);

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

429: l_table_loop_index := l_table_loop_index + 1;
430:
431: IF l_debug_level > 0 THEN
432: oe_debug_pub.add('Implicit Acceptance: inside l_status condition');
433: oe_debug_pub.add('Implicit Acceptance: entity_code:'||OE_GLOBALS.G_ENTITY_LINE);
434: oe_debug_pub.add('Implicit Acceptance: request_type:'||g_fulfillment_action); --myerrams, Bug: 5212583
435: oe_debug_pub.add('Implicit Acceptance: entity_id:'||l_line_id);
436: oe_debug_pub.add('Implicit Acceptance: param5:'||l_header_id);
437: oe_debug_pub.add('Implicit Acceptance: date_param1:'||SYSDATE);

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

430:
431: IF l_debug_level > 0 THEN
432: oe_debug_pub.add('Implicit Acceptance: inside l_status condition');
433: oe_debug_pub.add('Implicit Acceptance: entity_code:'||OE_GLOBALS.G_ENTITY_LINE);
434: oe_debug_pub.add('Implicit Acceptance: request_type:'||g_fulfillment_action); --myerrams, Bug: 5212583
435: oe_debug_pub.add('Implicit Acceptance: entity_id:'||l_line_id);
436: oe_debug_pub.add('Implicit Acceptance: param5:'||l_header_id);
437: oe_debug_pub.add('Implicit Acceptance: date_param1:'||SYSDATE);
438: END IF;

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

431: IF l_debug_level > 0 THEN
432: oe_debug_pub.add('Implicit Acceptance: inside l_status condition');
433: oe_debug_pub.add('Implicit Acceptance: entity_code:'||OE_GLOBALS.G_ENTITY_LINE);
434: oe_debug_pub.add('Implicit Acceptance: request_type:'||g_fulfillment_action); --myerrams, Bug: 5212583
435: oe_debug_pub.add('Implicit Acceptance: entity_id:'||l_line_id);
436: oe_debug_pub.add('Implicit Acceptance: param5:'||l_header_id);
437: oe_debug_pub.add('Implicit Acceptance: date_param1:'||SYSDATE);
438: END IF;
439: END IF;

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

432: oe_debug_pub.add('Implicit Acceptance: inside l_status condition');
433: oe_debug_pub.add('Implicit Acceptance: entity_code:'||OE_GLOBALS.G_ENTITY_LINE);
434: oe_debug_pub.add('Implicit Acceptance: request_type:'||g_fulfillment_action); --myerrams, Bug: 5212583
435: oe_debug_pub.add('Implicit Acceptance: entity_id:'||l_line_id);
436: oe_debug_pub.add('Implicit Acceptance: param5:'||l_header_id);
437: oe_debug_pub.add('Implicit Acceptance: date_param1:'||SYSDATE);
438: END IF;
439: END IF;
440: END LOOP;

Line 437: oe_debug_pub.add('Implicit Acceptance: date_param1:'||SYSDATE);

433: oe_debug_pub.add('Implicit Acceptance: entity_code:'||OE_GLOBALS.G_ENTITY_LINE);
434: oe_debug_pub.add('Implicit Acceptance: request_type:'||g_fulfillment_action); --myerrams, Bug: 5212583
435: oe_debug_pub.add('Implicit Acceptance: entity_id:'||l_line_id);
436: oe_debug_pub.add('Implicit Acceptance: param5:'||l_header_id);
437: oe_debug_pub.add('Implicit Acceptance: date_param1:'||SYSDATE);
438: END IF;
439: END IF;
440: END LOOP;
441: g_action_request_tbl := l_action_request_tbl; --myerrams, Bug:5161878

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

463: l_line_adj_assoc_out_tbl OE_ORDER_PUB.Line_Adj_Assoc_Tbl_Type;
464: l_line_scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
465: l_lot_serial_out_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
466: l_action_request_out_tbl OE_Order_PUB.Request_Tbl_Type;
467: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
468: BEGIN
469: IF l_debug_level > 0 THEN
470: oe_debug_pub.add('Implicit Acceptance: Before call to Process Order API');
471: END IF;

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

466: l_action_request_out_tbl OE_Order_PUB.Request_Tbl_Type;
467: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
468: BEGIN
469: IF l_debug_level > 0 THEN
470: oe_debug_pub.add('Implicit Acceptance: Before call to Process Order API');
471: END IF;
472: OE_Order_PVT.Process_Order( p_api_version_number => 1.0
473: , x_return_status => g_return_status
474: , x_msg_count => g_msg_count

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

488: , p_x_lot_serial_tbl => l_lot_serial_out_tbl
489: , p_x_action_request_tbl => g_action_request_tbl
490: );
491: IF l_debug_level > 0 THEN
492: oe_debug_pub.add('Implicit Acceptance: After call to Process Order API');
493: END IF;
494: --myerrams, decode the message
495: if g_msg_count > 0 then
496: for k in 1 .. g_msg_count loop

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

500: g_msg_data := g_msg_data || k || '.' || g_msg_data || ' ' ;
501: end loop;
502: end if;
503: IF l_debug_level > 0 THEN
504: oe_debug_pub.add('Implicit Acceptance: Process Order Error Msgs -> g_msg_data:'||g_msg_data);
505: END IF;
506: EXCEPTION
507: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
508: THEN

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

545: l_line_id NUMBER;
546: l_contingency_id NUMBER;
547: l_revrec_event_code VARCHAR2(30);
548: l_accepted_quantity NUMBER;
549: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
550: BEGIN
551: OE_SERVICE_UTIL.Get_Cust_Product_Line_Id( x_return_status => l_return_status
552: , p_reference_line_id => p_service_ref_line_id
553: , p_customer_id => p_sold_to_org_id

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

574: ELSE
575: g_fulfillment_action := OE_GLOBALS.G_ACCEPT_FULFILLMENT;
576: END IF;
577: IF l_debug_level > 0 THEN
578: oe_debug_pub.add('Implicit Acceptance: validate_service_lines returns true');
579: END IF;
580: RETURN TRUE;
581: ELSE
582: IF l_debug_level > 0 THEN

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

579: END IF;
580: RETURN TRUE;
581: ELSE
582: IF l_debug_level > 0 THEN
583: oe_debug_pub.add('Implicit Acceptance: validate_service_lines returns false');
584: END IF;
585: RETURN FALSE;
586: END IF;
587:

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

599: RETURN BOOLEAN
600: IS
601: l_reference_date DATE;
602: l_revrec_expiration_days NUMBER;
603: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
604: BEGIN
605: l_reference_date := p_actual_shipment_date;
606:
607: /* myerrams, Bug: 5531056; If Exipration Days is null, then its explicit acceptance.