APPS.CN_SCA_CREDITS_ONLINE_PUB dependencies on FND_MSG_PUB

Line 131: FND_MSG_PUB.initialize;

127: END IF;
128:
129: -- Initialize message list if p_init_msg_list is set to TRUE.
130: IF FND_API.to_Boolean( p_init_msg_list ) THEN
131: FND_MSG_PUB.initialize;
132: END IF;
133:
134: -- Initialize API return status to success
135: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 145: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

141:
142: BEGIN
143: SELECT org_id INTO l_org_id FROM cn_repositories;
144: IF l_org_id IS NULL then
145: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
146: FND_MESSAGE.SET_NAME('CN', 'CN_INVALID_ORG');
147: FND_MSG_PUB.ADD;
148: END IF;
149: RAISE FND_API.G_EXC_ERROR;

Line 147: FND_MSG_PUB.ADD;

143: SELECT org_id INTO l_org_id FROM cn_repositories;
144: IF l_org_id IS NULL then
145: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
146: FND_MESSAGE.SET_NAME('CN', 'CN_INVALID_ORG');
147: FND_MSG_PUB.ADD;
148: END IF;
149: RAISE FND_API.G_EXC_ERROR;
150: END IF;
151: EXCEPTION

Line 153: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

149: RAISE FND_API.G_EXC_ERROR;
150: END IF;
151: EXCEPTION
152: WHEN NO_DATA_FOUND THEN
153: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
154: FND_MESSAGE.SET_NAME('CN', 'CN_INVALID_ORG');
155: FND_MSG_PUB.ADD;
156: END IF;
157: RAISE FND_API.G_EXC_ERROR;

Line 155: FND_MSG_PUB.ADD;

151: EXCEPTION
152: WHEN NO_DATA_FOUND THEN
153: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
154: FND_MESSAGE.SET_NAME('CN', 'CN_INVALID_ORG');
155: FND_MSG_PUB.ADD;
156: END IF;
157: RAISE FND_API.G_EXC_ERROR;
158: END ;
159:

Line 164: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

160:
161: OPEN get_trans_src_cr;
162: FETCH get_trans_src_cr INTO l_trx_source;
163: IF get_trans_src_cr%NOTFOUND THEN
164: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
165: FND_MESSAGE.SET_NAME ('CN','CN_SCA_NO_ROWS_TO_PROCESS');
166: FND_MSG_PUB.Add;
167: END IF;
168: CLOSE get_trans_src_cr;

Line 166: FND_MSG_PUB.Add;

162: FETCH get_trans_src_cr INTO l_trx_source;
163: IF get_trans_src_cr%NOTFOUND THEN
164: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
165: FND_MESSAGE.SET_NAME ('CN','CN_SCA_NO_ROWS_TO_PROCESS');
166: FND_MSG_PUB.Add;
167: END IF;
168: CLOSE get_trans_src_cr;
169: RAISE FND_API.G_EXC_ERROR ;
170: END IF;

Line 384: FND_MSG_PUB.Count_And_Get

380:
381: EXCEPTION
382: WHEN FND_API.G_EXC_ERROR THEN
383: x_return_status := FND_API.G_RET_STS_ERROR ;
384: FND_MSG_PUB.Count_And_Get
385: (p_count => x_msg_count ,
386: p_data => x_msg_data ,
387: p_encoded => FND_API.G_FALSE
388: );

Line 391: FND_MSG_PUB.Count_And_Get

387: p_encoded => FND_API.G_FALSE
388: );
389: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
390: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
391: FND_MSG_PUB.Count_And_Get
392: (p_count => x_msg_count ,
393: p_data => x_msg_data ,
394: p_encoded => FND_API.G_FALSE
395: );

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

394: p_encoded => FND_API.G_FALSE
395: );
396: WHEN OTHERS THEN
397: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
398: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
399: THEN
400: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
401: END IF;
402: FND_MSG_PUB.Count_And_Get

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

396: WHEN OTHERS THEN
397: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
398: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
399: THEN
400: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
401: END IF;
402: FND_MSG_PUB.Count_And_Get
403: (p_count => x_msg_count ,
404: p_data => x_msg_data ,

Line 402: FND_MSG_PUB.Count_And_Get

398: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
399: THEN
400: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
401: END IF;
402: FND_MSG_PUB.Count_And_Get
403: (p_count => x_msg_count ,
404: p_data => x_msg_data ,
405: p_encoded => FND_API.G_FALSE
406: );