APPS.PA_ACTION_SETS_PUB dependencies on FND_API

Line 32: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE

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
35: ,x_action_set_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
36: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 33: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

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
35: ,x_action_set_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
36: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
37: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 34: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE

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
35: ,x_action_set_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
36: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
37: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
38: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 55: x_return_status := FND_API.G_RET_STS_SUCCESS;

51: -- Bug 4403338
52: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
53:
54: -- Initialize the return status to success
55: x_return_status := FND_API.G_RET_STS_SUCCESS;
56:
57: --Clear the global PL/SQL message table
58: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN
59: FND_MSG_PUB.initialize;

Line 58: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN

54: -- Initialize the return status to success
55: x_return_status := FND_API.G_RET_STS_SUCCESS;
56:
57: --Clear the global PL/SQL message table
58: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN
59: FND_MSG_PUB.initialize;
60: END IF;
61:
62: -- Issue API savepoint if the transaction is to be committed

Line 63: IF p_commit = FND_API.G_TRUE THEN

59: FND_MSG_PUB.initialize;
60: END IF;
61:
62: -- Issue API savepoint if the transaction is to be committed
63: IF p_commit = FND_API.G_TRUE THEN
64: SAVEPOINT CREATE_ACTION_SETS_PUB;
65: END IF;
66:
67: --Log Message: 4403338

Line 111: pa_interface_utils_pub.get_messages ( p_encoded => FND_API.G_TRUE

107: ,x_return_status => l_return_status);
108:
109: x_msg_count := FND_MSG_PUB.Count_Msg;
110: IF x_msg_count = 1 THEN
111: pa_interface_utils_pub.get_messages ( p_encoded => FND_API.G_TRUE
112: ,p_msg_index => 1
113: ,p_data => x_msg_data
114: ,p_msg_index_out => l_msg_index_out
115: );

Line 123: x_return_status := FND_API.G_RET_STS_ERROR;

119: PA_DEBUG.Reset_Err_Stack;
120: -- If any errors exist then set the x_return_status to 'E'
121:
122: IF x_msg_count > 0 THEN
123: x_return_status := FND_API.G_RET_STS_ERROR;
124: END IF;
125:
126: -- Commit if the flag is set and there is no error
127: IF p_commit = FND_API.G_TRUE AND x_msg_count = 0 THEN

Line 127: IF p_commit = FND_API.G_TRUE AND x_msg_count = 0 THEN

123: x_return_status := FND_API.G_RET_STS_ERROR;
124: END IF;
125:
126: -- Commit if the flag is set and there is no error
127: IF p_commit = FND_API.G_TRUE AND x_msg_count = 0 THEN
128: COMMIT;
129: END IF;
130:
131: EXCEPTION

Line 133: IF p_commit = FND_API.G_TRUE THEN

129: END IF;
130:
131: EXCEPTION
132: WHEN OTHERS THEN
133: IF p_commit = FND_API.G_TRUE THEN
134: ROLLBACK TO CREATE_ACTION_SETS_PUB;
135: END IF;
136:
137: -- Set the excetption Message and the stack

Line 141: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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;
143:
144: END Create_Action_Set;
145:

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

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

Line 150: ,p_object_type IN pa_action_sets.object_type%TYPE := FND_API.G_MISS_CHAR

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

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

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

Line 152: ,p_object_id IN pa_action_sets.object_id%TYPE := FND_API.G_MISS_NUM

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

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

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

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

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

Line 155: ,p_action_set_template_flag IN pa_action_sets.action_set_template_flag%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
159: ,p_attribute_category IN pa_action_sets.attribute_category%TYPE := FND_API.G_MISS_CHAR

Line 156: ,p_status_code IN pa_action_sets.status_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
160: ,p_attribute1 IN pa_action_sets.attribute1%TYPE := FND_API.G_MISS_CHAR

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 171: ,p_attribute12 IN pa_action_sets.attribute12%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

Line 172: ,p_attribute13 IN pa_action_sets.attribute13%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
176: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE

Line 173: ,p_attribute14 IN pa_action_sets.attribute14%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
177: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

Line 174: ,p_attribute15 IN pa_action_sets.attribute15%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
178: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE

Line 176: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE

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
179: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
180: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 177: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

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
179: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
180: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
181: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 178: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE

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
179: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
180: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
181: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
182: )

Line 200: x_return_status := FND_API.G_RET_STS_SUCCESS;

196: -- Bug 4403338
197: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
198:
199: -- Initialize the return status to success
200: x_return_status := FND_API.G_RET_STS_SUCCESS;
201:
202: --Clear the global PL/SQL message table
203: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN
204: FND_MSG_PUB.initialize;

Line 203: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN

199: -- Initialize the return status to success
200: x_return_status := FND_API.G_RET_STS_SUCCESS;
201:
202: --Clear the global PL/SQL message table
203: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN
204: FND_MSG_PUB.initialize;
205: END IF;
206:
207: -- Issue API savepoint if the transaction is to be committed

Line 208: IF p_commit = FND_API.G_TRUE THEN

204: FND_MSG_PUB.initialize;
205: END IF;
206:
207: -- Issue API savepoint if the transaction is to be committed
208: IF p_commit = FND_API.G_TRUE THEN
209: SAVEPOINT UPDATE_ACTION_SETS_PUB;
210: END IF;
211:
212: --Log Message: 4403338

Line 279: pa_interface_utils_pub.get_messages ( p_encoded => FND_API.G_TRUE

275:
276:
277: x_msg_count := FND_MSG_PUB.Count_Msg;
278: IF x_msg_count = 1 THEN
279: pa_interface_utils_pub.get_messages ( p_encoded => FND_API.G_TRUE
280: ,p_msg_index => 1
281: ,p_data => x_msg_data
282: ,p_msg_index_out => l_msg_index_out
283: );

Line 291: x_return_status := FND_API.G_RET_STS_ERROR;

287: PA_DEBUG.Reset_Err_Stack;
288: -- If any errors exist then set the x_return_status to 'E'
289:
290: IF x_msg_count > 0 THEN
291: x_return_status := FND_API.G_RET_STS_ERROR;
292: END IF;
293:
294: -- Commit if the flag is set and there is no error
295: IF p_commit = FND_API.G_TRUE AND x_msg_count = 0 THEN

Line 295: IF p_commit = FND_API.G_TRUE AND x_msg_count = 0 THEN

291: x_return_status := FND_API.G_RET_STS_ERROR;
292: END IF;
293:
294: -- Commit if the flag is set and there is no error
295: IF p_commit = FND_API.G_TRUE AND x_msg_count = 0 THEN
296: COMMIT;
297: END IF;
298:
299: EXCEPTION

Line 301: IF p_commit = FND_API.G_TRUE THEN

297: END IF;
298:
299: EXCEPTION
300: WHEN OTHERS THEN
301: IF p_commit = FND_API.G_TRUE THEN
302: ROLLBACK TO UPDATE_ACTION_SETS_PUB;
303: END IF;
304:
305: -- Set the excetption Message and the stack

Line 309: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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;
311:
312: END Update_Action_Set;
313:

Line 322: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE

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
325: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
326: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 323: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

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
325: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
326: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
327: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 324: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE

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
325: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
326: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
327: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
328: )

Line 351: x_return_status := FND_API.G_RET_STS_SUCCESS;

347: -- Bug 4403338
348: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
349:
350: -- Initialize the return status to success
351: x_return_status := FND_API.G_RET_STS_SUCCESS;
352:
353: --Clear the global PL/SQL message table
354: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN
355: FND_MSG_PUB.initialize;

Line 354: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN

350: -- Initialize the return status to success
351: x_return_status := FND_API.G_RET_STS_SUCCESS;
352:
353: --Clear the global PL/SQL message table
354: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN
355: FND_MSG_PUB.initialize;
356: END IF;
357:
358: -- 5130421

Line 362: IF p_commit = FND_API.G_TRUE THEN

358: -- 5130421
359: l_start_msg_count := FND_MSG_PUB.count_msg ;
360:
361: -- Issue API savepoint if the transaction is to be committed
362: IF p_commit = FND_API.G_TRUE THEN
363: SAVEPOINT Delete_ACTION_SETS_PUB;
364: END IF;
365:
366: --Log Message: 4403338

Line 417: pa_interface_utils_pub.get_messages ( p_encoded => FND_API.G_TRUE

413: l_current_api_msg_count := l_end_msg_count - l_start_msg_count;
414:
415: -- 5130421 IF x_msg_count = 1 THEN
416: IF l_current_api_msg_count = 1 THEN
417: pa_interface_utils_pub.get_messages ( p_encoded => FND_API.G_TRUE
418: ,p_msg_index => 1
419: ,p_data => x_msg_data
420: ,p_msg_index_out => l_msg_index_out
421: );

Line 430: x_return_status := FND_API.G_RET_STS_ERROR;

426: -- If any errors exist then set the x_return_status to 'E'
427:
428: -- 5130421 IF x_msg_count > 0 THEN
429: IF l_current_api_msg_count > 0 THEN
430: x_return_status := FND_API.G_RET_STS_ERROR;
431: END IF;
432:
433: -- Commit if the flag is set and there is no error
434: IF p_commit = FND_API.G_TRUE AND x_msg_count = 0 THEN

Line 434: IF p_commit = FND_API.G_TRUE AND x_msg_count = 0 THEN

430: x_return_status := FND_API.G_RET_STS_ERROR;
431: END IF;
432:
433: -- Commit if the flag is set and there is no error
434: IF p_commit = FND_API.G_TRUE AND x_msg_count = 0 THEN
435: COMMIT;
436: END IF;
437:
438: EXCEPTION

Line 440: IF p_commit = FND_API.G_TRUE THEN

436: END IF;
437:
438: EXCEPTION
439: WHEN OTHERS THEN
440: IF p_commit = FND_API.G_TRUE THEN
441: ROLLBACK TO Delete_ACTION_SETS_PUB;
442: END IF;
443:
444: -- Set the excetption Message and the stack

Line 448: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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;
450:
451: END Delete_Action_Set;
452:

Line 474: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE

470: ,p_action_attribute9 IN pa_action_set_lines.action_attribute9%TYPE := NULL
471: ,p_action_attribute10 IN pa_action_set_lines.action_attribute10%TYPE := NULL
472: ,p_condition_tbl IN pa_action_set_utils.action_line_cond_tbl_type
473: ,p_api_version IN NUMBER := 1.0
474: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
475: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
476: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
477: ,x_action_set_line_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
478: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 475: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

471: ,p_action_attribute10 IN pa_action_set_lines.action_attribute10%TYPE := NULL
472: ,p_condition_tbl IN pa_action_set_utils.action_line_cond_tbl_type
473: ,p_api_version IN NUMBER := 1.0
474: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
475: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
476: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
477: ,x_action_set_line_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
478: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
479: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 476: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE

472: ,p_condition_tbl IN pa_action_set_utils.action_line_cond_tbl_type
473: ,p_api_version IN NUMBER := 1.0
474: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
475: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
476: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
477: ,x_action_set_line_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
478: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
479: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
480: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 497: x_return_status := FND_API.G_RET_STS_SUCCESS;

493: -- Bug 4403338
494: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
495:
496: -- Initialize the return status to success
497: x_return_status := FND_API.G_RET_STS_SUCCESS;
498:
499: --Clear the global PL/SQL message table
500: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN
501: FND_MSG_PUB.initialize;

Line 500: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN

496: -- Initialize the return status to success
497: x_return_status := FND_API.G_RET_STS_SUCCESS;
498:
499: --Clear the global PL/SQL message table
500: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN
501: FND_MSG_PUB.initialize;
502: END IF;
503:
504: -- Issue API savepoint if the transaction is to be committed

Line 505: IF p_commit = FND_API.G_TRUE THEN

501: FND_MSG_PUB.initialize;
502: END IF;
503:
504: -- Issue API savepoint if the transaction is to be committed
505: IF p_commit = FND_API.G_TRUE THEN
506: SAVEPOINT CREATE_ACTION_SET_LINE_PUB;
507: END IF;
508:
509: --Log Message: 4403338

Line 542: pa_interface_utils_pub.get_messages ( p_encoded => FND_API.G_TRUE

538: ,x_return_status => l_return_status);
539:
540: x_msg_count := FND_MSG_PUB.Count_Msg;
541: IF x_msg_count = 1 THEN
542: pa_interface_utils_pub.get_messages ( p_encoded => FND_API.G_TRUE
543: ,p_msg_index => 1
544: ,p_data => x_msg_data
545: ,p_msg_index_out => l_msg_index_out
546: );

Line 554: x_return_status := FND_API.G_RET_STS_ERROR;

550: PA_DEBUG.Reset_Err_Stack;
551: -- If any errors exist then set the x_return_status to 'E'
552:
553: IF x_msg_count > 0 THEN
554: x_return_status := FND_API.G_RET_STS_ERROR;
555: END IF;
556:
557: -- Commit if the flag is set and there is no error
558: IF p_commit = FND_API.G_TRUE AND x_msg_count = 0 THEN

Line 558: IF p_commit = FND_API.G_TRUE AND x_msg_count = 0 THEN

554: x_return_status := FND_API.G_RET_STS_ERROR;
555: END IF;
556:
557: -- Commit if the flag is set and there is no error
558: IF p_commit = FND_API.G_TRUE AND x_msg_count = 0 THEN
559: COMMIT;
560: END IF;
561:
562: EXCEPTION

Line 564: IF p_commit = FND_API.G_TRUE THEN

560: END IF;
561:
562: EXCEPTION
563: WHEN OTHERS THEN
564: IF p_commit = FND_API.G_TRUE THEN
565: ROLLBACK TO CREATE_ACTION_SET_LINE_PUB;
566: END IF;
567:
568: -- Set the excetption Message and the stack

Line 572: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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;
574:
575: END Create_Action_Set_Line;
576:

Line 581: ,p_action_set_line_number IN pa_action_set_lines.action_set_line_number%TYPE := FND_API.G_MISS_NUM

577:
578: PROCEDURE update_action_set_line
579: (p_action_set_line_id IN pa_action_set_lines.action_set_line_id%TYPE
580: ,p_record_version_number IN pa_action_set_lines.record_version_number%TYPE
581: ,p_action_set_line_number IN pa_action_set_lines.action_set_line_number%TYPE := FND_API.G_MISS_NUM
582: ,p_use_def_description_flag IN VARCHAR2 := 'Y'
583: ,p_description IN pa_action_set_lines.description%TYPE := FND_API.G_MISS_CHAR
584: ,p_action_code IN pa_action_set_lines.action_code%TYPE := FND_API.G_MISS_CHAR
585: ,p_action_attribute1 IN pa_action_set_lines.action_attribute1%TYPE := FND_API.G_MISS_CHAR

Line 583: ,p_description IN pa_action_set_lines.description%TYPE := FND_API.G_MISS_CHAR

579: (p_action_set_line_id IN pa_action_set_lines.action_set_line_id%TYPE
580: ,p_record_version_number IN pa_action_set_lines.record_version_number%TYPE
581: ,p_action_set_line_number IN pa_action_set_lines.action_set_line_number%TYPE := FND_API.G_MISS_NUM
582: ,p_use_def_description_flag IN VARCHAR2 := 'Y'
583: ,p_description IN pa_action_set_lines.description%TYPE := FND_API.G_MISS_CHAR
584: ,p_action_code IN pa_action_set_lines.action_code%TYPE := FND_API.G_MISS_CHAR
585: ,p_action_attribute1 IN pa_action_set_lines.action_attribute1%TYPE := FND_API.G_MISS_CHAR
586: ,p_action_attribute2 IN pa_action_set_lines.action_attribute2%TYPE := FND_API.G_MISS_CHAR
587: ,p_action_attribute3 IN pa_action_set_lines.action_attribute3%TYPE := FND_API.G_MISS_CHAR

Line 584: ,p_action_code IN pa_action_set_lines.action_code%TYPE := FND_API.G_MISS_CHAR

580: ,p_record_version_number IN pa_action_set_lines.record_version_number%TYPE
581: ,p_action_set_line_number IN pa_action_set_lines.action_set_line_number%TYPE := FND_API.G_MISS_NUM
582: ,p_use_def_description_flag IN VARCHAR2 := 'Y'
583: ,p_description IN pa_action_set_lines.description%TYPE := FND_API.G_MISS_CHAR
584: ,p_action_code IN pa_action_set_lines.action_code%TYPE := FND_API.G_MISS_CHAR
585: ,p_action_attribute1 IN pa_action_set_lines.action_attribute1%TYPE := FND_API.G_MISS_CHAR
586: ,p_action_attribute2 IN pa_action_set_lines.action_attribute2%TYPE := FND_API.G_MISS_CHAR
587: ,p_action_attribute3 IN pa_action_set_lines.action_attribute3%TYPE := FND_API.G_MISS_CHAR
588: ,p_action_attribute4 IN pa_action_set_lines.action_attribute4%TYPE := FND_API.G_MISS_CHAR

Line 585: ,p_action_attribute1 IN pa_action_set_lines.action_attribute1%TYPE := FND_API.G_MISS_CHAR

581: ,p_action_set_line_number IN pa_action_set_lines.action_set_line_number%TYPE := FND_API.G_MISS_NUM
582: ,p_use_def_description_flag IN VARCHAR2 := 'Y'
583: ,p_description IN pa_action_set_lines.description%TYPE := FND_API.G_MISS_CHAR
584: ,p_action_code IN pa_action_set_lines.action_code%TYPE := FND_API.G_MISS_CHAR
585: ,p_action_attribute1 IN pa_action_set_lines.action_attribute1%TYPE := FND_API.G_MISS_CHAR
586: ,p_action_attribute2 IN pa_action_set_lines.action_attribute2%TYPE := FND_API.G_MISS_CHAR
587: ,p_action_attribute3 IN pa_action_set_lines.action_attribute3%TYPE := FND_API.G_MISS_CHAR
588: ,p_action_attribute4 IN pa_action_set_lines.action_attribute4%TYPE := FND_API.G_MISS_CHAR
589: ,p_action_attribute5 IN pa_action_set_lines.action_attribute5%TYPE := FND_API.G_MISS_CHAR

Line 586: ,p_action_attribute2 IN pa_action_set_lines.action_attribute2%TYPE := FND_API.G_MISS_CHAR

582: ,p_use_def_description_flag IN VARCHAR2 := 'Y'
583: ,p_description IN pa_action_set_lines.description%TYPE := FND_API.G_MISS_CHAR
584: ,p_action_code IN pa_action_set_lines.action_code%TYPE := FND_API.G_MISS_CHAR
585: ,p_action_attribute1 IN pa_action_set_lines.action_attribute1%TYPE := FND_API.G_MISS_CHAR
586: ,p_action_attribute2 IN pa_action_set_lines.action_attribute2%TYPE := FND_API.G_MISS_CHAR
587: ,p_action_attribute3 IN pa_action_set_lines.action_attribute3%TYPE := FND_API.G_MISS_CHAR
588: ,p_action_attribute4 IN pa_action_set_lines.action_attribute4%TYPE := FND_API.G_MISS_CHAR
589: ,p_action_attribute5 IN pa_action_set_lines.action_attribute5%TYPE := FND_API.G_MISS_CHAR
590: ,p_action_attribute6 IN pa_action_set_lines.action_attribute6%TYPE := FND_API.G_MISS_CHAR

Line 587: ,p_action_attribute3 IN pa_action_set_lines.action_attribute3%TYPE := FND_API.G_MISS_CHAR

583: ,p_description IN pa_action_set_lines.description%TYPE := FND_API.G_MISS_CHAR
584: ,p_action_code IN pa_action_set_lines.action_code%TYPE := FND_API.G_MISS_CHAR
585: ,p_action_attribute1 IN pa_action_set_lines.action_attribute1%TYPE := FND_API.G_MISS_CHAR
586: ,p_action_attribute2 IN pa_action_set_lines.action_attribute2%TYPE := FND_API.G_MISS_CHAR
587: ,p_action_attribute3 IN pa_action_set_lines.action_attribute3%TYPE := FND_API.G_MISS_CHAR
588: ,p_action_attribute4 IN pa_action_set_lines.action_attribute4%TYPE := FND_API.G_MISS_CHAR
589: ,p_action_attribute5 IN pa_action_set_lines.action_attribute5%TYPE := FND_API.G_MISS_CHAR
590: ,p_action_attribute6 IN pa_action_set_lines.action_attribute6%TYPE := FND_API.G_MISS_CHAR
591: ,p_action_attribute7 IN pa_action_set_lines.action_attribute7%TYPE := FND_API.G_MISS_CHAR

Line 588: ,p_action_attribute4 IN pa_action_set_lines.action_attribute4%TYPE := FND_API.G_MISS_CHAR

584: ,p_action_code IN pa_action_set_lines.action_code%TYPE := FND_API.G_MISS_CHAR
585: ,p_action_attribute1 IN pa_action_set_lines.action_attribute1%TYPE := FND_API.G_MISS_CHAR
586: ,p_action_attribute2 IN pa_action_set_lines.action_attribute2%TYPE := FND_API.G_MISS_CHAR
587: ,p_action_attribute3 IN pa_action_set_lines.action_attribute3%TYPE := FND_API.G_MISS_CHAR
588: ,p_action_attribute4 IN pa_action_set_lines.action_attribute4%TYPE := FND_API.G_MISS_CHAR
589: ,p_action_attribute5 IN pa_action_set_lines.action_attribute5%TYPE := FND_API.G_MISS_CHAR
590: ,p_action_attribute6 IN pa_action_set_lines.action_attribute6%TYPE := FND_API.G_MISS_CHAR
591: ,p_action_attribute7 IN pa_action_set_lines.action_attribute7%TYPE := FND_API.G_MISS_CHAR
592: ,p_action_attribute8 IN pa_action_set_lines.action_attribute8%TYPE := FND_API.G_MISS_CHAR

Line 589: ,p_action_attribute5 IN pa_action_set_lines.action_attribute5%TYPE := FND_API.G_MISS_CHAR

585: ,p_action_attribute1 IN pa_action_set_lines.action_attribute1%TYPE := FND_API.G_MISS_CHAR
586: ,p_action_attribute2 IN pa_action_set_lines.action_attribute2%TYPE := FND_API.G_MISS_CHAR
587: ,p_action_attribute3 IN pa_action_set_lines.action_attribute3%TYPE := FND_API.G_MISS_CHAR
588: ,p_action_attribute4 IN pa_action_set_lines.action_attribute4%TYPE := FND_API.G_MISS_CHAR
589: ,p_action_attribute5 IN pa_action_set_lines.action_attribute5%TYPE := FND_API.G_MISS_CHAR
590: ,p_action_attribute6 IN pa_action_set_lines.action_attribute6%TYPE := FND_API.G_MISS_CHAR
591: ,p_action_attribute7 IN pa_action_set_lines.action_attribute7%TYPE := FND_API.G_MISS_CHAR
592: ,p_action_attribute8 IN pa_action_set_lines.action_attribute8%TYPE := FND_API.G_MISS_CHAR
593: ,p_action_attribute9 IN pa_action_set_lines.action_attribute9%TYPE := FND_API.G_MISS_CHAR

Line 590: ,p_action_attribute6 IN pa_action_set_lines.action_attribute6%TYPE := FND_API.G_MISS_CHAR

586: ,p_action_attribute2 IN pa_action_set_lines.action_attribute2%TYPE := FND_API.G_MISS_CHAR
587: ,p_action_attribute3 IN pa_action_set_lines.action_attribute3%TYPE := FND_API.G_MISS_CHAR
588: ,p_action_attribute4 IN pa_action_set_lines.action_attribute4%TYPE := FND_API.G_MISS_CHAR
589: ,p_action_attribute5 IN pa_action_set_lines.action_attribute5%TYPE := FND_API.G_MISS_CHAR
590: ,p_action_attribute6 IN pa_action_set_lines.action_attribute6%TYPE := FND_API.G_MISS_CHAR
591: ,p_action_attribute7 IN pa_action_set_lines.action_attribute7%TYPE := FND_API.G_MISS_CHAR
592: ,p_action_attribute8 IN pa_action_set_lines.action_attribute8%TYPE := FND_API.G_MISS_CHAR
593: ,p_action_attribute9 IN pa_action_set_lines.action_attribute9%TYPE := FND_API.G_MISS_CHAR
594: ,p_action_attribute10 IN pa_action_set_lines.action_attribute10%TYPE := FND_API.G_MISS_CHAR

Line 591: ,p_action_attribute7 IN pa_action_set_lines.action_attribute7%TYPE := FND_API.G_MISS_CHAR

587: ,p_action_attribute3 IN pa_action_set_lines.action_attribute3%TYPE := FND_API.G_MISS_CHAR
588: ,p_action_attribute4 IN pa_action_set_lines.action_attribute4%TYPE := FND_API.G_MISS_CHAR
589: ,p_action_attribute5 IN pa_action_set_lines.action_attribute5%TYPE := FND_API.G_MISS_CHAR
590: ,p_action_attribute6 IN pa_action_set_lines.action_attribute6%TYPE := FND_API.G_MISS_CHAR
591: ,p_action_attribute7 IN pa_action_set_lines.action_attribute7%TYPE := FND_API.G_MISS_CHAR
592: ,p_action_attribute8 IN pa_action_set_lines.action_attribute8%TYPE := FND_API.G_MISS_CHAR
593: ,p_action_attribute9 IN pa_action_set_lines.action_attribute9%TYPE := FND_API.G_MISS_CHAR
594: ,p_action_attribute10 IN pa_action_set_lines.action_attribute10%TYPE := FND_API.G_MISS_CHAR
595: ,p_condition_tbl IN pa_action_set_utils.action_line_cond_tbl_type

Line 592: ,p_action_attribute8 IN pa_action_set_lines.action_attribute8%TYPE := FND_API.G_MISS_CHAR

588: ,p_action_attribute4 IN pa_action_set_lines.action_attribute4%TYPE := FND_API.G_MISS_CHAR
589: ,p_action_attribute5 IN pa_action_set_lines.action_attribute5%TYPE := FND_API.G_MISS_CHAR
590: ,p_action_attribute6 IN pa_action_set_lines.action_attribute6%TYPE := FND_API.G_MISS_CHAR
591: ,p_action_attribute7 IN pa_action_set_lines.action_attribute7%TYPE := FND_API.G_MISS_CHAR
592: ,p_action_attribute8 IN pa_action_set_lines.action_attribute8%TYPE := FND_API.G_MISS_CHAR
593: ,p_action_attribute9 IN pa_action_set_lines.action_attribute9%TYPE := FND_API.G_MISS_CHAR
594: ,p_action_attribute10 IN pa_action_set_lines.action_attribute10%TYPE := FND_API.G_MISS_CHAR
595: ,p_condition_tbl IN pa_action_set_utils.action_line_cond_tbl_type
596: ,p_api_version IN NUMBER := 1.0

Line 593: ,p_action_attribute9 IN pa_action_set_lines.action_attribute9%TYPE := FND_API.G_MISS_CHAR

589: ,p_action_attribute5 IN pa_action_set_lines.action_attribute5%TYPE := FND_API.G_MISS_CHAR
590: ,p_action_attribute6 IN pa_action_set_lines.action_attribute6%TYPE := FND_API.G_MISS_CHAR
591: ,p_action_attribute7 IN pa_action_set_lines.action_attribute7%TYPE := FND_API.G_MISS_CHAR
592: ,p_action_attribute8 IN pa_action_set_lines.action_attribute8%TYPE := FND_API.G_MISS_CHAR
593: ,p_action_attribute9 IN pa_action_set_lines.action_attribute9%TYPE := FND_API.G_MISS_CHAR
594: ,p_action_attribute10 IN pa_action_set_lines.action_attribute10%TYPE := FND_API.G_MISS_CHAR
595: ,p_condition_tbl IN pa_action_set_utils.action_line_cond_tbl_type
596: ,p_api_version IN NUMBER := 1.0
597: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE

Line 594: ,p_action_attribute10 IN pa_action_set_lines.action_attribute10%TYPE := FND_API.G_MISS_CHAR

590: ,p_action_attribute6 IN pa_action_set_lines.action_attribute6%TYPE := FND_API.G_MISS_CHAR
591: ,p_action_attribute7 IN pa_action_set_lines.action_attribute7%TYPE := FND_API.G_MISS_CHAR
592: ,p_action_attribute8 IN pa_action_set_lines.action_attribute8%TYPE := FND_API.G_MISS_CHAR
593: ,p_action_attribute9 IN pa_action_set_lines.action_attribute9%TYPE := FND_API.G_MISS_CHAR
594: ,p_action_attribute10 IN pa_action_set_lines.action_attribute10%TYPE := FND_API.G_MISS_CHAR
595: ,p_condition_tbl IN pa_action_set_utils.action_line_cond_tbl_type
596: ,p_api_version IN NUMBER := 1.0
597: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
598: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

Line 597: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE

593: ,p_action_attribute9 IN pa_action_set_lines.action_attribute9%TYPE := FND_API.G_MISS_CHAR
594: ,p_action_attribute10 IN pa_action_set_lines.action_attribute10%TYPE := FND_API.G_MISS_CHAR
595: ,p_condition_tbl IN pa_action_set_utils.action_line_cond_tbl_type
596: ,p_api_version IN NUMBER := 1.0
597: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
598: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
599: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
600: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
601: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 598: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

594: ,p_action_attribute10 IN pa_action_set_lines.action_attribute10%TYPE := FND_API.G_MISS_CHAR
595: ,p_condition_tbl IN pa_action_set_utils.action_line_cond_tbl_type
596: ,p_api_version IN NUMBER := 1.0
597: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
598: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
599: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
600: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
601: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
602: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 599: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE

595: ,p_condition_tbl IN pa_action_set_utils.action_line_cond_tbl_type
596: ,p_api_version IN NUMBER := 1.0
597: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
598: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
599: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
600: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
601: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
602: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
603: )

Line 621: x_return_status := FND_API.G_RET_STS_SUCCESS;

617: -- Bug 4403338
618: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
619:
620: -- Initialize the return status to success
621: x_return_status := FND_API.G_RET_STS_SUCCESS;
622:
623: --Clear the global PL/SQL message table
624: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN
625: FND_MSG_PUB.initialize;

Line 624: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN

620: -- Initialize the return status to success
621: x_return_status := FND_API.G_RET_STS_SUCCESS;
622:
623: --Clear the global PL/SQL message table
624: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN
625: FND_MSG_PUB.initialize;
626: END IF;
627:
628: -- Issue API savepoint if the transaction is to be committed

Line 629: IF p_commit = FND_API.G_TRUE THEN

625: FND_MSG_PUB.initialize;
626: END IF;
627:
628: -- Issue API savepoint if the transaction is to be committed
629: IF p_commit = FND_API.G_TRUE THEN
630: SAVEPOINT UPDATE_ACTION_SET_LINE_PUB;
631: END IF;
632:
633: --Log Message: 4403338

Line 665: pa_interface_utils_pub.get_messages ( p_encoded => FND_API.G_TRUE

661: ,x_return_status => l_return_status);
662:
663: x_msg_count := FND_MSG_PUB.Count_Msg;
664: IF x_msg_count = 1 THEN
665: pa_interface_utils_pub.get_messages ( p_encoded => FND_API.G_TRUE
666: ,p_msg_index => 1
667: ,p_data => x_msg_data
668: ,p_msg_index_out => l_msg_index_out
669: );

Line 677: x_return_status := FND_API.G_RET_STS_ERROR;

673: PA_DEBUG.Reset_Err_Stack;
674: -- If any errors exist then set the x_return_status to 'E'
675:
676: IF x_msg_count > 0 THEN
677: x_return_status := FND_API.G_RET_STS_ERROR;
678: END IF;
679:
680: -- Commit if the flag is set and there is no error
681: IF p_commit = FND_API.G_TRUE AND x_msg_count = 0 THEN

Line 681: IF p_commit = FND_API.G_TRUE AND x_msg_count = 0 THEN

677: x_return_status := FND_API.G_RET_STS_ERROR;
678: END IF;
679:
680: -- Commit if the flag is set and there is no error
681: IF p_commit = FND_API.G_TRUE AND x_msg_count = 0 THEN
682: COMMIT;
683: END IF;
684:
685: EXCEPTION

Line 687: IF p_commit = FND_API.G_TRUE THEN

683: END IF;
684:
685: EXCEPTION
686: WHEN OTHERS THEN
687: IF p_commit = FND_API.G_TRUE THEN
688: ROLLBACK TO UPDATE_ACTION_SET_LINE_PUB;
689: END IF;
690:
691: -- Set the excetption Message and the stack

Line 695: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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;
697:
698: END Update_Action_Set_Line;
699:

Line 705: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE

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
707: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
708: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
709: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 706: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

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
707: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
708: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
709: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
710: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 707: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE

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
707: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
708: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
709: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
710: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
711: )

Line 730: x_return_status := FND_API.G_RET_STS_SUCCESS;

726: -- Bug 4403338
727: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
728:
729: -- Initialize the return status to success
730: x_return_status := FND_API.G_RET_STS_SUCCESS;
731:
732: --Clear the global PL/SQL message table
733: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN
734: FND_MSG_PUB.initialize;

Line 733: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN

729: -- Initialize the return status to success
730: x_return_status := FND_API.G_RET_STS_SUCCESS;
731:
732: --Clear the global PL/SQL message table
733: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN
734: FND_MSG_PUB.initialize;
735: END IF;
736:
737: -- Issue API savepoint if the transaction is to be committed

Line 738: IF p_commit = FND_API.G_TRUE THEN

734: FND_MSG_PUB.initialize;
735: END IF;
736:
737: -- Issue API savepoint if the transaction is to be committed
738: IF p_commit = FND_API.G_TRUE THEN
739: SAVEPOINT Delete_ACTION_SET_LINE_PUB;
740: END IF;
741:
742: --Log Message: 4403338

Line 770: pa_interface_utils_pub.get_messages ( p_encoded => FND_API.G_TRUE

766: ,x_return_status => l_return_status);
767:
768: x_msg_count := FND_MSG_PUB.Count_Msg;
769: IF x_msg_count = 1 THEN
770: pa_interface_utils_pub.get_messages ( p_encoded => FND_API.G_TRUE
771: ,p_msg_index => 1
772: ,p_data => x_msg_data
773: ,p_msg_index_out => l_msg_index_out
774: );

Line 782: x_return_status := FND_API.G_RET_STS_ERROR;

778: PA_DEBUG.Reset_Err_Stack;
779: -- If any errors exist then set the x_return_status to 'E'
780:
781: IF x_msg_count > 0 THEN
782: x_return_status := FND_API.G_RET_STS_ERROR;
783: END IF;
784:
785: -- Commit if the flag is set and there is no error
786: IF p_commit = FND_API.G_TRUE AND x_msg_count = 0 THEN

Line 786: IF p_commit = FND_API.G_TRUE AND x_msg_count = 0 THEN

782: x_return_status := FND_API.G_RET_STS_ERROR;
783: END IF;
784:
785: -- Commit if the flag is set and there is no error
786: IF p_commit = FND_API.G_TRUE AND x_msg_count = 0 THEN
787: COMMIT;
788: END IF;
789:
790: EXCEPTION

Line 792: IF p_commit = FND_API.G_TRUE THEN

788: END IF;
789:
790: EXCEPTION
791: WHEN OTHERS THEN
792: IF p_commit = FND_API.G_TRUE THEN
793: ROLLBACK TO Delete_ACTION_SET_LINE_PUB;
794: END IF;
795:
796: -- Set the excetption Message and the stack

Line 800: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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;
802:
803: END Delete_Action_Set_Line;
804:

Line 812: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE

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
814: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
815: ,x_new_action_set_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
816: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 813: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

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
814: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
815: ,x_new_action_set_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
816: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
817: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 814: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE

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
814: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
815: ,x_new_action_set_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
816: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
817: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
818: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 861: x_return_status := FND_API.G_RET_STS_SUCCESS;

857: -- Bug 4403338
858: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
859:
860: -- Initialize the return status to success
861: x_return_status := FND_API.G_RET_STS_SUCCESS;
862:
863: --Clear the global PL/SQL message table
864: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN
865: FND_MSG_PUB.initialize;

Line 864: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN

860: -- Initialize the return status to success
861: x_return_status := FND_API.G_RET_STS_SUCCESS;
862:
863: --Clear the global PL/SQL message table
864: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN
865: FND_MSG_PUB.initialize;
866: END IF;
867:
868: -- Issue API savepoint if the transaction is to be committed

Line 869: IF p_commit = FND_API.G_TRUE THEN

865: FND_MSG_PUB.initialize;
866: END IF;
867:
868: -- Issue API savepoint if the transaction is to be committed
869: IF p_commit = FND_API.G_TRUE THEN
870: SAVEPOINT APPLY_ACTION_SET_PUB;
871: END IF;
872:
873: --Log Message: 4403338

Line 953: ,p_init_msg_list => FND_API.G_FALSE

949: ,p_attribute12 => l_attribute12
950: ,p_attribute13 => l_attribute13
951: ,p_attribute14 => l_attribute14
952: ,p_attribute15 => l_attribute15
953: ,p_init_msg_list => FND_API.G_FALSE
954: ,x_action_set_id => x_new_action_set_id
955: ,x_return_status => l_return_status
956: ,x_msg_count => l_msg_count
957: ,x_msg_data => l_msg_data);

Line 985: ,p_init_msg_list => FND_API.G_FALSE

981: ,p_action_attribute9 => l_action_set_lines_tbl(i).action_attribute9
982: ,p_action_attribute10 => l_action_set_lines_tbl(i).action_attribute10
983: ,p_condition_tbl => l_action_line_conditions_tbl
984: ,x_action_set_line_id => l_action_set_line_id
985: ,p_init_msg_list => FND_API.G_FALSE
986: ,x_return_status => l_return_status
987: ,x_msg_count => l_msg_count
988: ,x_msg_data => l_msg_data);
989:

Line 1001: ,p_init_msg_list => FND_API.G_FALSE

997:
998: IF p_perform_action_set_flag = 'Y' AND FND_MSG_PUB.Count_Msg = 0 THEN
999:
1000: Perform_Single_Action_Set(p_action_set_id => x_new_action_set_id
1001: ,p_init_msg_list => FND_API.G_FALSE
1002: ,x_return_status => l_return_status
1003: ,x_msg_count => l_msg_count
1004: ,x_msg_data => l_msg_data);
1005:

Line 1017: pa_interface_utils_pub.get_messages ( p_encoded => FND_API.G_TRUE

1013: END IF;
1014:
1015: x_msg_count := FND_MSG_PUB.Count_Msg;
1016: IF x_msg_count = 1 THEN
1017: pa_interface_utils_pub.get_messages ( p_encoded => FND_API.G_TRUE
1018: ,p_msg_index => 1
1019: ,p_data => x_msg_data
1020: ,p_msg_index_out => l_msg_index_out
1021: );

Line 1025: x_return_status := FND_API.G_RET_STS_ERROR;

1021: );
1022: END IF;
1023:
1024: IF x_msg_count > 0 THEN
1025: x_return_status := FND_API.G_RET_STS_ERROR;
1026: END IF;
1027:
1028: -- Reset the error stack when returning to the calling program
1029: PA_DEBUG.Reset_Err_Stack;

Line 1033: IF p_commit = FND_API.G_TRUE AND x_msg_count = 0 THEN

1029: PA_DEBUG.Reset_Err_Stack;
1030: -- If any errors exist then set the x_return_status to 'E'
1031:
1032: -- Commit if the flag is set and there is no error
1033: IF p_commit = FND_API.G_TRUE AND x_msg_count = 0 THEN
1034: COMMIT;
1035: END IF;
1036:
1037: EXCEPTION

Line 1039: IF p_commit = FND_API.G_TRUE THEN

1035: END IF;
1036:
1037: EXCEPTION
1038: WHEN OTHERS THEN
1039: IF p_commit = FND_API.G_TRUE THEN
1040: ROLLBACK TO APPLY_ACTION_SET_PUB;
1041: END IF;
1042:
1043: -- Set the excetption Message and the stack

Line 1047: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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;
1049:
1050: END;
1051:

Line 1061: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE

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
1064: ,x_new_action_set_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
1065: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 1062: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

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
1064: ,x_new_action_set_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
1065: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1066: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 1063: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE

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
1064: ,x_new_action_set_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
1065: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1066: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
1067: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 1089: x_return_status := FND_API.G_RET_STS_SUCCESS;

1085: -- Bug 4370082
1086: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
1087:
1088: -- Initialize the return status to success
1089: x_return_status := FND_API.G_RET_STS_SUCCESS;
1090:
1091: --Clear the global PL/SQL message table
1092: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN
1093: FND_MSG_PUB.initialize;

Line 1092: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN

1088: -- Initialize the return status to success
1089: x_return_status := FND_API.G_RET_STS_SUCCESS;
1090:
1091: --Clear the global PL/SQL message table
1092: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN
1093: FND_MSG_PUB.initialize;
1094: END IF;
1095:
1096: -- Issue API savepoint if the transaction is to be committed

Line 1097: IF p_commit = FND_API.G_TRUE THEN

1093: FND_MSG_PUB.initialize;
1094: END IF;
1095:
1096: -- Issue API savepoint if the transaction is to be committed
1097: IF p_commit = FND_API.G_TRUE THEN
1098: SAVEPOINT REPLACE_ACTION_SET_PUB;
1099: END IF;
1100:
1101: --Log Message: 4370082

Line 1121: ,p_init_msg_list => FND_API.G_FALSE

1117:
1118: delete_action_set(
1119: p_action_set_id => l_current_action_set_id
1120: ,p_record_version_number => p_record_version_number
1121: ,p_init_msg_list => FND_API.G_FALSE
1122: ,x_return_status => l_return_status
1123: ,x_msg_count => l_msg_count
1124: ,x_msg_data => l_msg_data);
1125:

Line 1138: ,p_init_msg_list => FND_API.G_FALSE

1134:
1135: Apply_Action_Set(p_action_set_id => p_new_action_set_id
1136: ,p_object_type => p_object_type
1137: ,p_object_id => p_object_id
1138: ,p_init_msg_list => FND_API.G_FALSE
1139: ,x_new_action_set_id => x_new_action_set_id
1140: ,x_return_status => l_return_status
1141: ,x_msg_count => l_msg_count
1142: ,x_msg_data => l_msg_data);

Line 1149: pa_interface_utils_pub.get_messages ( p_encoded => FND_API.G_TRUE

1145:
1146:
1147: x_msg_count := FND_MSG_PUB.Count_Msg;
1148: IF x_msg_count = 1 THEN
1149: pa_interface_utils_pub.get_messages ( p_encoded => FND_API.G_TRUE
1150: ,p_msg_index => 1
1151: ,p_data => x_msg_data
1152: ,p_msg_index_out => l_msg_index_out
1153: );

Line 1161: x_return_status := FND_API.G_RET_STS_ERROR;

1157: PA_DEBUG.Reset_Err_Stack;
1158: -- If any errors exist then set the x_return_status to 'E'
1159:
1160: IF x_msg_count > 0 THEN
1161: x_return_status := FND_API.G_RET_STS_ERROR;
1162: END IF;
1163:
1164: -- Commit if the flag is set and there is no error
1165: IF p_commit = FND_API.G_TRUE AND x_msg_count = 0 THEN

Line 1165: IF p_commit = FND_API.G_TRUE AND x_msg_count = 0 THEN

1161: x_return_status := FND_API.G_RET_STS_ERROR;
1162: END IF;
1163:
1164: -- Commit if the flag is set and there is no error
1165: IF p_commit = FND_API.G_TRUE AND x_msg_count = 0 THEN
1166: COMMIT;
1167: END IF;
1168:
1169: EXCEPTION

Line 1175: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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: */
1177: RAISE;
1178: WHEN OTHERS THEN
1179: IF p_commit = FND_API.G_TRUE THEN

Line 1179: IF p_commit = FND_API.G_TRUE THEN

1175: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1176: */
1177: RAISE;
1178: WHEN OTHERS THEN
1179: IF p_commit = FND_API.G_TRUE THEN
1180: ROLLBACK TO REPLACE_ACTION_SET;
1181: END IF;
1182:
1183: -- Set the excetption Message and the stack

Line 1187: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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;
1189:
1190: END;
1191:

Line 1200: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE

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
1203: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1204: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 1201: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

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
1203: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1204: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
1205: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 1202: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE

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
1203: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1204: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
1205: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1206: ) IS

Line 1241: x_return_status := FND_API.G_RET_STS_SUCCESS;

1237: -- Bug 4370082
1238: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
1239:
1240: -- Initialize the return status to success
1241: x_return_status := FND_API.G_RET_STS_SUCCESS;
1242:
1243: --Clear the global PL/SQL message table
1244: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN
1245: FND_MSG_PUB.initialize;

Line 1244: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN

1240: -- Initialize the return status to success
1241: x_return_status := FND_API.G_RET_STS_SUCCESS;
1242:
1243: --Clear the global PL/SQL message table
1244: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN
1245: FND_MSG_PUB.initialize;
1246: END IF;
1247:
1248: -- Issue API savepoint if the transaction is to be committed

Line 1249: IF p_commit = FND_API.G_TRUE THEN

1245: FND_MSG_PUB.initialize;
1246: END IF;
1247:
1248: -- Issue API savepoint if the transaction is to be committed
1249: IF p_commit = FND_API.G_TRUE THEN
1250: SAVEPOINT PERFORM_SINGLE_ACTION_SET_PUB;
1251: END IF;
1252:
1253: --Log Message: 4370082

Line 1311: pa_interface_utils_pub.get_messages ( p_encoded => FND_API.G_TRUE

1307: END IF;
1308:
1309: x_msg_count := FND_MSG_PUB.Count_Msg;
1310: IF x_msg_count = 1 THEN
1311: pa_interface_utils_pub.get_messages ( p_encoded => FND_API.G_TRUE
1312: ,p_msg_index => 1
1313: ,p_data => x_msg_data
1314: ,p_msg_index_out => l_msg_index_out
1315: );

Line 1323: x_return_status := FND_API.G_RET_STS_ERROR;

1319: PA_DEBUG.Reset_Err_Stack;
1320: -- If any errors exist then set the x_return_status to 'E'
1321:
1322: IF x_msg_count > 0 OR PA_ACTION_SET_UTILS.G_ERROR_EXISTS = 'Y' THEN
1323: x_return_status := FND_API.G_RET_STS_ERROR;
1324: END IF;
1325:
1326: -- Commit if the flag is set and there is no error
1327: IF p_commit = FND_API.G_TRUE AND x_msg_count = 0 THEN

Line 1327: IF p_commit = FND_API.G_TRUE AND x_msg_count = 0 THEN

1323: x_return_status := FND_API.G_RET_STS_ERROR;
1324: END IF;
1325:
1326: -- Commit if the flag is set and there is no error
1327: IF p_commit = FND_API.G_TRUE AND x_msg_count = 0 THEN
1328: COMMIT;
1329: END IF;
1330:
1331: EXCEPTION

Line 1333: IF p_commit = FND_API.G_TRUE THEN

1329: END IF;
1330:
1331: EXCEPTION
1332: WHEN OTHERS THEN
1333: IF p_commit = FND_API.G_TRUE THEN
1334: ROLLBACK TO PERFORM_SINGLE_ACTION_SET;
1335: END IF;
1336:
1337: -- Set the excetption Message and the stack

Line 1341: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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;
1343:
1344: END;
1345:

Line 1453: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

Line 1462: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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;
1464:
1465:
1466: END;

Line 1499: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE

1495: ,p_condition_attribute8 IN pa_action_set_line_cond.condition_attribute8%TYPE := NULL
1496: ,p_condition_attribute9 IN pa_action_set_line_cond.condition_attribute9%TYPE := NULL
1497: ,p_condition_attribute10 IN pa_action_set_line_cond.condition_attribute10%TYPE := NULL
1498: ,p_api_version IN NUMBER := 1.0
1499: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
1500: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
1501: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
1502: ,x_action_set_line_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
1503: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 1500: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

1496: ,p_condition_attribute9 IN pa_action_set_line_cond.condition_attribute9%TYPE := NULL
1497: ,p_condition_attribute10 IN pa_action_set_line_cond.condition_attribute10%TYPE := NULL
1498: ,p_api_version IN NUMBER := 1.0
1499: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
1500: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
1501: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
1502: ,x_action_set_line_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
1503: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1504: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 1501: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE

1497: ,p_condition_attribute10 IN pa_action_set_line_cond.condition_attribute10%TYPE := NULL
1498: ,p_api_version IN NUMBER := 1.0
1499: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
1500: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
1501: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
1502: ,x_action_set_line_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
1503: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1504: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
1505: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 1518: x_return_status := FND_API.G_RET_STS_SUCCESS;

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:
1520: l_condition_tbl(1).condition_code := p_condition_code;
1521: l_condition_tbl(1).description := p_condition_description;
1522: l_condition_tbl(1).condition_attribute1 := p_condition_attribute1;

Line 1561: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

1557: -- 2452316: Need to set MOD_SOURCE_ACTION_SET_FLAG = 'Y' when a new line
1558: -- is added from self-service page. Should not put this logic in
1559: -- PA_ACTION_SET_PVT.create_action_set_line because that is also called when
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;

Line 1581: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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;
1583:
1584: END;
1585:

Line 1590: ,p_action_description IN pa_action_set_lines.description%TYPE := FND_API.G_MISS_CHAR

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
1593: ,p_action_attribute2 IN pa_action_set_lines.action_attribute2%TYPE := FND_API.G_MISS_CHAR
1594: ,p_action_attribute3 IN pa_action_set_lines.action_attribute3%TYPE := FND_API.G_MISS_CHAR

Line 1592: ,p_action_attribute1 IN pa_action_set_lines.action_attribute1%TYPE := FND_API.G_MISS_CHAR

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
1593: ,p_action_attribute2 IN pa_action_set_lines.action_attribute2%TYPE := FND_API.G_MISS_CHAR
1594: ,p_action_attribute3 IN pa_action_set_lines.action_attribute3%TYPE := FND_API.G_MISS_CHAR
1595: ,p_action_attribute4 IN pa_action_set_lines.action_attribute4%TYPE := FND_API.G_MISS_CHAR
1596: ,p_action_attribute5 IN pa_action_set_lines.action_attribute5%TYPE := FND_API.G_MISS_CHAR

Line 1593: ,p_action_attribute2 IN pa_action_set_lines.action_attribute2%TYPE := FND_API.G_MISS_CHAR

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
1593: ,p_action_attribute2 IN pa_action_set_lines.action_attribute2%TYPE := FND_API.G_MISS_CHAR
1594: ,p_action_attribute3 IN pa_action_set_lines.action_attribute3%TYPE := FND_API.G_MISS_CHAR
1595: ,p_action_attribute4 IN pa_action_set_lines.action_attribute4%TYPE := FND_API.G_MISS_CHAR
1596: ,p_action_attribute5 IN pa_action_set_lines.action_attribute5%TYPE := FND_API.G_MISS_CHAR
1597: ,p_action_attribute6 IN pa_action_set_lines.action_attribute6%TYPE := FND_API.G_MISS_CHAR

Line 1594: ,p_action_attribute3 IN pa_action_set_lines.action_attribute3%TYPE := FND_API.G_MISS_CHAR

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
1593: ,p_action_attribute2 IN pa_action_set_lines.action_attribute2%TYPE := FND_API.G_MISS_CHAR
1594: ,p_action_attribute3 IN pa_action_set_lines.action_attribute3%TYPE := FND_API.G_MISS_CHAR
1595: ,p_action_attribute4 IN pa_action_set_lines.action_attribute4%TYPE := FND_API.G_MISS_CHAR
1596: ,p_action_attribute5 IN pa_action_set_lines.action_attribute5%TYPE := FND_API.G_MISS_CHAR
1597: ,p_action_attribute6 IN pa_action_set_lines.action_attribute6%TYPE := FND_API.G_MISS_CHAR
1598: ,p_action_attribute7 IN pa_action_set_lines.action_attribute7%TYPE := FND_API.G_MISS_CHAR

Line 1595: ,p_action_attribute4 IN pa_action_set_lines.action_attribute4%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
1593: ,p_action_attribute2 IN pa_action_set_lines.action_attribute2%TYPE := FND_API.G_MISS_CHAR
1594: ,p_action_attribute3 IN pa_action_set_lines.action_attribute3%TYPE := FND_API.G_MISS_CHAR
1595: ,p_action_attribute4 IN pa_action_set_lines.action_attribute4%TYPE := FND_API.G_MISS_CHAR
1596: ,p_action_attribute5 IN pa_action_set_lines.action_attribute5%TYPE := FND_API.G_MISS_CHAR
1597: ,p_action_attribute6 IN pa_action_set_lines.action_attribute6%TYPE := FND_API.G_MISS_CHAR
1598: ,p_action_attribute7 IN pa_action_set_lines.action_attribute7%TYPE := FND_API.G_MISS_CHAR
1599: ,p_action_attribute8 IN pa_action_set_lines.action_attribute8%TYPE := FND_API.G_MISS_CHAR

Line 1596: ,p_action_attribute5 IN pa_action_set_lines.action_attribute5%TYPE := FND_API.G_MISS_CHAR

1592: ,p_action_attribute1 IN pa_action_set_lines.action_attribute1%TYPE := FND_API.G_MISS_CHAR
1593: ,p_action_attribute2 IN pa_action_set_lines.action_attribute2%TYPE := FND_API.G_MISS_CHAR
1594: ,p_action_attribute3 IN pa_action_set_lines.action_attribute3%TYPE := FND_API.G_MISS_CHAR
1595: ,p_action_attribute4 IN pa_action_set_lines.action_attribute4%TYPE := FND_API.G_MISS_CHAR
1596: ,p_action_attribute5 IN pa_action_set_lines.action_attribute5%TYPE := FND_API.G_MISS_CHAR
1597: ,p_action_attribute6 IN pa_action_set_lines.action_attribute6%TYPE := FND_API.G_MISS_CHAR
1598: ,p_action_attribute7 IN pa_action_set_lines.action_attribute7%TYPE := FND_API.G_MISS_CHAR
1599: ,p_action_attribute8 IN pa_action_set_lines.action_attribute8%TYPE := FND_API.G_MISS_CHAR
1600: ,p_action_attribute9 IN pa_action_set_lines.action_attribute9%TYPE := FND_API.G_MISS_CHAR

Line 1597: ,p_action_attribute6 IN pa_action_set_lines.action_attribute6%TYPE := FND_API.G_MISS_CHAR

1593: ,p_action_attribute2 IN pa_action_set_lines.action_attribute2%TYPE := FND_API.G_MISS_CHAR
1594: ,p_action_attribute3 IN pa_action_set_lines.action_attribute3%TYPE := FND_API.G_MISS_CHAR
1595: ,p_action_attribute4 IN pa_action_set_lines.action_attribute4%TYPE := FND_API.G_MISS_CHAR
1596: ,p_action_attribute5 IN pa_action_set_lines.action_attribute5%TYPE := FND_API.G_MISS_CHAR
1597: ,p_action_attribute6 IN pa_action_set_lines.action_attribute6%TYPE := FND_API.G_MISS_CHAR
1598: ,p_action_attribute7 IN pa_action_set_lines.action_attribute7%TYPE := FND_API.G_MISS_CHAR
1599: ,p_action_attribute8 IN pa_action_set_lines.action_attribute8%TYPE := FND_API.G_MISS_CHAR
1600: ,p_action_attribute9 IN pa_action_set_lines.action_attribute9%TYPE := FND_API.G_MISS_CHAR
1601: ,p_action_attribute10 IN pa_action_set_lines.action_attribute10%TYPE := FND_API.G_MISS_CHAR

Line 1598: ,p_action_attribute7 IN pa_action_set_lines.action_attribute7%TYPE := FND_API.G_MISS_CHAR

1594: ,p_action_attribute3 IN pa_action_set_lines.action_attribute3%TYPE := FND_API.G_MISS_CHAR
1595: ,p_action_attribute4 IN pa_action_set_lines.action_attribute4%TYPE := FND_API.G_MISS_CHAR
1596: ,p_action_attribute5 IN pa_action_set_lines.action_attribute5%TYPE := FND_API.G_MISS_CHAR
1597: ,p_action_attribute6 IN pa_action_set_lines.action_attribute6%TYPE := FND_API.G_MISS_CHAR
1598: ,p_action_attribute7 IN pa_action_set_lines.action_attribute7%TYPE := FND_API.G_MISS_CHAR
1599: ,p_action_attribute8 IN pa_action_set_lines.action_attribute8%TYPE := FND_API.G_MISS_CHAR
1600: ,p_action_attribute9 IN pa_action_set_lines.action_attribute9%TYPE := FND_API.G_MISS_CHAR
1601: ,p_action_attribute10 IN pa_action_set_lines.action_attribute10%TYPE := FND_API.G_MISS_CHAR
1602: ,p_condition_description IN pa_action_set_line_cond.description%TYPE := FND_API.G_MISS_CHAR

Line 1599: ,p_action_attribute8 IN pa_action_set_lines.action_attribute8%TYPE := FND_API.G_MISS_CHAR

1595: ,p_action_attribute4 IN pa_action_set_lines.action_attribute4%TYPE := FND_API.G_MISS_CHAR
1596: ,p_action_attribute5 IN pa_action_set_lines.action_attribute5%TYPE := FND_API.G_MISS_CHAR
1597: ,p_action_attribute6 IN pa_action_set_lines.action_attribute6%TYPE := FND_API.G_MISS_CHAR
1598: ,p_action_attribute7 IN pa_action_set_lines.action_attribute7%TYPE := FND_API.G_MISS_CHAR
1599: ,p_action_attribute8 IN pa_action_set_lines.action_attribute8%TYPE := FND_API.G_MISS_CHAR
1600: ,p_action_attribute9 IN pa_action_set_lines.action_attribute9%TYPE := FND_API.G_MISS_CHAR
1601: ,p_action_attribute10 IN pa_action_set_lines.action_attribute10%TYPE := FND_API.G_MISS_CHAR
1602: ,p_condition_description IN pa_action_set_line_cond.description%TYPE := FND_API.G_MISS_CHAR
1603: ,p_condition_code IN pa_action_set_line_cond.condition_code%TYPE

Line 1600: ,p_action_attribute9 IN pa_action_set_lines.action_attribute9%TYPE := FND_API.G_MISS_CHAR

1596: ,p_action_attribute5 IN pa_action_set_lines.action_attribute5%TYPE := FND_API.G_MISS_CHAR
1597: ,p_action_attribute6 IN pa_action_set_lines.action_attribute6%TYPE := FND_API.G_MISS_CHAR
1598: ,p_action_attribute7 IN pa_action_set_lines.action_attribute7%TYPE := FND_API.G_MISS_CHAR
1599: ,p_action_attribute8 IN pa_action_set_lines.action_attribute8%TYPE := FND_API.G_MISS_CHAR
1600: ,p_action_attribute9 IN pa_action_set_lines.action_attribute9%TYPE := FND_API.G_MISS_CHAR
1601: ,p_action_attribute10 IN pa_action_set_lines.action_attribute10%TYPE := FND_API.G_MISS_CHAR
1602: ,p_condition_description IN pa_action_set_line_cond.description%TYPE := FND_API.G_MISS_CHAR
1603: ,p_condition_code IN pa_action_set_line_cond.condition_code%TYPE
1604: ,p_condition_attribute1 IN pa_action_set_line_cond.condition_attribute1%TYPE := FND_API.G_MISS_CHAR

Line 1601: ,p_action_attribute10 IN pa_action_set_lines.action_attribute10%TYPE := FND_API.G_MISS_CHAR

1597: ,p_action_attribute6 IN pa_action_set_lines.action_attribute6%TYPE := FND_API.G_MISS_CHAR
1598: ,p_action_attribute7 IN pa_action_set_lines.action_attribute7%TYPE := FND_API.G_MISS_CHAR
1599: ,p_action_attribute8 IN pa_action_set_lines.action_attribute8%TYPE := FND_API.G_MISS_CHAR
1600: ,p_action_attribute9 IN pa_action_set_lines.action_attribute9%TYPE := FND_API.G_MISS_CHAR
1601: ,p_action_attribute10 IN pa_action_set_lines.action_attribute10%TYPE := FND_API.G_MISS_CHAR
1602: ,p_condition_description IN pa_action_set_line_cond.description%TYPE := FND_API.G_MISS_CHAR
1603: ,p_condition_code IN pa_action_set_line_cond.condition_code%TYPE
1604: ,p_condition_attribute1 IN pa_action_set_line_cond.condition_attribute1%TYPE := FND_API.G_MISS_CHAR
1605: ,p_condition_attribute2 IN pa_action_set_line_cond.condition_attribute2%TYPE := FND_API.G_MISS_CHAR

Line 1602: ,p_condition_description IN pa_action_set_line_cond.description%TYPE := FND_API.G_MISS_CHAR

1598: ,p_action_attribute7 IN pa_action_set_lines.action_attribute7%TYPE := FND_API.G_MISS_CHAR
1599: ,p_action_attribute8 IN pa_action_set_lines.action_attribute8%TYPE := FND_API.G_MISS_CHAR
1600: ,p_action_attribute9 IN pa_action_set_lines.action_attribute9%TYPE := FND_API.G_MISS_CHAR
1601: ,p_action_attribute10 IN pa_action_set_lines.action_attribute10%TYPE := FND_API.G_MISS_CHAR
1602: ,p_condition_description IN pa_action_set_line_cond.description%TYPE := FND_API.G_MISS_CHAR
1603: ,p_condition_code IN pa_action_set_line_cond.condition_code%TYPE
1604: ,p_condition_attribute1 IN pa_action_set_line_cond.condition_attribute1%TYPE := FND_API.G_MISS_CHAR
1605: ,p_condition_attribute2 IN pa_action_set_line_cond.condition_attribute2%TYPE := FND_API.G_MISS_CHAR
1606: ,p_condition_attribute3 IN pa_action_set_line_cond.condition_attribute3%TYPE := FND_API.G_MISS_CHAR

Line 1604: ,p_condition_attribute1 IN pa_action_set_line_cond.condition_attribute1%TYPE := FND_API.G_MISS_CHAR

1600: ,p_action_attribute9 IN pa_action_set_lines.action_attribute9%TYPE := FND_API.G_MISS_CHAR
1601: ,p_action_attribute10 IN pa_action_set_lines.action_attribute10%TYPE := FND_API.G_MISS_CHAR
1602: ,p_condition_description IN pa_action_set_line_cond.description%TYPE := FND_API.G_MISS_CHAR
1603: ,p_condition_code IN pa_action_set_line_cond.condition_code%TYPE
1604: ,p_condition_attribute1 IN pa_action_set_line_cond.condition_attribute1%TYPE := FND_API.G_MISS_CHAR
1605: ,p_condition_attribute2 IN pa_action_set_line_cond.condition_attribute2%TYPE := FND_API.G_MISS_CHAR
1606: ,p_condition_attribute3 IN pa_action_set_line_cond.condition_attribute3%TYPE := FND_API.G_MISS_CHAR
1607: ,p_condition_attribute4 IN pa_action_set_line_cond.condition_attribute4%TYPE := FND_API.G_MISS_CHAR
1608: ,p_condition_attribute5 IN pa_action_set_line_cond.condition_attribute5%TYPE := FND_API.G_MISS_CHAR

Line 1605: ,p_condition_attribute2 IN pa_action_set_line_cond.condition_attribute2%TYPE := FND_API.G_MISS_CHAR

1601: ,p_action_attribute10 IN pa_action_set_lines.action_attribute10%TYPE := FND_API.G_MISS_CHAR
1602: ,p_condition_description IN pa_action_set_line_cond.description%TYPE := FND_API.G_MISS_CHAR
1603: ,p_condition_code IN pa_action_set_line_cond.condition_code%TYPE
1604: ,p_condition_attribute1 IN pa_action_set_line_cond.condition_attribute1%TYPE := FND_API.G_MISS_CHAR
1605: ,p_condition_attribute2 IN pa_action_set_line_cond.condition_attribute2%TYPE := FND_API.G_MISS_CHAR
1606: ,p_condition_attribute3 IN pa_action_set_line_cond.condition_attribute3%TYPE := FND_API.G_MISS_CHAR
1607: ,p_condition_attribute4 IN pa_action_set_line_cond.condition_attribute4%TYPE := FND_API.G_MISS_CHAR
1608: ,p_condition_attribute5 IN pa_action_set_line_cond.condition_attribute5%TYPE := FND_API.G_MISS_CHAR
1609: ,p_condition_attribute6 IN pa_action_set_line_cond.condition_attribute6%TYPE := FND_API.G_MISS_CHAR

Line 1606: ,p_condition_attribute3 IN pa_action_set_line_cond.condition_attribute3%TYPE := FND_API.G_MISS_CHAR

1602: ,p_condition_description IN pa_action_set_line_cond.description%TYPE := FND_API.G_MISS_CHAR
1603: ,p_condition_code IN pa_action_set_line_cond.condition_code%TYPE
1604: ,p_condition_attribute1 IN pa_action_set_line_cond.condition_attribute1%TYPE := FND_API.G_MISS_CHAR
1605: ,p_condition_attribute2 IN pa_action_set_line_cond.condition_attribute2%TYPE := FND_API.G_MISS_CHAR
1606: ,p_condition_attribute3 IN pa_action_set_line_cond.condition_attribute3%TYPE := FND_API.G_MISS_CHAR
1607: ,p_condition_attribute4 IN pa_action_set_line_cond.condition_attribute4%TYPE := FND_API.G_MISS_CHAR
1608: ,p_condition_attribute5 IN pa_action_set_line_cond.condition_attribute5%TYPE := FND_API.G_MISS_CHAR
1609: ,p_condition_attribute6 IN pa_action_set_line_cond.condition_attribute6%TYPE := FND_API.G_MISS_CHAR
1610: ,p_condition_attribute7 IN pa_action_set_line_cond.condition_attribute7%TYPE := FND_API.G_MISS_CHAR

Line 1607: ,p_condition_attribute4 IN pa_action_set_line_cond.condition_attribute4%TYPE := FND_API.G_MISS_CHAR

1603: ,p_condition_code IN pa_action_set_line_cond.condition_code%TYPE
1604: ,p_condition_attribute1 IN pa_action_set_line_cond.condition_attribute1%TYPE := FND_API.G_MISS_CHAR
1605: ,p_condition_attribute2 IN pa_action_set_line_cond.condition_attribute2%TYPE := FND_API.G_MISS_CHAR
1606: ,p_condition_attribute3 IN pa_action_set_line_cond.condition_attribute3%TYPE := FND_API.G_MISS_CHAR
1607: ,p_condition_attribute4 IN pa_action_set_line_cond.condition_attribute4%TYPE := FND_API.G_MISS_CHAR
1608: ,p_condition_attribute5 IN pa_action_set_line_cond.condition_attribute5%TYPE := FND_API.G_MISS_CHAR
1609: ,p_condition_attribute6 IN pa_action_set_line_cond.condition_attribute6%TYPE := FND_API.G_MISS_CHAR
1610: ,p_condition_attribute7 IN pa_action_set_line_cond.condition_attribute7%TYPE := FND_API.G_MISS_CHAR
1611: ,p_condition_attribute8 IN pa_action_set_line_cond.condition_attribute8%TYPE := FND_API.G_MISS_CHAR

Line 1608: ,p_condition_attribute5 IN pa_action_set_line_cond.condition_attribute5%TYPE := FND_API.G_MISS_CHAR

1604: ,p_condition_attribute1 IN pa_action_set_line_cond.condition_attribute1%TYPE := FND_API.G_MISS_CHAR
1605: ,p_condition_attribute2 IN pa_action_set_line_cond.condition_attribute2%TYPE := FND_API.G_MISS_CHAR
1606: ,p_condition_attribute3 IN pa_action_set_line_cond.condition_attribute3%TYPE := FND_API.G_MISS_CHAR
1607: ,p_condition_attribute4 IN pa_action_set_line_cond.condition_attribute4%TYPE := FND_API.G_MISS_CHAR
1608: ,p_condition_attribute5 IN pa_action_set_line_cond.condition_attribute5%TYPE := FND_API.G_MISS_CHAR
1609: ,p_condition_attribute6 IN pa_action_set_line_cond.condition_attribute6%TYPE := FND_API.G_MISS_CHAR
1610: ,p_condition_attribute7 IN pa_action_set_line_cond.condition_attribute7%TYPE := FND_API.G_MISS_CHAR
1611: ,p_condition_attribute8 IN pa_action_set_line_cond.condition_attribute8%TYPE := FND_API.G_MISS_CHAR
1612: ,p_condition_attribute9 IN pa_action_set_line_cond.condition_attribute9%TYPE := FND_API.G_MISS_CHAR

Line 1609: ,p_condition_attribute6 IN pa_action_set_line_cond.condition_attribute6%TYPE := FND_API.G_MISS_CHAR

1605: ,p_condition_attribute2 IN pa_action_set_line_cond.condition_attribute2%TYPE := FND_API.G_MISS_CHAR
1606: ,p_condition_attribute3 IN pa_action_set_line_cond.condition_attribute3%TYPE := FND_API.G_MISS_CHAR
1607: ,p_condition_attribute4 IN pa_action_set_line_cond.condition_attribute4%TYPE := FND_API.G_MISS_CHAR
1608: ,p_condition_attribute5 IN pa_action_set_line_cond.condition_attribute5%TYPE := FND_API.G_MISS_CHAR
1609: ,p_condition_attribute6 IN pa_action_set_line_cond.condition_attribute6%TYPE := FND_API.G_MISS_CHAR
1610: ,p_condition_attribute7 IN pa_action_set_line_cond.condition_attribute7%TYPE := FND_API.G_MISS_CHAR
1611: ,p_condition_attribute8 IN pa_action_set_line_cond.condition_attribute8%TYPE := FND_API.G_MISS_CHAR
1612: ,p_condition_attribute9 IN pa_action_set_line_cond.condition_attribute9%TYPE := FND_API.G_MISS_CHAR
1613: ,p_condition_attribute10 IN pa_action_set_line_cond.condition_attribute10%TYPE := FND_API.G_MISS_CHAR

Line 1610: ,p_condition_attribute7 IN pa_action_set_line_cond.condition_attribute7%TYPE := FND_API.G_MISS_CHAR

1606: ,p_condition_attribute3 IN pa_action_set_line_cond.condition_attribute3%TYPE := FND_API.G_MISS_CHAR
1607: ,p_condition_attribute4 IN pa_action_set_line_cond.condition_attribute4%TYPE := FND_API.G_MISS_CHAR
1608: ,p_condition_attribute5 IN pa_action_set_line_cond.condition_attribute5%TYPE := FND_API.G_MISS_CHAR
1609: ,p_condition_attribute6 IN pa_action_set_line_cond.condition_attribute6%TYPE := FND_API.G_MISS_CHAR
1610: ,p_condition_attribute7 IN pa_action_set_line_cond.condition_attribute7%TYPE := FND_API.G_MISS_CHAR
1611: ,p_condition_attribute8 IN pa_action_set_line_cond.condition_attribute8%TYPE := FND_API.G_MISS_CHAR
1612: ,p_condition_attribute9 IN pa_action_set_line_cond.condition_attribute9%TYPE := FND_API.G_MISS_CHAR
1613: ,p_condition_attribute10 IN pa_action_set_line_cond.condition_attribute10%TYPE := FND_API.G_MISS_CHAR
1614: ,p_api_version IN NUMBER := 1.0

Line 1611: ,p_condition_attribute8 IN pa_action_set_line_cond.condition_attribute8%TYPE := FND_API.G_MISS_CHAR

1607: ,p_condition_attribute4 IN pa_action_set_line_cond.condition_attribute4%TYPE := FND_API.G_MISS_CHAR
1608: ,p_condition_attribute5 IN pa_action_set_line_cond.condition_attribute5%TYPE := FND_API.G_MISS_CHAR
1609: ,p_condition_attribute6 IN pa_action_set_line_cond.condition_attribute6%TYPE := FND_API.G_MISS_CHAR
1610: ,p_condition_attribute7 IN pa_action_set_line_cond.condition_attribute7%TYPE := FND_API.G_MISS_CHAR
1611: ,p_condition_attribute8 IN pa_action_set_line_cond.condition_attribute8%TYPE := FND_API.G_MISS_CHAR
1612: ,p_condition_attribute9 IN pa_action_set_line_cond.condition_attribute9%TYPE := FND_API.G_MISS_CHAR
1613: ,p_condition_attribute10 IN pa_action_set_line_cond.condition_attribute10%TYPE := FND_API.G_MISS_CHAR
1614: ,p_api_version IN NUMBER := 1.0
1615: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE

Line 1612: ,p_condition_attribute9 IN pa_action_set_line_cond.condition_attribute9%TYPE := FND_API.G_MISS_CHAR

1608: ,p_condition_attribute5 IN pa_action_set_line_cond.condition_attribute5%TYPE := FND_API.G_MISS_CHAR
1609: ,p_condition_attribute6 IN pa_action_set_line_cond.condition_attribute6%TYPE := FND_API.G_MISS_CHAR
1610: ,p_condition_attribute7 IN pa_action_set_line_cond.condition_attribute7%TYPE := FND_API.G_MISS_CHAR
1611: ,p_condition_attribute8 IN pa_action_set_line_cond.condition_attribute8%TYPE := FND_API.G_MISS_CHAR
1612: ,p_condition_attribute9 IN pa_action_set_line_cond.condition_attribute9%TYPE := FND_API.G_MISS_CHAR
1613: ,p_condition_attribute10 IN pa_action_set_line_cond.condition_attribute10%TYPE := FND_API.G_MISS_CHAR
1614: ,p_api_version IN NUMBER := 1.0
1615: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
1616: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

Line 1613: ,p_condition_attribute10 IN pa_action_set_line_cond.condition_attribute10%TYPE := FND_API.G_MISS_CHAR

1609: ,p_condition_attribute6 IN pa_action_set_line_cond.condition_attribute6%TYPE := FND_API.G_MISS_CHAR
1610: ,p_condition_attribute7 IN pa_action_set_line_cond.condition_attribute7%TYPE := FND_API.G_MISS_CHAR
1611: ,p_condition_attribute8 IN pa_action_set_line_cond.condition_attribute8%TYPE := FND_API.G_MISS_CHAR
1612: ,p_condition_attribute9 IN pa_action_set_line_cond.condition_attribute9%TYPE := FND_API.G_MISS_CHAR
1613: ,p_condition_attribute10 IN pa_action_set_line_cond.condition_attribute10%TYPE := FND_API.G_MISS_CHAR
1614: ,p_api_version IN NUMBER := 1.0
1615: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
1616: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
1617: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE

Line 1615: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE

1611: ,p_condition_attribute8 IN pa_action_set_line_cond.condition_attribute8%TYPE := FND_API.G_MISS_CHAR
1612: ,p_condition_attribute9 IN pa_action_set_line_cond.condition_attribute9%TYPE := FND_API.G_MISS_CHAR
1613: ,p_condition_attribute10 IN pa_action_set_line_cond.condition_attribute10%TYPE := FND_API.G_MISS_CHAR
1614: ,p_api_version IN NUMBER := 1.0
1615: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
1616: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
1617: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
1618: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1619: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 1616: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

1612: ,p_condition_attribute9 IN pa_action_set_line_cond.condition_attribute9%TYPE := FND_API.G_MISS_CHAR
1613: ,p_condition_attribute10 IN pa_action_set_line_cond.condition_attribute10%TYPE := FND_API.G_MISS_CHAR
1614: ,p_api_version IN NUMBER := 1.0
1615: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
1616: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
1617: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
1618: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1619: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
1620: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 1617: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE

1613: ,p_condition_attribute10 IN pa_action_set_line_cond.condition_attribute10%TYPE := FND_API.G_MISS_CHAR
1614: ,p_api_version IN NUMBER := 1.0
1615: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
1616: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
1617: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
1618: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1619: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
1620: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1621: )

Line 1634: x_return_status := FND_API.G_RET_STS_SUCCESS;

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:
1636: l_condition_tbl(1).condition_code := p_condition_code;
1637: l_condition_tbl(1).description := p_condition_description;
1638: l_condition_tbl(1).condition_attribute1 := p_condition_attribute1;

Line 1680: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

1676: -- 2452316: Need to set MOD_SOURCE_ACTION_SET_FLAG = 'Y' when updating a line
1677: -- from self-service page. Should not put this logic in
1678: -- PA_ACTION_SET_PVT.update_action_set_line because that could be called when
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

Line 1701: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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;
1703:
1704: END;
1705:

Line 1721: x_return_status := FND_API.G_RET_STS_SUCCESS;

1717:
1718: BEGIN
1719:
1720: -- Initialize the return status to success
1721: x_return_status := FND_API.G_RET_STS_SUCCESS;
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

Line 1736: pa_interface_utils_pub.get_messages ( p_encoded => FND_API.G_TRUE

1732: x_return_status => l_return_status);
1733:
1734: x_msg_count := FND_MSG_PUB.Count_Msg;
1735: IF x_msg_count = 1 THEN
1736: pa_interface_utils_pub.get_messages ( p_encoded => FND_API.G_TRUE
1737: ,p_msg_index => 1
1738: ,p_data => x_msg_data
1739: ,p_msg_index_out => l_msg_index_out
1740: );

Line 1748: x_return_status := FND_API.G_RET_STS_ERROR;

1744: PA_DEBUG.Reset_Err_Stack;
1745: -- If any errors exist then set the x_return_status to 'E'
1746:
1747: IF x_msg_count > 0 THEN
1748: x_return_status := FND_API.G_RET_STS_ERROR;
1749: END IF;
1750:
1751: EXCEPTION
1752: WHEN OTHERS THEN

Line 1757: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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: