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_SETUP_PUB dependencies on IBY_DEBUG_PUB

Line 39: IBY_DEBUG_PUB.add(

35: /*
36: * OPTION I:
37: * Write debug text to the common application log file.
38: */
39: IBY_DEBUG_PUB.add(
40: substr(RPAD(p_module,55) || ' : ' || p_debug_text, 0, 150),
41: FND_LOG.G_CURRENT_RUNTIME_LEVEL,
42: 'iby.plsql.IBY_FNDCPT_SETUP_PUB'
43: );

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

337: p_api_version,
338: l_module,
339: G_PKG_NAME)
340: THEN
341: iby_debug_pub.add(debug_msg => 'Incorrect API Version:=' || p_api_version,
342: debug_level => FND_LOG.LEVEL_ERROR,
343: module => G_DEBUG_MODULE || l_module);
344: FND_MESSAGE.SET_NAME('IBY', 'IBY_204400_API_VER_MISMATCH');
345: FND_MSG_PUB.Add;

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

409: EXCEPTION
410:
411: WHEN FND_API.G_EXC_ERROR THEN
412:
413: iby_debug_pub.add(debug_msg => 'In G_EXC_ERROR Exception',
414: debug_level => FND_LOG.LEVEL_ERROR,
415: module => G_DEBUG_MODULE || l_module);
416: x_return_status := FND_API.G_RET_STS_ERROR ;
417: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

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

418: p_data => x_msg_data
419: );
420: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
421:
422: iby_debug_pub.add(debug_msg => 'In G_EXC_UNEXPECTED_ERROR Exception',
423: debug_level => FND_LOG.LEVEL_UNEXPECTED,
424: module => G_DEBUG_MODULE || l_module);
425: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
426: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

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

427: p_data => x_msg_data
428: );
429: WHEN OTHERS THEN
430:
431: iby_debug_pub.add(debug_msg => 'In OTHERS Exception',
432: debug_level => FND_LOG.LEVEL_UNEXPECTED,
433: module => G_DEBUG_MODULE || l_module);
434:
435: iby_fndcpt_common_pub.Clear_Msg_Stack(l_prev_msg_count);

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

468: p_api_version,
469: l_module,
470: G_PKG_NAME)
471: THEN
472: iby_debug_pub.add(debug_msg => 'Incorrect API Version:=' || p_api_version,
473: debug_level => FND_LOG.LEVEL_ERROR,
474: module => G_DEBUG_MODULE || l_module);
475: FND_MESSAGE.SET_NAME('IBY', 'IBY_204400_API_VER_MISMATCH');
476: FND_MSG_PUB.Add;

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

496: EXCEPTION
497:
498: WHEN FND_API.G_EXC_ERROR THEN
499:
500: iby_debug_pub.add(debug_msg => 'In G_EXC_ERROR Exception',
501: debug_level => FND_LOG.LEVEL_ERROR,
502: module => G_DEBUG_MODULE || l_module);
503: x_return_status := FND_API.G_RET_STS_ERROR ;
504: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

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

505: p_data => x_msg_data
506: );
507: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
508:
509: iby_debug_pub.add(debug_msg => 'In G_EXC_UNEXPECTED_ERROR Exception',
510: debug_level => FND_LOG.LEVEL_UNEXPECTED,
511: module => G_DEBUG_MODULE || l_module);
512: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
513: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

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

514: p_data => x_msg_data
515: );
516: WHEN OTHERS THEN
517:
518: iby_debug_pub.add(debug_msg => 'In OTHERS Exception',
519: debug_level => FND_LOG.LEVEL_UNEXPECTED,
520: module => G_DEBUG_MODULE || l_module);
521: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
522: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

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

602: p_api_version,
603: l_module,
604: G_PKG_NAME)
605: THEN
606: iby_debug_pub.add(debug_msg => 'Incorrect API Version:=' || p_api_version,
607: debug_level => FND_LOG.LEVEL_ERROR,
608: module => G_DEBUG_MODULE || l_module);
609: FND_MESSAGE.SET_NAME('IBY', 'IBY_204400_API_VER_MISMATCH');
610: FND_MSG_PUB.Add;

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

641: EXCEPTION
642:
643: WHEN FND_API.G_EXC_ERROR THEN
644:
645: iby_debug_pub.add(debug_msg => 'In G_EXC_ERROR Exception',
646: debug_level => FND_LOG.LEVEL_ERROR,
647: module => G_DEBUG_MODULE || l_module);
648: x_return_status := FND_API.G_RET_STS_ERROR ;
649: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

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

650: p_data => x_msg_data
651: );
652: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
653:
654: iby_debug_pub.add(debug_msg => 'In G_EXC_UNEXPECTED_ERROR Exception',
655: debug_level => FND_LOG.LEVEL_UNEXPECTED,
656: module => G_DEBUG_MODULE || l_module);
657: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
658: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

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

659: p_data => x_msg_data
660: );
661: WHEN OTHERS THEN
662:
663: iby_debug_pub.add(debug_msg => 'In OTHERS Exception',
664: debug_level => FND_LOG.LEVEL_UNEXPECTED,
665: module => G_DEBUG_MODULE || l_module);
666:
667: iby_fndcpt_common_pub.Clear_Msg_Stack(l_prev_msg_count);

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

718: p_api_version,
719: l_module,
720: G_PKG_NAME)
721: THEN
722: iby_debug_pub.add(debug_msg => 'Incorrect API Version:=' || p_api_version,
723: debug_level => FND_LOG.LEVEL_ERROR,
724: module => G_DEBUG_MODULE || l_module);
725: FND_MESSAGE.SET_NAME('IBY', 'IBY_204400_API_VER_MISMATCH');
726: FND_MSG_PUB.Add;

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

812: EXCEPTION
813:
814: WHEN FND_API.G_EXC_ERROR THEN
815: ROLLBACK TO Set_Payer_Default_Pmt_Channel;
816: iby_debug_pub.add(debug_msg => 'In G_EXC_ERROR Exception',
817: debug_level => FND_LOG.LEVEL_ERROR,
818: module => G_DEBUG_MODULE || l_module);
819: x_return_status := FND_API.G_RET_STS_ERROR ;
820: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

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

821: p_data => x_msg_data
822: );
823: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
824: ROLLBACK TO Set_Payer_Default_Pmt_Channel;
825: iby_debug_pub.add(debug_msg => 'In G_EXC_UNEXPECTED_ERROR Exception',
826: debug_level => FND_LOG.LEVEL_UNEXPECTED,
827: module => G_DEBUG_MODULE || l_module);
828: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
829: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

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

831: );
832: WHEN OTHERS THEN
833: ROLLBACK TO Set_Payer_Default_Pmt_Channel;
834:
835: iby_debug_pub.add(debug_msg => 'In OTHERS Exception',
836: debug_level => FND_LOG.LEVEL_UNEXPECTED,
837: module => G_DEBUG_MODULE || l_module);
838:
839: iby_fndcpt_common_pub.Clear_Msg_Stack(l_prev_msg_count);

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

887: p_api_version,
888: l_module,
889: G_PKG_NAME)
890: THEN
891: iby_debug_pub.add(debug_msg => 'Incorrect API Version:=' || p_api_version,
892: debug_level => FND_LOG.LEVEL_ERROR,
893: module => G_DEBUG_MODULE || l_module);
894: FND_MESSAGE.SET_NAME('IBY', 'IBY_204400_API_VER_MISMATCH');
895: FND_MSG_PUB.Add;

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

924: EXCEPTION
925:
926: WHEN FND_API.G_EXC_ERROR THEN
927:
928: iby_debug_pub.add(debug_msg => 'In G_EXC_ERROR Exception',
929: debug_level => FND_LOG.LEVEL_ERROR,
930: module => G_DEBUG_MODULE || l_module);
931: x_return_status := FND_API.G_RET_STS_ERROR ;
932: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

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

933: p_data => x_msg_data
934: );
935: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
936:
937: iby_debug_pub.add(debug_msg => 'In G_EXC_UNEXPECTED_ERROR Exception',
938: debug_level => FND_LOG.LEVEL_UNEXPECTED,
939: module => G_DEBUG_MODULE || l_module);
940: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
941: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

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

942: p_data => x_msg_data
943: );
944: WHEN OTHERS THEN
945:
946: iby_debug_pub.add(debug_msg => 'In OTHERS Exception',
947: debug_level => FND_LOG.LEVEL_UNEXPECTED,
948: module => G_DEBUG_MODULE || l_module);
949:
950: iby_fndcpt_common_pub.Clear_Msg_Stack(l_prev_msg_count);

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

1021: p_api_version,
1022: l_module,
1023: G_PKG_NAME)
1024: THEN
1025: iby_debug_pub.add(debug_msg => 'Incorrect API Version:=' || p_api_version,
1026: debug_level => FND_LOG.LEVEL_ERROR,
1027: module => G_DEBUG_MODULE || l_module);
1028: FND_MESSAGE.SET_NAME('IBY', 'IBY_204400_API_VER_MISMATCH');
1029: FND_MSG_PUB.Add;

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

1061: EXCEPTION
1062:
1063: WHEN FND_API.G_EXC_ERROR THEN
1064:
1065: iby_debug_pub.add(debug_msg => 'In G_EXC_ERROR Exception',
1066: debug_level => FND_LOG.LEVEL_ERROR,
1067: module => G_DEBUG_MODULE || l_module);
1068: x_return_status := FND_API.G_RET_STS_ERROR ;
1069: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

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

1070: p_data => x_msg_data
1071: );
1072: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1073:
1074: iby_debug_pub.add(debug_msg => 'In G_EXC_UNEXPECTED_ERROR Exception',
1075: debug_level => FND_LOG.LEVEL_UNEXPECTED,
1076: module => G_DEBUG_MODULE || l_module);
1077: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1078: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

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

1079: p_data => x_msg_data
1080: );
1081: WHEN OTHERS THEN
1082:
1083: iby_debug_pub.add(debug_msg => 'In OTHERS Exception',
1084: debug_level => FND_LOG.LEVEL_UNEXPECTED,
1085: module => G_DEBUG_MODULE || l_module);
1086:
1087: iby_fndcpt_common_pub.Clear_Msg_Stack(l_prev_msg_count);

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

1183: AND ACCOUNT_OWNER_PARTY_ID = ci_party_id;
1184:
1185: l_dbg_mod VARCHAR2(100) := G_DEBUG_MODULE || '.' || l_module;
1186: BEGIN
1187: iby_debug_pub.add('Enter',iby_debug_pub.G_LEVEL_PROCEDURE,l_dbg_mod);
1188:
1189: iby_debug_pub.add('p_assignment_attribs.Assignment_Id = '|| p_assignment_attribs.Assignment_Id,iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
1190: iby_debug_pub.add('p_assignment_attribs.Priority = '|| p_assignment_attribs.Priority,iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
1191: iby_debug_pub.add('p_assignment_attribs.Instrument.Instrument_Id = '|| p_assignment_attribs.Instrument.Instrument_Id,iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);

Line 1189: iby_debug_pub.add('p_assignment_attribs.Assignment_Id = '|| p_assignment_attribs.Assignment_Id,iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);

1185: l_dbg_mod VARCHAR2(100) := G_DEBUG_MODULE || '.' || l_module;
1186: BEGIN
1187: iby_debug_pub.add('Enter',iby_debug_pub.G_LEVEL_PROCEDURE,l_dbg_mod);
1188:
1189: iby_debug_pub.add('p_assignment_attribs.Assignment_Id = '|| p_assignment_attribs.Assignment_Id,iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
1190: iby_debug_pub.add('p_assignment_attribs.Priority = '|| p_assignment_attribs.Priority,iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
1191: iby_debug_pub.add('p_assignment_attribs.Instrument.Instrument_Id = '|| p_assignment_attribs.Instrument.Instrument_Id,iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
1192: iby_debug_pub.add('p_assignment_attribs.Instrument.Instrument_Type = '|| p_assignment_attribs.Instrument.Instrument_Type,iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
1193:

Line 1190: iby_debug_pub.add('p_assignment_attribs.Priority = '|| p_assignment_attribs.Priority,iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);

1186: BEGIN
1187: iby_debug_pub.add('Enter',iby_debug_pub.G_LEVEL_PROCEDURE,l_dbg_mod);
1188:
1189: iby_debug_pub.add('p_assignment_attribs.Assignment_Id = '|| p_assignment_attribs.Assignment_Id,iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
1190: iby_debug_pub.add('p_assignment_attribs.Priority = '|| p_assignment_attribs.Priority,iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
1191: iby_debug_pub.add('p_assignment_attribs.Instrument.Instrument_Id = '|| p_assignment_attribs.Instrument.Instrument_Id,iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
1192: iby_debug_pub.add('p_assignment_attribs.Instrument.Instrument_Type = '|| p_assignment_attribs.Instrument.Instrument_Type,iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
1193:
1194:

Line 1191: iby_debug_pub.add('p_assignment_attribs.Instrument.Instrument_Id = '|| p_assignment_attribs.Instrument.Instrument_Id,iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);

1187: iby_debug_pub.add('Enter',iby_debug_pub.G_LEVEL_PROCEDURE,l_dbg_mod);
1188:
1189: iby_debug_pub.add('p_assignment_attribs.Assignment_Id = '|| p_assignment_attribs.Assignment_Id,iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
1190: iby_debug_pub.add('p_assignment_attribs.Priority = '|| p_assignment_attribs.Priority,iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
1191: iby_debug_pub.add('p_assignment_attribs.Instrument.Instrument_Id = '|| p_assignment_attribs.Instrument.Instrument_Id,iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
1192: iby_debug_pub.add('p_assignment_attribs.Instrument.Instrument_Type = '|| p_assignment_attribs.Instrument.Instrument_Type,iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
1193:
1194:
1195: IF (c_instr_assignment%ISOPEN) THEN CLOSE c_instr_assignment; END IF;

Line 1192: iby_debug_pub.add('p_assignment_attribs.Instrument.Instrument_Type = '|| p_assignment_attribs.Instrument.Instrument_Type,iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);

1188:
1189: iby_debug_pub.add('p_assignment_attribs.Assignment_Id = '|| p_assignment_attribs.Assignment_Id,iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
1190: iby_debug_pub.add('p_assignment_attribs.Priority = '|| p_assignment_attribs.Priority,iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
1191: iby_debug_pub.add('p_assignment_attribs.Instrument.Instrument_Id = '|| p_assignment_attribs.Instrument.Instrument_Id,iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
1192: iby_debug_pub.add('p_assignment_attribs.Instrument.Instrument_Type = '|| p_assignment_attribs.Instrument.Instrument_Type,iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
1193:
1194:
1195: IF (c_instr_assignment%ISOPEN) THEN CLOSE c_instr_assignment; END IF;
1196:

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

1198: p_api_version,
1199: l_module,
1200: G_PKG_NAME)
1201: THEN
1202: iby_debug_pub.add(debug_msg => 'Incorrect API Version:=' || p_api_version,
1203: debug_level => FND_LOG.LEVEL_ERROR,
1204: module => G_DEBUG_MODULE || l_module);
1205: FND_MESSAGE.SET_NAME('IBY', 'IBY_204400_API_VER_MISMATCH');
1206: FND_MSG_PUB.Add;

Line 1233: iby_debug_pub.add('l_payer_id = '|| l_payer_id,iby_debug_pub.G_LEVEL_PROCEDURE,l_dbg_mod);

1229:
1230: Get_Payer_Id(p_payer,FND_API.G_VALID_LEVEL_FULL,
1231: l_payer_level,l_payer_id,l_payer_attribs);
1232:
1233: iby_debug_pub.add('l_payer_id = '|| l_payer_id,iby_debug_pub.G_LEVEL_PROCEDURE,l_dbg_mod);
1234:
1235:
1236: IF (l_payer_level = IBY_FNDCPT_COMMON_PUB.G_RC_INVALID_PAYER) THEN
1237: x_response.Result_Code := IBY_FNDCPT_COMMON_PUB.G_RC_INVALID_PAYER;

Line 1292: iby_debug_pub.add('values passed to the cursor',iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);

1288: l_instr_id := p_assignment_attribs.Instrument.Instrument_Id;
1289: l_instrtype := p_assignment_attribs.Instrument.Instrument_Type;
1290: END IF;
1291:
1292: iby_debug_pub.add('**values passed to the cursor**',iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
1293: iby_debug_pub.add('l_assign_id = '|| l_assign_id,iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
1294: iby_debug_pub.add('l_instr_id = '|| l_instr_id,iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
1295: iby_debug_pub.add('l_instrtype = '|| l_instrtype,iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
1296: iby_debug_pub.add('**----**',iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);

Line 1293: iby_debug_pub.add('l_assign_id = '|| l_assign_id,iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);

1289: l_instrtype := p_assignment_attribs.Instrument.Instrument_Type;
1290: END IF;
1291:
1292: iby_debug_pub.add('**values passed to the cursor**',iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
1293: iby_debug_pub.add('l_assign_id = '|| l_assign_id,iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
1294: iby_debug_pub.add('l_instr_id = '|| l_instr_id,iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
1295: iby_debug_pub.add('l_instrtype = '|| l_instrtype,iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
1296: iby_debug_pub.add('**----**',iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
1297:

Line 1294: iby_debug_pub.add('l_instr_id = '|| l_instr_id,iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);

1290: END IF;
1291:
1292: iby_debug_pub.add('**values passed to the cursor**',iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
1293: iby_debug_pub.add('l_assign_id = '|| l_assign_id,iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
1294: iby_debug_pub.add('l_instr_id = '|| l_instr_id,iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
1295: iby_debug_pub.add('l_instrtype = '|| l_instrtype,iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
1296: iby_debug_pub.add('**----**',iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
1297:
1298: OPEN c_instr_assignment(l_assign_id,l_payer_id,

Line 1295: iby_debug_pub.add('l_instrtype = '|| l_instrtype,iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);

1291:
1292: iby_debug_pub.add('**values passed to the cursor**',iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
1293: iby_debug_pub.add('l_assign_id = '|| l_assign_id,iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
1294: iby_debug_pub.add('l_instr_id = '|| l_instr_id,iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
1295: iby_debug_pub.add('l_instrtype = '|| l_instrtype,iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
1296: iby_debug_pub.add('**----**',iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
1297:
1298: OPEN c_instr_assignment(l_assign_id,l_payer_id,
1299: l_instrtype,

Line 1296: iby_debug_pub.add('----',iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);

1292: iby_debug_pub.add('**values passed to the cursor**',iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
1293: iby_debug_pub.add('l_assign_id = '|| l_assign_id,iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
1294: iby_debug_pub.add('l_instr_id = '|| l_instr_id,iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
1295: iby_debug_pub.add('l_instrtype = '|| l_instrtype,iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
1296: iby_debug_pub.add('**----**',iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
1297:
1298: OPEN c_instr_assignment(l_assign_id,l_payer_id,
1299: l_instrtype,
1300: l_instr_id);

Line 1310: iby_debug_pub.add('x_assign_id = '|| x_assign_id,iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);

1306: END IF;
1307: CLOSE c_instr_assignment;
1308:
1309:
1310: iby_debug_pub.add('x_assign_id = '|| x_assign_id,iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
1311: iby_debug_pub.add('l_instrtype = '|| l_instrtype,iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
1312: -- assignment id passed is non-NULL but no instruments found
1313: IF ((x_assign_id IS NULL) AND (NOT l_assign_id IS NULL)) THEN
1314: x_response.Result_Code := G_RC_INVALID_INSTR_ASSIGN;

Line 1311: iby_debug_pub.add('l_instrtype = '|| l_instrtype,iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);

1307: CLOSE c_instr_assignment;
1308:
1309:
1310: iby_debug_pub.add('x_assign_id = '|| x_assign_id,iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
1311: iby_debug_pub.add('l_instrtype = '|| l_instrtype,iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
1312: -- assignment id passed is non-NULL but no instruments found
1313: IF ((x_assign_id IS NULL) AND (NOT l_assign_id IS NULL)) THEN
1314: x_response.Result_Code := G_RC_INVALID_INSTR_ASSIGN;
1315: iby_fndcpt_common_pub.Prepare_Result

Line 1358: iby_debug_pub.add('SQL%ROWCOUNT = '|| SQL%ROWCOUNT,iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);

1354: AND instrument_type = l_instrtype
1355: AND order_of_preference >= l_priority;
1356:
1357:
1358: iby_debug_pub.add('SQL%ROWCOUNT = '|| SQL%ROWCOUNT,iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
1359:
1360: END IF;
1361:
1362: l_last_update := SYSDATE;

Line 1404: iby_debug_pub.add('begin HZ hook',iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);

1400:
1401: l_op_type := 'U';
1402: END IF;
1403:
1404: iby_debug_pub.add('begin HZ hook',iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
1405:
1406: IF (NOT p_payer.Account_Site_Id IS NULL) THEN
1407: l_parent_type := 'CUST_ACCT_SITE_USE';
1408: l_parent_table := 'HZ_CUST_SITE_USES_ALL';

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

1451:
1452: iby_fndcpt_common_pub.Prepare_Result
1453: (l_prev_msg_count,x_return_status,x_msg_count,x_msg_data,x_response);
1454:
1455: iby_debug_pub.add('Exit',iby_debug_pub.G_LEVEL_PROCEDURE,l_dbg_mod);
1456: EXCEPTION
1457:
1458: WHEN FND_API.G_EXC_ERROR THEN
1459: ROLLBACK TO Set_Payer_Instr_Assignment;

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

1456: EXCEPTION
1457:
1458: WHEN FND_API.G_EXC_ERROR THEN
1459: ROLLBACK TO Set_Payer_Instr_Assignment;
1460: iby_debug_pub.add(debug_msg => 'In G_EXC_ERROR Exception',
1461: debug_level => FND_LOG.LEVEL_ERROR,
1462: module => G_DEBUG_MODULE || l_module);
1463: x_return_status := FND_API.G_RET_STS_ERROR ;
1464: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

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

1465: p_data => x_msg_data
1466: );
1467: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1468: ROLLBACK TO Set_Payer_Instr_Assignment;
1469: iby_debug_pub.add(debug_msg => 'In G_EXC_UNEXPECTED_ERROR Exception',
1470: debug_level => FND_LOG.LEVEL_UNEXPECTED,
1471: module => G_DEBUG_MODULE || l_module);
1472: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1473: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

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

1474: p_data => x_msg_data
1475: );
1476: WHEN OTHERS THEN
1477: ROLLBACK TO Set_Payer_Instr_Assignment;
1478: iby_debug_pub.add(debug_msg => 'In OTHERS Exception',
1479: debug_level => FND_LOG.LEVEL_UNEXPECTED,
1480: module => G_DEBUG_MODULE || l_module);
1481:
1482: iby_fndcpt_common_pub.Clear_Msg_Stack(l_prev_msg_count);

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

1531: p_api_version,
1532: l_module,
1533: G_PKG_NAME)
1534: THEN
1535: iby_debug_pub.add(debug_msg => 'Incorrect API Version:=' || p_api_version,
1536: debug_level => FND_LOG.LEVEL_ERROR,
1537: module => G_DEBUG_MODULE || l_module);
1538: FND_MESSAGE.SET_NAME('IBY', 'IBY_204400_API_VER_MISMATCH');
1539: FND_MSG_PUB.Add;

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

1576: EXCEPTION
1577:
1578: WHEN FND_API.G_EXC_ERROR THEN
1579:
1580: iby_debug_pub.add(debug_msg => 'In G_EXC_ERROR Exception',
1581: debug_level => FND_LOG.LEVEL_ERROR,
1582: module => G_DEBUG_MODULE || l_module);
1583: x_return_status := FND_API.G_RET_STS_ERROR ;
1584: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

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

1585: p_data => x_msg_data
1586: );
1587: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1588:
1589: iby_debug_pub.add(debug_msg => 'In G_EXC_UNEXPECTED_ERROR Exception',
1590: debug_level => FND_LOG.LEVEL_UNEXPECTED,
1591: module => G_DEBUG_MODULE || l_module);
1592: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1593: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

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

1594: p_data => x_msg_data
1595: );
1596: WHEN OTHERS THEN
1597:
1598: iby_debug_pub.add(debug_msg => 'In OTHERS Exception',
1599: debug_level => FND_LOG.LEVEL_UNEXPECTED,
1600: module => G_DEBUG_MODULE || l_module);
1601:
1602: iby_fndcpt_common_pub.Clear_Msg_Stack(l_prev_msg_count);

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

1649: p_api_version,
1650: l_module,
1651: G_PKG_NAME)
1652: THEN
1653: iby_debug_pub.add(debug_msg => 'Incorrect API Version:=' || p_api_version,
1654: debug_level => FND_LOG.LEVEL_ERROR,
1655: module => G_DEBUG_MODULE || l_module);
1656: FND_MESSAGE.SET_NAME('IBY', 'IBY_204400_API_VER_MISMATCH');
1657: FND_MSG_PUB.Add;

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

1681: EXCEPTION
1682:
1683: WHEN FND_API.G_EXC_ERROR THEN
1684:
1685: iby_debug_pub.add(debug_msg => 'In G_EXC_ERROR Exception',
1686: debug_level => FND_LOG.LEVEL_ERROR,
1687: module => G_DEBUG_MODULE || l_module);
1688: x_return_status := FND_API.G_RET_STS_ERROR ;
1689: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

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

1690: p_data => x_msg_data
1691: );
1692: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1693:
1694: iby_debug_pub.add(debug_msg => 'In G_EXC_UNEXPECTED_ERROR Exception',
1695: debug_level => FND_LOG.LEVEL_UNEXPECTED,
1696: module => G_DEBUG_MODULE || l_module);
1697: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1698: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

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

1699: p_data => x_msg_data
1700: );
1701: WHEN OTHERS THEN
1702:
1703: iby_debug_pub.add(debug_msg => 'In OTHERS Exception',
1704: debug_level => FND_LOG.LEVEL_UNEXPECTED,
1705: module => G_DEBUG_MODULE || l_module);
1706:
1707: iby_fndcpt_common_pub.Clear_Msg_Stack(l_prev_msg_count);

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

1714: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
1715: p_data => x_msg_data
1716: );
1717:
1718: iby_debug_pub.add(debug_msg => 'x_return_status=' || x_return_status,
1719: debug_level => FND_LOG.LEVEL_UNEXPECTED,
1720: module => G_DEBUG_MODULE || l_module);
1721: iby_debug_pub.add(debug_msg => 'Exit Exception',
1722: debug_level => FND_LOG.LEVEL_UNEXPECTED,

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

1717:
1718: iby_debug_pub.add(debug_msg => 'x_return_status=' || x_return_status,
1719: debug_level => FND_LOG.LEVEL_UNEXPECTED,
1720: module => G_DEBUG_MODULE || l_module);
1721: iby_debug_pub.add(debug_msg => 'Exit Exception',
1722: debug_level => FND_LOG.LEVEL_UNEXPECTED,
1723: module => G_DEBUG_MODULE || l_module);
1724: END Get_Payer_All_Instruments;
1725:

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

1822: p_api_version,
1823: l_module,
1824: G_PKG_NAME)
1825: THEN
1826: iby_debug_pub.add(debug_msg => 'Incorrect API Version:=' || p_api_version,
1827: debug_level => FND_LOG.LEVEL_ERROR,
1828: module => G_DEBUG_MODULE || l_module);
1829: FND_MESSAGE.SET_NAME('IBY', 'IBY_204400_API_VER_MISMATCH');
1830: FND_MSG_PUB.Add;

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

1865: EXCEPTION
1866:
1867: WHEN FND_API.G_EXC_ERROR THEN
1868:
1869: iby_debug_pub.add(debug_msg => 'In G_EXC_ERROR Exception',
1870: debug_level => FND_LOG.LEVEL_ERROR,
1871: module => G_DEBUG_MODULE || l_module);
1872: x_return_status := FND_API.G_RET_STS_ERROR ;
1873: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

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

1874: p_data => x_msg_data
1875: );
1876: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1877:
1878: iby_debug_pub.add(debug_msg => 'In G_EXC_UNEXPECTED_ERROR Exception',
1879: debug_level => FND_LOG.LEVEL_UNEXPECTED,
1880: module => G_DEBUG_MODULE || l_module);
1881: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1882: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

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

1883: p_data => x_msg_data
1884: );
1885: WHEN OTHERS THEN
1886:
1887: iby_debug_pub.add(debug_msg => 'In OTHERS Exception',
1888: debug_level => FND_LOG.LEVEL_UNEXPECTED,
1889: module => G_DEBUG_MODULE || l_module);
1890:
1891: iby_fndcpt_common_pub.Clear_Msg_Stack(l_prev_msg_count);

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

1898: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
1899: p_data => x_msg_data
1900: );
1901:
1902: iby_debug_pub.add(debug_msg => 'x_return_status=' || x_return_status,
1903: debug_level => FND_LOG.LEVEL_UNEXPECTED,
1904: module => G_DEBUG_MODULE || l_module);
1905: iby_debug_pub.add(debug_msg => 'Exit Exception',
1906: debug_level => FND_LOG.LEVEL_UNEXPECTED,

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

1901:
1902: iby_debug_pub.add(debug_msg => 'x_return_status=' || x_return_status,
1903: debug_level => FND_LOG.LEVEL_UNEXPECTED,
1904: module => G_DEBUG_MODULE || l_module);
1905: iby_debug_pub.add(debug_msg => 'Exit Exception',
1906: debug_level => FND_LOG.LEVEL_UNEXPECTED,
1907: module => G_DEBUG_MODULE || l_module);
1908:
1909: END Get_Trxn_Appl_Instr_Assign;

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

2076: SELECT cc_encryption_mode
2077: FROM iby_sys_security_options;
2078:
2079: BEGIN
2080: iby_debug_pub.add('Enter',iby_debug_pub.G_LEVEL_PROCEDURE,l_dbg_mod);
2081:
2082: IF NOT FND_API.Compatible_API_Call (l_api_version,
2083: p_api_version,
2084: l_module,

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

2083: p_api_version,
2084: l_module,
2085: G_PKG_NAME)
2086: THEN
2087: iby_debug_pub.add(debug_msg => 'Incorrect API Version:=' || p_api_version,
2088: debug_level => FND_LOG.LEVEL_ERROR,
2089: module => G_DEBUG_MODULE || l_module);
2090: FND_MESSAGE.SET_NAME('IBY', 'IBY_204400_API_VER_MISMATCH');
2091: FND_MSG_PUB.Add;

Line 2118: iby_debug_pub.add('fetched card id:='||lx_card_rec.Card_Id,

2114: lx_result,
2115: NVL(p_card_instrument.Instrument_Type,IBY_FNDCPT_COMMON_PUB.G_INSTR_TYPE_CREDITCARD)
2116: );
2117:
2118: iby_debug_pub.add('fetched card id:='||lx_card_rec.Card_Id,
2119: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
2120:
2121: IF (lx_card_rec.Card_Id IS NULL) THEN
2122:

Line 2119: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);

2115: NVL(p_card_instrument.Instrument_Type,IBY_FNDCPT_COMMON_PUB.G_INSTR_TYPE_CREDITCARD)
2116: );
2117:
2118: iby_debug_pub.add('fetched card id:='||lx_card_rec.Card_Id,
2119: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
2120:
2121: IF (lx_card_rec.Card_Id IS NULL) THEN
2122:
2123: iby_debug_pub.add('p_card_instrument.Register_Invalid_Card: '|| p_card_instrument.Register_Invalid_Card,

Line 2123: iby_debug_pub.add('p_card_instrument.Register_Invalid_Card: '|| p_card_instrument.Register_Invalid_Card,

2119: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
2120:
2121: IF (lx_card_rec.Card_Id IS NULL) THEN
2122:
2123: iby_debug_pub.add('p_card_instrument.Register_Invalid_Card: '|| p_card_instrument.Register_Invalid_Card,
2124: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
2125:
2126: -- validate billing address information
2127: IF (NOT Validate_CC_Billing(FND_API.G_FALSE,p_card_instrument)) THEN

Line 2124: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);

2120:
2121: IF (lx_card_rec.Card_Id IS NULL) THEN
2122:
2123: iby_debug_pub.add('p_card_instrument.Register_Invalid_Card: '|| p_card_instrument.Register_Invalid_Card,
2124: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
2125:
2126: -- validate billing address information
2127: IF (NOT Validate_CC_Billing(FND_API.G_FALSE,p_card_instrument)) THEN
2128: x_response.Result_Code := iby_creditcard_pkg.G_RC_INVALID_ADDRESS;

Line 2137: iby_debug_pub.add('Starting address validation ..',iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);

2133:
2134: -- lmallick (bug# 8721435)
2135: -- These validations have been moved from iby_creditcard_pkg because the TCA
2136: -- data might not have been committed to the db before invoking the Create_card API
2137: iby_debug_pub.add('Starting address validation ..',iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
2138:
2139: -- If Site use id is already provied then no need to call get_billing address
2140: iby_debug_pub.add('p_card_instrument.Address_Type = '||p_card_instrument.Address_Type,
2141: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);

Line 2140: iby_debug_pub.add('p_card_instrument.Address_Type = '||p_card_instrument.Address_Type,

2136: -- data might not have been committed to the db before invoking the Create_card API
2137: iby_debug_pub.add('Starting address validation ..',iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
2138:
2139: -- If Site use id is already provied then no need to call get_billing address
2140: iby_debug_pub.add('p_card_instrument.Address_Type = '||p_card_instrument.Address_Type,
2141: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
2142: IF (p_card_instrument.Address_Type = IBY_CREDITCARD_PKG.G_PARTY_SITE_USE_ID) AND
2143: (NOT (p_card_instrument.Billing_Address_Id IS NULL)) THEN
2144: l_billing_site := p_card_instrument.Billing_Address_Id;

Line 2141: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);

2137: iby_debug_pub.add('Starting address validation ..',iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
2138:
2139: -- If Site use id is already provied then no need to call get_billing address
2140: iby_debug_pub.add('p_card_instrument.Address_Type = '||p_card_instrument.Address_Type,
2141: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
2142: IF (p_card_instrument.Address_Type = IBY_CREDITCARD_PKG.G_PARTY_SITE_USE_ID) AND
2143: (NOT (p_card_instrument.Billing_Address_Id IS NULL)) THEN
2144: l_billing_site := p_card_instrument.Billing_Address_Id;
2145: ELSE

Line 2154: iby_debug_pub.add('Invalid Billing site.',iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);

2150: IBY_CREDITCARD_PKG.Get_Billing_Site(p_card_instrument.Billing_Address_Id,
2151: p_card_instrument.Owner_Id);
2152: IF (l_billing_site IS NULL) THEN
2153: x_response.Result_Code := IBY_CREDITCARD_PKG.G_RC_INVALID_ADDRESS;
2154: iby_debug_pub.add('Invalid Billing site.',iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
2155: iby_fndcpt_common_pub.Prepare_Result
2156: (l_prev_msg_count,x_return_status,x_msg_count,x_msg_data,x_response);
2157: RETURN;
2158: END IF;

Line 2162: iby_debug_pub.add('l_billing_site = '||l_billing_site,

2158: END IF;
2159: END IF;
2160: END IF;
2161:
2162: iby_debug_pub.add('l_billing_site = '||l_billing_site,
2163: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
2164:
2165: IF (NOT ( (p_card_instrument.Billing_Address_Territory IS NULL)
2166: OR (p_card_instrument.Billing_Address_Territory = FND_API.G_MISS_CHAR) )

Line 2163: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);

2159: END IF;
2160: END IF;
2161:
2162: iby_debug_pub.add('l_billing_site = '||l_billing_site,
2163: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
2164:
2165: IF (NOT ( (p_card_instrument.Billing_Address_Territory IS NULL)
2166: OR (p_card_instrument.Billing_Address_Territory = FND_API.G_MISS_CHAR) )
2167: )

Line 2171: iby_debug_pub.add('Invalid Territory '|| p_card_instrument.Billing_Address_Territory,

2167: )
2168: THEN
2169: IF (NOT iby_utility_pvt.Validate_Territory(p_card_instrument.Billing_Address_Territory)) THEN
2170: x_response.Result_Code := IBY_CREDITCARD_PKG.G_RC_INVALID_ADDRESS;
2171: iby_debug_pub.add('Invalid Territory '|| p_card_instrument.Billing_Address_Territory,
2172: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
2173: iby_fndcpt_common_pub.Prepare_Result
2174: (l_prev_msg_count,x_return_status,x_msg_count,x_msg_data,x_response);
2175: RETURN;

Line 2172: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);

2168: THEN
2169: IF (NOT iby_utility_pvt.Validate_Territory(p_card_instrument.Billing_Address_Territory)) THEN
2170: x_response.Result_Code := IBY_CREDITCARD_PKG.G_RC_INVALID_ADDRESS;
2171: iby_debug_pub.add('Invalid Territory '|| p_card_instrument.Billing_Address_Territory,
2172: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
2173: iby_fndcpt_common_pub.Prepare_Result
2174: (l_prev_msg_count,x_return_status,x_msg_count,x_msg_data,x_response);
2175: RETURN;
2176: END IF;

Line 2182: iby_debug_pub.add('Invalid Owner party '||p_card_instrument.Owner_Id,

2178:
2179: IF (NOT p_card_instrument.Owner_Id IS NULL) THEN
2180: IF (NOT iby_utility_pvt.validate_party_id(p_card_instrument.Owner_Id)) THEN
2181: x_response.Result_Code := IBY_CREDITCARD_PKG.G_RC_INVALID_PARTY;
2182: iby_debug_pub.add('Invalid Owner party '||p_card_instrument.Owner_Id,
2183: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
2184: iby_fndcpt_common_pub.Prepare_Result
2185: (l_prev_msg_count,x_return_status,x_msg_count,x_msg_data,x_response);
2186: RETURN;

Line 2183: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);

2179: IF (NOT p_card_instrument.Owner_Id IS NULL) THEN
2180: IF (NOT iby_utility_pvt.validate_party_id(p_card_instrument.Owner_Id)) THEN
2181: x_response.Result_Code := IBY_CREDITCARD_PKG.G_RC_INVALID_PARTY;
2182: iby_debug_pub.add('Invalid Owner party '||p_card_instrument.Owner_Id,
2183: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
2184: iby_fndcpt_common_pub.Prepare_Result
2185: (l_prev_msg_count,x_return_status,x_msg_count,x_msg_data,x_response);
2186: RETURN;
2187: END IF;

Line 2197: iby_debug_pub.add('online registration',

2193: CLOSE c_sec_mode;
2194:
2195: IF (l_sec_mode = iby_security_pkg.G_ENCRYPT_MODE_INSTANT) THEN
2196:
2197: iby_debug_pub.add('online registration',
2198: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
2199:
2200: l_cc_reg.FIName := p_card_instrument.FI_Name;
2201: l_cc_reg.CC_Type := p_card_instrument.Card_Issuer;

Line 2198: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);

2194:
2195: IF (l_sec_mode = iby_security_pkg.G_ENCRYPT_MODE_INSTANT) THEN
2196:
2197: iby_debug_pub.add('online registration',
2198: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
2199:
2200: l_cc_reg.FIName := p_card_instrument.FI_Name;
2201: l_cc_reg.CC_Type := p_card_instrument.Card_Issuer;
2202: l_cc_reg.CC_Num := p_card_instrument.Card_Number;

Line 2227: iby_debug_pub.add('before calling OraInstrAdd',

2223:
2224: l_instr_reg.CreditCardInstr := l_cc_reg;
2225: l_instr_reg.InstrumentType := IBY_INSTRREG_PUB.C_INSTRTYPE_CREDITCARD;
2226:
2227: iby_debug_pub.add('before calling OraInstrAdd',
2228: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
2229:
2230: IBY_INSTRREG_PUB.OraInstrAdd
2231: (1.0, FND_API.G_FALSE, FND_API.G_FALSE, FND_API.G_VALID_LEVEL_FULL,

Line 2228: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);

2224: l_instr_reg.CreditCardInstr := l_cc_reg;
2225: l_instr_reg.InstrumentType := IBY_INSTRREG_PUB.C_INSTRTYPE_CREDITCARD;
2226:
2227: iby_debug_pub.add('before calling OraInstrAdd',
2228: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
2229:
2230: IBY_INSTRREG_PUB.OraInstrAdd
2231: (1.0, FND_API.G_FALSE, FND_API.G_FALSE, FND_API.G_VALID_LEVEL_FULL,
2232: l_instr_reg, x_return_status, x_msg_count, x_msg_data,

Line 2240: iby_debug_pub.add('instrument reg failed',

2236: -- should not be a validation error at this point
2237: IF ((NVL(x_card_id,-1)<0))
2238: --OR (x_return_status <> FND_API.G_RET_STS_ERROR))
2239: THEN
2240: iby_debug_pub.add('instrument reg failed',
2241: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
2242: iby_debug_pub.add('result code:=' || lx_result.Result_Code,
2243: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
2244: IF (lx_result.Result_Code IS NULL) THEN

Line 2241: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);

2237: IF ((NVL(x_card_id,-1)<0))
2238: --OR (x_return_status <> FND_API.G_RET_STS_ERROR))
2239: THEN
2240: iby_debug_pub.add('instrument reg failed',
2241: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
2242: iby_debug_pub.add('result code:=' || lx_result.Result_Code,
2243: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
2244: IF (lx_result.Result_Code IS NULL) THEN
2245: x_response.Result_Code := 'COMMUNICATION_ERROR';

Line 2242: iby_debug_pub.add('result code:=' || lx_result.Result_Code,

2238: --OR (x_return_status <> FND_API.G_RET_STS_ERROR))
2239: THEN
2240: iby_debug_pub.add('instrument reg failed',
2241: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
2242: iby_debug_pub.add('result code:=' || lx_result.Result_Code,
2243: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
2244: IF (lx_result.Result_Code IS NULL) THEN
2245: x_response.Result_Code := 'COMMUNICATION_ERROR';
2246: --IBY_FNDCPT_COMMON_PUB.G_RC_GENERIC_SYS_ERROR;

Line 2243: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);

2239: THEN
2240: iby_debug_pub.add('instrument reg failed',
2241: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
2242: iby_debug_pub.add('result code:=' || lx_result.Result_Code,
2243: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
2244: IF (lx_result.Result_Code IS NULL) THEN
2245: x_response.Result_Code := 'COMMUNICATION_ERROR';
2246: --IBY_FNDCPT_COMMON_PUB.G_RC_GENERIC_SYS_ERROR;
2247: iby_fndcpt_common_pub.Prepare_Result

Line 2261: iby_debug_pub.add('database registration',

2257: END IF;
2258: RETURN;
2259: END IF;
2260: ELSE
2261: iby_debug_pub.add('database registration',
2262: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
2263:
2264: iby_creditcard_pkg.Create_Card
2265: (FND_API.G_FALSE,

Line 2262: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);

2258: RETURN;
2259: END IF;
2260: ELSE
2261: iby_debug_pub.add('database registration',
2262: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
2263:
2264: iby_creditcard_pkg.Create_Card
2265: (FND_API.G_FALSE,
2266: p_card_instrument.Owner_Id, p_card_instrument.Card_Holder_Name,

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

2382: EXCEPTION
2383:
2384: WHEN FND_API.G_EXC_ERROR THEN
2385: ROLLBACK TO Create_Card;
2386: iby_debug_pub.add(debug_msg => 'In G_EXC_ERROR Exception',
2387: debug_level => FND_LOG.LEVEL_ERROR,
2388: module => G_DEBUG_MODULE || l_module);
2389: x_return_status := FND_API.G_RET_STS_ERROR ;
2390: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

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

2391: p_data => x_msg_data
2392: );
2393: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2394: --ROLLBACK TO Create_Card;
2395: iby_debug_pub.add(debug_msg => 'In G_EXC_UNEXPECTED_ERROR Exception',
2396: debug_level => FND_LOG.LEVEL_UNEXPECTED,
2397: module => G_DEBUG_MODULE || l_module);
2398: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2399: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

Line 2404: iby_debug_pub.add(debug_msg => 'In OTHERS Exception'||SQLERRM,

2400: p_data => x_msg_data
2401: );
2402: WHEN OTHERS THEN
2403: --ROLLBACK TO Create_Card;
2404: iby_debug_pub.add(debug_msg => 'In OTHERS Exception'||SQLERRM,
2405: debug_level => FND_LOG.LEVEL_UNEXPECTED,
2406: module => G_DEBUG_MODULE || l_module);
2407:
2408: iby_fndcpt_common_pub.Clear_Msg_Stack(l_prev_msg_count);

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

2415: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
2416: p_data => x_msg_data
2417: );
2418:
2419: iby_debug_pub.add(debug_msg => 'x_return_status=' || x_return_status,
2420: debug_level => FND_LOG.LEVEL_UNEXPECTED,
2421: module => G_DEBUG_MODULE || l_module);
2422: iby_debug_pub.add(debug_msg => 'Exit Exception',
2423: debug_level => FND_LOG.LEVEL_UNEXPECTED,

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

2418:
2419: iby_debug_pub.add(debug_msg => 'x_return_status=' || x_return_status,
2420: debug_level => FND_LOG.LEVEL_UNEXPECTED,
2421: module => G_DEBUG_MODULE || l_module);
2422: iby_debug_pub.add(debug_msg => 'Exit Exception',
2423: debug_level => FND_LOG.LEVEL_UNEXPECTED,
2424: module => G_DEBUG_MODULE || l_module);
2425:
2426: END Create_Card;

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

2578: p_api_version,
2579: l_module,
2580: G_PKG_NAME)
2581: THEN
2582: iby_debug_pub.add(debug_msg => 'Incorrect API Version:=' || p_api_version,
2583: debug_level => FND_LOG.LEVEL_ERROR,
2584: module => G_DEBUG_MODULE || l_module);
2585: FND_MESSAGE.SET_NAME('IBY', 'IBY_204400_API_VER_MISMATCH');
2586: FND_MSG_PUB.Add;

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

2651: EXCEPTION
2652:
2653: WHEN FND_API.G_EXC_ERROR THEN
2654: ROLLBACK TO Update_Card;
2655: iby_debug_pub.add(debug_msg => 'In G_EXC_ERROR Exception',
2656: debug_level => FND_LOG.LEVEL_ERROR,
2657: module => G_DEBUG_MODULE || l_module);
2658: x_return_status := FND_API.G_RET_STS_ERROR ;
2659: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

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

2660: p_data => x_msg_data
2661: );
2662: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2663: ROLLBACK TO Update_Card;
2664: iby_debug_pub.add(debug_msg => 'In G_EXC_UNEXPECTED_ERROR Exception',
2665: debug_level => FND_LOG.LEVEL_UNEXPECTED,
2666: module => G_DEBUG_MODULE || l_module);
2667: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2668: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

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

2669: p_data => x_msg_data
2670: );
2671: WHEN OTHERS THEN
2672: ROLLBACK TO Update_Card;
2673: iby_debug_pub.add(debug_msg => 'In OTHERS Exception',
2674: debug_level => FND_LOG.LEVEL_UNEXPECTED,
2675: module => G_DEBUG_MODULE || l_module);
2676:
2677: iby_fndcpt_common_pub.Clear_Msg_Stack(l_prev_msg_count);

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

2684: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
2685: p_data => x_msg_data
2686: );
2687:
2688: iby_debug_pub.add(debug_msg => 'x_return_status=' || x_return_status,
2689: debug_level => FND_LOG.LEVEL_UNEXPECTED,
2690: module => G_DEBUG_MODULE || l_module);
2691: iby_debug_pub.add(debug_msg => 'Exit Exception',
2692: debug_level => FND_LOG.LEVEL_UNEXPECTED,

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

2687:
2688: iby_debug_pub.add(debug_msg => 'x_return_status=' || x_return_status,
2689: debug_level => FND_LOG.LEVEL_UNEXPECTED,
2690: module => G_DEBUG_MODULE || l_module);
2691: iby_debug_pub.add(debug_msg => 'Exit Exception',
2692: debug_level => FND_LOG.LEVEL_UNEXPECTED,
2693: module => G_DEBUG_MODULE || l_module);
2694:
2695: END Update_Card;

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

2729: p_api_version,
2730: l_module,
2731: G_PKG_NAME)
2732: THEN
2733: iby_debug_pub.add(debug_msg => 'Incorrect API Version:=' || p_api_version,
2734: debug_level => FND_LOG.LEVEL_ERROR,
2735: module => G_DEBUG_MODULE || l_module);
2736: FND_MESSAGE.SET_NAME('IBY', 'IBY_204400_API_VER_MISMATCH');
2737: FND_MSG_PUB.Add;

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

2766: EXCEPTION
2767:
2768: WHEN FND_API.G_EXC_ERROR THEN
2769:
2770: iby_debug_pub.add(debug_msg => 'In G_EXC_ERROR Exception',
2771: debug_level => FND_LOG.LEVEL_ERROR,
2772: module => G_DEBUG_MODULE || l_module);
2773: x_return_status := FND_API.G_RET_STS_ERROR ;
2774: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

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

2775: p_data => x_msg_data
2776: );
2777: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2778:
2779: iby_debug_pub.add(debug_msg => 'In G_EXC_UNEXPECTED_ERROR Exception',
2780: debug_level => FND_LOG.LEVEL_UNEXPECTED,
2781: module => G_DEBUG_MODULE || l_module);
2782: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2783: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

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

2784: p_data => x_msg_data
2785: );
2786: WHEN OTHERS THEN
2787:
2788: iby_debug_pub.add(debug_msg => 'In OTHERS Exception',
2789: debug_level => FND_LOG.LEVEL_UNEXPECTED,
2790: module => G_DEBUG_MODULE || l_module);
2791:
2792: iby_fndcpt_common_pub.Clear_Msg_Stack(l_prev_msg_count);

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

2799: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
2800: p_data => x_msg_data
2801: );
2802:
2803: iby_debug_pub.add(debug_msg => 'x_return_status=' || x_return_status,
2804: debug_level => FND_LOG.LEVEL_UNEXPECTED,
2805: module => G_DEBUG_MODULE || l_module);
2806: iby_debug_pub.add(debug_msg => 'Exit Exception',
2807: debug_level => FND_LOG.LEVEL_UNEXPECTED,

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

2802:
2803: iby_debug_pub.add(debug_msg => 'x_return_status=' || x_return_status,
2804: debug_level => FND_LOG.LEVEL_UNEXPECTED,
2805: module => G_DEBUG_MODULE || l_module);
2806: iby_debug_pub.add(debug_msg => 'Exit Exception',
2807: debug_level => FND_LOG.LEVEL_UNEXPECTED,
2808: module => G_DEBUG_MODULE || l_module);
2809: END;
2810:

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

2859: p_api_version,
2860: l_module,
2861: G_PKG_NAME)
2862: THEN
2863: iby_debug_pub.add(debug_msg => 'Incorrect API Version:=' || p_api_version,
2864: debug_level => FND_LOG.LEVEL_ERROR,
2865: module => G_DEBUG_MODULE || l_module);
2866: FND_MESSAGE.SET_NAME('IBY', 'IBY_204400_API_VER_MISMATCH');
2867: FND_MSG_PUB.Add;

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

2917: EXCEPTION
2918:
2919: WHEN FND_API.G_EXC_ERROR THEN
2920:
2921: iby_debug_pub.add(debug_msg => 'In G_EXC_ERROR Exception',
2922: debug_level => FND_LOG.LEVEL_ERROR,
2923: module => G_DEBUG_MODULE || l_module);
2924: x_return_status := FND_API.G_RET_STS_ERROR ;
2925: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

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

2926: p_data => x_msg_data
2927: );
2928: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2929:
2930: iby_debug_pub.add(debug_msg => 'In G_EXC_UNEXPECTED_ERROR Exception',
2931: debug_level => FND_LOG.LEVEL_UNEXPECTED,
2932: module => G_DEBUG_MODULE || l_module);
2933: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2934: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

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

2935: p_data => x_msg_data
2936: );
2937: WHEN OTHERS THEN
2938:
2939: iby_debug_pub.add(debug_msg => 'In OTHERS Exception',
2940: debug_level => FND_LOG.LEVEL_UNEXPECTED,
2941: module => G_DEBUG_MODULE || l_module);
2942:
2943: iby_fndcpt_common_pub.Clear_Msg_Stack(l_prev_msg_count);

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

2950: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
2951: p_data => x_msg_data
2952: );
2953:
2954: iby_debug_pub.add(debug_msg => 'x_return_status=' || x_return_status,
2955: debug_level => FND_LOG.LEVEL_UNEXPECTED,
2956: module => G_DEBUG_MODULE || l_module);
2957: iby_debug_pub.add(debug_msg => 'Exit Exception',
2958: debug_level => FND_LOG.LEVEL_UNEXPECTED,

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

2953:
2954: iby_debug_pub.add(debug_msg => 'x_return_status=' || x_return_status,
2955: debug_level => FND_LOG.LEVEL_UNEXPECTED,
2956: module => G_DEBUG_MODULE || l_module);
2957: iby_debug_pub.add(debug_msg => 'Exit Exception',
2958: debug_level => FND_LOG.LEVEL_UNEXPECTED,
2959: module => G_DEBUG_MODULE || l_module);
2960: END Card_Exists;
2961:

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

2987: lx_assign_attribs PmtInstrAssignment_rec_type;
2988:
2989: l_dbg_mod VARCHAR2(100) := G_DEBUG_MODULE || '.' || l_module;
2990: BEGIN
2991: iby_debug_pub.add('Enter',iby_debug_pub.G_LEVEL_PROCEDURE,l_dbg_mod);
2992:
2993: IF NOT FND_API.Compatible_API_Call (l_api_version,
2994: p_api_version,
2995: l_module,

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

2994: p_api_version,
2995: l_module,
2996: G_PKG_NAME)
2997: THEN
2998: iby_debug_pub.add(debug_msg => 'Incorrect API Version:=' || p_api_version,
2999: debug_level => FND_LOG.LEVEL_ERROR,
3000: module => G_DEBUG_MODULE || l_module);
3001: FND_MESSAGE.SET_NAME('IBY', 'IBY_204400_API_VER_MISMATCH');
3002: FND_MSG_PUB.Add;

Line 3017: iby_debug_pub.add('create card',iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);

3013: SAVEPOINT Process_Credit_Card;
3014:
3015: lx_assign_attribs := p_assignment_attribs;
3016:
3017: iby_debug_pub.add('create card',iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
3018:
3019: Create_Card
3020: (1.0, FND_API.G_FALSE, FND_API.G_FALSE, lx_return_status, lx_msg_count,
3021: lx_msg_data, p_credit_card,

Line 3027: iby_debug_pub.add('rollback',iby_debug_pub.G_LEVEL_ERROR,l_dbg_mod);

3023: lx_response
3024: );
3025:
3026: IF (lx_response.Result_Code <> IBY_FNDCPT_COMMON_PUB.G_RC_SUCCESS) THEN
3027: iby_debug_pub.add('rollback',iby_debug_pub.G_LEVEL_ERROR,l_dbg_mod);
3028: ROLLBACK TO Process_Credit_Card;
3029: x_response := lx_response;
3030: ELSE
3031:

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

3049: EXCEPTION
3050:
3051: WHEN FND_API.G_EXC_ERROR THEN
3052: ROLLBACK TO Process_Credit_Card;
3053: iby_debug_pub.add(debug_msg => 'In G_EXC_ERROR Exception',
3054: debug_level => FND_LOG.LEVEL_ERROR,
3055: module => G_DEBUG_MODULE || l_module);
3056: x_return_status := FND_API.G_RET_STS_ERROR ;
3057: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

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

3058: p_data => x_msg_data
3059: );
3060: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3061: ROLLBACK TO Process_Credit_Card;
3062: iby_debug_pub.add(debug_msg => 'In G_EXC_UNEXPECTED_ERROR Exception',
3063: debug_level => FND_LOG.LEVEL_UNEXPECTED,
3064: module => G_DEBUG_MODULE || l_module);
3065: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3066: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

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

3067: p_data => x_msg_data
3068: );
3069: WHEN OTHERS THEN
3070: ROLLBACK TO Process_Credit_Card;
3071: iby_debug_pub.add(debug_msg => 'In OTHERS Exception',
3072: debug_level => FND_LOG.LEVEL_UNEXPECTED,
3073: module => G_DEBUG_MODULE || l_module);
3074:
3075: iby_fndcpt_common_pub.Clear_Msg_Stack(l_prev_msg_count);

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

3181: l_expiry_date DATE;
3182:
3183: l_dbg_mod VARCHAR2(100) := 'iby.plsql.IBY_FNDCPT_SETUP_PUB' || '.' || 'Get_Expiration_Status';
3184: BEGIN
3185: iby_debug_pub.add('Enter',iby_debug_pub.G_LEVEL_PROCEDURE,l_dbg_mod);
3186: x_result_code := FND_API.G_RET_STS_SUCCESS;
3187:
3188: SELECT expirydate, expiry_sec_segment_id
3189: INTO l_expiry_date, l_exp_sec_segment_id

Line 3214: iby_debug_pub.add('Error during http call out',iby_debug_pub.G_LEVEL_ERROR,l_dbg_mod);

3210: l_msg_data,
3211: l_resp_rec
3212: );
3213: IF(l_return_status <> FND_API.G_RET_STS_SUCCESS)THEN
3214: iby_debug_pub.add('Error during http call out',iby_debug_pub.G_LEVEL_ERROR,l_dbg_mod);
3215: x_result_code := FND_API.G_RET_STS_ERROR;
3216: RETURN;
3217: END IF;
3218: x_expired := l_resp_rec.Expired;

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

3215: x_result_code := FND_API.G_RET_STS_ERROR;
3216: RETURN;
3217: END IF;
3218: x_expired := l_resp_rec.Expired;
3219: iby_debug_pub.add('Exit',iby_debug_pub.G_LEVEL_PROCEDURE,l_dbg_mod);
3220: END Get_Card_Expiration_Status;
3221:
3222: FUNCTION Get_Encryption_Patch_Level
3223: RETURN VARCHAR2

Line 3264: print_debuginfo('Enter',iby_debug_pub.G_LEVEL_PROCEDURE, l_dbg_mod);

3260: l_module CONSTANT VARCHAR2(30) := 'Create_Debit_Authorization';
3261: l_dbg_mod VARCHAR2(100) := G_DEBUG_MODULE || '.' || l_module;
3262:
3263: BEGIN
3264: print_debuginfo('Enter',iby_debug_pub.G_LEVEL_PROCEDURE, l_dbg_mod);
3265: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3266: print_debuginfo('DEBIT_AUTHORIZATION_ID:'||
3267: p_debit_auth_id,iby_debug_pub.G_LEVEL_INFO, l_dbg_mod);
3268: print_debuginfo('EXTERNAL_BANK_ACCOUNT_USE_ID:'||

Line 3267: p_debit_auth_id,iby_debug_pub.G_LEVEL_INFO, l_dbg_mod);

3263: BEGIN
3264: print_debuginfo('Enter',iby_debug_pub.G_LEVEL_PROCEDURE, l_dbg_mod);
3265: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3266: print_debuginfo('DEBIT_AUTHORIZATION_ID:'||
3267: p_debit_auth_id,iby_debug_pub.G_LEVEL_INFO, l_dbg_mod);
3268: print_debuginfo('EXTERNAL_BANK_ACCOUNT_USE_ID:'||
3269: p_bank_use_id,iby_debug_pub.G_LEVEL_INFO, l_dbg_mod);
3270: print_debuginfo('AUTHORIZATION_REFERENCE_NUMBER:'||
3271: p_auth_ref_number,iby_debug_pub.G_LEVEL_INFO, l_dbg_mod);

Line 3269: p_bank_use_id,iby_debug_pub.G_LEVEL_INFO, l_dbg_mod);

3265: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3266: print_debuginfo('DEBIT_AUTHORIZATION_ID:'||
3267: p_debit_auth_id,iby_debug_pub.G_LEVEL_INFO, l_dbg_mod);
3268: print_debuginfo('EXTERNAL_BANK_ACCOUNT_USE_ID:'||
3269: p_bank_use_id,iby_debug_pub.G_LEVEL_INFO, l_dbg_mod);
3270: print_debuginfo('AUTHORIZATION_REFERENCE_NUMBER:'||
3271: p_auth_ref_number,iby_debug_pub.G_LEVEL_INFO, l_dbg_mod);
3272: print_debuginfo('INITIAL_DEBIT_AUTHORIZATION_ID:'||
3273: p_initial_debit_auth_id,iby_debug_pub.G_LEVEL_INFO, l_dbg_mod);

Line 3271: p_auth_ref_number,iby_debug_pub.G_LEVEL_INFO, l_dbg_mod);

3267: p_debit_auth_id,iby_debug_pub.G_LEVEL_INFO, l_dbg_mod);
3268: print_debuginfo('EXTERNAL_BANK_ACCOUNT_USE_ID:'||
3269: p_bank_use_id,iby_debug_pub.G_LEVEL_INFO, l_dbg_mod);
3270: print_debuginfo('AUTHORIZATION_REFERENCE_NUMBER:'||
3271: p_auth_ref_number,iby_debug_pub.G_LEVEL_INFO, l_dbg_mod);
3272: print_debuginfo('INITIAL_DEBIT_AUTHORIZATION_ID:'||
3273: p_initial_debit_auth_id,iby_debug_pub.G_LEVEL_INFO, l_dbg_mod);
3274: print_debuginfo('AUTHORIZATION_REVISION_NUMBER:'||
3275: p_auth_rev_number,iby_debug_pub.G_LEVEL_INFO, l_dbg_mod);

Line 3273: p_initial_debit_auth_id,iby_debug_pub.G_LEVEL_INFO, l_dbg_mod);

3269: p_bank_use_id,iby_debug_pub.G_LEVEL_INFO, l_dbg_mod);
3270: print_debuginfo('AUTHORIZATION_REFERENCE_NUMBER:'||
3271: p_auth_ref_number,iby_debug_pub.G_LEVEL_INFO, l_dbg_mod);
3272: print_debuginfo('INITIAL_DEBIT_AUTHORIZATION_ID:'||
3273: p_initial_debit_auth_id,iby_debug_pub.G_LEVEL_INFO, l_dbg_mod);
3274: print_debuginfo('AUTHORIZATION_REVISION_NUMBER:'||
3275: p_auth_rev_number,iby_debug_pub.G_LEVEL_INFO, l_dbg_mod);
3276: print_debuginfo('AUTH_SIGN_DATE:'||
3277: p_auth_sign_date,iby_debug_pub.G_LEVEL_INFO, l_dbg_mod);

Line 3275: p_auth_rev_number,iby_debug_pub.G_LEVEL_INFO, l_dbg_mod);

3271: p_auth_ref_number,iby_debug_pub.G_LEVEL_INFO, l_dbg_mod);
3272: print_debuginfo('INITIAL_DEBIT_AUTHORIZATION_ID:'||
3273: p_initial_debit_auth_id,iby_debug_pub.G_LEVEL_INFO, l_dbg_mod);
3274: print_debuginfo('AUTHORIZATION_REVISION_NUMBER:'||
3275: p_auth_rev_number,iby_debug_pub.G_LEVEL_INFO, l_dbg_mod);
3276: print_debuginfo('AUTH_SIGN_DATE:'||
3277: p_auth_sign_date,iby_debug_pub.G_LEVEL_INFO, l_dbg_mod);
3278: print_debuginfo('DEBIT_AUTH_BEGIN'||
3279: p_debit_auth_begin,iby_debug_pub.G_LEVEL_INFO, l_dbg_mod);

Line 3277: p_auth_sign_date,iby_debug_pub.G_LEVEL_INFO, l_dbg_mod);

3273: p_initial_debit_auth_id,iby_debug_pub.G_LEVEL_INFO, l_dbg_mod);
3274: print_debuginfo('AUTHORIZATION_REVISION_NUMBER:'||
3275: p_auth_rev_number,iby_debug_pub.G_LEVEL_INFO, l_dbg_mod);
3276: print_debuginfo('AUTH_SIGN_DATE:'||
3277: p_auth_sign_date,iby_debug_pub.G_LEVEL_INFO, l_dbg_mod);
3278: print_debuginfo('DEBIT_AUTH_BEGIN'||
3279: p_debit_auth_begin,iby_debug_pub.G_LEVEL_INFO, l_dbg_mod);
3280: END IF;
3281:

Line 3279: p_debit_auth_begin,iby_debug_pub.G_LEVEL_INFO, l_dbg_mod);

3275: p_auth_rev_number,iby_debug_pub.G_LEVEL_INFO, l_dbg_mod);
3276: print_debuginfo('AUTH_SIGN_DATE:'||
3277: p_auth_sign_date,iby_debug_pub.G_LEVEL_INFO, l_dbg_mod);
3278: print_debuginfo('DEBIT_AUTH_BEGIN'||
3279: p_debit_auth_begin,iby_debug_pub.G_LEVEL_INFO, l_dbg_mod);
3280: END IF;
3281:
3282: INSERT INTO IBY_DEBIT_AUTHORIZATIONS
3283: (DEBIT_AUTHORIZATION_ID,

Line 3310: print_debuginfo('x_result:'|| x_result,iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);

3306: p_debit_auth_flag,p_debit_auth_ref,p_cust_id_code,
3307: p_creditor_identifer,p_debit_auth_end, 'Y', p_mandate_file);
3308: COMMIT;
3309: x_result:=1;
3310: print_debuginfo('x_result:'|| x_result,iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
3311: EXCEPTION
3312: WHEN OTHERS THEN
3313: x_result:=0;
3314: print_debuginfo('Exception occured while inserting the mandate:' ||

Line 3315: sqlerrm,iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);

3311: EXCEPTION
3312: WHEN OTHERS THEN
3313: x_result:=0;
3314: print_debuginfo('Exception occured while inserting the mandate:' ||
3315: sqlerrm,iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
3316: raise;
3317: print_debuginfo('End',iby_debug_pub.G_LEVEL_PROCEDURE,l_dbg_mod);
3318: END Create_Debit_Authorization;
3319:

Line 3317: print_debuginfo('End',iby_debug_pub.G_LEVEL_PROCEDURE,l_dbg_mod);

3313: x_result:=0;
3314: print_debuginfo('Exception occured while inserting the mandate:' ||
3315: sqlerrm,iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
3316: raise;
3317: print_debuginfo('End',iby_debug_pub.G_LEVEL_PROCEDURE,l_dbg_mod);
3318: END Create_Debit_Authorization;
3319:
3320: -- Procedure to update the existing Mandate
3321: PROCEDURE Update_Debit_Authorization

Line 3368: print_debuginfo('Enter',iby_debug_pub.G_LEVEL_PROCEDURE,l_dbg_mod);

3364:
3365: IF (trxn_ref%ISOPEN) THEN
3366: CLOSE trxn_ref;
3367: END IF;
3368: print_debuginfo('Enter',iby_debug_pub.G_LEVEL_PROCEDURE,l_dbg_mod);
3369:
3370: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3371: print_debuginfo('p_debit_auth_flag:'||
3372: p_debit_auth_flag,iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);

Line 3372: p_debit_auth_flag,iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);

3368: print_debuginfo('Enter',iby_debug_pub.G_LEVEL_PROCEDURE,l_dbg_mod);
3369:
3370: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3371: print_debuginfo('p_debit_auth_flag:'||
3372: p_debit_auth_flag,iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
3373: print_debuginfo('p_creditor_name:'||
3374: p_creditor_name,iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
3375: print_debuginfo('p_creditor_identifer:'||
3376: p_creditor_identifer,iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);

Line 3374: p_creditor_name,iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);

3370: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3371: print_debuginfo('p_debit_auth_flag:'||
3372: p_debit_auth_flag,iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
3373: print_debuginfo('p_creditor_name:'||
3374: p_creditor_name,iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
3375: print_debuginfo('p_creditor_identifer:'||
3376: p_creditor_identifer,iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
3377: END IF;
3378:

Line 3376: p_creditor_identifer,iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);

3372: p_debit_auth_flag,iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
3373: print_debuginfo('p_creditor_name:'||
3374: p_creditor_name,iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
3375: print_debuginfo('p_creditor_identifer:'||
3376: p_creditor_identifer,iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
3377: END IF;
3378:
3379: SELECT AUTHORIZATION_REFERENCE_NUMBER, CREDITOR_LE_NAME, CREDITOR_IDENTIFIER
3380: into l_auth_ref_number, l_creditor_name, l_creditor_identifer

Line 3387: l_auth_ref_number,iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);

3383: DEBIT_AUTHORIZATION_ID = p_debit_auth_id;
3384:
3385: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3386: print_debuginfo('l_auth_ref_number:'||
3387: l_auth_ref_number,iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
3388: print_debuginfo('L_creditor_name:'||
3389: l_creditor_name,iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
3390: print_debuginfo('L_creditor_identifer:'||
3391: l_creditor_identifer,iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);

Line 3389: l_creditor_name,iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);

3385: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3386: print_debuginfo('l_auth_ref_number:'||
3387: l_auth_ref_number,iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
3388: print_debuginfo('L_creditor_name:'||
3389: l_creditor_name,iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
3390: print_debuginfo('L_creditor_identifer:'||
3391: l_creditor_identifer,iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
3392: print_debuginfo('p_debit_auth_id:'||
3393: p_debit_auth_id,iby_debug_pub.G_LEVEL_PROCEDURE,l_dbg_mod);

Line 3391: l_creditor_identifer,iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);

3387: l_auth_ref_number,iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
3388: print_debuginfo('L_creditor_name:'||
3389: l_creditor_name,iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
3390: print_debuginfo('L_creditor_identifer:'||
3391: l_creditor_identifer,iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
3392: print_debuginfo('p_debit_auth_id:'||
3393: p_debit_auth_id,iby_debug_pub.G_LEVEL_PROCEDURE,l_dbg_mod);
3394: END IF;
3395: -- Bug# 9508632

Line 3393: p_debit_auth_id,iby_debug_pub.G_LEVEL_PROCEDURE,l_dbg_mod);

3389: l_creditor_name,iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
3390: print_debuginfo('L_creditor_identifer:'||
3391: l_creditor_identifer,iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
3392: print_debuginfo('p_debit_auth_id:'||
3393: p_debit_auth_id,iby_debug_pub.G_LEVEL_PROCEDURE,l_dbg_mod);
3394: END IF;
3395: -- Bug# 9508632
3396: -- Comparing the unique auth ref number
3397: IF(p_auth_ref_number <>l_auth_ref_number OR

Line 3403: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);

3399: p_creditor_identifer <> l_creditor_identifer)
3400: THEN
3401: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3402: print_debuginfo('Before Updating mandate',
3403: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
3404: END IF;
3405:
3406: UPDATE IBY_DEBIT_AUTHORIZATIONS SET DEBIT_AUTH_END = SYSDATE,
3407: CURR_REC_INDI = 'N'

Line 3414: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);

3410: select IBY_DEBIT_AUTHORIZATIONS_S.nextval into l_seq_number from dual;
3411:
3412: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3413: print_debuginfo('Creating the new Mandate:',
3414: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
3415: END IF;
3416:
3417: Create_Debit_Authorization(l_seq_number,
3418: p_bank_use_id,

Line 3449: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);

3445: UPDATE IBY_TRXN_SUMMARIES_ALL SET DEBIT_AUTHORIZATION_ID = l_seq_number where debit_authorization_id = p_debit_auth_id and trxnmid = trxn_rec.trxnmid;
3446:
3447: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3448: print_debuginfo('Trxn Id : ' || trxn_rec.trxnmid || 'with debit-authorization_id = ' || p_debit_auth_id || 'updated with debit auth : ' || l_seq_number,
3449: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
3450: END IF;
3451:
3452: END LOOP;
3453: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 3455: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);

3451:
3452: END LOOP;
3453: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3454: print_debuginfo('UPDATING THE TRANSACTION WITH THE NEW DEBIT_AUTHORIZATION_ID',
3455: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
3456: END IF;
3457:
3458:
3459:

Line 3463: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);

3459:
3460:
3461: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3462: print_debuginfo('After creating the new Mandate:',
3463: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
3464: END IF;
3465:
3466: ELSE
3467: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 3469: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);

3465:
3466: ELSE
3467: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3468: print_debuginfo('Updating mandate12:',
3469: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
3470: END IF;
3471:
3472: UPDATE IBY_DEBIT_AUTHORIZATIONS
3473: SET

Line 3499: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);

3495: WHERE
3496: DEBIT_AUTHORIZATION_ID = p_debit_auth_id;
3497: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3498: print_debuginfo('Mandate has been updated:',
3499: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
3500: END IF;
3501: END IF;
3502: COMMIT;
3503: x_result:=1;

Line 3506: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);

3502: COMMIT;
3503: x_result:=1;
3504: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3505: print_debuginfo('x_result:' || x_result,
3506: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
3507: END IF;
3508: EXCEPTION
3509: WHEN OTHERS THEN
3510: x_result:=0;

Line 3512: sqlerrm,iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);

3508: EXCEPTION
3509: WHEN OTHERS THEN
3510: x_result:=0;
3511: print_debuginfo('Exception occured while updating the mandate:' ||
3512: sqlerrm,iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
3513:
3514: print_debuginfo('End:',iby_debug_pub.G_LEVEL_PROCEDURE,l_dbg_mod);
3515: END;
3516:

Line 3514: print_debuginfo('End:',iby_debug_pub.G_LEVEL_PROCEDURE,l_dbg_mod);

3510: x_result:=0;
3511: print_debuginfo('Exception occured while updating the mandate:' ||
3512: sqlerrm,iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
3513:
3514: print_debuginfo('End:',iby_debug_pub.G_LEVEL_PROCEDURE,l_dbg_mod);
3515: END;
3516:
3517: END IBY_FNDCPT_SETUP_PUB;