DBA Data[Home] [Help]

APPS.CS_WF_AUTO_NTFY_UPDATE_PKG dependencies on FND_API

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

4265: x_resource_type => x_resource_type,
4266: x_msg_count => x_msg_count,
4267: x_msg_data => x_msg_data);
4268:
4269: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
4270:
4271: result := 'COMPLETE:NOTCREATED';
4272:
4273: IF ( FND_MSG_PUB.Count_Msg > 0) THEN

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

5475: -- This procedure makes the call to Update_Sericerequest() api to update
5476: -- the status or resolution code of the SR, as defined in the update
5477: -- rule.
5478: -- Depending on the result of the update api call, we set the transition :
5479: -- 1. FND_API.G_RET_STS_SUCCESS - we set the renult to 'UPDATED'.
5480: -- We then move on and process the next related service request.
5481: -- 2. 'L'- we set the result to 'LOCKED'. If the record is locked, We
5482: -- then wait for 10 secs and re-try updating the record. We attempt
5483: -- the update 5 times, each time waiting 10 secs. if the record is

Line 5639: p_init_msg_list => fnd_api.g_false,

5635: aname => 'RESP_ID' );
5636:
5637: CS_ServiceRequest_PVT.Update_ServiceRequest
5638: ( p_api_version => 3.0,
5639: p_init_msg_list => fnd_api.g_false,
5640: p_commit => fnd_api.g_true,
5641: p_validation_level => fnd_api.g_valid_level_full,
5642: x_return_status => l_return_status,
5643: x_msg_count => l_msg_count,

Line 5640: p_commit => fnd_api.g_true,

5636:
5637: CS_ServiceRequest_PVT.Update_ServiceRequest
5638: ( p_api_version => 3.0,
5639: p_init_msg_list => fnd_api.g_false,
5640: p_commit => fnd_api.g_true,
5641: p_validation_level => fnd_api.g_valid_level_full,
5642: x_return_status => l_return_status,
5643: x_msg_count => l_msg_count,
5644: x_msg_data => l_msg_data,

Line 5641: p_validation_level => fnd_api.g_valid_level_full,

5637: CS_ServiceRequest_PVT.Update_ServiceRequest
5638: ( p_api_version => 3.0,
5639: p_init_msg_list => fnd_api.g_false,
5640: p_commit => fnd_api.g_true,
5641: p_validation_level => fnd_api.g_valid_level_full,
5642: x_return_status => l_return_status,
5643: x_msg_count => l_msg_count,
5644: x_msg_data => l_msg_data,
5645: p_request_id => l_request_id,

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

5657: x_workflow_process_id => out_wf_process_id
5658: );
5659:
5660: -- Check for possible errors returned by the API
5661: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
5662: result := 'COMPLETE:UPDATED';
5663: -- We need to have a separate return status for locked row exception.
5664: ELSIF (l_return_status = 'L') THEN
5665: --ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

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

5661: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
5662: result := 'COMPLETE:UPDATED';
5663: -- We need to have a separate return status for locked row exception.
5664: ELSIF (l_return_status = 'L') THEN
5665: --ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
5666: result := 'COMPLETE:LOCKED';
5667: ELSE
5668: -- Obtain the owner role of the related SR being updated, and set-up the
5669: -- the notification to be sent to the owner of the SR.

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

5671: END IF;
5672:
5673:
5674: -- IF (l_msg_data is not null) THEN
5675: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
5676:
5677:
5678: IF ( FND_MSG_PUB.Count_Msg > 0) THEN
5679: FOR i IN 1..FND_MSG_PUB.Count_Msg LOOP

Line 5701: p_encoded => FND_API.G_FALSE );

5697:
5698: /*****************************************
5699: FND_MSG_PUB.Count_And_Get( p_count => l_msg_count,
5700: p_data => l_msg_data,
5701: p_encoded => FND_API.G_FALSE );
5702: wf_core.context( pkg_name => 'CS_ServiceRequest_PUB',
5703: proc_name => 'Update_Status',
5704: arg1 => 'p_user_id=>'||l_user_id,
5705: arg2 => 'p_org_id=>'||l_org_id,

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

6395: p_employee_id => l_get_source_id_rec.source_id,
6396: p_role_name => l_owner_role,
6397: p_role_display_name => l_owner_name );
6398:
6399: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) OR
6400: (l_owner_role is NULL) THEN
6401: CLOSE l_get_source_id;
6402: wf_core.context( pkg_name => 'CS_WORKFLOW_PUB',
6403: proc_name => 'Get_Employee_Role',

Line 6854: x_return_status := FND_API.G_RET_STS_SUCCESS;

6850: d_login_id NUMBER;
6851:
6852: BEGIN
6853:
6854: x_return_status := FND_API.G_RET_STS_SUCCESS;
6855:
6856: l_int_wrapup_id := FND_PROFILE.Value('CSC_CC_WRAPUP_INTERACTION_DEFAULTS');
6857:
6858: l_action_item := 'Sr';

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

6974:
6975: END IF; -- IF ( l_int_wrapup_id is not null )
6976:
6977:
6978: IF (l_new_interaction_id IS NULL OR x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
6979: RAISE FND_API.G_EXC_ERROR;
6980:
6981: ELSE
6982:

Line 6979: RAISE FND_API.G_EXC_ERROR;

6975: END IF; -- IF ( l_int_wrapup_id is not null )
6976:
6977:
6978: IF (l_new_interaction_id IS NULL OR x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
6979: RAISE FND_API.G_EXC_ERROR;
6980:
6981: ELSE
6982:
6983:

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

7044: l_activity_rec,
7045: l_activity_id);
7046:
7047:
7048: IF (l_activity_id IS NULL OR x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
7049:
7050: raise FND_API.G_EXC_ERROR;
7051: /**********
7052: l_failed = 1;

Line 7050: raise FND_API.G_EXC_ERROR;

7046:
7047:
7048: IF (l_activity_id IS NULL OR x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
7049:
7050: raise FND_API.G_EXC_ERROR;
7051: /**********
7052: l_failed = 1;
7053:
7054: IF ( FND_MSG_PUB.Count_Msg > 0) THEN

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

7107: x_msg_count,
7108: x_msg_data,
7109: l_interaction_rec);
7110:
7111: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
7112: raise FND_API.G_EXC_ERROR;
7113: END IF;
7114:
7115: END IF; -- (l_new_interaction_id IS NOT NULL)

Line 7112: raise FND_API.G_EXC_ERROR;

7108: x_msg_data,
7109: l_interaction_rec);
7110:
7111: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
7112: raise FND_API.G_EXC_ERROR;
7113: END IF;
7114:
7115: END IF; -- (l_new_interaction_id IS NOT NULL)
7116:

Line 7125: x_return_status := FND_API.G_RET_STS_ERROR;

7121:
7122: EXCEPTION
7123:
7124: WHEN l_NO_RESOURCE_FOUND THEN
7125: x_return_status := FND_API.G_RET_STS_ERROR;
7126: FND_MSG_PUB.initialize;
7127: FND_MESSAGE.Set_Name('CS', 'CS_SR_WF_NO_INT_RESOURCE');
7128: FND_MESSAGE.Set_Token('API_NAME', 'CS_WF_AUTO_NTFY_UPDATE_PKG.Create_Interaction_Activity');
7129: FND_MSG_PUB.ADD;

Line 7135: WHEN FND_API.G_EXC_ERROR THEN

7131: ( p_count => x_msg_count,
7132: p_data => x_msg_data
7133: );
7134:
7135: WHEN FND_API.G_EXC_ERROR THEN
7136: x_return_status := FND_API.G_RET_STS_ERROR;
7137: FND_MSG_PUB.Count_And_Get
7138: ( p_count => x_msg_count,
7139: p_data => x_msg_data

Line 7136: x_return_status := FND_API.G_RET_STS_ERROR;

7132: p_data => x_msg_data
7133: );
7134:
7135: WHEN FND_API.G_EXC_ERROR THEN
7136: x_return_status := FND_API.G_RET_STS_ERROR;
7137: FND_MSG_PUB.Count_And_Get
7138: ( p_count => x_msg_count,
7139: p_data => x_msg_data
7140: );

Line 7143: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

7139: p_data => x_msg_data
7140: );
7141:
7142: WHEN OTHERS THEN
7143: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7144: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
7145: FND_MSG_PUB.Add_Exc_Msg('CS_WF_AUTO_NTFY_UPDATE_PKG', 'Create_Interaction_Activity');
7146: END IF;
7147: FND_MSG_PUB.Count_And_Get

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

8040:
8041: sel_party_role_rec sel_party_role_csr%ROWTYPE;
8042:
8043: BEGIN
8044: --x_return_status := FND_API.G_RET_STS_SUCCESS;
8045:
8046: IF (p_action_code = 'NOTIFY_ASSOCIATED_PARTIES') THEN
8047: IF (p_role_group_type = 'ROLEGROUP') THEN
8048: l_party_role_group_code := p_role_group_code;