APPS.PA_RBS_ASGMT_PKG dependencies on FND_API

Line 66: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

62: FND_GLOBAL.LOGIN_ID,
63: 1);
64: EXCEPTION
65: WHEN OTHERS THEN
66: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
67: RETURN;
68: END Insert_Row;
69: /***************************/
70: /**************************************************************

Line 88: x_return_status := FND_API.G_RET_STS_SUCCESS;

84: x_return_status OUT NOCOPY VARCHAR2 )
85: IS
86:
87: BEGIN
88: x_return_status := FND_API.G_RET_STS_SUCCESS;
89: UPDATE pa_rbs_prj_assignments
90: SET reporting_usage_flag = 'Y',
91: wp_usage_flag = p_wp_usage_flag,
92: fp_usage_flag = p_fp_usage_flag,

Line 104: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

100: AND assignment_status = 'ACTIVE'
101: AND NVL(record_version_number, 0) =
102: NVL(p_record_version_number, 0);
103: IF SQL%NOTFOUND THEN
104: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
105: RETURN;
106: END IF;
107: EXCEPTION
108: WHEN OTHERS THEN

Line 109: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

105: RETURN;
106: END IF;
107: EXCEPTION
108: WHEN OTHERS THEN
109: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
110: RETURN;
111: END Update_Row;
112:
113: /**************************************************************

Line 133: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

129: DELETE FROM pa_rbs_prj_assignments
130: WHERE RBS_PRJ_ASSIGNMENT_ID = p_rbs_prj_assignment_id;
131:
132: IF SQL%NOTFOUND THEN
133: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
134: RETURN;
135: END IF;
136: EXCEPTION
137: WHEN OTHERS THEN

Line 138: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

134: RETURN;
135: END IF;
136: EXCEPTION
137: WHEN OTHERS THEN
138: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
139: RETURN;
140: END Delete_Row;
141:
142: