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 169: p_init_msg_list => FND_API.G_FALSE,

165:
166: IBY_FNDCPT_SETUP_PUB.Process_Credit_Card
167: (
168: p_api_version => 1.0,
169: p_init_msg_list => FND_API.G_FALSE,
170: p_commit => FND_API.G_FALSE,
171: x_return_status => x_return_status,
172: x_msg_count => x_msg_count,
173: x_msg_data => x_msg_data,

Line 170: p_commit => FND_API.G_FALSE,

166: IBY_FNDCPT_SETUP_PUB.Process_Credit_Card
167: (
168: p_api_version => 1.0,
169: p_init_msg_list => FND_API.G_FALSE,
170: p_commit => FND_API.G_FALSE,
171: x_return_status => x_return_status,
172: x_msg_count => x_msg_count,
173: x_msg_data => x_msg_data,
174: p_payer => p_payer,

Line 189: if x_return_status <> fnd_api.g_ret_sts_success then

185: aso_debug_pub.add('IBY Process_Credit_Card x_response.result_message: '|| to_char(lx_response.result_message), 1, 'Y');
186: aso_debug_pub.add('IBY Process_Credit_Card x_assign_id: '|| to_char(lx_assign_id), 1, 'Y');
187: END IF;
188:
189: if x_return_status <> fnd_api.g_ret_sts_success then
190: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
191: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
192: FND_MESSAGE.Set_Token('API', 'IBY_FNDCPT_SETUP_PUB.Process_Credit_Card ', FALSE);
193: FND_MSG_PUB.ADD;

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

191: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
192: FND_MESSAGE.Set_Token('API', 'IBY_FNDCPT_SETUP_PUB.Process_Credit_Card ', FALSE);
193: FND_MSG_PUB.ADD;
194: END IF;
195: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
196: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
197: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
198: RAISE FND_API.G_EXC_ERROR;
199: END IF;

Line 196: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

192: FND_MESSAGE.Set_Token('API', 'IBY_FNDCPT_SETUP_PUB.Process_Credit_Card ', FALSE);
193: FND_MSG_PUB.ADD;
194: END IF;
195: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
196: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
197: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
198: RAISE FND_API.G_EXC_ERROR;
199: END IF;
200: end if;

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

193: FND_MSG_PUB.ADD;
194: END IF;
195: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
196: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
197: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
198: RAISE FND_API.G_EXC_ERROR;
199: END IF;
200: end if;
201:

Line 198: RAISE FND_API.G_EXC_ERROR;

194: END IF;
195: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
196: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
197: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
198: RAISE FND_API.G_EXC_ERROR;
199: END IF;
200: end if;
201:
202: x_payment_rec.instr_assignment_id := lx_assign_id;

Line 212: WHEN FND_API.G_EXC_ERROR THEN

208: aso_debug_pub.ADD ('END create_iby_payment',1,'N');
209: END IF;
210:
211: EXCEPTION
212: WHEN FND_API.G_EXC_ERROR THEN
213: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
214: P_API_NAME => L_API_NAME
215: ,P_PKG_NAME => G_PKG_NAME
216: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 222: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

218: ,X_MSG_COUNT => X_MSG_COUNT
219: ,X_MSG_DATA => X_MSG_DATA
220: ,X_RETURN_STATUS => X_RETURN_STATUS);
221:
222: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
223: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
224: P_API_NAME => L_API_NAME
225: ,P_PKG_NAME => G_PKG_NAME
226: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

Line 297: x_return_status := FND_API.G_RET_STS_SUCCESS;

293: IF aso_debug_pub.g_debug_flag = 'Y' THEN
294: aso_debug_pub.add('Begin create_payment_row ', 1, 'Y');
295: END IF;
296:
297: x_return_status := FND_API.G_RET_STS_SUCCESS;
298:
299: IF aso_debug_pub.g_debug_flag = 'Y' THEN
300: aso_debug_pub.add('l_payment_rec.Quote_Header_Id: '||l_payment_rec.Quote_Header_Id, 1, 'Y');
301: aso_debug_pub.add('l_payment_rec.Quote_Line_Id: '||l_payment_rec.Quote_Line_Id, 1, 'Y');

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

303: aso_debug_pub.add('l_payment_rec.instr_assignment_id: '||l_payment_rec.instr_assignment_id, 1, 'Y');
304: END IF;
305:
306: -- Check for duplicate payments see bug 5118000
307: IF ( l_payment_rec.Quote_Line_Id IS NOT NULL and l_payment_rec.Quote_Line_Id <> fnd_api.g_miss_num) then
308: IF aso_debug_pub.g_debug_flag = 'Y' THEN
309: aso_debug_pub.add('Checking for duplicate payment records at line level', 1, 'Y');
310: END IF;
311: open c_get_db_line_payment(l_payment_rec.Quote_Header_Id,l_payment_rec.Quote_Line_Id);

Line 314: x_return_status := FND_API.G_RET_STS_ERROR;

310: END IF;
311: open c_get_db_line_payment(l_payment_rec.Quote_Header_Id,l_payment_rec.Quote_Line_Id);
312: fetch c_get_db_line_payment into l_existing_payment_id;
313: if c_get_db_line_payment%FOUND THEN
314: x_return_status := FND_API.G_RET_STS_ERROR;
315: close c_get_db_line_payment;
316: FND_MESSAGE.Set_Name('ASO', 'ASO_API_MULTIPLE_PAYMENTS');
317: FND_MSG_PUB.ADD;
318: RAISE FND_API.G_EXC_ERROR;

Line 318: RAISE FND_API.G_EXC_ERROR;

314: x_return_status := FND_API.G_RET_STS_ERROR;
315: close c_get_db_line_payment;
316: FND_MESSAGE.Set_Name('ASO', 'ASO_API_MULTIPLE_PAYMENTS');
317: FND_MSG_PUB.ADD;
318: RAISE FND_API.G_EXC_ERROR;
319: end if;
320: close c_get_db_line_payment;
321: ELSE
322: IF aso_debug_pub.g_debug_flag = 'Y' THEN

Line 328: x_return_status := FND_API.G_RET_STS_ERROR;

324: END IF;
325: open c_get_db_hdr_payment(l_payment_rec.Quote_Header_Id);
326: fetch c_get_db_hdr_payment into l_existing_payment_id;
327: if c_get_db_hdr_payment%FOUND THEN
328: x_return_status := FND_API.G_RET_STS_ERROR;
329: close c_get_db_hdr_payment;
330: FND_MESSAGE.Set_Name('ASO', 'ASO_API_MULTIPLE_PAYMENTS');
331: FND_MSG_PUB.ADD;
332: RAISE FND_API.G_EXC_ERROR;

Line 332: RAISE FND_API.G_EXC_ERROR;

328: x_return_status := FND_API.G_RET_STS_ERROR;
329: close c_get_db_hdr_payment;
330: FND_MESSAGE.Set_Name('ASO', 'ASO_API_MULTIPLE_PAYMENTS');
331: FND_MSG_PUB.ADD;
332: RAISE FND_API.G_EXC_ERROR;
333: end if;
334: close c_get_db_hdr_payment;
335: END IF;
336:

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

341: aso_debug_pub.add('After querying the header row', 1, 'Y');
342: aso_debug_pub.add('l_qte_header_rec.quote_header_id: ' || l_qte_header_rec.quote_header_id, 1, 'Y');
343: END IF;
344:
345: IF ( l_payment_rec.Quote_Line_Id IS NOT NULL and l_payment_rec.Quote_Line_Id <> fnd_api.g_miss_num) then
346: l_qte_line_rec := ASO_UTILITY_PVT.Query_Qte_Line_Row ( l_payment_rec.Quote_Line_Id );
347: END IF;
348:
349: IF aso_debug_pub.g_debug_flag = 'Y' THEN

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

350: aso_debug_pub.add('After querying the line row', 1, 'Y');
351: END IF;
352:
353: if ( l_payment_rec.payment_type_code = 'CREDIT_CARD' and
354: ((l_payment_rec.payment_ref_number is not null and l_payment_rec.payment_ref_number <> fnd_api.g_miss_char) or
355: (l_payment_rec.instr_assignment_id is not null and l_payment_rec.instr_assignment_id <> fnd_api.g_miss_num)) ) then
356:
357: IF aso_debug_pub.g_debug_flag = 'Y' THEN
358: aso_debug_pub.add('Inside if for payment type credit card', 1, 'Y');

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

351: END IF;
352:
353: if ( l_payment_rec.payment_type_code = 'CREDIT_CARD' and
354: ((l_payment_rec.payment_ref_number is not null and l_payment_rec.payment_ref_number <> fnd_api.g_miss_char) or
355: (l_payment_rec.instr_assignment_id is not null and l_payment_rec.instr_assignment_id <> fnd_api.g_miss_num)) ) then
356:
357: IF aso_debug_pub.g_debug_flag = 'Y' THEN
358: aso_debug_pub.add('Inside if for payment type credit card', 1, 'Y');
359: END IF;

Line 367: p_init_msg_list => fnd_api.g_false,

363: aso_debug_pub.add('Before calling Validate_cc_info ', 1, 'Y');
364: END IF;
365: aso_validate_pvt.Validate_cc_info
366: (
367: p_init_msg_list => fnd_api.g_false,
368: p_payment_rec => l_payment_rec,
369: p_qte_header_rec => l_qte_header_rec,
370: P_Qte_Line_rec => l_qte_line_rec,
371: x_return_status => x_return_status,

Line 380: if x_return_status <> fnd_api.g_ret_sts_success then

376: aso_debug_pub.add('after calling Validate_cc_info ', 1, 'Y');
377: aso_debug_pub.add('Validate_cc_info Return Status: '||x_return_status, 1, 'Y');
378: END IF;
379:
380: if x_return_status <> fnd_api.g_ret_sts_success then
381: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
382: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
383: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
384: RAISE FND_API.G_EXC_ERROR;

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

377: aso_debug_pub.add('Validate_cc_info Return Status: '||x_return_status, 1, 'Y');
378: END IF;
379:
380: if x_return_status <> fnd_api.g_ret_sts_success then
381: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
382: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
383: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
384: RAISE FND_API.G_EXC_ERROR;
385: ELSE

Line 382: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

378: END IF;
379:
380: if x_return_status <> fnd_api.g_ret_sts_success then
381: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
382: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
383: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
384: RAISE FND_API.G_EXC_ERROR;
385: ELSE
386: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

379:
380: if x_return_status <> fnd_api.g_ret_sts_success then
381: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
382: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
383: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
384: RAISE FND_API.G_EXC_ERROR;
385: ELSE
386: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
387: END IF;

Line 384: RAISE FND_API.G_EXC_ERROR;

380: if x_return_status <> fnd_api.g_ret_sts_success then
381: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
382: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
383: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
384: RAISE FND_API.G_EXC_ERROR;
385: ELSE
386: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
387: END IF;
388: end if;

Line 386: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

382: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
383: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
384: RAISE FND_API.G_EXC_ERROR;
385: ELSE
386: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
387: END IF;
388: end if;
389:
390: l_payer.cust_account_id := null;

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

390: l_payer.cust_account_id := null;
391: l_payer.account_site_id := null;
392: l_payer.payment_function := 'CUSTOMER_PAYMENT';
393:
394: if (p_payment_rec.instr_assignment_id is null or p_payment_rec.instr_assignment_id = fnd_api.g_miss_num) then
395: -- this is the Quoting flow
396:
397: If ( l_payment_rec.Quote_Line_Id IS NOT NULL and l_payment_rec.Quote_Line_Id <> fnd_api.g_miss_num) then
398: l_payer.party_id := l_qte_line_rec.invoice_to_cust_party_id;

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

393:
394: if (p_payment_rec.instr_assignment_id is null or p_payment_rec.instr_assignment_id = fnd_api.g_miss_num) then
395: -- this is the Quoting flow
396:
397: If ( l_payment_rec.Quote_Line_Id IS NOT NULL and l_payment_rec.Quote_Line_Id <> fnd_api.g_miss_num) then
398: l_payer.party_id := l_qte_line_rec.invoice_to_cust_party_id;
399: Else
400: l_payer.party_id := l_qte_header_rec.invoice_to_cust_party_id;
401: End If;

Line 420: if x_return_status <> fnd_api.g_ret_sts_success then

416: aso_debug_pub.add('after calling create_iby_payment ', 1, 'Y');
417: aso_debug_pub.add('create_iby_payment Return Status: '||x_return_status, 1, 'Y');
418: END IF;
419:
420: if x_return_status <> fnd_api.g_ret_sts_success then
421: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
422: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
423: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
424: RAISE FND_API.G_EXC_ERROR;

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

417: aso_debug_pub.add('create_iby_payment Return Status: '||x_return_status, 1, 'Y');
418: END IF;
419:
420: if x_return_status <> fnd_api.g_ret_sts_success then
421: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
422: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
423: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
424: RAISE FND_API.G_EXC_ERROR;
425: ELSE

Line 422: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

418: END IF;
419:
420: if x_return_status <> fnd_api.g_ret_sts_success then
421: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
422: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
423: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
424: RAISE FND_API.G_EXC_ERROR;
425: ELSE
426: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

419:
420: if x_return_status <> fnd_api.g_ret_sts_success then
421: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
422: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
423: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
424: RAISE FND_API.G_EXC_ERROR;
425: ELSE
426: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
427: END IF;

Line 424: RAISE FND_API.G_EXC_ERROR;

420: if x_return_status <> fnd_api.g_ret_sts_success then
421: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
422: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
423: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
424: RAISE FND_API.G_EXC_ERROR;
425: ELSE
426: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
427: END IF;
428: end if;

Line 426: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

422: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
423: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
424: RAISE FND_API.G_EXC_ERROR;
425: ELSE
426: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
427: END IF;
428: end if;
429: else
430: -- this is the iStore Flow

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

439: end if;
440:
441: -- generate the payment id if it is not passed, this is possible
442: -- when quote is being created first time and payment rec is created at same time
443: if (l_payment_rec.payment_id is null or l_payment_rec.payment_id = fnd_api.g_miss_num) then
444: open c_get_payment_id;
445: fetch c_get_payment_id into l_payment_rec.payment_id;
446: close c_get_payment_id;
447: end if;

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

450: l_trxn_attribs.Order_Id := to_char(l_payment_rec.payment_id)||'-'||l_qte_header_rec.quote_number;
451: l_trxn_attribs.PO_Number := null;
452: l_trxn_attribs.PO_Line_Number := null;
453: l_trxn_attribs.Trxn_Ref_Number1 := l_payment_rec.quote_header_id;
454: IF l_payment_rec.quote_line_id = fnd_api.g_miss_num then
455: l_trxn_attribs.Trxn_Ref_Number2 := null;
456: Else
457: l_trxn_attribs.Trxn_Ref_Number2 := l_payment_rec.quote_line_id;
458: End if;

Line 468: p_init_msg_list => FND_API.G_FALSE,

464:
465: IBY_FNDCPT_SETUP_PUB.Get_Payment_Channel_Attribs
466: (
467: p_api_version => 1.0,
468: p_init_msg_list => FND_API.G_FALSE,
469: x_return_status => x_return_status,
470: x_msg_count => x_msg_count,
471: x_msg_data => x_msg_data,
472: p_channel_code => 'CREDIT_CARD',

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

482: aso_debug_pub.add('x_response.result_message: '|| to_char(lx_response.result_message), 1, 'Y');
483: END IF;
484:
485: IF (nvl(lx_channel_attrib_uses.Instr_SecCode_Use,'null') = 'REQUIRED' and
486: (l_payment_rec.cvv2 is null or l_payment_rec.cvv2 = fnd_api.g_miss_char)) then
487:
488: x_return_status := FND_API.G_RET_STS_ERROR;
489: FND_MESSAGE.Set_Name('ASO', 'ASO_CC_INVALID');
490: FND_MSG_PUB.ADD;

Line 488: x_return_status := FND_API.G_RET_STS_ERROR;

484:
485: IF (nvl(lx_channel_attrib_uses.Instr_SecCode_Use,'null') = 'REQUIRED' and
486: (l_payment_rec.cvv2 is null or l_payment_rec.cvv2 = fnd_api.g_miss_char)) then
487:
488: x_return_status := FND_API.G_RET_STS_ERROR;
489: FND_MESSAGE.Set_Name('ASO', 'ASO_CC_INVALID');
490: FND_MSG_PUB.ADD;
491: RAISE FND_API.G_EXC_ERROR;
492: END IF;

Line 491: RAISE FND_API.G_EXC_ERROR;

487:
488: x_return_status := FND_API.G_RET_STS_ERROR;
489: FND_MESSAGE.Set_Name('ASO', 'ASO_CC_INVALID');
490: FND_MSG_PUB.ADD;
491: RAISE FND_API.G_EXC_ERROR;
492: END IF;
493:
494:
495: if l_payment_rec.cvv2 = fnd_api.g_miss_char then

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

491: RAISE FND_API.G_EXC_ERROR;
492: END IF;
493:
494:
495: if l_payment_rec.cvv2 = fnd_api.g_miss_char then
496: l_trxn_attribs.Instrument_Security_Code := null;
497: else
498: l_trxn_attribs.Instrument_Security_Code := l_payment_rec.cvv2;
499: end if;

Line 515: p_init_msg_list => FND_API.G_FALSE,

511:
512: IBY_FNDCPT_TRXN_PUB.Create_Transaction_Extension
513: (
514: p_api_version => 1.0,
515: p_init_msg_list => FND_API.G_FALSE,
516: p_commit => FND_API.G_FALSE,
517: x_return_status => x_return_status,
518: x_msg_count => x_msg_count,
519: x_msg_data => x_msg_data,

Line 516: p_commit => FND_API.G_FALSE,

512: IBY_FNDCPT_TRXN_PUB.Create_Transaction_Extension
513: (
514: p_api_version => 1.0,
515: p_init_msg_list => FND_API.G_FALSE,
516: p_commit => FND_API.G_FALSE,
517: x_return_status => x_return_status,
518: x_msg_count => x_msg_count,
519: x_msg_data => x_msg_data,
520: p_payer => l_payer,

Line 537: if x_return_status <> fnd_api.g_ret_sts_success then

533: aso_debug_pub.add('x_response.result_category:'|| to_char(lx_response.result_category), 1, 'Y');
534: aso_debug_pub.add('x_response.result_message: '|| to_char(lx_response.result_message), 1, 'Y');
535: END IF;
536:
537: if x_return_status <> fnd_api.g_ret_sts_success then
538: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
539: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
540: FND_MESSAGE.Set_Token('API', 'IBY_FNDCPT_TRXN_PUB.Create_Transaction_Extension ', FALSE);
541: FND_MSG_PUB.ADD;

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

539: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
540: FND_MESSAGE.Set_Token('API', 'IBY_FNDCPT_TRXN_PUB.Create_Transaction_Extension ', FALSE);
541: FND_MSG_PUB.ADD;
542: END IF;
543: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
544: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
545: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
546: RAISE FND_API.G_EXC_ERROR;
547: END IF;

Line 544: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

540: FND_MESSAGE.Set_Token('API', 'IBY_FNDCPT_TRXN_PUB.Create_Transaction_Extension ', FALSE);
541: FND_MSG_PUB.ADD;
542: END IF;
543: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
544: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
545: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
546: RAISE FND_API.G_EXC_ERROR;
547: END IF;
548: end if;

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

541: FND_MSG_PUB.ADD;
542: END IF;
543: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
544: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
545: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
546: RAISE FND_API.G_EXC_ERROR;
547: END IF;
548: end if;
549:

Line 546: RAISE FND_API.G_EXC_ERROR;

542: END IF;
543: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
544: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
545: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
546: RAISE FND_API.G_EXC_ERROR;
547: END IF;
548: end if;
549:
550: end if;

Line 632: WHEN FND_API.G_EXC_ERROR THEN

628: aso_debug_pub.ADD ('END create_payment_row',1,'N');
629: END IF;
630:
631: EXCEPTION
632: WHEN FND_API.G_EXC_ERROR THEN
633: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
634: P_API_NAME => L_API_NAME
635: ,P_PKG_NAME => G_PKG_NAME
636: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 642: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

638: ,X_MSG_COUNT => X_MSG_COUNT
639: ,X_MSG_DATA => X_MSG_DATA
640: ,X_RETURN_STATUS => X_RETURN_STATUS);
641:
642: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
643: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
644: P_API_NAME => L_API_NAME
645: ,P_PKG_NAME => G_PKG_NAME
646: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

Line 753: x_return_status := FND_API.G_RET_STS_SUCCESS;

749: IF aso_debug_pub.g_debug_flag = 'Y' THEN
750: aso_debug_pub.add('Begin update_payment_row ', 1, 'Y');
751: END IF;
752:
753: x_return_status := FND_API.G_RET_STS_SUCCESS;
754:
755:
756:
757: -- Start API Body

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

756:
757: -- Start API Body
758: l_qte_header_rec := ASO_UTILITY_PVT.Query_Header_Row (l_payment_rec.Quote_Header_Id );
759:
760: IF ( l_payment_rec.Quote_Line_Id IS NOT NULL and l_payment_rec.Quote_Line_Id <> fnd_api.g_miss_num) then
761: l_qte_line_rec := ASO_UTILITY_PVT.Query_Qte_Line_Row ( l_payment_rec.Quote_Line_Id );
762: END IF;
763:
764: --Get the databse payment record and assign it to l_db_payment_rec

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

761: l_qte_line_rec := ASO_UTILITY_PVT.Query_Qte_Line_Row ( l_payment_rec.Quote_Line_Id );
762: END IF;
763:
764: --Get the databse payment record and assign it to l_db_payment_rec
765: IF ( l_payment_rec.Quote_Line_Id = fnd_api.g_miss_num) then
766: l_payment_rec.quote_line_id := null;
767: END IF;
768: l_payment_tbl := aso_utility_pvt.Query_Payment_Rows(l_payment_rec.quote_header_id,l_payment_rec.quote_line_id);
769: l_db_payment_rec := l_payment_tbl(1);

Line 774: (l_payment_rec.payment_type_code Is Null Or l_payment_rec.payment_type_code = fnd_api.g_miss_char) Then

770:
771: /*** Start : Code Added for Bug 8712439 for HTML Quoting PA-DSS update issue ***/
772:
773: If (nvl(l_db_payment_rec.payment_type_code,'NULL') = 'CREDIT_CARD') And
774: (l_payment_rec.payment_type_code Is Null Or l_payment_rec.payment_type_code = fnd_api.g_miss_char) Then
775:
776: IF aso_debug_pub.g_debug_flag = 'Y' THEN
777: aso_debug_pub.add('Database payment_type_code is CREDIT_CARD ', 1, 'Y');
778: aso_debug_pub.add('Input payment_type_code is NULL ',1, 'Y');

Line 781: If (l_payment_rec.PAYMENT_REF_NUMBER is Not Null or l_payment_rec.PAYMENT_REF_NUMBER <> fnd_api.g_miss_num) Then

777: aso_debug_pub.add('Database payment_type_code is CREDIT_CARD ', 1, 'Y');
778: aso_debug_pub.add('Input payment_type_code is NULL ',1, 'Y');
779: End if;
780:
781: If (l_payment_rec.PAYMENT_REF_NUMBER is Not Null or l_payment_rec.PAYMENT_REF_NUMBER <> fnd_api.g_miss_num) Then
782:
783: l_payment_rec.payment_type_code := 'CREDIT_CARD';
784: lc_payment_rec.payment_type_code := 'CREDIT_CARD';
785:

Line 824: p_init_msg_list => fnd_api.g_false,

820: aso_debug_pub.add('Before calling Validate_cc_info ', 1, 'Y');
821: END IF;
822: aso_validate_pvt.Validate_cc_info
823: (
824: p_init_msg_list => fnd_api.g_false,
825: p_payment_rec => l_payment_rec,
826: p_qte_header_rec => l_qte_header_rec,
827: P_Qte_Line_rec => l_qte_line_rec,
828: x_return_status => x_return_status,

Line 837: if x_return_status <> fnd_api.g_ret_sts_success then

833: aso_debug_pub.add('after calling Validate_cc_info ', 1, 'Y');
834: aso_debug_pub.add('Validate_cc_info Return Status: '||x_return_status, 1, 'Y');
835: END IF;
836:
837: if x_return_status <> fnd_api.g_ret_sts_success then
838: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
839: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
840: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
841: RAISE FND_API.G_EXC_ERROR;

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

834: aso_debug_pub.add('Validate_cc_info Return Status: '||x_return_status, 1, 'Y');
835: END IF;
836:
837: if x_return_status <> fnd_api.g_ret_sts_success then
838: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
839: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
840: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
841: RAISE FND_API.G_EXC_ERROR;
842: ELSE

Line 839: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

835: END IF;
836:
837: if x_return_status <> fnd_api.g_ret_sts_success then
838: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
839: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
840: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
841: RAISE FND_API.G_EXC_ERROR;
842: ELSE
843: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

836:
837: if x_return_status <> fnd_api.g_ret_sts_success then
838: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
839: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
840: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
841: RAISE FND_API.G_EXC_ERROR;
842: ELSE
843: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
844: END IF;

Line 841: RAISE FND_API.G_EXC_ERROR;

837: if x_return_status <> fnd_api.g_ret_sts_success then
838: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
839: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
840: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
841: RAISE FND_API.G_EXC_ERROR;
842: ELSE
843: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
844: END IF;
845: end if;

Line 843: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

839: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
840: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
841: RAISE FND_API.G_EXC_ERROR;
842: ELSE
843: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
844: END IF;
845: end if;
846: END IF;
847:

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

853: If (nvl(l_db_payment_rec.payment_type_code,'NULL') <> 'CREDIT_CARD' and l_payment_rec.payment_type_code = 'CREDIT_CARD') then
854:
855: -- this is similar to the create flow
856:
857: If (l_payment_rec.instr_assignment_id is null or l_payment_rec.instr_assignment_id = fnd_api.g_miss_num ) then
858: -- this is quoting flow
859: -- call api to create credit card and assigment , if needed
860: IF aso_debug_pub.g_debug_flag = 'Y' THEN
861: aso_debug_pub.add('Before calling create_iby_payment' , 1, 'Y');

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

860: IF aso_debug_pub.g_debug_flag = 'Y' THEN
861: aso_debug_pub.add('Before calling create_iby_payment' , 1, 'Y');
862: END IF;
863:
864: If ( l_payment_rec.Quote_Line_Id IS NOT NULL and l_payment_rec.Quote_Line_Id <> fnd_api.g_miss_num) then
865: l_payer.party_id := l_qte_line_rec.invoice_to_cust_party_id;
866: Else
867: l_payer.party_id := l_qte_header_rec.invoice_to_cust_party_id;
868: End If;

Line 882: if x_return_status <> fnd_api.g_ret_sts_success then

878: aso_debug_pub.add('after calling create_iby_payment ', 1, 'Y');
879: aso_debug_pub.add('create_iby_payment Return Status: '||x_return_status, 1, 'Y');
880: END IF;
881:
882: if x_return_status <> fnd_api.g_ret_sts_success then
883: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
884: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
885: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
886: RAISE FND_API.G_EXC_ERROR;

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

879: aso_debug_pub.add('create_iby_payment Return Status: '||x_return_status, 1, 'Y');
880: END IF;
881:
882: if x_return_status <> fnd_api.g_ret_sts_success then
883: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
884: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
885: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
886: RAISE FND_API.G_EXC_ERROR;
887: ELSE

Line 884: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

880: END IF;
881:
882: if x_return_status <> fnd_api.g_ret_sts_success then
883: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
884: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
885: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
886: RAISE FND_API.G_EXC_ERROR;
887: ELSE
888: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

881:
882: if x_return_status <> fnd_api.g_ret_sts_success then
883: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
884: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
885: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
886: RAISE FND_API.G_EXC_ERROR;
887: ELSE
888: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
889: END IF;

Line 886: RAISE FND_API.G_EXC_ERROR;

882: if x_return_status <> fnd_api.g_ret_sts_success then
883: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
884: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
885: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
886: RAISE FND_API.G_EXC_ERROR;
887: ELSE
888: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
889: END IF;
890: end if;

Line 888: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

884: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
885: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
886: RAISE FND_API.G_EXC_ERROR;
887: ELSE
888: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
889: END IF;
890: end if;
891: else
892: -- this is the iStore Flow

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

900: l_trxn_attribs.PO_Number := null;
901: l_trxn_attribs.PO_Line_Number := null;
902: l_trxn_attribs.Trxn_Ref_Number1 := l_payment_rec.quote_header_id;
903:
904: IF l_payment_rec.quote_line_id = fnd_api.g_miss_num then
905: l_trxn_attribs.Trxn_Ref_Number2 := null;
906: Else
907: l_trxn_attribs.Trxn_Ref_Number2 := l_payment_rec.quote_line_id;
908: End if;

Line 919: p_init_msg_list => FND_API.G_FALSE,

915:
916: IBY_FNDCPT_SETUP_PUB.Get_Payment_Channel_Attribs
917: (
918: p_api_version => 1.0,
919: p_init_msg_list => FND_API.G_FALSE,
920: x_return_status => x_return_status,
921: x_msg_count => x_msg_count,
922: x_msg_data => x_msg_data,
923: p_channel_code => 'CREDIT_CARD',

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

933: aso_debug_pub.add('x_response.result_message: '|| to_char(lx_response.result_message), 1, 'Y');
934: END IF;
935:
936: IF (nvl(lx_channel_attrib_uses.Instr_SecCode_Use,'null') = 'REQUIRED' and
937: (l_payment_rec.cvv2 is null or l_payment_rec.cvv2 = fnd_api.g_miss_char)) then
938:
939: x_return_status := FND_API.G_RET_STS_ERROR;
940: FND_MESSAGE.Set_Name('ASO', 'ASO_CC_INVALID');
941: FND_MSG_PUB.ADD;

Line 939: x_return_status := FND_API.G_RET_STS_ERROR;

935:
936: IF (nvl(lx_channel_attrib_uses.Instr_SecCode_Use,'null') = 'REQUIRED' and
937: (l_payment_rec.cvv2 is null or l_payment_rec.cvv2 = fnd_api.g_miss_char)) then
938:
939: x_return_status := FND_API.G_RET_STS_ERROR;
940: FND_MESSAGE.Set_Name('ASO', 'ASO_CC_INVALID');
941: FND_MSG_PUB.ADD;
942: RAISE FND_API.G_EXC_ERROR;
943: END IF;

Line 942: RAISE FND_API.G_EXC_ERROR;

938:
939: x_return_status := FND_API.G_RET_STS_ERROR;
940: FND_MESSAGE.Set_Name('ASO', 'ASO_CC_INVALID');
941: FND_MSG_PUB.ADD;
942: RAISE FND_API.G_EXC_ERROR;
943: END IF;
944:
945: if l_payment_rec.cvv2 = fnd_api.g_miss_char then
946: l_trxn_attribs.Instrument_Security_Code := null;

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

941: FND_MSG_PUB.ADD;
942: RAISE FND_API.G_EXC_ERROR;
943: END IF;
944:
945: if l_payment_rec.cvv2 = fnd_api.g_miss_char then
946: l_trxn_attribs.Instrument_Security_Code := null;
947: else
948: l_trxn_attribs.Instrument_Security_Code := l_payment_rec.cvv2;
949: end if;

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

959: aso_debug_pub.add('Instrument Assignment id: '|| l_payment_rec.instr_assignment_id, 1, 'Y');
960: END IF;
961:
962: --bug 5154775
963: IF (l_payment_rec.instr_assignment_id is not null and l_payment_rec.instr_assignment_id <> fnd_api.g_miss_num) then
964: IBY_FNDCPT_TRXN_PUB.Create_Transaction_Extension
965: (
966: p_api_version => 1.0,
967: p_init_msg_list => FND_API.G_FALSE,

Line 967: p_init_msg_list => FND_API.G_FALSE,

963: IF (l_payment_rec.instr_assignment_id is not null and l_payment_rec.instr_assignment_id <> fnd_api.g_miss_num) then
964: IBY_FNDCPT_TRXN_PUB.Create_Transaction_Extension
965: (
966: p_api_version => 1.0,
967: p_init_msg_list => FND_API.G_FALSE,
968: p_commit => FND_API.G_FALSE,
969: x_return_status => x_return_status,
970: x_msg_count => x_msg_count,
971: x_msg_data => x_msg_data,

Line 968: p_commit => FND_API.G_FALSE,

964: IBY_FNDCPT_TRXN_PUB.Create_Transaction_Extension
965: (
966: p_api_version => 1.0,
967: p_init_msg_list => FND_API.G_FALSE,
968: p_commit => FND_API.G_FALSE,
969: x_return_status => x_return_status,
970: x_msg_count => x_msg_count,
971: x_msg_data => x_msg_data,
972: p_payer => l_payer,

Line 989: if x_return_status <> fnd_api.g_ret_sts_success then

985: aso_debug_pub.add('x_response.result_category: '|| to_char(lx_response.result_category), 1, 'Y');
986: aso_debug_pub.add('x_response.result_message: '|| to_char(lx_response.result_message), 1, 'Y');
987: END IF;
988:
989: if x_return_status <> fnd_api.g_ret_sts_success then
990: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
991: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
992: FND_MESSAGE.Set_Token('API', 'IBY_FNDCPT_TRXN_PUB.Create_Transaction_Extension ', FALSE);
993: FND_MSG_PUB.ADD;

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

991: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
992: FND_MESSAGE.Set_Token('API', 'IBY_FNDCPT_TRXN_PUB.Create_Transaction_Extension ', FALSE);
993: FND_MSG_PUB.ADD;
994: END IF;
995: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
996: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
997: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
998: RAISE FND_API.G_EXC_ERROR;
999: END IF;

Line 996: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

992: FND_MESSAGE.Set_Token('API', 'IBY_FNDCPT_TRXN_PUB.Create_Transaction_Extension ', FALSE);
993: FND_MSG_PUB.ADD;
994: END IF;
995: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
996: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
997: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
998: RAISE FND_API.G_EXC_ERROR;
999: END IF;
1000: end if;

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

993: FND_MSG_PUB.ADD;
994: END IF;
995: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
996: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
997: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
998: RAISE FND_API.G_EXC_ERROR;
999: END IF;
1000: end if;
1001: l_payment_rec.trxn_extension_id := lx_entity_id;

Line 998: RAISE FND_API.G_EXC_ERROR;

994: END IF;
995: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
996: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
997: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
998: RAISE FND_API.G_EXC_ERROR;
999: END IF;
1000: end if;
1001: l_payment_rec.trxn_extension_id := lx_entity_id;
1002: END IF; -- end if for the instr_assignment_id null check

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

1001: l_payment_rec.trxn_extension_id := lx_entity_id;
1002: END IF; -- end if for the instr_assignment_id null check
1003:
1004: elsif (l_db_payment_rec.payment_type_code = 'CREDIT_CARD' and nvl(l_payment_rec.payment_type_code,'NULL') <> 'CREDIT_CARD'
1005: and nvl(l_payment_rec.payment_type_code,'NULL') <> FND_API.G_MISS_CHAR) then
1006:
1007: -- similar to delete flow, delete the trxn extension for the cc in the db
1008: open c_get_payer_from_trxn(l_db_payment_rec.trxn_extension_id);
1009: fetch c_get_payer_from_trxn into l_payer.party_id;

Line 1018: 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

1014: aso_debug_pub.add('l_payer.party_id: '|| l_payer.party_id, 1, 'Y');
1015: aso_debug_pub.add('l_payment_rec.trxn_extension_id: '|| l_db_payment_rec.trxn_extension_id, 1, 'Y');
1016: END IF;
1017:
1018: 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
1019: IBY_FNDCPT_TRXN_PUB.Delete_Transaction_Extension
1020: (
1021: p_api_version => 1.0,
1022: p_init_msg_list => FND_API.G_FALSE,

Line 1022: p_init_msg_list => FND_API.G_FALSE,

1018: 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
1019: IBY_FNDCPT_TRXN_PUB.Delete_Transaction_Extension
1020: (
1021: p_api_version => 1.0,
1022: p_init_msg_list => FND_API.G_FALSE,
1023: p_commit => FND_API.G_FALSE,
1024: x_return_status => x_return_status,
1025: x_msg_count => x_msg_count,
1026: x_msg_data => x_msg_data,

Line 1023: p_commit => FND_API.G_FALSE,

1019: IBY_FNDCPT_TRXN_PUB.Delete_Transaction_Extension
1020: (
1021: p_api_version => 1.0,
1022: p_init_msg_list => FND_API.G_FALSE,
1023: p_commit => FND_API.G_FALSE,
1024: x_return_status => x_return_status,
1025: x_msg_count => x_msg_count,
1026: x_msg_data => x_msg_data,
1027: p_payer => l_payer,

Line 1041: if x_return_status <> fnd_api.g_ret_sts_success then

1037: aso_debug_pub.add('Delete_Transaction_Extension x_response.result_category: '|| to_char(lx_response.result_category), 1, 'Y');
1038: aso_debug_pub.add('Delete_Transaction_Extension x_response.result_message: '|| to_char(lx_response.result_message), 1, 'Y');
1039: END IF;
1040:
1041: if x_return_status <> fnd_api.g_ret_sts_success then
1042: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1043: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
1044: FND_MESSAGE.Set_Token('API', ' IBY_FNDCPT_TRXN_PUB.Delete_Transaction_Extension', FALSE);
1045: FND_MSG_PUB.ADD;

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

1043: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
1044: FND_MESSAGE.Set_Token('API', ' IBY_FNDCPT_TRXN_PUB.Delete_Transaction_Extension', FALSE);
1045: FND_MSG_PUB.ADD;
1046: END IF;
1047: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1048: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1049: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1050: RAISE FND_API.G_EXC_ERROR;
1051: END IF;

Line 1048: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1044: FND_MESSAGE.Set_Token('API', ' IBY_FNDCPT_TRXN_PUB.Delete_Transaction_Extension', FALSE);
1045: FND_MSG_PUB.ADD;
1046: END IF;
1047: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1048: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1049: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1050: RAISE FND_API.G_EXC_ERROR;
1051: END IF;
1052: end if;

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

1045: FND_MSG_PUB.ADD;
1046: END IF;
1047: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1048: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1049: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1050: RAISE FND_API.G_EXC_ERROR;
1051: END IF;
1052: end if;
1053: end if; -- end if for the trxn ext id null check

Line 1050: RAISE FND_API.G_EXC_ERROR;

1046: END IF;
1047: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1048: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1049: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1050: RAISE FND_API.G_EXC_ERROR;
1051: END IF;
1052: end if;
1053: end if; -- end if for the trxn ext id null check
1054: l_payment_rec.trxn_extension_id := null;

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

1053: end if; -- end if for the trxn ext id null check
1054: l_payment_rec.trxn_extension_id := null;
1055:
1056: elsif ( (nvl(l_db_payment_rec.payment_type_code,'NULL') = 'CREDIT_CARD') and
1057: ((l_payment_rec.payment_type_code = 'CREDIT_CARD') OR (l_payment_rec.payment_type_code = fnd_api.g_miss_char))) then
1058:
1059:
1060: if ((l_payment_rec.instr_assignment_id is null or l_payment_rec.instr_assignment_id = fnd_api.g_miss_num)
1061: and (l_payment_rec.instrument_id is null or l_payment_rec.instrument_id = fnd_api.g_miss_num) )then

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

1056: elsif ( (nvl(l_db_payment_rec.payment_type_code,'NULL') = 'CREDIT_CARD') and
1057: ((l_payment_rec.payment_type_code = 'CREDIT_CARD') OR (l_payment_rec.payment_type_code = fnd_api.g_miss_char))) then
1058:
1059:
1060: if ((l_payment_rec.instr_assignment_id is null or l_payment_rec.instr_assignment_id = fnd_api.g_miss_num)
1061: and (l_payment_rec.instrument_id is null or l_payment_rec.instrument_id = fnd_api.g_miss_num) )then
1062: -- bug 5154775
1063: if (l_payment_rec.payment_ref_number is not null and l_payment_rec.payment_ref_number <> fnd_api.g_miss_char ) then
1064: -- this is again similar to create flow , create card and assignment, if needed and update extension

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

1057: ((l_payment_rec.payment_type_code = 'CREDIT_CARD') OR (l_payment_rec.payment_type_code = fnd_api.g_miss_char))) then
1058:
1059:
1060: if ((l_payment_rec.instr_assignment_id is null or l_payment_rec.instr_assignment_id = fnd_api.g_miss_num)
1061: and (l_payment_rec.instrument_id is null or l_payment_rec.instrument_id = fnd_api.g_miss_num) )then
1062: -- bug 5154775
1063: if (l_payment_rec.payment_ref_number is not null and l_payment_rec.payment_ref_number <> fnd_api.g_miss_char ) then
1064: -- this is again similar to create flow , create card and assignment, if needed and update extension
1065: -- this is the quoting flow

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

1059:
1060: if ((l_payment_rec.instr_assignment_id is null or l_payment_rec.instr_assignment_id = fnd_api.g_miss_num)
1061: and (l_payment_rec.instrument_id is null or l_payment_rec.instrument_id = fnd_api.g_miss_num) )then
1062: -- bug 5154775
1063: if (l_payment_rec.payment_ref_number is not null and l_payment_rec.payment_ref_number <> fnd_api.g_miss_char ) then
1064: -- this is again similar to create flow , create card and assignment, if needed and update extension
1065: -- this is the quoting flow
1066: -- call api to create credit card and assigment , if needed
1067: IF aso_debug_pub.g_debug_flag = 'Y' THEN

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

1067: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1068: aso_debug_pub.add('Before calling create_iby_payment' , 1, 'Y');
1069: END IF;
1070:
1071: If ( l_payment_rec.Quote_Line_Id IS NOT NULL and l_payment_rec.Quote_Line_Id <> fnd_api.g_miss_num) then
1072: l_payer.party_id := l_qte_line_rec.invoice_to_cust_party_id;
1073: Else
1074: l_payer.party_id := l_qte_header_rec.invoice_to_cust_party_id;
1075: End If;

Line 1092: if x_return_status <> fnd_api.g_ret_sts_success then

1088: aso_debug_pub.add('after calling create_iby_payment ', 1, 'Y');
1089: aso_debug_pub.add('create_iby_payment Return Status: '||x_return_status, 1, 'Y');
1090: END IF;
1091:
1092: if x_return_status <> fnd_api.g_ret_sts_success then
1093: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1094: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1095: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1096: RAISE FND_API.G_EXC_ERROR;

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

1089: aso_debug_pub.add('create_iby_payment Return Status: '||x_return_status, 1, 'Y');
1090: END IF;
1091:
1092: if x_return_status <> fnd_api.g_ret_sts_success then
1093: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1094: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1095: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1096: RAISE FND_API.G_EXC_ERROR;
1097: ELSE

Line 1094: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1090: END IF;
1091:
1092: if x_return_status <> fnd_api.g_ret_sts_success then
1093: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1094: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1095: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1096: RAISE FND_API.G_EXC_ERROR;
1097: ELSE
1098: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

1091:
1092: if x_return_status <> fnd_api.g_ret_sts_success then
1093: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1094: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1095: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1096: RAISE FND_API.G_EXC_ERROR;
1097: ELSE
1098: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1099: END IF;

Line 1096: RAISE FND_API.G_EXC_ERROR;

1092: if x_return_status <> fnd_api.g_ret_sts_success then
1093: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1094: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1095: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1096: RAISE FND_API.G_EXC_ERROR;
1097: ELSE
1098: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1099: END IF;
1100: end if;

Line 1098: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1094: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1095: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1096: RAISE FND_API.G_EXC_ERROR;
1097: ELSE
1098: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1099: END IF;
1100: end if;
1101: else
1102: -- this means the input cc is a fax cc

Line 1104: 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: end if;
1101: else
1102: -- this means the input cc is a fax cc
1103: l_shared_cart_scenario := 'Y';
1104: 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
1105: open c_get_payer_from_trxn(l_db_payment_rec.trxn_extension_id);
1106: fetch c_get_payer_from_trxn into l_orig_party_id;
1107: close c_get_payer_from_trxn;
1108: END IF;

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

1106: fetch c_get_payer_from_trxn into l_orig_party_id;
1107: close c_get_payer_from_trxn;
1108: END IF;
1109: end if; -- check for payment ref num
1110: elsif ((l_payment_rec.instr_assignment_id is not null and l_payment_rec.instr_assignment_id <> fnd_api.g_miss_num)
1111: and (l_payment_rec.instrument_id is not null and l_payment_rec.instrument_id <> fnd_api.g_miss_num) )then
1112:
1113: -- this means card has been updated, this is the quoting flow
1114: If ( l_payment_rec.Quote_Line_Id IS NOT NULL and l_payment_rec.Quote_Line_Id <> fnd_api.g_miss_num) then

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

1107: close c_get_payer_from_trxn;
1108: END IF;
1109: end if; -- check for payment ref num
1110: elsif ((l_payment_rec.instr_assignment_id is not null and l_payment_rec.instr_assignment_id <> fnd_api.g_miss_num)
1111: and (l_payment_rec.instrument_id is not null and l_payment_rec.instrument_id <> fnd_api.g_miss_num) )then
1112:
1113: -- this means card has been updated, this is the quoting flow
1114: If ( l_payment_rec.Quote_Line_Id IS NOT NULL and l_payment_rec.Quote_Line_Id <> fnd_api.g_miss_num) then
1115: l_payer.party_id := l_qte_line_rec.invoice_to_cust_party_id;

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

1110: elsif ((l_payment_rec.instr_assignment_id is not null and l_payment_rec.instr_assignment_id <> fnd_api.g_miss_num)
1111: and (l_payment_rec.instrument_id is not null and l_payment_rec.instrument_id <> fnd_api.g_miss_num) )then
1112:
1113: -- this means card has been updated, this is the quoting flow
1114: If ( l_payment_rec.Quote_Line_Id IS NOT NULL and l_payment_rec.Quote_Line_Id <> fnd_api.g_miss_num) then
1115: l_payer.party_id := l_qte_line_rec.invoice_to_cust_party_id;
1116: Else
1117: l_payer.party_id := l_qte_header_rec.invoice_to_cust_party_id;
1118: End If;

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

1119:
1120: l_card_instrument.card_id := l_payment_rec.instrument_id;
1121:
1122: -- user can possibly change exp date and name on the card
1123: if l_payment_rec.credit_card_expiration_date = fnd_api.g_miss_date then
1124: l_card_instrument.expiration_date := null;
1125: else
1126: l_card_instrument.expiration_date := last_day(l_payment_rec.credit_card_expiration_date);
1127: end if;

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

1125: else
1126: l_card_instrument.expiration_date := last_day(l_payment_rec.credit_card_expiration_date);
1127: end if;
1128:
1129: if l_payment_rec.credit_card_holder_name = fnd_api.g_miss_char then
1130: l_card_instrument.card_holder_name := null;
1131: else
1132: l_card_instrument.card_holder_name := l_payment_rec.credit_card_holder_name;
1133: end if;

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

1131: else
1132: l_card_instrument.card_holder_name := l_payment_rec.credit_card_holder_name;
1133: end if;
1134:
1135: if l_payment_rec.credit_card_code = fnd_api.g_miss_char then
1136: l_card_instrument.card_issuer := null;
1137: else
1138: l_card_instrument.card_issuer := l_payment_rec.credit_card_code;
1139: end if;

Line 1149: p_init_msg_list => FND_API.G_FALSE,

1145: END IF;
1146: IBY_FNDCPT_SETUP_PUB.Update_Card
1147: (
1148: p_api_version => 1.0,
1149: p_init_msg_list => FND_API.G_FALSE,
1150: p_commit => FND_API.G_FALSE,
1151: x_return_status => x_return_status,
1152: x_msg_count => x_msg_count,
1153: x_msg_data => x_msg_data,

Line 1150: p_commit => FND_API.G_FALSE,

1146: IBY_FNDCPT_SETUP_PUB.Update_Card
1147: (
1148: p_api_version => 1.0,
1149: p_init_msg_list => FND_API.G_FALSE,
1150: p_commit => FND_API.G_FALSE,
1151: x_return_status => x_return_status,
1152: x_msg_count => x_msg_count,
1153: x_msg_data => x_msg_data,
1154: p_card_instrument => l_card_instrument,

Line 1164: if x_return_status <> fnd_api.g_ret_sts_success then

1160: aso_debug_pub.add('x_response.result_category: '|| to_char(lx_response.result_category), 1, 'Y');
1161: aso_debug_pub.add('x_response.result_message: '|| to_char(lx_response.result_message), 1, 'Y');
1162: END IF;
1163:
1164: if x_return_status <> fnd_api.g_ret_sts_success then
1165: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1166: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
1167: FND_MESSAGE.Set_Token('API', 'IBY_FNDCPT_SETUP_PUB.Update_Card', FALSE);
1168: FND_MSG_PUB.ADD;

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

1166: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
1167: FND_MESSAGE.Set_Token('API', 'IBY_FNDCPT_SETUP_PUB.Update_Card', FALSE);
1168: FND_MSG_PUB.ADD;
1169: END IF;
1170: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1171: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1172: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1173: RAISE FND_API.G_EXC_ERROR;
1174: END IF;

Line 1171: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1167: FND_MESSAGE.Set_Token('API', 'IBY_FNDCPT_SETUP_PUB.Update_Card', FALSE);
1168: FND_MSG_PUB.ADD;
1169: END IF;
1170: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1171: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1172: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1173: RAISE FND_API.G_EXC_ERROR;
1174: END IF;
1175: end if;

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

1168: FND_MSG_PUB.ADD;
1169: END IF;
1170: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1171: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1172: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1173: RAISE FND_API.G_EXC_ERROR;
1174: END IF;
1175: end if;
1176:

Line 1173: RAISE FND_API.G_EXC_ERROR;

1169: END IF;
1170: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1171: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1172: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1173: RAISE FND_API.G_EXC_ERROR;
1174: END IF;
1175: end if;
1176:
1177: else

Line 1183: 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

1179: open c_get_payer_id(l_payment_rec.instr_assignment_id);
1180: fetch c_get_payer_id into l_payer.party_id;
1181: close c_get_payer_id;
1182: -- fix for bug 4767905
1183: 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
1184: open c_get_payer_from_trxn(l_db_payment_rec.trxn_extension_id);
1185: fetch c_get_payer_from_trxn into l_orig_party_id;
1186: close c_get_payer_from_trxn;
1187:

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

1202: l_trxn_attribs.Order_Id := to_char(l_payment_rec.payment_id)||'-'||l_qte_header_rec.quote_number;
1203: l_trxn_attribs.PO_Number := null;
1204: l_trxn_attribs.PO_Line_Number := null;
1205: l_trxn_attribs.Trxn_Ref_Number1 := l_payment_rec.quote_header_id;
1206: If l_payment_rec.quote_line_id = fnd_api.g_miss_num then
1207: l_trxn_attribs.Trxn_Ref_Number2 := null;
1208: Else
1209: l_trxn_attribs.Trxn_Ref_Number2 := l_payment_rec.quote_line_id;
1210: End if;

Line 1221: p_init_msg_list => FND_API.G_FALSE,

1217:
1218: IBY_FNDCPT_SETUP_PUB.Get_Payment_Channel_Attribs
1219: (
1220: p_api_version => 1.0,
1221: p_init_msg_list => FND_API.G_FALSE,
1222: x_return_status => x_return_status,
1223: x_msg_count => x_msg_count,
1224: x_msg_data => x_msg_data,
1225: p_channel_code => 'CREDIT_CARD',

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

1235: aso_debug_pub.add('x_response.result_message: '|| to_char(lx_response.result_message), 1, 'Y');
1236: END IF;
1237:
1238: IF (nvl(lx_channel_attrib_uses.Instr_SecCode_Use,'null') = 'REQUIRED' and
1239: (l_payment_rec.cvv2 is null or l_payment_rec.cvv2 = fnd_api.g_miss_char)) then
1240:
1241: x_return_status := FND_API.G_RET_STS_ERROR;
1242: FND_MESSAGE.Set_Name('ASO', 'ASO_CC_INVALID');
1243: FND_MSG_PUB.ADD;

Line 1241: x_return_status := FND_API.G_RET_STS_ERROR;

1237:
1238: IF (nvl(lx_channel_attrib_uses.Instr_SecCode_Use,'null') = 'REQUIRED' and
1239: (l_payment_rec.cvv2 is null or l_payment_rec.cvv2 = fnd_api.g_miss_char)) then
1240:
1241: x_return_status := FND_API.G_RET_STS_ERROR;
1242: FND_MESSAGE.Set_Name('ASO', 'ASO_CC_INVALID');
1243: FND_MSG_PUB.ADD;
1244: RAISE FND_API.G_EXC_ERROR;
1245: END IF;

Line 1244: RAISE FND_API.G_EXC_ERROR;

1240:
1241: x_return_status := FND_API.G_RET_STS_ERROR;
1242: FND_MESSAGE.Set_Name('ASO', 'ASO_CC_INVALID');
1243: FND_MSG_PUB.ADD;
1244: RAISE FND_API.G_EXC_ERROR;
1245: END IF;
1246: */
1247:
1248: if l_payment_rec.cvv2 = fnd_api.g_miss_char then

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

1244: RAISE FND_API.G_EXC_ERROR;
1245: END IF;
1246: */
1247:
1248: if l_payment_rec.cvv2 = fnd_api.g_miss_char then
1249: l_trxn_attribs.Instrument_Security_Code := null;
1250: else
1251: l_trxn_attribs.Instrument_Security_Code := l_payment_rec.cvv2;
1252: end if;

Line 1261: 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

1257: l_trxn_attribs.Additional_Info := null;
1258:
1259:
1260: --bug 5154775
1261: 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
1262: (l_payment_rec.instr_assignment_id IS NOT NULL AND l_payment_rec.instr_assignment_id <> fnd_api.g_miss_num) and
1263: (l_shared_cart_scenario = 'N')) then
1264:
1265: /*** Start : Code change done for Bug 14619666 ***/

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

1258:
1259:
1260: --bug 5154775
1261: 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
1262: (l_payment_rec.instr_assignment_id IS NOT NULL AND l_payment_rec.instr_assignment_id <> fnd_api.g_miss_num) and
1263: (l_shared_cart_scenario = 'N')) then
1264:
1265: /*** Start : Code change done for Bug 14619666 ***/
1266: Open c_check_authorized_flag(l_db_payment_rec.trxn_extension_id);

Line 1285: p_init_msg_list => FND_API.G_FALSE,

1281:
1282: IBY_FNDCPT_TRXN_PUB.Update_Transaction_Extension
1283: (
1284: p_api_version => 1.0,
1285: p_init_msg_list => FND_API.G_FALSE,
1286: p_commit => FND_API.G_FALSE,
1287: x_return_status => x_return_status,
1288: x_msg_count => x_msg_count,
1289: x_msg_data => x_msg_data,

Line 1286: p_commit => FND_API.G_FALSE,

1282: IBY_FNDCPT_TRXN_PUB.Update_Transaction_Extension
1283: (
1284: p_api_version => 1.0,
1285: p_init_msg_list => FND_API.G_FALSE,
1286: p_commit => FND_API.G_FALSE,
1287: x_return_status => x_return_status,
1288: x_msg_count => x_msg_count,
1289: x_msg_data => x_msg_data,
1290: p_payer => l_payer,

Line 1306: IF x_return_status <> fnd_api.g_ret_sts_success then

1302: aso_debug_pub.add('x_response.result_category: '|| to_char(lx_response.result_category), 1, 'Y');
1303: aso_debug_pub.add('x_response.result_message: '|| to_char(lx_response.result_message), 1, 'Y');
1304: END IF;
1305:
1306: IF x_return_status <> fnd_api.g_ret_sts_success then
1307: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1308: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
1309: FND_MESSAGE.Set_Token('API', 'IBY_FNDCPT_TRXN_PUB.Create_Transaction_Extension ', FALSE);
1310: FND_MSG_PUB.ADD;

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

1308: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
1309: FND_MESSAGE.Set_Token('API', 'IBY_FNDCPT_TRXN_PUB.Create_Transaction_Extension ', FALSE);
1310: FND_MSG_PUB.ADD;
1311: END IF;
1312: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1313: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1314: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1315: RAISE FND_API.G_EXC_ERROR;
1316: END IF;

Line 1313: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1309: FND_MESSAGE.Set_Token('API', 'IBY_FNDCPT_TRXN_PUB.Create_Transaction_Extension ', FALSE);
1310: FND_MSG_PUB.ADD;
1311: END IF;
1312: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1313: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1314: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1315: RAISE FND_API.G_EXC_ERROR;
1316: END IF;
1317: END IF;

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

1310: FND_MSG_PUB.ADD;
1311: END IF;
1312: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1313: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1314: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1315: RAISE FND_API.G_EXC_ERROR;
1316: END IF;
1317: END IF;
1318:

Line 1315: RAISE FND_API.G_EXC_ERROR;

1311: END IF;
1312: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1313: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1314: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1315: RAISE FND_API.G_EXC_ERROR;
1316: END IF;
1317: END IF;
1318:
1319: End If; -- l_authorized_flag is N

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

1321: ELSE -- else condition for trxn id not null
1322: -- fix for bug 4767905 and 5154775
1323: -- if cc has been created by shared user, then delete the previous extension
1324: if ( l_shared_cart_scenario = 'Y' and l_db_payment_rec.trxn_extension_id is not null
1325: and l_db_payment_rec.trxn_extension_id <> fnd_api.g_miss_num ) THEN
1326:
1327: -- set the party id to that of the orig user for deleting the trxn
1328: l_payer.party_id := l_orig_party_id;
1329: IF aso_debug_pub.g_debug_flag = 'Y' THEN

Line 1338: p_init_msg_list => FND_API.G_FALSE,

1334:
1335: IBY_FNDCPT_TRXN_PUB.Delete_Transaction_Extension
1336: (
1337: p_api_version => 1.0,
1338: p_init_msg_list => FND_API.G_FALSE,
1339: p_commit => FND_API.G_FALSE,
1340: x_return_status => x_return_status,
1341: x_msg_count => x_msg_count,
1342: x_msg_data => x_msg_data,

Line 1339: p_commit => FND_API.G_FALSE,

1335: IBY_FNDCPT_TRXN_PUB.Delete_Transaction_Extension
1336: (
1337: p_api_version => 1.0,
1338: p_init_msg_list => FND_API.G_FALSE,
1339: p_commit => FND_API.G_FALSE,
1340: x_return_status => x_return_status,
1341: x_msg_count => x_msg_count,
1342: x_msg_data => x_msg_data,
1343: p_payer => l_payer,

Line 1357: if x_return_status <> fnd_api.g_ret_sts_success then

1353: aso_debug_pub.add('Delete_Transaction_Extension x_response.result_category: '|| to_char(lx_response.result_category), 1, 'Y');
1354: aso_debug_pub.add('Delete_Transaction_Extension x_response.result_message: '|| to_char(lx_response.result_message), 1, 'Y');
1355: END IF;
1356:
1357: if x_return_status <> fnd_api.g_ret_sts_success then
1358: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1359: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
1360: FND_MESSAGE.Set_Token('API', ' IBY_FNDCPT_TRXN_PUB.Delete_Transaction_Extension', FALSE);
1361: FND_MSG_PUB.ADD;

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

1359: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
1360: FND_MESSAGE.Set_Token('API', ' IBY_FNDCPT_TRXN_PUB.Delete_Transaction_Extension', FALSE);
1361: FND_MSG_PUB.ADD;
1362: END IF;
1363: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1364: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1365: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1366: RAISE FND_API.G_EXC_ERROR;
1367: END IF;

Line 1364: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1360: FND_MESSAGE.Set_Token('API', ' IBY_FNDCPT_TRXN_PUB.Delete_Transaction_Extension', FALSE);
1361: FND_MSG_PUB.ADD;
1362: END IF;
1363: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1364: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1365: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1366: RAISE FND_API.G_EXC_ERROR;
1367: END IF;
1368: end if;

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

1361: FND_MSG_PUB.ADD;
1362: END IF;
1363: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1364: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1365: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1366: RAISE FND_API.G_EXC_ERROR;
1367: END IF;
1368: end if;
1369: -- reset the party id to that of the shared user

Line 1366: RAISE FND_API.G_EXC_ERROR;

1362: END IF;
1363: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1364: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1365: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1366: RAISE FND_API.G_EXC_ERROR;
1367: END IF;
1368: end if;
1369: -- reset the party id to that of the shared user
1370: open c_get_payer_id(l_payment_rec.instr_assignment_id);

Line 1395: p_init_msg_list => FND_API.G_FALSE,

1391:
1392: IBY_FNDCPT_SETUP_PUB.Get_Payment_Channel_Attribs
1393: (
1394: p_api_version => 1.0,
1395: p_init_msg_list => FND_API.G_FALSE,
1396: x_return_status => x_return_status,
1397: x_msg_count => x_msg_count,
1398: x_msg_data => x_msg_data,
1399: p_channel_code => 'CREDIT_CARD',

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

1409: aso_debug_pub.add('x_response.result_message: '|| to_char(lx_response.result_message), 1, 'Y');
1410: END IF;
1411:
1412: IF (nvl(lx_channel_attrib_uses.Instr_SecCode_Use,'null') = 'REQUIRED' and
1413: (l_payment_rec.cvv2 is null or l_payment_rec.cvv2 = fnd_api.g_miss_char)) then
1414:
1415: x_return_status := FND_API.G_RET_STS_ERROR;
1416: FND_MESSAGE.Set_Name('ASO', 'ASO_CC_INVALID');
1417: FND_MSG_PUB.ADD;

Line 1415: x_return_status := FND_API.G_RET_STS_ERROR;

1411:
1412: IF (nvl(lx_channel_attrib_uses.Instr_SecCode_Use,'null') = 'REQUIRED' and
1413: (l_payment_rec.cvv2 is null or l_payment_rec.cvv2 = fnd_api.g_miss_char)) then
1414:
1415: x_return_status := FND_API.G_RET_STS_ERROR;
1416: FND_MESSAGE.Set_Name('ASO', 'ASO_CC_INVALID');
1417: FND_MSG_PUB.ADD;
1418: RAISE FND_API.G_EXC_ERROR;
1419: END IF;

Line 1418: RAISE FND_API.G_EXC_ERROR;

1414:
1415: x_return_status := FND_API.G_RET_STS_ERROR;
1416: FND_MESSAGE.Set_Name('ASO', 'ASO_CC_INVALID');
1417: FND_MSG_PUB.ADD;
1418: RAISE FND_API.G_EXC_ERROR;
1419: END IF;
1420:
1421: if (l_payment_rec.instr_assignment_id is not null and l_payment_rec.instr_assignment_id <> fnd_api.g_miss_num) then
1422: IBY_FNDCPT_TRXN_PUB.Create_Transaction_Extension

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

1417: FND_MSG_PUB.ADD;
1418: RAISE FND_API.G_EXC_ERROR;
1419: END IF;
1420:
1421: if (l_payment_rec.instr_assignment_id is not null and l_payment_rec.instr_assignment_id <> fnd_api.g_miss_num) then
1422: IBY_FNDCPT_TRXN_PUB.Create_Transaction_Extension
1423: (
1424: p_api_version => 1.0,
1425: p_init_msg_list => FND_API.G_FALSE,

Line 1425: p_init_msg_list => FND_API.G_FALSE,

1421: if (l_payment_rec.instr_assignment_id is not null and l_payment_rec.instr_assignment_id <> fnd_api.g_miss_num) then
1422: IBY_FNDCPT_TRXN_PUB.Create_Transaction_Extension
1423: (
1424: p_api_version => 1.0,
1425: p_init_msg_list => FND_API.G_FALSE,
1426: p_commit => FND_API.G_FALSE,
1427: x_return_status => x_return_status,
1428: x_msg_count => x_msg_count,
1429: x_msg_data => x_msg_data,

Line 1426: p_commit => FND_API.G_FALSE,

1422: IBY_FNDCPT_TRXN_PUB.Create_Transaction_Extension
1423: (
1424: p_api_version => 1.0,
1425: p_init_msg_list => FND_API.G_FALSE,
1426: p_commit => FND_API.G_FALSE,
1427: x_return_status => x_return_status,
1428: x_msg_count => x_msg_count,
1429: x_msg_data => x_msg_data,
1430: p_payer => l_payer,

Line 1447: if x_return_status <> fnd_api.g_ret_sts_success then

1443: aso_debug_pub.add('x_response.result_category:'|| to_char(lx_response.result_category), 1, 'Y');
1444: aso_debug_pub.add('x_response.result_message: '|| to_char(lx_response.result_message), 1, 'Y');
1445: END IF;
1446:
1447: if x_return_status <> fnd_api.g_ret_sts_success then
1448: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1449: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
1450: FND_MESSAGE.Set_Token('API', 'IBY_FNDCPT_TRXN_PUB.Create_Transaction_Extension ', FALSE);
1451: FND_MSG_PUB.ADD;

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

1449: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
1450: FND_MESSAGE.Set_Token('API', 'IBY_FNDCPT_TRXN_PUB.Create_Transaction_Extension ', FALSE);
1451: FND_MSG_PUB.ADD;
1452: END IF;
1453: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1454: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1455: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1456: RAISE FND_API.G_EXC_ERROR;
1457: END IF;

Line 1454: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1450: FND_MESSAGE.Set_Token('API', 'IBY_FNDCPT_TRXN_PUB.Create_Transaction_Extension ', FALSE);
1451: FND_MSG_PUB.ADD;
1452: END IF;
1453: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1454: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1455: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1456: RAISE FND_API.G_EXC_ERROR;
1457: END IF;
1458: end if;

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

1451: FND_MSG_PUB.ADD;
1452: END IF;
1453: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1454: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1455: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1456: RAISE FND_API.G_EXC_ERROR;
1457: END IF;
1458: end if;
1459: l_payment_rec.trxn_extension_id := lx_entity_id;

Line 1456: RAISE FND_API.G_EXC_ERROR;

1452: END IF;
1453: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1454: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1455: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1456: RAISE FND_API.G_EXC_ERROR;
1457: END IF;
1458: end if;
1459: l_payment_rec.trxn_extension_id := lx_entity_id;
1460: end if; -- end if for the instr_assignment_id check

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

1463: end if;
1464:
1465:
1466: IF ((l_payment_rec.PAYMENT_TYPE_CODE = 'CREDIT_CARD') or
1467: ( l_db_payment_rec.payment_type_code = 'CREDIT_CARD' and l_payment_rec.PAYMENT_TYPE_CODE = fnd_api.g_miss_char)) then
1468: l_payment_ref_number := null;
1469: else
1470: l_payment_ref_number := l_payment_rec.PAYMENT_REF_NUMBER;
1471: END IF;

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

1532: -- End API Body
1533:
1534:
1535: -- Standard check for p_commit
1536: /*IF FND_API.to_Boolean( p_commit )
1537: THEN
1538: COMMIT WORK;
1539: END IF; */
1540:

Line 1552: WHEN FND_API.G_EXC_ERROR THEN

1548: aso_debug_pub.ADD ('END update_payment_row',1,'N');
1549: END IF;
1550:
1551: EXCEPTION
1552: WHEN FND_API.G_EXC_ERROR THEN
1553: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1554: P_API_NAME => L_API_NAME
1555: ,P_PKG_NAME => G_PKG_NAME
1556: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 1562: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1558: ,X_MSG_COUNT => X_MSG_COUNT
1559: ,X_MSG_DATA => X_MSG_DATA
1560: ,X_RETURN_STATUS => X_RETURN_STATUS);
1561:
1562: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1563: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1564: P_API_NAME => L_API_NAME
1565: ,P_PKG_NAME => G_PKG_NAME
1566: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

Line 1614: x_return_status := FND_API.G_RET_STS_SUCCESS;

1610: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1611: aso_debug_pub.add('Begin delete_payment_row ', 1, 'Y');
1612: END IF;
1613:
1614: x_return_status := FND_API.G_RET_STS_SUCCESS;
1615:
1616: l_qte_header_rec := ASO_UTILITY_PVT.Query_Header_Row (l_payment_rec.Quote_Header_Id );
1617:
1618: IF ( l_payment_rec.Quote_Line_Id IS NOT NULL and l_payment_rec.Quote_Line_Id <> fnd_api.g_miss_num) then

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

1614: x_return_status := FND_API.G_RET_STS_SUCCESS;
1615:
1616: l_qte_header_rec := ASO_UTILITY_PVT.Query_Header_Row (l_payment_rec.Quote_Header_Id );
1617:
1618: IF ( l_payment_rec.Quote_Line_Id IS NOT NULL and l_payment_rec.Quote_Line_Id <> fnd_api.g_miss_num) then
1619: l_qte_line_rec := ASO_UTILITY_PVT.Query_Qte_Line_Row ( l_payment_rec.Quote_Line_Id );
1620: END IF;
1621:
1622: --Get the databse payment record and assign it to l_payment_rec

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

1619: l_qte_line_rec := ASO_UTILITY_PVT.Query_Qte_Line_Row ( l_payment_rec.Quote_Line_Id );
1620: END IF;
1621:
1622: --Get the databse payment record and assign it to l_payment_rec
1623: IF ( l_payment_rec.Quote_Line_Id = fnd_api.g_miss_num) then
1624: l_payment_rec.quote_line_id := null;
1625: END IF;
1626:
1627: l_payment_tbl := aso_utility_pvt.Query_Payment_Rows(l_payment_rec.quote_header_id,l_payment_rec.quote_line_id);

Line 1654: p_init_msg_list => FND_API.G_FALSE,

1650:
1651: IBY_FNDCPT_TRXN_PUB.Delete_Transaction_Extension
1652: (
1653: p_api_version => 1.0,
1654: p_init_msg_list => FND_API.G_FALSE,
1655: p_commit => FND_API.G_FALSE,
1656: x_return_status => x_return_status,
1657: x_msg_count => x_msg_count,
1658: x_msg_data => x_msg_data,

Line 1655: p_commit => FND_API.G_FALSE,

1651: IBY_FNDCPT_TRXN_PUB.Delete_Transaction_Extension
1652: (
1653: p_api_version => 1.0,
1654: p_init_msg_list => FND_API.G_FALSE,
1655: p_commit => FND_API.G_FALSE,
1656: x_return_status => x_return_status,
1657: x_msg_count => x_msg_count,
1658: x_msg_data => x_msg_data,
1659: p_payer => l_payer,

Line 1673: if x_return_status <> fnd_api.g_ret_sts_success then

1669: aso_debug_pub.add('Delete_Transaction_Extension x_response.result_category: '|| to_char(lx_response.result_category), 1, 'Y');
1670: aso_debug_pub.add('Delete_Transaction_Extension x_response.result_message: '|| to_char(lx_response.result_message), 1, 'Y');
1671: END IF;
1672:
1673: if x_return_status <> fnd_api.g_ret_sts_success then
1674: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1675: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
1676: FND_MESSAGE.Set_Token('API', ' IBY_FNDCPT_TRXN_PUB.Delete_Transaction_Extension', FALSE);
1677: FND_MSG_PUB.ADD;

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

1675: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
1676: FND_MESSAGE.Set_Token('API', ' IBY_FNDCPT_TRXN_PUB.Delete_Transaction_Extension', FALSE);
1677: FND_MSG_PUB.ADD;
1678: END IF;
1679: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1680: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1681: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1682: RAISE FND_API.G_EXC_ERROR;
1683: END IF;

Line 1680: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1676: FND_MESSAGE.Set_Token('API', ' IBY_FNDCPT_TRXN_PUB.Delete_Transaction_Extension', FALSE);
1677: FND_MSG_PUB.ADD;
1678: END IF;
1679: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1680: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1681: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1682: RAISE FND_API.G_EXC_ERROR;
1683: END IF;
1684: end if;

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

1677: FND_MSG_PUB.ADD;
1678: END IF;
1679: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1680: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1681: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1682: RAISE FND_API.G_EXC_ERROR;
1683: END IF;
1684: end if;
1685: end if;

Line 1682: RAISE FND_API.G_EXC_ERROR;

1678: END IF;
1679: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1680: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1681: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1682: RAISE FND_API.G_EXC_ERROR;
1683: END IF;
1684: end if;
1685: end if;
1686:

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

1686:
1687: ASO_PAYMENTS_PKG.Delete_Row(p_PAYMENT_ID => p_payment_rec.PAYMENT_ID);
1688:
1689: -- Standard check for p_commit
1690: /*IF FND_API.to_Boolean( p_commit )
1691: THEN
1692: COMMIT WORK;
1693: END IF; */
1694:

Line 1706: WHEN FND_API.G_EXC_ERROR THEN

1702: aso_debug_pub.ADD ('END delete_payment_row',1,'N');
1703: END IF;
1704:
1705: EXCEPTION
1706: WHEN FND_API.G_EXC_ERROR THEN
1707: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1708: P_API_NAME => L_API_NAME
1709: ,P_PKG_NAME => G_PKG_NAME
1710: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 1716: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1712: ,X_MSG_COUNT => X_MSG_COUNT
1713: ,X_MSG_DATA => X_MSG_DATA
1714: ,X_RETURN_STATUS => X_RETURN_STATUS);
1715:
1716: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1717: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1718: P_API_NAME => L_API_NAME
1719: ,P_PKG_NAME => G_PKG_NAME
1720: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR