DBA Data[Home] [Help]

APPS.OZF_ASSIGNMENT_QUALIFIER_PUB dependencies on FND_API

Line 36: x_return_status := FND_API.G_RET_STS_SUCCESS;

32: IS
33: BEGIN
34:
35: -- Initialize API return status to sucess
36: x_return_status := FND_API.G_RET_STS_SUCCESS;
37:
38: x_claim_type_id := p_rec.claim_type_id;
39: EXCEPTION
40: WHEN FND_API.G_EXC_ERROR THEN

Line 40: WHEN FND_API.G_EXC_ERROR THEN

36: x_return_status := FND_API.G_RET_STS_SUCCESS;
37:
38: x_claim_type_id := p_rec.claim_type_id;
39: EXCEPTION
40: WHEN FND_API.G_EXC_ERROR THEN
41: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
42: WHEN OTHERS THEN
43: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
44: END get_claim_type;

Line 41: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

37:
38: x_claim_type_id := p_rec.claim_type_id;
39: EXCEPTION
40: WHEN FND_API.G_EXC_ERROR THEN
41: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
42: WHEN OTHERS THEN
43: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
44: END get_claim_type;
45:

Line 43: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

39: EXCEPTION
40: WHEN FND_API.G_EXC_ERROR THEN
41: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
42: WHEN OTHERS THEN
43: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
44: END get_claim_type;
45:
46: ---------------------------------------------------------------------
47: -- PROCEDURE

Line 67: x_return_status := FND_API.G_RET_STS_SUCCESS;

63: IS
64: BEGIN
65:
66: -- Initialize API return status to sucess
67: x_return_status := FND_API.G_RET_STS_SUCCESS;
68:
69: x_reason_code_id := p_rec.reason_code_id;
70: EXCEPTION
71: WHEN FND_API.G_EXC_ERROR THEN

Line 71: WHEN FND_API.G_EXC_ERROR THEN

67: x_return_status := FND_API.G_RET_STS_SUCCESS;
68:
69: x_reason_code_id := p_rec.reason_code_id;
70: EXCEPTION
71: WHEN FND_API.G_EXC_ERROR THEN
72: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
73: WHEN OTHERS THEN
74: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
75: END get_reason;

Line 72: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

68:
69: x_reason_code_id := p_rec.reason_code_id;
70: EXCEPTION
71: WHEN FND_API.G_EXC_ERROR THEN
72: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
73: WHEN OTHERS THEN
74: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
75: END get_reason;
76:

Line 74: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

70: EXCEPTION
71: WHEN FND_API.G_EXC_ERROR THEN
72: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
73: WHEN OTHERS THEN
74: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
75: END get_reason;
76:
77:
78: ---------------------------------------------------------------------

Line 99: x_return_status := FND_API.G_RET_STS_SUCCESS;

95: IS
96: BEGIN
97:
98: -- Initialize API return status to sucess
99: x_return_status := FND_API.G_RET_STS_SUCCESS;
100:
101: x_cust_ref_number := p_rec.customer_ref_number;
102: EXCEPTION
103: WHEN FND_API.G_EXC_ERROR THEN

Line 103: WHEN FND_API.G_EXC_ERROR THEN

99: x_return_status := FND_API.G_RET_STS_SUCCESS;
100:
101: x_cust_ref_number := p_rec.customer_ref_number;
102: EXCEPTION
103: WHEN FND_API.G_EXC_ERROR THEN
104: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
105: WHEN OTHERS THEN
106: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
107: END get_cust_ref_number;

Line 104: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

100:
101: x_cust_ref_number := p_rec.customer_ref_number;
102: EXCEPTION
103: WHEN FND_API.G_EXC_ERROR THEN
104: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
105: WHEN OTHERS THEN
106: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
107: END get_cust_ref_number;
108:

Line 106: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

102: EXCEPTION
103: WHEN FND_API.G_EXC_ERROR THEN
104: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
105: WHEN OTHERS THEN
106: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
107: END get_cust_ref_number;
108:
109: ---------------------------------------------------------------------
110: -- PROCEDURE

Line 130: x_return_status := FND_API.G_RET_STS_SUCCESS;

126: IS
127: BEGIN
128:
129: -- Initialize API return status to sucess
130: x_return_status := FND_API.G_RET_STS_SUCCESS;
131:
132: x_cust_ref_date := p_rec.customer_ref_date;
133: EXCEPTION
134: WHEN FND_API.G_EXC_ERROR THEN

Line 134: WHEN FND_API.G_EXC_ERROR THEN

130: x_return_status := FND_API.G_RET_STS_SUCCESS;
131:
132: x_cust_ref_date := p_rec.customer_ref_date;
133: EXCEPTION
134: WHEN FND_API.G_EXC_ERROR THEN
135: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
136: WHEN OTHERS THEN
137: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
138: END get_cust_ref_date;

Line 135: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

131:
132: x_cust_ref_date := p_rec.customer_ref_date;
133: EXCEPTION
134: WHEN FND_API.G_EXC_ERROR THEN
135: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
136: WHEN OTHERS THEN
137: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
138: END get_cust_ref_date;
139:

Line 137: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

133: EXCEPTION
134: WHEN FND_API.G_EXC_ERROR THEN
135: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
136: WHEN OTHERS THEN
137: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
138: END get_cust_ref_date;
139:
140: ---------------------------------------------------------------------
141: -- PROCEDURE: Get_Deduction_Value

Line 149: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE

145: --
146: -- PARAMETERS:
147: -- IN
148: -- p_api_version_number IN NUMBER Required
149: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
150: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
151: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
152: -- P_deduction IN DEDUCTION_REC_TYPE Required
153: --

Line 150: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL

146: -- PARAMETERS:
147: -- IN
148: -- p_api_version_number IN NUMBER Required
149: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
150: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
151: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
152: -- P_deduction IN DEDUCTION_REC_TYPE Required
153: --
154: -- OUT:

Line 151: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE

147: -- IN
148: -- p_api_version_number IN NUMBER Required
149: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
150: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
151: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
152: -- P_deduction IN DEDUCTION_REC_TYPE Required
153: --
154: -- OUT:
155: -- x_return_status OUT VARCHAR2

Line 164: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

160: --
161: ---------------------------------------------------------------------
162: PROCEDURE Get_Deduction_Value(
163: P_Api_Version_Number IN NUMBER,
164: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
165: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
166: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
167:
168: X_Return_Status OUT NOCOPY VARCHAR2,

Line 165: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

161: ---------------------------------------------------------------------
162: PROCEDURE Get_Deduction_Value(
163: P_Api_Version_Number IN NUMBER,
164: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
165: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
166: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
167:
168: X_Return_Status OUT NOCOPY VARCHAR2,
169: X_Msg_Count OUT NOCOPY NUMBER,

Line 166: P_Commit IN VARCHAR2 := FND_API.G_FALSE,

162: PROCEDURE Get_Deduction_Value(
163: P_Api_Version_Number IN NUMBER,
164: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
165: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
166: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
167:
168: X_Return_Status OUT NOCOPY VARCHAR2,
169: X_Msg_Count OUT NOCOPY NUMBER,
170: X_Msg_Data OUT NOCOPY VARCHAR2,

Line 186: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

182: BEGIN
183: -- Standard Start of API savepoint
184: SAVEPOINT GET_DED_VAL_PUB;
185: -- Standard call to check for call compatibility.
186: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
187: p_api_version_number,
188: l_api_name,
189: G_PKG_NAME)
190: THEN

Line 191: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

187: p_api_version_number,
188: l_api_name,
189: G_PKG_NAME)
190: THEN
191: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
192: END IF;
193:
194: -- Initialize message list if p_init_msg_list is set to TRUE.
195: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 195: IF FND_API.to_Boolean( p_init_msg_list ) THEN

191: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
192: END IF;
193:
194: -- Initialize message list if p_init_msg_list is set to TRUE.
195: IF FND_API.to_Boolean( p_init_msg_list ) THEN
196: FND_MSG_PUB.initialize;
197: END IF;
198:
199: -- Debug Message

Line 207: x_return_status := FND_API.G_RET_STS_SUCCESS;

203: FND_MSG_PUB.Add;
204: END IF;
205:
206: -- Initialize API return status to SUCCESS
207: x_return_status := FND_API.G_RET_STS_SUCCESS;
208:
209: get_claim_type(p_rec => p_deduction,
210: x_claim_type_id => l_qualifier.claim_type_id,
211: x_return_status => l_return_status);

Line 212: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

208:
209: get_claim_type(p_rec => p_deduction,
210: x_claim_type_id => l_qualifier.claim_type_id,
211: x_return_status => l_return_status);
212: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
213: RAISE FND_API.G_EXC_ERROR;
214: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
215: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
216: END IF;

Line 213: RAISE FND_API.G_EXC_ERROR;

209: get_claim_type(p_rec => p_deduction,
210: x_claim_type_id => l_qualifier.claim_type_id,
211: x_return_status => l_return_status);
212: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
213: RAISE FND_API.G_EXC_ERROR;
214: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
215: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
216: END IF;
217:

Line 214: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

210: x_claim_type_id => l_qualifier.claim_type_id,
211: x_return_status => l_return_status);
212: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
213: RAISE FND_API.G_EXC_ERROR;
214: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
215: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
216: END IF;
217:
218: get_reason(p_rec => p_deduction,

Line 215: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

211: x_return_status => l_return_status);
212: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
213: RAISE FND_API.G_EXC_ERROR;
214: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
215: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
216: END IF;
217:
218: get_reason(p_rec => p_deduction,
219: x_reason_code_id=> l_qualifier.reason_code_id,

Line 221: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

217:
218: get_reason(p_rec => p_deduction,
219: x_reason_code_id=> l_qualifier.reason_code_id,
220: x_return_status => l_return_status);
221: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
222: RAISE FND_API.G_EXC_ERROR;
223: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
224: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
225: END IF;

Line 222: RAISE FND_API.G_EXC_ERROR;

218: get_reason(p_rec => p_deduction,
219: x_reason_code_id=> l_qualifier.reason_code_id,
220: x_return_status => l_return_status);
221: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
222: RAISE FND_API.G_EXC_ERROR;
223: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
224: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
225: END IF;
226:

Line 223: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

219: x_reason_code_id=> l_qualifier.reason_code_id,
220: x_return_status => l_return_status);
221: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
222: RAISE FND_API.G_EXC_ERROR;
223: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
224: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
225: END IF;
226:
227: get_cust_ref_number(p_rec => p_deduction,

Line 224: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

220: x_return_status => l_return_status);
221: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
222: RAISE FND_API.G_EXC_ERROR;
223: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
224: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
225: END IF;
226:
227: get_cust_ref_number(p_rec => p_deduction,
228: x_cust_ref_number => l_qualifier.customer_ref_number,

Line 230: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

226:
227: get_cust_ref_number(p_rec => p_deduction,
228: x_cust_ref_number => l_qualifier.customer_ref_number,
229: x_return_status => l_return_status);
230: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
231: RAISE FND_API.G_EXC_ERROR;
232: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
233: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
234: END IF;

Line 231: RAISE FND_API.G_EXC_ERROR;

227: get_cust_ref_number(p_rec => p_deduction,
228: x_cust_ref_number => l_qualifier.customer_ref_number,
229: x_return_status => l_return_status);
230: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
231: RAISE FND_API.G_EXC_ERROR;
232: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
233: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
234: END IF;
235:

Line 232: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

228: x_cust_ref_number => l_qualifier.customer_ref_number,
229: x_return_status => l_return_status);
230: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
231: RAISE FND_API.G_EXC_ERROR;
232: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
233: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
234: END IF;
235:
236: get_cust_ref_date(p_rec => p_deduction,

Line 233: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

229: x_return_status => l_return_status);
230: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
231: RAISE FND_API.G_EXC_ERROR;
232: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
233: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
234: END IF;
235:
236: get_cust_ref_date(p_rec => p_deduction,
237: x_cust_ref_date => l_qualifier.customer_ref_date,

Line 239: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

235:
236: get_cust_ref_date(p_rec => p_deduction,
237: x_cust_ref_date => l_qualifier.customer_ref_date,
238: x_return_status => l_return_status);
239: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
240: RAISE FND_API.G_EXC_ERROR;
241: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
242: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
243: END IF;

Line 240: RAISE FND_API.G_EXC_ERROR;

236: get_cust_ref_date(p_rec => p_deduction,
237: x_cust_ref_date => l_qualifier.customer_ref_date,
238: x_return_status => l_return_status);
239: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
240: RAISE FND_API.G_EXC_ERROR;
241: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
242: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
243: END IF;
244:

Line 241: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

237: x_cust_ref_date => l_qualifier.customer_ref_date,
238: x_return_status => l_return_status);
239: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
240: RAISE FND_API.G_EXC_ERROR;
241: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
242: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
243: END IF;
244:
245: -- assign the rest of the values

Line 242: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

238: x_return_status => l_return_status);
239: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
240: RAISE FND_API.G_EXC_ERROR;
241: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
242: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
243: END IF;
244:
245: -- assign the rest of the values
246:

Line 261: IF FND_API.to_Boolean( p_commit )

257:
258: x_qualifier := l_qualifier;
259:
260: -- Standard check for p_commit
261: IF FND_API.to_Boolean( p_commit )
262: THEN
263: COMMIT WORK;
264: END IF;
265:

Line 280: WHEN FND_API.G_EXC_ERROR THEN

276: p_data => x_msg_data
277: );
278:
279: EXCEPTION
280: WHEN FND_API.G_EXC_ERROR THEN
281: ROLLBACK TO GET_DED_VAL_PUB;
282: x_return_status := FND_API.G_RET_STS_ERROR;
283: -- Standard call to get message count and if count=1, get the message
284: FND_MSG_PUB.Count_And_Get (

Line 282: x_return_status := FND_API.G_RET_STS_ERROR;

278:
279: EXCEPTION
280: WHEN FND_API.G_EXC_ERROR THEN
281: ROLLBACK TO GET_DED_VAL_PUB;
282: x_return_status := FND_API.G_RET_STS_ERROR;
283: -- Standard call to get message count and if count=1, get the message
284: FND_MSG_PUB.Count_And_Get (
285: p_encoded => FND_API.G_FALSE,
286: p_count => x_msg_count,

Line 285: p_encoded => FND_API.G_FALSE,

281: ROLLBACK TO GET_DED_VAL_PUB;
282: x_return_status := FND_API.G_RET_STS_ERROR;
283: -- Standard call to get message count and if count=1, get the message
284: FND_MSG_PUB.Count_And_Get (
285: p_encoded => FND_API.G_FALSE,
286: p_count => x_msg_count,
287: p_data => x_msg_data
288: );
289: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 289: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

285: p_encoded => FND_API.G_FALSE,
286: p_count => x_msg_count,
287: p_data => x_msg_data
288: );
289: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
290: ROLLBACK TO GET_DED_VAL_PUB;
291: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
292: -- Standard call to get message count and if count=1, get the message
293: FND_MSG_PUB.Count_And_Get (

Line 291: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

287: p_data => x_msg_data
288: );
289: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
290: ROLLBACK TO GET_DED_VAL_PUB;
291: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
292: -- Standard call to get message count and if count=1, get the message
293: FND_MSG_PUB.Count_And_Get (
294: p_encoded => FND_API.G_FALSE,
295: p_count => x_msg_count,

Line 294: p_encoded => FND_API.G_FALSE,

290: ROLLBACK TO GET_DED_VAL_PUB;
291: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
292: -- Standard call to get message count and if count=1, get the message
293: FND_MSG_PUB.Count_And_Get (
294: p_encoded => FND_API.G_FALSE,
295: p_count => x_msg_count,
296: p_data => x_msg_data
297: );
298: WHEN OTHERS THEN

Line 300: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

296: p_data => x_msg_data
297: );
298: WHEN OTHERS THEN
299: ROLLBACK TO GET_DED_VAL_PUBP;
300: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
301: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
302: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_ASS_QUA_ERR');
303: FND_MSG_PUB.add;
304: END IF;

Line 308: p_encoded => FND_API.G_FALSE,

304: END IF;
305:
306: -- Standard call to get message count and if count=1, get the message
307: FND_MSG_PUB.Count_And_Get (
308: p_encoded => FND_API.G_FALSE,
309: p_count => x_msg_count,
310: p_data => x_msg_data
311: );
312: End get_deduction_value;