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

Line 42: x_return_status := FND_API.G_RET_STS_SUCCESS;

38: Begin
39:
40: l_error_position := '<- Start Cancel List Generation ->';
41:
42: x_return_status := FND_API.G_RET_STS_SUCCESS;
43:
44: AMS_LISTGENERATION_PKG.write_to_act_log(p_msg_data => 'Canceling List Generation',
45: p_arc_log_used_by => 'LIST',
46: p_log_used_by_id => p_list_header_id,

Line 83: if x_return_status <> FND_API.g_ret_sts_success then

79: p_arc_log_used_by => 'LIST',
80: p_log_used_by_id => p_list_header_id,
81: p_level => 'HIGH');
82:
83: if x_return_status <> FND_API.g_ret_sts_success then
84: AMS_LISTGENERATION_PKG.write_to_act_log('Error while executing delete_list_entries. Unable to delete entries.', 'LIST', p_list_header_id,'HIGH');
85: -- raise FND_API.g_exc_unexpected_error;
86: end if;
87:

Line 85: -- raise FND_API.g_exc_unexpected_error;

81: p_level => 'HIGH');
82:
83: if x_return_status <> FND_API.g_ret_sts_success then
84: AMS_LISTGENERATION_PKG.write_to_act_log('Error while executing delete_list_entries. Unable to delete entries.', 'LIST', p_list_header_id,'HIGH');
85: -- raise FND_API.g_exc_unexpected_error;
86: end if;
87:
88: AMS_LISTGENERATION_PKG.write_to_act_log(p_msg_data => 'Updating list header info '|| l_status_code,
89: p_arc_log_used_by => 'LIST',

Line 100: if x_return_status <> FND_API.g_ret_sts_success then

96: p_arc_log_used_by => 'LIST',
97: p_log_used_by_id => p_list_header_id,
98: p_level => 'LOW');
99:
100: if x_return_status <> FND_API.g_ret_sts_success then
101: AMS_LISTGENERATION_PKG.write_to_act_log('Error while executing UpdateListHeader. Unable to update List header.', 'LIST', p_list_header_id,'HIGH');
102: end if;
103:
104: Commit;

Line 120: WHEN FND_API.g_exc_unexpected_error THEN

116: end if;
117:
118: Exception
119: /*
120: WHEN FND_API.g_exc_unexpected_error THEN
121: AMS_LISTGENERATION_PKG.write_to_act_log('Error while executing procedure cancel_list_gen '||sqlcode||' '||sqlerrm, 'LIST', p_list_header_id,'HIGH');
122: x_return_status := FND_API.g_ret_sts_unexp_error ;
123: FND_MSG_PUB.count_and_get(
124: p_encoded => FND_API.g_false,

Line 122: x_return_status := FND_API.g_ret_sts_unexp_error ;

118: Exception
119: /*
120: WHEN FND_API.g_exc_unexpected_error THEN
121: AMS_LISTGENERATION_PKG.write_to_act_log('Error while executing procedure cancel_list_gen '||sqlcode||' '||sqlerrm, 'LIST', p_list_header_id,'HIGH');
122: x_return_status := FND_API.g_ret_sts_unexp_error ;
123: FND_MSG_PUB.count_and_get(
124: p_encoded => FND_API.g_false,
125: p_count => x_msg_count,
126: p_data => x_msg_data

Line 124: p_encoded => FND_API.g_false,

120: WHEN FND_API.g_exc_unexpected_error THEN
121: AMS_LISTGENERATION_PKG.write_to_act_log('Error while executing procedure cancel_list_gen '||sqlcode||' '||sqlerrm, 'LIST', p_list_header_id,'HIGH');
122: x_return_status := FND_API.g_ret_sts_unexp_error ;
123: FND_MSG_PUB.count_and_get(
124: p_encoded => FND_API.g_false,
125: p_count => x_msg_count,
126: p_data => x_msg_data
127: );
128: */

Line 134: x_return_status := FND_API.g_ret_sts_unexp_error ;

130: --WHEN cancelListGen then
131: WHEN cancelexcep then
132:
133: AMS_LISTGENERATION_PKG.write_to_act_log('In procedure cancel_list_gen: User termination detected '||sqlcode||' '||sqlerrm, 'LIST', p_list_header_id, 'HIGH');
134: x_return_status := FND_API.g_ret_sts_unexp_error ;
135: Raise cancelListGen;
136:
137: WHEN OTHERS THEN
138: AMS_LISTGENERATION_PKG.write_to_act_log('Error while executing procedure cancel_list_gen '||sqlcode||' '||sqlerrm, 'LIST', p_list_header_id, 'HIGH');

Line 139: x_return_status := FND_API.g_ret_sts_unexp_error ;

135: Raise cancelListGen;
136:
137: WHEN OTHERS THEN
138: AMS_LISTGENERATION_PKG.write_to_act_log('Error while executing procedure cancel_list_gen '||sqlcode||' '||sqlerrm, 'LIST', p_list_header_id, 'HIGH');
139: x_return_status := FND_API.g_ret_sts_unexp_error ;
140:
141: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
142: FND_MSG_PUB.add_exc_msg(g_pkg_name, g_file_name);
143: END IF;

Line 146: p_encoded => FND_API.g_false,

142: FND_MSG_PUB.add_exc_msg(g_pkg_name, g_file_name);
143: END IF;
144:
145: FND_MSG_PUB.count_and_get(
146: p_encoded => FND_API.g_false,
147: p_count => x_msg_count,
148: p_data => x_msg_data
149: );
150:

Line 168: x_return_status := FND_API.G_RET_STS_SUCCESS;

164: Begin
165:
166: AMS_LISTGENERATION_PKG.write_to_act_log('Executing delete_list_entries in listcancelgen.', 'LIST', p_list_header_id,'LOW');
167:
168: x_return_status := FND_API.G_RET_STS_SUCCESS;
169:
170: -- If p_listheader_rec.list_type = 'TARGET'
171: select generation_type into l_gen_type
172: from ams_list_headers_all

Line 219: x_return_status := FND_API.G_RET_STS_ERROR;

215: AMS_LISTGENERATION_PKG.write_to_act_log('Procedure delete_list_entries executed successfully.', 'LIST', p_list_header_id,'LOW');
216:
217: EXCEPTION
218: WHEN OTHERS THEN
219: x_return_status := FND_API.G_RET_STS_ERROR;
220: AMS_LISTGENERATION_PKG.write_to_act_log(p_msg_data => 'Error Deleting in CancelListGen',
221: p_arc_log_used_by => 'LIST',
222: p_log_used_by_id => p_list_header_id,
223: p_level => 'HIGH');

Line 237: x_return_status := FND_API.G_RET_STS_SUCCESS;

233: x_return_status OUT NOCOPY VARCHAR2)
234: AS
235: Begin
236:
237: x_return_status := FND_API.G_RET_STS_SUCCESS;
238:
239: /*
240: If g_remote_gen = 'Y'
241: Currently, I don't see the remote list header table getting updated.

Line 270: x_return_status := FND_API.g_ret_sts_unexp_error ;

266: When Others then
267:
268: AMS_LISTGENERATION_PKG.write_to_act_log('Error while executing procedure Update_list_header '||sqlcode||' '||sqlerrm, 'LIST', p_list_header_id,'HIGH');
269:
270: x_return_status := FND_API.g_ret_sts_unexp_error ;
271:
272: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
273: FND_MSG_PUB.add_exc_msg(g_pkg_name, g_file_name);
274: END IF;

Line 277: p_encoded => FND_API.g_false,

273: FND_MSG_PUB.add_exc_msg(g_pkg_name, g_file_name);
274: END IF;
275: /*
276: FND_MSG_PUB.count_and_get(
277: p_encoded => FND_API.g_false,
278: p_count => x_msg_count,
279: p_data => x_msg_data
280: );
281: */

Line 375: x_return_status := FND_API.G_RET_STS_SUCCESS;

371: x_msg_data1 varchar2(200);
372:
373: BEGIN
374: -- Initialize API return status to SUCCESS
375: x_return_status := FND_API.G_RET_STS_SUCCESS;
376: open c_list_header_info;
377: fetch c_list_header_info into l_list_header_info_rec;
378: close c_list_header_info;
379:

Line 433: --x_return_status := FND_API.G_RET_STS_SUCCESS;

429: l_status_code varchar2(100);
430:
431: BEGIN
432: -- Initialize API return status to SUCCESS
433: --x_return_status := FND_API.G_RET_STS_SUCCESS;
434:
435: open c1;
436: fetch c1 into l_request_id,l_status_code_old,l_status_code;
437: close c1;