APPS.BIM_SEGMENT_DENORM_PKG dependencies on FND_MSG_PUB

Line 105: FND_MSG_PUB.count_and_get (p_encoded => FND_API.G_FALSE,

101: EXCEPTION
102:
103: WHEN FND_API.G_EXC_ERROR THEN
104: x_return_status := FND_API.g_ret_sts_error ;
105: FND_MSG_PUB.count_and_get (p_encoded => FND_API.G_FALSE,
106: p_count => x_msg_count,
107: p_data => x_msg_data);
108: ERRBUF := x_msg_data;
109: RETCODE := 2;

Line 113: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,

109: RETCODE := 2;
110:
111: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
112: x_return_status := FND_API.g_ret_sts_unexp_error ;
113: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,
114: p_count => x_msg_count,
115: p_data => x_msg_data);
116: ERRBUF := x_msg_data;
117: RETCODE := 2;

Line 121: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,

117: RETCODE := 2;
118:
119: WHEN OTHERS THEN
120: x_return_status := FND_API.g_ret_sts_unexp_error ;
121: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,
122: p_count => x_msg_count,
123: p_data => x_msg_data);
124: ERRBUF := sqlerrm(sqlcode);
125: RETCODE := sqlcode;

Line 486: FND_MSG_PUB.Count_And_Get (

482: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
483: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
484: Execute Immediate 'DROP TABLE source_query_sgdb';
485: -- Standard call to get message count and if count=1, get the message
486: FND_MSG_PUB.Count_And_Get (
487: p_encoded => FND_API.G_FALSE,
488: p_count => x_msg_count,
489: p_data => x_msg_data
490: );

Line 495: FND_MSG_PUB.count_and_get(

491:
492: WHEN FND_API.g_exc_error THEN
493: x_return_status := FND_API.g_ret_sts_error;
494: Execute immediate 'DROP TABLE source_query_sgdb';
495: FND_MSG_PUB.count_and_get(
496: p_encoded => FND_API.g_false,
497: p_count => x_msg_count,
498: p_data => x_msg_data
499: );

Line 504: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

500:
501: WHEN OTHERS THEN
502: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
503: Execute Immediate 'DROP TABLE source_query_sgdb';
504: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
505: THEN
506: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
507: END IF;
508: -- Standard call to get message count and if count=1, get the message

Line 506: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

502: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
503: Execute Immediate 'DROP TABLE source_query_sgdb';
504: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
505: THEN
506: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
507: END IF;
508: -- Standard call to get message count and if count=1, get the message
509: FND_MSG_PUB.Count_And_Get (
510: p_encoded => FND_API.G_FALSE,

Line 509: FND_MSG_PUB.Count_And_Get (

505: THEN
506: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
507: END IF;
508: -- Standard call to get message count and if count=1, get the message
509: FND_MSG_PUB.Count_And_Get (
510: p_encoded => FND_API.G_FALSE,
511: p_count => x_msg_count,
512: p_data => x_msg_data
513: );