DBA Data[Home] [Help]

APPS.DPP_ERROR_PVT dependencies on FND_MSG_PUB

Line 11: G_DEBUG BOOLEAN := FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_high);

7: -- NOTE :
8: -- End of Comments
9:
10: G_PKG_NAME CONSTANT VARCHAR2(30) := 'DPP_ERROR_PVT';
11: G_DEBUG BOOLEAN := FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_high);
12: G_FILE_NAME CONSTANT VARCHAR2(14) := 'dpperrb.pls';
13:
14: ---------------------------------------------------------------------
15: -- PROCEDURE

Line 72: FND_MSG_PUB.initialize;

68: END IF;
69: -- Initialize message list if p_init_msg_list is set to TRUE.
70: IF FND_API.to_Boolean( p_init_msg_list )
71: THEN
72: FND_MSG_PUB.initialize;
73: END IF;
74:
75: -- Debug Message
76: IF g_debug THEN

Line 132: FND_MSG_PUB.Count_And_Get

128: IF g_debug THEN
129: DPP_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
130: END IF;
131: -- Standard call to get message count and if count is 1, get message info.
132: FND_MSG_PUB.Count_And_Get
133: (p_count => x_msg_count,
134: p_data => x_msg_data
135: );
136:

Line 139: x_msg_data := SUBSTR((x_msg_data||' '|| FND_MSG_PUB.GET(P_MSG_INDEX => I, P_ENCODED => 'F')), 1, 4000);

135: );
136:
137: IF x_msg_count > 1 THEN
138: FOR I IN 1..x_msg_count LOOP
139: x_msg_data := SUBSTR((x_msg_data||' '|| FND_MSG_PUB.GET(P_MSG_INDEX => I, P_ENCODED => 'F')), 1, 4000);
140: END LOOP;
141: END IF;
142:
143: --Exception Handling

Line 150: FND_MSG_PUB.Count_And_Get (

146: WHEN FND_API.G_EXC_ERROR THEN
147: ROLLBACK TO Update_Error_PVT;
148: x_return_status := FND_API.G_RET_STS_ERROR;
149: -- Standard call to get message count and if count=1, get the message
150: FND_MSG_PUB.Count_And_Get (
151: p_encoded => FND_API.G_FALSE,
152: p_count => x_msg_count,
153: p_data => x_msg_data
154: );

Line 157: x_msg_data := SUBSTR((x_msg_data||' '|| FND_MSG_PUB.GET(P_MSG_INDEX => I, P_ENCODED => 'F')), 1, 4000);

153: p_data => x_msg_data
154: );
155: IF x_msg_count > 1 THEN
156: FOR I IN 1..x_msg_count LOOP
157: x_msg_data := SUBSTR((x_msg_data||' '|| FND_MSG_PUB.GET(P_MSG_INDEX => I, P_ENCODED => 'F')), 1, 4000);
158: END LOOP;
159: END IF;
160:
161: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 165: FND_MSG_PUB.Count_And_Get (

161: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
162: ROLLBACK TO Update_Error_PVT;
163: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
164: -- Standard call to get message count and if count=1, get the message
165: FND_MSG_PUB.Count_And_Get (
166: p_encoded => FND_API.G_FALSE,
167: p_count => x_msg_count,
168: p_data => x_msg_data
169: );

Line 172: x_msg_data := SUBSTR((x_msg_data||' '|| FND_MSG_PUB.GET(P_MSG_INDEX => I, P_ENCODED => 'F')), 1, 4000);

168: p_data => x_msg_data
169: );
170: IF x_msg_count > 1 THEN
171: FOR I IN 1..x_msg_count LOOP
172: x_msg_data := SUBSTR((x_msg_data||' '|| FND_MSG_PUB.GET(P_MSG_INDEX => I, P_ENCODED => 'F')), 1, 4000);
173: END LOOP;
174: END IF;
175:
176: WHEN OTHERS THEN

Line 182: FND_MSG_PUB.add;

178: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
179: fnd_message.set_token('ROUTINE', 'DPP_ERROR_PVT.Update_Error');
180: fnd_message.set_token('ERRNO', sqlcode);
181: fnd_message.set_token('REASON', sqlerrm);
182: FND_MSG_PUB.add;
183: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
184:
185: -- Standard call to get message count and if count=1, get the message
186: FND_MSG_PUB.Count_And_Get (

Line 186: FND_MSG_PUB.Count_And_Get (

182: FND_MSG_PUB.add;
183: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
184:
185: -- Standard call to get message count and if count=1, get the message
186: FND_MSG_PUB.Count_And_Get (
187: p_encoded => FND_API.G_FALSE,
188: p_count => x_msg_count,
189: p_data => x_msg_data
190: );

Line 193: x_msg_data := SUBSTR((x_msg_data||' '|| FND_MSG_PUB.GET(P_MSG_INDEX => I, P_ENCODED => 'F')), 1, 4000);

189: p_data => x_msg_data
190: );
191: IF x_msg_count > 1 THEN
192: FOR I IN 1..x_msg_count LOOP
193: x_msg_data := SUBSTR((x_msg_data||' '|| FND_MSG_PUB.GET(P_MSG_INDEX => I, P_ENCODED => 'F')), 1, 4000);
194: END LOOP;
195: END IF;
196:
197: