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.DPP_CUSTOMERCLAIMS_PVT dependencies on FND_API

Line 30: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

26: ----------------------------------------------------------------------
27:
28: PROCEDURE Select_CustomerPrice(
29: p_api_version IN NUMBER
30: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
31: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
32: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
33: ,x_return_status OUT NOCOPY VARCHAR2
34: ,x_msg_count OUT NOCOPY NUMBER

Line 31: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

27:
28: PROCEDURE Select_CustomerPrice(
29: p_api_version IN NUMBER
30: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
31: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
32: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
33: ,x_return_status OUT NOCOPY VARCHAR2
34: ,x_msg_count OUT NOCOPY NUMBER
35: ,x_msg_data OUT NOCOPY VARCHAR2

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

28: PROCEDURE Select_CustomerPrice(
29: p_api_version IN NUMBER
30: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
31: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
32: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
33: ,x_return_status OUT NOCOPY VARCHAR2
34: ,x_msg_count OUT NOCOPY NUMBER
35: ,x_msg_data OUT NOCOPY VARCHAR2
36: ,p_cust_hdr_rec IN dpp_cust_hdr_rec_type

Line 124: IF NOT FND_API.Compatible_API_Call ( l_api_version,

120:
121: -- Standard begin of API savepoint
122: SAVEPOINT Select_CustomerPrice_PVT;
123: -- Standard call to check for call compatibility.
124: IF NOT FND_API.Compatible_API_Call ( l_api_version,
125: p_api_version,
126: l_api_name,
127: G_PKG_NAME)
128: THEN

Line 129: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 132: IF FND_API.to_Boolean( p_init_msg_list )

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

Line 142: l_return_status := FND_API.G_RET_STS_SUCCESS;

138: IF g_debug THEN
139: DPP_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
140: END IF;
141: -- Initialize API return status to sucess
142: l_return_status := FND_API.G_RET_STS_SUCCESS;
143: --
144: -- API body
145: --
146: IF l_cust_hdr_rec.org_id IS NULL THEN

Line 150: RAISE FND_API.G_EXC_ERROR;

146: IF l_cust_hdr_rec.org_id IS NULL THEN
147: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');
148: FND_MESSAGE.set_token('ID', 'Org ID');
149: FND_MSG_PUB.add;
150: RAISE FND_API.G_EXC_ERROR;
151: ELSIF l_cust_hdr_rec.Effective_Start_Date IS NULL THEN
152: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');
153: FND_MESSAGE.set_token('ID', 'Effective Start Date');
154: FND_MSG_PUB.add;

Line 155: RAISE FND_API.G_EXC_ERROR;

151: ELSIF l_cust_hdr_rec.Effective_Start_Date IS NULL THEN
152: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');
153: FND_MESSAGE.set_token('ID', 'Effective Start Date');
154: FND_MSG_PUB.add;
155: RAISE FND_API.G_EXC_ERROR;
156: ELSIF l_cust_hdr_rec.Effective_End_Date IS NULL THEN
157: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');
158: FND_MESSAGE.set_token('ID', 'Effective End Date');
159: FND_MSG_PUB.add;

Line 160: RAISE FND_API.G_EXC_ERROR;

156: ELSIF l_cust_hdr_rec.Effective_End_Date IS NULL THEN
157: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');
158: FND_MESSAGE.set_token('ID', 'Effective End Date');
159: FND_MSG_PUB.add;
160: RAISE FND_API.G_EXC_ERROR;
161: ELSIF l_cust_hdr_rec.currency_code IS NULL THEN
162: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');
163: FND_MESSAGE.set_token('ID', 'Currency Code');
164: FND_MSG_PUB.add;

Line 165: RAISE FND_API.G_EXC_ERROR;

161: ELSIF l_cust_hdr_rec.currency_code IS NULL THEN
162: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');
163: FND_MESSAGE.set_token('ID', 'Currency Code');
164: FND_MSG_PUB.add;
165: RAISE FND_API.G_EXC_ERROR;
166: ELSE
167: IF l_customer_tbl.EXISTS(1) THEN
168: FOR i IN l_customer_tbl.FIRST..l_customer_tbl.LAST LOOP
169: IF l_customer_tbl(i).inventory_item_id IS NULL THEN

Line 173: RAISE FND_API.G_EXC_ERROR;

169: IF l_customer_tbl(i).inventory_item_id IS NULL THEN
170: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');
171: FND_MESSAGE.set_token('ID', 'Inventory Item Id');
172: FND_MSG_PUB.add;
173: RAISE FND_API.G_EXC_ERROR;
174: ELSIF l_customer_tbl(i).uom_code IS NULL THEN
175: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');
176: FND_MESSAGE.set_token('ID', 'UOM Code');
177: FND_MSG_PUB.add;

Line 178: RAISE FND_API.G_EXC_ERROR;

174: ELSIF l_customer_tbl(i).uom_code IS NULL THEN
175: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');
176: FND_MESSAGE.set_token('ID', 'UOM Code');
177: FND_MSG_PUB.add;
178: RAISE FND_API.G_EXC_ERROR;
179: ELSE --Inventory item id null
180: l_customer_price_tbl.delete();
181: l_count :=0;
182: FOR get_customer_rec IN get_customer_csr(to_number(l_cust_hdr_rec.org_id),

Line 219: RAISE FND_API.G_EXC_ERROR;

215: ELSE --No line details available
216: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');
217: FND_MESSAGE.set_token('ID', 'Line Details');
218: FND_MSG_PUB.add;
219: RAISE FND_API.G_EXC_ERROR;
220: END IF;
221:
222: p_customer_tbl := l_customer_tbl;
223: x_return_status := l_return_status;

Line 226: IF FND_API.to_Boolean( p_commit )

222: p_customer_tbl := l_customer_tbl;
223: x_return_status := l_return_status;
224: END IF;
225: -- Standard check for p_commit
226: IF FND_API.to_Boolean( p_commit )
227: THEN
228: COMMIT WORK;
229: END IF;
230: -- Debug Message

Line 244: WHEN FND_API.G_EXC_ERROR THEN

240:
241: --Exception Handling
242: EXCEPTION
243:
244: WHEN FND_API.G_EXC_ERROR THEN
245: ROLLBACK TO Select_CustomerPrice_PVT;
246: x_return_status := FND_API.G_RET_STS_ERROR;
247: -- Standard call to get message count and if count=1, get the message
248: FND_MSG_PUB.Count_And_Get (

Line 246: x_return_status := FND_API.G_RET_STS_ERROR;

242: EXCEPTION
243:
244: WHEN FND_API.G_EXC_ERROR THEN
245: ROLLBACK TO Select_CustomerPrice_PVT;
246: x_return_status := FND_API.G_RET_STS_ERROR;
247: -- Standard call to get message count and if count=1, get the message
248: FND_MSG_PUB.Count_And_Get (
249: p_encoded => FND_API.G_FALSE,
250: p_count => x_msg_count,

Line 249: p_encoded => FND_API.G_FALSE,

245: ROLLBACK TO Select_CustomerPrice_PVT;
246: x_return_status := FND_API.G_RET_STS_ERROR;
247: -- Standard call to get message count and if count=1, get the message
248: FND_MSG_PUB.Count_And_Get (
249: p_encoded => FND_API.G_FALSE,
250: p_count => x_msg_count,
251: p_data => x_msg_data
252: );
253: IF x_msg_count > 1 THEN

Line 259: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

255: x_msg_data := SUBSTR((x_msg_data||' '|| FND_MSG_PUB.GET(P_MSG_INDEX => I, P_ENCODED => 'F')), 1, 2000);
256: END LOOP;
257: END IF;
258:
259: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
260: ROLLBACK TO Select_CustomerPrice_PVT;
261: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
262: -- Standard call to get message count and if count=1, get the message
263: FND_MSG_PUB.Count_And_Get (

Line 261: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

257: END IF;
258:
259: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
260: ROLLBACK TO Select_CustomerPrice_PVT;
261: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
262: -- Standard call to get message count and if count=1, get the message
263: FND_MSG_PUB.Count_And_Get (
264: p_encoded => FND_API.G_FALSE,
265: p_count => x_msg_count,

Line 264: p_encoded => FND_API.G_FALSE,

260: ROLLBACK TO Select_CustomerPrice_PVT;
261: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
262: -- Standard call to get message count and if count=1, get the message
263: FND_MSG_PUB.Count_And_Get (
264: p_encoded => FND_API.G_FALSE,
265: p_count => x_msg_count,
266: p_data => x_msg_data
267: );
268: IF x_msg_count > 1 THEN

Line 276: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

272: END IF;
273:
274: WHEN OTHERS THEN
275: ROLLBACK TO Select_CustomerPrice_PVT;
276: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
277: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
278: fnd_message.set_token('ROUTINE', 'DPP_CUSTOMERCLAIMS_PVT.Select_CustomerPrice');
279: fnd_message.set_token('ERRNO', sqlcode);
280: fnd_message.set_token('REASON', sqlerrm);

Line 284: p_encoded => FND_API.G_FALSE,

280: fnd_message.set_token('REASON', sqlerrm);
281: FND_MSG_PUB.add;
282: -- Standard call to get message count and if count=1, get the message
283: FND_MSG_PUB.Count_And_Get (
284: p_encoded => FND_API.G_FALSE,
285: p_count => x_msg_count,
286: p_data => x_msg_data
287: );
288: IF x_msg_count > 1 THEN

Line 313: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

309: ----------------------------------------------------------------------
310:
311: PROCEDURE Populate_CustomerPrice(
312: p_api_version IN NUMBER
313: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
314: ,p_commit IN VARCHAR2 := FND_API.G_TRUE
315: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
316: ,x_return_status OUT NOCOPY VARCHAR2
317: ,x_msg_count OUT NOCOPY NUMBER

Line 314: ,p_commit IN VARCHAR2 := FND_API.G_TRUE

310:
311: PROCEDURE Populate_CustomerPrice(
312: p_api_version IN NUMBER
313: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
314: ,p_commit IN VARCHAR2 := FND_API.G_TRUE
315: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
316: ,x_return_status OUT NOCOPY VARCHAR2
317: ,x_msg_count OUT NOCOPY NUMBER
318: ,x_msg_data OUT NOCOPY VARCHAR2

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

311: PROCEDURE Populate_CustomerPrice(
312: p_api_version IN NUMBER
313: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
314: ,p_commit IN VARCHAR2 := FND_API.G_TRUE
315: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
316: ,x_return_status OUT NOCOPY VARCHAR2
317: ,x_msg_count OUT NOCOPY NUMBER
318: ,x_msg_data OUT NOCOPY VARCHAR2
319: ,p_cust_hdr_rec IN dpp_cust_hdr_rec_type

Line 363: IF NOT FND_API.Compatible_API_Call ( l_api_version,

359: BEGIN
360: -- Standard begin of API savepoint
361: SAVEPOINT Populate_CustomerPrice_PVT;
362: -- Standard call to check for call compatibility.
363: IF NOT FND_API.Compatible_API_Call ( l_api_version,
364: p_api_version,
365: l_api_name,
366: G_PKG_NAME)
367: THEN

Line 368: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

364: p_api_version,
365: l_api_name,
366: G_PKG_NAME)
367: THEN
368: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
369: END IF;
370: -- Initialize message list if p_init_msg_list is set to TRUE.
371: IF FND_API.to_Boolean( p_init_msg_list )
372: THEN

Line 371: IF FND_API.to_Boolean( p_init_msg_list )

367: THEN
368: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
369: END IF;
370: -- Initialize message list if p_init_msg_list is set to TRUE.
371: IF FND_API.to_Boolean( p_init_msg_list )
372: THEN
373: FND_MSG_PUB.initialize;
374: END IF;
375:

Line 381: l_return_status := FND_API.G_RET_STS_SUCCESS;

377: IF g_debug THEN
378: DPP_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
379: END IF;
380: -- Initialize API return status to sucess
381: l_return_status := FND_API.G_RET_STS_SUCCESS;
382: --
383: -- API body
384: --
385: --Assign ) to thr rounding value

Line 394: RAISE FND_API.G_EXC_ERROR;

390: IF l_cust_hdr_rec.org_id IS NULL THEN
391: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');
392: FND_MESSAGE.set_token('ID', 'Org Id');
393: FND_MSG_PUB.add;
394: RAISE FND_API.G_EXC_ERROR;
395: ELSIF l_cust_hdr_rec.effective_start_date IS NULL THEN
396: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');
397: FND_MESSAGE.set_token('ID', 'Effective Start Date');
398: FND_MSG_PUB.add;

Line 399: RAISE FND_API.G_EXC_ERROR;

395: ELSIF l_cust_hdr_rec.effective_start_date IS NULL THEN
396: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');
397: FND_MESSAGE.set_token('ID', 'Effective Start Date');
398: FND_MSG_PUB.add;
399: RAISE FND_API.G_EXC_ERROR;
400: ELSIF l_cust_hdr_rec.effective_end_date IS NULL THEN
401: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');
402: FND_MESSAGE.set_token('ID', 'Effective End Date');
403: FND_MSG_PUB.add;

Line 404: RAISE FND_API.G_EXC_ERROR;

400: ELSIF l_cust_hdr_rec.effective_end_date IS NULL THEN
401: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');
402: FND_MESSAGE.set_token('ID', 'Effective End Date');
403: FND_MSG_PUB.add;
404: RAISE FND_API.G_EXC_ERROR;
405: ELSIF l_cust_hdr_rec.currency_code IS NULL THEN
406: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');
407: FND_MESSAGE.set_token('ID', 'Currency Code');
408: FND_MSG_PUB.add;

Line 409: RAISE FND_API.G_EXC_ERROR;

405: ELSIF l_cust_hdr_rec.currency_code IS NULL THEN
406: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');
407: FND_MESSAGE.set_token('ID', 'Currency Code');
408: FND_MSG_PUB.add;
409: RAISE FND_API.G_EXC_ERROR;
410: ELSE
411: IF l_customer_tbl.EXISTS(1) THEN
412: FOR i IN l_customer_tbl.FIRST..l_customer_tbl.LAST LOOP
413: l_supp_new_price := 0;

Line 418: RAISE FND_API.G_EXC_ERROR;

414: IF l_customer_tbl(i).inventory_item_id IS NULL THEN
415: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');
416: FND_MESSAGE.set_token('ID', 'Inventory Item Id');
417: FND_MSG_PUB.add;
418: RAISE FND_API.G_EXC_ERROR;
419: ELSE
420: BEGIN
421: SELECT SUPPLIER_NEW_PRICE, PRICE_CHANGE
422: INTO l_supp_new_price, l_price_change

Line 467: ,p_conv_type => FND_API.G_MISS_CHAR

463: END IF;
464: --Convert supp new price
465: DPP_UTILITY_PVT.convert_currency(p_from_currency => l_cust_hdr_rec.currency_code
466: ,p_to_currency => l_customer_tbl(i).customer_price_tbl(j).invoice_currency_code
467: ,p_conv_type => FND_API.G_MISS_CHAR
468: ,p_conv_rate => FND_API.G_MISS_NUM
469: ,p_conv_date => trunc(SYSDATE)
470: ,p_from_amount => l_supp_new_price
471: ,x_return_status => l_return_status

Line 468: ,p_conv_rate => FND_API.G_MISS_NUM

464: --Convert supp new price
465: DPP_UTILITY_PVT.convert_currency(p_from_currency => l_cust_hdr_rec.currency_code
466: ,p_to_currency => l_customer_tbl(i).customer_price_tbl(j).invoice_currency_code
467: ,p_conv_type => FND_API.G_MISS_CHAR
468: ,p_conv_rate => FND_API.G_MISS_NUM
469: ,p_conv_date => trunc(SYSDATE)
470: ,p_from_amount => l_supp_new_price
471: ,x_return_status => l_return_status
472: ,x_to_amount => l_conv_supp_new_price

Line 479: ,p_conv_type => FND_API.G_MISS_CHAR

475: IF l_price_change <> 0 THEN
476: -- convert price change
477: DPP_UTILITY_PVT.convert_currency(p_from_currency => l_cust_hdr_rec.currency_code
478: ,p_to_currency => l_customer_tbl(i).customer_price_tbl(j).invoice_currency_code
479: ,p_conv_type => FND_API.G_MISS_CHAR
480: ,p_conv_rate => FND_API.G_MISS_NUM
481: ,p_conv_date => trunc(SYSDATE)
482: ,p_from_amount => l_price_change
483: ,x_return_status => l_return_status

Line 480: ,p_conv_rate => FND_API.G_MISS_NUM

476: -- convert price change
477: DPP_UTILITY_PVT.convert_currency(p_from_currency => l_cust_hdr_rec.currency_code
478: ,p_to_currency => l_customer_tbl(i).customer_price_tbl(j).invoice_currency_code
479: ,p_conv_type => FND_API.G_MISS_CHAR
480: ,p_conv_rate => FND_API.G_MISS_NUM
481: ,p_conv_date => trunc(SYSDATE)
482: ,p_from_amount => l_price_change
483: ,x_return_status => l_return_status
484: ,x_to_amount => l_conv_price_change

Line 571: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

567: fnd_message.set_token('ROUTINE', 'DPP_CUSTOMERCLAIMS_PVT.Populate_CustomerPrice');
568: fnd_message.set_token('ERRNO', sqlcode);
569: fnd_message.set_token('REASON', sqlerrm);
570: fnd_msg_pub.add;
571: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
572: END;
573: -- Debug Message
574: IF g_debug THEN
575: DPP_UTILITY_PVT.debug_message('Insertion Done in table DPP_CUSTOMER_CLAIMS_ALL');

Line 599: RAISE FND_API.G_EXC_ERROR;

595: ELSE --customer_price_tbl exists
596: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');
597: FND_MESSAGE.set_token('ID', 'Line Details');
598: FND_MSG_PUB.add;
599: RAISE FND_API.G_EXC_ERROR;
600: END IF; --customer_price_tbl exists
601: END IF; --inventory_item_id is not null
602: END LOOP; --l_customer_tbl loop
603: -- Call the procedure to insert history record

Line 605: ,p_init_msg_list => FND_API.G_FALSE

601: END IF; --inventory_item_id is not null
602: END LOOP; --l_customer_tbl loop
603: -- Call the procedure to insert history record
604: DPP_LOG_PVT.Insert_ClaimsLog(p_api_version => l_api_version
605: ,p_init_msg_list => FND_API.G_FALSE
606: ,p_commit => FND_API.G_FALSE
607: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
608: ,x_return_status => l_return_status
609: ,x_msg_count => l_msg_count

Line 606: ,p_commit => FND_API.G_FALSE

602: END LOOP; --l_customer_tbl loop
603: -- Call the procedure to insert history record
604: DPP_LOG_PVT.Insert_ClaimsLog(p_api_version => l_api_version
605: ,p_init_msg_list => FND_API.G_FALSE
606: ,p_commit => FND_API.G_FALSE
607: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
608: ,x_return_status => l_return_status
609: ,x_msg_count => l_msg_count
610: ,x_msg_data => l_msg_data

Line 607: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL

603: -- Call the procedure to insert history record
604: DPP_LOG_PVT.Insert_ClaimsLog(p_api_version => l_api_version
605: ,p_init_msg_list => FND_API.G_FALSE
606: ,p_commit => FND_API.G_FALSE
607: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
608: ,x_return_status => l_return_status
609: ,x_msg_count => l_msg_count
610: ,x_msg_data => l_msg_data
611: ,p_claim_lines_tbl => l_claim_lines_tbl

Line 639: RAISE FND_API.G_EXC_ERROR;

635: ELSE
636: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');
637: FND_MESSAGE.set_token('ID', 'Line Details');
638: FND_MSG_PUB.add;
639: RAISE FND_API.G_EXC_ERROR;
640: END IF; --l_customer_tbl.EXISTS(1)
641: END IF; --l_cust_hdr_rec.org_id IS NULL
642:
643: x_return_status := l_return_status;

Line 645: IF FND_API.to_Boolean( p_commit )

641: END IF; --l_cust_hdr_rec.org_id IS NULL
642:
643: x_return_status := l_return_status;
644: -- Standard check for p_commit
645: IF FND_API.to_Boolean( p_commit )
646: THEN
647: COMMIT WORK;
648: END IF;
649: -- Debug Message

Line 669: x_return_status := FND_API.g_ret_sts_error;

665: --Exception Handling
666: EXCEPTION
667: WHEN DPP_UTILITY_PVT.resource_locked THEN
668: ROLLBACK TO Populate_CustomerPrice_PVT;
669: x_return_status := FND_API.g_ret_sts_error;
670: DPP_UTILITY_PVT.Error_Message(p_message_name => 'API_RESOURCE_LOCKED');
671: FND_MSG_PUB.Count_And_Get (
672: p_encoded => FND_API.G_FALSE,
673: p_count => x_msg_count,

Line 672: p_encoded => FND_API.G_FALSE,

668: ROLLBACK TO Populate_CustomerPrice_PVT;
669: x_return_status := FND_API.g_ret_sts_error;
670: DPP_UTILITY_PVT.Error_Message(p_message_name => 'API_RESOURCE_LOCKED');
671: FND_MSG_PUB.Count_And_Get (
672: p_encoded => FND_API.G_FALSE,
673: p_count => x_msg_count,
674: p_data => x_msg_data
675: );
676: IF x_msg_count > 1 THEN

Line 682: WHEN FND_API.G_EXC_ERROR THEN

678: x_msg_data := SUBSTR((x_msg_data||' '|| FND_MSG_PUB.GET(P_MSG_INDEX => I, P_ENCODED => 'F')), 1, 2000);
679: END LOOP;
680: END IF;
681:
682: WHEN FND_API.G_EXC_ERROR THEN
683: ROLLBACK TO Populate_CustomerPrice_PVT;
684: x_return_status := FND_API.G_RET_STS_ERROR;
685: -- Standard call to get message count and if count=1, get the message
686: FND_MSG_PUB.Count_And_Get (

Line 684: x_return_status := FND_API.G_RET_STS_ERROR;

680: END IF;
681:
682: WHEN FND_API.G_EXC_ERROR THEN
683: ROLLBACK TO Populate_CustomerPrice_PVT;
684: x_return_status := FND_API.G_RET_STS_ERROR;
685: -- Standard call to get message count and if count=1, get the message
686: FND_MSG_PUB.Count_And_Get (
687: p_encoded => FND_API.G_FALSE,
688: p_count => x_msg_count,

Line 687: p_encoded => FND_API.G_FALSE,

683: ROLLBACK TO Populate_CustomerPrice_PVT;
684: x_return_status := FND_API.G_RET_STS_ERROR;
685: -- Standard call to get message count and if count=1, get the message
686: FND_MSG_PUB.Count_And_Get (
687: p_encoded => FND_API.G_FALSE,
688: p_count => x_msg_count,
689: p_data => x_msg_data
690: );
691: IF x_msg_count > 1 THEN

Line 697: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

693: x_msg_data := SUBSTR((x_msg_data||' '|| FND_MSG_PUB.GET(P_MSG_INDEX => I, P_ENCODED => 'F')), 1, 2000);
694: END LOOP;
695: END IF;
696:
697: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
698: ROLLBACK TO Populate_CustomerPrice_PVT;
699: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
700: -- Standard call to get message count and if count=1, get the message
701: FND_MSG_PUB.Count_And_Get (

Line 699: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

695: END IF;
696:
697: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
698: ROLLBACK TO Populate_CustomerPrice_PVT;
699: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
700: -- Standard call to get message count and if count=1, get the message
701: FND_MSG_PUB.Count_And_Get (
702: p_encoded => FND_API.G_FALSE,
703: p_count => x_msg_count,

Line 702: p_encoded => FND_API.G_FALSE,

698: ROLLBACK TO Populate_CustomerPrice_PVT;
699: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
700: -- Standard call to get message count and if count=1, get the message
701: FND_MSG_PUB.Count_And_Get (
702: p_encoded => FND_API.G_FALSE,
703: p_count => x_msg_count,
704: p_data => x_msg_data
705: );
706: IF x_msg_count > 1 THEN

Line 714: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

710: END IF;
711:
712: WHEN OTHERS THEN
713: ROLLBACK TO Populate_CustomerPrice_PVT;
714: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
715: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
716: fnd_message.set_token('ROUTINE', 'DPP_CUSTOMERCLAIMS_PVT.Populate_CustomerPrice');
717: fnd_message.set_token('ERRNO', sqlcode);
718: fnd_message.set_token('REASON', sqlerrm);

Line 724: p_encoded => FND_API.G_FALSE,

720: DPP_UTILITY_PVT.debug_message('Error in inserting into DPP_CUSTOMER_CLAIMS_ALL: '||SQLERRM);
721:
722: -- Standard call to get message count and if count=1, get the message
723: FND_MSG_PUB.Count_And_Get (
724: p_encoded => FND_API.G_FALSE,
725: p_count => x_msg_count,
726: p_data => x_msg_data
727: );
728: IF x_msg_count > 1 THEN