APPS.MSC_X_USER_EXCEP_GEN dependencies on FND_MESSAGE
Line 522: FND_MESSAGE.SET_NAME('MSC', 'MSC_UDE_FULLLOADFLAG');
518: log_message('FullLoadFlag to be default by program');
519: end if;
520: else
521: log_message('Incorrect value for Full Load flag'); 522: FND_MESSAGE.SET_NAME('MSC', 'MSC_UDE_FULLLOADFLAG'); 523: raise ExTerminateProgram;
524: end if;
525:
526: if v_debug then
Line 636: ERRBUF := FND_MESSAGE.GET;
632:
633: if dbms_sql.is_open(v_insert_cursor) THEN
634: dbms_sql.close_cursor(v_insert_cursor);
635: end if; 636: ERRBUF := FND_MESSAGE.GET; 637: RETCODE := G_ERROR;
638: log_message(ERRBUF);
639:
640: when others then
Line 706: FND_MESSAGE.SET_NAME('MSC', 'MSC_UDE_EXCNOTFOUND');
702:
703:
704: if v_exception_name is null then
705: log_message('exception definition not found'); 706: FND_MESSAGE.SET_NAME('MSC', 'MSC_UDE_EXCNOTFOUND'); 707: raise ExTerminateProgram;
708: end If;
709:
710:
Line 842: FND_MESSAGE.SET_NAME('MSC', 'MSC_UDE_COLNAMENULL');
838: num1 := num1 + 1;
839: --All these this should be checked in UI itself
840: if ColumnNameList(i) is null then
841: --Columname should not be null for calculation and select attribute 842: FND_MESSAGE.SET_NAME('MSC', 'MSC_UDE_COLNAMENULL'); 843: raise ExTerminateProgram;
844: elsif SeqNumList(i) is null then
845: --SeqNumber should not be null for calculation and select attribute
846: FND_MESSAGE.SET_NAME('MSC', 'MSC_UDE_SQNUMNULL');
Line 846: FND_MESSAGE.SET_NAME('MSC', 'MSC_UDE_SQNUMNULL');
842: FND_MESSAGE.SET_NAME('MSC', 'MSC_UDE_COLNAMENULL');
843: raise ExTerminateProgram;
844: elsif SeqNumList(i) is null then
845: --SeqNumber should not be null for calculation and select attribute 846: FND_MESSAGE.SET_NAME('MSC', 'MSC_UDE_SQNUMNULL'); 847: raise ExTerminateProgram;
848:
849: end If;
850:
Line 933: FND_MESSAGE.SET_NAME('MSC', 'MSC_UDE_INCORRECT_DATA_TYPE');
Line 959: FND_MESSAGE.SET_NAME('MSC', 'MSC_UDE_PARAM_VALUE_NULL');
955: if AttributeTypeList(i) = 'FILTER' Then
956:
957: if CompValueList1(i) is null AND DateFilterFlagList(i) <> 'R' then
958: --Parameter should not be null for filter unless it's a date filter set to rolling time period 959: FND_MESSAGE.SET_NAME('MSC', 'MSC_UDE_PARAM_VALUE_NULL'); 960: raise ExTerminateProgram;
961: end if;
962:
963: if DataTypeList(i) in ('DATE' ,'DATETIME' )then
Line 1040: FND_MESSAGE.SET_NAME('MSC', 'MSC_UDE_INCORRECT_DATA_TYPE');
1036: end if;
1037:
1038: else
1039: --Datatype not correct 1040: FND_MESSAGE.SET_NAME('MSC', 'MSC_UDE_INCORRECT_DATA_TYPE'); 1041: raise ExTerminateProgram;
1042: end if;
1043:
1044:
Line 1065: FND_MESSAGE.SET_NAME('MSC', 'MSC_UDE_PARAM_VALUE_NULL');
1061:
1062: if ((CompValueList1(i) is null and RollingNumberList(i) NOT IN (9,10))
1063: and (OpColumnNameList(i) is null)) then
1064: --Parameter should not be null for Simple Condition 1065: FND_MESSAGE.SET_NAME('MSC', 'MSC_UDE_PARAM_VALUE_NULL'); 1066: raise ExTerminateProgram;
1067: end if;
1068:
1069: --bug# 2410159
Line 1147: FND_MESSAGE.SET_NAME('MSC', 'MSC_UDE_INCORRECT_DATA_TYPE');
Line 1290: FND_MESSAGE.SET_NAME('MSC', 'MSC_UDE_SELECT_NULL');
1286:
1287: -- If Group by,Include group by statemnet else include trandsaction ids
1288: -- in select statement and as well as in insert and values statement
1289: if vSelectStmt is null then 1290: FND_MESSAGE.SET_NAME('MSC', 'MSC_UDE_SELECT_NULL'); 1291: raise ExTerminateProgram;
1292: end if;
1293:
1294: if vGroupByFlag = 'Y' then
Line 1490: FND_MESSAGE.SET_NAME('MSC', 'MSC_UDE_DATE_COL_EXCEEDED');
1486: if DataTypeList(columnCounter) in ('DATE','DATETIME') then
1487: dateCounter := dateCounter + 1;
1488: if dateCounter > 7 then
1489: --Number of date column should not be more then 7 1490: FND_MESSAGE.SET_NAME('MSC', 'MSC_UDE_DATE_COL_EXCEEDED'); 1491: raise ExTerminateProgram;
1492: end if;
1493: DBMSSQLStep(dateCounter, 'DATE' , 'DEFINE_ARRAY',lCounterTemp);
1494: elsif DataTypeList(columnCounter) in ( 'NUMBER','AGGREGATE') then
Line 1498: FND_MESSAGE.SET_NAME('MSC', 'MSC_UDE_NUMBER_COL_EXCEEDED');
1494: elsif DataTypeList(columnCounter) in ( 'NUMBER','AGGREGATE') then
1495: numberCounter := numberCounter + 1;
1496: if numberCounter > 10 then
1497: --Number of Number column should not be more then 10 1498: FND_MESSAGE.SET_NAME('MSC', 'MSC_UDE_NUMBER_COL_EXCEEDED'); 1499: raise ExTerminateProgram;
1500: end if;
1501: DBMSSQLStep(numberCounter, 'NUMBER' , 'DEFINE_ARRAY',lCounterTemp);
1502: elsif DataTypeList(columnCounter) = 'VARCHAR2' then
Line 1506: FND_MESSAGE.SET_NAME('MSC', 'MSC_UDE_VARCHAR2_COL_EXCEEDED');
1502: elsif DataTypeList(columnCounter) = 'VARCHAR2' then
1503: varchar2Counter := varchar2Counter + 1;
1504: if varchar2Counter > 20 then
1505: --Number of varchar2 column should not be more then 20 1506: FND_MESSAGE.SET_NAME('MSC', 'MSC_UDE_VARCHAR2_COL_EXCEEDED'); 1507: raise ExTerminateProgram;
1508: end if;
1509: DBMSSQLStep(varchar2Counter, 'VARCHAR2' , 'DEFINE_ARRAY',lCounterTemp);
1510: else
Line 1512: FND_MESSAGE.SET_NAME('MSC', 'MSC_UDE_INCORRECT_DATA_TYPE');
1508: end if;
1509: DBMSSQLStep(varchar2Counter, 'VARCHAR2' , 'DEFINE_ARRAY',lCounterTemp);
1510: else
1511: --Datatype not correct 1512: FND_MESSAGE.SET_NAME('MSC', 'MSC_UDE_INCORRECT_DATA_TYPE'); 1513: raise ExTerminateProgram;
1514:
1515: end if;
1516:
Line 1720: FND_MESSAGE.SET_NAME('MSC', 'MSC_UDE_INCORRECT_DATA_TYPE');
1716: --this doesn't work
1717: --DBMS_SQL.COLUMN_VALUE(v_fetch_cursor,columnCounter,getVarcharArray(varchar2Counter) );
1718: else
1719: --Datatype not correct 1720: FND_MESSAGE.SET_NAME('MSC', 'MSC_UDE_INCORRECT_DATA_TYPE'); 1721: raise ExTerminateProgram;
1722: end if;
1723: lCounterTemp := lCounterTemp + 1;
1724: end if;
Line 2044: fnd_message.set_name('MSC','MSC_UDE_NTFBOD');
Line 2173: fnd_message.set_name('MSC','MSC_UDE_NTFTOK_ERR');
2169: end if;
2170: else
2171: --l_token_number := -1;
2172: --log_message('Notification token'||tokenNumber||' not specified correctly'); 2173: fnd_message.set_name('MSC','MSC_UDE_NTFTOK_ERR'); 2174: fnd_message.set_token('TOKENNUMBER',tokenNumber);
2175: raise ExTerminateProgram;
2176: end if;
2177: l_token_number := to_number(lTempNumber1||lTempNumber2);
Line 2174: fnd_message.set_token('TOKENNUMBER',tokenNumber);
2170: else
2171: --l_token_number := -1;
2172: --log_message('Notification token'||tokenNumber||' not specified correctly');
2173: fnd_message.set_name('MSC','MSC_UDE_NTFTOK_ERR'); 2174: fnd_message.set_token('TOKENNUMBER',tokenNumber); 2175: raise ExTerminateProgram;
2176: end if;
2177: l_token_number := to_number(lTempNumber1||lTempNumber2);
2178: if l_token_number > 30 then
Line 2179: fnd_message.set_name('MSC','MSC_UDE_NTFTOK_BIG');
2175: raise ExTerminateProgram;
2176: end if;
2177: l_token_number := to_number(lTempNumber1||lTempNumber2);
2178: if l_token_number > 30 then 2179: fnd_message.set_name('MSC','MSC_UDE_NTFTOK_BIG'); 2180: fnd_message.set_token('TOKENNUMBER',tokenNumber);
2181: raise ExTerminateProgram;
2182: end if;
2183: else
Line 2180: fnd_message.set_token('TOKENNUMBER',tokenNumber);
2176: end if;
2177: l_token_number := to_number(lTempNumber1||lTempNumber2);
2178: if l_token_number > 30 then
2179: fnd_message.set_name('MSC','MSC_UDE_NTFTOK_BIG'); 2180: fnd_message.set_token('TOKENNUMBER',tokenNumber); 2181: raise ExTerminateProgram;
2182: end if;
2183: else
2184: log_message('Notification tokens'||tokenNumber||' not specified ');
Line 2320: FND_MESSAGE.SET_NAME('MSC','MSC_UDE_PARSE_ERROR');
2316: when others then
2317: errorPos := DBMS_SQL.last_error_position;
2318: if errorPos > 0 then
2319: log_message(substr(Stmt,1,errorPos)||'^^^^^'); 2320: FND_MESSAGE.SET_NAME('MSC','MSC_UDE_PARSE_ERROR'); 2321: FND_MESSAGE.SET_TOKEN('ERRPOS',to_char(errorPos) );
2322:
2323: log_message('Error occured at position = '||to_char(errorPos));
2324: end if;
Line 2321: FND_MESSAGE.SET_TOKEN('ERRPOS',to_char(errorPos) );
2317: errorPos := DBMS_SQL.last_error_position;
2318: if errorPos > 0 then
2319: log_message(substr(Stmt,1,errorPos)||'^^^^^');
2320: FND_MESSAGE.SET_NAME('MSC','MSC_UDE_PARSE_ERROR'); 2321: FND_MESSAGE.SET_TOKEN('ERRPOS',to_char(errorPos) ); 2322:
2323: log_message('Error occured at position = '||to_char(errorPos));
2324: end if;
2325:
Line 2402: FND_MESSAGE.SET_NAME('MSC', 'MSC_UDE_THRESHOLDERROR');
2398: return(replacedWhere);
2399: EXCEPTION
2400: when ExTerminateProgram then
2401: -- log_message( 'Threshold condition not specified correctly'); 2402: FND_MESSAGE.SET_NAME('MSC', 'MSC_UDE_THRESHOLDERROR'); 2403: raise;
2404: end modifyWhereForThreshold;
2405:
2406: --------------------------------------------------------------------------
Line 3374: oErrorMessage := fnd_message.get;
3370: end if;
3371:
3372: exception
3373: when ExTerminateProgram then 3374: oErrorMessage := fnd_message.get; 3375: log_message(oErrorMessage);
3376:
3377: when others then
3378: oErrorMessage := SQLERRM;
Line 3486: oErrorMessage := fnd_message.get;
3482: oErrorPosition := 0;
3483: exception
3484: when ExTerminateProgram then
3485: --log_message('ExTerminateProgram exception'); 3486: oErrorMessage := fnd_message.get; 3487: oErrorPosition := -1;
3488: log_message(oErrorMessage);
3489: when others then
3490: if oSqlStmt is null then
Line 3938: FND_MESSAGE.Set_NAME('MSC','MSCX_UDE_EXCEP_COPY');