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 FND_API

Line 378: (1.0, FND_API.G_FALSE, l_return_status, l_msg_count, l_msg_data,

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
382: RETURN FALSE;

Line 392: OR (p_trxn_attribs.Instrument_Security_Code = FND_API.G_MISS_CHAR)

388: ( ((p_trxn_attribs.Instrument_Security_Code IS NULL)
389: AND (NOT p_update)
390: AND (NOT p_consumed_cvv2)
391: )
392: OR (p_trxn_attribs.Instrument_Security_Code = FND_API.G_MISS_CHAR)
393: )
394: )
395: THEN
396: RETURN FALSE;

Line 401: (p_trxn_attribs.Instrument_security_Code = FND_API.G_MISS_CHAR)

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: )
404: THEN
405: RETURN FALSE;

Line 411: OR (p_trxn_attribs.VoiceAuth_Flag = FND_API.G_MISS_CHAR) )

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
414: RETURN FALSE;
415: END IF;

Line 420: (p_trxn_attribs.VoiceAuth_Flag = FND_API.G_MISS_CHAR)

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: )
423: THEN
424: RETURN FALSE;

Line 430: OR (p_trxn_attribs.VoiceAuth_Code = FND_API.G_MISS_CHAR)

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: )
433: THEN
434: RETURN FALSE;

Line 439: (p_trxn_attribs.VoiceAuth_Code = FND_API.G_MISS_CHAR)

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: )
442: THEN
443: RETURN FALSE;

Line 449: (p_trxn_attribs.VoiceAuth_Date = FND_API.G_MISS_DATE) )

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
452: RETURN FALSE;
453: END IF;

Line 457: (p_trxn_attribs.VoiceAuth_Date = FND_API.G_MISS_DATE)

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: )
460: THEN
461: RETURN FALSE;

Line 467: OR (p_trxn_attribs.PO_Number = FND_API.G_MISS_CHAR) )

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
470: RETURN FALSE;
471: END IF;

Line 475: (p_trxn_attribs.PO_Number = FND_API.G_MISS_CHAR)

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: )
478: THEN
479: RETURN FALSE;

Line 485: OR (p_trxn_attribs.PO_Line_Number = FND_API.G_MISS_CHAR) )

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
488: RETURN FALSE;
489: END IF;

Line 493: (p_trxn_attribs.PO_Line_Number = FND_API.G_MISS_CHAR)

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: )
496: THEN
497: RETURN FALSE;

Line 503: OR (p_trxn_attribs.Additional_Info = FND_API.G_MISS_CHAR) )

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
506: RETURN FALSE;
507: END IF;

Line 511: (p_trxn_attribs.Additional_Info = FND_API.G_MISS_CHAR)

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: )
514: THEN
515: RETURN FALSE;

Line 519: (p_trxn_attribs.Order_id = FND_API.G_MISS_CHAR)

515: RETURN FALSE;
516: END IF;
517:
518: IF ( (p_trxn_attribs.Order_Id IS NULL AND (NOT p_update)) OR
519: (p_trxn_attribs.Order_id = FND_API.G_MISS_CHAR)
520: )
521: THEN
522: RETURN FALSE;
523: END IF;

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

802:
803: PROCEDURE Create_Transaction_Extension
804: (
805: p_api_version IN NUMBER,
806: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
807: p_commit IN VARCHAR2 := FND_API.G_TRUE,
808: x_return_status OUT NOCOPY VARCHAR2,
809: x_msg_count OUT NOCOPY NUMBER,
810: x_msg_data OUT NOCOPY VARCHAR2,

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

803: PROCEDURE Create_Transaction_Extension
804: (
805: p_api_version IN NUMBER,
806: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
807: p_commit IN VARCHAR2 := FND_API.G_TRUE,
808: x_return_status OUT NOCOPY VARCHAR2,
809: x_msg_count OUT NOCOPY NUMBER,
810: x_msg_data OUT NOCOPY VARCHAR2,
811: p_payer IN IBY_FNDCPT_COMMON_PUB.PayerContext_rec_type,

Line 846: IF NOT FND_API.Compatible_API_Call (l_api_version,

842: BEGIN
843: iby_debug_pub.add('Enter',iby_debug_pub.G_LEVEL_PROCEDURE,l_dbg_mod);
844: -- test_debug('Create_Transaction_Extension=> Enter..');
845:
846: IF NOT FND_API.Compatible_API_Call (l_api_version,
847: p_api_version,
848: l_module,
849: G_PKG_NAME)
850: THEN

Line 856: RAISE FND_API.G_EXC_ERROR;

852: debug_level => FND_LOG.LEVEL_ERROR,
853: module => G_DEBUG_MODULE || l_module);
854: FND_MESSAGE.SET_NAME('IBY', 'IBY_204400_API_VER_MISMATCH');
855: FND_MSG_PUB.Add;
856: RAISE FND_API.G_EXC_ERROR;
857: END IF;
858:
859: IF FND_API.to_Boolean( p_init_msg_list ) THEN
860: FND_MSG_PUB.initialize;

Line 859: IF FND_API.to_Boolean( p_init_msg_list ) THEN

855: FND_MSG_PUB.Add;
856: RAISE FND_API.G_EXC_ERROR;
857: END IF;
858:
859: IF FND_API.to_Boolean( p_init_msg_list ) THEN
860: FND_MSG_PUB.initialize;
861: END IF;
862: l_prev_msg_count := FND_MSG_PUB.Count_Msg;
863:

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 952: (1.0, FND_API.G_FALSE, FND_API.G_FALSE,

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: );
956:

Line 969: (p_trxn_attribs.Instrument_security_Code = FND_API.G_MISS_CHAR))

965:
966: -- PABP: For IMMEDIATE mode of encryption, make an http callout --
967: -- to the ECApp and encrypt the CVV value --
968: IF (NOT ((p_trxn_attribs.Instrument_Security_Code IS NULL) OR
969: (p_trxn_attribs.Instrument_security_Code = FND_API.G_MISS_CHAR))
970: ) THEN
971: IF ('IMMEDIATE' = IBY_CREDITCARD_PKG.Get_CC_Encrypt_Mode()) THEN
972: -- Make an HTTP call out to the middle tier
973: -- test_debug('calling secure_extension..');

Line 975: (FND_API.G_FALSE,

971: IF ('IMMEDIATE' = IBY_CREDITCARD_PKG.Get_CC_Encrypt_Mode()) THEN
972: -- Make an HTTP call out to the middle tier
973: -- test_debug('calling secure_extension..');
974: IBY_PAYMENT_ADAPTER_PUB.OraSecureExtension
975: (FND_API.G_FALSE,
976: p_trxn_attribs.Instrument_security_Code,
977: l_return_status,
978: l_msg_count,
979: l_msg_data,

Line 1045: IF FND_API.To_Boolean(p_commit) THEN

1041:
1042: iby_fndcpt_common_pub.Prepare_Result
1043: (l_prev_msg_count,x_return_status,x_msg_count,x_msg_data,x_response);
1044:
1045: IF FND_API.To_Boolean(p_commit) THEN
1046: COMMIT;
1047: END IF;
1048:
1049: iby_debug_pub.add('Exit',iby_debug_pub.G_LEVEL_PROCEDURE,l_dbg_mod);

Line 1053: WHEN FND_API.G_EXC_ERROR THEN

1049: iby_debug_pub.add('Exit',iby_debug_pub.G_LEVEL_PROCEDURE,l_dbg_mod);
1050:
1051: EXCEPTION
1052:
1053: WHEN FND_API.G_EXC_ERROR THEN
1054:
1055: iby_debug_pub.add(debug_msg => 'In G_EXC_ERROR Exception',
1056: debug_level => FND_LOG.LEVEL_ERROR,
1057: module => G_DEBUG_MODULE || l_module);

Line 1058: x_return_status := FND_API.G_RET_STS_ERROR;

1054:
1055: iby_debug_pub.add(debug_msg => 'In G_EXC_ERROR Exception',
1056: debug_level => FND_LOG.LEVEL_ERROR,
1057: module => G_DEBUG_MODULE || l_module);
1058: x_return_status := FND_API.G_RET_STS_ERROR;
1059: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
1060: p_data => x_msg_data
1061: );
1062: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1062: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1058: x_return_status := FND_API.G_RET_STS_ERROR;
1059: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
1060: p_data => x_msg_data
1061: );
1062: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1063:
1064: iby_debug_pub.add(debug_msg => 'In G_EXC_UNEXPECTED_ERROR Exception',
1065: debug_level => FND_LOG.LEVEL_UNEXPECTED,
1066: module => G_DEBUG_MODULE || l_module);

Line 1067: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

Line 1079: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1075: module => G_DEBUG_MODULE || l_module);
1076:
1077: iby_fndcpt_common_pub.Clear_Msg_Stack(l_prev_msg_count);
1078:
1079: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1080: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1081: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_module, SUBSTR(SQLERRM,1,100));
1082: END IF;
1083: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

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

1088:
1089: PROCEDURE Update_Transaction_Extension
1090: (
1091: p_api_version IN NUMBER,
1092: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1093: p_commit IN VARCHAR2 := FND_API.G_TRUE,
1094: x_return_status OUT NOCOPY VARCHAR2,
1095: x_msg_count OUT NOCOPY NUMBER,
1096: x_msg_data OUT NOCOPY VARCHAR2,

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

1089: PROCEDURE Update_Transaction_Extension
1090: (
1091: p_api_version IN NUMBER,
1092: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1093: p_commit IN VARCHAR2 := FND_API.G_TRUE,
1094: x_return_status OUT NOCOPY VARCHAR2,
1095: x_msg_count OUT NOCOPY NUMBER,
1096: x_msg_data OUT NOCOPY VARCHAR2,
1097: p_payer IN IBY_FNDCPT_COMMON_PUB.PayerContext_rec_type,

Line 1164: IF NOT FND_API.Compatible_API_Call (l_api_version,

1160: -- test_debug('update_extension called..');
1161:
1162: IF (c_extension%ISOPEN) THEN CLOSE c_extension; END IF;
1163:
1164: IF NOT FND_API.Compatible_API_Call (l_api_version,
1165: p_api_version,
1166: l_module,
1167: G_PKG_NAME)
1168: THEN

Line 1174: RAISE FND_API.G_EXC_ERROR;

1170: debug_level => FND_LOG.LEVEL_ERROR,
1171: module => G_DEBUG_MODULE || l_module);
1172: FND_MESSAGE.SET_NAME('IBY', 'IBY_204400_API_VER_MISMATCH');
1173: FND_MSG_PUB.Add;
1174: RAISE FND_API.G_EXC_ERROR;
1175: END IF;
1176:
1177: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1178: FND_MSG_PUB.initialize;

Line 1177: IF FND_API.to_Boolean( p_init_msg_list ) THEN

1173: FND_MSG_PUB.Add;
1174: RAISE FND_API.G_EXC_ERROR;
1175: END IF;
1176:
1177: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1178: FND_MSG_PUB.initialize;
1179: END IF;
1180: l_prev_msg_count := FND_MSG_PUB.Count_Msg;
1181:

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 1216: IF (p_instr_assignment = FND_API.G_MISS_NUM) THEN

1212: RETURN;
1213: END IF;
1214:
1215: l_pmt_channel := NVL(p_pmt_channel,l_pmt_channel);
1216: IF (p_instr_assignment = FND_API.G_MISS_NUM) THEN
1217: l_instr_assign := NULL;
1218: ELSIF (NOT p_instr_assignment IS NULL) THEN
1219: l_instr_ASSIGN := p_instr_assignment;
1220: END IF;

Line 1276: (p_trxn_attribs.Instrument_security_Code = FND_API.G_MISS_CHAR))

1272:
1273: -- PABP: For IMMEDIATE mode of encryption, make an http callout --
1274: -- to the ECApp and encrypt the CVV value --
1275: IF (NOT ((p_trxn_attribs.Instrument_Security_Code IS NULL) OR
1276: (p_trxn_attribs.Instrument_security_Code = FND_API.G_MISS_CHAR))
1277: ) THEN
1278: IF ('IMMEDIATE' = IBY_CREDITCARD_PKG.Get_CC_Encrypt_Mode()) THEN
1279: -- Make an HTTP call out to the middle tier
1280: -- test_debug('calling secure_extension..');

Line 1282: (FND_API.G_FALSE,

1278: IF ('IMMEDIATE' = IBY_CREDITCARD_PKG.Get_CC_Encrypt_Mode()) THEN
1279: -- Make an HTTP call out to the middle tier
1280: -- test_debug('calling secure_extension..');
1281: IBY_PAYMENT_ADAPTER_PUB.OraSecureExtension
1282: (FND_API.G_FALSE,
1283: p_trxn_attribs.Instrument_security_Code,
1284: l_return_status,
1285: l_msg_count,
1286: l_msg_data,

Line 1327: DECODE(p_instr_assignment, FND_API.G_MISS_NUM,NULL,

1323: UPDATE iby_fndcpt_tx_extensions
1324: SET
1325: payment_channel_code = NVL(p_pmt_channel,payment_channel_code),
1326: instr_assignment_id =
1327: DECODE(p_instr_assignment, FND_API.G_MISS_NUM,NULL,
1328: NULL,instr_assignment_id, p_instr_assignment),
1329: origin_application_id =
1330: NVL(p_trxn_attribs.Originating_Application_Id,
1331: origin_application_id),

Line 1334: FND_API.G_MISS_CHAR,NULL, NULL,instrument_security_code,

1330: NVL(p_trxn_attribs.Originating_Application_Id,
1331: origin_application_id),
1332: instrument_security_code =
1333: DECODE(p_trxn_attribs.Instrument_Security_Code,
1334: FND_API.G_MISS_CHAR,NULL, NULL,instrument_security_code,
1335: l_sec_code),
1336: instr_sec_code_length =
1337: length(DECODE(p_trxn_attribs.Instrument_Security_Code,
1338: FND_API.G_MISS_CHAR,NULL,

Line 1338: FND_API.G_MISS_CHAR,NULL,

1334: FND_API.G_MISS_CHAR,NULL, NULL,instrument_security_code,
1335: l_sec_code),
1336: instr_sec_code_length =
1337: length(DECODE(p_trxn_attribs.Instrument_Security_Code,
1338: FND_API.G_MISS_CHAR,NULL,
1339: NULL,instrument_security_code,
1340: l_sec_code)
1341: ),
1342: encrypted =

Line 1344: FND_API.G_MISS_CHAR,'N', NULL,encrypted, l_encrypted),

1340: l_sec_code)
1341: ),
1342: encrypted =
1343: DECODE(p_trxn_attribs.Instrument_Security_Code,
1344: FND_API.G_MISS_CHAR,'N', NULL,encrypted, l_encrypted),
1345: instr_code_sec_segment_id =
1346: NVL(l_segment_id, instr_code_sec_segment_id),
1347: voice_authorization_flag =
1348: DECODE(p_trxn_attribs.VoiceAuth_Flag, FND_API.G_MISS_CHAR,NULL,

Line 1348: DECODE(p_trxn_attribs.VoiceAuth_Flag, FND_API.G_MISS_CHAR,NULL,

1344: FND_API.G_MISS_CHAR,'N', NULL,encrypted, l_encrypted),
1345: instr_code_sec_segment_id =
1346: NVL(l_segment_id, instr_code_sec_segment_id),
1347: voice_authorization_flag =
1348: DECODE(p_trxn_attribs.VoiceAuth_Flag, FND_API.G_MISS_CHAR,NULL,
1349: NULL,voice_authorization_flag, p_trxn_attribs.VoiceAuth_Flag),
1350: voice_authorization_date =
1351: DECODE(p_trxn_attribs.VoiceAuth_Date, FND_API.G_MISS_DATE,NULL,
1352: NULL,voice_authorization_date, p_trxn_attribs.VoiceAuth_Date),

Line 1351: DECODE(p_trxn_attribs.VoiceAuth_Date, FND_API.G_MISS_DATE,NULL,

1347: voice_authorization_flag =
1348: DECODE(p_trxn_attribs.VoiceAuth_Flag, FND_API.G_MISS_CHAR,NULL,
1349: NULL,voice_authorization_flag, p_trxn_attribs.VoiceAuth_Flag),
1350: voice_authorization_date =
1351: DECODE(p_trxn_attribs.VoiceAuth_Date, FND_API.G_MISS_DATE,NULL,
1352: NULL,voice_authorization_date, p_trxn_attribs.VoiceAuth_Date),
1353: voice_authorization_code =
1354: DECODE(p_trxn_attribs.VoiceAuth_Code, FND_API.G_MISS_CHAR,NULL,
1355: NULL,voice_authorization_code, p_trxn_attribs.VoiceAuth_Code),

Line 1354: DECODE(p_trxn_attribs.VoiceAuth_Code, FND_API.G_MISS_CHAR,NULL,

1350: voice_authorization_date =
1351: DECODE(p_trxn_attribs.VoiceAuth_Date, FND_API.G_MISS_DATE,NULL,
1352: NULL,voice_authorization_date, p_trxn_attribs.VoiceAuth_Date),
1353: voice_authorization_code =
1354: DECODE(p_trxn_attribs.VoiceAuth_Code, FND_API.G_MISS_CHAR,NULL,
1355: NULL,voice_authorization_code, p_trxn_attribs.VoiceAuth_Code),
1356: order_id = NVL(p_trxn_attribs.Order_Id, order_id),
1357: po_number = DECODE(p_trxn_attribs.PO_Number, FND_API.G_MISS_CHAR,NULL,
1358: NULL,po_number, p_trxn_attribs.PO_Number),

Line 1357: po_number = DECODE(p_trxn_attribs.PO_Number, FND_API.G_MISS_CHAR,NULL,

1353: voice_authorization_code =
1354: DECODE(p_trxn_attribs.VoiceAuth_Code, FND_API.G_MISS_CHAR,NULL,
1355: NULL,voice_authorization_code, p_trxn_attribs.VoiceAuth_Code),
1356: order_id = NVL(p_trxn_attribs.Order_Id, order_id),
1357: po_number = DECODE(p_trxn_attribs.PO_Number, FND_API.G_MISS_CHAR,NULL,
1358: NULL,po_number, p_trxn_attribs.PO_Number),
1359: po_line_number = DECODE(p_trxn_attribs.PO_Line_Number,
1360: FND_API.G_MISS_CHAR,NULL, NULL,po_line_number,
1361: p_trxn_attribs.PO_Line_Number),

Line 1360: FND_API.G_MISS_CHAR,NULL, NULL,po_line_number,

1356: order_id = NVL(p_trxn_attribs.Order_Id, order_id),
1357: po_number = DECODE(p_trxn_attribs.PO_Number, FND_API.G_MISS_CHAR,NULL,
1358: NULL,po_number, p_trxn_attribs.PO_Number),
1359: po_line_number = DECODE(p_trxn_attribs.PO_Line_Number,
1360: FND_API.G_MISS_CHAR,NULL, NULL,po_line_number,
1361: p_trxn_attribs.PO_Line_Number),
1362: trxn_ref_number1 = DECODE(p_trxn_attribs.Trxn_Ref_Number1,
1363: FND_API.G_MISS_CHAR,NULL, NULL,trxn_ref_number1,
1364: p_trxn_attribs.Trxn_Ref_Number1),

Line 1363: FND_API.G_MISS_CHAR,NULL, NULL,trxn_ref_number1,

1359: po_line_number = DECODE(p_trxn_attribs.PO_Line_Number,
1360: FND_API.G_MISS_CHAR,NULL, NULL,po_line_number,
1361: p_trxn_attribs.PO_Line_Number),
1362: trxn_ref_number1 = DECODE(p_trxn_attribs.Trxn_Ref_Number1,
1363: FND_API.G_MISS_CHAR,NULL, NULL,trxn_ref_number1,
1364: p_trxn_attribs.Trxn_Ref_Number1),
1365: trxn_ref_number2 = DECODE(p_trxn_attribs.Trxn_Ref_Number2,
1366: FND_API.G_MISS_CHAR,NULL, NULL,trxn_ref_number2,
1367: p_trxn_attribs.Trxn_Ref_Number2),

Line 1366: FND_API.G_MISS_CHAR,NULL, NULL,trxn_ref_number2,

1362: trxn_ref_number1 = DECODE(p_trxn_attribs.Trxn_Ref_Number1,
1363: FND_API.G_MISS_CHAR,NULL, NULL,trxn_ref_number1,
1364: p_trxn_attribs.Trxn_Ref_Number1),
1365: trxn_ref_number2 = DECODE(p_trxn_attribs.Trxn_Ref_Number2,
1366: FND_API.G_MISS_CHAR,NULL, NULL,trxn_ref_number2,
1367: p_trxn_attribs.Trxn_Ref_Number2),
1368: additional_info = DECODE(p_trxn_attribs.Additional_Info,
1369: FND_API.G_MISS_CHAR,NULL, NULL,additional_info,
1370: p_trxn_attribs.Additional_Info),

Line 1369: FND_API.G_MISS_CHAR,NULL, NULL,additional_info,

1365: trxn_ref_number2 = DECODE(p_trxn_attribs.Trxn_Ref_Number2,
1366: FND_API.G_MISS_CHAR,NULL, NULL,trxn_ref_number2,
1367: p_trxn_attribs.Trxn_Ref_Number2),
1368: additional_info = DECODE(p_trxn_attribs.Additional_Info,
1369: FND_API.G_MISS_CHAR,NULL, NULL,additional_info,
1370: p_trxn_attribs.Additional_Info),
1371: last_updated_by = fnd_global.user_id,
1372: last_update_date = SYSDATE,
1373: last_update_login = fnd_global.login_id,

Line 1380: (p_trxn_attribs.Instrument_Security_Code <> FND_API.G_MISS_CHAR)

1376:
1377: iby_debug_pub.add('updating extension',
1378: iby_debug_pub.G_LEVEL_ERROR,l_dbg_mod);
1379: IF (NOT p_trxn_attribs.Instrument_Security_Code IS NULL) AND
1380: (p_trxn_attribs.Instrument_Security_Code <> FND_API.G_MISS_CHAR)
1381: THEN
1382: DELETE FROM iby_security_segments
1383: WHERE (sec_segment_id = l_segment_id);
1384: END IF;

Line 1393: IF FND_API.To_Boolean(p_commit) THEN

1389: x_response.Result_Code := G_RC_INVALID_EXTENSION_ID;
1390: END IF;
1391: END IF;
1392:
1393: IF FND_API.To_Boolean(p_commit) THEN
1394: COMMIT;
1395: END IF;
1396:
1397: iby_fndcpt_common_pub.Prepare_Result

Line 1404: WHEN FND_API.G_EXC_ERROR THEN

1400: iby_debug_pub.add('Exit',iby_debug_pub.G_LEVEL_PROCEDURE,l_dbg_mod);
1401:
1402: EXCEPTION
1403:
1404: WHEN FND_API.G_EXC_ERROR THEN
1405:
1406: iby_debug_pub.add(debug_msg => 'In G_EXC_ERROR Exception',
1407: debug_level => FND_LOG.LEVEL_ERROR,
1408: module => G_DEBUG_MODULE || l_module);

Line 1409: x_return_status := FND_API.G_RET_STS_ERROR;

1405:
1406: iby_debug_pub.add(debug_msg => 'In G_EXC_ERROR Exception',
1407: debug_level => FND_LOG.LEVEL_ERROR,
1408: module => G_DEBUG_MODULE || l_module);
1409: x_return_status := FND_API.G_RET_STS_ERROR;
1410: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
1411: p_data => x_msg_data
1412: );
1413: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1413: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1409: x_return_status := FND_API.G_RET_STS_ERROR;
1410: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
1411: p_data => x_msg_data
1412: );
1413: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1414:
1415: iby_debug_pub.add(debug_msg => 'In G_EXC_UNEXPECTED_ERROR Exception',
1416: debug_level => FND_LOG.LEVEL_UNEXPECTED,
1417: module => G_DEBUG_MODULE || l_module);

Line 1418: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1414:
1415: iby_debug_pub.add(debug_msg => 'In G_EXC_UNEXPECTED_ERROR Exception',
1416: debug_level => FND_LOG.LEVEL_UNEXPECTED,
1417: module => G_DEBUG_MODULE || l_module);
1418: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1419: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
1420: p_data => x_msg_data
1421: );
1422: WHEN OTHERS THEN

Line 1430: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1426: module => G_DEBUG_MODULE || l_module);
1427:
1428: iby_fndcpt_common_pub.Clear_Msg_Stack(l_prev_msg_count);
1429:
1430: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1431: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1432: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_module, SUBSTR(SQLERRM,1,100));
1433: END IF;
1434:

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

1441:
1442: PROCEDURE Get_Transaction_Extension
1443: (
1444: p_api_version IN NUMBER,
1445: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1446: x_return_status OUT NOCOPY VARCHAR2,
1447: x_msg_count OUT NOCOPY NUMBER,
1448: x_msg_data OUT NOCOPY VARCHAR2,
1449: p_payer IN IBY_FNDCPT_COMMON_PUB.PayerContext_rec_type,

Line 1483: IF NOT FND_API.Compatible_API_Call (l_api_version,

1479: IF (c_extension%ISOPEN) THEN
1480: CLOSE c_extension;
1481: END IF;
1482:
1483: IF NOT FND_API.Compatible_API_Call (l_api_version,
1484: p_api_version,
1485: l_module,
1486: G_PKG_NAME)
1487: THEN

Line 1493: RAISE FND_API.G_EXC_ERROR;

1489: debug_level => FND_LOG.LEVEL_ERROR,
1490: module => G_DEBUG_MODULE || l_module);
1491: FND_MESSAGE.SET_NAME('IBY', 'IBY_204400_API_VER_MISMATCH');
1492: FND_MSG_PUB.Add;
1493: RAISE FND_API.G_EXC_ERROR;
1494: END IF;
1495:
1496: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1497: FND_MSG_PUB.initialize;

Line 1496: IF FND_API.to_Boolean( p_init_msg_list ) THEN

1492: FND_MSG_PUB.Add;
1493: RAISE FND_API.G_EXC_ERROR;
1494: END IF;
1495:
1496: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1497: FND_MSG_PUB.initialize;
1498: END IF;
1499: l_prev_msg_count := FND_MSG_PUB.Count_Msg;
1500:

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 1535: WHEN FND_API.G_EXC_ERROR THEN

1531:
1532: iby_debug_pub.add('Exit',iby_debug_pub.G_LEVEL_PROCEDURE,l_dbg_mod);
1533: EXCEPTION
1534:
1535: WHEN FND_API.G_EXC_ERROR THEN
1536:
1537: iby_debug_pub.add(debug_msg => 'In G_EXC_ERROR Exception',
1538: debug_level => FND_LOG.LEVEL_ERROR,
1539: module => G_DEBUG_MODULE || l_module);

Line 1540: x_return_status := FND_API.G_RET_STS_ERROR;

1536:
1537: iby_debug_pub.add(debug_msg => 'In G_EXC_ERROR Exception',
1538: debug_level => FND_LOG.LEVEL_ERROR,
1539: module => G_DEBUG_MODULE || l_module);
1540: x_return_status := FND_API.G_RET_STS_ERROR;
1541: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
1542: p_data => x_msg_data
1543: );
1544: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1544: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1540: x_return_status := FND_API.G_RET_STS_ERROR;
1541: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
1542: p_data => x_msg_data
1543: );
1544: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1545:
1546: iby_debug_pub.add(debug_msg => 'In G_EXC_UNEXPECTED_ERROR Exception',
1547: debug_level => FND_LOG.LEVEL_UNEXPECTED,
1548: module => G_DEBUG_MODULE || l_module);

Line 1549: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1545:
1546: iby_debug_pub.add(debug_msg => 'In G_EXC_UNEXPECTED_ERROR Exception',
1547: debug_level => FND_LOG.LEVEL_UNEXPECTED,
1548: module => G_DEBUG_MODULE || l_module);
1549: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1550: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
1551: p_data => x_msg_data
1552: );
1553: WHEN OTHERS THEN

Line 1561: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1557: module => G_DEBUG_MODULE || l_module);
1558:
1559: iby_fndcpt_common_pub.Clear_Msg_Stack(l_prev_msg_count);
1560:
1561: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1562: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1563: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_module, SUBSTR(SQLERRM,1,100));
1564: END IF;
1565:

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

1579:
1580: PROCEDURE Delete_Transaction_Extension
1581: (
1582: p_api_version IN NUMBER,
1583: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1584: p_commit IN VARCHAR2 := FND_API.G_TRUE,
1585: x_return_status OUT NOCOPY VARCHAR2,
1586: x_msg_count OUT NOCOPY NUMBER,
1587: x_msg_data OUT NOCOPY VARCHAR2,

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

1580: PROCEDURE Delete_Transaction_Extension
1581: (
1582: p_api_version IN NUMBER,
1583: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1584: p_commit IN VARCHAR2 := FND_API.G_TRUE,
1585: x_return_status OUT NOCOPY VARCHAR2,
1586: x_msg_count OUT NOCOPY NUMBER,
1587: x_msg_data OUT NOCOPY VARCHAR2,
1588: p_payer IN IBY_FNDCPT_COMMON_PUB.PayerContext_rec_type,

Line 1635: IF NOT FND_API.Compatible_API_Call (l_api_version,

1631: IF (c_extension%ISOPEN) THEN
1632: CLOSE c_extension;
1633: END IF;
1634:
1635: IF NOT FND_API.Compatible_API_Call (l_api_version,
1636: p_api_version,
1637: l_module,
1638: G_PKG_NAME)
1639: THEN

Line 1645: RAISE FND_API.G_EXC_ERROR;

1641: debug_level => FND_LOG.LEVEL_ERROR,
1642: module => G_DEBUG_MODULE || l_module);
1643: FND_MESSAGE.SET_NAME('IBY', 'IBY_204400_API_VER_MISMATCH');
1644: FND_MSG_PUB.Add;
1645: RAISE FND_API.G_EXC_ERROR;
1646: END IF;
1647:
1648: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1649: FND_MSG_PUB.initialize;

Line 1648: IF FND_API.to_Boolean( p_init_msg_list ) THEN

1644: FND_MSG_PUB.Add;
1645: RAISE FND_API.G_EXC_ERROR;
1646: END IF;
1647:
1648: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1649: FND_MSG_PUB.initialize;
1650: END IF;
1651: l_prev_msg_count := FND_MSG_PUB.Count_Msg;
1652:

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 1691: IF FND_API.To_Boolean(p_commit) THEN

1687: END IF;
1688: CLOSE c_extension;
1689: END IF;
1690:
1691: IF FND_API.To_Boolean(p_commit) THEN
1692: COMMIT;
1693: END IF;
1694:
1695: iby_fndcpt_common_pub.Prepare_Result

Line 1701: WHEN FND_API.G_EXC_ERROR THEN

1697:
1698: iby_debug_pub.add('Exit',iby_debug_pub.G_LEVEL_PROCEDURE,l_dbg_mod);
1699: EXCEPTION
1700:
1701: WHEN FND_API.G_EXC_ERROR THEN
1702: ROLLBACK TO Delete_Transaction_Extension;
1703: iby_debug_pub.add(debug_msg => 'In G_EXC_ERROR Exception',
1704: debug_level => FND_LOG.LEVEL_ERROR,
1705: module => G_DEBUG_MODULE || l_module);

Line 1706: x_return_status := FND_API.G_RET_STS_ERROR;

1702: ROLLBACK TO Delete_Transaction_Extension;
1703: iby_debug_pub.add(debug_msg => 'In G_EXC_ERROR Exception',
1704: debug_level => FND_LOG.LEVEL_ERROR,
1705: module => G_DEBUG_MODULE || l_module);
1706: x_return_status := FND_API.G_RET_STS_ERROR;
1707: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
1708: p_data => x_msg_data
1709: );
1710: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1710: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1706: x_return_status := FND_API.G_RET_STS_ERROR;
1707: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
1708: p_data => x_msg_data
1709: );
1710: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1711: ROLLBACK TO Delete_Transaction_Extension;
1712: iby_debug_pub.add(debug_msg => 'In G_EXC_UNEXPECTED_ERROR Exception',
1713: debug_level => FND_LOG.LEVEL_UNEXPECTED,
1714: module => G_DEBUG_MODULE || l_module);

Line 1715: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1711: ROLLBACK TO Delete_Transaction_Extension;
1712: iby_debug_pub.add(debug_msg => 'In G_EXC_UNEXPECTED_ERROR Exception',
1713: debug_level => FND_LOG.LEVEL_UNEXPECTED,
1714: module => G_DEBUG_MODULE || l_module);
1715: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1716: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
1717: p_data => x_msg_data
1718: );
1719:

Line 1728: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1724: module => G_DEBUG_MODULE || l_module);
1725:
1726: iby_fndcpt_common_pub.Clear_Msg_Stack(l_prev_msg_count);
1727:
1728: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1729: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1730: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_module, SUBSTR(SQLERRM,1,100));
1731: END IF;
1732:

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

1745:
1746: PROCEDURE Copy_Transaction_Extension
1747: (
1748: p_api_version IN NUMBER,
1749: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1750: p_commit IN VARCHAR2 := FND_API.G_TRUE,
1751: x_return_status OUT NOCOPY VARCHAR2,
1752: x_msg_count OUT NOCOPY NUMBER,
1753: x_msg_data OUT NOCOPY VARCHAR2,

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

1746: PROCEDURE Copy_Transaction_Extension
1747: (
1748: p_api_version IN NUMBER,
1749: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1750: p_commit IN VARCHAR2 := FND_API.G_TRUE,
1751: x_return_status OUT NOCOPY VARCHAR2,
1752: x_msg_count OUT NOCOPY NUMBER,
1753: x_msg_data OUT NOCOPY VARCHAR2,
1754: p_payer IN IBY_FNDCPT_COMMON_PUB.PayerContext_rec_type,

Line 1867: IF NOT FND_API.Compatible_API_Call (l_api_version,

1863:
1864: IF (c_extension%ISOPEN) THEN CLOSE c_extension; END IF;
1865: IF (c_auths%ISOPEN) THEN CLOSE c_auths; END IF;
1866:
1867: IF NOT FND_API.Compatible_API_Call (l_api_version,
1868: p_api_version,
1869: l_module,
1870: G_PKG_NAME)
1871: THEN

Line 1877: RAISE FND_API.G_EXC_ERROR;

1873: debug_level => FND_LOG.LEVEL_ERROR,
1874: module => G_DEBUG_MODULE || l_module);
1875: FND_MESSAGE.SET_NAME('IBY', 'IBY_204400_API_VER_MISMATCH');
1876: FND_MSG_PUB.Add;
1877: RAISE FND_API.G_EXC_ERROR;
1878: END IF;
1879:
1880: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1881: FND_MSG_PUB.initialize;

Line 1880: IF FND_API.to_Boolean( p_init_msg_list ) THEN

1876: FND_MSG_PUB.Add;
1877: RAISE FND_API.G_EXC_ERROR;
1878: END IF;
1879:
1880: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1881: FND_MSG_PUB.initialize;
1882: END IF;
1883: l_prev_msg_count := FND_MSG_PUB.Count_Msg;
1884:

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 1925: (1.0, FND_API.G_FALSE, FND_API.G_FALSE,

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: );
1929:

Line 2141: IF FND_API.To_Boolean(p_commit) THEN

2137:
2138: iby_fndcpt_common_pub.Prepare_Result
2139: (l_prev_msg_count,x_return_status,x_msg_count,x_msg_data,x_response);
2140:
2141: IF FND_API.To_Boolean(p_commit) THEN
2142: COMMIT;
2143: END IF;
2144:
2145: iby_debug_pub.add('Exit',iby_debug_pub.G_LEVEL_PROCEDURE,l_dbg_mod);

Line 2148: WHEN FND_API.G_EXC_ERROR THEN

2144:
2145: iby_debug_pub.add('Exit',iby_debug_pub.G_LEVEL_PROCEDURE,l_dbg_mod);
2146: EXCEPTION
2147:
2148: WHEN FND_API.G_EXC_ERROR THEN
2149: ROLLBACK TO Copy_Txn_Extension_Merge;
2150: iby_debug_pub.add(debug_msg => 'In G_EXC_ERROR Exception',
2151: debug_level => FND_LOG.LEVEL_ERROR,
2152: module => G_DEBUG_MODULE || l_module);

Line 2153: x_return_status := FND_API.G_RET_STS_ERROR;

2149: ROLLBACK TO Copy_Txn_Extension_Merge;
2150: iby_debug_pub.add(debug_msg => 'In G_EXC_ERROR Exception',
2151: debug_level => FND_LOG.LEVEL_ERROR,
2152: module => G_DEBUG_MODULE || l_module);
2153: x_return_status := FND_API.G_RET_STS_ERROR;
2154: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
2155: p_data => x_msg_data
2156: );
2157: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2157: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2153: x_return_status := FND_API.G_RET_STS_ERROR;
2154: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
2155: p_data => x_msg_data
2156: );
2157: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2158: ROLLBACK TO Copy_Txn_Extension_Merge;
2159: iby_debug_pub.add(debug_msg => 'In G_EXC_UNEXPECTED_ERROR Exception',
2160: debug_level => FND_LOG.LEVEL_UNEXPECTED,
2161: module => G_DEBUG_MODULE || l_module);

Line 2162: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2158: ROLLBACK TO Copy_Txn_Extension_Merge;
2159: iby_debug_pub.add(debug_msg => 'In G_EXC_UNEXPECTED_ERROR Exception',
2160: debug_level => FND_LOG.LEVEL_UNEXPECTED,
2161: module => G_DEBUG_MODULE || l_module);
2162: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2163: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
2164: p_data => x_msg_data
2165: );
2166:

Line 2176: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2172: module => G_DEBUG_MODULE || l_module);
2173:
2174: iby_fndcpt_common_pub.Clear_Msg_Stack(l_prev_msg_count);
2175:
2176: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2177: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2178: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_module, SUBSTR(SQLERRM,1,100));
2179: END IF;
2180:

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

2273:
2274: PROCEDURE Create_Authorization
2275: (
2276: p_api_version IN NUMBER,
2277: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2278: x_return_status OUT NOCOPY VARCHAR2,
2279: x_msg_count OUT NOCOPY NUMBER,
2280: x_msg_data OUT NOCOPY VARCHAR2,
2281: p_payer IN IBY_FNDCPT_COMMON_PUB.PayerContext_rec_type,

Line 2396: IF NOT FND_API.Compatible_API_Call (l_api_version,

2392: IF (c_auth%ISOPEN) THEN CLOSE c_auth; END IF;
2393: IF (c_instr_extensions%ISOPEN) THEN CLOSE c_instr_extensions; END IF;
2394: IF (c_operation_count%ISOPEN) THEN CLOSE c_operation_count; END IF;
2395:
2396: IF NOT FND_API.Compatible_API_Call (l_api_version,
2397: p_api_version,
2398: l_module,
2399: G_PKG_NAME)
2400: THEN

Line 2406: RAISE FND_API.G_EXC_ERROR;

2402: debug_level => FND_LOG.LEVEL_ERROR,
2403: module => G_DEBUG_MODULE || l_module);
2404: FND_MESSAGE.SET_NAME('IBY', 'IBY_204400_API_VER_MISMATCH');
2405: FND_MSG_PUB.Add;
2406: RAISE FND_API.G_EXC_ERROR;
2407: END IF;
2408:
2409: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2410: FND_MSG_PUB.initialize;

Line 2409: IF FND_API.to_Boolean( p_init_msg_list ) THEN

2405: FND_MSG_PUB.Add;
2406: RAISE FND_API.G_EXC_ERROR;
2407: END IF;
2408:
2409: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2410: FND_MSG_PUB.initialize;
2411: END IF;
2412: l_prev_msg_count := FND_MSG_PUB.Count_Msg;
2413:

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 2529: FND_API.G_FALSE,

2525: iby_debug_pub.add('send auth',iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
2526: IBY_PAYMENT_ADAPTER_PUB.OraPmtReq
2527: (1.0,
2528: p_init_msg_list,
2529: FND_API.G_FALSE,
2530: FND_API.G_VALID_LEVEL_FULL,
2531: l_ecapp_id,
2532: l_payee,
2533: l_payer,

Line 2530: FND_API.G_VALID_LEVEL_FULL,

2526: IBY_PAYMENT_ADAPTER_PUB.OraPmtReq
2527: (1.0,
2528: p_init_msg_list,
2529: FND_API.G_FALSE,
2530: FND_API.G_VALID_LEVEL_FULL,
2531: l_ecapp_id,
2532: l_payee,
2533: l_payer,
2534: l_pmt_instr,

Line 2777: WHEN FND_API.G_EXC_ERROR THEN

2773:
2774: iby_debug_pub.add('Exit',iby_debug_pub.G_LEVEL_PROCEDURE,l_dbg_mod);
2775: EXCEPTION
2776:
2777: WHEN FND_API.G_EXC_ERROR THEN
2778:
2779: iby_debug_pub.add(debug_msg => 'In G_EXC_ERROR Exception',
2780: debug_level => FND_LOG.LEVEL_ERROR,
2781: module => G_DEBUG_MODULE || l_module);

Line 2782: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 2786: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2782: x_return_status := FND_API.G_RET_STS_ERROR;
2783: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
2784: p_data => x_msg_data
2785: );
2786: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2787:
2788: iby_debug_pub.add(debug_msg => 'In G_EXC_UNEXPECTED_ERROR Exception',
2789: debug_level => FND_LOG.LEVEL_UNEXPECTED,
2790: module => G_DEBUG_MODULE || l_module);

Line 2791: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2787:
2788: iby_debug_pub.add(debug_msg => 'In G_EXC_UNEXPECTED_ERROR Exception',
2789: debug_level => FND_LOG.LEVEL_UNEXPECTED,
2790: module => G_DEBUG_MODULE || l_module);
2791: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2792: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
2793: p_data => x_msg_data
2794: );
2795:

Line 2804: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2800: module => G_DEBUG_MODULE || l_module);
2801:
2802: iby_fndcpt_common_pub.Clear_Msg_Stack(l_prev_msg_count);
2803:
2804: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2805: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2806: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_module, SUBSTR(SQLERRM,1,100));
2807: END IF;
2808:

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

2817:
2818: PROCEDURE Get_Authorization
2819: (
2820: p_api_version IN NUMBER,
2821: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2822: x_return_status OUT NOCOPY VARCHAR2,
2823: x_msg_count OUT NOCOPY NUMBER,
2824: x_msg_data OUT NOCOPY VARCHAR2,
2825: p_payer IN IBY_FNDCPT_COMMON_PUB.PayerContext_rec_type,

Line 2849: IF NOT FND_API.Compatible_API_Call (l_api_version,

2845: BEGIN
2846:
2847: IF (c_auth%ISOPEN) THEN CLOSE c_auth; END IF;
2848:
2849: IF NOT FND_API.Compatible_API_Call (l_api_version,
2850: p_api_version,
2851: l_module,
2852: G_PKG_NAME)
2853: THEN

Line 2859: RAISE FND_API.G_EXC_ERROR;

2855: debug_level => FND_LOG.LEVEL_ERROR,
2856: module => G_DEBUG_MODULE || l_module);
2857: FND_MESSAGE.SET_NAME('IBY', 'IBY_204400_API_VER_MISMATCH');
2858: FND_MSG_PUB.Add;
2859: RAISE FND_API.G_EXC_ERROR;
2860: END IF;
2861:
2862: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2863: FND_MSG_PUB.initialize;

Line 2862: IF FND_API.to_Boolean( p_init_msg_list ) THEN

2858: FND_MSG_PUB.Add;
2859: RAISE FND_API.G_EXC_ERROR;
2860: END IF;
2861:
2862: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2863: FND_MSG_PUB.initialize;
2864: END IF;
2865: l_prev_msg_count := FND_MSG_PUB.Count_Msg;
2866:

Line 2884: WHEN FND_API.G_EXC_ERROR THEN

2880: (l_prev_msg_count,x_return_status,x_msg_count,x_msg_data,x_response);
2881:
2882: EXCEPTION
2883:
2884: WHEN FND_API.G_EXC_ERROR THEN
2885:
2886: iby_debug_pub.add(debug_msg => 'In G_EXC_ERROR Exception',
2887: debug_level => FND_LOG.LEVEL_ERROR,
2888: module => G_DEBUG_MODULE || l_module);

Line 2889: x_return_status := FND_API.G_RET_STS_ERROR;

2885:
2886: iby_debug_pub.add(debug_msg => 'In G_EXC_ERROR Exception',
2887: debug_level => FND_LOG.LEVEL_ERROR,
2888: module => G_DEBUG_MODULE || l_module);
2889: x_return_status := FND_API.G_RET_STS_ERROR;
2890: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
2891: p_data => x_msg_data
2892: );
2893: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2893: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2889: x_return_status := FND_API.G_RET_STS_ERROR;
2890: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
2891: p_data => x_msg_data
2892: );
2893: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2894:
2895: iby_debug_pub.add(debug_msg => 'In G_EXC_UNEXPECTED_ERROR Exception',
2896: debug_level => FND_LOG.LEVEL_UNEXPECTED,
2897: module => G_DEBUG_MODULE || l_module);

Line 2898: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2894:
2895: iby_debug_pub.add(debug_msg => 'In G_EXC_UNEXPECTED_ERROR Exception',
2896: debug_level => FND_LOG.LEVEL_UNEXPECTED,
2897: module => G_DEBUG_MODULE || l_module);
2898: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2899: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
2900: p_data => x_msg_data
2901: );
2902:

Line 2911: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2907: module => G_DEBUG_MODULE || l_module);
2908:
2909: iby_fndcpt_common_pub.Clear_Msg_Stack(l_prev_msg_count);
2910:
2911: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2912: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2913: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_module, SUBSTR(SQLERRM,1,100));
2914: END IF;
2915:

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

2922:
2923: PROCEDURE Cancel_Authorization
2924: (
2925: p_api_version IN NUMBER,
2926: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2927: x_return_status OUT NOCOPY VARCHAR2,
2928: x_msg_count OUT NOCOPY NUMBER,
2929: x_msg_data OUT NOCOPY VARCHAR2,
2930: p_payer IN IBY_FNDCPT_COMMON_PUB.PayerContext_rec_type,

Line 2940: IF NOT FND_API.Compatible_API_Call (l_api_version,

2936: l_module CONSTANT VARCHAR2(30) := 'Cancel_Authorization';
2937: l_prev_msg_count NUMBER;
2938: BEGIN
2939:
2940: IF NOT FND_API.Compatible_API_Call (l_api_version,
2941: p_api_version,
2942: l_module,
2943: G_PKG_NAME)
2944: THEN

Line 2950: RAISE FND_API.G_EXC_ERROR;

2946: debug_level => FND_LOG.LEVEL_ERROR,
2947: module => G_DEBUG_MODULE || l_module);
2948: FND_MESSAGE.SET_NAME('IBY', 'IBY_204400_API_VER_MISMATCH');
2949: FND_MSG_PUB.Add;
2950: RAISE FND_API.G_EXC_ERROR;
2951: END IF;
2952:
2953: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2954: FND_MSG_PUB.initialize;

Line 2953: IF FND_API.to_Boolean( p_init_msg_list ) THEN

2949: FND_MSG_PUB.Add;
2950: RAISE FND_API.G_EXC_ERROR;
2951: END IF;
2952:
2953: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2954: FND_MSG_PUB.initialize;
2955: END IF;
2956: l_prev_msg_count := FND_MSG_PUB.Count_Msg;
2957:

Line 2965: WHEN FND_API.G_EXC_ERROR THEN

2961: (l_prev_msg_count,x_return_status,x_msg_count,x_msg_data,x_response);
2962:
2963: EXCEPTION
2964:
2965: WHEN FND_API.G_EXC_ERROR THEN
2966:
2967: iby_debug_pub.add(debug_msg => 'In G_EXC_ERROR Exception',
2968: debug_level => FND_LOG.LEVEL_ERROR,
2969: module => G_DEBUG_MODULE || l_module);

Line 2970: x_return_status := FND_API.G_RET_STS_ERROR;

2966:
2967: iby_debug_pub.add(debug_msg => 'In G_EXC_ERROR Exception',
2968: debug_level => FND_LOG.LEVEL_ERROR,
2969: module => G_DEBUG_MODULE || l_module);
2970: x_return_status := FND_API.G_RET_STS_ERROR;
2971: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
2972: p_data => x_msg_data
2973: );
2974: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2974: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2970: x_return_status := FND_API.G_RET_STS_ERROR;
2971: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
2972: p_data => x_msg_data
2973: );
2974: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2975:
2976: iby_debug_pub.add(debug_msg => 'In G_EXC_UNEXPECTED_ERROR Exception',
2977: debug_level => FND_LOG.LEVEL_UNEXPECTED,
2978: module => G_DEBUG_MODULE || l_module);

Line 2979: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2975:
2976: iby_debug_pub.add(debug_msg => 'In G_EXC_UNEXPECTED_ERROR Exception',
2977: debug_level => FND_LOG.LEVEL_UNEXPECTED,
2978: module => G_DEBUG_MODULE || l_module);
2979: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2980: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
2981: p_data => x_msg_data
2982: );
2983:

Line 2992: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2988: module => G_DEBUG_MODULE || l_module);
2989:
2990: iby_fndcpt_common_pub.Clear_Msg_Stack(l_prev_msg_count);
2991:
2992: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2993: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2994: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_module, SUBSTR(SQLERRM,1,100));
2995: END IF;
2996:

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

3005:
3006: PROCEDURE Create_Settlement
3007: (
3008: p_api_version IN NUMBER,
3009: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
3010: x_return_status OUT NOCOPY VARCHAR2,
3011: x_msg_count OUT NOCOPY NUMBER,
3012: x_msg_data OUT NOCOPY VARCHAR2,
3013: p_payer IN IBY_FNDCPT_COMMON_PUB.PayerContext_rec_type,

Line 3125: IF NOT FND_API.Compatible_API_Call (l_api_version,

3121: IF (c_auth%ISOPEN) THEN CLOSE c_auth; END IF;
3122: IF (c_payee%ISOPEN) THEN CLOSE c_payee; END IF;
3123: IF (c_operation_count%ISOPEN) THEN CLOSE c_operation_count; END IF;
3124:
3125: IF NOT FND_API.Compatible_API_Call (l_api_version,
3126: p_api_version,
3127: l_module,
3128: G_PKG_NAME)
3129: THEN

Line 3135: RAISE FND_API.G_EXC_ERROR;

3131: debug_level => FND_LOG.LEVEL_ERROR,
3132: module => G_DEBUG_MODULE || l_module);
3133: FND_MESSAGE.SET_NAME('IBY', 'IBY_204400_API_VER_MISMATCH');
3134: FND_MSG_PUB.Add;
3135: RAISE FND_API.G_EXC_ERROR;
3136: END IF;
3137:
3138: IF FND_API.to_Boolean( p_init_msg_list ) THEN
3139: FND_MSG_PUB.initialize;

Line 3138: IF FND_API.to_Boolean( p_init_msg_list ) THEN

3134: FND_MSG_PUB.Add;
3135: RAISE FND_API.G_EXC_ERROR;
3136: END IF;
3137:
3138: IF FND_API.to_Boolean( p_init_msg_list ) THEN
3139: FND_MSG_PUB.initialize;
3140: END IF;
3141: l_prev_msg_count := FND_MSG_PUB.Count_Msg;
3142:

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 3223: (1.0, p_init_msg_list, FND_API.G_FALSE, FND_API.G_VALID_LEVEL_FULL,

3219:
3220: iby_debug_pub.add('calling oraPmtReq ',iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
3221:
3222: IBY_PAYMENT_ADAPTER_PUB.OraPmtReq
3223: (1.0, p_init_msg_list, FND_API.G_FALSE, FND_API.G_VALID_LEVEL_FULL,
3224: l_ecapp_id, l_payee, l_payer, l_pmt_instr,
3225: l_tangible,
3226: l_pmt_trxn,
3227: lx_return_status,

Line 3394: (1.0, p_init_msg_list, FND_API.G_FALSE, FND_API.G_VALID_LEVEL_FULL,

3390:
3391: iby_debug_pub.add('Create Settlement- calling OraPmtCapture ' ,iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
3392:
3393: IBY_PAYMENT_ADAPTER_PUB.OraPmtCapture
3394: (1.0, p_init_msg_list, FND_API.G_FALSE, FND_API.G_VALID_LEVEL_FULL,
3395: l_ecapp_id, l_capture_trxn,
3396: lx_return_status, lx_msg_count, lx_msg_data, lx_capresp
3397: );
3398:

Line 3475: WHEN FND_API.G_EXC_ERROR THEN

3471:
3472:
3473: EXCEPTION
3474:
3475: WHEN FND_API.G_EXC_ERROR THEN
3476:
3477: iby_debug_pub.add(debug_msg => 'In G_EXC_ERROR Exception',
3478: debug_level => FND_LOG.LEVEL_ERROR,
3479: module => G_DEBUG_MODULE || l_module);

Line 3480: x_return_status := FND_API.G_RET_STS_ERROR;

3476:
3477: iby_debug_pub.add(debug_msg => 'In G_EXC_ERROR Exception',
3478: debug_level => FND_LOG.LEVEL_ERROR,
3479: module => G_DEBUG_MODULE || l_module);
3480: x_return_status := FND_API.G_RET_STS_ERROR;
3481: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
3482: p_data => x_msg_data
3483: );
3484: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 3484: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3480: x_return_status := FND_API.G_RET_STS_ERROR;
3481: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
3482: p_data => x_msg_data
3483: );
3484: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3485:
3486: iby_debug_pub.add(debug_msg => 'In G_EXC_UNEXPECTED_ERROR Exception',
3487: debug_level => FND_LOG.LEVEL_UNEXPECTED,
3488: module => G_DEBUG_MODULE || l_module);

Line 3489: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

3485:
3486: iby_debug_pub.add(debug_msg => 'In G_EXC_UNEXPECTED_ERROR Exception',
3487: debug_level => FND_LOG.LEVEL_UNEXPECTED,
3488: module => G_DEBUG_MODULE || l_module);
3489: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3490: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
3491: p_data => x_msg_data
3492: );
3493:

Line 3502: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

3498: module => G_DEBUG_MODULE || l_module);
3499:
3500: iby_fndcpt_common_pub.Clear_Msg_Stack(l_prev_msg_count);
3501:
3502: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3503: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3504: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_module, SUBSTR(SQLERRM,1,100));
3505: END IF;
3506:

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

3514: --Overloaded API for backward compatibility
3515: PROCEDURE Create_Settlement
3516: (
3517: p_api_version IN NUMBER,
3518: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
3519: x_return_status OUT NOCOPY VARCHAR2,
3520: x_msg_count OUT NOCOPY NUMBER,
3521: x_msg_data OUT NOCOPY VARCHAR2,
3522: p_payer IN IBY_FNDCPT_COMMON_PUB.PayerContext_rec_type,

Line 3571: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

3567: --
3568:
3569: PROCEDURE Create_Settlements (
3570: p_api_version IN NUMBER,
3571: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
3572: p_calling_app_id IN NUMBER,
3573: p_calling_app_request_code IN IBY_TRXN_SUMMARIES_ALL.CALL_APP_SERVICE_REQ_CODE%TYPE,
3574: p_order_view_name IN VARCHAR2,
3575: x_return_status OUT NOCOPY VARCHAR2,

Line 3673: IF NOT FND_API.Compatible_API_Call(l_api_version,

3669:
3670: SAVEPOINT create_settlements_pub;
3671:
3672: -- Standard call to check for call compatibility.
3673: IF NOT FND_API.Compatible_API_Call(l_api_version,
3674: p_api_version,
3675: l_api_name,
3676: G_PKG_NAME) THEN
3677: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3677: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3673: IF NOT FND_API.Compatible_API_Call(l_api_version,
3674: p_api_version,
3675: l_api_name,
3676: G_PKG_NAME) THEN
3677: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3678: END IF;
3679:
3680: -- Initialize message list if p_init_msg_list is set to TRUE.
3681: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 3681: IF FND_API.to_Boolean(p_init_msg_list) THEN

3677: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3678: END IF;
3679:
3680: -- Initialize message list if p_init_msg_list is set to TRUE.
3681: IF FND_API.to_Boolean(p_init_msg_list) THEN
3682: FND_MSG_PUB.initialize;
3683: END IF;
3684: l_prev_msg_count := FND_MSG_PUB.Count_Msg;
3685:

Line 3687: x_return_status := FND_API.G_RET_STS_SUCCESS;

3683: END IF;
3684: l_prev_msg_count := FND_MSG_PUB.Count_Msg;
3685:
3686: -- Initialize API return status to success
3687: x_return_status := FND_API.G_RET_STS_SUCCESS;
3688:
3689: -- Start of API body
3690:
3691: --

Line 4473: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

4469:
4470: -- End of API body
4471:
4472: -- get message count and if count is 1, get message info.
4473: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
4474: p_count => x_msg_count,
4475: p_data => x_msg_data);
4476:
4477: print_debuginfo(l_module_name, 'RETURN');

Line 4480: WHEN fnd_api.g_exc_error THEN

4476:
4477: print_debuginfo(l_module_name, 'RETURN');
4478:
4479: EXCEPTION
4480: WHEN fnd_api.g_exc_error THEN
4481: --ROLLBACK TO create_settlements_pub;
4482: x_return_status := fnd_api.g_ret_sts_error;
4483:
4484: print_debuginfo(l_module_name, 'Exception : ' || SQLERRM);

Line 4482: x_return_status := fnd_api.g_ret_sts_error;

4478:
4479: EXCEPTION
4480: WHEN fnd_api.g_exc_error THEN
4481: --ROLLBACK TO create_settlements_pub;
4482: x_return_status := fnd_api.g_ret_sts_error;
4483:
4484: print_debuginfo(l_module_name, 'Exception : ' || SQLERRM);
4485:
4486: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

Line 4486: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

4482: x_return_status := fnd_api.g_ret_sts_error;
4483:
4484: print_debuginfo(l_module_name, 'Exception : ' || SQLERRM);
4485:
4486: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
4487: p_count => x_msg_count,
4488: p_data => x_msg_data);
4489:
4490:

Line 4491: WHEN fnd_api.g_exc_unexpected_error THEN

4487: p_count => x_msg_count,
4488: p_data => x_msg_data);
4489:
4490:
4491: WHEN fnd_api.g_exc_unexpected_error THEN
4492: --ROLLBACK TO create_settlements_pub;
4493: x_return_status := fnd_api.g_ret_sts_unexp_error;
4494:
4495: print_debuginfo(l_module_name, 'Exception : ' || SQLERRM);

Line 4493: x_return_status := fnd_api.g_ret_sts_unexp_error;

4489:
4490:
4491: WHEN fnd_api.g_exc_unexpected_error THEN
4492: --ROLLBACK TO create_settlements_pub;
4493: x_return_status := fnd_api.g_ret_sts_unexp_error;
4494:
4495: print_debuginfo(l_module_name, 'Exception : ' || SQLERRM);
4496:
4497: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

Line 4497: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

4493: x_return_status := fnd_api.g_ret_sts_unexp_error;
4494:
4495: print_debuginfo(l_module_name, 'Exception : ' || SQLERRM);
4496:
4497: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
4498: p_count => x_msg_count,
4499: p_data => x_msg_data);
4500:
4501:

Line 4504: x_return_status := fnd_api.g_ret_sts_unexp_error;

4500:
4501:
4502: WHEN OTHERS THEN
4503: --ROLLBACK TO create_settlements_pub;
4504: x_return_status := fnd_api.g_ret_sts_unexp_error;
4505:
4506: print_debuginfo(l_module_name, 'Exception : ' || SQLERRM);
4507:
4508: fnd_message.set_name('IBY', 'IBY_API_OTHERS_EXCEP');

Line 4511: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

4507:
4508: fnd_message.set_name('IBY', 'IBY_API_OTHERS_EXCEP');
4509: fnd_message.set_token('ERROR',SQLERRM);
4510: fnd_msg_pub.add;
4511: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
4512: p_count => x_msg_count,
4513: p_data => x_msg_data);
4514:
4515: END Create_Settlements;

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

4516:
4517: PROCEDURE Create_Return
4518: (
4519: p_api_version IN NUMBER,
4520: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
4521: x_return_status OUT NOCOPY VARCHAR2,
4522: x_msg_count OUT NOCOPY NUMBER,
4523: x_msg_data OUT NOCOPY VARCHAR2,
4524: p_payer IN IBY_FNDCPT_COMMON_PUB.PayerContext_rec_type,

Line 4604: IF NOT FND_API.Compatible_API_Call (l_api_version,

4600:
4601: IF (c_extension%ISOPEN) THEN CLOSE c_extension; END IF;
4602: IF (c_settlement%ISOPEN) THEN CLOSE c_settlement; END IF;
4603:
4604: IF NOT FND_API.Compatible_API_Call (l_api_version,
4605: p_api_version,
4606: l_module,
4607: G_PKG_NAME)
4608: THEN

Line 4614: RAISE FND_API.G_EXC_ERROR;

4610: debug_level => FND_LOG.LEVEL_ERROR,
4611: module => G_DEBUG_MODULE || l_module);
4612: FND_MESSAGE.SET_NAME('IBY', 'IBY_204400_API_VER_MISMATCH');
4613: FND_MSG_PUB.Add;
4614: RAISE FND_API.G_EXC_ERROR;
4615: END IF;
4616:
4617: IF FND_API.to_Boolean( p_init_msg_list ) THEN
4618: FND_MSG_PUB.initialize;

Line 4617: IF FND_API.to_Boolean( p_init_msg_list ) THEN

4613: FND_MSG_PUB.Add;
4614: RAISE FND_API.G_EXC_ERROR;
4615: END IF;
4616:
4617: IF FND_API.to_Boolean( p_init_msg_list ) THEN
4618: FND_MSG_PUB.initialize;
4619: END IF;
4620: l_prev_msg_count := FND_MSG_PUB.Count_Msg;
4621:

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;

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

4661: l_credit_trxn.Payer_Party_Id := p_payer.Party_Id;
4662: l_credit_trxn.Settlement_Date := p_receipt_attribs.Settlement_Date;
4663:
4664: IBY_PAYMENT_ADAPTER_PUB.OraPmtCredit
4665: (1.0, FND_API.G_FALSE, FND_API.G_FALSE, FND_API.G_VALID_LEVEL_FULL,
4666: l_ecapp_id, l_payee, l_pmt_instr, l_tangible, l_credit_trxn,
4667: lx_return_status, lx_msg_count, lx_msg_data, lx_creditresp
4668: );
4669:

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

4732: l_return_trxn.PmtMode := 'ONLINE';
4733: l_return_trxn.Settlement_Date := p_receipt_attribs.Settlement_Date;
4734:
4735: IBY_PAYMENT_ADAPTER_PUB.OraPmtReturn
4736: (1.0, FND_API.G_FALSE, FND_API.G_FALSE, FND_API.G_VALID_LEVEL_FULL,
4737: l_ecapp_id, l_return_trxn, lx_return_status, lx_msg_count,
4738: lx_msg_data, lx_returnresp
4739: );
4740:

Line 4793: WHEN FND_API.G_EXC_ERROR THEN

4789: (l_prev_msg_count,x_return_status,x_msg_count,x_msg_data,x_response);
4790:
4791: EXCEPTION
4792:
4793: WHEN FND_API.G_EXC_ERROR THEN
4794:
4795: iby_debug_pub.add(debug_msg => 'In G_EXC_ERROR Exception',
4796: debug_level => FND_LOG.LEVEL_ERROR,
4797: module => G_DEBUG_MODULE || l_module);

Line 4798: x_return_status := FND_API.G_RET_STS_ERROR;

4794:
4795: iby_debug_pub.add(debug_msg => 'In G_EXC_ERROR Exception',
4796: debug_level => FND_LOG.LEVEL_ERROR,
4797: module => G_DEBUG_MODULE || l_module);
4798: x_return_status := FND_API.G_RET_STS_ERROR;
4799: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
4800: p_data => x_msg_data
4801: );
4802: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 4802: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4798: x_return_status := FND_API.G_RET_STS_ERROR;
4799: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
4800: p_data => x_msg_data
4801: );
4802: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4803:
4804: iby_debug_pub.add(debug_msg => 'In G_EXC_UNEXPECTED_ERROR Exception',
4805: debug_level => FND_LOG.LEVEL_UNEXPECTED,
4806: module => G_DEBUG_MODULE || l_module);

Line 4807: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

4803:
4804: iby_debug_pub.add(debug_msg => 'In G_EXC_UNEXPECTED_ERROR Exception',
4805: debug_level => FND_LOG.LEVEL_UNEXPECTED,
4806: module => G_DEBUG_MODULE || l_module);
4807: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4808: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
4809: p_data => x_msg_data
4810: );
4811:

Line 4820: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

4816: module => G_DEBUG_MODULE || l_module);
4817:
4818: iby_fndcpt_common_pub.Clear_Msg_Stack(l_prev_msg_count);
4819:
4820: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4821: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4822: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_module, SUBSTR(SQLERRM,1,100));
4823: END IF;
4824:

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

4830:
4831: PROCEDURE Create_Return
4832: (
4833: p_api_version IN NUMBER,
4834: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
4835: x_return_status OUT NOCOPY VARCHAR2,
4836: x_msg_count OUT NOCOPY NUMBER,
4837: x_msg_data OUT NOCOPY VARCHAR2,
4838: p_payer IN IBY_FNDCPT_COMMON_PUB.PayerContext_rec_type,

Line 4908: (FND_API.G_FALSE,l_cvv2,iby_security_pkg.G_ENCODING_NUMERIC,

4904: -- instead of the previous Encode_Number API.
4905: l_cvv2 :=
4906: IBY_SECURITY_PKG.Encode_CVV(c_ext_rec.instrument_security_code,TRUE);
4907: IBY_SECURITY_PKG.Create_Segment
4908: (FND_API.G_FALSE,l_cvv2,iby_security_pkg.G_ENCODING_NUMERIC,
4909: p_sys_security_key,lx_segment_id);
4910:
4911: UPDATE iby_fndcpt_tx_extensions
4912: SET

Line 4923: IF FND_API.To_Boolean(p_commit) THEN

4919: object_version_number = object_version_number + 1
4920: WHERE trxn_extension_id = c_ext_rec.trxn_extension_id;
4921: END LOOP;
4922:
4923: IF FND_API.To_Boolean(p_commit) THEN
4924: COMMIT;
4925: END IF;
4926: END Encrypt_Extensions;
4927:

Line 4929: (p_commit IN VARCHAR2 := FND_API.G_TRUE,

4925: END IF;
4926: END Encrypt_Extensions;
4927:
4928: PROCEDURE Encrypt_Security_Code
4929: (p_commit IN VARCHAR2 := FND_API.G_TRUE,
4930: p_sys_security_key IN iby_security_pkg.DES3_KEY_TYPE,
4931: p_security_code IN iby_fndcpt_tx_extensions.instrument_security_code%TYPE,
4932: x_segment_id OUT NOCOPY NUMBER,
4933: x_err_code OUT NOCOPY VARCHAR2

Line 4955: (FND_API.G_FALSE,l_cvv2,iby_security_pkg.G_ENCODING_NUMERIC,

4951: END IF;
4952: l_cvv2 := IBY_SECURITY_PKG.Encode_CVV(p_security_code,TRUE);
4953: -- test_debug('encoded cvv: '|| l_cvv2);
4954: IBY_SECURITY_PKG.Create_Segment
4955: (FND_API.G_FALSE,l_cvv2,iby_security_pkg.G_ENCODING_NUMERIC,
4956: p_sys_security_key,lx_segment_id);
4957: -- test_debug('segmentId: '|| lx_segment_id);
4958:
4959: x_segment_id := lx_segment_id;

Line 4961: IF FND_API.To_Boolean(p_commit) THEN

4957: -- test_debug('segmentId: '|| lx_segment_id);
4958:
4959: x_segment_id := lx_segment_id;
4960:
4961: IF FND_API.To_Boolean(p_commit) THEN
4962: COMMIT;
4963: END IF;
4964:
4965: END Encrypt_Security_Code;

Line 4968: (p_commit IN VARCHAR2 := FND_API.G_TRUE,

4964:
4965: END Encrypt_Security_Code;
4966:
4967: PROCEDURE Decrypt_Extensions
4968: (p_commit IN VARCHAR2 := FND_API.G_TRUE,
4969: p_sys_security_key IN iby_security_pkg.DES3_KEY_TYPE,
4970: x_err_code OUT NOCOPY VARCHAR2
4971: )
4972: IS

Line 5019: IF FND_API.To_Boolean(p_commit) THEN

5015: DELETE iby_security_segments
5016: WHERE sec_segment_id = c_ext_rec.sec_segment_id;
5017: END LOOP;
5018:
5019: IF FND_API.To_Boolean(p_commit) THEN
5020: COMMIT;
5021: END IF;
5022:
5023: END Decrypt_Extensions;