APPS.IEM_ARCH_REQUESTS_PVT dependencies on FND_MSG_PUB

Line 71: FND_MSG_PUB.Count_And_Get

67: IF p_commit='T' THEN
68: COMMIT WORK;
69: END IF;
70: -- Standard callto get message count and if count is 1, get message info.
71: FND_MSG_PUB.Count_And_Get
72: ( p_count => x_msg_count,
73: p_data => x_msg_data
74: );
75: EXCEPTION

Line 78: FND_MSG_PUB.Count_And_Get

74: );
75: EXCEPTION
76: WHEN FND_API.G_EXC_ERROR THEN
77: x_return_status := FND_API.G_RET_STS_ERROR ;
78: FND_MSG_PUB.Count_And_Get
79: ( p_count => x_msg_count,
80: p_data => x_msg_data
81: );
82: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 84: FND_MSG_PUB.Count_And_Get

80: p_data => x_msg_data
81: );
82: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
83: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
84: FND_MSG_PUB.Count_And_Get
85: ( p_count => x_msg_count,
86: p_data => x_msg_data
87: );
88: WHEN OTHERS THEN

Line 90: IF FND_MSG_PUB.Check_Msg_Level

86: p_data => x_msg_data
87: );
88: WHEN OTHERS THEN
89: x_return_status := FND_API.G_RET_STS_ERROR;
90: IF FND_MSG_PUB.Check_Msg_Level
91: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
92: THEN
93: FND_MSG_PUB.Add_Exc_Msg
94: ( G_PKG_NAME ,

Line 91: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

87: );
88: WHEN OTHERS THEN
89: x_return_status := FND_API.G_RET_STS_ERROR;
90: IF FND_MSG_PUB.Check_Msg_Level
91: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
92: THEN
93: FND_MSG_PUB.Add_Exc_Msg
94: ( G_PKG_NAME ,
95: l_api_name

Line 93: FND_MSG_PUB.Add_Exc_Msg

89: x_return_status := FND_API.G_RET_STS_ERROR;
90: IF FND_MSG_PUB.Check_Msg_Level
91: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
92: THEN
93: FND_MSG_PUB.Add_Exc_Msg
94: ( G_PKG_NAME ,
95: l_api_name
96: );
97: END IF;

Line 98: FND_MSG_PUB.Count_And_Get

94: ( G_PKG_NAME ,
95: l_api_name
96: );
97: END IF;
98: FND_MSG_PUB.Count_And_Get
99: ( p_count => x_msg_count ,
100: p_data => x_msg_data
101: );
102:

Line 143: FND_MSG_PUB.Count_And_Get

139: IF p_commit='T' THEN
140: COMMIT WORK;
141: END IF;
142: -- Standard callto get message count and if count is 1, get message info.
143: FND_MSG_PUB.Count_And_Get
144: ( p_count => x_msg_count,
145: p_data => x_msg_data
146: );
147: EXCEPTION

Line 150: FND_MSG_PUB.Count_And_Get

146: );
147: EXCEPTION
148: WHEN FND_API.G_EXC_ERROR THEN
149: x_return_status := FND_API.G_RET_STS_ERROR ;
150: FND_MSG_PUB.Count_And_Get
151: ( p_count => x_msg_count,
152: p_data => x_msg_data
153: );
154: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 156: FND_MSG_PUB.Count_And_Get

152: p_data => x_msg_data
153: );
154: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
155: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
156: FND_MSG_PUB.Count_And_Get
157: ( p_count => x_msg_count,
158: p_data => x_msg_data
159: );
160: WHEN OTHERS THEN

Line 162: IF FND_MSG_PUB.Check_Msg_Level

158: p_data => x_msg_data
159: );
160: WHEN OTHERS THEN
161: x_return_status := FND_API.G_RET_STS_ERROR;
162: IF FND_MSG_PUB.Check_Msg_Level
163: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
164: THEN
165: FND_MSG_PUB.Add_Exc_Msg
166: ( G_PKG_NAME ,

Line 163: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

159: );
160: WHEN OTHERS THEN
161: x_return_status := FND_API.G_RET_STS_ERROR;
162: IF FND_MSG_PUB.Check_Msg_Level
163: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
164: THEN
165: FND_MSG_PUB.Add_Exc_Msg
166: ( G_PKG_NAME ,
167: l_api_name

Line 165: FND_MSG_PUB.Add_Exc_Msg

161: x_return_status := FND_API.G_RET_STS_ERROR;
162: IF FND_MSG_PUB.Check_Msg_Level
163: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
164: THEN
165: FND_MSG_PUB.Add_Exc_Msg
166: ( G_PKG_NAME ,
167: l_api_name
168: );
169: END IF;

Line 170: FND_MSG_PUB.Count_And_Get

166: ( G_PKG_NAME ,
167: l_api_name
168: );
169: END IF;
170: FND_MSG_PUB.Count_And_Get
171: ( p_count => x_msg_count ,
172: p_data => x_msg_data
173: );
174: