eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HR_INT_BUS dependencies on HR_UTILITY

Line 111: hr_utility.set_location('Entering:'||l_proc,10);

107: from hr_ki_integrations
108: where integration_key = p_integration_key;
109: --
110: Begin
111: hr_utility.set_location('Entering:'||l_proc,10);
112: --
113: -- Check value has been passed
114: --
115: hr_api.mandatory_arg_error

Line 121: hr_utility.set_location('Validating:'||l_proc,20);

117: ,p_argument => 'INTEGRATION_KEY'
118: ,p_argument_value => p_integration_key
119: );
120:
121: hr_utility.set_location('Validating:'||l_proc,20);
122: open csr_name;
123: fetch csr_name into l_key;
124: if (csr_name%found)
125: then

Line 132: hr_utility.set_location(' Leaving:'||l_proc,30);

128: fnd_message.raise_error;
129: end if;
130: close csr_name;
131:
132: hr_utility.set_location(' Leaving:'||l_proc,30);
133: exception
134: when app_exception.application_exception then
135: if hr_multi_message.exception_add
136: (p_associated_column1 => 'HR_KI_INTEGRATIONS.INTEGRATION_KEY'

Line 138: hr_utility.set_location(' Leaving:'||l_proc, 40);

134: when app_exception.application_exception then
135: if hr_multi_message.exception_add
136: (p_associated_column1 => 'HR_KI_INTEGRATIONS.INTEGRATION_KEY'
137: )then
138: hr_utility.set_location(' Leaving:'||l_proc, 40);
139: raise;
140: end if;
141: hr_utility.set_location(' Leaving:'||l_proc,50);
142: End chk_integration_key;

Line 141: hr_utility.set_location(' Leaving:'||l_proc,50);

137: )then
138: hr_utility.set_location(' Leaving:'||l_proc, 40);
139: raise;
140: end if;
141: hr_utility.set_location(' Leaving:'||l_proc,50);
142: End chk_integration_key;
143:
144: -- ----------------------------------------------------------------------------
145: -- |---------------------------< CHK_SYNCHED>----------------------------------|

Line 178: hr_utility.set_location('Entering:'||l_proc,10);

174: l_proc varchar2(72) := g_package || 'chk_synched';
175:
176: --
177: Begin
178: hr_utility.set_location('Entering:'||l_proc,10);
179:
180: if p_url is not null then
181: p_synched := 'Y';
182: else

Line 186: hr_utility.set_location(' Leaving:'||l_proc,30);

182: else
183: p_synched := 'N';
184: end if;
185:
186: hr_utility.set_location(' Leaving:'||l_proc,30);
187: exception
188: when app_exception.application_exception then
189: if hr_multi_message.exception_add
190: (p_associated_column1 => 'HR_KI_INTEGRATIONS.SYNCHED'

Line 192: hr_utility.set_location(' Leaving:'||l_proc, 40);

188: when app_exception.application_exception then
189: if hr_multi_message.exception_add
190: (p_associated_column1 => 'HR_KI_INTEGRATIONS.SYNCHED'
191: )then
192: hr_utility.set_location(' Leaving:'||l_proc, 40);
193: raise;
194: end if;
195: hr_utility.set_location(' Leaving:'||l_proc,50);
196: End chk_synched;

Line 195: hr_utility.set_location(' Leaving:'||l_proc,50);

191: )then
192: hr_utility.set_location(' Leaving:'||l_proc, 40);
193: raise;
194: end if;
195: hr_utility.set_location(' Leaving:'||l_proc,50);
196: End chk_synched;
197:
198: -- ----------------------------------------------------------------------------
199: -- |---------------------------< CHK_SYNCHED_UPD>-----------------------------|

Line 232: hr_utility.set_location('Entering:'||l_proc,10);

228: l_proc varchar2(72) := g_package || 'chk_synched_upd';
229:
230: --
231: Begin
232: hr_utility.set_location('Entering:'||l_proc,10);
233: --
234: -- Check value has been passed
235: --
236: hr_api.mandatory_arg_error

Line 242: hr_utility.set_location('Validating:'||l_proc,20);

238: ,p_argument => 'SYNCHED'
239: ,p_argument_value => p_synched
240: );
241:
242: hr_utility.set_location('Validating:'||l_proc,20);
243:
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

Line 258: hr_utility.set_location(' Leaving:'||l_proc,30);

254: fnd_message.raise_error;
255:
256: end if;
257:
258: hr_utility.set_location(' Leaving:'||l_proc,30);
259: exception
260: when app_exception.application_exception then
261: if hr_multi_message.exception_add
262: (p_associated_column1 => 'HR_KI_INTEGRATIONS.SYNCHED'

Line 264: hr_utility.set_location(' Leaving:'||l_proc, 40);

260: when app_exception.application_exception then
261: if hr_multi_message.exception_add
262: (p_associated_column1 => 'HR_KI_INTEGRATIONS.SYNCHED'
263: )then
264: hr_utility.set_location(' Leaving:'||l_proc, 40);
265: raise;
266: end if;
267: hr_utility.set_location(' Leaving:'||l_proc,50);
268: End chk_synched_upd;

Line 267: hr_utility.set_location(' Leaving:'||l_proc,50);

263: )then
264: hr_utility.set_location(' Leaving:'||l_proc, 40);
265: raise;
266: end if;
267: hr_utility.set_location(' Leaving:'||l_proc,50);
268: End chk_synched_upd;
269:
270: -- ----------------------------------------------------------------------------
271: -- |---------------------------------------------------------|

Line 350: hr_utility.set_location('Entering:'||l_proc,10);

346: and authentication_needed=p_authentication_needed
347: and integration_id<>p_integration_id;
348: --
349: Begin
350: hr_utility.set_location('Entering:'||l_proc,10);
351:
352: -- Only proceed with record validation when the
353: -- Multiple Message List does not already contain an errors
354: -- associated with the party_name

Line 394: hr_utility.set_location('Validating:'||l_proc,20);

390: fnd_message.raise_error;
391: end if;
392: end if;
393:
394: hr_utility.set_location('Validating:'||l_proc,20);
395:
396: --for only URL case
397: --all SSO details will be null so this IF condition!
398:

Line 408: hr_utility.set_location('Validating combination'||l_proc,30);

404: or p_password_field is not null
405: or p_authentication_needed is not null
406: )then
407:
408: hr_utility.set_location('Validating combination'||l_proc,30);
409: --
410: --Check if SSO combination already exists in the hr_ki_integrations table.
411: --
412: if(p_insert ='insert') then

Line 442: hr_utility.set_location(' Leaving:'||l_proc, 40);

438: when app_exception.application_exception then
439: if hr_multi_message.exception_add
440: (p_associated_column1 => 'HR_KI_INTEGRATIONS.EXT_APPLICATION_ID'
441: )then
442: hr_utility.set_location(' Leaving:'||l_proc, 40);
443: raise;
444: end if;
445: hr_utility.set_location(' Leaving:'||l_proc,50);
446: End CHK_SSO_DETAILS;

Line 445: hr_utility.set_location(' Leaving:'||l_proc,50);

441: )then
442: hr_utility.set_location(' Leaving:'||l_proc, 40);
443: raise;
444: end if;
445: hr_utility.set_location(' Leaving:'||l_proc,50);
446: End CHK_SSO_DETAILS;
447: -- ----------------------------------------------------------------------------
448: -- |---------------------< CHK_EXT_APPLICATION_ID_UPD>------------------------|
449: -- ----------------------------------------------------------------------------

Line 495: hr_utility.set_location('Entering:'||l_proc,10);

491: where ext_application_id = p_ext_application_id
492: and integration_id<>p_integration_id;
493: --
494: Begin
495: hr_utility.set_location('Entering:'||l_proc,10);
496: --
497: -- Check value has been passed
498: --
499: if hr_multi_message.no_exclusive_error

Line 506: hr_utility.set_location('Validating ID:'||l_proc,20);

502: ) then
503:
504: if p_ext_application_id is not null then
505:
506: hr_utility.set_location('Validating ID:'||l_proc,20);
507:
508: open csr_name;
509: fetch csr_name into l_key;
510: if (csr_name%notfound)

Line 521: hr_utility.set_location('Validating ID in Integrations table:'||l_proc,30);

517:
518: --Now check if ext_application_id is already present in the
519: --hr_ki_integrations table
520:
521: hr_utility.set_location('Validating ID in Integrations table:'||l_proc,30);
522: open csr_app;
523: fetch csr_app into l_key_app;
524: if (csr_app%found)
525: then

Line 535: hr_utility.set_location(' Leaving:'||l_proc,30);

531:
532: end if;
533:
534: end if;
535: hr_utility.set_location(' Leaving:'||l_proc,30);
536: exception
537: when app_exception.application_exception then
538: if hr_multi_message.exception_add
539: (p_associated_column1 => 'HR_KI_INTEGRATIONS.EXT_APPLICATION_ID'

Line 541: hr_utility.set_location(' Leaving:'||l_proc, 40);

537: when app_exception.application_exception then
538: if hr_multi_message.exception_add
539: (p_associated_column1 => 'HR_KI_INTEGRATIONS.EXT_APPLICATION_ID'
540: )then
541: hr_utility.set_location(' Leaving:'||l_proc, 40);
542: raise;
543: end if;
544: hr_utility.set_location(' Leaving:'||l_proc,50);
545: End CHK_EXT_APPLICATION_ID_UPD;

Line 544: hr_utility.set_location(' Leaving:'||l_proc,50);

540: )then
541: hr_utility.set_location(' Leaving:'||l_proc, 40);
542: raise;
543: end if;
544: hr_utility.set_location(' Leaving:'||l_proc,50);
545: End CHK_EXT_APPLICATION_ID_UPD;
546:
547: -- ----------------------------------------------------------------------------
548: -- |---------------------------------------------------------|

Line 628: hr_utility.set_location('Entering:'||l_proc,10);

624: and trans_direction=p_trans_direction
625: and integration_id<>p_integration_id;
626: --
627: Begin
628: hr_utility.set_location('Entering:'||l_proc,10);
629:
630: -- Only proceed with record validation when the
631: -- Multiple Message List does not already contain an errors
632: -- associated with the party_name

Line 665: hr_utility.set_location('Validating:'||l_proc,20);

661: fnd_message.raise_error;
662: end if;
663: end if;
664:
665: hr_utility.set_location('Validating:'||l_proc,20);
666:
667: if ( p_party_type is not null
668: and p_party_name is not null
669: and p_party_site_name is not null

Line 677: hr_utility.set_location('Validating combination'||l_proc,30);

673: and p_ext_trans_type is not null
674: and p_ext_trans_subtype is not null
675: and p_trans_direction is not null )then
676:
677: hr_utility.set_location('Validating combination'||l_proc,30);
678: --
679: --Check if ECX combination already exists in the hr_ki_integrations table.
680: --
681: --For insert use csr_ecx cursor since integration_id will be null

Line 712: hr_utility.set_location(' Leaving:'||l_proc, 40);

708: when app_exception.application_exception then
709: if hr_multi_message.exception_add
710: (p_associated_column1 => 'HR_KI_INTEGRATIONS.PARTY_NAME'
711: )then
712: hr_utility.set_location(' Leaving:'||l_proc, 40);
713: raise;
714: end if;
715: hr_utility.set_location(' Leaving:'||l_proc,50);
716: End CHK_ECX_DETAILS;

Line 715: hr_utility.set_location(' Leaving:'||l_proc,50);

711: )then
712: hr_utility.set_location(' Leaving:'||l_proc, 40);
713: raise;
714: end if;
715: hr_utility.set_location(' Leaving:'||l_proc,50);
716: End CHK_ECX_DETAILS;
717:
718:
719: -- ----------------------------------------------------------------------------

Line 787: hr_utility.set_location('Entering:'||l_proc,10);

783: --
784: l_proc varchar2(72) := g_package || 'CHK_INTEGRATION_RECORD';
785: --
786: Begin
787: hr_utility.set_location('Entering:'||l_proc,10);
788:
789:
790: --At least one column out of url,ext_application_id and ecx column should
791: -- be not null

Line 816: hr_utility.set_location('Validating extAppId:'||l_proc,20);

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:
818: --for SSO type of integrations url and ecx details should be null
819:
820: if (p_ext_application_id is not null

Line 849: hr_utility.set_location('Validating ECX:'||l_proc,30);

845:
846: end if;
847:
848:
849: hr_utility.set_location('Validating ECX:'||l_proc,30);
850: --
851: --for ECX type of integrations url and SSO details
852: --should be null
853:

Line 879: hr_utility.set_location('Validating URL:'||l_proc,40);

875: end if;
876:
877: end if;
878:
879: hr_utility.set_location('Validating URL:'||l_proc,40);
880: --
881: --for simple URL type of integrations ,SSO details
882: --and ecx details should be null
883:

Line 919: hr_utility.set_location(' Leaving:'||l_proc, 50);

915: (p_associated_column1 => 'HR_KI_INTEGRATIONS.URL'
916: ,p_associated_column2 => 'HR_KI_INTEGRATIONS.EXT_APPLICATION_ID'
917: ,p_associated_column3 => 'HR_KI_INTEGRATIONS.PARTY_NAME'
918: )then
919: hr_utility.set_location(' Leaving:'||l_proc, 50);
920: raise;
921: end if;
922: hr_utility.set_location(' Leaving:'||l_proc,60);
923: End CHK_INTEGRATION_RECORD;

Line 922: hr_utility.set_location(' Leaving:'||l_proc,60);

918: )then
919: hr_utility.set_location(' Leaving:'||l_proc, 50);
920: raise;
921: end if;
922: hr_utility.set_location(' Leaving:'||l_proc,60);
923: End CHK_INTEGRATION_RECORD;
924:
925: -- ----------------------------------------------------------------------------
926: -- -------------------------------< CHK_DELETE>--------------------------------

Line 987: hr_utility.set_location('Entering:'|| l_proc, 10);

983: and inte.ext_application_id=ext.ext_application_id;
984:
985: --
986: begin
987: hr_utility.set_location('Entering:'|| l_proc, 10);
988: --
989: -- Can always execute the cursor as chk_delete
990: -- will only be called for delete validation
991: -- from within the row handler.

Line 1011: hr_utility.set_location('Checking for Topic Integrations:'|| l_proc, 20);

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;

Line 1021: hr_utility.set_location('Checking for TL:'|| l_proc, 30);

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;

Line 1031: hr_utility.set_location(' Leaving:'|| l_proc, 40);

1027: fnd_message.raise_error;
1028: end if;
1029: close csr_maintenance_tl;
1030:
1031: hr_utility.set_location(' Leaving:'|| l_proc, 40);
1032: exception
1033: when app_exception.application_exception then
1034: if hr_multi_message.exception_add
1035: (p_associated_column1 => 'HR_KI_INTEGRATIONS.integration_id'

Line 1037: hr_utility.set_location(' Leaving:'|| l_proc, 50);

1033: when app_exception.application_exception then
1034: if hr_multi_message.exception_add
1035: (p_associated_column1 => 'HR_KI_INTEGRATIONS.integration_id'
1036: ) then
1037: hr_utility.set_location(' Leaving:'|| l_proc, 50);
1038: raise;
1039: end if;
1040: hr_utility.set_location(' Leaving:'|| l_proc, 60);
1041: end chk_delete;

Line 1040: hr_utility.set_location(' Leaving:'|| l_proc, 60);

1036: ) then
1037: hr_utility.set_location(' Leaving:'|| l_proc, 50);
1038: raise;
1039: end if;
1040: hr_utility.set_location(' Leaving:'|| l_proc, 60);
1041: end chk_delete;
1042:
1043:
1044: --

Line 1055: hr_utility.set_location('Entering:'||l_proc, 5);

1051: --
1052: l_proc varchar2(72) := g_package||'insert_validate';
1053: --
1054: Begin
1055: hr_utility.set_location('Entering:'||l_proc, 5);
1056: --
1057: -- Call all supporting business operations
1058: --
1059: --

Line 1126: hr_utility.set_location(' Leaving:'||l_proc, 10);

1122: p_synched => p_rec.synched
1123: ,p_url =>p_rec.url
1124: );
1125:
1126: hr_utility.set_location(' Leaving:'||l_proc, 10);
1127: End insert_validate;
1128: --
1129: -- ----------------------------------------------------------------------------
1130: -- |---------------------------< update_validate >----------------------------|

Line 1139: hr_utility.set_location('Entering:'||l_proc, 5);

1135: --
1136: l_proc varchar2(72) := g_package||'update_validate';
1137: --
1138: Begin
1139: hr_utility.set_location('Entering:'||l_proc, 5);
1140: --
1141: -- Call all supporting business operations
1142: --
1143: --

Line 1215: hr_utility.set_location(' Leaving:'||l_proc, 10);

1211: );
1212:
1213: --
1214: --
1215: hr_utility.set_location(' Leaving:'||l_proc, 10);
1216: End update_validate;
1217: --
1218: -- ----------------------------------------------------------------------------
1219: -- |---------------------------< delete_validate >----------------------------|

Line 1228: hr_utility.set_location('Entering:'||l_proc, 5);

1224: --
1225: l_proc varchar2(72) := g_package||'delete_validate';
1226: --
1227: Begin
1228: hr_utility.set_location('Entering:'||l_proc, 5);
1229: --
1230: -- Call all supporting business operations
1231: --
1232: CHK_DELETE

Line 1236: hr_utility.set_location(' Leaving:'||l_proc, 10);

1232: CHK_DELETE
1233: (
1234: p_integration_id =>p_rec.integration_id
1235: );
1236: hr_utility.set_location(' Leaving:'||l_proc, 10);
1237: End delete_validate;
1238: --
1239: end hr_int_bus;