DBA Data[Home] [Help]

APPS.FA_MASSCP_PKG dependencies on FND_API

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

424: p_tax_book => p_book_type_code,
425: x_return_status => l_return_status);
426:
427:
428: if (l_return_status = FND_API.G_RET_STS_ERROR) then
429: raise error_found_trx;
430: elsif (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) then
431: raise error_found_fatal_trx;
432: else

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

426:
427:
428: if (l_return_status = FND_API.G_RET_STS_ERROR) then
429: raise error_found_trx;
430: elsif (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) then
431: raise error_found_fatal_trx;
432: else
433: -- do not set the status on the dependant trxs here!
434: -- l_process_status(l_loop_count) := 'SUCCESS';

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

547: else
548: raise error_found_trx;
549: end if;
550:
551: if (l_return_status = FND_API.G_RET_STS_ERROR) then
552: raise error_found_trx;
553: elsif (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) then
554: raise error_found_fatal_trx;
555: else

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

549: end if;
550:
551: if (l_return_status = FND_API.G_RET_STS_ERROR) then
552: raise error_found_trx;
553: elsif (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) then
554: raise error_found_fatal_trx;
555: else
556: l_process_status(l_loop_count) := 'SUCCESS';
557: end if;

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

697: l_category_id number;
698:
699: -- used for api call
700: l_api_version NUMBER := 1.0;
701: l_init_msg_list VARCHAR2(1) := FND_API.G_FALSE;
702: l_commit VARCHAR2(1) := FND_API.G_FALSE;
703: l_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL;
704: l_return_status VARCHAR2(1);
705: l_mesg_count number;

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

698:
699: -- used for api call
700: l_api_version NUMBER := 1.0;
701: l_init_msg_list VARCHAR2(1) := FND_API.G_FALSE;
702: l_commit VARCHAR2(1) := FND_API.G_FALSE;
703: l_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL;
704: l_return_status VARCHAR2(1);
705: l_mesg_count number;
706: l_mesg VARCHAR2(4000);

Line 703: l_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL;

699: -- used for api call
700: l_api_version NUMBER := 1.0;
701: l_init_msg_list VARCHAR2(1) := FND_API.G_FALSE;
702: l_commit VARCHAR2(1) := FND_API.G_FALSE;
703: l_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL;
704: l_return_status VARCHAR2(1);
705: l_mesg_count number;
706: l_mesg VARCHAR2(4000);
707:

Line 984: p_init_msg_list => FND_API.G_FALSE,

980:
981:
982: FA_ADDITION_PUB.do_addition
983: (p_api_version => 1.0,
984: p_init_msg_list => FND_API.G_FALSE,
985: p_commit => FND_API.G_FALSE,
986: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
987: x_return_status => l_return_status,
988: x_msg_count => l_mesg_count,

Line 985: p_commit => FND_API.G_FALSE,

981:
982: FA_ADDITION_PUB.do_addition
983: (p_api_version => 1.0,
984: p_init_msg_list => FND_API.G_FALSE,
985: p_commit => FND_API.G_FALSE,
986: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
987: x_return_status => l_return_status,
988: x_msg_count => l_mesg_count,
989: x_msg_data => l_mesg,

Line 986: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

982: FA_ADDITION_PUB.do_addition
983: (p_api_version => 1.0,
984: p_init_msg_list => FND_API.G_FALSE,
985: p_commit => FND_API.G_FALSE,
986: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
987: x_return_status => l_return_status,
988: x_msg_count => l_mesg_count,
989: x_msg_data => l_mesg,
990: p_calling_fn => null,

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

1000: px_asset_dist_tbl => l_asset_dist_tbl,
1001: px_inv_tbl => l_inv_tbl
1002: );
1003:
1004: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then
1005: l_mesg_name := 'FA_MCP_FAIL_THID';
1006: raise add_err2;
1007: end if;
1008: else --invalid

Line 1028: X_return_status := FND_API.G_RET_STS_SUCCESS;

1024: p_token => l_token,
1025: p_value => l_value,
1026: p_mode => 'S');
1027:
1028: X_return_status := FND_API.G_RET_STS_SUCCESS;
1029:
1030: EXCEPTION
1031: when add_err1 then
1032: -- non-fatal

Line 1041: x_return_status := FND_API.G_RET_STS_ERROR;

1037: p_token => l_token,
1038: p_value => l_value,
1039: p_mode => 'W');
1040: fa_srvr_msg.add_message(calling_fn => l_calling_fn, p_log_level_rec => g_log_level_rec);
1041: x_return_status := FND_API.G_RET_STS_ERROR;
1042:
1043: when add_err2 then
1044: -- fatal
1045: write_message

Line 1053: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1049: p_token => l_token,
1050: p_value => l_value,
1051: p_mode => 'F');
1052: fa_srvr_msg.add_message(calling_fn => l_calling_fn, p_log_level_rec => g_log_level_rec);
1053: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1054:
1055: when others then
1056: -- fatal
1057: fa_srvr_msg.add_sql_error(calling_fn => null, p_log_level_rec => g_log_level_rec);

Line 1066: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1062: p_token => null,
1063: p_value => null,
1064: p_mode => 'F');
1065: fa_srvr_msg.add_message(calling_fn => l_calling_fn, p_log_level_rec => g_log_level_rec);
1066: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1067:
1068:
1069: END mcp_addition;
1070:

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

1147: l_tax_group_asset_id number;
1148:
1149: -- variables and structs used for api call
1150: l_api_version NUMBER := 1.0;
1151: l_init_msg_list VARCHAR2(1) := FND_API.G_FALSE;
1152: l_commit VARCHAR2(1) := FND_API.G_FALSE;
1153: l_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL;
1154: l_return_status VARCHAR2(1);
1155: l_mesg_count number;

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

1148:
1149: -- variables and structs used for api call
1150: l_api_version NUMBER := 1.0;
1151: l_init_msg_list VARCHAR2(1) := FND_API.G_FALSE;
1152: l_commit VARCHAR2(1) := FND_API.G_FALSE;
1153: l_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL;
1154: l_return_status VARCHAR2(1);
1155: l_mesg_count number;
1156: l_mesg VARCHAR2(4000);

Line 1153: l_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL;

1149: -- variables and structs used for api call
1150: l_api_version NUMBER := 1.0;
1151: l_init_msg_list VARCHAR2(1) := FND_API.G_FALSE;
1152: l_commit VARCHAR2(1) := FND_API.G_FALSE;
1153: l_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL;
1154: l_return_status VARCHAR2(1);
1155: l_mesg_count number;
1156: l_mesg VARCHAR2(4000);
1157:

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

1761: from fa_transaction_headers m
1762: where m.transaction_header_id = p_corp_thid;
1763:
1764: -- set the group asset id for tax
1765: l_asset_fin_rec_adj.group_asset_id := nvl(l_corp_new_group_asset_id, FND_API.G_MISS_NUM);
1766: l_group_reclass_options_rec.group_reclass_type := 'CALC';
1767: l_group_reclass_options_rec.transfer_flag := 'YES';
1768:
1769: end if;

Line 1800: p_init_msg_list => FND_API.G_FALSE,

1796: end if;
1797:
1798: FA_ADJUSTMENT_PUB.do_adjustment
1799: (p_api_version => 1.0,
1800: p_init_msg_list => FND_API.G_FALSE,
1801: p_commit => FND_API.G_FALSE,
1802: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1803: x_return_status => l_return_status,
1804: x_msg_count => l_mesg_count,

Line 1801: p_commit => FND_API.G_FALSE,

1797:
1798: FA_ADJUSTMENT_PUB.do_adjustment
1799: (p_api_version => 1.0,
1800: p_init_msg_list => FND_API.G_FALSE,
1801: p_commit => FND_API.G_FALSE,
1802: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1803: x_return_status => l_return_status,
1804: x_msg_count => l_mesg_count,
1805: x_msg_data => l_mesg,

Line 1802: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

1798: FA_ADJUSTMENT_PUB.do_adjustment
1799: (p_api_version => 1.0,
1800: p_init_msg_list => FND_API.G_FALSE,
1801: p_commit => FND_API.G_FALSE,
1802: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1803: x_return_status => l_return_status,
1804: x_msg_count => l_mesg_count,
1805: x_msg_data => l_mesg,
1806: p_calling_fn => l_calling_fn,

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

1816: x_asset_deprn_mrc_tbl_new => l_asset_deprn_mrc_tbl_new,
1817: p_group_reclass_options_rec => l_group_reclass_options_rec
1818: );
1819:
1820: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then
1821: l_mesg_name := 'FA_MCP_FAIL_THID';
1822: raise adj_err2;
1823: end if;
1824:

Line 1836: X_return_status := FND_API.G_RET_STS_SUCCESS;

1832: p_token => l_token,
1833: p_value => l_value,
1834: p_mode => 'S');
1835:
1836: X_return_status := FND_API.G_RET_STS_SUCCESS;
1837:
1838: EXCEPTION
1839: when adj_err1 then
1840: -- non-fatal

Line 1850: x_return_status := FND_API.G_RET_STS_ERROR;

1846: p_value => l_value,
1847: p_mode => 'W');
1848:
1849: fa_srvr_msg.add_message(calling_fn => l_calling_fn, p_log_level_rec => g_log_level_rec);
1850: x_return_status := FND_API.G_RET_STS_ERROR;
1851:
1852: when adj_err2 then
1853: -- fatal
1854: write_message

Line 1863: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1859: p_value => l_value,
1860: p_mode => 'F');
1861:
1862: fa_srvr_msg.add_message(calling_fn => l_calling_fn, p_log_level_rec => g_log_level_rec);
1863: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1864:
1865: when others then
1866: -- fatal
1867: fa_srvr_msg.add_sql_error(calling_fn => null, p_log_level_rec => g_log_level_rec);

Line 1877: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1873: p_value => null,
1874: p_mode => 'F');
1875:
1876: fa_srvr_msg.add_message(calling_fn => l_calling_fn, p_log_level_rec => g_log_level_rec);
1877: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1878:
1879:
1880: END mcp_adjustment;
1881:

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

1918: l_trade_in_asset_id number(15);
1919:
1920: -- used for api call
1921: l_api_version NUMBER := 1.0;
1922: l_init_msg_list VARCHAR2(1) := FND_API.G_FALSE;
1923: l_commit VARCHAR2(1) := FND_API.G_FALSE;
1924: l_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL;
1925: l_return_status VARCHAR2(1);
1926: l_msg_count number;

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

1919:
1920: -- used for api call
1921: l_api_version NUMBER := 1.0;
1922: l_init_msg_list VARCHAR2(1) := FND_API.G_FALSE;
1923: l_commit VARCHAR2(1) := FND_API.G_FALSE;
1924: l_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL;
1925: l_return_status VARCHAR2(1);
1926: l_msg_count number;
1927: l_msg_data VARCHAR2(4000);

Line 1924: l_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL;

1920: -- used for api call
1921: l_api_version NUMBER := 1.0;
1922: l_init_msg_list VARCHAR2(1) := FND_API.G_FALSE;
1923: l_commit VARCHAR2(1) := FND_API.G_FALSE;
1924: l_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL;
1925: l_return_status VARCHAR2(1);
1926: l_msg_count number;
1927: l_msg_data VARCHAR2(4000);
1928:

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

2339: end if;
2340:
2341:
2342: -- insure we run gainloss
2343: l_asset_retire_rec.calculate_gain_loss := FND_API.G_TRUE;
2344: if (g_log_level_rec.statement_level) then
2345: fa_debug_pkg.add('test',
2346: 'calling',
2347: 'do reinstatement', p_log_level_rec => g_log_level_rec);

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

2478:
2479: l_asset_retire_rec.date_retired := l_trx_date_entered;
2480:
2481: -- insure we run gainloss
2482: l_asset_retire_rec.calculate_gain_loss := FND_API.G_TRUE;
2483:
2484: -- call the appropriate api
2485: -- passing calc_gain_loss flag as true
2486:

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

2512: );
2513:
2514: end if; -- ret vs. reinstate
2515:
2516: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then
2517: l_mesg_name := 'FA_MCP_FAIL_THID';
2518: raise ret_err2;
2519: end if;
2520:

Line 2539: X_return_status := FND_API.G_RET_STS_SUCCESS;

2535: p_token => l_token,
2536: p_value => l_value,
2537: p_mode => 'S');
2538:
2539: X_return_status := FND_API.G_RET_STS_SUCCESS;
2540:
2541: EXCEPTION
2542: when ret_err1 then
2543: -- non-fatal

Line 2553: x_return_status := FND_API.G_RET_STS_ERROR;

2549: p_value => l_value,
2550: p_mode => 'W');
2551:
2552: fa_srvr_msg.add_message(calling_fn => l_calling_fn, p_log_level_rec => g_log_level_rec);
2553: x_return_status := FND_API.G_RET_STS_ERROR;
2554:
2555: when ret_err2 then
2556: -- fatal
2557: write_message

Line 2566: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2562: p_value => l_value,
2563: p_mode => 'F');
2564:
2565: fa_srvr_msg.add_message(calling_fn => l_calling_fn, p_log_level_rec => g_log_level_rec);
2566: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2567:
2568: when others then
2569: -- fatal
2570: fa_srvr_msg.add_sql_error(calling_fn => null, p_log_level_rec => g_log_level_rec);

Line 2580: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2576: p_value => null,
2577: p_mode => 'F');
2578:
2579: fa_srvr_msg.add_message(calling_fn => l_calling_fn, p_log_level_rec => g_log_level_rec);
2580: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2581:
2582: END mcp_retirement;
2583:
2584: ----------------------------------------------------------------