APPS.ASO_PAYMENT_DATA_MIGRATION_PVT dependencies on IBY_CREDITCARD

Line 371: fnd_file.put_line(FND_FILE.OUTPUT, 'Before insering into table IBY_CREDITCARD');

367:
368:
369: BEGIN -- begin1
370:
371: fnd_file.put_line(FND_FILE.OUTPUT, 'Before insering into table IBY_CREDITCARD');
372:
373: -- create new credit cards with single use only
374: FORALL i IN payment_id_tab.first..payment_id_tab.last SAVE EXCEPTIONS
375:

Line 376: INSERT INTO IBY_CREDITCARD( CARD_OWNER_ID,

372:
373: -- create new credit cards with single use only
374: FORALL i IN payment_id_tab.first..payment_id_tab.last SAVE EXCEPTIONS
375:
376: INSERT INTO IBY_CREDITCARD( CARD_OWNER_ID,
377: INSTRUMENT_TYPE,
378: PURCHASECARD_FLAG,
379: CARD_ISSUER_CODE,
380: ACTIVE_FLAG,

Line 429: fnd_file.put_line(FND_FILE.OUTPUT, 'After insering into table IBY_CREDITCARD');

425: cc_number_length_tab(i),
426: masked_cc_number_tab(i),
427: 1
428: );
429: fnd_file.put_line(FND_FILE.OUTPUT, 'After insering into table IBY_CREDITCARD');
430:
431: EXCEPTION
432:
433: WHEN OTHERS THEN

Line 441: fnd_file.put_line(FND_FILE.OUTPUT, 'Insert failing at IBY_CREDITCARD for Payment ID ' || payment_id_tab(j));

437:
438: fnd_file.put_line(FND_FILE.OUTPUT, 'Error occurred during iteration ' || SQL%BULK_EXCEPTIONS(j).ERROR_INDEX ||
439: ' Oracle error is ' || SQL%BULK_EXCEPTIONS(j).ERROR_CODE );
440:
441: fnd_file.put_line(FND_FILE.OUTPUT, 'Insert failing at IBY_CREDITCARD for Payment ID ' || payment_id_tab(j));
442: END LOOP;
443:
444: END; --end begin1
445:

Line 647: fnd_file.put_line(FND_FILE.OUTPUT, 'Before insering into table IBY_CREDITCARD');

643:
644: BEGIN --begin4
645: -- create new credit cards with single use only
646:
647: fnd_file.put_line(FND_FILE.OUTPUT, 'Before insering into table IBY_CREDITCARD');
648:
649: FORALL i IN payment_id_tab.first..payment_id_tab.last SAVE EXCEPTIONS
650:
651: INSERT INTO IBY_CREDITCARD( CARD_OWNER_ID,

Line 651: INSERT INTO IBY_CREDITCARD( CARD_OWNER_ID,

647: fnd_file.put_line(FND_FILE.OUTPUT, 'Before insering into table IBY_CREDITCARD');
648:
649: FORALL i IN payment_id_tab.first..payment_id_tab.last SAVE EXCEPTIONS
650:
651: INSERT INTO IBY_CREDITCARD( CARD_OWNER_ID,
652: INSTRUMENT_TYPE,
653: PURCHASECARD_FLAG,
654: CARD_ISSUER_CODE,
655: ACTIVE_FLAG,

Line 707: fnd_file.put_line(FND_FILE.OUTPUT, 'After insering into table IBY_CREDITCARD');

703: masked_cc_number_tab(i),
704: 1
705: );
706:
707: fnd_file.put_line(FND_FILE.OUTPUT, 'After insering into table IBY_CREDITCARD');
708:
709: EXCEPTION
710:
711: WHEN OTHERS THEN

Line 719: fnd_file.put_line(FND_FILE.OUTPUT, 'Insert failing at IBY_CREDITCARD for Payment ID ' || payment_id_tab(j));

715:
716: fnd_file.put_line(FND_FILE.OUTPUT, 'Error occurred during iteration ' || SQL%BULK_EXCEPTIONS(j).ERROR_INDEX ||
717: ' Oracle error is ' || SQL%BULK_EXCEPTIONS(j).ERROR_CODE );
718:
719: fnd_file.put_line(FND_FILE.OUTPUT, 'Insert failing at IBY_CREDITCARD for Payment ID ' || payment_id_tab(j));
720: END LOOP;
721:
722: END; --end4
723: