DBA Data[Home] [Help]

APPS.FA_TRANS_API_PUB dependencies on FND_API

Line 9: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,

5:
6: PROCEDURE do_addition (
7: -- Standard Parameters --
8: p_api_version IN NUMBER,
9: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
10: p_commit IN VARCHAR2 := FND_API.G_FALSE,
11: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
12: x_return_status OUT NOCOPY VARCHAR2,
13: x_msg_count OUT NOCOPY NUMBER,

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

6: PROCEDURE do_addition (
7: -- Standard Parameters --
8: p_api_version IN NUMBER,
9: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
10: p_commit IN VARCHAR2 := FND_API.G_FALSE,
11: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
12: x_return_status OUT NOCOPY VARCHAR2,
13: x_msg_count OUT NOCOPY NUMBER,
14: x_msg_data OUT NOCOPY VARCHAR2,

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

7: -- Standard Parameters --
8: p_api_version IN NUMBER,
9: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
10: p_commit IN VARCHAR2 := FND_API.G_FALSE,
11: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
12: x_return_status OUT NOCOPY VARCHAR2,
13: x_msg_count OUT NOCOPY NUMBER,
14: x_msg_data OUT NOCOPY VARCHAR2,
15: p_calling_fn IN VARCHAR2,

Line 292: IF FND_API.To_Boolean(p_init_msg_list) THEN

288: /* Etoru */
289:
290: BEGIN
291: -- Initialize message list if p_init_msg_list is set to TRUE.
292: IF FND_API.To_Boolean(p_init_msg_list) THEN
293: -- Initialize error message stack.
294: FA_SRVR_MSG.Init_Server_Message;
295:
296: -- Initialize debug message stack.

Line 731: l_asset_fin_rec.bonus_rule := FND_API.G_MISS_CHAR;

727: -- Check bonus rule. Can only be nulled out in Detail Add.
728: if ((p_bonus_rule is NULL) and
729: (p_calling_fn = 'fa_addition_eng.post_forms_commit')) then
730:
731: l_asset_fin_rec.bonus_rule := FND_API.G_MISS_CHAR;
732: end if;
733:
734: -- Check ceiling name. Can only be nulled out in Detail Add.
735: if ((p_ceiling_name is NULL) and

Line 738: l_asset_fin_rec.ceiling_name := FND_API.G_MISS_CHAR;

734: -- Check ceiling name. Can only be nulled out in Detail Add.
735: if ((p_ceiling_name is NULL) and
736: (p_calling_fn = 'fa_addition_eng.post_forms_commit')) then
737:
738: l_asset_fin_rec.ceiling_name := FND_API.G_MISS_CHAR;
739: end if;
740:
741: -- Check group_asset_id. Can be nulled out in Detail or Quick Add.
742: if (p_group_asset_id is NULL) then

Line 743: l_asset_fin_rec.group_asset_id := FND_API.G_MISS_NUM;

739: end if;
740:
741: -- Check group_asset_id. Can be nulled out in Detail or Quick Add.
742: if (p_group_asset_id is NULL) then
743: l_asset_fin_rec.group_asset_id := FND_API.G_MISS_NUM;
744: end if;
745: end if;
746:
747: -- Call the Public Additions API

Line 770: if (x_return_status <> FND_API.G_RET_STS_SUCCESS) then

766: px_asset_dist_tbl => l_asset_dist_tbl,
767: px_inv_tbl => l_inv_tbl
768: );
769:
770: if (x_return_status <> FND_API.G_RET_STS_SUCCESS) then
771: return;
772: end if;
773:
774: -- Set the output variables to return back to the calling program.

Line 784: x_return_status := FND_API.G_RET_STS_ERROR;

780: EXCEPTION
781: when others then
782: fa_srvr_msg.add_sql_error(calling_fn => 'fa_trans_api_pub.do_addition',
783: p_log_level_rec => g_log_level_rec);
784: x_return_status := FND_API.G_RET_STS_ERROR;
785:
786: END do_addition;
787:
788: PROCEDURE do_adjustment (

Line 791: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,

787:
788: PROCEDURE do_adjustment (
789: -- Standard Parameters --
790: p_api_version IN NUMBER,
791: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
792: p_commit IN VARCHAR2 := FND_API.G_FALSE,
793: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
794: x_return_status OUT NOCOPY VARCHAR2,
795: x_msg_count OUT NOCOPY NUMBER,

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

788: PROCEDURE do_adjustment (
789: -- Standard Parameters --
790: p_api_version IN NUMBER,
791: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
792: p_commit IN VARCHAR2 := FND_API.G_FALSE,
793: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
794: x_return_status OUT NOCOPY VARCHAR2,
795: x_msg_count OUT NOCOPY NUMBER,
796: x_msg_data OUT NOCOPY VARCHAR2,

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

789: -- Standard Parameters --
790: p_api_version IN NUMBER,
791: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
792: p_commit IN VARCHAR2 := FND_API.G_FALSE,
793: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
794: x_return_status OUT NOCOPY VARCHAR2,
795: x_msg_count OUT NOCOPY NUMBER,
796: x_msg_data OUT NOCOPY VARCHAR2,
797: p_calling_fn IN VARCHAR2,

Line 969: IF FND_API.To_Boolean(p_init_msg_list) THEN

965: l_group_reclass_options_rec fa_api_types.group_reclass_options_rec_type;
966:
967: BEGIN
968: -- Initialize message list if p_init_msg_list is set to TRUE.
969: IF FND_API.To_Boolean(p_init_msg_list) THEN
970: -- Initialize error message stack.
971: FA_SRVR_MSG.Init_Server_Message;
972:
973: -- Initialize debug message stack.

Line 1133: l_asset_fin_rec_adj.super_group_id := nvl(p_super_group_id, FND_API.G_MISS_NUM);

1129: p_allowed_deprn_limit_amount -
1130: nvl(l_asset_fin_rec_old.allowed_deprn_limit_amount, 0);
1131: end if; -- (l_asset_fin_rec_old.salvage_type <>
1132:
1133: l_asset_fin_rec_adj.super_group_id := nvl(p_super_group_id, FND_API.G_MISS_NUM);
1134: l_asset_fin_rec_adj.reduction_rate := nvl(p_reduction_rate, 0) -
1135: nvl(l_asset_fin_rec_old.reduction_rate, 0);
1136:
1137: l_asset_fin_rec_adj.reduce_addition_flag := p_reduce_addition_flag;

Line 1148: l_asset_fin_rec_adj.retirement_deprn_option := FND_API.G_MISS_CHAR;

1144: l_asset_fin_rec_adj.terminal_gain_loss := p_terminal_gain_loss;
1145: l_asset_fin_rec_adj.exclude_proceeds_from_basis := p_exclude_proceeds_from_basis;
1146:
1147: if (p_retirement_deprn_option is null) then
1148: l_asset_fin_rec_adj.retirement_deprn_option := FND_API.G_MISS_CHAR;
1149: else
1150: l_asset_fin_rec_adj.retirement_deprn_option := p_retirement_deprn_option;
1151: end if;
1152:

Line 1158: l_asset_fin_rec_adj.tracking_method := FND_API.G_MISS_CHAR;

1154: l_asset_fin_rec_adj.deprn_limit_type := p_deprn_limit_type;
1155: l_asset_fin_rec_adj.tracking_method := p_tracking_method;
1156:
1157: if (p_tracking_method is null) then
1158: l_asset_fin_rec_adj.tracking_method := FND_API.G_MISS_CHAR;
1159: else
1160: l_asset_fin_rec_adj.tracking_method := p_tracking_method;
1161: end if;
1162:

Line 1175: l_asset_fin_rec_adj.cash_generating_unit_id := FND_API.G_MISS_NUM;

1171: -- l_asset_fin_rec_adj.ltd_proceeds := p_ltd_proceeds;
1172: l_asset_fin_rec_adj.exclude_fully_rsv_flag := p_exclude_fully_rsv_flag;
1173:
1174: if (p_cash_generating_unit_id is null) then
1175: l_asset_fin_rec_adj.cash_generating_unit_id := FND_API.G_MISS_NUM;
1176: else
1177: l_asset_fin_rec_adj.cash_generating_unit_id := p_cash_generating_unit_id;
1178: end if;
1179:

Line 1398: if (x_return_status <> FND_API.G_RET_STS_SUCCESS) then

1394: px_inv_tbl => l_inv_tbl,
1395: p_group_reclass_options_rec => l_group_reclass_options_rec
1396: );
1397:
1398: if (x_return_status <> FND_API.G_RET_STS_SUCCESS) then
1399: return;
1400: end if;
1401:
1402: x_transaction_header_id := l_trans_rec.transaction_header_id;

Line 1408: x_return_status := FND_API.G_RET_STS_ERROR;

1404: EXCEPTION
1405: when adj_err then
1406: fa_srvr_msg.add_message(calling_fn => 'fa_trans_api_pub.do_adjustment',
1407: p_log_level_rec => g_log_level_rec);
1408: x_return_status := FND_API.G_RET_STS_ERROR;
1409:
1410: when others then
1411: fa_srvr_msg.add_sql_error(calling_fn => 'fa_trans_api_pub.do_adjustment',
1412: p_log_level_rec => g_log_level_rec);

Line 1413: x_return_status := FND_API.G_RET_STS_ERROR;

1409:
1410: when others then
1411: fa_srvr_msg.add_sql_error(calling_fn => 'fa_trans_api_pub.do_adjustment',
1412: p_log_level_rec => g_log_level_rec);
1413: x_return_status := FND_API.G_RET_STS_ERROR;
1414:
1415: END do_adjustment;
1416:
1417: PROCEDURE do_unit_adjustment (

Line 1420: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,

1416:
1417: PROCEDURE do_unit_adjustment (
1418: -- Standard Parameters --
1419: p_api_version IN NUMBER,
1420: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
1421: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1422: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1423: x_return_status OUT NOCOPY VARCHAR2,
1424: x_msg_count OUT NOCOPY NUMBER,

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

1417: PROCEDURE do_unit_adjustment (
1418: -- Standard Parameters --
1419: p_api_version IN NUMBER,
1420: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
1421: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1422: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1423: x_return_status OUT NOCOPY VARCHAR2,
1424: x_msg_count OUT NOCOPY NUMBER,
1425: x_msg_data OUT NOCOPY VARCHAR2,

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

1418: -- Standard Parameters --
1419: p_api_version IN NUMBER,
1420: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
1421: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1422: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1423: x_return_status OUT NOCOPY VARCHAR2,
1424: x_msg_count OUT NOCOPY NUMBER,
1425: x_msg_data OUT NOCOPY VARCHAR2,
1426: p_calling_fn IN VARCHAR2,

Line 1471: IF FND_API.To_Boolean(p_init_msg_list) THEN

1467:
1468: BEGIN
1469:
1470: -- Initialize message list if p_init_msg_list is set to TRUE.
1471: IF FND_API.To_Boolean(p_init_msg_list) THEN
1472: -- Initialize error message stack.
1473: FA_SRVR_MSG.Init_Server_Message;
1474:
1475: -- Initialize debug message stack.

Line 1565: if (x_return_status <> FND_API.G_RET_STS_SUCCESS) then

1561: px_trans_rec => l_trans_rec,
1562: px_asset_hdr_rec => l_asset_hdr_rec,
1563: px_asset_dist_tbl => l_asset_dist_tbl);
1564:
1565: if (x_return_status <> FND_API.G_RET_STS_SUCCESS) then
1566: return;
1567: end if;
1568:
1569: x_transaction_header_id := l_trans_rec.transaction_header_id;

Line 1575: x_return_status := FND_API.G_RET_STS_ERROR;

1571: EXCEPTION
1572: when others then
1573: fa_srvr_msg.add_sql_error(calling_fn => 'fa_trans_api_pub.do_unit_adj',
1574: p_log_level_rec => g_log_level_rec);
1575: x_return_status := FND_API.G_RET_STS_ERROR;
1576:
1577: END do_unit_adjustment;
1578:
1579: PROCEDURE do_transfer (

Line 1582: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,

1578:
1579: PROCEDURE do_transfer (
1580: -- Standard Parameters --
1581: p_api_version IN NUMBER,
1582: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
1583: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1584: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1585: x_return_status OUT NOCOPY VARCHAR2,
1586: x_msg_count OUT NOCOPY NUMBER,

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

1579: PROCEDURE do_transfer (
1580: -- Standard Parameters --
1581: p_api_version IN NUMBER,
1582: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
1583: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1584: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1585: x_return_status OUT NOCOPY VARCHAR2,
1586: x_msg_count OUT NOCOPY NUMBER,
1587: x_msg_data OUT NOCOPY VARCHAR2,

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

1580: -- Standard Parameters --
1581: p_api_version IN NUMBER,
1582: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
1583: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1584: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1585: x_return_status OUT NOCOPY VARCHAR2,
1586: x_msg_count OUT NOCOPY NUMBER,
1587: x_msg_data OUT NOCOPY VARCHAR2,
1588: p_calling_fn IN VARCHAR2,

Line 1633: IF FND_API.To_Boolean(p_init_msg_list) THEN

1629:
1630: BEGIN
1631:
1632: -- Initialize message list if p_init_msg_list is set to TRUE.
1633: IF FND_API.To_Boolean(p_init_msg_list) THEN
1634: -- Initialize error message stack.
1635: FA_SRVR_MSG.Init_Server_Message;
1636:
1637: -- Initialize debug message stack.

Line 1727: if (x_return_status <> FND_API.G_RET_STS_SUCCESS) then

1723: px_trans_rec => l_trans_rec,
1724: px_asset_hdr_rec => l_asset_hdr_rec,
1725: px_asset_dist_tbl => l_asset_dist_tbl);
1726:
1727: if (x_return_status <> FND_API.G_RET_STS_SUCCESS) then
1728: return;
1729: end if;
1730:
1731: x_transaction_header_id := l_trans_rec.transaction_header_id;

Line 1737: x_return_status := FND_API.G_RET_STS_ERROR;

1733: EXCEPTION
1734: when others then
1735: fa_srvr_msg.add_sql_error(calling_fn => 'fa_trans_api_pub.do_transfer',
1736: p_log_level_rec => g_log_level_rec);
1737: x_return_status := FND_API.G_RET_STS_ERROR;
1738:
1739: END do_transfer;
1740:
1741: PROCEDURE do_invoice_transfer (

Line 1744: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,

1740:
1741: PROCEDURE do_invoice_transfer (
1742: -- Standard Parameters --
1743: p_api_version IN NUMBER,
1744: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
1745: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1746: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1747: x_return_status OUT NOCOPY VARCHAR2,
1748: x_msg_count OUT NOCOPY NUMBER,

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

1741: PROCEDURE do_invoice_transfer (
1742: -- Standard Parameters --
1743: p_api_version IN NUMBER,
1744: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
1745: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1746: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1747: x_return_status OUT NOCOPY VARCHAR2,
1748: x_msg_count OUT NOCOPY NUMBER,
1749: x_msg_data OUT NOCOPY VARCHAR2,

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

1742: -- Standard Parameters --
1743: p_api_version IN NUMBER,
1744: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
1745: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1746: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1747: x_return_status OUT NOCOPY VARCHAR2,
1748: x_msg_count OUT NOCOPY NUMBER,
1749: x_msg_data OUT NOCOPY VARCHAR2,
1750: p_calling_fn IN VARCHAR2,

Line 1784: IF FND_API.To_Boolean(p_init_msg_list) THEN

1780:
1781: BEGIN
1782:
1783: -- Initialize message list if p_init_msg_list is set to TRUE.
1784: IF FND_API.To_Boolean(p_init_msg_list) THEN
1785: -- Initialize error message stack.
1786: FA_SRVR_MSG.Init_Server_Message;
1787:
1788: -- Initialize debug message stack.

Line 1980: if (x_return_status <> FND_API.G_RET_STS_SUCCESS) then

1976: px_dest_asset_hdr_rec => l_dest_asset_hdr_rec,
1977: p_inv_tbl => l_inv_tbl
1978: );
1979:
1980: if (x_return_status <> FND_API.G_RET_STS_SUCCESS) then
1981: return;
1982: end if;
1983:
1984: x_src_transaction_header_id := l_src_trans_rec.transaction_header_id;

Line 1991: x_return_status := FND_API.G_RET_STS_ERROR;

1987: EXCEPTION
1988: when others then
1989: fa_srvr_msg.add_sql_error(calling_fn => 'fa_trans_api_pub.do_inv_xfr',
1990: p_log_level_rec => g_log_level_rec);
1991: x_return_status := FND_API.G_RET_STS_ERROR;
1992:
1993: END do_invoice_transfer;
1994:
1995: PROCEDURE do_reclass (

Line 1998: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,

1994:
1995: PROCEDURE do_reclass (
1996: -- Standard Parameters --
1997: p_api_version IN NUMBER,
1998: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
1999: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2000: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2001: x_return_status OUT NOCOPY VARCHAR2,
2002: x_msg_count OUT NOCOPY NUMBER,

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

1995: PROCEDURE do_reclass (
1996: -- Standard Parameters --
1997: p_api_version IN NUMBER,
1998: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
1999: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2000: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2001: x_return_status OUT NOCOPY VARCHAR2,
2002: x_msg_count OUT NOCOPY NUMBER,
2003: x_msg_data OUT NOCOPY VARCHAR2,

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

1996: -- Standard Parameters --
1997: p_api_version IN NUMBER,
1998: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
1999: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2000: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2001: x_return_status OUT NOCOPY VARCHAR2,
2002: x_msg_count OUT NOCOPY NUMBER,
2003: x_msg_data OUT NOCOPY VARCHAR2,
2004: p_calling_fn IN VARCHAR2,

Line 2086: IF FND_API.To_Boolean(p_init_msg_list) THEN

2082:
2083: BEGIN
2084:
2085: -- Initialize message list if p_init_msg_list is set to TRUE.
2086: IF FND_API.To_Boolean(p_init_msg_list) THEN
2087: -- Initialize error message stack.
2088: FA_SRVR_MSG.Init_Server_Message;
2089:
2090: -- Initialize debug message stack.

Line 2203: if (x_return_status <> FND_API.G_RET_STS_SUCCESS) then

2199: px_asset_hdr_rec => l_asset_hdr_rec,
2200: px_asset_cat_rec_new => l_asset_cat_rec_new,
2201: p_recl_opt_rec => l_reclass_options_rec);
2202:
2203: if (x_return_status <> FND_API.G_RET_STS_SUCCESS) then
2204: return;
2205: end if;
2206:
2207: x_transaction_header_id := l_trans_rec.transaction_header_id;

Line 2213: x_return_status := FND_API.G_RET_STS_ERROR;

2209: EXCEPTION
2210: when others then
2211: fa_srvr_msg.add_sql_error(calling_fn => 'fa_trans_api_pub.do_reclass',
2212: p_log_level_rec => g_log_level_rec);
2213: x_return_status := FND_API.G_RET_STS_ERROR;
2214:
2215: END do_reclass;
2216:
2217: PROCEDURE do_retirement (

Line 2220: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,

2216:
2217: PROCEDURE do_retirement (
2218: -- Standard Parameters --
2219: p_api_version IN NUMBER,
2220: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
2221: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2222: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2223: x_return_status OUT NOCOPY VARCHAR2,
2224: x_msg_count OUT NOCOPY NUMBER,

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

2217: PROCEDURE do_retirement (
2218: -- Standard Parameters --
2219: p_api_version IN NUMBER,
2220: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
2221: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2222: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2223: x_return_status OUT NOCOPY VARCHAR2,
2224: x_msg_count OUT NOCOPY NUMBER,
2225: x_msg_data OUT NOCOPY VARCHAR2,

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

2218: -- Standard Parameters --
2219: p_api_version IN NUMBER,
2220: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
2221: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2222: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2223: x_return_status OUT NOCOPY VARCHAR2,
2224: x_msg_count OUT NOCOPY NUMBER,
2225: x_msg_data OUT NOCOPY VARCHAR2,
2226: p_calling_fn IN VARCHAR2,

Line 2282: p_calculate_gain_loss IN VARCHAR2 DEFAULT FND_API.G_FALSE,

2278: p_asset_id IN NUMBER,
2279: p_book_type_code IN VARCHAR2,
2280: p_set_of_books_id IN NUMBER DEFAULT NULL,
2281: -- Asset Retirement Info --
2282: p_calculate_gain_loss IN VARCHAR2 DEFAULT FND_API.G_FALSE,
2283: p_units_retired IN NUMBER DEFAULT NULL,
2284: p_cost_retired IN NUMBER DEFAULT NULL,
2285: p_proceeds_of_sale IN NUMBER DEFAULT NULL,
2286: p_cost_of_removal IN NUMBER DEFAULT NULL,

Line 2334: IF FND_API.To_Boolean(p_init_msg_list) THEN

2330:
2331: BEGIN
2332:
2333: -- Initialize message list if p_init_msg_list is set to TRUE.
2334: IF FND_API.To_Boolean(p_init_msg_list) THEN
2335: -- Initialize error message stack.
2336: FA_SRVR_MSG.Init_Server_Message;
2337:
2338: -- Initialize debug message stack.

Line 2585: if (x_return_status <> FND_API.G_RET_STS_SUCCESS) then

2581: p_asset_dist_tbl => l_asset_dist_tbl,
2582: p_subcomp_tbl => l_subcomp_tbl,
2583: p_inv_tbl => l_inv_tbl);
2584:
2585: if (x_return_status <> FND_API.G_RET_STS_SUCCESS) then
2586: return;
2587: end if;
2588:
2589: x_retirement_id := l_asset_retire_rec.retirement_id;

Line 2597: x_return_status := FND_API.G_RET_STS_ERROR;

2593: EXCEPTION
2594: when others then
2595: fa_srvr_msg.add_sql_error(calling_fn => 'fa_trans_api_pub.do_retirement',
2596: p_log_level_rec => g_log_level_rec);
2597: x_return_status := FND_API.G_RET_STS_ERROR;
2598:
2599: END do_retirement;
2600:
2601: PROCEDURE undo_retirement (

Line 2604: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,

2600:
2601: PROCEDURE undo_retirement (
2602: -- Standard Parameters --
2603: p_api_version IN NUMBER,
2604: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
2605: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2606: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2607: x_return_status OUT NOCOPY VARCHAR2,
2608: x_msg_count OUT NOCOPY NUMBER,

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

2601: PROCEDURE undo_retirement (
2602: -- Standard Parameters --
2603: p_api_version IN NUMBER,
2604: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
2605: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2606: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2607: x_return_status OUT NOCOPY VARCHAR2,
2608: x_msg_count OUT NOCOPY NUMBER,
2609: x_msg_data OUT NOCOPY VARCHAR2,

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

2602: -- Standard Parameters --
2603: p_api_version IN NUMBER,
2604: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
2605: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2606: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2607: x_return_status OUT NOCOPY VARCHAR2,
2608: x_msg_count OUT NOCOPY NUMBER,
2609: x_msg_data OUT NOCOPY VARCHAR2,
2610: p_calling_fn IN VARCHAR2,

Line 2633: IF FND_API.To_Boolean(p_init_msg_list) THEN

2629:
2630: BEGIN
2631:
2632: -- Initialize message list if p_init_msg_list is set to TRUE.
2633: IF FND_API.To_Boolean(p_init_msg_list) THEN
2634: -- Initialize error message stack.
2635: FA_SRVR_MSG.Init_Server_Message;
2636:
2637: -- Initialize debug message stack.

Line 2739: if (x_return_status <> FND_API.G_RET_STS_SUCCESS) then

2735: px_asset_hdr_rec => l_asset_hdr_rec,
2736: px_asset_retire_rec => l_asset_retire_rec
2737: );
2738:
2739: if (x_return_status <> FND_API.G_RET_STS_SUCCESS) then
2740: return;
2741: end if;
2742:
2743: EXCEPTION

Line 2747: x_return_status := FND_API.G_RET_STS_ERROR;

2743: EXCEPTION
2744: when others then
2745: fa_srvr_msg.add_sql_error(calling_fn => 'fa_trans_api_pub.undo_ret',
2746: p_log_level_rec => g_log_level_rec);
2747: x_return_status := FND_API.G_RET_STS_ERROR;
2748:
2749: END undo_retirement;
2750:
2751: PROCEDURE do_reinstatement (

Line 2754: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,

2750:
2751: PROCEDURE do_reinstatement (
2752: -- Standard Parameters --
2753: p_api_version IN NUMBER,
2754: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
2755: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2756: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2757: x_return_status OUT NOCOPY VARCHAR2,
2758: x_msg_count OUT NOCOPY NUMBER,

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

2751: PROCEDURE do_reinstatement (
2752: -- Standard Parameters --
2753: p_api_version IN NUMBER,
2754: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
2755: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2756: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2757: x_return_status OUT NOCOPY VARCHAR2,
2758: x_msg_count OUT NOCOPY NUMBER,
2759: x_msg_data OUT NOCOPY VARCHAR2,

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

2752: -- Standard Parameters --
2753: p_api_version IN NUMBER,
2754: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
2755: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2756: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2757: x_return_status OUT NOCOPY VARCHAR2,
2758: x_msg_count OUT NOCOPY NUMBER,
2759: x_msg_data OUT NOCOPY VARCHAR2,
2760: p_calling_fn IN VARCHAR2,

Line 2796: p_calculate_gain_loss IN VARCHAR2 DEFAULT FND_API.G_FALSE,

2792: p_asset_id IN NUMBER,
2793: p_book_type_code IN VARCHAR2,
2794: p_set_of_books_id IN NUMBER DEFAULT NULL,
2795: -- Asset Retirement Info --
2796: p_calculate_gain_loss IN VARCHAR2 DEFAULT FND_API.G_FALSE,
2797: p_retirement_id IN NUMBER DEFAULT NULL,
2798: p_proceeds_of_sale IN NUMBER DEFAULT NULL,
2799: p_cost_of_removal IN NUMBER DEFAULT NULL,
2800: p_retirement_type_code IN VARCHAR2 DEFAULT NULL,

Line 2837: IF FND_API.To_Boolean(p_init_msg_list) THEN

2833:
2834: BEGIN
2835:
2836: -- Initialize message list if p_init_msg_list is set to TRUE.
2837: IF FND_API.To_Boolean(p_init_msg_list) THEN
2838: -- Initialize error message stack.
2839: FA_SRVR_MSG.Init_Server_Message;
2840:
2841: -- Initialize debug message stack.

Line 3048: if (x_return_status <> FND_API.G_RET_STS_SUCCESS) then

3044: p_asset_dist_tbl => l_asset_dist_tbl,
3045: p_subcomp_tbl => l_subcomp_tbl,
3046: p_inv_tbl => l_inv_tbl);
3047:
3048: if (x_return_status <> FND_API.G_RET_STS_SUCCESS) then
3049: return;
3050: end if;
3051:
3052: x_transaction_header_id := l_trans_rec.transaction_header_id;

Line 3058: x_return_status := FND_API.G_RET_STS_ERROR;

3054: EXCEPTION
3055: when others then
3056: fa_srvr_msg.add_sql_error(calling_fn => 'fa_trans_api_pub.do_reinst',
3057: p_log_level_rec => g_log_level_rec);
3058: x_return_status := FND_API.G_RET_STS_ERROR;
3059:
3060: END do_reinstatement;
3061:
3062: PROCEDURE undo_reinstatement (

Line 3065: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,

3061:
3062: PROCEDURE undo_reinstatement (
3063: -- Standard Parameters --
3064: p_api_version IN NUMBER,
3065: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
3066: p_commit IN VARCHAR2 := FND_API.G_FALSE,
3067: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
3068: x_return_status OUT NOCOPY VARCHAR2,
3069: x_msg_count OUT NOCOPY NUMBER,

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

3062: PROCEDURE undo_reinstatement (
3063: -- Standard Parameters --
3064: p_api_version IN NUMBER,
3065: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
3066: p_commit IN VARCHAR2 := FND_API.G_FALSE,
3067: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
3068: x_return_status OUT NOCOPY VARCHAR2,
3069: x_msg_count OUT NOCOPY NUMBER,
3070: x_msg_data OUT NOCOPY VARCHAR2,

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

3063: -- Standard Parameters --
3064: p_api_version IN NUMBER,
3065: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
3066: p_commit IN VARCHAR2 := FND_API.G_FALSE,
3067: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
3068: x_return_status OUT NOCOPY VARCHAR2,
3069: x_msg_count OUT NOCOPY NUMBER,
3070: x_msg_data OUT NOCOPY VARCHAR2,
3071: p_calling_fn IN VARCHAR2,

Line 3094: IF FND_API.To_Boolean(p_init_msg_list) THEN

3090:
3091: BEGIN
3092:
3093: -- Initialize message list if p_init_msg_list is set to TRUE.
3094: IF FND_API.To_Boolean(p_init_msg_list) THEN
3095: -- Initialize error message stack.
3096: FA_SRVR_MSG.Init_Server_Message;
3097:
3098: -- Initialize debug message stack.

Line 3201: if (x_return_status <> FND_API.G_RET_STS_SUCCESS) then

3197: px_asset_hdr_rec => l_asset_hdr_rec,
3198: px_asset_retire_rec => l_asset_retire_rec
3199: );
3200:
3201: if (x_return_status <> FND_API.G_RET_STS_SUCCESS) then
3202: return;
3203: end if;
3204:
3205: EXCEPTION

Line 3209: x_return_status := FND_API.G_RET_STS_ERROR;

3205: EXCEPTION
3206: when others then
3207: fa_srvr_msg.add_sql_error(calling_fn => 'fa_trans_api_pub.undo_reinst',
3208: p_log_level_rec => g_log_level_rec);
3209: x_return_status := FND_API.G_RET_STS_ERROR;
3210:
3211: END undo_reinstatement;
3212:
3213: PROCEDURE do_capitalization (

Line 3216: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,

3212:
3213: PROCEDURE do_capitalization (
3214: -- Standard Parameters --
3215: p_api_version IN NUMBER,
3216: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
3217: p_commit IN VARCHAR2 := FND_API.G_FALSE,
3218: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
3219: x_return_status OUT NOCOPY VARCHAR2,
3220: x_msg_count OUT NOCOPY NUMBER,

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

3213: PROCEDURE do_capitalization (
3214: -- Standard Parameters --
3215: p_api_version IN NUMBER,
3216: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
3217: p_commit IN VARCHAR2 := FND_API.G_FALSE,
3218: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
3219: x_return_status OUT NOCOPY VARCHAR2,
3220: x_msg_count OUT NOCOPY NUMBER,
3221: x_msg_data OUT NOCOPY VARCHAR2,

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

3214: -- Standard Parameters --
3215: p_api_version IN NUMBER,
3216: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
3217: p_commit IN VARCHAR2 := FND_API.G_FALSE,
3218: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
3219: x_return_status OUT NOCOPY VARCHAR2,
3220: x_msg_count OUT NOCOPY NUMBER,
3221: x_msg_data OUT NOCOPY VARCHAR2,
3222: p_calling_fn IN VARCHAR2,

Line 3268: IF FND_API.To_Boolean(p_init_msg_list) THEN

3264:
3265: BEGIN
3266:
3267: -- Initialize message list if p_init_msg_list is set to TRUE.
3268: IF FND_API.To_Boolean(p_init_msg_list) THEN
3269: -- Initialize error message stack.
3270: FA_SRVR_MSG.Init_Server_Message;
3271:
3272: -- Initialize debug message stack.

Line 3347: if (x_return_status <> FND_API.G_RET_STS_SUCCESS) then

3343: px_trans_rec => l_trans_rec,
3344: px_asset_hdr_rec => l_asset_hdr_rec,
3345: px_asset_fin_rec => l_asset_fin_rec);
3346:
3347: if (x_return_status <> FND_API.G_RET_STS_SUCCESS) then
3348: return;
3349: end if;
3350:
3351: x_transaction_header_id := l_trans_rec.transaction_header_id;

Line 3357: x_return_status := FND_API.G_RET_STS_ERROR;

3353: EXCEPTION
3354: when others then
3355: fa_srvr_msg.add_sql_error(calling_fn => 'fa_trans_api_pub.do_cap',
3356: p_log_level_rec => g_log_level_rec);
3357: x_return_status := FND_API.G_RET_STS_ERROR;
3358: END do_capitalization;
3359:
3360: PROCEDURE do_reverse (
3361: -- Standard Parameters --

Line 3363: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,

3359:
3360: PROCEDURE do_reverse (
3361: -- Standard Parameters --
3362: p_api_version IN NUMBER,
3363: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
3364: p_commit IN VARCHAR2 := FND_API.G_FALSE,
3365: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
3366: x_return_status OUT NOCOPY VARCHAR2,
3367: x_msg_count OUT NOCOPY NUMBER,

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

3360: PROCEDURE do_reverse (
3361: -- Standard Parameters --
3362: p_api_version IN NUMBER,
3363: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
3364: p_commit IN VARCHAR2 := FND_API.G_FALSE,
3365: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
3366: x_return_status OUT NOCOPY VARCHAR2,
3367: x_msg_count OUT NOCOPY NUMBER,
3368: x_msg_data OUT NOCOPY VARCHAR2,

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

3361: -- Standard Parameters --
3362: p_api_version IN NUMBER,
3363: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
3364: p_commit IN VARCHAR2 := FND_API.G_FALSE,
3365: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
3366: x_return_status OUT NOCOPY VARCHAR2,
3367: x_msg_count OUT NOCOPY NUMBER,
3368: x_msg_data OUT NOCOPY VARCHAR2,
3369: p_calling_fn IN VARCHAR2,

Line 3415: IF FND_API.To_Boolean(p_init_msg_list) THEN

3411:
3412: BEGIN
3413:
3414: -- Initialize message list if p_init_msg_list is set to TRUE.
3415: IF FND_API.To_Boolean(p_init_msg_list) THEN
3416: -- Initialize error message stack.
3417: FA_SRVR_MSG.Init_Server_Message;
3418:
3419: -- Initialize debug message stack.

Line 3494: if (x_return_status <> FND_API.G_RET_STS_SUCCESS) then

3490: px_trans_rec => l_trans_rec,
3491: px_asset_hdr_rec => l_asset_hdr_rec,
3492: px_asset_fin_rec => l_asset_fin_rec);
3493:
3494: if (x_return_status <> FND_API.G_RET_STS_SUCCESS) then
3495: return;
3496: end if;
3497:
3498: x_transaction_header_id := l_trans_rec.transaction_header_id;

Line 3504: x_return_status := FND_API.G_RET_STS_ERROR;

3500: EXCEPTION
3501: when others then
3502: fa_srvr_msg.add_sql_error(calling_fn => 'fa_trans_api_pub.do_rev',
3503: p_log_level_rec => g_log_level_rec);
3504: x_return_status := FND_API.G_RET_STS_ERROR;
3505: END do_reverse;
3506:
3507: PROCEDURE do_asset_desc_update (
3508: -- Standard Parameters --

Line 3510: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,

3506:
3507: PROCEDURE do_asset_desc_update (
3508: -- Standard Parameters --
3509: p_api_version IN NUMBER,
3510: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
3511: p_commit IN VARCHAR2 := FND_API.G_FALSE,
3512: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
3513: x_return_status OUT NOCOPY VARCHAR2,
3514: x_msg_count OUT NOCOPY NUMBER,

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

3507: PROCEDURE do_asset_desc_update (
3508: -- Standard Parameters --
3509: p_api_version IN NUMBER,
3510: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
3511: p_commit IN VARCHAR2 := FND_API.G_FALSE,
3512: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
3513: x_return_status OUT NOCOPY VARCHAR2,
3514: x_msg_count OUT NOCOPY NUMBER,
3515: x_msg_data OUT NOCOPY VARCHAR2,

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

3508: -- Standard Parameters --
3509: p_api_version IN NUMBER,
3510: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
3511: p_commit IN VARCHAR2 := FND_API.G_FALSE,
3512: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
3513: x_return_status OUT NOCOPY VARCHAR2,
3514: x_msg_count OUT NOCOPY NUMBER,
3515: x_msg_data OUT NOCOPY VARCHAR2,
3516: p_calling_fn IN VARCHAR2,

Line 3632: IF FND_API.To_Boolean(p_init_msg_list) THEN

3628:
3629: BEGIN
3630:
3631: -- Initialize message list if p_init_msg_list is set to TRUE.
3632: IF FND_API.To_Boolean(p_init_msg_list) THEN
3633: -- Initialize error message stack.
3634: FA_SRVR_MSG.Init_Server_Message;
3635:
3636: -- Initialize debug message stack.

Line 3833: if (x_return_status <> FND_API.G_RET_STS_SUCCESS) then

3829: px_asset_hdr_rec => l_asset_hdr_rec,
3830: px_asset_desc_rec_new => l_asset_desc_rec,
3831: px_asset_cat_rec_new => l_asset_cat_rec);
3832:
3833: if (x_return_status <> FND_API.G_RET_STS_SUCCESS) then
3834: return;
3835: end if;
3836:
3837: EXCEPTION

Line 3841: x_return_status := FND_API.G_RET_STS_ERROR;

3837: EXCEPTION
3838: when desc_err then
3839: fa_srvr_msg.add_message(calling_fn => 'fa_trans_api_pub.do_desc_update',
3840: p_log_level_rec => g_log_level_rec);
3841: x_return_status := FND_API.G_RET_STS_ERROR;
3842: when others then
3843: fa_srvr_msg.add_sql_error(calling_fn => 'fa_trans_api_pub.do_desc_update',
3844: p_log_level_rec => g_log_level_rec);
3845: x_return_status := FND_API.G_RET_STS_ERROR;

Line 3845: x_return_status := FND_API.G_RET_STS_ERROR;

3841: x_return_status := FND_API.G_RET_STS_ERROR;
3842: when others then
3843: fa_srvr_msg.add_sql_error(calling_fn => 'fa_trans_api_pub.do_desc_update',
3844: p_log_level_rec => g_log_level_rec);
3845: x_return_status := FND_API.G_RET_STS_ERROR;
3846: END do_asset_desc_update;
3847:
3848: PROCEDURE do_invoice_desc_update (
3849: -- Standard Parameters --

Line 3851: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,

3847:
3848: PROCEDURE do_invoice_desc_update (
3849: -- Standard Parameters --
3850: p_api_version IN NUMBER,
3851: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
3852: p_commit IN VARCHAR2 := FND_API.G_FALSE,
3853: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
3854: x_return_status OUT NOCOPY VARCHAR2,
3855: x_msg_count OUT NOCOPY NUMBER,

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

3848: PROCEDURE do_invoice_desc_update (
3849: -- Standard Parameters --
3850: p_api_version IN NUMBER,
3851: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
3852: p_commit IN VARCHAR2 := FND_API.G_FALSE,
3853: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
3854: x_return_status OUT NOCOPY VARCHAR2,
3855: x_msg_count OUT NOCOPY NUMBER,
3856: x_msg_data OUT NOCOPY VARCHAR2,

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

3849: -- Standard Parameters --
3850: p_api_version IN NUMBER,
3851: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
3852: p_commit IN VARCHAR2 := FND_API.G_FALSE,
3853: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
3854: x_return_status OUT NOCOPY VARCHAR2,
3855: x_msg_count OUT NOCOPY NUMBER,
3856: x_msg_data OUT NOCOPY VARCHAR2,
3857: p_calling_fn IN VARCHAR2,

Line 3882: IF FND_API.To_Boolean(p_init_msg_list) THEN

3878:
3879: BEGIN
3880:
3881: -- Initialize message list if p_init_msg_list is set to TRUE.
3882: IF FND_API.To_Boolean(p_init_msg_list) THEN
3883: -- Initialize error message stack.
3884: FA_SRVR_MSG.Init_Server_Message;
3885:
3886: -- Initialize debug message stack.

Line 4041: if (x_return_status <> FND_API.G_RET_STS_SUCCESS) then

4037: px_trans_rec => l_trans_rec,
4038: px_asset_hdr_rec => l_asset_hdr_rec,
4039: px_inv_tbl_new => l_inv_tbl);
4040:
4041: if (x_return_status <> FND_API.G_RET_STS_SUCCESS) then
4042: return;
4043: end if;
4044:
4045: EXCEPTION

Line 4049: x_return_status := FND_API.G_RET_STS_ERROR;

4045: EXCEPTION
4046: when desc_err then
4047: fa_srvr_msg.add_message(calling_fn => 'fa_trans_api_pub.do_inv_desc_upd',
4048: p_log_level_rec => g_log_level_rec);
4049: x_return_status := FND_API.G_RET_STS_ERROR;
4050:
4051: when others then
4052: fa_srvr_msg.add_sql_error(calling_fn => 'fa_trans_api_pub.do_inv_desc_upd',
4053: p_log_level_rec => g_log_level_rec);

Line 4054: x_return_status := FND_API.G_RET_STS_ERROR;

4050:
4051: when others then
4052: fa_srvr_msg.add_sql_error(calling_fn => 'fa_trans_api_pub.do_inv_desc_upd',
4053: p_log_level_rec => g_log_level_rec);
4054: x_return_status := FND_API.G_RET_STS_ERROR;
4055:
4056: END do_invoice_desc_update;
4057:
4058: PROCEDURE do_retirement_desc_update (

Line 4061: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,

4057:
4058: PROCEDURE do_retirement_desc_update (
4059: -- Standard Parameters --
4060: p_api_version IN NUMBER,
4061: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
4062: p_commit IN VARCHAR2 := FND_API.G_FALSE,
4063: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
4064: x_return_status OUT NOCOPY VARCHAR2,
4065: x_msg_count OUT NOCOPY NUMBER,

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

4058: PROCEDURE do_retirement_desc_update (
4059: -- Standard Parameters --
4060: p_api_version IN NUMBER,
4061: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
4062: p_commit IN VARCHAR2 := FND_API.G_FALSE,
4063: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
4064: x_return_status OUT NOCOPY VARCHAR2,
4065: x_msg_count OUT NOCOPY NUMBER,
4066: x_msg_data OUT NOCOPY VARCHAR2,

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

4059: -- Standard Parameters --
4060: p_api_version IN NUMBER,
4061: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
4062: p_commit IN VARCHAR2 := FND_API.G_FALSE,
4063: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
4064: x_return_status OUT NOCOPY VARCHAR2,
4065: x_msg_count OUT NOCOPY NUMBER,
4066: x_msg_data OUT NOCOPY VARCHAR2,
4067: p_calling_fn IN VARCHAR2,

Line 4117: IF FND_API.To_Boolean(p_init_msg_list) THEN

4113:
4114: BEGIN
4115:
4116: -- Initialize message list if p_init_msg_list is set to TRUE.
4117: IF FND_API.To_Boolean(p_init_msg_list) THEN
4118: -- Initialize error message stack.
4119: FA_SRVR_MSG.Init_Server_Message;
4120:
4121: -- Initialize debug message stack.

Line 4233: if (x_return_status <> FND_API.G_RET_STS_SUCCESS) then

4229: px_trans_rec => l_trans_rec,
4230: px_asset_hdr_rec => l_asset_hdr_rec,
4231: px_asset_retire_rec_new => l_asset_retire_rec);
4232:
4233: if (x_return_status <> FND_API.G_RET_STS_SUCCESS) then
4234: return;
4235: end if;
4236:
4237: EXCEPTION

Line 4241: x_return_status := FND_API.G_RET_STS_ERROR;

4237: EXCEPTION
4238: when desc_err then
4239: fa_srvr_msg.add_message(calling_fn => 'fa_trans_api_pub.do_ret_desc_upd',
4240: p_log_level_rec => g_log_level_rec);
4241: x_return_status := FND_API.G_RET_STS_ERROR;
4242:
4243: when others then
4244: fa_srvr_msg.add_sql_error(calling_fn => 'fa_trans_api_pub.do_ret_desc_upd',
4245: p_log_level_rec => g_log_level_rec);

Line 4246: x_return_status := FND_API.G_RET_STS_ERROR;

4242:
4243: when others then
4244: fa_srvr_msg.add_sql_error(calling_fn => 'fa_trans_api_pub.do_ret_desc_upd',
4245: p_log_level_rec => g_log_level_rec);
4246: x_return_status := FND_API.G_RET_STS_ERROR;
4247:
4248: END do_retirement_desc_update;
4249:
4250: PROCEDURE do_unplanned (

Line 4253: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,

4249:
4250: PROCEDURE do_unplanned (
4251: -- Standard Parameters --
4252: p_api_version IN NUMBER,
4253: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
4254: p_commit IN VARCHAR2 := FND_API.G_FALSE,
4255: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
4256: x_return_status OUT NOCOPY VARCHAR2,
4257: x_msg_count OUT NOCOPY NUMBER,

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

4250: PROCEDURE do_unplanned (
4251: -- Standard Parameters --
4252: p_api_version IN NUMBER,
4253: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
4254: p_commit IN VARCHAR2 := FND_API.G_FALSE,
4255: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
4256: x_return_status OUT NOCOPY VARCHAR2,
4257: x_msg_count OUT NOCOPY NUMBER,
4258: x_msg_data OUT NOCOPY VARCHAR2,

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

4251: -- Standard Parameters --
4252: p_api_version IN NUMBER,
4253: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
4254: p_commit IN VARCHAR2 := FND_API.G_FALSE,
4255: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
4256: x_return_status OUT NOCOPY VARCHAR2,
4257: x_msg_count OUT NOCOPY NUMBER,
4258: x_msg_data OUT NOCOPY VARCHAR2,
4259: p_calling_fn IN VARCHAR2,

Line 4309: IF FND_API.To_Boolean(p_init_msg_list) THEN

4305:
4306: BEGIN
4307:
4308: -- Initialize message list if p_init_msg_list is set to TRUE.
4309: IF FND_API.To_Boolean(p_init_msg_list) THEN
4310: -- Initialize error message stack.
4311: FA_SRVR_MSG.Init_Server_Message;
4312:
4313: -- Initialize debug message stack.

Line 4395: if (x_return_status <> FND_API.G_RET_STS_SUCCESS) then

4391: px_asset_hdr_rec => l_asset_hdr_rec,
4392: p_unplanned_deprn_rec => l_unplanned_deprn_rec
4393: );
4394:
4395: if (x_return_status <> FND_API.G_RET_STS_SUCCESS) then
4396: return;
4397: end if;
4398:
4399: x_transaction_header_id := l_trans_rec.transaction_header_id;

Line 4405: x_return_status := FND_API.G_RET_STS_ERROR;

4401: EXCEPTION
4402: when others then
4403: fa_srvr_msg.add_sql_error(calling_fn => 'fa_trans_api_pub.do_unplanned',
4404: p_log_level_rec => g_log_level_rec);
4405: x_return_status := FND_API.G_RET_STS_ERROR;
4406:
4407: END do_unplanned;
4408:
4409: PROCEDURE do_reserve_transfer (

Line 4412: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,

4408:
4409: PROCEDURE do_reserve_transfer (
4410: -- Standard Parameters --
4411: p_api_version IN NUMBER,
4412: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
4413: p_commit IN VARCHAR2 := FND_API.G_FALSE,
4414: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
4415: x_return_status OUT NOCOPY VARCHAR2,
4416: x_msg_count OUT NOCOPY NUMBER,

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

4409: PROCEDURE do_reserve_transfer (
4410: -- Standard Parameters --
4411: p_api_version IN NUMBER,
4412: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
4413: p_commit IN VARCHAR2 := FND_API.G_FALSE,
4414: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
4415: x_return_status OUT NOCOPY VARCHAR2,
4416: x_msg_count OUT NOCOPY NUMBER,
4417: x_msg_data OUT NOCOPY VARCHAR2,

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

4410: -- Standard Parameters --
4411: p_api_version IN NUMBER,
4412: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
4413: p_commit IN VARCHAR2 := FND_API.G_FALSE,
4414: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
4415: x_return_status OUT NOCOPY VARCHAR2,
4416: x_msg_count OUT NOCOPY NUMBER,
4417: x_msg_data OUT NOCOPY VARCHAR2,
4418: p_calling_fn IN VARCHAR2,

Line 4466: if FND_API.To_Boolean(p_init_msg_list) then

4462:
4463: BEGIN
4464:
4465: -- Initialize message list if p_init_msg_list is set to TRUE.
4466: if FND_API.To_Boolean(p_init_msg_list) then
4467: -- Initialize error message stack.
4468: FA_SRVR_MSG.Init_Server_Message;
4469:
4470: -- Initialize debug message stack.

Line 4517: if (x_return_status <> FND_API.G_RET_STS_SUCCESS) then

4513: p_amount => p_transfer_amount,
4514: px_src_trans_rec => l_src_trans_rec,
4515: px_dest_trans_rec => l_dest_trans_rec);
4516:
4517: if (x_return_status <> FND_API.G_RET_STS_SUCCESS) then
4518: x_src_transaction_header_id := l_src_trans_rec.transaction_header_id;
4519: x_dest_transaction_header_id := l_dest_trans_rec.transaction_header_id;
4520: return;
4521: end if;

Line 4527: x_return_status := FND_API.G_RET_STS_ERROR;

4523: EXCEPTION
4524: when others then
4525: fa_srvr_msg.add_sql_error(calling_fn => 'fa_trans_api_pub.do_rsv_xfr',
4526: p_log_level_rec => g_log_level_rec);
4527: x_return_status := FND_API.G_RET_STS_ERROR;
4528:
4529: END do_reserve_transfer;
4530:
4531: PROCEDURE do_retirement_adjustment (

Line 4534: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,

4530:
4531: PROCEDURE do_retirement_adjustment (
4532: -- Standard Parameters --
4533: p_api_version IN NUMBER,
4534: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
4535: p_commit IN VARCHAR2 := FND_API.G_FALSE,
4536: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
4537: x_return_status OUT NOCOPY VARCHAR2,
4538: x_msg_count OUT NOCOPY NUMBER,

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

4531: PROCEDURE do_retirement_adjustment (
4532: -- Standard Parameters --
4533: p_api_version IN NUMBER,
4534: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
4535: p_commit IN VARCHAR2 := FND_API.G_FALSE,
4536: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
4537: x_return_status OUT NOCOPY VARCHAR2,
4538: x_msg_count OUT NOCOPY NUMBER,
4539: x_msg_data OUT NOCOPY VARCHAR2,

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

4532: -- Standard Parameters --
4533: p_api_version IN NUMBER,
4534: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
4535: p_commit IN VARCHAR2 := FND_API.G_FALSE,
4536: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
4537: x_return_status OUT NOCOPY VARCHAR2,
4538: x_msg_count OUT NOCOPY NUMBER,
4539: x_msg_data OUT NOCOPY VARCHAR2,
4540: p_calling_fn IN VARCHAR2,

Line 4613: if (x_return_status <> FND_API.G_RET_STS_SUCCESS) then

4609: p_cost_of_removal => p_cost_of_removal,
4610: p_proceeds => p_proceeds_of_sale
4611: );
4612:
4613: if (x_return_status <> FND_API.G_RET_STS_SUCCESS) then
4614: x_transaction_header_id := l_trans_rec.transaction_header_id;
4615: return;
4616: end if;
4617:

Line 4622: x_return_status := FND_API.G_RET_STS_ERROR;

4618: EXCEPTION
4619: when others then
4620: fa_srvr_msg.add_sql_error(calling_fn => 'fa_trans_api_pub.do_ret_adj',
4621: p_log_level_rec => g_log_level_rec);
4622: x_return_status := FND_API.G_RET_STS_ERROR;
4623: END do_retirement_adjustment;
4624:
4625: PROCEDURE do_tax_reserve_adjustment(
4626: -- Standard Parameters --

Line 4628: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,

4624:
4625: PROCEDURE do_tax_reserve_adjustment(
4626: -- Standard Parameters --
4627: p_api_version IN NUMBER,
4628: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
4629: p_commit IN VARCHAR2 := FND_API.G_FALSE,
4630: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
4631: x_return_status OUT NOCOPY VARCHAR2,
4632: x_msg_count OUT NOCOPY NUMBER,

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

4625: PROCEDURE do_tax_reserve_adjustment(
4626: -- Standard Parameters --
4627: p_api_version IN NUMBER,
4628: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
4629: p_commit IN VARCHAR2 := FND_API.G_FALSE,
4630: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
4631: x_return_status OUT NOCOPY VARCHAR2,
4632: x_msg_count OUT NOCOPY NUMBER,
4633: x_msg_data OUT NOCOPY VARCHAR2,

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

4626: -- Standard Parameters --
4627: p_api_version IN NUMBER,
4628: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
4629: p_commit IN VARCHAR2 := FND_API.G_FALSE,
4630: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
4631: x_return_status OUT NOCOPY VARCHAR2,
4632: x_msg_count OUT NOCOPY NUMBER,
4633: x_msg_data OUT NOCOPY VARCHAR2,
4634: p_calling_fn IN VARCHAR2,

Line 4680: IF FND_API.To_Boolean(p_init_msg_list) THEN

4676: l_asset_tax_rsv_adj_rec fa_api_types.asset_tax_rsv_adj_rec_type;
4677:
4678: BEGIN
4679: -- Initialize message list if p_init_msg_list is set to TRUE.
4680: IF FND_API.To_Boolean(p_init_msg_list) THEN
4681: -- Initialize error message stack.
4682: FA_SRVR_MSG.Init_Server_Message;
4683:
4684: -- Initialize debug message stack.

Line 4751: if (x_return_status <> FND_API.G_RET_STS_SUCCESS) then

4747: px_asset_hdr_rec => l_asset_hdr_rec,
4748: p_asset_tax_rsv_adj_rec => l_asset_tax_rsv_adj_rec
4749: );
4750:
4751: if (x_return_status <> FND_API.G_RET_STS_SUCCESS) then
4752: x_transaction_header_id := l_trans_rec.transaction_header_id;
4753: return;
4754: end if;
4755:

Line 4759: x_return_status := FND_API.G_RET_STS_ERROR;

4755:
4756: EXCEPTION
4757: when others then
4758: fa_srvr_msg.add_sql_error(calling_fn => 'fa_trans_api_pub.do_tax_rsv_adj');
4759: x_return_status := FND_API.G_RET_STS_ERROR;
4760: END do_tax_reserve_adjustment;
4761:
4762:
4763: END FA_TRANS_API_PUB;