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

Line 53: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN

49: , x_data => l_data
50: , x_count => l_count
51: , x_return_code => l_return_status);
52:
53: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
54: RAISE FND_API.G_EXC_ERROR;
55: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
56: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
57: END IF;

Line 54: RAISE FND_API.G_EXC_ERROR;

50: , x_count => l_count
51: , x_return_code => l_return_status);
52:
53: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
54: RAISE FND_API.G_EXC_ERROR;
55: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
56: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
57: END IF;
58:

Line 55: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

51: , x_return_code => l_return_status);
52:
53: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
54: RAISE FND_API.G_EXC_ERROR;
55: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
56: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
57: END IF;
58:
59: -- Standard call to check for call compatibility

Line 56: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

52:
53: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
54: RAISE FND_API.G_EXC_ERROR;
55: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
56: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
57: END IF;
58:
59: -- Standard call to check for call compatibility
60: IF NOT fnd_api.compatible_api_call( l_api_version

Line 60: IF NOT fnd_api.compatible_api_call( l_api_version

56: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
57: END IF;
58:
59: -- Standard call to check for call compatibility
60: IF NOT fnd_api.compatible_api_call( l_api_version
61: , p_api_version
62: , l_api_name
63: , g_pkg_name) THEN
64: RAISE fnd_api.g_exc_unexpected_error;

Line 64: RAISE fnd_api.g_exc_unexpected_error;

60: IF NOT fnd_api.compatible_api_call( l_api_version
61: , p_api_version
62: , l_api_name
63: , g_pkg_name) THEN
64: RAISE fnd_api.g_exc_unexpected_error;
65: END IF;
66:
67: -- Initialize message list if p_init_msg_list is set to TRUE
68: IF fnd_api.to_boolean(p_init_msg_list) THEN

Line 68: IF fnd_api.to_boolean(p_init_msg_list) THEN

64: RAISE fnd_api.g_exc_unexpected_error;
65: END IF;
66:
67: -- Initialize message list if p_init_msg_list is set to TRUE
68: IF fnd_api.to_boolean(p_init_msg_list) THEN
69: fnd_msg_pub.initialize;
70: END IF;
71:
72: -- Initialize API return status to success

Line 73: x_return_status := fnd_api.g_ret_sts_success;

69: fnd_msg_pub.initialize;
70: END IF;
71:
72: -- Initialize API return status to success
73: x_return_status := fnd_api.g_ret_sts_success;
74:
75: --
76: -- Validate user and login session IDs
77: --

Line 80: RAISE fnd_api.g_exc_error;

76: -- Validate user and login session IDs
77: --
78: IF (p_user_id IS NULL) THEN
79: iec_rlctrl_util_pvt.add_null_parameter_msg(l_api_name_full, 'p_user_id');
80: RAISE fnd_api.g_exc_error;
81: ELSE
82: iec_rlctrl_util_pvt.validate_who_info ( p_api_name => l_api_name_full
83: , p_parameter_name_usr => 'p_user_id'
84: , p_parameter_name_log => 'p_login_id'

Line 88: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN

84: , p_parameter_name_log => 'p_login_id'
85: , p_user_id => p_user_id
86: , p_login_id => p_login_id
87: , x_return_status => l_return_status);
88: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
89: RAISE fnd_api.g_exc_error;
90: END IF;
91: END IF;
92:

Line 89: RAISE fnd_api.g_exc_error;

85: , p_user_id => p_user_id
86: , p_login_id => p_login_id
87: , x_return_status => l_return_status);
88: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
89: RAISE fnd_api.g_exc_error;
90: END IF;
91: END IF;
92:
93: ---------------------------------------------------------------------

Line 110: l_return_status := FND_API.G_RET_STS_SUCCESS;

106: update iec_g_mktg_item_cc_tzs set record_count = nvl(RECORD_COUNT,0)- 1,
107: last_update_date = sysdate
108: where itm_cc_tz_id = l_itm_cc_tz_id;
109:
110: l_return_status := FND_API.G_RET_STS_SUCCESS;
111:
112: EXCEPTION
113: WHEN NO_DATA_FOUND THEN
114: l_return_status:= FND_API.G_RET_STS_ERROR;

Line 114: l_return_status:= FND_API.G_RET_STS_ERROR;

110: l_return_status := FND_API.G_RET_STS_SUCCESS;
111:
112: EXCEPTION
113: WHEN NO_DATA_FOUND THEN
114: l_return_status:= FND_API.G_RET_STS_ERROR;
115: WHEN OTHERS THEN
116: l_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
117: END;
118:

Line 116: l_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;

112: EXCEPTION
113: WHEN NO_DATA_FOUND THEN
114: l_return_status:= FND_API.G_RET_STS_ERROR;
115: WHEN OTHERS THEN
116: l_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
117: END;
118:
119: IF (l_return_status= FND_API.G_RET_STS_ERROR) THEN
120: RAISE FND_API.G_EXC_ERROR;

Line 119: IF (l_return_status= FND_API.G_RET_STS_ERROR) THEN

115: WHEN OTHERS THEN
116: l_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
117: END;
118:
119: IF (l_return_status= FND_API.G_RET_STS_ERROR) THEN
120: RAISE FND_API.G_EXC_ERROR;
121: ELSIF (l_return_status= FND_API.G_RET_STS_UNEXP_ERROR) THEN
122: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
123: END IF;

Line 120: RAISE FND_API.G_EXC_ERROR;

116: l_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
117: END;
118:
119: IF (l_return_status= FND_API.G_RET_STS_ERROR) THEN
120: RAISE FND_API.G_EXC_ERROR;
121: ELSIF (l_return_status= FND_API.G_RET_STS_UNEXP_ERROR) THEN
122: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
123: END IF;
124:

Line 121: ELSIF (l_return_status= FND_API.G_RET_STS_UNEXP_ERROR) THEN

117: END;
118:
119: IF (l_return_status= FND_API.G_RET_STS_ERROR) THEN
120: RAISE FND_API.G_EXC_ERROR;
121: ELSIF (l_return_status= FND_API.G_RET_STS_UNEXP_ERROR) THEN
122: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
123: END IF;
124:
125: ---------------------------------------------------------------------

Line 122: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

118:
119: IF (l_return_status= FND_API.G_RET_STS_ERROR) THEN
120: RAISE FND_API.G_EXC_ERROR;
121: ELSIF (l_return_status= FND_API.G_RET_STS_UNEXP_ERROR) THEN
122: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
123: END IF;
124:
125: ---------------------------------------------------------------------
126:

Line 137: IF (l_return_status= FND_API.G_RET_STS_ERROR) THEN

133: , x_count => l_count
134: , x_return_code => l_return_status);
135:
136:
137: IF (l_return_status= FND_API.G_RET_STS_ERROR) THEN
138: RAISE FND_API.G_EXC_ERROR;
139: ELSIF (l_return_status= FND_API.G_RET_STS_UNEXP_ERROR) THEN
140: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
141: END IF;

Line 138: RAISE FND_API.G_EXC_ERROR;

134: , x_return_code => l_return_status);
135:
136:
137: IF (l_return_status= FND_API.G_RET_STS_ERROR) THEN
138: RAISE FND_API.G_EXC_ERROR;
139: ELSIF (l_return_status= FND_API.G_RET_STS_UNEXP_ERROR) THEN
140: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
141: END IF;
142:

Line 139: ELSIF (l_return_status= FND_API.G_RET_STS_UNEXP_ERROR) THEN

135:
136:
137: IF (l_return_status= FND_API.G_RET_STS_ERROR) THEN
138: RAISE FND_API.G_EXC_ERROR;
139: ELSIF (l_return_status= FND_API.G_RET_STS_UNEXP_ERROR) THEN
140: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
141: END IF;
142:
143: IF fnd_api.to_boolean(p_commit) THEN

Line 140: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

136:
137: IF (l_return_status= FND_API.G_RET_STS_ERROR) THEN
138: RAISE FND_API.G_EXC_ERROR;
139: ELSIF (l_return_status= FND_API.G_RET_STS_UNEXP_ERROR) THEN
140: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
141: END IF;
142:
143: IF fnd_api.to_boolean(p_commit) THEN
144: COMMIT WORK;

Line 143: IF fnd_api.to_boolean(p_commit) THEN

139: ELSIF (l_return_status= FND_API.G_RET_STS_UNEXP_ERROR) THEN
140: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
141: END IF;
142:
143: IF fnd_api.to_boolean(p_commit) THEN
144: COMMIT WORK;
145: END IF;
146:
147: -- Standard call to get message count and if count is 1, get message info

Line 152: WHEN fnd_api.g_exc_error THEN

148: fnd_msg_pub.count_and_get( p_count => x_msg_count
149: , p_data => x_msg_data );
150:
151: EXCEPTION
152: WHEN fnd_api.g_exc_error THEN
153: ROLLBACK TO set_record_donotuse_pub;
154: x_return_status := fnd_api.g_ret_sts_error;
155: fnd_msg_pub.count_and_get( p_count => x_msg_count
156: , p_data => x_msg_data );

Line 154: x_return_status := fnd_api.g_ret_sts_error;

150:
151: EXCEPTION
152: WHEN fnd_api.g_exc_error THEN
153: ROLLBACK TO set_record_donotuse_pub;
154: x_return_status := fnd_api.g_ret_sts_error;
155: fnd_msg_pub.count_and_get( p_count => x_msg_count
156: , p_data => x_msg_data );
157: WHEN fnd_api.g_exc_unexpected_error THEN
158: ROLLBACK TO set_record_donotuse_pub;

Line 157: WHEN fnd_api.g_exc_unexpected_error THEN

153: ROLLBACK TO set_record_donotuse_pub;
154: x_return_status := fnd_api.g_ret_sts_error;
155: fnd_msg_pub.count_and_get( p_count => x_msg_count
156: , p_data => x_msg_data );
157: WHEN fnd_api.g_exc_unexpected_error THEN
158: ROLLBACK TO set_record_donotuse_pub;
159: x_return_status := fnd_api.g_ret_sts_unexp_error;
160: fnd_msg_pub.count_and_get( p_count => x_msg_count
161: , p_data => x_msg_data );

Line 159: x_return_status := fnd_api.g_ret_sts_unexp_error;

155: fnd_msg_pub.count_and_get( p_count => x_msg_count
156: , p_data => x_msg_data );
157: WHEN fnd_api.g_exc_unexpected_error THEN
158: ROLLBACK TO set_record_donotuse_pub;
159: x_return_status := fnd_api.g_ret_sts_unexp_error;
160: fnd_msg_pub.count_and_get( p_count => x_msg_count
161: , p_data => x_msg_data );
162: WHEN OTHERS THEN
163: ROLLBACK TO set_record_donotuse_pub;

Line 164: x_return_status := fnd_api.g_ret_sts_unexp_error;

160: fnd_msg_pub.count_and_get( p_count => x_msg_count
161: , p_data => x_msg_data );
162: WHEN OTHERS THEN
163: ROLLBACK TO set_record_donotuse_pub;
164: x_return_status := fnd_api.g_ret_sts_unexp_error;
165: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
166: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
167: END IF;
168: fnd_msg_pub.count_and_get( p_count => x_msg_count