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 212: l_return_status := fnd_api.g_ret_sts_success;

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

Line 224: IF NOT FND_API.Compatible_API_Call (

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

Line 229: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 233: IF FND_API.to_Boolean(p_init_msg_list) THEN

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

Line 238: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 263: RAISE FND_API.g_exc_error;

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

Line 827: IF FND_API.to_Boolean(p_commit) THEN

823: END IF;
824:
825:
826: --- Standard check of p_commit
827: IF FND_API.to_Boolean(p_commit) THEN
828: COMMIT WORK;
829: END IF;
830:
831:

Line 845: WHEN FND_API.g_exc_error THEN

841: END IF;
842:
843:
844: EXCEPTION
845: WHEN FND_API.g_exc_error THEN
846: ROLLBACK TO Get_ReceivingUnitPrice_GRP;
847: x_return_status := FND_API.g_ret_sts_error;
848: FND_MSG_PUB.count_and_get
849: ( p_count => x_msg_count

Line 847: x_return_status := FND_API.g_ret_sts_error;

843:
844: EXCEPTION
845: WHEN FND_API.g_exc_error THEN
846: ROLLBACK TO Get_ReceivingUnitPrice_GRP;
847: x_return_status := FND_API.g_ret_sts_error;
848: FND_MSG_PUB.count_and_get
849: ( p_count => x_msg_count
850: , p_data => x_msg_data
851: );

Line 853: WHEN FND_API.g_exc_unexpected_error THEN

849: ( p_count => x_msg_count
850: , p_data => x_msg_data
851: );
852:
853: WHEN FND_API.g_exc_unexpected_error THEN
854: ROLLBACK TO Get_ReceivingUnitPrice_GRP;
855: x_return_status := FND_API.g_ret_sts_unexp_error ;
856: FND_MSG_PUB.count_and_get
857: ( p_count => x_msg_count

Line 855: x_return_status := FND_API.g_ret_sts_unexp_error ;

851: );
852:
853: WHEN FND_API.g_exc_unexpected_error THEN
854: ROLLBACK TO Get_ReceivingUnitPrice_GRP;
855: x_return_status := FND_API.g_ret_sts_unexp_error ;
856: FND_MSG_PUB.count_and_get
857: ( p_count => x_msg_count
858: , p_data => x_msg_data
859: );

Line 863: x_return_status := fnd_api.g_ret_sts_unexp_error ;

859: );
860:
861: WHEN OTHERS THEN
862: ROLLBACK TO Get_ReceivingUnitPrice_GRP;
863: x_return_status := fnd_api.g_ret_sts_unexp_error ;
864:
865: /*IF l_uLog THEN*/ -- replaced this to work around GSCC false positives File.Sql.45 (bug #4480504)
866: IF fnd_log.level_unexpected >= g_log_level THEN
867: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,G_LOG_HEAD || '.'||l_api_name||l_stmt_num

Line 927: IF NOT FND_API.Compatible_API_Call ( l_api_version,

923: SAVEPOINT Validate_PO_Purge;
924:
925: -- Standard call to check for call compatibility
926: l_stmt_num := 10;
927: IF NOT FND_API.Compatible_API_Call ( l_api_version,
928: p_api_version,
929: l_api_name,
930: G_PKG_NAME ) THEN
931: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 931: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

927: IF NOT FND_API.Compatible_API_Call ( l_api_version,
928: p_api_version,
929: l_api_name,
930: G_PKG_NAME ) THEN
931: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
932: END IF;
933:
934: -- Initialize message list
935: l_stmt_num := 20;

Line 936: IF FND_API.to_boolean ( p_init_msg_list ) THEN

932: END IF;
933:
934: -- Initialize message list
935: l_stmt_num := 20;
936: IF FND_API.to_boolean ( p_init_msg_list ) THEN
937: FND_MSG_PUB.initialize;
938: END IF;
939:
940:

Line 942: x_return_status := FND_API.G_RET_STS_SUCCESS;

938: END IF;
939:
940:
941: -- Initialize API return status to success
942: x_return_status := FND_API.G_RET_STS_SUCCESS;
943:
944: -- Set each header_id in p_purge_in_rec as Validated
945: -- This is marked as 'Y' in x_purge_out_rec in the corresponding
946: -- index.

Line 957: IF FND_API.to_Boolean(p_commit) THEN

953: l_index := p_purge_in_rec.entity_ids.NEXT(l_index);
954: END LOOP;
955:
956: --- Standard check of p_commit
957: IF FND_API.to_Boolean(p_commit) THEN
958: COMMIT WORK;
959: END IF;
960:
961:

Line 975: x_return_status := FND_API.G_RET_STS_ERROR;

971: SQLERRM
972: );
973:
974: END IF;
975: x_return_status := FND_API.G_RET_STS_ERROR;
976:
977: END Validate_PO_Purge;
978:
979: -----------------------------------------------------------------------------------------------

Line 1024: IF NOT FND_API.Compatible_API_Call ( l_api_version,

1020: SAVEPOINT Purge;
1021:
1022: -- Standard call to check for call compatibility
1023: l_stmt_num := 10;
1024: IF NOT FND_API.Compatible_API_Call ( l_api_version,
1025: p_api_version,
1026: l_api_name,
1027: G_PKG_NAME ) THEN
1028: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1028: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1024: IF NOT FND_API.Compatible_API_Call ( l_api_version,
1025: p_api_version,
1026: l_api_name,
1027: G_PKG_NAME ) THEN
1028: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1029: END IF;
1030:
1031: -- Initialize message list
1032: l_stmt_num := 20;

Line 1033: IF FND_API.to_boolean ( p_init_msg_list ) THEN

1029: END IF;
1030:
1031: -- Initialize message list
1032: l_stmt_num := 20;
1033: IF FND_API.to_boolean ( p_init_msg_list ) THEN
1034: FND_MSG_PUB.initialize;
1035: END IF;
1036:
1037:

Line 1039: x_return_status := FND_API.G_RET_STS_SUCCESS;

1035: END IF;
1036:
1037:
1038: -- Initialize API return status to success
1039: x_return_status := FND_API.G_RET_STS_SUCCESS;
1040:
1041: l_stmt_num := 25;
1042:
1043: IF p_purge_entity_type <> 'RCV_TRANSACTIONS' THEN

Line 1061: IF FND_API.to_Boolean(p_commit) THEN

1057: WHEN OTHERS THEN
1058: RAISE DELETE_FAILED;
1059: END;
1060: --- Standard check of p_commit
1061: IF FND_API.to_Boolean(p_commit) THEN
1062: COMMIT WORK;
1063: END IF;
1064:
1065:

Line 1079: x_return_status := FND_API.G_RET_STS_ERROR;

1075: SQLERRM
1076: );
1077:
1078: END IF;
1079: x_return_status := FND_API.G_RET_STS_ERROR;
1080:
1081:
1082: WHEN DELETE_FAILED THEN
1083: ROLLBACK TO Purge;

Line 1094: x_return_status := FND_API.G_RET_STS_ERROR;

1090: SQLERRM
1091: );
1092:
1093: END IF;
1094: x_return_status := FND_API.G_RET_STS_ERROR;
1095:
1096: WHEN OTHERS THEN
1097: ROLLBACK To Purge;
1098: IF G_MSG_LEVEL_THRESHOLD <= FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH THEN

Line 1108: x_return_status := FND_API.G_RET_STS_ERROR;

1104: SQLERRM
1105: );
1106:
1107: END IF;
1108: x_return_status := FND_API.G_RET_STS_ERROR;
1109:
1110: END Purge;
1111:
1112: -----------------------------------------------------------------------------