54: --
55: -- Initialize message list if p_init_msg_list is set to TRUE.
56: --
57: IF FND_API.to_Boolean( p_init_msg_list ) THEN
58: FND_MSG_PUB.initialize;
59: END IF;
60:
61: --
62: -- Initialize API return status to success
126: --
127: -- Standard call to get message count and if count is 1, get message info.
128: --
129:
130: FND_MSG_PUB.Count_And_Get
131: (
132: p_count => x_msg_count ,
133: p_data => x_msg_data ,
134: p_encoded => FND_API.G_FALSE
137: EXCEPTION
138: WHEN FND_API.G_EXC_ERROR THEN
139: ROLLBACK TO update_srp_quota_assign;
140: x_return_status := FND_API.G_RET_STS_ERROR ;
141: FND_MSG_PUB.Count_And_Get
142: (
143: p_count => x_msg_count ,
144: p_data => x_msg_data ,
145: p_encoded => FND_API.G_FALSE
147: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
148: ROLLBACK TO update_srp_quota_assign;
149: x_loading_status := 'UNEXPECTED_ERR';
150: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
151: FND_MSG_PUB.Count_And_Get
152: (
153: p_count => x_msg_count ,
154: p_data => x_msg_data ,
155: p_encoded => FND_API.G_FALSE
157: WHEN OTHERS THEN
158: ROLLBACK TO update_srp_quota_assign;
159: x_loading_status := 'UNEXPECTED_ERR';
160: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
161: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
162: THEN
163: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
164: END IF;
165: FND_MSG_PUB.Count_And_Get
159: x_loading_status := 'UNEXPECTED_ERR';
160: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
161: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
162: THEN
163: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
164: END IF;
165: FND_MSG_PUB.Count_And_Get
166: (
167: p_count => x_msg_count ,
161: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
162: THEN
163: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
164: END IF;
165: FND_MSG_PUB.Count_And_Get
166: (
167: p_count => x_msg_count ,
168: p_data => x_msg_data ,
169: p_encoded => FND_API.G_FALSE
217: --
218: -- Initialize message list if p_init_msg_list is set to TRUE.
219: --
220: IF FND_API.to_Boolean( p_init_msg_list ) THEN
221: FND_MSG_PUB.initialize;
222: END IF;
223:
224: --
225: -- Initialize API return status to success
289: --
290: -- Standard call to get message count and if count is 1, get message info.
291: --
292:
293: FND_MSG_PUB.Count_And_Get
294: (
295: p_count => x_msg_count ,
296: p_data => x_msg_data ,
297: p_encoded => FND_API.G_FALSE
299: EXCEPTION
300: WHEN FND_API.G_EXC_ERROR THEN
301: ROLLBACK TO change_srp_quota_custom_flag;
302: x_return_status := FND_API.G_RET_STS_ERROR ;
303: FND_MSG_PUB.Count_And_Get
304: (
305: p_count => x_msg_count ,
306: p_data => x_msg_data ,
307: p_encoded => FND_API.G_FALSE
309: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
310: ROLLBACK TO change_srp_quota_custom_flag;
311: x_loading_status := 'UNEXPECTED_ERR';
312: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
313: FND_MSG_PUB.Count_And_Get
314: (
315: p_count => x_msg_count ,
316: p_data => x_msg_data ,
317: p_encoded => FND_API.G_FALSE
319: WHEN OTHERS THEN
320: ROLLBACK TO change_srp_quota_custom_flag;
321: x_loading_status := 'UNEXPECTED_ERR';
322: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
323: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
324: THEN
325: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
326: END IF;
327: FND_MSG_PUB.Count_And_Get
321: x_loading_status := 'UNEXPECTED_ERR';
322: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
323: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
324: THEN
325: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
326: END IF;
327: FND_MSG_PUB.Count_And_Get
328: (
329: p_count => x_msg_count ,
323: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
324: THEN
325: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
326: END IF;
327: FND_MSG_PUB.Count_And_Get
328: (
329: p_count => x_msg_count ,
330: p_data => x_msg_data ,
331: p_encoded => FND_API.G_FALSE
376: --
377: -- Initialize message list if p_init_msg_list is set to TRUE.
378: --
379: IF FND_API.to_Boolean( p_init_msg_list ) THEN
380: FND_MSG_PUB.initialize;
381: END IF;
382:
383: --
384: -- Initialize API return status to success
415: --
416: -- Standard call to get message count and if count is 1, get message info.
417: --
418:
419: FND_MSG_PUB.Count_And_Get
420: (
421: p_count => x_msg_count ,
422: p_data => x_msg_data ,
423: p_encoded => FND_API.G_FALSE
426: EXCEPTION
427: WHEN FND_API.G_EXC_ERROR THEN
428: ROLLBACK TO Update_Srp_Quota_Rules;
429: x_return_status := FND_API.G_RET_STS_ERROR ;
430: FND_MSG_PUB.Count_And_Get
431: (
432: p_count => x_msg_count ,
433: p_data => x_msg_data ,
434: p_encoded => FND_API.G_FALSE
436: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
437: ROLLBACK TO Update_Srp_Quota_Rules;
438: x_loading_status := 'UNEXPECTED_ERR';
439: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
440: FND_MSG_PUB.Count_And_Get
441: (
442: p_count => x_msg_count ,
443: p_data => x_msg_data ,
444: p_encoded => FND_API.G_FALSE
446: WHEN OTHERS THEN
447: ROLLBACK TO Update_Srp_Quota_Rules;
448: x_loading_status := 'UNEXPECTED_ERR';
449: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
450: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
451: THEN
452: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
453: END IF;
454: FND_MSG_PUB.Count_And_Get
448: x_loading_status := 'UNEXPECTED_ERR';
449: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
450: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
451: THEN
452: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
453: END IF;
454: FND_MSG_PUB.Count_And_Get
455: (
456: p_count => x_msg_count ,
450: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
451: THEN
452: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
453: END IF;
454: FND_MSG_PUB.Count_And_Get
455: (
456: p_count => x_msg_count ,
457: p_data => x_msg_data ,
458: p_encoded => FND_API.G_FALSE
503: --
504: -- Initialize message list if p_init_msg_list is set to TRUE.
505: --
506: IF FND_API.to_Boolean( p_init_msg_list ) THEN
507: FND_MSG_PUB.initialize;
508: END IF;
509:
510: --
511: -- Initialize API return status to success
545: --
546: -- Standard call to get message count and if count is 1, get message info.
547: --
548:
549: FND_MSG_PUB.Count_And_Get
550: (
551: p_count => x_msg_count ,
552: p_data => x_msg_data ,
553: p_encoded => FND_API.G_FALSE
556: EXCEPTION
557: WHEN FND_API.G_EXC_ERROR THEN
558: ROLLBACK TO Update_Srp_Rule_Uplifts;
559: x_return_status := FND_API.G_RET_STS_ERROR ;
560: FND_MSG_PUB.Count_And_Get
561: (
562: p_count => x_msg_count ,
563: p_data => x_msg_data ,
564: p_encoded => FND_API.G_FALSE
566: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
567: ROLLBACK TO Update_Srp_Rule_Uplifts;
568: x_loading_status := 'UNEXPECTED_ERR';
569: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
570: FND_MSG_PUB.Count_And_Get
571: (
572: p_count => x_msg_count ,
573: p_data => x_msg_data ,
574: p_encoded => FND_API.G_FALSE
576: WHEN OTHERS THEN
577: ROLLBACK TO Update_Srp_Rule_Uplifts;
578: x_loading_status := 'UNEXPECTED_ERR';
579: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
580: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
581: THEN
582: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
583: END IF;
584: FND_MSG_PUB.Count_And_Get
578: x_loading_status := 'UNEXPECTED_ERR';
579: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
580: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
581: THEN
582: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
583: END IF;
584: FND_MSG_PUB.Count_And_Get
585: (
586: p_count => x_msg_count ,
580: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
581: THEN
582: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
583: END IF;
584: FND_MSG_PUB.Count_And_Get
585: (
586: p_count => x_msg_count ,
587: p_data => x_msg_data ,
588: p_encoded => FND_API.G_FALSE