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.CN_TRX_FACTOR_PVT dependencies on FND_MSG_PUB

Line 67: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)

63: IF p_quota_name IS NOT NULL
64: THEN
65: IF x_quota_id IS NULL
66: THEN
67: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
68: THEN
69: fnd_message.set_name ('CN', 'CN_PLN_NOT_EXIST');
70: fnd_message.set_token ('PE_NAME', p_quota_name);
71: fnd_msg_pub.ADD;

Line 71: fnd_msg_pub.ADD;

67: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
68: THEN
69: fnd_message.set_name ('CN', 'CN_PLN_NOT_EXIST');
70: fnd_message.set_token ('PE_NAME', p_quota_name);
71: fnd_msg_pub.ADD;
72: RAISE fnd_api.g_exc_error;
73: END IF;
74: END IF;
75: END IF;

Line 86: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)

82: IF p_rev_class_name IS NOT NULL
83: THEN
84: IF x_rev_class_id IS NULL
85: THEN
86: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
87: THEN
88: fnd_message.set_name ('CN', 'CN_REV_CLASS_NOT_EXIST');
89: fnd_msg_pub.ADD;
90: END IF;

Line 89: fnd_msg_pub.ADD;

85: THEN
86: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
87: THEN
88: fnd_message.set_name ('CN', 'CN_REV_CLASS_NOT_EXIST');
89: fnd_msg_pub.ADD;
90: END IF;
91:
92: RAISE fnd_api.g_exc_error;
93: END IF;

Line 95: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)

91:
92: RAISE fnd_api.g_exc_error;
93: END IF;
94: ELSE
95: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
96: THEN
97: fnd_message.set_name ('CN', 'CN_REV_CLASS_NOT_ASSIGNED');
98: fnd_msg_pub.ADD;
99: END IF;

Line 98: fnd_msg_pub.ADD;

94: ELSE
95: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
96: THEN
97: fnd_message.set_name ('CN', 'CN_REV_CLASS_NOT_ASSIGNED');
98: fnd_msg_pub.ADD;
99: END IF;
100:
101: RAISE fnd_api.g_exc_error;
102: END IF;

Line 106: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)

102: END IF;
103:
104: IF x_quota_rule_id IS NULL
105: THEN
106: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
107: THEN
108: fnd_message.set_name ('CN', 'CN_QUOTA_RULE_NOT_EXIST');
109: fnd_msg_pub.ADD;
110: END IF;

Line 109: fnd_msg_pub.ADD;

105: THEN
106: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
107: THEN
108: fnd_message.set_name ('CN', 'CN_QUOTA_RULE_NOT_EXIST');
109: fnd_msg_pub.ADD;
110: END IF;
111:
112: RAISE fnd_api.g_exc_error;
113: END IF;

Line 166: fnd_msg_pub.initialize;

162:
163: -- Initialize message list if p_init_msg_list is set to TRUE.
164: IF fnd_api.to_boolean (p_init_msg_list)
165: THEN
166: fnd_msg_pub.initialize;
167: END IF;
168:
169: -- Initialize API return status to success
170: x_return_status := fnd_api.g_ret_sts_success;

Line 184: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

180: COMMIT WORK;
181: END IF;
182:
183: -- Standard call to get message count and if count is 1, get message info.
184: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
185: EXCEPTION
186: WHEN fnd_api.g_exc_error
187: THEN
188: ROLLBACK TO create_trx_factor;

Line 190: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

186: WHEN fnd_api.g_exc_error
187: THEN
188: ROLLBACK TO create_trx_factor;
189: x_return_status := fnd_api.g_ret_sts_error;
190: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
191: WHEN fnd_api.g_exc_unexpected_error
192: THEN
193: ROLLBACK TO create_trx_factor;
194: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 195: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

191: WHEN fnd_api.g_exc_unexpected_error
192: THEN
193: ROLLBACK TO create_trx_factor;
194: x_return_status := fnd_api.g_ret_sts_unexp_error;
195: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
196: WHEN OTHERS
197: THEN
198: ROLLBACK TO create_trx_factor;
199: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 201: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)

197: THEN
198: ROLLBACK TO create_trx_factor;
199: x_return_status := fnd_api.g_ret_sts_unexp_error;
200:
201: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
202: THEN
203: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
204: END IF;
205:

Line 203: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

199: x_return_status := fnd_api.g_ret_sts_unexp_error;
200:
201: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
202: THEN
203: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
204: END IF;
205:
206: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
207: END create_trx_factor;

Line 206: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

202: THEN
203: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
204: END IF;
205:
206: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
207: END create_trx_factor;
208:
209: -- Start of comments
210: -- API name : Validate_Trx_Factor

Line 261: fnd_msg_pub.initialize;

257:
258: -- Initialize message list if p_init_msg_list is set to TRUE.
259: IF fnd_api.to_boolean (p_init_msg_list)
260: THEN
261: fnd_msg_pub.initialize;
262: END IF;
263:
264: -- Initialize API return status to success
265: x_return_status := fnd_api.g_ret_sts_success;

Line 270: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)

266:
267: -- 1. name can not be null
268: IF (p_trx_factor.trx_type IS NOT NULL)
269: THEN
270: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
271: THEN
272: BEGIN
273: --clku bug 2376751
274: SELECT meaning

Line 283: fnd_msg_pub.ADD;

279: WHEN NO_DATA_FOUND
280: THEN
281: fnd_message.set_name ('CN', 'CN_TRX_TYPE_NOT_EXISTS');
282: fnd_message.set_token ('TRANSACTION_TYPE', p_trx_factor.trx_type);
283: fnd_msg_pub.ADD;
284: RAISE fnd_api.g_exc_error;
285: END;
286: END IF;
287: ELSE

Line 288: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)

284: RAISE fnd_api.g_exc_error;
285: END;
286: END IF;
287: ELSE
288: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
289: THEN
290: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
291: THEN
292: fnd_message.set_name ('CN', 'CN_INPUT_CANT_NULL');

Line 290: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)

286: END IF;
287: ELSE
288: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
289: THEN
290: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
291: THEN
292: fnd_message.set_name ('CN', 'CN_INPUT_CANT_NULL');
293: fnd_message.set_token ('INPUT_NAME',cn_api.get_lkup_meaning ('TRX_TYPE', 'PE_OBJECT_TYPE'));
294: fnd_msg_pub.ADD;

Line 294: fnd_msg_pub.ADD;

290: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
291: THEN
292: fnd_message.set_name ('CN', 'CN_INPUT_CANT_NULL');
293: fnd_message.set_token ('INPUT_NAME',cn_api.get_lkup_meaning ('TRX_TYPE', 'PE_OBJECT_TYPE'));
294: fnd_msg_pub.ADD;
295: END IF;
296: END IF ;
297: RAISE fnd_api.g_exc_error;
298: END IF;

Line 302: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)

298: END IF;
299:
300: IF p_trx_factor.event_factor IS NULL
301: THEN
302: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
303: THEN
304: fnd_message.set_name ('CN', 'CN_INPUT_CANT_NULL');
305: fnd_message.set_token ('INPUT_NAME',cn_api.get_lkup_meaning ('EVENT_FACTOR', 'PE_OBJECT_TYPE'));
306: fnd_msg_pub.ADD;

Line 306: fnd_msg_pub.ADD;

302: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
303: THEN
304: fnd_message.set_name ('CN', 'CN_INPUT_CANT_NULL');
305: fnd_message.set_token ('INPUT_NAME',cn_api.get_lkup_meaning ('EVENT_FACTOR', 'PE_OBJECT_TYPE'));
306: fnd_msg_pub.ADD;
307: END IF;
308: RAISE fnd_api.g_exc_error;
309: END IF ;
310:

Line 313: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)

309: END IF ;
310:
311: IF p_trx_factor.quota_id IS NULL
312: THEN
313: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
314: THEN
315: fnd_message.set_name ('CN', 'CN_INVALID_DATA');
316: fnd_message.set_token ('OBJ_NAME', NVL (cn_api.get_lkup_meaning ('PE', 'INPUT_TOKEN'), 'PE'));
317: fnd_msg_pub.ADD;

Line 317: fnd_msg_pub.ADD;

313: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
314: THEN
315: fnd_message.set_name ('CN', 'CN_INVALID_DATA');
316: fnd_message.set_token ('OBJ_NAME', NVL (cn_api.get_lkup_meaning ('PE', 'INPUT_TOKEN'), 'PE'));
317: fnd_msg_pub.ADD;
318: END IF;
319:
320: RAISE fnd_api.g_exc_error;
321: END IF;

Line 325: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)

321: END IF;
322:
323: IF p_trx_factor.revenue_class_id IS NULL
324: THEN
325: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
326: THEN
327: fnd_message.set_name ('CN', 'CN_REV_CLASS_NOT_ASSIGNED');
328: fnd_msg_pub.ADD;
329: END IF;

Line 328: fnd_msg_pub.ADD;

324: THEN
325: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
326: THEN
327: fnd_message.set_name ('CN', 'CN_REV_CLASS_NOT_ASSIGNED');
328: fnd_msg_pub.ADD;
329: END IF;
330: RAISE fnd_api.g_exc_error;
331: END IF;
332:

Line 335: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)

331: END IF;
332:
333: IF p_trx_factor.quota_rule_id IS NULL
334: THEN
335: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
336: THEN
337: fnd_message.set_name ('CN', 'CN_QUOTA_RULE_NOT_EXIST');
338: fnd_msg_pub.ADD;
339: END IF;

Line 338: fnd_msg_pub.ADD;

334: THEN
335: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
336: THEN
337: fnd_message.set_name ('CN', 'CN_QUOTA_RULE_NOT_EXIST');
338: fnd_msg_pub.ADD;
339: END IF;
340:
341: RAISE fnd_api.g_exc_error;
342: END IF;

Line 348: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)

344: IF p_action = 'UPDATE'
345: THEN
346: IF p_trx_factor.trx_type <> p_old_trx_factor.trx_type
347: THEN
348: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
349: THEN
350: fnd_message.set_name ('CN', 'CN_FIELD_NOT_UPDATABLE');
351: fnd_message.set_token ('FIELD_NAME', NVL (cn_api.get_lkup_meaning ('TRX_TYPE', 'PE_OBJECT_TYPE'), 'TRX_TYPE'));
352: fnd_msg_pub.ADD;

Line 352: fnd_msg_pub.ADD;

348: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
349: THEN
350: fnd_message.set_name ('CN', 'CN_FIELD_NOT_UPDATABLE');
351: fnd_message.set_token ('FIELD_NAME', NVL (cn_api.get_lkup_meaning ('TRX_TYPE', 'PE_OBJECT_TYPE'), 'TRX_TYPE'));
352: fnd_msg_pub.ADD;
353: END IF;
354:
355: RAISE fnd_api.g_exc_error;
356: END IF;

Line 360: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)

356: END IF;
357:
358: IF p_trx_factor.quota_id <> p_old_trx_factor.quota_id
359: THEN
360: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
361: THEN
362: fnd_message.set_name ('CN', 'CN_FIELD_NOT_UPDATABLE');
363: fnd_message.set_token ('FIELD_NAME', NVL (cn_api.get_lkup_meaning ('PE', 'INPUT_TOKEN'), 'PE'));
364: fnd_msg_pub.ADD;

Line 364: fnd_msg_pub.ADD;

360: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
361: THEN
362: fnd_message.set_name ('CN', 'CN_FIELD_NOT_UPDATABLE');
363: fnd_message.set_token ('FIELD_NAME', NVL (cn_api.get_lkup_meaning ('PE', 'INPUT_TOKEN'), 'PE'));
364: fnd_msg_pub.ADD;
365: END IF;
366:
367: RAISE fnd_api.g_exc_error;
368: END IF;

Line 372: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)

368: END IF;
369:
370: IF p_trx_factor.quota_rule_id <> p_old_trx_factor.quota_rule_id
371: THEN
372: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
373: THEN
374: fnd_message.set_name ('CN', 'CN_FIELD_NOT_UPDATABLE');
375: fnd_message.set_token ('FIELD_NAME', NVL (cn_api.get_lkup_meaning ('RC_ASSIGN', 'PE_OBJECT_TYPE'), 'RC_ASSIGN'));
376: fnd_msg_pub.ADD;

Line 376: fnd_msg_pub.ADD;

372: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
373: THEN
374: fnd_message.set_name ('CN', 'CN_FIELD_NOT_UPDATABLE');
375: fnd_message.set_token ('FIELD_NAME', NVL (cn_api.get_lkup_meaning ('RC_ASSIGN', 'PE_OBJECT_TYPE'), 'RC_ASSIGN'));
376: fnd_msg_pub.ADD;
377: END IF;
378:
379: RAISE fnd_api.g_exc_error;
380: END IF;

Line 384: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)

380: END IF;
381:
382: IF p_trx_factor.revenue_class_id <> p_old_trx_factor.revenue_class_id
383: THEN
384: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
385: THEN
386: fnd_message.set_name ('CN', 'CN_FIELD_NOT_UPDATABLE');
387: fnd_message.set_token ('FIELD_NAME', NVL (cn_api.get_lkup_meaning ('RC', 'INPUT_TOKEN'), 'TRX_TYPE'));
388: fnd_msg_pub.ADD;

Line 388: fnd_msg_pub.ADD;

384: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
385: THEN
386: fnd_message.set_name ('CN', 'CN_FIELD_NOT_UPDATABLE');
387: fnd_message.set_token ('FIELD_NAME', NVL (cn_api.get_lkup_meaning ('RC', 'INPUT_TOKEN'), 'TRX_TYPE'));
388: fnd_msg_pub.ADD;
389: END IF;
390:
391: RAISE fnd_api.g_exc_error;
392: END IF;

Line 406: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)

402: AND trx_factor_id = p_trx_factor.trx_factor_id;
403:
404: IF l_temp_count < 1
405: THEN
406: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
407: THEN
408: fnd_message.set_name ('CN', 'CN_INCONSISTENT_DATA');
409: fnd_message.set_token ('INPUT1', cn_api.get_lkup_meaning ('RC', 'INPUT_TOKEN'));
410: fnd_message.set_token ('INPUT2', cn_api.get_lkup_meaning ('PE', 'INPUT_TOKEN'));

Line 414: fnd_msg_pub.ADD;

410: fnd_message.set_token ('INPUT2', cn_api.get_lkup_meaning ('PE', 'INPUT_TOKEN'));
411: fnd_message.set_token ('INPUT3', cn_api.get_lkup_meaning ('RC_ASSIGN', 'PE_OBJECT_TYPE'));
412: fnd_message.set_token ('INPUT4', cn_api.get_lkup_meaning ('TRX_TYPE', 'PE_OBJECT_TYPE'));
413: fnd_message.set_token ('INPUT5', ' ');
414: fnd_msg_pub.ADD;
415: END IF;
416:
417: RAISE fnd_api.g_exc_error;
418: END IF;

Line 431: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)

427: AND ROWNUM = 1;
428:
429: IF l_temp_count <> 0
430: THEN
431: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
432: THEN
433: fnd_message.set_name ('CN', 'CN_INPUT_MUST_UNIQUE');
434: fnd_msg_pub.ADD;
435: END IF;

Line 434: fnd_msg_pub.ADD;

430: THEN
431: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
432: THEN
433: fnd_message.set_name ('CN', 'CN_INPUT_MUST_UNIQUE');
434: fnd_msg_pub.ADD;
435: END IF;
436:
437: RAISE fnd_api.g_exc_error;
438: END IF;

Line 450: fnd_msg_pub.ADD;

446: -- 1. check object version number
447: IF p_old_trx_factor.object_version_number <> NVL (p_trx_factor.object_version_number, -1)
448: THEN
449: fnd_message.set_name ('CN', 'CN_RECORD_CHANGED');
450: fnd_msg_pub.ADD;
451: RAISE fnd_api.g_exc_error;
452: END IF;
453:
454: -- Standard call to get message count and if count is 1, get message info.

Line 455: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

451: RAISE fnd_api.g_exc_error;
452: END IF;
453:
454: -- Standard call to get message count and if count is 1, get message info.
455: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
456: EXCEPTION
457: WHEN fnd_api.g_exc_error
458: THEN
459: ROLLBACK TO validate_trx_factor;

Line 461: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

457: WHEN fnd_api.g_exc_error
458: THEN
459: ROLLBACK TO validate_trx_factor;
460: x_return_status := fnd_api.g_ret_sts_error;
461: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
462: WHEN fnd_api.g_exc_unexpected_error
463: THEN
464: ROLLBACK TO validate_trx_factor;
465: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 466: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

462: WHEN fnd_api.g_exc_unexpected_error
463: THEN
464: ROLLBACK TO validate_trx_factor;
465: x_return_status := fnd_api.g_ret_sts_unexp_error;
466: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
467: WHEN OTHERS
468: THEN
469: ROLLBACK TO validate_trx_factor;
470: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 472: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)

468: THEN
469: ROLLBACK TO validate_trx_factor;
470: x_return_status := fnd_api.g_ret_sts_unexp_error;
471:
472: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
473: THEN
474: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
475: END IF;
476:

Line 474: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

470: x_return_status := fnd_api.g_ret_sts_unexp_error;
471:
472: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
473: THEN
474: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
475: END IF;
476:
477: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
478: END validate_trx_factor;

Line 477: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

473: THEN
474: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
475: END IF;
476:
477: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
478: END validate_trx_factor;
479:
480: -- Start of comments
481: -- API name : Update_Trx_Factor

Line 553: fnd_msg_pub.initialize;

549:
550: -- Initialize message list if p_init_msg_list is set to TRUE.
551: IF fnd_api.to_boolean (p_init_msg_list)
552: THEN
553: fnd_msg_pub.initialize;
554: END IF;
555:
556: -- Initialize API return status to success
557: x_return_status := fnd_api.g_ret_sts_success;

Line 566: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)

562: INTO l_old_trx_factor;
563:
564: IF trx_factor_csr%NOTFOUND
565: THEN
566: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
567: THEN
568: fnd_message.set_name ('CN', 'CN_INVALID_DATA');
569: fnd_message.set_token ('OBJ_NAME', NVL (cn_api.get_lkup_meaning ('TRX_FACTOR', 'PE_OBJECT_TYPE'), 'TRX_FACTOR'));
570: fnd_msg_pub.ADD;

Line 570: fnd_msg_pub.ADD;

566: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
567: THEN
568: fnd_message.set_name ('CN', 'CN_INVALID_DATA');
569: fnd_message.set_token ('OBJ_NAME', NVL (cn_api.get_lkup_meaning ('TRX_FACTOR', 'PE_OBJECT_TYPE'), 'TRX_FACTOR'));
570: fnd_msg_pub.ADD;
571: END IF;
572:
573: RAISE fnd_api.g_exc_error;
574: END IF;

Line 670: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

666: COMMIT WORK;
667: END IF;
668:
669: -- Standard call to get message count and if count is 1, get message info.
670: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
671: EXCEPTION
672: WHEN fnd_api.g_exc_error
673: THEN
674: ROLLBACK TO update_trx_factor;

Line 676: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

672: WHEN fnd_api.g_exc_error
673: THEN
674: ROLLBACK TO update_trx_factor;
675: x_return_status := fnd_api.g_ret_sts_error;
676: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
677: WHEN fnd_api.g_exc_unexpected_error
678: THEN
679: ROLLBACK TO update_trx_factor;
680: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 681: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

677: WHEN fnd_api.g_exc_unexpected_error
678: THEN
679: ROLLBACK TO update_trx_factor;
680: x_return_status := fnd_api.g_ret_sts_unexp_error;
681: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
682: WHEN OTHERS
683: THEN
684: ROLLBACK TO update_trx_factor;
685: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 687: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)

683: THEN
684: ROLLBACK TO update_trx_factor;
685: x_return_status := fnd_api.g_ret_sts_unexp_error;
686:
687: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
688: THEN
689: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
690: END IF;
691:

Line 689: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

685: x_return_status := fnd_api.g_ret_sts_unexp_error;
686:
687: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
688: THEN
689: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
690: END IF;
691:
692: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
693: END update_trx_factor;

Line 692: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

688: THEN
689: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
690: END IF;
691:
692: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
693: END update_trx_factor;
694:
695: -- Start of comments
696: -- API name : update_trx_factors

Line 760: fnd_msg_pub.initialize;

756: -- Initialize message list if p_init_msg_list is set to TRUE.
757: -- +
758: IF fnd_api.to_boolean (p_init_msg_list)
759: THEN
760: fnd_msg_pub.initialize;
761: END IF;
762:
763: -- +
764: -- Initialize API return status to success

Line 801: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)

797:
798: -- Raise an Error If quota id is null but name is not null
799: IF l_quota_id IS NULL AND p_quota_name IS NOT NULL
800: THEN
801: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
802: THEN
803: fnd_message.set_name ('CN', 'CN_PLN_NOT_EXIST');
804: fnd_message.set_token ('PE_NAME', p_quota_name);
805: fnd_msg_pub.ADD;

Line 805: fnd_msg_pub.ADD;

801: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
802: THEN
803: fnd_message.set_name ('CN', 'CN_PLN_NOT_EXIST');
804: fnd_message.set_token ('PE_NAME', p_quota_name);
805: fnd_msg_pub.ADD;
806: END IF;
807:
808: x_loading_status := 'CN_PLN_NOT_EXIST';
809: RAISE fnd_api.g_exc_error;

Line 866: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)

862: AND revenue_class_id = l_trx_factor_rec.revenue_class_id;
863: EXCEPTION
864: WHEN NO_DATA_FOUND
865: THEN
866: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
867: THEN
868: fnd_message.set_name ('CN', 'CN_INVALID_DATA');
869: fnd_message.set_token ('OBJ_NAME', NVL (cn_api.get_lkup_meaning ('TRX_FACTOR', 'PE_OBJECT_TYPE'), 'TRX_FACTOR'));
870: fnd_msg_pub.ADD;

Line 870: fnd_msg_pub.ADD;

866: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
867: THEN
868: fnd_message.set_name ('CN', 'CN_INVALID_DATA');
869: fnd_message.set_token ('OBJ_NAME', NVL (cn_api.get_lkup_meaning ('TRX_FACTOR', 'PE_OBJECT_TYPE'), 'TRX_FACTOR'));
870: fnd_msg_pub.ADD;
871: END IF;
872:
873: RAISE fnd_api.g_exc_error;
874: END;

Line 894: fnd_msg_pub.ADD;

890: RAISE fnd_api.g_exc_error;
891: END IF;
892: ELSE
893: fnd_message.set_name ('CN', 'CN_INCONSISTENT_REV_CLASS');
894: fnd_msg_pub.ADD;
895: RAISE fnd_api.g_exc_error;
896: END IF;
897: END LOOP;
898:

Line 925: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

921:
922: --+
923: -- Standard call to get message count and if count is 1, get message info.
924: --+
925: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
926: EXCEPTION
927: WHEN fnd_api.g_exc_error
928: THEN
929: ROLLBACK TO update_trx_factors;

Line 931: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

927: WHEN fnd_api.g_exc_error
928: THEN
929: ROLLBACK TO update_trx_factors;
930: x_return_status := fnd_api.g_ret_sts_error;
931: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
932: WHEN fnd_api.g_exc_unexpected_error
933: THEN
934: ROLLBACK TO update_trx_factors;
935: x_loading_status := 'UNEXPECTED_ERR';

Line 937: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

933: THEN
934: ROLLBACK TO update_trx_factors;
935: x_loading_status := 'UNEXPECTED_ERR';
936: x_return_status := fnd_api.g_ret_sts_unexp_error;
937: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
938: WHEN OTHERS
939: THEN
940: ROLLBACK TO update_trx_factors;
941: x_loading_status := 'UNEXPECTED_ERR';

Line 944: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)

940: ROLLBACK TO update_trx_factors;
941: x_loading_status := 'UNEXPECTED_ERR';
942: x_return_status := fnd_api.g_ret_sts_unexp_error;
943:
944: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
945: THEN
946: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
947: END IF;
948:

Line 946: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

942: x_return_status := fnd_api.g_ret_sts_unexp_error;
943:
944: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
945: THEN
946: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
947: END IF;
948:
949: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
950: END update_trx_factors;

Line 949: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

945: THEN
946: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
947: END IF;
948:
949: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
950: END update_trx_factors;
951:
952: -- Start of comments
953: -- API name : Delete_Trx_Factor

Line 1000: fnd_msg_pub.initialize;

996:
997: -- Initialize message list if p_init_msg_list is set to TRUE.
998: IF fnd_api.to_boolean (p_init_msg_list)
999: THEN
1000: fnd_msg_pub.initialize;
1001: END IF;
1002:
1003: -- Initialize API return status to success
1004: x_return_status := fnd_api.g_ret_sts_success;

Line 1018: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

1014: COMMIT WORK;
1015: END IF;
1016:
1017: -- Standard call to get message count and if count is 1, get message info.
1018: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
1019: EXCEPTION
1020: WHEN fnd_api.g_exc_error
1021: THEN
1022: ROLLBACK TO delete_trx_factor;

Line 1024: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

1020: WHEN fnd_api.g_exc_error
1021: THEN
1022: ROLLBACK TO delete_trx_factor;
1023: x_return_status := fnd_api.g_ret_sts_error;
1024: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
1025: WHEN fnd_api.g_exc_unexpected_error
1026: THEN
1027: ROLLBACK TO delete_trx_factor;
1028: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 1029: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

1025: WHEN fnd_api.g_exc_unexpected_error
1026: THEN
1027: ROLLBACK TO delete_trx_factor;
1028: x_return_status := fnd_api.g_ret_sts_unexp_error;
1029: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
1030: WHEN OTHERS
1031: THEN
1032: ROLLBACK TO delete_trx_factor;
1033: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 1035: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)

1031: THEN
1032: ROLLBACK TO delete_trx_factor;
1033: x_return_status := fnd_api.g_ret_sts_unexp_error;
1034:
1035: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
1036: THEN
1037: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1038: END IF;
1039:

Line 1037: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

1033: x_return_status := fnd_api.g_ret_sts_unexp_error;
1034:
1035: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
1036: THEN
1037: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1038: END IF;
1039:
1040: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
1041: END delete_trx_factor;

Line 1040: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

1036: THEN
1037: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1038: END IF;
1039:
1040: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
1041: END delete_trx_factor;
1042:
1043: -- Start of comments
1044: -- API name : Get_Trx_Factor

Line 1100: fnd_msg_pub.initialize;

1096:
1097: -- Initialize message list if p_init_msg_list is set to TRUE.
1098: IF fnd_api.to_boolean (p_init_msg_list)
1099: THEN
1100: fnd_msg_pub.initialize;
1101: END IF;
1102:
1103: -- Initialize API return status to success
1104: x_return_status := fnd_api.g_ret_sts_success;

Line 1129: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

1125: COMMIT WORK;
1126: END IF;
1127:
1128: -- Standard call to get message count and if count is 1, get message info.
1129: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
1130: EXCEPTION
1131: WHEN fnd_api.g_exc_error
1132: THEN
1133: ROLLBACK TO get_trx_factor;

Line 1135: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

1131: WHEN fnd_api.g_exc_error
1132: THEN
1133: ROLLBACK TO get_trx_factor;
1134: x_return_status := fnd_api.g_ret_sts_error;
1135: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
1136: WHEN fnd_api.g_exc_unexpected_error
1137: THEN
1138: ROLLBACK TO get_trx_factor;
1139: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 1140: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

1136: WHEN fnd_api.g_exc_unexpected_error
1137: THEN
1138: ROLLBACK TO get_trx_factor;
1139: x_return_status := fnd_api.g_ret_sts_unexp_error;
1140: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
1141: WHEN OTHERS
1142: THEN
1143: ROLLBACK TO get_trx_factor;
1144: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 1146: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)

1142: THEN
1143: ROLLBACK TO get_trx_factor;
1144: x_return_status := fnd_api.g_ret_sts_unexp_error;
1145:
1146: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
1147: THEN
1148: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1149: END IF;
1150:

Line 1148: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

1144: x_return_status := fnd_api.g_ret_sts_unexp_error;
1145:
1146: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
1147: THEN
1148: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1149: END IF;
1150:
1151: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
1152: END get_trx_factor;

Line 1151: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

1147: THEN
1148: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1149: END IF;
1150:
1151: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
1152: END get_trx_factor;
1153: END cn_trx_factor_pvt;