DBA Data[Home] [Help]

APPS.HR_INT_BUS dependencies on FND_MESSAGE

Line 57: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');

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;

Line 58: fnd_message.set_token('PROCEDURE ', l_proc);

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:

Line 59: fnd_message.set_token('STEP ', '5');

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

Line 60: fnd_message.raise_error;

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

Line 127: fnd_message.set_name('PER','PER_449965_INT_IN_KEY_DUP');

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:

Line 128: fnd_message.raise_error;

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

Line 248: fnd_message.set_name('PER', 'PER_449973_INT_URL_SYND_INVAL');

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

Line 249: fnd_message.raise_error;

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

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

Line 254: 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:
258: hr_utility.set_location(' Leaving:'||l_proc,30);

Line 365: fnd_message.set_name('PER','PER_449976_INT_SSO_ID_INVALID');

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:

Line 366: fnd_message.raise_error;

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

Line 389: fnd_message.set_name('PER','PER_449977_INT_SSO_COL_INVALID');

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:

Line 390: fnd_message.raise_error;

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

Line 418: fnd_message.set_name('PER','PER_449978_INT_SSO_DT_DUPLI');

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

Line 419: fnd_message.raise_error;

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;

Line 428: fnd_message.set_name('PER','PER_449978_INT_SSO_DT_DUPLI');

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;

Line 429: fnd_message.raise_error;

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:

Line 513: fnd_message.set_name('PER','PER_449970_INT_EXT_ID_ABSENT');

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:

Line 514: fnd_message.raise_error;

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

Line 527: fnd_message.set_name('PER','PER_449971_INT_EXT_ID_DUPLI');

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:

Line 528: fnd_message.raise_error;

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;

Line 660: fnd_message.set_name('PER','PER_449967_INT_ECX_COL_INVALID');

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:

Line 661: fnd_message.raise_error;

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

Line 689: fnd_message.set_name('PER','PER_449969_INT_ECX_DT_DUPLI');

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

Line 690: fnd_message.raise_error;

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;

Line 699: fnd_message.set_name('PER','PER_449969_INT_ECX_DT_DUPLI');

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;

Line 700: fnd_message.raise_error;

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;

Line 812: fnd_message.set_name('PER', 'PER_449966_INT_MAN_COL_NULL');

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

Line 813: fnd_message.raise_error;

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:

Line 842: fnd_message.set_name('PER', 'PER_449975_INT_U_E_S_INVALID');

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;

Line 843: fnd_message.raise_error;

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:

Line 873: fnd_message.set_name('PER', 'PER_449975_INT_U_E_S_INVALID');

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;

Line 874: fnd_message.raise_error;

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:

Line 904: fnd_message.set_name('PER', 'PER_449975_INT_U_E_S_INVALID');

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;

Line 905: fnd_message.raise_error;

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:

Line 997: fnd_message.set_name('PER', 'PER_449979_INT_OPT_MAIN_EXIST');

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:

Line 998: fnd_message.raise_error;

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;

Line 1006: fnd_message.set_name('PER', 'PER_449982_INT_EXT_MAIN_EXIST');

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:

Line 1007: fnd_message.raise_error;

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

Line 1016: fnd_message.set_name('PER', 'PER_449980_INT_TOIN_EXIST');

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:

Line 1017: fnd_message.raise_error;

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

Line 1026: fnd_message.set_name('PER', 'PER_449981_INT_TL_EXIST');

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:

Line 1027: fnd_message.raise_error;

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