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

Line 54: RAISE fnd_api.g_exc_unexpected_error;

50: THEN
51: CLOSE c_lock;
52: fnd_message.set_name ('JTF', 'JTF_CAL_RECORD_DELETED');
53: fnd_msg_pub.add;
54: RAISE fnd_api.g_exc_unexpected_error;
55: END IF;
56:
57: /***************************************************************************
58: ** If the object version number has changed, the record has changed:

Line 67: RAISE fnd_api.g_exc_unexpected_error;

63: IF (l_object_version_number <> p_object_version_number)
64: THEN
65: fnd_message.set_name ('JTF', 'JTF_CAL_RECORD_CHANGED');
66: fnd_msg_pub.add;
67: RAISE fnd_api.g_exc_unexpected_error;
68: END IF;
69: END Lock_Row;
70:
71: --------------------------------------------------------------------------

Line 100: , p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false

96: -- End of comments
97: --------------------------------------------------------------------------
98: PROCEDURE Insert_Row
99: ( p_api_version IN NUMBER
100: , p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false
101: , p_commit IN VARCHAR2 DEFAULT fnd_api.g_false
102: , p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full
103: , x_return_status OUT VARCHAR2
104: , x_msg_count OUT NUMBER

Line 101: , p_commit IN VARCHAR2 DEFAULT fnd_api.g_false

97: --------------------------------------------------------------------------
98: PROCEDURE Insert_Row
99: ( p_api_version IN NUMBER
100: , p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false
101: , p_commit IN VARCHAR2 DEFAULT fnd_api.g_false
102: , p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full
103: , x_return_status OUT VARCHAR2
104: , x_msg_count OUT NUMBER
105: , x_msg_data OUT VARCHAR2

Line 102: , p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full

98: PROCEDURE Insert_Row
99: ( p_api_version IN NUMBER
100: , p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false
101: , p_commit IN VARCHAR2 DEFAULT fnd_api.g_false
102: , p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full
103: , x_return_status OUT VARCHAR2
104: , x_msg_count OUT NUMBER
105: , x_msg_data OUT VARCHAR2
106: , p_adr_rec IN AddrRec

Line 133: IF NOT FND_API.Compatible_API_Call( l_api_version

129:
130: --
131: -- Standard call to check for call compatibility
132: --
133: IF NOT FND_API.Compatible_API_Call( l_api_version
134: , p_api_version
135: , l_api_name
136: , G_PKG_NAME
137: )

Line 139: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

135: , l_api_name
136: , G_PKG_NAME
137: )
138: THEN
139: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
140: END IF;
141:
142: --
143: -- Initialize message list if p_init_msg_list is set to TRUE

Line 145: IF FND_API.To_Boolean(p_init_msg_list)

141:
142: --
143: -- Initialize message list if p_init_msg_list is set to TRUE
144: --
145: IF FND_API.To_Boolean(p_init_msg_list)
146: THEN
147: FND_MSG_PUB.Initialize;
148: END IF;
149:

Line 153: x_return_status := FND_API.G_RET_STS_SUCCESS;

149:
150: --
151: -- Initialize API return status to success
152: --
153: x_return_status := FND_API.G_RET_STS_SUCCESS;
154:
155: ------------------------------------------------------------------------
156: -- Insert into table. Generate the ID from the
157: -- sequence and return it

Line 265: IF FND_API.To_Boolean(p_commit)

261:
262: --
263: -- Standard check of p_commit
264: --
265: IF FND_API.To_Boolean(p_commit)
266: THEN
267: COMMIT WORK;
268: END IF;
269:

Line 278: WHEN FND_API.G_EXC_ERROR

274: , p_data => x_msg_data
275: );
276:
277: EXCEPTION
278: WHEN FND_API.G_EXC_ERROR
279: THEN
280: ROLLBACK TO Create_Address_PVT;
281: x_return_status := FND_API.G_RET_STS_ERROR;
282: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

Line 281: x_return_status := FND_API.G_RET_STS_ERROR;

277: EXCEPTION
278: WHEN FND_API.G_EXC_ERROR
279: THEN
280: ROLLBACK TO Create_Address_PVT;
281: x_return_status := FND_API.G_RET_STS_ERROR;
282: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
283: , p_data => x_msg_data
284: );
285:

Line 286: WHEN FND_API.G_EXC_UNEXPECTED_ERROR

282: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
283: , p_data => x_msg_data
284: );
285:
286: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
287: THEN
288: ROLLBACK TO Create_Address_PVT;
289: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
290: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

Line 289: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

285:
286: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
287: THEN
288: ROLLBACK TO Create_Address_PVT;
289: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
290: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
291: , p_data => x_msg_data
292: );
293: WHEN OTHERS

Line 296: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

292: );
293: WHEN OTHERS
294: THEN
295: ROLLBACK TO Create_Address_PVT;
296: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
297: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
298: THEN
299: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME
300: , l_api_name

Line 339: , p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false

335: -- End of comments
336: --------------------------------------------------------------------------
337: PROCEDURE Update_Row
338: ( p_api_version IN NUMBER
339: , p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false
340: , p_commit IN VARCHAR2 DEFAULT fnd_api.g_false
341: , p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full
342: , x_return_status OUT VARCHAR2
343: , x_msg_count OUT NUMBER

Line 340: , p_commit IN VARCHAR2 DEFAULT fnd_api.g_false

336: --------------------------------------------------------------------------
337: PROCEDURE Update_Row
338: ( p_api_version IN NUMBER
339: , p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false
340: , p_commit IN VARCHAR2 DEFAULT fnd_api.g_false
341: , p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full
342: , x_return_status OUT VARCHAR2
343: , x_msg_count OUT NUMBER
344: , x_msg_data OUT VARCHAR2

Line 341: , p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full

337: PROCEDURE Update_Row
338: ( p_api_version IN NUMBER
339: , p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false
340: , p_commit IN VARCHAR2 DEFAULT fnd_api.g_false
341: , p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full
342: , x_return_status OUT VARCHAR2
343: , x_msg_count OUT NUMBER
344: , x_msg_data OUT VARCHAR2
345: , p_adr_rec IN AddrRec

Line 362: IF NOT FND_API.Compatible_API_Call( l_api_version

358: -- Standard start of API savepoint
359: SAVEPOINT Update_Address_PVT;
360:
361: -- Standard call to check for call compatibility
362: IF NOT FND_API.Compatible_API_Call( l_api_version
363: , p_api_version
364: , l_api_name
365: , G_PKG_NAME
366: )

Line 368: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

364: , l_api_name
365: , G_PKG_NAME
366: )
367: THEN
368: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
369: END IF;
370:
371: -- Initialize message list if p_init_msg_list is set to TRUE
372: IF FND_API.To_Boolean(p_init_msg_list)

Line 372: IF FND_API.To_Boolean(p_init_msg_list)

368: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
369: END IF;
370:
371: -- Initialize message list if p_init_msg_list is set to TRUE
372: IF FND_API.To_Boolean(p_init_msg_list)
373: THEN
374: FND_MSG_PUB.Initialize;
375: END IF;
376:

Line 378: x_return_status := FND_API.G_RET_STS_SUCCESS;

374: FND_MSG_PUB.Initialize;
375: END IF;
376:
377: -- Initialize API return status to success
378: x_return_status := FND_API.G_RET_STS_SUCCESS;
379:
380: -- Try to lock the row before updating it
381: Lock_Row( p_adr_rec.address_id
382: , p_adr_rec.object_version_number

Line 439: IF FND_API.To_Boolean(p_commit)

435:
436: --
437: -- Standard check of p_commit
438: --
439: IF FND_API.To_Boolean(p_commit)
440: THEN
441: COMMIT WORK;
442: END IF;
443:

Line 457: WHEN FND_API.G_EXC_ERROR

453: , p_data => x_msg_data
454: );
455:
456: EXCEPTION
457: WHEN FND_API.G_EXC_ERROR
458: THEN
459: ROLLBACK TO Update_Address_PVT;
460: x_return_status := FND_API.G_RET_STS_ERROR;
461: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

Line 460: x_return_status := FND_API.G_RET_STS_ERROR;

456: EXCEPTION
457: WHEN FND_API.G_EXC_ERROR
458: THEN
459: ROLLBACK TO Update_Address_PVT;
460: x_return_status := FND_API.G_RET_STS_ERROR;
461: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
462: , p_data => x_msg_data
463: );
464:

Line 465: WHEN FND_API.G_EXC_UNEXPECTED_ERROR

461: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
462: , p_data => x_msg_data
463: );
464:
465: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
466: THEN
467: ROLLBACK TO Update_Address_PVT;
468: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
469: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

Line 468: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

464:
465: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
466: THEN
467: ROLLBACK TO Update_Address_PVT;
468: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
469: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
470: , p_data => x_msg_data
471: );
472:

Line 476: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

472:
473: WHEN OTHERS
474: THEN
475: ROLLBACK TO Update_Address_PVT;
476: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
477: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
478: THEN
479: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME
480: , l_api_name

Line 520: , p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false

516: -- End of comments
517: --------------------------------------------------------------------------
518: PROCEDURE Delete_Row
519: ( p_api_version IN NUMBER
520: , p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false
521: , p_commit IN VARCHAR2 DEFAULT fnd_api.g_false
522: , p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full
523: , x_return_status OUT VARCHAR2
524: , x_msg_count OUT NUMBER

Line 521: , p_commit IN VARCHAR2 DEFAULT fnd_api.g_false

517: --------------------------------------------------------------------------
518: PROCEDURE Delete_Row
519: ( p_api_version IN NUMBER
520: , p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false
521: , p_commit IN VARCHAR2 DEFAULT fnd_api.g_false
522: , p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full
523: , x_return_status OUT VARCHAR2
524: , x_msg_count OUT NUMBER
525: , x_msg_data OUT VARCHAR2

Line 522: , p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full

518: PROCEDURE Delete_Row
519: ( p_api_version IN NUMBER
520: , p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false
521: , p_commit IN VARCHAR2 DEFAULT fnd_api.g_false
522: , p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full
523: , x_return_status OUT VARCHAR2
524: , x_msg_count OUT NUMBER
525: , x_msg_data OUT VARCHAR2
526: , p_address_id IN NUMBER

Line 545: IF NOT FND_API.Compatible_API_Call( l_api_version

541:
542: --
543: -- Check version number
544: --
545: IF NOT FND_API.Compatible_API_Call( l_api_version
546: , p_api_version
547: , l_api_name
548: , G_PKG_NAME
549: )

Line 551: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

547: , l_api_name
548: , G_PKG_NAME
549: )
550: THEN
551: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
552: END IF;
553:
554: --
555: -- Initialize message list if requested

Line 557: IF FND_API.to_Boolean( p_init_msg_list )

553:
554: --
555: -- Initialize message list if requested
556: --
557: IF FND_API.to_Boolean( p_init_msg_list )
558: THEN
559: FND_MSG_PUB.initialize;
560: END IF;
561:

Line 580: IF FND_API.To_Boolean( p_commit )

576: THEN
577: RAISE NO_DATA_FOUND;
578: END IF;
579:
580: IF FND_API.To_Boolean( p_commit )
581: THEN
582: COMMIT WORK;
583: END IF;
584:

Line 588: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

584:
585: --
586: -- Initialize return status to SUCCESS
587: --
588: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
589:
590:
591: FND_MSG_PUB.Count_And_Get( p_count => X_MSG_COUNT
592: , p_data => X_MSG_DATA

Line 596: WHEN FND_API.G_EXC_ERROR

592: , p_data => X_MSG_DATA
593: );
594:
595: EXCEPTION
596: WHEN FND_API.G_EXC_ERROR
597: THEN
598: ROLLBACK TO Delete_ExpressionLine_PVT;
599: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
600: FND_MSG_PUB.Count_And_Get( p_count => X_MSG_COUNT

Line 599: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

595: EXCEPTION
596: WHEN FND_API.G_EXC_ERROR
597: THEN
598: ROLLBACK TO Delete_ExpressionLine_PVT;
599: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
600: FND_MSG_PUB.Count_And_Get( p_count => X_MSG_COUNT
601: , p_data => X_MSG_DATA
602: );
603:

Line 604: WHEN FND_API.G_EXC_UNEXPECTED_ERROR

600: FND_MSG_PUB.Count_And_Get( p_count => X_MSG_COUNT
601: , p_data => X_MSG_DATA
602: );
603:
604: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
605: THEN
606: ROLLBACK TO Delete_ExpressionLine_PVT;
607: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
608: FND_MSG_PUB.Count_And_Get( p_count => X_MSG_COUNT

Line 607: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

603:
604: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
605: THEN
606: ROLLBACK TO Delete_ExpressionLine_PVT;
607: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
608: FND_MSG_PUB.Count_And_Get( p_count => X_MSG_COUNT
609: , p_data => X_MSG_DATA
610: );
611:

Line 615: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

611:
612: WHEN OTHERS
613: THEN
614: ROLLBACK TO Delete_ExpressionLine_PVT;
615: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
616: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
617: THEN
618: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME
619: , l_api_name