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.19 2010/06/04 07:02:10 gpurohit 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 1146: Wf_Core.Context('hr_workflow_ss', 'GetActivityAttrText', itemtype, itemkey,

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

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

1186: return null;
1187: end if;
1188: exception
1189: when others then
1190: Wf_Core.Context('hr_workflow_ss', 'GetActivityAttrDate', itemtype, itemkey,
1191: to_char(actid), aname);
1192: raise;
1193: end GetActivityAttrDate;
1194:

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

1233: return null;
1234: end if;
1235: exception
1236: when others then
1237: Wf_Core.Context('hr_workflow_ss', 'GetActivityAttrNumber', itemtype, itemkey,
1238: to_char(actid), aname);
1239: raise;
1240: end GetActivityAttrNumber;
1241:

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

1408: return null;
1409: end if;
1410: exception
1411: when others then
1412: Wf_Core.Context('hr_workflow_ss', 'GetItemAttrText', itemtype, itemkey,
1413: aname);
1414: raise;
1415: end GetItemAttrText;
1416:

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

1458: p_itemKey := lv_item_key;
1459:
1460: exception
1461: when others then
1462: hr_utility.set_location('hr_workflow_ss.get_item_type_and_key errored : '||SQLERRM ||' '||to_char(SQLCODE), 30);
1463: Wf_Core.Context('hr_workflow_ss', 'get_item_type_and_key', p_ntfId);
1464: raise;
1465: end get_item_type_and_key;
1466:

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

1459:
1460: exception
1461: when others then
1462: hr_utility.set_location('hr_workflow_ss.get_item_type_and_key errored : '||SQLERRM ||' '||to_char(SQLCODE), 30);
1463: Wf_Core.Context('hr_workflow_ss', 'get_item_type_and_key', p_ntfId);
1464: raise;
1465: end get_item_type_and_key;
1466:
1467: procedure build_edit_link(document_id IN Varchar2,

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

1506: return;
1507: end if;
1508:
1509: -- get the itemtype and item key for the notification id
1510: hr_workflow_ss.get_item_type_and_key(document_id,lv_item_type,lv_item_key);
1511:
1512: -- check if the workflow process has been configured to
1513: --restrict edit to transaction owner/creator
1514: -- HR_RESTRICT_EDIT_ATTR

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

1610: exception
1611: when others then
1612: document := null;
1613: document_type :=null;
1614: hr_utility.set_location('hr_workflow_ss.build_edit_link errored : '||SQLERRM ||' '||to_char(SQLCODE), 20);
1615: Wf_Core.Context('hr_workflow_ss', 'build_edit_link', document_id, display_type);
1616: raise;
1617: end build_edit_link;
1618:

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

1611: when others then
1612: document := null;
1613: document_type :=null;
1614: hr_utility.set_location('hr_workflow_ss.build_edit_link errored : '||SQLERRM ||' '||to_char(SQLCODE), 20);
1615: Wf_Core.Context('hr_workflow_ss', 'build_edit_link', document_id, display_type);
1616: raise;
1617: end build_edit_link;
1618:
1619:

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

1657:
1658: return(lvalue);
1659: exception
1660: when others then
1661: wf_core.context('hr_workflow_ss', 'GetAttrNumber', to_char(nid), aname);
1662: hr_utility.set_location('Error querying wf_notification_attributes.NUMBER_VALUE for aname:nid'||aname||':'||nid||'-'||SQLERRM ||' '||to_char(SQLCODE), 10);
1663: raise;
1664: end GetAttrNumber;
1665:

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

1702:
1703: return(lvalue);
1704: exception
1705: when others then
1706: wf_core.context('hr_workflow_ss', 'GetAttrText', to_char(nid), aname);
1707: hr_utility.set_location('Error querying wf_notification_attributes.text_value for aname:nid'||aname||':'||nid||'-'||SQLERRM ||' '||to_char(SQLCODE), 10);
1708: raise;
1709: end GetAttrText;
1710:

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

1913: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
1914: end if;
1915:
1916: if g_debug then
1917: hr_utility.set_location('Calling hr_workflow_ss.get_item_type_and_key for NtfId:'||document_id, 11);
1918: end if;
1919: -- get the itemtype and item key for the notification id
1920: hr_workflow_ss.get_item_type_and_key(document_id,lv_item_type,lv_item_key);
1921: -- set the document type

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

1916: if g_debug then
1917: hr_utility.set_location('Calling hr_workflow_ss.get_item_type_and_key for NtfId:'||document_id, 11);
1918: end if;
1919: -- get the itemtype and item key for the notification id
1920: hr_workflow_ss.get_item_type_and_key(document_id,lv_item_type,lv_item_key);
1921: -- set the document type
1922: document_type := wf_notification.doc_html;
1923: -- set the document
1924: if g_debug then

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

1925: hr_utility.set_location('Calling getProcessDisplayName',12);
1926: hr_utility.set_location('ItemType:'||lv_item_type,13);
1927: hr_utility.set_location('ItemKey:'||lv_item_key,14);
1928: end if;
1929: document := hr_workflow_ss.getProcessDisplayName(lv_item_type,lv_item_key);
1930:
1931: if g_debug then
1932: hr_utility.set_location('Leaving:'|| g_package||'.'||c_proc, 30);
1933: end if;

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

1934:
1935: exception
1936: when others then
1937: document :=null;
1938: hr_utility.set_location('hr_workflow_ss.getProcessDisplayName errored : '||SQLERRM ||' '||to_char(SQLCODE), 20);
1939: Wf_Core.Context('hr_workflow_ss', 'getProcessDisplayName', document_id, display_type);
1940: raise;
1941: end getProcessDisplayName;
1942:

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

1935: exception
1936: when others then
1937: document :=null;
1938: hr_utility.set_location('hr_workflow_ss.getProcessDisplayName errored : '||SQLERRM ||' '||to_char(SQLCODE), 20);
1939: Wf_Core.Context('hr_workflow_ss', 'getProcessDisplayName', document_id, display_type);
1940: raise;
1941: end getProcessDisplayName;
1942:
1943:

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

1987: End If;
1988: exception
1989: when others then
1990: document :=null;
1991: hr_utility.set_location('hr_workflow_ss.getApprovalMsgSubject errored for custom call: '||SQLERRM ||' '||to_char(SQLCODE), 100);
1992: Wf_Core.Context('hr_workflow_ss', 'getApprovalMsgSubject', document_id, display_type);
1993: raise;
1994: end;
1995:

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

1988: exception
1989: when others then
1990: document :=null;
1991: hr_utility.set_location('hr_workflow_ss.getApprovalMsgSubject errored for custom call: '||SQLERRM ||' '||to_char(SQLCODE), 100);
1992: Wf_Core.Context('hr_workflow_ss', 'getApprovalMsgSubject', document_id, display_type);
1993: raise;
1994: end;
1995:
1996:

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

1996:
1997:
1998: -- get the itemtype and item key for the notification id
1999: if g_debug then
2000: hr_utility.set_location('Calling hr_workflow_ss.get_item_type_and_key for NtfId:'||document_id, 11);
2001: end if;
2002: hr_workflow_ss.get_item_type_and_key(document_id,lv_item_type,lv_item_key);
2003:
2004: -- get the process display name

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

1998: -- get the itemtype and item key for the notification id
1999: if g_debug then
2000: hr_utility.set_location('Calling hr_workflow_ss.get_item_type_and_key for NtfId:'||document_id, 11);
2001: end if;
2002: hr_workflow_ss.get_item_type_and_key(document_id,lv_item_type,lv_item_key);
2003:
2004: -- get the process display name
2005: if g_debug then
2006: hr_utility.set_location('Calling getProcessDisplayName',12);

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

2006: hr_utility.set_location('Calling getProcessDisplayName',12);
2007: hr_utility.set_location('ItemType:'||lv_item_type,13);
2008: hr_utility.set_location('ItemKey:'||lv_item_key,14);
2009: end if;
2010: -- lv_process_display_name := hr_workflow_ss.getProcessDisplayName(lv_item_type,lv_item_key);
2011:
2012: lv_ntf_sub_msg := wf_engine.GetItemAttrText(itemtype => lv_item_type ,
2013: itemkey => lv_item_key,
2014: aname => 'HR_NTF_SUB_FND_MSG_ATTR',

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

2014: aname => 'HR_NTF_SUB_FND_MSG_ATTR',
2015: ignore_notfound=>true);
2016:
2017: if(lv_ntf_sub_msg is null) then
2018: lv_process_display_name := hr_workflow_ss.getProcessDisplayName(lv_item_type,lv_item_key);
2019: else
2020: fnd_message.set_name('PER',lv_ntf_sub_msg);
2021: lv_process_display_name:= fnd_message.get;
2022: end if;

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

2133:
2134: exception
2135: when others then
2136: document :=null;
2137: hr_utility.set_location('hr_workflow_ss.getApprovalMsgSubject errored : '||SQLERRM ||' '||to_char(SQLCODE), 40);
2138: Wf_Core.Context('hr_workflow_ss', 'getApprovalMsgSubject', document_id, display_type);
2139: raise;
2140: end getApprovalMsgSubject;
2141:

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

2134: exception
2135: when others then
2136: document :=null;
2137: hr_utility.set_location('hr_workflow_ss.getApprovalMsgSubject errored : '||SQLERRM ||' '||to_char(SQLCODE), 40);
2138: Wf_Core.Context('hr_workflow_ss', 'getApprovalMsgSubject', document_id, display_type);
2139: raise;
2140: end getApprovalMsgSubject;
2141:
2142:

Line 2575: END hr_workflow_ss;

2571: RAISE;
2572: END isFyiNtfDet;
2573:
2574:
2575: END hr_workflow_ss;