317: OPEN csr_business_group_name(p_organization_id,p_name);
318: FETCH csr_business_group_name INTO l_business_group_name;
319: IF (csr_business_group_name%FOUND) THEN
320: CLOSE csr_business_group_name;
321: fnd_message.set_name('PER','HR_6556_ALL_BUS_GROUP_EXISTS');
322: fnd_message.raise_error;
323: ELSE
324: CLOSE csr_business_group_name;
325: END IF;
318: FETCH csr_business_group_name INTO l_business_group_name;
319: IF (csr_business_group_name%FOUND) THEN
320: CLOSE csr_business_group_name;
321: fnd_message.set_name('PER','HR_6556_ALL_BUS_GROUP_EXISTS');
322: fnd_message.raise_error;
323: ELSE
324: CLOSE csr_business_group_name;
325: END IF;
326: END IF;
708: ) then
709: --return;
710: null;
711: else
712: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');
713: APP_EXCEPTION.RAISE_EXCEPTION;
714: end if;
715: --
716: for tlinfo in c1 loop
718: if ( (tlinfo.NAME = X_NAME)
719: ) then
720: null;
721: else
722: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
723: app_exception.raise_exception;
724: end if;
725: end if;
726: end loop;
1097: --
1098: dbms_sql.column_value(l_sql_cursor, 1,X_SOB_ID);
1099: --
1100: else
1101: fnd_message.set_name('INV','INV_ACCOUNT_BEFORE_INV');
1102: fnd_message.raise_error;
1103: end if;
1104: dbms_sql.close_cursor(l_sql_cursor);
1105: if X_DESTINATION in ('RCV_ORGANIZATION_PARAMETERS'
1098: dbms_sql.column_value(l_sql_cursor, 1,X_SOB_ID);
1099: --
1100: else
1101: fnd_message.set_name('INV','INV_ACCOUNT_BEFORE_INV');
1102: fnd_message.raise_error;
1103: end if;
1104: dbms_sql.close_cursor(l_sql_cursor);
1105: if X_DESTINATION in ('RCV_ORGANIZATION_PARAMETERS'
1106: ,'MRP_ORGANIZATION_PARAMETERS'
1140: dbms_sql.column_value(l_sql_cursor, 1,X_ORG_CODE);
1141: --
1142: else
1143: if X_DESTINATION = 'WIP_ORGANIZATION_PARAMETERS' then
1144: fnd_message.set_name('WIP','WIP_PARAMETERS_NOT_ALLOWED');
1145: else
1146: fnd_message.set_name('INV','INV_ACCOUNT_BEFORE_INV');
1147: end if;
1148: fnd_message.raise_error;
1142: else
1143: if X_DESTINATION = 'WIP_ORGANIZATION_PARAMETERS' then
1144: fnd_message.set_name('WIP','WIP_PARAMETERS_NOT_ALLOWED');
1145: else
1146: fnd_message.set_name('INV','INV_ACCOUNT_BEFORE_INV');
1147: end if;
1148: fnd_message.raise_error;
1149: end if;
1150: dbms_sql.close_cursor(l_sql_cursor);
1144: fnd_message.set_name('WIP','WIP_PARAMETERS_NOT_ALLOWED');
1145: else
1146: fnd_message.set_name('INV','INV_ACCOUNT_BEFORE_INV');
1147: end if;
1148: fnd_message.raise_error;
1149: end if;
1150: dbms_sql.close_cursor(l_sql_cursor);
1151: --
1152: if X_DESTINATION = 'RCV_ORGANIZATION_PARAMETERS' then
1177: --
1178: dbms_sql.column_value(l_sql_cursor, 1,X_CHART_OF_ACCOUNTS);
1179: --
1180: else
1181: fnd_message.set_name('INV','INV_ACCOUNT_BEFORE_INV');
1182: fnd_message.raise_error;
1183: end if;
1184: dbms_sql.close_cursor(l_sql_cursor);
1185: end if;
1178: dbms_sql.column_value(l_sql_cursor, 1,X_CHART_OF_ACCOUNTS);
1179: --
1180: else
1181: fnd_message.set_name('INV','INV_ACCOUNT_BEFORE_INV');
1182: fnd_message.raise_error;
1183: end if;
1184: dbms_sql.close_cursor(l_sql_cursor);
1185: end if;
1186: end if;
1304: CLOSE c_translation;
1305: ELSE
1306: hr_utility.set_location (l_package_name,70);
1307: CLOSE c_translation;
1308: fnd_message.set_name('PAY','HR_TRANSLATION_EXISTS');
1309: fnd_message.raise_error;
1310: END IF;
1311: hr_utility.set_location ('Leaving:'||l_package_name,80);
1312: END validate_translation;
1305: ELSE
1306: hr_utility.set_location (l_package_name,70);
1307: CLOSE c_translation;
1308: fnd_message.set_name('PAY','HR_TRANSLATION_EXISTS');
1309: fnd_message.raise_error;
1310: END IF;
1311: hr_utility.set_location ('Leaving:'||l_package_name,80);
1312: END validate_translation;
1313: --------------------------------------------------------------------------------