APPS.OCM_RECOMMENDATIONS_PUB dependencies on FND_API

Line 52: x_return_status := FND_API.G_RET_STS_SUCCESS;

48: debug ( 'Credit Request Id : ' || p_credit_request_id );
49: debug ( 'Case Folder Id : ' || p_case_folder_id );
50: debug ( 'Appeal Flag : ' || p_appealed_flag );
51: END IF;
52: x_return_status := FND_API.G_RET_STS_SUCCESS;
53: IF p_credit_request_id IS NULL AND p_case_folder_id IS NULL
54: THEN
55: IF pg_debug = 'Y'
56: THEN

Line 59: x_return_status := FND_API.G_RET_STS_ERROR;

55: IF pg_debug = 'Y'
56: THEN
57: debug ( 'Both Credit Request and case folder Id is null');
58: END IF;
59: x_return_status := FND_API.G_RET_STS_ERROR;
60: x_msg_data := 'Both Credit Request Id and case Folder Id cannot be null';
61: x_msg_count := 1;
62: return;
63: END IF;

Line 83: x_return_status := FND_API.G_RET_STS_ERROR;

79:
80: l_reco_ctr := p_recommendations_tbl.first;
81: IF l_reco_ctr IS NULL
82: THEN
83: x_return_status := FND_API.G_RET_STS_ERROR;
84: x_msg_data := 'No recommendations Exists';
85: x_msg_count := 1;
86: return;
87: END IF;

Line 117: x_return_status := FND_API.G_RET_STS_SUCCESS;

113: debug ( 'ARCM_RECOMMENDATIONS_PUB.mark_appeal(+)');
114: debug ( 'Credit Request Id : ' || p_credit_request_id );
115: debug ( 'Case Folder Id : ' || p_case_folder_id );
116: END IF;
117: x_return_status := FND_API.G_RET_STS_SUCCESS;
118:
119: IF p_credit_request_id IS NULL and p_case_folder_id IS NULL
120: THEN
121: x_return_status := FND_API.G_RET_STS_ERROR;

Line 121: x_return_status := FND_API.G_RET_STS_ERROR;

117: x_return_status := FND_API.G_RET_STS_SUCCESS;
118:
119: IF p_credit_request_id IS NULL and p_case_folder_id IS NULL
120: THEN
121: x_return_status := FND_API.G_RET_STS_ERROR;
122: x_msg_data := 'Both Credit Request Id and case Folder Id cannot be null';
123: x_msg_count := 1;
124: return;
125: END IF;

Line 139: x_return_status := FND_API.G_RET_STS_ERROR;

135: AND status = 'CLOSED';
136:
137: EXCEPTION
138: WHEN NO_DATA_FOUND THEN
139: x_return_status := FND_API.G_RET_STS_ERROR;
140: x_msg_data := 'Either Case Folder Does not Exists or Not Closed.';
141: x_msg_count := 1;
142: return;
143: WHEN OTHERS THEN

Line 144: x_return_status := FND_API.G_RET_STS_ERROR;

140: x_msg_data := 'Either Case Folder Does not Exists or Not Closed.';
141: x_msg_count := 1;
142: return;
143: WHEN OTHERS THEN
144: x_return_status := FND_API.G_RET_STS_ERROR;
145: x_msg_data := 'Error while fetching case folder '||sqlerrm;
146: x_msg_count := 1;
147: return;
148:

Line 159: x_return_status := FND_API.G_RET_STS_ERROR;

155: WHERE case_folder_id = l_case_folder_id;
156:
157: EXCEPTION
158: WHEN OTHERS THEN
159: x_return_status := FND_API.G_RET_STS_ERROR;
160: x_msg_data := 'Error while updating Recommendation' ||sqlerrm;
161: x_msg_count := 1;
162: return;
163: END;