DBA Data[Home] [Help]

APPS.FA_MASSCP_PKG dependencies on FND_API

Line 327: if (l_return_status = FND_API.G_RET_STS_ERROR) then

323: else
324: raise error_found_trx;
325: end if;
326:
327: if (l_return_status = FND_API.G_RET_STS_ERROR) then
328: raise error_found_trx;
329: elsif (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) then
330: raise error_found_fatal_trx;
331: else

Line 329: elsif (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) then

325: end if;
326:
327: if (l_return_status = FND_API.G_RET_STS_ERROR) then
328: raise error_found_trx;
329: elsif (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) then
330: raise error_found_fatal_trx;
331: else
332: l_process_status(l_loop_count) := 'SUCCESS';
333: end if;

Line 472: l_init_msg_list VARCHAR2(1) := FND_API.G_FALSE;

468: l_category_id number;
469:
470: -- used for api call
471: l_api_version NUMBER := 1.0;
472: l_init_msg_list VARCHAR2(1) := FND_API.G_FALSE;
473: l_commit VARCHAR2(1) := FND_API.G_FALSE;
474: l_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL;
475: l_return_status VARCHAR2(1);
476: l_mesg_count number;

Line 473: l_commit VARCHAR2(1) := FND_API.G_FALSE;

469:
470: -- used for api call
471: l_api_version NUMBER := 1.0;
472: l_init_msg_list VARCHAR2(1) := FND_API.G_FALSE;
473: l_commit VARCHAR2(1) := FND_API.G_FALSE;
474: l_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL;
475: l_return_status VARCHAR2(1);
476: l_mesg_count number;
477: l_mesg VARCHAR2(4000);

Line 474: l_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL;

470: -- used for api call
471: l_api_version NUMBER := 1.0;
472: l_init_msg_list VARCHAR2(1) := FND_API.G_FALSE;
473: l_commit VARCHAR2(1) := FND_API.G_FALSE;
474: l_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL;
475: l_return_status VARCHAR2(1);
476: l_mesg_count number;
477: l_mesg VARCHAR2(4000);
478:

Line 727: p_init_msg_list => FND_API.G_FALSE,

723:
724:
725: FA_ADDITION_PUB.do_addition
726: (p_api_version => 1.0,
727: p_init_msg_list => FND_API.G_FALSE,
728: p_commit => FND_API.G_FALSE,
729: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
730: x_return_status => l_return_status,
731: x_msg_count => l_mesg_count,

Line 728: p_commit => FND_API.G_FALSE,

724:
725: FA_ADDITION_PUB.do_addition
726: (p_api_version => 1.0,
727: p_init_msg_list => FND_API.G_FALSE,
728: p_commit => FND_API.G_FALSE,
729: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
730: x_return_status => l_return_status,
731: x_msg_count => l_mesg_count,
732: x_msg_data => l_mesg,

Line 729: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

725: FA_ADDITION_PUB.do_addition
726: (p_api_version => 1.0,
727: p_init_msg_list => FND_API.G_FALSE,
728: p_commit => FND_API.G_FALSE,
729: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
730: x_return_status => l_return_status,
731: x_msg_count => l_mesg_count,
732: x_msg_data => l_mesg,
733: p_calling_fn => null,

Line 748: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then

744: px_inv_tbl => l_inv_tbl
745: );
746:
747:
748: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then
749: l_mesg_name := 'FA_MCP_FAIL_THID';
750: raise add_err2;
751: end if;
752: else --invalid

Line 773: X_return_status := FND_API.G_RET_STS_SUCCESS;

769: p_value => l_value,
770: p_mode => 'S',
771: p_log_level_rec => p_log_level_rec);
772:
773: X_return_status := FND_API.G_RET_STS_SUCCESS;
774:
775: EXCEPTION
776: when add_err1 then
777: -- non-fatal

Line 788: x_return_status := FND_API.G_RET_STS_ERROR;

784: p_mode => 'W',
785: p_log_level_rec => p_log_level_rec);
786: fa_srvr_msg.add_message(calling_fn => l_calling_fn,
787: p_log_level_rec => p_log_level_rec);
788: x_return_status := FND_API.G_RET_STS_ERROR;
789:
790: when add_err2 then
791: -- fatal
792: write_message

Line 802: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

798: p_mode => 'F',
799: p_log_level_rec => p_log_level_rec);
800: fa_srvr_msg.add_message(calling_fn => l_calling_fn,
801: p_log_level_rec => p_log_level_rec);
802: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
803:
804: when others then
805: -- fatal
806: fa_srvr_msg.add_sql_error(calling_fn => null

Line 818: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

814: p_mode => 'F',
815: p_log_level_rec => p_log_level_rec);
816: fa_srvr_msg.add_message(calling_fn => l_calling_fn,
817: p_log_level_rec => p_log_level_rec);
818: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
819:
820:
821: END mcp_addition;
822:

Line 903: l_init_msg_list VARCHAR2(1) := FND_API.G_FALSE;

899: l_tax_group_asset_id number;
900:
901: -- variables and structs used for api call
902: l_api_version NUMBER := 1.0;
903: l_init_msg_list VARCHAR2(1) := FND_API.G_FALSE;
904: l_commit VARCHAR2(1) := FND_API.G_FALSE;
905: l_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL;
906: l_return_status VARCHAR2(1);
907: l_mesg_count number;

Line 904: l_commit VARCHAR2(1) := FND_API.G_FALSE;

900:
901: -- variables and structs used for api call
902: l_api_version NUMBER := 1.0;
903: l_init_msg_list VARCHAR2(1) := FND_API.G_FALSE;
904: l_commit VARCHAR2(1) := FND_API.G_FALSE;
905: l_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL;
906: l_return_status VARCHAR2(1);
907: l_mesg_count number;
908: l_mesg VARCHAR2(4000);

Line 905: l_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL;

901: -- variables and structs used for api call
902: l_api_version NUMBER := 1.0;
903: l_init_msg_list VARCHAR2(1) := FND_API.G_FALSE;
904: l_commit VARCHAR2(1) := FND_API.G_FALSE;
905: l_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL;
906: l_return_status VARCHAR2(1);
907: l_mesg_count number;
908: l_mesg VARCHAR2(4000);
909:

Line 1464: l_asset_fin_rec_adj.group_asset_id := nvl(l_corp_new_group_asset_id, FND_API.G_MISS_NUM);

1460: from fa_transaction_headers m
1461: where m.transaction_header_id = p_corp_thid;
1462:
1463: -- set the group asset id for tax
1464: l_asset_fin_rec_adj.group_asset_id := nvl(l_corp_new_group_asset_id, FND_API.G_MISS_NUM);
1465:
1466: end if;
1467:
1468: */

Line 1499: p_init_msg_list => FND_API.G_FALSE,

1495: end if;
1496:
1497: FA_ADJUSTMENT_PUB.do_adjustment
1498: (p_api_version => 1.0,
1499: p_init_msg_list => FND_API.G_FALSE,
1500: p_commit => FND_API.G_FALSE,
1501: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1502: x_return_status => l_return_status,
1503: x_msg_count => l_mesg_count,

Line 1500: p_commit => FND_API.G_FALSE,

1496:
1497: FA_ADJUSTMENT_PUB.do_adjustment
1498: (p_api_version => 1.0,
1499: p_init_msg_list => FND_API.G_FALSE,
1500: p_commit => FND_API.G_FALSE,
1501: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1502: x_return_status => l_return_status,
1503: x_msg_count => l_mesg_count,
1504: x_msg_data => l_mesg,

Line 1501: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

1497: FA_ADJUSTMENT_PUB.do_adjustment
1498: (p_api_version => 1.0,
1499: p_init_msg_list => FND_API.G_FALSE,
1500: p_commit => FND_API.G_FALSE,
1501: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1502: x_return_status => l_return_status,
1503: x_msg_count => l_mesg_count,
1504: x_msg_data => l_mesg,
1505: p_calling_fn => l_calling_fn,

Line 1518: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then

1514: x_asset_deprn_rec_new => l_asset_deprn_rec_new,
1515: x_asset_deprn_mrc_tbl_new => l_asset_deprn_mrc_tbl_new,
1516: p_group_reclass_options_rec => l_group_reclass_options_rec);
1517:
1518: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then
1519: l_mesg_name := 'FA_MCP_FAIL_THID';
1520: raise adj_err2;
1521: end if;
1522:

Line 1535: X_return_status := FND_API.G_RET_STS_SUCCESS;

1531: p_value => l_value,
1532: p_mode => 'S',
1533: p_log_level_rec => p_log_level_rec);
1534:
1535: X_return_status := FND_API.G_RET_STS_SUCCESS;
1536:
1537: EXCEPTION
1538: when adj_err1 then
1539: -- non-fatal

Line 1551: x_return_status := FND_API.G_RET_STS_ERROR;

1547: p_log_level_rec => p_log_level_rec);
1548:
1549: fa_srvr_msg.add_message(calling_fn => l_calling_fn,
1550: p_log_level_rec => p_log_level_rec);
1551: x_return_status := FND_API.G_RET_STS_ERROR;
1552:
1553: when adj_err2 then
1554: -- fatal
1555: write_message

Line 1566: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1562: p_log_level_rec => p_log_level_rec);
1563:
1564: fa_srvr_msg.add_message(calling_fn => l_calling_fn,
1565: p_log_level_rec => p_log_level_rec);
1566: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1567:
1568: when others then
1569: -- fatal
1570: fa_srvr_msg.add_sql_error(calling_fn => null

Line 1583: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1579: p_log_level_rec => p_log_level_rec);
1580:
1581: fa_srvr_msg.add_message(calling_fn => l_calling_fn,
1582: p_log_level_rec => p_log_level_rec);
1583: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1584:
1585:
1586: END mcp_adjustment;
1587:

Line 1628: l_init_msg_list VARCHAR2(1) := FND_API.G_FALSE;

1624: l_trade_in_asset_id number(15);
1625:
1626: -- used for api call
1627: l_api_version NUMBER := 1.0;
1628: l_init_msg_list VARCHAR2(1) := FND_API.G_FALSE;
1629: l_commit VARCHAR2(1) := FND_API.G_FALSE;
1630: l_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL;
1631: l_return_status VARCHAR2(1);
1632: l_msg_count number;

Line 1629: l_commit VARCHAR2(1) := FND_API.G_FALSE;

1625:
1626: -- used for api call
1627: l_api_version NUMBER := 1.0;
1628: l_init_msg_list VARCHAR2(1) := FND_API.G_FALSE;
1629: l_commit VARCHAR2(1) := FND_API.G_FALSE;
1630: l_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL;
1631: l_return_status VARCHAR2(1);
1632: l_msg_count number;
1633: l_msg_data VARCHAR2(4000);

Line 1630: l_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL;

1626: -- used for api call
1627: l_api_version NUMBER := 1.0;
1628: l_init_msg_list VARCHAR2(1) := FND_API.G_FALSE;
1629: l_commit VARCHAR2(1) := FND_API.G_FALSE;
1630: l_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL;
1631: l_return_status VARCHAR2(1);
1632: l_msg_count number;
1633: l_msg_data VARCHAR2(4000);
1634:

Line 2008: l_asset_retire_rec.calculate_gain_loss := FND_API.G_TRUE;

2004: end if;
2005:
2006:
2007: -- insure we run gainloss
2008: l_asset_retire_rec.calculate_gain_loss := FND_API.G_TRUE;
2009: if (p_log_level_rec.statement_level) then
2010: fa_debug_pkg.add('test',
2011: 'calling',
2012: 'do reinstatement',

Line 2150: l_asset_retire_rec.calculate_gain_loss := FND_API.G_TRUE;

2146:
2147: l_asset_retire_rec.date_retired := l_trx_date_entered;
2148:
2149: -- insure we run gainloss
2150: l_asset_retire_rec.calculate_gain_loss := FND_API.G_TRUE;
2151:
2152: -- call the appropriate api
2153: -- passing calc_gain_loss flag as true
2154:

Line 2186: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then

2182: );
2183:
2184: end if; -- ret vs. reinstate
2185:
2186: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then
2187: l_mesg_name := 'FA_MCP_FAIL_THID';
2188: raise ret_err2;
2189: end if;
2190:

Line 2205: X_return_status := FND_API.G_RET_STS_SUCCESS;

2201: p_value => l_value,
2202: p_mode => 'S',
2203: p_log_level_rec => p_log_level_rec);
2204:
2205: X_return_status := FND_API.G_RET_STS_SUCCESS;
2206:
2207: EXCEPTION
2208: when ret_err1 then
2209: -- non-fatal

Line 2221: x_return_status := FND_API.G_RET_STS_ERROR;

2217: p_log_level_rec => p_log_level_rec);
2218:
2219: fa_srvr_msg.add_message(calling_fn => l_calling_fn,
2220: p_log_level_rec => p_log_level_rec);
2221: x_return_status := FND_API.G_RET_STS_ERROR;
2222:
2223: when ret_err2 then
2224: -- fatal
2225: write_message

Line 2236: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2232: p_log_level_rec => p_log_level_rec);
2233:
2234: fa_srvr_msg.add_message(calling_fn => l_calling_fn,
2235: p_log_level_rec => p_log_level_rec);
2236: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2237:
2238: when others then
2239: -- fatal
2240: fa_srvr_msg.add_sql_error(calling_fn => null

Line 2254: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2250:
2251:
2252: fa_srvr_msg.add_message(calling_fn => l_calling_fn,
2253: p_log_level_rec => p_log_level_rec);
2254: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2255:
2256: END mcp_retirement;
2257:
2258: ----------------------------------------------------------------