DBA Data[Home] [Help]

APPS.FA_ASSET_HIERARCHY_PVT dependencies on FA_ASSET_HIERARCHY_PVT

Line 1: PACKAGE BODY FA_ASSET_HIERARCHY_PVT as

1: PACKAGE BODY FA_ASSET_HIERARCHY_PVT as
2: /* $Header: FAVAHRB.pls 120.2 2004/01/08 17:04:00 dfred noship $ */
3:
4:
5: FUNCTION validate_parent ( p_parent_hierarchy_id in number,

Line 27: calling_fn => 'FA_ASSET_HIERARCHY_PVT.validate_parent',

23: close C1;
24:
25: if l_purpose_book is null then
26: fa_srvr_msg.add_message(
27: calling_fn => 'FA_ASSET_HIERARCHY_PVT.validate_parent',
28: name => 'CUA_INVALID_PARENT' );
29: return FALSE;
30: end if;
31:

Line 34: calling_fn => 'FA_ASSET_HIERARCHY_PVT.validate_parent',

30: end if;
31:
32: if l_purpose_book <> p_book_type_code then
33: fa_srvr_msg.add_message(
34: calling_fn => 'FA_ASSET_HIERARCHY_PVT.validate_parent',
35: name => 'CUA_INVALID_PARENT_BOOK_TYPE' );
36: return FALSE;
37: end if;
38:

Line 69: calling_fn => 'fa_asset_hierarchy_pvt.add_asset',

65: -- validate the required_parameters
66: if ( p_asset_hdr_rec.asset_id is null OR
67: p_asset_hierarchy_rec.parent_hierarchy_id is null ) then
68: fa_srvr_msg.add_message(
69: calling_fn => 'fa_asset_hierarchy_pvt.add_asset',
70: name => 'FA_SHARED_ITEM_NULL' );
71: return FALSE;
72: end if;
73:

Line 76: if not FA_ASSET_HIERARCHY_PVT.validate_parent(

72: end if;
73:
74: /*
75: -- check the parent is a valid
76: if not FA_ASSET_HIERARCHY_PVT.validate_parent(
77: p_asset_hierarchy_rec.parent_hierarchy_id,
78: p_asset_hdr_rec.book_type_code ) then
79: return FALSE;
80: end if;

Line 105: calling_fn => 'fa_asset_hierarchy_pvt.add_asset',

101: x_err_stage => l_err_stage,
102: x_err_stack => l_err_stack);
103: if l_err_code <> '0' then
104: fa_srvr_msg.add_message(
105: calling_fn => 'fa_asset_hierarchy_pvt.add_asset',
106: name => l_err_code );
107: return FALSE;
108: end if;
109:

Line 115: calling_fn => 'fa_asset_hierarchy_pvt.add_asset');

111: EXCEPTION
112: when others then
113: rollback;
114: fa_srvr_msg.add_sql_error(
115: calling_fn => 'fa_asset_hierarchy_pvt.add_asset');
116: return FALSE;
117: END;
118:
119: -----------------------------------

Line 159: calling_fn => 'fa_asset_hierarchy_pvt.load_distributions');

155: return TRUE;
156: EXCEPTION
157: when others then
158: fa_srvr_msg.add_sql_error(
159: calling_fn => 'fa_asset_hierarchy_pvt.load_distributions');
160: return FALSE;
161:
162:
163: END load_distributions;

Line 311: calling_fn => 'fa_asset_hierarchy_pvt.derive_asset_attribute',

307:
308: EXCEPTION
309: when inherit_error then
310: fa_srvr_msg.add_message(
311: calling_fn => 'fa_asset_hierarchy_pvt.derive_asset_attribute',
312: name => 'CUA_MAP_DATES');
313: return FALSE;
314:
315: when daa_error then

Line 317: calling_fn => 'fa_asset_hierarchy_pvt.derive_asset_attribute',

313: return FALSE;
314:
315: when daa_error then
316: fa_srvr_msg.add_message(
317: calling_fn => 'fa_asset_hierarchy_pvt.derive_asset_attribute',
318: name => l_err_code );
319: return FALSE;
320:
321: when rej_error then

Line 324: calling_fn => 'fa_asset_hierarchy_pvt.derive_asset_attribute',

320:
321: when rej_error then
322: if l_cat_RF = 'Y' then
323: fa_srvr_msg.add_message(
324: calling_fn => 'fa_asset_hierarchy_pvt.derive_asset_attribute',
325: name => 'CUA_MAP_CAT_ID' );
326: end if;
327:
328: if l_lease_RF = 'Y' then

Line 330: calling_fn => 'fa_asset_hierarchy_pvt.derive_asset_attribute',

326: end if;
327:
328: if l_lease_RF = 'Y' then
329: fa_srvr_msg.add_message(
330: calling_fn => 'fa_asset_hierarchy_pvt.derive_asset_attribute',
331: name => 'CUA_MAP_LEASE_ID' );
332: end if;
333:
334: if l_serial_num_RF = 'Y' then

Line 336: calling_fn => 'fa_asset_hierarchy_pvt.derive_asset_attribute',

332: end if;
333:
334: if l_serial_num_RF = 'Y' then
335: fa_srvr_msg.add_message(
336: calling_fn => 'fa_asset_hierarchy_pvt.derive_asset_attribute',
337: name => 'CUA_MAP_SERIAL_NUMBER' );
338: end if;
339:
340: if l_asset_key_RF = 'Y' then

Line 342: calling_fn => 'fa_asset_hierarchy_pvt.derive_asset_attribute',

338: end if;
339:
340: if l_asset_key_RF = 'Y' then
341: fa_srvr_msg.add_message(
342: calling_fn => 'fa_asset_hierarchy_pvt.derive_asset_attribute',
343: name => 'CUA_MAP_ASSET_KEY_CCID' );
344: end if;
345:
346: if l_dist_RF = 'Y' then

Line 348: calling_fn => 'fa_asset_hierarchy_pvt.derive_asset_attribute',

344: end if;
345:
346: if l_dist_RF = 'Y' then
347: fa_srvr_msg.add_message(
348: calling_fn => 'fa_asset_hierarchy_pvt.derive_asset_attribute',
349: name => 'CUA_MAP_DISTRIBUTION' );
350: end if;
351:
352: if l_life_RF = 'Y' then

Line 354: calling_fn => 'fa_asset_hierarchy_pvt.derive_asset_attribute',

350: end if;
351:
352: if l_life_RF = 'Y' then
353: fa_srvr_msg.add_message(
354: calling_fn => 'fa_asset_hierarchy_pvt.derive_asset_attribute',
355: name => 'CUA_MAP_LIFE_IN_MONTHS' );
356: end if;
357:
358:

Line 363: CALLING_FN => 'fa_asset_hierarchy_pvt.derive_asset_attribute' );

359: return FALSE;
360:
361: when others then
362: FA_SRVR_MSG.ADD_SQL_ERROR(
363: CALLING_FN => 'fa_asset_hierarchy_pvt.derive_asset_attribute' );
364: RETURN (FALSE);
365:
366: END derive_asset_attribute;
367:

Line 428: calling_fn => 'fa_asset_hierarchy_pvt.create_batch',

424:
425:
426: if l_err_code <> '0' then
427: fa_srvr_msg.add_message(
428: calling_fn => 'fa_asset_hierarchy_pvt.create_batch',
429: name => 'CUA_BATCH_ERRORED');
430: return FALSE;
431: end if;
432:

Line 448: calling_fn => 'fa_asset_hierarchy_pvt.create_batch.submit_request');

444: '','','','','','','','','','');
445:
446: if(l_request_num = 0) then
447: fa_srvr_msg.add_message(
448: calling_fn => 'fa_asset_hierarchy_pvt.create_batch.submit_request');
449: return FALSE;
450: else
451: Update fa_mass_update_batch_headers
452: set status_code = 'IP'

Line 457: calling_fn => 'fa_asset_hierarchy_pvt.create_batch',

453: , concurrent_request_id = l_request_num
454: where batch_id = l_batch_id;
455:
456: fa_srvr_msg.add_message(
457: calling_fn => 'fa_asset_hierarchy_pvt.create_batch',
458: name => 'CUA_BATCH_SUBMITTED',
459: token1 => 'Request_id',
460: value1 => to_char(l_request_num),
461: token2 => 'Batch_no',

Line 472: END FA_ASSET_HIERARCHY_PVT;

468:
469: END create_batch;
470:
471:
472: END FA_ASSET_HIERARCHY_PVT;