DBA Data[Home] [Help]

APPS.CS_WF_AUTO_NTFY_UPDATE_PKG dependencies on FND_API

Line 4207: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

4203: x_resource_type => x_resource_type,
4204: x_msg_count => x_msg_count,
4205: x_msg_data => x_msg_data);
4206:
4207: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
4208:
4209: result := 'COMPLETE:NOTCREATED';
4210:
4211: IF ( FND_MSG_PUB.Count_Msg > 0) THEN

Line 5415: -- 1. FND_API.G_RET_STS_SUCCESS - we set the renult to 'UPDATED'.

5411: -- This procedure makes the call to Update_Sericerequest() api to update
5412: -- the status or resolution code of the SR, as defined in the update
5413: -- rule.
5414: -- Depending on the result of the update api call, we set the transition :
5415: -- 1. FND_API.G_RET_STS_SUCCESS - we set the renult to 'UPDATED'.
5416: -- We then move on and process the next related service request.
5417: -- 2. 'L'- we set the result to 'LOCKED'. If the record is locked, We
5418: -- then wait for 10 secs and re-try updating the record. We attempt
5419: -- the update 5 times, each time waiting 10 secs. if the record is

Line 5575: p_init_msg_list => fnd_api.g_false,

5571: aname => 'RESP_ID' );
5572:
5573: CS_ServiceRequest_PVT.Update_ServiceRequest
5574: ( p_api_version => 3.0,
5575: p_init_msg_list => fnd_api.g_false,
5576: p_commit => fnd_api.g_true,
5577: p_validation_level => fnd_api.g_valid_level_full,
5578: x_return_status => l_return_status,
5579: x_msg_count => l_msg_count,

Line 5576: p_commit => fnd_api.g_true,

5572:
5573: CS_ServiceRequest_PVT.Update_ServiceRequest
5574: ( p_api_version => 3.0,
5575: p_init_msg_list => fnd_api.g_false,
5576: p_commit => fnd_api.g_true,
5577: p_validation_level => fnd_api.g_valid_level_full,
5578: x_return_status => l_return_status,
5579: x_msg_count => l_msg_count,
5580: x_msg_data => l_msg_data,

Line 5577: p_validation_level => fnd_api.g_valid_level_full,

5573: CS_ServiceRequest_PVT.Update_ServiceRequest
5574: ( p_api_version => 3.0,
5575: p_init_msg_list => fnd_api.g_false,
5576: p_commit => fnd_api.g_true,
5577: p_validation_level => fnd_api.g_valid_level_full,
5578: x_return_status => l_return_status,
5579: x_msg_count => l_msg_count,
5580: x_msg_data => l_msg_data,
5581: p_request_id => l_request_id,

Line 5597: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN

5593: x_workflow_process_id => out_wf_process_id
5594: );
5595:
5596: -- Check for possible errors returned by the API
5597: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
5598: result := 'COMPLETE:UPDATED';
5599: -- We need to have a separate return status for locked row exception.
5600: ELSIF (l_return_status = 'L') THEN
5601: --ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

Line 5601: --ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

5597: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
5598: result := 'COMPLETE:UPDATED';
5599: -- We need to have a separate return status for locked row exception.
5600: ELSIF (l_return_status = 'L') THEN
5601: --ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
5602: result := 'COMPLETE:LOCKED';
5603: ELSE
5604: -- Obtain the owner role of the related SR being updated, and set-up the
5605: -- the notification to be sent to the owner of the SR.

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

5607: END IF;
5608:
5609:
5610: -- IF (l_msg_data is not null) THEN
5611: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
5612:
5613:
5614: IF ( FND_MSG_PUB.Count_Msg > 0) THEN
5615: FOR i IN 1..FND_MSG_PUB.Count_Msg LOOP

Line 5637: p_encoded => FND_API.G_FALSE );

5633:
5634: /*****************************************
5635: FND_MSG_PUB.Count_And_Get( p_count => l_msg_count,
5636: p_data => l_msg_data,
5637: p_encoded => FND_API.G_FALSE );
5638: wf_core.context( pkg_name => 'CS_ServiceRequest_PUB',
5639: proc_name => 'Update_Status',
5640: arg1 => 'p_user_id=>'||l_user_id,
5641: arg2 => 'p_org_id=>'||l_org_id,

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

6331: p_employee_id => l_get_source_id_rec.source_id,
6332: p_role_name => l_owner_role,
6333: p_role_display_name => l_owner_name );
6334:
6335: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) OR
6336: (l_owner_role is NULL) THEN
6337: CLOSE l_get_source_id;
6338: wf_core.context( pkg_name => 'CS_WORKFLOW_PUB',
6339: proc_name => 'Get_Employee_Role',

Line 6790: x_return_status := FND_API.G_RET_STS_SUCCESS;

6786: d_login_id NUMBER;
6787:
6788: BEGIN
6789:
6790: x_return_status := FND_API.G_RET_STS_SUCCESS;
6791:
6792: l_int_wrapup_id := FND_PROFILE.Value('CSC_CC_WRAPUP_INTERACTION_DEFAULTS');
6793:
6794: l_action_item := 'Sr';

Line 6914: IF (l_new_interaction_id IS NULL OR x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

6910:
6911: END IF; -- IF ( l_int_wrapup_id is not null )
6912:
6913:
6914: IF (l_new_interaction_id IS NULL OR x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
6915: RAISE FND_API.G_EXC_ERROR;
6916:
6917: ELSE
6918:

Line 6915: RAISE FND_API.G_EXC_ERROR;

6911: END IF; -- IF ( l_int_wrapup_id is not null )
6912:
6913:
6914: IF (l_new_interaction_id IS NULL OR x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
6915: RAISE FND_API.G_EXC_ERROR;
6916:
6917: ELSE
6918:
6919:

Line 6984: IF (l_activity_id IS NULL OR x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

6980: l_activity_rec,
6981: l_activity_id);
6982:
6983:
6984: IF (l_activity_id IS NULL OR x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
6985:
6986: raise FND_API.G_EXC_ERROR;
6987: /**********
6988: l_failed = 1;

Line 6986: raise FND_API.G_EXC_ERROR;

6982:
6983:
6984: IF (l_activity_id IS NULL OR x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
6985:
6986: raise FND_API.G_EXC_ERROR;
6987: /**********
6988: l_failed = 1;
6989:
6990: IF ( FND_MSG_PUB.Count_Msg > 0) THEN

Line 7047: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

7043: x_msg_count,
7044: x_msg_data,
7045: l_interaction_rec);
7046:
7047: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
7048: raise FND_API.G_EXC_ERROR;
7049: END IF;
7050:
7051: END IF; -- (l_new_interaction_id IS NOT NULL)

Line 7048: raise FND_API.G_EXC_ERROR;

7044: x_msg_data,
7045: l_interaction_rec);
7046:
7047: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
7048: raise FND_API.G_EXC_ERROR;
7049: END IF;
7050:
7051: END IF; -- (l_new_interaction_id IS NOT NULL)
7052:

Line 7061: x_return_status := FND_API.G_RET_STS_ERROR;

7057:
7058: EXCEPTION
7059:
7060: WHEN l_NO_RESOURCE_FOUND THEN
7061: x_return_status := FND_API.G_RET_STS_ERROR;
7062: FND_MSG_PUB.initialize;
7063: FND_MESSAGE.Set_Name('CS', 'CS_SR_WF_NO_INT_RESOURCE');
7064: FND_MESSAGE.Set_Token('API_NAME', 'CS_WF_AUTO_NTFY_UPDATE_PKG.Create_Interaction_Activity');
7065: FND_MSG_PUB.ADD;

Line 7071: WHEN FND_API.G_EXC_ERROR THEN

7067: ( p_count => x_msg_count,
7068: p_data => x_msg_data
7069: );
7070:
7071: WHEN FND_API.G_EXC_ERROR THEN
7072: x_return_status := FND_API.G_RET_STS_ERROR;
7073: FND_MSG_PUB.Count_And_Get
7074: ( p_count => x_msg_count,
7075: p_data => x_msg_data

Line 7072: x_return_status := FND_API.G_RET_STS_ERROR;

7068: p_data => x_msg_data
7069: );
7070:
7071: WHEN FND_API.G_EXC_ERROR THEN
7072: x_return_status := FND_API.G_RET_STS_ERROR;
7073: FND_MSG_PUB.Count_And_Get
7074: ( p_count => x_msg_count,
7075: p_data => x_msg_data
7076: );

Line 7079: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

7075: p_data => x_msg_data
7076: );
7077:
7078: WHEN OTHERS THEN
7079: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7080: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
7081: FND_MSG_PUB.Add_Exc_Msg('CS_WF_AUTO_NTFY_UPDATE_PKG', 'Create_Interaction_Activity');
7082: END IF;
7083: FND_MSG_PUB.Count_And_Get

Line 7980: --x_return_status := FND_API.G_RET_STS_SUCCESS;

7976:
7977: sel_party_role_rec sel_party_role_csr%ROWTYPE;
7978:
7979: BEGIN
7980: --x_return_status := FND_API.G_RET_STS_SUCCESS;
7981:
7982: IF (p_action_code = 'NOTIFY_ASSOCIATED_PARTIES') THEN
7983: IF (p_role_group_type = 'ROLEGROUP') THEN
7984: l_party_role_group_code := p_role_group_code;