APPS.BIM_SOURCE_CODE_PKG dependencies on FND_API

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

48: ----------------------------------------------------------------------------*/
49:
50: PROCEDURE LOAD_DATA
51: (p_api_version_number IN NUMBER
52: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
53: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
54: ,x_msg_count OUT NOCOPY NUMBER
55: ,x_msg_data OUT NOCOPY VARCHAR2
56: ,x_return_status OUT NOCOPY VARCHAR2

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

49:
50: PROCEDURE LOAD_DATA
51: (p_api_version_number IN NUMBER
52: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
53: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
54: ,x_msg_count OUT NOCOPY NUMBER
55: ,x_msg_data OUT NOCOPY VARCHAR2
56: ,x_return_status OUT NOCOPY VARCHAR2
57: ) IS

Line 92: IF NOT FND_API.Compatible_API_Call (l_api_version_number, p_api_version_number, l_api_name, g_pkg_name)

88: BEGIN /* Standard API call to check for call compatibility */
89: l_return := fnd_installation.get_app_info('BIM', l_status, l_industry, l_schema);
90:
91:
92: IF NOT FND_API.Compatible_API_Call (l_api_version_number, p_api_version_number, l_api_name, g_pkg_name)
93: THEN RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
94: END IF;
95:
96: /* Initialize message list if p_init_msg_list is set to TRUE */

Line 93: THEN RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

89: l_return := fnd_installation.get_app_info('BIM', l_status, l_industry, l_schema);
90:
91:
92: IF NOT FND_API.Compatible_API_Call (l_api_version_number, p_api_version_number, l_api_name, g_pkg_name)
93: THEN RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
94: END IF;
95:
96: /* Initialize message list if p_init_msg_list is set to TRUE */
97: IF FND_API.to_Boolean( p_init_msg_list )

Line 97: IF FND_API.to_Boolean( p_init_msg_list )

93: THEN RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
94: END IF;
95:
96: /* Initialize message list if p_init_msg_list is set to TRUE */
97: IF FND_API.to_Boolean( p_init_msg_list )
98: THEN
99: FND_MSG_PUB.initialize;
100: END IF;
101:

Line 103: x_return_status := FND_API.G_RET_STS_SUCCESS;

99: FND_MSG_PUB.initialize;
100: END IF;
101:
102: /* Initialize API return status to SUCCESS */
103: x_return_status := FND_API.G_RET_STS_SUCCESS;
104:
105: /* Find if the data will be loaded for the first time in the day or not */
106: OPEN chk_history_data;
107: FETCH chk_history_data INTO l_creation_date;

Line 340: WHEN FND_API.G_EXC_ERROR THEN

336: COMMIT;
337:
338: --dbms_output.put_line('S u c c e s s f u l l y e x i t i n g ......');
339: EXCEPTION
340: WHEN FND_API.G_EXC_ERROR THEN
341: x_return_status := FND_API.G_RET_STS_ERROR;
342: /* Standard call to get message count and if count=1, get the message */
343: FND_MSG_PUB.Count_And_Get
344: ( p_count => x_msg_count,

Line 341: x_return_status := FND_API.G_RET_STS_ERROR;

337:
338: --dbms_output.put_line('S u c c e s s f u l l y e x i t i n g ......');
339: EXCEPTION
340: WHEN FND_API.G_EXC_ERROR THEN
341: x_return_status := FND_API.G_RET_STS_ERROR;
342: /* Standard call to get message count and if count=1, get the message */
343: FND_MSG_PUB.Count_And_Get
344: ( p_count => x_msg_count,
345: p_data => x_msg_data

Line 349: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

345: p_data => x_msg_data
346: );
347: ams_utility_pvt.write_conc_log('BIM_R_SOURCE_CODES:IN EXPECTED EXCEPTION '||sqlerrm(sqlcode));
348:
349: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
350: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
351: /* Standard call to get message count and if count=1, get the message */
352: FND_MSG_PUB.Count_And_Get
353: ( p_count => x_msg_count,

Line 350: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

346: );
347: ams_utility_pvt.write_conc_log('BIM_R_SOURCE_CODES:IN EXPECTED EXCEPTION '||sqlerrm(sqlcode));
348:
349: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
350: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
351: /* Standard call to get message count and if count=1, get the message */
352: FND_MSG_PUB.Count_And_Get
353: ( p_count => x_msg_count,
354: p_data => x_msg_data

Line 359: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

355: );
356: ams_utility_pvt.write_conc_log('BIM_R_SOURCE_CODES:IN UNEXPECTED EXCEPTION '||sqlerrm(sqlcode));
357:
358: WHEN OTHERS THEN
359: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
360: IF FND_MSG_PUB.Check_msg_Level ( FND_msg_PUB.G_msg_LVL_UNEXP_ERROR) THEN
361: FND_msg_PUB.Add_Exc_msg( g_pkg_name,l_api_name);
362: END IF;
363: /* Standard call to get message count and if count=1, get the message */