[Home] [Help]
1: PACKAGE BODY pa_action_sets_pub AS
2: /*$Header: PARASPUB.pls 120.3 2007/02/06 09:45:50 dthakker ship $*/
3: --
4: PROCEDURE create_action_set
5: (p_action_set_type_code IN pa_action_set_types.action_set_type_code%TYPE
2: /*$Header: PARASPUB.pls 120.3 2007/02/06 09:45:50 dthakker ship $*/
3: --
4: PROCEDURE create_action_set
5: (p_action_set_type_code IN pa_action_set_types.action_set_type_code%TYPE
6: ,p_action_set_name IN pa_action_sets.action_set_name%TYPE
7: ,p_object_type IN pa_action_sets.object_type%TYPE := NULL
8: ,p_object_id IN pa_action_sets.object_id%TYPE := NULL
9: ,p_start_date_active IN pa_action_sets.start_date_active%TYPE := NULL
10: ,p_end_date_active IN pa_action_sets.end_date_active%TYPE := NULL
3: --
4: PROCEDURE create_action_set
5: (p_action_set_type_code IN pa_action_set_types.action_set_type_code%TYPE
6: ,p_action_set_name IN pa_action_sets.action_set_name%TYPE
7: ,p_object_type IN pa_action_sets.object_type%TYPE := NULL
8: ,p_object_id IN pa_action_sets.object_id%TYPE := NULL
9: ,p_start_date_active IN pa_action_sets.start_date_active%TYPE := NULL
10: ,p_end_date_active IN pa_action_sets.end_date_active%TYPE := NULL
11: ,p_action_set_template_flag IN pa_action_sets.action_set_template_flag%TYPE := NULL
4: PROCEDURE create_action_set
5: (p_action_set_type_code IN pa_action_set_types.action_set_type_code%TYPE
6: ,p_action_set_name IN pa_action_sets.action_set_name%TYPE
7: ,p_object_type IN pa_action_sets.object_type%TYPE := NULL
8: ,p_object_id IN pa_action_sets.object_id%TYPE := NULL
9: ,p_start_date_active IN pa_action_sets.start_date_active%TYPE := NULL
10: ,p_end_date_active IN pa_action_sets.end_date_active%TYPE := NULL
11: ,p_action_set_template_flag IN pa_action_sets.action_set_template_flag%TYPE := NULL
12: ,p_source_action_set_id IN pa_action_sets.source_action_set_id%TYPE := NULL
5: (p_action_set_type_code IN pa_action_set_types.action_set_type_code%TYPE
6: ,p_action_set_name IN pa_action_sets.action_set_name%TYPE
7: ,p_object_type IN pa_action_sets.object_type%TYPE := NULL
8: ,p_object_id IN pa_action_sets.object_id%TYPE := NULL
9: ,p_start_date_active IN pa_action_sets.start_date_active%TYPE := NULL
10: ,p_end_date_active IN pa_action_sets.end_date_active%TYPE := NULL
11: ,p_action_set_template_flag IN pa_action_sets.action_set_template_flag%TYPE := NULL
12: ,p_source_action_set_id IN pa_action_sets.source_action_set_id%TYPE := NULL
13: ,p_status_code IN pa_action_sets.status_code%TYPE := NULL
6: ,p_action_set_name IN pa_action_sets.action_set_name%TYPE
7: ,p_object_type IN pa_action_sets.object_type%TYPE := NULL
8: ,p_object_id IN pa_action_sets.object_id%TYPE := NULL
9: ,p_start_date_active IN pa_action_sets.start_date_active%TYPE := NULL
10: ,p_end_date_active IN pa_action_sets.end_date_active%TYPE := NULL
11: ,p_action_set_template_flag IN pa_action_sets.action_set_template_flag%TYPE := NULL
12: ,p_source_action_set_id IN pa_action_sets.source_action_set_id%TYPE := NULL
13: ,p_status_code IN pa_action_sets.status_code%TYPE := NULL
14: ,p_description IN pa_action_sets.description%TYPE := NULL
7: ,p_object_type IN pa_action_sets.object_type%TYPE := NULL
8: ,p_object_id IN pa_action_sets.object_id%TYPE := NULL
9: ,p_start_date_active IN pa_action_sets.start_date_active%TYPE := NULL
10: ,p_end_date_active IN pa_action_sets.end_date_active%TYPE := NULL
11: ,p_action_set_template_flag IN pa_action_sets.action_set_template_flag%TYPE := NULL
12: ,p_source_action_set_id IN pa_action_sets.source_action_set_id%TYPE := NULL
13: ,p_status_code IN pa_action_sets.status_code%TYPE := NULL
14: ,p_description IN pa_action_sets.description%TYPE := NULL
15: ,p_attribute_category IN pa_action_sets.attribute_category%TYPE := NULL
8: ,p_object_id IN pa_action_sets.object_id%TYPE := NULL
9: ,p_start_date_active IN pa_action_sets.start_date_active%TYPE := NULL
10: ,p_end_date_active IN pa_action_sets.end_date_active%TYPE := NULL
11: ,p_action_set_template_flag IN pa_action_sets.action_set_template_flag%TYPE := NULL
12: ,p_source_action_set_id IN pa_action_sets.source_action_set_id%TYPE := NULL
13: ,p_status_code IN pa_action_sets.status_code%TYPE := NULL
14: ,p_description IN pa_action_sets.description%TYPE := NULL
15: ,p_attribute_category IN pa_action_sets.attribute_category%TYPE := NULL
16: ,p_attribute1 IN pa_action_sets.attribute1%TYPE := NULL
9: ,p_start_date_active IN pa_action_sets.start_date_active%TYPE := NULL
10: ,p_end_date_active IN pa_action_sets.end_date_active%TYPE := NULL
11: ,p_action_set_template_flag IN pa_action_sets.action_set_template_flag%TYPE := NULL
12: ,p_source_action_set_id IN pa_action_sets.source_action_set_id%TYPE := NULL
13: ,p_status_code IN pa_action_sets.status_code%TYPE := NULL
14: ,p_description IN pa_action_sets.description%TYPE := NULL
15: ,p_attribute_category IN pa_action_sets.attribute_category%TYPE := NULL
16: ,p_attribute1 IN pa_action_sets.attribute1%TYPE := NULL
17: ,p_attribute2 IN pa_action_sets.attribute2%TYPE := NULL
10: ,p_end_date_active IN pa_action_sets.end_date_active%TYPE := NULL
11: ,p_action_set_template_flag IN pa_action_sets.action_set_template_flag%TYPE := NULL
12: ,p_source_action_set_id IN pa_action_sets.source_action_set_id%TYPE := NULL
13: ,p_status_code IN pa_action_sets.status_code%TYPE := NULL
14: ,p_description IN pa_action_sets.description%TYPE := NULL
15: ,p_attribute_category IN pa_action_sets.attribute_category%TYPE := NULL
16: ,p_attribute1 IN pa_action_sets.attribute1%TYPE := NULL
17: ,p_attribute2 IN pa_action_sets.attribute2%TYPE := NULL
18: ,p_attribute3 IN pa_action_sets.attribute3%TYPE := NULL
11: ,p_action_set_template_flag IN pa_action_sets.action_set_template_flag%TYPE := NULL
12: ,p_source_action_set_id IN pa_action_sets.source_action_set_id%TYPE := NULL
13: ,p_status_code IN pa_action_sets.status_code%TYPE := NULL
14: ,p_description IN pa_action_sets.description%TYPE := NULL
15: ,p_attribute_category IN pa_action_sets.attribute_category%TYPE := NULL
16: ,p_attribute1 IN pa_action_sets.attribute1%TYPE := NULL
17: ,p_attribute2 IN pa_action_sets.attribute2%TYPE := NULL
18: ,p_attribute3 IN pa_action_sets.attribute3%TYPE := NULL
19: ,p_attribute4 IN pa_action_sets.attribute4%TYPE := NULL
12: ,p_source_action_set_id IN pa_action_sets.source_action_set_id%TYPE := NULL
13: ,p_status_code IN pa_action_sets.status_code%TYPE := NULL
14: ,p_description IN pa_action_sets.description%TYPE := NULL
15: ,p_attribute_category IN pa_action_sets.attribute_category%TYPE := NULL
16: ,p_attribute1 IN pa_action_sets.attribute1%TYPE := NULL
17: ,p_attribute2 IN pa_action_sets.attribute2%TYPE := NULL
18: ,p_attribute3 IN pa_action_sets.attribute3%TYPE := NULL
19: ,p_attribute4 IN pa_action_sets.attribute4%TYPE := NULL
20: ,p_attribute5 IN pa_action_sets.attribute5%TYPE := NULL
13: ,p_status_code IN pa_action_sets.status_code%TYPE := NULL
14: ,p_description IN pa_action_sets.description%TYPE := NULL
15: ,p_attribute_category IN pa_action_sets.attribute_category%TYPE := NULL
16: ,p_attribute1 IN pa_action_sets.attribute1%TYPE := NULL
17: ,p_attribute2 IN pa_action_sets.attribute2%TYPE := NULL
18: ,p_attribute3 IN pa_action_sets.attribute3%TYPE := NULL
19: ,p_attribute4 IN pa_action_sets.attribute4%TYPE := NULL
20: ,p_attribute5 IN pa_action_sets.attribute5%TYPE := NULL
21: ,p_attribute6 IN pa_action_sets.attribute6%TYPE := NULL
14: ,p_description IN pa_action_sets.description%TYPE := NULL
15: ,p_attribute_category IN pa_action_sets.attribute_category%TYPE := NULL
16: ,p_attribute1 IN pa_action_sets.attribute1%TYPE := NULL
17: ,p_attribute2 IN pa_action_sets.attribute2%TYPE := NULL
18: ,p_attribute3 IN pa_action_sets.attribute3%TYPE := NULL
19: ,p_attribute4 IN pa_action_sets.attribute4%TYPE := NULL
20: ,p_attribute5 IN pa_action_sets.attribute5%TYPE := NULL
21: ,p_attribute6 IN pa_action_sets.attribute6%TYPE := NULL
22: ,p_attribute7 IN pa_action_sets.attribute7%TYPE := NULL
15: ,p_attribute_category IN pa_action_sets.attribute_category%TYPE := NULL
16: ,p_attribute1 IN pa_action_sets.attribute1%TYPE := NULL
17: ,p_attribute2 IN pa_action_sets.attribute2%TYPE := NULL
18: ,p_attribute3 IN pa_action_sets.attribute3%TYPE := NULL
19: ,p_attribute4 IN pa_action_sets.attribute4%TYPE := NULL
20: ,p_attribute5 IN pa_action_sets.attribute5%TYPE := NULL
21: ,p_attribute6 IN pa_action_sets.attribute6%TYPE := NULL
22: ,p_attribute7 IN pa_action_sets.attribute7%TYPE := NULL
23: ,p_attribute8 IN pa_action_sets.attribute8%TYPE := NULL
16: ,p_attribute1 IN pa_action_sets.attribute1%TYPE := NULL
17: ,p_attribute2 IN pa_action_sets.attribute2%TYPE := NULL
18: ,p_attribute3 IN pa_action_sets.attribute3%TYPE := NULL
19: ,p_attribute4 IN pa_action_sets.attribute4%TYPE := NULL
20: ,p_attribute5 IN pa_action_sets.attribute5%TYPE := NULL
21: ,p_attribute6 IN pa_action_sets.attribute6%TYPE := NULL
22: ,p_attribute7 IN pa_action_sets.attribute7%TYPE := NULL
23: ,p_attribute8 IN pa_action_sets.attribute8%TYPE := NULL
24: ,p_attribute9 IN pa_action_sets.attribute9%TYPE := NULL
17: ,p_attribute2 IN pa_action_sets.attribute2%TYPE := NULL
18: ,p_attribute3 IN pa_action_sets.attribute3%TYPE := NULL
19: ,p_attribute4 IN pa_action_sets.attribute4%TYPE := NULL
20: ,p_attribute5 IN pa_action_sets.attribute5%TYPE := NULL
21: ,p_attribute6 IN pa_action_sets.attribute6%TYPE := NULL
22: ,p_attribute7 IN pa_action_sets.attribute7%TYPE := NULL
23: ,p_attribute8 IN pa_action_sets.attribute8%TYPE := NULL
24: ,p_attribute9 IN pa_action_sets.attribute9%TYPE := NULL
25: ,p_attribute10 IN pa_action_sets.attribute10%TYPE := NULL
18: ,p_attribute3 IN pa_action_sets.attribute3%TYPE := NULL
19: ,p_attribute4 IN pa_action_sets.attribute4%TYPE := NULL
20: ,p_attribute5 IN pa_action_sets.attribute5%TYPE := NULL
21: ,p_attribute6 IN pa_action_sets.attribute6%TYPE := NULL
22: ,p_attribute7 IN pa_action_sets.attribute7%TYPE := NULL
23: ,p_attribute8 IN pa_action_sets.attribute8%TYPE := NULL
24: ,p_attribute9 IN pa_action_sets.attribute9%TYPE := NULL
25: ,p_attribute10 IN pa_action_sets.attribute10%TYPE := NULL
26: ,p_attribute11 IN pa_action_sets.attribute11%TYPE := NULL
19: ,p_attribute4 IN pa_action_sets.attribute4%TYPE := NULL
20: ,p_attribute5 IN pa_action_sets.attribute5%TYPE := NULL
21: ,p_attribute6 IN pa_action_sets.attribute6%TYPE := NULL
22: ,p_attribute7 IN pa_action_sets.attribute7%TYPE := NULL
23: ,p_attribute8 IN pa_action_sets.attribute8%TYPE := NULL
24: ,p_attribute9 IN pa_action_sets.attribute9%TYPE := NULL
25: ,p_attribute10 IN pa_action_sets.attribute10%TYPE := NULL
26: ,p_attribute11 IN pa_action_sets.attribute11%TYPE := NULL
27: ,p_attribute12 IN pa_action_sets.attribute12%TYPE := NULL
20: ,p_attribute5 IN pa_action_sets.attribute5%TYPE := NULL
21: ,p_attribute6 IN pa_action_sets.attribute6%TYPE := NULL
22: ,p_attribute7 IN pa_action_sets.attribute7%TYPE := NULL
23: ,p_attribute8 IN pa_action_sets.attribute8%TYPE := NULL
24: ,p_attribute9 IN pa_action_sets.attribute9%TYPE := NULL
25: ,p_attribute10 IN pa_action_sets.attribute10%TYPE := NULL
26: ,p_attribute11 IN pa_action_sets.attribute11%TYPE := NULL
27: ,p_attribute12 IN pa_action_sets.attribute12%TYPE := NULL
28: ,p_attribute13 IN pa_action_sets.attribute13%TYPE := NULL
21: ,p_attribute6 IN pa_action_sets.attribute6%TYPE := NULL
22: ,p_attribute7 IN pa_action_sets.attribute7%TYPE := NULL
23: ,p_attribute8 IN pa_action_sets.attribute8%TYPE := NULL
24: ,p_attribute9 IN pa_action_sets.attribute9%TYPE := NULL
25: ,p_attribute10 IN pa_action_sets.attribute10%TYPE := NULL
26: ,p_attribute11 IN pa_action_sets.attribute11%TYPE := NULL
27: ,p_attribute12 IN pa_action_sets.attribute12%TYPE := NULL
28: ,p_attribute13 IN pa_action_sets.attribute13%TYPE := NULL
29: ,p_attribute14 IN pa_action_sets.attribute14%TYPE := NULL
22: ,p_attribute7 IN pa_action_sets.attribute7%TYPE := NULL
23: ,p_attribute8 IN pa_action_sets.attribute8%TYPE := NULL
24: ,p_attribute9 IN pa_action_sets.attribute9%TYPE := NULL
25: ,p_attribute10 IN pa_action_sets.attribute10%TYPE := NULL
26: ,p_attribute11 IN pa_action_sets.attribute11%TYPE := NULL
27: ,p_attribute12 IN pa_action_sets.attribute12%TYPE := NULL
28: ,p_attribute13 IN pa_action_sets.attribute13%TYPE := NULL
29: ,p_attribute14 IN pa_action_sets.attribute14%TYPE := NULL
30: ,p_attribute15 IN pa_action_sets.attribute15%TYPE := NULL
23: ,p_attribute8 IN pa_action_sets.attribute8%TYPE := NULL
24: ,p_attribute9 IN pa_action_sets.attribute9%TYPE := NULL
25: ,p_attribute10 IN pa_action_sets.attribute10%TYPE := NULL
26: ,p_attribute11 IN pa_action_sets.attribute11%TYPE := NULL
27: ,p_attribute12 IN pa_action_sets.attribute12%TYPE := NULL
28: ,p_attribute13 IN pa_action_sets.attribute13%TYPE := NULL
29: ,p_attribute14 IN pa_action_sets.attribute14%TYPE := NULL
30: ,p_attribute15 IN pa_action_sets.attribute15%TYPE := NULL
31: ,p_api_version IN NUMBER := 1.0
24: ,p_attribute9 IN pa_action_sets.attribute9%TYPE := NULL
25: ,p_attribute10 IN pa_action_sets.attribute10%TYPE := NULL
26: ,p_attribute11 IN pa_action_sets.attribute11%TYPE := NULL
27: ,p_attribute12 IN pa_action_sets.attribute12%TYPE := NULL
28: ,p_attribute13 IN pa_action_sets.attribute13%TYPE := NULL
29: ,p_attribute14 IN pa_action_sets.attribute14%TYPE := NULL
30: ,p_attribute15 IN pa_action_sets.attribute15%TYPE := NULL
31: ,p_api_version IN NUMBER := 1.0
32: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
25: ,p_attribute10 IN pa_action_sets.attribute10%TYPE := NULL
26: ,p_attribute11 IN pa_action_sets.attribute11%TYPE := NULL
27: ,p_attribute12 IN pa_action_sets.attribute12%TYPE := NULL
28: ,p_attribute13 IN pa_action_sets.attribute13%TYPE := NULL
29: ,p_attribute14 IN pa_action_sets.attribute14%TYPE := NULL
30: ,p_attribute15 IN pa_action_sets.attribute15%TYPE := NULL
31: ,p_api_version IN NUMBER := 1.0
32: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
33: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
26: ,p_attribute11 IN pa_action_sets.attribute11%TYPE := NULL
27: ,p_attribute12 IN pa_action_sets.attribute12%TYPE := NULL
28: ,p_attribute13 IN pa_action_sets.attribute13%TYPE := NULL
29: ,p_attribute14 IN pa_action_sets.attribute14%TYPE := NULL
30: ,p_attribute15 IN pa_action_sets.attribute15%TYPE := NULL
31: ,p_api_version IN NUMBER := 1.0
32: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
33: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
34: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
45:
46: BEGIN
47:
48: -- Initialize the Error Stack
49: PA_DEBUG.init_err_stack('PA_ACTION_SETS_PUB.Create_Action_Set');
50:
51: -- Bug 4403338
52: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
53:
65: END IF;
66:
67: --Log Message: 4403338
68: IF l_debug_mode = 'Y' THEN
69: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ACTION_SETS_PUB.Create_Action_Set.begin'
70: ,x_msg => 'Beginning of Create_Action_Set pub'
71: ,x_log_level => 5);
72:
73: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ACTION_SETS_PUB.Create_Action_Set.begin'
69: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ACTION_SETS_PUB.Create_Action_Set.begin'
70: ,x_msg => 'Beginning of Create_Action_Set pub'
71: ,x_log_level => 5);
72:
73: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ACTION_SETS_PUB.Create_Action_Set.begin'
74: ,x_msg => 'calling create_Action_Set pvt'
75: ,x_log_level => 5);
76: END IF;
77:
75: ,x_log_level => 5);
76: END IF;
77:
78:
79: PA_ACTION_SETS_PVT.create_action_set
80: (p_action_set_type_code => p_action_set_type_code
81: ,p_action_set_name => p_action_set_name
82: ,p_object_type => p_object_type
83: ,p_object_id => p_object_id
134: ROLLBACK TO CREATE_ACTION_SETS_PUB;
135: END IF;
136:
137: -- Set the excetption Message and the stack
138: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_ACTION_SETS_PUB.Create_Action_Set'
139: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
140: --
141: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
142: RAISE;
144: END Create_Action_Set;
145:
146:
147: PROCEDURE update_action_set
148: (p_action_set_id IN pa_action_sets.action_set_id%TYPE := NULL
149: ,p_action_set_name IN pa_action_sets.action_set_name%TYPE := FND_API.G_MISS_CHAR
150: ,p_object_type IN pa_action_sets.object_type%TYPE := FND_API.G_MISS_CHAR
151: ,p_action_set_type_code IN pa_action_sets.action_set_type_code%TYPE := FND_API.G_MISS_CHAR
152: ,p_object_id IN pa_action_sets.object_id%TYPE := FND_API.G_MISS_NUM
145:
146:
147: PROCEDURE update_action_set
148: (p_action_set_id IN pa_action_sets.action_set_id%TYPE := NULL
149: ,p_action_set_name IN pa_action_sets.action_set_name%TYPE := FND_API.G_MISS_CHAR
150: ,p_object_type IN pa_action_sets.object_type%TYPE := FND_API.G_MISS_CHAR
151: ,p_action_set_type_code IN pa_action_sets.action_set_type_code%TYPE := FND_API.G_MISS_CHAR
152: ,p_object_id IN pa_action_sets.object_id%TYPE := FND_API.G_MISS_NUM
153: ,p_start_date_active IN pa_action_sets.start_date_active%TYPE := FND_API.G_MISS_DATE
146:
147: PROCEDURE update_action_set
148: (p_action_set_id IN pa_action_sets.action_set_id%TYPE := NULL
149: ,p_action_set_name IN pa_action_sets.action_set_name%TYPE := FND_API.G_MISS_CHAR
150: ,p_object_type IN pa_action_sets.object_type%TYPE := FND_API.G_MISS_CHAR
151: ,p_action_set_type_code IN pa_action_sets.action_set_type_code%TYPE := FND_API.G_MISS_CHAR
152: ,p_object_id IN pa_action_sets.object_id%TYPE := FND_API.G_MISS_NUM
153: ,p_start_date_active IN pa_action_sets.start_date_active%TYPE := FND_API.G_MISS_DATE
154: ,p_end_date_active IN pa_action_sets.end_date_active%TYPE := FND_API.G_MISS_DATE
147: PROCEDURE update_action_set
148: (p_action_set_id IN pa_action_sets.action_set_id%TYPE := NULL
149: ,p_action_set_name IN pa_action_sets.action_set_name%TYPE := FND_API.G_MISS_CHAR
150: ,p_object_type IN pa_action_sets.object_type%TYPE := FND_API.G_MISS_CHAR
151: ,p_action_set_type_code IN pa_action_sets.action_set_type_code%TYPE := FND_API.G_MISS_CHAR
152: ,p_object_id IN pa_action_sets.object_id%TYPE := FND_API.G_MISS_NUM
153: ,p_start_date_active IN pa_action_sets.start_date_active%TYPE := FND_API.G_MISS_DATE
154: ,p_end_date_active IN pa_action_sets.end_date_active%TYPE := FND_API.G_MISS_DATE
155: ,p_action_set_template_flag IN pa_action_sets.action_set_template_flag%TYPE := FND_API.G_MISS_CHAR
148: (p_action_set_id IN pa_action_sets.action_set_id%TYPE := NULL
149: ,p_action_set_name IN pa_action_sets.action_set_name%TYPE := FND_API.G_MISS_CHAR
150: ,p_object_type IN pa_action_sets.object_type%TYPE := FND_API.G_MISS_CHAR
151: ,p_action_set_type_code IN pa_action_sets.action_set_type_code%TYPE := FND_API.G_MISS_CHAR
152: ,p_object_id IN pa_action_sets.object_id%TYPE := FND_API.G_MISS_NUM
153: ,p_start_date_active IN pa_action_sets.start_date_active%TYPE := FND_API.G_MISS_DATE
154: ,p_end_date_active IN pa_action_sets.end_date_active%TYPE := FND_API.G_MISS_DATE
155: ,p_action_set_template_flag IN pa_action_sets.action_set_template_flag%TYPE := FND_API.G_MISS_CHAR
156: ,p_status_code IN pa_action_sets.status_code%TYPE := FND_API.G_MISS_CHAR
149: ,p_action_set_name IN pa_action_sets.action_set_name%TYPE := FND_API.G_MISS_CHAR
150: ,p_object_type IN pa_action_sets.object_type%TYPE := FND_API.G_MISS_CHAR
151: ,p_action_set_type_code IN pa_action_sets.action_set_type_code%TYPE := FND_API.G_MISS_CHAR
152: ,p_object_id IN pa_action_sets.object_id%TYPE := FND_API.G_MISS_NUM
153: ,p_start_date_active IN pa_action_sets.start_date_active%TYPE := FND_API.G_MISS_DATE
154: ,p_end_date_active IN pa_action_sets.end_date_active%TYPE := FND_API.G_MISS_DATE
155: ,p_action_set_template_flag IN pa_action_sets.action_set_template_flag%TYPE := FND_API.G_MISS_CHAR
156: ,p_status_code IN pa_action_sets.status_code%TYPE := FND_API.G_MISS_CHAR
157: ,p_description IN pa_action_sets.description%TYPE := FND_API.G_MISS_CHAR
150: ,p_object_type IN pa_action_sets.object_type%TYPE := FND_API.G_MISS_CHAR
151: ,p_action_set_type_code IN pa_action_sets.action_set_type_code%TYPE := FND_API.G_MISS_CHAR
152: ,p_object_id IN pa_action_sets.object_id%TYPE := FND_API.G_MISS_NUM
153: ,p_start_date_active IN pa_action_sets.start_date_active%TYPE := FND_API.G_MISS_DATE
154: ,p_end_date_active IN pa_action_sets.end_date_active%TYPE := FND_API.G_MISS_DATE
155: ,p_action_set_template_flag IN pa_action_sets.action_set_template_flag%TYPE := FND_API.G_MISS_CHAR
156: ,p_status_code IN pa_action_sets.status_code%TYPE := FND_API.G_MISS_CHAR
157: ,p_description IN pa_action_sets.description%TYPE := FND_API.G_MISS_CHAR
158: ,p_record_version_number IN pa_action_sets.record_version_number%TYPE
151: ,p_action_set_type_code IN pa_action_sets.action_set_type_code%TYPE := FND_API.G_MISS_CHAR
152: ,p_object_id IN pa_action_sets.object_id%TYPE := FND_API.G_MISS_NUM
153: ,p_start_date_active IN pa_action_sets.start_date_active%TYPE := FND_API.G_MISS_DATE
154: ,p_end_date_active IN pa_action_sets.end_date_active%TYPE := FND_API.G_MISS_DATE
155: ,p_action_set_template_flag IN pa_action_sets.action_set_template_flag%TYPE := FND_API.G_MISS_CHAR
156: ,p_status_code IN pa_action_sets.status_code%TYPE := FND_API.G_MISS_CHAR
157: ,p_description IN pa_action_sets.description%TYPE := FND_API.G_MISS_CHAR
158: ,p_record_version_number IN pa_action_sets.record_version_number%TYPE
159: ,p_attribute_category IN pa_action_sets.attribute_category%TYPE := FND_API.G_MISS_CHAR
152: ,p_object_id IN pa_action_sets.object_id%TYPE := FND_API.G_MISS_NUM
153: ,p_start_date_active IN pa_action_sets.start_date_active%TYPE := FND_API.G_MISS_DATE
154: ,p_end_date_active IN pa_action_sets.end_date_active%TYPE := FND_API.G_MISS_DATE
155: ,p_action_set_template_flag IN pa_action_sets.action_set_template_flag%TYPE := FND_API.G_MISS_CHAR
156: ,p_status_code IN pa_action_sets.status_code%TYPE := FND_API.G_MISS_CHAR
157: ,p_description IN pa_action_sets.description%TYPE := FND_API.G_MISS_CHAR
158: ,p_record_version_number IN pa_action_sets.record_version_number%TYPE
159: ,p_attribute_category IN pa_action_sets.attribute_category%TYPE := FND_API.G_MISS_CHAR
160: ,p_attribute1 IN pa_action_sets.attribute1%TYPE := FND_API.G_MISS_CHAR
153: ,p_start_date_active IN pa_action_sets.start_date_active%TYPE := FND_API.G_MISS_DATE
154: ,p_end_date_active IN pa_action_sets.end_date_active%TYPE := FND_API.G_MISS_DATE
155: ,p_action_set_template_flag IN pa_action_sets.action_set_template_flag%TYPE := FND_API.G_MISS_CHAR
156: ,p_status_code IN pa_action_sets.status_code%TYPE := FND_API.G_MISS_CHAR
157: ,p_description IN pa_action_sets.description%TYPE := FND_API.G_MISS_CHAR
158: ,p_record_version_number IN pa_action_sets.record_version_number%TYPE
159: ,p_attribute_category IN pa_action_sets.attribute_category%TYPE := FND_API.G_MISS_CHAR
160: ,p_attribute1 IN pa_action_sets.attribute1%TYPE := FND_API.G_MISS_CHAR
161: ,p_attribute2 IN pa_action_sets.attribute2%TYPE := FND_API.G_MISS_CHAR
154: ,p_end_date_active IN pa_action_sets.end_date_active%TYPE := FND_API.G_MISS_DATE
155: ,p_action_set_template_flag IN pa_action_sets.action_set_template_flag%TYPE := FND_API.G_MISS_CHAR
156: ,p_status_code IN pa_action_sets.status_code%TYPE := FND_API.G_MISS_CHAR
157: ,p_description IN pa_action_sets.description%TYPE := FND_API.G_MISS_CHAR
158: ,p_record_version_number IN pa_action_sets.record_version_number%TYPE
159: ,p_attribute_category IN pa_action_sets.attribute_category%TYPE := FND_API.G_MISS_CHAR
160: ,p_attribute1 IN pa_action_sets.attribute1%TYPE := FND_API.G_MISS_CHAR
161: ,p_attribute2 IN pa_action_sets.attribute2%TYPE := FND_API.G_MISS_CHAR
162: ,p_attribute3 IN pa_action_sets.attribute3%TYPE := FND_API.G_MISS_CHAR
155: ,p_action_set_template_flag IN pa_action_sets.action_set_template_flag%TYPE := FND_API.G_MISS_CHAR
156: ,p_status_code IN pa_action_sets.status_code%TYPE := FND_API.G_MISS_CHAR
157: ,p_description IN pa_action_sets.description%TYPE := FND_API.G_MISS_CHAR
158: ,p_record_version_number IN pa_action_sets.record_version_number%TYPE
159: ,p_attribute_category IN pa_action_sets.attribute_category%TYPE := FND_API.G_MISS_CHAR
160: ,p_attribute1 IN pa_action_sets.attribute1%TYPE := FND_API.G_MISS_CHAR
161: ,p_attribute2 IN pa_action_sets.attribute2%TYPE := FND_API.G_MISS_CHAR
162: ,p_attribute3 IN pa_action_sets.attribute3%TYPE := FND_API.G_MISS_CHAR
163: ,p_attribute4 IN pa_action_sets.attribute4%TYPE := FND_API.G_MISS_CHAR
156: ,p_status_code IN pa_action_sets.status_code%TYPE := FND_API.G_MISS_CHAR
157: ,p_description IN pa_action_sets.description%TYPE := FND_API.G_MISS_CHAR
158: ,p_record_version_number IN pa_action_sets.record_version_number%TYPE
159: ,p_attribute_category IN pa_action_sets.attribute_category%TYPE := FND_API.G_MISS_CHAR
160: ,p_attribute1 IN pa_action_sets.attribute1%TYPE := FND_API.G_MISS_CHAR
161: ,p_attribute2 IN pa_action_sets.attribute2%TYPE := FND_API.G_MISS_CHAR
162: ,p_attribute3 IN pa_action_sets.attribute3%TYPE := FND_API.G_MISS_CHAR
163: ,p_attribute4 IN pa_action_sets.attribute4%TYPE := FND_API.G_MISS_CHAR
164: ,p_attribute5 IN pa_action_sets.attribute5%TYPE := FND_API.G_MISS_CHAR
157: ,p_description IN pa_action_sets.description%TYPE := FND_API.G_MISS_CHAR
158: ,p_record_version_number IN pa_action_sets.record_version_number%TYPE
159: ,p_attribute_category IN pa_action_sets.attribute_category%TYPE := FND_API.G_MISS_CHAR
160: ,p_attribute1 IN pa_action_sets.attribute1%TYPE := FND_API.G_MISS_CHAR
161: ,p_attribute2 IN pa_action_sets.attribute2%TYPE := FND_API.G_MISS_CHAR
162: ,p_attribute3 IN pa_action_sets.attribute3%TYPE := FND_API.G_MISS_CHAR
163: ,p_attribute4 IN pa_action_sets.attribute4%TYPE := FND_API.G_MISS_CHAR
164: ,p_attribute5 IN pa_action_sets.attribute5%TYPE := FND_API.G_MISS_CHAR
165: ,p_attribute6 IN pa_action_sets.attribute6%TYPE := FND_API.G_MISS_CHAR
158: ,p_record_version_number IN pa_action_sets.record_version_number%TYPE
159: ,p_attribute_category IN pa_action_sets.attribute_category%TYPE := FND_API.G_MISS_CHAR
160: ,p_attribute1 IN pa_action_sets.attribute1%TYPE := FND_API.G_MISS_CHAR
161: ,p_attribute2 IN pa_action_sets.attribute2%TYPE := FND_API.G_MISS_CHAR
162: ,p_attribute3 IN pa_action_sets.attribute3%TYPE := FND_API.G_MISS_CHAR
163: ,p_attribute4 IN pa_action_sets.attribute4%TYPE := FND_API.G_MISS_CHAR
164: ,p_attribute5 IN pa_action_sets.attribute5%TYPE := FND_API.G_MISS_CHAR
165: ,p_attribute6 IN pa_action_sets.attribute6%TYPE := FND_API.G_MISS_CHAR
166: ,p_attribute7 IN pa_action_sets.attribute7%TYPE := FND_API.G_MISS_CHAR
159: ,p_attribute_category IN pa_action_sets.attribute_category%TYPE := FND_API.G_MISS_CHAR
160: ,p_attribute1 IN pa_action_sets.attribute1%TYPE := FND_API.G_MISS_CHAR
161: ,p_attribute2 IN pa_action_sets.attribute2%TYPE := FND_API.G_MISS_CHAR
162: ,p_attribute3 IN pa_action_sets.attribute3%TYPE := FND_API.G_MISS_CHAR
163: ,p_attribute4 IN pa_action_sets.attribute4%TYPE := FND_API.G_MISS_CHAR
164: ,p_attribute5 IN pa_action_sets.attribute5%TYPE := FND_API.G_MISS_CHAR
165: ,p_attribute6 IN pa_action_sets.attribute6%TYPE := FND_API.G_MISS_CHAR
166: ,p_attribute7 IN pa_action_sets.attribute7%TYPE := FND_API.G_MISS_CHAR
167: ,p_attribute8 IN pa_action_sets.attribute8%TYPE := FND_API.G_MISS_CHAR
160: ,p_attribute1 IN pa_action_sets.attribute1%TYPE := FND_API.G_MISS_CHAR
161: ,p_attribute2 IN pa_action_sets.attribute2%TYPE := FND_API.G_MISS_CHAR
162: ,p_attribute3 IN pa_action_sets.attribute3%TYPE := FND_API.G_MISS_CHAR
163: ,p_attribute4 IN pa_action_sets.attribute4%TYPE := FND_API.G_MISS_CHAR
164: ,p_attribute5 IN pa_action_sets.attribute5%TYPE := FND_API.G_MISS_CHAR
165: ,p_attribute6 IN pa_action_sets.attribute6%TYPE := FND_API.G_MISS_CHAR
166: ,p_attribute7 IN pa_action_sets.attribute7%TYPE := FND_API.G_MISS_CHAR
167: ,p_attribute8 IN pa_action_sets.attribute8%TYPE := FND_API.G_MISS_CHAR
168: ,p_attribute9 IN pa_action_sets.attribute9%TYPE := FND_API.G_MISS_CHAR
161: ,p_attribute2 IN pa_action_sets.attribute2%TYPE := FND_API.G_MISS_CHAR
162: ,p_attribute3 IN pa_action_sets.attribute3%TYPE := FND_API.G_MISS_CHAR
163: ,p_attribute4 IN pa_action_sets.attribute4%TYPE := FND_API.G_MISS_CHAR
164: ,p_attribute5 IN pa_action_sets.attribute5%TYPE := FND_API.G_MISS_CHAR
165: ,p_attribute6 IN pa_action_sets.attribute6%TYPE := FND_API.G_MISS_CHAR
166: ,p_attribute7 IN pa_action_sets.attribute7%TYPE := FND_API.G_MISS_CHAR
167: ,p_attribute8 IN pa_action_sets.attribute8%TYPE := FND_API.G_MISS_CHAR
168: ,p_attribute9 IN pa_action_sets.attribute9%TYPE := FND_API.G_MISS_CHAR
169: ,p_attribute10 IN pa_action_sets.attribute10%TYPE := FND_API.G_MISS_CHAR
162: ,p_attribute3 IN pa_action_sets.attribute3%TYPE := FND_API.G_MISS_CHAR
163: ,p_attribute4 IN pa_action_sets.attribute4%TYPE := FND_API.G_MISS_CHAR
164: ,p_attribute5 IN pa_action_sets.attribute5%TYPE := FND_API.G_MISS_CHAR
165: ,p_attribute6 IN pa_action_sets.attribute6%TYPE := FND_API.G_MISS_CHAR
166: ,p_attribute7 IN pa_action_sets.attribute7%TYPE := FND_API.G_MISS_CHAR
167: ,p_attribute8 IN pa_action_sets.attribute8%TYPE := FND_API.G_MISS_CHAR
168: ,p_attribute9 IN pa_action_sets.attribute9%TYPE := FND_API.G_MISS_CHAR
169: ,p_attribute10 IN pa_action_sets.attribute10%TYPE := FND_API.G_MISS_CHAR
170: ,p_attribute11 IN pa_action_sets.attribute11%TYPE := FND_API.G_MISS_CHAR
163: ,p_attribute4 IN pa_action_sets.attribute4%TYPE := FND_API.G_MISS_CHAR
164: ,p_attribute5 IN pa_action_sets.attribute5%TYPE := FND_API.G_MISS_CHAR
165: ,p_attribute6 IN pa_action_sets.attribute6%TYPE := FND_API.G_MISS_CHAR
166: ,p_attribute7 IN pa_action_sets.attribute7%TYPE := FND_API.G_MISS_CHAR
167: ,p_attribute8 IN pa_action_sets.attribute8%TYPE := FND_API.G_MISS_CHAR
168: ,p_attribute9 IN pa_action_sets.attribute9%TYPE := FND_API.G_MISS_CHAR
169: ,p_attribute10 IN pa_action_sets.attribute10%TYPE := FND_API.G_MISS_CHAR
170: ,p_attribute11 IN pa_action_sets.attribute11%TYPE := FND_API.G_MISS_CHAR
171: ,p_attribute12 IN pa_action_sets.attribute12%TYPE := FND_API.G_MISS_CHAR
164: ,p_attribute5 IN pa_action_sets.attribute5%TYPE := FND_API.G_MISS_CHAR
165: ,p_attribute6 IN pa_action_sets.attribute6%TYPE := FND_API.G_MISS_CHAR
166: ,p_attribute7 IN pa_action_sets.attribute7%TYPE := FND_API.G_MISS_CHAR
167: ,p_attribute8 IN pa_action_sets.attribute8%TYPE := FND_API.G_MISS_CHAR
168: ,p_attribute9 IN pa_action_sets.attribute9%TYPE := FND_API.G_MISS_CHAR
169: ,p_attribute10 IN pa_action_sets.attribute10%TYPE := FND_API.G_MISS_CHAR
170: ,p_attribute11 IN pa_action_sets.attribute11%TYPE := FND_API.G_MISS_CHAR
171: ,p_attribute12 IN pa_action_sets.attribute12%TYPE := FND_API.G_MISS_CHAR
172: ,p_attribute13 IN pa_action_sets.attribute13%TYPE := FND_API.G_MISS_CHAR
165: ,p_attribute6 IN pa_action_sets.attribute6%TYPE := FND_API.G_MISS_CHAR
166: ,p_attribute7 IN pa_action_sets.attribute7%TYPE := FND_API.G_MISS_CHAR
167: ,p_attribute8 IN pa_action_sets.attribute8%TYPE := FND_API.G_MISS_CHAR
168: ,p_attribute9 IN pa_action_sets.attribute9%TYPE := FND_API.G_MISS_CHAR
169: ,p_attribute10 IN pa_action_sets.attribute10%TYPE := FND_API.G_MISS_CHAR
170: ,p_attribute11 IN pa_action_sets.attribute11%TYPE := FND_API.G_MISS_CHAR
171: ,p_attribute12 IN pa_action_sets.attribute12%TYPE := FND_API.G_MISS_CHAR
172: ,p_attribute13 IN pa_action_sets.attribute13%TYPE := FND_API.G_MISS_CHAR
173: ,p_attribute14 IN pa_action_sets.attribute14%TYPE := FND_API.G_MISS_CHAR
166: ,p_attribute7 IN pa_action_sets.attribute7%TYPE := FND_API.G_MISS_CHAR
167: ,p_attribute8 IN pa_action_sets.attribute8%TYPE := FND_API.G_MISS_CHAR
168: ,p_attribute9 IN pa_action_sets.attribute9%TYPE := FND_API.G_MISS_CHAR
169: ,p_attribute10 IN pa_action_sets.attribute10%TYPE := FND_API.G_MISS_CHAR
170: ,p_attribute11 IN pa_action_sets.attribute11%TYPE := FND_API.G_MISS_CHAR
171: ,p_attribute12 IN pa_action_sets.attribute12%TYPE := FND_API.G_MISS_CHAR
172: ,p_attribute13 IN pa_action_sets.attribute13%TYPE := FND_API.G_MISS_CHAR
173: ,p_attribute14 IN pa_action_sets.attribute14%TYPE := FND_API.G_MISS_CHAR
174: ,p_attribute15 IN pa_action_sets.attribute15%TYPE := FND_API.G_MISS_CHAR
167: ,p_attribute8 IN pa_action_sets.attribute8%TYPE := FND_API.G_MISS_CHAR
168: ,p_attribute9 IN pa_action_sets.attribute9%TYPE := FND_API.G_MISS_CHAR
169: ,p_attribute10 IN pa_action_sets.attribute10%TYPE := FND_API.G_MISS_CHAR
170: ,p_attribute11 IN pa_action_sets.attribute11%TYPE := FND_API.G_MISS_CHAR
171: ,p_attribute12 IN pa_action_sets.attribute12%TYPE := FND_API.G_MISS_CHAR
172: ,p_attribute13 IN pa_action_sets.attribute13%TYPE := FND_API.G_MISS_CHAR
173: ,p_attribute14 IN pa_action_sets.attribute14%TYPE := FND_API.G_MISS_CHAR
174: ,p_attribute15 IN pa_action_sets.attribute15%TYPE := FND_API.G_MISS_CHAR
175: ,p_api_version IN NUMBER := 1.0
168: ,p_attribute9 IN pa_action_sets.attribute9%TYPE := FND_API.G_MISS_CHAR
169: ,p_attribute10 IN pa_action_sets.attribute10%TYPE := FND_API.G_MISS_CHAR
170: ,p_attribute11 IN pa_action_sets.attribute11%TYPE := FND_API.G_MISS_CHAR
171: ,p_attribute12 IN pa_action_sets.attribute12%TYPE := FND_API.G_MISS_CHAR
172: ,p_attribute13 IN pa_action_sets.attribute13%TYPE := FND_API.G_MISS_CHAR
173: ,p_attribute14 IN pa_action_sets.attribute14%TYPE := FND_API.G_MISS_CHAR
174: ,p_attribute15 IN pa_action_sets.attribute15%TYPE := FND_API.G_MISS_CHAR
175: ,p_api_version IN NUMBER := 1.0
176: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
169: ,p_attribute10 IN pa_action_sets.attribute10%TYPE := FND_API.G_MISS_CHAR
170: ,p_attribute11 IN pa_action_sets.attribute11%TYPE := FND_API.G_MISS_CHAR
171: ,p_attribute12 IN pa_action_sets.attribute12%TYPE := FND_API.G_MISS_CHAR
172: ,p_attribute13 IN pa_action_sets.attribute13%TYPE := FND_API.G_MISS_CHAR
173: ,p_attribute14 IN pa_action_sets.attribute14%TYPE := FND_API.G_MISS_CHAR
174: ,p_attribute15 IN pa_action_sets.attribute15%TYPE := FND_API.G_MISS_CHAR
175: ,p_api_version IN NUMBER := 1.0
176: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
177: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
170: ,p_attribute11 IN pa_action_sets.attribute11%TYPE := FND_API.G_MISS_CHAR
171: ,p_attribute12 IN pa_action_sets.attribute12%TYPE := FND_API.G_MISS_CHAR
172: ,p_attribute13 IN pa_action_sets.attribute13%TYPE := FND_API.G_MISS_CHAR
173: ,p_attribute14 IN pa_action_sets.attribute14%TYPE := FND_API.G_MISS_CHAR
174: ,p_attribute15 IN pa_action_sets.attribute15%TYPE := FND_API.G_MISS_CHAR
175: ,p_api_version IN NUMBER := 1.0
176: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
177: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
178: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
190:
191: BEGIN
192:
193: -- Initialize the Error Stack
194: PA_DEBUG.init_err_stack('PA_ACTION_SETS_PUB.Update_Action_Set');
195:
196: -- Bug 4403338
197: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
198:
210: END IF;
211:
212: --Log Message: 4403338
213: IF l_debug_mode = 'Y' THEN
214: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ACTION_SETS_PUB.Update_Action_Set.begin'
215: ,x_msg => 'Beginning of Update_Action_Set pub'
216: ,x_log_level => 5);
217: END IF;
218:
227:
228: BEGIN
229:
230: SELECT record_version_number INTO l_record_version_number
231: FROM pa_action_sets
232: WHERE action_set_id = l_action_set_id
233: AND record_version_number = p_record_version_number;
234:
235: EXCEPTION
240: END;
241:
242: --Log Message: 4403338
243: IF l_debug_mode = 'Y' THEN
244: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ACTION_SETS_PUB.Update_Action_Set.begin'
245: ,x_msg => 'calling Update_Action_Set pvt'
246: ,x_log_level => 5);
247: END IF;
248:
245: ,x_msg => 'calling Update_Action_Set pvt'
246: ,x_log_level => 5);
247: END IF;
248:
249: PA_ACTION_SETS_PVT.update_action_set
250: (p_action_set_id => l_action_set_id
251: ,p_action_set_name => p_action_set_name
252: ,p_action_set_type_code => p_action_set_type_code
253: ,p_start_date_active => p_start_date_active
302: ROLLBACK TO UPDATE_ACTION_SETS_PUB;
303: END IF;
304:
305: -- Set the excetption Message and the stack
306: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_ACTION_SETS_PUB.Update_Action_Set'
307: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
308: --
309: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
310: RAISE;
312: END Update_Action_Set;
313:
314:
315: PROCEDURE delete_action_set
316: (p_action_set_id IN pa_action_sets.action_set_id%TYPE := NULL
317: ,p_action_set_type_code IN pa_action_sets.action_set_type_code%TYPE := NULL
318: ,p_object_type IN pa_action_sets.object_type%TYPE := NULL
319: ,p_object_id IN pa_action_sets.object_id%TYPE := NULL
320: ,p_record_version_number IN pa_action_sets.record_version_number%TYPE
313:
314:
315: PROCEDURE delete_action_set
316: (p_action_set_id IN pa_action_sets.action_set_id%TYPE := NULL
317: ,p_action_set_type_code IN pa_action_sets.action_set_type_code%TYPE := NULL
318: ,p_object_type IN pa_action_sets.object_type%TYPE := NULL
319: ,p_object_id IN pa_action_sets.object_id%TYPE := NULL
320: ,p_record_version_number IN pa_action_sets.record_version_number%TYPE
321: ,p_api_version IN NUMBER := 1.0
314:
315: PROCEDURE delete_action_set
316: (p_action_set_id IN pa_action_sets.action_set_id%TYPE := NULL
317: ,p_action_set_type_code IN pa_action_sets.action_set_type_code%TYPE := NULL
318: ,p_object_type IN pa_action_sets.object_type%TYPE := NULL
319: ,p_object_id IN pa_action_sets.object_id%TYPE := NULL
320: ,p_record_version_number IN pa_action_sets.record_version_number%TYPE
321: ,p_api_version IN NUMBER := 1.0
322: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
315: PROCEDURE delete_action_set
316: (p_action_set_id IN pa_action_sets.action_set_id%TYPE := NULL
317: ,p_action_set_type_code IN pa_action_sets.action_set_type_code%TYPE := NULL
318: ,p_object_type IN pa_action_sets.object_type%TYPE := NULL
319: ,p_object_id IN pa_action_sets.object_id%TYPE := NULL
320: ,p_record_version_number IN pa_action_sets.record_version_number%TYPE
321: ,p_api_version IN NUMBER := 1.0
322: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
323: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
316: (p_action_set_id IN pa_action_sets.action_set_id%TYPE := NULL
317: ,p_action_set_type_code IN pa_action_sets.action_set_type_code%TYPE := NULL
318: ,p_object_type IN pa_action_sets.object_type%TYPE := NULL
319: ,p_object_id IN pa_action_sets.object_id%TYPE := NULL
320: ,p_record_version_number IN pa_action_sets.record_version_number%TYPE
321: ,p_api_version IN NUMBER := 1.0
322: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
323: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
324: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
341: -- End 5130421
342: BEGIN
343:
344: -- Initialize the Error Stack
345: PA_DEBUG.init_err_stack('PA_ACTION_SETS_PUB.Delete_Action_Set');
346:
347: -- Bug 4403338
348: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
349:
364: END IF;
365:
366: --Log Message: 4403338
367: IF l_debug_mode = 'Y' THEN
368: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ACTION_SETS_PUB.Delete_Action_Set.begin'
369: ,x_msg => 'Beginning of Delete_Action_Set pub'
370: ,x_log_level => 5);
371: END IF;
372:
381:
382: BEGIN
383:
384: SELECT record_version_number INTO l_record_version_number
385: FROM pa_action_sets
386: WHERE action_set_id = l_action_set_id
387: AND record_version_number = p_record_version_number;
388:
389: EXCEPTION
394: END;
395:
396: --Log Message: 4403338
397: IF l_debug_mode = 'Y' THEN
398: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ACTION_SETS_PUB.Delete_Action_Set.begin'
399: ,x_msg => 'calling Delete_Action_Set pvt'
400: ,x_log_level => 5);
401: END IF;
402:
399: ,x_msg => 'calling Delete_Action_Set pvt'
400: ,x_log_level => 5);
401: END IF;
402:
403: PA_ACTION_SETS_PVT.delete_action_set
404: (p_action_set_id => l_action_set_id
405: ,p_record_version_number => p_record_version_number
406: ,x_return_status => l_return_status);
407:
441: ROLLBACK TO Delete_ACTION_SETS_PUB;
442: END IF;
443:
444: -- Set the excetption Message and the stack
445: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_ACTION_SETS_PUB.Delete_Action_Set'
446: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
447: --
448: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
449: RAISE;
453:
454:
455:
456: PROCEDURE create_action_set_line
457: (p_action_set_id IN pa_action_sets.action_set_id%TYPE
458: ,p_use_def_description_flag IN VARCHAR2 := 'Y'
459: ,p_description IN pa_action_set_lines.description%TYPE := NULL
460: ,p_action_set_line_number IN pa_action_set_lines.action_set_line_number%TYPE := NULL
461: ,p_action_code IN pa_action_set_lines.action_code%TYPE
487:
488: BEGIN
489:
490: -- Initialize the Error Stack
491: PA_DEBUG.init_err_stack('PA_ACTION_SETS_PUB.Create_Action_Set_Line');
492:
493: -- Bug 4403338
494: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
495:
507: END IF;
508:
509: --Log Message: 4403338
510: IF l_debug_mode = 'Y' THEN
511: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ACTION_SETS_PUB.Create_Action_Set_Line.begin'
512: ,x_msg => 'Beginning of Create_Action_Set_Line pub'
513: ,x_log_level => 5);
514:
515: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ACTION_SETS_PUB.Create_Action_SetLine.begin'
511: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ACTION_SETS_PUB.Create_Action_Set_Line.begin'
512: ,x_msg => 'Beginning of Create_Action_Set_Line pub'
513: ,x_log_level => 5);
514:
515: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ACTION_SETS_PUB.Create_Action_SetLine.begin'
516: ,x_msg => 'calling create_Action_Set_Line pvt'
517: ,x_log_level => 5);
518: END IF;
519:
516: ,x_msg => 'calling create_Action_Set_Line pvt'
517: ,x_log_level => 5);
518: END IF;
519:
520: PA_ACTION_SETS_PVT.create_action_set_line
521: (p_action_set_id => p_action_set_id
522: ,p_use_def_description_flag => p_use_def_description_flag
523: ,p_description => p_description
524: ,p_action_set_line_number => p_action_set_line_number
565: ROLLBACK TO CREATE_ACTION_SET_LINE_PUB;
566: END IF;
567:
568: -- Set the excetption Message and the stack
569: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_ACTION_SETS_PUB.Create_Action_Set_Line'
570: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
571: --
572: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
573: RAISE;
611:
612: BEGIN
613:
614: -- Initialize the Error Stack
615: PA_DEBUG.init_err_stack('PA_ACTION_SETS_PUB.Update_Action_Set_Line');
616:
617: -- Bug 4403338
618: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
619:
631: END IF;
632:
633: --Log Message: 4403338
634: IF l_debug_mode = 'Y' THEN
635: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ACTION_SETS_PUB.Update_Action_Set_Line.begin'
636: ,x_msg => 'Beginning of Update_Action_Set_Line pub'
637: ,x_log_level => 5);
638:
639: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ACTION_SETS_PUB.Update_Action_Set_Line.begin'
635: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ACTION_SETS_PUB.Update_Action_Set_Line.begin'
636: ,x_msg => 'Beginning of Update_Action_Set_Line pub'
637: ,x_log_level => 5);
638:
639: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ACTION_SETS_PUB.Update_Action_Set_Line.begin'
640: ,x_msg => 'calling Update_Action_Set_Line pvt'
641: ,x_log_level => 5);
642: END IF;
643:
640: ,x_msg => 'calling Update_Action_Set_Line pvt'
641: ,x_log_level => 5);
642: END IF;
643:
644: PA_ACTION_SETS_PVT.update_action_set_line
645: (p_action_set_line_id => p_action_set_line_id
646: ,p_record_version_number => p_record_version_number
647: ,p_description => p_description
648: ,p_action_set_line_number => p_action_set_line_number
688: ROLLBACK TO UPDATE_ACTION_SET_LINE_PUB;
689: END IF;
690:
691: -- Set the excetption Message and the stack
692: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_ACTION_SETS_PUB.Update_Action_Set_Line'
693: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
694: --
695: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
696: RAISE;
698: END Update_Action_Set_Line;
699:
700:
701: PROCEDURE delete_action_set_line
702: (p_action_set_line_id IN pa_action_sets.action_set_id%TYPE := NULL
703: ,p_record_version_number IN pa_action_set_lines.record_version_number%TYPE := NULL
704: ,p_api_version IN NUMBER := 1.0
705: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
706: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
720:
721: BEGIN
722:
723: -- Initialize the Error Stack
724: PA_DEBUG.init_err_stack('PA_ACTION_SETS_PUB.Delete_Action_Set_Line');
725:
726: -- Bug 4403338
727: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
728:
740: END IF;
741:
742: --Log Message: 4403338
743: IF l_debug_mode = 'Y' THEN
744: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ACTION_SETS_PUB.Delete_Action_Set_Line.begin'
745: ,x_msg => 'Beginning of Delete_Action_Set_Line pub'
746: ,x_log_level => 5);
747: END IF;
748:
759: ,p_msg_name => 'PA_XC_RECORD_CHANGED');
760:
761: END;
762:
763: PA_ACTION_SETS_PVT.delete_action_set_line
764: (p_action_set_line_id => p_action_set_line_id
765: ,p_record_version_number => p_record_version_number
766: ,x_return_status => l_return_status);
767:
793: ROLLBACK TO Delete_ACTION_SET_LINE_PUB;
794: END IF;
795:
796: -- Set the excetption Message and the stack
797: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_ACTION_SETS_PUB.Delete_Action_Set_Line'
798: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
799: --
800: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
801: RAISE;
803: END Delete_Action_Set_Line;
804:
805:
806: PROCEDURE apply_action_set
807: (p_action_set_id IN pa_action_sets.action_set_id%TYPE := NULL
808: ,p_object_type IN pa_action_sets.object_type%TYPE := NULL
809: ,p_object_id IN pa_action_sets.object_id%TYPE := NULL
810: ,p_perform_action_set_flag IN VARCHAR2 := 'N'
811: ,p_api_version IN NUMBER := 1.0
804:
805:
806: PROCEDURE apply_action_set
807: (p_action_set_id IN pa_action_sets.action_set_id%TYPE := NULL
808: ,p_object_type IN pa_action_sets.object_type%TYPE := NULL
809: ,p_object_id IN pa_action_sets.object_id%TYPE := NULL
810: ,p_perform_action_set_flag IN VARCHAR2 := 'N'
811: ,p_api_version IN NUMBER := 1.0
812: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
805:
806: PROCEDURE apply_action_set
807: (p_action_set_id IN pa_action_sets.action_set_id%TYPE := NULL
808: ,p_object_type IN pa_action_sets.object_type%TYPE := NULL
809: ,p_object_id IN pa_action_sets.object_id%TYPE := NULL
810: ,p_perform_action_set_flag IN VARCHAR2 := 'N'
811: ,p_api_version IN NUMBER := 1.0
812: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
813: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
820: IS
821:
822: l_action_set_lines_tbl pa_action_set_utils.action_set_lines_tbl_type;
823: l_action_line_conditions_tbl pa_action_set_utils.action_line_cond_tbl_type;
824: l_new_action_set_id pa_action_sets.action_set_id%TYPE;
825: l_action_set_name pa_action_sets.action_set_name%TYPE;
826: l_action_set_type_code pa_action_set_types.action_set_type_code%TYPE;
827: l_description pa_action_sets.description%TYPE;
828: l_attribute_category pa_action_sets.attribute_category%TYPE;
821:
822: l_action_set_lines_tbl pa_action_set_utils.action_set_lines_tbl_type;
823: l_action_line_conditions_tbl pa_action_set_utils.action_line_cond_tbl_type;
824: l_new_action_set_id pa_action_sets.action_set_id%TYPE;
825: l_action_set_name pa_action_sets.action_set_name%TYPE;
826: l_action_set_type_code pa_action_set_types.action_set_type_code%TYPE;
827: l_description pa_action_sets.description%TYPE;
828: l_attribute_category pa_action_sets.attribute_category%TYPE;
829: l_attribute1 pa_action_sets.attribute1%TYPE;
823: l_action_line_conditions_tbl pa_action_set_utils.action_line_cond_tbl_type;
824: l_new_action_set_id pa_action_sets.action_set_id%TYPE;
825: l_action_set_name pa_action_sets.action_set_name%TYPE;
826: l_action_set_type_code pa_action_set_types.action_set_type_code%TYPE;
827: l_description pa_action_sets.description%TYPE;
828: l_attribute_category pa_action_sets.attribute_category%TYPE;
829: l_attribute1 pa_action_sets.attribute1%TYPE;
830: l_attribute2 pa_action_sets.attribute2%TYPE;
831: l_attribute3 pa_action_sets.attribute3%TYPE;
824: l_new_action_set_id pa_action_sets.action_set_id%TYPE;
825: l_action_set_name pa_action_sets.action_set_name%TYPE;
826: l_action_set_type_code pa_action_set_types.action_set_type_code%TYPE;
827: l_description pa_action_sets.description%TYPE;
828: l_attribute_category pa_action_sets.attribute_category%TYPE;
829: l_attribute1 pa_action_sets.attribute1%TYPE;
830: l_attribute2 pa_action_sets.attribute2%TYPE;
831: l_attribute3 pa_action_sets.attribute3%TYPE;
832: l_attribute4 pa_action_sets.attribute4%TYPE;
825: l_action_set_name pa_action_sets.action_set_name%TYPE;
826: l_action_set_type_code pa_action_set_types.action_set_type_code%TYPE;
827: l_description pa_action_sets.description%TYPE;
828: l_attribute_category pa_action_sets.attribute_category%TYPE;
829: l_attribute1 pa_action_sets.attribute1%TYPE;
830: l_attribute2 pa_action_sets.attribute2%TYPE;
831: l_attribute3 pa_action_sets.attribute3%TYPE;
832: l_attribute4 pa_action_sets.attribute4%TYPE;
833: l_attribute5 pa_action_sets.attribute5%TYPE;
826: l_action_set_type_code pa_action_set_types.action_set_type_code%TYPE;
827: l_description pa_action_sets.description%TYPE;
828: l_attribute_category pa_action_sets.attribute_category%TYPE;
829: l_attribute1 pa_action_sets.attribute1%TYPE;
830: l_attribute2 pa_action_sets.attribute2%TYPE;
831: l_attribute3 pa_action_sets.attribute3%TYPE;
832: l_attribute4 pa_action_sets.attribute4%TYPE;
833: l_attribute5 pa_action_sets.attribute5%TYPE;
834: l_attribute6 pa_action_sets.attribute6%TYPE;
827: l_description pa_action_sets.description%TYPE;
828: l_attribute_category pa_action_sets.attribute_category%TYPE;
829: l_attribute1 pa_action_sets.attribute1%TYPE;
830: l_attribute2 pa_action_sets.attribute2%TYPE;
831: l_attribute3 pa_action_sets.attribute3%TYPE;
832: l_attribute4 pa_action_sets.attribute4%TYPE;
833: l_attribute5 pa_action_sets.attribute5%TYPE;
834: l_attribute6 pa_action_sets.attribute6%TYPE;
835: l_attribute7 pa_action_sets.attribute7%TYPE;
828: l_attribute_category pa_action_sets.attribute_category%TYPE;
829: l_attribute1 pa_action_sets.attribute1%TYPE;
830: l_attribute2 pa_action_sets.attribute2%TYPE;
831: l_attribute3 pa_action_sets.attribute3%TYPE;
832: l_attribute4 pa_action_sets.attribute4%TYPE;
833: l_attribute5 pa_action_sets.attribute5%TYPE;
834: l_attribute6 pa_action_sets.attribute6%TYPE;
835: l_attribute7 pa_action_sets.attribute7%TYPE;
836: l_attribute8 pa_action_sets.attribute8%TYPE;
829: l_attribute1 pa_action_sets.attribute1%TYPE;
830: l_attribute2 pa_action_sets.attribute2%TYPE;
831: l_attribute3 pa_action_sets.attribute3%TYPE;
832: l_attribute4 pa_action_sets.attribute4%TYPE;
833: l_attribute5 pa_action_sets.attribute5%TYPE;
834: l_attribute6 pa_action_sets.attribute6%TYPE;
835: l_attribute7 pa_action_sets.attribute7%TYPE;
836: l_attribute8 pa_action_sets.attribute8%TYPE;
837: l_attribute9 pa_action_sets.attribute9%TYPE;
830: l_attribute2 pa_action_sets.attribute2%TYPE;
831: l_attribute3 pa_action_sets.attribute3%TYPE;
832: l_attribute4 pa_action_sets.attribute4%TYPE;
833: l_attribute5 pa_action_sets.attribute5%TYPE;
834: l_attribute6 pa_action_sets.attribute6%TYPE;
835: l_attribute7 pa_action_sets.attribute7%TYPE;
836: l_attribute8 pa_action_sets.attribute8%TYPE;
837: l_attribute9 pa_action_sets.attribute9%TYPE;
838: l_attribute10 pa_action_sets.attribute10%TYPE;
831: l_attribute3 pa_action_sets.attribute3%TYPE;
832: l_attribute4 pa_action_sets.attribute4%TYPE;
833: l_attribute5 pa_action_sets.attribute5%TYPE;
834: l_attribute6 pa_action_sets.attribute6%TYPE;
835: l_attribute7 pa_action_sets.attribute7%TYPE;
836: l_attribute8 pa_action_sets.attribute8%TYPE;
837: l_attribute9 pa_action_sets.attribute9%TYPE;
838: l_attribute10 pa_action_sets.attribute10%TYPE;
839: l_attribute11 pa_action_sets.attribute11%TYPE;
832: l_attribute4 pa_action_sets.attribute4%TYPE;
833: l_attribute5 pa_action_sets.attribute5%TYPE;
834: l_attribute6 pa_action_sets.attribute6%TYPE;
835: l_attribute7 pa_action_sets.attribute7%TYPE;
836: l_attribute8 pa_action_sets.attribute8%TYPE;
837: l_attribute9 pa_action_sets.attribute9%TYPE;
838: l_attribute10 pa_action_sets.attribute10%TYPE;
839: l_attribute11 pa_action_sets.attribute11%TYPE;
840: l_attribute12 pa_action_sets.attribute12%TYPE;
833: l_attribute5 pa_action_sets.attribute5%TYPE;
834: l_attribute6 pa_action_sets.attribute6%TYPE;
835: l_attribute7 pa_action_sets.attribute7%TYPE;
836: l_attribute8 pa_action_sets.attribute8%TYPE;
837: l_attribute9 pa_action_sets.attribute9%TYPE;
838: l_attribute10 pa_action_sets.attribute10%TYPE;
839: l_attribute11 pa_action_sets.attribute11%TYPE;
840: l_attribute12 pa_action_sets.attribute12%TYPE;
841: l_attribute13 pa_action_sets.attribute13%TYPE;
834: l_attribute6 pa_action_sets.attribute6%TYPE;
835: l_attribute7 pa_action_sets.attribute7%TYPE;
836: l_attribute8 pa_action_sets.attribute8%TYPE;
837: l_attribute9 pa_action_sets.attribute9%TYPE;
838: l_attribute10 pa_action_sets.attribute10%TYPE;
839: l_attribute11 pa_action_sets.attribute11%TYPE;
840: l_attribute12 pa_action_sets.attribute12%TYPE;
841: l_attribute13 pa_action_sets.attribute13%TYPE;
842: l_attribute14 pa_action_sets.attribute14%TYPE;
835: l_attribute7 pa_action_sets.attribute7%TYPE;
836: l_attribute8 pa_action_sets.attribute8%TYPE;
837: l_attribute9 pa_action_sets.attribute9%TYPE;
838: l_attribute10 pa_action_sets.attribute10%TYPE;
839: l_attribute11 pa_action_sets.attribute11%TYPE;
840: l_attribute12 pa_action_sets.attribute12%TYPE;
841: l_attribute13 pa_action_sets.attribute13%TYPE;
842: l_attribute14 pa_action_sets.attribute14%TYPE;
843: l_attribute15 pa_action_sets.attribute15%TYPE;
836: l_attribute8 pa_action_sets.attribute8%TYPE;
837: l_attribute9 pa_action_sets.attribute9%TYPE;
838: l_attribute10 pa_action_sets.attribute10%TYPE;
839: l_attribute11 pa_action_sets.attribute11%TYPE;
840: l_attribute12 pa_action_sets.attribute12%TYPE;
841: l_attribute13 pa_action_sets.attribute13%TYPE;
842: l_attribute14 pa_action_sets.attribute14%TYPE;
843: l_attribute15 pa_action_sets.attribute15%TYPE;
844: l_action_set_line_id pa_action_set_line_cond.action_set_line_id%TYPE;
837: l_attribute9 pa_action_sets.attribute9%TYPE;
838: l_attribute10 pa_action_sets.attribute10%TYPE;
839: l_attribute11 pa_action_sets.attribute11%TYPE;
840: l_attribute12 pa_action_sets.attribute12%TYPE;
841: l_attribute13 pa_action_sets.attribute13%TYPE;
842: l_attribute14 pa_action_sets.attribute14%TYPE;
843: l_attribute15 pa_action_sets.attribute15%TYPE;
844: l_action_set_line_id pa_action_set_line_cond.action_set_line_id%TYPE;
845: l_return_status VARCHAR2(1);
838: l_attribute10 pa_action_sets.attribute10%TYPE;
839: l_attribute11 pa_action_sets.attribute11%TYPE;
840: l_attribute12 pa_action_sets.attribute12%TYPE;
841: l_attribute13 pa_action_sets.attribute13%TYPE;
842: l_attribute14 pa_action_sets.attribute14%TYPE;
843: l_attribute15 pa_action_sets.attribute15%TYPE;
844: l_action_set_line_id pa_action_set_line_cond.action_set_line_id%TYPE;
845: l_return_status VARCHAR2(1);
846: l_msg_index_out NUMBER;
839: l_attribute11 pa_action_sets.attribute11%TYPE;
840: l_attribute12 pa_action_sets.attribute12%TYPE;
841: l_attribute13 pa_action_sets.attribute13%TYPE;
842: l_attribute14 pa_action_sets.attribute14%TYPE;
843: l_attribute15 pa_action_sets.attribute15%TYPE;
844: l_action_set_line_id pa_action_set_line_cond.action_set_line_id%TYPE;
845: l_return_status VARCHAR2(1);
846: l_msg_index_out NUMBER;
847: l_msg_count NUMBER;
851:
852: BEGIN
853:
854: -- Initialize the Error Stack
855: PA_DEBUG.init_err_stack('PA_ACTION_SETS_PUB.Apply_Action_Set');
856:
857: -- Bug 4403338
858: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
859:
871: END IF;
872:
873: --Log Message: 4403338
874: IF l_debug_mode = 'Y' THEN
875: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ACTION_SETS_PUB.Apply_Action_Set.begin'
876: ,x_msg => 'Beginning of Apply_Action_Set pub'
877: ,x_log_level => 5);
878:
879: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ACTION_SETS_PUB.Apply_Action_Set'
875: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ACTION_SETS_PUB.Apply_Action_Set.begin'
876: ,x_msg => 'Beginning of Apply_Action_Set pub'
877: ,x_log_level => 5);
878:
879: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ACTION_SETS_PUB.Apply_Action_Set'
880: ,x_msg => 'FND_MSG_PUB.Count_Msg = '||FND_MSG_PUB.Count_Msg
881: ,x_log_level => 5);
882: END IF;
883:
920: l_attribute12,
921: l_attribute13,
922: l_attribute14,
923: l_attribute15
924: FROM pa_action_sets
925: WHERE action_set_id = p_action_set_id;
926:
927: create_action_set(
928: p_action_set_type_code => l_action_set_type_code
1006: END IF;
1007:
1008: --Log Message: 4403338
1009: IF l_debug_mode = 'Y' THEN
1010: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ACTION_SETS_PUB.Apply_Action_Set.begin'
1011: ,x_msg => 'calling Perform_Action_Set_Line pub'
1012: ,x_log_level => 5);
1013: END IF;
1014:
1040: ROLLBACK TO APPLY_ACTION_SET_PUB;
1041: END IF;
1042:
1043: -- Set the excetption Message and the stack
1044: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_ACTION_SETS_PUB.Apply_Action_Set'
1045: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
1046: --
1047: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1048: RAISE;
1050: END;
1051:
1052:
1053: PROCEDURE replace_action_set
1054: (p_current_action_set_id IN pa_action_sets.action_set_id%TYPE := NULL
1055: ,p_action_set_type_code IN pa_action_set_types.action_set_type_code%TYPE := NULL
1056: ,p_object_type IN pa_action_sets.object_type%TYPE := NULL
1057: ,p_object_id IN pa_action_sets.object_id%TYPE := NULL
1058: ,p_record_version_number IN pa_action_sets.record_version_number%TYPE
1052:
1053: PROCEDURE replace_action_set
1054: (p_current_action_set_id IN pa_action_sets.action_set_id%TYPE := NULL
1055: ,p_action_set_type_code IN pa_action_set_types.action_set_type_code%TYPE := NULL
1056: ,p_object_type IN pa_action_sets.object_type%TYPE := NULL
1057: ,p_object_id IN pa_action_sets.object_id%TYPE := NULL
1058: ,p_record_version_number IN pa_action_sets.record_version_number%TYPE
1059: ,p_new_action_set_id IN pa_action_sets.action_set_id%TYPE
1060: ,p_api_version IN NUMBER := 1.0
1053: PROCEDURE replace_action_set
1054: (p_current_action_set_id IN pa_action_sets.action_set_id%TYPE := NULL
1055: ,p_action_set_type_code IN pa_action_set_types.action_set_type_code%TYPE := NULL
1056: ,p_object_type IN pa_action_sets.object_type%TYPE := NULL
1057: ,p_object_id IN pa_action_sets.object_id%TYPE := NULL
1058: ,p_record_version_number IN pa_action_sets.record_version_number%TYPE
1059: ,p_new_action_set_id IN pa_action_sets.action_set_id%TYPE
1060: ,p_api_version IN NUMBER := 1.0
1061: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
1054: (p_current_action_set_id IN pa_action_sets.action_set_id%TYPE := NULL
1055: ,p_action_set_type_code IN pa_action_set_types.action_set_type_code%TYPE := NULL
1056: ,p_object_type IN pa_action_sets.object_type%TYPE := NULL
1057: ,p_object_id IN pa_action_sets.object_id%TYPE := NULL
1058: ,p_record_version_number IN pa_action_sets.record_version_number%TYPE
1059: ,p_new_action_set_id IN pa_action_sets.action_set_id%TYPE
1060: ,p_api_version IN NUMBER := 1.0
1061: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
1062: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
1055: ,p_action_set_type_code IN pa_action_set_types.action_set_type_code%TYPE := NULL
1056: ,p_object_type IN pa_action_sets.object_type%TYPE := NULL
1057: ,p_object_id IN pa_action_sets.object_id%TYPE := NULL
1058: ,p_record_version_number IN pa_action_sets.record_version_number%TYPE
1059: ,p_new_action_set_id IN pa_action_sets.action_set_id%TYPE
1060: ,p_api_version IN NUMBER := 1.0
1061: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
1062: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
1063: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
1070: l_return_status VARCHAR2(1);
1071: l_msg_index_out NUMBER;
1072: l_msg_count NUMBER;
1073: l_msg_data VARCHAR2(2000);
1074: l_action_set_id pa_action_sets.action_set_id%TYPE;
1075: l_new_action_set_id pa_action_sets.action_set_id%TYPE;
1076: l_current_action_set_id pa_action_sets.action_set_id%TYPE;
1077: e_invalid_result_code EXCEPTION;
1078: l_debug_mode VARCHAR2(20) := 'N';
1071: l_msg_index_out NUMBER;
1072: l_msg_count NUMBER;
1073: l_msg_data VARCHAR2(2000);
1074: l_action_set_id pa_action_sets.action_set_id%TYPE;
1075: l_new_action_set_id pa_action_sets.action_set_id%TYPE;
1076: l_current_action_set_id pa_action_sets.action_set_id%TYPE;
1077: e_invalid_result_code EXCEPTION;
1078: l_debug_mode VARCHAR2(20) := 'N';
1079:
1072: l_msg_count NUMBER;
1073: l_msg_data VARCHAR2(2000);
1074: l_action_set_id pa_action_sets.action_set_id%TYPE;
1075: l_new_action_set_id pa_action_sets.action_set_id%TYPE;
1076: l_current_action_set_id pa_action_sets.action_set_id%TYPE;
1077: e_invalid_result_code EXCEPTION;
1078: l_debug_mode VARCHAR2(20) := 'N';
1079:
1080: BEGIN
1079:
1080: BEGIN
1081:
1082: -- Initialize the Error Stack
1083: PA_DEBUG.init_err_stack('PA_ACTION_SETS_PUB.Replace_Action_Set');
1084:
1085: -- Bug 4370082
1086: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
1087:
1099: END IF;
1100:
1101: --Log Message: 4370082
1102: IF l_debug_mode = 'Y' THEN
1103: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ACTION_SETS_PUB.Replace_Action_Set.begin'
1104: ,x_msg => 'Beginning of Replace_Action_Set pub'
1105: ,x_log_level => 5);
1106: END IF;
1107:
1126: IF FND_MSG_PUB.Count_Msg = 0 THEN
1127:
1128: --Log Message: 4370082
1129: IF l_debug_mode = 'Y' THEN
1130: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ACTION_SETS_PUB.Replace_Action_Set.begin'
1131: ,x_msg => 'calling Apply_Action_Set pub'
1132: ,x_log_level => 5);
1133: END IF;
1134:
1168:
1169: EXCEPTION
1170: WHEN e_invalid_result_code THEN
1171: /*
1172: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_ACTION_SETS_PVT.Perform_Action_Set_Line'
1173: ,p_procedure_name => 'INVALID RESULTS CODE: '||l_action_line_result_code);
1174: --
1175: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1176: */
1180: ROLLBACK TO REPLACE_ACTION_SET;
1181: END IF;
1182:
1183: -- Set the excetption Message and the stack
1184: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_ACTION_SETS_PUB.Replace_Action_Set'
1185: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
1186: --
1187: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1188: RAISE;
1191:
1192:
1193:
1194: PROCEDURE perform_single_action_set
1195: (p_action_set_id IN pa_action_sets.action_set_id%TYPE := NULL
1196: ,p_action_set_type_code IN pa_action_set_types.action_set_type_code%TYPE := NULL
1197: ,p_object_type IN pa_action_sets.object_type%TYPE := NULL
1198: ,p_object_id IN pa_action_sets.object_id%TYPE := NULL
1199: ,p_api_version IN NUMBER := 1.0
1193:
1194: PROCEDURE perform_single_action_set
1195: (p_action_set_id IN pa_action_sets.action_set_id%TYPE := NULL
1196: ,p_action_set_type_code IN pa_action_set_types.action_set_type_code%TYPE := NULL
1197: ,p_object_type IN pa_action_sets.object_type%TYPE := NULL
1198: ,p_object_id IN pa_action_sets.object_id%TYPE := NULL
1199: ,p_api_version IN NUMBER := 1.0
1200: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
1201: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
1194: PROCEDURE perform_single_action_set
1195: (p_action_set_id IN pa_action_sets.action_set_id%TYPE := NULL
1196: ,p_action_set_type_code IN pa_action_set_types.action_set_type_code%TYPE := NULL
1197: ,p_object_type IN pa_action_sets.object_type%TYPE := NULL
1198: ,p_object_id IN pa_action_sets.object_id%TYPE := NULL
1199: ,p_api_version IN NUMBER := 1.0
1200: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
1201: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
1202: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
1208: l_return_status VARCHAR2(1);
1209: l_msg_index_out NUMBER;
1210: l_msg_count NUMBER;
1211: l_msg_data VARCHAR2(2000);
1212: l_action_set_id pa_action_sets.action_set_id%TYPE;
1213: l_action_set_type_code pa_action_set_types.action_set_type_code%TYPE;
1214: e_invalid_result_code EXCEPTION;
1215:
1216: CURSOR get_action_set_lines(p_action_set_id IN NUMBER) IS
1215:
1216: CURSOR get_action_set_lines(p_action_set_id IN NUMBER) IS
1217: SELECT action_set_line_id
1218: FROM pa_action_set_lines l,
1219: pa_action_sets s
1220: WHERE s.action_set_id = p_action_set_id
1221: AND s.action_set_id = l.action_set_id
1222: AND s.status_code IN ('STARTED','RESUMED')
1223: AND l.status_code IN ('PENDING','ACTIVE','REVERSE_PENDING','UPDATE_PENDING')
1231:
1232: BEGIN
1233:
1234: -- Initialize the Error Stack
1235: PA_DEBUG.init_err_stack('PA_ACTION_SETS_PUB.Perform_Single_Action_Set');
1236:
1237: -- Bug 4370082
1238: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
1239:
1251: END IF;
1252:
1253: --Log Message: 4370082
1254: IF l_debug_mode = 'Y' THEN
1255: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ACTION_SETS_PUB.Perform_Single_Action_Set.begin'
1256: ,x_msg => 'Beginning of Perform_Single_Action_Set pub'
1257: ,x_log_level => 5);
1258: END IF;
1259:
1257: ,x_log_level => 5);
1258: END IF;
1259:
1260: PA_ACTION_SET_UTILS.G_ERROR_EXISTS := 'N';
1261: -- PA_ACTION_SETS_PVT.g_line_errors_tbl.DELETE;
1262:
1263: l_action_set_type_code := p_action_set_type_code;
1264:
1265: IF l_action_set_type_code IS NULL THEN
1263: l_action_set_type_code := p_action_set_type_code;
1264:
1265: IF l_action_set_type_code IS NULL THEN
1266: SELECT action_set_type_code INTO l_action_set_type_code
1267: FROM pa_action_sets
1268: WHERE action_set_id = p_action_set_id;
1269: END IF;
1270:
1271: l_action_set_id := p_action_set_id;
1282: CLOSE get_action_set_lines;
1283:
1284: --Log Message: 4370082
1285: IF l_debug_mode = 'Y' THEN
1286: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ACTION_SETS_PVT.Perform_Action_Set_Line'
1287: ,x_msg => 'calling Perform_ActionSet_Line pvt'
1288: ,x_log_level => 5);
1289: END IF;
1290:
1293: FOR i IN l_action_set_line_id_tbl.FIRST .. l_action_set_line_id_tbl.LAST LOOP
1294:
1295: FND_MSG_PUB.initialize;
1296:
1297: PA_ACTION_SETS_PVT.Perform_Action_Set_Line(p_action_set_type_code => l_action_set_type_code ,
1298: p_action_set_line_id => l_action_set_line_id_tbl(i)
1299: ,x_return_status => l_return_status);
1300:
1301: END LOOP;
1334: ROLLBACK TO PERFORM_SINGLE_ACTION_SET;
1335: END IF;
1336:
1337: -- Set the excetption Message and the stack
1338: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_ACTION_SETS_PUB.Perform_Single_Action_Set'
1339: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
1340: --
1341: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1342: RAISE;
1396: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Action Set Type Code = '||l_action_set_type_code_tbl(i));
1397: FND_FILE.PUT_LINE(FND_FILE.LOG, 'About to get action set line ids');
1398: END IF;
1399:
1400: PA_ACTION_SETS_DYN.get_action_set_line_ids(p_action_set_type_code => l_action_set_type_code_tbl(i),
1401: p_project_number_from => p_project_number_from,
1402: p_project_number_to => p_project_number_to,
1403: x_action_set_line_id_tbl => l_action_set_line_id_tbl,
1404: x_object_name_tbl => l_object_name_tbl,
1425: IF p_debug_mode = 'Y' THEN
1426: FND_FILE.PUT_LINE(FND_FILE.LOG, 'About to perform action set line id '||l_action_set_line_id_tbl(j));
1427: END IF;
1428:
1429: PA_ACTION_SETS_PVT.perform_action_set_line(p_action_set_type_code => l_action_set_type_code_tbl(i),
1430: p_action_set_line_id => l_action_set_line_id_tbl(j),
1431: x_return_status => l_return_status);
1432:
1433: COMMIT;
1446:
1447: EXCEPTION
1448: WHEN e_invalid_result_code THEN
1449: /*
1450: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_ACTION_SETS_PVT.Perform_Action_Set_Line'
1451: ,p_procedure_name => 'INVALID RESULTS CODE: '||l_action_line_result_code);
1452: --
1453: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1454: */
1455: RAISE;
1456:
1457: WHEN OTHERS THEN
1458: -- Set the excetption Message and the stack
1459: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_ACTION_SETS_PVT.Perform_Action_Set_Line'
1460: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
1461: --
1462: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1463: RAISE;
1467:
1468:
1469:
1470: PROCEDURE create_line_single_cond
1471: (p_action_set_id IN pa_action_sets.action_set_id%TYPE
1472: ,p_use_def_description_flag IN VARCHAR2 := 'Y'
1473: ,p_action_description IN pa_action_set_lines.description%TYPE := NULL
1474: ,p_action_set_line_number IN pa_action_set_lines.action_set_line_number%TYPE := NULL
1475: ,p_action_code IN pa_action_set_lines.action_code%TYPE
1506: )
1507: IS
1508:
1509: l_condition_tbl pa_action_set_utils.action_line_cond_tbl_type;
1510: l_action_set_template_flag pa_action_sets.action_set_template_flag%TYPE;
1511:
1512: BEGIN
1513:
1514: -- Initialize the Error Stack
1511:
1512: BEGIN
1513:
1514: -- Initialize the Error Stack
1515: PA_DEBUG.init_err_stack('PA_ACTION_SETS_PUB.create_line_single_cond');
1516:
1517: -- Initialize the return status to success
1518: x_return_status := FND_API.G_RET_STS_SUCCESS;
1519:
1560: -- an action set is created for the first time.
1561: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
1562: SELECT action_set_template_flag
1563: INTO l_action_set_template_flag
1564: FROM pa_action_sets
1565: WHERE action_set_id = p_action_set_id;
1566:
1567: IF l_action_set_template_flag = 'N' THEN
1568: UPDATE pa_action_sets
1564: FROM pa_action_sets
1565: WHERE action_set_id = p_action_set_id;
1566:
1567: IF l_action_set_template_flag = 'N' THEN
1568: UPDATE pa_action_sets
1569: SET MOD_SOURCE_ACTION_SET_FLAG = 'Y'
1570: WHERE action_set_id = p_action_set_id;
1571: END IF;
1572: END IF;
1574: EXCEPTION
1575: WHEN OTHERS THEN
1576:
1577: -- Set the excetption Message and the stack
1578: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_ACTION_SETS_PUB.create_line_single_cond'
1579: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
1580: --
1581: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1582: RAISE;
1584: END;
1585:
1586:
1587: PROCEDURE update_line_single_cond
1588: (p_action_set_line_id IN pa_action_sets.action_set_id%TYPE
1589: ,p_record_version_number IN NUMBER := NULL
1590: ,p_action_description IN pa_action_set_lines.description%TYPE := FND_API.G_MISS_CHAR
1591: ,p_action_code IN pa_action_set_lines.action_code%TYPE
1592: ,p_action_attribute1 IN pa_action_set_lines.action_attribute1%TYPE := FND_API.G_MISS_CHAR
1621: )
1622: IS
1623:
1624: l_condition_tbl pa_action_set_utils.action_line_cond_tbl_type;
1625: l_action_set_template_flag pa_action_sets.action_set_template_flag%TYPE;
1626: l_action_set_id pa_action_sets.action_set_id%TYPE;
1627:
1628: BEGIN
1629:
1622: IS
1623:
1624: l_condition_tbl pa_action_set_utils.action_line_cond_tbl_type;
1625: l_action_set_template_flag pa_action_sets.action_set_template_flag%TYPE;
1626: l_action_set_id pa_action_sets.action_set_id%TYPE;
1627:
1628: BEGIN
1629:
1630: -- Initialize the Error Stack
1627:
1628: BEGIN
1629:
1630: -- Initialize the Error Stack
1631: PA_DEBUG.init_err_stack('PA_ACTION_SETS_PUB.update_line_single_cond');
1632:
1633: -- Initialize the return status to success
1634: x_return_status := FND_API.G_RET_STS_SUCCESS;
1635:
1679: -- a line is performed.
1680: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
1681: SELECT s.action_set_template_flag, s.action_set_id
1682: INTO l_action_set_template_flag, l_action_set_id
1683: FROM pa_action_sets s, pa_action_set_lines l
1684: WHERE l.action_set_line_id = p_action_set_line_id
1685: AND s.action_set_id = l.action_set_id;
1686:
1687: IF l_action_set_template_flag = 'N' THEN
1684: WHERE l.action_set_line_id = p_action_set_line_id
1685: AND s.action_set_id = l.action_set_id;
1686:
1687: IF l_action_set_template_flag = 'N' THEN
1688: UPDATE pa_action_sets
1689: SET MOD_SOURCE_ACTION_SET_FLAG = 'Y'
1690: WHERE action_set_id = l_action_set_id;
1691: END IF;
1692: END IF;
1694: EXCEPTION
1695: WHEN OTHERS THEN
1696:
1697: -- Set the excetption Message and the stack
1698: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_ACTION_SETS_PUB.update_line_single_cond'
1699: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
1700: --
1701: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1702: RAISE;
1722:
1723: FND_MSG_PUB.initialize;
1724:
1725: SELECT action_set_template_flag, action_set_type_code INTO l_action_set_template_flag, l_action_set_type_code
1726: FROM pa_action_sets
1727: WHERE action_set_id = p_action_set_id;
1728:
1729: PA_ACTION_SETS_DYN.Process_Action_Set(p_action_set_type_code => l_action_set_type_code,
1730: p_action_set_id => p_action_set_id,
1725: SELECT action_set_template_flag, action_set_type_code INTO l_action_set_template_flag, l_action_set_type_code
1726: FROM pa_action_sets
1727: WHERE action_set_id = p_action_set_id;
1728:
1729: PA_ACTION_SETS_DYN.Process_Action_Set(p_action_set_type_code => l_action_set_type_code,
1730: p_action_set_id => p_action_set_id,
1731: p_action_set_template_flag => l_action_set_template_flag,
1732: x_return_status => l_return_status);
1733:
1750:
1751: EXCEPTION
1752: WHEN OTHERS THEN
1753: -- Set the excetption Message and the stack
1754: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_ACTION_SETS_PUB.Validate_Action_Set'
1755: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
1756: --
1757: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1758: RAISE;
1759:
1760: END;
1761:
1762:
1763: END pa_action_sets_pub;