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.

[Home] [Help]

APPS.AHL_FMP_MR_HEADER_PVT dependencies on AHL_DEBUG_PUB

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

2: /* $Header: AHLVMRHB.pls 120.9.12020000.2 2012/12/13 05:03:22 shnatu ship $ */
3:
4: G_PKG_NAME VARCHAR2(30):='AHL_FMP_MR_HEADER_PVT';
5: G_APPLN_USAGE VARCHAR2(30):=RTRIM(LTRIM(FND_PROFILE.VALUE('AHL_APPLN_USAGE')));
6: G_DEBUG VARCHAR2(1) :=AHL_DEBUG_PUB.is_log_enabled;
7:
8: PROCEDURE DEFAULT_MISSING_ATTRIBS
9: (p_x_mr_header_rec IN OUT NOCOPY AHL_FMP_MR_HEADER_PVT.MR_HEADER_REC)
10: AS

Line 95: AHL_DEBUG_PUB.enable_debug;

91:
92: l_MR_header_rec CurHeaderDet%ROWTYPE;
93: BEGIN
94: IF G_DEBUG='Y' THEN
95: AHL_DEBUG_PUB.enable_debug;
96: END IF;
97:
98: OPEN CurHeaderDet(p_x_mr_header_rec.mr_header_id);
99: FETCH CurHeaderDet INTO l_mr_header_rec;

Line 747: AHL_DEBUG_PUB.enable_debug;

743:
744: BEGIN
745:
746: IF G_DEBUG='Y' THEN
747: AHL_DEBUG_PUB.enable_debug;
748: AHL_DEBUG_PUB.debug('Trans TYPE CODE '||p_x_mr_header_rec.TYPE_CODE,'+HEADERS+');
749: END IF;
750:
751: x_return_status:=FND_API.G_RET_STS_SUCCESS;

Line 748: AHL_DEBUG_PUB.debug('Trans TYPE CODE '||p_x_mr_header_rec.TYPE_CODE,'+HEADERS+');

744: BEGIN
745:
746: IF G_DEBUG='Y' THEN
747: AHL_DEBUG_PUB.enable_debug;
748: AHL_DEBUG_PUB.debug('Trans TYPE CODE '||p_x_mr_header_rec.TYPE_CODE,'+HEADERS+');
749: END IF;
750:
751: x_return_status:=FND_API.G_RET_STS_SUCCESS;
752:

Line 919: AHL_DEBUG_PUB.debug( 'PRECEDING MR_TITLE COUNTER');

915:
916: IF nvl(l_title_counter,0)=0
917: THEN
918: IF G_DEBUG='Y' THEN
919: AHL_DEBUG_PUB.debug( 'PRECEDING MR_TITLE COUNTER');
920: END IF;
921: FND_MESSAGE.SET_NAME('AHL','AHL_FMP_MR_PREC_MR_ID_INVALID');
922: FND_MESSAGE.SET_TOKEN('FIELD',p_x_mr_header_rec.PRECEDING_MR_TITLE,false);
923: FND_MSG_PUB.ADD;

Line 933: AHL_DEBUG_PUB.debug(' Preceding MRHEADER_ID NOT FOUND2','+HEADERS+');

929:
930: IF get_mr_header%NOTFOUND
931: THEN
932: IF G_DEBUG='Y' THEN
933: AHL_DEBUG_PUB.debug(' Preceding MRHEADER_ID NOT FOUND2','+HEADERS+');
934: END IF;
935: FND_MESSAGE.SET_NAME('AHL','AHL_FMP_MR_PREC_MR_ID_INVALID');
936: FND_MESSAGE.SET_TOKEN('FIELD',p_x_mr_header_rec.PRECEDING_MR_TITLE,false);
937: FND_MSG_PUB.ADD;

Line 946: AHL_DEBUG_PUB.debug( 'PRECEDING .. MR>1 '||p_x_mr_header_rec.PRECEDING_MR_HEADER_ID,'+HEADERS+');

942: OPEN get_prec_mrheader_info(p_x_mr_header_rec.PRECEDING_MR_HEADER_ID);
943: FETCH get_prec_mrheader_info INTO l_prec_mr_info;
944:
945: IF G_DEBUG='Y' THEN
946: AHL_DEBUG_PUB.debug( 'PRECEDING .. MR>1 '||p_x_mr_header_rec.PRECEDING_MR_HEADER_ID,'+HEADERS+');
947: END IF;
948:
949: IF get_prec_mrheader_info%NOTFOUND
950: THEN

Line 952: AHL_DEBUG_PUB.debug('Preceding mr title err','+HEADERS+');

948:
949: IF get_prec_mrheader_info%NOTFOUND
950: THEN
951: IF G_DEBUG='Y' THEN
952: AHL_DEBUG_PUB.debug('Preceding mr title err','+HEADERS+');
953: END IF;
954:
955: FND_MESSAGE.SET_NAME('AHL','AHL_FMP_MR_PREC_MR_ID_INVALID');
956: FND_MESSAGE.SET_TOKEN('FIELD',p_x_mr_header_rec.PRECEDING_MR_TITLE,false);

Line 1348: AHL_DEBUG_PUB.enable_debug;

1344: BEGIN
1345: x_return_status:=FND_API.G_RET_STS_SUCCESS;
1346:
1347: IF G_DEBUG='Y' THEN
1348: AHL_DEBUG_PUB.enable_debug;
1349: AHL_DEBUG_PUB.debug('Application Usage code:'||G_APPLN_USAGE);
1350: AHL_DEBUG_PUB.debug('TYPE CODE '||p_mr_header_rec.TYPE_CODE,'+HEADERS+');
1351: END IF;
1352:

Line 1349: AHL_DEBUG_PUB.debug('Application Usage code:'||G_APPLN_USAGE);

1345: x_return_status:=FND_API.G_RET_STS_SUCCESS;
1346:
1347: IF G_DEBUG='Y' THEN
1348: AHL_DEBUG_PUB.enable_debug;
1349: AHL_DEBUG_PUB.debug('Application Usage code:'||G_APPLN_USAGE);
1350: AHL_DEBUG_PUB.debug('TYPE CODE '||p_mr_header_rec.TYPE_CODE,'+HEADERS+');
1351: END IF;
1352:
1353: IF G_APPLN_USAGE IS NULL

Line 1350: AHL_DEBUG_PUB.debug('TYPE CODE '||p_mr_header_rec.TYPE_CODE,'+HEADERS+');

1346:
1347: IF G_DEBUG='Y' THEN
1348: AHL_DEBUG_PUB.enable_debug;
1349: AHL_DEBUG_PUB.debug('Application Usage code:'||G_APPLN_USAGE);
1350: AHL_DEBUG_PUB.debug('TYPE CODE '||p_mr_header_rec.TYPE_CODE,'+HEADERS+');
1351: END IF;
1352:
1353: IF G_APPLN_USAGE IS NULL
1354: THEN

Line 1468: AHL_DEBUG_PUB.debug('Error at AHL_FMP_AUTSIGNOFF_QA_INV');

1464: IF p_mr_header_rec.QA_INSPECTION_TYPE IS NOT NULL
1465: and p_mr_header_rec.QA_INSPECTION_TYPE <>FND_API.G_MISS_CHAR
1466: THEN
1467: IF G_DEBUG='Y' THEN
1468: AHL_DEBUG_PUB.debug('Error at AHL_FMP_AUTSIGNOFF_QA_INV');
1469: END IF;
1470: FND_MESSAGE.SET_NAME('AHL','AHL_FMP_AUTSIGNOFF_QA_INV');
1471: FND_MSG_PUB.ADD;
1472: END IF;

Line 1577: AHL_DEBUG_PUB.debug('RETURN STATUS '||l_return_status,'+ERRORS+');

1573: x_return_status =>l_return_status,
1574: p_space_category_code =>p_mr_header_rec.space_category_code
1575: );
1576:
1577: AHL_DEBUG_PUB.debug('RETURN STATUS '||l_return_status,'+ERRORS+');
1578:
1579: IF l_return_status<>'S'
1580: THEN
1581: FND_MESSAGE.SET_NAME('AHL','AHL_FMP_INVALID_SERV_CAT_RANK');

Line 1634: AHL_DEBUG_PUB.debug('superusermode is ...:'||l_MR_HEADER_REC.SUPERUSER_ROLE);

1630: END IF;
1631: -- Super User
1632: IF G_DEBUG='Y'
1633: THEN
1634: AHL_DEBUG_PUB.debug('superusermode is ...:'||l_MR_HEADER_REC.SUPERUSER_ROLE);
1635: AHL_DEBUG_PUB.debug('billing item :'||nvl(l_MR_HEADER_REC.BILLING_ITEM,'X'));
1636: AHL_DEBUG_PUB.debug('billing item :'||nvl(l_REC.BILLING_ITEM,'X'));
1637: AHL_DEBUG_PUB.debug('billing item :'||nvl(p_mr_header_rec.mr_header_id,0));
1638: END IF;

Line 1635: AHL_DEBUG_PUB.debug('billing item :'||nvl(l_MR_HEADER_REC.BILLING_ITEM,'X'));

1631: -- Super User
1632: IF G_DEBUG='Y'
1633: THEN
1634: AHL_DEBUG_PUB.debug('superusermode is ...:'||l_MR_HEADER_REC.SUPERUSER_ROLE);
1635: AHL_DEBUG_PUB.debug('billing item :'||nvl(l_MR_HEADER_REC.BILLING_ITEM,'X'));
1636: AHL_DEBUG_PUB.debug('billing item :'||nvl(l_REC.BILLING_ITEM,'X'));
1637: AHL_DEBUG_PUB.debug('billing item :'||nvl(p_mr_header_rec.mr_header_id,0));
1638: END IF;
1639: IF l_mr_header_rec.MR_STATUS_CODE='COMPLETE' AND nvl(l_mr_header_rec.SUPERUSER_ROLE,'N')='N'

Line 1636: AHL_DEBUG_PUB.debug('billing item :'||nvl(l_REC.BILLING_ITEM,'X'));

1632: IF G_DEBUG='Y'
1633: THEN
1634: AHL_DEBUG_PUB.debug('superusermode is ...:'||l_MR_HEADER_REC.SUPERUSER_ROLE);
1635: AHL_DEBUG_PUB.debug('billing item :'||nvl(l_MR_HEADER_REC.BILLING_ITEM,'X'));
1636: AHL_DEBUG_PUB.debug('billing item :'||nvl(l_REC.BILLING_ITEM,'X'));
1637: AHL_DEBUG_PUB.debug('billing item :'||nvl(p_mr_header_rec.mr_header_id,0));
1638: END IF;
1639: IF l_mr_header_rec.MR_STATUS_CODE='COMPLETE' AND nvl(l_mr_header_rec.SUPERUSER_ROLE,'N')='N'
1640: THEN

Line 1637: AHL_DEBUG_PUB.debug('billing item :'||nvl(p_mr_header_rec.mr_header_id,0));

1633: THEN
1634: AHL_DEBUG_PUB.debug('superusermode is ...:'||l_MR_HEADER_REC.SUPERUSER_ROLE);
1635: AHL_DEBUG_PUB.debug('billing item :'||nvl(l_MR_HEADER_REC.BILLING_ITEM,'X'));
1636: AHL_DEBUG_PUB.debug('billing item :'||nvl(l_REC.BILLING_ITEM,'X'));
1637: AHL_DEBUG_PUB.debug('billing item :'||nvl(p_mr_header_rec.mr_header_id,0));
1638: END IF;
1639: IF l_mr_header_rec.MR_STATUS_CODE='COMPLETE' AND nvl(l_mr_header_rec.SUPERUSER_ROLE,'N')='N'
1640: THEN
1641: FND_MESSAGE.SET_NAME('AHL','AHL_FMP_MR_INVALID_EDIT');

Line 1651: AHL_DEBUG_PUB.debug(l_rec.REPETITIVE_FLAG ||'---'||(p_mr_header_rec.REPETITIVE_FLAG));

1647: OPEN get_super_non_edit(p_mr_header_rec.MR_HEADER_ID);
1648: FETCH get_super_non_edit INTO l_rec;
1649: IF G_DEBUG='Y'
1650: THEN
1651: AHL_DEBUG_PUB.debug(l_rec.REPETITIVE_FLAG ||'---'||(p_mr_header_rec.REPETITIVE_FLAG));
1652: AHL_DEBUG_PUB.debug(l_rec.SHOW_REPETITIVE_CODE||'---'|| (p_mr_header_rec.SHOW_REPETITIVE_CODE));
1653: AHL_DEBUG_PUB.debug(l_rec.WHICHEVER_FIRST_CODE||'---'|| (p_mr_header_rec.WHICHEVER_FIRST_CODE));
1654: AHL_DEBUG_PUB.debug(l_rec.EFFECTIVE_FROM||'---'||(p_mr_header_rec.EFFECTIVE_FROM));
1655: AHL_DEBUG_PUB.debug(l_rec.BILLING_ITEM_ID||'---'||(p_mr_header_rec.BILLING_ITEM_ID));

Line 1652: AHL_DEBUG_PUB.debug(l_rec.SHOW_REPETITIVE_CODE||'---'|| (p_mr_header_rec.SHOW_REPETITIVE_CODE));

1648: FETCH get_super_non_edit INTO l_rec;
1649: IF G_DEBUG='Y'
1650: THEN
1651: AHL_DEBUG_PUB.debug(l_rec.REPETITIVE_FLAG ||'---'||(p_mr_header_rec.REPETITIVE_FLAG));
1652: AHL_DEBUG_PUB.debug(l_rec.SHOW_REPETITIVE_CODE||'---'|| (p_mr_header_rec.SHOW_REPETITIVE_CODE));
1653: AHL_DEBUG_PUB.debug(l_rec.WHICHEVER_FIRST_CODE||'---'|| (p_mr_header_rec.WHICHEVER_FIRST_CODE));
1654: AHL_DEBUG_PUB.debug(l_rec.EFFECTIVE_FROM||'---'||(p_mr_header_rec.EFFECTIVE_FROM));
1655: AHL_DEBUG_PUB.debug(l_rec.BILLING_ITEM_ID||'---'||(p_mr_header_rec.BILLING_ITEM_ID));
1656: AHL_DEBUG_PUB.debug(l_rec.BILLING_ITEM);

Line 1653: AHL_DEBUG_PUB.debug(l_rec.WHICHEVER_FIRST_CODE||'---'|| (p_mr_header_rec.WHICHEVER_FIRST_CODE));

1649: IF G_DEBUG='Y'
1650: THEN
1651: AHL_DEBUG_PUB.debug(l_rec.REPETITIVE_FLAG ||'---'||(p_mr_header_rec.REPETITIVE_FLAG));
1652: AHL_DEBUG_PUB.debug(l_rec.SHOW_REPETITIVE_CODE||'---'|| (p_mr_header_rec.SHOW_REPETITIVE_CODE));
1653: AHL_DEBUG_PUB.debug(l_rec.WHICHEVER_FIRST_CODE||'---'|| (p_mr_header_rec.WHICHEVER_FIRST_CODE));
1654: AHL_DEBUG_PUB.debug(l_rec.EFFECTIVE_FROM||'---'||(p_mr_header_rec.EFFECTIVE_FROM));
1655: AHL_DEBUG_PUB.debug(l_rec.BILLING_ITEM_ID||'---'||(p_mr_header_rec.BILLING_ITEM_ID));
1656: AHL_DEBUG_PUB.debug(l_rec.BILLING_ITEM);
1657: AHL_DEBUG_PUB.debug(l_rec.qa_inspection_type_code||'---'||(p_mr_header_rec.qa_inspection_type_code));

Line 1654: AHL_DEBUG_PUB.debug(l_rec.EFFECTIVE_FROM||'---'||(p_mr_header_rec.EFFECTIVE_FROM));

1650: THEN
1651: AHL_DEBUG_PUB.debug(l_rec.REPETITIVE_FLAG ||'---'||(p_mr_header_rec.REPETITIVE_FLAG));
1652: AHL_DEBUG_PUB.debug(l_rec.SHOW_REPETITIVE_CODE||'---'|| (p_mr_header_rec.SHOW_REPETITIVE_CODE));
1653: AHL_DEBUG_PUB.debug(l_rec.WHICHEVER_FIRST_CODE||'---'|| (p_mr_header_rec.WHICHEVER_FIRST_CODE));
1654: AHL_DEBUG_PUB.debug(l_rec.EFFECTIVE_FROM||'---'||(p_mr_header_rec.EFFECTIVE_FROM));
1655: AHL_DEBUG_PUB.debug(l_rec.BILLING_ITEM_ID||'---'||(p_mr_header_rec.BILLING_ITEM_ID));
1656: AHL_DEBUG_PUB.debug(l_rec.BILLING_ITEM);
1657: AHL_DEBUG_PUB.debug(l_rec.qa_inspection_type_code||'---'||(p_mr_header_rec.qa_inspection_type_code));
1658: AHL_DEBUG_PUB.debug(l_rec.space_category_code||'---'||(P_mr_header_rec.space_category_code));

Line 1655: AHL_DEBUG_PUB.debug(l_rec.BILLING_ITEM_ID||'---'||(p_mr_header_rec.BILLING_ITEM_ID));

1651: AHL_DEBUG_PUB.debug(l_rec.REPETITIVE_FLAG ||'---'||(p_mr_header_rec.REPETITIVE_FLAG));
1652: AHL_DEBUG_PUB.debug(l_rec.SHOW_REPETITIVE_CODE||'---'|| (p_mr_header_rec.SHOW_REPETITIVE_CODE));
1653: AHL_DEBUG_PUB.debug(l_rec.WHICHEVER_FIRST_CODE||'---'|| (p_mr_header_rec.WHICHEVER_FIRST_CODE));
1654: AHL_DEBUG_PUB.debug(l_rec.EFFECTIVE_FROM||'---'||(p_mr_header_rec.EFFECTIVE_FROM));
1655: AHL_DEBUG_PUB.debug(l_rec.BILLING_ITEM_ID||'---'||(p_mr_header_rec.BILLING_ITEM_ID));
1656: AHL_DEBUG_PUB.debug(l_rec.BILLING_ITEM);
1657: AHL_DEBUG_PUB.debug(l_rec.qa_inspection_type_code||'---'||(p_mr_header_rec.qa_inspection_type_code));
1658: AHL_DEBUG_PUB.debug(l_rec.space_category_code||'---'||(P_mr_header_rec.space_category_code));
1659: AHL_DEBUG_PUB.debug(l_rec.DOWN_TIME||'---'||(p_mr_header_rec.DOWN_TIME));

Line 1656: AHL_DEBUG_PUB.debug(l_rec.BILLING_ITEM);

1652: AHL_DEBUG_PUB.debug(l_rec.SHOW_REPETITIVE_CODE||'---'|| (p_mr_header_rec.SHOW_REPETITIVE_CODE));
1653: AHL_DEBUG_PUB.debug(l_rec.WHICHEVER_FIRST_CODE||'---'|| (p_mr_header_rec.WHICHEVER_FIRST_CODE));
1654: AHL_DEBUG_PUB.debug(l_rec.EFFECTIVE_FROM||'---'||(p_mr_header_rec.EFFECTIVE_FROM));
1655: AHL_DEBUG_PUB.debug(l_rec.BILLING_ITEM_ID||'---'||(p_mr_header_rec.BILLING_ITEM_ID));
1656: AHL_DEBUG_PUB.debug(l_rec.BILLING_ITEM);
1657: AHL_DEBUG_PUB.debug(l_rec.qa_inspection_type_code||'---'||(p_mr_header_rec.qa_inspection_type_code));
1658: AHL_DEBUG_PUB.debug(l_rec.space_category_code||'---'||(P_mr_header_rec.space_category_code));
1659: AHL_DEBUG_PUB.debug(l_rec.DOWN_TIME||'---'||(p_mr_header_rec.DOWN_TIME));
1660: AHL_DEBUG_PUB.debug(l_rec.UOM_CODE||'---'||(p_mr_header_rec.uom_code));

Line 1657: AHL_DEBUG_PUB.debug(l_rec.qa_inspection_type_code||'---'||(p_mr_header_rec.qa_inspection_type_code));

1653: AHL_DEBUG_PUB.debug(l_rec.WHICHEVER_FIRST_CODE||'---'|| (p_mr_header_rec.WHICHEVER_FIRST_CODE));
1654: AHL_DEBUG_PUB.debug(l_rec.EFFECTIVE_FROM||'---'||(p_mr_header_rec.EFFECTIVE_FROM));
1655: AHL_DEBUG_PUB.debug(l_rec.BILLING_ITEM_ID||'---'||(p_mr_header_rec.BILLING_ITEM_ID));
1656: AHL_DEBUG_PUB.debug(l_rec.BILLING_ITEM);
1657: AHL_DEBUG_PUB.debug(l_rec.qa_inspection_type_code||'---'||(p_mr_header_rec.qa_inspection_type_code));
1658: AHL_DEBUG_PUB.debug(l_rec.space_category_code||'---'||(P_mr_header_rec.space_category_code));
1659: AHL_DEBUG_PUB.debug(l_rec.DOWN_TIME||'---'||(p_mr_header_rec.DOWN_TIME));
1660: AHL_DEBUG_PUB.debug(l_rec.UOM_CODE||'---'||(p_mr_header_rec.uom_code));
1661: END IF;

Line 1658: AHL_DEBUG_PUB.debug(l_rec.space_category_code||'---'||(P_mr_header_rec.space_category_code));

1654: AHL_DEBUG_PUB.debug(l_rec.EFFECTIVE_FROM||'---'||(p_mr_header_rec.EFFECTIVE_FROM));
1655: AHL_DEBUG_PUB.debug(l_rec.BILLING_ITEM_ID||'---'||(p_mr_header_rec.BILLING_ITEM_ID));
1656: AHL_DEBUG_PUB.debug(l_rec.BILLING_ITEM);
1657: AHL_DEBUG_PUB.debug(l_rec.qa_inspection_type_code||'---'||(p_mr_header_rec.qa_inspection_type_code));
1658: AHL_DEBUG_PUB.debug(l_rec.space_category_code||'---'||(P_mr_header_rec.space_category_code));
1659: AHL_DEBUG_PUB.debug(l_rec.DOWN_TIME||'---'||(p_mr_header_rec.DOWN_TIME));
1660: AHL_DEBUG_PUB.debug(l_rec.UOM_CODE||'---'||(p_mr_header_rec.uom_code));
1661: END IF;
1662:

Line 1659: AHL_DEBUG_PUB.debug(l_rec.DOWN_TIME||'---'||(p_mr_header_rec.DOWN_TIME));

1655: AHL_DEBUG_PUB.debug(l_rec.BILLING_ITEM_ID||'---'||(p_mr_header_rec.BILLING_ITEM_ID));
1656: AHL_DEBUG_PUB.debug(l_rec.BILLING_ITEM);
1657: AHL_DEBUG_PUB.debug(l_rec.qa_inspection_type_code||'---'||(p_mr_header_rec.qa_inspection_type_code));
1658: AHL_DEBUG_PUB.debug(l_rec.space_category_code||'---'||(P_mr_header_rec.space_category_code));
1659: AHL_DEBUG_PUB.debug(l_rec.DOWN_TIME||'---'||(p_mr_header_rec.DOWN_TIME));
1660: AHL_DEBUG_PUB.debug(l_rec.UOM_CODE||'---'||(p_mr_header_rec.uom_code));
1661: END IF;
1662:
1663: IF nvl(l_rec.REPETITIVE_FLAG,'X') <> nvl(p_mr_header_rec.REPETITIVE_FLAG,'X')

Line 1660: AHL_DEBUG_PUB.debug(l_rec.UOM_CODE||'---'||(p_mr_header_rec.uom_code));

1656: AHL_DEBUG_PUB.debug(l_rec.BILLING_ITEM);
1657: AHL_DEBUG_PUB.debug(l_rec.qa_inspection_type_code||'---'||(p_mr_header_rec.qa_inspection_type_code));
1658: AHL_DEBUG_PUB.debug(l_rec.space_category_code||'---'||(P_mr_header_rec.space_category_code));
1659: AHL_DEBUG_PUB.debug(l_rec.DOWN_TIME||'---'||(p_mr_header_rec.DOWN_TIME));
1660: AHL_DEBUG_PUB.debug(l_rec.UOM_CODE||'---'||(p_mr_header_rec.uom_code));
1661: END IF;
1662:
1663: IF nvl(l_rec.REPETITIVE_FLAG,'X') <> nvl(p_mr_header_rec.REPETITIVE_FLAG,'X')
1664: or nvl(l_rec.SHOW_REPETITIVE_CODE,'X')<> nvl(p_mr_header_rec.SHOW_REPETITIVE_CODE,'X')

Line 1675: AHL_DEBUG_PUB.debug('SUPERUSER NONEDIT:'||L_MR_HEADER_REC.SUPERUSER_ROLE);

1671: or nvl(l_rec.UOM_CODE,'X')<>nvl(p_mr_header_rec.uom_code,'X')
1672: THEN
1673: FND_MESSAGE.SET_NAME('AHL','AHL_FMP_MR_SUPER_NONEDIT_COLS');
1674: FND_MSG_PUB.ADD;
1675: AHL_DEBUG_PUB.debug('SUPERUSER NONEDIT:'||L_MR_HEADER_REC.SUPERUSER_ROLE);
1676: l_check_flag:='N';
1677: END IF;
1678: CLOSE get_super_non_edit;
1679: END IF;

Line 1759: AHL_DEBUG_PUB.debug('Error.Before calling validate mr_type :'||L_MR_HEADER_REC.SUPERUSER_ROLE);

1755: END IF;
1756:
1757: IF p_mr_header_rec.DML_OPERATION='U'
1758: THEN
1759: AHL_DEBUG_PUB.debug('Error.Before calling validate mr_type :'||L_MR_HEADER_REC.SUPERUSER_ROLE);
1760: VALIDATE_MR_TYPE
1761: (
1762: x_return_status =>x_return_Status,
1763: p_mr_header_rec =>l_mr_header_rec

Line 2118: AHL_DEBUG_PUB.enable_debug;

2114: x_return_status:=FND_API.G_RET_STS_SUCCESS;
2115:
2116:
2117: IF G_DEBUG='Y' THEN
2118: AHL_DEBUG_PUB.enable_debug;
2119: END IF;
2120:
2121:
2122: IF p_module_type = 'JSP' THEN

Line 2133: AHL_DEBUG_PUB.debug('p_x_mr_header_rec.billing_item_id :'||p_x_mr_header_rec.billing_item_id);

2129: p_x_mr_header_rec.PRECEDING_MR_HEADER_ID:=NULL;
2130: --CHANDANK, 29-Sep-2010, added supplier warranty ID for supplier warranty project
2131: p_x_mr_header_rec.WARRANTY_TEMPLATE_ID:=NULL;
2132: END IF;
2133: AHL_DEBUG_PUB.debug('p_x_mr_header_rec.billing_item_id :'||p_x_mr_header_rec.billing_item_id);
2134: -- Debug info.
2135:
2136: IF G_DEBUG='Y' THEN
2137: AHL_DEBUG_PUB.debug( 'AHL_FMP_MR_HEADERS_PVT.','+CREATE_MR_HEADER+');

Line 2137: AHL_DEBUG_PUB.debug( 'AHL_FMP_MR_HEADERS_PVT.','+CREATE_MR_HEADER+');

2133: AHL_DEBUG_PUB.debug('p_x_mr_header_rec.billing_item_id :'||p_x_mr_header_rec.billing_item_id);
2134: -- Debug info.
2135:
2136: IF G_DEBUG='Y' THEN
2137: AHL_DEBUG_PUB.debug( 'AHL_FMP_MR_HEADERS_PVT.','+CREATE_MR_HEADER+');
2138: END IF;
2139:
2140: IF FND_API.to_boolean(p_default)
2141: THEN

Line 2271: AHL_DEBUG_PUB.disable_debug;

2267: COMMIT;
2268: END IF;
2269:
2270: IF G_DEBUG='Y' THEN
2271: AHL_DEBUG_PUB.disable_debug;
2272: END IF;
2273:
2274: EXCEPTION
2275: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2282: AHL_DEBUG_PUB.disable_debug;

2278: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
2279: p_count => x_msg_count,
2280: p_data => x_msg_data);
2281: IF G_DEBUG='Y' THEN
2282: AHL_DEBUG_PUB.disable_debug;
2283: END IF;
2284: WHEN FND_API.G_EXC_ERROR THEN
2285: ROLLBACK TO CREATE_MR_HEADER_PVT;
2286: X_return_status := FND_API.G_RET_STS_ERROR;

Line 2291: AHL_DEBUG_PUB.disable_debug;

2287: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
2288: p_count => x_msg_count,
2289: p_data => X_msg_data);
2290: IF G_DEBUG='Y' THEN
2291: AHL_DEBUG_PUB.disable_debug;
2292: END IF;
2293:
2294: WHEN OTHERS THEN
2295: ROLLBACK TO CREATE_MR_HEADER_PVT;

Line 2308: AHL_DEBUG_PUB.disable_debug;

2304: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
2305: p_count => x_msg_count,
2306: p_data => X_msg_data);
2307: IF G_DEBUG='Y' THEN
2308: AHL_DEBUG_PUB.disable_debug;
2309: END IF;
2310: END;
2311:
2312:

Line 2351: AHL_DEBUG_PUB.enable_debug;

2347:
2348: x_return_status:=FND_API.G_RET_STS_SUCCESS;
2349:
2350: IF G_DEBUG='Y' THEN
2351: AHL_DEBUG_PUB.enable_debug;
2352: AHL_DEBUG_PUB.debug('Service Category CODE:'||p_x_mr_header_Rec.SPACE_CATEGORY_CODE);
2353: AHL_DEBUG_PUB.debug('Service Category MEANING :'||p_x_mr_header_Rec.SPACE_CATEGORY);
2354: END IF;
2355: --11.5.10 public API change.

Line 2352: AHL_DEBUG_PUB.debug('Service Category CODE:'||p_x_mr_header_Rec.SPACE_CATEGORY_CODE);

2348: x_return_status:=FND_API.G_RET_STS_SUCCESS;
2349:
2350: IF G_DEBUG='Y' THEN
2351: AHL_DEBUG_PUB.enable_debug;
2352: AHL_DEBUG_PUB.debug('Service Category CODE:'||p_x_mr_header_Rec.SPACE_CATEGORY_CODE);
2353: AHL_DEBUG_PUB.debug('Service Category MEANING :'||p_x_mr_header_Rec.SPACE_CATEGORY);
2354: END IF;
2355: --11.5.10 public API change.
2356: IF p_x_mr_header_rec.mr_header_id IS NULL THEN

Line 2353: AHL_DEBUG_PUB.debug('Service Category MEANING :'||p_x_mr_header_Rec.SPACE_CATEGORY);

2349:
2350: IF G_DEBUG='Y' THEN
2351: AHL_DEBUG_PUB.enable_debug;
2352: AHL_DEBUG_PUB.debug('Service Category CODE:'||p_x_mr_header_Rec.SPACE_CATEGORY_CODE);
2353: AHL_DEBUG_PUB.debug('Service Category MEANING :'||p_x_mr_header_Rec.SPACE_CATEGORY);
2354: END IF;
2355: --11.5.10 public API change.
2356: IF p_x_mr_header_rec.mr_header_id IS NULL THEN
2357: -- Function to convert mr_title,mr_version_number to id

Line 2550: -- AHL_DEBUG_PUB.debug( 'End of Private api UPDATE_MR_HEADER','+MR_header+');

2546: COMMIT;
2547: END IF;
2548: -- Debug info
2549:
2550: -- AHL_DEBUG_PUB.debug( 'End of Private api UPDATE_MR_HEADER','+MR_header+');
2551:
2552: -- Check if API is called in debug mode. If yes, disable debug.
2553:
2554: IF G_DEBUG='Y' THEN

Line 2555: AHL_DEBUG_PUB.disable_debug;

2551:
2552: -- Check if API is called in debug mode. If yes, disable debug.
2553:
2554: IF G_DEBUG='Y' THEN
2555: AHL_DEBUG_PUB.disable_debug;
2556: END IF;
2557:
2558: EXCEPTION
2559:

Line 2567: AHL_DEBUG_PUB.disable_debug;

2563: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
2564: p_count => x_msg_count,
2565: p_data => x_msg_data);
2566: IF G_DEBUG='Y' THEN
2567: AHL_DEBUG_PUB.disable_debug;
2568: END IF;
2569:
2570: WHEN FND_API.G_EXC_ERROR THEN
2571: ROLLBACK TO UPDATE_MR_HEADER_PVT;

Line 2577: AHL_DEBUG_PUB.disable_debug;

2573: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
2574: p_count => x_msg_count,
2575: p_data => X_msg_data);
2576: IF G_DEBUG='Y' THEN
2577: AHL_DEBUG_PUB.disable_debug;
2578: END IF;
2579: WHEN OTHERS THEN
2580: ROLLBACK TO UPDATE_MR_HEADER_PVT;
2581: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2592: AHL_DEBUG_PUB.disable_debug;

2588: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
2589: p_count => x_msg_count,
2590: p_data => X_msg_data);
2591: IF G_DEBUG='Y' THEN
2592: AHL_DEBUG_PUB.disable_debug;
2593: END IF;
2594: END;
2595:
2596: PROCEDURE VALIDATE_DEL_MR_HEADER

Line 2760: AHL_DEBUG_PUB.enable_debug;

2756:
2757: x_return_status:=FND_API.G_RET_STS_SUCCESS;
2758:
2759: IF G_DEBUG='Y' THEN
2760: AHL_DEBUG_PUB.enable_debug;
2761: END IF;
2762:
2763: -- Debug info.
2764: IF G_DEBUG='Y' THEN

Line 2765: AHL_DEBUG_PUB.debug( 'AHL_FMP_MR_HEADERS_PVT.','+DELETE_MR_HEADER+');

2761: END IF;
2762:
2763: -- Debug info.
2764: IF G_DEBUG='Y' THEN
2765: AHL_DEBUG_PUB.debug( 'AHL_FMP_MR_HEADERS_PVT.','+DELETE_MR_HEADER+');
2766: END IF;
2767:
2768: -- IF (p_validation_level = FND_API.G_VALID_LEVEL_FULL )
2769: -- THEN

Line 2930: AHL_DEBUG_PUB.disable_debug;

2926: RAISE FND_API.G_EXC_ERROR;
2927: END IF;
2928:
2929: IF G_DEBUG='Y' THEN
2930: AHL_DEBUG_PUB.disable_debug;
2931: END IF;
2932:
2933: IF FND_API.TO_BOOLEAN(p_commit) THEN
2934: COMMIT;

Line 2944: AHL_DEBUG_PUB.disable_debug;

2940: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
2941: p_count => x_msg_count,
2942: p_data => x_msg_data);
2943: IF G_DEBUG='Y' THEN
2944: AHL_DEBUG_PUB.disable_debug;
2945: END IF;
2946:
2947: WHEN FND_API.G_EXC_ERROR THEN
2948: ROLLBACK TO DELETE_MR_HEADER_PVT;

Line 2954: AHL_DEBUG_PUB.disable_debug;

2950: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
2951: p_count => x_msg_count,
2952: p_data => X_msg_data);
2953: IF G_DEBUG='Y' THEN
2954: AHL_DEBUG_PUB.disable_debug;
2955: END IF;
2956:
2957: WHEN OTHERS THEN
2958: ROLLBACK TO DELETE_MR_HEADER_PVT;

Line 2970: AHL_DEBUG_PUB.disable_debug;

2966: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
2967: p_count => x_msg_count,
2968: p_data => X_msg_data);
2969: IF G_DEBUG='Y' THEN
2970: AHL_DEBUG_PUB.disable_debug;
2971: END IF;
2972:
2973: END DELETE_MR_HEADER;
2974: