15: l_old_line_Payment_rec OE_AK_LINE_PAYMENTS_V%ROWTYPE;
16: l_operation VARCHAR2(30);
17: l_action NUMBER;
18: --
19: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
20: --
21: l_org_id number := 0;
22: l_payment_type_code varchar2(30) := NULL;
23: l_old_payment_type_code varchar2(30) := NULL;
24: l_defer varchar2(1) := NULL;
25:
26: BEGIN
27: IF l_debug_level > 0 THEN
28: oe_debug_pub.add( 'ENTER OE_DEFAULT_LINE_PAYMENT.ATTRIBUTES' ) ;
29: END IF;
30:
31: l_operation := p_x_line_payment_rec.operation;
32:
58: END IF;
59:
60: IF l_debug_level > 0 THEN
61: -- call the default handler framework to default the missing attributes
62: oe_debug_pub.add('g_line_payment_rec.credit_card_number...'||g_line_payment_rec.credit_card_number);
63: oe_debug_pub.add('g_line_payment_rec.credit_card_code...'||g_line_payment_rec.credit_card_code);
64:
65: IF OE_GLOBALS.G_UI_FLAG THEN
66: oe_debug_pub.add('G ui flag True');
59:
60: IF l_debug_level > 0 THEN
61: -- call the default handler framework to default the missing attributes
62: oe_debug_pub.add('g_line_payment_rec.credit_card_number...'||g_line_payment_rec.credit_card_number);
63: oe_debug_pub.add('g_line_payment_rec.credit_card_code...'||g_line_payment_rec.credit_card_code);
64:
65: IF OE_GLOBALS.G_UI_FLAG THEN
66: oe_debug_pub.add('G ui flag True');
67: ELSE
62: oe_debug_pub.add('g_line_payment_rec.credit_card_number...'||g_line_payment_rec.credit_card_number);
63: oe_debug_pub.add('g_line_payment_rec.credit_card_code...'||g_line_payment_rec.credit_card_code);
64:
65: IF OE_GLOBALS.G_UI_FLAG THEN
66: oe_debug_pub.add('G ui flag True');
67: ELSE
68: oe_debug_pub.add('Gui flag false');
69: END IF;
70:
64:
65: IF OE_GLOBALS.G_UI_FLAG THEN
66: oe_debug_pub.add('G ui flag True');
67: ELSE
68: oe_debug_pub.add('Gui flag false');
69: END IF;
70:
71: oe_debug_pub.add('In defaulting4');
72: END IF;
67: ELSE
68: oe_debug_pub.add('Gui flag false');
69: END IF;
70:
71: oe_debug_pub.add('In defaulting4');
72: END IF;
73: -- bug 5001819
74: /*IF p_x_line_payment_rec.trxn_extension_id IS NOT NULL THEN
75: g_line_payment_rec.credit_card_number := null;
105:
106: END IF;
107: --bug 5020737
108: IF l_debug_level > 0 THEN
109: oe_debug_pub.add('g_line_payment_rec.credit_card_number...'||g_line_payment_rec.credit_card_number);
110: oe_debug_pub.add('g_line_payment_rec.credit_card_code...'||g_line_payment_rec.credit_card_code);
111: END IF;
112: ONT_LINE_Payment_Def_Hdlr.Default_Record
113: (p_x_rec => g_line_payment_rec
106: END IF;
107: --bug 5020737
108: IF l_debug_level > 0 THEN
109: oe_debug_pub.add('g_line_payment_rec.credit_card_number...'||g_line_payment_rec.credit_card_number);
110: oe_debug_pub.add('g_line_payment_rec.credit_card_code...'||g_line_payment_rec.credit_card_code);
111: END IF;
112: ONT_LINE_Payment_Def_Hdlr.Default_Record
113: (p_x_rec => g_line_payment_rec
114: ,p_in_old_rec => l_old_line_payment_rec);
112: ONT_LINE_Payment_Def_Hdlr.Default_Record
113: (p_x_rec => g_line_payment_rec
114: ,p_in_old_rec => l_old_line_payment_rec);
115: IF l_debug_level > 0 THEN
116: oe_debug_pub.add('g_line_payment_rec.credit_card_number...'||g_line_payment_rec.credit_card_number);
117: oe_debug_pub.add('g_line_payment_rec.credit_card_code...'||g_line_payment_rec.credit_card_code);
118: oe_debug_pub.add('In defaulting5');
119: END IF;
120: -- copy the data back to a format that is compatible with the API architecture
113: (p_x_rec => g_line_payment_rec
114: ,p_in_old_rec => l_old_line_payment_rec);
115: IF l_debug_level > 0 THEN
116: oe_debug_pub.add('g_line_payment_rec.credit_card_number...'||g_line_payment_rec.credit_card_number);
117: oe_debug_pub.add('g_line_payment_rec.credit_card_code...'||g_line_payment_rec.credit_card_code);
118: oe_debug_pub.add('In defaulting5');
119: END IF;
120: -- copy the data back to a format that is compatible with the API architecture
121:
114: ,p_in_old_rec => l_old_line_payment_rec);
115: IF l_debug_level > 0 THEN
116: oe_debug_pub.add('g_line_payment_rec.credit_card_number...'||g_line_payment_rec.credit_card_number);
117: oe_debug_pub.add('g_line_payment_rec.credit_card_code...'||g_line_payment_rec.credit_card_code);
118: oe_debug_pub.add('In defaulting5');
119: END IF;
120: -- copy the data back to a format that is compatible with the API architecture
121:
122: OE_Line_Payment_UTIL.RowType_Rec_to_API_Rec
123: (p_record => g_line_Payment_rec
124: ,x_api_rec => p_x_line_Payment_rec);
125:
126: IF l_debug_level > 0 THEN
127: oe_debug_pub.add( 'CALL CONVERT_MISS_TO_NULL' ) ;
128: END IF;
129:
130: OE_LINE_Payment_UTIL.Convert_Miss_To_Null
131: (p_x_line_Payment_rec);
169: where payment_type_code = l_payment_type_code
170: and nvl(org_id, -99) = nvl(l_org_id, -99);
171:
172: IF l_debug_level > 0 THEN
173: oe_debug_pub.add( 'Defaulting the defer_payment_processing_flag. ' ) ;
174: END IF;
175:
176: p_x_line_Payment_rec.defer_payment_processing_flag := l_defer;
177: END IF;
190: p_x_Line_Payment_rec.lock_control := NULL;
191: END IF;
192:
193: IF l_debug_level > 0 THEN
194: oe_debug_pub.add( 'EXIT OE_DEFAULT_LINE_PAYMENT.ATTRIBUTES' ) ;
195: END IF;
196:
197: EXCEPTION
198:
225: l_payment_number NUMBER := NULL;
226: l_exists_null_number VARCHAR2(1) := 'N';
227: l_header_id NUMBER;
228: --
229: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
230: --
231: BEGIN
232:
233: IF l_debug_level > 0 THEN
230: --
231: BEGIN
232:
233: IF l_debug_level > 0 THEN
234: oe_debug_pub.add( 'In OE_Default_Line_Payment: FUNCTION Get_Payment_Number' ) ;
235: oe_debug_pub.add( 'line_id is: '||p_line_id ) ;
236: oe_debug_pub.add( 'header_id is: '||p_header_id ) ;
237: END IF;
238:
231: BEGIN
232:
233: IF l_debug_level > 0 THEN
234: oe_debug_pub.add( 'In OE_Default_Line_Payment: FUNCTION Get_Payment_Number' ) ;
235: oe_debug_pub.add( 'line_id is: '||p_line_id ) ;
236: oe_debug_pub.add( 'header_id is: '||p_header_id ) ;
237: END IF;
238:
239: IF p_line_id IS NOT NULL
232:
233: IF l_debug_level > 0 THEN
234: oe_debug_pub.add( 'In OE_Default_Line_Payment: FUNCTION Get_Payment_Number' ) ;
235: oe_debug_pub.add( 'line_id is: '||p_line_id ) ;
236: oe_debug_pub.add( 'header_id is: '||p_header_id ) ;
237: END IF;
238:
239: IF p_line_id IS NOT NULL
240: AND p_line_id <> FND_API.G_MISS_NUM THEN