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.GMD_ITEM_TECHNICAL_DATA_PVT dependencies on FND_API

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

18:
19: PROCEDURE INSERT_ITEM_TECHNICAL_DATA_HDR
20: (
21: p_api_version IN NUMBER
22: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
23: , p_commit IN VARCHAR2 := FND_API.G_FALSE
24: , x_return_status OUT NOCOPY VARCHAR2
25: , x_msg_count OUT NOCOPY NUMBER
26: , x_msg_data OUT NOCOPY VARCHAR2

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

19: PROCEDURE INSERT_ITEM_TECHNICAL_DATA_HDR
20: (
21: p_api_version IN NUMBER
22: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
23: , p_commit IN VARCHAR2 := FND_API.G_FALSE
24: , x_return_status OUT NOCOPY VARCHAR2
25: , x_msg_count OUT NOCOPY NUMBER
26: , x_msg_data OUT NOCOPY VARCHAR2
27: , x_tech_data_id IN OUT NOCOPY NUMBER

Line 55: IF FND_API.to_Boolean( p_init_msg_list ) THEN

51: -- Standard Start of API savepoint
52: SAVEPOINT Insert_Item_Technical_Data ;
53:
54: -- Initialize message list if p_init_msg_list is set to TRUE.
55: IF FND_API.to_Boolean( p_init_msg_list ) THEN
56: FND_MSG_PUB.initialize;
57: END IF;
58:
59: -- Standard call to check for call compatibility.

Line 60: IF NOT FND_API.Compatible_API_Call (l_api_version ,

56: FND_MSG_PUB.initialize;
57: END IF;
58:
59: -- Standard call to check for call compatibility.
60: IF NOT FND_API.Compatible_API_Call (l_api_version ,
61: p_api_version ,
62: l_api_name ,
63: G_PKG_NAME
64: )

Line 67: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

63: G_PKG_NAME
64: )
65: THEN
66:
67: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
68: END IF;
69:
70: -- Initialize API return status to success
71: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 71: x_return_status := FND_API.G_RET_STS_SUCCESS;

67: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
68: END IF;
69:
70: -- Initialize API return status to success
71: x_return_status := FND_API.G_RET_STS_SUCCESS;
72:
73: --Bug 9819541 is fixed by changing the fnd_dual to sys.dual
74: IF (x_tech_data_id IS NULL) THEN
75: SELECT GMD_TECH_DATA_ID_S.NEXTVAL

Line 123: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

119: EXCEPTION
120: WHEN OTHERS THEN
121: ROLLBACK TO Insert_Item_Technical_Data;
122: FND_MSG_PUB.Add_Exc_Msg('GMD_ITEM_TECHNICAL_DATA_PVT', 'INSERT_ITEM_TECHNICAL_DATA_HDR');
123: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
124: fnd_msg_pub.count_and_get (
125: p_count => x_msg_count
126: ,p_encoded => FND_API.g_false
127: ,p_data => x_msg_data);

Line 126: ,p_encoded => FND_API.g_false

122: FND_MSG_PUB.Add_Exc_Msg('GMD_ITEM_TECHNICAL_DATA_PVT', 'INSERT_ITEM_TECHNICAL_DATA_HDR');
123: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
124: fnd_msg_pub.count_and_get (
125: p_count => x_msg_count
126: ,p_encoded => FND_API.g_false
127: ,p_data => x_msg_data);
128:
129: END INSERT_ITEM_TECHNICAL_DATA_HDR;
130:

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

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

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

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

Line 177: IF FND_API.to_Boolean( p_init_msg_list )

173: -- Standard Start of API savepoint
174: SAVEPOINT Insert_Item_Technical_Data ;
175:
176: -- Initialize message list if p_init_msg_list is set to TRUE.
177: IF FND_API.to_Boolean( p_init_msg_list )
178: THEN
179: FND_MSG_PUB.initialize;
180: END IF;
181:

Line 183: IF NOT FND_API.Compatible_API_Call (l_api_version ,

179: FND_MSG_PUB.initialize;
180: END IF;
181:
182: -- Standard call to check for call compatibility.
183: IF NOT FND_API.Compatible_API_Call (l_api_version ,
184: p_api_version ,
185: l_api_name ,
186: G_PKG_NAME
187: )

Line 189: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

185: l_api_name ,
186: G_PKG_NAME
187: )
188: THEN
189: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
190: END IF;
191:
192: -- Initialize API return status to success
193: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 193: x_return_status := FND_API.G_RET_STS_SUCCESS;

189: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
190: END IF;
191:
192: -- Initialize API return status to success
193: x_return_status := FND_API.G_RET_STS_SUCCESS;
194:
195: INSERT INTO GMD_TECHNICAL_DATA_DTL (
196: TECH_DATA_ID,
197: TECH_PARM_ID,

Line 232: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

228: EXCEPTION
229: WHEN OTHERS THEN
230: ROLLBACK TO Insert_Item_Technical_Data;
231: FND_MSG_PUB.Add_Exc_Msg('GMD_ITEM_TECHNICAL_DATA_PVT', 'INSERT_ITEM_TECHNICAL_DATA_DTL');
232: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
233: fnd_msg_pub.count_and_get (
234: p_count => x_msg_count
235: ,p_encoded => FND_API.g_false
236: ,p_data => x_msg_data);

Line 235: ,p_encoded => FND_API.g_false

231: FND_MSG_PUB.Add_Exc_Msg('GMD_ITEM_TECHNICAL_DATA_PVT', 'INSERT_ITEM_TECHNICAL_DATA_DTL');
232: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
233: fnd_msg_pub.count_and_get (
234: p_count => x_msg_count
235: ,p_encoded => FND_API.g_false
236: ,p_data => x_msg_data);
237:
238:
239: END INSERT_ITEM_TECHNICAL_DATA_DTL;

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

252:
253: PROCEDURE UPDATE_ITEM_TECHNICAL_DATA
254: (
255: p_api_version IN NUMBER
256: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
257: , p_commit IN VARCHAR2 := FND_API.G_FALSE
258: , x_return_status OUT NOCOPY VARCHAR2
259: , x_msg_count OUT NOCOPY NUMBER
260: , x_msg_data OUT NOCOPY VARCHAR2

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

253: PROCEDURE UPDATE_ITEM_TECHNICAL_DATA
254: (
255: p_api_version IN NUMBER
256: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
257: , p_commit IN VARCHAR2 := FND_API.G_FALSE
258: , x_return_status OUT NOCOPY VARCHAR2
259: , x_msg_count OUT NOCOPY NUMBER
260: , x_msg_data OUT NOCOPY VARCHAR2
261: , p_tech_data_id IN NUMBER

Line 283: IF FND_API.to_Boolean( p_init_msg_list )

279: -- Standard Start of API savepoint
280: SAVEPOINT Update_Item_Technical_Data ;
281:
282: -- Initialize message list if p_init_msg_list is set to TRUE.
283: IF FND_API.to_Boolean( p_init_msg_list )
284: THEN
285: FND_MSG_PUB.initialize;
286: END IF;
287:

Line 289: IF NOT FND_API.Compatible_API_Call (l_api_version ,

285: FND_MSG_PUB.initialize;
286: END IF;
287:
288: -- Standard call to check for call compatibility.
289: IF NOT FND_API.Compatible_API_Call (l_api_version ,
290: p_api_version ,
291: l_api_name ,
292: G_PKG_NAME
293: )

Line 295: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

291: l_api_name ,
292: G_PKG_NAME
293: )
294: THEN
295: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
296: END IF;
297:
298: -- Initialize API return status to success
299: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 299: x_return_status := FND_API.G_RET_STS_SUCCESS;

295: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
296: END IF;
297:
298: -- Initialize API return status to success
299: x_return_status := FND_API.G_RET_STS_SUCCESS;
300:
301: IF (p_tech_data_id IS NOT NULL AND x_tech_parm_id IS NOT NULL) THEN
302: UPDATE gmd_technical_data_dtl
303: SET SORT_SEQ = p_sort_seq

Line 322: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

318: EXCEPTION
319: WHEN OTHERS THEN
320: ROLLBACK TO Insert_Item_Technical_Data;
321: FND_MSG_PUB.Add_Exc_Msg('GMD_ITEM_TECHNICAL_DATA_PVT', 'UPDATE_ITEM_TECHNICAL_DATA');
322: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
323: fnd_msg_pub.count_and_get (
324: p_count => x_msg_count
325: ,p_encoded => FND_API.g_false
326: ,p_data => x_msg_data);

Line 325: ,p_encoded => FND_API.g_false

321: FND_MSG_PUB.Add_Exc_Msg('GMD_ITEM_TECHNICAL_DATA_PVT', 'UPDATE_ITEM_TECHNICAL_DATA');
322: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
323: fnd_msg_pub.count_and_get (
324: p_count => x_msg_count
325: ,p_encoded => FND_API.g_false
326: ,p_data => x_msg_data);
327:
328: END UPDATE_ITEM_TECHNICAL_DATA;
329:

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

340: -- End of comments
341: PROCEDURE DELETE_ITEM_TECHNICAL_DATA
342: (
343: p_api_version IN NUMBER
344: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
345: , p_commit IN VARCHAR2 := FND_API.G_FALSE
346: , x_return_status OUT NOCOPY VARCHAR2
347: , x_msg_count OUT NOCOPY NUMBER
348: , x_msg_data OUT NOCOPY VARCHAR2

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

341: PROCEDURE DELETE_ITEM_TECHNICAL_DATA
342: (
343: p_api_version IN NUMBER
344: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
345: , p_commit IN VARCHAR2 := FND_API.G_FALSE
346: , x_return_status OUT NOCOPY VARCHAR2
347: , x_msg_count OUT NOCOPY NUMBER
348: , x_msg_data OUT NOCOPY VARCHAR2
349: , p_tech_data_id IN NUMBER

Line 365: IF FND_API.to_Boolean( p_init_msg_list ) THEN

361: SAVEPOINT Delete_Item_Technical_Data ;
362:
363:
364: -- Initialize message list if p_init_msg_list is set to TRUE.
365: IF FND_API.to_Boolean( p_init_msg_list ) THEN
366: FND_MSG_PUB.initialize;
367: END IF;
368:
369:

Line 371: IF NOT FND_API.Compatible_API_Call (l_api_version ,

367: END IF;
368:
369:
370: -- Standard call to check for call compatibility.
371: IF NOT FND_API.Compatible_API_Call (l_api_version ,
372: p_api_version ,
373: l_api_name ,
374: G_PKG_NAME
375: )

Line 377: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

373: l_api_name ,
374: G_PKG_NAME
375: )
376: THEN
377: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
378: END IF;
379:
380:
381: -- Initialize API return status to success

Line 382: x_return_status := FND_API.G_RET_STS_SUCCESS;

378: END IF;
379:
380:
381: -- Initialize API return status to success
382: x_return_status := FND_API.G_RET_STS_SUCCESS;
383:
384: IF p_tech_data_id IS NOT NULL THEN
385: -- Delete in OPM is not Physical delete; Set delete mark to 1 (Mark for Purge)
386: UPDATE gmd_technical_data_hdr

Line 402: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

398: EXCEPTION
399: WHEN OTHERS THEN
400: ROLLBACK TO Delete_Item_Technical_Data;
401: FND_MSG_PUB.Add_Exc_Msg('GMD_ITEM_TECHNICAL_DATA_PVT', 'DELETE_ITEM_TECHNICAL_DATA');
402: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
403: fnd_msg_pub.count_and_get (
404: p_count => x_msg_count
405: ,p_encoded => FND_API.g_false
406: ,p_data => x_msg_data);

Line 405: ,p_encoded => FND_API.g_false

401: FND_MSG_PUB.Add_Exc_Msg('GMD_ITEM_TECHNICAL_DATA_PVT', 'DELETE_ITEM_TECHNICAL_DATA');
402: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
403: fnd_msg_pub.count_and_get (
404: p_count => x_msg_count
405: ,p_encoded => FND_API.g_false
406: ,p_data => x_msg_data);
407:
408: END DELETE_ITEM_TECHNICAL_DATA;
409:

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

421: -- End of comments
422:
423: PROCEDURE FETCH_ITEM_TECHNICAL_DATA (
424: p_api_version IN NUMBER
425: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
426: , x_msg_count OUT NOCOPY NUMBER
427: , x_msg_data OUT NOCOPY VARCHAR2
428: , p_header_rec IN GMD_ITEM_TECHNICAL_DATA_PUB.technical_data_hdr_rec
429: , x_dtl_tbl OUT NOCOPY GMD_ITEM_TECHNICAL_DATA_PUB.technical_data_dtl_tab

Line 471: IF FND_API.to_Boolean( p_init_msg_list )

467:
468: BEGIN
469:
470: -- Initialize message list if p_init_msg_list is set to TRUE.
471: IF FND_API.to_Boolean( p_init_msg_list )
472: THEN
473: FND_MSG_PUB.initialize;
474: END IF;
475:

Line 477: IF NOT FND_API.Compatible_API_Call (l_api_version ,

473: FND_MSG_PUB.initialize;
474: END IF;
475:
476: -- Standard call to check for call compatibility.
477: IF NOT FND_API.Compatible_API_Call (l_api_version ,
478: p_api_version ,
479: l_api_name ,
480: G_PKG_NAME
481: )

Line 483: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

479: l_api_name ,
480: G_PKG_NAME
481: )
482: THEN
483: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
484: END IF;
485:
486: -- Initialize API return status to success
487: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 487: x_return_status := FND_API.G_RET_STS_SUCCESS;

483: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
484: END IF;
485:
486: -- Initialize API return status to success
487: x_return_status := FND_API.G_RET_STS_SUCCESS;
488:
489: -- FETCH IMPLEMENTATION
490: -- Get the tech_data_id based on i/p parameters
491: OPEN get_tech_data_id;

Line 521: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

517: END IF;
518:
519: EXCEPTION
520: WHEN OTHERS THEN
521: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
522: FND_MSG_PUB.Add_Exc_Msg('GMD_ITEM_TECHNICAL_DATA_PVT', 'FETCH_ITEM_TECHNICAL_DATA');
523: fnd_msg_pub.count_and_get (
524: p_count => x_msg_count
525: ,p_encoded => FND_API.g_false

Line 525: ,p_encoded => FND_API.g_false

521: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
522: FND_MSG_PUB.Add_Exc_Msg('GMD_ITEM_TECHNICAL_DATA_PVT', 'FETCH_ITEM_TECHNICAL_DATA');
523: fnd_msg_pub.count_and_get (
524: p_count => x_msg_count
525: ,p_encoded => FND_API.g_false
526: ,p_data => x_msg_data);
527:
528:
529: END FETCH_ITEM_TECHNICAL_DATA;