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.AHL_DI_ASSO_DOC_GEN_PVT dependencies on FND_API

Line 37: If l_doc_no is not null and l_doc_no<>fnd_api.g_miss_char

33: open get_rev_dat(p_association_rec.document_id, p_association_rec.doc_revision_id);
34: fetch get_rev_dat into l_doc_no, l_doc_rev_no;
35: close get_rev_dat;
36:
37: If l_doc_no is not null and l_doc_no<>fnd_api.g_miss_char
38: Then
39: x_record:=x_record||nvl(l_doc_no,'')||' - ';
40: End if;
41:

Line 42: If l_doc_rev_no is not null and l_doc_rev_no<>fnd_api.g_miss_char

38: Then
39: x_record:=x_record||nvl(l_doc_no,'')||' - ';
40: End if;
41:
42: If l_doc_rev_no is not null and l_doc_rev_no<>fnd_api.g_miss_char
43: Then
44: x_record:=x_record||nvl(l_doc_rev_no ,'')||' - ';
45: End if;
46:

Line 47: If p_association_rec.chapter is not null and p_association_rec.chapter<>fnd_api.g_miss_char

43: Then
44: x_record:=x_record||nvl(l_doc_rev_no ,'')||' - ';
45: End if;
46:
47: If p_association_rec.chapter is not null and p_association_rec.chapter<>fnd_api.g_miss_char
48: Then
49: x_record:=x_record||nvl(p_association_rec.chapter,'')||' - ';
50: End if;
51:

Line 52: If p_association_rec.section is not null and p_association_rec.section<>fnd_api.g_miss_char

48: Then
49: x_record:=x_record||nvl(p_association_rec.chapter,'')||' - ';
50: End if;
51:
52: If p_association_rec.section is not null and p_association_rec.section<>fnd_api.g_miss_char
53: Then
54: x_record:=x_record||nvl(p_association_rec.section,'')||' - ';
55: End if;
56:

Line 57: If p_association_rec.subject is not null and p_association_rec.subject<>fnd_api.g_miss_char

53: Then
54: x_record:=x_record||nvl(p_association_rec.section,'')||' - ';
55: End if;
56:
57: If p_association_rec.subject is not null and p_association_rec.subject<>fnd_api.g_miss_char
58: Then
59: x_record:=x_record||nvl(p_association_rec.subject,'')||' - ';
60: End if;
61:

Line 62: If p_association_rec.figure is not null and p_association_rec.figure<>fnd_api.g_miss_char

58: Then
59: x_record:=x_record||nvl(p_association_rec.subject,'')||' - ';
60: End if;
61:
62: If p_association_rec.figure is not null and p_association_rec.figure<>fnd_api.g_miss_char
63: Then
64: x_record:=x_record||nvl(p_association_rec.figure,'')||' - ';
65: End if;
66:

Line 67: If p_association_rec.page is not null and p_association_rec.page<>fnd_api.g_miss_char

63: Then
64: x_record:=x_record||nvl(p_association_rec.figure,'')||' - ';
65: End if;
66:
67: If p_association_rec.page is not null and p_association_rec.page<>fnd_api.g_miss_char
68: Then
69: x_record:=x_record||nvl(p_association_rec.page,'');
70: End if;
71:

Line 191: l_init_msg_list VARCHAR2(10):=FND_API.G_TRUE;

187: l_num_rec NUMBER;
188: l_msg_count NUMBER;
189: l_msg_data VARCHAR2(2000);
190: l_return_status VARCHAR2(1);
191: l_init_msg_list VARCHAR2(10):=FND_API.G_TRUE;
192: l_counter NUMBER:=0;
193: l_counter1 NUMBER:=0;
194: l_lookup_code VARCHAR2(30):='';
195: l_record VARCHAR2(4000):=P_RECORD;

Line 198: x_return_status:=FND_API.G_RET_STS_SUCCESS;

194: l_lookup_code VARCHAR2(30):='';
195: l_record VARCHAR2(4000):=P_RECORD;
196: l_type_code VARCHAR2(30);
197: BEGIN
198: x_return_status:=FND_API.G_RET_STS_SUCCESS;
199:
200: IF p_dml_operation <> 'D'
201: THEN
202:

Line 208: IF p_ASO_OBJECT_ID IS NOT NULL OR p_ASO_OBJECT_ID<>FND_API.G_MISS_NUM

204: THEN
205: IF g_pm_install<>'Y'
206: THEN
207:
208: IF p_ASO_OBJECT_ID IS NOT NULL OR p_ASO_OBJECT_ID<>FND_API.G_MISS_NUM
209: THEN
210: OPEN get_mr_type_code (P_ASO_OBJECT_ID);
211: fetch get_mr_type_code into l_type_code;
212: close get_mr_type_code ;

Line 227: IF p_doc_title_asso_id IS NOT NULL AND p_doc_title_asso_id <> FND_API.G_MISS_NUM

223: END IF;
224:
225: END IF;
226:
227: IF p_doc_title_asso_id IS NOT NULL AND p_doc_title_asso_id <> FND_API.G_MISS_NUM
228: THEN
229: OPEN get_doc_assos_rec_b_info(p_doc_title_asso_id);
230: FETCH get_doc_assos_rec_b_info INTO l_document_id,
231: l_doc_revision_id,

Line 298: IF p_Doc_revision_id IS NOT NULL and p_doc_revision_id <> FND_API.G_MISS_NUM

294: RETURN;
295: END IF;
296: END IF;
297:
298: IF p_Doc_revision_id IS NOT NULL and p_doc_revision_id <> FND_API.G_MISS_NUM
299: THEN
300: OPEN get_rev_dat(p_doc_revision_id);
301: FETCH get_rev_dat INTO l_rev_rec1;
302: IF get_rev_dat%notfound

Line 324: p_doc_title_asso_id = FND_API.G_MISS_NUM) AND

320: END IF;
321: END IF;
322:
323: IF ((p_doc_title_asso_id IS NULL OR
324: p_doc_title_asso_id = FND_API.G_MISS_NUM) AND
325: (p_document_id IS NULL OR p_document_id = FND_API.G_MISS_NUM))
326: OR
327: ((p_doc_title_asso_id IS NOT NULL AND
328: p_doc_title_asso_id <> FND_API.G_MISS_NUM) AND l_document_id IS NULL)

Line 325: (p_document_id IS NULL OR p_document_id = FND_API.G_MISS_NUM))

321: END IF;
322:
323: IF ((p_doc_title_asso_id IS NULL OR
324: p_doc_title_asso_id = FND_API.G_MISS_NUM) AND
325: (p_document_id IS NULL OR p_document_id = FND_API.G_MISS_NUM))
326: OR
327: ((p_doc_title_asso_id IS NOT NULL AND
328: p_doc_title_asso_id <> FND_API.G_MISS_NUM) AND l_document_id IS NULL)
329: THEN

Line 328: p_doc_title_asso_id <> FND_API.G_MISS_NUM) AND l_document_id IS NULL)

324: p_doc_title_asso_id = FND_API.G_MISS_NUM) AND
325: (p_document_id IS NULL OR p_document_id = FND_API.G_MISS_NUM))
326: OR
327: ((p_doc_title_asso_id IS NOT NULL AND
328: p_doc_title_asso_id <> FND_API.G_MISS_NUM) AND l_document_id IS NULL)
329: THEN
330: FND_MESSAGE.SET_NAME('AHL','AHL_DI_DOCUMENT_ID_NULL');
331: FND_MSG_PUB.ADD;
332: RETURN;

Line 338: p_doc_title_asso_id = FND_API.G_MISS_NUM) AND

334:
335: -- This condition checks for Aso Object Type Code is Null
336:
337: IF ((p_doc_title_asso_id IS NULL OR
338: p_doc_title_asso_id = FND_API.G_MISS_NUM) AND
339: (p_aso_object_type_code IS NULL OR
340: p_aso_object_type_code = FND_API.G_MISS_CHAR))
341: OR
342: ((p_doc_title_asso_id IS NOT NULL AND

Line 340: p_aso_object_type_code = FND_API.G_MISS_CHAR))

336:
337: IF ((p_doc_title_asso_id IS NULL OR
338: p_doc_title_asso_id = FND_API.G_MISS_NUM) AND
339: (p_aso_object_type_code IS NULL OR
340: p_aso_object_type_code = FND_API.G_MISS_CHAR))
341: OR
342: ((p_doc_title_asso_id IS NOT NULL AND
343: p_doc_title_asso_id <> FND_API.G_MISS_NUM)
344: AND l_aso_object_type_code IS NULL)

Line 343: p_doc_title_asso_id <> FND_API.G_MISS_NUM)

339: (p_aso_object_type_code IS NULL OR
340: p_aso_object_type_code = FND_API.G_MISS_CHAR))
341: OR
342: ((p_doc_title_asso_id IS NOT NULL AND
343: p_doc_title_asso_id <> FND_API.G_MISS_NUM)
344: AND l_aso_object_type_code IS NULL)
345: THEN
346: FND_MESSAGE.SET_NAME('AHL','AHL_DI_ASO_OBJECT_TYPE_NULL');
347: FND_MSG_PUB.ADD;

Line 353: p_doc_title_asso_id = FND_API.G_MISS_NUM) AND

349: END IF;
350:
351: -- This condiiton checks for Aso Object Id Value Is Null
352: IF ((p_doc_title_asso_id IS NULL OR
353: p_doc_title_asso_id = FND_API.G_MISS_NUM) AND
354: (p_aso_object_id IS NULL OR
355: p_aso_object_id = FND_API.G_MISS_NUM))
356: OR
357: ((p_doc_title_asso_id IS NOT NULL AND

Line 355: p_aso_object_id = FND_API.G_MISS_NUM))

351: -- This condiiton checks for Aso Object Id Value Is Null
352: IF ((p_doc_title_asso_id IS NULL OR
353: p_doc_title_asso_id = FND_API.G_MISS_NUM) AND
354: (p_aso_object_id IS NULL OR
355: p_aso_object_id = FND_API.G_MISS_NUM))
356: OR
357: ((p_doc_title_asso_id IS NOT NULL AND
358: p_doc_title_asso_id <> FND_API.G_MISS_NUM) AND l_aso_object_id IS NULL)
359: THEN

Line 358: p_doc_title_asso_id <> FND_API.G_MISS_NUM) AND l_aso_object_id IS NULL)

354: (p_aso_object_id IS NULL OR
355: p_aso_object_id = FND_API.G_MISS_NUM))
356: OR
357: ((p_doc_title_asso_id IS NOT NULL AND
358: p_doc_title_asso_id <> FND_API.G_MISS_NUM) AND l_aso_object_id IS NULL)
359: THEN
360: FND_MESSAGE.SET_NAME('AHL','AHL_DI_ASO_OBJECT_ID_NULL');
361: FND_MSG_PUB.ADD;
362: RETURN;

Line 368: p_aso_object_type_code <> FND_API.G_MISS_CHAR

364:
365: --Check for Aso Object Type Code in fnd lookups
366:
367: IF p_aso_object_type_code IS NOT NULL AND
368: p_aso_object_type_code <> FND_API.G_MISS_CHAR
369: THEN
370: OPEN get_aso_obj_type_code(p_aso_object_type_code);
371: FETCH get_aso_obj_type_code INTO l_dummy;
372: IF get_aso_obj_type_code%NOTFOUND

Line 426: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

422: END IF;
423:
424: END IF;
425: EXCEPTION
426: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
427: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
428: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
429: p_count => x_msg_count,
430: p_data => x_msg_data);

Line 427: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

423:
424: END IF;
425: EXCEPTION
426: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
427: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
428: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
429: p_count => x_msg_count,
430: p_data => x_msg_data);
431: WHEN FND_API.G_EXC_ERROR THEN

Line 428: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

424: END IF;
425: EXCEPTION
426: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
427: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
428: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
429: p_count => x_msg_count,
430: p_data => x_msg_data);
431: WHEN FND_API.G_EXC_ERROR THEN
432: X_return_status := FND_API.G_RET_STS_ERROR;

Line 431: WHEN FND_API.G_EXC_ERROR THEN

427: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
428: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
429: p_count => x_msg_count,
430: p_data => x_msg_data);
431: WHEN FND_API.G_EXC_ERROR THEN
432: X_return_status := FND_API.G_RET_STS_ERROR;
433: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
434: p_count => x_msg_count,
435: p_data => X_msg_data);

Line 432: X_return_status := FND_API.G_RET_STS_ERROR;

428: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
429: p_count => x_msg_count,
430: p_data => x_msg_data);
431: WHEN FND_API.G_EXC_ERROR THEN
432: X_return_status := FND_API.G_RET_STS_ERROR;
433: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
434: p_count => x_msg_count,
435: p_data => X_msg_data);
436: WHEN OTHERS THEN

Line 433: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

429: p_count => x_msg_count,
430: p_data => x_msg_data);
431: WHEN FND_API.G_EXC_ERROR THEN
432: X_return_status := FND_API.G_RET_STS_ERROR;
433: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
434: p_count => x_msg_count,
435: p_data => X_msg_data);
436: WHEN OTHERS THEN
437: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 437: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

433: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
434: p_count => x_msg_count,
435: p_data => X_msg_data);
436: WHEN OTHERS THEN
437: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
438: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
439: THEN
440: fnd_msg_pub.add_exc_msg(p_pkg_name =>g_pkg_name,
441: p_procedure_name =>'VALIDATE_ASSOCIATION',

Line 444: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

440: fnd_msg_pub.add_exc_msg(p_pkg_name =>g_pkg_name,
441: p_procedure_name =>'VALIDATE_ASSOCIATION',
442: p_error_text =>SUBSTR(SQLERRM,1,240));
443: END IF;
444: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
445: p_count => x_msg_count,
446: p_data => X_msg_data);
447: END;
448:

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

456: /*-------------------------------------------------------*/
457: PROCEDURE DELETE_ASSOCIATION
458: (
459: p_api_version IN NUMBER := 1.0 ,
460: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
461: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
462: p_validate_only IN VARCHAR2 := FND_API.G_TRUE ,
463: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
464: p_association_rec IN association_rec ,

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

457: PROCEDURE DELETE_ASSOCIATION
458: (
459: p_api_version IN NUMBER := 1.0 ,
460: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
461: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
462: p_validate_only IN VARCHAR2 := FND_API.G_TRUE ,
463: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
464: p_association_rec IN association_rec ,
465: x_return_status OUT NOCOPY VARCHAR2 ,

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

458: (
459: p_api_version IN NUMBER := 1.0 ,
460: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
461: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
462: p_validate_only IN VARCHAR2 := FND_API.G_TRUE ,
463: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
464: p_association_rec IN association_rec ,
465: x_return_status OUT NOCOPY VARCHAR2 ,
466: x_msg_count OUT NOCOPY NUMBER ,

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

459: p_api_version IN NUMBER := 1.0 ,
460: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
461: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
462: p_validate_only IN VARCHAR2 := FND_API.G_TRUE ,
463: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
464: p_association_rec IN association_rec ,
465: x_return_status OUT NOCOPY VARCHAR2 ,
466: x_msg_count OUT NOCOPY NUMBER ,
467: x_msg_data OUT NOCOPY VARCHAR2)

Line 500: IF FND_API.to_boolean(p_init_msg_list)

496:
497: END IF;
498: END IF;
499: -- Standard call to check for call compatibility.
500: IF FND_API.to_boolean(p_init_msg_list)
501: THEN
502: FND_MSG_PUB.initialize;
503: END IF;
504: -- Initialize API return status to success

Line 507: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version,

503: END IF;
504: -- Initialize API return status to success
505: x_return_status := 'S';
506: -- Initialize message list if p_init_msg_list is set to TRUE.
507: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version,
508: p_api_version,
509: l_api_name,G_PKG_NAME)
510: THEN
511: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 511: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

507: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version,
508: p_api_version,
509: l_api_name,G_PKG_NAME)
510: THEN
511: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
512: END IF;
513: --
514: OPEN get_doc_assos_rec_b_info(p_association_rec.doc_title_asso_id);
515: FETCH get_doc_assos_rec_b_info INTO l_rowid,

Line 550: IF FND_API.TO_BOOLEAN(p_commit) THEN

546: WHERE doc_title_asso_id = p_association_rec.doc_title_asso_id;
547: --
548: */
549: --Standard check for commit;
550: IF FND_API.TO_BOOLEAN(p_commit) THEN
551: COMMIT;
552: END IF;
553: -- Debug info
554: IF G_DEBUG='Y' THEN

Line 565: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

561:
562: END IF;
563:
564: EXCEPTION
565: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
566: ROLLBACK TO delete_association;
567: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
568: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
569: p_count => x_msg_count,

Line 567: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

563:
564: EXCEPTION
565: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
566: ROLLBACK TO delete_association;
567: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
568: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
569: p_count => x_msg_count,
570: p_data => x_msg_data);
571: --Debug Info

Line 568: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

564: EXCEPTION
565: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
566: ROLLBACK TO delete_association;
567: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
568: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
569: p_count => x_msg_count,
570: p_data => x_msg_data);
571: --Debug Info
572: IF G_DEBUG='Y' THEN

Line 583: WHEN FND_API.G_EXC_ERROR THEN

579: AHL_DEBUG_PUB.disable_debug;
580:
581: END IF;
582:
583: WHEN FND_API.G_EXC_ERROR THEN
584: ROLLBACK TO delete_association;
585: X_return_status := FND_API.G_RET_STS_ERROR;
586: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
587: p_count => x_msg_count,

Line 585: X_return_status := FND_API.G_RET_STS_ERROR;

581: END IF;
582:
583: WHEN FND_API.G_EXC_ERROR THEN
584: ROLLBACK TO delete_association;
585: X_return_status := FND_API.G_RET_STS_ERROR;
586: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
587: p_count => x_msg_count,
588: p_data => X_msg_data);
589: -- Debug info.

Line 586: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

582:
583: WHEN FND_API.G_EXC_ERROR THEN
584: ROLLBACK TO delete_association;
585: X_return_status := FND_API.G_RET_STS_ERROR;
586: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
587: p_count => x_msg_count,
588: p_data => X_msg_data);
589: -- Debug info.
590: IF G_DEBUG='Y' THEN

Line 602: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

598: END IF;
599:
600: WHEN OTHERS THEN
601: ROLLBACK TO delete_association;
602: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
603: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
604: THEN
605: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_DI_ASSO_DOC_GEN_PVT',
606: p_procedure_name => 'DELETE_ASSOCIATION',

Line 609: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

605: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_DI_ASSO_DOC_GEN_PVT',
606: p_procedure_name => 'DELETE_ASSOCIATION',
607: p_error_text => SUBSTR(SQLERRM,1,240));
608: END IF;
609: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
610: p_count => x_msg_count,
611: p_data => X_msg_data);
612: -- Debug info.
613: IF G_DEBUG='Y' THEN

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

632: /*------------------------------------------------------*/
633: PROCEDURE PROCESS_ASSOCIATION
634: (
635: p_api_version IN NUMBER := 1.0 ,
636: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
637: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
638: p_validate_only IN VARCHAR2 := FND_API.G_TRUE ,
639: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
640: p_x_association_tbl IN OUT NOCOPY association_tbl ,

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

633: PROCEDURE PROCESS_ASSOCIATION
634: (
635: p_api_version IN NUMBER := 1.0 ,
636: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
637: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
638: p_validate_only IN VARCHAR2 := FND_API.G_TRUE ,
639: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
640: p_x_association_tbl IN OUT NOCOPY association_tbl ,
641: x_return_status OUT NOCOPY VARCHAR2 ,

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

634: (
635: p_api_version IN NUMBER := 1.0 ,
636: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
637: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
638: p_validate_only IN VARCHAR2 := FND_API.G_TRUE ,
639: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
640: p_x_association_tbl IN OUT NOCOPY association_tbl ,
641: x_return_status OUT NOCOPY VARCHAR2 ,
642: x_msg_count OUT NOCOPY NUMBER ,

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

635: p_api_version IN NUMBER := 1.0 ,
636: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
637: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
638: p_validate_only IN VARCHAR2 := FND_API.G_TRUE ,
639: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
640: p_x_association_tbl IN OUT NOCOPY association_tbl ,
641: x_return_status OUT NOCOPY VARCHAR2 ,
642: x_msg_count OUT NOCOPY NUMBER ,
643: x_msg_data OUT NOCOPY VARCHAR2)

Line 798: IF FND_API.to_boolean(p_init_msg_list)

794:
795: END IF;
796: END IF;
797: -- Standard call to check for call compatibility.
798: IF FND_API.to_boolean(p_init_msg_list)
799: THEN
800: FND_MSG_PUB.initialize;
801: END IF;
802: -- Initialize API return status to success

Line 805: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version,

801: END IF;
802: -- Initialize API return status to success
803: x_return_status := 'S';
804: -- Initialize message list if p_init_msg_list is set to TRUE.
805: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version,
806: p_api_version,
807: l_api_name,G_PKG_NAME)
808: THEN
809: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 809: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

805: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version,
806: p_api_version,
807: l_api_name,G_PKG_NAME)
808: THEN
809: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
810: END IF;
811:
812:
813: --Start of API Body

Line 860: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

856: l_msg_count := FND_MSG_PUB.count_msg;
857:
858: IF l_msg_count > 0 THEN
859: X_msg_count := l_msg_count;
860: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
861: RAISE FND_API.G_EXC_ERROR;
862: END IF;
863:
864:

Line 861: RAISE FND_API.G_EXC_ERROR;

857:
858: IF l_msg_count > 0 THEN
859: X_msg_count := l_msg_count;
860: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
861: RAISE FND_API.G_EXC_ERROR;
862: END IF;
863:
864:
865:

Line 918: RAISE FND_API.G_EXC_ERROR;

914:
915: FND_MESSAGE.SET_NAME('AHL','AHL_DI_DOC_ASSOS_DUP_RECORD');
916: FND_MESSAGE.SET_TOKEN('DUPRECORD',l_record);
917: FND_MSG_PUB.ADD;
918: RAISE FND_API.G_EXC_ERROR;
919:
920: END IF;
921: END IF;
922:

Line 929: RAISE FND_API.G_EXC_ERROR;

925: THEN
926: FND_MESSAGE.SET_NAME('AHL','AHL_DI_DOC_ASSOS_DUP_RECORD');
927: FND_MESSAGE.SET_TOKEN('DUPRECORD',l_record);
928: FND_MSG_PUB.ADD;
929: RAISE FND_API.G_EXC_ERROR;
930: END IF;
931:
932: END IF;
933: CLOSE dup_rec_check_cre;

Line 978: RAISE FND_API.G_EXC_ERROR;

974:
975: FND_MESSAGE.SET_NAME('AHL','AHL_DI_DOC_ASSOS_DUP_RECORD');
976: FND_MESSAGE.SET_TOKEN('DUPRECORD',l_record);
977: FND_MSG_PUB.ADD;
978: RAISE FND_API.G_EXC_ERROR;
979:
980: END IF;
981: END IF;
982:

Line 989: RAISE FND_API.G_EXC_ERROR;

985: THEN
986: FND_MESSAGE.SET_NAME('AHL','AHL_DI_DOC_ASSOS_DUP_RECORD');
987: FND_MESSAGE.SET_TOKEN('DUPRECORD',l_record);
988: FND_MSG_PUB.ADD;
989: RAISE FND_API.G_EXC_ERROR;
990: END IF;
991:
992: END IF;
993: CLOSE dup_rec_check_upd;

Line 1020: RAISE FND_API.G_EXC_ERROR;

1016:
1017: FND_MESSAGE.SET_NAME('AHL','AHL_DI_DOC_ASSOS_DUP_RECORD');
1018: FND_MESSAGE.SET_TOKEN('DUPRECORD',l_record);
1019: FND_MSG_PUB.ADD;
1020: RAISE FND_API.G_EXC_ERROR;
1021:
1022: END IF;
1023: END IF;
1024:

Line 1031: RAISE FND_API.G_EXC_ERROR;

1027: THEN
1028: FND_MESSAGE.SET_NAME('AHL','AHL_DI_DOC_ASSOS_DUP_RECORD');
1029: FND_MESSAGE.SET_TOKEN('DUPRECORD',l_record);
1030: FND_MSG_PUB.ADD;
1031: RAISE FND_API.G_EXC_ERROR;
1032: END IF;
1033: END IF;
1034: CLOSE dup_rec;
1035:

Line 1052: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1048: l_msg_count := FND_MSG_PUB.count_msg;
1049:
1050: IF l_msg_count > 0 THEN
1051: X_msg_count := l_msg_count;
1052: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1053: RAISE FND_API.G_EXC_ERROR;
1054: END IF;
1055: */
1056: --prithwi changing code

Line 1053: RAISE FND_API.G_EXC_ERROR;

1049:
1050: IF l_msg_count > 0 THEN
1051: X_msg_count := l_msg_count;
1052: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1053: RAISE FND_API.G_EXC_ERROR;
1054: END IF;
1055: */
1056: --prithwi changing code
1057: -- FOR i IN p_x_association_tbl.FIRST..p_x_association_tbl.LAST

Line 1065: p_init_msg_list => FND_API.G_TRUE ,

1061: IF p_x_association_tbl(i).DML_OPERATION ='D'
1062: THEN
1063: DELETE_ASSOCIATION
1064: ( p_api_version => 1.0 ,
1065: p_init_msg_list => FND_API.G_TRUE ,
1066: p_commit => FND_API.G_FALSE ,
1067: p_validate_only => FND_API.G_TRUE ,
1068: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1069: p_association_rec => p_x_association_tbl(i) ,

Line 1066: p_commit => FND_API.G_FALSE ,

1062: THEN
1063: DELETE_ASSOCIATION
1064: ( p_api_version => 1.0 ,
1065: p_init_msg_list => FND_API.G_TRUE ,
1066: p_commit => FND_API.G_FALSE ,
1067: p_validate_only => FND_API.G_TRUE ,
1068: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1069: p_association_rec => p_x_association_tbl(i) ,
1070: x_return_status => x_return_status ,

Line 1067: p_validate_only => FND_API.G_TRUE ,

1063: DELETE_ASSOCIATION
1064: ( p_api_version => 1.0 ,
1065: p_init_msg_list => FND_API.G_TRUE ,
1066: p_commit => FND_API.G_FALSE ,
1067: p_validate_only => FND_API.G_TRUE ,
1068: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1069: p_association_rec => p_x_association_tbl(i) ,
1070: x_return_status => x_return_status ,
1071: x_msg_count => x_msg_count ,

Line 1068: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

1064: ( p_api_version => 1.0 ,
1065: p_init_msg_list => FND_API.G_TRUE ,
1066: p_commit => FND_API.G_FALSE ,
1067: p_validate_only => FND_API.G_TRUE ,
1068: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1069: p_association_rec => p_x_association_tbl(i) ,
1070: x_return_status => x_return_status ,
1071: x_msg_count => x_msg_count ,
1072: x_msg_data => x_msg_data);

Line 1211: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1207: l_msg_count := FND_MSG_PUB.count_msg;
1208:
1209: IF l_msg_count > 0 THEN
1210: X_msg_count := l_msg_count;
1211: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1212: RAISE FND_API.G_EXC_ERROR;
1213: END IF;
1214:
1215: END IF;

Line 1212: RAISE FND_API.G_EXC_ERROR;

1208:
1209: IF l_msg_count > 0 THEN
1210: X_msg_count := l_msg_count;
1211: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1212: RAISE FND_API.G_EXC_ERROR;
1213: END IF;
1214:
1215: END IF;
1216: --Standard check for commit

Line 1217: IF FND_API.TO_BOOLEAN(p_commit) THEN

1213: END IF;
1214:
1215: END IF;
1216: --Standard check for commit
1217: IF FND_API.TO_BOOLEAN(p_commit) THEN
1218: COMMIT;
1219: END IF;
1220: -- Debug info
1221: IF G_DEBUG='Y' THEN

Line 1232: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1228:
1229: END IF;
1230:
1231: EXCEPTION
1232: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1233: ROLLBACK TO process_association;
1234: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1235: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
1236: p_count => x_msg_count,

Line 1234: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1230:
1231: EXCEPTION
1232: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1233: ROLLBACK TO process_association;
1234: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1235: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
1236: p_count => x_msg_count,
1237: p_data => x_msg_data);
1238:

Line 1235: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

1231: EXCEPTION
1232: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1233: ROLLBACK TO process_association;
1234: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1235: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
1236: p_count => x_msg_count,
1237: p_data => x_msg_data);
1238:
1239: --Debug Info

Line 1250: WHEN FND_API.G_EXC_ERROR THEN

1246: AHL_DEBUG_PUB.disable_debug;
1247:
1248: END IF;
1249:
1250: WHEN FND_API.G_EXC_ERROR THEN
1251: ROLLBACK TO process_association;
1252: X_return_status := FND_API.G_RET_STS_ERROR;
1253: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
1254: p_count => x_msg_count,

Line 1252: X_return_status := FND_API.G_RET_STS_ERROR;

1248: END IF;
1249:
1250: WHEN FND_API.G_EXC_ERROR THEN
1251: ROLLBACK TO process_association;
1252: X_return_status := FND_API.G_RET_STS_ERROR;
1253: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
1254: p_count => x_msg_count,
1255: p_data => X_msg_data);
1256:

Line 1253: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

1249:
1250: WHEN FND_API.G_EXC_ERROR THEN
1251: ROLLBACK TO process_association;
1252: X_return_status := FND_API.G_RET_STS_ERROR;
1253: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
1254: p_count => x_msg_count,
1255: p_data => X_msg_data);
1256:
1257: -- Debug info.

Line 1270: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1266: END IF;
1267:
1268: WHEN OTHERS THEN
1269: ROLLBACK TO process_association;
1270: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1271: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1272: THEN
1273: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_DI_ASSO_DOC_GEN_PVT',
1274: p_procedure_name => 'PROCESS_ASSOCIATION',

Line 1277: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

1273: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_DI_ASSO_DOC_GEN_PVT',
1274: p_procedure_name => 'PROCESS_ASSOCIATION',
1275: p_error_text => SUBSTR(SQLERRM,1,240));
1276: END IF;
1277: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
1278: p_count => x_msg_count,
1279: p_data => X_msg_data);
1280: -- Debug info.
1281: IF G_DEBUG='Y' THEN

Line 1296: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_TRUE ,

1292:
1293: PROCEDURE INSERT_ASSOC_REC
1294: (
1295: p_api_version IN NUMBER := 1.0 ,
1296: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_TRUE ,
1297: p_commit IN VARCHAR2 := Fnd_Api.G_FALSE ,
1298: p_validate_only IN VARCHAR2 := Fnd_Api.G_TRUE ,
1299: p_validation_level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL,
1300: p_association_rec IN ahl_doc_title_assos_vl%ROWTYPE ,

Line 1297: p_commit IN VARCHAR2 := Fnd_Api.G_FALSE ,

1293: PROCEDURE INSERT_ASSOC_REC
1294: (
1295: p_api_version IN NUMBER := 1.0 ,
1296: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_TRUE ,
1297: p_commit IN VARCHAR2 := Fnd_Api.G_FALSE ,
1298: p_validate_only IN VARCHAR2 := Fnd_Api.G_TRUE ,
1299: p_validation_level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL,
1300: p_association_rec IN ahl_doc_title_assos_vl%ROWTYPE ,
1301: x_return_status OUT NOCOPY VARCHAR2 ,

Line 1298: p_validate_only IN VARCHAR2 := Fnd_Api.G_TRUE ,

1294: (
1295: p_api_version IN NUMBER := 1.0 ,
1296: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_TRUE ,
1297: p_commit IN VARCHAR2 := Fnd_Api.G_FALSE ,
1298: p_validate_only IN VARCHAR2 := Fnd_Api.G_TRUE ,
1299: p_validation_level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL,
1300: p_association_rec IN ahl_doc_title_assos_vl%ROWTYPE ,
1301: x_return_status OUT NOCOPY VARCHAR2 ,
1302: x_msg_count OUT NOCOPY NUMBER ,

Line 1299: p_validation_level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL,

1295: p_api_version IN NUMBER := 1.0 ,
1296: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_TRUE ,
1297: p_commit IN VARCHAR2 := Fnd_Api.G_FALSE ,
1298: p_validate_only IN VARCHAR2 := Fnd_Api.G_TRUE ,
1299: p_validation_level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL,
1300: p_association_rec IN ahl_doc_title_assos_vl%ROWTYPE ,
1301: x_return_status OUT NOCOPY VARCHAR2 ,
1302: x_msg_count OUT NOCOPY NUMBER ,
1303: x_msg_data OUT NOCOPY VARCHAR2)

Line 1381: IF Fnd_Api.to_boolean(p_init_msg_list)

1377:
1378: END IF;
1379: END IF;
1380: -- Standard call to check for call compatibility.
1381: IF Fnd_Api.to_boolean(p_init_msg_list)
1382: THEN
1383: Fnd_Msg_Pub.initialize;
1384: END IF;
1385: -- Initialize API return status to success

Line 1388: IF NOT Fnd_Api.COMPATIBLE_API_CALL(l_api_version,

1384: END IF;
1385: -- Initialize API return status to success
1386: x_return_status := 'S';
1387: -- Initialize message list if p_init_msg_list is set to TRUE.
1388: IF NOT Fnd_Api.COMPATIBLE_API_CALL(l_api_version,
1389: p_api_version,
1390: l_api_name,G_PKG_NAME)
1391: THEN
1392: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;

Line 1392: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;

1388: IF NOT Fnd_Api.COMPATIBLE_API_CALL(l_api_version,
1389: p_api_version,
1390: l_api_name,G_PKG_NAME)
1391: THEN
1392: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
1393: END IF;
1394: --Start of API Body
1395: L_RECORD:='';
1396: VALIDATE_ASSOCIATION

Line 1417: X_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

1413: l_msg_count := Fnd_Msg_Pub.count_msg;
1414:
1415: IF l_msg_count > 0 THEN
1416: X_msg_count := l_msg_count;
1417: X_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1418: RAISE Fnd_Api.G_EXC_ERROR;
1419: END IF;
1420:
1421: IF p_association_rec.doc_title_asso_id = Fnd_Api.G_MISS_NUM

Line 1418: RAISE Fnd_Api.G_EXC_ERROR;

1414:
1415: IF l_msg_count > 0 THEN
1416: X_msg_count := l_msg_count;
1417: X_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1418: RAISE Fnd_Api.G_EXC_ERROR;
1419: END IF;
1420:
1421: IF p_association_rec.doc_title_asso_id = Fnd_Api.G_MISS_NUM
1422: THEN

Line 1421: IF p_association_rec.doc_title_asso_id = Fnd_Api.G_MISS_NUM

1417: X_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1418: RAISE Fnd_Api.G_EXC_ERROR;
1419: END IF;
1420:
1421: IF p_association_rec.doc_title_asso_id = Fnd_Api.G_MISS_NUM
1422: THEN
1423: --The following conditions are required for optional fields
1424: IF p_association_rec.doc_revision_id = Fnd_Api.G_MISS_NUM
1425: THEN

Line 1424: IF p_association_rec.doc_revision_id = Fnd_Api.G_MISS_NUM

1420:
1421: IF p_association_rec.doc_title_asso_id = Fnd_Api.G_MISS_NUM
1422: THEN
1423: --The following conditions are required for optional fields
1424: IF p_association_rec.doc_revision_id = Fnd_Api.G_MISS_NUM
1425: THEN
1426: l_association_info.doc_revision_id := NULL;
1427: ELSE
1428: l_association_info.doc_revision_id := p_association_rec.doc_revision_id;

Line 1432: IF (p_association_rec.use_latest_rev_flag = Fnd_Api.G_MISS_CHAR

1428: l_association_info.doc_revision_id := p_association_rec.doc_revision_id;
1429: END IF;
1430: -- If document revision doesnt exist then latest rev flag
1431: -- is 'YES' else which ever user selects (Default 'NO')
1432: IF (p_association_rec.use_latest_rev_flag = Fnd_Api.G_MISS_CHAR
1433: AND
1434: l_association_info.doc_revision_id IS NULL)
1435: THEN
1436: l_association_info.use_latest_rev_flag := 'Y';

Line 1437: ELSIF (p_association_rec.use_latest_rev_flag <> Fnd_Api.G_MISS_CHAR

1433: AND
1434: l_association_info.doc_revision_id IS NULL)
1435: THEN
1436: l_association_info.use_latest_rev_flag := 'Y';
1437: ELSIF (p_association_rec.use_latest_rev_flag <> Fnd_Api.G_MISS_CHAR
1438: AND
1439: l_association_info.doc_revision_id IS NULL)
1440: THEN
1441: l_association_info.use_latest_rev_flag := p_association_rec.use_latest_rev_flag;

Line 1442: ELSIF (p_association_rec.use_latest_rev_flag <> Fnd_Api.G_MISS_CHAR

1438: AND
1439: l_association_info.doc_revision_id IS NULL)
1440: THEN
1441: l_association_info.use_latest_rev_flag := p_association_rec.use_latest_rev_flag;
1442: ELSIF (p_association_rec.use_latest_rev_flag <> Fnd_Api.G_MISS_CHAR
1443: AND
1444: l_association_info.doc_revision_id IS NOT NULL)
1445: THEN
1446: l_association_info.use_latest_rev_flag := p_association_rec.use_latest_rev_flag;

Line 1452: IF p_association_rec.serial_no = Fnd_Api.G_MISS_CHAR

1448: ELSE
1449: l_association_info.use_latest_rev_flag := 'N';
1450: END IF;
1451: --
1452: IF p_association_rec.serial_no = Fnd_Api.G_MISS_CHAR
1453: THEN
1454: l_association_info.serial_no := NULL;
1455: ELSE
1456: l_association_info.serial_no := p_association_rec.serial_no;

Line 1459: IF p_association_rec.chapter = Fnd_Api.G_MISS_CHAR

1455: ELSE
1456: l_association_info.serial_no := p_association_rec.serial_no;
1457: END IF;
1458: --
1459: IF p_association_rec.chapter = Fnd_Api.G_MISS_CHAR
1460: THEN
1461: l_association_info.chapter := NULL;
1462: ELSE
1463: l_association_info.chapter := p_association_rec.chapter;

Line 1466: IF p_association_rec.SECTION = Fnd_Api.G_MISS_CHAR

1462: ELSE
1463: l_association_info.chapter := p_association_rec.chapter;
1464: END IF;
1465: --
1466: IF p_association_rec.SECTION = Fnd_Api.G_MISS_CHAR
1467: THEN
1468: l_association_info.SECTION := NULL;
1469: ELSE
1470: l_association_info.SECTION := p_association_rec.SECTION;

Line 1473: IF p_association_rec.subject = Fnd_Api.G_MISS_CHAR

1469: ELSE
1470: l_association_info.SECTION := p_association_rec.SECTION;
1471: END IF;
1472: --
1473: IF p_association_rec.subject = Fnd_Api.G_MISS_CHAR
1474: THEN
1475: l_association_info.subject := NULL;
1476: ELSE
1477: l_association_info.subject := p_association_rec.subject;

Line 1480: IF p_association_rec.page = Fnd_Api.G_MISS_CHAR

1476: ELSE
1477: l_association_info.subject := p_association_rec.subject;
1478: END IF;
1479: --
1480: IF p_association_rec.page = Fnd_Api.G_MISS_CHAR
1481: THEN
1482: l_association_info.page := NULL;
1483: ELSE
1484: l_association_info.page := p_association_rec.page;

Line 1487: IF p_association_rec.figure = Fnd_Api.G_MISS_CHAR

1483: ELSE
1484: l_association_info.page := p_association_rec.page;
1485: END IF;
1486: --
1487: IF p_association_rec.figure = Fnd_Api.G_MISS_CHAR
1488: THEN
1489: l_association_info.figure := NULL;
1490: ELSE
1491: l_association_info.figure := p_association_rec.figure;

Line 1494: IF p_association_rec.note = Fnd_Api.G_MISS_CHAR

1490: ELSE
1491: l_association_info.figure := p_association_rec.figure;
1492: END IF;
1493: --
1494: IF p_association_rec.note = Fnd_Api.G_MISS_CHAR
1495: THEN
1496: l_association_info.note := NULL;
1497: ELSE
1498: l_association_info.note := p_association_rec.note;

Line 1501: IF p_association_rec.attribute_category = Fnd_Api.G_MISS_CHAR

1497: ELSE
1498: l_association_info.note := p_association_rec.note;
1499: END IF;
1500: --
1501: IF p_association_rec.attribute_category = Fnd_Api.G_MISS_CHAR
1502: THEN
1503: l_association_info.attribute_category := NULL;
1504: ELSE
1505: l_association_info.attribute_category := p_association_rec.attribute_category;

Line 1508: IF p_association_rec.attribute1 = Fnd_Api.G_MISS_CHAR

1504: ELSE
1505: l_association_info.attribute_category := p_association_rec.attribute_category;
1506: END IF;
1507: --
1508: IF p_association_rec.attribute1 = Fnd_Api.G_MISS_CHAR
1509: THEN
1510: l_association_info.attribute1 := NULL;
1511: ELSE
1512: l_association_info.attribute1 := p_association_rec.attribute1;

Line 1515: IF p_association_rec.attribute2 = Fnd_Api.G_MISS_CHAR

1511: ELSE
1512: l_association_info.attribute1 := p_association_rec.attribute1;
1513: END IF;
1514: --
1515: IF p_association_rec.attribute2 = Fnd_Api.G_MISS_CHAR
1516: THEN
1517: l_association_info.attribute2 := NULL;
1518: ELSE
1519: l_association_info.attribute2 := p_association_rec.attribute2;

Line 1522: IF p_association_rec.attribute3 = Fnd_Api.G_MISS_CHAR

1518: ELSE
1519: l_association_info.attribute2 := p_association_rec.attribute2;
1520: END IF;
1521: --
1522: IF p_association_rec.attribute3 = Fnd_Api.G_MISS_CHAR
1523: THEN
1524: l_association_info.attribute3 := NULL;
1525: ELSE
1526: l_association_info.attribute3 := p_association_rec.attribute3;

Line 1529: IF p_association_rec.attribute4 = Fnd_Api.G_MISS_CHAR

1525: ELSE
1526: l_association_info.attribute3 := p_association_rec.attribute3;
1527: END IF;
1528: --
1529: IF p_association_rec.attribute4 = Fnd_Api.G_MISS_CHAR
1530: THEN
1531: l_association_info.attribute4 := NULL;
1532: ELSE
1533: l_association_info.attribute4 := p_association_rec.attribute4;

Line 1536: IF p_association_rec.attribute5 = Fnd_Api.G_MISS_CHAR

1532: ELSE
1533: l_association_info.attribute4 := p_association_rec.attribute4;
1534: END IF;
1535: --
1536: IF p_association_rec.attribute5 = Fnd_Api.G_MISS_CHAR
1537: THEN
1538: l_association_info.attribute5 := NULL;
1539: ELSE
1540: l_association_info.attribute5 := p_association_rec.attribute5;

Line 1543: IF p_association_rec.attribute6 = Fnd_Api.G_MISS_CHAR

1539: ELSE
1540: l_association_info.attribute5 := p_association_rec.attribute5;
1541: END IF;
1542: --
1543: IF p_association_rec.attribute6 = Fnd_Api.G_MISS_CHAR
1544: THEN
1545: l_association_info.attribute6 := NULL;
1546: ELSE
1547: l_association_info.attribute6 := p_association_rec.attribute6;

Line 1550: IF p_association_rec.attribute7 = Fnd_Api.G_MISS_CHAR

1546: ELSE
1547: l_association_info.attribute6 := p_association_rec.attribute6;
1548: END IF;
1549: --
1550: IF p_association_rec.attribute7 = Fnd_Api.G_MISS_CHAR
1551: THEN
1552: l_association_info.attribute7 := NULL;
1553: ELSE
1554: l_association_info.attribute7 := p_association_rec.attribute7;

Line 1557: IF p_association_rec.attribute8 = Fnd_Api.G_MISS_CHAR

1553: ELSE
1554: l_association_info.attribute7 := p_association_rec.attribute7;
1555: END IF;
1556: --
1557: IF p_association_rec.attribute8 = Fnd_Api.G_MISS_CHAR
1558: THEN
1559: l_association_info.attribute8 := NULL;
1560: ELSE
1561: l_association_info.attribute8 := p_association_rec.attribute8;

Line 1564: IF p_association_rec.attribute9 = Fnd_Api.G_MISS_CHAR

1560: ELSE
1561: l_association_info.attribute8 := p_association_rec.attribute8;
1562: END IF;
1563: --
1564: IF p_association_rec.attribute9 = Fnd_Api.G_MISS_CHAR
1565: THEN
1566: l_association_info.attribute9 := NULL;
1567: ELSE
1568: l_association_info.attribute9 := p_association_rec.attribute9;

Line 1571: IF p_association_rec.attribute10 = Fnd_Api.G_MISS_CHAR

1567: ELSE
1568: l_association_info.attribute9 := p_association_rec.attribute9;
1569: END IF;
1570: --
1571: IF p_association_rec.attribute10 = Fnd_Api.G_MISS_CHAR
1572: THEN
1573: l_association_info.attribute10 := NULL;
1574: ELSE
1575: l_association_info.attribute10 := p_association_rec.attribute10;

Line 1578: IF p_association_rec.attribute11 = Fnd_Api.G_MISS_CHAR

1574: ELSE
1575: l_association_info.attribute10 := p_association_rec.attribute10;
1576: END IF;
1577: --
1578: IF p_association_rec.attribute11 = Fnd_Api.G_MISS_CHAR
1579: THEN
1580: l_association_info.attribute11 := NULL;
1581: ELSE
1582: l_association_info.attribute11 := p_association_rec.attribute11;

Line 1585: IF p_association_rec.attribute12 = Fnd_Api.G_MISS_CHAR

1581: ELSE
1582: l_association_info.attribute11 := p_association_rec.attribute11;
1583: END IF;
1584: --
1585: IF p_association_rec.attribute12 = Fnd_Api.G_MISS_CHAR
1586: THEN
1587: l_association_info.attribute12 := NULL;
1588: ELSE
1589: l_association_info.attribute12 := p_association_rec.attribute12;

Line 1592: IF p_association_rec.attribute13 = Fnd_Api.G_MISS_CHAR

1588: ELSE
1589: l_association_info.attribute12 := p_association_rec.attribute12;
1590: END IF;
1591: --
1592: IF p_association_rec.attribute13 = Fnd_Api.G_MISS_CHAR
1593: THEN
1594: l_association_info.attribute13 := NULL;
1595: ELSE
1596: l_association_info.attribute13 := p_association_rec.attribute13;

Line 1599: IF p_association_rec.attribute14 = Fnd_Api.G_MISS_CHAR

1595: ELSE
1596: l_association_info.attribute13 := p_association_rec.attribute13;
1597: END IF;
1598: --
1599: IF p_association_rec.attribute14 = Fnd_Api.G_MISS_CHAR
1600: THEN
1601: l_association_info.attribute14 := NULL;
1602: ELSE
1603: l_association_info.attribute14 := p_association_rec.attribute14;

Line 1606: IF p_association_rec.attribute15 = Fnd_Api.G_MISS_CHAR

1602: ELSE
1603: l_association_info.attribute14 := p_association_rec.attribute14;
1604: END IF;
1605: --
1606: IF p_association_rec.attribute15 = Fnd_Api.G_MISS_CHAR
1607: THEN
1608: l_association_info.attribute15 := NULL;
1609: ELSE
1610: l_association_info.attribute15 := p_association_rec.attribute15;

Line 1635: RAISE Fnd_Api.G_EXC_ERROR;

1631: IF dup_rec_check%FOUND THEN
1632: Fnd_Message.SET_NAME('AHL','AHL_DI_DOC_ASSOS_DUP_RECORD');
1633: Fnd_Message.SET_TOKEN('DUPRECORD',l_document_no);
1634: Fnd_Msg_Pub.ADD;
1635: RAISE Fnd_Api.G_EXC_ERROR;
1636: END IF;
1637: CLOSE dup_rec_check;
1638: ELSE
1639: OPEN dup_rec( p_association_rec.aso_object_type_code,

Line 1648: RAISE Fnd_Api.G_EXC_ERROR;

1644: IF dup_rec%FOUND THEN
1645: Fnd_Message.SET_NAME('AHL','AHL_DI_DOC_ASSOS_DUP_RECORD');
1646: Fnd_Message.SET_TOKEN('DUPRECORD',l_document_no);
1647: Fnd_Msg_Pub.ADD;
1648: RAISE Fnd_Api.G_EXC_ERROR;
1649: END IF;
1650: CLOSE dup_rec;
1651: END IF;
1652:

Line 1707: X_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

1703: l_msg_count := Fnd_Msg_Pub.count_msg;
1704:
1705: IF l_msg_count > 0 THEN
1706: X_msg_count := l_msg_count;
1707: X_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1708: RAISE Fnd_Api.G_EXC_ERROR;
1709: END IF;
1710: END IF;
1711: --Standard check for commit

Line 1708: RAISE Fnd_Api.G_EXC_ERROR;

1704:
1705: IF l_msg_count > 0 THEN
1706: X_msg_count := l_msg_count;
1707: X_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1708: RAISE Fnd_Api.G_EXC_ERROR;
1709: END IF;
1710: END IF;
1711: --Standard check for commit
1712: IF Fnd_Api.TO_BOOLEAN(p_commit) THEN

Line 1712: IF Fnd_Api.TO_BOOLEAN(p_commit) THEN

1708: RAISE Fnd_Api.G_EXC_ERROR;
1709: END IF;
1710: END IF;
1711: --Standard check for commit
1712: IF Fnd_Api.TO_BOOLEAN(p_commit) THEN
1713: COMMIT;
1714: END IF;
1715: -- Debug info
1716: IF G_DEBUG='Y' THEN

Line 1727: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN

1723:
1724: END IF;
1725:
1726: EXCEPTION
1727: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
1728: ROLLBACK TO insert_assoc_rec;
1729: X_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1730: Fnd_Msg_Pub.count_and_get( p_encoded => Fnd_Api.G_FALSE,
1731: p_count => x_msg_count,

Line 1729: X_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

1725:
1726: EXCEPTION
1727: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
1728: ROLLBACK TO insert_assoc_rec;
1729: X_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1730: Fnd_Msg_Pub.count_and_get( p_encoded => Fnd_Api.G_FALSE,
1731: p_count => x_msg_count,
1732: p_data => x_msg_data);
1733:

Line 1730: Fnd_Msg_Pub.count_and_get( p_encoded => Fnd_Api.G_FALSE,

1726: EXCEPTION
1727: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
1728: ROLLBACK TO insert_assoc_rec;
1729: X_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1730: Fnd_Msg_Pub.count_and_get( p_encoded => Fnd_Api.G_FALSE,
1731: p_count => x_msg_count,
1732: p_data => x_msg_data);
1733:
1734: --Debug Info

Line 1745: WHEN Fnd_Api.G_EXC_ERROR THEN

1741: AHL_DEBUG_PUB.disable_debug;
1742:
1743: END IF;
1744:
1745: WHEN Fnd_Api.G_EXC_ERROR THEN
1746: ROLLBACK TO insert_assoc_rec;
1747: X_return_status := Fnd_Api.G_RET_STS_ERROR;
1748: Fnd_Msg_Pub.count_and_get( p_encoded => Fnd_Api.G_FALSE,
1749: p_count => x_msg_count,

Line 1747: X_return_status := Fnd_Api.G_RET_STS_ERROR;

1743: END IF;
1744:
1745: WHEN Fnd_Api.G_EXC_ERROR THEN
1746: ROLLBACK TO insert_assoc_rec;
1747: X_return_status := Fnd_Api.G_RET_STS_ERROR;
1748: Fnd_Msg_Pub.count_and_get( p_encoded => Fnd_Api.G_FALSE,
1749: p_count => x_msg_count,
1750: p_data => X_msg_data);
1751:

Line 1748: Fnd_Msg_Pub.count_and_get( p_encoded => Fnd_Api.G_FALSE,

1744:
1745: WHEN Fnd_Api.G_EXC_ERROR THEN
1746: ROLLBACK TO insert_assoc_rec;
1747: X_return_status := Fnd_Api.G_RET_STS_ERROR;
1748: Fnd_Msg_Pub.count_and_get( p_encoded => Fnd_Api.G_FALSE,
1749: p_count => x_msg_count,
1750: p_data => X_msg_data);
1751:
1752: -- Debug info.

Line 1765: X_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

1761: END IF;
1762:
1763: WHEN OTHERS THEN
1764: ROLLBACK TO insert_assoc_rec;
1765: X_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1766: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
1767: THEN
1768: Fnd_Msg_Pub.add_exc_msg(p_pkg_name => 'AHL_DI_ASSO_DOC_GEN_PVT',
1769: p_procedure_name => 'INSERT_ASSOC_REC',

Line 1772: Fnd_Msg_Pub.count_and_get( p_encoded => Fnd_Api.G_FALSE,

1768: Fnd_Msg_Pub.add_exc_msg(p_pkg_name => 'AHL_DI_ASSO_DOC_GEN_PVT',
1769: p_procedure_name => 'INSERT_ASSOC_REC',
1770: p_error_text => SUBSTR(SQLERRM,1,240));
1771: END IF;
1772: Fnd_Msg_Pub.count_and_get( p_encoded => Fnd_Api.G_FALSE,
1773: p_count => x_msg_count,
1774: p_data => X_msg_data);
1775: -- Debug info.
1776: IF G_DEBUG='Y' THEN

Line 1799: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_TRUE ,

1795: /*------------------------------------------------------*/
1796: Procedure COPY_ASSOCIATION
1797: (
1798: p_api_version IN NUMBER := 1.0 ,
1799: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_TRUE ,
1800: p_commit IN VARCHAR2 := Fnd_Api.G_FALSE ,
1801: p_validate_only IN VARCHAR2 := Fnd_Api.G_TRUE ,
1802: p_validation_level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL,
1803: p_from_object_id IN NUMBER,

Line 1800: p_commit IN VARCHAR2 := Fnd_Api.G_FALSE ,

1796: Procedure COPY_ASSOCIATION
1797: (
1798: p_api_version IN NUMBER := 1.0 ,
1799: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_TRUE ,
1800: p_commit IN VARCHAR2 := Fnd_Api.G_FALSE ,
1801: p_validate_only IN VARCHAR2 := Fnd_Api.G_TRUE ,
1802: p_validation_level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL,
1803: p_from_object_id IN NUMBER,
1804: p_from_object_type IN VARCHAR2,

Line 1801: p_validate_only IN VARCHAR2 := Fnd_Api.G_TRUE ,

1797: (
1798: p_api_version IN NUMBER := 1.0 ,
1799: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_TRUE ,
1800: p_commit IN VARCHAR2 := Fnd_Api.G_FALSE ,
1801: p_validate_only IN VARCHAR2 := Fnd_Api.G_TRUE ,
1802: p_validation_level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL,
1803: p_from_object_id IN NUMBER,
1804: p_from_object_type IN VARCHAR2,
1805: p_to_object_id IN NUMBER,

Line 1802: p_validation_level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL,

1798: p_api_version IN NUMBER := 1.0 ,
1799: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_TRUE ,
1800: p_commit IN VARCHAR2 := Fnd_Api.G_FALSE ,
1801: p_validate_only IN VARCHAR2 := Fnd_Api.G_TRUE ,
1802: p_validation_level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL,
1803: p_from_object_id IN NUMBER,
1804: p_from_object_type IN VARCHAR2,
1805: p_to_object_id IN NUMBER,
1806: p_to_object_type IN VARCHAR2,

Line 1841: IF Fnd_Api.to_boolean(p_init_msg_list)

1837:
1838: END IF;
1839: END IF;
1840: -- Standard call to check for call compatibility.
1841: IF Fnd_Api.to_boolean(p_init_msg_list)
1842: THEN
1843: Fnd_Msg_Pub.initialize;
1844: END IF;
1845: -- Initialize API return status to success

Line 1848: IF NOT Fnd_Api.COMPATIBLE_API_CALL(l_api_version,

1844: END IF;
1845: -- Initialize API return status to success
1846: x_return_status := 'S';
1847: -- Initialize message list if p_init_msg_list is set to TRUE.
1848: IF NOT Fnd_Api.COMPATIBLE_API_CALL(l_api_version,
1849: p_api_version,
1850: l_api_name,G_PKG_NAME)
1851: THEN
1852: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;

Line 1852: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;

1848: IF NOT Fnd_Api.COMPATIBLE_API_CALL(l_api_version,
1849: p_api_version,
1850: l_api_name,G_PKG_NAME)
1851: THEN
1852: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
1853: END IF;
1854: IF G_DEBUG='Y' THEN
1855: IF G_DEBUG='Y' THEN
1856: AHL_DEBUG_PUB.debug( 'enter AHL_DI_ASSO_DOC_GEN_PVT.Copy Association:'||p_from_object_id ,'+DOBJASS+');

Line 1896: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

1892: END;
1893: l_msg_count := Fnd_Msg_Pub.count_msg;
1894: IF l_msg_count > 0 THEN
1895: x_msg_count := l_msg_count;
1896: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1897: RAISE Fnd_Api.G_EXC_ERROR;
1898: END IF;
1899: END IF;
1900: --Assign the new object id and object type

Line 1897: RAISE Fnd_Api.G_EXC_ERROR;

1893: l_msg_count := Fnd_Msg_Pub.count_msg;
1894: IF l_msg_count > 0 THEN
1895: x_msg_count := l_msg_count;
1896: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1897: RAISE Fnd_Api.G_EXC_ERROR;
1898: END IF;
1899: END IF;
1900: --Assign the new object id and object type
1901: l_association_rec.doc_title_asso_id := Fnd_Api.G_MISS_NUM;

Line 1901: l_association_rec.doc_title_asso_id := Fnd_Api.G_MISS_NUM;

1897: RAISE Fnd_Api.G_EXC_ERROR;
1898: END IF;
1899: END IF;
1900: --Assign the new object id and object type
1901: l_association_rec.doc_title_asso_id := Fnd_Api.G_MISS_NUM;
1902: l_association_rec.aso_object_id := p_to_object_id;
1903: l_association_rec.aso_object_type_code := p_from_object_type;
1904: --Call to insert new association records
1905: INSERT_ASSOC_REC

Line 1907: p_init_msg_list => Fnd_Api.G_TRUE ,

1903: l_association_rec.aso_object_type_code := p_from_object_type;
1904: --Call to insert new association records
1905: INSERT_ASSOC_REC
1906: ( p_api_version => 1.0 ,
1907: p_init_msg_list => Fnd_Api.G_TRUE ,
1908: p_commit => Fnd_Api.G_FALSE ,
1909: p_validate_only => Fnd_Api.G_TRUE ,
1910: p_validation_level => Fnd_Api.G_VALID_LEVEL_FULL,
1911: p_association_rec => l_association_rec ,

Line 1908: p_commit => Fnd_Api.G_FALSE ,

1904: --Call to insert new association records
1905: INSERT_ASSOC_REC
1906: ( p_api_version => 1.0 ,
1907: p_init_msg_list => Fnd_Api.G_TRUE ,
1908: p_commit => Fnd_Api.G_FALSE ,
1909: p_validate_only => Fnd_Api.G_TRUE ,
1910: p_validation_level => Fnd_Api.G_VALID_LEVEL_FULL,
1911: p_association_rec => l_association_rec ,
1912: x_return_status => x_return_status ,

Line 1909: p_validate_only => Fnd_Api.G_TRUE ,

1905: INSERT_ASSOC_REC
1906: ( p_api_version => 1.0 ,
1907: p_init_msg_list => Fnd_Api.G_TRUE ,
1908: p_commit => Fnd_Api.G_FALSE ,
1909: p_validate_only => Fnd_Api.G_TRUE ,
1910: p_validation_level => Fnd_Api.G_VALID_LEVEL_FULL,
1911: p_association_rec => l_association_rec ,
1912: x_return_status => x_return_status ,
1913: x_msg_count => x_msg_count ,

Line 1910: p_validation_level => Fnd_Api.G_VALID_LEVEL_FULL,

1906: ( p_api_version => 1.0 ,
1907: p_init_msg_list => Fnd_Api.G_TRUE ,
1908: p_commit => Fnd_Api.G_FALSE ,
1909: p_validate_only => Fnd_Api.G_TRUE ,
1910: p_validation_level => Fnd_Api.G_VALID_LEVEL_FULL,
1911: p_association_rec => l_association_rec ,
1912: x_return_status => x_return_status ,
1913: x_msg_count => x_msg_count ,
1914: x_msg_data => x_msg_data);

Line 1923: X_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

1919: l_msg_count := Fnd_Msg_Pub.count_msg;
1920:
1921: IF l_msg_count > 0 THEN
1922: X_msg_count := l_msg_count;
1923: X_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1924: RAISE Fnd_Api.G_EXC_ERROR;
1925: END IF;
1926: --Standard check for commit
1927: IF Fnd_Api.TO_BOOLEAN(p_commit) THEN

Line 1924: RAISE Fnd_Api.G_EXC_ERROR;

1920:
1921: IF l_msg_count > 0 THEN
1922: X_msg_count := l_msg_count;
1923: X_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1924: RAISE Fnd_Api.G_EXC_ERROR;
1925: END IF;
1926: --Standard check for commit
1927: IF Fnd_Api.TO_BOOLEAN(p_commit) THEN
1928: COMMIT;

Line 1927: IF Fnd_Api.TO_BOOLEAN(p_commit) THEN

1923: X_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1924: RAISE Fnd_Api.G_EXC_ERROR;
1925: END IF;
1926: --Standard check for commit
1927: IF Fnd_Api.TO_BOOLEAN(p_commit) THEN
1928: COMMIT;
1929: END IF;
1930: -- Debug info
1931: IF G_DEBUG='Y' THEN

Line 1942: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN

1938:
1939: END IF;
1940:
1941: EXCEPTION
1942: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
1943: ROLLBACK TO copy_association;
1944: X_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1945: Fnd_Msg_Pub.count_and_get( p_encoded => Fnd_Api.G_FALSE,
1946: p_count => x_msg_count,

Line 1944: X_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

1940:
1941: EXCEPTION
1942: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
1943: ROLLBACK TO copy_association;
1944: X_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1945: Fnd_Msg_Pub.count_and_get( p_encoded => Fnd_Api.G_FALSE,
1946: p_count => x_msg_count,
1947: p_data => x_msg_data);
1948:

Line 1945: Fnd_Msg_Pub.count_and_get( p_encoded => Fnd_Api.G_FALSE,

1941: EXCEPTION
1942: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
1943: ROLLBACK TO copy_association;
1944: X_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1945: Fnd_Msg_Pub.count_and_get( p_encoded => Fnd_Api.G_FALSE,
1946: p_count => x_msg_count,
1947: p_data => x_msg_data);
1948:
1949: --Debug Info

Line 1960: WHEN Fnd_Api.G_EXC_ERROR THEN

1956: AHL_DEBUG_PUB.disable_debug;
1957:
1958: END IF;
1959:
1960: WHEN Fnd_Api.G_EXC_ERROR THEN
1961: ROLLBACK TO copy_association;
1962: X_return_status := Fnd_Api.G_RET_STS_ERROR;
1963: Fnd_Msg_Pub.count_and_get( p_encoded => Fnd_Api.G_FALSE,
1964: p_count => x_msg_count,

Line 1962: X_return_status := Fnd_Api.G_RET_STS_ERROR;

1958: END IF;
1959:
1960: WHEN Fnd_Api.G_EXC_ERROR THEN
1961: ROLLBACK TO copy_association;
1962: X_return_status := Fnd_Api.G_RET_STS_ERROR;
1963: Fnd_Msg_Pub.count_and_get( p_encoded => Fnd_Api.G_FALSE,
1964: p_count => x_msg_count,
1965: p_data => X_msg_data);
1966: -- Debug info.

Line 1963: Fnd_Msg_Pub.count_and_get( p_encoded => Fnd_Api.G_FALSE,

1959:
1960: WHEN Fnd_Api.G_EXC_ERROR THEN
1961: ROLLBACK TO copy_association;
1962: X_return_status := Fnd_Api.G_RET_STS_ERROR;
1963: Fnd_Msg_Pub.count_and_get( p_encoded => Fnd_Api.G_FALSE,
1964: p_count => x_msg_count,
1965: p_data => X_msg_data);
1966: -- Debug info.
1967: IF G_DEBUG='Y' THEN

Line 1979: X_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

1975: END IF;
1976:
1977: WHEN OTHERS THEN
1978: ROLLBACK TO copy_association;
1979: X_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1980: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
1981: THEN
1982: Fnd_Msg_Pub.add_exc_msg(p_pkg_name => 'AHL_DI_ASSO_DOC_GEN_PVT',
1983: p_procedure_name => 'COPY_ASSOCIATION',

Line 1986: Fnd_Msg_Pub.count_and_get( p_encoded => Fnd_Api.G_FALSE,

1982: Fnd_Msg_Pub.add_exc_msg(p_pkg_name => 'AHL_DI_ASSO_DOC_GEN_PVT',
1983: p_procedure_name => 'COPY_ASSOCIATION',
1984: p_error_text => SUBSTR(SQLERRM,1,240));
1985: END IF;
1986: Fnd_Msg_Pub.count_and_get( p_encoded => Fnd_Api.G_FALSE,
1987: p_count => x_msg_count,
1988: p_data => X_msg_data);
1989:
1990: -- Debug info.

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

2006:
2007: PROCEDURE DELETE_ALL_ASSOCIATIONS
2008: (
2009: p_api_version IN NUMBER := 1.0 ,
2010: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
2011: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
2012: p_validate_only IN VARCHAR2 := FND_API.G_TRUE ,
2013: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2014: p_aso_object_type_code IN VARCHAR2 ,

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

2007: PROCEDURE DELETE_ALL_ASSOCIATIONS
2008: (
2009: p_api_version IN NUMBER := 1.0 ,
2010: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
2011: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
2012: p_validate_only IN VARCHAR2 := FND_API.G_TRUE ,
2013: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2014: p_aso_object_type_code IN VARCHAR2 ,
2015: p_aso_object_id IN NUMBER ,

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

2008: (
2009: p_api_version IN NUMBER := 1.0 ,
2010: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
2011: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
2012: p_validate_only IN VARCHAR2 := FND_API.G_TRUE ,
2013: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2014: p_aso_object_type_code IN VARCHAR2 ,
2015: p_aso_object_id IN NUMBER ,
2016: x_return_status OUT NOCOPY VARCHAR2 ,

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

2009: p_api_version IN NUMBER := 1.0 ,
2010: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
2011: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
2012: p_validate_only IN VARCHAR2 := FND_API.G_TRUE ,
2013: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2014: p_aso_object_type_code IN VARCHAR2 ,
2015: p_aso_object_id IN NUMBER ,
2016: x_return_status OUT NOCOPY VARCHAR2 ,
2017: x_msg_count OUT NOCOPY NUMBER ,

Line 2051: IF Fnd_Api.to_boolean(p_init_msg_list)

2047: END IF;
2048: END IF;
2049:
2050: -- Standard call to check for call compatibility.
2051: IF Fnd_Api.to_boolean(p_init_msg_list)
2052: THEN
2053: Fnd_Msg_Pub.initialize;
2054: END IF;
2055: -- Initialize API return status to success

Line 2058: IF NOT Fnd_Api.COMPATIBLE_API_CALL(l_api_version,

2054: END IF;
2055: -- Initialize API return status to success
2056: x_return_status := 'S';
2057: -- Initialize message list if p_init_msg_list is set to TRUE.
2058: IF NOT Fnd_Api.COMPATIBLE_API_CALL(l_api_version,
2059: p_api_version,
2060: l_api_name,G_PKG_NAME)
2061: THEN
2062: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;

Line 2062: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;

2058: IF NOT Fnd_Api.COMPATIBLE_API_CALL(l_api_version,
2059: p_api_version,
2060: l_api_name,G_PKG_NAME)
2061: THEN
2062: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
2063: END IF;
2064: IF G_DEBUG='Y' THEN
2065:
2066: AHL_DEBUG_PUB.debug( 'enter AHL_DI_ASSO_DOC_GEN_PVT.delete all Association:'||p_aso_object_id ,'+DOBJASS+');

Line 2126: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN

2122:
2123: AHL_DEBUG_PUB.debug( 'exit AHL_DI_ASSO_DOC_GEN_PVT.delete all Association:'||p_aso_object_id ,'+DOBJASS+');
2124:
2125: EXCEPTION
2126: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
2127: ROLLBACK TO copy_association;
2128: X_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
2129: Fnd_Msg_Pub.count_and_get( p_encoded => Fnd_Api.G_FALSE,
2130: p_count => x_msg_count,

Line 2128: X_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

2124:
2125: EXCEPTION
2126: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
2127: ROLLBACK TO copy_association;
2128: X_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
2129: Fnd_Msg_Pub.count_and_get( p_encoded => Fnd_Api.G_FALSE,
2130: p_count => x_msg_count,
2131: p_data => x_msg_data);
2132:

Line 2129: Fnd_Msg_Pub.count_and_get( p_encoded => Fnd_Api.G_FALSE,

2125: EXCEPTION
2126: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
2127: ROLLBACK TO copy_association;
2128: X_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
2129: Fnd_Msg_Pub.count_and_get( p_encoded => Fnd_Api.G_FALSE,
2130: p_count => x_msg_count,
2131: p_data => x_msg_data);
2132:
2133: --Debug Info

Line 2144: WHEN Fnd_Api.G_EXC_ERROR THEN

2140: AHL_DEBUG_PUB.disable_debug;
2141:
2142: END IF;
2143:
2144: WHEN Fnd_Api.G_EXC_ERROR THEN
2145: ROLLBACK TO copy_association;
2146: X_return_status := Fnd_Api.G_RET_STS_ERROR;
2147: Fnd_Msg_Pub.count_and_get( p_encoded => Fnd_Api.G_FALSE,
2148: p_count => x_msg_count,

Line 2146: X_return_status := Fnd_Api.G_RET_STS_ERROR;

2142: END IF;
2143:
2144: WHEN Fnd_Api.G_EXC_ERROR THEN
2145: ROLLBACK TO copy_association;
2146: X_return_status := Fnd_Api.G_RET_STS_ERROR;
2147: Fnd_Msg_Pub.count_and_get( p_encoded => Fnd_Api.G_FALSE,
2148: p_count => x_msg_count,
2149: p_data => X_msg_data);
2150: -- Debug info.

Line 2147: Fnd_Msg_Pub.count_and_get( p_encoded => Fnd_Api.G_FALSE,

2143:
2144: WHEN Fnd_Api.G_EXC_ERROR THEN
2145: ROLLBACK TO copy_association;
2146: X_return_status := Fnd_Api.G_RET_STS_ERROR;
2147: Fnd_Msg_Pub.count_and_get( p_encoded => Fnd_Api.G_FALSE,
2148: p_count => x_msg_count,
2149: p_data => X_msg_data);
2150: -- Debug info.
2151: IF G_DEBUG='Y' THEN

Line 2163: X_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

2159: END IF;
2160:
2161: WHEN OTHERS THEN
2162: ROLLBACK TO copy_association;
2163: X_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
2164: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
2165: THEN
2166: Fnd_Msg_Pub.add_exc_msg(p_pkg_name => 'AHL_DI_ASSO_DOC_GEN_PVT',
2167: p_procedure_name => 'DELETE_ALL_ASSOCIATION',

Line 2170: Fnd_Msg_Pub.count_and_get( p_encoded => Fnd_Api.G_FALSE,

2166: Fnd_Msg_Pub.add_exc_msg(p_pkg_name => 'AHL_DI_ASSO_DOC_GEN_PVT',
2167: p_procedure_name => 'DELETE_ALL_ASSOCIATION',
2168: p_error_text => SUBSTR(SQLERRM,1,240));
2169: END IF;
2170: Fnd_Msg_Pub.count_and_get( p_encoded => Fnd_Api.G_FALSE,
2171: p_count => x_msg_count,
2172: p_data => X_msg_data);
2173:
2174: -- Debug info.