DBA Data[Home] [Help]

APPS.FA_CUA_MASS_UPDATE1_PKG dependencies on FND_API

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

360: --l_return_status2 BOOLEAN;
361: --l_return_status3 BOOLEAN;
362:
363: l_api_version CONSTANT number := 1.0;
364: l_msg_list VARCHAR2(5) := FND_API.G_FALSE;
365: l_commit_flag VARCHAR2(5) := FND_API.G_FALSE;
366: l_validation_level VARCHAR2(5) := FND_API.G_VALID_LEVEL_FULL;
367: l_debug_flag VARCHAR2(5) := FND_API.G_FALSE;
368: l_calling_fn VARCHAR2(20) := 'update_category';

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

361: --l_return_status3 BOOLEAN;
362:
363: l_api_version CONSTANT number := 1.0;
364: l_msg_list VARCHAR2(5) := FND_API.G_FALSE;
365: l_commit_flag VARCHAR2(5) := FND_API.G_FALSE;
366: l_validation_level VARCHAR2(5) := FND_API.G_VALID_LEVEL_FULL;
367: l_debug_flag VARCHAR2(5) := FND_API.G_FALSE;
368: l_calling_fn VARCHAR2(20) := 'update_category';
369:

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

362:
363: l_api_version CONSTANT number := 1.0;
364: l_msg_list VARCHAR2(5) := FND_API.G_FALSE;
365: l_commit_flag VARCHAR2(5) := FND_API.G_FALSE;
366: l_validation_level VARCHAR2(5) := FND_API.G_VALID_LEVEL_FULL;
367: l_debug_flag VARCHAR2(5) := FND_API.G_FALSE;
368: l_calling_fn VARCHAR2(20) := 'update_category';
369:
370: l_trans_rec FA_API_TYPES.trans_rec_type;

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

363: l_api_version CONSTANT number := 1.0;
364: l_msg_list VARCHAR2(5) := FND_API.G_FALSE;
365: l_commit_flag VARCHAR2(5) := FND_API.G_FALSE;
366: l_validation_level VARCHAR2(5) := FND_API.G_VALID_LEVEL_FULL;
367: l_debug_flag VARCHAR2(5) := FND_API.G_FALSE;
368: l_calling_fn VARCHAR2(20) := 'update_category';
369:
370: l_trans_rec FA_API_TYPES.trans_rec_type;
371: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;

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

413: px_asset_cat_rec_new => l_asset_cat_rec_new,
414: p_recl_opt_rec => l_recl_opt_rec );
415:
416: if not(l_return_status <> 'S') then
417: x_err_code := substr(fnd_msg_pub.get(fnd_msg_pub.G_FIRST, fnd_api.G_TRUE), 1, 512);
418: end if;
419:
420: x_err_stack := l_old_stack;
421:

Line 514: p_init_msg_list => FND_API.G_FALSE,

510: l_msg_data := null;
511: l_return_status := null;
512: FA_TRANSFER_PUB.do_transfer(
513: p_api_version => 1.0,
514: p_init_msg_list => FND_API.G_FALSE,
515: p_commit => FND_API.G_FALSE,
516: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
517: p_calling_fn => NULL,
518: x_return_status => l_return_status,

Line 515: p_commit => FND_API.G_FALSE,

511: l_return_status := null;
512: FA_TRANSFER_PUB.do_transfer(
513: p_api_version => 1.0,
514: p_init_msg_list => FND_API.G_FALSE,
515: p_commit => FND_API.G_FALSE,
516: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
517: p_calling_fn => NULL,
518: x_return_status => l_return_status,
519: x_msg_count => l_msg_count,

Line 516: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

512: FA_TRANSFER_PUB.do_transfer(
513: p_api_version => 1.0,
514: p_init_msg_list => FND_API.G_FALSE,
515: p_commit => FND_API.G_FALSE,
516: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
517: p_calling_fn => NULL,
518: x_return_status => l_return_status,
519: x_msg_count => l_msg_count,
520: x_msg_data => l_msg_data,

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

521: px_trans_rec => l_trans_rec,
522: px_asset_hdr_rec => l_asset_hdr_rec,
523: px_asset_dist_tbl => l_asset_dist_tbl);
524:
525: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then
526: x_err_code := substr(fnd_msg_pub.get(fnd_msg_pub.G_FIRST, fnd_api.G_TRUE), 1, 512);
527: return;
528: end if;
529: end loop;

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

522: px_asset_hdr_rec => l_asset_hdr_rec,
523: px_asset_dist_tbl => l_asset_dist_tbl);
524:
525: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then
526: x_err_code := substr(fnd_msg_pub.get(fnd_msg_pub.G_FIRST, fnd_api.G_TRUE), 1, 512);
527: return;
528: end if;
529: end loop;
530:

Line 582: p_init_msg_list => FND_API.G_FALSE,

578: l_asset_fin_rec_adj.life_in_months := x_new_life;
579:
580: FA_ADJUSTMENT_PUB.do_adjustment
581: (p_api_version => 1.0,
582: p_init_msg_list => FND_API.G_FALSE,
583: p_commit => FND_API.G_FALSE,
584: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
585: x_return_status => l_return_status,
586: x_msg_count => l_mesg_count,

Line 583: p_commit => FND_API.G_FALSE,

579:
580: FA_ADJUSTMENT_PUB.do_adjustment
581: (p_api_version => 1.0,
582: p_init_msg_list => FND_API.G_FALSE,
583: p_commit => FND_API.G_FALSE,
584: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
585: x_return_status => l_return_status,
586: x_msg_count => l_mesg_count,
587: x_msg_data => l_mesg,

Line 584: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

580: FA_ADJUSTMENT_PUB.do_adjustment
581: (p_api_version => 1.0,
582: p_init_msg_list => FND_API.G_FALSE,
583: p_commit => FND_API.G_FALSE,
584: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
585: x_return_status => l_return_status,
586: x_msg_count => l_mesg_count,
587: x_msg_data => l_mesg,
588: p_calling_fn => 'fa_cua_mass_update1_pkg.do_adjustment',

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

599: p_group_reclass_options_rec => l_group_reclass_options_rec );
600:
601:
602:
603: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then
604: x_err_code := substr(fnd_msg_pub.get(fnd_msg_pub.G_FIRST, fnd_api.G_TRUE), 1, 512);
605: return;
606: end if;
607:

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

600:
601:
602:
603: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then
604: x_err_code := substr(fnd_msg_pub.get(fnd_msg_pub.G_FIRST, fnd_api.G_TRUE), 1, 512);
605: return;
606: end if;
607:
608: EXCEPTION

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

883: X_trx_type => 'RECLASS',
884: X_trx_date => l_transaction_date,
885: X_init_message_flag=> 'YES') then
886:
887: l_err_code := substr(fnd_msg_pub.get(fnd_msg_pub.G_FIRST, fnd_api.G_TRUE), 1, 512);
888:
889: if nvl(l_err_code, '0') = '0' then
890: -- check_pending_batches procedure returned false;
891: l_err_code := 'CUA_PENDING_BOOK';

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

1023: l_return_status VARCHAR2(100);
1024: l_msg_count NUMBER:= 0;
1025: l_msg_data VARCHAR2(4000);
1026: l_api_version CONSTANT number := 1.0;
1027: l_msg_list VARCHAR2(5) := FND_API.G_FALSE;
1028: l_commit_flag VARCHAR2(5) := FND_API.G_FALSE;
1029: l_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL;
1030: l_calling_fn VARCHAR2(20) := 'ASSET HIERARACHY';
1031:

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

1024: l_msg_count NUMBER:= 0;
1025: l_msg_data VARCHAR2(4000);
1026: l_api_version CONSTANT number := 1.0;
1027: l_msg_list VARCHAR2(5) := FND_API.G_FALSE;
1028: l_commit_flag VARCHAR2(5) := FND_API.G_FALSE;
1029: l_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL;
1030: l_calling_fn VARCHAR2(20) := 'ASSET HIERARACHY';
1031:
1032: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;

Line 1029: l_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL;

1025: l_msg_data VARCHAR2(4000);
1026: l_api_version CONSTANT number := 1.0;
1027: l_msg_list VARCHAR2(5) := FND_API.G_FALSE;
1028: l_commit_flag VARCHAR2(5) := FND_API.G_FALSE;
1029: l_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL;
1030: l_calling_fn VARCHAR2(20) := 'ASSET HIERARACHY';
1031:
1032: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
1033: l_asset_cat_rec_new FA_API_TYPES.asset_cat_rec_type;

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

1136: px_asset_hdr_rec => l_asset_hdr_rec,
1137: px_asset_desc_rec_new => l_asset_desc_rec,
1138: px_asset_cat_rec_new => l_asset_cat_rec);
1139:
1140: if ( l_return_status <> FND_API.G_RET_STS_SUCCESS) then
1141: x_err_code := substr(fnd_msg_pub.get(fnd_msg_pub.G_FIRST, fnd_api.G_TRUE), 1, 512);
1142: x_err_attr_name := l_get_lines_rec.attribute_name;
1143: return;
1144: end if;

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

1137: px_asset_desc_rec_new => l_asset_desc_rec,
1138: px_asset_cat_rec_new => l_asset_cat_rec);
1139:
1140: if ( l_return_status <> FND_API.G_RET_STS_SUCCESS) then
1141: x_err_code := substr(fnd_msg_pub.get(fnd_msg_pub.G_FIRST, fnd_api.G_TRUE), 1, 512);
1142: x_err_attr_name := l_get_lines_rec.attribute_name;
1143: return;
1144: end if;
1145: end if;