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_TRXN_PUB dependencies on IBY_FNDCPT_SETUP_PUB

Line 518: l_channel_attribs IBY_FNDCPT_SETUP_PUB.PmtChannel_AttribUses_rec_type;

514: IS
515: l_return_status VARCHAR2(1);
516: l_msg_count NUMBER;
517: l_msg_data VARCHAR2(100);
518: l_channel_attribs IBY_FNDCPT_SETUP_PUB.PmtChannel_AttribUses_rec_type;
519: l_response IBY_FNDCPT_COMMON_PUB.Result_rec_type;
520:
521: l_dbg_mod VARCHAR2(100) := G_DEBUG_MODULE || '.Extension_Valid';
522: BEGIN

Line 533: iby_debug_pub.add('Call -> IBY_FNDCPT_SETUP_PUB.Get_Payment_Channel_Attribs',

529: iby_debug_pub.add('validating xtension',G_LEVEL_STATEMENT,l_dbg_mod);
530: END IF;
531:
532: IF( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
533: iby_debug_pub.add('Call -> IBY_FNDCPT_SETUP_PUB.Get_Payment_Channel_Attribs',
534: G_LEVEL_STATEMENT,l_dbg_mod);
535: END IF;
536: IBY_FNDCPT_SETUP_PUB.Get_Payment_Channel_Attribs
537: (1.0, FND_API.G_FALSE, l_return_status, l_msg_count, l_msg_data,

Line 536: IBY_FNDCPT_SETUP_PUB.Get_Payment_Channel_Attribs

532: IF( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
533: iby_debug_pub.add('Call -> IBY_FNDCPT_SETUP_PUB.Get_Payment_Channel_Attribs',
534: G_LEVEL_STATEMENT,l_dbg_mod);
535: END IF;
536: IBY_FNDCPT_SETUP_PUB.Get_Payment_Channel_Attribs
537: (1.0, FND_API.G_FALSE, l_return_status, l_msg_count, l_msg_data,
538: p_pmt_channel, l_channel_attribs, l_response);
539:
540: IF( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 541: iby_debug_pub.add('Return from IBY_FNDCPT_SETUP_PUB.Get_Payment_Channel_Attribs',

537: (1.0, FND_API.G_FALSE, l_return_status, l_msg_count, l_msg_data,
538: p_pmt_channel, l_channel_attribs, l_response);
539:
540: IF( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
541: iby_debug_pub.add('Return from IBY_FNDCPT_SETUP_PUB.Get_Payment_Channel_Attribs',
542: G_LEVEL_STATEMENT,l_dbg_mod);
543: END IF;
544: IF (l_response.Result_Code <> IBY_FNDCPT_COMMON_PUB.G_RC_SUCCESS) THEN
545: RETURN FALSE;

Line 549: IBY_FNDCPT_SETUP_PUB.G_CHNNL_ATTRIB_USE_REQUIRED)

545: RETURN FALSE;
546: END IF;
547:
548: IF ( (l_channel_attribs.Instr_SecCode_Use =
549: IBY_FNDCPT_SETUP_PUB.G_CHNNL_ATTRIB_USE_REQUIRED)
550: AND
551: ( ((p_trxn_attribs.Instrument_Security_Code IS NULL)
552: AND (NOT p_update)
553: AND (NOT p_consumed_cvv2)

Line 562: IBY_FNDCPT_SETUP_PUB.G_CHNNL_ATTRIB_USE_DISABLED)

558: THEN
559: RETURN FALSE;
560: END IF;
561: IF ( (l_channel_attribs.Instr_SecCode_Use =
562: IBY_FNDCPT_SETUP_PUB.G_CHNNL_ATTRIB_USE_DISABLED)
563: AND NOT ( (p_trxn_attribs.Instrument_Security_Code IS NULL) OR
564: (p_trxn_attribs.Instrument_security_Code = FND_API.G_MISS_CHAR)
565: )
566: )

Line 572: IBY_FNDCPT_SETUP_PUB.G_CHNNL_ATTRIB_USE_REQUIRED)

568: RETURN FALSE;
569: END IF;
570:
571: IF ( (l_channel_attribs.Instr_VoiceAuthFlag_Use =
572: IBY_FNDCPT_SETUP_PUB.G_CHNNL_ATTRIB_USE_REQUIRED)
573: AND ( (p_trxn_attribs.VoiceAuth_Flag IS NULL AND (NOT p_update))
574: OR (p_trxn_attribs.VoiceAuth_Flag = FND_API.G_MISS_CHAR) )
575: )
576: THEN

Line 581: IBY_FNDCPT_SETUP_PUB.G_CHNNL_ATTRIB_USE_DISABLED)

577: RETURN FALSE;
578: END IF;
579: --Fix for bug# 6404912: Voice Auth flag 'N' and NULL treated similarly
580: IF ( (l_channel_attribs.Instr_VoiceAuthFlag_Use =
581: IBY_FNDCPT_SETUP_PUB.G_CHNNL_ATTRIB_USE_DISABLED)
582: AND NOT ( ( nvl(p_trxn_attribs.VoiceAuth_Flag, 'N') = 'N') OR
583: (p_trxn_attribs.VoiceAuth_Flag = FND_API.G_MISS_CHAR)
584: )
585: )

Line 591: IBY_FNDCPT_SETUP_PUB.G_CHNNL_ATTRIB_USE_REQUIRED)

587: RETURN FALSE;
588: END IF;
589:
590: IF ( (l_channel_attribs.Instr_VoiceAuthCode_Use =
591: IBY_FNDCPT_SETUP_PUB.G_CHNNL_ATTRIB_USE_REQUIRED)
592: AND ( (p_trxn_attribs.VoiceAuth_Code IS NULL AND (NOT p_update))
593: OR (p_trxn_attribs.VoiceAuth_Code = FND_API.G_MISS_CHAR)
594: )
595: )

Line 600: IBY_FNDCPT_SETUP_PUB.G_CHNNL_ATTRIB_USE_DISABLED)

596: THEN
597: RETURN FALSE;
598: END IF;
599: IF ( (l_channel_attribs.Instr_VoiceAuthCode_Use =
600: IBY_FNDCPT_SETUP_PUB.G_CHNNL_ATTRIB_USE_DISABLED)
601: AND NOT ( (p_trxn_attribs.VoiceAuth_Code IS NULL) OR
602: (p_trxn_attribs.VoiceAuth_Code = FND_API.G_MISS_CHAR)
603: )
604: )

Line 610: IBY_FNDCPT_SETUP_PUB.G_CHNNL_ATTRIB_USE_REQUIRED)

606: RETURN FALSE;
607: END IF;
608:
609: IF ( (l_channel_attribs.Instr_VoiceAuthDate_Use =
610: IBY_FNDCPT_SETUP_PUB.G_CHNNL_ATTRIB_USE_REQUIRED)
611: AND ( (p_trxn_attribs.VoiceAuth_Date IS NULL AND (NOT p_update)) OR
612: (p_trxn_attribs.VoiceAuth_Date = FND_API.G_MISS_DATE) )
613: )
614: THEN

Line 618: IBY_FNDCPT_SETUP_PUB.G_CHNNL_ATTRIB_USE_DISABLED)

614: THEN
615: RETURN FALSE;
616: END IF;
617: IF ( (l_channel_attribs.Instr_VoiceAuthDate_Use =
618: IBY_FNDCPT_SETUP_PUB.G_CHNNL_ATTRIB_USE_DISABLED)
619: AND NOT ( (p_trxn_attribs.VoiceAuth_Date IS NULL) OR
620: (p_trxn_attribs.VoiceAuth_Date = FND_API.G_MISS_DATE)
621: )
622: )

Line 628: IBY_FNDCPT_SETUP_PUB.G_CHNNL_ATTRIB_USE_REQUIRED)

624: RETURN FALSE;
625: END IF;
626:
627: IF ( (l_channel_attribs.PO_Number_Use =
628: IBY_FNDCPT_SETUP_PUB.G_CHNNL_ATTRIB_USE_REQUIRED)
629: AND ( (p_trxn_attribs.PO_Number IS NULL AND (NOT p_update))
630: OR (p_trxn_attribs.PO_Number = FND_API.G_MISS_CHAR) )
631: )
632: THEN

Line 636: IBY_FNDCPT_SETUP_PUB.G_CHNNL_ATTRIB_USE_DISABLED)

632: THEN
633: RETURN FALSE;
634: END IF;
635: IF ( (l_channel_attribs.PO_Number_Use =
636: IBY_FNDCPT_SETUP_PUB.G_CHNNL_ATTRIB_USE_DISABLED)
637: AND NOT ( (p_trxn_attribs.PO_Number IS NULL) OR
638: (p_trxn_attribs.PO_Number = FND_API.G_MISS_CHAR)
639: )
640: )

Line 646: IBY_FNDCPT_SETUP_PUB.G_CHNNL_ATTRIB_USE_REQUIRED)

642: RETURN FALSE;
643: END IF;
644:
645: IF ( (l_channel_attribs.PO_Line_Number_Use =
646: IBY_FNDCPT_SETUP_PUB.G_CHNNL_ATTRIB_USE_REQUIRED)
647: AND ( (p_trxn_attribs.PO_Line_Number IS NULL OR (NOT p_update))
648: OR (p_trxn_attribs.PO_Line_Number = FND_API.G_MISS_CHAR) )
649: )
650: THEN

Line 654: IBY_FNDCPT_SETUP_PUB.G_CHNNL_ATTRIB_USE_DISABLED)

650: THEN
651: RETURN FALSE;
652: END IF;
653: IF ( (l_channel_attribs.PO_Line_Number_Use =
654: IBY_FNDCPT_SETUP_PUB.G_CHNNL_ATTRIB_USE_DISABLED)
655: AND NOT ( (p_trxn_attribs.PO_Line_Number IS NULL) OR
656: (p_trxn_attribs.PO_Line_Number = FND_API.G_MISS_CHAR)
657: )
658: )

Line 664: IBY_FNDCPT_SETUP_PUB.G_CHNNL_ATTRIB_USE_REQUIRED)

660: RETURN FALSE;
661: END IF;
662:
663: IF ( (l_channel_attribs.AddInfo_Use =
664: IBY_FNDCPT_SETUP_PUB.G_CHNNL_ATTRIB_USE_REQUIRED)
665: AND ( (p_trxn_attribs.Additional_Info IS NULL OR (NOT p_update))
666: OR (p_trxn_attribs.Additional_Info = FND_API.G_MISS_CHAR) )
667: )
668: THEN

Line 672: IBY_FNDCPT_SETUP_PUB.G_CHNNL_ATTRIB_USE_DISABLED)

668: THEN
669: RETURN FALSE;
670: END IF;
671: IF ( (l_channel_attribs.AddInfo_Use =
672: IBY_FNDCPT_SETUP_PUB.G_CHNNL_ATTRIB_USE_DISABLED)
673: AND NOT ( (p_trxn_attribs.Additional_Info IS NULL) OR
674: (p_trxn_attribs.Additional_Info = FND_API.G_MISS_CHAR)
675: )
676: )

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

723: WHERE (c.payment_channel_code = ci_channel_code)
724: AND (pm.payment_method_code = c.payment_channel_code)
725: AND (NVL(pm.inactive_date,SYSDATE-10) 726: AND (NVL(c.inactive_date,SYSDATE-10) 727: AND (pm.payment_flow = IBY_FNDCPT_SETUP_PUB.G_PMT_FLOW_FNDCPT)
728: AND pm.ext_pmt_party_id IN
729: (
730: SELECT ext_payer_id
731: FROM iby_external_payers_all

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

829: FROM iby_fndcpt_pmt_chnnls_b c, iby_pmt_instr_uses_all u
830: WHERE (payment_channel_code = ci_channel_code)
831: AND (u.instrument_payment_use_id (+) = ci_assign_id)
832: AND (c.instrument_type = u.instrument_type(+))
833: AND (NVL(payment_flow,IBY_FNDCPT_SETUP_PUB.G_PMT_FLOW_FNDCPT)
834: = IBY_FNDCPT_SETUP_PUB.G_PMT_FLOW_FNDCPT);
835:
836: l_dbg_mod VARCHAR2(100) := G_DEBUG_MODULE || '.InstrAssignment_Channel_Valid';
837: BEGIN

Line 834: = IBY_FNDCPT_SETUP_PUB.G_PMT_FLOW_FNDCPT);

830: WHERE (payment_channel_code = ci_channel_code)
831: AND (u.instrument_payment_use_id (+) = ci_assign_id)
832: AND (c.instrument_type = u.instrument_type(+))
833: AND (NVL(payment_flow,IBY_FNDCPT_SETUP_PUB.G_PMT_FLOW_FNDCPT)
834: = IBY_FNDCPT_SETUP_PUB.G_PMT_FLOW_FNDCPT);
835:
836: l_dbg_mod VARCHAR2(100) := G_DEBUG_MODULE || '.InstrAssignment_Channel_Valid';
837: BEGIN
838: IF( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 858: ELSIF (l_assign_appl = IBY_FNDCPT_SETUP_PUB.G_CHNNL_ATTRIB_USE_OPTIONAL)

854: IF ((x_channel_instr = IBY_FNDCPT_COMMON_PUB.G_INSTR_TYPE_MANUAL)
855: AND (l_assign_id IS NULL))
856: THEN
857: RETURN TRUE;
858: ELSIF (l_assign_appl = IBY_FNDCPT_SETUP_PUB.G_CHNNL_ATTRIB_USE_OPTIONAL)
859: THEN
860: RETURN TRUE;
861: ELSIF (NOT l_assign_id IS NULL) THEN
862: RETURN TRUE;

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

937: IF( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
938: iby_debug_pub.add('instrument applicability:=' || l_instr_req,G_LEVEL_STATEMENT,l_dbg_mod);
939: END IF;
940:
941: IF ((l_instr_req = IBY_FNDCPT_SETUP_PUB.G_CHNNL_ATTRIB_USE_OPTIONAL)
942: AND (p_instr_assign IS NULL))
943: THEN
944: RETURN TRUE;
945: ELSIF (l_instr_req = IBY_FNDCPT_SETUP_PUB.G_CHNNL_ATTRIB_USE_DISABLED) THEN

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

941: IF ((l_instr_req = IBY_FNDCPT_SETUP_PUB.G_CHNNL_ATTRIB_USE_OPTIONAL)
942: AND (p_instr_assign IS NULL))
943: THEN
944: RETURN TRUE;
945: ELSIF (l_instr_req = IBY_FNDCPT_SETUP_PUB.G_CHNNL_ATTRIB_USE_DISABLED) THEN
946: RETURN (p_instr_assign IS NULL);
947: END IF;
948:
949: OPEN c_instr_assigns(p_payer,p_payer_level,p_payer_equiv,p_instr_assign);

Line 1044: l_payer_attribs IBY_FNDCPT_SETUP_PUB.PayerAttributes_rec_type;

1040: l_prev_msg_count NUMBER;
1041:
1042: l_payer_level VARCHAR2(30);
1043: l_payer_id iby_external_payers_all.ext_payer_id%TYPE;
1044: l_payer_attribs IBY_FNDCPT_SETUP_PUB.PayerAttributes_rec_type;
1045:
1046: l_msg_count NUMBER;
1047: l_msg_data VARCHAR2(300);
1048: l_return_status VARCHAR2(1);

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

1092: iby_debug_pub.add('p_instr_assignment: '|| p_instr_assignment,G_LEVEL_STATEMENT,l_dbg_mod);
1093: END IF;
1094: -- test_debug('Create_Transaction_Extension=> Checking Payer context..');
1095:
1096: IBY_FNDCPT_SETUP_PUB.Get_Payer_Id(p_payer,FND_API.G_VALID_LEVEL_FULL,
1097: l_payer_level,l_payer_id,l_payer_attribs);
1098:
1099: iby_debug_pub.add('l_payer_level: '|| l_payer_level,G_LEVEL_STATEMENT,l_dbg_mod);
1100: iby_debug_pub.add('l_payer_id: '|| l_payer_id,G_LEVEL_STATEMENT,l_dbg_mod);

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

1126: --
1127: IF (NOT Payer_Channel_Valid(p_payer,l_payer_level,
1128: p_payer_equivalency,p_pmt_channel))
1129: THEN
1130: x_response.Result_Code := IBY_FNDCPT_SETUP_PUB.G_RC_INVALID_CHNNL;
1131: iby_fndcpt_common_pub.Prepare_Result
1132: (l_prev_msg_count,x_return_status,x_msg_count,x_msg_data,x_response);
1133: RETURN;
1134: END IF;

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

1146: IF( G_LEVEL_ERROR >= G_CURRENT_RUNTIME_LEVEL) THEN
1147: iby_debug_pub.add('instrument asssignment not valid for channel',
1148: G_LEVEL_ERROR,l_dbg_mod);
1149: END IF;
1150: x_response.Result_Code := IBY_FNDCPT_SETUP_PUB.G_RC_INVALID_INSTR_ASSIGN;
1151: iby_fndcpt_common_pub.Prepare_Result
1152: (l_prev_msg_count,x_return_status,x_msg_count,x_msg_data,x_response);
1153: RETURN;
1154: END IF;

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

1165: IF( G_LEVEL_ERROR >= G_CURRENT_RUNTIME_LEVEL) THEN
1166: iby_debug_pub.add('instrument asssignment not valid payer',
1167: G_LEVEL_ERROR,l_dbg_mod);
1168: END IF;
1169: x_response.Result_Code := IBY_FNDCPT_SETUP_PUB.G_RC_INVALID_INSTR_ASSIGN;
1170: iby_fndcpt_common_pub.Prepare_Result
1171: (l_prev_msg_count,x_return_status,x_msg_count,x_msg_data,x_response);
1172: RETURN;
1173: END IF;

Line 1191: IBY_FNDCPT_SETUP_PUB.Set_Payer_Attributes

1187: ELSE
1188:
1189: -- create payer on the fly if necessary
1190: IF (l_payer_id IS NULL) THEN
1191: IBY_FNDCPT_SETUP_PUB.Set_Payer_Attributes
1192: (1.0, FND_API.G_FALSE, FND_API.G_FALSE,
1193: x_return_status, x_msg_count, x_msg_data,
1194: p_payer, l_payer_attribs, l_payer_id, lx_result
1195: );

Line 1388: l_payer_attribs IBY_FNDCPT_SETUP_PUB.PayerAttributes_rec_type;

1384: l_prev_msg_count NUMBER;
1385:
1386: l_payer_level VARCHAR2(30);
1387: l_payer_id iby_external_payers_all.ext_payer_id%TYPE;
1388: l_payer_attribs IBY_FNDCPT_SETUP_PUB.PayerAttributes_rec_type;
1389:
1390: l_xtension_id iby_fndcpt_tx_extensions.trxn_extension_id%TYPE;
1391: l_pmt_channel iby_fndcpt_pmt_chnnls_b.payment_channel_code%TYPE;
1392: l_instr_assign iby_pmt_instr_uses_all.instrument_payment_use_id%TYPE;

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

1462:
1463: IF( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1464: iby_debug_pub.add('checking payer context',G_LEVEL_STATEMENT,l_dbg_mod);
1465: END IF;
1466: IBY_FNDCPT_SETUP_PUB.Get_Payer_Id(p_payer,FND_API.G_VALID_LEVEL_FULL,
1467: l_payer_level,l_payer_id,l_payer_attribs);
1468:
1469: IF (l_payer_level = IBY_FNDCPT_COMMON_PUB.G_RC_INVALID_PAYER) THEN
1470: x_response.Result_Code := IBY_FNDCPT_COMMON_PUB.G_RC_INVALID_PAYER;

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

1553: THEN
1554: IF( G_LEVEL_ERROR >= G_CURRENT_RUNTIME_LEVEL) THEN
1555: iby_debug_pub.add('invalid payment channel for payer',G_LEVEL_ERROR,l_dbg_mod);
1556: END IF;
1557: x_response.Result_Code := IBY_FNDCPT_SETUP_PUB.G_RC_INVALID_CHNNL;
1558: iby_fndcpt_common_pub.Prepare_Result
1559: (l_prev_msg_count,x_return_status,x_msg_count,x_msg_data,
1560: x_response);
1561: RETURN;

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

1572: IF( G_LEVEL_ERROR >= G_CURRENT_RUNTIME_LEVEL) THEN
1573: iby_debug_pub.add('invalid payment channel for instrument or payer',
1574: G_LEVEL_ERROR,l_dbg_mod);
1575: END IF;
1576: x_response.Result_Code := IBY_FNDCPT_SETUP_PUB.G_RC_INVALID_INSTR_ASSIGN;
1577: iby_fndcpt_common_pub.Prepare_Result
1578: (l_prev_msg_count,x_return_status,x_msg_count,x_msg_data,
1579: x_response);
1580: RETURN;

Line 1829: l_payer_attribs IBY_FNDCPT_SETUP_PUB.PayerAttributes_rec_type;

1825: l_prev_msg_count NUMBER;
1826:
1827: l_payer_level VARCHAR2(30);
1828: l_payer_id iby_external_payers_all.ext_payer_id%TYPE;
1829: l_payer_attribs IBY_FNDCPT_SETUP_PUB.PayerAttributes_rec_type;
1830:
1831: l_dbg_mod VARCHAR2(100) := G_DEBUG_MODULE || l_module;
1832:
1833: CURSOR c_extension

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

1872:
1873: IF( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1874: iby_debug_pub.add('checking payer contxt',G_LEVEL_STATEMENT,l_dbg_mod);
1875: END IF;
1876: IBY_FNDCPT_SETUP_PUB.Get_Payer_Id(p_payer,FND_API.G_VALID_LEVEL_FULL,
1877: l_payer_level,l_payer_id,l_payer_attribs);
1878:
1879: IF (l_payer_level = IBY_FNDCPT_COMMON_PUB.G_RC_INVALID_PAYER) THEN
1880: x_response.Result_Code := IBY_FNDCPT_COMMON_PUB.G_RC_INVALID_PAYER;

Line 1986: l_payer_attribs IBY_FNDCPT_SETUP_PUB.PayerAttributes_rec_type;

1982: l_prev_msg_count NUMBER;
1983:
1984: l_payer_level VARCHAR2(30);
1985: l_payer_id iby_external_payers_all.ext_payer_id%TYPE;
1986: l_payer_attribs IBY_FNDCPT_SETUP_PUB.PayerAttributes_rec_type;
1987:
1988: l_extension_id NUMBER;
1989: l_copy_count NUMBER;
1990:

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

2041:
2042: IF( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2043: iby_debug_pub.add('checking payer contxt',G_LEVEL_STATEMENT,l_dbg_mod);
2044: END IF;
2045: IBY_FNDCPT_SETUP_PUB.Get_Payer_Id(p_payer,FND_API.G_VALID_LEVEL_FULL,
2046: l_payer_level,l_payer_id,l_payer_attribs);
2047:
2048: IF (l_payer_level = IBY_FNDCPT_COMMON_PUB.G_RC_INVALID_PAYER) THEN
2049: x_response.Result_Code := IBY_FNDCPT_COMMON_PUB.G_RC_INVALID_PAYER;

Line 2172: l_payer_attribs IBY_FNDCPT_SETUP_PUB.PayerAttributes_rec_type;

2168: l_prev_msg_count NUMBER;
2169:
2170: l_payer_level VARCHAR2(30);
2171: l_payer_id iby_external_payers_all.ext_payer_id%TYPE;
2172: l_payer_attribs IBY_FNDCPT_SETUP_PUB.PayerAttributes_rec_type;
2173:
2174: l_pmt_channel iby_fndcpt_tx_extensions.payment_channel_code%TYPE;
2175: l_instr_assign_id iby_fndcpt_tx_extensions.instr_assignment_id%TYPE;
2176: lc_pmt_channel iby_fndcpt_tx_extensions.payment_channel_code%TYPE;

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

2316: iby_debug_pub.add('org id =' || p_payer.Org_Id,G_LEVEL_STATEMENT,l_dbg_mod);
2317: iby_debug_pub.add('org type =' || p_payer.Org_Type,G_LEVEL_STATEMENT,l_dbg_mod);
2318: END IF;
2319:
2320: IBY_FNDCPT_SETUP_PUB.Get_Payer_Id(p_payer,FND_API.G_VALID_LEVEL_FULL,
2321: l_payer_level,l_payer_id,l_payer_attribs);
2322:
2323: iby_debug_pub.add('l_payer_level: '|| l_payer_level,G_LEVEL_STATEMENT,l_dbg_mod);
2324: iby_debug_pub.add('l_payer_id: '|| l_payer_id,G_LEVEL_STATEMENT,l_dbg_mod);

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

2343: (l_prev_msg_count,x_return_status,x_msg_count,x_msg_data,x_response);
2344: RETURN;
2345: END IF;
2346:
2347: IBY_FNDCPT_SETUP_PUB.Get_Payer_Id(p_payer,FND_API.G_VALID_LEVEL_FULL,
2348: l_payer_level,l_payer_id,l_payer_attribs);
2349:
2350: iby_debug_pub.add('l_payer_id: '|| l_payer_id,G_LEVEL_STATEMENT,l_dbg_mod);
2351:

Line 2357: IBY_FNDCPT_SETUP_PUB.Set_Payer_Attributes

2353: IF (l_payer_id IS NULL) THEN
2354: IF( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2355: iby_debug_pub.add('setting payer attribs',G_LEVEL_STATEMENT,l_dbg_mod);
2356: END IF;
2357: IBY_FNDCPT_SETUP_PUB.Set_Payer_Attributes
2358: (1.0, FND_API.G_FALSE, FND_API.G_FALSE,
2359: x_return_status, x_msg_count, x_msg_data,
2360: p_payer, l_payer_attribs, l_payer_id, lx_result
2361: );

Line 2417: --x_response.Result_Code := IBY_FNDCPT_SETUP_PUB.G_RC_INVALID_INSTR_ASSIGN;

2413: --IF (NOT Payer_InstrAssignment_Valid(p_payer,l_payer_level, p_payer_equivalency, l_pmt_channel, p_trxn_attribs.Copy_Instr_Assign_Id, TRUE ) ) THEN
2414: --IF( G_LEVEL_ERROR >= G_CURRENT_RUNTIME_LEVEL) THEN
2415: --iby_debug_pub.add('payer instr assignment invalid ' || p_trxn_attribs.Copy_Instr_Assign_Id || ' for channel ' || l_pmt_channel, G_LEVEL_ERROR,l_dbg_mod);
2416: --END IF;
2417: --x_response.Result_Code := IBY_FNDCPT_SETUP_PUB.G_RC_INVALID_INSTR_ASSIGN;
2418: --iby_fndcpt_common_pub.Prepare_Result (l_prev_msg_count,x_return_status,x_msg_count,x_msg_data,x_response);
2419: --RETURN;
2420: --END IF;
2421: --l_instr_assign_id := p_trxn_attribs.Copy_Instr_Assign_Id;

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

2431: IF(l_count <=0) THEN
2432: IF( G_LEVEL_ERROR >= G_CURRENT_RUNTIME_LEVEL) THEN
2433: iby_debug_pub.add('payer instr assignment invalid ' || l_instr_assign_id || ' for channel ' || l_pmt_channel, G_LEVEL_ERROR,l_dbg_mod);
2434: END IF;
2435: x_response.Result_Code := IBY_FNDCPT_SETUP_PUB.G_RC_INVALID_INSTR_ASSIGN;
2436: iby_fndcpt_common_pub.Prepare_Result (l_prev_msg_count,x_return_status,x_msg_count,x_msg_data,x_response);
2437: RETURN;
2438: END IF;
2439: l_instr_assign_id := p_trxn_attribs.Copy_Instr_Assign_Id;

Line 2805: l_payer_attribs IBY_FNDCPT_SETUP_PUB.PayerAttributes_rec_type;

2801: l_prev_msg_count NUMBER;
2802:
2803: l_payer_level VARCHAR2(30);
2804: l_payer_id iby_external_payers_all.ext_payer_id%TYPE;
2805: l_payer_attribs IBY_FNDCPT_SETUP_PUB.PayerAttributes_rec_type;
2806:
2807: l_copy_count NUMBER;
2808: l_auth_flag iby_trxn_extensions_v.authorized_flag%TYPE;
2809: l_instr_auth_flag iby_trxn_extensions_v.authorized_flag%TYPE;

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

2975: iby_debug_pub.add('account site use id =' || p_payer.Account_Site_Id,iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
2976: iby_debug_pub.add('org id =' || p_payer.Org_Id,iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
2977: iby_debug_pub.add('org type =' || p_payer.Org_Type,iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
2978: END IF;
2979: IBY_FNDCPT_SETUP_PUB.Get_Payer_Id(p_payer,FND_API.G_VALID_LEVEL_FULL,
2980: l_payer_level,l_payer_id,l_payer_attribs);
2981:
2982: iby_debug_pub.add('l_payer_level: '|| l_payer_level,G_LEVEL_STATEMENT,l_dbg_mod);
2983: iby_debug_pub.add('l_payer_id: '|| l_payer_id,G_LEVEL_STATEMENT,l_dbg_mod);

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

3078: IF (NVL(l_instr_auth_flag,'N') = 'Y') THEN
3079: IF( G_LEVEL_ERROR >= G_CURRENT_RUNTIME_LEVEL) THEN
3080: iby_debug_pub.add('single use instrument cannot be reused',G_LEVEL_ERROR,l_dbg_mod);
3081: END IF;
3082: x_response.Result_Code := IBY_FNDCPT_SETUP_PUB.G_RC_INVALID_INSTRUMENT;
3083: iby_fndcpt_common_pub.Prepare_Result
3084: (l_prev_msg_count,x_return_status,x_msg_count,x_msg_data,x_response);
3085: RETURN;
3086: END IF;

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

3253:
3254: -- populate the dirdeb_instruction_code column
3255: -- for settlement
3256: BEGIN
3257: IBY_FNDCPT_SETUP_PUB.Get_Trxn_Payer_Attributes(p_payer,p_payer_equivalency, l_payer_attribs);
3258:
3259: UPDATE iby_trxn_summaries_all
3260: SET dirdeb_instruction_code = l_payer_attribs.DirectDebit_BankInstruction
3261: WHERE transactionid = l_reqresp.Trxn_Id;

Line 3779: l_payer_attribs IBY_FNDCPT_SETUP_PUB.PayerAttributes_rec_type;

3775: l_prev_msg_count NUMBER;
3776:
3777: l_payer_level VARCHAR2(30);
3778: l_payer_id iby_external_payers_all.ext_payer_id%TYPE;
3779: l_payer_attribs IBY_FNDCPT_SETUP_PUB.PayerAttributes_rec_type;
3780:
3781: l_extension_count NUMBER;
3782: l_transactionid iby_fndcpt_tx_operations.transactionid%TYPE;
3783:

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

3893: FND_MSG_PUB.initialize;
3894: END IF;
3895: l_prev_msg_count := FND_MSG_PUB.Count_Msg;
3896:
3897: IBY_FNDCPT_SETUP_PUB.Get_Payer_Id(p_payer,FND_API.G_VALID_LEVEL_FULL,
3898: l_payer_level,l_payer_id,l_payer_attribs);
3899:
3900: IF (l_payer_level = IBY_FNDCPT_COMMON_PUB.G_RC_INVALID_PAYER) THEN
3901: IF( G_LEVEL_ERROR >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 5616: l_payer_attribs IBY_FNDCPT_SETUP_PUB.PayerAttributes_rec_type;

5612: l_prev_msg_count NUMBER;
5613: l_rec_mth_id NUMBER;
5614: l_payer_level VARCHAR2(30);
5615: l_payer_id iby_external_payers_all.ext_payer_id%TYPE;
5616: l_payer_attribs IBY_FNDCPT_SETUP_PUB.PayerAttributes_rec_type;
5617: l_settled_flag VARCHAR2(1);
5618: l_returned_flag VARCHAR2(1);
5619: l_extension_found BOOLEAN;
5620:

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

5715: iby_debug_pub.add('account site use id =' || p_payer.Account_Site_Id,iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
5716: iby_debug_pub.add('org id =' || p_payer.Org_Id,iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
5717: iby_debug_pub.add('org type =' || p_payer.Org_Type,iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
5718:
5719: IBY_FNDCPT_SETUP_PUB.Get_Payer_Id(p_payer,FND_API.G_VALID_LEVEL_FULL,
5720: l_payer_level,l_payer_id,l_payer_attribs);
5721:
5722: iby_debug_pub.add('l_payer_level: '|| l_payer_level,G_LEVEL_STATEMENT,l_dbg_mod);
5723: iby_debug_pub.add('l_payer_id: '|| l_payer_id,G_LEVEL_STATEMENT,l_dbg_mod);

Line 6061: l_payer_attribs IBY_FNDCPT_SETUP_PUB.PayerAttributes_rec_type;

6057: l_prev_msg_count NUMBER;
6058:
6059: l_payer_level VARCHAR2(30);
6060: l_payer_id iby_external_payers_all.ext_payer_id%TYPE;
6061: l_payer_attribs IBY_FNDCPT_SETUP_PUB.PayerAttributes_rec_type;
6062: l_instrtype IBY_FNDCPT_PMT_CHNNLS_B.instrument_type%TYPE;
6063: l_encrypted VARCHAR2(1);
6064: l_code_segment_id iby_fndcpt_tx_extensions.instr_code_sec_segment_id%TYPE;
6065: l_sec_code_len iby_fndcpt_tx_extensions.instr_sec_code_length%TYPE;

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

6201: iby_debug_pub.add('account site use id =' || p_payer.Account_Site_Id,iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
6202: iby_debug_pub.add('org id =' || p_payer.Org_Id,iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
6203: iby_debug_pub.add('org type =' || p_payer.Org_Type,iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
6204:
6205: IBY_FNDCPT_SETUP_PUB.Get_Payer_Id(p_payer,FND_API.G_VALID_LEVEL_FULL,
6206: l_payer_level,l_payer_id,l_payer_attribs);
6207:
6208: iby_debug_pub.add('l_payer_level: '|| l_payer_level,G_LEVEL_STATEMENT,l_dbg_mod);
6209: iby_debug_pub.add('l_payer_id: '|| l_payer_id,G_LEVEL_STATEMENT,l_dbg_mod);