DBA Data[Home] [Help]

APPS.DPP_LOG_PVT dependencies on FND_MSG_PUB

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

6: -- NOTE :
7: -- End of Comments
8:
9: G_PKG_NAME CONSTANT VARCHAR2(30) := 'DPP_LOG_PVT';
10: G_DEBUG BOOLEAN := FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_high);
11:
12: ---------------------------------------------------------------------
13: -- PROCEDURE
14: -- Insert_HeaderLog

Line 60: FND_MSG_PUB.initialize;

56: END IF;
57: -- Initialize message list if p_init_msg_list is set to TRUE.
58: IF FND_API.to_Boolean( p_init_msg_list )
59: THEN
60: FND_MSG_PUB.initialize;
61: END IF;
62:
63:
64: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_PROCEDURE, 'dpp.plsql.' || L_FULL_NAME, 'Private API: ' || l_api_name || 'start');

Line 125: FND_MSG_PUB.Count_And_Get

121:
122: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, 'Private API: ' || l_api_name || 'end');
123:
124: -- Standard call to get message count and if count is 1, get message info.
125: FND_MSG_PUB.Count_And_Get
126: (p_count => x_msg_count,
127: p_data => x_msg_data
128: );
129:

Line 136: FND_MSG_PUB.Count_And_Get (

132: WHEN FND_API.G_EXC_ERROR THEN
133: ROLLBACK TO INSERT_HEADERLOG_PVT;
134: x_return_status := FND_API.G_RET_STS_ERROR;
135: -- Standard call to get message count and if count=1, get the message
136: FND_MSG_PUB.Count_And_Get (
137: p_encoded => FND_API.G_FALSE,
138: p_count => x_msg_count,
139: p_data => x_msg_data
140: );

Line 145: FND_MSG_PUB.Count_And_Get (

141: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
142: ROLLBACK TO INSERT_HEADERLOG_PVT;
143: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
144: -- Standard call to get message count and if count=1, get the message
145: FND_MSG_PUB.Count_And_Get (
146: p_encoded => FND_API.G_FALSE,
147: p_count => x_msg_count,
148: p_data => x_msg_data
149: );

Line 157: FND_MSG_PUB.ADD;

153: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
154: fnd_message.set_token('ROUTINE', 'DPP_LOG_PVT.Insert_HeaderLog');
155: fnd_message.set_token('ERRNO', sqlcode);
156: fnd_message.set_token('REASON', sqlerrm);
157: FND_MSG_PUB.ADD;
158: -- Standard call to get message count and if count=1, get the message
159: FND_MSG_PUB.Count_And_Get (
160: p_encoded => FND_API.G_FALSE,
161: p_count => x_msg_count,

Line 159: FND_MSG_PUB.Count_And_Get (

155: fnd_message.set_token('ERRNO', sqlcode);
156: fnd_message.set_token('REASON', sqlerrm);
157: FND_MSG_PUB.ADD;
158: -- Standard call to get message count and if count=1, get the message
159: FND_MSG_PUB.Count_And_Get (
160: p_encoded => FND_API.G_FALSE,
161: p_count => x_msg_count,
162: p_data => x_msg_data
163: );

Line 200: FND_MSG_PUB.initialize;

196: END IF;
197: -- Initialize message list if p_init_msg_list is set to TRUE.
198: IF FND_API.to_Boolean( p_init_msg_list )
199: THEN
200: FND_MSG_PUB.initialize;
201: END IF;
202:
203:
204: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_PROCEDURE, 'dpp.plsql.' || L_FULL_NAME, 'Private API: ' || l_api_name || 'start');

Line 281: FND_MSG_PUB.Count_And_Get

277:
278: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, 'Private API: ' || l_api_name || 'end');
279:
280: -- Standard call to get message count and if count is 1, get message info.
281: FND_MSG_PUB.Count_And_Get
282: (p_count => x_msg_count,
283: p_data => x_msg_data
284: );
285:

Line 296: FND_MSG_PUB.ADD;

292: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
293: fnd_message.set_token('ROUTINE', 'DPP_LOG_PVT.Insert_LinesLog');
294: fnd_message.set_token('ERRNO', sqlcode);
295: fnd_message.set_token('REASON', sqlerrm);
296: FND_MSG_PUB.ADD;
297: -- Standard call to get message count and if count=1, get the message
298: FND_MSG_PUB.Count_And_Get (
299: p_encoded => FND_API.G_FALSE,
300: p_count => x_msg_count,

Line 298: FND_MSG_PUB.Count_And_Get (

294: fnd_message.set_token('ERRNO', sqlcode);
295: fnd_message.set_token('REASON', sqlerrm);
296: FND_MSG_PUB.ADD;
297: -- Standard call to get message count and if count=1, get the message
298: FND_MSG_PUB.Count_And_Get (
299: p_encoded => FND_API.G_FALSE,
300: p_count => x_msg_count,
301: p_data => x_msg_data
302: );

Line 338: FND_MSG_PUB.initialize;

334: END IF;
335: -- Initialize message list if p_init_msg_list is set to TRUE.
336: IF FND_API.to_Boolean( p_init_msg_list )
337: THEN
338: FND_MSG_PUB.initialize;
339: END IF;
340:
341:
342: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_PROCEDURE, 'dpp.plsql.' || L_FULL_NAME, 'Private API: ' || l_api_name || 'start');

Line 413: FND_MSG_PUB.Count_And_Get

409:
410: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, 'Private API: ' || l_api_name || 'end');
411:
412: -- Standard call to get message count and if count is 1, get message info.
413: FND_MSG_PUB.Count_And_Get
414: (p_count => x_msg_count,
415: p_data => x_msg_data
416: );
417:

Line 428: FND_MSG_PUB.ADD;

424: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
425: fnd_message.set_token('ROUTINE', 'DPP_LOG_PVT.Insert_ClaimsLog');
426: fnd_message.set_token('ERRNO', sqlcode);
427: fnd_message.set_token('REASON', sqlerrm);
428: FND_MSG_PUB.ADD;
429: -- Standard call to get message count and if count=1, get the message
430: FND_MSG_PUB.Count_And_Get (
431: p_encoded => FND_API.G_FALSE,
432: p_count => x_msg_count,

Line 430: FND_MSG_PUB.Count_And_Get (

426: fnd_message.set_token('ERRNO', sqlcode);
427: fnd_message.set_token('REASON', sqlerrm);
428: FND_MSG_PUB.ADD;
429: -- Standard call to get message count and if count=1, get the message
430: FND_MSG_PUB.Count_And_Get (
431: p_encoded => FND_API.G_FALSE,
432: p_count => x_msg_count,
433: p_data => x_msg_data
434: );