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_CALC_FORMULAS_PVT dependencies on FND_MESSAGE

Line 40: fnd_message.set_name('CN', 'CN_CANNOT_NULL');

36: BEGIN
37: IF (p_name IS NULL) THEN
38: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN
39: l_prompt := cn_api.get_lkup_meaning('FORMULA_NAME', 'CN_PROMPTS');
40: fnd_message.set_name('CN', 'CN_CANNOT_NULL');
41: fnd_message.set_token('OBJ_NAME', l_prompt);
42: fnd_msg_pub.ADD;
43: END IF;
44: RAISE fnd_api.g_exc_error;

Line 41: fnd_message.set_token('OBJ_NAME', l_prompt);

37: IF (p_name IS NULL) THEN
38: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN
39: l_prompt := cn_api.get_lkup_meaning('FORMULA_NAME', 'CN_PROMPTS');
40: fnd_message.set_name('CN', 'CN_CANNOT_NULL');
41: fnd_message.set_token('OBJ_NAME', l_prompt);
42: fnd_msg_pub.ADD;
43: END IF;
44: RAISE fnd_api.g_exc_error;
45: END IF;

Line 53: fnd_message.set_name('CN', 'CN_NAME_NOT_UNIQUE');

49: CLOSE formula_exists;
50:
51: IF (l_dummy = 1) THEN
52: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN
53: fnd_message.set_name('CN', 'CN_NAME_NOT_UNIQUE');
54: fnd_msg_pub.ADD;
55: END IF;
56: RAISE fnd_api.g_exc_error;
57: END IF;

Line 64: fnd_message.set_name('CN', 'CN_SPLIT_ONE_INPUT');

60: /****
61: -- 1. make sure splitting across multiple inputs is not allowed
62: IF (p_split_flag IN ('Y', 'P') AND p_number_dim > 1) THEN
63: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN
64: fnd_message.set_name('CN', 'CN_SPLIT_ONE_INPUT');
65: fnd_msg_pub.ADD;
66: END IF;
67: RAISE fnd_api.g_exc_error;
68: END IF;

Line 73: fnd_message.set_name('CN', 'CN_CUMULATE_ONE_INPUT');

69:
70: -- 2. make sure accumulation along multiple dimensions is not allowed
71: IF (p_cumulative_flag = 'Y' AND p_number_dim > 1) THEN
72: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN
73: fnd_message.set_name('CN', 'CN_CUMULATE_ONE_INPUT');
74: fnd_msg_pub.ADD;
75: END IF;
76: RAISE fnd_api.g_exc_error;
77: END IF;

Line 83: fnd_message.set_name('CN', 'CN_GROUP_CONSTRAINT');

79:
80: -- 3. make sure group by always goes with cumulative = 'Y' and itd_flag = 'N'
81: IF (p_trx_group_code = 'GROUP' AND (p_cumulative_flag = 'N' OR p_itd_flag = 'Y')) THEN
82: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN
83: fnd_message.set_name('CN', 'CN_GROUP_CONSTRAINT');
84: fnd_msg_pub.ADD;
85: END IF;
86: RAISE fnd_api.g_exc_error;
87: END IF;

Line 92: fnd_message.set_name('CN', 'CN_ITD_CUMULATIVE');

88:
89: -- 4. make sure itd_flag = 'Y' always goes with cumulative_flag = 'Y'
90: IF (p_itd_flag = 'Y' AND p_cumulative_flag = 'N') THEN
91: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN
92: fnd_message.set_name('CN', 'CN_ITD_CUMULATIVE');
93: fnd_msg_pub.ADD;
94: END IF;
95: RAISE fnd_api.g_exc_error;
96: END IF;

Line 103: fnd_message.set_name('CN', 'CN_BONUS_CONSTRAINT');

99: -- 'INDIVIDUAL' amd cumulative_flag = 'N' and itd_flag = 'N'
100: IF (p_formula_type = 'B' AND (p_trx_group_code = 'GROUP' OR
101: p_itd_flag = 'Y' OR p_cumulative_flag = 'Y')) THEN
102: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN
103: fnd_message.set_name('CN', 'CN_BONUS_CONSTRAINT');
104: fnd_msg_pub.ADD;
105: END IF;
106: RAISE fnd_api.g_exc_error;
107: END IF;

Line 116: fnd_message.set_name('CN', 'CN_THRESHOLD_CONSTRAINT');

112: IF (p_threshold_all_tier_flag = 'Y' AND
113: (p_trx_group_code = 'GROUP' or p_cumulative_flag = 'N' or
114: p_split_flag = 'Y' OR p_formula_type = 'B')) THEN
115: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN
116: fnd_message.set_name('CN', 'CN_THRESHOLD_CONSTRAINT');
117: fnd_msg_pub.ADD;
118: END IF;
119: RAISE fnd_api.g_exc_error;
120: END IF;

Line 126: fnd_message.set_name('CN', 'CN_PERF_CANT_NULL');

122: /*
123: -- 7. make sure that perf_measure_id is not null ... not required anymore
124: IF (p_perf_measure_id IS NULL) THEN
125: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN
126: fnd_message.set_name('CN', 'CN_PERF_CANT_NULL');
127: fnd_msg_pub.ADD;
128: END IF;
129: RAISE fnd_api.g_exc_error;
130: END IF;

Line 169: FND_MESSAGE.SET_NAME('CN', 'CN_ILLEGAL_EXP_COMPONENT');

165: (substr(l_sql, l_pos-2, 21) <> 'CH.TRANSACTION_AMOUNT' ) AND
166: (substr(l_sql, l_pos-2, 11) <> 'CH.QUANTITY' ) AND
167: (substr(l_sql, l_pos-4, 11) <> 'CSQA.TARGET' ) AND
168: (substr(l_sql, l_pos-4, 19) <> 'CSQA.PAYMENT_AMOUNT' ) THEN
169: FND_MESSAGE.SET_NAME('CN', 'CN_ILLEGAL_EXP_COMPONENT');
170: FND_MSG_PUB.ADD;
171: RAISE FND_API.G_EXC_ERROR;
172: end if;
173: l_pos := l_pos + 1;

Line 205: FND_MESSAGE.SET_NAME('CN', 'CN_FORMULA_PLAN_RATE');

201: for r in rt_asgns loop
202: IF r.dim_unit_code not in ('AMOUNT', 'PERCENT') OR
203: r.number_dim <> 1 THEN
204: -- condition 1 or 2 fails
205: FND_MESSAGE.SET_NAME('CN', 'CN_FORMULA_PLAN_RATE');
206: FND_MSG_PUB.ADD;
207: RAISE FND_API.G_EXC_ERROR;
208: END IF;
209: end loop;

Line 213: FND_MESSAGE.SET_NAME('CN', 'CN_FORMULA_PLAN_CUM_FLAG');

209: end loop;
210:
211: IF p_cumulative_flag = 'N' THEN
212: -- condition 3 fails
213: FND_MESSAGE.SET_NAME('CN', 'CN_FORMULA_PLAN_CUM_FLAG');
214: FND_MSG_PUB.ADD;
215: RAISE FND_API.G_EXC_ERROR;
216: END IF;
217:

Line 340: fnd_message.set_name('CN', 'CNR12_NOTE_FORMULA_CREATE');

336: select name into l_formula_name
337: from cn_calc_formulas
338: where calc_formula_id = x_calc_formula_id;
339:
340: fnd_message.set_name('CN', 'CNR12_NOTE_FORMULA_CREATE');
341: fnd_message.set_token('FORMULA_NAME', l_formula_name);
342: l_note_msg := fnd_message.get;
343:
344: jtf_notes_pub.create_note

Line 341: fnd_message.set_token('FORMULA_NAME', l_formula_name);

337: from cn_calc_formulas
338: where calc_formula_id = x_calc_formula_id;
339:
340: fnd_message.set_name('CN', 'CNR12_NOTE_FORMULA_CREATE');
341: fnd_message.set_token('FORMULA_NAME', l_formula_name);
342: l_note_msg := fnd_message.get;
343:
344: jtf_notes_pub.create_note
345: (p_api_version => 1.0,

Line 342: l_note_msg := fnd_message.get;

338: where calc_formula_id = x_calc_formula_id;
339:
340: fnd_message.set_name('CN', 'CNR12_NOTE_FORMULA_CREATE');
341: fnd_message.set_token('FORMULA_NAME', l_formula_name);
342: l_note_msg := fnd_message.get;
343:
344: jtf_notes_pub.create_note
345: (p_api_version => 1.0,
346: x_return_status => x_return_status,

Line 362: fnd_message.set_name('CN', 'CNR12_NOTE_FORMULA_OPEXPR_CRE');

358: select name INTO l_output_exp_name
359: from cn_calc_sql_exps
360: where calc_sql_exp_id = p_output_exp_id;
361:
362: fnd_message.set_name('CN', 'CNR12_NOTE_FORMULA_OPEXPR_CRE');
363: fnd_message.set_token('EXPR', l_output_exp_name);
364: l_note_msg := fnd_message.get;
365:
366: l_consolidated_note := l_consolidated_note || l_note_msg || fnd_global.local_chr(10);

Line 363: fnd_message.set_token('EXPR', l_output_exp_name);

359: from cn_calc_sql_exps
360: where calc_sql_exp_id = p_output_exp_id;
361:
362: fnd_message.set_name('CN', 'CNR12_NOTE_FORMULA_OPEXPR_CRE');
363: fnd_message.set_token('EXPR', l_output_exp_name);
364: l_note_msg := fnd_message.get;
365:
366: l_consolidated_note := l_consolidated_note || l_note_msg || fnd_global.local_chr(10);
367: /*

Line 364: l_note_msg := fnd_message.get;

360: where calc_sql_exp_id = p_output_exp_id;
361:
362: fnd_message.set_name('CN', 'CNR12_NOTE_FORMULA_OPEXPR_CRE');
363: fnd_message.set_token('EXPR', l_output_exp_name);
364: l_note_msg := fnd_message.get;
365:
366: l_consolidated_note := l_consolidated_note || l_note_msg || fnd_global.local_chr(10);
367: /*
368: jtf_notes_pub.create_note

Line 388: fnd_message.set_name('CN', 'CNR12_NOTE_FORMULA_OPFORE_CRE');

384: select name INTO l_f_output_exp_name
385: from cn_calc_sql_exps
386: where calc_sql_exp_id = p_f_output_exp_id;
387:
388: fnd_message.set_name('CN', 'CNR12_NOTE_FORMULA_OPFORE_CRE');
389: fnd_message.set_token('EXPR', l_f_output_exp_name);
390: l_note_msg := fnd_message.get;
391:
392: l_consolidated_note := l_consolidated_note || l_note_msg || fnd_global.local_chr(10);

Line 389: fnd_message.set_token('EXPR', l_f_output_exp_name);

385: from cn_calc_sql_exps
386: where calc_sql_exp_id = p_f_output_exp_id;
387:
388: fnd_message.set_name('CN', 'CNR12_NOTE_FORMULA_OPFORE_CRE');
389: fnd_message.set_token('EXPR', l_f_output_exp_name);
390: l_note_msg := fnd_message.get;
391:
392: l_consolidated_note := l_consolidated_note || l_note_msg || fnd_global.local_chr(10);
393: /*

Line 390: l_note_msg := fnd_message.get;

386: where calc_sql_exp_id = p_f_output_exp_id;
387:
388: fnd_message.set_name('CN', 'CNR12_NOTE_FORMULA_OPFORE_CRE');
389: fnd_message.set_token('EXPR', l_f_output_exp_name);
390: l_note_msg := fnd_message.get;
391:
392: l_consolidated_note := l_consolidated_note || l_note_msg || fnd_global.local_chr(10);
393: /*
394: jtf_notes_pub.create_note

Line 431: fnd_message.set_name('CN', 'CNR12_NOTE_FORMULA_PERF_CREATE');

427: select name INTO l_perf_measure_name
428: from cn_calc_sql_exps
429: where calc_sql_exp_id = p_perf_measure_id;
430:
431: fnd_message.set_name('CN', 'CNR12_NOTE_FORMULA_PERF_CREATE');
432: fnd_message.set_token('PERF_MEASURE', l_perf_measure_name);
433: l_note_msg := fnd_message.get;
434:
435: jtf_notes_pub.create_note

Line 432: fnd_message.set_token('PERF_MEASURE', l_perf_measure_name);

428: from cn_calc_sql_exps
429: where calc_sql_exp_id = p_perf_measure_id;
430:
431: fnd_message.set_name('CN', 'CNR12_NOTE_FORMULA_PERF_CREATE');
432: fnd_message.set_token('PERF_MEASURE', l_perf_measure_name);
433: l_note_msg := fnd_message.get;
434:
435: jtf_notes_pub.create_note
436: (p_api_version => 1.0,

Line 433: l_note_msg := fnd_message.get;

429: where calc_sql_exp_id = p_perf_measure_id;
430:
431: fnd_message.set_name('CN', 'CNR12_NOTE_FORMULA_PERF_CREATE');
432: fnd_message.set_token('PERF_MEASURE', l_perf_measure_name);
433: l_note_msg := fnd_message.get;
434:
435: jtf_notes_pub.create_note
436: (p_api_version => 1.0,
437: x_return_status => x_return_status,

Line 479: FND_MESSAGE.SET_NAME('CN', 'CN_DATE_OVERLAP');

475: for j in p_rt_assign_tbl.first..i-1 loop
476: if greatest(p_rt_assign_tbl(i).start_date, p_rt_assign_tbl(j).start_date) <=
477: least(nvl(p_rt_assign_tbl(i).end_date,g_end_of_time),
478: nvl(p_rt_assign_tbl(j).end_date,g_end_of_time)) then
479: FND_MESSAGE.SET_NAME('CN', 'CN_DATE_OVERLAP');
480: FND_MSG_PUB.ADD;
481: RAISE FND_API.G_EXC_ERROR;
482: end if;
483: end loop;

Line 486: FND_MESSAGE.SET_NAME('CN', 'ALL_INVALID_PERIOD_RANGE');

482: end if;
483: end loop;
484:
485: if p_rt_assign_tbl(i).start_date > nvl(p_rt_assign_tbl(i).end_date, g_end_of_time) then
486: FND_MESSAGE.SET_NAME('CN', 'ALL_INVALID_PERIOD_RANGE');
487: FND_MSG_PUB.ADD;
488: RAISE FND_API.G_EXC_ERROR;
489: end if;
490:

Line 860: fnd_message.set_name('CN', 'CNR12_NOTE_FORMULA_NAME_CREATE');

856: l_consolidated_note := '';
857: l_consolidated_exp_note := '';
858:
859: IF (l_old_rec.name <> p_name) THEN
860: fnd_message.set_name('CN', 'CNR12_NOTE_FORMULA_NAME_CREATE');
861: fnd_message.set_token('FORMULA_OLD', l_old_rec.name);
862: fnd_message.set_token('FORMULA_NEW', p_name);
863: l_note_msg := fnd_message.get;
864:

Line 861: fnd_message.set_token('FORMULA_OLD', l_old_rec.name);

857: l_consolidated_exp_note := '';
858:
859: IF (l_old_rec.name <> p_name) THEN
860: fnd_message.set_name('CN', 'CNR12_NOTE_FORMULA_NAME_CREATE');
861: fnd_message.set_token('FORMULA_OLD', l_old_rec.name);
862: fnd_message.set_token('FORMULA_NEW', p_name);
863: l_note_msg := fnd_message.get;
864:
865: l_consolidated_note := l_consolidated_note || l_note_msg || fnd_global.local_chr(10);

Line 862: fnd_message.set_token('FORMULA_NEW', p_name);

858:
859: IF (l_old_rec.name <> p_name) THEN
860: fnd_message.set_name('CN', 'CNR12_NOTE_FORMULA_NAME_CREATE');
861: fnd_message.set_token('FORMULA_OLD', l_old_rec.name);
862: fnd_message.set_token('FORMULA_NEW', p_name);
863: l_note_msg := fnd_message.get;
864:
865: l_consolidated_note := l_consolidated_note || l_note_msg || fnd_global.local_chr(10);
866: /*

Line 863: l_note_msg := fnd_message.get;

859: IF (l_old_rec.name <> p_name) THEN
860: fnd_message.set_name('CN', 'CNR12_NOTE_FORMULA_NAME_CREATE');
861: fnd_message.set_token('FORMULA_OLD', l_old_rec.name);
862: fnd_message.set_token('FORMULA_NEW', p_name);
863: l_note_msg := fnd_message.get;
864:
865: l_consolidated_note := l_consolidated_note || l_note_msg || fnd_global.local_chr(10);
866: /*
867: jtf_notes_pub.create_note

Line 889: fnd_message.set_name('CN', 'CNR12_NOTE_FORMULA_TYPE_UPDATE');

885: WHERE cl.lookup_code = cf.FORMULA_TYPE
886: AND cl.lookup_type = 'FORMULA_TYPE'
887: AND calc_formula_id = p_calc_formula_id;
888:
889: fnd_message.set_name('CN', 'CNR12_NOTE_FORMULA_TYPE_UPDATE');
890: fnd_message.set_token('OLD_TYPE', l_old_rec.meaning);
891: fnd_message.set_token('NEW_TYPE', l_meaning);
892: l_note_msg := fnd_message.get;
893:

Line 890: fnd_message.set_token('OLD_TYPE', l_old_rec.meaning);

886: AND cl.lookup_type = 'FORMULA_TYPE'
887: AND calc_formula_id = p_calc_formula_id;
888:
889: fnd_message.set_name('CN', 'CNR12_NOTE_FORMULA_TYPE_UPDATE');
890: fnd_message.set_token('OLD_TYPE', l_old_rec.meaning);
891: fnd_message.set_token('NEW_TYPE', l_meaning);
892: l_note_msg := fnd_message.get;
893:
894: l_consolidated_note := l_consolidated_note || l_note_msg || fnd_global.local_chr(10);

Line 891: fnd_message.set_token('NEW_TYPE', l_meaning);

887: AND calc_formula_id = p_calc_formula_id;
888:
889: fnd_message.set_name('CN', 'CNR12_NOTE_FORMULA_TYPE_UPDATE');
890: fnd_message.set_token('OLD_TYPE', l_old_rec.meaning);
891: fnd_message.set_token('NEW_TYPE', l_meaning);
892: l_note_msg := fnd_message.get;
893:
894: l_consolidated_note := l_consolidated_note || l_note_msg || fnd_global.local_chr(10);
895: /*

Line 892: l_note_msg := fnd_message.get;

888:
889: fnd_message.set_name('CN', 'CNR12_NOTE_FORMULA_TYPE_UPDATE');
890: fnd_message.set_token('OLD_TYPE', l_old_rec.meaning);
891: fnd_message.set_token('NEW_TYPE', l_meaning);
892: l_note_msg := fnd_message.get;
893:
894: l_consolidated_note := l_consolidated_note || l_note_msg || fnd_global.local_chr(10);
895: /*
896: jtf_notes_pub.create_note

Line 912: fnd_message.set_name('CN', 'CNR12_NOTE_FOR_PROTYPE_UPD');

908: */
909: END IF;
910:
911: IF (l_old_rec.TRX_GROUP_CODE <> p_trx_group_code) THEN
912: fnd_message.set_name('CN', 'CNR12_NOTE_FOR_PROTYPE_UPD');
913: fnd_message.set_token('OLD_OPTION', l_old_rec.TRX_GROUP_CODE);
914: fnd_message.set_token('NEW_OPTION', p_trx_group_code);
915: l_note_msg := fnd_message.get;
916:

Line 913: fnd_message.set_token('OLD_OPTION', l_old_rec.TRX_GROUP_CODE);

909: END IF;
910:
911: IF (l_old_rec.TRX_GROUP_CODE <> p_trx_group_code) THEN
912: fnd_message.set_name('CN', 'CNR12_NOTE_FOR_PROTYPE_UPD');
913: fnd_message.set_token('OLD_OPTION', l_old_rec.TRX_GROUP_CODE);
914: fnd_message.set_token('NEW_OPTION', p_trx_group_code);
915: l_note_msg := fnd_message.get;
916:
917: l_consolidated_note := l_consolidated_note || l_note_msg || fnd_global.local_chr(10);

Line 914: fnd_message.set_token('NEW_OPTION', p_trx_group_code);

910:
911: IF (l_old_rec.TRX_GROUP_CODE <> p_trx_group_code) THEN
912: fnd_message.set_name('CN', 'CNR12_NOTE_FOR_PROTYPE_UPD');
913: fnd_message.set_token('OLD_OPTION', l_old_rec.TRX_GROUP_CODE);
914: fnd_message.set_token('NEW_OPTION', p_trx_group_code);
915: l_note_msg := fnd_message.get;
916:
917: l_consolidated_note := l_consolidated_note || l_note_msg || fnd_global.local_chr(10);
918: /*

Line 915: l_note_msg := fnd_message.get;

911: IF (l_old_rec.TRX_GROUP_CODE <> p_trx_group_code) THEN
912: fnd_message.set_name('CN', 'CNR12_NOTE_FOR_PROTYPE_UPD');
913: fnd_message.set_token('OLD_OPTION', l_old_rec.TRX_GROUP_CODE);
914: fnd_message.set_token('NEW_OPTION', p_trx_group_code);
915: l_note_msg := fnd_message.get;
916:
917: l_consolidated_note := l_consolidated_note || l_note_msg || fnd_global.local_chr(10);
918: /*
919: jtf_notes_pub.create_note

Line 946: fnd_message.set_name('CN', 'CNR12_NOTE_FORMULA_SPLIT_UPD');

942: FROM cn_lookups
943: WHERE lookup_type = 'SPLIT_FLAG'
944: AND lookup_code = l_old_rec.split_flag;
945:
946: fnd_message.set_name('CN', 'CNR12_NOTE_FORMULA_SPLIT_UPD');
947: fnd_message.set_token('OLD_OPTION', l_old_meaning);
948: fnd_message.set_token('NEW_OPTION', l_new_meaning);
949: l_note_msg := fnd_message.get;
950:

Line 947: fnd_message.set_token('OLD_OPTION', l_old_meaning);

943: WHERE lookup_type = 'SPLIT_FLAG'
944: AND lookup_code = l_old_rec.split_flag;
945:
946: fnd_message.set_name('CN', 'CNR12_NOTE_FORMULA_SPLIT_UPD');
947: fnd_message.set_token('OLD_OPTION', l_old_meaning);
948: fnd_message.set_token('NEW_OPTION', l_new_meaning);
949: l_note_msg := fnd_message.get;
950:
951: l_consolidated_note := l_consolidated_note || l_note_msg || fnd_global.local_chr(10);

Line 948: fnd_message.set_token('NEW_OPTION', l_new_meaning);

944: AND lookup_code = l_old_rec.split_flag;
945:
946: fnd_message.set_name('CN', 'CNR12_NOTE_FORMULA_SPLIT_UPD');
947: fnd_message.set_token('OLD_OPTION', l_old_meaning);
948: fnd_message.set_token('NEW_OPTION', l_new_meaning);
949: l_note_msg := fnd_message.get;
950:
951: l_consolidated_note := l_consolidated_note || l_note_msg || fnd_global.local_chr(10);
952: /*

Line 949: l_note_msg := fnd_message.get;

945:
946: fnd_message.set_name('CN', 'CNR12_NOTE_FORMULA_SPLIT_UPD');
947: fnd_message.set_token('OLD_OPTION', l_old_meaning);
948: fnd_message.set_token('NEW_OPTION', l_new_meaning);
949: l_note_msg := fnd_message.get;
950:
951: l_consolidated_note := l_consolidated_note || l_note_msg || fnd_global.local_chr(10);
952: /*
953: jtf_notes_pub.create_note

Line 970: fnd_message.set_name('CN', 'CNR12_NOTE_FORMULA_ACC1_UPDATE');

966: END IF;
967:
968: IF (l_old_rec.cumulative_flag <> p_cumulative_flag) THEN
969: IF (p_cumulative_flag = 'Y') THEN
970: fnd_message.set_name('CN', 'CNR12_NOTE_FORMULA_ACC1_UPDATE');
971: ELSE
972: fnd_message.set_name('CN', 'CNR12_NOTE_FORMULA_ACC2_UPDATE');
973: END IF;
974:

Line 972: fnd_message.set_name('CN', 'CNR12_NOTE_FORMULA_ACC2_UPDATE');

968: IF (l_old_rec.cumulative_flag <> p_cumulative_flag) THEN
969: IF (p_cumulative_flag = 'Y') THEN
970: fnd_message.set_name('CN', 'CNR12_NOTE_FORMULA_ACC1_UPDATE');
971: ELSE
972: fnd_message.set_name('CN', 'CNR12_NOTE_FORMULA_ACC2_UPDATE');
973: END IF;
974:
975: l_note_msg := fnd_message.get;
976:

Line 975: l_note_msg := fnd_message.get;

971: ELSE
972: fnd_message.set_name('CN', 'CNR12_NOTE_FORMULA_ACC2_UPDATE');
973: END IF;
974:
975: l_note_msg := fnd_message.get;
976:
977: l_consolidated_note := l_consolidated_note || l_note_msg || fnd_global.local_chr(10);
978: /*
979: jtf_notes_pub.create_note

Line 996: fnd_message.set_name('CN', 'CNR12_NOTE_FORMULA_ITD1_UPDATE');

992: END IF;
993:
994: IF (l_old_rec.itd_flag <> p_itd_flag) THEN
995: IF (p_itd_flag = 'Y') THEN
996: fnd_message.set_name('CN', 'CNR12_NOTE_FORMULA_ITD1_UPDATE');
997: ELSE
998: fnd_message.set_name('CN', 'CNR12_NOTE_FORMULA_ITD2_UPDATE');
999: END IF;
1000:

Line 998: fnd_message.set_name('CN', 'CNR12_NOTE_FORMULA_ITD2_UPDATE');

994: IF (l_old_rec.itd_flag <> p_itd_flag) THEN
995: IF (p_itd_flag = 'Y') THEN
996: fnd_message.set_name('CN', 'CNR12_NOTE_FORMULA_ITD1_UPDATE');
997: ELSE
998: fnd_message.set_name('CN', 'CNR12_NOTE_FORMULA_ITD2_UPDATE');
999: END IF;
1000:
1001: l_note_msg := fnd_message.get;
1002:

Line 1001: l_note_msg := fnd_message.get;

997: ELSE
998: fnd_message.set_name('CN', 'CNR12_NOTE_FORMULA_ITD2_UPDATE');
999: END IF;
1000:
1001: l_note_msg := fnd_message.get;
1002:
1003: l_consolidated_note := l_consolidated_note || l_note_msg || fnd_global.local_chr(10);
1004: /*
1005: jtf_notes_pub.create_note

Line 1022: fnd_message.set_name('CN', 'CNR12_NOTE_FOR_PLANFL1_UPD');

1018: END IF;
1019:
1020: IF (l_old_rec.modeling_flag <> p_modeling_flag) THEN
1021: IF (p_modeling_flag = 'Y') THEN
1022: fnd_message.set_name('CN', 'CNR12_NOTE_FOR_PLANFL1_UPD');
1023: ELSE
1024: fnd_message.set_name('CN', 'CNR12_NOTE_FOR_PLANFL2_UPD');
1025: END IF;
1026:

Line 1024: fnd_message.set_name('CN', 'CNR12_NOTE_FOR_PLANFL2_UPD');

1020: IF (l_old_rec.modeling_flag <> p_modeling_flag) THEN
1021: IF (p_modeling_flag = 'Y') THEN
1022: fnd_message.set_name('CN', 'CNR12_NOTE_FOR_PLANFL1_UPD');
1023: ELSE
1024: fnd_message.set_name('CN', 'CNR12_NOTE_FOR_PLANFL2_UPD');
1025: END IF;
1026:
1027: l_note_msg := fnd_message.get;
1028:

Line 1027: l_note_msg := fnd_message.get;

1023: ELSE
1024: fnd_message.set_name('CN', 'CNR12_NOTE_FOR_PLANFL2_UPD');
1025: END IF;
1026:
1027: l_note_msg := fnd_message.get;
1028:
1029: l_consolidated_note := l_consolidated_note || l_note_msg || fnd_global.local_chr(10);
1030: /*
1031: jtf_notes_pub.create_note

Line 1071: fnd_message.set_name('CN', 'CNR12_NOTE_FORMULA_OPEXPR_UPD');

1067: where calc_sql_exp_id = p_output_exp_id;
1068:
1069: IF l_old_rec.output_exp_id IS NOT NULL THEN
1070: l_output_exp_name_old := l_old_rec.oname;
1071: fnd_message.set_name('CN', 'CNR12_NOTE_FORMULA_OPEXPR_UPD');
1072: fnd_message.set_token('EXPR', l_output_exp_name_old);
1073: fnd_message.set_token('NEW_EXPR', l_output_exp_name);
1074: l_note_msg := fnd_message.get;
1075: ELSE

Line 1072: fnd_message.set_token('EXPR', l_output_exp_name_old);

1068:
1069: IF l_old_rec.output_exp_id IS NOT NULL THEN
1070: l_output_exp_name_old := l_old_rec.oname;
1071: fnd_message.set_name('CN', 'CNR12_NOTE_FORMULA_OPEXPR_UPD');
1072: fnd_message.set_token('EXPR', l_output_exp_name_old);
1073: fnd_message.set_token('NEW_EXPR', l_output_exp_name);
1074: l_note_msg := fnd_message.get;
1075: ELSE
1076: fnd_message.set_name('CN', 'CNR12_NOTE_FORMULA_OPEXPR_CRE');

Line 1073: fnd_message.set_token('NEW_EXPR', l_output_exp_name);

1069: IF l_old_rec.output_exp_id IS NOT NULL THEN
1070: l_output_exp_name_old := l_old_rec.oname;
1071: fnd_message.set_name('CN', 'CNR12_NOTE_FORMULA_OPEXPR_UPD');
1072: fnd_message.set_token('EXPR', l_output_exp_name_old);
1073: fnd_message.set_token('NEW_EXPR', l_output_exp_name);
1074: l_note_msg := fnd_message.get;
1075: ELSE
1076: fnd_message.set_name('CN', 'CNR12_NOTE_FORMULA_OPEXPR_CRE');
1077: fnd_message.set_token('EXPR', l_output_exp_name);

Line 1074: l_note_msg := fnd_message.get;

1070: l_output_exp_name_old := l_old_rec.oname;
1071: fnd_message.set_name('CN', 'CNR12_NOTE_FORMULA_OPEXPR_UPD');
1072: fnd_message.set_token('EXPR', l_output_exp_name_old);
1073: fnd_message.set_token('NEW_EXPR', l_output_exp_name);
1074: l_note_msg := fnd_message.get;
1075: ELSE
1076: fnd_message.set_name('CN', 'CNR12_NOTE_FORMULA_OPEXPR_CRE');
1077: fnd_message.set_token('EXPR', l_output_exp_name);
1078: l_note_msg := fnd_message.get;

Line 1076: fnd_message.set_name('CN', 'CNR12_NOTE_FORMULA_OPEXPR_CRE');

1072: fnd_message.set_token('EXPR', l_output_exp_name_old);
1073: fnd_message.set_token('NEW_EXPR', l_output_exp_name);
1074: l_note_msg := fnd_message.get;
1075: ELSE
1076: fnd_message.set_name('CN', 'CNR12_NOTE_FORMULA_OPEXPR_CRE');
1077: fnd_message.set_token('EXPR', l_output_exp_name);
1078: l_note_msg := fnd_message.get;
1079: END IF;
1080: l_consolidated_exp_note := l_consolidated_exp_note || l_note_msg || fnd_global.local_chr(10);

Line 1077: fnd_message.set_token('EXPR', l_output_exp_name);

1073: fnd_message.set_token('NEW_EXPR', l_output_exp_name);
1074: l_note_msg := fnd_message.get;
1075: ELSE
1076: fnd_message.set_name('CN', 'CNR12_NOTE_FORMULA_OPEXPR_CRE');
1077: fnd_message.set_token('EXPR', l_output_exp_name);
1078: l_note_msg := fnd_message.get;
1079: END IF;
1080: l_consolidated_exp_note := l_consolidated_exp_note || l_note_msg || fnd_global.local_chr(10);
1081: /*

Line 1078: l_note_msg := fnd_message.get;

1074: l_note_msg := fnd_message.get;
1075: ELSE
1076: fnd_message.set_name('CN', 'CNR12_NOTE_FORMULA_OPEXPR_CRE');
1077: fnd_message.set_token('EXPR', l_output_exp_name);
1078: l_note_msg := fnd_message.get;
1079: END IF;
1080: l_consolidated_exp_note := l_consolidated_exp_note || l_note_msg || fnd_global.local_chr(10);
1081: /*
1082: jtf_notes_pub.create_note

Line 1099: fnd_message.set_name('CN', 'CNR12_NOTE_FORMULA_OPEXPR_DEL');

1095: END IF;
1096:
1097: IF (p_output_exp_id IS NULL AND l_old_rec.output_exp_id IS NOT NULL) THEN
1098: l_output_exp_name_old := l_old_rec.oname;
1099: fnd_message.set_name('CN', 'CNR12_NOTE_FORMULA_OPEXPR_DEL');
1100: fnd_message.set_token('EXPR', l_output_exp_name_old);
1101: l_note_msg := fnd_message.get;
1102:
1103: l_consolidated_exp_note := l_consolidated_exp_note || l_note_msg || fnd_global.local_chr(10);

Line 1100: fnd_message.set_token('EXPR', l_output_exp_name_old);

1096:
1097: IF (p_output_exp_id IS NULL AND l_old_rec.output_exp_id IS NOT NULL) THEN
1098: l_output_exp_name_old := l_old_rec.oname;
1099: fnd_message.set_name('CN', 'CNR12_NOTE_FORMULA_OPEXPR_DEL');
1100: fnd_message.set_token('EXPR', l_output_exp_name_old);
1101: l_note_msg := fnd_message.get;
1102:
1103: l_consolidated_exp_note := l_consolidated_exp_note || l_note_msg || fnd_global.local_chr(10);
1104: /*

Line 1101: l_note_msg := fnd_message.get;

1097: IF (p_output_exp_id IS NULL AND l_old_rec.output_exp_id IS NOT NULL) THEN
1098: l_output_exp_name_old := l_old_rec.oname;
1099: fnd_message.set_name('CN', 'CNR12_NOTE_FORMULA_OPEXPR_DEL');
1100: fnd_message.set_token('EXPR', l_output_exp_name_old);
1101: l_note_msg := fnd_message.get;
1102:
1103: l_consolidated_exp_note := l_consolidated_exp_note || l_note_msg || fnd_global.local_chr(10);
1104: /*
1105: jtf_notes_pub.create_note

Line 1130: fnd_message.set_name('CN', 'CNR12_NOTE_FORMULA_OPFORE_UPD');

1126: where calc_sql_exp_id = p_f_output_exp_id;
1127:
1128: IF l_old_rec.f_output_exp_id IS NOT NULL THEN
1129: l_f_output_exp_name_old := l_old_rec.fname;
1130: fnd_message.set_name('CN', 'CNR12_NOTE_FORMULA_OPFORE_UPD');
1131: fnd_message.set_token('OLD_EXPR', l_f_output_exp_name_old);
1132: fnd_message.set_token('NEW_EXPR', l_f_output_exp_name);
1133: l_note_msg := fnd_message.get;
1134:

Line 1131: fnd_message.set_token('OLD_EXPR', l_f_output_exp_name_old);

1127:
1128: IF l_old_rec.f_output_exp_id IS NOT NULL THEN
1129: l_f_output_exp_name_old := l_old_rec.fname;
1130: fnd_message.set_name('CN', 'CNR12_NOTE_FORMULA_OPFORE_UPD');
1131: fnd_message.set_token('OLD_EXPR', l_f_output_exp_name_old);
1132: fnd_message.set_token('NEW_EXPR', l_f_output_exp_name);
1133: l_note_msg := fnd_message.get;
1134:
1135: ELSE

Line 1132: fnd_message.set_token('NEW_EXPR', l_f_output_exp_name);

1128: IF l_old_rec.f_output_exp_id IS NOT NULL THEN
1129: l_f_output_exp_name_old := l_old_rec.fname;
1130: fnd_message.set_name('CN', 'CNR12_NOTE_FORMULA_OPFORE_UPD');
1131: fnd_message.set_token('OLD_EXPR', l_f_output_exp_name_old);
1132: fnd_message.set_token('NEW_EXPR', l_f_output_exp_name);
1133: l_note_msg := fnd_message.get;
1134:
1135: ELSE
1136: fnd_message.set_name('CN', 'CNR12_NOTE_FORMULA_OPFORE_CRE');

Line 1133: l_note_msg := fnd_message.get;

1129: l_f_output_exp_name_old := l_old_rec.fname;
1130: fnd_message.set_name('CN', 'CNR12_NOTE_FORMULA_OPFORE_UPD');
1131: fnd_message.set_token('OLD_EXPR', l_f_output_exp_name_old);
1132: fnd_message.set_token('NEW_EXPR', l_f_output_exp_name);
1133: l_note_msg := fnd_message.get;
1134:
1135: ELSE
1136: fnd_message.set_name('CN', 'CNR12_NOTE_FORMULA_OPFORE_CRE');
1137: fnd_message.set_token('EXPR', l_f_output_exp_name);

Line 1136: fnd_message.set_name('CN', 'CNR12_NOTE_FORMULA_OPFORE_CRE');

1132: fnd_message.set_token('NEW_EXPR', l_f_output_exp_name);
1133: l_note_msg := fnd_message.get;
1134:
1135: ELSE
1136: fnd_message.set_name('CN', 'CNR12_NOTE_FORMULA_OPFORE_CRE');
1137: fnd_message.set_token('EXPR', l_f_output_exp_name);
1138: l_note_msg := fnd_message.get;
1139: END IF;
1140:

Line 1137: fnd_message.set_token('EXPR', l_f_output_exp_name);

1133: l_note_msg := fnd_message.get;
1134:
1135: ELSE
1136: fnd_message.set_name('CN', 'CNR12_NOTE_FORMULA_OPFORE_CRE');
1137: fnd_message.set_token('EXPR', l_f_output_exp_name);
1138: l_note_msg := fnd_message.get;
1139: END IF;
1140:
1141: l_consolidated_exp_note := l_consolidated_exp_note || l_note_msg || fnd_global.local_chr(10);

Line 1138: l_note_msg := fnd_message.get;

1134:
1135: ELSE
1136: fnd_message.set_name('CN', 'CNR12_NOTE_FORMULA_OPFORE_CRE');
1137: fnd_message.set_token('EXPR', l_f_output_exp_name);
1138: l_note_msg := fnd_message.get;
1139: END IF;
1140:
1141: l_consolidated_exp_note := l_consolidated_exp_note || l_note_msg || fnd_global.local_chr(10);
1142: /*

Line 1160: fnd_message.set_name('CN', 'CNR12_NOTE_FORMULA_OPFORE_DEL');

1156: END IF;
1157:
1158: IF (p_f_output_exp_id IS NULL AND l_old_rec.f_output_exp_id IS NOT NULL) THEN
1159: l_f_output_exp_name_old := l_old_rec.fname;
1160: fnd_message.set_name('CN', 'CNR12_NOTE_FORMULA_OPFORE_DEL');
1161: fnd_message.set_token('EXPR_NAME', l_f_output_exp_name_old);
1162: l_note_msg := fnd_message.get;
1163:
1164: l_consolidated_exp_note := l_consolidated_exp_note || l_note_msg || fnd_global.local_chr(10);

Line 1161: fnd_message.set_token('EXPR_NAME', l_f_output_exp_name_old);

1157:
1158: IF (p_f_output_exp_id IS NULL AND l_old_rec.f_output_exp_id IS NOT NULL) THEN
1159: l_f_output_exp_name_old := l_old_rec.fname;
1160: fnd_message.set_name('CN', 'CNR12_NOTE_FORMULA_OPFORE_DEL');
1161: fnd_message.set_token('EXPR_NAME', l_f_output_exp_name_old);
1162: l_note_msg := fnd_message.get;
1163:
1164: l_consolidated_exp_note := l_consolidated_exp_note || l_note_msg || fnd_global.local_chr(10);
1165: /*

Line 1162: l_note_msg := fnd_message.get;

1158: IF (p_f_output_exp_id IS NULL AND l_old_rec.f_output_exp_id IS NOT NULL) THEN
1159: l_f_output_exp_name_old := l_old_rec.fname;
1160: fnd_message.set_name('CN', 'CNR12_NOTE_FORMULA_OPFORE_DEL');
1161: fnd_message.set_token('EXPR_NAME', l_f_output_exp_name_old);
1162: l_note_msg := fnd_message.get;
1163:
1164: l_consolidated_exp_note := l_consolidated_exp_note || l_note_msg || fnd_global.local_chr(10);
1165: /*
1166: jtf_notes_pub.create_note

Line 1208: fnd_message.set_name('CN', 'CNR12_NOTE_FORMULA_PERF_UPDATE');

1204: where calc_sql_exp_id = p_perf_measure_id;
1205:
1206: IF l_old_rec.perf_measure_id IS NOT NULL THEN
1207: l_perf_measure_name_old := l_old_rec.pname;
1208: fnd_message.set_name('CN', 'CNR12_NOTE_FORMULA_PERF_UPDATE');
1209: fnd_message.set_token('OLD_PERF_MEASURE', l_perf_measure_name_old);
1210: fnd_message.set_token('NEW_PERF_MEASURE', l_perf_measure_name);
1211: l_note_msg := fnd_message.get;
1212: ELSE

Line 1209: fnd_message.set_token('OLD_PERF_MEASURE', l_perf_measure_name_old);

1205:
1206: IF l_old_rec.perf_measure_id IS NOT NULL THEN
1207: l_perf_measure_name_old := l_old_rec.pname;
1208: fnd_message.set_name('CN', 'CNR12_NOTE_FORMULA_PERF_UPDATE');
1209: fnd_message.set_token('OLD_PERF_MEASURE', l_perf_measure_name_old);
1210: fnd_message.set_token('NEW_PERF_MEASURE', l_perf_measure_name);
1211: l_note_msg := fnd_message.get;
1212: ELSE
1213: fnd_message.set_name('CN', 'CNR12_NOTE_FORMULA_PERF_CREATE');

Line 1210: fnd_message.set_token('NEW_PERF_MEASURE', l_perf_measure_name);

1206: IF l_old_rec.perf_measure_id IS NOT NULL THEN
1207: l_perf_measure_name_old := l_old_rec.pname;
1208: fnd_message.set_name('CN', 'CNR12_NOTE_FORMULA_PERF_UPDATE');
1209: fnd_message.set_token('OLD_PERF_MEASURE', l_perf_measure_name_old);
1210: fnd_message.set_token('NEW_PERF_MEASURE', l_perf_measure_name);
1211: l_note_msg := fnd_message.get;
1212: ELSE
1213: fnd_message.set_name('CN', 'CNR12_NOTE_FORMULA_PERF_CREATE');
1214: fnd_message.set_token('PERF_MEASURE', l_perf_measure_name);

Line 1211: l_note_msg := fnd_message.get;

1207: l_perf_measure_name_old := l_old_rec.pname;
1208: fnd_message.set_name('CN', 'CNR12_NOTE_FORMULA_PERF_UPDATE');
1209: fnd_message.set_token('OLD_PERF_MEASURE', l_perf_measure_name_old);
1210: fnd_message.set_token('NEW_PERF_MEASURE', l_perf_measure_name);
1211: l_note_msg := fnd_message.get;
1212: ELSE
1213: fnd_message.set_name('CN', 'CNR12_NOTE_FORMULA_PERF_CREATE');
1214: fnd_message.set_token('PERF_MEASURE', l_perf_measure_name);
1215: l_note_msg := fnd_message.get;

Line 1213: fnd_message.set_name('CN', 'CNR12_NOTE_FORMULA_PERF_CREATE');

1209: fnd_message.set_token('OLD_PERF_MEASURE', l_perf_measure_name_old);
1210: fnd_message.set_token('NEW_PERF_MEASURE', l_perf_measure_name);
1211: l_note_msg := fnd_message.get;
1212: ELSE
1213: fnd_message.set_name('CN', 'CNR12_NOTE_FORMULA_PERF_CREATE');
1214: fnd_message.set_token('PERF_MEASURE', l_perf_measure_name);
1215: l_note_msg := fnd_message.get;
1216: END IF;
1217:

Line 1214: fnd_message.set_token('PERF_MEASURE', l_perf_measure_name);

1210: fnd_message.set_token('NEW_PERF_MEASURE', l_perf_measure_name);
1211: l_note_msg := fnd_message.get;
1212: ELSE
1213: fnd_message.set_name('CN', 'CNR12_NOTE_FORMULA_PERF_CREATE');
1214: fnd_message.set_token('PERF_MEASURE', l_perf_measure_name);
1215: l_note_msg := fnd_message.get;
1216: END IF;
1217:
1218: jtf_notes_pub.create_note

Line 1215: l_note_msg := fnd_message.get;

1211: l_note_msg := fnd_message.get;
1212: ELSE
1213: fnd_message.set_name('CN', 'CNR12_NOTE_FORMULA_PERF_CREATE');
1214: fnd_message.set_token('PERF_MEASURE', l_perf_measure_name);
1215: l_note_msg := fnd_message.get;
1216: END IF;
1217:
1218: jtf_notes_pub.create_note
1219: (p_api_version => 1.0,

Line 1233: fnd_message.set_name('CN', 'CNR12_NOTE_FORMULA_PERF_DELETE');

1229: );
1230: END IF;
1231: IF (p_perf_measure_id IS NULL AND l_old_rec.perf_measure_id IS NOT NULL) THEN
1232: l_perf_measure_name_old := l_old_rec.pname;
1233: fnd_message.set_name('CN', 'CNR12_NOTE_FORMULA_PERF_DELETE');
1234: fnd_message.set_token('PERF_MEASURE', l_perf_measure_name_old);
1235: l_note_msg := fnd_message.get;
1236:
1237: jtf_notes_pub.create_note

Line 1234: fnd_message.set_token('PERF_MEASURE', l_perf_measure_name_old);

1230: END IF;
1231: IF (p_perf_measure_id IS NULL AND l_old_rec.perf_measure_id IS NOT NULL) THEN
1232: l_perf_measure_name_old := l_old_rec.pname;
1233: fnd_message.set_name('CN', 'CNR12_NOTE_FORMULA_PERF_DELETE');
1234: fnd_message.set_token('PERF_MEASURE', l_perf_measure_name_old);
1235: l_note_msg := fnd_message.get;
1236:
1237: jtf_notes_pub.create_note
1238: (p_api_version => 1.0,

Line 1235: l_note_msg := fnd_message.get;

1231: IF (p_perf_measure_id IS NULL AND l_old_rec.perf_measure_id IS NOT NULL) THEN
1232: l_perf_measure_name_old := l_old_rec.pname;
1233: fnd_message.set_name('CN', 'CNR12_NOTE_FORMULA_PERF_DELETE');
1234: fnd_message.set_token('PERF_MEASURE', l_perf_measure_name_old);
1235: l_note_msg := fnd_message.get;
1236:
1237: jtf_notes_pub.create_note
1238: (p_api_version => 1.0,
1239: x_return_status => x_return_status,

Line 1313: FND_MESSAGE.SET_NAME('CN', 'CN_DATE_OVERLAP');

1309: for j in p_rt_assign_tbl.first..i-1 loop
1310: if greatest(p_rt_assign_tbl(i).start_date, p_rt_assign_tbl(j).start_date) <=
1311: least(nvl(p_rt_assign_tbl(i).end_date,g_end_of_time),
1312: nvl(p_rt_assign_tbl(j).end_date,g_end_of_time)) then
1313: FND_MESSAGE.SET_NAME('CN', 'CN_DATE_OVERLAP');
1314: FND_MSG_PUB.ADD;
1315: RAISE FND_API.G_EXC_ERROR;
1316: end if;
1317: end loop;

Line 1320: FND_MESSAGE.SET_NAME('CN', 'ALL_INVALID_PERIOD_RANGE');

1316: end if;
1317: end loop;
1318:
1319: if p_rt_assign_tbl(i).start_date > nvl(p_rt_assign_tbl(i).end_date, g_end_of_time) then
1320: FND_MESSAGE.SET_NAME('CN', 'ALL_INVALID_PERIOD_RANGE');
1321: FND_MSG_PUB.ADD;
1322: RAISE FND_API.G_EXC_ERROR;
1323: end if;
1324:

Line 1503: fnd_message.set_name('CN', 'CN_FORMULA_IN_USE');

1499: CLOSE parent_exist;
1500:
1501: IF (l_dummy = 1) THEN
1502: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN
1503: fnd_message.set_name('CN', 'CN_FORMULA_IN_USE');
1504: fnd_msg_pub.ADD;
1505: END IF;
1506: RAISE fnd_api.g_exc_error;
1507: END IF;

Line 1513: fnd_message.set_name('CN', 'CN_FORMULA_IN_USE');

1509: select count(1) into l_dummy
1510: from cn_quotas_v where calc_formula_id = p_calc_formula_id;
1511: if l_dummy > 0 THEN
1512: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN
1513: fnd_message.set_name('CN', 'CN_FORMULA_IN_USE');
1514: fnd_msg_pub.ADD;
1515: END IF;
1516: RAISE fnd_api.g_exc_error;
1517: END IF;

Line 1526: fnd_message.set_name('CN', 'CN_CANNOT_DEL_PLANNING_FORM');

1522: and f.calc_formula_id = r.calc_formula_id
1523: and f.modeling_flag = 'Y';
1524: if l_dummy > 0 THEN
1525: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN
1526: fnd_message.set_name('CN', 'CN_CANNOT_DEL_PLANNING_FORM');
1527: fnd_msg_pub.ADD;
1528: END IF;
1529: RAISE fnd_api.g_exc_error;
1530: END IF;

Line 1548: fnd_message.set_name ('CN', 'CNR12_NOTE_FORMULA_DELETE');

1544: cn_calc_formulas_pkg.delete_row(p_calc_formula_id, p_org_id);
1545:
1546: /* Start - R12 Notes History */
1547: IF (p_org_id <> -999) THEN
1548: fnd_message.set_name ('CN', 'CNR12_NOTE_FORMULA_DELETE');
1549: fnd_message.set_token ('FORMULA', l_formula_name);
1550: l_note_msg := fnd_message.get;
1551: jtf_notes_pub.create_note
1552: (p_api_version => 1.0,

Line 1549: fnd_message.set_token ('FORMULA', l_formula_name);

1545:
1546: /* Start - R12 Notes History */
1547: IF (p_org_id <> -999) THEN
1548: fnd_message.set_name ('CN', 'CNR12_NOTE_FORMULA_DELETE');
1549: fnd_message.set_token ('FORMULA', l_formula_name);
1550: l_note_msg := fnd_message.get;
1551: jtf_notes_pub.create_note
1552: (p_api_version => 1.0,
1553: x_return_status => x_return_status,

Line 1550: l_note_msg := fnd_message.get;

1546: /* Start - R12 Notes History */
1547: IF (p_org_id <> -999) THEN
1548: fnd_message.set_name ('CN', 'CNR12_NOTE_FORMULA_DELETE');
1549: fnd_message.set_token ('FORMULA', l_formula_name);
1550: l_note_msg := fnd_message.get;
1551: jtf_notes_pub.create_note
1552: (p_api_version => 1.0,
1553: x_return_status => x_return_status,
1554: x_msg_count => x_msg_count,

Line 1772: fnd_message.set_name('CN', 'CN_INVALID_PERF');

1768: CLOSE perf_measure;
1769:
1770: IF (l_status <> 'VALID') THEN
1771: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN
1772: fnd_message.set_name('CN', 'CN_INVALID_PERF');
1773: fnd_msg_pub.ADD;
1774: END IF;
1775: RAISE fnd_api.g_exc_error;
1776: ELSE

Line 1780: fnd_message.set_name('CN', 'CN_UNMATCHED_PERF');

1776: ELSE
1777: IF (l_formula_type = 'C') THEN
1778: IF (l_exp_type_code NOT IN ('IIIOIPGP', 'IRIOIPGOGPBIBOBPFRFO', 'IRIOIPGOGPBIBOBPFRFODDT')) THEN
1779: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN
1780: fnd_message.set_name('CN', 'CN_UNMATCHED_PERF');
1781: fnd_msg_pub.ADD;
1782: END IF;
1783: RAISE fnd_api.g_exc_error;
1784: END IF;

Line 1788: fnd_message.set_name('CN', 'CN_UNMATCHED_PERF');

1784: END IF;
1785: ELSIF (l_formula_type = 'B') THEN
1786: IF (l_exp_type_code NOT IN ('IRIOIPGOGPBIBOBPFRFO', 'IRIOIPGOGPBIBOBPFRFODDT', 'IIIOIPGOGPBIBOBP')) THEN
1787: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN
1788: fnd_message.set_name('CN', 'CN_UNMATCHED_PERF');
1789: fnd_msg_pub.ADD;
1790: END IF;
1791: RAISE fnd_api.g_exc_error;
1792: END IF;

Line 1812: fnd_message.set_name('CN', 'CN_INVALID_OUTPUT');

1808: IF (l_status <> 'VALID' OR
1809: l_exp_type_code IS NULL OR
1810: (l_f_output_exp_id IS NOT NULL AND (l_f_status <> 'VALID' OR l_f_exp_type_code IS NULL))) THEN
1811: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN
1812: fnd_message.set_name('CN', 'CN_INVALID_OUTPUT');
1813: fnd_msg_pub.ADD;
1814: END IF;
1815: RAISE fnd_api.g_exc_error;
1816: ELSE

Line 1820: fnd_message.set_name('CN', 'CN_UNMATCHED_OUTPUT');

1816: ELSE
1817: IF (l_formula_type = 'C' AND l_trx_group_code = 'INDIVIDUAL' AND l_itd_flag = 'Y') THEN
1818: IF (l_exp_type_code NOT IN ('IO', 'IIIO', 'IOGOBOFO', 'IIIOIPGP', 'IOGOBO', 'IRIOIPGOGPBIBOBPFRFO', 'IRIOIPGOGPBIBOBPFRFODDT', 'IIIOIPGOGPBIBOBP')) THEN
1819: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN
1820: fnd_message.set_name('CN', 'CN_UNMATCHED_OUTPUT');
1821: fnd_msg_pub.ADD;
1822: END IF;
1823: RAISE fnd_api.g_exc_error;
1824: END IF;

Line 1828: fnd_message.set_name('CN', 'CN_UNMATCHED_OUTPUT');

1824: END IF;
1825: ELSIF (l_formula_type = 'C' AND l_trx_group_code = 'INDIVIDUAL' AND l_itd_flag = 'N') THEN
1826: IF (l_exp_type_code NOT IN ('IO', 'IO_ITDN', 'IIIO', 'IIIOIPGP', 'IOGOBOFO', 'IOGOBO', 'IRIOIPGOGPBIBOBPFRFO', 'IRIOIPGOGPBIBOBPFRFODDT', 'IIIOIPGOGPBIBOBP')) THEN
1827: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN
1828: fnd_message.set_name('CN', 'CN_UNMATCHED_OUTPUT');
1829: fnd_msg_pub.ADD;
1830: END IF;
1831: RAISE fnd_api.g_exc_error;
1832: END IF;

Line 1836: fnd_message.set_name('CN', 'CN_UNMATCHED_OUTPUT');

1832: END IF;
1833: ELSIF (l_formula_type = 'C' AND l_trx_group_code = 'GROUP') THEN
1834: IF (l_exp_type_code NOT IN ('GO', 'GIGO', 'IOGOBOFO', 'IRIOIPGOGPBIBOBPFRFO', 'IRIOIPGOGPBIBOBPFRFODDT', 'IOGOBO', 'IIIOIPGOGPBIBOBP')) THEN
1835: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN
1836: fnd_message.set_name('CN', 'CN_UNMATCHED_OUTPUT');
1837: fnd_msg_pub.ADD;
1838: END IF;
1839: RAISE fnd_api.g_exc_error;
1840: END IF;

Line 1844: fnd_message.set_name('CN', 'CN_UNMATCHED_OUTPUT');

1840: END IF;
1841: ELSIF (l_formula_type = 'B') THEN
1842: IF (l_exp_type_code NOT IN ('IOGOBOFO', 'IRIOIPGOGPBIBOBPFRFO', 'IRIOIPGOGPBIBOBPFRFODDT', 'IOGOBO', 'IIIOIPGOGPBIBOBP')) THEN
1843: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN
1844: fnd_message.set_name('CN', 'CN_UNMATCHED_OUTPUT');
1845: fnd_msg_pub.ADD;
1846: END IF;
1847: RAISE fnd_api.g_exc_error;
1848: END IF;

Line 1856: fnd_message.set_name('CN', 'CN_INVALID_INPUT');

1852: -- check and make sure that number_dim is correct and input expressions match this formula
1853: FOR input IN inputs LOOP
1854: IF (input.status <> 'VALID' OR input.exp_type_code IS NULL) THEN
1855: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN
1856: fnd_message.set_name('CN', 'CN_INVALID_INPUT');
1857: fnd_msg_pub.ADD;
1858: END IF;
1859: RAISE fnd_api.g_exc_error;
1860: ELSE

Line 1864: fnd_message.set_name('CN', 'CN_UNMATCHED_INPUT');

1860: ELSE
1861: IF (l_formula_type = 'C' AND l_trx_group_code = 'INDIVIDUAL') THEN
1862: IF (input.exp_type_code NOT IN ('IIIOIPGP', 'IIIO', 'IRIOIPGOGPBIBOBPFRFO', 'IRIOIPGOGPBIBOBPFRFODDT', 'IIIOIPGOGPBIBOBP')) THEN
1863: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN
1864: fnd_message.set_name('CN', 'CN_UNMATCHED_INPUT');
1865: fnd_msg_pub.ADD;
1866: END IF;
1867: RAISE fnd_api.g_exc_error;
1868: END IF;

Line 1876: fnd_message.set_name('CN', 'CN_UNMATCHED_INPUT');

1872: END IF;
1873: ELSIF (l_formula_type = 'C' AND l_trx_group_code = 'GROUP') THEN
1874: IF (input.exp_type_code <> 'GIGO') THEN
1875: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN
1876: fnd_message.set_name('CN', 'CN_UNMATCHED_INPUT');
1877: fnd_msg_pub.ADD;
1878: END IF;
1879: RAISE fnd_api.g_exc_error;
1880: END IF;

Line 1885: fnd_message.set_name('CN', 'CN_UNMATCHED_INPUT');

1881: l_ii_flag := 'Y';
1882: ELSIF (l_formula_type = 'B') THEN
1883: IF (input.exp_type_code NOT IN ('IRIOIPGOGPBIBOBPFRFO', 'IRIOIPGOGPBIBOBPFRFODDT', 'IIIOIPGOGPBIBOBP')) THEN
1884: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN
1885: fnd_message.set_name('CN', 'CN_UNMATCHED_INPUT');
1886: fnd_msg_pub.ADD;
1887: END IF;
1888: RAISE fnd_api.g_exc_error;
1889: END IF;

Line 1902: fnd_message.set_name('CN', 'CN_NO_LINE_HEADER');

1898: -- least one column from cn_commission_lines/headers
1899: -- in one of its input definition
1900: IF (l_ii_flag <> 'Y') THEN
1901: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN
1902: fnd_message.set_name('CN', 'CN_NO_LINE_HEADER');
1903: fnd_msg_pub.ADD;
1904: END IF;
1905: RAISE fnd_api.g_exc_error;
1906: END IF;

Line 1922: fnd_message.set_name('CN', 'CN_NO_SPLIT_INPUT_EXP');

1918: AND split_flag = 'Y';
1919:
1920: IF l_count_formula_input = 0 THEN
1921: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN
1922: fnd_message.set_name('CN', 'CN_NO_SPLIT_INPUT_EXP');
1923: fnd_msg_pub.ADD;
1924: END IF;
1925: RAISE fnd_api.g_exc_error;
1926: END IF;

Line 1931: fnd_message.set_name('CN', 'CN_WRONG_NUMBER_DIM');

1927: END IF;
1928:
1929: IF (l_input_count <> l_number_dim) THEN
1930: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN
1931: fnd_message.set_name('CN', 'CN_WRONG_NUMBER_DIM');
1932: fnd_msg_pub.ADD;
1933: END IF;
1934: RAISE fnd_api.g_exc_error;
1935: END IF;

Line 1944: fnd_message.set_name('CN', 'CN_RT_NOT_MATCH');

1940: FETCH check_dimensions INTO l_dummy;
1941: CLOSE check_dimensions;
1942: IF (l_dummy = 1) THEN
1943: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN
1944: fnd_message.set_name('CN', 'CN_RT_NOT_MATCH');
1945: fnd_msg_pub.ADD;
1946: END IF;
1947: RAISE fnd_api.g_exc_error;
1948: END IF;