APPS.DPP_UIWRAPPER_PVT dependencies on FND_MESSAGE

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

23: WHEN OTHERS THEN
24: x_return_status := fnd_api.g_ret_sts_unexp_error;
25:
26: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
27: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
28: fnd_message.set_token('ROUTINE', 'DPP_UIWRAPPER_PVT.check_txnclose');
29: fnd_message.set_token('ERRNO', sqlcode);
30: fnd_message.set_token('REASON', sqlerrm);
31: FND_MSG_PUB.ADD;

Line 28: fnd_message.set_token('ROUTINE', 'DPP_UIWRAPPER_PVT.check_txnclose');

24: x_return_status := fnd_api.g_ret_sts_unexp_error;
25:
26: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
27: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
28: fnd_message.set_token('ROUTINE', 'DPP_UIWRAPPER_PVT.check_txnclose');
29: fnd_message.set_token('ERRNO', sqlcode);
30: fnd_message.set_token('REASON', sqlerrm);
31: FND_MSG_PUB.ADD;
32: END IF;

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

25:
26: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
27: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
28: fnd_message.set_token('ROUTINE', 'DPP_UIWRAPPER_PVT.check_txnclose');
29: fnd_message.set_token('ERRNO', sqlcode);
30: fnd_message.set_token('REASON', sqlerrm);
31: FND_MSG_PUB.ADD;
32: END IF;
33: END check_transaction;

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

26: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
27: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
28: fnd_message.set_token('ROUTINE', 'DPP_UIWRAPPER_PVT.check_txnclose');
29: fnd_message.set_token('ERRNO', sqlcode);
30: fnd_message.set_token('REASON', sqlerrm);
31: FND_MSG_PUB.ADD;
32: END IF;
33: END check_transaction;
34:

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

69: WHEN OTHERS THEN
70: x_return_status := fnd_api.g_ret_sts_unexp_error;
71:
72: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
73: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
74: fnd_message.set_token('ROUTINE', 'DPP_UIWRAPPER_PVT.search_vendors');
75: fnd_message.set_token('ERRNO', sqlcode);
76: fnd_message.set_token('REASON', sqlerrm);
77: FND_MSG_PUB.add;

Line 74: fnd_message.set_token('ROUTINE', 'DPP_UIWRAPPER_PVT.search_vendors');

70: x_return_status := fnd_api.g_ret_sts_unexp_error;
71:
72: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
73: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
74: fnd_message.set_token('ROUTINE', 'DPP_UIWRAPPER_PVT.search_vendors');
75: fnd_message.set_token('ERRNO', sqlcode);
76: fnd_message.set_token('REASON', sqlerrm);
77: FND_MSG_PUB.add;
78: END IF;

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

71:
72: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
73: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
74: fnd_message.set_token('ROUTINE', 'DPP_UIWRAPPER_PVT.search_vendors');
75: fnd_message.set_token('ERRNO', sqlcode);
76: fnd_message.set_token('REASON', sqlerrm);
77: FND_MSG_PUB.add;
78: END IF;
79: END search_vendors;

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

72: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
73: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
74: fnd_message.set_token('ROUTINE', 'DPP_UIWRAPPER_PVT.search_vendors');
75: fnd_message.set_token('ERRNO', sqlcode);
76: fnd_message.set_token('REASON', sqlerrm);
77: FND_MSG_PUB.add;
78: END IF;
79: END search_vendors;
80:

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

122: WHEN OTHERS THEN
123: x_return_status := fnd_api.g_ret_sts_unexp_error;
124:
125: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
126: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
127: fnd_message.set_token('ROUTINE', 'DPP_UIWRAPPER_PVT.search_vendor_sites');
128: fnd_message.set_token('ERRNO', sqlcode);
129: fnd_message.set_token('REASON', sqlerrm);
130: FND_MSG_PUB.add;

Line 127: fnd_message.set_token('ROUTINE', 'DPP_UIWRAPPER_PVT.search_vendor_sites');

123: x_return_status := fnd_api.g_ret_sts_unexp_error;
124:
125: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
126: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
127: fnd_message.set_token('ROUTINE', 'DPP_UIWRAPPER_PVT.search_vendor_sites');
128: fnd_message.set_token('ERRNO', sqlcode);
129: fnd_message.set_token('REASON', sqlerrm);
130: FND_MSG_PUB.add;
131: END IF;

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

124:
125: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
126: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
127: fnd_message.set_token('ROUTINE', 'DPP_UIWRAPPER_PVT.search_vendor_sites');
128: fnd_message.set_token('ERRNO', sqlcode);
129: fnd_message.set_token('REASON', sqlerrm);
130: FND_MSG_PUB.add;
131: END IF;
132: END search_vendor_sites;

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

125: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
126: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
127: fnd_message.set_token('ROUTINE', 'DPP_UIWRAPPER_PVT.search_vendor_sites');
128: fnd_message.set_token('ERRNO', sqlcode);
129: fnd_message.set_token('REASON', sqlerrm);
130: FND_MSG_PUB.add;
131: END IF;
132: END search_vendor_sites;
133:

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

171: WHEN OTHERS THEN
172: x_return_status := fnd_api.g_ret_sts_unexp_error;
173:
174: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
175: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
176: fnd_message.set_token('ROUTINE', 'DPP_UIWRAPPER_PVT.search_vendor_contacts');
177: fnd_message.set_token('ERRNO', sqlcode);
178: fnd_message.set_token('REASON', sqlerrm);
179: FND_MSG_PUB.add;

Line 176: fnd_message.set_token('ROUTINE', 'DPP_UIWRAPPER_PVT.search_vendor_contacts');

172: x_return_status := fnd_api.g_ret_sts_unexp_error;
173:
174: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
175: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
176: fnd_message.set_token('ROUTINE', 'DPP_UIWRAPPER_PVT.search_vendor_contacts');
177: fnd_message.set_token('ERRNO', sqlcode);
178: fnd_message.set_token('REASON', sqlerrm);
179: FND_MSG_PUB.add;
180: END IF;

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

173:
174: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
175: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
176: fnd_message.set_token('ROUTINE', 'DPP_UIWRAPPER_PVT.search_vendor_contacts');
177: fnd_message.set_token('ERRNO', sqlcode);
178: fnd_message.set_token('REASON', sqlerrm);
179: FND_MSG_PUB.add;
180: END IF;
181: END search_vendor_contacts;

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

174: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
175: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
176: fnd_message.set_token('ROUTINE', 'DPP_UIWRAPPER_PVT.search_vendor_contacts');
177: fnd_message.set_token('ERRNO', sqlcode);
178: fnd_message.set_token('REASON', sqlerrm);
179: FND_MSG_PUB.add;
180: END IF;
181: END search_vendor_contacts;
182:

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

218: WHEN OTHERS THEN
219: x_return_status := fnd_api.g_ret_sts_unexp_error;
220:
221: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
222: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
223: fnd_message.set_token('ROUTINE', 'DPP_UIWRAPPER_PVT.search_items');
224: fnd_message.set_token('ERRNO', sqlcode);
225: fnd_message.set_token('REASON', sqlerrm);
226: FND_MSG_PUB.add;

Line 223: fnd_message.set_token('ROUTINE', 'DPP_UIWRAPPER_PVT.search_items');

219: x_return_status := fnd_api.g_ret_sts_unexp_error;
220:
221: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
222: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
223: fnd_message.set_token('ROUTINE', 'DPP_UIWRAPPER_PVT.search_items');
224: fnd_message.set_token('ERRNO', sqlcode);
225: fnd_message.set_token('REASON', sqlerrm);
226: FND_MSG_PUB.add;
227: END IF;

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

220:
221: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
222: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
223: fnd_message.set_token('ROUTINE', 'DPP_UIWRAPPER_PVT.search_items');
224: fnd_message.set_token('ERRNO', sqlcode);
225: fnd_message.set_token('REASON', sqlerrm);
226: FND_MSG_PUB.add;
227: END IF;
228: END search_items;

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

221: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
222: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
223: fnd_message.set_token('ROUTINE', 'DPP_UIWRAPPER_PVT.search_items');
224: fnd_message.set_token('ERRNO', sqlcode);
225: fnd_message.set_token('REASON', sqlerrm);
226: FND_MSG_PUB.add;
227: END IF;
228: END search_items;
229:

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

264: WHEN OTHERS THEN
265: x_return_status := fnd_api.g_ret_sts_unexp_error;
266:
267: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
268: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
269: fnd_message.set_token('ROUTINE', 'DPP_UIWRAPPER_PVT.search_customer_items');
270: fnd_message.set_token('ERRNO', sqlcode);
271: fnd_message.set_token('REASON', sqlerrm);
272: FND_MSG_PUB.add;

Line 269: fnd_message.set_token('ROUTINE', 'DPP_UIWRAPPER_PVT.search_customer_items');

265: x_return_status := fnd_api.g_ret_sts_unexp_error;
266:
267: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
268: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
269: fnd_message.set_token('ROUTINE', 'DPP_UIWRAPPER_PVT.search_customer_items');
270: fnd_message.set_token('ERRNO', sqlcode);
271: fnd_message.set_token('REASON', sqlerrm);
272: FND_MSG_PUB.add;
273: END IF;

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

266:
267: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
268: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
269: fnd_message.set_token('ROUTINE', 'DPP_UIWRAPPER_PVT.search_customer_items');
270: fnd_message.set_token('ERRNO', sqlcode);
271: fnd_message.set_token('REASON', sqlerrm);
272: FND_MSG_PUB.add;
273: END IF;
274: END search_customer_items;

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

267: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
268: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
269: fnd_message.set_token('ROUTINE', 'DPP_UIWRAPPER_PVT.search_customer_items');
270: fnd_message.set_token('ERRNO', sqlcode);
271: fnd_message.set_token('REASON', sqlerrm);
272: FND_MSG_PUB.add;
273: END IF;
274: END search_customer_items;
275:

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

310: WHEN OTHERS THEN
311: x_return_status := fnd_api.g_ret_sts_unexp_error;
312:
313: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
314: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
315: fnd_message.set_token('ROUTINE', 'DPP_UIWRAPPER_PVT.search_warehouses');
316: fnd_message.set_token('ERRNO', sqlcode);
317: fnd_message.set_token('REASON', sqlerrm);
318: FND_MSG_PUB.add;

Line 315: fnd_message.set_token('ROUTINE', 'DPP_UIWRAPPER_PVT.search_warehouses');

311: x_return_status := fnd_api.g_ret_sts_unexp_error;
312:
313: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
314: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
315: fnd_message.set_token('ROUTINE', 'DPP_UIWRAPPER_PVT.search_warehouses');
316: fnd_message.set_token('ERRNO', sqlcode);
317: fnd_message.set_token('REASON', sqlerrm);
318: FND_MSG_PUB.add;
319: END IF;

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

312:
313: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
314: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
315: fnd_message.set_token('ROUTINE', 'DPP_UIWRAPPER_PVT.search_warehouses');
316: fnd_message.set_token('ERRNO', sqlcode);
317: fnd_message.set_token('REASON', sqlerrm);
318: FND_MSG_PUB.add;
319: END IF;
320: END search_warehouses;

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

313: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
314: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
315: fnd_message.set_token('ROUTINE', 'DPP_UIWRAPPER_PVT.search_warehouses');
316: fnd_message.set_token('ERRNO', sqlcode);
317: fnd_message.set_token('REASON', sqlerrm);
318: FND_MSG_PUB.add;
319: END IF;
320: END search_warehouses;
321:

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

361: WHEN OTHERS THEN
362: x_return_status := fnd_api.g_ret_sts_unexp_error;
363:
364: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
365: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
366: fnd_message.set_token('ROUTINE', 'DPP_UIWRAPPER_PVT.Get_InventoryDetails');
367: fnd_message.set_token('ERRNO', sqlcode);
368: fnd_message.set_token('REASON', sqlerrm);
369: FND_MSG_PUB.add;

Line 366: fnd_message.set_token('ROUTINE', 'DPP_UIWRAPPER_PVT.Get_InventoryDetails');

362: x_return_status := fnd_api.g_ret_sts_unexp_error;
363:
364: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
365: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
366: fnd_message.set_token('ROUTINE', 'DPP_UIWRAPPER_PVT.Get_InventoryDetails');
367: fnd_message.set_token('ERRNO', sqlcode);
368: fnd_message.set_token('REASON', sqlerrm);
369: FND_MSG_PUB.add;
370: END IF;

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

363:
364: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
365: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
366: fnd_message.set_token('ROUTINE', 'DPP_UIWRAPPER_PVT.Get_InventoryDetails');
367: fnd_message.set_token('ERRNO', sqlcode);
368: fnd_message.set_token('REASON', sqlerrm);
369: FND_MSG_PUB.add;
370: END IF;
371: END Get_InventoryDetails;

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

364: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
365: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
366: fnd_message.set_token('ROUTINE', 'DPP_UIWRAPPER_PVT.Get_InventoryDetails');
367: fnd_message.set_token('ERRNO', sqlcode);
368: fnd_message.set_token('REASON', sqlerrm);
369: FND_MSG_PUB.add;
370: END IF;
371: END Get_InventoryDetails;
372:

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

410: WHEN OTHERS THEN
411: x_return_status := fnd_api.g_ret_sts_unexp_error;
412:
413: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
414: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
415: fnd_message.set_token('ROUTINE', 'DPP_UIWRAPPER_PVT.Get_CustomerInventory');
416: fnd_message.set_token('ERRNO', sqlcode);
417: fnd_message.set_token('REASON', sqlerrm);
418: FND_MSG_PUB.add;

Line 415: fnd_message.set_token('ROUTINE', 'DPP_UIWRAPPER_PVT.Get_CustomerInventory');

411: x_return_status := fnd_api.g_ret_sts_unexp_error;
412:
413: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
414: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
415: fnd_message.set_token('ROUTINE', 'DPP_UIWRAPPER_PVT.Get_CustomerInventory');
416: fnd_message.set_token('ERRNO', sqlcode);
417: fnd_message.set_token('REASON', sqlerrm);
418: FND_MSG_PUB.add;
419: END IF;

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

412:
413: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
414: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
415: fnd_message.set_token('ROUTINE', 'DPP_UIWRAPPER_PVT.Get_CustomerInventory');
416: fnd_message.set_token('ERRNO', sqlcode);
417: fnd_message.set_token('REASON', sqlerrm);
418: FND_MSG_PUB.add;
419: END IF;
420: END Get_CustomerInventory;

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

413: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
414: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
415: fnd_message.set_token('ROUTINE', 'DPP_UIWRAPPER_PVT.Get_CustomerInventory');
416: fnd_message.set_token('ERRNO', sqlcode);
417: fnd_message.set_token('REASON', sqlerrm);
418: FND_MSG_PUB.add;
419: END IF;
420: END Get_CustomerInventory;
421:

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

455: WHEN OTHERS THEN
456: x_return_status := fnd_api.g_ret_sts_unexp_error;
457:
458: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
459: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
460: fnd_message.set_token('ROUTINE', 'DPP_UIWRAPPER_PVT.search_customers');
461: fnd_message.set_token('ERRNO', sqlcode);
462: fnd_message.set_token('REASON', sqlerrm);
463: FND_MSG_PUB.add;

Line 460: fnd_message.set_token('ROUTINE', 'DPP_UIWRAPPER_PVT.search_customers');

456: x_return_status := fnd_api.g_ret_sts_unexp_error;
457:
458: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
459: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
460: fnd_message.set_token('ROUTINE', 'DPP_UIWRAPPER_PVT.search_customers');
461: fnd_message.set_token('ERRNO', sqlcode);
462: fnd_message.set_token('REASON', sqlerrm);
463: FND_MSG_PUB.add;
464: END IF;

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

457:
458: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
459: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
460: fnd_message.set_token('ROUTINE', 'DPP_UIWRAPPER_PVT.search_customers');
461: fnd_message.set_token('ERRNO', sqlcode);
462: fnd_message.set_token('REASON', sqlerrm);
463: FND_MSG_PUB.add;
464: END IF;
465: END search_customers;

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

458: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
459: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
460: fnd_message.set_token('ROUTINE', 'DPP_UIWRAPPER_PVT.search_customers');
461: fnd_message.set_token('ERRNO', sqlcode);
462: fnd_message.set_token('REASON', sqlerrm);
463: FND_MSG_PUB.add;
464: END IF;
465: END search_customers;
466:

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

508: WHEN OTHERS THEN
509: x_return_status := fnd_api.g_ret_sts_unexp_error;
510:
511: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
512: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
513: fnd_message.set_token('ROUTINE', 'DPP_UIWRAPPER_PVT.Get_LastPrice');
514: fnd_message.set_token('ERRNO', sqlcode);
515: fnd_message.set_token('REASON', sqlerrm);
516: FND_MSG_PUB.add;

Line 513: fnd_message.set_token('ROUTINE', 'DPP_UIWRAPPER_PVT.Get_LastPrice');

509: x_return_status := fnd_api.g_ret_sts_unexp_error;
510:
511: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
512: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
513: fnd_message.set_token('ROUTINE', 'DPP_UIWRAPPER_PVT.Get_LastPrice');
514: fnd_message.set_token('ERRNO', sqlcode);
515: fnd_message.set_token('REASON', sqlerrm);
516: FND_MSG_PUB.add;
517: END IF;

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

510:
511: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
512: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
513: fnd_message.set_token('ROUTINE', 'DPP_UIWRAPPER_PVT.Get_LastPrice');
514: fnd_message.set_token('ERRNO', sqlcode);
515: fnd_message.set_token('REASON', sqlerrm);
516: FND_MSG_PUB.add;
517: END IF;
518: END Get_LastPrice;

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

511: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
512: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
513: fnd_message.set_token('ROUTINE', 'DPP_UIWRAPPER_PVT.Get_LastPrice');
514: fnd_message.set_token('ERRNO', sqlcode);
515: fnd_message.set_token('REASON', sqlerrm);
516: FND_MSG_PUB.add;
517: END IF;
518: END Get_LastPrice;
519:

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

553: WHEN OTHERS THEN
554: x_return_status := fnd_api.g_ret_sts_unexp_error;
555:
556: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
557: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
558: fnd_message.set_token('ROUTINE', 'DPP_UIWRAPPER_PVT.Get_ListPrice');
559: fnd_message.set_token('ERRNO', sqlcode);
560: fnd_message.set_token('REASON', sqlerrm);
561: FND_MSG_PUB.add;

Line 558: fnd_message.set_token('ROUTINE', 'DPP_UIWRAPPER_PVT.Get_ListPrice');

554: x_return_status := fnd_api.g_ret_sts_unexp_error;
555:
556: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
557: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
558: fnd_message.set_token('ROUTINE', 'DPP_UIWRAPPER_PVT.Get_ListPrice');
559: fnd_message.set_token('ERRNO', sqlcode);
560: fnd_message.set_token('REASON', sqlerrm);
561: FND_MSG_PUB.add;
562: END IF;

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

555:
556: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
557: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
558: fnd_message.set_token('ROUTINE', 'DPP_UIWRAPPER_PVT.Get_ListPrice');
559: fnd_message.set_token('ERRNO', sqlcode);
560: fnd_message.set_token('REASON', sqlerrm);
561: FND_MSG_PUB.add;
562: END IF;
563: END Get_ListPrice;

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

556: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
557: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
558: fnd_message.set_token('ROUTINE', 'DPP_UIWRAPPER_PVT.Get_ListPrice');
559: fnd_message.set_token('ERRNO', sqlcode);
560: fnd_message.set_token('REASON', sqlerrm);
561: FND_MSG_PUB.add;
562: END IF;
563: END Get_ListPrice;
564:

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

585: WHEN OTHERS THEN
586: x_return_status := fnd_api.g_ret_sts_unexp_error;
587:
588: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
589: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
590: fnd_message.set_token('ROUTINE', 'DPP_UIWRAPPER_PVT.Get_Vendor');
591: fnd_message.set_token('ERRNO', sqlcode);
592: fnd_message.set_token('REASON', sqlerrm);
593: FND_MSG_PUB.add;

Line 590: fnd_message.set_token('ROUTINE', 'DPP_UIWRAPPER_PVT.Get_Vendor');

586: x_return_status := fnd_api.g_ret_sts_unexp_error;
587:
588: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
589: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
590: fnd_message.set_token('ROUTINE', 'DPP_UIWRAPPER_PVT.Get_Vendor');
591: fnd_message.set_token('ERRNO', sqlcode);
592: fnd_message.set_token('REASON', sqlerrm);
593: FND_MSG_PUB.add;
594: END IF;

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

587:
588: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
589: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
590: fnd_message.set_token('ROUTINE', 'DPP_UIWRAPPER_PVT.Get_Vendor');
591: fnd_message.set_token('ERRNO', sqlcode);
592: fnd_message.set_token('REASON', sqlerrm);
593: FND_MSG_PUB.add;
594: END IF;
595: END Get_Vendor;

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

588: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
589: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
590: fnd_message.set_token('ROUTINE', 'DPP_UIWRAPPER_PVT.Get_Vendor');
591: fnd_message.set_token('ERRNO', sqlcode);
592: fnd_message.set_token('REASON', sqlerrm);
593: FND_MSG_PUB.add;
594: END IF;
595: END Get_Vendor;
596:

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

625: WHEN OTHERS THEN
626: x_return_status := fnd_api.g_ret_sts_unexp_error;
627:
628: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
629: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
630: fnd_message.set_token('ROUTINE', 'DPP_UIWRAPPER_PVT.Get_Vendor_Site');
631: fnd_message.set_token('ERRNO', sqlcode);
632: fnd_message.set_token('REASON', sqlerrm);
633: FND_MSG_PUB.add;

Line 630: fnd_message.set_token('ROUTINE', 'DPP_UIWRAPPER_PVT.Get_Vendor_Site');

626: x_return_status := fnd_api.g_ret_sts_unexp_error;
627:
628: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
629: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
630: fnd_message.set_token('ROUTINE', 'DPP_UIWRAPPER_PVT.Get_Vendor_Site');
631: fnd_message.set_token('ERRNO', sqlcode);
632: fnd_message.set_token('REASON', sqlerrm);
633: FND_MSG_PUB.add;
634: END IF;

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

627:
628: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
629: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
630: fnd_message.set_token('ROUTINE', 'DPP_UIWRAPPER_PVT.Get_Vendor_Site');
631: fnd_message.set_token('ERRNO', sqlcode);
632: fnd_message.set_token('REASON', sqlerrm);
633: FND_MSG_PUB.add;
634: END IF;
635: END Get_Vendor_Site;

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

628: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
629: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
630: fnd_message.set_token('ROUTINE', 'DPP_UIWRAPPER_PVT.Get_Vendor_Site');
631: fnd_message.set_token('ERRNO', sqlcode);
632: fnd_message.set_token('REASON', sqlerrm);
633: FND_MSG_PUB.add;
634: END IF;
635: END Get_Vendor_Site;
636:

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

663: WHEN OTHERS THEN
664: x_return_status := fnd_api.g_ret_sts_unexp_error;
665:
666: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
667: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
668: fnd_message.set_token('ROUTINE', 'DPP_UIWRAPPER_PVT.Get_Vendor_Contact');
669: fnd_message.set_token('ERRNO', sqlcode);
670: fnd_message.set_token('REASON', sqlerrm);
671: FND_MSG_PUB.add;

Line 668: fnd_message.set_token('ROUTINE', 'DPP_UIWRAPPER_PVT.Get_Vendor_Contact');

664: x_return_status := fnd_api.g_ret_sts_unexp_error;
665:
666: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
667: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
668: fnd_message.set_token('ROUTINE', 'DPP_UIWRAPPER_PVT.Get_Vendor_Contact');
669: fnd_message.set_token('ERRNO', sqlcode);
670: fnd_message.set_token('REASON', sqlerrm);
671: FND_MSG_PUB.add;
672: END IF;

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

665:
666: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
667: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
668: fnd_message.set_token('ROUTINE', 'DPP_UIWRAPPER_PVT.Get_Vendor_Contact');
669: fnd_message.set_token('ERRNO', sqlcode);
670: fnd_message.set_token('REASON', sqlerrm);
671: FND_MSG_PUB.add;
672: END IF;
673: END Get_Vendor_Contact;

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

666: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
667: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
668: fnd_message.set_token('ROUTINE', 'DPP_UIWRAPPER_PVT.Get_Vendor_Contact');
669: fnd_message.set_token('ERRNO', sqlcode);
670: fnd_message.set_token('REASON', sqlerrm);
671: FND_MSG_PUB.add;
672: END IF;
673: END Get_Vendor_Contact;
674:

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

702: WHEN OTHERS THEN
703: x_return_status := fnd_api.g_ret_sts_unexp_error;
704:
705: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
706: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
707: fnd_message.set_token('ROUTINE', 'DPP_UIWRAPPER_PVT.Get_Warehouse');
708: fnd_message.set_token('ERRNO', sqlcode);
709: fnd_message.set_token('REASON', sqlerrm);
710: FND_MSG_PUB.add;

Line 707: fnd_message.set_token('ROUTINE', 'DPP_UIWRAPPER_PVT.Get_Warehouse');

703: x_return_status := fnd_api.g_ret_sts_unexp_error;
704:
705: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
706: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
707: fnd_message.set_token('ROUTINE', 'DPP_UIWRAPPER_PVT.Get_Warehouse');
708: fnd_message.set_token('ERRNO', sqlcode);
709: fnd_message.set_token('REASON', sqlerrm);
710: FND_MSG_PUB.add;
711: END IF;

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

704:
705: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
706: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
707: fnd_message.set_token('ROUTINE', 'DPP_UIWRAPPER_PVT.Get_Warehouse');
708: fnd_message.set_token('ERRNO', sqlcode);
709: fnd_message.set_token('REASON', sqlerrm);
710: FND_MSG_PUB.add;
711: END IF;
712: END Get_Warehouse;

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

705: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
706: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
707: fnd_message.set_token('ROUTINE', 'DPP_UIWRAPPER_PVT.Get_Warehouse');
708: fnd_message.set_token('ERRNO', sqlcode);
709: fnd_message.set_token('REASON', sqlerrm);
710: FND_MSG_PUB.add;
711: END IF;
712: END Get_Warehouse;
713:

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

741: WHEN OTHERS THEN
742: x_return_status := fnd_api.g_ret_sts_unexp_error;
743:
744: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
745: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
746: fnd_message.set_token('ROUTINE', 'DPP_UIWRAPPER_PVT.Get_Customer');
747: fnd_message.set_token('ERRNO', sqlcode);
748: fnd_message.set_token('REASON', sqlerrm);
749: FND_MSG_PUB.add;

Line 746: fnd_message.set_token('ROUTINE', 'DPP_UIWRAPPER_PVT.Get_Customer');

742: x_return_status := fnd_api.g_ret_sts_unexp_error;
743:
744: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
745: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
746: fnd_message.set_token('ROUTINE', 'DPP_UIWRAPPER_PVT.Get_Customer');
747: fnd_message.set_token('ERRNO', sqlcode);
748: fnd_message.set_token('REASON', sqlerrm);
749: FND_MSG_PUB.add;
750: END IF;

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

743:
744: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
745: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
746: fnd_message.set_token('ROUTINE', 'DPP_UIWRAPPER_PVT.Get_Customer');
747: fnd_message.set_token('ERRNO', sqlcode);
748: fnd_message.set_token('REASON', sqlerrm);
749: FND_MSG_PUB.add;
750: END IF;
751: END Get_Customer;

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

744: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
745: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
746: fnd_message.set_token('ROUTINE', 'DPP_UIWRAPPER_PVT.Get_Customer');
747: fnd_message.set_token('ERRNO', sqlcode);
748: fnd_message.set_token('REASON', sqlerrm);
749: FND_MSG_PUB.add;
750: END IF;
751: END Get_Customer;
752:

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

782: WHEN OTHERS THEN
783: x_return_status := fnd_api.g_ret_sts_unexp_error;
784:
785: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
786: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
787: fnd_message.set_token('ROUTINE', 'DPP_UIWRAPPER_PVT.Get_Product');
788: fnd_message.set_token('ERRNO', sqlcode);
789: fnd_message.set_token('REASON', sqlerrm);
790: FND_MSG_PUB.add;

Line 787: fnd_message.set_token('ROUTINE', 'DPP_UIWRAPPER_PVT.Get_Product');

783: x_return_status := fnd_api.g_ret_sts_unexp_error;
784:
785: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
786: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
787: fnd_message.set_token('ROUTINE', 'DPP_UIWRAPPER_PVT.Get_Product');
788: fnd_message.set_token('ERRNO', sqlcode);
789: fnd_message.set_token('REASON', sqlerrm);
790: FND_MSG_PUB.add;
791: END IF;

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

784:
785: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
786: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
787: fnd_message.set_token('ROUTINE', 'DPP_UIWRAPPER_PVT.Get_Product');
788: fnd_message.set_token('ERRNO', sqlcode);
789: fnd_message.set_token('REASON', sqlerrm);
790: FND_MSG_PUB.add;
791: END IF;
792: END Get_Product;

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

785: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
786: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
787: fnd_message.set_token('ROUTINE', 'DPP_UIWRAPPER_PVT.Get_Product');
788: fnd_message.set_token('ERRNO', sqlcode);
789: fnd_message.set_token('REASON', sqlerrm);
790: FND_MSG_PUB.add;
791: END IF;
792: END Get_Product;
793: --- for AME

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

845: WHEN OTHERS THEN
846: x_return_status := fnd_api.g_ret_sts_unexp_error;
847:
848: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
849: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
850: fnd_message.set_token('ROUTINE', 'DPP_UIWRAPPER_PVT.Get_AllApprovers');
851: fnd_message.set_token('ERRNO', sqlcode);
852: fnd_message.set_token('REASON', sqlerrm);
853: FND_MSG_PUB.add;

Line 850: fnd_message.set_token('ROUTINE', 'DPP_UIWRAPPER_PVT.Get_AllApprovers');

846: x_return_status := fnd_api.g_ret_sts_unexp_error;
847:
848: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
849: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
850: fnd_message.set_token('ROUTINE', 'DPP_UIWRAPPER_PVT.Get_AllApprovers');
851: fnd_message.set_token('ERRNO', sqlcode);
852: fnd_message.set_token('REASON', sqlerrm);
853: FND_MSG_PUB.add;
854: END IF;

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

847:
848: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
849: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
850: fnd_message.set_token('ROUTINE', 'DPP_UIWRAPPER_PVT.Get_AllApprovers');
851: fnd_message.set_token('ERRNO', sqlcode);
852: fnd_message.set_token('REASON', sqlerrm);
853: FND_MSG_PUB.add;
854: END IF;
855: END Get_AllApprovers;

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

848: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
849: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
850: fnd_message.set_token('ROUTINE', 'DPP_UIWRAPPER_PVT.Get_AllApprovers');
851: fnd_message.set_token('ERRNO', sqlcode);
852: fnd_message.set_token('REASON', sqlerrm);
853: FND_MSG_PUB.add;
854: END IF;
855: END Get_AllApprovers;
856:

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

896: WHEN OTHERS THEN
897: x_return_status := fnd_api.g_ret_sts_unexp_error;
898:
899: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
900: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
901: fnd_message.set_token('ROUTINE', 'DPP_UIWRAPPER_PVT.Process_User_Action');
902: fnd_message.set_token('ERRNO', sqlcode);
903: fnd_message.set_token('REASON', sqlerrm);
904: FND_MSG_PUB.add;

Line 901: fnd_message.set_token('ROUTINE', 'DPP_UIWRAPPER_PVT.Process_User_Action');

897: x_return_status := fnd_api.g_ret_sts_unexp_error;
898:
899: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
900: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
901: fnd_message.set_token('ROUTINE', 'DPP_UIWRAPPER_PVT.Process_User_Action');
902: fnd_message.set_token('ERRNO', sqlcode);
903: fnd_message.set_token('REASON', sqlerrm);
904: FND_MSG_PUB.add;
905: END IF;

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

898:
899: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
900: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
901: fnd_message.set_token('ROUTINE', 'DPP_UIWRAPPER_PVT.Process_User_Action');
902: fnd_message.set_token('ERRNO', sqlcode);
903: fnd_message.set_token('REASON', sqlerrm);
904: FND_MSG_PUB.add;
905: END IF;
906: END Process_User_Action;

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

899: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
900: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
901: fnd_message.set_token('ROUTINE', 'DPP_UIWRAPPER_PVT.Process_User_Action');
902: fnd_message.set_token('ERRNO', sqlcode);
903: fnd_message.set_token('REASON', sqlerrm);
904: FND_MSG_PUB.add;
905: END IF;
906: END Process_User_Action;
907:

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

949: WHEN OTHERS THEN
950: x_return_status := fnd_api.g_ret_sts_unexp_error;
951:
952: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
953: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
954: fnd_message.set_token('ROUTINE', 'DPP_UIWRAPPER_PVT.Raise_Business_Event');
955: fnd_message.set_token('ERRNO', sqlcode);
956: fnd_message.set_token('REASON', sqlerrm);
957: FND_MSG_PUB.add;

Line 954: fnd_message.set_token('ROUTINE', 'DPP_UIWRAPPER_PVT.Raise_Business_Event');

950: x_return_status := fnd_api.g_ret_sts_unexp_error;
951:
952: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
953: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
954: fnd_message.set_token('ROUTINE', 'DPP_UIWRAPPER_PVT.Raise_Business_Event');
955: fnd_message.set_token('ERRNO', sqlcode);
956: fnd_message.set_token('REASON', sqlerrm);
957: FND_MSG_PUB.add;
958: END IF;

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

951:
952: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
953: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
954: fnd_message.set_token('ROUTINE', 'DPP_UIWRAPPER_PVT.Raise_Business_Event');
955: fnd_message.set_token('ERRNO', sqlcode);
956: fnd_message.set_token('REASON', sqlerrm);
957: FND_MSG_PUB.add;
958: END IF;
959: END Raise_Business_Event;

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

952: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
953: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
954: fnd_message.set_token('ROUTINE', 'DPP_UIWRAPPER_PVT.Raise_Business_Event');
955: fnd_message.set_token('ERRNO', sqlcode);
956: fnd_message.set_token('REASON', sqlerrm);
957: FND_MSG_PUB.add;
958: END IF;
959: END Raise_Business_Event;
960:

Line 975: fnd_message.clear();

971: )
972: IS
973: BEGIN
974: --Clearing the msg stack and Initialize the message stack.
975: fnd_message.clear();
976: FND_MSG_PUB.initialize;
977: --Call Dpp_utility_pvt.convert_currency
978: DPP_UTILITY_PVT.convert_currency(p_from_currency => p_from_currency
979: ,p_to_currency => p_to_currency

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

991: WHEN OTHERS THEN
992: x_return_status := fnd_api.g_ret_sts_unexp_error;
993:
994: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
995: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
996: fnd_message.set_token('ROUTINE', 'DPP_UIWRAPPER_PVT.convert_currency');
997: fnd_message.set_token('ERRNO', sqlcode);
998: fnd_message.set_token('REASON', sqlerrm);
999: FND_MSG_PUB.ADD;

Line 996: fnd_message.set_token('ROUTINE', 'DPP_UIWRAPPER_PVT.convert_currency');

992: x_return_status := fnd_api.g_ret_sts_unexp_error;
993:
994: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
995: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
996: fnd_message.set_token('ROUTINE', 'DPP_UIWRAPPER_PVT.convert_currency');
997: fnd_message.set_token('ERRNO', sqlcode);
998: fnd_message.set_token('REASON', sqlerrm);
999: FND_MSG_PUB.ADD;
1000: END IF;

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

993:
994: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
995: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
996: fnd_message.set_token('ROUTINE', 'DPP_UIWRAPPER_PVT.convert_currency');
997: fnd_message.set_token('ERRNO', sqlcode);
998: fnd_message.set_token('REASON', sqlerrm);
999: FND_MSG_PUB.ADD;
1000: END IF;
1001:

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

994: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
995: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
996: fnd_message.set_token('ROUTINE', 'DPP_UIWRAPPER_PVT.convert_currency');
997: fnd_message.set_token('ERRNO', sqlcode);
998: fnd_message.set_token('REASON', sqlerrm);
999: FND_MSG_PUB.ADD;
1000: END IF;
1001:
1002: END convert_currency;