DBA Data[Home] [Help]

APPS.AHL_DI_ASSO_DOC_ASO_PVT dependencies on AHL_DEBUG_PUB

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

8: /* new record as well before modification */
9: /* takes place */
10: /*---------------------------------------------------------*/
11:
12: G_DEBUG VARCHAR2(1):=AHL_DEBUG_PUB.is_log_enabled;
13: PROCEDURE VALIDATE_ASSOCIATION
14: (
15: P_DOC_TITLE_ASSO_ID IN NUMBER ,
16: P_DOCUMENT_ID IN NUMBER ,

Line 315: AHL_DEBUG_PUB.enable_debug;

311: -- Standard Start of API savepoint
312: SAVEPOINT delete_association;
313: -- Check if API is called in debug mode. If yes, enable debug.
314: IF G_DEBUG='Y' THEN
315: AHL_DEBUG_PUB.enable_debug;
316:
317: END IF;
318: -- Debug info.
319: IF G_DEBUG='Y' THEN

Line 321: AHL_DEBUG_PUB.debug( 'enter ahl_di_asso_doc_aso_pvt.Delete Association','+DOBJASS+');

317: END IF;
318: -- Debug info.
319: IF G_DEBUG='Y' THEN
320: IF G_DEBUG='Y' THEN
321: AHL_DEBUG_PUB.debug( 'enter ahl_di_asso_doc_aso_pvt.Delete Association','+DOBJASS+');
322:
323: END IF;
324: END IF;
325: -- Standard call to check for call compatibility.

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

377: COMMIT;
378: END IF;
379: -- Debug info
380: IF G_DEBUG='Y' THEN
381: AHL_DEBUG_PUB.debug( 'End of private procedure Delete Association','+DOBJASS+');
382:
383: END IF;
384: -- Check if API is called in debug mode. If yes, disable debug.
385: IF G_DEBUG='Y' THEN

Line 386: AHL_DEBUG_PUB.disable_debug;

382:
383: END IF;
384: -- Check if API is called in debug mode. If yes, disable debug.
385: IF G_DEBUG='Y' THEN
386: AHL_DEBUG_PUB.disable_debug;
387:
388: END IF;
389:
390: EXCEPTION

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

395: p_count => x_msg_count,
396: p_data => x_msg_data);
397: --Debug Info
398: IF G_DEBUG='Y' THEN
399: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'ERROR' );
400: AHL_DEBUG_PUB.debug( 'ahl_di_asso_doc_aso_pvt.Delete Association','+DOBJASS+');
401:
402:
403: -- Check if API is called in debug mode. If yes, disable debug.

Line 400: AHL_DEBUG_PUB.debug( 'ahl_di_asso_doc_aso_pvt.Delete Association','+DOBJASS+');

396: p_data => x_msg_data);
397: --Debug Info
398: IF G_DEBUG='Y' THEN
399: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'ERROR' );
400: AHL_DEBUG_PUB.debug( 'ahl_di_asso_doc_aso_pvt.Delete Association','+DOBJASS+');
401:
402:
403: -- Check if API is called in debug mode. If yes, disable debug.
404:

Line 405: AHL_DEBUG_PUB.disable_debug;

401:
402:
403: -- Check if API is called in debug mode. If yes, disable debug.
404:
405: AHL_DEBUG_PUB.disable_debug;
406:
407: END IF;
408:
409: WHEN FND_API.G_EXC_ERROR THEN

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

413: p_count => x_msg_count,
414: p_data => X_msg_data);
415: -- Debug info.
416: IF G_DEBUG='Y' THEN
417: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
418: AHL_DEBUG_PUB.debug( 'ahl_di_asso_doc_aso_pvt.Delete Association','+DOCJASS+');
419:
420:
421: -- Check if API is called in debug mode. If yes, disable debug.

Line 418: AHL_DEBUG_PUB.debug( 'ahl_di_asso_doc_aso_pvt.Delete Association','+DOCJASS+');

414: p_data => X_msg_data);
415: -- Debug info.
416: IF G_DEBUG='Y' THEN
417: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
418: AHL_DEBUG_PUB.debug( 'ahl_di_asso_doc_aso_pvt.Delete Association','+DOCJASS+');
419:
420:
421: -- Check if API is called in debug mode. If yes, disable debug.
422: AHL_DEBUG_PUB.disable_debug;

Line 422: AHL_DEBUG_PUB.disable_debug;

418: AHL_DEBUG_PUB.debug( 'ahl_di_asso_doc_aso_pvt.Delete Association','+DOCJASS+');
419:
420:
421: -- Check if API is called in debug mode. If yes, disable debug.
422: AHL_DEBUG_PUB.disable_debug;
423:
424: END IF;
425:
426: WHEN OTHERS THEN

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

436: p_count => x_msg_count,
437: p_data => X_msg_data);
438: -- Debug info.
439: IF G_DEBUG='Y' THEN
440: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'SQL ERROR' );
441: AHL_DEBUG_PUB.debug( 'ahl_di_asso_doc_aso_pvt.Delete Association','+DOCJASS+');
442:
443:
444: -- Check if API is called in debug mode. If yes, disable debug.

Line 441: AHL_DEBUG_PUB.debug( 'ahl_di_asso_doc_aso_pvt.Delete Association','+DOCJASS+');

437: p_data => X_msg_data);
438: -- Debug info.
439: IF G_DEBUG='Y' THEN
440: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'SQL ERROR' );
441: AHL_DEBUG_PUB.debug( 'ahl_di_asso_doc_aso_pvt.Delete Association','+DOCJASS+');
442:
443:
444: -- Check if API is called in debug mode. If yes, disable debug.
445: AHL_DEBUG_PUB.disable_debug;

Line 445: AHL_DEBUG_PUB.disable_debug;

441: AHL_DEBUG_PUB.debug( 'ahl_di_asso_doc_aso_pvt.Delete Association','+DOCJASS+');
442:
443:
444: -- Check if API is called in debug mode. If yes, disable debug.
445: AHL_DEBUG_PUB.disable_debug;
446:
447: END IF;
448:
449: END DELETE_ASSOCIATION;

Line 528: AHL_DEBUG_PUB.enable_debug;

524: -- Standard Start of API savepoint
525: SAVEPOINT create_association;
526: -- Check if API is called in debug mode. If yes, enable debug.
527: IF G_DEBUG='Y' THEN
528: AHL_DEBUG_PUB.enable_debug;
529:
530: END IF;
531: -- Debug info.
532: IF G_DEBUG='Y' THEN

Line 534: AHL_DEBUG_PUB.debug( 'enter ahl_di_asso_doc_aso_pvt.Create Association','+DOBJASS+');

530: END IF;
531: -- Debug info.
532: IF G_DEBUG='Y' THEN
533: IF G_DEBUG='Y' THEN
534: AHL_DEBUG_PUB.debug( 'enter ahl_di_asso_doc_aso_pvt.Create Association','+DOBJASS+');
535:
536: END IF;
537: END IF;
538: -- Standard call to check for call compatibility.

Line 792: AHL_DEBUG_PUB.ENABLE_DEBUG;

788: END IF;
789: --
790: -- This check is required for when same record is passed twice
791: IF G_DEBUG='Y' THEN
792: AHL_DEBUG_PUB.ENABLE_DEBUG;
793:
794: END IF;
795:
796: IF p_x_association_tbl(i).aso_object_type_code NOT IN ( 'PC', 'MC','ROUTE','OPERATION' )

Line 836: AHL_DEBUG_PUB.debug('DCAB -- DUP CHECK FOUND ');

832:
833:
834:
835: IF G_DEBUG='Y' THEN
836: AHL_DEBUG_PUB.debug('DCAB -- DUP CHECK FOUND ');
837:
838: END IF;
839: FND_MESSAGE.SET_NAME('AHL','AHL_DI_DOC_ASSOS_DUP_RECORD');
840: FND_MESSAGE.SET_TOKEN('DUPRECORD',l_document_no);

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

911: COMMIT;
912: END IF;
913: -- Debug info
914: IF G_DEBUG='Y' THEN
915: AHL_DEBUG_PUB.debug( 'End of private api Create Association','+DOBJASS+');
916:
917: END IF;
918: -- Check if API is called in debug mode. If yes, disable debug.
919: IF G_DEBUG='Y' THEN

Line 920: AHL_DEBUG_PUB.disable_debug;

916:
917: END IF;
918: -- Check if API is called in debug mode. If yes, disable debug.
919: IF G_DEBUG='Y' THEN
920: AHL_DEBUG_PUB.disable_debug;
921:
922: END IF;
923:
924: EXCEPTION

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

930: p_data => x_msg_data);
931:
932: --Debug Info
933: IF G_DEBUG='Y' THEN
934: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'ERROR' );
935: AHL_DEBUG_PUB.debug( 'ahl_di_asso_doc_aso_pvt.Create Association','+DOBJASS+');
936:
937:
938: -- Check if API is called in debug mode. If yes, disable debug.

Line 935: AHL_DEBUG_PUB.debug( 'ahl_di_asso_doc_aso_pvt.Create Association','+DOBJASS+');

931:
932: --Debug Info
933: IF G_DEBUG='Y' THEN
934: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'ERROR' );
935: AHL_DEBUG_PUB.debug( 'ahl_di_asso_doc_aso_pvt.Create Association','+DOBJASS+');
936:
937:
938: -- Check if API is called in debug mode. If yes, disable debug.
939: AHL_DEBUG_PUB.disable_debug;

Line 939: AHL_DEBUG_PUB.disable_debug;

935: AHL_DEBUG_PUB.debug( 'ahl_di_asso_doc_aso_pvt.Create Association','+DOBJASS+');
936:
937:
938: -- Check if API is called in debug mode. If yes, disable debug.
939: AHL_DEBUG_PUB.disable_debug;
940:
941: END IF;
942:
943: WHEN FND_API.G_EXC_ERROR THEN

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

948: p_data => X_msg_data);
949:
950: -- Debug info.
951: IF G_DEBUG='Y' THEN
952: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
953: AHL_DEBUG_PUB.debug( 'ahl_di_asso_doc_aso_pvt.Create Association','+DOCJASS+');
954:
955:
956: -- Check if API is called in debug mode. If yes, disable debug.

Line 953: AHL_DEBUG_PUB.debug( 'ahl_di_asso_doc_aso_pvt.Create Association','+DOCJASS+');

949:
950: -- Debug info.
951: IF G_DEBUG='Y' THEN
952: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
953: AHL_DEBUG_PUB.debug( 'ahl_di_asso_doc_aso_pvt.Create Association','+DOCJASS+');
954:
955:
956: -- Check if API is called in debug mode. If yes, disable debug.
957: AHL_DEBUG_PUB.disable_debug;

Line 957: AHL_DEBUG_PUB.disable_debug;

953: AHL_DEBUG_PUB.debug( 'ahl_di_asso_doc_aso_pvt.Create Association','+DOCJASS+');
954:
955:
956: -- Check if API is called in debug mode. If yes, disable debug.
957: AHL_DEBUG_PUB.disable_debug;
958:
959: END IF;
960:
961: WHEN OTHERS THEN

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

971: p_count => x_msg_count,
972: p_data => X_msg_data);
973: -- Debug info.
974: IF G_DEBUG='Y' THEN
975: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'SQL ERROR' );
976: AHL_DEBUG_PUB.debug( 'ahl_di_asso_doc_aso_pvt.Create Association','+DOCJASS+');
977:
978:
979: -- Check if API is called in debug mode. If yes, disable debug.

Line 976: AHL_DEBUG_PUB.debug( 'ahl_di_asso_doc_aso_pvt.Create Association','+DOCJASS+');

972: p_data => X_msg_data);
973: -- Debug info.
974: IF G_DEBUG='Y' THEN
975: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'SQL ERROR' );
976: AHL_DEBUG_PUB.debug( 'ahl_di_asso_doc_aso_pvt.Create Association','+DOCJASS+');
977:
978:
979: -- Check if API is called in debug mode. If yes, disable debug.
980: AHL_DEBUG_PUB.disable_debug;

Line 980: AHL_DEBUG_PUB.disable_debug;

976: AHL_DEBUG_PUB.debug( 'ahl_di_asso_doc_aso_pvt.Create Association','+DOCJASS+');
977:
978:
979: -- Check if API is called in debug mode. If yes, disable debug.
980: AHL_DEBUG_PUB.disable_debug;
981:
982: END IF;
983:
984: END CREATE_ASSOCIATION;

Line 1113: AHL_DEBUG_PUB.enable_debug;

1109: -- Standard Start of API savepoint
1110: SAVEPOINT modify_association;
1111: -- Check if API is called in debug mode. If yes, enable debug.
1112: IF G_DEBUG='Y' THEN
1113: AHL_DEBUG_PUB.enable_debug;
1114:
1115: END IF;
1116: -- Debug info.
1117: IF G_DEBUG='Y' THEN

Line 1119: AHL_DEBUG_PUB.debug( 'enter ahl_di_asso_doc_aso_pvt.Modify Association','+DOBJASS+');

1115: END IF;
1116: -- Debug info.
1117: IF G_DEBUG='Y' THEN
1118: IF G_DEBUG='Y' THEN
1119: AHL_DEBUG_PUB.debug( 'enter ahl_di_asso_doc_aso_pvt.Modify Association','+DOBJASS+');
1120:
1121: END IF;
1122: END IF;
1123: -- Standard call to check for call compatibility.

Line 1335: AHL_DEBUG_PUB.ENABLE_DEBUG;

1331: l_association_info.attribute15 := p_x_association_tbl(i).attribute15;
1332: END IF;
1333: --
1334: IF G_DEBUG='Y' THEN
1335: AHL_DEBUG_PUB.ENABLE_DEBUG;
1336:
1337: END IF;
1338: --
1339:

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

1512: COMMIT;
1513: END IF;
1514: -- Debug info
1515: IF G_DEBUG='Y' THEN
1516: AHL_DEBUG_PUB.debug( 'End of private api Modify Association','+DOBJASS+');
1517:
1518: END IF;
1519: -- Check if API is called in debug mode. If yes, disable debug.
1520: IF G_DEBUG='Y' THEN

Line 1521: AHL_DEBUG_PUB.disable_debug;

1517:
1518: END IF;
1519: -- Check if API is called in debug mode. If yes, disable debug.
1520: IF G_DEBUG='Y' THEN
1521: AHL_DEBUG_PUB.disable_debug;
1522:
1523: END IF;
1524:
1525: EXCEPTION

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

1531: p_data => x_msg_data);
1532:
1533: --Debug Info
1534: IF G_DEBUG='Y' THEN
1535: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'ERROR' );
1536: AHL_DEBUG_PUB.debug( 'ahl_di_asso_doc_aso_pvt.Modify Association','+DOBJASS+');
1537:
1538:
1539: -- Check if API is called in debug mode. If yes, disable debug.

Line 1536: AHL_DEBUG_PUB.debug( 'ahl_di_asso_doc_aso_pvt.Modify Association','+DOBJASS+');

1532:
1533: --Debug Info
1534: IF G_DEBUG='Y' THEN
1535: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'ERROR' );
1536: AHL_DEBUG_PUB.debug( 'ahl_di_asso_doc_aso_pvt.Modify Association','+DOBJASS+');
1537:
1538:
1539: -- Check if API is called in debug mode. If yes, disable debug.
1540: AHL_DEBUG_PUB.disable_debug;

Line 1540: AHL_DEBUG_PUB.disable_debug;

1536: AHL_DEBUG_PUB.debug( 'ahl_di_asso_doc_aso_pvt.Modify Association','+DOBJASS+');
1537:
1538:
1539: -- Check if API is called in debug mode. If yes, disable debug.
1540: AHL_DEBUG_PUB.disable_debug;
1541:
1542: END IF;
1543:
1544: WHEN FND_API.G_EXC_ERROR THEN

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

1548: p_count => x_msg_count,
1549: p_data => X_msg_data);
1550: -- Debug info.
1551: IF G_DEBUG='Y' THEN
1552: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
1553: AHL_DEBUG_PUB.debug( 'ahl_di_asso_doc_aso_pvt.Modify Association','+DOCJASS+');
1554:
1555:
1556: -- Check if API is called in debug mode. If yes, disable debug.

Line 1553: AHL_DEBUG_PUB.debug( 'ahl_di_asso_doc_aso_pvt.Modify Association','+DOCJASS+');

1549: p_data => X_msg_data);
1550: -- Debug info.
1551: IF G_DEBUG='Y' THEN
1552: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
1553: AHL_DEBUG_PUB.debug( 'ahl_di_asso_doc_aso_pvt.Modify Association','+DOCJASS+');
1554:
1555:
1556: -- Check if API is called in debug mode. If yes, disable debug.
1557: AHL_DEBUG_PUB.disable_debug;

Line 1557: AHL_DEBUG_PUB.disable_debug;

1553: AHL_DEBUG_PUB.debug( 'ahl_di_asso_doc_aso_pvt.Modify Association','+DOCJASS+');
1554:
1555:
1556: -- Check if API is called in debug mode. If yes, disable debug.
1557: AHL_DEBUG_PUB.disable_debug;
1558:
1559: END IF;
1560:
1561: WHEN OTHERS THEN

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

1572: p_data => X_msg_data);
1573:
1574: -- Debug info.
1575: IF G_DEBUG='Y' THEN
1576: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'SQL ERROR' );
1577: AHL_DEBUG_PUB.debug( 'ahl_di_asso_doc_aso_pvt.Modify Association','+DOCJASS+');
1578:
1579:
1580: -- Check if API is called in debug mode. If yes, disable debug.

Line 1577: AHL_DEBUG_PUB.debug( 'ahl_di_asso_doc_aso_pvt.Modify Association','+DOCJASS+');

1573:
1574: -- Debug info.
1575: IF G_DEBUG='Y' THEN
1576: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'SQL ERROR' );
1577: AHL_DEBUG_PUB.debug( 'ahl_di_asso_doc_aso_pvt.Modify Association','+DOCJASS+');
1578:
1579:
1580: -- Check if API is called in debug mode. If yes, disable debug.
1581: AHL_DEBUG_PUB.disable_debug;

Line 1581: AHL_DEBUG_PUB.disable_debug;

1577: AHL_DEBUG_PUB.debug( 'ahl_di_asso_doc_aso_pvt.Modify Association','+DOCJASS+');
1578:
1579:
1580: -- Check if API is called in debug mode. If yes, disable debug.
1581: AHL_DEBUG_PUB.disable_debug;
1582:
1583: END IF;
1584:
1585: END MODIFY_ASSOCIATION;

Line 1633: AHL_DEBUG_PUB.enable_debug;

1629: -- Standard Start of API savepoint
1630: SAVEPOINT insert_assoc_rec;
1631: -- Check if API is called in debug mode. If yes, enable debug.
1632: IF G_DEBUG='Y' THEN
1633: AHL_DEBUG_PUB.enable_debug;
1634:
1635: END IF;
1636: -- Debug info.
1637: IF G_DEBUG='Y' THEN

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

1635: END IF;
1636: -- Debug info.
1637: IF G_DEBUG='Y' THEN
1638: IF G_DEBUG='Y' THEN
1639: AHL_DEBUG_PUB.debug( 'enter ahl_di_asso_doc_aso_pvt.Insert Assoc Rec','+DOBJASS+');
1640:
1641: END IF;
1642: END IF;
1643: -- Standard call to check for call compatibility.

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

1943: COMMIT;
1944: END IF;
1945: -- Debug info
1946: IF G_DEBUG='Y' THEN
1947: AHL_DEBUG_PUB.debug( 'END OF PRIVATE Insret Asso Rec','+DOBJASS+');
1948:
1949: END IF;
1950: -- Check if API is called in debug mode. If yes, disable debug.
1951: IF G_DEBUG='Y' THEN

Line 1952: AHL_DEBUG_PUB.disable_debug;

1948:
1949: END IF;
1950: -- Check if API is called in debug mode. If yes, disable debug.
1951: IF G_DEBUG='Y' THEN
1952: AHL_DEBUG_PUB.disable_debug;
1953:
1954: END IF;
1955:
1956: EXCEPTION

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

1962: p_data => x_msg_data);
1963:
1964: --Debug Info
1965: IF G_DEBUG='Y' THEN
1966: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'ERROR' );
1967: AHL_DEBUG_PUB.debug( 'Ahl_Di_Asso_Doc_Aso_Pvt.INSERT Assoc Rec','+DOBJASS+');
1968:
1969:
1970: -- Check if API is called in debug mode. If yes, disable debug.

Line 1967: AHL_DEBUG_PUB.debug( 'Ahl_Di_Asso_Doc_Aso_Pvt.INSERT Assoc Rec','+DOBJASS+');

1963:
1964: --Debug Info
1965: IF G_DEBUG='Y' THEN
1966: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'ERROR' );
1967: AHL_DEBUG_PUB.debug( 'Ahl_Di_Asso_Doc_Aso_Pvt.INSERT Assoc Rec','+DOBJASS+');
1968:
1969:
1970: -- Check if API is called in debug mode. If yes, disable debug.
1971: AHL_DEBUG_PUB.disable_debug;

Line 1971: AHL_DEBUG_PUB.disable_debug;

1967: AHL_DEBUG_PUB.debug( 'Ahl_Di_Asso_Doc_Aso_Pvt.INSERT Assoc Rec','+DOBJASS+');
1968:
1969:
1970: -- Check if API is called in debug mode. If yes, disable debug.
1971: AHL_DEBUG_PUB.disable_debug;
1972:
1973: END IF;
1974:
1975: WHEN Fnd_Api.G_EXC_ERROR THEN

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

1980: p_data => X_msg_data);
1981:
1982: -- Debug info.
1983: IF G_DEBUG='Y' THEN
1984: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
1985: AHL_DEBUG_PUB.debug( 'Ahl_Di_Asso_Doc_Aso_Pvt. INSERT Assoc Rec','+DOCJASS+');
1986:
1987:
1988: -- Check if API is called in debug mode. If yes, disable debug.

Line 1985: AHL_DEBUG_PUB.debug( 'Ahl_Di_Asso_Doc_Aso_Pvt. INSERT Assoc Rec','+DOCJASS+');

1981:
1982: -- Debug info.
1983: IF G_DEBUG='Y' THEN
1984: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
1985: AHL_DEBUG_PUB.debug( 'Ahl_Di_Asso_Doc_Aso_Pvt. INSERT Assoc Rec','+DOCJASS+');
1986:
1987:
1988: -- Check if API is called in debug mode. If yes, disable debug.
1989: AHL_DEBUG_PUB.disable_debug;

Line 1989: AHL_DEBUG_PUB.disable_debug;

1985: AHL_DEBUG_PUB.debug( 'Ahl_Di_Asso_Doc_Aso_Pvt. INSERT Assoc Rec','+DOCJASS+');
1986:
1987:
1988: -- Check if API is called in debug mode. If yes, disable debug.
1989: AHL_DEBUG_PUB.disable_debug;
1990:
1991: END IF;
1992:
1993: WHEN OTHERS THEN

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

2003: p_count => x_msg_count,
2004: p_data => X_msg_data);
2005: -- Debug info.
2006: IF G_DEBUG='Y' THEN
2007: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'SQL ERROR' );
2008: AHL_DEBUG_PUB.debug( 'Ahl_Di_Asso_Doc_Aso_Pvt.INSERT Assoc Rec','+DOCJASS+');
2009:
2010:
2011: -- Check if API is called in debug mode. If yes, disable debug.

Line 2008: AHL_DEBUG_PUB.debug( 'Ahl_Di_Asso_Doc_Aso_Pvt.INSERT Assoc Rec','+DOCJASS+');

2004: p_data => X_msg_data);
2005: -- Debug info.
2006: IF G_DEBUG='Y' THEN
2007: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'SQL ERROR' );
2008: AHL_DEBUG_PUB.debug( 'Ahl_Di_Asso_Doc_Aso_Pvt.INSERT Assoc Rec','+DOCJASS+');
2009:
2010:
2011: -- Check if API is called in debug mode. If yes, disable debug.
2012: AHL_DEBUG_PUB.disable_debug;

Line 2012: AHL_DEBUG_PUB.disable_debug;

2008: AHL_DEBUG_PUB.debug( 'Ahl_Di_Asso_Doc_Aso_Pvt.INSERT Assoc Rec','+DOCJASS+');
2009:
2010:
2011: -- Check if API is called in debug mode. If yes, disable debug.
2012: AHL_DEBUG_PUB.disable_debug;
2013:
2014: END IF;
2015:
2016: END INSERT_ASSOC_REC;

Line 2060: AHL_DEBUG_PUB.enable_debug;

2056: -- Standard Start of API savepoint
2057: SAVEPOINT copy_association;
2058: -- Check if API is called in debug mode. If yes, enable debug.
2059: IF G_DEBUG='Y' THEN
2060: AHL_DEBUG_PUB.enable_debug;
2061:
2062: END IF;
2063: -- Debug info.
2064: IF G_DEBUG='Y' THEN

Line 2066: AHL_DEBUG_PUB.debug( 'enter Ahl_Di_Asso_Doc_Aso_Pvt.Copy Association','+DOBJASS+');

2062: END IF;
2063: -- Debug info.
2064: IF G_DEBUG='Y' THEN
2065: IF G_DEBUG='Y' THEN
2066: AHL_DEBUG_PUB.debug( 'enter Ahl_Di_Asso_Doc_Aso_Pvt.Copy Association','+DOBJASS+');
2067:
2068: END IF;
2069: END IF;
2070: -- Standard call to check for call compatibility.

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

2082: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
2083: END IF;
2084: IF G_DEBUG='Y' THEN
2085: IF G_DEBUG='Y' THEN
2086: AHL_DEBUG_PUB.debug( 'enter Ahl_Di_Asso_Doc_Aso_Pvt.Copy Association:'||p_from_object_id ,'+DOBJASS+');
2087:
2088: END IF;
2089: END IF;
2090: --Start of API Body

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

2158: COMMIT;
2159: END IF;
2160: -- Debug info
2161: IF G_DEBUG='Y' THEN
2162: AHL_DEBUG_PUB.debug( 'END OF PRIVATE copy Association','+DOBJASS+');
2163:
2164: END IF;
2165: -- Check if API is called in debug mode. If yes, disable debug.
2166: IF G_DEBUG='Y' THEN

Line 2167: AHL_DEBUG_PUB.disable_debug;

2163:
2164: END IF;
2165: -- Check if API is called in debug mode. If yes, disable debug.
2166: IF G_DEBUG='Y' THEN
2167: AHL_DEBUG_PUB.disable_debug;
2168:
2169: END IF;
2170:
2171: EXCEPTION

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

2177: p_data => x_msg_data);
2178:
2179: --Debug Info
2180: IF G_DEBUG='Y' THEN
2181: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'ERROR' );
2182: AHL_DEBUG_PUB.debug( 'Ahl_Di_Asso_Doc_Aso_Pvt.Copy Association','+DOBJASS+');
2183:
2184:
2185: -- Check if API is called in debug mode. If yes, disable debug.

Line 2182: AHL_DEBUG_PUB.debug( 'Ahl_Di_Asso_Doc_Aso_Pvt.Copy Association','+DOBJASS+');

2178:
2179: --Debug Info
2180: IF G_DEBUG='Y' THEN
2181: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'ERROR' );
2182: AHL_DEBUG_PUB.debug( 'Ahl_Di_Asso_Doc_Aso_Pvt.Copy Association','+DOBJASS+');
2183:
2184:
2185: -- Check if API is called in debug mode. If yes, disable debug.
2186: AHL_DEBUG_PUB.disable_debug;

Line 2186: AHL_DEBUG_PUB.disable_debug;

2182: AHL_DEBUG_PUB.debug( 'Ahl_Di_Asso_Doc_Aso_Pvt.Copy Association','+DOBJASS+');
2183:
2184:
2185: -- Check if API is called in debug mode. If yes, disable debug.
2186: AHL_DEBUG_PUB.disable_debug;
2187:
2188: END IF;
2189:
2190: WHEN Fnd_Api.G_EXC_ERROR THEN

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

2194: p_count => x_msg_count,
2195: p_data => X_msg_data);
2196: -- Debug info.
2197: IF G_DEBUG='Y' THEN
2198: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
2199: AHL_DEBUG_PUB.debug( 'Ahl_Di_Asso_Doc_Aso_Pvt.Copy Association','+DOCJASS+');
2200:
2201:
2202: -- Check if API is called in debug mode. If yes, disable debug.

Line 2199: AHL_DEBUG_PUB.debug( 'Ahl_Di_Asso_Doc_Aso_Pvt.Copy Association','+DOCJASS+');

2195: p_data => X_msg_data);
2196: -- Debug info.
2197: IF G_DEBUG='Y' THEN
2198: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
2199: AHL_DEBUG_PUB.debug( 'Ahl_Di_Asso_Doc_Aso_Pvt.Copy Association','+DOCJASS+');
2200:
2201:
2202: -- Check if API is called in debug mode. If yes, disable debug.
2203: AHL_DEBUG_PUB.disable_debug;

Line 2203: AHL_DEBUG_PUB.disable_debug;

2199: AHL_DEBUG_PUB.debug( 'Ahl_Di_Asso_Doc_Aso_Pvt.Copy Association','+DOCJASS+');
2200:
2201:
2202: -- Check if API is called in debug mode. If yes, disable debug.
2203: AHL_DEBUG_PUB.disable_debug;
2204:
2205: END IF;
2206:
2207: WHEN OTHERS THEN

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

2218: p_data => X_msg_data);
2219:
2220: -- Debug info.
2221: IF G_DEBUG='Y' THEN
2222: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'SQL ERROR' );
2223: AHL_DEBUG_PUB.debug( 'Ahl_Di_Asso_Doc_Aso_Pvt.Copy Association','+DOCJASS+');
2224:
2225:
2226: -- Check if API is called in debug mode. If yes, disable debug.

Line 2223: AHL_DEBUG_PUB.debug( 'Ahl_Di_Asso_Doc_Aso_Pvt.Copy Association','+DOCJASS+');

2219:
2220: -- Debug info.
2221: IF G_DEBUG='Y' THEN
2222: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'SQL ERROR' );
2223: AHL_DEBUG_PUB.debug( 'Ahl_Di_Asso_Doc_Aso_Pvt.Copy Association','+DOCJASS+');
2224:
2225:
2226: -- Check if API is called in debug mode. If yes, disable debug.
2227:

Line 2228: AHL_DEBUG_PUB.disable_debug;

2224:
2225:
2226: -- Check if API is called in debug mode. If yes, disable debug.
2227:
2228: AHL_DEBUG_PUB.disable_debug;
2229:
2230: END IF;
2231:
2232: END COPY_ASSOCIATION;