DBA Data[Home] [Help]

APPS.FA_ADJUSTMENT_PUB dependencies on FND_API

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

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

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

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

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

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

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

109: g_release := fa_cache_pkg.fazarel_release;
110:
111: g_cip_cost := 0;
112: -- Initialize message list if p_init_msg_list is set to TRUE.
113: if (fnd_api.to_boolean(p_init_msg_list)) then
114: -- initialize error message stack.
115: fa_srvr_msg.init_server_message;
116:
117: -- initialize debug message stack.

Line 123: if NOT fnd_api.compatible_api_call (

119: end if;
120:
121: -- Check version of the API
122: -- Standard call to check for API call compatibility.
123: if NOT fnd_api.compatible_api_call (
124: G_API_VERSION,
125: p_api_version,
126: G_API_NAME,
127: G_PKG_NAME

Line 129: x_return_status := FND_API.G_RET_STS_ERROR;

125: p_api_version,
126: G_API_NAME,
127: G_PKG_NAME
128: ) then
129: x_return_status := FND_API.G_RET_STS_ERROR;
130: raise adj_err;
131: end if;
132: /*bug#16426081 */
133: declare

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

299:
300:
301: if (nvl(fa_cache_pkg.fazccmt_record.guarantee_rate_method_flag,'NO') = 'YES') and
302: nvl(l_asset_fin_rec_adj.group_asset_id,
303: FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM then
304: fa_srvr_msg.add_message
305: (calling_fn => l_calling_fn,
306: name => 'FA_GROUP_NOT_AVAILABLE', p_log_level_rec => g_log_level_rec);
307: raise adj_err;

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

511:
512: end if; -- corporate book
513:
514: -- commit if p_commit is TRUE.
515: if (fnd_api.to_boolean (p_commit)) then
516: COMMIT WORK;
517: end if;
518:
519: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 519: x_return_status := FND_API.G_RET_STS_SUCCESS;

515: if (fnd_api.to_boolean (p_commit)) then
516: COMMIT WORK;
517: end if;
518:
519: x_return_status := FND_API.G_RET_STS_SUCCESS;
520:
521:
522: EXCEPTION
523:

Line 539: x_return_status := FND_API.G_RET_STS_ERROR;

535: p_data => x_msg_data
536: );
537: end if;
538:
539: x_return_status := FND_API.G_RET_STS_ERROR;
540:
541: when others then
542: ROLLBACK TO do_adjustment;
543:

Line 557: x_return_status := FND_API.G_RET_STS_ERROR;

553: p_data => x_msg_data
554: );
555: end if;
556:
557: x_return_status := FND_API.G_RET_STS_ERROR;
558:
559: END do_adjustment;
560:
561: -----------------------------------------------------------------------------

Line 1005: nvl(l_asset_fin_rec_adj.group_asset_id, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM then

1001: end if;
1002:
1003:
1004: if (nvl(fa_cache_pkg.fazccmt_record.guarantee_rate_method_flag,'NO') = 'YES') and
1005: nvl(l_asset_fin_rec_adj.group_asset_id, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM then
1006: fa_srvr_msg.add_message
1007: (calling_fn => l_calling_fn,
1008: name => 'FA_GROUP_NOT_AVAILABLE', p_log_level_rec => p_log_level_rec);
1009: raise adj_err;

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

1103:
1104: if (px_trans_rec.transaction_subtype = 'EXPENSED') then
1105: if (l_asset_fin_rec_old.group_asset_id is not null or
1106: nvl(l_asset_fin_rec_adj.group_asset_id,
1107: FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM) then
1108: px_trans_rec.transaction_subtype := 'AMORTIZED';
1109: end if;
1110: end if;
1111:

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

1109: end if;
1110: end if;
1111:
1112: /* Japan Tax Phase3 Set the extended deprn flags */
1113: -- Possible values of extended_deprn_flag are 'Y', 'N', 'D', null and FND_API.G_MISS_CHAR
1114: -- l_asset_fin_rec_adj.extended_deprn_flag = null means no change
1115: -- = FND_API.G_MISS_CHAR means make it null
1116: if (nvl(l_asset_fin_rec_old.extended_deprn_flag,'N') = 'Y') then
1117: l_extended_flag := TRUE;

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

1111:
1112: /* Japan Tax Phase3 Set the extended deprn flags */
1113: -- Possible values of extended_deprn_flag are 'Y', 'N', 'D', null and FND_API.G_MISS_CHAR
1114: -- l_asset_fin_rec_adj.extended_deprn_flag = null means no change
1115: -- = FND_API.G_MISS_CHAR means make it null
1116: if (nvl(l_asset_fin_rec_old.extended_deprn_flag,'N') = 'Y') then
1117: l_extended_flag := TRUE;
1118: if (nvl(l_asset_fin_rec_adj.extended_deprn_flag,'X') in ('N','D',FND_API.G_MISS_CHAR)) then
1119: l_reset_extend_flag := TRUE;

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

1114: -- l_asset_fin_rec_adj.extended_deprn_flag = null means no change
1115: -- = FND_API.G_MISS_CHAR means make it null
1116: if (nvl(l_asset_fin_rec_old.extended_deprn_flag,'N') = 'Y') then
1117: l_extended_flag := TRUE;
1118: if (nvl(l_asset_fin_rec_adj.extended_deprn_flag,'X') in ('N','D',FND_API.G_MISS_CHAR)) then
1119: l_reset_extend_flag := TRUE;
1120: l_extended_flag := FALSE; -- Bug 6737486 don't need validations when resetting
1121: end if;
1122: elsif ((nvl(l_asset_fin_rec_adj.extended_deprn_flag,'N') = 'Y') and

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

1517: p_log_level_rec => p_log_level_rec
1518: );
1519:
1520: -- Removing not before l_validate_flag inif condtion for bug 9168436
1521: if (nvl(l_asset_fin_rec_old.contract_id, FND_API.G_MISS_NUM) <>
1522: nvl(p_asset_fin_rec_adj.contract_id,
1523: nvl(l_asset_fin_rec_old.contract_id, FND_API.G_MISS_NUM)) ) and
1524: l_validate_flag then
1525:

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

1519:
1520: -- Removing not before l_validate_flag inif condtion for bug 9168436
1521: if (nvl(l_asset_fin_rec_old.contract_id, FND_API.G_MISS_NUM) <>
1522: nvl(p_asset_fin_rec_adj.contract_id,
1523: nvl(l_asset_fin_rec_old.contract_id, FND_API.G_MISS_NUM)) ) and
1524: l_validate_flag then
1525:
1526: l_contract_change_flag := TRUE;
1527: l_asset_fin_rec_adj.contract_change_flag := TRUE;

Line 1539: nvl(l_asset_fin_rec_adj.group_asset_id, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM) or

1535: -- populate the trx_reference_id when group change occurs
1536: -- if (nvl(l_asset_fin_rec_old.group_asset_id, -99) <>
1537: -- nvl(l_asset_fin_rec_adj.group_asset_id, -99)) then
1538: if (l_asset_fin_rec_old.group_asset_id is null and
1539: nvl(l_asset_fin_rec_adj.group_asset_id, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM) or
1540: (l_asset_fin_rec_old.group_asset_id <> l_asset_fin_rec_adj.group_asset_id) then
1541: select fa_trx_references_s.nextval
1542: into px_trans_rec.trx_reference_id
1543: from dual;

Line 1550: nvl(l_asset_fin_rec_adj.group_asset_id, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM)) then

1546: -- BUG# 2877651
1547: -- if this is or was a amember asset, force amortized subtype
1548: if (px_trans_rec.transaction_subtype = 'EXPENSED' and
1549: (l_asset_fin_rec_old.group_asset_id is not null or
1550: nvl(l_asset_fin_rec_adj.group_asset_id, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM)) then
1551: px_trans_rec.transaction_subtype := 'AMORTIZED';
1552: px_trans_rec.amortization_start_date := to_date(to_char(l_transaction_date,'DD/MM/YYYY'),'DD/MM/YYYY');
1553: px_trans_rec.transaction_date_entered := px_trans_rec.amortization_start_date;
1554: end if;

Line 1979: nvl(l_asset_fin_rec_old.group_asset_id,FND_API.G_MISS_NUM)) <> FND_API.G_MISS_NUM then

1975:
1976: end if; -- primary of reporting
1977:
1978: if nvl(l_asset_fin_rec_adj.group_asset_id,
1979: nvl(l_asset_fin_rec_old.group_asset_id,FND_API.G_MISS_NUM)) <> FND_API.G_MISS_NUM then
1980: l_asset_fin_rec_adj.group_asset_id := nvl(l_asset_fin_rec_adj.group_asset_id,l_asset_fin_rec_old.group_asset_id);
1981: if not FA_ASSET_VAL_PVT.validate_over_depreciation
1982: (p_asset_hdr_rec => l_asset_hdr_rec,
1983: p_asset_fin_rec => l_asset_fin_rec_adj,

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

2075: l_asset_fin_rec_adj.deprn_limit_type,
2076: l_asset_fin_rec_adj.allowed_deprn_limit_amount;
2077: close c_extend_get_original_deprn;
2078:
2079: l_asset_fin_rec_adj.extended_depreciation_period := FND_API.G_MISS_NUM;
2080:
2081: -- Added this condition for Bug#7297680
2082:
2083: if (l_asset_fin_rec_adj.deprn_limit_type = l_asset_fin_rec_old.deprn_limit_type ) then