DBA Data[Home] [Help]

APPS.HR_INTEGRATION_UTILS dependencies on FND_MESSAGE

Line 553: l_prompt_above := fnd_message.get_string('PER','HR_DOWNLOAD_PARAM_LABEL');

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

Line 868: fnd_message.set_name('PER','PER_289428_ADI_INTG_NOT_EXIST');

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: --

Line 869: fnd_message.raise_error;

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;

Line 886: fnd_message.set_name('PER','PER_289505_ADI_CONT_NOT_EXIST');

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;

Line 887: fnd_message.raise_error;

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: --

Line 1029: fnd_message.set_name('PER','PER_289189_HR_DISBLE_INVAL_APP');

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;

Line 1030: fnd_message.raise_error;

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: --

Line 1041: fnd_message.set_name('PER','PER_289190_NO_DISABLE_HR_INTG');

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: --

Line 1042: fnd_message.raise_error;

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

Line 1061: fnd_message.set_name('PER','PER_289428_ADI_INTG_NOT_EXIST');

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;

Line 1062: fnd_message.raise_error;

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: --

Line 1151: fnd_message.set_name('PER','PER_289514_ADI_INVAL_INTG_APPL');

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: --

Line 1152: fnd_message.raise_error;

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

Line 1163: fnd_message.set_name('PER','PER_289516_ADI_INVAL_RESP_APPL');

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: --

Line 1164: fnd_message.raise_error;

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

Line 1179: fnd_message.set_name('PER','PER_289428_ADI_INTG_NOT_EXIST');

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;

Line 1180: fnd_message.raise_error;

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: --

Line 1193: fnd_message.set_name('PER','PER_289517_ADI_INVAL_RESP');

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: --

Line 1194: fnd_message.raise_error;

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

Line 1261: fnd_message.set_name('PER','PER_449900_ADI_INVAL_RESP_ASSC');

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;

Line 1262: fnd_message.raise_error;

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: --

Line 1282: fnd_message.set_name('PER','PER_449901_ADI_RESP_VAL_NULL');

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

Line 1283: fnd_message.raise_error;

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;

Line 1292: fnd_message.set_name('PER','PER_289516_ADI_INVAL_RESP_APPL');

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: --

Line 1293: fnd_message.raise_error;

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

Line 1304: fnd_message.set_name('PER','PER_289517_ADI_INVAL_RESP');

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: --

Line 1305: fnd_message.raise_error;

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

Line 1362: fnd_message.set_name('PER','PER_289514_ADI_INVAL_INTG_APPL');

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

Line 1363: fnd_message.raise_error;

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

Line 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

Line 1368: 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
1372: --

Line 1378: fnd_message.set_name('PER','PER_289514_ADI_INVAL_INTG_APPL');

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: --

Line 1379: fnd_message.raise_error;

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

Line 1395: fnd_message.set_name('PER','PER_289428_ADI_INTG_NOT_EXIST');

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: --

Line 1396: fnd_message.raise_error;

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