DBA Data[Home] [Help]

APPS.FA_ADJUSTMENT_PUB dependencies on FND_API

Line 38: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

34: --*********************** Public procedures ******************************--
35:
36: PROCEDURE do_adjustment
37: (p_api_version IN NUMBER,
38: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
39: p_commit IN VARCHAR2 := FND_API.G_FALSE,
40: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
41: p_calling_fn IN VARCHAR2,
42: x_return_status OUT NOCOPY VARCHAR2,

Line 39: p_commit IN VARCHAR2 := FND_API.G_FALSE,

35:
36: PROCEDURE do_adjustment
37: (p_api_version IN NUMBER,
38: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
39: p_commit IN VARCHAR2 := FND_API.G_FALSE,
40: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
41: p_calling_fn IN VARCHAR2,
42: x_return_status OUT NOCOPY VARCHAR2,
43: x_msg_count OUT NOCOPY NUMBER,

Line 40: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

36: PROCEDURE do_adjustment
37: (p_api_version IN NUMBER,
38: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
39: p_commit IN VARCHAR2 := FND_API.G_FALSE,
40: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
41: p_calling_fn IN VARCHAR2,
42: x_return_status OUT NOCOPY VARCHAR2,
43: x_msg_count OUT NOCOPY NUMBER,
44: x_msg_data OUT NOCOPY VARCHAR2,

Line 109: if (fnd_api.to_boolean(p_init_msg_list)) then

105:
106: g_cip_cost := 0;
107:
108: -- Initialize message list if p_init_msg_list is set to TRUE.
109: if (fnd_api.to_boolean(p_init_msg_list)) then
110: -- initialize error message stack.
111: fa_srvr_msg.init_server_message;
112:
113: -- initialize debug message stack.

Line 119: if NOT fnd_api.compatible_api_call (

115: end if;
116:
117: -- Check version of the API
118: -- Standard call to check for API call compatibility.
119: if NOT fnd_api.compatible_api_call (
120: G_API_VERSION,
121: p_api_version,
122: G_API_NAME,
123: G_PKG_NAME) then

Line 124: x_return_status := FND_API.G_RET_STS_ERROR;

120: G_API_VERSION,
121: p_api_version,
122: G_API_NAME,
123: G_PKG_NAME) then
124: x_return_status := FND_API.G_RET_STS_ERROR;
125: raise adj_err;
126: end if;
127:
128: -- call the cache for the primary transaction book

Line 248: FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM then

244: end if; */
245:
246: if (nvl(fa_cache_pkg.fazccmt_record.guarantee_rate_method_flag,'NO') = 'YES') and
247: nvl(l_asset_fin_rec_adj.group_asset_id,
248: FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM then
249: fa_srvr_msg.add_message
250: (calling_fn => l_calling_fn,
251: name => 'FA_GROUP_NOT_AVAILABLE');
252: raise adj_err;

Line 468: if (fnd_api.to_boolean (p_commit)) then

464:
465: end if; -- corporate book
466:
467: -- commit if p_commit is TRUE.
468: if (fnd_api.to_boolean (p_commit)) then
469: COMMIT WORK;
470: end if;
471:
472: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 472: x_return_status := FND_API.G_RET_STS_SUCCESS;

468: if (fnd_api.to_boolean (p_commit)) then
469: COMMIT WORK;
470: end if;
471:
472: x_return_status := FND_API.G_RET_STS_SUCCESS;
473:
474:
475: EXCEPTION
476:

Line 496: x_return_status := FND_API.G_RET_STS_ERROR;

492: p_data => x_msg_data
493: );
494: end if;
495:
496: x_return_status := FND_API.G_RET_STS_ERROR;
497:
498: when others then
499: ROLLBACK TO do_adjustment;
500:

Line 518: x_return_status := FND_API.G_RET_STS_ERROR;

514: p_data => x_msg_data
515: );
516: end if;
517:
518: x_return_status := FND_API.G_RET_STS_ERROR;
519:
520: END do_adjustment;
521:
522: -----------------------------------------------------------------------------

Line 860: FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM) then

856:
857: if (px_trans_rec.transaction_subtype = 'EXPENSED') then
858: if (l_asset_fin_rec_old.group_asset_id is not null or
859: nvl(p_asset_fin_rec_adj.group_asset_id,
860: FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM) then
861: px_trans_rec.transaction_subtype := 'AMORTIZED';
862: end if;
863: end if;
864:

Line 866: -- Possible values of extended_deprn_flag are 'Y', 'N', 'D', null and FND_API.G_MISS_CHAR

862: end if;
863: end if;
864:
865: /* Japan Tax Phase3 Set the extended deprn flags */
866: -- Possible values of extended_deprn_flag are 'Y', 'N', 'D', null and FND_API.G_MISS_CHAR
867: -- l_asset_fin_rec_adj.extended_deprn_flag = null means no change
868: -- = FND_API.G_MISS_CHAR means make it null
869: if (nvl(l_asset_fin_rec_old.extended_deprn_flag,'N') = 'Y') then
870: l_extended_flag := TRUE;

Line 868: -- = FND_API.G_MISS_CHAR means make it null

864:
865: /* Japan Tax Phase3 Set the extended deprn flags */
866: -- Possible values of extended_deprn_flag are 'Y', 'N', 'D', null and FND_API.G_MISS_CHAR
867: -- l_asset_fin_rec_adj.extended_deprn_flag = null means no change
868: -- = FND_API.G_MISS_CHAR means make it null
869: if (nvl(l_asset_fin_rec_old.extended_deprn_flag,'N') = 'Y') then
870: l_extended_flag := TRUE;
871: if (nvl(l_asset_fin_rec_adj.extended_deprn_flag,'X') in ('N','D',FND_API.G_MISS_CHAR)) then
872: l_reset_extend_flag := TRUE;

Line 871: if (nvl(l_asset_fin_rec_adj.extended_deprn_flag,'X') in ('N','D',FND_API.G_MISS_CHAR)) then

867: -- l_asset_fin_rec_adj.extended_deprn_flag = null means no change
868: -- = FND_API.G_MISS_CHAR means make it null
869: if (nvl(l_asset_fin_rec_old.extended_deprn_flag,'N') = 'Y') then
870: l_extended_flag := TRUE;
871: if (nvl(l_asset_fin_rec_adj.extended_deprn_flag,'X') in ('N','D',FND_API.G_MISS_CHAR)) then
872: l_reset_extend_flag := TRUE;
873: l_extended_flag := FALSE; -- Bug 6774428 don't need validations when resetting
874: end if;
875: elsif ((nvl(l_asset_fin_rec_adj.extended_deprn_flag,'N') = 'Y') and

Line 885: FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM) then

881: if (l_set_extend_flag) then
882: if ( p_asset_type_rec.asset_type = 'GROUP' ) OR
883: (l_asset_fin_rec_old.group_asset_id is not null or
884: nvl(p_asset_fin_rec_adj.group_asset_id,
885: FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM) then
886:
887: fa_srvr_msg.add_message(calling_fn => l_calling_fn,name =>'FA_GROUP_ASSET_EXTD_DEPRN_NOT_ALLOWED');
888: raise adj_err;
889: end if;

Line 1247: if (nvl(l_asset_fin_rec_old.contract_id, FND_API.G_MISS_NUM) <>

1243: p_asset_fin_rec_adj => l_asset_fin_rec_adj,
1244: p_asset_deprn_rec_old => l_asset_deprn_rec_old,
1245: p_asset_deprn_rec_adj => l_asset_deprn_rec_adj);
1246:
1247: if (nvl(l_asset_fin_rec_old.contract_id, FND_API.G_MISS_NUM) <>
1248: nvl(p_asset_fin_rec_adj.contract_id,
1249: nvl(l_asset_fin_rec_old.contract_id, FND_API.G_MISS_NUM)) ) and
1250: not l_validate_flag then
1251:

Line 1249: nvl(l_asset_fin_rec_old.contract_id, FND_API.G_MISS_NUM)) ) and

1245: p_asset_deprn_rec_adj => l_asset_deprn_rec_adj);
1246:
1247: if (nvl(l_asset_fin_rec_old.contract_id, FND_API.G_MISS_NUM) <>
1248: nvl(p_asset_fin_rec_adj.contract_id,
1249: nvl(l_asset_fin_rec_old.contract_id, FND_API.G_MISS_NUM)) ) and
1250: not l_validate_flag then
1251:
1252: l_contract_change_flag := TRUE;
1253: l_asset_fin_rec_adj.contract_change_flag := TRUE;

Line 1280: nvl(p_asset_fin_rec_adj.group_asset_id, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM) or

1276: -- populate the trx_reference_id when group change occurs
1277: -- if (nvl(l_asset_fin_rec_old.group_asset_id, -99) <>
1278: -- nvl(p_asset_fin_rec_adj.group_asset_id, -99)) then
1279: if (l_asset_fin_rec_old.group_asset_id is null and
1280: nvl(p_asset_fin_rec_adj.group_asset_id, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM) or
1281: (l_asset_fin_rec_old.group_asset_id <> p_asset_fin_rec_adj.group_asset_id) then
1282: select fa_trx_references_s.nextval
1283: into px_trans_rec.trx_reference_id
1284: from dual;

Line 1291: nvl(p_asset_fin_rec_adj.group_asset_id, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM)) then

1287: -- BUG# 2877651
1288: -- if this is or was a amember asset, force amortized subtype
1289: if (px_trans_rec.transaction_subtype = 'EXPENSED' and
1290: (l_asset_fin_rec_old.group_asset_id is not null or
1291: nvl(p_asset_fin_rec_adj.group_asset_id, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM)) then
1292: px_trans_rec.transaction_subtype := 'AMORTIZED';
1293: px_trans_rec.amortization_start_date := to_date(to_char(l_transaction_date,'DD/MM/YYYY'),'DD/MM/YYYY');
1294: px_trans_rec.transaction_date_entered := px_trans_rec.amortization_start_date;
1295: end if;

Line 1720: l_asset_fin_rec_adj.extended_depreciation_period := FND_API.G_MISS_NUM;

1716: l_asset_fin_rec_adj.allowed_deprn_limit,
1717: l_asset_fin_rec_adj.deprn_limit_type,
1718: l_asset_fin_rec_adj.allowed_deprn_limit_amount;
1719: close c_extend_get_original_deprn;
1720: l_asset_fin_rec_adj.extended_depreciation_period := FND_API.G_MISS_NUM;
1721:
1722: px_trans_rec.transaction_key := 'ER';
1723: end if;
1724: -- Japan Tax phase3 end