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.ASO_PAYMENT_INT dependencies on FND_API

Line 39: IF c_pay_term1%FOUND and l_payment_term_id IS NOT NULL and l_payment_term_id <> FND_API.G_MISS_NUM THEN

35:
36: OPEN c_pay_term1;
37: FETCH c_pay_term1 INTO l_payment_term_id;
38:
39: IF c_pay_term1%FOUND and l_payment_term_id IS NOT NULL and l_payment_term_id <> FND_API.G_MISS_NUM THEN
40:
41: CLOSE c_pay_term1;
42: return l_payment_term_id;
43:

Line 50: IF c_pay_term2%FOUND and l_payment_term_id IS NOT NULL and l_payment_term_id <> FND_API.G_MISS_NUM THEN

46:
47: OPEN c_pay_term2;
48: FETCH c_pay_term2 INTO l_payment_term_id;
49:
50: IF c_pay_term2%FOUND and l_payment_term_id IS NOT NULL and l_payment_term_id <> FND_API.G_MISS_NUM THEN
51:
52: CLOSE c_pay_term2;
53: return l_payment_term_id;
54:

Line 93: x_return_status := FND_API.G_RET_STS_SUCCESS;

89: IF aso_debug_pub.g_debug_flag = 'Y' THEN
90: aso_debug_pub.add('Begin create_iby_payment ', 1, 'Y');
91: END IF;
92:
93: x_return_status := FND_API.G_RET_STS_SUCCESS;
94:
95: x_payment_rec := l_payment_rec;
96:
97: l_qte_header_rec := ASO_UTILITY_PVT.Query_Header_Row (l_payment_rec.Quote_Header_Id );

Line 99: IF ( l_payment_rec.Quote_Line_Id IS NOT NULL and l_payment_rec.Quote_Line_Id <> fnd_api.g_miss_num) then

95: x_payment_rec := l_payment_rec;
96:
97: l_qte_header_rec := ASO_UTILITY_PVT.Query_Header_Row (l_payment_rec.Quote_Header_Id );
98:
99: IF ( l_payment_rec.Quote_Line_Id IS NOT NULL and l_payment_rec.Quote_Line_Id <> fnd_api.g_miss_num) then
100: l_qte_line_rec := ASO_UTILITY_PVT.Query_Qte_Line_Row ( l_payment_rec.Quote_Line_Id );
101: END IF;
102:
103:

Line 106: or ( l_payment_rec.payment_type_code = fnd_api.g_miss_char and db_payment_rec.payment_type_code = 'CREDIT_CARD'))

102:
103:
104:
105: if (l_payment_rec.payment_type_code = 'CREDIT_CARD'
106: or ( l_payment_rec.payment_type_code = fnd_api.g_miss_char and db_payment_rec.payment_type_code = 'CREDIT_CARD'))
107: and
108: l_payment_rec.payment_ref_number is not null and
109: l_payment_rec.payment_ref_number <> fnd_api.g_miss_char then
110:

Line 109: l_payment_rec.payment_ref_number <> fnd_api.g_miss_char then

105: if (l_payment_rec.payment_type_code = 'CREDIT_CARD'
106: or ( l_payment_rec.payment_type_code = fnd_api.g_miss_char and db_payment_rec.payment_type_code = 'CREDIT_CARD'))
107: and
108: l_payment_rec.payment_ref_number is not null and
109: l_payment_rec.payment_ref_number <> fnd_api.g_miss_char then
110:
111: IF aso_debug_pub.g_debug_flag = 'Y' THEN
112: aso_debug_pub.add('Inside if for payment type credit card', 1, 'Y');
113: END IF;

Line 115: If (l_payment_rec.instr_assignment_id is null or l_payment_rec.instr_assignment_id = fnd_api.g_miss_num ) then

111: IF aso_debug_pub.g_debug_flag = 'Y' THEN
112: aso_debug_pub.add('Inside if for payment type credit card', 1, 'Y');
113: END IF;
114:
115: If (l_payment_rec.instr_assignment_id is null or l_payment_rec.instr_assignment_id = fnd_api.g_miss_num ) then
116:
117: l_credit_card.card_id := null;
118:
119: If ( l_payment_rec.Quote_Line_Id IS NOT NULL and l_payment_rec.Quote_Line_Id <> fnd_api.g_miss_num) then

Line 119: If ( l_payment_rec.Quote_Line_Id IS NOT NULL and l_payment_rec.Quote_Line_Id <> fnd_api.g_miss_num) then

115: If (l_payment_rec.instr_assignment_id is null or l_payment_rec.instr_assignment_id = fnd_api.g_miss_num ) then
116:
117: l_credit_card.card_id := null;
118:
119: If ( l_payment_rec.Quote_Line_Id IS NOT NULL and l_payment_rec.Quote_Line_Id <> fnd_api.g_miss_num) then
120: l_credit_card.owner_id := l_qte_line_rec.invoice_to_cust_party_id;
121: l_credit_card.billing_address_id := l_qte_line_rec.invoice_to_party_site_id;
122: Else
123: l_credit_card.owner_id := l_qte_header_rec.invoice_to_cust_party_id;

Line 161: p_init_msg_list => FND_API.G_FALSE,

157:
158: IBY_FNDCPT_SETUP_PUB.Process_Credit_Card
159: (
160: p_api_version => 1.0,
161: p_init_msg_list => FND_API.G_FALSE,
162: p_commit => FND_API.G_FALSE,
163: x_return_status => x_return_status,
164: x_msg_count => x_msg_count,
165: x_msg_data => x_msg_data,

Line 162: p_commit => FND_API.G_FALSE,

158: IBY_FNDCPT_SETUP_PUB.Process_Credit_Card
159: (
160: p_api_version => 1.0,
161: p_init_msg_list => FND_API.G_FALSE,
162: p_commit => FND_API.G_FALSE,
163: x_return_status => x_return_status,
164: x_msg_count => x_msg_count,
165: x_msg_data => x_msg_data,
166: p_payer => p_payer,

Line 181: if x_return_status <> fnd_api.g_ret_sts_success then

177: aso_debug_pub.add('IBY Process_Credit_Card x_response.result_message: '|| to_char(lx_response.result_message), 1, 'Y');
178: aso_debug_pub.add('IBY Process_Credit_Card x_assign_id: '|| to_char(lx_assign_id), 1, 'Y');
179: END IF;
180:
181: if x_return_status <> fnd_api.g_ret_sts_success then
182: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
183: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
184: FND_MESSAGE.Set_Token('API', 'IBY_FNDCPT_SETUP_PUB.Process_Credit_Card ', FALSE);
185: FND_MSG_PUB.ADD;

Line 187: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

183: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
184: FND_MESSAGE.Set_Token('API', 'IBY_FNDCPT_SETUP_PUB.Process_Credit_Card ', FALSE);
185: FND_MSG_PUB.ADD;
186: END IF;
187: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
188: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
189: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
190: RAISE FND_API.G_EXC_ERROR;
191: END IF;

Line 188: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

184: FND_MESSAGE.Set_Token('API', 'IBY_FNDCPT_SETUP_PUB.Process_Credit_Card ', FALSE);
185: FND_MSG_PUB.ADD;
186: END IF;
187: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
188: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
189: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
190: RAISE FND_API.G_EXC_ERROR;
191: END IF;
192: end if;

Line 189: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN

185: FND_MSG_PUB.ADD;
186: END IF;
187: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
188: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
189: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
190: RAISE FND_API.G_EXC_ERROR;
191: END IF;
192: end if;
193:

Line 190: RAISE FND_API.G_EXC_ERROR;

186: END IF;
187: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
188: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
189: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
190: RAISE FND_API.G_EXC_ERROR;
191: END IF;
192: end if;
193:
194: x_payment_rec.instr_assignment_id := lx_assign_id;

Line 204: WHEN FND_API.G_EXC_ERROR THEN

200: aso_debug_pub.ADD ('END create_iby_payment',1,'N');
201: END IF;
202:
203: EXCEPTION
204: WHEN FND_API.G_EXC_ERROR THEN
205: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
206: P_API_NAME => L_API_NAME
207: ,P_PKG_NAME => G_PKG_NAME
208: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 214: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

210: ,X_MSG_COUNT => X_MSG_COUNT
211: ,X_MSG_DATA => X_MSG_DATA
212: ,X_RETURN_STATUS => X_RETURN_STATUS);
213:
214: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
215: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
216: P_API_NAME => L_API_NAME
217: ,P_PKG_NAME => G_PKG_NAME
218: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

Line 289: x_return_status := FND_API.G_RET_STS_SUCCESS;

285: IF aso_debug_pub.g_debug_flag = 'Y' THEN
286: aso_debug_pub.add('Begin create_payment_row ', 1, 'Y');
287: END IF;
288:
289: x_return_status := FND_API.G_RET_STS_SUCCESS;
290:
291: IF aso_debug_pub.g_debug_flag = 'Y' THEN
292: aso_debug_pub.add('l_payment_rec.Quote_Header_Id: '||l_payment_rec.Quote_Header_Id, 1, 'Y');
293: aso_debug_pub.add('l_payment_rec.Quote_Line_Id: '||l_payment_rec.Quote_Line_Id, 1, 'Y');

Line 299: IF ( l_payment_rec.Quote_Line_Id IS NOT NULL and l_payment_rec.Quote_Line_Id <> fnd_api.g_miss_num) then

295: aso_debug_pub.add('l_payment_rec.instr_assignment_id: '||l_payment_rec.instr_assignment_id, 1, 'Y');
296: END IF;
297:
298: -- Check for duplicate payments see bug 5118000
299: IF ( l_payment_rec.Quote_Line_Id IS NOT NULL and l_payment_rec.Quote_Line_Id <> fnd_api.g_miss_num) then
300: IF aso_debug_pub.g_debug_flag = 'Y' THEN
301: aso_debug_pub.add('Checking for duplicate payment records at line level', 1, 'Y');
302: END IF;
303: open c_get_db_line_payment(l_payment_rec.Quote_Header_Id,l_payment_rec.Quote_Line_Id);

Line 306: x_return_status := FND_API.G_RET_STS_ERROR;

302: END IF;
303: open c_get_db_line_payment(l_payment_rec.Quote_Header_Id,l_payment_rec.Quote_Line_Id);
304: fetch c_get_db_line_payment into l_existing_payment_id;
305: if c_get_db_line_payment%FOUND THEN
306: x_return_status := FND_API.G_RET_STS_ERROR;
307: close c_get_db_line_payment;
308: FND_MESSAGE.Set_Name('ASO', 'ASO_API_MULTIPLE_PAYMENTS');
309: FND_MSG_PUB.ADD;
310: RAISE FND_API.G_EXC_ERROR;

Line 310: RAISE FND_API.G_EXC_ERROR;

306: x_return_status := FND_API.G_RET_STS_ERROR;
307: close c_get_db_line_payment;
308: FND_MESSAGE.Set_Name('ASO', 'ASO_API_MULTIPLE_PAYMENTS');
309: FND_MSG_PUB.ADD;
310: RAISE FND_API.G_EXC_ERROR;
311: end if;
312: close c_get_db_line_payment;
313: ELSE
314: IF aso_debug_pub.g_debug_flag = 'Y' THEN

Line 320: x_return_status := FND_API.G_RET_STS_ERROR;

316: END IF;
317: open c_get_db_hdr_payment(l_payment_rec.Quote_Header_Id);
318: fetch c_get_db_hdr_payment into l_existing_payment_id;
319: if c_get_db_hdr_payment%FOUND THEN
320: x_return_status := FND_API.G_RET_STS_ERROR;
321: close c_get_db_hdr_payment;
322: FND_MESSAGE.Set_Name('ASO', 'ASO_API_MULTIPLE_PAYMENTS');
323: FND_MSG_PUB.ADD;
324: RAISE FND_API.G_EXC_ERROR;

Line 324: RAISE FND_API.G_EXC_ERROR;

320: x_return_status := FND_API.G_RET_STS_ERROR;
321: close c_get_db_hdr_payment;
322: FND_MESSAGE.Set_Name('ASO', 'ASO_API_MULTIPLE_PAYMENTS');
323: FND_MSG_PUB.ADD;
324: RAISE FND_API.G_EXC_ERROR;
325: end if;
326: close c_get_db_hdr_payment;
327: END IF;
328:

Line 337: IF ( l_payment_rec.Quote_Line_Id IS NOT NULL and l_payment_rec.Quote_Line_Id <> fnd_api.g_miss_num) then

333: aso_debug_pub.add('After querying the header row', 1, 'Y');
334: aso_debug_pub.add('l_qte_header_rec.quote_header_id: ' || l_qte_header_rec.quote_header_id, 1, 'Y');
335: END IF;
336:
337: IF ( l_payment_rec.Quote_Line_Id IS NOT NULL and l_payment_rec.Quote_Line_Id <> fnd_api.g_miss_num) then
338: l_qte_line_rec := ASO_UTILITY_PVT.Query_Qte_Line_Row ( l_payment_rec.Quote_Line_Id );
339: END IF;
340:
341: IF aso_debug_pub.g_debug_flag = 'Y' THEN

Line 346: ((l_payment_rec.payment_ref_number is not null and l_payment_rec.payment_ref_number <> fnd_api.g_miss_char) or

342: aso_debug_pub.add('After querying the line row', 1, 'Y');
343: END IF;
344:
345: if ( l_payment_rec.payment_type_code = 'CREDIT_CARD' and
346: ((l_payment_rec.payment_ref_number is not null and l_payment_rec.payment_ref_number <> fnd_api.g_miss_char) or
347: (l_payment_rec.instr_assignment_id is not null and l_payment_rec.instr_assignment_id <> fnd_api.g_miss_num)) ) then
348:
349: IF aso_debug_pub.g_debug_flag = 'Y' THEN
350: aso_debug_pub.add('Inside if for payment type credit card', 1, 'Y');

Line 347: (l_payment_rec.instr_assignment_id is not null and l_payment_rec.instr_assignment_id <> fnd_api.g_miss_num)) ) then

343: END IF;
344:
345: if ( l_payment_rec.payment_type_code = 'CREDIT_CARD' and
346: ((l_payment_rec.payment_ref_number is not null and l_payment_rec.payment_ref_number <> fnd_api.g_miss_char) or
347: (l_payment_rec.instr_assignment_id is not null and l_payment_rec.instr_assignment_id <> fnd_api.g_miss_num)) ) then
348:
349: IF aso_debug_pub.g_debug_flag = 'Y' THEN
350: aso_debug_pub.add('Inside if for payment type credit card', 1, 'Y');
351: END IF;

Line 359: p_init_msg_list => fnd_api.g_false,

355: aso_debug_pub.add('Before calling Validate_cc_info ', 1, 'Y');
356: END IF;
357: aso_validate_pvt.Validate_cc_info
358: (
359: p_init_msg_list => fnd_api.g_false,
360: p_payment_rec => l_payment_rec,
361: p_qte_header_rec => l_qte_header_rec,
362: P_Qte_Line_rec => l_qte_line_rec,
363: x_return_status => x_return_status,

Line 372: if x_return_status <> fnd_api.g_ret_sts_success then

368: aso_debug_pub.add('after calling Validate_cc_info ', 1, 'Y');
369: aso_debug_pub.add('Validate_cc_info Return Status: '||x_return_status, 1, 'Y');
370: END IF;
371:
372: if x_return_status <> fnd_api.g_ret_sts_success then
373: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
374: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
375: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
376: RAISE FND_API.G_EXC_ERROR;

Line 373: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

369: aso_debug_pub.add('Validate_cc_info Return Status: '||x_return_status, 1, 'Y');
370: END IF;
371:
372: if x_return_status <> fnd_api.g_ret_sts_success then
373: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
374: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
375: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
376: RAISE FND_API.G_EXC_ERROR;
377: ELSE

Line 374: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

370: END IF;
371:
372: if x_return_status <> fnd_api.g_ret_sts_success then
373: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
374: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
375: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
376: RAISE FND_API.G_EXC_ERROR;
377: ELSE
378: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 375: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN

371:
372: if x_return_status <> fnd_api.g_ret_sts_success then
373: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
374: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
375: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
376: RAISE FND_API.G_EXC_ERROR;
377: ELSE
378: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
379: END IF;

Line 376: RAISE FND_API.G_EXC_ERROR;

372: if x_return_status <> fnd_api.g_ret_sts_success then
373: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
374: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
375: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
376: RAISE FND_API.G_EXC_ERROR;
377: ELSE
378: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
379: END IF;
380: end if;

Line 378: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

374: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
375: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
376: RAISE FND_API.G_EXC_ERROR;
377: ELSE
378: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
379: END IF;
380: end if;
381:
382: l_payer.cust_account_id := null;

Line 386: if (p_payment_rec.instr_assignment_id is null or p_payment_rec.instr_assignment_id = fnd_api.g_miss_num) then

382: l_payer.cust_account_id := null;
383: l_payer.account_site_id := null;
384: l_payer.payment_function := 'CUSTOMER_PAYMENT';
385:
386: if (p_payment_rec.instr_assignment_id is null or p_payment_rec.instr_assignment_id = fnd_api.g_miss_num) then
387: -- this is the Quoting flow
388:
389: If ( l_payment_rec.Quote_Line_Id IS NOT NULL and l_payment_rec.Quote_Line_Id <> fnd_api.g_miss_num) then
390: l_payer.party_id := l_qte_line_rec.invoice_to_cust_party_id;

Line 389: If ( l_payment_rec.Quote_Line_Id IS NOT NULL and l_payment_rec.Quote_Line_Id <> fnd_api.g_miss_num) then

385:
386: if (p_payment_rec.instr_assignment_id is null or p_payment_rec.instr_assignment_id = fnd_api.g_miss_num) then
387: -- this is the Quoting flow
388:
389: If ( l_payment_rec.Quote_Line_Id IS NOT NULL and l_payment_rec.Quote_Line_Id <> fnd_api.g_miss_num) then
390: l_payer.party_id := l_qte_line_rec.invoice_to_cust_party_id;
391: Else
392: l_payer.party_id := l_qte_header_rec.invoice_to_cust_party_id;
393: End If;

Line 412: if x_return_status <> fnd_api.g_ret_sts_success then

408: aso_debug_pub.add('after calling create_iby_payment ', 1, 'Y');
409: aso_debug_pub.add('create_iby_payment Return Status: '||x_return_status, 1, 'Y');
410: END IF;
411:
412: if x_return_status <> fnd_api.g_ret_sts_success then
413: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
414: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
415: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
416: RAISE FND_API.G_EXC_ERROR;

Line 413: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

409: aso_debug_pub.add('create_iby_payment Return Status: '||x_return_status, 1, 'Y');
410: END IF;
411:
412: if x_return_status <> fnd_api.g_ret_sts_success then
413: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
414: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
415: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
416: RAISE FND_API.G_EXC_ERROR;
417: ELSE

Line 414: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

410: END IF;
411:
412: if x_return_status <> fnd_api.g_ret_sts_success then
413: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
414: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
415: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
416: RAISE FND_API.G_EXC_ERROR;
417: ELSE
418: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 415: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN

411:
412: if x_return_status <> fnd_api.g_ret_sts_success then
413: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
414: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
415: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
416: RAISE FND_API.G_EXC_ERROR;
417: ELSE
418: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
419: END IF;

Line 416: RAISE FND_API.G_EXC_ERROR;

412: if x_return_status <> fnd_api.g_ret_sts_success then
413: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
414: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
415: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
416: RAISE FND_API.G_EXC_ERROR;
417: ELSE
418: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
419: END IF;
420: end if;

Line 418: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

414: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
415: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
416: RAISE FND_API.G_EXC_ERROR;
417: ELSE
418: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
419: END IF;
420: end if;
421: else
422: -- this is the iStore Flow

Line 435: if (l_payment_rec.payment_id is null or l_payment_rec.payment_id = fnd_api.g_miss_num) then

431: end if;
432:
433: -- generate the payment id if it is not passed, this is possible
434: -- when quote is being created first time and payment rec is created at same time
435: if (l_payment_rec.payment_id is null or l_payment_rec.payment_id = fnd_api.g_miss_num) then
436: open c_get_payment_id;
437: fetch c_get_payment_id into l_payment_rec.payment_id;
438: close c_get_payment_id;
439: end if;

Line 446: IF l_payment_rec.quote_line_id = fnd_api.g_miss_num then

442: l_trxn_attribs.Order_Id := to_char(l_payment_rec.payment_id)||'-'||l_qte_header_rec.quote_number;
443: l_trxn_attribs.PO_Number := null;
444: l_trxn_attribs.PO_Line_Number := null;
445: l_trxn_attribs.Trxn_Ref_Number1 := l_payment_rec.quote_header_id;
446: IF l_payment_rec.quote_line_id = fnd_api.g_miss_num then
447: l_trxn_attribs.Trxn_Ref_Number2 := null;
448: Else
449: l_trxn_attribs.Trxn_Ref_Number2 := l_payment_rec.quote_line_id;
450: End if;

Line 460: p_init_msg_list => FND_API.G_FALSE,

456:
457: IBY_FNDCPT_SETUP_PUB.Get_Payment_Channel_Attribs
458: (
459: p_api_version => 1.0,
460: p_init_msg_list => FND_API.G_FALSE,
461: x_return_status => x_return_status,
462: x_msg_count => x_msg_count,
463: x_msg_data => x_msg_data,
464: p_channel_code => 'CREDIT_CARD',

Line 478: (l_payment_rec.cvv2 is null or l_payment_rec.cvv2 = fnd_api.g_miss_char)) then

474: aso_debug_pub.add('x_response.result_message: '|| to_char(lx_response.result_message), 1, 'Y');
475: END IF;
476:
477: IF (nvl(lx_channel_attrib_uses.Instr_SecCode_Use,'null') = 'REQUIRED' and
478: (l_payment_rec.cvv2 is null or l_payment_rec.cvv2 = fnd_api.g_miss_char)) then
479:
480: x_return_status := FND_API.G_RET_STS_ERROR;
481: FND_MESSAGE.Set_Name('ASO', 'ASO_CC_INVALID');
482: FND_MSG_PUB.ADD;

Line 480: x_return_status := FND_API.G_RET_STS_ERROR;

476:
477: IF (nvl(lx_channel_attrib_uses.Instr_SecCode_Use,'null') = 'REQUIRED' and
478: (l_payment_rec.cvv2 is null or l_payment_rec.cvv2 = fnd_api.g_miss_char)) then
479:
480: x_return_status := FND_API.G_RET_STS_ERROR;
481: FND_MESSAGE.Set_Name('ASO', 'ASO_CC_INVALID');
482: FND_MSG_PUB.ADD;
483: RAISE FND_API.G_EXC_ERROR;
484: END IF;

Line 483: RAISE FND_API.G_EXC_ERROR;

479:
480: x_return_status := FND_API.G_RET_STS_ERROR;
481: FND_MESSAGE.Set_Name('ASO', 'ASO_CC_INVALID');
482: FND_MSG_PUB.ADD;
483: RAISE FND_API.G_EXC_ERROR;
484: END IF;
485:
486:
487: if l_payment_rec.cvv2 = fnd_api.g_miss_char then

Line 487: if l_payment_rec.cvv2 = fnd_api.g_miss_char then

483: RAISE FND_API.G_EXC_ERROR;
484: END IF;
485:
486:
487: if l_payment_rec.cvv2 = fnd_api.g_miss_char then
488: l_trxn_attribs.Instrument_Security_Code := null;
489: else
490: l_trxn_attribs.Instrument_Security_Code := l_payment_rec.cvv2;
491: end if;

Line 507: p_init_msg_list => FND_API.G_FALSE,

503:
504: IBY_FNDCPT_TRXN_PUB.Create_Transaction_Extension
505: (
506: p_api_version => 1.0,
507: p_init_msg_list => FND_API.G_FALSE,
508: p_commit => FND_API.G_FALSE,
509: x_return_status => x_return_status,
510: x_msg_count => x_msg_count,
511: x_msg_data => x_msg_data,

Line 508: p_commit => FND_API.G_FALSE,

504: IBY_FNDCPT_TRXN_PUB.Create_Transaction_Extension
505: (
506: p_api_version => 1.0,
507: p_init_msg_list => FND_API.G_FALSE,
508: p_commit => FND_API.G_FALSE,
509: x_return_status => x_return_status,
510: x_msg_count => x_msg_count,
511: x_msg_data => x_msg_data,
512: p_payer => l_payer,

Line 529: if x_return_status <> fnd_api.g_ret_sts_success then

525: aso_debug_pub.add('x_response.result_category:'|| to_char(lx_response.result_category), 1, 'Y');
526: aso_debug_pub.add('x_response.result_message: '|| to_char(lx_response.result_message), 1, 'Y');
527: END IF;
528:
529: if x_return_status <> fnd_api.g_ret_sts_success then
530: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
531: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
532: FND_MESSAGE.Set_Token('API', 'IBY_FNDCPT_TRXN_PUB.Create_Transaction_Extension ', FALSE);
533: FND_MSG_PUB.ADD;

Line 535: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

531: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
532: FND_MESSAGE.Set_Token('API', 'IBY_FNDCPT_TRXN_PUB.Create_Transaction_Extension ', FALSE);
533: FND_MSG_PUB.ADD;
534: END IF;
535: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
536: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
537: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
538: RAISE FND_API.G_EXC_ERROR;
539: END IF;

Line 536: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

532: FND_MESSAGE.Set_Token('API', 'IBY_FNDCPT_TRXN_PUB.Create_Transaction_Extension ', FALSE);
533: FND_MSG_PUB.ADD;
534: END IF;
535: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
536: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
537: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
538: RAISE FND_API.G_EXC_ERROR;
539: END IF;
540: end if;

Line 537: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN

533: FND_MSG_PUB.ADD;
534: END IF;
535: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
536: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
537: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
538: RAISE FND_API.G_EXC_ERROR;
539: END IF;
540: end if;
541:

Line 538: RAISE FND_API.G_EXC_ERROR;

534: END IF;
535: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
536: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
537: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
538: RAISE FND_API.G_EXC_ERROR;
539: END IF;
540: end if;
541:
542: end if;

Line 624: WHEN FND_API.G_EXC_ERROR THEN

620: aso_debug_pub.ADD ('END create_payment_row',1,'N');
621: END IF;
622:
623: EXCEPTION
624: WHEN FND_API.G_EXC_ERROR THEN
625: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
626: P_API_NAME => L_API_NAME
627: ,P_PKG_NAME => G_PKG_NAME
628: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 634: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

630: ,X_MSG_COUNT => X_MSG_COUNT
631: ,X_MSG_DATA => X_MSG_DATA
632: ,X_RETURN_STATUS => X_RETURN_STATUS);
633:
634: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
635: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
636: P_API_NAME => L_API_NAME
637: ,P_PKG_NAME => G_PKG_NAME
638: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

Line 704: x_return_status := FND_API.G_RET_STS_SUCCESS;

700: IF aso_debug_pub.g_debug_flag = 'Y' THEN
701: aso_debug_pub.add('Begin update_payment_row ', 1, 'Y');
702: END IF;
703:
704: x_return_status := FND_API.G_RET_STS_SUCCESS;
705:
706:
707:
708: -- Start API Body

Line 711: IF ( l_payment_rec.Quote_Line_Id IS NOT NULL and l_payment_rec.Quote_Line_Id <> fnd_api.g_miss_num) then

707:
708: -- Start API Body
709: l_qte_header_rec := ASO_UTILITY_PVT.Query_Header_Row (l_payment_rec.Quote_Header_Id );
710:
711: IF ( l_payment_rec.Quote_Line_Id IS NOT NULL and l_payment_rec.Quote_Line_Id <> fnd_api.g_miss_num) then
712: l_qte_line_rec := ASO_UTILITY_PVT.Query_Qte_Line_Row ( l_payment_rec.Quote_Line_Id );
713: END IF;
714:
715: --Get the databse payment record and assign it to l_db_payment_rec

Line 716: IF ( l_payment_rec.Quote_Line_Id = fnd_api.g_miss_num) then

712: l_qte_line_rec := ASO_UTILITY_PVT.Query_Qte_Line_Row ( l_payment_rec.Quote_Line_Id );
713: END IF;
714:
715: --Get the databse payment record and assign it to l_db_payment_rec
716: IF ( l_payment_rec.Quote_Line_Id = fnd_api.g_miss_num) then
717: l_payment_rec.quote_line_id := null;
718: END IF;
719: l_payment_tbl := aso_utility_pvt.Query_Payment_Rows(l_payment_rec.quote_header_id,l_payment_rec.quote_line_id);
720: l_db_payment_rec := l_payment_tbl(1);

Line 742: p_init_msg_list => fnd_api.g_false,

738: aso_debug_pub.add('Before calling Validate_cc_info ', 1, 'Y');
739: END IF;
740: aso_validate_pvt.Validate_cc_info
741: (
742: p_init_msg_list => fnd_api.g_false,
743: p_payment_rec => l_payment_rec,
744: p_qte_header_rec => l_qte_header_rec,
745: P_Qte_Line_rec => l_qte_line_rec,
746: x_return_status => x_return_status,

Line 755: if x_return_status <> fnd_api.g_ret_sts_success then

751: aso_debug_pub.add('after calling Validate_cc_info ', 1, 'Y');
752: aso_debug_pub.add('Validate_cc_info Return Status: '||x_return_status, 1, 'Y');
753: END IF;
754:
755: if x_return_status <> fnd_api.g_ret_sts_success then
756: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
757: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
758: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
759: RAISE FND_API.G_EXC_ERROR;

Line 756: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

752: aso_debug_pub.add('Validate_cc_info Return Status: '||x_return_status, 1, 'Y');
753: END IF;
754:
755: if x_return_status <> fnd_api.g_ret_sts_success then
756: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
757: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
758: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
759: RAISE FND_API.G_EXC_ERROR;
760: ELSE

Line 757: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

753: END IF;
754:
755: if x_return_status <> fnd_api.g_ret_sts_success then
756: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
757: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
758: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
759: RAISE FND_API.G_EXC_ERROR;
760: ELSE
761: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 758: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN

754:
755: if x_return_status <> fnd_api.g_ret_sts_success then
756: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
757: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
758: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
759: RAISE FND_API.G_EXC_ERROR;
760: ELSE
761: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
762: END IF;

Line 759: RAISE FND_API.G_EXC_ERROR;

755: if x_return_status <> fnd_api.g_ret_sts_success then
756: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
757: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
758: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
759: RAISE FND_API.G_EXC_ERROR;
760: ELSE
761: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
762: END IF;
763: end if;

Line 761: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

757: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
758: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
759: RAISE FND_API.G_EXC_ERROR;
760: ELSE
761: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
762: END IF;
763: end if;
764: END IF;
765:

Line 775: If (l_payment_rec.instr_assignment_id is null or l_payment_rec.instr_assignment_id = fnd_api.g_miss_num ) then

771: If (nvl(l_db_payment_rec.payment_type_code,'NULL') <> 'CREDIT_CARD' and l_payment_rec.payment_type_code = 'CREDIT_CARD') then
772:
773: -- this is similar to the create flow
774:
775: If (l_payment_rec.instr_assignment_id is null or l_payment_rec.instr_assignment_id = fnd_api.g_miss_num ) then
776: -- this is quoting flow
777: -- call api to create credit card and assigment , if needed
778: IF aso_debug_pub.g_debug_flag = 'Y' THEN
779: aso_debug_pub.add('Before calling create_iby_payment' , 1, 'Y');

Line 782: If ( l_payment_rec.Quote_Line_Id IS NOT NULL and l_payment_rec.Quote_Line_Id <> fnd_api.g_miss_num) then

778: IF aso_debug_pub.g_debug_flag = 'Y' THEN
779: aso_debug_pub.add('Before calling create_iby_payment' , 1, 'Y');
780: END IF;
781:
782: If ( l_payment_rec.Quote_Line_Id IS NOT NULL and l_payment_rec.Quote_Line_Id <> fnd_api.g_miss_num) then
783: l_payer.party_id := l_qte_line_rec.invoice_to_cust_party_id;
784: Else
785: l_payer.party_id := l_qte_header_rec.invoice_to_cust_party_id;
786: End If;

Line 800: if x_return_status <> fnd_api.g_ret_sts_success then

796: aso_debug_pub.add('after calling create_iby_payment ', 1, 'Y');
797: aso_debug_pub.add('create_iby_payment Return Status: '||x_return_status, 1, 'Y');
798: END IF;
799:
800: if x_return_status <> fnd_api.g_ret_sts_success then
801: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
802: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
803: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
804: RAISE FND_API.G_EXC_ERROR;

Line 801: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

797: aso_debug_pub.add('create_iby_payment Return Status: '||x_return_status, 1, 'Y');
798: END IF;
799:
800: if x_return_status <> fnd_api.g_ret_sts_success then
801: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
802: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
803: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
804: RAISE FND_API.G_EXC_ERROR;
805: ELSE

Line 802: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

798: END IF;
799:
800: if x_return_status <> fnd_api.g_ret_sts_success then
801: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
802: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
803: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
804: RAISE FND_API.G_EXC_ERROR;
805: ELSE
806: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 803: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN

799:
800: if x_return_status <> fnd_api.g_ret_sts_success then
801: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
802: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
803: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
804: RAISE FND_API.G_EXC_ERROR;
805: ELSE
806: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
807: END IF;

Line 804: RAISE FND_API.G_EXC_ERROR;

800: if x_return_status <> fnd_api.g_ret_sts_success then
801: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
802: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
803: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
804: RAISE FND_API.G_EXC_ERROR;
805: ELSE
806: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
807: END IF;
808: end if;

Line 806: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

802: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
803: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
804: RAISE FND_API.G_EXC_ERROR;
805: ELSE
806: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
807: END IF;
808: end if;
809: else
810: -- this is the iStore Flow

Line 822: IF l_payment_rec.quote_line_id = fnd_api.g_miss_num then

818: l_trxn_attribs.PO_Number := null;
819: l_trxn_attribs.PO_Line_Number := null;
820: l_trxn_attribs.Trxn_Ref_Number1 := l_payment_rec.quote_header_id;
821:
822: IF l_payment_rec.quote_line_id = fnd_api.g_miss_num then
823: l_trxn_attribs.Trxn_Ref_Number2 := null;
824: Else
825: l_trxn_attribs.Trxn_Ref_Number2 := l_payment_rec.quote_line_id;
826: End if;

Line 837: p_init_msg_list => FND_API.G_FALSE,

833:
834: IBY_FNDCPT_SETUP_PUB.Get_Payment_Channel_Attribs
835: (
836: p_api_version => 1.0,
837: p_init_msg_list => FND_API.G_FALSE,
838: x_return_status => x_return_status,
839: x_msg_count => x_msg_count,
840: x_msg_data => x_msg_data,
841: p_channel_code => 'CREDIT_CARD',

Line 855: (l_payment_rec.cvv2 is null or l_payment_rec.cvv2 = fnd_api.g_miss_char)) then

851: aso_debug_pub.add('x_response.result_message: '|| to_char(lx_response.result_message), 1, 'Y');
852: END IF;
853:
854: IF (nvl(lx_channel_attrib_uses.Instr_SecCode_Use,'null') = 'REQUIRED' and
855: (l_payment_rec.cvv2 is null or l_payment_rec.cvv2 = fnd_api.g_miss_char)) then
856:
857: x_return_status := FND_API.G_RET_STS_ERROR;
858: FND_MESSAGE.Set_Name('ASO', 'ASO_CC_INVALID');
859: FND_MSG_PUB.ADD;

Line 857: x_return_status := FND_API.G_RET_STS_ERROR;

853:
854: IF (nvl(lx_channel_attrib_uses.Instr_SecCode_Use,'null') = 'REQUIRED' and
855: (l_payment_rec.cvv2 is null or l_payment_rec.cvv2 = fnd_api.g_miss_char)) then
856:
857: x_return_status := FND_API.G_RET_STS_ERROR;
858: FND_MESSAGE.Set_Name('ASO', 'ASO_CC_INVALID');
859: FND_MSG_PUB.ADD;
860: RAISE FND_API.G_EXC_ERROR;
861: END IF;

Line 860: RAISE FND_API.G_EXC_ERROR;

856:
857: x_return_status := FND_API.G_RET_STS_ERROR;
858: FND_MESSAGE.Set_Name('ASO', 'ASO_CC_INVALID');
859: FND_MSG_PUB.ADD;
860: RAISE FND_API.G_EXC_ERROR;
861: END IF;
862:
863: if l_payment_rec.cvv2 = fnd_api.g_miss_char then
864: l_trxn_attribs.Instrument_Security_Code := null;

Line 863: if l_payment_rec.cvv2 = fnd_api.g_miss_char then

859: FND_MSG_PUB.ADD;
860: RAISE FND_API.G_EXC_ERROR;
861: END IF;
862:
863: if l_payment_rec.cvv2 = fnd_api.g_miss_char then
864: l_trxn_attribs.Instrument_Security_Code := null;
865: else
866: l_trxn_attribs.Instrument_Security_Code := l_payment_rec.cvv2;
867: end if;

Line 881: IF (l_payment_rec.instr_assignment_id is not null and l_payment_rec.instr_assignment_id <> fnd_api.g_miss_num) then

877: aso_debug_pub.add('Instrument Assignment id: '|| l_payment_rec.instr_assignment_id, 1, 'Y');
878: END IF;
879:
880: --bug 5154775
881: IF (l_payment_rec.instr_assignment_id is not null and l_payment_rec.instr_assignment_id <> fnd_api.g_miss_num) then
882: IBY_FNDCPT_TRXN_PUB.Create_Transaction_Extension
883: (
884: p_api_version => 1.0,
885: p_init_msg_list => FND_API.G_FALSE,

Line 885: p_init_msg_list => FND_API.G_FALSE,

881: IF (l_payment_rec.instr_assignment_id is not null and l_payment_rec.instr_assignment_id <> fnd_api.g_miss_num) then
882: IBY_FNDCPT_TRXN_PUB.Create_Transaction_Extension
883: (
884: p_api_version => 1.0,
885: p_init_msg_list => FND_API.G_FALSE,
886: p_commit => FND_API.G_FALSE,
887: x_return_status => x_return_status,
888: x_msg_count => x_msg_count,
889: x_msg_data => x_msg_data,

Line 886: p_commit => FND_API.G_FALSE,

882: IBY_FNDCPT_TRXN_PUB.Create_Transaction_Extension
883: (
884: p_api_version => 1.0,
885: p_init_msg_list => FND_API.G_FALSE,
886: p_commit => FND_API.G_FALSE,
887: x_return_status => x_return_status,
888: x_msg_count => x_msg_count,
889: x_msg_data => x_msg_data,
890: p_payer => l_payer,

Line 907: if x_return_status <> fnd_api.g_ret_sts_success then

903: aso_debug_pub.add('x_response.result_category: '|| to_char(lx_response.result_category), 1, 'Y');
904: aso_debug_pub.add('x_response.result_message: '|| to_char(lx_response.result_message), 1, 'Y');
905: END IF;
906:
907: if x_return_status <> fnd_api.g_ret_sts_success then
908: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
909: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
910: FND_MESSAGE.Set_Token('API', 'IBY_FNDCPT_TRXN_PUB.Create_Transaction_Extension ', FALSE);
911: FND_MSG_PUB.ADD;

Line 913: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

909: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
910: FND_MESSAGE.Set_Token('API', 'IBY_FNDCPT_TRXN_PUB.Create_Transaction_Extension ', FALSE);
911: FND_MSG_PUB.ADD;
912: END IF;
913: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
914: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
915: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
916: RAISE FND_API.G_EXC_ERROR;
917: END IF;

Line 914: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

910: FND_MESSAGE.Set_Token('API', 'IBY_FNDCPT_TRXN_PUB.Create_Transaction_Extension ', FALSE);
911: FND_MSG_PUB.ADD;
912: END IF;
913: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
914: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
915: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
916: RAISE FND_API.G_EXC_ERROR;
917: END IF;
918: end if;

Line 915: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN

911: FND_MSG_PUB.ADD;
912: END IF;
913: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
914: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
915: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
916: RAISE FND_API.G_EXC_ERROR;
917: END IF;
918: end if;
919: l_payment_rec.trxn_extension_id := lx_entity_id;

Line 916: RAISE FND_API.G_EXC_ERROR;

912: END IF;
913: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
914: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
915: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
916: RAISE FND_API.G_EXC_ERROR;
917: END IF;
918: end if;
919: l_payment_rec.trxn_extension_id := lx_entity_id;
920: END IF; -- end if for the instr_assignment_id null check

Line 923: and nvl(l_payment_rec.payment_type_code,'NULL') <> FND_API.G_MISS_CHAR) then

919: l_payment_rec.trxn_extension_id := lx_entity_id;
920: END IF; -- end if for the instr_assignment_id null check
921:
922: elsif (l_db_payment_rec.payment_type_code = 'CREDIT_CARD' and nvl(l_payment_rec.payment_type_code,'NULL') <> 'CREDIT_CARD'
923: and nvl(l_payment_rec.payment_type_code,'NULL') <> FND_API.G_MISS_CHAR) then
924:
925: -- similar to delete flow, delete the trxn extension for the cc in the db
926: open c_get_payer_from_trxn(l_db_payment_rec.trxn_extension_id);
927: fetch c_get_payer_from_trxn into l_payer.party_id;

Line 936: IF (l_db_payment_rec.trxn_extension_id is not null and l_db_payment_rec.trxn_extension_id <> fnd_api.g_miss_num ) then

932: aso_debug_pub.add('l_payer.party_id: '|| l_payer.party_id, 1, 'Y');
933: aso_debug_pub.add('l_payment_rec.trxn_extension_id: '|| l_db_payment_rec.trxn_extension_id, 1, 'Y');
934: END IF;
935:
936: IF (l_db_payment_rec.trxn_extension_id is not null and l_db_payment_rec.trxn_extension_id <> fnd_api.g_miss_num ) then
937: IBY_FNDCPT_TRXN_PUB.Delete_Transaction_Extension
938: (
939: p_api_version => 1.0,
940: p_init_msg_list => FND_API.G_FALSE,

Line 940: p_init_msg_list => FND_API.G_FALSE,

936: IF (l_db_payment_rec.trxn_extension_id is not null and l_db_payment_rec.trxn_extension_id <> fnd_api.g_miss_num ) then
937: IBY_FNDCPT_TRXN_PUB.Delete_Transaction_Extension
938: (
939: p_api_version => 1.0,
940: p_init_msg_list => FND_API.G_FALSE,
941: p_commit => FND_API.G_FALSE,
942: x_return_status => x_return_status,
943: x_msg_count => x_msg_count,
944: x_msg_data => x_msg_data,

Line 941: p_commit => FND_API.G_FALSE,

937: IBY_FNDCPT_TRXN_PUB.Delete_Transaction_Extension
938: (
939: p_api_version => 1.0,
940: p_init_msg_list => FND_API.G_FALSE,
941: p_commit => FND_API.G_FALSE,
942: x_return_status => x_return_status,
943: x_msg_count => x_msg_count,
944: x_msg_data => x_msg_data,
945: p_payer => l_payer,

Line 959: if x_return_status <> fnd_api.g_ret_sts_success then

955: aso_debug_pub.add('Delete_Transaction_Extension x_response.result_category: '|| to_char(lx_response.result_category), 1, 'Y');
956: aso_debug_pub.add('Delete_Transaction_Extension x_response.result_message: '|| to_char(lx_response.result_message), 1, 'Y');
957: END IF;
958:
959: if x_return_status <> fnd_api.g_ret_sts_success then
960: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
961: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
962: FND_MESSAGE.Set_Token('API', ' IBY_FNDCPT_TRXN_PUB.Delete_Transaction_Extension', FALSE);
963: FND_MSG_PUB.ADD;

Line 965: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

961: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
962: FND_MESSAGE.Set_Token('API', ' IBY_FNDCPT_TRXN_PUB.Delete_Transaction_Extension', FALSE);
963: FND_MSG_PUB.ADD;
964: END IF;
965: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
966: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
967: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
968: RAISE FND_API.G_EXC_ERROR;
969: END IF;

Line 966: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

962: FND_MESSAGE.Set_Token('API', ' IBY_FNDCPT_TRXN_PUB.Delete_Transaction_Extension', FALSE);
963: FND_MSG_PUB.ADD;
964: END IF;
965: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
966: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
967: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
968: RAISE FND_API.G_EXC_ERROR;
969: END IF;
970: end if;

Line 967: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN

963: FND_MSG_PUB.ADD;
964: END IF;
965: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
966: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
967: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
968: RAISE FND_API.G_EXC_ERROR;
969: END IF;
970: end if;
971: end if; -- end if for the trxn ext id null check

Line 968: RAISE FND_API.G_EXC_ERROR;

964: END IF;
965: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
966: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
967: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
968: RAISE FND_API.G_EXC_ERROR;
969: END IF;
970: end if;
971: end if; -- end if for the trxn ext id null check
972: l_payment_rec.trxn_extension_id := null;

Line 975: ((l_payment_rec.payment_type_code = 'CREDIT_CARD') OR (l_payment_rec.payment_type_code = fnd_api.g_miss_char))) then

971: end if; -- end if for the trxn ext id null check
972: l_payment_rec.trxn_extension_id := null;
973:
974: elsif ( (nvl(l_db_payment_rec.payment_type_code,'NULL') = 'CREDIT_CARD') and
975: ((l_payment_rec.payment_type_code = 'CREDIT_CARD') OR (l_payment_rec.payment_type_code = fnd_api.g_miss_char))) then
976:
977:
978: if ((l_payment_rec.instr_assignment_id is null or l_payment_rec.instr_assignment_id = fnd_api.g_miss_num)
979: and (l_payment_rec.instrument_id is null or l_payment_rec.instrument_id = fnd_api.g_miss_num) )then

Line 978: if ((l_payment_rec.instr_assignment_id is null or l_payment_rec.instr_assignment_id = fnd_api.g_miss_num)

974: elsif ( (nvl(l_db_payment_rec.payment_type_code,'NULL') = 'CREDIT_CARD') and
975: ((l_payment_rec.payment_type_code = 'CREDIT_CARD') OR (l_payment_rec.payment_type_code = fnd_api.g_miss_char))) then
976:
977:
978: if ((l_payment_rec.instr_assignment_id is null or l_payment_rec.instr_assignment_id = fnd_api.g_miss_num)
979: and (l_payment_rec.instrument_id is null or l_payment_rec.instrument_id = fnd_api.g_miss_num) )then
980: -- bug 5154775
981: if (l_payment_rec.payment_ref_number is not null and l_payment_rec.payment_ref_number <> fnd_api.g_miss_char ) then
982: -- this is again similar to create flow , create card and assignment, if needed and update extension

Line 979: and (l_payment_rec.instrument_id is null or l_payment_rec.instrument_id = fnd_api.g_miss_num) )then

975: ((l_payment_rec.payment_type_code = 'CREDIT_CARD') OR (l_payment_rec.payment_type_code = fnd_api.g_miss_char))) then
976:
977:
978: if ((l_payment_rec.instr_assignment_id is null or l_payment_rec.instr_assignment_id = fnd_api.g_miss_num)
979: and (l_payment_rec.instrument_id is null or l_payment_rec.instrument_id = fnd_api.g_miss_num) )then
980: -- bug 5154775
981: if (l_payment_rec.payment_ref_number is not null and l_payment_rec.payment_ref_number <> fnd_api.g_miss_char ) then
982: -- this is again similar to create flow , create card and assignment, if needed and update extension
983: -- this is the quoting flow

Line 981: if (l_payment_rec.payment_ref_number is not null and l_payment_rec.payment_ref_number <> fnd_api.g_miss_char ) then

977:
978: if ((l_payment_rec.instr_assignment_id is null or l_payment_rec.instr_assignment_id = fnd_api.g_miss_num)
979: and (l_payment_rec.instrument_id is null or l_payment_rec.instrument_id = fnd_api.g_miss_num) )then
980: -- bug 5154775
981: if (l_payment_rec.payment_ref_number is not null and l_payment_rec.payment_ref_number <> fnd_api.g_miss_char ) then
982: -- this is again similar to create flow , create card and assignment, if needed and update extension
983: -- this is the quoting flow
984: -- call api to create credit card and assigment , if needed
985: IF aso_debug_pub.g_debug_flag = 'Y' THEN

Line 989: If ( l_payment_rec.Quote_Line_Id IS NOT NULL and l_payment_rec.Quote_Line_Id <> fnd_api.g_miss_num) then

985: IF aso_debug_pub.g_debug_flag = 'Y' THEN
986: aso_debug_pub.add('Before calling create_iby_payment' , 1, 'Y');
987: END IF;
988:
989: If ( l_payment_rec.Quote_Line_Id IS NOT NULL and l_payment_rec.Quote_Line_Id <> fnd_api.g_miss_num) then
990: l_payer.party_id := l_qte_line_rec.invoice_to_cust_party_id;
991: Else
992: l_payer.party_id := l_qte_header_rec.invoice_to_cust_party_id;
993: End If;

Line 1008: if x_return_status <> fnd_api.g_ret_sts_success then

1004: aso_debug_pub.add('after calling create_iby_payment ', 1, 'Y');
1005: aso_debug_pub.add('create_iby_payment Return Status: '||x_return_status, 1, 'Y');
1006: END IF;
1007:
1008: if x_return_status <> fnd_api.g_ret_sts_success then
1009: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1010: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1011: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1012: RAISE FND_API.G_EXC_ERROR;

Line 1009: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

1005: aso_debug_pub.add('create_iby_payment Return Status: '||x_return_status, 1, 'Y');
1006: END IF;
1007:
1008: if x_return_status <> fnd_api.g_ret_sts_success then
1009: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1010: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1011: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1012: RAISE FND_API.G_EXC_ERROR;
1013: ELSE

Line 1010: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1006: END IF;
1007:
1008: if x_return_status <> fnd_api.g_ret_sts_success then
1009: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1010: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1011: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1012: RAISE FND_API.G_EXC_ERROR;
1013: ELSE
1014: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1011: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN

1007:
1008: if x_return_status <> fnd_api.g_ret_sts_success then
1009: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1010: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1011: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1012: RAISE FND_API.G_EXC_ERROR;
1013: ELSE
1014: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1015: END IF;

Line 1012: RAISE FND_API.G_EXC_ERROR;

1008: if x_return_status <> fnd_api.g_ret_sts_success then
1009: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1010: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1011: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1012: RAISE FND_API.G_EXC_ERROR;
1013: ELSE
1014: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1015: END IF;
1016: end if;

Line 1014: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1010: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1011: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1012: RAISE FND_API.G_EXC_ERROR;
1013: ELSE
1014: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1015: END IF;
1016: end if;
1017: else
1018: -- this means the input cc is a fax cc

Line 1020: IF (l_db_payment_rec.trxn_extension_id is not null and l_db_payment_rec.trxn_extension_id <> fnd_api.g_miss_num) then

1016: end if;
1017: else
1018: -- this means the input cc is a fax cc
1019: l_shared_cart_scenario := 'Y';
1020: IF (l_db_payment_rec.trxn_extension_id is not null and l_db_payment_rec.trxn_extension_id <> fnd_api.g_miss_num) then
1021: open c_get_payer_from_trxn(l_db_payment_rec.trxn_extension_id);
1022: fetch c_get_payer_from_trxn into l_orig_party_id;
1023: close c_get_payer_from_trxn;
1024: END IF;

Line 1026: elsif ((l_payment_rec.instr_assignment_id is not null and l_payment_rec.instr_assignment_id <> fnd_api.g_miss_num)

1022: fetch c_get_payer_from_trxn into l_orig_party_id;
1023: close c_get_payer_from_trxn;
1024: END IF;
1025: end if; -- check for payment ref num
1026: elsif ((l_payment_rec.instr_assignment_id is not null and l_payment_rec.instr_assignment_id <> fnd_api.g_miss_num)
1027: and (l_payment_rec.instrument_id is not null and l_payment_rec.instrument_id <> fnd_api.g_miss_num) )then
1028:
1029: -- this means card has been updated, this is the quoting flow
1030: If ( l_payment_rec.Quote_Line_Id IS NOT NULL and l_payment_rec.Quote_Line_Id <> fnd_api.g_miss_num) then

Line 1027: and (l_payment_rec.instrument_id is not null and l_payment_rec.instrument_id <> fnd_api.g_miss_num) )then

1023: close c_get_payer_from_trxn;
1024: END IF;
1025: end if; -- check for payment ref num
1026: elsif ((l_payment_rec.instr_assignment_id is not null and l_payment_rec.instr_assignment_id <> fnd_api.g_miss_num)
1027: and (l_payment_rec.instrument_id is not null and l_payment_rec.instrument_id <> fnd_api.g_miss_num) )then
1028:
1029: -- this means card has been updated, this is the quoting flow
1030: If ( l_payment_rec.Quote_Line_Id IS NOT NULL and l_payment_rec.Quote_Line_Id <> fnd_api.g_miss_num) then
1031: l_payer.party_id := l_qte_line_rec.invoice_to_cust_party_id;

Line 1030: If ( l_payment_rec.Quote_Line_Id IS NOT NULL and l_payment_rec.Quote_Line_Id <> fnd_api.g_miss_num) then

1026: elsif ((l_payment_rec.instr_assignment_id is not null and l_payment_rec.instr_assignment_id <> fnd_api.g_miss_num)
1027: and (l_payment_rec.instrument_id is not null and l_payment_rec.instrument_id <> fnd_api.g_miss_num) )then
1028:
1029: -- this means card has been updated, this is the quoting flow
1030: If ( l_payment_rec.Quote_Line_Id IS NOT NULL and l_payment_rec.Quote_Line_Id <> fnd_api.g_miss_num) then
1031: l_payer.party_id := l_qte_line_rec.invoice_to_cust_party_id;
1032: Else
1033: l_payer.party_id := l_qte_header_rec.invoice_to_cust_party_id;
1034: End If;

Line 1039: if l_payment_rec.credit_card_expiration_date = fnd_api.g_miss_date then

1035:
1036: l_card_instrument.card_id := l_payment_rec.instrument_id;
1037:
1038: -- user can possibly change exp date and name on the card
1039: if l_payment_rec.credit_card_expiration_date = fnd_api.g_miss_date then
1040: l_card_instrument.expiration_date := null;
1041: else
1042: l_card_instrument.expiration_date := last_day(l_payment_rec.credit_card_expiration_date);
1043: end if;

Line 1045: if l_payment_rec.credit_card_holder_name = fnd_api.g_miss_char then

1041: else
1042: l_card_instrument.expiration_date := last_day(l_payment_rec.credit_card_expiration_date);
1043: end if;
1044:
1045: if l_payment_rec.credit_card_holder_name = fnd_api.g_miss_char then
1046: l_card_instrument.card_holder_name := null;
1047: else
1048: l_card_instrument.card_holder_name := l_payment_rec.credit_card_holder_name;
1049: end if;

Line 1051: if l_payment_rec.credit_card_code = fnd_api.g_miss_char then

1047: else
1048: l_card_instrument.card_holder_name := l_payment_rec.credit_card_holder_name;
1049: end if;
1050:
1051: if l_payment_rec.credit_card_code = fnd_api.g_miss_char then
1052: l_card_instrument.card_issuer := null;
1053: else
1054: l_card_instrument.card_issuer := l_payment_rec.credit_card_code;
1055: end if;

Line 1065: p_init_msg_list => FND_API.G_FALSE,

1061: END IF;
1062: IBY_FNDCPT_SETUP_PUB.Update_Card
1063: (
1064: p_api_version => 1.0,
1065: p_init_msg_list => FND_API.G_FALSE,
1066: p_commit => FND_API.G_FALSE,
1067: x_return_status => x_return_status,
1068: x_msg_count => x_msg_count,
1069: x_msg_data => x_msg_data,

Line 1066: p_commit => FND_API.G_FALSE,

1062: IBY_FNDCPT_SETUP_PUB.Update_Card
1063: (
1064: p_api_version => 1.0,
1065: p_init_msg_list => FND_API.G_FALSE,
1066: p_commit => FND_API.G_FALSE,
1067: x_return_status => x_return_status,
1068: x_msg_count => x_msg_count,
1069: x_msg_data => x_msg_data,
1070: p_card_instrument => l_card_instrument,

Line 1080: if x_return_status <> fnd_api.g_ret_sts_success then

1076: aso_debug_pub.add('x_response.result_category: '|| to_char(lx_response.result_category), 1, 'Y');
1077: aso_debug_pub.add('x_response.result_message: '|| to_char(lx_response.result_message), 1, 'Y');
1078: END IF;
1079:
1080: if x_return_status <> fnd_api.g_ret_sts_success then
1081: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1082: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
1083: FND_MESSAGE.Set_Token('API', 'IBY_FNDCPT_SETUP_PUB.Update_Card', FALSE);
1084: FND_MSG_PUB.ADD;

Line 1086: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

1082: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
1083: FND_MESSAGE.Set_Token('API', 'IBY_FNDCPT_SETUP_PUB.Update_Card', FALSE);
1084: FND_MSG_PUB.ADD;
1085: END IF;
1086: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1087: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1088: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1089: RAISE FND_API.G_EXC_ERROR;
1090: END IF;

Line 1087: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1083: FND_MESSAGE.Set_Token('API', 'IBY_FNDCPT_SETUP_PUB.Update_Card', FALSE);
1084: FND_MSG_PUB.ADD;
1085: END IF;
1086: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1087: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1088: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1089: RAISE FND_API.G_EXC_ERROR;
1090: END IF;
1091: end if;

Line 1088: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN

1084: FND_MSG_PUB.ADD;
1085: END IF;
1086: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1087: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1088: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1089: RAISE FND_API.G_EXC_ERROR;
1090: END IF;
1091: end if;
1092:

Line 1089: RAISE FND_API.G_EXC_ERROR;

1085: END IF;
1086: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1087: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1088: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1089: RAISE FND_API.G_EXC_ERROR;
1090: END IF;
1091: end if;
1092:
1093: else

Line 1099: IF (l_db_payment_rec.trxn_extension_id is not null and l_db_payment_rec.trxn_extension_id <> fnd_api.g_miss_num) then

1095: open c_get_payer_id(l_payment_rec.instr_assignment_id);
1096: fetch c_get_payer_id into l_payer.party_id;
1097: close c_get_payer_id;
1098: -- fix for bug 4767905
1099: IF (l_db_payment_rec.trxn_extension_id is not null and l_db_payment_rec.trxn_extension_id <> fnd_api.g_miss_num) then
1100: open c_get_payer_from_trxn(l_db_payment_rec.trxn_extension_id);
1101: fetch c_get_payer_from_trxn into l_orig_party_id;
1102: close c_get_payer_from_trxn;
1103:

Line 1122: If l_payment_rec.quote_line_id = fnd_api.g_miss_num then

1118: l_trxn_attribs.Order_Id := to_char(l_payment_rec.payment_id)||'-'||l_qte_header_rec.quote_number;
1119: l_trxn_attribs.PO_Number := null;
1120: l_trxn_attribs.PO_Line_Number := null;
1121: l_trxn_attribs.Trxn_Ref_Number1 := l_payment_rec.quote_header_id;
1122: If l_payment_rec.quote_line_id = fnd_api.g_miss_num then
1123: l_trxn_attribs.Trxn_Ref_Number2 := null;
1124: Else
1125: l_trxn_attribs.Trxn_Ref_Number2 := l_payment_rec.quote_line_id;
1126: End if;

Line 1137: p_init_msg_list => FND_API.G_FALSE,

1133:
1134: IBY_FNDCPT_SETUP_PUB.Get_Payment_Channel_Attribs
1135: (
1136: p_api_version => 1.0,
1137: p_init_msg_list => FND_API.G_FALSE,
1138: x_return_status => x_return_status,
1139: x_msg_count => x_msg_count,
1140: x_msg_data => x_msg_data,
1141: p_channel_code => 'CREDIT_CARD',

Line 1155: (l_payment_rec.cvv2 is null or l_payment_rec.cvv2 = fnd_api.g_miss_char)) then

1151: aso_debug_pub.add('x_response.result_message: '|| to_char(lx_response.result_message), 1, 'Y');
1152: END IF;
1153:
1154: IF (nvl(lx_channel_attrib_uses.Instr_SecCode_Use,'null') = 'REQUIRED' and
1155: (l_payment_rec.cvv2 is null or l_payment_rec.cvv2 = fnd_api.g_miss_char)) then
1156:
1157: x_return_status := FND_API.G_RET_STS_ERROR;
1158: FND_MESSAGE.Set_Name('ASO', 'ASO_CC_INVALID');
1159: FND_MSG_PUB.ADD;

Line 1157: x_return_status := FND_API.G_RET_STS_ERROR;

1153:
1154: IF (nvl(lx_channel_attrib_uses.Instr_SecCode_Use,'null') = 'REQUIRED' and
1155: (l_payment_rec.cvv2 is null or l_payment_rec.cvv2 = fnd_api.g_miss_char)) then
1156:
1157: x_return_status := FND_API.G_RET_STS_ERROR;
1158: FND_MESSAGE.Set_Name('ASO', 'ASO_CC_INVALID');
1159: FND_MSG_PUB.ADD;
1160: RAISE FND_API.G_EXC_ERROR;
1161: END IF;

Line 1160: RAISE FND_API.G_EXC_ERROR;

1156:
1157: x_return_status := FND_API.G_RET_STS_ERROR;
1158: FND_MESSAGE.Set_Name('ASO', 'ASO_CC_INVALID');
1159: FND_MSG_PUB.ADD;
1160: RAISE FND_API.G_EXC_ERROR;
1161: END IF;
1162: */
1163:
1164: if l_payment_rec.cvv2 = fnd_api.g_miss_char then

Line 1164: if l_payment_rec.cvv2 = fnd_api.g_miss_char then

1160: RAISE FND_API.G_EXC_ERROR;
1161: END IF;
1162: */
1163:
1164: if l_payment_rec.cvv2 = fnd_api.g_miss_char then
1165: l_trxn_attribs.Instrument_Security_Code := null;
1166: else
1167: l_trxn_attribs.Instrument_Security_Code := l_payment_rec.cvv2;
1168: end if;

Line 1177: IF ( (l_db_payment_rec.trxn_extension_id is not null and l_db_payment_rec.trxn_extension_id <> fnd_api.g_miss_num) and

1173: l_trxn_attribs.Additional_Info := null;
1174:
1175:
1176: --bug 5154775
1177: IF ( (l_db_payment_rec.trxn_extension_id is not null and l_db_payment_rec.trxn_extension_id <> fnd_api.g_miss_num) and
1178: (l_payment_rec.instr_assignment_id IS NOT NULL AND l_payment_rec.instr_assignment_id <> fnd_api.g_miss_num) and
1179: (l_shared_cart_scenario = 'N')) then
1180:
1181: IF aso_debug_pub.g_debug_flag = 'Y' THEN

Line 1178: (l_payment_rec.instr_assignment_id IS NOT NULL AND l_payment_rec.instr_assignment_id <> fnd_api.g_miss_num) and

1174:
1175:
1176: --bug 5154775
1177: IF ( (l_db_payment_rec.trxn_extension_id is not null and l_db_payment_rec.trxn_extension_id <> fnd_api.g_miss_num) and
1178: (l_payment_rec.instr_assignment_id IS NOT NULL AND l_payment_rec.instr_assignment_id <> fnd_api.g_miss_num) and
1179: (l_shared_cart_scenario = 'N')) then
1180:
1181: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1182: aso_debug_pub.add('Before calling IBY_FNDCPT_TRXN_PUB.Update_Transaction_Extension ', 1, 'Y');

Line 1189: p_init_msg_list => FND_API.G_FALSE,

1185:
1186: IBY_FNDCPT_TRXN_PUB.Update_Transaction_Extension
1187: (
1188: p_api_version => 1.0,
1189: p_init_msg_list => FND_API.G_FALSE,
1190: p_commit => FND_API.G_FALSE,
1191: x_return_status => x_return_status,
1192: x_msg_count => x_msg_count,
1193: x_msg_data => x_msg_data,

Line 1190: p_commit => FND_API.G_FALSE,

1186: IBY_FNDCPT_TRXN_PUB.Update_Transaction_Extension
1187: (
1188: p_api_version => 1.0,
1189: p_init_msg_list => FND_API.G_FALSE,
1190: p_commit => FND_API.G_FALSE,
1191: x_return_status => x_return_status,
1192: x_msg_count => x_msg_count,
1193: x_msg_data => x_msg_data,
1194: p_payer => l_payer,

Line 1210: IF x_return_status <> fnd_api.g_ret_sts_success then

1206: aso_debug_pub.add('x_response.result_category: '|| to_char(lx_response.result_category), 1, 'Y');
1207: aso_debug_pub.add('x_response.result_message: '|| to_char(lx_response.result_message), 1, 'Y');
1208: END IF;
1209:
1210: IF x_return_status <> fnd_api.g_ret_sts_success then
1211: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1212: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
1213: FND_MESSAGE.Set_Token('API', 'IBY_FNDCPT_TRXN_PUB.Create_Transaction_Extension ', FALSE);
1214: FND_MSG_PUB.ADD;

Line 1216: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

1212: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
1213: FND_MESSAGE.Set_Token('API', 'IBY_FNDCPT_TRXN_PUB.Create_Transaction_Extension ', FALSE);
1214: FND_MSG_PUB.ADD;
1215: END IF;
1216: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1217: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1218: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1219: RAISE FND_API.G_EXC_ERROR;
1220: END IF;

Line 1217: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1213: FND_MESSAGE.Set_Token('API', 'IBY_FNDCPT_TRXN_PUB.Create_Transaction_Extension ', FALSE);
1214: FND_MSG_PUB.ADD;
1215: END IF;
1216: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1217: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1218: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1219: RAISE FND_API.G_EXC_ERROR;
1220: END IF;
1221: END IF;

Line 1218: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN

1214: FND_MSG_PUB.ADD;
1215: END IF;
1216: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1217: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1218: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1219: RAISE FND_API.G_EXC_ERROR;
1220: END IF;
1221: END IF;
1222:

Line 1219: RAISE FND_API.G_EXC_ERROR;

1215: END IF;
1216: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1217: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1218: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1219: RAISE FND_API.G_EXC_ERROR;
1220: END IF;
1221: END IF;
1222:
1223: ELSE -- else condition for trxn id not null

Line 1227: and l_db_payment_rec.trxn_extension_id <> fnd_api.g_miss_num ) THEN

1223: ELSE -- else condition for trxn id not null
1224: -- fix for bug 4767905 and 5154775
1225: -- if cc has been created by shared user, then delete the previous extension
1226: if ( l_shared_cart_scenario = 'Y' and l_db_payment_rec.trxn_extension_id is not null
1227: and l_db_payment_rec.trxn_extension_id <> fnd_api.g_miss_num ) THEN
1228:
1229: -- set the party id to that of the orig user for deleting the trxn
1230: l_payer.party_id := l_orig_party_id;
1231: IF aso_debug_pub.g_debug_flag = 'Y' THEN

Line 1240: p_init_msg_list => FND_API.G_FALSE,

1236:
1237: IBY_FNDCPT_TRXN_PUB.Delete_Transaction_Extension
1238: (
1239: p_api_version => 1.0,
1240: p_init_msg_list => FND_API.G_FALSE,
1241: p_commit => FND_API.G_FALSE,
1242: x_return_status => x_return_status,
1243: x_msg_count => x_msg_count,
1244: x_msg_data => x_msg_data,

Line 1241: p_commit => FND_API.G_FALSE,

1237: IBY_FNDCPT_TRXN_PUB.Delete_Transaction_Extension
1238: (
1239: p_api_version => 1.0,
1240: p_init_msg_list => FND_API.G_FALSE,
1241: p_commit => FND_API.G_FALSE,
1242: x_return_status => x_return_status,
1243: x_msg_count => x_msg_count,
1244: x_msg_data => x_msg_data,
1245: p_payer => l_payer,

Line 1259: if x_return_status <> fnd_api.g_ret_sts_success then

1255: aso_debug_pub.add('Delete_Transaction_Extension x_response.result_category: '|| to_char(lx_response.result_category), 1, 'Y');
1256: aso_debug_pub.add('Delete_Transaction_Extension x_response.result_message: '|| to_char(lx_response.result_message), 1, 'Y');
1257: END IF;
1258:
1259: if x_return_status <> fnd_api.g_ret_sts_success then
1260: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1261: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
1262: FND_MESSAGE.Set_Token('API', ' IBY_FNDCPT_TRXN_PUB.Delete_Transaction_Extension', FALSE);
1263: FND_MSG_PUB.ADD;

Line 1265: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

1261: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
1262: FND_MESSAGE.Set_Token('API', ' IBY_FNDCPT_TRXN_PUB.Delete_Transaction_Extension', FALSE);
1263: FND_MSG_PUB.ADD;
1264: END IF;
1265: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1266: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1267: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1268: RAISE FND_API.G_EXC_ERROR;
1269: END IF;

Line 1266: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1262: FND_MESSAGE.Set_Token('API', ' IBY_FNDCPT_TRXN_PUB.Delete_Transaction_Extension', FALSE);
1263: FND_MSG_PUB.ADD;
1264: END IF;
1265: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1266: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1267: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1268: RAISE FND_API.G_EXC_ERROR;
1269: END IF;
1270: end if;

Line 1267: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN

1263: FND_MSG_PUB.ADD;
1264: END IF;
1265: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1266: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1267: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1268: RAISE FND_API.G_EXC_ERROR;
1269: END IF;
1270: end if;
1271: -- reset the party id to that of the shared user

Line 1268: RAISE FND_API.G_EXC_ERROR;

1264: END IF;
1265: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1266: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1267: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1268: RAISE FND_API.G_EXC_ERROR;
1269: END IF;
1270: end if;
1271: -- reset the party id to that of the shared user
1272: open c_get_payer_id(l_payment_rec.instr_assignment_id);

Line 1297: p_init_msg_list => FND_API.G_FALSE,

1293:
1294: IBY_FNDCPT_SETUP_PUB.Get_Payment_Channel_Attribs
1295: (
1296: p_api_version => 1.0,
1297: p_init_msg_list => FND_API.G_FALSE,
1298: x_return_status => x_return_status,
1299: x_msg_count => x_msg_count,
1300: x_msg_data => x_msg_data,
1301: p_channel_code => 'CREDIT_CARD',

Line 1315: (l_payment_rec.cvv2 is null or l_payment_rec.cvv2 = fnd_api.g_miss_char)) then

1311: aso_debug_pub.add('x_response.result_message: '|| to_char(lx_response.result_message), 1, 'Y');
1312: END IF;
1313:
1314: IF (nvl(lx_channel_attrib_uses.Instr_SecCode_Use,'null') = 'REQUIRED' and
1315: (l_payment_rec.cvv2 is null or l_payment_rec.cvv2 = fnd_api.g_miss_char)) then
1316:
1317: x_return_status := FND_API.G_RET_STS_ERROR;
1318: FND_MESSAGE.Set_Name('ASO', 'ASO_CC_INVALID');
1319: FND_MSG_PUB.ADD;

Line 1317: x_return_status := FND_API.G_RET_STS_ERROR;

1313:
1314: IF (nvl(lx_channel_attrib_uses.Instr_SecCode_Use,'null') = 'REQUIRED' and
1315: (l_payment_rec.cvv2 is null or l_payment_rec.cvv2 = fnd_api.g_miss_char)) then
1316:
1317: x_return_status := FND_API.G_RET_STS_ERROR;
1318: FND_MESSAGE.Set_Name('ASO', 'ASO_CC_INVALID');
1319: FND_MSG_PUB.ADD;
1320: RAISE FND_API.G_EXC_ERROR;
1321: END IF;

Line 1320: RAISE FND_API.G_EXC_ERROR;

1316:
1317: x_return_status := FND_API.G_RET_STS_ERROR;
1318: FND_MESSAGE.Set_Name('ASO', 'ASO_CC_INVALID');
1319: FND_MSG_PUB.ADD;
1320: RAISE FND_API.G_EXC_ERROR;
1321: END IF;
1322:
1323: if (l_payment_rec.instr_assignment_id is not null and l_payment_rec.instr_assignment_id <> fnd_api.g_miss_num) then
1324: IBY_FNDCPT_TRXN_PUB.Create_Transaction_Extension

Line 1323: if (l_payment_rec.instr_assignment_id is not null and l_payment_rec.instr_assignment_id <> fnd_api.g_miss_num) then

1319: FND_MSG_PUB.ADD;
1320: RAISE FND_API.G_EXC_ERROR;
1321: END IF;
1322:
1323: if (l_payment_rec.instr_assignment_id is not null and l_payment_rec.instr_assignment_id <> fnd_api.g_miss_num) then
1324: IBY_FNDCPT_TRXN_PUB.Create_Transaction_Extension
1325: (
1326: p_api_version => 1.0,
1327: p_init_msg_list => FND_API.G_FALSE,

Line 1327: p_init_msg_list => FND_API.G_FALSE,

1323: if (l_payment_rec.instr_assignment_id is not null and l_payment_rec.instr_assignment_id <> fnd_api.g_miss_num) then
1324: IBY_FNDCPT_TRXN_PUB.Create_Transaction_Extension
1325: (
1326: p_api_version => 1.0,
1327: p_init_msg_list => FND_API.G_FALSE,
1328: p_commit => FND_API.G_FALSE,
1329: x_return_status => x_return_status,
1330: x_msg_count => x_msg_count,
1331: x_msg_data => x_msg_data,

Line 1328: p_commit => FND_API.G_FALSE,

1324: IBY_FNDCPT_TRXN_PUB.Create_Transaction_Extension
1325: (
1326: p_api_version => 1.0,
1327: p_init_msg_list => FND_API.G_FALSE,
1328: p_commit => FND_API.G_FALSE,
1329: x_return_status => x_return_status,
1330: x_msg_count => x_msg_count,
1331: x_msg_data => x_msg_data,
1332: p_payer => l_payer,

Line 1349: if x_return_status <> fnd_api.g_ret_sts_success then

1345: aso_debug_pub.add('x_response.result_category:'|| to_char(lx_response.result_category), 1, 'Y');
1346: aso_debug_pub.add('x_response.result_message: '|| to_char(lx_response.result_message), 1, 'Y');
1347: END IF;
1348:
1349: if x_return_status <> fnd_api.g_ret_sts_success then
1350: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1351: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
1352: FND_MESSAGE.Set_Token('API', 'IBY_FNDCPT_TRXN_PUB.Create_Transaction_Extension ', FALSE);
1353: FND_MSG_PUB.ADD;

Line 1355: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

1351: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
1352: FND_MESSAGE.Set_Token('API', 'IBY_FNDCPT_TRXN_PUB.Create_Transaction_Extension ', FALSE);
1353: FND_MSG_PUB.ADD;
1354: END IF;
1355: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1356: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1357: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1358: RAISE FND_API.G_EXC_ERROR;
1359: END IF;

Line 1356: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1352: FND_MESSAGE.Set_Token('API', 'IBY_FNDCPT_TRXN_PUB.Create_Transaction_Extension ', FALSE);
1353: FND_MSG_PUB.ADD;
1354: END IF;
1355: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1356: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1357: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1358: RAISE FND_API.G_EXC_ERROR;
1359: END IF;
1360: end if;

Line 1357: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN

1353: FND_MSG_PUB.ADD;
1354: END IF;
1355: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1356: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1357: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1358: RAISE FND_API.G_EXC_ERROR;
1359: END IF;
1360: end if;
1361: l_payment_rec.trxn_extension_id := lx_entity_id;

Line 1358: RAISE FND_API.G_EXC_ERROR;

1354: END IF;
1355: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1356: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1357: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1358: RAISE FND_API.G_EXC_ERROR;
1359: END IF;
1360: end if;
1361: l_payment_rec.trxn_extension_id := lx_entity_id;
1362: end if; -- end if for the instr_assignment_id check

Line 1369: ( l_db_payment_rec.payment_type_code = 'CREDIT_CARD' and l_payment_rec.PAYMENT_TYPE_CODE = fnd_api.g_miss_char)) then

1365: end if;
1366:
1367:
1368: IF ((l_payment_rec.PAYMENT_TYPE_CODE = 'CREDIT_CARD') or
1369: ( l_db_payment_rec.payment_type_code = 'CREDIT_CARD' and l_payment_rec.PAYMENT_TYPE_CODE = fnd_api.g_miss_char)) then
1370: l_payment_ref_number := null;
1371: else
1372: l_payment_ref_number := l_payment_rec.PAYMENT_REF_NUMBER;
1373: END IF;

Line 1438: /*IF FND_API.to_Boolean( p_commit )

1434: -- End API Body
1435:
1436:
1437: -- Standard check for p_commit
1438: /*IF FND_API.to_Boolean( p_commit )
1439: THEN
1440: COMMIT WORK;
1441: END IF; */
1442:

Line 1454: WHEN FND_API.G_EXC_ERROR THEN

1450: aso_debug_pub.ADD ('END update_payment_row',1,'N');
1451: END IF;
1452:
1453: EXCEPTION
1454: WHEN FND_API.G_EXC_ERROR THEN
1455: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1456: P_API_NAME => L_API_NAME
1457: ,P_PKG_NAME => G_PKG_NAME
1458: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 1464: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1460: ,X_MSG_COUNT => X_MSG_COUNT
1461: ,X_MSG_DATA => X_MSG_DATA
1462: ,X_RETURN_STATUS => X_RETURN_STATUS);
1463:
1464: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1465: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1466: P_API_NAME => L_API_NAME
1467: ,P_PKG_NAME => G_PKG_NAME
1468: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

Line 1516: x_return_status := FND_API.G_RET_STS_SUCCESS;

1512: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1513: aso_debug_pub.add('Begin delete_payment_row ', 1, 'Y');
1514: END IF;
1515:
1516: x_return_status := FND_API.G_RET_STS_SUCCESS;
1517:
1518: l_qte_header_rec := ASO_UTILITY_PVT.Query_Header_Row (l_payment_rec.Quote_Header_Id );
1519:
1520: IF ( l_payment_rec.Quote_Line_Id IS NOT NULL and l_payment_rec.Quote_Line_Id <> fnd_api.g_miss_num) then

Line 1520: IF ( l_payment_rec.Quote_Line_Id IS NOT NULL and l_payment_rec.Quote_Line_Id <> fnd_api.g_miss_num) then

1516: x_return_status := FND_API.G_RET_STS_SUCCESS;
1517:
1518: l_qte_header_rec := ASO_UTILITY_PVT.Query_Header_Row (l_payment_rec.Quote_Header_Id );
1519:
1520: IF ( l_payment_rec.Quote_Line_Id IS NOT NULL and l_payment_rec.Quote_Line_Id <> fnd_api.g_miss_num) then
1521: l_qte_line_rec := ASO_UTILITY_PVT.Query_Qte_Line_Row ( l_payment_rec.Quote_Line_Id );
1522: END IF;
1523:
1524: --Get the databse payment record and assign it to l_payment_rec

Line 1525: IF ( l_payment_rec.Quote_Line_Id = fnd_api.g_miss_num) then

1521: l_qte_line_rec := ASO_UTILITY_PVT.Query_Qte_Line_Row ( l_payment_rec.Quote_Line_Id );
1522: END IF;
1523:
1524: --Get the databse payment record and assign it to l_payment_rec
1525: IF ( l_payment_rec.Quote_Line_Id = fnd_api.g_miss_num) then
1526: l_payment_rec.quote_line_id := null;
1527: END IF;
1528:
1529: l_payment_tbl := aso_utility_pvt.Query_Payment_Rows(l_payment_rec.quote_header_id,l_payment_rec.quote_line_id);

Line 1556: p_init_msg_list => FND_API.G_FALSE,

1552:
1553: IBY_FNDCPT_TRXN_PUB.Delete_Transaction_Extension
1554: (
1555: p_api_version => 1.0,
1556: p_init_msg_list => FND_API.G_FALSE,
1557: p_commit => FND_API.G_FALSE,
1558: x_return_status => x_return_status,
1559: x_msg_count => x_msg_count,
1560: x_msg_data => x_msg_data,

Line 1557: p_commit => FND_API.G_FALSE,

1553: IBY_FNDCPT_TRXN_PUB.Delete_Transaction_Extension
1554: (
1555: p_api_version => 1.0,
1556: p_init_msg_list => FND_API.G_FALSE,
1557: p_commit => FND_API.G_FALSE,
1558: x_return_status => x_return_status,
1559: x_msg_count => x_msg_count,
1560: x_msg_data => x_msg_data,
1561: p_payer => l_payer,

Line 1575: if x_return_status <> fnd_api.g_ret_sts_success then

1571: aso_debug_pub.add('Delete_Transaction_Extension x_response.result_category: '|| to_char(lx_response.result_category), 1, 'Y');
1572: aso_debug_pub.add('Delete_Transaction_Extension x_response.result_message: '|| to_char(lx_response.result_message), 1, 'Y');
1573: END IF;
1574:
1575: if x_return_status <> fnd_api.g_ret_sts_success then
1576: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1577: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
1578: FND_MESSAGE.Set_Token('API', ' IBY_FNDCPT_TRXN_PUB.Delete_Transaction_Extension', FALSE);
1579: FND_MSG_PUB.ADD;

Line 1581: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

1577: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
1578: FND_MESSAGE.Set_Token('API', ' IBY_FNDCPT_TRXN_PUB.Delete_Transaction_Extension', FALSE);
1579: FND_MSG_PUB.ADD;
1580: END IF;
1581: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1582: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1583: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1584: RAISE FND_API.G_EXC_ERROR;
1585: END IF;

Line 1582: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1578: FND_MESSAGE.Set_Token('API', ' IBY_FNDCPT_TRXN_PUB.Delete_Transaction_Extension', FALSE);
1579: FND_MSG_PUB.ADD;
1580: END IF;
1581: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1582: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1583: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1584: RAISE FND_API.G_EXC_ERROR;
1585: END IF;
1586: end if;

Line 1583: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN

1579: FND_MSG_PUB.ADD;
1580: END IF;
1581: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1582: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1583: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1584: RAISE FND_API.G_EXC_ERROR;
1585: END IF;
1586: end if;
1587: end if;

Line 1584: RAISE FND_API.G_EXC_ERROR;

1580: END IF;
1581: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1582: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1583: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1584: RAISE FND_API.G_EXC_ERROR;
1585: END IF;
1586: end if;
1587: end if;
1588:

Line 1592: /*IF FND_API.to_Boolean( p_commit )

1588:
1589: ASO_PAYMENTS_PKG.Delete_Row(p_PAYMENT_ID => p_payment_rec.PAYMENT_ID);
1590:
1591: -- Standard check for p_commit
1592: /*IF FND_API.to_Boolean( p_commit )
1593: THEN
1594: COMMIT WORK;
1595: END IF; */
1596:

Line 1608: WHEN FND_API.G_EXC_ERROR THEN

1604: aso_debug_pub.ADD ('END delete_payment_row',1,'N');
1605: END IF;
1606:
1607: EXCEPTION
1608: WHEN FND_API.G_EXC_ERROR THEN
1609: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1610: P_API_NAME => L_API_NAME
1611: ,P_PKG_NAME => G_PKG_NAME
1612: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 1618: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1614: ,X_MSG_COUNT => X_MSG_COUNT
1615: ,X_MSG_DATA => X_MSG_DATA
1616: ,X_RETURN_STATUS => X_RETURN_STATUS);
1617:
1618: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1619: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1620: P_API_NAME => L_API_NAME
1621: ,P_PKG_NAME => G_PKG_NAME
1622: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR