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_WORKFLOW_SS dependencies on HR_WORKFLOW_SS

Line 1: PACKAGE BODY hr_workflow_ss AS

1: PACKAGE BODY hr_workflow_ss AS
2: /* $Header: hrwkflss.pkb 120.9.12000000.2 2007/09/27 11:06:12 dbatra ship $ */
3: /*
4: This package contails new (v4.0+)workflow related business logic
5: */

Line 9: g_package varchar2(33) := 'hr_workflow_ss.';

5: */
6: --
7: -- Package Variables
8: --
9: g_package varchar2(33) := 'hr_workflow_ss.';
10: g_asg_api_name constant varchar2(80)
11: default 'HR_PROCESS_ASSIGNMENT_SS.PROCESS_API';
12: -- Salary Basis Enhancement Change Begins
13: g_mid_pay_period_change constant varchar2(30) := 'HR_MID_PAY_PERIOD_CHANGE';

Line 1104: Wf_Core.Context('hr_workflow_ss', 'GetActivityAttrText', itemtype, itemkey,

1100: return null;
1101: end if;
1102: exception
1103: when others then
1104: Wf_Core.Context('hr_workflow_ss', 'GetActivityAttrText', itemtype, itemkey,
1105: to_char(actid), aname);
1106: raise;
1107: end GetActivityAttrText;
1108:

Line 1148: Wf_Core.Context('hr_workflow_ss', 'GetActivityAttrDate', itemtype, itemkey,

1144: return null;
1145: end if;
1146: exception
1147: when others then
1148: Wf_Core.Context('hr_workflow_ss', 'GetActivityAttrDate', itemtype, itemkey,
1149: to_char(actid), aname);
1150: raise;
1151: end GetActivityAttrDate;
1152:

Line 1195: Wf_Core.Context('hr_workflow_ss', 'GetActivityAttrNumber', itemtype, itemkey,

1191: return null;
1192: end if;
1193: exception
1194: when others then
1195: Wf_Core.Context('hr_workflow_ss', 'GetActivityAttrNumber', itemtype, itemkey,
1196: to_char(actid), aname);
1197: raise;
1198: end GetActivityAttrNumber;
1199:

Line 1370: Wf_Core.Context('hr_workflow_ss', 'GetItemAttrText', itemtype, itemkey,

1366: return null;
1367: end if;
1368: exception
1369: when others then
1370: Wf_Core.Context('hr_workflow_ss', 'GetItemAttrText', itemtype, itemkey,
1371: aname);
1372: raise;
1373: end GetItemAttrText;
1374:

Line 1420: hr_utility.set_location('hr_workflow_ss.get_item_type_and_key errored : '||SQLERRM ||' '||to_char(SQLCODE), 30);

1416: p_itemKey := lv_item_key;
1417:
1418: exception
1419: when others then
1420: hr_utility.set_location('hr_workflow_ss.get_item_type_and_key errored : '||SQLERRM ||' '||to_char(SQLCODE), 30);
1421: Wf_Core.Context('hr_workflow_ss', 'get_item_type_and_key', p_ntfId);
1422: raise;
1423: end get_item_type_and_key;
1424:

Line 1421: Wf_Core.Context('hr_workflow_ss', 'get_item_type_and_key', p_ntfId);

1417:
1418: exception
1419: when others then
1420: hr_utility.set_location('hr_workflow_ss.get_item_type_and_key errored : '||SQLERRM ||' '||to_char(SQLCODE), 30);
1421: Wf_Core.Context('hr_workflow_ss', 'get_item_type_and_key', p_ntfId);
1422: raise;
1423: end get_item_type_and_key;
1424:
1425: procedure build_edit_link(document_id IN Varchar2,

Line 1468: hr_workflow_ss.get_item_type_and_key(document_id,lv_item_type,lv_item_key);

1464: return;
1465: end if;
1466:
1467: -- get the itemtype and item key for the notification id
1468: hr_workflow_ss.get_item_type_and_key(document_id,lv_item_type,lv_item_key);
1469:
1470: -- check if the workflow process has been configured to
1471: --restrict edit to transaction owner/creator
1472: -- HR_RESTRICT_EDIT_ATTR

Line 1572: hr_utility.set_location('hr_workflow_ss.build_edit_link errored : '||SQLERRM ||' '||to_char(SQLCODE), 20);

1568: exception
1569: when others then
1570: document := null;
1571: document_type :=null;
1572: hr_utility.set_location('hr_workflow_ss.build_edit_link errored : '||SQLERRM ||' '||to_char(SQLCODE), 20);
1573: Wf_Core.Context('hr_workflow_ss', 'build_edit_link', document_id, display_type);
1574: raise;
1575: end build_edit_link;
1576:

Line 1573: Wf_Core.Context('hr_workflow_ss', 'build_edit_link', document_id, display_type);

1569: when others then
1570: document := null;
1571: document_type :=null;
1572: hr_utility.set_location('hr_workflow_ss.build_edit_link errored : '||SQLERRM ||' '||to_char(SQLCODE), 20);
1573: Wf_Core.Context('hr_workflow_ss', 'build_edit_link', document_id, display_type);
1574: raise;
1575: end build_edit_link;
1576:
1577:

Line 1619: wf_core.context('hr_workflow_ss', 'GetAttrNumber', to_char(nid), aname);

1615:
1616: return(lvalue);
1617: exception
1618: when others then
1619: wf_core.context('hr_workflow_ss', 'GetAttrNumber', to_char(nid), aname);
1620: hr_utility.set_location('Error querying wf_notification_attributes.NUMBER_VALUE for aname:nid'||aname||':'||nid||'-'||SQLERRM ||' '||to_char(SQLCODE), 10);
1621: raise;
1622: end GetAttrNumber;
1623:

Line 1664: wf_core.context('hr_workflow_ss', 'GetAttrText', to_char(nid), aname);

1660:
1661: return(lvalue);
1662: exception
1663: when others then
1664: wf_core.context('hr_workflow_ss', 'GetAttrText', to_char(nid), aname);
1665: hr_utility.set_location('Error querying wf_notification_attributes.text_value for aname:nid'||aname||':'||nid||'-'||SQLERRM ||' '||to_char(SQLCODE), 10);
1666: raise;
1667: end GetAttrText;
1668:

Line 1875: hr_utility.set_location('Calling hr_workflow_ss.get_item_type_and_key for NtfId:'||document_id, 11);

1871: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
1872: end if;
1873:
1874: if g_debug then
1875: hr_utility.set_location('Calling hr_workflow_ss.get_item_type_and_key for NtfId:'||document_id, 11);
1876: end if;
1877: -- get the itemtype and item key for the notification id
1878: hr_workflow_ss.get_item_type_and_key(document_id,lv_item_type,lv_item_key);
1879: -- set the document type

Line 1878: hr_workflow_ss.get_item_type_and_key(document_id,lv_item_type,lv_item_key);

1874: if g_debug then
1875: hr_utility.set_location('Calling hr_workflow_ss.get_item_type_and_key for NtfId:'||document_id, 11);
1876: end if;
1877: -- get the itemtype and item key for the notification id
1878: hr_workflow_ss.get_item_type_and_key(document_id,lv_item_type,lv_item_key);
1879: -- set the document type
1880: document_type := wf_notification.doc_html;
1881: -- set the document
1882: if g_debug then

Line 1887: document := hr_workflow_ss.getProcessDisplayName(lv_item_type,lv_item_key);

1883: hr_utility.set_location('Calling getProcessDisplayName',12);
1884: hr_utility.set_location('ItemType:'||lv_item_type,13);
1885: hr_utility.set_location('ItemKey:'||lv_item_key,14);
1886: end if;
1887: document := hr_workflow_ss.getProcessDisplayName(lv_item_type,lv_item_key);
1888:
1889: if g_debug then
1890: hr_utility.set_location('Leaving:'|| g_package||'.'||c_proc, 30);
1891: end if;

Line 1896: hr_utility.set_location('hr_workflow_ss.getProcessDisplayName errored : '||SQLERRM ||' '||to_char(SQLCODE), 20);

1892:
1893: exception
1894: when others then
1895: document :=null;
1896: hr_utility.set_location('hr_workflow_ss.getProcessDisplayName errored : '||SQLERRM ||' '||to_char(SQLCODE), 20);
1897: Wf_Core.Context('hr_workflow_ss', 'getProcessDisplayName', document_id, display_type);
1898: raise;
1899: end getProcessDisplayName;
1900:

Line 1897: Wf_Core.Context('hr_workflow_ss', 'getProcessDisplayName', document_id, display_type);

1893: exception
1894: when others then
1895: document :=null;
1896: hr_utility.set_location('hr_workflow_ss.getProcessDisplayName errored : '||SQLERRM ||' '||to_char(SQLCODE), 20);
1897: Wf_Core.Context('hr_workflow_ss', 'getProcessDisplayName', document_id, display_type);
1898: raise;
1899: end getProcessDisplayName;
1900:
1901:

Line 1949: hr_utility.set_location('hr_workflow_ss.getApprovalMsgSubject errored for custom call: '||SQLERRM ||' '||to_char(SQLCODE), 100);

1945: End If;
1946: exception
1947: when others then
1948: document :=null;
1949: hr_utility.set_location('hr_workflow_ss.getApprovalMsgSubject errored for custom call: '||SQLERRM ||' '||to_char(SQLCODE), 100);
1950: Wf_Core.Context('hr_workflow_ss', 'getApprovalMsgSubject', document_id, display_type);
1951: raise;
1952: end;
1953:

Line 1950: Wf_Core.Context('hr_workflow_ss', 'getApprovalMsgSubject', document_id, display_type);

1946: exception
1947: when others then
1948: document :=null;
1949: hr_utility.set_location('hr_workflow_ss.getApprovalMsgSubject errored for custom call: '||SQLERRM ||' '||to_char(SQLCODE), 100);
1950: Wf_Core.Context('hr_workflow_ss', 'getApprovalMsgSubject', document_id, display_type);
1951: raise;
1952: end;
1953:
1954:

Line 1958: hr_utility.set_location('Calling hr_workflow_ss.get_item_type_and_key for NtfId:'||document_id, 11);

1954:
1955:
1956: -- get the itemtype and item key for the notification id
1957: if g_debug then
1958: hr_utility.set_location('Calling hr_workflow_ss.get_item_type_and_key for NtfId:'||document_id, 11);
1959: end if;
1960: hr_workflow_ss.get_item_type_and_key(document_id,lv_item_type,lv_item_key);
1961:
1962: -- get the process display name

Line 1960: hr_workflow_ss.get_item_type_and_key(document_id,lv_item_type,lv_item_key);

1956: -- get the itemtype and item key for the notification id
1957: if g_debug then
1958: hr_utility.set_location('Calling hr_workflow_ss.get_item_type_and_key for NtfId:'||document_id, 11);
1959: end if;
1960: hr_workflow_ss.get_item_type_and_key(document_id,lv_item_type,lv_item_key);
1961:
1962: -- get the process display name
1963: if g_debug then
1964: hr_utility.set_location('Calling getProcessDisplayName',12);

Line 1968: -- lv_process_display_name := hr_workflow_ss.getProcessDisplayName(lv_item_type,lv_item_key);

1964: hr_utility.set_location('Calling getProcessDisplayName',12);
1965: hr_utility.set_location('ItemType:'||lv_item_type,13);
1966: hr_utility.set_location('ItemKey:'||lv_item_key,14);
1967: end if;
1968: -- lv_process_display_name := hr_workflow_ss.getProcessDisplayName(lv_item_type,lv_item_key);
1969:
1970: lv_ntf_sub_msg := wf_engine.GetItemAttrText(itemtype => lv_item_type ,
1971: itemkey => lv_item_key,
1972: aname => 'HR_NTF_SUB_FND_MSG_ATTR',

Line 1976: lv_process_display_name := hr_workflow_ss.getProcessDisplayName(lv_item_type,lv_item_key);

1972: aname => 'HR_NTF_SUB_FND_MSG_ATTR',
1973: ignore_notfound=>true);
1974:
1975: if(lv_ntf_sub_msg is null) then
1976: lv_process_display_name := hr_workflow_ss.getProcessDisplayName(lv_item_type,lv_item_key);
1977: else
1978: fnd_message.set_name('PER',lv_ntf_sub_msg);
1979: lv_process_display_name:= fnd_message.get;
1980: end if;

Line 2093: hr_utility.set_location('hr_workflow_ss.getApprovalMsgSubject errored : '||SQLERRM ||' '||to_char(SQLCODE), 40);

2089:
2090: exception
2091: when others then
2092: document :=null;
2093: hr_utility.set_location('hr_workflow_ss.getApprovalMsgSubject errored : '||SQLERRM ||' '||to_char(SQLCODE), 40);
2094: Wf_Core.Context('hr_workflow_ss', 'getApprovalMsgSubject', document_id, display_type);
2095: raise;
2096: end getApprovalMsgSubject;
2097:

Line 2094: Wf_Core.Context('hr_workflow_ss', 'getApprovalMsgSubject', document_id, display_type);

2090: exception
2091: when others then
2092: document :=null;
2093: hr_utility.set_location('hr_workflow_ss.getApprovalMsgSubject errored : '||SQLERRM ||' '||to_char(SQLCODE), 40);
2094: Wf_Core.Context('hr_workflow_ss', 'getApprovalMsgSubject', document_id, display_type);
2095: raise;
2096: end getApprovalMsgSubject;
2097:
2098:

Line 2406: END hr_workflow_ss;

2402: raise;
2403: end Authenticate;
2404:
2405:
2406: END hr_workflow_ss;