362: --l_return_status2 BOOLEAN;
363: --l_return_status3 BOOLEAN;
364:
365: l_api_version CONSTANT number := 1.0;
366: l_msg_list VARCHAR2(5) := FND_API.G_FALSE;
367: l_commit_flag VARCHAR2(5) := FND_API.G_FALSE;
368: l_validation_level VARCHAR2(5) := FND_API.G_VALID_LEVEL_FULL;
369: l_debug_flag VARCHAR2(5) := FND_API.G_FALSE;
370: l_calling_fn VARCHAR2(20) := 'update_category';
363: --l_return_status3 BOOLEAN;
364:
365: l_api_version CONSTANT number := 1.0;
366: l_msg_list VARCHAR2(5) := FND_API.G_FALSE;
367: l_commit_flag VARCHAR2(5) := FND_API.G_FALSE;
368: l_validation_level VARCHAR2(5) := FND_API.G_VALID_LEVEL_FULL;
369: l_debug_flag VARCHAR2(5) := FND_API.G_FALSE;
370: l_calling_fn VARCHAR2(20) := 'update_category';
371:
364:
365: l_api_version CONSTANT number := 1.0;
366: l_msg_list VARCHAR2(5) := FND_API.G_FALSE;
367: l_commit_flag VARCHAR2(5) := FND_API.G_FALSE;
368: l_validation_level VARCHAR2(5) := FND_API.G_VALID_LEVEL_FULL;
369: l_debug_flag VARCHAR2(5) := FND_API.G_FALSE;
370: l_calling_fn VARCHAR2(20) := 'update_category';
371:
372: l_trans_rec FA_API_TYPES.trans_rec_type;
365: l_api_version CONSTANT number := 1.0;
366: l_msg_list VARCHAR2(5) := FND_API.G_FALSE;
367: l_commit_flag VARCHAR2(5) := FND_API.G_FALSE;
368: l_validation_level VARCHAR2(5) := FND_API.G_VALID_LEVEL_FULL;
369: l_debug_flag VARCHAR2(5) := FND_API.G_FALSE;
370: l_calling_fn VARCHAR2(20) := 'update_category';
371:
372: l_trans_rec FA_API_TYPES.trans_rec_type;
373: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
415: px_asset_cat_rec_new => l_asset_cat_rec_new,
416: p_recl_opt_rec => l_recl_opt_rec );
417:
418: if not(l_return_status <> 'S') then
419: x_err_code := substr(fnd_msg_pub.get(fnd_msg_pub.G_FIRST, fnd_api.G_TRUE), 1, 512);
420: end if;
421:
422: x_err_stack := l_old_stack;
423:
512: l_msg_data := null;
513: l_return_status := null;
514: FA_TRANSFER_PUB.do_transfer(
515: p_api_version => 1.0,
516: p_init_msg_list => FND_API.G_FALSE,
517: p_commit => FND_API.G_FALSE,
518: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
519: p_calling_fn => NULL,
520: x_return_status => l_return_status,
513: l_return_status := null;
514: FA_TRANSFER_PUB.do_transfer(
515: p_api_version => 1.0,
516: p_init_msg_list => FND_API.G_FALSE,
517: p_commit => FND_API.G_FALSE,
518: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
519: p_calling_fn => NULL,
520: x_return_status => l_return_status,
521: x_msg_count => l_msg_count,
514: FA_TRANSFER_PUB.do_transfer(
515: p_api_version => 1.0,
516: p_init_msg_list => FND_API.G_FALSE,
517: p_commit => FND_API.G_FALSE,
518: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
519: p_calling_fn => NULL,
520: x_return_status => l_return_status,
521: x_msg_count => l_msg_count,
522: x_msg_data => l_msg_data,
523: px_trans_rec => l_trans_rec,
524: px_asset_hdr_rec => l_asset_hdr_rec,
525: px_asset_dist_tbl => l_asset_dist_tbl);
526:
527: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then
528: x_err_code := substr(fnd_msg_pub.get(fnd_msg_pub.G_FIRST, fnd_api.G_TRUE), 1, 512);
529: return;
530: end if;
531: end loop;
524: px_asset_hdr_rec => l_asset_hdr_rec,
525: px_asset_dist_tbl => l_asset_dist_tbl);
526:
527: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then
528: x_err_code := substr(fnd_msg_pub.get(fnd_msg_pub.G_FIRST, fnd_api.G_TRUE), 1, 512);
529: return;
530: end if;
531: end loop;
532:
580: l_asset_fin_rec_adj.life_in_months := x_new_life;
581:
582: FA_ADJUSTMENT_PUB.do_adjustment
583: (p_api_version => 1.0,
584: p_init_msg_list => FND_API.G_FALSE,
585: p_commit => FND_API.G_FALSE,
586: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
587: x_return_status => l_return_status,
588: x_msg_count => l_mesg_count,
581:
582: FA_ADJUSTMENT_PUB.do_adjustment
583: (p_api_version => 1.0,
584: p_init_msg_list => FND_API.G_FALSE,
585: p_commit => FND_API.G_FALSE,
586: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
587: x_return_status => l_return_status,
588: x_msg_count => l_mesg_count,
589: x_msg_data => l_mesg,
582: FA_ADJUSTMENT_PUB.do_adjustment
583: (p_api_version => 1.0,
584: p_init_msg_list => FND_API.G_FALSE,
585: p_commit => FND_API.G_FALSE,
586: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
587: x_return_status => l_return_status,
588: x_msg_count => l_mesg_count,
589: x_msg_data => l_mesg,
590: p_calling_fn => 'fa_cua_mass_update1_pkg.do_adjustment',
601: p_group_reclass_options_rec => l_group_reclass_options_rec);
602:
603:
604:
605: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then
606: x_err_code := substr(fnd_msg_pub.get(fnd_msg_pub.G_FIRST, fnd_api.G_TRUE), 1, 512);
607: return;
608: end if;
609:
602:
603:
604:
605: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then
606: x_err_code := substr(fnd_msg_pub.get(fnd_msg_pub.G_FIRST, fnd_api.G_TRUE), 1, 512);
607: return;
608: end if;
609:
610: EXCEPTION
886: X_trx_type => 'RECLASS',
887: X_trx_date => l_transaction_date,
888: X_init_message_flag=> 'YES', p_log_level_rec => p_log_level_rec) then
889:
890: l_err_code := substr(fnd_msg_pub.get(fnd_msg_pub.G_FIRST, fnd_api.G_TRUE), 1, 512);
891:
892: if nvl(l_err_code, '0') = '0' then
893: -- check_pending_batches procedure returned false;
894: l_err_code := 'CUA_PENDING_BOOK';
1027: l_return_status VARCHAR2(100);
1028: l_msg_count NUMBER:= 0;
1029: l_msg_data VARCHAR2(4000);
1030: l_api_version CONSTANT number := 1.0;
1031: l_msg_list VARCHAR2(5) := FND_API.G_FALSE;
1032: l_commit_flag VARCHAR2(5) := FND_API.G_FALSE;
1033: l_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL;
1034: l_calling_fn VARCHAR2(20) := 'ASSET HIERARACHY';
1035:
1028: l_msg_count NUMBER:= 0;
1029: l_msg_data VARCHAR2(4000);
1030: l_api_version CONSTANT number := 1.0;
1031: l_msg_list VARCHAR2(5) := FND_API.G_FALSE;
1032: l_commit_flag VARCHAR2(5) := FND_API.G_FALSE;
1033: l_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL;
1034: l_calling_fn VARCHAR2(20) := 'ASSET HIERARACHY';
1035:
1036: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
1029: l_msg_data VARCHAR2(4000);
1030: l_api_version CONSTANT number := 1.0;
1031: l_msg_list VARCHAR2(5) := FND_API.G_FALSE;
1032: l_commit_flag VARCHAR2(5) := FND_API.G_FALSE;
1033: l_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL;
1034: l_calling_fn VARCHAR2(20) := 'ASSET HIERARACHY';
1035:
1036: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
1037: l_asset_cat_rec_new FA_API_TYPES.asset_cat_rec_type;
1139: px_asset_hdr_rec => l_asset_hdr_rec,
1140: px_asset_desc_rec_new => l_asset_desc_rec,
1141: px_asset_cat_rec_new => l_asset_cat_rec);
1142:
1143: if ( l_return_status <> FND_API.G_RET_STS_SUCCESS) then
1144: x_err_code := substr(fnd_msg_pub.get(fnd_msg_pub.G_FIRST, fnd_api.G_TRUE), 1, 512);
1145: x_err_attr_name := l_get_lines_rec.attribute_name;
1146: return;
1147: end if;
1140: px_asset_desc_rec_new => l_asset_desc_rec,
1141: px_asset_cat_rec_new => l_asset_cat_rec);
1142:
1143: if ( l_return_status <> FND_API.G_RET_STS_SUCCESS) then
1144: x_err_code := substr(fnd_msg_pub.get(fnd_msg_pub.G_FIRST, fnd_api.G_TRUE), 1, 512);
1145: x_err_attr_name := l_get_lines_rec.attribute_name;
1146: return;
1147: end if;
1148: end if;