eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_ACTION_SETS_PVT dependencies on PA_ACTION_SETS

Line 1: PACKAGE BODY pa_action_sets_pvt AS

1: PACKAGE BODY pa_action_sets_pvt AS
2: /*$Header: PARASPVB.pls 120.2.12010000.2 2008/08/22 16:11:53 mumohan ship $*/
3: --
4: PROCEDURE create_action_set
5: (p_action_set_type_code IN pa_action_set_types.action_set_type_code%TYPE

Line 6: ,p_action_set_name IN pa_action_sets.action_set_name%TYPE

2: /*$Header: PARASPVB.pls 120.2.12010000.2 2008/08/22 16:11:53 mumohan 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

Line 7: ,p_object_type IN pa_action_sets.object_type%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

Line 8: ,p_object_id IN pa_action_sets.object_id%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

Line 9: ,p_start_date_active IN pa_action_sets.start_date_active%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

Line 10: ,p_end_date_active IN pa_action_sets.end_date_active%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

Line 11: ,p_action_set_template_flag IN pa_action_sets.action_set_template_flag%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

Line 12: ,p_source_action_set_id IN pa_action_sets.source_action_set_id%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

Line 13: ,p_status_code IN pa_action_sets.status_code%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

Line 14: ,p_description IN pa_action_sets.description%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

Line 15: ,p_attribute_category IN pa_action_sets.attribute_category%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

Line 16: ,p_attribute1 IN pa_action_sets.attribute1%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

Line 17: ,p_attribute2 IN pa_action_sets.attribute2%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

Line 18: ,p_attribute3 IN pa_action_sets.attribute3%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

Line 19: ,p_attribute4 IN pa_action_sets.attribute4%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

Line 20: ,p_attribute5 IN pa_action_sets.attribute5%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

Line 21: ,p_attribute6 IN pa_action_sets.attribute6%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

Line 22: ,p_attribute7 IN pa_action_sets.attribute7%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

Line 23: ,p_attribute8 IN pa_action_sets.attribute8%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

Line 24: ,p_attribute9 IN pa_action_sets.attribute9%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

Line 25: ,p_attribute10 IN pa_action_sets.attribute10%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

Line 26: ,p_attribute11 IN pa_action_sets.attribute11%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

Line 27: ,p_attribute12 IN pa_action_sets.attribute12%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: ,x_action_set_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 28: ,p_attribute13 IN pa_action_sets.attribute13%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: ,x_action_set_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
32: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 29: ,p_attribute14 IN pa_action_sets.attribute14%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: ,x_action_set_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
32: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
33: )

Line 30: ,p_attribute15 IN pa_action_sets.attribute15%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: ,x_action_set_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
32: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
33: )
34: IS

Line 39: l_status_code pa_action_sets.status_code%TYPE;

35:
36: l_return_status VARCHAR2(1);
37: l_unique VARCHAR2(1);
38: l_existing_action_set_id NUMBER;
39: l_status_code pa_action_sets.status_code%TYPE;
40: l_actual_start_date DATE;
41: l_is_action_set_started VARCHAR2(1);
42: l_debug_mode VARCHAR2(20) := 'N';
43:

Line 54: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ACTION_SETS_PVT.Create_Action_Set.begin'

50: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
51:
52: --Log Message: 4403338
53: IF l_debug_mode = 'Y' THEN
54: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ACTION_SETS_PVT.Create_Action_Set.begin'
55: ,x_msg => 'Beginning of Create_Action_Set pvt'
56: ,x_log_level => 5);
57: END IF;
58:

Line 90: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ACTION_SETS_PVT.create_action_set'

86: ,p_msg_name => 'PA_OBJECT_HAS_ACTION_SET');
87:
88: --Log Message: 4403338
89: IF l_debug_mode = 'Y' THEN
90: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ACTION_SETS_PVT.create_action_set'
91: ,x_msg => 'Message: PA_OBJECT_HAS_ACTION_SET'
92: ,x_log_level => 5);
93: END IF;
94:

Line 97: l_is_action_set_started := PA_ACTION_SETS_DYN.Is_Action_Set_Started_On_Apply(

93: END IF;
94:
95: END IF;
96:
97: l_is_action_set_started := PA_ACTION_SETS_DYN.Is_Action_Set_Started_On_Apply(
98: p_action_set_type_code => p_action_set_type_code,
99: p_object_type => p_object_type,
100: p_object_id => p_object_id);
101: --Log Message: 4403338

Line 103: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ACTION_SETS_PVT.Create_Action_Set'

99: p_object_type => p_object_type,
100: p_object_id => p_object_id);
101: --Log Message: 4403338
102: IF l_debug_mode = 'Y' THEN
103: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ACTION_SETS_PVT.Create_Action_Set'
104: ,x_msg => 'l_is_action_set_started = '|| l_is_action_set_started
105: ,x_log_level => 5);
106: END IF;
107:

Line 124: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ACTION_SETS_PVT.Create_Action_Set'

120: IF FND_MSG_PUB.Count_Msg =0 THEN
121:
122: --Log Message: 4403338
123: IF l_debug_mode = 'Y' THEN
124: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ACTION_SETS_PVT.Create_Action_Set'
125: ,x_msg => 'before pa_action_sets_pkg.insert_row'
126: ,x_log_level => 5);
127: END IF;
128:

Line 125: ,x_msg => 'before pa_action_sets_pkg.insert_row'

121:
122: --Log Message: 4403338
123: IF l_debug_mode = 'Y' THEN
124: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ACTION_SETS_PVT.Create_Action_Set'
125: ,x_msg => 'before pa_action_sets_pkg.insert_row'
126: ,x_log_level => 5);
127: END IF;
128:
129: PA_ACTION_SETS_PKG.insert_row

Line 129: PA_ACTION_SETS_PKG.insert_row

125: ,x_msg => 'before pa_action_sets_pkg.insert_row'
126: ,x_log_level => 5);
127: END IF;
128:
129: PA_ACTION_SETS_PKG.insert_row
130: (p_action_set_type_code => p_action_set_type_code
131: ,p_action_set_name => p_action_set_name
132: ,p_object_type => p_object_type
133: ,p_object_id => p_object_id

Line 164: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ACTION_SETS_PVT.Create_Action_Set'

160: END IF;
161:
162: --Log Message: 4403338
163: IF l_debug_mode = 'Y' THEN
164: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ACTION_SETS_PVT.Create_Action_Set'
165: ,x_msg => 'x_action_set_id = '|| x_action_set_id
166: ,x_log_level => 5);
167: END IF;
168:

Line 177: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_ACTION_SETS_PVT.Create_Action_Set'

173: EXCEPTION
174: WHEN OTHERS THEN
175:
176: -- Set the excetption Message and the stack
177: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_ACTION_SETS_PVT.Create_Action_Set'
178: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
179: --
180: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
181: RAISE;

Line 187: (p_action_set_id IN pa_action_sets.action_set_id%TYPE := NULL

183: END Create_Action_Set;
184:
185:
186: PROCEDURE update_action_set
187: (p_action_set_id IN pa_action_sets.action_set_id%TYPE := NULL
188: ,p_action_set_name IN pa_action_sets.action_set_name%TYPE := FND_API.G_MISS_CHAR
189: ,p_action_set_type_code IN pa_action_sets.action_set_type_code%TYPE := FND_API.G_MISS_CHAR
190: ,p_start_date_active IN pa_action_sets.start_date_active%TYPE := FND_API.G_MISS_DATE
191: ,p_end_date_active IN pa_action_sets.end_date_active%TYPE := FND_API.G_MISS_DATE

Line 188: ,p_action_set_name IN pa_action_sets.action_set_name%TYPE := FND_API.G_MISS_CHAR

184:
185:
186: PROCEDURE update_action_set
187: (p_action_set_id IN pa_action_sets.action_set_id%TYPE := NULL
188: ,p_action_set_name IN pa_action_sets.action_set_name%TYPE := FND_API.G_MISS_CHAR
189: ,p_action_set_type_code IN pa_action_sets.action_set_type_code%TYPE := FND_API.G_MISS_CHAR
190: ,p_start_date_active IN pa_action_sets.start_date_active%TYPE := FND_API.G_MISS_DATE
191: ,p_end_date_active IN pa_action_sets.end_date_active%TYPE := FND_API.G_MISS_DATE
192: ,p_action_set_template_flag IN pa_action_sets.action_set_template_flag%TYPE := FND_API.G_MISS_CHAR

Line 189: ,p_action_set_type_code IN pa_action_sets.action_set_type_code%TYPE := FND_API.G_MISS_CHAR

185:
186: PROCEDURE update_action_set
187: (p_action_set_id IN pa_action_sets.action_set_id%TYPE := NULL
188: ,p_action_set_name IN pa_action_sets.action_set_name%TYPE := FND_API.G_MISS_CHAR
189: ,p_action_set_type_code IN pa_action_sets.action_set_type_code%TYPE := FND_API.G_MISS_CHAR
190: ,p_start_date_active IN pa_action_sets.start_date_active%TYPE := FND_API.G_MISS_DATE
191: ,p_end_date_active IN pa_action_sets.end_date_active%TYPE := FND_API.G_MISS_DATE
192: ,p_action_set_template_flag IN pa_action_sets.action_set_template_flag%TYPE := FND_API.G_MISS_CHAR
193: ,p_status_code IN pa_action_sets.status_code%TYPE := FND_API.G_MISS_CHAR

Line 190: ,p_start_date_active IN pa_action_sets.start_date_active%TYPE := FND_API.G_MISS_DATE

186: PROCEDURE update_action_set
187: (p_action_set_id IN pa_action_sets.action_set_id%TYPE := NULL
188: ,p_action_set_name IN pa_action_sets.action_set_name%TYPE := FND_API.G_MISS_CHAR
189: ,p_action_set_type_code IN pa_action_sets.action_set_type_code%TYPE := FND_API.G_MISS_CHAR
190: ,p_start_date_active IN pa_action_sets.start_date_active%TYPE := FND_API.G_MISS_DATE
191: ,p_end_date_active IN pa_action_sets.end_date_active%TYPE := FND_API.G_MISS_DATE
192: ,p_action_set_template_flag IN pa_action_sets.action_set_template_flag%TYPE := FND_API.G_MISS_CHAR
193: ,p_status_code IN pa_action_sets.status_code%TYPE := FND_API.G_MISS_CHAR
194: ,p_description IN pa_action_sets.description%TYPE := FND_API.G_MISS_CHAR

Line 191: ,p_end_date_active IN pa_action_sets.end_date_active%TYPE := FND_API.G_MISS_DATE

187: (p_action_set_id IN pa_action_sets.action_set_id%TYPE := NULL
188: ,p_action_set_name IN pa_action_sets.action_set_name%TYPE := FND_API.G_MISS_CHAR
189: ,p_action_set_type_code IN pa_action_sets.action_set_type_code%TYPE := FND_API.G_MISS_CHAR
190: ,p_start_date_active IN pa_action_sets.start_date_active%TYPE := FND_API.G_MISS_DATE
191: ,p_end_date_active IN pa_action_sets.end_date_active%TYPE := FND_API.G_MISS_DATE
192: ,p_action_set_template_flag IN pa_action_sets.action_set_template_flag%TYPE := FND_API.G_MISS_CHAR
193: ,p_status_code IN pa_action_sets.status_code%TYPE := FND_API.G_MISS_CHAR
194: ,p_description IN pa_action_sets.description%TYPE := FND_API.G_MISS_CHAR
195: ,p_record_version_number IN pa_action_sets.record_version_number%TYPE

Line 192: ,p_action_set_template_flag IN pa_action_sets.action_set_template_flag%TYPE := FND_API.G_MISS_CHAR

188: ,p_action_set_name IN pa_action_sets.action_set_name%TYPE := FND_API.G_MISS_CHAR
189: ,p_action_set_type_code IN pa_action_sets.action_set_type_code%TYPE := FND_API.G_MISS_CHAR
190: ,p_start_date_active IN pa_action_sets.start_date_active%TYPE := FND_API.G_MISS_DATE
191: ,p_end_date_active IN pa_action_sets.end_date_active%TYPE := FND_API.G_MISS_DATE
192: ,p_action_set_template_flag IN pa_action_sets.action_set_template_flag%TYPE := FND_API.G_MISS_CHAR
193: ,p_status_code IN pa_action_sets.status_code%TYPE := FND_API.G_MISS_CHAR
194: ,p_description IN pa_action_sets.description%TYPE := FND_API.G_MISS_CHAR
195: ,p_record_version_number IN pa_action_sets.record_version_number%TYPE
196: ,p_attribute_category IN pa_action_sets.attribute_category%TYPE := FND_API.G_MISS_CHAR

Line 193: ,p_status_code IN pa_action_sets.status_code%TYPE := FND_API.G_MISS_CHAR

189: ,p_action_set_type_code IN pa_action_sets.action_set_type_code%TYPE := FND_API.G_MISS_CHAR
190: ,p_start_date_active IN pa_action_sets.start_date_active%TYPE := FND_API.G_MISS_DATE
191: ,p_end_date_active IN pa_action_sets.end_date_active%TYPE := FND_API.G_MISS_DATE
192: ,p_action_set_template_flag IN pa_action_sets.action_set_template_flag%TYPE := FND_API.G_MISS_CHAR
193: ,p_status_code IN pa_action_sets.status_code%TYPE := FND_API.G_MISS_CHAR
194: ,p_description IN pa_action_sets.description%TYPE := FND_API.G_MISS_CHAR
195: ,p_record_version_number IN pa_action_sets.record_version_number%TYPE
196: ,p_attribute_category IN pa_action_sets.attribute_category%TYPE := FND_API.G_MISS_CHAR
197: ,p_attribute1 IN pa_action_sets.attribute1%TYPE := FND_API.G_MISS_CHAR

Line 194: ,p_description IN pa_action_sets.description%TYPE := FND_API.G_MISS_CHAR

190: ,p_start_date_active IN pa_action_sets.start_date_active%TYPE := FND_API.G_MISS_DATE
191: ,p_end_date_active IN pa_action_sets.end_date_active%TYPE := FND_API.G_MISS_DATE
192: ,p_action_set_template_flag IN pa_action_sets.action_set_template_flag%TYPE := FND_API.G_MISS_CHAR
193: ,p_status_code IN pa_action_sets.status_code%TYPE := FND_API.G_MISS_CHAR
194: ,p_description IN pa_action_sets.description%TYPE := FND_API.G_MISS_CHAR
195: ,p_record_version_number IN pa_action_sets.record_version_number%TYPE
196: ,p_attribute_category IN pa_action_sets.attribute_category%TYPE := FND_API.G_MISS_CHAR
197: ,p_attribute1 IN pa_action_sets.attribute1%TYPE := FND_API.G_MISS_CHAR
198: ,p_attribute2 IN pa_action_sets.attribute2%TYPE := FND_API.G_MISS_CHAR

Line 195: ,p_record_version_number IN pa_action_sets.record_version_number%TYPE

191: ,p_end_date_active IN pa_action_sets.end_date_active%TYPE := FND_API.G_MISS_DATE
192: ,p_action_set_template_flag IN pa_action_sets.action_set_template_flag%TYPE := FND_API.G_MISS_CHAR
193: ,p_status_code IN pa_action_sets.status_code%TYPE := FND_API.G_MISS_CHAR
194: ,p_description IN pa_action_sets.description%TYPE := FND_API.G_MISS_CHAR
195: ,p_record_version_number IN pa_action_sets.record_version_number%TYPE
196: ,p_attribute_category IN pa_action_sets.attribute_category%TYPE := FND_API.G_MISS_CHAR
197: ,p_attribute1 IN pa_action_sets.attribute1%TYPE := FND_API.G_MISS_CHAR
198: ,p_attribute2 IN pa_action_sets.attribute2%TYPE := FND_API.G_MISS_CHAR
199: ,p_attribute3 IN pa_action_sets.attribute3%TYPE := FND_API.G_MISS_CHAR

Line 196: ,p_attribute_category IN pa_action_sets.attribute_category%TYPE := FND_API.G_MISS_CHAR

192: ,p_action_set_template_flag IN pa_action_sets.action_set_template_flag%TYPE := FND_API.G_MISS_CHAR
193: ,p_status_code IN pa_action_sets.status_code%TYPE := FND_API.G_MISS_CHAR
194: ,p_description IN pa_action_sets.description%TYPE := FND_API.G_MISS_CHAR
195: ,p_record_version_number IN pa_action_sets.record_version_number%TYPE
196: ,p_attribute_category IN pa_action_sets.attribute_category%TYPE := FND_API.G_MISS_CHAR
197: ,p_attribute1 IN pa_action_sets.attribute1%TYPE := FND_API.G_MISS_CHAR
198: ,p_attribute2 IN pa_action_sets.attribute2%TYPE := FND_API.G_MISS_CHAR
199: ,p_attribute3 IN pa_action_sets.attribute3%TYPE := FND_API.G_MISS_CHAR
200: ,p_attribute4 IN pa_action_sets.attribute4%TYPE := FND_API.G_MISS_CHAR

Line 197: ,p_attribute1 IN pa_action_sets.attribute1%TYPE := FND_API.G_MISS_CHAR

193: ,p_status_code IN pa_action_sets.status_code%TYPE := FND_API.G_MISS_CHAR
194: ,p_description IN pa_action_sets.description%TYPE := FND_API.G_MISS_CHAR
195: ,p_record_version_number IN pa_action_sets.record_version_number%TYPE
196: ,p_attribute_category IN pa_action_sets.attribute_category%TYPE := FND_API.G_MISS_CHAR
197: ,p_attribute1 IN pa_action_sets.attribute1%TYPE := FND_API.G_MISS_CHAR
198: ,p_attribute2 IN pa_action_sets.attribute2%TYPE := FND_API.G_MISS_CHAR
199: ,p_attribute3 IN pa_action_sets.attribute3%TYPE := FND_API.G_MISS_CHAR
200: ,p_attribute4 IN pa_action_sets.attribute4%TYPE := FND_API.G_MISS_CHAR
201: ,p_attribute5 IN pa_action_sets.attribute5%TYPE := FND_API.G_MISS_CHAR

Line 198: ,p_attribute2 IN pa_action_sets.attribute2%TYPE := FND_API.G_MISS_CHAR

194: ,p_description IN pa_action_sets.description%TYPE := FND_API.G_MISS_CHAR
195: ,p_record_version_number IN pa_action_sets.record_version_number%TYPE
196: ,p_attribute_category IN pa_action_sets.attribute_category%TYPE := FND_API.G_MISS_CHAR
197: ,p_attribute1 IN pa_action_sets.attribute1%TYPE := FND_API.G_MISS_CHAR
198: ,p_attribute2 IN pa_action_sets.attribute2%TYPE := FND_API.G_MISS_CHAR
199: ,p_attribute3 IN pa_action_sets.attribute3%TYPE := FND_API.G_MISS_CHAR
200: ,p_attribute4 IN pa_action_sets.attribute4%TYPE := FND_API.G_MISS_CHAR
201: ,p_attribute5 IN pa_action_sets.attribute5%TYPE := FND_API.G_MISS_CHAR
202: ,p_attribute6 IN pa_action_sets.attribute6%TYPE := FND_API.G_MISS_CHAR

Line 199: ,p_attribute3 IN pa_action_sets.attribute3%TYPE := FND_API.G_MISS_CHAR

195: ,p_record_version_number IN pa_action_sets.record_version_number%TYPE
196: ,p_attribute_category IN pa_action_sets.attribute_category%TYPE := FND_API.G_MISS_CHAR
197: ,p_attribute1 IN pa_action_sets.attribute1%TYPE := FND_API.G_MISS_CHAR
198: ,p_attribute2 IN pa_action_sets.attribute2%TYPE := FND_API.G_MISS_CHAR
199: ,p_attribute3 IN pa_action_sets.attribute3%TYPE := FND_API.G_MISS_CHAR
200: ,p_attribute4 IN pa_action_sets.attribute4%TYPE := FND_API.G_MISS_CHAR
201: ,p_attribute5 IN pa_action_sets.attribute5%TYPE := FND_API.G_MISS_CHAR
202: ,p_attribute6 IN pa_action_sets.attribute6%TYPE := FND_API.G_MISS_CHAR
203: ,p_attribute7 IN pa_action_sets.attribute7%TYPE := FND_API.G_MISS_CHAR

Line 200: ,p_attribute4 IN pa_action_sets.attribute4%TYPE := FND_API.G_MISS_CHAR

196: ,p_attribute_category IN pa_action_sets.attribute_category%TYPE := FND_API.G_MISS_CHAR
197: ,p_attribute1 IN pa_action_sets.attribute1%TYPE := FND_API.G_MISS_CHAR
198: ,p_attribute2 IN pa_action_sets.attribute2%TYPE := FND_API.G_MISS_CHAR
199: ,p_attribute3 IN pa_action_sets.attribute3%TYPE := FND_API.G_MISS_CHAR
200: ,p_attribute4 IN pa_action_sets.attribute4%TYPE := FND_API.G_MISS_CHAR
201: ,p_attribute5 IN pa_action_sets.attribute5%TYPE := FND_API.G_MISS_CHAR
202: ,p_attribute6 IN pa_action_sets.attribute6%TYPE := FND_API.G_MISS_CHAR
203: ,p_attribute7 IN pa_action_sets.attribute7%TYPE := FND_API.G_MISS_CHAR
204: ,p_attribute8 IN pa_action_sets.attribute8%TYPE := FND_API.G_MISS_CHAR

Line 201: ,p_attribute5 IN pa_action_sets.attribute5%TYPE := FND_API.G_MISS_CHAR

197: ,p_attribute1 IN pa_action_sets.attribute1%TYPE := FND_API.G_MISS_CHAR
198: ,p_attribute2 IN pa_action_sets.attribute2%TYPE := FND_API.G_MISS_CHAR
199: ,p_attribute3 IN pa_action_sets.attribute3%TYPE := FND_API.G_MISS_CHAR
200: ,p_attribute4 IN pa_action_sets.attribute4%TYPE := FND_API.G_MISS_CHAR
201: ,p_attribute5 IN pa_action_sets.attribute5%TYPE := FND_API.G_MISS_CHAR
202: ,p_attribute6 IN pa_action_sets.attribute6%TYPE := FND_API.G_MISS_CHAR
203: ,p_attribute7 IN pa_action_sets.attribute7%TYPE := FND_API.G_MISS_CHAR
204: ,p_attribute8 IN pa_action_sets.attribute8%TYPE := FND_API.G_MISS_CHAR
205: ,p_attribute9 IN pa_action_sets.attribute9%TYPE := FND_API.G_MISS_CHAR

Line 202: ,p_attribute6 IN pa_action_sets.attribute6%TYPE := FND_API.G_MISS_CHAR

198: ,p_attribute2 IN pa_action_sets.attribute2%TYPE := FND_API.G_MISS_CHAR
199: ,p_attribute3 IN pa_action_sets.attribute3%TYPE := FND_API.G_MISS_CHAR
200: ,p_attribute4 IN pa_action_sets.attribute4%TYPE := FND_API.G_MISS_CHAR
201: ,p_attribute5 IN pa_action_sets.attribute5%TYPE := FND_API.G_MISS_CHAR
202: ,p_attribute6 IN pa_action_sets.attribute6%TYPE := FND_API.G_MISS_CHAR
203: ,p_attribute7 IN pa_action_sets.attribute7%TYPE := FND_API.G_MISS_CHAR
204: ,p_attribute8 IN pa_action_sets.attribute8%TYPE := FND_API.G_MISS_CHAR
205: ,p_attribute9 IN pa_action_sets.attribute9%TYPE := FND_API.G_MISS_CHAR
206: ,p_attribute10 IN pa_action_sets.attribute10%TYPE := FND_API.G_MISS_CHAR

Line 203: ,p_attribute7 IN pa_action_sets.attribute7%TYPE := FND_API.G_MISS_CHAR

199: ,p_attribute3 IN pa_action_sets.attribute3%TYPE := FND_API.G_MISS_CHAR
200: ,p_attribute4 IN pa_action_sets.attribute4%TYPE := FND_API.G_MISS_CHAR
201: ,p_attribute5 IN pa_action_sets.attribute5%TYPE := FND_API.G_MISS_CHAR
202: ,p_attribute6 IN pa_action_sets.attribute6%TYPE := FND_API.G_MISS_CHAR
203: ,p_attribute7 IN pa_action_sets.attribute7%TYPE := FND_API.G_MISS_CHAR
204: ,p_attribute8 IN pa_action_sets.attribute8%TYPE := FND_API.G_MISS_CHAR
205: ,p_attribute9 IN pa_action_sets.attribute9%TYPE := FND_API.G_MISS_CHAR
206: ,p_attribute10 IN pa_action_sets.attribute10%TYPE := FND_API.G_MISS_CHAR
207: ,p_attribute11 IN pa_action_sets.attribute11%TYPE := FND_API.G_MISS_CHAR

Line 204: ,p_attribute8 IN pa_action_sets.attribute8%TYPE := FND_API.G_MISS_CHAR

200: ,p_attribute4 IN pa_action_sets.attribute4%TYPE := FND_API.G_MISS_CHAR
201: ,p_attribute5 IN pa_action_sets.attribute5%TYPE := FND_API.G_MISS_CHAR
202: ,p_attribute6 IN pa_action_sets.attribute6%TYPE := FND_API.G_MISS_CHAR
203: ,p_attribute7 IN pa_action_sets.attribute7%TYPE := FND_API.G_MISS_CHAR
204: ,p_attribute8 IN pa_action_sets.attribute8%TYPE := FND_API.G_MISS_CHAR
205: ,p_attribute9 IN pa_action_sets.attribute9%TYPE := FND_API.G_MISS_CHAR
206: ,p_attribute10 IN pa_action_sets.attribute10%TYPE := FND_API.G_MISS_CHAR
207: ,p_attribute11 IN pa_action_sets.attribute11%TYPE := FND_API.G_MISS_CHAR
208: ,p_attribute12 IN pa_action_sets.attribute12%TYPE := FND_API.G_MISS_CHAR

Line 205: ,p_attribute9 IN pa_action_sets.attribute9%TYPE := FND_API.G_MISS_CHAR

201: ,p_attribute5 IN pa_action_sets.attribute5%TYPE := FND_API.G_MISS_CHAR
202: ,p_attribute6 IN pa_action_sets.attribute6%TYPE := FND_API.G_MISS_CHAR
203: ,p_attribute7 IN pa_action_sets.attribute7%TYPE := FND_API.G_MISS_CHAR
204: ,p_attribute8 IN pa_action_sets.attribute8%TYPE := FND_API.G_MISS_CHAR
205: ,p_attribute9 IN pa_action_sets.attribute9%TYPE := FND_API.G_MISS_CHAR
206: ,p_attribute10 IN pa_action_sets.attribute10%TYPE := FND_API.G_MISS_CHAR
207: ,p_attribute11 IN pa_action_sets.attribute11%TYPE := FND_API.G_MISS_CHAR
208: ,p_attribute12 IN pa_action_sets.attribute12%TYPE := FND_API.G_MISS_CHAR
209: ,p_attribute13 IN pa_action_sets.attribute13%TYPE := FND_API.G_MISS_CHAR

Line 206: ,p_attribute10 IN pa_action_sets.attribute10%TYPE := FND_API.G_MISS_CHAR

202: ,p_attribute6 IN pa_action_sets.attribute6%TYPE := FND_API.G_MISS_CHAR
203: ,p_attribute7 IN pa_action_sets.attribute7%TYPE := FND_API.G_MISS_CHAR
204: ,p_attribute8 IN pa_action_sets.attribute8%TYPE := FND_API.G_MISS_CHAR
205: ,p_attribute9 IN pa_action_sets.attribute9%TYPE := FND_API.G_MISS_CHAR
206: ,p_attribute10 IN pa_action_sets.attribute10%TYPE := FND_API.G_MISS_CHAR
207: ,p_attribute11 IN pa_action_sets.attribute11%TYPE := FND_API.G_MISS_CHAR
208: ,p_attribute12 IN pa_action_sets.attribute12%TYPE := FND_API.G_MISS_CHAR
209: ,p_attribute13 IN pa_action_sets.attribute13%TYPE := FND_API.G_MISS_CHAR
210: ,p_attribute14 IN pa_action_sets.attribute14%TYPE := FND_API.G_MISS_CHAR

Line 207: ,p_attribute11 IN pa_action_sets.attribute11%TYPE := FND_API.G_MISS_CHAR

203: ,p_attribute7 IN pa_action_sets.attribute7%TYPE := FND_API.G_MISS_CHAR
204: ,p_attribute8 IN pa_action_sets.attribute8%TYPE := FND_API.G_MISS_CHAR
205: ,p_attribute9 IN pa_action_sets.attribute9%TYPE := FND_API.G_MISS_CHAR
206: ,p_attribute10 IN pa_action_sets.attribute10%TYPE := FND_API.G_MISS_CHAR
207: ,p_attribute11 IN pa_action_sets.attribute11%TYPE := FND_API.G_MISS_CHAR
208: ,p_attribute12 IN pa_action_sets.attribute12%TYPE := FND_API.G_MISS_CHAR
209: ,p_attribute13 IN pa_action_sets.attribute13%TYPE := FND_API.G_MISS_CHAR
210: ,p_attribute14 IN pa_action_sets.attribute14%TYPE := FND_API.G_MISS_CHAR
211: ,p_attribute15 IN pa_action_sets.attribute15%TYPE := FND_API.G_MISS_CHAR

Line 208: ,p_attribute12 IN pa_action_sets.attribute12%TYPE := FND_API.G_MISS_CHAR

204: ,p_attribute8 IN pa_action_sets.attribute8%TYPE := FND_API.G_MISS_CHAR
205: ,p_attribute9 IN pa_action_sets.attribute9%TYPE := FND_API.G_MISS_CHAR
206: ,p_attribute10 IN pa_action_sets.attribute10%TYPE := FND_API.G_MISS_CHAR
207: ,p_attribute11 IN pa_action_sets.attribute11%TYPE := FND_API.G_MISS_CHAR
208: ,p_attribute12 IN pa_action_sets.attribute12%TYPE := FND_API.G_MISS_CHAR
209: ,p_attribute13 IN pa_action_sets.attribute13%TYPE := FND_API.G_MISS_CHAR
210: ,p_attribute14 IN pa_action_sets.attribute14%TYPE := FND_API.G_MISS_CHAR
211: ,p_attribute15 IN pa_action_sets.attribute15%TYPE := FND_API.G_MISS_CHAR
212: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 209: ,p_attribute13 IN pa_action_sets.attribute13%TYPE := FND_API.G_MISS_CHAR

205: ,p_attribute9 IN pa_action_sets.attribute9%TYPE := FND_API.G_MISS_CHAR
206: ,p_attribute10 IN pa_action_sets.attribute10%TYPE := FND_API.G_MISS_CHAR
207: ,p_attribute11 IN pa_action_sets.attribute11%TYPE := FND_API.G_MISS_CHAR
208: ,p_attribute12 IN pa_action_sets.attribute12%TYPE := FND_API.G_MISS_CHAR
209: ,p_attribute13 IN pa_action_sets.attribute13%TYPE := FND_API.G_MISS_CHAR
210: ,p_attribute14 IN pa_action_sets.attribute14%TYPE := FND_API.G_MISS_CHAR
211: ,p_attribute15 IN pa_action_sets.attribute15%TYPE := FND_API.G_MISS_CHAR
212: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
213: )

Line 210: ,p_attribute14 IN pa_action_sets.attribute14%TYPE := FND_API.G_MISS_CHAR

206: ,p_attribute10 IN pa_action_sets.attribute10%TYPE := FND_API.G_MISS_CHAR
207: ,p_attribute11 IN pa_action_sets.attribute11%TYPE := FND_API.G_MISS_CHAR
208: ,p_attribute12 IN pa_action_sets.attribute12%TYPE := FND_API.G_MISS_CHAR
209: ,p_attribute13 IN pa_action_sets.attribute13%TYPE := FND_API.G_MISS_CHAR
210: ,p_attribute14 IN pa_action_sets.attribute14%TYPE := FND_API.G_MISS_CHAR
211: ,p_attribute15 IN pa_action_sets.attribute15%TYPE := FND_API.G_MISS_CHAR
212: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
213: )
214: IS

Line 211: ,p_attribute15 IN pa_action_sets.attribute15%TYPE := FND_API.G_MISS_CHAR

207: ,p_attribute11 IN pa_action_sets.attribute11%TYPE := FND_API.G_MISS_CHAR
208: ,p_attribute12 IN pa_action_sets.attribute12%TYPE := FND_API.G_MISS_CHAR
209: ,p_attribute13 IN pa_action_sets.attribute13%TYPE := FND_API.G_MISS_CHAR
210: ,p_attribute14 IN pa_action_sets.attribute14%TYPE := FND_API.G_MISS_CHAR
211: ,p_attribute15 IN pa_action_sets.attribute15%TYPE := FND_API.G_MISS_CHAR
212: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
213: )
214: IS
215:

Line 220: l_previous_status pa_action_sets.status_code%TYPE;

216: l_return_status VARCHAR2(1);
217: l_action_set_id NUMBER;
218: l_record_version_number NUMBER;
219: l_existing_action_set_id NUMBER;
220: l_previous_status pa_action_sets.status_code%TYPE;
221: l_status_code pa_action_sets.status_code%TYPE;
222: l_unique VARCHAR2(1);
223: l_actual_start_date DATE := FND_API.G_MISS_DATE;
224: l_action_set_type_code pa_action_set_types.action_set_type_code%TYPE;

Line 221: l_status_code pa_action_sets.status_code%TYPE;

217: l_action_set_id NUMBER;
218: l_record_version_number NUMBER;
219: l_existing_action_set_id NUMBER;
220: l_previous_status pa_action_sets.status_code%TYPE;
221: l_status_code pa_action_sets.status_code%TYPE;
222: l_unique VARCHAR2(1);
223: l_actual_start_date DATE := FND_API.G_MISS_DATE;
224: l_action_set_type_code pa_action_set_types.action_set_type_code%TYPE;
225: l_action_set_template_flag VARCHAR2(1);

Line 240: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ACTION_SETS_PVT.Update_Action_Set.begin'

236: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
237:
238: --Log Message: 4403338
239: IF l_debug_mode = 'Y' THEN
240: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ACTION_SETS_PVT.Update_Action_Set.begin'
241: ,x_msg => 'Beginning of Update_Action_Set pvt'
242: ,x_log_level => 5);
243: END IF;
244:

Line 249: FROM pa_action_sets

245: SELECT action_set_type_code,
246: action_set_template_flag
247: INTO l_action_set_type_code,
248: l_action_set_template_flag
249: FROM pa_action_sets
250: WHERE action_set_id = p_action_set_id;
251:
252: IF l_action_set_template_flag = 'Y' THEN
253:

Line 282: FROM pa_action_sets

278: --validate that status is a valid next status
279: null;
280:
281: SELECT status_code INTO l_previous_status
282: FROM pa_action_sets
283: WHERE action_set_id = p_action_set_id;
284:
285: IF p_status_code = 'STARTED' AND l_previous_status <> 'STARTED' THEN
286: l_actual_start_date := SYSDATE;

Line 295: PA_ACTION_SETS_PKG.update_row

291: END IF;
292:
293: IF FND_MSG_PUB.Count_Msg =0 THEN
294:
295: PA_ACTION_SETS_PKG.update_row
296: (p_action_set_id => p_action_set_id
297: ,p_action_set_name => p_action_set_name
298: ,p_start_date_active => p_start_date_active
299: ,p_end_date_active => p_end_date_active

Line 326: PA_ACTION_SETS_DYN.Process_Action_Set(p_action_set_type_code => l_action_set_type_code,

322: --be needed in order to update line numbers based on the actual start date.
323: -- 2334717: When RESUMED, should be performed as well.
324: IF p_status_code = 'STARTED' OR p_status_code = 'RESUMED'THEN
325:
326: PA_ACTION_SETS_DYN.Process_Action_Set(p_action_set_type_code => l_action_set_type_code,
327: p_action_set_id => p_action_set_id,
328: p_action_set_template_flag => l_action_set_template_flag,
329: x_return_status => l_return_status);
330:

Line 333: PA_ACTION_SETS_PUB.perform_single_action_set

329: x_return_status => l_return_status);
330:
331: IF l_action_set_template_flag = 'N' AND FND_MSG_PUB.Count_Msg = 0 THEN
332:
333: PA_ACTION_SETS_PUB.perform_single_action_set
334: (p_action_set_id => p_action_set_id,
335: p_init_msg_list => FND_API.G_FALSE,
336: x_return_status => l_return_status,
337: x_msg_count => l_msg_count,

Line 354: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_ACTION_SETS_PVT.Update_Action_Set'

350: EXCEPTION
351: WHEN OTHERS THEN
352:
353: -- Set the excetption Message and the stack
354: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_ACTION_SETS_PVT.Update_Action_Set'
355: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
356: --
357: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
358: RAISE;

Line 364: (p_action_set_id IN pa_action_sets.action_set_id%TYPE

360: END Update_Action_Set;
361:
362:
363: PROCEDURE delete_action_set
364: (p_action_set_id IN pa_action_sets.action_set_id%TYPE
365: ,p_record_version_number IN pa_action_sets.record_version_number%TYPE := NULL
366: ,x_return_status OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895
367: IS
368:

Line 365: ,p_record_version_number IN pa_action_sets.record_version_number%TYPE := NULL

361:
362:
363: PROCEDURE delete_action_set
364: (p_action_set_id IN pa_action_sets.action_set_id%TYPE
365: ,p_record_version_number IN pa_action_sets.record_version_number%TYPE := NULL
366: ,x_return_status OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895
367: IS
368:
369: l_return_status VARCHAR2(1);

Line 391: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ACTION_SETS_PVT.Delete_Action_Set'

387: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
388:
389: --Log Message: 4403338
390: IF l_debug_mode = 'Y' THEN
391: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ACTION_SETS_PVT.Delete_Action_Set'
392: ,x_msg => 'Beginning of Delete_Action_Set pvt'
393: ,x_log_level => 5);
394: END IF;
395:

Line 397: FROM pa_action_sets

393: ,x_log_level => 5);
394: END IF;
395:
396: SELECT action_set_template_flag INTO l_action_set_template_flag
397: FROM pa_action_sets
398: WHERE action_set_id = p_action_set_id;
399:
400: IF l_action_set_template_flag = 'Y' THEN
401:

Line 435: PA_ACTION_SETS_PKG.delete_row

431: l_do_lines_exist := PA_ACTION_SET_UTILS.do_lines_exist(p_action_set_id => p_action_set_id);
432:
433: IF l_do_lines_exist = 'N' THEN
434:
435: PA_ACTION_SETS_PKG.delete_row
436: (p_action_set_id => p_action_set_id,
437: p_record_version_number => p_record_version_number,
438: x_return_status => l_return_status);
439:

Line 444: PA_ACTION_SETS_PUB.perform_single_action_set(p_action_set_id => p_action_set_id

440: ELSE
441:
442: IF l_action_set_template_flag = 'N' THEN
443:
444: PA_ACTION_SETS_PUB.perform_single_action_set(p_action_set_id => p_action_set_id
445: ,p_init_msg_list => FND_API.G_FALSE
446: ,x_return_status => l_return_status
447: ,x_msg_count => l_msg_count
448: ,x_msg_data => l_msg_data);

Line 452: PA_ACTION_SETS_PKG.update_row(p_action_set_id => p_action_set_id,

448: ,x_msg_data => l_msg_data);
449: END IF;
450:
451:
452: PA_ACTION_SETS_PKG.update_row(p_action_set_id => p_action_set_id,
453: p_record_version_number => p_record_version_number,
454: p_status_code => 'DELETED',
455: x_return_status => l_return_status);
456:

Line 470: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_ACTION_SETS_PVT.Delete_Action_Set'

466: EXCEPTION
467: WHEN OTHERS THEN
468:
469: -- Set the excetption Message and the stack
470: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_ACTION_SETS_PVT.Delete_Action_Set'
471: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
472: --
473: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
474: RAISE;

Line 482: (p_action_set_id IN pa_action_sets.action_set_id%TYPE

478:
479:
480:
481: PROCEDURE create_action_set_line
482: (p_action_set_id IN pa_action_sets.action_set_id%TYPE
483: ,p_use_def_description_flag IN VARCHAR2 := 'Y'
484: ,p_description IN pa_action_set_lines.description%TYPE := NULL
485: ,p_action_set_line_number IN pa_action_set_lines.action_set_line_number%TYPE := NULL
486: ,p_action_code IN pa_action_set_lines.action_code%TYPE

Line 507: l_action_set_template_flag pa_action_sets.action_set_template_flag%TYPE;

503: l_return_status VARCHAR2(1);
504: l_msg_index_out NUMBER;
505: l_action_set_line_rec pa_action_set_lines%ROWTYPE;
506: l_action_set_type_code pa_action_set_types.action_set_type_code%TYPE;
507: l_action_set_template_flag pa_action_sets.action_set_template_flag%TYPE;
508: l_action_set_line_id NUMBER;
509: l_action_line_condition_id NUMBER;
510: l_debug_mode VARCHAR2(20) := 'N';
511:

Line 522: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ACTION_SETS_PVT.Create_Action_Set_Line.begin'

518: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
519:
520: --Log Message: 4403338
521: IF l_debug_mode = 'Y' THEN
522: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ACTION_SETS_PVT.Create_Action_Set_Line.begin'
523: ,x_msg => 'Beginning of Create_Action_Set_Line pvt'
524: ,x_log_level => 5);
525: END IF;
526:

Line 543: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ACTION_SETS_PVT.Create_Action_Set_Line.begin'

539: l_action_set_line_rec.action_attribute10 := p_action_attribute10;
540:
541: --Log Message: 4403338
542: IF l_debug_mode = 'Y' THEN
543: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ACTION_SETS_PVT.Create_Action_Set_Line.begin'
544: ,x_msg => 'p_action_set_id = '|| p_action_set_id
545: ,x_log_level => 5);
546: END IF;
547:

Line 550: FROM pa_action_sets

546: END IF;
547:
548: SELECT action_set_type_code, action_set_template_flag
549: INTO l_action_set_type_code, l_action_set_template_flag
550: FROM pa_action_sets
551: WHERE action_set_id = p_action_set_id;
552:
553: --Log Message: 4403338
554: IF l_debug_mode = 'Y' THEN

Line 555: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ACTION_SETS_PVT.Create_Action_Set_Line.begin'

551: WHERE action_set_id = p_action_set_id;
552:
553: --Log Message: 4403338
554: IF l_debug_mode = 'Y' THEN
555: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ACTION_SETS_PVT.Create_Action_Set_Line.begin'
556: ,x_msg => 'Before validate_action_set_line: '||'action_set_type_code = '||l_action_set_type_code
557: ,x_log_level => 5);
558: END IF;
559:

Line 560: PA_ACTION_SETS_DYN.Validate_Action_Set_Line(p_action_set_type_code => l_action_set_type_code,

556: ,x_msg => 'Before validate_action_set_line: '||'action_set_type_code = '||l_action_set_type_code
557: ,x_log_level => 5);
558: END IF;
559:
560: PA_ACTION_SETS_DYN.Validate_Action_Set_Line(p_action_set_type_code => l_action_set_type_code,
561: p_action_set_line_rec => l_action_set_line_rec,
562: p_action_line_conditions_tbl => p_condition_tbl,
563: x_return_status => l_return_status);
564:

Line 567: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ACTION_SETS_PVT.Create_Action_Set_Line.begin'

563: x_return_status => l_return_status);
564:
565: --Log Message: 4403338
566: IF l_debug_mode = 'Y' THEN
567: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ACTION_SETS_PVT.Create_Action_Set_Line.begin'
568: ,x_msg => 'After validate_action_set_line: x_retun_status = '||l_return_status
569: ,x_log_level => 5);
570: END IF;
571:

Line 628: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_ACTION_SETS_PVT.Create_Action_Set_Line'

624: EXCEPTION
625: WHEN OTHERS THEN
626:
627: -- Set the excetption Message and the stack
628: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_ACTION_SETS_PVT.Create_Action_Set_Line'
629: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
630: --
631: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
632: RAISE;

Line 662: l_action_set_id pa_action_sets.action_set_id%TYPE;

658: l_return_status VARCHAR2(1);
659: l_record_version_number NUMBER;
660: l_current_line_status pa_action_set_lines.status_code%TYPE;
661: l_action_set_type_code pa_action_set_types.action_set_type_code%TYPE;
662: l_action_set_id pa_action_sets.action_set_id%TYPE;
663: l_action_set_line_rec pa_action_set_lines%ROWTYPE;
664: l_action_set_template_flag VARCHAR2(1);
665: l_debug_mode VARCHAR2(20) := 'N';
666:

Line 677: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ACTION_SETS_PVT.Update_Action_Set_Line.begin'

673: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
674:
675: --Log Message: 4403338
676: IF l_debug_mode = 'Y' THEN
677: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ACTION_SETS_PVT.Update_Action_Set_Line.begin'
678: ,x_msg => 'Beginning of Update_Action_Set_Line pvt'
679: ,x_log_level => 5);
680: END IF;
681:

Line 690: FROM pa_action_sets sets,

686: INTO l_action_set_type_code,
687: l_action_set_id,
688: l_action_set_template_flag,
689: l_current_line_status
690: FROM pa_action_sets sets,
691: pa_action_set_lines lines
692: WHERE lines.action_set_line_id = p_action_set_line_id
693: AND sets.action_set_id = lines.action_set_id;
694:

Line 715: PA_ACTION_SETS_DYN.Validate_Action_Set_Line(p_action_set_type_code => l_action_set_type_code,

711: l_action_set_line_rec.action_attribute9 := p_action_attribute9;
712: l_action_set_line_rec.action_attribute10 := p_action_attribute10;
713:
714:
715: PA_ACTION_SETS_DYN.Validate_Action_Set_Line(p_action_set_type_code => l_action_set_type_code,
716: p_action_set_line_rec => l_action_set_line_rec,
717: p_action_line_conditions_tbl => p_condition_tbl,
718: x_return_status => l_return_status);
719:

Line 776: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_ACTION_SETS_PVT.Update_Action_Set_Line'

772: EXCEPTION
773: WHEN OTHERS THEN
774:
775: -- Set the excetption Message and the stack
776: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_ACTION_SETS_PVT.Update_Action_Set_Line'
777: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
778: --
779: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
780: RAISE;

Line 786: (p_action_set_line_id IN pa_action_sets.action_set_id%TYPE

782: END Update_Action_Set_Line;
783:
784:
785: PROCEDURE delete_action_set_line
786: (p_action_set_line_id IN pa_action_sets.action_set_id%TYPE
787: ,p_record_version_number IN pa_action_set_lines.record_version_number%TYPE
788: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
789: )
790: IS

Line 794: l_action_set_id pa_action_sets.action_set_id%TYPE;

790: IS
791:
792: l_return_status VARCHAR2(1);
793: l_action_set_type_code pa_action_set_types.action_set_type_code%TYPE;
794: l_action_set_id pa_action_sets.action_set_id%TYPE;
795: l_action_set_template_flag pa_action_sets.action_set_template_flag%TYPE;
796: l_current_line_status pa_action_set_lines.status_code%TYPE;
797: l_do_audit_lines_exist VARCHAR2(1);
798: l_action_line_conditions_tbl pa_action_set_utils.action_line_cond_tbl_type;

Line 795: l_action_set_template_flag pa_action_sets.action_set_template_flag%TYPE;

791:
792: l_return_status VARCHAR2(1);
793: l_action_set_type_code pa_action_set_types.action_set_type_code%TYPE;
794: l_action_set_id pa_action_sets.action_set_id%TYPE;
795: l_action_set_template_flag pa_action_sets.action_set_template_flag%TYPE;
796: l_current_line_status pa_action_set_lines.status_code%TYPE;
797: l_do_audit_lines_exist VARCHAR2(1);
798: l_action_line_conditions_tbl pa_action_set_utils.action_line_cond_tbl_type;
799: l_debug_mode VARCHAR2(20) := 'N';

Line 811: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ACTION_SETS_PVT.Delete_Action_Set_Line.begin'

807: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
808:
809: --Log Message: 4403338
810: IF l_debug_mode = 'Y' THEN
811: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ACTION_SETS_PVT.Delete_Action_Set_Line.begin'
812: ,x_msg => 'Beginning of Delete_Action_Set_Line pvt'
813: ,x_log_level => 5);
814: END IF;
815:

Line 824: FROM pa_action_sets sets,

820: INTO l_action_set_type_code,
821: l_action_set_id,
822: l_action_set_template_flag,
823: l_current_line_status
824: FROM pa_action_sets sets,
825: pa_action_set_lines lines
826: WHERE lines.action_set_line_id = p_action_set_line_id
827: AND sets.action_set_id = lines.action_set_id;
828:

Line 838: UPDATE pa_action_sets

834: ELSIF l_current_line_status = 'REVERSED' THEN
835:
836: -- 2411522 : Need to set MOD_SOURCE_ACTION_SET_FLAG = 'Y' when deleting a line.
837: IF l_action_set_template_flag = 'N' THEN
838: UPDATE pa_action_sets
839: SET MOD_SOURCE_ACTION_SET_FLAG = 'Y'
840: WHERE action_set_id = l_action_set_id;
841: END IF;
842:

Line 862: UPDATE pa_action_sets

858: l_do_audit_lines_exist :=
859: PA_ACTION_SET_UTILS.do_audit_lines_exist(p_action_set_line_id => p_action_set_line_id);
860: IF ( l_do_audit_lines_exist = 'N' AND l_current_line_status <> 'ACTIVE' ) THEN
861: IF l_action_set_template_flag = 'N' THEN
862: UPDATE pa_action_sets
863: SET MOD_SOURCE_ACTION_SET_FLAG = 'Y'
864: WHERE action_set_id = l_action_set_id;
865: END IF;
866: l_action_line_conditions_tbl :=

Line 889: UPDATE pa_action_sets

885: ELSE -- l_action_set_type_code = 'ADVERTISEMENT' ) THEN
886: IF ( l_do_audit_lines_exist = 'N' AND l_current_line_status <> 'ACTIVE' AND l_current_line_status <> 'COMPLETE' ) THEN
887: -- 2411522 : Need to set MOD_SOURCE_ACTION_SET_FLAG = 'Y' when deleting a line.
888: IF l_action_set_template_flag = 'N' THEN
889: UPDATE pa_action_sets
890: SET MOD_SOURCE_ACTION_SET_FLAG = 'Y'
891: WHERE action_set_id = l_action_set_id;
892: END IF;
893: l_action_line_conditions_tbl :=

Line 930: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_ACTION_SETS_PVT.Delete_Action_Set_Line'

926: EXCEPTION
927: WHEN OTHERS THEN
928:
929: -- Set the excetption Message and the stack
930: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_ACTION_SETS_PVT.Delete_Action_Set_Line'
931: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
932: --
933: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
934: RAISE;

Line 943: l_action_set_details_rec pa_action_sets%ROWTYPE;

939: FUNCTION get_def_reverse_audit_lines(p_action_set_line_id IN pa_action_set_lines.action_set_line_id%TYPE,
940: p_reason IN VARCHAR2) RETURN pa_action_set_utils.insert_audit_lines_tbl_type
941: IS
942:
943: l_action_set_details_rec pa_action_sets%ROWTYPE;
944:
945: l_active_audit_lines_tbl pa_action_set_utils.audit_lines_tbl_type;
946: l_insert_audit_lines_tbl pa_action_set_utils.insert_audit_lines_tbl_type;
947: l_reason_code_tbl pa_action_set_utils.varchar_tbl_type;

Line 987: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_ACTION_SETS_PVT.reverse_action_audit_lines'

983: EXCEPTION
984: WHEN OTHERS THEN
985:
986: -- Set the excetption Message and the stack
987: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_ACTION_SETS_PVT.reverse_action_audit_lines'
988: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
989: --
990: RAISE;
991:

Line 998: p_object_type IN pa_action_sets.object_type%TYPE,

994:
995:
996: PROCEDURE bulk_insert_audit_lines(p_audit_lines_tbl IN pa_action_set_utils.insert_audit_lines_tbl_type,
997: p_action_set_line_id IN pa_action_set_lines.action_set_line_id%TYPE,
998: p_object_type IN pa_action_sets.object_type%TYPE,
999: p_object_id IN pa_action_sets.object_id%TYPE,
1000: p_action_set_type_code IN pa_action_sets.action_set_type_code%TYPE,
1001: p_status_code IN VARCHAR2,
1002: x_return_status OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895

Line 999: p_object_id IN pa_action_sets.object_id%TYPE,

995:
996: PROCEDURE bulk_insert_audit_lines(p_audit_lines_tbl IN pa_action_set_utils.insert_audit_lines_tbl_type,
997: p_action_set_line_id IN pa_action_set_lines.action_set_line_id%TYPE,
998: p_object_type IN pa_action_sets.object_type%TYPE,
999: p_object_id IN pa_action_sets.object_id%TYPE,
1000: p_action_set_type_code IN pa_action_sets.action_set_type_code%TYPE,
1001: p_status_code IN VARCHAR2,
1002: x_return_status OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895
1003: IS

Line 1000: p_action_set_type_code IN pa_action_sets.action_set_type_code%TYPE,

996: PROCEDURE bulk_insert_audit_lines(p_audit_lines_tbl IN pa_action_set_utils.insert_audit_lines_tbl_type,
997: p_action_set_line_id IN pa_action_set_lines.action_set_line_id%TYPE,
998: p_object_type IN pa_action_sets.object_type%TYPE,
999: p_object_id IN pa_action_sets.object_id%TYPE,
1000: p_action_set_type_code IN pa_action_sets.action_set_type_code%TYPE,
1001: p_status_code IN VARCHAR2,
1002: x_return_status OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895
1003: IS
1004:

Line 1090: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_ACTION_SETS_PVT.bulk_insert_audit_lines'

1086: EXCEPTION
1087: WHEN OTHERS THEN
1088:
1089: -- Set the excetption Message and the stack
1090: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_ACTION_SETS_PVT.bulk_insert_audit_lines'
1091: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
1092: --
1093: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1094: RAISE;

Line 1141: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_ACTION_SETS_PVT.bulk_update_line_number'

1137: x_return_status := FND_API.G_RET_STS_ERROR;
1138: WHEN OTHERS THEN
1139:
1140: -- Set the excetption Message and the stack
1141: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_ACTION_SETS_PVT.bulk_update_line_number'
1142: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
1143: --
1144: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1145: RAISE;

Line 1190: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_ACTION_SETS_PVT.bulk_update_condition_date'

1186: x_return_status := FND_API.G_RET_STS_ERROR;
1187:
1188: WHEN OTHERS THEN
1189: -- Set the excetption Message and the stack
1190: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_ACTION_SETS_PVT.bulk_update_condition_date'
1191: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
1192: --
1193: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1194: RAISE;

Line 1238: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_ACTION_SETS_PVT.bulk_update_line_status'

1234: ,p_msg_name => 'PA_ACTION_LINE_CHANGE_PENDING');
1235: x_return_status := FND_API.G_RET_STS_ERROR;
1236: WHEN OTHERS THEN
1237: -- Set the excetption Message and the stack
1238: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_ACTION_SETS_PVT.bulk_update_line_status'
1239: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
1240: --
1241: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1242: RAISE;

Line 1249: ,p_action_set_line_id IN pa_action_sets.action_set_id%TYPE

1245:
1246:
1247: PROCEDURE perform_action_set_line
1248: (p_action_set_type_code IN pa_action_set_types.action_set_type_code%TYPE
1249: ,p_action_set_line_id IN pa_action_sets.action_set_id%TYPE
1250: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1251: )
1252: IS
1253:

Line 1260: l_action_set_details_rec pa_action_sets%ROWTYPE;

1256: l_action_line_conditions_tbl pa_action_set_utils.action_line_cond_tbl_type;
1257: l_action_line_audit_tbl pa_action_set_utils.insert_audit_lines_tbl_type;
1258: l_action_line_complete_flag VARCHAR2(1);
1259: l_action_line_result_code VARCHAR2(240);
1260: l_action_set_details_rec pa_action_sets%ROWTYPE;
1261: l_audit_status_code VARCHAR2(30);
1262: l_new_line_status_code VARCHAR2(30);
1263: l_line_deleted_flag VARCHAR2(1);
1264: l_action_set_line_number NUMBER;

Line 1280: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ACTION_SETS_PVT.Perform_Action_Set_Line.begin'

1276: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
1277:
1278: --Log Message: 4403338
1279: IF l_debug_mode = 'Y' THEN
1280: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ACTION_SETS_PVT.Perform_Action_Set_Line.begin'
1281: ,x_msg => 'Beginning of Perform_Action_Set_Line pvt'
1282: ,x_log_level => 5);
1283: END IF;
1284:

Line 1293: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ACTION_SETS_PVT.Perform_Action_Set_Line.begin'

1289: l_action_line_conditions_tbl := PA_ACTION_SET_UTILS.get_action_line_conditions(p_action_set_line_id => p_action_set_line_id);
1290:
1291: --Log Message: 4403338
1292: IF l_debug_mode = 'Y' THEN
1293: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ACTION_SETS_PVT.Perform_Action_Set_Line.begin'
1294: ,x_msg => 'Before calling PA_ACTION_SETS_DYN.perform_action_set_line'
1295: ,x_log_level => 5);
1296: END IF;
1297:

Line 1294: ,x_msg => 'Before calling PA_ACTION_SETS_DYN.perform_action_set_line'

1290:
1291: --Log Message: 4403338
1292: IF l_debug_mode = 'Y' THEN
1293: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ACTION_SETS_PVT.Perform_Action_Set_Line.begin'
1294: ,x_msg => 'Before calling PA_ACTION_SETS_DYN.perform_action_set_line'
1295: ,x_log_level => 5);
1296: END IF;
1297:
1298: PA_ACTION_SETS_DYN.perform_action_set_line

Line 1298: PA_ACTION_SETS_DYN.perform_action_set_line

1294: ,x_msg => 'Before calling PA_ACTION_SETS_DYN.perform_action_set_line'
1295: ,x_log_level => 5);
1296: END IF;
1297:
1298: PA_ACTION_SETS_DYN.perform_action_set_line
1299: (p_action_set_type_code => p_action_set_type_code,
1300: p_action_set_details_rec => l_action_set_details_rec,
1301: p_action_set_line_rec => l_action_set_line_rec,
1302: p_action_line_conditions_tbl => l_action_line_conditions_tbl,

Line 1308: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ACTION_SETS_PVT.Perform_Action_Set_Line.begin'

1304: x_action_line_result_code => l_action_line_result_code);
1305:
1306: --Log Message: 4403338
1307: IF l_debug_mode = 'Y' THEN
1308: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ACTION_SETS_PVT.Perform_Action_Set_Line.begin'
1309: ,x_msg => 'After calling PA_ACTION_SETS_DYN.perform_action_set_line'
1310: ,x_log_level => 5);
1311: END IF;
1312:

Line 1309: ,x_msg => 'After calling PA_ACTION_SETS_DYN.perform_action_set_line'

1305:
1306: --Log Message: 4403338
1307: IF l_debug_mode = 'Y' THEN
1308: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ACTION_SETS_PVT.Perform_Action_Set_Line.begin'
1309: ,x_msg => 'After calling PA_ACTION_SETS_DYN.perform_action_set_line'
1310: ,x_log_level => 5);
1311: END IF;
1312:
1313: IF l_action_line_result_code = PA_ACTION_SET_UTILS.G_PERFORMED_COMPLETE THEN

Line 1413: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_ACTION_SETS_PVT.Perform_Action_Set_Line'

1409: */
1410:
1411: EXCEPTION
1412: WHEN e_invalid_result_code THEN
1413: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_ACTION_SETS_PVT.Perform_Action_Set_Line'
1414: ,p_procedure_name => PA_DEBUG.G_Err_Stack
1415: ,p_error_text => 'INVALID RESULT CODE: '||l_action_line_result_code);
1416: --
1417: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 1422: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_ACTION_SETS_PVT.Perform_Action_Set_Line'

1418: RAISE e_invalid_result_code;
1419:
1420: WHEN OTHERS THEN
1421: -- Set the excetption Message and the stack
1422: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_ACTION_SETS_PVT.Perform_Action_Set_Line'
1423: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
1424: --
1425: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1426: RAISE;