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_SEGMENT_DENORM_PKG dependencies on FND_API

Line 73: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

69:
70: l_date:= bis_common_parameters.get_global_start_date;
71: -- Standard call to check for call compatibility.
72:
73: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
74: p_api_version_number,
75: l_api_name,
76: g_pkg_name)
77: THEN

Line 78: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

74: p_api_version_number,
75: l_api_name,
76: g_pkg_name)
77: THEN
78: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
79: END IF;
80:
81: POPULATE_SEGMENT_DENORM
82: (p_api_version_number => 1.0

Line 83: ,p_init_msg_list => FND_API.G_FALSE

79: END IF;
80:
81: POPULATE_SEGMENT_DENORM
82: (p_api_version_number => 1.0
83: ,p_init_msg_list => FND_API.G_FALSE
84: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
85: ,p_commit => FND_API.G_FALSE
86: ,x_msg_Count => x_msg_count
87: ,x_msg_Data => x_msg_data

Line 84: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL

80:
81: POPULATE_SEGMENT_DENORM
82: (p_api_version_number => 1.0
83: ,p_init_msg_list => FND_API.G_FALSE
84: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
85: ,p_commit => FND_API.G_FALSE
86: ,x_msg_Count => x_msg_count
87: ,x_msg_Data => x_msg_data
88: ,x_return_status => x_return_status

Line 85: ,p_commit => FND_API.G_FALSE

81: POPULATE_SEGMENT_DENORM
82: (p_api_version_number => 1.0
83: ,p_init_msg_list => FND_API.G_FALSE
84: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
85: ,p_commit => FND_API.G_FALSE
86: ,x_msg_Count => x_msg_count
87: ,x_msg_Data => x_msg_data
88: ,x_return_status => x_return_status
89: ,p_proc_num => p_proc_num

Line 94: IF x_return_status = FND_API.g_ret_sts_error

90: ,p_load_type => p_load_type
91: );
92:
93:
94: IF x_return_status = FND_API.g_ret_sts_error
95: THEN
96: RAISE FND_API.g_exc_error;
97: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
98: RAISE FND_API.g_exc_unexpected_error;

Line 96: RAISE FND_API.g_exc_error;

92:
93:
94: IF x_return_status = FND_API.g_ret_sts_error
95: THEN
96: RAISE FND_API.g_exc_error;
97: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
98: RAISE FND_API.g_exc_unexpected_error;
99: END IF;
100:

Line 97: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN

93:
94: IF x_return_status = FND_API.g_ret_sts_error
95: THEN
96: RAISE FND_API.g_exc_error;
97: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
98: RAISE FND_API.g_exc_unexpected_error;
99: END IF;
100:
101: EXCEPTION

Line 98: RAISE FND_API.g_exc_unexpected_error;

94: IF x_return_status = FND_API.g_ret_sts_error
95: THEN
96: RAISE FND_API.g_exc_error;
97: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
98: RAISE FND_API.g_exc_unexpected_error;
99: END IF;
100:
101: EXCEPTION
102:

Line 103: WHEN FND_API.G_EXC_ERROR THEN

99: END IF;
100:
101: EXCEPTION
102:
103: WHEN FND_API.G_EXC_ERROR THEN
104: x_return_status := FND_API.g_ret_sts_error ;
105: FND_MSG_PUB.count_and_get (p_encoded => FND_API.G_FALSE,
106: p_count => x_msg_count,
107: p_data => x_msg_data);

Line 104: x_return_status := FND_API.g_ret_sts_error ;

100:
101: EXCEPTION
102:
103: WHEN FND_API.G_EXC_ERROR THEN
104: x_return_status := FND_API.g_ret_sts_error ;
105: FND_MSG_PUB.count_and_get (p_encoded => FND_API.G_FALSE,
106: p_count => x_msg_count,
107: p_data => x_msg_data);
108: ERRBUF := x_msg_data;

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

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

Line 111: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

107: p_data => x_msg_data);
108: ERRBUF := x_msg_data;
109: RETCODE := 2;
110:
111: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
112: x_return_status := FND_API.g_ret_sts_unexp_error ;
113: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,
114: p_count => x_msg_count,
115: p_data => x_msg_data);

Line 112: x_return_status := FND_API.g_ret_sts_unexp_error ;

108: ERRBUF := x_msg_data;
109: RETCODE := 2;
110:
111: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
112: x_return_status := FND_API.g_ret_sts_unexp_error ;
113: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,
114: p_count => x_msg_count,
115: p_data => x_msg_data);
116: ERRBUF := x_msg_data;

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

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

Line 120: x_return_status := FND_API.g_ret_sts_unexp_error ;

116: ERRBUF := x_msg_data;
117: RETCODE := 2;
118:
119: WHEN OTHERS THEN
120: x_return_status := FND_API.g_ret_sts_unexp_error ;
121: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,
122: p_count => x_msg_count,
123: p_data => x_msg_data);
124: ERRBUF := sqlerrm(sqlcode);

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

117: RETCODE := 2;
118:
119: WHEN OTHERS THEN
120: x_return_status := FND_API.g_ret_sts_unexp_error ;
121: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,
122: p_count => x_msg_count,
123: p_data => x_msg_data);
124: ERRBUF := sqlerrm(sqlcode);
125: RETCODE := sqlcode;

Line 251: l_init_msg_list:= FND_API.G_FALSE;

247: l_sql_id := NULL;
248: END LOOP;
249: CLOSE c_query_source;
250:
251: l_init_msg_list:= FND_API.G_FALSE;
252:
253: /* This Delete Statement is for the records changed after last run. */
254:
255:

Line 482: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

478: ,p_period_to => sysdate
479: );
480:
481: EXCEPTION
482: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
483: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
484: Execute Immediate 'DROP TABLE source_query_sgdb';
485: -- Standard call to get message count and if count=1, get the message
486: FND_MSG_PUB.Count_And_Get (

Line 483: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

479: );
480:
481: EXCEPTION
482: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
483: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
484: Execute Immediate 'DROP TABLE source_query_sgdb';
485: -- Standard call to get message count and if count=1, get the message
486: FND_MSG_PUB.Count_And_Get (
487: p_encoded => FND_API.G_FALSE,

Line 487: p_encoded => FND_API.G_FALSE,

483: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
484: Execute Immediate 'DROP TABLE source_query_sgdb';
485: -- Standard call to get message count and if count=1, get the message
486: FND_MSG_PUB.Count_And_Get (
487: p_encoded => FND_API.G_FALSE,
488: p_count => x_msg_count,
489: p_data => x_msg_data
490: );
491:

Line 492: WHEN FND_API.g_exc_error THEN

488: p_count => x_msg_count,
489: p_data => x_msg_data
490: );
491:
492: WHEN FND_API.g_exc_error THEN
493: x_return_status := FND_API.g_ret_sts_error;
494: Execute immediate 'DROP TABLE source_query_sgdb';
495: FND_MSG_PUB.count_and_get(
496: p_encoded => FND_API.g_false,

Line 493: x_return_status := FND_API.g_ret_sts_error;

489: p_data => x_msg_data
490: );
491:
492: WHEN FND_API.g_exc_error THEN
493: x_return_status := FND_API.g_ret_sts_error;
494: Execute immediate 'DROP TABLE source_query_sgdb';
495: FND_MSG_PUB.count_and_get(
496: p_encoded => FND_API.g_false,
497: p_count => x_msg_count,

Line 496: p_encoded => FND_API.g_false,

492: WHEN FND_API.g_exc_error THEN
493: x_return_status := FND_API.g_ret_sts_error;
494: Execute immediate 'DROP TABLE source_query_sgdb';
495: FND_MSG_PUB.count_and_get(
496: p_encoded => FND_API.g_false,
497: p_count => x_msg_count,
498: p_data => x_msg_data
499: );
500:

Line 502: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

498: p_data => x_msg_data
499: );
500:
501: WHEN OTHERS THEN
502: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
503: Execute Immediate 'DROP TABLE source_query_sgdb';
504: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
505: THEN
506: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

Line 510: p_encoded => FND_API.G_FALSE,

506: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
507: END IF;
508: -- Standard call to get message count and if count=1, get the message
509: FND_MSG_PUB.Count_And_Get (
510: p_encoded => FND_API.G_FALSE,
511: p_count => x_msg_count,
512: p_data => x_msg_data
513: );
514: