72:
73:
74: IF p_database_object_name = 'OE_AK_ORDER_HEADERS_V' THEN
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
74: IF p_database_object_name = 'OE_AK_ORDER_HEADERS_V' THEN
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;
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
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
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;
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
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...
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
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
89: RETURN NULL;
90: END IF; -- if ont_header_def_hdlr.g_record.sold_to_org_id is not null
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
89: RETURN NULL;
90: END IF; -- if ont_header_def_hdlr.g_record.sold_to_org_id is not null
91:
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
89: RETURN NULL;
90: END IF; -- if ont_header_def_hdlr.g_record.sold_to_org_id is not null
91:
92: ELSIF p_database_object_name = 'OE_AK_HEADER_PAYMENTS_V' THEN
93:
94: l_payment_type_code := ONT_HEADER_PAYMENT_DEF_HDLR.g_record.payment_type_code;
114: END IF;
115:
116: /* Fix Bug #2297053:Customer of Invoice To may be different from the Sold To */
117: --R12 CC Encryption Verify
118: --l_trans_curr_code := ONT_HEADER_DEF_HDLR.transactional_curr_code;
119: --R12 CC Encryption
120:
121: IF l_invoice_to_org_id is not null THEN
122: OPEN C_Invoice_To_Cust(l_invoice_to_org_id);
263: END IF;
264:
265:
266: IF p_database_object_name = 'OE_AK_ORDER_HEADERS_V' THEN
267: ONT_HEADER_DEF_HDLR.g_record.credit_card_number := l_card_instrument.card_number;
268: ONT_HEADER_DEF_HDLR.g_record.credit_card_holder_name := l_card_instrument.card_holder_name;
269: ONT_HEADER_DEF_HDLR.g_record.credit_card_code := l_card_instrument.card_issuer;
270: ONT_HEADER_DEF_HDLR.g_record.credit_card_expiration_date := l_card_instrument.expiration_date;
271: OE_Default_Pvt.g_default_instrument_id := l_assignments(1).instrument.instrument_id;
264:
265:
266: IF p_database_object_name = 'OE_AK_ORDER_HEADERS_V' THEN
267: ONT_HEADER_DEF_HDLR.g_record.credit_card_number := l_card_instrument.card_number;
268: ONT_HEADER_DEF_HDLR.g_record.credit_card_holder_name := l_card_instrument.card_holder_name;
269: ONT_HEADER_DEF_HDLR.g_record.credit_card_code := l_card_instrument.card_issuer;
270: ONT_HEADER_DEF_HDLR.g_record.credit_card_expiration_date := l_card_instrument.expiration_date;
271: OE_Default_Pvt.g_default_instrument_id := l_assignments(1).instrument.instrument_id;
272: OE_Default_Pvt.g_default_instr_assignment_id := l_assignments(1).assignment_id;
265:
266: IF p_database_object_name = 'OE_AK_ORDER_HEADERS_V' THEN
267: ONT_HEADER_DEF_HDLR.g_record.credit_card_number := l_card_instrument.card_number;
268: ONT_HEADER_DEF_HDLR.g_record.credit_card_holder_name := l_card_instrument.card_holder_name;
269: ONT_HEADER_DEF_HDLR.g_record.credit_card_code := l_card_instrument.card_issuer;
270: ONT_HEADER_DEF_HDLR.g_record.credit_card_expiration_date := l_card_instrument.expiration_date;
271: OE_Default_Pvt.g_default_instrument_id := l_assignments(1).instrument.instrument_id;
272: OE_Default_Pvt.g_default_instr_assignment_id := l_assignments(1).assignment_id;
273: ELSIF p_database_object_name = 'OE_AK_HEADER_PAYMENTS_V' THEN
266: IF p_database_object_name = 'OE_AK_ORDER_HEADERS_V' THEN
267: ONT_HEADER_DEF_HDLR.g_record.credit_card_number := l_card_instrument.card_number;
268: ONT_HEADER_DEF_HDLR.g_record.credit_card_holder_name := l_card_instrument.card_holder_name;
269: ONT_HEADER_DEF_HDLR.g_record.credit_card_code := l_card_instrument.card_issuer;
270: ONT_HEADER_DEF_HDLR.g_record.credit_card_expiration_date := l_card_instrument.expiration_date;
271: OE_Default_Pvt.g_default_instrument_id := l_assignments(1).instrument.instrument_id;
272: OE_Default_Pvt.g_default_instr_assignment_id := l_assignments(1).assignment_id;
273: ELSIF p_database_object_name = 'OE_AK_HEADER_PAYMENTS_V' THEN
274: ONT_HEADER_PAYMENT_DEF_HDLR.g_record.credit_card_number := l_card_instrument.card_number;
341: BEGIN
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
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
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
351: THEN
407: ** Old defaulting code will not even get executed now.
408: */
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:
408: */
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;
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'
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
429: END IF;
430: RETURN NULL;
431:
432: /*IF p_database_object_name = 'OE_AK_ORDER_HEADERS_V' THEN
433: l_credit_card_number := ONT_HEADER_DEF_HDLR.g_record.credit_card_number;
434: ELSIF p_database_object_name = 'OE_AK_HEADER_PAYMENTS_V' THEN
435: l_credit_card_number := ONT_HEADER_PAYMENT_DEF_HDLR.g_record.credit_card_number;
436: ELSIF p_database_object_name = 'OE_AK_LINE_PAYMENTS_V' THEN
437: l_credit_card_number := ONT_LINE_PAYMENT_DEF_HDLR.g_record.credit_card_number;
450: -- code below is not needed. Hence the return statement is above this line
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;
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
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
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;
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
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...
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
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
465:
466: ELSIF p_database_object_name = 'OE_AK_HEADER_PAYMENTS_V' THEN
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
465:
466: ELSIF p_database_object_name = 'OE_AK_HEADER_PAYMENTS_V' THEN
467:
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
465:
466: ELSIF p_database_object_name = 'OE_AK_HEADER_PAYMENTS_V' THEN
467:
468: OPEN get_hdr_sold_inv(ONT_HEADER_PAYMENT_DEF_HDLR.g_record.header_id);
537: BEGIN
538:
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;
538:
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'
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
548: AND ONT_HEADER_PAYMENT_DEF_HDLR.g_record.credit_card_expiration_date
549: <> FND_API.G_MISS_DATE
564: ** Old defaulting code will not even get executed now.
565: */
566:
567: /*IF p_database_object_name = 'OE_AK_ORDER_HEADERS_V' THEN
568: l_credit_card_number := ONT_HEADER_DEF_HDLR.g_record.credit_card_number;
569: ELSIF p_database_object_name = 'OE_AK_HEADER_PAYMENTS_V' THEN
570: l_credit_card_number := ONT_HEADER_PAYMENT_DEF_HDLR.g_record.credit_card_number;
571: ELSIF p_database_object_name = 'OE_AK_LINE_PAYMENTS_V' THEN
572: l_credit_card_number := ONT_LINE_PAYMENT_DEF_HDLR.g_record.credit_card_number;
580: END IF;
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
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
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
590: , ONT_HEADER_DEF_HDLR.g_record.invoice_to_org_id
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);
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);
592: ELSE
593: l_Bank_Account_ID := arp_bank_pkg.get_primary_bank_acct
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);
592: ELSE
593: l_Bank_Account_ID := arp_bank_pkg.get_primary_bank_acct
594: (ONT_HEADER_DEF_HDLR.g_record.sold_to_org_id);
590: , ONT_HEADER_DEF_HDLR.g_record.invoice_to_org_id
591: , TRUE);
592: ELSE
593: l_Bank_Account_ID := arp_bank_pkg.get_primary_bank_acct
594: (ONT_HEADER_DEF_HDLR.g_record.sold_to_org_id);
595: END IF;
596: ELSE
597: RETURN NULL;
598: END IF;
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
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
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
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
660: THEN
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:
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:
662:
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,
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,
664: ONT_HEADER_DEF_HDLR.g_record.Invoice_To_Org_id,
665: ONT_HEADER_DEF_HDLR.g_record.ordered_date);
666: FETCH C_Std_Tax_Exemption INTO l_tax_exempt_number;
667: CLOSE C_Std_Tax_Exemption;
660: THEN
661:
662:
663: OPEN C_Std_Tax_Exemption(ONT_HEADER_DEF_HDLR.g_record.ship_to_org_id,
664: ONT_HEADER_DEF_HDLR.g_record.Invoice_To_Org_id,
665: ONT_HEADER_DEF_HDLR.g_record.ordered_date);
666: FETCH C_Std_Tax_Exemption INTO l_tax_exempt_number;
667: CLOSE C_Std_Tax_Exemption;
668: END IF;
661:
662:
663: OPEN C_Std_Tax_Exemption(ONT_HEADER_DEF_HDLR.g_record.ship_to_org_id,
664: ONT_HEADER_DEF_HDLR.g_record.Invoice_To_Org_id,
665: ONT_HEADER_DEF_HDLR.g_record.ordered_date);
666: FETCH C_Std_Tax_Exemption INTO l_tax_exempt_number;
667: CLOSE C_Std_Tax_Exemption;
668: END IF;
669: RETURN l_tax_exempt_number;
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
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
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
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
723: THEN
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:
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:
725: OPEN C_Std_Tax_Exemption(ONT_HEADER_DEF_HDLR.g_record.ship_to_org_id,
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,
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,
727: ONT_HEADER_DEF_HDLR.g_record.ordered_date);
728: FETCH C_Std_Tax_Exemption INTO l_tax_exempt_reason_code;
729: CLOSE C_Std_Tax_Exemption;
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,
727: ONT_HEADER_DEF_HDLR.g_record.ordered_date);
728: FETCH C_Std_Tax_Exemption INTO l_tax_exempt_reason_code;
729: CLOSE C_Std_Tax_Exemption;
730: END IF;
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,
727: ONT_HEADER_DEF_HDLR.g_record.ordered_date);
728: FETCH C_Std_Tax_Exemption INTO l_tax_exempt_reason_code;
729: CLOSE C_Std_Tax_Exemption;
730: END IF;
731: RETURN l_tax_exempt_reason_code;
1022:
1023: EXCEPTION
1024: WHEN NO_DATA_FOUND THEN
1025: IF p_database_object_name = 'OE_AK_ORDER_HEADERS_V' THEN
1026: ONT_HEADER_Def_Hdlr.g_record.tax_exempt_number := NULL;
1027: ONT_HEADER_Def_Hdlr.g_record.tax_exempt_reason_code := NULL;
1028: ELSIF p_database_object_name = 'OE_AK_ORDER_LINES_V' THEN
1029: ONT_LINE_Def_Hdlr.g_record.tax_exempt_number := NULL;
1030: ONT_LINE_Def_Hdlr.g_record.tax_exempt_reason_code := NULL;
1023: EXCEPTION
1024: WHEN NO_DATA_FOUND THEN
1025: IF p_database_object_name = 'OE_AK_ORDER_HEADERS_V' THEN
1026: ONT_HEADER_Def_Hdlr.g_record.tax_exempt_number := NULL;
1027: ONT_HEADER_Def_Hdlr.g_record.tax_exempt_reason_code := NULL;
1028: ELSIF p_database_object_name = 'OE_AK_ORDER_LINES_V' THEN
1029: ONT_LINE_Def_Hdlr.g_record.tax_exempt_number := NULL;
1030: ONT_LINE_Def_Hdlr.g_record.tax_exempt_reason_code := NULL;
1031: END IF;
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
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;
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;
1626: IF l_debug_level > 0 THEN
1627: oe_debug_pub.add('Entering Get_Receipt_Method');
1628: END IF;
1629:
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;
1647:
1648: IF l_payment_type_code IS NOT NULL AND
1649: l_payment_type_code <> FND_API.G_MISS_CHAR AND
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;
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