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

Line 27: Fnd_Msg_Pub.initialize;

23:
24: BEGIN
25: x_rec_count := 0;
26: x_msg_data := '';
27: Fnd_Msg_Pub.initialize;
28:
29: x_return_status := fnd_api.g_ret_sts_success;
30:
31: IF p_status_change = 'CANCELLED' THEN

Line 42: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN

38: INTO l_process_code
39: FROM fnd_lookups
40: WHERE lookup_type LIKE 'DPP_EXECUTION_PROCESSES%'
41: AND lookup_code ='UPDTPO';
42: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
43: fnd_message.set_name('DPP', 'DPP_EXE_PROCESS_REQUESTED');
44: fnd_message.set_token('PROCESS_CODE', l_process_code);
45: fnd_msg_pub.add;
46: END IF;

Line 45: fnd_msg_pub.add;

41: AND lookup_code ='UPDTPO';
42: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
43: fnd_message.set_name('DPP', 'DPP_EXE_PROCESS_REQUESTED');
44: fnd_message.set_token('PROCESS_CODE', l_process_code);
45: fnd_msg_pub.add;
46: END IF;
47: EXCEPTION WHEN OTHERS THEN
48: NULL;
49: END;

Line 61: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN

57: INTO l_process_code
58: FROM fnd_lookups
59: WHERE lookup_type LIKE 'DPP_EXECUTION_PROCESSES%'
60: AND lookup_code ='NTFYPO';
61: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
62: fnd_message.set_name('DPP', 'DPP_EXE_PROCESS_REQUESTED');
63: fnd_message.set_token('PROCESS_CODE', l_process_code);
64: fnd_msg_pub.add;
65: END IF;

Line 64: fnd_msg_pub.add;

60: AND lookup_code ='NTFYPO';
61: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
62: fnd_message.set_name('DPP', 'DPP_EXE_PROCESS_REQUESTED');
63: fnd_message.set_token('PROCESS_CODE', l_process_code);
64: fnd_msg_pub.add;
65: END IF;
66: EXCEPTION WHEN OTHERS THEN
67: NULL;
68: END;

Line 80: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN

76: INTO l_process_code
77: FROM fnd_lookups
78: WHERE lookup_type LIKE 'DPP_EXECUTION_PROCESSES%'
79: AND lookup_code ='INVC';
80: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
81: fnd_message.set_name('DPP', 'DPP_EXE_PROCESS_REQUESTED');
82: fnd_message.set_token('PROCESS_CODE', l_process_code);
83: fnd_msg_pub.add;
84: END IF;

Line 83: fnd_msg_pub.add;

79: AND lookup_code ='INVC';
80: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
81: fnd_message.set_name('DPP', 'DPP_EXE_PROCESS_REQUESTED');
82: fnd_message.set_token('PROCESS_CODE', l_process_code);
83: fnd_msg_pub.add;
84: END IF;
85: EXCEPTION WHEN OTHERS THEN
86: NULL;
87: END;

Line 100: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN

96: INTO l_process_code
97: FROM fnd_lookups
98: WHERE lookup_type LIKE 'DPP_EXECUTION_PROCESSES%'
99: AND lookup_code ='UPDTLP';
100: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
101: fnd_message.set_name('DPP', 'DPP_EXE_PROCESS_REQUESTED');
102: fnd_message.set_token('PROCESS_CODE', l_process_code);
103: fnd_msg_pub.add;
104: END IF;

Line 103: fnd_msg_pub.add;

99: AND lookup_code ='UPDTLP';
100: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
101: fnd_message.set_name('DPP', 'DPP_EXE_PROCESS_REQUESTED');
102: fnd_message.set_token('PROCESS_CODE', l_process_code);
103: fnd_msg_pub.add;
104: END IF;
105: EXCEPTION WHEN OTHERS THEN
106: NULL;
107: END;

Line 119: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN

115: INTO l_process_code
116: FROM fnd_lookups
117: WHERE lookup_type LIKE 'DPP_EXECUTION_PROCESSES%'
118: AND lookup_code ='INPL';
119: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
120: fnd_message.set_name('DPP', 'DPP_EXE_PROCESS_REQUESTED');
121: fnd_message.set_token('PROCESS_CODE', l_process_code);
122: fnd_msg_pub.add;
123: END IF;

Line 122: fnd_msg_pub.add;

118: AND lookup_code ='INPL';
119: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
120: fnd_message.set_name('DPP', 'DPP_EXE_PROCESS_REQUESTED');
121: fnd_message.set_token('PROCESS_CODE', l_process_code);
122: fnd_msg_pub.add;
123: END IF;
124: EXCEPTION WHEN OTHERS THEN
125: NULL;
126: END;

Line 138: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN

134: INTO l_process_code
135: FROM fnd_lookups
136: WHERE lookup_type LIKE 'DPP_EXECUTION_PROCESSES%'
137: AND lookup_code ='OUTPL';
138: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
139: fnd_message.set_name('DPP', 'DPP_EXE_PROCESS_REQUESTED');
140: fnd_message.set_token('PROCESS_CODE', l_process_code);
141: fnd_msg_pub.add;
142: END IF;

Line 141: fnd_msg_pub.add;

137: AND lookup_code ='OUTPL';
138: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
139: fnd_message.set_name('DPP', 'DPP_EXE_PROCESS_REQUESTED');
140: fnd_message.set_token('PROCESS_CODE', l_process_code);
141: fnd_msg_pub.add;
142: END IF;
143: EXCEPTION WHEN OTHERS THEN
144: NULL;
145: END;

Line 157: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN

153: INTO l_process_code
154: FROM fnd_lookups
155: WHERE lookup_type LIKE 'DPP_EXECUTION_PROCESSES%'
156: AND lookup_code ='PROMO';
157: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
158: fnd_message.set_name('DPP', 'DPP_EXE_PROCESS_REQUESTED');
159: fnd_message.set_token('PROCESS_CODE', l_process_code);
160: fnd_msg_pub.add;
161: END IF;

Line 160: fnd_msg_pub.add;

156: AND lookup_code ='PROMO';
157: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
158: fnd_message.set_name('DPP', 'DPP_EXE_PROCESS_REQUESTED');
159: fnd_message.set_token('PROCESS_CODE', l_process_code);
160: fnd_msg_pub.add;
161: END IF;
162: EXCEPTION WHEN OTHERS THEN
163: NULL;
164: END;

Line 175: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN

171: INTO l_process_code
172: FROM fnd_lookups
173: WHERE lookup_type LIKE 'DPP_EXECUTION_PROCESSES%'
174: AND lookup_code ='DSTRINVCL';
175: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
176: fnd_message.set_name('DPP', 'DPP_EXE_PROCESS_REQUESTED');
177: fnd_message.set_token('PROCESS_CODE', l_process_code);
178: fnd_msg_pub.add;
179: END IF;

Line 178: fnd_msg_pub.add;

174: AND lookup_code ='DSTRINVCL';
175: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
176: fnd_message.set_name('DPP', 'DPP_EXE_PROCESS_REQUESTED');
177: fnd_message.set_token('PROCESS_CODE', l_process_code);
178: fnd_msg_pub.add;
179: END IF;
180: EXCEPTION WHEN OTHERS THEN
181: NULL;
182: END;

Line 194: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN

190: INTO l_process_code
191: FROM fnd_lookups
192: WHERE lookup_type LIKE 'DPP_EXECUTION_PROCESSES%'
193: AND lookup_code ='CUSTCL';
194: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
195: fnd_message.set_name('DPP', 'DPP_EXE_PROCESS_REQUESTED');
196: fnd_message.set_token('PROCESS_CODE', l_process_code);
197: fnd_msg_pub.add;
198: END IF;

Line 197: fnd_msg_pub.add;

193: AND lookup_code ='CUSTCL';
194: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
195: fnd_message.set_name('DPP', 'DPP_EXE_PROCESS_REQUESTED');
196: fnd_message.set_token('PROCESS_CODE', l_process_code);
197: fnd_msg_pub.add;
198: END IF;
199: EXCEPTION WHEN OTHERS THEN
200: NULL;
201: END;

Line 204: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN

200: NULL;
201: END;
202:
203: IF l_flag = 'Y' THEN
204: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
205: fnd_message.set_name('DPP', 'DPP_TXN_NOT_CANCELLED');
206: fnd_msg_pub.add;
207: END IF;
208: RAISE FND_API.G_EXC_ERROR;

Line 206: fnd_msg_pub.add;

202:
203: IF l_flag = 'Y' THEN
204: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
205: fnd_message.set_name('DPP', 'DPP_TXN_NOT_CANCELLED');
206: fnd_msg_pub.add;
207: END IF;
208: RAISE FND_API.G_EXC_ERROR;
209: END IF;
210:

Line 222: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN

218: INTO l_process_code
219: FROM fnd_lookups
220: WHERE lookup_type LIKE 'DPP_EXECUTION_PROCESSES%'
221: AND lookup_code ='UPDTPO';
222: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
223: fnd_message.set_name('DPP', 'DPP_EXE_PROCESS_INCOMPLETE');
224: fnd_message.set_token('PROCESS_CODE', l_process_code);
225: fnd_msg_pub.add;
226: END IF;

Line 225: fnd_msg_pub.add;

221: AND lookup_code ='UPDTPO';
222: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
223: fnd_message.set_name('DPP', 'DPP_EXE_PROCESS_INCOMPLETE');
224: fnd_message.set_token('PROCESS_CODE', l_process_code);
225: fnd_msg_pub.add;
226: END IF;
227: EXCEPTION WHEN OTHERS THEN
228: NULL;
229: END;

Line 240: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN

236: INTO l_process_code
237: FROM fnd_lookups
238: WHERE lookup_type LIKE 'DPP_EXECUTION_PROCESSES%'
239: AND lookup_code ='NTFYPO';
240: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
241: fnd_message.set_name('DPP', 'DPP_EXE_PROCESS_INCOMPLETE');
242: fnd_message.set_token('PROCESS_CODE', l_process_code);
243: fnd_msg_pub.add;
244: END IF;

Line 243: fnd_msg_pub.add;

239: AND lookup_code ='NTFYPO';
240: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
241: fnd_message.set_name('DPP', 'DPP_EXE_PROCESS_INCOMPLETE');
242: fnd_message.set_token('PROCESS_CODE', l_process_code);
243: fnd_msg_pub.add;
244: END IF;
245: EXCEPTION WHEN OTHERS THEN
246: NULL;
247: END;

Line 260: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN

256: INTO l_process_code
257: FROM fnd_lookups
258: WHERE lookup_type LIKE 'DPP_EXECUTION_PROCESSES%'
259: AND lookup_code ='INVC';
260: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
261: fnd_message.set_name('DPP', 'DPP_EXE_PROCESS_INCOMPLETE');
262: fnd_message.set_token('PROCESS_CODE', l_process_code);
263: fnd_msg_pub.add;
264: END IF;

Line 263: fnd_msg_pub.add;

259: AND lookup_code ='INVC';
260: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
261: fnd_message.set_name('DPP', 'DPP_EXE_PROCESS_INCOMPLETE');
262: fnd_message.set_token('PROCESS_CODE', l_process_code);
263: fnd_msg_pub.add;
264: END IF;
265: EXCEPTION WHEN OTHERS THEN
266: NULL;
267: END;

Line 279: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN

275: INTO l_process_code
276: FROM fnd_lookups
277: WHERE lookup_type LIKE 'DPP_EXECUTION_PROCESSES%'
278: AND lookup_code ='UPDTLP';
279: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
280: fnd_message.set_name('DPP', 'DPP_EXE_PROCESS_INCOMPLETE');
281: fnd_message.set_token('PROCESS_CODE', l_process_code);
282: fnd_msg_pub.add;
283: END IF;

Line 282: fnd_msg_pub.add;

278: AND lookup_code ='UPDTLP';
279: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
280: fnd_message.set_name('DPP', 'DPP_EXE_PROCESS_INCOMPLETE');
281: fnd_message.set_token('PROCESS_CODE', l_process_code);
282: fnd_msg_pub.add;
283: END IF;
284: EXCEPTION WHEN OTHERS THEN
285: NULL;
286: END;

Line 298: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN

294: INTO l_process_code
295: FROM fnd_lookups
296: WHERE lookup_type LIKE 'DPP_EXECUTION_PROCESSES%'
297: AND lookup_code ='INPL';
298: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
299: fnd_message.set_name('DPP', 'DPP_EXE_PROCESS_INCOMPLETE');
300: fnd_message.set_token('PROCESS_CODE', l_process_code);
301: fnd_msg_pub.add;
302: END IF;

Line 301: fnd_msg_pub.add;

297: AND lookup_code ='INPL';
298: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
299: fnd_message.set_name('DPP', 'DPP_EXE_PROCESS_INCOMPLETE');
300: fnd_message.set_token('PROCESS_CODE', l_process_code);
301: fnd_msg_pub.add;
302: END IF;
303: EXCEPTION WHEN OTHERS THEN
304: NULL;
305: END;

Line 317: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN

313: INTO l_process_code
314: FROM fnd_lookups
315: WHERE lookup_type LIKE 'DPP_EXECUTION_PROCESSES%'
316: AND lookup_code ='OUTPL';
317: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
318: fnd_message.set_name('DPP', 'DPP_EXE_PROCESS_INCOMPLETE');
319: fnd_message.set_token('PROCESS_CODE', l_process_code);
320: fnd_msg_pub.add;
321: END IF;

Line 320: fnd_msg_pub.add;

316: AND lookup_code ='OUTPL';
317: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
318: fnd_message.set_name('DPP', 'DPP_EXE_PROCESS_INCOMPLETE');
319: fnd_message.set_token('PROCESS_CODE', l_process_code);
320: fnd_msg_pub.add;
321: END IF;
322: EXCEPTION WHEN OTHERS THEN
323: NULL;
324: END;

Line 336: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN

332: INTO l_process_code
333: FROM fnd_lookups
334: WHERE lookup_type LIKE 'DPP_EXECUTION_PROCESSES%'
335: AND lookup_code ='PROMO';
336: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
337: fnd_message.set_name('DPP', 'DPP_EXE_PROCESS_INCOMPLETE');
338: fnd_message.set_token('PROCESS_CODE', l_process_code);
339: fnd_msg_pub.add;
340: END IF;

Line 339: fnd_msg_pub.add;

335: AND lookup_code ='PROMO';
336: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
337: fnd_message.set_name('DPP', 'DPP_EXE_PROCESS_INCOMPLETE');
338: fnd_message.set_token('PROCESS_CODE', l_process_code);
339: fnd_msg_pub.add;
340: END IF;
341: EXCEPTION WHEN OTHERS THEN
342: NULL;
343: END;

Line 355: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN

351: INTO l_process_code
352: FROM fnd_lookups
353: WHERE lookup_type LIKE 'DPP_EXECUTION_PROCESSES%'
354: AND lookup_code ='DSTRINVCL';
355: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
356: fnd_message.set_name('DPP', 'DPP_EXE_PROCESS_INCOMPLETE');
357: fnd_message.set_token('PROCESS_CODE', l_process_code);
358: fnd_msg_pub.add;
359: END IF;

Line 358: fnd_msg_pub.add;

354: AND lookup_code ='DSTRINVCL';
355: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
356: fnd_message.set_name('DPP', 'DPP_EXE_PROCESS_INCOMPLETE');
357: fnd_message.set_token('PROCESS_CODE', l_process_code);
358: fnd_msg_pub.add;
359: END IF;
360: EXCEPTION WHEN OTHERS THEN
361: NULL;
362: END;

Line 369: fnd_msg_pub.add;

365: LOOP
366: l_flag := 'Y';
367: fnd_message.set_name('DPP', 'DPP_CLAIM_NOT_CLOSED');
368: fnd_message.set_token('CLAIM_NUMBER',select_claims_rec.claim_number );
369: fnd_msg_pub.add;
370: END LOOP;
371: END IF;
372: IF l_flag = 'Y' THEN
373: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN

Line 373: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN

369: fnd_msg_pub.add;
370: END LOOP;
371: END IF;
372: IF l_flag = 'Y' THEN
373: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
374: fnd_message.set_name('DPP', 'DPP_TXN_NOT_CLOSED');
375: fnd_msg_pub.add;
376: END IF;
377: RAISE FND_API.G_EXC_ERROR;

Line 375: fnd_msg_pub.add;

371: END IF;
372: IF l_flag = 'Y' THEN
373: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
374: fnd_message.set_name('DPP', 'DPP_TXN_NOT_CLOSED');
375: fnd_msg_pub.add;
376: END IF;
377: RAISE FND_API.G_EXC_ERROR;
378: END IF;
379: EXCEPTION

Line 386: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

382:
383: WHEN OTHERS THEN
384: x_return_status := fnd_api.g_ret_sts_unexp_error;
385:
386: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
387: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
388: fnd_message.set_token('ROUTINE', 'DPP_UTILITY_PVT.check_txnclose');
389: fnd_message.set_token('ERRNO', sqlcode);
390: fnd_message.set_token('REASON', sqlerrm);

Line 391: FND_MSG_PUB.ADD;

387: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
388: fnd_message.set_token('ROUTINE', 'DPP_UTILITY_PVT.check_txnclose');
389: fnd_message.set_token('ERRNO', sqlcode);
390: fnd_message.set_token('REASON', sqlerrm);
391: FND_MSG_PUB.ADD;
392: END IF;
393: END Check_Transaction;
394:
395: PROCEDURE search_vendors(

Line 444: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

440: EXCEPTION
441: WHEN OTHERS THEN
442: x_return_status := fnd_api.g_ret_sts_unexp_error;
443:
444: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
445: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
446: fnd_message.set_token('ROUTINE', 'DPP_UTILITY_PVT.search_vendors');
447: fnd_message.set_token('ERRNO', sqlcode);
448: fnd_message.set_token('REASON', sqlerrm);

Line 449: FND_MSG_PUB.ADD;

445: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
446: fnd_message.set_token('ROUTINE', 'DPP_UTILITY_PVT.search_vendors');
447: fnd_message.set_token('ERRNO', sqlcode);
448: fnd_message.set_token('REASON', sqlerrm);
449: FND_MSG_PUB.ADD;
450: END IF;
451:
452: END search_vendors;
453:

Line 500: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN

496:
497: x_rec_count := 0;
498:
499: IF l_search_criteria_tbl(1).search_text IS NULL THEN
500: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
501: fnd_message.set_name('DPP', 'DPP_UI_LOV_NO_VENDORID');
502: fnd_msg_pub.add;
503: END IF;
504: RAISE FND_API.G_EXC_ERROR;

Line 502: fnd_msg_pub.add;

498:
499: IF l_search_criteria_tbl(1).search_text IS NULL THEN
500: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
501: fnd_message.set_name('DPP', 'DPP_UI_LOV_NO_VENDORID');
502: fnd_msg_pub.add;
503: END IF;
504: RAISE FND_API.G_EXC_ERROR;
505:
506: ELSIF l_search_criteria_tbl(3).search_text IS NULL THEN

Line 507: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN

503: END IF;
504: RAISE FND_API.G_EXC_ERROR;
505:
506: ELSIF l_search_criteria_tbl(3).search_text IS NULL THEN
507: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
508: fnd_message.set_name('DPP', 'DPP_UI_LOV_NO_ORGID');
509: fnd_msg_pub.add;
510: END IF;
511: RAISE FND_API.G_EXC_ERROR;

Line 509: fnd_msg_pub.add;

505:
506: ELSIF l_search_criteria_tbl(3).search_text IS NULL THEN
507: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
508: fnd_message.set_name('DPP', 'DPP_UI_LOV_NO_ORGID');
509: fnd_msg_pub.add;
510: END IF;
511: RAISE FND_API.G_EXC_ERROR;
512: END IF;
513:

Line 539: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

535:
536: WHEN OTHERS THEN
537: x_return_status := fnd_api.g_ret_sts_unexp_error;
538:
539: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
540: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
541: fnd_message.set_token('ROUTINE', 'DPP_UTILITY_PVT.search_vendor_sites');
542: fnd_message.set_token('ERRNO', sqlcode);
543: fnd_message.set_token('REASON', sqlerrm);

Line 544: FND_MSG_PUB.ADD;

540: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
541: fnd_message.set_token('ROUTINE', 'DPP_UTILITY_PVT.search_vendor_sites');
542: fnd_message.set_token('ERRNO', sqlcode);
543: fnd_message.set_token('REASON', sqlerrm);
544: FND_MSG_PUB.ADD;
545: END IF;
546:
547: END search_vendor_sites;
548:

Line 591: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN

587:
588: x_rec_count := 0;
589:
590: IF l_search_criteria_tbl(1).search_text IS NULL THEN
591: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
592: fnd_message.set_name('DPP', 'DPP_UI_LOV_NO_VENDORSITEID');
593: fnd_msg_pub.add;
594: END IF;
595:

Line 593: fnd_msg_pub.add;

589:
590: IF l_search_criteria_tbl(1).search_text IS NULL THEN
591: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
592: fnd_message.set_name('DPP', 'DPP_UI_LOV_NO_VENDORSITEID');
593: fnd_msg_pub.add;
594: END IF;
595:
596: RAISE fnd_api.g_exc_error;
597: END IF;

Line 621: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

617:
618: WHEN OTHERS THEN
619: x_return_status := fnd_api.g_ret_sts_unexp_error;
620:
621: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
622: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
623: fnd_message.set_token('ROUTINE', 'DPP_UTILITY_PVT.search_vendor_contacts');
624: fnd_message.set_token('ERRNO', sqlcode);
625: fnd_message.set_token('REASON', sqlerrm);

Line 626: FND_MSG_PUB.ADD;

622: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
623: fnd_message.set_token('ROUTINE', 'DPP_UTILITY_PVT.search_vendor_contacts');
624: fnd_message.set_token('ERRNO', sqlcode);
625: fnd_message.set_token('REASON', sqlerrm);
626: FND_MSG_PUB.ADD;
627: END IF;
628:
629: END search_vendor_contacts;
630:

Line 728: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN

724:
725: x_rec_count := 0;
726:
727: IF l_search_criteria_tbl(1).search_text IS NULL THEN
728: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
729: fnd_message.set_name('DPP', 'DPP_UI_LOV_NO_ORGID');
730: fnd_msg_pub.add;
731: END IF;
732:

Line 730: fnd_msg_pub.add;

726:
727: IF l_search_criteria_tbl(1).search_text IS NULL THEN
728: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
729: fnd_message.set_name('DPP', 'DPP_UI_LOV_NO_ORGID');
730: fnd_msg_pub.add;
731: END IF;
732:
733: RAISE fnd_api.g_exc_error;
734: ELSIF l_search_criteria_tbl(3).search_text IS NULL THEN

Line 735: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN

731: END IF;
732:
733: RAISE fnd_api.g_exc_error;
734: ELSIF l_search_criteria_tbl(3).search_text IS NULL THEN
735: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
736: fnd_message.set_name('DPP', 'DPP_UI_LOV_NO_VENDORID');
737: fnd_msg_pub.add;
738: END IF;
739: RAISE fnd_api.g_exc_error;

Line 737: fnd_msg_pub.add;

733: RAISE fnd_api.g_exc_error;
734: ELSIF l_search_criteria_tbl(3).search_text IS NULL THEN
735: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
736: fnd_message.set_name('DPP', 'DPP_UI_LOV_NO_VENDORID');
737: fnd_msg_pub.add;
738: END IF;
739: RAISE fnd_api.g_exc_error;
740: ELSIF l_search_criteria_tbl(4).search_text IS NULL THEN
741: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN

Line 741: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN

737: fnd_msg_pub.add;
738: END IF;
739: RAISE fnd_api.g_exc_error;
740: ELSIF l_search_criteria_tbl(4).search_text IS NULL THEN
741: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
742: fnd_message.set_name('DPP', 'DPP_UI_LOV_NO_VENDORSITEID');
743: fnd_msg_pub.add;
744: END IF;
745: RAISE fnd_api.g_exc_error;

Line 743: fnd_msg_pub.add;

739: RAISE fnd_api.g_exc_error;
740: ELSIF l_search_criteria_tbl(4).search_text IS NULL THEN
741: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
742: fnd_message.set_name('DPP', 'DPP_UI_LOV_NO_VENDORSITEID');
743: fnd_msg_pub.add;
744: END IF;
745: RAISE fnd_api.g_exc_error;
746: END IF;
747:

Line 838: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

834:
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_UTILITY_PVT.search_items');
841: fnd_message.set_token('ERRNO', sqlcode);
842: fnd_message.set_token('REASON', sqlerrm);

Line 843: FND_MSG_PUB.ADD;

839: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
840: fnd_message.set_token('ROUTINE', 'DPP_UTILITY_PVT.search_items');
841: fnd_message.set_token('ERRNO', sqlcode);
842: fnd_message.set_token('REASON', sqlerrm);
843: FND_MSG_PUB.ADD;
844: END IF;
845:
846: END search_items;
847:

Line 894: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN

890: BEGIN
891: x_rec_count := 0;
892:
893: IF l_search_criteria_tbl(1).search_text IS NULL THEN
894: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
895: fnd_message.set_name('DPP', 'DPP_UI_LOV_NO_TRANSACTIONID');
896: fnd_msg_pub.add;
897: END IF;
898:

Line 896: fnd_msg_pub.add;

892:
893: IF l_search_criteria_tbl(1).search_text IS NULL THEN
894: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
895: fnd_message.set_name('DPP', 'DPP_UI_LOV_NO_TRANSACTIONID');
896: fnd_msg_pub.add;
897: END IF;
898:
899: RAISE fnd_api.g_exc_error;
900: ELSIF l_search_criteria_tbl(3).search_text IS NULL THEN

Line 901: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN

897: END IF;
898:
899: RAISE fnd_api.g_exc_error;
900: ELSIF l_search_criteria_tbl(3).search_text IS NULL THEN
901: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
902: fnd_message.set_name('DPP', 'DPP_UI_LOV_NO_CUST_ACCT_ID');
903: fnd_msg_pub.add;
904: END IF;
905: RAISE fnd_api.g_exc_error;

Line 903: fnd_msg_pub.add;

899: RAISE fnd_api.g_exc_error;
900: ELSIF l_search_criteria_tbl(3).search_text IS NULL THEN
901: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
902: fnd_message.set_name('DPP', 'DPP_UI_LOV_NO_CUST_ACCT_ID');
903: fnd_msg_pub.add;
904: END IF;
905: RAISE fnd_api.g_exc_error;
906: END IF;
907:

Line 935: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

931:
932: WHEN OTHERS THEN
933: x_return_status := fnd_api.g_ret_sts_unexp_error;
934:
935: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
936: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
937: fnd_message.set_token('ROUTINE', 'DPP_UTILITY_PVT.search_customer_items');
938: fnd_message.set_token('ERRNO', sqlcode);
939: fnd_message.set_token('REASON', sqlerrm);

Line 940: FND_MSG_PUB.ADD;

936: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
937: fnd_message.set_token('ROUTINE', 'DPP_UTILITY_PVT.search_customer_items');
938: fnd_message.set_token('ERRNO', sqlcode);
939: fnd_message.set_token('REASON', sqlerrm);
940: FND_MSG_PUB.ADD;
941: END IF;
942:
943: END search_customer_items;
944:

Line 977: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN

973: BEGIN
974: x_rec_count := 0;
975: x_return_status := fnd_api.g_ret_sts_success;
976: IF l_search_criteria_tbl(2).search_text IS NULL THEN
977: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
978: fnd_message.set_name('DPP', 'DPP_UI_LOV_NO_ORGID');
979: fnd_msg_pub.add;
980: END IF;
981:

Line 979: fnd_msg_pub.add;

975: x_return_status := fnd_api.g_ret_sts_success;
976: IF l_search_criteria_tbl(2).search_text IS NULL THEN
977: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
978: fnd_message.set_name('DPP', 'DPP_UI_LOV_NO_ORGID');
979: fnd_msg_pub.add;
980: END IF;
981:
982: RAISE FND_API.G_EXC_ERROR;
983: END IF;

Line 1009: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

1005:
1006: WHEN OTHERS THEN
1007: x_return_status := fnd_api.g_ret_sts_unexp_error;
1008:
1009: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1010: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1011: fnd_message.set_token('ROUTINE', 'DPP_UTILITY_PVT.search_warehouses');
1012: fnd_message.set_token('ERRNO', sqlcode);
1013: fnd_message.set_token('REASON', sqlerrm);

Line 1014: FND_MSG_PUB.ADD;

1010: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1011: fnd_message.set_token('ROUTINE', 'DPP_UTILITY_PVT.search_warehouses');
1012: fnd_message.set_token('ERRNO', sqlcode);
1013: fnd_message.set_token('REASON', sqlerrm);
1014: FND_MSG_PUB.ADD;
1015: END IF;
1016: END search_warehouses;
1017:
1018: PROCEDURE Get_CoveredInventory(

Line 1182: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

1178:
1179: WHEN OTHERS THEN
1180: x_return_status := fnd_api.g_ret_sts_unexp_error;
1181:
1182: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1183: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1184: fnd_message.set_token('ROUTINE', 'DPP_UTILITY_PVT.Get_CoveredInventory');
1185: fnd_message.set_token('ERRNO', sqlcode);
1186: fnd_message.set_token('REASON', sqlerrm);

Line 1187: FND_MSG_PUB.ADD;

1183: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1184: fnd_message.set_token('ROUTINE', 'DPP_UTILITY_PVT.Get_CoveredInventory');
1185: fnd_message.set_token('ERRNO', sqlcode);
1186: fnd_message.set_token('REASON', sqlerrm);
1187: FND_MSG_PUB.ADD;
1188: END IF;
1189:
1190: END Get_CoveredInventory;
1191:

Line 1293: FND_MSG_PUB.add;

1289: x_return_status := fnd_api.g_ret_sts_success;
1290: IF l_hdr_rec.org_id IS NULL THEN
1291: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');
1292: FND_MESSAGE.set_token('ID', 'Org ID');
1293: FND_MSG_PUB.add;
1294: RAISE FND_API.G_EXC_ERROR;
1295: ELSIF l_hdr_rec.effective_start_date IS NULL THEN
1296: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');
1297: FND_MESSAGE.set_token('ID', 'Effective Start Date');

Line 1298: FND_MSG_PUB.add;

1294: RAISE FND_API.G_EXC_ERROR;
1295: ELSIF l_hdr_rec.effective_start_date IS NULL THEN
1296: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');
1297: FND_MESSAGE.set_token('ID', 'Effective Start Date');
1298: FND_MSG_PUB.add;
1299: RAISE FND_API.G_EXC_ERROR;
1300: ELSIF l_hdr_rec.effective_end_date IS NULL THEN
1301: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');
1302: FND_MESSAGE.set_token('ID', 'Effective End Date');

Line 1303: FND_MSG_PUB.add;

1299: RAISE FND_API.G_EXC_ERROR;
1300: ELSIF l_hdr_rec.effective_end_date IS NULL THEN
1301: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');
1302: FND_MESSAGE.set_token('ID', 'Effective End Date');
1303: FND_MSG_PUB.add;
1304: RAISE FND_API.G_EXC_ERROR;
1305: END IF;
1306:
1307: FOR i in l_inventorydetails_tbl.FIRST..l_inventorydetails_tbl.LAST

Line 1313: FND_MSG_PUB.add;

1309:
1310: IF l_inventorydetails_tbl(i).Inventory_Item_ID IS NULL THEN
1311: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');
1312: FND_MESSAGE.set_token('ID', 'Inventory Item ID');
1313: FND_MSG_PUB.add;
1314: x_return_status := FND_API.G_RET_STS_ERROR;
1315: ELSE
1316: FOR get_covered_inventory_rec IN get_covered_inventory_csr(l_hdr_rec.org_id, l_hdr_rec.effective_start_date, l_hdr_rec.effective_end_date, l_inventorydetails_tbl(i).Inventory_Item_ID)
1317: LOOP

Line 1495: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

1491:
1492: WHEN OTHERS THEN
1493: x_return_status := fnd_api.g_ret_sts_unexp_error;
1494:
1495: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1496: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1497: fnd_message.set_token('ROUTINE', 'DPP_UTILITY_PVT.Get_InventoryDetails');
1498: fnd_message.set_token('ERRNO', sqlcode);
1499: fnd_message.set_token('REASON', sqlerrm);

Line 1500: FND_MSG_PUB.ADD;

1496: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1497: fnd_message.set_token('ROUTINE', 'DPP_UTILITY_PVT.Get_InventoryDetails');
1498: fnd_message.set_token('ERRNO', sqlcode);
1499: fnd_message.set_token('REASON', sqlerrm);
1500: FND_MSG_PUB.ADD;
1501: END IF;
1502:
1503: END Get_InventoryDetails;
1504:

Line 1541: FND_MSG_PUB.add;

1537: x_return_status := fnd_api.g_ret_sts_success;
1538: IF l_hdr_rec.effective_start_date IS NULL THEN
1539: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');
1540: FND_MESSAGE.set_token('ID', 'Effective Start Date');
1541: FND_MSG_PUB.add;
1542: RAISE FND_API.G_EXC_ERROR;
1543: ELSIF l_hdr_rec.effective_end_date IS NULL THEN
1544: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');
1545: FND_MESSAGE.set_token('ID', 'Effective End Date');

Line 1546: FND_MSG_PUB.add;

1542: RAISE FND_API.G_EXC_ERROR;
1543: ELSIF l_hdr_rec.effective_end_date IS NULL THEN
1544: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');
1545: FND_MESSAGE.set_token('ID', 'Effective End Date');
1546: FND_MSG_PUB.add;
1547: RAISE FND_API.G_EXC_ERROR;
1548: END IF;
1549:
1550: FOR i in l_cust_inv_tbl.FIRST..l_cust_inv_tbl.LAST

Line 1556: FND_MSG_PUB.add;

1552:
1553: IF l_cust_inv_tbl(i).Inventory_Item_ID IS NULL THEN
1554: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');
1555: FND_MESSAGE.set_token('ID', 'Inventory Item ID');
1556: FND_MSG_PUB.add;
1557: x_return_status := FND_API.G_RET_STS_ERROR;
1558: ELSIF l_cust_inv_tbl(i).Customer_ID IS NULL THEN
1559: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');
1560: FND_MESSAGE.set_token('ID', 'Customer ID');

Line 1561: FND_MSG_PUB.add;

1557: x_return_status := FND_API.G_RET_STS_ERROR;
1558: ELSIF l_cust_inv_tbl(i).Customer_ID IS NULL THEN
1559: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');
1560: FND_MESSAGE.set_token('ID', 'Customer ID');
1561: FND_MSG_PUB.add;
1562: x_return_status := FND_API.G_RET_STS_ERROR;
1563: ELSE
1564: FOR get_customer_inventory_rec IN get_customer_inventory_csr(l_hdr_rec.effective_start_date,
1565: l_hdr_rec.effective_end_date,

Line 1587: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

1583: x_return_status := FND_API.G_RET_STS_ERROR;
1584:
1585: WHEN OTHERS THEN
1586: x_return_status := fnd_api.g_ret_sts_unexp_error;
1587: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1588: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1589: fnd_message.set_token('ROUTINE', 'DPP_UTILITY_PVT.Get_CustomerInventory');
1590: fnd_message.set_token('ERRNO', sqlcode);
1591: fnd_message.set_token('REASON', sqlerrm);

Line 1592: FND_MSG_PUB.ADD;

1588: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1589: fnd_message.set_token('ROUTINE', 'DPP_UTILITY_PVT.Get_CustomerInventory');
1590: fnd_message.set_token('ERRNO', sqlcode);
1591: fnd_message.set_token('REASON', sqlerrm);
1592: FND_MSG_PUB.ADD;
1593: END IF;
1594: END Get_CustomerInventory;
1595:
1596:

Line 1642: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN

1638: BEGIN
1639: x_rec_count := 0;
1640: x_return_status := fnd_api.g_ret_sts_success;
1641: IF l_search_criteria_tbl(2).search_text IS NULL THEN
1642: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
1643: fnd_message.set_name('DPP', 'DPP_UI_LOV_NO_TRANSACTIONID');
1644: fnd_msg_pub.add;
1645: END IF;
1646: RAISE FND_API.G_EXC_ERROR;

Line 1644: fnd_msg_pub.add;

1640: x_return_status := fnd_api.g_ret_sts_success;
1641: IF l_search_criteria_tbl(2).search_text IS NULL THEN
1642: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
1643: fnd_message.set_name('DPP', 'DPP_UI_LOV_NO_TRANSACTIONID');
1644: fnd_msg_pub.add;
1645: END IF;
1646: RAISE FND_API.G_EXC_ERROR;
1647: END IF;
1648:

Line 1673: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

1669:
1670: WHEN OTHERS THEN
1671: x_return_status := fnd_api.g_ret_sts_unexp_error;
1672:
1673: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1674: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1675: fnd_message.set_token('ROUTINE', 'DPP_UTILITY_PVT.search_customers');
1676: fnd_message.set_token('ERRNO', sqlcode);
1677: fnd_message.set_token('REASON', sqlerrm);

Line 1678: FND_MSG_PUB.ADD;

1674: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1675: fnd_message.set_token('ROUTINE', 'DPP_UTILITY_PVT.search_customers');
1676: fnd_message.set_token('ERRNO', sqlcode);
1677: fnd_message.set_token('REASON', sqlerrm);
1678: FND_MSG_PUB.ADD;
1679: END IF;
1680:
1681: END search_customers;
1682:

Line 1748: FND_MSG_PUB.add;

1744: x_return_status := fnd_api.g_ret_sts_success;
1745: IF l_hdr_rec.org_id IS NULL THEN
1746: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');
1747: FND_MESSAGE.set_token('ID', 'Org ID');
1748: FND_MSG_PUB.add;
1749: RAISE FND_API.G_EXC_ERROR;
1750: END IF;
1751:
1752: FOR i in l_cust_price_tbl.FIRST..l_cust_price_tbl.LAST

Line 1758: FND_MSG_PUB.add;

1754:
1755: IF l_cust_price_tbl(i).Inventory_Item_ID IS NULL THEN
1756: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');
1757: FND_MESSAGE.set_token('ID', 'Inventory Item ID');
1758: FND_MSG_PUB.add;
1759: x_return_status := FND_API.G_RET_STS_ERROR;
1760: ELSIF l_cust_price_tbl(i).Customer_ID IS NULL THEN
1761: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');
1762: FND_MESSAGE.set_token('ID', 'Customer ID');

Line 1763: FND_MSG_PUB.add;

1759: x_return_status := FND_API.G_RET_STS_ERROR;
1760: ELSIF l_cust_price_tbl(i).Customer_ID IS NULL THEN
1761: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');
1762: FND_MESSAGE.set_token('ID', 'Customer ID');
1763: FND_MSG_PUB.add;
1764: x_return_status := FND_API.G_RET_STS_ERROR;
1765: ELSIF l_cust_price_tbl(i).UOM_Code IS NULL THEN
1766: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');
1767: FND_MESSAGE.set_token('ID', 'UOM Code');

Line 1768: FND_MSG_PUB.add;

1764: x_return_status := FND_API.G_RET_STS_ERROR;
1765: ELSIF l_cust_price_tbl(i).UOM_Code IS NULL THEN
1766: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');
1767: FND_MESSAGE.set_token('ID', 'UOM Code');
1768: FND_MSG_PUB.add;
1769: x_return_status := FND_API.G_RET_STS_ERROR;
1770: ELSIF l_cust_price_tbl(i).price_change IS NULL THEN
1771: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');
1772: FND_MESSAGE.set_token('ID', 'Price Change');

Line 1773: FND_MSG_PUB.add;

1769: x_return_status := FND_API.G_RET_STS_ERROR;
1770: ELSIF l_cust_price_tbl(i).price_change IS NULL THEN
1771: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');
1772: FND_MESSAGE.set_token('ID', 'Price Change');
1773: FND_MSG_PUB.add;
1774: x_return_status := FND_API.G_RET_STS_ERROR;
1775: ELSE
1776: FOR get_last_price_rec IN get_last_price_csr(l_hdr_rec.org_id,
1777: l_cust_price_tbl(i).Inventory_Item_ID,

Line 1832: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

1828:
1829: WHEN OTHERS THEN
1830: x_return_status := fnd_api.g_ret_sts_unexp_error;
1831:
1832: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1833: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1834: fnd_message.set_token('ROUTINE', 'DPP_UTILITY_PVT.Get_LastPrice');
1835: fnd_message.set_token('ERRNO', sqlcode);
1836: fnd_message.set_token('REASON', sqlerrm);

Line 1837: FND_MSG_PUB.ADD;

1833: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1834: fnd_message.set_token('ROUTINE', 'DPP_UTILITY_PVT.Get_LastPrice');
1835: fnd_message.set_token('ERRNO', sqlcode);
1836: fnd_message.set_token('REASON', sqlerrm);
1837: FND_MSG_PUB.ADD;
1838: END IF;
1839:
1840: END Get_LastPrice;
1841:

Line 1879: FND_MSG_PUB.add;

1875:
1876: IF l_header_rec.org_id IS NULL THEN
1877: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');
1878: FND_MESSAGE.set_token('ID', 'Org ID');
1879: FND_MSG_PUB.add;
1880: RAISE FND_API.G_EXC_ERROR;
1881: ELSIF l_header_rec.currency_code IS NULL THEN
1882: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');
1883: FND_MESSAGE.set_token('ID', 'Currency Code');

Line 1884: FND_MSG_PUB.add;

1880: RAISE FND_API.G_EXC_ERROR;
1881: ELSIF l_header_rec.currency_code IS NULL THEN
1882: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');
1883: FND_MESSAGE.set_token('ID', 'Currency Code');
1884: FND_MSG_PUB.add;
1885: RAISE FND_API.G_EXC_ERROR;
1886: END IF;
1887: po_moac_utils_pvt.set_org_context(l_header_rec.org_id);
1888:

Line 1908: FND_MSG_PUB.add;

1904:
1905: IF l_listprice_tbl(i).Inventory_Item_ID IS NULL THEN
1906: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');
1907: FND_MESSAGE.set_token('ID', 'Inventory Item ID');
1908: FND_MSG_PUB.add;
1909: x_return_status := FND_API.G_RET_STS_ERROR;
1910: ELSE
1911: FOR get_list_price_rec IN get_list_price_csr(l_header_rec.org_id, l_listprice_tbl(i).Inventory_Item_ID)
1912: LOOP

Line 1947: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

1943:
1944: WHEN OTHERS THEN
1945: x_return_status := fnd_api.g_ret_sts_unexp_error;
1946:
1947: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1948: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1949: fnd_message.set_token('ROUTINE', 'DPP_UTILITY_PVT.Get_ListPrice');
1950: fnd_message.set_token('ERRNO', sqlcode);
1951: fnd_message.set_token('REASON', sqlerrm);

Line 1952: FND_MSG_PUB.ADD;

1948: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1949: fnd_message.set_token('ROUTINE', 'DPP_UTILITY_PVT.Get_ListPrice');
1950: fnd_message.set_token('ERRNO', sqlcode);
1951: fnd_message.set_token('REASON', sqlerrm);
1952: FND_MSG_PUB.ADD;
1953: END IF;
1954:
1955:
1956: END Get_ListPrice;

Line 1982: FND_MSG_PUB.add;

1978:
1979: IF l_vendor_rec.vendor_ID IS NULL THEN
1980: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');
1981: FND_MESSAGE.set_token('ID', 'Vendor ID');
1982: FND_MSG_PUB.add;
1983: RAISE FND_API.G_EXC_ERROR;
1984: END IF;
1985: FOR get_vendor_rec IN get_vendor_csr(l_vendor_rec.vendor_ID)
1986: LOOP

Line 2001: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

1997:
1998: WHEN OTHERS THEN
1999: x_return_status := fnd_api.g_ret_sts_unexp_error;
2000:
2001: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2002: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
2003: fnd_message.set_token('ROUTINE', 'DPP_UTILITY_PVT.Get_Vendor');
2004: fnd_message.set_token('ERRNO', sqlcode);
2005: fnd_message.set_token('REASON', sqlerrm);

Line 2006: FND_MSG_PUB.ADD;

2002: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
2003: fnd_message.set_token('ROUTINE', 'DPP_UTILITY_PVT.Get_Vendor');
2004: fnd_message.set_token('ERRNO', sqlcode);
2005: fnd_message.set_token('REASON', sqlerrm);
2006: FND_MSG_PUB.ADD;
2007: END IF;
2008: END Get_Vendor;
2009:
2010: PROCEDURE Get_Vendor_Site(

Line 2042: FND_MSG_PUB.add;

2038:
2039: IF l_vendor_site_rec.vendor_ID IS NULL THEN
2040: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');
2041: FND_MESSAGE.set_token('ID', 'Vendor ID');
2042: FND_MSG_PUB.add;
2043: RAISE FND_API.G_EXC_ERROR;
2044: ELSIF l_vendor_site_rec.vendor_site_ID IS NULL THEN
2045: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');
2046: FND_MESSAGE.set_token('ID', 'Vendor Site ID');

Line 2047: FND_MSG_PUB.add;

2043: RAISE FND_API.G_EXC_ERROR;
2044: ELSIF l_vendor_site_rec.vendor_site_ID IS NULL THEN
2045: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');
2046: FND_MESSAGE.set_token('ID', 'Vendor Site ID');
2047: FND_MSG_PUB.add;
2048: RAISE FND_API.G_EXC_ERROR;
2049: END IF;
2050:
2051: FOR get_vendor_site_rec IN get_vendor_site_csr(l_vendor_site_rec.vendor_ID,l_vendor_site_rec.vendor_site_ID)

Line 2073: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

2069:
2070: WHEN OTHERS THEN
2071: x_return_status := fnd_api.g_ret_sts_unexp_error;
2072:
2073: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2074: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
2075: fnd_message.set_token('ROUTINE', 'DPP_UTILITY_PVT.Get_Vendor_Site');
2076: fnd_message.set_token('ERRNO', sqlcode);
2077: fnd_message.set_token('REASON', sqlerrm);

Line 2078: FND_MSG_PUB.ADD;

2074: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
2075: fnd_message.set_token('ROUTINE', 'DPP_UTILITY_PVT.Get_Vendor_Site');
2076: fnd_message.set_token('ERRNO', sqlcode);
2077: fnd_message.set_token('REASON', sqlerrm);
2078: FND_MSG_PUB.ADD;
2079: END IF;
2080: END Get_Vendor_Site;
2081:
2082: PROCEDURE Get_Vendor_Contact(

Line 2113: FND_MSG_PUB.add;

2109:
2110: IF l_vendor_contact_rec.vendor_site_ID IS NULL THEN
2111: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');
2112: FND_MESSAGE.set_token('ID', 'Vendor Site ID');
2113: FND_MSG_PUB.add;
2114: RAISE FND_API.G_EXC_ERROR;
2115: ELSIF l_vendor_contact_rec.vendor_contact_ID IS NULL THEN
2116: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');
2117: FND_MESSAGE.set_token('ID', 'Vendor Contact ID');

Line 2118: FND_MSG_PUB.add;

2114: RAISE FND_API.G_EXC_ERROR;
2115: ELSIF l_vendor_contact_rec.vendor_contact_ID IS NULL THEN
2116: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');
2117: FND_MESSAGE.set_token('ID', 'Vendor Contact ID');
2118: FND_MSG_PUB.add;
2119: RAISE FND_API.G_EXC_ERROR;
2120: END IF;
2121:
2122: FOR get_vendor_contact_rec IN get_vendor_contact_csr(l_vendor_contact_rec.vendor_site_ID,l_vendor_contact_rec.vendor_contact_ID)

Line 2143: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

2139:
2140: WHEN OTHERS THEN
2141: x_return_status := fnd_api.g_ret_sts_unexp_error;
2142:
2143: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2144: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
2145: fnd_message.set_token('ROUTINE', 'DPP_UTILITY_PVT.Get_Vendor_Contact');
2146: fnd_message.set_token('ERRNO', sqlcode);
2147: fnd_message.set_token('REASON', sqlerrm);

Line 2148: FND_MSG_PUB.ADD;

2144: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
2145: fnd_message.set_token('ROUTINE', 'DPP_UTILITY_PVT.Get_Vendor_Contact');
2146: fnd_message.set_token('ERRNO', sqlcode);
2147: fnd_message.set_token('REASON', sqlerrm);
2148: FND_MSG_PUB.ADD;
2149: END IF;
2150: END Get_Vendor_Contact;
2151:
2152: PROCEDURE Get_Warehouse(

Line 2181: FND_MSG_PUB.add;

2177: LOOP
2178: IF l_warehouse_tbl(i).warehouse_id IS NULL THEN
2179: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');
2180: FND_MESSAGE.set_token('ID', 'Warehouse ID');
2181: FND_MSG_PUB.add;
2182: x_return_status := FND_API.G_RET_STS_ERROR;
2183: ELSE
2184: FOR get_warehouse_rec IN get_warehouse_csr(l_warehouse_tbl(i).warehouse_id)
2185: LOOP

Line 2205: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

2201: x_return_status := FND_API.G_RET_STS_ERROR;
2202: WHEN OTHERS THEN
2203: x_return_status := fnd_api.g_ret_sts_unexp_error;
2204:
2205: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2206: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
2207: fnd_message.set_token('ROUTINE', 'DPP_UTILITY_PVT.Get_Warehouse');
2208: fnd_message.set_token('ERRNO', sqlcode);
2209: fnd_message.set_token('REASON', sqlerrm);

Line 2210: FND_MSG_PUB.ADD;

2206: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
2207: fnd_message.set_token('ROUTINE', 'DPP_UTILITY_PVT.Get_Warehouse');
2208: fnd_message.set_token('ERRNO', sqlcode);
2209: fnd_message.set_token('REASON', sqlerrm);
2210: FND_MSG_PUB.ADD;
2211: END IF;
2212: END Get_Warehouse;
2213:
2214: PROCEDURE Get_Customer(

Line 2240: FND_MSG_PUB.add;

2236:
2237: IF l_customer_tbl(i).customer_id IS NULL THEN
2238: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');
2239: FND_MESSAGE.set_token('ID', 'Customer ID');
2240: FND_MSG_PUB.add;
2241: x_return_status := FND_API.G_RET_STS_ERROR;
2242: ELSE
2243:
2244: FOR get_customer_rec IN get_customer_csr(l_customer_tbl(i).customer_id)

Line 2264: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

2260:
2261: EXCEPTION
2262: WHEN OTHERS THEN
2263: x_return_status := fnd_api.g_ret_sts_unexp_error;
2264: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2265: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
2266: fnd_message.set_token('ROUTINE', 'DPP_UTILITY_PVT.Get_Customer');
2267: fnd_message.set_token('ERRNO', sqlcode);
2268: fnd_message.set_token('REASON', sqlerrm);

Line 2269: FND_MSG_PUB.ADD;

2265: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
2266: fnd_message.set_token('ROUTINE', 'DPP_UTILITY_PVT.Get_Customer');
2267: fnd_message.set_token('ERRNO', sqlcode);
2268: fnd_message.set_token('REASON', sqlerrm);
2269: FND_MSG_PUB.ADD;
2270: END IF;
2271: END Get_Customer;
2272:
2273: PROCEDURE Get_Product(

Line 2300: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN

2296:
2297: IF (p_org_id IS NOT NULL) THEN
2298: l_org_id := p_org_id;
2299: ELSE
2300: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
2301: fnd_message.set_name('DPP', 'DPP_ORG_ID_NOTFOUND');
2302: fnd_msg_pub.add;
2303: END IF;
2304:

Line 2302: fnd_msg_pub.add;

2298: l_org_id := p_org_id;
2299: ELSE
2300: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
2301: fnd_message.set_name('DPP', 'DPP_ORG_ID_NOTFOUND');
2302: fnd_msg_pub.add;
2303: END IF;
2304:
2305: RAISE fnd_api.g_exc_error;
2306: END IF;

Line 2321: FND_MSG_PUB.add;

2317:
2318: IF l_item_tbl(i).inventory_item_id IS NULL THEN
2319: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');
2320: FND_MESSAGE.set_token('ID', 'Inventory Item ID');
2321: FND_MSG_PUB.add;
2322: x_return_status := FND_API.G_RET_STS_ERROR;
2323:
2324: ELSE
2325:

Line 2344: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

2340: EXCEPTION
2341: WHEN OTHERS THEN
2342: x_return_status := fnd_api.g_ret_sts_unexp_error;
2343:
2344: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2345: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
2346: fnd_message.set_token('ROUTINE', 'DPP_UTILITY_PVT.Get_Product');
2347: fnd_message.set_token('ERRNO', sqlcode);
2348: fnd_message.set_token('REASON', sqlerrm);

Line 2349: FND_MSG_PUB.ADD;

2345: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
2346: fnd_message.set_token('ROUTINE', 'DPP_UTILITY_PVT.Get_Product');
2347: fnd_message.set_token('ERRNO', sqlcode);
2348: fnd_message.set_token('REASON', sqlerrm);
2349: FND_MSG_PUB.ADD;
2350: END IF;
2351: END Get_Product;
2352:
2353: --To be used incase we are storing the log messages in the fnd_log_messages table

Line 2385: FND_MSG_PUB.add;

2381: COMMIT;
2382:
2383: FND_MESSAGE.set_name('DPP', 'DPP_API_DEBUG_MESSAGE');
2384: FND_MESSAGE.set_token('TEXT', REPLACE (p_message_text, FND_API.G_MISS_CHAR, 'G_MISS_CHAR'));
2385: FND_MSG_PUB.add;
2386:
2387: END debug_message;
2388:
2389: PROCEDURE error_message(

Line 2396: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

2392: P_token_value VARCHAR2 := NULL
2393: )
2394: IS
2395: BEGIN
2396: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2397: FND_MESSAGE.set_name('DPP', p_message_name);
2398: IF p_token_name IS NOT NULL THEN
2399: FND_MESSAGE.set_token(p_token_name, p_token_value);
2400: END IF;

Line 2401: FND_MSG_PUB.add;

2397: FND_MESSAGE.set_name('DPP', p_message_name);
2398: IF p_token_name IS NOT NULL THEN
2399: FND_MESSAGE.set_token(p_token_name, p_token_value);
2400: END IF;
2401: FND_MSG_PUB.add;
2402: END IF;
2403: END error_message;
2404:
2405: PROCEDURE get_EmailAddress(

Line 2426: FND_MSG_PUB.add;

2422:
2423: IF l_user_id IS NULL THEN
2424: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');
2425: FND_MESSAGE.set_token('ID', 'User ID');
2426: FND_MSG_PUB.add;
2427: RAISE FND_API.G_EXC_ERROR;
2428: ELSE
2429:
2430: FOR Get_Mail_ID_rec IN Get_Mail_ID_csr(l_user_id)

Line 2447: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

2443: x_return_status := FND_API.G_RET_STS_ERROR;
2444: WHEN OTHERS THEN
2445: x_return_status := fnd_api.g_ret_sts_unexp_error;
2446:
2447: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2448: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
2449: fnd_message.set_token('ROUTINE', 'DPP_UTILITY_PVT.get_EmailAddress');
2450: fnd_message.set_token('ERRNO', sqlcode);
2451: fnd_message.set_token('REASON', sqlerrm);

Line 2452: FND_MSG_PUB.ADD;

2448: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
2449: fnd_message.set_token('ROUTINE', 'DPP_UTILITY_PVT.get_EmailAddress');
2450: fnd_message.set_token('ERRNO', sqlcode);
2451: fnd_message.set_token('REASON', sqlerrm);
2452: FND_MSG_PUB.ADD;
2453: END IF;
2454: END get_EmailAddress;
2455:
2456: PROCEDURE convert_currency(

Line 2487: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN

2483: -- Get the currency conversion type from profile option
2484: l_conversion_type := fnd_profile.VALUE(l_conversion_type_profile);
2485: -- Conversion type cannot be null in profile
2486: IF l_conversion_type IS NULL THEN
2487: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
2488: fnd_message.set_name('DPP', 'DPP_NO_EXCHANGE_TYPE');
2489: fnd_msg_pub.add;
2490: END IF;
2491: x_return_status := fnd_api.g_ret_sts_error;

Line 2489: fnd_msg_pub.add;

2485: -- Conversion type cannot be null in profile
2486: IF l_conversion_type IS NULL THEN
2487: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
2488: fnd_message.set_name('DPP', 'DPP_NO_EXCHANGE_TYPE');
2489: fnd_msg_pub.add;
2490: END IF;
2491: x_return_status := fnd_api.g_ret_sts_error;
2492: RETURN;
2493: END IF;

Line 2515: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN

2511: --
2512:
2513: EXCEPTION
2514: WHEN gl_currency_api.no_rate THEN
2515: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
2516: fnd_message.set_name('DPP', 'DPP_NO_RATE');
2517: fnd_message.set_token('CURRENCY_FROM', p_from_currency);
2518: fnd_message.set_token('CURRENCY_TO', p_to_currency);
2519: fnd_msg_pub.add;

Line 2519: fnd_msg_pub.add;

2515: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
2516: fnd_message.set_name('DPP', 'DPP_NO_RATE');
2517: fnd_message.set_token('CURRENCY_FROM', p_from_currency);
2518: fnd_message.set_token('CURRENCY_TO', p_to_currency);
2519: fnd_msg_pub.add;
2520: END IF;
2521:
2522: x_return_status := fnd_api.g_ret_sts_error;
2523: WHEN gl_currency_api.invalid_currency THEN

Line 2524: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN

2520: END IF;
2521:
2522: x_return_status := fnd_api.g_ret_sts_error;
2523: WHEN gl_currency_api.invalid_currency THEN
2524: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
2525: fnd_message.set_name('DPP', 'DPP_INVALID_CURR');
2526: fnd_message.set_token('CURRENCY_FROM', p_from_currency);
2527: fnd_message.set_token('CURRENCY_TO', p_to_currency);
2528: fnd_msg_pub.add;

Line 2528: fnd_msg_pub.add;

2524: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
2525: fnd_message.set_name('DPP', 'DPP_INVALID_CURR');
2526: fnd_message.set_token('CURRENCY_FROM', p_from_currency);
2527: fnd_message.set_token('CURRENCY_TO', p_to_currency);
2528: fnd_msg_pub.add;
2529: END IF;
2530:
2531: x_return_status := fnd_api.g_ret_sts_error;
2532: WHEN OTHERS THEN

Line 2538: FND_MSG_PUB.ADD;

2534: FND_MESSAGE.SET_NAME('FND', 'SQL_PLSQL_ERROR');
2535: FND_MESSAGE.SET_TOKEN('ROUTINE', 'DPP_UTILITY_PVT.convert_currency');
2536: FND_MESSAGE.SET_TOKEN('ERRNO', sqlcode);
2537: FND_MESSAGE.SET_TOKEN('REASON', sqlerrm);
2538: FND_MSG_PUB.ADD;
2539: DPP_UTILITY_PVT.debug_message(sqlerrm);
2540:
2541: END convert_currency;
2542:

Line 2589: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN

2585: l_conversion_type := x_exchange_rate_type;
2586: END IF;
2587:
2588: IF l_conversion_type IS NULL THEN
2589: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
2590: fnd_message.set_name('DPP', 'DPP_NO_EXCHANGE_TYPE');
2591: fnd_msg_pub.add;
2592: END IF;
2593:

Line 2591: fnd_msg_pub.add;

2587:
2588: IF l_conversion_type IS NULL THEN
2589: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
2590: fnd_message.set_name('DPP', 'DPP_NO_EXCHANGE_TYPE');
2591: fnd_msg_pub.add;
2592: END IF;
2593:
2594: x_return_status := fnd_api.g_ret_sts_error;
2595: RETURN;

Line 2601: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN

2597: IF ozf_utility_pvt.check_fk_exists('GL_DAILY_CONVERSION_TYPES',
2598: 'CONVERSION_TYPE'
2599: ,l_conversion_type) = fnd_api.g_false
2600: THEN
2601: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
2602: fnd_message.set_name('DPP', 'DPP_WRONG_CONVERSION_TYPE');
2603: fnd_msg_pub.add;
2604: END IF;
2605: x_return_status := fnd_api.g_ret_sts_error;

Line 2603: fnd_msg_pub.add;

2599: ,l_conversion_type) = fnd_api.g_false
2600: THEN
2601: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
2602: fnd_message.set_name('DPP', 'DPP_WRONG_CONVERSION_TYPE');
2603: fnd_msg_pub.add;
2604: END IF;
2605: x_return_status := fnd_api.g_ret_sts_error;
2606: RETURN;
2607: END IF;

Line 2619: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN

2615:
2616: l_org_id := MO_GLOBAL.GET_CURRENT_ORG_ID();
2617:
2618: IF l_org_id IS NULL THEN
2619: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
2620: fnd_message.set_name('DPP', 'DPP_ORG_ID_NOTFOUND');
2621: fnd_msg_pub.add;
2622: END IF;
2623:

Line 2621: fnd_msg_pub.add;

2617:
2618: IF l_org_id IS NULL THEN
2619: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
2620: fnd_message.set_name('DPP', 'DPP_ORG_ID_NOTFOUND');
2621: fnd_msg_pub.add;
2622: END IF;
2623:
2624: RAISE fnd_api.g_exc_error;
2625: END IF;

Line 2638: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN

2634: OPEN c_get_gl_info(l_org_id);
2635: FETCH c_get_gl_info INTO x_set_of_books_id, x_fc_currency_code;
2636:
2637: IF c_get_gl_info%NOTFOUND THEN
2638: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
2639: fnd_message.set_name('DPP', 'DPP_GL_SOB_NOTFOUND');
2640: fnd_msg_pub.add;
2641: END IF;
2642:

Line 2640: fnd_msg_pub.add;

2636:
2637: IF c_get_gl_info%NOTFOUND THEN
2638: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
2639: fnd_message.set_name('DPP', 'DPP_GL_SOB_NOTFOUND');
2640: fnd_msg_pub.add;
2641: END IF;
2642:
2643: RAISE fnd_api.g_exc_error;
2644: END IF;

Line 2668: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN

2664: EXCEPTION
2665: WHEN fnd_api.g_exc_error THEN
2666: x_return_status := fnd_api.g_ret_sts_error;
2667: WHEN gl_currency_api.no_rate THEN
2668: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
2669: fnd_message.set_name('DPP', 'DPP_NO_RATE');
2670: fnd_msg_pub.add;
2671: END IF;
2672:

Line 2670: fnd_msg_pub.add;

2666: x_return_status := fnd_api.g_ret_sts_error;
2667: WHEN gl_currency_api.no_rate THEN
2668: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
2669: fnd_message.set_name('DPP', 'DPP_NO_RATE');
2670: fnd_msg_pub.add;
2671: END IF;
2672:
2673: x_return_status := fnd_api.g_ret_sts_error;
2674: WHEN gl_currency_api.invalid_currency THEN

Line 2675: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN

2671: END IF;
2672:
2673: x_return_status := fnd_api.g_ret_sts_error;
2674: WHEN gl_currency_api.invalid_currency THEN
2675: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
2676: fnd_message.set_name('DPP', 'DPP_INVALID_CURR');
2677: fnd_msg_pub.add;
2678: END IF;
2679:

Line 2677: fnd_msg_pub.add;

2673: x_return_status := fnd_api.g_ret_sts_error;
2674: WHEN gl_currency_api.invalid_currency THEN
2675: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
2676: fnd_message.set_name('DPP', 'DPP_INVALID_CURR');
2677: fnd_msg_pub.add;
2678: END IF;
2679:
2680: x_return_status := fnd_api.g_ret_sts_error;
2681: WHEN OTHERS THEN

Line 2684: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

2680: x_return_status := fnd_api.g_ret_sts_error;
2681: WHEN OTHERS THEN
2682: x_return_status := fnd_api.g_ret_sts_unexp_error;
2683:
2684: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2685: FND_MESSAGE.SET_NAME('FND', 'SQL_PLSQL_ERROR');
2686: FND_MESSAGE.SET_TOKEN('ROUTINE', 'DPP_UTILITY_PVT.Convert_functional_curr');
2687: FND_MESSAGE.SET_TOKEN('ERRNO', sqlcode);
2688: FND_MESSAGE.SET_TOKEN('REASON', sqlerrm);

Line 2689: FND_MSG_PUB.ADD;

2685: FND_MESSAGE.SET_NAME('FND', 'SQL_PLSQL_ERROR');
2686: FND_MESSAGE.SET_TOKEN('ROUTINE', 'DPP_UTILITY_PVT.Convert_functional_curr');
2687: FND_MESSAGE.SET_TOKEN('ERRNO', sqlcode);
2688: FND_MESSAGE.SET_TOKEN('REASON', sqlerrm);
2689: FND_MSG_PUB.ADD;
2690: END IF;
2691: END calculate_functional_curr;
2692: END DPP_UTILITY_PVT;