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

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

24: ) IS
25:
26: l_line_index NUMBER := 0;
27: l_mod_line_id NUMBER;
28: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
29:
30: BEGIN
31: IF l_debug_level > 0 THEN
32: oe_debug_pub.add('Entering OE_ACCEPTANCE_UTIL.Register_Changed_Lines ' );

Line 32: oe_debug_pub.add('Entering OE_ACCEPTANCE_UTIL.Register_Changed_Lines ' );

28: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
29:
30: BEGIN
31: IF l_debug_level > 0 THEN
32: oe_debug_pub.add('Entering OE_ACCEPTANCE_UTIL.Register_Changed_Lines ' );
33: END IF;
34:
35: IF l_debug_level > 0 THEN
36: oe_debug_pub.add('Operation value is ' || p_operation );

Line 36: oe_debug_pub.add('Operation value is ' || p_operation );

32: oe_debug_pub.add('Entering OE_ACCEPTANCE_UTIL.Register_Changed_Lines ' );
33: END IF;
34:
35: IF l_debug_level > 0 THEN
36: oe_debug_pub.add('Operation value is ' || p_operation );
37: END IF;
38:
39: l_mod_line_id := MOD(p_line_id, G_BINARY_LIMIT); -- Bug 8656395
40: IF p_operation In (OE_GLOBALS.G_OPR_CREATE, OE_GLOBALS.G_OPR_UPDATE) THEN

Line 49: oe_debug_pub.add('Line Index value is ' || l_line_index );

45: G_line_index_tbl(l_mod_line_id).line_index := l_line_index;
46: END IF;
47:
48: IF l_debug_level > 0 THEN
49: oe_debug_pub.add('Line Index value is ' || l_line_index );
50: END IF;
51:
52: G_Line_id_tbl(l_line_index) := nvl(p_line_id, -99);
53: G_header_id_tbl(l_line_index) := nvl(p_header_id, -99);

Line 68: oe_debug_pub.add('Line Index value is ' || l_line_index ); -- Replaced p_line_id with l_mod_line_id 8656395

64: ELSIF p_operation = OE_GLOBALS.G_OPR_DELETE THEN
65:
66: IF G_line_index_tbl.exists(l_mod_line_id) THEN
67: IF l_debug_level > 0 THEN
68: oe_debug_pub.add('Line Index value is ' || l_line_index ); -- Replaced p_line_id with l_mod_line_id 8656395
69: END IF;
70: G_Line_id_tbl(G_line_index_tbl(l_mod_line_id).line_index) := -99;
71: G_line_index_tbl.delete(l_mod_line_id);
72: END IF;

Line 77: oe_debug_pub.add('Exiting OE_ACCEPTANCE_UTIL.Register_Changed_Lines ' );

73:
74: END IF;
75:
76: IF l_debug_level > 0 THEN
77: oe_debug_pub.add('Exiting OE_ACCEPTANCE_UTIL.Register_Changed_Lines ' );
78: END IF;
79:
80: END Register_Changed_Lines;
81:

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

105: FUNCTION Get_batch_source_ID
106: (p_batch_source_name VARCHAR2)
107: RETURN NUMBER IS
108:
109: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
110:
111: BEGIN
112: IF l_debug_level > 0 THEN
113: oe_debug_pub.add('Entering OE_ACCEPTANCE_UTIL.Get_batch_source_ID ' );

Line 113: oe_debug_pub.add('Entering OE_ACCEPTANCE_UTIL.Get_batch_source_ID ' );

109: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
110:
111: BEGIN
112: IF l_debug_level > 0 THEN
113: oe_debug_pub.add('Entering OE_ACCEPTANCE_UTIL.Get_batch_source_ID ' );
114: END IF;
115:
116: IF l_debug_level > 0 THEN
117: oe_debug_pub.add('IN Batch source name is ' || p_batch_source_name );

Line 117: oe_debug_pub.add('IN Batch source name is ' || p_batch_source_name );

113: oe_debug_pub.add('Entering OE_ACCEPTANCE_UTIL.Get_batch_source_ID ' );
114: END IF;
115:
116: IF l_debug_level > 0 THEN
117: oe_debug_pub.add('IN Batch source name is ' || p_batch_source_name );
118: END IF;
119:
120: IF p_batch_source_name IS NOT NULL THEN
121: IF g_batch_source_name = FND_API.G_MISS_CHAR OR

Line 134: oe_debug_pub.add('OUT Batch source name: ' || g_batch_source_name||' :batch_source_id:'||g_batch_source_id );

130:
131: END IF;
132:
133: IF l_debug_level > 0 THEN
134: oe_debug_pub.add('OUT Batch source name: ' || g_batch_source_name||' :batch_source_id:'||g_batch_source_id );
135: END IF;
136:
137: RETURN g_batch_source_id;
138: ELSE

Line 143: oe_debug_pub.add('Exiting OE_ACCEPTANCE_UTIL.Get_batch_source_ID ' );

139: RETURN -99;
140: END IF;
141:
142: IF l_debug_level > 0 THEN
143: oe_debug_pub.add('Exiting OE_ACCEPTANCE_UTIL.Get_batch_source_ID ' );
144: END IF;
145:
146: EXCEPTION
147: WHEN NO_DATA_FOUND THEN

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

149: END get_batch_source_ID;
150:
151: PROCEDURE Default_Contingency_Attributes IS
152:
153: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
154:
155: l_return_status VARCHAR2(1);
156: l_msg_count NUMBER;
157: l_msg_data VARCHAR2(2000);

Line 185: oe_debug_pub.add('Entering OE_ACCEPTANCE_UTIL.Default_Contingency_Attributes ' );

181: ORDER BY id, revrec_event_code DESC, expiration_days, creation_date DESC;
182:
183: BEGIN
184: IF l_debug_level > 0 THEN
185: oe_debug_pub.add('Entering OE_ACCEPTANCE_UTIL.Default_Contingency_Attributes ' );
186: END IF;
187:
188: FOR i in 1..g_Line_id_tbl.count LOOP
189:

Line 192: oe_debug_pub.add('Setting remaining attributes as -99');

188: FOR i in 1..g_Line_id_tbl.count LOOP
189:
190: IF g_line_id_tbl(i) = -99 THEN
191: IF l_debug_level > 0 THEN
192: oe_debug_pub.add('Setting remaining attributes as -99');
193: END IF;
194: g_invoice_to_customer_tbl(i) := -99;
195: g_invoice_to_site_tbl(i) := -99;
196: g_cust_trx_type_id_tbl(i) := -99;

Line 250: oe_debug_pub.add('Line type details... ' );

246: l_invoice_source_id := l_line_type_rec.invoice_source_id;
247: l_non_d_invoice_source_id := l_line_type_rec.non_delivery_invoice_source_id;
248:
249: IF l_debug_level > 0 THEN
250: oe_debug_pub.add('Line type details... ' );
251: oe_debug_pub.add('Customer Transaction type : ' || l_cust_trx_type_id );
252: oe_debug_pub.add('Invoice Source : ' || l_invoice_source_id );
253: oe_debug_pub.add('Non Delivery Invoice Source : ' || l_non_d_invoice_source_id );
254: END IF;

Line 251: oe_debug_pub.add('Customer Transaction type : ' || l_cust_trx_type_id );

247: l_non_d_invoice_source_id := l_line_type_rec.non_delivery_invoice_source_id;
248:
249: IF l_debug_level > 0 THEN
250: oe_debug_pub.add('Line type details... ' );
251: oe_debug_pub.add('Customer Transaction type : ' || l_cust_trx_type_id );
252: oe_debug_pub.add('Invoice Source : ' || l_invoice_source_id );
253: oe_debug_pub.add('Non Delivery Invoice Source : ' || l_non_d_invoice_source_id );
254: END IF;
255:

Line 252: oe_debug_pub.add('Invoice Source : ' || l_invoice_source_id );

248:
249: IF l_debug_level > 0 THEN
250: oe_debug_pub.add('Line type details... ' );
251: oe_debug_pub.add('Customer Transaction type : ' || l_cust_trx_type_id );
252: oe_debug_pub.add('Invoice Source : ' || l_invoice_source_id );
253: oe_debug_pub.add('Non Delivery Invoice Source : ' || l_non_d_invoice_source_id );
254: END IF;
255:
256: IF l_cust_trx_type_id IS NULL OR

Line 253: oe_debug_pub.add('Non Delivery Invoice Source : ' || l_non_d_invoice_source_id );

249: IF l_debug_level > 0 THEN
250: oe_debug_pub.add('Line type details... ' );
251: oe_debug_pub.add('Customer Transaction type : ' || l_cust_trx_type_id );
252: oe_debug_pub.add('Invoice Source : ' || l_invoice_source_id );
253: oe_debug_pub.add('Non Delivery Invoice Source : ' || l_non_d_invoice_source_id );
254: END IF;
255:
256: IF l_cust_trx_type_id IS NULL OR
257: (l_invoice_source_id IS NULL AND (g_shippable_flag_tbl(i) = 'Y' OR l_invoice_numbering_method = 'A')) OR

Line 267: oe_debug_pub.add('Order type details... ' );

263: l_non_d_invoice_source_id2 := l_order_type_rec.non_delivery_invoice_source_id;
264: END IF;
265:
266: IF l_debug_level > 0 THEN
267: oe_debug_pub.add('Order type details... ' );
268: oe_debug_pub.add('Customer Transaction type : ' || l_cust_trx_type_id2 );
269: oe_debug_pub.add('Invoice Source : ' || l_invoice_source_id2 );
270: oe_debug_pub.add('Non Delivery Invoice Source : ' || l_non_d_invoice_source_id2 );
271: END IF;

Line 268: oe_debug_pub.add('Customer Transaction type : ' || l_cust_trx_type_id2 );

264: END IF;
265:
266: IF l_debug_level > 0 THEN
267: oe_debug_pub.add('Order type details... ' );
268: oe_debug_pub.add('Customer Transaction type : ' || l_cust_trx_type_id2 );
269: oe_debug_pub.add('Invoice Source : ' || l_invoice_source_id2 );
270: oe_debug_pub.add('Non Delivery Invoice Source : ' || l_non_d_invoice_source_id2 );
271: END IF;
272:

Line 269: oe_debug_pub.add('Invoice Source : ' || l_invoice_source_id2 );

265:
266: IF l_debug_level > 0 THEN
267: oe_debug_pub.add('Order type details... ' );
268: oe_debug_pub.add('Customer Transaction type : ' || l_cust_trx_type_id2 );
269: oe_debug_pub.add('Invoice Source : ' || l_invoice_source_id2 );
270: oe_debug_pub.add('Non Delivery Invoice Source : ' || l_non_d_invoice_source_id2 );
271: END IF;
272:
273: g_cust_trx_type_id_tbl(i) := NVL(l_cust_trx_type_id, NVL(l_cust_trx_type_id2, NVL(OE_SYS_PARAMETERS.VALUE('OE_INVOICE_TRANSACTION_TYPE_ID', g_org_id_tbl(i)), -99)));

Line 270: oe_debug_pub.add('Non Delivery Invoice Source : ' || l_non_d_invoice_source_id2 );

266: IF l_debug_level > 0 THEN
267: oe_debug_pub.add('Order type details... ' );
268: oe_debug_pub.add('Customer Transaction type : ' || l_cust_trx_type_id2 );
269: oe_debug_pub.add('Invoice Source : ' || l_invoice_source_id2 );
270: oe_debug_pub.add('Non Delivery Invoice Source : ' || l_non_d_invoice_source_id2 );
271: END IF;
272:
273: g_cust_trx_type_id_tbl(i) := NVL(l_cust_trx_type_id, NVL(l_cust_trx_type_id2, NVL(OE_SYS_PARAMETERS.VALUE('OE_INVOICE_TRANSACTION_TYPE_ID', g_org_id_tbl(i)), -99)));
274:

Line 290: oe_debug_pub.add('i:'||i);

286: END IF;
287: END IF;
288:
289: IF l_debug_level > 0 THEN
290: oe_debug_pub.add('i:'||i);
291: oe_debug_pub.add('g_line_id_tbl(i):'||g_line_id_tbl(i));
292: oe_debug_pub.add('g_invoice_to_customer_tbl(i):'||g_invoice_to_customer_tbl(i));
293: oe_debug_pub.add('G_invoice_to_site_tbl(i):'||G_invoice_to_site_tbl(i));
294: oe_debug_pub.add('g_inventory_item_id_tbl(i):'||g_inventory_item_id_tbl(i));

Line 291: oe_debug_pub.add('g_line_id_tbl(i):'||g_line_id_tbl(i));

287: END IF;
288:
289: IF l_debug_level > 0 THEN
290: oe_debug_pub.add('i:'||i);
291: oe_debug_pub.add('g_line_id_tbl(i):'||g_line_id_tbl(i));
292: oe_debug_pub.add('g_invoice_to_customer_tbl(i):'||g_invoice_to_customer_tbl(i));
293: oe_debug_pub.add('G_invoice_to_site_tbl(i):'||G_invoice_to_site_tbl(i));
294: oe_debug_pub.add('g_inventory_item_id_tbl(i):'||g_inventory_item_id_tbl(i));
295: oe_debug_pub.add('Customer Transaction type : ' || g_cust_trx_type_id_tbl(i) );

Line 292: oe_debug_pub.add('g_invoice_to_customer_tbl(i):'||g_invoice_to_customer_tbl(i));

288:
289: IF l_debug_level > 0 THEN
290: oe_debug_pub.add('i:'||i);
291: oe_debug_pub.add('g_line_id_tbl(i):'||g_line_id_tbl(i));
292: oe_debug_pub.add('g_invoice_to_customer_tbl(i):'||g_invoice_to_customer_tbl(i));
293: oe_debug_pub.add('G_invoice_to_site_tbl(i):'||G_invoice_to_site_tbl(i));
294: oe_debug_pub.add('g_inventory_item_id_tbl(i):'||g_inventory_item_id_tbl(i));
295: oe_debug_pub.add('Customer Transaction type : ' || g_cust_trx_type_id_tbl(i) );
296: oe_debug_pub.add('Invoice Source : ' || g_batch_source_id_tbl(i) );

Line 293: oe_debug_pub.add('G_invoice_to_site_tbl(i):'||G_invoice_to_site_tbl(i));

289: IF l_debug_level > 0 THEN
290: oe_debug_pub.add('i:'||i);
291: oe_debug_pub.add('g_line_id_tbl(i):'||g_line_id_tbl(i));
292: oe_debug_pub.add('g_invoice_to_customer_tbl(i):'||g_invoice_to_customer_tbl(i));
293: oe_debug_pub.add('G_invoice_to_site_tbl(i):'||G_invoice_to_site_tbl(i));
294: oe_debug_pub.add('g_inventory_item_id_tbl(i):'||g_inventory_item_id_tbl(i));
295: oe_debug_pub.add('Customer Transaction type : ' || g_cust_trx_type_id_tbl(i) );
296: oe_debug_pub.add('Invoice Source : ' || g_batch_source_id_tbl(i) );
297: oe_debug_pub.add('org_id : ' || g_org_id_tbl(i) );

Line 294: oe_debug_pub.add('g_inventory_item_id_tbl(i):'||g_inventory_item_id_tbl(i));

290: oe_debug_pub.add('i:'||i);
291: oe_debug_pub.add('g_line_id_tbl(i):'||g_line_id_tbl(i));
292: oe_debug_pub.add('g_invoice_to_customer_tbl(i):'||g_invoice_to_customer_tbl(i));
293: oe_debug_pub.add('G_invoice_to_site_tbl(i):'||G_invoice_to_site_tbl(i));
294: oe_debug_pub.add('g_inventory_item_id_tbl(i):'||g_inventory_item_id_tbl(i));
295: oe_debug_pub.add('Customer Transaction type : ' || g_cust_trx_type_id_tbl(i) );
296: oe_debug_pub.add('Invoice Source : ' || g_batch_source_id_tbl(i) );
297: oe_debug_pub.add('org_id : ' || g_org_id_tbl(i) );
298: oe_debug_pub.add('accounting rule : ' || g_accounting_rule_id_tbl(i) );

Line 295: oe_debug_pub.add('Customer Transaction type : ' || g_cust_trx_type_id_tbl(i) );

291: oe_debug_pub.add('g_line_id_tbl(i):'||g_line_id_tbl(i));
292: oe_debug_pub.add('g_invoice_to_customer_tbl(i):'||g_invoice_to_customer_tbl(i));
293: oe_debug_pub.add('G_invoice_to_site_tbl(i):'||G_invoice_to_site_tbl(i));
294: oe_debug_pub.add('g_inventory_item_id_tbl(i):'||g_inventory_item_id_tbl(i));
295: oe_debug_pub.add('Customer Transaction type : ' || g_cust_trx_type_id_tbl(i) );
296: oe_debug_pub.add('Invoice Source : ' || g_batch_source_id_tbl(i) );
297: oe_debug_pub.add('org_id : ' || g_org_id_tbl(i) );
298: oe_debug_pub.add('accounting rule : ' || g_accounting_rule_id_tbl(i) );
299:

Line 296: oe_debug_pub.add('Invoice Source : ' || g_batch_source_id_tbl(i) );

292: oe_debug_pub.add('g_invoice_to_customer_tbl(i):'||g_invoice_to_customer_tbl(i));
293: oe_debug_pub.add('G_invoice_to_site_tbl(i):'||G_invoice_to_site_tbl(i));
294: oe_debug_pub.add('g_inventory_item_id_tbl(i):'||g_inventory_item_id_tbl(i));
295: oe_debug_pub.add('Customer Transaction type : ' || g_cust_trx_type_id_tbl(i) );
296: oe_debug_pub.add('Invoice Source : ' || g_batch_source_id_tbl(i) );
297: oe_debug_pub.add('org_id : ' || g_org_id_tbl(i) );
298: oe_debug_pub.add('accounting rule : ' || g_accounting_rule_id_tbl(i) );
299:
300: END IF;

Line 297: oe_debug_pub.add('org_id : ' || g_org_id_tbl(i) );

293: oe_debug_pub.add('G_invoice_to_site_tbl(i):'||G_invoice_to_site_tbl(i));
294: oe_debug_pub.add('g_inventory_item_id_tbl(i):'||g_inventory_item_id_tbl(i));
295: oe_debug_pub.add('Customer Transaction type : ' || g_cust_trx_type_id_tbl(i) );
296: oe_debug_pub.add('Invoice Source : ' || g_batch_source_id_tbl(i) );
297: oe_debug_pub.add('org_id : ' || g_org_id_tbl(i) );
298: oe_debug_pub.add('accounting rule : ' || g_accounting_rule_id_tbl(i) );
299:
300: END IF;
301:

Line 298: oe_debug_pub.add('accounting rule : ' || g_accounting_rule_id_tbl(i) );

294: oe_debug_pub.add('g_inventory_item_id_tbl(i):'||g_inventory_item_id_tbl(i));
295: oe_debug_pub.add('Customer Transaction type : ' || g_cust_trx_type_id_tbl(i) );
296: oe_debug_pub.add('Invoice Source : ' || g_batch_source_id_tbl(i) );
297: oe_debug_pub.add('org_id : ' || g_org_id_tbl(i) );
298: oe_debug_pub.add('accounting rule : ' || g_accounting_rule_id_tbl(i) );
299:
300: END IF;
301:
302: END IF;

Line 306: oe_debug_pub.add('Inserting records in AR_RDR_PARAMETERS_GT ' );

302: END IF;
303: END LOOP;
304:
305: IF l_debug_level > 0 THEN
306: oe_debug_pub.add('Inserting records in AR_RDR_PARAMETERS_GT ' );
307: oe_debug_pub.add('g_Line_id_tbl.count: ' ||g_Line_id_tbl.count);
308: END IF;
309:
310: --Populate global temporary table AR_RDR_PARAMETERS_GT

Line 307: oe_debug_pub.add('g_Line_id_tbl.count: ' ||g_Line_id_tbl.count);

303: END LOOP;
304:
305: IF l_debug_level > 0 THEN
306: oe_debug_pub.add('Inserting records in AR_RDR_PARAMETERS_GT ' );
307: oe_debug_pub.add('g_Line_id_tbl.count: ' ||g_Line_id_tbl.count);
308: END IF;
309:
310: --Populate global temporary table AR_RDR_PARAMETERS_GT
311: -- FORALL i in g_line_id_tbl.FIRST..g_line_id_tbl.LAST

Line 348: oe_debug_pub.add('done inserting records' );

344: FROM dual
345: WHERE g_line_id_tbl(i) <> -99;
346:
347: IF l_debug_level > 0 THEN
348: oe_debug_pub.add('done inserting records' );
349: END IF;
350:
351: l_inserted_lines := SQL%ROWCOUNT;
352: IF l_debug_level > 0 THEN

Line 353: oe_debug_pub.add( 'INSERTED '||l_inserted_lines||' records' , 3 ) ;

349: END IF;
350:
351: l_inserted_lines := SQL%ROWCOUNT;
352: IF l_debug_level > 0 THEN
353: oe_debug_pub.add( 'INSERTED '||l_inserted_lines||' records' , 3 ) ;
354: END IF;
355:
356: IF l_inserted_lines > 0 THEN
357: --Call AR API

Line 359: oe_debug_pub.add('Entering AR_DEFERRAL_REASONS_GRP.default_reasons ' );

355:
356: IF l_inserted_lines > 0 THEN
357: --Call AR API
358: IF l_debug_level > 0 THEN
359: oe_debug_pub.add('Entering AR_DEFERRAL_REASONS_GRP.default_reasons ' );
360: END IF;
361: ar_deferral_reasons_grp.default_reasons (
362: p_api_version => 1.0,
363: p_mode => 'OM',

Line 369: oe_debug_pub.add('Exiting AR_DEFERRAL_REASONS_GRP.default_reasons ' );

365: x_msg_count => l_msg_count,
366: x_msg_data => l_msg_data);
367:
368: IF l_debug_level > 0 THEN
369: oe_debug_pub.add('Exiting AR_DEFERRAL_REASONS_GRP.default_reasons ' );
370: END IF;
371:
372: --join fun_rule_bulk_result_gt with ar_deferral_reasons to get all the AR attributes
373: --pick one pre-billing or post-billing contingency

Line 383: oe_debug_pub.add('Records returned by AR');

379: l_line_id_old := 0;
380: l_line_id_new := 0;
381:
382: IF l_debug_level > 0 THEN -- for debugging purpose
383: oe_debug_pub.add('Records returned by AR');
384: FOR default_contingencies_rec IN default_contingencies LOOP
385: oe_debug_pub.add('id:'||default_contingencies_rec.id);
386: oe_debug_pub.add('contingency_id:'||default_contingencies_rec.contingency_id);
387: oe_debug_pub.add('revrec_event_code:'||default_contingencies_rec.revrec_event_code);

Line 385: oe_debug_pub.add('id:'||default_contingencies_rec.id);

381:
382: IF l_debug_level > 0 THEN -- for debugging purpose
383: oe_debug_pub.add('Records returned by AR');
384: FOR default_contingencies_rec IN default_contingencies LOOP
385: oe_debug_pub.add('id:'||default_contingencies_rec.id);
386: oe_debug_pub.add('contingency_id:'||default_contingencies_rec.contingency_id);
387: oe_debug_pub.add('revrec_event_code:'||default_contingencies_rec.revrec_event_code);
388: oe_debug_pub.add('revrec_expiration_days:'||default_contingencies_rec.expiration_days);
389: END LOOP;

Line 386: oe_debug_pub.add('contingency_id:'||default_contingencies_rec.contingency_id);

382: IF l_debug_level > 0 THEN -- for debugging purpose
383: oe_debug_pub.add('Records returned by AR');
384: FOR default_contingencies_rec IN default_contingencies LOOP
385: oe_debug_pub.add('id:'||default_contingencies_rec.id);
386: oe_debug_pub.add('contingency_id:'||default_contingencies_rec.contingency_id);
387: oe_debug_pub.add('revrec_event_code:'||default_contingencies_rec.revrec_event_code);
388: oe_debug_pub.add('revrec_expiration_days:'||default_contingencies_rec.expiration_days);
389: END LOOP;
390: END IF;

Line 387: oe_debug_pub.add('revrec_event_code:'||default_contingencies_rec.revrec_event_code);

383: oe_debug_pub.add('Records returned by AR');
384: FOR default_contingencies_rec IN default_contingencies LOOP
385: oe_debug_pub.add('id:'||default_contingencies_rec.id);
386: oe_debug_pub.add('contingency_id:'||default_contingencies_rec.contingency_id);
387: oe_debug_pub.add('revrec_event_code:'||default_contingencies_rec.revrec_event_code);
388: oe_debug_pub.add('revrec_expiration_days:'||default_contingencies_rec.expiration_days);
389: END LOOP;
390: END IF;
391:

Line 388: oe_debug_pub.add('revrec_expiration_days:'||default_contingencies_rec.expiration_days);

384: FOR default_contingencies_rec IN default_contingencies LOOP
385: oe_debug_pub.add('id:'||default_contingencies_rec.id);
386: oe_debug_pub.add('contingency_id:'||default_contingencies_rec.contingency_id);
387: oe_debug_pub.add('revrec_event_code:'||default_contingencies_rec.revrec_event_code);
388: oe_debug_pub.add('revrec_expiration_days:'||default_contingencies_rec.expiration_days);
389: END LOOP;
390: END IF;
391:
392:

Line 398: oe_debug_pub.add('Updating records in OE_ORDER_LINES_ALL ' );

394: l_line_id_new := default_contingencies_rec.id;
395:
396: IF l_line_id_new <> l_line_id_old THEN
397: IF l_debug_level > 0 THEN
398: oe_debug_pub.add('Updating records in OE_ORDER_LINES_ALL ' );
399: END IF;
400: UPDATE OE_ORDER_LINES_ALL
401: SET contingency_id = default_contingencies_rec.contingency_id,
402: revrec_event_code = default_contingencies_rec.revrec_event_code,

Line 413: oe_debug_pub.add('Deleting the changed lines table once the lines are processed ' );

409: END LOOP;
410: END IF;
411:
412: IF l_debug_level > 0 THEN
413: oe_debug_pub.add('Deleting the changed lines table once the lines are processed ' );
414: END IF;
415:
416: Delete_Changed_Lines_Tbl;
417:

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

431: l_order_line_id NUMBER;
432: l_return_status VARCHAR2(1);
433: l_service_reference_line_id NUMBER;
434: --
435: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
436: --
437: l_accepted_quantity NUMBER;
438: l_revrec_signature VARCHAR2(240);
439: l_revrec_signature_date DATE;

Line 449: oe_debug_pub.add( 'ENTERING OE_ACCEPTANCE_UTIL.Default_Parent_Accept_Details' ) ;

445: l_item_type_code VARCHAR2(30);
446:
447: BEGIN
448: IF l_debug_level > 0 THEN
449: oe_debug_pub.add( 'ENTERING OE_ACCEPTANCE_UTIL.Default_Parent_Accept_Details' ) ;
450: END IF;
451: IF p_line_rec.item_type_code = 'SERVICE' THEN
452: IF p_line_rec.service_reference_type_code = 'CUSTOMER_PRODUCT' AND
453: p_line_rec.service_reference_line_id IS NOT NULL THEN

Line 455: oe_debug_pub.add( 'LINE IS A CUSTOMER PRODUCT' ) ;

451: IF p_line_rec.item_type_code = 'SERVICE' THEN
452: IF p_line_rec.service_reference_type_code = 'CUSTOMER_PRODUCT' AND
453: p_line_rec.service_reference_line_id IS NOT NULL THEN
454: IF l_debug_level > 0 THEN
455: oe_debug_pub.add( 'LINE IS A CUSTOMER PRODUCT' ) ;
456: END IF;
457: OE_SERVICE_UTIL.Get_Cust_Product_Line_Id
458: ( x_return_status => l_return_status
459: , p_reference_line_id => p_line_rec.service_reference_line_id

Line 465: oe_debug_pub.add( 'SERVICE LINE ID IS ' || L_ORDER_LINE_ID ) ;

461: , x_cust_product_line_id => l_order_line_id
462: );
463: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
464: IF l_debug_level > 0 THEN
465: oe_debug_pub.add( 'SERVICE LINE ID IS ' || L_ORDER_LINE_ID ) ;
466: END IF;
467: l_service_reference_line_id := l_order_line_id;
468: ELSE
469: IF l_debug_level > 0 THEN

Line 470: oe_debug_pub.add( 'NOT ABLE TO RETRIEVE CUST PRODUCT LINE ID' ) ;

466: END IF;
467: l_service_reference_line_id := l_order_line_id;
468: ELSE
469: IF l_debug_level > 0 THEN
470: oe_debug_pub.add( 'NOT ABLE TO RETRIEVE CUST PRODUCT LINE ID' ) ;
471: END IF;
472: FND_MESSAGE.SET_NAME('ONT','ONT_NO_CUST_PROD_LINE');
473: OE_MSG_PUB.ADD;
474: --RAISE NO_DATA_FOUND;

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

572: l_item_type_code VARCHAR2(30);
573: l_order_line_id NUMBER;
574: l_top_model_line_id NUMBER;
575: --
576: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
577: --
578: BEGIN
579: x_contingency_id := NULL;
580: x_revrec_event_code := NULL;

Line 586: oe_debug_pub.add( 'Return Line, Return ' );

582:
583: IF p_line_rec.item_type_code = 'RETURN' THEN
584:
585: IF l_debug_level > 0 THEN
586: oe_debug_pub.add( 'Return Line, Return ' );
587: END IF;
588: RETURN;
589:
590: ELSIF p_line_rec.source_document_type_id = 10 THEN

Line 593: oe_debug_pub.add( 'Internal Order Line, Return');

589:
590: ELSIF p_line_rec.source_document_type_id = 10 THEN
591:
592: IF l_debug_level > 0 THEN
593: oe_debug_pub.add( 'Internal Order Line, Return');
594: END IF;
595: RETURN;
596:
597: ELSIF p_line_rec.order_source_id=27 AND p_line_rec.retrobill_request_id IS NOT NULL THEN

Line 600: oe_debug_pub.add( 'Retrobill Line, Return ' );

596:
597: ELSIF p_line_rec.order_source_id=27 AND p_line_rec.retrobill_request_id IS NOT NULL THEN
598:
599: IF l_debug_level > 0 THEN
600: oe_debug_pub.add( 'Retrobill Line, Return ' );
601: END IF;
602: RETURN;
603:
604: ELSIF p_line_rec.item_type_code IN ('CONFIG','CLASS','OPTION','INCLUDED')

Line 608: oe_debug_pub.add('Item_type_code:'||p_line_rec.item_type_code||' Get from parent:'||p_line_rec.top_model_line_id );

604: ELSIF p_line_rec.item_type_code IN ('CONFIG','CLASS','OPTION','INCLUDED')
605: OR (p_line_rec.item_type_code = 'KIT' and p_line_rec.top_model_line_id <> p_line_rec.line_id) THEN
606:
607: IF l_debug_level > 0 THEN
608: oe_debug_pub.add('Item_type_code:'||p_line_rec.item_type_code||' Get from parent:'||p_line_rec.top_model_line_id );
609: END IF;
610: IF p_line_rec.top_model_line_id IS NOT NULL THEN
611: SELECT contingency_id, revrec_event_code, revrec_expiration_days
612: INTO x_contingency_id, x_revrec_event_code,x_revrec_expiration_days

Line 618: oe_debug_pub.add( 'Item_type_code:'||p_line_rec.item_type_code||' - Get from service parent' );

614: WHERE line_id = p_line_rec.top_model_line_id;
615: END IF;
616: ELSIF p_line_rec.item_type_code = 'SERVICE' THEN
617: IF l_debug_level > 0 THEN
618: oe_debug_pub.add( 'Item_type_code:'||p_line_rec.item_type_code||' - Get from service parent' );
619: END IF;
620: IF p_line_rec.service_reference_type_code = 'CUSTOMER_PRODUCT' AND
621: p_line_rec.service_reference_line_id IS NOT NULL THEN
622: IF l_debug_level > 0 THEN

Line 623: oe_debug_pub.add( 'LINE IS A CUSTOMER PRODUCT' ) ;

619: END IF;
620: IF p_line_rec.service_reference_type_code = 'CUSTOMER_PRODUCT' AND
621: p_line_rec.service_reference_line_id IS NOT NULL THEN
622: IF l_debug_level > 0 THEN
623: oe_debug_pub.add( 'LINE IS A CUSTOMER PRODUCT' ) ;
624: END IF;
625: OE_SERVICE_UTIL.Get_Cust_Product_Line_Id
626: ( x_return_status => l_return_status
627: , p_reference_line_id => p_line_rec.service_reference_line_id

Line 633: oe_debug_pub.add( 'SERVICE LINE ID IS ' || L_ORDER_LINE_ID ) ;

629: , x_cust_product_line_id => l_order_line_id
630: );
631: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
632: IF l_debug_level > 0 THEN
633: oe_debug_pub.add( 'SERVICE LINE ID IS ' || L_ORDER_LINE_ID ) ;
634: END IF;
635: l_service_reference_line_id := l_order_line_id;
636: ELSE
637: IF l_debug_level > 0 THEN

Line 638: oe_debug_pub.add( 'NOT ABLE TO RETRIEVE CUST PRODUCT LINE ID' ) ;

634: END IF;
635: l_service_reference_line_id := l_order_line_id;
636: ELSE
637: IF l_debug_level > 0 THEN
638: oe_debug_pub.add( 'NOT ABLE TO RETRIEVE CUST PRODUCT LINE ID' ) ;
639: END IF;
640: FND_MESSAGE.SET_NAME('ONT','ONT_NO_CUST_PROD_LINE');
641: OE_MSG_PUB.ADD;
642: RAISE NO_DATA_FOUND;

Line 667: oe_debug_pub.add( 'Item_type_code:'||p_line_rec.item_type_code||' top_model_line_id:'||p_line_rec.top_model_line_id );

663: END IF;
664: END IF;
665: ELSE -- standard line or top model
666: IF l_debug_level > 0 THEN
667: oe_debug_pub.add( 'Item_type_code:'||p_line_rec.item_type_code||' top_model_line_id:'||p_line_rec.top_model_line_id );
668: END IF;
669: x_contingency_id := p_line_rec.contingency_id;
670: x_revrec_event_code := p_line_rec.revrec_event_code;
671: x_revrec_expiration_days:= p_line_rec.revrec_expiration_days;

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

693: l_top_model_line_id NUMBER;
694: l_contingency_id NUMBER;
695: l_revrec_event_code VARCHAR2(30);
696: --
697: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
698: --
699: BEGIN
700:
701: IF p_line_rec.line_category_code = 'RETURN' THEN

Line 704: oe_debug_pub.add( 'Return Line, Return FALSE' );

700:
701: IF p_line_rec.line_category_code = 'RETURN' THEN
702:
703: IF l_debug_level > 0 THEN
704: oe_debug_pub.add( 'Return Line, Return FALSE' );
705: END IF;
706: RETURN FALSE;
707:
708: ELSIF p_line_rec.source_document_type_id = 10 THEN

Line 711: oe_debug_pub.add( 'Internal Order Line, Return FALSE' );

707:
708: ELSIF p_line_rec.source_document_type_id = 10 THEN
709:
710: IF l_debug_level > 0 THEN
711: oe_debug_pub.add( 'Internal Order Line, Return FALSE' );
712: END IF;
713: RETURN FALSE;
714:
715: ELSIF p_line_rec.order_source_id = 27 AND p_line_rec.retrobill_request_id IS NOT NULL THEN

Line 718: oe_debug_pub.add( 'Retrobill Line, Return FALSE' );

714:
715: ELSIF p_line_rec.order_source_id = 27 AND p_line_rec.retrobill_request_id IS NOT NULL THEN
716:
717: IF l_debug_level > 0 THEN
718: oe_debug_pub.add( 'Retrobill Line, Return FALSE' );
719: END IF;
720: RETURN FALSE;
721:
722: ELSIF p_line_rec.item_type_code IN ('CONFIG', 'CLASS', 'OPTION', 'INCLUDED')

Line 726: oe_debug_pub.add( 'Item_type_code:'||p_line_rec.item_type_code||' - Get from parent:'||p_line_rec.top_model_line_id );

722: ELSIF p_line_rec.item_type_code IN ('CONFIG', 'CLASS', 'OPTION', 'INCLUDED')
723: OR (p_line_rec.item_type_code = 'KIT' and p_line_rec.top_model_line_id <> p_line_rec.line_id) THEN
724:
725: IF l_debug_level > 0 THEN
726: oe_debug_pub.add( 'Item_type_code:'||p_line_rec.item_type_code||' - Get from parent:'||p_line_rec.top_model_line_id );
727: END IF;
728: IF p_line_rec.top_model_line_id IS NOT NULL THEN
729: SELECT contingency_id, revrec_event_code
730: INTO l_contingency_id, l_revrec_event_code

Line 742: oe_debug_pub.add( 'Item_type_code:'||p_line_rec.item_type_code||' - Get from service parent' );

738: RETURN FALSE;
739: END IF;
740: ELSIF p_line_rec.item_type_code = 'SERVICE' THEN
741: IF l_debug_level > 0 THEN
742: oe_debug_pub.add( 'Item_type_code:'||p_line_rec.item_type_code||' - Get from service parent' );
743: END IF;
744: IF p_line_rec.service_reference_type_code='CUSTOMER_PRODUCT' AND
745: p_line_rec.service_reference_line_id IS NOT NULL THEN
746: IF l_debug_level > 0 THEN

Line 747: oe_debug_pub.add( 'LINE IS A CUSTOMER PRODUCT' ) ;

743: END IF;
744: IF p_line_rec.service_reference_type_code='CUSTOMER_PRODUCT' AND
745: p_line_rec.service_reference_line_id IS NOT NULL THEN
746: IF l_debug_level > 0 THEN
747: oe_debug_pub.add( 'LINE IS A CUSTOMER PRODUCT' ) ;
748: END IF;
749: OE_SERVICE_UTIL.Get_Cust_Product_Line_Id
750: ( x_return_status => l_return_status
751: , p_reference_line_id => p_line_rec.service_reference_line_id

Line 757: oe_debug_pub.add( 'SERVICE LINE ID IS ' || L_ORDER_LINE_ID ) ;

753: , x_cust_product_line_id => l_order_line_id
754: );
755: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
756: IF l_debug_level > 0 THEN
757: oe_debug_pub.add( 'SERVICE LINE ID IS ' || L_ORDER_LINE_ID ) ;
758: END IF;
759: l_service_reference_line_id := l_order_line_id;
760: ELSE
761: IF l_debug_level > 0 THEN

Line 762: oe_debug_pub.add( 'NOT ABLE TO RETRIEVE CUST PRODUCT LINE ID' ) ;

758: END IF;
759: l_service_reference_line_id := l_order_line_id;
760: ELSE
761: IF l_debug_level > 0 THEN
762: oe_debug_pub.add( 'NOT ABLE TO RETRIEVE CUST PRODUCT LINE ID' ) ;
763: END IF;
764: FND_MESSAGE.SET_NAME('ONT','ONT_NO_CUST_PROD_LINE');
765: OE_MSG_PUB.ADD;
766: --RAISE NO_DATA_FOUND;

Line 801: oe_debug_pub.add( 'Item_type_code:'||p_line_rec.item_type_code||' top_model_line_id:'||p_line_rec.top_model_line_id );

797: RETURN FALSE;
798: END IF;
799: ELSE -- standard line or top model
800: IF l_debug_level > 0 THEN
801: oe_debug_pub.add( 'Item_type_code:'||p_line_rec.item_type_code||' top_model_line_id:'||p_line_rec.top_model_line_id );
802: END IF;
803: IF p_line_rec.contingency_id IS NOT NULL AND p_line_rec.revrec_event_code='INVOICING' THEN
804: RETURN TRUE;
805: ELSE

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

822: --Overloaded to accept line_id as parameter
823: FUNCTION Pre_billing_acceptance_on (p_line_id IN NUMBER) RETURN BOOLEAN
824: IS
825: l_line_rec OE_ORDER_PUB.line_rec_type;
826: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
827: BEGIN
828:
829: OE_Line_Util.Query_Row(p_line_id => p_line_id,x_line_rec => l_line_rec);
830: RETURN Pre_billing_acceptance_on (p_line_rec => l_line_rec);

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

846: l_top_model_line_id NUMBER;
847: l_contingency_id NUMBER;
848: l_revrec_event_code VARCHAR2(30);
849: --
850: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
851: --
852: BEGIN
853:
854: IF p_line_rec.line_category_code = 'RETURN' THEN

Line 857: oe_debug_pub.add( 'Return Line, Return FALSE' );

853:
854: IF p_line_rec.line_category_code = 'RETURN' THEN
855:
856: IF l_debug_level > 0 THEN
857: oe_debug_pub.add( 'Return Line, Return FALSE' );
858: END IF;
859: RETURN FALSE;
860:
861: ELSIF p_line_rec.source_document_type_id = 10 THEN

Line 864: oe_debug_pub.add( 'Internal Order Line, Return FALSE' );

860:
861: ELSIF p_line_rec.source_document_type_id = 10 THEN
862:
863: IF l_debug_level > 0 THEN
864: oe_debug_pub.add( 'Internal Order Line, Return FALSE' );
865: END IF;
866: RETURN FALSE;
867:
868: ELSIF p_line_rec.order_source_id = 27 AND p_line_rec.retrobill_request_id IS NOT NULL THEN

Line 871: oe_debug_pub.add( 'Retrobill Line, Return FALSE' );

867:
868: ELSIF p_line_rec.order_source_id = 27 AND p_line_rec.retrobill_request_id IS NOT NULL THEN
869:
870: IF l_debug_level > 0 THEN
871: oe_debug_pub.add( 'Retrobill Line, Return FALSE' );
872: END IF;
873: RETURN FALSE;
874:
875: ELSIF p_line_rec.item_type_code IN ('CONFIG', 'CLASS', 'OPTION', 'INCLUDED')

Line 879: oe_debug_pub.add( 'Item_type_code:'||p_line_rec.item_type_code||' - Get from parent:'||p_line_rec.top_model_line_id );

875: ELSIF p_line_rec.item_type_code IN ('CONFIG', 'CLASS', 'OPTION', 'INCLUDED')
876: OR (p_line_rec.item_type_code = 'KIT' and p_line_rec.top_model_line_id <> p_line_rec.line_id) THEN
877:
878: IF l_debug_level > 0 THEN
879: oe_debug_pub.add( 'Item_type_code:'||p_line_rec.item_type_code||' - Get from parent:'||p_line_rec.top_model_line_id );
880: END IF;
881: IF p_line_rec.top_model_line_id IS NOT NULL THEN
882: SELECT contingency_id, revrec_event_code
883: INTO l_contingency_id, l_revrec_event_code

Line 895: oe_debug_pub.add( 'Item_type_code:'||p_line_rec.item_type_code||' - Get from service parent' );

891: RETURN FALSE;
892: END IF;
893: ELSIF p_line_rec.item_type_code = 'SERVICE' THEN
894: IF l_debug_level > 0 THEN
895: oe_debug_pub.add( 'Item_type_code:'||p_line_rec.item_type_code||' - Get from service parent' );
896: END IF;
897: IF p_line_rec.service_reference_type_code='CUSTOMER_PRODUCT' AND
898: p_line_rec.service_reference_line_id IS NOT NULL THEN
899: IF l_debug_level > 0 THEN

Line 900: oe_debug_pub.add( 'LINE IS A CUSTOMER PRODUCT' ) ;

896: END IF;
897: IF p_line_rec.service_reference_type_code='CUSTOMER_PRODUCT' AND
898: p_line_rec.service_reference_line_id IS NOT NULL THEN
899: IF l_debug_level > 0 THEN
900: oe_debug_pub.add( 'LINE IS A CUSTOMER PRODUCT' ) ;
901: END IF;
902: OE_SERVICE_UTIL.Get_Cust_Product_Line_Id
903: ( x_return_status => l_return_status
904: , p_reference_line_id => p_line_rec.service_reference_line_id

Line 910: oe_debug_pub.add( 'SERVICE LINE ID IS ' || L_ORDER_LINE_ID ) ;

906: , x_cust_product_line_id => l_order_line_id
907: );
908: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
909: IF l_debug_level > 0 THEN
910: oe_debug_pub.add( 'SERVICE LINE ID IS ' || L_ORDER_LINE_ID ) ;
911: END IF;
912: l_service_reference_line_id := l_order_line_id;
913: ELSE
914: IF l_debug_level > 0 THEN

Line 915: oe_debug_pub.add( 'NOT ABLE TO RETRIEVE CUST PRODUCT LINE ID' ) ;

911: END IF;
912: l_service_reference_line_id := l_order_line_id;
913: ELSE
914: IF l_debug_level > 0 THEN
915: oe_debug_pub.add( 'NOT ABLE TO RETRIEVE CUST PRODUCT LINE ID' ) ;
916: END IF;
917: FND_MESSAGE.SET_NAME('ONT','ONT_NO_CUST_PROD_LINE');
918: OE_MSG_PUB.ADD;
919: --RAISE NO_DATA_FOUND;

Line 954: oe_debug_pub.add( 'Item_type_code:'||p_line_rec.item_type_code||' top_model_line_id:'||p_line_rec.top_model_line_id );

950: RETURN FALSE;
951: END IF;
952: ELSE -- standard line or top model
953: IF l_debug_level > 0 THEN
954: oe_debug_pub.add( 'Item_type_code:'||p_line_rec.item_type_code||' top_model_line_id:'||p_line_rec.top_model_line_id );
955: END IF;
956: IF p_line_rec.contingency_id IS NOT NULL AND p_line_rec.revrec_event_code='CUSTOMER_ACCEPTANCE' THEN
957: RETURN TRUE;
958: ELSE

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

975: FUNCTION Post_billing_acceptance_on (p_line_id IN NUMBER) RETURN BOOLEAN
976: IS
977: l_line_rec OE_ORDER_PUB.line_rec_type;
978: --
979: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
980: --
981: BEGIN
982: OE_Line_Util.Query_Row(p_line_id => p_line_id,
983: x_line_rec => l_line_rec);

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

994:
995: FUNCTION Customer_acceptance_Eligible (p_line_rec IN OE_Order_PUB.Line_Rec_Type) RETURN BOOLEAN IS
996: l_count NUMBER := 0;
997: --
998: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
999: --
1000: BEGIN
1001: IF p_line_rec.line_category_code = 'RETURN' THEN
1002:

Line 1004: oe_debug_pub.add( 'Return Line, Return FALSE' );

1000: BEGIN
1001: IF p_line_rec.line_category_code = 'RETURN' THEN
1002:
1003: IF l_debug_level > 0 THEN
1004: oe_debug_pub.add( 'Return Line, Return FALSE' );
1005: END IF;
1006: RETURN FALSE;
1007:
1008: ELSIF p_line_rec.source_document_type_id = 10 THEN

Line 1011: oe_debug_pub.add( 'Internal Order Line, Return FALSE' );

1007:
1008: ELSIF p_line_rec.source_document_type_id = 10 THEN
1009:
1010: IF l_debug_level > 0 THEN
1011: oe_debug_pub.add( 'Internal Order Line, Return FALSE' );
1012: END IF;
1013: RETURN FALSE;
1014:
1015: ELSIF p_line_rec.order_source_id = 27 AND p_line_rec.retrobill_request_id IS NOT NULL THEN

Line 1018: oe_debug_pub.add( 'Retrobill Line, Return FALSE' );

1014:
1015: ELSIF p_line_rec.order_source_id = 27 AND p_line_rec.retrobill_request_id IS NOT NULL THEN
1016:
1017: IF l_debug_level > 0 THEN
1018: oe_debug_pub.add( 'Retrobill Line, Return FALSE' );
1019: END IF;
1020: RETURN FALSE;
1021: ELSIF p_line_rec.item_type_code IN ('CONFIG', 'CLASS', 'OPTION', 'INCLUDED')
1022: OR (p_line_rec.item_type_code = 'KIT' and p_line_rec.top_model_line_id <> p_line_rec.line_id) THEN --child line

Line 1025: oe_debug_pub.add( 'Item_type_code:'||p_line_rec.item_type_code);

1021: ELSIF p_line_rec.item_type_code IN ('CONFIG', 'CLASS', 'OPTION', 'INCLUDED')
1022: OR (p_line_rec.item_type_code = 'KIT' and p_line_rec.top_model_line_id <> p_line_rec.line_id) THEN --child line
1023:
1024: IF l_debug_level > 0 THEN
1025: oe_debug_pub.add( 'Item_type_code:'||p_line_rec.item_type_code);
1026: END IF;
1027: RETURN FALSE;
1028: ELSIF p_line_rec.item_type_code = 'SERVICE' THEN
1029: IF l_debug_level > 0 THEN

Line 1030: oe_debug_pub.add( 'Item_type_code:'||p_line_rec.item_type_code||' - Get from service parent' );

1026: END IF;
1027: RETURN FALSE;
1028: ELSIF p_line_rec.item_type_code = 'SERVICE' THEN
1029: IF l_debug_level > 0 THEN
1030: oe_debug_pub.add( 'Item_type_code:'||p_line_rec.item_type_code||' - Get from service parent' );
1031: END IF;
1032: IF p_line_rec.service_reference_type_code='ORDER' THEN
1033: IF l_debug_level > 0 THEN
1034: oe_debug_pub.add( 'LINE is a service with reference type ORDER' ) ;

Line 1034: oe_debug_pub.add( 'LINE is a service with reference type ORDER' ) ;

1030: oe_debug_pub.add( 'Item_type_code:'||p_line_rec.item_type_code||' - Get from service parent' );
1031: END IF;
1032: IF p_line_rec.service_reference_type_code='ORDER' THEN
1033: IF l_debug_level > 0 THEN
1034: oe_debug_pub.add( 'LINE is a service with reference type ORDER' ) ;
1035: END IF;
1036: RETURN FALSE;
1037: -- Acceptance of customer product services should not be allowed through UI.
1038: -- But explicit acceptance should be allowed

Line 1048: oe_debug_pub.add( 'Item_type_code:'||p_line_rec.item_type_code||' top_model_line_id'|| p_line_rec.top_model_line_id);

1044: END IF;
1045: END IF;
1046: ELSE -- Now it could be a model, kit or standard line
1047: IF l_debug_level > 0 THEN
1048: oe_debug_pub.add( 'Item_type_code:'||p_line_rec.item_type_code||' top_model_line_id'|| p_line_rec.top_model_line_id);
1049: END IF;
1050: IF p_line_rec.top_model_line_id IS NOT NULL AND p_line_rec.top_model_line_id = p_line_rec.line_id THEN
1051: IF p_line_rec.flow_status_code NOT IN ('PRE-BILLING_ACCEPTANCE', 'POST-BILLING_ACCEPTANCE') THEN
1052: RETURN FALSE;

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

1089: --Overloaded to accept line_id as parameter
1090: FUNCTION Customer_Acceptance_Eligible (p_line_id IN NUMBER) RETURN BOOLEAN IS
1091: l_line_rec OE_ORDER_PUB.line_rec_type;
1092: --
1093: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1094: --
1095: BEGIN
1096: OE_Line_Util.Query_Row(p_line_id => p_line_id,
1097: x_line_rec => l_line_rec);

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

1108: END Customer_Acceptance_Eligible;
1109:
1110: FUNCTION Acceptance_Status(p_line_rec IN OE_Order_PUB.Line_Rec_Type) RETURN VARCHAR2 IS
1111: --
1112: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1113: --
1114: BEGIN
1115:
1116: IF p_line_rec.accepted_quantity IS NULL OR p_line_rec.accepted_quantity = FND_API.G_MISS_NUM THEN

Line 1121: oe_debug_pub.add('returning as accepted because line '||p_line_rec.line_id||' is already closed');

1117: -- consider closed lines as accepted because parent line might have been closed
1118: -- without acceptance (ex: from progress order when system param turned off)
1119: IF nvl(p_line_rec.open_flag, 'Y') = 'N' THEN
1120: IF l_debug_level > 0 THEN
1121: oe_debug_pub.add('returning as accepted because line '||p_line_rec.line_id||' is already closed');
1122: END IF;
1123: RETURN 'ACCEPTED';
1124: ELSE
1125: RETURN 'NOT_ACCEPTED';

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

1137: FUNCTION Acceptance_Status(p_line_id IN NUMBER) RETURN VARCHAR2 IS
1138: l_accepted_quantity NUMBER;
1139: l_open_flag VARCHAR2(1);
1140: --
1141: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1142: --
1143: BEGIN
1144: SELECT accepted_quantity, open_flag
1145: INTO l_accepted_quantity, l_open_flag

Line 1154: oe_debug_pub.add('returning as accepted because line '||p_line_id||' is already closed');

1150: -- consider closed lines as accepted because parent line might have been closed
1151: -- without acceptance (ex: from progress order when system param turned off)
1152: IF nvl(l_open_flag, 'Y') = 'N' THEN
1153: IF l_debug_level > 0 THEN
1154: oe_debug_pub.add('returning as accepted because line '||p_line_id||' is already closed');
1155: END IF;
1156: RETURN 'ACCEPTED';
1157: ELSE
1158: RETURN 'NOT_ACCEPTED';