[Home] [Help]
3: --
4: -- Package variables
5: --
6: g_package varchar2(33) := 'hr_person_deployment_swi.';
7: g_debug boolean := hr_utility.debug_enabled;
8: --
9: -- ----------------------------------------------------------------------------
10: -- |-----------------------< create_person_deployment >-----------------------|
11: -- ----------------------------------------------------------------------------
84: -- Other variables
85: l_person_deployment_id number;
86: l_proc varchar2(72) := g_package ||'create_person_deployment';
87: Begin
88: hr_utility.set_location(' Entering:' || l_proc,10);
89: --
90: -- Issue a savepoint
91: --
92: savepoint create_person_deployment_swi;
197: -- messages of any type exist in the Multiple Message List.
198: -- Also disable Multiple Message Detection.
199: --
200: p_return_status := hr_multi_message.get_return_status_disable;
201: hr_utility.set_location(' Leaving:' || l_proc,20);
202: --
203: exception
204: when hr_multi_message.error_message_exist then
205: --
212: -- Reset IN OUT parameters and set OUT parameters
213: --
214: p_object_version_number := null;
215: p_return_status := hr_multi_message.get_return_status_disable;
216: hr_utility.set_location(' Leaving:' || l_proc, 30);
217: when others then
218: --
219: -- When Multiple Message Detection is enabled catch
220: -- any Application specific or other unexpected
223: -- error.
224: --
225: rollback to create_person_deployment_swi;
226: if hr_multi_message.unexpected_error_add(l_proc) then
227: hr_utility.set_location(' Leaving:' || l_proc,40);
228: raise;
229: end if;
230: --
231: -- Reset IN OUT and set OUT parameters
231: -- Reset IN OUT and set OUT parameters
232: --
233: p_object_version_number := null;
234: p_return_status := hr_multi_message.get_return_status_disable;
235: hr_utility.set_location(' Leaving:' || l_proc,50);
236: end create_person_deployment;
237: -- ----------------------------------------------------------------------------
238: -- |-----------------------< update_person_deployment >-----------------------|
239: -- ----------------------------------------------------------------------------
309: --
310: -- Other variables
311: l_proc varchar2(72) := g_package ||'update_person_deployment';
312: Begin
313: hr_utility.set_location(' Entering:' || l_proc,10);
314: --
315: -- Issue a savepoint
316: --
317: savepoint update_person_deployment_swi;
417: -- messages of any type exist in the Multiple Message List.
418: -- Also disable Multiple Message Detection.
419: --
420: p_return_status := hr_multi_message.get_return_status_disable;
421: hr_utility.set_location(' Leaving:' || l_proc,20);
422: --
423: exception
424: when hr_multi_message.error_message_exist then
425: --
432: -- Reset IN OUT parameters and set OUT parameters
433: --
434: p_object_version_number := l_object_version_number;
435: p_return_status := hr_multi_message.get_return_status_disable;
436: hr_utility.set_location(' Leaving:' || l_proc, 30);
437: when others then
438: --
439: -- When Multiple Message Detection is enabled catch
440: -- any Application specific or other unexpected
443: -- error.
444: --
445: rollback to update_person_deployment_swi;
446: if hr_multi_message.unexpected_error_add(l_proc) then
447: hr_utility.set_location(' Leaving:' || l_proc,40);
448: raise;
449: end if;
450: --
451: -- Reset IN OUT and set OUT parameters
451: -- Reset IN OUT and set OUT parameters
452: --
453: p_object_version_number := l_object_version_number;
454: p_return_status := hr_multi_message.get_return_status_disable;
455: hr_utility.set_location(' Leaving:' || l_proc,50);
456: end update_person_deployment;
457: -- ----------------------------------------------------------------------------
458: -- |-----------------------< delete_person_deployment >-----------------------|
459: -- ----------------------------------------------------------------------------
481: and hat.transaction_id = hats.transaction_id
482: and hats.information1 = to_char(p_person_deployment_id);
483:
484: Begin
485: hr_utility.set_location(' Entering:' || l_proc,10);
486: --
487: -- Issue a savepoint
488: --
489: savepoint delete_person_deployment_swi;
530: -- messages of any type exist in the Multiple Message List.
531: -- Also disable Multiple Message Detection.
532: --
533: p_return_status := hr_multi_message.get_return_status_disable;
534: hr_utility.set_location(' Leaving:' || l_proc,20);
535: --
536: exception
537: when hr_multi_message.error_message_exist then
538: --
544: --
545: -- Reset IN OUT parameters and set OUT parameters
546: --
547: p_return_status := hr_multi_message.get_return_status_disable;
548: hr_utility.set_location(' Leaving:' || l_proc, 30);
549: when others then
550: --
551: -- When Multiple Message Detection is enabled catch
552: -- any Application specific or other unexpected
555: -- error.
556: --
557: rollback to delete_person_deployment_swi;
558: if hr_multi_message.unexpected_error_add(l_proc) then
559: hr_utility.set_location(' Leaving:' || l_proc,40);
560: raise;
561: end if;
562: --
563: -- Reset IN OUT and set OUT parameters
562: --
563: -- Reset IN OUT and set OUT parameters
564: --
565: p_return_status := hr_multi_message.get_return_status_disable;
566: hr_utility.set_location(' Leaving:' || l_proc,50);
567: end delete_person_deployment;
568: -- ----------------------------------------------------------------------------
569: -- |-----------------------< initiate_deployment >----------------------------|
570: -- ----------------------------------------------------------------------------
588: --
589: -- Other variables
590: l_proc varchar2(72) := g_package ||'initiate_deployment';
591: Begin
592: hr_utility.set_location(' Entering:' || l_proc,10);
593: --
594: -- Issue a savepoint
595: --
596: savepoint initiate_deployment_swi;
642: -- messages of any type exist in the Multiple Message List.
643: -- Also disable Multiple Message Detection.
644: --
645: p_return_status := hr_multi_message.get_return_status_disable;
646: hr_utility.set_location(' Leaving:' || l_proc,20);
647: --
648: exception
649: when hr_multi_message.error_message_exist then
650: --
661: p_host_per_ovn := null;
662: p_host_assignment_id := null;
663: p_host_asg_ovn := null;
664: p_return_status := hr_multi_message.get_return_status_disable;
665: hr_utility.set_location(' Leaving:' || l_proc, 30);
666: when others then
667: --
668: -- When Multiple Message Detection is enabled catch
669: -- any Application specific or other unexpected
672: -- error.
673: --
674: rollback to initiate_deployment_swi;
675: if hr_multi_message.unexpected_error_add(l_proc) then
676: hr_utility.set_location(' Leaving:' || l_proc,40);
677: raise;
678: end if;
679: --
680: -- Reset IN OUT and set OUT parameters
684: p_host_per_ovn := null;
685: p_host_assignment_id := null;
686: p_host_asg_ovn := null;
687: p_return_status := hr_multi_message.get_return_status_disable;
688: hr_utility.set_location(' Leaving:' || l_proc,50);
689: end initiate_deployment;
690: -- ----------------------------------------------------------------------------
691: -- |-----------------------< change_deployment_dates >------------------------|
692: -- ----------------------------------------------------------------------------
709: -- Other variables
710: --
711: l_proc varchar2(72) := g_package ||'change_deployment_dates';
712: Begin
713: hr_utility.set_location(' Entering:' || l_proc,10);
714: --
715: -- Issue a savepoint
716: --
717: savepoint change_deployment_dates_swi;
755: -- messages of any type exist in the Multiple Message List.
756: -- Also disable Multiple Message Detection.
757: --
758: p_return_status := hr_multi_message.get_return_status_disable;
759: hr_utility.set_location(' Leaving:' || l_proc,20);
760: --
761: exception
762: when hr_multi_message.error_message_exist then
763: --
770: -- Reset IN OUT parameters and set OUT parameters
771: --
772: p_object_version_number := l_object_version_number;
773: p_return_status := hr_multi_message.get_return_status_disable;
774: hr_utility.set_location(' Leaving:' || l_proc, 30);
775: when others then
776: --
777: -- When Multiple Message Detection is enabled catch
778: -- any Application specific or other unexpected
781: -- error.
782: --
783: rollback to change_deployment_dates_swi;
784: if hr_multi_message.unexpected_error_add(l_proc) then
785: hr_utility.set_location(' Leaving:' || l_proc,40);
786: raise;
787: end if;
788: --
789: -- Reset IN OUT and set OUT parameters
789: -- Reset IN OUT and set OUT parameters
790: --
791: p_object_version_number := l_object_version_number;
792: p_return_status := hr_multi_message.get_return_status_disable;
793: hr_utility.set_location(' Leaving:' || l_proc,50);
794: end change_deployment_dates;
795: -- ----------------------------------------------------------------------------
796: -- |-----------------------< return_from_deployment >-------------------------|
797: -- ----------------------------------------------------------------------------
814: --
815: -- Other variables
816: l_proc varchar2(72) := g_package ||'change_deployment_dates';
817: Begin
818: hr_utility.set_location(' Entering:' || l_proc,10);
819: --
820: -- Issue a savepoint
821: --
822: savepoint return_from_deployment_swi;
860: -- messages of any type exist in the Multiple Message List.
861: -- Also disable Multiple Message Detection.
862: --
863: p_return_status := hr_multi_message.get_return_status_disable;
864: hr_utility.set_location(' Leaving:' || l_proc,20);
865: --
866: exception
867: when hr_multi_message.error_message_exist then
868: --
875: -- Reset IN OUT parameters and set OUT parameters
876: --
877: p_object_version_number := l_object_version_number;
878: p_return_status := hr_multi_message.get_return_status_disable;
879: hr_utility.set_location(' Leaving:' || l_proc, 30);
880: when others then
881: --
882: -- When Multiple Message Detection is enabled catch
883: -- any Application specific or other unexpected
886: -- error.
887: --
888: rollback to return_from_deployment_swi;
889: if hr_multi_message.unexpected_error_add(l_proc) then
890: hr_utility.set_location(' Leaving:' || l_proc,40);
891: raise;
892: end if;
893: --
894: -- Reset IN OUT and set OUT parameters
894: -- Reset IN OUT and set OUT parameters
895: --
896: p_object_version_number := l_object_version_number;
897: p_return_status := hr_multi_message.get_return_status_disable;
898: hr_utility.set_location(' Leaving:' || l_proc,50);
899: end return_from_deployment;
900:
901: -- ----------------------------------------------------------------------------
902: -- |--------------------------< update_attachment >----------------------------|
937: l_doc_tl_pre_upd csr_get_doc_tl%rowtype;
938: --
939: --
940: Begin
941: hr_utility.set_location(' Entering:' || l_proc,10);
942: --
943: -- Get language
944: select userenv('LANG') into l_language from dual;
945: --
966: close csr_get_doc_tl;
967: raise data_error;
968: END IF;
969:
970: hr_utility.set_location(' before fnd_attached_documents_pkg.lock_row :' || l_proc,20);
971: -- Now, lock the rows.
972: fnd_attached_documents_pkg.lock_row
973: (x_rowid => p_rowid
974: ,x_attached_document_id =>
1039:
1040: -- Update document to fnd_attached_documents, fnd_documents,
1041: -- fnd_documents_tl
1042: --
1043: hr_utility.set_location(' before fnd_attached_documents_pkg.update_row :' || l_proc,30);
1044: fnd_attached_documents_pkg.update_row
1045: (x_rowid => p_rowid
1046: ,x_attached_document_id =>
1047: l_attached_doc_pre_upd.attached_document_id
1110: ,x_url => l_doc_pre_upd.url
1111: ,x_title => l_doc_tl_pre_upd.title
1112: );
1113:
1114: hr_utility.set_location(' after fnd_attached_documents_pkg.update_row :' || l_proc,40);
1115: hr_utility.set_location(' Leaving:' || l_proc,50);
1116:
1117: EXCEPTION
1118: when others then
1111: ,x_title => l_doc_tl_pre_upd.title
1112: );
1113:
1114: hr_utility.set_location(' after fnd_attached_documents_pkg.update_row :' || l_proc,40);
1115: hr_utility.set_location(' Leaving:' || l_proc,50);
1116:
1117: EXCEPTION
1118: when others then
1119: hr_utility.set_location(' Error in :' || l_proc,60);
1115: hr_utility.set_location(' Leaving:' || l_proc,50);
1116:
1117: EXCEPTION
1118: when others then
1119: hr_utility.set_location(' Error in :' || l_proc,60);
1120: raise;
1121: --
1122: End update_attachment;
1123:
1148: FROM fnd_attached_documents
1149: WHERE attached_document_id = X_attached_document_id;
1150: --
1151: Begin
1152: hr_utility.set_location(' Entering:' || l_proc,10);
1153: --
1154: -- Issue a savepoint
1155: --
1156: savepoint attachments_person_absence_swi;
1176: end loop;
1177:
1178: p_return_status := hr_multi_message.get_return_status_disable;
1179:
1180: hr_utility.set_location(' Leaving:' || l_proc,20);
1181: --
1182: exception
1183: when others then
1184: --
1189: -- error.
1190: --
1191: rollback to attachments_person_absence_swi;
1192: if hr_multi_message.unexpected_error_add(l_proc) then
1193: hr_utility.set_location(' Leaving:' || l_proc,40);
1194: raise;
1195: end if;
1196: --
1197: -- Reset IN OUT and set OUT parameters
1196: --
1197: -- Reset IN OUT and set OUT parameters
1198: p_return_status := hr_multi_message.get_return_status_disable;
1199:
1200: hr_utility.set_location(' Leaving:' || l_proc,50);
1201: end merge_attachments;
1202:
1203:
1204:
1229: where person_deployment_id = p_person_deployment_id;
1230:
1231:
1232: BEGIN
1233: --hr_utility.trace_on(null,'ORCLE');
1234: hr_utility.set_location(' Entering:' || l_proc,10);
1235: hr_utility.set_location(' CLOB --> xmldom.DOMNode:' || l_proc,15);
1236: savepoint deployment_process_api;
1237: l_parser := xmlparser.newParser;
1230:
1231:
1232: BEGIN
1233: --hr_utility.trace_on(null,'ORCLE');
1234: hr_utility.set_location(' Entering:' || l_proc,10);
1235: hr_utility.set_location(' CLOB --> xmldom.DOMNode:' || l_proc,15);
1236: savepoint deployment_process_api;
1237: l_parser := xmlparser.newParser;
1238: xmlparser.ParseCLOB(l_parser,p_document);
1231:
1232: BEGIN
1233: --hr_utility.trace_on(null,'ORCLE');
1234: hr_utility.set_location(' Entering:' || l_proc,10);
1235: hr_utility.set_location(' CLOB --> xmldom.DOMNode:' || l_proc,15);
1236: savepoint deployment_process_api;
1237: l_parser := xmlparser.newParser;
1238: xmlparser.ParseCLOB(l_parser,p_document);
1239: l_CommitNode := xmldom.makeNode(xmldom.getDocumentElement(xmlparser.getDocument(l_parser)));
1237: l_parser := xmlparser.newParser;
1238: xmlparser.ParseCLOB(l_parser,p_document);
1239: l_CommitNode := xmldom.makeNode(xmldom.getDocumentElement(xmlparser.getDocument(l_parser)));
1240:
1241: hr_utility.set_location('Extracting the PostState:' || l_proc,20);
1242:
1243: l_commitElement := xmldom.makeElement(l_CommitNode);
1244: l_postState := xmldom.getAttribute(l_commitElement, 'PS');
1245: -- l_object_version_number := hr_transaction_swi.getNumberValue(l_CommitNode,'ObjectVersionNumber');
1449: l_return_status);
1450: end if;
1451:
1452: p_return_status := l_return_status;
1453: hr_utility.set_location( l_proc||'p_return_status = '||p_return_status,38);
1454: hr_utility.set_location('Exiting:' || l_proc,40);
1455: EXCEPTION
1456: WHEN OTHERS THEN
1457: rollback to deployment_process_api;
1450: end if;
1451:
1452: p_return_status := l_return_status;
1453: hr_utility.set_location( l_proc||'p_return_status = '||p_return_status,38);
1454: hr_utility.set_location('Exiting:' || l_proc,40);
1455: EXCEPTION
1456: WHEN OTHERS THEN
1457: rollback to deployment_process_api;
1458: hr_utility.trace('Exception in .process_api:' || SQLERRM );
1454: hr_utility.set_location('Exiting:' || l_proc,40);
1455: EXCEPTION
1456: WHEN OTHERS THEN
1457: rollback to deployment_process_api;
1458: hr_utility.trace('Exception in .process_api:' || SQLERRM );
1459: hr_utility.set_location(' Leaving:' || l_proc,50);
1460:
1461: raise;
1462:
1455: EXCEPTION
1456: WHEN OTHERS THEN
1457: rollback to deployment_process_api;
1458: hr_utility.trace('Exception in .process_api:' || SQLERRM );
1459: hr_utility.set_location(' Leaving:' || l_proc,50);
1460:
1461: raise;
1462:
1463: END process_api;
1473: IS
1474: c_proc constant varchar2(30) := 'getDeploymentType';
1475: lv_permanent hr_api_transaction_steps.Information8%type;
1476: begin
1477: g_debug := hr_utility.debug_enabled;
1478: if g_debug then
1479: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
1480: end if;
1481:
1475: lv_permanent hr_api_transaction_steps.Information8%type;
1476: begin
1477: g_debug := hr_utility.debug_enabled;
1478: if g_debug then
1479: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
1480: end if;
1481:
1482: if(p_transaction_id is not null) then
1483: begin
1502: end if;
1503:
1504: return lv_permanent;
1505: if g_debug then
1506: hr_utility.set_location('Leaving:'|| g_package||'.'||c_proc, 30);
1507: end if;
1508:
1509: exception
1510: when others then
1507: end if;
1508:
1509: exception
1510: when others then
1511: hr_utility.set_location(g_package||c_proc|| 'errored : '||SQLERRM ||' '||to_char(SQLCODE), 30);
1512: Wf_Core.Context(g_package, c_proc, p_transaction_id);
1513: raise;
1514: end getDeploymentType;
1515:
1525: IS
1526: c_proc constant varchar2(30) := 'getPersonDeploymentId';
1527: lv_deployment_id hr_api_transaction_steps.Information1%type;
1528: begin
1529: g_debug := hr_utility.debug_enabled;
1530: if g_debug then
1531: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
1532: end if;
1533:
1527: lv_deployment_id hr_api_transaction_steps.Information1%type;
1528: begin
1529: g_debug := hr_utility.debug_enabled;
1530: if g_debug then
1531: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
1532: end if;
1533:
1534: if(p_transaction_id is not null) then
1535: begin
1546:
1547: return lv_deployment_id;
1548:
1549: if g_debug then
1550: hr_utility.set_location('Leaving:'|| g_package||'.'||c_proc, 30);
1551: end if;
1552:
1553: exception
1554: when others then
1551: end if;
1552:
1553: exception
1554: when others then
1555: hr_utility.set_location(g_package||c_proc|| 'errored : '||SQLERRM ||' '||to_char(SQLCODE), 30);
1556: Wf_Core.Context(g_package, c_proc, p_transaction_id);
1557: raise;
1558: end getPersonDeploymentId;
1559:
1570: IS
1571: c_proc constant varchar2(30) := 'getFromPersonId';
1572: lv_from_person_id hr_api_transaction_steps.Information2%type;
1573: begin
1574: g_debug := hr_utility.debug_enabled;
1575: if g_debug then
1576: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
1577: end if;
1578:
1572: lv_from_person_id hr_api_transaction_steps.Information2%type;
1573: begin
1574: g_debug := hr_utility.debug_enabled;
1575: if g_debug then
1576: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
1577: end if;
1578:
1579: if(p_transaction_id is not null) then
1580: begin
1591:
1592: return lv_from_person_id;
1593:
1594: if g_debug then
1595: hr_utility.set_location('Leaving:'|| g_package||'.'||c_proc, 30);
1596: end if;
1597:
1598: exception
1599: when others then
1596: end if;
1597:
1598: exception
1599: when others then
1600: hr_utility.set_location(g_package||c_proc|| 'errored : '||SQLERRM ||' '||to_char(SQLCODE), 30);
1601: Wf_Core.Context(g_package, c_proc, p_transaction_id);
1602: raise;
1603: end getFromPersonId;
1604:
1612: IS
1613: c_proc constant varchar2(30) := 'getToBgId';
1614: lv_to_bg_id hr_api_transaction_steps.Information3%type;
1615: begin
1616: g_debug := hr_utility.debug_enabled;
1617: if g_debug then
1618: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
1619: end if;
1620:
1614: lv_to_bg_id hr_api_transaction_steps.Information3%type;
1615: begin
1616: g_debug := hr_utility.debug_enabled;
1617: if g_debug then
1618: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
1619: end if;
1620:
1621: if(p_transaction_id is not null) then
1622: begin
1633:
1634: return lv_to_bg_id;
1635:
1636: if g_debug then
1637: hr_utility.set_location('Leaving:'|| g_package||'.'||c_proc, 30);
1638: end if;
1639:
1640: exception
1641: when others then
1638: end if;
1639:
1640: exception
1641: when others then
1642: hr_utility.set_location(g_package||c_proc|| 'errored : '||SQLERRM ||' '||to_char(SQLCODE), 30);
1643: Wf_Core.Context(g_package, c_proc, p_transaction_id);
1644: raise;
1645: end getToBgId;
1646:
1654: IS
1655: c_proc constant varchar2(30) := 'getPersonTypeId';
1656: lv_person_type_id hr_api_transaction_steps.Information4%type;
1657: begin
1658: g_debug := hr_utility.debug_enabled;
1659: if g_debug then
1660: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
1661: end if;
1662:
1656: lv_person_type_id hr_api_transaction_steps.Information4%type;
1657: begin
1658: g_debug := hr_utility.debug_enabled;
1659: if g_debug then
1660: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
1661: end if;
1662:
1663: if(p_transaction_id is not null) then
1664: begin
1675:
1676: return lv_person_type_id;
1677:
1678: if g_debug then
1679: hr_utility.set_location('Leaving:'|| g_package||'.'||c_proc, 30);
1680: end if;
1681:
1682: exception
1683: when others then
1680: end if;
1681:
1682: exception
1683: when others then
1684: hr_utility.set_location(g_package||c_proc|| 'errored : '||SQLERRM ||' '||to_char(SQLCODE), 30);
1685: Wf_Core.Context(g_package, c_proc, p_transaction_id);
1686: raise;
1687: end getPersonTypeId;
1688:
1698: IS
1699: c_proc constant varchar2(30) := 'getStartDate';
1700: lv_start_date hr_api_transaction_steps.Information5%type;
1701: begin
1702: g_debug := hr_utility.debug_enabled;
1703: if g_debug then
1704: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
1705: end if;
1706:
1700: lv_start_date hr_api_transaction_steps.Information5%type;
1701: begin
1702: g_debug := hr_utility.debug_enabled;
1703: if g_debug then
1704: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
1705: end if;
1706:
1707: if(p_transaction_id is not null) then
1708: begin
1719:
1720: return lv_start_date;
1721:
1722: if g_debug then
1723: hr_utility.set_location('Leaving:'|| g_package||'.'||c_proc, 30);
1724: end if;
1725:
1726: exception
1727: when others then
1724: end if;
1725:
1726: exception
1727: when others then
1728: hr_utility.set_location(g_package||c_proc|| 'errored : '||SQLERRM ||' '||to_char(SQLCODE), 30);
1729: Wf_Core.Context(g_package, c_proc, p_transaction_id);
1730: raise;
1731: end getStartDate;
1732:
1742: c_proc constant varchar2(30) := 'getEndDate';
1743: lv_end_date hr_api_transaction_steps.Information6%type;
1744:
1745: begin
1746: g_debug := hr_utility.debug_enabled;
1747: if g_debug then
1748: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
1749: end if;
1750:
1744:
1745: begin
1746: g_debug := hr_utility.debug_enabled;
1747: if g_debug then
1748: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
1749: end if;
1750:
1751: if(p_transaction_id is not null) then
1752: begin
1763:
1764: return lv_end_date;
1765:
1766: if g_debug then
1767: hr_utility.set_location('Leaving:'|| g_package||'.'||c_proc, 30);
1768: end if;
1769:
1770: exception
1771: when others then
1768: end if;
1769:
1770: exception
1771: when others then
1772: hr_utility.set_location(g_package||c_proc|| 'errored : '||SQLERRM ||' '||to_char(SQLCODE), 30);
1773: Wf_Core.Context(g_package, c_proc, p_transaction_id);
1774: raise;
1775: end getEndDate;
1776:
1788: c_proc constant varchar2(30) := 'getEmployeeNumber';
1789: lv_employee_number hr_api_transaction_steps.Information7%type;
1790:
1791: begin
1792: g_debug := hr_utility.debug_enabled;
1793: if g_debug then
1794: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
1795: end if;
1796:
1790:
1791: begin
1792: g_debug := hr_utility.debug_enabled;
1793: if g_debug then
1794: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
1795: end if;
1796:
1797: if(p_transaction_id is not null) then
1798: begin
1809:
1810: return lv_employee_number;
1811:
1812: if g_debug then
1813: hr_utility.set_location('Leaving:'|| g_package||'.'||c_proc, 30);
1814: end if;
1815:
1816: exception
1817: when others then
1814: end if;
1815:
1816: exception
1817: when others then
1818: hr_utility.set_location(g_package||c_proc|| 'errored : '||SQLERRM ||' '||to_char(SQLCODE), 30);
1819: Wf_Core.Context(g_package, c_proc, p_transaction_id);
1820: raise;
1821: end getEmployeeNumber;
1822:
1833: c_proc constant varchar2(30) := 'getFromBgId';
1834: lv_to_bg_id hr_api_transaction_steps.Information9%type;
1835:
1836: begin
1837: g_debug := hr_utility.debug_enabled;
1838: if g_debug then
1839: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
1840: end if;
1841:
1835:
1836: begin
1837: g_debug := hr_utility.debug_enabled;
1838: if g_debug then
1839: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
1840: end if;
1841:
1842: if(p_transaction_id is not null) then
1843: begin
1854:
1855: return lv_to_bg_id;
1856:
1857: if g_debug then
1858: hr_utility.set_location('Leaving:'|| g_package||'.'||c_proc, 30);
1859: end if;
1860:
1861: exception
1862: when others then
1859: end if;
1860:
1861: exception
1862: when others then
1863: hr_utility.set_location(g_package||c_proc|| 'errored : '||SQLERRM ||' '||to_char(SQLCODE), 30);
1864: Wf_Core.Context(g_package, c_proc, p_transaction_id);
1865: raise;
1866: end getFromBgId;
1867:
1878: c_proc constant varchar2(30) := 'getOrganizationId';
1879: lv_organization_id hr_api_transaction_steps.Information10%type;
1880:
1881: begin
1882: g_debug := hr_utility.debug_enabled;
1883: if g_debug then
1884: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
1885: end if;
1886:
1880:
1881: begin
1882: g_debug := hr_utility.debug_enabled;
1883: if g_debug then
1884: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
1885: end if;
1886:
1887: if(p_transaction_id is not null) then
1888: begin
1899:
1900: return lv_organization_id;
1901:
1902: if g_debug then
1903: hr_utility.set_location('Leaving:'|| g_package||'.'||c_proc, 30);
1904: end if;
1905:
1906: exception
1907: when others then
1904: end if;
1905:
1906: exception
1907: when others then
1908: hr_utility.set_location(g_package||c_proc|| 'errored : '||SQLERRM ||' '||to_char(SQLCODE), 30);
1909: Wf_Core.Context(g_package, c_proc, p_transaction_id);
1910: raise;
1911: end getOrganizationId;
1912:
1921: c_proc constant varchar2(30) := 'getJobId';
1922: lv_job_id hr_api_transaction_steps.Information11%type;
1923:
1924: begin
1925: g_debug := hr_utility.debug_enabled;
1926: if g_debug then
1927: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
1928: end if;
1929:
1923:
1924: begin
1925: g_debug := hr_utility.debug_enabled;
1926: if g_debug then
1927: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
1928: end if;
1929:
1930: if(p_transaction_id is not null) then
1931: begin
1942:
1943: return lv_job_id;
1944:
1945: if g_debug then
1946: hr_utility.set_location('Leaving:'|| g_package||'.'||c_proc, 30);
1947: end if;
1948:
1949: exception
1950: when others then
1947: end if;
1948:
1949: exception
1950: when others then
1951: hr_utility.set_location(g_package||c_proc|| 'errored : '||SQLERRM ||' '||to_char(SQLCODE), 30);
1952: Wf_Core.Context(g_package, c_proc, p_transaction_id);
1953: raise;
1954: end getJobId;
1955:
1968: c_proc constant varchar2(30) := 'isUpdateAllowed';
1969: lv_UpdateAllowed varchar2(30);
1970:
1971: begin
1972: g_debug := hr_utility.debug_enabled;
1973: if g_debug then
1974: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
1975: end if;
1976:
1970:
1971: begin
1972: g_debug := hr_utility.debug_enabled;
1973: if g_debug then
1974: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
1975: end if;
1976:
1977: -- need to revisit with the common code for handling update
1978: -- based on the current transaction owner
2005:
2006: return lv_UpdateAllowed;
2007:
2008: if g_debug then
2009: hr_utility.set_location('Leaving:'|| g_package||'.'||c_proc, 30);
2010: end if;
2011:
2012: exception
2013: when others then
2010: end if;
2011:
2012: exception
2013: when others then
2014: hr_utility.set_location(g_package||c_proc|| 'errored : '||SQLERRM ||' '||to_char(SQLCODE), 30);
2015: Wf_Core.Context(g_package, c_proc, p_transaction_id);
2016: raise;
2017: end isUpdateAllowed;
2018:
2032: c_proc constant varchar2(30) := 'isDeleteAllowed';
2033: lv_DeleteAllowed varchar2(30);
2034:
2035: begin
2036: g_debug := hr_utility.debug_enabled;
2037: if g_debug then
2038: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
2039: end if;
2040:
2034:
2035: begin
2036: g_debug := hr_utility.debug_enabled;
2037: if g_debug then
2038: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
2039: end if;
2040:
2041: -- need to revisit with the common code for handling update
2042: -- based on the current transaction owner
2081:
2082: return lv_DeleteAllowed;
2083:
2084: if g_debug then
2085: hr_utility.set_location('Leaving:'|| g_package||'.'||c_proc, 30);
2086: end if;
2087:
2088: exception
2089: when others then
2086: end if;
2087:
2088: exception
2089: when others then
2090: hr_utility.set_location(g_package||c_proc|| 'errored : '||SQLERRM ||' '||to_char(SQLCODE), 30);
2091: Wf_Core.Context(g_package, c_proc, p_transaction_id);
2092: raise;
2093: end isDeleteAllowed;
2094:
2107: c_proc constant varchar2(30) := 'isInitAllowed';
2108: lv_Init_Allowed varchar2(30);
2109:
2110: begin
2111: g_debug := hr_utility.debug_enabled;
2112: if g_debug then
2113: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
2114: end if;
2115:
2109:
2110: begin
2111: g_debug := hr_utility.debug_enabled;
2112: if g_debug then
2113: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
2114: end if;
2115:
2116: -- need to revisit with the common code for handling update
2117: -- based on the current transaction owner
2133:
2134: return lv_Init_Allowed;
2135:
2136: if g_debug then
2137: hr_utility.set_location('Leaving:'|| g_package||'.'||c_proc, 30);
2138: end if;
2139:
2140: exception
2141: when others then
2138: end if;
2139:
2140: exception
2141: when others then
2142: hr_utility.set_location(g_package||c_proc|| 'errored : '||SQLERRM ||' '||to_char(SQLCODE), 30);
2143: Wf_Core.Context(g_package, c_proc, p_transaction_id);
2144: raise;
2145: end isInitAllowed;
2146:
2160: c_proc constant varchar2(30) := 'isReturnInitAllowed';
2161: lv_ret_Init_Allowed varchar2(30);
2162:
2163: begin
2164: g_debug := hr_utility.debug_enabled;
2165: if g_debug then
2166: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
2167: end if;
2168:
2162:
2163: begin
2164: g_debug := hr_utility.debug_enabled;
2165: if g_debug then
2166: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
2167: end if;
2168:
2169: -- need to revisit with the common code for handling update
2170: -- based on the current transaction owner
2190:
2191: return lv_ret_Init_Allowed;
2192:
2193: if g_debug then
2194: hr_utility.set_location('Leaving:'|| g_package||'.'||c_proc, 30);
2195: end if;
2196:
2197: exception
2198: when others then
2195: end if;
2196:
2197: exception
2198: when others then
2199: hr_utility.set_location(g_package||c_proc|| 'errored : '||SQLERRM ||' '||to_char(SQLCODE), 30);
2200: Wf_Core.Context(g_package, c_proc, p_transaction_id);
2201: raise;
2202: end isReturnInitAllowed;
2203:
2212: IS
2213: c_proc constant varchar2(30) := 'getActionMode';
2214: lv_action_mode hr_api_transaction_steps.Information12%type;
2215: begin
2216: g_debug := hr_utility.debug_enabled;
2217: if g_debug then
2218: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
2219: end if;
2220:
2214: lv_action_mode hr_api_transaction_steps.Information12%type;
2215: begin
2216: g_debug := hr_utility.debug_enabled;
2217: if g_debug then
2218: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
2219: end if;
2220:
2221: if(p_transaction_id is not null) then
2222: begin
2233:
2234: return lv_action_mode;
2235:
2236: if g_debug then
2237: hr_utility.set_location('Leaving:'|| g_package||'.'||c_proc, 30);
2238: end if;
2239:
2240: exception
2241: when others then
2238: end if;
2239:
2240: exception
2241: when others then
2242: hr_utility.set_location(g_package||c_proc|| 'errored : '||SQLERRM ||' '||to_char(SQLCODE), 30);
2243: Wf_Core.Context(g_package, c_proc, p_transaction_id);
2244: raise;
2245: end getActionMode;
2246:
2256: c_proc constant varchar2(30) := 'getStatus';
2257: lv_action_mode hr_api_transaction_steps.Information12%type;
2258: lv_status Varchar2(40);
2259: begin
2260: -- hr_utility.trace_on (null,'ORAC');
2261: g_debug := hr_utility.debug_enabled;
2262: hr_utility.set_location(c_proc||'p_transaction_id = '||p_transaction_id,12);
2263: hr_utility.set_location(c_proc||'p_person_deployment_id = '||p_person_deployment_id,13);
2264: hr_utility.set_location(c_proc||'p_transaction_status = '||p_transaction_status,14);
2257: lv_action_mode hr_api_transaction_steps.Information12%type;
2258: lv_status Varchar2(40);
2259: begin
2260: -- hr_utility.trace_on (null,'ORAC');
2261: g_debug := hr_utility.debug_enabled;
2262: hr_utility.set_location(c_proc||'p_transaction_id = '||p_transaction_id,12);
2263: hr_utility.set_location(c_proc||'p_person_deployment_id = '||p_person_deployment_id,13);
2264: hr_utility.set_location(c_proc||'p_transaction_status = '||p_transaction_status,14);
2265: if g_debug then
2258: lv_status Varchar2(40);
2259: begin
2260: -- hr_utility.trace_on (null,'ORAC');
2261: g_debug := hr_utility.debug_enabled;
2262: hr_utility.set_location(c_proc||'p_transaction_id = '||p_transaction_id,12);
2263: hr_utility.set_location(c_proc||'p_person_deployment_id = '||p_person_deployment_id,13);
2264: hr_utility.set_location(c_proc||'p_transaction_status = '||p_transaction_status,14);
2265: if g_debug then
2266: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
2259: begin
2260: -- hr_utility.trace_on (null,'ORAC');
2261: g_debug := hr_utility.debug_enabled;
2262: hr_utility.set_location(c_proc||'p_transaction_id = '||p_transaction_id,12);
2263: hr_utility.set_location(c_proc||'p_person_deployment_id = '||p_person_deployment_id,13);
2264: hr_utility.set_location(c_proc||'p_transaction_status = '||p_transaction_status,14);
2265: if g_debug then
2266: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
2267: end if;
2260: -- hr_utility.trace_on (null,'ORAC');
2261: g_debug := hr_utility.debug_enabled;
2262: hr_utility.set_location(c_proc||'p_transaction_id = '||p_transaction_id,12);
2263: hr_utility.set_location(c_proc||'p_person_deployment_id = '||p_person_deployment_id,13);
2264: hr_utility.set_location(c_proc||'p_transaction_status = '||p_transaction_status,14);
2265: if g_debug then
2266: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
2267: end if;
2268:
2262: hr_utility.set_location(c_proc||'p_transaction_id = '||p_transaction_id,12);
2263: hr_utility.set_location(c_proc||'p_person_deployment_id = '||p_person_deployment_id,13);
2264: hr_utility.set_location(c_proc||'p_transaction_status = '||p_transaction_status,14);
2265: if g_debug then
2266: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
2267: end if;
2268:
2269: if(p_transaction_id is not null) then
2270: begin
2276: when others then
2277: lv_action_mode:=null;
2278: end;
2279: end if;
2280: hr_utility.set_location(c_proc||'lv_action_mode = '||lv_action_mode,15);
2281: if (lv_action_mode is not null) then
2282:
2283: if lv_action_mode in ('CreateMode','UpdateMode','ActUpdateMode') then
2284: if p_transaction_status in ('AC') then
2306:
2307: return lv_status;
2308:
2309: if g_debug then
2310: hr_utility.set_location('Leaving:'|| g_package||'.'||c_proc, 30);
2311: end if;
2312:
2313: exception
2314: when others then
2311: end if;
2312:
2313: exception
2314: when others then
2315: hr_utility.set_location(g_package||c_proc|| 'errored : '||SQLERRM ||' '||to_char(SQLCODE), 30);
2316: Wf_Core.Context(g_package, c_proc, p_transaction_id);
2317: raise;
2318: end getStatus;
2319:
2329: IS
2330: c_proc constant varchar2(30) := 'getToPersonId';
2331: lv_from_person_id hr_api_transaction_steps.Information13%type;
2332: begin
2333: g_debug := hr_utility.debug_enabled;
2334: if g_debug then
2335: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
2336: end if;
2337:
2331: lv_from_person_id hr_api_transaction_steps.Information13%type;
2332: begin
2333: g_debug := hr_utility.debug_enabled;
2334: if g_debug then
2335: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
2336: end if;
2337:
2338: if(p_transaction_id is not null) then
2339: begin
2350:
2351: return lv_from_person_id;
2352:
2353: if g_debug then
2354: hr_utility.set_location('Leaving:'|| g_package||'.'||c_proc, 30);
2355: end if;
2356:
2357: exception
2358: when others then
2355: end if;
2356:
2357: exception
2358: when others then
2359: hr_utility.set_location(g_package||c_proc|| 'errored : '||SQLERRM ||' '||to_char(SQLCODE), 30);
2360: Wf_Core.Context(g_package, c_proc, p_transaction_id);
2361: raise;
2362: end getToPersonId;
2363:
2372: IS
2373: c_proc constant varchar2(30) := 'getOvn';
2374: lv_ovn hr_api_transaction_steps.Information14%type;
2375: begin
2376: g_debug := hr_utility.debug_enabled;
2377: if g_debug then
2378: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
2379: end if;
2380:
2374: lv_ovn hr_api_transaction_steps.Information14%type;
2375: begin
2376: g_debug := hr_utility.debug_enabled;
2377: if g_debug then
2378: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
2379: end if;
2380:
2381: if(p_transaction_id is not null) then
2382: begin
2393:
2394: return lv_ovn;
2395:
2396: if g_debug then
2397: hr_utility.set_location('Leaving:'|| g_package||'.'||c_proc, 30);
2398: end if;
2399:
2400: exception
2401: when others then
2398: end if;
2399:
2400: exception
2401: when others then
2402: hr_utility.set_location(g_package||c_proc|| 'errored : '||SQLERRM ||' '||to_char(SQLCODE), 30);
2403: Wf_Core.Context(g_package, c_proc, p_transaction_id);
2404: raise;
2405: end getOvn;
2406:
2420: lv_approval_required varchar2(2) := 'N';
2421: lv_action varchar2(20) := NULL;
2422:
2423: begin
2424: -- hr_utility.trace_on (null,'ORAC');
2425: g_debug := hr_utility.debug_enabled;
2426:
2427: if g_debug then
2428: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
2421: lv_action varchar2(20) := NULL;
2422:
2423: begin
2424: -- hr_utility.trace_on (null,'ORAC');
2425: g_debug := hr_utility.debug_enabled;
2426:
2427: if g_debug then
2428: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
2429: end if;
2424: -- hr_utility.trace_on (null,'ORAC');
2425: g_debug := hr_utility.debug_enabled;
2426:
2427: if g_debug then
2428: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
2429: end if;
2430:
2431: if upper(p_deployment_status) = 'DRAFT'
2432: then
2625:
2626: return lv_status;
2627:
2628: if g_debug then
2629: hr_utility.set_location('Leaving:'|| g_package||'.'||c_proc, 30);
2630: end if;
2631:
2632: exception
2633: when others then
2630: end if;
2631:
2632: exception
2633: when others then
2634: hr_utility.set_location(g_package||c_proc|| 'errored : '||SQLERRM ||' '||to_char(SQLCODE), 30);
2635: Wf_Core.Context(g_package, c_proc, p_deployment_id);
2636: raise;
2637: end getDeploymentStatus;
2638:
2649: lv_status Varchar2(40) := p_transaction_status;
2650: lv_action varchar2(20) := NULL;
2651:
2652: begin
2653: -- hr_utility.trace_on (null,'ORAC');
2654: g_debug := hr_utility.debug_enabled;
2655:
2656: if g_debug then
2657: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
2650: lv_action varchar2(20) := NULL;
2651:
2652: begin
2653: -- hr_utility.trace_on (null,'ORAC');
2654: g_debug := hr_utility.debug_enabled;
2655:
2656: if g_debug then
2657: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
2658: end if;
2653: -- hr_utility.trace_on (null,'ORAC');
2654: g_debug := hr_utility.debug_enabled;
2655:
2656: if g_debug then
2657: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
2658: end if;
2659:
2660: if upper(p_transaction_status) = 'AC'
2661: then
2691:
2692: return lv_status;
2693:
2694: if g_debug then
2695: hr_utility.set_location('Leaving:'|| g_package||'.'||c_proc, 30);
2696: end if;
2697:
2698: exception
2699: when others then
2696: end if;
2697:
2698: exception
2699: when others then
2700: hr_utility.set_location(g_package||c_proc|| 'errored : '||SQLERRM ||' '||to_char(SQLCODE), 30);
2701: Wf_Core.Context(g_package, c_proc, p_transaction_id);
2702: raise;
2703: end getDeploymentStatus;
2704:
2721: lv_custom_callBack varchar2(60);
2722: l_sqlbuf Varchar2(1000);
2723:
2724: begin
2725: g_debug := hr_utility.debug_enabled;
2726: if g_debug then
2727: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 10);
2728: end if;
2729:
2723:
2724: begin
2725: g_debug := hr_utility.debug_enabled;
2726: if g_debug then
2727: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 10);
2728: end if;
2729:
2730: -- check if we have custom callback for the Approval Ntf subject
2731: --
2748: End If;
2749: exception
2750: when others then
2751: document :=null;
2752: hr_utility.set_location('hr_workflow_ss.getApprovalMsgSubject errored for custom call: '||SQLERRM ||' '||to_char(SQLCODE), 100);
2753: Wf_Core.Context('hr_workflow_ss', 'getApprovalMsgSubject', document_id, display_type);
2754: raise;
2755: end;
2756: */
2757:
2758:
2759: -- get the itemtype and item key for the notification id
2760: if g_debug then
2761: hr_utility.set_location('Calling hr_workflow_ss.get_item_type_and_key for NtfId:'||document_id, 11);
2762: end if;
2763: hr_workflow_ss.get_item_type_and_key(document_id,lv_item_type,lv_item_key);
2764:
2765: -- get the process display name
2763: hr_workflow_ss.get_item_type_and_key(document_id,lv_item_type,lv_item_key);
2764:
2765: -- get the process display name
2766: if g_debug then
2767: hr_utility.set_location('Calling getProcessDisplayName',12);
2768: hr_utility.set_location('ItemType:'||lv_item_type,13);
2769: hr_utility.set_location('ItemKey:'||lv_item_key,14);
2770: end if;
2771: -- lv_process_display_name := hr_workflow_ss.getProcessDisplayName(lv_item_type,lv_item_key);
2764:
2765: -- get the process display name
2766: if g_debug then
2767: hr_utility.set_location('Calling getProcessDisplayName',12);
2768: hr_utility.set_location('ItemType:'||lv_item_type,13);
2769: hr_utility.set_location('ItemKey:'||lv_item_key,14);
2770: end if;
2771: -- lv_process_display_name := hr_workflow_ss.getProcessDisplayName(lv_item_type,lv_item_key);
2772:
2765: -- get the process display name
2766: if g_debug then
2767: hr_utility.set_location('Calling getProcessDisplayName',12);
2768: hr_utility.set_location('ItemType:'||lv_item_type,13);
2769: hr_utility.set_location('ItemKey:'||lv_item_key,14);
2770: end if;
2771: -- lv_process_display_name := hr_workflow_ss.getProcessDisplayName(lv_item_type,lv_item_key);
2772:
2773: lv_ntf_sub_msg := wf_engine.GetItemAttrText(itemtype => lv_item_type ,
2793: (itemtype => lv_item_type
2794: ,itemkey => lv_item_key
2795: ,aname => 'CURRENT_PERSON_ID');
2796: if g_debug then
2797: hr_utility.set_location('Creator_person_id:'||l_creator_person_id,15);
2798: hr_utility.set_location('Current_person_id:'||l_current_person_id,16);
2799: end if;
2800: if g_debug then
2801: hr_utility.set_location('Building subject for NtfId:'||document_id,17);
2794: ,itemkey => lv_item_key
2795: ,aname => 'CURRENT_PERSON_ID');
2796: if g_debug then
2797: hr_utility.set_location('Creator_person_id:'||l_creator_person_id,15);
2798: hr_utility.set_location('Current_person_id:'||l_current_person_id,16);
2799: end if;
2800: if g_debug then
2801: hr_utility.set_location('Building subject for NtfId:'||document_id,17);
2802: end if;
2797: hr_utility.set_location('Creator_person_id:'||l_creator_person_id,15);
2798: hr_utility.set_location('Current_person_id:'||l_current_person_id,16);
2799: end if;
2800: if g_debug then
2801: hr_utility.set_location('Building subject for NtfId:'||document_id,17);
2802: end if;
2803: if(l_creator_person_id=l_current_person_id) then
2804: if g_debug then
2805: hr_utility.set_location('calling wf_directory.GetUserName for person_id:'||l_creator_person_id,18);
2801: hr_utility.set_location('Building subject for NtfId:'||document_id,17);
2802: end if;
2803: if(l_creator_person_id=l_current_person_id) then
2804: if g_debug then
2805: hr_utility.set_location('calling wf_directory.GetUserName for person_id:'||l_creator_person_id,18);
2806: end if;
2807:
2808: -- get creator display name from role
2809: wf_directory.GetUserName
2817: end if;
2818: -- Subject pattern
2819: -- "Change Job for Doe, John "
2820: if g_debug then
2821: hr_utility.set_location('Getting message HR_SS_APPROVER_MSG_SUB_SELF',19);
2822: end if;
2823: fnd_message.set_name('PER','HR_SS_APPROVER_MSG_SUB_SELF');
2824: fnd_message.set_token('PROCESS_DISPLAY_NAME',lv_process_display_name,false);
2825: fnd_message.set_token('CURRENT_PERSON_DISPLAY_NAME',l_creator_disp_name,false);
2827:
2828: else
2829: -- get creator display name from role
2830: if g_debug then
2831: hr_utility.set_location('calling wf_directory.GetUserName for person_id:'||l_creator_person_id,20);
2832: end if;
2833: wf_directory.GetUserName
2834: (p_orig_system => 'PER'
2835: ,p_orig_system_id => l_creator_person_id
2837: ,p_display_name => l_creator_disp_name);
2838:
2839: -- get current person display name from role
2840: if g_debug then
2841: hr_utility.set_location('calling wf_directory.GetUserName for person_id:'||l_current_person_id,21);
2842: end if;
2843: wf_directory.GetUserName
2844: (p_orig_system => 'PER'
2845: ,p_orig_system_id => l_current_person_id
2873:
2874: -- Subject pattern
2875: -- "Change Job for Doe, John (proposed by Bond, James)"
2876: if g_debug then
2877: hr_utility.set_location('Getting message HR_SS_APPROVER_MSG_SUB_REPORTS',22);
2878: end if;
2879:
2880: fnd_message.set_name('PER','HR_SS_APPROVER_MSG_SUB_REPORTS');
2881: fnd_message.set_token('PROCESS_DISPLAY_NAME',lv_process_display_name,false);
2888: -- set the document type
2889: document_type := wf_notification.doc_html;
2890:
2891: if g_debug then
2892: hr_utility.set_location('Leaving:'|| g_package||'.'||c_proc, 30);
2893: end if;
2894:
2895: exception
2896: when others then
2894:
2895: exception
2896: when others then
2897: document :=null;
2898: hr_utility.set_location('hr_workflow_ss.getApprovalMsgSubject errored : '||SQLERRM ||' '||to_char(SQLCODE), 40);
2899: Wf_Core.Context('hr_workflow_ss', 'getApprovalMsgSubject', document_id, display_type);
2900: raise;
2901: end getGoldApprovalMsgSubject;
2902:
2907: l_item_type varchar2(240);
2908: l_proc varchar2(72) := g_package || 'set_start_date';
2909: begin
2910:
2911: hr_utility.set_location('Entering: '||l_proc,10);
2912:
2913: begin
2914: select item_type,item_key
2915: into l_item_type,l_item_key
2915: into l_item_type,l_item_key
2916: from hr_api_transactions
2917: where transaction_id = p_transaction_id;
2918:
2919: hr_utility.set_location(l_proc||'l_item_key='||l_item_key,41);
2920: Exception
2921: when others then l_item_key := null;
2922: l_item_type := null;
2923: End;
2920: Exception
2921: when others then l_item_key := null;
2922: l_item_type := null;
2923: End;
2924: hr_utility.set_location('Entering: '||l_proc,42);
2925: if ((l_item_key is not null) and (l_item_type is not null) and (p_effective_date is not null))
2926: then
2927: Wf_Engine.SetItemAttrDate(itemtype => l_item_type
2928: ,itemkey => l_item_key
2928: ,itemkey => l_item_key
2929: ,aname => 'CURRENT_EFFECTIVE_DATE'
2930: ,avalue => TO_DATE(TO_CHAR(p_effective_date,'RRRR-MM-DD'),'RRRR-MM-DD'));
2931:
2932: hr_utility.set_location('Entering: '||l_proc,43);
2933: end if;
2934: exception
2935: when others then
2936: hr_utility.set_location(l_proc||sqlerrm,50);
2932: hr_utility.set_location('Entering: '||l_proc,43);
2933: end if;
2934: exception
2935: when others then
2936: hr_utility.set_location(l_proc||sqlerrm,50);
2937: null;
2938: end;
2939:
2940: end hr_person_deployment_swi;