53: IF NOT hr_int_shd.api_updating
54: (p_integration_id => p_rec.integration_id
55: ,p_object_version_number => p_rec.object_version_number
56: ) THEN
57: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
58: fnd_message.set_token('PROCEDURE ', l_proc);
59: fnd_message.set_token('STEP ', '5');
60: fnd_message.raise_error;
61: END IF;
54: (p_integration_id => p_rec.integration_id
55: ,p_object_version_number => p_rec.object_version_number
56: ) THEN
57: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
58: fnd_message.set_token('PROCEDURE ', l_proc);
59: fnd_message.set_token('STEP ', '5');
60: fnd_message.raise_error;
61: END IF;
62:
55: ,p_object_version_number => p_rec.object_version_number
56: ) THEN
57: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
58: fnd_message.set_token('PROCEDURE ', l_proc);
59: fnd_message.set_token('STEP ', '5');
60: fnd_message.raise_error;
61: END IF;
62:
63: if nvl(p_rec.integration_key, hr_api.g_varchar2) <>
56: ) THEN
57: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
58: fnd_message.set_token('PROCEDURE ', l_proc);
59: fnd_message.set_token('STEP ', '5');
60: fnd_message.raise_error;
61: END IF;
62:
63: if nvl(p_rec.integration_key, hr_api.g_varchar2) <>
64: nvl(hr_int_shd.g_old_rec.integration_key
123: fetch csr_name into l_key;
124: if (csr_name%found)
125: then
126: close csr_name;
127: fnd_message.set_name('PER','PER_449965_INT_IN_KEY_DUP');
128: fnd_message.raise_error;
129: end if;
130: close csr_name;
131:
124: if (csr_name%found)
125: then
126: close csr_name;
127: fnd_message.set_name('PER','PER_449965_INT_IN_KEY_DUP');
128: fnd_message.raise_error;
129: end if;
130: close csr_name;
131:
132: hr_utility.set_location(' Leaving:'||l_proc,30);
244: if upper(p_synched) ='Y' or upper(p_synched)='N' then
245:
246: if (upper(p_synched) ='N' and p_url is not null ) then
247: --For URL type of integration synched should be Y
248: fnd_message.set_name('PER', 'PER_449973_INT_URL_SYND_INVAL');
249: fnd_message.raise_error;
250: end if;
251:
252: else
245:
246: if (upper(p_synched) ='N' and p_url is not null ) then
247: --For URL type of integration synched should be Y
248: fnd_message.set_name('PER', 'PER_449973_INT_URL_SYND_INVAL');
249: fnd_message.raise_error;
250: end if;
251:
252: else
253: fnd_message.set_name('PER', 'PER_449974_INT_SYNCHED_INVAL');
249: fnd_message.raise_error;
250: end if;
251:
252: else
253: fnd_message.set_name('PER', 'PER_449974_INT_SYNCHED_INVAL');
254: fnd_message.raise_error;
255:
256: end if;
257:
250: end if;
251:
252: else
253: fnd_message.set_name('PER', 'PER_449974_INT_SYNCHED_INVAL');
254: fnd_message.raise_error;
255:
256: end if;
257:
258: hr_utility.set_location(' Leaving:'||l_proc,30);
361:
362: --For insert mode ext_application_id must be null
363: if(p_insert ='insert') then
364: if(p_ext_application_id is not null) then
365: fnd_message.set_name('PER','PER_449976_INT_SSO_ID_INVALID');
366: fnd_message.raise_error;
367: end if;
368: end if;
369:
362: --For insert mode ext_application_id must be null
363: if(p_insert ='insert') then
364: if(p_ext_application_id is not null) then
365: fnd_message.set_name('PER','PER_449976_INT_SSO_ID_INVALID');
366: fnd_message.raise_error;
367: end if;
368: end if;
369:
370: --If any ofthe SSO parameters are not null then validate SSO details
385: or p_user_field is null
386: or p_password_field is null
387: or p_authentication_needed is null
388: ) then
389: fnd_message.set_name('PER','PER_449977_INT_SSO_COL_INVALID');
390: fnd_message.raise_error;
391: end if;
392: end if;
393:
386: or p_password_field is null
387: or p_authentication_needed is null
388: ) then
389: fnd_message.set_name('PER','PER_449977_INT_SSO_COL_INVALID');
390: fnd_message.raise_error;
391: end if;
392: end if;
393:
394: hr_utility.set_location('Validating:'||l_proc,20);
414: fetch csr_sso into l_key_sso;
415: if (csr_sso%found)
416: then
417: close csr_sso;
418: fnd_message.set_name('PER','PER_449978_INT_SSO_DT_DUPLI');
419: fnd_message.raise_error;
420: end if;
421: close csr_sso;
422: else
415: if (csr_sso%found)
416: then
417: close csr_sso;
418: fnd_message.set_name('PER','PER_449978_INT_SSO_DT_DUPLI');
419: fnd_message.raise_error;
420: end if;
421: close csr_sso;
422: else
423: open csr_sso_upd;
424: fetch csr_sso_upd into l_key_sso_upd;
425: if (csr_sso_upd%found)
426: then
427: close csr_sso_upd;
428: fnd_message.set_name('PER','PER_449978_INT_SSO_DT_DUPLI');
429: fnd_message.raise_error;
430: end if;
431: close csr_sso_upd;
432: end if;
425: if (csr_sso_upd%found)
426: then
427: close csr_sso_upd;
428: fnd_message.set_name('PER','PER_449978_INT_SSO_DT_DUPLI');
429: fnd_message.raise_error;
430: end if;
431: close csr_sso_upd;
432: end if;
433:
509: fetch csr_name into l_key;
510: if (csr_name%notfound)
511: then
512: close csr_name;
513: fnd_message.set_name('PER','PER_449970_INT_EXT_ID_ABSENT');
514: fnd_message.raise_error;
515: end if;
516: close csr_name;
517:
510: if (csr_name%notfound)
511: then
512: close csr_name;
513: fnd_message.set_name('PER','PER_449970_INT_EXT_ID_ABSENT');
514: fnd_message.raise_error;
515: end if;
516: close csr_name;
517:
518: --Now check if ext_application_id is already present in the
523: fetch csr_app into l_key_app;
524: if (csr_app%found)
525: then
526: close csr_app;
527: fnd_message.set_name('PER','PER_449971_INT_EXT_ID_DUPLI');
528: fnd_message.raise_error;
529: end if;
530: close csr_app;
531:
524: if (csr_app%found)
525: then
526: close csr_app;
527: fnd_message.set_name('PER','PER_449971_INT_EXT_ID_DUPLI');
528: fnd_message.raise_error;
529: end if;
530: close csr_app;
531:
532: end if;
656: or p_ext_trans_type is null
657: or p_ext_trans_subtype is null
658: or p_trans_direction is null
659: ) then
660: fnd_message.set_name('PER','PER_449967_INT_ECX_COL_INVALID');
661: fnd_message.raise_error;
662: end if;
663: end if;
664:
657: or p_ext_trans_subtype is null
658: or p_trans_direction is null
659: ) then
660: fnd_message.set_name('PER','PER_449967_INT_ECX_COL_INVALID');
661: fnd_message.raise_error;
662: end if;
663: end if;
664:
665: hr_utility.set_location('Validating:'||l_proc,20);
685: fetch csr_ecx into l_key_ecx;
686: if (csr_ecx%found)
687: then
688: close csr_ecx;
689: fnd_message.set_name('PER','PER_449969_INT_ECX_DT_DUPLI');
690: fnd_message.raise_error;
691: end if;
692: close csr_ecx;
693: else
686: if (csr_ecx%found)
687: then
688: close csr_ecx;
689: fnd_message.set_name('PER','PER_449969_INT_ECX_DT_DUPLI');
690: fnd_message.raise_error;
691: end if;
692: close csr_ecx;
693: else
694: open csr_ecx_upd;
695: fetch csr_ecx_upd into l_key_ecx_upd;
696: if (csr_ecx_upd%found)
697: then
698: close csr_ecx_upd;
699: fnd_message.set_name('PER','PER_449969_INT_ECX_DT_DUPLI');
700: fnd_message.raise_error;
701: end if;
702: close csr_ecx_upd;
703: end if;
696: if (csr_ecx_upd%found)
697: then
698: close csr_ecx_upd;
699: fnd_message.set_name('PER','PER_449969_INT_ECX_DT_DUPLI');
700: fnd_message.raise_error;
701: end if;
702: close csr_ecx_upd;
703: end if;
704: end if;
808: and p_ext_trans_type is null
809: and p_ext_trans_subtype is null
810: and p_trans_direction is null
811: ) then
812: fnd_message.set_name('PER', 'PER_449966_INT_MAN_COL_NULL');
813: fnd_message.raise_error;
814: end if;
815:
816: hr_utility.set_location('Validating extAppId:'||l_proc,20);
809: and p_ext_trans_subtype is null
810: and p_trans_direction is null
811: ) then
812: fnd_message.set_name('PER', 'PER_449966_INT_MAN_COL_NULL');
813: fnd_message.raise_error;
814: end if;
815:
816: hr_utility.set_location('Validating extAppId:'||l_proc,20);
817:
838: or p_ext_trans_subtype is not null
839: or p_trans_direction is not null
840: ) then
841:
842: fnd_message.set_name('PER', 'PER_449975_INT_U_E_S_INVALID');
843: fnd_message.raise_error;
844: end if;
845:
846: end if;
839: or p_trans_direction is not null
840: ) then
841:
842: fnd_message.set_name('PER', 'PER_449975_INT_U_E_S_INVALID');
843: fnd_message.raise_error;
844: end if;
845:
846: end if;
847:
869: or p_logout_url is not null
870: or p_user_field is not null
871: or p_password_field is not null
872: ) then
873: fnd_message.set_name('PER', 'PER_449975_INT_U_E_S_INVALID');
874: fnd_message.raise_error;
875: end if;
876:
877: end if;
870: or p_user_field is not null
871: or p_password_field is not null
872: ) then
873: fnd_message.set_name('PER', 'PER_449975_INT_U_E_S_INVALID');
874: fnd_message.raise_error;
875: end if;
876:
877: end if;
878:
900: or p_ext_trans_type is not null
901: or p_ext_trans_subtype is not null
902: or p_trans_direction is not null
903: ) then
904: fnd_message.set_name('PER', 'PER_449975_INT_U_E_S_INVALID');
905: fnd_message.raise_error;
906: end if;
907:
908: end if;
901: or p_ext_trans_subtype is not null
902: or p_trans_direction is not null
903: ) then
904: fnd_message.set_name('PER', 'PER_449975_INT_U_E_S_INVALID');
905: fnd_message.raise_error;
906: end if;
907:
908: end if;
909:
993: open csr_maintenance_option;
994: fetch csr_maintenance_option into l_exists;
995: if csr_maintenance_option%found then
996: close csr_maintenance_option;
997: fnd_message.set_name('PER', 'PER_449979_INT_OPT_MAIN_EXIST');
998: fnd_message.raise_error;
999: end if;
1000: close csr_maintenance_option;
1001:
994: fetch csr_maintenance_option into l_exists;
995: if csr_maintenance_option%found then
996: close csr_maintenance_option;
997: fnd_message.set_name('PER', 'PER_449979_INT_OPT_MAIN_EXIST');
998: fnd_message.raise_error;
999: end if;
1000: close csr_maintenance_option;
1001:
1002: open csr_maintenance_extapp;
1002: open csr_maintenance_extapp;
1003: fetch csr_maintenance_extapp into l_exists_ext;
1004: if csr_maintenance_extapp%found then
1005: close csr_maintenance_extapp;
1006: fnd_message.set_name('PER', 'PER_449982_INT_EXT_MAIN_EXIST');
1007: fnd_message.raise_error;
1008: end if;
1009: close csr_maintenance_extapp;
1010:
1003: fetch csr_maintenance_extapp into l_exists_ext;
1004: if csr_maintenance_extapp%found then
1005: close csr_maintenance_extapp;
1006: fnd_message.set_name('PER', 'PER_449982_INT_EXT_MAIN_EXIST');
1007: fnd_message.raise_error;
1008: end if;
1009: close csr_maintenance_extapp;
1010:
1011: hr_utility.set_location('Checking for Topic Integrations:'|| l_proc, 20);
1012: open csr_maintenance_ti;
1013: fetch csr_maintenance_ti into l_exists_ti;
1014: if csr_maintenance_ti%found then
1015: close csr_maintenance_ti;
1016: fnd_message.set_name('PER', 'PER_449980_INT_TOIN_EXIST');
1017: fnd_message.raise_error;
1018: end if;
1019: close csr_maintenance_ti;
1020:
1013: fetch csr_maintenance_ti into l_exists_ti;
1014: if csr_maintenance_ti%found then
1015: close csr_maintenance_ti;
1016: fnd_message.set_name('PER', 'PER_449980_INT_TOIN_EXIST');
1017: fnd_message.raise_error;
1018: end if;
1019: close csr_maintenance_ti;
1020:
1021: hr_utility.set_location('Checking for TL:'|| l_proc, 30);
1022: open csr_maintenance_tl;
1023: fetch csr_maintenance_tl into l_exists_tl;
1024: if csr_maintenance_tl%found then
1025: close csr_maintenance_tl;
1026: fnd_message.set_name('PER', 'PER_449981_INT_TL_EXIST');
1027: fnd_message.raise_error;
1028: end if;
1029: close csr_maintenance_tl;
1030:
1023: fetch csr_maintenance_tl into l_exists_tl;
1024: if csr_maintenance_tl%found then
1025: close csr_maintenance_tl;
1026: fnd_message.set_name('PER', 'PER_449981_INT_TL_EXIST');
1027: fnd_message.raise_error;
1028: end if;
1029: close csr_maintenance_tl;
1030:
1031: hr_utility.set_location(' Leaving:'|| l_proc, 40);