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: IF (x_tech_data_id IS NULL) THEN
74: SELECT GMD_TECH_DATA_ID_S.NEXTVAL
75: INTO l_tech_data_id

Line 122: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

Line 125: ,p_encoded => FND_API.g_false

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

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

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

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

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

Line 176: IF FND_API.to_Boolean( p_init_msg_list )

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

Line 182: IF NOT FND_API.Compatible_API_Call (l_api_version ,

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

Line 188: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 192: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 231: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

Line 234: ,p_encoded => FND_API.g_false

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

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

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

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

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

Line 282: IF FND_API.to_Boolean( p_init_msg_list )

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

Line 288: IF NOT FND_API.Compatible_API_Call (l_api_version ,

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

Line 294: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 298: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 321: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

Line 324: ,p_encoded => FND_API.g_false

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

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

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

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

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

Line 364: IF FND_API.to_Boolean( p_init_msg_list ) THEN

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

Line 370: IF NOT FND_API.Compatible_API_Call (l_api_version ,

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

Line 376: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 381: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 401: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

Line 404: ,p_encoded => FND_API.g_false

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

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

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

Line 470: IF FND_API.to_Boolean( p_init_msg_list )

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

Line 476: IF NOT FND_API.Compatible_API_Call (l_api_version ,

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

Line 482: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 486: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 520: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

Line 524: ,p_encoded => FND_API.g_false

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