1209:
1210: if (columns_name is not null) then
1211: -- print out message about which column has been changed to
1212: -- meet the function type validation rule
1213: fnd_message.set_name('FND', 'FUNCTION_TYPE_COLUMNS_CHANGED');
1214: fnd_message.set_token('NAME', X_FUNCTION_NAME);
1215: fnd_message.set_token('COLUMNS', columns_name);
1216: end if;
1217:
1210: if (columns_name is not null) then
1211: -- print out message about which column has been changed to
1212: -- meet the function type validation rule
1213: fnd_message.set_name('FND', 'FUNCTION_TYPE_COLUMNS_CHANGED');
1214: fnd_message.set_token('NAME', X_FUNCTION_NAME);
1215: fnd_message.set_token('COLUMNS', columns_name);
1216: end if;
1217:
1218: insert into FND_FORM_FUNCTIONS_TL (
1211: -- print out message about which column has been changed to
1212: -- meet the function type validation rule
1213: fnd_message.set_name('FND', 'FUNCTION_TYPE_COLUMNS_CHANGED');
1214: fnd_message.set_token('NAME', X_FUNCTION_NAME);
1215: fnd_message.set_token('COLUMNS', columns_name);
1216: end if;
1217:
1218: insert into FND_FORM_FUNCTIONS_TL (
1219: FUNCTION_ID,
1324: open c;
1325: fetch c into recinfo;
1326: if (c%notfound) then
1327: close c;
1328: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
1329: app_exception.raise_exception;
1330: end if;
1331: close c;
1332: if ( ((recinfo.WEB_ICON = X_WEB_ICON)
1363: OR ((recinfo.JRAD_REF_PATH is null) AND (X_JRAD_REF_PATH is null)))
1364: ) then
1365: null;
1366: else
1367: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
1368: app_exception.raise_exception;
1369: end if;
1370:
1371: open c1;
1381: OR ((tlinfo.DESCRIPTION is null) AND (X_DESCRIPTION is null)))
1382: ) then
1383: null;
1384: else
1385: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
1386: app_exception.raise_exception;
1387: end if;
1388: return;
1389: end LOCK_ROW;
1476:
1477: if (columns_name is not null) then
1478: -- print out message about which column has been changed to
1479: -- meet the function type validation rule
1480: fnd_message.set_name('FND', 'FUNCTION_TYPE_COLUMNS_CHANGED');
1481: fnd_message.set_token('NAME', X_FUNCTION_NAME);
1482: fnd_message.set_token('COLUMNS', columns_name);
1483: end if;
1484:
1477: if (columns_name is not null) then
1478: -- print out message about which column has been changed to
1479: -- meet the function type validation rule
1480: fnd_message.set_name('FND', 'FUNCTION_TYPE_COLUMNS_CHANGED');
1481: fnd_message.set_token('NAME', X_FUNCTION_NAME);
1482: fnd_message.set_token('COLUMNS', columns_name);
1483: end if;
1484:
1485: if (sql%notfound) then
1478: -- print out message about which column has been changed to
1479: -- meet the function type validation rule
1480: fnd_message.set_name('FND', 'FUNCTION_TYPE_COLUMNS_CHANGED');
1481: fnd_message.set_token('NAME', X_FUNCTION_NAME);
1482: fnd_message.set_token('COLUMNS', columns_name);
1483: end if;
1484:
1485: if (sql%notfound) then
1486: raise no_data_found;
1523: where lv.lookup_type = 'APPS_MAINTENANCE_MODE_SUPPORT'
1524: and lv.language = userenv('LANG'));
1525: exception
1526: when no_data_found then
1527: fnd_message.set_name('FND', 'FND_INVALID_MAINTENANCE_MODE');
1528: fnd_message.set_token('MODE', x_function_mode);
1529: app_exception.raise_exception;
1530: end;
1531:
1524: and lv.language = userenv('LANG'));
1525: exception
1526: when no_data_found then
1527: fnd_message.set_name('FND', 'FND_INVALID_MAINTENANCE_MODE');
1528: fnd_message.set_token('MODE', x_function_mode);
1529: app_exception.raise_exception;
1530: end;
1531:
1532: update fnd_form_functions
1534: where function_name like x_function_name;
1535:
1536: -- Function name does not exist
1537: if (sql%notfound) then
1538: fnd_message.set_name('FND', 'FND_FUNCTION_NOT_FOUND');
1539: fnd_message.set_token('NAME', x_function_name);
1540: app_exception.raise_exception;
1541: end if;
1542:
1535:
1536: -- Function name does not exist
1537: if (sql%notfound) then
1538: fnd_message.set_name('FND', 'FND_FUNCTION_NOT_FOUND');
1539: fnd_message.set_token('NAME', x_function_name);
1540: app_exception.raise_exception;
1541: end if;
1542:
1543: