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');
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
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
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
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
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:
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:
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:
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:
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';
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';
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:
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;
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;
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
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
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;