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.2 2008/09/30 10:34:56 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.2 2008/09/30 10:34:56 sshilpam ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CS_AutoGen_Task_PVT';
5:
6: PROCEDURE Create_Task_From_Template
7: (
8: P_task_template_group_owner IN NUMBER,

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

16: X_msg_data OUT NOCOPY VARCHAR2,
17: X_msg_count OUT NOCOPY NUMBER
18: ) IS
19:
20: l_level_statement VARCHAR2(240) := 'cs.plsql.cs_autogen_task_pvt.create_task_from_template';
21: l_return_status VARCHAR2(30) := 'S';
22: l_commit VARCHAR2(30) := fnd_api.g_false;
23: l_init_msg_list VARCHAR2(30) := fnd_api.g_false;
24: l_owner_group_id NUMBER ;

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

72: -- Simplex
73: -- local variable and exception declarations for Simplex Enhancement
74: l_prof_val VARCHAR(1);
75: l_temp NUMBER(30,6);
76: l_api_name VARCHAR2(100) := 'CS_AutoGen_Task_PVT.Create_Task_From_Template';
77: l_conv_rate NUMBER(30,6);
78: l_conv_rate_day NUMBER;
79: l_planned_effort NUMBER(30,6):= 0;
80: l_text VARCHAR2(240);

Line 448: p_task_template_search_rec IN CS_AutoGen_Task_PVT.task_template_search_rec_type,

444: p_api_version IN NUMBER,
445: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
446: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
447: p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full,
448: p_task_template_search_rec IN CS_AutoGen_Task_PVT.task_template_search_rec_type,
449: x_task_template_group_tbl OUT NOCOPY CS_AutoGen_Task_PVT.task_template_group_tbl_type,
450: x_return_status OUT NOCOPY VARCHAR2,
451: x_msg_count OUT NOCOPY NUMBER,
452: x_msg_data OUT NOCOPY VARCHAR2

Line 449: x_task_template_group_tbl OUT NOCOPY CS_AutoGen_Task_PVT.task_template_group_tbl_type,

445: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
446: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
447: p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full,
448: p_task_template_search_rec IN CS_AutoGen_Task_PVT.task_template_search_rec_type,
449: x_task_template_group_tbl OUT NOCOPY CS_AutoGen_Task_PVT.task_template_group_tbl_type,
450: x_return_status OUT NOCOPY VARCHAR2,
451: x_msg_count OUT NOCOPY NUMBER,
452: x_msg_data OUT NOCOPY VARCHAR2
453: )

Line 805: x_auto_task_gen_rec OUT NOCOPY Cs_AutoGen_Task_PVT.auto_task_gen_rec_type,

801: p_task_template_group_owner IN NUMBER,
802: p_task_tmpl_group_owner_type IN VARCHAR2,
803: p_task_template_group_rec IN JTF_TASK_INST_TEMPLATES_PUB.task_template_group_info,
804: p_task_template_table IN JTF_TASK_INST_TEMPLATES_PUB.task_template_info_tbl,
805: x_auto_task_gen_rec OUT NOCOPY Cs_AutoGen_Task_PVT.auto_task_gen_rec_type,
806: x_return_status OUT NOCOPY VARCHAR2,
807: x_msg_count OUT NOCOPY NUMBER,
808: x_msg_data OUT NOCOPY VARCHAR2
809: )

Line 820: l_task_template_search_rec CS_AutoGen_Task_PVT.Task_Template_Search_Rec_Type;

816:
817: l_field_service_task_created BOOLEAN;
818: l_return_status VARCHAR2(30);
819:
820: l_task_template_search_rec CS_AutoGen_Task_PVT.Task_Template_Search_Rec_Type;
821: l_task_template_group_tbl Cs_AutoGen_Task_PVT.Task_Template_Group_Tbl_Type;
822: l_task_template_table JTF_TASK_INST_TEMPLATES_PUB.task_template_info_tbl;
823: l_task_template_group_rec JTF_TASK_INST_TEMPLATES_PUB.task_template_group_info;
824: l_task_template_group_owner NUMBER := NULL;

Line 821: l_task_template_group_tbl Cs_AutoGen_Task_PVT.Task_Template_Group_Tbl_Type;

817: l_field_service_task_created BOOLEAN;
818: l_return_status VARCHAR2(30);
819:
820: l_task_template_search_rec CS_AutoGen_Task_PVT.Task_Template_Search_Rec_Type;
821: l_task_template_group_tbl Cs_AutoGen_Task_PVT.Task_Template_Group_Tbl_Type;
822: l_task_template_table JTF_TASK_INST_TEMPLATES_PUB.task_template_info_tbl;
823: l_task_template_group_rec JTF_TASK_INST_TEMPLATES_PUB.task_template_group_info;
824: l_task_template_group_owner NUMBER := NULL;
825: l_task_tmpl_group_owner_type VARCHAR2(240) := NULL;

Line 857: SAVEPOINT CS_AutoGen_Task_PVT ;

853: BEGIN
854: -- Declare a savepoint to rollback to in case of errors in task creation.
855: -- API standard start of API saveponit
856:
857: SAVEPOINT CS_AutoGen_Task_PVT ;
858:
859: -- Initialize message list if p_init_msg_list is set to TRUE
860: IF FND_API.To_Boolean(p_init_msg_list) THEN
861: FND_MSG_PUB.Initialize;

Line 919: CS_Autogen_Task_PVT.Get_Task_Template_Group

915:
916: -- Determine the task template group by calling the Get Task Template Group API
917:
918:
919: CS_Autogen_Task_PVT.Get_Task_Template_Group
920: ( p_api_version => 1.0,
921: p_init_msg_list => fnd_api.g_false,
922: p_commit => p_commit,
923: p_validation_level => p_validation_level,

Line 1123: ROLLBACK to CS_AutoGen_Task_PVT ;

1119:
1120:
1121: EXCEPTION
1122: WHEN FND_API.G_EXC_ERROR THEN
1123: ROLLBACK to CS_AutoGen_Task_PVT ;
1124: x_return_status := FND_API.G_RET_STS_ERROR;
1125: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1126:
1127: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1128: ROLLBACK to CS_AutoGen_Task_PVT ;

1124: x_return_status := FND_API.G_RET_STS_ERROR;
1125: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1126:
1127: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1128: ROLLBACK to CS_AutoGen_Task_PVT ;
1129: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1130: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1131:
1132: -- Added new exception handler for mutiple template group error --anmukher -- 08/22/03

Line 1134: ROLLBACK to CS_AutoGen_Task_PVT ;

1130: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1131:
1132: -- Added new exception handler for mutiple template group error --anmukher -- 08/22/03
1133: WHEN Many_Task_Tmpl_Found THEN
1134: ROLLBACK to CS_AutoGen_Task_PVT ;
1135: x_return_status := FND_API.G_RET_STS_ERROR;
1136: FND_MESSAGE.SET_NAME ('CS', 'CS_SR_TGT_MULTIPLE_TGT_ERROR');
1137: FND_MESSAGE.SET_TOKEN ('TASK_GROUP_TEMPLATES',l_task_tmpl_groups_found);
1138: FND_MSG_PUB.ADD;

Line 1145: ROLLBACK to CS_AutoGen_Task_PVT ;

1141: p_data => x_msg_data);
1142:
1143: -- Added new exception handler for auto task creation failure with single template group --anmukher -- 08/22/03
1144: WHEN Task_Creation_Failed THEN
1145: ROLLBACK to CS_AutoGen_Task_PVT ;
1146: x_return_status := FND_API.G_RET_STS_ERROR;
1147: -- Message commented out since Create_Task_From_Template API is already
1148: -- stacking specific error message on failure --anmukher --10/30/2003
1149: /*

Line 1159: ROLLBACK to CS_AutoGen_Task_PVT ;

1155: p_count => x_msg_count,
1156: p_data => x_msg_data);
1157:
1158: WHEN OTHERS THEN
1159: ROLLBACK to CS_AutoGen_Task_PVT ;
1160: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1161: If c_get_task_tmpl_grp_info%IsOpen Then
1162: close c_get_task_tmpl_grp_info;
1163: End If;

Line 1213: END CS_AutoGen_Task_PVT;

1209: END Get_Task_Template_Status;
1210:
1211:
1212:
1213: END CS_AutoGen_Task_PVT;