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

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

13:
14: PROCEDURE Insert_Row
15: (
16: p_api_version IN NUMBER,
17: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
18: p_commit IN VARCHAR2 := FND_API.G_FALSE,
19: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
20: x_return_status OUT NOCOPY VARCHAR2,
21: x_msg_count OUT NOCOPY NUMBER,

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

14: PROCEDURE Insert_Row
15: (
16: p_api_version IN NUMBER,
17: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
18: p_commit IN VARCHAR2 := FND_API.G_FALSE,
19: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
20: x_return_status OUT NOCOPY VARCHAR2,
21: x_msg_count OUT NOCOPY NUMBER,
22: x_msg_data OUT NOCOPY VARCHAR2,

Line 19: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

15: (
16: p_api_version IN NUMBER,
17: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
18: p_commit IN VARCHAR2 := FND_API.G_FALSE,
19: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
20: x_return_status OUT NOCOPY VARCHAR2,
21: x_msg_count OUT NOCOPY NUMBER,
22: x_msg_data OUT NOCOPY VARCHAR2,
23: ---------------------------------------------

Line 35: IF NOT FND_API.Compatible_API_Call ( l_api_version,

31: BEGIN
32:
33: SAVEPOINT Insert_Row_Pvt ;
34:
35: IF NOT FND_API.Compatible_API_Call ( l_api_version,
36: p_api_version,
37: l_api_name,
38: G_PKG_NAME )
39: THEN

Line 40: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

36: p_api_version,
37: l_api_name,
38: G_PKG_NAME )
39: THEN
40: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
41: END IF;
42:
43:
44: IF FND_API.to_Boolean ( p_init_msg_list )

Line 44: IF FND_API.to_Boolean ( p_init_msg_list )

40: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
41: END IF;
42:
43:
44: IF FND_API.to_Boolean ( p_init_msg_list )
45: THEN
46: FND_MSG_PUB.initialize ;
47: END IF;
48:

Line 49: x_return_status := FND_API.G_RET_STS_SUCCESS ;

45: THEN
46: FND_MSG_PUB.initialize ;
47: END IF;
48:
49: x_return_status := FND_API.G_RET_STS_SUCCESS ;
50:
51:
52: INSERT INTO po_line_locations_all (
53: line_location_id,

Line 308: IF FND_API.To_Boolean ( p_commit )

304: p_po_line_locs_rec.matching_basis,
305: p_po_line_locs_rec.outsourced_assembly -- Bug 6971366 . Added the missing outsource assembly col.
306: ) ;
307:
308: IF FND_API.To_Boolean ( p_commit )
309: THEN
310: COMMIT WORK;
311: END IF;
312:

Line 318: WHEN FND_API.G_EXC_ERROR

314: p_data => x_msg_data );
315:
316: EXCEPTION
317:
318: WHEN FND_API.G_EXC_ERROR
319: THEN
320:
321: ROLLBACK TO Insert_Row_Pvt ;
322: x_return_status := FND_API.G_RET_STS_ERROR;

Line 322: x_return_status := FND_API.G_RET_STS_ERROR;

318: WHEN FND_API.G_EXC_ERROR
319: THEN
320:
321: ROLLBACK TO Insert_Row_Pvt ;
322: x_return_status := FND_API.G_RET_STS_ERROR;
323: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
324: p_data => x_msg_data );
325:
326: WHEN FND_API.G_EXC_UNEXPECTED_ERROR

Line 326: WHEN FND_API.G_EXC_UNEXPECTED_ERROR

322: x_return_status := FND_API.G_RET_STS_ERROR;
323: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
324: p_data => x_msg_data );
325:
326: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
327: THEN
328: ROLLBACK TO Insert_Row_Pvt ;
329: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
330: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

Line 329: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

325:
326: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
327: THEN
328: ROLLBACK TO Insert_Row_Pvt ;
329: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
330: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
331: p_data => x_msg_data );
332:
333: WHEN OTHERS

Line 336: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

332:
333: WHEN OTHERS
334: THEN
335: ROLLBACK TO Insert_Row_Pvt ;
336: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
337:
338: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
339: THEN
340: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,

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

354:
355: PROCEDURE Update_Row
356: (
357: p_api_version IN NUMBER,
358: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
359: p_commit IN VARCHAR2 := FND_API.G_FALSE,
360: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
361: x_return_status OUT NOCOPY VARCHAR2,
362: x_msg_count OUT NOCOPY NUMBER,

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

355: PROCEDURE Update_Row
356: (
357: p_api_version IN NUMBER,
358: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
359: p_commit IN VARCHAR2 := FND_API.G_FALSE,
360: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
361: x_return_status OUT NOCOPY VARCHAR2,
362: x_msg_count OUT NOCOPY NUMBER,
363: x_msg_data OUT NOCOPY VARCHAR2,

Line 360: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

356: (
357: p_api_version IN NUMBER,
358: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
359: p_commit IN VARCHAR2 := FND_API.G_FALSE,
360: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
361: x_return_status OUT NOCOPY VARCHAR2,
362: x_msg_count OUT NOCOPY NUMBER,
363: x_msg_data OUT NOCOPY VARCHAR2,
364: ---------------------------------------------

Line 376: IF NOT FND_API.Compatible_API_Call ( l_api_version,

372: BEGIN
373:
374: SAVEPOINT Update_Row_Pvt ;
375:
376: IF NOT FND_API.Compatible_API_Call ( l_api_version,
377: p_api_version,
378: l_api_name,
379: G_PKG_NAME )
380: THEN

Line 381: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

377: p_api_version,
378: l_api_name,
379: G_PKG_NAME )
380: THEN
381: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
382: END IF;
383:
384:
385: IF FND_API.to_Boolean ( p_init_msg_list )

Line 385: IF FND_API.to_Boolean ( p_init_msg_list )

381: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
382: END IF;
383:
384:
385: IF FND_API.to_Boolean ( p_init_msg_list )
386: THEN
387: FND_MSG_PUB.initialize ;
388: END IF;
389:

Line 390: x_return_status := FND_API.G_RET_STS_SUCCESS ;

386: THEN
387: FND_MSG_PUB.initialize ;
388: END IF;
389:
390: x_return_status := FND_API.G_RET_STS_SUCCESS ;
391:
392: /* update */
393: UPDATE po_line_locations_all
394: SET

Line 530: IF FND_API.To_Boolean ( p_commit )

526: RAISE NO_DATA_FOUND ;
527: END IF;
528:
529:
530: IF FND_API.To_Boolean ( p_commit )
531: THEN
532: COMMIT WORK;
533: END IF;
534:

Line 540: WHEN FND_API.G_EXC_ERROR

536: p_data => x_msg_data );
537:
538: EXCEPTION
539:
540: WHEN FND_API.G_EXC_ERROR
541: THEN
542: ROLLBACK TO Update_Row_Pvt ;
543: x_return_status := FND_API.G_RET_STS_ERROR;
544:

Line 543: x_return_status := FND_API.G_RET_STS_ERROR;

539:
540: WHEN FND_API.G_EXC_ERROR
541: THEN
542: ROLLBACK TO Update_Row_Pvt ;
543: x_return_status := FND_API.G_RET_STS_ERROR;
544:
545: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
546: p_data => x_msg_data );
547:

Line 548: WHEN FND_API.G_EXC_UNEXPECTED_ERROR

544:
545: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
546: p_data => x_msg_data );
547:
548: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
549: THEN
550:
551: ROLLBACK TO Update_Row_Pvt ;
552: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 552: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

548: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
549: THEN
550:
551: ROLLBACK TO Update_Row_Pvt ;
552: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
553: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
554: p_data => x_msg_data );
555:
556: WHEN OTHERS

Line 560: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

556: WHEN OTHERS
557: THEN
558:
559: ROLLBACK TO Update_Row_Pvt ;
560: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
561:
562: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
563: THEN
564: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,