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_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.4.12010000.2 2008/12/29 01:01:46 sracha 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 88: AHL_DEBUG_PUB.enable_debug;

84:
85: l_MR_header_rec CurHeaderDet%ROWTYPE;
86: BEGIN
87: IF G_DEBUG='Y' THEN
88: AHL_DEBUG_PUB.enable_debug;
89: END IF;
90:
91: OPEN CurHeaderDet(p_x_mr_header_rec.mr_header_id);
92: FETCH CurHeaderDet INTO l_mr_header_rec;

Line 680: AHL_DEBUG_PUB.enable_debug;

676: l_program_type_code_ind VARCHAR2(1):='N';
677: BEGIN
678:
679: IF G_DEBUG='Y' THEN
680: AHL_DEBUG_PUB.enable_debug;
681: AHL_DEBUG_PUB.debug('Trans TYPE CODE '||p_x_mr_header_rec.TYPE_CODE,'+HEADERS+');
682: END IF;
683:
684: x_return_status:=FND_API.G_RET_STS_SUCCESS;

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

677: BEGIN
678:
679: IF G_DEBUG='Y' THEN
680: AHL_DEBUG_PUB.enable_debug;
681: AHL_DEBUG_PUB.debug('Trans TYPE CODE '||p_x_mr_header_rec.TYPE_CODE,'+HEADERS+');
682: END IF;
683:
684: x_return_status:=FND_API.G_RET_STS_SUCCESS;
685:

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

845:
846: IF nvl(l_title_counter,0)=0
847: THEN
848: IF G_DEBUG='Y' THEN
849: AHL_DEBUG_PUB.debug( 'PRECEDING MR_TITLE COUNTER');
850: END IF;
851: FND_MESSAGE.SET_NAME('AHL','AHL_FMP_MR_PREC_MR_ID_INVALID');
852: FND_MESSAGE.SET_TOKEN('FIELD',p_x_mr_header_rec.PRECEDING_MR_TITLE,false);
853: FND_MSG_PUB.ADD;

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

859:
860: IF get_mr_header%NOTFOUND
861: THEN
862: IF G_DEBUG='Y' THEN
863: AHL_DEBUG_PUB.debug(' Preceding MRHEADER_ID NOT FOUND2','+HEADERS+');
864: END IF;
865: FND_MESSAGE.SET_NAME('AHL','AHL_FMP_MR_PREC_MR_ID_INVALID');
866: FND_MESSAGE.SET_TOKEN('FIELD',p_x_mr_header_rec.PRECEDING_MR_TITLE,false);
867: FND_MSG_PUB.ADD;

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

872: OPEN get_prec_mrheader_info(p_x_mr_header_rec.PRECEDING_MR_HEADER_ID);
873: FETCH get_prec_mrheader_info INTO l_prec_mr_info;
874:
875: IF G_DEBUG='Y' THEN
876: AHL_DEBUG_PUB.debug( 'PRECEDING .. MR>1 '||p_x_mr_header_rec.PRECEDING_MR_HEADER_ID,'+HEADERS+');
877: END IF;
878:
879: IF get_prec_mrheader_info%NOTFOUND
880: THEN

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

878:
879: IF get_prec_mrheader_info%NOTFOUND
880: THEN
881: IF G_DEBUG='Y' THEN
882: AHL_DEBUG_PUB.debug('Preceding mr title err','+HEADERS+');
883: END IF;
884:
885: FND_MESSAGE.SET_NAME('AHL','AHL_FMP_MR_PREC_MR_ID_INVALID');
886: FND_MESSAGE.SET_TOKEN('FIELD',p_x_mr_header_rec.PRECEDING_MR_TITLE,false);

Line 1168: AHL_DEBUG_PUB.enable_debug;

1164: BEGIN
1165: x_return_status:=FND_API.G_RET_STS_SUCCESS;
1166:
1167: IF G_DEBUG='Y' THEN
1168: AHL_DEBUG_PUB.enable_debug;
1169: AHL_DEBUG_PUB.debug('Application Usage code:'||G_APPLN_USAGE);
1170: AHL_DEBUG_PUB.debug('TYPE CODE '||p_mr_header_rec.TYPE_CODE,'+HEADERS+');
1171: END IF;
1172:

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

1165: x_return_status:=FND_API.G_RET_STS_SUCCESS;
1166:
1167: IF G_DEBUG='Y' THEN
1168: AHL_DEBUG_PUB.enable_debug;
1169: AHL_DEBUG_PUB.debug('Application Usage code:'||G_APPLN_USAGE);
1170: AHL_DEBUG_PUB.debug('TYPE CODE '||p_mr_header_rec.TYPE_CODE,'+HEADERS+');
1171: END IF;
1172:
1173: IF G_APPLN_USAGE IS NULL

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

1166:
1167: IF G_DEBUG='Y' THEN
1168: AHL_DEBUG_PUB.enable_debug;
1169: AHL_DEBUG_PUB.debug('Application Usage code:'||G_APPLN_USAGE);
1170: AHL_DEBUG_PUB.debug('TYPE CODE '||p_mr_header_rec.TYPE_CODE,'+HEADERS+');
1171: END IF;
1172:
1173: IF G_APPLN_USAGE IS NULL
1174: THEN

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

1284: IF p_mr_header_rec.QA_INSPECTION_TYPE IS NOT NULL
1285: and p_mr_header_rec.QA_INSPECTION_TYPE <>FND_API.G_MISS_CHAR
1286: THEN
1287: IF G_DEBUG='Y' THEN
1288: AHL_DEBUG_PUB.debug('Error at AHL_FMP_AUTSIGNOFF_QA_INV');
1289: END IF;
1290: FND_MESSAGE.SET_NAME('AHL','AHL_FMP_AUTSIGNOFF_QA_INV');
1291: FND_MSG_PUB.ADD;
1292: END IF;

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

1433: END IF;
1434: -- Super User
1435: IF G_DEBUG='Y'
1436: THEN
1437: AHL_DEBUG_PUB.debug('superusermode is ...:'||l_MR_HEADER_REC.SUPERUSER_ROLE);
1438: AHL_DEBUG_PUB.debug('billing item :'||nvl(l_MR_HEADER_REC.BILLING_ITEM,'X'));
1439: AHL_DEBUG_PUB.debug('billing item :'||nvl(l_REC.BILLING_ITEM,'X'));
1440: AHL_DEBUG_PUB.debug('billing item :'||nvl(p_mr_header_rec.mr_header_id,0));
1441: END IF;

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

1434: -- Super User
1435: IF G_DEBUG='Y'
1436: THEN
1437: AHL_DEBUG_PUB.debug('superusermode is ...:'||l_MR_HEADER_REC.SUPERUSER_ROLE);
1438: AHL_DEBUG_PUB.debug('billing item :'||nvl(l_MR_HEADER_REC.BILLING_ITEM,'X'));
1439: AHL_DEBUG_PUB.debug('billing item :'||nvl(l_REC.BILLING_ITEM,'X'));
1440: AHL_DEBUG_PUB.debug('billing item :'||nvl(p_mr_header_rec.mr_header_id,0));
1441: END IF;
1442: IF l_mr_header_rec.MR_STATUS_CODE='COMPLETE' AND nvl(l_mr_header_rec.SUPERUSER_ROLE,'N')='N'

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

1435: IF G_DEBUG='Y'
1436: THEN
1437: AHL_DEBUG_PUB.debug('superusermode is ...:'||l_MR_HEADER_REC.SUPERUSER_ROLE);
1438: AHL_DEBUG_PUB.debug('billing item :'||nvl(l_MR_HEADER_REC.BILLING_ITEM,'X'));
1439: AHL_DEBUG_PUB.debug('billing item :'||nvl(l_REC.BILLING_ITEM,'X'));
1440: AHL_DEBUG_PUB.debug('billing item :'||nvl(p_mr_header_rec.mr_header_id,0));
1441: END IF;
1442: IF l_mr_header_rec.MR_STATUS_CODE='COMPLETE' AND nvl(l_mr_header_rec.SUPERUSER_ROLE,'N')='N'
1443: THEN

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

1436: THEN
1437: AHL_DEBUG_PUB.debug('superusermode is ...:'||l_MR_HEADER_REC.SUPERUSER_ROLE);
1438: AHL_DEBUG_PUB.debug('billing item :'||nvl(l_MR_HEADER_REC.BILLING_ITEM,'X'));
1439: AHL_DEBUG_PUB.debug('billing item :'||nvl(l_REC.BILLING_ITEM,'X'));
1440: AHL_DEBUG_PUB.debug('billing item :'||nvl(p_mr_header_rec.mr_header_id,0));
1441: END IF;
1442: IF l_mr_header_rec.MR_STATUS_CODE='COMPLETE' AND nvl(l_mr_header_rec.SUPERUSER_ROLE,'N')='N'
1443: THEN
1444: FND_MESSAGE.SET_NAME('AHL','AHL_FMP_MR_INVALID_EDIT');

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

1450: OPEN get_super_non_edit(p_mr_header_rec.MR_HEADER_ID);
1451: FETCH get_super_non_edit INTO l_rec;
1452: IF G_DEBUG='Y'
1453: THEN
1454: AHL_DEBUG_PUB.debug(l_rec.REPETITIVE_FLAG ||'---'||(p_mr_header_rec.REPETITIVE_FLAG));
1455: AHL_DEBUG_PUB.debug(l_rec.SHOW_REPETITIVE_CODE||'---'|| (p_mr_header_rec.SHOW_REPETITIVE_CODE));
1456: AHL_DEBUG_PUB.debug(l_rec.WHICHEVER_FIRST_CODE||'---'|| (p_mr_header_rec.WHICHEVER_FIRST_CODE));
1457: AHL_DEBUG_PUB.debug(l_rec.EFFECTIVE_FROM||'---'||(p_mr_header_rec.EFFECTIVE_FROM));
1458: AHL_DEBUG_PUB.debug(l_rec.BILLING_ITEM_ID||'---'||(p_mr_header_rec.BILLING_ITEM_ID));

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

1451: FETCH get_super_non_edit INTO l_rec;
1452: IF G_DEBUG='Y'
1453: THEN
1454: AHL_DEBUG_PUB.debug(l_rec.REPETITIVE_FLAG ||'---'||(p_mr_header_rec.REPETITIVE_FLAG));
1455: AHL_DEBUG_PUB.debug(l_rec.SHOW_REPETITIVE_CODE||'---'|| (p_mr_header_rec.SHOW_REPETITIVE_CODE));
1456: AHL_DEBUG_PUB.debug(l_rec.WHICHEVER_FIRST_CODE||'---'|| (p_mr_header_rec.WHICHEVER_FIRST_CODE));
1457: AHL_DEBUG_PUB.debug(l_rec.EFFECTIVE_FROM||'---'||(p_mr_header_rec.EFFECTIVE_FROM));
1458: AHL_DEBUG_PUB.debug(l_rec.BILLING_ITEM_ID||'---'||(p_mr_header_rec.BILLING_ITEM_ID));
1459: AHL_DEBUG_PUB.debug(l_rec.BILLING_ITEM);

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

1452: IF G_DEBUG='Y'
1453: THEN
1454: AHL_DEBUG_PUB.debug(l_rec.REPETITIVE_FLAG ||'---'||(p_mr_header_rec.REPETITIVE_FLAG));
1455: AHL_DEBUG_PUB.debug(l_rec.SHOW_REPETITIVE_CODE||'---'|| (p_mr_header_rec.SHOW_REPETITIVE_CODE));
1456: AHL_DEBUG_PUB.debug(l_rec.WHICHEVER_FIRST_CODE||'---'|| (p_mr_header_rec.WHICHEVER_FIRST_CODE));
1457: AHL_DEBUG_PUB.debug(l_rec.EFFECTIVE_FROM||'---'||(p_mr_header_rec.EFFECTIVE_FROM));
1458: AHL_DEBUG_PUB.debug(l_rec.BILLING_ITEM_ID||'---'||(p_mr_header_rec.BILLING_ITEM_ID));
1459: AHL_DEBUG_PUB.debug(l_rec.BILLING_ITEM);
1460: AHL_DEBUG_PUB.debug(l_rec.qa_inspection_type_code||'---'||(p_mr_header_rec.qa_inspection_type_code));

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

1453: THEN
1454: AHL_DEBUG_PUB.debug(l_rec.REPETITIVE_FLAG ||'---'||(p_mr_header_rec.REPETITIVE_FLAG));
1455: AHL_DEBUG_PUB.debug(l_rec.SHOW_REPETITIVE_CODE||'---'|| (p_mr_header_rec.SHOW_REPETITIVE_CODE));
1456: AHL_DEBUG_PUB.debug(l_rec.WHICHEVER_FIRST_CODE||'---'|| (p_mr_header_rec.WHICHEVER_FIRST_CODE));
1457: AHL_DEBUG_PUB.debug(l_rec.EFFECTIVE_FROM||'---'||(p_mr_header_rec.EFFECTIVE_FROM));
1458: AHL_DEBUG_PUB.debug(l_rec.BILLING_ITEM_ID||'---'||(p_mr_header_rec.BILLING_ITEM_ID));
1459: AHL_DEBUG_PUB.debug(l_rec.BILLING_ITEM);
1460: AHL_DEBUG_PUB.debug(l_rec.qa_inspection_type_code||'---'||(p_mr_header_rec.qa_inspection_type_code));
1461: AHL_DEBUG_PUB.debug(l_rec.space_category_code||'---'||(P_mr_header_rec.space_category_code));

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

1454: AHL_DEBUG_PUB.debug(l_rec.REPETITIVE_FLAG ||'---'||(p_mr_header_rec.REPETITIVE_FLAG));
1455: AHL_DEBUG_PUB.debug(l_rec.SHOW_REPETITIVE_CODE||'---'|| (p_mr_header_rec.SHOW_REPETITIVE_CODE));
1456: AHL_DEBUG_PUB.debug(l_rec.WHICHEVER_FIRST_CODE||'---'|| (p_mr_header_rec.WHICHEVER_FIRST_CODE));
1457: AHL_DEBUG_PUB.debug(l_rec.EFFECTIVE_FROM||'---'||(p_mr_header_rec.EFFECTIVE_FROM));
1458: AHL_DEBUG_PUB.debug(l_rec.BILLING_ITEM_ID||'---'||(p_mr_header_rec.BILLING_ITEM_ID));
1459: AHL_DEBUG_PUB.debug(l_rec.BILLING_ITEM);
1460: AHL_DEBUG_PUB.debug(l_rec.qa_inspection_type_code||'---'||(p_mr_header_rec.qa_inspection_type_code));
1461: AHL_DEBUG_PUB.debug(l_rec.space_category_code||'---'||(P_mr_header_rec.space_category_code));
1462: AHL_DEBUG_PUB.debug(l_rec.DOWN_TIME||'---'||(p_mr_header_rec.DOWN_TIME));

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

1455: AHL_DEBUG_PUB.debug(l_rec.SHOW_REPETITIVE_CODE||'---'|| (p_mr_header_rec.SHOW_REPETITIVE_CODE));
1456: AHL_DEBUG_PUB.debug(l_rec.WHICHEVER_FIRST_CODE||'---'|| (p_mr_header_rec.WHICHEVER_FIRST_CODE));
1457: AHL_DEBUG_PUB.debug(l_rec.EFFECTIVE_FROM||'---'||(p_mr_header_rec.EFFECTIVE_FROM));
1458: AHL_DEBUG_PUB.debug(l_rec.BILLING_ITEM_ID||'---'||(p_mr_header_rec.BILLING_ITEM_ID));
1459: AHL_DEBUG_PUB.debug(l_rec.BILLING_ITEM);
1460: AHL_DEBUG_PUB.debug(l_rec.qa_inspection_type_code||'---'||(p_mr_header_rec.qa_inspection_type_code));
1461: AHL_DEBUG_PUB.debug(l_rec.space_category_code||'---'||(P_mr_header_rec.space_category_code));
1462: AHL_DEBUG_PUB.debug(l_rec.DOWN_TIME||'---'||(p_mr_header_rec.DOWN_TIME));
1463: AHL_DEBUG_PUB.debug(l_rec.UOM_CODE||'---'||(p_mr_header_rec.uom_code));

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

1456: AHL_DEBUG_PUB.debug(l_rec.WHICHEVER_FIRST_CODE||'---'|| (p_mr_header_rec.WHICHEVER_FIRST_CODE));
1457: AHL_DEBUG_PUB.debug(l_rec.EFFECTIVE_FROM||'---'||(p_mr_header_rec.EFFECTIVE_FROM));
1458: AHL_DEBUG_PUB.debug(l_rec.BILLING_ITEM_ID||'---'||(p_mr_header_rec.BILLING_ITEM_ID));
1459: AHL_DEBUG_PUB.debug(l_rec.BILLING_ITEM);
1460: AHL_DEBUG_PUB.debug(l_rec.qa_inspection_type_code||'---'||(p_mr_header_rec.qa_inspection_type_code));
1461: AHL_DEBUG_PUB.debug(l_rec.space_category_code||'---'||(P_mr_header_rec.space_category_code));
1462: AHL_DEBUG_PUB.debug(l_rec.DOWN_TIME||'---'||(p_mr_header_rec.DOWN_TIME));
1463: AHL_DEBUG_PUB.debug(l_rec.UOM_CODE||'---'||(p_mr_header_rec.uom_code));
1464: END IF;

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

1457: AHL_DEBUG_PUB.debug(l_rec.EFFECTIVE_FROM||'---'||(p_mr_header_rec.EFFECTIVE_FROM));
1458: AHL_DEBUG_PUB.debug(l_rec.BILLING_ITEM_ID||'---'||(p_mr_header_rec.BILLING_ITEM_ID));
1459: AHL_DEBUG_PUB.debug(l_rec.BILLING_ITEM);
1460: AHL_DEBUG_PUB.debug(l_rec.qa_inspection_type_code||'---'||(p_mr_header_rec.qa_inspection_type_code));
1461: AHL_DEBUG_PUB.debug(l_rec.space_category_code||'---'||(P_mr_header_rec.space_category_code));
1462: AHL_DEBUG_PUB.debug(l_rec.DOWN_TIME||'---'||(p_mr_header_rec.DOWN_TIME));
1463: AHL_DEBUG_PUB.debug(l_rec.UOM_CODE||'---'||(p_mr_header_rec.uom_code));
1464: END IF;
1465:

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

1458: AHL_DEBUG_PUB.debug(l_rec.BILLING_ITEM_ID||'---'||(p_mr_header_rec.BILLING_ITEM_ID));
1459: AHL_DEBUG_PUB.debug(l_rec.BILLING_ITEM);
1460: AHL_DEBUG_PUB.debug(l_rec.qa_inspection_type_code||'---'||(p_mr_header_rec.qa_inspection_type_code));
1461: AHL_DEBUG_PUB.debug(l_rec.space_category_code||'---'||(P_mr_header_rec.space_category_code));
1462: AHL_DEBUG_PUB.debug(l_rec.DOWN_TIME||'---'||(p_mr_header_rec.DOWN_TIME));
1463: AHL_DEBUG_PUB.debug(l_rec.UOM_CODE||'---'||(p_mr_header_rec.uom_code));
1464: END IF;
1465:
1466: IF nvl(l_rec.REPETITIVE_FLAG,'X') <> nvl(p_mr_header_rec.REPETITIVE_FLAG,'X')

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

1459: AHL_DEBUG_PUB.debug(l_rec.BILLING_ITEM);
1460: AHL_DEBUG_PUB.debug(l_rec.qa_inspection_type_code||'---'||(p_mr_header_rec.qa_inspection_type_code));
1461: AHL_DEBUG_PUB.debug(l_rec.space_category_code||'---'||(P_mr_header_rec.space_category_code));
1462: AHL_DEBUG_PUB.debug(l_rec.DOWN_TIME||'---'||(p_mr_header_rec.DOWN_TIME));
1463: AHL_DEBUG_PUB.debug(l_rec.UOM_CODE||'---'||(p_mr_header_rec.uom_code));
1464: END IF;
1465:
1466: IF nvl(l_rec.REPETITIVE_FLAG,'X') <> nvl(p_mr_header_rec.REPETITIVE_FLAG,'X')
1467: or nvl(l_rec.SHOW_REPETITIVE_CODE,'X')<> nvl(p_mr_header_rec.SHOW_REPETITIVE_CODE,'X')

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

1474: or nvl(l_rec.UOM_CODE,'X')<>nvl(p_mr_header_rec.uom_code,'X')
1475: THEN
1476: FND_MESSAGE.SET_NAME('AHL','AHL_FMP_MR_SUPER_NONEDIT_COLS');
1477: FND_MSG_PUB.ADD;
1478: AHL_DEBUG_PUB.debug('SUPERUSER NONEDIT:'||L_MR_HEADER_REC.SUPERUSER_ROLE);
1479: l_check_flag:='N';
1480: END IF;
1481: CLOSE get_super_non_edit;
1482: END IF;

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

1545: END IF;
1546:
1547: IF p_mr_header_rec.DML_OPERATION='U'
1548: THEN
1549: AHL_DEBUG_PUB.debug('Error.Before calling validate mr_type :'||L_MR_HEADER_REC.SUPERUSER_ROLE);
1550: VALIDATE_MR_TYPE
1551: (
1552: x_return_status =>x_return_Status,
1553: p_mr_header_rec =>l_mr_header_rec

Line 1794: AHL_DEBUG_PUB.enable_debug;

1790: x_return_status:=FND_API.G_RET_STS_SUCCESS;
1791:
1792:
1793: IF G_DEBUG='Y' THEN
1794: AHL_DEBUG_PUB.enable_debug;
1795: END IF;
1796:
1797:
1798: IF p_module_type = 'JSP' THEN

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

1803: p_x_mr_header_rec.PROGRAM_TYPE_CODE:=NULL;
1804: p_x_mr_header_rec.PROGRAM_SUBTYPE_CODE:=NULL;
1805: p_x_mr_header_rec.PRECEDING_MR_HEADER_ID:=NULL;
1806: END IF;
1807: AHL_DEBUG_PUB.debug('p_x_mr_header_rec.billing_item_id :'||p_x_mr_header_rec.billing_item_id);
1808: -- Debug info.
1809:
1810: IF G_DEBUG='Y' THEN
1811: AHL_DEBUG_PUB.debug( 'AHL_FMP_MR_HEADERS_PVT.','+CREATE_MR_HEADER+');

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

1807: AHL_DEBUG_PUB.debug('p_x_mr_header_rec.billing_item_id :'||p_x_mr_header_rec.billing_item_id);
1808: -- Debug info.
1809:
1810: IF G_DEBUG='Y' THEN
1811: AHL_DEBUG_PUB.debug( 'AHL_FMP_MR_HEADERS_PVT.','+CREATE_MR_HEADER+');
1812: END IF;
1813:
1814: IF FND_API.to_boolean(p_default)
1815: THEN

Line 1938: AHL_DEBUG_PUB.disable_debug;

1934: COMMIT;
1935: END IF;
1936:
1937: IF G_DEBUG='Y' THEN
1938: AHL_DEBUG_PUB.disable_debug;
1939: END IF;
1940:
1941: EXCEPTION
1942: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1949: AHL_DEBUG_PUB.disable_debug;

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: IF G_DEBUG='Y' THEN
1949: AHL_DEBUG_PUB.disable_debug;
1950: END IF;
1951: WHEN FND_API.G_EXC_ERROR THEN
1952: ROLLBACK TO CREATE_MR_HEADER_PVT;
1953: X_return_status := FND_API.G_RET_STS_ERROR;

Line 1958: AHL_DEBUG_PUB.disable_debug;

1954: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
1955: p_count => x_msg_count,
1956: p_data => X_msg_data);
1957: IF G_DEBUG='Y' THEN
1958: AHL_DEBUG_PUB.disable_debug;
1959: END IF;
1960:
1961: WHEN OTHERS THEN
1962: ROLLBACK TO CREATE_MR_HEADER_PVT;

Line 1975: AHL_DEBUG_PUB.disable_debug;

1971: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
1972: p_count => x_msg_count,
1973: p_data => X_msg_data);
1974: IF G_DEBUG='Y' THEN
1975: AHL_DEBUG_PUB.disable_debug;
1976: END IF;
1977: END;
1978:
1979:

Line 2018: AHL_DEBUG_PUB.enable_debug;

2014:
2015: x_return_status:=FND_API.G_RET_STS_SUCCESS;
2016:
2017: IF G_DEBUG='Y' THEN
2018: AHL_DEBUG_PUB.enable_debug;
2019: AHL_DEBUG_PUB.debug('Service Category CODE:'||p_x_mr_header_Rec.SPACE_CATEGORY_CODE);
2020: AHL_DEBUG_PUB.debug('Service Category MEANING :'||p_x_mr_header_Rec.SPACE_CATEGORY);
2021: END IF;
2022: --11.5.10 public API change.

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

2015: x_return_status:=FND_API.G_RET_STS_SUCCESS;
2016:
2017: IF G_DEBUG='Y' THEN
2018: AHL_DEBUG_PUB.enable_debug;
2019: AHL_DEBUG_PUB.debug('Service Category CODE:'||p_x_mr_header_Rec.SPACE_CATEGORY_CODE);
2020: AHL_DEBUG_PUB.debug('Service Category MEANING :'||p_x_mr_header_Rec.SPACE_CATEGORY);
2021: END IF;
2022: --11.5.10 public API change.
2023: IF p_x_mr_header_rec.mr_header_id IS NULL THEN

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

2016:
2017: IF G_DEBUG='Y' THEN
2018: AHL_DEBUG_PUB.enable_debug;
2019: AHL_DEBUG_PUB.debug('Service Category CODE:'||p_x_mr_header_Rec.SPACE_CATEGORY_CODE);
2020: AHL_DEBUG_PUB.debug('Service Category MEANING :'||p_x_mr_header_Rec.SPACE_CATEGORY);
2021: END IF;
2022: --11.5.10 public API change.
2023: IF p_x_mr_header_rec.mr_header_id IS NULL THEN
2024: -- Function to convert mr_title,mr_version_number to id

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

2202: COMMIT;
2203: END IF;
2204: -- Debug info
2205:
2206: -- AHL_DEBUG_PUB.debug( 'End of Private api UPDATE_MR_HEADER','+MR_header+');
2207:
2208: -- Check if API is called in debug mode. If yes, disable debug.
2209:
2210: IF G_DEBUG='Y' THEN

Line 2211: AHL_DEBUG_PUB.disable_debug;

2207:
2208: -- Check if API is called in debug mode. If yes, disable debug.
2209:
2210: IF G_DEBUG='Y' THEN
2211: AHL_DEBUG_PUB.disable_debug;
2212: END IF;
2213:
2214: EXCEPTION
2215:

Line 2223: AHL_DEBUG_PUB.disable_debug;

2219: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
2220: p_count => x_msg_count,
2221: p_data => x_msg_data);
2222: IF G_DEBUG='Y' THEN
2223: AHL_DEBUG_PUB.disable_debug;
2224: END IF;
2225:
2226: WHEN FND_API.G_EXC_ERROR THEN
2227: ROLLBACK TO UPDATE_MR_HEADER_PVT;

Line 2233: AHL_DEBUG_PUB.disable_debug;

2229: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
2230: p_count => x_msg_count,
2231: p_data => X_msg_data);
2232: IF G_DEBUG='Y' THEN
2233: AHL_DEBUG_PUB.disable_debug;
2234: END IF;
2235: WHEN OTHERS THEN
2236: ROLLBACK TO UPDATE_MR_HEADER_PVT;
2237: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2248: AHL_DEBUG_PUB.disable_debug;

2244: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
2245: p_count => x_msg_count,
2246: p_data => X_msg_data);
2247: IF G_DEBUG='Y' THEN
2248: AHL_DEBUG_PUB.disable_debug;
2249: END IF;
2250: END;
2251:
2252: PROCEDURE VALIDATE_DEL_MR_HEADER

Line 2389: AHL_DEBUG_PUB.enable_debug;

2385:
2386: x_return_status:=FND_API.G_RET_STS_SUCCESS;
2387:
2388: IF G_DEBUG='Y' THEN
2389: AHL_DEBUG_PUB.enable_debug;
2390: END IF;
2391:
2392: -- Debug info.
2393: IF G_DEBUG='Y' THEN

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

2390: END IF;
2391:
2392: -- Debug info.
2393: IF G_DEBUG='Y' THEN
2394: AHL_DEBUG_PUB.debug( 'AHL_FMP_MR_HEADERS_PVT.','+DELETE_MR_HEADER+');
2395: END IF;
2396:
2397: -- IF (p_validation_level = FND_API.G_VALID_LEVEL_FULL )
2398: -- THEN

Line 2494: AHL_DEBUG_PUB.disable_debug;

2490: RAISE FND_API.G_EXC_ERROR;
2491: END IF;
2492:
2493: IF G_DEBUG='Y' THEN
2494: AHL_DEBUG_PUB.disable_debug;
2495: END IF;
2496:
2497: IF FND_API.TO_BOOLEAN(p_commit) THEN
2498: COMMIT;

Line 2508: AHL_DEBUG_PUB.disable_debug;

2504: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
2505: p_count => x_msg_count,
2506: p_data => x_msg_data);
2507: IF G_DEBUG='Y' THEN
2508: AHL_DEBUG_PUB.disable_debug;
2509: END IF;
2510:
2511: WHEN FND_API.G_EXC_ERROR THEN
2512: ROLLBACK TO DELETE_MR_HEADER_PVT;

Line 2518: AHL_DEBUG_PUB.disable_debug;

2514: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
2515: p_count => x_msg_count,
2516: p_data => X_msg_data);
2517: IF G_DEBUG='Y' THEN
2518: AHL_DEBUG_PUB.disable_debug;
2519: END IF;
2520:
2521: WHEN OTHERS THEN
2522: ROLLBACK TO DELETE_MR_HEADER_PVT;

Line 2534: AHL_DEBUG_PUB.disable_debug;

2530: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
2531: p_count => x_msg_count,
2532: p_data => X_msg_data);
2533: IF G_DEBUG='Y' THEN
2534: AHL_DEBUG_PUB.disable_debug;
2535: END IF;
2536:
2537: END DELETE_MR_HEADER;
2538: