DBA Data[Home] [Help]

APPS.DPP_NOTIFICATION_PVT dependencies on DPP_UTILITY_PVT

Line 84: DPP_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');

80: END IF;
81:
82: -- Debug Message
83: IF g_debug THEN
84: DPP_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
85: END IF;
86: -- Initialize API return status to sucess
87: l_return_status := FND_API.G_RET_STS_SUCCESS;
88:

Line 123: DPP_UTILITY_PVT.debug_message('Price Protection responsibility not available for User');

119: AND u.RESPONSIBILITY_APPLICATION_ID = 9000 -- for dpp
120: AND ROWNUM = 1;
121: EXCEPTION
122: WHEN NO_DATA_FOUND THEN
123: DPP_UTILITY_PVT.debug_message('Price Protection responsibility not available for User');
124: RAISE FND_API.G_EXC_ERROR;
125: END;
126:
127: FND_GLOBAL.APPS_INITIALIZE(p_user_id,l_responsibility_id,l_application_id);

Line 132: DPP_UTILITY_PVT.debug_message('Output Type: ' || l_output_type);

128:
129: l_output_type := fnd_profile.VALUE('DPP_NOTIFICATION_REPORT_TYPE');
130:
131: IF g_debug THEN
132: DPP_UTILITY_PVT.debug_message('Output Type: ' || l_output_type);
133: END IF;
134:
135:
136: INSERT INTO DPP_NOTIFICATION_BLOBS

Line 201: DPP_UTILITY_PVT.debug_message('Error in Conc Request Submission');

197: x_request_id := l_req_id;
198:
199: IF l_req_id = 0 THEN
200:
201: DPP_UTILITY_PVT.debug_message('Error in Conc Request Submission');
202: RAISE FND_API.G_EXC_ERROR;
203:
204: END IF;
205:

Line 217: DPP_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');

213: END IF;
214:
215: -- Debug Message
216: IF g_debug THEN
217: DPP_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
218: END IF;
219: -- Standard call to get message count and if count is 1, get message info.
220: FND_MSG_PUB.Count_And_Get
221: (p_count => x_msg_count,

Line 263: DPP_UTILITY_PVT.debug_message(substr(('Error in DPP_NOTIFICATION_PVT.Create_FormattedOutput: '||SQLERRM),1,4000));

259: fnd_message.set_token('ROUTINE', 'DPP_NOTIFICATION_PVT.Create_FormattedOutput');
260: fnd_message.set_token('ERRNO', sqlcode);
261: fnd_message.set_token('REASON', sqlerrm);
262: FND_MSG_PUB.ADD;
263: DPP_UTILITY_PVT.debug_message(substr(('Error in DPP_NOTIFICATION_PVT.Create_FormattedOutput: '||SQLERRM),1,4000));
264:
265: -- Standard call to get message count and if count=1, get the message
266: FND_MSG_PUB.Count_And_Get (
267: p_encoded => FND_API.G_FALSE,

Line 318: DPP_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');

314: BEGIN
315:
316: -- Debug Message
317: IF g_debug THEN
318: DPP_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
319: END IF;
320: -- Initialize API return status to sucess
321: l_return_status := FND_API.G_RET_STS_SUCCESS;
322:

Line 391: DPP_UTILITY_PVT.debug_message('Message: ' || p_message_name || ' cannot be found');

387: x_message_text :=FND_MESSAGE.get;
388: END IF;
389:
390: IF x_message_text IS NULL THEN
391: DPP_UTILITY_PVT.debug_message('Message: ' || p_message_name || ' cannot be found');
392: END IF;
393:
394: x_return_status := l_return_status;
395:

Line 398: DPP_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');

394: x_return_status := l_return_status;
395:
396: -- Debug Message
397: IF g_debug THEN
398: DPP_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
399: END IF;
400: --Exception Handling
401: EXCEPTION
402: WHEN FND_API.G_EXC_ERROR THEN

Line 437: DPP_UTILITY_PVT.debug_message(substr(('Error in DPP_NOTIFICATION_PVT.Select_Message_Text: '||SQLERRM),1,2000));

433: fnd_message.set_token('ROUTINE', 'DPP_NOTIFICATION_PVT.Select_Message_Text');
434: fnd_message.set_token('ERRNO', sqlcode);
435: fnd_message.set_token('REASON', sqlerrm);
436: FND_MSG_PUB.ADD;
437: DPP_UTILITY_PVT.debug_message(substr(('Error in DPP_NOTIFICATION_PVT.Select_Message_Text: '||SQLERRM),1,2000));
438:
439: -- Standard call to get message count and if count=1, get the message
440: FND_MSG_PUB.Count_And_Get (
441: p_encoded => FND_API.G_FALSE,

Line 488: DPP_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');

484: BEGIN
485:
486: -- Debug Message
487: IF g_debug THEN
488: DPP_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
489: END IF;
490: -- Initialize API return status to sucess
491: l_return_status := FND_API.G_RET_STS_SUCCESS;
492:

Line 513: DPP_UTILITY_PVT.debug_message('Formatted Output was not created by Request');

509: FND_MESSAGE.set_token('REQID', p_execution_detail_id); -- change token name later
510: FND_MSG_PUB.add;
511: -- Debug Message
512: IF g_debug THEN
513: DPP_UTILITY_PVT.debug_message('Formatted Output was not created by Request');
514: END IF;
515: RAISE FND_API.G_EXC_ERROR;
516: END IF;
517:

Line 522: DPP_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');

518: x_return_status := l_return_status;
519:
520: -- Debug Message
521: IF g_debug THEN
522: DPP_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
523: END IF;
524: --Exception Handling
525: EXCEPTION
526: WHEN FND_API.G_EXC_ERROR THEN

Line 561: DPP_UTILITY_PVT.debug_message(substr(('Error in DPP_NOTIFICATION_PVT.Get_FormattedOutput: '||SQLERRM),1,2000));

557: fnd_message.set_token('ROUTINE', 'DPP_NOTIFICATION_PVT.Get_FormattedOutput');
558: fnd_message.set_token('ERRNO', sqlcode);
559: fnd_message.set_token('REASON', sqlerrm);
560: FND_MSG_PUB.ADD;
561: DPP_UTILITY_PVT.debug_message(substr(('Error in DPP_NOTIFICATION_PVT.Get_FormattedOutput: '||SQLERRM),1,2000));
562: -- Standard call to get message count and if count=1, get the message
563: FND_MSG_PUB.Count_And_Get (
564: p_encoded => FND_API.G_FALSE,
565: p_count => x_msg_count,