eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OZF_PARTNER_CLAIM_GRP dependencies on FND_API

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

20: --
21: -- PARAMETERS:
22: -- IN
23: -- p_api_version_number IN NUMBER Required
24: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
25: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
26: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
27: -- p_claim_rec IN CLAIM_REC_TYPE Required
28: -- p_promotion_activity_tbl IN PROMOTION_ACTIVITY_TBL_TYPE Required

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

21: -- PARAMETERS:
22: -- IN
23: -- p_api_version_number IN NUMBER Required
24: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
25: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
26: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
27: -- p_claim_rec IN CLAIM_REC_TYPE Required
28: -- p_promotion_activity_tbl IN PROMOTION_ACTIVITY_TBL_TYPE Required
29: --

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

22: -- IN
23: -- p_api_version_number IN NUMBER Required
24: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
25: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
26: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
27: -- p_claim_rec IN CLAIM_REC_TYPE Required
28: -- p_promotion_activity_tbl IN PROMOTION_ACTIVITY_TBL_TYPE Required
29: --
30: -- OUT:

Line 105: IF NOT FND_API.Compatible_API_Call ( l_api_version,

101: OZF_Utility_PVT.debug_message(l_full_name||': start');
102: END IF;
103:
104: -- Standard call to check for call compatibility.
105: IF NOT FND_API.Compatible_API_Call ( l_api_version,
106: p_api_version_number,
107: l_api_name,
108: G_PKG_NAME ) THEN
109: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 109: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

105: IF NOT FND_API.Compatible_API_Call ( l_api_version,
106: p_api_version_number,
107: l_api_name,
108: G_PKG_NAME ) THEN
109: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
110: END IF;
111:
112: -- Initialize message list if p_init_msg_list is set to TRUE.
113: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 113: IF FND_API.to_Boolean( p_init_msg_list ) THEN

109: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
110: END IF;
111:
112: -- Initialize message list if p_init_msg_list is set to TRUE.
113: IF FND_API.to_Boolean( p_init_msg_list ) THEN
114: FND_MSG_PUB.initialize;
115: END IF;
116:
117: -- Initialize API return status to SUCCESS

Line 118: x_return_status := FND_API.G_RET_STS_SUCCESS;

114: FND_MSG_PUB.initialize;
115: END IF;
116:
117: -- Initialize API return status to SUCCESS
118: x_return_status := FND_API.G_RET_STS_SUCCESS;
119:
120:
121: -- Standard call to check for call compatibility.
122: IF NOT FND_API.Compatible_API_Call ( l_api_version,

Line 122: IF NOT FND_API.Compatible_API_Call ( l_api_version,

118: x_return_status := FND_API.G_RET_STS_SUCCESS;
119:
120:
121: -- Standard call to check for call compatibility.
122: IF NOT FND_API.Compatible_API_Call ( l_api_version,
123: p_api_version_number,
124: l_api_name,
125: G_PKG_NAME)
126: THEN

Line 127: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

123: p_api_version_number,
124: l_api_name,
125: G_PKG_NAME)
126: THEN
127: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
128: END IF;
129:
130: -- Initialize message list if p_init_msg_list is set to TRUE.
131: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 131: IF FND_API.to_Boolean( p_init_msg_list ) THEN

127: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
128: END IF;
129:
130: -- Initialize message list if p_init_msg_list is set to TRUE.
131: IF FND_API.to_Boolean( p_init_msg_list ) THEN
132: FND_MSG_PUB.initialize;
133: END IF;
134:
135: -- Debug Message

Line 143: x_return_status := FND_API.G_RET_STS_SUCCESS;

139: FND_MSG_PUB.Add;
140: END IF;
141:
142: -- Initialize API return status to SUCCESS
143: x_return_status := FND_API.G_RET_STS_SUCCESS;
144:
145: -- [BEGIN OF BUG 4067282 FIXING]
146: l_session_org_id := MO_GLOBAL.GET_CURRENT_ORG_ID(); -- R12 Enahancements.
147:

Line 159: ,p_init_msg_list => FND_API.g_false

155: -----------------------------
156: -- raise business event
157: OZF_CLAIM_SETTLEMENT_PVT.Raise_Business_Event(
158: p_api_version => l_api_version
159: ,p_init_msg_list => FND_API.g_false
160: ,p_commit => FND_API.g_false
161: ,p_validation_level => FND_API.g_valid_level_full
162: ,x_return_status => l_return_status
163: ,x_msg_data => x_msg_data

Line 160: ,p_commit => FND_API.g_false

156: -- raise business event
157: OZF_CLAIM_SETTLEMENT_PVT.Raise_Business_Event(
158: p_api_version => l_api_version
159: ,p_init_msg_list => FND_API.g_false
160: ,p_commit => FND_API.g_false
161: ,p_validation_level => FND_API.g_valid_level_full
162: ,x_return_status => l_return_status
163: ,x_msg_data => x_msg_data
164: ,x_msg_count => x_msg_count

Line 161: ,p_validation_level => FND_API.g_valid_level_full

157: OZF_CLAIM_SETTLEMENT_PVT.Raise_Business_Event(
158: p_api_version => l_api_version
159: ,p_init_msg_list => FND_API.g_false
160: ,p_commit => FND_API.g_false
161: ,p_validation_level => FND_API.g_valid_level_full
162: ,x_return_status => l_return_status
163: ,x_msg_data => x_msg_data
164: ,x_msg_count => x_msg_count
165:

Line 171: IF l_return_status = FND_API.g_ret_sts_error THEN

167: ,p_old_status => NULL
168: ,p_new_status => 'NEW'
169: ,p_event_name => 'oracle.apps.ozf.claim.assignQualifier'
170: );
171: IF l_return_status = FND_API.g_ret_sts_error THEN
172: RAISE FND_API.g_exc_error;
173: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
174: RAISE FND_API.g_exc_unexpected_error;
175: END IF;

Line 172: RAISE FND_API.g_exc_error;

168: ,p_new_status => 'NEW'
169: ,p_event_name => 'oracle.apps.ozf.claim.assignQualifier'
170: );
171: IF l_return_status = FND_API.g_ret_sts_error THEN
172: RAISE FND_API.g_exc_error;
173: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
174: RAISE FND_API.g_exc_unexpected_error;
175: END IF;
176:

Line 173: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

169: ,p_event_name => 'oracle.apps.ozf.claim.assignQualifier'
170: );
171: IF l_return_status = FND_API.g_ret_sts_error THEN
172: RAISE FND_API.g_exc_error;
173: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
174: RAISE FND_API.g_exc_unexpected_error;
175: END IF;
176:
177: -----------------------------------------

Line 174: RAISE FND_API.g_exc_unexpected_error;

170: );
171: IF l_return_status = FND_API.g_ret_sts_error THEN
172: RAISE FND_API.g_exc_error;
173: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
174: RAISE FND_API.g_exc_unexpected_error;
175: END IF;
176:
177: -----------------------------------------
178: -- 2. Minimum required fields checking --

Line 196: RAISE FND_API.G_EXC_ERROR;

192: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
193: FND_MESSAGE.Set_Name('OZF','OZF_REQUIRED_FIELDS_MISSING');
194: FND_MSG_PUB.Add;
195: END IF;
196: RAISE FND_API.G_EXC_ERROR;
197: END IF;
198:
199: ------------------------------------------
200: -- 3. Default and derive column valude --

Line 262: ,p_init_msg_list => FND_API.g_false

258: -- 4. Call OZF_CLAIM_ACCRUL_PVT
259: ------------------------------------------
260: OZF_Claim_Accrual_PVT.Create_Claim_For_Accruals(
261: p_api_version => l_api_version
262: ,p_init_msg_list => FND_API.g_false
263: ,p_commit => FND_API.g_false
264: ,p_validation_level => FND_API.g_valid_level_full
265:
266: ,x_return_status => l_return_status

Line 263: ,p_commit => FND_API.g_false

259: ------------------------------------------
260: OZF_Claim_Accrual_PVT.Create_Claim_For_Accruals(
261: p_api_version => l_api_version
262: ,p_init_msg_list => FND_API.g_false
263: ,p_commit => FND_API.g_false
264: ,p_validation_level => FND_API.g_valid_level_full
265:
266: ,x_return_status => l_return_status
267: ,x_msg_count => x_msg_count

Line 264: ,p_validation_level => FND_API.g_valid_level_full

260: OZF_Claim_Accrual_PVT.Create_Claim_For_Accruals(
261: p_api_version => l_api_version
262: ,p_init_msg_list => FND_API.g_false
263: ,p_commit => FND_API.g_false
264: ,p_validation_level => FND_API.g_valid_level_full
265:
266: ,x_return_status => l_return_status
267: ,x_msg_count => x_msg_count
268: ,x_msg_data => x_msg_data

Line 275: IF l_return_status = FND_API.g_ret_sts_error THEN

271: ,p_funds_util_flt => l_funds_util_flt
272:
273: ,x_claim_id => l_claim_id
274: );
275: IF l_return_status = FND_API.g_ret_sts_error THEN
276: RAISE FND_API.g_exc_error;
277: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
278: RAISE FND_API.g_exc_unexpected_error;
279: END IF;

Line 276: RAISE FND_API.g_exc_error;

272:
273: ,x_claim_id => l_claim_id
274: );
275: IF l_return_status = FND_API.g_ret_sts_error THEN
276: RAISE FND_API.g_exc_error;
277: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
278: RAISE FND_API.g_exc_unexpected_error;
279: END IF;
280:

Line 277: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

273: ,x_claim_id => l_claim_id
274: );
275: IF l_return_status = FND_API.g_ret_sts_error THEN
276: RAISE FND_API.g_exc_error;
277: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
278: RAISE FND_API.g_exc_unexpected_error;
279: END IF;
280:
281: -- [BEGIN OF BUG 4067282 FIXING]: Update Claim Line with Order information

Line 278: RAISE FND_API.g_exc_unexpected_error;

274: );
275: IF l_return_status = FND_API.g_ret_sts_error THEN
276: RAISE FND_API.g_exc_error;
277: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
278: RAISE FND_API.g_exc_unexpected_error;
279: END IF;
280:
281: -- [BEGIN OF BUG 4067282 FIXING]: Update Claim Line with Order information
282: -- Assumption: per referral claim <--> per order

Line 319: IF FND_API.to_Boolean(p_commit) THEN

315: -- [END OF BUG 4067282 FIXING]
316:
317:
318: -- Standard check for p_commit
319: IF FND_API.to_Boolean(p_commit) THEN
320: COMMIT WORK;
321: END IF;
322:
323: -- Debug Message

Line 341: WHEN FND_API.G_EXC_ERROR THEN

337: OZF_Utility_PVT.debug_message(l_full_name ||': end');
338: END IF;
339:
340: EXCEPTION
341: WHEN FND_API.G_EXC_ERROR THEN
342: ROLLBACK TO Create_Partner_Claim;
343: x_return_status := FND_API.G_RET_STS_ERROR;
344: FND_MSG_PUB.Count_And_Get (
345: p_encoded => FND_API.G_FALSE,

Line 343: x_return_status := FND_API.G_RET_STS_ERROR;

339:
340: EXCEPTION
341: WHEN FND_API.G_EXC_ERROR THEN
342: ROLLBACK TO Create_Partner_Claim;
343: x_return_status := FND_API.G_RET_STS_ERROR;
344: FND_MSG_PUB.Count_And_Get (
345: p_encoded => FND_API.G_FALSE,
346: p_count => x_msg_count,
347: p_data => x_msg_data

Line 345: p_encoded => FND_API.G_FALSE,

341: WHEN FND_API.G_EXC_ERROR THEN
342: ROLLBACK TO Create_Partner_Claim;
343: x_return_status := FND_API.G_RET_STS_ERROR;
344: FND_MSG_PUB.Count_And_Get (
345: p_encoded => FND_API.G_FALSE,
346: p_count => x_msg_count,
347: p_data => x_msg_data
348: );
349:

Line 350: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

346: p_count => x_msg_count,
347: p_data => x_msg_data
348: );
349:
350: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
351: ROLLBACK TO Create_Partner_Claim;
352: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
353: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
354: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_CRE_DEDU_ERR');

Line 352: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

348: );
349:
350: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
351: ROLLBACK TO Create_Partner_Claim;
352: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
353: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
354: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_CRE_DEDU_ERR');
355: FND_MSG_PUB.add;
356: END IF;

Line 358: p_encoded => FND_API.G_FALSE,

354: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_CRE_DEDU_ERR');
355: FND_MSG_PUB.add;
356: END IF;
357: FND_MSG_PUB.Count_And_Get (
358: p_encoded => FND_API.G_FALSE,
359: p_count => x_msg_count,
360: p_data => x_msg_data
361: );
362:

Line 365: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

361: );
362:
363: WHEN OTHERS THEN
364: ROLLBACK TO Create_Partner_Claim;
365: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
366: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
367: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_CRE_DEDU_ERR');
368: FND_MSG_PUB.add;
369: END IF;

Line 371: p_encoded => FND_API.G_FALSE,

367: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_CRE_DEDU_ERR');
368: FND_MSG_PUB.add;
369: END IF;
370: FND_MSG_PUB.Count_And_Get (
371: p_encoded => FND_API.G_FALSE,
372: p_count => x_msg_count,
373: p_data => x_msg_data
374: );
375:

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

383: --
384: -- PARAMETERS:
385: -- IN:
386: -- p_api_version_number IN NUMBER Required
387: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
388: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
389: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
390: -- P_claim_id IN NUMBER Required
391: -- P_status_code IN VARCHAR2 Required

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

384: -- PARAMETERS:
385: -- IN:
386: -- p_api_version_number IN NUMBER Required
387: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
388: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
389: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
390: -- P_claim_id IN NUMBER Required
391: -- P_status_code IN VARCHAR2 Required
392: -- P_note_type IN VARCHAR2 Optional Default = NULL

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

385: -- IN:
386: -- p_api_version_number IN NUMBER Required
387: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
388: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
389: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
390: -- P_claim_id IN NUMBER Required
391: -- P_status_code IN VARCHAR2 Required
392: -- P_note_type IN VARCHAR2 Optional Default = NULL
393: -- p_note_detail IN VARCHAR2 Optional Default = NULL

Line 457: IF NOT FND_API.Compatible_API_Call ( l_api_version,

453: OZF_Utility_PVT.debug_message(l_full_name||': start');
454: END IF;
455:
456: -- Standard call to check for call compatibility.
457: IF NOT FND_API.Compatible_API_Call ( l_api_version,
458: p_api_version_number,
459: l_api_name,
460: G_PKG_NAME ) THEN
461: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 461: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

457: IF NOT FND_API.Compatible_API_Call ( l_api_version,
458: p_api_version_number,
459: l_api_name,
460: G_PKG_NAME ) THEN
461: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
462: END IF;
463:
464: -- Initialize message list if p_init_msg_list is set to TRUE.
465: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 465: IF FND_API.to_Boolean( p_init_msg_list ) THEN

461: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
462: END IF;
463:
464: -- Initialize message list if p_init_msg_list is set to TRUE.
465: IF FND_API.to_Boolean( p_init_msg_list ) THEN
466: FND_MSG_PUB.initialize;
467: END IF;
468:
469: -- Initialize API return status to SUCCESS

Line 470: x_return_status := FND_API.G_RET_STS_SUCCESS;

466: FND_MSG_PUB.initialize;
467: END IF;
468:
469: -- Initialize API return status to SUCCESS
470: x_return_status := FND_API.G_RET_STS_SUCCESS;
471:
472: -----------------------------------------
473: -- 1. Minimum required fields checking --
474: -----------------------------------------

Line 481: RAISE FND_API.G_EXC_ERROR;

477: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
478: FND_MESSAGE.Set_Name('OZF','OZF_REQUIRED_FIELDS_MISSING');
479: FND_MSG_PUB.Add;
480: END IF;
481: RAISE FND_API.G_EXC_ERROR;
482: ELSE
483: OPEN csr_claim_status(p_status_code);
484: FETCH csr_claim_status INTO l_status_code;
485: CLOSE csr_claim_status;

Line 491: RAISE FND_API.G_EXC_ERROR;

487: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
488: FND_MESSAGE.Set_Name('OZF','OZF_CLAIM_INVALID_STATUS');
489: FND_MSG_PUB.Add;
490: END IF;
491: RAISE FND_API.G_EXC_ERROR;
492: END IF;
493: END IF;
494:
495: -----------------------------------------

Line 530: RAISE FND_API.g_exc_unexpected_error;

526: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
527: FND_MESSAGE.Set_Token('TEXT',sqlerrm);
528: FND_MSG_PUB.Add;
529: END IF;
530: RAISE FND_API.g_exc_unexpected_error;
531: END;
532: l_claim_pvt_rec.status_code := 'CLOSED';
533: ELSE
534: l_claim_pvt_rec.status_code := p_status_code;

Line 541: ,p_init_msg_list => FND_API.G_FALSE

537: l_claim_pvt_rec.comments := SUBSTR(p_comments, 1, 2000);
538:
539: OZF_claim_PVT.Update_Claim (
540: p_api_version => l_api_version
541: ,p_init_msg_list => FND_API.G_FALSE
542: ,p_commit => FND_API.G_FALSE
543: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
544: ,x_return_status => l_return_status
545: ,x_msg_data => x_msg_data

Line 542: ,p_commit => FND_API.G_FALSE

538:
539: OZF_claim_PVT.Update_Claim (
540: p_api_version => l_api_version
541: ,p_init_msg_list => FND_API.G_FALSE
542: ,p_commit => FND_API.G_FALSE
543: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
544: ,x_return_status => l_return_status
545: ,x_msg_data => x_msg_data
546: ,x_msg_count => x_msg_count

Line 543: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL

539: OZF_claim_PVT.Update_Claim (
540: p_api_version => l_api_version
541: ,p_init_msg_list => FND_API.G_FALSE
542: ,p_commit => FND_API.G_FALSE
543: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
544: ,x_return_status => l_return_status
545: ,x_msg_data => x_msg_data
546: ,x_msg_count => x_msg_count
547: ,p_claim => l_claim_pvt_rec

Line 552: IF l_return_status = FND_API.g_ret_sts_error THEN

548: ,p_event => 'UPDATE'
549: ,p_mode => OZF_Claim_Utility_PVT.G_AUTO_MODE
550: ,x_object_version_number => l_dummy_number
551: );
552: IF l_return_status = FND_API.g_ret_sts_error THEN
553: RAISE FND_API.g_exc_error;
554: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
555: RAISE FND_API.g_exc_unexpected_error;
556: END IF;

Line 553: RAISE FND_API.g_exc_error;

549: ,p_mode => OZF_Claim_Utility_PVT.G_AUTO_MODE
550: ,x_object_version_number => l_dummy_number
551: );
552: IF l_return_status = FND_API.g_ret_sts_error THEN
553: RAISE FND_API.g_exc_error;
554: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
555: RAISE FND_API.g_exc_unexpected_error;
556: END IF;
557:

Line 554: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

550: ,x_object_version_number => l_dummy_number
551: );
552: IF l_return_status = FND_API.g_ret_sts_error THEN
553: RAISE FND_API.g_exc_error;
554: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
555: RAISE FND_API.g_exc_unexpected_error;
556: END IF;
557:
558: -----------------------------------------

Line 555: RAISE FND_API.g_exc_unexpected_error;

551: );
552: IF l_return_status = FND_API.g_ret_sts_error THEN
553: RAISE FND_API.g_exc_error;
554: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
555: RAISE FND_API.g_exc_unexpected_error;
556: END IF;
557:
558: -----------------------------------------
559: -- 3. Create Note

Line 583: IF l_return_status = FND_API.g_ret_sts_error THEN

579: ,p_note_type => p_note_type
580: ,p_last_update_date => SYSDATE
581: ,p_creation_date => SYSDATE
582: );
583: IF l_return_status = FND_API.g_ret_sts_error THEN
584: RAISE FND_API.g_exc_error;
585: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
586: RAISE FND_API.g_exc_unexpected_error;
587: END IF;

Line 584: RAISE FND_API.g_exc_error;

580: ,p_last_update_date => SYSDATE
581: ,p_creation_date => SYSDATE
582: );
583: IF l_return_status = FND_API.g_ret_sts_error THEN
584: RAISE FND_API.g_exc_error;
585: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
586: RAISE FND_API.g_exc_unexpected_error;
587: END IF;
588: END IF;

Line 585: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

581: ,p_creation_date => SYSDATE
582: );
583: IF l_return_status = FND_API.g_ret_sts_error THEN
584: RAISE FND_API.g_exc_error;
585: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
586: RAISE FND_API.g_exc_unexpected_error;
587: END IF;
588: END IF;
589:

Line 586: RAISE FND_API.g_exc_unexpected_error;

582: );
583: IF l_return_status = FND_API.g_ret_sts_error THEN
584: RAISE FND_API.g_exc_error;
585: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
586: RAISE FND_API.g_exc_unexpected_error;
587: END IF;
588: END IF;
589:
590: -- [BEGIN OF BUG 4067282 FIXING]

Line 599: IF FND_API.to_Boolean(p_commit) THEN

595: END IF;
596: -- [END OF BUG 4067282 FIXING]
597:
598: -- Standard check for p_commit
599: IF FND_API.to_Boolean(p_commit) THEN
600: COMMIT WORK;
601: END IF;
602:
603: -- Standard call to get message count and if count is 1, get message info.

Line 614: WHEN FND_API.G_EXC_ERROR THEN

610: OZF_Utility_PVT.debug_message(l_full_name||': start');
611: END IF;
612:
613: EXCEPTION
614: WHEN FND_API.G_EXC_ERROR THEN
615: ROLLBACK TO Update_Partner_Claim;
616: x_return_status := FND_API.G_RET_STS_ERROR;
617: FND_MSG_PUB.Count_And_Get (
618: p_encoded => FND_API.G_FALSE,

Line 616: x_return_status := FND_API.G_RET_STS_ERROR;

612:
613: EXCEPTION
614: WHEN FND_API.G_EXC_ERROR THEN
615: ROLLBACK TO Update_Partner_Claim;
616: x_return_status := FND_API.G_RET_STS_ERROR;
617: FND_MSG_PUB.Count_And_Get (
618: p_encoded => FND_API.G_FALSE,
619: p_count => x_msg_count,
620: p_data => x_msg_data

Line 618: p_encoded => FND_API.G_FALSE,

614: WHEN FND_API.G_EXC_ERROR THEN
615: ROLLBACK TO Update_Partner_Claim;
616: x_return_status := FND_API.G_RET_STS_ERROR;
617: FND_MSG_PUB.Count_And_Get (
618: p_encoded => FND_API.G_FALSE,
619: p_count => x_msg_count,
620: p_data => x_msg_data
621: );
622:

Line 623: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

619: p_count => x_msg_count,
620: p_data => x_msg_data
621: );
622:
623: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
624: ROLLBACK TO Update_Partner_Claim;
625: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
626: FND_MSG_PUB.Count_And_Get (
627: p_encoded => FND_API.G_FALSE,

Line 625: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

621: );
622:
623: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
624: ROLLBACK TO Update_Partner_Claim;
625: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
626: FND_MSG_PUB.Count_And_Get (
627: p_encoded => FND_API.G_FALSE,
628: p_count => x_msg_count,
629: p_data => x_msg_data

Line 627: p_encoded => FND_API.G_FALSE,

623: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
624: ROLLBACK TO Update_Partner_Claim;
625: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
626: FND_MSG_PUB.Count_And_Get (
627: p_encoded => FND_API.G_FALSE,
628: p_count => x_msg_count,
629: p_data => x_msg_data
630: );
631:

Line 634: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

630: );
631:
632: WHEN OTHERS THEN
633: ROLLBACK TO Update_Partner_Claim;
634: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
635: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
636: FND_MESSAGE.set_name('AMS', 'AMS_CLAIM_UPD_DEDU_ERR');
637: FND_MSG_PUB.add;
638: END IF;

Line 640: p_encoded => FND_API.G_FALSE,

636: FND_MESSAGE.set_name('AMS', 'AMS_CLAIM_UPD_DEDU_ERR');
637: FND_MSG_PUB.add;
638: END IF;
639: FND_MSG_PUB.Count_And_Get (
640: p_encoded => FND_API.G_FALSE,
641: p_count => x_msg_count,
642: p_data => x_msg_data
643: );
644: