DBA Data[Home] [Help]

APPS.FA_CUA_MASS_UPDATE1_PKG dependencies on FND_API

Line 366: l_msg_list VARCHAR2(5) := FND_API.G_FALSE;

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';

Line 367: l_commit_flag VARCHAR2(5) := FND_API.G_FALSE;

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:

Line 368: l_validation_level VARCHAR2(5) := FND_API.G_VALID_LEVEL_FULL;

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;

Line 369: l_debug_flag VARCHAR2(5) := FND_API.G_FALSE;

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;

Line 419: x_err_code := substr(fnd_msg_pub.get(fnd_msg_pub.G_FIRST, fnd_api.G_TRUE), 1, 512);

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:

Line 516: p_init_msg_list => FND_API.G_FALSE,

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,

Line 517: p_commit => FND_API.G_FALSE,

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,

Line 518: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

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,

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

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;

Line 528: x_err_code := substr(fnd_msg_pub.get(fnd_msg_pub.G_FIRST, fnd_api.G_TRUE), 1, 512);

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:

Line 584: p_init_msg_list => FND_API.G_FALSE,

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,

Line 585: p_commit => FND_API.G_FALSE,

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,

Line 586: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

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',

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

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:

Line 606: x_err_code := substr(fnd_msg_pub.get(fnd_msg_pub.G_FIRST, fnd_api.G_TRUE), 1, 512);

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

Line 890: l_err_code := substr(fnd_msg_pub.get(fnd_msg_pub.G_FIRST, fnd_api.G_TRUE), 1, 512);

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';

Line 1031: l_msg_list VARCHAR2(5) := FND_API.G_FALSE;

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:

Line 1032: l_commit_flag VARCHAR2(5) := FND_API.G_FALSE;

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;

Line 1033: l_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL;

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;

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

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;

Line 1144: x_err_code := substr(fnd_msg_pub.get(fnd_msg_pub.G_FIRST, fnd_api.G_TRUE), 1, 512);

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;