198: v_FoundBadChar BOOLEAN :=FALSE;
199: l_DBUG_MOD VARCHAR2(100) :='IBY_CC_VALIDATE.Get_CC_Issuer_Range(6 params)';
200: BEGIN
201:
202: iby_debug_pub.add('Enter',FND_LOG.LEVEL_STATEMENT,l_DBUG_MOD);
203:
204: FOR v_Counter IN 1..LENGTH(p_cc_id) LOOP
205: --
206: -- tests if a character is a digit
218: END IF;
219: END LOOP;
220:
221: IF v_FoundBadChar THEN
222: iby_debug_pub.add('Found bad char',FND_LOG.LEVEL_STATEMENT,l_DBUG_MOD);
223:
224: RETURN NULL;
225: ELSE
226: RETURN v_StrippedCC;
224: RETURN NULL;
225: ELSE
226: RETURN v_StrippedCC;
227: END IF;
228: iby_debug_pub.add('Exit',FND_LOG.LEVEL_STATEMENT,l_DBUG_MOD);
229:
230:
231: EXCEPTION
232: WHEN OTHERS THEN
229:
230:
231: EXCEPTION
232: WHEN OTHERS THEN
233: iby_debug_pub.add('In Others Exception',FND_LOG.LEVEL_UNEXPECTED, l_DBUG_MOD);
234: iby_debug_pub.add('Exception code='||SQLCODE,FND_LOG.LEVEL_UNEXPECTED,l_DBUG_MOD);
235: iby_debug_pub.add('Exception message='||SQLERRM,FND_LOG.LEVEL_UNEXPECTED,l_DBUG_MOD);
236:
237:
230:
231: EXCEPTION
232: WHEN OTHERS THEN
233: iby_debug_pub.add('In Others Exception',FND_LOG.LEVEL_UNEXPECTED, l_DBUG_MOD);
234: iby_debug_pub.add('Exception code='||SQLCODE,FND_LOG.LEVEL_UNEXPECTED,l_DBUG_MOD);
235: iby_debug_pub.add('Exception message='||SQLERRM,FND_LOG.LEVEL_UNEXPECTED,l_DBUG_MOD);
236:
237:
238: END StripCC;
231: EXCEPTION
232: WHEN OTHERS THEN
233: iby_debug_pub.add('In Others Exception',FND_LOG.LEVEL_UNEXPECTED, l_DBUG_MOD);
234: iby_debug_pub.add('Exception code='||SQLCODE,FND_LOG.LEVEL_UNEXPECTED,l_DBUG_MOD);
235: iby_debug_pub.add('Exception message='||SQLERRM,FND_LOG.LEVEL_UNEXPECTED,l_DBUG_MOD);
236:
237:
238: END StripCC;
239:
408: l_DBUG_MOD VARCHAR2(100) :='IBY_CC_VALIDATE.Get_CC_Issuer_Range(5 params)';
409:
410: BEGIN
411:
412: iby_debug_pub.add('Enter',FND_LOG.LEVEL_STATEMENT,l_DBUG_MOD);
413:
414: iby_debug_pub.add('Calling Get_CC_Issuer_Range (6 params)',FND_LOG.LEVEL_STATEMENT,l_DBUG_MOD);
415:
416: Get_CC_Issuer_Range(p_card_number,x_card_issuer,x_issuer_range,x_card_prefix,x_digit_check,null);
410: BEGIN
411:
412: iby_debug_pub.add('Enter',FND_LOG.LEVEL_STATEMENT,l_DBUG_MOD);
413:
414: iby_debug_pub.add('Calling Get_CC_Issuer_Range (6 params)',FND_LOG.LEVEL_STATEMENT,l_DBUG_MOD);
415:
416: Get_CC_Issuer_Range(p_card_number,x_card_issuer,x_issuer_range,x_card_prefix,x_digit_check,null);
417:
418: iby_debug_pub.add('Exit',FND_LOG.LEVEL_STATEMENT,l_DBUG_MOD);
414: iby_debug_pub.add('Calling Get_CC_Issuer_Range (6 params)',FND_LOG.LEVEL_STATEMENT,l_DBUG_MOD);
415:
416: Get_CC_Issuer_Range(p_card_number,x_card_issuer,x_issuer_range,x_card_prefix,x_digit_check,null);
417:
418: iby_debug_pub.add('Exit',FND_LOG.LEVEL_STATEMENT,l_DBUG_MOD);
419:
420: END Get_CC_Issuer_Range;
421: --Bug 8581161: FP:8352320
422: PROCEDURE Get_CC_Issuer_Range
447: ORDER BY r.last_updated_by DESC,
448: r.last_update_date DESC;
449:
450: BEGIN
451: iby_debug_pub.add('Enter',FND_LOG.LEVEL_STATEMENT,l_DBUG_MOD);
452:
453: IF (c_range%ISOPEN) THEN CLOSE c_range; END IF;
454:
455: l_cc_number :=
478: x_card_issuer := 'UNKNOWN';
479: x_digit_check := 'N';
480: END IF;
481:
482: iby_debug_pub.add('Exit',FND_LOG.LEVEL_STATEMENT,l_DBUG_MOD);
483:
484: EXCEPTION
485: WHEN OTHERS THEN
486: iby_debug_pub.add('In Others Exception',FND_LOG.LEVEL_UNEXPECTED, l_DBUG_MOD);
482: iby_debug_pub.add('Exit',FND_LOG.LEVEL_STATEMENT,l_DBUG_MOD);
483:
484: EXCEPTION
485: WHEN OTHERS THEN
486: iby_debug_pub.add('In Others Exception',FND_LOG.LEVEL_UNEXPECTED, l_DBUG_MOD);
487: iby_debug_pub.add('Exception code='||SQLCODE,FND_LOG.LEVEL_UNEXPECTED,l_DBUG_MOD);
488: iby_debug_pub.add('Exception message='||SQLERRM,FND_LOG.LEVEL_UNEXPECTED,l_DBUG_MOD);
489:
490:
483:
484: EXCEPTION
485: WHEN OTHERS THEN
486: iby_debug_pub.add('In Others Exception',FND_LOG.LEVEL_UNEXPECTED, l_DBUG_MOD);
487: iby_debug_pub.add('Exception code='||SQLCODE,FND_LOG.LEVEL_UNEXPECTED,l_DBUG_MOD);
488: iby_debug_pub.add('Exception message='||SQLERRM,FND_LOG.LEVEL_UNEXPECTED,l_DBUG_MOD);
489:
490:
491:
484: EXCEPTION
485: WHEN OTHERS THEN
486: iby_debug_pub.add('In Others Exception',FND_LOG.LEVEL_UNEXPECTED, l_DBUG_MOD);
487: iby_debug_pub.add('Exception code='||SQLCODE,FND_LOG.LEVEL_UNEXPECTED,l_DBUG_MOD);
488: iby_debug_pub.add('Exception message='||SQLERRM,FND_LOG.LEVEL_UNEXPECTED,l_DBUG_MOD);
489:
490:
491:
492: END Get_CC_Issuer_Range;