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_PP_MATERIALS_PVT dependencies on AHL_DEBUG_PUB

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

4: -----------------------
5: -- Declare Constants --
6: -----------------------
7: G_PKG_NAME VARCHAR2(30) := 'AHL_PP_MATERIALS_PVT';
8: G_DEBUG VARCHAR2(1) := AHL_DEBUG_PUB.is_log_enabled;
9: -------------------------------------------------
10: -- Declare Locally used Record and Table Types --
11: -------------------------------------------------
12: ------------------------------

Line 241: AHL_DEBUG_PUB.debug( 'XVISITTASK:'|| x_visit_task_id);

237: WHERE workorder_id = p_workorder_id;
238: END IF;
239: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
240: IF G_DEBUG='Y' THEN
241: AHL_DEBUG_PUB.debug( 'XVISITTASK:'|| x_visit_task_id);
242: END IF;
243: EXCEPTION
244: WHEN NO_DATA_FOUND THEN
245: x_return_status:= Fnd_Api.G_RET_STS_ERROR;

Line 278: AHL_DEBUG_PUB.debug( 'XWOID:'|| x_workorder_id);

274: WHERE workorder_name = p_job_number;
275: END IF;
276: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
277: IF G_DEBUG='Y' THEN
278: AHL_DEBUG_PUB.debug( 'XWOID:'|| x_workorder_id);
279: END IF;
280: EXCEPTION
281: WHEN NO_DATA_FOUND THEN
282: x_return_status:= Fnd_Api.G_RET_STS_ERROR;

Line 1420: AHL_DEBUG_PUB.enable_debug;

1416: -- Standard Start of API savepoint
1417: SAVEPOINT create_material_reqst;
1418: -- Check if API is called in debug mode. If yes, enable debug.
1419: IF G_DEBUG='Y' THEN
1420: AHL_DEBUG_PUB.enable_debug;
1421: END IF;
1422: -- Debug info.
1423: IF G_DEBUG='Y' THEN
1424: AHL_DEBUG_PUB.debug( 'enter ahl_pp_materias_pvt. create material reqst','+PPMRP+');

Line 1424: AHL_DEBUG_PUB.debug( 'enter ahl_pp_materias_pvt. create material reqst','+PPMRP+');

1420: AHL_DEBUG_PUB.enable_debug;
1421: END IF;
1422: -- Debug info.
1423: IF G_DEBUG='Y' THEN
1424: AHL_DEBUG_PUB.debug( 'enter ahl_pp_materias_pvt. create material reqst','+PPMRP+');
1425: AHL_DEBUG_PUB.debug( 'INTERAFCE FALG'||p_interface_flag);
1426: AHL_DEBUG_PUB.debug( 'Total Number Records:'||p_x_req_material_tbl.COUNT);
1427: END IF;
1428: -- Standard call to check for call compatibility.

Line 1425: AHL_DEBUG_PUB.debug( 'INTERAFCE FALG'||p_interface_flag);

1421: END IF;
1422: -- Debug info.
1423: IF G_DEBUG='Y' THEN
1424: AHL_DEBUG_PUB.debug( 'enter ahl_pp_materias_pvt. create material reqst','+PPMRP+');
1425: AHL_DEBUG_PUB.debug( 'INTERAFCE FALG'||p_interface_flag);
1426: AHL_DEBUG_PUB.debug( 'Total Number Records:'||p_x_req_material_tbl.COUNT);
1427: END IF;
1428: -- Standard call to check for call compatibility.
1429: IF FND_API.to_boolean(l_init_msg_list)

Line 1426: AHL_DEBUG_PUB.debug( 'Total Number Records:'||p_x_req_material_tbl.COUNT);

1422: -- Debug info.
1423: IF G_DEBUG='Y' THEN
1424: AHL_DEBUG_PUB.debug( 'enter ahl_pp_materias_pvt. create material reqst','+PPMRP+');
1425: AHL_DEBUG_PUB.debug( 'INTERAFCE FALG'||p_interface_flag);
1426: AHL_DEBUG_PUB.debug( 'Total Number Records:'||p_x_req_material_tbl.COUNT);
1427: END IF;
1428: -- Standard call to check for call compatibility.
1429: IF FND_API.to_boolean(l_init_msg_list)
1430: THEN

Line 1448: AHL_DEBUG_PUB.debug( 'WOID 1:'||p_x_req_material_tbl(i).workorder_id);

1444: FOR i IN p_x_req_material_tbl.FIRST..p_x_req_material_tbl.LAST
1445: LOOP
1446: -- Value to ID Conversion
1447: IF G_DEBUG='Y' THEN
1448: AHL_DEBUG_PUB.debug( 'WOID 1:'||p_x_req_material_tbl(i).workorder_id);
1449: AHL_DEBUG_PUB.debug( 'OPFLAG 1:'||p_x_req_material_tbl(i).operation_flag);
1450: AHL_DEBUG_PUB.debug( 'ITEM:'||i||'-'||p_x_req_material_tbl(i).concatenated_segments);
1451: END IF;
1452: IF ( ( p_x_req_material_tbl(i).workorder_id IS NOT NULL AND

Line 1449: AHL_DEBUG_PUB.debug( 'OPFLAG 1:'||p_x_req_material_tbl(i).operation_flag);

1445: LOOP
1446: -- Value to ID Conversion
1447: IF G_DEBUG='Y' THEN
1448: AHL_DEBUG_PUB.debug( 'WOID 1:'||p_x_req_material_tbl(i).workorder_id);
1449: AHL_DEBUG_PUB.debug( 'OPFLAG 1:'||p_x_req_material_tbl(i).operation_flag);
1450: AHL_DEBUG_PUB.debug( 'ITEM:'||i||'-'||p_x_req_material_tbl(i).concatenated_segments);
1451: END IF;
1452: IF ( ( p_x_req_material_tbl(i).workorder_id IS NOT NULL AND
1453: p_x_req_material_tbl(i).workorder_id <> FND_API.G_MISS_NUM ) OR

Line 1450: AHL_DEBUG_PUB.debug( 'ITEM:'||i||'-'||p_x_req_material_tbl(i).concatenated_segments);

1446: -- Value to ID Conversion
1447: IF G_DEBUG='Y' THEN
1448: AHL_DEBUG_PUB.debug( 'WOID 1:'||p_x_req_material_tbl(i).workorder_id);
1449: AHL_DEBUG_PUB.debug( 'OPFLAG 1:'||p_x_req_material_tbl(i).operation_flag);
1450: AHL_DEBUG_PUB.debug( 'ITEM:'||i||'-'||p_x_req_material_tbl(i).concatenated_segments);
1451: END IF;
1452: IF ( ( p_x_req_material_tbl(i).workorder_id IS NOT NULL AND
1453: p_x_req_material_tbl(i).workorder_id <> FND_API.G_MISS_NUM ) OR
1454: ( p_x_req_material_tbl(i).job_number IS NOT NULL AND

Line 1459: AHL_DEBUG_PUB.debug( 'WOID 2:'||p_x_req_material_tbl(i).workorder_id);

1455: p_x_req_material_tbl(i).job_number <> FND_API.G_MISS_CHAR ) )
1456: THEN
1457: --
1458: IF G_DEBUG='Y' THEN
1459: AHL_DEBUG_PUB.debug( 'WOID 2:'||p_x_req_material_tbl(i).workorder_id);
1460: END IF;
1461: --
1462: Get_workorder_id
1463: (p_workorder_id => p_x_req_material_tbl(i).workorder_id,

Line 1516: AHL_DEBUG_PUB.debug( 'VTID'||p_x_req_material_tbl(i).visit_task_id);

1512: END IF;
1513: -- Assign
1514: p_x_req_material_tbl(i).visit_task_id := l_visit_task_id;
1515: IF G_DEBUG='Y' THEN
1516: AHL_DEBUG_PUB.debug( 'VTID'||p_x_req_material_tbl(i).visit_task_id);
1517: AHL_DEBUG_PUB.debug( 'Job Number:'||p_x_req_material_tbl(i).job_number);
1518: END IF;
1519: -- Validate for organization,department,project_task_id
1520: Get_visit_task_details

Line 1517: AHL_DEBUG_PUB.debug( 'Job Number:'||p_x_req_material_tbl(i).job_number);

1513: -- Assign
1514: p_x_req_material_tbl(i).visit_task_id := l_visit_task_id;
1515: IF G_DEBUG='Y' THEN
1516: AHL_DEBUG_PUB.debug( 'VTID'||p_x_req_material_tbl(i).visit_task_id);
1517: AHL_DEBUG_PUB.debug( 'Job Number:'||p_x_req_material_tbl(i).job_number);
1518: END IF;
1519: -- Validate for organization,department,project_task_id
1520: Get_visit_task_details
1521: ( p_visit_task_id => l_visit_task_id,

Line 1583: AHL_DEBUG_PUB.debug( 'ORID'||p_x_req_material_tbl(i).organization_id);

1579: p_x_req_material_tbl(i).project_task_id := l_project_task_id;
1580: p_x_req_material_tbl(i).project_id := l_project_id;
1581: --
1582: IF G_DEBUG='Y' THEN
1583: AHL_DEBUG_PUB.debug( 'ORID'||p_x_req_material_tbl(i).organization_id);
1584: AHL_DEBUG_PUB.debug( 'DEID'||p_x_req_material_tbl(i).department_id);
1585: AHL_DEBUG_PUB.debug( 'PTID'||p_x_req_material_tbl(i).project_task_id);
1586: AHL_DEBUG_PUB.debug( 'PJID'||p_x_req_material_tbl(i).project_id);
1587: AHL_DEBUG_PUB.debug( 'CITEM:'||p_x_req_material_tbl(i).concatenated_segments);

Line 1584: AHL_DEBUG_PUB.debug( 'DEID'||p_x_req_material_tbl(i).department_id);

1580: p_x_req_material_tbl(i).project_id := l_project_id;
1581: --
1582: IF G_DEBUG='Y' THEN
1583: AHL_DEBUG_PUB.debug( 'ORID'||p_x_req_material_tbl(i).organization_id);
1584: AHL_DEBUG_PUB.debug( 'DEID'||p_x_req_material_tbl(i).department_id);
1585: AHL_DEBUG_PUB.debug( 'PTID'||p_x_req_material_tbl(i).project_task_id);
1586: AHL_DEBUG_PUB.debug( 'PJID'||p_x_req_material_tbl(i).project_id);
1587: AHL_DEBUG_PUB.debug( 'CITEM:'||p_x_req_material_tbl(i).concatenated_segments);
1588: END IF;

Line 1585: AHL_DEBUG_PUB.debug( 'PTID'||p_x_req_material_tbl(i).project_task_id);

1581: --
1582: IF G_DEBUG='Y' THEN
1583: AHL_DEBUG_PUB.debug( 'ORID'||p_x_req_material_tbl(i).organization_id);
1584: AHL_DEBUG_PUB.debug( 'DEID'||p_x_req_material_tbl(i).department_id);
1585: AHL_DEBUG_PUB.debug( 'PTID'||p_x_req_material_tbl(i).project_task_id);
1586: AHL_DEBUG_PUB.debug( 'PJID'||p_x_req_material_tbl(i).project_id);
1587: AHL_DEBUG_PUB.debug( 'CITEM:'||p_x_req_material_tbl(i).concatenated_segments);
1588: END IF;
1589: --sukhwsin: Code Changes for SB Effectivity - starts

Line 1586: AHL_DEBUG_PUB.debug( 'PJID'||p_x_req_material_tbl(i).project_id);

1582: IF G_DEBUG='Y' THEN
1583: AHL_DEBUG_PUB.debug( 'ORID'||p_x_req_material_tbl(i).organization_id);
1584: AHL_DEBUG_PUB.debug( 'DEID'||p_x_req_material_tbl(i).department_id);
1585: AHL_DEBUG_PUB.debug( 'PTID'||p_x_req_material_tbl(i).project_task_id);
1586: AHL_DEBUG_PUB.debug( 'PJID'||p_x_req_material_tbl(i).project_id);
1587: AHL_DEBUG_PUB.debug( 'CITEM:'||p_x_req_material_tbl(i).concatenated_segments);
1588: END IF;
1589: --sukhwsin: Code Changes for SB Effectivity - starts
1590: --Assign null to relationship_id

Line 1587: AHL_DEBUG_PUB.debug( 'CITEM:'||p_x_req_material_tbl(i).concatenated_segments);

1583: AHL_DEBUG_PUB.debug( 'ORID'||p_x_req_material_tbl(i).organization_id);
1584: AHL_DEBUG_PUB.debug( 'DEID'||p_x_req_material_tbl(i).department_id);
1585: AHL_DEBUG_PUB.debug( 'PTID'||p_x_req_material_tbl(i).project_task_id);
1586: AHL_DEBUG_PUB.debug( 'PJID'||p_x_req_material_tbl(i).project_id);
1587: AHL_DEBUG_PUB.debug( 'CITEM:'||p_x_req_material_tbl(i).concatenated_segments);
1588: END IF;
1589: --sukhwsin: Code Changes for SB Effectivity - starts
1590: --Assign null to relationship_id
1591: l_relationship_tbl(i) := null;

Line 1769: AHL_DEBUG_PUB.debug( 'IVID'||p_x_req_material_tbl(i).requested_quantity);

1765: );
1766: END IF;
1767: --sukhwsin: Code Changes for SB Effectivity - ends
1768: IF G_DEBUG='Y' THEN
1769: AHL_DEBUG_PUB.debug( 'IVID'||p_x_req_material_tbl(i).requested_quantity);
1770: END IF;
1771: -- Validate for Requested Quantity
1772: IF (p_x_req_material_tbl(i).requested_quantity IS NULL OR
1773: p_x_req_material_tbl(i).requested_quantity = FND_API.G_MISS_NUM ) THEN

Line 1788: AHL_DEBUG_PUB.debug('Scheduled Quantity: ' || p_x_req_material_tbl(i).scheduled_quantity);

1784: --
1785:
1786: -- MANESING::NR Analysis, 03-Jun-2011, Validate for Scheduled Quantity
1787: IF ( G_DEBUG = 'Y' ) THEN
1788: AHL_DEBUG_PUB.debug('Scheduled Quantity: ' || p_x_req_material_tbl(i).scheduled_quantity);
1789: END IF;
1790:
1791: IF ( p_x_req_material_tbl(i).scheduled_quantity IS NOT NULL AND
1792: p_x_req_material_tbl(i).scheduled_quantity <> FND_API.G_MISS_NUM ) THEN

Line 1802: AHL_DEBUG_PUB.debug( 'RDATE1:'||p_x_req_material_tbl(i).requested_date);

1798:
1799: END IF;
1800:
1801: IF G_DEBUG='Y' THEN
1802: AHL_DEBUG_PUB.debug( 'RDATE1:'||p_x_req_material_tbl(i).requested_date);
1803: END IF;
1804: --
1805: -- bug 14137417 :: added module type condition by tchimira
1806: -- following validation should not occur for VWP flows

Line 1823: AHL_DEBUG_PUB.debug( 'RDATE'||p_x_req_material_tbl(i).requested_date);

1819: END IF;
1820: END IF;
1821: --
1822: IF G_DEBUG='Y' THEN
1823: AHL_DEBUG_PUB.debug( 'RDATE'||p_x_req_material_tbl(i).requested_date);
1824: AHL_DEBUG_PUB.debug( 'OSID'||p_x_req_material_tbl(i).operation_sequence);
1825: END IF;
1826: --Check for operation sequence
1827: IF( p_x_req_material_tbl(i).operation_sequence IS NULL OR

Line 1824: AHL_DEBUG_PUB.debug( 'OSID'||p_x_req_material_tbl(i).operation_sequence);

1820: END IF;
1821: --
1822: IF G_DEBUG='Y' THEN
1823: AHL_DEBUG_PUB.debug( 'RDATE'||p_x_req_material_tbl(i).requested_date);
1824: AHL_DEBUG_PUB.debug( 'OSID'||p_x_req_material_tbl(i).operation_sequence);
1825: END IF;
1826: --Check for operation sequence
1827: IF( p_x_req_material_tbl(i).operation_sequence IS NULL OR
1828: p_x_req_material_tbl(i).operation_sequence = FND_API.G_MISS_NUM)

Line 1849: AHL_DEBUG_PUB.debug('OPID'||p_x_req_material_tbl(i).workorder_operation_id);

1845: -- dbms_output.put_line( 'after fetch:'||p_x_req_material_tbl(i).workorder_operation_id);
1846: -- dbms_output.put_line( 'interface flag:'||p_interface_flag);
1847: -- Check for workorder operation ID
1848: IF G_DEBUG='Y' THEN
1849: AHL_DEBUG_PUB.debug('OPID'||p_x_req_material_tbl(i).workorder_operation_id);
1850: END IF;
1851: --
1852: IF (p_x_req_material_tbl(i).workorder_operation_id IS NULL OR
1853: p_x_req_material_tbl(i).workorder_operation_id = FND_API.G_MISS_NUM)

Line 1918: AHL_DEBUG_PUB.debug('Local OPID:'||l_workorder_operation_id);

1914: --
1915: END IF;
1916: */
1917: IF G_DEBUG='Y' THEN
1918: AHL_DEBUG_PUB.debug('Local OPID:'||l_workorder_operation_id);
1919: AHL_DEBUG_PUB.debug('OPID2 :'||p_x_req_material_tbl(i).workorder_operation_id);
1920: END IF;
1921: --Check for operation sequence
1922: -- dbms_output.put_line( 'before uinque check:'||p_x_req_material_tbl(i).inventory_item_id);

Line 1919: AHL_DEBUG_PUB.debug('OPID2 :'||p_x_req_material_tbl(i).workorder_operation_id);

1915: END IF;
1916: */
1917: IF G_DEBUG='Y' THEN
1918: AHL_DEBUG_PUB.debug('Local OPID:'||l_workorder_operation_id);
1919: AHL_DEBUG_PUB.debug('OPID2 :'||p_x_req_material_tbl(i).workorder_operation_id);
1920: END IF;
1921: --Check for operation sequence
1922: -- dbms_output.put_line( 'before uinque check:'||p_x_req_material_tbl(i).inventory_item_id);
1923: -- dbms_output.put_line( 'before unique check:'||p_x_req_material_tbl(i).organization_id);

Line 1985: -- AHL_DEBUG_PUB.debug('after interface flag yes or null call:'||p_x_req_material_tbl(1).workorder_id);

1981: IF (p_interface_flag = 'Y' OR p_interface_flag IS NULL )THEN
1982: --
1983: -- dbms_output.put_line( 'inside:'||p_interface_flag);
1984: -- IF G_DEBUG='Y' THEN
1985: -- AHL_DEBUG_PUB.debug('after interface flag yes or null call:'||p_x_req_material_tbl(1).workorder_id);
1986: -- END IF;
1987: --
1988: -- dbms_output.put_line( 'inside:'||p_interface_flag);
1989: IF p_x_req_material_tbl.COUNT >0

Line 2029: AHL_DEBUG_PUB.debug('Before Eam job pvt.InentoryItemID:'||l_req_material_tbl(j).INVENTORY_ITEM_ID);

2025: -- sracha: Fix for FP bug# 6802777.
2026: l_req_material_tbl(j).DEPARTMENT_ID := p_x_req_material_tbl(i).department_id;
2027: --
2028: IF G_DEBUG='Y' THEN
2029: AHL_DEBUG_PUB.debug('Before Eam job pvt.InentoryItemID:'||l_req_material_tbl(j).INVENTORY_ITEM_ID);
2030: AHL_DEBUG_PUB.debug('Before Eam job pvt.Quantity:'||l_req_material_tbl(j).REQUESTED_QUANTITY);
2031: AHL_DEBUG_PUB.debug('Before Eam job pvt.Uom:'||l_req_material_tbl(j).UOM_CODE);
2032: AHL_DEBUG_PUB.debug('Before Eam job pvt.WorkorderID:'||l_req_material_tbl(j).WORKORDER_ID);
2033: AHL_DEBUG_PUB.debug('Before Eam job pvt.WipentityID:'||l_req_material_tbl(j).WIP_ENTITY_ID);

Line 2030: AHL_DEBUG_PUB.debug('Before Eam job pvt.Quantity:'||l_req_material_tbl(j).REQUESTED_QUANTITY);

2026: l_req_material_tbl(j).DEPARTMENT_ID := p_x_req_material_tbl(i).department_id;
2027: --
2028: IF G_DEBUG='Y' THEN
2029: AHL_DEBUG_PUB.debug('Before Eam job pvt.InentoryItemID:'||l_req_material_tbl(j).INVENTORY_ITEM_ID);
2030: AHL_DEBUG_PUB.debug('Before Eam job pvt.Quantity:'||l_req_material_tbl(j).REQUESTED_QUANTITY);
2031: AHL_DEBUG_PUB.debug('Before Eam job pvt.Uom:'||l_req_material_tbl(j).UOM_CODE);
2032: AHL_DEBUG_PUB.debug('Before Eam job pvt.WorkorderID:'||l_req_material_tbl(j).WORKORDER_ID);
2033: AHL_DEBUG_PUB.debug('Before Eam job pvt.WipentityID:'||l_req_material_tbl(j).WIP_ENTITY_ID);
2034: AHL_DEBUG_PUB.debug('Before Eam job pvt.OrganizationID:'||l_req_material_tbl(j).ORGANIZATION_ID);

Line 2031: AHL_DEBUG_PUB.debug('Before Eam job pvt.Uom:'||l_req_material_tbl(j).UOM_CODE);

2027: --
2028: IF G_DEBUG='Y' THEN
2029: AHL_DEBUG_PUB.debug('Before Eam job pvt.InentoryItemID:'||l_req_material_tbl(j).INVENTORY_ITEM_ID);
2030: AHL_DEBUG_PUB.debug('Before Eam job pvt.Quantity:'||l_req_material_tbl(j).REQUESTED_QUANTITY);
2031: AHL_DEBUG_PUB.debug('Before Eam job pvt.Uom:'||l_req_material_tbl(j).UOM_CODE);
2032: AHL_DEBUG_PUB.debug('Before Eam job pvt.WorkorderID:'||l_req_material_tbl(j).WORKORDER_ID);
2033: AHL_DEBUG_PUB.debug('Before Eam job pvt.WipentityID:'||l_req_material_tbl(j).WIP_ENTITY_ID);
2034: AHL_DEBUG_PUB.debug('Before Eam job pvt.OrganizationID:'||l_req_material_tbl(j).ORGANIZATION_ID);
2035: AHL_DEBUG_PUB.debug('Before Eam job pvt.Jobmumber:'||l_req_material_tbl(j).JOB_NUMBER);

Line 2032: AHL_DEBUG_PUB.debug('Before Eam job pvt.WorkorderID:'||l_req_material_tbl(j).WORKORDER_ID);

2028: IF G_DEBUG='Y' THEN
2029: AHL_DEBUG_PUB.debug('Before Eam job pvt.InentoryItemID:'||l_req_material_tbl(j).INVENTORY_ITEM_ID);
2030: AHL_DEBUG_PUB.debug('Before Eam job pvt.Quantity:'||l_req_material_tbl(j).REQUESTED_QUANTITY);
2031: AHL_DEBUG_PUB.debug('Before Eam job pvt.Uom:'||l_req_material_tbl(j).UOM_CODE);
2032: AHL_DEBUG_PUB.debug('Before Eam job pvt.WorkorderID:'||l_req_material_tbl(j).WORKORDER_ID);
2033: AHL_DEBUG_PUB.debug('Before Eam job pvt.WipentityID:'||l_req_material_tbl(j).WIP_ENTITY_ID);
2034: AHL_DEBUG_PUB.debug('Before Eam job pvt.OrganizationID:'||l_req_material_tbl(j).ORGANIZATION_ID);
2035: AHL_DEBUG_PUB.debug('Before Eam job pvt.Jobmumber:'||l_req_material_tbl(j).JOB_NUMBER);
2036: AHL_DEBUG_PUB.debug('Before Eam job pvt.OperationSequence:'||l_req_material_tbl(j).OPERATION_SEQUENCE);

Line 2033: AHL_DEBUG_PUB.debug('Before Eam job pvt.WipentityID:'||l_req_material_tbl(j).WIP_ENTITY_ID);

2029: AHL_DEBUG_PUB.debug('Before Eam job pvt.InentoryItemID:'||l_req_material_tbl(j).INVENTORY_ITEM_ID);
2030: AHL_DEBUG_PUB.debug('Before Eam job pvt.Quantity:'||l_req_material_tbl(j).REQUESTED_QUANTITY);
2031: AHL_DEBUG_PUB.debug('Before Eam job pvt.Uom:'||l_req_material_tbl(j).UOM_CODE);
2032: AHL_DEBUG_PUB.debug('Before Eam job pvt.WorkorderID:'||l_req_material_tbl(j).WORKORDER_ID);
2033: AHL_DEBUG_PUB.debug('Before Eam job pvt.WipentityID:'||l_req_material_tbl(j).WIP_ENTITY_ID);
2034: AHL_DEBUG_PUB.debug('Before Eam job pvt.OrganizationID:'||l_req_material_tbl(j).ORGANIZATION_ID);
2035: AHL_DEBUG_PUB.debug('Before Eam job pvt.Jobmumber:'||l_req_material_tbl(j).JOB_NUMBER);
2036: AHL_DEBUG_PUB.debug('Before Eam job pvt.OperationSequence:'||l_req_material_tbl(j).OPERATION_SEQUENCE);
2037: END IF;

Line 2034: AHL_DEBUG_PUB.debug('Before Eam job pvt.OrganizationID:'||l_req_material_tbl(j).ORGANIZATION_ID);

2030: AHL_DEBUG_PUB.debug('Before Eam job pvt.Quantity:'||l_req_material_tbl(j).REQUESTED_QUANTITY);
2031: AHL_DEBUG_PUB.debug('Before Eam job pvt.Uom:'||l_req_material_tbl(j).UOM_CODE);
2032: AHL_DEBUG_PUB.debug('Before Eam job pvt.WorkorderID:'||l_req_material_tbl(j).WORKORDER_ID);
2033: AHL_DEBUG_PUB.debug('Before Eam job pvt.WipentityID:'||l_req_material_tbl(j).WIP_ENTITY_ID);
2034: AHL_DEBUG_PUB.debug('Before Eam job pvt.OrganizationID:'||l_req_material_tbl(j).ORGANIZATION_ID);
2035: AHL_DEBUG_PUB.debug('Before Eam job pvt.Jobmumber:'||l_req_material_tbl(j).JOB_NUMBER);
2036: AHL_DEBUG_PUB.debug('Before Eam job pvt.OperationSequence:'||l_req_material_tbl(j).OPERATION_SEQUENCE);
2037: END IF;
2038: -- dbms_output.put_line( 'Before Eam job pvt.InentoryItemID:'||l_req_material_tbl(j).INVENTORY_ITEM_ID);

Line 2035: AHL_DEBUG_PUB.debug('Before Eam job pvt.Jobmumber:'||l_req_material_tbl(j).JOB_NUMBER);

2031: AHL_DEBUG_PUB.debug('Before Eam job pvt.Uom:'||l_req_material_tbl(j).UOM_CODE);
2032: AHL_DEBUG_PUB.debug('Before Eam job pvt.WorkorderID:'||l_req_material_tbl(j).WORKORDER_ID);
2033: AHL_DEBUG_PUB.debug('Before Eam job pvt.WipentityID:'||l_req_material_tbl(j).WIP_ENTITY_ID);
2034: AHL_DEBUG_PUB.debug('Before Eam job pvt.OrganizationID:'||l_req_material_tbl(j).ORGANIZATION_ID);
2035: AHL_DEBUG_PUB.debug('Before Eam job pvt.Jobmumber:'||l_req_material_tbl(j).JOB_NUMBER);
2036: AHL_DEBUG_PUB.debug('Before Eam job pvt.OperationSequence:'||l_req_material_tbl(j).OPERATION_SEQUENCE);
2037: END IF;
2038: -- dbms_output.put_line( 'Before Eam job pvt.InentoryItemID:'||l_req_material_tbl(j).INVENTORY_ITEM_ID);
2039: -- dbms_output.put_line( 'Before Eam job pvt.quantity:'||l_req_material_tbl(j).REQUESTED_QUANTITY);

Line 2036: AHL_DEBUG_PUB.debug('Before Eam job pvt.OperationSequence:'||l_req_material_tbl(j).OPERATION_SEQUENCE);

2032: AHL_DEBUG_PUB.debug('Before Eam job pvt.WorkorderID:'||l_req_material_tbl(j).WORKORDER_ID);
2033: AHL_DEBUG_PUB.debug('Before Eam job pvt.WipentityID:'||l_req_material_tbl(j).WIP_ENTITY_ID);
2034: AHL_DEBUG_PUB.debug('Before Eam job pvt.OrganizationID:'||l_req_material_tbl(j).ORGANIZATION_ID);
2035: AHL_DEBUG_PUB.debug('Before Eam job pvt.Jobmumber:'||l_req_material_tbl(j).JOB_NUMBER);
2036: AHL_DEBUG_PUB.debug('Before Eam job pvt.OperationSequence:'||l_req_material_tbl(j).OPERATION_SEQUENCE);
2037: END IF;
2038: -- dbms_output.put_line( 'Before Eam job pvt.InentoryItemID:'||l_req_material_tbl(j).INVENTORY_ITEM_ID);
2039: -- dbms_output.put_line( 'Before Eam job pvt.quantity:'||l_req_material_tbl(j).REQUESTED_QUANTITY);
2040: -- dbms_output.put_line( 'Before Eam job pvt.uom:'||l_req_material_tbl(j).UOM_CODE);

Line 2052: AHL_DEBUG_PUB.debug('before wip job call');

2048: END IF; --Material tbl
2049: --
2050: -- dbms_output.put_line( 'before wip jobs:');
2051: IF G_DEBUG='Y' THEN
2052: AHL_DEBUG_PUB.debug('before wip job call');
2053: END IF;
2054: -- Before Ahl Eam job Call
2055: AHL_EAM_JOB_PVT.process_material_req
2056: (

Line 2069: AHL_DEBUG_PUB.debug('after wip job call:'||l_return_status);

2065: x_msg_data => l_msg_data,
2066: p_material_req_tbl => l_req_material_tbl);
2067: -- dbms_output.put_line( 'after wip jobs:'||l_return_status);
2068: IF G_DEBUG='Y' THEN
2069: AHL_DEBUG_PUB.debug('after wip job call:'||l_return_status);
2070: AHL_DEBUG_PUB.debug('after wip job call:'||l_msg_count);
2071: AHL_DEBUG_PUB.debug('after wip job call:'||l_msg_data);
2072: END IF;
2073: --

Line 2070: AHL_DEBUG_PUB.debug('after wip job call:'||l_msg_count);

2066: p_material_req_tbl => l_req_material_tbl);
2067: -- dbms_output.put_line( 'after wip jobs:'||l_return_status);
2068: IF G_DEBUG='Y' THEN
2069: AHL_DEBUG_PUB.debug('after wip job call:'||l_return_status);
2070: AHL_DEBUG_PUB.debug('after wip job call:'||l_msg_count);
2071: AHL_DEBUG_PUB.debug('after wip job call:'||l_msg_data);
2072: END IF;
2073: --
2074: l_msg_count := FND_MSG_PUB.count_msg;

Line 2071: AHL_DEBUG_PUB.debug('after wip job call:'||l_msg_data);

2067: -- dbms_output.put_line( 'after wip jobs:'||l_return_status);
2068: IF G_DEBUG='Y' THEN
2069: AHL_DEBUG_PUB.debug('after wip job call:'||l_return_status);
2070: AHL_DEBUG_PUB.debug('after wip job call:'||l_msg_count);
2071: AHL_DEBUG_PUB.debug('after wip job call:'||l_msg_data);
2072: END IF;
2073: --
2074: l_msg_count := FND_MSG_PUB.count_msg;
2075: --

Line 2085: AHL_DEBUG_PUB.debug('Before insert status call');

2081: END IF;
2082: END IF;
2083: --
2084: IF G_DEBUG='Y' THEN
2085: AHL_DEBUG_PUB.debug('Before insert status call');
2086: END IF;
2087: -- dbms_output.put_line( 'after wip jobs:');
2088: --
2089: IF l_return_status ='S' THEN

Line 2231: AHL_DEBUG_PUB.debug('fetching dff_default_values');

2227: l_Req_Material_Tbl(i).mc_position := p_x_req_material_tbl(i).mc_position;
2228: END IF;
2229: --sukhwsin: SB Effectivity Code chanages - ends
2230: IF G_DEBUG='Y' THEN
2231: AHL_DEBUG_PUB.debug('fetching dff_default_values');
2232: END IF;
2233: get_dff_default_values
2234: (
2235: p_req_material_rec => p_x_req_material_tbl(i),

Line 2239: AHL_DEBUG_PUB.debug('dff_default_values have been fetched');

2235: p_req_material_rec => p_x_req_material_tbl(i),
2236: flex_fields_defaults => dff_default_values
2237: );
2238: IF G_DEBUG='Y' THEN
2239: AHL_DEBUG_PUB.debug('dff_default_values have been fetched');
2240: END IF;
2241: -- Attribte Category
2242: IF p_x_req_material_tbl(i).attribute_category = FND_API.G_MISS_CHAR
2243: THEN

Line 2401: AHL_DEBUG_PUB.debug( 'before interface flag:'||p_x_req_material_tbl(i).rt_oper_material_id);

2397: INTO l_schedule_material_id FROM DUAL;
2398: --
2399: --
2400: IF G_DEBUG='Y' THEN
2401: AHL_DEBUG_PUB.debug( 'before interface flag:'||p_x_req_material_tbl(i).rt_oper_material_id);
2402: AHL_DEBUG_PUB.debug( 'before interface flag:'||p_interface_flag);
2403: END IF;
2404: --Check for materials added from route.Already in scheudle material entity
2405: -- were schedule during LTP process

Line 2402: AHL_DEBUG_PUB.debug( 'before interface flag:'||p_interface_flag);

2398: --
2399: --
2400: IF G_DEBUG='Y' THEN
2401: AHL_DEBUG_PUB.debug( 'before interface flag:'||p_x_req_material_tbl(i).rt_oper_material_id);
2402: AHL_DEBUG_PUB.debug( 'before interface flag:'||p_interface_flag);
2403: END IF;
2404: --Check for materials added from route.Already in scheudle material entity
2405: -- were schedule during LTP process
2406: IF (p_interface_flag = 'N' or p_interface_flag = 'n') THEN

Line 2409: AHL_DEBUG_PUB.debug( 'FLAG=N RTID:'||p_x_req_material_tbl(i).rt_oper_material_id);

2405: -- were schedule during LTP process
2406: IF (p_interface_flag = 'N' or p_interface_flag = 'n') THEN
2407: --
2408: IF G_DEBUG='Y' THEN
2409: AHL_DEBUG_PUB.debug( 'FLAG=N RTID:'||p_x_req_material_tbl(i).rt_oper_material_id);
2410: AHL_DEBUG_PUB.debug( 'FLAG=N VTID:'||p_x_req_material_tbl(i).visit_task_id);
2411: AHL_DEBUG_PUB.debug( 'FLAG=N ITID:'||p_x_req_material_tbl(i).inventory_item_id);
2412: END IF;
2413: IF (p_x_req_material_tbl(i).rt_oper_material_id IS NOT NULL AND

Line 2410: AHL_DEBUG_PUB.debug( 'FLAG=N VTID:'||p_x_req_material_tbl(i).visit_task_id);

2406: IF (p_interface_flag = 'N' or p_interface_flag = 'n') THEN
2407: --
2408: IF G_DEBUG='Y' THEN
2409: AHL_DEBUG_PUB.debug( 'FLAG=N RTID:'||p_x_req_material_tbl(i).rt_oper_material_id);
2410: AHL_DEBUG_PUB.debug( 'FLAG=N VTID:'||p_x_req_material_tbl(i).visit_task_id);
2411: AHL_DEBUG_PUB.debug( 'FLAG=N ITID:'||p_x_req_material_tbl(i).inventory_item_id);
2412: END IF;
2413: IF (p_x_req_material_tbl(i).rt_oper_material_id IS NOT NULL AND
2414: p_x_req_material_tbl(i).rt_oper_material_id <> FND_API.G_MISS_NUM)

Line 2411: AHL_DEBUG_PUB.debug( 'FLAG=N ITID:'||p_x_req_material_tbl(i).inventory_item_id);

2407: --
2408: IF G_DEBUG='Y' THEN
2409: AHL_DEBUG_PUB.debug( 'FLAG=N RTID:'||p_x_req_material_tbl(i).rt_oper_material_id);
2410: AHL_DEBUG_PUB.debug( 'FLAG=N VTID:'||p_x_req_material_tbl(i).visit_task_id);
2411: AHL_DEBUG_PUB.debug( 'FLAG=N ITID:'||p_x_req_material_tbl(i).inventory_item_id);
2412: END IF;
2413: IF (p_x_req_material_tbl(i).rt_oper_material_id IS NOT NULL AND
2414: p_x_req_material_tbl(i).rt_oper_material_id <> FND_API.G_MISS_NUM)
2415: THEN

Line 2425: AHL_DEBUG_PUB.debug( 'Inside MATID:'||l_material_rec.scheduled_material_id);

2421: FETCH Get_rt_mat_cur INTO l_material_rec;
2422: CLOSE Get_rt_mat_cur;
2423: --
2424: IF G_DEBUG='Y' THEN
2425: AHL_DEBUG_PUB.debug( 'Inside MATID:'||l_material_rec.scheduled_material_id);
2426: AHL_DEBUG_PUB.debug( 'inside VTID:'||l_material_rec.visit_task_id);
2427: AHL_DEBUG_PUB.debug( 'inside ITID:'||l_material_rec.inventory_item_id);
2428: AHL_DEBUG_PUB.debug( 'inside DES:'||l_schedule_designator);
2429: END IF;

Line 2426: AHL_DEBUG_PUB.debug( 'inside VTID:'||l_material_rec.visit_task_id);

2422: CLOSE Get_rt_mat_cur;
2423: --
2424: IF G_DEBUG='Y' THEN
2425: AHL_DEBUG_PUB.debug( 'Inside MATID:'||l_material_rec.scheduled_material_id);
2426: AHL_DEBUG_PUB.debug( 'inside VTID:'||l_material_rec.visit_task_id);
2427: AHL_DEBUG_PUB.debug( 'inside ITID:'||l_material_rec.inventory_item_id);
2428: AHL_DEBUG_PUB.debug( 'inside DES:'||l_schedule_designator);
2429: END IF;
2430: --

Line 2427: AHL_DEBUG_PUB.debug( 'inside ITID:'||l_material_rec.inventory_item_id);

2423: --
2424: IF G_DEBUG='Y' THEN
2425: AHL_DEBUG_PUB.debug( 'Inside MATID:'||l_material_rec.scheduled_material_id);
2426: AHL_DEBUG_PUB.debug( 'inside VTID:'||l_material_rec.visit_task_id);
2427: AHL_DEBUG_PUB.debug( 'inside ITID:'||l_material_rec.inventory_item_id);
2428: AHL_DEBUG_PUB.debug( 'inside DES:'||l_schedule_designator);
2429: END IF;
2430: --
2431: IF ( l_material_rec.scheduled_material_id IS NOT NULL

Line 2428: AHL_DEBUG_PUB.debug( 'inside DES:'||l_schedule_designator);

2424: IF G_DEBUG='Y' THEN
2425: AHL_DEBUG_PUB.debug( 'Inside MATID:'||l_material_rec.scheduled_material_id);
2426: AHL_DEBUG_PUB.debug( 'inside VTID:'||l_material_rec.visit_task_id);
2427: AHL_DEBUG_PUB.debug( 'inside ITID:'||l_material_rec.inventory_item_id);
2428: AHL_DEBUG_PUB.debug( 'inside DES:'||l_schedule_designator);
2429: END IF;
2430: --
2431: IF ( l_material_rec.scheduled_material_id IS NOT NULL
2432: --Adithya added for FP Bug# 6366740

Line 2451: AHL_DEBUG_PUB.debug( 'p_x_req_material_tbl(i).mrp_net_flag:'||p_x_req_material_tbl(i).mrp_net_flag);

2447: -- fix for bug# 5549135.
2448: --p_x_req_material_tbl(i).mrp_net_flag := 1;
2449: p_x_req_material_tbl(i).mrp_net_flag := 2;
2450: IF G_DEBUG='Y' THEN
2451: AHL_DEBUG_PUB.debug( 'p_x_req_material_tbl(i).mrp_net_flag:'||p_x_req_material_tbl(i).mrp_net_flag);
2452: END IF;
2453: ELSE
2454: IF G_DEBUG='Y' THEN
2455: AHL_DEBUG_PUB.debug( 'else flag Mat id:'||l_schedule_material_id);

Line 2455: AHL_DEBUG_PUB.debug( 'else flag Mat id:'||l_schedule_material_id);

2451: AHL_DEBUG_PUB.debug( 'p_x_req_material_tbl(i).mrp_net_flag:'||p_x_req_material_tbl(i).mrp_net_flag);
2452: END IF;
2453: ELSE
2454: IF G_DEBUG='Y' THEN
2455: AHL_DEBUG_PUB.debug( 'else flag Mat id:'||l_schedule_material_id);
2456: END IF;
2457: -- Create Record in schedule materials
2458: Insert_Row (
2459: X_SCHEDULED_MATERIAL_ID => l_schedule_material_id,

Line 2524: AHL_DEBUG_PUB.debug( 'schedule material id 5:'||l_schedule_material_id);

2520: --
2521: END IF; --Get_rt_mat_cur
2522: -- Get Project and Task id
2523: IF G_DEBUG='Y' THEN
2524: AHL_DEBUG_PUB.debug( 'schedule material id 5:'||l_schedule_material_id);
2525: END IF;
2526: ELSE
2527: IF G_DEBUG='Y' THEN
2528: AHL_DEBUG_PUB.debug( 'schedule material id 6:'||l_schedule_material_id);

Line 2528: AHL_DEBUG_PUB.debug( 'schedule material id 6:'||l_schedule_material_id);

2524: AHL_DEBUG_PUB.debug( 'schedule material id 5:'||l_schedule_material_id);
2525: END IF;
2526: ELSE
2527: IF G_DEBUG='Y' THEN
2528: AHL_DEBUG_PUB.debug( 'schedule material id 6:'||l_schedule_material_id);
2529: END IF;
2530: -- Create Record in schedule materials
2531: Insert_Row (
2532: X_SCHEDULED_MATERIAL_ID => l_schedule_material_id,

Line 2597: AHL_DEBUG_PUB.debug( 'after rt oper material id:'||l_schedule_material_id);

2593: p_x_req_material_tbl(i).mrp_net_flag := 2;
2594: --
2595: END IF; -- --rt oper id not null
2596: IF G_DEBUG='Y' THEN
2597: AHL_DEBUG_PUB.debug( 'after rt oper material id:'||l_schedule_material_id);
2598: END IF;
2599: --
2600: END IF; -- --Interface flag
2601: --

Line 2603: AHL_DEBUG_PUB.debug( 'schedule material id:'||l_schedule_material_id);

2599: --
2600: END IF; -- --Interface flag
2601: --
2602: IF G_DEBUG='Y' THEN
2603: AHL_DEBUG_PUB.debug( 'schedule material id:'||l_schedule_material_id);
2604: END IF;
2605: --
2606: END IF; --Material id g_miss_num
2607: --

Line 2612: AHL_DEBUG_PUB.debug( 'before calling log record l_wo_operation_txn_id:'||l_wo_operation_txn_id);

2608: SELECT AHL_WO_OPERATIONS_TXNS_S.NEXTVAL INTO l_wo_operation_txn_id
2609: FROM DUAL;
2610: --
2611: IF G_DEBUG='Y' THEN
2612: AHL_DEBUG_PUB.debug( 'before calling log record l_wo_operation_txn_id:'||l_wo_operation_txn_id);
2613: END IF;
2614: --Create Record in transactions table
2615: Log_Transaction_Record
2616: ( p_wo_operation_txn_id => l_wo_operation_txn_id,

Line 2634: AHL_DEBUG_PUB.debug( 'before calling MRP l_schedule_designator:'||l_schedule_designator);

2630: );
2631: --Call MRP Process
2632: --
2633: IF G_DEBUG='Y' THEN
2634: AHL_DEBUG_PUB.debug( 'before calling MRP l_schedule_designator:'||l_schedule_designator);
2635: END IF;
2636: IF (p_interface_flag IS NULL OR p_interface_flag = 'Y') THEN
2637: -- Create Record in schedule materials
2638: Insert_Row (

Line 2780: Ahl_Debug_Pub.debug( 'End of public api Create Material Reqst','+PPMRP+');

2776: COMMIT;
2777: END IF;
2778: -- Debug info
2779: IF G_DEBUG='Y' THEN
2780: Ahl_Debug_Pub.debug( 'End of public api Create Material Reqst','+PPMRP+');
2781: -- Check if API is called in debug mode. If yes, disable debug.
2782: Ahl_Debug_Pub.disable_debug;
2783: END IF;
2784: EXCEPTION

Line 2782: Ahl_Debug_Pub.disable_debug;

2778: -- Debug info
2779: IF G_DEBUG='Y' THEN
2780: Ahl_Debug_Pub.debug( 'End of public api Create Material Reqst','+PPMRP+');
2781: -- Check if API is called in debug mode. If yes, disable debug.
2782: Ahl_Debug_Pub.disable_debug;
2783: END IF;
2784: EXCEPTION
2785: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2786: ROLLBACK TO create_material_reqst;

Line 2792: AHL_DEBUG_PUB.log_app_messages (

2788: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
2789: p_count => x_msg_count,
2790: p_data => x_msg_data);
2791: IF G_DEBUG='Y' THEN
2792: AHL_DEBUG_PUB.log_app_messages (
2793: x_msg_count, x_msg_data, 'ERROR' );
2794: AHL_DEBUG_PUB.debug( 'ahl_pp_materials_pvt. Create Material Reqst','+PPMRP+');
2795: -- Check if API is called in debug mode. If yes, disable debug.
2796: AHL_DEBUG_PUB.disable_debug;

Line 2794: AHL_DEBUG_PUB.debug( 'ahl_pp_materials_pvt. Create Material Reqst','+PPMRP+');

2790: p_data => x_msg_data);
2791: IF G_DEBUG='Y' THEN
2792: AHL_DEBUG_PUB.log_app_messages (
2793: x_msg_count, x_msg_data, 'ERROR' );
2794: AHL_DEBUG_PUB.debug( 'ahl_pp_materials_pvt. Create Material Reqst','+PPMRP+');
2795: -- Check if API is called in debug mode. If yes, disable debug.
2796: AHL_DEBUG_PUB.disable_debug;
2797: END IF;
2798: WHEN FND_API.G_EXC_ERROR THEN

Line 2796: AHL_DEBUG_PUB.disable_debug;

2792: AHL_DEBUG_PUB.log_app_messages (
2793: x_msg_count, x_msg_data, 'ERROR' );
2794: AHL_DEBUG_PUB.debug( 'ahl_pp_materials_pvt. Create Material Reqst','+PPMRP+');
2795: -- Check if API is called in debug mode. If yes, disable debug.
2796: AHL_DEBUG_PUB.disable_debug;
2797: END IF;
2798: WHEN FND_API.G_EXC_ERROR THEN
2799: ROLLBACK TO create_material_reqst;
2800: X_return_status := FND_API.G_RET_STS_ERROR;

Line 2806: AHL_DEBUG_PUB.log_app_messages (

2802: p_count => x_msg_count,
2803: p_data => X_msg_data);
2804: IF G_DEBUG='Y' THEN
2805: -- Debug info.
2806: AHL_DEBUG_PUB.log_app_messages (
2807: x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
2808: AHL_DEBUG_PUB.debug( 'ahl_pp_materials_pvt. Create Material Reqst','+PPMRP+');
2809: -- Check if API is called in debug mode. If yes, disable debug.
2810: AHL_DEBUG_PUB.disable_debug;

Line 2808: AHL_DEBUG_PUB.debug( 'ahl_pp_materials_pvt. Create Material Reqst','+PPMRP+');

2804: IF G_DEBUG='Y' THEN
2805: -- Debug info.
2806: AHL_DEBUG_PUB.log_app_messages (
2807: x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
2808: AHL_DEBUG_PUB.debug( 'ahl_pp_materials_pvt. Create Material Reqst','+PPMRP+');
2809: -- Check if API is called in debug mode. If yes, disable debug.
2810: AHL_DEBUG_PUB.disable_debug;
2811: END IF;
2812: WHEN OTHERS THEN

Line 2810: AHL_DEBUG_PUB.disable_debug;

2806: AHL_DEBUG_PUB.log_app_messages (
2807: x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
2808: AHL_DEBUG_PUB.debug( 'ahl_pp_materials_pvt. Create Material Reqst','+PPMRP+');
2809: -- Check if API is called in debug mode. If yes, disable debug.
2810: AHL_DEBUG_PUB.disable_debug;
2811: END IF;
2812: WHEN OTHERS THEN
2813: ROLLBACK TO create_material_reqst;
2814: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2826: AHL_DEBUG_PUB.log_app_messages (

2822: p_count => x_msg_count,
2823: p_data => X_msg_data);
2824: IF G_DEBUG='Y' THEN
2825: -- Debug info.
2826: AHL_DEBUG_PUB.log_app_messages (
2827: x_msg_count, x_msg_data, 'SQL ERROR' );
2828: AHL_DEBUG_PUB.debug( 'ahl_pp_materials_pvt. Create Material Reqst','+PPMRP+');
2829: -- Check if API is called in debug mode. If yes, disable debug.
2830: AHL_DEBUG_PUB.disable_debug;

Line 2828: AHL_DEBUG_PUB.debug( 'ahl_pp_materials_pvt. Create Material Reqst','+PPMRP+');

2824: IF G_DEBUG='Y' THEN
2825: -- Debug info.
2826: AHL_DEBUG_PUB.log_app_messages (
2827: x_msg_count, x_msg_data, 'SQL ERROR' );
2828: AHL_DEBUG_PUB.debug( 'ahl_pp_materials_pvt. Create Material Reqst','+PPMRP+');
2829: -- Check if API is called in debug mode. If yes, disable debug.
2830: AHL_DEBUG_PUB.disable_debug;
2831: END IF;
2832: END Create_Material_Reqst;

Line 2830: AHL_DEBUG_PUB.disable_debug;

2826: AHL_DEBUG_PUB.log_app_messages (
2827: x_msg_count, x_msg_data, 'SQL ERROR' );
2828: AHL_DEBUG_PUB.debug( 'ahl_pp_materials_pvt. Create Material Reqst','+PPMRP+');
2829: -- Check if API is called in debug mode. If yes, disable debug.
2830: AHL_DEBUG_PUB.disable_debug;
2831: END IF;
2832: END Create_Material_Reqst;
2833: --
2834: -- Start of Comments --

Line 3017: AHL_DEBUG_PUB.enable_debug;

3013: -- Standard Start of API savepoint
3014: SAVEPOINT update_material_reqst;
3015: -- Check if API is called in debug mode. If yes, enable debug.
3016: IF G_DEBUG='Y' THEN
3017: AHL_DEBUG_PUB.enable_debug;
3018: -- Debug info.
3019: AHL_DEBUG_PUB.debug( 'enter ahl_pp_materias_pvt. update material reqst','+PPMRP+');
3020: END IF;
3021: -- Standard call to check for call compatibility.

Line 3019: AHL_DEBUG_PUB.debug( 'enter ahl_pp_materias_pvt. update material reqst','+PPMRP+');

3015: -- Check if API is called in debug mode. If yes, enable debug.
3016: IF G_DEBUG='Y' THEN
3017: AHL_DEBUG_PUB.enable_debug;
3018: -- Debug info.
3019: AHL_DEBUG_PUB.debug( 'enter ahl_pp_materias_pvt. update material reqst','+PPMRP+');
3020: END IF;
3021: -- Standard call to check for call compatibility.
3022: IF FND_API.to_boolean(p_init_msg_list)
3023: THEN

Line 3048: AHL_DEBUG_PUB.debug( 'WOID :'||p_x_req_material_tbl(i).workorder_id);

3044: p_x_req_material_tbl(i).job_number <> FND_API.G_MISS_CHAR ) )
3045: THEN
3046: --
3047: IF G_DEBUG='Y' THEN
3048: AHL_DEBUG_PUB.debug( 'WOID :'||p_x_req_material_tbl(i).workorder_id);
3049: END IF;
3050: --
3051: Get_workorder_id
3052: (p_workorder_id => p_x_req_material_tbl(i).workorder_id,

Line 3089: AHL_DEBUG_PUB.debug( 'WOID 2:'||p_x_req_material_tbl(i).workorder_id);

3085: -- rroy
3086: -- ACL Changes
3087: --
3088: IF G_DEBUG='Y' THEN
3089: AHL_DEBUG_PUB.debug( 'WOID 2:'||p_x_req_material_tbl(i).workorder_id);
3090: END IF;
3091: END IF; --Module type
3092: --Get Requirement operation details
3093: OPEN Get_Req_Matrl_cur(p_x_req_material_tbl(i).schedule_material_id);

Line 3114: AHL_DEBUG_PUB.debug( 'INVID :'||p_x_req_material_tbl(i).inventory_item_id);

3110: --sukhwsin: SB Effectivity code changes - ends
3111: --pdoki added for Bug 7712916
3112: p_x_req_material_tbl(i).rt_oper_material_id := l_req_material_rec.rt_oper_material_id;
3113: IF G_DEBUG='Y' THEN
3114: AHL_DEBUG_PUB.debug( 'INVID :'||p_x_req_material_tbl(i).inventory_item_id);
3115: END IF;
3116: -- Validate for Requested Quantity
3117: IF (p_x_req_material_tbl(i).requested_quantity IS NULL OR
3118: p_x_req_material_tbl(i).requested_quantity = FND_API.G_MISS_NUM) THEN

Line 3149: AHL_DEBUG_PUB.debug( 'QTY :'||p_x_req_material_tbl(i).requested_quantity);

3145: END IF;-- p_x_req_material_tbl(i).requested_quantity <
3146: END IF; --p_x_req_material_tbl(i).requested_quantity <>
3147: END IF;
3148: IF G_DEBUG='Y' THEN
3149: AHL_DEBUG_PUB.debug( 'QTY :'||p_x_req_material_tbl(i).requested_quantity);
3150: END IF;
3151:
3152: -- MANESING::NR Analysis, 03-Jun-2011, Validate for Scheduled Quantity
3153: IF ( p_x_req_material_tbl(i).scheduled_quantity IS NOT NULL AND

Line 3188: AHL_DEBUG_PUB.debug( 'Scheduled Quantity: ' || p_x_req_material_tbl(i).scheduled_quantity);

3184:
3185: END IF; -- p_x_req_material_tbl(i).scheduled_quantity IS NOT NULL
3186:
3187: IF ( G_DEBUG = 'Y' ) THEN
3188: AHL_DEBUG_PUB.debug( 'Scheduled Quantity: ' || p_x_req_material_tbl(i).scheduled_quantity);
3189: END IF;
3190:
3191: IF p_module_type NOT IN ('API', 'VWP') THEN --bug 14137417 :: added VWP by tchimira :: below validation should not occur for VWP flows
3192: -- Validate for Requested Date

Line 3210: AHL_DEBUG_PUB.debug( 'DATE :'||p_x_req_material_tbl(i).requested_date);

3206: Fnd_Msg_Pub.ADD;
3207: END IF;
3208: END IF;
3209: IF G_DEBUG='Y' THEN
3210: AHL_DEBUG_PUB.debug( 'DATE :'||p_x_req_material_tbl(i).requested_date);
3211: END IF;
3212: -- Validate for Schedule Material ID
3213: IF (p_x_req_material_tbl(i).schedule_material_id IS NULL AND
3214: p_x_req_material_tbl(i).schedule_material_id = FND_API.G_MISS_NUM) THEN

Line 3219: AHL_DEBUG_PUB.debug( 'SCHID :'||p_x_req_material_tbl(i).schedule_material_id);

3215: Fnd_Message.SET_NAME('AHL','AHL_PP_SCH_MATRL_REQUIRED');
3216: Fnd_Msg_Pub.ADD;
3217: END IF;
3218: IF G_DEBUG='Y' THEN
3219: AHL_DEBUG_PUB.debug( 'SCHID :'||p_x_req_material_tbl(i).schedule_material_id);
3220: AHL_DEBUG_PUB.debug( 'OSID'||p_x_req_material_tbl(i).operation_sequence);
3221: END IF;
3222: --Check for workorder status
3223: OPEN Check_wo_status_cur(p_x_req_material_tbl(i).workorder_id, p_module_type);

Line 3220: AHL_DEBUG_PUB.debug( 'OSID'||p_x_req_material_tbl(i).operation_sequence);

3216: Fnd_Msg_Pub.ADD;
3217: END IF;
3218: IF G_DEBUG='Y' THEN
3219: AHL_DEBUG_PUB.debug( 'SCHID :'||p_x_req_material_tbl(i).schedule_material_id);
3220: AHL_DEBUG_PUB.debug( 'OSID'||p_x_req_material_tbl(i).operation_sequence);
3221: END IF;
3222: --Check for workorder status
3223: OPEN Check_wo_status_cur(p_x_req_material_tbl(i).workorder_id, p_module_type);
3224: FETCH Check_wo_status_cur INTO l_dummy;

Line 3256: AHL_DEBUG_PUB.debug( 'End of validations');

3252: END IF;
3253: -- Calling Wip job api
3254: --
3255: IF G_DEBUG='Y' THEN
3256: AHL_DEBUG_PUB.debug( 'End of validations');
3257: AHL_DEBUG_PUB.debug('Before processing updates');
3258: END IF;
3259: --
3260: --IF p_module_type <> 'API' THEN

Line 3257: AHL_DEBUG_PUB.debug('Before processing updates');

3253: -- Calling Wip job api
3254: --
3255: IF G_DEBUG='Y' THEN
3256: AHL_DEBUG_PUB.debug( 'End of validations');
3257: AHL_DEBUG_PUB.debug('Before processing updates');
3258: END IF;
3259: --
3260: --IF p_module_type <> 'API' THEN
3261: IF p_x_req_material_tbl.COUNT >0

Line 3293: AHL_DEBUG_PUB.debug( 'before calling log record l_wo_operation_txn_id:'||l_wo_operation_txn_id);

3289: SELECT AHL_WO_OPERATIONS_TXNS_S.NEXTVAL INTO l_wo_operation_txn_id
3290: FROM DUAL;
3291: --
3292: IF G_DEBUG='Y' THEN
3293: AHL_DEBUG_PUB.debug( 'before calling log record l_wo_operation_txn_id:'||l_wo_operation_txn_id);
3294: END IF;
3295: Log_Transaction_Record
3296: ( p_wo_operation_txn_id => l_wo_operation_txn_id,
3297: p_object_version_number => 1,

Line 3332: AHL_DEBUG_PUB.debug('Request Date from DB for sch. Mat ID:1:' || l_req_material_rec.old_requested_date || ':' || p_x_req_material_tbl(i).schedule_material_id);

3328: l_req_material_tbl(j).REQUESTED_DATE := p_x_req_material_tbl(i).requested_date;
3329: l_req_material_tbl(j).OPERATION_FLAG := 'U';
3330: j := j + 1;
3331: IF G_DEBUG='Y' THEN
3332: AHL_DEBUG_PUB.debug('Request Date from DB for sch. Mat ID:1:' || l_req_material_rec.old_requested_date || ':' || p_x_req_material_tbl(i).schedule_material_id);
3333: AHL_DEBUG_PUB.debug('Changed Request Date :' || p_x_req_material_tbl(i).requested_date );
3334: END IF;
3335: --
3336: END LOOP;

Line 3333: AHL_DEBUG_PUB.debug('Changed Request Date :' || p_x_req_material_tbl(i).requested_date );

3329: l_req_material_tbl(j).OPERATION_FLAG := 'U';
3330: j := j + 1;
3331: IF G_DEBUG='Y' THEN
3332: AHL_DEBUG_PUB.debug('Request Date from DB for sch. Mat ID:1:' || l_req_material_rec.old_requested_date || ':' || p_x_req_material_tbl(i).schedule_material_id);
3333: AHL_DEBUG_PUB.debug('Changed Request Date :' || p_x_req_material_tbl(i).requested_date );
3334: END IF;
3335: --
3336: END LOOP;
3337: END IF; --Material tbl

Line 3339: AHL_DEBUG_PUB.debug('beforer wip job record assign');

3335: --
3336: END LOOP;
3337: END IF; --Material tbl
3338: IF G_DEBUG='Y' THEN
3339: AHL_DEBUG_PUB.debug('beforer wip job record assign');
3340: END IF;
3341: IF l_req_material_tbl.COUNT > 0 THEN
3342: --
3343: IF G_DEBUG='Y' THEN

Line 3344: AHL_DEBUG_PUB.debug('before Eam Workorder job call');

3340: END IF;
3341: IF l_req_material_tbl.COUNT > 0 THEN
3342: --
3343: IF G_DEBUG='Y' THEN
3344: AHL_DEBUG_PUB.debug('before Eam Workorder job call');
3345: AHL_DEBUG_PUB.debug('before Eam Api jobs call''count :'||l_req_material_tbl.count);
3346: END IF;
3347: -- Call wip job api
3348: --

Line 3345: AHL_DEBUG_PUB.debug('before Eam Api jobs call''count :'||l_req_material_tbl.count);

3341: IF l_req_material_tbl.COUNT > 0 THEN
3342: --
3343: IF G_DEBUG='Y' THEN
3344: AHL_DEBUG_PUB.debug('before Eam Workorder job call');
3345: AHL_DEBUG_PUB.debug('before Eam Api jobs call''count :'||l_req_material_tbl.count);
3346: END IF;
3347: -- Call wip job api
3348: --
3349: AHL_EAM_JOB_PVT.process_material_req

Line 3365: AHL_DEBUG_PUB.debug('AHLVPPMB: after wip job call'||l_return_status);

3361: );
3362: --
3363: END IF; --Eam table count > 0
3364: IF G_DEBUG='Y' THEN
3365: AHL_DEBUG_PUB.debug('AHLVPPMB: after wip job call'||l_return_status);
3366: END IF;
3367: --END IF; --Module type null
3368: IF l_return_status ='S' THEN
3369: --

Line 3384: AHL_DEBUG_PUB.debug('Request Date from DB for sch. Mat ID:2:' || l_req_material_rec.old_requested_date

3380: -- Added for R12 serial reservations enhancements - ER# 4295982.
3381: -- If requested date is changed, then call reservations api to change the
3382: -- requested date in WMS.
3383: IF G_DEBUG='Y' THEN
3384: AHL_DEBUG_PUB.debug('Request Date from DB for sch. Mat ID:2:' || l_req_material_rec.old_requested_date
3385: || ':' || p_x_req_material_tbl(i).schedule_material_id);
3386: AHL_DEBUG_PUB.debug('Changed Request Date :' || p_x_req_material_tbl(i).requested_date );
3387: END IF;
3388: IF (trunc(p_x_req_material_tbl(i).requested_date) <> trunc(l_req_material_rec.old_requested_date))

Line 3386: AHL_DEBUG_PUB.debug('Changed Request Date :' || p_x_req_material_tbl(i).requested_date );

3382: -- requested date in WMS.
3383: IF G_DEBUG='Y' THEN
3384: AHL_DEBUG_PUB.debug('Request Date from DB for sch. Mat ID:2:' || l_req_material_rec.old_requested_date
3385: || ':' || p_x_req_material_tbl(i).schedule_material_id);
3386: AHL_DEBUG_PUB.debug('Changed Request Date :' || p_x_req_material_tbl(i).requested_date );
3387: END IF;
3388: IF (trunc(p_x_req_material_tbl(i).requested_date) <> trunc(l_req_material_rec.old_requested_date))
3389: THEN
3390: IF G_DEBUG='Y' THEN

Line 3391: AHL_DEBUG_PUB.debug('Before Call to Upd RSV ') ;

3387: END IF;
3388: IF (trunc(p_x_req_material_tbl(i).requested_date) <> trunc(l_req_material_rec.old_requested_date))
3389: THEN
3390: IF G_DEBUG='Y' THEN
3391: AHL_DEBUG_PUB.debug('Before Call to Upd RSV ') ;
3392: END IF;
3393: -- call update reservations api.
3394: AHL_RSV_RESERVATIONS_PVT.Update_Reservation(
3395: p_api_version => 1.0,

Line 3405: AHL_DEBUG_PUB.debug('After Call to Upd RSV- Return Status:' || x_return_status);

3401: x_msg_data => x_msg_data,
3402: p_scheduled_material_id => p_x_req_material_tbl(i).schedule_material_id,
3403: p_requested_date => p_x_req_material_tbl(i).requested_date);
3404: IF G_DEBUG='Y' THEN
3405: AHL_DEBUG_PUB.debug('After Call to Upd RSV- Return Status:' || x_return_status);
3406: END IF;
3407: -- Raise error if exceptions occur
3408: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3409: RAISE FND_API.G_EXC_ERROR;

Line 3682: AHL_DEBUG_PUB.debug( 'END OF UPDATE PROCESS');

3678: x_msg_data => l_msg_data);
3679: END IF;
3680: END IF;
3681: IF G_DEBUG='Y' THEN
3682: AHL_DEBUG_PUB.debug( 'END OF UPDATE PROCESS');
3683: END IF;
3684: --
3685: ------------------------End of Body---------------------------------------
3686: --Standard check to count messages

Line 3703: Ahl_Debug_Pub.debug( 'End of public api Update Material Reqst','+PPMRP+');

3699: COMMIT;
3700: END IF;
3701: -- Debug info
3702: IF G_DEBUG='Y' THEN
3703: Ahl_Debug_Pub.debug( 'End of public api Update Material Reqst','+PPMRP+');
3704: -- Check if API is called in debug mode. If yes, disable debug.
3705: Ahl_Debug_Pub.disable_debug;
3706: END IF;
3707: EXCEPTION

Line 3705: Ahl_Debug_Pub.disable_debug;

3701: -- Debug info
3702: IF G_DEBUG='Y' THEN
3703: Ahl_Debug_Pub.debug( 'End of public api Update Material Reqst','+PPMRP+');
3704: -- Check if API is called in debug mode. If yes, disable debug.
3705: Ahl_Debug_Pub.disable_debug;
3706: END IF;
3707: EXCEPTION
3708: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3709: ROLLBACK TO update_material_reqst;

Line 3715: AHL_DEBUG_PUB.log_app_messages (

3711: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
3712: p_count => x_msg_count,
3713: p_data => x_msg_data);
3714: IF G_DEBUG='Y' THEN
3715: AHL_DEBUG_PUB.log_app_messages (
3716: x_msg_count, x_msg_data, 'ERROR' );
3717: AHL_DEBUG_PUB.debug( 'ahl_pp_materials_pvt. Update Material Reqst','+PPMRP+');
3718: -- Check if API is called in debug mode. If yes, disable debug.
3719: AHL_DEBUG_PUB.disable_debug;

Line 3717: AHL_DEBUG_PUB.debug( 'ahl_pp_materials_pvt. Update Material Reqst','+PPMRP+');

3713: p_data => x_msg_data);
3714: IF G_DEBUG='Y' THEN
3715: AHL_DEBUG_PUB.log_app_messages (
3716: x_msg_count, x_msg_data, 'ERROR' );
3717: AHL_DEBUG_PUB.debug( 'ahl_pp_materials_pvt. Update Material Reqst','+PPMRP+');
3718: -- Check if API is called in debug mode. If yes, disable debug.
3719: AHL_DEBUG_PUB.disable_debug;
3720: END IF;
3721: WHEN FND_API.G_EXC_ERROR THEN

Line 3719: AHL_DEBUG_PUB.disable_debug;

3715: AHL_DEBUG_PUB.log_app_messages (
3716: x_msg_count, x_msg_data, 'ERROR' );
3717: AHL_DEBUG_PUB.debug( 'ahl_pp_materials_pvt. Update Material Reqst','+PPMRP+');
3718: -- Check if API is called in debug mode. If yes, disable debug.
3719: AHL_DEBUG_PUB.disable_debug;
3720: END IF;
3721: WHEN FND_API.G_EXC_ERROR THEN
3722: ROLLBACK TO update_material_reqst;
3723: X_return_status := FND_API.G_RET_STS_ERROR;

Line 3729: AHL_DEBUG_PUB.log_app_messages (

3725: p_count => x_msg_count,
3726: p_data => X_msg_data);
3727: IF G_DEBUG='Y' THEN
3728: -- Debug info.
3729: AHL_DEBUG_PUB.log_app_messages (
3730: x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
3731: AHL_DEBUG_PUB.debug( 'ahl_pp_materials_pvt. Update Material Reqst','+PPMRP+');
3732: -- Check if API is called in debug mode. If yes, disable debug.
3733: AHL_DEBUG_PUB.disable_debug;

Line 3731: AHL_DEBUG_PUB.debug( 'ahl_pp_materials_pvt. Update Material Reqst','+PPMRP+');

3727: IF G_DEBUG='Y' THEN
3728: -- Debug info.
3729: AHL_DEBUG_PUB.log_app_messages (
3730: x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
3731: AHL_DEBUG_PUB.debug( 'ahl_pp_materials_pvt. Update Material Reqst','+PPMRP+');
3732: -- Check if API is called in debug mode. If yes, disable debug.
3733: AHL_DEBUG_PUB.disable_debug;
3734: END IF;
3735: WHEN OTHERS THEN

Line 3733: AHL_DEBUG_PUB.disable_debug;

3729: AHL_DEBUG_PUB.log_app_messages (
3730: x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
3731: AHL_DEBUG_PUB.debug( 'ahl_pp_materials_pvt. Update Material Reqst','+PPMRP+');
3732: -- Check if API is called in debug mode. If yes, disable debug.
3733: AHL_DEBUG_PUB.disable_debug;
3734: END IF;
3735: WHEN OTHERS THEN
3736: ROLLBACK TO update_material_reqst;
3737: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 3749: AHL_DEBUG_PUB.log_app_messages (

3745: p_count => x_msg_count,
3746: p_data => X_msg_data);
3747: IF G_DEBUG='Y' THEN
3748: -- Debug info.
3749: AHL_DEBUG_PUB.log_app_messages (
3750: x_msg_count, x_msg_data, 'SQL ERROR' );
3751: AHL_DEBUG_PUB.debug( 'ahl_pp_materials_pvt. Update Material Reqst','+PPMRP+');
3752: -- Check if API is called in debug mode. If yes, disable debug.
3753: AHL_DEBUG_PUB.disable_debug;

Line 3751: AHL_DEBUG_PUB.debug( 'ahl_pp_materials_pvt. Update Material Reqst','+PPMRP+');

3747: IF G_DEBUG='Y' THEN
3748: -- Debug info.
3749: AHL_DEBUG_PUB.log_app_messages (
3750: x_msg_count, x_msg_data, 'SQL ERROR' );
3751: AHL_DEBUG_PUB.debug( 'ahl_pp_materials_pvt. Update Material Reqst','+PPMRP+');
3752: -- Check if API is called in debug mode. If yes, disable debug.
3753: AHL_DEBUG_PUB.disable_debug;
3754: END IF;
3755: END Update_Material_Reqst;

Line 3753: AHL_DEBUG_PUB.disable_debug;

3749: AHL_DEBUG_PUB.log_app_messages (
3750: x_msg_count, x_msg_data, 'SQL ERROR' );
3751: AHL_DEBUG_PUB.debug( 'ahl_pp_materials_pvt. Update Material Reqst','+PPMRP+');
3752: -- Check if API is called in debug mode. If yes, disable debug.
3753: AHL_DEBUG_PUB.disable_debug;
3754: END IF;
3755: END Update_Material_Reqst;
3756: -- Start of Comments --
3757: -- Procedure name : Remove_Material_Reqst

Line 3927: Ahl_Debug_Pub.enable_debug;

3923: -- Standard Start of API savepoint
3924: SAVEPOINT remove_material_request;
3925: -- Check if API is called in debug mode. If yes, enable debug.
3926: IF G_DEBUG='Y' THEN
3927: Ahl_Debug_Pub.enable_debug;
3928: -- Debug info.
3929: Ahl_Debug_Pub.debug( 'enter ahl_pp_materials_pvt Remove Material Request ','+MAATP+');
3930: --
3931: END IF;

Line 3929: Ahl_Debug_Pub.debug( 'enter ahl_pp_materials_pvt Remove Material Request ','+MAATP+');

3925: -- Check if API is called in debug mode. If yes, enable debug.
3926: IF G_DEBUG='Y' THEN
3927: Ahl_Debug_Pub.enable_debug;
3928: -- Debug info.
3929: Ahl_Debug_Pub.debug( 'enter ahl_pp_materials_pvt Remove Material Request ','+MAATP+');
3930: --
3931: END IF;
3932: -- Standard call to check for call compatibility.
3933: IF Fnd_Api.to_boolean(p_init_msg_list)

Line 4005: Ahl_Debug_Pub.debug( 'Obj Number:'||p_x_req_material_tbl(i).object_version_number);

4001: Fnd_Msg_Pub.ADD;
4002: END IF;
4003: --
4004: IF G_DEBUG='Y' THEN
4005: Ahl_Debug_Pub.debug( 'Obj Number:'||p_x_req_material_tbl(i).object_version_number);
4006: Ahl_Debug_Pub.debug( 'Sch mat Id:'||p_x_req_material_tbl(i).schedule_material_id);
4007: END IF;
4008: -- Check for object version number
4009: IF (p_x_req_material_tbl(i).object_version_number IS NOT NULL AND

Line 4006: Ahl_Debug_Pub.debug( 'Sch mat Id:'||p_x_req_material_tbl(i).schedule_material_id);

4002: END IF;
4003: --
4004: IF G_DEBUG='Y' THEN
4005: Ahl_Debug_Pub.debug( 'Obj Number:'||p_x_req_material_tbl(i).object_version_number);
4006: Ahl_Debug_Pub.debug( 'Sch mat Id:'||p_x_req_material_tbl(i).schedule_material_id);
4007: END IF;
4008: -- Check for object version number
4009: IF (p_x_req_material_tbl(i).object_version_number IS NOT NULL AND
4010: p_x_req_material_tbl(i).object_version_number <> FND_API.G_MISS_NUM) THEN

Line 4036: Ahl_Debug_Pub.debug( 'before wip jobs call:');

4032: END LOOP;
4033: END IF;
4034: --
4035: IF G_DEBUG='Y' THEN
4036: Ahl_Debug_Pub.debug( 'before wip jobs call:');
4037: END IF;
4038: --
4039: IF p_x_req_material_tbl.COUNT >0 THEN
4040: j := 1;

Line 4078: AHL_DEBUG_PUB.debug('Reserved quantity for sch. material ID:' || p_x_req_material_tbl(i).schedule_material_id || ' is: ' || l_reserved_quantity || 'for INV ID: ' || l_material_rec.inventory_item_id);

4074: FETCH get_count_resrv_cur INTO l_reserved_quantity;
4075: CLOSE get_count_resrv_cur;
4076: IF (l_reserved_quantity > 0) THEN
4077: IF G_DEBUG='Y' THEN
4078: AHL_DEBUG_PUB.debug('Reserved quantity for sch. material ID:' || p_x_req_material_tbl(i).schedule_material_id || ' is: ' || l_reserved_quantity || 'for INV ID: ' || l_material_rec.inventory_item_id);
4079: AHL_DEBUG_PUB.debug('Before calling delete reservation api');
4080: END IF;
4081: -- delete reservations.
4082: AHL_RSV_RESERVATIONS_PVT.DELETE_RESERVATION(

Line 4079: AHL_DEBUG_PUB.debug('Before calling delete reservation api');

4075: CLOSE get_count_resrv_cur;
4076: IF (l_reserved_quantity > 0) THEN
4077: IF G_DEBUG='Y' THEN
4078: AHL_DEBUG_PUB.debug('Reserved quantity for sch. material ID:' || p_x_req_material_tbl(i).schedule_material_id || ' is: ' || l_reserved_quantity || 'for INV ID: ' || l_material_rec.inventory_item_id);
4079: AHL_DEBUG_PUB.debug('Before calling delete reservation api');
4080: END IF;
4081: -- delete reservations.
4082: AHL_RSV_RESERVATIONS_PVT.DELETE_RESERVATION(
4083: p_api_version => 1.0,

Line 4092: AHL_DEBUG_PUB.debug('After calling delete reservation api. Return status:' || x_return_status);

4088: x_msg_count => x_msg_count,
4089: x_msg_data => x_msg_data,
4090: p_scheduled_material_id => p_x_req_material_tbl(i).schedule_material_id);
4091: IF G_DEBUG='Y' THEN
4092: AHL_DEBUG_PUB.debug('After calling delete reservation api. Return status:' || x_return_status);
4093: END IF;
4094: -- check return status.
4095: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
4096: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 4104: AHL_DEBUG_PUB.debug('beforer Eam wip job call');

4100: END IF;
4101: END LOOP;
4102: END IF; --Material tbl
4103: IF G_DEBUG='Y' THEN
4104: AHL_DEBUG_PUB.debug('beforer Eam wip job call');
4105: END IF;
4106: -- Call wip job api
4107: AHL_EAM_JOB_PVT.process_material_req
4108: (

Line 4122: AHL_DEBUG_PUB.debug('after wip job call');

4118: p_material_req_tbl => l_req_material_tbl
4119: );
4120: --
4121: IF G_DEBUG='Y' THEN
4122: AHL_DEBUG_PUB.debug('after wip job call');
4123: END IF;
4124: IF l_return_Status = 'S' THEN
4125: --Remove the records
4126: IF p_x_req_material_tbl.COUNT > 0 THEN

Line 4140: AHL_DEBUG_PUB.debug('after set request quantity to zero');

4136: WHERE SCHEDULED_MATERIAL_ID = p_x_req_material_tbl(i).schedule_material_id;
4137: END IF;
4138: --
4139: IF G_DEBUG='Y' THEN
4140: AHL_DEBUG_PUB.debug('after set request quantity to zero');
4141: END IF;
4142: --
4143: END LOOP;
4144: END IF;

Line 4169: Ahl_Debug_Pub.debug( 'End of private api Remove Material Request ','+MAMRP+');

4165: COMMIT;
4166: END IF;
4167: -- Debug info
4168: IF G_DEBUG='Y' THEN
4169: Ahl_Debug_Pub.debug( 'End of private api Remove Material Request ','+MAMRP+');
4170: -- Check if API is called in debug mode. If yes, disable debug.
4171: Ahl_Debug_Pub.disable_debug;
4172: END IF;
4173: EXCEPTION

Line 4171: Ahl_Debug_Pub.disable_debug;

4167: -- Debug info
4168: IF G_DEBUG='Y' THEN
4169: Ahl_Debug_Pub.debug( 'End of private api Remove Material Request ','+MAMRP+');
4170: -- Check if API is called in debug mode. If yes, disable debug.
4171: Ahl_Debug_Pub.disable_debug;
4172: END IF;
4173: EXCEPTION
4174: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
4175: ROLLBACK TO remove_material_request;

Line 4181: Ahl_Debug_Pub.log_app_messages (

4177: Fnd_Msg_Pub.count_and_get( p_encoded => Fnd_Api.G_FALSE,
4178: p_count => x_msg_count,
4179: p_data => x_msg_data);
4180: IF G_DEBUG='Y' THEN
4181: Ahl_Debug_Pub.log_app_messages (
4182: x_msg_count, x_msg_data, 'ERROR' );
4183: Ahl_Debug_Pub.debug( 'ahl_pp_materials_pvt. Remove Material Request ','+MAMRP+');
4184: -- Check if API is called in debug mode. If yes, disable debug.
4185: Ahl_Debug_Pub.disable_debug;

Line 4183: Ahl_Debug_Pub.debug( 'ahl_pp_materials_pvt. Remove Material Request ','+MAMRP+');

4179: p_data => x_msg_data);
4180: IF G_DEBUG='Y' THEN
4181: Ahl_Debug_Pub.log_app_messages (
4182: x_msg_count, x_msg_data, 'ERROR' );
4183: Ahl_Debug_Pub.debug( 'ahl_pp_materials_pvt. Remove Material Request ','+MAMRP+');
4184: -- Check if API is called in debug mode. If yes, disable debug.
4185: Ahl_Debug_Pub.disable_debug;
4186: END IF;
4187: WHEN Fnd_Api.G_EXC_ERROR THEN

Line 4185: Ahl_Debug_Pub.disable_debug;

4181: Ahl_Debug_Pub.log_app_messages (
4182: x_msg_count, x_msg_data, 'ERROR' );
4183: Ahl_Debug_Pub.debug( 'ahl_pp_materials_pvt. Remove Material Request ','+MAMRP+');
4184: -- Check if API is called in debug mode. If yes, disable debug.
4185: Ahl_Debug_Pub.disable_debug;
4186: END IF;
4187: WHEN Fnd_Api.G_EXC_ERROR THEN
4188: ROLLBACK TO remove_material_request;
4189: X_return_status := Fnd_Api.G_RET_STS_ERROR;

Line 4195: Ahl_Debug_Pub.log_app_messages (

4191: p_count => x_msg_count,
4192: p_data => X_msg_data);
4193: IF G_DEBUG='Y' THEN
4194: -- Debug info.
4195: Ahl_Debug_Pub.log_app_messages (
4196: x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
4197: Ahl_Debug_Pub.debug( 'ahl_pp_materials_pvt. Remove Material Request ','+MAMRP+');
4198: -- Check if API is called in debug mode. If yes, disable debug.
4199: Ahl_Debug_Pub.disable_debug;

Line 4197: Ahl_Debug_Pub.debug( 'ahl_pp_materials_pvt. Remove Material Request ','+MAMRP+');

4193: IF G_DEBUG='Y' THEN
4194: -- Debug info.
4195: Ahl_Debug_Pub.log_app_messages (
4196: x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
4197: Ahl_Debug_Pub.debug( 'ahl_pp_materials_pvt. Remove Material Request ','+MAMRP+');
4198: -- Check if API is called in debug mode. If yes, disable debug.
4199: Ahl_Debug_Pub.disable_debug;
4200: END IF;
4201: WHEN OTHERS THEN

Line 4199: Ahl_Debug_Pub.disable_debug;

4195: Ahl_Debug_Pub.log_app_messages (
4196: x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
4197: Ahl_Debug_Pub.debug( 'ahl_pp_materials_pvt. Remove Material Request ','+MAMRP+');
4198: -- Check if API is called in debug mode. If yes, disable debug.
4199: Ahl_Debug_Pub.disable_debug;
4200: END IF;
4201: WHEN OTHERS THEN
4202: ROLLBACK TO remove_material_request;
4203: X_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

Line 4215: Ahl_Debug_Pub.log_app_messages (

4211: p_count => x_msg_count,
4212: p_data => X_msg_data);
4213: IF G_DEBUG='Y' THEN
4214: -- Debug info.
4215: Ahl_Debug_Pub.log_app_messages (
4216: x_msg_count, x_msg_data, 'SQL ERROR' );
4217: Ahl_Debug_Pub.debug( 'ahl_pp_materials_pvt. Remove Material Request ','+MTMRP+');
4218: -- Check if API is called in debug mode. If yes, disable debug.
4219: Ahl_Debug_Pub.disable_debug;

Line 4217: Ahl_Debug_Pub.debug( 'ahl_pp_materials_pvt. Remove Material Request ','+MTMRP+');

4213: IF G_DEBUG='Y' THEN
4214: -- Debug info.
4215: Ahl_Debug_Pub.log_app_messages (
4216: x_msg_count, x_msg_data, 'SQL ERROR' );
4217: Ahl_Debug_Pub.debug( 'ahl_pp_materials_pvt. Remove Material Request ','+MTMRP+');
4218: -- Check if API is called in debug mode. If yes, disable debug.
4219: Ahl_Debug_Pub.disable_debug;
4220: END IF;
4221: END Remove_Material_Request;

Line 4219: Ahl_Debug_Pub.disable_debug;

4215: Ahl_Debug_Pub.log_app_messages (
4216: x_msg_count, x_msg_data, 'SQL ERROR' );
4217: Ahl_Debug_Pub.debug( 'ahl_pp_materials_pvt. Remove Material Request ','+MTMRP+');
4218: -- Check if API is called in debug mode. If yes, disable debug.
4219: Ahl_Debug_Pub.disable_debug;
4220: END IF;
4221: END Remove_Material_Request;
4222:
4223: -- Start of Comments --

Line 4514: AHL_DEBUG_PUB.debug( 'before calling log record l_wo_operation_txn_id:'||l_wo_operation_txn_id);

4510:
4511: SELECT AHL_WO_OPERATIONS_TXNS_S.NEXTVAL INTO l_wo_operation_txn_id FROM DUAL;
4512: --
4513: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
4514: AHL_DEBUG_PUB.debug( 'before calling log record l_wo_operation_txn_id:'||l_wo_operation_txn_id);
4515: END IF;
4516: --Create Record in transactions table
4517: Log_Transaction_Record
4518: ( p_wo_operation_txn_id => l_wo_operation_txn_id,

Line 4623: AHL_DEBUG_PUB.debug( 'After calling log record l_wo_operation_txn_id:'||l_wo_operation_txn_id);

4619: p_required_quantity => p_x_req_material_tbl(i).requested_quantity,
4620: p_date_required => p_x_req_material_tbl(i).requested_date
4621: );
4622: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
4623: AHL_DEBUG_PUB.debug( 'After calling log record l_wo_operation_txn_id:'||l_wo_operation_txn_id);
4624: END IF;
4625:
4626: l_material_req_cr_tbl(cr_index).schedule_material_id := l_schedule_material_id;
4627: l_material_req_cr_tbl(cr_index).job_number := l_workorder_name;

Line 4649: AHL_DEBUG_PUB.debug( 'Invalid Scedule Material Id: '||l_schedule_material_id);

4645: END IF; -- End of existance of WIP requirement for the original item check.
4646: END IF; -- End of item changed check.
4647: ELSE
4648: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
4649: AHL_DEBUG_PUB.debug( 'Invalid Scedule Material Id: '||l_schedule_material_id);
4650: END IF;
4651: Fnd_Message.SET_NAME('AHL','AHL_RSV_INVALID_MTRLREQ'); -- Material Requirement is Invalid.
4652: Fnd_Msg_Pub.ADD;
4653: END IF; -- End of existance of ASM requirement for the original item check.

Line 4879: AHL_DEBUG_PUB.enable_debug;

4875: -- Standard Start of API savepoint
4876: SAVEPOINT process_material_request;
4877: -- Check if API is called in debug mode. If yes, enable debug.
4878: IF G_DEBUG='Y' THEN
4879: AHL_DEBUG_PUB.enable_debug;
4880: -- Debug info.
4881: AHL_DEBUG_PUB.debug( 'enter ahl_pp_materias_pvt.process material request','+PPMRP+');
4882: --
4883: END IF;

Line 4881: AHL_DEBUG_PUB.debug( 'enter ahl_pp_materias_pvt.process material request','+PPMRP+');

4877: -- Check if API is called in debug mode. If yes, enable debug.
4878: IF G_DEBUG='Y' THEN
4879: AHL_DEBUG_PUB.enable_debug;
4880: -- Debug info.
4881: AHL_DEBUG_PUB.debug( 'enter ahl_pp_materias_pvt.process material request','+PPMRP+');
4882: --
4883: END IF;
4884: -- Standard call to check for call compatibility.
4885: IF FND_API.to_boolean(p_init_msg_list)

Line 4901: Ahl_Debug_Pub.debug( 'p_x_req_material_tbl.COUNT= '||p_x_req_material_tbl.COUNT,'+PPMRP+');

4897: END IF;
4898: --------------------Start of API Body-----------------------------------
4899: --debadey:logging
4900: IF G_DEBUG='Y' THEN
4901: Ahl_Debug_Pub.debug( 'p_x_req_material_tbl.COUNT= '||p_x_req_material_tbl.COUNT,'+PPMRP+');
4902: Ahl_Debug_Pub.debug( 'p_x_req_material_tbl(1).operation_flag= '||p_x_req_material_tbl(1).operation_flag,'+PPMRP+');
4903: -- Check if API is called in debug mode. If yes, disable debug.
4904: Ahl_Debug_Pub.disable_debug;
4905: END IF;

Line 4902: Ahl_Debug_Pub.debug( 'p_x_req_material_tbl(1).operation_flag= '||p_x_req_material_tbl(1).operation_flag,'+PPMRP+');

4898: --------------------Start of API Body-----------------------------------
4899: --debadey:logging
4900: IF G_DEBUG='Y' THEN
4901: Ahl_Debug_Pub.debug( 'p_x_req_material_tbl.COUNT= '||p_x_req_material_tbl.COUNT,'+PPMRP+');
4902: Ahl_Debug_Pub.debug( 'p_x_req_material_tbl(1).operation_flag= '||p_x_req_material_tbl(1).operation_flag,'+PPMRP+');
4903: -- Check if API is called in debug mode. If yes, disable debug.
4904: Ahl_Debug_Pub.disable_debug;
4905: END IF;
4906: --debadey:logging end

Line 4904: Ahl_Debug_Pub.disable_debug;

4900: IF G_DEBUG='Y' THEN
4901: Ahl_Debug_Pub.debug( 'p_x_req_material_tbl.COUNT= '||p_x_req_material_tbl.COUNT,'+PPMRP+');
4902: Ahl_Debug_Pub.debug( 'p_x_req_material_tbl(1).operation_flag= '||p_x_req_material_tbl(1).operation_flag,'+PPMRP+');
4903: -- Check if API is called in debug mode. If yes, disable debug.
4904: Ahl_Debug_Pub.disable_debug;
4905: END IF;
4906: --debadey:logging end
4907:
4908: IF p_x_req_material_tbl.COUNT > 0 THEN

Line 4922: Ahl_Debug_Pub.debug( 'p_x_req_material_tbl(i).AOG_FLAG= '||p_x_req_material_tbl(i).AOG_FLAG,'+PPMRP+');

4918: l_req_up_material_tbl(i) := p_x_req_material_tbl(i);
4919: -- Added for AOG notification by debadey
4920: --debadey:logging
4921: IF G_DEBUG='Y' THEN
4922: Ahl_Debug_Pub.debug( 'p_x_req_material_tbl(i).AOG_FLAG= '||p_x_req_material_tbl(i).AOG_FLAG,'+PPMRP+');
4923: Ahl_Debug_Pub.debug( 'p_x_req_material_tbl(i).SCHEDULE_MATERIAL_ID= '||p_x_req_material_tbl(i).SCHEDULE_MATERIAL_ID,'+PPMRP+');
4924: -- Check if API is called in debug mode. If yes, disable debug.
4925: Ahl_Debug_Pub.disable_debug;
4926: END IF;

Line 4923: Ahl_Debug_Pub.debug( 'p_x_req_material_tbl(i).SCHEDULE_MATERIAL_ID= '||p_x_req_material_tbl(i).SCHEDULE_MATERIAL_ID,'+PPMRP+');

4919: -- Added for AOG notification by debadey
4920: --debadey:logging
4921: IF G_DEBUG='Y' THEN
4922: Ahl_Debug_Pub.debug( 'p_x_req_material_tbl(i).AOG_FLAG= '||p_x_req_material_tbl(i).AOG_FLAG,'+PPMRP+');
4923: Ahl_Debug_Pub.debug( 'p_x_req_material_tbl(i).SCHEDULE_MATERIAL_ID= '||p_x_req_material_tbl(i).SCHEDULE_MATERIAL_ID,'+PPMRP+');
4924: -- Check if API is called in debug mode. If yes, disable debug.
4925: Ahl_Debug_Pub.disable_debug;
4926: END IF;
4927: --debadey:logging end

Line 4925: Ahl_Debug_Pub.disable_debug;

4921: IF G_DEBUG='Y' THEN
4922: Ahl_Debug_Pub.debug( 'p_x_req_material_tbl(i).AOG_FLAG= '||p_x_req_material_tbl(i).AOG_FLAG,'+PPMRP+');
4923: Ahl_Debug_Pub.debug( 'p_x_req_material_tbl(i).SCHEDULE_MATERIAL_ID= '||p_x_req_material_tbl(i).SCHEDULE_MATERIAL_ID,'+PPMRP+');
4924: -- Check if API is called in debug mode. If yes, disable debug.
4925: Ahl_Debug_Pub.disable_debug;
4926: END IF;
4927: --debadey:logging end
4928: IF (p_x_req_material_tbl(i).AOG_FLAG = 'Y')
4929: THEN

Line 4988: Ahl_Debug_Pub.debug( 'l_req_cr_material_tbl(i).AOG_FLAG= '||p_x_req_material_tbl(i).AOG_FLAG,'+PPMRP+');

4984: p_x_req_material_tbl(i).SCHEDULE_MATERIAL_ID := l_req_cr_material_tbl(i).SCHEDULE_MATERIAL_ID;
4985: -- Added by debadey for AOG notification
4986:
4987: IF G_DEBUG='Y' THEN
4988: Ahl_Debug_Pub.debug( 'l_req_cr_material_tbl(i).AOG_FLAG= '||p_x_req_material_tbl(i).AOG_FLAG,'+PPMRP+');
4989: Ahl_Debug_Pub.debug( 'l_req_cr_material_tbl(i).SCHEDULE_MATERIAL_ID= '||p_x_req_material_tbl(i).SCHEDULE_MATERIAL_ID,'+PPMRP+');
4990: -- Check if API is called in debug mode. If yes, disable debug.
4991: Ahl_Debug_Pub.disable_debug;
4992: END IF;

Line 4989: Ahl_Debug_Pub.debug( 'l_req_cr_material_tbl(i).SCHEDULE_MATERIAL_ID= '||p_x_req_material_tbl(i).SCHEDULE_MATERIAL_ID,'+PPMRP+');

4985: -- Added by debadey for AOG notification
4986:
4987: IF G_DEBUG='Y' THEN
4988: Ahl_Debug_Pub.debug( 'l_req_cr_material_tbl(i).AOG_FLAG= '||p_x_req_material_tbl(i).AOG_FLAG,'+PPMRP+');
4989: Ahl_Debug_Pub.debug( 'l_req_cr_material_tbl(i).SCHEDULE_MATERIAL_ID= '||p_x_req_material_tbl(i).SCHEDULE_MATERIAL_ID,'+PPMRP+');
4990: -- Check if API is called in debug mode. If yes, disable debug.
4991: Ahl_Debug_Pub.disable_debug;
4992: END IF;
4993:

Line 4991: Ahl_Debug_Pub.disable_debug;

4987: IF G_DEBUG='Y' THEN
4988: Ahl_Debug_Pub.debug( 'l_req_cr_material_tbl(i).AOG_FLAG= '||p_x_req_material_tbl(i).AOG_FLAG,'+PPMRP+');
4989: Ahl_Debug_Pub.debug( 'l_req_cr_material_tbl(i).SCHEDULE_MATERIAL_ID= '||p_x_req_material_tbl(i).SCHEDULE_MATERIAL_ID,'+PPMRP+');
4990: -- Check if API is called in debug mode. If yes, disable debug.
4991: Ahl_Debug_Pub.disable_debug;
4992: END IF;
4993:
4994: IF (l_req_cr_material_tbl(i).AOG_FLAG = 'Y')
4995: THEN

Line 5079: Ahl_Debug_Pub.debug( 'No. of asm ids for which notification to be sent = '||l_asm_id_tbl.COUNT,'+PPMRP+');

5075: IF (l_asm_id_tbl IS NOT NULL AND l_asm_id_tbl.COUNT > 0)
5076: THEN
5077: --debadey:logging
5078: IF (G_DEBUG='Y') THEN
5079: Ahl_Debug_Pub.debug( 'No. of asm ids for which notification to be sent = '||l_asm_id_tbl.COUNT,'+PPMRP+');
5080: -- Check if API is called in debug mode. If yes, disable debug.
5081: Ahl_Debug_Pub.disable_debug;
5082: END IF;
5083: --debadey:logging end

Line 5081: Ahl_Debug_Pub.disable_debug;

5077: --debadey:logging
5078: IF (G_DEBUG='Y') THEN
5079: Ahl_Debug_Pub.debug( 'No. of asm ids for which notification to be sent = '||l_asm_id_tbl.COUNT,'+PPMRP+');
5080: -- Check if API is called in debug mode. If yes, disable debug.
5081: Ahl_Debug_Pub.disable_debug;
5082: END IF;
5083: --debadey:logging end
5084:
5085: AHL_MM_MTL_MGT_PVT.aog_upd_notification(p_api_version => p_api_version,

Line 5116: Ahl_Debug_Pub.debug( 'End of public api Process Material Request','+PPMRP+');

5112: COMMIT;
5113: END IF;
5114: -- Debug info
5115: IF G_DEBUG='Y' THEN
5116: Ahl_Debug_Pub.debug( 'End of public api Process Material Request','+PPMRP+');
5117: -- Check if API is called in debug mode. If yes, disable debug.
5118: Ahl_Debug_Pub.disable_debug;
5119: --
5120: END IF;

Line 5118: Ahl_Debug_Pub.disable_debug;

5114: -- Debug info
5115: IF G_DEBUG='Y' THEN
5116: Ahl_Debug_Pub.debug( 'End of public api Process Material Request','+PPMRP+');
5117: -- Check if API is called in debug mode. If yes, disable debug.
5118: Ahl_Debug_Pub.disable_debug;
5119: --
5120: END IF;
5121: EXCEPTION
5122: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 5129: AHL_DEBUG_PUB.log_app_messages (

5125: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
5126: p_count => x_msg_count,
5127: p_data => x_msg_data);
5128: IF G_DEBUG='Y' THEN
5129: AHL_DEBUG_PUB.log_app_messages (
5130: x_msg_count, x_msg_data, 'ERROR' );
5131: AHL_DEBUG_PUB.debug( 'ahl_pp_materials_pvt. Process Material Request','+PPMRP+');
5132: -- Check if API is called in debug mode. If yes, disable debug.
5133: AHL_DEBUG_PUB.disable_debug;

Line 5131: AHL_DEBUG_PUB.debug( 'ahl_pp_materials_pvt. Process Material Request','+PPMRP+');

5127: p_data => x_msg_data);
5128: IF G_DEBUG='Y' THEN
5129: AHL_DEBUG_PUB.log_app_messages (
5130: x_msg_count, x_msg_data, 'ERROR' );
5131: AHL_DEBUG_PUB.debug( 'ahl_pp_materials_pvt. Process Material Request','+PPMRP+');
5132: -- Check if API is called in debug mode. If yes, disable debug.
5133: AHL_DEBUG_PUB.disable_debug;
5134: END IF;
5135: WHEN FND_API.G_EXC_ERROR THEN

Line 5133: AHL_DEBUG_PUB.disable_debug;

5129: AHL_DEBUG_PUB.log_app_messages (
5130: x_msg_count, x_msg_data, 'ERROR' );
5131: AHL_DEBUG_PUB.debug( 'ahl_pp_materials_pvt. Process Material Request','+PPMRP+');
5132: -- Check if API is called in debug mode. If yes, disable debug.
5133: AHL_DEBUG_PUB.disable_debug;
5134: END IF;
5135: WHEN FND_API.G_EXC_ERROR THEN
5136: ROLLBACK TO process_material_request;
5137: X_return_status := FND_API.G_RET_STS_ERROR;

Line 5143: AHL_DEBUG_PUB.log_app_messages (

5139: p_count => x_msg_count,
5140: p_data => X_msg_data);
5141: IF G_DEBUG='Y' THEN
5142: -- Debug info.
5143: AHL_DEBUG_PUB.log_app_messages (
5144: x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
5145: AHL_DEBUG_PUB.debug( 'ahl_pp_materials_pvt. Process Material Request','+PPMRP+');
5146: -- Check if API is called in debug mode. If yes, disable debug.
5147: AHL_DEBUG_PUB.disable_debug;

Line 5145: AHL_DEBUG_PUB.debug( 'ahl_pp_materials_pvt. Process Material Request','+PPMRP+');

5141: IF G_DEBUG='Y' THEN
5142: -- Debug info.
5143: AHL_DEBUG_PUB.log_app_messages (
5144: x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
5145: AHL_DEBUG_PUB.debug( 'ahl_pp_materials_pvt. Process Material Request','+PPMRP+');
5146: -- Check if API is called in debug mode. If yes, disable debug.
5147: AHL_DEBUG_PUB.disable_debug;
5148: --
5149: END IF;

Line 5147: AHL_DEBUG_PUB.disable_debug;

5143: AHL_DEBUG_PUB.log_app_messages (
5144: x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
5145: AHL_DEBUG_PUB.debug( 'ahl_pp_materials_pvt. Process Material Request','+PPMRP+');
5146: -- Check if API is called in debug mode. If yes, disable debug.
5147: AHL_DEBUG_PUB.disable_debug;
5148: --
5149: END IF;
5150: WHEN OTHERS THEN
5151: ROLLBACK TO process_material_request;

Line 5164: AHL_DEBUG_PUB.log_app_messages (

5160: p_count => x_msg_count,
5161: p_data => X_msg_data);
5162: IF G_DEBUG='Y' THEN
5163: -- Debug info.
5164: AHL_DEBUG_PUB.log_app_messages (
5165: x_msg_count, x_msg_data, 'SQL ERROR' );
5166: AHL_DEBUG_PUB.debug( 'ahl_pp_materials_pvt. Process Material Request','+PPMRP+');
5167: -- Check if API is called in debug mode. If yes, disable debug.
5168: AHL_DEBUG_PUB.disable_debug;

Line 5166: AHL_DEBUG_PUB.debug( 'ahl_pp_materials_pvt. Process Material Request','+PPMRP+');

5162: IF G_DEBUG='Y' THEN
5163: -- Debug info.
5164: AHL_DEBUG_PUB.log_app_messages (
5165: x_msg_count, x_msg_data, 'SQL ERROR' );
5166: AHL_DEBUG_PUB.debug( 'ahl_pp_materials_pvt. Process Material Request','+PPMRP+');
5167: -- Check if API is called in debug mode. If yes, disable debug.
5168: AHL_DEBUG_PUB.disable_debug;
5169: END IF;
5170: END Process_Material_Request;

Line 5168: AHL_DEBUG_PUB.disable_debug;

5164: AHL_DEBUG_PUB.log_app_messages (
5165: x_msg_count, x_msg_data, 'SQL ERROR' );
5166: AHL_DEBUG_PUB.debug( 'ahl_pp_materials_pvt. Process Material Request','+PPMRP+');
5167: -- Check if API is called in debug mode. If yes, disable debug.
5168: AHL_DEBUG_PUB.disable_debug;
5169: END IF;
5170: END Process_Material_Request;
5171: --
5172: -- aps obsoleted

Line 5993: AHL_DEBUG_PUB.debug( 'x_req_material_tbl(i).workorder_id'||x_req_material_tbl(i).workorder_id);

5989: IF x_req_material_tbl.count > 0 THEN
5990: FOR i IN x_req_material_tbl.FIRST..x_req_material_tbl.LAST
5991: LOOP
5992: IF G_DEBUG='Y' THEN
5993: AHL_DEBUG_PUB.debug( 'x_req_material_tbl(i).workorder_id'||x_req_material_tbl(i).workorder_id);
5994: AHL_DEBUG_PUB.debug( 'x_req_material_tbl(i).organization_id'||x_req_material_tbl(i).organization_id);
5995: AHL_DEBUG_PUB.debug( 'x_req_material_tbl(i).workorder_operation_id'||x_req_material_tbl(i).workorder_operation_id);
5996: AHL_DEBUG_PUB.debug( 'x_req_material_tbl(i).operation_sequence'||x_req_material_tbl(i).operation_sequence);
5997: AHL_DEBUG_PUB.debug( 'x_req_material_tbl(i).inventory_item_id'||x_req_material_tbl(i).inventory_item_id);

Line 5994: AHL_DEBUG_PUB.debug( 'x_req_material_tbl(i).organization_id'||x_req_material_tbl(i).organization_id);

5990: FOR i IN x_req_material_tbl.FIRST..x_req_material_tbl.LAST
5991: LOOP
5992: IF G_DEBUG='Y' THEN
5993: AHL_DEBUG_PUB.debug( 'x_req_material_tbl(i).workorder_id'||x_req_material_tbl(i).workorder_id);
5994: AHL_DEBUG_PUB.debug( 'x_req_material_tbl(i).organization_id'||x_req_material_tbl(i).organization_id);
5995: AHL_DEBUG_PUB.debug( 'x_req_material_tbl(i).workorder_operation_id'||x_req_material_tbl(i).workorder_operation_id);
5996: AHL_DEBUG_PUB.debug( 'x_req_material_tbl(i).operation_sequence'||x_req_material_tbl(i).operation_sequence);
5997: AHL_DEBUG_PUB.debug( 'x_req_material_tbl(i).inventory_item_id'||x_req_material_tbl(i).inventory_item_id);
5998: AHL_DEBUG_PUB.debug( 'x_req_material_tbl(i).requested_date'||x_req_material_tbl(i).requested_date);

Line 5995: AHL_DEBUG_PUB.debug( 'x_req_material_tbl(i).workorder_operation_id'||x_req_material_tbl(i).workorder_operation_id);

5991: LOOP
5992: IF G_DEBUG='Y' THEN
5993: AHL_DEBUG_PUB.debug( 'x_req_material_tbl(i).workorder_id'||x_req_material_tbl(i).workorder_id);
5994: AHL_DEBUG_PUB.debug( 'x_req_material_tbl(i).organization_id'||x_req_material_tbl(i).organization_id);
5995: AHL_DEBUG_PUB.debug( 'x_req_material_tbl(i).workorder_operation_id'||x_req_material_tbl(i).workorder_operation_id);
5996: AHL_DEBUG_PUB.debug( 'x_req_material_tbl(i).operation_sequence'||x_req_material_tbl(i).operation_sequence);
5997: AHL_DEBUG_PUB.debug( 'x_req_material_tbl(i).inventory_item_id'||x_req_material_tbl(i).inventory_item_id);
5998: AHL_DEBUG_PUB.debug( 'x_req_material_tbl(i).requested_date'||x_req_material_tbl(i).requested_date);
5999: END IF;

Line 5996: AHL_DEBUG_PUB.debug( 'x_req_material_tbl(i).operation_sequence'||x_req_material_tbl(i).operation_sequence);

5992: IF G_DEBUG='Y' THEN
5993: AHL_DEBUG_PUB.debug( 'x_req_material_tbl(i).workorder_id'||x_req_material_tbl(i).workorder_id);
5994: AHL_DEBUG_PUB.debug( 'x_req_material_tbl(i).organization_id'||x_req_material_tbl(i).organization_id);
5995: AHL_DEBUG_PUB.debug( 'x_req_material_tbl(i).workorder_operation_id'||x_req_material_tbl(i).workorder_operation_id);
5996: AHL_DEBUG_PUB.debug( 'x_req_material_tbl(i).operation_sequence'||x_req_material_tbl(i).operation_sequence);
5997: AHL_DEBUG_PUB.debug( 'x_req_material_tbl(i).inventory_item_id'||x_req_material_tbl(i).inventory_item_id);
5998: AHL_DEBUG_PUB.debug( 'x_req_material_tbl(i).requested_date'||x_req_material_tbl(i).requested_date);
5999: END IF;
6000: END LOOP;

Line 5997: AHL_DEBUG_PUB.debug( 'x_req_material_tbl(i).inventory_item_id'||x_req_material_tbl(i).inventory_item_id);

5993: AHL_DEBUG_PUB.debug( 'x_req_material_tbl(i).workorder_id'||x_req_material_tbl(i).workorder_id);
5994: AHL_DEBUG_PUB.debug( 'x_req_material_tbl(i).organization_id'||x_req_material_tbl(i).organization_id);
5995: AHL_DEBUG_PUB.debug( 'x_req_material_tbl(i).workorder_operation_id'||x_req_material_tbl(i).workorder_operation_id);
5996: AHL_DEBUG_PUB.debug( 'x_req_material_tbl(i).operation_sequence'||x_req_material_tbl(i).operation_sequence);
5997: AHL_DEBUG_PUB.debug( 'x_req_material_tbl(i).inventory_item_id'||x_req_material_tbl(i).inventory_item_id);
5998: AHL_DEBUG_PUB.debug( 'x_req_material_tbl(i).requested_date'||x_req_material_tbl(i).requested_date);
5999: END IF;
6000: END LOOP;
6001: END IF;

Line 5998: AHL_DEBUG_PUB.debug( 'x_req_material_tbl(i).requested_date'||x_req_material_tbl(i).requested_date);

5994: AHL_DEBUG_PUB.debug( 'x_req_material_tbl(i).organization_id'||x_req_material_tbl(i).organization_id);
5995: AHL_DEBUG_PUB.debug( 'x_req_material_tbl(i).workorder_operation_id'||x_req_material_tbl(i).workorder_operation_id);
5996: AHL_DEBUG_PUB.debug( 'x_req_material_tbl(i).operation_sequence'||x_req_material_tbl(i).operation_sequence);
5997: AHL_DEBUG_PUB.debug( 'x_req_material_tbl(i).inventory_item_id'||x_req_material_tbl(i).inventory_item_id);
5998: AHL_DEBUG_PUB.debug( 'x_req_material_tbl(i).requested_date'||x_req_material_tbl(i).requested_date);
5999: END IF;
6000: END LOOP;
6001: END IF;
6002: IF G_DEBUG='Y' THEN

Line 6003: AHL_DEBUG_PUB.debug( 'x_req_material_tbl.count'||x_req_material_tbl.count);

5999: END IF;
6000: END LOOP;
6001: END IF;
6002: IF G_DEBUG='Y' THEN
6003: AHL_DEBUG_PUB.debug( 'x_req_material_tbl.count'||x_req_material_tbl.count);
6004: END IF;
6005: ------------------------End of Body---------------------------------------
6006: --Standard check to count messages
6007: l_msg_count := Fnd_Msg_Pub.count_msg;

Line 6372: AHL_DEBUG_PUB.debug('flex_fields_defaults.ATTRIBUTE_CATEGORY : ' || flex_fields_defaults.ATTRIBUTE_CATEGORY);

6368: ELSE
6369: flex_fields_defaults.ATTRIBUTE_CATEGORY := p_req_material_rec.ATTRIBUTE_CATEGORY;
6370: END IF;
6371: IF G_DEBUG='Y' THEN
6372: AHL_DEBUG_PUB.debug('flex_fields_defaults.ATTRIBUTE_CATEGORY : ' || flex_fields_defaults.ATTRIBUTE_CATEGORY);
6373: END IF;
6374: IF(flex_fields_defaults.ATTRIBUTE_CATEGORY IS NOT NULL)THEN
6375: fnd_dflex.get_contexts(flexfield, contexts);
6376: FOR j IN 1 .. contexts.ncontexts LOOP

Line 6515: AHL_DEBUG_PUB.enable_debug;

6511: -- Standard Start of API savepoint
6512: SAVEPOINT Wo_Mat_Req_Item_Change;
6513: -- Check if API is called in debug mode. If yes, enable debug.
6514: IF G_DEBUG='Y' THEN
6515: AHL_DEBUG_PUB.enable_debug;
6516: -- Debug info.
6517: AHL_DEBUG_PUB.debug( 'enter ahl_pp_materias_pvt.Wo_Mat_Req_Item_Change','+PPMRP+');
6518: --
6519: END IF;

Line 6517: AHL_DEBUG_PUB.debug( 'enter ahl_pp_materias_pvt.Wo_Mat_Req_Item_Change','+PPMRP+');

6513: -- Check if API is called in debug mode. If yes, enable debug.
6514: IF G_DEBUG='Y' THEN
6515: AHL_DEBUG_PUB.enable_debug;
6516: -- Debug info.
6517: AHL_DEBUG_PUB.debug( 'enter ahl_pp_materias_pvt.Wo_Mat_Req_Item_Change','+PPMRP+');
6518: --
6519: END IF;
6520:
6521: -- Standard call to check for call compatibility.

Line 6666: Ahl_Debug_Pub.debug( 'End of api Wo_Mat_Req_Item_Change','+PPMRP+');

6662: COMMIT;
6663: END IF;
6664: -- Debug info
6665: IF G_DEBUG='Y' THEN
6666: Ahl_Debug_Pub.debug( 'End of api Wo_Mat_Req_Item_Change','+PPMRP+');
6667: END IF;
6668: EXCEPTION
6669: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6670: ROLLBACK TO Wo_Mat_Req_Item_Change;

Line 6676: AHL_DEBUG_PUB.log_app_messages (

6672: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
6673: p_count => x_msg_count,
6674: p_data => x_msg_data);
6675: IF G_DEBUG='Y' THEN
6676: AHL_DEBUG_PUB.log_app_messages (
6677: x_msg_count, x_msg_data, 'ERROR' );
6678: AHL_DEBUG_PUB.debug( 'ahl_pp_materials_pvt.Wo_Mat_Req_Item_Change','+PPMRP+');
6679: -- Check if API is called in debug mode. If yes, disable debug.
6680: AHL_DEBUG_PUB.disable_debug;

Line 6678: AHL_DEBUG_PUB.debug( 'ahl_pp_materials_pvt.Wo_Mat_Req_Item_Change','+PPMRP+');

6674: p_data => x_msg_data);
6675: IF G_DEBUG='Y' THEN
6676: AHL_DEBUG_PUB.log_app_messages (
6677: x_msg_count, x_msg_data, 'ERROR' );
6678: AHL_DEBUG_PUB.debug( 'ahl_pp_materials_pvt.Wo_Mat_Req_Item_Change','+PPMRP+');
6679: -- Check if API is called in debug mode. If yes, disable debug.
6680: AHL_DEBUG_PUB.disable_debug;
6681: END IF;
6682: WHEN FND_API.G_EXC_ERROR THEN

Line 6680: AHL_DEBUG_PUB.disable_debug;

6676: AHL_DEBUG_PUB.log_app_messages (
6677: x_msg_count, x_msg_data, 'ERROR' );
6678: AHL_DEBUG_PUB.debug( 'ahl_pp_materials_pvt.Wo_Mat_Req_Item_Change','+PPMRP+');
6679: -- Check if API is called in debug mode. If yes, disable debug.
6680: AHL_DEBUG_PUB.disable_debug;
6681: END IF;
6682: WHEN FND_API.G_EXC_ERROR THEN
6683: ROLLBACK TO Wo_Mat_Req_Item_Change;
6684: X_return_status := FND_API.G_RET_STS_ERROR;

Line 6690: AHL_DEBUG_PUB.log_app_messages (

6686: p_count => x_msg_count,
6687: p_data => X_msg_data);
6688: IF G_DEBUG='Y' THEN
6689: -- Debug info.
6690: AHL_DEBUG_PUB.log_app_messages (
6691: x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
6692: AHL_DEBUG_PUB.debug( 'ahl_pp_materials_pvt.Wo_Mat_Req_Item_Change','+PPMRP+');
6693: -- Check if API is called in debug mode. If yes, disable debug.
6694: AHL_DEBUG_PUB.disable_debug;

Line 6692: AHL_DEBUG_PUB.debug( 'ahl_pp_materials_pvt.Wo_Mat_Req_Item_Change','+PPMRP+');

6688: IF G_DEBUG='Y' THEN
6689: -- Debug info.
6690: AHL_DEBUG_PUB.log_app_messages (
6691: x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
6692: AHL_DEBUG_PUB.debug( 'ahl_pp_materials_pvt.Wo_Mat_Req_Item_Change','+PPMRP+');
6693: -- Check if API is called in debug mode. If yes, disable debug.
6694: AHL_DEBUG_PUB.disable_debug;
6695: END IF;
6696: WHEN OTHERS THEN

Line 6694: AHL_DEBUG_PUB.disable_debug;

6690: AHL_DEBUG_PUB.log_app_messages (
6691: x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
6692: AHL_DEBUG_PUB.debug( 'ahl_pp_materials_pvt.Wo_Mat_Req_Item_Change','+PPMRP+');
6693: -- Check if API is called in debug mode. If yes, disable debug.
6694: AHL_DEBUG_PUB.disable_debug;
6695: END IF;
6696: WHEN OTHERS THEN
6697: ROLLBACK TO Wo_Mat_Req_Item_Change;
6698: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 6710: AHL_DEBUG_PUB.log_app_messages (

6706: p_count => x_msg_count,
6707: p_data => X_msg_data);
6708: IF G_DEBUG='Y' THEN
6709: -- Debug info.
6710: AHL_DEBUG_PUB.log_app_messages (
6711: x_msg_count, x_msg_data, 'SQL ERROR' );
6712: AHL_DEBUG_PUB.debug( 'ahl_pp_materials_pvt.Wo_Mat_Req_Item_Change','+PPMRP+');
6713: -- Check if API is called in debug mode. If yes, disable debug.
6714: AHL_DEBUG_PUB.disable_debug;

Line 6712: AHL_DEBUG_PUB.debug( 'ahl_pp_materials_pvt.Wo_Mat_Req_Item_Change','+PPMRP+');

6708: IF G_DEBUG='Y' THEN
6709: -- Debug info.
6710: AHL_DEBUG_PUB.log_app_messages (
6711: x_msg_count, x_msg_data, 'SQL ERROR' );
6712: AHL_DEBUG_PUB.debug( 'ahl_pp_materials_pvt.Wo_Mat_Req_Item_Change','+PPMRP+');
6713: -- Check if API is called in debug mode. If yes, disable debug.
6714: AHL_DEBUG_PUB.disable_debug;
6715: END IF;
6716:

Line 6714: AHL_DEBUG_PUB.disable_debug;

6710: AHL_DEBUG_PUB.log_app_messages (
6711: x_msg_count, x_msg_data, 'SQL ERROR' );
6712: AHL_DEBUG_PUB.debug( 'ahl_pp_materials_pvt.Wo_Mat_Req_Item_Change','+PPMRP+');
6713: -- Check if API is called in debug mode. If yes, disable debug.
6714: AHL_DEBUG_PUB.disable_debug;
6715: END IF;
6716:
6717: END Wo_Mat_Req_Item_Change;
6718: