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_LISTPRICE_PVT dependencies on FND_MESSAGE

Line 113: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');

109: --
110: -- API body
111: --
112: IF l_txn_hdr_rec.org_id IS NULL THEN
113: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');
114: FND_MESSAGE.set_token('ID', 'Org ID');
115: FND_MSG_PUB.add;
116: RAISE FND_API.G_EXC_ERROR;
117: ELSIF l_txn_hdr_rec.Transaction_Number IS NULL THEN

Line 114: FND_MESSAGE.set_token('ID', 'Org ID');

110: -- API body
111: --
112: IF l_txn_hdr_rec.org_id IS NULL THEN
113: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');
114: FND_MESSAGE.set_token('ID', 'Org ID');
115: FND_MSG_PUB.add;
116: RAISE FND_API.G_EXC_ERROR;
117: ELSIF l_txn_hdr_rec.Transaction_Number IS NULL THEN
118: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');

Line 118: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');

114: FND_MESSAGE.set_token('ID', 'Org ID');
115: FND_MSG_PUB.add;
116: RAISE FND_API.G_EXC_ERROR;
117: ELSIF l_txn_hdr_rec.Transaction_Number IS NULL THEN
118: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');
119: FND_MESSAGE.set_token('ID', 'Transaction Number');
120: FND_MSG_PUB.add;
121: RAISE FND_API.G_EXC_ERROR;
122: ELSIF l_txn_hdr_rec.Transaction_Header_ID IS NULL THEN

Line 119: FND_MESSAGE.set_token('ID', 'Transaction Number');

115: FND_MSG_PUB.add;
116: RAISE FND_API.G_EXC_ERROR;
117: ELSIF l_txn_hdr_rec.Transaction_Number IS NULL THEN
118: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');
119: FND_MESSAGE.set_token('ID', 'Transaction Number');
120: FND_MSG_PUB.add;
121: RAISE FND_API.G_EXC_ERROR;
122: ELSIF l_txn_hdr_rec.Transaction_Header_ID IS NULL THEN
123: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');

Line 123: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');

119: FND_MESSAGE.set_token('ID', 'Transaction Number');
120: FND_MSG_PUB.add;
121: RAISE FND_API.G_EXC_ERROR;
122: ELSIF l_txn_hdr_rec.Transaction_Header_ID IS NULL THEN
123: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');
124: FND_MESSAGE.set_token('ID', 'Transaction Header ID');
125: FND_MSG_PUB.add;
126: RAISE FND_API.G_EXC_ERROR;
127: END IF;

Line 124: FND_MESSAGE.set_token('ID', 'Transaction Header ID');

120: FND_MSG_PUB.add;
121: RAISE FND_API.G_EXC_ERROR;
122: ELSIF l_txn_hdr_rec.Transaction_Header_ID IS NULL THEN
123: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');
124: FND_MESSAGE.set_token('ID', 'Transaction Header ID');
125: FND_MSG_PUB.add;
126: RAISE FND_API.G_EXC_ERROR;
127: END IF;
128: --Assign

Line 142: FND_MESSAGE.set_name('DPP', 'DPP_INVALID_CONTROL_LEVEL');

138: AND miaaiv.attribute_name = miav.attribute_name
139: AND miaaiv.attribute_name = 'MTL_SYSTEM_ITEMS.LIST_PRICE_PER_UNIT';
140: EXCEPTION
141: WHEN NO_DATA_FOUND THEN --
142: FND_MESSAGE.set_name('DPP', 'DPP_INVALID_CONTROL_LEVEL');
143: FND_MSG_PUB.add;
144: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
145: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
146: END IF;

Line 149: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');

145: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
146: END IF;
147: RAISE FND_API.G_EXC_ERROR;
148: WHEN OTHERS THEN
149: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
150: fnd_message.set_token('ROUTINE', 'DPP_LISTPRICE_PVT');
151: fnd_message.set_token('ERRNO', sqlcode);
152: fnd_message.set_token('REASON', sqlerrm);
153: FND_MSG_PUB.add;

Line 150: fnd_message.set_token('ROUTINE', 'DPP_LISTPRICE_PVT');

146: END IF;
147: RAISE FND_API.G_EXC_ERROR;
148: WHEN OTHERS THEN
149: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
150: fnd_message.set_token('ROUTINE', 'DPP_LISTPRICE_PVT');
151: fnd_message.set_token('ERRNO', sqlcode);
152: fnd_message.set_token('REASON', sqlerrm);
153: FND_MSG_PUB.add;
154: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 151: fnd_message.set_token('ERRNO', sqlcode);

147: RAISE FND_API.G_EXC_ERROR;
148: WHEN OTHERS THEN
149: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
150: fnd_message.set_token('ROUTINE', 'DPP_LISTPRICE_PVT');
151: fnd_message.set_token('ERRNO', sqlcode);
152: fnd_message.set_token('REASON', sqlerrm);
153: FND_MSG_PUB.add;
154: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
155: END;

Line 152: fnd_message.set_token('REASON', sqlerrm);

148: WHEN OTHERS THEN
149: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
150: fnd_message.set_token('ROUTINE', 'DPP_LISTPRICE_PVT');
151: fnd_message.set_token('ERRNO', sqlcode);
152: fnd_message.set_token('REASON', sqlerrm);
153: FND_MSG_PUB.add;
154: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
155: END;
156: IF l_item_cost_tbl.EXISTS(1) THEN

Line 175: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');

171: RAISE FND_API.G_EXC_ERROR;
172: END IF;
173:
174: IF l_item_cost_tbl(i).inventory_item_id IS NULL THEN
175: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');
176: FND_MESSAGE.set_token('ID', 'Inventory Item ID');
177: FND_MSG_PUB.add;
178: RAISE FND_API.G_EXC_ERROR;
179: END IF;

Line 176: FND_MESSAGE.set_token('ID', 'Inventory Item ID');

172: END IF;
173:
174: IF l_item_cost_tbl(i).inventory_item_id IS NULL THEN
175: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');
176: FND_MESSAGE.set_token('ID', 'Inventory Item ID');
177: FND_MSG_PUB.add;
178: RAISE FND_API.G_EXC_ERROR;
179: END IF;
180: l_count := 0;

Line 233: SELECT fnd_message.get_string('DPP','DPP_INVALID_ITEM')

229: --Check if the item belongs to that inventory organization
230: IF l_count = 0 THEN
231: l_item_cost_tbl(i).update_status := 'N';
232: l_return_status := FND_API.G_RET_STS_ERROR;
233: SELECT fnd_message.get_string('DPP','DPP_INVALID_ITEM')
234: INTO l_reason
235: FROM dual;
236:
237: SELECT DISTINCT(concatenated_segments)

Line 258: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');

254: l_status_Update_tbl(i).transaction_line_id := l_item_cost_tbl(i).transaction_line_id;
255: l_status_Update_tbl(i).update_status := l_item_cost_tbl(i).update_status;
256: END LOOP;
257: ELSE
258: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');
259: FND_MESSAGE.set_token('ID', 'Line Details');
260: FND_MSG_PUB.add;
261: RAISE FND_API.G_EXC_ERROR;
262: END IF;

Line 259: FND_MESSAGE.set_token('ID', 'Line Details');

255: l_status_Update_tbl(i).update_status := l_item_cost_tbl(i).update_status;
256: END LOOP;
257: ELSE
258: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');
259: FND_MESSAGE.set_token('ID', 'Line Details');
260: FND_MSG_PUB.add;
261: RAISE FND_API.G_EXC_ERROR;
262: END IF;
263:

Line 284: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');

280: dbms_xmlquery.closeContext(l_queryCtx);
281: EXCEPTION
282: WHEN OTHERS THEN
283: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
284: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
285: fnd_message.set_token('ROUTINE', 'DPP_LISTPRICE_PVT.Update_ListPrice');
286: fnd_message.set_token('ERRNO', sqlcode);
287: fnd_message.set_token('REASON', sqlerrm);
288: fnd_msg_pub.add;

Line 285: fnd_message.set_token('ROUTINE', 'DPP_LISTPRICE_PVT.Update_ListPrice');

281: EXCEPTION
282: WHEN OTHERS THEN
283: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
284: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
285: fnd_message.set_token('ROUTINE', 'DPP_LISTPRICE_PVT.Update_ListPrice');
286: fnd_message.set_token('ERRNO', sqlcode);
287: fnd_message.set_token('REASON', sqlerrm);
288: fnd_msg_pub.add;
289: END;

Line 286: fnd_message.set_token('ERRNO', sqlcode);

282: WHEN OTHERS THEN
283: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
284: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
285: fnd_message.set_token('ROUTINE', 'DPP_LISTPRICE_PVT.Update_ListPrice');
286: fnd_message.set_token('ERRNO', sqlcode);
287: fnd_message.set_token('REASON', sqlerrm);
288: fnd_msg_pub.add;
289: END;
290: IF x_return_status NOT IN (FND_API.G_RET_STS_ERROR, FND_API.G_RET_STS_UNEXP_ERROR) THEN

Line 287: fnd_message.set_token('REASON', sqlerrm);

283: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
284: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
285: fnd_message.set_token('ROUTINE', 'DPP_LISTPRICE_PVT.Update_ListPrice');
286: fnd_message.set_token('ERRNO', sqlcode);
287: fnd_message.set_token('REASON', sqlerrm);
288: fnd_msg_pub.add;
289: END;
290: IF x_return_status NOT IN (FND_API.G_RET_STS_ERROR, FND_API.G_RET_STS_UNEXP_ERROR) THEN
291: x_return_status := l_return_status;

Line 331: FND_MESSAGE.set_name('DPP', 'DPP_UPDATE_ITEM_ERR');

327: COMMIT WORK;
328: END IF;
329:
330: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
331: FND_MESSAGE.set_name('DPP', 'DPP_UPDATE_ITEM_ERR');
332: x_msg_data := fnd_message.get();
333: END IF;
334:
335: -- Debug Message

Line 332: x_msg_data := fnd_message.get();

328: END IF;
329:
330: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
331: FND_MESSAGE.set_name('DPP', 'DPP_UPDATE_ITEM_ERR');
332: x_msg_data := fnd_message.get();
333: END IF;
334:
335: -- Debug Message
336: IF g_debug THEN

Line 402: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');

398:
399: WHEN OTHERS THEN
400: ROLLBACK TO UPDATE_LISTPRICE_PVT;
401: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
402: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
403: fnd_message.set_token('ROUTINE', l_full_name);
404: fnd_message.set_token('ERRNO', sqlcode);
405: fnd_message.set_token('REASON', sqlerrm);
406: fnd_msg_pub.add;

Line 403: fnd_message.set_token('ROUTINE', l_full_name);

399: WHEN OTHERS THEN
400: ROLLBACK TO UPDATE_LISTPRICE_PVT;
401: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
402: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
403: fnd_message.set_token('ROUTINE', l_full_name);
404: fnd_message.set_token('ERRNO', sqlcode);
405: fnd_message.set_token('REASON', sqlerrm);
406: fnd_msg_pub.add;
407: -- Standard call to get message count and if count=1, get the message

Line 404: fnd_message.set_token('ERRNO', sqlcode);

400: ROLLBACK TO UPDATE_LISTPRICE_PVT;
401: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
402: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
403: fnd_message.set_token('ROUTINE', l_full_name);
404: fnd_message.set_token('ERRNO', sqlcode);
405: fnd_message.set_token('REASON', sqlerrm);
406: fnd_msg_pub.add;
407: -- Standard call to get message count and if count=1, get the message
408: FND_MSG_PUB.Count_And_Get (

Line 405: fnd_message.set_token('REASON', sqlerrm);

401: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
402: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
403: fnd_message.set_token('ROUTINE', l_full_name);
404: fnd_message.set_token('ERRNO', sqlcode);
405: fnd_message.set_token('REASON', sqlerrm);
406: fnd_msg_pub.add;
407: -- Standard call to get message count and if count=1, get the message
408: FND_MSG_PUB.Count_And_Get (
409: p_encoded => FND_API.G_FALSE,