DBA Data[Home] [Help]

APPS.INV_STANDALONE_SYNC_PUB dependencies on FND_MSG_PUB

Line 61: FND_MSG_PUB.initialize;

57: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
58: END IF;
59:
60: IF FND_API.to_Boolean( p_init_msg_list ) THEN
61: FND_MSG_PUB.initialize;
62: END IF;
63:
64: x_return_status := FND_API.G_RET_STS_SUCCESS;
65: print_debug('In Update_RC_Extracted');

Line 118: FND_MSG_PUB.Count_And_Get

114:
115: EXCEPTION
116: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
117: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
118: FND_MSG_PUB.Count_And_Get
119: ( p_count => x_msg_count ,
120: p_data => x_msg_data
121: );
122: IF (g_debug = 1) THEN

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

125: RETURN 'U';
126:
127: WHEN OTHERS THEN
128: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
129: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
130: THEN
131: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
132: END IF;
133: FND_MSG_PUB.Count_And_Get

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

127: WHEN OTHERS THEN
128: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
129: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
130: THEN
131: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
132: END IF;
133: FND_MSG_PUB.Count_And_Get
134: ( p_count => x_msg_count ,
135: p_data => x_msg_data

Line 133: FND_MSG_PUB.Count_And_Get

129: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
130: THEN
131: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
132: END IF;
133: FND_MSG_PUB.Count_And_Get
134: ( p_count => x_msg_count ,
135: p_data => x_msg_data
136: );
137: IF (g_debug = 1) THEN

Line 186: FND_MSG_PUB.initialize;

182: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
183: END IF;
184: -- Check p_init_msg_list
185: IF FND_API.to_Boolean( p_init_msg_list ) THEN
186: FND_MSG_PUB.initialize;
187: END IF;
188: -- Initialize API return status to success
189: x_return_status := FND_API.G_RET_STS_SUCCESS;
190:

Line 203: fnd_msg_pub.ADD;

199: WHERE organization_name = p_organization_name;
200: EXCEPTION
201: WHEN OTHERS THEN
202: fnd_message.set_name('INV', 'INV_INT_ORGCODE');
203: fnd_msg_pub.ADD;
204: RAISE FND_API.G_EXC_ERROR;
205: END;
206: END IF;
207:

Line 225: fnd_msg_pub.ADD;

221: AND concatenated_segments = p_inventory_item;
222: EXCEPTION
223: WHEN OTHERS THEN
224: fnd_message.set_name('INV', 'INV_INT_ITMCODE');
225: fnd_msg_pub.ADD;
226: RAISE FND_API.G_EXC_ERROR;
227: END;
228: END IF;
229:

Line 246: fnd_msg_pub.ADD;

242: WHERE transaction_type_name = p_transaction_type;
243: EXCEPTION
244: WHEN OTHERS THEN
245: fnd_message.set_name('INV', 'INV_INT_TRXTYPCODE');
246: fnd_msg_pub.ADD;
247: RAISE FND_API.G_EXC_ERROR;
248: END;
249: END IF;
250:

Line 290: FND_MSG_PUB.Count_And_Get

286:
287: EXCEPTION
288: WHEN FND_API.G_EXC_ERROR THEN
289: x_return_status := FND_API.G_RET_STS_ERROR ;
290: FND_MSG_PUB.Count_And_Get
291: ( p_count => x_msg_count ,
292: p_data => x_msg_data
293: );
294: RETURN 'E';

Line 298: FND_MSG_PUB.Count_And_Get

294: RETURN 'E';
295:
296: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
297: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
298: FND_MSG_PUB.Count_And_Get
299: ( p_count => x_msg_count ,
300: p_data => x_msg_data
301: );
302: RETURN 'U';

Line 368: FND_MSG_PUB.initialize;

364: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
365: END IF;
366: -- Check p_init_msg_list
367: IF FND_API.to_Boolean( p_init_msg_list ) THEN
368: FND_MSG_PUB.initialize;
369: END IF;
370: -- Initialize API return status to success
371: x_return_status := FND_API.G_RET_STS_SUCCESS;
372:

Line 501: FND_MSG_PUB.Count_And_Get

497: EXCEPTION
498: WHEN FND_API.G_EXC_ERROR THEN
499: ROLLBACK TO inv_sync_adj_txn1;
500: x_return_status := FND_API.G_RET_STS_ERROR ;
501: FND_MSG_PUB.Count_And_Get
502: ( p_count => x_msg_count ,
503: p_data => x_msg_data
504: );
505: l_txn_detail.DELETE;

Line 510: FND_MSG_PUB.Count_And_Get

506:
507: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
508: ROLLBACK TO inv_sync_adj_txn1;
509: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
510: FND_MSG_PUB.Count_And_Get
511: ( p_count => x_msg_count ,
512: p_data => x_msg_data
513: );
514: l_txn_detail.DELETE;

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

515:
516: WHEN OTHERS THEN
517: ROLLBACK TO inv_sync_adj_txn1;
518: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
519: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
520: THEN
521: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
522: END IF;
523: FND_MSG_PUB.Count_And_Get

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

517: ROLLBACK TO inv_sync_adj_txn1;
518: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
519: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
520: THEN
521: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
522: END IF;
523: FND_MSG_PUB.Count_And_Get
524: ( p_count => x_msg_count ,
525: p_data => x_msg_data

Line 523: FND_MSG_PUB.Count_And_Get

519: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
520: THEN
521: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
522: END IF;
523: FND_MSG_PUB.Count_And_Get
524: ( p_count => x_msg_count ,
525: p_data => x_msg_data
526: );
527: l_txn_detail.DELETE;