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_DEBUG_PUB

Line 155: iby_debug_pub.add('instr assignment id:=' || p_instr_assign_id,

151:
152: l_dbg_mod VARCHAR2(100) := G_DEBUG_MODULE || '.Get_Payer_Instr_Assgn_Fail';
153: BEGIN
154:
155: iby_debug_pub.add('instr assignment id:=' || p_instr_assign_id,
156: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
157:
158: l_msg := 'IBY_INVALID_INSTR_ASSIGN';
159:

Line 156: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);

152: l_dbg_mod VARCHAR2(100) := G_DEBUG_MODULE || '.Get_Payer_Instr_Assgn_Fail';
153: BEGIN
154:
155: iby_debug_pub.add('instr assignment id:=' || p_instr_assign_id,
156: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
157:
158: l_msg := 'IBY_INVALID_INSTR_ASSIGN';
159:
160: -- Bug: 7719030

Line 169: iby_debug_pub.add('payer id:=' || l_payer_id,

165: INTO l_payer_id
166: FROM iby_pmt_instr_uses_all
167: WHERE (instrument_payment_use_id = p_instr_assign_id);
168:
169: iby_debug_pub.add('payer id:=' || l_payer_id,
170: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
171:
172: EXCEPTION
173: WHEN NO_DATA_FOUND THEN

Line 170: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);

166: FROM iby_pmt_instr_uses_all
167: WHERE (instrument_payment_use_id = p_instr_assign_id);
168:
169: iby_debug_pub.add('payer id:=' || l_payer_id,
170: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
171:
172: EXCEPTION
173: WHEN NO_DATA_FOUND THEN
174: iby_debug_pub.add('Exception: No Instrument found',

Line 174: iby_debug_pub.add('Exception: No Instrument found',

170: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
171:
172: EXCEPTION
173: WHEN NO_DATA_FOUND THEN
174: iby_debug_pub.add('Exception: No Instrument found',
175: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
176: RETURN l_msg;
177: END;
178:

Line 175: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);

171:
172: EXCEPTION
173: WHEN NO_DATA_FOUND THEN
174: iby_debug_pub.add('Exception: No Instrument found',
175: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
176: RETURN l_msg;
177: END;
178:
179:

Line 186: iby_debug_pub.add('external payer count:=' || SQL%ROWCOUNT,

182: INTO l_party_id
183: FROM iby_external_payers_all
184: WHERE (ext_payer_id = l_payer_id);
185:
186: iby_debug_pub.add('external payer count:=' || SQL%ROWCOUNT,
187: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
188:
189: IF (SQL%ROWCOUNT < 1) THEN RETURN l_msg; END IF;
190:

Line 187: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);

183: FROM iby_external_payers_all
184: WHERE (ext_payer_id = l_payer_id);
185:
186: iby_debug_pub.add('external payer count:=' || SQL%ROWCOUNT,
187: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
188:
189: IF (SQL%ROWCOUNT < 1) THEN RETURN l_msg; END IF;
190:
191: l_msg := 'IBY_INVALID_PARTY_CONTEXT';

Line 192: iby_debug_pub.add('party id:=' || l_party_id,

188:
189: IF (SQL%ROWCOUNT < 1) THEN RETURN l_msg; END IF;
190:
191: l_msg := 'IBY_INVALID_PARTY_CONTEXT';
192: iby_debug_pub.add('party id:=' || l_party_id,
193: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
194: IF (l_party_id <> p_payer.Party_Id) THEN RETURN l_msg; END IF;
195:
196: RETURN null;

Line 193: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);

189: IF (SQL%ROWCOUNT < 1) THEN RETURN l_msg; END IF;
190:
191: l_msg := 'IBY_INVALID_PARTY_CONTEXT';
192: iby_debug_pub.add('party id:=' || l_party_id,
193: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
194: IF (l_party_id <> p_payer.Party_Id) THEN RETURN l_msg; END IF;
195:
196: RETURN null;
197: EXCEPTION

Line 232: iby_debug_pub.add('checking instrument assignment',

228: WHEN NO_DATA_FOUND THEN
229: RETURN l_msg;
230: END;
231:
232: iby_debug_pub.add('checking instrument assignment',
233: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
234: l_msg := Get_Payer_Instr_Assgn_Fail(l_instr_assign_id,p_payer);
235:
236: IF (NOT l_msg IS NULL) THEN RETURN l_msg; END IF;

Line 233: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);

229: RETURN l_msg;
230: END;
231:
232: iby_debug_pub.add('checking instrument assignment',
233: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
234: l_msg := Get_Payer_Instr_Assgn_Fail(l_instr_assign_id,p_payer);
235:
236: IF (NOT l_msg IS NULL) THEN RETURN l_msg; END IF;
237:

Line 374: iby_debug_pub.add('validating xtension',

370:
371: l_dbg_mod VARCHAR2(100) := G_DEBUG_MODULE || '.Extension_Valid';
372: BEGIN
373:
374: iby_debug_pub.add('validating xtension',
375: iby_debug_pub.G_LEVEL_PROCEDURE,l_dbg_mod);
376:
377: IBY_FNDCPT_SETUP_PUB.Get_Payment_Channel_Attribs
378: (1.0, FND_API.G_FALSE, l_return_status, l_msg_count, l_msg_data,

Line 375: iby_debug_pub.G_LEVEL_PROCEDURE,l_dbg_mod);

371: l_dbg_mod VARCHAR2(100) := G_DEBUG_MODULE || '.Extension_Valid';
372: BEGIN
373:
374: iby_debug_pub.add('validating xtension',
375: iby_debug_pub.G_LEVEL_PROCEDURE,l_dbg_mod);
376:
377: IBY_FNDCPT_SETUP_PUB.Get_Payment_Channel_Attribs
378: (1.0, FND_API.G_FALSE, l_return_status, l_msg_count, l_msg_data,
379: p_pmt_channel, l_channel_attribs, l_response);

Line 730: iby_debug_pub.add('Enter',iby_debug_pub.G_LEVEL_PROCEDURE,l_dbg_mod);

726: AND (instrument_type = ci_instr_type);
727:
728: l_dbg_mod VARCHAR2(100) := G_DEBUG_MODULE || '.Payer_InstrAssignment_Valid';
729: BEGIN
730: iby_debug_pub.add('Enter',iby_debug_pub.G_LEVEL_PROCEDURE,l_dbg_mod);
731:
732: IF (c_instr_assigns%ISOPEN) THEN CLOSE c_instr_assigns; END IF;
733: IF (c_instr_extensions%ISOPEN) THEN CLOSE c_instr_extensions; END IF;
734:

Line 737: iby_debug_pub.add('instrument applicability:=' || l_instr_req,

733: IF (c_instr_extensions%ISOPEN) THEN CLOSE c_instr_extensions; END IF;
734:
735: l_instr_req := Channel_InstrAssignment_Appl(p_channel_code);
736:
737: iby_debug_pub.add('instrument applicability:=' || l_instr_req,
738: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
739:
740: IF ((l_instr_req = IBY_FNDCPT_SETUP_PUB.G_CHNNL_ATTRIB_USE_OPTIONAL)
741: AND (p_instr_assign IS NULL))

Line 738: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);

734:
735: l_instr_req := Channel_InstrAssignment_Appl(p_channel_code);
736:
737: iby_debug_pub.add('instrument applicability:=' || l_instr_req,
738: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
739:
740: IF ((l_instr_req = IBY_FNDCPT_SETUP_PUB.G_CHNNL_ATTRIB_USE_OPTIONAL)
741: AND (p_instr_assign IS NULL))
742: THEN

Line 753: iby_debug_pub.add('fetched assignment id:=' || l_assign_id,

749: FETCH c_instr_assigns INTO l_assign_id, l_instr_type, l_instr_id,
750: l_info_only, l_single_use;
751: CLOSE c_instr_assigns;
752:
753: iby_debug_pub.add('fetched assignment id:=' || l_assign_id,
754: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
755: iby_debug_pub.add('info only:=' || l_info_only,
756: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
757: iby_debug_pub.add('single use:=' || l_single_use,

Line 754: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);

750: l_info_only, l_single_use;
751: CLOSE c_instr_assigns;
752:
753: iby_debug_pub.add('fetched assignment id:=' || l_assign_id,
754: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
755: iby_debug_pub.add('info only:=' || l_info_only,
756: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
757: iby_debug_pub.add('single use:=' || l_single_use,
758: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);

Line 755: iby_debug_pub.add('info only:=' || l_info_only,

751: CLOSE c_instr_assigns;
752:
753: iby_debug_pub.add('fetched assignment id:=' || l_assign_id,
754: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
755: iby_debug_pub.add('info only:=' || l_info_only,
756: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
757: iby_debug_pub.add('single use:=' || l_single_use,
758: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
759:

Line 756: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);

752:
753: iby_debug_pub.add('fetched assignment id:=' || l_assign_id,
754: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
755: iby_debug_pub.add('info only:=' || l_info_only,
756: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
757: iby_debug_pub.add('single use:=' || l_single_use,
758: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
759:
760: IF ((l_assign_id IS NULL) OR (l_info_only = 'Y')) THEN

Line 757: iby_debug_pub.add('single use:=' || l_single_use,

753: iby_debug_pub.add('fetched assignment id:=' || l_assign_id,
754: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
755: iby_debug_pub.add('info only:=' || l_info_only,
756: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
757: iby_debug_pub.add('single use:=' || l_single_use,
758: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
759:
760: IF ((l_assign_id IS NULL) OR (l_info_only = 'Y')) THEN
761: RETURN FALSE;

Line 758: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);

754: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
755: iby_debug_pub.add('info only:=' || l_info_only,
756: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
757: iby_debug_pub.add('single use:=' || l_single_use,
758: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
759:
760: IF ((l_assign_id IS NULL) OR (l_info_only = 'Y')) THEN
761: RETURN FALSE;
762: ELSE

Line 843: iby_debug_pub.add('Enter',iby_debug_pub.G_LEVEL_PROCEDURE,l_dbg_mod);

839: lx_result IBY_FNDCPT_COMMON_PUB.Result_rec_type;
840:
841: l_dbg_mod VARCHAR2(100) := G_DEBUG_MODULE || '.' || l_module;
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,

Line 851: iby_debug_pub.add(debug_msg => 'Incorrect API Version:=' || p_api_version,

847: p_api_version,
848: l_module,
849: G_PKG_NAME)
850: THEN
851: iby_debug_pub.add(debug_msg => 'Incorrect API Version:=' || p_api_version,
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;

Line 864: iby_debug_pub.add('checking payer context',

860: FND_MSG_PUB.initialize;
861: END IF;
862: l_prev_msg_count := FND_MSG_PUB.Count_Msg;
863:
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,

Line 865: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);

861: END IF;
862: l_prev_msg_count := FND_MSG_PUB.Count_Msg;
863:
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);

Line 885: iby_debug_pub.add('invalid order id',

881: -- > iby_bill_pkg.G_MAX_TANGIBLEID_LEN
882: -- )
883: THEN
884: -- test_debug('invalid order id');
885: iby_debug_pub.add('invalid order id',
886: iby_debug_pub.G_LEVEL_ERROR,l_dbg_mod);
887: x_response.Result_Code := G_RC_INVALID_EXTENSION_ATTRIB;
888: iby_fndcpt_common_pub.Prepare_Result
889: (l_prev_msg_count,x_return_status,x_msg_count,x_msg_data,x_response);

Line 886: iby_debug_pub.G_LEVEL_ERROR,l_dbg_mod);

882: -- )
883: THEN
884: -- test_debug('invalid order id');
885: iby_debug_pub.add('invalid order id',
886: iby_debug_pub.G_LEVEL_ERROR,l_dbg_mod);
887: x_response.Result_Code := G_RC_INVALID_EXTENSION_ATTRIB;
888: iby_fndcpt_common_pub.Prepare_Result
889: (l_prev_msg_count,x_return_status,x_msg_count,x_msg_data,x_response);
890: RETURN;

Line 912: iby_debug_pub.add('instrument asssignment not valid for channel',

908: IF (NOT InstrAssignment_Channel_Valid(p_pmt_channel,p_instr_assignment,
909: lx_channel_instr))
910: THEN
911: -- test_debug('instrument asssignment not valid for channel');
912: iby_debug_pub.add('instrument asssignment not valid for channel',
913: iby_debug_pub.G_LEVEL_ERROR,l_dbg_mod);
914: x_response.Result_Code := IBY_FNDCPT_SETUP_PUB.G_RC_INVALID_INSTR_ASSIGN;
915: iby_fndcpt_common_pub.Prepare_Result
916: (l_prev_msg_count,x_return_status,x_msg_count,x_msg_data,x_response);

Line 913: iby_debug_pub.G_LEVEL_ERROR,l_dbg_mod);

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

Line 929: iby_debug_pub.add('instrument asssignment not valid payer',

925: p_pmt_channel,
926: p_instr_assignment,TRUE))
927: THEN
928: --test_debug('instrument asssignment not valid payer');
929: iby_debug_pub.add('instrument asssignment not valid payer',
930: iby_debug_pub.G_LEVEL_ERROR,l_dbg_mod);
931: x_response.Result_Code := IBY_FNDCPT_SETUP_PUB.G_RC_INVALID_INSTR_ASSIGN;
932: iby_fndcpt_common_pub.Prepare_Result
933: (l_prev_msg_count,x_return_status,x_msg_count,x_msg_data,x_response);

Line 930: iby_debug_pub.G_LEVEL_ERROR,l_dbg_mod);

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

Line 944: iby_debug_pub.add('invalid trxn extension attributes',

940: END IF;
941:
942: IF (NOT Extension_Valid(p_pmt_channel,p_trxn_attribs,FALSE,FALSE)) THEN
943: -- test_debug('invalid trxn extension attributes');
944: iby_debug_pub.add('invalid trxn extension attributes',
945: iby_debug_pub.G_LEVEL_ERROR,l_dbg_mod);
946: x_response.Result_Code := G_RC_INVALID_EXTENSION_ATTRIB;
947: ELSE
948:

Line 945: iby_debug_pub.G_LEVEL_ERROR,l_dbg_mod);

941:
942: IF (NOT Extension_Valid(p_pmt_channel,p_trxn_attribs,FALSE,FALSE)) THEN
943: -- test_debug('invalid trxn extension attributes');
944: iby_debug_pub.add('invalid trxn extension attributes',
945: iby_debug_pub.G_LEVEL_ERROR,l_dbg_mod);
946: x_response.Result_Code := G_RC_INVALID_EXTENSION_ATTRIB;
947: ELSE
948:
949: -- create payer on the fly if necessary

Line 959: iby_debug_pub.add('could not set payer attributes',

955: );
956:
957: IF (lx_result.Result_Code <> IBY_FNDCPT_COMMON_PUB.G_RC_SUCCESS) THEN
958: -- test_debug('could not set payer attributes');
959: iby_debug_pub.add('could not set payer attributes',
960: iby_debug_pub.G_LEVEL_ERROR,l_dbg_mod);
961: x_response := lx_result;
962: RETURN;
963: END IF;

Line 960: iby_debug_pub.G_LEVEL_ERROR,l_dbg_mod);

956:
957: IF (lx_result.Result_Code <> IBY_FNDCPT_COMMON_PUB.G_RC_SUCCESS) THEN
958: -- test_debug('could not set payer attributes');
959: iby_debug_pub.add('could not set payer attributes',
960: iby_debug_pub.G_LEVEL_ERROR,l_dbg_mod);
961: x_response := lx_result;
962: RETURN;
963: END IF;
964: END IF;

Line 1049: iby_debug_pub.add('Exit',iby_debug_pub.G_LEVEL_PROCEDURE,l_dbg_mod);

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);
1050:
1051: EXCEPTION
1052:
1053: WHEN FND_API.G_EXC_ERROR THEN

Line 1055: iby_debug_pub.add(debug_msg => 'In G_EXC_ERROR Exception',

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);
1058: x_return_status := FND_API.G_RET_STS_ERROR;
1059: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

Line 1064: iby_debug_pub.add(debug_msg => 'In G_EXC_UNEXPECTED_ERROR Exception',

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);
1067: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1068: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

Line 1073: iby_debug_pub.add(debug_msg => 'In OTHERS Exception',

1069: p_data => x_msg_data
1070: );
1071: WHEN OTHERS THEN
1072:
1073: iby_debug_pub.add(debug_msg => 'In OTHERS Exception',
1074: debug_level => FND_LOG.LEVEL_UNEXPECTED,
1075: module => G_DEBUG_MODULE || l_module);
1076:
1077: iby_fndcpt_common_pub.Clear_Msg_Stack(l_prev_msg_count);

Line 1158: iby_debug_pub.add('Enter',iby_debug_pub.G_LEVEL_PROCEDURE,l_dbg_mod);

1154: ci_payer_level,ci_payer_equiv,p.org_type,p.org_id,
1155: p.cust_account_id,p.acct_site_use_id) = 'T');
1156:
1157: BEGIN
1158: iby_debug_pub.add('Enter',iby_debug_pub.G_LEVEL_PROCEDURE,l_dbg_mod);
1159:
1160: -- test_debug('update_extension called..');
1161:
1162: IF (c_extension%ISOPEN) THEN CLOSE c_extension; END IF;

Line 1169: iby_debug_pub.add(debug_msg => 'Incorrect API Version:=' || p_api_version,

1165: p_api_version,
1166: l_module,
1167: G_PKG_NAME)
1168: THEN
1169: iby_debug_pub.add(debug_msg => 'Incorrect API Version:=' || p_api_version,
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;

Line 1182: iby_debug_pub.add('checking payer context',iby_debug_pub.G_LEVEL_INFO,

1178: FND_MSG_PUB.initialize;
1179: END IF;
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:

Line 1207: iby_debug_pub.add('invalid order id',

1203: l_trxn_ref2))
1204: > iby_bill_pkg.G_MAX_TANGIBLEID_LEN
1205: )
1206: THEN
1207: iby_debug_pub.add('invalid order id',
1208: iby_debug_pub.G_LEVEL_ERROR,l_dbg_mod);
1209: x_response.Result_Code := G_RC_INVALID_EXTENSION_ATTRIB;
1210: iby_fndcpt_common_pub.Prepare_Result
1211: (l_prev_msg_count,x_return_status,x_msg_count,x_msg_data,x_response);

Line 1208: iby_debug_pub.G_LEVEL_ERROR,l_dbg_mod);

1204: > iby_bill_pkg.G_MAX_TANGIBLEID_LEN
1205: )
1206: THEN
1207: iby_debug_pub.add('invalid order id',
1208: iby_debug_pub.G_LEVEL_ERROR,l_dbg_mod);
1209: x_response.Result_Code := G_RC_INVALID_EXTENSION_ATTRIB;
1210: iby_fndcpt_common_pub.Prepare_Result
1211: (l_prev_msg_count,x_return_status,x_msg_count,x_msg_data,x_response);
1212: RETURN;

Line 1228: iby_debug_pub.add('invalid extension attributes',

1224: -- validate the trxn attributes; note that mandatory ones
1225: -- may be NULL in which case the current values will be used
1226: --
1227: IF (NOT Extension_Valid(l_pmt_channel,p_trxn_attribs,TRUE,FALSE)) THEN
1228: iby_debug_pub.add('invalid extension attributes',
1229: iby_debug_pub.G_LEVEL_ERROR,l_dbg_mod);
1230: x_response.Result_Code := G_RC_INVALID_EXTENSION_ATTRIB;
1231: --
1232: -- make sure no operations already performed on the extension;

Line 1229: iby_debug_pub.G_LEVEL_ERROR,l_dbg_mod);

1225: -- may be NULL in which case the current values will be used
1226: --
1227: IF (NOT Extension_Valid(l_pmt_channel,p_trxn_attribs,TRUE,FALSE)) THEN
1228: iby_debug_pub.add('invalid extension attributes',
1229: iby_debug_pub.G_LEVEL_ERROR,l_dbg_mod);
1230: x_response.Result_Code := G_RC_INVALID_EXTENSION_ATTRIB;
1231: --
1232: -- make sure no operations already performed on the extension;
1233: --

Line 1235: iby_debug_pub.add('operations exist for extension; cannot update',

1231: --
1232: -- make sure no operations already performed on the extension;
1233: --
1234: ELSIF ( Extension_Operation_Exists(p_entity_id) ) THEN
1235: iby_debug_pub.add('operations exist for extension; cannot update',
1236: iby_debug_pub.G_LEVEL_ERROR,l_dbg_mod);
1237: x_response.Result_Code := G_RC_EXTENSION_IMMUTABLE;
1238: ELSE
1239:

Line 1236: iby_debug_pub.G_LEVEL_ERROR,l_dbg_mod);

1232: -- make sure no operations already performed on the extension;
1233: --
1234: ELSIF ( Extension_Operation_Exists(p_entity_id) ) THEN
1235: iby_debug_pub.add('operations exist for extension; cannot update',
1236: iby_debug_pub.G_LEVEL_ERROR,l_dbg_mod);
1237: x_response.Result_Code := G_RC_EXTENSION_IMMUTABLE;
1238: ELSE
1239:
1240: IF (NOT p_pmt_channel IS NULL) OR (NOT p_instr_assignment IS NULL)

Line 1245: iby_debug_pub.add('invalid payment channel for payer',

1241: THEN
1242: IF (NOT Payer_Channel_Valid(p_payer,l_payer_level,
1243: p_payer_equivalency,l_pmt_channel))
1244: THEN
1245: iby_debug_pub.add('invalid payment channel for payer',
1246: iby_debug_pub.G_LEVEL_ERROR,l_dbg_mod);
1247: x_response.Result_Code := IBY_FNDCPT_SETUP_PUB.G_RC_INVALID_CHNNL;
1248: iby_fndcpt_common_pub.Prepare_Result
1249: (l_prev_msg_count,x_return_status,x_msg_count,x_msg_data,

Line 1246: iby_debug_pub.G_LEVEL_ERROR,l_dbg_mod);

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

Line 1262: iby_debug_pub.add('invalid payment channel for instrument or payer',

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

Line 1263: iby_debug_pub.G_LEVEL_ERROR,l_dbg_mod);

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

Line 1377: iby_debug_pub.add('updating extension',

1373: last_update_login = fnd_global.login_id,
1374: object_version_number = object_version_number + 1
1375: WHERE (trxn_extension_id = p_entity_id);
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

Line 1378: iby_debug_pub.G_LEVEL_ERROR,l_dbg_mod);

1374: object_version_number = object_version_number + 1
1375: WHERE (trxn_extension_id = p_entity_id);
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

Line 1400: iby_debug_pub.add('Exit',iby_debug_pub.G_LEVEL_PROCEDURE,l_dbg_mod);

1396:
1397: iby_fndcpt_common_pub.Prepare_Result
1398: (l_prev_msg_count,x_return_status,x_msg_count,x_msg_data,x_response);
1399:
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

Line 1406: iby_debug_pub.add(debug_msg => 'In G_EXC_ERROR Exception',

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);
1409: x_return_status := FND_API.G_RET_STS_ERROR;
1410: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

Line 1415: iby_debug_pub.add(debug_msg => 'In G_EXC_UNEXPECTED_ERROR Exception',

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);
1418: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1419: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

Line 1424: iby_debug_pub.add(debug_msg => 'In OTHERS Exception',

1420: p_data => x_msg_data
1421: );
1422: WHEN OTHERS THEN
1423:
1424: iby_debug_pub.add(debug_msg => 'In OTHERS Exception',
1425: debug_level => FND_LOG.LEVEL_UNEXPECTED,
1426: module => G_DEBUG_MODULE || l_module);
1427:
1428: iby_fndcpt_common_pub.Clear_Msg_Stack(l_prev_msg_count);

Line 1477: iby_debug_pub.add('Enter',iby_debug_pub.G_LEVEL_PROCEDURE,l_dbg_mod);

1473: FROM iby_fndcpt_tx_extensions
1474: WHERE trxn_extension_id = ci_extension_id;
1475:
1476: BEGIN
1477: iby_debug_pub.add('Enter',iby_debug_pub.G_LEVEL_PROCEDURE,l_dbg_mod);
1478:
1479: IF (c_extension%ISOPEN) THEN
1480: CLOSE c_extension;
1481: END IF;

Line 1488: iby_debug_pub.add(debug_msg => 'Incorrect API Version:=' || p_api_version,

1484: p_api_version,
1485: l_module,
1486: G_PKG_NAME)
1487: THEN
1488: iby_debug_pub.add(debug_msg => 'Incorrect API Version:=' || p_api_version,
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;

Line 1501: iby_debug_pub.add('checking payer contxt',iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);

1497: FND_MSG_PUB.initialize;
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

Line 1520: iby_debug_pub.add('could not find extension',

1516: x_trxn_attribs.Additional_Info;
1517:
1518: x_response.Result_Code := IBY_FNDCPT_COMMON_PUB.G_RC_SUCCESS;
1519: IF (c_extension%NOTFOUND) THEN
1520: iby_debug_pub.add('could not find extension',
1521: iby_debug_pub.G_LEVEL_ERROR,l_dbg_mod);
1522: x_response.Result_Code := G_RC_INVALID_EXTENSION_ID;
1523: ELSE
1524: x_response.Result_Code := IBY_FNDCPT_COMMON_PUB.G_RC_SUCCESS;

Line 1521: iby_debug_pub.G_LEVEL_ERROR,l_dbg_mod);

1517:
1518: x_response.Result_Code := IBY_FNDCPT_COMMON_PUB.G_RC_SUCCESS;
1519: IF (c_extension%NOTFOUND) THEN
1520: iby_debug_pub.add('could not find extension',
1521: iby_debug_pub.G_LEVEL_ERROR,l_dbg_mod);
1522: x_response.Result_Code := G_RC_INVALID_EXTENSION_ID;
1523: ELSE
1524: x_response.Result_Code := IBY_FNDCPT_COMMON_PUB.G_RC_SUCCESS;
1525: END IF;

Line 1532: iby_debug_pub.add('Exit',iby_debug_pub.G_LEVEL_PROCEDURE,l_dbg_mod);

1528:
1529: iby_fndcpt_common_pub.Prepare_Result
1530: (l_prev_msg_count,x_return_status,x_msg_count,x_msg_data,x_response);
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:

Line 1537: iby_debug_pub.add(debug_msg => 'In G_EXC_ERROR Exception',

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);
1540: x_return_status := FND_API.G_RET_STS_ERROR;
1541: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

Line 1546: iby_debug_pub.add(debug_msg => 'In G_EXC_UNEXPECTED_ERROR Exception',

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);
1549: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1550: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

Line 1555: iby_debug_pub.add(debug_msg => 'In OTHERS Exception',

1551: p_data => x_msg_data
1552: );
1553: WHEN OTHERS THEN
1554:
1555: iby_debug_pub.add(debug_msg => 'In OTHERS Exception',
1556: debug_level => FND_LOG.LEVEL_UNEXPECTED,
1557: module => G_DEBUG_MODULE || l_module);
1558:
1559: iby_fndcpt_common_pub.Clear_Msg_Stack(l_prev_msg_count);

Line 1570: iby_debug_pub.add(debug_msg => 'x_return_status=' || x_return_status,

1566: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
1567: p_data => x_msg_data
1568: );
1569:
1570: iby_debug_pub.add(debug_msg => 'x_return_status=' || x_return_status,
1571: debug_level => FND_LOG.LEVEL_UNEXPECTED,
1572: module => G_DEBUG_MODULE || l_module);
1573: iby_debug_pub.add(debug_msg => 'Exit Exception',
1574: debug_level => FND_LOG.LEVEL_UNEXPECTED,

Line 1573: iby_debug_pub.add(debug_msg => 'Exit Exception',

1569:
1570: iby_debug_pub.add(debug_msg => 'x_return_status=' || x_return_status,
1571: debug_level => FND_LOG.LEVEL_UNEXPECTED,
1572: module => G_DEBUG_MODULE || l_module);
1573: iby_debug_pub.add(debug_msg => 'Exit Exception',
1574: debug_level => FND_LOG.LEVEL_UNEXPECTED,
1575: module => G_DEBUG_MODULE || l_module);
1576:
1577: END Get_Transaction_Extension;

Line 1629: iby_debug_pub.add('Enter',iby_debug_pub.G_LEVEL_PROCEDURE,l_dbg_mod);

1625: ci_payer_level,ci_payer_equiv,p.org_type,p.org_id,
1626: p.cust_account_id,p.acct_site_use_id) = 'T');
1627:
1628: BEGIN
1629: iby_debug_pub.add('Enter',iby_debug_pub.G_LEVEL_PROCEDURE,l_dbg_mod);
1630:
1631: IF (c_extension%ISOPEN) THEN
1632: CLOSE c_extension;
1633: END IF;

Line 1640: iby_debug_pub.add(debug_msg => 'Incorrect API Version:=' || p_api_version,

1636: p_api_version,
1637: l_module,
1638: G_PKG_NAME)
1639: THEN
1640: iby_debug_pub.add(debug_msg => 'Incorrect API Version:=' || p_api_version,
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;

Line 1653: iby_debug_pub.add('checking payer contxt',iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);

1649: FND_MSG_PUB.initialize;
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

Line 1671: iby_debug_pub.add('extension copied or operation done; cannot delete',

1667: l_copy_count := Get_Tx_Extension_Copy_Count(p_entity_id);
1668: IF ( Extension_Operation_Exists(p_entity_id)
1669: OR (l_copy_count>0) )
1670: THEN
1671: iby_debug_pub.add('extension copied or operation done; cannot delete',
1672: iby_debug_pub.G_LEVEL_ERROR,l_dbg_mod);
1673: x_response.Result_Code := G_RC_EXTENSION_IMMUTABLE;
1674: ELSE
1675: SAVEPOINT Delete_Transaction_Extension;

Line 1672: iby_debug_pub.G_LEVEL_ERROR,l_dbg_mod);

1668: IF ( Extension_Operation_Exists(p_entity_id)
1669: OR (l_copy_count>0) )
1670: THEN
1671: iby_debug_pub.add('extension copied or operation done; cannot delete',
1672: iby_debug_pub.G_LEVEL_ERROR,l_dbg_mod);
1673: x_response.Result_Code := G_RC_EXTENSION_IMMUTABLE;
1674: ELSE
1675: SAVEPOINT Delete_Transaction_Extension;
1676:

Line 1698: iby_debug_pub.add('Exit',iby_debug_pub.G_LEVEL_PROCEDURE,l_dbg_mod);

1694:
1695: iby_fndcpt_common_pub.Prepare_Result
1696: (l_prev_msg_count,x_return_status,x_msg_count,x_msg_data,x_response);
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;

Line 1703: iby_debug_pub.add(debug_msg => 'In G_EXC_ERROR Exception',

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);
1706: x_return_status := FND_API.G_RET_STS_ERROR;
1707: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

Line 1712: iby_debug_pub.add(debug_msg => 'In G_EXC_UNEXPECTED_ERROR Exception',

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);
1715: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1716: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

Line 1722: iby_debug_pub.add(debug_msg => 'In OTHERS Exception',

1718: );
1719:
1720: WHEN OTHERS THEN
1721: ROLLBACK TO Delete_Transaction_Extension;
1722: iby_debug_pub.add(debug_msg => 'In OTHERS Exception',
1723: debug_level => FND_LOG.LEVEL_UNEXPECTED,
1724: module => G_DEBUG_MODULE || l_module);
1725:
1726: iby_fndcpt_common_pub.Clear_Msg_Stack(l_prev_msg_count);

Line 1737: iby_debug_pub.add(debug_msg => 'x_return_status=' || x_return_status,

1733: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
1734: p_data => x_msg_data
1735: );
1736:
1737: iby_debug_pub.add(debug_msg => 'x_return_status=' || x_return_status,
1738: debug_level => FND_LOG.LEVEL_UNEXPECTED,
1739: module => G_DEBUG_MODULE || l_module);
1740: iby_debug_pub.add(debug_msg => 'Exit Exception',
1741: debug_level => FND_LOG.LEVEL_UNEXPECTED,

Line 1740: iby_debug_pub.add(debug_msg => 'Exit Exception',

1736:
1737: iby_debug_pub.add(debug_msg => 'x_return_status=' || x_return_status,
1738: debug_level => FND_LOG.LEVEL_UNEXPECTED,
1739: module => G_DEBUG_MODULE || l_module);
1740: iby_debug_pub.add(debug_msg => 'Exit Exception',
1741: debug_level => FND_LOG.LEVEL_UNEXPECTED,
1742: module => G_DEBUG_MODULE || l_module);
1743:
1744: END Delete_Transaction_Extension;

Line 1862: iby_debug_pub.add('Enter',iby_debug_pub.G_LEVEL_PROCEDURE,l_dbg_mod);

1858: )
1859: AND (up.sys_eft_profile_code = sp.sys_eft_profile_code(+));
1860:
1861: BEGIN
1862: iby_debug_pub.add('Enter',iby_debug_pub.G_LEVEL_PROCEDURE,l_dbg_mod);
1863:
1864: IF (c_extension%ISOPEN) THEN CLOSE c_extension; END IF;
1865: IF (c_auths%ISOPEN) THEN CLOSE c_auths; END IF;
1866:

Line 1872: iby_debug_pub.add(debug_msg => 'Incorrect API Version:=' || p_api_version,

1868: p_api_version,
1869: l_module,
1870: G_PKG_NAME)
1871: THEN
1872: iby_debug_pub.add(debug_msg => 'Incorrect API Version:=' || p_api_version,
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;

Line 1889: iby_debug_pub.add('checking payer context',iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);

1885: SAVEPOINT Copy_Txn_Extension_Merge;
1886:
1887: l_extension := p_trxn_attribs;
1888:
1889: iby_debug_pub.add('checking payer context',iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
1890:
1891: iby_debug_pub.add('party id =' || p_payer.Party_Id,iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
1892: iby_debug_pub.add('account id =' || p_payer.Cust_Account_Id,iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
1893: iby_debug_pub.add('account site use id =' || p_payer.Account_Site_Id,iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);

Line 1891: iby_debug_pub.add('party id =' || p_payer.Party_Id,iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);

1887: l_extension := p_trxn_attribs;
1888:
1889: iby_debug_pub.add('checking payer context',iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
1890:
1891: iby_debug_pub.add('party id =' || p_payer.Party_Id,iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
1892: iby_debug_pub.add('account id =' || p_payer.Cust_Account_Id,iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
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);

Line 1892: iby_debug_pub.add('account id =' || p_payer.Cust_Account_Id,iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);

1888:
1889: iby_debug_pub.add('checking payer context',iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
1890:
1891: iby_debug_pub.add('party id =' || p_payer.Party_Id,iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
1892: iby_debug_pub.add('account id =' || p_payer.Cust_Account_Id,iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
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:

Line 1893: iby_debug_pub.add('account site use id =' || p_payer.Account_Site_Id,iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);

1889: iby_debug_pub.add('checking payer context',iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
1890:
1891: iby_debug_pub.add('party id =' || p_payer.Party_Id,iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
1892: iby_debug_pub.add('account id =' || p_payer.Cust_Account_Id,iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
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,

Line 1894: iby_debug_pub.add('org id =' || p_payer.Org_Id,iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);

1890:
1891: iby_debug_pub.add('party id =' || p_payer.Party_Id,iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
1892: iby_debug_pub.add('account id =' || p_payer.Cust_Account_Id,iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
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);

Line 1895: iby_debug_pub.add('org type =' || p_payer.Org_Type,iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);

1891: iby_debug_pub.add('party id =' || p_payer.Party_Id,iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
1892: iby_debug_pub.add('account id =' || p_payer.Cust_Account_Id,iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
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:

Line 1911: iby_debug_pub.add('order id invalid',iby_debug_pub.G_LEVEL_ERROR,l_dbg_mod);

1907: l_extension.Trxn_Ref_Number2))
1908: > iby_bill_pkg.G_MAX_TANGIBLEID_LEN
1909: )
1910: THEN
1911: iby_debug_pub.add('order id invalid',iby_debug_pub.G_LEVEL_ERROR,l_dbg_mod);
1912: x_response.Result_Code := G_RC_INVALID_EXTENSION_ATTRIB;
1913: iby_fndcpt_common_pub.Prepare_Result
1914: (l_prev_msg_count,x_return_status,x_msg_count,x_msg_data,x_response);
1915: RETURN;

Line 1923: iby_debug_pub.add('setting payer attribs',iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);

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
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

Line 1939: iby_debug_pub.add('trxn entity id:=' || p_entities(i),

1935:
1936: l_val_instr := (NOT p_trxn_attribs.Copy_Instr_Assign_Id IS NULL);
1937:
1938: FOR i IN p_entities.FIRST..p_entities.LAST LOOP
1939: iby_debug_pub.add('trxn entity id:=' || p_entities(i),
1940: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
1941: iby_debug_pub.add('copy instr assignment:=' || p_trxn_attribs.Copy_Instr_Assign_Id,
1942: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
1943:

Line 1940: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);

1936: l_val_instr := (NOT p_trxn_attribs.Copy_Instr_Assign_Id IS NULL);
1937:
1938: FOR i IN p_entities.FIRST..p_entities.LAST LOOP
1939: iby_debug_pub.add('trxn entity id:=' || p_entities(i),
1940: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
1941: iby_debug_pub.add('copy instr assignment:=' || p_trxn_attribs.Copy_Instr_Assign_Id,
1942: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
1943:
1944: OPEN c_extension(p_entities(i), p_payer, l_payer_level,

Line 1941: iby_debug_pub.add('copy instr assignment:=' || p_trxn_attribs.Copy_Instr_Assign_Id,

1937:
1938: FOR i IN p_entities.FIRST..p_entities.LAST LOOP
1939: iby_debug_pub.add('trxn entity id:=' || p_entities(i),
1940: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
1941: iby_debug_pub.add('copy instr assignment:=' || p_trxn_attribs.Copy_Instr_Assign_Id,
1942: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
1943:
1944: OPEN c_extension(p_entities(i), p_payer, l_payer_level,
1945: p_payer_equivalency,

Line 1942: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);

1938: FOR i IN p_entities.FIRST..p_entities.LAST LOOP
1939: iby_debug_pub.add('trxn entity id:=' || p_entities(i),
1940: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
1941: iby_debug_pub.add('copy instr assignment:=' || p_trxn_attribs.Copy_Instr_Assign_Id,
1942: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
1943:
1944: OPEN c_extension(p_entities(i), p_payer, l_payer_level,
1945: p_payer_equivalency,
1946: p_trxn_attribs.Copy_Instr_Assign_Id);

Line 1972: iby_debug_pub.add('payer instr assignment invalid ' ||

1968: TRUE
1969: )
1970: )
1971: THEN
1972: iby_debug_pub.add('payer instr assignment invalid ' ||
1973: p_trxn_attribs.Copy_Instr_Assign_Id ||
1974: ' for channel ' || l_pmt_channel,
1975: iby_debug_pub.G_LEVEL_ERROR,l_dbg_mod);
1976: x_response.Result_Code :=

Line 1975: iby_debug_pub.G_LEVEL_ERROR,l_dbg_mod);

1971: THEN
1972: iby_debug_pub.add('payer instr assignment invalid ' ||
1973: p_trxn_attribs.Copy_Instr_Assign_Id ||
1974: ' for channel ' || l_pmt_channel,
1975: iby_debug_pub.G_LEVEL_ERROR,l_dbg_mod);
1976: x_response.Result_Code :=
1977: IBY_FNDCPT_SETUP_PUB.G_RC_INVALID_INSTR_ASSIGN;
1978: iby_fndcpt_common_pub.Prepare_Result
1979: (l_prev_msg_count,x_return_status,x_msg_count,x_msg_data,x_response);

Line 1986: iby_debug_pub.add('extension invalid for payer, or non-existant',

1982: l_instr_assign_id := p_trxn_attribs.Copy_Instr_Assign_Id;
1983: l_val_instr := FALSE;
1984: END IF;
1985: IF (l_x_not_found) THEN
1986: iby_debug_pub.add('extension invalid for payer, or non-existant',
1987: iby_debug_pub.G_LEVEL_ERROR,l_dbg_mod);
1988: x_response.Result_Code := G_RC_INVALID_EXTENSION_ID;
1989: iby_fndcpt_common_pub.Prepare_Result
1990: (l_prev_msg_count,x_return_status,x_msg_count,x_msg_data,x_response);

Line 1987: iby_debug_pub.G_LEVEL_ERROR,l_dbg_mod);

1983: l_val_instr := FALSE;
1984: END IF;
1985: IF (l_x_not_found) THEN
1986: iby_debug_pub.add('extension invalid for payer, or non-existant',
1987: iby_debug_pub.G_LEVEL_ERROR,l_dbg_mod);
1988: x_response.Result_Code := G_RC_INVALID_EXTENSION_ID;
1989: iby_fndcpt_common_pub.Prepare_Result
1990: (l_prev_msg_count,x_return_status,x_msg_count,x_msg_data,x_response);
1991: RETURN;

Line 1997: iby_debug_pub.add('incompatible pmt chanenel ' || l_pmt_channel,

1993: -- instr assignment may change;
1994: --OR (l_instr_assign_id<>lc_instr_assign_id)
1995: )
1996: THEN
1997: iby_debug_pub.add('incompatible pmt chanenel ' || l_pmt_channel,
1998: iby_debug_pub.G_LEVEL_ERROR,l_dbg_mod);
1999: x_response.Result_Code := G_RC_INCMP_EXTENSION_GROUP;
2000: iby_fndcpt_common_pub.Prepare_Result
2001: (l_prev_msg_count,x_return_status,x_msg_count,x_msg_data,x_response);

Line 1998: iby_debug_pub.G_LEVEL_ERROR,l_dbg_mod);

1994: --OR (l_instr_assign_id<>lc_instr_assign_id)
1995: )
1996: THEN
1997: iby_debug_pub.add('incompatible pmt chanenel ' || l_pmt_channel,
1998: iby_debug_pub.G_LEVEL_ERROR,l_dbg_mod);
1999: x_response.Result_Code := G_RC_INCMP_EXTENSION_GROUP;
2000: iby_fndcpt_common_pub.Prepare_Result
2001: (l_prev_msg_count,x_return_status,x_msg_count,x_msg_data,x_response);
2002: RETURN;

Line 2047: iby_debug_pub.add('persistent auth; cannot do 1-to-many copy',

2043: FETCH c_auths INTO l_persist_auth;
2044: CLOSE c_auths;
2045:
2046: IF (l_persist_auth = 'Y') THEN
2047: iby_debug_pub.add('persistent auth; cannot do 1-to-many copy',
2048: iby_debug_pub.G_LEVEL_ERROR,l_dbg_mod);
2049: x_response.Result_Code := G_RC_INCMP_EXTENSION_GROUP;
2050: iby_fndcpt_common_pub.Prepare_Result
2051: (l_prev_msg_count,x_return_status,x_msg_count,x_msg_data,x_response);

Line 2048: iby_debug_pub.G_LEVEL_ERROR,l_dbg_mod);

2044: CLOSE c_auths;
2045:
2046: IF (l_persist_auth = 'Y') THEN
2047: iby_debug_pub.add('persistent auth; cannot do 1-to-many copy',
2048: iby_debug_pub.G_LEVEL_ERROR,l_dbg_mod);
2049: x_response.Result_Code := G_RC_INCMP_EXTENSION_GROUP;
2050: iby_fndcpt_common_pub.Prepare_Result
2051: (l_prev_msg_count,x_return_status,x_msg_count,x_msg_data,x_response);
2052: RETURN;

Line 2145: iby_debug_pub.add('Exit',iby_debug_pub.G_LEVEL_PROCEDURE,l_dbg_mod);

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);
2146: EXCEPTION
2147:
2148: WHEN FND_API.G_EXC_ERROR THEN
2149: ROLLBACK TO Copy_Txn_Extension_Merge;

Line 2150: iby_debug_pub.add(debug_msg => 'In G_EXC_ERROR Exception',

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);
2153: x_return_status := FND_API.G_RET_STS_ERROR;
2154: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

Line 2159: iby_debug_pub.add(debug_msg => 'In G_EXC_UNEXPECTED_ERROR Exception',

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);
2162: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2163: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

Line 2170: iby_debug_pub.add(debug_msg => 'In OTHERS Exception',

2166:
2167: WHEN OTHERS THEN
2168: ROLLBACK TO Copy_Txn_Extension_Merge;
2169:
2170: iby_debug_pub.add(debug_msg => 'In OTHERS Exception',
2171: debug_level => FND_LOG.LEVEL_UNEXPECTED,
2172: module => G_DEBUG_MODULE || l_module);
2173:
2174: iby_fndcpt_common_pub.Clear_Msg_Stack(l_prev_msg_count);

Line 2185: iby_debug_pub.add(debug_msg => 'x_return_status=' || x_return_status,

2181: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
2182: p_data => x_msg_data
2183: );
2184:
2185: iby_debug_pub.add(debug_msg => 'x_return_status=' || x_return_status,
2186: debug_level => FND_LOG.LEVEL_UNEXPECTED,
2187: module => G_DEBUG_MODULE || l_module);
2188: iby_debug_pub.add(debug_msg => 'Exit Exception',
2189: debug_level => FND_LOG.LEVEL_UNEXPECTED,

Line 2188: iby_debug_pub.add(debug_msg => 'Exit Exception',

2184:
2185: iby_debug_pub.add(debug_msg => 'x_return_status=' || x_return_status,
2186: debug_level => FND_LOG.LEVEL_UNEXPECTED,
2187: module => G_DEBUG_MODULE || l_module);
2188: iby_debug_pub.add(debug_msg => 'Exit Exception',
2189: debug_level => FND_LOG.LEVEL_UNEXPECTED,
2190: module => G_DEBUG_MODULE || l_module);
2191:
2192: END Copy_Transaction_Extension;

Line 2389: iby_debug_pub.add('Enter',iby_debug_pub.G_LEVEL_PROCEDURE,l_dbg_mod);

2385: WHERE o.transactionid = ci_trxn_id
2386: AND o.trxn_extension_id = ci_trxn_extension_id;
2387:
2388: BEGIN
2389: iby_debug_pub.add('Enter',iby_debug_pub.G_LEVEL_PROCEDURE,l_dbg_mod);
2390:
2391: IF (c_extension%ISOPEN) THEN CLOSE c_extension; END IF;
2392: IF (c_auth%ISOPEN) THEN CLOSE c_auth; END IF;
2393: IF (c_instr_extensions%ISOPEN) THEN CLOSE c_instr_extensions; END IF;

Line 2401: iby_debug_pub.add(debug_msg => 'Incorrect API Version:=' || p_api_version,

2397: p_api_version,
2398: l_module,
2399: G_PKG_NAME)
2400: THEN
2401: iby_debug_pub.add(debug_msg => 'Incorrect API Version:=' || p_api_version,
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;

Line 2414: iby_debug_pub.add('checking payer context',iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);

2410: FND_MSG_PUB.initialize;
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

Line 2436: iby_debug_pub.add('channel code:=' || l_pmt_trxn.payment_channel_code,

2432: l_pmt_trxn.payment_channel_code;
2433: l_ext_not_found := c_extension%NOTFOUND;
2434: CLOSE c_extension;
2435:
2436: iby_debug_pub.add('channel code:=' || l_pmt_trxn.payment_channel_code,
2437: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
2438: iby_debug_pub.add('instrument type:=' || l_pmt_instr.pmtinstr_type,
2439: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
2440:

Line 2437: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);

2433: l_ext_not_found := c_extension%NOTFOUND;
2434: CLOSE c_extension;
2435:
2436: iby_debug_pub.add('channel code:=' || l_pmt_trxn.payment_channel_code,
2437: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
2438: iby_debug_pub.add('instrument type:=' || l_pmt_instr.pmtinstr_type,
2439: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
2440:
2441: IF (NOT l_ext_not_found) THEN

Line 2438: iby_debug_pub.add('instrument type:=' || l_pmt_instr.pmtinstr_type,

2434: CLOSE c_extension;
2435:
2436: iby_debug_pub.add('channel code:=' || l_pmt_trxn.payment_channel_code,
2437: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
2438: iby_debug_pub.add('instrument type:=' || l_pmt_instr.pmtinstr_type,
2439: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
2440:
2441: IF (NOT l_ext_not_found) THEN
2442:

Line 2439: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);

2435:
2436: iby_debug_pub.add('channel code:=' || l_pmt_trxn.payment_channel_code,
2437: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
2438: iby_debug_pub.add('instrument type:=' || l_pmt_instr.pmtinstr_type,
2439: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
2440:
2441: IF (NOT l_ext_not_found) THEN
2442:
2443: -- map the records

Line 2458: iby_debug_pub.add('extension has been copied ' || l_copy_count

2454: (l_prev_msg_count,x_return_status,x_msg_count,x_msg_data,x_response);
2455: RETURN;
2456: -- cannot do operations on a trxn entity already copied
2457: ELSIF (l_copy_count>0) THEN
2458: iby_debug_pub.add('extension has been copied ' || l_copy_count
2459: || ' times; cannot auth',iby_debug_pub.G_LEVEL_ERROR,l_dbg_mod);
2460: x_response.Result_Code := G_RC_EXTENSION_IMMUTABLE;
2461: iby_fndcpt_common_pub.Prepare_Result
2462: (l_prev_msg_count,x_return_status,x_msg_count,x_msg_data,x_response);

Line 2459: || ' times; cannot auth',iby_debug_pub.G_LEVEL_ERROR,l_dbg_mod);

2455: RETURN;
2456: -- cannot do operations on a trxn entity already copied
2457: ELSIF (l_copy_count>0) THEN
2458: iby_debug_pub.add('extension has been copied ' || l_copy_count
2459: || ' times; cannot auth',iby_debug_pub.G_LEVEL_ERROR,l_dbg_mod);
2460: x_response.Result_Code := G_RC_EXTENSION_IMMUTABLE;
2461: iby_fndcpt_common_pub.Prepare_Result
2462: (l_prev_msg_count,x_return_status,x_msg_count,x_msg_data,x_response);
2463: RETURN;

Line 2505: iby_debug_pub.add('single use instrument cannot be reused',

2501: l_pmt_instr.PmtInstr_Id, p_trxn_entity_id);
2502: FETCH c_instr_extensions INTO l_instr_auth_flag;
2503: CLOSE c_instr_extensions;
2504: IF (NVL(l_instr_auth_flag,'N') = 'Y') THEN
2505: iby_debug_pub.add('single use instrument cannot be reused',
2506: iby_debug_pub.G_LEVEL_ERROR,l_dbg_mod);
2507: x_response.Result_Code := IBY_FNDCPT_SETUP_PUB.G_RC_INVALID_INSTRUMENT;
2508: iby_fndcpt_common_pub.Prepare_Result
2509: (l_prev_msg_count,x_return_status,x_msg_count,x_msg_data,x_response);

Line 2506: iby_debug_pub.G_LEVEL_ERROR,l_dbg_mod);

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

Line 2517: iby_debug_pub.add('extension already authorized',

2513:
2514: OPEN c_auth(p_trxn_entity_id);
2515: FETCH c_auth INTO l_auth_flag;
2516: IF (l_auth_flag = 'Y') THEN
2517: iby_debug_pub.add('extension already authorized',
2518: iby_debug_pub.G_LEVEL_ERROR,l_dbg_mod);
2519: x_response.Result_Code := G_RC_DUPLICATE_AUTHORIZATION;
2520: ELSE
2521: IF (p_auth_attribs.RiskEval_Enable_Flag = 'Y') THEN

Line 2518: iby_debug_pub.G_LEVEL_ERROR,l_dbg_mod);

2514: OPEN c_auth(p_trxn_entity_id);
2515: FETCH c_auth INTO l_auth_flag;
2516: IF (l_auth_flag = 'Y') THEN
2517: iby_debug_pub.add('extension already authorized',
2518: iby_debug_pub.G_LEVEL_ERROR,l_dbg_mod);
2519: x_response.Result_Code := G_RC_DUPLICATE_AUTHORIZATION;
2520: ELSE
2521: IF (p_auth_attribs.RiskEval_Enable_Flag = 'Y') THEN
2522: l_pmt_trxn.AnalyzeRisk := 'TRUE';

Line 2525: iby_debug_pub.add('send auth',iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);

2521: IF (p_auth_attribs.RiskEval_Enable_Flag = 'Y') THEN
2522: l_pmt_trxn.AnalyzeRisk := 'TRUE';
2523: END IF;
2524:
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,

Line 2543: iby_debug_pub.add('status :=' || l_return_status,

2539: l_msg_data,
2540: l_reqresp
2541: );
2542:
2543: iby_debug_pub.add('status :=' || l_return_status,
2544: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
2545: iby_debug_pub.add('auth status :=' ||
2546: to_char(l_reqresp.Response.Status),
2547: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);

Line 2544: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);

2540: l_reqresp
2541: );
2542:
2543: iby_debug_pub.add('status :=' || l_return_status,
2544: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
2545: iby_debug_pub.add('auth status :=' ||
2546: to_char(l_reqresp.Response.Status),
2547: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
2548: iby_debug_pub.add('auth engine code :=' ||

Line 2545: iby_debug_pub.add('auth status :=' ||

2541: );
2542:
2543: iby_debug_pub.add('status :=' || l_return_status,
2544: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
2545: iby_debug_pub.add('auth status :=' ||
2546: to_char(l_reqresp.Response.Status),
2547: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
2548: iby_debug_pub.add('auth engine code :=' ||
2549: to_char(l_reqresp.Response.ErrCode),

Line 2547: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);

2543: iby_debug_pub.add('status :=' || l_return_status,
2544: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
2545: iby_debug_pub.add('auth status :=' ||
2546: to_char(l_reqresp.Response.Status),
2547: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
2548: iby_debug_pub.add('auth engine code :=' ||
2549: to_char(l_reqresp.Response.ErrCode),
2550: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
2551: iby_debug_pub.add('auth engine msg :=' ||

Line 2548: iby_debug_pub.add('auth engine code :=' ||

2544: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
2545: iby_debug_pub.add('auth status :=' ||
2546: to_char(l_reqresp.Response.Status),
2547: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
2548: iby_debug_pub.add('auth engine code :=' ||
2549: to_char(l_reqresp.Response.ErrCode),
2550: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
2551: iby_debug_pub.add('auth engine msg :=' ||
2552: to_char(l_reqresp.Response.ErrMessage),

Line 2550: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);

2546: to_char(l_reqresp.Response.Status),
2547: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
2548: iby_debug_pub.add('auth engine code :=' ||
2549: to_char(l_reqresp.Response.ErrCode),
2550: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
2551: iby_debug_pub.add('auth engine msg :=' ||
2552: to_char(l_reqresp.Response.ErrMessage),
2553: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
2554:

Line 2551: iby_debug_pub.add('auth engine msg :=' ||

2547: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
2548: iby_debug_pub.add('auth engine code :=' ||
2549: to_char(l_reqresp.Response.ErrCode),
2550: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
2551: iby_debug_pub.add('auth engine msg :=' ||
2552: to_char(l_reqresp.Response.ErrMessage),
2553: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
2554:
2555: iby_debug_pub.add('payment system code :=' ||

Line 2553: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);

2549: to_char(l_reqresp.Response.ErrCode),
2550: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
2551: iby_debug_pub.add('auth engine msg :=' ||
2552: to_char(l_reqresp.Response.ErrMessage),
2553: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
2554:
2555: iby_debug_pub.add('payment system code :=' ||
2556: to_char(l_reqresp.BEPErrCode),
2557: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);

Line 2555: iby_debug_pub.add('payment system code :=' ||

2551: iby_debug_pub.add('auth engine msg :=' ||
2552: to_char(l_reqresp.Response.ErrMessage),
2553: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
2554:
2555: iby_debug_pub.add('payment system code :=' ||
2556: to_char(l_reqresp.BEPErrCode),
2557: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
2558: iby_debug_pub.add('payment system msg :=' ||
2559: to_char(l_reqresp.BEPErrMessage),

Line 2557: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);

2553: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
2554:
2555: iby_debug_pub.add('payment system code :=' ||
2556: to_char(l_reqresp.BEPErrCode),
2557: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
2558: iby_debug_pub.add('payment system msg :=' ||
2559: to_char(l_reqresp.BEPErrMessage),
2560: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
2561:

Line 2558: iby_debug_pub.add('payment system msg :=' ||

2554:
2555: iby_debug_pub.add('payment system code :=' ||
2556: to_char(l_reqresp.BEPErrCode),
2557: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
2558: iby_debug_pub.add('payment system msg :=' ||
2559: to_char(l_reqresp.BEPErrMessage),
2560: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
2561:
2562: iby_debug_pub.add('trxn id :=' ||

Line 2560: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);

2556: to_char(l_reqresp.BEPErrCode),
2557: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
2558: iby_debug_pub.add('payment system msg :=' ||
2559: to_char(l_reqresp.BEPErrMessage),
2560: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
2561:
2562: iby_debug_pub.add('trxn id :=' ||
2563: to_char(l_reqresp.Trxn_ID),
2564: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);

Line 2562: iby_debug_pub.add('trxn id :=' ||

2558: iby_debug_pub.add('payment system msg :=' ||
2559: to_char(l_reqresp.BEPErrMessage),
2560: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
2561:
2562: iby_debug_pub.add('trxn id :=' ||
2563: to_char(l_reqresp.Trxn_ID),
2564: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
2565:
2566: IF (p_auth_attribs.RiskEval_Enable_Flag = 'Y') THEN

Line 2564: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);

2560: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
2561:
2562: iby_debug_pub.add('trxn id :=' ||
2563: to_char(l_reqresp.Trxn_ID),
2564: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
2565:
2566: IF (p_auth_attribs.RiskEval_Enable_Flag = 'Y') THEN
2567: x_auth_result.Risk_Result.Risk_Score :=
2568: l_reqresp.RiskResponse.Risk_Score;

Line 2609: iby_debug_pub.add('Set DirectDebit_BankInstruction for trxn',

2605: UPDATE iby_trxn_summaries_all
2606: SET dirdeb_instruction_code = l_payer_attribs.DirectDebit_BankInstruction
2607: WHERE transactionid = l_reqresp.Trxn_Id;
2608:
2609: iby_debug_pub.add('Set DirectDebit_BankInstruction for trxn',
2610: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
2611:
2612: EXCEPTION
2613: WHEN OTHERS THEN

Line 2610: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);

2606: SET dirdeb_instruction_code = l_payer_attribs.DirectDebit_BankInstruction
2607: WHERE transactionid = l_reqresp.Trxn_Id;
2608:
2609: iby_debug_pub.add('Set DirectDebit_BankInstruction for trxn',
2610: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
2611:
2612: EXCEPTION
2613: WHEN OTHERS THEN
2614: iby_debug_pub.add('Unable to retrieve/set payer attribs for trxn',

Line 2614: iby_debug_pub.add('Unable to retrieve/set payer attribs for trxn',

2610: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
2611:
2612: EXCEPTION
2613: WHEN OTHERS THEN
2614: iby_debug_pub.add('Unable to retrieve/set payer attribs for trxn',
2615: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
2616:
2617: END;
2618:

Line 2615: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);

2611:
2612: EXCEPTION
2613: WHEN OTHERS THEN
2614: iby_debug_pub.add('Unable to retrieve/set payer attribs for trxn',
2615: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
2616:
2617: END;
2618:
2619: -- Fix for bug# 7377455. Stamp the tangibleid on the PSON column of

Line 2621: iby_debug_pub.add( 'Stamping the PSON on the extension as '||

2617: END;
2618:
2619: -- Fix for bug# 7377455. Stamp the tangibleid on the PSON column of
2620: -- IBY_FNDCPT_TX_EXTENSIONS table
2621: iby_debug_pub.add( 'Stamping the PSON on the extension as '||
2622: l_tangible.Tangible_Id,
2623: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
2624:
2625: UPDATE iby_fndcpt_tx_extensions

Line 2623: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);

2619: -- Fix for bug# 7377455. Stamp the tangibleid on the PSON column of
2620: -- IBY_FNDCPT_TX_EXTENSIONS table
2621: iby_debug_pub.add( 'Stamping the PSON on the extension as '||
2622: l_tangible.Tangible_Id,
2623: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
2624:
2625: UPDATE iby_fndcpt_tx_extensions
2626: SET payment_system_order_number = l_tangible.Tangible_Id
2627: WHERE trxn_extension_id = p_trxn_entity_id;

Line 2631: iby_debug_pub.add( 'Stamping '||p_trxn_entity_id ||' as the initiator_extension_id'

2627: WHERE trxn_extension_id = p_trxn_entity_id;
2628:
2629: -- Fix for bug# 7530578. Stamp the initiator transaction extension id
2630: -- on the corresponding record in iby_trxn_summaries_all
2631: iby_debug_pub.add( 'Stamping '||p_trxn_entity_id ||' as the initiator_extension_id'
2632: ||'on the auth record', iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
2633:
2634: UPDATE iby_trxn_summaries_all
2635: SET initiator_extension_id = p_trxn_entity_id

Line 2632: ||'on the auth record', iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);

2628:
2629: -- Fix for bug# 7530578. Stamp the initiator transaction extension id
2630: -- on the corresponding record in iby_trxn_summaries_all
2631: iby_debug_pub.add( 'Stamping '||p_trxn_entity_id ||' as the initiator_extension_id'
2632: ||'on the auth record', iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
2633:
2634: UPDATE iby_trxn_summaries_all
2635: SET initiator_extension_id = p_trxn_entity_id
2636: WHERE transactionid = l_reqresp.Trxn_Id

Line 2639: iby_debug_pub.add('creating extension operation record for=' ||

2635: SET initiator_extension_id = p_trxn_entity_id
2636: WHERE transactionid = l_reqresp.Trxn_Id
2637: AND reqtype = 'ORAPMTREQ';
2638:
2639: iby_debug_pub.add('creating extension operation record for=' ||
2640: p_trxn_entity_id,
2641: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
2642:
2643: -- check to see if the operation is already recorded

Line 2641: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);

2637: AND reqtype = 'ORAPMTREQ';
2638:
2639: iby_debug_pub.add('creating extension operation record for=' ||
2640: p_trxn_entity_id,
2641: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
2642:
2643: -- check to see if the operation is already recorded
2644: OPEN c_operation_count(p_trxn_entity_id,l_reqresp.Trxn_Id);
2645: FETCH c_operation_count INTO l_op_count;

Line 2650: iby_debug_pub.add( 'operation already recorded',

2646: CLOSE c_operation_count;
2647: l_op_count := NVL(l_op_count,0);
2648:
2649: IF ( l_op_count > 0 ) THEN
2650: iby_debug_pub.add( 'operation already recorded',
2651: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
2652: ELSE
2653: INSERT INTO iby_fndcpt_tx_operations
2654: (trxn_extension_id, transactionid,

Line 2651: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);

2647: l_op_count := NVL(l_op_count,0);
2648:
2649: IF ( l_op_count > 0 ) THEN
2650: iby_debug_pub.add( 'operation already recorded',
2651: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
2652: ELSE
2653: INSERT INTO iby_fndcpt_tx_operations
2654: (trxn_extension_id, transactionid,
2655: created_by, creation_date, last_updated_by, last_update_date,

Line 2679: iby_debug_pub.add('back-propogated rows:='||SQL%ROWCOUNT,

2675: FROM iby_fndcpt_tx_xe_copies
2676: START WITH copy_trxn_extension_id = p_trxn_entity_id
2677: CONNECT BY PRIOR source_trxn_extension_id = copy_trxn_extension_id;
2678:
2679: iby_debug_pub.add('back-propogated rows:='||SQL%ROWCOUNT,
2680: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
2681:
2682: --
2683: -- forward propogate the authorization

Line 2680: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);

2676: START WITH copy_trxn_extension_id = p_trxn_entity_id
2677: CONNECT BY PRIOR source_trxn_extension_id = copy_trxn_extension_id;
2678:
2679: iby_debug_pub.add('back-propogated rows:='||SQL%ROWCOUNT,
2680: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
2681:
2682: --
2683: -- forward propogate the authorization
2684: --

Line 2697: iby_debug_pub.add('forward-propogated rows:='||SQL%ROWCOUNT,

2693: FROM iby_fndcpt_tx_xe_copies
2694: START WITH source_trxn_extension_id = p_trxn_entity_id
2695: CONNECT BY source_trxn_extension_id = PRIOR copy_trxn_extension_id;
2696:
2697: iby_debug_pub.add('forward-propogated rows:='||SQL%ROWCOUNT,
2698: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
2699:
2700: END IF;
2701:

Line 2698: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);

2694: START WITH source_trxn_extension_id = p_trxn_entity_id
2695: CONNECT BY source_trxn_extension_id = PRIOR copy_trxn_extension_id;
2696:
2697: iby_debug_pub.add('forward-propogated rows:='||SQL%ROWCOUNT,
2698: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
2699:
2700: END IF;
2701:
2702: x_auth_result.Auth_Id := l_reqresp.Trxn_Id;

Line 2755: iby_debug_pub.add('fail msg code:=' || l_fail_msg,

2751: ELSE
2752: x_response.Result_Code := G_RC_INVALID_EXTENSION_ID;
2753:
2754: l_fail_msg := Get_Extension_Auth_Fail(p_trxn_entity_id,p_payer);
2755: iby_debug_pub.add('fail msg code:=' || l_fail_msg,
2756: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
2757: IF (NOT l_fail_msg IS NULL) THEN
2758: FND_MESSAGE.SET_NAME('IBY',l_fail_msg);
2759: l_fail_msg := FND_MESSAGE.GET();

Line 2756: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);

2752: x_response.Result_Code := G_RC_INVALID_EXTENSION_ID;
2753:
2754: l_fail_msg := Get_Extension_Auth_Fail(p_trxn_entity_id,p_payer);
2755: iby_debug_pub.add('fail msg code:=' || l_fail_msg,
2756: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
2757: IF (NOT l_fail_msg IS NULL) THEN
2758: FND_MESSAGE.SET_NAME('IBY',l_fail_msg);
2759: l_fail_msg := FND_MESSAGE.GET();
2760:

Line 2774: iby_debug_pub.add('Exit',iby_debug_pub.G_LEVEL_PROCEDURE,l_dbg_mod);

2770:
2771: iby_fndcpt_common_pub.Prepare_Result
2772: (l_prev_msg_count,x_return_status,x_msg_count,x_msg_data,x_response);
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:

Line 2779: iby_debug_pub.add(debug_msg => 'In G_EXC_ERROR Exception',

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);
2782: x_return_status := FND_API.G_RET_STS_ERROR;
2783: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

Line 2788: iby_debug_pub.add(debug_msg => 'In G_EXC_UNEXPECTED_ERROR Exception',

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);
2791: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2792: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

Line 2798: iby_debug_pub.add(debug_msg => 'In OTHERS Exception',

2794: );
2795:
2796: WHEN OTHERS THEN
2797:
2798: iby_debug_pub.add(debug_msg => 'In OTHERS Exception',
2799: debug_level => FND_LOG.LEVEL_UNEXPECTED,
2800: module => G_DEBUG_MODULE || l_module);
2801:
2802: iby_fndcpt_common_pub.Clear_Msg_Stack(l_prev_msg_count);

Line 2854: iby_debug_pub.add(debug_msg => 'Incorrect API Version:=' || p_api_version,

2850: p_api_version,
2851: l_module,
2852: G_PKG_NAME)
2853: THEN
2854: iby_debug_pub.add(debug_msg => 'Incorrect API Version:=' || p_api_version,
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;

Line 2886: iby_debug_pub.add(debug_msg => 'In G_EXC_ERROR Exception',

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);
2889: x_return_status := FND_API.G_RET_STS_ERROR;
2890: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

Line 2895: iby_debug_pub.add(debug_msg => 'In G_EXC_UNEXPECTED_ERROR Exception',

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);
2898: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2899: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

Line 2905: iby_debug_pub.add(debug_msg => 'In OTHERS Exception',

2901: );
2902:
2903: WHEN OTHERS THEN
2904:
2905: iby_debug_pub.add(debug_msg => 'In OTHERS Exception',
2906: debug_level => FND_LOG.LEVEL_UNEXPECTED,
2907: module => G_DEBUG_MODULE || l_module);
2908:
2909: iby_fndcpt_common_pub.Clear_Msg_Stack(l_prev_msg_count);

Line 2945: iby_debug_pub.add(debug_msg => 'Incorrect API Version:=' || p_api_version,

2941: p_api_version,
2942: l_module,
2943: G_PKG_NAME)
2944: THEN
2945: iby_debug_pub.add(debug_msg => 'Incorrect API Version:=' || p_api_version,
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;

Line 2967: iby_debug_pub.add(debug_msg => 'In G_EXC_ERROR Exception',

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);
2970: x_return_status := FND_API.G_RET_STS_ERROR;
2971: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

Line 2976: iby_debug_pub.add(debug_msg => 'In G_EXC_UNEXPECTED_ERROR Exception',

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);
2979: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2980: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

Line 2986: iby_debug_pub.add(debug_msg => 'In OTHERS Exception',

2982: );
2983:
2984: WHEN OTHERS THEN
2985:
2986: iby_debug_pub.add(debug_msg => 'In OTHERS Exception',
2987: debug_level => FND_LOG.LEVEL_UNEXPECTED,
2988: module => G_DEBUG_MODULE || l_module);
2989:
2990: iby_fndcpt_common_pub.Clear_Msg_Stack(l_prev_msg_count);

Line 3117: iby_debug_pub.add('Enter',iby_debug_pub.G_LEVEL_PROCEDURE,l_dbg_mod);

3113:
3114: BEGIN
3115:
3116:
3117: iby_debug_pub.add('Enter',iby_debug_pub.G_LEVEL_PROCEDURE,l_dbg_mod);
3118:
3119:
3120: IF (c_extension%ISOPEN) THEN CLOSE c_extension; END IF;
3121: IF (c_auth%ISOPEN) THEN CLOSE c_auth; END IF;

Line 3130: iby_debug_pub.add(debug_msg => 'Incorrect API Version:=' || p_api_version,

3126: p_api_version,
3127: l_module,
3128: G_PKG_NAME)
3129: THEN
3130: iby_debug_pub.add(debug_msg => 'Incorrect API Version:=' || p_api_version,
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;

Line 3147: iby_debug_pub.add('invalid payer',iby_debug_pub.G_LEVEL_ERROR,l_dbg_mod);

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);
3148: x_response.Result_Code := IBY_FNDCPT_COMMON_PUB.G_RC_INVALID_PAYER;
3149: ELSE
3150: iby_debug_pub.add('Create Settlemnet- Valid Payer',iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
3151: OPEN c_extension(p_trxn_entity_id,p_payer,l_payer_level,p_payer_equivalency);

Line 3150: iby_debug_pub.add('Create Settlemnet- Valid Payer',iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);

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);
3148: x_response.Result_Code := IBY_FNDCPT_COMMON_PUB.G_RC_INVALID_PAYER;
3149: ELSE
3150: iby_debug_pub.add('Create Settlemnet- Valid Payer',iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
3151: OPEN c_extension(p_trxn_entity_id,p_payer,l_payer_level,p_payer_equivalency);
3152: FETCH c_extension INTO l_pmt_instr.PmtInstr_Type,
3153: l_pmt_instr.PmtInstr_Id, l_ecapp_id, l_app_short_name,
3154: l_order_id, l_trxn_ref1, l_trxn_ref2,

Line 3162: iby_debug_pub.add('retrieveing extn attrs rows' || SQL%ROWCOUNT,iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);

3158: l_pmt_instr.Pmtinstr_assignment_id,
3159: l_pmt_trxn.payment_channel_code;
3160: CLOSE c_extension;
3161:
3162: iby_debug_pub.add('retrieveing extn attrs rows' || SQL%ROWCOUNT,iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
3163:
3164:
3165:
3166: IF (l_ecapp_id IS NULL) THEN

Line 3167: iby_debug_pub.add('Create Settlemnet. l_ecapp_id is null ',iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);

3163:
3164:
3165:
3166: IF (l_ecapp_id IS NULL) THEN
3167: iby_debug_pub.add('Create Settlemnet. l_ecapp_id is null ',iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
3168: x_response.Result_Code := G_RC_INVALID_EXTENSION_ID;
3169: ELSE
3170:
3171: iby_debug_pub.add('Create Settlemnet. l_ecapp_id is not null. l_pmt_instr.PmtInstr_Type ' || l_pmt_instr.PmtInstr_Type,iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);

Line 3171: iby_debug_pub.add('Create Settlemnet. l_ecapp_id is not null. l_pmt_instr.PmtInstr_Type ' || l_pmt_instr.PmtInstr_Type,iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);

3167: iby_debug_pub.add('Create Settlemnet. l_ecapp_id is null ',iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
3168: x_response.Result_Code := G_RC_INVALID_EXTENSION_ID;
3169: ELSE
3170:
3171: iby_debug_pub.add('Create Settlemnet. l_ecapp_id is not null. l_pmt_instr.PmtInstr_Type ' || l_pmt_instr.PmtInstr_Type,iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
3172: IF (l_pmt_instr.PmtInstr_Type = IBY_FNDCPT_COMMON_PUB.G_INSTR_TYPE_BANKACCT) THEN
3173:
3174: iby_debug_pub.add('Create Settlemnet. Entered Bank Account flow. p_trxn_entity_id ' || p_trxn_entity_id,iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
3175:

Line 3174: iby_debug_pub.add('Create Settlemnet. Entered Bank Account flow. p_trxn_entity_id ' || p_trxn_entity_id,iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);

3170:
3171: iby_debug_pub.add('Create Settlemnet. l_ecapp_id is not null. l_pmt_instr.PmtInstr_Type ' || l_pmt_instr.PmtInstr_Type,iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
3172: IF (l_pmt_instr.PmtInstr_Type = IBY_FNDCPT_COMMON_PUB.G_INSTR_TYPE_BANKACCT) THEN
3173:
3174: iby_debug_pub.add('Create Settlemnet. Entered Bank Account flow. p_trxn_entity_id ' || p_trxn_entity_id,iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
3175:
3176: OPEN C_PAYEE(p_trxn_entity_id);
3177: FETCH C_PAYEE INTO l_payee.Payee_Id, l_pmt_trxn.org_id, l_pmt_trxn.org_type;
3178: IF C_PAYEE%NOTFOUND THEN

Line 3181: iby_debug_pub.add('Invalid Payee ',iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);

3177: FETCH C_PAYEE INTO l_payee.Payee_Id, l_pmt_trxn.org_id, l_pmt_trxn.org_type;
3178: IF C_PAYEE%NOTFOUND THEN
3179: CLOSE C_PAYEE;
3180:
3181: iby_debug_pub.add('Invalid Payee ',iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
3182:
3183: x_response.Result_Code := G_RC_INVALID_PAYEE;
3184:
3185: iby_fndcpt_common_pub.Prepare_Result

Line 3192: iby_debug_pub.add('Payee id ' || l_payee.Payee_Id || ' org id ' || l_pmt_trxn.org_id || ' org type ' || l_pmt_trxn.org_type ,iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);

3188:
3189: END IF;
3190: CLOSE C_PAYEE;
3191:
3192: iby_debug_pub.add('Payee id ' || l_payee.Payee_Id || ' org id ' || l_pmt_trxn.org_id || ' org type ' || l_pmt_trxn.org_type ,iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
3193:
3194:
3195:
3196: l_pmt_trxn.Auth_Type := IBY_PAYMENT_ADAPTER_PUB.G_AUTHTYPE_AUTHONLY;

Line 3220: iby_debug_pub.add('calling oraPmtReq ',iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);

3216: l_pmt_trxn.Trxn_Extension_Id := p_trxn_entity_id;
3217: END IF;
3218:
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,

Line 3233: iby_debug_pub.add('status :=' || lx_return_status,

3229: lx_msg_data,
3230: l_reqresp
3231: );
3232:
3233: iby_debug_pub.add('status :=' || lx_return_status,
3234: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
3235: iby_debug_pub.add('auth status :=' ||
3236: to_char(l_reqresp.Response.Status),
3237: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);

Line 3234: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);

3230: l_reqresp
3231: );
3232:
3233: iby_debug_pub.add('status :=' || lx_return_status,
3234: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
3235: iby_debug_pub.add('auth status :=' ||
3236: to_char(l_reqresp.Response.Status),
3237: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
3238: iby_debug_pub.add('auth engine code :=' ||

Line 3235: iby_debug_pub.add('auth status :=' ||

3231: );
3232:
3233: iby_debug_pub.add('status :=' || lx_return_status,
3234: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
3235: iby_debug_pub.add('auth status :=' ||
3236: to_char(l_reqresp.Response.Status),
3237: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
3238: iby_debug_pub.add('auth engine code :=' ||
3239: to_char(l_reqresp.Response.ErrCode),

Line 3237: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);

3233: iby_debug_pub.add('status :=' || lx_return_status,
3234: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
3235: iby_debug_pub.add('auth status :=' ||
3236: to_char(l_reqresp.Response.Status),
3237: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
3238: iby_debug_pub.add('auth engine code :=' ||
3239: to_char(l_reqresp.Response.ErrCode),
3240: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
3241: iby_debug_pub.add('auth engine msg :=' ||

Line 3238: iby_debug_pub.add('auth engine code :=' ||

3234: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
3235: iby_debug_pub.add('auth status :=' ||
3236: to_char(l_reqresp.Response.Status),
3237: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
3238: iby_debug_pub.add('auth engine code :=' ||
3239: to_char(l_reqresp.Response.ErrCode),
3240: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
3241: iby_debug_pub.add('auth engine msg :=' ||
3242: to_char(l_reqresp.Response.ErrMessage),

Line 3240: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);

3236: to_char(l_reqresp.Response.Status),
3237: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
3238: iby_debug_pub.add('auth engine code :=' ||
3239: to_char(l_reqresp.Response.ErrCode),
3240: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
3241: iby_debug_pub.add('auth engine msg :=' ||
3242: to_char(l_reqresp.Response.ErrMessage),
3243: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
3244:

Line 3241: iby_debug_pub.add('auth engine msg :=' ||

3237: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
3238: iby_debug_pub.add('auth engine code :=' ||
3239: to_char(l_reqresp.Response.ErrCode),
3240: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
3241: iby_debug_pub.add('auth engine msg :=' ||
3242: to_char(l_reqresp.Response.ErrMessage),
3243: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
3244:
3245: iby_debug_pub.add('payment system code :=' ||

Line 3243: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);

3239: to_char(l_reqresp.Response.ErrCode),
3240: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
3241: iby_debug_pub.add('auth engine msg :=' ||
3242: to_char(l_reqresp.Response.ErrMessage),
3243: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
3244:
3245: iby_debug_pub.add('payment system code :=' ||
3246: to_char(l_reqresp.BEPErrCode),
3247: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);

Line 3245: iby_debug_pub.add('payment system code :=' ||

3241: iby_debug_pub.add('auth engine msg :=' ||
3242: to_char(l_reqresp.Response.ErrMessage),
3243: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
3244:
3245: iby_debug_pub.add('payment system code :=' ||
3246: to_char(l_reqresp.BEPErrCode),
3247: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
3248: iby_debug_pub.add('payment system msg :=' ||
3249: to_char(l_reqresp.BEPErrMessage),

Line 3247: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);

3243: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
3244:
3245: iby_debug_pub.add('payment system code :=' ||
3246: to_char(l_reqresp.BEPErrCode),
3247: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
3248: iby_debug_pub.add('payment system msg :=' ||
3249: to_char(l_reqresp.BEPErrMessage),
3250: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
3251:

Line 3248: iby_debug_pub.add('payment system msg :=' ||

3244:
3245: iby_debug_pub.add('payment system code :=' ||
3246: to_char(l_reqresp.BEPErrCode),
3247: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
3248: iby_debug_pub.add('payment system msg :=' ||
3249: to_char(l_reqresp.BEPErrMessage),
3250: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
3251:
3252: iby_debug_pub.add('trxn id :=' ||

Line 3250: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);

3246: to_char(l_reqresp.BEPErrCode),
3247: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
3248: iby_debug_pub.add('payment system msg :=' ||
3249: to_char(l_reqresp.BEPErrMessage),
3250: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
3251:
3252: iby_debug_pub.add('trxn id :=' ||
3253: to_char(l_reqresp.Trxn_ID),
3254: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);

Line 3252: iby_debug_pub.add('trxn id :=' ||

3248: iby_debug_pub.add('payment system msg :=' ||
3249: to_char(l_reqresp.BEPErrMessage),
3250: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
3251:
3252: iby_debug_pub.add('trxn id :=' ||
3253: to_char(l_reqresp.Trxn_ID),
3254: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
3255:
3256: -- Fix for bug# 7377455. Stamp the tangibleid on the PSON column of

Line 3254: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);

3250: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
3251:
3252: iby_debug_pub.add('trxn id :=' ||
3253: to_char(l_reqresp.Trxn_ID),
3254: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
3255:
3256: -- Fix for bug# 7377455. Stamp the tangibleid on the PSON column of
3257: -- IBY_FNDCPT_TX_EXTENSIONS table
3258: iby_debug_pub.add( 'Stamping the PSON on the extension as '||

Line 3258: iby_debug_pub.add( 'Stamping the PSON on the extension as '||

3254: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
3255:
3256: -- Fix for bug# 7377455. Stamp the tangibleid on the PSON column of
3257: -- IBY_FNDCPT_TX_EXTENSIONS table
3258: iby_debug_pub.add( 'Stamping the PSON on the extension as '||
3259: l_tangible.Tangible_Id,
3260: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
3261:
3262: UPDATE iby_fndcpt_tx_extensions

Line 3260: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);

3256: -- Fix for bug# 7377455. Stamp the tangibleid on the PSON column of
3257: -- IBY_FNDCPT_TX_EXTENSIONS table
3258: iby_debug_pub.add( 'Stamping the PSON on the extension as '||
3259: l_tangible.Tangible_Id,
3260: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
3261:
3262: UPDATE iby_fndcpt_tx_extensions
3263: SET payment_system_order_number = l_tangible.Tangible_Id
3264: WHERE trxn_extension_id = p_trxn_entity_id;

Line 3268: iby_debug_pub.add( 'Stamping '||p_trxn_entity_id ||' as the initiator_extension_id'

3264: WHERE trxn_extension_id = p_trxn_entity_id;
3265:
3266: -- Fix for bug# 7530578. Stamp the initiator transaction extension id
3267: -- on the corresponding record in iby_trxn_summaries_all
3268: iby_debug_pub.add( 'Stamping '||p_trxn_entity_id ||' as the initiator_extension_id'
3269: ||'on the auth record', iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
3270:
3271: UPDATE iby_trxn_summaries_all
3272: SET initiator_extension_id = p_trxn_entity_id

Line 3269: ||'on the auth record', iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);

3265:
3266: -- Fix for bug# 7530578. Stamp the initiator transaction extension id
3267: -- on the corresponding record in iby_trxn_summaries_all
3268: iby_debug_pub.add( 'Stamping '||p_trxn_entity_id ||' as the initiator_extension_id'
3269: ||'on the auth record', iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
3270:
3271: UPDATE iby_trxn_summaries_all
3272: SET initiator_extension_id = p_trxn_entity_id
3273: WHERE transactionid = l_reqresp.Trxn_Id

Line 3318: iby_debug_pub.add('inserting into iby_fndcpt_tx_operations.',

3314: FETCH c_operation_count INTO l_op_count;
3315: CLOSE c_operation_count;
3316:
3317: IF (NVL(l_op_count,0) = 0) THEN
3318: iby_debug_pub.add('inserting into iby_fndcpt_tx_operations.',
3319: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
3320:
3321: INSERT INTO iby_fndcpt_tx_operations
3322: (trxn_extension_id, transactionid,

Line 3319: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);

3315: CLOSE c_operation_count;
3316:
3317: IF (NVL(l_op_count,0) = 0) THEN
3318: iby_debug_pub.add('inserting into iby_fndcpt_tx_operations.',
3319: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
3320:
3321: INSERT INTO iby_fndcpt_tx_operations
3322: (trxn_extension_id, transactionid,
3323: created_by, creation_date, last_updated_by, last_update_date,

Line 3347: iby_debug_pub.add('back-propogated rows:='||SQL%ROWCOUNT,

3343: FROM iby_fndcpt_tx_xe_copies
3344: START WITH copy_trxn_extension_id = p_trxn_entity_id
3345: CONNECT BY PRIOR source_trxn_extension_id = copy_trxn_extension_id;
3346:
3347: iby_debug_pub.add('back-propogated rows:='||SQL%ROWCOUNT,
3348: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
3349:
3350: --
3351: -- forward propogate the authorization

Line 3348: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);

3344: START WITH copy_trxn_extension_id = p_trxn_entity_id
3345: CONNECT BY PRIOR source_trxn_extension_id = copy_trxn_extension_id;
3346:
3347: iby_debug_pub.add('back-propogated rows:='||SQL%ROWCOUNT,
3348: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
3349:
3350: --
3351: -- forward propogate the authorization
3352: --

Line 3365: iby_debug_pub.add('forward-propogated rows:='||SQL%ROWCOUNT,

3361: FROM iby_fndcpt_tx_xe_copies
3362: START WITH source_trxn_extension_id = p_trxn_entity_id
3363: CONNECT BY source_trxn_extension_id = PRIOR copy_trxn_extension_id;
3364:
3365: iby_debug_pub.add('forward-propogated rows:='||SQL%ROWCOUNT,
3366: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
3367: END IF;
3368: ELSE
3369:

Line 3366: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);

3362: START WITH source_trxn_extension_id = p_trxn_entity_id
3363: CONNECT BY source_trxn_extension_id = PRIOR copy_trxn_extension_id;
3364:
3365: iby_debug_pub.add('forward-propogated rows:='||SQL%ROWCOUNT,
3366: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
3367: END IF;
3368: ELSE
3369:
3370: iby_debug_pub.add('not bank account settlement ',

Line 3370: iby_debug_pub.add('not bank account settlement ',

3366: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
3367: END IF;
3368: ELSE
3369:
3370: iby_debug_pub.add('not bank account settlement ',
3371: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
3372:
3373: OPEN c_auth(p_trxn_entity_id);
3374: FETCH c_auth INTO l_transactionid;

Line 3371: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);

3367: END IF;
3368: ELSE
3369:
3370: iby_debug_pub.add('not bank account settlement ',
3371: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
3372:
3373: OPEN c_auth(p_trxn_entity_id);
3374: FETCH c_auth INTO l_transactionid;
3375: CLOSE c_auth;

Line 3379: iby_debug_pub.add('calling capture',

3375: CLOSE c_auth;
3376: IF (l_transactionid IS NULL) THEN
3377: x_response.Result_Code := G_RC_INVALID_AUTHORIZATION;
3378: ELSE
3379: iby_debug_pub.add('calling capture',
3380: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
3381:
3382: l_capture_trxn.PmtMode := 'ONLINE';
3383: l_capture_trxn.Trxn_Id := l_transactionid;

Line 3380: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);

3376: IF (l_transactionid IS NULL) THEN
3377: x_response.Result_Code := G_RC_INVALID_AUTHORIZATION;
3378: ELSE
3379: iby_debug_pub.add('calling capture',
3380: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
3381:
3382: l_capture_trxn.PmtMode := 'ONLINE';
3383: l_capture_trxn.Trxn_Id := l_transactionid;
3384: l_capture_trxn.Price := p_amount.Value;

Line 3387: iby_debug_pub.add('Settlement_Date passed as: '||p_receipt_attribs.Settlement_Date,iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);

3383: l_capture_trxn.Trxn_Id := l_transactionid;
3384: l_capture_trxn.Price := p_amount.Value;
3385: l_capture_trxn.Currency := p_amount.Currency_Code;
3386:
3387: iby_debug_pub.add('Settlement_Date passed as: '||p_receipt_attribs.Settlement_Date,iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
3388: iby_debug_pub.add('Settlement_Due_Date passed as: '||p_receipt_attribs.Settlement_Due_Date,iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
3389: l_capture_trxn.Settlement_Date := p_receipt_attribs.Settlement_Date;
3390:
3391: iby_debug_pub.add('Create Settlement- calling OraPmtCapture ' ,iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);

Line 3388: iby_debug_pub.add('Settlement_Due_Date passed as: '||p_receipt_attribs.Settlement_Due_Date,iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);

3384: l_capture_trxn.Price := p_amount.Value;
3385: l_capture_trxn.Currency := p_amount.Currency_Code;
3386:
3387: iby_debug_pub.add('Settlement_Date passed as: '||p_receipt_attribs.Settlement_Date,iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
3388: iby_debug_pub.add('Settlement_Due_Date passed as: '||p_receipt_attribs.Settlement_Due_Date,iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
3389: l_capture_trxn.Settlement_Date := p_receipt_attribs.Settlement_Date;
3390:
3391: iby_debug_pub.add('Create Settlement- calling OraPmtCapture ' ,iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
3392:

Line 3391: iby_debug_pub.add('Create Settlement- calling OraPmtCapture ' ,iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);

3387: iby_debug_pub.add('Settlement_Date passed as: '||p_receipt_attribs.Settlement_Date,iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
3388: iby_debug_pub.add('Settlement_Due_Date passed as: '||p_receipt_attribs.Settlement_Due_Date,iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
3389: l_capture_trxn.Settlement_Date := p_receipt_attribs.Settlement_Date;
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,

Line 3399: iby_debug_pub.add('status :=' || lx_return_status,

3395: l_ecapp_id, l_capture_trxn,
3396: lx_return_status, lx_msg_count, lx_msg_data, lx_capresp
3397: );
3398:
3399: iby_debug_pub.add('status :=' || lx_return_status,
3400: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
3401: iby_debug_pub.add('capture status :=' ||
3402: to_char(lx_capresp.Response.Status),
3403: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);

Line 3400: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);

3396: lx_return_status, lx_msg_count, lx_msg_data, lx_capresp
3397: );
3398:
3399: iby_debug_pub.add('status :=' || lx_return_status,
3400: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
3401: iby_debug_pub.add('capture status :=' ||
3402: to_char(lx_capresp.Response.Status),
3403: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
3404: iby_debug_pub.add('engine code :=' ||

Line 3401: iby_debug_pub.add('capture status :=' ||

3397: );
3398:
3399: iby_debug_pub.add('status :=' || lx_return_status,
3400: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
3401: iby_debug_pub.add('capture status :=' ||
3402: to_char(lx_capresp.Response.Status),
3403: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
3404: iby_debug_pub.add('engine code :=' ||
3405: to_char(lx_capresp.Response.ErrCode),

Line 3403: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);

3399: iby_debug_pub.add('status :=' || lx_return_status,
3400: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
3401: iby_debug_pub.add('capture status :=' ||
3402: to_char(lx_capresp.Response.Status),
3403: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
3404: iby_debug_pub.add('engine code :=' ||
3405: to_char(lx_capresp.Response.ErrCode),
3406: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
3407: iby_debug_pub.add('engine msg :=' ||

Line 3404: iby_debug_pub.add('engine code :=' ||

3400: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
3401: iby_debug_pub.add('capture status :=' ||
3402: to_char(lx_capresp.Response.Status),
3403: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
3404: iby_debug_pub.add('engine code :=' ||
3405: to_char(lx_capresp.Response.ErrCode),
3406: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
3407: iby_debug_pub.add('engine msg :=' ||
3408: to_char(lx_capresp.Response.ErrMessage),

Line 3406: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);

3402: to_char(lx_capresp.Response.Status),
3403: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
3404: iby_debug_pub.add('engine code :=' ||
3405: to_char(lx_capresp.Response.ErrCode),
3406: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
3407: iby_debug_pub.add('engine msg :=' ||
3408: to_char(lx_capresp.Response.ErrMessage),
3409: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
3410:

Line 3407: iby_debug_pub.add('engine msg :=' ||

3403: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
3404: iby_debug_pub.add('engine code :=' ||
3405: to_char(lx_capresp.Response.ErrCode),
3406: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
3407: iby_debug_pub.add('engine msg :=' ||
3408: to_char(lx_capresp.Response.ErrMessage),
3409: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
3410:
3411: iby_debug_pub.add('payment system code :=' ||

Line 3409: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);

3405: to_char(lx_capresp.Response.ErrCode),
3406: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
3407: iby_debug_pub.add('engine msg :=' ||
3408: to_char(lx_capresp.Response.ErrMessage),
3409: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
3410:
3411: iby_debug_pub.add('payment system code :=' ||
3412: to_char(lx_capresp.BEPErrCode),
3413: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);

Line 3411: iby_debug_pub.add('payment system code :=' ||

3407: iby_debug_pub.add('engine msg :=' ||
3408: to_char(lx_capresp.Response.ErrMessage),
3409: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
3410:
3411: iby_debug_pub.add('payment system code :=' ||
3412: to_char(lx_capresp.BEPErrCode),
3413: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
3414: iby_debug_pub.add('payment system msg :=' ||
3415: to_char(lx_capresp.BEPErrMessage),

Line 3413: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);

3409: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
3410:
3411: iby_debug_pub.add('payment system code :=' ||
3412: to_char(lx_capresp.BEPErrCode),
3413: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
3414: iby_debug_pub.add('payment system msg :=' ||
3415: to_char(lx_capresp.BEPErrMessage),
3416: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
3417:

Line 3414: iby_debug_pub.add('payment system msg :=' ||

3410:
3411: iby_debug_pub.add('payment system code :=' ||
3412: to_char(lx_capresp.BEPErrCode),
3413: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
3414: iby_debug_pub.add('payment system msg :=' ||
3415: to_char(lx_capresp.BEPErrMessage),
3416: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
3417:
3418: -- Fix for bug# 7530578. Stamp the initiator transaction extension id

Line 3416: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);

3412: to_char(lx_capresp.BEPErrCode),
3413: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
3414: iby_debug_pub.add('payment system msg :=' ||
3415: to_char(lx_capresp.BEPErrMessage),
3416: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
3417:
3418: -- Fix for bug# 7530578. Stamp the initiator transaction extension id
3419: -- on the corresponding record in iby_trxn_summaries_all
3420: iby_debug_pub.add( 'Stamping '||p_trxn_entity_id ||' as the initiator_extension_id'

Line 3420: iby_debug_pub.add( 'Stamping '||p_trxn_entity_id ||' as the initiator_extension_id'

3416: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
3417:
3418: -- Fix for bug# 7530578. Stamp the initiator transaction extension id
3419: -- on the corresponding record in iby_trxn_summaries_all
3420: iby_debug_pub.add( 'Stamping '||p_trxn_entity_id ||' as the initiator_extension_id'
3421: ||'on the capture record', iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
3422:
3423: UPDATE iby_trxn_summaries_all
3424: SET initiator_extension_id = p_trxn_entity_id

Line 3421: ||'on the capture record', iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);

3417:
3418: -- Fix for bug# 7530578. Stamp the initiator transaction extension id
3419: -- on the corresponding record in iby_trxn_summaries_all
3420: iby_debug_pub.add( 'Stamping '||p_trxn_entity_id ||' as the initiator_extension_id'
3421: ||'on the capture record', iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
3422:
3423: UPDATE iby_trxn_summaries_all
3424: SET initiator_extension_id = p_trxn_entity_id
3425: WHERE transactionid = l_reqresp.Trxn_Id

Line 3477: iby_debug_pub.add(debug_msg => 'In G_EXC_ERROR Exception',

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);
3480: x_return_status := FND_API.G_RET_STS_ERROR;
3481: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

Line 3486: iby_debug_pub.add(debug_msg => 'In G_EXC_UNEXPECTED_ERROR Exception',

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);
3489: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3490: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

Line 3496: iby_debug_pub.add(debug_msg => 'In OTHERS Exception',

3492: );
3493:
3494: WHEN OTHERS THEN
3495:
3496: iby_debug_pub.add(debug_msg => 'In OTHERS Exception',
3497: debug_level => FND_LOG.LEVEL_UNEXPECTED,
3498: module => G_DEBUG_MODULE || l_module);
3499:
3500: iby_fndcpt_common_pub.Clear_Msg_Stack(l_prev_msg_count);

Line 3534: iby_debug_pub.add( 'Overloaded API invoked. ReceiptAttribs_rec_type will be defaulted to Null',

3530: p_receipt_attribs ReceiptAttribs_rec_type;
3531: l_module CONSTANT VARCHAR2(30) := 'Create_Settlement(2)';
3532:
3533: BEGIN
3534: iby_debug_pub.add( 'Overloaded API invoked. ReceiptAttribs_rec_type will be defaulted to Null',
3535: iby_debug_pub.G_LEVEL_INFO,G_DEBUG_MODULE || l_module);
3536:
3537: p_receipt_attribs.Settlement_Date := NULL;
3538: p_receipt_attribs.Settlement_Due_Date := NULL;

Line 3535: iby_debug_pub.G_LEVEL_INFO,G_DEBUG_MODULE || l_module);

3531: l_module CONSTANT VARCHAR2(30) := 'Create_Settlement(2)';
3532:
3533: BEGIN
3534: iby_debug_pub.add( 'Overloaded API invoked. ReceiptAttribs_rec_type will be defaulted to Null',
3535: iby_debug_pub.G_LEVEL_INFO,G_DEBUG_MODULE || l_module);
3536:
3537: p_receipt_attribs.Settlement_Date := NULL;
3538: p_receipt_attribs.Settlement_Due_Date := NULL;
3539:

Line 3663: --iby_debug_pub.add('ENTER',iby_debug_pub.G_LEVEL_PROCEDURE,l_module_name);

3659: l_routing_failure BOOLEAN;
3660:
3661: BEGIN
3662:
3663: --iby_debug_pub.add('ENTER',iby_debug_pub.G_LEVEL_PROCEDURE,l_module_name);
3664: print_debuginfo(l_module_name, 'ENTER');
3665:
3666: -- Close the cursors if open due to previous error
3667: IF (l_orders_cursor%ISOPEN) THEN CLOSE l_orders_cursor; END IF;

Line 4023: iby_debug_pub.add('processing extensionid: '|| current_trxn_ext_id,

4019: current_trxn_ext_id := l_settlement_trxn_rec.PAYMENT_TRXN_EXTENSION_ID;
4020: print_debuginfo(l_module_name, 'Transaction Extension Id : '||
4021: current_trxn_ext_id);
4022:
4023: iby_debug_pub.add('processing extensionid: '|| current_trxn_ext_id,
4024: iby_debug_pub.G_LEVEL_PROCEDURE,l_module_name);
4025:
4026: /*
4027: Bug7658675# REMITTANCE BATCH (IBY_FNDCPT_TRXN_PUB.CREATE_SETTLEMENTS) LTD TO 1000 RECORDS

Line 4024: iby_debug_pub.G_LEVEL_PROCEDURE,l_module_name);

4020: print_debuginfo(l_module_name, 'Transaction Extension Id : '||
4021: current_trxn_ext_id);
4022:
4023: iby_debug_pub.add('processing extensionid: '|| current_trxn_ext_id,
4024: iby_debug_pub.G_LEVEL_PROCEDURE,l_module_name);
4025:
4026: /*
4027: Bug7658675# REMITTANCE BATCH (IBY_FNDCPT_TRXN_PUB.CREATE_SETTLEMENTS) LTD TO 1000 RECORDS
4028: l is the new variable defined to initailize the x_responses recrod TYPE.

Line 4438: iby_debug_pub.add('updating extension '|| l_pson_Tab(i).extension_id

4434: -- SET payment_system_order_number = TREAT(l_pson_Tab(j) AS Pson_rec_type).tangibleid
4435: -- WHERE trxn_extension_id = TREAT(l_pson_Tab(j) AS Pson_rec_type).extension_id;
4436:
4437: FOR i IN 0..(l_pson_Tab.COUNT-1) LOOP --index starts from 0 and ends at (COUNT-1)
4438: iby_debug_pub.add('updating extension '|| l_pson_Tab(i).extension_id
4439: ||' with PSON '||l_pson_Tab(i).tangibleid, iby_debug_pub.G_LEVEL_PROCEDURE,l_module_name);
4440: UPDATE iby_fndcpt_tx_extensions
4441: SET payment_system_order_number = l_pson_Tab(i).tangibleid,
4442: object_version_number = object_version_number + 1

Line 4439: ||' with PSON '||l_pson_Tab(i).tangibleid, iby_debug_pub.G_LEVEL_PROCEDURE,l_module_name);

4435: -- WHERE trxn_extension_id = TREAT(l_pson_Tab(j) AS Pson_rec_type).extension_id;
4436:
4437: FOR i IN 0..(l_pson_Tab.COUNT-1) LOOP --index starts from 0 and ends at (COUNT-1)
4438: iby_debug_pub.add('updating extension '|| l_pson_Tab(i).extension_id
4439: ||' with PSON '||l_pson_Tab(i).tangibleid, iby_debug_pub.G_LEVEL_PROCEDURE,l_module_name);
4440: UPDATE iby_fndcpt_tx_extensions
4441: SET payment_system_order_number = l_pson_Tab(i).tangibleid,
4442: object_version_number = object_version_number + 1
4443: WHERE trxn_extension_id = l_pson_Tab(i).extension_id;

Line 4445: iby_debug_pub.add('updating extension complete..'

4441: SET payment_system_order_number = l_pson_Tab(i).tangibleid,
4442: object_version_number = object_version_number + 1
4443: WHERE trxn_extension_id = l_pson_Tab(i).extension_id;
4444: END LOOP;
4445: iby_debug_pub.add('updating extension complete..'
4446: , iby_debug_pub.G_LEVEL_PROCEDURE,l_module_name);
4447:
4448: END IF;
4449:

Line 4446: , iby_debug_pub.G_LEVEL_PROCEDURE,l_module_name);

4442: object_version_number = object_version_number + 1
4443: WHERE trxn_extension_id = l_pson_Tab(i).extension_id;
4444: END LOOP;
4445: iby_debug_pub.add('updating extension complete..'
4446: , iby_debug_pub.G_LEVEL_PROCEDURE,l_module_name);
4447:
4448: END IF;
4449:
4450: IF (l_TrxnCore_Tab.COUNT > 0) THEN

Line 4609: iby_debug_pub.add(debug_msg => 'Incorrect API Version:=' || p_api_version,

4605: p_api_version,
4606: l_module,
4607: G_PKG_NAME)
4608: THEN
4609: iby_debug_pub.add(debug_msg => 'Incorrect API Version:=' || p_api_version,
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;

Line 4655: iby_debug_pub.add('Settlement_Date passed as: '||p_receipt_attribs.Settlement_Date,iby_debug_pub.G_LEVEL_INFO,G_DEBUG_MODULE || l_module);

4651: Get_Tangible_Id(l_app_short_name,p_trxn_entity_id);
4652: --l_tangible.Tangible_Id :=
4653: -- Get_Tangible_Id(l_app_short_name,l_order_id,l_trxn_ref1,l_trxn_ref2);
4654:
4655: iby_debug_pub.add('Settlement_Date passed as: '||p_receipt_attribs.Settlement_Date,iby_debug_pub.G_LEVEL_INFO,G_DEBUG_MODULE || l_module);
4656: iby_debug_pub.add('Settlement_Due_Date passed as: '||p_receipt_attribs.Settlement_Due_Date,iby_debug_pub.G_LEVEL_INFO,G_DEBUG_MODULE || l_module);
4657:
4658: l_tangible.Tangible_Amount := p_amount.Value;
4659: l_tangible.Currency_Code := p_amount.Currency_Code;

Line 4656: iby_debug_pub.add('Settlement_Due_Date passed as: '||p_receipt_attribs.Settlement_Due_Date,iby_debug_pub.G_LEVEL_INFO,G_DEBUG_MODULE || l_module);

4652: --l_tangible.Tangible_Id :=
4653: -- Get_Tangible_Id(l_app_short_name,l_order_id,l_trxn_ref1,l_trxn_ref2);
4654:
4655: iby_debug_pub.add('Settlement_Date passed as: '||p_receipt_attribs.Settlement_Date,iby_debug_pub.G_LEVEL_INFO,G_DEBUG_MODULE || l_module);
4656: iby_debug_pub.add('Settlement_Due_Date passed as: '||p_receipt_attribs.Settlement_Due_Date,iby_debug_pub.G_LEVEL_INFO,G_DEBUG_MODULE || l_module);
4657:
4658: l_tangible.Tangible_Amount := p_amount.Value;
4659: l_tangible.Currency_Code := p_amount.Currency_Code;
4660: l_credit_trxn.PmtMode := 'ONLINE';

Line 4698: iby_debug_pub.add( 'Stamping the PSON on the extension as '||

4694: CONNECT BY source_trxn_extension_id = PRIOR copy_trxn_extension_id;
4695:
4696: -- Fix for bug# 7377455. Stamp the tangibleid on the PSON column of
4697: -- IBY_FNDCPT_TX_EXTENSIONS table
4698: iby_debug_pub.add( 'Stamping the PSON on the extension as '||
4699: l_tangible.Tangible_Id,
4700: iby_debug_pub.G_LEVEL_INFO,G_DEBUG_MODULE || l_module);
4701:
4702: UPDATE iby_fndcpt_tx_extensions

Line 4700: iby_debug_pub.G_LEVEL_INFO,G_DEBUG_MODULE || l_module);

4696: -- Fix for bug# 7377455. Stamp the tangibleid on the PSON column of
4697: -- IBY_FNDCPT_TX_EXTENSIONS table
4698: iby_debug_pub.add( 'Stamping the PSON on the extension as '||
4699: l_tangible.Tangible_Id,
4700: iby_debug_pub.G_LEVEL_INFO,G_DEBUG_MODULE || l_module);
4701:
4702: UPDATE iby_fndcpt_tx_extensions
4703: SET payment_system_order_number = l_tangible.Tangible_Id
4704: WHERE trxn_extension_id = p_trxn_entity_id;

Line 4708: iby_debug_pub.add( 'Stamping '||p_trxn_entity_id ||' as the initiator_extension_id'

4704: WHERE trxn_extension_id = p_trxn_entity_id;
4705:
4706: -- Fix for bug# 7530578. Stamp the initiator transaction extension id
4707: -- on the corresponding record in iby_trxn_summaries_all
4708: iby_debug_pub.add( 'Stamping '||p_trxn_entity_id ||' as the initiator_extension_id'
4709: ||'on the credit record', iby_debug_pub.G_LEVEL_INFO,G_DEBUG_MODULE || l_module);
4710:
4711: UPDATE iby_trxn_summaries_all
4712: SET initiator_extension_id = p_trxn_entity_id

Line 4709: ||'on the credit record', iby_debug_pub.G_LEVEL_INFO,G_DEBUG_MODULE || l_module);

4705:
4706: -- Fix for bug# 7530578. Stamp the initiator transaction extension id
4707: -- on the corresponding record in iby_trxn_summaries_all
4708: iby_debug_pub.add( 'Stamping '||p_trxn_entity_id ||' as the initiator_extension_id'
4709: ||'on the credit record', iby_debug_pub.G_LEVEL_INFO,G_DEBUG_MODULE || l_module);
4710:
4711: UPDATE iby_trxn_summaries_all
4712: SET initiator_extension_id = p_trxn_entity_id
4713: WHERE transactionid = lx_creditresp.Trxn_Id

Line 4727: iby_debug_pub.add('Settlement_Date passed as: '||p_receipt_attribs.Settlement_Date,iby_debug_pub.G_LEVEL_INFO,G_DEBUG_MODULE || l_module);

4723: NVL(lx_creditresp.Response.ErrCode,IBY_FNDCPT_COMMON_PUB.G_RC_GENERIC_SYS_ERROR);
4724: END IF;
4725: ELSE
4726:
4727: iby_debug_pub.add('Settlement_Date passed as: '||p_receipt_attribs.Settlement_Date,iby_debug_pub.G_LEVEL_INFO,G_DEBUG_MODULE || l_module);
4728: iby_debug_pub.add('Settlement_Due_Date passed as: '||p_receipt_attribs.Settlement_Due_Date,iby_debug_pub.G_LEVEL_INFO,G_DEBUG_MODULE || l_module);
4729:
4730: l_return_trxn.Currency := p_amount.Currency_Code;
4731: l_return_trxn.Price := p_amount.Value;

Line 4728: iby_debug_pub.add('Settlement_Due_Date passed as: '||p_receipt_attribs.Settlement_Due_Date,iby_debug_pub.G_LEVEL_INFO,G_DEBUG_MODULE || l_module);

4724: END IF;
4725: ELSE
4726:
4727: iby_debug_pub.add('Settlement_Date passed as: '||p_receipt_attribs.Settlement_Date,iby_debug_pub.G_LEVEL_INFO,G_DEBUG_MODULE || l_module);
4728: iby_debug_pub.add('Settlement_Due_Date passed as: '||p_receipt_attribs.Settlement_Due_Date,iby_debug_pub.G_LEVEL_INFO,G_DEBUG_MODULE || l_module);
4729:
4730: l_return_trxn.Currency := p_amount.Currency_Code;
4731: l_return_trxn.Price := p_amount.Value;
4732: l_return_trxn.PmtMode := 'ONLINE';

Line 4746: iby_debug_pub.add( 'Stamping the PSON on the extension as '||

4742: l_interface_code := IBY_FNDCPT_COMMON_PUB.G_INTERFACE_CODE;
4743:
4744: -- Fix for bug# 7377455. Stamp the tangibleid on the PSON column of
4745: -- IBY_FNDCPT_TX_EXTENSIONS table
4746: iby_debug_pub.add( 'Stamping the PSON on the extension as '||
4747: l_return_pson,
4748: iby_debug_pub.G_LEVEL_INFO,G_DEBUG_MODULE || l_module);
4749:
4750: UPDATE iby_fndcpt_tx_extensions

Line 4748: iby_debug_pub.G_LEVEL_INFO,G_DEBUG_MODULE || l_module);

4744: -- Fix for bug# 7377455. Stamp the tangibleid on the PSON column of
4745: -- IBY_FNDCPT_TX_EXTENSIONS table
4746: iby_debug_pub.add( 'Stamping the PSON on the extension as '||
4747: l_return_pson,
4748: iby_debug_pub.G_LEVEL_INFO,G_DEBUG_MODULE || l_module);
4749:
4750: UPDATE iby_fndcpt_tx_extensions
4751: SET payment_system_order_number = l_return_pson
4752: WHERE trxn_extension_id = p_trxn_entity_id;

Line 4756: iby_debug_pub.add( 'Stamping '||p_trxn_entity_id ||' as the initiator_extension_id'

4752: WHERE trxn_extension_id = p_trxn_entity_id;
4753:
4754: -- Fix for bug# 7530578. Stamp the initiator transaction extension id
4755: -- on the corresponding record in iby_trxn_summaries_all
4756: iby_debug_pub.add( 'Stamping '||p_trxn_entity_id ||' as the initiator_extension_id'
4757: ||'on the return record', iby_debug_pub.G_LEVEL_INFO,G_DEBUG_MODULE || l_module);
4758:
4759: UPDATE iby_trxn_summaries_all
4760: SET initiator_extension_id = p_trxn_entity_id

Line 4757: ||'on the return record', iby_debug_pub.G_LEVEL_INFO,G_DEBUG_MODULE || l_module);

4753:
4754: -- Fix for bug# 7530578. Stamp the initiator transaction extension id
4755: -- on the corresponding record in iby_trxn_summaries_all
4756: iby_debug_pub.add( 'Stamping '||p_trxn_entity_id ||' as the initiator_extension_id'
4757: ||'on the return record', iby_debug_pub.G_LEVEL_INFO,G_DEBUG_MODULE || l_module);
4758:
4759: UPDATE iby_trxn_summaries_all
4760: SET initiator_extension_id = p_trxn_entity_id
4761: WHERE transactionid = lx_returnresp.Trxn_Id

Line 4795: iby_debug_pub.add(debug_msg => 'In G_EXC_ERROR Exception',

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);
4798: x_return_status := FND_API.G_RET_STS_ERROR;
4799: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

Line 4804: iby_debug_pub.add(debug_msg => 'In G_EXC_UNEXPECTED_ERROR Exception',

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);
4807: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4808: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

Line 4814: iby_debug_pub.add(debug_msg => 'In OTHERS Exception',

4810: );
4811:
4812: WHEN OTHERS THEN
4813:
4814: iby_debug_pub.add(debug_msg => 'In OTHERS Exception',
4815: debug_level => FND_LOG.LEVEL_UNEXPECTED,
4816: module => G_DEBUG_MODULE || l_module);
4817:
4818: iby_fndcpt_common_pub.Clear_Msg_Stack(l_prev_msg_count);

Line 4849: iby_debug_pub.add( 'Overloaded API invoked. ReceiptAttribs_rec_type will be defaulted to Null',

4845: IS
4846: p_receipt_attribs ReceiptAttribs_rec_type;
4847: l_module CONSTANT VARCHAR2(30) := 'Create_Return(2)';
4848: BEGIN
4849: iby_debug_pub.add( 'Overloaded API invoked. ReceiptAttribs_rec_type will be defaulted to Null',
4850: iby_debug_pub.G_LEVEL_INFO,G_DEBUG_MODULE || l_module);
4851:
4852: p_receipt_attribs.Settlement_Date := NULL;
4853: p_receipt_attribs.Settlement_Due_Date := NULL;

Line 4850: iby_debug_pub.G_LEVEL_INFO,G_DEBUG_MODULE || l_module);

4846: p_receipt_attribs ReceiptAttribs_rec_type;
4847: l_module CONSTANT VARCHAR2(30) := 'Create_Return(2)';
4848: BEGIN
4849: iby_debug_pub.add( 'Overloaded API invoked. ReceiptAttribs_rec_type will be defaulted to Null',
4850: iby_debug_pub.G_LEVEL_INFO,G_DEBUG_MODULE || l_module);
4851:
4852: p_receipt_attribs.Settlement_Date := NULL;
4853: p_receipt_attribs.Settlement_Due_Date := NULL;
4854: