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

APPS.PA_ACTION_SETS_PVT dependencies on FND_API

Line 47: x_return_status := FND_API.G_RET_STS_SUCCESS;

43:
44: BEGIN
45:
46: -- Initialize the return status to success
47: x_return_status := FND_API.G_RET_STS_SUCCESS;
48:
49: --Bug 4403338
50: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
51:

Line 170: x_return_status := FND_API.G_RET_STS_ERROR;

166: ,x_log_level => 5);
167: END IF;
168:
169: IF FND_MSG_PUB.Count_Msg > 0 THEN
170: x_return_status := FND_API.G_RET_STS_ERROR;
171: END IF;
172:
173: EXCEPTION
174: WHEN OTHERS THEN

Line 180: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

176: -- Set the excetption Message and the stack
177: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_ACTION_SETS_PVT.Create_Action_Set'
178: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
179: --
180: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
181: RAISE;
182:
183: END Create_Action_Set;
184:

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 223: l_actual_start_date DATE := FND_API.G_MISS_DATE;

219: l_existing_action_set_id NUMBER;
220: l_previous_status pa_action_sets.status_code%TYPE;
221: l_status_code pa_action_sets.status_code%TYPE;
222: l_unique VARCHAR2(1);
223: l_actual_start_date DATE := FND_API.G_MISS_DATE;
224: l_action_set_type_code pa_action_set_types.action_set_type_code%TYPE;
225: l_action_set_template_flag VARCHAR2(1);
226: l_msg_count NUMBER;
227: l_msg_data VARCHAR2(2000);

Line 233: x_return_status := FND_API.G_RET_STS_SUCCESS;

229:
230: BEGIN
231:
232: -- Initialize the return status to success
233: x_return_status := FND_API.G_RET_STS_SUCCESS;
234:
235: --Log Message: 4403338
236: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
237:

Line 335: p_init_msg_list => FND_API.G_FALSE,

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

Line 347: x_return_status := FND_API.G_RET_STS_ERROR;

343:
344: END IF;
345:
346: IF FND_MSG_PUB.Count_Msg > 0 THEN
347: x_return_status := FND_API.G_RET_STS_ERROR;
348: END IF;
349:
350: EXCEPTION
351: WHEN OTHERS THEN

Line 357: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

353: -- Set the excetption Message and the stack
354: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_ACTION_SETS_PVT.Update_Action_Set'
355: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
356: --
357: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
358: RAISE;
359:
360: END Update_Action_Set;
361:

Line 384: x_return_status := FND_API.G_RET_STS_SUCCESS;

380: BEGIN
381:
382:
383: -- Initialize the return status to success
384: x_return_status := FND_API.G_RET_STS_SUCCESS;
385:
386: --Log Message: 4403338
387: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
388:

Line 445: ,p_init_msg_list => FND_API.G_FALSE

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

Line 463: x_return_status := FND_API.G_RET_STS_ERROR;

459:
460: END IF;
461:
462: IF FND_MSG_PUB.Count_Msg > 0 THEN
463: x_return_status := FND_API.G_RET_STS_ERROR;
464: END IF;
465:
466: EXCEPTION
467: WHEN OTHERS THEN

Line 473: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

469: -- Set the excetption Message and the stack
470: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_ACTION_SETS_PVT.Delete_Action_Set'
471: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
472: --
473: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
474: RAISE;
475:
476: END Delete_Action_Set;
477:

Line 515: x_return_status := FND_API.G_RET_STS_SUCCESS;

511:
512: BEGIN
513:
514: -- Initialize the return status to success
515: x_return_status := FND_API.G_RET_STS_SUCCESS;
516:
517: --Log Message: 4403338
518: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
519:

Line 620: x_return_status := FND_API.G_RET_STS_ERROR;

616: END IF;
617:
618: -- If any errors exist then set the x_return_status to 'E'
619: IF FND_MSG_PUB.Count_Msg > 0 THEN
620: x_return_status := FND_API.G_RET_STS_ERROR;
621: END IF;
622:
623:
624: EXCEPTION

Line 631: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

627: -- Set the excetption Message and the stack
628: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_ACTION_SETS_PVT.Create_Action_Set_Line'
629: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
630: --
631: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
632: RAISE;
633:
634: END Create_Action_Set_Line;
635:

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

636:
637: PROCEDURE update_action_set_line
638: (p_action_set_line_id IN pa_action_set_lines.action_set_line_id%TYPE
639: ,p_record_version_number IN pa_action_set_lines.record_version_number%TYPE
640: ,p_action_set_line_number IN pa_action_set_lines.action_set_line_number%TYPE := FND_API.G_MISS_NUM
641: ,p_description IN pa_action_set_lines.description%TYPE := FND_API.G_MISS_CHAR
642: ,p_action_code IN pa_action_set_lines.action_code%TYPE := FND_API.G_MISS_CHAR
643: ,p_action_attribute1 IN pa_action_set_lines.action_attribute1%TYPE := FND_API.G_MISS_CHAR
644: ,p_action_attribute2 IN pa_action_set_lines.action_attribute2%TYPE := FND_API.G_MISS_CHAR

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

637: PROCEDURE update_action_set_line
638: (p_action_set_line_id IN pa_action_set_lines.action_set_line_id%TYPE
639: ,p_record_version_number IN pa_action_set_lines.record_version_number%TYPE
640: ,p_action_set_line_number IN pa_action_set_lines.action_set_line_number%TYPE := FND_API.G_MISS_NUM
641: ,p_description IN pa_action_set_lines.description%TYPE := FND_API.G_MISS_CHAR
642: ,p_action_code IN pa_action_set_lines.action_code%TYPE := FND_API.G_MISS_CHAR
643: ,p_action_attribute1 IN pa_action_set_lines.action_attribute1%TYPE := FND_API.G_MISS_CHAR
644: ,p_action_attribute2 IN pa_action_set_lines.action_attribute2%TYPE := FND_API.G_MISS_CHAR
645: ,p_action_attribute3 IN pa_action_set_lines.action_attribute3%TYPE := FND_API.G_MISS_CHAR

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

638: (p_action_set_line_id IN pa_action_set_lines.action_set_line_id%TYPE
639: ,p_record_version_number IN pa_action_set_lines.record_version_number%TYPE
640: ,p_action_set_line_number IN pa_action_set_lines.action_set_line_number%TYPE := FND_API.G_MISS_NUM
641: ,p_description IN pa_action_set_lines.description%TYPE := FND_API.G_MISS_CHAR
642: ,p_action_code IN pa_action_set_lines.action_code%TYPE := FND_API.G_MISS_CHAR
643: ,p_action_attribute1 IN pa_action_set_lines.action_attribute1%TYPE := FND_API.G_MISS_CHAR
644: ,p_action_attribute2 IN pa_action_set_lines.action_attribute2%TYPE := FND_API.G_MISS_CHAR
645: ,p_action_attribute3 IN pa_action_set_lines.action_attribute3%TYPE := FND_API.G_MISS_CHAR
646: ,p_action_attribute4 IN pa_action_set_lines.action_attribute4%TYPE := FND_API.G_MISS_CHAR

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

639: ,p_record_version_number IN pa_action_set_lines.record_version_number%TYPE
640: ,p_action_set_line_number IN pa_action_set_lines.action_set_line_number%TYPE := FND_API.G_MISS_NUM
641: ,p_description IN pa_action_set_lines.description%TYPE := FND_API.G_MISS_CHAR
642: ,p_action_code IN pa_action_set_lines.action_code%TYPE := FND_API.G_MISS_CHAR
643: ,p_action_attribute1 IN pa_action_set_lines.action_attribute1%TYPE := FND_API.G_MISS_CHAR
644: ,p_action_attribute2 IN pa_action_set_lines.action_attribute2%TYPE := FND_API.G_MISS_CHAR
645: ,p_action_attribute3 IN pa_action_set_lines.action_attribute3%TYPE := FND_API.G_MISS_CHAR
646: ,p_action_attribute4 IN pa_action_set_lines.action_attribute4%TYPE := FND_API.G_MISS_CHAR
647: ,p_action_attribute5 IN pa_action_set_lines.action_attribute5%TYPE := FND_API.G_MISS_CHAR

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

640: ,p_action_set_line_number IN pa_action_set_lines.action_set_line_number%TYPE := FND_API.G_MISS_NUM
641: ,p_description IN pa_action_set_lines.description%TYPE := FND_API.G_MISS_CHAR
642: ,p_action_code IN pa_action_set_lines.action_code%TYPE := FND_API.G_MISS_CHAR
643: ,p_action_attribute1 IN pa_action_set_lines.action_attribute1%TYPE := FND_API.G_MISS_CHAR
644: ,p_action_attribute2 IN pa_action_set_lines.action_attribute2%TYPE := FND_API.G_MISS_CHAR
645: ,p_action_attribute3 IN pa_action_set_lines.action_attribute3%TYPE := FND_API.G_MISS_CHAR
646: ,p_action_attribute4 IN pa_action_set_lines.action_attribute4%TYPE := FND_API.G_MISS_CHAR
647: ,p_action_attribute5 IN pa_action_set_lines.action_attribute5%TYPE := FND_API.G_MISS_CHAR
648: ,p_action_attribute6 IN pa_action_set_lines.action_attribute6%TYPE := FND_API.G_MISS_CHAR

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

641: ,p_description IN pa_action_set_lines.description%TYPE := FND_API.G_MISS_CHAR
642: ,p_action_code IN pa_action_set_lines.action_code%TYPE := FND_API.G_MISS_CHAR
643: ,p_action_attribute1 IN pa_action_set_lines.action_attribute1%TYPE := FND_API.G_MISS_CHAR
644: ,p_action_attribute2 IN pa_action_set_lines.action_attribute2%TYPE := FND_API.G_MISS_CHAR
645: ,p_action_attribute3 IN pa_action_set_lines.action_attribute3%TYPE := FND_API.G_MISS_CHAR
646: ,p_action_attribute4 IN pa_action_set_lines.action_attribute4%TYPE := FND_API.G_MISS_CHAR
647: ,p_action_attribute5 IN pa_action_set_lines.action_attribute5%TYPE := FND_API.G_MISS_CHAR
648: ,p_action_attribute6 IN pa_action_set_lines.action_attribute6%TYPE := FND_API.G_MISS_CHAR
649: ,p_action_attribute7 IN pa_action_set_lines.action_attribute7%TYPE := FND_API.G_MISS_CHAR

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

642: ,p_action_code IN pa_action_set_lines.action_code%TYPE := FND_API.G_MISS_CHAR
643: ,p_action_attribute1 IN pa_action_set_lines.action_attribute1%TYPE := FND_API.G_MISS_CHAR
644: ,p_action_attribute2 IN pa_action_set_lines.action_attribute2%TYPE := FND_API.G_MISS_CHAR
645: ,p_action_attribute3 IN pa_action_set_lines.action_attribute3%TYPE := FND_API.G_MISS_CHAR
646: ,p_action_attribute4 IN pa_action_set_lines.action_attribute4%TYPE := FND_API.G_MISS_CHAR
647: ,p_action_attribute5 IN pa_action_set_lines.action_attribute5%TYPE := FND_API.G_MISS_CHAR
648: ,p_action_attribute6 IN pa_action_set_lines.action_attribute6%TYPE := FND_API.G_MISS_CHAR
649: ,p_action_attribute7 IN pa_action_set_lines.action_attribute7%TYPE := FND_API.G_MISS_CHAR
650: ,p_action_attribute8 IN pa_action_set_lines.action_attribute8%TYPE := FND_API.G_MISS_CHAR

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

643: ,p_action_attribute1 IN pa_action_set_lines.action_attribute1%TYPE := FND_API.G_MISS_CHAR
644: ,p_action_attribute2 IN pa_action_set_lines.action_attribute2%TYPE := FND_API.G_MISS_CHAR
645: ,p_action_attribute3 IN pa_action_set_lines.action_attribute3%TYPE := FND_API.G_MISS_CHAR
646: ,p_action_attribute4 IN pa_action_set_lines.action_attribute4%TYPE := FND_API.G_MISS_CHAR
647: ,p_action_attribute5 IN pa_action_set_lines.action_attribute5%TYPE := FND_API.G_MISS_CHAR
648: ,p_action_attribute6 IN pa_action_set_lines.action_attribute6%TYPE := FND_API.G_MISS_CHAR
649: ,p_action_attribute7 IN pa_action_set_lines.action_attribute7%TYPE := FND_API.G_MISS_CHAR
650: ,p_action_attribute8 IN pa_action_set_lines.action_attribute8%TYPE := FND_API.G_MISS_CHAR
651: ,p_action_attribute9 IN pa_action_set_lines.action_attribute9%TYPE := FND_API.G_MISS_CHAR

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

644: ,p_action_attribute2 IN pa_action_set_lines.action_attribute2%TYPE := FND_API.G_MISS_CHAR
645: ,p_action_attribute3 IN pa_action_set_lines.action_attribute3%TYPE := FND_API.G_MISS_CHAR
646: ,p_action_attribute4 IN pa_action_set_lines.action_attribute4%TYPE := FND_API.G_MISS_CHAR
647: ,p_action_attribute5 IN pa_action_set_lines.action_attribute5%TYPE := FND_API.G_MISS_CHAR
648: ,p_action_attribute6 IN pa_action_set_lines.action_attribute6%TYPE := FND_API.G_MISS_CHAR
649: ,p_action_attribute7 IN pa_action_set_lines.action_attribute7%TYPE := FND_API.G_MISS_CHAR
650: ,p_action_attribute8 IN pa_action_set_lines.action_attribute8%TYPE := FND_API.G_MISS_CHAR
651: ,p_action_attribute9 IN pa_action_set_lines.action_attribute9%TYPE := FND_API.G_MISS_CHAR
652: ,p_action_attribute10 IN pa_action_set_lines.action_attribute10%TYPE := FND_API.G_MISS_CHAR

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

645: ,p_action_attribute3 IN pa_action_set_lines.action_attribute3%TYPE := FND_API.G_MISS_CHAR
646: ,p_action_attribute4 IN pa_action_set_lines.action_attribute4%TYPE := FND_API.G_MISS_CHAR
647: ,p_action_attribute5 IN pa_action_set_lines.action_attribute5%TYPE := FND_API.G_MISS_CHAR
648: ,p_action_attribute6 IN pa_action_set_lines.action_attribute6%TYPE := FND_API.G_MISS_CHAR
649: ,p_action_attribute7 IN pa_action_set_lines.action_attribute7%TYPE := FND_API.G_MISS_CHAR
650: ,p_action_attribute8 IN pa_action_set_lines.action_attribute8%TYPE := FND_API.G_MISS_CHAR
651: ,p_action_attribute9 IN pa_action_set_lines.action_attribute9%TYPE := FND_API.G_MISS_CHAR
652: ,p_action_attribute10 IN pa_action_set_lines.action_attribute10%TYPE := FND_API.G_MISS_CHAR
653: ,p_condition_tbl IN pa_action_set_utils.action_line_cond_tbl_type := pa_action_set_utils.l_empty_condition_tbl

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

646: ,p_action_attribute4 IN pa_action_set_lines.action_attribute4%TYPE := FND_API.G_MISS_CHAR
647: ,p_action_attribute5 IN pa_action_set_lines.action_attribute5%TYPE := FND_API.G_MISS_CHAR
648: ,p_action_attribute6 IN pa_action_set_lines.action_attribute6%TYPE := FND_API.G_MISS_CHAR
649: ,p_action_attribute7 IN pa_action_set_lines.action_attribute7%TYPE := FND_API.G_MISS_CHAR
650: ,p_action_attribute8 IN pa_action_set_lines.action_attribute8%TYPE := FND_API.G_MISS_CHAR
651: ,p_action_attribute9 IN pa_action_set_lines.action_attribute9%TYPE := FND_API.G_MISS_CHAR
652: ,p_action_attribute10 IN pa_action_set_lines.action_attribute10%TYPE := FND_API.G_MISS_CHAR
653: ,p_condition_tbl IN pa_action_set_utils.action_line_cond_tbl_type := pa_action_set_utils.l_empty_condition_tbl
654: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

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

647: ,p_action_attribute5 IN pa_action_set_lines.action_attribute5%TYPE := FND_API.G_MISS_CHAR
648: ,p_action_attribute6 IN pa_action_set_lines.action_attribute6%TYPE := FND_API.G_MISS_CHAR
649: ,p_action_attribute7 IN pa_action_set_lines.action_attribute7%TYPE := FND_API.G_MISS_CHAR
650: ,p_action_attribute8 IN pa_action_set_lines.action_attribute8%TYPE := FND_API.G_MISS_CHAR
651: ,p_action_attribute9 IN pa_action_set_lines.action_attribute9%TYPE := FND_API.G_MISS_CHAR
652: ,p_action_attribute10 IN pa_action_set_lines.action_attribute10%TYPE := FND_API.G_MISS_CHAR
653: ,p_condition_tbl IN pa_action_set_utils.action_line_cond_tbl_type := pa_action_set_utils.l_empty_condition_tbl
654: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
655: )

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

648: ,p_action_attribute6 IN pa_action_set_lines.action_attribute6%TYPE := FND_API.G_MISS_CHAR
649: ,p_action_attribute7 IN pa_action_set_lines.action_attribute7%TYPE := FND_API.G_MISS_CHAR
650: ,p_action_attribute8 IN pa_action_set_lines.action_attribute8%TYPE := FND_API.G_MISS_CHAR
651: ,p_action_attribute9 IN pa_action_set_lines.action_attribute9%TYPE := FND_API.G_MISS_CHAR
652: ,p_action_attribute10 IN pa_action_set_lines.action_attribute10%TYPE := FND_API.G_MISS_CHAR
653: ,p_condition_tbl IN pa_action_set_utils.action_line_cond_tbl_type := pa_action_set_utils.l_empty_condition_tbl
654: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
655: )
656: IS

Line 670: x_return_status := FND_API.G_RET_STS_SUCCESS;

666:
667: BEGIN
668:
669: -- Initialize the return status to success
670: x_return_status := FND_API.G_RET_STS_SUCCESS;
671:
672: --Log Message: 4403338
673: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
674:

Line 769: x_return_status := FND_API.G_RET_STS_ERROR;

765: END IF;
766:
767: -- If any errors exist then set the x_return_status to 'E'
768: IF FND_MSG_PUB.Count_Msg > 0 THEN
769: x_return_status := FND_API.G_RET_STS_ERROR;
770: END IF;
771:
772: EXCEPTION
773: WHEN OTHERS THEN

Line 779: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

775: -- Set the excetption Message and the stack
776: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_ACTION_SETS_PVT.Update_Action_Set_Line'
777: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
778: --
779: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
780: RAISE;
781:
782: END Update_Action_Set_Line;
783:

Line 804: x_return_status := FND_API.G_RET_STS_SUCCESS;

800:
801: BEGIN
802:
803: -- Initialize the return status to success
804: x_return_status := FND_API.G_RET_STS_SUCCESS;
805:
806: --Log Message: 4403338
807: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
808:

Line 923: x_return_status := FND_API.G_RET_STS_ERROR;

919:
920: END IF;
921:
922: IF FND_MSG_PUB.Count_Msg > 0 THEN
923: x_return_status := FND_API.G_RET_STS_ERROR;
924: END IF;
925:
926: EXCEPTION
927: WHEN OTHERS THEN

Line 933: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

929: -- Set the excetption Message and the stack
930: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_ACTION_SETS_PVT.Delete_Action_Set_Line'
931: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
932: --
933: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
934: RAISE;
935:
936: END Delete_Action_Set_Line;
937:

Line 1093: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1089: -- Set the excetption Message and the stack
1090: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_ACTION_SETS_PVT.bulk_insert_audit_lines'
1091: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
1092: --
1093: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1094: RAISE;
1095:
1096:
1097: END;

Line 1137: x_return_status := FND_API.G_RET_STS_ERROR;

1133: EXCEPTION
1134: WHEN e_row_is_locked THEN
1135: PA_UTILS.Add_Message ( p_app_short_name => 'PA'
1136: ,p_msg_name => 'PA_ACTION_LINE_CHANGE_PENDING');
1137: x_return_status := FND_API.G_RET_STS_ERROR;
1138: WHEN OTHERS THEN
1139:
1140: -- Set the excetption Message and the stack
1141: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_ACTION_SETS_PVT.bulk_update_line_number'

Line 1144: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1140: -- Set the excetption Message and the stack
1141: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_ACTION_SETS_PVT.bulk_update_line_number'
1142: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
1143: --
1144: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1145: RAISE;
1146:
1147: END;
1148:

Line 1186: x_return_status := FND_API.G_RET_STS_ERROR;

1182: EXCEPTION
1183: WHEN e_row_is_locked THEN
1184: PA_UTILS.Add_Message ( p_app_short_name => 'PA'
1185: ,p_msg_name => 'PA_ACTION_LINE_CHANGE_PENDING');
1186: x_return_status := FND_API.G_RET_STS_ERROR;
1187:
1188: WHEN OTHERS THEN
1189: -- Set the excetption Message and the stack
1190: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_ACTION_SETS_PVT.bulk_update_condition_date'

Line 1193: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1189: -- Set the excetption Message and the stack
1190: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_ACTION_SETS_PVT.bulk_update_condition_date'
1191: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
1192: --
1193: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1194: RAISE;
1195:
1196: END;
1197:

Line 1235: x_return_status := FND_API.G_RET_STS_ERROR;

1231: EXCEPTION
1232: WHEN e_row_is_locked THEN
1233: PA_UTILS.Add_Message ( p_app_short_name => 'PA'
1234: ,p_msg_name => 'PA_ACTION_LINE_CHANGE_PENDING');
1235: x_return_status := FND_API.G_RET_STS_ERROR;
1236: WHEN OTHERS THEN
1237: -- Set the excetption Message and the stack
1238: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_ACTION_SETS_PVT.bulk_update_line_status'
1239: ,p_procedure_name => PA_DEBUG.G_Err_Stack );

Line 1241: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1237: -- Set the excetption Message and the stack
1238: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_ACTION_SETS_PVT.bulk_update_line_status'
1239: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
1240: --
1241: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1242: RAISE;
1243:
1244: END;
1245:

Line 1273: x_return_status := FND_API.G_RET_STS_SUCCESS;

1269:
1270: BEGIN
1271:
1272: -- Initialize the return status to success
1273: x_return_status := FND_API.G_RET_STS_SUCCESS;
1274:
1275: --Log Message: 4403338
1276: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
1277:

Line 1362: l_line_deleted_flag := FND_API.G_MISS_CHAR;

1358: HOW SHOULD THIS BE HANDLED???
1359: IF l_new_line_status_code = 'REVERSED' AND FND_MSG_PUB.Count_Msg > 0 THEN
1360: l_line_deleted_flag := 'N';
1361: ELSE
1362: l_line_deleted_flag := FND_API.G_MISS_CHAR;
1363: END IF;
1364: */
1365:
1366:

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

1387:
1388: --only do if line not performed from concurrent program
1389: IF FND_MSG_PUB.Count_Msg > 0 AND FND_GLOBAL.CONC_REQUEST_ID = -1 THEN
1390: FOR i IN 1 .. FND_MSG_PUB.Count_Msg LOOP
1391: pa_interface_utils_pub.get_messages ( p_encoded => FND_API.G_TRUE
1392: ,p_msg_index => i
1393: ,p_data => l_msg_data
1394: ,p_msg_index_out => l_msg_index_out
1395: );

Line 1417: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1413: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_ACTION_SETS_PVT.Perform_Action_Set_Line'
1414: ,p_procedure_name => PA_DEBUG.G_Err_Stack
1415: ,p_error_text => 'INVALID RESULT CODE: '||l_action_line_result_code);
1416: --
1417: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1418: RAISE e_invalid_result_code;
1419:
1420: WHEN OTHERS THEN
1421: -- Set the excetption Message and the stack

Line 1425: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1421: -- Set the excetption Message and the stack
1422: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_ACTION_SETS_PVT.Perform_Action_Set_Line'
1423: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
1424: --
1425: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1426: RAISE;
1427:
1428: END Perform_Action_Set_Line;
1429: