DBA Data[Home] [Help]

APPS.IBY_FNDCPT_TRXN_PUB dependencies on IBY_FNDCPT_SETUP_PUB

Line 368: l_channel_attribs IBY_FNDCPT_SETUP_PUB.PmtChannel_AttribUses_rec_type;

364: IS
365: l_return_status VARCHAR2(1);
366: l_msg_count NUMBER;
367: l_msg_data VARCHAR2(100);
368: l_channel_attribs IBY_FNDCPT_SETUP_PUB.PmtChannel_AttribUses_rec_type;
369: l_response IBY_FNDCPT_COMMON_PUB.Result_rec_type;
370:
371: l_dbg_mod VARCHAR2(100) := G_DEBUG_MODULE || '.Extension_Valid';
372: BEGIN

Line 377: IBY_FNDCPT_SETUP_PUB.Get_Payment_Channel_Attribs

373:
374: iby_debug_pub.add('validating xtension',
375: iby_debug_pub.G_LEVEL_PROCEDURE,l_dbg_mod);
376:
377: IBY_FNDCPT_SETUP_PUB.Get_Payment_Channel_Attribs
378: (1.0, FND_API.G_FALSE, l_return_status, l_msg_count, l_msg_data,
379: p_pmt_channel, l_channel_attribs, l_response);
380:
381: IF (l_response.Result_Code <> IBY_FNDCPT_COMMON_PUB.G_RC_SUCCESS) THEN

Line 386: IBY_FNDCPT_SETUP_PUB.G_CHNNL_ATTRIB_USE_REQUIRED)

382: RETURN FALSE;
383: END IF;
384:
385: IF ( (l_channel_attribs.Instr_SecCode_Use =
386: IBY_FNDCPT_SETUP_PUB.G_CHNNL_ATTRIB_USE_REQUIRED)
387: AND
388: ( ((p_trxn_attribs.Instrument_Security_Code IS NULL)
389: AND (NOT p_update)
390: AND (NOT p_consumed_cvv2)

Line 399: IBY_FNDCPT_SETUP_PUB.G_CHNNL_ATTRIB_USE_DISABLED)

395: THEN
396: RETURN FALSE;
397: END IF;
398: IF ( (l_channel_attribs.Instr_SecCode_Use =
399: IBY_FNDCPT_SETUP_PUB.G_CHNNL_ATTRIB_USE_DISABLED)
400: AND NOT ( (p_trxn_attribs.Instrument_Security_Code IS NULL) OR
401: (p_trxn_attribs.Instrument_security_Code = FND_API.G_MISS_CHAR)
402: )
403: )

Line 409: IBY_FNDCPT_SETUP_PUB.G_CHNNL_ATTRIB_USE_REQUIRED)

405: RETURN FALSE;
406: END IF;
407:
408: IF ( (l_channel_attribs.Instr_VoiceAuthFlag_Use =
409: IBY_FNDCPT_SETUP_PUB.G_CHNNL_ATTRIB_USE_REQUIRED)
410: AND ( (p_trxn_attribs.VoiceAuth_Flag IS NULL AND (NOT p_update))
411: OR (p_trxn_attribs.VoiceAuth_Flag = FND_API.G_MISS_CHAR) )
412: )
413: THEN

Line 418: IBY_FNDCPT_SETUP_PUB.G_CHNNL_ATTRIB_USE_DISABLED)

414: RETURN FALSE;
415: END IF;
416: --Fix for bug# 6404912: Voice Auth flag 'N' and NULL treated similarly
417: IF ( (l_channel_attribs.Instr_VoiceAuthFlag_Use =
418: IBY_FNDCPT_SETUP_PUB.G_CHNNL_ATTRIB_USE_DISABLED)
419: AND NOT ( ( nvl(p_trxn_attribs.VoiceAuth_Flag, 'N') = 'N') OR
420: (p_trxn_attribs.VoiceAuth_Flag = FND_API.G_MISS_CHAR)
421: )
422: )

Line 428: IBY_FNDCPT_SETUP_PUB.G_CHNNL_ATTRIB_USE_REQUIRED)

424: RETURN FALSE;
425: END IF;
426:
427: IF ( (l_channel_attribs.Instr_VoiceAuthCode_Use =
428: IBY_FNDCPT_SETUP_PUB.G_CHNNL_ATTRIB_USE_REQUIRED)
429: AND ( (p_trxn_attribs.VoiceAuth_Code IS NULL AND (NOT p_update))
430: OR (p_trxn_attribs.VoiceAuth_Code = FND_API.G_MISS_CHAR)
431: )
432: )

Line 437: IBY_FNDCPT_SETUP_PUB.G_CHNNL_ATTRIB_USE_DISABLED)

433: THEN
434: RETURN FALSE;
435: END IF;
436: IF ( (l_channel_attribs.Instr_VoiceAuthCode_Use =
437: IBY_FNDCPT_SETUP_PUB.G_CHNNL_ATTRIB_USE_DISABLED)
438: AND NOT ( (p_trxn_attribs.VoiceAuth_Code IS NULL) OR
439: (p_trxn_attribs.VoiceAuth_Code = FND_API.G_MISS_CHAR)
440: )
441: )

Line 447: IBY_FNDCPT_SETUP_PUB.G_CHNNL_ATTRIB_USE_REQUIRED)

443: RETURN FALSE;
444: END IF;
445:
446: IF ( (l_channel_attribs.Instr_VoiceAuthDate_Use =
447: IBY_FNDCPT_SETUP_PUB.G_CHNNL_ATTRIB_USE_REQUIRED)
448: AND ( (p_trxn_attribs.VoiceAuth_Date IS NULL AND (NOT p_update)) OR
449: (p_trxn_attribs.VoiceAuth_Date = FND_API.G_MISS_DATE) )
450: )
451: THEN

Line 455: IBY_FNDCPT_SETUP_PUB.G_CHNNL_ATTRIB_USE_DISABLED)

451: THEN
452: RETURN FALSE;
453: END IF;
454: IF ( (l_channel_attribs.Instr_VoiceAuthDate_Use =
455: IBY_FNDCPT_SETUP_PUB.G_CHNNL_ATTRIB_USE_DISABLED)
456: AND NOT ( (p_trxn_attribs.VoiceAuth_Date IS NULL) OR
457: (p_trxn_attribs.VoiceAuth_Date = FND_API.G_MISS_DATE)
458: )
459: )

Line 465: IBY_FNDCPT_SETUP_PUB.G_CHNNL_ATTRIB_USE_REQUIRED)

461: RETURN FALSE;
462: END IF;
463:
464: IF ( (l_channel_attribs.PO_Number_Use =
465: IBY_FNDCPT_SETUP_PUB.G_CHNNL_ATTRIB_USE_REQUIRED)
466: AND ( (p_trxn_attribs.PO_Number IS NULL AND (NOT p_update))
467: OR (p_trxn_attribs.PO_Number = FND_API.G_MISS_CHAR) )
468: )
469: THEN

Line 473: IBY_FNDCPT_SETUP_PUB.G_CHNNL_ATTRIB_USE_DISABLED)

469: THEN
470: RETURN FALSE;
471: END IF;
472: IF ( (l_channel_attribs.PO_Number_Use =
473: IBY_FNDCPT_SETUP_PUB.G_CHNNL_ATTRIB_USE_DISABLED)
474: AND NOT ( (p_trxn_attribs.PO_Number IS NULL) OR
475: (p_trxn_attribs.PO_Number = FND_API.G_MISS_CHAR)
476: )
477: )

Line 483: IBY_FNDCPT_SETUP_PUB.G_CHNNL_ATTRIB_USE_REQUIRED)

479: RETURN FALSE;
480: END IF;
481:
482: IF ( (l_channel_attribs.PO_Line_Number_Use =
483: IBY_FNDCPT_SETUP_PUB.G_CHNNL_ATTRIB_USE_REQUIRED)
484: AND ( (p_trxn_attribs.PO_Line_Number IS NULL OR (NOT p_update))
485: OR (p_trxn_attribs.PO_Line_Number = FND_API.G_MISS_CHAR) )
486: )
487: THEN

Line 491: IBY_FNDCPT_SETUP_PUB.G_CHNNL_ATTRIB_USE_DISABLED)

487: THEN
488: RETURN FALSE;
489: END IF;
490: IF ( (l_channel_attribs.PO_Line_Number_Use =
491: IBY_FNDCPT_SETUP_PUB.G_CHNNL_ATTRIB_USE_DISABLED)
492: AND NOT ( (p_trxn_attribs.PO_Line_Number IS NULL) OR
493: (p_trxn_attribs.PO_Line_Number = FND_API.G_MISS_CHAR)
494: )
495: )

Line 501: IBY_FNDCPT_SETUP_PUB.G_CHNNL_ATTRIB_USE_REQUIRED)

497: RETURN FALSE;
498: END IF;
499:
500: IF ( (l_channel_attribs.AddInfo_Use =
501: IBY_FNDCPT_SETUP_PUB.G_CHNNL_ATTRIB_USE_REQUIRED)
502: AND ( (p_trxn_attribs.Additional_Info IS NULL OR (NOT p_update))
503: OR (p_trxn_attribs.Additional_Info = FND_API.G_MISS_CHAR) )
504: )
505: THEN

Line 509: IBY_FNDCPT_SETUP_PUB.G_CHNNL_ATTRIB_USE_DISABLED)

505: THEN
506: RETURN FALSE;
507: END IF;
508: IF ( (l_channel_attribs.AddInfo_Use =
509: IBY_FNDCPT_SETUP_PUB.G_CHNNL_ATTRIB_USE_DISABLED)
510: AND NOT ( (p_trxn_attribs.Additional_Info IS NULL) OR
511: (p_trxn_attribs.Additional_Info = FND_API.G_MISS_CHAR)
512: )
513: )

Line 560: AND (pm.payment_flow = IBY_FNDCPT_SETUP_PUB.G_PMT_FLOW_FNDCPT)

556: WHERE (c.payment_channel_code = ci_channel_code)
557: AND (pm.payment_method_code = c.payment_channel_code)
558: AND (NVL(pm.inactive_date,SYSDATE-10) 559: AND (NVL(c.inactive_date,SYSDATE-10) 560: AND (pm.payment_flow = IBY_FNDCPT_SETUP_PUB.G_PMT_FLOW_FNDCPT)
561: AND pm.ext_pmt_party_id IN
562: (
563: SELECT ext_payer_id
564: FROM iby_external_payers_all

Line 646: AND (NVL(payment_flow,IBY_FNDCPT_SETUP_PUB.G_PMT_FLOW_FNDCPT)

642: FROM iby_fndcpt_pmt_chnnls_b c, iby_pmt_instr_uses_all u
643: WHERE (payment_channel_code = ci_channel_code)
644: AND (u.instrument_payment_use_id (+) = ci_assign_id)
645: AND (c.instrument_type = u.instrument_type(+))
646: AND (NVL(payment_flow,IBY_FNDCPT_SETUP_PUB.G_PMT_FLOW_FNDCPT)
647: = IBY_FNDCPT_SETUP_PUB.G_PMT_FLOW_FNDCPT);
648:
649: BEGIN
650: IF (c_channel_assign%ISOPEN) THEN CLOSE c_channel_assign; END IF;

Line 647: = IBY_FNDCPT_SETUP_PUB.G_PMT_FLOW_FNDCPT);

643: WHERE (payment_channel_code = ci_channel_code)
644: AND (u.instrument_payment_use_id (+) = ci_assign_id)
645: AND (c.instrument_type = u.instrument_type(+))
646: AND (NVL(payment_flow,IBY_FNDCPT_SETUP_PUB.G_PMT_FLOW_FNDCPT)
647: = IBY_FNDCPT_SETUP_PUB.G_PMT_FLOW_FNDCPT);
648:
649: BEGIN
650: IF (c_channel_assign%ISOPEN) THEN CLOSE c_channel_assign; END IF;
651:

Line 662: ELSIF (l_assign_appl = IBY_FNDCPT_SETUP_PUB.G_CHNNL_ATTRIB_USE_OPTIONAL)

658: IF ((x_channel_instr = IBY_FNDCPT_COMMON_PUB.G_INSTR_TYPE_MANUAL)
659: AND (l_assign_id IS NULL))
660: THEN
661: RETURN TRUE;
662: ELSIF (l_assign_appl = IBY_FNDCPT_SETUP_PUB.G_CHNNL_ATTRIB_USE_OPTIONAL)
663: THEN
664: RETURN TRUE;
665: ELSIF (NOT l_assign_id IS NULL) THEN
666: RETURN TRUE;

Line 740: IF ((l_instr_req = IBY_FNDCPT_SETUP_PUB.G_CHNNL_ATTRIB_USE_OPTIONAL)

736:
737: iby_debug_pub.add('instrument applicability:=' || l_instr_req,
738: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
739:
740: IF ((l_instr_req = IBY_FNDCPT_SETUP_PUB.G_CHNNL_ATTRIB_USE_OPTIONAL)
741: AND (p_instr_assign IS NULL))
742: THEN
743: RETURN TRUE;
744: ELSIF (l_instr_req = IBY_FNDCPT_SETUP_PUB.G_CHNNL_ATTRIB_USE_DISABLED) THEN

Line 744: ELSIF (l_instr_req = IBY_FNDCPT_SETUP_PUB.G_CHNNL_ATTRIB_USE_DISABLED) THEN

740: IF ((l_instr_req = IBY_FNDCPT_SETUP_PUB.G_CHNNL_ATTRIB_USE_OPTIONAL)
741: AND (p_instr_assign IS NULL))
742: THEN
743: RETURN TRUE;
744: ELSIF (l_instr_req = IBY_FNDCPT_SETUP_PUB.G_CHNNL_ATTRIB_USE_DISABLED) THEN
745: RETURN (p_instr_assign IS NULL);
746: END IF;
747:
748: OPEN c_instr_assigns(p_payer,p_payer_level,p_payer_equiv,p_instr_assign);

Line 827: l_payer_attribs IBY_FNDCPT_SETUP_PUB.PayerAttributes_rec_type;

823: l_prev_msg_count NUMBER;
824:
825: l_payer_level VARCHAR2(30);
826: l_payer_id iby_external_payers_all.ext_payer_id%TYPE;
827: l_payer_attribs IBY_FNDCPT_SETUP_PUB.PayerAttributes_rec_type;
828:
829: l_msg_count NUMBER;
830: l_msg_data VARCHAR2(300);
831: l_return_status VARCHAR2(1);

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

864: iby_debug_pub.add('checking payer context',
865: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
866: -- test_debug('Create_Transaction_Extension=> Checking Payer context..');
867:
868: IBY_FNDCPT_SETUP_PUB.Get_Payer_Id(p_payer,FND_API.G_VALID_LEVEL_FULL,
869: l_payer_level,l_payer_id,l_payer_attribs);
870:
871: IF (l_payer_level = IBY_FNDCPT_COMMON_PUB.G_RC_INVALID_PAYER) THEN
872: x_response.Result_Code := IBY_FNDCPT_COMMON_PUB.G_RC_INVALID_PAYER;

Line 898: x_response.Result_Code := IBY_FNDCPT_SETUP_PUB.G_RC_INVALID_CHNNL;

894: --
895: IF (NOT Payer_Channel_Valid(p_payer,l_payer_level,
896: p_payer_equivalency,p_pmt_channel))
897: THEN
898: x_response.Result_Code := IBY_FNDCPT_SETUP_PUB.G_RC_INVALID_CHNNL;
899: iby_fndcpt_common_pub.Prepare_Result
900: (l_prev_msg_count,x_return_status,x_msg_count,x_msg_data,x_response);
901: RETURN;
902: END IF;

Line 914: x_response.Result_Code := IBY_FNDCPT_SETUP_PUB.G_RC_INVALID_INSTR_ASSIGN;

910: THEN
911: -- test_debug('instrument asssignment not valid for channel');
912: iby_debug_pub.add('instrument asssignment not valid for channel',
913: iby_debug_pub.G_LEVEL_ERROR,l_dbg_mod);
914: x_response.Result_Code := IBY_FNDCPT_SETUP_PUB.G_RC_INVALID_INSTR_ASSIGN;
915: iby_fndcpt_common_pub.Prepare_Result
916: (l_prev_msg_count,x_return_status,x_msg_count,x_msg_data,x_response);
917: RETURN;
918: END IF;

Line 931: x_response.Result_Code := IBY_FNDCPT_SETUP_PUB.G_RC_INVALID_INSTR_ASSIGN;

927: THEN
928: --test_debug('instrument asssignment not valid payer');
929: iby_debug_pub.add('instrument asssignment not valid payer',
930: iby_debug_pub.G_LEVEL_ERROR,l_dbg_mod);
931: x_response.Result_Code := IBY_FNDCPT_SETUP_PUB.G_RC_INVALID_INSTR_ASSIGN;
932: iby_fndcpt_common_pub.Prepare_Result
933: (l_prev_msg_count,x_return_status,x_msg_count,x_msg_data,x_response);
934: RETURN;
935: END IF;

Line 951: IBY_FNDCPT_SETUP_PUB.Set_Payer_Attributes

947: ELSE
948:
949: -- create payer on the fly if necessary
950: IF (l_payer_id IS NULL) THEN
951: IBY_FNDCPT_SETUP_PUB.Set_Payer_Attributes
952: (1.0, FND_API.G_FALSE, FND_API.G_FALSE,
953: x_return_status, x_msg_count, x_msg_data,
954: p_payer, l_payer_attribs, l_payer_id, lx_result
955: );

Line 1113: l_payer_attribs IBY_FNDCPT_SETUP_PUB.PayerAttributes_rec_type;

1109: l_prev_msg_count NUMBER;
1110:
1111: l_payer_level VARCHAR2(30);
1112: l_payer_id iby_external_payers_all.ext_payer_id%TYPE;
1113: l_payer_attribs IBY_FNDCPT_SETUP_PUB.PayerAttributes_rec_type;
1114:
1115: l_xtension_id iby_fndcpt_tx_extensions.trxn_extension_id%TYPE;
1116: l_pmt_channel iby_fndcpt_pmt_chnnls_b.payment_channel_code%TYPE;
1117: l_instr_assign iby_pmt_instr_uses_all.instrument_payment_use_id%TYPE;

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

1180: l_prev_msg_count := FND_MSG_PUB.Count_Msg;
1181:
1182: iby_debug_pub.add('checking payer context',iby_debug_pub.G_LEVEL_INFO,
1183: l_dbg_mod);
1184: IBY_FNDCPT_SETUP_PUB.Get_Payer_Id(p_payer,FND_API.G_VALID_LEVEL_FULL,
1185: l_payer_level,l_payer_id,l_payer_attribs);
1186:
1187: IF (l_payer_level = IBY_FNDCPT_COMMON_PUB.G_RC_INVALID_PAYER) THEN
1188: x_response.Result_Code := IBY_FNDCPT_COMMON_PUB.G_RC_INVALID_PAYER;

Line 1247: x_response.Result_Code := IBY_FNDCPT_SETUP_PUB.G_RC_INVALID_CHNNL;

1243: p_payer_equivalency,l_pmt_channel))
1244: THEN
1245: iby_debug_pub.add('invalid payment channel for payer',
1246: iby_debug_pub.G_LEVEL_ERROR,l_dbg_mod);
1247: x_response.Result_Code := IBY_FNDCPT_SETUP_PUB.G_RC_INVALID_CHNNL;
1248: iby_fndcpt_common_pub.Prepare_Result
1249: (l_prev_msg_count,x_return_status,x_msg_count,x_msg_data,
1250: x_response);
1251: RETURN;

Line 1264: x_response.Result_Code := IBY_FNDCPT_SETUP_PUB.G_RC_INVALID_INSTR_ASSIGN;

1260: l_instr_assign,FALSE))
1261: THEN
1262: iby_debug_pub.add('invalid payment channel for instrument or payer',
1263: iby_debug_pub.G_LEVEL_ERROR,l_dbg_mod);
1264: x_response.Result_Code := IBY_FNDCPT_SETUP_PUB.G_RC_INVALID_INSTR_ASSIGN;
1265: iby_fndcpt_common_pub.Prepare_Result
1266: (l_prev_msg_count,x_return_status,x_msg_count,x_msg_data,
1267: x_response);
1268: RETURN;

Line 1461: l_payer_attribs IBY_FNDCPT_SETUP_PUB.PayerAttributes_rec_type;

1457: l_prev_msg_count NUMBER;
1458:
1459: l_payer_level VARCHAR2(30);
1460: l_payer_id iby_external_payers_all.ext_payer_id%TYPE;
1461: l_payer_attribs IBY_FNDCPT_SETUP_PUB.PayerAttributes_rec_type;
1462:
1463: l_dbg_mod VARCHAR2(100) := G_DEBUG_MODULE || l_module;
1464:
1465: CURSOR c_extension

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

1498: END IF;
1499: l_prev_msg_count := FND_MSG_PUB.Count_Msg;
1500:
1501: iby_debug_pub.add('checking payer contxt',iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
1502: IBY_FNDCPT_SETUP_PUB.Get_Payer_Id(p_payer,FND_API.G_VALID_LEVEL_FULL,
1503: l_payer_level,l_payer_id,l_payer_attribs);
1504:
1505: IF (l_payer_level = IBY_FNDCPT_COMMON_PUB.G_RC_INVALID_PAYER) THEN
1506: x_response.Result_Code := IBY_FNDCPT_COMMON_PUB.G_RC_INVALID_PAYER;

Line 1601: l_payer_attribs IBY_FNDCPT_SETUP_PUB.PayerAttributes_rec_type;

1597: l_prev_msg_count NUMBER;
1598:
1599: l_payer_level VARCHAR2(30);
1600: l_payer_id iby_external_payers_all.ext_payer_id%TYPE;
1601: l_payer_attribs IBY_FNDCPT_SETUP_PUB.PayerAttributes_rec_type;
1602:
1603: l_extension_id NUMBER;
1604: l_copy_count NUMBER;
1605:

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

1650: END IF;
1651: l_prev_msg_count := FND_MSG_PUB.Count_Msg;
1652:
1653: iby_debug_pub.add('checking payer contxt',iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
1654: IBY_FNDCPT_SETUP_PUB.Get_Payer_Id(p_payer,FND_API.G_VALID_LEVEL_FULL,
1655: l_payer_level,l_payer_id,l_payer_attribs);
1656:
1657: IF (l_payer_level = IBY_FNDCPT_COMMON_PUB.G_RC_INVALID_PAYER) THEN
1658: x_response.Result_Code := IBY_FNDCPT_COMMON_PUB.G_RC_INVALID_PAYER;

Line 1769: l_payer_attribs IBY_FNDCPT_SETUP_PUB.PayerAttributes_rec_type;

1765: l_prev_msg_count NUMBER;
1766:
1767: l_payer_level VARCHAR2(30);
1768: l_payer_id iby_external_payers_all.ext_payer_id%TYPE;
1769: l_payer_attribs IBY_FNDCPT_SETUP_PUB.PayerAttributes_rec_type;
1770:
1771: l_pmt_channel iby_fndcpt_tx_extensions.payment_channel_code%TYPE;
1772: l_instr_assign_id iby_fndcpt_tx_extensions.instr_assignment_id%TYPE;
1773: lc_pmt_channel iby_fndcpt_tx_extensions.payment_channel_code%TYPE;

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

1893: iby_debug_pub.add('account site use id =' || p_payer.Account_Site_Id,iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
1894: iby_debug_pub.add('org id =' || p_payer.Org_Id,iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
1895: iby_debug_pub.add('org type =' || p_payer.Org_Type,iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
1896:
1897: IBY_FNDCPT_SETUP_PUB.Get_Payer_Id(p_payer,FND_API.G_VALID_LEVEL_FULL,
1898: l_payer_level,l_payer_id,l_payer_attribs);
1899:
1900: IF (l_payer_level = IBY_FNDCPT_COMMON_PUB.G_RC_INVALID_PAYER) THEN
1901: x_response.Result_Code := IBY_FNDCPT_COMMON_PUB.G_RC_INVALID_PAYER;

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

1914: (l_prev_msg_count,x_return_status,x_msg_count,x_msg_data,x_response);
1915: RETURN;
1916: END IF;
1917:
1918: IBY_FNDCPT_SETUP_PUB.Get_Payer_Id(p_payer,FND_API.G_VALID_LEVEL_FULL,
1919: l_payer_level,l_payer_id,l_payer_attribs);
1920:
1921: -- create external payer if necessary
1922: IF (l_payer_id IS NULL) THEN

Line 1924: IBY_FNDCPT_SETUP_PUB.Set_Payer_Attributes

1920:
1921: -- create external payer if necessary
1922: IF (l_payer_id IS NULL) THEN
1923: iby_debug_pub.add('setting payer attribs',iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
1924: IBY_FNDCPT_SETUP_PUB.Set_Payer_Attributes
1925: (1.0, FND_API.G_FALSE, FND_API.G_FALSE,
1926: x_return_status, x_msg_count, x_msg_data,
1927: p_payer, l_payer_attribs, l_payer_id, lx_result
1928: );

Line 1977: IBY_FNDCPT_SETUP_PUB.G_RC_INVALID_INSTR_ASSIGN;

1973: p_trxn_attribs.Copy_Instr_Assign_Id ||
1974: ' for channel ' || l_pmt_channel,
1975: iby_debug_pub.G_LEVEL_ERROR,l_dbg_mod);
1976: x_response.Result_Code :=
1977: IBY_FNDCPT_SETUP_PUB.G_RC_INVALID_INSTR_ASSIGN;
1978: iby_fndcpt_common_pub.Prepare_Result
1979: (l_prev_msg_count,x_return_status,x_msg_count,x_msg_data,x_response);
1980: RETURN;
1981: END IF;

Line 2298: l_payer_attribs IBY_FNDCPT_SETUP_PUB.PayerAttributes_rec_type;

2294: l_prev_msg_count NUMBER;
2295:
2296: l_payer_level VARCHAR2(30);
2297: l_payer_id iby_external_payers_all.ext_payer_id%TYPE;
2298: l_payer_attribs IBY_FNDCPT_SETUP_PUB.PayerAttributes_rec_type;
2299:
2300: l_copy_count NUMBER;
2301: l_auth_flag iby_trxn_extensions_v.authorized_flag%TYPE;
2302: l_instr_auth_flag iby_trxn_extensions_v.authorized_flag%TYPE;

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

2411: END IF;
2412: l_prev_msg_count := FND_MSG_PUB.Count_Msg;
2413:
2414: iby_debug_pub.add('checking payer context',iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
2415: IBY_FNDCPT_SETUP_PUB.Get_Payer_Id(p_payer,FND_API.G_VALID_LEVEL_FULL,
2416: l_payer_level,l_payer_id,l_payer_attribs);
2417:
2418: IF (l_payer_level = IBY_FNDCPT_COMMON_PUB.G_RC_INVALID_PAYER) THEN
2419: x_response.Result_Code := IBY_FNDCPT_COMMON_PUB.G_RC_INVALID_PAYER;

Line 2507: x_response.Result_Code := IBY_FNDCPT_SETUP_PUB.G_RC_INVALID_INSTRUMENT;

2503: CLOSE c_instr_extensions;
2504: IF (NVL(l_instr_auth_flag,'N') = 'Y') THEN
2505: iby_debug_pub.add('single use instrument cannot be reused',
2506: iby_debug_pub.G_LEVEL_ERROR,l_dbg_mod);
2507: x_response.Result_Code := IBY_FNDCPT_SETUP_PUB.G_RC_INVALID_INSTRUMENT;
2508: iby_fndcpt_common_pub.Prepare_Result
2509: (l_prev_msg_count,x_return_status,x_msg_count,x_msg_data,x_response);
2510: RETURN;
2511: END IF;

Line 2603: IBY_FNDCPT_SETUP_PUB.Get_Trxn_Payer_Attributes(p_payer,p_payer_equivalency, l_payer_attribs);

2599:
2600: -- populate the dirdeb_instruction_code column
2601: -- for settlement
2602: BEGIN
2603: IBY_FNDCPT_SETUP_PUB.Get_Trxn_Payer_Attributes(p_payer,p_payer_equivalency, l_payer_attribs);
2604:
2605: UPDATE iby_trxn_summaries_all
2606: SET dirdeb_instruction_code = l_payer_attribs.DirectDebit_BankInstruction
2607: WHERE transactionid = l_reqresp.Trxn_Id;

Line 3028: l_payer_attribs IBY_FNDCPT_SETUP_PUB.PayerAttributes_rec_type;

3024: l_prev_msg_count NUMBER;
3025:
3026: l_payer_level VARCHAR2(30);
3027: l_payer_id iby_external_payers_all.ext_payer_id%TYPE;
3028: l_payer_attribs IBY_FNDCPT_SETUP_PUB.PayerAttributes_rec_type;
3029:
3030: l_extension_count NUMBER;
3031: l_transactionid iby_fndcpt_tx_operations.transactionid%TYPE;
3032:

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

3139: FND_MSG_PUB.initialize;
3140: END IF;
3141: l_prev_msg_count := FND_MSG_PUB.Count_Msg;
3142:
3143: IBY_FNDCPT_SETUP_PUB.Get_Payer_Id(p_payer,FND_API.G_VALID_LEVEL_FULL,
3144: l_payer_level,l_payer_id,l_payer_attribs);
3145:
3146: IF (l_payer_level = IBY_FNDCPT_COMMON_PUB.G_RC_INVALID_PAYER) THEN
3147: iby_debug_pub.add('invalid payer',iby_debug_pub.G_LEVEL_ERROR,l_dbg_mod);

Line 4539: l_payer_attribs IBY_FNDCPT_SETUP_PUB.PayerAttributes_rec_type;

4535: l_prev_msg_count NUMBER;
4536:
4537: l_payer_level VARCHAR2(30);
4538: l_payer_id iby_external_payers_all.ext_payer_id%TYPE;
4539: l_payer_attribs IBY_FNDCPT_SETUP_PUB.PayerAttributes_rec_type;
4540: l_settled_flag VARCHAR2(1);
4541: l_returned_flag VARCHAR2(1);
4542: l_extension_found BOOLEAN;
4543:

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

4618: FND_MSG_PUB.initialize;
4619: END IF;
4620: l_prev_msg_count := FND_MSG_PUB.Count_Msg;
4621:
4622: IBY_FNDCPT_SETUP_PUB.Get_Payer_Id(p_payer,FND_API.G_VALID_LEVEL_FULL,
4623: l_payer_level,l_payer_id,l_payer_attribs);
4624:
4625: IF (l_payer_level = IBY_FNDCPT_COMMON_PUB.G_RC_INVALID_PAYER) THEN
4626: x_response.Result_Code := IBY_FNDCPT_COMMON_PUB.G_RC_INVALID_PAYER;