444: FROM JA_CN_VOUCHER_NUMBER
445: WHERE PERIOD_NAME = v_row.period_name
446: AND REQUEST_ID = fnd_global.CONC_REQUEST_ID);
447: IF (JOURNAL_AMOUNT <> 0) THEN
448: Fnd_Message.Set_Name(Application => 'JA',
449: NAME => 'JA_CN_VOUCHER_NUM_MIG_HAS_DATA');
450: Fnd_Message.SET_TOKEN(TOKEN => 'PERIOD_NAME',
451: VALUE => v_row.period_name);
452: Fnd_Message.SET_TOKEN(TOKEN => 'VOUCHER_NUMBER_FROM',
446: AND REQUEST_ID = fnd_global.CONC_REQUEST_ID);
447: IF (JOURNAL_AMOUNT <> 0) THEN
448: Fnd_Message.Set_Name(Application => 'JA',
449: NAME => 'JA_CN_VOUCHER_NUM_MIG_HAS_DATA');
450: Fnd_Message.SET_TOKEN(TOKEN => 'PERIOD_NAME',
451: VALUE => v_row.period_name);
452: Fnd_Message.SET_TOKEN(TOKEN => 'VOUCHER_NUMBER_FROM',
453: VALUE => VOUCHER_NUMBER_FROM);
454: Fnd_Message.SET_TOKEN(TOKEN => 'VOUCHER_NUMBER_TO',
448: Fnd_Message.Set_Name(Application => 'JA',
449: NAME => 'JA_CN_VOUCHER_NUM_MIG_HAS_DATA');
450: Fnd_Message.SET_TOKEN(TOKEN => 'PERIOD_NAME',
451: VALUE => v_row.period_name);
452: Fnd_Message.SET_TOKEN(TOKEN => 'VOUCHER_NUMBER_FROM',
453: VALUE => VOUCHER_NUMBER_FROM);
454: Fnd_Message.SET_TOKEN(TOKEN => 'VOUCHER_NUMBER_TO',
455: VALUE => VOUCHER_NUMBER_TO);
456: Fnd_Message.SET_TOKEN(TOKEN => 'MIGRATED_JOURNAL_AMOUNT',
450: Fnd_Message.SET_TOKEN(TOKEN => 'PERIOD_NAME',
451: VALUE => v_row.period_name);
452: Fnd_Message.SET_TOKEN(TOKEN => 'VOUCHER_NUMBER_FROM',
453: VALUE => VOUCHER_NUMBER_FROM);
454: Fnd_Message.SET_TOKEN(TOKEN => 'VOUCHER_NUMBER_TO',
455: VALUE => VOUCHER_NUMBER_TO);
456: Fnd_Message.SET_TOKEN(TOKEN => 'MIGRATED_JOURNAL_AMOUNT',
457: VALUE => JOURNAL_AMOUNT);
458: l_Error_Msg := Fnd_Message.Get;
452: Fnd_Message.SET_TOKEN(TOKEN => 'VOUCHER_NUMBER_FROM',
453: VALUE => VOUCHER_NUMBER_FROM);
454: Fnd_Message.SET_TOKEN(TOKEN => 'VOUCHER_NUMBER_TO',
455: VALUE => VOUCHER_NUMBER_TO);
456: Fnd_Message.SET_TOKEN(TOKEN => 'MIGRATED_JOURNAL_AMOUNT',
457: VALUE => JOURNAL_AMOUNT);
458: l_Error_Msg := Fnd_Message.Get;
459:
460: --Output error message
454: Fnd_Message.SET_TOKEN(TOKEN => 'VOUCHER_NUMBER_TO',
455: VALUE => VOUCHER_NUMBER_TO);
456: Fnd_Message.SET_TOKEN(TOKEN => 'MIGRATED_JOURNAL_AMOUNT',
457: VALUE => JOURNAL_AMOUNT);
458: l_Error_Msg := Fnd_Message.Get;
459:
460: --Output error message
461: Fnd_File.Put_Line(Fnd_File.Output, l_Error_Msg);
462: HAS_DATA_TAG := 'Y';
462: HAS_DATA_TAG := 'Y';
463: END IF;
464: END LOOP; -- FOR v_row IN periods_cur
465: IF (HAS_DATA_TAG = 'N') THEN
466: Fnd_Message.Set_Name(Application => 'JA',
467: NAME => 'JA_CN_VOUCHER_NUM_MIG_NO_DATA');
468: l_Error_Msg := Fnd_Message.Get;
469:
470: --Output error message
464: END LOOP; -- FOR v_row IN periods_cur
465: IF (HAS_DATA_TAG = 'N') THEN
466: Fnd_Message.Set_Name(Application => 'JA',
467: NAME => 'JA_CN_VOUCHER_NUM_MIG_NO_DATA');
468: l_Error_Msg := Fnd_Message.Get;
469:
470: --Output error message
471: Fnd_File.Put_Line(Fnd_File.Output, l_Error_Msg);
472: END IF;