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.CLN_SHOWSHIP_PKG dependencies on CLN_DEBUG_PUB

Line 176: cln_debug_pub.Add('Failure point ' || x_progress, 1);

172: l_create_cln_parameter_list := wf_parameter_list_t();
173:
174: x_progress := 'CLN_SHOWSHIP_PKG.Showship_Raise_Event : 01';
175: if (l_debug_level <= 1) then
176: cln_debug_pub.Add('Failure point ' || x_progress, 1);
177: end if;
178:
179: -- Getting parameters for XML Setup Check and retrieves current time stamp date
180: OPEN c_XML_Setup;

Line 190: cln_debug_pub.Add('Failure point ' || x_progress, 1);

186: cnt := c_XML_Setup%ROWCOUNT;
187:
188: x_progress := 'CLN_SHOWSHIP_PKG.Showship_Raise_Event : 02';
189: if (l_debug_level <= 1) then
190: cln_debug_pub.Add('Failure point ' || x_progress, 1);
191: end if;
192:
193: -- only perform check if one record is returned
194: if(cnt = 1) or NOT(result) then

Line 207: cln_debug_pub.Add('Failure point ' || x_progress, 1);

203: errmsg => errmsg);
204:
205: x_progress := 'CLN_SHOWSHIP_PKG.Showship_Raise_Event : 03';
206: if (l_debug_level <= 1) then
207: cln_debug_pub.Add('Failure point ' || x_progress, 1);
208: end if;
209: else
210: -- returned more than one record
211: result := FALSE;

Line 215: cln_debug_pub.Add('Failure point ' || x_progress, 1);

211: result := FALSE;
212:
213: x_progress := 'CLN_SHOWSHIP_PKG.Showship_Raise_Event : 04';
214: if (l_debug_level <= 1) then
215: cln_debug_pub.Add('Failure point ' || x_progress, 1);
216: end if;
217: end if;
218:
219: -- Validations

Line 229: cln_debug_pub.Add('Failure point ' || x_progress, 1);

225: and wnd.status_code not in ('SR','SC','OP');
226:
227: x_progress := 'CLN_SHOWSHIP_PKG.Showship_Raise_Event : 05';
228: if (l_debug_level <= 1) then
229: cln_debug_pub.Add('Failure point ' || x_progress, 1);
230: end if;
231:
232: -- Decision on action depending on XML Setup Check and Validations
233: if (cnt = 0) or NOT(result) then

Line 237: cln_debug_pub.Add('Failure point ' || x_progress, 1);

233: if (cnt = 0) or NOT(result) then
234:
235: x_progress := 'CLN_SHOWSHIP_PKG.Showship_Raise_Event : 06';
236: if (l_debug_level <= 1) then
237: cln_debug_pub.Add('Failure point ' || x_progress, 1);
238: end if;
239:
240: else
241:

Line 244: cln_debug_pub.Add('Failure point ' || x_progress, 1);

240: else
241:
242: x_progress := 'CLN_SHOWSHIP_PKG.Showship_Raise_Event : 07';
243: if (l_debug_level <= 1) then
244: cln_debug_pub.Add('Failure point ' || x_progress, 1);
245: end if;
246:
247: -- create unique key
248: SELECT CLN_SHOWSHIP_S.nextval into l_showship_seq from dual;

Line 256: cln_debug_pub.Add('Failure point ' || x_progress, 1);

252: l_canonical_date := FND_DATE.DATE_TO_CANONICAL(l_date);
253:
254: x_progress := 'CLN_SHOWSHIP_PKG.Showship_Raise_Event : 08';
255: if (l_debug_level <= 1) then
256: cln_debug_pub.Add('Failure point ' || x_progress, 1);
257: end if;
258:
259: -- call time stamp date API to get the new time stamp date
260: WSH_ECE_VIEWS_DEF.update_del_asn_info(

Line 269: cln_debug_pub.Add('Failure point ' || x_progress, 1);

265: x_g_time_stamp_date => l_time_stamp_date_new);
266:
267: x_progress := 'CLN_SHOWSHIP_PKG.Showship_Raise_Event : 09';
268: if (l_debug_level <= 1) then
269: cln_debug_pub.Add('Failure point ' || x_progress, 1);
270: end if;
271:
272: -- add parameters to list for create collaboration event
273: wf_event.AddParameterToList(p_name => 'XMLG_INTERNAL_TXN_TYPE',

Line 306: cln_debug_pub.Add('Failure point ' || x_progress, 1);

302: p_parameterlist => l_create_cln_parameter_list);
303:
304: x_progress := 'CLN_SHOWSHIP_PKG.Showship_Raise_Event : 10';
305: if (l_debug_level <= 1) then
306: cln_debug_pub.Add('Failure point ' || x_progress, 1);
307: end if;
308:
309: -- raise create collaboration event
310: wf_event.raise(p_event_name => l_create_cln_event,

Line 316: cln_debug_pub.Add('Failure point ' || x_progress, 1);

312: p_parameters => l_create_cln_parameter_list);
313:
314: x_progress := 'CLN_SHOWSHIP_PKG.Showship_Raise_Event : 11';
315: if (l_debug_level <= 1) then
316: cln_debug_pub.Add('Failure point ' || x_progress, 1);
317: end if;
318:
319: -- add parameters to list for send show shipment document
320: wf_event.AddParameterToList(p_name => 'ECX_TRANSACTION_TYPE',

Line 386: cln_debug_pub.Add('Failure point ' || x_progress, 1);

382:
383: -- Reached Here. Successful execution.
384: x_progress := 'CLN_SHOWSHIP_PKG.Showship_Raise_Event : 12';
385: if (l_debug_level <= 1) then
386: cln_debug_pub.Add('Failure point ' || x_progress, 1);
387: end if;
388: end if;
389: EXCEPTION
390: WHEN OTHERS THEN

Line 394: cln_debug_pub.Add('Exception ' || ':' || l_error_code || ':' || l_error_msg, 1);

390: WHEN OTHERS THEN
391: l_error_code := SQLCODE;
392: l_error_msg := SQLERRM;
393: if (l_debug_level <= 1) then
394: cln_debug_pub.Add('Exception ' || ':' || l_error_code || ':' || l_error_msg, 1);
395: end if;
396:
397: x_progress := 'CLN_SHOWSHIP_PKG.Showship_Raise_Event : 13';
398: if (l_debug_level <= 1) then

Line 399: cln_debug_pub.Add('Failure point ' || x_progress, 1);

395: end if;
396:
397: x_progress := 'CLN_SHOWSHIP_PKG.Showship_Raise_Event : 13';
398: if (l_debug_level <= 1) then
399: cln_debug_pub.Add('Failure point ' || x_progress, 1);
400: end if;
401: END Showship_Raise_Event;
402:
403: END CLN_SHOWSHIP_PKG;