DBA Data[Home] [Help]

APPS.FA_CUA_MASS_EXT_RET_PKG dependencies on FND_API

Line 35: G_calc_gain_loss_flag varchar2(50) := FND_API.G_FALSE;

31: G_Min_Acct_Unit NUMBER;
32: G_Today_Datetime DATE := SYSDATE;
33: G_Currency_Code gl_sets_of_books.currency_code%TYPE;
34: G_Set_of_Books_ID fa_book_controls.set_of_books_id%TYPE;
35: G_calc_gain_loss_flag varchar2(50) := FND_API.G_FALSE;
36: G_Distribution_id fa_distribution_history.distribution_id%TYPE;
37: -- bug 1857395
38: G_Code_Combination_Id fa_mass_Ext_retirements.Code_Combination_Id%TYPE;
39: G_Location_Id fa_mass_Ext_retirements.Location_Id%TYPE;

Line 218: l_init_msg_list VARCHAR2(50) := FND_API.G_FALSE; -- 1

214: -- variables and structs used for api call
215: -- l_debug_flag VARCHAR2(3) := 'YES';
216: l_debug_flag VARCHAR2(3) := 'NO';
217: l_api_version NUMBER := 1; -- 1.0
218: l_init_msg_list VARCHAR2(50) := FND_API.G_FALSE; -- 1
219: l_commit VARCHAR2(1) := FND_API.G_FALSE;
220: l_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL;
221: l_return_status VARCHAR2(10);
222: l_msg_count NUMBER;

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

215: -- l_debug_flag VARCHAR2(3) := 'YES';
216: l_debug_flag VARCHAR2(3) := 'NO';
217: l_api_version NUMBER := 1; -- 1.0
218: l_init_msg_list VARCHAR2(50) := FND_API.G_FALSE; -- 1
219: l_commit VARCHAR2(1) := FND_API.G_FALSE;
220: l_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL;
221: l_return_status VARCHAR2(10);
222: l_msg_count NUMBER;
223: -- l_msg_data VARCHAR2(4000);

Line 220: l_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL;

216: l_debug_flag VARCHAR2(3) := 'NO';
217: l_api_version NUMBER := 1; -- 1.0
218: l_init_msg_list VARCHAR2(50) := FND_API.G_FALSE; -- 1
219: l_commit VARCHAR2(1) := FND_API.G_FALSE;
220: l_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL;
221: l_return_status VARCHAR2(10);
222: l_msg_count NUMBER;
223: -- l_msg_data VARCHAR2(4000);
224: l_calling_fn VARCHAR2(100) := 'fa_cua_mass_ext_ret_pkg';

Line 475: raise FND_API.G_EXC_ERROR;

471: if (not g_log_level_rec.initialized) then
472: if (NOT fa_util_pub.get_log_level_rec (
473: x_log_level_rec => g_log_level_rec
474: )) then
475: raise FND_API.G_EXC_ERROR;
476: end if;
477: end if;
478:
479: px_max_mass_ext_retire_id := nvl(px_max_mass_ext_retire_id, 0);

Line 1066: -- retirement api is using fnd_api.g_true/g_false

1062: l_asset_retire_rec.trade_in_asset_id := g_trade_in_asset_id;
1063: l_asset_retire_rec.status := 'PENDING';
1064: l_asset_retire_rec.reference_num := g_reference_num;
1065: -- this parameter gives an option to run gain/loss right after the transaction.
1066: -- retirement api is using fnd_api.g_true/g_false
1067: -- converting potential Y and N to fnd_api.g_true/g_false.
1068: --
1069: if g_calc_gain_loss_flag in ('Y','YES') then
1070: g_calc_gain_loss_flag := fnd_api.g_true;

Line 1067: -- converting potential Y and N to fnd_api.g_true/g_false.

1063: l_asset_retire_rec.status := 'PENDING';
1064: l_asset_retire_rec.reference_num := g_reference_num;
1065: -- this parameter gives an option to run gain/loss right after the transaction.
1066: -- retirement api is using fnd_api.g_true/g_false
1067: -- converting potential Y and N to fnd_api.g_true/g_false.
1068: --
1069: if g_calc_gain_loss_flag in ('Y','YES') then
1070: g_calc_gain_loss_flag := fnd_api.g_true;
1071: elsif g_calc_gain_loss_flag in ('N','NO') then

Line 1070: g_calc_gain_loss_flag := fnd_api.g_true;

1066: -- retirement api is using fnd_api.g_true/g_false
1067: -- converting potential Y and N to fnd_api.g_true/g_false.
1068: --
1069: if g_calc_gain_loss_flag in ('Y','YES') then
1070: g_calc_gain_loss_flag := fnd_api.g_true;
1071: elsif g_calc_gain_loss_flag in ('N','NO') then
1072: g_calc_gain_loss_flag := fnd_api.g_false;
1073: end if;
1074: l_asset_retire_rec.calculate_gain_loss := g_calc_gain_loss_flag;

Line 1072: g_calc_gain_loss_flag := fnd_api.g_false;

1068: --
1069: if g_calc_gain_loss_flag in ('Y','YES') then
1070: g_calc_gain_loss_flag := fnd_api.g_true;
1071: elsif g_calc_gain_loss_flag in ('N','NO') then
1072: g_calc_gain_loss_flag := fnd_api.g_false;
1073: end if;
1074: l_asset_retire_rec.calculate_gain_loss := g_calc_gain_loss_flag;
1075: l_asset_retire_rec.desc_flex.attribute1 := g_attribute1;
1076: l_asset_retire_rec.desc_flex.attribute2 := g_attribute2;

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

1207: l_msg_count, g_log_level_rec);
1208: END IF;
1209:
1210:
1211: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then
1212: raise G_Subroutine_Fail;
1213: else
1214: G_success_count := G_success_count + 1;
1215: x_success_count := x_success_count + 1;

Line 1283: -- x_return_status := FND_API.G_RET_STS_ERROR;

1279: p_db_error => '',
1280: p_mode => 'W');
1281:
1282: fa_srvr_msg.add_message(calling_fn => l_calling_fn);
1283: -- x_return_status := FND_API.G_RET_STS_ERROR;
1284:
1285: FND_CONCURRENT.AF_COMMIT;
1286: x_return_status := 1;
1287: