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 315: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');

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

Line 316: fnd_message.set_token('ROUTINE', 'DPP_UIWRAPPER_PVT.search_customer_items_all');

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

503: WHEN OTHERS THEN
504: x_return_status := fnd_api.g_ret_sts_unexp_error;
505:
506: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
507: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
508: fnd_message.set_token('ROUTINE', 'DPP_UIWRAPPER_PVT.search_customers');
509: fnd_message.set_token('ERRNO', sqlcode);
510: fnd_message.set_token('REASON', sqlerrm);
511: FND_MSG_PUB.add;

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

504: x_return_status := fnd_api.g_ret_sts_unexp_error;
505:
506: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
507: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
508: fnd_message.set_token('ROUTINE', 'DPP_UIWRAPPER_PVT.search_customers');
509: fnd_message.set_token('ERRNO', sqlcode);
510: fnd_message.set_token('REASON', sqlerrm);
511: FND_MSG_PUB.add;
512: END IF;

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

505:
506: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
507: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
508: fnd_message.set_token('ROUTINE', 'DPP_UIWRAPPER_PVT.search_customers');
509: fnd_message.set_token('ERRNO', sqlcode);
510: fnd_message.set_token('REASON', sqlerrm);
511: FND_MSG_PUB.add;
512: END IF;
513: END search_customers;

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

506: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
507: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
508: fnd_message.set_token('ROUTINE', 'DPP_UIWRAPPER_PVT.search_customers');
509: fnd_message.set_token('ERRNO', sqlcode);
510: fnd_message.set_token('REASON', sqlerrm);
511: FND_MSG_PUB.add;
512: END IF;
513: END search_customers;
514:

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

549: WHEN OTHERS THEN
550: x_return_status := fnd_api.g_ret_sts_unexp_error;
551:
552: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
553: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
554: fnd_message.set_token('ROUTINE', 'DPP_UIWRAPPER_PVT.search_customers_all');
555: fnd_message.set_token('ERRNO', sqlcode);
556: fnd_message.set_token('REASON', sqlerrm);
557: FND_MSG_PUB.add;

Line 554: fnd_message.set_token('ROUTINE', 'DPP_UIWRAPPER_PVT.search_customers_all');

550: x_return_status := fnd_api.g_ret_sts_unexp_error;
551:
552: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
553: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
554: fnd_message.set_token('ROUTINE', 'DPP_UIWRAPPER_PVT.search_customers_all');
555: fnd_message.set_token('ERRNO', sqlcode);
556: fnd_message.set_token('REASON', sqlerrm);
557: FND_MSG_PUB.add;
558: END IF;

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

551:
552: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
553: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
554: fnd_message.set_token('ROUTINE', 'DPP_UIWRAPPER_PVT.search_customers_all');
555: fnd_message.set_token('ERRNO', sqlcode);
556: fnd_message.set_token('REASON', sqlerrm);
557: FND_MSG_PUB.add;
558: END IF;
559: END search_customers_all;

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

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

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

602: WHEN OTHERS THEN
603: x_return_status := fnd_api.g_ret_sts_unexp_error;
604:
605: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
606: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
607: fnd_message.set_token('ROUTINE', 'DPP_UIWRAPPER_PVT.Get_LastPrice');
608: fnd_message.set_token('ERRNO', sqlcode);
609: fnd_message.set_token('REASON', sqlerrm);
610: FND_MSG_PUB.add;

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

603: x_return_status := fnd_api.g_ret_sts_unexp_error;
604:
605: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
606: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
607: fnd_message.set_token('ROUTINE', 'DPP_UIWRAPPER_PVT.Get_LastPrice');
608: fnd_message.set_token('ERRNO', sqlcode);
609: fnd_message.set_token('REASON', sqlerrm);
610: FND_MSG_PUB.add;
611: END IF;

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

604:
605: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
606: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
607: fnd_message.set_token('ROUTINE', 'DPP_UIWRAPPER_PVT.Get_LastPrice');
608: fnd_message.set_token('ERRNO', sqlcode);
609: fnd_message.set_token('REASON', sqlerrm);
610: FND_MSG_PUB.add;
611: END IF;
612: END Get_LastPrice;

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

605: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
606: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
607: fnd_message.set_token('ROUTINE', 'DPP_UIWRAPPER_PVT.Get_LastPrice');
608: fnd_message.set_token('ERRNO', sqlcode);
609: fnd_message.set_token('REASON', sqlerrm);
610: FND_MSG_PUB.add;
611: END IF;
612: END Get_LastPrice;
613:

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

647: WHEN OTHERS THEN
648: x_return_status := fnd_api.g_ret_sts_unexp_error;
649:
650: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
651: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
652: fnd_message.set_token('ROUTINE', 'DPP_UIWRAPPER_PVT.Get_ListPrice');
653: fnd_message.set_token('ERRNO', sqlcode);
654: fnd_message.set_token('REASON', sqlerrm);
655: FND_MSG_PUB.add;

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

648: x_return_status := fnd_api.g_ret_sts_unexp_error;
649:
650: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
651: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
652: fnd_message.set_token('ROUTINE', 'DPP_UIWRAPPER_PVT.Get_ListPrice');
653: fnd_message.set_token('ERRNO', sqlcode);
654: fnd_message.set_token('REASON', sqlerrm);
655: FND_MSG_PUB.add;
656: END IF;

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

649:
650: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
651: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
652: fnd_message.set_token('ROUTINE', 'DPP_UIWRAPPER_PVT.Get_ListPrice');
653: fnd_message.set_token('ERRNO', sqlcode);
654: fnd_message.set_token('REASON', sqlerrm);
655: FND_MSG_PUB.add;
656: END IF;
657: END Get_ListPrice;

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

650: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
651: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
652: fnd_message.set_token('ROUTINE', 'DPP_UIWRAPPER_PVT.Get_ListPrice');
653: fnd_message.set_token('ERRNO', sqlcode);
654: fnd_message.set_token('REASON', sqlerrm);
655: FND_MSG_PUB.add;
656: END IF;
657: END Get_ListPrice;
658:

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

679: WHEN OTHERS THEN
680: x_return_status := fnd_api.g_ret_sts_unexp_error;
681:
682: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
683: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
684: fnd_message.set_token('ROUTINE', 'DPP_UIWRAPPER_PVT.Get_Vendor');
685: fnd_message.set_token('ERRNO', sqlcode);
686: fnd_message.set_token('REASON', sqlerrm);
687: FND_MSG_PUB.add;

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

680: x_return_status := fnd_api.g_ret_sts_unexp_error;
681:
682: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
683: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
684: fnd_message.set_token('ROUTINE', 'DPP_UIWRAPPER_PVT.Get_Vendor');
685: fnd_message.set_token('ERRNO', sqlcode);
686: fnd_message.set_token('REASON', sqlerrm);
687: FND_MSG_PUB.add;
688: END IF;

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

681:
682: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
683: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
684: fnd_message.set_token('ROUTINE', 'DPP_UIWRAPPER_PVT.Get_Vendor');
685: fnd_message.set_token('ERRNO', sqlcode);
686: fnd_message.set_token('REASON', sqlerrm);
687: FND_MSG_PUB.add;
688: END IF;
689: END Get_Vendor;

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

682: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
683: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
684: fnd_message.set_token('ROUTINE', 'DPP_UIWRAPPER_PVT.Get_Vendor');
685: fnd_message.set_token('ERRNO', sqlcode);
686: fnd_message.set_token('REASON', sqlerrm);
687: FND_MSG_PUB.add;
688: END IF;
689: END Get_Vendor;
690:

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

719: WHEN OTHERS THEN
720: x_return_status := fnd_api.g_ret_sts_unexp_error;
721:
722: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
723: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
724: fnd_message.set_token('ROUTINE', 'DPP_UIWRAPPER_PVT.Get_Vendor_Site');
725: fnd_message.set_token('ERRNO', sqlcode);
726: fnd_message.set_token('REASON', sqlerrm);
727: FND_MSG_PUB.add;

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

720: x_return_status := fnd_api.g_ret_sts_unexp_error;
721:
722: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
723: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
724: fnd_message.set_token('ROUTINE', 'DPP_UIWRAPPER_PVT.Get_Vendor_Site');
725: fnd_message.set_token('ERRNO', sqlcode);
726: fnd_message.set_token('REASON', sqlerrm);
727: FND_MSG_PUB.add;
728: END IF;

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

721:
722: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
723: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
724: fnd_message.set_token('ROUTINE', 'DPP_UIWRAPPER_PVT.Get_Vendor_Site');
725: fnd_message.set_token('ERRNO', sqlcode);
726: fnd_message.set_token('REASON', sqlerrm);
727: FND_MSG_PUB.add;
728: END IF;
729: END Get_Vendor_Site;

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

722: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
723: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
724: fnd_message.set_token('ROUTINE', 'DPP_UIWRAPPER_PVT.Get_Vendor_Site');
725: fnd_message.set_token('ERRNO', sqlcode);
726: fnd_message.set_token('REASON', sqlerrm);
727: FND_MSG_PUB.add;
728: END IF;
729: END Get_Vendor_Site;
730:

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

757: WHEN OTHERS THEN
758: x_return_status := fnd_api.g_ret_sts_unexp_error;
759:
760: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
761: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
762: fnd_message.set_token('ROUTINE', 'DPP_UIWRAPPER_PVT.Get_Vendor_Contact');
763: fnd_message.set_token('ERRNO', sqlcode);
764: fnd_message.set_token('REASON', sqlerrm);
765: FND_MSG_PUB.add;

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

758: x_return_status := fnd_api.g_ret_sts_unexp_error;
759:
760: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
761: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
762: fnd_message.set_token('ROUTINE', 'DPP_UIWRAPPER_PVT.Get_Vendor_Contact');
763: fnd_message.set_token('ERRNO', sqlcode);
764: fnd_message.set_token('REASON', sqlerrm);
765: FND_MSG_PUB.add;
766: END IF;

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

759:
760: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
761: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
762: fnd_message.set_token('ROUTINE', 'DPP_UIWRAPPER_PVT.Get_Vendor_Contact');
763: fnd_message.set_token('ERRNO', sqlcode);
764: fnd_message.set_token('REASON', sqlerrm);
765: FND_MSG_PUB.add;
766: END IF;
767: END Get_Vendor_Contact;

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

760: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
761: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
762: fnd_message.set_token('ROUTINE', 'DPP_UIWRAPPER_PVT.Get_Vendor_Contact');
763: fnd_message.set_token('ERRNO', sqlcode);
764: fnd_message.set_token('REASON', sqlerrm);
765: FND_MSG_PUB.add;
766: END IF;
767: END Get_Vendor_Contact;
768:

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

796: WHEN OTHERS THEN
797: x_return_status := fnd_api.g_ret_sts_unexp_error;
798:
799: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
800: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
801: fnd_message.set_token('ROUTINE', 'DPP_UIWRAPPER_PVT.Get_Warehouse');
802: fnd_message.set_token('ERRNO', sqlcode);
803: fnd_message.set_token('REASON', sqlerrm);
804: FND_MSG_PUB.add;

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

797: x_return_status := fnd_api.g_ret_sts_unexp_error;
798:
799: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
800: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
801: fnd_message.set_token('ROUTINE', 'DPP_UIWRAPPER_PVT.Get_Warehouse');
802: fnd_message.set_token('ERRNO', sqlcode);
803: fnd_message.set_token('REASON', sqlerrm);
804: FND_MSG_PUB.add;
805: END IF;

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

798:
799: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
800: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
801: fnd_message.set_token('ROUTINE', 'DPP_UIWRAPPER_PVT.Get_Warehouse');
802: fnd_message.set_token('ERRNO', sqlcode);
803: fnd_message.set_token('REASON', sqlerrm);
804: FND_MSG_PUB.add;
805: END IF;
806: END Get_Warehouse;

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

799: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
800: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
801: fnd_message.set_token('ROUTINE', 'DPP_UIWRAPPER_PVT.Get_Warehouse');
802: fnd_message.set_token('ERRNO', sqlcode);
803: fnd_message.set_token('REASON', sqlerrm);
804: FND_MSG_PUB.add;
805: END IF;
806: END Get_Warehouse;
807:

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

835: WHEN OTHERS THEN
836: x_return_status := fnd_api.g_ret_sts_unexp_error;
837:
838: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
839: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
840: fnd_message.set_token('ROUTINE', 'DPP_UIWRAPPER_PVT.Get_Customer');
841: fnd_message.set_token('ERRNO', sqlcode);
842: fnd_message.set_token('REASON', sqlerrm);
843: FND_MSG_PUB.add;

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

836: x_return_status := fnd_api.g_ret_sts_unexp_error;
837:
838: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
839: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
840: fnd_message.set_token('ROUTINE', 'DPP_UIWRAPPER_PVT.Get_Customer');
841: fnd_message.set_token('ERRNO', sqlcode);
842: fnd_message.set_token('REASON', sqlerrm);
843: FND_MSG_PUB.add;
844: END IF;

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

837:
838: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
839: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
840: fnd_message.set_token('ROUTINE', 'DPP_UIWRAPPER_PVT.Get_Customer');
841: fnd_message.set_token('ERRNO', sqlcode);
842: fnd_message.set_token('REASON', sqlerrm);
843: FND_MSG_PUB.add;
844: END IF;
845: END Get_Customer;

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

838: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
839: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
840: fnd_message.set_token('ROUTINE', 'DPP_UIWRAPPER_PVT.Get_Customer');
841: fnd_message.set_token('ERRNO', sqlcode);
842: fnd_message.set_token('REASON', sqlerrm);
843: FND_MSG_PUB.add;
844: END IF;
845: END Get_Customer;
846:

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

876: WHEN OTHERS THEN
877: x_return_status := fnd_api.g_ret_sts_unexp_error;
878:
879: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
880: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
881: fnd_message.set_token('ROUTINE', 'DPP_UIWRAPPER_PVT.Get_Product');
882: fnd_message.set_token('ERRNO', sqlcode);
883: fnd_message.set_token('REASON', sqlerrm);
884: FND_MSG_PUB.add;

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

877: x_return_status := fnd_api.g_ret_sts_unexp_error;
878:
879: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
880: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
881: fnd_message.set_token('ROUTINE', 'DPP_UIWRAPPER_PVT.Get_Product');
882: fnd_message.set_token('ERRNO', sqlcode);
883: fnd_message.set_token('REASON', sqlerrm);
884: FND_MSG_PUB.add;
885: END IF;

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

878:
879: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
880: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
881: fnd_message.set_token('ROUTINE', 'DPP_UIWRAPPER_PVT.Get_Product');
882: fnd_message.set_token('ERRNO', sqlcode);
883: fnd_message.set_token('REASON', sqlerrm);
884: FND_MSG_PUB.add;
885: END IF;
886: END Get_Product;

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

879: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
880: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
881: fnd_message.set_token('ROUTINE', 'DPP_UIWRAPPER_PVT.Get_Product');
882: fnd_message.set_token('ERRNO', sqlcode);
883: fnd_message.set_token('REASON', sqlerrm);
884: FND_MSG_PUB.add;
885: END IF;
886: END Get_Product;
887: --- for AME

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

939: WHEN OTHERS THEN
940: x_return_status := fnd_api.g_ret_sts_unexp_error;
941:
942: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
943: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
944: fnd_message.set_token('ROUTINE', 'DPP_UIWRAPPER_PVT.Get_AllApprovers');
945: fnd_message.set_token('ERRNO', sqlcode);
946: fnd_message.set_token('REASON', sqlerrm);
947: FND_MSG_PUB.add;

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

940: x_return_status := fnd_api.g_ret_sts_unexp_error;
941:
942: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
943: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
944: fnd_message.set_token('ROUTINE', 'DPP_UIWRAPPER_PVT.Get_AllApprovers');
945: fnd_message.set_token('ERRNO', sqlcode);
946: fnd_message.set_token('REASON', sqlerrm);
947: FND_MSG_PUB.add;
948: END IF;

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

941:
942: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
943: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
944: fnd_message.set_token('ROUTINE', 'DPP_UIWRAPPER_PVT.Get_AllApprovers');
945: fnd_message.set_token('ERRNO', sqlcode);
946: fnd_message.set_token('REASON', sqlerrm);
947: FND_MSG_PUB.add;
948: END IF;
949: END Get_AllApprovers;

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

942: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
943: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
944: fnd_message.set_token('ROUTINE', 'DPP_UIWRAPPER_PVT.Get_AllApprovers');
945: fnd_message.set_token('ERRNO', sqlcode);
946: fnd_message.set_token('REASON', sqlerrm);
947: FND_MSG_PUB.add;
948: END IF;
949: END Get_AllApprovers;
950:

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

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

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

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

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

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

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

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

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

1043: WHEN OTHERS THEN
1044: x_return_status := fnd_api.g_ret_sts_unexp_error;
1045:
1046: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1047: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1048: fnd_message.set_token('ROUTINE', 'DPP_UIWRAPPER_PVT.Raise_Business_Event');
1049: fnd_message.set_token('ERRNO', sqlcode);
1050: fnd_message.set_token('REASON', sqlerrm);
1051: FND_MSG_PUB.add;

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

1044: x_return_status := fnd_api.g_ret_sts_unexp_error;
1045:
1046: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1047: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1048: fnd_message.set_token('ROUTINE', 'DPP_UIWRAPPER_PVT.Raise_Business_Event');
1049: fnd_message.set_token('ERRNO', sqlcode);
1050: fnd_message.set_token('REASON', sqlerrm);
1051: FND_MSG_PUB.add;
1052: END IF;

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

1045:
1046: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1047: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1048: fnd_message.set_token('ROUTINE', 'DPP_UIWRAPPER_PVT.Raise_Business_Event');
1049: fnd_message.set_token('ERRNO', sqlcode);
1050: fnd_message.set_token('REASON', sqlerrm);
1051: FND_MSG_PUB.add;
1052: END IF;
1053: END Raise_Business_Event;

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

1046: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1047: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1048: fnd_message.set_token('ROUTINE', 'DPP_UIWRAPPER_PVT.Raise_Business_Event');
1049: fnd_message.set_token('ERRNO', sqlcode);
1050: fnd_message.set_token('REASON', sqlerrm);
1051: FND_MSG_PUB.add;
1052: END IF;
1053: END Raise_Business_Event;
1054:

Line 1069: fnd_message.clear();

1065: )
1066: IS
1067: BEGIN
1068: --Clearing the msg stack and Initialize the message stack.
1069: fnd_message.clear();
1070: FND_MSG_PUB.initialize;
1071: --Call Dpp_utility_pvt.convert_currency
1072: DPP_UTILITY_PVT.convert_currency(p_from_currency => p_from_currency
1073: ,p_to_currency => p_to_currency

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

1085: WHEN OTHERS THEN
1086: x_return_status := fnd_api.g_ret_sts_unexp_error;
1087:
1088: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1089: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1090: fnd_message.set_token('ROUTINE', 'DPP_UIWRAPPER_PVT.convert_currency');
1091: fnd_message.set_token('ERRNO', sqlcode);
1092: fnd_message.set_token('REASON', sqlerrm);
1093: FND_MSG_PUB.ADD;

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

1086: x_return_status := fnd_api.g_ret_sts_unexp_error;
1087:
1088: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1089: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1090: fnd_message.set_token('ROUTINE', 'DPP_UIWRAPPER_PVT.convert_currency');
1091: fnd_message.set_token('ERRNO', sqlcode);
1092: fnd_message.set_token('REASON', sqlerrm);
1093: FND_MSG_PUB.ADD;
1094: END IF;

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

1087:
1088: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1089: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1090: fnd_message.set_token('ROUTINE', 'DPP_UIWRAPPER_PVT.convert_currency');
1091: fnd_message.set_token('ERRNO', sqlcode);
1092: fnd_message.set_token('REASON', sqlerrm);
1093: FND_MSG_PUB.ADD;
1094: END IF;
1095:

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

1088: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1089: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1090: fnd_message.set_token('ROUTINE', 'DPP_UIWRAPPER_PVT.convert_currency');
1091: fnd_message.set_token('ERRNO', sqlcode);
1092: fnd_message.set_token('REASON', sqlerrm);
1093: FND_MSG_PUB.ADD;
1094: END IF;
1095:
1096: END convert_currency;