[Home] [Help]
62: l_language_code varchar2(30);
63: l_object_version_number number;
64:
65: begin
66: hr_utility.set_location('Entering:'|| l_proc, 10);
67: --
68: -- Issue a savepoint
69: --
70: savepoint create_integration;
256: p_integration_id := l_integration_id;
257: p_object_version_number := l_object_version_number;
258:
259: --
260: hr_utility.set_location(' Leaving:'||l_proc, 70);
261: exception
262: when hr_api.validate_enabled then
263: --
264: -- As the Validate_Enabled exception has been raised
273:
274: p_integration_id := null;
275: p_object_version_number := null;
276:
277: hr_utility.set_location(' Leaving:'||l_proc, 80);
278: when others then
279: --
280: -- A validation or unexpected error has occured
281: --
287:
288: p_integration_id := null;
289: p_object_version_number := null;
290:
291: hr_utility.set_location(' Leaving:'||l_proc, 90);
292: raise;
293: end create_integration;
294:
295:
417: lv_sqlcode NUMBER;
418: lv_sqlerrm VARCHAR2(240);
419:
420: begin
421: hr_utility.set_location('Entering:'|| l_proc, 10);
422: --
423: -- Issue a savepoint
424: --
425: savepoint validate_integration;
448:
449: --
450: -- Process Logic
451: --
452: hr_utility.set_location('Start:'|| l_proc, 20);
453: OPEN csr_name;
454: FETCH csr_name INTO l_synched,l_party_type,l_party_name,
455: l_party_site_name,l_transaction_type,l_transaction_sub_type,
456: l_standard_code,l_ext_trans_type,l_ext_trans_sub_type,
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);
470: If l_synched='N' then
471: --Check if it is SSO with ext-application-id null
472: if (l_ext_application_id is null and l_app_code is not null
473: and l_apptype is not null and l_appurl is not null
473: and l_apptype is not null and l_appurl is not null
474: and l_logout_url is not null and l_userfld is not null and
475: l_pwdfld is not null and l_authused is not null) then
476:
477: hr_utility.set_location('Registering in SSO:'|| l_proc, 40);
478:
479: --Call register to create entry in SSO
480: begin
481:
523: end;
524: --update integration table with synched set to Y
525: --and newly generated ext_application_id
526:
527: hr_utility.set_location('Updating integration:'|| l_proc, 50);
528: hr_int_upd.upd
529: (
530: p_synched => 'Y'
531: ,p_ext_application_id => l_ext_application_id
601: and l_ext_trans_type is not null and l_ext_trans_sub_type is not null
602: and l_trans_direction is not null
603: ) then
604:
605: hr_utility.set_location('Validate against ECX:'|| l_proc, 60);
606:
607: open csr_ecx(l_party_type,l_party_name,l_party_site_name,
608: l_transaction_type,l_transaction_sub_type,l_standard_code,
609: l_ext_trans_type,l_ext_trans_sub_type,l_trans_direction
618: --update integration table with synched set to Y
619:
620: close csr_ecx;
621:
622: hr_utility.set_location('ECX Update integrations:'|| l_proc, 70);
623:
624: hr_int_upd.upd
625: (
626: p_synched => 'Y'
632:
633: end if;
634:
635: end if;
636: hr_utility.set_location('Before after user hook:'|| l_proc, 80);
637:
638: --
639: -- Call After Process User Hook
640: --
662: -- Set all IN OUT and OUT parameters with out values
663: --
664: -- p_object_version_number := l_object_version_number;
665: --
666: hr_utility.set_location(' Leaving:'||l_proc, 90);
667: exception
668: when hr_api.validate_enabled then
669: --
670: -- As the Validate_Enabled exception has been raised
678: --
679:
680: p_object_version_number := l_object_version_number;
681:
682: hr_utility.set_location(' Leaving:'||l_proc, 100);
683: when others then
684: --
685: -- A validation or unexpected error has occured
686: --
691: --
692:
693: p_object_version_number := l_object_version_number;
694:
695: hr_utility.set_location(' Leaving:'||l_proc, 110);
696: raise;
697: end validate_integration;
698: --
699: --
821: l_ext_trans_sub_type varchar2(100) := p_ext_trans_subtype;
822: l_trans_direction varchar2(20) := p_trans_direction;
823:
824: begin
825: hr_utility.set_location('Entering:'|| l_proc, 10);
826: --
827: -- Issue a savepoint
828: --
829: savepoint UPDATE_INTEGRATION;
1280: -- p_object_version_number := p_object_version_number;
1281:
1282:
1283: --
1284: hr_utility.set_location(' Leaving:'||l_proc, 70);
1285: exception
1286: when hr_api.validate_enabled then
1287: --
1288: -- As the Validate_Enabled exception has been raised
1296: --
1297:
1298: p_object_version_number := l_object_version_number;
1299:
1300: hr_utility.set_location(' Leaving:'||l_proc, 80);
1301: when others then
1302: --
1303: -- A validation or unexpected error has occured
1304: --
1309: --
1310:
1311: p_object_version_number := l_object_version_number;
1312:
1313: hr_utility.set_location(' Leaving:'||l_proc, 90);
1314: raise;
1315: end UPDATE_INTEGRATION;
1316: --
1317: --
1341: l_error number(15);
1342: l_eap_id number(15);
1343:
1344: begin
1345: hr_utility.set_location('Entering:'|| l_proc, 10);
1346: --
1347: -- Issue a savepoint
1348: --
1349: savepoint delete_integration;
1436: -- Set all IN OUT and OUT parameters with out values
1437: --
1438:
1439: --
1440: hr_utility.set_location(' Leaving:'||l_proc, 70);
1441: exception
1442: when hr_api.validate_enabled then
1443: --
1444: -- As the Validate_Enabled exception has been raised
1450: -- (Any key or derived arguments must be set to null
1451: -- when validation only mode is being used.)
1452: --
1453:
1454: hr_utility.set_location(' Leaving:'||l_proc, 80);
1455: when others then
1456: --
1457: -- A validation or unexpected error has occured
1458: --
1460: --
1461: -- Reset IN OUT parameters and set all
1462: -- OUT parameters, including warnings, to null
1463: --
1464: hr_utility.set_location(' Leaving:'||l_proc, 90);
1465: raise;
1466: end delete_integration;
1467: end HR_KI_INTEGRATIONS_API;