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

Line 8: G_MSG_LEVEL_THRESHOLD CONSTANT VARCHAR2(1):= FND_PROFILE.Value('FND_API_MSG_LEVEL_THRESHOLD');

4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'RCV_AccrualUtilities_GRP';
5: --G_DEBUG CONSTANT VARCHAR2(1) := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N');
6: G_LOG_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
7: G_LOG_HEAD CONSTANT VARCHAR2(40) := 'po.plsql.'||G_PKG_NAME;
8: G_MSG_LEVEL_THRESHOLD CONSTANT VARCHAR2(1):= FND_PROFILE.Value('FND_API_MSG_LEVEL_THRESHOLD');
9:
10: -----------------------------------------------------------------------------
11: -- Start of comments --
12: -- --

Line 15: -- fnd_api package --

11: -- Start of comments --
12: -- --
13: -- FUNCTION --
14: -- get_ret_sts_success returns constant G_RET_STS_SUCCESS from--
15: -- fnd_api package --
16: -----------------------------------------------------------------------------
17: FUNCTION get_ret_sts_success return varchar2
18: IS
19: BEGIN

Line 20: return fnd_api.g_ret_sts_success;

16: -----------------------------------------------------------------------------
17: FUNCTION get_ret_sts_success return varchar2
18: IS
19: BEGIN
20: return fnd_api.g_ret_sts_success;
21: END get_ret_sts_success;
22:
23: -----------------------------------------------------------------------------
24: -- Start of comments --

Line 28: -- fnd_api package --

24: -- Start of comments --
25: -- --
26: -- FUNCTION --
27: -- get_ret_sts_error returns constant G_RET_STS_ERROR from --
28: -- fnd_api package --
29: -----------------------------------------------------------------------------
30: FUNCTION get_ret_sts_error return varchar2
31: IS
32: BEGIN

Line 33: return fnd_api.g_ret_sts_error;

29: -----------------------------------------------------------------------------
30: FUNCTION get_ret_sts_error return varchar2
31: IS
32: BEGIN
33: return fnd_api.g_ret_sts_error;
34: END get_ret_sts_error;
35:
36: -----------------------------------------------------------------------------
37: -- Start of comments --

Line 41: -- from fnd_api package --

37: -- Start of comments --
38: -- --
39: -- FUNCTION --
40: -- get_ret_sts_unexp_error returns constant G_RET_STS_UNEXP_ERROR --
41: -- from fnd_api package --
42: -----------------------------------------------------------------------------
43: FUNCTION get_ret_sts_unexp_error return varchar2
44: IS
45: BEGIN

Line 46: return fnd_api.g_ret_sts_unexp_error;

42: -----------------------------------------------------------------------------
43: FUNCTION get_ret_sts_unexp_error return varchar2
44: IS
45: BEGIN
46: return fnd_api.g_ret_sts_unexp_error;
47: END get_ret_sts_unexp_error;
48:
49: -----------------------------------------------------------------------------
50: -- Start of comments --

Line 53: -- get_true returns constant G_TRUE from fnd_api package --

49: -----------------------------------------------------------------------------
50: -- Start of comments --
51: -- --
52: -- FUNCTION --
53: -- get_true returns constant G_TRUE from fnd_api package --
54: -----------------------------------------------------------------------------
55: FUNCTION get_true return varchar2
56: IS
57: BEGIN

Line 58: return fnd_api.g_true;

54: -----------------------------------------------------------------------------
55: FUNCTION get_true return varchar2
56: IS
57: BEGIN
58: return fnd_api.g_true;
59: END get_true;
60:
61: -----------------------------------------------------------------------------
62: -- Start of comments --

Line 65: -- get_false returns constant G_FALSE from fnd_api package--

61: -----------------------------------------------------------------------------
62: -- Start of comments --
63: -- --
64: -- FUNCTION --
65: -- get_false returns constant G_FALSE from fnd_api package--
66: -----------------------------------------------------------------------------
67: FUNCTION get_false return varchar2
68: IS
69: BEGIN

Line 70: return fnd_api.g_false;

66: -----------------------------------------------------------------------------
67: FUNCTION get_false return varchar2
68: IS
69: BEGIN
70: return fnd_api.g_false;
71: END get_false;
72:
73: -----------------------------------------------------------------------------
74: -- Start of comments --

Line 78: -- fnd_api package --

74: -- Start of comments --
75: -- --
76: -- FUNCTION --
77: -- get_valid_level_none returns constant G_VALID_LEVEL_NONE from --
78: -- fnd_api package --
79: -----------------------------------------------------------------------------
80: FUNCTION get_valid_level_none return NUMBER
81: IS
82: BEGIN

Line 83: return fnd_api.g_valid_level_none;

79: -----------------------------------------------------------------------------
80: FUNCTION get_valid_level_none return NUMBER
81: IS
82: BEGIN
83: return fnd_api.g_valid_level_none;
84: END get_valid_level_none;
85:
86: -----------------------------------------------------------------------------
87: -- Start of comments --

Line 91: -- fnd_api package --

87: -- Start of comments --
88: -- --
89: -- FUNCTION --
90: -- get_valid_level_full returns constant G_VALID_LEVEL_FULL from --
91: -- fnd_api package --
92: -----------------------------------------------------------------------------
93: FUNCTION get_valid_level_full return NUMBER
94: IS
95: BEGIN

Line 96: return fnd_api.g_valid_level_full;

92: -----------------------------------------------------------------------------
93: FUNCTION get_valid_level_full return NUMBER
94: IS
95: BEGIN
96: return fnd_api.g_valid_level_full;
97: END get_valid_level_full;
98:
99: -----------------------------------------------------------------------------
100: -- Start of comments

Line 111: -- Default = FND_API.G_FALSE

107: -- Pre-reqs :
108: -- Parameters :
109: -- IN : p_api_version IN NUMBER Required
110: -- p_init_msg_list IN VARCHAR2 Optional
111: -- Default = FND_API.G_FALSE
112: -- p_commit IN VARCHAR2 Optional
113: -- Default = FND_API.G_FALSE
114: -- p_validation_level IN NUMBER Optional
115: -- Default = FND_API.G_VALID_LEVEL_FULL

Line 113: -- Default = FND_API.G_FALSE

109: -- IN : p_api_version IN NUMBER Required
110: -- p_init_msg_list IN VARCHAR2 Optional
111: -- Default = FND_API.G_FALSE
112: -- p_commit IN VARCHAR2 Optional
113: -- Default = FND_API.G_FALSE
114: -- p_validation_level IN NUMBER Optional
115: -- Default = FND_API.G_VALID_LEVEL_FULL
116: -- p_rcv_transaction_id IN NUMBER
117: -- p_valuation_date IN DATE Optional

Line 115: -- Default = FND_API.G_VALID_LEVEL_FULL

111: -- Default = FND_API.G_FALSE
112: -- p_commit IN VARCHAR2 Optional
113: -- Default = FND_API.G_FALSE
114: -- p_validation_level IN NUMBER Optional
115: -- Default = FND_API.G_VALID_LEVEL_FULL
116: -- p_rcv_transaction_id IN NUMBER
117: -- p_valuation_date IN DATE Optional
118: -- Default = NULL
119: --

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

137: -- End of comments
138: -------------------------------------------------------------------------------
139: PROCEDURE Get_ReceivingUnitPrice(
140: p_api_version IN NUMBER,
141: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
142: p_commit IN VARCHAR2 := FND_API.G_FALSE,
143: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
144: x_return_status OUT NOCOPY VARCHAR2,
145: x_msg_count OUT NOCOPY NUMBER,

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

138: -------------------------------------------------------------------------------
139: PROCEDURE Get_ReceivingUnitPrice(
140: p_api_version IN NUMBER,
141: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
142: p_commit IN VARCHAR2 := FND_API.G_FALSE,
143: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
144: x_return_status OUT NOCOPY VARCHAR2,
145: x_msg_count OUT NOCOPY NUMBER,
146: x_msg_data OUT NOCOPY VARCHAR2,

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

139: PROCEDURE Get_ReceivingUnitPrice(
140: p_api_version IN NUMBER,
141: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
142: p_commit IN VARCHAR2 := FND_API.G_FALSE,
143: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
144: x_return_status OUT NOCOPY VARCHAR2,
145: x_msg_count OUT NOCOPY NUMBER,
146: x_msg_data OUT NOCOPY VARCHAR2,
147:

Line 209: l_return_status := fnd_api.g_ret_sts_success;

205: CONNECT BY parent_transaction_id = PRIOR transaction_id;
206:
207:
208: BEGIN
209: l_return_status := fnd_api.g_ret_sts_success;
210: -- Standard start of API savepoint
211: SAVEPOINT Get_ReceivingUnitPrice_GRP;
212:
213: l_stmt_num := 0;

Line 221: IF NOT FND_API.Compatible_API_Call (

217: ,'Get_ReceivingUnitPrice <<');
218: END IF;
219:
220: -- Standard call to check for call compatibility
221: IF NOT FND_API.Compatible_API_Call (
222: l_api_version,
223: p_api_version,
224: l_api_name,
225: G_PKG_NAME ) THEN

Line 226: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

222: l_api_version,
223: p_api_version,
224: l_api_name,
225: G_PKG_NAME ) THEN
226: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
227: END IF;
228:
229: -- Initialize message list if p_init_msg_list is set to TRUE
230: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 230: IF FND_API.to_Boolean(p_init_msg_list) THEN

226: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
227: END IF;
228:
229: -- Initialize message list if p_init_msg_list is set to TRUE
230: IF FND_API.to_Boolean(p_init_msg_list) THEN
231: FND_MSG_PUB.initialize;
232: END IF;
233:
234: -- Initialize API return status to success

Line 235: x_return_status := FND_API.G_RET_STS_SUCCESS;

231: FND_MSG_PUB.initialize;
232: END IF;
233:
234: -- Initialize API return status to success
235: x_return_status := FND_API.G_RET_STS_SUCCESS;
236:
237: IF l_sLog THEN
238: l_api_message := 'p_rcv_transaction_id : '||p_rcv_transaction_id;
239: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,G_LOG_HEAD || '.'||l_api_name||'.begin'

Line 260: RAISE FND_API.g_exc_error;

256: FND_MSG_pub.add;
257: IF l_errorLog THEN
258: FND_LOG.message(FND_LOG.LEVEL_ERROR,G_LOG_HEAD || '.'||l_api_name||l_stmt_num,FALSE);
259: END IF;
260: RAISE FND_API.g_exc_error;
261: END IF;
262:
263:
264: /* Get the parameters to determine whether this is a global procurement scenario. */

Line 722: IF FND_API.to_Boolean(p_commit) THEN

718: END IF;
719:
720:
721: --- Standard check of p_commit
722: IF FND_API.to_Boolean(p_commit) THEN
723: COMMIT WORK;
724: END IF;
725:
726:

Line 740: WHEN FND_API.g_exc_error THEN

736: END IF;
737:
738:
739: EXCEPTION
740: WHEN FND_API.g_exc_error THEN
741: ROLLBACK TO Get_ReceivingUnitPrice_GRP;
742: x_return_status := FND_API.g_ret_sts_error;
743: FND_MSG_PUB.count_and_get
744: ( p_count => x_msg_count

Line 742: x_return_status := FND_API.g_ret_sts_error;

738:
739: EXCEPTION
740: WHEN FND_API.g_exc_error THEN
741: ROLLBACK TO Get_ReceivingUnitPrice_GRP;
742: x_return_status := FND_API.g_ret_sts_error;
743: FND_MSG_PUB.count_and_get
744: ( p_count => x_msg_count
745: , p_data => x_msg_data
746: );

Line 748: WHEN FND_API.g_exc_unexpected_error THEN

744: ( p_count => x_msg_count
745: , p_data => x_msg_data
746: );
747:
748: WHEN FND_API.g_exc_unexpected_error THEN
749: ROLLBACK TO Get_ReceivingUnitPrice_GRP;
750: x_return_status := FND_API.g_ret_sts_unexp_error ;
751: FND_MSG_PUB.count_and_get
752: ( p_count => x_msg_count

Line 750: x_return_status := FND_API.g_ret_sts_unexp_error ;

746: );
747:
748: WHEN FND_API.g_exc_unexpected_error THEN
749: ROLLBACK TO Get_ReceivingUnitPrice_GRP;
750: x_return_status := FND_API.g_ret_sts_unexp_error ;
751: FND_MSG_PUB.count_and_get
752: ( p_count => x_msg_count
753: , p_data => x_msg_data
754: );

Line 758: x_return_status := fnd_api.g_ret_sts_unexp_error ;

754: );
755:
756: WHEN OTHERS THEN
757: ROLLBACK TO Get_ReceivingUnitPrice_GRP;
758: x_return_status := fnd_api.g_ret_sts_unexp_error ;
759:
760: /*IF l_uLog THEN*/ -- replaced this to work around GSCC false positives File.Sql.45 (bug #4480504)
761: IF fnd_log.level_unexpected >= g_log_level THEN
762: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,G_LOG_HEAD || '.'||l_api_name||l_stmt_num

Line 822: IF NOT FND_API.Compatible_API_Call ( l_api_version,

818: SAVEPOINT Validate_PO_Purge;
819:
820: -- Standard call to check for call compatibility
821: l_stmt_num := 10;
822: IF NOT FND_API.Compatible_API_Call ( l_api_version,
823: p_api_version,
824: l_api_name,
825: G_PKG_NAME ) THEN
826: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 826: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

822: IF NOT FND_API.Compatible_API_Call ( l_api_version,
823: p_api_version,
824: l_api_name,
825: G_PKG_NAME ) THEN
826: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
827: END IF;
828:
829: -- Initialize message list
830: l_stmt_num := 20;

Line 831: IF FND_API.to_boolean ( p_init_msg_list ) THEN

827: END IF;
828:
829: -- Initialize message list
830: l_stmt_num := 20;
831: IF FND_API.to_boolean ( p_init_msg_list ) THEN
832: FND_MSG_PUB.initialize;
833: END IF;
834:
835:

Line 837: x_return_status := FND_API.G_RET_STS_SUCCESS;

833: END IF;
834:
835:
836: -- Initialize API return status to success
837: x_return_status := FND_API.G_RET_STS_SUCCESS;
838:
839: -- Set each header_id in p_purge_in_rec as Validated
840: -- This is marked as 'Y' in x_purge_out_rec in the corresponding
841: -- index.

Line 852: IF FND_API.to_Boolean(p_commit) THEN

848: l_index := p_purge_in_rec.entity_ids.NEXT(l_index);
849: END LOOP;
850:
851: --- Standard check of p_commit
852: IF FND_API.to_Boolean(p_commit) THEN
853: COMMIT WORK;
854: END IF;
855:
856:

Line 870: x_return_status := FND_API.G_RET_STS_ERROR;

866: SQLERRM
867: );
868:
869: END IF;
870: x_return_status := FND_API.G_RET_STS_ERROR;
871:
872: END Validate_PO_Purge;
873:
874: -----------------------------------------------------------------------------------------------

Line 919: IF NOT FND_API.Compatible_API_Call ( l_api_version,

915: SAVEPOINT Purge;
916:
917: -- Standard call to check for call compatibility
918: l_stmt_num := 10;
919: IF NOT FND_API.Compatible_API_Call ( l_api_version,
920: p_api_version,
921: l_api_name,
922: G_PKG_NAME ) THEN
923: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 923: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

919: IF NOT FND_API.Compatible_API_Call ( l_api_version,
920: p_api_version,
921: l_api_name,
922: G_PKG_NAME ) THEN
923: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
924: END IF;
925:
926: -- Initialize message list
927: l_stmt_num := 20;

Line 928: IF FND_API.to_boolean ( p_init_msg_list ) THEN

924: END IF;
925:
926: -- Initialize message list
927: l_stmt_num := 20;
928: IF FND_API.to_boolean ( p_init_msg_list ) THEN
929: FND_MSG_PUB.initialize;
930: END IF;
931:
932:

Line 934: x_return_status := FND_API.G_RET_STS_SUCCESS;

930: END IF;
931:
932:
933: -- Initialize API return status to success
934: x_return_status := FND_API.G_RET_STS_SUCCESS;
935:
936: l_stmt_num := 25;
937:
938: IF p_purge_entity_type <> 'RCV_TRANSACTIONS' THEN

Line 956: IF FND_API.to_Boolean(p_commit) THEN

952: WHEN OTHERS THEN
953: RAISE DELETE_FAILED;
954: END;
955: --- Standard check of p_commit
956: IF FND_API.to_Boolean(p_commit) THEN
957: COMMIT WORK;
958: END IF;
959:
960:

Line 974: x_return_status := FND_API.G_RET_STS_ERROR;

970: SQLERRM
971: );
972:
973: END IF;
974: x_return_status := FND_API.G_RET_STS_ERROR;
975:
976:
977: WHEN DELETE_FAILED THEN
978: ROLLBACK TO Purge;

Line 989: x_return_status := FND_API.G_RET_STS_ERROR;

985: SQLERRM
986: );
987:
988: END IF;
989: x_return_status := FND_API.G_RET_STS_ERROR;
990:
991: WHEN OTHERS THEN
992: ROLLBACK To Purge;
993: IF G_MSG_LEVEL_THRESHOLD <= FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH THEN

Line 1003: x_return_status := FND_API.G_RET_STS_ERROR;

999: SQLERRM
1000: );
1001:
1002: END IF;
1003: x_return_status := FND_API.G_RET_STS_ERROR;
1004:
1005: END Purge;
1006:
1007: -----------------------------------------------------------------------------