550: IF csr_int%NOTFOUND THEN
551: -- Create Param List
552: --
553: l_list_name := l_prompt_above || ': ' || l_param_list_code;
554: l_prompt_above := fnd_message.get_string('PER','HR_DOWNLOAD_PARAM_LABEL');
555: --
556: l_plsql := 'BEGIN ' ||
557: ' :1 := BNE_PARAMETER_UTILS.CREATE_PARAM_LIST_ALL' ||
558: ' (p_application_id => :2 ' ||
786: WHERE PARAM_DEFN_CODE = l_param_defn_code
787: AND APPLICATION_ID = p_application_id;
788:
789: IF l_data_type <> p_param_type THEN
790: fnd_message.set_name('PER','PER_ADI_PARAM_NAME_EXISTS');
791: fnd_message.raise_error;
792: END IF;
793: END IF;
794: --
787: AND APPLICATION_ID = p_application_id;
788:
789: IF l_data_type <> p_param_type THEN
790: fnd_message.set_name('PER','PER_ADI_PARAM_NAME_EXISTS');
791: fnd_message.raise_error;
792: END IF;
793: END IF;
794: --
795: -- Have param defn, now define item in list
877: --
878: IF csr_int%NOTFOUND THEN
879: --
880: CLOSE csr_int;
881: fnd_message.set_name('PER','PER_289428_ADI_INTG_NOT_EXIST');
882: fnd_message.raise_error;
883: --
884: END IF;
885: --
878: IF csr_int%NOTFOUND THEN
879: --
880: CLOSE csr_int;
881: fnd_message.set_name('PER','PER_289428_ADI_INTG_NOT_EXIST');
882: fnd_message.raise_error;
883: --
884: END IF;
885: --
886: CLOSE csr_int;
895: --
896: IF csr_int%NOTFOUND THEN
897: --
898: CLOSE csr_int;
899: fnd_message.set_name('PER','PER_289505_ADI_CONT_NOT_EXIST');
900: fnd_message.raise_error;
901: --
902: END IF;
903: CLOSE csr_int;
896: IF csr_int%NOTFOUND THEN
897: --
898: CLOSE csr_int;
899: fnd_message.set_name('PER','PER_289505_ADI_CONT_NOT_EXIST');
900: fnd_message.raise_error;
901: --
902: END IF;
903: CLOSE csr_int;
904: --
1038: IF csr_find_app_id%NOTFOUND THEN
1039: CLOSE csr_find_app_id;
1040: --
1041: -- Unable to determine Application ID for given short name
1042: fnd_message.set_name('PER','PER_289189_HR_DISBLE_INVAL_APP');
1043: fnd_message.raise_error;
1044: --
1045: END IF;
1046: CLOSE csr_find_app_id;
1039: CLOSE csr_find_app_id;
1040: --
1041: -- Unable to determine Application ID for given short name
1042: fnd_message.set_name('PER','PER_289189_HR_DISBLE_INVAL_APP');
1043: fnd_message.raise_error;
1044: --
1045: END IF;
1046: CLOSE csr_find_app_id;
1047: --
1050: --
1051: IF (hr_general.chk_application_id(l_application_id) = 'TRUE') THEN
1052: --
1053: -- Integrator belongs to HRMS, so disabling it is not allowed
1054: fnd_message.set_name('PER','PER_289190_NO_DISABLE_HR_INTG');
1055: fnd_message.raise_error;
1056: --
1057: END IF;
1058: --
1051: IF (hr_general.chk_application_id(l_application_id) = 'TRUE') THEN
1052: --
1053: -- Integrator belongs to HRMS, so disabling it is not allowed
1054: fnd_message.set_name('PER','PER_289190_NO_DISABLE_HR_INTG');
1055: fnd_message.raise_error;
1056: --
1057: END IF;
1058: --
1059: -- Have integrator user name - determine integrator code
1070: --
1071: IF l_int_csr%NOTFOUND THEN
1072: --
1073: CLOSE l_int_csr;
1074: fnd_message.set_name('PER','PER_289428_ADI_INTG_NOT_EXIST');
1075: fnd_message.raise_error;
1076: --
1077: END IF;
1078: CLOSE l_int_csr;
1071: IF l_int_csr%NOTFOUND THEN
1072: --
1073: CLOSE l_int_csr;
1074: fnd_message.set_name('PER','PER_289428_ADI_INTG_NOT_EXIST');
1075: fnd_message.raise_error;
1076: --
1077: END IF;
1078: CLOSE l_int_csr;
1079: --
1160: IF csr_get_app_id%NOTFOUND THEN
1161: --
1162: CLOSE csr_get_app_id;
1163: -- Invalid application short name
1164: fnd_message.set_name('PER','PER_289514_ADI_INVAL_INTG_APPL');
1165: fnd_message.raise_error;
1166: END IF;
1167: CLOSE csr_get_app_id;
1168: --
1161: --
1162: CLOSE csr_get_app_id;
1163: -- Invalid application short name
1164: fnd_message.set_name('PER','PER_289514_ADI_INVAL_INTG_APPL');
1165: fnd_message.raise_error;
1166: END IF;
1167: CLOSE csr_get_app_id;
1168: --
1169: -- Determine app_id for responsibility
1172: IF csr_get_app_id%NOTFOUND THEN
1173: --
1174: CLOSE csr_get_app_id;
1175: -- Invalid application_short_name
1176: fnd_message.set_name('PER','PER_289516_ADI_INVAL_RESP_APPL');
1177: fnd_message.raise_error;
1178: END IF;
1179: CLOSE csr_get_app_id;
1180: --
1173: --
1174: CLOSE csr_get_app_id;
1175: -- Invalid application_short_name
1176: fnd_message.set_name('PER','PER_289516_ADI_INVAL_RESP_APPL');
1177: fnd_message.raise_error;
1178: END IF;
1179: CLOSE csr_get_app_id;
1180: --
1181: -- Now check if integrator exists
1188: FETCH l_int_csr INTO l_integrator_code;
1189: IF l_int_csr%NOTFOUND THEN
1190: --
1191: CLOSE l_int_csr;
1192: fnd_message.set_name('PER','PER_289428_ADI_INTG_NOT_EXIST');
1193: fnd_message.raise_error;
1194: --
1195: END IF;
1196: CLOSE l_int_csr;
1189: IF l_int_csr%NOTFOUND THEN
1190: --
1191: CLOSE l_int_csr;
1192: fnd_message.set_name('PER','PER_289428_ADI_INTG_NOT_EXIST');
1193: fnd_message.raise_error;
1194: --
1195: END IF;
1196: CLOSE l_int_csr;
1197: --
1202: IF csr_get_resp_id%NOTFOUND THEN
1203: --
1204: CLOSE csr_get_resp_id;
1205: --
1206: fnd_message.set_name('PER','PER_289517_ADI_INVAL_RESP');
1207: fnd_message.raise_error;
1208: END IF;
1209: CLOSE csr_get_resp_id;
1210: --
1203: --
1204: CLOSE csr_get_resp_id;
1205: --
1206: fnd_message.set_name('PER','PER_289517_ADI_INVAL_RESP');
1207: fnd_message.raise_error;
1208: END IF;
1209: CLOSE csr_get_resp_id;
1210: --
1211: -- Now have a valid app_id/integrator_code and app_id/resp_id
1270: FETCH csr_chk_exists INTO l_exists;
1271: IF csr_chk_exists%NOTFOUND THEN
1272: --
1273: CLOSE csr_chk_exists;
1274: fnd_message.set_name('PER','PER_449900_ADI_INVAL_RESP_ASSC');
1275: fnd_message.raise_error;
1276: --
1277: END IF;
1278: CLOSE csr_chk_exists;
1271: IF csr_chk_exists%NOTFOUND THEN
1272: --
1273: CLOSE csr_chk_exists;
1274: fnd_message.set_name('PER','PER_449900_ADI_INVAL_RESP_ASSC');
1275: fnd_message.raise_error;
1276: --
1277: END IF;
1278: CLOSE csr_chk_exists;
1279: --
1291: IF ((p_resp_application IS NULL) or
1292: (p_responsibility_name IS NULL)) THEN
1293: --
1294: -- Invalid combination - must both have a value to update
1295: fnd_message.set_name('PER','PER_449901_ADI_RESP_VAL_NULL');
1296: fnd_message.raise_error;
1297: END IF;
1298: --
1299: -- Check resp_app_id exists
1292: (p_responsibility_name IS NULL)) THEN
1293: --
1294: -- Invalid combination - must both have a value to update
1295: fnd_message.set_name('PER','PER_449901_ADI_RESP_VAL_NULL');
1296: fnd_message.raise_error;
1297: END IF;
1298: --
1299: -- Check resp_app_id exists
1300: OPEN csr_chk_app_exists;
1301: FETCH csr_chk_app_exists INTO l_application_id;
1302: IF csr_chk_app_exists%NOTFOUND THEN
1303: --
1304: CLOSE csr_chk_app_exists;
1305: fnd_message.set_name('PER','PER_289516_ADI_INVAL_RESP_APPL');
1306: fnd_message.raise_error;
1307: END IF;
1308: CLOSE csr_chk_app_exists;
1309: --
1302: IF csr_chk_app_exists%NOTFOUND THEN
1303: --
1304: CLOSE csr_chk_app_exists;
1305: fnd_message.set_name('PER','PER_289516_ADI_INVAL_RESP_APPL');
1306: fnd_message.raise_error;
1307: END IF;
1308: CLOSE csr_chk_app_exists;
1309: --
1310: -- Check resp exists
1313: IF csr_chk_resp_exists%NOTFOUND THEN
1314: --
1315: -- No matching resp, so error
1316: CLOSE csr_chk_resp_exists;
1317: fnd_message.set_name('PER','PER_289517_ADI_INVAL_RESP');
1318: fnd_message.raise_error;
1319: END IF;
1320: CLOSE csr_chk_resp_exists;
1321: --
1314: --
1315: -- No matching resp, so error
1316: CLOSE csr_chk_resp_exists;
1317: fnd_message.set_name('PER','PER_289517_ADI_INVAL_RESP');
1318: fnd_message.raise_error;
1319: END IF;
1320: CLOSE csr_chk_resp_exists;
1321: --
1322: -- Update the resp
1371: -- Check for NULLS - Both Application and Integrator Name must have
1372: -- a value
1373: --
1374: IF p_intg_application IS NULL THEN
1375: fnd_message.set_name('PER','PER_289514_ADI_INVAL_INTG_APPL');
1376: fnd_message.raise_error;
1377: END IF;
1378: --
1379: IF p_integrator_user_name IS NULL THEN
1372: -- a value
1373: --
1374: IF p_intg_application IS NULL THEN
1375: fnd_message.set_name('PER','PER_289514_ADI_INVAL_INTG_APPL');
1376: fnd_message.raise_error;
1377: END IF;
1378: --
1379: IF p_integrator_user_name IS NULL THEN
1380: fnd_message.set_name('PER','PER_289428_ADI_INTG_NOT_EXIST');
1376: fnd_message.raise_error;
1377: END IF;
1378: --
1379: IF p_integrator_user_name IS NULL THEN
1380: fnd_message.set_name('PER','PER_289428_ADI_INTG_NOT_EXIST');
1381: fnd_message.raise_error;
1382: END IF;
1383: --
1384: -- Check Integrator App exists
1377: END IF;
1378: --
1379: IF p_integrator_user_name IS NULL THEN
1380: fnd_message.set_name('PER','PER_289428_ADI_INTG_NOT_EXIST');
1381: fnd_message.raise_error;
1382: END IF;
1383: --
1384: -- Check Integrator App exists
1385: --
1387: FETCH csr_chk_app_exists INTO l_intg_app_id;
1388: IF csr_chk_app_exists%NOTFOUND THEN
1389: --
1390: CLOSE csr_chk_app_exists;
1391: fnd_message.set_name('PER','PER_289514_ADI_INVAL_INTG_APPL');
1392: fnd_message.raise_error;
1393: END IF;
1394: CLOSE csr_chk_app_exists;
1395: --
1388: IF csr_chk_app_exists%NOTFOUND THEN
1389: --
1390: CLOSE csr_chk_app_exists;
1391: fnd_message.set_name('PER','PER_289514_ADI_INVAL_INTG_APPL');
1392: fnd_message.raise_error;
1393: END IF;
1394: CLOSE csr_chk_app_exists;
1395: --
1396: -- Check Integrator exists
1404: FETCH l_int_csr INTO l_integrator_code;
1405: IF l_int_csr%NOTFOUND THEN
1406: --
1407: CLOSE l_int_csr;
1408: fnd_message.set_name('PER','PER_289428_ADI_INTG_NOT_EXIST');
1409: fnd_message.raise_error;
1410: END IF;
1411: CLOSE l_int_csr;
1412: --
1405: IF l_int_csr%NOTFOUND THEN
1406: --
1407: CLOSE l_int_csr;
1408: fnd_message.set_name('PER','PER_289428_ADI_INTG_NOT_EXIST');
1409: fnd_message.raise_error;
1410: END IF;
1411: CLOSE l_int_csr;
1412: --
1413: -- Check if Form Function rules exist for this Integrator