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 AMS_LISTGENERATION_PKG

Line 44: AMS_LISTGENERATION_PKG.write_to_act_log(p_msg_data => 'Canceling List Generation',

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,
47: p_level => 'HIGH');
48:

Line 58: AMS_LISTGENERATION_PKG.write_to_act_log(p_msg_data => 'In cancel List gen, Status code: '|| l_status_code,

54: open get_status_code(p_list_header_id);
55: fetch get_status_code into l_status_code;
56: close get_status_code;
57:
58: AMS_LISTGENERATION_PKG.write_to_act_log(p_msg_data => 'In cancel List gen, Status code: '|| l_status_code,
59: p_arc_log_used_by => 'LIST',
60: p_log_used_by_id => p_list_header_id,
61: p_level => 'HIGH');
62:

Line 71: AMS_LISTGENERATION_PKG.write_to_act_log(p_msg_data => 'Before delete in Cancel List Gen'|| l_status_code,

67:
68: /* for now calling delete procedure in the Generation package because this
69: is what is needed here. Later that Procedure can be migrated here. */
70:
71: AMS_LISTGENERATION_PKG.write_to_act_log(p_msg_data => 'Before delete in Cancel List Gen'|| l_status_code,
72: p_arc_log_used_by => 'LIST',
73: p_log_used_by_id => p_list_header_id,
74: p_level => 'LOW');
75:

Line 78: AMS_LISTGENERATION_PKG.write_to_act_log(p_msg_data => 'After delete in Cancel List Gen'|| l_status_code,

74: p_level => 'LOW');
75:
76: delete_list_entries(p_list_header_id, x_msg_count, x_msg_data, x_return_status);
77:
78: AMS_LISTGENERATION_PKG.write_to_act_log(p_msg_data => 'After delete in Cancel List Gen'|| l_status_code,
79: p_arc_log_used_by => 'LIST',
80: p_log_used_by_id => p_list_header_id,
81: p_level => 'HIGH');
82:

Line 84: AMS_LISTGENERATION_PKG.write_to_act_log('Error while executing delete_list_entries. Unable to delete entries.', 'LIST', p_list_header_id,'HIGH');

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:
88: AMS_LISTGENERATION_PKG.write_to_act_log(p_msg_data => 'Updating list header info '|| l_status_code,

Line 88: AMS_LISTGENERATION_PKG.write_to_act_log(p_msg_data => 'Updating list header info '|| l_status_code,

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',
90: p_log_used_by_id => p_list_header_id,
91: p_level => 'LOW');
92:

Line 95: AMS_LISTGENERATION_PKG.write_to_act_log(p_msg_data => 'List header info updated '|| l_status_code,

91: p_level => 'LOW');
92:
93: Update_List_Header (p_list_header_id, x_return_status);
94:
95: AMS_LISTGENERATION_PKG.write_to_act_log(p_msg_data => 'List header info updated '|| l_status_code,
96: p_arc_log_used_by => 'LIST',
97: p_log_used_by_id => p_list_header_id,
98: p_level => 'LOW');
99:

Line 101: AMS_LISTGENERATION_PKG.write_to_act_log('Error while executing UpdateListHeader. Unable to update List header.', 'LIST', p_list_header_id,'HIGH');

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;
105:

Line 110: AMS_LISTGENERATION_PKG.write_to_act_log(p_msg_data => 'Cancel List Gen: Status code is not FAILED so exiting. Status code is '||x_return_Status,

106: Raise cancelexcep;
107:
108: else
109:
110: AMS_LISTGENERATION_PKG.write_to_act_log(p_msg_data => 'Cancel List Gen: Status code is not FAILED so exiting. Status code is '||x_return_Status,
111: p_arc_log_used_by => 'LIST',
112: p_log_used_by_id => p_list_header_id,
113: p_level => 'LOW');
114:

Line 121: AMS_LISTGENERATION_PKG.write_to_act_log('Error while executing procedure cancel_list_gen '||sqlcode||' '||sqlerrm, 'LIST', p_list_header_id,'HIGH');

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,
125: p_count => x_msg_count,

Line 133: AMS_LISTGENERATION_PKG.write_to_act_log('In procedure cancel_list_gen: User termination detected '||sqlcode||' '||sqlerrm, 'LIST', p_list_header_id, 'HIGH');

129:
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

Line 138: AMS_LISTGENERATION_PKG.write_to_act_log('Error while executing procedure cancel_list_gen '||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');
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);

Line 166: AMS_LISTGENERATION_PKG.write_to_act_log('Executing delete_list_entries in listcancelgen.', 'LIST', p_list_header_id,'LOW');

162: l_gen_type VARCHAR2(20);
163:
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'

Line 181: AMS_LISTGENERATION_PKG.write_to_act_log(sql%rowcount||' entries deleted from ams_list_entries in local instance.', 'LIST', p_list_header_id,'LOW');

177:
178: DELETE FROM ams_list_entries
179: WHERE list_header_id = p_list_header_id;
180:
181: AMS_LISTGENERATION_PKG.write_to_act_log(sql%rowcount||' entries deleted from ams_list_entries in local instance.', 'LIST', p_list_header_id,'LOW');
182:
183: If g_remote_gen = 'Y' -- based on remote DS so delete remotely
184: then
185: AMS_LISTGENERATION_PKG.write_to_act_log('Calling remote procedure with process type as DELETE_LIST_ENTRIES to delete entries in remote instance', 'LIST', p_list_header_id,'LOW');

Line 185: AMS_LISTGENERATION_PKG.write_to_act_log('Calling remote procedure with process type as DELETE_LIST_ENTRIES to delete entries in remote instance', 'LIST', p_list_header_id,'LOW');

181: AMS_LISTGENERATION_PKG.write_to_act_log(sql%rowcount||' entries deleted from ams_list_entries in local instance.', 'LIST', p_list_header_id,'LOW');
182:
183: If g_remote_gen = 'Y' -- based on remote DS so delete remotely
184: then
185: AMS_LISTGENERATION_PKG.write_to_act_log('Calling remote procedure with process type as DELETE_LIST_ENTRIES to delete entries in remote instance', 'LIST', p_list_header_id,'LOW');
186: execute immediate
187: 'BEGIN AMS_Remote_ListGen_PKG.remote_list_gen'||'@'||g_database_link||'(:1,:2,:3,:4,:5,:6,:7,:8,:9,:10,:11,:12)'||';'||
188: ' END;'
189: using '1',

Line 202: AMS_LISTGENERATION_PKG.write_to_act_log('Error in executing remote procedure', 'LIST', p_list_header_id,'HIGH');

198: l_null,
199: OUT l_total_recs,
200: 'DELETE_LIST_ENTRIES';
201: if nvl(x_return_status,'S') in ('E','U') then -- resulted in error.
202: AMS_LISTGENERATION_PKG.write_to_act_log('Error in executing remote procedure', 'LIST', p_list_header_id,'HIGH');
203: AMS_LISTGENERATION_PKG.write_to_act_log('Error '||x_msg_data , 'LIST', p_list_header_id,'HIGH');
204: else
205: AMS_LISTGENERATION_PKG.write_to_act_log('Entries deleted succesfully in remote instance','LIST', p_list_header_id,'LOW');
206: end if;

Line 203: AMS_LISTGENERATION_PKG.write_to_act_log('Error '||x_msg_data , 'LIST', p_list_header_id,'HIGH');

199: OUT l_total_recs,
200: 'DELETE_LIST_ENTRIES';
201: if nvl(x_return_status,'S') in ('E','U') then -- resulted in error.
202: AMS_LISTGENERATION_PKG.write_to_act_log('Error in executing remote procedure', 'LIST', p_list_header_id,'HIGH');
203: AMS_LISTGENERATION_PKG.write_to_act_log('Error '||x_msg_data , 'LIST', p_list_header_id,'HIGH');
204: else
205: AMS_LISTGENERATION_PKG.write_to_act_log('Entries deleted succesfully in remote instance','LIST', p_list_header_id,'LOW');
206: end if;
207: end if; --g_remote_gen = 'Y'

Line 205: AMS_LISTGENERATION_PKG.write_to_act_log('Entries deleted succesfully in remote instance','LIST', p_list_header_id,'LOW');

201: if nvl(x_return_status,'S') in ('E','U') then -- resulted in error.
202: AMS_LISTGENERATION_PKG.write_to_act_log('Error in executing remote procedure', 'LIST', p_list_header_id,'HIGH');
203: AMS_LISTGENERATION_PKG.write_to_act_log('Error '||x_msg_data , 'LIST', p_list_header_id,'HIGH');
204: else
205: AMS_LISTGENERATION_PKG.write_to_act_log('Entries deleted succesfully in remote instance','LIST', p_list_header_id,'LOW');
206: end if;
207: end if; --g_remote_gen = 'Y'
208: End if; -- STANDARD
209:

Line 210: AMS_LISTGENERATION_PKG.write_to_act_log('Deleting entries from list src type usages tables.', 'LIST', p_list_header_id,'LOW');

206: end if;
207: end if; --g_remote_gen = 'Y'
208: End if; -- STANDARD
209:
210: AMS_LISTGENERATION_PKG.write_to_act_log('Deleting entries from list src type usages tables.', 'LIST', p_list_header_id,'LOW');
211:
212: DELETE FROM ams_list_src_type_usages
213: WHERE list_header_id = p_list_header_id;
214:

Line 215: AMS_LISTGENERATION_PKG.write_to_act_log('Procedure delete_list_entries executed successfully.', 'LIST', p_list_header_id,'LOW');

211:
212: DELETE FROM ams_list_src_type_usages
213: WHERE list_header_id = p_list_header_id;
214:
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;

Line 220: AMS_LISTGENERATION_PKG.write_to_act_log(p_msg_data => 'Error Deleting in CancelListGen',

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');
224: FND_MESSAGE.set_name('AMS', 'AMS_API_DEBUG_MESSAGE');

Line 268: AMS_LISTGENERATION_PKG.write_to_act_log('Error while executing procedure Update_list_header '||sqlcode||' '||sqlerrm, 'LIST', p_list_header_id,'HIGH');

264:
265: Exception
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

Line 314: AMS_LISTGENERATION_PKG.write_to_act_log('Error getting ItemStatus. ItemKey = '||l_item_key||' and Status = '|| l_status,'LIST', p_list_header_id, 'HIGH');

310: return l_status;
311:
312: Exception
313: When others then
314: AMS_LISTGENERATION_PKG.write_to_act_log('Error getting ItemStatus. ItemKey = '||l_item_key||' and Status = '|| l_status,'LIST', p_list_header_id, 'HIGH');
315:
316: End getWFItemStatus;
317:
318: Function isListCancelling(p_list_header_id in Number) return VARCHAR2

Line 337: AMS_LISTGENERATION_PKG.write_to_act_log('Error getting status code = '|| l_status_code, 'LIST', p_list_header_id, 'HIGH');

333:
334: Exception
335:
336: When others then
337: AMS_LISTGENERATION_PKG.write_to_act_log('Error getting status code = '|| l_status_code, 'LIST', p_list_header_id, 'HIGH');
338: return 'N';
339: End isListCancelling;
340:
341: PROCEDURE START_CTRL_GRP_PROCESS