DBA Data[Home] [Help]

APPS.CN_SRP_CUSTOMIZE_PUB dependencies on FND_MSG_PUB

Line 58: FND_MSG_PUB.initialize;

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

Line 130: FND_MSG_PUB.Count_And_Get

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

Line 141: FND_MSG_PUB.Count_And_Get

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

Line 151: FND_MSG_PUB.Count_And_Get

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

Line 161: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

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

Line 163: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );

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 ,

Line 165: FND_MSG_PUB.Count_And_Get

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

Line 221: FND_MSG_PUB.initialize;

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

Line 293: FND_MSG_PUB.Count_And_Get

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

Line 303: FND_MSG_PUB.Count_And_Get

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

Line 313: FND_MSG_PUB.Count_And_Get

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

Line 323: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

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

Line 325: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );

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 ,

Line 327: FND_MSG_PUB.Count_And_Get

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

Line 380: FND_MSG_PUB.initialize;

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

Line 419: FND_MSG_PUB.Count_And_Get

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

Line 430: FND_MSG_PUB.Count_And_Get

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

Line 440: FND_MSG_PUB.Count_And_Get

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

Line 450: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

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

Line 452: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );

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 ,

Line 454: FND_MSG_PUB.Count_And_Get

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

Line 507: FND_MSG_PUB.initialize;

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

Line 549: FND_MSG_PUB.Count_And_Get

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

Line 560: FND_MSG_PUB.Count_And_Get

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

Line 570: FND_MSG_PUB.Count_And_Get

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

Line 580: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

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

Line 582: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );

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 ,

Line 584: FND_MSG_PUB.Count_And_Get

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