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.CS_WF_ACTIVITIES_PKG dependencies on FND_API

Line 300: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

296: p_itemkey => itemkey,
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';

Line 492: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) OR

488: p_employee_id => l_source_id,
489: p_role_name => l_owner_role,
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);

Line 695: p_init_msg_list => FND_API.G_TRUE,

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,
697: p_msg_data => l_msg_data,
698: p_employee_id => l_owner_id,
699: p_supervisor_emp_id => l_supervisor_id,

Line 703: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) OR

699: p_supervisor_emp_id => l_supervisor_id,
700: p_supervisor_role => l_supervisor_role,
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) );

Line 835: p_init_msg_list => FND_API.G_FALSE,

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,
838: p_msg_data => l_msg_data,
839: p_employee_id => l_new_owner_id,

Line 843: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) OR

839: p_employee_id => l_new_owner_id,
840: p_role_name => l_new_owner_role,
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) );

Line 862: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

858: p_msg_data => l_msg_data,
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';

Line 873: p_init_msg_list => FND_API.G_FALSE,

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,
876: p_msg_data => l_msg_data,
877: p_itemkey => itemkey,

Line 881: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

877: p_itemkey => itemkey,
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';

Line 933: p_init_msg_list => FND_API.G_FALSE,

929: END IF;
930:
931: CS_ServiceRequest_PUB.Update_Owner (
932: p_api_version => 2.0,
933: p_init_msg_list => FND_API.G_FALSE,
934: p_commit => FND_API.G_FALSE,
935: x_return_status => l_return_status,
936: x_msg_count => l_msg_count,
937: x_msg_data => l_msg_data,

Line 934: p_commit => FND_API.G_FALSE,

930:
931: CS_ServiceRequest_PUB.Update_Owner (
932: p_api_version => 2.0,
933: p_init_msg_list => FND_API.G_FALSE,
934: p_commit => FND_API.G_FALSE,
935: x_return_status => l_return_status,
936: x_msg_count => l_msg_count,
937: x_msg_data => l_msg_data,
938: p_user_id => l_user_id,

Line 952: p_called_by_workflow => FND_API.G_TRUE,

948: p_owner_id => l_resource_id,
949: p_owner_group_id => l_owner_group_id,
950: p_resource_type => l_resource_type,
951: p_audit_comments => CS_WF_ACTIVITIES_PKG.Audit_Comments,
952: p_called_by_workflow => FND_API.G_TRUE,
953: p_workflow_process_id => l_wf_process_id,
954: x_interaction_id => l_dummy_id );
955:
956: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

Line 956: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

952: p_called_by_workflow => FND_API.G_TRUE,
953: p_workflow_process_id => l_wf_process_id,
954: x_interaction_id => l_dummy_id );
955:
956: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
957: FND_MSG_PUB.Count_And_Get( p_count => l_msg_count,
958: p_data => l_msg_data,
959: p_encoded => FND_API.G_FALSE );
960: wf_core.context( pkg_name => 'CS_ServiceRequest_PUB',

Line 959: p_encoded => FND_API.G_FALSE );

955:
956: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
957: FND_MSG_PUB.Count_And_Get( p_count => l_msg_count,
958: p_data => l_msg_data,
959: p_encoded => FND_API.G_FALSE );
960: wf_core.context( pkg_name => 'CS_ServiceRequest_PUB',
961: proc_name => 'Update_Owner',
962: arg1 => 'p_user_id=>'||l_user_id,
963: arg2 => 'p_login_id=>'||l_login_id,

Line 1113: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

1109: p_msg_data => l_msg_data,
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';

Line 1144: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

1140: p_msg_data => l_msg_data,
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';

Line 1159: p_init_msg_list => FND_API.G_FALSE,

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,
1162: p_msg_data => l_msg_data,
1163: p_itemkey => itemkey,

Line 1167: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

1163: p_itemkey => itemkey,
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';

Line 1180: l_return_status := FND_API.G_RET_STS_SUCCESS;

1176: -- get object_version_number
1177:
1178: begin
1179: --initialise
1180: l_return_status := FND_API.G_RET_STS_SUCCESS;
1181:
1182: select object_version_number,incident_id
1183: INTO l_object_version_number,l_request_id
1184: from cs_incidents_all_b

Line 1191: l_return_status := FND_API.G_RET_STS_ERROR;

1187: -- dbms_output.put_line('object version ' || l_object_version_number );
1188:
1189: exception
1190: WHEN NO_DATA_FOUND THEN
1191: l_return_status := FND_API.G_RET_STS_ERROR;
1192: CS_ServiceRequest_UTIL.Add_Invalid_Argument_Msg(
1193: p_token_an => l_api_name,
1194: p_token_v => to_char(l_request_id),
1195: p_token_p => 'p_request_id' );

Line 1196: raise FND_API.G_EXC_ERROR;

1192: CS_ServiceRequest_UTIL.Add_Invalid_Argument_Msg(
1193: p_token_an => l_api_name,
1194: p_token_v => to_char(l_request_id),
1195: p_token_p => 'p_request_id' );
1196: raise FND_API.G_EXC_ERROR;
1197:
1198: WHEN TOO_MANY_ROWS THEN
1199: Null;
1200: end;

Line 1235: p_init_msg_list => FND_API.G_FALSE,

1231:
1232: /*
1233: CS_ServiceRequest_PUB.Update_Status (
1234: p_api_version => 2.0,
1235: p_init_msg_list => FND_API.G_FALSE,
1236: p_commit => FND_API.G_FALSE,
1237: x_return_status => l_return_status,
1238: x_msg_count => l_msg_count,
1239: x_msg_data => l_msg_data,

Line 1236: p_commit => FND_API.G_FALSE,

1232: /*
1233: CS_ServiceRequest_PUB.Update_Status (
1234: p_api_version => 2.0,
1235: p_init_msg_list => FND_API.G_FALSE,
1236: p_commit => FND_API.G_FALSE,
1237: x_return_status => l_return_status,
1238: x_msg_count => l_msg_count,
1239: x_msg_data => l_msg_data,
1240: p_user_id => l_user_id,

Line 1249: p_called_by_workflow => FND_API.G_TRUE,

1245: p_object_version_number => l_object_version_number,
1246: p_status_id => l_new_status_id,
1247: p_closed_date => sysdate,
1248: p_audit_comments => CS_WF_ACTIVITIES_PKG.Audit_Comments,
1249: p_called_by_workflow => FND_API.G_TRUE,
1250: p_workflow_process_id => l_wf_process_id,
1251: x_interaction_id => l_dummy_id );
1252:
1253: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

Line 1253: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

1249: p_called_by_workflow => FND_API.G_TRUE,
1250: p_workflow_process_id => l_wf_process_id,
1251: x_interaction_id => l_dummy_id );
1252:
1253: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1254: FND_MSG_PUB.Count_And_Get( p_count => l_msg_count,
1255: p_data => l_msg_data,
1256: p_encoded => FND_API.G_FALSE );
1257: wf_core.context( pkg_name => 'CS_ServiceRequest_PUB',

Line 1256: p_encoded => FND_API.G_FALSE );

1252:
1253: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1254: FND_MSG_PUB.Count_And_Get( p_count => l_msg_count,
1255: p_data => l_msg_data,
1256: p_encoded => FND_API.G_FALSE );
1257: wf_core.context( pkg_name => 'CS_ServiceRequest_PUB',
1258: proc_name => 'Update_Status',
1259: arg1 => 'p_user_id=>'||l_user_id,
1260: arg2 => 'p_org_id=>'||l_org_id,

Line 1296: p_init_msg_list => fnd_api.g_false,

1292:
1293:
1294: CS_ServiceRequest_PVT.Update_ServiceRequest
1295: ( p_api_version => 3.0, -- Changed from 2.0 for 11.5.9.
1296: p_init_msg_list => fnd_api.g_false,
1297: p_commit => fnd_api.g_true,
1298: p_validation_level => fnd_api.g_valid_level_full,
1299: x_return_status => l_return_status,
1300: x_msg_count => l_msg_count,

Line 1297: p_commit => fnd_api.g_true,

1293:
1294: CS_ServiceRequest_PVT.Update_ServiceRequest
1295: ( p_api_version => 3.0, -- Changed from 2.0 for 11.5.9.
1296: p_init_msg_list => fnd_api.g_false,
1297: p_commit => fnd_api.g_true,
1298: p_validation_level => fnd_api.g_valid_level_full,
1299: x_return_status => l_return_status,
1300: x_msg_count => l_msg_count,
1301: x_msg_data => l_msg_data,

Line 1298: p_validation_level => fnd_api.g_valid_level_full,

1294: CS_ServiceRequest_PVT.Update_ServiceRequest
1295: ( p_api_version => 3.0, -- Changed from 2.0 for 11.5.9.
1296: p_init_msg_list => fnd_api.g_false,
1297: p_commit => fnd_api.g_true,
1298: p_validation_level => fnd_api.g_valid_level_full,
1299: x_return_status => l_return_status,
1300: x_msg_count => l_msg_count,
1301: x_msg_data => l_msg_data,
1302: p_request_id => l_request_id,

Line 1318: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

1314:
1315:
1316:
1317: -- Check for possible errors returned by the API
1318: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1319: FND_MSG_PUB.Count_And_Get( p_count => l_msg_count,
1320: p_data => l_msg_data,
1321: p_encoded => FND_API.G_FALSE );
1322: wf_core.context( pkg_name => 'CS_ServiceRequest_PUB',

Line 1321: p_encoded => FND_API.G_FALSE );

1317: -- Check for possible errors returned by the API
1318: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1319: FND_MSG_PUB.Count_And_Get( p_count => l_msg_count,
1320: p_data => l_msg_data,
1321: p_encoded => FND_API.G_FALSE );
1322: wf_core.context( pkg_name => 'CS_ServiceRequest_PUB',
1323: proc_name => 'Update_Status',
1324: arg1 => 'p_user_id=>'||l_user_id,
1325: arg2 => 'p_org_id=>'||l_org_id,

Line 1335: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN

1331: END IF;
1332: /*
1333: This is the standard error handling but am retaining the older method
1334: as in earlier version
1335: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1336: raise FND_API.G_EXC_ERROR;
1337: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1338: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1339: END IF;

Line 1336: raise FND_API.G_EXC_ERROR;

1332: /*
1333: This is the standard error handling but am retaining the older method
1334: as in earlier version
1335: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1336: raise FND_API.G_EXC_ERROR;
1337: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1338: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1339: END IF;
1340: */

Line 1337: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

1333: This is the standard error handling but am retaining the older method
1334: as in earlier version
1335: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1336: raise FND_API.G_EXC_ERROR;
1337: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1338: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1339: END IF;
1340: */
1341:

Line 1338: raise FND_API.G_EXC_UNEXPECTED_ERROR;

1334: as in earlier version
1335: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1336: raise FND_API.G_EXC_ERROR;
1337: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1338: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1339: END IF;
1340: */
1341:
1342:

Line 1365: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

1361: END IF;
1362:
1363: --dbms_output.put_line(' after error mesg ' || l_return_status );
1364:
1365: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1366: FND_MSG_PUB.Count_And_Get( p_count => l_msg_count,
1367: p_data => l_msg_data,
1368: p_encoded => FND_API.G_FALSE );
1369: wf_core.context( pkg_name => 'CS_ServiceRequest_PVT',

Line 1368: p_encoded => FND_API.G_FALSE );

1364:
1365: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1366: FND_MSG_PUB.Count_And_Get( p_count => l_msg_count,
1367: p_data => l_msg_data,
1368: p_encoded => FND_API.G_FALSE );
1369: wf_core.context( pkg_name => 'CS_ServiceRequest_PVT',
1370: proc_name => 'Update_ServiceRequest',
1371: arg1 => 'p_user_id=>'||l_user_id,
1372: arg2 => 'p_org_id=>'||l_org_id,

Line 1401: WHEN FND_API.G_EXC_ERROR THEN

1397: END IF;
1398:
1399: EXCEPTION
1400: /* for new error handling
1401: WHEN FND_API.G_EXC_ERROR THEN
1402: l_return_status := FND_API.G_RET_STS_ERROR;
1403: FND_MSG_PUB.Count_And_Get( p_count => l_msg_count,
1404: p_data => l_msg_data,
1405: p_encoded => FND_API.G_FALSE );

Line 1402: l_return_status := FND_API.G_RET_STS_ERROR;

1398:
1399: EXCEPTION
1400: /* for new error handling
1401: WHEN FND_API.G_EXC_ERROR THEN
1402: l_return_status := FND_API.G_RET_STS_ERROR;
1403: FND_MSG_PUB.Count_And_Get( p_count => l_msg_count,
1404: p_data => l_msg_data,
1405: p_encoded => FND_API.G_FALSE );
1406: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1405: p_encoded => FND_API.G_FALSE );

1401: WHEN FND_API.G_EXC_ERROR THEN
1402: l_return_status := FND_API.G_RET_STS_ERROR;
1403: FND_MSG_PUB.Count_And_Get( p_count => l_msg_count,
1404: p_data => l_msg_data,
1405: p_encoded => FND_API.G_FALSE );
1406: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1407: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1408: FND_MSG_PUB.Count_And_Get( p_count => l_msg_count,
1409: p_data => l_msg_data,

Line 1406: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1402: l_return_status := FND_API.G_RET_STS_ERROR;
1403: FND_MSG_PUB.Count_And_Get( p_count => l_msg_count,
1404: p_data => l_msg_data,
1405: p_encoded => FND_API.G_FALSE );
1406: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1407: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1408: FND_MSG_PUB.Count_And_Get( p_count => l_msg_count,
1409: p_data => l_msg_data,
1410: p_encoded => FND_API.G_FALSE );

Line 1407: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1403: FND_MSG_PUB.Count_And_Get( p_count => l_msg_count,
1404: p_data => l_msg_data,
1405: p_encoded => FND_API.G_FALSE );
1406: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1407: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1408: FND_MSG_PUB.Count_And_Get( p_count => l_msg_count,
1409: p_data => l_msg_data,
1410: p_encoded => FND_API.G_FALSE );
1411: */

Line 1410: p_encoded => FND_API.G_FALSE );

1406: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1407: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1408: FND_MSG_PUB.Count_And_Get( p_count => l_msg_count,
1409: p_data => l_msg_data,
1410: p_encoded => FND_API.G_FALSE );
1411: */
1412: WHEN l_API_ERROR THEN
1413: WF_CORE.Raise(l_errmsg_name);
1414: WHEN OTHERS THEN

Line 1725: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

1721: p_request_id => l_request_id,
1722: p_action_number => l_action_number,
1723: p_wf_process_id => l_dummy
1724: );
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',

Line 1728: p_encoded => FND_API.G_FALSE );

1724: );
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 );

Line 1764: IF ((l_return_status <> FND_API.G_RET_STS_SUCCESS) OR

1760: p_employee_id => l_action_rec.action_assignee_id,
1761: p_role_name => l_assignee_role,
1762: p_role_display_name => l_assignee_name
1763: );
1764: IF ((l_return_status <> FND_API.G_RET_STS_SUCCESS) OR
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 );

Line 1768: p_encoded => FND_API.G_FALSE );

1764: IF ((l_return_status <> FND_API.G_RET_STS_SUCCESS) OR
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 );

Line 1942: IF FND_API.To_Boolean(l_launched_by_dispatch) THEN

1938: ( itemtype => itemtype,
1939: itemkey => itemkey,
1940: aname => 'LAUNCHED_BY_DISPATCH'
1941: );
1942: IF FND_API.To_Boolean(l_launched_by_dispatch) THEN
1943: result := 'COMPLETE:Y';
1944: ELSE
1945: result := 'COMPLETE:N';
1946: END IF;

Line 2575: x_return_status := FND_API.G_RET_STS_SUCCESS;

2571: x_msg_count NUMBER;
2572:
2573: BEGIN
2574: -- Initialize the return status to Success
2575: x_return_status := FND_API.G_RET_STS_SUCCESS;
2576:
2577: SELECT inc.incident_id,
2578: act.workflow_process_id,
2579: CS_WORKFLOW_PKG.IS_ACTION_ITEM_ACTIVE(

Line 2605: x_return_status := FND_API.G_RET_STS_ERROR;

2601: END IF ;
2602:
2603: EXCEPTION
2604: WHEN WF_NOT_ACTIVE THEN
2605: x_return_status := FND_API.G_RET_STS_ERROR;
2606: FND_MESSAGE.Set_Name('CS', 'CS_SR_WORKFLOW_NOT_ACTIVE');
2607: FND_MSG_PUB.Add;
2608: FND_MSG_PUB.Count_And_Get(
2609: p_count => x_msg_count,

Line 2611: p_encoded => FND_API.G_FALSE );

2607: FND_MSG_PUB.Add;
2608: FND_MSG_PUB.Count_And_Get(
2609: p_count => x_msg_count,
2610: p_data => x_msg_data,
2611: p_encoded => FND_API.G_FALSE );
2612: WHEN OTHERS THEN
2613: x_return_status := FND_API.G_RET_STS_ERROR;
2614: FND_MESSAGE.Set_Name('CS', sqlerrm);
2615: FND_MSG_PUB.Add;

Line 2613: x_return_status := FND_API.G_RET_STS_ERROR;

2609: p_count => x_msg_count,
2610: p_data => x_msg_data,
2611: p_encoded => FND_API.G_FALSE );
2612: WHEN OTHERS THEN
2613: x_return_status := FND_API.G_RET_STS_ERROR;
2614: FND_MESSAGE.Set_Name('CS', sqlerrm);
2615: FND_MSG_PUB.Add;
2616: FND_MSG_PUB.Count_And_Get(
2617: p_count => x_msg_count,

Line 2619: p_encoded => FND_API.G_FALSE );

2615: FND_MSG_PUB.Add;
2616: FND_MSG_PUB.Count_And_Get(
2617: p_count => x_msg_count,
2618: p_data => x_msg_data,
2619: p_encoded => FND_API.G_FALSE );
2620:
2621: END SET_FS_WF_RESPONSE; */
2622:
2623: -- ---------------------------