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_PAYMENTCARD_PKG dependencies on IBY_FNDCPT_COMMON_PUB

Line 161: lx_result IBY_FNDCPT_COMMON_PUB.Result_rec_type;

157:
158: lx_return_status VARCHAR2(1);
159: lx_msg_count NUMBER;
160: lx_msg_data VARCHAR2(3000);
161: lx_result IBY_FNDCPT_COMMON_PUB.Result_rec_type;
162:
163: l_addressid iby_paymentcard.addressid%TYPE;
164: l_billing_zip iby_paymentcard.billing_addr_postal_code%TYPE;
165: l_billing_terr iby_paymentcard.bill_addr_territory_code%TYPE;

Line 567: x_response OUT NOCOPY IBY_FNDCPT_COMMON_PUB.Result_rec_type

563: x_msg_count OUT NOCOPY NUMBER,
564: x_msg_data OUT NOCOPY VARCHAR2,
565: p_card_instrument IN PaymentCard_rec_type,
566: x_card_id OUT NOCOPY NUMBER,
567: x_response OUT NOCOPY IBY_FNDCPT_COMMON_PUB.Result_rec_type
568: )
569: IS
570:
571: l_api_version CONSTANT NUMBER := 1.0;

Line 576: lx_result IBY_FNDCPT_COMMON_PUB.Result_rec_type;

572: l_module CONSTANT VARCHAR2(30) := 'Create_Card';
573: l_prev_msg_count NUMBER;
574:
575: lx_result_code VARCHAR2(30);
576: lx_result IBY_FNDCPT_COMMON_PUB.Result_rec_type;
577: lx_card_rec PaymentCard_rec_type;
578:
579: l_info_only iby_paymentcard.information_only_flag%TYPE := NULL;
580:

Line 629: iby_fndcpt_common_pub.Prepare_Result

625:
626: -- validate billing address information
627: IF (NOT Validate_Card_Billing(FND_API.G_FALSE,p_card_instrument)) THEN
628: x_response.Result_Code := G_RC_INVALID_ADDRESS;
629: iby_fndcpt_common_pub.Prepare_Result
630: (l_prev_msg_count,x_return_status,x_msg_count,x_msg_data,x_response);
631: RETURN;
632: END IF;
633:

Line 679: iby_fndcpt_common_pub.Prepare_Result

675:
676: -- validate billing address information
677: IF (NOT Validate_Card_Billing(FND_API.G_TRUE,p_card_instrument)) THEN
678: x_response.Result_Code := G_RC_INVALID_ADDRESS;
679: iby_fndcpt_common_pub.Prepare_Result
680: (l_prev_msg_count,x_return_status,x_msg_count,x_msg_data,x_response);
681: RETURN;
682: END IF;
683: -- validate expiration date

Line 687: iby_fndcpt_common_pub.Prepare_Result

683: -- validate expiration date
684: IF (TRUNC(p_card_instrument.Expiration_Date,'DD') < TRUNC(SYSDATE,'DD'))
685: THEN
686: x_response.Result_Code := G_RC_INVALID_CARD_EXPIRY;
687: iby_fndcpt_common_pub.Prepare_Result
688: (l_prev_msg_count,x_return_status,x_msg_count,x_msg_data,x_response);
689: RETURN;
690: END IF;
691:

Line 716: x_response.Result_Code := NVL(lx_result_code,IBY_FNDCPT_COMMON_PUB.G_RC_SUCCESS);

712: p_card_instrument.attribute15, lx_result_code);
713: x_card_id := lx_card_rec.Card_Id;
714: END IF;
715:
716: x_response.Result_Code := NVL(lx_result_code,IBY_FNDCPT_COMMON_PUB.G_RC_SUCCESS);
717: iby_fndcpt_common_pub.Prepare_Result
718: (l_prev_msg_count,x_return_status,x_msg_count,x_msg_data,x_response);
719:
720: IF FND_API.To_Boolean(p_commit) THEN

Line 717: iby_fndcpt_common_pub.Prepare_Result

713: x_card_id := lx_card_rec.Card_Id;
714: END IF;
715:
716: x_response.Result_Code := NVL(lx_result_code,IBY_FNDCPT_COMMON_PUB.G_RC_SUCCESS);
717: iby_fndcpt_common_pub.Prepare_Result
718: (l_prev_msg_count,x_return_status,x_msg_count,x_msg_data,x_response);
719:
720: IF FND_API.To_Boolean(p_commit) THEN
721: COMMIT;

Line 750: iby_fndcpt_common_pub.Clear_Msg_Stack(l_prev_msg_count);

746: iby_debug_pub.add(debug_msg => 'In OTHERS Exception',
747: debug_level => FND_LOG.LEVEL_UNEXPECTED,
748: module => G_DEBUG_MODULE || l_module);
749:
750: iby_fndcpt_common_pub.Clear_Msg_Stack(l_prev_msg_count);
751:
752: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
753: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
754: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_module, SUBSTR(SQLERRM,1,100));

Line 779: x_response OUT NOCOPY IBY_FNDCPT_COMMON_PUB.Result_rec_type

775: x_return_status OUT NOCOPY VARCHAR2,
776: x_msg_count OUT NOCOPY NUMBER,
777: x_msg_data OUT NOCOPY VARCHAR2,
778: p_card_instrument IN PaymentCard_rec_type,
779: x_response OUT NOCOPY IBY_FNDCPT_COMMON_PUB.Result_rec_type
780: )
781: IS
782:
783: l_api_version CONSTANT NUMBER := 1.0;

Line 819: iby_fndcpt_common_pub.Prepare_Result

815: END IF;
816: -- validate billing address information
817: IF (NOT Validate_Card_Billing(FND_API.G_TRUE,p_card_instrument)) THEN
818: x_response.Result_Code := G_RC_INVALID_ADDRESS;
819: iby_fndcpt_common_pub.Prepare_Result
820: (l_prev_msg_count,x_return_status,x_msg_count,x_msg_data,x_response);
821: RETURN;
822: END IF;
823:

Line 849: NVL(lx_result_code,IBY_FNDCPT_COMMON_PUB.G_RC_SUCCESS);

845: lx_result_code);
846:
847:
848: x_response.Result_Code :=
849: NVL(lx_result_code,IBY_FNDCPT_COMMON_PUB.G_RC_SUCCESS);
850: iby_fndcpt_common_pub.Prepare_Result
851: (l_prev_msg_count,x_return_status,x_msg_count,x_msg_data,x_response);
852:
853: IF FND_API.To_Boolean(p_commit) THEN

Line 850: iby_fndcpt_common_pub.Prepare_Result

846:
847:
848: x_response.Result_Code :=
849: NVL(lx_result_code,IBY_FNDCPT_COMMON_PUB.G_RC_SUCCESS);
850: iby_fndcpt_common_pub.Prepare_Result
851: (l_prev_msg_count,x_return_status,x_msg_count,x_msg_data,x_response);
852:
853: IF FND_API.To_Boolean(p_commit) THEN
854: COMMIT;

Line 883: iby_fndcpt_common_pub.Clear_Msg_Stack(l_prev_msg_count);

879: iby_debug_pub.add(debug_msg => 'In OTHERS Exception',
880: debug_level => FND_LOG.LEVEL_UNEXPECTED,
881: module => G_DEBUG_MODULE || l_module);
882:
883: iby_fndcpt_common_pub.Clear_Msg_Stack(l_prev_msg_count);
884:
885: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
886: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
887: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_module, SUBSTR(SQLERRM,1,100));

Line 1034: x_response OUT NOCOPY IBY_FNDCPT_COMMON_PUB.Result_rec_type,

1030: x_msg_data OUT NOCOPY VARCHAR2,
1031: p_owner_id NUMBER,
1032: p_card_number VARCHAR2,
1033: x_card_instrument OUT NOCOPY PaymentCard_rec_type,
1034: x_response OUT NOCOPY IBY_FNDCPT_COMMON_PUB.Result_rec_type,
1035: p_card_instr_type IN VARCHAR2 DEFAULT NULL
1036: )
1037: IS
1038: l_api_version CONSTANT NUMBER := 1.0;

Line 1049: lx_result IBY_FNDCPT_COMMON_PUB.Result_rec_type;

1045: lx_return_status VARCHAR2(1);
1046: lx_msg_count NUMBER;
1047: lx_msg_data VARCHAR2(200);
1048: lx_card_number iby_paymentcard.card_number%TYPE;
1049: lx_result IBY_FNDCPT_COMMON_PUB.Result_rec_type;
1050:
1051: CURSOR p_card
1052: (pi_card_owner IN iby_paymentcard.card_owner_id%TYPE
1053: )

Line 1086: iby_fndcpt_common_pub.Prepare_Result

1082: l_prev_msg_count := FND_MSG_PUB.Count_Msg;
1083:
1084: IF (lx_card_number IS NULL) THEN
1085: x_response.Result_Code := G_RC_INVALID_CARD_NUMBER;
1086: iby_fndcpt_common_pub.Prepare_Result
1087: (l_prev_msg_count,x_return_status,x_msg_count,x_msg_data,x_response);
1088: RETURN;
1089: END IF;
1090:

Line 1106: x_response.Result_Code := IBY_FNDCPT_COMMON_PUB.G_RC_SUCCESS;

1102: l_card_id,
1103: x_card_instrument,
1104: lx_result
1105: );
1106: x_response.Result_Code := IBY_FNDCPT_COMMON_PUB.G_RC_SUCCESS;
1107:
1108: iby_fndcpt_common_pub.Prepare_Result
1109: (l_prev_msg_count,x_return_status,x_msg_count,x_msg_data,x_response);
1110:

Line 1108: iby_fndcpt_common_pub.Prepare_Result

1104: lx_result
1105: );
1106: x_response.Result_Code := IBY_FNDCPT_COMMON_PUB.G_RC_SUCCESS;
1107:
1108: iby_fndcpt_common_pub.Prepare_Result
1109: (l_prev_msg_count,x_return_status,x_msg_count,x_msg_data,x_response);
1110:
1111: EXCEPTION
1112:

Line 1137: iby_fndcpt_common_pub.Clear_Msg_Stack(l_prev_msg_count);

1133: iby_debug_pub.add(debug_msg => 'In OTHERS Exception',
1134: debug_level => FND_LOG.LEVEL_UNEXPECTED,
1135: module => G_DEBUG_MODULE || l_module);
1136:
1137: iby_fndcpt_common_pub.Clear_Msg_Stack(l_prev_msg_count);
1138:
1139: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1140: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1141: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_module, SUBSTR(SQLERRM,1,100));

Line 1165: x_response OUT NOCOPY IBY_FNDCPT_COMMON_PUB.Result_rec_type

1161: x_msg_count OUT NOCOPY NUMBER,
1162: x_msg_data OUT NOCOPY VARCHAR2,
1163: p_card_id NUMBER,
1164: x_card_instrument OUT NOCOPY PaymentCard_rec_type,
1165: x_response OUT NOCOPY IBY_FNDCPT_COMMON_PUB.Result_rec_type
1166: )
1167: IS
1168: l_api_version CONSTANT NUMBER := 1.0;
1169: l_module CONSTANT VARCHAR2(30) := 'Get_Card';

Line 1217: x_response.Result_Code := IBY_FNDCPT_COMMON_PUB.G_RC_SUCCESS;

1213:
1214: IF (p_card%NOTFOUND) THEN
1215: x_response.Result_Code := G_RC_INVALID_CARD_ID;
1216: ELSE
1217: x_response.Result_Code := IBY_FNDCPT_COMMON_PUB.G_RC_SUCCESS;
1218: x_card_instrument.Card_Id := p_card_id;
1219: END IF;
1220:
1221: iby_fndcpt_common_pub.Prepare_Result

Line 1221: iby_fndcpt_common_pub.Prepare_Result

1217: x_response.Result_Code := IBY_FNDCPT_COMMON_PUB.G_RC_SUCCESS;
1218: x_card_instrument.Card_Id := p_card_id;
1219: END IF;
1220:
1221: iby_fndcpt_common_pub.Prepare_Result
1222: (l_prev_msg_count,x_return_status,x_msg_count,x_msg_data,x_response);
1223:
1224: EXCEPTION
1225:

Line 1250: iby_fndcpt_common_pub.Clear_Msg_Stack(l_prev_msg_count);

1246: iby_debug_pub.add(debug_msg => 'In OTHERS Exception',
1247: debug_level => FND_LOG.LEVEL_UNEXPECTED,
1248: module => G_DEBUG_MODULE || l_module);
1249:
1250: iby_fndcpt_common_pub.Clear_Msg_Stack(l_prev_msg_count);
1251:
1252: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1253: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1254: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_module, SUBSTR(SQLERRM,1,100));