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

Line 1: PACKAGE BODY FA_DISTRIBUTION_PVT AS

1: PACKAGE BODY FA_DISTRIBUTION_PVT AS
2: /* $Header: FAVDISTB.pls 120.34.12020000.3 2013/02/04 11:18:40 adaluru ship $ */
3:
4: g_release number := fa_cache_pkg.fazarel_release;
5:

Line 117: calling_fn => 'FA_DISTRIBUTION_PVT.do_distribution',

113: px_asset_cat_rec_new.category_id := l_asset_cat_rec_old.category_id;
114: elsif (px_trans_rec.transaction_type_code = 'RECLASS') then
115: if px_asset_cat_rec_new.category_id is null then
116: fa_srvr_msg.add_message(
117: calling_fn => 'FA_DISTRIBUTION_PVT.do_distribution',
118: name => 'FA_SHARED_UNDEFINE_CATEGORY'
119: ,p_log_level_rec => p_log_level_rec);
120: raise error_found;
121: end if;

Line 183: fa_srvr_msg.add_message(calling_fn => 'FA_DISTRIBUTION_PVT.do_distribution'

179: end if;
180:
181: if not FA_CACHE_PKG.fazcbc(X_book => l_book
182: ,p_log_level_rec => p_log_level_rec) then
183: fa_srvr_msg.add_message(calling_fn => 'FA_DISTRIBUTION_PVT.do_distribution'
184: ,p_log_level_rec => p_log_level_rec);
185: raise error_found;
186: end if;
187:

Line 258: p_calling_fn => 'FA_DISTRIBUTION_PVT.do_distribution'

254: (p_asset_hdr_rec => l_asset_hdr_rec,
255: p_asset_type_rec=> l_asset_type_rec_old,
256: px_trans_rec => l_trans_rec,
257: p_event_status => NULL,
258: p_calling_fn => 'FA_DISTRIBUTION_PVT.do_distribution'
259: ,p_log_level_rec => p_log_level_rec) then
260: raise error_found;
261: end if;
262: /*=================================================================

Line 278: p_calling_fn => 'FA_DISTRIBUTION_PVT.do_distribution'

274: (p_asset_hdr_rec => l_secondary_asset_hdr_rec,
275: p_asset_type_rec=> l_asset_type_rec_old,
276: px_trans_rec => l_secondary_trans_rec,
277: p_event_status => NULL,
278: p_calling_fn => 'FA_DISTRIBUTION_PVT.do_distribution'
279: ,p_log_level_rec => p_log_level_rec) then
280: raise error_found;
281: end if;
282: end if;

Line 379: calling_fn => 'FA_DISTRIBUTION_PVT.do_distribution');

375: X_mrc_sob_type_code => l_mrc_sob_type_code,
376: X_set_of_books_id => c_rec.sob_id,
377: p_log_level_rec => p_log_level_rec) then
378: fa_srvr_msg.add_message(
379: calling_fn => 'FA_DISTRIBUTION_PVT.do_distribution');
380: return FALSE;
381: end if;
382: end loop;
383: end if;

Line 462: p_calling_fn => 'FA_DISTRIBUTION_PVT.do_distribution', p_log_level_rec => p_log_level_rec) then

458: p_src_trans_rec => l_src_trans_rec,
459: p_src_asset_hdr_rec => l_src_asset_hdr_rec,
460: p_dest_trans_rec => l_dest_trans_rec,
461: p_dest_asset_hdr_rec => l_dest_asset_hdr_rec,
462: p_calling_fn => 'FA_DISTRIBUTION_PVT.do_distribution', p_log_level_rec => p_log_level_rec) then
463: fa_srvr_msg.add_message(
464: calling_fn => 'FA_DISTRIBUTION_PVT.do_distribution', p_log_level_rec => p_log_level_rec);
465: return FALSE;
466: end if;

Line 464: calling_fn => 'FA_DISTRIBUTION_PVT.do_distribution', p_log_level_rec => p_log_level_rec);

460: p_dest_trans_rec => l_dest_trans_rec,
461: p_dest_asset_hdr_rec => l_dest_asset_hdr_rec,
462: p_calling_fn => 'FA_DISTRIBUTION_PVT.do_distribution', p_log_level_rec => p_log_level_rec) then
463: fa_srvr_msg.add_message(
464: calling_fn => 'FA_DISTRIBUTION_PVT.do_distribution', p_log_level_rec => p_log_level_rec);
465: return FALSE;
466: end if;
467: end if;
468: end if;

Line 476: fa_srvr_msg.add_message(calling_fn => 'FA_DISTRIBUTION_PVT.do_distribution'

472:
473: -- reset cache to incoming corp book instead of last tax
474: if not FA_CACHE_PKG.fazcbc(X_book => px_asset_hdr_rec.book_type_code
475: ,p_log_level_rec => p_log_level_rec) then
476: fa_srvr_msg.add_message(calling_fn => 'FA_DISTRIBUTION_PVT.do_distribution'
477: ,p_log_level_rec => p_log_level_rec);
478: raise error_found;
479: end if;
480:

Line 486: calling_fn => 'FA_DISTRIBUTION_PVT.do_distribution', p_log_level_rec => p_log_level_rec);

482:
483: EXCEPTION
484: when others then
485: fa_srvr_msg.add_sql_error(
486: calling_fn => 'FA_DISTRIBUTION_PVT.do_distribution', p_log_level_rec => p_log_level_rec);
487: return FALSE;
488:
489: END do_distribution;
490:

Line 551: calling_fn => 'FA_DISTRIBUTION_PVT.do_validation',

547:
548: -- check period_of_addition is correctly set
549: if (p_asset_hdr_rec.period_of_addition not in ('Y','N')) then
550: fa_srvr_msg.add_message(
551: calling_fn => 'FA_DISTRIBUTION_PVT.do_validation',
552: name => 'FA_API_SHARED_INVALID_YN',
553: token1 => 'VALUE',
554: value1 => p_asset_hdr_rec.period_of_addition,
555: token2 => 'XMLTAG',

Line 752: fa_srvr_msg.add_message(calling_fn => 'FA_DISTRIBUTION_PVT.do_validation', p_log_level_rec => p_log_level_rec);

748: nvl(fa_cache_pkg.fazcbc_record.allow_interco_group_flag, 'N') <> 'Y') then
749:
750: if not FA_UTIL_PVT.get_asset_type_rec(p_asset_hdr_rec,
751: l_asset_type_rec_old, p_log_level_rec => p_log_level_rec) then
752: fa_srvr_msg.add_message(calling_fn => 'FA_DISTRIBUTION_PVT.do_validation', p_log_level_rec => p_log_level_rec);
753: return FALSE;
754: end if;
755:
756: if (l_asset_type_rec_old.asset_type <> 'GROUP') then

Line 774: p_calling_fn => 'FA_DISTRIBUTION_PVT.do_validation', p_log_level_rec => p_log_level_rec) then

770: p_trans_rec => p_trans_rec,
771: p_asset_type_rec => l_asset_type_rec_old,
772: p_group_asset_id => 1,
773: p_asset_dist_tbl => px_asset_dist_tbl,
774: p_calling_fn => 'FA_DISTRIBUTION_PVT.do_validation', p_log_level_rec => p_log_level_rec) then
775:
776: fa_srvr_msg.add_message(calling_fn => 'FA_DISTRIBUTION_PVT.do_validation', p_log_level_rec => p_log_level_rec);
777: return FALSE;
778: end if;

Line 776: fa_srvr_msg.add_message(calling_fn => 'FA_DISTRIBUTION_PVT.do_validation', p_log_level_rec => p_log_level_rec);

772: p_group_asset_id => 1,
773: p_asset_dist_tbl => px_asset_dist_tbl,
774: p_calling_fn => 'FA_DISTRIBUTION_PVT.do_validation', p_log_level_rec => p_log_level_rec) then
775:
776: fa_srvr_msg.add_message(calling_fn => 'FA_DISTRIBUTION_PVT.do_validation', p_log_level_rec => p_log_level_rec);
777: return FALSE;
778: end if;
779:
780: end if;

Line 796: calling_fn => 'FA_DISTRIBUTION_PVT.do_validation',

792: close DH_C2;
793: end if;
794:
795: fa_srvr_msg.add_message(
796: calling_fn => 'FA_DISTRIBUTION_PVT.do_validation',
797: name => l_msg_name, p_log_level_rec => p_log_level_rec);
798: return FALSE;
799:
800: when others then

Line 802: calling_fn => 'FA_DISTRIBUTION_PVT.do_validation', p_log_level_rec => p_log_level_rec);

798: return FALSE;
799:
800: when others then
801: fa_srvr_msg.add_sql_error(
802: calling_fn => 'FA_DISTRIBUTION_PVT.do_validation', p_log_level_rec => p_log_level_rec);
803: return FALSE;
804: END do_validation;
805:
806:

Line 834: calling_fn => 'FA_DISTRIBUTION_PVT.valid_dist_data',

830: and nvl(s.actual_termination_date,sysdate) >= sysdate
831: and p.person_id = p_asset_dist_tbl(p_curr_index).assigned_to;
832: if (l_count = 0) then
833: fa_srvr_msg.add_message(
834: calling_fn => 'FA_DISTRIBUTION_PVT.valid_dist_data',
835: name => 'FA_INCORRECT_ASSIGNED_TO',
836: token1 => 'ASSIGNED_TO',
837: value1 => p_asset_dist_tbl(p_curr_index).assigned_to,
838: p_log_level_rec => p_log_level_rec);

Line 852: 'FA_DISTRIBUTION_PVT.valid_dist_data', p_log_level_rec) then

848:
849: -- validate expense ccid
850: if not FA_ASSET_VAL_PVT.validate_expense_ccid(p_asset_dist_tbl(p_curr_index).expense_ccid,
851: l_gl_chart_id,
852: 'FA_DISTRIBUTION_PVT.valid_dist_data', p_log_level_rec) then
853: return FALSE;
854: end if;
855:
856:

Line 861: 'FA_DISTRIBUTION_PVT.valid_dist_data',

857: -- validate location id
858: if not FA_ASSET_VAL_PVT.validate_location_ccid(
859: p_trans_rec.transaction_type_code,
860: p_asset_dist_tbl(p_curr_index).location_ccid,
861: 'FA_DISTRIBUTION_PVT.valid_dist_data',
862: p_log_level_rec) then
863: return FALSE;
864: end if;
865:

Line 878: p_calling_function => 'FA_DISTRIBUTION_PVT.valid_dist_data',

874: if not FA_ASSET_VAL_PVT.validate_duplicate_dist (
875: p_transaction_type_code => p_trans_rec.transaction_type_code,
876: p_asset_dist_tbl => p_asset_dist_tbl,
877: p_curr_index => p_curr_index ,
878: p_calling_function => 'FA_DISTRIBUTION_PVT.valid_dist_data',
879: p_log_level_rec => p_log_level_rec) then
880:
881: fa_srvr_msg.add_message(
882: calling_fn => 'FA_DISTRIBUTION_PVT.valid_dist_data', p_log_level_rec => p_log_level_rec);

Line 882: calling_fn => 'FA_DISTRIBUTION_PVT.valid_dist_data', p_log_level_rec => p_log_level_rec);

878: p_calling_function => 'FA_DISTRIBUTION_PVT.valid_dist_data',
879: p_log_level_rec => p_log_level_rec) then
880:
881: fa_srvr_msg.add_message(
882: calling_fn => 'FA_DISTRIBUTION_PVT.valid_dist_data', p_log_level_rec => p_log_level_rec);
883: return FALSE;
884: end if;
885: end if;
886: end if; /* if txn_type */

Line 893: fa_srvr_msg.add_sql_error(calling_fn => 'FA_DISTRIBUTION_PVT.valid_dist_data', p_log_level_rec => p_log_level_rec);

889:
890:
891: EXCEPTION
892: when others then
893: fa_srvr_msg.add_sql_error(calling_fn => 'FA_DISTRIBUTION_PVT.valid_dist_data', p_log_level_rec => p_log_level_rec);
894: return FALSE;
895: END valid_dist_data;
896:
897:

Line 930: calling_fn => 'FA_DISTRIBUTION_PVT.units_in_sync',

926: l_ad_units <> l_dh_units or
927: l_ah_units <> l_dh_units) then
928:
929: fa_srvr_msg.add_message(
930: calling_fn => 'FA_DISTRIBUTION_PVT.units_in_sync',
931: name => 'FA_UNITS_DIFFERENT', p_log_level_rec => p_log_level_rec);
932:
933: return FALSE;
934: end if;

Line 941: (calling_fn => 'FA_DISTRIBUTION_PVT.units_in_sync', p_log_level_rec => p_log_level_rec);

937:
938: EXCEPTION
939: when others then
940: fa_srvr_msg.add_sql_error
941: (calling_fn => 'FA_DISTRIBUTION_PVT.units_in_sync', p_log_level_rec => p_log_level_rec);
942: return FALSE;
943:
944: END units_in_sync;
945:

Line 1020: X_calling_FN =>'FA_DISTRIBUTION_PVT.insert_txn_headers', p_log_level_rec => p_log_level_rec);

1016: X_Calling_Interface => px_trans_rec.calling_interface,
1017: X_Mass_Transaction_ID => px_trans_rec.mass_transaction_id,
1018: X_Event_ID => px_trans_rec.event_id,
1019: X_Return_status => l_success,
1020: X_calling_FN =>'FA_DISTRIBUTION_PVT.insert_txn_headers', p_log_level_rec => p_log_level_rec);
1021:
1022: if (not l_success) then
1023: return FALSE;
1024: end if;

Line 1032: calling_fn => 'FA_DISTRIBUTION_PVT.insert_txn_headers', p_log_level_rec => p_log_level_rec);

1028:
1029: EXCEPTION
1030: when others then
1031: fa_srvr_msg.add_sql_error(
1032: calling_fn => 'FA_DISTRIBUTION_PVT.insert_txn_headers', p_log_level_rec => p_log_level_rec);
1033: return FALSE;
1034:
1035: END insert_txn_headers;
1036:

Line 1105: X_Calling_Fn => 'FA_DISTRIBUTION_PVT.update_asset_history', p_log_level_rec => p_log_level_rec);

1101: X_Last_Update_Date => p_trans_rec.who_info.last_update_date,
1102: X_Last_Updated_By => p_trans_rec.who_info.last_updated_by,
1103: X_Last_Update_Login => p_trans_rec.who_info.last_update_login,
1104: X_Return_Status => l_success,
1105: X_Calling_Fn => 'FA_DISTRIBUTION_PVT.update_asset_history', p_log_level_rec => p_log_level_rec);
1106: if (not l_success) then
1107: return FALSE;
1108: end if;
1109:

Line 1128: X_Calling_Fn => 'FA_DISTRIBUTION_PVT.update_asset_history', p_log_level_rec => p_log_level_rec);

1124: X_Last_Update_Date => p_trans_rec.who_info.last_update_date,
1125: X_Last_Updated_By => p_trans_rec.who_info.last_updated_by,
1126: X_Last_Update_Login => p_trans_rec.who_info.last_update_login,
1127: X_Return_Status => l_success,
1128: X_Calling_Fn => 'FA_DISTRIBUTION_PVT.update_asset_history', p_log_level_rec => p_log_level_rec);
1129: if (not l_success) then
1130: return FALSE;
1131: end if;
1132:

Line 1149: X_Calling_Fn => 'FA_DISTRIBUTION_PVT.update_asset_history', p_log_level_rec => p_log_level_rec);

1145: X_Last_Update_Date => p_trans_rec.who_info.last_update_date,
1146: X_Last_Updated_By => p_trans_rec.who_info.last_updated_by,
1147: X_Last_Update_Login => p_trans_rec.who_info.last_update_login,
1148: X_Return_Status => l_success,
1149: X_Calling_Fn => 'FA_DISTRIBUTION_PVT.update_asset_history', p_log_level_rec => p_log_level_rec);
1150: if (not l_success) then
1151: return FALSE;
1152: end if;
1153:

Line 1160: calling_fn => 'FA_DISTRIBUTION_PVT.update_asset_history', p_log_level_rec => p_log_level_rec);

1156:
1157: EXCEPTION
1158: WHEN Others THEN
1159: fa_srvr_msg.add_sql_error(
1160: calling_fn => 'FA_DISTRIBUTION_PVT.update_asset_history', p_log_level_rec => p_log_level_rec);
1161: return FALSE;
1162: END update_asset_history;
1163:
1164:

Line 1242: calling_fn => 'FA_DISTRIBUTION_PVT.update_additions', p_log_level_rec => p_log_level_rec);

1238:
1239: EXCEPTION
1240: when others then
1241: fa_srvr_msg.add_sql_error(
1242: calling_fn => 'FA_DISTRIBUTION_PVT.update_additions', p_log_level_rec => p_log_level_rec);
1243: return FALSE;
1244: END update_additions;
1245:
1246:

Line 1409: calling_fn => 'FA_DISTRIBUTION_PVT.update_books', p_log_level_rec => p_log_level_rec);

1405:
1406: EXCEPTION
1407: when others then
1408: fa_srvr_msg.add_sql_error(
1409: calling_fn => 'FA_DISTRIBUTION_PVT.update_books', p_log_level_rec => p_log_level_rec);
1410: return FALSE;
1411:
1412: END update_books;
1413:

Line 1495: X_Calling_Fn => 'FA_DISTRIBUTION_PVT.update_dist_history', p_log_level_rec => p_log_level_rec);

1491: X_Transaction_Header_Id_Out =>p_trans_rec.transaction_header_id,
1492: X_Transaction_Units => p_asset_dist_tbl(i).transaction_units,
1493: X_Retirement_Id => l_ret_id,
1494: X_Last_Update_Login => p_trans_rec.who_info.last_update_login,
1495: X_Calling_Fn => 'FA_DISTRIBUTION_PVT.update_dist_history', p_log_level_rec => p_log_level_rec);
1496:
1497: -- create new row with new units
1498: FA_DISTRIBUTION_HISTORY_PKG.INSERT_ROW
1499: (X_Rowid => l_rowid,

Line 1517: X_Calling_Fn => 'FA_DISTRIBUTION_PVT.update_dist_history', p_log_level_rec => p_log_level_rec);

1513: X_Transaction_Header_Id_Out => NULL,
1514: X_Transaction_Units => NULL,
1515: X_Retirement_Id => NULL,
1516: X_Last_Update_Login => p_trans_rec.who_info.last_update_login,
1517: X_Calling_Fn => 'FA_DISTRIBUTION_PVT.update_dist_history', p_log_level_rec => p_log_level_rec);
1518:
1519: else -- full unit change, then terminate the row only
1520:
1521: FA_DISTRIBUTION_HISTORY_PKG.UPDATE_ROW

Line 1539: X_Calling_Fn => 'FA_DISTRIBUTION_PVT.update_dist_history', p_log_level_rec => p_log_level_rec);

1535: X_Transaction_Header_Id_Out =>p_trans_rec.transaction_header_id,
1536: X_Transaction_Units => p_asset_dist_tbl(i).transaction_units,
1537: X_Retirement_Id => l_ret_id,
1538: X_Last_Update_Login => p_trans_rec.who_info.last_update_login,
1539: X_Calling_Fn => 'FA_DISTRIBUTION_PVT.update_dist_history', p_log_level_rec => p_log_level_rec);
1540: end if;
1541: l_tfr_det_dist_id := p_asset_dist_tbl(i).distribution_id;
1542: else
1543:

Line 1563: X_Calling_Fn => 'FA_DISTRIBUTION_PVT.update_dist_history', p_log_level_rec => p_log_level_rec);

1559: X_Transaction_Header_Id_Out => NULL,
1560: X_Transaction_Units => NULL,
1561: X_Retirement_Id => NULL,
1562: X_Last_Update_Login => p_trans_rec.who_info.last_update_login,
1563: X_Calling_Fn => 'FA_DISTRIBUTION_PVT.update_dist_history', p_log_level_rec => p_log_level_rec);
1564: l_tfr_det_dist_id := l_distribution_id;
1565: end if;
1566:
1567:

Line 1574: X_Calling_Fn => 'FA_DISTRIBUTION_PVT.update_dist_history', p_log_level_rec => p_log_level_rec);

1570: (X_Rowid => l_rowid,
1571: X_Transfer_Header_Id => p_trans_rec.transaction_header_id,
1572: X_Distribution_Id => l_tfr_det_dist_id,
1573: X_Book_Header_Id => l_book_header_id,
1574: X_Calling_Fn => 'FA_DISTRIBUTION_PVT.update_dist_history', p_log_level_rec => p_log_level_rec);
1575: end if;
1576:
1577: END LOOP;
1578:

Line 1584: calling_fn => 'FA_DISTRIBUTION_PVT.update_dist_history', p_log_level_rec => p_log_level_rec);

1580:
1581: EXCEPTION
1582: when others then
1583: fa_srvr_msg.add_sql_error(
1584: calling_fn => 'FA_DISTRIBUTION_PVT.update_dist_history', p_log_level_rec => p_log_level_rec);
1585: return FALSE;
1586: END update_dist_history;
1587:
1588:

Line 1590: END FA_DISTRIBUTION_PVT;

1586: END update_dist_history;
1587:
1588:
1589:
1590: END FA_DISTRIBUTION_PVT;