DBA Data[Home] [Help]

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');

929: i_varchar2Counter := i_varchar2Counter + 1;
930: l_colStr := 'USER_ATTRIBUTE'||to_char(i_varchar2Counter);
931: else
932: --Datatype not correct
933: FND_MESSAGE.SET_NAME('MSC', 'MSC_UDE_INCORRECT_DATA_TYPE');
934: raise ExTerminateProgram;
935:
936: end if;
937:

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');

1143: CompValueList1(i) := ''''|| replace(CompValueList1(i), '''', '''''') ||'''';
1144:
1145: else
1146: --Datatype not correct
1147: FND_MESSAGE.SET_NAME('MSC', 'MSC_UDE_INCORRECT_DATA_TYPE');
1148: raise ExTerminateProgram;
1149:
1150: end if;
1151:

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');

2040: end if;
2041:
2042: end loop; -- columnCounter loop
2043:
2044: fnd_message.set_name('MSC','MSC_UDE_NTFBOD');
2045: fnd_message.set_token('EXCEPTION',v_exception_name);
2046: fnd_message.set_token('CREATION_DATE',vLastUpdateDate);
2047:
2048: vNtfBodyText := '
'||fnd_message.get||'
'||

Line 2045: fnd_message.set_token('EXCEPTION',v_exception_name);

2041:
2042: end loop; -- columnCounter loop
2043:
2044: fnd_message.set_name('MSC','MSC_UDE_NTFBOD');
2045: fnd_message.set_token('EXCEPTION',v_exception_name);
2046: fnd_message.set_token('CREATION_DATE',vLastUpdateDate);
2047:
2048: vNtfBodyText := '
'||fnd_message.get||'
'||
2049: ' '||

Line 2046: fnd_message.set_token('CREATION_DATE',vLastUpdateDate);

2042: end loop; -- columnCounter loop
2043:
2044: fnd_message.set_name('MSC','MSC_UDE_NTFBOD');
2045: fnd_message.set_token('EXCEPTION',v_exception_name);
2046: fnd_message.set_token('CREATION_DATE',vLastUpdateDate);
2047:
2048: vNtfBodyText := '
'||fnd_message.get||'
'||
2049: '

'||
2050: ''||columnNtfTableHeader||''||

Line 2048: vNtfBodyText := '
'||fnd_message.get||'
'||

2044: fnd_message.set_name('MSC','MSC_UDE_NTFBOD');
2045: fnd_message.set_token('EXCEPTION',v_exception_name);
2046: fnd_message.set_token('CREATION_DATE',vLastUpdateDate);
2047:
2048: vNtfBodyText := '
'||fnd_message.get||'
'||
2049: '

'||
2050: ''||columnNtfTableHeader||''||
2051: ''||columnNtfRowValue||'';
2052:

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');

3934: where EXCEPTION_ID = lexceptionId;
3935:
3936:
3937: status := 1;
3938: FND_MESSAGE.Set_NAME('MSC','MSCX_UDE_EXCEP_COPY');
3939: returnMessage := FND_MESSAGE.get;
3940:
3941:
3942: Exception

Line 3939: returnMessage := FND_MESSAGE.get;

3935:
3936:
3937: status := 1;
3938: FND_MESSAGE.Set_NAME('MSC','MSCX_UDE_EXCEP_COPY');
3939: returnMessage := FND_MESSAGE.get;
3940:
3941:
3942: Exception
3943: when others then

Line 3973: FND_MESSAGE.SET_NAME('MSC', 'MSC_UDE_DEL_FAILED');

3969:
3970: Begin
3971: status := -1;
3972: --returnMessage := 'delete failed';
3973: FND_MESSAGE.SET_NAME('MSC', 'MSC_UDE_DEL_FAILED');
3974: returnMessage := FND_MESSAGE.get;
3975:
3976: open wfItems;
3977: fetch wfItems into lItemType;

Line 3974: returnMessage := FND_MESSAGE.get;

3970: Begin
3971: status := -1;
3972: --returnMessage := 'delete failed';
3973: FND_MESSAGE.SET_NAME('MSC', 'MSC_UDE_DEL_FAILED');
3974: returnMessage := FND_MESSAGE.get;
3975:
3976: open wfItems;
3977: fetch wfItems into lItemType;
3978: close wfItems;

Line 4030: FND_MESSAGE.SET_NAME('MSC', 'MSC_UDE_DEL_SUCCESS');

4026: */
4027:
4028: status := 1;
4029: --returnMessage := 'delete completed';
4030: FND_MESSAGE.SET_NAME('MSC', 'MSC_UDE_DEL_SUCCESS');
4031: returnMessage := FND_MESSAGE.get;
4032:
4033:
4034: end;

Line 4031: returnMessage := FND_MESSAGE.get;

4027:
4028: status := 1;
4029: --returnMessage := 'delete completed';
4030: FND_MESSAGE.SET_NAME('MSC', 'MSC_UDE_DEL_SUCCESS');
4031: returnMessage := FND_MESSAGE.get;
4032:
4033:
4034: end;
4035: