APPS.CSE_DEPLOYMENT_GRP dependencies on CSE_DEPLOYMENT_GRP

Line 1: PACKAGE BODY cse_deployment_grp AS

1: PACKAGE BODY cse_deployment_grp AS
2: /* $Header: CSEDPLGB.pls 120.21.12010000.7 2010/01/12 21:03:56 devijay ship $ */
3:
4: l_debug varchar2(1) := NVL(fnd_profile.value('cse_debug_option'),'N');
5:

Line 497: l_api_name CONSTANT VARCHAR2(30) := 'cse_deployment_grp';

493: p_conc_request_id IN NUMBER ,
494: x_return_status OUT NOCOPY VARCHAR2,
495: x_error_message OUT NOCOPY VARCHAR2)
496: IS
497: l_api_name CONSTANT VARCHAR2(30) := 'cse_deployment_grp';
498: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
499: l_error_message VARCHAR2(2000);
500: l_msg_count NUMBER;
501: l_msg_data VARCHAR2(2000);

Line 702: debug('Inside API cse_deployment_grp.interface_nl_to_pa');

698: x_return_status := FND_API.G_RET_STS_SUCCESS;
699: x_error_message := NULL;
700: cse_util_pkg.set_debug;
701:
702: debug('Inside API cse_deployment_grp.interface_nl_to_pa');
703:
704: debug(' inventory_item_id : '||p_trf_pa_attr_rec.item_id);
705: debug(' organization_id : '||p_trf_pa_attr_rec.inv_master_org_id);
706: debug(' project_id : '||p_trf_pa_attr_rec.project_id);

Line 1112: debug('Error in cse_deployment_grp.interface_nl_to_pa : '||x_error_message);

1108: EXCEPTION
1109: WHEN fnd_api.g_exc_error THEN
1110: x_return_status := l_return_status;
1111: x_error_message := l_error_message;
1112: debug('Error in cse_deployment_grp.interface_nl_to_pa : '||x_error_message);
1113: WHEN OTHERS THEN
1114: fnd_message.set_name('CSE','CSE_OTHERS_EXCEPTION');
1115: fnd_message.set_token('ERR_MSG',l_api_name||'='|| SQLERRM);
1116: x_error_message := fnd_message.get;

Line 1118: debug('Inside others exception in cse_deployment_grp.interface_nl_to_pa : ' ||x_error_message);

1114: fnd_message.set_name('CSE','CSE_OTHERS_EXCEPTION');
1115: fnd_message.set_token('ERR_MSG',l_api_name||'='|| SQLERRM);
1116: x_error_message := fnd_message.get;
1117: x_return_status := fnd_api.g_ret_sts_unexp_error;
1118: debug('Inside others exception in cse_deployment_grp.interface_nl_to_pa : ' ||x_error_message);
1119: END interface_nl_to_pa;
1120: -- Added for 8670632--
1121:
1122: PROCEDURE process_transaction (

Line 1180: debug('Inside API cse_deployment_grp.process_transaction '||to_char(l_sysdate, 'dd-mon-yyyy hh24:mi:ss'));

1176: p_file_segment2 => to_char(sysdate, 'DDMONYYYY'));
1177:
1178: SELECT sysdate INTO l_sysdate FROM sys.dual;
1179:
1180: debug('Inside API cse_deployment_grp.process_transaction '||to_char(l_sysdate, 'dd-mon-yyyy hh24:mi:ss'));
1181: debug(' instance_tbl.count : '||p_instance_tbl.count);
1182: debug(' dest_loc_tbl.count : '||p_dest_location_tbl.count);
1183: debug(' ea_val_tbl.count : '||p_ext_attrib_values_tbl.count);
1184: debug(' txn_tbl.count : '||p_txn_tbl.count);

Line 1530: cse_deployment_grp.interface_nl_to_pa(

1526: l_trf_pa_attr_rec.to_project_id := l_dest_location_rec.pa_project_id;
1527: l_trf_pa_attr_rec.to_task_id := l_dest_location_rec.pa_project_task_id;
1528:
1529: debug('Calling interface_nl_to_pa');
1530: cse_deployment_grp.interface_nl_to_pa(
1531: p_trf_pa_attr_rec => l_trf_pa_attr_rec,
1532: p_conc_request_id => 111 ,
1533: x_return_status => l_return_status,
1534: x_error_message => l_error_msg );

Line 1549: END cse_deployment_grp;

1545: debug('Error : '||x_error_msg);
1546: rollback to process_transaction;
1547: END process_transaction;
1548:
1549: END cse_deployment_grp;