DBA Data[Home] [Help]

APPS.CS_WF_ACTIVITIES_PKG dependencies on CS_WORKFLOW_PUB

Line 291: CS_WORKFLOW_PUB.Decode_Servereq_Itemkey(

287:
288: IF (funmode = 'RUN') THEN
289:
290: -- Decode the item key to get the service request number
291: CS_WORKFLOW_PUB.Decode_Servereq_Itemkey(
292: p_api_version => 1.0,
293: p_return_status => l_return_status,
294: p_msg_count => l_msg_count,
295: p_msg_data => l_msg_data,

Line 301: wf_core.context( pkg_name => 'CS_WORKFLOW_PUB',

297: p_request_number => l_request_number,
298: p_wf_process_id => l_dummy );
299:
300: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
301: wf_core.context( pkg_name => 'CS_WORKFLOW_PUB',
302: proc_name => 'Decode_Servereq_Itemkey',
303: arg1 => 'p_itemkey=>'||itemkey );
304: l_errmsg_name := 'CS_WF_SR_CANT_DECODE_ITEMKEY';
305: raise l_API_ERROR;

Line 482: CS_WORKFLOW_PUB.Get_Employee_Role (

478:
479: CLOSE l_get_source_id;
480:
481: -- Retrieve the role name for the request owner
482: CS_WORKFLOW_PUB.Get_Employee_Role (
483: p_api_version => 1.0,
484: p_return_status => l_return_status,
485: p_msg_count => l_msg_count,
486: p_msg_data => l_msg_data,

Line 494: wf_core.context( pkg_name => 'CS_WORKFLOW_PUB',

490: p_role_display_name => l_owner_name );
491:
492: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) OR
493: (l_owner_role is NULL) THEN
494: wf_core.context( pkg_name => 'CS_WORKFLOW_PUB',
495: proc_name => 'Get_Employee_Role',
496: arg1 => 'p_employee_id=>'|| l_source_id);
497: --to_char(l_ServiceRequest_rec.incident_owner_id));
498: l_errmsg_name := 'CS_WF_SR_CANT_FIND_OWNER';

Line 504: wf_core.context( pkg_name => 'CS_WORKFLOW_PUB',

500: END IF;
501:
502: ELSE
503: CLOSE l_get_source_id;
504: wf_core.context( pkg_name => 'CS_WORKFLOW_PUB',
505: proc_name => 'Get_Employee_Role',
506: arg1 => 'p_employee_id=>'||
507: to_char(l_ServiceRequest_rec.incident_owner_id));
508: l_errmsg_name := 'CS_WF_SR_CANT_FIND_OWNER';

Line 692: CS_WORKFLOW_PUB.Get_Emp_Supervisor(

688: CLOSE sel_recipient_role_csr;
689: -- END of fix for Bug 1810781 rmanabat
690:
691: -- Get the supervisor information
692: CS_WORKFLOW_PUB.Get_Emp_Supervisor(
693: p_api_version => 1.0,
694: p_return_status => l_return_status,
695: p_init_msg_list => FND_API.G_TRUE,
696: p_msg_count => l_msg_count,

Line 705: wf_core.context( pkg_name => 'CS_WORKFLOW_PUB',

701: p_supervisor_name => l_supervisor_name );
702:
703: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) OR
704: (l_supervisor_role IS NULL) THEN
705: wf_core.context( pkg_name => 'CS_WORKFLOW_PUB',
706: proc_name => 'Get_Emp_Supervisor',
707: arg1 => 'p_employee_id=>'||to_char(l_owner_id) );
708: l_errmsg_name := 'CS_SR_CANT_FIND_SUPERVISOR';
709: raise l_API_ERROR;

Line 833: CS_WORKFLOW_PUB.Get_Employee_Role (

829: aname => 'NEW_OWNER_ID' );
830:
831:
832: -- Get the new owner information
833: CS_WORKFLOW_PUB.Get_Employee_Role (
834: p_api_version => 1.0,
835: p_init_msg_list => FND_API.G_FALSE,
836: p_return_status => l_return_status,
837: p_msg_count => l_msg_count,

Line 845: wf_core.context( pkg_name => 'CS_WORKFLOW_PUB',

841: p_role_display_name => l_new_owner_name );
842:
843: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) OR
844: (l_new_owner_role IS NULL) THEN
845: wf_core.context( pkg_name => 'CS_WORKFLOW_PUB',
846: proc_name => 'Get_Employee_Role',
847: arg1 => 'p_employee_id=>'||to_char(l_new_owner_id) );
848: l_errmsg_name := 'CS_WF_SR_CANT_FIND_OWNER';
849: raise l_API_ERROR;

Line 854: CS_WORKFLOW_PUB.Get_Emp_Fnd_User_ID(

850: END IF;
851:
852: -- Get the FND_USER ID of the current owner so that we can
853: -- use it for the audit record
854: CS_WORKFLOW_PUB.Get_Emp_Fnd_User_ID(
855: p_api_version => 1.0,
856: p_return_status => l_return_status,
857: p_msg_count => l_msg_count,
858: p_msg_data => l_msg_data,

Line 863: wf_core.context( pkg_name => 'CS_WORKFLOW_PUB',

859: p_employee_id => l_owner_id,
860: p_fnd_user_id => l_user_id );
861:
862: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
863: wf_core.context( pkg_name => 'CS_WORKFLOW_PUB',
864: proc_name => 'Get_Emp_Fnd_User_ID',
865: arg1 => 'p_employee_id=>'||to_char(l_owner_id) );
866: l_errmsg_name := 'CS_WF_SR_GET_EMP_USER_ID';
867: raise l_API_ERROR;

Line 871: CS_Workflow_PUB.Decode_Servereq_Itemkey(

867: raise l_API_ERROR;
868: END IF;
869:
870: -- Get the workflow process ID
871: CS_Workflow_PUB.Decode_Servereq_Itemkey(
872: p_api_version => 1.0,
873: p_init_msg_list => FND_API.G_FALSE,
874: p_return_status => l_return_status,
875: p_msg_count => l_msg_count,

Line 882: wf_core.context( pkg_name => 'CS_WORKFLOW_PUB',

878: p_request_number => l_request_number,
879: p_wf_process_id => l_wf_process_id );
880:
881: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
882: wf_core.context( pkg_name => 'CS_WORKFLOW_PUB',
883: proc_name => 'Decode_Servereq_Itemkey',
884: arg1 => 'p_itemkey=>'||itemkey );
885: l_errmsg_name := 'CS_WF_SR_CANT_DECODE_ITEMKEY';
886: raise l_API_ERROR;

Line 1105: CS_WORKFLOW_PUB.Get_Emp_Fnd_User_ID(

1101:
1102: /* Commenting out this call, l_user_id used for update_service_request
1103: (last_updated_by) should always be the FND_USER .
1104:
1105: CS_WORKFLOW_PUB.Get_Emp_Fnd_User_ID(
1106: p_api_version => 1.0,
1107: p_return_status => l_return_status,
1108: p_msg_count => l_msg_count,
1109: p_msg_data => l_msg_data,

Line 1114: wf_core.context( pkg_name => 'CS_WORKFLOW_PUB',

1110: p_employee_id => l_owner_id,
1111: p_fnd_user_id => l_user_id );
1112:
1113: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1114: wf_core.context( pkg_name => 'CS_WORKFLOW_PUB',
1115: proc_name => 'Get_Emp_Fnd_User_ID',
1116: arg1 => 'p_employee_id=>'||to_char(l_owner_id) );
1117: l_errmsg_name := 'CS_WF_SR_GET_EMP_USER_ID';
1118: raise l_API_ERROR;

Line 1121: -- Replacing call to CS_WORKFLOW_PUB.Get_Emp_Fnd_User_ID

1117: l_errmsg_name := 'CS_WF_SR_GET_EMP_USER_ID';
1118: raise l_API_ERROR;
1119: END IF;
1120: */
1121: -- Replacing call to CS_WORKFLOW_PUB.Get_Emp_Fnd_User_ID
1122: -- with FND_USER profile. rmanabat 09/18/01
1123:
1124: /* Roopa
1125: Fix for bug 2843395

Line 1136: CS_WORKFLOW_PUB.Get_Emp_Fnd_User_ID(

1132:
1133: IF (l_user_id IS NULL) THEN
1134:
1135: IF(l_owner_id IS NOT NULL) THEN
1136: CS_WORKFLOW_PUB.Get_Emp_Fnd_User_ID(
1137: p_api_version => 1.0,
1138: p_return_status => l_return_status,
1139: p_msg_count => l_msg_count,
1140: p_msg_data => l_msg_data,

Line 1145: wf_core.context( pkg_name => 'CS_WORKFLOW_PUB',

1141: p_employee_id => l_owner_id,
1142: p_fnd_user_id => l_user_id );
1143:
1144: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1145: wf_core.context( pkg_name => 'CS_WORKFLOW_PUB',
1146: proc_name => 'Get_Emp_Fnd_User_ID',
1147: arg1 => 'p_employee_id=>'||to_char(l_owner_id) );
1148: l_errmsg_name := 'CS_WF_SR_GET_EMP_USER_ID';
1149: raise l_API_ERROR;

Line 1157: CS_Workflow_PUB.Decode_Servereq_Itemkey(

1153: END IF;
1154: END IF;
1155:
1156: -- Get the workflow process ID
1157: CS_Workflow_PUB.Decode_Servereq_Itemkey(
1158: p_api_version => 1.0,
1159: p_init_msg_list => FND_API.G_FALSE,
1160: p_return_status => l_return_status,
1161: p_msg_count => l_msg_count,

Line 1168: wf_core.context( pkg_name => 'CS_WORKFLOW_PUB',

1164: p_request_number => l_request_number,
1165: p_wf_process_id => l_wf_process_id );
1166:
1167: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1168: wf_core.context( pkg_name => 'CS_WORKFLOW_PUB',
1169: proc_name => 'Decode_Servereq_Itemkey',
1170: arg1 => 'p_itemkey=>'||itemkey );
1171: l_errmsg_name := 'CS_WF_SR_CANT_DECODE_ITEMKEY';
1172: raise l_API_ERROR;

Line 1715: CS_Workflow_PUB.Decode_Action_Itemkey

1711: BEGIN
1712: IF (funcmode = 'RUN') THEN
1713:
1714: -- Decode the item key to get the service request id and action number
1715: CS_Workflow_PUB.Decode_Action_Itemkey
1716: ( p_api_version => 1.0,
1717: p_return_status => l_return_status,
1718: p_msg_count => l_msg_count,
1719: p_msg_data => l_msg_data,

Line 1729: WF_CORE.Context( pkg_name => 'CS_Workflow_PUB',

1725: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1726: FND_MSG_PUB.Count_And_Get( p_count => l_msg_count,
1727: p_data => l_msg_data,
1728: p_encoded => FND_API.G_FALSE );
1729: WF_CORE.Context( pkg_name => 'CS_Workflow_PUB',
1730: proc_name => 'Decode_Action_Itemkey',
1731: arg1 => 'p_itemkey=>'||itemkey,
1732: arg2 => 'p_msg_data=>'||l_msg_data );
1733: l_errmsg_name := 'CS_WF_SR_CANT_DECODE_ITEMKEY';

Line 1755: CS_Workflow_PUB.Get_Employee_Role

1751: avalue => l_action_rec.incident_id
1752: );
1753:
1754: -- Retrieve the role name for the request action assignee
1755: CS_Workflow_PUB.Get_Employee_Role
1756: ( p_api_version => 1.0,
1757: p_return_status => l_return_status,
1758: p_msg_count => l_msg_count,
1759: p_msg_data => l_msg_data,

Line 1769: WF_CORE.Context( pkg_name => 'CS_Workflow_PUB',

1765: (l_assignee_role IS NULL)) THEN
1766: FND_MSG_PUB.Count_And_Get( p_count => l_msg_count,
1767: p_data => l_msg_data,
1768: p_encoded => FND_API.G_FALSE );
1769: WF_CORE.Context( pkg_name => 'CS_Workflow_PUB',
1770: proc_name => 'Get_Employee_Role',
1771: arg1 => 'p_employee_id=>'||l_action_rec.action_assignee_id,
1772: arg2 => 'p_msg_data=>'||l_msg_data );
1773: l_errmsg_name := 'CS_WF_SR_CANT_FIND_OWNER';