DBA Data[Home] [Help]

APPS.AHL_RM_RT_OPER_PANEL_PVT dependencies on AHL_DEBUG_PUB

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

2: /* $Header: AHLVRAPB.pls 120.0.12000000.1 2007/10/18 13:45:11 adivenka noship $ */
3:
4: G_PKG_NAME VARCHAR2(30) := 'AHL_RM_RT_OPER_PANEL_PVT';
5: G_API_NAME1 VARCHAR2(30) := 'process_rt_oper_panel';
6: G_DEBUG VARCHAR2(1) := NVL(AHL_DEBUG_PUB.is_log_enabled,'N');
7:
8: -- constants for WHO Columns
9: G_LAST_UPDATE_DATE DATE := SYSDATE;
10: G_LAST_UPDATED_BY NUMBER(15) := FND_GLOBAL.user_id;

Line 621: AHL_DEBUG_PUB.enable_debug;

617: FND_MSG_PUB.initialize;
618: END IF;
619:
620: IF G_DEBUG = 'Y' THEN
621: AHL_DEBUG_PUB.enable_debug;
622: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME1 || ' : Begin API' );
623: END IF;
624:
625:

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

618: END IF;
619:
620: IF G_DEBUG = 'Y' THEN
621: AHL_DEBUG_PUB.enable_debug;
622: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME1 || ' : Begin API' );
623: END IF;
624:
625:
626: --This is to be added before calling validate_api_inputs()

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

693: END LOOP;
694: --END IF;
695:
696: IF G_DEBUG = 'Y' THEN
697: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME1 || ' : after convert_values_to_ids' );
698: END IF;
699:
700: -- Default rt_oper_panel attributes.
701: /* Removed as a part of public API cleanup in 11510+.

Line 715: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME1 || ' : after default_attributes' );

711: END IF;
712: */
713:
714: IF G_DEBUG = 'Y' THEN
715: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME1 || ' : after default_attributes' );
716: END IF;
717:
718: -- Validate all attributes (Item level validation)
719: -- Balaji removed p_validation_level check in 11510+ as a part of public api cleanup.

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

736: END LOOP;
737: --END IF;
738:
739: IF G_DEBUG = 'Y' THEN
740: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME1 || ' : after validate_attributes' );
741: END IF;
742:
743: -- Default missing and unchanged attributes.
744: FOR i IN 1..p_x_rt_oper_panel_tbl.count LOOP

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

755: END IF;
756: END LOOP;
757:
758: IF G_DEBUG = 'Y' THEN
759: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME1 || ' : after default_unchanged_attributes / default_missing_attributes' );
760: END IF;
761:
762: IF G_DEBUG='Y' THEN
763: AHL_DEBUG_PUB.debug( 'Starting updating parent route/operation');

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

759: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME1 || ' : after default_unchanged_attributes / default_missing_attributes' );
760: END IF;
761:
762: IF G_DEBUG='Y' THEN
763: AHL_DEBUG_PUB.debug( 'Starting updating parent route/operation');
764: END IF;
765:
766: IF ( p_association_type_code = 'OPERATION')
767: THEN

Line 769: AHL_DEBUG_PUB.debug( 'p_association_type_code = OPERATION');

765:
766: IF ( p_association_type_code = 'OPERATION')
767: THEN
768: IF G_DEBUG='Y' THEN
769: AHL_DEBUG_PUB.debug( 'p_association_type_code = OPERATION');
770: END IF;
771:
772: AHL_RM_ROUTE_UTIL.validate_operation_status
773: (

Line 800: AHL_DEBUG_PUB.debug( 'p_association_type_code = ROUTE');

796:
797: ELSIF ( p_association_type_code = 'ROUTE')
798: THEN
799: IF G_DEBUG='Y' THEN
800: AHL_DEBUG_PUB.debug( 'p_association_type_code = ROUTE');
801: END IF;
802: -- Check if the Route is existing and in Draft status
803: AHL_RM_ROUTE_UTIL.validate_route_status
804: (

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

993: END IF;
994: END LOOP;
995:
996: IF G_DEBUG = 'Y' THEN
997: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME1 || ' : after DML operation' );
998: END IF;
999:
1000: -- Get all the error messages from the previous steps (if any) and raise the appropriate Exception
1001: l_msg_count := FND_MSG_PUB.count_msg;

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

1019: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1020: END IF;
1021:
1022: IF G_DEBUG = 'Y' THEN
1023: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME1 || ' : after validate_records' );
1024: END IF;
1025:
1026: -- Perform the Commit (if requested)
1027: IF FND_API.to_boolean( p_commit ) THEN

Line 1041: AHL_DEBUG_PUB.disable_debug;

1037: );
1038:
1039: -- Disable debug (if enabled)
1040: IF G_DEBUG = 'Y' THEN
1041: AHL_DEBUG_PUB.disable_debug;
1042: END IF;
1043: EXCEPTION
1044: WHEN FND_API.G_EXC_ERROR THEN
1045: ROLLBACK TO process_rt_oper_panel_PVT;

Line 1056: AHL_DEBUG_PUB.disable_debug;

1052: );
1053:
1054: -- Disable debug (if enabled)
1055: IF G_DEBUG = 'Y' THEN
1056: AHL_DEBUG_PUB.disable_debug;
1057: END IF;
1058:
1059: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1060: ROLLBACK TO process_rt_oper_panel_PVT;

Line 1071: AHL_DEBUG_PUB.disable_debug;

1067: );
1068:
1069: -- Disable debug (if enabled)
1070: IF G_DEBUG = 'Y' THEN
1071: AHL_DEBUG_PUB.disable_debug;
1072: END IF;
1073:
1074: WHEN OTHERS THEN
1075: ROLLBACK TO process_rt_oper_panel_PVT;

Line 1095: AHL_DEBUG_PUB.disable_debug;

1091: );
1092:
1093: -- Disable debug (if enabled)
1094: IF G_DEBUG = 'Y' THEN
1095: AHL_DEBUG_PUB.disable_debug;
1096: END IF;
1097:
1098: END process_rt_oper_panel;
1099: