eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.INV_STANDALONE_SYNC_PUB dependencies on FND_API

Line 24: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

20: END;
21:
22: FUNCTION Update_RC_Extracted(
23: p_api_version IN NUMBER
24: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
25: , p_commit IN VARCHAR2 := FND_API.G_FALSE
26: , x_return_status OUT NOCOPY VARCHAR2
27: , x_msg_count OUT NOCOPY NUMBER
28: , x_msg_data OUT NOCOPY VARCHAR2

Line 25: , p_commit IN VARCHAR2 := FND_API.G_FALSE

21:
22: FUNCTION Update_RC_Extracted(
23: p_api_version IN NUMBER
24: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
25: , p_commit IN VARCHAR2 := FND_API.G_FALSE
26: , x_return_status OUT NOCOPY VARCHAR2
27: , x_msg_count OUT NOCOPY NUMBER
28: , x_msg_data OUT NOCOPY VARCHAR2
29: , p_start_date IN VARCHAR2

Line 54: IF NOT FND_API.Compatible_API_Call ( l_api_version, p_api_version ,

50: l_rc_extracted VARCHAR2(1);
51: l_transaction_id NUMBER;
52:
53: BEGIN
54: IF NOT FND_API.Compatible_API_Call ( l_api_version, p_api_version ,
55: l_api_name , G_PKG_NAME )
56: THEN
57: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
58: END IF;

Line 57: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

53: BEGIN
54: IF NOT FND_API.Compatible_API_Call ( l_api_version, p_api_version ,
55: l_api_name , G_PKG_NAME )
56: THEN
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;

Line 60: IF FND_API.to_Boolean( p_init_msg_list ) THEN

56: THEN
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;

Line 64: x_return_status := FND_API.G_RET_STS_SUCCESS;

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');
66:
67: IF (g_debug = 1) THEN
68: print_debug('In Update_RC_Extracted');

Line 109: IF FND_API.To_Boolean( p_commit ) THEN

105: IF (g_debug = 1) THEN
106: print_debug('Updated ' || SQL%ROWCOUNT || ' rows.');
107: END IF;
108:
109: IF FND_API.To_Boolean( p_commit ) THEN
110: COMMIT WORK;
111: END IF;
112:
113: RETURN 'S';

Line 116: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

112:
113: RETURN 'S';
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

Line 117: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

Line 128: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

124: END IF;
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;

Line 147: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

143:
144:
145: FUNCTION sync_adjustment_transactions(
146: p_api_version IN NUMBER
147: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
148: , p_commit IN VARCHAR2 := FND_API.G_FALSE
149: , x_return_status OUT NOCOPY VARCHAR2
150: , x_msg_count OUT NOCOPY NUMBER
151: , x_msg_data OUT NOCOPY VARCHAR2

Line 148: , p_commit IN VARCHAR2 := FND_API.G_FALSE

144:
145: FUNCTION sync_adjustment_transactions(
146: p_api_version IN NUMBER
147: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
148: , p_commit IN VARCHAR2 := FND_API.G_FALSE
149: , x_return_status OUT NOCOPY VARCHAR2
150: , x_msg_count OUT NOCOPY NUMBER
151: , x_msg_data OUT NOCOPY VARCHAR2
152: , p_from_date IN DATE

Line 179: IF NOT FND_API.Compatible_API_Call ( l_api_version, p_api_version ,

175: ||p_inventory_item||','||p_transaction_type||','||p_transaction_source||','||p_transaction_id||','||p_extract_flag);
176: END IF;
177:
178: -- Standard call to check for call compatibility.
179: IF NOT FND_API.Compatible_API_Call ( l_api_version, p_api_version ,
180: l_api_name , G_PKG_NAME )
181: THEN
182: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
183: END IF;

Line 182: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

178: -- Standard call to check for call compatibility.
179: IF NOT FND_API.Compatible_API_Call ( l_api_version, p_api_version ,
180: l_api_name , G_PKG_NAME )
181: 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;

Line 185: IF FND_API.to_Boolean( p_init_msg_list ) THEN

181: 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;

Line 189: x_return_status := FND_API.G_RET_STS_SUCCESS;

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:
191: -- Handle Organization Name / Organization Id
192: IF p_organization_name IS NULL THEN
193: RAISE FND_API.G_EXC_ERROR;

Line 193: RAISE FND_API.G_EXC_ERROR;

189: x_return_status := FND_API.G_RET_STS_SUCCESS;
190:
191: -- Handle Organization Name / Organization Id
192: IF p_organization_name IS NULL THEN
193: RAISE FND_API.G_EXC_ERROR;
194: ELSE
195: BEGIN
196: SELECT organization_id
197: INTO l_organization_id

Line 204: RAISE FND_API.G_EXC_ERROR;

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:
208: IF (g_debug = 1) THEN

Line 226: RAISE FND_API.G_EXC_ERROR;

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:
230: IF (g_debug = 1) THEN

Line 247: RAISE FND_API.G_EXC_ERROR;

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:
251: IF (g_debug = 1) THEN

Line 273: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

269: , p_transaction_id => p_transaction_id
270: , p_extract_flag => p_extract_flag
271: );
272:
273: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
274: IF (g_debug = 1) THEN
275: print_debug('return status : '|| x_return_status || ' msg_count : ' || x_msg_count);
276: print_debug('error : '|| x_msg_data);
277: END IF;

Line 278: RAISE FND_API.G_EXC_ERROR;

274: IF (g_debug = 1) THEN
275: print_debug('return status : '|| x_return_status || ' msg_count : ' || x_msg_count);
276: print_debug('error : '|| x_msg_data);
277: END IF;
278: RAISE FND_API.G_EXC_ERROR;
279: END IF;
280:
281: IF FND_API.To_Boolean( p_commit ) THEN
282: COMMIT WORK;

Line 281: IF FND_API.To_Boolean( p_commit ) THEN

277: END IF;
278: RAISE FND_API.G_EXC_ERROR;
279: END IF;
280:
281: IF FND_API.To_Boolean( p_commit ) THEN
282: COMMIT WORK;
283: END IF;
284:
285: RETURN x_return_status;

Line 288: WHEN FND_API.G_EXC_ERROR THEN

284:
285: RETURN x_return_status;
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

Line 289: x_return_status := FND_API.G_RET_STS_ERROR ;

285: RETURN x_return_status;
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: );

Line 296: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

292: p_data => x_msg_data
293: );
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

Line 297: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

Line 311: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

307: END sync_adjustment_transactions;
308:
309: PROCEDURE sync_adjustment_transactions2(
310: p_api_version IN NUMBER
311: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
312: , p_commit IN VARCHAR2 := FND_API.G_FALSE
313: , x_return_status OUT NOCOPY VARCHAR2
314: , x_msg_count OUT NOCOPY NUMBER
315: , x_msg_data OUT NOCOPY VARCHAR2

Line 312: , p_commit IN VARCHAR2 := FND_API.G_FALSE

308:
309: PROCEDURE sync_adjustment_transactions2(
310: p_api_version IN NUMBER
311: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
312: , p_commit IN VARCHAR2 := FND_API.G_FALSE
313: , x_return_status OUT NOCOPY VARCHAR2
314: , x_msg_count OUT NOCOPY NUMBER
315: , x_msg_data OUT NOCOPY VARCHAR2
316: , p_from_date IN DATE

Line 361: IF NOT FND_API.Compatible_API_Call ( l_api_version, p_api_version ,

357:
358: -- Standard begin of API savepoint
359: SAVEPOINT inv_sync_adj_txn1;
360: -- Standard call to check for call compatibility.
361: IF NOT FND_API.Compatible_API_Call ( l_api_version, p_api_version ,
362: l_api_name , G_PKG_NAME )
363: THEN
364: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
365: END IF;

Line 364: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

360: -- Standard call to check for call compatibility.
361: IF NOT FND_API.Compatible_API_Call ( l_api_version, p_api_version ,
362: l_api_name , G_PKG_NAME )
363: THEN
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;

Line 367: IF FND_API.to_Boolean( p_init_msg_list ) THEN

363: THEN
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;

Line 371: x_return_status := FND_API.G_RET_STS_SUCCESS;

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:
373: l_from_date := p_from_date;
374: l_to_date := p_to_date;
375: l_organization_id := p_organization_id;

Line 383: RAISE FND_API.G_EXC_ERROR;

379: l_transaction_source := p_transaction_source;
380: l_extract_flag := p_extract_flag;
381:
382: IF l_organization_id IS NULL OR l_category_name IS NULL OR l_from_date IS NULL OR l_to_date IS NULL THEN
383: RAISE FND_API.G_EXC_ERROR;
384: END IF;
385:
386: stmt := 'SELECT * '
387: || ' FROM MTL_ADJUSTMENT_TXN_SYNC_V '

Line 490: IF FND_API.To_Boolean( p_commit ) THEN

486: UPDATE mtl_material_transactions
487: SET transaction_extracted = l_extract_flag
488: WHERE transaction_id = t_txn_id(i);
489:
490: IF FND_API.To_Boolean( p_commit ) THEN
491: COMMIT WORK;
492: END IF;
493:
494: l_txn_detail.DELETE;

Line 498: WHEN FND_API.G_EXC_ERROR THEN

494: l_txn_detail.DELETE;
495: t_txn_id.DELETE;
496:
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 ,

Line 500: x_return_status := FND_API.G_RET_STS_ERROR ;

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

Line 507: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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 ,

Line 509: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

Line 518: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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;