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

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

61: l_cust_account_id NUMBER;
62: l_trans_curr_code VARCHAR2(20); --Verify
63: l_card_instrument IBY_FNDCPT_SETUP_PUB.CreditCard_rec_Type;
64:
65: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
66:
67: BEGIN
68:
69: IF l_debug_level > 0 THEN

Line 70: oe_debug_pub.add('Entering OE_Default_PVT.Get_Credit_Card_Number.', 1);

66:
67: BEGIN
68:
69: IF l_debug_level > 0 THEN
70: oe_debug_pub.add('Entering OE_Default_PVT.Get_Credit_Card_Number.', 1);
71: END IF;
72:
73:
74: IF p_database_object_name = 'OE_AK_ORDER_HEADERS_V' THEN

Line 179: oe_debug_pub.add('Payer context values in Defaulting package');

175: l_conditions.Currency_Code := l_trans_curr_code;
176: l_conditions.Payment_InstrType := 'CREDITCARD';
177:
178: IF l_debug_level > 0 THEN
179: oe_debug_pub.add('Payer context values in Defaulting package');
180: oe_debug_pub.add('Party id'||l_party_id);
181: oe_debug_pub.add('Org id'||l_payer.org_id);
182: oe_debug_pub.add('cust acct id'||l_invoice_to_org_id);
183: oe_debug_pub.add('acct site id'||l_invoice_to_cust_id);

Line 180: oe_debug_pub.add('Party id'||l_party_id);

176: l_conditions.Payment_InstrType := 'CREDITCARD';
177:
178: IF l_debug_level > 0 THEN
179: oe_debug_pub.add('Payer context values in Defaulting package');
180: oe_debug_pub.add('Party id'||l_party_id);
181: oe_debug_pub.add('Org id'||l_payer.org_id);
182: oe_debug_pub.add('cust acct id'||l_invoice_to_org_id);
183: oe_debug_pub.add('acct site id'||l_invoice_to_cust_id);
184: END IF;

Line 181: oe_debug_pub.add('Org id'||l_payer.org_id);

177:
178: IF l_debug_level > 0 THEN
179: oe_debug_pub.add('Payer context values in Defaulting package');
180: oe_debug_pub.add('Party id'||l_party_id);
181: oe_debug_pub.add('Org id'||l_payer.org_id);
182: oe_debug_pub.add('cust acct id'||l_invoice_to_org_id);
183: oe_debug_pub.add('acct site id'||l_invoice_to_cust_id);
184: END IF;
185:

Line 182: oe_debug_pub.add('cust acct id'||l_invoice_to_org_id);

178: IF l_debug_level > 0 THEN
179: oe_debug_pub.add('Payer context values in Defaulting package');
180: oe_debug_pub.add('Party id'||l_party_id);
181: oe_debug_pub.add('Org id'||l_payer.org_id);
182: oe_debug_pub.add('cust acct id'||l_invoice_to_org_id);
183: oe_debug_pub.add('acct site id'||l_invoice_to_cust_id);
184: END IF;
185:
186: --payer equivalency value of g_payer_equiv_upward means to retrieve from

Line 183: oe_debug_pub.add('acct site id'||l_invoice_to_cust_id);

179: oe_debug_pub.add('Payer context values in Defaulting package');
180: oe_debug_pub.add('Party id'||l_party_id);
181: oe_debug_pub.add('Org id'||l_payer.org_id);
182: oe_debug_pub.add('cust acct id'||l_invoice_to_org_id);
183: oe_debug_pub.add('acct site id'||l_invoice_to_cust_id);
184: END IF;
185:
186: --payer equivalency value of g_payer_equiv_upward means to retrieve from
187: --if out found at the current transaction level higher level,

Line 202: oe_debug_pub.add('Return status after Get_Trxn_Appl_Instr_Assign is: '||l_return_status, 3);

198: X_assignments => l_assignments,
199: X_response => l_response_code);
200:
201: IF l_debug_level > 0 THEN
202: oe_debug_pub.add('Return status after Get_Trxn_Appl_Instr_Assign is: '||l_return_status, 3);
203: oe_debug_pub.add('assignment id is: '||l_assignments(1).instrument.instrument_id, 3);
204: END IF;
205:
206: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

Line 203: oe_debug_pub.add('assignment id is: '||l_assignments(1).instrument.instrument_id, 3);

199: X_response => l_response_code);
200:
201: IF l_debug_level > 0 THEN
202: oe_debug_pub.add('Return status after Get_Trxn_Appl_Instr_Assign is: '||l_return_status, 3);
203: oe_debug_pub.add('assignment id is: '||l_assignments(1).instrument.instrument_id, 3);
204: END IF;
205:
206: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
207: IF l_debug_level > 0 THEN

Line 208: oe_debug_pub.add('Result error code in Get_Trxn_Appl_Instr_Assign'||l_response_code.result_code);

204: END IF;
205:
206: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
207: IF l_debug_level > 0 THEN
208: oe_debug_pub.add('Result error code in Get_Trxn_Appl_Instr_Assign'||l_response_code.result_code);
209: END IF;
210: RAISE FND_API.G_EXC_ERROR;
211: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
212: IF l_debug_level > 0 THEN

Line 213: oe_debug_pub.add('Result error code in Get_Trxn_Appl_Instr_Assign'||l_response_code.result_code);

209: END IF;
210: RAISE FND_API.G_EXC_ERROR;
211: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
212: IF l_debug_level > 0 THEN
213: oe_debug_pub.add('Result error code in Get_Trxn_Appl_Instr_Assign'||l_response_code.result_code);
214: END IF;
215: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
216: ELSIF l_return_status =FND_API.G_RET_STS_SUCCESS THEN
217: IF l_debug_level > 0 THEN

Line 218: oe_debug_pub.add('Get_Trxn_Appl_Instr_Assign Successful....'||l_assignments(1).instrument.instrument_id);

214: END IF;
215: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
216: ELSIF l_return_status =FND_API.G_RET_STS_SUCCESS THEN
217: IF l_debug_level > 0 THEN
218: oe_debug_pub.add('Get_Trxn_Appl_Instr_Assign Successful....'||l_assignments(1).instrument.instrument_id);
219: oe_debug_pub.add('After calling Get_Trxn_Appl_Instr_Assign');
220: END IF;
221: END IF;
222:

Line 219: oe_debug_pub.add('After calling Get_Trxn_Appl_Instr_Assign');

215: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
216: ELSIF l_return_status =FND_API.G_RET_STS_SUCCESS THEN
217: IF l_debug_level > 0 THEN
218: oe_debug_pub.add('Get_Trxn_Appl_Instr_Assign Successful....'||l_assignments(1).instrument.instrument_id);
219: oe_debug_pub.add('After calling Get_Trxn_Appl_Instr_Assign');
220: END IF;
221: END IF;
222:
223: IF l_debug_level > 0 THEN

Line 224: oe_debug_pub.add('Calling IBY_FNDCPT_SETUP_PUB.Get_Card.',3);

220: END IF;
221: END IF;
222:
223: IF l_debug_level > 0 THEN
224: oe_debug_pub.add('Calling IBY_FNDCPT_SETUP_PUB.Get_Card.',3);
225: END IF;
226:
227:
228: IBY_FNDCPT_SETUP_PUB.Get_Card

Line 238: oe_debug_pub.add('Return status after IBY_FNDCPT_SETUP_PUB.Get_Card.'||l_return_status, 3);

234: X_card_instrument => l_card_instrument,
235: X_response => l_response_code);
236:
237: IF l_debug_level > 0 THEN
238: oe_debug_pub.add('Return status after IBY_FNDCPT_SETUP_PUB.Get_Card.'||l_return_status, 3);
239: END IF;
240:
241: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
242: IF l_debug_level > 0 THEN

Line 243: oe_debug_pub.add('Result error code in Get_Card'||l_response_code.result_code);

239: END IF;
240:
241: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
242: IF l_debug_level > 0 THEN
243: oe_debug_pub.add('Result error code in Get_Card'||l_response_code.result_code);
244: END IF;
245: RAISE FND_API.G_EXC_ERROR;
246: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
247: IF l_debug_level > 0 THEN

Line 248: oe_debug_pub.add('Result error code in Get_Card'||l_response_code.result_code);

244: END IF;
245: RAISE FND_API.G_EXC_ERROR;
246: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
247: IF l_debug_level > 0 THEN
248: oe_debug_pub.add('Result error code in Get_Card'||l_response_code.result_code);
249: END IF;
250: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
251: ELSIF l_return_status =FND_API.G_RET_STS_SUCCESS THEN
252: IF l_debug_level > 0 THEN

Line 253: oe_debug_pub.add('Get_Card Successful....');

249: END IF;
250: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
251: ELSIF l_return_status =FND_API.G_RET_STS_SUCCESS THEN
252: IF l_debug_level > 0 THEN
253: oe_debug_pub.add('Get_Card Successful....');
254: oe_debug_pub.add('After calling Get_Card');
255: oe_debug_pub.add('Card values in Defaulting package');
256: --oe_debug_pub.add('card_number'||l_card_instrument.card_number);
257: --oe_debug_pub.add('expiration_date'||l_card_instrument.expiration_date);

Line 254: oe_debug_pub.add('After calling Get_Card');

250: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
251: ELSIF l_return_status =FND_API.G_RET_STS_SUCCESS THEN
252: IF l_debug_level > 0 THEN
253: oe_debug_pub.add('Get_Card Successful....');
254: oe_debug_pub.add('After calling Get_Card');
255: oe_debug_pub.add('Card values in Defaulting package');
256: --oe_debug_pub.add('card_number'||l_card_instrument.card_number);
257: --oe_debug_pub.add('expiration_date'||l_card_instrument.expiration_date);
258: --oe_debug_pub.add('Card_Holder_Name'||l_card_instrument.Card_Holder_Name);

Line 255: oe_debug_pub.add('Card values in Defaulting package');

251: ELSIF l_return_status =FND_API.G_RET_STS_SUCCESS THEN
252: IF l_debug_level > 0 THEN
253: oe_debug_pub.add('Get_Card Successful....');
254: oe_debug_pub.add('After calling Get_Card');
255: oe_debug_pub.add('Card values in Defaulting package');
256: --oe_debug_pub.add('card_number'||l_card_instrument.card_number);
257: --oe_debug_pub.add('expiration_date'||l_card_instrument.expiration_date);
258: --oe_debug_pub.add('Card_Holder_Name'||l_card_instrument.Card_Holder_Name);
259: --oe_debug_pub.add('card_id'||l_card_instrument.card_id);

Line 256: --oe_debug_pub.add('card_number'||l_card_instrument.card_number);

252: IF l_debug_level > 0 THEN
253: oe_debug_pub.add('Get_Card Successful....');
254: oe_debug_pub.add('After calling Get_Card');
255: oe_debug_pub.add('Card values in Defaulting package');
256: --oe_debug_pub.add('card_number'||l_card_instrument.card_number);
257: --oe_debug_pub.add('expiration_date'||l_card_instrument.expiration_date);
258: --oe_debug_pub.add('Card_Holder_Name'||l_card_instrument.Card_Holder_Name);
259: --oe_debug_pub.add('card_id'||l_card_instrument.card_id);
260: oe_debug_pub.add('Instrument_id'||l_assignments(1).instrument.instrument_id);

Line 257: --oe_debug_pub.add('expiration_date'||l_card_instrument.expiration_date);

253: oe_debug_pub.add('Get_Card Successful....');
254: oe_debug_pub.add('After calling Get_Card');
255: oe_debug_pub.add('Card values in Defaulting package');
256: --oe_debug_pub.add('card_number'||l_card_instrument.card_number);
257: --oe_debug_pub.add('expiration_date'||l_card_instrument.expiration_date);
258: --oe_debug_pub.add('Card_Holder_Name'||l_card_instrument.Card_Holder_Name);
259: --oe_debug_pub.add('card_id'||l_card_instrument.card_id);
260: oe_debug_pub.add('Instrument_id'||l_assignments(1).instrument.instrument_id);
261: oe_debug_pub.add('assign id'||l_assignments(1).assignment_id);

Line 258: --oe_debug_pub.add('Card_Holder_Name'||l_card_instrument.Card_Holder_Name);

254: oe_debug_pub.add('After calling Get_Card');
255: oe_debug_pub.add('Card values in Defaulting package');
256: --oe_debug_pub.add('card_number'||l_card_instrument.card_number);
257: --oe_debug_pub.add('expiration_date'||l_card_instrument.expiration_date);
258: --oe_debug_pub.add('Card_Holder_Name'||l_card_instrument.Card_Holder_Name);
259: --oe_debug_pub.add('card_id'||l_card_instrument.card_id);
260: oe_debug_pub.add('Instrument_id'||l_assignments(1).instrument.instrument_id);
261: oe_debug_pub.add('assign id'||l_assignments(1).assignment_id);
262: END IF;

Line 259: --oe_debug_pub.add('card_id'||l_card_instrument.card_id);

255: oe_debug_pub.add('Card values in Defaulting package');
256: --oe_debug_pub.add('card_number'||l_card_instrument.card_number);
257: --oe_debug_pub.add('expiration_date'||l_card_instrument.expiration_date);
258: --oe_debug_pub.add('Card_Holder_Name'||l_card_instrument.Card_Holder_Name);
259: --oe_debug_pub.add('card_id'||l_card_instrument.card_id);
260: oe_debug_pub.add('Instrument_id'||l_assignments(1).instrument.instrument_id);
261: oe_debug_pub.add('assign id'||l_assignments(1).assignment_id);
262: END IF;
263: END IF;

Line 260: oe_debug_pub.add('Instrument_id'||l_assignments(1).instrument.instrument_id);

256: --oe_debug_pub.add('card_number'||l_card_instrument.card_number);
257: --oe_debug_pub.add('expiration_date'||l_card_instrument.expiration_date);
258: --oe_debug_pub.add('Card_Holder_Name'||l_card_instrument.Card_Holder_Name);
259: --oe_debug_pub.add('card_id'||l_card_instrument.card_id);
260: oe_debug_pub.add('Instrument_id'||l_assignments(1).instrument.instrument_id);
261: oe_debug_pub.add('assign id'||l_assignments(1).assignment_id);
262: END IF;
263: END IF;
264:

Line 261: oe_debug_pub.add('assign id'||l_assignments(1).assignment_id);

257: --oe_debug_pub.add('expiration_date'||l_card_instrument.expiration_date);
258: --oe_debug_pub.add('Card_Holder_Name'||l_card_instrument.Card_Holder_Name);
259: --oe_debug_pub.add('card_id'||l_card_instrument.card_id);
260: oe_debug_pub.add('Instrument_id'||l_assignments(1).instrument.instrument_id);
261: oe_debug_pub.add('assign id'||l_assignments(1).assignment_id);
262: END IF;
263: END IF;
264:
265:

Line 293: --oe_debug_pub.add('returned card number is: '||l_card_instrument.card_number);

289:
290: --R12 CC Encryption
291:
292: --IF l_debug_level > 0 THEN
293: --oe_debug_pub.add('returned card number is: '||l_card_instrument.card_number);
294: --END IF;
295:
296: RETURN l_card_instrument.card_number;
297:

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

394: SELECT sold_to_org_id, invoice_to_org_id
395: from oe_order_lines_all
396: where line_id = x_line_id;
397:
398: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
399: l_credit_card_number VARCHAR2(80) := NULL;
400: l_cust_org_id number;
401: l_invoice_to_org_id number;
402:

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

529: AND account_type='EXTERNAL'
530: AND rownum=1;
531: **/
532: --
533: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
534: --
535: l_credit_card_number VARCHAR2(80) := NULL;
536:
537: BEGIN

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

646: AND tax.status_code = 'PRIMARY'
647: AND ROWNUM = 1;
648: ***/
649: --
650: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
651: --
652: BEGIN
653: /***
654: IF ONT_HEADER_DEF_HDLR.g_record.ship_to_org_id IS NOT NULL AND

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

709: AND tax.status_code = 'PRIMARY'
710: AND ROWNUM = 1;
711: ***/
712: --
713: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
714: --
715: BEGIN
716: /***
717: IF ONT_HEADER_DEF_HDLR.g_record.ship_to_org_id IS NOT NULL AND

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

790: AND site_use.cust_acct_site_id = acct_site.cust_acct_site_id
791: and acct_site.cust_account_id = cust_acct.cust_account_id;
792:
793: --
794: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
795: --
796: BEGIN
797:
798: l_line_type_rec := oe_order_cache.load_line_type(ONT_LINE_DEF_HDLR.g_record.line_type_id);

Line 820: oe_debug_pub.add( 'Do not default tax exempt because flag is standard');

816: -- bug 5485367 when tax_exempt_flag is 'S', shouldn't have any tax_exempt_number
817: -- without tax_exempt_number, tax_exempt_reason is not necessary either
818: -- so the following defaulting code is no longer used
819: IF l_debug_level > 0 THEN
820: oe_debug_pub.add( 'Do not default tax exempt because flag is standard');
821: END IF;
822: RETURN NULL;
823: -- Check whether the attribute has got a value in privious call to
824: -- the related attribute.

Line 1003: oe_debug_pub.add( 'DEFAULTED TAX EXEMPT NUMBER/REASON '||L_TAX_EXEMPT_NUMBER|| '/' || L_TAX_EXEMPT_REASON_CODE ) ;

999: IF (ONT_LINE_Def_Hdlr.g_record.tax_exempt_reason_code = FND_API.G_MISS_CHAR
1000: AND ONT_LINE_Def_Hdlr.g_record.tax_exempt_number = FND_API.G_MISS_CHAR)
1001: THEN
1002: IF l_debug_level > 0 THEN
1003: oe_debug_pub.add( 'DEFAULTED TAX EXEMPT NUMBER/REASON '||L_TAX_EXEMPT_NUMBER|| '/' || L_TAX_EXEMPT_REASON_CODE ) ;
1004: END IF;
1005:
1006: ONT_LINE_Def_Hdlr.g_record.tax_exempt_number := l_tax_exempt_number;
1007: ONT_LINE_Def_Hdlr.g_record.tax_exempt_reason_code := l_tax_exempt_reason_code;

Line 1012: oe_debug_pub.add( 'DEFAULTED TAX EXEMPT NUMBER '||L_TAX_EXEMPT_NUMBER) ;

1008: END IF;--bug5184842
1009:
1010: IF p_attribute_code = 'TAX_EXEMPT_NUMBER' THEN
1011: IF l_debug_level > 0 THEN
1012: oe_debug_pub.add( 'DEFAULTED TAX EXEMPT NUMBER '||L_TAX_EXEMPT_NUMBER) ;
1013: END IF;
1014:
1015: RETURN l_tax_exempt_number;
1016: ELSIF p_attribute_code = 'TAX_EXEMPT_REASON' THEN

Line 1018: oe_debug_pub.add( 'DEFAULTED TAX EXEMPT REASON '||L_TAX_EXEMPT_REASON_CODE ) ;

1014:
1015: RETURN l_tax_exempt_number;
1016: ELSIF p_attribute_code = 'TAX_EXEMPT_REASON' THEN
1017: IF l_debug_level > 0 THEN
1018: oe_debug_pub.add( 'DEFAULTED TAX EXEMPT REASON '||L_TAX_EXEMPT_REASON_CODE ) ;
1019: END IF;
1020: RETURN l_tax_exempt_reason_code;
1021: END IF;
1022:

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

1054: IS
1055: X_Currency_Code VARCHAR2(15);
1056: l_set_of_books_rec OE_Order_Cache.Set_Of_Books_Rec_Type;
1057: --
1058: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1059: --
1060: BEGIN
1061:
1062: l_set_of_books_rec :=

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

1121: WHERE CUST_TRX_TYPE_ID = l_cust_trx_type_id;
1122: */
1123: /* added by Renga for bug 1476390 */
1124: --
1125: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1126: --
1127: BEGIN
1128: IF l_debug_level > 0 THEN
1129: oe_debug_pub.add( 'ENTERING OE_DEFAULT_PVT.GET_TAX_CODE' , 1 ) ;

Line 1129: oe_debug_pub.add( 'ENTERING OE_DEFAULT_PVT.GET_TAX_CODE' , 1 ) ;

1125: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1126: --
1127: BEGIN
1128: IF l_debug_level > 0 THEN
1129: oe_debug_pub.add( 'ENTERING OE_DEFAULT_PVT.GET_TAX_CODE' , 1 ) ;
1130: END IF;
1131:
1132: Begin
1133: --bug4333881 start

Line 1135: oe_debug_pub.add('line_id : ' || ONT_LINE_DEF_HDLR.g_record.line_id);

1131:
1132: Begin
1133: --bug4333881 start
1134: IF l_debug_level > 0 THEN
1135: oe_debug_pub.add('line_id : ' || ONT_LINE_DEF_HDLR.g_record.line_id);
1136: oe_debug_pub.add('commitment_id : ' || ONT_LINE_DEF_HDLR.g_record.commitment_id);
1137: END IF;
1138:
1139: l_commitment_id := ONT_LINE_DEF_HDLR.g_record.commitment_id;

Line 1136: oe_debug_pub.add('commitment_id : ' || ONT_LINE_DEF_HDLR.g_record.commitment_id);

1132: Begin
1133: --bug4333881 start
1134: IF l_debug_level > 0 THEN
1135: oe_debug_pub.add('line_id : ' || ONT_LINE_DEF_HDLR.g_record.line_id);
1136: oe_debug_pub.add('commitment_id : ' || ONT_LINE_DEF_HDLR.g_record.commitment_id);
1137: END IF;
1138:
1139: l_commitment_id := ONT_LINE_DEF_HDLR.g_record.commitment_id;
1140:

Line 1151: oe_debug_pub.add( 'value of commitment customer trx type id '||l_cust_trx_type_id,1);

1147: WHERE cust_type.cust_trx_type_id = cust_trx.cust_trx_type_id
1148: AND cust_trx.customer_trx_id = l_commitment_id;
1149:
1150: IF l_debug_level > 0 THEN
1151: oe_debug_pub.add( 'value of commitment customer trx type id '||l_cust_trx_type_id,1);
1152: END IF;
1153:
1154: EXCEPTION
1155: WHEN NO_DATA_FOUND THEN

Line 1162: oe_debug_pub.add( 'value of customer trx type id '||l_cust_trx_type_id,1);

1158: RETURN null;
1159: END;
1160: ELSE
1161: l_cust_trx_type_id := OE_Invoice_PUB.Get_Customer_Transaction_Type(ONT_LINE_DEF_HDLR.g_record);
1162: oe_debug_pub.add( 'value of customer trx type id '||l_cust_trx_type_id,1);
1163: END IF;
1164: --bug4333881 end
1165:
1166: --bug 3175277 begin

Line 1172: oe_debug_pub.add( 'customer trx type id:'||l_cust_trx_type_id,1);

1168: --OE_Invoice_PUB.Get_Customer_Transaction_Type checks the line_type cache to get cust_trx_type_id
1169: /*if (l_cust_trx_type_id = 0 or l_cust_trx_type_id is null) then
1170: l_line_type_rec := oe_order_cache.load_line_type(ONT_LINE_DEF_HDLR.g_record.line_type_id);
1171: l_cust_trx_type_id := l_line_type_rec.cust_trx_type_id;
1172: oe_debug_pub.add( 'customer trx type id:'||l_cust_trx_type_id,1);
1173: end if; */
1174: --bug 3175277 end
1175:
1176: -- performance fix for bug 4200055

Line 1195: oe_debug_pub.add('l_calculate_tax_flag : '|| l_calculate_tax_flag);

1191: -- end bug 4200055
1192: --l_line_type_rec := oe_order_cache.load_line_type(ONT_LINE_DEF_HDLR.g_record.line_type_id);
1193:
1194: IF l_debug_level > 0 THEN
1195: oe_debug_pub.add('l_calculate_tax_flag : '|| l_calculate_tax_flag);
1196: END IF;
1197:
1198: IF nvl(ONT_LINE_DEF_HDLR.g_record.tax_exempt_flag, 'S') <> 'R' AND
1199: l_calculate_tax_flag = 'N' THEN

Line 1206: oe_debug_pub.add(' in no data found for cust_trx_type_id - tax code ');

1202: END IF;
1203:
1204: EXCEPTION
1205: WHEN No_Data_Found THEN
1206: oe_debug_pub.add(' in no data found for cust_trx_type_id - tax code ');
1207: RETURN NULL;
1208:
1209: WHEN OTHERS THEN
1210: oe_debug_pub.add(' in when others for cust_trx_type_code - tax code' );

Line 1210: oe_debug_pub.add(' in when others for cust_trx_type_code - tax code' );

1206: oe_debug_pub.add(' in no data found for cust_trx_type_id - tax code ');
1207: RETURN NULL;
1208:
1209: WHEN OTHERS THEN
1210: oe_debug_pub.add(' in when others for cust_trx_type_code - tax code' );
1211: End;
1212:
1213: IF ONT_LINE_DEF_HDLR.g_record.inventory_item_id IS NOT NULL AND
1214: ONT_LINE_DEF_HDLR.g_record.inventory_item_id <> FND_API.G_MISS_NUM AND

Line 1230: oe_debug_pub.add( 'SHIP_TO'||TO_CHAR ( ONT_LINE_DEF_HDLR.G_RECORD.SHIP_TO_ORG_ID ) , 3 ) ;

1226: l_organization_id := OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID', l_org_id);
1227:
1228:
1229: IF l_debug_level > 0 THEN
1230: oe_debug_pub.add( 'SHIP_TO'||TO_CHAR ( ONT_LINE_DEF_HDLR.G_RECORD.SHIP_TO_ORG_ID ) , 3 ) ;
1231: END IF;
1232: IF l_debug_level > 0 THEN
1233: oe_debug_pub.add( 'BILL_TO'||TO_CHAR ( ONT_LINE_DEF_HDLR.G_RECORD.INVOICE_TO_ORG_ID ) , 3 ) ;
1234: END IF;

Line 1233: oe_debug_pub.add( 'BILL_TO'||TO_CHAR ( ONT_LINE_DEF_HDLR.G_RECORD.INVOICE_TO_ORG_ID ) , 3 ) ;

1229: IF l_debug_level > 0 THEN
1230: oe_debug_pub.add( 'SHIP_TO'||TO_CHAR ( ONT_LINE_DEF_HDLR.G_RECORD.SHIP_TO_ORG_ID ) , 3 ) ;
1231: END IF;
1232: IF l_debug_level > 0 THEN
1233: oe_debug_pub.add( 'BILL_TO'||TO_CHAR ( ONT_LINE_DEF_HDLR.G_RECORD.INVOICE_TO_ORG_ID ) , 3 ) ;
1234: END IF;
1235: IF l_debug_level > 0 THEN
1236: oe_debug_pub.add( 'TAX_DATE'||TO_CHAR ( ONT_LINE_DEF_HDLR.G_RECORD.TAX_DATE ) , 3 ) ;
1237: END IF;

Line 1236: oe_debug_pub.add( 'TAX_DATE'||TO_CHAR ( ONT_LINE_DEF_HDLR.G_RECORD.TAX_DATE ) , 3 ) ;

1232: IF l_debug_level > 0 THEN
1233: oe_debug_pub.add( 'BILL_TO'||TO_CHAR ( ONT_LINE_DEF_HDLR.G_RECORD.INVOICE_TO_ORG_ID ) , 3 ) ;
1234: END IF;
1235: IF l_debug_level > 0 THEN
1236: oe_debug_pub.add( 'TAX_DATE'||TO_CHAR ( ONT_LINE_DEF_HDLR.G_RECORD.TAX_DATE ) , 3 ) ;
1237: END IF;
1238: IF l_debug_level > 0 THEN
1239: oe_debug_pub.add( 'SOLD TO'||TO_CHAR ( ONT_LINE_DEF_HDLR.G_RECORD.SOLD_TO_ORG_ID ) , 3 ) ;
1240: END IF;

Line 1239: oe_debug_pub.add( 'SOLD TO'||TO_CHAR ( ONT_LINE_DEF_HDLR.G_RECORD.SOLD_TO_ORG_ID ) , 3 ) ;

1235: IF l_debug_level > 0 THEN
1236: oe_debug_pub.add( 'TAX_DATE'||TO_CHAR ( ONT_LINE_DEF_HDLR.G_RECORD.TAX_DATE ) , 3 ) ;
1237: END IF;
1238: IF l_debug_level > 0 THEN
1239: oe_debug_pub.add( 'SOLD TO'||TO_CHAR ( ONT_LINE_DEF_HDLR.G_RECORD.SOLD_TO_ORG_ID ) , 3 ) ;
1240: END IF;
1241: IF l_debug_level > 0 THEN
1242: oe_debug_pub.add( 'ORG'||TO_CHAR ( L_ORG_ID ) , 3 ) ;
1243: END IF;

Line 1242: oe_debug_pub.add( 'ORG'||TO_CHAR ( L_ORG_ID ) , 3 ) ;

1238: IF l_debug_level > 0 THEN
1239: oe_debug_pub.add( 'SOLD TO'||TO_CHAR ( ONT_LINE_DEF_HDLR.G_RECORD.SOLD_TO_ORG_ID ) , 3 ) ;
1240: END IF;
1241: IF l_debug_level > 0 THEN
1242: oe_debug_pub.add( 'ORG'||TO_CHAR ( L_ORG_ID ) , 3 ) ;
1243: END IF;
1244: IF l_debug_level > 0 THEN
1245: oe_debug_pub.add( 'ITEM VALIDATION ORG'||TO_CHAR ( L_ORGANIZATION_ID ) , 3 ) ;
1246: END IF;

Line 1245: oe_debug_pub.add( 'ITEM VALIDATION ORG'||TO_CHAR ( L_ORGANIZATION_ID ) , 3 ) ;

1241: IF l_debug_level > 0 THEN
1242: oe_debug_pub.add( 'ORG'||TO_CHAR ( L_ORG_ID ) , 3 ) ;
1243: END IF;
1244: IF l_debug_level > 0 THEN
1245: oe_debug_pub.add( 'ITEM VALIDATION ORG'||TO_CHAR ( L_ORGANIZATION_ID ) , 3 ) ;
1246: END IF;
1247: IF l_debug_level > 0 THEN
1248: oe_debug_pub.add( 'ITEM_ID'||TO_CHAR ( ONT_LINE_DEF_HDLR.G_RECORD.INVENTORY_ITEM_ID ) , 3 ) ;
1249: END IF;

Line 1248: oe_debug_pub.add( 'ITEM_ID'||TO_CHAR ( ONT_LINE_DEF_HDLR.G_RECORD.INVENTORY_ITEM_ID ) , 3 ) ;

1244: IF l_debug_level > 0 THEN
1245: oe_debug_pub.add( 'ITEM VALIDATION ORG'||TO_CHAR ( L_ORGANIZATION_ID ) , 3 ) ;
1246: END IF;
1247: IF l_debug_level > 0 THEN
1248: oe_debug_pub.add( 'ITEM_ID'||TO_CHAR ( ONT_LINE_DEF_HDLR.G_RECORD.INVENTORY_ITEM_ID ) , 3 ) ;
1249: END IF;
1250: IF l_debug_level > 0 THEN
1251: oe_debug_pub.add( 'SHIP_FROM'||TO_CHAR ( ONT_LINE_DEF_HDLR.G_RECORD.SHIP_FROM_ORG_ID ) ) ;
1252: END IF;

Line 1251: oe_debug_pub.add( 'SHIP_FROM'||TO_CHAR ( ONT_LINE_DEF_HDLR.G_RECORD.SHIP_FROM_ORG_ID ) ) ;

1247: IF l_debug_level > 0 THEN
1248: oe_debug_pub.add( 'ITEM_ID'||TO_CHAR ( ONT_LINE_DEF_HDLR.G_RECORD.INVENTORY_ITEM_ID ) , 3 ) ;
1249: END IF;
1250: IF l_debug_level > 0 THEN
1251: oe_debug_pub.add( 'SHIP_FROM'||TO_CHAR ( ONT_LINE_DEF_HDLR.G_RECORD.SHIP_FROM_ORG_ID ) ) ;
1252: END IF;
1253:
1254: IF l_organization_id IS NOT NULL AND
1255: l_organization_id <> FND_API.G_MISS_NUM

Line 1259: oe_debug_pub.add( 'REN 1' , 3 ) ;

1255: l_organization_id <> FND_API.G_MISS_NUM
1256: THEN
1257:
1258: IF l_debug_level > 0 THEN
1259: oe_debug_pub.add( 'REN 1' , 3 ) ;
1260: END IF;
1261: -- Get Set of book ID
1262: l_set_of_books_rec := OE_Order_Cache.Load_Set_Of_Books;
1263: l_Set_Of_Books_Id := l_set_of_books_rec.set_of_books_id;

Line 1264: oe_debug_pub.add('Set of books id:'||l_set_of_books_id , 3 ) ;

1260: END IF;
1261: -- Get Set of book ID
1262: l_set_of_books_rec := OE_Order_Cache.Load_Set_Of_Books;
1263: l_Set_Of_Books_Id := l_set_of_books_rec.set_of_books_id;
1264: oe_debug_pub.add('Set of books id:'||l_set_of_books_id , 3 ) ;
1265:
1266: IF l_debug_level > 0 THEN
1267: oe_debug_pub.add( 'REN 2' , 3 ) ;
1268: END IF;

Line 1267: oe_debug_pub.add( 'REN 2' , 3 ) ;

1263: l_Set_Of_Books_Id := l_set_of_books_rec.set_of_books_id;
1264: oe_debug_pub.add('Set of books id:'||l_set_of_books_id , 3 ) ;
1265:
1266: IF l_debug_level > 0 THEN
1267: oe_debug_pub.add( 'REN 2' , 3 ) ;
1268: END IF;
1269:
1270:
1271: --bug 3175277

Line 1273: oe_debug_pub.add('trx type id:'||l_trx_type_id , 3 ) ;

1269:
1270:
1271: --bug 3175277
1272: l_trx_type_id := l_cust_trx_type_id;
1273: oe_debug_pub.add('trx type id:'||l_trx_type_id , 3 ) ;
1274:
1275: -- Call the AR's API to get the default tax code
1276:
1277: --bsadri caching the values

Line 1295: oe_debug_pub.add( 'REN INSIDE TC 1 ' , 3 ) ;

1291: nvl( OE_Order_Cache.g_TAX_CODE_CACH.trx_type_id,FND_API.G_MISS_NUM)
1292: THEN
1293:
1294: IF l_debug_level > 0 THEN
1295: oe_debug_pub.add( 'REN INSIDE TC 1 ' , 3 ) ;
1296: END IF;
1297:
1298:
1299: zx_ar_tax_classificatn_def_pkg.get_default_tax_classification(

Line 1335: oe_debug_pub.add( 'DEFAULTED TAX CODE IS '||X_TAX_CODE ) ;

1331:
1332: END IF; /* if cached values are different than passed values */
1333:
1334: IF l_debug_level > 0 THEN
1335: oe_debug_pub.add( 'DEFAULTED TAX CODE IS '||X_TAX_CODE ) ;
1336: END IF;
1337: IF (x_tax_code IS NOT NULL) THEN
1338: RETURN x_tax_code;
1339: END IF;

Line 1346: oe_debug_pub.add( 'EXITING OE_DEFAULT_PVT.GET_TAX_CODE' , 1 ) ;

1342:
1343: END IF; /* if inventory_item_id and tax_date are not null and not missing */
1344:
1345: IF l_debug_level > 0 THEN
1346: oe_debug_pub.add( 'EXITING OE_DEFAULT_PVT.GET_TAX_CODE' , 1 ) ;
1347: END IF;
1348: RETURN NULL;
1349:
1350: EXCEPTION

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

1381: l_commitment_bal NUMBER;
1382:
1383:
1384: --
1385: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1386: --
1387: BEGIN
1388:
1389: IF l_debug_level > 0 THEN

Line 1390: oe_debug_pub.add( 'ENTERING OE_DEFAULT_PVT.GET_COMMITMENT_FROM_AGREEMENT' , 1 ) ;

1386: --
1387: BEGIN
1388:
1389: IF l_debug_level > 0 THEN
1390: oe_debug_pub.add( 'ENTERING OE_DEFAULT_PVT.GET_COMMITMENT_FROM_AGREEMENT' , 1 ) ;
1391: END IF;
1392:
1393: IF ONT_LINE_Def_Hdlr.g_record.Agreement_id IS NOT NULL THEN
1394: SELECT transactional_curr_code

Line 1400: oe_debug_pub.add( 'AGREEMENT_ID: '||ONT_LINE_DEF_HDLR.G_RECORD.AGREEMENT_ID|| ' L_TRANS_CURR_CODE: '||L_TRANS_CURR_CODE ||' SOLD TO ORG: '||ONT_LINE_DEF_HDLR.G_RECORD.SOLD_TO_ORG_ID ) ;

1396: FROM oe_order_headers
1397: WHERE header_id = ONT_LINE_Def_Hdlr.g_record.header_id;
1398:
1399: IF l_debug_level > 0 THEN
1400: oe_debug_pub.add( 'AGREEMENT_ID: '||ONT_LINE_DEF_HDLR.G_RECORD.AGREEMENT_ID|| ' L_TRANS_CURR_CODE: '||L_TRANS_CURR_CODE ||' SOLD TO ORG: '||ONT_LINE_DEF_HDLR.G_RECORD.SOLD_TO_ORG_ID ) ;
1401: END IF;
1402:
1403: --Bug 3247840 fix query for better performance
1404: SELECT /* MOAC_SQL_CHANGE */ customer_trx_id

Line 1456: oe_debug_pub.add( 'OEXVDEFB: COMMITMENT BALANCE IS: '||L_COMMITMENT_BAL ) ;

1452: ,l_so_source_code
1453: ,l_oe_installed_flag );
1454:
1455: IF l_debug_level > 0 THEN
1456: oe_debug_pub.add( 'OEXVDEFB: COMMITMENT BALANCE IS: '||L_COMMITMENT_BAL ) ;
1457: END IF;
1458:
1459: IF l_commitment_bal > 0 THEN
1460: IF l_debug_level > 0 THEN

Line 1461: oe_debug_pub.add( 'AGREEMENT IS NOT NULL - RETURNING COMMITMENT: '||L_COMMITMENT_ID ) ;

1457: END IF;
1458:
1459: IF l_commitment_bal > 0 THEN
1460: IF l_debug_level > 0 THEN
1461: oe_debug_pub.add( 'AGREEMENT IS NOT NULL - RETURNING COMMITMENT: '||L_COMMITMENT_ID ) ;
1462: END IF;
1463: RETURN l_Commitment_id;
1464: ELSE
1465: IF l_debug_level > 0 THEN

Line 1466: oe_debug_pub.add( 'COMMITMENT BALANCE IS ZERO - RETURNING NULL COMMITMENT' ) ;

1462: END IF;
1463: RETURN l_Commitment_id;
1464: ELSE
1465: IF l_debug_level > 0 THEN
1466: oe_debug_pub.add( 'COMMITMENT BALANCE IS ZERO - RETURNING NULL COMMITMENT' ) ;
1467: END IF;
1468: RETURN NULL;
1469: END IF;
1470:

Line 1473: oe_debug_pub.add( 'AGREEMENT IS NULL ON LINE - RETURNING NULL COMMITMENT' ) ;

1469: END IF;
1470:
1471: ELSE
1472: IF l_debug_level > 0 THEN
1473: oe_debug_pub.add( 'AGREEMENT IS NULL ON LINE - RETURNING NULL COMMITMENT' ) ;
1474: END IF;
1475: RETURN NULL;
1476: END IF;
1477:

Line 1479: oe_debug_pub.add( 'EXITING OE_DEFAULT_PVT.GET_COMMITMENT_FROM_AGREEMENT' , 1 ) ;

1475: RETURN NULL;
1476: END IF;
1477:
1478: IF l_debug_level > 0 THEN
1479: oe_debug_pub.add( 'EXITING OE_DEFAULT_PVT.GET_COMMITMENT_FROM_AGREEMENT' , 1 ) ;
1480: END IF;
1481: EXCEPTION
1482: WHEN NO_DATA_FOUND THEN
1483: IF l_debug_level > 0 THEN

Line 1484: oe_debug_pub.add( 'IN WHEN NO DATA FOUND - RETURNING NULL COMMITMENT' ) ;

1480: END IF;
1481: EXCEPTION
1482: WHEN NO_DATA_FOUND THEN
1483: IF l_debug_level > 0 THEN
1484: oe_debug_pub.add( 'IN WHEN NO DATA FOUND - RETURNING NULL COMMITMENT' ) ;
1485: END IF;
1486: RETURN NULL;
1487: WHEN TOO_MANY_ROWS THEN
1488: IF l_debug_level > 0 THEN

Line 1489: oe_debug_pub.add( 'IN WHEN TOO MANY ROWS - RETURNING NULL COMMITMENT' ) ;

1485: END IF;
1486: RETURN NULL;
1487: WHEN TOO_MANY_ROWS THEN
1488: IF l_debug_level > 0 THEN
1489: oe_debug_pub.add( 'IN WHEN TOO MANY ROWS - RETURNING NULL COMMITMENT' ) ;
1490: END IF;
1491: RETURN NULL;
1492: END Get_Commitment_From_Agreement;
1493:

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

1497: RETURN NUMBER IS
1498: l_accounting_rule_duration NUMBER;
1499: l_rule_type VARCHAR2(10);
1500: --
1501: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1502: --
1503: BEGIN
1504: IF l_debug_level > 0 THEN
1505: oe_debug_pub.add( 'ENTERING OE_DEFAULT_PVT. GET_ACCOUNTING_RULE_DURATION' , 1 ) ;

Line 1505: oe_debug_pub.add( 'ENTERING OE_DEFAULT_PVT. GET_ACCOUNTING_RULE_DURATION' , 1 ) ;

1501: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1502: --
1503: BEGIN
1504: IF l_debug_level > 0 THEN
1505: oe_debug_pub.add( 'ENTERING OE_DEFAULT_PVT. GET_ACCOUNTING_RULE_DURATION' , 1 ) ;
1506: END IF;
1507: IF OE_CODE_CONTROL.Get_Code_Release_Level < '110509' THEN
1508: IF l_debug_level > 0 THEN
1509: oe_debug_pub.add( 'OEXVDEFB: BELOW PACK I , DO NOT DEFAULT ACCOUNTING DURATION' ) ;

Line 1509: oe_debug_pub.add( 'OEXVDEFB: BELOW PACK I , DO NOT DEFAULT ACCOUNTING DURATION' ) ;

1505: oe_debug_pub.add( 'ENTERING OE_DEFAULT_PVT. GET_ACCOUNTING_RULE_DURATION' , 1 ) ;
1506: END IF;
1507: IF OE_CODE_CONTROL.Get_Code_Release_Level < '110509' THEN
1508: IF l_debug_level > 0 THEN
1509: oe_debug_pub.add( 'OEXVDEFB: BELOW PACK I , DO NOT DEFAULT ACCOUNTING DURATION' ) ;
1510: END IF;
1511: RETURN NULL;
1512: END IF;
1513:

Line 1515: oe_debug_pub.add( 'ITEM_TYPE_CODE:'||ONT_LINE_DEF_HDLR.G_RECORD.ITEM_TYPE_CODE||':ACCOUNTING_RULE_ID:'||ONT_LINE_DEF_HDLR.G_RECORD.ACCOUNTING_RULE_ID ) ;

1511: RETURN NULL;
1512: END IF;
1513:
1514: IF l_debug_level > 0 THEN
1515: oe_debug_pub.add( 'ITEM_TYPE_CODE:'||ONT_LINE_DEF_HDLR.G_RECORD.ITEM_TYPE_CODE||':ACCOUNTING_RULE_ID:'||ONT_LINE_DEF_HDLR.G_RECORD.ACCOUNTING_RULE_ID ) ;
1516: END IF;
1517: IF (ONT_LINE_Def_Hdlr.g_record.item_type_code <> 'SERVICE') AND ONT_LINE_Def_Hdlr.g_record.Accounting_Rule_ID IS NOT NULL THEN
1518: SELECT type
1519: INTO l_rule_type

Line 1523: oe_debug_pub.add( 'RULE_TYPE IS:'||L_RULE_TYPE ) ;

1519: INTO l_rule_type
1520: FROM ra_rules
1521: WHERE rule_id= ONT_LINE_Def_Hdlr.g_record.Accounting_Rule_ID;
1522: IF l_debug_level > 0 THEN
1523: oe_debug_pub.add( 'RULE_TYPE IS:'||L_RULE_TYPE ) ;
1524: END IF;
1525: IF l_rule_type = 'ACC_DUR' THEN
1526: SELECT accounting_rule_duration
1527: INTO l_accounting_rule_duration

Line 1531: oe_debug_pub.add( 'EXITING OE_DEFAULT_PVT.GET_ACCOUNTING_RULE_DURATION - DURATION:'|| L_ACCOUNTING_RULE_DURATION ) ;

1527: INTO l_accounting_rule_duration
1528: FROM oe_order_headers
1529: WHERE header_id = ONT_LINE_Def_Hdlr.g_record.header_id;
1530: IF l_debug_level > 0 THEN
1531: oe_debug_pub.add( 'EXITING OE_DEFAULT_PVT.GET_ACCOUNTING_RULE_DURATION - DURATION:'|| L_ACCOUNTING_RULE_DURATION ) ;
1532: END IF;
1533: RETURN l_accounting_rule_duration;
1534: END IF;
1535: END IF;

Line 1538: oe_debug_pub.add( 'EXITING OE_DEFAULT_PVT.GET_ACCOUNTING_RULE_DURATION' ) ;

1534: END IF;
1535: END IF;
1536: RETURN NULL;
1537: IF l_debug_level > 0 THEN
1538: oe_debug_pub.add( 'EXITING OE_DEFAULT_PVT.GET_ACCOUNTING_RULE_DURATION' ) ;
1539: END IF;
1540: EXCEPTION
1541: WHEN OTHERS THEN
1542: IF l_debug_level > 0 THEN

Line 1543: oe_debug_pub.add( 'IN WHEN OTHERS - RETURNING NULL ACCOUNTING RULE DURATION' ) ;

1539: END IF;
1540: EXCEPTION
1541: WHEN OTHERS THEN
1542: IF l_debug_level > 0 THEN
1543: oe_debug_pub.add( 'IN WHEN OTHERS - RETURNING NULL ACCOUNTING RULE DURATION' ) ;
1544: END IF;
1545: RETURN NULL;
1546: END Get_Accounting_Rule_Duration;
1547:

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

1555: IS
1556: l_sold_to_org_id NUMBER;
1557: l_site_use_id NUMBER;
1558: --
1559: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1560: --
1561: BEGIN
1562: l_sold_to_org_id := ONT_HEADER_DEF_HDLR.g_record.SOLD_TO_ORG_ID;
1563: IF l_debug_level > 0 THEN

Line 1564: oe_debug_pub.add('ENTER Get_Primary_Customer_Location');

1560: --
1561: BEGIN
1562: l_sold_to_org_id := ONT_HEADER_DEF_HDLR.g_record.SOLD_TO_ORG_ID;
1563: IF l_debug_level > 0 THEN
1564: oe_debug_pub.add('ENTER Get_Primary_Customer_Location');
1565: oe_debug_pub.add('Sold To Org ID :'||l_sold_to_org_id);
1566: END IF;
1567:
1568: IF l_sold_to_org_id is not null

Line 1565: oe_debug_pub.add('Sold To Org ID :'||l_sold_to_org_id);

1561: BEGIN
1562: l_sold_to_org_id := ONT_HEADER_DEF_HDLR.g_record.SOLD_TO_ORG_ID;
1563: IF l_debug_level > 0 THEN
1564: oe_debug_pub.add('ENTER Get_Primary_Customer_Location');
1565: oe_debug_pub.add('Sold To Org ID :'||l_sold_to_org_id);
1566: END IF;
1567:
1568: IF l_sold_to_org_id is not null
1569: AND l_sold_to_org_id <> fnd_api.g_miss_num

Line 1605: oe_debug_pub.add('Error in Get_Primary_Customer_Location') ;

1601:
1602: EXCEPTION
1603: WHEN OTHERS THEN
1604: IF l_debug_level > 0 THEN
1605: oe_debug_pub.add('Error in Get_Primary_Customer_Location') ;
1606: oe_debug_pub.add('Error :'||substr(sqlerrm,1,200)) ;
1607: END IF;
1608: RETURN NULL;
1609: END Get_Primary_Customer_Location;

Line 1606: oe_debug_pub.add('Error :'||substr(sqlerrm,1,200)) ;

1602: EXCEPTION
1603: WHEN OTHERS THEN
1604: IF l_debug_level > 0 THEN
1605: oe_debug_pub.add('Error in Get_Primary_Customer_Location') ;
1606: oe_debug_pub.add('Error :'||substr(sqlerrm,1,200)) ;
1607: END IF;
1608: RETURN NULL;
1609: END Get_Primary_Customer_Location;
1610:

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

1617: l_pay_method_id NUMBER;
1618: l_payment_type_code VARCHAR2(30);
1619: l_org_id NUMBER ;
1620: --
1621: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1622: --
1623: l_header_id number;
1624: BEGIN
1625: l_org_id:= ONT_HEADER_DEF_HDLR.g_record.org_id;

Line 1627: oe_debug_pub.add('Entering Get_Receipt_Method');

1623: l_header_id number;
1624: BEGIN
1625: l_org_id:= ONT_HEADER_DEF_HDLR.g_record.org_id;
1626: IF l_debug_level > 0 THEN
1627: oe_debug_pub.add('Entering Get_Receipt_Method');
1628: END IF;
1629:
1630: IF p_database_object_name = 'OE_AK_HEADER_PAYMENTS_V' THEN
1631: l_payment_type_code := ONT_HEADER_PAYMENT_DEF_HDLR.g_record.payment_type_code;

Line 1635: oe_debug_pub.add('payment_type_code from header payments'||l_payment_type_code);

1631: l_payment_type_code := ONT_HEADER_PAYMENT_DEF_HDLR.g_record.payment_type_code;
1632: l_header_id := ONT_HEADER_PAYMENT_DEF_HDLR.g_record.header_id;
1633:
1634: IF l_debug_level > 0 THEN
1635: oe_debug_pub.add('payment_type_code from header payments'||l_payment_type_code);
1636: END IF;
1637: ELSIF p_database_object_name = 'OE_AK_LINE_PAYMENTS_V' THEN
1638: l_payment_type_code := ONT_LINE_PAYMENT_DEF_HDLR.g_record.payment_type_code;
1639: l_header_id := ONT_LINE_PAYMENT_DEF_HDLR.g_record.header_id;

Line 1642: oe_debug_pub.add('payment_type_code from line payments'||l_payment_type_code ||':org_id:'||l_org_id);

1638: l_payment_type_code := ONT_LINE_PAYMENT_DEF_HDLR.g_record.payment_type_code;
1639: l_header_id := ONT_LINE_PAYMENT_DEF_HDLR.g_record.header_id;
1640:
1641: IF l_debug_level > 0 THEN
1642: oe_debug_pub.add('payment_type_code from line payments'||l_payment_type_code ||':org_id:'||l_org_id);
1643: END IF;
1644: ELSIF p_database_object_name = 'OE_AK_ORDER_HEADERS_V' THEN
1645: l_header_id := ONT_HEADER_DEF_HDLR.g_record.header_id;
1646: END IF;

Line 1658: oe_debug_pub.add('org_id:'||l_org_id);

1654: into l_org_id
1655: from oe_order_headers_all
1656: where header_id = l_header_id;
1657: IF l_debug_level > 0 THEN
1658: oe_debug_pub.add('org_id:'||l_org_id);
1659: END IF;
1660: END IF;
1661:
1662: select receipt_method_id

Line 1669: oe_debug_pub.add('l_pay_method_id from payment type:'||l_pay_method_id);

1665: where payment_type_code = l_payment_type_code
1666: AND nvl(org_id, -99) = nvl(l_org_id, -99);
1667:
1668: IF l_debug_level > 0 THEN
1669: oe_debug_pub.add('l_pay_method_id from payment type:'||l_pay_method_id);
1670: END IF;
1671: IF l_pay_method_id IS NOT NULL THEN
1672: RETURN l_pay_method_id;
1673: END IF;

Line 1682: oe_debug_pub.add('Sold To Org ID :'||l_header_rec.sold_to_org_id);

1678:
1679: l_header_rec := OE_HEADER_UTIL.Query_Row(l_header_id);
1680:
1681: IF l_debug_level > 0 THEN
1682: oe_debug_pub.add('Sold To Org ID :'||l_header_rec.sold_to_org_id);
1683: oe_debug_pub.add('Invoice To Org ID :'||l_header_rec.invoice_to_org_id);
1684: oe_debug_pub.add('Calling OE_Verify_Payment_PUB.Get_Primary_Pay_Method');
1685: END IF;
1686:

Line 1683: oe_debug_pub.add('Invoice To Org ID :'||l_header_rec.invoice_to_org_id);

1679: l_header_rec := OE_HEADER_UTIL.Query_Row(l_header_id);
1680:
1681: IF l_debug_level > 0 THEN
1682: oe_debug_pub.add('Sold To Org ID :'||l_header_rec.sold_to_org_id);
1683: oe_debug_pub.add('Invoice To Org ID :'||l_header_rec.invoice_to_org_id);
1684: oe_debug_pub.add('Calling OE_Verify_Payment_PUB.Get_Primary_Pay_Method');
1685: END IF;
1686:
1687: l_pay_method_id := OE_Verify_Payment_PUB.Get_Primary_Pay_Method

Line 1684: oe_debug_pub.add('Calling OE_Verify_Payment_PUB.Get_Primary_Pay_Method');

1680:
1681: IF l_debug_level > 0 THEN
1682: oe_debug_pub.add('Sold To Org ID :'||l_header_rec.sold_to_org_id);
1683: oe_debug_pub.add('Invoice To Org ID :'||l_header_rec.invoice_to_org_id);
1684: oe_debug_pub.add('Calling OE_Verify_Payment_PUB.Get_Primary_Pay_Method');
1685: END IF;
1686:
1687: l_pay_method_id := OE_Verify_Payment_PUB.Get_Primary_Pay_Method
1688: ( p_header_rec => l_header_rec ) ;

Line 1691: oe_debug_pub.add( 'After Getting primary payment method'||l_pay_method_id , 5 ) ;

1687: l_pay_method_id := OE_Verify_Payment_PUB.Get_Primary_Pay_Method
1688: ( p_header_rec => l_header_rec ) ;
1689:
1690: IF l_debug_level > 0 THEN
1691: oe_debug_pub.add( 'After Getting primary payment method'||l_pay_method_id , 5 ) ;
1692: END IF;
1693:
1694: RETURN l_pay_method_id;
1695: ELSE

Line 1704: oe_debug_pub.add('Error in Get_Receipt_method') ;

1700:
1701: EXCEPTION
1702: WHEN OTHERS THEN
1703: IF l_debug_level > 0 THEN
1704: oe_debug_pub.add('Error in Get_Receipt_method') ;
1705: oe_debug_pub.add('Error :'||substr(sqlerrm,1,200)) ;
1706: END IF;
1707: RETURN NULL;
1708: END Get_Receipt_Method;

Line 1705: oe_debug_pub.add('Error :'||substr(sqlerrm,1,200)) ;

1701: EXCEPTION
1702: WHEN OTHERS THEN
1703: IF l_debug_level > 0 THEN
1704: oe_debug_pub.add('Error in Get_Receipt_method') ;
1705: oe_debug_pub.add('Error :'||substr(sqlerrm,1,200)) ;
1706: END IF;
1707: RETURN NULL;
1708: END Get_Receipt_Method;
1709:

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

1716: ,p_attribute_code IN VARCHAR2)
1717: RETURN VARCHAR2 IS
1718: l_sold_to_org_id NUMBER;
1719: l_site_use_id NUMBER;
1720: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1721: BEGIN
1722:
1723: IF l_debug_level > 0 THEN
1724: oe_debug_pub.add('Enter Get_Primary_Deliver_To');

Line 1724: oe_debug_pub.add('Enter Get_Primary_Deliver_To');

1720: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1721: BEGIN
1722:
1723: IF l_debug_level > 0 THEN
1724: oe_debug_pub.add('Enter Get_Primary_Deliver_To');
1725: END IF;
1726:
1727: IF p_database_object_name = 'OE_AK_ORDER_HEADERS_V' THEN
1728: l_sold_to_org_id := ONT_HEADER_DEF_HDLR.g_record.sold_to_org_id;

Line 1733: oe_debug_pub.add('Invalid DB object :'||p_database_object_name);

1729: ELSIF p_database_object_name = 'OE_AK_ORDER_LINES_V' THEN
1730: l_sold_to_org_id := ONT_LINE_DEF_HDLR.g_record.sold_to_org_id;
1731: ELSE
1732: IF l_debug_level > 0 THEN
1733: oe_debug_pub.add('Invalid DB object :'||p_database_object_name);
1734: END IF;
1735: RETURN NULL;
1736: END IF;
1737:

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

1779: RETURN DATE
1780: IS
1781: l_latest_acceptable_date DATE;
1782: --
1783: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1784: --
1785: BEGIN
1786:
1787: OE_ORDER_CACHE.Load_Order_Header(Ont_Line_Def_Hdlr.G_Record.header_id);