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

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

3:
4: G_PKG_NAME VARCHAR2(30) := 'AHL_RM_MATERIAL_AS_PVT';
5: G_API_NAME VARCHAR2(30) := 'PROCESS_MATERIAL_REQ';
6: G_API_NAME1 VARCHAR2(30) := 'PROCESS_ROUTE_EFCTS';
7: G_DEBUG VARCHAR2(1) := AHL_DEBUG_PUB.is_log_enabled;
8:
9: -- Function to get the Record Identifier for Error Messages
10: FUNCTION get_record_identifier
11: (

Line 1948: AHL_DEBUG_PUB.debug( 'association_type : ' || l_association_type );

1944: l_material_req_rec.inventory_item_id,
1945: l_material_req_rec.inventory_org_id;
1946:
1947: IF G_DEBUG = 'Y' THEN
1948: AHL_DEBUG_PUB.debug( 'association_type : ' || l_association_type );
1949: AHL_DEBUG_PUB.debug( 'POSITION_PATH_ID : ' || l_material_req_rec.POSITION_PATH_ID);
1950: AHL_DEBUG_PUB.debug( 'item_group_id : ' || l_material_req_rec.item_group_id);
1951: AHL_DEBUG_PUB.debug( 'inventory_item_id : ' || l_material_req_rec.inventory_item_id);
1952: AHL_DEBUG_PUB.debug( 'inventory_org_id : ' || l_material_req_rec.inventory_org_id);

Line 1949: AHL_DEBUG_PUB.debug( 'POSITION_PATH_ID : ' || l_material_req_rec.POSITION_PATH_ID);

1945: l_material_req_rec.inventory_org_id;
1946:
1947: IF G_DEBUG = 'Y' THEN
1948: AHL_DEBUG_PUB.debug( 'association_type : ' || l_association_type );
1949: AHL_DEBUG_PUB.debug( 'POSITION_PATH_ID : ' || l_material_req_rec.POSITION_PATH_ID);
1950: AHL_DEBUG_PUB.debug( 'item_group_id : ' || l_material_req_rec.item_group_id);
1951: AHL_DEBUG_PUB.debug( 'inventory_item_id : ' || l_material_req_rec.inventory_item_id);
1952: AHL_DEBUG_PUB.debug( 'inventory_org_id : ' || l_material_req_rec.inventory_org_id);
1953: END IF;

Line 1950: AHL_DEBUG_PUB.debug( 'item_group_id : ' || l_material_req_rec.item_group_id);

1946:
1947: IF G_DEBUG = 'Y' THEN
1948: AHL_DEBUG_PUB.debug( 'association_type : ' || l_association_type );
1949: AHL_DEBUG_PUB.debug( 'POSITION_PATH_ID : ' || l_material_req_rec.POSITION_PATH_ID);
1950: AHL_DEBUG_PUB.debug( 'item_group_id : ' || l_material_req_rec.item_group_id);
1951: AHL_DEBUG_PUB.debug( 'inventory_item_id : ' || l_material_req_rec.inventory_item_id);
1952: AHL_DEBUG_PUB.debug( 'inventory_org_id : ' || l_material_req_rec.inventory_org_id);
1953: END IF;
1954: EXIT WHEN get_dup_rec%NOTFOUND;

Line 1951: AHL_DEBUG_PUB.debug( 'inventory_item_id : ' || l_material_req_rec.inventory_item_id);

1947: IF G_DEBUG = 'Y' THEN
1948: AHL_DEBUG_PUB.debug( 'association_type : ' || l_association_type );
1949: AHL_DEBUG_PUB.debug( 'POSITION_PATH_ID : ' || l_material_req_rec.POSITION_PATH_ID);
1950: AHL_DEBUG_PUB.debug( 'item_group_id : ' || l_material_req_rec.item_group_id);
1951: AHL_DEBUG_PUB.debug( 'inventory_item_id : ' || l_material_req_rec.inventory_item_id);
1952: AHL_DEBUG_PUB.debug( 'inventory_org_id : ' || l_material_req_rec.inventory_org_id);
1953: END IF;
1954: EXIT WHEN get_dup_rec%NOTFOUND;
1955:

Line 1952: AHL_DEBUG_PUB.debug( 'inventory_org_id : ' || l_material_req_rec.inventory_org_id);

1948: AHL_DEBUG_PUB.debug( 'association_type : ' || l_association_type );
1949: AHL_DEBUG_PUB.debug( 'POSITION_PATH_ID : ' || l_material_req_rec.POSITION_PATH_ID);
1950: AHL_DEBUG_PUB.debug( 'item_group_id : ' || l_material_req_rec.item_group_id);
1951: AHL_DEBUG_PUB.debug( 'inventory_item_id : ' || l_material_req_rec.inventory_item_id);
1952: AHL_DEBUG_PUB.debug( 'inventory_org_id : ' || l_material_req_rec.inventory_org_id);
1953: END IF;
1954: EXIT WHEN get_dup_rec%NOTFOUND;
1955:
1956: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_MATERIAL_REQ_REC_DUP' );

Line 2055: AHL_DEBUG_PUB.enable_debug;

2051: --END
2052: BEGIN
2053:
2054: IF G_DEBUG='Y' THEN
2055: AHL_DEBUG_PUB.enable_debug;
2056: END IF;
2057: x_return_status := FND_API.G_RET_STS_SUCCESS;
2058:
2059: -- Check whether any duplicate records for the given OBJECT_ID

Line 2183: AHL_DEBUG_PUB.enable_debug;

2179: END IF;
2180:
2181: -- Enable Debug (optional)
2182: IF ( G_DEBUG = 'Y' ) THEN
2183: AHL_DEBUG_PUB.enable_debug;
2184: END IF;
2185:
2186: IF G_DEBUG = 'Y' THEN
2187: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : Begin API' );

Line 2187: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : Begin API' );

2183: AHL_DEBUG_PUB.enable_debug;
2184: END IF;
2185:
2186: IF G_DEBUG = 'Y' THEN
2187: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : Begin API' );
2188: END IF;
2189:
2190:
2191: --This is to be added before calling validate_efct_api_inputs

Line 2262: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : after convert_values_to_ids' );

2258: END IF;
2259: END LOOP;
2260:
2261: IF G_DEBUG = 'Y' THEN
2262: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : after convert_values_to_ids' );
2263: END IF;
2264:
2265: -- Default missing and unchanged attributes.
2266: FOR i IN 1..p_x_material_req_tbl.count LOOP

Line 2281: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : after default_unchanged_attributes / default_missing_attributes' );

2277: END IF;
2278: END LOOP;
2279:
2280: IF G_DEBUG = 'Y' THEN
2281: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : after default_unchanged_attributes / default_missing_attributes' );
2282: END IF;
2283:
2284: -- Validate all attributes (Item level validation)
2285: FOR i IN 1..p_x_material_req_tbl.count LOOP

Line 2303: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : after validate_attributes' );

2299:
2300: END LOOP;
2301:
2302: IF G_DEBUG = 'Y' THEN
2303: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : after validate_attributes' );
2304: END IF;
2305:
2306: -- Perform cross attribute validation and missing attribute checks (Record level validation)
2307: FOR i IN 1..p_x_material_req_tbl.count LOOP

Line 2334: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : after validate_record' );

2330: END IF;
2331:
2332:
2333: IF G_DEBUG = 'Y' THEN
2334: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : after validate_record' );
2335: END IF;
2336:
2337:
2338: IF ( p_association_type = 'OPERATION')

Line 2445: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : p_x_material_req_tbl(i).dml_operation ' || p_x_material_req_tbl(i).dml_operation ) ;

2441:
2442: -- Perform the DML statement directly.
2443: FOR i IN 1..p_x_material_req_tbl.count LOOP
2444: IF G_DEBUG = 'Y' THEN
2445: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : p_x_material_req_tbl(i).dml_operation ' || p_x_material_req_tbl(i).dml_operation ) ;
2446: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : before DML p_object_id ' || p_object_id );
2447: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : before DML p_association_type ' || p_association_type );
2448: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : before DML p_x_material_req_tbl(i).position_path_id ' || p_x_material_req_tbl(i).position_path_id );
2449: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : before insert p_x_material_req_tbl(i).item_group_id ' || p_x_material_req_tbl(i).item_group_id );

Line 2446: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : before DML p_object_id ' || p_object_id );

2442: -- Perform the DML statement directly.
2443: FOR i IN 1..p_x_material_req_tbl.count LOOP
2444: IF G_DEBUG = 'Y' THEN
2445: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : p_x_material_req_tbl(i).dml_operation ' || p_x_material_req_tbl(i).dml_operation ) ;
2446: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : before DML p_object_id ' || p_object_id );
2447: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : before DML p_association_type ' || p_association_type );
2448: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : before DML p_x_material_req_tbl(i).position_path_id ' || p_x_material_req_tbl(i).position_path_id );
2449: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : before insert p_x_material_req_tbl(i).item_group_id ' || p_x_material_req_tbl(i).item_group_id );
2450: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : before insert p_x_material_req_tbl(i).inventory_item_id ' || p_x_material_req_tbl(i).inventory_item_id );

Line 2447: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : before DML p_association_type ' || p_association_type );

2443: FOR i IN 1..p_x_material_req_tbl.count LOOP
2444: IF G_DEBUG = 'Y' THEN
2445: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : p_x_material_req_tbl(i).dml_operation ' || p_x_material_req_tbl(i).dml_operation ) ;
2446: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : before DML p_object_id ' || p_object_id );
2447: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : before DML p_association_type ' || p_association_type );
2448: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : before DML p_x_material_req_tbl(i).position_path_id ' || p_x_material_req_tbl(i).position_path_id );
2449: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : before insert p_x_material_req_tbl(i).item_group_id ' || p_x_material_req_tbl(i).item_group_id );
2450: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : before insert p_x_material_req_tbl(i).inventory_item_id ' || p_x_material_req_tbl(i).inventory_item_id );
2451: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : before insert p_x_material_req_tbl(i).inventory_org_id ' || p_x_material_req_tbl(i).inventory_org_id );

Line 2448: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : before DML p_x_material_req_tbl(i).position_path_id ' || p_x_material_req_tbl(i).position_path_id );

2444: IF G_DEBUG = 'Y' THEN
2445: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : p_x_material_req_tbl(i).dml_operation ' || p_x_material_req_tbl(i).dml_operation ) ;
2446: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : before DML p_object_id ' || p_object_id );
2447: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : before DML p_association_type ' || p_association_type );
2448: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : before DML p_x_material_req_tbl(i).position_path_id ' || p_x_material_req_tbl(i).position_path_id );
2449: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : before insert p_x_material_req_tbl(i).item_group_id ' || p_x_material_req_tbl(i).item_group_id );
2450: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : before insert p_x_material_req_tbl(i).inventory_item_id ' || p_x_material_req_tbl(i).inventory_item_id );
2451: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : before insert p_x_material_req_tbl(i).inventory_org_id ' || p_x_material_req_tbl(i).inventory_org_id );
2452: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : before insert p_x_material_req_tbl(i).uom_code ' || p_x_material_req_tbl(i).uom_code);

Line 2449: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : before insert p_x_material_req_tbl(i).item_group_id ' || p_x_material_req_tbl(i).item_group_id );

2445: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : p_x_material_req_tbl(i).dml_operation ' || p_x_material_req_tbl(i).dml_operation ) ;
2446: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : before DML p_object_id ' || p_object_id );
2447: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : before DML p_association_type ' || p_association_type );
2448: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : before DML p_x_material_req_tbl(i).position_path_id ' || p_x_material_req_tbl(i).position_path_id );
2449: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : before insert p_x_material_req_tbl(i).item_group_id ' || p_x_material_req_tbl(i).item_group_id );
2450: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : before insert p_x_material_req_tbl(i).inventory_item_id ' || p_x_material_req_tbl(i).inventory_item_id );
2451: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : before insert p_x_material_req_tbl(i).inventory_org_id ' || p_x_material_req_tbl(i).inventory_org_id );
2452: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : before insert p_x_material_req_tbl(i).uom_code ' || p_x_material_req_tbl(i).uom_code);
2453: END IF;

Line 2450: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : before insert p_x_material_req_tbl(i).inventory_item_id ' || p_x_material_req_tbl(i).inventory_item_id );

2446: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : before DML p_object_id ' || p_object_id );
2447: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : before DML p_association_type ' || p_association_type );
2448: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : before DML p_x_material_req_tbl(i).position_path_id ' || p_x_material_req_tbl(i).position_path_id );
2449: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : before insert p_x_material_req_tbl(i).item_group_id ' || p_x_material_req_tbl(i).item_group_id );
2450: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : before insert p_x_material_req_tbl(i).inventory_item_id ' || p_x_material_req_tbl(i).inventory_item_id );
2451: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : before insert p_x_material_req_tbl(i).inventory_org_id ' || p_x_material_req_tbl(i).inventory_org_id );
2452: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : before insert p_x_material_req_tbl(i).uom_code ' || p_x_material_req_tbl(i).uom_code);
2453: END IF;
2454: IF ( p_x_material_req_tbl(i).dml_operation = 'C' ) THEN

Line 2451: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : before insert p_x_material_req_tbl(i).inventory_org_id ' || p_x_material_req_tbl(i).inventory_org_id );

2447: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : before DML p_association_type ' || p_association_type );
2448: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : before DML p_x_material_req_tbl(i).position_path_id ' || p_x_material_req_tbl(i).position_path_id );
2449: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : before insert p_x_material_req_tbl(i).item_group_id ' || p_x_material_req_tbl(i).item_group_id );
2450: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : before insert p_x_material_req_tbl(i).inventory_item_id ' || p_x_material_req_tbl(i).inventory_item_id );
2451: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : before insert p_x_material_req_tbl(i).inventory_org_id ' || p_x_material_req_tbl(i).inventory_org_id );
2452: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : before insert p_x_material_req_tbl(i).uom_code ' || p_x_material_req_tbl(i).uom_code);
2453: END IF;
2454: IF ( p_x_material_req_tbl(i).dml_operation = 'C' ) THEN
2455:

Line 2452: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : before insert p_x_material_req_tbl(i).uom_code ' || p_x_material_req_tbl(i).uom_code);

2448: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : before DML p_x_material_req_tbl(i).position_path_id ' || p_x_material_req_tbl(i).position_path_id );
2449: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : before insert p_x_material_req_tbl(i).item_group_id ' || p_x_material_req_tbl(i).item_group_id );
2450: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : before insert p_x_material_req_tbl(i).inventory_item_id ' || p_x_material_req_tbl(i).inventory_item_id );
2451: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : before insert p_x_material_req_tbl(i).inventory_org_id ' || p_x_material_req_tbl(i).inventory_org_id );
2452: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : before insert p_x_material_req_tbl(i).uom_code ' || p_x_material_req_tbl(i).uom_code);
2453: END IF;
2454: IF ( p_x_material_req_tbl(i).dml_operation = 'C' ) THEN
2455:
2456: BEGIN

Line 2539: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : after insert p_object_id ' || p_object_id );

2535: p_x_material_req_tbl(i).in_service --pdoki added for OGMA 105 issue
2536: ) RETURNING rt_oper_material_id INTO l_rt_oper_material_id;
2537:
2538: IF G_DEBUG = 'Y' THEN
2539: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : after insert p_object_id ' || p_object_id );
2540: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : after insert p_association_type ' || p_association_type );
2541: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : after insert p_x_material_req_tbl(i).position_path_id ' || p_x_material_req_tbl(i).position_path_id );
2542: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : after insert p_x_material_req_tbl(i).item_group_id ' || p_x_material_req_tbl(i).item_group_id );
2543: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : after insert p_x_material_req_tbl(i).inventory_item_id ' || p_x_material_req_tbl(i).inventory_item_id );

Line 2540: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : after insert p_association_type ' || p_association_type );

2536: ) RETURNING rt_oper_material_id INTO l_rt_oper_material_id;
2537:
2538: IF G_DEBUG = 'Y' THEN
2539: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : after insert p_object_id ' || p_object_id );
2540: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : after insert p_association_type ' || p_association_type );
2541: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : after insert p_x_material_req_tbl(i).position_path_id ' || p_x_material_req_tbl(i).position_path_id );
2542: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : after insert p_x_material_req_tbl(i).item_group_id ' || p_x_material_req_tbl(i).item_group_id );
2543: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : after insert p_x_material_req_tbl(i).inventory_item_id ' || p_x_material_req_tbl(i).inventory_item_id );
2544: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : after insert p_x_material_req_tbl(i).inventory_org_id ' || p_x_material_req_tbl(i).inventory_org_id );

Line 2541: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : after insert p_x_material_req_tbl(i).position_path_id ' || p_x_material_req_tbl(i).position_path_id );

2537:
2538: IF G_DEBUG = 'Y' THEN
2539: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : after insert p_object_id ' || p_object_id );
2540: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : after insert p_association_type ' || p_association_type );
2541: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : after insert p_x_material_req_tbl(i).position_path_id ' || p_x_material_req_tbl(i).position_path_id );
2542: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : after insert p_x_material_req_tbl(i).item_group_id ' || p_x_material_req_tbl(i).item_group_id );
2543: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : after insert p_x_material_req_tbl(i).inventory_item_id ' || p_x_material_req_tbl(i).inventory_item_id );
2544: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : after insert p_x_material_req_tbl(i).inventory_org_id ' || p_x_material_req_tbl(i).inventory_org_id );
2545: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : after insert p_x_material_req_tbl(i).uom_code ' || p_x_material_req_tbl(i).uom_code);

Line 2542: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : after insert p_x_material_req_tbl(i).item_group_id ' || p_x_material_req_tbl(i).item_group_id );

2538: IF G_DEBUG = 'Y' THEN
2539: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : after insert p_object_id ' || p_object_id );
2540: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : after insert p_association_type ' || p_association_type );
2541: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : after insert p_x_material_req_tbl(i).position_path_id ' || p_x_material_req_tbl(i).position_path_id );
2542: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : after insert p_x_material_req_tbl(i).item_group_id ' || p_x_material_req_tbl(i).item_group_id );
2543: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : after insert p_x_material_req_tbl(i).inventory_item_id ' || p_x_material_req_tbl(i).inventory_item_id );
2544: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : after insert p_x_material_req_tbl(i).inventory_org_id ' || p_x_material_req_tbl(i).inventory_org_id );
2545: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : after insert p_x_material_req_tbl(i).uom_code ' || p_x_material_req_tbl(i).uom_code);
2546: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : after insert p_x_material_req_tbl(i).quantity ' || p_x_material_req_tbl(i).quantity);

Line 2543: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : after insert p_x_material_req_tbl(i).inventory_item_id ' || p_x_material_req_tbl(i).inventory_item_id );

2539: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : after insert p_object_id ' || p_object_id );
2540: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : after insert p_association_type ' || p_association_type );
2541: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : after insert p_x_material_req_tbl(i).position_path_id ' || p_x_material_req_tbl(i).position_path_id );
2542: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : after insert p_x_material_req_tbl(i).item_group_id ' || p_x_material_req_tbl(i).item_group_id );
2543: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : after insert p_x_material_req_tbl(i).inventory_item_id ' || p_x_material_req_tbl(i).inventory_item_id );
2544: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : after insert p_x_material_req_tbl(i).inventory_org_id ' || p_x_material_req_tbl(i).inventory_org_id );
2545: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : after insert p_x_material_req_tbl(i).uom_code ' || p_x_material_req_tbl(i).uom_code);
2546: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : after insert p_x_material_req_tbl(i).quantity ' || p_x_material_req_tbl(i).quantity);
2547: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : after insert p_x_material_req_tbl(i).item_comp_detail_id ' || p_x_material_req_tbl(i).item_comp_detail_id);

Line 2544: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : after insert p_x_material_req_tbl(i).inventory_org_id ' || p_x_material_req_tbl(i).inventory_org_id );

2540: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : after insert p_association_type ' || p_association_type );
2541: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : after insert p_x_material_req_tbl(i).position_path_id ' || p_x_material_req_tbl(i).position_path_id );
2542: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : after insert p_x_material_req_tbl(i).item_group_id ' || p_x_material_req_tbl(i).item_group_id );
2543: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : after insert p_x_material_req_tbl(i).inventory_item_id ' || p_x_material_req_tbl(i).inventory_item_id );
2544: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : after insert p_x_material_req_tbl(i).inventory_org_id ' || p_x_material_req_tbl(i).inventory_org_id );
2545: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : after insert p_x_material_req_tbl(i).uom_code ' || p_x_material_req_tbl(i).uom_code);
2546: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : after insert p_x_material_req_tbl(i).quantity ' || p_x_material_req_tbl(i).quantity);
2547: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : after insert p_x_material_req_tbl(i).item_comp_detail_id ' || p_x_material_req_tbl(i).item_comp_detail_id);
2548: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : after insert p_x_material_req_tbl(i).exclude_flag ' || p_x_material_req_tbl(i).exclude_flag );

Line 2545: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : after insert p_x_material_req_tbl(i).uom_code ' || p_x_material_req_tbl(i).uom_code);

2541: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : after insert p_x_material_req_tbl(i).position_path_id ' || p_x_material_req_tbl(i).position_path_id );
2542: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : after insert p_x_material_req_tbl(i).item_group_id ' || p_x_material_req_tbl(i).item_group_id );
2543: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : after insert p_x_material_req_tbl(i).inventory_item_id ' || p_x_material_req_tbl(i).inventory_item_id );
2544: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : after insert p_x_material_req_tbl(i).inventory_org_id ' || p_x_material_req_tbl(i).inventory_org_id );
2545: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : after insert p_x_material_req_tbl(i).uom_code ' || p_x_material_req_tbl(i).uom_code);
2546: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : after insert p_x_material_req_tbl(i).quantity ' || p_x_material_req_tbl(i).quantity);
2547: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : after insert p_x_material_req_tbl(i).item_comp_detail_id ' || p_x_material_req_tbl(i).item_comp_detail_id);
2548: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : after insert p_x_material_req_tbl(i).exclude_flag ' || p_x_material_req_tbl(i).exclude_flag );
2549: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : after insert p_x_material_req_tbl(i).rework_percent ' || p_x_material_req_tbl(i).rework_percent );

Line 2546: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : after insert p_x_material_req_tbl(i).quantity ' || p_x_material_req_tbl(i).quantity);

2542: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : after insert p_x_material_req_tbl(i).item_group_id ' || p_x_material_req_tbl(i).item_group_id );
2543: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : after insert p_x_material_req_tbl(i).inventory_item_id ' || p_x_material_req_tbl(i).inventory_item_id );
2544: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : after insert p_x_material_req_tbl(i).inventory_org_id ' || p_x_material_req_tbl(i).inventory_org_id );
2545: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : after insert p_x_material_req_tbl(i).uom_code ' || p_x_material_req_tbl(i).uom_code);
2546: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : after insert p_x_material_req_tbl(i).quantity ' || p_x_material_req_tbl(i).quantity);
2547: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : after insert p_x_material_req_tbl(i).item_comp_detail_id ' || p_x_material_req_tbl(i).item_comp_detail_id);
2548: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : after insert p_x_material_req_tbl(i).exclude_flag ' || p_x_material_req_tbl(i).exclude_flag );
2549: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : after insert p_x_material_req_tbl(i).rework_percent ' || p_x_material_req_tbl(i).rework_percent );
2550: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : after insert p_x_material_req_tbl(i).replace_percent ' || p_x_material_req_tbl(i).replace_percent );

Line 2547: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : after insert p_x_material_req_tbl(i).item_comp_detail_id ' || p_x_material_req_tbl(i).item_comp_detail_id);

2543: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : after insert p_x_material_req_tbl(i).inventory_item_id ' || p_x_material_req_tbl(i).inventory_item_id );
2544: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : after insert p_x_material_req_tbl(i).inventory_org_id ' || p_x_material_req_tbl(i).inventory_org_id );
2545: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : after insert p_x_material_req_tbl(i).uom_code ' || p_x_material_req_tbl(i).uom_code);
2546: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : after insert p_x_material_req_tbl(i).quantity ' || p_x_material_req_tbl(i).quantity);
2547: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : after insert p_x_material_req_tbl(i).item_comp_detail_id ' || p_x_material_req_tbl(i).item_comp_detail_id);
2548: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : after insert p_x_material_req_tbl(i).exclude_flag ' || p_x_material_req_tbl(i).exclude_flag );
2549: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : after insert p_x_material_req_tbl(i).rework_percent ' || p_x_material_req_tbl(i).rework_percent );
2550: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : after insert p_x_material_req_tbl(i).replace_percent ' || p_x_material_req_tbl(i).replace_percent );
2551: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : after insert l_rt_oper_material_id' || l_rt_oper_material_id);

Line 2548: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : after insert p_x_material_req_tbl(i).exclude_flag ' || p_x_material_req_tbl(i).exclude_flag );

2544: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : after insert p_x_material_req_tbl(i).inventory_org_id ' || p_x_material_req_tbl(i).inventory_org_id );
2545: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : after insert p_x_material_req_tbl(i).uom_code ' || p_x_material_req_tbl(i).uom_code);
2546: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : after insert p_x_material_req_tbl(i).quantity ' || p_x_material_req_tbl(i).quantity);
2547: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : after insert p_x_material_req_tbl(i).item_comp_detail_id ' || p_x_material_req_tbl(i).item_comp_detail_id);
2548: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : after insert p_x_material_req_tbl(i).exclude_flag ' || p_x_material_req_tbl(i).exclude_flag );
2549: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : after insert p_x_material_req_tbl(i).rework_percent ' || p_x_material_req_tbl(i).rework_percent );
2550: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : after insert p_x_material_req_tbl(i).replace_percent ' || p_x_material_req_tbl(i).replace_percent );
2551: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : after insert l_rt_oper_material_id' || l_rt_oper_material_id);
2552: END IF;

Line 2549: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : after insert p_x_material_req_tbl(i).rework_percent ' || p_x_material_req_tbl(i).rework_percent );

2545: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : after insert p_x_material_req_tbl(i).uom_code ' || p_x_material_req_tbl(i).uom_code);
2546: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : after insert p_x_material_req_tbl(i).quantity ' || p_x_material_req_tbl(i).quantity);
2547: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : after insert p_x_material_req_tbl(i).item_comp_detail_id ' || p_x_material_req_tbl(i).item_comp_detail_id);
2548: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : after insert p_x_material_req_tbl(i).exclude_flag ' || p_x_material_req_tbl(i).exclude_flag );
2549: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : after insert p_x_material_req_tbl(i).rework_percent ' || p_x_material_req_tbl(i).rework_percent );
2550: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : after insert p_x_material_req_tbl(i).replace_percent ' || p_x_material_req_tbl(i).replace_percent );
2551: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : after insert l_rt_oper_material_id' || l_rt_oper_material_id);
2552: END IF;
2553:

Line 2550: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : after insert p_x_material_req_tbl(i).replace_percent ' || p_x_material_req_tbl(i).replace_percent );

2546: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : after insert p_x_material_req_tbl(i).quantity ' || p_x_material_req_tbl(i).quantity);
2547: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : after insert p_x_material_req_tbl(i).item_comp_detail_id ' || p_x_material_req_tbl(i).item_comp_detail_id);
2548: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : after insert p_x_material_req_tbl(i).exclude_flag ' || p_x_material_req_tbl(i).exclude_flag );
2549: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : after insert p_x_material_req_tbl(i).rework_percent ' || p_x_material_req_tbl(i).rework_percent );
2550: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : after insert p_x_material_req_tbl(i).replace_percent ' || p_x_material_req_tbl(i).replace_percent );
2551: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : after insert l_rt_oper_material_id' || l_rt_oper_material_id);
2552: END IF;
2553:
2554: -- Set OUT values

Line 2551: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : after insert l_rt_oper_material_id' || l_rt_oper_material_id);

2547: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : after insert p_x_material_req_tbl(i).item_comp_detail_id ' || p_x_material_req_tbl(i).item_comp_detail_id);
2548: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : after insert p_x_material_req_tbl(i).exclude_flag ' || p_x_material_req_tbl(i).exclude_flag );
2549: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : after insert p_x_material_req_tbl(i).rework_percent ' || p_x_material_req_tbl(i).rework_percent );
2550: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : after insert p_x_material_req_tbl(i).replace_percent ' || p_x_material_req_tbl(i).replace_percent );
2551: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : after insert l_rt_oper_material_id' || l_rt_oper_material_id);
2552: END IF;
2553:
2554: -- Set OUT values
2555: p_x_material_req_tbl(i).rt_oper_material_id := l_rt_oper_material_id;

Line 2666: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : after DML operation' );

2662: END LOOP;
2663:
2664:
2665: IF G_DEBUG = 'Y' THEN
2666: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : after DML operation' );
2667: END IF;
2668:
2669: -- Get all the error messages from the previous steps (if any) and raise the appropriate Exception
2670: l_msg_count := FND_MSG_PUB.count_msg;

Line 2691: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : after validate_records' );

2687: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2688: END IF;
2689:
2690: IF G_DEBUG = 'Y' THEN
2691: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : after validate_records' );
2692: END IF;
2693:
2694: -- Perform the Commit (if requested)
2695: IF FND_API.to_boolean( p_commit ) THEN

Line 2709: AHL_DEBUG_PUB.disable_debug;

2705: );
2706:
2707: -- Disable debug (if enabled)
2708: IF ( G_DEBUG = 'Y' ) THEN
2709: AHL_DEBUG_PUB.disable_debug;
2710: END IF;
2711:
2712: EXCEPTION
2713:

Line 2726: AHL_DEBUG_PUB.disable_debug;

2722: );
2723:
2724: -- Disable debug (if enabled)
2725: IF ( G_DEBUG = 'Y' ) THEN
2726: AHL_DEBUG_PUB.disable_debug;
2727: END IF;
2728:
2729: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2730: ROLLBACK TO process_material_req_PVT;

Line 2741: AHL_DEBUG_PUB.disable_debug;

2737: );
2738:
2739: -- Disable debug (if enabled)
2740: IF ( G_DEBUG = 'Y' ) THEN
2741: AHL_DEBUG_PUB.disable_debug;
2742: END IF;
2743:
2744: WHEN OTHERS THEN
2745: ROLLBACK TO process_material_req_PVT;

Line 2765: AHL_DEBUG_PUB.disable_debug;

2761: );
2762:
2763: -- Disable debug (if enabled)
2764: IF ( G_DEBUG = 'Y' ) THEN
2765: AHL_DEBUG_PUB.disable_debug;
2766: END IF;
2767:
2768: END process_material_req;
2769:

Line 2826: AHL_DEBUG_PUB.enable_debug;

2822: FND_MSG_PUB.initialize;
2823: END IF;
2824:
2825: IF G_DEBUG = 'Y' THEN
2826: AHL_DEBUG_PUB.enable_debug;
2827: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME1 || ' : Begin API' );
2828: END IF;
2829:
2830: --This is to be added before calling validate_api_inputs

Line 2827: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME1 || ' : Begin API' );

2823: END IF;
2824:
2825: IF G_DEBUG = 'Y' THEN
2826: AHL_DEBUG_PUB.enable_debug;
2827: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME1 || ' : Begin API' );
2828: END IF;
2829:
2830: --This is to be added before calling validate_api_inputs
2831: -- Validate Application Usage

Line 2893: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME1 || ' : after convert_values_to_ids' );

2889: END IF;
2890: END LOOP;
2891:
2892: IF G_DEBUG = 'Y' THEN
2893: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME1 || ' : after convert_values_to_ids' );
2894: END IF;
2895:
2896: -- Validate all attributes (Item level validation)
2897: FOR i IN 1..p_x_route_efct_tbl.count LOOP

Line 2913: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME1 || ' : after validate_attributes' );

2909: END IF;
2910: END LOOP;
2911:
2912: IF G_DEBUG = 'Y' THEN
2913: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME1 || ' : after validate_attributes' );
2914: END IF;
2915:
2916: -- Default missing and unchanged attributes.
2917: FOR i IN 1..p_x_route_efct_tbl.count LOOP

Line 2932: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME1 || ' : after default_unchanged_attributes / default_missing_attributes' );

2928: END IF;
2929: END LOOP;
2930:
2931: IF G_DEBUG = 'Y' THEN
2932: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME1 || ' : after default_unchanged_attributes / default_missing_attributes' );
2933: END IF;
2934:
2935: -- Perform cross attribute validation and missing attribute checks (Record level validation)
2936: FOR i IN 1..p_x_route_efct_tbl.count LOOP

Line 2954: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME1 || ' : after validate_record' );

2950: END IF;
2951: END LOOP;
2952:
2953: IF G_DEBUG = 'Y' THEN
2954: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME1 || ' : after validate_record' );
2955: END IF;
2956: IF G_DEBUG='Y' THEN
2957: AHL_DEBUG_PUB.debug( 'Starting updating parent route/operation');
2958: END IF;

Line 2957: AHL_DEBUG_PUB.debug( 'Starting updating parent route/operation');

2953: IF G_DEBUG = 'Y' THEN
2954: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME1 || ' : after validate_record' );
2955: END IF;
2956: IF G_DEBUG='Y' THEN
2957: AHL_DEBUG_PUB.debug( 'Starting updating parent route/operation');
2958: END IF;
2959:
2960: IF G_DEBUG='Y' THEN
2961: AHL_DEBUG_PUB.debug( 'p_association_type = ROUTE');

Line 2961: AHL_DEBUG_PUB.debug( 'p_association_type = ROUTE');

2957: AHL_DEBUG_PUB.debug( 'Starting updating parent route/operation');
2958: END IF;
2959:
2960: IF G_DEBUG='Y' THEN
2961: AHL_DEBUG_PUB.debug( 'p_association_type = ROUTE');
2962: END IF;
2963:
2964: -- Check if the Route is existing and in Draft status
2965: AHL_RM_ROUTE_UTIL.validate_route_status

Line 2994: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : p_x_route_efct_tbl(i).dml_operation ' || p_x_route_efct_tbl(i).dml_operation ) ;

2990: -- Perform the DML statement directly.
2991: FOR i IN 1..p_x_route_efct_tbl.count LOOP
2992: IF ( p_x_route_efct_tbl(i).dml_operation = 'C' ) THEN
2993: IF G_DEBUG = 'Y' THEN
2994: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : p_x_route_efct_tbl(i).dml_operation ' || p_x_route_efct_tbl(i).dml_operation ) ;
2995: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : before DML p_object_id ' || p_object_id );
2996: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : before DML p_x_route_efct_tbl(i).INVENTORY_ITEM_ID ' || p_x_route_efct_tbl(i).INVENTORY_ITEM_ID );
2997: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : before insert p_x_route_efct_tbl(i).INVENTORY_MASTER_ORG_ID ' || p_x_route_efct_tbl(i).INVENTORY_MASTER_ORG_ID );
2998: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : before insert p_x_route_efct_tbl(i).MC_ID ' || p_x_route_efct_tbl(i).MC_ID );

Line 2995: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : before DML p_object_id ' || p_object_id );

2991: FOR i IN 1..p_x_route_efct_tbl.count LOOP
2992: IF ( p_x_route_efct_tbl(i).dml_operation = 'C' ) THEN
2993: IF G_DEBUG = 'Y' THEN
2994: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : p_x_route_efct_tbl(i).dml_operation ' || p_x_route_efct_tbl(i).dml_operation ) ;
2995: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : before DML p_object_id ' || p_object_id );
2996: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : before DML p_x_route_efct_tbl(i).INVENTORY_ITEM_ID ' || p_x_route_efct_tbl(i).INVENTORY_ITEM_ID );
2997: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : before insert p_x_route_efct_tbl(i).INVENTORY_MASTER_ORG_ID ' || p_x_route_efct_tbl(i).INVENTORY_MASTER_ORG_ID );
2998: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : before insert p_x_route_efct_tbl(i).MC_ID ' || p_x_route_efct_tbl(i).MC_ID );
2999: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : before insert p_x_route_efct_tbl(i).MC_HEADER_ID ' || p_x_route_efct_tbl(i).MC_HEADER_ID );

Line 2996: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : before DML p_x_route_efct_tbl(i).INVENTORY_ITEM_ID ' || p_x_route_efct_tbl(i).INVENTORY_ITEM_ID );

2992: IF ( p_x_route_efct_tbl(i).dml_operation = 'C' ) THEN
2993: IF G_DEBUG = 'Y' THEN
2994: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : p_x_route_efct_tbl(i).dml_operation ' || p_x_route_efct_tbl(i).dml_operation ) ;
2995: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : before DML p_object_id ' || p_object_id );
2996: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : before DML p_x_route_efct_tbl(i).INVENTORY_ITEM_ID ' || p_x_route_efct_tbl(i).INVENTORY_ITEM_ID );
2997: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : before insert p_x_route_efct_tbl(i).INVENTORY_MASTER_ORG_ID ' || p_x_route_efct_tbl(i).INVENTORY_MASTER_ORG_ID );
2998: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : before insert p_x_route_efct_tbl(i).MC_ID ' || p_x_route_efct_tbl(i).MC_ID );
2999: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : before insert p_x_route_efct_tbl(i).MC_HEADER_ID ' || p_x_route_efct_tbl(i).MC_HEADER_ID );
3000: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : before insert p_x_route_efct_tbl(i).object_version_number ' || p_x_route_efct_tbl(i).object_version_number);

Line 2997: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : before insert p_x_route_efct_tbl(i).INVENTORY_MASTER_ORG_ID ' || p_x_route_efct_tbl(i).INVENTORY_MASTER_ORG_ID );

2993: IF G_DEBUG = 'Y' THEN
2994: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : p_x_route_efct_tbl(i).dml_operation ' || p_x_route_efct_tbl(i).dml_operation ) ;
2995: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : before DML p_object_id ' || p_object_id );
2996: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : before DML p_x_route_efct_tbl(i).INVENTORY_ITEM_ID ' || p_x_route_efct_tbl(i).INVENTORY_ITEM_ID );
2997: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : before insert p_x_route_efct_tbl(i).INVENTORY_MASTER_ORG_ID ' || p_x_route_efct_tbl(i).INVENTORY_MASTER_ORG_ID );
2998: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : before insert p_x_route_efct_tbl(i).MC_ID ' || p_x_route_efct_tbl(i).MC_ID );
2999: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : before insert p_x_route_efct_tbl(i).MC_HEADER_ID ' || p_x_route_efct_tbl(i).MC_HEADER_ID );
3000: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : before insert p_x_route_efct_tbl(i).object_version_number ' || p_x_route_efct_tbl(i).object_version_number);
3001: END IF;

Line 2998: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : before insert p_x_route_efct_tbl(i).MC_ID ' || p_x_route_efct_tbl(i).MC_ID );

2994: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : p_x_route_efct_tbl(i).dml_operation ' || p_x_route_efct_tbl(i).dml_operation ) ;
2995: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : before DML p_object_id ' || p_object_id );
2996: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : before DML p_x_route_efct_tbl(i).INVENTORY_ITEM_ID ' || p_x_route_efct_tbl(i).INVENTORY_ITEM_ID );
2997: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : before insert p_x_route_efct_tbl(i).INVENTORY_MASTER_ORG_ID ' || p_x_route_efct_tbl(i).INVENTORY_MASTER_ORG_ID );
2998: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : before insert p_x_route_efct_tbl(i).MC_ID ' || p_x_route_efct_tbl(i).MC_ID );
2999: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : before insert p_x_route_efct_tbl(i).MC_HEADER_ID ' || p_x_route_efct_tbl(i).MC_HEADER_ID );
3000: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : before insert p_x_route_efct_tbl(i).object_version_number ' || p_x_route_efct_tbl(i).object_version_number);
3001: END IF;
3002: -- Insert the record

Line 2999: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : before insert p_x_route_efct_tbl(i).MC_HEADER_ID ' || p_x_route_efct_tbl(i).MC_HEADER_ID );

2995: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : before DML p_object_id ' || p_object_id );
2996: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : before DML p_x_route_efct_tbl(i).INVENTORY_ITEM_ID ' || p_x_route_efct_tbl(i).INVENTORY_ITEM_ID );
2997: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : before insert p_x_route_efct_tbl(i).INVENTORY_MASTER_ORG_ID ' || p_x_route_efct_tbl(i).INVENTORY_MASTER_ORG_ID );
2998: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : before insert p_x_route_efct_tbl(i).MC_ID ' || p_x_route_efct_tbl(i).MC_ID );
2999: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : before insert p_x_route_efct_tbl(i).MC_HEADER_ID ' || p_x_route_efct_tbl(i).MC_HEADER_ID );
3000: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : before insert p_x_route_efct_tbl(i).object_version_number ' || p_x_route_efct_tbl(i).object_version_number);
3001: END IF;
3002: -- Insert the record
3003: p_x_route_efct_tbl(i).object_version_number := 1;

Line 3000: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : before insert p_x_route_efct_tbl(i).object_version_number ' || p_x_route_efct_tbl(i).object_version_number);

2996: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : before DML p_x_route_efct_tbl(i).INVENTORY_ITEM_ID ' || p_x_route_efct_tbl(i).INVENTORY_ITEM_ID );
2997: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : before insert p_x_route_efct_tbl(i).INVENTORY_MASTER_ORG_ID ' || p_x_route_efct_tbl(i).INVENTORY_MASTER_ORG_ID );
2998: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : before insert p_x_route_efct_tbl(i).MC_ID ' || p_x_route_efct_tbl(i).MC_ID );
2999: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : before insert p_x_route_efct_tbl(i).MC_HEADER_ID ' || p_x_route_efct_tbl(i).MC_HEADER_ID );
3000: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : before insert p_x_route_efct_tbl(i).object_version_number ' || p_x_route_efct_tbl(i).object_version_number);
3001: END IF;
3002: -- Insert the record
3003: p_x_route_efct_tbl(i).object_version_number := 1;
3004:

Line 3070: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : after DML p_object_id ' || p_object_id );

3066: p_x_route_efct_tbl(i).attribute15
3067: ) RETURNING route_effectivity_id INTO l_route_effectivitiy_id ;
3068:
3069: IF G_DEBUG = 'Y' THEN
3070: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : after DML p_object_id ' || p_object_id );
3071: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : after insert p_x_route_efct_tbl(i).INVENTORY_MASTER_ORG_ID ' || p_x_route_efct_tbl(i).INVENTORY_MASTER_ORG_ID );
3072: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : after insert p_x_route_efct_tbl(i).MC_ID ' || p_x_route_efct_tbl(i).MC_ID );
3073: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : after insert p_x_route_efct_tbl(i).MC_HEADER_ID ' || p_x_route_efct_tbl(i).MC_HEADER_ID );
3074: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : after insert p_x_route_efct_tbl(i).object_version_number ' || p_x_route_efct_tbl(i).object_version_number);

Line 3071: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : after insert p_x_route_efct_tbl(i).INVENTORY_MASTER_ORG_ID ' || p_x_route_efct_tbl(i).INVENTORY_MASTER_ORG_ID );

3067: ) RETURNING route_effectivity_id INTO l_route_effectivitiy_id ;
3068:
3069: IF G_DEBUG = 'Y' THEN
3070: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : after DML p_object_id ' || p_object_id );
3071: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : after insert p_x_route_efct_tbl(i).INVENTORY_MASTER_ORG_ID ' || p_x_route_efct_tbl(i).INVENTORY_MASTER_ORG_ID );
3072: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : after insert p_x_route_efct_tbl(i).MC_ID ' || p_x_route_efct_tbl(i).MC_ID );
3073: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : after insert p_x_route_efct_tbl(i).MC_HEADER_ID ' || p_x_route_efct_tbl(i).MC_HEADER_ID );
3074: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : after insert p_x_route_efct_tbl(i).object_version_number ' || p_x_route_efct_tbl(i).object_version_number);
3075: END IF;

Line 3072: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : after insert p_x_route_efct_tbl(i).MC_ID ' || p_x_route_efct_tbl(i).MC_ID );

3068:
3069: IF G_DEBUG = 'Y' THEN
3070: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : after DML p_object_id ' || p_object_id );
3071: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : after insert p_x_route_efct_tbl(i).INVENTORY_MASTER_ORG_ID ' || p_x_route_efct_tbl(i).INVENTORY_MASTER_ORG_ID );
3072: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : after insert p_x_route_efct_tbl(i).MC_ID ' || p_x_route_efct_tbl(i).MC_ID );
3073: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : after insert p_x_route_efct_tbl(i).MC_HEADER_ID ' || p_x_route_efct_tbl(i).MC_HEADER_ID );
3074: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : after insert p_x_route_efct_tbl(i).object_version_number ' || p_x_route_efct_tbl(i).object_version_number);
3075: END IF;
3076:

Line 3073: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : after insert p_x_route_efct_tbl(i).MC_HEADER_ID ' || p_x_route_efct_tbl(i).MC_HEADER_ID );

3069: IF G_DEBUG = 'Y' THEN
3070: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : after DML p_object_id ' || p_object_id );
3071: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : after insert p_x_route_efct_tbl(i).INVENTORY_MASTER_ORG_ID ' || p_x_route_efct_tbl(i).INVENTORY_MASTER_ORG_ID );
3072: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : after insert p_x_route_efct_tbl(i).MC_ID ' || p_x_route_efct_tbl(i).MC_ID );
3073: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : after insert p_x_route_efct_tbl(i).MC_HEADER_ID ' || p_x_route_efct_tbl(i).MC_HEADER_ID );
3074: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : after insert p_x_route_efct_tbl(i).object_version_number ' || p_x_route_efct_tbl(i).object_version_number);
3075: END IF;
3076:
3077: -- Set OUT values

Line 3074: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : after insert p_x_route_efct_tbl(i).object_version_number ' || p_x_route_efct_tbl(i).object_version_number);

3070: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : after DML p_object_id ' || p_object_id );
3071: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : after insert p_x_route_efct_tbl(i).INVENTORY_MASTER_ORG_ID ' || p_x_route_efct_tbl(i).INVENTORY_MASTER_ORG_ID );
3072: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : after insert p_x_route_efct_tbl(i).MC_ID ' || p_x_route_efct_tbl(i).MC_ID );
3073: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : after insert p_x_route_efct_tbl(i).MC_HEADER_ID ' || p_x_route_efct_tbl(i).MC_HEADER_ID );
3074: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : after insert p_x_route_efct_tbl(i).object_version_number ' || p_x_route_efct_tbl(i).object_version_number);
3075: END IF;
3076:
3077: -- Set OUT values
3078: p_x_route_efct_tbl(i).route_effectivity_id := l_route_effectivitiy_id;

Line 3150: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME1 || ' : after DML operation' );

3146:
3147: END LOOP;
3148:
3149: IF G_DEBUG = 'Y' THEN
3150: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME1 || ' : after DML operation' );
3151: END IF;
3152:
3153: -- Get all the error messages from the previous steps (if any) and raise the appropriate Exception
3154: l_msg_count := FND_MSG_PUB.count_msg;

Line 3176: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME1 || ' : after validate_records' );

3172: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3173: END IF;
3174:
3175: IF G_DEBUG = 'Y' THEN
3176: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME1 || ' : after validate_records' );
3177: END IF;
3178:
3179: -- Perform the Commit (if requested)
3180: IF FND_API.to_boolean( p_commit ) THEN

Line 3194: AHL_DEBUG_PUB.disable_debug;

3190: );
3191:
3192: -- Disable debug (if enabled)
3193: IF G_DEBUG = 'Y' THEN
3194: AHL_DEBUG_PUB.disable_debug;
3195: END IF;
3196:
3197: EXCEPTION
3198: WHEN FND_API.G_EXC_ERROR THEN

Line 3210: AHL_DEBUG_PUB.disable_debug;

3206: );
3207:
3208: -- Disable debug (if enabled)
3209: IF G_DEBUG = 'Y' THEN
3210: AHL_DEBUG_PUB.disable_debug;
3211: END IF;
3212:
3213: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3214: ROLLBACK TO process_route_efcts;

Line 3225: AHL_DEBUG_PUB.disable_debug;

3221: );
3222:
3223: -- Disable debug (if enabled)
3224: IF G_DEBUG = 'Y' THEN
3225: AHL_DEBUG_PUB.disable_debug;
3226: END IF;
3227:
3228: WHEN OTHERS THEN
3229: ROLLBACK TO process_route_efcts;

Line 3249: AHL_DEBUG_PUB.disable_debug;

3245: );
3246:
3247: -- Disable debug (if enabled)
3248: IF G_DEBUG = 'Y' THEN
3249: AHL_DEBUG_PUB.disable_debug;
3250: END IF;
3251:
3252: END process_route_efcts;
3253: