DBA Data[Home] [Help]

APPS.OE_DEFAULT_PVT dependencies on OE_DEFAULT_PVT

Line 1: PACKAGE BODY OE_Default_Pvt AS

1: PACKAGE BODY OE_Default_Pvt AS
2: /* $Header: OEXVDEFB.pls 120.15 2012/01/03 18:58:13 gabhatia ship $ */
3:
4: -- Global constant holding the package name
5:

Line 6: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OE_Default_Pvt';

2: /* $Header: OEXVDEFB.pls 120.15 2012/01/03 18:58:13 gabhatia ship $ */
3:
4: -- Global constant holding the package name
5:
6: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OE_Default_Pvt';
7:
8: -----------------------------------------------------------------------
9: -- DEFAULTING FUNCTIONS TO BE USED FOR ATTRIBUTES ON ORDER HEADER
10: -----------------------------------------------------------------------

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 271: OE_Default_Pvt.g_default_instrument_id := l_assignments(1).instrument.instrument_id;

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;
275: ONT_HEADER_PAYMENT_DEF_HDLR.g_record.credit_card_holder_name := l_card_instrument.card_holder_name;

Line 272: OE_Default_Pvt.g_default_instr_assignment_id := l_assignments(1).assignment_id;

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;
275: ONT_HEADER_PAYMENT_DEF_HDLR.g_record.credit_card_holder_name := l_card_instrument.card_holder_name;
276: ONT_HEADER_PAYMENT_DEF_HDLR.g_record.credit_card_code := l_card_instrument.card_issuer;

Line 278: OE_Default_Pvt.g_default_instrument_id := l_assignments(1).instrument.instrument_id;

274: ONT_HEADER_PAYMENT_DEF_HDLR.g_record.credit_card_number := l_card_instrument.card_number;
275: ONT_HEADER_PAYMENT_DEF_HDLR.g_record.credit_card_holder_name := l_card_instrument.card_holder_name;
276: ONT_HEADER_PAYMENT_DEF_HDLR.g_record.credit_card_code := l_card_instrument.card_issuer;
277: ONT_HEADER_PAYMENT_DEF_HDLR.g_record.credit_card_expiration_date := l_card_instrument.expiration_date;
278: OE_Default_Pvt.g_default_instrument_id := l_assignments(1).instrument.instrument_id;
279: OE_Default_Pvt.g_default_instr_assignment_id := l_assignments(1).assignment_id;
280: ELSIF p_database_object_name = 'OE_AK_LINE_PAYMENTS_V' THEN
281: ONT_LINE_PAYMENT_DEF_HDLR.g_record.credit_card_number := l_card_instrument.card_number;
282: ONT_LINE_PAYMENT_DEF_HDLR.g_record.credit_card_holder_name := l_card_instrument.card_holder_name;

Line 279: OE_Default_Pvt.g_default_instr_assignment_id := l_assignments(1).assignment_id;

275: ONT_HEADER_PAYMENT_DEF_HDLR.g_record.credit_card_holder_name := l_card_instrument.card_holder_name;
276: ONT_HEADER_PAYMENT_DEF_HDLR.g_record.credit_card_code := l_card_instrument.card_issuer;
277: ONT_HEADER_PAYMENT_DEF_HDLR.g_record.credit_card_expiration_date := l_card_instrument.expiration_date;
278: OE_Default_Pvt.g_default_instrument_id := l_assignments(1).instrument.instrument_id;
279: OE_Default_Pvt.g_default_instr_assignment_id := l_assignments(1).assignment_id;
280: ELSIF p_database_object_name = 'OE_AK_LINE_PAYMENTS_V' THEN
281: ONT_LINE_PAYMENT_DEF_HDLR.g_record.credit_card_number := l_card_instrument.card_number;
282: ONT_LINE_PAYMENT_DEF_HDLR.g_record.credit_card_holder_name := l_card_instrument.card_holder_name;
283: ONT_LINE_PAYMENT_DEF_HDLR.g_record.credit_card_code := l_card_instrument.card_issuer;

Line 285: OE_Default_Pvt.g_default_instrument_id := l_assignments(1).instrument.instrument_id;

281: ONT_LINE_PAYMENT_DEF_HDLR.g_record.credit_card_number := l_card_instrument.card_number;
282: ONT_LINE_PAYMENT_DEF_HDLR.g_record.credit_card_holder_name := l_card_instrument.card_holder_name;
283: ONT_LINE_PAYMENT_DEF_HDLR.g_record.credit_card_code := l_card_instrument.card_issuer;
284: ONT_LINE_PAYMENT_DEF_HDLR.g_record.credit_card_expiration_date := l_card_instrument.expiration_date;
285: OE_Default_Pvt.g_default_instrument_id := l_assignments(1).instrument.instrument_id;
286: OE_Default_Pvt.g_default_instr_assignment_id := l_assignments(1).assignment_id;
287: END IF;
288:
289:

Line 286: OE_Default_Pvt.g_default_instr_assignment_id := l_assignments(1).assignment_id;

282: ONT_LINE_PAYMENT_DEF_HDLR.g_record.credit_card_holder_name := l_card_instrument.card_holder_name;
283: ONT_LINE_PAYMENT_DEF_HDLR.g_record.credit_card_code := l_card_instrument.card_issuer;
284: ONT_LINE_PAYMENT_DEF_HDLR.g_record.credit_card_expiration_date := l_card_instrument.expiration_date;
285: OE_Default_Pvt.g_default_instrument_id := l_assignments(1).instrument.instrument_id;
286: OE_Default_Pvt.g_default_instr_assignment_id := l_assignments(1).assignment_id;
287: END IF;
288:
289:
290: --R12 CC Encryption

Line 324: , 'OE_DEFAULT_PVT'

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
324: , 'OE_DEFAULT_PVT'
325: );
326: END IF;
327:
328: OE_MSG_PUB.Count_And_Get

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 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 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 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 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 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 1801: END OE_Default_Pvt;

1797: END Get_Latest_Acceptable_Date;
1798:
1799: --end bug 13088960
1800:
1801: END OE_Default_Pvt;