DBA Data[Home] [Help]

APPS.CE_CASH_FCST dependencies on FND_MESSAGE

Line 453: FND_MESSAGE.set_name ('CE','CE_FC_MISSING_EXCHANGE_RATE');

449: -- WHEN NO_RATE THEN
450: -- bug 1200912
451: IF (curr = CE_CASH_FCST.G_rp_src_currency) THEN
452: all_exist_flag := FALSE;
453: FND_MESSAGE.set_name ('CE','CE_FC_MISSING_EXCHANGE_RATE');
454: FND_MESSAGE.set_token('FROM_CURR', curr);
455: FND_MESSAGE.set_token('TO_CURR',
456: CE_CASH_FCST.G_rp_forecast_currency);
457: error_msg := FND_MESSAGE.GET;

Line 454: FND_MESSAGE.set_token('FROM_CURR', curr);

450: -- bug 1200912
451: IF (curr = CE_CASH_FCST.G_rp_src_currency) THEN
452: all_exist_flag := FALSE;
453: FND_MESSAGE.set_name ('CE','CE_FC_MISSING_EXCHANGE_RATE');
454: FND_MESSAGE.set_token('FROM_CURR', curr);
455: FND_MESSAGE.set_token('TO_CURR',
456: CE_CASH_FCST.G_rp_forecast_currency);
457: error_msg := FND_MESSAGE.GET;
458: CE_FORECAST_ERRORS_PKG.insert_row(G_forecast_id,

Line 455: FND_MESSAGE.set_token('TO_CURR',

451: IF (curr = CE_CASH_FCST.G_rp_src_currency) THEN
452: all_exist_flag := FALSE;
453: FND_MESSAGE.set_name ('CE','CE_FC_MISSING_EXCHANGE_RATE');
454: FND_MESSAGE.set_token('FROM_CURR', curr);
455: FND_MESSAGE.set_token('TO_CURR',
456: CE_CASH_FCST.G_rp_forecast_currency);
457: error_msg := FND_MESSAGE.GET;
458: CE_FORECAST_ERRORS_PKG.insert_row(G_forecast_id,
459: G_rp_forecast_header_id, null,'CE_FC_MISSING_RATE', error_msg);

Line 457: error_msg := FND_MESSAGE.GET;

453: FND_MESSAGE.set_name ('CE','CE_FC_MISSING_EXCHANGE_RATE');
454: FND_MESSAGE.set_token('FROM_CURR', curr);
455: FND_MESSAGE.set_token('TO_CURR',
456: CE_CASH_FCST.G_rp_forecast_currency);
457: error_msg := FND_MESSAGE.GET;
458: CE_FORECAST_ERRORS_PKG.insert_row(G_forecast_id,
459: G_rp_forecast_header_id, null,'CE_FC_MISSING_RATE', error_msg);
460: END IF;
461: END;

Line 478: FND_MESSAGE.set_name ('CE','CE_FC_BAD_CURRENCY');

474: FETCH bad_curr INTO curr;
475: EXIT WHEN (bad_curr%NOTFOUND OR bad_curr%NOTFOUND IS NULL);
476: BEGIN
477: all_exist_flag := FALSE;
478: FND_MESSAGE.set_name ('CE','CE_FC_BAD_CURRENCY');
479: FND_MESSAGE.set_token('BAD_CURR', curr);
480: error_msg := FND_MESSAGE.GET;
481: CE_FORECAST_ERRORS_PKG.insert_row(G_forecast_id,
482: G_rp_forecast_header_id, null,'CE_FC_BAD_CURRENCY', error_msg);

Line 479: FND_MESSAGE.set_token('BAD_CURR', curr);

475: EXIT WHEN (bad_curr%NOTFOUND OR bad_curr%NOTFOUND IS NULL);
476: BEGIN
477: all_exist_flag := FALSE;
478: FND_MESSAGE.set_name ('CE','CE_FC_BAD_CURRENCY');
479: FND_MESSAGE.set_token('BAD_CURR', curr);
480: error_msg := FND_MESSAGE.GET;
481: CE_FORECAST_ERRORS_PKG.insert_row(G_forecast_id,
482: G_rp_forecast_header_id, null,'CE_FC_BAD_CURRENCY', error_msg);
483: END;

Line 480: error_msg := FND_MESSAGE.GET;

476: BEGIN
477: all_exist_flag := FALSE;
478: FND_MESSAGE.set_name ('CE','CE_FC_BAD_CURRENCY');
479: FND_MESSAGE.set_token('BAD_CURR', curr);
480: error_msg := FND_MESSAGE.GET;
481: CE_FORECAST_ERRORS_PKG.insert_row(G_forecast_id,
482: G_rp_forecast_header_id, null,'CE_FC_BAD_CURRENCY', error_msg);
483: END;
484: END LOOP;

Line 589: FND_MESSAGE.set_name ('CE','CE_FC_EURO_NOT_DEFINED');

585: FROM fnd_currencies
586: WHERE derive_type = 'EURO';
587: EXCEPTION
588: WHEN NO_DATA_FOUND THEN
589: FND_MESSAGE.set_name ('CE','CE_FC_EURO_NOT_DEFINED');
590: error_msg := FND_MESSAGE.GET;
591: CE_FORECAST_ERRORS_PKG.insert_row(G_forecast_id,
592: G_rp_forecast_header_id, null,'CE_FC_EURO_NOT_DEFINED',
593: error_msg);

Line 590: error_msg := FND_MESSAGE.GET;

586: WHERE derive_type = 'EURO';
587: EXCEPTION
588: WHEN NO_DATA_FOUND THEN
589: FND_MESSAGE.set_name ('CE','CE_FC_EURO_NOT_DEFINED');
590: error_msg := FND_MESSAGE.GET;
591: CE_FORECAST_ERRORS_PKG.insert_row(G_forecast_id,
592: G_rp_forecast_header_id, null,'CE_FC_EURO_NOT_DEFINED',
593: error_msg);
594: END;

Line 669: FND_MESSAGE.set_name ('CE','CE_FC_MISSING_EXCHANGE_RATE');

665: END IF;
666:
667: IF skip_err_log = FALSE THEN
668: all_exist_flag := FALSE;
669: FND_MESSAGE.set_name ('CE','CE_FC_MISSING_EXCHANGE_RATE');
670: FND_MESSAGE.set_token('FROM_CURR', from_curr);
671: FND_MESSAGE.set_token('TO_CURR',to_curr);
672: error_msg := FND_MESSAGE.GET;
673: CE_FORECAST_ERRORS_PKG.insert_row(G_forecast_id,

Line 670: FND_MESSAGE.set_token('FROM_CURR', from_curr);

666:
667: IF skip_err_log = FALSE THEN
668: all_exist_flag := FALSE;
669: FND_MESSAGE.set_name ('CE','CE_FC_MISSING_EXCHANGE_RATE');
670: FND_MESSAGE.set_token('FROM_CURR', from_curr);
671: FND_MESSAGE.set_token('TO_CURR',to_curr);
672: error_msg := FND_MESSAGE.GET;
673: CE_FORECAST_ERRORS_PKG.insert_row(G_forecast_id,
674: G_rp_forecast_header_id, null,'CE_FC_MISSING_RATE',

Line 671: FND_MESSAGE.set_token('TO_CURR',to_curr);

667: IF skip_err_log = FALSE THEN
668: all_exist_flag := FALSE;
669: FND_MESSAGE.set_name ('CE','CE_FC_MISSING_EXCHANGE_RATE');
670: FND_MESSAGE.set_token('FROM_CURR', from_curr);
671: FND_MESSAGE.set_token('TO_CURR',to_curr);
672: error_msg := FND_MESSAGE.GET;
673: CE_FORECAST_ERRORS_PKG.insert_row(G_forecast_id,
674: G_rp_forecast_header_id, null,'CE_FC_MISSING_RATE',
675: error_msg);

Line 672: error_msg := FND_MESSAGE.GET;

668: all_exist_flag := FALSE;
669: FND_MESSAGE.set_name ('CE','CE_FC_MISSING_EXCHANGE_RATE');
670: FND_MESSAGE.set_token('FROM_CURR', from_curr);
671: FND_MESSAGE.set_token('TO_CURR',to_curr);
672: error_msg := FND_MESSAGE.GET;
673: CE_FORECAST_ERRORS_PKG.insert_row(G_forecast_id,
674: G_rp_forecast_header_id, null,'CE_FC_MISSING_RATE',
675: error_msg);
676: END IF;

Line 689: FND_MESSAGE.set_name ('CE','CE_FC_BAD_CURRENCY');

685: BEGIN
686: all_exist_flag := FALSE;
687: IF (G_rp_src_curr_type = 'A'
688: OR curr = CE_CASH_FCST.G_rp_src_currency) THEN
689: FND_MESSAGE.set_name ('CE','CE_FC_BAD_CURRENCY');
690: FND_MESSAGE.set_token('BAD_CURR', curr);
691: error_msg := FND_MESSAGE.GET;
692: CE_FORECAST_ERRORS_PKG.insert_row(G_forecast_id,
693: G_rp_forecast_header_id, null,'CE_FC_BAD_CURRENCY', error_msg);

Line 690: FND_MESSAGE.set_token('BAD_CURR', curr);

686: all_exist_flag := FALSE;
687: IF (G_rp_src_curr_type = 'A'
688: OR curr = CE_CASH_FCST.G_rp_src_currency) THEN
689: FND_MESSAGE.set_name ('CE','CE_FC_BAD_CURRENCY');
690: FND_MESSAGE.set_token('BAD_CURR', curr);
691: error_msg := FND_MESSAGE.GET;
692: CE_FORECAST_ERRORS_PKG.insert_row(G_forecast_id,
693: G_rp_forecast_header_id, null,'CE_FC_BAD_CURRENCY', error_msg);
694: END IF;

Line 691: error_msg := FND_MESSAGE.GET;

687: IF (G_rp_src_curr_type = 'A'
688: OR curr = CE_CASH_FCST.G_rp_src_currency) THEN
689: FND_MESSAGE.set_name ('CE','CE_FC_BAD_CURRENCY');
690: FND_MESSAGE.set_token('BAD_CURR', curr);
691: error_msg := FND_MESSAGE.GET;
692: CE_FORECAST_ERRORS_PKG.insert_row(G_forecast_id,
693: G_rp_forecast_header_id, null,'CE_FC_BAD_CURRENCY', error_msg);
694: END IF;
695: END;

Line 818: FND_MESSAGE.set_name('CE', 'CE_FC_INVALID_PERIOD_SET_NAME');

814: WHERE gsb.set_of_books_id = G_set_of_books_id;
815:
816: IF (calendar <> G_rp_calendar_name) THEN
817: valid_period := FALSE;
818: FND_MESSAGE.set_name('CE', 'CE_FC_INVALID_PERIOD_SET_NAME');
819: FND_MESSAGE.set_token('SOB_NAME', sob_name);
820: FND_MESSAGE.set_token('START_PERIOD', G_rp_calendar_name);
821: error_msg := fnd_message.get;
822: CE_FORECAST_ERRORS_PKG.insert_row(G_forecast_id,G_rp_forecast_header_id, G_forecast_row_id,

Line 819: FND_MESSAGE.set_token('SOB_NAME', sob_name);

815:
816: IF (calendar <> G_rp_calendar_name) THEN
817: valid_period := FALSE;
818: FND_MESSAGE.set_name('CE', 'CE_FC_INVALID_PERIOD_SET_NAME');
819: FND_MESSAGE.set_token('SOB_NAME', sob_name);
820: FND_MESSAGE.set_token('START_PERIOD', G_rp_calendar_name);
821: error_msg := fnd_message.get;
822: CE_FORECAST_ERRORS_PKG.insert_row(G_forecast_id,G_rp_forecast_header_id, G_forecast_row_id,
823: 'CE_FC_INVALID_PERIOD', error_msg);

Line 820: FND_MESSAGE.set_token('START_PERIOD', G_rp_calendar_name);

816: IF (calendar <> G_rp_calendar_name) THEN
817: valid_period := FALSE;
818: FND_MESSAGE.set_name('CE', 'CE_FC_INVALID_PERIOD_SET_NAME');
819: FND_MESSAGE.set_token('SOB_NAME', sob_name);
820: FND_MESSAGE.set_token('START_PERIOD', G_rp_calendar_name);
821: error_msg := fnd_message.get;
822: CE_FORECAST_ERRORS_PKG.insert_row(G_forecast_id,G_rp_forecast_header_id, G_forecast_row_id,
823: 'CE_FC_INVALID_PERIOD', error_msg);
824: END IF;

Line 821: error_msg := fnd_message.get;

817: valid_period := FALSE;
818: FND_MESSAGE.set_name('CE', 'CE_FC_INVALID_PERIOD_SET_NAME');
819: FND_MESSAGE.set_token('SOB_NAME', sob_name);
820: FND_MESSAGE.set_token('START_PERIOD', G_rp_calendar_name);
821: error_msg := fnd_message.get;
822: CE_FORECAST_ERRORS_PKG.insert_row(G_forecast_id,G_rp_forecast_header_id, G_forecast_row_id,
823: 'CE_FC_INVALID_PERIOD', error_msg);
824: END IF;
825: ELSE

Line 833: FND_MESSAGE.set_name('CE', 'CE_FC_INVALID_PERIOD_SET_NAME');

829: EXIT WHEN sob_c%NOTFOUND or sob_c%NOTFOUND IS NULL;
830:
831: IF (calendar <> G_rp_calendar_name) THEN
832: valid_period := FALSE;
833: FND_MESSAGE.set_name('CE', 'CE_FC_INVALID_PERIOD_SET_NAME');
834: FND_MESSAGE.set_token('SOB_NAME', sob_name);
835: FND_MESSAGE.set_token('START_PERIOD', G_rp_calendar_name);
836: error_msg := fnd_message.get;
837: CE_FORECAST_ERRORS_PKG.insert_row(G_forecast_id,G_rp_forecast_header_id, G_forecast_row_id,

Line 834: FND_MESSAGE.set_token('SOB_NAME', sob_name);

830:
831: IF (calendar <> G_rp_calendar_name) THEN
832: valid_period := FALSE;
833: FND_MESSAGE.set_name('CE', 'CE_FC_INVALID_PERIOD_SET_NAME');
834: FND_MESSAGE.set_token('SOB_NAME', sob_name);
835: FND_MESSAGE.set_token('START_PERIOD', G_rp_calendar_name);
836: error_msg := fnd_message.get;
837: CE_FORECAST_ERRORS_PKG.insert_row(G_forecast_id,G_rp_forecast_header_id, G_forecast_row_id,
838: 'CE_FC_INVALID_PERIOD', error_msg);

Line 835: FND_MESSAGE.set_token('START_PERIOD', G_rp_calendar_name);

831: IF (calendar <> G_rp_calendar_name) THEN
832: valid_period := FALSE;
833: FND_MESSAGE.set_name('CE', 'CE_FC_INVALID_PERIOD_SET_NAME');
834: FND_MESSAGE.set_token('SOB_NAME', sob_name);
835: FND_MESSAGE.set_token('START_PERIOD', G_rp_calendar_name);
836: error_msg := fnd_message.get;
837: CE_FORECAST_ERRORS_PKG.insert_row(G_forecast_id,G_rp_forecast_header_id, G_forecast_row_id,
838: 'CE_FC_INVALID_PERIOD', error_msg);
839: END IF;

Line 836: error_msg := fnd_message.get;

832: valid_period := FALSE;
833: FND_MESSAGE.set_name('CE', 'CE_FC_INVALID_PERIOD_SET_NAME');
834: FND_MESSAGE.set_token('SOB_NAME', sob_name);
835: FND_MESSAGE.set_token('START_PERIOD', G_rp_calendar_name);
836: error_msg := fnd_message.get;
837: CE_FORECAST_ERRORS_PKG.insert_row(G_forecast_id,G_rp_forecast_header_id, G_forecast_row_id,
838: 'CE_FC_INVALID_PERIOD', error_msg);
839: END IF;
840: END LOOP;

Line 881: FND_MESSAGE.set_name('CE', 'CE_FC_NO_COLUMN');

877: WHERE forecast_header_id = G_rp_forecast_header_id;
878:
879: IF (col_count = 0) THEN
880: valid_col := FALSE;
881: FND_MESSAGE.set_name('CE', 'CE_FC_NO_COLUMN');
882: error_msg := fnd_message.get;
883: CE_FORECAST_ERRORS_PKG.insert_row(G_forecast_id,G_rp_forecast_header_id, null,
884: 'CE_FC_NO_COLUMN', error_msg);
885: END IF;

Line 882: error_msg := fnd_message.get;

878:
879: IF (col_count = 0) THEN
880: valid_col := FALSE;
881: FND_MESSAGE.set_name('CE', 'CE_FC_NO_COLUMN');
882: error_msg := fnd_message.get;
883: CE_FORECAST_ERRORS_PKG.insert_row(G_forecast_id,G_rp_forecast_header_id, null,
884: 'CE_FC_NO_COLUMN', error_msg);
885: END IF;
886: END IF;

Line 937: FND_MESSAGE.set_name ('CE','CE_FC_COLUMN_NOT_IN_RANGE');

933: days_to < G_min_col OR
934: days_to > G_max_col) THEN
935:
936: all_valid := FALSE;
937: FND_MESSAGE.set_name ('CE','CE_FC_COLUMN_NOT_IN_RANGE');
938: FND_MESSAGE.set_token('COLUMN', col_num);
939: error_msg := FND_MESSAGE.GET;
940: CE_FORECAST_ERRORS_PKG.insert_row(G_forecast_id,G_rp_forecast_header_id,
941: null,'CE_FC_COLUMN_NOT_IN_RANGE', error_msg);

Line 938: FND_MESSAGE.set_token('COLUMN', col_num);

934: days_to > G_max_col) THEN
935:
936: all_valid := FALSE;
937: FND_MESSAGE.set_name ('CE','CE_FC_COLUMN_NOT_IN_RANGE');
938: FND_MESSAGE.set_token('COLUMN', col_num);
939: error_msg := FND_MESSAGE.GET;
940: CE_FORECAST_ERRORS_PKG.insert_row(G_forecast_id,G_rp_forecast_header_id,
941: null,'CE_FC_COLUMN_NOT_IN_RANGE', error_msg);
942: END IF;

Line 939: error_msg := FND_MESSAGE.GET;

935:
936: all_valid := FALSE;
937: FND_MESSAGE.set_name ('CE','CE_FC_COLUMN_NOT_IN_RANGE');
938: FND_MESSAGE.set_token('COLUMN', col_num);
939: error_msg := FND_MESSAGE.GET;
940: CE_FORECAST_ERRORS_PKG.insert_row(G_forecast_id,G_rp_forecast_header_id,
941: null,'CE_FC_COLUMN_NOT_IN_RANGE', error_msg);
942: END IF;
943:

Line 1034: FND_MESSAGE.set_name('CE', 'CE_FC_NO_ROW');

1030:
1031: IF (NOT G_gl_cash_only) THEN
1032:
1033: valid_row := FALSE;
1034: FND_MESSAGE.set_name('CE', 'CE_FC_NO_ROW');
1035: error_msg := fnd_message.get;
1036: CE_FORECAST_ERRORS_PKG.insert_row(G_forecast_id,G_rp_forecast_header_id, null,
1037: 'CE_FC_NO_ROW', error_msg);
1038: END IF;

Line 1035: error_msg := fnd_message.get;

1031: IF (NOT G_gl_cash_only) THEN
1032:
1033: valid_row := FALSE;
1034: FND_MESSAGE.set_name('CE', 'CE_FC_NO_ROW');
1035: error_msg := fnd_message.get;
1036: CE_FORECAST_ERRORS_PKG.insert_row(G_forecast_id,G_rp_forecast_header_id, null,
1037: 'CE_FC_NO_ROW', error_msg);
1038: END IF;
1039: END IF;

Line 1308: FND_MESSAGE.set_name ('CE','CE_FC_DUPLICATE_FORECAST_NAME');

1304: commit;
1305: END IF;
1306:
1307: IF(duplicate_name)THEN
1308: FND_MESSAGE.set_name ('CE','CE_FC_DUPLICATE_FORECAST_NAME');
1309: error_msg := FND_MESSAGE.GET;
1310: CE_FORECAST_ERRORS_PKG.insert_row(G_forecast_id,G_rp_forecast_header_id,
1311: null,'CE_FC_DUPLICATE_FORECAST_NAME', error_msg);
1312: UPDATE ce_forecasts

Line 1309: error_msg := FND_MESSAGE.GET;

1305: END IF;
1306:
1307: IF(duplicate_name)THEN
1308: FND_MESSAGE.set_name ('CE','CE_FC_DUPLICATE_FORECAST_NAME');
1309: error_msg := FND_MESSAGE.GET;
1310: CE_FORECAST_ERRORS_PKG.insert_row(G_forecast_id,G_rp_forecast_header_id,
1311: null,'CE_FC_DUPLICATE_FORECAST_NAME', error_msg);
1312: UPDATE ce_forecasts
1313: SET error_status = 'X'

Line 1356: FND_MESSAGE.set_name('CE', 'CE_FC_PMR_MISSING_XINFO');

1352: valid_pmr := FALSE;
1353: END IF;
1354:
1355: IF(not valid_pmr)THEN
1356: FND_MESSAGE.set_name('CE', 'CE_FC_PMR_MISSING_XINFO');
1357: error_msg := fnd_message.get;
1358: CE_FORECAST_ERRORS_PKG.insert_row(G_forecast_id,G_rp_forecast_header_id, null,
1359: 'CE_FC_PMR_MISSING_XINFO', error_msg);
1360: END IF;

Line 1357: error_msg := fnd_message.get;

1353: END IF;
1354:
1355: IF(not valid_pmr)THEN
1356: FND_MESSAGE.set_name('CE', 'CE_FC_PMR_MISSING_XINFO');
1357: error_msg := fnd_message.get;
1358: CE_FORECAST_ERRORS_PKG.insert_row(G_forecast_id,G_rp_forecast_header_id, null,
1359: 'CE_FC_PMR_MISSING_XINFO', error_msg);
1360: END IF;
1361:

Line 1707: FND_MESSAGE.set_name ('CE','CE_FC_DUPLICATE_FORECAST_NAME');

1703: AND error_status = 'P';
1704: commit;
1705:
1706: IF (p_fc_name_exists = 'Y') THEN
1707: FND_MESSAGE.set_name ('CE','CE_FC_DUPLICATE_FORECAST_NAME');
1708: error_msg := FND_MESSAGE.GET;
1709: CE_FORECAST_ERRORS_PKG.insert_row(p_forecast_id,p_forecast_header_id,
1710: null,'CE_FC_DUPLICATE_FORECAST_NAME', error_msg);
1711: UPDATE ce_forecasts

Line 1708: error_msg := FND_MESSAGE.GET;

1704: commit;
1705:
1706: IF (p_fc_name_exists = 'Y') THEN
1707: FND_MESSAGE.set_name ('CE','CE_FC_DUPLICATE_FORECAST_NAME');
1708: error_msg := FND_MESSAGE.GET;
1709: CE_FORECAST_ERRORS_PKG.insert_row(p_forecast_id,p_forecast_header_id,
1710: null,'CE_FC_DUPLICATE_FORECAST_NAME', error_msg);
1711: UPDATE ce_forecasts
1712: SET error_status = 'X'

Line 1866: FND_MESSAGE.set_name ('CE','CE_FC_DUPLICATE_FORECAST_NAME');

1862: AND error_status = 'P';
1863: commit;
1864:
1865: IF (p_fc_name_exists = 'Y') THEN
1866: FND_MESSAGE.set_name ('CE','CE_FC_DUPLICATE_FORECAST_NAME');
1867: error_msg := FND_MESSAGE.GET;
1868: CE_FORECAST_ERRORS_PKG.insert_row(p_forecast_id,p_forecast_header_id,
1869: null,'CE_FC_DUPLICATE_FORECAST_NAME', error_msg);
1870: UPDATE ce_forecasts

Line 1867: error_msg := FND_MESSAGE.GET;

1863: commit;
1864:
1865: IF (p_fc_name_exists = 'Y') THEN
1866: FND_MESSAGE.set_name ('CE','CE_FC_DUPLICATE_FORECAST_NAME');
1867: error_msg := FND_MESSAGE.GET;
1868: CE_FORECAST_ERRORS_PKG.insert_row(p_forecast_id,p_forecast_header_id,
1869: null,'CE_FC_DUPLICATE_FORECAST_NAME', error_msg);
1870: UPDATE ce_forecasts
1871: SET error_status = 'X'