DBA Data[Home] [Help]

APPS.HR_KI_INTEGRATIONS_API dependencies on FND_MESSAGE

Line 464: fnd_message.set_name('PER','PER_449991_INT_API_IOID_INVAL');

460: l_fname5,l_fval5,l_fname6,l_fval6,l_fname7,l_fval7,l_fname8,
461: l_fval8,l_fname9,l_fval9;
462: if (csr_name%notfound) then
463: CLOSE csr_name;
464: fnd_message.set_name('PER','PER_449991_INT_API_IOID_INVAL');
465: fnd_message.raise_error;
466: end if;
467: CLOSE csr_name;
468:

Line 465: fnd_message.raise_error;

461: l_fval8,l_fname9,l_fval9;
462: if (csr_name%notfound) then
463: CLOSE csr_name;
464: fnd_message.set_name('PER','PER_449991_INT_API_IOID_INVAL');
465: fnd_message.raise_error;
466: end if;
467: CLOSE csr_name;
468:
469: hr_utility.set_location('Check for p_synched:'|| l_proc, 30);

Line 516: fnd_message.set_name('PER','PER_449993_INT_API_SSO_GRANT');

512: lv_sqlcode := SQLCODE;
513: lv_sqlerrm := SQLERRM;
514: IF (lv_sqlcode = -6550 and
515: instr(lv_sqlerrm,'WWSSO_PSTORE_EX.PSTORE_ADD_APPLICATION') > 0) THEN
516: fnd_message.set_name('PER','PER_449993_INT_API_SSO_GRANT');
517: fnd_message.raise_error;
518: else
519: fnd_message.set_name('PER','PER_449994_INT_API_SSO_EX');
520: fnd_message.raise_error;

Line 517: fnd_message.raise_error;

513: lv_sqlerrm := SQLERRM;
514: IF (lv_sqlcode = -6550 and
515: instr(lv_sqlerrm,'WWSSO_PSTORE_EX.PSTORE_ADD_APPLICATION') > 0) THEN
516: fnd_message.set_name('PER','PER_449993_INT_API_SSO_GRANT');
517: fnd_message.raise_error;
518: else
519: fnd_message.set_name('PER','PER_449994_INT_API_SSO_EX');
520: fnd_message.raise_error;
521:

Line 519: fnd_message.set_name('PER','PER_449994_INT_API_SSO_EX');

515: instr(lv_sqlerrm,'WWSSO_PSTORE_EX.PSTORE_ADD_APPLICATION') > 0) THEN
516: fnd_message.set_name('PER','PER_449993_INT_API_SSO_GRANT');
517: fnd_message.raise_error;
518: else
519: fnd_message.set_name('PER','PER_449994_INT_API_SSO_EX');
520: fnd_message.raise_error;
521:
522: end if;
523: end;

Line 520: fnd_message.raise_error;

516: fnd_message.set_name('PER','PER_449993_INT_API_SSO_GRANT');
517: fnd_message.raise_error;
518: else
519: fnd_message.set_name('PER','PER_449994_INT_API_SSO_EX');
520: fnd_message.raise_error;
521:
522: end if;
523: end;
524: --update integration table with synched set to Y

Line 550: fnd_message.set_name('PER','PER_449989_INT_API_SSO_INVAL');

546: ) then
547: --Throw Error
548: --
549:
550: fnd_message.set_name('PER','PER_449989_INT_API_SSO_INVAL');
551: fnd_message.raise_error;
552:
553: --This is case when SSO application is already created
554: --and SSO data is updated through loaders then synched will be N

Line 551: fnd_message.raise_error;

547: --Throw Error
548: --
549:
550: fnd_message.set_name('PER','PER_449989_INT_API_SSO_INVAL');
551: fnd_message.raise_error;
552:
553: --This is case when SSO application is already created
554: --and SSO data is updated through loaders then synched will be N
555: --Call update_integration_api to synch integration table and sso schema

Line 615: fnd_message.set_name('PER','PER_449992_INT_API_ECXDT_ABS');

611: fetch csr_ecx into l_key_ecx;
612: if (csr_ecx%notfound)
613: then
614: close csr_ecx;
615: fnd_message.set_name('PER','PER_449992_INT_API_ECXDT_ABS');
616: fnd_message.raise_error;
617: else
618: --update integration table with synched set to Y
619:

Line 616: fnd_message.raise_error;

612: if (csr_ecx%notfound)
613: then
614: close csr_ecx;
615: fnd_message.set_name('PER','PER_449992_INT_API_ECXDT_ABS');
616: fnd_message.raise_error;
617: else
618: --update integration table with synched set to Y
619:
620: close csr_ecx;

Line 902: fnd_message.set_name('PER','PER_449988_INT_API_STTT_INVL');

898: p_source_type <> 'URL' and p_source_type <> 'ECX')
899: or (p_target_type is null or p_target_type <> 'SSO'
900: and p_target_type <> 'URL' and p_target_type <> 'ECX')
901: ) then
902: fnd_message.set_name('PER','PER_449988_INT_API_STTT_INVL');
903: fnd_message.raise_error;
904: end if;
905: if (p_source_type = 'SSO') then
906: --make sure that ext_application_id is valid

Line 903: fnd_message.raise_error;

899: or (p_target_type is null or p_target_type <> 'SSO'
900: and p_target_type <> 'URL' and p_target_type <> 'ECX')
901: ) then
902: fnd_message.set_name('PER','PER_449988_INT_API_STTT_INVL');
903: fnd_message.raise_error;
904: end if;
905: if (p_source_type = 'SSO') then
906: --make sure that ext_application_id is valid
907: --and it exists for the integration_id passed in

Line 913: fnd_message.set_name('PER','PER_449990_INT_API_EXID_INVL');

909: open csr_extid;
910: fetch csr_extid into l_ext_application_id,l_extid;
911: if (csr_extid%notfound) then
912: close csr_extid;
913: fnd_message.set_name('PER','PER_449990_INT_API_EXID_INVL');
914: fnd_message.raise_error;
915: end if;
916: close csr_extid;
917: end if;

Line 914: fnd_message.raise_error;

910: fetch csr_extid into l_ext_application_id,l_extid;
911: if (csr_extid%notfound) then
912: close csr_extid;
913: fnd_message.set_name('PER','PER_449990_INT_API_EXID_INVL');
914: fnd_message.raise_error;
915: end if;
916: close csr_extid;
917: end if;
918:

Line 934: fnd_message.set_name('PER','PER_0000_INT_API_SSO_INVAL');

930: or p_user_field is null
931: or p_password_field is null
932: or p_authentication_needed is null )
933: then
934: fnd_message.set_name('PER','PER_0000_INT_API_SSO_INVAL');
935: fnd_message.raise_error;
936: end if;
937:
938: --user is trying to update some of the SSO columns,he may not pass

Line 935: fnd_message.raise_error;

931: or p_password_field is null
932: or p_authentication_needed is null )
933: then
934: fnd_message.set_name('PER','PER_0000_INT_API_SSO_INVAL');
935: fnd_message.raise_error;
936: end if;
937:
938: --user is trying to update some of the SSO columns,he may not pass
939: --the columns which he does not want to update,get these columns from

Line 987: fnd_message.set_name('PER','PER_0000_INT_API_SSO_INVAL');

983: or p_user_field is null or p_user_field =hr_api.g_varchar2
984: or p_password_field is null or p_password_field =hr_api.g_varchar2
985: or p_authentication_needed is null or p_authentication_needed =hr_api.g_varchar2
986: ) then
987: fnd_message.set_name('PER','PER_0000_INT_API_SSO_INVAL');
988: fnd_message.raise_error;
989: end if;
990: end if;
991: end if;

Line 988: fnd_message.raise_error;

984: or p_password_field is null or p_password_field =hr_api.g_varchar2
985: or p_authentication_needed is null or p_authentication_needed =hr_api.g_varchar2
986: ) then
987: fnd_message.set_name('PER','PER_0000_INT_API_SSO_INVAL');
988: fnd_message.raise_error;
989: end if;
990: end if;
991: end if;
992: if (p_source_type = p_target_type and p_source_type = 'SSO')then

Line 1089: fnd_message.set_name('PER','PER_0000_INT_API_SSO_GRANT');

1085: lv_sqlcode := SQLCODE;
1086: lv_sqlerrm := SQLERRM;
1087: IF (lv_sqlcode = -6550 and
1088: instr(lv_sqlerrm,'WWSSO_PSTORE_EX.PSTORE_ADD_APPLICATION') > 0) THEN
1089: fnd_message.set_name('PER','PER_0000_INT_API_SSO_GRANT');
1090: fnd_message.raise_error;
1091: else
1092: fnd_message.set_name('PER','PER_0000_INT_API_SSO_EX');
1093: fnd_message.raise_error;

Line 1090: fnd_message.raise_error;

1086: lv_sqlerrm := SQLERRM;
1087: IF (lv_sqlcode = -6550 and
1088: instr(lv_sqlerrm,'WWSSO_PSTORE_EX.PSTORE_ADD_APPLICATION') > 0) THEN
1089: fnd_message.set_name('PER','PER_0000_INT_API_SSO_GRANT');
1090: fnd_message.raise_error;
1091: else
1092: fnd_message.set_name('PER','PER_0000_INT_API_SSO_EX');
1093: fnd_message.raise_error;
1094:

Line 1092: fnd_message.set_name('PER','PER_0000_INT_API_SSO_EX');

1088: instr(lv_sqlerrm,'WWSSO_PSTORE_EX.PSTORE_ADD_APPLICATION') > 0) THEN
1089: fnd_message.set_name('PER','PER_0000_INT_API_SSO_GRANT');
1090: fnd_message.raise_error;
1091: else
1092: fnd_message.set_name('PER','PER_0000_INT_API_SSO_EX');
1093: fnd_message.raise_error;
1094:
1095: end if;
1096: end;

Line 1093: fnd_message.raise_error;

1089: fnd_message.set_name('PER','PER_0000_INT_API_SSO_GRANT');
1090: fnd_message.raise_error;
1091: else
1092: fnd_message.set_name('PER','PER_0000_INT_API_SSO_EX');
1093: fnd_message.raise_error;
1094:
1095: end if;
1096: end;
1097:

Line 1382: fnd_message.set_name('PER','PER_0000_INT_API_EXID_INVL');

1378: open csr_extid;
1379: fetch csr_extid into l_extid,l_eap_id;
1380: if (csr_extid%notfound) then
1381: close csr_extid;
1382: fnd_message.set_name('PER','PER_0000_INT_API_EXID_INVL');
1383: fnd_message.raise_error;
1384: end if;
1385: close csr_extid;
1386:

Line 1383: fnd_message.raise_error;

1379: fetch csr_extid into l_extid,l_eap_id;
1380: if (csr_extid%notfound) then
1381: close csr_extid;
1382: fnd_message.set_name('PER','PER_0000_INT_API_EXID_INVL');
1383: fnd_message.raise_error;
1384: end if;
1385: close csr_extid;
1386:
1387: --delete the application from SSO and then