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 25: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

21: , p_operation IN VARCHAR2 ) IS
22:
23: l_line_index NUMBER := 0;
24:
25: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
26:
27: BEGIN
28: IF l_debug_level > 0 THEN
29: oe_debug_pub.add('Entering OE_ACCEPTANCE_UTIL.Register_Changed_Lines ' );

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

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

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

29: oe_debug_pub.add('Entering OE_ACCEPTANCE_UTIL.Register_Changed_Lines ' );
30: END IF;
31:
32: IF l_debug_level > 0 THEN
33: oe_debug_pub.add('Operation value is ' || p_operation );
34: END IF;
35:
36: IF p_operation In (OE_GLOBALS.G_OPR_CREATE, OE_GLOBALS.G_OPR_UPDATE) THEN
37: IF G_line_index_Tbl.exists(p_line_id) THEN

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

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

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

58: ELSIF p_operation = OE_GLOBALS.G_OPR_DELETE THEN
59:
60: IF G_line_index_tbl.exists(p_line_id) THEN
61: IF l_debug_level > 0 THEN
62: oe_debug_pub.add('Line Index value is ' || l_line_index );
63: END IF;
64: G_Line_id_tbl(G_line_index_tbl(p_line_id).line_index) := -99;
65: G_line_index_tbl.delete(p_line_id);
66: END IF;

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

67:
68: END IF;
69:
70: IF l_debug_level > 0 THEN
71: oe_debug_pub.add('Exiting OE_ACCEPTANCE_UTIL.Register_Changed_Lines ' );
72: END IF;
73:
74: END Register_Changed_Lines;
75:

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

95: FUNCTION Get_batch_source_ID
96: (p_batch_source_name VARCHAR2)
97: RETURN NUMBER IS
98:
99: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
100:
101: BEGIN
102: IF l_debug_level > 0 THEN
103: oe_debug_pub.add('Entering OE_ACCEPTANCE_UTIL.Get_batch_source_ID ' );

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

99: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
100:
101: BEGIN
102: IF l_debug_level > 0 THEN
103: oe_debug_pub.add('Entering OE_ACCEPTANCE_UTIL.Get_batch_source_ID ' );
104: END IF;
105:
106: IF l_debug_level > 0 THEN
107: oe_debug_pub.add('IN Batch source name is ' || p_batch_source_name );

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

103: oe_debug_pub.add('Entering OE_ACCEPTANCE_UTIL.Get_batch_source_ID ' );
104: END IF;
105:
106: IF l_debug_level > 0 THEN
107: oe_debug_pub.add('IN Batch source name is ' || p_batch_source_name );
108: END IF;
109:
110: IF p_batch_source_name IS NOT NULL THEN
111: IF g_batch_source_name = FND_API.G_MISS_CHAR OR

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

120:
121: END IF;
122:
123: IF l_debug_level > 0 THEN
124: oe_debug_pub.add('OUT Batch source name: ' || g_batch_source_name||' :batch_source_id:'||g_batch_source_id );
125: END IF;
126:
127: RETURN g_batch_source_id;
128: ELSE

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

129: RETURN -99;
130: END IF;
131:
132: IF l_debug_level > 0 THEN
133: oe_debug_pub.add('Exiting OE_ACCEPTANCE_UTIL.Get_batch_source_ID ' );
134: END IF;
135:
136: EXCEPTION
137: WHEN NO_DATA_FOUND THEN

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

139: END get_batch_source_ID;
140:
141: PROCEDURE Default_Contingency_Attributes IS
142:
143: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
144:
145: l_return_status VARCHAR2(1);
146: l_msg_count NUMBER;
147: l_msg_data VARCHAR2(2000);

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

171: ORDER BY id, revrec_event_code DESC, expiration_days, creation_date DESC;
172:
173: BEGIN
174: IF l_debug_level > 0 THEN
175: oe_debug_pub.add('Entering OE_ACCEPTANCE_UTIL.Default_Contingency_Attributes ' );
176: END IF;
177:
178: FOR i in 1..g_Line_id_tbl.count LOOP
179:

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

178: FOR i in 1..g_Line_id_tbl.count LOOP
179:
180: IF g_line_id_tbl(i) = -99 THEN
181: IF l_debug_level > 0 THEN
182: oe_debug_pub.add('Setting remaining attributes as -99');
183: END IF;
184: g_invoice_to_customer_tbl(i) := -99;
185: g_invoice_to_site_tbl(i) := -99;
186: g_cust_trx_type_id_tbl(i) := -99;

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

215: l_invoice_source_id := l_line_type_rec.invoice_source_id;
216: l_non_d_invoice_source_id := l_line_type_rec.non_delivery_invoice_source_id;
217:
218: IF l_debug_level > 0 THEN
219: oe_debug_pub.add('Line type details... ' );
220: oe_debug_pub.add('Customer Transaction type : ' || l_cust_trx_type_id );
221: oe_debug_pub.add('Invoice Source : ' || l_invoice_source_id );
222: oe_debug_pub.add('Non Delivery Invoice Source : ' || l_non_d_invoice_source_id );
223: END IF;

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

216: l_non_d_invoice_source_id := l_line_type_rec.non_delivery_invoice_source_id;
217:
218: IF l_debug_level > 0 THEN
219: oe_debug_pub.add('Line type details... ' );
220: oe_debug_pub.add('Customer Transaction type : ' || l_cust_trx_type_id );
221: oe_debug_pub.add('Invoice Source : ' || l_invoice_source_id );
222: oe_debug_pub.add('Non Delivery Invoice Source : ' || l_non_d_invoice_source_id );
223: END IF;
224:

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

217:
218: IF l_debug_level > 0 THEN
219: oe_debug_pub.add('Line type details... ' );
220: oe_debug_pub.add('Customer Transaction type : ' || l_cust_trx_type_id );
221: oe_debug_pub.add('Invoice Source : ' || l_invoice_source_id );
222: oe_debug_pub.add('Non Delivery Invoice Source : ' || l_non_d_invoice_source_id );
223: END IF;
224:
225: IF l_cust_trx_type_id IS NULL OR

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

218: IF l_debug_level > 0 THEN
219: oe_debug_pub.add('Line type details... ' );
220: oe_debug_pub.add('Customer Transaction type : ' || l_cust_trx_type_id );
221: oe_debug_pub.add('Invoice Source : ' || l_invoice_source_id );
222: oe_debug_pub.add('Non Delivery Invoice Source : ' || l_non_d_invoice_source_id );
223: END IF;
224:
225: IF l_cust_trx_type_id IS NULL OR
226: (l_invoice_source_id IS NULL AND (g_shippable_flag_tbl(i) = 'Y' OR l_invoice_numbering_method = 'A')) OR

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

232: l_non_d_invoice_source_id2 := l_order_type_rec.non_delivery_invoice_source_id;
233: END IF;
234:
235: IF l_debug_level > 0 THEN
236: oe_debug_pub.add('Order type details... ' );
237: oe_debug_pub.add('Customer Transaction type : ' || l_cust_trx_type_id2 );
238: oe_debug_pub.add('Invoice Source : ' || l_invoice_source_id2 );
239: oe_debug_pub.add('Non Delivery Invoice Source : ' || l_non_d_invoice_source_id2 );
240: END IF;

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

233: END IF;
234:
235: IF l_debug_level > 0 THEN
236: oe_debug_pub.add('Order type details... ' );
237: oe_debug_pub.add('Customer Transaction type : ' || l_cust_trx_type_id2 );
238: oe_debug_pub.add('Invoice Source : ' || l_invoice_source_id2 );
239: oe_debug_pub.add('Non Delivery Invoice Source : ' || l_non_d_invoice_source_id2 );
240: END IF;
241:

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

234:
235: IF l_debug_level > 0 THEN
236: oe_debug_pub.add('Order type details... ' );
237: oe_debug_pub.add('Customer Transaction type : ' || l_cust_trx_type_id2 );
238: oe_debug_pub.add('Invoice Source : ' || l_invoice_source_id2 );
239: oe_debug_pub.add('Non Delivery Invoice Source : ' || l_non_d_invoice_source_id2 );
240: END IF;
241:
242: 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 239: oe_debug_pub.add('Non Delivery Invoice Source : ' || l_non_d_invoice_source_id2 );

235: IF l_debug_level > 0 THEN
236: oe_debug_pub.add('Order type details... ' );
237: oe_debug_pub.add('Customer Transaction type : ' || l_cust_trx_type_id2 );
238: oe_debug_pub.add('Invoice Source : ' || l_invoice_source_id2 );
239: oe_debug_pub.add('Non Delivery Invoice Source : ' || l_non_d_invoice_source_id2 );
240: END IF;
241:
242: 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)));
243:

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

255: END IF;
256: END IF;
257:
258: IF l_debug_level > 0 THEN
259: oe_debug_pub.add('i:'||i);
260: oe_debug_pub.add('g_line_id_tbl(i):'||g_line_id_tbl(i));
261: oe_debug_pub.add('g_invoice_to_customer_tbl(i):'||g_invoice_to_customer_tbl(i));
262: oe_debug_pub.add('G_invoice_to_site_tbl(i):'||G_invoice_to_site_tbl(i));
263: oe_debug_pub.add('g_inventory_item_id_tbl(i):'||g_inventory_item_id_tbl(i));

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

256: END IF;
257:
258: IF l_debug_level > 0 THEN
259: oe_debug_pub.add('i:'||i);
260: oe_debug_pub.add('g_line_id_tbl(i):'||g_line_id_tbl(i));
261: oe_debug_pub.add('g_invoice_to_customer_tbl(i):'||g_invoice_to_customer_tbl(i));
262: oe_debug_pub.add('G_invoice_to_site_tbl(i):'||G_invoice_to_site_tbl(i));
263: oe_debug_pub.add('g_inventory_item_id_tbl(i):'||g_inventory_item_id_tbl(i));
264: oe_debug_pub.add('Customer Transaction type : ' || g_cust_trx_type_id_tbl(i) );

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

257:
258: IF l_debug_level > 0 THEN
259: oe_debug_pub.add('i:'||i);
260: oe_debug_pub.add('g_line_id_tbl(i):'||g_line_id_tbl(i));
261: oe_debug_pub.add('g_invoice_to_customer_tbl(i):'||g_invoice_to_customer_tbl(i));
262: oe_debug_pub.add('G_invoice_to_site_tbl(i):'||G_invoice_to_site_tbl(i));
263: oe_debug_pub.add('g_inventory_item_id_tbl(i):'||g_inventory_item_id_tbl(i));
264: oe_debug_pub.add('Customer Transaction type : ' || g_cust_trx_type_id_tbl(i) );
265: oe_debug_pub.add('Invoice Source : ' || g_batch_source_id_tbl(i) );

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

258: IF l_debug_level > 0 THEN
259: oe_debug_pub.add('i:'||i);
260: oe_debug_pub.add('g_line_id_tbl(i):'||g_line_id_tbl(i));
261: oe_debug_pub.add('g_invoice_to_customer_tbl(i):'||g_invoice_to_customer_tbl(i));
262: oe_debug_pub.add('G_invoice_to_site_tbl(i):'||G_invoice_to_site_tbl(i));
263: oe_debug_pub.add('g_inventory_item_id_tbl(i):'||g_inventory_item_id_tbl(i));
264: oe_debug_pub.add('Customer Transaction type : ' || g_cust_trx_type_id_tbl(i) );
265: oe_debug_pub.add('Invoice Source : ' || g_batch_source_id_tbl(i) );
266: oe_debug_pub.add('org_id : ' || g_org_id_tbl(i) );

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

259: oe_debug_pub.add('i:'||i);
260: oe_debug_pub.add('g_line_id_tbl(i):'||g_line_id_tbl(i));
261: oe_debug_pub.add('g_invoice_to_customer_tbl(i):'||g_invoice_to_customer_tbl(i));
262: oe_debug_pub.add('G_invoice_to_site_tbl(i):'||G_invoice_to_site_tbl(i));
263: oe_debug_pub.add('g_inventory_item_id_tbl(i):'||g_inventory_item_id_tbl(i));
264: oe_debug_pub.add('Customer Transaction type : ' || g_cust_trx_type_id_tbl(i) );
265: oe_debug_pub.add('Invoice Source : ' || g_batch_source_id_tbl(i) );
266: oe_debug_pub.add('org_id : ' || g_org_id_tbl(i) );
267: oe_debug_pub.add('accounting rule : ' || g_accounting_rule_id_tbl(i) );

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

260: oe_debug_pub.add('g_line_id_tbl(i):'||g_line_id_tbl(i));
261: oe_debug_pub.add('g_invoice_to_customer_tbl(i):'||g_invoice_to_customer_tbl(i));
262: oe_debug_pub.add('G_invoice_to_site_tbl(i):'||G_invoice_to_site_tbl(i));
263: oe_debug_pub.add('g_inventory_item_id_tbl(i):'||g_inventory_item_id_tbl(i));
264: oe_debug_pub.add('Customer Transaction type : ' || g_cust_trx_type_id_tbl(i) );
265: oe_debug_pub.add('Invoice Source : ' || g_batch_source_id_tbl(i) );
266: oe_debug_pub.add('org_id : ' || g_org_id_tbl(i) );
267: oe_debug_pub.add('accounting rule : ' || g_accounting_rule_id_tbl(i) );
268:

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

261: oe_debug_pub.add('g_invoice_to_customer_tbl(i):'||g_invoice_to_customer_tbl(i));
262: oe_debug_pub.add('G_invoice_to_site_tbl(i):'||G_invoice_to_site_tbl(i));
263: oe_debug_pub.add('g_inventory_item_id_tbl(i):'||g_inventory_item_id_tbl(i));
264: oe_debug_pub.add('Customer Transaction type : ' || g_cust_trx_type_id_tbl(i) );
265: oe_debug_pub.add('Invoice Source : ' || g_batch_source_id_tbl(i) );
266: oe_debug_pub.add('org_id : ' || g_org_id_tbl(i) );
267: oe_debug_pub.add('accounting rule : ' || g_accounting_rule_id_tbl(i) );
268:
269: END IF;

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

262: oe_debug_pub.add('G_invoice_to_site_tbl(i):'||G_invoice_to_site_tbl(i));
263: oe_debug_pub.add('g_inventory_item_id_tbl(i):'||g_inventory_item_id_tbl(i));
264: oe_debug_pub.add('Customer Transaction type : ' || g_cust_trx_type_id_tbl(i) );
265: oe_debug_pub.add('Invoice Source : ' || g_batch_source_id_tbl(i) );
266: oe_debug_pub.add('org_id : ' || g_org_id_tbl(i) );
267: oe_debug_pub.add('accounting rule : ' || g_accounting_rule_id_tbl(i) );
268:
269: END IF;
270:

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

263: oe_debug_pub.add('g_inventory_item_id_tbl(i):'||g_inventory_item_id_tbl(i));
264: oe_debug_pub.add('Customer Transaction type : ' || g_cust_trx_type_id_tbl(i) );
265: oe_debug_pub.add('Invoice Source : ' || g_batch_source_id_tbl(i) );
266: oe_debug_pub.add('org_id : ' || g_org_id_tbl(i) );
267: oe_debug_pub.add('accounting rule : ' || g_accounting_rule_id_tbl(i) );
268:
269: END IF;
270:
271: END IF;

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

271: END IF;
272: END LOOP;
273:
274: IF l_debug_level > 0 THEN
275: oe_debug_pub.add('Inserting records in AR_RDR_PARAMETERS_GT ' );
276: oe_debug_pub.add('g_Line_id_tbl.count: ' ||g_Line_id_tbl.count);
277: END IF;
278:
279: --Populate global temporary table AR_RDR_PARAMETERS_GT

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

272: END LOOP;
273:
274: IF l_debug_level > 0 THEN
275: oe_debug_pub.add('Inserting records in AR_RDR_PARAMETERS_GT ' );
276: oe_debug_pub.add('g_Line_id_tbl.count: ' ||g_Line_id_tbl.count);
277: END IF;
278:
279: --Populate global temporary table AR_RDR_PARAMETERS_GT
280: -- FORALL i in g_line_id_tbl.FIRST..g_line_id_tbl.LAST

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

306: FROM dual
307: WHERE g_line_id_tbl(i) <> -99;
308:
309: IF l_debug_level > 0 THEN
310: oe_debug_pub.add('done inserting records' );
311: END IF;
312:
313: l_inserted_lines := SQL%ROWCOUNT;
314: IF l_debug_level > 0 THEN

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

311: END IF;
312:
313: l_inserted_lines := SQL%ROWCOUNT;
314: IF l_debug_level > 0 THEN
315: oe_debug_pub.add( 'INSERTED '||l_inserted_lines||' records' , 3 ) ;
316: END IF;
317:
318: IF l_inserted_lines > 0 THEN
319: --Call AR API

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

317:
318: IF l_inserted_lines > 0 THEN
319: --Call AR API
320: IF l_debug_level > 0 THEN
321: oe_debug_pub.add('Entering AR_DEFERRAL_REASONS_GRP.default_reasons ' );
322: END IF;
323: ar_deferral_reasons_grp.default_reasons (
324: p_api_version => 1.0,
325: p_mode => 'OM',

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

327: x_msg_count => l_msg_count,
328: x_msg_data => l_msg_data);
329:
330: IF l_debug_level > 0 THEN
331: oe_debug_pub.add('Exiting AR_DEFERRAL_REASONS_GRP.default_reasons ' );
332: END IF;
333:
334: --join fun_rule_bulk_result_gt with ar_deferral_reasons to get all the AR attributes
335: --pick one pre-billing or post-billing contingency

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

341: l_line_id_old := 0;
342: l_line_id_new := 0;
343:
344: IF l_debug_level > 0 THEN -- for debugging purpose
345: oe_debug_pub.add('Records returned by AR');
346: FOR default_contingencies_rec IN default_contingencies LOOP
347: oe_debug_pub.add('id:'||default_contingencies_rec.id);
348: oe_debug_pub.add('contingency_id:'||default_contingencies_rec.contingency_id);
349: oe_debug_pub.add('revrec_event_code:'||default_contingencies_rec.revrec_event_code);

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

343:
344: IF l_debug_level > 0 THEN -- for debugging purpose
345: oe_debug_pub.add('Records returned by AR');
346: FOR default_contingencies_rec IN default_contingencies LOOP
347: oe_debug_pub.add('id:'||default_contingencies_rec.id);
348: oe_debug_pub.add('contingency_id:'||default_contingencies_rec.contingency_id);
349: oe_debug_pub.add('revrec_event_code:'||default_contingencies_rec.revrec_event_code);
350: oe_debug_pub.add('revrec_expiration_days:'||default_contingencies_rec.expiration_days);
351: END LOOP;

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

344: IF l_debug_level > 0 THEN -- for debugging purpose
345: oe_debug_pub.add('Records returned by AR');
346: FOR default_contingencies_rec IN default_contingencies LOOP
347: oe_debug_pub.add('id:'||default_contingencies_rec.id);
348: oe_debug_pub.add('contingency_id:'||default_contingencies_rec.contingency_id);
349: oe_debug_pub.add('revrec_event_code:'||default_contingencies_rec.revrec_event_code);
350: oe_debug_pub.add('revrec_expiration_days:'||default_contingencies_rec.expiration_days);
351: END LOOP;
352: END IF;

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

345: oe_debug_pub.add('Records returned by AR');
346: FOR default_contingencies_rec IN default_contingencies LOOP
347: oe_debug_pub.add('id:'||default_contingencies_rec.id);
348: oe_debug_pub.add('contingency_id:'||default_contingencies_rec.contingency_id);
349: oe_debug_pub.add('revrec_event_code:'||default_contingencies_rec.revrec_event_code);
350: oe_debug_pub.add('revrec_expiration_days:'||default_contingencies_rec.expiration_days);
351: END LOOP;
352: END IF;
353:

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

346: FOR default_contingencies_rec IN default_contingencies LOOP
347: oe_debug_pub.add('id:'||default_contingencies_rec.id);
348: oe_debug_pub.add('contingency_id:'||default_contingencies_rec.contingency_id);
349: oe_debug_pub.add('revrec_event_code:'||default_contingencies_rec.revrec_event_code);
350: oe_debug_pub.add('revrec_expiration_days:'||default_contingencies_rec.expiration_days);
351: END LOOP;
352: END IF;
353:
354:

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

356: l_line_id_new := default_contingencies_rec.id;
357:
358: IF l_line_id_new <> l_line_id_old THEN
359: IF l_debug_level > 0 THEN
360: oe_debug_pub.add('Updating records in OE_ORDER_LINES_ALL ' );
361: END IF;
362: UPDATE OE_ORDER_LINES_ALL
363: SET contingency_id = default_contingencies_rec.contingency_id,
364: revrec_event_code = default_contingencies_rec.revrec_event_code,

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

371: END LOOP;
372: END IF;
373:
374: IF l_debug_level > 0 THEN
375: oe_debug_pub.add('Deleting the changed lines table once the lines are processed ' );
376: END IF;
377:
378: Delete_Changed_Lines_Tbl;
379:

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

393: l_order_line_id NUMBER;
394: l_return_status VARCHAR2(1);
395: l_service_reference_line_id NUMBER;
396: --
397: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
398: --
399: l_accepted_quantity NUMBER;
400: l_revrec_signature VARCHAR2(240);
401: l_revrec_signature_date DATE;

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

407: l_item_type_code VARCHAR2(30);
408:
409: BEGIN
410: IF l_debug_level > 0 THEN
411: oe_debug_pub.add( 'ENTERING OE_ACCEPTANCE_UTIL.Default_Parent_Accept_Details' ) ;
412: END IF;
413: IF p_line_rec.item_type_code = 'SERVICE' THEN
414: IF p_line_rec.service_reference_type_code = 'CUSTOMER_PRODUCT' AND
415: p_line_rec.service_reference_line_id IS NOT NULL THEN

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

413: IF p_line_rec.item_type_code = 'SERVICE' THEN
414: IF p_line_rec.service_reference_type_code = 'CUSTOMER_PRODUCT' AND
415: p_line_rec.service_reference_line_id IS NOT NULL THEN
416: IF l_debug_level > 0 THEN
417: oe_debug_pub.add( 'LINE IS A CUSTOMER PRODUCT' ) ;
418: END IF;
419: OE_SERVICE_UTIL.Get_Cust_Product_Line_Id
420: ( x_return_status => l_return_status
421: , p_reference_line_id => p_line_rec.service_reference_line_id

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

423: , x_cust_product_line_id => l_order_line_id
424: );
425: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
426: IF l_debug_level > 0 THEN
427: oe_debug_pub.add( 'SERVICE LINE ID IS ' || L_ORDER_LINE_ID ) ;
428: END IF;
429: l_service_reference_line_id := l_order_line_id;
430: ELSE
431: IF l_debug_level > 0 THEN

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

428: END IF;
429: l_service_reference_line_id := l_order_line_id;
430: ELSE
431: IF l_debug_level > 0 THEN
432: oe_debug_pub.add( 'NOT ABLE TO RETRIEVE CUST PRODUCT LINE ID' ) ;
433: END IF;
434: FND_MESSAGE.SET_NAME('ONT','ONT_NO_CUST_PROD_LINE');
435: OE_MSG_PUB.ADD;
436: --RAISE NO_DATA_FOUND;

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

534: l_item_type_code VARCHAR2(30);
535: l_order_line_id NUMBER;
536: l_top_model_line_id NUMBER;
537: --
538: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
539: --
540: BEGIN
541: x_contingency_id := NULL;
542: x_revrec_event_code := NULL;

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

544:
545: IF p_line_rec.item_type_code = 'RETURN' THEN
546:
547: IF l_debug_level > 0 THEN
548: oe_debug_pub.add( 'Return Line, Return ' );
549: END IF;
550: RETURN;
551:
552: ELSIF p_line_rec.source_document_type_id = 10 THEN

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

551:
552: ELSIF p_line_rec.source_document_type_id = 10 THEN
553:
554: IF l_debug_level > 0 THEN
555: oe_debug_pub.add( 'Internal Order Line, Return');
556: END IF;
557: RETURN;
558:
559: ELSIF p_line_rec.order_source_id=27 AND p_line_rec.retrobill_request_id IS NOT NULL THEN

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

558:
559: ELSIF p_line_rec.order_source_id=27 AND p_line_rec.retrobill_request_id IS NOT NULL THEN
560:
561: IF l_debug_level > 0 THEN
562: oe_debug_pub.add( 'Retrobill Line, Return ' );
563: END IF;
564: RETURN;
565:
566: ELSIF p_line_rec.item_type_code IN ('CONFIG','CLASS','OPTION','INCLUDED')

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

566: ELSIF p_line_rec.item_type_code IN ('CONFIG','CLASS','OPTION','INCLUDED')
567: OR (p_line_rec.item_type_code = 'KIT' and p_line_rec.top_model_line_id <> p_line_rec.line_id) THEN
568:
569: IF l_debug_level > 0 THEN
570: oe_debug_pub.add('Item_type_code:'||p_line_rec.item_type_code||' Get from parent:'||p_line_rec.top_model_line_id );
571: END IF;
572: IF p_line_rec.top_model_line_id IS NOT NULL THEN
573: SELECT contingency_id, revrec_event_code, revrec_expiration_days
574: INTO x_contingency_id, x_revrec_event_code,x_revrec_expiration_days

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

576: WHERE line_id = p_line_rec.top_model_line_id;
577: END IF;
578: ELSIF p_line_rec.item_type_code = 'SERVICE' THEN
579: IF l_debug_level > 0 THEN
580: oe_debug_pub.add( 'Item_type_code:'||p_line_rec.item_type_code||' - Get from service parent' );
581: END IF;
582: IF p_line_rec.service_reference_type_code = 'CUSTOMER_PRODUCT' AND
583: p_line_rec.service_reference_line_id IS NOT NULL THEN
584: IF l_debug_level > 0 THEN

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

581: END IF;
582: IF p_line_rec.service_reference_type_code = 'CUSTOMER_PRODUCT' AND
583: p_line_rec.service_reference_line_id IS NOT NULL THEN
584: IF l_debug_level > 0 THEN
585: oe_debug_pub.add( 'LINE IS A CUSTOMER PRODUCT' ) ;
586: END IF;
587: OE_SERVICE_UTIL.Get_Cust_Product_Line_Id
588: ( x_return_status => l_return_status
589: , p_reference_line_id => p_line_rec.service_reference_line_id

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

591: , x_cust_product_line_id => l_order_line_id
592: );
593: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
594: IF l_debug_level > 0 THEN
595: oe_debug_pub.add( 'SERVICE LINE ID IS ' || L_ORDER_LINE_ID ) ;
596: END IF;
597: l_service_reference_line_id := l_order_line_id;
598: ELSE
599: IF l_debug_level > 0 THEN

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

596: END IF;
597: l_service_reference_line_id := l_order_line_id;
598: ELSE
599: IF l_debug_level > 0 THEN
600: oe_debug_pub.add( 'NOT ABLE TO RETRIEVE CUST PRODUCT LINE ID' ) ;
601: END IF;
602: FND_MESSAGE.SET_NAME('ONT','ONT_NO_CUST_PROD_LINE');
603: OE_MSG_PUB.ADD;
604: RAISE NO_DATA_FOUND;

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

625: END IF;
626: END IF;
627: ELSE -- standard line or top model
628: IF l_debug_level > 0 THEN
629: oe_debug_pub.add( 'Item_type_code:'||p_line_rec.item_type_code||' top_model_line_id:'||p_line_rec.top_model_line_id );
630: END IF;
631: x_contingency_id := p_line_rec.contingency_id;
632: x_revrec_event_code := p_line_rec.revrec_event_code;
633: x_revrec_expiration_days:= p_line_rec.revrec_expiration_days;

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

655: l_top_model_line_id NUMBER;
656: l_contingency_id NUMBER;
657: l_revrec_event_code VARCHAR2(30);
658: --
659: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
660: --
661: BEGIN
662:
663: IF p_line_rec.line_category_code = 'RETURN' THEN

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

662:
663: IF p_line_rec.line_category_code = 'RETURN' THEN
664:
665: IF l_debug_level > 0 THEN
666: oe_debug_pub.add( 'Return Line, Return FALSE' );
667: END IF;
668: RETURN FALSE;
669:
670: ELSIF p_line_rec.source_document_type_id = 10 THEN

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

669:
670: ELSIF p_line_rec.source_document_type_id = 10 THEN
671:
672: IF l_debug_level > 0 THEN
673: oe_debug_pub.add( 'Internal Order Line, Return FALSE' );
674: END IF;
675: RETURN FALSE;
676:
677: ELSIF p_line_rec.order_source_id = 27 AND p_line_rec.retrobill_request_id IS NOT NULL THEN

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

676:
677: ELSIF p_line_rec.order_source_id = 27 AND p_line_rec.retrobill_request_id IS NOT NULL THEN
678:
679: IF l_debug_level > 0 THEN
680: oe_debug_pub.add( 'Retrobill Line, Return FALSE' );
681: END IF;
682: RETURN FALSE;
683:
684: ELSIF p_line_rec.item_type_code IN ('CONFIG', 'CLASS', 'OPTION', 'INCLUDED')

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

684: ELSIF p_line_rec.item_type_code IN ('CONFIG', 'CLASS', 'OPTION', 'INCLUDED')
685: OR (p_line_rec.item_type_code = 'KIT' and p_line_rec.top_model_line_id <> p_line_rec.line_id) THEN
686:
687: IF l_debug_level > 0 THEN
688: oe_debug_pub.add( 'Item_type_code:'||p_line_rec.item_type_code||' - Get from parent:'||p_line_rec.top_model_line_id );
689: END IF;
690: IF p_line_rec.top_model_line_id IS NOT NULL THEN
691: SELECT contingency_id, revrec_event_code
692: INTO l_contingency_id, l_revrec_event_code

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

700: RETURN FALSE;
701: END IF;
702: ELSIF p_line_rec.item_type_code = 'SERVICE' THEN
703: IF l_debug_level > 0 THEN
704: oe_debug_pub.add( 'Item_type_code:'||p_line_rec.item_type_code||' - Get from service parent' );
705: END IF;
706: IF p_line_rec.service_reference_type_code='CUSTOMER_PRODUCT' AND
707: p_line_rec.service_reference_line_id IS NOT NULL THEN
708: IF l_debug_level > 0 THEN

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

705: END IF;
706: IF p_line_rec.service_reference_type_code='CUSTOMER_PRODUCT' AND
707: p_line_rec.service_reference_line_id IS NOT NULL THEN
708: IF l_debug_level > 0 THEN
709: oe_debug_pub.add( 'LINE IS A CUSTOMER PRODUCT' ) ;
710: END IF;
711: OE_SERVICE_UTIL.Get_Cust_Product_Line_Id
712: ( x_return_status => l_return_status
713: , p_reference_line_id => p_line_rec.service_reference_line_id

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

715: , x_cust_product_line_id => l_order_line_id
716: );
717: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
718: IF l_debug_level > 0 THEN
719: oe_debug_pub.add( 'SERVICE LINE ID IS ' || L_ORDER_LINE_ID ) ;
720: END IF;
721: l_service_reference_line_id := l_order_line_id;
722: ELSE
723: IF l_debug_level > 0 THEN

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

720: END IF;
721: l_service_reference_line_id := l_order_line_id;
722: ELSE
723: IF l_debug_level > 0 THEN
724: oe_debug_pub.add( 'NOT ABLE TO RETRIEVE CUST PRODUCT LINE ID' ) ;
725: END IF;
726: FND_MESSAGE.SET_NAME('ONT','ONT_NO_CUST_PROD_LINE');
727: OE_MSG_PUB.ADD;
728: --RAISE NO_DATA_FOUND;

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

759: RETURN FALSE;
760: END IF;
761: ELSE -- standard line or top model
762: IF l_debug_level > 0 THEN
763: oe_debug_pub.add( 'Item_type_code:'||p_line_rec.item_type_code||' top_model_line_id:'||p_line_rec.top_model_line_id );
764: END IF;
765: IF p_line_rec.contingency_id IS NOT NULL AND p_line_rec.revrec_event_code='INVOICING' THEN
766: RETURN TRUE;
767: ELSE

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

784: --Overloaded to accept line_id as parameter
785: FUNCTION Pre_billing_acceptance_on (p_line_id IN NUMBER) RETURN BOOLEAN
786: IS
787: l_line_rec OE_ORDER_PUB.line_rec_type;
788: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
789: BEGIN
790:
791: OE_Line_Util.Query_Row(p_line_id => p_line_id,x_line_rec => l_line_rec);
792: RETURN Pre_billing_acceptance_on (p_line_rec => l_line_rec);

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

808: l_top_model_line_id NUMBER;
809: l_contingency_id NUMBER;
810: l_revrec_event_code VARCHAR2(30);
811: --
812: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
813: --
814: BEGIN
815:
816: IF p_line_rec.line_category_code = 'RETURN' THEN

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

815:
816: IF p_line_rec.line_category_code = 'RETURN' THEN
817:
818: IF l_debug_level > 0 THEN
819: oe_debug_pub.add( 'Return Line, Return FALSE' );
820: END IF;
821: RETURN FALSE;
822:
823: ELSIF p_line_rec.source_document_type_id = 10 THEN

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

822:
823: ELSIF p_line_rec.source_document_type_id = 10 THEN
824:
825: IF l_debug_level > 0 THEN
826: oe_debug_pub.add( 'Internal Order Line, Return FALSE' );
827: END IF;
828: RETURN FALSE;
829:
830: ELSIF p_line_rec.order_source_id = 27 AND p_line_rec.retrobill_request_id IS NOT NULL THEN

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

829:
830: ELSIF p_line_rec.order_source_id = 27 AND p_line_rec.retrobill_request_id IS NOT NULL THEN
831:
832: IF l_debug_level > 0 THEN
833: oe_debug_pub.add( 'Retrobill Line, Return FALSE' );
834: END IF;
835: RETURN FALSE;
836:
837: ELSIF p_line_rec.item_type_code IN ('CONFIG', 'CLASS', 'OPTION', 'INCLUDED')

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

837: ELSIF p_line_rec.item_type_code IN ('CONFIG', 'CLASS', 'OPTION', 'INCLUDED')
838: OR (p_line_rec.item_type_code = 'KIT' and p_line_rec.top_model_line_id <> p_line_rec.line_id) THEN
839:
840: IF l_debug_level > 0 THEN
841: oe_debug_pub.add( 'Item_type_code:'||p_line_rec.item_type_code||' - Get from parent:'||p_line_rec.top_model_line_id );
842: END IF;
843: IF p_line_rec.top_model_line_id IS NOT NULL THEN
844: SELECT contingency_id, revrec_event_code
845: INTO l_contingency_id, l_revrec_event_code

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

853: RETURN FALSE;
854: END IF;
855: ELSIF p_line_rec.item_type_code = 'SERVICE' THEN
856: IF l_debug_level > 0 THEN
857: oe_debug_pub.add( 'Item_type_code:'||p_line_rec.item_type_code||' - Get from service parent' );
858: END IF;
859: IF p_line_rec.service_reference_type_code='CUSTOMER_PRODUCT' AND
860: p_line_rec.service_reference_line_id IS NOT NULL THEN
861: IF l_debug_level > 0 THEN

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

858: END IF;
859: IF p_line_rec.service_reference_type_code='CUSTOMER_PRODUCT' AND
860: p_line_rec.service_reference_line_id IS NOT NULL THEN
861: IF l_debug_level > 0 THEN
862: oe_debug_pub.add( 'LINE IS A CUSTOMER PRODUCT' ) ;
863: END IF;
864: OE_SERVICE_UTIL.Get_Cust_Product_Line_Id
865: ( x_return_status => l_return_status
866: , p_reference_line_id => p_line_rec.service_reference_line_id

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

868: , x_cust_product_line_id => l_order_line_id
869: );
870: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
871: IF l_debug_level > 0 THEN
872: oe_debug_pub.add( 'SERVICE LINE ID IS ' || L_ORDER_LINE_ID ) ;
873: END IF;
874: l_service_reference_line_id := l_order_line_id;
875: ELSE
876: IF l_debug_level > 0 THEN

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

873: END IF;
874: l_service_reference_line_id := l_order_line_id;
875: ELSE
876: IF l_debug_level > 0 THEN
877: oe_debug_pub.add( 'NOT ABLE TO RETRIEVE CUST PRODUCT LINE ID' ) ;
878: END IF;
879: FND_MESSAGE.SET_NAME('ONT','ONT_NO_CUST_PROD_LINE');
880: OE_MSG_PUB.ADD;
881: --RAISE NO_DATA_FOUND;

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

912: RETURN FALSE;
913: END IF;
914: ELSE -- standard line or top model
915: IF l_debug_level > 0 THEN
916: oe_debug_pub.add( 'Item_type_code:'||p_line_rec.item_type_code||' top_model_line_id:'||p_line_rec.top_model_line_id );
917: END IF;
918: IF p_line_rec.contingency_id IS NOT NULL AND p_line_rec.revrec_event_code='CUSTOMER_ACCEPTANCE' THEN
919: RETURN TRUE;
920: ELSE

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

937: FUNCTION Post_billing_acceptance_on (p_line_id IN NUMBER) RETURN BOOLEAN
938: IS
939: l_line_rec OE_ORDER_PUB.line_rec_type;
940: --
941: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
942: --
943: BEGIN
944: OE_Line_Util.Query_Row(p_line_id => p_line_id,
945: x_line_rec => l_line_rec);

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

956:
957: FUNCTION Customer_acceptance_Eligible (p_line_rec IN OE_Order_PUB.Line_Rec_Type) RETURN BOOLEAN IS
958: l_count NUMBER := 0;
959: --
960: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
961: --
962: BEGIN
963: IF p_line_rec.line_category_code = 'RETURN' THEN
964:

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

962: BEGIN
963: IF p_line_rec.line_category_code = 'RETURN' THEN
964:
965: IF l_debug_level > 0 THEN
966: oe_debug_pub.add( 'Return Line, Return FALSE' );
967: END IF;
968: RETURN FALSE;
969:
970: ELSIF p_line_rec.source_document_type_id = 10 THEN

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

969:
970: ELSIF p_line_rec.source_document_type_id = 10 THEN
971:
972: IF l_debug_level > 0 THEN
973: oe_debug_pub.add( 'Internal Order Line, Return FALSE' );
974: END IF;
975: RETURN FALSE;
976:
977: ELSIF p_line_rec.order_source_id = 27 AND p_line_rec.retrobill_request_id IS NOT NULL THEN

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

976:
977: ELSIF p_line_rec.order_source_id = 27 AND p_line_rec.retrobill_request_id IS NOT NULL THEN
978:
979: IF l_debug_level > 0 THEN
980: oe_debug_pub.add( 'Retrobill Line, Return FALSE' );
981: END IF;
982: RETURN FALSE;
983: ELSIF p_line_rec.item_type_code IN ('CONFIG', 'CLASS', 'OPTION', 'INCLUDED')
984: 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 987: oe_debug_pub.add( 'Item_type_code:'||p_line_rec.item_type_code);

983: ELSIF p_line_rec.item_type_code IN ('CONFIG', 'CLASS', 'OPTION', 'INCLUDED')
984: OR (p_line_rec.item_type_code = 'KIT' and p_line_rec.top_model_line_id <> p_line_rec.line_id) THEN --child line
985:
986: IF l_debug_level > 0 THEN
987: oe_debug_pub.add( 'Item_type_code:'||p_line_rec.item_type_code);
988: END IF;
989: RETURN FALSE;
990: ELSIF p_line_rec.item_type_code = 'SERVICE' THEN
991: IF l_debug_level > 0 THEN

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

988: END IF;
989: RETURN FALSE;
990: ELSIF p_line_rec.item_type_code = 'SERVICE' THEN
991: IF l_debug_level > 0 THEN
992: oe_debug_pub.add( 'Item_type_code:'||p_line_rec.item_type_code||' - Get from service parent' );
993: END IF;
994: IF p_line_rec.service_reference_type_code='ORDER' THEN
995: IF l_debug_level > 0 THEN
996: oe_debug_pub.add( 'LINE is a service with reference type ORDER' ) ;

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

992: oe_debug_pub.add( 'Item_type_code:'||p_line_rec.item_type_code||' - Get from service parent' );
993: END IF;
994: IF p_line_rec.service_reference_type_code='ORDER' THEN
995: IF l_debug_level > 0 THEN
996: oe_debug_pub.add( 'LINE is a service with reference type ORDER' ) ;
997: END IF;
998: RETURN FALSE;
999: -- Acceptance of customer product services should not be allowed through UI.
1000: -- But explicit acceptance should be allowed

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

1006: END IF;
1007: END IF;
1008: ELSE -- Now it could be a model, kit or standard line
1009: IF l_debug_level > 0 THEN
1010: oe_debug_pub.add( 'Item_type_code:'||p_line_rec.item_type_code||' top_model_line_id'|| p_line_rec.top_model_line_id);
1011: END IF;
1012: 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
1013: IF p_line_rec.flow_status_code NOT IN ('PRE-BILLING_ACCEPTANCE', 'POST-BILLING_ACCEPTANCE') THEN
1014: RETURN FALSE;

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

1051: --Overloaded to accept line_id as parameter
1052: FUNCTION Customer_Acceptance_Eligible (p_line_id IN NUMBER) RETURN BOOLEAN IS
1053: l_line_rec OE_ORDER_PUB.line_rec_type;
1054: --
1055: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1056: --
1057: BEGIN
1058: OE_Line_Util.Query_Row(p_line_id => p_line_id,
1059: x_line_rec => l_line_rec);

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

1070: END Customer_Acceptance_Eligible;
1071:
1072: FUNCTION Acceptance_Status(p_line_rec IN OE_Order_PUB.Line_Rec_Type) RETURN VARCHAR2 IS
1073: --
1074: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1075: --
1076: BEGIN
1077:
1078: IF p_line_rec.accepted_quantity IS NULL OR p_line_rec.accepted_quantity = FND_API.G_MISS_NUM THEN

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

1079: -- consider closed lines as accepted because parent line might have been closed
1080: -- without acceptance (ex: from progress order when system param turned off)
1081: IF nvl(p_line_rec.open_flag, 'Y') = 'N' THEN
1082: IF l_debug_level > 0 THEN
1083: oe_debug_pub.add('returning as accepted because line '||p_line_rec.line_id||' is already closed');
1084: END IF;
1085: RETURN 'ACCEPTED';
1086: ELSE
1087: RETURN 'NOT_ACCEPTED';

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

1099: FUNCTION Acceptance_Status(p_line_id IN NUMBER) RETURN VARCHAR2 IS
1100: l_accepted_quantity NUMBER;
1101: l_open_flag VARCHAR2(1);
1102: --
1103: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1104: --
1105: BEGIN
1106: SELECT accepted_quantity, open_flag
1107: INTO l_accepted_quantity, l_open_flag

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

1112: -- consider closed lines as accepted because parent line might have been closed
1113: -- without acceptance (ex: from progress order when system param turned off)
1114: IF nvl(l_open_flag, 'Y') = 'N' THEN
1115: IF l_debug_level > 0 THEN
1116: oe_debug_pub.add('returning as accepted because line '||p_line_id||' is already closed');
1117: END IF;
1118: RETURN 'ACCEPTED';
1119: ELSE
1120: RETURN 'NOT_ACCEPTED';