APPS.CN_RATE_DIMENSIONS_PVT dependencies on FND_MSG_PUB

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

41: AND org_id = p_org_id;
42: --R12 MOAC Changes--End
43: BEGIN
44: IF (p_name IS NULL) THEN
45: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN
46: l_prompt := cn_api.get_lkup_meaning('DIMENSION_NAME', 'CN_PROMPTS');
47: fnd_message.set_name('CN', 'CN_CANNOT_NULL');
48: fnd_message.set_token('OBJ_NAME', l_prompt);
49: fnd_msg_pub.ADD;

Line 49: fnd_msg_pub.ADD;

45: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN
46: l_prompt := cn_api.get_lkup_meaning('DIMENSION_NAME', 'CN_PROMPTS');
47: fnd_message.set_name('CN', 'CN_CANNOT_NULL');
48: fnd_message.set_token('OBJ_NAME', l_prompt);
49: fnd_msg_pub.ADD;
50: END IF;
51: RAISE fnd_api.g_exc_error;
52: END IF;
53:

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

55: FETCH name_exists INTO l_dummy;
56: CLOSE name_exists;
57:
58: IF (l_dummy = 1) THEN
59: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN
60: fnd_message.set_name('CN', 'CN_NAME_NOT_UNIQUE');
61: fnd_msg_pub.ADD;
62: END IF;
63: RAISE fnd_api.g_exc_error;

Line 61: fnd_msg_pub.ADD;

57:
58: IF (l_dummy = 1) THEN
59: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN
60: fnd_message.set_name('CN', 'CN_NAME_NOT_UNIQUE');
61: fnd_msg_pub.ADD;
62: END IF;
63: RAISE fnd_api.g_exc_error;
64: END IF;
65:

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

64: END IF;
65:
66: -- validate dim_unit_code
67: IF (p_dim_unit_code NOT IN ('AMOUNT', 'PERCENT', 'STRING', 'EXPRESSION')) THEN
68: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN
69: fnd_message.set_name('CN', 'CN_INVALID_DIM_UOM');
70: fnd_msg_pub.ADD;
71: END IF;
72: RAISE fnd_api.g_exc_error;

Line 70: fnd_msg_pub.ADD;

66: -- validate dim_unit_code
67: IF (p_dim_unit_code NOT IN ('AMOUNT', 'PERCENT', 'STRING', 'EXPRESSION')) THEN
68: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN
69: fnd_message.set_name('CN', 'CN_INVALID_DIM_UOM');
70: fnd_msg_pub.ADD;
71: END IF;
72: RAISE fnd_api.g_exc_error;
73: END IF;
74:

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

73: END IF;
74:
75: -- if p_tiers_tbl is not empty, then p_number_tier should be equal to the number of records in p_tiers_tbl
76: IF (p_tiers_tbl.COUNT > 0 AND p_number_tier <> p_tiers_tbl.count) THEN
77: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN
78: fnd_message.set_name('CN', 'CN_X_NUMBER_TIER');
79: fnd_msg_pub.ADD;
80: END IF;
81: RAISE fnd_api.g_exc_error;

Line 79: fnd_msg_pub.ADD;

75: -- if p_tiers_tbl is not empty, then p_number_tier should be equal to the number of records in p_tiers_tbl
76: IF (p_tiers_tbl.COUNT > 0 AND p_number_tier <> p_tiers_tbl.count) THEN
77: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN
78: fnd_message.set_name('CN', 'CN_X_NUMBER_TIER');
79: fnd_msg_pub.ADD;
80: END IF;
81: RAISE fnd_api.g_exc_error;
82: END IF;
83:

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

85: IF (p_dim_unit_code IN ('AMOUNT', 'PERCENT') AND p_tiers_tbl.COUNT > 0) THEN
86: FOR i IN p_tiers_tbl.first..p_tiers_tbl.last LOOP
87: -- if minimum_amount is greater than maximum_amount, then error
88: IF (p_tiers_tbl(i).minimum_amount >= p_tiers_tbl(i).maximum_amount) THEN
89: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN
90: fnd_message.set_name('CN', 'CN_MIN_G_MAX');
91: fnd_msg_pub.ADD;
92: END IF;
93: RAISE fnd_api.g_exc_error;

Line 91: fnd_msg_pub.ADD;

87: -- if minimum_amount is greater than maximum_amount, then error
88: IF (p_tiers_tbl(i).minimum_amount >= p_tiers_tbl(i).maximum_amount) THEN
89: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN
90: fnd_message.set_name('CN', 'CN_MIN_G_MAX');
91: fnd_msg_pub.ADD;
92: END IF;
93: RAISE fnd_api.g_exc_error;
94: END IF;
95:

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

94: END IF;
95:
96: -- if minimum_amount is not equal to previous tier's maximum_amount, then error
97: IF (i > 1 AND p_tiers_tbl(i).minimum_amount <> p_tiers_tbl(i-1).maximum_amount) THEN
98: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN
99: fnd_message.set_name('CN', 'CN_MIN_NE_MAX');
100: fnd_msg_pub.ADD;
101: END IF;
102: RAISE fnd_api.g_exc_error;

Line 100: fnd_msg_pub.ADD;

96: -- if minimum_amount is not equal to previous tier's maximum_amount, then error
97: IF (i > 1 AND p_tiers_tbl(i).minimum_amount <> p_tiers_tbl(i-1).maximum_amount) THEN
98: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN
99: fnd_message.set_name('CN', 'CN_MIN_NE_MAX');
100: fnd_msg_pub.ADD;
101: END IF;
102: RAISE fnd_api.g_exc_error;
103: END IF;
104: END LOOP;

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

113: FETCH exp_info INTO l_dummy;
114: CLOSE exp_info;
115:
116: IF (l_dummy = 0) THEN
117: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN
118: fnd_message.set_name('CN', 'CN_EXP_NOT_EXIST');
119: fnd_msg_pub.ADD;
120: END IF;
121: RAISE fnd_api.g_exc_error;

Line 119: fnd_msg_pub.ADD;

115:
116: IF (l_dummy = 0) THEN
117: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN
118: fnd_message.set_name('CN', 'CN_EXP_NOT_EXIST');
119: fnd_msg_pub.ADD;
120: END IF;
121: RAISE fnd_api.g_exc_error;
122: ELSIF (l_dummy = 2) THEN
123: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN

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

119: fnd_msg_pub.ADD;
120: END IF;
121: RAISE fnd_api.g_exc_error;
122: ELSIF (l_dummy = 2) THEN
123: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN
124: fnd_message.set_name('CN', 'CN_EXP_NOT_MATCH');
125: fnd_msg_pub.ADD;
126: END IF;
127: RAISE fnd_api.g_exc_error;

Line 125: fnd_msg_pub.ADD;

121: RAISE fnd_api.g_exc_error;
122: ELSIF (l_dummy = 2) THEN
123: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN
124: fnd_message.set_name('CN', 'CN_EXP_NOT_MATCH');
125: fnd_msg_pub.ADD;
126: END IF;
127: RAISE fnd_api.g_exc_error;
128: END IF;
129:

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

131: FETCH exp_info INTO l_dummy;
132: CLOSE exp_info;
133:
134: IF (l_dummy = 0) THEN
135: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN
136: fnd_message.set_name('CN', 'CN_EXP_NOT_EXIST');
137: fnd_msg_pub.ADD;
138: END IF;
139: RAISE fnd_api.g_exc_error;

Line 137: fnd_msg_pub.ADD;

133:
134: IF (l_dummy = 0) THEN
135: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN
136: fnd_message.set_name('CN', 'CN_EXP_NOT_EXIST');
137: fnd_msg_pub.ADD;
138: END IF;
139: RAISE fnd_api.g_exc_error;
140: ELSIF (l_dummy = 2) THEN
141: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN

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

137: fnd_msg_pub.ADD;
138: END IF;
139: RAISE fnd_api.g_exc_error;
140: ELSIF (l_dummy = 2) THEN
141: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN
142: fnd_message.set_name('CN', 'CN_EXP_NOT_MATCH');
143: fnd_msg_pub.ADD;
144: END IF;
145: RAISE fnd_api.g_exc_error;

Line 143: fnd_msg_pub.ADD;

139: RAISE fnd_api.g_exc_error;
140: ELSIF (l_dummy = 2) THEN
141: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN
142: fnd_message.set_name('CN', 'CN_EXP_NOT_MATCH');
143: fnd_msg_pub.ADD;
144: END IF;
145: RAISE fnd_api.g_exc_error;
146: END IF;
147: END LOOP;

Line 202: FND_MSG_PUB.initialize;

198: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
199: END IF;
200: -- Initialize message list if p_init_msg_list is set to TRUE.
201: IF FND_API.to_Boolean( p_init_msg_list ) THEN
202: FND_MSG_PUB.initialize;
203: END IF;
204: -- Initialize API return status to success
205: x_return_status := FND_API.G_RET_STS_SUCCESS;
206:

Line 300: FND_MSG_PUB.Count_And_Get

296: IF FND_API.To_Boolean( p_commit ) THEN
297: COMMIT WORK;
298: END IF;
299: -- Standard call to get message count and if count is 1, get message info.
300: FND_MSG_PUB.Count_And_Get
301: (p_count => x_msg_count ,
302: p_data => x_msg_data ,
303: p_encoded => FND_API.G_FALSE );
304: EXCEPTION

Line 308: FND_MSG_PUB.count_and_get

304: EXCEPTION
305: WHEN FND_API.G_EXC_ERROR THEN
306: ROLLBACK TO Create_Dimension;
307: x_return_status := FND_API.G_RET_STS_ERROR ;
308: FND_MSG_PUB.count_and_get
309: (p_count => x_msg_count ,
310: p_data => x_msg_data ,
311: p_encoded => FND_API.G_FALSE );
312: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 315: FND_MSG_PUB.count_and_get

311: p_encoded => FND_API.G_FALSE );
312: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
313: ROLLBACK TO Create_Dimension;
314: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
315: FND_MSG_PUB.count_and_get
316: (p_count => x_msg_count ,
317: p_data => x_msg_data ,
318: p_encoded => FND_API.G_FALSE );
319: WHEN OTHERS THEN

Line 322: IF FND_MSG_PUB.check_msg_level

318: p_encoded => FND_API.G_FALSE );
319: WHEN OTHERS THEN
320: ROLLBACK TO Create_Dimension;
321: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
322: IF FND_MSG_PUB.check_msg_level
323: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
324: THEN
325: FND_MSG_PUB.add_exc_msg
326: (G_PKG_NAME ,

Line 323: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

319: WHEN OTHERS THEN
320: ROLLBACK TO Create_Dimension;
321: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
322: IF FND_MSG_PUB.check_msg_level
323: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
324: THEN
325: FND_MSG_PUB.add_exc_msg
326: (G_PKG_NAME ,
327: l_api_name );

Line 325: FND_MSG_PUB.add_exc_msg

321: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
322: IF FND_MSG_PUB.check_msg_level
323: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
324: THEN
325: FND_MSG_PUB.add_exc_msg
326: (G_PKG_NAME ,
327: l_api_name );
328: END IF;
329: FND_MSG_PUB.count_and_get

Line 329: FND_MSG_PUB.count_and_get

325: FND_MSG_PUB.add_exc_msg
326: (G_PKG_NAME ,
327: l_api_name );
328: END IF;
329: FND_MSG_PUB.count_and_get
330: (p_count => x_msg_count ,
331: p_data => x_msg_data ,
332: p_encoded => FND_API.G_FALSE );
333: END Create_Dimension;

Line 413: FND_MSG_PUB.initialize;

409: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
410: END IF;
411: -- Initialize message list if p_init_msg_list is set to TRUE.
412: IF FND_API.to_Boolean( p_init_msg_list ) THEN
413: FND_MSG_PUB.initialize;
414: END IF;
415: -- Initialize API return status to success
416: x_return_status := FND_API.G_RET_STS_SUCCESS;
417:

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

439: CLOSE formula_info;
440:
441: -- if it is used in a formula, then can not update dim_unit_code
442: IF (l_dummy = 1) THEN
443: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN
444: fnd_message.set_name('CN', 'CN_X_UPDATE_DUC1');
445: fnd_msg_pub.ADD;
446: END IF;
447: RAISE fnd_api.g_exc_error;

Line 445: fnd_msg_pub.ADD;

441: -- if it is used in a formula, then can not update dim_unit_code
442: IF (l_dummy = 1) THEN
443: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN
444: fnd_message.set_name('CN', 'CN_X_UPDATE_DUC1');
445: fnd_msg_pub.ADD;
446: END IF;
447: RAISE fnd_api.g_exc_error;
448: END IF;
449:

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

449:
450: -- dim_unit_code can be changed only between AMOUNT and PERCENT
451: IF (p_dim_unit_code NOT IN ('AMOUNT', 'PERCENT') OR
452: l_dim_unit_code NOT IN ('AMOUNT', 'PERCENT')) THEN
453: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN
454: fnd_message.set_name('CN', 'CN_X_UPDATE_DUC2');
455: fnd_msg_pub.ADD;
456: END IF;
457: RAISE fnd_api.g_exc_error;

Line 455: fnd_msg_pub.ADD;

451: IF (p_dim_unit_code NOT IN ('AMOUNT', 'PERCENT') OR
452: l_dim_unit_code NOT IN ('AMOUNT', 'PERCENT')) THEN
453: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN
454: fnd_message.set_name('CN', 'CN_X_UPDATE_DUC2');
455: fnd_msg_pub.ADD;
456: END IF;
457: RAISE fnd_api.g_exc_error;
458: END IF;
459: END IF;

Line 637: FND_MSG_PUB.count_and_get

633: IF FND_API.To_Boolean( p_commit ) THEN
634: COMMIT WORK;
635: END IF;
636: -- Standard call to get message count and if count is 1, get message info.
637: FND_MSG_PUB.count_and_get
638: (p_count => x_msg_count ,
639: p_data => x_msg_data ,
640: p_encoded => FND_API.G_FALSE );
641: EXCEPTION

Line 645: FND_MSG_PUB.count_and_get

641: EXCEPTION
642: WHEN FND_API.G_EXC_ERROR THEN
643: ROLLBACK TO Update_Dimension;
644: x_return_status := FND_API.G_RET_STS_ERROR ;
645: FND_MSG_PUB.count_and_get
646: (p_count => x_msg_count ,
647: p_data => x_msg_data ,
648: p_encoded => FND_API.G_FALSE );
649: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 652: FND_MSG_PUB.count_and_get

648: p_encoded => FND_API.G_FALSE );
649: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
650: ROLLBACK TO Update_Dimension;
651: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
652: FND_MSG_PUB.count_and_get
653: (p_count => x_msg_count ,
654: p_data => x_msg_data ,
655: p_encoded => FND_API.G_FALSE );
656: WHEN OTHERS THEN

Line 659: IF FND_MSG_PUB.check_msg_level

655: p_encoded => FND_API.G_FALSE );
656: WHEN OTHERS THEN
657: ROLLBACK TO Update_Dimension;
658: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
659: IF FND_MSG_PUB.check_msg_level
660: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
661: THEN
662: FND_MSG_PUB.add_exc_msg
663: (G_PKG_NAME ,

Line 660: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

656: WHEN OTHERS THEN
657: ROLLBACK TO Update_Dimension;
658: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
659: IF FND_MSG_PUB.check_msg_level
660: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
661: THEN
662: FND_MSG_PUB.add_exc_msg
663: (G_PKG_NAME ,
664: l_api_name );

Line 662: FND_MSG_PUB.add_exc_msg

658: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
659: IF FND_MSG_PUB.check_msg_level
660: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
661: THEN
662: FND_MSG_PUB.add_exc_msg
663: (G_PKG_NAME ,
664: l_api_name );
665: END IF;
666: FND_MSG_PUB.count_and_get

Line 666: FND_MSG_PUB.count_and_get

662: FND_MSG_PUB.add_exc_msg
663: (G_PKG_NAME ,
664: l_api_name );
665: END IF;
666: FND_MSG_PUB.count_and_get
667: (p_count => x_msg_count ,
668: p_data => x_msg_data ,
669: p_encoded => FND_API.G_FALSE );
670: END Update_Dimension;

Line 717: FND_MSG_PUB.initialize;

713: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
714: END IF;
715: -- Initialize message list if p_init_msg_list is set to TRUE.
716: IF FND_API.to_Boolean( p_init_msg_list ) THEN
717: FND_MSG_PUB.initialize;
718: END IF;
719: -- Initialize API return status to success
720: x_return_status := FND_API.G_RET_STS_SUCCESS;
721:

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

725: FETCH parent_table_exist INTO l_dummy;
726: CLOSE parent_table_exist;
727:
728: IF (l_dummy = 1) THEN
729: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN
730: fnd_message.set_name('CN', 'CN_DIMENSION_IN_USE');
731: fnd_msg_pub.ADD;
732: END IF;
733: RAISE fnd_api.g_exc_error;

Line 731: fnd_msg_pub.ADD;

727:
728: IF (l_dummy = 1) THEN
729: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN
730: fnd_message.set_name('CN', 'CN_DIMENSION_IN_USE');
731: fnd_msg_pub.ADD;
732: END IF;
733: RAISE fnd_api.g_exc_error;
734: END IF;
735:

Line 782: FND_MSG_PUB.count_and_get

778: IF FND_API.To_Boolean( p_commit ) THEN
779: COMMIT WORK;
780: END IF;
781: -- Standard call to get message count and if count is 1, get message info.
782: FND_MSG_PUB.count_and_get
783: (p_count => x_msg_count ,
784: p_data => x_msg_data ,
785: p_encoded => FND_API.G_FALSE );
786: EXCEPTION

Line 790: FND_MSG_PUB.count_and_get

786: EXCEPTION
787: WHEN FND_API.G_EXC_ERROR THEN
788: ROLLBACK TO Delete_Dimension;
789: x_return_status := FND_API.G_RET_STS_ERROR ;
790: FND_MSG_PUB.count_and_get
791: (p_count => x_msg_count ,
792: p_data => x_msg_data ,
793: p_encoded => FND_API.G_FALSE );
794: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 797: FND_MSG_PUB.count_and_get

793: p_encoded => FND_API.G_FALSE );
794: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
795: ROLLBACK TO Delete_Dimension;
796: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
797: FND_MSG_PUB.count_and_get
798: (p_count => x_msg_count ,
799: p_data => x_msg_data ,
800: p_encoded => FND_API.G_FALSE );
801: WHEN OTHERS THEN

Line 804: IF FND_MSG_PUB.check_msg_level

800: p_encoded => FND_API.G_FALSE );
801: WHEN OTHERS THEN
802: ROLLBACK TO Delete_Dimension;
803: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
804: IF FND_MSG_PUB.check_msg_level
805: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
806: THEN
807: FND_MSG_PUB.add_exc_msg
808: (G_PKG_NAME ,

Line 805: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

801: WHEN OTHERS THEN
802: ROLLBACK TO Delete_Dimension;
803: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
804: IF FND_MSG_PUB.check_msg_level
805: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
806: THEN
807: FND_MSG_PUB.add_exc_msg
808: (G_PKG_NAME ,
809: l_api_name );

Line 807: FND_MSG_PUB.add_exc_msg

803: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
804: IF FND_MSG_PUB.check_msg_level
805: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
806: THEN
807: FND_MSG_PUB.add_exc_msg
808: (G_PKG_NAME ,
809: l_api_name );
810: END IF;
811: FND_MSG_PUB.count_and_get

Line 811: FND_MSG_PUB.count_and_get

807: FND_MSG_PUB.add_exc_msg
808: (G_PKG_NAME ,
809: l_api_name );
810: END IF;
811: FND_MSG_PUB.count_and_get
812: (p_count => x_msg_count ,
813: p_data => x_msg_data ,
814: p_encoded => FND_API.G_FALSE );
815: END Delete_Dimension;

Line 889: FND_MSG_PUB.initialize;

885: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
886: END IF;
887: -- Initialize message list if p_init_msg_list is set to TRUE.
888: IF FND_API.to_Boolean( p_init_msg_list ) THEN
889: FND_MSG_PUB.initialize;
890: END IF;
891: -- Initialize API return status to success
892: x_return_status := FND_API.G_RET_STS_SUCCESS;
893:

Line 905: fnd_msg_pub.add;

901: WHERE rate_dim_tier_id = p_rate_dim_tier_id;
902: exception
903: when no_data_found then
904: fnd_message.set_name('CN', 'CN_RECORD_DELETED');
905: fnd_msg_pub.add;
906: raise fnd_api.g_exc_unexpected_error;
907: end;
908:
909: FOR rate_table IN rate_tables LOOP

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

911: FETCH last_tier INTO l_dummy;
912: CLOSE last_tier;
913:
914: IF (l_dummy = 1) THEN
915: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN
916: fnd_message.set_name('CN', 'CN_DIM_LAST_TIER');
917: fnd_msg_pub.ADD;
918: END IF;
919: RAISE fnd_api.g_exc_error;

Line 917: fnd_msg_pub.ADD;

913:
914: IF (l_dummy = 1) THEN
915: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN
916: fnd_message.set_name('CN', 'CN_DIM_LAST_TIER');
917: fnd_msg_pub.ADD;
918: END IF;
919: RAISE fnd_api.g_exc_error;
920: END IF;
921:

Line 1013: FND_MSG_PUB.Count_And_Get

1009: IF FND_API.To_Boolean( p_commit ) THEN
1010: COMMIT WORK;
1011: END IF;
1012: -- Standard call to get message count and if count is 1, get message info.
1013: FND_MSG_PUB.Count_And_Get
1014: (p_count => x_msg_count ,
1015: p_data => x_msg_data ,
1016: p_encoded => FND_API.G_FALSE );
1017: EXCEPTION

Line 1021: FND_MSG_PUB.count_and_get

1017: EXCEPTION
1018: WHEN FND_API.G_EXC_ERROR THEN
1019: ROLLBACK TO Delete_Tier;
1020: x_return_status := FND_API.G_RET_STS_ERROR ;
1021: FND_MSG_PUB.count_and_get
1022: (p_count => x_msg_count ,
1023: p_data => x_msg_data ,
1024: p_encoded => FND_API.G_FALSE );
1025: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1028: FND_MSG_PUB.count_and_get

1024: p_encoded => FND_API.G_FALSE );
1025: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1026: ROLLBACK TO Delete_Tier;
1027: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1028: FND_MSG_PUB.count_and_get
1029: (p_count => x_msg_count ,
1030: p_data => x_msg_data ,
1031: p_encoded => FND_API.G_FALSE );
1032: WHEN OTHERS THEN

Line 1035: IF FND_MSG_PUB.check_msg_level

1031: p_encoded => FND_API.G_FALSE );
1032: WHEN OTHERS THEN
1033: ROLLBACK TO Delete_Tier;
1034: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1035: IF FND_MSG_PUB.check_msg_level
1036: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1037: THEN
1038: FND_MSG_PUB.add_exc_msg
1039: (G_PKG_NAME ,

Line 1036: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1032: WHEN OTHERS THEN
1033: ROLLBACK TO Delete_Tier;
1034: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1035: IF FND_MSG_PUB.check_msg_level
1036: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1037: THEN
1038: FND_MSG_PUB.add_exc_msg
1039: (G_PKG_NAME ,
1040: l_api_name );

Line 1038: FND_MSG_PUB.add_exc_msg

1034: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1035: IF FND_MSG_PUB.check_msg_level
1036: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1037: THEN
1038: FND_MSG_PUB.add_exc_msg
1039: (G_PKG_NAME ,
1040: l_api_name );
1041: END IF;
1042: FND_MSG_PUB.count_and_get

Line 1042: FND_MSG_PUB.count_and_get

1038: FND_MSG_PUB.add_exc_msg
1039: (G_PKG_NAME ,
1040: l_api_name );
1041: END IF;
1042: FND_MSG_PUB.count_and_get
1043: (p_count => x_msg_count ,
1044: p_data => x_msg_data ,
1045: p_encoded => FND_API.G_FALSE );
1046: END Delete_Tier;

Line 1104: FND_MSG_PUB.initialize;

1100: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1101: END IF;
1102: -- Initialize message list if p_init_msg_list is set to TRUE.
1103: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1104: FND_MSG_PUB.initialize;
1105: END IF;
1106: -- Initialize API return status to success
1107: x_return_status := FND_API.G_RET_STS_SUCCESS;
1108:

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

1113: p_maximum_amount = fnd_api.g_miss_num OR
1114: p_minimum_amount IS NULL OR
1115: p_maximum_amount IS NULL)
1116: THEN
1117: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN
1118: fnd_message.set_name('CN', 'CN_TIER_NULL_MISS');
1119: fnd_msg_pub.ADD;
1120: END IF;
1121: RAISE fnd_api.g_exc_error;

Line 1119: fnd_msg_pub.ADD;

1115: p_maximum_amount IS NULL)
1116: THEN
1117: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN
1118: fnd_message.set_name('CN', 'CN_TIER_NULL_MISS');
1119: fnd_msg_pub.ADD;
1120: END IF;
1121: RAISE fnd_api.g_exc_error;
1122: END IF;
1123:

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

1121: RAISE fnd_api.g_exc_error;
1122: END IF;
1123:
1124: IF (p_minimum_amount >= p_maximum_amount) THEN
1125: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN
1126: fnd_message.set_name('CN', 'CN_MIN_G_MAX');
1127: fnd_msg_pub.ADD;
1128: END IF;
1129: RAISE fnd_api.g_exc_error;

Line 1127: fnd_msg_pub.ADD;

1123:
1124: IF (p_minimum_amount >= p_maximum_amount) THEN
1125: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN
1126: fnd_message.set_name('CN', 'CN_MIN_G_MAX');
1127: fnd_msg_pub.ADD;
1128: END IF;
1129: RAISE fnd_api.g_exc_error;
1130: END IF;
1131: END IF;

Line 1226: FND_MSG_PUB.Count_And_Get

1222: IF FND_API.To_Boolean( p_commit ) THEN
1223: COMMIT WORK;
1224: END IF;
1225: -- Standard call to get message count and if count is 1, get message info.
1226: FND_MSG_PUB.Count_And_Get
1227: (p_count => x_msg_count ,
1228: p_data => x_msg_data ,
1229: p_encoded => FND_API.G_FALSE );
1230: EXCEPTION

Line 1234: FND_MSG_PUB.count_and_get

1230: EXCEPTION
1231: WHEN FND_API.G_EXC_ERROR THEN
1232: ROLLBACK TO Update_tier;
1233: x_return_status := FND_API.G_RET_STS_ERROR ;
1234: FND_MSG_PUB.count_and_get
1235: (p_count => x_msg_count ,
1236: p_data => x_msg_data ,
1237: p_encoded => FND_API.G_FALSE );
1238: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1241: FND_MSG_PUB.count_and_get

1237: p_encoded => FND_API.G_FALSE );
1238: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1239: ROLLBACK TO Update_tier;
1240: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1241: FND_MSG_PUB.count_and_get
1242: (p_count => x_msg_count ,
1243: p_data => x_msg_data ,
1244: p_encoded => FND_API.G_FALSE );
1245: WHEN OTHERS THEN

Line 1248: IF FND_MSG_PUB.check_msg_level

1244: p_encoded => FND_API.G_FALSE );
1245: WHEN OTHERS THEN
1246: ROLLBACK TO Update_tier;
1247: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1248: IF FND_MSG_PUB.check_msg_level
1249: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1250: THEN
1251: FND_MSG_PUB.add_exc_msg
1252: (G_PKG_NAME ,

Line 1249: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1245: WHEN OTHERS THEN
1246: ROLLBACK TO Update_tier;
1247: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1248: IF FND_MSG_PUB.check_msg_level
1249: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1250: THEN
1251: FND_MSG_PUB.add_exc_msg
1252: (G_PKG_NAME ,
1253: l_api_name );

Line 1251: FND_MSG_PUB.add_exc_msg

1247: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1248: IF FND_MSG_PUB.check_msg_level
1249: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1250: THEN
1251: FND_MSG_PUB.add_exc_msg
1252: (G_PKG_NAME ,
1253: l_api_name );
1254: END IF;
1255: FND_MSG_PUB.count_and_get

Line 1255: FND_MSG_PUB.count_and_get

1251: FND_MSG_PUB.add_exc_msg
1252: (G_PKG_NAME ,
1253: l_api_name );
1254: END IF;
1255: FND_MSG_PUB.count_and_get
1256: (p_count => x_msg_count ,
1257: p_data => x_msg_data ,
1258: p_encoded => FND_API.G_FALSE );
1259: END Update_tier;

Line 1322: FND_MSG_PUB.initialize;

1318: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1319: END IF;
1320: -- Initialize message list if p_init_msg_list is set to TRUE.
1321: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1322: FND_MSG_PUB.initialize;
1323: END IF;
1324: -- Initialize API return status to success
1325: x_return_status := FND_API.G_RET_STS_SUCCESS;
1326:

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

1331: p_maximum_amount = fnd_api.g_miss_num OR
1332: p_minimum_amount IS NULL OR
1333: p_maximum_amount IS NULL)
1334: THEN
1335: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN
1336: fnd_message.set_name('CN', 'CN_TIER_NULL_MISS');
1337: fnd_msg_pub.ADD;
1338: END IF;
1339: RAISE fnd_api.g_exc_error;

Line 1337: fnd_msg_pub.ADD;

1333: p_maximum_amount IS NULL)
1334: THEN
1335: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN
1336: fnd_message.set_name('CN', 'CN_TIER_NULL_MISS');
1337: fnd_msg_pub.ADD;
1338: END IF;
1339: RAISE fnd_api.g_exc_error;
1340: END IF;
1341:

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

1339: RAISE fnd_api.g_exc_error;
1340: END IF;
1341:
1342: IF (p_minimum_amount >= p_maximum_amount) THEN
1343: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN
1344: fnd_message.set_name('CN', 'CN_MIN_G_MAX');
1345: fnd_msg_pub.ADD;
1346: END IF;
1347: RAISE fnd_api.g_exc_error;

Line 1345: fnd_msg_pub.ADD;

1341:
1342: IF (p_minimum_amount >= p_maximum_amount) THEN
1343: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)) THEN
1344: fnd_message.set_name('CN', 'CN_MIN_G_MAX');
1345: fnd_msg_pub.ADD;
1346: END IF;
1347: RAISE fnd_api.g_exc_error;
1348: END IF;
1349: END IF;

Line 1447: FND_MSG_PUB.Count_And_Get

1443: IF FND_API.To_Boolean( p_commit ) THEN
1444: COMMIT WORK;
1445: END IF;
1446: -- Standard call to get message count and if count is 1, get message info.
1447: FND_MSG_PUB.Count_And_Get
1448: (p_count => x_msg_count ,
1449: p_data => x_msg_data ,
1450: p_encoded => FND_API.G_FALSE );
1451: EXCEPTION

Line 1455: FND_MSG_PUB.count_and_get

1451: EXCEPTION
1452: WHEN FND_API.G_EXC_ERROR THEN
1453: ROLLBACK TO Create_tier;
1454: x_return_status := FND_API.G_RET_STS_ERROR ;
1455: FND_MSG_PUB.count_and_get
1456: (p_count => x_msg_count ,
1457: p_data => x_msg_data ,
1458: p_encoded => FND_API.G_FALSE );
1459: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1462: FND_MSG_PUB.count_and_get

1458: p_encoded => FND_API.G_FALSE );
1459: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1460: ROLLBACK TO Create_tier;
1461: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1462: FND_MSG_PUB.count_and_get
1463: (p_count => x_msg_count ,
1464: p_data => x_msg_data ,
1465: p_encoded => FND_API.G_FALSE );
1466: WHEN OTHERS THEN

Line 1469: IF FND_MSG_PUB.check_msg_level

1465: p_encoded => FND_API.G_FALSE );
1466: WHEN OTHERS THEN
1467: ROLLBACK TO Create_tier;
1468: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1469: IF FND_MSG_PUB.check_msg_level
1470: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1471: THEN
1472: FND_MSG_PUB.add_exc_msg
1473: (G_PKG_NAME ,

Line 1470: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1466: WHEN OTHERS THEN
1467: ROLLBACK TO Create_tier;
1468: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1469: IF FND_MSG_PUB.check_msg_level
1470: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1471: THEN
1472: FND_MSG_PUB.add_exc_msg
1473: (G_PKG_NAME ,
1474: l_api_name );

Line 1472: FND_MSG_PUB.add_exc_msg

1468: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1469: IF FND_MSG_PUB.check_msg_level
1470: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1471: THEN
1472: FND_MSG_PUB.add_exc_msg
1473: (G_PKG_NAME ,
1474: l_api_name );
1475: END IF;
1476: FND_MSG_PUB.count_and_get

Line 1476: FND_MSG_PUB.count_and_get

1472: FND_MSG_PUB.add_exc_msg
1473: (G_PKG_NAME ,
1474: l_api_name );
1475: END IF;
1476: FND_MSG_PUB.count_and_get
1477: (p_count => x_msg_count ,
1478: p_data => x_msg_data ,
1479: p_encoded => FND_API.G_FALSE );
1480: END Create_tier;