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

Line 199: IF FND_API.to_Boolean(p_is_update) THEN

195: l_addressid := p_creditcard.Billing_Address_Id;
196: l_billing_zip := p_creditcard.Billing_Postal_Code;
197: l_billing_terr := p_creditcard.Billing_Address_Territory;
198:
199: IF FND_API.to_Boolean(p_is_update) THEN
200: IF (l_addressid = FND_API.G_MISS_NUM) THEN
201: l_addressid := NULL;
202: ELSIF (l_addressid IS NULL) THEN
203: l_addressid := FND_API.G_MISS_NUM;

Line 200: IF (l_addressid = FND_API.G_MISS_NUM) THEN

196: l_billing_zip := p_creditcard.Billing_Postal_Code;
197: l_billing_terr := p_creditcard.Billing_Address_Territory;
198:
199: IF FND_API.to_Boolean(p_is_update) THEN
200: IF (l_addressid = FND_API.G_MISS_NUM) THEN
201: l_addressid := NULL;
202: ELSIF (l_addressid IS NULL) THEN
203: l_addressid := FND_API.G_MISS_NUM;
204: END IF;

Line 203: l_addressid := FND_API.G_MISS_NUM;

199: IF FND_API.to_Boolean(p_is_update) THEN
200: IF (l_addressid = FND_API.G_MISS_NUM) THEN
201: l_addressid := NULL;
202: ELSIF (l_addressid IS NULL) THEN
203: l_addressid := FND_API.G_MISS_NUM;
204: END IF;
205: IF (l_billing_zip = FND_API.G_MISS_CHAR) THEN
206: l_billing_zip := NULL;
207: ELSIF (l_billing_zip IS NULL) THEN

Line 205: IF (l_billing_zip = FND_API.G_MISS_CHAR) THEN

201: l_addressid := NULL;
202: ELSIF (l_addressid IS NULL) THEN
203: l_addressid := FND_API.G_MISS_NUM;
204: END IF;
205: IF (l_billing_zip = FND_API.G_MISS_CHAR) THEN
206: l_billing_zip := NULL;
207: ELSIF (l_billing_zip IS NULL) THEN
208: l_billing_zip := FND_API.G_MISS_CHAR;
209: END IF;

Line 208: l_billing_zip := FND_API.G_MISS_CHAR;

204: END IF;
205: IF (l_billing_zip = FND_API.G_MISS_CHAR) THEN
206: l_billing_zip := NULL;
207: ELSIF (l_billing_zip IS NULL) THEN
208: l_billing_zip := FND_API.G_MISS_CHAR;
209: END IF;
210: IF (l_billing_terr = FND_API.G_MISS_CHAR) THEN
211: l_billing_terr := NULL;
212: ELSIF (l_billing_terr IS NULL) THEN

Line 210: IF (l_billing_terr = FND_API.G_MISS_CHAR) THEN

206: l_billing_zip := NULL;
207: ELSIF (l_billing_zip IS NULL) THEN
208: l_billing_zip := FND_API.G_MISS_CHAR;
209: END IF;
210: IF (l_billing_terr = FND_API.G_MISS_CHAR) THEN
211: l_billing_terr := NULL;
212: ELSIF (l_billing_terr IS NULL) THEN
213: l_billing_terr := FND_API.G_MISS_CHAR;
214: END IF;

Line 213: l_billing_terr := FND_API.G_MISS_CHAR;

209: END IF;
210: IF (l_billing_terr = FND_API.G_MISS_CHAR) THEN
211: l_billing_terr := NULL;
212: ELSIF (l_billing_terr IS NULL) THEN
213: l_billing_terr := FND_API.G_MISS_CHAR;
214: END IF;
215: END IF;
216:
217: IF ( (NOT (l_addressid IS NULL OR l_addressid = FND_API.G_MISS_NUM))

Line 217: IF ( (NOT (l_addressid IS NULL OR l_addressid = FND_API.G_MISS_NUM))

213: l_billing_terr := FND_API.G_MISS_CHAR;
214: END IF;
215: END IF;
216:
217: IF ( (NOT (l_addressid IS NULL OR l_addressid = FND_API.G_MISS_NUM))
218: AND
219: (NOT (l_billing_zip IS NULL OR l_billing_zip = FND_API.G_MISS_CHAR))
220: )
221: THEN

Line 219: (NOT (l_billing_zip IS NULL OR l_billing_zip = FND_API.G_MISS_CHAR))

215: END IF;
216:
217: IF ( (NOT (l_addressid IS NULL OR l_addressid = FND_API.G_MISS_NUM))
218: AND
219: (NOT (l_billing_zip IS NULL OR l_billing_zip = FND_API.G_MISS_CHAR))
220: )
221: THEN
222: RETURN FALSE;
223: END IF;

Line 225: IF ( (NOT (l_billing_zip IS NULL OR l_billing_zip = FND_API.G_MISS_CHAR))

221: THEN
222: RETURN FALSE;
223: END IF;
224:
225: IF ( (NOT (l_billing_zip IS NULL OR l_billing_zip = FND_API.G_MISS_CHAR))
226: AND (l_billing_terr IS NULL OR l_billing_terr = FND_API.G_MISS_CHAR)
227: )
228: THEN
229: RETURN FALSE;

Line 226: AND (l_billing_terr IS NULL OR l_billing_terr = FND_API.G_MISS_CHAR)

222: RETURN FALSE;
223: END IF;
224:
225: IF ( (NOT (l_billing_zip IS NULL OR l_billing_zip = FND_API.G_MISS_CHAR))
226: AND (l_billing_terr IS NULL OR l_billing_terr = FND_API.G_MISS_CHAR)
227: )
228: THEN
229: RETURN FALSE;
230: ELSIF ( (NOT (l_billing_terr IS NULL OR l_billing_terr = FND_API.G_MISS_CHAR))

Line 230: ELSIF ( (NOT (l_billing_terr IS NULL OR l_billing_terr = FND_API.G_MISS_CHAR))

226: AND (l_billing_terr IS NULL OR l_billing_terr = FND_API.G_MISS_CHAR)
227: )
228: THEN
229: RETURN FALSE;
230: ELSIF ( (NOT (l_billing_terr IS NULL OR l_billing_terr = FND_API.G_MISS_CHAR))
231:
232: AND (l_billing_zip IS NULL OR l_billing_zip = FND_API.G_MISS_CHAR)
233: )
234: THEN

Line 232: AND (l_billing_zip IS NULL OR l_billing_zip = FND_API.G_MISS_CHAR)

228: THEN
229: RETURN FALSE;
230: ELSIF ( (NOT (l_billing_terr IS NULL OR l_billing_terr = FND_API.G_MISS_CHAR))
231:
232: AND (l_billing_zip IS NULL OR l_billing_zip = FND_API.G_MISS_CHAR)
233: )
234: THEN
235: RETURN FALSE;
236: END IF;

Line 239: (1.0, FND_API.G_FALSE, lx_return_status, lx_msg_count, lx_msg_data,

235: RETURN FALSE;
236: END IF;
237:
238: Get_Payment_Channel_Attribs
239: (1.0, FND_API.G_FALSE, lx_return_status, lx_msg_count, lx_msg_data,
240: G_CHANNEL_CREDIT_CARD, lx_channel_attribs, lx_result);
241:
242: IF ((lx_channel_attribs.Instr_Billing_Address = G_CHNNL_ATTRIB_USE_REQUIRED)
243: AND ((l_addressid IS NULL) AND (l_billing_zip IS NULL))

Line 317: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

313:
314: PROCEDURE Set_Payer_Attributes
315: (
316: p_api_version IN NUMBER,
317: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
318: p_commit IN VARCHAR2 := FND_API.G_TRUE,
319: x_return_status OUT NOCOPY VARCHAR2,
320: x_msg_count OUT NOCOPY NUMBER,
321: x_msg_data OUT NOCOPY VARCHAR2,

Line 318: p_commit IN VARCHAR2 := FND_API.G_TRUE,

314: PROCEDURE Set_Payer_Attributes
315: (
316: p_api_version IN NUMBER,
317: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
318: p_commit IN VARCHAR2 := FND_API.G_TRUE,
319: x_return_status OUT NOCOPY VARCHAR2,
320: x_msg_count OUT NOCOPY NUMBER,
321: x_msg_data OUT NOCOPY VARCHAR2,
322: p_payer IN IBY_FNDCPT_COMMON_PUB.PayerContext_rec_type,

Line 336: IF NOT FND_API.Compatible_API_Call (l_api_version,

332: l_prev_msg_count NUMBER;
333:
334: BEGIN
335:
336: IF NOT FND_API.Compatible_API_Call (l_api_version,
337: p_api_version,
338: l_module,
339: G_PKG_NAME)
340: THEN

Line 346: RAISE FND_API.G_EXC_ERROR;

342: debug_level => FND_LOG.LEVEL_ERROR,
343: module => G_DEBUG_MODULE || l_module);
344: FND_MESSAGE.SET_NAME('IBY', 'IBY_204400_API_VER_MISMATCH');
345: FND_MSG_PUB.Add;
346: RAISE FND_API.G_EXC_ERROR;
347: END IF;
348:
349: IF FND_API.to_Boolean( p_init_msg_list ) THEN
350: FND_MSG_PUB.initialize;

Line 349: IF FND_API.to_Boolean( p_init_msg_list ) THEN

345: FND_MSG_PUB.Add;
346: RAISE FND_API.G_EXC_ERROR;
347: END IF;
348:
349: IF FND_API.to_Boolean( p_init_msg_list ) THEN
350: FND_MSG_PUB.initialize;
351: END IF;
352: l_prev_msg_count := FND_MSG_PUB.Count_Msg;
353:

Line 354: Get_Payer_Id(p_payer,FND_API.G_VALID_LEVEL_FULL,

350: FND_MSG_PUB.initialize;
351: END IF;
352: l_prev_msg_count := FND_MSG_PUB.Count_Msg;
353:
354: Get_Payer_Id(p_payer,FND_API.G_VALID_LEVEL_FULL,
355: l_payer_level,x_payer_attribs_id,l_payer_attribs);
356:
357: IF (l_payer_level = IBY_FNDCPT_COMMON_PUB.G_RC_INVALID_PAYER) THEN
358: x_response.Result_Code := l_payer_level;

Line 387: FND_API.G_MISS_CHAR,NULL, p_payer_attributes.DirectDebit_BankInstruction),

383: UPDATE iby_external_payers_all
384: SET
385: dirdeb_instruction_code =
386: DECODE(p_payer_attributes.DirectDebit_BankInstruction,
387: FND_API.G_MISS_CHAR,NULL, p_payer_attributes.DirectDebit_BankInstruction),
388: bank_charge_bearer_code =
389: DECODE(p_payer_attributes.Bank_Charge_Bearer,
390: FND_API.G_MISS_CHAR,NULL, p_payer_attributes.Bank_Charge_Bearer),
391: last_updated_by = fnd_global.user_id,

Line 390: FND_API.G_MISS_CHAR,NULL, p_payer_attributes.Bank_Charge_Bearer),

386: DECODE(p_payer_attributes.DirectDebit_BankInstruction,
387: FND_API.G_MISS_CHAR,NULL, p_payer_attributes.DirectDebit_BankInstruction),
388: bank_charge_bearer_code =
389: DECODE(p_payer_attributes.Bank_Charge_Bearer,
390: FND_API.G_MISS_CHAR,NULL, p_payer_attributes.Bank_Charge_Bearer),
391: last_updated_by = fnd_global.user_id,
392: last_update_date = SYSDATE,
393: last_update_login = fnd_global.login_id,
394: object_version_number = object_version_number + 1,

Line 401: IF FND_API.To_Boolean(p_commit) THEN

397: debit_advice_fax = p_payer.Debit_Advice_Fax
398: WHERE (ext_payer_id = x_payer_attribs_id);
399: END IF;
400:
401: IF FND_API.To_Boolean(p_commit) THEN
402: COMMIT;
403: END IF;
404:
405: x_response.Result_Code := IBY_FNDCPT_COMMON_PUB.G_RC_SUCCESS;

Line 411: WHEN FND_API.G_EXC_ERROR THEN

407: (l_prev_msg_count,x_return_status,x_msg_count,x_msg_data,x_response);
408:
409: EXCEPTION
410:
411: WHEN FND_API.G_EXC_ERROR THEN
412:
413: iby_debug_pub.add(debug_msg => 'In G_EXC_ERROR Exception',
414: debug_level => FND_LOG.LEVEL_ERROR,
415: module => G_DEBUG_MODULE || l_module);

Line 416: x_return_status := FND_API.G_RET_STS_ERROR ;

412:
413: iby_debug_pub.add(debug_msg => 'In G_EXC_ERROR Exception',
414: debug_level => FND_LOG.LEVEL_ERROR,
415: module => G_DEBUG_MODULE || l_module);
416: x_return_status := FND_API.G_RET_STS_ERROR ;
417: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
418: p_data => x_msg_data
419: );
420: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 420: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

416: x_return_status := FND_API.G_RET_STS_ERROR ;
417: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
418: p_data => x_msg_data
419: );
420: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
421:
422: iby_debug_pub.add(debug_msg => 'In G_EXC_UNEXPECTED_ERROR Exception',
423: debug_level => FND_LOG.LEVEL_UNEXPECTED,
424: module => G_DEBUG_MODULE || l_module);

Line 425: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

421:
422: iby_debug_pub.add(debug_msg => 'In G_EXC_UNEXPECTED_ERROR Exception',
423: debug_level => FND_LOG.LEVEL_UNEXPECTED,
424: module => G_DEBUG_MODULE || l_module);
425: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
426: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
427: p_data => x_msg_data
428: );
429: WHEN OTHERS THEN

Line 437: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

433: module => G_DEBUG_MODULE || l_module);
434:
435: iby_fndcpt_common_pub.Clear_Msg_Stack(l_prev_msg_count);
436:
437: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
438: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
439: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_module, SUBSTR(SQLERRM,1,100));
440: END IF;
441:

Line 450: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

446:
447: PROCEDURE Get_Payer_Attributes
448: (
449: p_api_version IN NUMBER,
450: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
451: x_return_status OUT NOCOPY VARCHAR2,
452: x_msg_count OUT NOCOPY NUMBER,
453: x_msg_data OUT NOCOPY VARCHAR2,
454: p_payer IN IBY_FNDCPT_COMMON_PUB.PayerContext_rec_type,

Line 467: IF NOT FND_API.Compatible_API_Call (l_api_version,

463: l_prev_msg_count NUMBER;
464:
465: BEGIN
466:
467: IF NOT FND_API.Compatible_API_Call (l_api_version,
468: p_api_version,
469: l_module,
470: G_PKG_NAME)
471: THEN

Line 477: RAISE FND_API.G_EXC_ERROR;

473: debug_level => FND_LOG.LEVEL_ERROR,
474: module => G_DEBUG_MODULE || l_module);
475: FND_MESSAGE.SET_NAME('IBY', 'IBY_204400_API_VER_MISMATCH');
476: FND_MSG_PUB.Add;
477: RAISE FND_API.G_EXC_ERROR;
478: END IF;
479:
480: IF FND_API.to_Boolean( p_init_msg_list ) THEN
481: FND_MSG_PUB.initialize;

Line 480: IF FND_API.to_Boolean( p_init_msg_list ) THEN

476: FND_MSG_PUB.Add;
477: RAISE FND_API.G_EXC_ERROR;
478: END IF;
479:
480: IF FND_API.to_Boolean( p_init_msg_list ) THEN
481: FND_MSG_PUB.initialize;
482: END IF;
483: l_prev_msg_count := FND_MSG_PUB.Count_Msg;
484:

Line 485: Get_Payer_Id(p_payer,FND_API.G_VALID_LEVEL_FULL,

481: FND_MSG_PUB.initialize;
482: END IF;
483: l_prev_msg_count := FND_MSG_PUB.Count_Msg;
484:
485: Get_Payer_Id(p_payer,FND_API.G_VALID_LEVEL_FULL,
486: l_payer_level,x_payer_attribs_id,x_payer_attributes);
487: IF (x_payer_attribs_id IS NULL) THEN
488: x_response.Result_Code := IBY_FNDCPT_COMMON_PUB.G_RC_INVALID_PAYER;
489: ELSE

Line 498: WHEN FND_API.G_EXC_ERROR THEN

494: (l_prev_msg_count,x_return_status,x_msg_count,x_msg_data,x_response);
495:
496: EXCEPTION
497:
498: WHEN FND_API.G_EXC_ERROR THEN
499:
500: iby_debug_pub.add(debug_msg => 'In G_EXC_ERROR Exception',
501: debug_level => FND_LOG.LEVEL_ERROR,
502: module => G_DEBUG_MODULE || l_module);

Line 503: x_return_status := FND_API.G_RET_STS_ERROR ;

499:
500: iby_debug_pub.add(debug_msg => 'In G_EXC_ERROR Exception',
501: debug_level => FND_LOG.LEVEL_ERROR,
502: module => G_DEBUG_MODULE || l_module);
503: x_return_status := FND_API.G_RET_STS_ERROR ;
504: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
505: p_data => x_msg_data
506: );
507: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 507: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

503: x_return_status := FND_API.G_RET_STS_ERROR ;
504: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
505: p_data => x_msg_data
506: );
507: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
508:
509: iby_debug_pub.add(debug_msg => 'In G_EXC_UNEXPECTED_ERROR Exception',
510: debug_level => FND_LOG.LEVEL_UNEXPECTED,
511: module => G_DEBUG_MODULE || l_module);

Line 512: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

508:
509: iby_debug_pub.add(debug_msg => 'In G_EXC_UNEXPECTED_ERROR Exception',
510: debug_level => FND_LOG.LEVEL_UNEXPECTED,
511: module => G_DEBUG_MODULE || l_module);
512: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
513: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
514: p_data => x_msg_data
515: );
516: WHEN OTHERS THEN

Line 521: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

517:
518: iby_debug_pub.add(debug_msg => 'In OTHERS Exception',
519: debug_level => FND_LOG.LEVEL_UNEXPECTED,
520: module => G_DEBUG_MODULE || l_module);
521: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
522: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
523: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_module);
524: END IF;
525:

Line 534: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

530:
531: PROCEDURE Get_Payment_Channel_Attribs
532: (
533: p_api_version IN NUMBER,
534: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
535: x_return_status OUT NOCOPY VARCHAR2,
536: x_msg_count OUT NOCOPY NUMBER,
537: x_msg_data OUT NOCOPY VARCHAR2,
538: p_channel_code IN VARCHAR2,

Line 601: IF NOT FND_API.Compatible_API_Call (l_api_version,

597: BEGIN
598:
599: IF (c_appl_attribs%ISOPEN) THEN CLOSE c_appl_attribs; END IF;
600:
601: IF NOT FND_API.Compatible_API_Call (l_api_version,
602: p_api_version,
603: l_module,
604: G_PKG_NAME)
605: THEN

Line 611: RAISE FND_API.G_EXC_ERROR;

607: debug_level => FND_LOG.LEVEL_ERROR,
608: module => G_DEBUG_MODULE || l_module);
609: FND_MESSAGE.SET_NAME('IBY', 'IBY_204400_API_VER_MISMATCH');
610: FND_MSG_PUB.Add;
611: RAISE FND_API.G_EXC_ERROR;
612: END IF;
613:
614: IF FND_API.to_Boolean( p_init_msg_list ) THEN
615: FND_MSG_PUB.initialize;

Line 614: IF FND_API.to_Boolean( p_init_msg_list ) THEN

610: FND_MSG_PUB.Add;
611: RAISE FND_API.G_EXC_ERROR;
612: END IF;
613:
614: IF FND_API.to_Boolean( p_init_msg_list ) THEN
615: FND_MSG_PUB.initialize;
616: END IF;
617: l_prev_msg_count := FND_MSG_PUB.Count_Msg;
618:

Line 643: WHEN FND_API.G_EXC_ERROR THEN

639: (l_prev_msg_count,x_return_status,x_msg_count,x_msg_data,x_response);
640:
641: EXCEPTION
642:
643: WHEN FND_API.G_EXC_ERROR THEN
644:
645: iby_debug_pub.add(debug_msg => 'In G_EXC_ERROR Exception',
646: debug_level => FND_LOG.LEVEL_ERROR,
647: module => G_DEBUG_MODULE || l_module);

Line 648: x_return_status := FND_API.G_RET_STS_ERROR ;

644:
645: iby_debug_pub.add(debug_msg => 'In G_EXC_ERROR Exception',
646: debug_level => FND_LOG.LEVEL_ERROR,
647: module => G_DEBUG_MODULE || l_module);
648: x_return_status := FND_API.G_RET_STS_ERROR ;
649: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
650: p_data => x_msg_data
651: );
652: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 652: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

648: x_return_status := FND_API.G_RET_STS_ERROR ;
649: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
650: p_data => x_msg_data
651: );
652: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
653:
654: iby_debug_pub.add(debug_msg => 'In G_EXC_UNEXPECTED_ERROR Exception',
655: debug_level => FND_LOG.LEVEL_UNEXPECTED,
656: module => G_DEBUG_MODULE || l_module);

Line 657: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

653:
654: iby_debug_pub.add(debug_msg => 'In G_EXC_UNEXPECTED_ERROR Exception',
655: debug_level => FND_LOG.LEVEL_UNEXPECTED,
656: module => G_DEBUG_MODULE || l_module);
657: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
658: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
659: p_data => x_msg_data
660: );
661: WHEN OTHERS THEN

Line 669: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

665: module => G_DEBUG_MODULE || l_module);
666:
667: iby_fndcpt_common_pub.Clear_Msg_Stack(l_prev_msg_count);
668:
669: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
670: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
671: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_module, SUBSTR(SQLERRM,1,100));
672: END IF;
673:

Line 682: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

678:
679: PROCEDURE Set_Payer_Default_Pmt_Channel
680: (
681: p_api_version IN NUMBER,
682: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
683: p_commit IN VARCHAR2 := FND_API.G_TRUE,
684: x_return_status OUT NOCOPY VARCHAR2,
685: x_msg_count OUT NOCOPY NUMBER,
686: x_msg_data OUT NOCOPY VARCHAR2,

Line 683: p_commit IN VARCHAR2 := FND_API.G_TRUE,

679: PROCEDURE Set_Payer_Default_Pmt_Channel
680: (
681: p_api_version IN NUMBER,
682: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
683: p_commit IN VARCHAR2 := FND_API.G_TRUE,
684: x_return_status OUT NOCOPY VARCHAR2,
685: x_msg_count OUT NOCOPY NUMBER,
686: x_msg_data OUT NOCOPY VARCHAR2,
687: p_payer IN IBY_FNDCPT_COMMON_PUB.PayerContext_rec_type,

Line 717: IF NOT FND_API.Compatible_API_Call (l_api_version,

713: IF (c_chnnl_assign%ISOPEN) THEN
714: CLOSE c_chnnl_assign;
715: END IF;
716:
717: IF NOT FND_API.Compatible_API_Call (l_api_version,
718: p_api_version,
719: l_module,
720: G_PKG_NAME)
721: THEN

Line 727: RAISE FND_API.G_EXC_ERROR;

723: debug_level => FND_LOG.LEVEL_ERROR,
724: module => G_DEBUG_MODULE || l_module);
725: FND_MESSAGE.SET_NAME('IBY', 'IBY_204400_API_VER_MISMATCH');
726: FND_MSG_PUB.Add;
727: RAISE FND_API.G_EXC_ERROR;
728: END IF;
729:
730: IF FND_API.to_Boolean( p_init_msg_list ) THEN
731: FND_MSG_PUB.initialize;

Line 730: IF FND_API.to_Boolean( p_init_msg_list ) THEN

726: FND_MSG_PUB.Add;
727: RAISE FND_API.G_EXC_ERROR;
728: END IF;
729:
730: IF FND_API.to_Boolean( p_init_msg_list ) THEN
731: FND_MSG_PUB.initialize;
732: END IF;
733: l_prev_msg_count := FND_MSG_PUB.Count_Msg;
734:

Line 735: Get_Payer_Id(p_payer,FND_API.G_VALID_LEVEL_FULL,l_payer_level,

731: FND_MSG_PUB.initialize;
732: END IF;
733: l_prev_msg_count := FND_MSG_PUB.Count_Msg;
734:
735: Get_Payer_Id(p_payer,FND_API.G_VALID_LEVEL_FULL,l_payer_level,
736: l_payer_id,l_payer_attribs);
737:
738: IF (l_payer_level = IBY_FNDCPT_COMMON_PUB.G_RC_INVALID_PAYER) THEN
739: x_response.Result_Code := IBY_FNDCPT_COMMON_PUB.G_RC_INVALID_PAYER;

Line 750: FND_API.G_FALSE,

746: IF (l_payer_id IS NULL) THEN
747: IBY_FNDCPT_SETUP_PUB.Set_Payer_Attributes
748: (
749: 1.0,
750: FND_API.G_FALSE,
751: FND_API.G_FALSE,
752: x_return_status,
753: x_msg_count,
754: x_msg_data,

Line 751: FND_API.G_FALSE,

747: IBY_FNDCPT_SETUP_PUB.Set_Payer_Attributes
748: (
749: 1.0,
750: FND_API.G_FALSE,
751: FND_API.G_FALSE,
752: x_return_status,
753: x_msg_count,
754: x_msg_data,
755: p_payer,

Line 808: IF FND_API.To_Boolean(p_commit) THEN

804:
805: iby_fndcpt_common_pub.Prepare_Result
806: (l_prev_msg_count,x_return_status,x_msg_count,x_msg_data,x_response);
807:
808: IF FND_API.To_Boolean(p_commit) THEN
809: COMMIT;
810: END IF;
811:
812: EXCEPTION

Line 814: WHEN FND_API.G_EXC_ERROR THEN

810: END IF;
811:
812: EXCEPTION
813:
814: WHEN FND_API.G_EXC_ERROR THEN
815: ROLLBACK TO Set_Payer_Default_Pmt_Channel;
816: iby_debug_pub.add(debug_msg => 'In G_EXC_ERROR Exception',
817: debug_level => FND_LOG.LEVEL_ERROR,
818: module => G_DEBUG_MODULE || l_module);

Line 819: x_return_status := FND_API.G_RET_STS_ERROR ;

815: ROLLBACK TO Set_Payer_Default_Pmt_Channel;
816: iby_debug_pub.add(debug_msg => 'In G_EXC_ERROR Exception',
817: debug_level => FND_LOG.LEVEL_ERROR,
818: module => G_DEBUG_MODULE || l_module);
819: x_return_status := FND_API.G_RET_STS_ERROR ;
820: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
821: p_data => x_msg_data
822: );
823: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 823: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

819: x_return_status := FND_API.G_RET_STS_ERROR ;
820: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
821: p_data => x_msg_data
822: );
823: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
824: ROLLBACK TO Set_Payer_Default_Pmt_Channel;
825: iby_debug_pub.add(debug_msg => 'In G_EXC_UNEXPECTED_ERROR Exception',
826: debug_level => FND_LOG.LEVEL_UNEXPECTED,
827: module => G_DEBUG_MODULE || l_module);

Line 828: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

824: ROLLBACK TO Set_Payer_Default_Pmt_Channel;
825: iby_debug_pub.add(debug_msg => 'In G_EXC_UNEXPECTED_ERROR Exception',
826: debug_level => FND_LOG.LEVEL_UNEXPECTED,
827: module => G_DEBUG_MODULE || l_module);
828: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
829: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
830: p_data => x_msg_data
831: );
832: WHEN OTHERS THEN

Line 841: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

837: module => G_DEBUG_MODULE || l_module);
838:
839: iby_fndcpt_common_pub.Clear_Msg_Stack(l_prev_msg_count);
840:
841: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
842: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
843: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_module, SUBSTR(SQLERRM,1,100));
844: END IF;
845:

Line 854: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

850:
851: PROCEDURE Get_Payer_Default_Pmt_Channel
852: (
853: p_api_version IN NUMBER,
854: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
855: x_return_status OUT NOCOPY VARCHAR2,
856: x_msg_count OUT NOCOPY NUMBER,
857: x_msg_data OUT NOCOPY VARCHAR2,
858: p_payer IN IBY_FNDCPT_COMMON_PUB.PayerContext_rec_type,

Line 886: IF NOT FND_API.Compatible_API_Call (l_api_version,

882: IF (c_chnnl_assign%ISOPEN) THEN
883: CLOSE c_chnnl_assign;
884: END IF;
885:
886: IF NOT FND_API.Compatible_API_Call (l_api_version,
887: p_api_version,
888: l_module,
889: G_PKG_NAME)
890: THEN

Line 896: RAISE FND_API.G_EXC_ERROR;

892: debug_level => FND_LOG.LEVEL_ERROR,
893: module => G_DEBUG_MODULE || l_module);
894: FND_MESSAGE.SET_NAME('IBY', 'IBY_204400_API_VER_MISMATCH');
895: FND_MSG_PUB.Add;
896: RAISE FND_API.G_EXC_ERROR;
897: END IF;
898:
899: IF FND_API.to_Boolean( p_init_msg_list ) THEN
900: FND_MSG_PUB.initialize;

Line 899: IF FND_API.to_Boolean( p_init_msg_list ) THEN

895: FND_MSG_PUB.Add;
896: RAISE FND_API.G_EXC_ERROR;
897: END IF;
898:
899: IF FND_API.to_Boolean( p_init_msg_list ) THEN
900: FND_MSG_PUB.initialize;
901: END IF;
902: l_prev_msg_count := FND_MSG_PUB.Count_Msg;
903:

Line 904: Get_Payer_Id(p_payer,FND_API.G_VALID_LEVEL_FULL,

900: FND_MSG_PUB.initialize;
901: END IF;
902: l_prev_msg_count := FND_MSG_PUB.Count_Msg;
903:
904: Get_Payer_Id(p_payer,FND_API.G_VALID_LEVEL_FULL,
905: l_payer_level,l_payer_id,l_payer_attribs);
906:
907: IF (l_payer_level = IBY_FNDCPT_COMMON_PUB.G_RC_INVALID_PAYER) THEN
908: x_response.Result_Code := IBY_FNDCPT_COMMON_PUB.G_RC_INVALID_PAYER;

Line 926: WHEN FND_API.G_EXC_ERROR THEN

922: (l_prev_msg_count,x_return_status,x_msg_count,x_msg_data,x_response);
923:
924: EXCEPTION
925:
926: WHEN FND_API.G_EXC_ERROR THEN
927:
928: iby_debug_pub.add(debug_msg => 'In G_EXC_ERROR Exception',
929: debug_level => FND_LOG.LEVEL_ERROR,
930: module => G_DEBUG_MODULE || l_module);

Line 931: x_return_status := FND_API.G_RET_STS_ERROR ;

927:
928: iby_debug_pub.add(debug_msg => 'In G_EXC_ERROR Exception',
929: debug_level => FND_LOG.LEVEL_ERROR,
930: module => G_DEBUG_MODULE || l_module);
931: x_return_status := FND_API.G_RET_STS_ERROR ;
932: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
933: p_data => x_msg_data
934: );
935: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 935: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

931: x_return_status := FND_API.G_RET_STS_ERROR ;
932: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
933: p_data => x_msg_data
934: );
935: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
936:
937: iby_debug_pub.add(debug_msg => 'In G_EXC_UNEXPECTED_ERROR Exception',
938: debug_level => FND_LOG.LEVEL_UNEXPECTED,
939: module => G_DEBUG_MODULE || l_module);

Line 940: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

936:
937: iby_debug_pub.add(debug_msg => 'In G_EXC_UNEXPECTED_ERROR Exception',
938: debug_level => FND_LOG.LEVEL_UNEXPECTED,
939: module => G_DEBUG_MODULE || l_module);
940: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
941: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
942: p_data => x_msg_data
943: );
944: WHEN OTHERS THEN

Line 952: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

948: module => G_DEBUG_MODULE || l_module);
949:
950: iby_fndcpt_common_pub.Clear_Msg_Stack(l_prev_msg_count);
951:
952: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
953: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
954: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_module, SUBSTR(SQLERRM,1,100));
955: END IF;
956:

Line 965: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

961:
962: PROCEDURE Get_Trxn_Appl_Pmt_Channels
963: (
964: p_api_version IN NUMBER,
965: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
966: x_return_status OUT NOCOPY VARCHAR2,
967: x_msg_count OUT NOCOPY NUMBER,
968: x_msg_data OUT NOCOPY VARCHAR2,
969: p_payer IN IBY_FNDCPT_COMMON_PUB.PayerContext_rec_type,

Line 1020: IF NOT FND_API.Compatible_API_Call (l_api_version,

1016: IF (c_trxn_channels%ISOPEN) THEN
1017: CLOSE c_trxn_channels;
1018: END IF;
1019:
1020: IF NOT FND_API.Compatible_API_Call (l_api_version,
1021: p_api_version,
1022: l_module,
1023: G_PKG_NAME)
1024: THEN

Line 1030: RAISE FND_API.G_EXC_ERROR;

1026: debug_level => FND_LOG.LEVEL_ERROR,
1027: module => G_DEBUG_MODULE || l_module);
1028: FND_MESSAGE.SET_NAME('IBY', 'IBY_204400_API_VER_MISMATCH');
1029: FND_MSG_PUB.Add;
1030: RAISE FND_API.G_EXC_ERROR;
1031: END IF;
1032:
1033: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1034: FND_MSG_PUB.initialize;

Line 1033: IF FND_API.to_Boolean( p_init_msg_list ) THEN

1029: FND_MSG_PUB.Add;
1030: RAISE FND_API.G_EXC_ERROR;
1031: END IF;
1032:
1033: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1034: FND_MSG_PUB.initialize;
1035: END IF;
1036: l_prev_msg_count := FND_MSG_PUB.Count_Msg;
1037:

Line 1038: Get_Payer_Id(p_payer,FND_API.G_VALID_LEVEL_FULL,

1034: FND_MSG_PUB.initialize;
1035: END IF;
1036: l_prev_msg_count := FND_MSG_PUB.Count_Msg;
1037:
1038: Get_Payer_Id(p_payer,FND_API.G_VALID_LEVEL_FULL,
1039: l_payer_level,l_payer_id,l_payer_attribs);
1040:
1041: IF (l_payer_level = IBY_FNDCPT_COMMON_PUB.G_RC_INVALID_PAYER) THEN
1042: x_response.Result_Code := IBY_FNDCPT_COMMON_PUB.G_RC_INVALID_PAYER;

Line 1063: WHEN FND_API.G_EXC_ERROR THEN

1059: (l_prev_msg_count,x_return_status,x_msg_count,x_msg_data,x_response);
1060:
1061: EXCEPTION
1062:
1063: WHEN FND_API.G_EXC_ERROR THEN
1064:
1065: iby_debug_pub.add(debug_msg => 'In G_EXC_ERROR Exception',
1066: debug_level => FND_LOG.LEVEL_ERROR,
1067: module => G_DEBUG_MODULE || l_module);

Line 1068: x_return_status := FND_API.G_RET_STS_ERROR ;

1064:
1065: iby_debug_pub.add(debug_msg => 'In G_EXC_ERROR Exception',
1066: debug_level => FND_LOG.LEVEL_ERROR,
1067: module => G_DEBUG_MODULE || l_module);
1068: x_return_status := FND_API.G_RET_STS_ERROR ;
1069: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
1070: p_data => x_msg_data
1071: );
1072: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1072: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1068: x_return_status := FND_API.G_RET_STS_ERROR ;
1069: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
1070: p_data => x_msg_data
1071: );
1072: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1073:
1074: iby_debug_pub.add(debug_msg => 'In G_EXC_UNEXPECTED_ERROR Exception',
1075: debug_level => FND_LOG.LEVEL_UNEXPECTED,
1076: module => G_DEBUG_MODULE || l_module);

Line 1077: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1073:
1074: iby_debug_pub.add(debug_msg => 'In G_EXC_UNEXPECTED_ERROR Exception',
1075: debug_level => FND_LOG.LEVEL_UNEXPECTED,
1076: module => G_DEBUG_MODULE || l_module);
1077: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1078: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
1079: p_data => x_msg_data
1080: );
1081: WHEN OTHERS THEN

Line 1089: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1085: module => G_DEBUG_MODULE || l_module);
1086:
1087: iby_fndcpt_common_pub.Clear_Msg_Stack(l_prev_msg_count);
1088:
1089: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1090: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1091: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_module, SUBSTR(SQLERRM,1,100));
1092: END IF;
1093:

Line 1103: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

1099:
1100: PROCEDURE Set_Payer_Instr_Assignment
1101: (
1102: p_api_version IN NUMBER,
1103: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1104: p_commit IN VARCHAR2 := FND_API.G_TRUE,
1105: x_return_status OUT NOCOPY VARCHAR2,
1106: x_msg_count OUT NOCOPY NUMBER,
1107: x_msg_data OUT NOCOPY VARCHAR2,

Line 1104: p_commit IN VARCHAR2 := FND_API.G_TRUE,

1100: PROCEDURE Set_Payer_Instr_Assignment
1101: (
1102: p_api_version IN NUMBER,
1103: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1104: p_commit IN VARCHAR2 := FND_API.G_TRUE,
1105: x_return_status OUT NOCOPY VARCHAR2,
1106: x_msg_count OUT NOCOPY NUMBER,
1107: x_msg_data OUT NOCOPY VARCHAR2,
1108: p_payer IN IBY_FNDCPT_COMMON_PUB.PayerContext_rec_type,

Line 1197: IF NOT FND_API.Compatible_API_Call (l_api_version,

1193:
1194:
1195: IF (c_instr_assignment%ISOPEN) THEN CLOSE c_instr_assignment; END IF;
1196:
1197: IF NOT FND_API.Compatible_API_Call (l_api_version,
1198: p_api_version,
1199: l_module,
1200: G_PKG_NAME)
1201: THEN

Line 1207: RAISE FND_API.G_EXC_ERROR;

1203: debug_level => FND_LOG.LEVEL_ERROR,
1204: module => G_DEBUG_MODULE || l_module);
1205: FND_MESSAGE.SET_NAME('IBY', 'IBY_204400_API_VER_MISMATCH');
1206: FND_MSG_PUB.Add;
1207: RAISE FND_API.G_EXC_ERROR;
1208: END IF;
1209:
1210: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1211: FND_MSG_PUB.initialize;

Line 1210: IF FND_API.to_Boolean( p_init_msg_list ) THEN

1206: FND_MSG_PUB.Add;
1207: RAISE FND_API.G_EXC_ERROR;
1208: END IF;
1209:
1210: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1211: FND_MSG_PUB.initialize;
1212: END IF;
1213: l_prev_msg_count := FND_MSG_PUB.Count_Msg;
1214:

Line 1230: Get_Payer_Id(p_payer,FND_API.G_VALID_LEVEL_FULL,

1226: RETURN;
1227: END IF;
1228: END IF;
1229:
1230: Get_Payer_Id(p_payer,FND_API.G_VALID_LEVEL_FULL,
1231: l_payer_level,l_payer_id,l_payer_attribs);
1232:
1233: iby_debug_pub.add('l_payer_id = '|| l_payer_id,iby_debug_pub.G_LEVEL_PROCEDURE,l_dbg_mod);
1234:

Line 1253: FND_API.G_FALSE,

1249: IF (l_payer_id IS NULL) THEN
1250: IBY_FNDCPT_SETUP_PUB.Set_Payer_Attributes
1251: (
1252: 1.0,
1253: FND_API.G_FALSE,
1254: FND_API.G_FALSE,
1255: x_return_status,
1256: x_msg_count,
1257: x_msg_data,

Line 1254: FND_API.G_FALSE,

1250: IBY_FNDCPT_SETUP_PUB.Set_Payer_Attributes
1251: (
1252: 1.0,
1253: FND_API.G_FALSE,
1254: FND_API.G_FALSE,
1255: x_return_status,
1256: x_msg_count,
1257: x_msg_data,
1258: p_payer,

Line 1426: (p_init_msg_list => fnd_api.g_false,

1422: SELECT party_type INTO l_party_type
1423: FROM hz_parties WHERE party_id = p_payer.Party_Id;
1424:
1425: HZ_BES_BO_TRACKING_PVT.Create_Bot
1426: (p_init_msg_list => fnd_api.g_false,
1427: p_child_bo_code => NULL,
1428: p_child_tbl_name => 'IBY_FNDCPT_PAYER_ASSGN_INSTR_V',
1429: p_child_id => x_assign_id,
1430: p_child_opr_flag => l_op_type,

Line 1448: IF FND_API.To_Boolean(p_commit) THEN

1444:
1445: x_response.Result_Code := IBY_FNDCPT_COMMON_PUB.G_RC_SUCCESS;
1446: END IF;
1447:
1448: IF FND_API.To_Boolean(p_commit) THEN
1449: COMMIT;
1450: END IF;
1451:
1452: iby_fndcpt_common_pub.Prepare_Result

Line 1458: WHEN FND_API.G_EXC_ERROR THEN

1454:
1455: iby_debug_pub.add('Exit',iby_debug_pub.G_LEVEL_PROCEDURE,l_dbg_mod);
1456: EXCEPTION
1457:
1458: WHEN FND_API.G_EXC_ERROR THEN
1459: ROLLBACK TO Set_Payer_Instr_Assignment;
1460: iby_debug_pub.add(debug_msg => 'In G_EXC_ERROR Exception',
1461: debug_level => FND_LOG.LEVEL_ERROR,
1462: module => G_DEBUG_MODULE || l_module);

Line 1463: x_return_status := FND_API.G_RET_STS_ERROR ;

1459: ROLLBACK TO Set_Payer_Instr_Assignment;
1460: iby_debug_pub.add(debug_msg => 'In G_EXC_ERROR Exception',
1461: debug_level => FND_LOG.LEVEL_ERROR,
1462: module => G_DEBUG_MODULE || l_module);
1463: x_return_status := FND_API.G_RET_STS_ERROR ;
1464: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
1465: p_data => x_msg_data
1466: );
1467: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1467: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1463: x_return_status := FND_API.G_RET_STS_ERROR ;
1464: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
1465: p_data => x_msg_data
1466: );
1467: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1468: ROLLBACK TO Set_Payer_Instr_Assignment;
1469: iby_debug_pub.add(debug_msg => 'In G_EXC_UNEXPECTED_ERROR Exception',
1470: debug_level => FND_LOG.LEVEL_UNEXPECTED,
1471: module => G_DEBUG_MODULE || l_module);

Line 1472: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1468: ROLLBACK TO Set_Payer_Instr_Assignment;
1469: iby_debug_pub.add(debug_msg => 'In G_EXC_UNEXPECTED_ERROR Exception',
1470: debug_level => FND_LOG.LEVEL_UNEXPECTED,
1471: module => G_DEBUG_MODULE || l_module);
1472: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1473: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
1474: p_data => x_msg_data
1475: );
1476: WHEN OTHERS THEN

Line 1484: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1480: module => G_DEBUG_MODULE || l_module);
1481:
1482: iby_fndcpt_common_pub.Clear_Msg_Stack(l_prev_msg_count);
1483:
1484: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1485: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1486: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_module, SUBSTR(SQLERRM,1,100));
1487: END IF;
1488:

Line 1498: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

1494:
1495: PROCEDURE Get_Payer_Instr_Assignments
1496: (
1497: p_api_version IN NUMBER,
1498: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1499: x_return_status OUT NOCOPY VARCHAR2,
1500: x_msg_count OUT NOCOPY NUMBER,
1501: x_msg_data OUT NOCOPY VARCHAR2,
1502: p_payer IN IBY_FNDCPT_COMMON_PUB.PayerContext_rec_type,

Line 1530: IF NOT FND_API.Compatible_API_Call (l_api_version,

1526: IF (c_instr_assignments%ISOPEN) THEN
1527: CLOSE c_instr_assignments;
1528: END IF;
1529:
1530: IF NOT FND_API.Compatible_API_Call (l_api_version,
1531: p_api_version,
1532: l_module,
1533: G_PKG_NAME)
1534: THEN

Line 1540: RAISE FND_API.G_EXC_ERROR;

1536: debug_level => FND_LOG.LEVEL_ERROR,
1537: module => G_DEBUG_MODULE || l_module);
1538: FND_MESSAGE.SET_NAME('IBY', 'IBY_204400_API_VER_MISMATCH');
1539: FND_MSG_PUB.Add;
1540: RAISE FND_API.G_EXC_ERROR;
1541: END IF;
1542:
1543: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1544: FND_MSG_PUB.initialize;

Line 1543: IF FND_API.to_Boolean( p_init_msg_list ) THEN

1539: FND_MSG_PUB.Add;
1540: RAISE FND_API.G_EXC_ERROR;
1541: END IF;
1542:
1543: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1544: FND_MSG_PUB.initialize;
1545: END IF;
1546: l_prev_msg_count := FND_MSG_PUB.Count_Msg;
1547:

Line 1548: Get_Payer_Id(p_payer,FND_API.G_VALID_LEVEL_FULL,

1544: FND_MSG_PUB.initialize;
1545: END IF;
1546: l_prev_msg_count := FND_MSG_PUB.Count_Msg;
1547:
1548: Get_Payer_Id(p_payer,FND_API.G_VALID_LEVEL_FULL,
1549: l_payer_level,l_payer_id,l_payer_attribs);
1550:
1551: IF (l_payer_level = IBY_FNDCPT_COMMON_PUB.G_RC_INVALID_PAYER) THEN
1552: x_response.Result_Code := IBY_FNDCPT_COMMON_PUB.G_RC_INVALID_PAYER;

Line 1578: WHEN FND_API.G_EXC_ERROR THEN

1574: (l_prev_msg_count,x_return_status,x_msg_count,x_msg_data,x_response);
1575:
1576: EXCEPTION
1577:
1578: WHEN FND_API.G_EXC_ERROR THEN
1579:
1580: iby_debug_pub.add(debug_msg => 'In G_EXC_ERROR Exception',
1581: debug_level => FND_LOG.LEVEL_ERROR,
1582: module => G_DEBUG_MODULE || l_module);

Line 1583: x_return_status := FND_API.G_RET_STS_ERROR ;

1579:
1580: iby_debug_pub.add(debug_msg => 'In G_EXC_ERROR Exception',
1581: debug_level => FND_LOG.LEVEL_ERROR,
1582: module => G_DEBUG_MODULE || l_module);
1583: x_return_status := FND_API.G_RET_STS_ERROR ;
1584: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
1585: p_data => x_msg_data
1586: );
1587: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1587: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1583: x_return_status := FND_API.G_RET_STS_ERROR ;
1584: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
1585: p_data => x_msg_data
1586: );
1587: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1588:
1589: iby_debug_pub.add(debug_msg => 'In G_EXC_UNEXPECTED_ERROR Exception',
1590: debug_level => FND_LOG.LEVEL_UNEXPECTED,
1591: module => G_DEBUG_MODULE || l_module);

Line 1592: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1588:
1589: iby_debug_pub.add(debug_msg => 'In G_EXC_UNEXPECTED_ERROR Exception',
1590: debug_level => FND_LOG.LEVEL_UNEXPECTED,
1591: module => G_DEBUG_MODULE || l_module);
1592: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1593: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
1594: p_data => x_msg_data
1595: );
1596: WHEN OTHERS THEN

Line 1604: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1600: module => G_DEBUG_MODULE || l_module);
1601:
1602: iby_fndcpt_common_pub.Clear_Msg_Stack(l_prev_msg_count);
1603:
1604: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1605: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1606: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_module, SUBSTR(SQLERRM,1,100));
1607: END IF;
1608:

Line 1618: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

1614:
1615: PROCEDURE Get_Payer_All_Instruments
1616: (
1617: p_api_version IN NUMBER,
1618: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1619: x_return_status OUT NOCOPY VARCHAR2,
1620: x_msg_count OUT NOCOPY NUMBER,
1621: x_msg_data OUT NOCOPY VARCHAR2,
1622: p_party_id IN NUMBER,

Line 1648: IF NOT FND_API.Compatible_API_Call (l_api_version,

1644: IF (c_instr_assignments%ISOPEN) THEN
1645: CLOSE c_instr_assignments;
1646: END IF;
1647:
1648: IF NOT FND_API.Compatible_API_Call (l_api_version,
1649: p_api_version,
1650: l_module,
1651: G_PKG_NAME)
1652: THEN

Line 1658: RAISE FND_API.G_EXC_ERROR;

1654: debug_level => FND_LOG.LEVEL_ERROR,
1655: module => G_DEBUG_MODULE || l_module);
1656: FND_MESSAGE.SET_NAME('IBY', 'IBY_204400_API_VER_MISMATCH');
1657: FND_MSG_PUB.Add;
1658: RAISE FND_API.G_EXC_ERROR;
1659: END IF;
1660:
1661: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1662: FND_MSG_PUB.initialize;

Line 1661: IF FND_API.to_Boolean( p_init_msg_list ) THEN

1657: FND_MSG_PUB.Add;
1658: RAISE FND_API.G_EXC_ERROR;
1659: END IF;
1660:
1661: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1662: FND_MSG_PUB.initialize;
1663: END IF;
1664: l_prev_msg_count := FND_MSG_PUB.Count_Msg;
1665:

Line 1683: WHEN FND_API.G_EXC_ERROR THEN

1679: (l_prev_msg_count,x_return_status,x_msg_count,x_msg_data,x_response);
1680:
1681: EXCEPTION
1682:
1683: WHEN FND_API.G_EXC_ERROR THEN
1684:
1685: iby_debug_pub.add(debug_msg => 'In G_EXC_ERROR Exception',
1686: debug_level => FND_LOG.LEVEL_ERROR,
1687: module => G_DEBUG_MODULE || l_module);

Line 1688: x_return_status := FND_API.G_RET_STS_ERROR ;

1684:
1685: iby_debug_pub.add(debug_msg => 'In G_EXC_ERROR Exception',
1686: debug_level => FND_LOG.LEVEL_ERROR,
1687: module => G_DEBUG_MODULE || l_module);
1688: x_return_status := FND_API.G_RET_STS_ERROR ;
1689: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
1690: p_data => x_msg_data
1691: );
1692: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1692: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1688: x_return_status := FND_API.G_RET_STS_ERROR ;
1689: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
1690: p_data => x_msg_data
1691: );
1692: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1693:
1694: iby_debug_pub.add(debug_msg => 'In G_EXC_UNEXPECTED_ERROR Exception',
1695: debug_level => FND_LOG.LEVEL_UNEXPECTED,
1696: module => G_DEBUG_MODULE || l_module);

Line 1697: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1693:
1694: iby_debug_pub.add(debug_msg => 'In G_EXC_UNEXPECTED_ERROR Exception',
1695: debug_level => FND_LOG.LEVEL_UNEXPECTED,
1696: module => G_DEBUG_MODULE || l_module);
1697: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1698: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
1699: p_data => x_msg_data
1700: );
1701: WHEN OTHERS THEN

Line 1709: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1705: module => G_DEBUG_MODULE || l_module);
1706:
1707: iby_fndcpt_common_pub.Clear_Msg_Stack(l_prev_msg_count);
1708:
1709: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1710: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1711: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_module, SUBSTR(SQLERRM,1,100));
1712: END IF;
1713:

Line 1730: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

1726:
1727: PROCEDURE Get_Trxn_Appl_Instr_Assign
1728: (
1729: p_api_version IN NUMBER,
1730: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1731: x_return_status OUT NOCOPY VARCHAR2,
1732: x_msg_count OUT NOCOPY NUMBER,
1733: x_msg_data OUT NOCOPY VARCHAR2,
1734: p_payer IN IBY_FNDCPT_COMMON_PUB.PayerContext_rec_type,

Line 1821: IF NOT FND_API.Compatible_API_Call (l_api_version,

1817: IF (c_instr_assigns%ISOPEN) THEN
1818: CLOSE c_instr_assigns;
1819: END IF;
1820:
1821: IF NOT FND_API.Compatible_API_Call (l_api_version,
1822: p_api_version,
1823: l_module,
1824: G_PKG_NAME)
1825: THEN

Line 1831: RAISE FND_API.G_EXC_ERROR;

1827: debug_level => FND_LOG.LEVEL_ERROR,
1828: module => G_DEBUG_MODULE || l_module);
1829: FND_MESSAGE.SET_NAME('IBY', 'IBY_204400_API_VER_MISMATCH');
1830: FND_MSG_PUB.Add;
1831: RAISE FND_API.G_EXC_ERROR;
1832: END IF;
1833:
1834: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1835: FND_MSG_PUB.initialize;

Line 1834: IF FND_API.to_Boolean( p_init_msg_list ) THEN

1830: FND_MSG_PUB.Add;
1831: RAISE FND_API.G_EXC_ERROR;
1832: END IF;
1833:
1834: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1835: FND_MSG_PUB.initialize;
1836: END IF;
1837: l_prev_msg_count := FND_MSG_PUB.Count_Msg;
1838:

Line 1839: Get_Payer_Id(p_payer,FND_API.G_VALID_LEVEL_FULL,

1835: FND_MSG_PUB.initialize;
1836: END IF;
1837: l_prev_msg_count := FND_MSG_PUB.Count_Msg;
1838:
1839: Get_Payer_Id(p_payer,FND_API.G_VALID_LEVEL_FULL,
1840: l_payer_level,l_payer_id,l_payer_attribs);
1841:
1842: IF (l_payer_level = IBY_FNDCPT_COMMON_PUB.G_RC_INVALID_PAYER) THEN
1843: x_response.Result_Code := IBY_FNDCPT_COMMON_PUB.G_RC_INVALID_PAYER;

Line 1867: WHEN FND_API.G_EXC_ERROR THEN

1863: (l_prev_msg_count,x_return_status,x_msg_count,x_msg_data,x_response);
1864:
1865: EXCEPTION
1866:
1867: WHEN FND_API.G_EXC_ERROR THEN
1868:
1869: iby_debug_pub.add(debug_msg => 'In G_EXC_ERROR Exception',
1870: debug_level => FND_LOG.LEVEL_ERROR,
1871: module => G_DEBUG_MODULE || l_module);

Line 1872: x_return_status := FND_API.G_RET_STS_ERROR ;

1868:
1869: iby_debug_pub.add(debug_msg => 'In G_EXC_ERROR Exception',
1870: debug_level => FND_LOG.LEVEL_ERROR,
1871: module => G_DEBUG_MODULE || l_module);
1872: x_return_status := FND_API.G_RET_STS_ERROR ;
1873: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
1874: p_data => x_msg_data
1875: );
1876: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1876: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1872: x_return_status := FND_API.G_RET_STS_ERROR ;
1873: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
1874: p_data => x_msg_data
1875: );
1876: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1877:
1878: iby_debug_pub.add(debug_msg => 'In G_EXC_UNEXPECTED_ERROR Exception',
1879: debug_level => FND_LOG.LEVEL_UNEXPECTED,
1880: module => G_DEBUG_MODULE || l_module);

Line 1881: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1877:
1878: iby_debug_pub.add(debug_msg => 'In G_EXC_UNEXPECTED_ERROR Exception',
1879: debug_level => FND_LOG.LEVEL_UNEXPECTED,
1880: module => G_DEBUG_MODULE || l_module);
1881: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1882: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
1883: p_data => x_msg_data
1884: );
1885: WHEN OTHERS THEN

Line 1893: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1889: module => G_DEBUG_MODULE || l_module);
1890:
1891: iby_fndcpt_common_pub.Clear_Msg_Stack(l_prev_msg_count);
1892:
1893: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1894: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1895: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_module, SUBSTR(SQLERRM,1,100));
1896: END IF;
1897:

Line 2029: FND_API.G_FALSE,

2025:
2026:
2027: -- call Create_Card
2028: Create_Card(1.0,
2029: FND_API.G_FALSE,
2030: p_commit,
2031: x_return_status,
2032: x_msg_count,
2033: x_msg_data,

Line 2046: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

2042:
2043: PROCEDURE Create_Card
2044: (
2045: p_api_version IN NUMBER,
2046: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2047: p_commit IN VARCHAR2 := FND_API.G_TRUE,
2048: x_return_status OUT NOCOPY VARCHAR2,
2049: x_msg_count OUT NOCOPY NUMBER,
2050: x_msg_data OUT NOCOPY VARCHAR2,

Line 2047: p_commit IN VARCHAR2 := FND_API.G_TRUE,

2043: PROCEDURE Create_Card
2044: (
2045: p_api_version IN NUMBER,
2046: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2047: p_commit IN VARCHAR2 := FND_API.G_TRUE,
2048: x_return_status OUT NOCOPY VARCHAR2,
2049: x_msg_count OUT NOCOPY NUMBER,
2050: x_msg_data OUT NOCOPY VARCHAR2,
2051: p_card_instrument IN CreditCard_rec_type,

Line 2082: IF NOT FND_API.Compatible_API_Call (l_api_version,

2078:
2079: BEGIN
2080: iby_debug_pub.add('Enter',iby_debug_pub.G_LEVEL_PROCEDURE,l_dbg_mod);
2081:
2082: IF NOT FND_API.Compatible_API_Call (l_api_version,
2083: p_api_version,
2084: l_module,
2085: G_PKG_NAME)
2086: THEN

Line 2092: RAISE FND_API.G_EXC_ERROR;

2088: debug_level => FND_LOG.LEVEL_ERROR,
2089: module => G_DEBUG_MODULE || l_module);
2090: FND_MESSAGE.SET_NAME('IBY', 'IBY_204400_API_VER_MISMATCH');
2091: FND_MSG_PUB.Add;
2092: RAISE FND_API.G_EXC_ERROR;
2093: END IF;
2094:
2095: IF (c_sec_mode%ISOPEN) THEN CLOSE c_sec_mode; END IF;
2096:

Line 2097: IF FND_API.to_Boolean( p_init_msg_list ) THEN

2093: END IF;
2094:
2095: IF (c_sec_mode%ISOPEN) THEN CLOSE c_sec_mode; END IF;
2096:
2097: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2098: FND_MSG_PUB.initialize;
2099: END IF;
2100: l_prev_msg_count := FND_MSG_PUB.Count_Msg;
2101:

Line 2107: FND_API.G_FALSE,

2103:
2104: IBY_FNDCPT_SETUP_PUB.Card_Exists
2105: (
2106: 1.0,
2107: FND_API.G_FALSE,
2108: x_return_status,
2109: x_msg_count,
2110: x_msg_data,
2111: p_card_instrument.Owner_Id,

Line 2127: IF (NOT Validate_CC_Billing(FND_API.G_FALSE,p_card_instrument)) THEN

2123: iby_debug_pub.add('p_card_instrument.Register_Invalid_Card: '|| p_card_instrument.Register_Invalid_Card,
2124: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
2125:
2126: -- validate billing address information
2127: IF (NOT Validate_CC_Billing(FND_API.G_FALSE,p_card_instrument)) THEN
2128: x_response.Result_Code := iby_creditcard_pkg.G_RC_INVALID_ADDRESS;
2129: iby_fndcpt_common_pub.Prepare_Result
2130: (l_prev_msg_count,x_return_status,x_msg_count,x_msg_data,x_response);
2131: RETURN;

Line 2146: IF (p_card_instrument.Billing_Address_Id = FND_API.G_MISS_NUM ) THEN

2142: IF (p_card_instrument.Address_Type = IBY_CREDITCARD_PKG.G_PARTY_SITE_USE_ID) AND
2143: (NOT (p_card_instrument.Billing_Address_Id IS NULL)) THEN
2144: l_billing_site := p_card_instrument.Billing_Address_Id;
2145: ELSE
2146: IF (p_card_instrument.Billing_Address_Id = FND_API.G_MISS_NUM ) THEN
2147: l_billing_site := FND_API.G_MISS_NUM;
2148: ELSIF (NOT (p_card_instrument.Billing_Address_Id IS NULL)) THEN
2149: l_billing_site :=
2150: IBY_CREDITCARD_PKG.Get_Billing_Site(p_card_instrument.Billing_Address_Id,

Line 2147: l_billing_site := FND_API.G_MISS_NUM;

2143: (NOT (p_card_instrument.Billing_Address_Id IS NULL)) THEN
2144: l_billing_site := p_card_instrument.Billing_Address_Id;
2145: ELSE
2146: IF (p_card_instrument.Billing_Address_Id = FND_API.G_MISS_NUM ) THEN
2147: l_billing_site := FND_API.G_MISS_NUM;
2148: ELSIF (NOT (p_card_instrument.Billing_Address_Id IS NULL)) THEN
2149: l_billing_site :=
2150: IBY_CREDITCARD_PKG.Get_Billing_Site(p_card_instrument.Billing_Address_Id,
2151: p_card_instrument.Owner_Id);

Line 2166: OR (p_card_instrument.Billing_Address_Territory = FND_API.G_MISS_CHAR) )

2162: iby_debug_pub.add('l_billing_site = '||l_billing_site,
2163: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
2164:
2165: IF (NOT ( (p_card_instrument.Billing_Address_Territory IS NULL)
2166: OR (p_card_instrument.Billing_Address_Territory = FND_API.G_MISS_CHAR) )
2167: )
2168: THEN
2169: IF (NOT iby_utility_pvt.Validate_Territory(p_card_instrument.Billing_Address_Territory)) THEN
2170: x_response.Result_Code := IBY_CREDITCARD_PKG.G_RC_INVALID_ADDRESS;

Line 2231: (1.0, FND_API.G_FALSE, FND_API.G_FALSE, FND_API.G_VALID_LEVEL_FULL,

2227: iby_debug_pub.add('before calling OraInstrAdd',
2228: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
2229:
2230: IBY_INSTRREG_PUB.OraInstrAdd
2231: (1.0, FND_API.G_FALSE, FND_API.G_FALSE, FND_API.G_VALID_LEVEL_FULL,
2232: l_instr_reg, x_return_status, x_msg_count, x_msg_data,
2233: x_card_id, lx_result
2234: );
2235:

Line 2238: --OR (x_return_status <> FND_API.G_RET_STS_ERROR))

2234: );
2235:
2236: -- should not be a validation error at this point
2237: IF ((NVL(x_card_id,-1)<0))
2238: --OR (x_return_status <> FND_API.G_RET_STS_ERROR))
2239: THEN
2240: iby_debug_pub.add('instrument reg failed',
2241: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
2242: iby_debug_pub.add('result code:=' || lx_result.Result_Code,

Line 2265: (FND_API.G_FALSE,

2261: iby_debug_pub.add('database registration',
2262: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
2263:
2264: iby_creditcard_pkg.Create_Card
2265: (FND_API.G_FALSE,
2266: p_card_instrument.Owner_Id, p_card_instrument.Card_Holder_Name,
2267: l_billing_site,
2268: p_card_instrument.Address_Type,
2269: p_card_instrument.Billing_Postal_Code,

Line 2325: IF (NOT Validate_CC_Billing(FND_API.G_TRUE,p_card_instrument)) THEN

2321: l_info_only := p_card_instrument.Info_Only_Flag;
2322: END IF;
2323:
2324: -- validate billing address information
2325: IF (NOT Validate_CC_Billing(FND_API.G_TRUE,p_card_instrument)) THEN
2326: x_response.Result_Code := iby_creditcard_pkg.G_RC_INVALID_ADDRESS;
2327: iby_fndcpt_common_pub.Prepare_Result
2328: (l_prev_msg_count,x_return_status,x_msg_count,x_msg_data,x_response);
2329: RETURN;

Line 2341: (FND_API.G_FALSE, lx_card_rec.Card_Id, p_card_instrument.Owner_Id,

2337: RETURN;
2338: END IF;
2339:
2340: iby_creditcard_pkg.Update_Card
2341: (FND_API.G_FALSE, lx_card_rec.Card_Id, p_card_instrument.Owner_Id,
2342: p_card_instrument.Card_Holder_Name,
2343: p_card_instrument.Billing_Address_Id,
2344: p_card_instrument.Address_Type,
2345: p_card_instrument.Billing_Postal_Code,

Line 2352: NVL(p_card_instrument.Inactive_Date,FND_API.G_MISS_DATE),

2348: p_card_instrument.PurchaseCard_Flag, p_card_instrument.PurchaseCard_SubType,
2349: p_card_instrument.FI_Name, p_card_instrument.Single_Use_Flag,
2350: l_info_only, p_card_instrument.Card_Purpose,
2351: p_card_instrument.Card_Description, p_card_instrument.Active_Flag,
2352: NVL(p_card_instrument.Inactive_Date,FND_API.G_MISS_DATE),
2353: p_card_instrument.attribute_category,
2354: p_card_instrument.attribute1, p_card_instrument.attribute2,
2355: p_card_instrument.attribute3, p_card_instrument.attribute4,
2356: p_card_instrument.attribute5, p_card_instrument.attribute6,

Line 2378: IF FND_API.To_Boolean(p_commit) THEN

2374: x_response.Result_Code := NVL(lx_result_code,IBY_FNDCPT_COMMON_PUB.G_RC_SUCCESS);
2375: iby_fndcpt_common_pub.Prepare_Result
2376: (l_prev_msg_count,x_return_status,x_msg_count,x_msg_data,x_response);
2377:
2378: IF FND_API.To_Boolean(p_commit) THEN
2379: COMMIT;
2380: END IF;
2381:
2382: EXCEPTION

Line 2384: WHEN FND_API.G_EXC_ERROR THEN

2380: END IF;
2381:
2382: EXCEPTION
2383:
2384: WHEN FND_API.G_EXC_ERROR THEN
2385: ROLLBACK TO Create_Card;
2386: iby_debug_pub.add(debug_msg => 'In G_EXC_ERROR Exception',
2387: debug_level => FND_LOG.LEVEL_ERROR,
2388: module => G_DEBUG_MODULE || l_module);

Line 2389: x_return_status := FND_API.G_RET_STS_ERROR ;

2385: ROLLBACK TO Create_Card;
2386: iby_debug_pub.add(debug_msg => 'In G_EXC_ERROR Exception',
2387: debug_level => FND_LOG.LEVEL_ERROR,
2388: module => G_DEBUG_MODULE || l_module);
2389: x_return_status := FND_API.G_RET_STS_ERROR ;
2390: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
2391: p_data => x_msg_data
2392: );
2393: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2393: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2389: x_return_status := FND_API.G_RET_STS_ERROR ;
2390: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
2391: p_data => x_msg_data
2392: );
2393: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2394: --ROLLBACK TO Create_Card;
2395: iby_debug_pub.add(debug_msg => 'In G_EXC_UNEXPECTED_ERROR Exception',
2396: debug_level => FND_LOG.LEVEL_UNEXPECTED,
2397: module => G_DEBUG_MODULE || l_module);

Line 2398: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2394: --ROLLBACK TO Create_Card;
2395: iby_debug_pub.add(debug_msg => 'In G_EXC_UNEXPECTED_ERROR Exception',
2396: debug_level => FND_LOG.LEVEL_UNEXPECTED,
2397: module => G_DEBUG_MODULE || l_module);
2398: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2399: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
2400: p_data => x_msg_data
2401: );
2402: WHEN OTHERS THEN

Line 2410: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2406: module => G_DEBUG_MODULE || l_module);
2407:
2408: iby_fndcpt_common_pub.Clear_Msg_Stack(l_prev_msg_count);
2409:
2410: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2411: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2412: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_module, SUBSTR(SQLERRM,1,100));
2413: END IF;
2414:

Line 2543: FND_API.G_FALSE,

2539:
2540:
2541: -- call Update_Card
2542: Update_Card(1.0,
2543: FND_API.G_FALSE,
2544: p_commit,
2545: x_return_status,
2546: x_msg_count,
2547: x_msg_data,

Line 2558: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

2554:
2555: PROCEDURE Update_Card
2556: (
2557: p_api_version IN NUMBER,
2558: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2559: p_commit IN VARCHAR2 := FND_API.G_TRUE,
2560: x_return_status OUT NOCOPY VARCHAR2,
2561: x_msg_count OUT NOCOPY NUMBER,
2562: x_msg_data OUT NOCOPY VARCHAR2,

Line 2559: p_commit IN VARCHAR2 := FND_API.G_TRUE,

2555: PROCEDURE Update_Card
2556: (
2557: p_api_version IN NUMBER,
2558: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2559: p_commit IN VARCHAR2 := FND_API.G_TRUE,
2560: x_return_status OUT NOCOPY VARCHAR2,
2561: x_msg_count OUT NOCOPY NUMBER,
2562: x_msg_data OUT NOCOPY VARCHAR2,
2563: p_card_instrument IN CreditCard_rec_type,

Line 2577: IF NOT FND_API.Compatible_API_Call (l_api_version,

2573:
2574: l_info_only iby_creditcard.information_only_flag%TYPE := NULL;
2575:
2576: BEGIN
2577: IF NOT FND_API.Compatible_API_Call (l_api_version,
2578: p_api_version,
2579: l_module,
2580: G_PKG_NAME)
2581: THEN

Line 2587: RAISE FND_API.G_EXC_ERROR;

2583: debug_level => FND_LOG.LEVEL_ERROR,
2584: module => G_DEBUG_MODULE || l_module);
2585: FND_MESSAGE.SET_NAME('IBY', 'IBY_204400_API_VER_MISMATCH');
2586: FND_MSG_PUB.Add;
2587: RAISE FND_API.G_EXC_ERROR;
2588: END IF;
2589:
2590: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2591: FND_MSG_PUB.initialize;

Line 2590: IF FND_API.to_Boolean( p_init_msg_list ) THEN

2586: FND_MSG_PUB.Add;
2587: RAISE FND_API.G_EXC_ERROR;
2588: END IF;
2589:
2590: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2591: FND_MSG_PUB.initialize;
2592: END IF;
2593: l_prev_msg_count := FND_MSG_PUB.Count_Msg;
2594:

Line 2602: IF (NOT Validate_CC_Billing(FND_API.G_TRUE,p_card_instrument)) THEN

2598: IF (NOT p_card_instrument.Info_Only_Flag = 'Y') THEN
2599: l_info_only := p_card_instrument.Info_Only_Flag;
2600: END IF;
2601: -- validate billing address information
2602: IF (NOT Validate_CC_Billing(FND_API.G_TRUE,p_card_instrument)) THEN
2603: x_response.Result_Code := iby_creditcard_pkg.G_RC_INVALID_ADDRESS;
2604: iby_fndcpt_common_pub.Prepare_Result
2605: (l_prev_msg_count,x_return_status,x_msg_count,x_msg_data,x_response);
2606: RETURN;

Line 2610: (FND_API.G_FALSE, p_card_instrument.Card_Id, p_card_instrument.Owner_Id,

2606: RETURN;
2607: END IF;
2608:
2609: iby_creditcard_pkg.Update_Card
2610: (FND_API.G_FALSE, p_card_instrument.Card_Id, p_card_instrument.Owner_Id,
2611: p_card_instrument.Card_Holder_Name,
2612: p_card_instrument.Billing_Address_Id,
2613: p_card_instrument.Address_Type,
2614: p_card_instrument.Billing_Postal_Code,

Line 2647: IF FND_API.To_Boolean(p_commit) THEN

2643: NVL(lx_result_code,IBY_FNDCPT_COMMON_PUB.G_RC_SUCCESS);
2644: iby_fndcpt_common_pub.Prepare_Result
2645: (l_prev_msg_count,x_return_status,x_msg_count,x_msg_data,x_response);
2646:
2647: IF FND_API.To_Boolean(p_commit) THEN
2648: COMMIT;
2649: END IF;
2650:
2651: EXCEPTION

Line 2653: WHEN FND_API.G_EXC_ERROR THEN

2649: END IF;
2650:
2651: EXCEPTION
2652:
2653: WHEN FND_API.G_EXC_ERROR THEN
2654: ROLLBACK TO Update_Card;
2655: iby_debug_pub.add(debug_msg => 'In G_EXC_ERROR Exception',
2656: debug_level => FND_LOG.LEVEL_ERROR,
2657: module => G_DEBUG_MODULE || l_module);

Line 2658: x_return_status := FND_API.G_RET_STS_ERROR ;

2654: ROLLBACK TO Update_Card;
2655: iby_debug_pub.add(debug_msg => 'In G_EXC_ERROR Exception',
2656: debug_level => FND_LOG.LEVEL_ERROR,
2657: module => G_DEBUG_MODULE || l_module);
2658: x_return_status := FND_API.G_RET_STS_ERROR ;
2659: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
2660: p_data => x_msg_data
2661: );
2662: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2662: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2658: x_return_status := FND_API.G_RET_STS_ERROR ;
2659: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
2660: p_data => x_msg_data
2661: );
2662: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2663: ROLLBACK TO Update_Card;
2664: iby_debug_pub.add(debug_msg => 'In G_EXC_UNEXPECTED_ERROR Exception',
2665: debug_level => FND_LOG.LEVEL_UNEXPECTED,
2666: module => G_DEBUG_MODULE || l_module);

Line 2667: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2663: ROLLBACK TO Update_Card;
2664: iby_debug_pub.add(debug_msg => 'In G_EXC_UNEXPECTED_ERROR Exception',
2665: debug_level => FND_LOG.LEVEL_UNEXPECTED,
2666: module => G_DEBUG_MODULE || l_module);
2667: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2668: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
2669: p_data => x_msg_data
2670: );
2671: WHEN OTHERS THEN

Line 2679: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2675: module => G_DEBUG_MODULE || l_module);
2676:
2677: iby_fndcpt_common_pub.Clear_Msg_Stack(l_prev_msg_count);
2678:
2679: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2680: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2681: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_module, SUBSTR(SQLERRM,1,100));
2682: END IF;
2683:

Line 2700: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

2696:
2697: PROCEDURE Get_Card
2698: (
2699: p_api_version IN NUMBER,
2700: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2701: x_return_status OUT NOCOPY VARCHAR2,
2702: x_msg_count OUT NOCOPY NUMBER,
2703: x_msg_data OUT NOCOPY VARCHAR2,
2704: p_card_id NUMBER,

Line 2728: IF NOT FND_API.Compatible_API_Call (l_api_version,

2724: IF (c_card%ISOPEN) THEN
2725: CLOSE c_card;
2726: END IF;
2727:
2728: IF NOT FND_API.Compatible_API_Call (l_api_version,
2729: p_api_version,
2730: l_module,
2731: G_PKG_NAME)
2732: THEN

Line 2738: RAISE FND_API.G_EXC_ERROR;

2734: debug_level => FND_LOG.LEVEL_ERROR,
2735: module => G_DEBUG_MODULE || l_module);
2736: FND_MESSAGE.SET_NAME('IBY', 'IBY_204400_API_VER_MISMATCH');
2737: FND_MSG_PUB.Add;
2738: RAISE FND_API.G_EXC_ERROR;
2739: END IF;
2740:
2741: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2742: FND_MSG_PUB.initialize;

Line 2741: IF FND_API.to_Boolean( p_init_msg_list ) THEN

2737: FND_MSG_PUB.Add;
2738: RAISE FND_API.G_EXC_ERROR;
2739: END IF;
2740:
2741: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2742: FND_MSG_PUB.initialize;
2743: END IF;
2744: l_prev_msg_count := FND_MSG_PUB.Count_Msg;
2745:

Line 2768: WHEN FND_API.G_EXC_ERROR THEN

2764: (l_prev_msg_count,x_return_status,x_msg_count,x_msg_data,x_response);
2765:
2766: EXCEPTION
2767:
2768: WHEN FND_API.G_EXC_ERROR THEN
2769:
2770: iby_debug_pub.add(debug_msg => 'In G_EXC_ERROR Exception',
2771: debug_level => FND_LOG.LEVEL_ERROR,
2772: module => G_DEBUG_MODULE || l_module);

Line 2773: x_return_status := FND_API.G_RET_STS_ERROR ;

2769:
2770: iby_debug_pub.add(debug_msg => 'In G_EXC_ERROR Exception',
2771: debug_level => FND_LOG.LEVEL_ERROR,
2772: module => G_DEBUG_MODULE || l_module);
2773: x_return_status := FND_API.G_RET_STS_ERROR ;
2774: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
2775: p_data => x_msg_data
2776: );
2777: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2777: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2773: x_return_status := FND_API.G_RET_STS_ERROR ;
2774: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
2775: p_data => x_msg_data
2776: );
2777: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2778:
2779: iby_debug_pub.add(debug_msg => 'In G_EXC_UNEXPECTED_ERROR Exception',
2780: debug_level => FND_LOG.LEVEL_UNEXPECTED,
2781: module => G_DEBUG_MODULE || l_module);

Line 2782: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2778:
2779: iby_debug_pub.add(debug_msg => 'In G_EXC_UNEXPECTED_ERROR Exception',
2780: debug_level => FND_LOG.LEVEL_UNEXPECTED,
2781: module => G_DEBUG_MODULE || l_module);
2782: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2783: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
2784: p_data => x_msg_data
2785: );
2786: WHEN OTHERS THEN

Line 2794: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2790: module => G_DEBUG_MODULE || l_module);
2791:
2792: iby_fndcpt_common_pub.Clear_Msg_Stack(l_prev_msg_count);
2793:
2794: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2795: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2796: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_module, SUBSTR(SQLERRM,1,100));
2797: END IF;
2798:

Line 2814: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

2810:
2811: PROCEDURE Card_Exists
2812: (
2813: p_api_version IN NUMBER,
2814: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2815: x_return_status OUT NOCOPY VARCHAR2,
2816: x_msg_count OUT NOCOPY NUMBER,
2817: x_msg_data OUT NOCOPY VARCHAR2,
2818: p_owner_id NUMBER,

Line 2858: IF NOT FND_API.Compatible_API_Call (l_api_version,

2854: IF (c_card%ISOPEN) THEN
2855: CLOSE c_card;
2856: END IF;
2857:
2858: IF NOT FND_API.Compatible_API_Call (l_api_version,
2859: p_api_version,
2860: l_module,
2861: G_PKG_NAME)
2862: THEN

Line 2868: RAISE FND_API.G_EXC_ERROR;

2864: debug_level => FND_LOG.LEVEL_ERROR,
2865: module => G_DEBUG_MODULE || l_module);
2866: FND_MESSAGE.SET_NAME('IBY', 'IBY_204400_API_VER_MISMATCH');
2867: FND_MSG_PUB.Add;
2868: RAISE FND_API.G_EXC_ERROR;
2869: END IF;
2870:
2871: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2872: FND_MSG_PUB.initialize;

Line 2871: IF FND_API.to_Boolean( p_init_msg_list ) THEN

2867: FND_MSG_PUB.Add;
2868: RAISE FND_API.G_EXC_ERROR;
2869: END IF;
2870:
2871: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2872: FND_MSG_PUB.initialize;
2873: END IF;
2874: l_prev_msg_count := FND_MSG_PUB.Count_Msg;
2875: IF (nvl(p_card_instr_type,IBY_FNDCPT_COMMON_PUB.G_INSTR_TYPE_CREDITCARD ) = IBY_FNDCPT_COMMON_PUB.G_INSTR_TYPE_PAYMENTCARD) THEN

Line 2880: (1.0, FND_API.G_FALSE, p_card_number,

2876: l_char_allowed := 'Y';
2877: END IF;
2878:
2879: iby_cc_validate.StripCC
2880: (1.0, FND_API.G_FALSE, p_card_number,
2881: lx_return_status, lx_msg_count, lx_msg_data, lx_cc_number
2882: );
2883:
2884: IF (lx_cc_number IS NULL) THEN

Line 2904: FND_API.G_FALSE,

2900: ELSE
2901: IBY_FNDCPT_SETUP_PUB.Get_Card
2902: (
2903: 1.0,
2904: FND_API.G_FALSE,
2905: x_return_status,
2906: x_msg_count,
2907: x_msg_data,
2908: l_card_id,

Line 2919: WHEN FND_API.G_EXC_ERROR THEN

2915: (l_prev_msg_count,x_return_status,x_msg_count,x_msg_data,x_response);
2916:
2917: EXCEPTION
2918:
2919: WHEN FND_API.G_EXC_ERROR THEN
2920:
2921: iby_debug_pub.add(debug_msg => 'In G_EXC_ERROR Exception',
2922: debug_level => FND_LOG.LEVEL_ERROR,
2923: module => G_DEBUG_MODULE || l_module);

Line 2924: x_return_status := FND_API.G_RET_STS_ERROR ;

2920:
2921: iby_debug_pub.add(debug_msg => 'In G_EXC_ERROR Exception',
2922: debug_level => FND_LOG.LEVEL_ERROR,
2923: module => G_DEBUG_MODULE || l_module);
2924: x_return_status := FND_API.G_RET_STS_ERROR ;
2925: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
2926: p_data => x_msg_data
2927: );
2928: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2928: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2924: x_return_status := FND_API.G_RET_STS_ERROR ;
2925: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
2926: p_data => x_msg_data
2927: );
2928: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2929:
2930: iby_debug_pub.add(debug_msg => 'In G_EXC_UNEXPECTED_ERROR Exception',
2931: debug_level => FND_LOG.LEVEL_UNEXPECTED,
2932: module => G_DEBUG_MODULE || l_module);

Line 2933: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2929:
2930: iby_debug_pub.add(debug_msg => 'In G_EXC_UNEXPECTED_ERROR Exception',
2931: debug_level => FND_LOG.LEVEL_UNEXPECTED,
2932: module => G_DEBUG_MODULE || l_module);
2933: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2934: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
2935: p_data => x_msg_data
2936: );
2937: WHEN OTHERS THEN

Line 2945: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2941: module => G_DEBUG_MODULE || l_module);
2942:
2943: iby_fndcpt_common_pub.Clear_Msg_Stack(l_prev_msg_count);
2944:
2945: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2946: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2947: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_module, SUBSTR(SQLERRM,1,100));
2948: END IF;
2949:

Line 2965: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

2961:
2962: PROCEDURE Process_Credit_Card
2963: (
2964: p_api_version IN NUMBER,
2965: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2966: p_commit IN VARCHAR2 := FND_API.G_TRUE,
2967: x_return_status OUT NOCOPY VARCHAR2,
2968: x_msg_count OUT NOCOPY NUMBER,
2969: x_msg_data OUT NOCOPY VARCHAR2,

Line 2966: p_commit IN VARCHAR2 := FND_API.G_TRUE,

2962: PROCEDURE Process_Credit_Card
2963: (
2964: p_api_version IN NUMBER,
2965: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2966: p_commit IN VARCHAR2 := FND_API.G_TRUE,
2967: x_return_status OUT NOCOPY VARCHAR2,
2968: x_msg_count OUT NOCOPY NUMBER,
2969: x_msg_data OUT NOCOPY VARCHAR2,
2970: p_payer IN IBY_FNDCPT_COMMON_PUB.PayerContext_rec_type,

Line 2993: IF NOT FND_API.Compatible_API_Call (l_api_version,

2989: l_dbg_mod VARCHAR2(100) := G_DEBUG_MODULE || '.' || l_module;
2990: BEGIN
2991: iby_debug_pub.add('Enter',iby_debug_pub.G_LEVEL_PROCEDURE,l_dbg_mod);
2992:
2993: IF NOT FND_API.Compatible_API_Call (l_api_version,
2994: p_api_version,
2995: l_module,
2996: G_PKG_NAME)
2997: THEN

Line 3003: RAISE FND_API.G_EXC_ERROR;

2999: debug_level => FND_LOG.LEVEL_ERROR,
3000: module => G_DEBUG_MODULE || l_module);
3001: FND_MESSAGE.SET_NAME('IBY', 'IBY_204400_API_VER_MISMATCH');
3002: FND_MSG_PUB.Add;
3003: RAISE FND_API.G_EXC_ERROR;
3004: END IF;
3005:
3006: IF FND_API.to_Boolean( p_init_msg_list ) THEN
3007: FND_MSG_PUB.initialize;

Line 3006: IF FND_API.to_Boolean( p_init_msg_list ) THEN

3002: FND_MSG_PUB.Add;
3003: RAISE FND_API.G_EXC_ERROR;
3004: END IF;
3005:
3006: IF FND_API.to_Boolean( p_init_msg_list ) THEN
3007: FND_MSG_PUB.initialize;
3008: END IF;
3009: l_prev_msg_count := FND_MSG_PUB.Count_Msg;
3010:

Line 3020: (1.0, FND_API.G_FALSE, FND_API.G_FALSE, lx_return_status, lx_msg_count,

3016:
3017: iby_debug_pub.add('create card',iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
3018:
3019: Create_Card
3020: (1.0, FND_API.G_FALSE, FND_API.G_FALSE, lx_return_status, lx_msg_count,
3021: lx_msg_data, p_credit_card,
3022: lx_assign_attribs.Instrument.Instrument_Id,
3023: lx_response
3024: );

Line 3035: (1.0, FND_API.G_FALSE, FND_API.G_FALSE, x_return_status, x_msg_count,

3031:
3032: lx_assign_attribs.Instrument.Instrument_Type :=
3033: IBY_FNDCPT_COMMON_PUB.G_INSTR_TYPE_CREDITCARD;
3034: Set_Payer_Instr_Assignment
3035: (1.0, FND_API.G_FALSE, FND_API.G_FALSE, x_return_status, x_msg_count,
3036: x_msg_data, p_payer, lx_assign_attribs, x_assign_id,
3037: x_response
3038: );
3039: END IF;

Line 3045: IF FND_API.To_Boolean(p_commit) THEN

3041: iby_fndcpt_common_pub.Prepare_Result
3042: (iby_fndcpt_common_pub.G_INTERFACE_CODE,x_response.Result_Message,
3043: l_prev_msg_count,x_return_status,x_msg_count,x_msg_data,x_response);
3044:
3045: IF FND_API.To_Boolean(p_commit) THEN
3046: COMMIT;
3047: END IF;
3048:
3049: EXCEPTION

Line 3051: WHEN FND_API.G_EXC_ERROR THEN

3047: END IF;
3048:
3049: EXCEPTION
3050:
3051: WHEN FND_API.G_EXC_ERROR THEN
3052: ROLLBACK TO Process_Credit_Card;
3053: iby_debug_pub.add(debug_msg => 'In G_EXC_ERROR Exception',
3054: debug_level => FND_LOG.LEVEL_ERROR,
3055: module => G_DEBUG_MODULE || l_module);

Line 3056: x_return_status := FND_API.G_RET_STS_ERROR ;

3052: ROLLBACK TO Process_Credit_Card;
3053: iby_debug_pub.add(debug_msg => 'In G_EXC_ERROR Exception',
3054: debug_level => FND_LOG.LEVEL_ERROR,
3055: module => G_DEBUG_MODULE || l_module);
3056: x_return_status := FND_API.G_RET_STS_ERROR ;
3057: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
3058: p_data => x_msg_data
3059: );
3060: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 3060: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3056: x_return_status := FND_API.G_RET_STS_ERROR ;
3057: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
3058: p_data => x_msg_data
3059: );
3060: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3061: ROLLBACK TO Process_Credit_Card;
3062: iby_debug_pub.add(debug_msg => 'In G_EXC_UNEXPECTED_ERROR Exception',
3063: debug_level => FND_LOG.LEVEL_UNEXPECTED,
3064: module => G_DEBUG_MODULE || l_module);

Line 3065: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

3061: ROLLBACK TO Process_Credit_Card;
3062: iby_debug_pub.add(debug_msg => 'In G_EXC_UNEXPECTED_ERROR Exception',
3063: debug_level => FND_LOG.LEVEL_UNEXPECTED,
3064: module => G_DEBUG_MODULE || l_module);
3065: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3066: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
3067: p_data => x_msg_data
3068: );
3069: WHEN OTHERS THEN

Line 3077: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

3073: module => G_DEBUG_MODULE || l_module);
3074:
3075: iby_fndcpt_common_pub.Clear_Msg_Stack(l_prev_msg_count);
3076:
3077: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3078: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3079: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_module, SUBSTR(SQLERRM,1,100));
3080: END IF;
3081:

Line 3096: (1.0, FND_API.G_FALSE, p_number,

3092: lx_msg_data VARCHAR2(200);
3093: lx_cc_number iby_creditcard.ccnumber%TYPE;
3094: BEGIN
3095: iby_cc_validate.StripCC
3096: (1.0, FND_API.G_FALSE, p_number,
3097: lx_return_status, lx_msg_count, lx_msg_data, lx_cc_number
3098: );
3099: RETURN iby_security_pkg.get_hash(lx_cc_number,p_salt);
3100: END Get_Hash;

Line 3111: (1.0, FND_API.G_FALSE, p_number,

3107: lx_msg_data VARCHAR2(200);
3108: lx_cc_number iby_creditcard.ccnumber%TYPE;
3109: BEGIN
3110: iby_cc_validate.StripCC
3111: (1.0, FND_API.G_FALSE, p_number,
3112: lx_return_status, lx_msg_count, lx_msg_data, lx_cc_number
3113: );
3114: RETURN iby_security_pkg.get_hash(lx_cc_number,p_salt,p_site_salt);
3115: END Get_Hash;

Line 3148: IBY_FNDCPT_SETUP_PUB.Get_Payer_Id(p_payer,FND_API.G_VALID_LEVEL_FULL,

3144: ORDER BY p.acct_site_use_id, p.cust_account_id, p.org_id;
3145:
3146: BEGIN
3147:
3148: IBY_FNDCPT_SETUP_PUB.Get_Payer_Id(p_payer,FND_API.G_VALID_LEVEL_FULL,
3149: l_payer_level,l_payer_id,l_payer_attribs);
3150:
3151: FOR l_payer_attr_rec in l_payer_attr_cur(p_payer,l_payer_level,p_payer_equivalency) LOOP
3152: IF (x_payer_attributes.Bank_Charge_Bearer is NULL) THEN

Line 3186: x_result_code := FND_API.G_RET_STS_SUCCESS;

3182:
3183: l_dbg_mod VARCHAR2(100) := 'iby.plsql.IBY_FNDCPT_SETUP_PUB' || '.' || 'Get_Expiration_Status';
3184: BEGIN
3185: iby_debug_pub.add('Enter',iby_debug_pub.G_LEVEL_PROCEDURE,l_dbg_mod);
3186: x_result_code := FND_API.G_RET_STS_SUCCESS;
3187:
3188: SELECT expirydate, expiry_sec_segment_id
3189: INTO l_expiry_date, l_exp_sec_segment_id
3190: FROM iby_creditcard

Line 3213: IF(l_return_status <> FND_API.G_RET_STS_SUCCESS)THEN

3209: l_msg_count,
3210: l_msg_data,
3211: l_resp_rec
3212: );
3213: IF(l_return_status <> FND_API.G_RET_STS_SUCCESS)THEN
3214: iby_debug_pub.add('Error during http call out',iby_debug_pub.G_LEVEL_ERROR,l_dbg_mod);
3215: x_result_code := FND_API.G_RET_STS_ERROR;
3216: RETURN;
3217: END IF;

Line 3215: x_result_code := FND_API.G_RET_STS_ERROR;

3211: l_resp_rec
3212: );
3213: IF(l_return_status <> FND_API.G_RET_STS_SUCCESS)THEN
3214: iby_debug_pub.add('Error during http call out',iby_debug_pub.G_LEVEL_ERROR,l_dbg_mod);
3215: x_result_code := FND_API.G_RET_STS_ERROR;
3216: RETURN;
3217: END IF;
3218: x_expired := l_resp_rec.Expired;
3219: iby_debug_pub.add('Exit',iby_debug_pub.G_LEVEL_PROCEDURE,l_dbg_mod);