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

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

6: -- NOTE :
7: -- End of Comments
8:
9: G_PKG_NAME CONSTANT VARCHAR2(30) := 'DPP_ITEMCOST_PVT';
10: G_DEBUG BOOLEAN := FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_high);
11: G_FILE_NAME CONSTANT VARCHAR2(14) := 'dppvcstb.pls';
12: ---------------------------------------------------------------------
13: -- PROCEDURE
14: -- Update_ItemCost

Line 83: FND_MSG_PUB.add;

79: when others then
80: Fnd_Message.Set_Name('FND', 'CP-Generic oracle error');
81: Fnd_Message.Set_Token('ERROR', substr(SQLERRM, 1, 80), FALSE);
82: Fnd_Message.Set_Token('ROUTINE','DPP_ITEMCOST_PVT.wait_for_rec_processing', FALSE);
83: FND_MSG_PUB.add;
84: return FALSE;
85: end wait_for_rec_processing;
86:
87: PROCEDURE Update_ItemCost

Line 228: FND_MSG_PUB.initialize;

224: END IF;
225:
226: -- Initialize message list if p_init_msg_list is set to TRUE.
227: IF FND_API.to_Boolean( p_init_msg_list ) THEN
228: FND_MSG_PUB.initialize;
229: END IF;
230:
231: -- Debug Message
232: IF g_debug THEN

Line 246: FND_MSG_PUB.add;

242: -- check for mandatory input parameters --
243: IF l_txn_hdr_rec.org_id IS NULL THEN
244: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');
245: FND_MESSAGE.set_token('ID', 'Org ID');
246: FND_MSG_PUB.add;
247: RAISE FND_API.G_EXC_ERROR;
248: ELSIF l_txn_hdr_rec.last_updated_by IS NULL THEN
249: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');
250: FND_MESSAGE.set_token('ID', 'User ID - Last_Updated_By');

Line 251: FND_MSG_PUB.add;

247: RAISE FND_API.G_EXC_ERROR;
248: ELSIF l_txn_hdr_rec.last_updated_by IS NULL THEN
249: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');
250: FND_MESSAGE.set_token('ID', 'User ID - Last_Updated_By');
251: FND_MSG_PUB.add;
252: RAISE FND_API.G_EXC_ERROR;
253: ELSIF l_txn_hdr_rec.cost_adjustment_account IS NULL THEN
254: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');
255: FND_MESSAGE.set_token('ID', 'Cost Adjustment Account');

Line 256: FND_MSG_PUB.add;

252: RAISE FND_API.G_EXC_ERROR;
253: ELSIF l_txn_hdr_rec.cost_adjustment_account IS NULL THEN
254: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');
255: FND_MESSAGE.set_token('ID', 'Cost Adjustment Account');
256: FND_MSG_PUB.add;
257: RAISE FND_API.G_EXC_ERROR;
258: ELSIF l_txn_hdr_rec.transaction_header_id IS NULL THEN
259: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');
260: FND_MESSAGE.set_token('ID', 'Transaction Header ID');

Line 261: FND_MSG_PUB.add;

257: RAISE FND_API.G_EXC_ERROR;
258: ELSIF l_txn_hdr_rec.transaction_header_id IS NULL THEN
259: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');
260: FND_MESSAGE.set_token('ID', 'Transaction Header ID');
261: FND_MSG_PUB.add;
262: RAISE FND_API.G_EXC_ERROR;
263: ELSIF l_txn_hdr_rec.execution_detail_id IS NULL THEN
264: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');
265: FND_MESSAGE.set_token('ID', 'Execution Detail ID');

Line 266: FND_MSG_PUB.add;

262: RAISE FND_API.G_EXC_ERROR;
263: ELSIF l_txn_hdr_rec.execution_detail_id IS NULL THEN
264: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');
265: FND_MESSAGE.set_token('ID', 'Execution Detail ID');
266: FND_MSG_PUB.add;
267: RAISE FND_API.G_EXC_ERROR;
268: ELSIF l_txn_hdr_rec.transaction_number IS NULL THEN
269: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');
270: FND_MESSAGE.set_token('ID', 'Transaction Number');

Line 271: FND_MSG_PUB.add;

267: RAISE FND_API.G_EXC_ERROR;
268: ELSIF l_txn_hdr_rec.transaction_number IS NULL THEN
269: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');
270: FND_MESSAGE.set_token('ID', 'Transaction Number');
271: FND_MSG_PUB.add;
272: RAISE FND_API.G_EXC_ERROR;
273: END IF;
274:
275: IF G_DEBUG THEN

Line 296: FND_MSG_PUB.add;

292: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
293: fnd_message.set_token('ROUTINE', 'DPP_ITEMCOST_PVT');
294: fnd_message.set_token('ERRNO', sqlcode);
295: fnd_message.set_token('REASON', sqlerrm);
296: FND_MSG_PUB.add;
297: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
298: END;
299:
300: --Getting a valid Price Protection Responsibility at the User Level Profile Options

Line 373: FND_MSG_PUB.add;

369: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
370: fnd_message.set_token('ROUTINE', 'DPP_ITEMCOST_PVT');
371: fnd_message.set_token('ERRNO', sqlcode);
372: fnd_message.set_token('REASON', sqlerrm);
373: FND_MSG_PUB.add;
374: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
375: END;
376: WHEN OTHERS THEN
377: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');

Line 381: FND_MSG_PUB.add;

377: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
378: fnd_message.set_token('ROUTINE', 'DPP_ITEMCOST_PVT');
379: fnd_message.set_token('ERRNO', sqlcode);
380: fnd_message.set_token('REASON', sqlerrm);
381: FND_MSG_PUB.add;
382: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
383: END;
384:
385: --Getting a valid Price Protection Responsibility at the Responsibility Level Profile Options

Line 458: FND_MSG_PUB.add;

454: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
455: fnd_message.set_token('ROUTINE', 'DPP_ITEMCOST_PVT');
456: fnd_message.set_token('ERRNO', sqlcode);
457: fnd_message.set_token('REASON', sqlerrm);
458: FND_MSG_PUB.add;
459: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
460: END;
461: WHEN OTHERS THEN
462: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');

Line 466: FND_MSG_PUB.add;

462: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
463: fnd_message.set_token('ROUTINE', 'DPP_ITEMCOST_PVT');
464: fnd_message.set_token('ERRNO', sqlcode);
465: fnd_message.set_token('REASON', sqlerrm);
466: FND_MSG_PUB.add;
467: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
468: END;
469: END IF;
470:

Line 544: FND_MSG_PUB.add;

540: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
541: fnd_message.set_token('ROUTINE', 'DPP_ITEMCOST_PVT');
542: fnd_message.set_token('ERRNO', sqlcode);
543: fnd_message.set_token('REASON', sqlerrm);
544: FND_MSG_PUB.add;
545: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
546: END;
547: WHEN OTHERS THEN
548: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');

Line 552: FND_MSG_PUB.add;

548: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
549: fnd_message.set_token('ROUTINE', 'DPP_ITEMCOST_PVT');
550: fnd_message.set_token('ERRNO', sqlcode);
551: fnd_message.set_token('REASON', sqlerrm);
552: FND_MSG_PUB.add;
553: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
554: END;
555: END IF;
556:

Line 631: FND_MSG_PUB.add;

627: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
628: fnd_message.set_token('ROUTINE', 'DPP_ITEMCOST_PVT');
629: fnd_message.set_token('ERRNO', sqlcode);
630: fnd_message.set_token('REASON', sqlerrm);
631: FND_MSG_PUB.add;
632: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
633: END;
634: WHEN OTHERS THEN
635: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');

Line 639: FND_MSG_PUB.add;

635: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
636: fnd_message.set_token('ROUTINE', 'DPP_ITEMCOST_PVT');
637: fnd_message.set_token('ERRNO', sqlcode);
638: fnd_message.set_token('REASON', sqlerrm);
639: FND_MSG_PUB.add;
640: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
641: END;
642: END IF;
643:

Line 648: FND_MSG_PUB.add;

644: --Check if the responsibility id is -1
645: IF l_responsibility_id = -1 THEN
646: FND_MESSAGE.set_name('DPP', 'DPP_INVALID_RESP');
647: FND_MESSAGE.set_token('USER', l_user_name);
648: FND_MSG_PUB.add;
649: IF g_debug THEN
650: DPP_UTILITY_PVT.debug_message('Price Protection responsibility not available for Last updated user'||l_user_name);
651: END IF;
652: RAISE FND_API.G_EXC_ERROR;

Line 1517: -- IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

1513:
1514: EXCEPTION
1515: WHEN OTHERS THEN
1516: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1517: -- IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1518: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1519: fnd_message.set_token('ROUTINE', 'DPP_ITEMCOST_PVT.Update_ItemCost-SLA Tables Insertion');
1520: fnd_message.set_token('ERRNO', sqlcode);
1521: fnd_message.set_token('REASON', sqlerrm);

Line 1522: FND_MSG_PUB.add;

1518: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1519: fnd_message.set_token('ROUTINE', 'DPP_ITEMCOST_PVT.Update_ItemCost-SLA Tables Insertion');
1520: fnd_message.set_token('ERRNO', sqlcode);
1521: fnd_message.set_token('REASON', sqlerrm);
1522: FND_MSG_PUB.add;
1523: -- END IF;
1524: DPP_UTILITY_PVT.debug_message('Error in SLA Tables Insertion:' || sqlerrm);
1525: END;
1526: END IF;

Line 1574: FND_MSG_PUB.add;

1570: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1571: fnd_message.set_token('ROUTINE', 'DPP_ITEMCOST_PVT.Update_ItemCost-XML Generation');
1572: fnd_message.set_token('ERRNO', sqlcode);
1573: fnd_message.set_token('REASON', sqlerrm);
1574: FND_MSG_PUB.add;
1575: END;
1576:
1577: IF g_debug THEN
1578: DPP_UTILITY_PVT.debug_message('Status before calling update API: ' || l_return_status);

Line 1622: FND_MSG_PUB.Count_And_Get

1618: DPP_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
1619: END IF;
1620:
1621: -- Standard call to get message count and if count is 1, get message info.
1622: FND_MSG_PUB.Count_And_Get
1623: (p_count => x_msg_count,
1624: p_data => x_msg_data
1625: );
1626: IF x_msg_count > 1 THEN

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

1624: p_data => x_msg_data
1625: );
1626: IF x_msg_count > 1 THEN
1627: FOR I IN 1..x_msg_count LOOP
1628: x_msg_data := SUBSTR((x_msg_data||' '|| FND_MSG_PUB.GET(P_MSG_INDEX => I, P_ENCODED => 'F')), 1, 4000);
1629: END LOOP;
1630: END IF;
1631: --Exception Handling
1632: EXCEPTION

Line 1637: FND_MSG_PUB.Count_And_Get (

1633:
1634: WHEN FND_API.G_EXC_ERROR THEN
1635: x_return_status := FND_API.G_RET_STS_ERROR;
1636: -- Standard call to get message count and if count=1, get the message
1637: FND_MSG_PUB.Count_And_Get (
1638: p_encoded => FND_API.G_FALSE,
1639: p_count => x_msg_count,
1640: p_data => x_msg_data
1641: );

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

1640: p_data => x_msg_data
1641: );
1642: IF x_msg_count > 1 THEN
1643: FOR I IN 1..x_msg_count LOOP
1644: x_msg_data := SUBSTR((x_msg_data||' '|| FND_MSG_PUB.GET(P_MSG_INDEX => I, P_ENCODED => 'F')), 1, 4000);
1645: END LOOP;
1646: END IF;
1647:
1648: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1652: FND_MSG_PUB.Count_And_Get (

1648: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1649: ROLLBACK TO UPDATE_ITEMCOST_PVT;
1650: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1651: -- Standard call to get message count and if count=1, get the message
1652: FND_MSG_PUB.Count_And_Get (
1653: p_encoded => FND_API.G_FALSE,
1654: p_count => x_msg_count,
1655: p_data => x_msg_data
1656: );

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

1655: p_data => x_msg_data
1656: );
1657: IF x_msg_count > 1 THEN
1658: FOR I IN 1..x_msg_count LOOP
1659: x_msg_data := SUBSTR((x_msg_data||' '|| FND_MSG_PUB.GET(P_MSG_INDEX => I, P_ENCODED => 'F')), 1, 4000);
1660: END LOOP;
1661: END IF;
1662:
1663: WHEN OTHERS THEN

Line 1670: FND_MSG_PUB.add;

1666: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1667: fnd_message.set_token('ROUTINE', 'DPP_ITEMCOST_PVT.Update_ItemCost');
1668: fnd_message.set_token('ERRNO', sqlcode);
1669: fnd_message.set_token('REASON', sqlerrm);
1670: FND_MSG_PUB.add;
1671:
1672: -- Standard call to get message count and if count=1, get the message
1673: FND_MSG_PUB.Count_And_Get (
1674: p_encoded => FND_API.G_FALSE,

Line 1673: FND_MSG_PUB.Count_And_Get (

1669: fnd_message.set_token('REASON', sqlerrm);
1670: FND_MSG_PUB.add;
1671:
1672: -- Standard call to get message count and if count=1, get the message
1673: FND_MSG_PUB.Count_And_Get (
1674: p_encoded => FND_API.G_FALSE,
1675: p_count => x_msg_count,
1676: p_data => x_msg_data
1677: );

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

1676: p_data => x_msg_data
1677: );
1678: IF x_msg_count > 1 THEN
1679: FOR I IN 1..x_msg_count LOOP
1680: x_msg_data := SUBSTR((x_msg_data||' '|| FND_MSG_PUB.GET(P_MSG_INDEX => I, P_ENCODED => 'F')), 1, 4000);
1681: END LOOP;
1682: END IF;
1683: END Update_ItemCost;
1684: