DBA Data[Home] [Help]

APPS.CS_AUTOGEN_TASK_PVT dependencies on CS_AUTOGEN_TASK_PVT

Line 1: PACKAGE BODY CS_AutoGen_Task_PVT AS

1: PACKAGE BODY CS_AutoGen_Task_PVT AS
2: /* $Header: csvatskb.pls 120.12.12010000.7 2010/01/06 07:07:54 sshilpam ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CS_AutoGen_Task_PVT';
5:

Line 4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CS_AutoGen_Task_PVT';

1: PACKAGE BODY CS_AutoGen_Task_PVT AS
2: /* $Header: csvatskb.pls 120.12.12010000.7 2010/01/06 07:07:54 sshilpam ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CS_AutoGen_Task_PVT';
5:
6: -- 12.1.2 SR Task Enhancement project
7: -- Get the Planned End date based on the Profile
8: PROCEDURE Default_Planned_End_Date(p_respond_by IN DATE,

Line 88: l_level_statement VARCHAR2(240) := 'cs.plsql.cs_autogen_task_pvt.create_task_from_template';

84: X_msg_data OUT NOCOPY VARCHAR2,
85: X_msg_count OUT NOCOPY NUMBER
86: ) IS
87:
88: l_level_statement VARCHAR2(240) := 'cs.plsql.cs_autogen_task_pvt.create_task_from_template';
89: l_return_status VARCHAR2(30) := 'S';
90: l_commit VARCHAR2(30) := fnd_api.g_false;
91: l_init_msg_list VARCHAR2(30) := fnd_api.g_false;
92: l_owner_group_id NUMBER ;

Line 144: l_api_name VARCHAR2(100) := 'CS_AutoGen_Task_PVT.Create_Task_From_Template';

140: -- Simplex
141: -- local variable and exception declarations for Simplex Enhancement
142: l_prof_val VARCHAR(1);
143: l_temp NUMBER(30,6);
144: l_api_name VARCHAR2(100) := 'CS_AutoGen_Task_PVT.Create_Task_From_Template';
145: l_conv_rate NUMBER(30,6);
146: l_conv_rate_day NUMBER;
147: l_planned_effort NUMBER(30,6):= 0;
148: l_text VARCHAR2(240);

Line 526: p_task_template_search_rec IN CS_AutoGen_Task_PVT.task_template_search_rec_type,

522: p_api_version IN NUMBER,
523: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
524: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
525: p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full,
526: p_task_template_search_rec IN CS_AutoGen_Task_PVT.task_template_search_rec_type,
527: x_task_template_group_tbl OUT NOCOPY CS_AutoGen_Task_PVT.task_template_group_tbl_type,
528: x_return_status OUT NOCOPY VARCHAR2,
529: x_msg_count OUT NOCOPY NUMBER,
530: x_msg_data OUT NOCOPY VARCHAR2

Line 527: x_task_template_group_tbl OUT NOCOPY CS_AutoGen_Task_PVT.task_template_group_tbl_type,

523: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
524: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
525: p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full,
526: p_task_template_search_rec IN CS_AutoGen_Task_PVT.task_template_search_rec_type,
527: x_task_template_group_tbl OUT NOCOPY CS_AutoGen_Task_PVT.task_template_group_tbl_type,
528: x_return_status OUT NOCOPY VARCHAR2,
529: x_msg_count OUT NOCOPY NUMBER,
530: x_msg_data OUT NOCOPY VARCHAR2
531: )

Line 883: x_auto_task_gen_rec OUT NOCOPY Cs_AutoGen_Task_PVT.auto_task_gen_rec_type,

879: p_task_template_group_owner IN NUMBER,
880: p_task_tmpl_group_owner_type IN VARCHAR2,
881: p_task_template_group_rec IN JTF_TASK_INST_TEMPLATES_PUB.task_template_group_info,
882: p_task_template_table IN JTF_TASK_INST_TEMPLATES_PUB.task_template_info_tbl,
883: x_auto_task_gen_rec OUT NOCOPY Cs_AutoGen_Task_PVT.auto_task_gen_rec_type,
884: x_return_status OUT NOCOPY VARCHAR2,
885: x_msg_count OUT NOCOPY NUMBER,
886: x_msg_data OUT NOCOPY VARCHAR2
887: )

Line 898: l_task_template_search_rec CS_AutoGen_Task_PVT.Task_Template_Search_Rec_Type;

894:
895: l_field_service_task_created BOOLEAN;
896: l_return_status VARCHAR2(30);
897:
898: l_task_template_search_rec CS_AutoGen_Task_PVT.Task_Template_Search_Rec_Type;
899: l_task_template_group_tbl Cs_AutoGen_Task_PVT.Task_Template_Group_Tbl_Type;
900: l_task_template_table JTF_TASK_INST_TEMPLATES_PUB.task_template_info_tbl;
901: l_task_template_group_rec JTF_TASK_INST_TEMPLATES_PUB.task_template_group_info;
902: l_task_template_group_owner NUMBER := NULL;

Line 899: l_task_template_group_tbl Cs_AutoGen_Task_PVT.Task_Template_Group_Tbl_Type;

895: l_field_service_task_created BOOLEAN;
896: l_return_status VARCHAR2(30);
897:
898: l_task_template_search_rec CS_AutoGen_Task_PVT.Task_Template_Search_Rec_Type;
899: l_task_template_group_tbl Cs_AutoGen_Task_PVT.Task_Template_Group_Tbl_Type;
900: l_task_template_table JTF_TASK_INST_TEMPLATES_PUB.task_template_info_tbl;
901: l_task_template_group_rec JTF_TASK_INST_TEMPLATES_PUB.task_template_group_info;
902: l_task_template_group_owner NUMBER := NULL;
903: l_task_tmpl_group_owner_type VARCHAR2(240) := NULL;

Line 939: SAVEPOINT CS_AutoGen_Task_PVT ;

935: BEGIN
936: -- Declare a savepoint to rollback to in case of errors in task creation.
937: -- API standard start of API saveponit
938:
939: SAVEPOINT CS_AutoGen_Task_PVT ;
940:
941: -- Initialize message list if p_init_msg_list is set to TRUE
942: IF FND_API.To_Boolean(p_init_msg_list) THEN
943: FND_MSG_PUB.Initialize;

Line 1001: CS_Autogen_Task_PVT.Get_Task_Template_Group

997:
998: -- Determine the task template group by calling the Get Task Template Group API
999:
1000:
1001: CS_Autogen_Task_PVT.Get_Task_Template_Group
1002: ( p_api_version => 1.0,
1003: p_init_msg_list => fnd_api.g_false,
1004: p_commit => p_commit,
1005: p_validation_level => p_validation_level,

Line 1156: CS_AutoGen_Task_PVT.Default_Planned_End_Date(p_service_request_rec.obligation_date,

1152: if ( l_planned_uom_value = 'DAY') then
1153: l_planned_effort_value := l_planned_effort_value +1;
1154: end if;
1155:
1156: CS_AutoGen_Task_PVT.Default_Planned_End_Date(p_service_request_rec.obligation_date,
1157: p_service_request_rec.exp_resolution_date,
1158: l_planned_uom_value,
1159: l_planned_effort_value,
1160: l_planned_end_date);

Line 1224: ROLLBACK to CS_AutoGen_Task_PVT ;

1220:
1221:
1222: EXCEPTION
1223: WHEN FND_API.G_EXC_ERROR THEN
1224: ROLLBACK to CS_AutoGen_Task_PVT ;
1225: x_return_status := FND_API.G_RET_STS_ERROR;
1226: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1227:
1228: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1229: ROLLBACK to CS_AutoGen_Task_PVT ;

1225: x_return_status := FND_API.G_RET_STS_ERROR;
1226: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1227:
1228: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1229: ROLLBACK to CS_AutoGen_Task_PVT ;
1230: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1231: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1232:
1233: -- Added new exception handler for mutiple template group error --anmukher -- 08/22/03

Line 1235: ROLLBACK to CS_AutoGen_Task_PVT ;

1231: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1232:
1233: -- Added new exception handler for mutiple template group error --anmukher -- 08/22/03
1234: WHEN Many_Task_Tmpl_Found THEN
1235: ROLLBACK to CS_AutoGen_Task_PVT ;
1236: x_return_status := FND_API.G_RET_STS_ERROR;
1237: FND_MESSAGE.SET_NAME ('CS', 'CS_SR_TGT_MULTIPLE_TGT_ERROR');
1238: FND_MESSAGE.SET_TOKEN ('TASK_GROUP_TEMPLATES',l_task_tmpl_groups_found);
1239: FND_MSG_PUB.ADD;

Line 1246: ROLLBACK to CS_AutoGen_Task_PVT ;

1242: p_data => x_msg_data);
1243:
1244: -- Added new exception handler for auto task creation failure with single template group --anmukher -- 08/22/03
1245: WHEN Task_Creation_Failed THEN
1246: ROLLBACK to CS_AutoGen_Task_PVT ;
1247: x_return_status := FND_API.G_RET_STS_ERROR;
1248: -- Message commented out since Create_Task_From_Template API is already
1249: -- stacking specific error message on failure --anmukher --10/30/2003
1250: /*

Line 1260: ROLLBACK to CS_AutoGen_Task_PVT ;

1256: p_count => x_msg_count,
1257: p_data => x_msg_data);
1258:
1259: WHEN OTHERS THEN
1260: ROLLBACK to CS_AutoGen_Task_PVT ;
1261: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1262: If c_get_task_tmpl_grp_info%IsOpen Then
1263: close c_get_task_tmpl_grp_info;
1264: End If;

Line 1314: END CS_AutoGen_Task_PVT;

1310: END Get_Task_Template_Status;
1311:
1312:
1313:
1314: END CS_AutoGen_Task_PVT;