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.PON_CLM_CLO_UTIL_PKG dependencies on PON_CLM_CLO_UTIL_PKG

Line 1: PACKAGE BODY pon_clm_clo_util_pkg AS

1: PACKAGE BODY pon_clm_clo_util_pkg AS
2: --$Header: PONCLOUTILB.pls 120.31.12020000.3 2013/04/15 05:20:55 sgulkota ship $
3:
4: -- Forward declarations of procedures that will be used in copying a clin/slin
5: --and creating an optional line flows

Line 143: module => 'PON_CLM_CLO_UTIL_PKG.' || l_module_name,

139: x_result := FND_API.g_ret_sts_success;
140:
141: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
142: FND_LOG.string (log_level => FND_LOG.level_procedure,
143: module => 'PON_CLM_CLO_UTIL_PKG.' || l_module_name,
144: message => 'Entered procedure = ' || l_module_name ||
145: ', p_auction_header_id = ' || p_auction_header_id ||
146: ', p_line_number = ' || p_line_number);
147: END IF;

Line 169: module => 'PON_CLM_CLO_UTIL_PKG.' || l_module_name,

165: FOR cross_linked_options IN CrossLinkedOptionLines(sl_line.line_number) LOOP
166: temp :=0;
167: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
168: FND_LOG.string (log_level => FND_LOG.level_procedure,
169: module => 'PON_CLM_CLO_UTIL_PKG.' || l_module_name,
170: message => 'Inside cross_linked_options loop: Calling delete_single_line for ' || cross_linked_options.line_number);
171: END IF;
172:
173: pon_clm_clo_util_pkg.SEND_LINE_DELETED_NOTIF(p_caller=>'PON',

Line 173: pon_clm_clo_util_pkg.SEND_LINE_DELETED_NOTIF(p_caller=>'PON',

169: module => 'PON_CLM_CLO_UTIL_PKG.' || l_module_name,
170: message => 'Inside cross_linked_options loop: Calling delete_single_line for ' || cross_linked_options.line_number);
171: END IF;
172:
173: pon_clm_clo_util_pkg.SEND_LINE_DELETED_NOTIF(p_caller=>'PON',
174: p_document_id => p_auction_header_id,
175: p_document_line_id => cross_linked_options.line_number,
176: x_return_status=>l_return_status ,
177: x_msg_count=>l_msg_count,

Line 198: module => 'PON_CLM_CLO_UTIL_PKG.' || l_module_name,

194: total_lines := total_lines + temp;
195:
196: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
197: FND_LOG.string (log_level => FND_LOG.level_procedure,
198: module => 'PON_CLM_CLO_UTIL_PKG.' || l_module_name,
199: message => 'Deleted cross linked option : ' || cross_linked_options.line_number);
200: END IF;
201: END LOOP;
202: ELSE

Line 215: module => 'PON_CLM_CLO_UTIL_PKG.' || l_module_name,

211:
212: temp :=0;
213: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
214: FND_LOG.string (log_level => FND_LOG.level_procedure,
215: module => 'PON_CLM_CLO_UTIL_PKG.' || l_module_name,
216: message => 'Inside slinLines loop: Calling delete_single_line for ' || sl_line.line_number);
217: END IF;
218:
219: pon_clm_clo_util_pkg.SEND_LINE_DELETED_NOTIF(p_caller=>'PON',

Line 219: pon_clm_clo_util_pkg.SEND_LINE_DELETED_NOTIF(p_caller=>'PON',

215: module => 'PON_CLM_CLO_UTIL_PKG.' || l_module_name,
216: message => 'Inside slinLines loop: Calling delete_single_line for ' || sl_line.line_number);
217: END IF;
218:
219: pon_clm_clo_util_pkg.SEND_LINE_DELETED_NOTIF(p_caller=>'PON',
220: p_document_id => p_auction_header_id,
221: p_document_line_id => sl_line.line_number,
222: x_return_status=>l_return_status ,
223: x_msg_count=>l_msg_count,

Line 243: module => 'PON_CLM_CLO_UTIL_PKG.' || l_module_name,

239: total_lines := total_lines + temp;
240:
241: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
242: FND_LOG.string (log_level => FND_LOG.level_procedure,
243: module => 'PON_CLM_CLO_UTIL_PKG.' || l_module_name,
244: message => 'Deleted slin ' || sl_line.line_number);
245: END IF;
246: END LOOP;
247:

Line 250: module => 'PON_CLM_CLO_UTIL_PKG.' || l_module_name,

246: END LOOP;
247:
248: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
249: FND_LOG.string (log_level => FND_LOG.level_procedure,
250: module => 'PON_CLM_CLO_UTIL_PKG.' || l_module_name,
251: message => 'after slinLines loop: Calling delete_single_line for ' || op_line.line_number);
252: END IF;
253:
254: pon_clm_clo_util_pkg.SEND_LINE_DELETED_NOTIF(p_caller=>'PON',

Line 254: pon_clm_clo_util_pkg.SEND_LINE_DELETED_NOTIF(p_caller=>'PON',

250: module => 'PON_CLM_CLO_UTIL_PKG.' || l_module_name,
251: message => 'after slinLines loop: Calling delete_single_line for ' || op_line.line_number);
252: END IF;
253:
254: pon_clm_clo_util_pkg.SEND_LINE_DELETED_NOTIF(p_caller=>'PON',
255: p_document_id => p_auction_header_id,
256: p_document_line_id => op_line.line_number,
257: x_return_status=>l_return_status ,
258: x_msg_count=>l_msg_count,

Line 277: module => 'PON_CLM_CLO_UTIL_PKG.' || l_module_name,

273: x_number_of_lines_deleted => temp
274: );
275: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
276: FND_LOG.string (log_level => FND_LOG.level_procedure,
277: module => 'PON_CLM_CLO_UTIL_PKG.' || l_module_name,
278: message => 'Deleted clin/option ' || op_line.line_number);
279: END IF;
280:
281: IF ( nvl(op_line.clm_base_line_num,-1) <> -1) THEN

Line 285: module => 'PON_CLM_CLO_UTIL_PKG.' || l_module_name,

281: IF ( nvl(op_line.clm_base_line_num,-1) <> -1) THEN
282: opcount:=0;
283: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
284: FND_LOG.string (log_level => FND_LOG.level_procedure,
285: module => 'PON_CLM_CLO_UTIL_PKG.' || l_module_name,
286: message => 'Renumbering options for ' || op_line.clm_base_line_num);
287: END IF;
288:
289: FOR options IN OptionsForRenum(op_line.clm_base_line_num) LOOP

Line 306: module => 'PON_CLM_CLO_UTIL_PKG.' || l_module_name,

302:
303: total_lines := total_lines + temp;
304: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
305: FND_LOG.string (log_level => FND_LOG.level_procedure,
306: module => 'PON_CLM_CLO_UTIL_PKG.' || l_module_name,
307: message => 'total_lines ' || total_lines);
308: END IF;
309: END LOOP;
310:

Line 319: module => 'PON_CLM_CLO_UTIL_PKG.' || l_module_name,

315: */
316: IF( x_slin_flag = 'N' and x_option_flag = 'N' AND x_is_req_backed='Y') THEN
317: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
318: FND_LOG.string (log_level => FND_LOG.level_procedure,
319: module => 'PON_CLM_CLO_UTIL_PKG.' || l_module_name,
320: message => 'This is a clin.Checking previously deleted slins/options to return them to req pool ');
321: END IF;
322: FOR rec IN (SELECT requisition_line_id FROM po_requisition_lines_all prl WHERE requisition_header_id = x_req_hdr_id
323: AND (group_line_id = x_req_line_id OR clm_base_line_num = x_req_line_id)

Line 364: module => 'PON_CLM_CLO_UTIL_PKG.' || l_module_name,

360:
361: x_number_of_lines_deleted := total_lines;
362: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
363: FND_LOG.string (log_level => FND_LOG.level_procedure,
364: module => 'PON_CLM_CLO_UTIL_PKG.' || l_module_name,
365: message => 'Number of lines deleted ' || x_number_of_lines_deleted);
366: END IF;
367:
368:

Line 373: module => 'PON_CLM_CLO_UTIL_PKG.' || l_module_name,

369: EXCEPTION
370: WHEN OTHERS THEN
371: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
372: FND_LOG.string (log_level => FND_LOG.level_procedure,
373: module => 'PON_CLM_CLO_UTIL_PKG.' || l_module_name,
374: message => 'Exception' || SQLERRM );
375: END IF;
376: END delete_single_line;
377:

Line 405: module => 'PON_CLM_CLO_UTIL_PKG.' || l_module_name,

401: l_module_name := 'copy_and_create_option';
402:
403: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
404: FND_LOG.string (log_level => FND_LOG.level_procedure,
405: module => 'PON_CLM_CLO_UTIL_PKG.' || l_module_name,
406: message => 'Entered procedure = ' || l_module_name ||
407: ', p_auction_header_id = ' || p_auction_header_id ||
408: ', p_line_number = ' || p_src_line_number);
409: END IF;

Line 544: module => 'PON_CLM_CLO_UTIL_PKG.' || l_module_name,

540: l_module_name := 'copy_clin';
541:
542: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
543: FND_LOG.string (log_level => FND_LOG.level_procedure,
544: module => 'PON_CLM_CLO_UTIL_PKG.' || l_module_name,
545: message => 'Entered procedure = ' || l_module_name ||
546: ', p_auction_header_id = ' || p_auction_header_id ||
547: ', p_line_number = ' || p_src_line_number);
548: END IF;

Line 1741: module => 'PON_CLM_CLO_UTIL_PKG.' || l_module_name,

1737:
1738:
1739: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
1740: FND_LOG.string (log_level => FND_LOG.level_procedure,
1741: module => 'PON_CLM_CLO_UTIL_PKG.' || l_module_name,
1742: message => 'Entered procedure = ' || l_module_name ||
1743: ', l_slin_flag = ' || l_slin_flag ||
1744: ', l_req_num = ' || l_req_num ||
1745: ', l_option_flag = ' || l_option_flag ||

Line 1952: FND_LOG.string (log_level => FND_LOG.level_procedure, module => 'PON_CLM_CLO_UTIL_PKG.' || l_module_name, MESSAGE => 'Entered procedure = '

1948: exhibit VARCHAR2(2);
1949: BEGIN
1950: l_module_name := 'copy_clin';
1951: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
1952: FND_LOG.string (log_level => FND_LOG.level_procedure, module => 'PON_CLM_CLO_UTIL_PKG.' || l_module_name, MESSAGE => 'Entered procedure = '
1953: || l_module_name || ', p_auction_header_id = ' || p_auction_header_id );
1954: END IF;
1955: -- we will return x_max_line_number to the calling method so it will be used
1956: -- in copying subsequent lines if user had selected more than one line to copy.

Line 2441: END PON_CLM_CLO_UTIL_PKG;

2437:
2438:
2439:
2440:
2441: END PON_CLM_CLO_UTIL_PKG;