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_COVEREDINVENTORY_PVT dependencies on FND_MSG_PUB

Line 11: G_DEBUG BOOLEAN := FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_high);

7: -- NOTE :Contains Procedures - Select Covered Inventory from INV, Populate Covered Inventory in DPP
8: -- End of Comments
9:
10: G_PKG_NAME CONSTANT VARCHAR2(30) := 'DPP_COVEREDINVENTORY_PVT';
11: G_DEBUG BOOLEAN := FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_high);
12: G_FILE_NAME CONSTANT VARCHAR2(14) := 'dppvcovb.pls';
13:
14: ---------------------------------------------------------------------
15: -- PROCEDURE

Line 145: FND_MSG_PUB.initialize;

141: END IF;
142: -- Initialize message list if p_init_msg_list is set to TRUE.
143: IF FND_API.to_Boolean( p_init_msg_list )
144: THEN
145: FND_MSG_PUB.initialize;
146: END IF;
147:
148: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_PROCEDURE, 'dpp.plsql.' || L_FULL_NAME, 'Private API: ' || l_api_name || 'start');
149:

Line 158: FND_MSG_PUB.add;

154: --
155: IF l_hdr_rec.org_id IS NULL THEN
156: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');
157: FND_MESSAGE.set_token('ID', 'Org ID');
158: FND_MSG_PUB.add;
159: RAISE FND_API.G_EXC_ERROR;
160: ELSIF l_hdr_rec.effective_start_date IS NULL THEN
161: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');
162: FND_MESSAGE.set_token('ID', 'Effective Start Date');

Line 163: FND_MSG_PUB.add;

159: RAISE FND_API.G_EXC_ERROR;
160: ELSIF l_hdr_rec.effective_start_date IS NULL THEN
161: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');
162: FND_MESSAGE.set_token('ID', 'Effective Start Date');
163: FND_MSG_PUB.add;
164: RAISE FND_API.G_EXC_ERROR;
165: ELSIF l_hdr_rec.effective_end_date IS NULL THEN
166: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');
167: FND_MESSAGE.set_token('ID', 'Effective End Date');

Line 168: FND_MSG_PUB.add;

164: RAISE FND_API.G_EXC_ERROR;
165: ELSIF l_hdr_rec.effective_end_date IS NULL THEN
166: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');
167: FND_MESSAGE.set_token('ID', 'Effective End Date');
168: FND_MSG_PUB.add;
169: RAISE FND_API.G_EXC_ERROR;
170: ELSE
171: FOR i IN l_covered_inv_tbl.FIRST..l_covered_inv_tbl.LAST LOOP
172: IF l_covered_inv_tbl(i).Transaction_Line_Id IS NULL THEN

Line 175: FND_MSG_PUB.add;

171: FOR i IN l_covered_inv_tbl.FIRST..l_covered_inv_tbl.LAST LOOP
172: IF l_covered_inv_tbl(i).Transaction_Line_Id IS NULL THEN
173: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');
174: FND_MESSAGE.set_token('ID', 'Transaction Line ID');
175: FND_MSG_PUB.add;
176: RAISE FND_API.G_EXC_ERROR;
177: ELSIF l_covered_inv_tbl(i).inventory_item_id IS NULL THEN
178: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');
179: FND_MESSAGE.set_token('ID', 'Inventory Item ID');

Line 180: FND_MSG_PUB.add;

176: RAISE FND_API.G_EXC_ERROR;
177: ELSIF l_covered_inv_tbl(i).inventory_item_id IS NULL THEN
178: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');
179: FND_MESSAGE.set_token('ID', 'Inventory Item ID');
180: FND_MSG_PUB.add;
181: RAISE FND_API.G_EXC_ERROR;
182: ELSE
183: FOR get_covered_inventory_rec IN get_covered_inventory_csr(l_hdr_rec.org_id, l_hdr_rec.effective_start_date, l_hdr_rec.effective_end_date, l_covered_inv_tbl(i).Inventory_ITem_ID)
184: LOOP

Line 261: FND_MSG_PUB.Count_And_Get

257:
258: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, 'Private API: ' || l_api_name || 'end');
259:
260: -- Standard call to get message count and if count is 1, get message info.
261: FND_MSG_PUB.Count_And_Get
262: (p_count => x_msg_count,
263: p_data => x_msg_data
264: );
265:

Line 273: FND_MSG_PUB.Count_And_Get (

269: WHEN FND_API.G_EXC_ERROR THEN
270: ROLLBACK TO Select_CoveredInventory_PVT;
271: x_return_status := FND_API.G_RET_STS_ERROR;
272: -- Standard call to get message count and if count=1, get the message
273: FND_MSG_PUB.Count_And_Get (
274: p_encoded => FND_API.G_FALSE,
275: p_count => x_msg_count,
276: p_data => x_msg_data
277: );

Line 281: x_msg_data := SUBSTR((x_msg_data||' '|| FND_MSG_PUB.GET(P_MSG_INDEX => I, P_ENCODED => 'F')), 1, 4000);

277: );
278:
279: IF x_msg_count > 1 THEN
280: FOR I IN 1..x_msg_count LOOP
281: x_msg_data := SUBSTR((x_msg_data||' '|| FND_MSG_PUB.GET(P_MSG_INDEX => I, P_ENCODED => 'F')), 1, 4000);
282: END LOOP;
283: END IF;
284:
285: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 289: FND_MSG_PUB.Count_And_Get (

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

Line 296: x_msg_data := SUBSTR((x_msg_data||' '|| FND_MSG_PUB.GET(P_MSG_INDEX => I, P_ENCODED => 'F')), 1, 4000);

292: p_data => x_msg_data
293: );
294: IF x_msg_count > 1 THEN
295: FOR I IN 1..x_msg_count LOOP
296: x_msg_data := SUBSTR((x_msg_data||' '|| FND_MSG_PUB.GET(P_MSG_INDEX => I, P_ENCODED => 'F')), 1, 4000);
297: END LOOP;
298: END IF;
299:
300: WHEN OTHERS THEN

Line 307: FND_MSG_PUB.add;

303: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
304: fnd_message.set_token('ROUTINE', 'DPP_COVEREDINVENTORY_PVT.Select_CoveredInventory');
305: fnd_message.set_token('ERRNO', sqlcode);
306: fnd_message.set_token('REASON', sqlerrm);
307: FND_MSG_PUB.add;
308: -- Standard call to get message count and if count=1, get the message
309: FND_MSG_PUB.Count_And_Get (
310: p_encoded => FND_API.G_FALSE,
311: p_count => x_msg_count,

Line 309: FND_MSG_PUB.Count_And_Get (

305: fnd_message.set_token('ERRNO', sqlcode);
306: fnd_message.set_token('REASON', sqlerrm);
307: FND_MSG_PUB.add;
308: -- Standard call to get message count and if count=1, get the message
309: FND_MSG_PUB.Count_And_Get (
310: p_encoded => FND_API.G_FALSE,
311: p_count => x_msg_count,
312: p_data => x_msg_data
313: );

Line 316: x_msg_data := SUBSTR((x_msg_data||' '|| FND_MSG_PUB.GET(P_MSG_INDEX => I, P_ENCODED => 'F')), 1, 4000);

312: p_data => x_msg_data
313: );
314: IF x_msg_count > 1 THEN
315: FOR I IN 1..x_msg_count LOOP
316: x_msg_data := SUBSTR((x_msg_data||' '|| FND_MSG_PUB.GET(P_MSG_INDEX => I, P_ENCODED => 'F')), 1, 4000);
317: END LOOP;
318: END IF;
319:
320:

Line 385: FND_MSG_PUB.initialize;

381: END IF;
382: -- Initialize message list if p_init_msg_list is set to TRUE.
383: IF FND_API.to_Boolean( p_init_msg_list )
384: THEN
385: FND_MSG_PUB.initialize;
386: END IF;
387:
388:
389: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_PROCEDURE, 'dpp.plsql.' || L_FULL_NAME, 'Private API: ' || l_api_name || 'start');

Line 442: FND_MSG_PUB.Count_And_Get

438: END IF;
439:
440: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, 'Private API: ' || l_api_name || 'end');
441: -- Standard call to get message count and if count is 1, get message info.
442: FND_MSG_PUB.Count_And_Get
443: (p_count => x_msg_count,
444: p_data => x_msg_data
445: );
446:

Line 453: FND_MSG_PUB.Count_And_Get (

449: WHEN DPP_UTILITY_PVT.resource_locked THEN
450: ROLLBACK TO Populate_CoveredInventory_PVT;
451: x_return_status := FND_API.g_ret_sts_error;
452: DPP_UTILITY_PVT.Error_Message(p_message_name => 'API_RESOURCE_LOCKED');
453: FND_MSG_PUB.Count_And_Get (
454: p_encoded => FND_API.G_FALSE,
455: p_count => x_msg_count,
456: p_data => x_msg_data
457: );

Line 460: x_msg_data := SUBSTR((x_msg_data||' '|| FND_MSG_PUB.GET(P_MSG_INDEX => I, P_ENCODED => 'F')), 1, 4000);

456: p_data => x_msg_data
457: );
458: IF x_msg_count > 1 THEN
459: FOR I IN 1..x_msg_count LOOP
460: x_msg_data := SUBSTR((x_msg_data||' '|| FND_MSG_PUB.GET(P_MSG_INDEX => I, P_ENCODED => 'F')), 1, 4000);
461: END LOOP;
462: END IF;
463:
464: WHEN FND_API.G_EXC_ERROR THEN

Line 468: FND_MSG_PUB.Count_And_Get (

464: WHEN FND_API.G_EXC_ERROR THEN
465: ROLLBACK TO Populate_CoveredInventory_PVT;
466: x_return_status := FND_API.G_RET_STS_ERROR;
467: -- Standard call to get message count and if count=1, get the message
468: FND_MSG_PUB.Count_And_Get (
469: p_encoded => FND_API.G_FALSE,
470: p_count => x_msg_count,
471: p_data => x_msg_data
472: );

Line 475: x_msg_data := SUBSTR((x_msg_data||' '|| FND_MSG_PUB.GET(P_MSG_INDEX => I, P_ENCODED => 'F')), 1, 4000);

471: p_data => x_msg_data
472: );
473: IF x_msg_count > 1 THEN
474: FOR I IN 1..x_msg_count LOOP
475: x_msg_data := SUBSTR((x_msg_data||' '|| FND_MSG_PUB.GET(P_MSG_INDEX => I, P_ENCODED => 'F')), 1, 4000);
476: END LOOP;
477: END IF;
478:
479: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 483: FND_MSG_PUB.Count_And_Get (

479: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
480: ROLLBACK TO Populate_CoveredInventory_PVT;
481: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
482: -- Standard call to get message count and if count=1, get the message
483: FND_MSG_PUB.Count_And_Get (
484: p_encoded => FND_API.G_FALSE,
485: p_count => x_msg_count,
486: p_data => x_msg_data
487: );

Line 490: x_msg_data := SUBSTR((x_msg_data||' '|| FND_MSG_PUB.GET(P_MSG_INDEX => I, P_ENCODED => 'F')), 1, 4000);

486: p_data => x_msg_data
487: );
488: IF x_msg_count > 1 THEN
489: FOR I IN 1..x_msg_count LOOP
490: x_msg_data := SUBSTR((x_msg_data||' '|| FND_MSG_PUB.GET(P_MSG_INDEX => I, P_ENCODED => 'F')), 1, 4000);
491: END LOOP;
492: END IF;
493:
494: WHEN OTHERS THEN

Line 501: FND_MSG_PUB.add;

497: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
498: fnd_message.set_token('ROUTINE', 'DPP_COVEREDINVENTORY_PVT.Populate_CoveredInventory');
499: fnd_message.set_token('ERRNO', sqlcode);
500: fnd_message.set_token('REASON', sqlerrm);
501: FND_MSG_PUB.add;
502: -- Standard call to get message count and if count=1, get the message
503: FND_MSG_PUB.Count_And_Get (
504: p_encoded => FND_API.G_FALSE,
505: p_count => x_msg_count,

Line 503: FND_MSG_PUB.Count_And_Get (

499: fnd_message.set_token('ERRNO', sqlcode);
500: fnd_message.set_token('REASON', sqlerrm);
501: FND_MSG_PUB.add;
502: -- Standard call to get message count and if count=1, get the message
503: FND_MSG_PUB.Count_And_Get (
504: p_encoded => FND_API.G_FALSE,
505: p_count => x_msg_count,
506: p_data => x_msg_data
507: );

Line 510: x_msg_data := SUBSTR((x_msg_data||' '|| FND_MSG_PUB.GET(P_MSG_INDEX => I, P_ENCODED => 'F')), 1, 4000);

506: p_data => x_msg_data
507: );
508: IF x_msg_count > 1 THEN
509: FOR I IN 1..x_msg_count LOOP
510: x_msg_data := SUBSTR((x_msg_data||' '|| FND_MSG_PUB.GET(P_MSG_INDEX => I, P_ENCODED => 'F')), 1, 4000);
511: END LOOP;
512: END IF;
513:
514: END Populate_CoveredInventory;

Line 570: FND_MSG_PUB.initialize;

566: END IF;
567: -- Initialize message list if p_init_msg_list is set to TRUE.
568: IF FND_API.to_Boolean( p_init_msg_list )
569: THEN
570: FND_MSG_PUB.initialize;
571: END IF;
572:
573: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_PROCEDURE, 'dpp.plsql.' || L_FULL_NAME, 'Private API: ' || l_api_name || 'start');
574:

Line 584: FND_MSG_PUB.add;

580: --Check whether the last updated by value is passed
581: IF l_inv_hdr_rec.Last_Updated_By IS NULL THEN
582: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');
583: FND_MESSAGE.set_token('ID', 'Last Updated By');
584: FND_MSG_PUB.add;
585: RAISE FND_API.G_EXC_ERROR;
586: ELSIF l_inv_hdr_rec.effective_start_date IS NULL THEN
587: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');
588: FND_MESSAGE.set_token('ID', 'Effective Start Date');

Line 589: FND_MSG_PUB.add;

585: RAISE FND_API.G_EXC_ERROR;
586: ELSIF l_inv_hdr_rec.effective_start_date IS NULL THEN
587: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');
588: FND_MESSAGE.set_token('ID', 'Effective Start Date');
589: FND_MSG_PUB.add;
590: RAISE FND_API.G_EXC_ERROR;
591: ELSIF l_inv_hdr_rec.effective_end_date IS NULL THEN
592: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');
593: FND_MESSAGE.set_token('ID', 'Effective End Date');

Line 594: FND_MSG_PUB.add;

590: RAISE FND_API.G_EXC_ERROR;
591: ELSIF l_inv_hdr_rec.effective_end_date IS NULL THEN
592: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');
593: FND_MESSAGE.set_token('ID', 'Effective End Date');
594: FND_MSG_PUB.add;
595: RAISE FND_API.G_EXC_ERROR;
596: END IF;
597:
598: FOR i IN l_covered_inv_tbl.FIRST..l_covered_inv_tbl.LAST LOOP

Line 602: FND_MSG_PUB.add;

598: FOR i IN l_covered_inv_tbl.FIRST..l_covered_inv_tbl.LAST LOOP
599: IF l_covered_inv_tbl(i).Transaction_Line_Id IS NULL THEN
600: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');
601: FND_MESSAGE.set_token('ID', 'Transaction Line ID');
602: FND_MSG_PUB.add;
603: RAISE FND_API.G_EXC_ERROR;
604: ELSIF
605: l_covered_inv_tbl(i).inventory_item_id IS NULL THEN
606: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');

Line 608: FND_MSG_PUB.add;

604: ELSIF
605: l_covered_inv_tbl(i).inventory_item_id IS NULL THEN
606: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');
607: FND_MESSAGE.set_token('ID', 'Inventory Item ID');
608: FND_MSG_PUB.add;
609: RAISE FND_API.G_EXC_ERROR;
610: ELSIF
611: l_covered_inv_tbl(i).UOM_Code IS NULL THEN
612: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');

Line 614: FND_MSG_PUB.add;

610: ELSIF
611: l_covered_inv_tbl(i).UOM_Code IS NULL THEN
612: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');
613: FND_MESSAGE.set_token('ID', 'UOM Code');
614: FND_MSG_PUB.add;
615: RAISE FND_API.G_EXC_ERROR;
616: ELSE
617: BEGIN
618: UPDATE DPP_TRANSACTION_LINES_ALL

Line 657: FND_MSG_PUB.add;

653: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
654: fnd_message.set_token('ROUTINE', 'DPP_BUSINESSEVENTS_PVT');
655: fnd_message.set_token('ERRNO', sqlcode);
656: fnd_message.set_token('REASON', 'SUPPLIER TRADE PROFILE IS NOT FOUND'); --To be modified
657: FND_MSG_PUB.add;
658: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
659: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
660: END IF;
661: RAISE FND_API.g_exc_error;

Line 658: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

654: fnd_message.set_token('ROUTINE', 'DPP_BUSINESSEVENTS_PVT');
655: fnd_message.set_token('ERRNO', sqlcode);
656: fnd_message.set_token('REASON', 'SUPPLIER TRADE PROFILE IS NOT FOUND'); --To be modified
657: FND_MSG_PUB.add;
658: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
659: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
660: END IF;
661: RAISE FND_API.g_exc_error;
662: WHEN OTHERS THEN

Line 659: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);

655: fnd_message.set_token('ERRNO', sqlcode);
656: fnd_message.set_token('REASON', 'SUPPLIER TRADE PROFILE IS NOT FOUND'); --To be modified
657: FND_MSG_PUB.add;
658: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
659: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
660: END IF;
661: RAISE FND_API.g_exc_error;
662: WHEN OTHERS THEN
663: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');

Line 667: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

663: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
664: fnd_message.set_token('ROUTINE', 'DPP_BUSINESSEVENTS_PVT');
665: fnd_message.set_token('ERRNO', sqlcode);
666: fnd_message.set_token('REASON', sqlerrm);
667: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
668: FND_MESSAGE.set_name('DPP', 'DPP_BUSEVT_INVALID_EXE_DET_ID'); --To be modified
669: fnd_message.set_token('SEQ_NAME', 'DPP_EXECUTION_DETAIL_ID_SEQ'); --To be modified
670: FND_MSG_PUB.add;
671: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);

Line 670: FND_MSG_PUB.add;

666: fnd_message.set_token('REASON', sqlerrm);
667: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
668: FND_MESSAGE.set_name('DPP', 'DPP_BUSEVT_INVALID_EXE_DET_ID'); --To be modified
669: fnd_message.set_token('SEQ_NAME', 'DPP_EXECUTION_DETAIL_ID_SEQ'); --To be modified
670: FND_MSG_PUB.add;
671: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
672: END IF;
673: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
674: END;

Line 671: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);

667: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
668: FND_MESSAGE.set_name('DPP', 'DPP_BUSEVT_INVALID_EXE_DET_ID'); --To be modified
669: fnd_message.set_token('SEQ_NAME', 'DPP_EXECUTION_DETAIL_ID_SEQ'); --To be modified
670: FND_MSG_PUB.add;
671: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
672: END IF;
673: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
674: END;
675:

Line 750: FND_MSG_PUB.add;

746: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
747: fnd_message.set_token('ROUTINE', 'DPP_COVEREDINVENTORY_PVT.Update_CoveredInventory - Delete rows');
748: fnd_message.set_token('ERRNO', sqlcode);
749: fnd_message.set_token('REASON', sqlerrm);
750: FND_MSG_PUB.add;
751: END IF;
752: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
753: END;
754: --Insert child records if covered quantity <> 0

Line 888: FND_MSG_PUB.Count_And_Get

884:
885: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, 'Private API: ' || l_api_name || 'end');
886:
887: -- Standard call to get message count and if count is 1, get message info.
888: FND_MSG_PUB.Count_And_Get
889: (p_count => x_msg_count,
890: p_data => x_msg_data
891: );
892:

Line 899: FND_MSG_PUB.Count_And_Get (

895: WHEN DPP_UTILITY_PVT.resource_locked THEN
896: ROLLBACK TO Update_CoveredInventory_PVT;
897: x_return_status := FND_API.g_ret_sts_error;
898: DPP_UTILITY_PVT.Error_Message(p_message_name => 'API_RESOURCE_LOCKED');
899: FND_MSG_PUB.Count_And_Get (
900: p_encoded => FND_API.G_FALSE,
901: p_count => x_msg_count,
902: p_data => x_msg_data
903: );

Line 906: x_msg_data := SUBSTR((x_msg_data||' '|| FND_MSG_PUB.GET(P_MSG_INDEX => I, P_ENCODED => 'F')), 1, 4000);

902: p_data => x_msg_data
903: );
904: IF x_msg_count > 1 THEN
905: FOR I IN 1..x_msg_count LOOP
906: x_msg_data := SUBSTR((x_msg_data||' '|| FND_MSG_PUB.GET(P_MSG_INDEX => I, P_ENCODED => 'F')), 1, 4000);
907: END LOOP;
908: END IF;
909:
910: WHEN FND_API.G_EXC_ERROR THEN

Line 914: FND_MSG_PUB.Count_And_Get (

910: WHEN FND_API.G_EXC_ERROR THEN
911: ROLLBACK TO Update_CoveredInventory_PVT;
912: x_return_status := FND_API.G_RET_STS_ERROR;
913: -- Standard call to get message count and if count=1, get the message
914: FND_MSG_PUB.Count_And_Get (
915: p_encoded => FND_API.G_FALSE,
916: p_count => x_msg_count,
917: p_data => x_msg_data
918: );

Line 921: x_msg_data := SUBSTR((x_msg_data||' '|| FND_MSG_PUB.GET(P_MSG_INDEX => I, P_ENCODED => 'F')), 1, 4000);

917: p_data => x_msg_data
918: );
919: IF x_msg_count > 1 THEN
920: FOR I IN 1..x_msg_count LOOP
921: x_msg_data := SUBSTR((x_msg_data||' '|| FND_MSG_PUB.GET(P_MSG_INDEX => I, P_ENCODED => 'F')), 1, 4000);
922: END LOOP;
923: END IF;
924:
925: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 929: FND_MSG_PUB.Count_And_Get (

925: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
926: ROLLBACK TO Update_CoveredInventory_PVT;
927: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
928: -- Standard call to get message count and if count=1, get the message
929: FND_MSG_PUB.Count_And_Get (
930: p_encoded => FND_API.G_FALSE,
931: p_count => x_msg_count,
932: p_data => x_msg_data
933: );

Line 936: x_msg_data := SUBSTR((x_msg_data||' '|| FND_MSG_PUB.GET(P_MSG_INDEX => I, P_ENCODED => 'F')), 1, 4000);

932: p_data => x_msg_data
933: );
934: IF x_msg_count > 1 THEN
935: FOR I IN 1..x_msg_count LOOP
936: x_msg_data := SUBSTR((x_msg_data||' '|| FND_MSG_PUB.GET(P_MSG_INDEX => I, P_ENCODED => 'F')), 1, 4000);
937: END LOOP;
938: END IF;
939:
940: WHEN OTHERS THEN

Line 947: FND_MSG_PUB.add;

943: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
944: fnd_message.set_token('ROUTINE', 'DPP_COVEREDINVENTORY_PVT.Update_CoveredInventory');
945: fnd_message.set_token('ERRNO', sqlcode);
946: fnd_message.set_token('REASON', sqlerrm);
947: FND_MSG_PUB.add;
948: -- Standard call to get message count and if count=1, get the message
949: FND_MSG_PUB.Count_And_Get (
950: p_encoded => FND_API.G_FALSE,
951: p_count => x_msg_count,

Line 949: FND_MSG_PUB.Count_And_Get (

945: fnd_message.set_token('ERRNO', sqlcode);
946: fnd_message.set_token('REASON', sqlerrm);
947: FND_MSG_PUB.add;
948: -- Standard call to get message count and if count=1, get the message
949: FND_MSG_PUB.Count_And_Get (
950: p_encoded => FND_API.G_FALSE,
951: p_count => x_msg_count,
952: p_data => x_msg_data
953: );

Line 956: x_msg_data := SUBSTR((x_msg_data||' '|| FND_MSG_PUB.GET(P_MSG_INDEX => I, P_ENCODED => 'F')), 1, 4000);

952: p_data => x_msg_data
953: );
954: IF x_msg_count > 1 THEN
955: FOR I IN 1..x_msg_count LOOP
956: x_msg_data := SUBSTR((x_msg_data||' '|| FND_MSG_PUB.GET(P_MSG_INDEX => I, P_ENCODED => 'F')), 1, 4000);
957: END LOOP;
958: END IF;
959:
960: