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_MSG_PUB

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

34: --R12 MOAC Changes--End
35:
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;

Line 42: fnd_msg_pub.ADD;

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

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

48: FETCH formula_exists INTO l_dummy;
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;

Line 54: fnd_msg_pub.ADD;

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

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

59: -- validate the combination of flags
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;

Line 65: fnd_msg_pub.ADD;

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

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

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

Line 74: fnd_msg_pub.ADD;

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;
78: ***/

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

78: ***/
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;

Line 84: fnd_msg_pub.ADD;

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

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

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

Line 93: fnd_msg_pub.ADD;

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

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

98: -- 5. make sure BONUS type formulas always have trx_group_code =
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;

Line 104: fnd_msg_pub.ADD;

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

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

111: -- itd_flag = 'N' and split_flag = 'N'
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;

Line 117: fnd_msg_pub.ADD;

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

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

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

Line 127: fnd_msg_pub.ADD;

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;
131: */

Line 170: FND_MSG_PUB.ADD;

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;
174: end if;

Line 206: FND_MSG_PUB.ADD;

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

Line 214: FND_MSG_PUB.ADD;

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:
218: /*

Line 290: FND_MSG_PUB.initialize;

286: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
287: END IF;
288: -- Initialize message list if p_init_msg_list is set to TRUE.
289: IF FND_API.to_Boolean( p_init_msg_list ) THEN
290: FND_MSG_PUB.initialize;
291: END IF;
292: -- Initialize API return status to success
293: x_return_status := FND_API.G_RET_STS_SUCCESS;
294:

Line 480: FND_MSG_PUB.ADD;

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

Line 487: FND_MSG_PUB.ADD;

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:
491: l_temp_id := NULL;

Line 538: FND_MSG_PUB.Count_And_Get

534:
535: -- End of API body.
536:
537: -- Standard call to get message count and if count is 1, get message info.
538: FND_MSG_PUB.Count_And_Get
539: (p_count => x_msg_count ,
540: p_data => x_msg_data ,
541: p_encoded => FND_API.G_FALSE );
542: EXCEPTION

Line 546: FND_MSG_PUB.count_and_get

542: EXCEPTION
543: WHEN FND_API.G_EXC_ERROR THEN
544: ROLLBACK TO Create_Formula;
545: x_return_status := FND_API.G_RET_STS_ERROR ;
546: FND_MSG_PUB.count_and_get
547: (p_count => x_msg_count ,
548: p_data => x_msg_data ,
549: p_encoded => FND_API.G_FALSE );
550: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 553: FND_MSG_PUB.count_and_get

549: p_encoded => FND_API.G_FALSE );
550: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
551: ROLLBACK TO Create_Formula;
552: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
553: FND_MSG_PUB.count_and_get
554: (p_count => x_msg_count ,
555: p_data => x_msg_data ,
556: p_encoded => FND_API.G_FALSE );
557: WHEN OTHERS THEN

Line 560: IF FND_MSG_PUB.check_msg_level

556: p_encoded => FND_API.G_FALSE );
557: WHEN OTHERS THEN
558: ROLLBACK TO Create_Formula;
559: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
560: IF FND_MSG_PUB.check_msg_level
561: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
562: THEN
563: FND_MSG_PUB.add_exc_msg
564: (G_PKG_NAME ,

Line 561: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

557: WHEN OTHERS THEN
558: ROLLBACK TO Create_Formula;
559: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
560: IF FND_MSG_PUB.check_msg_level
561: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
562: THEN
563: FND_MSG_PUB.add_exc_msg
564: (G_PKG_NAME ,
565: l_api_name );

Line 563: FND_MSG_PUB.add_exc_msg

559: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
560: IF FND_MSG_PUB.check_msg_level
561: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
562: THEN
563: FND_MSG_PUB.add_exc_msg
564: (G_PKG_NAME ,
565: l_api_name );
566: END IF;
567: FND_MSG_PUB.count_and_get

Line 567: FND_MSG_PUB.count_and_get

563: FND_MSG_PUB.add_exc_msg
564: (G_PKG_NAME ,
565: l_api_name );
566: END IF;
567: FND_MSG_PUB.count_and_get
568: (p_count => x_msg_count ,
569: p_data => x_msg_data ,
570: p_encoded => FND_API.G_FALSE );
571: END Create_Formula;

Line 699: FND_MSG_PUB.initialize;

695: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
696: END IF;
697: -- Initialize message list if p_init_msg_list is set to TRUE.
698: IF FND_API.to_Boolean( p_init_msg_list ) THEN
699: FND_MSG_PUB.initialize;
700: END IF;
701: -- Initialize API return status to success
702: x_return_status := FND_API.G_RET_STS_SUCCESS;
703:

Line 1314: FND_MSG_PUB.ADD;

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

Line 1321: FND_MSG_PUB.ADD;

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:
1325: IF (p_rt_assign_tbl(i).rt_formula_asgn_id IS NULL) then

Line 1405: FND_MSG_PUB.count_and_get

1401: END IF;
1402: -- End of API body.
1403:
1404: -- Standard call to get message count and if count is 1, get message info.
1405: FND_MSG_PUB.count_and_get
1406: (p_count => x_msg_count ,
1407: p_data => x_msg_data ,
1408: p_encoded => FND_API.G_FALSE );
1409: EXCEPTION

Line 1413: FND_MSG_PUB.count_and_get

1409: EXCEPTION
1410: WHEN FND_API.G_EXC_ERROR THEN
1411: ROLLBACK TO Update_Formula;
1412: x_return_status := FND_API.G_RET_STS_ERROR ;
1413: FND_MSG_PUB.count_and_get
1414: (p_count => x_msg_count ,
1415: p_data => x_msg_data ,
1416: p_encoded => FND_API.G_FALSE );
1417: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1420: FND_MSG_PUB.count_and_get

1416: p_encoded => FND_API.G_FALSE );
1417: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1418: ROLLBACK TO Update_Formula;
1419: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1420: FND_MSG_PUB.count_and_get
1421: (p_count => x_msg_count ,
1422: p_data => x_msg_data ,
1423: p_encoded => FND_API.G_FALSE );
1424: WHEN OTHERS THEN

Line 1427: IF FND_MSG_PUB.check_msg_level

1423: p_encoded => FND_API.G_FALSE );
1424: WHEN OTHERS THEN
1425: ROLLBACK TO Update_Formula;
1426: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1427: IF FND_MSG_PUB.check_msg_level
1428: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1429: THEN
1430: FND_MSG_PUB.add_exc_msg
1431: (G_PKG_NAME ,

Line 1428: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1424: WHEN OTHERS THEN
1425: ROLLBACK TO Update_Formula;
1426: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1427: IF FND_MSG_PUB.check_msg_level
1428: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1429: THEN
1430: FND_MSG_PUB.add_exc_msg
1431: (G_PKG_NAME ,
1432: l_api_name );

Line 1430: FND_MSG_PUB.add_exc_msg

1426: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1427: IF FND_MSG_PUB.check_msg_level
1428: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1429: THEN
1430: FND_MSG_PUB.add_exc_msg
1431: (G_PKG_NAME ,
1432: l_api_name );
1433: END IF;
1434: FND_MSG_PUB.count_and_get

Line 1434: FND_MSG_PUB.count_and_get

1430: FND_MSG_PUB.add_exc_msg
1431: (G_PKG_NAME ,
1432: l_api_name );
1433: END IF;
1434: FND_MSG_PUB.count_and_get
1435: (p_count => x_msg_count ,
1436: p_data => x_msg_data ,
1437: p_encoded => FND_API.G_FALSE );
1438: END Update_Formula;

Line 1485: FND_MSG_PUB.initialize;

1481: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1482: END IF;
1483: -- Initialize message list if p_init_msg_list is set to TRUE.
1484: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1485: FND_MSG_PUB.initialize;
1486: END IF;
1487: -- Initialize API return status to success
1488: x_return_status := FND_API.G_RET_STS_SUCCESS;
1489:

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

1498: FETCH parent_exist INTO l_dummy;
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;

Line 1504: fnd_msg_pub.ADD;

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

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

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

Line 1514: fnd_msg_pub.ADD;

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

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

1521: where f.calc_formula_id = p_calc_formula_id
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;

Line 1527: fnd_msg_pub.ADD;

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

Line 1579: FND_MSG_PUB.count_and_get

1575: IF FND_API.To_Boolean( p_commit ) THEN
1576: COMMIT WORK;
1577: END IF;
1578: -- Standard call to get message count and if count is 1, get message info.
1579: FND_MSG_PUB.count_and_get
1580: (p_count => x_msg_count ,
1581: p_data => x_msg_data ,
1582: p_encoded => FND_API.G_FALSE );
1583: EXCEPTION

Line 1587: FND_MSG_PUB.count_and_get

1583: EXCEPTION
1584: WHEN FND_API.G_EXC_ERROR THEN
1585: ROLLBACK TO Delete_Formula;
1586: x_return_status := FND_API.G_RET_STS_ERROR ;
1587: FND_MSG_PUB.count_and_get
1588: (p_count => x_msg_count ,
1589: p_data => x_msg_data ,
1590: p_encoded => FND_API.G_FALSE );
1591: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1594: FND_MSG_PUB.count_and_get

1590: p_encoded => FND_API.G_FALSE );
1591: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1592: ROLLBACK TO Delete_Formula;
1593: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1594: FND_MSG_PUB.count_and_get
1595: (p_count => x_msg_count ,
1596: p_data => x_msg_data ,
1597: p_encoded => FND_API.G_FALSE );
1598: WHEN OTHERS THEN

Line 1601: IF FND_MSG_PUB.check_msg_level

1597: p_encoded => FND_API.G_FALSE );
1598: WHEN OTHERS THEN
1599: ROLLBACK TO Delete_Formula;
1600: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1601: IF FND_MSG_PUB.check_msg_level
1602: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1603: THEN
1604: FND_MSG_PUB.add_exc_msg
1605: (G_PKG_NAME ,

Line 1602: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1598: WHEN OTHERS THEN
1599: ROLLBACK TO Delete_Formula;
1600: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1601: IF FND_MSG_PUB.check_msg_level
1602: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1603: THEN
1604: FND_MSG_PUB.add_exc_msg
1605: (G_PKG_NAME ,
1606: l_api_name );

Line 1604: FND_MSG_PUB.add_exc_msg

1600: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1601: IF FND_MSG_PUB.check_msg_level
1602: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1603: THEN
1604: FND_MSG_PUB.add_exc_msg
1605: (G_PKG_NAME ,
1606: l_api_name );
1607: END IF;
1608: FND_MSG_PUB.count_and_get

Line 1608: FND_MSG_PUB.count_and_get

1604: FND_MSG_PUB.add_exc_msg
1605: (G_PKG_NAME ,
1606: l_api_name );
1607: END IF;
1608: FND_MSG_PUB.count_and_get
1609: (p_count => x_msg_count ,
1610: p_data => x_msg_data ,
1611: p_encoded => FND_API.G_FALSE );
1612: END Delete_Formula;

Line 1727: FND_MSG_PUB.initialize;

1723: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1724: END IF;
1725: -- Initialize message list if p_init_msg_list is set to TRUE.
1726: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1727: FND_MSG_PUB.initialize;
1728: END IF;
1729: -- Initialize API return status to success
1730: x_return_status := FND_API.G_RET_STS_SUCCESS;
1731:

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

1767: FETCH perf_measure INTO l_status, l_exp_type_code;
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;

Line 1773: fnd_msg_pub.ADD;

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
1777: IF (l_formula_type = 'C') THEN

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

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

Line 1781: fnd_msg_pub.ADD;

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;
1785: ELSIF (l_formula_type = 'B') THEN

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

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

Line 1789: fnd_msg_pub.ADD;

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

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

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

Line 1813: fnd_msg_pub.ADD;

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
1817: IF (l_formula_type = 'C' AND l_trx_group_code = 'INDIVIDUAL' AND l_itd_flag = 'Y') THEN

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

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

Line 1821: fnd_msg_pub.ADD;

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;
1825: ELSIF (l_formula_type = 'C' AND l_trx_group_code = 'INDIVIDUAL' AND l_itd_flag = 'N') THEN

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

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

Line 1829: fnd_msg_pub.ADD;

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;
1833: ELSIF (l_formula_type = 'C' AND l_trx_group_code = 'GROUP') THEN

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

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

Line 1837: fnd_msg_pub.ADD;

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;
1841: ELSIF (l_formula_type = 'B') THEN

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

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

Line 1845: fnd_msg_pub.ADD;

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

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

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

Line 1857: fnd_msg_pub.ADD;

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
1861: IF (l_formula_type = 'C' AND l_trx_group_code = 'INDIVIDUAL') THEN

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

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

Line 1865: fnd_msg_pub.ADD;

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

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

1871: l_ii_flag := 'Y';
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;

Line 1877: fnd_msg_pub.ADD;

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;
1881: l_ii_flag := 'Y';

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

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

Line 1886: fnd_msg_pub.ADD;

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;
1890: l_ii_flag := 'Y';

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

1897: -- Commission type formulas with trx_group_code = 'INDIVIDUAL' must have at
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;

Line 1903: fnd_msg_pub.ADD;

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

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

1917: WHERE calc_formula_id = p_calc_formula_id
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;

Line 1923: fnd_msg_pub.ADD;

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

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

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

Line 1932: fnd_msg_pub.ADD;

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

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

1939: OPEN check_dimensions;
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;

Line 1945: fnd_msg_pub.ADD;

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

Line 1994: FND_MSG_PUB.Count_And_Get

1990: IF FND_API.To_Boolean( p_commit ) THEN
1991: COMMIT WORK;
1992: END IF;
1993: -- Standard call to get message count and if count is 1, get message info.
1994: FND_MSG_PUB.Count_And_Get
1995: (p_count => x_msg_count ,
1996: p_data => x_msg_data ,
1997: p_encoded => FND_API.G_FALSE );
1998: EXCEPTION

Line 2002: FND_MSG_PUB.count_and_get

1998: EXCEPTION
1999: WHEN FND_API.G_EXC_ERROR THEN
2000: ROLLBACK TO Generate_Formula;
2001: x_return_status := FND_API.G_RET_STS_ERROR ;
2002: FND_MSG_PUB.count_and_get
2003: (p_count => x_msg_count ,
2004: p_data => x_msg_data ,
2005: p_encoded => FND_API.G_FALSE );
2006: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2009: FND_MSG_PUB.count_and_get

2005: p_encoded => FND_API.G_FALSE );
2006: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2007: ROLLBACK TO Generate_Formula;
2008: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2009: FND_MSG_PUB.count_and_get
2010: (p_count => x_msg_count ,
2011: p_data => x_msg_data ,
2012: p_encoded => FND_API.G_FALSE );
2013: WHEN OTHERS THEN

Line 2016: IF FND_MSG_PUB.check_msg_level

2012: p_encoded => FND_API.G_FALSE );
2013: WHEN OTHERS THEN
2014: ROLLBACK TO Generate_Formula;
2015: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2016: IF FND_MSG_PUB.check_msg_level
2017: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2018: THEN
2019: FND_MSG_PUB.add_exc_msg
2020: (G_PKG_NAME ,

Line 2017: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

2013: WHEN OTHERS THEN
2014: ROLLBACK TO Generate_Formula;
2015: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2016: IF FND_MSG_PUB.check_msg_level
2017: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2018: THEN
2019: FND_MSG_PUB.add_exc_msg
2020: (G_PKG_NAME ,
2021: l_api_name );

Line 2019: FND_MSG_PUB.add_exc_msg

2015: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2016: IF FND_MSG_PUB.check_msg_level
2017: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2018: THEN
2019: FND_MSG_PUB.add_exc_msg
2020: (G_PKG_NAME ,
2021: l_api_name );
2022: END IF;
2023: FND_MSG_PUB.count_and_get

Line 2023: FND_MSG_PUB.count_and_get

2019: FND_MSG_PUB.add_exc_msg
2020: (G_PKG_NAME ,
2021: l_api_name );
2022: END IF;
2023: FND_MSG_PUB.count_and_get
2024: (p_count => x_msg_count ,
2025: p_data => x_msg_data ,
2026: p_encoded => FND_API.G_FALSE );
2027: END generate_formula;