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',
961: proc_name => 'Update_Owner',
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',
1258: proc_name => 'Update_Status',
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',
1323: proc_name => 'Update_Status',
1341:
1342:
1343: /* for testng - error handling when running SQL script you need this
1344: to see if Update_SR API is successful
1345: IF (FND_MSG_PUB.Count_Msg > 1) THEN
1346: --Display all the error messages
1347: FOR j in 1..FND_MSG_PUB.Count_Msg LOOP
1348: FND_MSG_PUB.Get(p_msg_index=>j,
1349: p_encoded=>'F',
1343: /* for testng - error handling when running SQL script you need this
1344: to see if Update_SR API is successful
1345: IF (FND_MSG_PUB.Count_Msg > 1) THEN
1346: --Display all the error messages
1347: FOR j in 1..FND_MSG_PUB.Count_Msg LOOP
1348: FND_MSG_PUB.Get(p_msg_index=>j,
1349: p_encoded=>'F',
1350: p_data=>l_msg_data,
1351: p_msg_index_out=>l_msg_index_out);
1344: to see if Update_SR API is successful
1345: IF (FND_MSG_PUB.Count_Msg > 1) THEN
1346: --Display all the error messages
1347: FOR j in 1..FND_MSG_PUB.Count_Msg LOOP
1348: FND_MSG_PUB.Get(p_msg_index=>j,
1349: p_encoded=>'F',
1350: p_data=>l_msg_data,
1351: p_msg_index_out=>l_msg_index_out);
1352: DBMS_OUTPUT.PUT_LINE(l_msg_data);
1352: DBMS_OUTPUT.PUT_LINE(l_msg_data);
1353: END LOOP;
1354: ELSE
1355: --Only one error
1356: FND_MSG_PUB.Get(p_msg_index=>1,
1357: p_encoded=>'F',
1358: p_data=>l_msg_data,
1359: p_msg_index_out=>l_msg_index_out);
1360: DBMS_OUTPUT.PUT_LINE(l_msg_data);
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',
1370: proc_name => 'Update_ServiceRequest',
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
1407: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
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: */
1412: WHEN l_API_ERROR THEN
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',
1730: proc_name => 'Decode_Action_Itemkey',
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 );
1769: WF_CORE.Context( pkg_name => 'CS_Workflow_PUB',
1770: proc_name => 'Get_Employee_Role',
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,
2610: p_data => x_msg_data,
2611: p_encoded => FND_API.G_FALSE );
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,
2610: p_data => x_msg_data,
2611: p_encoded => FND_API.G_FALSE );
2612: WHEN OTHERS THEN
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,
2618: p_data => x_msg_data,
2619: 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,
2618: p_data => x_msg_data,
2619: p_encoded => FND_API.G_FALSE );
2620: