DBA Data[Home] [Help]

APPS.IBY_CC_VALIDATE dependencies on FND_LOG

Line 202: iby_debug_pub.add('Enter',FND_LOG.LEVEL_STATEMENT,l_DBUG_MOD);

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

Line 222: iby_debug_pub.add('Found bad char',FND_LOG.LEVEL_STATEMENT,l_DBUG_MOD);

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;

Line 228: iby_debug_pub.add('Exit',FND_LOG.LEVEL_STATEMENT,l_DBUG_MOD);

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

Line 233: iby_debug_pub.add('In Others Exception',FND_LOG.LEVEL_UNEXPECTED, l_DBUG_MOD);

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:

Line 234: iby_debug_pub.add('Exception code='||SQLCODE,FND_LOG.LEVEL_UNEXPECTED,l_DBUG_MOD);

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;

Line 235: iby_debug_pub.add('Exception message='||SQLERRM,FND_LOG.LEVEL_UNEXPECTED,l_DBUG_MOD);

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:

Line 412: iby_debug_pub.add('Enter',FND_LOG.LEVEL_STATEMENT,l_DBUG_MOD);

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

Line 414: iby_debug_pub.add('Calling Get_CC_Issuer_Range (6 params)',FND_LOG.LEVEL_STATEMENT,l_DBUG_MOD);

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

Line 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

Line 451: iby_debug_pub.add('Enter',FND_LOG.LEVEL_STATEMENT,l_DBUG_MOD);

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

Line 482: iby_debug_pub.add('Exit',FND_LOG.LEVEL_STATEMENT,l_DBUG_MOD);

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

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

Line 487: iby_debug_pub.add('Exception code='||SQLCODE,FND_LOG.LEVEL_UNEXPECTED,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:
491:

Line 488: iby_debug_pub.add('Exception message='||SQLERRM,FND_LOG.LEVEL_UNEXPECTED,l_DBUG_MOD);

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;