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_MESSAGE

Line 43: fnd_message.set_name('DPP', 'DPP_EXE_PROCESS_REQUESTED');

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;
47: EXCEPTION WHEN OTHERS THEN

Line 44: fnd_message.set_token('PROCESS_CODE', l_process_code);

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;
47: EXCEPTION WHEN OTHERS THEN
48: NULL;

Line 62: fnd_message.set_name('DPP', 'DPP_EXE_PROCESS_REQUESTED');

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;
66: EXCEPTION WHEN OTHERS THEN

Line 63: fnd_message.set_token('PROCESS_CODE', l_process_code);

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;
66: EXCEPTION WHEN OTHERS THEN
67: NULL;

Line 81: fnd_message.set_name('DPP', 'DPP_EXE_PROCESS_REQUESTED');

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;
85: EXCEPTION WHEN OTHERS THEN

Line 82: fnd_message.set_token('PROCESS_CODE', l_process_code);

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;
85: EXCEPTION WHEN OTHERS THEN
86: NULL;

Line 101: fnd_message.set_name('DPP', 'DPP_EXE_PROCESS_REQUESTED');

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;
105: EXCEPTION WHEN OTHERS THEN

Line 102: fnd_message.set_token('PROCESS_CODE', l_process_code);

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;
105: EXCEPTION WHEN OTHERS THEN
106: NULL;

Line 120: fnd_message.set_name('DPP', 'DPP_EXE_PROCESS_REQUESTED');

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;
124: EXCEPTION WHEN OTHERS THEN

Line 121: fnd_message.set_token('PROCESS_CODE', l_process_code);

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;
124: EXCEPTION WHEN OTHERS THEN
125: NULL;

Line 139: fnd_message.set_name('DPP', 'DPP_EXE_PROCESS_REQUESTED');

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;
143: EXCEPTION WHEN OTHERS THEN

Line 140: fnd_message.set_token('PROCESS_CODE', l_process_code);

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;
143: EXCEPTION WHEN OTHERS THEN
144: NULL;

Line 158: fnd_message.set_name('DPP', 'DPP_EXE_PROCESS_REQUESTED');

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;
162: EXCEPTION WHEN OTHERS THEN

Line 159: fnd_message.set_token('PROCESS_CODE', l_process_code);

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;
162: EXCEPTION WHEN OTHERS THEN
163: NULL;

Line 176: fnd_message.set_name('DPP', 'DPP_EXE_PROCESS_REQUESTED');

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;
180: EXCEPTION WHEN OTHERS THEN

Line 177: fnd_message.set_token('PROCESS_CODE', l_process_code);

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;
180: EXCEPTION WHEN OTHERS THEN
181: NULL;

Line 195: fnd_message.set_name('DPP', 'DPP_EXE_PROCESS_REQUESTED');

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;
199: EXCEPTION WHEN OTHERS THEN

Line 196: fnd_message.set_token('PROCESS_CODE', l_process_code);

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;
199: EXCEPTION WHEN OTHERS THEN
200: NULL;

Line 205: fnd_message.set_name('DPP', 'DPP_TXN_NOT_CANCELLED');

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;
209: END IF;

Line 223: fnd_message.set_name('DPP', 'DPP_EXE_PROCESS_INCOMPLETE');

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;
227: EXCEPTION WHEN OTHERS THEN

Line 224: fnd_message.set_token('PROCESS_CODE', l_process_code);

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;
227: EXCEPTION WHEN OTHERS THEN
228: NULL;

Line 241: fnd_message.set_name('DPP', 'DPP_EXE_PROCESS_INCOMPLETE');

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;
245: EXCEPTION WHEN OTHERS THEN

Line 242: fnd_message.set_token('PROCESS_CODE', l_process_code);

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;
245: EXCEPTION WHEN OTHERS THEN
246: NULL;

Line 261: fnd_message.set_name('DPP', 'DPP_EXE_PROCESS_INCOMPLETE');

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;
265: EXCEPTION WHEN OTHERS THEN

Line 262: fnd_message.set_token('PROCESS_CODE', l_process_code);

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;
265: EXCEPTION WHEN OTHERS THEN
266: NULL;

Line 280: fnd_message.set_name('DPP', 'DPP_EXE_PROCESS_INCOMPLETE');

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;
284: EXCEPTION WHEN OTHERS THEN

Line 281: fnd_message.set_token('PROCESS_CODE', l_process_code);

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;
284: EXCEPTION WHEN OTHERS THEN
285: NULL;

Line 299: fnd_message.set_name('DPP', 'DPP_EXE_PROCESS_INCOMPLETE');

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;
303: EXCEPTION WHEN OTHERS THEN

Line 300: fnd_message.set_token('PROCESS_CODE', l_process_code);

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;
303: EXCEPTION WHEN OTHERS THEN
304: NULL;

Line 318: fnd_message.set_name('DPP', 'DPP_EXE_PROCESS_INCOMPLETE');

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;
322: EXCEPTION WHEN OTHERS THEN

Line 319: fnd_message.set_token('PROCESS_CODE', l_process_code);

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;
322: EXCEPTION WHEN OTHERS THEN
323: NULL;

Line 337: fnd_message.set_name('DPP', 'DPP_EXE_PROCESS_INCOMPLETE');

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;
341: EXCEPTION WHEN OTHERS THEN

Line 338: fnd_message.set_token('PROCESS_CODE', l_process_code);

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;
341: EXCEPTION WHEN OTHERS THEN
342: NULL;

Line 356: fnd_message.set_name('DPP', 'DPP_EXE_PROCESS_INCOMPLETE');

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;
360: EXCEPTION WHEN OTHERS THEN

Line 357: fnd_message.set_token('PROCESS_CODE', l_process_code);

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;
360: EXCEPTION WHEN OTHERS THEN
361: NULL;

Line 367: fnd_message.set_name('DPP', 'DPP_CLAIM_NOT_CLOSED');

363:
364: FOR select_claims_rec IN select_claims_csr(p_transaction_header_id)
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;

Line 368: fnd_message.set_token('CLAIM_NUMBER',select_claims_rec.claim_number );

364: FOR select_claims_rec IN select_claims_csr(p_transaction_header_id)
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

Line 374: fnd_message.set_name('DPP', 'DPP_TXN_NOT_CLOSED');

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;
378: END IF;

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

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);
391: FND_MSG_PUB.ADD;

Line 388: fnd_message.set_token('ROUTINE', 'DPP_UTILITY_PVT.check_txnclose');

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);
391: FND_MSG_PUB.ADD;
392: END IF;

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

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);
391: FND_MSG_PUB.ADD;
392: END IF;
393: END Check_Transaction;

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

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);
391: FND_MSG_PUB.ADD;
392: END IF;
393: END Check_Transaction;
394:

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

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);
449: FND_MSG_PUB.ADD;

Line 446: fnd_message.set_token('ROUTINE', 'DPP_UTILITY_PVT.search_vendors');

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);
449: FND_MSG_PUB.ADD;
450: END IF;

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

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);
449: FND_MSG_PUB.ADD;
450: END IF;
451:

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

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);
449: FND_MSG_PUB.ADD;
450: END IF;
451:
452: END search_vendors;

Line 501: fnd_message.set_name('DPP', 'DPP_UI_LOV_NO_VENDORID');

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;
505:

Line 508: fnd_message.set_name('DPP', 'DPP_UI_LOV_NO_ORGID');

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;
512: END IF;

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

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);
544: FND_MSG_PUB.ADD;

Line 541: fnd_message.set_token('ROUTINE', 'DPP_UTILITY_PVT.search_vendor_sites');

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);
544: FND_MSG_PUB.ADD;
545: END IF;

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

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);
544: FND_MSG_PUB.ADD;
545: END IF;
546:

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

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);
544: FND_MSG_PUB.ADD;
545: END IF;
546:
547: END search_vendor_sites;

Line 592: fnd_message.set_name('DPP', 'DPP_UI_LOV_NO_VENDORSITEID');

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:
596: RAISE fnd_api.g_exc_error;

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

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);
626: FND_MSG_PUB.ADD;

Line 623: fnd_message.set_token('ROUTINE', 'DPP_UTILITY_PVT.search_vendor_contacts');

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);
626: FND_MSG_PUB.ADD;
627: END IF;

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

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);
626: FND_MSG_PUB.ADD;
627: END IF;
628:

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

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);
626: FND_MSG_PUB.ADD;
627: END IF;
628:
629: END search_vendor_contacts;

Line 729: fnd_message.set_name('DPP', 'DPP_UI_LOV_NO_ORGID');

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:
733: RAISE fnd_api.g_exc_error;

Line 736: fnd_message.set_name('DPP', 'DPP_UI_LOV_NO_VENDORID');

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;
740: ELSIF l_search_criteria_tbl(4).search_text IS NULL THEN

Line 742: fnd_message.set_name('DPP', 'DPP_UI_LOV_NO_VENDORSITEID');

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;
746: END IF;

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_UTILITY_PVT.search_items');
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_UTILITY_PVT.search_items');

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);
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_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:

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_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;

Line 895: fnd_message.set_name('DPP', 'DPP_UI_LOV_NO_TRANSACTIONID');

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:
899: RAISE fnd_api.g_exc_error;

Line 902: fnd_message.set_name('DPP', 'DPP_UI_LOV_NO_CUST_ACCT_ID');

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;
906: END IF;

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

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);
940: FND_MSG_PUB.ADD;

Line 937: fnd_message.set_token('ROUTINE', 'DPP_UTILITY_PVT.search_customer_items');

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);
940: FND_MSG_PUB.ADD;
941: END IF;

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

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);
940: FND_MSG_PUB.ADD;
941: END IF;
942:

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

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);
940: FND_MSG_PUB.ADD;
941: END IF;
942:
943: END search_customer_items;

Line 978: fnd_message.set_name('DPP', 'DPP_UI_LOV_NO_ORGID');

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:
982: RAISE FND_API.G_EXC_ERROR;

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

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);
1014: FND_MSG_PUB.ADD;

Line 1011: fnd_message.set_token('ROUTINE', 'DPP_UTILITY_PVT.search_warehouses');

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);
1014: FND_MSG_PUB.ADD;
1015: END IF;

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

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);
1014: FND_MSG_PUB.ADD;
1015: END IF;
1016: END search_warehouses;

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

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);
1014: FND_MSG_PUB.ADD;
1015: END IF;
1016: END search_warehouses;
1017:

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

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);
1187: FND_MSG_PUB.ADD;

Line 1184: fnd_message.set_token('ROUTINE', 'DPP_UTILITY_PVT.Get_CoveredInventory');

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);
1187: FND_MSG_PUB.ADD;
1188: END IF;

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

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);
1187: FND_MSG_PUB.ADD;
1188: END IF;
1189:

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

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);
1187: FND_MSG_PUB.ADD;
1188: END IF;
1189:
1190: END Get_CoveredInventory;

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

1287:
1288: x_rec_count := 0;
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

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

1288: x_rec_count := 0;
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');

Line 1296: 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');
1298: FND_MSG_PUB.add;
1299: RAISE FND_API.G_EXC_ERROR;
1300: ELSIF l_hdr_rec.effective_end_date IS NULL THEN

Line 1297: FND_MESSAGE.set_token('ID', 'Effective Start Date');

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');
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');

Line 1301: 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');
1303: FND_MSG_PUB.add;
1304: RAISE FND_API.G_EXC_ERROR;
1305: END IF;

Line 1302: FND_MESSAGE.set_token('ID', 'Effective End 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');
1303: FND_MSG_PUB.add;
1304: RAISE FND_API.G_EXC_ERROR;
1305: END IF;
1306:

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

1307: FOR i in l_inventorydetails_tbl.FIRST..l_inventorydetails_tbl.LAST
1308: LOOP
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

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

1308: LOOP
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)

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

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);
1500: FND_MSG_PUB.ADD;

Line 1497: fnd_message.set_token('ROUTINE', 'DPP_UTILITY_PVT.Get_InventoryDetails');

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);
1500: FND_MSG_PUB.ADD;
1501: END IF;

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

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);
1500: FND_MSG_PUB.ADD;
1501: END IF;
1502:

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

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);
1500: FND_MSG_PUB.ADD;
1501: END IF;
1502:
1503: END Get_InventoryDetails;

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

1535:
1536: x_rec_count := 0;
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

Line 1540: FND_MESSAGE.set_token('ID', 'Effective Start Date');

1536: x_rec_count := 0;
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');

Line 1544: 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');
1546: FND_MSG_PUB.add;
1547: RAISE FND_API.G_EXC_ERROR;
1548: END IF;

Line 1545: FND_MESSAGE.set_token('ID', 'Effective End 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');
1546: FND_MSG_PUB.add;
1547: RAISE FND_API.G_EXC_ERROR;
1548: END IF;
1549:

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

1550: FOR i in l_cust_inv_tbl.FIRST..l_cust_inv_tbl.LAST
1551: LOOP
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

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

1551: LOOP
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');

Line 1559: 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');
1561: FND_MSG_PUB.add;
1562: x_return_status := FND_API.G_RET_STS_ERROR;
1563: ELSE

Line 1560: FND_MESSAGE.set_token('ID', 'Customer 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');
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,

Line 1588: fnd_message.set_name('FND', 'SQL_PLSQL_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);
1592: FND_MSG_PUB.ADD;

Line 1589: fnd_message.set_token('ROUTINE', 'DPP_UTILITY_PVT.Get_CustomerInventory');

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);
1592: FND_MSG_PUB.ADD;
1593: END IF;

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

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);
1592: FND_MSG_PUB.ADD;
1593: END IF;
1594: END Get_CustomerInventory;

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

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);
1592: FND_MSG_PUB.ADD;
1593: END IF;
1594: END Get_CustomerInventory;
1595:

Line 1643: fnd_message.set_name('DPP', 'DPP_UI_LOV_NO_TRANSACTIONID');

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;
1647: END IF;

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

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);
1678: FND_MSG_PUB.ADD;

Line 1675: fnd_message.set_token('ROUTINE', 'DPP_UTILITY_PVT.search_customers');

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);
1678: FND_MSG_PUB.ADD;
1679: END IF;

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

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);
1678: FND_MSG_PUB.ADD;
1679: END IF;
1680:

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

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);
1678: FND_MSG_PUB.ADD;
1679: END IF;
1680:
1681: END search_customers;

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

1742:
1743: x_rec_count := 0;
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;

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

1743: x_rec_count := 0;
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:

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

1752: FOR i in l_cust_price_tbl.FIRST..l_cust_price_tbl.LAST
1753: LOOP
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

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

1753: LOOP
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');

Line 1761: 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');
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

Line 1762: FND_MESSAGE.set_token('ID', 'Customer 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');
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');

Line 1766: 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');
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

Line 1767: FND_MESSAGE.set_token('ID', 'UOM Code');

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');
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');

Line 1771: 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');
1773: FND_MSG_PUB.add;
1774: x_return_status := FND_API.G_RET_STS_ERROR;
1775: ELSE

Line 1772: FND_MESSAGE.set_token('ID', 'Price Change');

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');
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,

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

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);
1837: FND_MSG_PUB.ADD;

Line 1834: fnd_message.set_token('ROUTINE', 'DPP_UTILITY_PVT.Get_LastPrice');

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);
1837: FND_MSG_PUB.ADD;
1838: END IF;

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

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);
1837: FND_MSG_PUB.ADD;
1838: END IF;
1839:

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

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);
1837: FND_MSG_PUB.ADD;
1838: END IF;
1839:
1840: END Get_LastPrice;

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

1873: x_rec_count := 0;
1874: x_return_status := fnd_api.g_ret_sts_success;
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

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

1874: x_return_status := fnd_api.g_ret_sts_success;
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');

Line 1882: 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');
1884: FND_MSG_PUB.add;
1885: RAISE FND_API.G_EXC_ERROR;
1886: END IF;

Line 1883: FND_MESSAGE.set_token('ID', 'Currency Code');

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');
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);

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

1902: FOR i in l_listprice_tbl.FIRST..l_listprice_tbl.LAST
1903: LOOP
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

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

1903: LOOP
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)

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

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);
1952: FND_MSG_PUB.ADD;

Line 1949: fnd_message.set_token('ROUTINE', 'DPP_UTILITY_PVT.Get_ListPrice');

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);
1952: FND_MSG_PUB.ADD;
1953: END IF;

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

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);
1952: FND_MSG_PUB.ADD;
1953: END IF;
1954:

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

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);
1952: FND_MSG_PUB.ADD;
1953: END IF;
1954:
1955:

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

1976: x_rec_count := 0;
1977: x_return_status := fnd_api.g_ret_sts_success;
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;

Line 1981: FND_MESSAGE.set_token('ID', 'Vendor ID');

1977: x_return_status := fnd_api.g_ret_sts_success;
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)

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

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);
2006: FND_MSG_PUB.ADD;

Line 2003: fnd_message.set_token('ROUTINE', 'DPP_UTILITY_PVT.Get_Vendor');

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);
2006: FND_MSG_PUB.ADD;
2007: END IF;

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

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);
2006: FND_MSG_PUB.ADD;
2007: END IF;
2008: END Get_Vendor;

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

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);
2006: FND_MSG_PUB.ADD;
2007: END IF;
2008: END Get_Vendor;
2009:

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

2036: x_rec_count := 0;
2037: x_return_status := fnd_api.g_ret_sts_success;
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

Line 2041: FND_MESSAGE.set_token('ID', 'Vendor ID');

2037: x_return_status := fnd_api.g_ret_sts_success;
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');

Line 2045: 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');
2047: FND_MSG_PUB.add;
2048: RAISE FND_API.G_EXC_ERROR;
2049: END IF;

Line 2046: FND_MESSAGE.set_token('ID', 'Vendor Site 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');
2047: FND_MSG_PUB.add;
2048: RAISE FND_API.G_EXC_ERROR;
2049: END IF;
2050:

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

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);
2078: FND_MSG_PUB.ADD;

Line 2075: fnd_message.set_token('ROUTINE', 'DPP_UTILITY_PVT.Get_Vendor_Site');

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);
2078: FND_MSG_PUB.ADD;
2079: END IF;

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

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);
2078: FND_MSG_PUB.ADD;
2079: END IF;
2080: END Get_Vendor_Site;

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

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);
2078: FND_MSG_PUB.ADD;
2079: END IF;
2080: END Get_Vendor_Site;
2081:

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

2107: x_rec_count := 0;
2108: x_return_status := fnd_api.g_ret_sts_success;
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

Line 2112: FND_MESSAGE.set_token('ID', 'Vendor Site ID');

2108: x_return_status := fnd_api.g_ret_sts_success;
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');

Line 2116: 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');
2118: FND_MSG_PUB.add;
2119: RAISE FND_API.G_EXC_ERROR;
2120: END IF;

Line 2117: FND_MESSAGE.set_token('ID', 'Vendor Contact 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');
2118: FND_MSG_PUB.add;
2119: RAISE FND_API.G_EXC_ERROR;
2120: END IF;
2121:

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

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);
2148: FND_MSG_PUB.ADD;

Line 2145: fnd_message.set_token('ROUTINE', 'DPP_UTILITY_PVT.Get_Vendor_Contact');

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);
2148: FND_MSG_PUB.ADD;
2149: END IF;

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

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);
2148: FND_MSG_PUB.ADD;
2149: END IF;
2150: END Get_Vendor_Contact;

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

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);
2148: FND_MSG_PUB.ADD;
2149: END IF;
2150: END Get_Vendor_Contact;
2151:

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

2175:
2176: FOR i in l_warehouse_tbl.FIRST..l_warehouse_tbl.LAST
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

Line 2180: FND_MESSAGE.set_token('ID', 'Warehouse ID');

2176: FOR i in l_warehouse_tbl.FIRST..l_warehouse_tbl.LAST
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)

Line 2206: fnd_message.set_name('FND', 'SQL_PLSQL_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);
2210: FND_MSG_PUB.ADD;

Line 2207: fnd_message.set_token('ROUTINE', 'DPP_UTILITY_PVT.Get_Warehouse');

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);
2210: FND_MSG_PUB.ADD;
2211: END IF;

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

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);
2210: FND_MSG_PUB.ADD;
2211: END IF;
2212: END Get_Warehouse;

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

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);
2210: FND_MSG_PUB.ADD;
2211: END IF;
2212: END Get_Warehouse;
2213:

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

2234: FOR i in l_customer_tbl.FIRST..l_customer_tbl.LAST
2235: LOOP
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

Line 2239: FND_MESSAGE.set_token('ID', 'Customer ID');

2235: LOOP
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:

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

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);
2269: FND_MSG_PUB.ADD;

Line 2266: fnd_message.set_token('ROUTINE', 'DPP_UTILITY_PVT.Get_Customer');

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);
2269: FND_MSG_PUB.ADD;
2270: END IF;

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

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);
2269: FND_MSG_PUB.ADD;
2270: END IF;
2271: END Get_Customer;

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

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);
2269: FND_MSG_PUB.ADD;
2270: END IF;
2271: END Get_Customer;
2272:

Line 2301: fnd_message.set_name('DPP', 'DPP_ORG_ID_NOTFOUND');

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:
2305: RAISE fnd_api.g_exc_error;

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

2315: FOR i in l_item_tbl.FIRST..l_item_tbl.LAST
2316: LOOP
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:

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

2316: LOOP
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

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

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);
2349: FND_MSG_PUB.ADD;

Line 2346: fnd_message.set_token('ROUTINE', 'DPP_UTILITY_PVT.Get_Product');

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);
2349: FND_MSG_PUB.ADD;
2350: END IF;

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

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);
2349: FND_MSG_PUB.ADD;
2350: END IF;
2351: END Get_Product;

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

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);
2349: FND_MSG_PUB.ADD;
2350: END IF;
2351: END Get_Product;
2352:

Line 2383: FND_MESSAGE.set_name('DPP', 'DPP_API_DEBUG_MESSAGE');

2379:
2380: INSERT INTO DPP_LOG_MESSAGES(LOG_ID,LOG_MESSAGE) VALUES(DPP_DEBUG_LOG_ID_SEQ.nextval, p_message_text);
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;

Line 2384: FND_MESSAGE.set_token('TEXT', REPLACE (p_message_text, FND_API.G_MISS_CHAR, 'G_MISS_CHAR'));

2380: INSERT INTO DPP_LOG_MESSAGES(LOG_ID,LOG_MESSAGE) VALUES(DPP_DEBUG_LOG_ID_SEQ.nextval, p_message_text);
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:

Line 2397: FND_MESSAGE.set_name('DPP', p_message_name);

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;
2401: FND_MSG_PUB.add;

Line 2399: FND_MESSAGE.set_token(p_token_name, p_token_value);

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;
2401: FND_MSG_PUB.add;
2402: END IF;
2403: END error_message;

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

2420: BEGIN
2421: x_return_status := fnd_api.g_ret_sts_success;
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

Line 2425: FND_MESSAGE.set_token('ID', 'User ID');

2421: x_return_status := fnd_api.g_ret_sts_success;
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:

Line 2448: fnd_message.set_name('FND', 'SQL_PLSQL_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);
2452: FND_MSG_PUB.ADD;

Line 2449: fnd_message.set_token('ROUTINE', 'DPP_UTILITY_PVT.get_EmailAddress');

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);
2452: FND_MSG_PUB.ADD;
2453: END IF;

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

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);
2452: FND_MSG_PUB.ADD;
2453: END IF;
2454: END get_EmailAddress;

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

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);
2452: FND_MSG_PUB.ADD;
2453: END IF;
2454: END get_EmailAddress;
2455:

Line 2488: fnd_message.set_name('DPP', 'DPP_NO_EXCHANGE_TYPE');

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;
2492: RETURN;

Line 2516: fnd_message.set_name('DPP', 'DPP_NO_RATE');

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;
2520: END IF;

Line 2517: fnd_message.set_token('CURRENCY_FROM', p_from_currency);

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;
2520: END IF;
2521:

Line 2518: fnd_message.set_token('CURRENCY_TO', p_to_currency);

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;
2520: END IF;
2521:
2522: x_return_status := fnd_api.g_ret_sts_error;

Line 2525: fnd_message.set_name('DPP', 'DPP_INVALID_CURR');

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;
2529: END IF;

Line 2526: fnd_message.set_token('CURRENCY_FROM', p_from_currency);

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;
2529: END IF;
2530:

Line 2527: fnd_message.set_token('CURRENCY_TO', p_to_currency);

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;
2529: END IF;
2530:
2531: x_return_status := fnd_api.g_ret_sts_error;

Line 2534: FND_MESSAGE.SET_NAME('FND', 'SQL_PLSQL_ERROR');

2530:
2531: x_return_status := fnd_api.g_ret_sts_error;
2532: WHEN OTHERS THEN
2533: x_return_status := fnd_api.g_ret_sts_unexp_error;
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;

Line 2535: FND_MESSAGE.SET_TOKEN('ROUTINE', 'DPP_UTILITY_PVT.convert_currency');

2531: x_return_status := fnd_api.g_ret_sts_error;
2532: WHEN OTHERS THEN
2533: x_return_status := fnd_api.g_ret_sts_unexp_error;
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);

Line 2536: FND_MESSAGE.SET_TOKEN('ERRNO', sqlcode);

2532: WHEN OTHERS THEN
2533: x_return_status := fnd_api.g_ret_sts_unexp_error;
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:

Line 2537: FND_MESSAGE.SET_TOKEN('REASON', sqlerrm);

2533: x_return_status := fnd_api.g_ret_sts_unexp_error;
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;

Line 2590: fnd_message.set_name('DPP', 'DPP_NO_EXCHANGE_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:
2594: x_return_status := fnd_api.g_ret_sts_error;

Line 2602: fnd_message.set_name('DPP', 'DPP_WRONG_CONVERSION_TYPE');

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;
2606: RETURN;

Line 2620: fnd_message.set_name('DPP', 'DPP_ORG_ID_NOTFOUND');

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:
2624: RAISE fnd_api.g_exc_error;

Line 2639: fnd_message.set_name('DPP', 'DPP_GL_SOB_NOTFOUND');

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:
2643: RAISE fnd_api.g_exc_error;

Line 2669: fnd_message.set_name('DPP', 'DPP_NO_RATE');

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:
2673: x_return_status := fnd_api.g_ret_sts_error;

Line 2676: fnd_message.set_name('DPP', 'DPP_INVALID_CURR');

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:
2680: x_return_status := fnd_api.g_ret_sts_error;

Line 2685: FND_MESSAGE.SET_NAME('FND', 'SQL_PLSQL_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);
2689: FND_MSG_PUB.ADD;

Line 2686: FND_MESSAGE.SET_TOKEN('ROUTINE', 'DPP_UTILITY_PVT.Convert_functional_curr');

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);
2689: FND_MSG_PUB.ADD;
2690: END IF;

Line 2687: FND_MESSAGE.SET_TOKEN('ERRNO', sqlcode);

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);
2689: FND_MSG_PUB.ADD;
2690: END IF;
2691: END calculate_functional_curr;

Line 2688: FND_MESSAGE.SET_TOKEN('REASON', sqlerrm);

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);
2689: FND_MSG_PUB.ADD;
2690: END IF;
2691: END calculate_functional_curr;
2692: END DPP_UTILITY_PVT;