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 FND_API

Line 79: AND ONT_HEADER_DEF_HDLR.g_record.sold_to_org_id <> FND_API.G_MISS_NUM

75:
76: l_payment_type_code := ONT_HEADER_DEF_HDLR.g_record.payment_type_code;
77:
78: IF ONT_HEADER_DEF_HDLR.g_record.sold_to_org_id IS NOT NULL
79: AND ONT_HEADER_DEF_HDLR.g_record.sold_to_org_id <> FND_API.G_MISS_NUM
80: THEN
81:
82: l_cust_org_id := ONT_HEADER_DEF_HDLR.g_record.sold_to_org_id;
83: IF ONT_HEADER_DEF_HDLR.g_record.invoice_to_org_id IS NOT NULL

Line 84: AND ONT_HEADER_DEF_HDLR.g_record.invoice_to_org_id <> FND_API.G_MISS_NUM

80: THEN
81:
82: l_cust_org_id := ONT_HEADER_DEF_HDLR.g_record.sold_to_org_id;
83: IF ONT_HEADER_DEF_HDLR.g_record.invoice_to_org_id IS NOT NULL
84: AND ONT_HEADER_DEF_HDLR.g_record.invoice_to_org_id <> FND_API.G_MISS_NUM
85: THEN
86: l_invoice_to_org_id := ONT_HEADER_DEF_HDLR.g_record.invoice_to_org_id;
87: END IF; -- if ont_header_def_hdlr.g_record.invoice_to...
88: ELSE

Line 206: IF l_return_status = FND_API.G_RET_STS_ERROR 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
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;

Line 210: RAISE FND_API.G_EXC_ERROR;

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
213: oe_debug_pub.add('Result error code in Get_Trxn_Appl_Instr_Assign'||l_response_code.result_code);
214: END IF;

Line 211: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_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
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;

Line 215: RAISE FND_API.G_EXC_UNEXPECTED_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
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');

Line 216: ELSIF l_return_status =FND_API.G_RET_STS_SUCCESS 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
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;

Line 241: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

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
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;

Line 245: RAISE FND_API.G_EXC_ERROR;

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
248: oe_debug_pub.add('Result error code in Get_Card'||l_response_code.result_code);
249: END IF;

Line 246: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_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
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;

Line 250: RAISE FND_API.G_EXC_UNEXPECTED_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
253: oe_debug_pub.add('Get_Card Successful....');
254: oe_debug_pub.add('After calling Get_Card');

Line 251: ELSIF l_return_status =FND_API.G_RET_STS_SUCCESS 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
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');

Line 302: WHEN FND_API.G_EXC_ERROR THEN

298: EXCEPTION
299: WHEN NO_DATA_FOUND THEN
300: RETURN NULL;
301:
302: WHEN FND_API.G_EXC_ERROR THEN
303: l_return_status := FND_API.G_RET_STS_ERROR;
304: OE_MSG_PUB.Count_And_Get
305: ( p_count => l_msg_count,
306: p_data => l_msg_data

Line 303: l_return_status := FND_API.G_RET_STS_ERROR;

299: WHEN NO_DATA_FOUND THEN
300: RETURN NULL;
301:
302: WHEN FND_API.G_EXC_ERROR THEN
303: l_return_status := FND_API.G_RET_STS_ERROR;
304: OE_MSG_PUB.Count_And_Get
305: ( p_count => l_msg_count,
306: p_data => l_msg_data
307: );

Line 310: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

306: p_data => l_msg_data
307: );
308: RETURN NULL;
309:
310: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
311: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
312: OE_MSG_PUB.Count_And_Get
313: ( p_count => l_msg_count,
314: p_data => l_msg_data

Line 311: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

307: );
308: RETURN NULL;
309:
310: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
311: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
312: OE_MSG_PUB.Count_And_Get
313: ( p_count => l_msg_count,
314: p_data => l_msg_data
315: );

Line 319: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

315: );
316: RETURN NULL;
317:
318: WHEN OTHERS THEN
319: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
320: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
321: THEN
322: FND_MSG_PUB.Add_Exc_Msg
323: ( G_PKG_NAME

Line 346: AND ONT_HEADER_DEF_HDLR.g_record.credit_card_code <> FND_API.G_MISS_CHAR THEN

342:
343:
344: IF p_database_object_name = 'OE_AK_ORDER_HEADERS_V'
345: AND ONT_HEADER_DEF_HDLR.g_record.credit_card_code IS NOT NULL
346: AND ONT_HEADER_DEF_HDLR.g_record.credit_card_code <> FND_API.G_MISS_CHAR THEN
347: RETURN ONT_HEADER_DEF_HDLR.g_record.credit_card_code;
348: ELSIF p_database_object_name = 'OE_AK_HEADER_PAYMENTS_V'
349: AND ONT_HEADER_PAYMENT_DEF_HDLR.g_record.credit_card_code IS NOT NULL
350: AND ONT_HEADER_PAYMENT_DEF_HDLR.g_record.credit_card_code <> FND_API.G_MISS_CHAR

Line 350: AND ONT_HEADER_PAYMENT_DEF_HDLR.g_record.credit_card_code <> FND_API.G_MISS_CHAR

346: AND ONT_HEADER_DEF_HDLR.g_record.credit_card_code <> FND_API.G_MISS_CHAR THEN
347: RETURN ONT_HEADER_DEF_HDLR.g_record.credit_card_code;
348: ELSIF p_database_object_name = 'OE_AK_HEADER_PAYMENTS_V'
349: AND ONT_HEADER_PAYMENT_DEF_HDLR.g_record.credit_card_code IS NOT NULL
350: AND ONT_HEADER_PAYMENT_DEF_HDLR.g_record.credit_card_code <> FND_API.G_MISS_CHAR
351: THEN
352: RETURN ONT_HEADER_PAYMENT_DEF_HDLR.g_record.credit_card_code;
353: ELSIF p_database_object_name = 'OE_AK_LINE_PAYMENTS_V'
354: AND ONT_LINE_PAYMENT_DEF_HDLR.g_record.credit_card_code IS NOT NULL

Line 355: AND ONT_LINE_PAYMENT_DEF_HDLR.g_record.credit_card_code <> FND_API.G_MISS_CHAR

351: THEN
352: RETURN ONT_HEADER_PAYMENT_DEF_HDLR.g_record.credit_card_code;
353: ELSIF p_database_object_name = 'OE_AK_LINE_PAYMENTS_V'
354: AND ONT_LINE_PAYMENT_DEF_HDLR.g_record.credit_card_code IS NOT NULL
355: AND ONT_LINE_PAYMENT_DEF_HDLR.g_record.credit_card_code <> FND_API.G_MISS_CHAR
356: THEN
357: RETURN ONT_LINE_PAYMENT_DEF_HDLR.g_record.credit_card_code;
358: END IF;
359: RETURN NULL;

Line 413: <> FND_API.G_MISS_CHAR

409: --R12 CC Encryption
410: IF p_database_object_name = 'OE_AK_ORDER_HEADERS_V'
411: AND ONT_HEADER_DEF_HDLR.g_record.credit_card_holder_name IS NOT NULL
412: AND ONT_HEADER_DEF_HDLR.g_record.credit_card_holder_name
413: <> FND_API.G_MISS_CHAR
414: THEN
415:
416: RETURN ONT_HEADER_DEF_HDLR.g_record.credit_card_holder_name;
417: ELSIF p_database_object_name = 'OE_AK_HEADER_PAYMENTS_V'

Line 420: <> FND_API.G_MISS_CHAR

416: RETURN ONT_HEADER_DEF_HDLR.g_record.credit_card_holder_name;
417: ELSIF p_database_object_name = 'OE_AK_HEADER_PAYMENTS_V'
418: AND ONT_HEADER_PAYMENT_DEF_HDLR.g_record.credit_card_holder_name IS NOT NULL
419: AND ONT_HEADER_PAYMENT_DEF_HDLR.g_record.credit_card_holder_name
420: <> FND_API.G_MISS_CHAR
421: THEN
422: RETURN ONT_HEADER_PAYMENT_DEF_HDLR.g_record.credit_card_holder_name;
423: ELSIF p_database_object_name = 'OE_AK_LINE_PAYMENTS_V'
424: AND ONT_LINE_PAYMENT_DEF_HDLR.g_record.credit_card_holder_name IS NOT NULL

Line 426: <> FND_API.G_MISS_CHAR

422: RETURN ONT_HEADER_PAYMENT_DEF_HDLR.g_record.credit_card_holder_name;
423: ELSIF p_database_object_name = 'OE_AK_LINE_PAYMENTS_V'
424: AND ONT_LINE_PAYMENT_DEF_HDLR.g_record.credit_card_holder_name IS NOT NULL
425: AND ONT_LINE_PAYMENT_DEF_HDLR.g_record.credit_card_holder_name
426: <> FND_API.G_MISS_CHAR
427: THEN
428: RETURN ONT_LINE_PAYMENT_DEF_HDLR.g_record.credit_card_holder_name;
429: END IF;
430: RETURN NULL;

Line 441: l_credit_card_number <> FND_API.G_MISS_CHAR THEN

437: l_credit_card_number := ONT_LINE_PAYMENT_DEF_HDLR.g_record.credit_card_number;
438: END IF;
439:
440: IF l_credit_card_number IS NOT NULL AND
441: l_credit_card_number <> FND_API.G_MISS_CHAR THEN
442: OPEN C_Holder_Name2(l_credit_card_number);
443: FETCH C_Holder_Name2 INTO l_Credit_Card_Holder_Name;
444: CLOSE C_Holder_Name2;
445:

Line 455: AND ONT_HEADER_DEF_HDLR.g_record.sold_to_org_id <> FND_API.G_MISS_NUM

451:
452: IF p_database_object_name = 'OE_AK_ORDER_HEADERS_V' THEN
453:
454: IF ONT_HEADER_DEF_HDLR.g_record.sold_to_org_id IS NOT NULL
455: AND ONT_HEADER_DEF_HDLR.g_record.sold_to_org_id <> FND_API.G_MISS_NUM
456: THEN
457:
458: l_cust_org_id := ONT_HEADER_DEF_HDLR.g_record.sold_to_org_id;
459: IF ONT_HEADER_DEF_HDLR.g_record.invoice_to_org_id IS NOT NULL

Line 460: AND ONT_HEADER_DEF_HDLR.g_record.invoice_to_org_id <> FND_API.G_MISS_NUM

456: THEN
457:
458: l_cust_org_id := ONT_HEADER_DEF_HDLR.g_record.sold_to_org_id;
459: IF ONT_HEADER_DEF_HDLR.g_record.invoice_to_org_id IS NOT NULL
460: AND ONT_HEADER_DEF_HDLR.g_record.invoice_to_org_id <> FND_API.G_MISS_NUM
461: THEN
462: l_invoice_to_org_id := ONT_HEADER_DEF_HDLR.g_record.invoice_to_org_id;
463: END IF; -- if ont_header_def_hdlr.g_record.invoice_to...
464: END IF; -- if ont_header_def_hdlr.g_record.sold_to_org_id is not null

Line 543: <> FND_API.G_MISS_DATE

539: --R12 CC Encryption
540: IF p_database_object_name = 'OE_AK_ORDER_HEADERS_V'
541: AND ONT_HEADER_DEF_HDLR.g_record.credit_card_expiration_date IS NOT NULL
542: AND ONT_HEADER_DEF_HDLR.g_record.credit_card_expiration_date
543: <> FND_API.G_MISS_DATE
544: THEN
545: RETURN ONT_HEADER_DEF_HDLR.g_record.credit_card_expiration_date;
546: ELSIF p_database_object_name = 'OE_AK_HEADER_PAYMENTS_V'
547: AND ONT_HEADER_PAYMENT_DEF_HDLR.g_record.credit_card_expiration_date IS NOT NULL

Line 549: <> FND_API.G_MISS_DATE

545: RETURN ONT_HEADER_DEF_HDLR.g_record.credit_card_expiration_date;
546: ELSIF p_database_object_name = 'OE_AK_HEADER_PAYMENTS_V'
547: AND ONT_HEADER_PAYMENT_DEF_HDLR.g_record.credit_card_expiration_date IS NOT NULL
548: AND ONT_HEADER_PAYMENT_DEF_HDLR.g_record.credit_card_expiration_date
549: <> FND_API.G_MISS_DATE
550: THEN
551: RETURN ONT_HEADER_PAYMENT_DEF_HDLR.g_record.credit_card_expiration_date;
552: ELSIF p_database_object_name = 'OE_AK_LINE_PAYMENTS_V'
553: AND ONT_LINE_PAYMENT_DEF_HDLR.g_record.credit_card_expiration_date IS NOT NULL

Line 555: <> FND_API.G_MISS_DATE

551: RETURN ONT_HEADER_PAYMENT_DEF_HDLR.g_record.credit_card_expiration_date;
552: ELSIF p_database_object_name = 'OE_AK_LINE_PAYMENTS_V'
553: AND ONT_LINE_PAYMENT_DEF_HDLR.g_record.credit_card_expiration_date IS NOT NULL
554: AND ONT_LINE_PAYMENT_DEF_HDLR.g_record.credit_card_expiration_date
555: <> FND_API.G_MISS_DATE
556: THEN
557: RETURN ONT_LINE_PAYMENT_DEF_HDLR.g_record.credit_card_expiration_date;
558: END IF;
559:

Line 576: l_credit_card_number <> FND_API.G_MISS_CHAR THEN

572: l_credit_card_number := ONT_LINE_PAYMENT_DEF_HDLR.g_record.credit_card_number;
573: END IF;
574:
575: IF l_credit_card_number IS NOT NULL AND
576: l_credit_card_number <> FND_API.G_MISS_CHAR THEN
577: OPEN C_Expiry_Date2(l_credit_card_number);
578: FETCH C_Expiry_Date2 INTO l_CC_Expiration_Date;
579: CLOSE C_Expiry_Date2;
580: END IF;

Line 585: AND ONT_HEADER_DEF_HDLR.g_record.sold_to_org_id <> FND_API.G_MISS_NUM THEN

581:
582: RETURN l_CC_Expiration_Date;
583:
584: IF ONT_HEADER_DEF_HDLR.g_record.sold_to_org_id IS NOT NULL
585: AND ONT_HEADER_DEF_HDLR.g_record.sold_to_org_id <> FND_API.G_MISS_NUM THEN
586: IF ONT_HEADER_DEF_HDLR.g_record.invoice_to_org_id IS NOT NULL
587: AND ONT_HEADER_DEF_HDLR.g_record.invoice_to_org_id <> FND_API.G_MISS_NUM THEN
588: l_Bank_Account_ID := arp_bank_pkg.get_primary_bank_acct
589: (ONT_HEADER_DEF_HDLR.g_record.sold_to_org_id

Line 587: AND ONT_HEADER_DEF_HDLR.g_record.invoice_to_org_id <> FND_API.G_MISS_NUM THEN

583:
584: IF ONT_HEADER_DEF_HDLR.g_record.sold_to_org_id IS NOT NULL
585: AND ONT_HEADER_DEF_HDLR.g_record.sold_to_org_id <> FND_API.G_MISS_NUM THEN
586: IF ONT_HEADER_DEF_HDLR.g_record.invoice_to_org_id IS NOT NULL
587: AND ONT_HEADER_DEF_HDLR.g_record.invoice_to_org_id <> FND_API.G_MISS_NUM THEN
588: l_Bank_Account_ID := arp_bank_pkg.get_primary_bank_acct
589: (ONT_HEADER_DEF_HDLR.g_record.sold_to_org_id
590: , ONT_HEADER_DEF_HDLR.g_record.invoice_to_org_id
591: , TRUE);

Line 655: ONT_HEADER_DEF_HDLR.g_record.ship_to_org_id <> FND_API.G_MISS_NUM AND

651: --
652: BEGIN
653: /***
654: IF ONT_HEADER_DEF_HDLR.g_record.ship_to_org_id IS NOT NULL AND
655: ONT_HEADER_DEF_HDLR.g_record.ship_to_org_id <> FND_API.G_MISS_NUM AND
656: ONT_HEADER_DEF_HDLR.g_record.invoice_to_org_id IS NOT NULL AND
657: ONT_HEADER_DEF_HDLR.g_record.invoice_to_org_id <> FND_API.G_MISS_NUM AND
658: ONT_HEADER_DEF_HDLR.g_record.ordered_date IS NOT NULL AND
659: ONT_HEADER_DEF_HDLR.g_record.ordered_date <> FND_API.G_MISS_DATE

Line 657: ONT_HEADER_DEF_HDLR.g_record.invoice_to_org_id <> FND_API.G_MISS_NUM AND

653: /***
654: IF ONT_HEADER_DEF_HDLR.g_record.ship_to_org_id IS NOT NULL AND
655: ONT_HEADER_DEF_HDLR.g_record.ship_to_org_id <> FND_API.G_MISS_NUM AND
656: ONT_HEADER_DEF_HDLR.g_record.invoice_to_org_id IS NOT NULL AND
657: ONT_HEADER_DEF_HDLR.g_record.invoice_to_org_id <> FND_API.G_MISS_NUM AND
658: ONT_HEADER_DEF_HDLR.g_record.ordered_date IS NOT NULL AND
659: ONT_HEADER_DEF_HDLR.g_record.ordered_date <> FND_API.G_MISS_DATE
660: THEN
661:

Line 659: ONT_HEADER_DEF_HDLR.g_record.ordered_date <> FND_API.G_MISS_DATE

655: ONT_HEADER_DEF_HDLR.g_record.ship_to_org_id <> FND_API.G_MISS_NUM AND
656: ONT_HEADER_DEF_HDLR.g_record.invoice_to_org_id IS NOT NULL AND
657: ONT_HEADER_DEF_HDLR.g_record.invoice_to_org_id <> FND_API.G_MISS_NUM AND
658: ONT_HEADER_DEF_HDLR.g_record.ordered_date IS NOT NULL AND
659: ONT_HEADER_DEF_HDLR.g_record.ordered_date <> FND_API.G_MISS_DATE
660: THEN
661:
662:
663: OPEN C_Std_Tax_Exemption(ONT_HEADER_DEF_HDLR.g_record.ship_to_org_id,

Line 718: ONT_HEADER_DEF_HDLR.g_record.ship_to_org_id <> FND_API.G_MISS_NUM AND

714: --
715: BEGIN
716: /***
717: IF ONT_HEADER_DEF_HDLR.g_record.ship_to_org_id IS NOT NULL AND
718: ONT_HEADER_DEF_HDLR.g_record.ship_to_org_id <> FND_API.G_MISS_NUM AND
719: ONT_HEADER_DEF_HDLR.g_record.invoice_to_org_id IS NOT NULL AND
720: ONT_HEADER_DEF_HDLR.g_record.invoice_to_org_id <> FND_API.G_MISS_NUM AND
721: ONT_HEADER_DEF_HDLR.g_record.ordered_date IS NOT NULL AND
722: ONT_HEADER_DEF_HDLR.g_record.ordered_date <> FND_API.G_MISS_DATE

Line 720: ONT_HEADER_DEF_HDLR.g_record.invoice_to_org_id <> FND_API.G_MISS_NUM AND

716: /***
717: IF ONT_HEADER_DEF_HDLR.g_record.ship_to_org_id IS NOT NULL AND
718: ONT_HEADER_DEF_HDLR.g_record.ship_to_org_id <> FND_API.G_MISS_NUM AND
719: ONT_HEADER_DEF_HDLR.g_record.invoice_to_org_id IS NOT NULL AND
720: ONT_HEADER_DEF_HDLR.g_record.invoice_to_org_id <> FND_API.G_MISS_NUM AND
721: ONT_HEADER_DEF_HDLR.g_record.ordered_date IS NOT NULL AND
722: ONT_HEADER_DEF_HDLR.g_record.ordered_date <> FND_API.G_MISS_DATE
723: THEN
724:

Line 722: ONT_HEADER_DEF_HDLR.g_record.ordered_date <> FND_API.G_MISS_DATE

718: ONT_HEADER_DEF_HDLR.g_record.ship_to_org_id <> FND_API.G_MISS_NUM AND
719: ONT_HEADER_DEF_HDLR.g_record.invoice_to_org_id IS NOT NULL AND
720: ONT_HEADER_DEF_HDLR.g_record.invoice_to_org_id <> FND_API.G_MISS_NUM AND
721: ONT_HEADER_DEF_HDLR.g_record.ordered_date IS NOT NULL AND
722: ONT_HEADER_DEF_HDLR.g_record.ordered_date <> FND_API.G_MISS_DATE
723: THEN
724:
725: OPEN C_Std_Tax_Exemption(ONT_HEADER_DEF_HDLR.g_record.ship_to_org_id,
726: ONT_HEADER_DEF_HDLR.g_record.Invoice_To_Org_id,

Line 831: IF ONT_LINE_Def_Hdlr.g_record.tax_exempt_reason_code <> FND_API.G_MISS_CHAR

827: -- (OE_Line_DEF_HANDLER.g_record). It can used in defaulting the
828: -- tax exempt reason.
829:
830: IF p_attribute_code = 'TAX_EXEMPT_REASON' THEN
831: IF ONT_LINE_Def_Hdlr.g_record.tax_exempt_reason_code <> FND_API.G_MISS_CHAR
832: THEN
833: RETURN ONT_LINE_Def_Hdlr.g_record.tax_exempt_reason_code;
834: END IF;
835: ELSIF p_attribute_code = 'TAX_EXEMPT_NUMBER' THEN

Line 836: IF ONT_LINE_Def_Hdlr.g_record.tax_exempt_number <> FND_API.G_MISS_CHAR

832: THEN
833: RETURN ONT_LINE_Def_Hdlr.g_record.tax_exempt_reason_code;
834: END IF;
835: ELSIF p_attribute_code = 'TAX_EXEMPT_NUMBER' THEN
836: IF ONT_LINE_Def_Hdlr.g_record.tax_exempt_number <> FND_API.G_MISS_CHAR
837: THEN
838: RETURN ONT_LINE_Def_Hdlr.g_record.tax_exempt_number;
839: END IF;
840: END IF;

Line 842: ONT_LINE_Def_Hdlr.g_record.ship_to_org_id <> FND_API.G_MISS_NUM) OR

838: RETURN ONT_LINE_Def_Hdlr.g_record.tax_exempt_number;
839: END IF;
840: END IF;
841: IF ((ONT_LINE_Def_Hdlr.g_record.ship_to_org_id IS NOT NULL AND
842: ONT_LINE_Def_Hdlr.g_record.ship_to_org_id <> FND_API.G_MISS_NUM) OR
843: (ONT_LINE_Def_Hdlr.g_record.invoice_to_org_id IS NOT NULL AND
844: ONT_LINE_Def_Hdlr.g_record.invoice_to_org_id <> FND_API.G_MISS_NUM)) AND
845: ONT_LINE_Def_Hdlr.g_record.sold_to_org_id IS NOT NULL AND
846: ONT_LINE_Def_Hdlr.g_record.sold_to_org_id <> FND_API.G_MISS_NUM AND

Line 844: ONT_LINE_Def_Hdlr.g_record.invoice_to_org_id <> FND_API.G_MISS_NUM)) AND

840: END IF;
841: IF ((ONT_LINE_Def_Hdlr.g_record.ship_to_org_id IS NOT NULL AND
842: ONT_LINE_Def_Hdlr.g_record.ship_to_org_id <> FND_API.G_MISS_NUM) OR
843: (ONT_LINE_Def_Hdlr.g_record.invoice_to_org_id IS NOT NULL AND
844: ONT_LINE_Def_Hdlr.g_record.invoice_to_org_id <> FND_API.G_MISS_NUM)) AND
845: ONT_LINE_Def_Hdlr.g_record.sold_to_org_id IS NOT NULL AND
846: ONT_LINE_Def_Hdlr.g_record.sold_to_org_id <> FND_API.G_MISS_NUM AND
847: ONT_LINE_Def_Hdlr.g_record.tax_date IS NOT NULL AND
848: ONT_LINE_Def_Hdlr.g_record.tax_date <> FND_API.G_MISS_DATE AND

Line 846: ONT_LINE_Def_Hdlr.g_record.sold_to_org_id <> FND_API.G_MISS_NUM AND

842: ONT_LINE_Def_Hdlr.g_record.ship_to_org_id <> FND_API.G_MISS_NUM) OR
843: (ONT_LINE_Def_Hdlr.g_record.invoice_to_org_id IS NOT NULL AND
844: ONT_LINE_Def_Hdlr.g_record.invoice_to_org_id <> FND_API.G_MISS_NUM)) AND
845: ONT_LINE_Def_Hdlr.g_record.sold_to_org_id IS NOT NULL AND
846: ONT_LINE_Def_Hdlr.g_record.sold_to_org_id <> FND_API.G_MISS_NUM AND
847: ONT_LINE_Def_Hdlr.g_record.tax_date IS NOT NULL AND
848: ONT_LINE_Def_Hdlr.g_record.tax_date <> FND_API.G_MISS_DATE AND
849: ONT_LINE_Def_Hdlr.g_record.tax_code IS NOT NULL AND
850: ONT_LINE_Def_Hdlr.g_record.tax_code <> FND_API.G_MISS_CHAR

Line 848: ONT_LINE_Def_Hdlr.g_record.tax_date <> FND_API.G_MISS_DATE AND

844: ONT_LINE_Def_Hdlr.g_record.invoice_to_org_id <> FND_API.G_MISS_NUM)) AND
845: ONT_LINE_Def_Hdlr.g_record.sold_to_org_id IS NOT NULL AND
846: ONT_LINE_Def_Hdlr.g_record.sold_to_org_id <> FND_API.G_MISS_NUM AND
847: ONT_LINE_Def_Hdlr.g_record.tax_date IS NOT NULL AND
848: ONT_LINE_Def_Hdlr.g_record.tax_date <> FND_API.G_MISS_DATE AND
849: ONT_LINE_Def_Hdlr.g_record.tax_code IS NOT NULL AND
850: ONT_LINE_Def_Hdlr.g_record.tax_code <> FND_API.G_MISS_CHAR
851: THEN
852: --bsadri if the cached values are the same do not fetch them

Line 850: ONT_LINE_Def_Hdlr.g_record.tax_code <> FND_API.G_MISS_CHAR

846: ONT_LINE_Def_Hdlr.g_record.sold_to_org_id <> FND_API.G_MISS_NUM AND
847: ONT_LINE_Def_Hdlr.g_record.tax_date IS NOT NULL AND
848: ONT_LINE_Def_Hdlr.g_record.tax_date <> FND_API.G_MISS_DATE AND
849: ONT_LINE_Def_Hdlr.g_record.tax_code IS NOT NULL AND
850: ONT_LINE_Def_Hdlr.g_record.tax_code <> FND_API.G_MISS_CHAR
851: THEN
852: --bsadri if the cached values are the same do not fetch them
853: IF nvl(ONT_LINE_Def_Hdlr.g_record.ship_to_org_id,FND_API.G_MISS_NUM)
854: <>nvl( OE_Order_Cache.g_TAX_EXEMPTION_CACH.ship_to_org_id,FND_API.G_MISS_NUM)

Line 853: IF nvl(ONT_LINE_Def_Hdlr.g_record.ship_to_org_id,FND_API.G_MISS_NUM)

849: ONT_LINE_Def_Hdlr.g_record.tax_code IS NOT NULL AND
850: ONT_LINE_Def_Hdlr.g_record.tax_code <> FND_API.G_MISS_CHAR
851: THEN
852: --bsadri if the cached values are the same do not fetch them
853: IF nvl(ONT_LINE_Def_Hdlr.g_record.ship_to_org_id,FND_API.G_MISS_NUM)
854: <>nvl( OE_Order_Cache.g_TAX_EXEMPTION_CACH.ship_to_org_id,FND_API.G_MISS_NUM)
855: OR nvl(ONT_LINE_Def_Hdlr.g_record.invoice_to_org_id,FND_API.G_MISS_NUM) <>
856: NVL( OE_Order_Cache.g_TAX_EXEMPTION_CACH.invoice_to_org_id,FND_API.G_MISS_NUM)
857: OR NVL(ONT_LINE_Def_Hdlr.g_record.sold_to_org_id,FND_API.G_MISS_NUM) <>

Line 854: <>nvl( OE_Order_Cache.g_TAX_EXEMPTION_CACH.ship_to_org_id,FND_API.G_MISS_NUM)

850: ONT_LINE_Def_Hdlr.g_record.tax_code <> FND_API.G_MISS_CHAR
851: THEN
852: --bsadri if the cached values are the same do not fetch them
853: IF nvl(ONT_LINE_Def_Hdlr.g_record.ship_to_org_id,FND_API.G_MISS_NUM)
854: <>nvl( OE_Order_Cache.g_TAX_EXEMPTION_CACH.ship_to_org_id,FND_API.G_MISS_NUM)
855: OR nvl(ONT_LINE_Def_Hdlr.g_record.invoice_to_org_id,FND_API.G_MISS_NUM) <>
856: NVL( OE_Order_Cache.g_TAX_EXEMPTION_CACH.invoice_to_org_id,FND_API.G_MISS_NUM)
857: OR NVL(ONT_LINE_Def_Hdlr.g_record.sold_to_org_id,FND_API.G_MISS_NUM) <>
858: nvl(OE_Order_Cache.g_TAX_EXEMPTION_CACH.sold_to_org_id,FND_API.G_MISS_NUM)

Line 855: OR nvl(ONT_LINE_Def_Hdlr.g_record.invoice_to_org_id,FND_API.G_MISS_NUM) <>

851: THEN
852: --bsadri if the cached values are the same do not fetch them
853: IF nvl(ONT_LINE_Def_Hdlr.g_record.ship_to_org_id,FND_API.G_MISS_NUM)
854: <>nvl( OE_Order_Cache.g_TAX_EXEMPTION_CACH.ship_to_org_id,FND_API.G_MISS_NUM)
855: OR nvl(ONT_LINE_Def_Hdlr.g_record.invoice_to_org_id,FND_API.G_MISS_NUM) <>
856: NVL( OE_Order_Cache.g_TAX_EXEMPTION_CACH.invoice_to_org_id,FND_API.G_MISS_NUM)
857: OR NVL(ONT_LINE_Def_Hdlr.g_record.sold_to_org_id,FND_API.G_MISS_NUM) <>
858: nvl(OE_Order_Cache.g_TAX_EXEMPTION_CACH.sold_to_org_id,FND_API.G_MISS_NUM)
859: OR nvl(ONT_LINE_Def_Hdlr.g_record.tax_date,FND_API.G_MISS_DATE) <>

Line 856: NVL( OE_Order_Cache.g_TAX_EXEMPTION_CACH.invoice_to_org_id,FND_API.G_MISS_NUM)

852: --bsadri if the cached values are the same do not fetch them
853: IF nvl(ONT_LINE_Def_Hdlr.g_record.ship_to_org_id,FND_API.G_MISS_NUM)
854: <>nvl( OE_Order_Cache.g_TAX_EXEMPTION_CACH.ship_to_org_id,FND_API.G_MISS_NUM)
855: OR nvl(ONT_LINE_Def_Hdlr.g_record.invoice_to_org_id,FND_API.G_MISS_NUM) <>
856: NVL( OE_Order_Cache.g_TAX_EXEMPTION_CACH.invoice_to_org_id,FND_API.G_MISS_NUM)
857: OR NVL(ONT_LINE_Def_Hdlr.g_record.sold_to_org_id,FND_API.G_MISS_NUM) <>
858: nvl(OE_Order_Cache.g_TAX_EXEMPTION_CACH.sold_to_org_id,FND_API.G_MISS_NUM)
859: OR nvl(ONT_LINE_Def_Hdlr.g_record.tax_date,FND_API.G_MISS_DATE) <>
860: nvl(OE_Order_Cache.g_TAX_EXEMPTION_CACH.tax_date,FND_API.G_MISS_DATE)

Line 857: OR NVL(ONT_LINE_Def_Hdlr.g_record.sold_to_org_id,FND_API.G_MISS_NUM) <>

853: IF nvl(ONT_LINE_Def_Hdlr.g_record.ship_to_org_id,FND_API.G_MISS_NUM)
854: <>nvl( OE_Order_Cache.g_TAX_EXEMPTION_CACH.ship_to_org_id,FND_API.G_MISS_NUM)
855: OR nvl(ONT_LINE_Def_Hdlr.g_record.invoice_to_org_id,FND_API.G_MISS_NUM) <>
856: NVL( OE_Order_Cache.g_TAX_EXEMPTION_CACH.invoice_to_org_id,FND_API.G_MISS_NUM)
857: OR NVL(ONT_LINE_Def_Hdlr.g_record.sold_to_org_id,FND_API.G_MISS_NUM) <>
858: nvl(OE_Order_Cache.g_TAX_EXEMPTION_CACH.sold_to_org_id,FND_API.G_MISS_NUM)
859: OR nvl(ONT_LINE_Def_Hdlr.g_record.tax_date,FND_API.G_MISS_DATE) <>
860: nvl(OE_Order_Cache.g_TAX_EXEMPTION_CACH.tax_date,FND_API.G_MISS_DATE)
861: OR nvl(ONT_LINE_Def_Hdlr.g_record.tax_code,FND_API.G_MISS_CHAR) <>

Line 858: nvl(OE_Order_Cache.g_TAX_EXEMPTION_CACH.sold_to_org_id,FND_API.G_MISS_NUM)

854: <>nvl( OE_Order_Cache.g_TAX_EXEMPTION_CACH.ship_to_org_id,FND_API.G_MISS_NUM)
855: OR nvl(ONT_LINE_Def_Hdlr.g_record.invoice_to_org_id,FND_API.G_MISS_NUM) <>
856: NVL( OE_Order_Cache.g_TAX_EXEMPTION_CACH.invoice_to_org_id,FND_API.G_MISS_NUM)
857: OR NVL(ONT_LINE_Def_Hdlr.g_record.sold_to_org_id,FND_API.G_MISS_NUM) <>
858: nvl(OE_Order_Cache.g_TAX_EXEMPTION_CACH.sold_to_org_id,FND_API.G_MISS_NUM)
859: OR nvl(ONT_LINE_Def_Hdlr.g_record.tax_date,FND_API.G_MISS_DATE) <>
860: nvl(OE_Order_Cache.g_TAX_EXEMPTION_CACH.tax_date,FND_API.G_MISS_DATE)
861: OR nvl(ONT_LINE_Def_Hdlr.g_record.tax_code,FND_API.G_MISS_CHAR) <>
862: nvl(OE_Order_Cache.g_TAX_EXEMPTION_CACH.tax_code ,FND_API.G_MISS_CHAR)

Line 859: OR nvl(ONT_LINE_Def_Hdlr.g_record.tax_date,FND_API.G_MISS_DATE) <>

855: OR nvl(ONT_LINE_Def_Hdlr.g_record.invoice_to_org_id,FND_API.G_MISS_NUM) <>
856: NVL( OE_Order_Cache.g_TAX_EXEMPTION_CACH.invoice_to_org_id,FND_API.G_MISS_NUM)
857: OR NVL(ONT_LINE_Def_Hdlr.g_record.sold_to_org_id,FND_API.G_MISS_NUM) <>
858: nvl(OE_Order_Cache.g_TAX_EXEMPTION_CACH.sold_to_org_id,FND_API.G_MISS_NUM)
859: OR nvl(ONT_LINE_Def_Hdlr.g_record.tax_date,FND_API.G_MISS_DATE) <>
860: nvl(OE_Order_Cache.g_TAX_EXEMPTION_CACH.tax_date,FND_API.G_MISS_DATE)
861: OR nvl(ONT_LINE_Def_Hdlr.g_record.tax_code,FND_API.G_MISS_CHAR) <>
862: nvl(OE_Order_Cache.g_TAX_EXEMPTION_CACH.tax_code ,FND_API.G_MISS_CHAR)
863: THEN --{

Line 860: nvl(OE_Order_Cache.g_TAX_EXEMPTION_CACH.tax_date,FND_API.G_MISS_DATE)

856: NVL( OE_Order_Cache.g_TAX_EXEMPTION_CACH.invoice_to_org_id,FND_API.G_MISS_NUM)
857: OR NVL(ONT_LINE_Def_Hdlr.g_record.sold_to_org_id,FND_API.G_MISS_NUM) <>
858: nvl(OE_Order_Cache.g_TAX_EXEMPTION_CACH.sold_to_org_id,FND_API.G_MISS_NUM)
859: OR nvl(ONT_LINE_Def_Hdlr.g_record.tax_date,FND_API.G_MISS_DATE) <>
860: nvl(OE_Order_Cache.g_TAX_EXEMPTION_CACH.tax_date,FND_API.G_MISS_DATE)
861: OR nvl(ONT_LINE_Def_Hdlr.g_record.tax_code,FND_API.G_MISS_CHAR) <>
862: nvl(OE_Order_Cache.g_TAX_EXEMPTION_CACH.tax_code ,FND_API.G_MISS_CHAR)
863: THEN --{
864: -- eBTax changes

Line 861: OR nvl(ONT_LINE_Def_Hdlr.g_record.tax_code,FND_API.G_MISS_CHAR) <>

857: OR NVL(ONT_LINE_Def_Hdlr.g_record.sold_to_org_id,FND_API.G_MISS_NUM) <>
858: nvl(OE_Order_Cache.g_TAX_EXEMPTION_CACH.sold_to_org_id,FND_API.G_MISS_NUM)
859: OR nvl(ONT_LINE_Def_Hdlr.g_record.tax_date,FND_API.G_MISS_DATE) <>
860: nvl(OE_Order_Cache.g_TAX_EXEMPTION_CACH.tax_date,FND_API.G_MISS_DATE)
861: OR nvl(ONT_LINE_Def_Hdlr.g_record.tax_code,FND_API.G_MISS_CHAR) <>
862: nvl(OE_Order_Cache.g_TAX_EXEMPTION_CACH.tax_code ,FND_API.G_MISS_CHAR)
863: THEN --{
864: -- eBTax changes
865: /* OPEN C_Line_Std_Tax_Exemption(ONT_LINE_Def_Hdlr.g_record.ship_to_org_id,

Line 862: nvl(OE_Order_Cache.g_TAX_EXEMPTION_CACH.tax_code ,FND_API.G_MISS_CHAR)

858: nvl(OE_Order_Cache.g_TAX_EXEMPTION_CACH.sold_to_org_id,FND_API.G_MISS_NUM)
859: OR nvl(ONT_LINE_Def_Hdlr.g_record.tax_date,FND_API.G_MISS_DATE) <>
860: nvl(OE_Order_Cache.g_TAX_EXEMPTION_CACH.tax_date,FND_API.G_MISS_DATE)
861: OR nvl(ONT_LINE_Def_Hdlr.g_record.tax_code,FND_API.G_MISS_CHAR) <>
862: nvl(OE_Order_Cache.g_TAX_EXEMPTION_CACH.tax_code ,FND_API.G_MISS_CHAR)
863: THEN --{
864: -- eBTax changes
865: /* OPEN C_Line_Std_Tax_Exemption(ONT_LINE_Def_Hdlr.g_record.ship_to_org_id,
866: ONT_LINE_Def_Hdlr.g_record.Invoice_To_Org_id,

Line 959: IF ONT_LINE_Def_Hdlr.g_record.tax_exempt_reason_code <> FND_API.G_MISS_CHAR

955: -- (OE_Line_DEF_HANDLER.g_record). It can used in defaulting the
956: -- tax exempt reason.
957:
958: IF p_attribute_code = 'TAX_EXEMPT_REASON' THEN
959: IF ONT_LINE_Def_Hdlr.g_record.tax_exempt_reason_code <> FND_API.G_MISS_CHAR
960: THEN
961: RETURN ONT_LINE_Def_Hdlr.g_record.tax_exempt_reason_code;
962: END IF;
963: ELSIF p_attribute_code = 'TAX_EXEMPT_NUMBER' THEN

Line 964: IF ONT_LINE_Def_Hdlr.g_record.tax_exempt_number <> FND_API.G_MISS_CHAR

960: THEN
961: RETURN ONT_LINE_Def_Hdlr.g_record.tax_exempt_reason_code;
962: END IF;
963: ELSIF p_attribute_code = 'TAX_EXEMPT_NUMBER' THEN
964: IF ONT_LINE_Def_Hdlr.g_record.tax_exempt_number <> FND_API.G_MISS_CHAR
965: THEN
966: RETURN ONT_LINE_Def_Hdlr.g_record.tax_exempt_number;
967: END IF;
968: END IF;

Line 999: IF (ONT_LINE_Def_Hdlr.g_record.tax_exempt_reason_code = FND_API.G_MISS_CHAR

995:
996: END IF;
997: -- bug 5184842 only set both when both needs to be defaulted
998: -- otherwise, the return value should take care
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 ) ;

Line 1000: AND ONT_LINE_Def_Hdlr.g_record.tax_exempt_number = FND_API.G_MISS_CHAR)

996: END IF;
997: -- bug 5184842 only set both when both needs to be defaulted
998: -- otherwise, the return value should take care
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;

Line 1044: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1040: 'Get_Tax_Exemption_details'
1041: );
1042: END IF;
1043:
1044: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1045: END Get_Tax_Exemption_Details;
1046:
1047:
1048: -- Get the Set of Books Currency

Line 1066: IF x_Currency_Code = FND_API.G_MISS_CHAR THEN

1062: l_set_of_books_rec :=
1063: OE_Order_Cache.Load_Set_Of_Books;
1064: x_Currency_Code := l_set_of_books_rec.Currency_Code;
1065:
1066: IF x_Currency_Code = FND_API.G_MISS_CHAR THEN
1067:
1068: x_Currency_Code := Null;
1069:
1070: END IF;

Line 1086: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1082: 'GET_TAX_CODE'
1083: );
1084: END IF;
1085:
1086: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1087:
1088: END Get_SOB_Currency_Code;
1089:
1090:

Line 1142: l_commitment_id <> FND_API.G_MISS_NUM THEN

1138:
1139: l_commitment_id := ONT_LINE_DEF_HDLR.g_record.commitment_id;
1140:
1141: IF l_commitment_id IS NOT NULL AND
1142: l_commitment_id <> FND_API.G_MISS_NUM THEN
1143: BEGIN
1144: SELECT NVL(cust_type.subsequent_trx_type_id,cust_type.cust_trx_type_id)
1145: INTO l_cust_trx_type_id
1146: FROM ra_cust_trx_types cust_type,ra_customer_trx_all cust_trx

Line 1214: ONT_LINE_DEF_HDLR.g_record.inventory_item_id <> FND_API.G_MISS_NUM AND

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
1215: ONT_LINE_DEF_HDLR.g_record.tax_date IS NOT NULL AND
1216: ONT_LINE_DEF_HDLR.g_record.tax_date <> FND_API.G_MISS_DATE
1217: THEN
1218:

Line 1216: ONT_LINE_DEF_HDLR.g_record.tax_date <> FND_API.G_MISS_DATE

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
1215: ONT_LINE_DEF_HDLR.g_record.tax_date IS NOT NULL AND
1216: ONT_LINE_DEF_HDLR.g_record.tax_date <> FND_API.G_MISS_DATE
1217: THEN
1218:
1219:
1220: OE_GLOBALS.Set_Context;

Line 1255: l_organization_id <> FND_API.G_MISS_NUM

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
1256: THEN
1257:
1258: IF l_debug_level > 0 THEN
1259: oe_debug_pub.add( 'REN 1' , 3 ) ;

Line 1279: IF nvl(ONT_LINE_DEF_HDLR.g_record.ship_to_org_id,FND_API.G_MISS_NUM)<>

1275: -- Call the AR's API to get the default tax code
1276:
1277: --bsadri caching the values
1278:
1279: IF nvl(ONT_LINE_DEF_HDLR.g_record.ship_to_org_id,FND_API.G_MISS_NUM)<>
1280:
1281: nvl(OE_Order_Cache.g_TAX_CODE_CACH.ship_to_org_id,FND_API.G_MISS_NUM)
1282: OR nvl(ONT_LINE_DEF_HDLR.g_record.invoice_to_org_id,FND_API.G_MISS_NUM)<>
1283: nvl(OE_Order_Cache.g_TAX_CODE_CACH.invoice_to_org_id,FND_API.G_MISS_NUM)

Line 1281: nvl(OE_Order_Cache.g_TAX_CODE_CACH.ship_to_org_id,FND_API.G_MISS_NUM)

1277: --bsadri caching the values
1278:
1279: IF nvl(ONT_LINE_DEF_HDLR.g_record.ship_to_org_id,FND_API.G_MISS_NUM)<>
1280:
1281: nvl(OE_Order_Cache.g_TAX_CODE_CACH.ship_to_org_id,FND_API.G_MISS_NUM)
1282: OR nvl(ONT_LINE_DEF_HDLR.g_record.invoice_to_org_id,FND_API.G_MISS_NUM)<>
1283: nvl(OE_Order_Cache.g_TAX_CODE_CACH.invoice_to_org_id,FND_API.G_MISS_NUM)
1284: OR nvl(ONT_LINE_DEF_HDLR.g_record.inventory_item_id,FND_API.G_MISS_NUM) <>
1285: nvl(OE_Order_Cache.g_TAX_CODE_CACH.inventory_item_id,FND_API.G_MISS_NUM)

Line 1282: OR nvl(ONT_LINE_DEF_HDLR.g_record.invoice_to_org_id,FND_API.G_MISS_NUM)<>

1278:
1279: IF nvl(ONT_LINE_DEF_HDLR.g_record.ship_to_org_id,FND_API.G_MISS_NUM)<>
1280:
1281: nvl(OE_Order_Cache.g_TAX_CODE_CACH.ship_to_org_id,FND_API.G_MISS_NUM)
1282: OR nvl(ONT_LINE_DEF_HDLR.g_record.invoice_to_org_id,FND_API.G_MISS_NUM)<>
1283: nvl(OE_Order_Cache.g_TAX_CODE_CACH.invoice_to_org_id,FND_API.G_MISS_NUM)
1284: OR nvl(ONT_LINE_DEF_HDLR.g_record.inventory_item_id,FND_API.G_MISS_NUM) <>
1285: nvl(OE_Order_Cache.g_TAX_CODE_CACH.inventory_item_id,FND_API.G_MISS_NUM)
1286: OR nvl(ONT_LINE_DEF_HDLR.g_record.ship_from_org_id,FND_API.G_MISS_NUM)<>

Line 1283: nvl(OE_Order_Cache.g_TAX_CODE_CACH.invoice_to_org_id,FND_API.G_MISS_NUM)

1279: IF nvl(ONT_LINE_DEF_HDLR.g_record.ship_to_org_id,FND_API.G_MISS_NUM)<>
1280:
1281: nvl(OE_Order_Cache.g_TAX_CODE_CACH.ship_to_org_id,FND_API.G_MISS_NUM)
1282: OR nvl(ONT_LINE_DEF_HDLR.g_record.invoice_to_org_id,FND_API.G_MISS_NUM)<>
1283: nvl(OE_Order_Cache.g_TAX_CODE_CACH.invoice_to_org_id,FND_API.G_MISS_NUM)
1284: OR nvl(ONT_LINE_DEF_HDLR.g_record.inventory_item_id,FND_API.G_MISS_NUM) <>
1285: nvl(OE_Order_Cache.g_TAX_CODE_CACH.inventory_item_id,FND_API.G_MISS_NUM)
1286: OR nvl(ONT_LINE_DEF_HDLR.g_record.ship_from_org_id,FND_API.G_MISS_NUM)<>
1287: nvl(OE_Order_Cache.g_TAX_CODE_CACH.ship_from_org_id ,FND_API.G_MISS_NUM)

Line 1284: OR nvl(ONT_LINE_DEF_HDLR.g_record.inventory_item_id,FND_API.G_MISS_NUM) <>

1280:
1281: nvl(OE_Order_Cache.g_TAX_CODE_CACH.ship_to_org_id,FND_API.G_MISS_NUM)
1282: OR nvl(ONT_LINE_DEF_HDLR.g_record.invoice_to_org_id,FND_API.G_MISS_NUM)<>
1283: nvl(OE_Order_Cache.g_TAX_CODE_CACH.invoice_to_org_id,FND_API.G_MISS_NUM)
1284: OR nvl(ONT_LINE_DEF_HDLR.g_record.inventory_item_id,FND_API.G_MISS_NUM) <>
1285: nvl(OE_Order_Cache.g_TAX_CODE_CACH.inventory_item_id,FND_API.G_MISS_NUM)
1286: OR nvl(ONT_LINE_DEF_HDLR.g_record.ship_from_org_id,FND_API.G_MISS_NUM)<>
1287: nvl(OE_Order_Cache.g_TAX_CODE_CACH.ship_from_org_id ,FND_API.G_MISS_NUM)
1288: OR nvl(ONT_LINE_DEF_HDLR.g_record.tax_date,FND_API.G_MISS_DATE) <>

Line 1285: nvl(OE_Order_Cache.g_TAX_CODE_CACH.inventory_item_id,FND_API.G_MISS_NUM)

1281: nvl(OE_Order_Cache.g_TAX_CODE_CACH.ship_to_org_id,FND_API.G_MISS_NUM)
1282: OR nvl(ONT_LINE_DEF_HDLR.g_record.invoice_to_org_id,FND_API.G_MISS_NUM)<>
1283: nvl(OE_Order_Cache.g_TAX_CODE_CACH.invoice_to_org_id,FND_API.G_MISS_NUM)
1284: OR nvl(ONT_LINE_DEF_HDLR.g_record.inventory_item_id,FND_API.G_MISS_NUM) <>
1285: nvl(OE_Order_Cache.g_TAX_CODE_CACH.inventory_item_id,FND_API.G_MISS_NUM)
1286: OR nvl(ONT_LINE_DEF_HDLR.g_record.ship_from_org_id,FND_API.G_MISS_NUM)<>
1287: nvl(OE_Order_Cache.g_TAX_CODE_CACH.ship_from_org_id ,FND_API.G_MISS_NUM)
1288: OR nvl(ONT_LINE_DEF_HDLR.g_record.tax_date,FND_API.G_MISS_DATE) <>
1289: nvl(OE_Order_Cache.g_TAX_CODE_CACH.tax_date,FND_API.G_MISS_DATE)

Line 1286: OR nvl(ONT_LINE_DEF_HDLR.g_record.ship_from_org_id,FND_API.G_MISS_NUM)<>

1282: OR nvl(ONT_LINE_DEF_HDLR.g_record.invoice_to_org_id,FND_API.G_MISS_NUM)<>
1283: nvl(OE_Order_Cache.g_TAX_CODE_CACH.invoice_to_org_id,FND_API.G_MISS_NUM)
1284: OR nvl(ONT_LINE_DEF_HDLR.g_record.inventory_item_id,FND_API.G_MISS_NUM) <>
1285: nvl(OE_Order_Cache.g_TAX_CODE_CACH.inventory_item_id,FND_API.G_MISS_NUM)
1286: OR nvl(ONT_LINE_DEF_HDLR.g_record.ship_from_org_id,FND_API.G_MISS_NUM)<>
1287: nvl(OE_Order_Cache.g_TAX_CODE_CACH.ship_from_org_id ,FND_API.G_MISS_NUM)
1288: OR nvl(ONT_LINE_DEF_HDLR.g_record.tax_date,FND_API.G_MISS_DATE) <>
1289: nvl(OE_Order_Cache.g_TAX_CODE_CACH.tax_date,FND_API.G_MISS_DATE)
1290: OR nvl(l_trx_type_id,FND_API.G_MISS_NUM) <>

Line 1287: nvl(OE_Order_Cache.g_TAX_CODE_CACH.ship_from_org_id ,FND_API.G_MISS_NUM)

1283: nvl(OE_Order_Cache.g_TAX_CODE_CACH.invoice_to_org_id,FND_API.G_MISS_NUM)
1284: OR nvl(ONT_LINE_DEF_HDLR.g_record.inventory_item_id,FND_API.G_MISS_NUM) <>
1285: nvl(OE_Order_Cache.g_TAX_CODE_CACH.inventory_item_id,FND_API.G_MISS_NUM)
1286: OR nvl(ONT_LINE_DEF_HDLR.g_record.ship_from_org_id,FND_API.G_MISS_NUM)<>
1287: nvl(OE_Order_Cache.g_TAX_CODE_CACH.ship_from_org_id ,FND_API.G_MISS_NUM)
1288: OR nvl(ONT_LINE_DEF_HDLR.g_record.tax_date,FND_API.G_MISS_DATE) <>
1289: nvl(OE_Order_Cache.g_TAX_CODE_CACH.tax_date,FND_API.G_MISS_DATE)
1290: OR nvl(l_trx_type_id,FND_API.G_MISS_NUM) <>
1291: nvl( OE_Order_Cache.g_TAX_CODE_CACH.trx_type_id,FND_API.G_MISS_NUM)

Line 1288: OR nvl(ONT_LINE_DEF_HDLR.g_record.tax_date,FND_API.G_MISS_DATE) <>

1284: OR nvl(ONT_LINE_DEF_HDLR.g_record.inventory_item_id,FND_API.G_MISS_NUM) <>
1285: nvl(OE_Order_Cache.g_TAX_CODE_CACH.inventory_item_id,FND_API.G_MISS_NUM)
1286: OR nvl(ONT_LINE_DEF_HDLR.g_record.ship_from_org_id,FND_API.G_MISS_NUM)<>
1287: nvl(OE_Order_Cache.g_TAX_CODE_CACH.ship_from_org_id ,FND_API.G_MISS_NUM)
1288: OR nvl(ONT_LINE_DEF_HDLR.g_record.tax_date,FND_API.G_MISS_DATE) <>
1289: nvl(OE_Order_Cache.g_TAX_CODE_CACH.tax_date,FND_API.G_MISS_DATE)
1290: OR nvl(l_trx_type_id,FND_API.G_MISS_NUM) <>
1291: nvl( OE_Order_Cache.g_TAX_CODE_CACH.trx_type_id,FND_API.G_MISS_NUM)
1292: THEN

Line 1289: nvl(OE_Order_Cache.g_TAX_CODE_CACH.tax_date,FND_API.G_MISS_DATE)

1285: nvl(OE_Order_Cache.g_TAX_CODE_CACH.inventory_item_id,FND_API.G_MISS_NUM)
1286: OR nvl(ONT_LINE_DEF_HDLR.g_record.ship_from_org_id,FND_API.G_MISS_NUM)<>
1287: nvl(OE_Order_Cache.g_TAX_CODE_CACH.ship_from_org_id ,FND_API.G_MISS_NUM)
1288: OR nvl(ONT_LINE_DEF_HDLR.g_record.tax_date,FND_API.G_MISS_DATE) <>
1289: nvl(OE_Order_Cache.g_TAX_CODE_CACH.tax_date,FND_API.G_MISS_DATE)
1290: OR nvl(l_trx_type_id,FND_API.G_MISS_NUM) <>
1291: nvl( OE_Order_Cache.g_TAX_CODE_CACH.trx_type_id,FND_API.G_MISS_NUM)
1292: THEN
1293:

Line 1290: OR nvl(l_trx_type_id,FND_API.G_MISS_NUM) <>

1286: OR nvl(ONT_LINE_DEF_HDLR.g_record.ship_from_org_id,FND_API.G_MISS_NUM)<>
1287: nvl(OE_Order_Cache.g_TAX_CODE_CACH.ship_from_org_id ,FND_API.G_MISS_NUM)
1288: OR nvl(ONT_LINE_DEF_HDLR.g_record.tax_date,FND_API.G_MISS_DATE) <>
1289: nvl(OE_Order_Cache.g_TAX_CODE_CACH.tax_date,FND_API.G_MISS_DATE)
1290: OR nvl(l_trx_type_id,FND_API.G_MISS_NUM) <>
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

Line 1291: nvl( OE_Order_Cache.g_TAX_CODE_CACH.trx_type_id,FND_API.G_MISS_NUM)

1287: nvl(OE_Order_Cache.g_TAX_CODE_CACH.ship_from_org_id ,FND_API.G_MISS_NUM)
1288: OR nvl(ONT_LINE_DEF_HDLR.g_record.tax_date,FND_API.G_MISS_DATE) <>
1289: nvl(OE_Order_Cache.g_TAX_CODE_CACH.tax_date,FND_API.G_MISS_DATE)
1290: OR nvl(l_trx_type_id,FND_API.G_MISS_NUM) <>
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 ) ;

Line 1366: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1362: 'GET_TAX_CODE'
1363: );
1364: END IF;
1365:
1366: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1367:
1368: END Get_Tax_Code;
1369:
1370: FUNCTION Get_Commitment_From_Agreement

Line 1569: AND l_sold_to_org_id <> fnd_api.g_miss_num

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
1570: THEN
1571:
1572: BEGIN
1573:

Line 1649: l_payment_type_code <> FND_API.G_MISS_CHAR AND

1645: l_header_id := ONT_HEADER_DEF_HDLR.g_record.header_id;
1646: END IF;
1647:
1648: IF l_payment_type_code IS NOT NULL AND
1649: l_payment_type_code <> FND_API.G_MISS_CHAR AND
1650: l_payment_type_code <> 'COMMITMENT' THEN /* Bug #3536642 */
1651:
1652: IF l_org_id IS NULL or l_org_id = FND_API.G_MISS_NUM THEN
1653: select org_id

Line 1652: IF l_org_id IS NULL or l_org_id = FND_API.G_MISS_NUM THEN

1648: IF l_payment_type_code IS NOT NULL AND
1649: l_payment_type_code <> FND_API.G_MISS_CHAR AND
1650: l_payment_type_code <> 'COMMITMENT' THEN /* Bug #3536642 */
1651:
1652: IF l_org_id IS NULL or l_org_id = FND_API.G_MISS_NUM THEN
1653: select org_id
1654: into l_org_id
1655: from oe_order_headers_all
1656: where header_id = l_header_id;

Line 1739: AND l_sold_to_org_id <> fnd_api.g_miss_num

1735: RETURN NULL;
1736: END IF;
1737:
1738: IF l_sold_to_org_id is not null
1739: AND l_sold_to_org_id <> fnd_api.g_miss_num
1740: THEN
1741:
1742: BEGIN
1743: