[Home] [Help]
18: RETURN l_rate_schedule_id;
19: EXCEPTION
20: when others then
21: fnd_message.set_name('CN', 'CN_RATE_SCHEDULE_NOT_EXIST');
22: fnd_msg_pub.ADD;
23: RAISE fnd_api.g_exc_error;
24: END get_rate_schedule_id;
25:
26: -- to get a rate dimension ID from its name
37: RETURN l_rate_dimension_id;
38: EXCEPTION
39: when others then
40: fnd_message.set_name('CN', 'CN_RATE_DIMENSION_NOT_EXIST');
41: fnd_msg_pub.ADD;
42: RAISE fnd_api.g_exc_error;
43: END get_rate_dimension_id;
44:
45: -- to get a rate_sch_dim_id from a given rate dimension ID and rate schedule ID
57: RETURN l_rate_sch_dim_id;
58: EXCEPTION
59: when others THEN
60: fnd_message.set_name('CN', 'CN_RATE_DIM_ASSIGN_NOT_EXIST');
61: fnd_msg_pub.ADD;
62: RAISE fnd_api.g_exc_error;
63: END get_rate_sch_dim_id;
64:
65: -- to get an expression ID from its name
75: RETURN l_calc_sql_exp_id;
76: EXCEPTION
77: when others THEN
78: fnd_message.set_name('CN', 'CN_EXP_NOT_EXIST');
79: fnd_msg_pub.ADD;
80: RAISE fnd_api.g_exc_error;
81: END get_exp_id;
82:
83: -- to get a rate_dim_tier_id from the rate_dimension_id and its sequence
95: RETURN l_rate_dim_tier_id;
96: EXCEPTION
97: when others THEN
98: fnd_message.set_name('CN', 'CN_RATE_DIM_TIER_NOT_EXIST');
99: fnd_msg_pub.ADD;
100: RAISE fnd_api.g_exc_error;
101: END get_rate_dim_tier_id;
102:
103: -- to get a rate_dim_tier_id from the rate_schedule and sequence numbers
118: RETURN l_rate_dim_tier_id;
119: EXCEPTION
120: when others THEN
121: fnd_message.set_name('CN', 'CN_RATE_DIM_TIER_NOT_EXIST');
122: fnd_msg_pub.ADD;
123: RAISE fnd_api.g_exc_error;
124: END get_rate_dim_tier_id;
125:
126: PROCEDURE translate_values(p_dim_unit_code IN CN_RATE_DIMENSIONS.DIM_UNIT_CODE%TYPE,
141: elsif p_dim_unit_code = 'STRING' then
142: p_string_value := p_value1; -- value2 not used for strings
143: else
144: fnd_message.set_name('CN', 'CN_INVALID_DIM_UOM');
145: fnd_msg_pub.ADD;
146: RAISE fnd_api.g_exc_error;
147: end if;
148:
149: EXCEPTION
148:
149: EXCEPTION
150: when others THEN
151: fnd_message.set_name('CN', 'CN_INVALID_TIER');
152: fnd_msg_pub.ADD;
153: RAISE fnd_api.g_exc_error;
154: END translate_values;
155:
156: -- to raise an error according to the return status passed in
201: END IF;
202:
203: -- Initialize message list if p_init_msg_list is set to TRUE.
204: IF FND_API.to_Boolean( p_init_msg_list ) THEN
205: FND_MSG_PUB.initialize;
206: END IF;
207:
208: -- Initialize API return status to success
209: x_return_status := FND_API.G_RET_STS_SUCCESS;
307: IF FND_API.To_Boolean( p_commit ) THEN
308: COMMIT WORK;
309: END IF;
310: -- Standard call to get message count and if count is 1, get message info.
311: FND_MSG_PUB.Count_And_Get
312: (p_count => x_msg_count ,
313: p_data => x_msg_data ,
314: p_encoded => FND_API.G_FALSE );
315: EXCEPTION
315: EXCEPTION
316: WHEN FND_API.G_EXC_ERROR THEN
317: ROLLBACK TO Create_Schedule;
318: x_return_status := FND_API.G_RET_STS_ERROR ;
319: FND_MSG_PUB.count_and_get
320: (p_count => x_msg_count ,
321: p_data => x_msg_data ,
322: p_encoded => FND_API.G_FALSE );
323: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
322: p_encoded => FND_API.G_FALSE );
323: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
324: ROLLBACK TO Create_Schedule;
325: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
326: FND_MSG_PUB.count_and_get
327: (p_count => x_msg_count ,
328: p_data => x_msg_data ,
329: p_encoded => FND_API.G_FALSE );
330: WHEN OTHERS THEN
329: p_encoded => FND_API.G_FALSE );
330: WHEN OTHERS THEN
331: ROLLBACK TO Create_Schedule;
332: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
333: IF FND_MSG_PUB.check_msg_level
334: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
335: THEN
336: FND_MSG_PUB.add_exc_msg
337: (G_PKG_NAME ,
330: WHEN OTHERS THEN
331: ROLLBACK TO Create_Schedule;
332: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
333: IF FND_MSG_PUB.check_msg_level
334: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
335: THEN
336: FND_MSG_PUB.add_exc_msg
337: (G_PKG_NAME ,
338: l_api_name );
332: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
333: IF FND_MSG_PUB.check_msg_level
334: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
335: THEN
336: FND_MSG_PUB.add_exc_msg
337: (G_PKG_NAME ,
338: l_api_name );
339: END IF;
340: FND_MSG_PUB.count_and_get
336: FND_MSG_PUB.add_exc_msg
337: (G_PKG_NAME ,
338: l_api_name );
339: END IF;
340: FND_MSG_PUB.count_and_get
341: (p_count => x_msg_count ,
342: p_data => x_msg_data ,
343: p_encoded => FND_API.G_FALSE );
344: END Create_Schedule;
385: END IF;
386:
387: -- Initialize message list if p_init_msg_list is set to TRUE.
388: IF FND_API.to_Boolean( p_init_msg_list ) THEN
389: FND_MSG_PUB.initialize;
390: END IF;
391:
392: -- Initialize API return status to success
393: x_return_status := FND_API.G_RET_STS_SUCCESS;
409: 'cn.plsql.cn_multi_rate_schedule_pub.update_schedule.error',
410: true);
411: END IF;
412:
413: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
414: FND_MESSAGE.SET_NAME ('FND' , 'FND_MO_OU_CANNOT_UPDATE');
415: FND_MSG_PUB.Add;
416: END IF;
417:
411: END IF;
412:
413: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
414: FND_MESSAGE.SET_NAME ('FND' , 'FND_MO_OU_CANNOT_UPDATE');
415: FND_MSG_PUB.Add;
416: END IF;
417:
418: RAISE FND_API.G_EXC_ERROR ;
419: END IF;
520: IF FND_API.To_Boolean( p_commit ) THEN
521: COMMIT WORK;
522: END IF;
523: -- Standard call to get message count and if count is 1, get message info.
524: FND_MSG_PUB.count_and_get
525: (p_count => x_msg_count ,
526: p_data => x_msg_data ,
527: p_encoded => FND_API.G_FALSE );
528: EXCEPTION
528: EXCEPTION
529: WHEN FND_API.G_EXC_ERROR THEN
530: ROLLBACK TO Update_Schedule;
531: x_return_status := FND_API.G_RET_STS_ERROR ;
532: FND_MSG_PUB.count_and_get
533: (p_count => x_msg_count ,
534: p_data => x_msg_data ,
535: p_encoded => FND_API.G_FALSE );
536: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
535: p_encoded => FND_API.G_FALSE );
536: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
537: ROLLBACK TO Update_Schedule;
538: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
539: FND_MSG_PUB.count_and_get
540: (p_count => x_msg_count ,
541: p_data => x_msg_data ,
542: p_encoded => FND_API.G_FALSE );
543: WHEN OTHERS THEN
542: p_encoded => FND_API.G_FALSE );
543: WHEN OTHERS THEN
544: ROLLBACK TO Update_Schedule;
545: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
546: IF FND_MSG_PUB.check_msg_level
547: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
548: THEN
549: FND_MSG_PUB.add_exc_msg
550: (G_PKG_NAME ,
543: WHEN OTHERS THEN
544: ROLLBACK TO Update_Schedule;
545: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
546: IF FND_MSG_PUB.check_msg_level
547: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
548: THEN
549: FND_MSG_PUB.add_exc_msg
550: (G_PKG_NAME ,
551: l_api_name );
545: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
546: IF FND_MSG_PUB.check_msg_level
547: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
548: THEN
549: FND_MSG_PUB.add_exc_msg
550: (G_PKG_NAME ,
551: l_api_name );
552: END IF;
553: FND_MSG_PUB.count_and_get
549: FND_MSG_PUB.add_exc_msg
550: (G_PKG_NAME ,
551: l_api_name );
552: END IF;
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: END Update_Schedule;
586: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
587: END IF;
588: -- Initialize message list if p_init_msg_list is set to TRUE.
589: IF FND_API.to_Boolean( p_init_msg_list ) THEN
590: FND_MSG_PUB.initialize;
591: END IF;
592: -- Initialize API return status to success
593: x_return_status := FND_API.G_RET_STS_SUCCESS;
594:
662: IF FND_API.To_Boolean( p_commit ) THEN
663: COMMIT WORK;
664: END IF;
665: -- Standard call to get message count and if count is 1, get message info.
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: EXCEPTION
670: EXCEPTION
671: WHEN FND_API.G_EXC_ERROR THEN
672: ROLLBACK TO Delete_Schedule;
673: x_return_status := FND_API.G_RET_STS_ERROR ;
674: FND_MSG_PUB.count_and_get
675: (p_count => x_msg_count ,
676: p_data => x_msg_data ,
677: p_encoded => FND_API.G_FALSE );
678: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
677: p_encoded => FND_API.G_FALSE );
678: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
679: ROLLBACK TO Delete_Schedule;
680: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
681: FND_MSG_PUB.count_and_get
682: (p_count => x_msg_count ,
683: p_data => x_msg_data ,
684: p_encoded => FND_API.G_FALSE );
685: WHEN OTHERS THEN
684: p_encoded => FND_API.G_FALSE );
685: WHEN OTHERS THEN
686: ROLLBACK TO Delete_Schedule;
687: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
688: IF FND_MSG_PUB.check_msg_level
689: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
690: THEN
691: FND_MSG_PUB.add_exc_msg
692: (G_PKG_NAME ,
685: WHEN OTHERS THEN
686: ROLLBACK TO Delete_Schedule;
687: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
688: IF FND_MSG_PUB.check_msg_level
689: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
690: THEN
691: FND_MSG_PUB.add_exc_msg
692: (G_PKG_NAME ,
693: l_api_name );
687: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
688: IF FND_MSG_PUB.check_msg_level
689: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
690: THEN
691: FND_MSG_PUB.add_exc_msg
692: (G_PKG_NAME ,
693: l_api_name );
694: END IF;
695: FND_MSG_PUB.count_and_get
691: FND_MSG_PUB.add_exc_msg
692: (G_PKG_NAME ,
693: l_api_name );
694: END IF;
695: FND_MSG_PUB.count_and_get
696: (p_count => x_msg_count ,
697: p_data => x_msg_data ,
698: p_encoded => FND_API.G_FALSE );
699: END Delete_Schedule;
736: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
737: END IF;
738: -- Initialize message list if p_init_msg_list is set to TRUE.
739: IF FND_API.to_Boolean( p_init_msg_list ) THEN
740: FND_MSG_PUB.initialize;
741: END IF;
742: -- Initialize API return status to success
743: x_return_status := FND_API.G_RET_STS_SUCCESS;
744:
835: IF FND_API.To_Boolean( p_commit ) THEN
836: COMMIT WORK;
837: END IF;
838: -- Standard call to get message count and if count is 1, get message info.
839: FND_MSG_PUB.Count_And_Get
840: (p_count => x_msg_count ,
841: p_data => x_msg_data ,
842: p_encoded => FND_API.G_FALSE );
843: EXCEPTION
843: EXCEPTION
844: WHEN FND_API.G_EXC_ERROR THEN
845: ROLLBACK TO Create_Dimension_Assign;
846: x_return_status := FND_API.G_RET_STS_ERROR ;
847: FND_MSG_PUB.count_and_get
848: (p_count => x_msg_count ,
849: p_data => x_msg_data ,
850: p_encoded => FND_API.G_FALSE );
851: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
850: p_encoded => FND_API.G_FALSE );
851: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
852: ROLLBACK TO Create_Dimension_Assign;
853: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
854: FND_MSG_PUB.count_and_get
855: (p_count => x_msg_count ,
856: p_data => x_msg_data ,
857: p_encoded => FND_API.G_FALSE );
858: WHEN OTHERS THEN
857: p_encoded => FND_API.G_FALSE );
858: WHEN OTHERS THEN
859: ROLLBACK TO Create_Dimension_Assign;
860: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
861: IF FND_MSG_PUB.check_msg_level
862: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
863: THEN
864: FND_MSG_PUB.add_exc_msg
865: (G_PKG_NAME ,
858: WHEN OTHERS THEN
859: ROLLBACK TO Create_Dimension_Assign;
860: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
861: IF FND_MSG_PUB.check_msg_level
862: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
863: THEN
864: FND_MSG_PUB.add_exc_msg
865: (G_PKG_NAME ,
866: l_api_name );
860: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
861: IF FND_MSG_PUB.check_msg_level
862: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
863: THEN
864: FND_MSG_PUB.add_exc_msg
865: (G_PKG_NAME ,
866: l_api_name );
867: END IF;
868: FND_MSG_PUB.count_and_get
864: FND_MSG_PUB.add_exc_msg
865: (G_PKG_NAME ,
866: l_api_name );
867: END IF;
868: FND_MSG_PUB.count_and_get
869: (p_count => x_msg_count ,
870: p_data => x_msg_data ,
871: p_encoded => FND_API.G_FALSE );
872: END Create_Dimension_Assign;
912: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
913: END IF;
914: -- Initialize message list if p_init_msg_list is set to TRUE.
915: IF FND_API.to_Boolean( p_init_msg_list ) THEN
916: FND_MSG_PUB.initialize;
917: END IF;
918: -- Initialize API return status to success
919: x_return_status := FND_API.G_RET_STS_SUCCESS;
920:
939: 'cn.plsql.cn_multi_rate_schedule_pub.update_dimension_assign.error',
940: true);
941: END IF;
942:
943: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
944: FND_MESSAGE.SET_NAME ('FND' , 'FND_MO_OU_CANNOT_UPDATE');
945: FND_MSG_PUB.Add;
946: END IF;
947:
941: END IF;
942:
943: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
944: FND_MESSAGE.SET_NAME ('FND' , 'FND_MO_OU_CANNOT_UPDATE');
945: FND_MSG_PUB.Add;
946: END IF;
947:
948: RAISE FND_API.G_EXC_ERROR ;
949: END IF;
1047: IF FND_API.To_Boolean( p_commit ) THEN
1048: COMMIT WORK;
1049: END IF;
1050: -- Standard call to get message count and if count is 1, get message info.
1051: FND_MSG_PUB.Count_And_Get
1052: (p_count => x_msg_count ,
1053: p_data => x_msg_data ,
1054: p_encoded => FND_API.G_FALSE );
1055: EXCEPTION
1055: EXCEPTION
1056: WHEN FND_API.G_EXC_ERROR THEN
1057: ROLLBACK TO Update_Dimension_Assign;
1058: x_return_status := FND_API.G_RET_STS_ERROR ;
1059: FND_MSG_PUB.count_and_get
1060: (p_count => x_msg_count ,
1061: p_data => x_msg_data ,
1062: p_encoded => FND_API.G_FALSE );
1063: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1062: p_encoded => FND_API.G_FALSE );
1063: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1064: ROLLBACK TO Update_Dimension_Assign;
1065: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1066: FND_MSG_PUB.count_and_get
1067: (p_count => x_msg_count ,
1068: p_data => x_msg_data ,
1069: p_encoded => FND_API.G_FALSE );
1070: WHEN OTHERS THEN
1069: p_encoded => FND_API.G_FALSE );
1070: WHEN OTHERS THEN
1071: ROLLBACK TO Update_Dimension_Assign;
1072: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1073: IF FND_MSG_PUB.check_msg_level
1074: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1075: THEN
1076: FND_MSG_PUB.add_exc_msg
1077: (G_PKG_NAME ,
1070: WHEN OTHERS THEN
1071: ROLLBACK TO Update_Dimension_Assign;
1072: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1073: IF FND_MSG_PUB.check_msg_level
1074: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1075: THEN
1076: FND_MSG_PUB.add_exc_msg
1077: (G_PKG_NAME ,
1078: l_api_name );
1072: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1073: IF FND_MSG_PUB.check_msg_level
1074: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1075: THEN
1076: FND_MSG_PUB.add_exc_msg
1077: (G_PKG_NAME ,
1078: l_api_name );
1079: END IF;
1080: FND_MSG_PUB.count_and_get
1076: FND_MSG_PUB.add_exc_msg
1077: (G_PKG_NAME ,
1078: l_api_name );
1079: END IF;
1080: FND_MSG_PUB.count_and_get
1081: (p_count => x_msg_count ,
1082: p_data => x_msg_data ,
1083: p_encoded => FND_API.G_FALSE );
1084: END Update_Dimension_Assign;
1115: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1116: END IF;
1117: -- Initialize message list if p_init_msg_list is set to TRUE.
1118: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1119: FND_MSG_PUB.initialize;
1120: END IF;
1121: -- Initialize API return status to success
1122: x_return_status := FND_API.G_RET_STS_SUCCESS;
1123:
1197: IF FND_API.To_Boolean( p_commit ) THEN
1198: COMMIT WORK;
1199: END IF;
1200: -- Standard call to get message count and if count is 1, get message info.
1201: FND_MSG_PUB.Count_And_Get
1202: (p_count => x_msg_count ,
1203: p_data => x_msg_data ,
1204: p_encoded => FND_API.G_FALSE );
1205: EXCEPTION
1205: EXCEPTION
1206: WHEN FND_API.G_EXC_ERROR THEN
1207: ROLLBACK TO Delete_Dimension_Assign;
1208: x_return_status := FND_API.G_RET_STS_ERROR ;
1209: FND_MSG_PUB.count_and_get
1210: (p_count => x_msg_count ,
1211: p_data => x_msg_data ,
1212: p_encoded => FND_API.G_FALSE );
1213: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1212: p_encoded => FND_API.G_FALSE );
1213: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1214: ROLLBACK TO Delete_Dimension_Assign;
1215: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1216: FND_MSG_PUB.count_and_get
1217: (p_count => x_msg_count ,
1218: p_data => x_msg_data ,
1219: p_encoded => FND_API.G_FALSE );
1220: WHEN OTHERS THEN
1219: p_encoded => FND_API.G_FALSE );
1220: WHEN OTHERS THEN
1221: ROLLBACK TO Delete_Dimension_Assign;
1222: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1223: IF FND_MSG_PUB.check_msg_level
1224: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1225: THEN
1226: FND_MSG_PUB.add_exc_msg
1227: (G_PKG_NAME ,
1220: WHEN OTHERS THEN
1221: ROLLBACK TO Delete_Dimension_Assign;
1222: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1223: IF FND_MSG_PUB.check_msg_level
1224: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1225: THEN
1226: FND_MSG_PUB.add_exc_msg
1227: (G_PKG_NAME ,
1228: l_api_name );
1222: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1223: IF FND_MSG_PUB.check_msg_level
1224: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1225: THEN
1226: FND_MSG_PUB.add_exc_msg
1227: (G_PKG_NAME ,
1228: l_api_name );
1229: END IF;
1230: FND_MSG_PUB.count_and_get
1226: FND_MSG_PUB.add_exc_msg
1227: (G_PKG_NAME ,
1228: l_api_name );
1229: END IF;
1230: FND_MSG_PUB.count_and_get
1231: (p_count => x_msg_count ,
1232: p_data => x_msg_data ,
1233: p_encoded => FND_API.G_FALSE );
1234: END Delete_Dimension_Assign;
1274: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1275: END IF;
1276: -- Initialize message list if p_init_msg_list is set to TRUE.
1277: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1278: FND_MSG_PUB.initialize;
1279: END IF;
1280: -- Initialize API return status to success
1281: x_return_status := FND_API.G_RET_STS_SUCCESS;
1282:
1298: 'cn.plsql.cn_multi_rate_schedule_pub.update_rate.error',
1299: true);
1300: END IF;
1301:
1302: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1303: FND_MESSAGE.SET_NAME ('FND' , 'FND_MO_OU_CANNOT_UPDATE');
1304: FND_MSG_PUB.Add;
1305: END IF;
1306:
1300: END IF;
1301:
1302: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1303: FND_MESSAGE.SET_NAME ('FND' , 'FND_MO_OU_CANNOT_UPDATE');
1304: FND_MSG_PUB.Add;
1305: END IF;
1306:
1307: RAISE FND_API.G_EXC_ERROR ;
1308: END IF;
1393: IF FND_API.To_Boolean( p_commit ) THEN
1394: COMMIT WORK;
1395: END IF;
1396: -- Standard call to get message count and if count is 1, get message info.
1397: FND_MSG_PUB.Count_And_Get
1398: (p_count => x_msg_count ,
1399: p_data => x_msg_data ,
1400: p_encoded => FND_API.G_FALSE );
1401: EXCEPTION
1401: EXCEPTION
1402: WHEN FND_API.G_EXC_ERROR THEN
1403: ROLLBACK TO Update_Rate;
1404: x_return_status := FND_API.G_RET_STS_ERROR ;
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: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1408: p_encoded => FND_API.G_FALSE );
1409: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1410: ROLLBACK TO Update_Rate;
1411: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1412: FND_MSG_PUB.count_and_get
1413: (p_count => x_msg_count ,
1414: p_data => x_msg_data ,
1415: p_encoded => FND_API.G_FALSE );
1416: WHEN OTHERS THEN
1415: p_encoded => FND_API.G_FALSE );
1416: WHEN OTHERS THEN
1417: ROLLBACK TO Update_Rate;
1418: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1419: IF FND_MSG_PUB.check_msg_level
1420: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1421: THEN
1422: FND_MSG_PUB.add_exc_msg
1423: (G_PKG_NAME ,
1416: WHEN OTHERS THEN
1417: ROLLBACK TO Update_Rate;
1418: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1419: IF FND_MSG_PUB.check_msg_level
1420: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1421: THEN
1422: FND_MSG_PUB.add_exc_msg
1423: (G_PKG_NAME ,
1424: l_api_name );
1418: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1419: IF FND_MSG_PUB.check_msg_level
1420: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1421: THEN
1422: FND_MSG_PUB.add_exc_msg
1423: (G_PKG_NAME ,
1424: l_api_name );
1425: END IF;
1426: FND_MSG_PUB.count_and_get
1422: FND_MSG_PUB.add_exc_msg
1423: (G_PKG_NAME ,
1424: l_api_name );
1425: END IF;
1426: FND_MSG_PUB.count_and_get
1427: (p_count => x_msg_count ,
1428: p_data => x_msg_data ,
1429: p_encoded => FND_API.G_FALSE );
1430: END Update_Rate;
1468: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1469: END IF;
1470: -- Initialize message list if p_init_msg_list is set to TRUE.
1471: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1472: FND_MSG_PUB.initialize;
1473: END IF;
1474: -- Initialize API return status to success
1475: x_return_status := FND_API.G_RET_STS_SUCCESS;
1476:
1580: IF FND_API.To_Boolean( p_commit ) THEN
1581: COMMIT WORK;
1582: END IF;
1583: -- Standard call to get message count and if count is 1, get message info.
1584: FND_MSG_PUB.Count_And_Get
1585: (p_count => x_msg_count ,
1586: p_data => x_msg_data ,
1587: p_encoded => FND_API.G_FALSE );
1588: EXCEPTION
1588: EXCEPTION
1589: WHEN FND_API.G_EXC_ERROR THEN
1590: ROLLBACK TO Create_Dimension;
1591: x_return_status := FND_API.G_RET_STS_ERROR ;
1592: FND_MSG_PUB.count_and_get
1593: (p_count => x_msg_count ,
1594: p_data => x_msg_data ,
1595: p_encoded => FND_API.G_FALSE );
1596: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1595: p_encoded => FND_API.G_FALSE );
1596: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1597: ROLLBACK TO Create_Dimension;
1598: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1599: FND_MSG_PUB.count_and_get
1600: (p_count => x_msg_count ,
1601: p_data => x_msg_data ,
1602: p_encoded => FND_API.G_FALSE );
1603: WHEN OTHERS THEN
1602: p_encoded => FND_API.G_FALSE );
1603: WHEN OTHERS THEN
1604: ROLLBACK TO Create_Dimension;
1605: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1606: IF FND_MSG_PUB.check_msg_level
1607: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1608: THEN
1609: FND_MSG_PUB.add_exc_msg
1610: (G_PKG_NAME ,
1603: WHEN OTHERS THEN
1604: ROLLBACK TO Create_Dimension;
1605: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1606: IF FND_MSG_PUB.check_msg_level
1607: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1608: THEN
1609: FND_MSG_PUB.add_exc_msg
1610: (G_PKG_NAME ,
1611: l_api_name );
1605: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1606: IF FND_MSG_PUB.check_msg_level
1607: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1608: THEN
1609: FND_MSG_PUB.add_exc_msg
1610: (G_PKG_NAME ,
1611: l_api_name );
1612: END IF;
1613: FND_MSG_PUB.count_and_get
1609: FND_MSG_PUB.add_exc_msg
1610: (G_PKG_NAME ,
1611: l_api_name );
1612: END IF;
1613: FND_MSG_PUB.count_and_get
1614: (p_count => x_msg_count ,
1615: p_data => x_msg_data ,
1616: p_encoded => FND_API.G_FALSE );
1617: END Create_Dimension;
1667: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1668: END IF;
1669: -- Initialize message list if p_init_msg_list is set to TRUE.
1670: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1671: FND_MSG_PUB.initialize;
1672: END IF;
1673: -- Initialize API return status to success
1674: x_return_status := FND_API.G_RET_STS_SUCCESS;
1675:
1691: 'cn.plsql.cn_multi_rate_schedule_pub.update_dimenstion.error',
1692: true);
1693: END IF;
1694:
1695: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1696: FND_MESSAGE.SET_NAME ('FND' , 'FND_MO_OU_CANNOT_UPDATE');
1697: FND_MSG_PUB.Add;
1698: END IF;
1699:
1693: END IF;
1694:
1695: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1696: FND_MESSAGE.SET_NAME ('FND' , 'FND_MO_OU_CANNOT_UPDATE');
1697: FND_MSG_PUB.Add;
1698: END IF;
1699:
1700: RAISE FND_API.G_EXC_ERROR ;
1701: END IF;
1815: IF FND_API.To_Boolean( p_commit ) THEN
1816: COMMIT WORK;
1817: END IF;
1818: -- Standard call to get message count and if count is 1, get message info.
1819: FND_MSG_PUB.count_and_get
1820: (p_count => x_msg_count ,
1821: p_data => x_msg_data ,
1822: p_encoded => FND_API.G_FALSE );
1823: EXCEPTION
1823: EXCEPTION
1824: WHEN FND_API.G_EXC_ERROR THEN
1825: ROLLBACK TO Update_Dimension;
1826: x_return_status := FND_API.G_RET_STS_ERROR ;
1827: FND_MSG_PUB.count_and_get
1828: (p_count => x_msg_count ,
1829: p_data => x_msg_data ,
1830: p_encoded => FND_API.G_FALSE );
1831: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1830: p_encoded => FND_API.G_FALSE );
1831: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1832: ROLLBACK TO Update_Dimension;
1833: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1834: FND_MSG_PUB.count_and_get
1835: (p_count => x_msg_count ,
1836: p_data => x_msg_data ,
1837: p_encoded => FND_API.G_FALSE );
1838: WHEN OTHERS THEN
1837: p_encoded => FND_API.G_FALSE );
1838: WHEN OTHERS THEN
1839: ROLLBACK TO Update_Dimension;
1840: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1841: IF FND_MSG_PUB.check_msg_level
1842: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1843: THEN
1844: FND_MSG_PUB.add_exc_msg
1845: (G_PKG_NAME ,
1838: WHEN OTHERS THEN
1839: ROLLBACK TO Update_Dimension;
1840: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1841: IF FND_MSG_PUB.check_msg_level
1842: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1843: THEN
1844: FND_MSG_PUB.add_exc_msg
1845: (G_PKG_NAME ,
1846: l_api_name );
1840: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1841: IF FND_MSG_PUB.check_msg_level
1842: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1843: THEN
1844: FND_MSG_PUB.add_exc_msg
1845: (G_PKG_NAME ,
1846: l_api_name );
1847: END IF;
1848: FND_MSG_PUB.count_and_get
1844: FND_MSG_PUB.add_exc_msg
1845: (G_PKG_NAME ,
1846: l_api_name );
1847: END IF;
1848: FND_MSG_PUB.count_and_get
1849: (p_count => x_msg_count ,
1850: p_data => x_msg_data ,
1851: p_encoded => FND_API.G_FALSE );
1852: END Update_Dimension;
1881: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1882: END IF;
1883: -- Initialize message list if p_init_msg_list is set to TRUE.
1884: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1885: FND_MSG_PUB.initialize;
1886: END IF;
1887: -- Initialize API return status to success
1888: x_return_status := FND_API.G_RET_STS_SUCCESS;
1889:
1956: IF FND_API.To_Boolean( p_commit ) THEN
1957: COMMIT WORK;
1958: END IF;
1959: -- Standard call to get message count and if count is 1, get message info.
1960: FND_MSG_PUB.count_and_get
1961: (p_count => x_msg_count ,
1962: p_data => x_msg_data ,
1963: p_encoded => FND_API.G_FALSE );
1964: EXCEPTION
1964: EXCEPTION
1965: WHEN FND_API.G_EXC_ERROR THEN
1966: ROLLBACK TO Delete_Dimension;
1967: x_return_status := FND_API.G_RET_STS_ERROR ;
1968: FND_MSG_PUB.count_and_get
1969: (p_count => x_msg_count ,
1970: p_data => x_msg_data ,
1971: p_encoded => FND_API.G_FALSE );
1972: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1971: p_encoded => FND_API.G_FALSE );
1972: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1973: ROLLBACK TO Delete_Dimension;
1974: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1975: FND_MSG_PUB.count_and_get
1976: (p_count => x_msg_count ,
1977: p_data => x_msg_data ,
1978: p_encoded => FND_API.G_FALSE );
1979: WHEN OTHERS THEN
1978: p_encoded => FND_API.G_FALSE );
1979: WHEN OTHERS THEN
1980: ROLLBACK TO Delete_Dimension;
1981: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1982: IF FND_MSG_PUB.check_msg_level
1983: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1984: THEN
1985: FND_MSG_PUB.add_exc_msg
1986: (G_PKG_NAME ,
1979: WHEN OTHERS THEN
1980: ROLLBACK TO Delete_Dimension;
1981: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1982: IF FND_MSG_PUB.check_msg_level
1983: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1984: THEN
1985: FND_MSG_PUB.add_exc_msg
1986: (G_PKG_NAME ,
1987: l_api_name );
1981: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1982: IF FND_MSG_PUB.check_msg_level
1983: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1984: THEN
1985: FND_MSG_PUB.add_exc_msg
1986: (G_PKG_NAME ,
1987: l_api_name );
1988: END IF;
1989: FND_MSG_PUB.count_and_get
1985: FND_MSG_PUB.add_exc_msg
1986: (G_PKG_NAME ,
1987: l_api_name );
1988: END IF;
1989: FND_MSG_PUB.count_and_get
1990: (p_count => x_msg_count ,
1991: p_data => x_msg_data ,
1992: p_encoded => FND_API.G_FALSE );
1993: END Delete_Dimension;
2036: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2037: END IF;
2038: -- Initialize message list if p_init_msg_list is set to TRUE.
2039: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2040: FND_MSG_PUB.initialize;
2041: END IF;
2042: -- Initialize API return status to success
2043: x_return_status := FND_API.G_RET_STS_SUCCESS;
2044:
2149: IF FND_API.To_Boolean( p_commit ) THEN
2150: COMMIT WORK;
2151: END IF;
2152: -- Standard call to get message count and if count is 1, get message info.
2153: FND_MSG_PUB.Count_And_Get
2154: (p_count => x_msg_count ,
2155: p_data => x_msg_data ,
2156: p_encoded => FND_API.G_FALSE );
2157: EXCEPTION
2157: EXCEPTION
2158: WHEN FND_API.G_EXC_ERROR THEN
2159: ROLLBACK TO Create_tier;
2160: x_return_status := FND_API.G_RET_STS_ERROR ;
2161: FND_MSG_PUB.count_and_get
2162: (p_count => x_msg_count ,
2163: p_data => x_msg_data ,
2164: p_encoded => FND_API.G_FALSE );
2165: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2164: p_encoded => FND_API.G_FALSE );
2165: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2166: ROLLBACK TO Create_tier;
2167: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2168: FND_MSG_PUB.count_and_get
2169: (p_count => x_msg_count ,
2170: p_data => x_msg_data ,
2171: p_encoded => FND_API.G_FALSE );
2172: WHEN OTHERS THEN
2171: p_encoded => FND_API.G_FALSE );
2172: WHEN OTHERS THEN
2173: ROLLBACK TO Create_tier;
2174: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2175: IF FND_MSG_PUB.check_msg_level
2176: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2177: THEN
2178: FND_MSG_PUB.add_exc_msg
2179: (G_PKG_NAME ,
2172: WHEN OTHERS THEN
2173: ROLLBACK TO Create_tier;
2174: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2175: IF FND_MSG_PUB.check_msg_level
2176: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2177: THEN
2178: FND_MSG_PUB.add_exc_msg
2179: (G_PKG_NAME ,
2180: l_api_name );
2174: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2175: IF FND_MSG_PUB.check_msg_level
2176: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2177: THEN
2178: FND_MSG_PUB.add_exc_msg
2179: (G_PKG_NAME ,
2180: l_api_name );
2181: END IF;
2182: FND_MSG_PUB.count_and_get
2178: FND_MSG_PUB.add_exc_msg
2179: (G_PKG_NAME ,
2180: l_api_name );
2181: END IF;
2182: FND_MSG_PUB.count_and_get
2183: (p_count => x_msg_count ,
2184: p_data => x_msg_data ,
2185: p_encoded => FND_API.G_FALSE );
2186: END Create_tier;
2228: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2229: END IF;
2230: -- Initialize message list if p_init_msg_list is set to TRUE.
2231: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2232: FND_MSG_PUB.initialize;
2233: END IF;
2234: -- Initialize API return status to success
2235: x_return_status := FND_API.G_RET_STS_SUCCESS;
2236:
2253: 'cn.plsql.cn_multi_rate_schedule_pub.update_tier.error',
2254: true);
2255: END IF;
2256:
2257: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2258: FND_MESSAGE.SET_NAME ('FND' , 'FND_MO_OU_CANNOT_UPDATE');
2259: FND_MSG_PUB.Add;
2260: END IF;
2261:
2255: END IF;
2256:
2257: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2258: FND_MESSAGE.SET_NAME ('FND' , 'FND_MO_OU_CANNOT_UPDATE');
2259: FND_MSG_PUB.Add;
2260: END IF;
2261:
2262: RAISE FND_API.G_EXC_ERROR ;
2263: END IF;
2357: IF FND_API.To_Boolean( p_commit ) THEN
2358: COMMIT WORK;
2359: END IF;
2360: -- Standard call to get message count and if count is 1, get message info.
2361: FND_MSG_PUB.Count_And_Get
2362: (p_count => x_msg_count ,
2363: p_data => x_msg_data ,
2364: p_encoded => FND_API.G_FALSE );
2365: EXCEPTION
2365: EXCEPTION
2366: WHEN FND_API.G_EXC_ERROR THEN
2367: ROLLBACK TO Update_tier;
2368: x_return_status := FND_API.G_RET_STS_ERROR ;
2369: FND_MSG_PUB.count_and_get
2370: (p_count => x_msg_count ,
2371: p_data => x_msg_data ,
2372: p_encoded => FND_API.G_FALSE );
2373: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2372: p_encoded => FND_API.G_FALSE );
2373: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2374: ROLLBACK TO Update_tier;
2375: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2376: FND_MSG_PUB.count_and_get
2377: (p_count => x_msg_count ,
2378: p_data => x_msg_data ,
2379: p_encoded => FND_API.G_FALSE );
2380: WHEN OTHERS THEN
2379: p_encoded => FND_API.G_FALSE );
2380: WHEN OTHERS THEN
2381: ROLLBACK TO Update_tier;
2382: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2383: IF FND_MSG_PUB.check_msg_level
2384: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2385: THEN
2386: FND_MSG_PUB.add_exc_msg
2387: (G_PKG_NAME ,
2380: WHEN OTHERS THEN
2381: ROLLBACK TO Update_tier;
2382: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2383: IF FND_MSG_PUB.check_msg_level
2384: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2385: THEN
2386: FND_MSG_PUB.add_exc_msg
2387: (G_PKG_NAME ,
2388: l_api_name );
2382: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2383: IF FND_MSG_PUB.check_msg_level
2384: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2385: THEN
2386: FND_MSG_PUB.add_exc_msg
2387: (G_PKG_NAME ,
2388: l_api_name );
2389: END IF;
2390: FND_MSG_PUB.count_and_get
2386: FND_MSG_PUB.add_exc_msg
2387: (G_PKG_NAME ,
2388: l_api_name );
2389: END IF;
2390: FND_MSG_PUB.count_and_get
2391: (p_count => x_msg_count ,
2392: p_data => x_msg_data ,
2393: p_encoded => FND_API.G_FALSE );
2394: END Update_tier;
2424: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2425: END IF;
2426: -- Initialize message list if p_init_msg_list is set to TRUE.
2427: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2428: FND_MSG_PUB.initialize;
2429: END IF;
2430: -- Initialize API return status to success
2431: x_return_status := FND_API.G_RET_STS_SUCCESS;
2432:
2501: IF FND_API.To_Boolean( p_commit ) THEN
2502: COMMIT WORK;
2503: END IF;
2504: -- Standard call to get message count and if count is 1, get message info.
2505: FND_MSG_PUB.Count_And_Get
2506: (p_count => x_msg_count ,
2507: p_data => x_msg_data ,
2508: p_encoded => FND_API.G_FALSE );
2509: EXCEPTION
2509: EXCEPTION
2510: WHEN FND_API.G_EXC_ERROR THEN
2511: ROLLBACK TO Delete_Tier;
2512: x_return_status := FND_API.G_RET_STS_ERROR ;
2513: FND_MSG_PUB.count_and_get
2514: (p_count => x_msg_count ,
2515: p_data => x_msg_data ,
2516: p_encoded => FND_API.G_FALSE );
2517: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2516: p_encoded => FND_API.G_FALSE );
2517: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2518: ROLLBACK TO Delete_Tier;
2519: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2520: FND_MSG_PUB.count_and_get
2521: (p_count => x_msg_count ,
2522: p_data => x_msg_data ,
2523: p_encoded => FND_API.G_FALSE );
2524: WHEN OTHERS THEN
2523: p_encoded => FND_API.G_FALSE );
2524: WHEN OTHERS THEN
2525: ROLLBACK TO Delete_Tier;
2526: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2527: IF FND_MSG_PUB.check_msg_level
2528: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2529: THEN
2530: FND_MSG_PUB.add_exc_msg
2531: (G_PKG_NAME ,
2524: WHEN OTHERS THEN
2525: ROLLBACK TO Delete_Tier;
2526: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2527: IF FND_MSG_PUB.check_msg_level
2528: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2529: THEN
2530: FND_MSG_PUB.add_exc_msg
2531: (G_PKG_NAME ,
2532: l_api_name );
2526: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2527: IF FND_MSG_PUB.check_msg_level
2528: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2529: THEN
2530: FND_MSG_PUB.add_exc_msg
2531: (G_PKG_NAME ,
2532: l_api_name );
2533: END IF;
2534: FND_MSG_PUB.count_and_get
2530: FND_MSG_PUB.add_exc_msg
2531: (G_PKG_NAME ,
2532: l_api_name );
2533: END IF;
2534: FND_MSG_PUB.count_and_get
2535: (p_count => x_msg_count ,
2536: p_data => x_msg_data ,
2537: p_encoded => FND_API.G_FALSE );
2538: END Delete_Tier;