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_LIFECYCLES_PUB dependencies on FND_API

Line 10: P_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,

6: +-----------------------------------------------------------*/
7:
8: PROCEDURE create_lifecycle (
9: P_api_version IN NUMBER := 1.0 ,
10: P_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
11: P_commit IN VARCHAR2 := FND_API.G_FALSE ,
12: P_validate_only IN VARCHAR2 := FND_API.G_TRUE ,
13: P_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
14: P_calling_module IN VARCHAR2 := 'SELF-SERVICE' ,

Line 11: P_commit IN VARCHAR2 := FND_API.G_FALSE ,

7:
8: PROCEDURE create_lifecycle (
9: P_api_version IN NUMBER := 1.0 ,
10: P_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
11: P_commit IN VARCHAR2 := FND_API.G_FALSE ,
12: P_validate_only IN VARCHAR2 := FND_API.G_TRUE ,
13: P_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
14: P_calling_module IN VARCHAR2 := 'SELF-SERVICE' ,
15: P_debug_mode IN VARCHAR2 := 'N' ,

Line 12: P_validate_only IN VARCHAR2 := FND_API.G_TRUE ,

8: PROCEDURE create_lifecycle (
9: P_api_version IN NUMBER := 1.0 ,
10: P_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
11: P_commit IN VARCHAR2 := FND_API.G_FALSE ,
12: P_validate_only IN VARCHAR2 := FND_API.G_TRUE ,
13: P_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
14: P_calling_module IN VARCHAR2 := 'SELF-SERVICE' ,
15: P_debug_mode IN VARCHAR2 := 'N' ,
16: P_max_msg_count IN NUMBER := G_MISS_NUM ,

Line 13: P_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,

9: P_api_version IN NUMBER := 1.0 ,
10: P_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
11: P_commit IN VARCHAR2 := FND_API.G_FALSE ,
12: P_validate_only IN VARCHAR2 := FND_API.G_TRUE ,
13: P_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
14: P_calling_module IN VARCHAR2 := 'SELF-SERVICE' ,
15: P_debug_mode IN VARCHAR2 := 'N' ,
16: P_max_msg_count IN NUMBER := G_MISS_NUM ,
17: P_lifecycle_short_name IN VARCHAR2 ,

Line 47: IF (p_commit = FND_API.G_TRUE) then

43: IF(p_debug_mode = 'Y') then
44: pa_debug.debug('PA_LIFECYCLES_PUB.create_lifecycle : Entered create_lifecycle...');
45: END IF;
46:
47: IF (p_commit = FND_API.G_TRUE) then
48: SAVEPOINT LCYL_CREATE_LIFECYCLE_PUB;
49: END IF;
50:
51:

Line 52: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version,

48: SAVEPOINT LCYL_CREATE_LIFECYCLE_PUB;
49: END IF;
50:
51:
52: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version,
53: p_api_version,
54: l_api_name,
55: g_pkg_name)
56: THEN

Line 57: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

53: p_api_version,
54: l_api_name,
55: g_pkg_name)
56: THEN
57: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
58: END IF;
59:
60: x_return_status := FND_API.G_RET_STS_SUCCESS;
61:

Line 60: x_return_status := FND_API.G_RET_STS_SUCCESS;

56: THEN
57: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
58: END IF;
59:
60: x_return_status := FND_API.G_RET_STS_SUCCESS;
61:
62: -- Initialise message stack
63:
64: IF( p_debug_mode = 'Y') THEN

Line 70: IF FND_API.to_boolean(nvl(p_init_msg_list, FND_API.G_FALSE)) THEN

66: END IF;
67:
68: pa_debug.init_err_stack('PA_LIFECYCLES_PUB.CREATE_LIFECYCLE');
69:
70: IF FND_API.to_boolean(nvl(p_init_msg_list, FND_API.G_FALSE)) THEN
71: fnd_msg_pub.initialize;
72: END IF;
73:
74: IF(p_debug_mode = 'Y') THEN

Line 87: x_return_status := FND_API.G_RET_STS_ERROR;

83: THEN
84: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
85: p_msg_name => 'PA_LCYL_NAME_REQUIRED');
86: x_msg_data := 'PA_LCYL_NAME_REQUIRED';
87: x_return_status := FND_API.G_RET_STS_ERROR;
88: END IF;
89:
90: IF (P_lifecycle_short_name is NULL)
91: THEN

Line 95: x_return_status := FND_API.G_RET_STS_ERROR;

91: THEN
92: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
93: p_msg_name => 'PA_LCYL_SHORT_NAME_REQUIRED');
94: x_msg_data := 'PA_LCYL_SHORT_NAME_REQUIRED';
95: x_return_status := FND_API.G_RET_STS_ERROR;
96: END IF;
97:
98:
99: IF (P_lifecycle_project_usage_type is NULL) then

Line 124: x_return_status := FND_API.G_RET_STS_ERROR;

120: THEN
121: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
122: p_msg_name => 'PA_LCYL_USAGE_REQUIRED');
123: x_msg_data := 'PA_LCYL_USAGE_REQUIRED';
124: x_return_status := FND_API.G_RET_STS_ERROR;
125: END IF;
126:
127: IF P_lifecycle_description = G_MISS_CHAR THEN
128: l_lifecycle_description := null;

Line 143: (p_encoded => FND_API.G_TRUE ,

139: If l_msg_count > 0 THEN
140: x_msg_count := l_msg_count;
141: If l_msg_count = 1 THEN
142: pa_interface_utils_pub.get_messages
143: (p_encoded => FND_API.G_TRUE ,
144: p_msg_index => 1 ,
145: p_msg_count => l_msg_count ,
146: p_msg_data => l_msg_data ,
147: p_data => l_data ,

Line 152: RAISE FND_API.G_EXC_ERROR;

148: p_msg_index_out => l_msg_index_out
149: );
150: x_msg_data := l_data;
151: End if;
152: RAISE FND_API.G_EXC_ERROR;
153: End if;
154:
155:
156: IF(p_debug_mode = 'Y') THEN

Line 189: (p_encoded => FND_API.G_TRUE ,

185: If l_msg_count > 0 THEN
186: x_msg_count := l_msg_count;
187: If l_msg_count = 1 THEN
188: pa_interface_utils_pub.get_messages
189: (p_encoded => FND_API.G_TRUE ,
190: p_msg_index => 1 ,
191: p_msg_count => l_msg_count ,
192: p_msg_data => l_msg_data ,
193: p_data => l_data ,

Line 198: RAISE FND_API.G_EXC_ERROR;

194: p_msg_index_out => l_msg_index_out
195: );
196: x_msg_data := l_data;
197: End if;
198: RAISE FND_API.G_EXC_ERROR;
199: End if;
200:
201: x_lifecycle_id := l_lifecycle_id;
202: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 202: x_return_status := FND_API.G_RET_STS_SUCCESS;

198: RAISE FND_API.G_EXC_ERROR;
199: End if;
200:
201: x_lifecycle_id := l_lifecycle_id;
202: x_return_status := FND_API.G_RET_STS_SUCCESS;
203:
204:
205: IF FND_API.TO_BOOLEAN(P_COMMIT)
206: THEN

Line 205: IF FND_API.TO_BOOLEAN(P_COMMIT)

201: x_lifecycle_id := l_lifecycle_id;
202: x_return_status := FND_API.G_RET_STS_SUCCESS;
203:
204:
205: IF FND_API.TO_BOOLEAN(P_COMMIT)
206: THEN
207: COMMIT;
208: END IF;
209:

Line 210: EXCEPTION WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

206: THEN
207: COMMIT;
208: END IF;
209:
210: EXCEPTION WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
211: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
212: IF p_commit = FND_API.G_TRUE THEN
213: ROLLBACK TO LCYL_CREATE_LIFECYCLE_PUB;
214: END IF;

Line 211: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

207: COMMIT;
208: END IF;
209:
210: EXCEPTION WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
211: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
212: IF p_commit = FND_API.G_TRUE THEN
213: ROLLBACK TO LCYL_CREATE_LIFECYCLE_PUB;
214: END IF;
215:

Line 212: IF p_commit = FND_API.G_TRUE THEN

208: END IF;
209:
210: EXCEPTION WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
211: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
212: IF p_commit = FND_API.G_TRUE THEN
213: ROLLBACK TO LCYL_CREATE_LIFECYCLE_PUB;
214: END IF;
215:
216: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_LIFECYCLES_PUB',

Line 219: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

215:
216: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_LIFECYCLES_PUB',
217: p_procedure_name => 'CREATE_LIFECYCLE',
218: p_error_text => SUBSTRB(SQLERRM,1,240));
219: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
220:
221: WHEN FND_API.G_EXC_ERROR THEN
222: x_return_status := FND_API.G_RET_STS_ERROR;
223: IF p_commit = FND_API.G_TRUE THEN

Line 221: WHEN FND_API.G_EXC_ERROR THEN

217: p_procedure_name => 'CREATE_LIFECYCLE',
218: p_error_text => SUBSTRB(SQLERRM,1,240));
219: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
220:
221: WHEN FND_API.G_EXC_ERROR THEN
222: x_return_status := FND_API.G_RET_STS_ERROR;
223: IF p_commit = FND_API.G_TRUE THEN
224: ROLLBACK TO LCYL_CREATE_LIFECYCLE_PUB;
225: END IF;

Line 222: x_return_status := FND_API.G_RET_STS_ERROR;

218: p_error_text => SUBSTRB(SQLERRM,1,240));
219: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
220:
221: WHEN FND_API.G_EXC_ERROR THEN
222: x_return_status := FND_API.G_RET_STS_ERROR;
223: IF p_commit = FND_API.G_TRUE THEN
224: ROLLBACK TO LCYL_CREATE_LIFECYCLE_PUB;
225: END IF;
226:

Line 223: IF p_commit = FND_API.G_TRUE THEN

219: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
220:
221: WHEN FND_API.G_EXC_ERROR THEN
222: x_return_status := FND_API.G_RET_STS_ERROR;
223: IF p_commit = FND_API.G_TRUE THEN
224: ROLLBACK TO LCYL_CREATE_LIFECYCLE_PUB;
225: END IF;
226:
227: WHEN OTHERS THEN

Line 228: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

224: ROLLBACK TO LCYL_CREATE_LIFECYCLE_PUB;
225: END IF;
226:
227: WHEN OTHERS THEN
228: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
229: IF p_commit = FND_API.G_TRUE THEN
230: ROLLBACK TO LCYL_CREATE_LIFECYCLE_PUB;
231: END IF;
232: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_LIFECYCLES_PUB',

Line 229: IF p_commit = FND_API.G_TRUE THEN

225: END IF;
226:
227: WHEN OTHERS THEN
228: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
229: IF p_commit = FND_API.G_TRUE THEN
230: ROLLBACK TO LCYL_CREATE_LIFECYCLE_PUB;
231: END IF;
232: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_LIFECYCLES_PUB',
233: p_procedure_name => 'CREATE_LIFECYCLE',

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

244:
245:
246: PROCEDURE create_lifecycle_phase(
247: P_api_version IN NUMBER := 1.0 ,
248: p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE ,
249: p_commit IN VARCHAR2 :=FND_API.G_FALSE ,
250: p_validate_only IN VARCHAR2 :=FND_API.G_TRUE ,
251: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL ,
252: p_calling_module IN VARCHAR2 :='SELF_SERVICE' ,

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

245:
246: PROCEDURE create_lifecycle_phase(
247: P_api_version IN NUMBER := 1.0 ,
248: p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE ,
249: p_commit IN VARCHAR2 :=FND_API.G_FALSE ,
250: p_validate_only IN VARCHAR2 :=FND_API.G_TRUE ,
251: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL ,
252: p_calling_module IN VARCHAR2 :='SELF_SERVICE' ,
253: p_debug_mode IN VARCHAR2 :='N' ,

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

246: PROCEDURE create_lifecycle_phase(
247: P_api_version IN NUMBER := 1.0 ,
248: p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE ,
249: p_commit IN VARCHAR2 :=FND_API.G_FALSE ,
250: p_validate_only IN VARCHAR2 :=FND_API.G_TRUE ,
251: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL ,
252: p_calling_module IN VARCHAR2 :='SELF_SERVICE' ,
253: p_debug_mode IN VARCHAR2 :='N' ,
254: P_max_msg_count IN NUMBER :=G_MISS_NUM ,

Line 251: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL ,

247: P_api_version IN NUMBER := 1.0 ,
248: p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE ,
249: p_commit IN VARCHAR2 :=FND_API.G_FALSE ,
250: p_validate_only IN VARCHAR2 :=FND_API.G_TRUE ,
251: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL ,
252: p_calling_module IN VARCHAR2 :='SELF_SERVICE' ,
253: p_debug_mode IN VARCHAR2 :='N' ,
254: P_max_msg_count IN NUMBER :=G_MISS_NUM ,
255: P_lifecycle_id IN NUMBER ,

Line 311: IF (p_commit = FND_API.G_TRUE) THEN

307: IF(p_debug_mode = 'Y') THEN
308: pa_debug.debug('PA_LIFECYCLES_PUB.create_lifecycle_phase :Entered create_lifecycle_phase...');
309: END IF;
310:
311: IF (p_commit = FND_API.G_TRUE) THEN
312: SAVEPOINT CREATE_LCYL_PHASES_PUB;
313: END IF;
314:
315: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version ,

Line 315: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version ,

311: IF (p_commit = FND_API.G_TRUE) THEN
312: SAVEPOINT CREATE_LCYL_PHASES_PUB;
313: END IF;
314:
315: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version ,
316: p_api_version ,
317: l_api_name ,
318: g_pkg_name)
319: THEN

Line 320: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

316: p_api_version ,
317: l_api_name ,
318: g_pkg_name)
319: THEN
320: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
321: END IF;
322:
323:
324: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 324: x_return_status := FND_API.G_RET_STS_SUCCESS;

320: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
321: END IF;
322:
323:
324: x_return_status := FND_API.G_RET_STS_SUCCESS;
325:
326:
327: IF( p_debug_mode = 'Y') THEN
328: pa_debug.debug('PA_LIFECYCLES_PUB.create_lifecycle_phase : Initialising message stack...');

Line 333: IF FND_API.to_boolean(nvl(p_init_msg_list, FND_API.G_FALSE)) THEN

329: END IF;
330:
331: pa_debug.init_err_stack('PA_LIFECYCLES_PUB.CREATE_LIFECYCLE_PHASES');
332:
333: IF FND_API.to_boolean(nvl(p_init_msg_list, FND_API.G_FALSE)) THEN
334: fnd_msg_pub.initialize;
335: END IF;
336:
337: IF(p_debug_mode = 'Y') THEN

Line 346: x_return_status := FND_API.G_RET_STS_ERROR;

342: THEN
343: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
344: p_msg_name => 'PA_LCYL_PHASE_NAME_REQUIRED');
345: x_msg_data := 'PA_LCYL_PHASE_NAME_REQUIRED';
346: x_return_status := FND_API.G_RET_STS_ERROR;
347: END IF;
348:
349: IF (P_phase_short_name is NULL )
350: THEN

Line 354: x_return_status := FND_API.G_RET_STS_ERROR;

350: THEN
351: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
352: p_msg_name => 'PA_LCYL_PHASE_SHORT_NAME_REQ');
353: x_msg_data := 'PA_LCYL_PHASE_SHORT_NAME_REQ';
354: x_return_status := FND_API.G_RET_STS_ERROR;
355: END IF;
356:
357: IF (P_phase_display_sequence is NULL )
358: THEN

Line 362: x_return_status := FND_API.G_RET_STS_ERROR;

358: THEN
359: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
360: p_msg_name => 'PA_LCYL_PHASE_SEQ_NO_REQ');
361: x_msg_data := 'PA_LCYL_PHASE_SEQ_NO_REQ';
362: x_return_status := FND_API.G_RET_STS_ERROR;
363: END IF;
364:
365: l_lifecycle_exists:='N';
366: OPEN l_get_lifecycle_csr;

Line 374: x_return_status := FND_API.G_RET_STS_ERROR;

370: IF(l_lifecycle_exists <> 'Y') THEN
371: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
372: p_msg_name => 'PA_LCYL_NOT_VALID');
373: x_msg_data := 'PA_LCYL_NOT_VALID';
374: x_return_status := FND_API.G_RET_STS_ERROR;
375: END IF;
376:
377: OPEN l_get_phase_csr;
378: FETCH l_get_phase_csr INTO l_phase_code;

Line 385: x_return_status := FND_API.G_RET_STS_ERROR;

381: IF(l_phase_code is null) THEN
382: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
383: p_msg_name => 'PA_LCYL_PHASE_NOT_VALID');
384: x_msg_data := 'PA_LCYL_PHASE_NOT_VALID';
385: x_return_status := FND_API.G_RET_STS_ERROR;
386: END IF;
387:
388:
389: IF p_phase_description = G_MISS_CHAR THEN

Line 405: (p_encoded => FND_API.G_TRUE ,

401: If l_msg_count > 0 THEN
402: x_msg_count := l_msg_count;
403: If l_msg_count = 1 THEN
404: pa_interface_utils_pub.get_messages
405: (p_encoded => FND_API.G_TRUE ,
406: p_msg_index => 1,
407: p_msg_count => l_msg_count ,
408: p_msg_data => l_msg_data,
409: p_data => l_data,

Line 413: RAISE FND_API.G_EXC_ERROR;

409: p_data => l_data,
410: p_msg_index_out => l_msg_index_out );
411: x_msg_data := l_data;
412: End if;
413: RAISE FND_API.G_EXC_ERROR;
414: End if;
415:
416:
417:

Line 452: (p_encoded => FND_API.G_TRUE ,

448: If l_msg_count > 0 THEN
449: x_msg_count := l_msg_count;
450: If l_msg_count = 1 THEN
451: pa_interface_utils_pub.get_messages
452: (p_encoded => FND_API.G_TRUE ,
453: p_msg_index => 1,
454: p_msg_count => l_msg_count ,
455: p_msg_data => l_msg_data,
456: p_data => l_data,

Line 460: RAISE FND_API.G_EXC_ERROR;

456: p_data => l_data,
457: p_msg_index_out => l_msg_index_out );
458: x_msg_data := l_data;
459: End if;
460: RAISE FND_API.G_EXC_ERROR;
461: End if;
462:
463: x_lifecycle_phase_id := l_lifecycle_phase_id;
464: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 464: x_return_status := FND_API.G_RET_STS_SUCCESS;

460: RAISE FND_API.G_EXC_ERROR;
461: End if;
462:
463: x_lifecycle_phase_id := l_lifecycle_phase_id;
464: x_return_status := FND_API.G_RET_STS_SUCCESS;
465:
466:
467: IF FND_API.TO_BOOLEAN(P_COMMIT)
468: THEN

Line 467: IF FND_API.TO_BOOLEAN(P_COMMIT)

463: x_lifecycle_phase_id := l_lifecycle_phase_id;
464: x_return_status := FND_API.G_RET_STS_SUCCESS;
465:
466:
467: IF FND_API.TO_BOOLEAN(P_COMMIT)
468: THEN
469: COMMIT;
470: END IF;
471:

Line 473: EXCEPTION WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

469: COMMIT;
470: END IF;
471:
472:
473: EXCEPTION WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
474: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
475: IF p_commit = FND_API.G_TRUE THEN
476: ROLLBACK TO CREATE_LCYL_PHASES_PUB;
477: END IF;

Line 474: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

470: END IF;
471:
472:
473: EXCEPTION WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
474: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
475: IF p_commit = FND_API.G_TRUE THEN
476: ROLLBACK TO CREATE_LCYL_PHASES_PUB;
477: END IF;
478:

Line 475: IF p_commit = FND_API.G_TRUE THEN

471:
472:
473: EXCEPTION WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
474: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
475: IF p_commit = FND_API.G_TRUE THEN
476: ROLLBACK TO CREATE_LCYL_PHASES_PUB;
477: END IF;
478:
479: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_LIFECYCLES_PUB',

Line 482: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

478:
479: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_LIFECYCLES_PUB',
480: p_procedure_name => 'CREATE_LIFECYCLE_PHASE',
481: p_error_text => SUBSTRB(SQLERRM,1,240));
482: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
483:
484: WHEN FND_API.G_EXC_ERROR THEN
485: x_return_status := FND_API.G_RET_STS_ERROR;
486: IF p_commit = FND_API.G_TRUE THEN

Line 484: WHEN FND_API.G_EXC_ERROR THEN

480: p_procedure_name => 'CREATE_LIFECYCLE_PHASE',
481: p_error_text => SUBSTRB(SQLERRM,1,240));
482: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
483:
484: WHEN FND_API.G_EXC_ERROR THEN
485: x_return_status := FND_API.G_RET_STS_ERROR;
486: IF p_commit = FND_API.G_TRUE THEN
487: ROLLBACK TO CREATE_LCYL_PHASES_PUB;
488: END IF;

Line 485: x_return_status := FND_API.G_RET_STS_ERROR;

481: p_error_text => SUBSTRB(SQLERRM,1,240));
482: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
483:
484: WHEN FND_API.G_EXC_ERROR THEN
485: x_return_status := FND_API.G_RET_STS_ERROR;
486: IF p_commit = FND_API.G_TRUE THEN
487: ROLLBACK TO CREATE_LCYL_PHASES_PUB;
488: END IF;
489:

Line 486: IF p_commit = FND_API.G_TRUE THEN

482: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
483:
484: WHEN FND_API.G_EXC_ERROR THEN
485: x_return_status := FND_API.G_RET_STS_ERROR;
486: IF p_commit = FND_API.G_TRUE THEN
487: ROLLBACK TO CREATE_LCYL_PHASES_PUB;
488: END IF;
489:
490: WHEN OTHERS THEN

Line 491: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

487: ROLLBACK TO CREATE_LCYL_PHASES_PUB;
488: END IF;
489:
490: WHEN OTHERS THEN
491: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
492: IF p_commit = FND_API.G_TRUE THEN
493: ROLLBACK TO CREATE_LCYL_PHASES_PUB;
494: END IF;
495: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_LIFECYCLES_PUB',

Line 492: IF p_commit = FND_API.G_TRUE THEN

488: END IF;
489:
490: WHEN OTHERS THEN
491: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
492: IF p_commit = FND_API.G_TRUE THEN
493: ROLLBACK TO CREATE_LCYL_PHASES_PUB;
494: END IF;
495: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_LIFECYCLES_PUB',
496: p_procedure_name => 'CREATE_LIFECYCLE_PHASE',

Line 509: P_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,

505: +-----------------------------------------------------------*/
506:
507: PROCEDURE delete_lifecycle (
508: P_api_version IN NUMBER := 1.0 ,
509: P_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
510: P_commit IN VARCHAR2 := FND_API.G_FALSE ,
511: P_validate_only IN VARCHAR2 := FND_API.G_TRUE ,
512: P_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
513: P_calling_module IN VARCHAR2 := 'SELF-SERVICE' ,

Line 510: P_commit IN VARCHAR2 := FND_API.G_FALSE ,

506:
507: PROCEDURE delete_lifecycle (
508: P_api_version IN NUMBER := 1.0 ,
509: P_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
510: P_commit IN VARCHAR2 := FND_API.G_FALSE ,
511: P_validate_only IN VARCHAR2 := FND_API.G_TRUE ,
512: P_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
513: P_calling_module IN VARCHAR2 := 'SELF-SERVICE' ,
514: P_debug_mode IN VARCHAR2 := 'N' ,

Line 511: P_validate_only IN VARCHAR2 := FND_API.G_TRUE ,

507: PROCEDURE delete_lifecycle (
508: P_api_version IN NUMBER := 1.0 ,
509: P_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
510: P_commit IN VARCHAR2 := FND_API.G_FALSE ,
511: P_validate_only IN VARCHAR2 := FND_API.G_TRUE ,
512: P_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
513: P_calling_module IN VARCHAR2 := 'SELF-SERVICE' ,
514: P_debug_mode IN VARCHAR2 := 'N' ,
515: P_max_msg_count IN NUMBER := G_MISS_NUM ,

Line 512: P_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,

508: P_api_version IN NUMBER := 1.0 ,
509: P_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
510: P_commit IN VARCHAR2 := FND_API.G_FALSE ,
511: P_validate_only IN VARCHAR2 := FND_API.G_TRUE ,
512: P_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
513: P_calling_module IN VARCHAR2 := 'SELF-SERVICE' ,
514: P_debug_mode IN VARCHAR2 := 'N' ,
515: P_max_msg_count IN NUMBER := G_MISS_NUM ,
516: P_lifecycle_id IN NUMBER ,

Line 583: IF (p_commit = FND_API.G_TRUE) then

579: IF(p_debug_mode = 'Y') then
580: pa_debug.debug('PA_LIFECYCLES_PUB.delete_lifecycle : Entered delete_lifecycle...');
581: END IF;
582:
583: IF (p_commit = FND_API.G_TRUE) then
584: SAVEPOINT LCYL_DELETE_LIFECYCLE_PUB;
585: END IF;
586:
587:

Line 588: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version,

584: SAVEPOINT LCYL_DELETE_LIFECYCLE_PUB;
585: END IF;
586:
587:
588: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version,
589: p_api_version,
590: l_api_name,
591: g_pkg_name)
592: THEN

Line 593: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

589: p_api_version,
590: l_api_name,
591: g_pkg_name)
592: THEN
593: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
594: END IF;
595:
596: x_return_status := FND_API.G_RET_STS_SUCCESS;
597:

Line 596: x_return_status := FND_API.G_RET_STS_SUCCESS;

592: THEN
593: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
594: END IF;
595:
596: x_return_status := FND_API.G_RET_STS_SUCCESS;
597:
598: -- Initialise message stack
599:
600: IF( p_debug_mode = 'Y') THEN

Line 606: IF FND_API.to_boolean(nvl(p_init_msg_list, FND_API.G_FALSE)) THEN

602: END IF;
603:
604: pa_debug.init_err_stack('PA_LIFECYCLES_PUB.DELETE_LIFECYCLE');
605:
606: IF FND_API.to_boolean(nvl(p_init_msg_list, FND_API.G_FALSE)) THEN
607: fnd_msg_pub.initialize;
608: END IF;
609:
610: IF(p_debug_mode = 'Y') THEN

Line 626: x_return_status := FND_API.G_RET_STS_ERROR;

622: IF(l_lifecycle_exists <> 'Y') THEN
623: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
624: p_msg_name => 'PA_LCYL_NOT_VALID');
625: x_msg_data := 'PA_LCYL_NOT_VALID';
626: x_return_status := FND_API.G_RET_STS_ERROR;
627: END IF;
628:
629: begin
630: select 'Y'

Line 665: (p_encoded => FND_API.G_TRUE ,

661: If l_msg_count > 0 THEN
662: x_msg_count := l_msg_count;
663: If l_msg_count = 1 THEN
664: pa_interface_utils_pub.get_messages
665: (p_encoded => FND_API.G_TRUE ,
666: p_msg_index => 1,
667: p_msg_count => l_msg_count ,
668: p_msg_data => l_msg_data,
669: p_data => l_data,

Line 673: RAISE FND_API.G_EXC_ERROR;

669: p_data => l_data,
670: p_msg_index_out => l_msg_index_out );
671: x_msg_data := l_data;
672: End if;
673: RAISE FND_API.G_EXC_ERROR;
674: End if;
675:
676: OPEN l_get_life_elem_ver_id;
677: FETCH l_get_life_elem_ver_id INTO l_life_elem_ver_id;

Line 726: (p_encoded => FND_API.G_TRUE ,

722: If l_msg_count > 0 THEN
723: x_msg_count := l_msg_count;
724: If l_msg_count = 1 THEN
725: pa_interface_utils_pub.get_messages
726: (p_encoded => FND_API.G_TRUE ,
727: p_msg_index => 1,
728: p_msg_count => l_msg_count ,
729: p_msg_data => l_msg_data,
730: p_data => l_data,

Line 734: RAISE FND_API.G_EXC_ERROR;

730: p_data => l_data,
731: p_msg_index_out => l_msg_index_out );
732: x_msg_data := l_data;
733: End if;
734: RAISE FND_API.G_EXC_ERROR;
735: End if;
736:
737: IF (l_del_lifecycle_ok <> FND_API.G_TRUE) THEN
738: RAISE FND_API.G_EXC_ERROR;

Line 737: IF (l_del_lifecycle_ok <> FND_API.G_TRUE) THEN

733: End if;
734: RAISE FND_API.G_EXC_ERROR;
735: End if;
736:
737: IF (l_del_lifecycle_ok <> FND_API.G_TRUE) THEN
738: RAISE FND_API.G_EXC_ERROR;
739: END IF;
740:
741: IF (p_debug_mode = 'Y') THEN

Line 738: RAISE FND_API.G_EXC_ERROR;

734: RAISE FND_API.G_EXC_ERROR;
735: End if;
736:
737: IF (l_del_lifecycle_ok <> FND_API.G_TRUE) THEN
738: RAISE FND_API.G_EXC_ERROR;
739: END IF;
740:
741: IF (p_debug_mode = 'Y') THEN
742: pa_debug.debug('PA_LIFECYCLES_PUB.delete_lifecycle : calling pa_lifecycles_pvt.delete_lifecycle_phase for each phase');

Line 775: (p_encoded => FND_API.G_TRUE ,

771: If l_msg_count > 0 THEN
772: x_msg_count := l_msg_count;
773: If l_msg_count = 1 THEN
774: pa_interface_utils_pub.get_messages
775: (p_encoded => FND_API.G_TRUE ,
776: p_msg_index => 1,
777: p_msg_count => l_msg_count ,
778: p_msg_data => l_msg_data,
779: p_data => l_data,

Line 783: RAISE FND_API.G_EXC_ERROR;

779: p_data => l_data,
780: p_msg_index_out => l_msg_index_out );
781: x_msg_data := l_data;
782: End if;
783: RAISE FND_API.G_EXC_ERROR;
784: End if;
785:
786:
787: IF(l_product_usage_exists = 'Y') then

Line 828: (p_encoded => FND_API.G_TRUE ,

824: If l_msg_count > 0 THEN
825: x_msg_count := l_msg_count;
826: If l_msg_count = 1 THEN
827: pa_interface_utils_pub.get_messages
828: (p_encoded => FND_API.G_TRUE ,
829: p_msg_index => 1,
830: p_msg_count => l_msg_count ,
831: p_msg_data => l_msg_data,
832: p_data => l_data,

Line 836: RAISE FND_API.G_EXC_ERROR;

832: p_data => l_data,
833: p_msg_index_out => l_msg_index_out );
834: x_msg_data := l_data;
835: End if;
836: RAISE FND_API.G_EXC_ERROR;
837: End if;
838:
839: x_return_status := FND_API.G_RET_STS_SUCCESS;
840:

Line 839: x_return_status := FND_API.G_RET_STS_SUCCESS;

835: End if;
836: RAISE FND_API.G_EXC_ERROR;
837: End if;
838:
839: x_return_status := FND_API.G_RET_STS_SUCCESS;
840:
841:
842: IF FND_API.TO_BOOLEAN(P_COMMIT)
843: THEN

Line 842: IF FND_API.TO_BOOLEAN(P_COMMIT)

838:
839: x_return_status := FND_API.G_RET_STS_SUCCESS;
840:
841:
842: IF FND_API.TO_BOOLEAN(P_COMMIT)
843: THEN
844: COMMIT;
845: END IF;
846:

Line 848: EXCEPTION WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

844: COMMIT;
845: END IF;
846:
847:
848: EXCEPTION WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
849: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
850: IF p_commit = FND_API.G_TRUE THEN
851: ROLLBACK TO LCYL_DELETE_LIFECYCLE_PUB;
852: END IF;

Line 849: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

845: END IF;
846:
847:
848: EXCEPTION WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
849: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
850: IF p_commit = FND_API.G_TRUE THEN
851: ROLLBACK TO LCYL_DELETE_LIFECYCLE_PUB;
852: END IF;
853:

Line 850: IF p_commit = FND_API.G_TRUE THEN

846:
847:
848: EXCEPTION WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
849: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
850: IF p_commit = FND_API.G_TRUE THEN
851: ROLLBACK TO LCYL_DELETE_LIFECYCLE_PUB;
852: END IF;
853:
854: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_LIFECYCLES_PUB',

Line 857: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

853:
854: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_LIFECYCLES_PUB',
855: p_procedure_name => 'DELETE_LIFECYCLE',
856: p_error_text => SUBSTRB(SQLERRM,1,240));
857: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
858:
859: WHEN FND_API.G_EXC_ERROR THEN
860: x_return_status := FND_API.G_RET_STS_ERROR;
861: IF p_commit = FND_API.G_TRUE THEN

Line 859: WHEN FND_API.G_EXC_ERROR THEN

855: p_procedure_name => 'DELETE_LIFECYCLE',
856: p_error_text => SUBSTRB(SQLERRM,1,240));
857: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
858:
859: WHEN FND_API.G_EXC_ERROR THEN
860: x_return_status := FND_API.G_RET_STS_ERROR;
861: IF p_commit = FND_API.G_TRUE THEN
862: ROLLBACK TO LCYL_DELETE_LIFECYCLE_PUB;
863: END IF;

Line 860: x_return_status := FND_API.G_RET_STS_ERROR;

856: p_error_text => SUBSTRB(SQLERRM,1,240));
857: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
858:
859: WHEN FND_API.G_EXC_ERROR THEN
860: x_return_status := FND_API.G_RET_STS_ERROR;
861: IF p_commit = FND_API.G_TRUE THEN
862: ROLLBACK TO LCYL_DELETE_LIFECYCLE_PUB;
863: END IF;
864:

Line 861: IF p_commit = FND_API.G_TRUE THEN

857: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
858:
859: WHEN FND_API.G_EXC_ERROR THEN
860: x_return_status := FND_API.G_RET_STS_ERROR;
861: IF p_commit = FND_API.G_TRUE THEN
862: ROLLBACK TO LCYL_DELETE_LIFECYCLE_PUB;
863: END IF;
864:
865: WHEN OTHERS THEN

Line 866: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

862: ROLLBACK TO LCYL_DELETE_LIFECYCLE_PUB;
863: END IF;
864:
865: WHEN OTHERS THEN
866: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
867: IF p_commit = FND_API.G_TRUE THEN
868: ROLLBACK TO LCYL_DELETE_LIFECYCLE_PUB;
869: END IF;
870: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_LIFECYCLES_PUB',

Line 867: IF p_commit = FND_API.G_TRUE THEN

863: END IF;
864:
865: WHEN OTHERS THEN
866: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
867: IF p_commit = FND_API.G_TRUE THEN
868: ROLLBACK TO LCYL_DELETE_LIFECYCLE_PUB;
869: END IF;
870: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_LIFECYCLES_PUB',
871: p_procedure_name => 'DELETE_LIFECYCLE',

Line 883: P_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,

879: +-----------------------------------------------------------*/
880:
881: PROCEDURE delete_lifecycle_phase (
882: P_api_version IN NUMBER := 1.0 ,
883: P_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
884: P_commit IN VARCHAR2 := FND_API.G_FALSE ,
885: P_validate_only IN VARCHAR2 := FND_API.G_TRUE ,
886: P_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
887: P_calling_module IN VARCHAR2 := 'SELF-SERVICE' ,

Line 884: P_commit IN VARCHAR2 := FND_API.G_FALSE ,

880:
881: PROCEDURE delete_lifecycle_phase (
882: P_api_version IN NUMBER := 1.0 ,
883: P_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
884: P_commit IN VARCHAR2 := FND_API.G_FALSE ,
885: P_validate_only IN VARCHAR2 := FND_API.G_TRUE ,
886: P_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
887: P_calling_module IN VARCHAR2 := 'SELF-SERVICE' ,
888: P_debug_mode IN VARCHAR2 := 'N' ,

Line 885: P_validate_only IN VARCHAR2 := FND_API.G_TRUE ,

881: PROCEDURE delete_lifecycle_phase (
882: P_api_version IN NUMBER := 1.0 ,
883: P_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
884: P_commit IN VARCHAR2 := FND_API.G_FALSE ,
885: P_validate_only IN VARCHAR2 := FND_API.G_TRUE ,
886: P_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
887: P_calling_module IN VARCHAR2 := 'SELF-SERVICE' ,
888: P_debug_mode IN VARCHAR2 := 'N' ,
889: P_max_msg_count IN NUMBER := G_MISS_NUM ,

Line 886: P_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,

882: P_api_version IN NUMBER := 1.0 ,
883: P_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
884: P_commit IN VARCHAR2 := FND_API.G_FALSE ,
885: P_validate_only IN VARCHAR2 := FND_API.G_TRUE ,
886: P_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
887: P_calling_module IN VARCHAR2 := 'SELF-SERVICE' ,
888: P_debug_mode IN VARCHAR2 := 'N' ,
889: P_max_msg_count IN NUMBER := G_MISS_NUM ,
890: P_lifecycle_id IN NUMBER ,

Line 944: IF (p_commit = FND_API.G_TRUE) then

940: IF(p_debug_mode = 'Y') then
941: pa_debug.debug('PA_LIFECYCLES_PUB.delete_lifecycle_phase : Entered delete_lifecycle_phase...');
942: END IF;
943:
944: IF (p_commit = FND_API.G_TRUE) then
945: SAVEPOINT LCYL_DELETE_LCYL_PHASE_PUB;
946: END IF;
947:
948:

Line 949: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version,

945: SAVEPOINT LCYL_DELETE_LCYL_PHASE_PUB;
946: END IF;
947:
948:
949: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version,
950: p_api_version,
951: l_api_name,
952: g_pkg_name)
953: THEN

Line 954: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

950: p_api_version,
951: l_api_name,
952: g_pkg_name)
953: THEN
954: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
955: END IF;
956:
957: x_return_status := FND_API.G_RET_STS_SUCCESS;
958:

Line 957: x_return_status := FND_API.G_RET_STS_SUCCESS;

953: THEN
954: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
955: END IF;
956:
957: x_return_status := FND_API.G_RET_STS_SUCCESS;
958:
959: -- Initialise message stack
960:
961: IF( p_debug_mode = 'Y') THEN

Line 967: IF FND_API.to_boolean(nvl(p_init_msg_list, FND_API.G_FALSE)) THEN

963: END IF;
964:
965: pa_debug.init_err_stack('PA_LIFECYCLES_PUB.DELETE_LIFECYCLE_PHASE');
966:
967: IF FND_API.to_boolean(nvl(p_init_msg_list, FND_API.G_FALSE)) THEN
968: fnd_msg_pub.initialize;
969: END IF;
970:
971: IF(p_debug_mode = 'Y') THEN

Line 1001: x_return_status := FND_API.G_RET_STS_ERROR;

997: IF(l_phase_exists <> 'Y') THEN
998: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
999: p_msg_name => 'PA_LCYL_PHASE_NOT_VALID');
1000: x_msg_data := 'PA_LCYL_PHASE_NOT_VALID';
1001: x_return_status := FND_API.G_RET_STS_ERROR;
1002: END IF;
1003:
1004: begin
1005: select 'Y'

Line 1039: (p_encoded => FND_API.G_TRUE ,

1035: If l_msg_count > 0 THEN
1036: x_msg_count := l_msg_count;
1037: If l_msg_count = 1 THEN
1038: pa_interface_utils_pub.get_messages
1039: (p_encoded => FND_API.G_TRUE ,
1040: p_msg_index => 1,
1041: p_msg_count => l_msg_count ,
1042: p_msg_data => l_msg_data,
1043: p_data => l_data,

Line 1047: RAISE FND_API.G_EXC_ERROR;

1043: p_data => l_data,
1044: p_msg_index_out => l_msg_index_out );
1045: x_msg_data := l_data;
1046: End if;
1047: RAISE FND_API.G_EXC_ERROR;
1048: End if;
1049:
1050: IF(l_project_usage_exists = 'Y') then
1051:

Line 1100: (p_encoded => FND_API.G_TRUE ,

1096: If l_msg_count > 0 THEN
1097: x_msg_count := l_msg_count;
1098: If l_msg_count = 1 THEN
1099: pa_interface_utils_pub.get_messages
1100: (p_encoded => FND_API.G_TRUE ,
1101: p_msg_index => 1,
1102: p_msg_count => l_msg_count ,
1103: p_msg_data => l_msg_data,
1104: p_data => l_data,

Line 1108: RAISE FND_API.G_EXC_ERROR;

1104: p_data => l_data,
1105: p_msg_index_out => l_msg_index_out );
1106: x_msg_data := l_data;
1107: End if;
1108: RAISE FND_API.G_EXC_ERROR;
1109: End if;
1110:
1111: IF (l_del_phase_ok <> FND_API.G_TRUE) THEN
1112: RAISE FND_API.G_EXC_ERROR;

Line 1111: IF (l_del_phase_ok <> FND_API.G_TRUE) THEN

1107: End if;
1108: RAISE FND_API.G_EXC_ERROR;
1109: End if;
1110:
1111: IF (l_del_phase_ok <> FND_API.G_TRUE) THEN
1112: RAISE FND_API.G_EXC_ERROR;
1113: END IF;
1114:
1115:

Line 1112: RAISE FND_API.G_EXC_ERROR;

1108: RAISE FND_API.G_EXC_ERROR;
1109: End if;
1110:
1111: IF (l_del_phase_ok <> FND_API.G_TRUE) THEN
1112: RAISE FND_API.G_EXC_ERROR;
1113: END IF;
1114:
1115:
1116: IF(l_product_usage_exists = 'Y') then

Line 1158: (p_encoded => FND_API.G_TRUE ,

1154: If l_msg_count > 0 THEN
1155: x_msg_count := l_msg_count;
1156: If l_msg_count = 1 THEN
1157: pa_interface_utils_pub.get_messages
1158: (p_encoded => FND_API.G_TRUE ,
1159: p_msg_index => 1 ,
1160: p_msg_count => l_msg_count ,
1161: p_msg_data => l_msg_data ,
1162: p_data => l_data ,

Line 1166: RAISE FND_API.G_EXC_ERROR;

1162: p_data => l_data ,
1163: p_msg_index_out => l_msg_index_out );
1164: x_msg_data := l_data;
1165: End if;
1166: RAISE FND_API.G_EXC_ERROR;
1167: End if;
1168:
1169: x_return_status := FND_API.G_RET_STS_SUCCESS;
1170:

Line 1169: x_return_status := FND_API.G_RET_STS_SUCCESS;

1165: End if;
1166: RAISE FND_API.G_EXC_ERROR;
1167: End if;
1168:
1169: x_return_status := FND_API.G_RET_STS_SUCCESS;
1170:
1171:
1172: IF FND_API.TO_BOOLEAN(P_COMMIT)
1173: THEN

Line 1172: IF FND_API.TO_BOOLEAN(P_COMMIT)

1168:
1169: x_return_status := FND_API.G_RET_STS_SUCCESS;
1170:
1171:
1172: IF FND_API.TO_BOOLEAN(P_COMMIT)
1173: THEN
1174: COMMIT;
1175: END IF;
1176:

Line 1178: EXCEPTION WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1174: COMMIT;
1175: END IF;
1176:
1177:
1178: EXCEPTION WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1179: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1180: IF p_commit = FND_API.G_TRUE THEN
1181: ROLLBACK TO LCYL_DELETE_LCYL_PHASE_PUB;
1182: END IF;

Line 1179: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1175: END IF;
1176:
1177:
1178: EXCEPTION WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1179: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1180: IF p_commit = FND_API.G_TRUE THEN
1181: ROLLBACK TO LCYL_DELETE_LCYL_PHASE_PUB;
1182: END IF;
1183:

Line 1180: IF p_commit = FND_API.G_TRUE THEN

1176:
1177:
1178: EXCEPTION WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1179: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1180: IF p_commit = FND_API.G_TRUE THEN
1181: ROLLBACK TO LCYL_DELETE_LCYL_PHASE_PUB;
1182: END IF;
1183:
1184: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_LIFECYCLES_PUB',

Line 1187: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1183:
1184: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_LIFECYCLES_PUB',
1185: p_procedure_name => 'DELETE_LIFECYCLE_PHASE',
1186: p_error_text => SUBSTRB(SQLERRM,1,240));
1187: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1188:
1189: WHEN FND_API.G_EXC_ERROR THEN
1190: x_return_status := FND_API.G_RET_STS_ERROR;
1191: IF p_commit = FND_API.G_TRUE THEN

Line 1189: WHEN FND_API.G_EXC_ERROR THEN

1185: p_procedure_name => 'DELETE_LIFECYCLE_PHASE',
1186: p_error_text => SUBSTRB(SQLERRM,1,240));
1187: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1188:
1189: WHEN FND_API.G_EXC_ERROR THEN
1190: x_return_status := FND_API.G_RET_STS_ERROR;
1191: IF p_commit = FND_API.G_TRUE THEN
1192: ROLLBACK TO LCYL_DELETE_LCYL_PHASE_PUB;
1193: END IF;

Line 1190: x_return_status := FND_API.G_RET_STS_ERROR;

1186: p_error_text => SUBSTRB(SQLERRM,1,240));
1187: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1188:
1189: WHEN FND_API.G_EXC_ERROR THEN
1190: x_return_status := FND_API.G_RET_STS_ERROR;
1191: IF p_commit = FND_API.G_TRUE THEN
1192: ROLLBACK TO LCYL_DELETE_LCYL_PHASE_PUB;
1193: END IF;
1194:

Line 1191: IF p_commit = FND_API.G_TRUE THEN

1187: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1188:
1189: WHEN FND_API.G_EXC_ERROR THEN
1190: x_return_status := FND_API.G_RET_STS_ERROR;
1191: IF p_commit = FND_API.G_TRUE THEN
1192: ROLLBACK TO LCYL_DELETE_LCYL_PHASE_PUB;
1193: END IF;
1194:
1195: WHEN OTHERS THEN

Line 1196: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1192: ROLLBACK TO LCYL_DELETE_LCYL_PHASE_PUB;
1193: END IF;
1194:
1195: WHEN OTHERS THEN
1196: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1197: IF p_commit = FND_API.G_TRUE THEN
1198: ROLLBACK TO LCYL_DELETE_LCYL_PHASE_PUB;
1199: END IF;
1200: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_LIFECYCLES_PUB',

Line 1197: IF p_commit = FND_API.G_TRUE THEN

1193: END IF;
1194:
1195: WHEN OTHERS THEN
1196: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1197: IF p_commit = FND_API.G_TRUE THEN
1198: ROLLBACK TO LCYL_DELETE_LCYL_PHASE_PUB;
1199: END IF;
1200: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_LIFECYCLES_PUB',
1201: p_procedure_name => 'DELETE_LIFECYCLE_PHASE',

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

1210: +-----------------------------------------------------------*/
1211:
1212: PROCEDURE update_lifecycle (
1213: P_api_version IN NUMBER :=1.0 ,
1214: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
1215: p_commit IN VARCHAR2 :=FND_API.G_FALSE ,
1216: p_validate_only IN VARCHAR2 :=FND_API.G_TRUE ,
1217: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL ,
1218: p_calling_module IN VARCHAR2 :='SELF SERVICE' ,

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

1211:
1212: PROCEDURE update_lifecycle (
1213: P_api_version IN NUMBER :=1.0 ,
1214: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
1215: p_commit IN VARCHAR2 :=FND_API.G_FALSE ,
1216: p_validate_only IN VARCHAR2 :=FND_API.G_TRUE ,
1217: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL ,
1218: p_calling_module IN VARCHAR2 :='SELF SERVICE' ,
1219: p_debug_mode IN VARCHAR2 :='N' ,

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

1212: PROCEDURE update_lifecycle (
1213: P_api_version IN NUMBER :=1.0 ,
1214: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
1215: p_commit IN VARCHAR2 :=FND_API.G_FALSE ,
1216: p_validate_only IN VARCHAR2 :=FND_API.G_TRUE ,
1217: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL ,
1218: p_calling_module IN VARCHAR2 :='SELF SERVICE' ,
1219: p_debug_mode IN VARCHAR2 :='N' ,
1220: p_max_msg_count IN NUMBER :=G_MISS_NUM ,

Line 1217: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL ,

1213: P_api_version IN NUMBER :=1.0 ,
1214: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
1215: p_commit IN VARCHAR2 :=FND_API.G_FALSE ,
1216: p_validate_only IN VARCHAR2 :=FND_API.G_TRUE ,
1217: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL ,
1218: p_calling_module IN VARCHAR2 :='SELF SERVICE' ,
1219: p_debug_mode IN VARCHAR2 :='N' ,
1220: p_max_msg_count IN NUMBER :=G_MISS_NUM ,
1221: P_lifecycle_id IN NUMBER ,

Line 1260: IF (p_commit = FND_API.G_TRUE) then

1256: IF(p_debug_mode = 'Y') THEN
1257: pa_debug.debug('PA_LIFECYCLES_PUB.update_lifecycle : Entered update_lifecycle...');
1258: END IF;
1259:
1260: IF (p_commit = FND_API.G_TRUE) then
1261: SAVEPOINT LCYL_UPDATE_LIFECYCLE_PUB;
1262: END IF;
1263:
1264: IF(p_debug_mode = 'Y') THEN

Line 1268: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version ,

1264: IF(p_debug_mode = 'Y') THEN
1265: pa_debug.debug('PA_LIFECYCLES_PUB.Update_Lifecycle: Checking api compatibility...');
1266: END IF;
1267:
1268: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version ,
1269: p_api_version ,
1270: l_api_name ,
1271: g_pkg_name)
1272: THEN

Line 1273: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1269: p_api_version ,
1270: l_api_name ,
1271: g_pkg_name)
1272: THEN
1273: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1274: END IF;
1275:
1276: x_return_status := FND_API.G_RET_STS_SUCCESS;
1277:

Line 1276: x_return_status := FND_API.G_RET_STS_SUCCESS;

1272: THEN
1273: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1274: END IF;
1275:
1276: x_return_status := FND_API.G_RET_STS_SUCCESS;
1277:
1278:
1279: l_lifecycle_id := P_lifecycle_id;
1280:

Line 1289: IF FND_API.to_boolean(nvl(p_init_msg_list, FND_API.G_FALSE)) THEN

1285: END IF;
1286:
1287: pa_debug.init_err_stack('PA_LIFECYCLES_PUB.UPDATE_LIFECYCLE');
1288:
1289: IF FND_API.to_boolean(nvl(p_init_msg_list, FND_API.G_FALSE)) THEN
1290: fnd_msg_pub.initialize;
1291: END IF;
1292:
1293:

Line 1313: x_return_status := FND_API.G_RET_STS_ERROR;

1309: when NO_DATA_FOUND then
1310: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
1311: p_msg_name => 'PA_LCYL_NOT_VALID');
1312: x_msg_data := 'PA_LCYL_NOT_VALID';
1313: x_return_status := FND_API.G_RET_STS_ERROR;
1314: END;
1315:
1316: IF(p_debug_mode = 'Y') THEN
1317: pa_debug.debug('PA_LIFECYCLES_PUB.Update_Lifecycle:Checking for null values assigning the updated values');

Line 1327: x_return_status := FND_API.G_RET_STS_ERROR;

1323: pa_debug.debug('Lifecycle name is NULL....');
1324: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
1325: p_msg_name => 'PA_LCYL_NAME_REQUIRED');
1326: x_msg_data := 'PA_LCYL_NAME_REQUIRED';
1327: x_return_status := FND_API.G_RET_STS_ERROR;
1328: ELSIF(P_lifecycle_name <> G_MISS_CHAR) then
1329: IF l_lcyl_name <> P_lifecycle_name THEN
1330: l_data_changed := true;
1331: END IF;

Line 1342: x_return_status := FND_API.G_RET_STS_ERROR;

1338: pa_debug.debug('Lifecycle short name is NULL....');
1339: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
1340: p_msg_name => 'PA_LCYL_SHORT_NAME_REQUIRED');
1341: x_msg_data := 'PA_LCYL_SHORT_NAME_REQUIRED';
1342: x_return_status := FND_API.G_RET_STS_ERROR;
1343: ELSIF (P_lifecycle_short_name <> G_MISS_CHAR)
1344: THEN
1345: IF(p_debug_mode = 'Y') THEN
1346: pa_debug.debug('PA_LIFECYCLES_PVT.Update_Lifecycle: Checking for existing parameters for uniqueness..');

Line 1369: x_return_status := FND_API.G_RET_STS_ERROR;

1365: PA_UTILS.ADD_MESSAGE(
1366: p_app_short_name => 'PA',
1367: p_msg_name => 'PA_LCYL_SHORT_NAME_EXISTS');
1368: x_msg_data := 'PA_LCYL_SHORT_NAME_EXISTS';
1369: x_return_status := FND_API.G_RET_STS_ERROR;
1370: ELSE
1371: IF l_short_name <> P_lifecycle_short_name THEN
1372: l_data_changed := true;
1373: END IF;

Line 1404: x_return_status := FND_API.G_RET_STS_ERROR;

1400: THEN
1401: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
1402: p_msg_name => 'PA_LCYL_USAGE_REQUIRED');
1403: x_msg_data := 'PA_LCYL_USAGE_REQUIRED';
1404: x_return_status := FND_API.G_RET_STS_ERROR;
1405: END IF;
1406:
1407: BEGIN
1408: select 'Y'

Line 1450: x_return_status := FND_API.G_RET_STS_ERROR;

1446: THEN
1447: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
1448: p_msg_name => 'PA_LCYL_USAGE_REQUIRED');
1449: x_msg_data := 'PA_LCYL_USAGE_REQUIRED';
1450: x_return_status := FND_API.G_RET_STS_ERROR;
1451: END IF;
1452:
1453:
1454: /* The below code could be used to dod not hit the data if nothing is changed

Line 1459: x_return_status := FND_API.G_RET_STS_ERROR;

1455: IF (NOT (l_data_changed)) THEN
1456: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
1457: p_msg_name => 'PA_NO_CHANGES_TO_UPDATE');
1458: x_msg_data := 'PA_NO_CHANGES_TO_UPDATE';
1459: x_return_status := FND_API.G_RET_STS_ERROR;
1460: END IF;
1461: */
1462:
1463: IF(p_debug_mode = 'Y') THEN

Line 1477: (p_encoded => FND_API.G_TRUE ,

1473: If l_msg_count > 0 THEN
1474: x_msg_count := l_msg_count;
1475: If l_msg_count = 1 THEN
1476: pa_interface_utils_pub.get_messages
1477: (p_encoded => FND_API.G_TRUE ,
1478: p_msg_index => 1,
1479: p_msg_count => l_msg_count ,
1480: p_msg_data => l_msg_data,
1481: p_data => l_data,

Line 1485: RAISE FND_API.G_EXC_ERROR;

1481: p_data => l_data,
1482: p_msg_index_out => l_msg_index_out );
1483: x_msg_data := l_data;
1484: End if;
1485: RAISE FND_API.G_EXC_ERROR;
1486: End if;
1487:
1488:
1489: IF(p_debug_mode = 'Y') THEN

Line 1528: (p_encoded => FND_API.G_TRUE ,

1524: If l_msg_count > 0 THEN
1525: x_msg_count := l_msg_count;
1526: If l_msg_count = 1 THEN
1527: pa_interface_utils_pub.get_messages
1528: (p_encoded => FND_API.G_TRUE ,
1529: p_msg_index => 1 ,
1530: p_msg_count => l_msg_count ,
1531: p_msg_data => l_msg_data ,
1532: p_data => l_data ,

Line 1536: RAISE FND_API.G_EXC_ERROR;

1532: p_data => l_data ,
1533: p_msg_index_out => l_msg_index_out );
1534: x_msg_data := l_data;
1535: End if;
1536: RAISE FND_API.G_EXC_ERROR;
1537: End if;
1538:
1539: x_return_status := FND_API.G_RET_STS_SUCCESS;
1540:

Line 1539: x_return_status := FND_API.G_RET_STS_SUCCESS;

1535: End if;
1536: RAISE FND_API.G_EXC_ERROR;
1537: End if;
1538:
1539: x_return_status := FND_API.G_RET_STS_SUCCESS;
1540:
1541:
1542: IF FND_API.TO_BOOLEAN(P_COMMIT) THEN
1543: COMMIT;

Line 1542: IF FND_API.TO_BOOLEAN(P_COMMIT) THEN

1538:
1539: x_return_status := FND_API.G_RET_STS_SUCCESS;
1540:
1541:
1542: IF FND_API.TO_BOOLEAN(P_COMMIT) THEN
1543: COMMIT;
1544: END IF;
1545:
1546:

Line 1549: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1545:
1546:
1547: EXCEPTION
1548:
1549: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1550: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1551: IF p_commit = FND_API.G_TRUE THEN
1552: ROLLBACK TO LCYL_UPDATE_LIFECYCLE_PUB;
1553: END IF;

Line 1550: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1546:
1547: EXCEPTION
1548:
1549: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1550: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1551: IF p_commit = FND_API.G_TRUE THEN
1552: ROLLBACK TO LCYL_UPDATE_LIFECYCLE_PUB;
1553: END IF;
1554:

Line 1551: IF p_commit = FND_API.G_TRUE THEN

1547: EXCEPTION
1548:
1549: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1550: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1551: IF p_commit = FND_API.G_TRUE THEN
1552: ROLLBACK TO LCYL_UPDATE_LIFECYCLE_PUB;
1553: END IF;
1554:
1555: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_LIFECYCLES_PUB',

Line 1558: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1554:
1555: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_LIFECYCLES_PUB',
1556: p_procedure_name => 'UPDATE_LIFECYCLE',
1557: p_error_text => SUBSTRB(SQLERRM,1,240));
1558: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1559:
1560: WHEN FND_API.G_EXC_ERROR THEN
1561: x_return_status := FND_API.G_RET_STS_ERROR;
1562: IF p_commit = FND_API.G_TRUE THEN

Line 1560: WHEN FND_API.G_EXC_ERROR THEN

1556: p_procedure_name => 'UPDATE_LIFECYCLE',
1557: p_error_text => SUBSTRB(SQLERRM,1,240));
1558: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1559:
1560: WHEN FND_API.G_EXC_ERROR THEN
1561: x_return_status := FND_API.G_RET_STS_ERROR;
1562: IF p_commit = FND_API.G_TRUE THEN
1563: ROLLBACK TO LCYL_UPDATE_LIFECYCLE_PUB;
1564: END IF;

Line 1561: x_return_status := FND_API.G_RET_STS_ERROR;

1557: p_error_text => SUBSTRB(SQLERRM,1,240));
1558: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1559:
1560: WHEN FND_API.G_EXC_ERROR THEN
1561: x_return_status := FND_API.G_RET_STS_ERROR;
1562: IF p_commit = FND_API.G_TRUE THEN
1563: ROLLBACK TO LCYL_UPDATE_LIFECYCLE_PUB;
1564: END IF;
1565:

Line 1562: IF p_commit = FND_API.G_TRUE THEN

1558: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1559:
1560: WHEN FND_API.G_EXC_ERROR THEN
1561: x_return_status := FND_API.G_RET_STS_ERROR;
1562: IF p_commit = FND_API.G_TRUE THEN
1563: ROLLBACK TO LCYL_UPDATE_LIFECYCLE_PUB;
1564: END IF;
1565:
1566: WHEN OTHERS THEN

Line 1567: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1563: ROLLBACK TO LCYL_UPDATE_LIFECYCLE_PUB;
1564: END IF;
1565:
1566: WHEN OTHERS THEN
1567: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1568: IF p_commit = FND_API.G_TRUE THEN
1569: ROLLBACK TO LCYL_UPDATE_LIFECYCLE_PUB;
1570: END IF;
1571: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_LIFECYCLES_PUB',

Line 1568: IF p_commit = FND_API.G_TRUE THEN

1564: END IF;
1565:
1566: WHEN OTHERS THEN
1567: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1568: IF p_commit = FND_API.G_TRUE THEN
1569: ROLLBACK TO LCYL_UPDATE_LIFECYCLE_PUB;
1570: END IF;
1571: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_LIFECYCLES_PUB',
1572: p_procedure_name => 'UPDATE_LIFECYCLE',

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

1582:
1583:
1584: PROCEDURE update_lifecycle_phase (
1585: P_api_version IN NUMBER :=1.0 ,
1586: p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE ,
1587: p_commit IN VARCHAR2 :=FND_API.G_FALSE ,
1588: p_validate_only IN VARCHAR2 :=FND_API.G_TRUE ,
1589: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL ,
1590: p_calling_module IN VARCHAR2 :='SELF SERVICE' ,

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

1583:
1584: PROCEDURE update_lifecycle_phase (
1585: P_api_version IN NUMBER :=1.0 ,
1586: p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE ,
1587: p_commit IN VARCHAR2 :=FND_API.G_FALSE ,
1588: p_validate_only IN VARCHAR2 :=FND_API.G_TRUE ,
1589: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL ,
1590: p_calling_module IN VARCHAR2 :='SELF SERVICE' ,
1591: p_debug_mode IN VARCHAR2 :='N' ,

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

1584: PROCEDURE update_lifecycle_phase (
1585: P_api_version IN NUMBER :=1.0 ,
1586: p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE ,
1587: p_commit IN VARCHAR2 :=FND_API.G_FALSE ,
1588: p_validate_only IN VARCHAR2 :=FND_API.G_TRUE ,
1589: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL ,
1590: p_calling_module IN VARCHAR2 :='SELF SERVICE' ,
1591: p_debug_mode IN VARCHAR2 :='N' ,
1592: P_max_msg_count IN NUMBER :=G_MISS_NUM ,

Line 1589: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL ,

1585: P_api_version IN NUMBER :=1.0 ,
1586: p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE ,
1587: p_commit IN VARCHAR2 :=FND_API.G_FALSE ,
1588: p_validate_only IN VARCHAR2 :=FND_API.G_TRUE ,
1589: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL ,
1590: p_calling_module IN VARCHAR2 :='SELF SERVICE' ,
1591: p_debug_mode IN VARCHAR2 :='N' ,
1592: P_max_msg_count IN NUMBER :=G_MISS_NUM ,
1593: P_lifecycle_id IN NUMBER ,

Line 1625: l_update_ok VARCHAR2(1) := FND_API.G_FALSE;

1621: l_org_phase_code VARCHAR2(30);
1622: l_phase_description VARCHAR2(250);
1623: c_object_type CONSTANT VARCHAR(30) := 'PA_TASKS';
1624: c_project_id CONSTANT NUMBER :=0;
1625: l_update_ok VARCHAR2(1) := FND_API.G_FALSE;
1626: l_data_changed boolean := false;
1627:
1628:
1629: CURSOR l_get_phase_csr

Line 1645: IF (p_commit = FND_API.G_TRUE) then

1641: IF(p_debug_mode = 'Y') then
1642: pa_debug.debug('PA_LIFECYCLES_PUB.update_lifecycle_phase : Entered update_lifecycle_phase...');
1643: END IF;
1644:
1645: IF (p_commit = FND_API.G_TRUE) then
1646: SAVEPOINT LCYL_UPD_LC_PHASE_PUB;
1647: END IF;
1648:
1649: IF(p_debug_mode = 'Y') THEN

Line 1653: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version ,

1649: IF(p_debug_mode = 'Y') THEN
1650: pa_debug.debug('PA_LIFECYCLES_PUB.Update_Lifecycle_phases: Checking api compatibility...');
1651: END IF;
1652:
1653: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version ,
1654: p_api_version ,
1655: l_api_name ,
1656: g_pkg_name)
1657: THEN

Line 1658: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1654: p_api_version ,
1655: l_api_name ,
1656: g_pkg_name)
1657: THEN
1658: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1659: END IF;
1660:
1661: x_return_status := FND_API.G_RET_STS_SUCCESS;
1662:

Line 1661: x_return_status := FND_API.G_RET_STS_SUCCESS;

1657: THEN
1658: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1659: END IF;
1660:
1661: x_return_status := FND_API.G_RET_STS_SUCCESS;
1662:
1663:
1664:
1665: -- Initialise message stack

Line 1673: IF FND_API.to_boolean(nvl(p_init_msg_list, FND_API.G_FALSE)) THEN

1669: END IF;
1670:
1671: pa_debug.init_err_stack('PA_LIFECYCLES_PUB.UPDATE_LIFECYCLE_PHASE');
1672:
1673: IF FND_API.to_boolean(nvl(p_init_msg_list, FND_API.G_FALSE)) THEN
1674: fnd_msg_pub.initialize;
1675: END IF;
1676:
1677: IF(p_debug_mode = 'Y') THEN

Line 1699: x_return_status := FND_API.G_RET_STS_ERROR;

1695: when NO_DATA_FOUND then
1696: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
1697: p_msg_name => 'PA_LCYL_PHASE_NOT_VALID');
1698: x_msg_data := 'PA_LCYL_PHASE_NOT_VALID';
1699: x_return_status := FND_API.G_RET_STS_ERROR;
1700: END;
1701:
1702:
1703: IF(p_debug_mode = 'Y') THEN

Line 1713: x_return_status := FND_API.G_RET_STS_ERROR;

1709: THEN
1710: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
1711: p_msg_name => 'PA_LCYL_PHASE_NAME_REQUIRED');
1712: x_msg_data := 'PA_LCYL_PHASE_NAME_REQUIRED';
1713: x_return_status := FND_API.G_RET_STS_ERROR;
1714: ELSIF(P_phase_name <> G_MISS_CHAR) then
1715: IF l_phase_name <> P_phase_name THEN
1716: l_data_changed := true;
1717: END IF;

Line 1726: x_return_status := FND_API.G_RET_STS_ERROR;

1722: THEN
1723: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
1724: p_msg_name => 'PA_LCYL_PHASE_SHORT_NAME_REQ');
1725: x_msg_data := 'PA_LCYL_PHASE_SHORT_NAME_REQ';
1726: x_return_status := FND_API.G_RET_STS_ERROR;
1727: elsif(P_phase_short_name <> G_MISS_CHAR) then
1728: IF l_phase_short_name <> P_phase_short_name THEN
1729: l_data_changed := true;
1730: END IF;

Line 1739: x_return_status := FND_API.G_RET_STS_ERROR;

1735: THEN
1736: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
1737: p_msg_name => 'PA_LCYL_PHASE_NOT_VALID');
1738: x_msg_data := 'PA_LCYL_PHASE_NOT_VALID';
1739: x_return_status := FND_API.G_RET_STS_ERROR;
1740: ELSIF (P_phase_status_name <> G_MISS_CHAR)
1741: THEN
1742: OPEN l_get_phase_csr;
1743: FETCH l_get_phase_csr INTO l_new_phase_code;

Line 1750: x_return_status := FND_API.G_RET_STS_ERROR;

1746: IF(l_new_phase_code is null) THEN
1747: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
1748: p_msg_name => 'PA_LCYL_PHASE_NOT_VALID');
1749: x_msg_data := 'PA_LCYL_PHASE_NOT_VALID';
1750: x_return_status := FND_API.G_RET_STS_ERROR;
1751: END IF;
1752:
1753: IF l_phase_code <> l_new_phase_code THEN
1754: l_data_changed := true;

Line 1764: x_return_status := FND_API.G_RET_STS_ERROR;

1760: THEN
1761: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
1762: p_msg_name => 'PA_LCYL_PHASE_SEQ_NO_REQ');
1763: x_msg_data := 'PA_LCYL_PHASE_SEQ_NO_REQ';
1764: x_return_status := FND_API.G_RET_STS_ERROR;
1765: elsif(P_phase_display_sequence <> G_MISS_NUM) then
1766: IF l_seqn <> P_phase_display_sequence THEN
1767: l_data_changed := true;
1768: END IF;

Line 1790: x_return_status := FND_API.G_RET_STS_ERROR;

1786: IF (NOT (l_data_changed)) THEN
1787: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
1788: p_msg_name => 'PA_NO_CHANGES_TO_UPDATE');
1789: x_msg_data := 'PA_NO_CHANGES_TO_UPDATE';
1790: x_return_status := FND_API.G_RET_STS_ERROR;
1791: END IF;
1792: */
1793:
1794: IF (p_debug_mode = 'Y') THEN

Line 1804: (p_encoded => FND_API.G_TRUE ,

1800: If l_msg_count > 0 THEN
1801: x_msg_count := l_msg_count;
1802: If l_msg_count = 1 THEN
1803: pa_interface_utils_pub.get_messages
1804: (p_encoded => FND_API.G_TRUE ,
1805: p_msg_index => 1 ,
1806: p_msg_count => l_msg_count ,
1807: p_msg_data => l_msg_data ,
1808: p_data => l_data ,

Line 1812: RAISE FND_API.G_EXC_ERROR;

1808: p_data => l_data ,
1809: p_msg_index_out => l_msg_index_out );
1810: x_msg_data := l_data;
1811: End if;
1812: RAISE FND_API.G_EXC_ERROR;
1813: End if;
1814:
1815: IF ((P_phase_display_sequence <> G_MISS_NUM AND l_seqn <> l_org_seq)
1816: OR (P_phase_status_name <> G_MISS_CHAR AND l_phase_code <> l_org_phase_code))

Line 1843: (p_encoded => FND_API.G_TRUE ,

1839: If l_msg_count > 0 THEN
1840: x_msg_count := l_msg_count;
1841: If l_msg_count = 1 THEN
1842: pa_interface_utils_pub.get_messages
1843: (p_encoded => FND_API.G_TRUE ,
1844: p_msg_index => 1,
1845: p_msg_count => l_msg_count ,
1846: p_msg_data => l_msg_data,
1847: p_data => l_data,

Line 1851: RAISE FND_API.G_EXC_ERROR;

1847: p_data => l_data,
1848: p_msg_index_out => l_msg_index_out );
1849: x_msg_data := l_data;
1850: End if;
1851: RAISE FND_API.G_EXC_ERROR;
1852: End if;
1853:
1854: IF (l_update_ok <>FND_API.G_TRUE) THEN
1855: RAISE FND_API.G_EXC_ERROR;

Line 1854: IF (l_update_ok <>FND_API.G_TRUE) THEN

1850: End if;
1851: RAISE FND_API.G_EXC_ERROR;
1852: End if;
1853:
1854: IF (l_update_ok <>FND_API.G_TRUE) THEN
1855: RAISE FND_API.G_EXC_ERROR;
1856: END IF;
1857:
1858: END IF;

Line 1855: RAISE FND_API.G_EXC_ERROR;

1851: RAISE FND_API.G_EXC_ERROR;
1852: End if;
1853:
1854: IF (l_update_ok <>FND_API.G_TRUE) THEN
1855: RAISE FND_API.G_EXC_ERROR;
1856: END IF;
1857:
1858: END IF;
1859:

Line 1896: (p_encoded => FND_API.G_TRUE ,

1892: If l_msg_count > 0 THEN
1893: x_msg_count := l_msg_count;
1894: If l_msg_count = 1 THEN
1895: pa_interface_utils_pub.get_messages
1896: (p_encoded => FND_API.G_TRUE ,
1897: p_msg_index => 1,
1898: p_msg_count => l_msg_count ,
1899: p_msg_data => l_msg_data,
1900: p_data => l_data,

Line 1904: RAISE FND_API.G_EXC_ERROR;

1900: p_data => l_data,
1901: p_msg_index_out => l_msg_index_out );
1902: x_msg_data := l_data;
1903: End if;
1904: RAISE FND_API.G_EXC_ERROR;
1905: End if;
1906:
1907: x_return_status := FND_API.G_RET_STS_SUCCESS;
1908:

Line 1907: x_return_status := FND_API.G_RET_STS_SUCCESS;

1903: End if;
1904: RAISE FND_API.G_EXC_ERROR;
1905: End if;
1906:
1907: x_return_status := FND_API.G_RET_STS_SUCCESS;
1908:
1909:
1910: IF FND_API.TO_BOOLEAN(P_COMMIT) THEN
1911: COMMIT;

Line 1910: IF FND_API.TO_BOOLEAN(P_COMMIT) THEN

1906:
1907: x_return_status := FND_API.G_RET_STS_SUCCESS;
1908:
1909:
1910: IF FND_API.TO_BOOLEAN(P_COMMIT) THEN
1911: COMMIT;
1912: END IF;
1913:
1914:

Line 1916: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1912: END IF;
1913:
1914:
1915: EXCEPTION
1916: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1917: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1918: IF p_commit = FND_API.G_TRUE THEN
1919: ROLLBACK TO LCYL_UPD_LC_PHASE_PUB;
1920: END IF;

Line 1917: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1913:
1914:
1915: EXCEPTION
1916: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1917: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1918: IF p_commit = FND_API.G_TRUE THEN
1919: ROLLBACK TO LCYL_UPD_LC_PHASE_PUB;
1920: END IF;
1921:

Line 1918: IF p_commit = FND_API.G_TRUE THEN

1914:
1915: EXCEPTION
1916: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1917: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1918: IF p_commit = FND_API.G_TRUE THEN
1919: ROLLBACK TO LCYL_UPD_LC_PHASE_PUB;
1920: END IF;
1921:
1922: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_LIFECYCLES_PUB',

Line 1925: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1921:
1922: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_LIFECYCLES_PUB',
1923: p_procedure_name => 'UPDATE_LIFECYCLE_PHASE',
1924: p_error_text => SUBSTRB(SQLERRM,1,240));
1925: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1926:
1927: WHEN FND_API.G_EXC_ERROR THEN
1928: x_return_status := FND_API.G_RET_STS_ERROR;
1929: IF p_commit = FND_API.G_TRUE THEN

Line 1927: WHEN FND_API.G_EXC_ERROR THEN

1923: p_procedure_name => 'UPDATE_LIFECYCLE_PHASE',
1924: p_error_text => SUBSTRB(SQLERRM,1,240));
1925: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1926:
1927: WHEN FND_API.G_EXC_ERROR THEN
1928: x_return_status := FND_API.G_RET_STS_ERROR;
1929: IF p_commit = FND_API.G_TRUE THEN
1930: ROLLBACK TO LCYL_UPD_LC_PHASE_PUB;
1931: END IF;

Line 1928: x_return_status := FND_API.G_RET_STS_ERROR;

1924: p_error_text => SUBSTRB(SQLERRM,1,240));
1925: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1926:
1927: WHEN FND_API.G_EXC_ERROR THEN
1928: x_return_status := FND_API.G_RET_STS_ERROR;
1929: IF p_commit = FND_API.G_TRUE THEN
1930: ROLLBACK TO LCYL_UPD_LC_PHASE_PUB;
1931: END IF;
1932:

Line 1929: IF p_commit = FND_API.G_TRUE THEN

1925: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1926:
1927: WHEN FND_API.G_EXC_ERROR THEN
1928: x_return_status := FND_API.G_RET_STS_ERROR;
1929: IF p_commit = FND_API.G_TRUE THEN
1930: ROLLBACK TO LCYL_UPD_LC_PHASE_PUB;
1931: END IF;
1932:
1933: WHEN OTHERS THEN

Line 1934: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1930: ROLLBACK TO LCYL_UPD_LC_PHASE_PUB;
1931: END IF;
1932:
1933: WHEN OTHERS THEN
1934: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1935: IF p_commit = FND_API.G_TRUE THEN
1936: ROLLBACK TO LCYL_UPD_LC_PHASE_PUB;
1937: END IF;
1938: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_LIFECYCLES_PUB',

Line 1935: IF p_commit = FND_API.G_TRUE THEN

1931: END IF;
1932:
1933: WHEN OTHERS THEN
1934: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1935: IF p_commit = FND_API.G_TRUE THEN
1936: ROLLBACK TO LCYL_UPD_LC_PHASE_PUB;
1937: END IF;
1938: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_LIFECYCLES_PUB',
1939: p_procedure_name => 'UPDATE_LIFECYCLE_PHASE',