DBA Data[Home] [Help]

APPS.CSE_IPA_TRANS_PKG dependencies on CSE_UTIL_PKG

Line 280: cse_util_pkg.get_concat_segments(

276: END IF;
277:
278: debug(' asset_category_id : '||l_asset_category_id);
279:
280: cse_util_pkg.get_concat_segments(
281: p_short_name => 'OFA',
282: p_flex_code => 'CAT#',
283: p_combination_id => l_asset_category_id,
284: x_concat_segments => l_con_asset_category,

Line 314: cse_util_pkg.get_combine_segments(

310: fnd_msg_pub.add;
311: END;
312:
313: -- removes the delimiter
314: cse_util_pkg.get_combine_segments(
315: p_short_name => 'OFA',
316: p_flex_code => 'CAT#',
317: p_concat_segments => l_con_asset_category,
318: x_combine_segments => l_asset_category,

Line 332: x_error_message := nvl(l_error_message, cse_util_pkg.dump_error_stack);

328:
329: EXCEPTION
330:
331: WHEN fnd_api.g_exc_error THEN
332: x_error_message := nvl(l_error_message, cse_util_pkg.dump_error_stack);
333: x_return_status := l_return_status;
334:
335: WHEN OTHERS THEN
336: fnd_message.set_name('CSE','CSE_OTHERS_EXCEPTION');

Line 339: x_error_message := cse_util_pkg.dump_error_stack;

335: WHEN OTHERS THEN
336: fnd_message.set_name('CSE','CSE_OTHERS_EXCEPTION');
337: fnd_message.set_token('ERR_MSG', sqlerrm);
338: fnd_msg_pub.add;
339: x_error_message := cse_util_pkg.dump_error_stack;
340: x_return_status := fnd_api.g_ret_sts_unexp_error;
341: END get_fa_asset_category;
342:
343: PROCEDURE get_fa_location_segment (

Line 378: cse_util_pkg.get_concat_segments(

374: l_location_id:=p_fa_location_id ;
375: END IF;
376:
377: --get the concatenated segments from fa_location_id
378: cse_util_pkg.get_concat_segments(
379: p_short_name => 'OFA',
380: p_flex_code => 'LOC#',
381: p_combination_id => l_location_id,
382: X_concat_segments => l_con_fa_location,

Line 393: CSE_UTIL_PKG.get_combine_segments(

389:
390: debug(' location_segment : '||l_con_fa_location);
391:
392: -- remove the delimeter
393: CSE_UTIL_PKG.get_combine_segments(
394: p_short_name => 'OFA',
395: p_flex_code => 'LOC#',
396: p_concat_segments => l_con_fa_location,
397: x_combine_segments=> x_fa_location,

Line 577: l_error_message := cse_util_pkg.dump_error_stack;

573: WHEN no_data_found THEN
574: fnd_message.set_name('CSE', 'CSE_CRL_GRP_NOT_FOUND');
575: fnd_message.set_token('ORG_ID', p_org_id);
576: fnd_msg_pub.add;
577: l_error_message := cse_util_pkg.dump_error_stack;
578: RAISE fnd_api.g_exc_error;
579: END;
580:
581: EXCEPTION