DBA Data[Home] [Help]

APPS.DPP_NOTIFICATION_PVT dependencies on FND_LOG

Line 84: DPP_UTILITY_PVT.debug_message(FND_LOG.LEVEL_PROCEDURE, l_module, 'Private API: ' || l_api_name || 'start');

80: FND_MSG_PUB.initialize;
81: END IF;
82:
83: -- Debug Message
84: DPP_UTILITY_PVT.debug_message(FND_LOG.LEVEL_PROCEDURE, l_module, 'Private API: ' || l_api_name || 'start');
85:
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(FND_LOG.LEVEL_EXCEPTION, l_module, '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(FND_LOG.LEVEL_EXCEPTION, l_module, '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 131: DPP_UTILITY_PVT.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Output Type: ' || l_output_type);

127: FND_GLOBAL.APPS_INITIALIZE(p_user_id,l_responsibility_id,l_application_id);
128:
129: l_output_type := fnd_profile.VALUE('DPP_NOTIFICATION_REPORT_TYPE');
130:
131: DPP_UTILITY_PVT.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Output Type: ' || l_output_type);
132:
133:
134: INSERT INTO DPP_NOTIFICATION_BLOBS
135: (

Line 199: DPP_UTILITY_PVT.debug_message(FND_LOG.LEVEL_EXCEPTION, l_module, 'Error in Conc Request Submission');

195: x_request_id := l_req_id;
196:
197: IF l_req_id = 0 THEN
198:
199: DPP_UTILITY_PVT.debug_message(FND_LOG.LEVEL_EXCEPTION, l_module, 'Error in Conc Request Submission');
200: RAISE FND_API.G_EXC_ERROR;
201:
202: END IF;
203:

Line 214: DPP_UTILITY_PVT.debug_message(FND_LOG.LEVEL_PROCEDURE, l_module, 'Private API: ' || l_api_name || 'end');

210: COMMIT WORK;
211: END IF;
212:
213: -- Debug Message
214: DPP_UTILITY_PVT.debug_message(FND_LOG.LEVEL_PROCEDURE, l_module, 'Private API: ' || l_api_name || 'end');
215:
216: -- Standard call to get message count and if count is 1, get message info.
217: FND_MSG_PUB.Count_And_Get
218: (p_count => x_msg_count,

Line 260: DPP_UTILITY_PVT.debug_message(FND_LOG.LEVEL_EXCEPTION, l_module, substr(('Error in DPP_NOTIFICATION_PVT.Create_FormattedOutput: '||SQLERRM),1,4000));

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

Line 315: DPP_UTILITY_PVT.debug_message(FND_LOG.LEVEL_PROCEDURE, l_module, 'Private API: ' || l_api_name || 'start');

311:
312: BEGIN
313:
314: -- Debug Message
315: DPP_UTILITY_PVT.debug_message(FND_LOG.LEVEL_PROCEDURE, l_module, 'Private API: ' || l_api_name || 'start');
316:
317: -- Initialize API return status to sucess
318: l_return_status := FND_API.G_RET_STS_SUCCESS;
319:

Line 388: DPP_UTILITY_PVT.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Message: ' || p_message_name || ' cannot be found');

384: x_message_text :=FND_MESSAGE.get;
385: END IF;
386:
387: IF x_message_text IS NULL THEN
388: DPP_UTILITY_PVT.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Message: ' || p_message_name || ' cannot be found');
389: END IF;
390:
391: x_return_status := l_return_status;
392:

Line 394: DPP_UTILITY_PVT.debug_message(FND_LOG.LEVEL_PROCEDURE, l_module, 'Private API: ' || l_api_name || 'end');

390:
391: x_return_status := l_return_status;
392:
393: -- Debug Message
394: DPP_UTILITY_PVT.debug_message(FND_LOG.LEVEL_PROCEDURE, l_module, 'Private API: ' || l_api_name || 'end');
395:
396: --Exception Handling
397: EXCEPTION
398: WHEN FND_API.G_EXC_ERROR THEN

Line 433: DPP_UTILITY_PVT.debug_message(FND_LOG.LEVEL_EXCEPTION, l_module, substr(('Error in DPP_NOTIFICATION_PVT.Select_Message_Text: '||SQLERRM),1,2000));

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

Line 484: DPP_UTILITY_PVT.debug_message(FND_LOG.LEVEL_PROCEDURE, l_module, 'Private API: ' || l_api_name || 'start');

480: l_return_status VARCHAR2(1);
481: BEGIN
482:
483: -- Debug Message
484: DPP_UTILITY_PVT.debug_message(FND_LOG.LEVEL_PROCEDURE, l_module, 'Private API: ' || l_api_name || 'start');
485:
486: -- Initialize API return status to sucess
487: l_return_status := FND_API.G_RET_STS_SUCCESS;
488:

Line 508: DPP_UTILITY_PVT.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Formatted Output was not created by Request');

504: FND_MESSAGE.set_name('DPP', 'DPP_OUTPUT_NOT_CREATED');
505: FND_MESSAGE.set_token('REQID', p_execution_detail_id); -- change token name later
506: FND_MSG_PUB.add;
507: -- Debug Message
508: DPP_UTILITY_PVT.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Formatted Output was not created by Request');
509:
510: RAISE FND_API.G_EXC_ERROR;
511: END IF;
512:

Line 516: DPP_UTILITY_PVT.debug_message(FND_LOG.LEVEL_PROCEDURE, l_module, 'Private API: ' || l_api_name || 'end');

512:
513: x_return_status := l_return_status;
514:
515: -- Debug Message
516: DPP_UTILITY_PVT.debug_message(FND_LOG.LEVEL_PROCEDURE, l_module, 'Private API: ' || l_api_name || 'end');
517:
518: --Exception Handling
519: EXCEPTION
520: WHEN FND_API.G_EXC_ERROR THEN

Line 555: DPP_UTILITY_PVT.debug_message(FND_LOG.LEVEL_EXCEPTION, l_module, substr(('Error in DPP_NOTIFICATION_PVT.Get_FormattedOutput: '||SQLERRM),1,2000));

551: fnd_message.set_token('ROUTINE', 'DPP_NOTIFICATION_PVT.Get_FormattedOutput');
552: fnd_message.set_token('ERRNO', sqlcode);
553: fnd_message.set_token('REASON', sqlerrm);
554: FND_MSG_PUB.ADD;
555: DPP_UTILITY_PVT.debug_message(FND_LOG.LEVEL_EXCEPTION, l_module, substr(('Error in DPP_NOTIFICATION_PVT.Get_FormattedOutput: '||SQLERRM),1,2000));
556: -- Standard call to get message count and if count=1, get the message
557: FND_MSG_PUB.Count_And_Get (
558: p_encoded => FND_API.G_FALSE,
559: p_count => x_msg_count,