APPS.CE_CASH_FCST dependencies on CE_FORECAST_ERRORS_PKG

Line 458: CE_FORECAST_ERRORS_PKG.insert_row(G_forecast_id,

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;
462: END LOOP;

Line 481: CE_FORECAST_ERRORS_PKG.insert_row(G_forecast_id,

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;
485: CLOSE bad_curr;

Line 591: CE_FORECAST_ERRORS_PKG.insert_row(G_forecast_id,

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;
595: END IF;

Line 673: CE_FORECAST_ERRORS_PKG.insert_row(G_forecast_id,

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;
677: END;

Line 692: CE_FORECAST_ERRORS_PKG.insert_row(G_forecast_id,

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;
696: END LOOP;

Line 822: CE_FORECAST_ERRORS_PKG.insert_row(G_forecast_id,G_rp_forecast_header_id, G_forecast_row_id,

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
826: open sob_c;

Line 837: CE_FORECAST_ERRORS_PKG.insert_row(G_forecast_id,G_rp_forecast_header_id, G_forecast_row_id,

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;
841: END IF;

Line 883: CE_FORECAST_ERRORS_PKG.insert_row(G_forecast_id,G_rp_forecast_header_id, null,

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;
887:

Line 940: CE_FORECAST_ERRORS_PKG.insert_row(G_forecast_id,G_rp_forecast_header_id,

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:
944: IF(col_num = 0 AND days_to < G_min_col )THEN

Line 1036: CE_FORECAST_ERRORS_PKG.insert_row(G_forecast_id,G_rp_forecast_header_id, null,

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;
1040:

Line 1310: CE_FORECAST_ERRORS_PKG.insert_row(G_forecast_id,G_rp_forecast_header_id,

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'
1314: WHERE forecast_id = G_forecast_id;

Line 1358: CE_FORECAST_ERRORS_PKG.insert_row(G_forecast_id,G_rp_forecast_header_id, null,

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:
1362: return valid_pmr;

Line 1709: CE_FORECAST_ERRORS_PKG.insert_row(p_forecast_id,p_forecast_header_id,

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'
1713: WHERE forecast_id = p_forecast_id;

Line 1868: CE_FORECAST_ERRORS_PKG.insert_row(p_forecast_id,p_forecast_header_id,

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'
1872: WHERE forecast_id = p_forecast_id;