DBA Data[Home] [Help]

APPS.HR_INTEGRATION_UTILS dependencies on FND_MESSAGE

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

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

Line 790: fnd_message.set_name('PER','PER_ADI_PARAM_NAME_EXISTS');

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

Line 791: fnd_message.raise_error;

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

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

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

Line 882: fnd_message.raise_error;

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;

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

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;

Line 900: fnd_message.raise_error;

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

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

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;

Line 1043: fnd_message.raise_error;

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

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

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

Line 1055: fnd_message.raise_error;

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

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

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;

Line 1075: fnd_message.raise_error;

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

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

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

Line 1165: fnd_message.raise_error;

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

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

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

Line 1177: fnd_message.raise_error;

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

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

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;

Line 1193: fnd_message.raise_error;

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

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

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

Line 1207: fnd_message.raise_error;

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

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

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;

Line 1275: fnd_message.raise_error;

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

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

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

Line 1296: fnd_message.raise_error;

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;

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

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

Line 1306: fnd_message.raise_error;

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

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

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

Line 1318: fnd_message.raise_error;

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

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

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

Line 1376: fnd_message.raise_error;

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

Line 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

Line 1381: 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
1385: --

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

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

Line 1392: fnd_message.raise_error;

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

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

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

Line 1409: fnd_message.raise_error;

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