DBA Data[Home] [Help]

APPS.CN_PAYGROUP_PUB dependencies on FND_MSG_PUB

Line 87: FND_MSG_PUB.initialize;

83: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
84: END IF;
85: -- Initialize message list if p_init_msg_list is set to TRUE.
86: IF FND_API.to_Boolean( p_init_msg_list ) THEN
87: FND_MSG_PUB.initialize;
88: END IF;
89: -- Initialize API return status to success
90: x_return_status := FND_API.G_RET_STS_SUCCESS;
91: -- API body

Line 136: FND_MSG_PUB.Count_And_Get

132: IF FND_API.To_Boolean( p_commit ) THEN
133: COMMIT WORK;
134: END IF;
135: -- Standard call to get message count and if count is 1, get message info.
136: FND_MSG_PUB.Count_And_Get
137: (p_count => x_msg_count ,
138: p_data => x_msg_data ,
139: p_encoded => FND_API.G_FALSE );
140: EXCEPTION

Line 144: FND_MSG_PUB.Count_And_Get

140: EXCEPTION
141: WHEN FND_API.G_EXC_ERROR THEN
142: ROLLBACK TO Get_Pay_Group_Sum;
143: x_return_status := FND_API.G_RET_STS_ERROR ;
144: FND_MSG_PUB.Count_And_Get
145: (p_count => x_msg_count ,
146: p_data => x_msg_data ,
147: p_encoded => FND_API.G_FALSE );
148: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 151: FND_MSG_PUB.Count_And_Get

147: p_encoded => FND_API.G_FALSE );
148: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
149: ROLLBACK TO Get_Pay_Group_Sum;
150: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
151: FND_MSG_PUB.Count_And_Get
152: (p_count => x_msg_count ,
153: p_data => x_msg_data ,
154: p_encoded => FND_API.G_FALSE );
155: WHEN OTHERS THEN

Line 158: IF FND_MSG_PUB.Check_Msg_Level

154: p_encoded => FND_API.G_FALSE );
155: WHEN OTHERS THEN
156: ROLLBACK TO Get_Pay_Group_Sum;
157: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
158: IF FND_MSG_PUB.Check_Msg_Level
159: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
160: THEN
161: FND_MSG_PUB.Add_Exc_Msg
162: (G_PKG_NAME ,

Line 159: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

155: WHEN OTHERS THEN
156: ROLLBACK TO Get_Pay_Group_Sum;
157: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
158: IF FND_MSG_PUB.Check_Msg_Level
159: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
160: THEN
161: FND_MSG_PUB.Add_Exc_Msg
162: (G_PKG_NAME ,
163: l_api_name );

Line 161: FND_MSG_PUB.Add_Exc_Msg

157: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
158: IF FND_MSG_PUB.Check_Msg_Level
159: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
160: THEN
161: FND_MSG_PUB.Add_Exc_Msg
162: (G_PKG_NAME ,
163: l_api_name );
164: END IF;
165: FND_MSG_PUB.Count_And_Get

Line 165: FND_MSG_PUB.Count_And_Get

161: FND_MSG_PUB.Add_Exc_Msg
162: (G_PKG_NAME ,
163: l_api_name );
164: END IF;
165: FND_MSG_PUB.Count_And_Get
166: (p_count => x_msg_count ,
167: p_data => x_msg_data ,
168: p_encoded => FND_API.G_FALSE );
169: END Get_Pay_Group_Sum;

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

235: EXCEPTION
236: WHEN OTHERS THEN
237: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
238: x_loading_status := 'UNEXPECTED_ERR';
239: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
240: THEN
241: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
242: END IF;
243:

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

237: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
238: x_loading_status := 'UNEXPECTED_ERR';
239: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
240: THEN
241: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
242: END IF;
243:
244: END Get_PayGroup_ID;
245:

Line 294: FND_MSG_PUB.initialize;

290:
291: -- Initialize message list if p_init_msg_list is set to TRUE.
292:
293: IF FND_API.to_Boolean( p_init_msg_list ) THEN
294: FND_MSG_PUB.initialize;
295: END IF;
296:
297:
298: -- Initialize API return status to success

Line 369: FND_MSG_PUB.Count_And_Get

365: );
366:
367: -- Standard call to get message count and if count is 1, get message info.
368:
369: FND_MSG_PUB.Count_And_Get
370: (
371: p_count => x_msg_count ,
372: p_data => x_msg_data ,
373: p_encoded => FND_API.G_FALSE

Line 380: FND_MSG_PUB.Count_And_Get

376: EXCEPTION
377: WHEN FND_API.G_EXC_ERROR THEN
378: ROLLBACK TO Create_PayGroup;
379: x_return_status := FND_API.G_RET_STS_ERROR ;
380: FND_MSG_PUB.Count_And_Get
381: (
382: p_count => x_msg_count ,
383: p_data => x_msg_data ,
384: p_encoded => FND_API.G_FALSE

Line 390: FND_MSG_PUB.Count_And_Get

386: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
387: ROLLBACK TO Create_PayGroup;
388: x_loading_status := 'UNEXPECTED_ERR';
389: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
390: FND_MSG_PUB.Count_And_Get
391: (
392: p_count => x_msg_count ,
393: p_data => x_msg_data ,
394: p_encoded => FND_API.G_FALSE

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

396: WHEN OTHERS THEN
397: ROLLBACK TO Create_PayGroup;
398: x_loading_status := 'UNEXPECTED_ERR';
399: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
400: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
401: THEN
402: FND_MSG_PUB.Add_Exc_Msg( L_PKG_NAME ,l_api_name );
403: END IF;
404: FND_MSG_PUB.Count_And_Get

Line 402: FND_MSG_PUB.Add_Exc_Msg( L_PKG_NAME ,l_api_name );

398: x_loading_status := 'UNEXPECTED_ERR';
399: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
400: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
401: THEN
402: FND_MSG_PUB.Add_Exc_Msg( L_PKG_NAME ,l_api_name );
403: END IF;
404: FND_MSG_PUB.Count_And_Get
405: (
406: p_count => x_msg_count ,

Line 404: FND_MSG_PUB.Count_And_Get

400: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
401: THEN
402: FND_MSG_PUB.Add_Exc_Msg( L_PKG_NAME ,l_api_name );
403: END IF;
404: FND_MSG_PUB.Count_And_Get
405: (
406: p_count => x_msg_count ,
407: p_data => x_msg_data ,
408: p_encoded => FND_API.G_FALSE

Line 466: FND_MSG_PUB.initialize;

462:
463: -- Initialize message list if p_init_msg_list is set to TRUE.
464:
465: IF FND_API.to_Boolean( p_init_msg_list ) THEN
466: FND_MSG_PUB.initialize;
467: END IF;
468:
469: -- Initialize API return status to success
470:

Line 490: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

486: 'cn.plsql.cn_paygroup_pub.update_paygroup.error',
487: true);
488: end if;
489:
490: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
491: FND_MESSAGE.SET_NAME ('FND' , 'FND_MO_OU_CANNOT_UPDATE');
492: FND_MSG_PUB.Add;
493: END IF;
494:

Line 492: FND_MSG_PUB.Add;

488: end if;
489:
490: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
491: FND_MESSAGE.SET_NAME ('FND' , 'FND_MO_OU_CANNOT_UPDATE');
492: FND_MSG_PUB.Add;
493: END IF;
494:
495: RAISE FND_API.G_EXC_ERROR ;
496: end if;

Line 554: FND_MSG_PUB.Count_And_Get

550: );
551:
552: -- Standard call to get message count and if count is 1, get message info.
553:
554: FND_MSG_PUB.Count_And_Get
555: (
556: p_count => x_msg_count ,
557: p_data => x_msg_data ,
558: p_encoded => FND_API.G_FALSE

Line 564: FND_MSG_PUB.Count_And_Get

560: EXCEPTION
561: WHEN FND_API.G_EXC_ERROR THEN
562: ROLLBACK TO Update_PayGroup;
563: x_return_status := FND_API.G_RET_STS_ERROR ;
564: FND_MSG_PUB.Count_And_Get
565: (
566: p_count => x_msg_count ,
567: p_data => x_msg_data ,
568: p_encoded => FND_API.G_FALSE

Line 574: FND_MSG_PUB.Count_And_Get

570: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
571: ROLLBACK TO Update_PayGroup;
572: x_loading_status := 'UNEXPECTED_ERR';
573: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
574: FND_MSG_PUB.Count_And_Get
575: (
576: p_count => x_msg_count ,
577: p_data => x_msg_data ,
578: p_encoded => FND_API.G_FALSE

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

580: WHEN OTHERS THEN
581: ROLLBACK TO Update_PayGroup;
582: x_loading_status := 'UNEXPECTED_ERR';
583: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
584: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
585: THEN
586: FND_MSG_PUB.Add_Exc_Msg( L_PKG_NAME ,l_api_name );
587: END IF;
588: FND_MSG_PUB.Count_And_Get

Line 586: FND_MSG_PUB.Add_Exc_Msg( L_PKG_NAME ,l_api_name );

582: x_loading_status := 'UNEXPECTED_ERR';
583: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
584: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
585: THEN
586: FND_MSG_PUB.Add_Exc_Msg( L_PKG_NAME ,l_api_name );
587: END IF;
588: FND_MSG_PUB.Count_And_Get
589: (
590: p_count => x_msg_count ,

Line 588: FND_MSG_PUB.Count_And_Get

584: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
585: THEN
586: FND_MSG_PUB.Add_Exc_Msg( L_PKG_NAME ,l_api_name );
587: END IF;
588: FND_MSG_PUB.Count_And_Get
589: (
590: p_count => x_msg_count ,
591: p_data => x_msg_data ,
592: p_encoded => FND_API.G_FALSE

Line 646: FND_MSG_PUB.initialize;

642:
643: -- Initialize message list if p_init_msg_list is set to TRUE.
644:
645: IF FND_API.to_Boolean( p_init_msg_list ) THEN
646: FND_MSG_PUB.initialize;
647: END IF;
648:
649: -- Initialize API return status to success
650:

Line 719: FND_MSG_PUB.Count_And_Get

715: );
716:
717: -- Standard call to get message count and if count is 1, get message info.
718:
719: FND_MSG_PUB.Count_And_Get
720: (
721: p_count => x_msg_count ,
722: p_data => x_msg_data ,
723: p_encoded => FND_API.G_FALSE

Line 729: FND_MSG_PUB.Count_And_Get

725: EXCEPTION
726: WHEN FND_API.G_EXC_ERROR THEN
727: ROLLBACK TO Delete_PayGroup;
728: x_return_status := FND_API.G_RET_STS_ERROR ;
729: FND_MSG_PUB.Count_And_Get
730: (
731: p_count => x_msg_count ,
732: p_data => x_msg_data ,
733: p_encoded => FND_API.G_FALSE

Line 739: FND_MSG_PUB.Count_And_Get

735: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
736: ROLLBACK TO Delete_PayGroup;
737: x_loading_status := 'UNEXPECTED_ERR';
738: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
739: FND_MSG_PUB.Count_And_Get
740: (
741: p_count => x_msg_count ,
742: p_data => x_msg_data ,
743: p_encoded => FND_API.G_FALSE

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

745: WHEN OTHERS THEN
746: ROLLBACK TO Delete_PayGroup;
747: x_loading_status := 'UNEXPECTED_ERR';
748: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
749: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
750: THEN
751: FND_MSG_PUB.Add_Exc_Msg( L_PKG_NAME ,l_api_name );
752: END IF;
753: FND_MSG_PUB.Count_And_Get

Line 751: FND_MSG_PUB.Add_Exc_Msg( L_PKG_NAME ,l_api_name );

747: x_loading_status := 'UNEXPECTED_ERR';
748: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
749: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
750: THEN
751: FND_MSG_PUB.Add_Exc_Msg( L_PKG_NAME ,l_api_name );
752: END IF;
753: FND_MSG_PUB.Count_And_Get
754: (
755: p_count => x_msg_count ,

Line 753: FND_MSG_PUB.Count_And_Get

749: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
750: THEN
751: FND_MSG_PUB.Add_Exc_Msg( L_PKG_NAME ,l_api_name );
752: END IF;
753: FND_MSG_PUB.Count_And_Get
754: (
755: p_count => x_msg_count ,
756: p_data => x_msg_data ,
757: p_encoded => FND_API.G_FALSE