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

Line 60: l_init_msg_list VARCHAR2(10) := FND_API.G_FALSE;

56: l_api_name CONSTANT VARCHAR2(30) := 'POPULATE';
57: x_msg_count NUMBER;
58: x_msg_data VARCHAR2(240);
59: x_return_status VARCHAR2(1) ;
60: l_init_msg_list VARCHAR2(10) := FND_API.G_FALSE;
61:
62: BEGIN
63:
64: -- Standard call to check for call compatibility.

Line 65: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

61:
62: BEGIN
63:
64: -- Standard call to check for call compatibility.
65: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
66: p_api_version_number,
67: l_api_name,
68: g_pkg_name)
69: THEN

Line 70: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

66: p_api_version_number,
67: l_api_name,
68: g_pkg_name)
69: THEN
70: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
71: END IF;
72:
73: POPULATE_DENORM
74: (p_api_version_number => 1.0

Line 82: IF x_return_status = FND_API.g_ret_sts_error

78: ,p_proc_num => p_proc_num
79: ,p_load_type => p_load_type
80: );
81:
82: IF x_return_status = FND_API.g_ret_sts_error
83: THEN
84: RAISE FND_API.g_exc_error;
85: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
86: RAISE FND_API.g_exc_unexpected_error;

Line 84: RAISE FND_API.g_exc_error;

80: );
81:
82: IF x_return_status = FND_API.g_ret_sts_error
83: THEN
84: RAISE FND_API.g_exc_error;
85: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
86: RAISE FND_API.g_exc_unexpected_error;
87: END IF;
88:

Line 85: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN

81:
82: IF x_return_status = FND_API.g_ret_sts_error
83: THEN
84: RAISE FND_API.g_exc_error;
85: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
86: RAISE FND_API.g_exc_unexpected_error;
87: END IF;
88:
89: IF x_return_status = FND_API.g_ret_sts_error

Line 86: RAISE FND_API.g_exc_unexpected_error;

82: IF x_return_status = FND_API.g_ret_sts_error
83: THEN
84: RAISE FND_API.g_exc_error;
85: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
86: RAISE FND_API.g_exc_unexpected_error;
87: END IF;
88:
89: IF x_return_status = FND_API.g_ret_sts_error
90: THEN

Line 89: IF x_return_status = FND_API.g_ret_sts_error

85: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
86: RAISE FND_API.g_exc_unexpected_error;
87: END IF;
88:
89: IF x_return_status = FND_API.g_ret_sts_error
90: THEN
91: RAISE FND_API.g_exc_error;
92: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
93: RAISE FND_API.g_exc_unexpected_error;

Line 91: RAISE FND_API.g_exc_error;

87: END IF;
88:
89: IF x_return_status = FND_API.g_ret_sts_error
90: THEN
91: RAISE FND_API.g_exc_error;
92: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
93: RAISE FND_API.g_exc_unexpected_error;
94: END IF;
95:

Line 92: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN

88:
89: IF x_return_status = FND_API.g_ret_sts_error
90: THEN
91: RAISE FND_API.g_exc_error;
92: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
93: RAISE FND_API.g_exc_unexpected_error;
94: END IF;
95:
96: EXCEPTION

Line 93: RAISE FND_API.g_exc_unexpected_error;

89: IF x_return_status = FND_API.g_ret_sts_error
90: THEN
91: RAISE FND_API.g_exc_error;
92: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
93: RAISE FND_API.g_exc_unexpected_error;
94: END IF;
95:
96: EXCEPTION
97: WHEN FND_API.G_EXC_ERROR THEN

Line 97: WHEN FND_API.G_EXC_ERROR THEN

93: RAISE FND_API.g_exc_unexpected_error;
94: END IF;
95:
96: EXCEPTION
97: WHEN FND_API.G_EXC_ERROR THEN
98: x_return_status := FND_API.g_ret_sts_error ;
99: FND_MSG_PUB.count_and_get (p_encoded => FND_API.G_FALSE,
100: p_count => x_msg_count,
101: p_data => x_msg_data);

Line 98: x_return_status := FND_API.g_ret_sts_error ;

94: END IF;
95:
96: EXCEPTION
97: WHEN FND_API.G_EXC_ERROR THEN
98: x_return_status := FND_API.g_ret_sts_error ;
99: FND_MSG_PUB.count_and_get (p_encoded => FND_API.G_FALSE,
100: p_count => x_msg_count,
101: p_data => x_msg_data);
102: ERRBUF := x_msg_data;

Line 99: FND_MSG_PUB.count_and_get (p_encoded => FND_API.G_FALSE,

95:
96: EXCEPTION
97: WHEN FND_API.G_EXC_ERROR THEN
98: x_return_status := FND_API.g_ret_sts_error ;
99: FND_MSG_PUB.count_and_get (p_encoded => FND_API.G_FALSE,
100: p_count => x_msg_count,
101: p_data => x_msg_data);
102: ERRBUF := x_msg_data;
103: RETCODE := 2;

Line 105: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

101: p_data => x_msg_data);
102: ERRBUF := x_msg_data;
103: RETCODE := 2;
104:
105: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
106: x_return_status := FND_API.g_ret_sts_unexp_error ;
107: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,
108: p_count => x_msg_count,
109: p_data => x_msg_data);

Line 106: x_return_status := FND_API.g_ret_sts_unexp_error ;

102: ERRBUF := x_msg_data;
103: RETCODE := 2;
104:
105: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
106: x_return_status := FND_API.g_ret_sts_unexp_error ;
107: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,
108: p_count => x_msg_count,
109: p_data => x_msg_data);
110: ERRBUF := x_msg_data;

Line 107: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,

103: RETCODE := 2;
104:
105: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
106: x_return_status := FND_API.g_ret_sts_unexp_error ;
107: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,
108: p_count => x_msg_count,
109: p_data => x_msg_data);
110: ERRBUF := x_msg_data;
111: RETCODE := 2;

Line 114: x_return_status := FND_API.g_ret_sts_unexp_error ;

110: ERRBUF := x_msg_data;
111: RETCODE := 2;
112:
113: WHEN OTHERS THEN
114: x_return_status := FND_API.g_ret_sts_unexp_error ;
115: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,
116: p_count => x_msg_count,
117: p_data => x_msg_data);
118: ERRBUF := sqlerrm(sqlcode);

Line 115: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,

111: RETCODE := 2;
112:
113: WHEN OTHERS THEN
114: x_return_status := FND_API.g_ret_sts_unexp_error ;
115: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,
116: p_count => x_msg_count,
117: p_data => x_msg_data);
118: ERRBUF := sqlerrm(sqlcode);
119: RETCODE := sqlcode;

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

121: END POPULATE;
122:
123: PROCEDURE POPULATE_DENORM
124: (p_api_version_number IN NUMBER
125: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
126: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
127: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
128: ,x_msg_Count OUT NOCOPY NUMBER
129: ,x_msg_Data OUT NOCOPY VARCHAR2

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

122:
123: PROCEDURE POPULATE_DENORM
124: (p_api_version_number IN NUMBER
125: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
126: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
127: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
128: ,x_msg_Count OUT NOCOPY NUMBER
129: ,x_msg_Data OUT NOCOPY VARCHAR2
130: ,x_return_status OUT NOCOPY VARCHAR2

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

123: PROCEDURE POPULATE_DENORM
124: (p_api_version_number IN NUMBER
125: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
126: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
127: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
128: ,x_msg_Count OUT NOCOPY NUMBER
129: ,x_msg_Data OUT NOCOPY VARCHAR2
130: ,x_return_status OUT NOCOPY VARCHAR2
131: ,p_proc_num IN NUMBER

Line 141: l_init_msg_list VARCHAR2(10) := FND_API.G_FALSE;

137: l_temp_start_date DATE;
138: l_temp_end_date DATE;
139: l_api_version_number CONSTANT NUMBER := 1.0;
140: l_api_name CONSTANT VARCHAR2(30) := 'POPULATE_DENORM';
141: l_init_msg_list VARCHAR2(10) := FND_API.G_FALSE;
142:
143: l_start_date DATE;
144: l_end_date DATE;
145: l_period_from DATE;

Line 294: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

290: ,p_period_from => l_temp_start_date
291: ,p_period_to => sysdate
292: );
293: EXCEPTION
294: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
295: ROLLBACK TO LOAD_ADMIN_RECORDS;
296: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
297: -- Standard call to get message count and if count=1, get the message
298: FND_MSG_PUB.Count_And_Get (

Line 296: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

292: );
293: EXCEPTION
294: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
295: ROLLBACK TO LOAD_ADMIN_RECORDS;
296: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
297: -- Standard call to get message count and if count=1, get the message
298: FND_MSG_PUB.Count_And_Get (
299: p_encoded => FND_API.G_FALSE,
300: p_count => x_msg_count,

Line 299: p_encoded => FND_API.G_FALSE,

295: ROLLBACK TO LOAD_ADMIN_RECORDS;
296: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
297: -- Standard call to get message count and if count=1, get the message
298: FND_MSG_PUB.Count_And_Get (
299: p_encoded => FND_API.G_FALSE,
300: p_count => x_msg_count,
301: p_data => x_msg_data
302: );
303: WHEN FND_API.g_exc_error THEN

Line 303: WHEN FND_API.g_exc_error THEN

299: p_encoded => FND_API.G_FALSE,
300: p_count => x_msg_count,
301: p_data => x_msg_data
302: );
303: WHEN FND_API.g_exc_error THEN
304: x_return_status := FND_API.g_ret_sts_error;
305: FND_MSG_PUB.count_and_get(
306: p_encoded => FND_API.g_false,
307: p_count => x_msg_count,

Line 304: x_return_status := FND_API.g_ret_sts_error;

300: p_count => x_msg_count,
301: p_data => x_msg_data
302: );
303: WHEN FND_API.g_exc_error THEN
304: x_return_status := FND_API.g_ret_sts_error;
305: FND_MSG_PUB.count_and_get(
306: p_encoded => FND_API.g_false,
307: p_count => x_msg_count,
308: p_data => x_msg_data

Line 306: p_encoded => FND_API.g_false,

302: );
303: WHEN FND_API.g_exc_error THEN
304: x_return_status := FND_API.g_ret_sts_error;
305: FND_MSG_PUB.count_and_get(
306: p_encoded => FND_API.g_false,
307: p_count => x_msg_count,
308: p_data => x_msg_data
309: );
310: WHEN OTHERS THEN

Line 311: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

307: p_count => x_msg_count,
308: p_data => x_msg_data
309: );
310: WHEN OTHERS THEN
311: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
312: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
313: THEN
314: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
315: END IF;

Line 318: p_encoded => FND_API.G_FALSE,

314: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
315: END IF;
316: -- Standard call to get message count and if count=1, get the message
317: FND_MSG_PUB.Count_And_Get (
318: p_encoded => FND_API.G_FALSE,
319: p_count => x_msg_count,
320: p_data => x_msg_data
321: );
322: END POPULATE_DENORM;