APPS.CE_CASH_FCST dependencies on FND_NEW_MESSAGES

Line 418: error_msg FND_NEW_MESSAGES.message_text%TYPE;

414: AND org.org_id = NVL(r.org_id, org.org_id);
415:
416: curr FND_CURRENCIES.currency_code%TYPE;
417: to_curr FND_CURRENCIES.currency_code%TYPE;
418: error_msg FND_NEW_MESSAGES.message_text%TYPE;
419: xrate NUMBER;
420: all_exist_flag BOOLEAN := TRUE;
421: BEGIN
422: cep_standard.debug('>>CE_CASH_FCST.populate_base_xrate_table');

Line 545: error_msg FND_NEW_MESSAGES.message_text%TYPE;

541: curr FND_CURRENCIES.currency_code%TYPE;
542: from_curr FND_CURRENCIES.currency_code%TYPE;
543: to_curr FND_CURRENCIES.currency_code%TYPE;
544: euro_curr FND_CURRENCIES.currency_code%TYPE;
545: error_msg FND_NEW_MESSAGES.message_text%TYPE;
546: xrate NUMBER;
547: skip_err_log BOOLEAN;
548: all_exist_flag BOOLEAN := TRUE;
549: fcast_curr_is_emu VARCHAR2(1);

Line 794: error_msg fnd_new_messages.message_text%TYPE;

790: FUNCTION valid_calendar_name RETURN BOOLEAN IS
791: valid_period BOOLEAN := TRUE;
792: sob_id GL_SETS_OF_BOOKS.set_of_books_id%TYPE;
793: calendar GL_PERIODS.period_set_name%TYPE;
794: error_msg fnd_new_messages.message_text%TYPE;
795: sob_name GL_SETS_OF_BOOKS.name%TYPE;
796:
797: CURSOR sob_c IS
798: SELECT gsb.period_set_name, org.set_of_books_id, org.set_of_books_name

Line 864: error_msg FND_NEW_MESSAGES.message_text%TYPE;

860: | HISTORY |
861: | 21-AUG-1997 Created Wynne Chan |
862: --------------------------------------------------------------------- */
863: FUNCTION valid_col_info RETURN BOOLEAN IS
864: error_msg FND_NEW_MESSAGES.message_text%TYPE;
865: valid_col BOOLEAN := TRUE;
866: col_count NUMBER;
867: BEGIN
868: SELECT count(1)

Line 911: error_msg FND_NEW_MESSAGES.message_text%TYPE;

907: CURSOR cCol IS SELECT forecast_column_id, column_number, days_from, days_to
908: FROM ce_forecast_columns
909: WHERE forecast_header_id = G_rp_forecast_header_id;
910:
911: error_msg FND_NEW_MESSAGES.message_text%TYPE;
912: col_num NUMBER;
913: cid NUMBER;
914: days_from NUMBER;
915: days_to NUMBER;

Line 974: error_msg FND_NEW_MESSAGES.message_text%TYPE;

970: | HISTORY |
971: | 21-AUG-1997 Created Wynne Chan |
972: --------------------------------------------------------------------- */
973: FUNCTION valid_row_info RETURN BOOLEAN IS
974: error_msg FND_NEW_MESSAGES.message_text%TYPE;
975: valid_row BOOLEAN := TRUE;
976: row_exists BOOLEAN := FALSE;
977: BEGIN
978: G_gl_cash_only := FALSE;

Line 1215: error_msg FND_NEW_MESSAGES.message_text%TYPE;

1211: --------------------------------------------------------------------- */
1212: PROCEDURE create_forecast_header IS
1213: l_forecast_rowid VARCHAR2(30);
1214: fid NUMBER;
1215: error_msg FND_NEW_MESSAGES.message_text%TYPE;
1216: duplicate_name BOOLEAN DEFAULT FALSE;
1217: l_fc_count NUMBER;
1218: l_reqid NUMBER;
1219: l_request_id NUMBER;

Line 1338: error_msg FND_NEW_MESSAGES.message_text%TYPE;

1334: | HISTORY |
1335: | 26-SEP-1997 Created Wynne Chan |
1336: --------------------------------------------------------------------- */
1337: FUNCTION valid_exchange_pmr RETURN BOOLEAN IS
1338: error_msg FND_NEW_MESSAGES.message_text%TYPE;
1339: valid_pmr BOOLEAN := TRUE;
1340: BEGIN
1341: IF((G_rp_src_curr_type = 'E' AND
1342: G_rp_forecast_currency <> G_rp_src_currency) OR

Line 1690: error_msg FND_NEW_MESSAGES.message_text%TYPE;

1686: SELECT project_id, segment1
1687: FROM pa_projects_all
1688: WHERE segment1 >= p_start_project_num
1689: AND segment1 <= p_end_project_num;
1690: error_msg FND_NEW_MESSAGES.message_text%TYPE;
1691: p_amount_threshold NUMBER;
1692: BEGIN
1693:
1694: -- populate ce_security_profiles_gt table with ce_security_procfiles_v

Line 1849: error_msg FND_NEW_MESSAGES.message_text%TYPE;

1845: SELECT project_id, segment1
1846: FROM pa_projects_all
1847: WHERE segment1 >= p_start_project_num
1848: AND segment1 <= p_end_project_num;
1849: error_msg FND_NEW_MESSAGES.message_text%TYPE;
1850: p_amount_threshold NUMBER;
1851: BEGIN
1852: -- populate ce_security_profiles_gt table with ce_security_procfiles_v
1853: CEP_STANDARD.init_security;