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

Line 12: -- p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE

8: -- Pre-reqs : None
9: -- Return Value : N/A
10: -- Parameters
11: -- p_api_version IN NUMBER := 1.0
12: -- p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
13: -- p_commit IN VARCHAR2 := FND_API.G_FALSE
14: -- p_validate_only IN VARCHAR2 := FND_API.G_TRUE
15: -- p_validation_level IN VARCHAR2 := 100
16: -- p_calling_module IN VARCHAR2 := 'SELF_SERVICE'

Line 13: -- p_commit IN VARCHAR2 := FND_API.G_FALSE

9: -- Return Value : N/A
10: -- Parameters
11: -- p_api_version IN NUMBER := 1.0
12: -- p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
13: -- p_commit IN VARCHAR2 := FND_API.G_FALSE
14: -- p_validate_only IN VARCHAR2 := FND_API.G_TRUE
15: -- p_validation_level IN VARCHAR2 := 100
16: -- p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
17: -- p_debug_mode IN VARCHAR2 := 'N'

Line 14: -- p_validate_only IN VARCHAR2 := FND_API.G_TRUE

10: -- Parameters
11: -- p_api_version IN NUMBER := 1.0
12: -- p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
13: -- p_commit IN VARCHAR2 := FND_API.G_FALSE
14: -- p_validate_only IN VARCHAR2 := FND_API.G_TRUE
15: -- p_validation_level IN VARCHAR2 := 100
16: -- p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
17: -- p_debug_mode IN VARCHAR2 := 'N'
18: -- p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

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

53:
54: procedure Create_Relationship
55: (
56: p_api_version IN NUMBER := 1.0
57: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
58: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
59: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
60: ,p_validation_level IN VARCHAR2 := 100
61: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'

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

54: procedure Create_Relationship
55: (
56: p_api_version IN NUMBER := 1.0
57: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
58: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
59: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
60: ,p_validation_level IN VARCHAR2 := 100
61: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
62: ,p_debug_mode IN VARCHAR2 := 'N'

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

55: (
56: p_api_version IN NUMBER := 1.0
57: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
58: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
59: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
60: ,p_validation_level IN VARCHAR2 := 100
61: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
62: ,p_debug_mode IN VARCHAR2 := 'N'
63: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

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

118: IF (p_debug_mode = 'Y') THEN
119: pa_debug.debug('PA_RELATIONSHIP_PUB.CREATE_RELATIONSHIP begin');
120: END IF;
121:
122: IF (p_commit = FND_API.G_TRUE) THEN
123: savepoint create_relationship;
124: END IF;
125:
126: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version, p_api_version, l_api_name, g_pkg_name) then

Line 126: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version, p_api_version, l_api_name, g_pkg_name) then

122: IF (p_commit = FND_API.G_TRUE) THEN
123: savepoint create_relationship;
124: END IF;
125:
126: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version, p_api_version, l_api_name, g_pkg_name) then
127: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
128: END IF;
129:
130: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN

Line 127: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

123: savepoint create_relationship;
124: END IF;
125:
126: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version, p_api_version, l_api_name, g_pkg_name) then
127: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
128: END IF;
129:
130: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN
131: FND_MSG_PUB.initialize;

Line 130: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN

126: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version, p_api_version, l_api_name, g_pkg_name) then
127: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
128: END IF;
129:
130: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN
131: FND_MSG_PUB.initialize;
132: END IF;
133:
134:

Line 148: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

144: ,x_project_id => l_project_id_from
145: ,x_return_status => l_return_status
146: ,x_error_msg_code => l_error_msg_code
147: );
148: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
149: PA_UTILS.ADD_MESSAGE( 'PA', l_error_msg_code);
150: END IF;
151: END IF;
152:

Line 166: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

162: ,x_project_id => l_project_id_to
163: ,x_return_status => l_return_status
164: ,x_error_msg_code => l_error_msg_code
165: );
166: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
167: PA_UTILS.ADD_MESSAGE( 'PA', l_error_msg_code);
168: END IF;
169: END IF;
170:

Line 184: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

180: ,x_structure_id => l_structure_id_from
181: ,x_return_status => l_return_status
182: ,x_error_message_code => l_error_msg_code
183: );
184: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
185: PA_UTILS.ADD_MESSAGE( 'PA', l_error_msg_code);
186: END IF;
187: END IF;
188:

Line 202: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

198: ,x_structure_id => l_structure_id_to
199: ,x_return_status => l_return_status
200: ,x_error_message_code => l_error_msg_code
201: );
202: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
203: PA_UTILS.ADD_MESSAGE( 'PA', l_error_msg_code);
204: END IF;
205: END IF;
206:

Line 223: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

219: ,x_structure_version_id => l_struc_ver_id_from
220: ,x_return_status => l_return_status
221: ,x_error_message_code => l_error_msg_code
222: );
223: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
224: -- error_msg('structure version from ');
225: PA_UTILS.ADD_MESSAGE( 'PA', l_error_msg_code);
226: END IF;
227: END IF;

Line 243: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

239: ,x_structure_version_id => l_struc_ver_id_to
240: ,x_return_status => l_return_status
241: ,x_error_message_code => l_error_msg_code
242: );
243: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
244: -- error_msg('structure version to ');
245: PA_UTILS.ADD_MESSAGE( 'PA', l_error_msg_code);
246: END IF;
247: END IF;

Line 263: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

259: ,x_return_status => l_return_status
260: ,x_error_msg_code => l_error_msg_code
261: );
262:
263: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
264: PA_UTILS.ADD_MESSAGE( 'PA', l_error_msg_code);
265: END IF;
266: END IF;
267:

Line 282: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

278: ,x_return_status => l_return_status
279: ,x_error_msg_code => l_error_msg_code
280: );
281:
282: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
283: PA_UTILS.ADD_MESSAGE( 'PA', l_error_msg_code);
284: END IF;
285: END IF;
286:

Line 291: (p_encoded => FND_API.G_TRUE,

287: x_msg_count := FND_MSG_PUB.count_msg;
288: IF x_msg_count > 0 THEN
289: If x_msg_count > 1 then
290: pa_interface_utils_pub.get_messages
291: (p_encoded => FND_API.G_TRUE,
292: p_msg_index => 1,
293: p_msg_count => l_msg_count,
294: p_msg_data => l_msg_data,
295: p_data => l_data,

Line 299: raise FND_API.G_EXC_ERROR;

295: p_data => l_data,
296: p_msg_index_out => l_msg_index_out);
297: x_msg_data := l_data;
298: END IF;
299: raise FND_API.G_EXC_ERROR;
300: END IF;
301:
302:
303: PA_RELATIONSHIP_PVT.Create_Relationship(

Line 334: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

330: ,x_msg_count => l_msg_count
331: ,x_msg_data => l_msg_data
332: );
333:
334: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
335: x_msg_count := FND_MSG_PUB.count_msg;
336: IF x_msg_count = 1 then
337: pa_interface_utils_pub.get_messages
338: (p_encoded => FND_API.G_TRUE,

Line 338: (p_encoded => FND_API.G_TRUE,

334: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
335: x_msg_count := FND_MSG_PUB.count_msg;
336: IF x_msg_count = 1 then
337: pa_interface_utils_pub.get_messages
338: (p_encoded => FND_API.G_TRUE,
339: p_msg_index => 1,
340: p_msg_count => l_msg_count,
341: p_msg_data => l_msg_data,
342: p_data => l_data,

Line 346: raise FND_API.G_EXC_ERROR;

342: p_data => l_data,
343: p_msg_index_out => l_msg_index_out);
344: x_msg_data := l_data;
345: END IF;
346: raise FND_API.G_EXC_ERROR;
347: END IF;
348:
349: x_object_relationship_id := l_object_relationship_id;
350: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 350: x_return_status := FND_API.G_RET_STS_SUCCESS;

346: raise FND_API.G_EXC_ERROR;
347: END IF;
348:
349: x_object_relationship_id := l_object_relationship_id;
350: x_return_status := FND_API.G_RET_STS_SUCCESS;
351:
352: IF (p_commit = FND_API.G_TRUE) THEN
353: COMMIT;
354: END IF;

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

348:
349: x_object_relationship_id := l_object_relationship_id;
350: x_return_status := FND_API.G_RET_STS_SUCCESS;
351:
352: IF (p_commit = FND_API.G_TRUE) THEN
353: COMMIT;
354: END IF;
355:
356: IF (p_debug_mode = 'Y') THEN

Line 361: when FND_API.G_EXC_ERROR then

357: pa_debug.debug('PA_RELATIONSHIP_PUB.CREATE_RELATIONSHIP END');
358: END IF;
359:
360: EXCEPTION
361: when FND_API.G_EXC_ERROR then
362: if p_commit = FND_API.G_TRUE then
363: rollback to create_relationship;
364: end if;
365: x_return_status := FND_API.G_RET_STS_ERROR;

Line 362: if p_commit = FND_API.G_TRUE then

358: END IF;
359:
360: EXCEPTION
361: when FND_API.G_EXC_ERROR then
362: if p_commit = FND_API.G_TRUE then
363: rollback to create_relationship;
364: end if;
365: x_return_status := FND_API.G_RET_STS_ERROR;
366: when FND_API.G_EXC_UNEXPECTED_ERROR then

Line 365: x_return_status := FND_API.G_RET_STS_ERROR;

361: when FND_API.G_EXC_ERROR then
362: if p_commit = FND_API.G_TRUE then
363: rollback to create_relationship;
364: end if;
365: x_return_status := FND_API.G_RET_STS_ERROR;
366: when FND_API.G_EXC_UNEXPECTED_ERROR then
367: if p_commit = FND_API.G_TRUE then
368: rollback to create_relationship;
369: end if;

Line 366: when FND_API.G_EXC_UNEXPECTED_ERROR then

362: if p_commit = FND_API.G_TRUE then
363: rollback to create_relationship;
364: end if;
365: x_return_status := FND_API.G_RET_STS_ERROR;
366: when FND_API.G_EXC_UNEXPECTED_ERROR then
367: if p_commit = FND_API.G_TRUE then
368: rollback to create_relationship;
369: end if;
370: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 367: if p_commit = FND_API.G_TRUE then

363: rollback to create_relationship;
364: end if;
365: x_return_status := FND_API.G_RET_STS_ERROR;
366: when FND_API.G_EXC_UNEXPECTED_ERROR then
367: if p_commit = FND_API.G_TRUE then
368: rollback to create_relationship;
369: end if;
370: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
371: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_RELATIONSHIP_PUB',

Line 370: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

366: when FND_API.G_EXC_UNEXPECTED_ERROR then
367: if p_commit = FND_API.G_TRUE then
368: rollback to create_relationship;
369: end if;
370: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
371: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_RELATIONSHIP_PUB',
372: p_procedure_name => 'CREATE_RELATIONSHIP',
373: p_error_text => SUBSTRB(SQLERRM,1,240));
374: when OTHERS then

Line 375: if p_commit = FND_API.G_TRUE then

371: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_RELATIONSHIP_PUB',
372: p_procedure_name => 'CREATE_RELATIONSHIP',
373: p_error_text => SUBSTRB(SQLERRM,1,240));
374: when OTHERS then
375: if p_commit = FND_API.G_TRUE then
376: rollback to create_relationship;
377: end if;
378: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
379: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_RELATIONSHIOP_PUB',

Line 378: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

374: when OTHERS then
375: if p_commit = FND_API.G_TRUE then
376: rollback to create_relationship;
377: end if;
378: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
379: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_RELATIONSHIOP_PUB',
380: p_procedure_name => 'CREATE_RELATIONSHIP',
381: p_error_text => SUBSTRB(SQLERRM,1,240));
382: raise;

Line 393: -- p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE

389: -- Pre-reqs : None
390: -- Return Value : N/A
391: -- Parameters
392: -- p_api_version IN NUMBER := 1.0
393: -- p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
394: -- p_commit IN VARCHAR2 := FND_API.G_FALSE
395: -- p_validate_only IN VARCHAR2 := FND_API.G_TRUE
396: -- p_validation_level IN VARCHAR2 := 100
397: -- p_calling_module IN VARCHAR2 := 'SELF_SERVICE'

Line 394: -- p_commit IN VARCHAR2 := FND_API.G_FALSE

390: -- Return Value : N/A
391: -- Parameters
392: -- p_api_version IN NUMBER := 1.0
393: -- p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
394: -- p_commit IN VARCHAR2 := FND_API.G_FALSE
395: -- p_validate_only IN VARCHAR2 := FND_API.G_TRUE
396: -- p_validation_level IN VARCHAR2 := 100
397: -- p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
398: -- p_debug_mode IN VARCHAR2 := 'N'

Line 395: -- p_validate_only IN VARCHAR2 := FND_API.G_TRUE

391: -- Parameters
392: -- p_api_version IN NUMBER := 1.0
393: -- p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
394: -- p_commit IN VARCHAR2 := FND_API.G_FALSE
395: -- p_validate_only IN VARCHAR2 := FND_API.G_TRUE
396: -- p_validation_level IN VARCHAR2 := 100
397: -- p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
398: -- p_debug_mode IN VARCHAR2 := 'N'
399: -- p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

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

412:
413: procedure Delete_Relationship
414: (
415: p_api_version IN NUMBER := 1.0
416: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
417: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
418: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
419: ,p_validation_level IN VARCHAR2 := 100
420: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'

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

413: procedure Delete_Relationship
414: (
415: p_api_version IN NUMBER := 1.0
416: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
417: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
418: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
419: ,p_validation_level IN VARCHAR2 := 100
420: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
421: ,p_debug_mode IN VARCHAR2 := 'N'

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

414: (
415: p_api_version IN NUMBER := 1.0
416: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
417: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
418: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
419: ,p_validation_level IN VARCHAR2 := 100
420: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
421: ,p_debug_mode IN VARCHAR2 := 'N'
422: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

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

443: IF (p_debug_mode = 'Y') THEN
444: pa_debug.debug('PA_RELATIONSHIP_PUB.DELETE_RELATIONSHIP begin');
445: END IF;
446:
447: IF (p_commit = FND_API.G_TRUE) THEN
448: savepoint delete_relationship;
449: END IF;
450:
451: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version, p_api_version, l_api_name, g_pkg_name) then

Line 451: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version, p_api_version, l_api_name, g_pkg_name) then

447: IF (p_commit = FND_API.G_TRUE) THEN
448: savepoint delete_relationship;
449: END IF;
450:
451: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version, p_api_version, l_api_name, g_pkg_name) then
452: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
453: END IF;
454:
455: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN

Line 452: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

448: savepoint delete_relationship;
449: END IF;
450:
451: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version, p_api_version, l_api_name, g_pkg_name) then
452: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
453: END IF;
454:
455: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN
456: FND_MSG_PUB.initialize;

Line 455: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN

451: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version, p_api_version, l_api_name, g_pkg_name) then
452: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
453: END IF;
454:
455: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN
456: FND_MSG_PUB.initialize;
457: END IF;
458:
459: PA_RELATIONSHIP_PVT.Delete_Relationship(

Line 475: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

471: ,x_msg_count => l_msg_count
472: ,x_msg_data => l_msg_data
473: );
474:
475: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
476: x_msg_count := FND_MSG_PUB.count_msg;
477: IF x_msg_count = 1 then
478: pa_interface_utils_pub.get_messages
479: (p_encoded => FND_API.G_TRUE,

Line 479: (p_encoded => FND_API.G_TRUE,

475: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
476: x_msg_count := FND_MSG_PUB.count_msg;
477: IF x_msg_count = 1 then
478: pa_interface_utils_pub.get_messages
479: (p_encoded => FND_API.G_TRUE,
480: p_msg_index => 1,
481: p_msg_count => l_msg_count,
482: p_msg_data => l_msg_data,
483: p_data => l_data,

Line 487: raise FND_API.G_EXC_ERROR;

483: p_data => l_data,
484: p_msg_index_out => l_msg_index_out);
485: x_msg_data := l_data;
486: END IF;
487: raise FND_API.G_EXC_ERROR;
488: END IF;
489:
490: x_return_status := FND_API.G_RET_STS_SUCCESS;
491:

Line 490: x_return_status := FND_API.G_RET_STS_SUCCESS;

486: END IF;
487: raise FND_API.G_EXC_ERROR;
488: END IF;
489:
490: x_return_status := FND_API.G_RET_STS_SUCCESS;
491:
492: EXCEPTION
493: when FND_API.G_EXC_ERROR then
494: if p_commit = FND_API.G_TRUE then

Line 493: when FND_API.G_EXC_ERROR then

489:
490: x_return_status := FND_API.G_RET_STS_SUCCESS;
491:
492: EXCEPTION
493: when FND_API.G_EXC_ERROR then
494: if p_commit = FND_API.G_TRUE then
495: rollback to delete_relationship;
496: end if;
497: x_return_status := FND_API.G_RET_STS_ERROR;

Line 494: if p_commit = FND_API.G_TRUE then

490: x_return_status := FND_API.G_RET_STS_SUCCESS;
491:
492: EXCEPTION
493: when FND_API.G_EXC_ERROR then
494: if p_commit = FND_API.G_TRUE then
495: rollback to delete_relationship;
496: end if;
497: x_return_status := FND_API.G_RET_STS_ERROR;
498: when FND_API.G_EXC_UNEXPECTED_ERROR then

Line 497: x_return_status := FND_API.G_RET_STS_ERROR;

493: when FND_API.G_EXC_ERROR then
494: if p_commit = FND_API.G_TRUE then
495: rollback to delete_relationship;
496: end if;
497: x_return_status := FND_API.G_RET_STS_ERROR;
498: when FND_API.G_EXC_UNEXPECTED_ERROR then
499: if p_commit = FND_API.G_TRUE then
500: rollback to delete_relationship;
501: end if;

Line 498: when FND_API.G_EXC_UNEXPECTED_ERROR then

494: if p_commit = FND_API.G_TRUE then
495: rollback to delete_relationship;
496: end if;
497: x_return_status := FND_API.G_RET_STS_ERROR;
498: when FND_API.G_EXC_UNEXPECTED_ERROR then
499: if p_commit = FND_API.G_TRUE then
500: rollback to delete_relationship;
501: end if;
502: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 499: if p_commit = FND_API.G_TRUE then

495: rollback to delete_relationship;
496: end if;
497: x_return_status := FND_API.G_RET_STS_ERROR;
498: when FND_API.G_EXC_UNEXPECTED_ERROR then
499: if p_commit = FND_API.G_TRUE then
500: rollback to delete_relationship;
501: end if;
502: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
503: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_RELATIONSHIP_PUB',

Line 502: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

498: when FND_API.G_EXC_UNEXPECTED_ERROR then
499: if p_commit = FND_API.G_TRUE then
500: rollback to delete_relationship;
501: end if;
502: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
503: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_RELATIONSHIP_PUB',
504: p_procedure_name => 'DELETE_RELATIONSHIP',
505: p_error_text => SUBSTRB(SQLERRM,1,240));
506: when OTHERS then

Line 507: if p_commit = FND_API.G_TRUE then

503: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_RELATIONSHIP_PUB',
504: p_procedure_name => 'DELETE_RELATIONSHIP',
505: p_error_text => SUBSTRB(SQLERRM,1,240));
506: when OTHERS then
507: if p_commit = FND_API.G_TRUE then
508: rollback to delete_relationship;
509: end if;
510: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
511: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_RELATIONSHIOP_PUB',

Line 510: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

506: when OTHERS then
507: if p_commit = FND_API.G_TRUE then
508: rollback to delete_relationship;
509: end if;
510: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
511: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_RELATIONSHIOP_PUB',
512: p_procedure_name => 'DEKETE_RELATIONSHIP',
513: p_error_text => SUBSTRB(SQLERRM,1,240));
514: raise;

Line 524: -- p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE

520: -- Pre-reqs : None
521: -- Return Value : N/A
522: -- Parameters
523: -- p_api_version IN NUMBER := 1.0
524: -- p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
525: -- p_commit IN VARCHAR2 := FND_API.G_FALSE
526: -- p_validate_only IN VARCHAR2 := FND_API.G_TRUE
527: -- p_validation_level IN VARCHAR2 := 100
528: -- p_calling_module IN VARCHAR2 := 'SELF_SERVICE'

Line 525: -- p_commit IN VARCHAR2 := FND_API.G_FALSE

521: -- Return Value : N/A
522: -- Parameters
523: -- p_api_version IN NUMBER := 1.0
524: -- p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
525: -- p_commit IN VARCHAR2 := FND_API.G_FALSE
526: -- p_validate_only IN VARCHAR2 := FND_API.G_TRUE
527: -- p_validation_level IN VARCHAR2 := 100
528: -- p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
529: -- p_debug_mode IN VARCHAR2 := 'N'

Line 526: -- p_validate_only IN VARCHAR2 := FND_API.G_TRUE

522: -- Parameters
523: -- p_api_version IN NUMBER := 1.0
524: -- p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
525: -- p_commit IN VARCHAR2 := FND_API.G_FALSE
526: -- p_validate_only IN VARCHAR2 := FND_API.G_TRUE
527: -- p_validation_level IN VARCHAR2 := 100
528: -- p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
529: -- p_debug_mode IN VARCHAR2 := 'N'
530: -- p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

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

550:
551: procedure Create_dependency
552: (
553: p_api_version IN NUMBER := 1.0
554: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
555: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
556: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
557: ,p_validation_level IN VARCHAR2 := 100
558: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'

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

551: procedure Create_dependency
552: (
553: p_api_version IN NUMBER := 1.0
554: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
555: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
556: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
557: ,p_validation_level IN VARCHAR2 := 100
558: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
559: ,p_debug_mode IN VARCHAR2 := 'N'

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

552: (
553: p_api_version IN NUMBER := 1.0
554: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
555: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
556: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
557: ,p_validation_level IN VARCHAR2 := 100
558: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
559: ,p_debug_mode IN VARCHAR2 := 'N'
560: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

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

607: IF (p_debug_mode = 'Y') THEN
608: pa_debug.debug('PA_RELATIONSHIP_PUB.CREATE_DEPENDENCY begin');
609: END IF;
610:
611: IF (p_commit = FND_API.G_TRUE) THEN
612: savepoint create_dependency;
613: END IF;
614:
615: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version, p_api_version, l_api_name, g_pkg_name) then

Line 615: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version, p_api_version, l_api_name, g_pkg_name) then

611: IF (p_commit = FND_API.G_TRUE) THEN
612: savepoint create_dependency;
613: END IF;
614:
615: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version, p_api_version, l_api_name, g_pkg_name) then
616: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
617: END IF;
618:
619: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN

Line 616: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

612: savepoint create_dependency;
613: END IF;
614:
615: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version, p_api_version, l_api_name, g_pkg_name) then
616: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
617: END IF;
618:
619: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN
620: FND_MSG_PUB.initialize;

Line 619: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN

615: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version, p_api_version, l_api_name, g_pkg_name) then
616: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
617: END IF;
618:
619: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN
620: FND_MSG_PUB.initialize;
621: END IF;
622:
623: IF p_src_proj_id IS NULL

Line 626: RAISE FND_API.G_EXC_ERROR;

622:
623: IF p_src_proj_id IS NULL
624: THEN
625: PA_UTILS.ADD_MESSAGE( 'PA', 'PA_PS_SRC_PROJ_NULL');
626: RAISE FND_API.G_EXC_ERROR;
627: END IF;
628:
629: IF p_src_task_ver_id IS NULL
630: THEN

Line 632: RAISE FND_API.G_EXC_ERROR;

628:
629: IF p_src_task_ver_id IS NULL
630: THEN
631: PA_UTILS.ADD_MESSAGE( 'PA', 'PA_PS_SRC_TASK_VER_NULL');
632: RAISE FND_API.G_EXC_ERROR;
633: END IF;
634:
635: --project name to id conversion
636: IF ((p_dest_proj_name <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) AND

Line 648: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

644: ,x_project_id => l_dest_proj_id
645: ,x_return_status => l_return_status
646: ,x_error_msg_code => l_error_msg_code
647: );
648: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
649: PA_UTILS.ADD_MESSAGE( 'PA', l_error_msg_code);
650: END IF;
651: ELSE
652: --Throw a message and stop further processing

Line 654: RAISE FND_API.G_EXC_ERROR;

650: END IF;
651: ELSE
652: --Throw a message and stop further processing
653: PA_UTILS.ADD_MESSAGE( 'PA', 'PA_PS_DEST_PROJ_NULL');
654: RAISE FND_API.G_EXC_ERROR;
655: END IF;
656:
657: --If the dependency is created within the structure then get the structure ver of the
658: --source task otherwise get the structure ver as follows

Line 670: RAISE FND_API.G_EXC_ERROR;

666:
667: IF l_structure_ver_id IS NULL
668: THEN
669: PA_UTILS.ADD_MESSAGE( 'PA', 'PA_PS_SRC_PROJ_TSK_INV');
670: RAISE FND_API.G_EXC_ERROR;
671: END IF;
672: ELSE
673: l_structure_ver_id := PA_PROJECT_STRUCTURE_UTILS.GET_LATEST_WP_VERSION(l_dest_proj_id);
674: IF l_structure_ver_id IS NULL

Line 697: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

693: ,x_return_status => l_return_status
694: ,x_error_msg_code => l_error_msg_code
695: ) ;
696:
697: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
698: PA_UTILS.ADD_MESSAGE( 'PA', l_error_msg_code);
699: END IF;
700: ELSE
701: --Throw a message and stop further processing

Line 703: RAISE FND_API.G_EXC_ERROR;

699: END IF;
700: ELSE
701: --Throw a message and stop further processing
702: PA_UTILS.ADD_MESSAGE( 'PA', 'PA_PS_DEST_TASK_NULL');
703: RAISE FND_API.G_EXC_ERROR;
704: END IF;
705:
706: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
707: x_msg_count := FND_MSG_PUB.count_msg;

Line 706: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

702: PA_UTILS.ADD_MESSAGE( 'PA', 'PA_PS_DEST_TASK_NULL');
703: RAISE FND_API.G_EXC_ERROR;
704: END IF;
705:
706: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
707: x_msg_count := FND_MSG_PUB.count_msg;
708: IF x_msg_count = 1 then
709: pa_interface_utils_pub.get_messages
710: (p_encoded => FND_API.G_TRUE,

Line 710: (p_encoded => FND_API.G_TRUE,

706: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
707: x_msg_count := FND_MSG_PUB.count_msg;
708: IF x_msg_count = 1 then
709: pa_interface_utils_pub.get_messages
710: (p_encoded => FND_API.G_TRUE,
711: p_msg_index => 1,
712: p_msg_count => l_msg_count,
713: p_msg_data => l_msg_data,
714: p_data => l_data,

Line 718: raise FND_API.G_EXC_ERROR;

714: p_data => l_data,
715: p_msg_index_out => l_msg_index_out);
716: x_msg_data := l_data;
717: END IF;
718: raise FND_API.G_EXC_ERROR;
719: END IF;
720:
721: --Call private create dependency API here.
722:

Line 745: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

741: ,x_msg_count => l_msg_count
742: ,x_msg_data => l_msg_data
743: );
744:
745: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
746: x_msg_count := FND_MSG_PUB.count_msg;
747: IF x_msg_count = 1 then
748: pa_interface_utils_pub.get_messages
749: (p_encoded => FND_API.G_TRUE,

Line 749: (p_encoded => FND_API.G_TRUE,

745: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
746: x_msg_count := FND_MSG_PUB.count_msg;
747: IF x_msg_count = 1 then
748: pa_interface_utils_pub.get_messages
749: (p_encoded => FND_API.G_TRUE,
750: p_msg_index => 1,
751: p_msg_count => l_msg_count,
752: p_msg_data => l_msg_data,
753: p_data => l_data,

Line 757: raise FND_API.G_EXC_ERROR;

753: p_data => l_data,
754: p_msg_index_out => l_msg_index_out);
755: x_msg_data := l_data;
756: END IF;
757: raise FND_API.G_EXC_ERROR;
758: END IF;
759:
760: x_return_status := FND_API.G_RET_STS_SUCCESS;
761:

Line 760: x_return_status := FND_API.G_RET_STS_SUCCESS;

756: END IF;
757: raise FND_API.G_EXC_ERROR;
758: END IF;
759:
760: x_return_status := FND_API.G_RET_STS_SUCCESS;
761:
762: IF (p_commit = FND_API.G_TRUE) THEN
763: COMMIT;
764: END IF;

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

758: END IF;
759:
760: x_return_status := FND_API.G_RET_STS_SUCCESS;
761:
762: IF (p_commit = FND_API.G_TRUE) THEN
763: COMMIT;
764: END IF;
765:
766: IF (p_debug_mode = 'Y') THEN

Line 771: when FND_API.G_EXC_ERROR then

767: pa_debug.debug('PA_RELATIONSHIP_PUB.CREATE_DEPENDENCY END');
768: END IF;
769:
770: EXCEPTION
771: when FND_API.G_EXC_ERROR then
772: if p_commit = FND_API.G_TRUE then
773: rollback to create_dependency;
774: end if;
775: x_return_status := FND_API.G_RET_STS_ERROR;

Line 772: if p_commit = FND_API.G_TRUE then

768: END IF;
769:
770: EXCEPTION
771: when FND_API.G_EXC_ERROR then
772: if p_commit = FND_API.G_TRUE then
773: rollback to create_dependency;
774: end if;
775: x_return_status := FND_API.G_RET_STS_ERROR;
776: when FND_API.G_EXC_UNEXPECTED_ERROR then

Line 775: x_return_status := FND_API.G_RET_STS_ERROR;

771: when FND_API.G_EXC_ERROR then
772: if p_commit = FND_API.G_TRUE then
773: rollback to create_dependency;
774: end if;
775: x_return_status := FND_API.G_RET_STS_ERROR;
776: when FND_API.G_EXC_UNEXPECTED_ERROR then
777: if p_commit = FND_API.G_TRUE then
778: rollback to create_dependency;
779: end if;

Line 776: when FND_API.G_EXC_UNEXPECTED_ERROR then

772: if p_commit = FND_API.G_TRUE then
773: rollback to create_dependency;
774: end if;
775: x_return_status := FND_API.G_RET_STS_ERROR;
776: when FND_API.G_EXC_UNEXPECTED_ERROR then
777: if p_commit = FND_API.G_TRUE then
778: rollback to create_dependency;
779: end if;
780: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 777: if p_commit = FND_API.G_TRUE then

773: rollback to create_dependency;
774: end if;
775: x_return_status := FND_API.G_RET_STS_ERROR;
776: when FND_API.G_EXC_UNEXPECTED_ERROR then
777: if p_commit = FND_API.G_TRUE then
778: rollback to create_dependency;
779: end if;
780: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
781: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_RELATIONSHIP_PUB',

Line 780: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

776: when FND_API.G_EXC_UNEXPECTED_ERROR then
777: if p_commit = FND_API.G_TRUE then
778: rollback to create_dependency;
779: end if;
780: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
781: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_RELATIONSHIP_PUB',
782: p_procedure_name => 'CREATE_DEPENDENCY',
783: p_error_text => SUBSTRB(SQLERRM,1,240));
784: when OTHERS then

Line 785: if p_commit = FND_API.G_TRUE then

781: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_RELATIONSHIP_PUB',
782: p_procedure_name => 'CREATE_DEPENDENCY',
783: p_error_text => SUBSTRB(SQLERRM,1,240));
784: when OTHERS then
785: if p_commit = FND_API.G_TRUE then
786: rollback to create_dependency;
787: end if;
788: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
789: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_RELATIONSHIOP_PUB',

Line 788: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

784: when OTHERS then
785: if p_commit = FND_API.G_TRUE then
786: rollback to create_dependency;
787: end if;
788: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
789: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_RELATIONSHIOP_PUB',
790: p_procedure_name => 'CREATE_DEPENDENCY',
791: p_error_text => SUBSTRB(SQLERRM,1,240));
792: raise;

Line 801: -- p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE

797: -- Pre-reqs : None
798: -- Return Value : N/A
799: -- Parameters
800: -- p_api_version IN NUMBER := 1.0
801: -- p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
802: -- p_commit IN VARCHAR2 := FND_API.G_FALSE
803: -- p_validate_only IN VARCHAR2 := FND_API.G_TRUE
804: -- p_validation_level IN VARCHAR2 := 100
805: -- p_calling_module IN VARCHAR2 := 'SELF_SERVICE'

Line 802: -- p_commit IN VARCHAR2 := FND_API.G_FALSE

798: -- Return Value : N/A
799: -- Parameters
800: -- p_api_version IN NUMBER := 1.0
801: -- p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
802: -- p_commit IN VARCHAR2 := FND_API.G_FALSE
803: -- p_validate_only IN VARCHAR2 := FND_API.G_TRUE
804: -- p_validation_level IN VARCHAR2 := 100
805: -- p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
806: -- p_debug_mode IN VARCHAR2 := 'N'

Line 803: -- p_validate_only IN VARCHAR2 := FND_API.G_TRUE

799: -- Parameters
800: -- p_api_version IN NUMBER := 1.0
801: -- p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
802: -- p_commit IN VARCHAR2 := FND_API.G_FALSE
803: -- p_validate_only IN VARCHAR2 := FND_API.G_TRUE
804: -- p_validation_level IN VARCHAR2 := 100
805: -- p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
806: -- p_debug_mode IN VARCHAR2 := 'N'
807: -- p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

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

823:
824: procedure Update_dependency
825: (
826: p_api_version IN NUMBER := 1.0
827: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
828: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
829: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
830: ,p_validation_level IN VARCHAR2 := 100
831: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'

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

824: procedure Update_dependency
825: (
826: p_api_version IN NUMBER := 1.0
827: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
828: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
829: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
830: ,p_validation_level IN VARCHAR2 := 100
831: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
832: ,p_debug_mode IN VARCHAR2 := 'N'

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

825: (
826: p_api_version IN NUMBER := 1.0
827: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
828: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
829: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
830: ,p_validation_level IN VARCHAR2 := 100
831: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
832: ,p_debug_mode IN VARCHAR2 := 'N'
833: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

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

857: IF (p_debug_mode = 'Y') THEN
858: pa_debug.debug('PA_RELATIONSHIP_PUB.UPDATE_DEPENDENCY begin');
859: END IF;
860:
861: IF (p_commit = FND_API.G_TRUE) THEN
862: savepoint update_dependency;
863: END IF;
864:
865: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version, p_api_version, l_api_name, g_pkg_name) then

Line 865: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version, p_api_version, l_api_name, g_pkg_name) then

861: IF (p_commit = FND_API.G_TRUE) THEN
862: savepoint update_dependency;
863: END IF;
864:
865: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version, p_api_version, l_api_name, g_pkg_name) then
866: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
867: END IF;
868:
869: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN

Line 866: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

862: savepoint update_dependency;
863: END IF;
864:
865: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version, p_api_version, l_api_name, g_pkg_name) then
866: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
867: END IF;
868:
869: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN
870: FND_MSG_PUB.initialize;

Line 869: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN

865: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version, p_api_version, l_api_name, g_pkg_name) then
866: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
867: END IF;
868:
869: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN
870: FND_MSG_PUB.initialize;
871: END IF;
872:
873: --Call private update dependency API here.

Line 895: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

891: ,x_msg_count => l_msg_count
892: ,x_msg_data => l_msg_data
893: );
894:
895: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
896: x_msg_count := FND_MSG_PUB.count_msg;
897: IF x_msg_count = 1 then
898: pa_interface_utils_pub.get_messages
899: (p_encoded => FND_API.G_TRUE,

Line 899: (p_encoded => FND_API.G_TRUE,

895: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
896: x_msg_count := FND_MSG_PUB.count_msg;
897: IF x_msg_count = 1 then
898: pa_interface_utils_pub.get_messages
899: (p_encoded => FND_API.G_TRUE,
900: p_msg_index => 1,
901: p_msg_count => l_msg_count,
902: p_msg_data => l_msg_data,
903: p_data => l_data,

Line 907: raise FND_API.G_EXC_ERROR;

903: p_data => l_data,
904: p_msg_index_out => l_msg_index_out);
905: x_msg_data := l_data;
906: END IF;
907: raise FND_API.G_EXC_ERROR;
908: END IF;
909:
910: x_return_status := FND_API.G_RET_STS_SUCCESS;
911:

Line 910: x_return_status := FND_API.G_RET_STS_SUCCESS;

906: END IF;
907: raise FND_API.G_EXC_ERROR;
908: END IF;
909:
910: x_return_status := FND_API.G_RET_STS_SUCCESS;
911:
912: IF (p_commit = FND_API.G_TRUE) THEN
913: COMMIT;
914: END IF;

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

908: END IF;
909:
910: x_return_status := FND_API.G_RET_STS_SUCCESS;
911:
912: IF (p_commit = FND_API.G_TRUE) THEN
913: COMMIT;
914: END IF;
915:
916: IF (p_debug_mode = 'Y') THEN

Line 921: when FND_API.G_EXC_ERROR then

917: pa_debug.debug('PA_RELATIONSHIP_PUB.UPDATE_DEPENDENCY END');
918: END IF;
919:
920: EXCEPTION
921: when FND_API.G_EXC_ERROR then
922: if p_commit = FND_API.G_TRUE then
923: rollback to update_dependency;
924: end if;
925: x_return_status := FND_API.G_RET_STS_ERROR;

Line 922: if p_commit = FND_API.G_TRUE then

918: END IF;
919:
920: EXCEPTION
921: when FND_API.G_EXC_ERROR then
922: if p_commit = FND_API.G_TRUE then
923: rollback to update_dependency;
924: end if;
925: x_return_status := FND_API.G_RET_STS_ERROR;
926: when FND_API.G_EXC_UNEXPECTED_ERROR then

Line 925: x_return_status := FND_API.G_RET_STS_ERROR;

921: when FND_API.G_EXC_ERROR then
922: if p_commit = FND_API.G_TRUE then
923: rollback to update_dependency;
924: end if;
925: x_return_status := FND_API.G_RET_STS_ERROR;
926: when FND_API.G_EXC_UNEXPECTED_ERROR then
927: if p_commit = FND_API.G_TRUE then
928: rollback to update_dependency;
929: end if;

Line 926: when FND_API.G_EXC_UNEXPECTED_ERROR then

922: if p_commit = FND_API.G_TRUE then
923: rollback to update_dependency;
924: end if;
925: x_return_status := FND_API.G_RET_STS_ERROR;
926: when FND_API.G_EXC_UNEXPECTED_ERROR then
927: if p_commit = FND_API.G_TRUE then
928: rollback to update_dependency;
929: end if;
930: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 927: if p_commit = FND_API.G_TRUE then

923: rollback to update_dependency;
924: end if;
925: x_return_status := FND_API.G_RET_STS_ERROR;
926: when FND_API.G_EXC_UNEXPECTED_ERROR then
927: if p_commit = FND_API.G_TRUE then
928: rollback to update_dependency;
929: end if;
930: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
931: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_RELATIONSHIP_PUB',

Line 930: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

926: when FND_API.G_EXC_UNEXPECTED_ERROR then
927: if p_commit = FND_API.G_TRUE then
928: rollback to update_dependency;
929: end if;
930: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
931: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_RELATIONSHIP_PUB',
932: p_procedure_name => 'UPDATE_DEPENDENCY',
933: p_error_text => SUBSTRB(SQLERRM,1,240));
934: when OTHERS then

Line 935: if p_commit = FND_API.G_TRUE then

931: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_RELATIONSHIP_PUB',
932: p_procedure_name => 'UPDATE_DEPENDENCY',
933: p_error_text => SUBSTRB(SQLERRM,1,240));
934: when OTHERS then
935: if p_commit = FND_API.G_TRUE then
936: rollback to update_dependency;
937: end if;
938: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
939: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_RELATIONSHIOP_PUB',

Line 938: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

934: when OTHERS then
935: if p_commit = FND_API.G_TRUE then
936: rollback to update_dependency;
937: end if;
938: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
939: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_RELATIONSHIOP_PUB',
940: p_procedure_name => 'UPDATE_DEPENDENCY',
941: p_error_text => SUBSTRB(SQLERRM,1,240));
942: raise;

Line 951: -- p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE

947: -- Pre-reqs : None
948: -- Return Value : N/A
949: -- Parameters
950: -- p_api_version IN NUMBER := 1.0
951: -- p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
952: -- p_commit IN VARCHAR2 := FND_API.G_FALSE
953: -- p_validate_only IN VARCHAR2 := FND_API.G_TRUE
954: -- p_validation_level IN VARCHAR2 := 100
955: -- p_calling_module IN VARCHAR2 := 'SELF_SERVICE'

Line 952: -- p_commit IN VARCHAR2 := FND_API.G_FALSE

948: -- Return Value : N/A
949: -- Parameters
950: -- p_api_version IN NUMBER := 1.0
951: -- p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
952: -- p_commit IN VARCHAR2 := FND_API.G_FALSE
953: -- p_validate_only IN VARCHAR2 := FND_API.G_TRUE
954: -- p_validation_level IN VARCHAR2 := 100
955: -- p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
956: -- p_debug_mode IN VARCHAR2 := 'N'

Line 953: -- p_validate_only IN VARCHAR2 := FND_API.G_TRUE

949: -- Parameters
950: -- p_api_version IN NUMBER := 1.0
951: -- p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
952: -- p_commit IN VARCHAR2 := FND_API.G_FALSE
953: -- p_validate_only IN VARCHAR2 := FND_API.G_TRUE
954: -- p_validation_level IN VARCHAR2 := 100
955: -- p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
956: -- p_debug_mode IN VARCHAR2 := 'N'
957: -- p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

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

969:
970: procedure Delete_Dependency
971: (
972: p_api_version IN NUMBER := 1.0
973: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
974: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
975: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
976: ,p_validation_level IN VARCHAR2 := 100
977: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'

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

970: procedure Delete_Dependency
971: (
972: p_api_version IN NUMBER := 1.0
973: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
974: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
975: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
976: ,p_validation_level IN VARCHAR2 := 100
977: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
978: ,p_debug_mode IN VARCHAR2 := 'N'

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

971: (
972: p_api_version IN NUMBER := 1.0
973: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
974: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
975: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
976: ,p_validation_level IN VARCHAR2 := 100
977: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
978: ,p_debug_mode IN VARCHAR2 := 'N'
979: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

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

998: IF (p_debug_mode = 'Y') THEN
999: pa_debug.debug('PA_RELATIONSHIP_PUB.DELETE_DEPENDENCY begin');
1000: END IF;
1001:
1002: IF (p_commit = FND_API.G_TRUE) THEN
1003: savepoint delete_dependency;
1004: END IF;
1005:
1006: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version, p_api_version, l_api_name, g_pkg_name) then

Line 1006: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version, p_api_version, l_api_name, g_pkg_name) then

1002: IF (p_commit = FND_API.G_TRUE) THEN
1003: savepoint delete_dependency;
1004: END IF;
1005:
1006: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version, p_api_version, l_api_name, g_pkg_name) then
1007: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1008: END IF;
1009:
1010: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN

Line 1007: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1003: savepoint delete_dependency;
1004: END IF;
1005:
1006: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version, p_api_version, l_api_name, g_pkg_name) then
1007: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1008: END IF;
1009:
1010: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN
1011: FND_MSG_PUB.initialize;

Line 1010: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN

1006: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version, p_api_version, l_api_name, g_pkg_name) then
1007: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1008: END IF;
1009:
1010: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN
1011: FND_MSG_PUB.initialize;
1012: END IF;
1013:
1014: --Call private delete dependency API here.

Line 1032: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

1028: ,x_msg_count => l_msg_count
1029: ,x_msg_data => l_msg_data
1030: );
1031:
1032: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1033: x_msg_count := FND_MSG_PUB.count_msg;
1034: IF x_msg_count = 1 then
1035: pa_interface_utils_pub.get_messages
1036: (p_encoded => FND_API.G_TRUE,

Line 1036: (p_encoded => FND_API.G_TRUE,

1032: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1033: x_msg_count := FND_MSG_PUB.count_msg;
1034: IF x_msg_count = 1 then
1035: pa_interface_utils_pub.get_messages
1036: (p_encoded => FND_API.G_TRUE,
1037: p_msg_index => 1,
1038: p_msg_count => l_msg_count,
1039: p_msg_data => l_msg_data,
1040: p_data => l_data,

Line 1044: raise FND_API.G_EXC_ERROR;

1040: p_data => l_data,
1041: p_msg_index_out => l_msg_index_out);
1042: x_msg_data := l_data;
1043: END IF;
1044: raise FND_API.G_EXC_ERROR;
1045: END IF;
1046:
1047: x_return_status := FND_API.G_RET_STS_SUCCESS;
1048:

Line 1047: x_return_status := FND_API.G_RET_STS_SUCCESS;

1043: END IF;
1044: raise FND_API.G_EXC_ERROR;
1045: END IF;
1046:
1047: x_return_status := FND_API.G_RET_STS_SUCCESS;
1048:
1049: IF (p_commit = FND_API.G_TRUE) THEN
1050: COMMIT;
1051: END IF;

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

1045: END IF;
1046:
1047: x_return_status := FND_API.G_RET_STS_SUCCESS;
1048:
1049: IF (p_commit = FND_API.G_TRUE) THEN
1050: COMMIT;
1051: END IF;
1052:
1053: IF (p_debug_mode = 'Y') THEN

Line 1057: when FND_API.G_EXC_ERROR then

1053: IF (p_debug_mode = 'Y') THEN
1054: pa_debug.debug('PA_RELATIONSHIP_PUB.DELETE_DEPENDENCY END');
1055: END IF;
1056: EXCEPTION
1057: when FND_API.G_EXC_ERROR then
1058: if p_commit = FND_API.G_TRUE then
1059: rollback to delete_dependency;
1060: end if;
1061: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1058: if p_commit = FND_API.G_TRUE then

1054: pa_debug.debug('PA_RELATIONSHIP_PUB.DELETE_DEPENDENCY END');
1055: END IF;
1056: EXCEPTION
1057: when FND_API.G_EXC_ERROR then
1058: if p_commit = FND_API.G_TRUE then
1059: rollback to delete_dependency;
1060: end if;
1061: x_return_status := FND_API.G_RET_STS_ERROR;
1062: when FND_API.G_EXC_UNEXPECTED_ERROR then

Line 1061: x_return_status := FND_API.G_RET_STS_ERROR;

1057: when FND_API.G_EXC_ERROR then
1058: if p_commit = FND_API.G_TRUE then
1059: rollback to delete_dependency;
1060: end if;
1061: x_return_status := FND_API.G_RET_STS_ERROR;
1062: when FND_API.G_EXC_UNEXPECTED_ERROR then
1063: if p_commit = FND_API.G_TRUE then
1064: rollback to delete_dependency;
1065: end if;

Line 1062: when FND_API.G_EXC_UNEXPECTED_ERROR then

1058: if p_commit = FND_API.G_TRUE then
1059: rollback to delete_dependency;
1060: end if;
1061: x_return_status := FND_API.G_RET_STS_ERROR;
1062: when FND_API.G_EXC_UNEXPECTED_ERROR then
1063: if p_commit = FND_API.G_TRUE then
1064: rollback to delete_dependency;
1065: end if;
1066: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1063: if p_commit = FND_API.G_TRUE then

1059: rollback to delete_dependency;
1060: end if;
1061: x_return_status := FND_API.G_RET_STS_ERROR;
1062: when FND_API.G_EXC_UNEXPECTED_ERROR then
1063: if p_commit = FND_API.G_TRUE then
1064: rollback to delete_dependency;
1065: end if;
1066: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1067: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_RELATIONSHIP_PUB',

Line 1066: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1062: when FND_API.G_EXC_UNEXPECTED_ERROR then
1063: if p_commit = FND_API.G_TRUE then
1064: rollback to delete_dependency;
1065: end if;
1066: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1067: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_RELATIONSHIP_PUB',
1068: p_procedure_name => 'DELETE_DEPENDENCY',
1069: p_error_text => SUBSTRB(SQLERRM,1,240));
1070: when OTHERS then

Line 1071: if p_commit = FND_API.G_TRUE then

1067: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_RELATIONSHIP_PUB',
1068: p_procedure_name => 'DELETE_DEPENDENCY',
1069: p_error_text => SUBSTRB(SQLERRM,1,240));
1070: when OTHERS then
1071: if p_commit = FND_API.G_TRUE then
1072: rollback to delete_dependency;
1073: end if;
1074: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1075: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_RELATIONSHIOP_PUB',

Line 1074: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1070: when OTHERS then
1071: if p_commit = FND_API.G_TRUE then
1072: rollback to delete_dependency;
1073: end if;
1074: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1075: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_RELATIONSHIOP_PUB',
1076: p_procedure_name => 'DELETE_DEPENDENCY',
1077: p_error_text => SUBSTRB(SQLERRM,1,240));
1078: raise;

Line 1088: -- p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE

1084: -- Pre-reqs : None
1085: -- Return Value : N/A
1086: -- Parameters
1087: -- p_api_version IN NUMBER := 1.0
1088: -- p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
1089: -- p_commit IN VARCHAR2 := FND_API.G_FALSE
1090: -- p_validate_only IN VARCHAR2 := FND_API.G_TRUE
1091: -- p_validation_level IN VARCHAR2 := 100
1092: -- p_calling_module IN VARCHAR2 := 'SELF_SERVICE'

Line 1089: -- p_commit IN VARCHAR2 := FND_API.G_FALSE

1085: -- Return Value : N/A
1086: -- Parameters
1087: -- p_api_version IN NUMBER := 1.0
1088: -- p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
1089: -- p_commit IN VARCHAR2 := FND_API.G_FALSE
1090: -- p_validate_only IN VARCHAR2 := FND_API.G_TRUE
1091: -- p_validation_level IN VARCHAR2 := 100
1092: -- p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
1093: -- p_debug_mode IN VARCHAR2 := 'N'

Line 1090: -- p_validate_only IN VARCHAR2 := FND_API.G_TRUE

1086: -- Parameters
1087: -- p_api_version IN NUMBER := 1.0
1088: -- p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
1089: -- p_commit IN VARCHAR2 := FND_API.G_FALSE
1090: -- p_validate_only IN VARCHAR2 := FND_API.G_TRUE
1091: -- p_validation_level IN VARCHAR2 := 100
1092: -- p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
1093: -- p_debug_mode IN VARCHAR2 := 'N'
1094: -- p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

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

1108: -- FPM bug 3450684
1109: --
1110: PROCEDURE create_subproject_association(
1111: p_api_version IN NUMBER := 1.0
1112: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
1113: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
1114: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
1115: ,p_validation_level IN VARCHAR2 := 100
1116: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'

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

1109: --
1110: PROCEDURE create_subproject_association(
1111: p_api_version IN NUMBER := 1.0
1112: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
1113: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
1114: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
1115: ,p_validation_level IN VARCHAR2 := 100
1116: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
1117: ,p_debug_mode IN VARCHAR2 := 'N'

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

1110: PROCEDURE create_subproject_association(
1111: p_api_version IN NUMBER := 1.0
1112: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
1113: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
1114: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
1115: ,p_validation_level IN VARCHAR2 := 100
1116: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
1117: ,p_debug_mode IN VARCHAR2 := 'N'
1118: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

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

1152: IF (p_debug_mode = 'Y') THEN
1153: pa_debug.debug('PA_RELATIONSHIP_PUB.CREATE_SUBPROJECT_ASSOCIATION begin');
1154: END IF;
1155: --
1156: IF (p_commit = FND_API.G_TRUE) THEN
1157: savepoint create_subproject_association;
1158: END IF;
1159: --
1160: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version, p_api_version, l_api_name, g_pkg_name) then

Line 1160: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version, p_api_version, l_api_name, g_pkg_name) then

1156: IF (p_commit = FND_API.G_TRUE) THEN
1157: savepoint create_subproject_association;
1158: END IF;
1159: --
1160: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version, p_api_version, l_api_name, g_pkg_name) then
1161: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1162: END IF;
1163: --
1164: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN

Line 1161: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1157: savepoint create_subproject_association;
1158: END IF;
1159: --
1160: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version, p_api_version, l_api_name, g_pkg_name) then
1161: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1162: END IF;
1163: --
1164: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN
1165: FND_MSG_PUB.initialize;

Line 1164: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN

1160: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version, p_api_version, l_api_name, g_pkg_name) then
1161: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1162: END IF;
1163: --
1164: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN
1165: FND_MSG_PUB.initialize;
1166: END IF;
1167: --
1168: --

Line 1182: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1178: ,x_project_id => l_dest_proj_id
1179: ,x_return_status => l_return_status
1180: ,x_error_msg_code => l_error_msg_code
1181: );
1182: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1183: PA_UTILS.ADD_MESSAGE( 'PA', l_error_msg_code);
1184: END IF;
1185: ELSE
1186: --Throw a message and stop further processing

Line 1188: RAISE FND_API.G_EXC_ERROR;

1184: END IF;
1185: ELSE
1186: --Throw a message and stop further processing
1187: PA_UTILS.ADD_MESSAGE( 'PA', 'PA_PS_DEST_PROJ_NULL');
1188: RAISE FND_API.G_EXC_ERROR;
1189: END IF;
1190: --
1191: --
1192: PA_RELATIONSHIP_PVT.create_subproject_association(

Line 1209: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

1205: p_comment => p_comment,
1206: x_return_status => l_return_status,
1207: x_msg_count => x_msg_count,
1208: x_msg_data => x_msg_data);
1209: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1210: x_msg_count := FND_MSG_PUB.count_msg;
1211: IF x_msg_count = 1 then
1212: pa_interface_utils_pub.get_messages
1213: (p_encoded => FND_API.G_TRUE,

Line 1213: (p_encoded => FND_API.G_TRUE,

1209: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1210: x_msg_count := FND_MSG_PUB.count_msg;
1211: IF x_msg_count = 1 then
1212: pa_interface_utils_pub.get_messages
1213: (p_encoded => FND_API.G_TRUE,
1214: p_msg_index => 1,
1215: p_msg_count => l_msg_count,
1216: p_msg_data => l_msg_data,
1217: p_data => l_data,

Line 1221: raise FND_API.G_EXC_ERROR;

1217: p_data => l_data,
1218: p_msg_index_out => l_msg_index_out);
1219: x_msg_data := l_data;
1220: END IF;
1221: raise FND_API.G_EXC_ERROR;
1222: END IF;
1223: --
1224: x_return_status := FND_API.G_RET_STS_SUCCESS;
1225: --

Line 1224: x_return_status := FND_API.G_RET_STS_SUCCESS;

1220: END IF;
1221: raise FND_API.G_EXC_ERROR;
1222: END IF;
1223: --
1224: x_return_status := FND_API.G_RET_STS_SUCCESS;
1225: --
1226: IF (p_commit = FND_API.G_TRUE) THEN
1227: COMMIT;
1228: END IF;

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

1222: END IF;
1223: --
1224: x_return_status := FND_API.G_RET_STS_SUCCESS;
1225: --
1226: IF (p_commit = FND_API.G_TRUE) THEN
1227: COMMIT;
1228: END IF;
1229: --
1230: IF (p_debug_mode = 'Y') THEN

Line 1235: when FND_API.G_EXC_ERROR then

1231: pa_debug.debug('PA_RELATIONSHIP_PUB.CREATE_SUBPROJECT_ASSOCIATION END');
1232: END IF;
1233: --
1234: EXCEPTION
1235: when FND_API.G_EXC_ERROR then
1236: if p_commit = FND_API.G_TRUE then
1237: rollback to create_subproject_association;
1238: end if;
1239: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1236: if p_commit = FND_API.G_TRUE then

1232: END IF;
1233: --
1234: EXCEPTION
1235: when FND_API.G_EXC_ERROR then
1236: if p_commit = FND_API.G_TRUE then
1237: rollback to create_subproject_association;
1238: end if;
1239: x_return_status := FND_API.G_RET_STS_ERROR;
1240: when FND_API.G_EXC_UNEXPECTED_ERROR then

Line 1239: x_return_status := FND_API.G_RET_STS_ERROR;

1235: when FND_API.G_EXC_ERROR then
1236: if p_commit = FND_API.G_TRUE then
1237: rollback to create_subproject_association;
1238: end if;
1239: x_return_status := FND_API.G_RET_STS_ERROR;
1240: when FND_API.G_EXC_UNEXPECTED_ERROR then
1241: if p_commit = FND_API.G_TRUE then
1242: rollback to create_subproject_association;
1243: end if;

Line 1240: when FND_API.G_EXC_UNEXPECTED_ERROR then

1236: if p_commit = FND_API.G_TRUE then
1237: rollback to create_subproject_association;
1238: end if;
1239: x_return_status := FND_API.G_RET_STS_ERROR;
1240: when FND_API.G_EXC_UNEXPECTED_ERROR then
1241: if p_commit = FND_API.G_TRUE then
1242: rollback to create_subproject_association;
1243: end if;
1244: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1241: if p_commit = FND_API.G_TRUE then

1237: rollback to create_subproject_association;
1238: end if;
1239: x_return_status := FND_API.G_RET_STS_ERROR;
1240: when FND_API.G_EXC_UNEXPECTED_ERROR then
1241: if p_commit = FND_API.G_TRUE then
1242: rollback to create_subproject_association;
1243: end if;
1244: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1245: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_RELATIONSHIP_PUB',

Line 1244: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1240: when FND_API.G_EXC_UNEXPECTED_ERROR then
1241: if p_commit = FND_API.G_TRUE then
1242: rollback to create_subproject_association;
1243: end if;
1244: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1245: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_RELATIONSHIP_PUB',
1246: p_procedure_name => 'CREATE_SUBPROJECT_ASSOCIATION',
1247: p_error_text => SUBSTRB(SQLERRM,1,240));
1248: when OTHERS then

Line 1249: if p_commit = FND_API.G_TRUE then

1245: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_RELATIONSHIP_PUB',
1246: p_procedure_name => 'CREATE_SUBPROJECT_ASSOCIATION',
1247: p_error_text => SUBSTRB(SQLERRM,1,240));
1248: when OTHERS then
1249: if p_commit = FND_API.G_TRUE then
1250: rollback to create_subproject_association;
1251: end if;
1252: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1253: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_RELATIONSHIOP_PUB',

Line 1252: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1248: when OTHERS then
1249: if p_commit = FND_API.G_TRUE then
1250: rollback to create_subproject_association;
1251: end if;
1252: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1253: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_RELATIONSHIOP_PUB',
1254: p_procedure_name => 'CREATE_SUBPROJECT_ASSOCIATION',
1255: p_error_text => SUBSTRB(SQLERRM,1,240));
1256: raise;

Line 1267: -- p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE

1263: -- Pre-reqs : None
1264: -- Return Value : N/A
1265: -- Parameters
1266: -- p_api_version IN NUMBER := 1.0
1267: -- p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
1268: -- p_validate_only IN VARCHAR2 := FND_API.G_TRUE
1269: -- p_validation_level IN VARCHAR2 := 100
1270: -- p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
1271: -- p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 1268: -- p_validate_only IN VARCHAR2 := FND_API.G_TRUE

1264: -- Return Value : N/A
1265: -- Parameters
1266: -- p_api_version IN NUMBER := 1.0
1267: -- p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
1268: -- p_validate_only IN VARCHAR2 := FND_API.G_TRUE
1269: -- p_validation_level IN VARCHAR2 := 100
1270: -- p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
1271: -- p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1272: -- p_commit IN VARCHAR2 := FND_API.G_FALSE

Line 1272: -- p_commit IN VARCHAR2 := FND_API.G_FALSE

1268: -- p_validate_only IN VARCHAR2 := FND_API.G_TRUE
1269: -- p_validation_level IN VARCHAR2 := 100
1270: -- p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
1271: -- p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1272: -- p_commit IN VARCHAR2 := FND_API.G_FALSE
1273: -- p_debug_mode IN VARCHAR2 := 'N'
1274: -- p_object_relationship_id IN NUMBER
1275: -- p_record_version_number IN NUMBER
1276: -- p_comment IN VARCHAR2

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

1286: -- FPM bug 3450684
1287: --
1288: --
1289: Procedure Update_Subproject_Association(p_api_version IN NUMBER := 1.0,
1290: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
1291: p_validate_only IN VARCHAR2 := FND_API.G_TRUE,
1292: p_validation_level IN VARCHAR2 := 100,
1293: p_calling_module IN VARCHAR2 := 'SELF_SERVICE',
1294: p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,

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

1287: --
1288: --
1289: Procedure Update_Subproject_Association(p_api_version IN NUMBER := 1.0,
1290: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
1291: p_validate_only IN VARCHAR2 := FND_API.G_TRUE,
1292: p_validation_level IN VARCHAR2 := 100,
1293: p_calling_module IN VARCHAR2 := 'SELF_SERVICE',
1294: p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
1295: p_commit IN VARCHAR2 := FND_API.G_FALSE,

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

1291: p_validate_only IN VARCHAR2 := FND_API.G_TRUE,
1292: p_validation_level IN VARCHAR2 := 100,
1293: p_calling_module IN VARCHAR2 := 'SELF_SERVICE',
1294: p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
1295: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1296: p_debug_mode IN VARCHAR2 := 'N',
1297: p_object_relationship_id IN NUMBER,
1298: p_record_version_number IN NUMBER,
1299: p_comment IN VARCHAR2,

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

1321: IF (p_debug_mode = 'Y') THEN
1322: pa_debug.debug('PA_RELATIONSHIP_PUB.UPDATE_SUBPROJECT_ASSOCIATION begin');
1323: END IF;
1324: --
1325: IF (p_commit = FND_API.G_TRUE) THEN
1326: savepoint Update_Subproject_Association;
1327: END IF;
1328: --
1329: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version, p_api_version, l_api_name, g_pkg_name) then

Line 1329: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version, p_api_version, l_api_name, g_pkg_name) then

1325: IF (p_commit = FND_API.G_TRUE) THEN
1326: savepoint Update_Subproject_Association;
1327: END IF;
1328: --
1329: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version, p_api_version, l_api_name, g_pkg_name) then
1330: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1331: END IF;
1332: --
1333: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN

Line 1330: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1326: savepoint Update_Subproject_Association;
1327: END IF;
1328: --
1329: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version, p_api_version, l_api_name, g_pkg_name) then
1330: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1331: END IF;
1332: --
1333: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN
1334: FND_MSG_PUB.initialize;

Line 1333: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN

1329: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version, p_api_version, l_api_name, g_pkg_name) then
1330: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1331: END IF;
1332: --
1333: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN
1334: FND_MSG_PUB.initialize;
1335: END IF;
1336: --
1337: --

Line 1353: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

1349: p_comment => p_comment,
1350: x_return_status => l_return_status,
1351: x_msg_count => x_msg_count,
1352: x_msg_data => x_msg_data);
1353: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1354: x_msg_count := FND_MSG_PUB.count_msg;
1355: IF x_msg_count = 1 then
1356: pa_interface_utils_pub.get_messages
1357: (p_encoded => FND_API.G_TRUE,

Line 1357: (p_encoded => FND_API.G_TRUE,

1353: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1354: x_msg_count := FND_MSG_PUB.count_msg;
1355: IF x_msg_count = 1 then
1356: pa_interface_utils_pub.get_messages
1357: (p_encoded => FND_API.G_TRUE,
1358: p_msg_index => 1,
1359: p_msg_count => l_msg_count,
1360: p_msg_data => l_msg_data,
1361: p_data => l_data,

Line 1365: raise FND_API.G_EXC_ERROR;

1361: p_data => l_data,
1362: p_msg_index_out => l_msg_index_out);
1363: x_msg_data := l_data;
1364: END IF;
1365: raise FND_API.G_EXC_ERROR;
1366: END IF;
1367: --
1368: x_return_status := FND_API.G_RET_STS_SUCCESS;
1369: --

Line 1368: x_return_status := FND_API.G_RET_STS_SUCCESS;

1364: END IF;
1365: raise FND_API.G_EXC_ERROR;
1366: END IF;
1367: --
1368: x_return_status := FND_API.G_RET_STS_SUCCESS;
1369: --
1370: IF (p_commit = FND_API.G_TRUE) THEN
1371: COMMIT;
1372: END IF;

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

1366: END IF;
1367: --
1368: x_return_status := FND_API.G_RET_STS_SUCCESS;
1369: --
1370: IF (p_commit = FND_API.G_TRUE) THEN
1371: COMMIT;
1372: END IF;
1373: --
1374: IF (p_debug_mode = 'Y') THEN

Line 1379: when FND_API.G_EXC_ERROR then

1375: pa_debug.debug('PA_RELATIONSHIP_PUB.UPDATE_SUBPROJECT_ASSOCIATION END');
1376: END IF;
1377: --
1378: EXCEPTION
1379: when FND_API.G_EXC_ERROR then
1380: if p_commit = FND_API.G_TRUE then
1381: rollback to Update_Subproject_Association;
1382: end if;
1383: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1380: if p_commit = FND_API.G_TRUE then

1376: END IF;
1377: --
1378: EXCEPTION
1379: when FND_API.G_EXC_ERROR then
1380: if p_commit = FND_API.G_TRUE then
1381: rollback to Update_Subproject_Association;
1382: end if;
1383: x_return_status := FND_API.G_RET_STS_ERROR;
1384: when FND_API.G_EXC_UNEXPECTED_ERROR then

Line 1383: x_return_status := FND_API.G_RET_STS_ERROR;

1379: when FND_API.G_EXC_ERROR then
1380: if p_commit = FND_API.G_TRUE then
1381: rollback to Update_Subproject_Association;
1382: end if;
1383: x_return_status := FND_API.G_RET_STS_ERROR;
1384: when FND_API.G_EXC_UNEXPECTED_ERROR then
1385: if p_commit = FND_API.G_TRUE then
1386: rollback to Update_Subproject_Association;
1387: end if;

Line 1384: when FND_API.G_EXC_UNEXPECTED_ERROR then

1380: if p_commit = FND_API.G_TRUE then
1381: rollback to Update_Subproject_Association;
1382: end if;
1383: x_return_status := FND_API.G_RET_STS_ERROR;
1384: when FND_API.G_EXC_UNEXPECTED_ERROR then
1385: if p_commit = FND_API.G_TRUE then
1386: rollback to Update_Subproject_Association;
1387: end if;
1388: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1385: if p_commit = FND_API.G_TRUE then

1381: rollback to Update_Subproject_Association;
1382: end if;
1383: x_return_status := FND_API.G_RET_STS_ERROR;
1384: when FND_API.G_EXC_UNEXPECTED_ERROR then
1385: if p_commit = FND_API.G_TRUE then
1386: rollback to Update_Subproject_Association;
1387: end if;
1388: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1389: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_RELATIONSHIP_PUB',

Line 1388: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1384: when FND_API.G_EXC_UNEXPECTED_ERROR then
1385: if p_commit = FND_API.G_TRUE then
1386: rollback to Update_Subproject_Association;
1387: end if;
1388: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1389: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_RELATIONSHIP_PUB',
1390: p_procedure_name => 'UPDATE_SUBPROJECT_ASSOCIATION',
1391: p_error_text => SUBSTRB(SQLERRM,1,240));
1392: when OTHERS then

Line 1393: if p_commit = FND_API.G_TRUE then

1389: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_RELATIONSHIP_PUB',
1390: p_procedure_name => 'UPDATE_SUBPROJECT_ASSOCIATION',
1391: p_error_text => SUBSTRB(SQLERRM,1,240));
1392: when OTHERS then
1393: if p_commit = FND_API.G_TRUE then
1394: rollback to Update_Subproject_Association;
1395: end if;
1396: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1397: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_RELATIONSHIOP_PUB',

Line 1396: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1392: when OTHERS then
1393: if p_commit = FND_API.G_TRUE then
1394: rollback to Update_Subproject_Association;
1395: end if;
1396: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1397: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_RELATIONSHIOP_PUB',
1398: p_procedure_name => 'UPDATE_SUBPROJECT_ASSOCIATION',
1399: p_error_text => SUBSTRB(SQLERRM,1,240));
1400: raise;

Line 1410: -- p_commit IN VARCHAR2 := FND_API.G_FALSE

1406: -- Type : Public Procedure
1407: -- Pre-reqs : None
1408: -- Return Value : N/A
1409: -- Parameters
1410: -- p_commit IN VARCHAR2 := FND_API.G_FALSE
1411: -- p_validate_only IN VARCHAR2 := FND_API.G_TRUE
1412: -- p_validation_level IN VARCHAR2 := 100
1413: -- p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
1414: -- p_debug_mode IN VARCHAR2 := 'N'

Line 1411: -- p_validate_only IN VARCHAR2 := FND_API.G_TRUE

1407: -- Pre-reqs : None
1408: -- Return Value : N/A
1409: -- Parameters
1410: -- p_commit IN VARCHAR2 := FND_API.G_FALSE
1411: -- p_validate_only IN VARCHAR2 := FND_API.G_TRUE
1412: -- p_validation_level IN VARCHAR2 := 100
1413: -- p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
1414: -- p_debug_mode IN VARCHAR2 := 'N'
1415: -- p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

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

1427: -- FPM bug 3450684
1428: --
1429: --
1430: Procedure Delete_SubProject_Association(p_api_version IN NUMBER := 1.0,
1431: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
1432: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1433: p_validate_only IN VARCHAR2 := FND_API.G_TRUE,
1434: p_validation_level IN VARCHAR2 := 100,
1435: p_calling_module IN VARCHAR2 := 'SELF_SERVICE',

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

1428: --
1429: --
1430: Procedure Delete_SubProject_Association(p_api_version IN NUMBER := 1.0,
1431: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
1432: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1433: p_validate_only IN VARCHAR2 := FND_API.G_TRUE,
1434: p_validation_level IN VARCHAR2 := 100,
1435: p_calling_module IN VARCHAR2 := 'SELF_SERVICE',
1436: p_debug_mode IN VARCHAR2 := 'N',

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

1429: --
1430: Procedure Delete_SubProject_Association(p_api_version IN NUMBER := 1.0,
1431: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
1432: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1433: p_validate_only IN VARCHAR2 := FND_API.G_TRUE,
1434: p_validation_level IN VARCHAR2 := 100,
1435: p_calling_module IN VARCHAR2 := 'SELF_SERVICE',
1436: p_debug_mode IN VARCHAR2 := 'N',
1437: p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,

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

1461: IF (p_debug_mode = 'Y') THEN
1462: pa_debug.debug('PA_RELATIONSHIP_PUB.UPDATE_SUBPROJECT_ASSOCIATION begin');
1463: END IF;
1464: --
1465: IF (p_commit = FND_API.G_TRUE) THEN
1466: savepoint Delete_SubProject_Association;
1467: END IF;
1468: --
1469: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version, p_api_version, l_api_name, g_pkg_name) then

Line 1469: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version, p_api_version, l_api_name, g_pkg_name) then

1465: IF (p_commit = FND_API.G_TRUE) THEN
1466: savepoint Delete_SubProject_Association;
1467: END IF;
1468: --
1469: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version, p_api_version, l_api_name, g_pkg_name) then
1470: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1471: END IF;
1472: --
1473: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN

Line 1470: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1466: savepoint Delete_SubProject_Association;
1467: END IF;
1468: --
1469: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version, p_api_version, l_api_name, g_pkg_name) then
1470: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1471: END IF;
1472: --
1473: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN
1474: FND_MSG_PUB.initialize;

Line 1473: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN

1469: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version, p_api_version, l_api_name, g_pkg_name) then
1470: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1471: END IF;
1472: --
1473: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN
1474: FND_MSG_PUB.initialize;
1475: END IF;
1476: --
1477: --

Line 1490: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

1486: p_record_version_number => p_record_version_number,
1487: x_return_status => l_return_status,
1488: x_msg_count => x_msg_count,
1489: x_msg_data => x_msg_data);
1490: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1491: x_msg_count := FND_MSG_PUB.count_msg;
1492: IF x_msg_count = 1 then
1493: pa_interface_utils_pub.get_messages
1494: (p_encoded => FND_API.G_TRUE,

Line 1494: (p_encoded => FND_API.G_TRUE,

1490: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1491: x_msg_count := FND_MSG_PUB.count_msg;
1492: IF x_msg_count = 1 then
1493: pa_interface_utils_pub.get_messages
1494: (p_encoded => FND_API.G_TRUE,
1495: p_msg_index => 1,
1496: p_msg_count => l_msg_count,
1497: p_msg_data => l_msg_data,
1498: p_data => l_data,

Line 1502: raise FND_API.G_EXC_ERROR;

1498: p_data => l_data,
1499: p_msg_index_out => l_msg_index_out);
1500: x_msg_data := l_data;
1501: END IF;
1502: raise FND_API.G_EXC_ERROR;
1503: END IF;
1504: --
1505: x_return_status := FND_API.G_RET_STS_SUCCESS;
1506: --

Line 1505: x_return_status := FND_API.G_RET_STS_SUCCESS;

1501: END IF;
1502: raise FND_API.G_EXC_ERROR;
1503: END IF;
1504: --
1505: x_return_status := FND_API.G_RET_STS_SUCCESS;
1506: --
1507: IF (p_commit = FND_API.G_TRUE) THEN
1508: COMMIT;
1509: END IF;

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

1503: END IF;
1504: --
1505: x_return_status := FND_API.G_RET_STS_SUCCESS;
1506: --
1507: IF (p_commit = FND_API.G_TRUE) THEN
1508: COMMIT;
1509: END IF;
1510: --
1511: IF (p_debug_mode = 'Y') THEN

Line 1516: when FND_API.G_EXC_ERROR then

1512: pa_debug.debug('PA_RELATIONSHIP_PUB.DELETE_SUBPROJECT_ASSOCIATION END');
1513: END IF;
1514: --
1515: EXCEPTION
1516: when FND_API.G_EXC_ERROR then
1517: if p_commit = FND_API.G_TRUE then
1518: rollback to Delete_SubProject_Association;
1519: end if;
1520: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1517: if p_commit = FND_API.G_TRUE then

1513: END IF;
1514: --
1515: EXCEPTION
1516: when FND_API.G_EXC_ERROR then
1517: if p_commit = FND_API.G_TRUE then
1518: rollback to Delete_SubProject_Association;
1519: end if;
1520: x_return_status := FND_API.G_RET_STS_ERROR;
1521: when FND_API.G_EXC_UNEXPECTED_ERROR then

Line 1520: x_return_status := FND_API.G_RET_STS_ERROR;

1516: when FND_API.G_EXC_ERROR then
1517: if p_commit = FND_API.G_TRUE then
1518: rollback to Delete_SubProject_Association;
1519: end if;
1520: x_return_status := FND_API.G_RET_STS_ERROR;
1521: when FND_API.G_EXC_UNEXPECTED_ERROR then
1522: if p_commit = FND_API.G_TRUE then
1523: rollback to Delete_SubProject_Association;
1524: end if;

Line 1521: when FND_API.G_EXC_UNEXPECTED_ERROR then

1517: if p_commit = FND_API.G_TRUE then
1518: rollback to Delete_SubProject_Association;
1519: end if;
1520: x_return_status := FND_API.G_RET_STS_ERROR;
1521: when FND_API.G_EXC_UNEXPECTED_ERROR then
1522: if p_commit = FND_API.G_TRUE then
1523: rollback to Delete_SubProject_Association;
1524: end if;
1525: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1522: if p_commit = FND_API.G_TRUE then

1518: rollback to Delete_SubProject_Association;
1519: end if;
1520: x_return_status := FND_API.G_RET_STS_ERROR;
1521: when FND_API.G_EXC_UNEXPECTED_ERROR then
1522: if p_commit = FND_API.G_TRUE then
1523: rollback to Delete_SubProject_Association;
1524: end if;
1525: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1526: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_RELATIONSHIP_PUB',

Line 1525: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1521: when FND_API.G_EXC_UNEXPECTED_ERROR then
1522: if p_commit = FND_API.G_TRUE then
1523: rollback to Delete_SubProject_Association;
1524: end if;
1525: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1526: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_RELATIONSHIP_PUB',
1527: p_procedure_name => 'DELETE_SUBPROJECT_ASSOCIATION',
1528: p_error_text => SUBSTRB(SQLERRM,1,240));
1529: when OTHERS then

Line 1530: if p_commit = FND_API.G_TRUE then

1526: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_RELATIONSHIP_PUB',
1527: p_procedure_name => 'DELETE_SUBPROJECT_ASSOCIATION',
1528: p_error_text => SUBSTRB(SQLERRM,1,240));
1529: when OTHERS then
1530: if p_commit = FND_API.G_TRUE then
1531: rollback to Delete_SubProject_Association;
1532: end if;
1533: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1534: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_RELATIONSHIOP_PUB',

Line 1533: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1529: when OTHERS then
1530: if p_commit = FND_API.G_TRUE then
1531: rollback to Delete_SubProject_Association;
1532: end if;
1533: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1534: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_RELATIONSHIOP_PUB',
1535: p_procedure_name => 'DELETE_SUBPROJECT_ASSOCIATION',
1536: p_error_text => SUBSTRB(SQLERRM,1,240));
1537: raise;