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 AHL_DEBUG_PUB

Line 6: G_DEBUG VARCHAR2(1):=AHL_DEBUG_PUB.is_log_enabled;

2: /* $Header: AHLVDAGB.pls 120.1.12020000.2 2012/12/14 07:50:36 shnatu ship $ */
3: --
4: G_PKG_NAME VARCHAR2(30) := 'AHL_DI_ASSO_DOC_GEN_PVT';
5: G_PM_INSTALL VARCHAR2(30):=ahl_util_pkg.is_pm_installed;
6: G_DEBUG VARCHAR2(1):=AHL_DEBUG_PUB.is_log_enabled;
7:
8: /*---------------------------------------------------------*/
9: /* procedure name: validate_association(private procedure) */
10: /* description : Validation checks for before inserting */

Line 344: AHL_DEBUG_PUB.debug( 'Checking when object status is complete');

340: END IF;
341:
342: IF l_status = 'COMPLETE' THEN
343: IF G_DEBUG='Y' THEN
344: AHL_DEBUG_PUB.debug( 'Checking when object status is complete');
345: END IF;
346:
347: OPEN get_doc_assos_rec_b_info(p_doc_title_asso_id);
348: FETCH get_doc_assos_rec_b_info INTO l_document_id,

Line 364: AHL_DEBUG_PUB.debug( 'Checked Object Status Complete');

360: RAISE FND_API.G_EXC_ERROR;
361: END IF;
362: END IF;
363: IF G_DEBUG='Y' THEN
364: AHL_DEBUG_PUB.debug( 'Checked Object Status Complete');
365: END IF;
366: -- Document Association/Updation is only allowed in DRAFT,APPROVAL_REJECTED and COMPLETE status.
367: IF l_status <> 'DRAFT' AND l_status <> 'APPROVAL_REJECTED' AND l_status<>'COMPLETE'
368: THEN

Line 497: AHL_DEBUG_PUB.debug( 'Checking obsolete doc attach');

493: end if;
494: END IF;
495: -- FP for #8410484
496: IF G_DEBUG='Y' THEN
497: AHL_DEBUG_PUB.debug( 'Checking obsolete doc attach');
498: END IF;
499:
500: OPEN get_revision_status_code(P_DOC_REVISION_ID);
501: FETCH get_revision_status_code INTO l_revision_status_code;

Line 515: AHL_DEBUG_PUB.debug( 'Checking latest revision doc attach');

511: -- To validate that two revisions of same document are not added if the use latest = yes for that
512: -- document
513:
514: IF G_DEBUG='Y' THEN
515: AHL_DEBUG_PUB.debug( 'Checking latest revision doc attach');
516: END IF;
517: --Number of records(other than this record) having this document attached and use_latest =Yes
518: Select count(*) into l_counter
519: From AHL_DOC_TITLE_ASSOS_B

Line 545: AHL_DEBUG_PUB.debug( 'Checking latest revsion 2');

541: END IF;
542:
543: --To validate that if the Use Latest Flag='Y' then only the latest revision is allowed to attach.
544: IF G_DEBUG='Y' THEN
545: AHL_DEBUG_PUB.debug( 'Checking latest revsion 2');
546: END IF;
547: IF(P_USE_LATEST_REV_FLAG = 'Y')
548: THEN
549: -- If use latest = 'Y' then

Line 569: AHL_DEBUG_PUB.debug( 'latest revision checked');

565: RAISE FND_API.G_EXC_ERROR;
566: END IF;
567: END IF;
568: IF G_DEBUG='Y' THEN
569: AHL_DEBUG_PUB.debug( 'latest revision checked');
570: END IF;
571: -- End of FP #8410484
572: END IF;
573: EXCEPTION

Line 637: AHL_DEBUG_PUB.enable_debug;

633: -- Standard Start of API savepoint
634: SAVEPOINT delete_association;
635: -- Check if API is called in debug mode. If yes, enable debug.
636: IF G_DEBUG='Y' THEN
637: AHL_DEBUG_PUB.enable_debug;
638:
639: END IF;
640: -- Debug info.
641: IF G_DEBUG='Y' THEN

Line 643: AHL_DEBUG_PUB.debug( 'enter AHL_DI_ASSO_DOC_GEN_PVT.Delete Association','+DOBJASS+');

639: END IF;
640: -- Debug info.
641: IF G_DEBUG='Y' THEN
642: IF G_DEBUG='Y' THEN
643: AHL_DEBUG_PUB.debug( 'enter AHL_DI_ASSO_DOC_GEN_PVT.Delete Association','+DOBJASS+');
644:
645: END IF;
646: END IF;
647: -- Standard call to check for call compatibility.

Line 703: AHL_DEBUG_PUB.debug( 'End of private procedure Delete Association','+DOBJASS+');

699: COMMIT;
700: END IF;
701: -- Debug info
702: IF G_DEBUG='Y' THEN
703: AHL_DEBUG_PUB.debug( 'End of private procedure Delete Association','+DOBJASS+');
704:
705: END IF;
706: -- Check if API is called in debug mode. If yes, disable debug.
707: IF G_DEBUG='Y' THEN

Line 708: AHL_DEBUG_PUB.disable_debug;

704:
705: END IF;
706: -- Check if API is called in debug mode. If yes, disable debug.
707: IF G_DEBUG='Y' THEN
708: AHL_DEBUG_PUB.disable_debug;
709:
710: END IF;
711:
712: EXCEPTION

Line 721: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'ERROR' );

717: p_count => x_msg_count,
718: p_data => x_msg_data);
719: --Debug Info
720: IF G_DEBUG='Y' THEN
721: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'ERROR' );
722: AHL_DEBUG_PUB.debug( 'AHL_DI_ASSO_DOC_GEN_PVT.Delete Association','+DOBJASS+');
723:
724:
725: -- Check if API is called in debug mode. If yes, disable debug.

Line 722: AHL_DEBUG_PUB.debug( 'AHL_DI_ASSO_DOC_GEN_PVT.Delete Association','+DOBJASS+');

718: p_data => x_msg_data);
719: --Debug Info
720: IF G_DEBUG='Y' THEN
721: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'ERROR' );
722: AHL_DEBUG_PUB.debug( 'AHL_DI_ASSO_DOC_GEN_PVT.Delete Association','+DOBJASS+');
723:
724:
725: -- Check if API is called in debug mode. If yes, disable debug.
726:

Line 727: AHL_DEBUG_PUB.disable_debug;

723:
724:
725: -- Check if API is called in debug mode. If yes, disable debug.
726:
727: AHL_DEBUG_PUB.disable_debug;
728:
729: END IF;
730:
731: WHEN FND_API.G_EXC_ERROR THEN

Line 739: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );

735: p_count => x_msg_count,
736: p_data => X_msg_data);
737: -- Debug info.
738: IF G_DEBUG='Y' THEN
739: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
740: AHL_DEBUG_PUB.debug( 'AHL_DI_ASSO_DOC_GEN_PVT.Delete Association','+DOCJASS+');
741:
742:
743: -- Check if API is called in debug mode. If yes, disable debug.

Line 740: AHL_DEBUG_PUB.debug( 'AHL_DI_ASSO_DOC_GEN_PVT.Delete Association','+DOCJASS+');

736: p_data => X_msg_data);
737: -- Debug info.
738: IF G_DEBUG='Y' THEN
739: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
740: AHL_DEBUG_PUB.debug( 'AHL_DI_ASSO_DOC_GEN_PVT.Delete Association','+DOCJASS+');
741:
742:
743: -- Check if API is called in debug mode. If yes, disable debug.
744: AHL_DEBUG_PUB.disable_debug;

Line 744: AHL_DEBUG_PUB.disable_debug;

740: AHL_DEBUG_PUB.debug( 'AHL_DI_ASSO_DOC_GEN_PVT.Delete Association','+DOCJASS+');
741:
742:
743: -- Check if API is called in debug mode. If yes, disable debug.
744: AHL_DEBUG_PUB.disable_debug;
745:
746: END IF;
747:
748: WHEN OTHERS THEN

Line 762: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'SQL ERROR' );

758: p_count => x_msg_count,
759: p_data => X_msg_data);
760: -- Debug info.
761: IF G_DEBUG='Y' THEN
762: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'SQL ERROR' );
763: AHL_DEBUG_PUB.debug( 'AHL_DI_ASSO_DOC_GEN_PVT.Delete Association','+DOCJASS+');
764:
765:
766: -- Check if API is called in debug mode. If yes, disable debug.

Line 763: AHL_DEBUG_PUB.debug( 'AHL_DI_ASSO_DOC_GEN_PVT.Delete Association','+DOCJASS+');

759: p_data => X_msg_data);
760: -- Debug info.
761: IF G_DEBUG='Y' THEN
762: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'SQL ERROR' );
763: AHL_DEBUG_PUB.debug( 'AHL_DI_ASSO_DOC_GEN_PVT.Delete Association','+DOCJASS+');
764:
765:
766: -- Check if API is called in debug mode. If yes, disable debug.
767: AHL_DEBUG_PUB.disable_debug;

Line 767: AHL_DEBUG_PUB.disable_debug;

763: AHL_DEBUG_PUB.debug( 'AHL_DI_ASSO_DOC_GEN_PVT.Delete Association','+DOCJASS+');
764:
765:
766: -- Check if API is called in debug mode. If yes, disable debug.
767: AHL_DEBUG_PUB.disable_debug;
768:
769: END IF;
770:
771: END DELETE_ASSOCIATION;

Line 935: AHL_DEBUG_PUB.enable_debug;

931: -- Standard Start of API savepoint
932: SAVEPOINT process_association;
933: -- Check if API is called in debug mode. If yes, enable debug.
934: IF G_DEBUG='Y' THEN
935: AHL_DEBUG_PUB.enable_debug;
936:
937: END IF;
938: -- Debug info.
939: IF G_DEBUG='Y' THEN

Line 941: AHL_DEBUG_PUB.debug( 'enter AHL_DI_ASSO_DOC_GEN_PVT.Process Association','+DOBJASS+');

937: END IF;
938: -- Debug info.
939: IF G_DEBUG='Y' THEN
940: IF G_DEBUG='Y' THEN
941: AHL_DEBUG_PUB.debug( 'enter AHL_DI_ASSO_DOC_GEN_PVT.Process Association','+DOBJASS+');
942:
943: END IF;
944: END IF;
945: -- Standard call to check for call compatibility.

Line 973: AHL_DEBUG_PUB.debug( 'at end of validate the record pvt .... '||l_record,'+adhariamr+');

969: p_association_rec =>p_x_association_tbl(i),
970: x_record =>l_record
971: );
972: IF G_DEBUG='Y' THEN
973: AHL_DEBUG_PUB.debug( 'at end of validate the record pvt .... '||l_record,'+adhariamr+');
974: END IF;
975: IF G_DEBUG='Y' THEN
976: AHL_DEBUG_PUB.debug('DML FLAG ' || p_x_association_tbl(i).DML_OPERATION || ' Record ' || i || ' assos id ' || to_char(p_x_association_tbl(i).doc_title_asso_id));
977: END IF;

Line 976: AHL_DEBUG_PUB.debug('DML FLAG ' || p_x_association_tbl(i).DML_OPERATION || ' Record ' || i || ' assos id ' || to_char(p_x_association_tbl(i).doc_title_asso_id));

972: IF G_DEBUG='Y' THEN
973: AHL_DEBUG_PUB.debug( 'at end of validate the record pvt .... '||l_record,'+adhariamr+');
974: END IF;
975: IF G_DEBUG='Y' THEN
976: AHL_DEBUG_PUB.debug('DML FLAG ' || p_x_association_tbl(i).DML_OPERATION || ' Record ' || i || ' assos id ' || to_char(p_x_association_tbl(i).doc_title_asso_id));
977: END IF;
978: FOR j in p_x_association_tbl.FIRST..p_x_association_tbl.LAST
979: LOOP
980: IF((i <> j) AND (p_x_association_tbl(i).document_id=p_x_association_tbl(j).document_id) AND

Line 1005: AHL_DEBUG_PUB.debug( 'after validation check: '||l_record,'+adharia+');

1001: P_DML_OPERATION => p_x_association_tbl(i).DML_OPERATION,
1002: P_RECORD => L_RECORD
1003: );
1004: IF G_DEBUG='Y' THEN
1005: AHL_DEBUG_PUB.debug( 'after validation check: '||l_record,'+adharia+');
1006: END IF;
1007: l_msg_count := FND_MSG_PUB.count_msg;
1008:
1009: IF l_msg_count > 0 THEN

Line 1090: AHL_DEBUG_PUB.debug( 'in update prithwi71+');

1086:
1087:
1088: ELSIF p_x_association_tbl(i).DML_OPERATION = 'U'
1089: THEN
1090: AHL_DEBUG_PUB.debug( 'in update prithwi71+');
1091: OPEN dup_rec_check_upd(c_doc_title_asso_id => p_x_association_tbl(i).doc_title_asso_id,
1092: c_aso_object_type_code => p_x_association_tbl(i).aso_object_type_code,
1093: c_aso_object_id => p_x_association_tbl(i).aso_object_id,
1094: c_document_id => p_x_association_tbl(i).document_id,

Line 1194: AHL_DEBUG_PUB.debug( 'after dup check: '||l_record,'+adharia+');

1190:
1191: -- END LOOP;
1192:
1193: /* IF G_DEBUG='Y' THEN
1194: AHL_DEBUG_PUB.debug( 'after dup check: '||l_record,'+adharia+');
1195: END IF;
1196:
1197: --Standard call to message count
1198: l_msg_count := FND_MSG_PUB.count_msg;

Line 1228: AHL_DEBUG_PUB.debug( 'bafore update Association','+DOBJASS+');

1224: -----------------------------START UPDATE-----------------------------------------------------------------------
1225: ELSIF p_x_association_tbl(i).DML_OPERATION ='U'
1226: THEN
1227: IF G_DEBUG='Y' THEN
1228: AHL_DEBUG_PUB.debug( 'bafore update Association','+DOBJASS+');
1229: END IF;
1230:
1231: --Open the record from base table
1232: OPEN get_doc_assos_rec_b_info(p_x_association_tbl(i).doc_title_asso_id);

Line 1246: AHL_DEBUG_PUB.debug( 'bafore 3 update Association','+DOBJASS+');

1242: FND_MESSAGE.SET_NAME('AHL','AHL_COM_RECORD_CHANGED');
1243: FND_MSG_PUB.ADD;
1244: ELSE
1245: IF G_DEBUG='Y' THEN
1246: AHL_DEBUG_PUB.debug( 'bafore 3 update Association','+DOBJASS+');
1247: END IF;
1248:
1249: /*-------------------------------------------------------- */
1250: /* procedure name: AHL_DOC_TITLE_ASSOS_PKG.UPDATE_ROW */

Line 1354: AHL_DEBUG_PUB.debug( 'afte all update Association','+DOBJASS+');

1350: END IF;--CREATE/EDIT/DELETE
1351: END LOOP;
1352:
1353: IF G_DEBUG='Y' THEN
1354: AHL_DEBUG_PUB.debug( 'afte all update Association','+DOBJASS+');
1355: END IF;
1356:
1357: l_msg_count := FND_MSG_PUB.count_msg;
1358:

Line 1360: AHL_DEBUG_PUB.debug( 'l_msg_count- ' || l_msg_count);

1356:
1357: l_msg_count := FND_MSG_PUB.count_msg;
1358:
1359: IF G_DEBUG='Y' THEN
1360: AHL_DEBUG_PUB.debug( 'l_msg_count- ' || l_msg_count);
1361: END IF;
1362:
1363: IF l_msg_count > 0 THEN
1364: X_msg_count := l_msg_count;

Line 1373: AHL_DEBUG_PUB.debug( 'before commit');

1369: END IF;
1370: --Standard check for commit
1371: IF FND_API.TO_BOOLEAN(p_commit) THEN
1372: IF G_DEBUG='Y' THEN
1373: AHL_DEBUG_PUB.debug( 'before commit');
1374: END IF;
1375: COMMIT;
1376: END IF;
1377: -- Debug info

Line 1379: AHL_DEBUG_PUB.debug( 'End of private api Create Association','+DOBJASS+');

1375: COMMIT;
1376: END IF;
1377: -- Debug info
1378: IF G_DEBUG='Y' THEN
1379: AHL_DEBUG_PUB.debug( 'End of private api Create Association','+DOBJASS+');
1380:
1381: END IF;
1382: -- Check if API is called in debug mode. If yes, disable debug.
1383: IF G_DEBUG='Y' THEN

Line 1384: AHL_DEBUG_PUB.disable_debug;

1380:
1381: END IF;
1382: -- Check if API is called in debug mode. If yes, disable debug.
1383: IF G_DEBUG='Y' THEN
1384: AHL_DEBUG_PUB.disable_debug;
1385:
1386: END IF;
1387:
1388: EXCEPTION

Line 1398: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'ERROR' );

1394: p_data => x_msg_data);
1395:
1396: --Debug Info
1397: IF G_DEBUG='Y' THEN
1398: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'ERROR' );
1399: AHL_DEBUG_PUB.debug( 'AHL_DI_ASSO_DOC_GEN_PVT.Create Association','+DOBJASS+');
1400:
1401:
1402: -- Check if API is called in debug mode. If yes, disable debug.

Line 1399: AHL_DEBUG_PUB.debug( 'AHL_DI_ASSO_DOC_GEN_PVT.Create Association','+DOBJASS+');

1395:
1396: --Debug Info
1397: IF G_DEBUG='Y' THEN
1398: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'ERROR' );
1399: AHL_DEBUG_PUB.debug( 'AHL_DI_ASSO_DOC_GEN_PVT.Create Association','+DOBJASS+');
1400:
1401:
1402: -- Check if API is called in debug mode. If yes, disable debug.
1403: AHL_DEBUG_PUB.disable_debug;

Line 1403: AHL_DEBUG_PUB.disable_debug;

1399: AHL_DEBUG_PUB.debug( 'AHL_DI_ASSO_DOC_GEN_PVT.Create Association','+DOBJASS+');
1400:
1401:
1402: -- Check if API is called in debug mode. If yes, disable debug.
1403: AHL_DEBUG_PUB.disable_debug;
1404:
1405: END IF;
1406:
1407: WHEN FND_API.G_EXC_ERROR THEN

Line 1416: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );

1412: p_data => X_msg_data);
1413:
1414: -- Debug info.
1415: IF G_DEBUG='Y' THEN
1416: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
1417: AHL_DEBUG_PUB.debug( 'AHL_DI_ASSO_DOC_GEN_PVT.Create Association','+DOCJASS+');
1418:
1419:
1420: -- Check if API is called in debug mode. If yes, disable debug.

Line 1417: AHL_DEBUG_PUB.debug( 'AHL_DI_ASSO_DOC_GEN_PVT.Create Association','+DOCJASS+');

1413:
1414: -- Debug info.
1415: IF G_DEBUG='Y' THEN
1416: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
1417: AHL_DEBUG_PUB.debug( 'AHL_DI_ASSO_DOC_GEN_PVT.Create Association','+DOCJASS+');
1418:
1419:
1420: -- Check if API is called in debug mode. If yes, disable debug.
1421: AHL_DEBUG_PUB.disable_debug;

Line 1421: AHL_DEBUG_PUB.disable_debug;

1417: AHL_DEBUG_PUB.debug( 'AHL_DI_ASSO_DOC_GEN_PVT.Create Association','+DOCJASS+');
1418:
1419:
1420: -- Check if API is called in debug mode. If yes, disable debug.
1421: AHL_DEBUG_PUB.disable_debug;
1422:
1423: END IF;
1424:
1425: WHEN OTHERS THEN

Line 1439: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'SQL ERROR' );

1435: p_count => x_msg_count,
1436: p_data => X_msg_data);
1437: -- Debug info.
1438: IF G_DEBUG='Y' THEN
1439: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'SQL ERROR' );
1440: AHL_DEBUG_PUB.debug( 'AHL_DI_ASSO_DOC_GEN_PVT.Create Association','+DOCJASS+');
1441:
1442:
1443: -- Check if API is called in debug mode. If yes, disable debug.

Line 1440: AHL_DEBUG_PUB.debug( 'AHL_DI_ASSO_DOC_GEN_PVT.Create Association','+DOCJASS+');

1436: p_data => X_msg_data);
1437: -- Debug info.
1438: IF G_DEBUG='Y' THEN
1439: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'SQL ERROR' );
1440: AHL_DEBUG_PUB.debug( 'AHL_DI_ASSO_DOC_GEN_PVT.Create Association','+DOCJASS+');
1441:
1442:
1443: -- Check if API is called in debug mode. If yes, disable debug.
1444: AHL_DEBUG_PUB.disable_debug;

Line 1444: AHL_DEBUG_PUB.disable_debug;

1440: AHL_DEBUG_PUB.debug( 'AHL_DI_ASSO_DOC_GEN_PVT.Create Association','+DOCJASS+');
1441:
1442:
1443: -- Check if API is called in debug mode. If yes, disable debug.
1444: AHL_DEBUG_PUB.disable_debug;
1445:
1446: END IF;
1447:
1448: END PROCESS_ASSOCIATION;

Line 1527: AHL_DEBUG_PUB.enable_debug;

1523: -- Standard Start of API savepoint
1524: SAVEPOINT insert_assoc_rec;
1525: -- Check if API is called in debug mode. If yes, enable debug.
1526: IF G_DEBUG='Y' THEN
1527: AHL_DEBUG_PUB.enable_debug;
1528:
1529: END IF;
1530: -- Debug info.
1531: IF G_DEBUG='Y' THEN

Line 1533: AHL_DEBUG_PUB.debug( 'enter AHL_DI_ASSO_DOC_GEN_PVT.Insert Assoc Rec','+DOBJASS+');

1529: END IF;
1530: -- Debug info.
1531: IF G_DEBUG='Y' THEN
1532: IF G_DEBUG='Y' THEN
1533: AHL_DEBUG_PUB.debug( 'enter AHL_DI_ASSO_DOC_GEN_PVT.Insert Assoc Rec','+DOBJASS+');
1534:
1535: END IF;
1536: END IF;
1537: -- Standard call to check for call compatibility.

Line 1874: AHL_DEBUG_PUB.debug( 'END OF PRIVATE Insret Asso Rec','+DOBJASS+');

1870: COMMIT;
1871: END IF;
1872: -- Debug info
1873: IF G_DEBUG='Y' THEN
1874: AHL_DEBUG_PUB.debug( 'END OF PRIVATE Insret Asso Rec','+DOBJASS+');
1875:
1876: END IF;
1877: -- Check if API is called in debug mode. If yes, disable debug.
1878: IF G_DEBUG='Y' THEN

Line 1879: AHL_DEBUG_PUB.disable_debug;

1875:
1876: END IF;
1877: -- Check if API is called in debug mode. If yes, disable debug.
1878: IF G_DEBUG='Y' THEN
1879: AHL_DEBUG_PUB.disable_debug;
1880:
1881: END IF;
1882:
1883: EXCEPTION

Line 1893: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'ERROR' );

1889: p_data => x_msg_data);
1890:
1891: --Debug Info
1892: IF G_DEBUG='Y' THEN
1893: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'ERROR' );
1894: AHL_DEBUG_PUB.debug( 'AHL_DI_ASSO_DOC_GEN_PVT.INSERT Assoc Rec','+DOBJASS+');
1895:
1896:
1897: -- Check if API is called in debug mode. If yes, disable debug.

Line 1894: AHL_DEBUG_PUB.debug( 'AHL_DI_ASSO_DOC_GEN_PVT.INSERT Assoc Rec','+DOBJASS+');

1890:
1891: --Debug Info
1892: IF G_DEBUG='Y' THEN
1893: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'ERROR' );
1894: AHL_DEBUG_PUB.debug( 'AHL_DI_ASSO_DOC_GEN_PVT.INSERT Assoc Rec','+DOBJASS+');
1895:
1896:
1897: -- Check if API is called in debug mode. If yes, disable debug.
1898: AHL_DEBUG_PUB.disable_debug;

Line 1898: AHL_DEBUG_PUB.disable_debug;

1894: AHL_DEBUG_PUB.debug( 'AHL_DI_ASSO_DOC_GEN_PVT.INSERT Assoc Rec','+DOBJASS+');
1895:
1896:
1897: -- Check if API is called in debug mode. If yes, disable debug.
1898: AHL_DEBUG_PUB.disable_debug;
1899:
1900: END IF;
1901:
1902: WHEN Fnd_Api.G_EXC_ERROR THEN

Line 1911: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );

1907: p_data => X_msg_data);
1908:
1909: -- Debug info.
1910: IF G_DEBUG='Y' THEN
1911: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
1912: AHL_DEBUG_PUB.debug( 'AHL_DI_ASSO_DOC_GEN_PVT. INSERT Assoc Rec','+DOCJASS+');
1913:
1914:
1915: -- Check if API is called in debug mode. If yes, disable debug.

Line 1912: AHL_DEBUG_PUB.debug( 'AHL_DI_ASSO_DOC_GEN_PVT. INSERT Assoc Rec','+DOCJASS+');

1908:
1909: -- Debug info.
1910: IF G_DEBUG='Y' THEN
1911: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
1912: AHL_DEBUG_PUB.debug( 'AHL_DI_ASSO_DOC_GEN_PVT. INSERT Assoc Rec','+DOCJASS+');
1913:
1914:
1915: -- Check if API is called in debug mode. If yes, disable debug.
1916: AHL_DEBUG_PUB.disable_debug;

Line 1916: AHL_DEBUG_PUB.disable_debug;

1912: AHL_DEBUG_PUB.debug( 'AHL_DI_ASSO_DOC_GEN_PVT. INSERT Assoc Rec','+DOCJASS+');
1913:
1914:
1915: -- Check if API is called in debug mode. If yes, disable debug.
1916: AHL_DEBUG_PUB.disable_debug;
1917:
1918: END IF;
1919:
1920: WHEN OTHERS THEN

Line 1934: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'SQL ERROR' );

1930: p_count => x_msg_count,
1931: p_data => X_msg_data);
1932: -- Debug info.
1933: IF G_DEBUG='Y' THEN
1934: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'SQL ERROR' );
1935: AHL_DEBUG_PUB.debug( 'AHL_DI_ASSO_DOC_GEN_PVT.INSERT Assoc Rec','+DOCJASS+');
1936:
1937:
1938: -- Check if API is called in debug mode. If yes, disable debug.

Line 1935: AHL_DEBUG_PUB.debug( 'AHL_DI_ASSO_DOC_GEN_PVT.INSERT Assoc Rec','+DOCJASS+');

1931: p_data => X_msg_data);
1932: -- Debug info.
1933: IF G_DEBUG='Y' THEN
1934: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'SQL ERROR' );
1935: AHL_DEBUG_PUB.debug( 'AHL_DI_ASSO_DOC_GEN_PVT.INSERT Assoc Rec','+DOCJASS+');
1936:
1937:
1938: -- Check if API is called in debug mode. If yes, disable debug.
1939: AHL_DEBUG_PUB.disable_debug;

Line 1939: AHL_DEBUG_PUB.disable_debug;

1935: AHL_DEBUG_PUB.debug( 'AHL_DI_ASSO_DOC_GEN_PVT.INSERT Assoc Rec','+DOCJASS+');
1936:
1937:
1938: -- Check if API is called in debug mode. If yes, disable debug.
1939: AHL_DEBUG_PUB.disable_debug;
1940:
1941: END IF;
1942:
1943: END INSERT_ASSOC_REC;

Line 1987: AHL_DEBUG_PUB.enable_debug;

1983: -- Standard Start of API savepoint
1984: SAVEPOINT copy_association;
1985: -- Check if API is called in debug mode. If yes, enable debug.
1986: IF G_DEBUG='Y' THEN
1987: AHL_DEBUG_PUB.enable_debug;
1988:
1989: END IF;
1990: -- Debug info.
1991: IF G_DEBUG='Y' THEN

Line 1993: AHL_DEBUG_PUB.debug( 'enter AHL_DI_ASSO_DOC_GEN_PVT.Copy Association','+DOBJASS+');

1989: END IF;
1990: -- Debug info.
1991: IF G_DEBUG='Y' THEN
1992: IF G_DEBUG='Y' THEN
1993: AHL_DEBUG_PUB.debug( 'enter AHL_DI_ASSO_DOC_GEN_PVT.Copy Association','+DOBJASS+');
1994:
1995: END IF;
1996: END IF;
1997: -- Standard call to check for call compatibility.

Line 2013: AHL_DEBUG_PUB.debug( 'enter AHL_DI_ASSO_DOC_GEN_PVT.Copy Association:'||p_from_object_id ,'+DOBJASS+');

2009: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
2010: END IF;
2011: IF G_DEBUG='Y' THEN
2012: IF G_DEBUG='Y' THEN
2013: AHL_DEBUG_PUB.debug( 'enter AHL_DI_ASSO_DOC_GEN_PVT.Copy Association:'||p_from_object_id ,'+DOBJASS+');
2014:
2015: END IF;
2016: END IF;
2017: --Start of API Body

Line 2089: AHL_DEBUG_PUB.debug( 'END OF PRIVATE copy Association','+DOBJASS+');

2085: COMMIT;
2086: END IF;
2087: -- Debug info
2088: IF G_DEBUG='Y' THEN
2089: AHL_DEBUG_PUB.debug( 'END OF PRIVATE copy Association','+DOBJASS+');
2090:
2091: END IF;
2092: -- Check if API is called in debug mode. If yes, disable debug.
2093: IF G_DEBUG='Y' THEN

Line 2094: AHL_DEBUG_PUB.disable_debug;

2090:
2091: END IF;
2092: -- Check if API is called in debug mode. If yes, disable debug.
2093: IF G_DEBUG='Y' THEN
2094: AHL_DEBUG_PUB.disable_debug;
2095:
2096: END IF;
2097:
2098: EXCEPTION

Line 2108: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'ERROR' );

2104: p_data => x_msg_data);
2105:
2106: --Debug Info
2107: IF G_DEBUG='Y' THEN
2108: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'ERROR' );
2109: AHL_DEBUG_PUB.debug( 'AHL_DI_ASSO_DOC_GEN_PVT.Copy Association','+DOBJASS+');
2110:
2111:
2112: -- Check if API is called in debug mode. If yes, disable debug.

Line 2109: AHL_DEBUG_PUB.debug( 'AHL_DI_ASSO_DOC_GEN_PVT.Copy Association','+DOBJASS+');

2105:
2106: --Debug Info
2107: IF G_DEBUG='Y' THEN
2108: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'ERROR' );
2109: AHL_DEBUG_PUB.debug( 'AHL_DI_ASSO_DOC_GEN_PVT.Copy Association','+DOBJASS+');
2110:
2111:
2112: -- Check if API is called in debug mode. If yes, disable debug.
2113: AHL_DEBUG_PUB.disable_debug;

Line 2113: AHL_DEBUG_PUB.disable_debug;

2109: AHL_DEBUG_PUB.debug( 'AHL_DI_ASSO_DOC_GEN_PVT.Copy Association','+DOBJASS+');
2110:
2111:
2112: -- Check if API is called in debug mode. If yes, disable debug.
2113: AHL_DEBUG_PUB.disable_debug;
2114:
2115: END IF;
2116:
2117: WHEN Fnd_Api.G_EXC_ERROR THEN

Line 2125: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );

2121: p_count => x_msg_count,
2122: p_data => X_msg_data);
2123: -- Debug info.
2124: IF G_DEBUG='Y' THEN
2125: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
2126: AHL_DEBUG_PUB.debug( 'AHL_DI_ASSO_DOC_GEN_PVT.Copy Association','+DOCJASS+');
2127:
2128:
2129: -- Check if API is called in debug mode. If yes, disable debug.

Line 2126: AHL_DEBUG_PUB.debug( 'AHL_DI_ASSO_DOC_GEN_PVT.Copy Association','+DOCJASS+');

2122: p_data => X_msg_data);
2123: -- Debug info.
2124: IF G_DEBUG='Y' THEN
2125: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
2126: AHL_DEBUG_PUB.debug( 'AHL_DI_ASSO_DOC_GEN_PVT.Copy Association','+DOCJASS+');
2127:
2128:
2129: -- Check if API is called in debug mode. If yes, disable debug.
2130: AHL_DEBUG_PUB.disable_debug;

Line 2130: AHL_DEBUG_PUB.disable_debug;

2126: AHL_DEBUG_PUB.debug( 'AHL_DI_ASSO_DOC_GEN_PVT.Copy Association','+DOCJASS+');
2127:
2128:
2129: -- Check if API is called in debug mode. If yes, disable debug.
2130: AHL_DEBUG_PUB.disable_debug;
2131:
2132: END IF;
2133:
2134: WHEN OTHERS THEN

Line 2149: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'SQL ERROR' );

2145: p_data => X_msg_data);
2146:
2147: -- Debug info.
2148: IF G_DEBUG='Y' THEN
2149: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'SQL ERROR' );
2150: AHL_DEBUG_PUB.debug( 'AHL_DI_ASSO_DOC_GEN_PVT.Copy Association','+DOCJASS+');
2151:
2152:
2153: -- Check if API is called in debug mode. If yes, disable debug.

Line 2150: AHL_DEBUG_PUB.debug( 'AHL_DI_ASSO_DOC_GEN_PVT.Copy Association','+DOCJASS+');

2146:
2147: -- Debug info.
2148: IF G_DEBUG='Y' THEN
2149: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'SQL ERROR' );
2150: AHL_DEBUG_PUB.debug( 'AHL_DI_ASSO_DOC_GEN_PVT.Copy Association','+DOCJASS+');
2151:
2152:
2153: -- Check if API is called in debug mode. If yes, disable debug.
2154:

Line 2155: AHL_DEBUG_PUB.disable_debug;

2151:
2152:
2153: -- Check if API is called in debug mode. If yes, disable debug.
2154:
2155: AHL_DEBUG_PUB.disable_debug;
2156:
2157: END IF;
2158:
2159: END COPY_ASSOCIATION;

Line 2196: AHL_DEBUG_PUB.enable_debug;

2192: -- Standard Start of API savepoint
2193: SAVEPOINT copy_association;
2194: -- Check if API is called in debug mode. If yes, enable debug.
2195: IF G_DEBUG='Y' THEN
2196: AHL_DEBUG_PUB.enable_debug;
2197:
2198: END IF;
2199: -- Debug info.
2200: IF G_DEBUG='Y' THEN

Line 2202: AHL_DEBUG_PUB.debug( 'enter AHL_DI_ASSO_DOC_GEN_PVT.delete all Association','+DOBJASS+');

2198: END IF;
2199: -- Debug info.
2200: IF G_DEBUG='Y' THEN
2201: IF G_DEBUG='Y' THEN
2202: AHL_DEBUG_PUB.debug( 'enter AHL_DI_ASSO_DOC_GEN_PVT.delete all Association','+DOBJASS+');
2203:
2204: END IF;
2205: END IF;
2206:

Line 2223: AHL_DEBUG_PUB.debug( 'enter AHL_DI_ASSO_DOC_GEN_PVT.delete all Association:'||p_aso_object_id ,'+DOBJASS+');

2219: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
2220: END IF;
2221: IF G_DEBUG='Y' THEN
2222:
2223: AHL_DEBUG_PUB.debug( 'enter AHL_DI_ASSO_DOC_GEN_PVT.delete all Association:'||p_aso_object_id ,'+DOBJASS+');
2224:
2225: END IF;
2226: --Start of API Body
2227:

Line 2243: AHL_DEBUG_PUB.debug( 'AHL_DI_ASSO_DOC_GEN_PVT.delete all Association: the revision id of revision deleted is '|| l_doc_asso_rec.doc_revision_id);

2239:
2240: l_count_assoc := l_count_assoc + 1;
2241: FND_MESSAGE.SET_NAME('AHL','AHL_DI_DOC_ASSOS_NOT_FOUND');
2242: FND_MSG_PUB.ADD;
2243: AHL_DEBUG_PUB.debug( 'AHL_DI_ASSO_DOC_GEN_PVT.delete all Association: the revision id of revision deleted is '|| l_doc_asso_rec.doc_revision_id);
2244: END IF;
2245:
2246: END LOOP;
2247:

Line 2254: AHL_DEBUG_PUB.debug( 'no revisions found that are attached to the object id'|| p_aso_object_id );

2250: IF l_count_assoc = 0
2251: THEN
2252: FND_MESSAGE.SET_NAME('AHL','AHL_DI_DOC_ASSOS_NOT_FOUND');
2253: FND_MSG_PUB.ADD;
2254: AHL_DEBUG_PUB.debug( 'no revisions found that are attached to the object id'|| p_aso_object_id );
2255: ELSE
2256:
2257: FND_MESSAGE.SET_NAME('AHL','AHL_DI_DOC_ASSOS_DELETED');
2258: FND_MSG_PUB.ADD;

Line 2259: AHL_DEBUG_PUB.debug( 'number of revisions found that are attached to the object id'|| p_aso_object_id ||' are '|| l_count_assoc);

2255: ELSE
2256:
2257: FND_MESSAGE.SET_NAME('AHL','AHL_DI_DOC_ASSOS_DELETED');
2258: FND_MSG_PUB.ADD;
2259: AHL_DEBUG_PUB.debug( 'number of revisions found that are attached to the object id'|| p_aso_object_id ||' are '|| l_count_assoc);
2260:
2261: END IF;
2262:
2263: END IF;

Line 2280: AHL_DEBUG_PUB.debug( 'exit AHL_DI_ASSO_DOC_GEN_PVT.delete all Association:'||p_aso_object_id ,'+DOBJASS+');

2276: FROM AHL_DOC_TITLE_ASSOS_B
2277: WHERE aso_object_type_code = p_aso_object_type_code and
2278: aso_object_id = p_aso_object_id;
2279:
2280: AHL_DEBUG_PUB.debug( 'exit AHL_DI_ASSO_DOC_GEN_PVT.delete all Association:'||p_aso_object_id ,'+DOBJASS+');
2281:
2282: EXCEPTION
2283: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
2284: ROLLBACK TO copy_association;

Line 2292: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'ERROR' );

2288: p_data => x_msg_data);
2289:
2290: --Debug Info
2291: IF G_DEBUG='Y' THEN
2292: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'ERROR' );
2293: AHL_DEBUG_PUB.debug( 'AHL_DI_ASSO_DOC_GEN_PVT.delete all Association','+DOBJASS+');
2294:
2295:
2296: -- Check if API is called in debug mode. If yes, disable debug.

Line 2293: AHL_DEBUG_PUB.debug( 'AHL_DI_ASSO_DOC_GEN_PVT.delete all Association','+DOBJASS+');

2289:
2290: --Debug Info
2291: IF G_DEBUG='Y' THEN
2292: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'ERROR' );
2293: AHL_DEBUG_PUB.debug( 'AHL_DI_ASSO_DOC_GEN_PVT.delete all Association','+DOBJASS+');
2294:
2295:
2296: -- Check if API is called in debug mode. If yes, disable debug.
2297: AHL_DEBUG_PUB.disable_debug;

Line 2297: AHL_DEBUG_PUB.disable_debug;

2293: AHL_DEBUG_PUB.debug( 'AHL_DI_ASSO_DOC_GEN_PVT.delete all Association','+DOBJASS+');
2294:
2295:
2296: -- Check if API is called in debug mode. If yes, disable debug.
2297: AHL_DEBUG_PUB.disable_debug;
2298:
2299: END IF;
2300:
2301: WHEN Fnd_Api.G_EXC_ERROR THEN

Line 2309: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );

2305: p_count => x_msg_count,
2306: p_data => X_msg_data);
2307: -- Debug info.
2308: IF G_DEBUG='Y' THEN
2309: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
2310: AHL_DEBUG_PUB.debug( 'AHL_DI_ASSO_DOC_GEN_PVT.delete all Association','+DOCJASS+');
2311:
2312:
2313: -- Check if API is called in debug mode. If yes, disable debug.

Line 2310: AHL_DEBUG_PUB.debug( 'AHL_DI_ASSO_DOC_GEN_PVT.delete all Association','+DOCJASS+');

2306: p_data => X_msg_data);
2307: -- Debug info.
2308: IF G_DEBUG='Y' THEN
2309: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
2310: AHL_DEBUG_PUB.debug( 'AHL_DI_ASSO_DOC_GEN_PVT.delete all Association','+DOCJASS+');
2311:
2312:
2313: -- Check if API is called in debug mode. If yes, disable debug.
2314: AHL_DEBUG_PUB.disable_debug;

Line 2314: AHL_DEBUG_PUB.disable_debug;

2310: AHL_DEBUG_PUB.debug( 'AHL_DI_ASSO_DOC_GEN_PVT.delete all Association','+DOCJASS+');
2311:
2312:
2313: -- Check if API is called in debug mode. If yes, disable debug.
2314: AHL_DEBUG_PUB.disable_debug;
2315:
2316: END IF;
2317:
2318: WHEN OTHERS THEN

Line 2333: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'SQL ERROR' );

2329: p_data => X_msg_data);
2330:
2331: -- Debug info.
2332: IF G_DEBUG='Y' THEN
2333: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'SQL ERROR' );
2334: AHL_DEBUG_PUB.debug( 'AHL_DI_ASSO_DOC_GEN_PVT.delete all Association','+DOCJASS+');
2335:
2336:
2337: -- Check if API is called in debug mode. If yes, disable debug.

Line 2334: AHL_DEBUG_PUB.debug( 'AHL_DI_ASSO_DOC_GEN_PVT.delete all Association','+DOCJASS+');

2330:
2331: -- Debug info.
2332: IF G_DEBUG='Y' THEN
2333: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'SQL ERROR' );
2334: AHL_DEBUG_PUB.debug( 'AHL_DI_ASSO_DOC_GEN_PVT.delete all Association','+DOCJASS+');
2335:
2336:
2337: -- Check if API is called in debug mode. If yes, disable debug.
2338:

Line 2339: AHL_DEBUG_PUB.disable_debug;

2335:
2336:
2337: -- Check if API is called in debug mode. If yes, disable debug.
2338:
2339: AHL_DEBUG_PUB.disable_debug;
2340:
2341: END IF;
2342:
2343: