549: IF csr_int%NOTFOUND THEN
550: -- Create Param List
551: --
552: l_list_name := l_prompt_above || ': ' || l_param_list_code;
553: l_prompt_above := fnd_message.get_string('PER','HR_DOWNLOAD_PARAM_LABEL');
554: --
555: l_plsql := 'BEGIN ' ||
556: ' :1 := BNE_PARAMETER_UTILS.CREATE_PARAM_LIST_ALL' ||
557: ' (p_application_id => :2 ' ||
864: --
865: IF csr_int%NOTFOUND THEN
866: --
867: CLOSE csr_int;
868: fnd_message.set_name('PER','PER_289428_ADI_INTG_NOT_EXIST');
869: fnd_message.raise_error;
870: --
871: END IF;
872: --
865: IF csr_int%NOTFOUND THEN
866: --
867: CLOSE csr_int;
868: fnd_message.set_name('PER','PER_289428_ADI_INTG_NOT_EXIST');
869: fnd_message.raise_error;
870: --
871: END IF;
872: --
873: CLOSE csr_int;
882: --
883: IF csr_int%NOTFOUND THEN
884: --
885: CLOSE csr_int;
886: fnd_message.set_name('PER','PER_289505_ADI_CONT_NOT_EXIST');
887: fnd_message.raise_error;
888: --
889: END IF;
890: CLOSE csr_int;
883: IF csr_int%NOTFOUND THEN
884: --
885: CLOSE csr_int;
886: fnd_message.set_name('PER','PER_289505_ADI_CONT_NOT_EXIST');
887: fnd_message.raise_error;
888: --
889: END IF;
890: CLOSE csr_int;
891: --
1025: IF csr_find_app_id%NOTFOUND THEN
1026: CLOSE csr_find_app_id;
1027: --
1028: -- Unable to determine Application ID for given short name
1029: fnd_message.set_name('PER','PER_289189_HR_DISBLE_INVAL_APP');
1030: fnd_message.raise_error;
1031: --
1032: END IF;
1033: CLOSE csr_find_app_id;
1026: CLOSE csr_find_app_id;
1027: --
1028: -- Unable to determine Application ID for given short name
1029: fnd_message.set_name('PER','PER_289189_HR_DISBLE_INVAL_APP');
1030: fnd_message.raise_error;
1031: --
1032: END IF;
1033: CLOSE csr_find_app_id;
1034: --
1037: --
1038: IF (hr_general.chk_application_id(l_application_id) = 'TRUE') THEN
1039: --
1040: -- Integrator belongs to HRMS, so disabling it is not allowed
1041: fnd_message.set_name('PER','PER_289190_NO_DISABLE_HR_INTG');
1042: fnd_message.raise_error;
1043: --
1044: END IF;
1045: --
1038: IF (hr_general.chk_application_id(l_application_id) = 'TRUE') THEN
1039: --
1040: -- Integrator belongs to HRMS, so disabling it is not allowed
1041: fnd_message.set_name('PER','PER_289190_NO_DISABLE_HR_INTG');
1042: fnd_message.raise_error;
1043: --
1044: END IF;
1045: --
1046: -- Have integrator user name - determine integrator code
1057: --
1058: IF l_int_csr%NOTFOUND THEN
1059: --
1060: CLOSE l_int_csr;
1061: fnd_message.set_name('PER','PER_289428_ADI_INTG_NOT_EXIST');
1062: fnd_message.raise_error;
1063: --
1064: END IF;
1065: CLOSE l_int_csr;
1058: IF l_int_csr%NOTFOUND THEN
1059: --
1060: CLOSE l_int_csr;
1061: fnd_message.set_name('PER','PER_289428_ADI_INTG_NOT_EXIST');
1062: fnd_message.raise_error;
1063: --
1064: END IF;
1065: CLOSE l_int_csr;
1066: --
1147: IF csr_get_app_id%NOTFOUND THEN
1148: --
1149: CLOSE csr_get_app_id;
1150: -- Invalid application short name
1151: fnd_message.set_name('PER','PER_289514_ADI_INVAL_INTG_APPL');
1152: fnd_message.raise_error;
1153: END IF;
1154: CLOSE csr_get_app_id;
1155: --
1148: --
1149: CLOSE csr_get_app_id;
1150: -- Invalid application short name
1151: fnd_message.set_name('PER','PER_289514_ADI_INVAL_INTG_APPL');
1152: fnd_message.raise_error;
1153: END IF;
1154: CLOSE csr_get_app_id;
1155: --
1156: -- Determine app_id for responsibility
1159: IF csr_get_app_id%NOTFOUND THEN
1160: --
1161: CLOSE csr_get_app_id;
1162: -- Invalid application_short_name
1163: fnd_message.set_name('PER','PER_289516_ADI_INVAL_RESP_APPL');
1164: fnd_message.raise_error;
1165: END IF;
1166: CLOSE csr_get_app_id;
1167: --
1160: --
1161: CLOSE csr_get_app_id;
1162: -- Invalid application_short_name
1163: fnd_message.set_name('PER','PER_289516_ADI_INVAL_RESP_APPL');
1164: fnd_message.raise_error;
1165: END IF;
1166: CLOSE csr_get_app_id;
1167: --
1168: -- Now check if integrator exists
1175: FETCH l_int_csr INTO l_integrator_code;
1176: IF l_int_csr%NOTFOUND THEN
1177: --
1178: CLOSE l_int_csr;
1179: fnd_message.set_name('PER','PER_289428_ADI_INTG_NOT_EXIST');
1180: fnd_message.raise_error;
1181: --
1182: END IF;
1183: CLOSE l_int_csr;
1176: IF l_int_csr%NOTFOUND THEN
1177: --
1178: CLOSE l_int_csr;
1179: fnd_message.set_name('PER','PER_289428_ADI_INTG_NOT_EXIST');
1180: fnd_message.raise_error;
1181: --
1182: END IF;
1183: CLOSE l_int_csr;
1184: --
1189: IF csr_get_resp_id%NOTFOUND THEN
1190: --
1191: CLOSE csr_get_resp_id;
1192: --
1193: fnd_message.set_name('PER','PER_289517_ADI_INVAL_RESP');
1194: fnd_message.raise_error;
1195: END IF;
1196: CLOSE csr_get_resp_id;
1197: --
1190: --
1191: CLOSE csr_get_resp_id;
1192: --
1193: fnd_message.set_name('PER','PER_289517_ADI_INVAL_RESP');
1194: fnd_message.raise_error;
1195: END IF;
1196: CLOSE csr_get_resp_id;
1197: --
1198: -- Now have a valid app_id/integrator_code and app_id/resp_id
1257: FETCH csr_chk_exists INTO l_exists;
1258: IF csr_chk_exists%NOTFOUND THEN
1259: --
1260: CLOSE csr_chk_exists;
1261: fnd_message.set_name('PER','PER_449900_ADI_INVAL_RESP_ASSC');
1262: fnd_message.raise_error;
1263: --
1264: END IF;
1265: CLOSE csr_chk_exists;
1258: IF csr_chk_exists%NOTFOUND THEN
1259: --
1260: CLOSE csr_chk_exists;
1261: fnd_message.set_name('PER','PER_449900_ADI_INVAL_RESP_ASSC');
1262: fnd_message.raise_error;
1263: --
1264: END IF;
1265: CLOSE csr_chk_exists;
1266: --
1278: IF ((p_resp_application IS NULL) or
1279: (p_responsibility_name IS NULL)) THEN
1280: --
1281: -- Invalid combination - must both have a value to update
1282: fnd_message.set_name('PER','PER_449901_ADI_RESP_VAL_NULL');
1283: fnd_message.raise_error;
1284: END IF;
1285: --
1286: -- Check resp_app_id exists
1279: (p_responsibility_name IS NULL)) THEN
1280: --
1281: -- Invalid combination - must both have a value to update
1282: fnd_message.set_name('PER','PER_449901_ADI_RESP_VAL_NULL');
1283: fnd_message.raise_error;
1284: END IF;
1285: --
1286: -- Check resp_app_id exists
1287: OPEN csr_chk_app_exists;
1288: FETCH csr_chk_app_exists INTO l_application_id;
1289: IF csr_chk_app_exists%NOTFOUND THEN
1290: --
1291: CLOSE csr_chk_app_exists;
1292: fnd_message.set_name('PER','PER_289516_ADI_INVAL_RESP_APPL');
1293: fnd_message.raise_error;
1294: END IF;
1295: CLOSE csr_chk_app_exists;
1296: --
1289: IF csr_chk_app_exists%NOTFOUND THEN
1290: --
1291: CLOSE csr_chk_app_exists;
1292: fnd_message.set_name('PER','PER_289516_ADI_INVAL_RESP_APPL');
1293: fnd_message.raise_error;
1294: END IF;
1295: CLOSE csr_chk_app_exists;
1296: --
1297: -- Check resp exists
1300: IF csr_chk_resp_exists%NOTFOUND THEN
1301: --
1302: -- No matching resp, so error
1303: CLOSE csr_chk_resp_exists;
1304: fnd_message.set_name('PER','PER_289517_ADI_INVAL_RESP');
1305: fnd_message.raise_error;
1306: END IF;
1307: CLOSE csr_chk_resp_exists;
1308: --
1301: --
1302: -- No matching resp, so error
1303: CLOSE csr_chk_resp_exists;
1304: fnd_message.set_name('PER','PER_289517_ADI_INVAL_RESP');
1305: fnd_message.raise_error;
1306: END IF;
1307: CLOSE csr_chk_resp_exists;
1308: --
1309: -- Update the resp
1358: -- Check for NULLS - Both Application and Integrator Name must have
1359: -- a value
1360: --
1361: IF p_intg_application IS NULL THEN
1362: fnd_message.set_name('PER','PER_289514_ADI_INVAL_INTG_APPL');
1363: fnd_message.raise_error;
1364: END IF;
1365: --
1366: IF p_integrator_user_name IS NULL THEN
1359: -- a value
1360: --
1361: IF p_intg_application IS NULL THEN
1362: fnd_message.set_name('PER','PER_289514_ADI_INVAL_INTG_APPL');
1363: fnd_message.raise_error;
1364: END IF;
1365: --
1366: IF p_integrator_user_name IS NULL THEN
1367: fnd_message.set_name('PER','PER_289428_ADI_INTG_NOT_EXIST');
1363: fnd_message.raise_error;
1364: END IF;
1365: --
1366: IF p_integrator_user_name IS NULL THEN
1367: fnd_message.set_name('PER','PER_289428_ADI_INTG_NOT_EXIST');
1368: fnd_message.raise_error;
1369: END IF;
1370: --
1371: -- Check Integrator App exists
1364: END IF;
1365: --
1366: IF p_integrator_user_name IS NULL THEN
1367: fnd_message.set_name('PER','PER_289428_ADI_INTG_NOT_EXIST');
1368: fnd_message.raise_error;
1369: END IF;
1370: --
1371: -- Check Integrator App exists
1372: --
1374: FETCH csr_chk_app_exists INTO l_intg_app_id;
1375: IF csr_chk_app_exists%NOTFOUND THEN
1376: --
1377: CLOSE csr_chk_app_exists;
1378: fnd_message.set_name('PER','PER_289514_ADI_INVAL_INTG_APPL');
1379: fnd_message.raise_error;
1380: END IF;
1381: CLOSE csr_chk_app_exists;
1382: --
1375: IF csr_chk_app_exists%NOTFOUND THEN
1376: --
1377: CLOSE csr_chk_app_exists;
1378: fnd_message.set_name('PER','PER_289514_ADI_INVAL_INTG_APPL');
1379: fnd_message.raise_error;
1380: END IF;
1381: CLOSE csr_chk_app_exists;
1382: --
1383: -- Check Integrator exists
1391: FETCH l_int_csr INTO l_integrator_code;
1392: IF l_int_csr%NOTFOUND THEN
1393: --
1394: CLOSE l_int_csr;
1395: fnd_message.set_name('PER','PER_289428_ADI_INTG_NOT_EXIST');
1396: fnd_message.raise_error;
1397: END IF;
1398: CLOSE l_int_csr;
1399: --
1392: IF l_int_csr%NOTFOUND THEN
1393: --
1394: CLOSE l_int_csr;
1395: fnd_message.set_name('PER','PER_289428_ADI_INTG_NOT_EXIST');
1396: fnd_message.raise_error;
1397: END IF;
1398: CLOSE l_int_csr;
1399: --
1400: -- Check if Form Function rules exist for this Integrator