DBA Data[Home] [Help]

APPS.AHL_RM_OP_ROUTE_AS_PVT dependencies on AHL_DEBUG_PUB

Line 5: G_DEBUG VARCHAR2(1) := NVL(AHL_DEBUG_PUB.is_log_enabled,'N');

1: PACKAGE BODY AHL_RM_OP_ROUTE_AS_PVT AS
2: /* $Header: AHLVORMB.pls 120.1.12020000.2 2012/12/07 01:28:38 sareepar ship $ */
3: G_PKG_NAME VARCHAR2(30) := 'AHL_RM_OP_ROUTE_AS_PVT';
4: G_API_NAME VARCHAR2(30) := 'PROCESS_ROUTE_OPERATION_AS';
5: G_DEBUG VARCHAR2(1) := NVL(AHL_DEBUG_PUB.is_log_enabled,'N');
6:
7: -- constants for WHO Columns
8: -- Added by Prithwi as a part of Public API cleanup
9:

Line 765: AHL_DEBUG_PUB.enable_debug;

761: FND_MSG_PUB.initialize;
762: END IF;
763:
764: IF G_DEBUG = 'Y' THEN
765: AHL_DEBUG_PUB.enable_debug;
766: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : Begin API' );
767: END IF;
768:
769: -- This is to be added before calling validate_api_inputs()

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

762: END IF;
763:
764: IF G_DEBUG = 'Y' THEN
765: AHL_DEBUG_PUB.enable_debug;
766: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : Begin API' );
767: END IF;
768:
769: -- This is to be added before calling validate_api_inputs()
770: -- Validate Application Usage

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

873: END LOOP;
874:
875:
876: IF G_DEBUG = 'Y' THEN
877: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : after convert_values_to_ids' );
878: END IF;
879:
880: FOR i IN 1..p_x_route_operation_tbl.count LOOP
881: IF ( p_x_route_operation_tbl(i).dml_operation = 'C' ) THEN

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

910: END IF;
911:
912:
913: IF G_DEBUG = 'Y' THEN
914: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : after validate_attributes' );
915: END IF;
916:
917: -- Default missing and unchanged attributes.
918: FOR i IN 1..p_x_route_operation_tbl.count LOOP

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

929: END IF;
930: END LOOP;
931:
932: IF G_DEBUG = 'Y' THEN
933: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : after default_unchanged_attributes / default_missing_attributes' );
934: END IF;
935:
936: -- Perform cross attribute validation and missing attribute checks (Record level validation)
937:

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

954: END LOOP;
955:
956:
957: IF G_DEBUG = 'Y' THEN
958: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : after validate_record' );
959: END IF;
960:
961: -- Update route status from APPROVAL_REJECTED to DRAFT
962: OPEN get_route_status (p_route_id);

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

1172:
1173: END LOOP;
1174:
1175: IF G_DEBUG = 'Y' THEN
1176: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : after DML operation' );
1177: END IF;
1178:
1179: -- Get all the error messages from the previous steps (if any) and raise the appropriate Exception
1180: l_msg_count := FND_MSG_PUB.count_msg;

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

1199: END IF;
1200: */
1201:
1202: IF G_DEBUG = 'Y' THEN
1203: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : after validate_records ' || p_route_id );
1204: END IF;
1205:
1206: -- Perform the Commit (if requested)
1207: IF FND_API.to_boolean( p_commit ) THEN

Line 1221: AHL_DEBUG_PUB.disable_debug;

1217: );
1218:
1219: -- Disable debug (if enabled)
1220: IF G_DEBUG = 'Y' THEN
1221: AHL_DEBUG_PUB.disable_debug;
1222: END IF;
1223:
1224: EXCEPTION
1225:

Line 1238: AHL_DEBUG_PUB.disable_debug;

1234: );
1235:
1236: -- Disable debug (if enabled)
1237: IF G_DEBUG = 'Y' THEN
1238: AHL_DEBUG_PUB.disable_debug;
1239: END IF;
1240:
1241: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1242: ROLLBACK TO process_route_operation_pvt;

Line 1253: AHL_DEBUG_PUB.disable_debug;

1249: );
1250:
1251: -- Disable debug (if enabled)
1252: IF G_DEBUG = 'Y' THEN
1253: AHL_DEBUG_PUB.disable_debug;
1254: END IF;
1255:
1256: WHEN OTHERS THEN
1257: ROLLBACK TO process_route_operation_pvt;

Line 1277: AHL_DEBUG_PUB.disable_debug;

1273: );
1274:
1275: -- Disable debug (if enabled)
1276: IF G_DEBUG = 'Y' THEN
1277: AHL_DEBUG_PUB.disable_debug;
1278: END IF;
1279:
1280: END process_route_operation_as;
1281: