APPS.GL_COA_SEGMENT_VAL_PVT dependencies on FND_MSG_PUB

Line 50: FND_MSG_PUB.initialize;

46: END IF;
47:
48: --Initialize message list if p_init_msg_list is set to TRUE
49: IF FND_API.to_Boolean(p_init_msg_list) THEN
50: FND_MSG_PUB.initialize;
51: END IF;
52:
53:
54: --API body

Line 127: FND_MSG_PUB.ADD;

123:
124: --If none of the PL/SQL data has been passed then raise error
125: IF NOT l_record_exists THEN
126: FND_MESSAGE.SET_NAME ('GL','GL_COA_SVI_DATA_NOT_PASSED');
127: FND_MSG_PUB.ADD;
128: RAISE FND_API.G_EXC_ERROR;
129: END IF;
130:
131: --End of API body

Line 139: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,

135: COMMIT WORK;
136: END IF;
137:
138: --Standard call to get message count and if count is 1, get message info.
139: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
140: p_data => x_msg_data);
141:
142:
143: EXCEPTION

Line 148: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count ,

144: WHEN FND_API.G_EXC_ERROR THEN
145: FND_FILE.PUT_LINE(FND_FILE.LOG,'Exception1:');
146: ROLLBACK;
147: x_return_status := FND_API.G_RET_STS_ERROR;
148: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count ,
149: p_data => x_msg_data );
150: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
151: FND_FILE.PUT_LINE(FND_FILE.LOG,'Exception2:');
152: ROLLBACK;

Line 154: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count ,

150: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
151: FND_FILE.PUT_LINE(FND_FILE.LOG,'Exception2:');
152: ROLLBACK;
153: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
154: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count ,
155: p_data => x_msg_data );
156:
157: WHEN OTHERS THEN
158: FND_FILE.PUT_LINE(FND_FILE.LOG,'Exception3:'||SQLERRM);

Line 161: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

157: WHEN OTHERS THEN
158: FND_FILE.PUT_LINE(FND_FILE.LOG,'Exception3:'||SQLERRM);
159: ROLLBACK ;
160: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
161: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
162: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,
163: l_api_name);
164: END IF;
165: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count ,

Line 162: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,

158: FND_FILE.PUT_LINE(FND_FILE.LOG,'Exception3:'||SQLERRM);
159: ROLLBACK ;
160: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
161: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
162: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,
163: l_api_name);
164: END IF;
165: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count ,
166: p_data => x_msg_data );

Line 165: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count ,

161: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
162: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,
163: l_api_name);
164: END IF;
165: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count ,
166: p_data => x_msg_data );
167: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level) THEN
168: fnd_log.string( fnd_log.level_exception, 'gl.plsql.gl_coa_segment_val_pvt.Flex_Values_import.in_exception_section_OTHERS.err_msg',
169: SUBSTRB(SQLERRM,1,4000));